Energy consumption on excel

hazard7
2ndFloor.xlsx

Sheet1

Room sq ft Htg Load Clg Load Dsn Load (ton) cfm
Zone 1 Kitchen + bathroom 220.58507 8475.22 4784.74 0.3987283333 159.4913333333
Zone 2 Office + lobby 367.90785 14053.42 13067.41 1.0889508333 435.5803333333
Zone 3 2 Offices + conference room + hall 521.07 18633.31 22722.65 1.8935541667 757.4216666667
3.3812333333 1352.4933333333
Unit 4 ton

Sheet2

Description ID Type BTUh Cfm dp Assumed Length (ft) Velocity Diameter Register
Gallery A Duct 875 22.74 0.1 7 300 6
Galley B Duct 875 22.74 0.1 7 300 6
C Tee
Room D Duct 1801 23.39 0.1 5 395 7
E Branch 821 10.66 0.1 5 240 10 #683, 8x8
Stairs F Duct 2573 33.42 0.1 10 203 6
G Tee
Gallery H Duct 821 10.66 0.1 12 160 3
I Tee
Office 5 K Duct 2401 31.19 0.1 11 450 5
Office 4 L Duct 2324 30.18 0.1 11 450 5
Return 2500 0.05 550 15 12x12