{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","Energy","Chiller","Pump","Financials","InfoText"],"not_rendered":{"charts":10,"images":11,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[24,11,24,12],[24,9,24,10],[24,3,24,4],[22,1,22,9],[45,1,45,5],[24,5,24,6],[29,7,29,8],[28,7,28,8],[27,7,27,8],[26,7,26,8],[25,7,25,8],[24,7,24,8],[26,1,26,2],[27,11,27,12],[32,11,32,12],[31,11,31,12],[30,5,30,6],[30,3,30,4],[28,3,28,4],[27,3,27,4],[30,1,30,2],[29,1,29,2],[28,1,28,2],[27,1,27,2],[16,1,16,9],[17,1,17,9],[50,1,50,9],[51,1,51,9],[52,1,52,9],[49,1,49,9],[41,1,41,9],[42,1,42,9],[43,1,43,9],[25,1,25,2],[24,1,24,2],[30,7,30,8],[46,1,46,5],[47,1,47,5],[27,5,27,6],[28,5,28,6],[31,7,31,8],[32,7,32,8],[31,9,31,10],[32,9,32,10],[55,1,58,13],[31,1,32,6],[34,1,34,9],[35,1,35,9],[36,1,36,9],[37,1,37,9],[30,11,30,12],[30,9,30,10],[29,11,29,12],[28,11,28,12],[29,9,29,10],[28,9,28,10],[27,9,27,10],[26,11,26,12],[26,5,26,6],[29,3,29,4],[25,11,25,12],[26,3,26,4],[25,3,25,4],[25,9,25,10],[26,9,26,10],[25,5,25,6],[29,5,29,6],[14,1,14,9],[15,1,15,9],[10,1,10,9],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,13],[6,5,6,13],[7,5,7,13],[11,1,11,9],[12,1,12,9],[13,1,13,9]]}
[]
[]
[]
[]
[]
[]
[null,"Project",null,null,null,"Enter Project Name"]
[null,"Information"]
[null,"Climate Region",null,null,null,"North East",null,"Chiller Cooling",null,"Water Cooled",null,"Plant Design",null,"Primary/Secondary"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Value",null,"Unit"]
[null,"Electricity Cost (Average)",null,null,null,null,null,null,null,null,null,0.1701,null,"$/kWh"]
[null,"Chilled Water Plant Load (Design Cooling Load)",null,null,null,null,null,null,null,null,null,1791,null,"tons"]
[null,"Number Of Chillers",null,null,null,null,null,null,null,null,null,2,null,"pcs."]
[null,"Operating Hours / Day",null,null,null,null,null,null,null,null,null,12,null,"hours"]
[null,"Operating Days / Week",null,null,null,null,null,null,null,null,null,5,null,"days"]
[null,"Chiller Design Integrated Part Load Value (IPLV)",null,null,null,null,null,null,null,null,null,0.6,null,"kW/ton"]
[null,{"$f":"IF($N$9=Chiller!$L$11,\"Actual Secondary Pump Head (Design)\",\"Actual Primary Pump Head (Design)\")","v":"Actual Secondary Pump Head (Design)"},null,null,null,null,null,null,null,null,null,135,null,"ft."]
[null,"Minimum Distribution Pump Flow Percentage",null,null,null,null,null,null,null,null,null,30,null,"%"]
[null,"Pump, VFD, Motor Efficiency (Average)",null,null,null,null,null,null,null,null,null,65,null,"%"]
[null,"Design Delta T of distribution system",null,null,null,null,null,null,null,null,null,14,null,"°F"]
[null,"Actual Delta T (Prior to Energy Valve Installation)",null,null,null,null,null,null,null,null,null,11,null,"°F"]
[null,"Future Delta T (Energy Valve Delta T Manager Setting)",null,null,null,null,null,null,null,null,null,14,null,"°F"]
[]
[null,"Delta-T [°F]",null,"Avg [GPM]",null,"Avg [Tons]",null,"Pumping Cost",null,"    Chiller Cost",null,"     Total Cost",null,"Energy [kWh]"]
[null,{"$f":"ROUND(IF($L$22-2<=0,$L$22,$L$22-($B$28-$B27)),0)","v":10},null,{"$f":"+Pump!I23","v":2505.3531428571432},null,{"$f":"+Chiller!J20","v":1461.4560000000001},null,{"$f":"Pump!I21","v":37110.299917062417},null,{"$f":"Chiller!J19","v":96052.450205047557},null,{"$f":"J26+H26","v":133162.75012210998},null,{"$f":"L26/$L$12","v":782849.79495655489}]
[null,{"$f":"L22","v":11},null,{"$f":"+Pump!I32","v":2411.5698701298702},null,{"$f":"+Chiller!J29","v":1406.7490909090909},null,{"$f":"Pump!I30","v":34259.162883299898},null,{"$f":"Chiller!J28","v":94006.47469892088},null,128265.63758222078,null,754060.18566855253]
[null,{"$f":"ROUND(QUOTIENT($L$23-$L$22,3)+B27,0)","v":12},null,{"$f":"+Pump!I41","v":2251.542857142857},null,{"$f":"+Chiller!J38","v":1313.4},null,{"$f":"Pump!I39","v":28097.893543305589},null,{"$f":"Chiller!J37","v":87247.246335993594},null,115345.13987929918,null,678101.93932568596]
[null,{"$f":"ROUND(QUOTIENT($L$23-$L$22,3)+B28,0)","v":13},null,{"$f":"+Pump!I50","v":2097.2413186813187},null,{"$f":"+Chiller!J47","v":1223.3907692307691},null,{"$f":"+Pump!I48","v":22898.370981622229},null,{"$f":"Chiller!J46","v":83881.004584460374},null,106779.3755660826,null,627744.71232264896]
[null,{"$f":"ROUND(IF(L23<=L21,L23,L21),0)","v":14},null,{"$f":"+Pump!I59","v":1964.982857142857},null,{"$f":"+Chiller!J56","v":1146.24},null,{"$f":"+Pump!I57","v":19071.233870300581},null,{"$f":"Chiller!J55","v":80995.654511717643},null,100066.88838201822,null,588282.70653743809]
[null,{"$f":"ROUND(IF(L21>L23,L21,IF(L23>L21,L23,L23+(B30-B29))),0)","v":15},null,{"$f":"+Pump!I68","v":1840.1245714285715},null,{"$f":"+Chiller!J65","v":1073.4060000000002},null,{"$f":"+Pump!I66","v":15665.690385352596},null,{"$f":"Chiller!J64","v":78271.746645425956},null,93937.437030778558,null,552248.30705925077]
[null,{"$f":"CONCATENATE(\"Annual Energy Savings for \nchanging Delta T from \",L22,\" to \",L23)","v":"Annual Energy Savings for \nchanging Delta T from 11 to 14"},null,null,null,null,null,{"$f":"+H33/H27","v":0.44332458048479878},null,{"$f":"+J33/J27","v":0.13840344751649952},null,{"$f":"+L33/L27","v":0.21984648212680194},null,"%"]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($L$22,$B$26:$N$31,7)-VLOOKUP($L$23,$B$26:$N$31,7)","v":15187.929012999317},null,{"$f":"VLOOKUP($L$22,$B$26:$N$31,9)-VLOOKUP($L$23,$B$26:$N$31,9)","v":13010.820187203237},null,{"$f":"VLOOKUP($L$22,$B$26:$N$31,11)-VLOOKUP($L$23,$B$26:$N$31,11)","v":28198.749200202554},null,"$"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Value",null,"Unit"]
[null,"Cooling Tower Water treatment chemicals savings (reduced runtime)",null,null,null,null,null,null,null,null,null,600,null,"$/Year"]
[null,"Reduced runtime of lag chillers, extending life of chillers, pumps",null,null,null,null,null,null,null,null,null,0,null,"$/Year"]
[null,"Allowing additional cooling loads (GPM) to be added w/o upsizing dist. Pumps",null,null,null,null,null,null,null,null,null,0,null,"$/Year"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Value",null,"Unit"]
[null,"Incremental Investment for Energy Valves",null,null,null,null,null,null,null,null,null,290000,null,"$"]
[null,"Discount Rate",null,null,null,null,null,null,null,null,null,10,null,"%"]
[null,"Annual Inflation Rate on Energy Costs",null,null,null,null,null,null,null,null,null,3,null,"%"]
[]
[null,"Investment Horizon",null,null,null,null,null,"5 years",null,"10 years",null,"15 years",null,"20 years"]
[null,"Savings-Investment Ratio (SIR)",null,null,null,null,null,{"$f":"+Financials!G45","v":0.39748233392749688},null,{"$f":"+Financials!L45","v":0.68359726939166798},null,{"$f":"+Financials!Q45","v":0.88954794771942203},null,{"$f":"+Financials!V45","v":1.0377949514448657}]
[null,"Net Present Value (NPV)",null,null,null,null,null,{"$f":"+Financials!$G$40","v":-174730.1231610259},null,{"$f":"+Financials!$L$40","v":-91756.791876416275},null,{"$f":"+Financials!$Q$40","v":-32031.095161367615},null,{"$f":"+Financials!$V$40","v":10960.535919011047}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Value",null,"Unit"]
[null,"Annual Carbon Dioxide Avoided",null,null,null,null,null,null,null,null,null,{"$f":"L33/L12*1.555","v":257783.98004888283},null,"pounds"]
[null,"Number of Tree Seedlings Grown for 10 Years",null,null,null,null,null,null,null,null,null,{"$f":"L51/133.47","v":1931.400165197294},null,"tree seedlings"]
[null,"Equivalent to Number of Houses' Annual Electricity Use",null,null,null,null,null,null,null,null,null,{"$f":"(L33/L12)/11880","v":13.954333260194813},null,"homes"]
[]
[]
[null,"Copyright by BELIMO Aircontrols (USA), Inc., Danbury, CT, 2014-2017. This is an estimating tool. Results are dependent on the accuracy of input values and specific plant details. For more accurate results, additional plant data and complex modeling software is necessary. In order to better analyze an existing plant Belimo recommends installing 3 Energy Valves at strategic locations in order to obtain actual measured data."]
[]
[]
[]
[null,"V.2021.1.02"]

{"sheet":"Energy","index":1,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,1,21,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[34,1,34,5],[16,1,16,3],[32,1,32,3],[30,1,30,3],[29,1,29,3],[28,1,28,3],[27,1,27,3],[26,1,26,3],[20,1,20,3],[25,1,25,3],[24,1,24,3],[23,1,23,3],[22,1,22,3]]}
[]
[]
[]
[]
[null,"Operating Hours / Day",null,{"$f":"Home!L15","v":12},"hours",null,"Editable Field"]
[null,"Operating Days / Week",null,{"$f":"Home!L16","v":5},"days",null,"Label"]
[null,"Operating Weeks/Year",null,52,"weeks"]
[null,"Annual Operating Hours",null,{"$f":"(D5*D6)*D7*G35","v":2748.2988204456096},"hours","(adjusted for climate region)"]
[]
[null,"Point","Bin","Load","% of Operating Time","Operating Hours","Tons"]
[null,"A","Design",1,0.05,{"$f":"$D$8*E11","v":137.41494102228049},{"$f":"D11*Home!$L$13","v":1791}]
[null,"B","Peak",0.8,0.4,{"$f":"$D$8*E12","v":1099.3195281782439},{"$f":"D12*Home!$L$13","v":1432.8000000000002}]
[null,"C","Mid",0.6,0.3,{"$f":"$D$8*E13","v":824.48964613368287},{"$f":"D13*Home!$L$13","v":1074.5999999999999}]
[null,"D","Partial",0.4,0.15,{"$f":"$D$8*E14","v":412.24482306684143},{"$f":"D14*Home!$L$13","v":716.40000000000009}]
[null,"E","Low",0.2,0.1,274.82988204456097,{"$f":"D15*Home!$L$13","v":358.20000000000005}]
[null,"F","Min",0.1,{"$f":"1-SUM(E11:E15)","v":0},{"$f":"$D$8*E16","v":0},{"$f":"D16*Home!$L$13","v":179.10000000000002}]
[null,null,null,null,null,{"$f":"SUM(F11:F16)","v":2748.2988204456101}]
[]
[]
[null,null,null,null,"Cooling Degree Days","Humidity Adjustment","Multiplier"]
[null,"Climate Region"]
[null,"North East",null,null,1034,0.3,{"$f":"E22/$E$33*(1+F22)","v":0.88086500655307998}]
[null,"Central",null,null,1090,0.3,{"$f":"E23/$E$33*(1+F23)","v":0.9285714285714286}]
[null,"East North Central",null,null,975,0.3,0.83060288335517696]
[null,"West North Central",null,null,1123,0.15,0.84629750982961982]
[null,"South East",null,null,2264,0.3,1.92870249017038]
[null,"South",null,null,2004,0.3,1.7072083879423328]
[null,"South West ",null,null,2750,0.05,1.8922018348623852]
[null,"Mountain",null,null,1450,0.05,0.99770642201834869]
[null,"North West",null,null,720,0.05,0.49541284403669728]
[null,"West  ",null,null,1850,0.05,1.272935779816514]
[null,"Custom Region",null,null,800,1E-3,0.52477064220183478]
[null,"Average US",null,null,{"$f":"SUM(E22:E31)/10","v":1526},{"$f":"SUM(F22:F31)/10","v":0.185},1.1850000000000001]
[]
[null,"Selected Value     ",null,null,null,null,{"$f":"VLOOKUP(Home!F9,B:G,6,FALSE)","v":0.88086500655307998}]

{"sheet":"Chiller","index":2,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[11,1,11,4]]}
[null,null,null,null,null,null,null,null,null,null,null,"Editable Field"]
[null,null,null,null,null,null,null,null,null,null,null,"Label"]
[]
[]
[null,"Aggregation of Energy Consumption",null,null,null,"[kW/ton]","Flow [GPM]","Head [Ft]","Power [kW]","Ratio"]
[null,"KW1 Compressor",null,null,null,{"$f":"Home!L17","v":0.6},null,null,{"$f":"Home!$L$13*F6","v":1074.5999999999999},{"$f":"I6/$I$12","v":0.8498321017968492}]
[null,{"$f":"IF(Home!N9=$L$11,\"KW2 Constant Speed Primary Pumps (each)\",\"\")","v":"KW2 Constant Speed Primary Pumps (each)"},null,null,null,null,{"$f":"IF(Home!$N$9=$L$11,Home!L13*12000/(Home!L14*500*Home!L21),0)","v":1535.1428571428571},26,{"$f":"0.746 * G7*H7/(3960*Home!$L$20/100)","v":11.567844155844156},{"$f":"I7/$I$12","v":9.1482647610454486E-3}]
[null,{"$f":"IF(Home!J9=$M$11,\"KW3 Condenser Pumps (each)\",\"\")","v":"KW3 Condenser Pumps (each)"},null,null,null,null,{"$f":"IF(Home!J9=M$11,3*Home!L13/Home!L14,\"-\")","v":2686.5},45,{"$f":"IF(Home!J9=$M$11,G8*H8/(3960*Home!$L$20/100)*0.746,0)","v":35.03722027972028},2.7708686535858812E-2]
[null,{"$f":"IF(Home!J9=$M$11,\"KW4 Cooling Tower Fans (all)\",\"\")","v":"KW4 Cooling Tower Fans (all)"},null,null,null,0.08,null,null,{"$f":"IF(Home!$J$9=$M$11,Home!$L$13*F9,0)","v":143.28},0.11331094690624657]
[null,"KW5 Chiller Controls",null,null,null,0,null,null,{"$f":"Home!$L$13*F10","v":0},0,null,"Chiller Plant Piping","Chiller Cooling"]
[null,"KW6 Transmission Oil Pump and Heater",null,null,null,0,null,null,{"$f":"Home!$L$13*F11","v":0},0,null,"Primary/Secondary","Water Cooled"]
[null,"Total Chiller Plant Energy Consumption",null,null,null,{"$f":"+$F$6+$F$10+$F$11+IF(Home!N9=$L$11,$F$7,0)+IF(Home!J9=$M$11,$F$8+$F$9,0)","v":0.67999999999999994},null,null,{"$f":"SUM(I6:I11)","v":1264.4850644355643},{"$f":"F12/$F$12","v":1},null,"Variable Primary","Air Cooled"]
[]
[null,"Chiller Plant Design Primary loop Delta T",null,null,{"$f":"Home!L21","v":14},null,null,null,null,null,null,null,null,"Actual Delta T Energy Usage","Actual %","Future Delta T Energy Usage","Future %"]
[null,"Design Chiller Primary loop GPM=",null,null,{"$f":"G7*Home!L14","v":3070.2857142857142},null,null,null,null,null,null,null,"Chiller",{"$f":"VLOOKUP(Home!$L$22,Home!$B$26:$K$31,7)*$J6","v":29114.536398915356},{"$f":"+N15/$N$23*100","v":95.39092450290768},{"$f":"VLOOKUP(Home!$L$23,Home!$B$26:$K$31,7)*$J6","v":16207.346763856802},{"$f":"+P15/$N$23*100","v":53.101782915599017}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"-\",$M$15,\"-\",B6)","v":"-Chiller-KW1 Compressor"},{"$f":"+$N$15*$J6","v":24742.467660731105},81.0662698626506,{"$f":"+$P$15*$J6","v":13773.523564878788},{"$f":"+P16/$P$23*100","v":79.369894836758505}]
[null,"Chiller Energy Usage at Delta T [F]:",null,null,null,{"$f":"+Pump!F19","v":10},null,null,null,null,null,null,{"$f":"IF(Home!$N$9=$L$11,CONCATENATE(\"-\",$M$15,\"-\",B7),\"\")","v":"-Chiller-KW2 Constant Speed Primary Pumps (each)"},{"$f":"+$N$15*IF(Home!$N$9=$L$11,$J7,0)","v":266.34748737237243},0.8726614331534972,{"$f":"+$P$15*IF(Home!$N$9=$L$11,$J7,0)","v":148.26909926983518},0.85440031094115243]
[null,"Load [%]","Time [%]","Time [h/yr]","Flow [GPM]","Tons","Chillers On","Power [kW]",null,null,"LWT Plant",null,{"$f":"IF(Home!$J$9=$M$11,CONCATENATE(\"-\",$M$15,\"-\",B8),\"\")","v":"-Chiller-KW3 Condenser Pumps (each)"},{"$f":"+$N$15*IF(Home!$J$9=$M$11,$J8,0)","v":806.72556271439726},2.6431572254168425,{"$f":"+$P$15*IF(Home!$J$9=$M$11,$J8,0)","v":449.08429105767385},2.5878470956390673]
[null,{"$f":"Energy!$D$11","v":1},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C19*0.01","v":137.41494102228052},{"$f":"+Pump!E21","v":3070.2857142857142},{"$f":"IF(+E19*$E$14/24>(Home!$L$13), Home!$L$13,(+E19*$E$14/24))","v":1791},{"$f":"ROUNDUP(+IF(E19/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E19/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G19*($I$7+$I$8)+($F$9)*F19+($F$10+$F$11)*G19","v":236.49012887112889},"Power Costs",{"$f":"J22*Home!$L$12","v":96052.450205047557},{"$f":"IF(E19>G19*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"},null,{"$f":"IF(Home!$J$9=$M$11,CONCATENATE(\"-\",$M$15,\"-\",B9),\"\")","v":"-Chiller-KW4 Cooling Tower Fans (all)"},{"$f":"+$N$15*IF(Home!$J$9=$M$11,J9,0)","v":3298.995688097481},10.808835981686746,{"$f":"+$P$15*IF(Home!$J$9=$M$11,J9,0)","v":1836.4698086505052},10.582652644901136]
[null,{"$f":"Energy!$D$12","v":0.8},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C20*0.01","v":1099.3195281782441},{"$f":"+Pump!E22","v":3070.2857142857142},{"$f":"IF(+E20*$E$14/24>(Home!$L$13), Home!$L$13,(+E20*$E$14/24))","v":1791},{"$f":"ROUNDUP(+IF(E20/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E20/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G20*($I$7+$I$8)+$F$9*F20+($F$10+$F$11)*G20","v":236.49012887112889},"Avg Tonage",{"$f":"+((F19*D19)+(F20*D20)+(F21*D21)+(F22*D22)+(F23*D23)+(F24*D24))/Energy!$F$17","v":1461.4560000000001},{"$f":"IF(E20>G20*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"},null,{"$f":"CONCATENATE(\"-\",$M$15,\"-\",B10)","v":"-Chiller-KW5 Chiller Controls"},{"$f":"+$N$15*J10","v":0},0,{"$f":"+$P$15*J10","v":0},0]
[null,{"$f":"Energy!$D$13","v":0.6},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C21*0.01","v":824.48964613368298},{"$f":"+Pump!E23","v":2579.04},{"$f":"IF(+E21*$E$14/24>(Home!$L$13), Home!$L$13,(+E21*$E$14/24))","v":1504.4399999999998},{"$f":"ROUNDUP(+IF(E21/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E21/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G21*($I$7+$I$8)+$F$9*F21+($F$10+$F$11)*G21","v":213.56532887112886},"Avg. Power [kW]",{"$f":"AVERAGE(H19:H24)","v":173.19510739260738},{"$f":"IF(E21>G21*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"},null,{"$f":"CONCATENATE(\"-\",$M$15,\"-\",B11)","v":"-Chiller-KW6 Transmission Oil Pump and Heater"},{"$f":"+$N$15*J11","v":0},0,{"$f":"+$P$15*J11","v":0},0]
[null,{"$f":"Energy!$D$14","v":0.4},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C22*0.01","v":412.24482306684149},{"$f":"+Pump!E24","v":1719.36},{"$f":"IF(+E22*$E$14/24>(Home!$L$13), Home!$L$13,(+E22*$E$14/24))","v":1002.9599999999999},{"$f":"ROUNDUP(+IF(E22/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E22/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G22*($I$7+$I$8)+$F$9*F22+($F$10+$F$11)*G22","v":173.44692887112888},"Energy [kWh/yr]",{"$f":"SUMPRODUCT(D19:D24,H19:H24)","v":564682.24694325426},{"$f":"IF(E22>G22*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"},null,"Pump",{"$f":"VLOOKUP(Home!$L$22,Home!$B$26:$K$31,5)","v":1406.7490909090909},4.6090754970923156,{"$f":"VLOOKUP(Home!$L$23,Home!$B$26:$K$31,5)","v":1146.24},6.6052051117601369]
[null,{"$f":"Energy!$D$15","v":0.2},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C23*0.01","v":274.82988204456103},{"$f":"+Pump!E25","v":921.08571428571418},{"$f":"IF(+E23*$E$14/24>(Home!$L$13), Home!$L$13,(+E23*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E23/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E23/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G23*($I$7+$I$8)+$F$9*F23+($F$10+$F$11)*G23","v":89.589064435564438},null,null,null,null,null,{"$f":"SUM(N16:N22)","v":30521.285489824448},100,{"$f":"SUM(P16:P22)","v":17353.586763856802},100]
[null,{"$f":"Energy!$D$16","v":0.1},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C24*0.01","v":0},{"$f":"+Pump!E26","v":921.08571428571418},{"$f":"IF(+E24*$E$14/24>(Home!$L$13), Home!$L$13,(+E24*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E24/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E24/(Pump!$E$8/Home!$L$14)),0)","v":1},89.589064435564438]
[]
[null,"Chiller Energy Usage at Delta T [F]:",null,null,null,{"$f":"+Pump!F28","v":11}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Tons",{"$f":"+$G$18","v":"Chillers On"},"Power [kW]"]
[null,{"$f":"Energy!$D$11","v":1},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C28*0.01","v":137.41494102228052},{"$f":"+Pump!E30","v":3070.2857142857142},{"$f":"IF(+E28*$E$14/24>(Home!$L$13), Home!$L$13,(+E28*$E$14/24))","v":1791},{"$f":"ROUNDUP(+IF(E28/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E28/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G28*($I$7+$I$8)+$F$9*F28+($F$10+$F$11)*G28","v":236.49012887112889},{"$f":"+I19","v":"Power Costs"},{"$f":"J31*Home!$L$12","v":94006.47469892088},{"$f":"IF(E28>G28*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$12","v":0.8},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C29*0.01","v":1099.3195281782441},{"$f":"+Pump!E31","v":3070.2857142857142},{"$f":"IF(+E29*$E$14/24>(Home!$L$13), Home!$L$13,(+E29*$E$14/24))","v":1791},{"$f":"ROUNDUP(+IF(E29/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E29/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G29*($I$7+$I$8)+$F$9*F29+($F$10+$F$11)*G29","v":236.49012887112889},{"$f":"+I20","v":"Avg Tonage"},{"$f":"+((F28*D28)+(F29*D29)+(F30*D30)+(F31*D31)+(F32*D32)+(F33*D33))/Energy!$F$17","v":1406.7490909090909},{"$f":"IF(E29>G29*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$13","v":0.6},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C30*0.01","v":824.48964613368298},{"$f":"+Pump!E32","v":2344.5818181818181},{"$f":"IF(+E30*$E$14/24>(Home!$L$13), Home!$L$13,(+E30*$E$14/24))","v":1367.6727272727273},{"$f":"ROUNDUP(+IF(E30/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E30/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G30*($I$7+$I$8)+$F$9*F30+($F$10+$F$11)*G30","v":202.62394705294707},{"$f":"I21","v":"Avg. Power [kW]"},{"$f":"AVERAGE(H28:H33)","v":170.15583466533465},{"$f":"IF(E30>G30*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$14","v":0.4},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C31*0.01","v":412.24482306684149},{"$f":"+Pump!E33","v":1563.0545454545454},{"$f":"IF(+E31*$E$14/24>(Home!$L$13), Home!$L$13,(+E31*$E$14/24))","v":911.78181818181804},{"$f":"ROUNDUP(+IF(E31/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E31/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G31*($I$7+$I$8)+$F$9*F31+($F$10+$F$11)*G31","v":166.1526743256743},{"$f":"+I22","v":"Energy [kWh/yr]"},{"$f":"SUMPRODUCT(D28:D33,H28:H33)","v":552654.17224527267},{"$f":"IF(E31>G31*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$15","v":0.2},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C32*0.01","v":274.82988204456103},{"$f":"+Pump!E34","v":921.08571428571418},{"$f":"IF(+E32*$E$14/24>(Home!$L$13), Home!$L$13,(+E32*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E32/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E32/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G32*($I$7+$I$8)+$F$9*F32+($F$10+$F$11)*G32","v":89.589064435564438}]
[null,{"$f":"Energy!$D$16","v":0.1},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C33*0.01","v":0},{"$f":"+Pump!E35","v":921.08571428571418},{"$f":"IF(+E33*$E$14/24>(Home!$L$13), Home!$L$13,(+E33*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E33/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E33/(Pump!$E$8/Home!$L$14)),0)","v":1},89.589064435564438]
[]
[null,"Chiller Energy Usage at Delta T [F]:",null,null,null,{"$f":"+Pump!F37","v":12}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Tons",{"$f":"+$G$18","v":"Chillers On"},"Power [kW]"]
[null,{"$f":"Energy!$D$11","v":1},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C37*0.01","v":137.41494102228052},{"$f":"+Pump!E39","v":3070.2857142857142},{"$f":"IF(+E37*$E$14/24>(Home!$L$13), Home!$L$13,(+E37*$E$14/24))","v":1791},{"$f":"ROUNDUP(+IF(E37/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E37/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G37*($I$7+$I$8)+$F$9*F37+($F$10+$F$11)*G37","v":236.49012887112889},{"$f":"+I19","v":"Power Costs"},{"$f":"J40*Home!$L$12","v":87247.246335993594},{"$f":"IF(E37>G37*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$12","v":0.8},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C38*0.01","v":1099.3195281782441},{"$f":"+Pump!E40","v":2865.6},{"$f":"IF(+E38*$E$14/24>(Home!$L$13), Home!$L$13,(+E38*$E$14/24))","v":1671.6000000000001},{"$f":"ROUNDUP(+IF(E38/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E38/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G38*($I$7+$I$8)+$F$9*F38+($F$10+$F$11)*G38","v":226.93812887112887},{"$f":"+I20","v":"Avg Tonage"},{"$f":"+((F37*D37)+(F38*D38)+(F39*D39)+(F40*D40)+(F41*D41)+(F42*D42))/Energy!$F$17","v":1313.4},{"$f":"IF(E38>G38*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$13","v":0.6},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C39*0.01","v":824.48964613368298},{"$f":"+Pump!E41","v":2149.1999999999998},{"$f":"IF(+E39*$E$14/24>(Home!$L$13), Home!$L$13,(+E39*$E$14/24))","v":1253.6999999999998},{"$f":"ROUNDUP(+IF(E39/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E39/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G39*($I$7+$I$8)+$F$9*F39+($F$10+$F$11)*G39","v":193.50612887112885},{"$f":"I21","v":"Avg. Power [kW]"},{"$f":"AVERAGE(H37:H42)","v":158.26359665334664},{"$f":"IF(E39>G39*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$14","v":0.4},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C40*0.01","v":412.24482306684149},{"$f":"+Pump!E42","v":1432.8},{"$f":"IF(+E40*$E$14/24>(Home!$L$13), Home!$L$13,(+E40*$E$14/24))","v":835.80000000000007},{"$f":"ROUNDUP(+IF(E40/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E40/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G40*($I$7+$I$8)+$F$9*F40+($F$10+$F$11)*G40","v":113.46906443556443},{"$f":"+I22","v":"Energy [kWh/yr]"},{"$f":"SUMPRODUCT(D37:D42,H37:H42)","v":512917.37998820457},{"$f":"IF(E40>G40*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$15","v":0.2},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C41*0.01","v":274.82988204456103},{"$f":"+Pump!E43","v":921.08571428571418},{"$f":"IF(+E41*$E$14/24>(Home!$L$13), Home!$L$13,(+E41*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E41/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E41/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G41*($I$7+$I$8)+$F$9*F41+($F$10+$F$11)*G41","v":89.589064435564438}]
[null,{"$f":"Energy!$D$16","v":0.1},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C42*0.01","v":0},{"$f":"+Pump!E44","v":921.08571428571418},{"$f":"IF(+E42*$E$14/24>(Home!$L$13), Home!$L$13,(+E42*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E42/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E42/(Pump!$E$8/Home!$L$14)),0)","v":1},89.589064435564438]
[]
[null,"Chiller Energy Usage at Delta T [F]:",null,null,null,{"$f":"+Pump!F46","v":13}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Tons",{"$f":"+$G$18","v":"Chillers On"},"Power [kW]"]
[null,{"$f":"Energy!$D$11","v":1},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C46*0.01","v":137.41494102228052},{"$f":"+Pump!E48","v":3070.2857142857142},{"$f":"IF(+E46*$E$14/24>(Home!$L$13), Home!$L$13,(+E46*$E$14/24))","v":1791},{"$f":"ROUNDUP(+IF(E46/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E46/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G46*($I$7+$I$8)+$F$9*F46+($F$10+$F$11)*G46","v":236.49012887112889},{"$f":"+I19","v":"Power Costs"},{"$f":"J49*Home!$L$12","v":83881.004584460374},{"$f":"IF(E46>G46*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$12","v":0.8},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C47*0.01","v":1099.3195281782441},{"$f":"+Pump!E49","v":2645.1692307692306},{"$f":"IF(+E47*$E$14/24>(Home!$L$13), Home!$L$13,(+E47*$E$14/24))","v":1543.0153846153844},{"$f":"ROUNDUP(+IF(E47/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E47/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G47*($I$7+$I$8)+$F$9*F47+($F$10+$F$11)*G47","v":216.65135964035963},{"$f":"+I20","v":"Avg Tonage"},{"$f":"+((F46*D46)+(F47*D47)+(F48*D48)+(F49*D49)+(F50*D50)+(F51*D51))/Energy!$F$17","v":1223.3907692307691},{"$f":"IF(E47>G47*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$13","v":0.6},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C48*0.01","v":824.48964613368298},{"$f":"+Pump!E50","v":1983.876923076923},{"$f":"IF(+E48*$E$14/24>(Home!$L$13), Home!$L$13,(+E48*$E$14/24))","v":1157.2615384615385},{"$f":"ROUNDUP(+IF(E48/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E48/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G48*($I$7+$I$8)+$F$9*F48+($F$10+$F$11)*G48","v":185.79105194805197},{"$f":"I30","v":"Avg. Power [kW]"},{"$f":"AVERAGE(H46:H51)","v":154.4060581918082},{"$f":"IF(E48>G48*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$14","v":0.4},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C49*0.01","v":412.24482306684149},{"$f":"+Pump!E51","v":1322.5846153846153},{"$f":"IF(+E49*$E$14/24>(Home!$L$13), Home!$L$13,(+E49*$E$14/24))","v":771.5076923076922},{"$f":"ROUNDUP(+IF(E49/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E49/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G49*($I$7+$I$8)+$F$9*F49+($F$10+$F$11)*G49","v":108.32567982017981},{"$f":"+I22","v":"Energy [kWh/yr]"},{"$f":"SUMPRODUCT(D46:D51,H46:H51)","v":493127.59896802105},{"$f":"IF(E49>G49*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$15","v":0.2},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C50*0.01","v":274.82988204456103},{"$f":"+Pump!E52","v":921.08571428571418},{"$f":"IF(+E50*$E$14/24>(Home!$L$13), Home!$L$13,(+E50*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E50/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E50/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G50*($I$7+$I$8)+$F$9*F50+($F$10+$F$11)*G50","v":89.589064435564438}]
[null,{"$f":"Energy!$D$16","v":0.1},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C51*0.01","v":0},{"$f":"+Pump!E53","v":921.08571428571418},{"$f":"IF(+E51*$E$14/24>(Home!$L$13), Home!$L$13,(+E51*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E51/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E51/(Pump!$E$8/Home!$L$14)),0)","v":1},89.589064435564438]
[]
[null,"Chiller Energy Usage at Delta T [F]:",null,null,null,{"$f":"+Pump!F55","v":14}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Tons",{"$f":"+$G$18","v":"Chillers On"},"Power [kW]"]
[null,{"$f":"Energy!$D$11","v":1},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C55*0.01","v":137.41494102228052},{"$f":"+Pump!E57","v":3070.2857142857142},{"$f":"IF(+E55*$E$14/24>(Home!$L$13), Home!$L$13,(+E55*$E$14/24))","v":1791},{"$f":"ROUNDUP(+IF(E55/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E55/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G55*($I$7+$I$8)+$F$9*F55+($F$10+$F$11)*G55","v":236.49012887112889},{"$f":"+I19","v":"Power Costs"},{"$f":"J58*Home!$L$12","v":80995.654511717643},{"$f":"IF(E55>G55*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$12","v":0.8},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C56*0.01","v":1099.3195281782441},{"$f":"+Pump!E58","v":2456.2285714285713},{"$f":"IF(+E56*$E$14/24>(Home!$L$13), Home!$L$13,(+E56*$E$14/24))","v":1432.8},{"$f":"ROUNDUP(+IF(E56/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E56/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G56*($I$7+$I$8)+$F$9*F56+($F$10+$F$11)*G56","v":207.83412887112888},{"$f":"+I20","v":"Avg Tonage"},{"$f":"+((F55*D55)+(F56*D56)+(F57*D57)+(F58*D58)+(F59*D59)+(F60*D60))/Energy!$F$17","v":1146.24},{"$f":"IF(E56>G56*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$13","v":0.6},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C57*0.01","v":824.48964613368298},{"$f":"+Pump!E59","v":1842.1714285714286},{"$f":"IF(+E57*$E$14/24>(Home!$L$13), Home!$L$13,(+E57*$E$14/24))","v":1074.6000000000001},{"$f":"ROUNDUP(+IF(E57/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E57/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G57*($I$7+$I$8)+$F$9*F57+($F$10+$F$11)*G57","v":179.17812887112888},{"$f":"+I21","v":"Avg. Power [kW]"},{"$f":"AVERAGE(H55:H60)","v":151.09959665334665},{"$f":"IF(E57>G57*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$14","v":0.4},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C58*0.01","v":412.24482306684149},{"$f":"+Pump!E60","v":1228.1142857142856},{"$f":"IF(+E58*$E$14/24>(Home!$L$13), Home!$L$13,(+E58*$E$14/24))","v":716.4},{"$f":"ROUNDUP(+IF(E58/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E58/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G58*($I$7+$I$8)+$F$9*F58+($F$10+$F$11)*G58","v":103.91706443556444},{"$f":"+I22","v":"Energy [kWh/yr]"},{"$f":"SUMPRODUCT(D55:D60,H55:H60)","v":476164.92952214956},{"$f":"IF(E58>G58*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$15","v":0.2},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C59*0.01","v":274.82988204456103},{"$f":"+Pump!E61","v":921.08571428571418},{"$f":"IF(+E59*$E$14/24>(Home!$L$13), Home!$L$13,(+E59*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E59/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E59/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G59*($I$7+$I$8)+$F$9*F59+($F$10+$F$11)*G59","v":89.589064435564438}]
[null,{"$f":"Energy!$D$16","v":0.1},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C60*0.01","v":0},{"$f":"+Pump!E62","v":921.08571428571418},{"$f":"IF(+E60*$E$14/24>(Home!$L$13), Home!$L$13,(+E60*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E60/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E60/(Pump!$E$8/Home!$L$14)),0)","v":1},89.589064435564438]
[]
[null,"Chiller Energy Usage at Delta T [F]:",null,null,null,{"$f":"+Pump!F64","v":15}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Tons",{"$f":"+$G$18","v":"Chillers On"},"Power [kW]"]
[null,{"$f":"Energy!$D$11","v":1},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C64*0.01","v":137.41494102228052},{"$f":"+Pump!E66","v":2865.6},{"$f":"IF(+E64*$E$14/24>(Home!$L$13), Home!$L$13,(+E64*$E$14/24))","v":1671.6000000000001},{"$f":"ROUNDUP(+IF(E64/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E64/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G64*($I$7+$I$8)+$F$9*F64+($F$10+$F$11)*G64","v":226.93812887112887},{"$f":"+I19","v":"Power Costs"},{"$f":"J67*Home!$L$12","v":78271.746645425956},{"$f":"IF(E64>G64*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$12","v":0.8},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C65*0.01","v":1099.3195281782441},{"$f":"+Pump!E67","v":2292.48},{"$f":"IF(+E65*$E$14/24>(Home!$L$13), Home!$L$13,(+E65*$E$14/24))","v":1337.28},{"$f":"ROUNDUP(+IF(E65/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E65/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G65*($I$7+$I$8)+$F$9*F65+($F$10+$F$11)*G65","v":200.19252887112887},{"$f":"+I20","v":"Avg Tonage"},{"$f":"+((F64*D64)+(F65*D65)+(F66*D66)+(F67*D67)+(F68*D68)+(F69*D69))/Energy!$F$17","v":1073.4060000000002},{"$f":"IF(E65>G65*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$13","v":0.6},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C66*0.01","v":824.48964613368298},{"$f":"+Pump!E68","v":1719.36},{"$f":"IF(+E66*$E$14/24>(Home!$L$13), Home!$L$13,(+E66*$E$14/24))","v":1002.9599999999999},{"$f":"ROUNDUP(+IF(E66/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E66/(Pump!$E$8/Home!$L$14)),0)","v":2},{"$f":"G66*($I$7+$I$8)+$F$9*F66+($F$10+$F$11)*G66","v":173.44692887112888},{"$f":"+I21","v":"Avg. Power [kW]"},{"$f":"AVERAGE(H64:H69)","v":146.64199665334664},{"$f":"IF(E66>G66*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$14","v":0.4},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C67*0.01","v":412.24482306684149},{"$f":"+Pump!E69","v":1146.24},{"$f":"IF(+E67*$E$14/24>(Home!$L$13), Home!$L$13,(+E67*$E$14/24))","v":668.64},{"$f":"ROUNDUP(+IF(E67/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E67/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G67*($I$7+$I$8)+$F$9*F67+($F$10+$F$11)*G67","v":100.09626443556444},{"$f":"+I22","v":"Energy [kWh/yr]"},{"$f":"SUMPRODUCT(D64:D69,H64:H69)","v":460151.36181908264},{"$f":"IF(E67>G67*Chiller!$G$7,\"LWT Loss\",\"Normal\")","v":"Normal"}]
[null,{"$f":"Energy!$D$15","v":0.2},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C68*0.01","v":274.82988204456103},{"$f":"+Pump!E70","v":921.08571428571418},{"$f":"IF(+E68*$E$14/24>(Home!$L$13), Home!$L$13,(+E68*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E68/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E68/(Pump!$E$8/Home!$L$14)),0)","v":1},{"$f":"G68*($I$7+$I$8)+$F$9*F68+($F$10+$F$11)*G68","v":89.589064435564438}]
[null,{"$f":"Energy!$D$16","v":0.1},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C69*0.01","v":0},{"$f":"+Pump!E71","v":921.08571428571418},{"$f":"IF(+E69*$E$14/24>(Home!$L$13), Home!$L$13,(+E69*$E$14/24))","v":537.29999999999995},{"$f":"ROUNDUP(+IF(E69/(Pump!$E$8/Home!$L$14)>Home!$L$14,Home!$L$14,E69/(Pump!$E$8/Home!$L$14)),0)","v":1},89.589064435564438]

{"sheet":"Pump","index":3,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[5,7,5,8]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Editable Field"]
[null,"Pump Design Factor",null,null,null,1,null,null,null,"Label"]
[null,"Design Chilled Water Distribution dT",null,null,null,{"$f":"+Home!$L$21","v":14}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Head [ft]","Power [HP]"]
[null,{"$f":"Energy!$D$11*100","v":100},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C8*0.01","v":137.41494102228052},{"$f":"+Home!$L$13*24/Home!$L$21","v":3070.2857142857142},{"$f":"+Home!L18","v":135},{"$f":"(E8*F8)/(3960*Home!$L$20/100)","v":161.02897102897103},"Pump costs",{"$f":"I11*Home!$L$12","v":19071.233870300581},null,{"$f":"B8*Home!$L$13*24/$F$6/100","v":3070.2857142857142}]
[null,{"$f":"Energy!$D$12*100","v":80},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C9*0.01","v":1099.3195281782441},{"$f":"+IF(($E$8*B9/100)<$E$17,$E$17,($E$8*B9/100))","v":2456.2285714285713},{"$f":"IF(($F$8*(E9/$E$8)^2)<$F$15,$F$15,($F$8*(E9/$E$8)^2))","v":86.399999999999991},{"$f":"(E9*F9)/(3960*Home!$L$20/100)","v":82.446833166833159},"Annual Gal.",{"$f":"SUMPRODUCT(E8:E13,D8:D13)*60","v":324021604.10889345},null,{"$f":"B9*Home!$L$13*24/$F$6/100","v":2456.2285714285713}]
[null,{"$f":"Energy!$D$13*100","v":60},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C10*0.01","v":824.48964613368298},{"$f":"+IF(($E$8*B10/100)<$E$17,$E$17,($E$8*B10/100))","v":1842.1714285714284},{"$f":"IF(($F$8*(E10/$E$8)^2)<$F$15,$F$15,($F$8*(E10/$E$8)^2))","v":48.6},{"$f":"(E10*F10)/(3960*Home!$L$20/100)","v":34.782257742257741},"Avg GPM",{"$f":"+I9/(60*Energy!$F$17)","v":1964.9828571428568},null,{"$f":"B10*Home!$L$13*24/$F$6/100","v":1842.1714285714288}]
[null,{"$f":"Energy!$D$14*100","v":40},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C11*0.01","v":412.24482306684149},{"$f":"+IF(($E$8*B11/100)<$E$17,$E$17,($E$8*B11/100))","v":1228.1142857142856},{"$f":"IF(($F$8*(E11/$E$8)^2)<$F$15,$F$15,($F$8*(E11/$E$8)^2))","v":30},{"$f":"(E11*F11)/(3960*Home!$L$20/100)","v":14.313686313686315},"Energy [kWh]",{"$f":"SUMPRODUCT(D8:D13,G8:G13)*0.746","v":112117.77701528855},null,{"$f":"B11*Home!$L$13*24/$F$6/100","v":1228.1142857142856}]
[null,{"$f":"Energy!$D$15*100","v":20},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C12*0.01","v":274.82988204456103},{"$f":"+IF(($E$8*B12/100)<$E$17,$E$17,($E$8*B12/100))","v":921.08571428571418},{"$f":"IF(($F$8*(E12/$E$8)^2)<$F$15,$F$15,($F$8*(E12/$E$8)^2))","v":30},{"$f":"(E12*F12)/(3960*Home!$L$20/100)","v":10.735264735264733},null,null,null,{"$f":"B12*Home!$L$13*24/$F$6/100","v":614.05714285714282}]
[null,{"$f":"Energy!$D$16*100","v":10},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C13*0.01","v":0},921.08571428571418,30,{"$f":"(E13*F13)/(3960*Home!$L$20/100)","v":10.735264735264733},null,null,null,{"$f":"B13*Home!$L$13*24/$F$6/100","v":307.02857142857141}]
[null," "," "," "]
[null,"Minimum Pump head",null," [ft] and Flow [GPM]",null,30,{"$f":"E8*Home!L19/100","v":921.08571428571418}]
[null,null,null,null,"Min. [GPM]","Head [ft]","Power [HP]","Power [kW]"]
[null,null,null,null,{"$f":"G15","v":921.08571428571418},{"$f":"+F15","v":30},{"$f":"(E17*F17)/(3960*Home!L20/100)","v":10.735264735264733},{"$f":"G17*0.746","v":8.0085074925074906}]
[]
[null,"Chilled Water Distribution Flow at Delta T [F]:",null,null,null,{"$f":"Home!B26","v":10}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Head [ft]","Power [HP]",null,"Pump costs"]
[null,{"$f":"Energy!$D$11*100","v":100},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C21*0.01","v":137.41494102228052},{"$f":"IF(Home!$L$13*B21*0.01*24/$F$19>$E$8*$F$5,$E$8*$F$5,Home!$L$13*B21*0.01*24/$F$19)","v":3070.2857142857142},{"$f":"IF(($F$8*(E21/$E$8)^2)<$F$15,$F$15,($F$8*(E21/$E$8)^2))","v":135},{"$f":"(E21*F21)/(3960*Home!$L$20/100)","v":161.02897102897103},"Pump costs",{"$f":"I24*Home!$L$12","v":37110.299917062417}]
[null,{"$f":"Energy!$D$12*100","v":80},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C22*0.01","v":1099.3195281782441},{"$f":"IF(IF(Home!$L$13*12000*B22/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B22/(100*500*$F$19))<$E$17,$E$17,IF(Home!$L$13*12000*B22/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B22/(100*500*$F$19)))","v":3070.2857142857142},{"$f":"IF(($F$8*(E22/$E$8)^2)<$F$15,$F$15,($F$8*(E22/$E$8)^2))","v":135},{"$f":"(E22*F22)/(3960*Home!$L$20/100)","v":161.02897102897103},"Annual Gal.",{"$f":"SUMPRODUCT(E21:E26,D21:D26)*60","v":413127545.23883927}]
[null,{"$f":"Energy!$D$13*100","v":60},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C23*0.01","v":824.48964613368298},{"$f":"IF(IF(Home!$L$13*12000*B23/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B23/(100*500*$F$19))<$E$17,$E$17,IF(Home!$L$13*12000*B23/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B23/(100*500*$F$19)))","v":2579.04},{"$f":"IF(($F$8*(E23/$E$8)^2)<$F$15,$F$15,($F$8*(E23/$E$8)^2))","v":95.255999999999986},{"$f":"(E23*F23)/(3960*Home!$L$20/100)","v":95.442515244755228},"Avg GPM",{"$f":"+I22/(60*Energy!$F$17)","v":2505.3531428571432}]
[null,{"$f":"Energy!$D$14*100","v":40},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C24*0.01","v":412.24482306684149},{"$f":"IF(IF(Home!$L$13*12000*B24/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B24/(100*500*$F$19))<$E$17,$E$17,IF(Home!$L$13*12000*B24/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B24/(100*500*$F$19)))","v":1719.36},{"$f":"IF(($F$8*(E24/$E$8)^2)<$F$15,$F$15,($F$8*(E24/$E$8)^2))","v":42.335999999999991},{"$f":"(E24*F24)/(3960*Home!$L$20/100)","v":28.279263776223768},"Energy [kWh]",{"$f":"SUMPRODUCT(D21:D26,G21:G26)*0.746","v":218167.54801330052}]
[null,{"$f":"Energy!$D$15*100","v":20},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C25*0.01","v":274.82988204456103},{"$f":"IF(IF(Home!$L$13*12000*B25/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B25/(100*500*$F$19))<$E$17,$E$17,IF(Home!$L$13*12000*B25/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B25/(100*500*$F$19)))","v":921.08571428571418},{"$f":"IF(($F$8*(E25/$E$8)^2)<$F$15,$F$15,($F$8*(E25/$E$8)^2))","v":30},{"$f":"(E25*F25)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null,{"$f":"Energy!$D$16*100","v":10},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C26*0.01","v":0},{"$f":"IF(IF(Home!$L$13*12000*B26/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B26/(100*500*$F$19))<$E$17,$E$17,IF(Home!$L$13*12000*B26/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B26/(100*500*$F$19)))","v":921.08571428571418},30,{"$f":"(E26*F26)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null," "," "," "]
[null,"Chilled Water Distribution Flow at Delta T [F]:",null,null,null,{"$f":"Home!B27","v":11}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Head [ft]","Power [HP]",null,"Pump costs"]
[null,{"$f":"Energy!$D$11*100","v":100},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C30*0.01","v":137.41494102228052},{"$f":"IF(Home!$L$13*B30*0.01*24/(F28)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*B30*0.01*24/(F28))","v":3070.2857142857142},{"$f":"IF(($F$8*(E30/$E$8)^2)<$F$15,$F$15,($F$8*(E30/$E$8)^2))","v":135},{"$f":"(E30*F30)/(3960*Home!$L$20/100)","v":161.02897102897103},"Pump costs",{"$f":"I33*Home!$L$12","v":34259.162883299898}]
[null,{"$f":"Energy!$D$12*100","v":80},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C31*0.01","v":1099.3195281782441},{"$f":"IF(IF(Home!$L$13*12000*B31/(100*500*$F$28)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B31/(100*500*$F$28))<$E$17,$E$17,IF(Home!$L$13*12000*B31/(100*500*$F$28)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B31/(100*500*$F$28)))","v":3070.2857142857142},{"$f":"IF(($F$8*(E31/$E$8)^2)<$F$15,$F$15,($F$8*(E31/$E$8)^2))","v":135},{"$f":"(E31*F31)/(3960*Home!$L$20/100)","v":161.02897102897103},"Annual Gal.",{"$f":"SUMPRODUCT(E30:E35,D30:D35)*60","v":397662877.7700057}]
[null,{"$f":"Energy!$D$13*100","v":60},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C32*0.01","v":824.48964613368298},{"$f":"IF(IF(Home!$L$13*12000*B32/(100*500*$F$28)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B32/(100*500*$F$28))<$E$17,$E$17,IF(Home!$L$13*12000*B32/(100*500*$F$28)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B32/(100*500*$F$28)))","v":2344.5818181818181},{"$f":"IF(($F$8*(E32/$E$8)^2)<$F$15,$F$15,($F$8*(E32/$E$8)^2))","v":78.723966942148763},{"$f":"(E32*F32)/(3960*Home!$L$20/100)","v":71.707374338659093},"Avg GPM",{"$f":"+I31/(60*Energy!$F$17)","v":2411.5698701298702}]
[null,{"$f":"Energy!$D$14*100","v":40},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C33*0.01","v":412.24482306684149},{"$f":"IF(IF(Home!$L$13*12000*B33/(100*500*$F$28)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B33/(100*500*$F$28))<$E$17,$E$17,IF(Home!$L$13*12000*B33/(100*500*$F$28)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B33/(100*500*$F$28)))","v":1563.0545454545454},{"$f":"IF(($F$8*(E33/$E$8)^2)<$F$15,$F$15,($F$8*(E33/$E$8)^2))","v":34.988429752066104},{"$f":"(E33*F33)/(3960*Home!$L$20/100)","v":21.246629433676759},"Energy [kWh]",{"$f":"SUMPRODUCT(D30:D35,G30:G35)*0.746","v":201406.01342327983}]
[null,{"$f":"Energy!$D$15*100","v":20},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C34*0.01","v":274.82988204456103},{"$f":"IF(IF(Home!$L$13*12000*B34/(100*500*$F$28)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B34/(100*500*$F$28))<$E$17,$E$17,IF(Home!$L$13*12000*B34/(100*500*$F$28)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B34/(100*500*$F$28)))","v":921.08571428571418},{"$f":"IF(($F$8*(E34/$E$8)^2)<$F$15,$F$15,($F$8*(E34/$E$8)^2))","v":30},{"$f":"(E34*F34)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null,{"$f":"Energy!$D$16*100","v":10},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C35*0.01","v":0},{"$f":"IF(IF(Home!$L$13*12000*B35/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B35/(100*500*$F$19))<$E$17,$E$17,IF(Home!$L$13*12000*B35/(100*500*$F$19)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B35/(100*500*$F$19)))","v":921.08571428571418},30,{"$f":"(E35*F35)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null," "," "," "]
[null,"Chilled Water Distribution Flow at Delta T [F]:",null,null,null,{"$f":"+Home!B28","v":12}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Head [ft]","Power [HP]",null,"Pump costs"]
[null,{"$f":"Energy!$D$11*100","v":100},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C39*0.01","v":137.41494102228052},{"$f":"IF(Home!$L$13*B39*0.01*24/(F37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*B39*0.01*24/(F37))","v":3070.2857142857142},{"$f":"IF(($F$8*(E39/$E$8)^2)<$F$15,$F$15,($F$8*(E39/$E$8)^2))","v":135},{"$f":"(E39*F39)/(3960*Home!$L$20/100)","v":161.02897102897103},"Pump costs",{"$f":"I42*Home!$L$12","v":28097.893543305589}]
[null,{"$f":"Energy!$D$12*100","v":80},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C40*0.01","v":1099.3195281782441},{"$f":"IF(IF(Home!$L$13*12000*B40/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B40/(100*500*$F$37))<$E$17,$E$17,IF(Home!$L$13*12000*B40/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B40/(100*500*$F$37)))","v":2865.6},{"$f":"IF(($F$8*(E40/$E$8)^2)<$F$15,$F$15,($F$8*(E40/$E$8)^2))","v":117.60000000000001},{"$f":"(E40*F40)/(3960*Home!$L$20/100)","v":130.92251748251749},"Annual Gal.",{"$f":"SUMPRODUCT(E39:E44,D39:D44)*60","v":371274754.70810717}]
[null,{"$f":"Energy!$D$13*100","v":60},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C41*0.01","v":824.48964613368298},{"$f":"IF(IF(Home!$L$13*12000*B41/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B41/(100*500*$F$37))<$E$17,$E$17,IF(Home!$L$13*12000*B41/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B41/(100*500*$F$37)))","v":2149.1999999999998},{"$f":"IF(($F$8*(E41/$E$8)^2)<$F$15,$F$15,($F$8*(E41/$E$8)^2))","v":66.149999999999991},{"$f":"(E41*F41)/(3960*Home!$L$20/100)","v":55.232937062937047},"Avg GPM",{"$f":"+I40/(60*Energy!$F$17)","v":2251.542857142857}]
[null,{"$f":"Energy!$D$14*100","v":40},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C42*0.01","v":412.24482306684149},{"$f":"IF(IF(Home!$L$13*12000*B42/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B42/(100*500*$F$37))<$E$17,$E$17,IF(Home!$L$13*12000*B42/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B42/(100*500*$F$37)))","v":1432.8},{"$f":"IF(($F$8*(E42/$E$8)^2)<$F$15,$F$15,($F$8*(E42/$E$8)^2))","v":30},{"$f":"(E42*F42)/(3960*Home!$L$20/100)","v":16.6993006993007},"Energy [kWh]",{"$f":"SUMPRODUCT(D39:D44,G39:G44)*0.746","v":165184.55933748142}]
[null,{"$f":"Energy!$D$15*100","v":20},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C43*0.01","v":274.82988204456103},{"$f":"IF(IF(Home!$L$13*12000*B43/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B43/(100*500*$F$37))<$E$17,$E$17,IF(Home!$L$13*12000*B43/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B43/(100*500*$F$37)))","v":921.08571428571418},{"$f":"IF(($F$8*(E43/$E$8)^2)<$F$15,$F$15,($F$8*(E43/$E$8)^2))","v":30},{"$f":"(E43*F43)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null,{"$f":"Energy!$D$16*100","v":10},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C44*0.01","v":0},{"$f":"IF(IF(Home!$L$13*12000*B44/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B44/(100*500*$F$37))<$E$17,$E$17,IF(Home!$L$13*12000*B44/(100*500*$F$37)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B44/(100*500*$F$37)))","v":921.08571428571418},30,{"$f":"(E44*F44)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null," "," "," "]
[null,"Chilled Water Distribution Flow at Delta T [F]:",null,null,null,{"$f":"Home!B29","v":13}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Head [ft]","Power [HP]",null,"Pump costs"]
[null,{"$f":"Energy!$D$11*100","v":100},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C48*0.01","v":137.41494102228052},{"$f":"IF(Home!$L$13*B48*0.01*24/(F46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*B48*0.01*24/(F46))","v":3070.2857142857142},{"$f":"IF(($F$8*(E48/$E$8)^2)<$F$15,$F$15,($F$8*(E48/$E$8)^2))","v":135},{"$f":"(E48*F48)/(3960*Home!$L$20/100)","v":161.02897102897103},"Pump costs",{"$f":"I51*Home!$L$12","v":22898.370981622229}]
[null,{"$f":"Energy!$D$12*100","v":80},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C49*0.01","v":1099.3195281782441},{"$f":"IF(IF(Home!$L$13*12000*B49/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B49/(100*500*$F$46))<$E$17,$E$17,IF(Home!$L$13*12000*B49/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B49/(100*500*$F$46)))","v":2645.1692307692306},{"$f":"IF(($F$8*(E49/$E$8)^2)<$F$15,$F$15,($F$8*(E49/$E$8)^2))","v":100.20355029585798},{"$f":"(E49*F49)/(3960*Home!$L$20/100)","v":102.97410569403284},"Annual Gal.",{"$f":"SUMPRODUCT(E48:E53,D48:D53)*60","v":345830750.53929985}]
[null,{"$f":"Energy!$D$13*100","v":60},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C50*0.01","v":824.48964613368298},{"$f":"IF(IF(Home!$L$13*12000*B50/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B50/(100*500*$F$46))<$E$17,$E$17,IF(Home!$L$13*12000*B50/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B50/(100*500*$F$46)))","v":1983.876923076923},{"$f":"IF(($F$8*(E50/$E$8)^2)<$F$15,$F$15,($F$8*(E50/$E$8)^2))","v":56.36449704142013},{"$f":"(E50*F50)/(3960*Home!$L$20/100)","v":43.442200839670122},"Avg GPM",{"$f":"+I49/(60*Energy!$F$17)","v":2097.2413186813187}]
[null,{"$f":"Energy!$D$14*100","v":40},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C51*0.01","v":412.24482306684149},{"$f":"IF(IF(Home!$L$13*12000*B51/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B51/(100*500*$F$46))<$E$17,$E$17,IF(Home!$L$13*12000*B51/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B51/(100*500*$F$46)))","v":1322.5846153846153},{"$f":"IF(($F$8*(E51/$E$8)^2)<$F$15,$F$15,($F$8*(E51/$E$8)^2))","v":30},{"$f":"(E51*F51)/(3960*Home!$L$20/100)","v":15.414739107046799},"Energy [kWh]",{"$f":"SUMPRODUCT(D48:D53,G48:G53)*0.746","v":134617.11335462803}]
[null,{"$f":"Energy!$D$15*100","v":20},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C52*0.01","v":274.82988204456103},{"$f":"IF(IF(Home!$L$13*12000*B52/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B52/(100*500*$F$46))<$E$17,$E$17,IF(Home!$L$13*12000*B52/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B52/(100*500*$F$46)))","v":921.08571428571418},{"$f":"IF(($F$8*(E52/$E$8)^2)<$F$15,$F$15,($F$8*(E52/$E$8)^2))","v":30},{"$f":"(E52*F52)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null,{"$f":"Energy!$D$16*100","v":10},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C53*0.01","v":0},{"$f":"IF(IF(Home!$L$13*12000*B53/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B53/(100*500*$F$46))<$E$17,$E$17,IF(Home!$L$13*12000*B53/(100*500*$F$46)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B53/(100*500*$F$46)))","v":921.08571428571418},30,{"$f":"(E53*F53)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null," "," "," "," "]
[null,"Chilled Water Distribution Flow at Delta T [F]:",null,null,null,{"$f":"Home!B30","v":14}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Head [ft]","Power [HP]",null,"Pump costs"]
[null,{"$f":"Energy!$D$11*100","v":100},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C57*0.01","v":137.41494102228052},{"$f":"IF(Home!$L$13*B57*0.01*24/(F55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*B57*0.01*24/(F55))","v":3070.2857142857142},{"$f":"IF(($F$8*(E57/$E$8)^2)<$F$15,$F$15,($F$8*(E57/$E$8)^2))","v":135},{"$f":"(E57*F57)/(3960*Home!$L$20/100)","v":161.02897102897103},"Pump costs",{"$f":"I60*Home!$L$12","v":19071.233870300581}]
[null,{"$f":"Energy!$D$12*100","v":80},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C58*0.01","v":1099.3195281782441},{"$f":"IF(IF(Home!$L$13*12000*B58/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B58/(100*500*$F$55))<$E$17,$E$17,IF(Home!$L$13*12000*B58/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B58/(100*500*$F$55)))","v":2456.2285714285713},{"$f":"IF(($F$8*(E58/$E$8)^2)<$F$15,$F$15,($F$8*(E58/$E$8)^2))","v":86.399999999999991},{"$f":"(E58*F58)/(3960*Home!$L$20/100)","v":82.446833166833159},"Annual Gal.",{"$f":"SUMPRODUCT(E57:E62,D57:D62)*60","v":324021604.10889351}]
[null,{"$f":"Energy!$D$13*100","v":60},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C59*0.01","v":824.48964613368298},{"$f":"IF(IF(Home!$L$13*12000*B59/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B59/(100*500*$F$55))<$E$17,$E$17,IF(Home!$L$13*12000*B59/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B59/(100*500*$F$55)))","v":1842.1714285714286},{"$f":"IF(($F$8*(E59/$E$8)^2)<$F$15,$F$15,($F$8*(E59/$E$8)^2))","v":48.6},{"$f":"(E59*F59)/(3960*Home!$L$20/100)","v":34.782257742257741},"Avg GPM",{"$f":"+I58/(60*Energy!$F$17)","v":1964.982857142857}]
[null,{"$f":"Energy!$D$14*100","v":40},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C60*0.01","v":412.24482306684149},{"$f":"IF(IF(Home!$L$13*12000*B60/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B60/(100*500*$F$55))<$E$17,$E$17,IF(Home!$L$13*12000*B60/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B60/(100*500*$F$55)))","v":1228.1142857142856},{"$f":"IF(($F$8*(E60/$E$8)^2)<$F$15,$F$15,($F$8*(E60/$E$8)^2))","v":30},{"$f":"(E60*F60)/(3960*Home!$L$20/100)","v":14.313686313686315},"Energy [kWh]",{"$f":"SUMPRODUCT(D57:D62,G57:G62)*0.746","v":112117.77701528855}]
[null,{"$f":"Energy!$D$15*100","v":20},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C61*0.01","v":274.82988204456103},{"$f":"IF(IF(Home!$L$13*12000*B61/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B61/(100*500*$F$55))<$E$17,$E$17,IF(Home!$L$13*12000*B61/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B61/(100*500*$F$55)))","v":921.08571428571418},{"$f":"IF(($F$8*(E61/$E$8)^2)<$F$15,$F$15,($F$8*(E61/$E$8)^2))","v":30},{"$f":"(E61*F61)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null,{"$f":"Energy!$D$16*100","v":10},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C62*0.01","v":0},{"$f":"IF(IF(Home!$L$13*12000*B62/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B62/(100*500*$F$55))<$E$17,$E$17,IF(Home!$L$13*12000*B62/(100*500*$F$55)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B62/(100*500*$F$55)))","v":921.08571428571418},30,{"$f":"(E62*F62)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null," "," "," "]
[null,"Chilled Water Distribution Flow at Delta T [F]:",null,null,null,{"$f":"Home!B31","v":15}]
[null,"Load [%]","Time [%]","Time [h]","Flow [GPM]","Head [ft]","Power [HP]",null,"Pump costs"]
[null,{"$f":"Energy!$D$11*100","v":100},{"$f":"+Energy!$E$11*100","v":5},{"$f":"+Energy!$F$17*C66*0.01","v":137.41494102228052},{"$f":"IF(Home!$L$13*B66*0.01*24/(F64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*B66*0.01*24/(F64))","v":2865.6},{"$f":"IF(($F$8*(E66/$E$8)^2)<$F$15,$F$15,($F$8*(E66/$E$8)^2))","v":117.60000000000001},{"$f":"(E66*F66)/(3960*Home!$L$20/100)","v":130.92251748251749},"Pump costs",{"$f":"I69*Home!$L$12","v":15665.690385352596}]
[null,{"$f":"Energy!$D$12*100","v":80},{"$f":"+Energy!$E$12*100","v":40},{"$f":"+Energy!$F$17*C67*0.01","v":1099.3195281782441},{"$f":"IF(IF(Home!$L$13*12000*B67/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B67/(100*500*$F$64))<$E$17,$E$17,IF(Home!$L$13*12000*B67/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B67/(100*500*$F$64)))","v":2292.48},{"$f":"IF(($F$8*(E67/$E$8)^2)<$F$15,$F$15,($F$8*(E67/$E$8)^2))","v":75.26400000000001},{"$f":"(E67*F67)/(3960*Home!$L$20/100)","v":67.032328951048953},"Annual Gal.",{"$f":"SUMPRODUCT(E66:E71,D66:D71)*60","v":303432731.34780759}]
[null,{"$f":"Energy!$D$13*100","v":60},{"$f":"+Energy!$E$13*100","v":30},{"$f":"+Energy!$F$17*C68*0.01","v":824.48964613368298},{"$f":"IF(IF(Home!$L$13*12000*B68/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B68/(100*500*$F$64))<$E$17,$E$17,IF(Home!$L$13*12000*B68/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B68/(100*500*$F$64)))","v":1719.36},{"$f":"IF(($F$8*(E68/$E$8)^2)<$F$15,$F$15,($F$8*(E68/$E$8)^2))","v":42.335999999999991},{"$f":"(E68*F68)/(3960*Home!$L$20/100)","v":28.279263776223768},"Avg GPM",{"$f":"+I67/(60*Energy!$F$17)","v":1840.1245714285715}]
[null,{"$f":"Energy!$D$14*100","v":40},{"$f":"+Energy!$E$14*100","v":15},{"$f":"+Energy!$F$17*C69*0.01","v":412.24482306684149},{"$f":"IF(IF(Home!$L$13*12000*B69/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B69/(100*500*$F$64))<$E$17,$E$17,IF(Home!$L$13*12000*B69/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B69/(100*500*$F$64)))","v":1146.24},{"$f":"IF(($F$8*(E69/$E$8)^2)<$F$15,$F$15,($F$8*(E69/$E$8)^2))","v":30},{"$f":"(E69*F69)/(3960*Home!$L$20/100)","v":13.359440559440559},"Energy [kWh]",{"$f":"SUMPRODUCT(D66:D71,G66:G71)*0.746","v":92096.945240168119}]
[null,{"$f":"Energy!$D$15*100","v":20},{"$f":"+Energy!$E$15*100","v":10},{"$f":"+Energy!$F$17*C70*0.01","v":274.82988204456103},{"$f":"IF(IF(Home!$L$13*12000*B70/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B70/(100*500*$F$64))<$E$17,$E$17,IF(Home!$L$13*12000*B70/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B70/(100*500*$F$64)))","v":921.08571428571418},{"$f":"IF(($F$8*(E70/$E$8)^2)<$F$15,$F$15,($F$8*(E70/$E$8)^2))","v":30},{"$f":"(E70*F70)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null,{"$f":"Energy!$D$16*100","v":10},{"$f":"+Energy!$E$16*100","v":0},{"$f":"+Energy!$F$17*C71*0.01","v":0},{"$f":"IF(IF(Home!$L$13*12000*B71/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B71/(100*500*$F$64))<$E$17,$E$17,IF(Home!$L$13*12000*B71/(100*500*$F$64)>$E$8*$F$5,$E$8*$F$5,Home!$L$13*12000*B71/(100*500*$F$64)))","v":921.08571428571418},30,{"$f":"(E71*F71)/(3960*Home!$L$20/100)","v":10.735264735264733}]
[null," "," "," "]

{"sheet":"Financials","index":4,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[[46,1,46,11],[37,2,37,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Discount Rate:",{"$f":"Home!L43/100","v":0.1}]
["Finance Rate:",0.1]
["Reinvestment Rate:",0.1]
["Inflation Rate",{"$f":"Home!L44/100","v":0.03}]
[]
[" ","Today","End of\nYear 1","End of\nYear 2","End of\nYear 3","End of\nYear 4","End of\nYear 5","End of\nYear 6","End of\nYear 7","End of\nYear 8","End of\nYear 9","End of\nYear 10","End of\nYear 11","End of\nYear 12","End of\nYear 13","End of\nYear 14","End of\nYear 15","End of\nYear 16","End of\nYear 17","End of\nYear 18","End of\nYear 19","End of\nYear 20"]
["Date:",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[]
[]
["Single Investment",{"$f":"Home!L42*-1","v":-290000},0,0,0,0,0,0,0,0,0,0,{"$f":"+L18*(1+$B$12)","v":0},{"$f":"+M18*(1+$B$12)","v":0},0,0,0,0,0,0,0,0]
["Phased Investment",0,0,0,0,0,0,0,0,0,0,0,{"$f":"+L19*(1+$B$12)","v":0},{"$f":"+M19*(1+$B$12)","v":0},0,0,0,0,0,0,0,{"$f":"+U19*(1+$B$12)","v":0}]
["Financed Investment",0,0,0,0,0,0,0,0,0,0,0,{"$f":"+L20*(1+$B$12)","v":0},0,0,0,0,0,0,0,0,0]
["Subtotal",{"$f":"SUM(B18:B20)","v":-290000},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(M18:M20)","v":0},0,0,0,0,0,0,0,0,0]
["Rebate Rec'd at Project Start",0]
["Subtotal Outflows",{"$f":"SUM(B21:B22)","v":-290000},{"$f":"SUM(C21:C22)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(M21:M22)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
["Energy Savings",null,{"$f":"Home!L33","v":28198.749200202554},{"$f":"C26*(1+$B$12)","v":29044.71167620863},29916.05302649489,30813.534617289737,31737.94065580843,32690.078875482683,33670.781241747165,34680.904678999577,35721.331819369567,36792.971773950652,{"$f":"L26*(1+$B$12)","v":37896.760927169176},39033.663754984249,40204.673667633775,41410.813877662789,42653.138293992677,43932.732442812456,45250.714416096831,46608.235848579738,48006.482924037133,49446.677411758246]
["Maintenance/Other Savings",null,{"$f":"SUM(Home!L36:L38)","v":600},{"$f":"C27*(1+$B$12)","v":618},636.54,655.63620000000003,675.30528600000002,695.56444457999999,716.43137791740003,737.92431925492201,760.06204883256964,782.86391029754679,{"$f":"L27*(1+$B$12)","v":806.34982760647324},830.54032243466747,855.45653210770752,881.12022807093877,907.55383491306691,934.7804499604589,962.82386345927273,991.70857936305094,1021.4598367439424,1052.1036318462607]
["Rebates Rec'd after Project Start",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal Inflows",null,{"$f":"SUM(C26:C28)","v":28798.749200202554},{"$f":"SUM(D26:D28)","v":29662.71167620863},30552.593026494891,31469.170817289738,32413.245941808429,33385.643320062685,34387.212619664562,35418.828998254496,36481.39386820214,{"$f":"SUM(L26:L28)","v":37575.835684248203},{"$f":"SUM(M26:M28)","v":38703.110754775647},39864.204077418915,41060.130199741485,42291.93410573373,43560.692128905743,44867.512892772917,46213.538279556102,47599.944427942792,49027.942760781072,50498.781043604504]
[]
["Annual Cash Flow",{"$f":"B23+B29","v":-290000},{"$f":"C23+C29","v":28798.749200202554},{"$f":"D23+D29","v":29662.71167620863},30552.593026494891,31469.170817289738,32413.245941808429,33385.643320062685,34387.212619664562,35418.828998254496,36481.39386820214,37575.835684248203,{"$f":"M23+M29","v":38703.110754775647},39864.204077418915,41060.130199741485,42291.93410573373,43560.692128905743,44867.512892772917,46213.538279556102,47599.944427942792,49027.942760781072,50498.781043604504]
[]
["PV of Outflows (for SIR calculation)",{"$f":"SUM(B23)/(1+$B$9)^B$15","v":-290000},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(M23)/(1+$B$9)^M$15","v":0},0,0,0,0,0,0,0,0,0]
["PV of Inflows (for SIR calculation)",{"$f":"B29/(1+$B$9)^B$15","v":0},{"$f":"C29/(1+$B$9)^C$15","v":26180.681091093229},24514.63774893275,22954.615346727936,21493.867097390703,20126.075554829476,18845.325292249418,17646.077319106269,16523.145126072232,15471.672254413093,14487.111292768621,{"$f":"M29/(1+$B$9)^M$15","v":13565.204210501524},12701.963942560518,11893.657146215759,11136.788055092937,10428.083360677931,9764.478055907517,9143.1021796224923,8561.268404555607,8016.4604151747935,7506.3220251182165]
["Cumulative Cash Flows",{"$f":"B31","v":-290000},{"$f":"B35+C31","v":-261201.25079979745},{"$f":"C35+D31","v":-231538.53912358882},-200985.94609709393,-169516.77527980419,-137103.52933799577,-103717.88601793308,-69330.673398268525,-33911.84440001403,2569.54946818811,40145.385152436313,{"$f":"L35+M31","v":78848.495907211967},118712.69998463089,159772.83018437237,202064.7642901061,245625.45641901184,290492.96931178478,336706.50759134087,384306.45201928366,433334.39478006476,483833.17582366924]
["Annual Present Value",{"$f":"B31/(1+$B$9)^B15","v":-290000},{"$f":"C31/(1+$B$9)^C15","v":26180.681091093229},24514.63774893275,22954.615346727936,21493.867097390703,20126.075554829476,18845.325292249418,17646.077319106269,16523.145126072232,15471.672254413093,14487.111292768621,{"$f":"M31/(1+$B$9)^M15","v":13565.204210501524},12701.963942560518,11893.657146215759,11136.788055092937,10428.083360677931,9764.478055907517,9143.1021796224923,8561.268404555607,8016.4604151747935,7506.3220251182165]
["Cumulative Present Value",{"$f":"B36","v":-290000},{"$f":"B37+C36","v":-263819.31890890677},{"$f":"C37+D36","v":-239304.68115997402},-216350.06581324607,-194856.19871585537,-174730.1231610259,-155884.79786877648,-138238.72054967022,-121715.575423598,-106243.90316918491,-91756.79187641629,{"$f":"L37+M36","v":-78191.587665914762},-65489.623723354242,-53595.966577138483,-42459.178522045549,-32031.095161367619,-22266.6171054601,-13123.514925837608,-4562.2465212820007,3454.2138938927928,10960.53591901101]
[null,null,"*Note: Certain Returns Vary Depending on the Length of the Analysis Term*"]
[null,"10 Year","1 Year","2 Year","3 Year","4 Year","5 Year","6 Year","7 Year","8 Year","9 Year","10 Year","11 Year","12 Year","13 Year","14 Year","15 Year","16 Year","17 Year","18 Year","19 Year","20 Year"]
["Net Present Value (NPV)",{"$f":"SUM(B36:L36)","v":-91756.79187641629},{"$f":"$B$36+SUM($C$36:C36)","v":-263819.31890890677},{"$f":"$B$36+SUM($C$36:D36)","v":-239304.68115997402},{"$f":"$B$36+SUM($C$36:E36)","v":-216350.06581324607},{"$f":"$B$36+SUM($C$36:F36)","v":-194856.19871585537},{"$f":"$B$36+SUM($C$36:G36)","v":-174730.1231610259},{"$f":"$B$36+SUM($C$36:H36)","v":-155884.79786877648},{"$f":"$B$36+SUM($C$36:I36)","v":-138238.72054967022},{"$f":"$B$36+SUM($C$36:J36)","v":-121715.575423598},{"$f":"$B$36+SUM($C$36:K36)","v":-106243.90316918489},{"$f":"$B$36+SUM($C$36:L36)","v":-91756.791876416275},{"$f":"$B$36+SUM($C$36:M36)","v":-78191.587665914762},{"$f":"$B$36+SUM($C$36:N36)","v":-65489.623723354249},{"$f":"$B$36+SUM($C$36:O36)","v":-53595.96657713849},{"$f":"$B$36+SUM($C$36:P36)","v":-42459.178522045549},{"$f":"$B$36+SUM($C$36:Q36)","v":-32031.095161367615},{"$f":"$B$36+SUM($C$36:R36)","v":-22266.617105460085},{"$f":"$B$36+SUM($C$36:S36)","v":-13123.514925837575},{"$f":"$B$36+SUM($C$36:T36)","v":-4562.2465212819516},{"$f":"$B$36+SUM($C$36:U36)","v":3454.2138938928256},{"$f":"$B$36+SUM($C$36:V36)","v":10960.535919011047}]
["Simple Payback Period (SPP)",{"$f":"IF(C21>0,\"N/A\",-B31/C31)","v":10.069881784933921}]
["Return on Investment (ROI)",{"$f":"IF(C21>0,\"N/A\",-C31/B31)","v":9.9306031724836388E-2}]
["Internal Rate of Return (IRR)",{"$f":"IRR($B$31:$L$31,0.1)","v":2.3216463203288296E-2},{"$f":"IRR($B$31:$C$31,0.1)","v":-0.90069396827516357},{"$f":"IRR($B$31:$D$31,0.1)","v":-0.62669495701461009},{"$f":"IRR($B$31:$E$31,0.1)","v":-0.41627280106120446},{"$f":"IRR($B$31:$F$31,0.1)","v":-0.27480150511929369},{"$f":"IRR($B$31:$G$31,0.1)","v":-0.17862427575740869},{"$f":"IRR($B$31:$H$31,0.1)","v":-0.11115671696341245},{"$f":"IRR($B$31:$I$31,0.1)","v":-6.232089771699123E-2},{"$f":"IRR($B$31:$J$31,0.1)","v":-2.598254795268895E-2},{"$f":"IRR($B$31:$K$31,0.1)","v":1.7007680145739723E-3},{"$f":"IRR($B$31:$L$31,0.1)","v":2.3216463203288296E-2},{"$f":"IRR($B$31:$I$31,0.1)","v":-6.232089771699123E-2},{"$f":"IRR($B$31:$J$31,0.1)","v":-2.598254795268895E-2},{"$f":"IRR($B$31:$K$31,0.1)","v":1.7007680145739723E-3},{"$f":"IRR($B$31:$L$31,0.1)","v":2.3216463203288296E-2},{"$f":"IRR($B$31:$I$31,0.1)","v":-6.232089771699123E-2},{"$f":"IRR($B$31:$J$31,0.1)","v":-2.598254795268895E-2},{"$f":"IRR($B$31:$K$31,0.1)","v":1.7007680145739723E-3},{"$f":"IRR($B$31:$L$31,0.1)","v":2.3216463203288296E-2},{"$f":"IRR($B$31:$I$31,0.1)","v":-6.232089771699123E-2},{"$f":"IRR($B$31:$J$31,0.1)","v":-2.598254795268895E-2}]
["Modified Internal Rate of Return (MIRR)",{"$f":"MIRR($B$31:$L$31,$B$10,$B$11)","v":5.8943324858388602E-2},{"$f":"MIRR($B$31:$C$31,$B$10,$B$11)","v":-0.90069396827516357},{"$f":"MIRR($B$31:$D$31,$B$10,$B$11)","v":-0.54008495613439478},{"$f":"MIRR($B$31:$E$31,$B$10,$B$11)","v":-0.30339892516934486},{"$f":"MIRR($B$31:$F$31,$B$10,$B$11)","v":-0.16749220160511891},{"$f":"MIRR($B$31:$G$31,$B$10,$B$11)","v":-8.5347235389235832E-2},{"$f":"MIRR($B$31:$H$31,$B$10,$B$11)","v":-3.2674387715611708E-2},{"$f":"MIRR($B$31:$I$31,$B$10,$B$11)","v":2.8037935816760395E-3},{"$f":"MIRR($B$31:$J$31,$B$10,$B$11)","v":2.7657569915440439E-2},{"$f":"MIRR($B$31:$K$31,$B$10,$B$11)","v":4.5623475480092601E-2},{"$f":"MIRR($B$31:$L$31,$B$10,$B$11)","v":5.8943324858388602E-2},{"$f":"MIRR($B$31:$I$31,$B$10,$B$11)","v":2.8037935816760395E-3},{"$f":"MIRR($B$31:$J$31,$B$10,$B$11)","v":2.7657569915440439E-2},{"$f":"MIRR($B$31:$K$31,$B$10,$B$11)","v":4.5623475480092601E-2},{"$f":"MIRR($B$31:$L$31,$B$10,$B$11)","v":5.8943324858388602E-2},{"$f":"MIRR($B$31:$I$31,$B$10,$B$11)","v":2.8037935816760395E-3},{"$f":"MIRR($B$31:$J$31,$B$10,$B$11)","v":2.7657569915440439E-2},{"$f":"MIRR($B$31:$K$31,$B$10,$B$11)","v":4.5623475480092601E-2},{"$f":"MIRR($B$31:$L$31,$B$10,$B$11)","v":5.8943324858388602E-2},{"$f":"MIRR($B$31:$I$31,$B$10,$B$11)","v":2.8037935816760395E-3},{"$f":"MIRR($B$31:$J$31,$B$10,$B$11)","v":2.7657569915440439E-2}]
["Savings-Investment Ratio (SIR)",{"$f":"SUM($B$34:$L$34)/(ABS(SUM(B33:L33)))","v":0.68359726939166798},{"$f":"SUM($B34:C34)/ABS(SUM($B33:C33))","v":9.0278210658942162E-2},{"$f":"SUM($B34:D34)/ABS(SUM($B33:D33))","v":0.17481144427595166},{"$f":"SUM($B34:E34)/ABS(SUM($B33:E33))","v":0.25396529029915144},{"$f":"SUM($B34:F34)/ABS(SUM($B33:F33))","v":0.32808207339360212},{"$f":"SUM($B34:G34)/ABS(SUM($B33:G33))","v":0.39748233392749688},{"$f":"SUM($B34:H34)/ABS(SUM($B33:H33))","v":0.46246621424559831},{"$f":"SUM($B34:I34)/ABS(SUM($B33:I33))","v":0.52331475672527505},{"$f":"SUM($B34:J34)/ABS(SUM($B33:J33))","v":0.58029111922897247},{"$f":"SUM($B34:K34)/ABS(SUM($B33:K33))","v":0.6336417132097073},{"$f":"SUM($B34:L34)/ABS(SUM($B33:L33))","v":0.68359726939166798},{"$f":"SUM($B34:M34)/ABS(SUM($B33:M33))","v":0.73037383563477665},{"$f":"SUM($B34:N34)/ABS(SUM($B33:N33))","v":0.77417371129877843},{"$f":"SUM($B34:O34)/ABS(SUM($B33:O33))","v":0.81518632214779829},{"$f":"SUM($B34:P34)/ABS(SUM($B33:P33))","v":0.85358903957915333},{"$f":"SUM($B34:Q34)/ABS(SUM($B33:Q33))","v":0.88954794771942203},{"$f":"SUM($B34:R34)/ABS(SUM($B33:R33))","v":0.92321856170531003},{"$f":"SUM($B34:S34)/ABS(SUM($B33:S33))","v":0.95474650025573249},{"$f":"SUM($B34:T34)/ABS(SUM($B33:T33))","v":0.98426811544385528},{"$f":"SUM($B34:U34)/ABS(SUM($B33:U33))","v":1.011911082392734},{"$f":"SUM($B34:V34)/ABS(SUM($B33:V33))","v":1.0377949514448657}]
[null,{"$f":"+Home!B60","v":"V.2021.1.02"}]

{"sheet":"InfoText","index":5,"n_rows":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Sheet","Cell Address","Information Displayed"]
["Home","$D$9","NOAA (National Oceanic and Atmospheric Administration) US Standard Regions "]
["Chiller","$C$18","%Time data comes from the Energy tab."]
["Chiller","$F$18","Operating chiller capacity (Tons) calculated from the primary loop.  If the % load cooling tons is greater than the chiller tons, then the Load equals the maximum chiller ton capacity.  Otherwise, this value is eqal to the GPM*dT/24              Operating Chiller Tons=IF(+E19*$E$14/24>(Home!$L$13), Home!$L$13,(+E19*$E$14/24))"]
["Chiller","$E$7","Operating Tons is calculated as secondary loop GPMxchiller plant dT (not to exceed chiller capacity).    Formula=IF(+E19*$E$14/24>(Home!$L$13), Home!$L$13,(+E19*$E$14/24))"]
["Chiller","$H$14","Savings from auxiliary chiller energy consumption in % per degree of delta t improvement"]
["Chiller","$H$18","Chiller plant energy does not include energy saved by chillers because chiller kW/ton does not change for chiller Delta T.    Raising Delta T allows lag chillers to turn off sooner which reduces primary pump power, condenser pump power, cooling tower fan, and auxilliary chiller power.  Power = # chillers running x (KW2(ea) + KW3(ea)) + #tons x (KW4 kw/ton +  KW6 kw/ton)."]
["Chiller","$I$23","Total energy is the Power (Kw, Column H)  times the operation time (h/yr, Column D)."]
["Chiller","$K$18","LWT Plant checks to ensure the secondary loop water flow (GPM) calculated in Pump worksheet is less than or equal to the chiller plant primary loop flow in GPM (applies to Primary/Secondary pumping systems only).   If \"Normal\", then the primary loop GPM is greater than or equal to the secondary loop GPM.  If \"LWT Loss\", then the secondary loop GPM is greater than the primary loop GPM."]
["Chiller","$E$18","Secondary loop water flow (GPM) from the Pump worksheet"]
["Energy","$D$31","http://www7.ncdc.noaa.gov/CDO/CDODivisionalSelect.jsp"]
["Energy","$E$21","5-year average adjusted for population density at base temperature of 65 F\nSource: National Climatic Data Center"]
["Energy","$E$10","If the chiller plant load profile is known from actual trend log data, enter it here.  If a new chiller plant or load profile is not known, then these %Load and %times are building modeling values that are calculated based on building type, location, chiller plant type and number of chillers. These values can be calculated using plant modeling modeling by myPLV(TM) Calculator tool that can be downloaded from the Trane website. The tool uses PNNL (Pacific Northwest National Labs) and ASHRAE / IES 90.1 - 2010 building modeling criteria."]
["Energy","$F$21","adjusted for population density at base temperature of 65 F\n- Use 30% for very humid climate.\n- Use 5% for for very dry climate.\nSource: National Climatic Data Center"]
["Energy","$G$21","Multiplier = (Cooling Degree Days / Average US CDD)*(1 + Humidity Adjustment)"]
["Financials","$B$12","This is the inflation rate that is predicted for the cost of electricity. Some forecasts predict this to between 3 and 4% annually, over the next decade.\n\nFormula  =Home!J38/100"]
["Financials","$B$18","Formula =Home!J36*-1"]
["Financials","$B$9","This depends on the finance instrument of the investment. If the project is financed by a mortgage with an interest rate of 4%, then enter 4. Alternatively, it could be financed by a bank loan or simply by cash that's on an organizations balance sheet. Some companies are using a so called internal Hurdle Rate. \n\nFormula  =Home!J37/100"]
["Financials","$C$26","Formula =Home!J33"]
["Home","$B$25","Average delta T scenarios"]
["Home","$D$25","Average Flow based on the corresponding delta T.\n\nFormula linked to Pump Tab Column \"N\"."]
["Home","$F$25","Average Tonage based on the corresponding average delta T and average flow.\n\nFormula linked to Chiller Tab Column \"J\"."]
["Home","$F$47","The life-cycle savings of an energy improvement divided by the initial investment. (For every dollar invested in an energy improvement, how many dollars will be saved over the life of the improvement in today’s dollars)\n\n=+Financials!G45"]
["Home","$F$48","Net present value is the present value of net cash inflows generated by a project including salvage value, if any, less the initial investment on the project. It is one of the most reliable measures used in capital budgeting because it accounts for time value of money by using discounted cash inflows.\nBefore calculating NPV, a target rate of return is set which is used to discount the net cash inflows from a project. Net cash inflow equals total cash inflow during a period less the expenses directly incurred on generating the cash inflow.\n\nFormula =+Financials!$G$40"]
["Home","$H$25","Formula =Pump!K24*Energy!$G$34"]
["Home","$J$12","check:\nhttp://www.eia.gov/electricity"]
["Home","$J$17","Enter the Integrated Part Load Value (IPLV) for the chiller from design if known. Otherwise select a value from this list:\n0.3 High Efficiency Variable speed chillers with advanced control optimization\n0.4 High-Efficiency Variable Speed chillers\n0.6 Typical Constant Speed chillers\n0.7 Typical Constant Speed Old style chillers"]
["Home","$J$19","for conventional pump control based on static pressure sensor(s) use lowest possible pump head at part load conditions. If pump(s) are controlled based on actual load, use the min. pump head value as well. Adjust Min [ft./hd] on the Pump tab."]
["Home","$J$25","Formula =Chiller!I52*Energy!$G$34"]
["Home","$J$36","Enter the estimated water treatment savings if a water cooled system.  A rough estimate could be $300 per cooling tower per year.  Enter $0 for air-cooled chiller systems."]
["Home","$J$37","Increasing the Delta T allows the lag chillers to run less hours of operation.  This can extend the useful life of the chillers and corresponding pumps, extending the date when an expensive chiller replacement is necessary.  The net present value (NPV) depends upon the replacement cost, age, and remaining life of the existing chillers.  "]
["Home","$J$38","Increasing the Delta T allows less water flow in the distribution loop and full and part load conditions.  This can allow additional loads to be added to the secondary loop without having to replace expensive distribution pumps.   The value will depend upon the cost of replacing pumps."]
["Home","$J$42","Enter the incremental costs for Energy Valves over conventional control valves such as balancing valves, circuit setters, and labor to install and balance.  If there are new valves installed in the plant that will be replaced by Energy Valves, the whole replacement costs have to be considered."]
["Home","$J$43","This depends on the finance instrument of the investment. If the project is financed by a mortgage with an interest rate of 4%, then enter 4. Alternatively, it could be financed by a bank loan or simply by cash that's on an organizations balance sheet. Some companies are using a so called internal Hurdle Rate. "]
["Home","$J$44","This is the inflation rate that is predicted for the cost of electricity. Some forecasts predict this to between 3 and 4% annually, over the next decade."]
["Home","$J$51","calculation according to EPA www.epa.gov"]
["Home","$J$52","calculation according to EPA www.epa.gov"]
["Home","$J$53","based on annual consumption of 11,880 kWh per home according to EPA www.epa.gov"]
["Home","$L$25","Formula =J26+H26"]
["Home","$N$25","Formula =L26/$L$12"]
["Pump","$C$30","According to \"The Centrifugal Pump Grundfos\", Page 56"]
["Pump","$C$38","According to \"The Centrifugal Pump Grundfos\", Page 56"]
["Pump","$C$46","According to \"The Centrifugal Pump Grundfos\", Page 56"]
["Pump","$C$54","According to \"The Centrifugal Pump Grundfos\", Page 56"]
["Pump","$C$62","According to \"The Centrifugal Pump Grundfos\", Page 56"]
["Pump","$C$7","The constants are based on the weighted average of the most common building types, and operating hours, using average USA weather data. To reduce the number of data points, the ASHRAE based bin data was \n\nFormula=Energy!E$10 through $E$15"]
["Pump","$C$70","According to \"The Centrifugal Pump Grundfos\", Page 56"]
["Pump","$E$15","Enter estimated Pump minimum head pressure drop [ft] and minimum distribution loop flow [GPM] during pump operation.  This would depend upon if there is a bypass loop or 3-way valves in the system that always flow a minumum amount of water regardless of the cooling load needs.  Sometimes this min. flow is marked on the central plant design drawings (piping diagram)."]
["Pump","$F$22","Static pressure control of pump(s) is considered for the calculation of the reduced pump head at part load conditions. A head reduction according to the affinity laws would assume a system with one valve only and without static pressure sensor. The min. head is limited depending on the chosen value."]
["Pump","$F$5","This factor assumes that the pump can generate more GPM than its design selection.  Default Value is 100% means that the pump produces its design capcity.  A larger value can be used for pumps that can generate more GPM than thier design selection capacity."]
["Pump","$F$6","Calculated pump's maximum flow based on Design Delta T."]