Eng-Tips is the largest forum for Engineering Professionals on the Internet.

Members share and learn making Eng-Tips Forums the best source of engineering information on the Internet!

  • Congratulations JStephen on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL

Status
Not open for further replies.

fouttyw

Computer
Joined
Nov 22, 2006
Messages
1
Location
US
Does anyone have an excel spreadsheet that I can put in BTUs/and cubic feet of a room and it will tell me the AC size I need.
 
No. Such a program doesn't really exist.

You need to add windows (type and orientation), walls, roof, floor, interal gains: people, lights, equipment.

Try searching for 'load estimating software'. There are some less expensive software packages out there.

Try:

 
If you know the BTU's, you know the size AC you need.
 
Twenty years ago we did hand load calculations using the method prescribed in the ASHRAE manual. That avenue is still open. You need to figure all the surface areas of wall, window, roof,and floor along with their respective U values and solar heat gain factors. A spread sheet program would make the process somewhat less laborious.

You also need to know how many people, how much lighting, any miscellaneous heat loads such as cooking, computers, motors, etc.

Don't forget to add in heat or cooling of required outside ventilation air as well as unwanted infiltration.

It is much easier to use computer software such as Carrier E-20.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top