Network equipment's power and cooling loads/requirements

looking to create a spreadsheet that basically can calculate a cabinet power consumption, heat dissipation and cooling load. cabinets may vary "teleco ,network, server, Access, AV, security, and user defined". network equipment's can be switch, routers, firewalls, WAPs , servers ,WLC in a different vendor environment. this could be a datacenter or