{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Non-Lighting Rebate Estimator","Lookups","Incremental Cost"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":3,"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":"Non-Lighting Rebate Estimator","index":0,"n_rows":66,"n_cols":26,"rows_kept":66,"cut":false,"hidden":false,"merged":[[65,0,65,25],[64,16,64,20],[7,19,7,20],[9,19,9,20],[26,25,45,25],[64,0,64,15],[7,14,7,18],[61,4,61,13],[62,19,63,19],[62,20,63,20],[62,21,63,21],[62,25,63,25],[62,4,63,12],[62,23,63,23],[47,4,47,13],[3,0,6,0],[3,14,3,18],[5,14,5,18],[62,0,63,0],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,16,63,16],[62,17,63,17],[62,18,63,18],[53,4,53,13],[9,14,9,18],[7,0,9,0],[3,4,9,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address (Street / City / State / Zip Code)"]
[null,null,null,null,"HVAC \nRebate Estimator\nLast Revised 1/1/2018",null,null,null,null,null,null,null,null,null,"Enter Total Project Costs \n(for items receiving rebates - including tax)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Expected Utility Rebates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PACE Rebate Limit \n(50% of Project Costs minus Utility Rebates)",null,null,null,null,{"$f":"IF(IF((0.5*T4-T6)<5000,(0.5*T4-T6),5000)<0,0.000001,(IF((0.5*T4-T6)<5000,(0.5*T4-T6),5000)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," Estimated PACE Rebate Amount ",null,null,null,null,{"$f":"IFERROR(IF(V65>T8,T8,V65),\"\")","v":0}]
[]
["Measures","# of Units Being Rebated","Building Type","Equipment Capacity","Equipment Capacity Unit","Efficient Equipment Efficiency","Efficient RTU with Economizer?","Is the Existing Unit Operable?","Existing Equipment Efficiency","Existing Equipment Efficiency - Final","Equipment Efficiency Unit","Existing Equipment Installed Date ","Existing Equipment Install Date Range","EFLH","Calculated Savings","Calculated Savings Unit","Deemed Savings","Deemed Savings Units","PACE Rebate","Rebate Units","Capacity Units","PACE Reward","$/ ton GHG-saved (PACE Rebate) ","Xcel Rebate","$/ ton GHG-saved (ES+Xcel Rebate) ","Specifications"]
["Heating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kBTU",null,"$/metric ton",null,"$/metric ton"]
["Boiler, minimum 92% AFUE",null,null,null,"kBTU",null,"n/a",null,null,{"$f":"IFERROR(IF(I15=\"\",VLOOKUP(M15,Baseline_Eff_lookup,2,FALSE),I15),\"\")","v":""},"EFF %",null,{"$f":"IFERROR(VLOOKUP(L15,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C15,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(((((D15*1000)*F15/(IF(H15=\"yes\",J15*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L15),Lookups!$B$30)))-(D15*1000))*N15/1000000)*B15,\"\")","v":""},"dekatherms/ unit",510.3,"kWh/million btu",{"$f":"IF(H15=\"yes\",IF(F15=\"\",'Incremental Cost'!$M$11,IF(F15=92%,'Incremental Cost'!$M$11,('Incremental Cost'!$M$11+('Incremental Cost'!$Q4*((F15-92%)*100))))),IF(F15=\"\",'Incremental Cost'!$L$11,IF(F15=92%,'Incremental Cost'!$L$11,('Incremental Cost'!$L$11+('Incremental Cost'!$Q4*((F15-92%)*100))))))","v":2.5},"$/kBTU",{"$f":"D15","v":0},{"$f":"IF((U15*S15)*B15>5000,5000,(U15*S15)*B15)","v":0},{"$f":"IFERROR(V15/((O15*10)*Lookups!$M$4),\"\")","v":""},{"$f":"IFERROR(U15*'Incremental Cost'!$K$11,\"\")","v":0},{"$f":"IFERROR((V15+X15)/(O15*10*Lookups!$M$4),\"\")","v":""},"• Condensing hot water boilers for space heating and domestic water only\n• Rebates for new equipment replacing currently operating & inoperable equipment \n• Equipment must use natural-gas fuel \n• Boilers must meet minimum efficiency of 92% AFUE \n• Back-up equipment not eligible for rebates \n• Customer must provide CO State inspection report with application"]
["Boiler, minimum 92% AFUE",null,null,null,"kBTU",null,"n/a",null,null,{"$f":"IFERROR(IF(I16=\"\",VLOOKUP(M16,Baseline_Eff_lookup,2,FALSE),I16),\"\")","v":""},"EFF %",null,{"$f":"IFERROR(VLOOKUP(L16,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C16,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(((((D16*1000)*F16/(IF(H16=\"yes\",J16*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L16),Lookups!$B$30)))-(D16*1000))*N16/1000000)*B16,\"\")","v":""},"dekatherms/ unit",510.3,"kWh/million btu",{"$f":"IF(H16=\"yes\",IF(F16=\"\",'Incremental Cost'!$M$11,IF(F16=92%,'Incremental Cost'!$M$11,('Incremental Cost'!$M$11+('Incremental Cost'!$Q5*((F16-92%)*100))))),IF(F16=\"\",'Incremental Cost'!$L$11,IF(F16=92%,'Incremental Cost'!$L$11,('Incremental Cost'!$L$11+('Incremental Cost'!$Q5*((F16-92%)*100))))))","v":2.5},"$/kBTU",{"$f":"D16","v":0},{"$f":"IF((U16*S16)*B16>5000,5000,(U16*S16)*B16)","v":0},{"$f":"IFERROR(V16/((O16*10)*Lookups!$M$4),\"\")","v":""},{"$f":"IFERROR(U16*'Incremental Cost'!$K$11,\"\")","v":0},{"$f":"IFERROR((V16+X16)/(O16*10*Lookups!$M$4),\"\")","v":""},"• Condensing hot water boilers for space heating and domestic water only\n• Rebates for new equipment replacing currently operating & inoperable equipment \n• Equipment must use natural-gas fuel \n• Boilers must meet minimum efficiency of 92% AFUE \n• Back-up equipment not eligible for rebates \n• Customer must provide CO State inspection report with application"]
["Boiler, minimum 92% AFUE",null,null,null,"kBTU",null,"n/a",null,null,{"$f":"IFERROR(IF(I17=\"\",VLOOKUP(M17,Baseline_Eff_lookup,2,FALSE),I17),\"\")","v":""},"EFF %",null,{"$f":"IFERROR(VLOOKUP(L17,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C17,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(((((D17*1000)*F17/(IF(H17=\"yes\",J17*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L17),Lookups!$B$30)))-(D17*1000))*N17/1000000)*B17,\"\")","v":""},"dekatherms/ unit",510.3,"kWh/million btu",{"$f":"IF(H17=\"yes\",IF(F17=\"\",'Incremental Cost'!$M$11,IF(F17=92%,'Incremental Cost'!$M$11,('Incremental Cost'!$M$11+('Incremental Cost'!$Q6*((F17-92%)*100))))),IF(F17=\"\",'Incremental Cost'!$L$11,IF(F17=92%,'Incremental Cost'!$L$11,('Incremental Cost'!$L$11+('Incremental Cost'!$Q6*((F17-92%)*100))))))","v":2.5},"$/kBTU",{"$f":"D17","v":0},{"$f":"IF((U17*S17)*B17>5000,5000,(U17*S17)*B17)","v":0},{"$f":"IFERROR(V17/((O17*10)*Lookups!$M$4),\"\")","v":""},{"$f":"IFERROR(U17*'Incremental Cost'!$K$11,\"\")","v":0},{"$f":"IFERROR((V17+X17)/(O17*10*Lookups!$M$4),\"\")","v":""},"• Condensing hot water boilers for space heating and domestic water only\n• Rebates for new equipment replacing currently operating & inoperable equipment \n• Equipment must use natural-gas fuel \n• Boilers must meet minimum efficiency of 92% AFUE \n• Back-up equipment not eligible for rebates \n• Customer must provide CO State inspection report with application"]
["Boiler, minimum 92% AFUE",null,null,null,"kBTU",null,"n/a",null,null,{"$f":"IFERROR(IF(I18=\"\",VLOOKUP(M18,Baseline_Eff_lookup,2,FALSE),I18),\"\")","v":""},"EFF %",null,{"$f":"IFERROR(VLOOKUP(L18,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C18,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(((((D18*1000)*F18/(IF(H18=\"yes\",J18*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L18),Lookups!$B$30)))-(D18*1000))*N18/1000000)*B18,\"\")","v":""},"dekatherms/ unit",510.3,"kWh/million btu",{"$f":"IF(H18=\"yes\",IF(F18=\"\",'Incremental Cost'!$M$11,IF(F18=92%,'Incremental Cost'!$M$11,('Incremental Cost'!$M$11+('Incremental Cost'!$Q7*((F18-92%)*100))))),IF(F18=\"\",'Incremental Cost'!$L$11,IF(F18=92%,'Incremental Cost'!$L$11,('Incremental Cost'!$L$11+('Incremental Cost'!$Q7*((F18-92%)*100))))))","v":2.5},"$/kBTU",{"$f":"D18","v":0},{"$f":"IF((U18*S18)*B18>5000,5000,(U18*S18)*B18)","v":0},{"$f":"IFERROR(V18/((O18*10)*Lookups!$M$4),\"\")","v":""},{"$f":"IFERROR(U18*'Incremental Cost'!$K$11,\"\")","v":0},{"$f":"IFERROR((V18+X18)/(O18*10*Lookups!$M$4),\"\")","v":""},"• Condensing hot water boilers for space heating and domestic water only\n• Rebates for new equipment replacing currently operating & inoperable equipment \n• Equipment must use natural-gas fuel \n• Boilers must meet minimum efficiency of 92% AFUE \n• Back-up equipment not eligible for rebates \n• Customer must provide CO State inspection report with application"]
["Boiler, minimum 92% AFUE",null,null,null,"kBTU",null,"n/a",null,null,{"$f":"IFERROR(IF(I19=\"\",VLOOKUP(M19,Baseline_Eff_lookup,2,FALSE),I19),\"\")","v":""},"EFF %",null,{"$f":"IFERROR(VLOOKUP(L19,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C19,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(((((D19*1000)*F19/(IF(H19=\"yes\",J19*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L19),Lookups!$B$30)))-(D19*1000))*N19/1000000)*B19,\"\")","v":""},"dekatherms/ unit",510.3,"kWh/million btu",{"$f":"IF(H19=\"yes\",IF(F19=\"\",'Incremental Cost'!$M$11,IF(F19=92%,'Incremental Cost'!$M$11,('Incremental Cost'!$M$11+('Incremental Cost'!$Q8*((F19-92%)*100))))),IF(F19=\"\",'Incremental Cost'!$L$11,IF(F19=92%,'Incremental Cost'!$L$11,('Incremental Cost'!$L$11+('Incremental Cost'!$Q8*((F19-92%)*100))))))","v":2.5},"$/kBTU",{"$f":"D19","v":0},{"$f":"IF((U19*S19)*B19>5000,5000,(U19*S19)*B19)","v":0},{"$f":"IFERROR(V19/((O19*10)*Lookups!$M$4),\"\")","v":""},{"$f":"IFERROR(U19*'Incremental Cost'!$K$11,\"\")","v":0},{"$f":"IFERROR((V19+X19)/(O19*10*Lookups!$M$4),\"\")","v":""},"• Condensing hot water boilers for space heating and domestic water only\n• Rebates for new equipment replacing currently operating & inoperable equipment \n• Equipment must use natural-gas fuel \n• Boilers must meet minimum efficiency of 92% AFUE \n• Back-up equipment not eligible for rebates \n• Customer must provide CO State inspection report with application"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit"]
["Natural Gas Furnace <=225 kBTU, minimum 92% AFUE",null,null,null,"kBTU",null,null,null,null,{"$f":"IFERROR(IF(I21=\"\",VLOOKUP(M21,Baseline_Eff_lookup,4,FALSE),I21),\"\")","v":""},"EFF %",null,{"$f":"IFERROR(VLOOKUP(L21,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C21,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(((((D21*1000)*F21/(IF(H21=\"yes\",J21*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L21),Lookups!$D$30)))-(D21*1000))*N21/1000000)*B21,\"\")","v":""},"dekatherms/ unit",4071,"kWh/Unit",{"$f":"ROUND(IF(H21=\"yes\",IF(F21=\"\",'Incremental Cost'!$I$25,IF(F21=92%,'Incremental Cost'!$I$25,('Incremental Cost'!$I$25+'Incremental Cost'!$M16))),IF(F21=\"\",'Incremental Cost'!$H$25,IF(F21=92%,'Incremental Cost'!$H$25,('Incremental Cost'!$H$25+'Incremental Cost'!$M16)))),0)","v":100},"$/unit",{"$f":"B21","v":0},{"$f":"IF((U21*S21)>5000,5000,(U21*S21))","v":0},{"$f":"IFERROR(V21/((O21*10)*Lookups!$M$4),\"\")","v":""},{"$f":"'Incremental Cost'!$G$25","v":80},{"$f":"IFERROR((V21+X21)/(O21*10*Lookups!$M$4),\"\")","v":""},"• Rebates for new equipment replacing currently operating & inoperable equipment \n• Furnace must be less than 225 kBtuh \n• Furnaces must meet minimum efficiency of 92% AFUE \n• Equipment must use natural-gas fuel"]
["Natural Gas Furnace <=225 kBTU, minimum 92% AFUE",null,null,null,"kBTU",null,null,null,null,{"$f":"IFERROR(IF(I22=\"\",VLOOKUP(M22,Baseline_Eff_lookup,4,FALSE),I22),\"\")","v":""},"EFF %",null,{"$f":"IFERROR(VLOOKUP(L22,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C22,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(((((D22*1000)*F22/(IF(H22=\"yes\",J22*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L22),Lookups!$D$30)))-(D22*1000))*N22/1000000)*B22,\"\")","v":""},"dekatherms/ unit",4071,"kWh/Unit",{"$f":"ROUND(IF(H22=\"yes\",IF(F22=\"\",'Incremental Cost'!$I$25,IF(F22=92%,'Incremental Cost'!$I$25,('Incremental Cost'!$I$25+'Incremental Cost'!$M17))),IF(F22=\"\",'Incremental Cost'!$H$25,IF(F22=92%,'Incremental Cost'!$H$25,('Incremental Cost'!$H$25+'Incremental Cost'!$M17)))),0)","v":100},"$/unit",{"$f":"B22","v":0},{"$f":"IF((U22*S22)>5000,5000,(U22*S22))","v":0},{"$f":"IFERROR(V22/((O22*10)*Lookups!$M$4),\"\")","v":""},{"$f":"'Incremental Cost'!$G$25","v":80},{"$f":"IFERROR((V22+X22)/(O22*10*Lookups!$M$4),\"\")","v":""},"• Rebates for new equipment replacing currently operating & inoperable equipment \n• Furnace must be less than 225 million Btuh \n• Furnaces must meet minimum efficiency of 92% AFUE \n• Equipment must use natural-gas fuel"]
["Natural Gas Furnace <=225 kBTU, minimum 92% AFUE",null,null,null,"kBTU",null,null,null,null,{"$f":"IFERROR(IF(I23=\"\",VLOOKUP(M23,Baseline_Eff_lookup,4,FALSE),I23),\"\")","v":""},"EFF %",null,{"$f":"IFERROR(VLOOKUP(L23,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C23,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(((((D23*1000)*F23/(IF(H23=\"yes\",J23*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L23),Lookups!$D$30)))-(D23*1000))*N23/1000000)*B23,\"\")","v":""},"dekatherms/ unit",4071,"kWh/Unit",{"$f":"ROUND(IF(H23=\"yes\",IF(F23=\"\",'Incremental Cost'!$I$25,IF(F23=92%,'Incremental Cost'!$I$25,('Incremental Cost'!$I$25+'Incremental Cost'!$M18))),IF(F23=\"\",'Incremental Cost'!$H$25,IF(F23=92%,'Incremental Cost'!$H$25,('Incremental Cost'!$H$25+'Incremental Cost'!$M18)))),0)","v":100},"$/unit",{"$f":"B23","v":0},{"$f":"IF((U23*S23)>5000,5000,(U23*S23))","v":0},{"$f":"IFERROR(V23/((O23*10)*Lookups!$M$4),\"\")","v":""},{"$f":"'Incremental Cost'!$G$25","v":80},{"$f":"IFERROR((V23+X23)/(O23*10*Lookups!$M$4),\"\")","v":""},"• Rebates for new equipment replacing currently operating & inoperable equipment \n• Furnace must be less than 225 million Btuh \n• Furnaces must meet minimum efficiency of 92% AFUE \n• Equipment must use natural-gas fuel"]
["Natural Gas Furnace <=225 kBTU, minimum 92% AFUE",null,null,null,"kBTU",null,null,null,null,{"$f":"IFERROR(IF(I24=\"\",VLOOKUP(M24,Baseline_Eff_lookup,4,FALSE),I24),\"\")","v":""},"EFF %",null,{"$f":"IFERROR(VLOOKUP(L24,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C24,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(((((D24*1000)*F24/(IF(H24=\"yes\",J24*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L24),Lookups!$D$30)))-(D24*1000))*N24/1000000)*B24,\"\")","v":""},"dekatherms/ unit",4071,"kWh/Unit",{"$f":"ROUND(IF(H24=\"yes\",IF(F24=\"\",'Incremental Cost'!$I$25,IF(F24=92%,'Incremental Cost'!$I$25,('Incremental Cost'!$I$25+'Incremental Cost'!$M19))),IF(F24=\"\",'Incremental Cost'!$H$25,IF(F24=92%,'Incremental Cost'!$H$25,('Incremental Cost'!$H$25+'Incremental Cost'!$M19)))),0)","v":100},"$/unit",{"$f":"B24","v":0},{"$f":"IF((U24*S24)>5000,5000,(U24*S24))","v":0},{"$f":"IFERROR(V24/((O24*10)*Lookups!$M$4),\"\")","v":""},{"$f":"'Incremental Cost'!$G$25","v":80},{"$f":"IFERROR((V24+X24)/(O24*10*Lookups!$M$4),\"\")","v":""},"• Rebates for new equipment replacing currently operating & inoperable equipment \n• Furnace must be less than 225 million Btuh \n• Furnaces must meet minimum efficiency of 92% AFUE \n• Equipment must use natural-gas fuel"]
["Air Conditioning "]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(I26=\"\",VLOOKUP(M26,Baseline_Eff_lookup,6,FALSE),I26),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Tons",null,"$/metric ton",null,"$/metric ton"]
["Rooftop AC Units, <=5.4 tons, 17.0 SEER",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I27=\"\",VLOOKUP(M27,Baseline_Eff_lookup,6,FALSE),I27),\"\")","v":""},"SEER",null,{"$f":"IFERROR(VLOOKUP(L27,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C27,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D27*12000)/1000)*N27*((1/(IF(H27=\"yes\",J27*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L27),Lookups!$F$30)))-(1/IF(G27=\"Yes\",F27*Lookups!E$44,F27))),\"\")*B27,\"\")","v":""},"kWh/unit",595,"kWh/Unit",{"$f":"ROUND(IF(H27=\"yes\",IF(F27=\"\",'Incremental Cost'!$I$50,IF(F27=17,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M39*((F27-17)))))),IF(F27=\"\",'Incremental Cost'!$H$50,IF(F27=17,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M39*((F27-17))))))),0)","v":79},"$/ton",{"$f":"D27","v":0},{"$f":"IF((U27*S27)*B27>5000,5000,(U27*S27+IF(G27=\"yes\",250,0))*B27)","v":0},{"$f":"IFERROR(V27/(O27*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U27*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V27+X27)/(O27*Lookups!$M$3),\"\")","v":""},"• Rebates for new equipment replacing currently operating & inoperable equipment \n• Equipment must be currently rated at AHRI standards. \n• Equipment must use a minimum ozone-depleting refrigerant such as R-\n   22, R-123, and R-134\nRooftop AC Units\n• Equipment must be 20 tons or less \n• Tier 2 equipment less than 5.4 tons must be minimum 17.0 SEER \n• Tier 2 equipment between 5.5 and 11.3 tons must be minimum 12.0 EER \n• Tier 2 equipment between 11.4 and 20 tons must be minimum 12.0 EER \n• Refer to Consortium of Energy Efficiency for listing of Tier 2 equipment \n   (http://www.cee1.org/com/hecac/hecac-tiers.pdf)\nSplit Systems\n• Equipment must be less than 5.4 tons and must be minimum 15 SEER \n• Condensing unit and coil must both be newly installed to receive a rebate. • Efficiencies will be based on the condensing unit and coil combination rated by AHRI. \nCondensing Units\n• Equipment must be minimum 15 SEER"]
["Rooftop AC Units, <=5.4 tons, 17.0 SEER",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I28=\"\",VLOOKUP(M28,Baseline_Eff_lookup,6,FALSE),I28),\"\")","v":""},"SEER",null,{"$f":"IFERROR(VLOOKUP(L28,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C28,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D28*12000)/1000)*N28*((1/(IF(H28=\"yes\",J28*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L28),Lookups!$F$30)))-(1/IF(G28=\"Yes\",F28*Lookups!E$44,F28))),\"\")*B28,\"\")","v":""},"kWh/unit",595,"kWh/Unit",{"$f":"ROUND(IF(H28=\"yes\",IF(F28=\"\",'Incremental Cost'!$I$50,IF(F28=17,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M40*((F28-17)))))),IF(F28=\"\",'Incremental Cost'!$H$50,IF(F28=17,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M40*((F28-17))))))),0)","v":79},"$/ton",0,{"$f":"IF((U28*S28)*B28>5000,5000,(U28*S28+IF(G28=\"yes\",250,0))*B28)","v":0},{"$f":"IFERROR(V28/(O28*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U28*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V28+X28)/(O28*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, <=5.4 tons, 17.0 SEER",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I29=\"\",VLOOKUP(M29,Baseline_Eff_lookup,6,FALSE),I29),\"\")","v":""},"SEER",null,"","",{"$f":"IFERROR(IFERROR(((D29*12000)/1000)*N29*((1/(IF(H29=\"yes\",J29*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L29),Lookups!$F$30)))-(1/IF(G29=\"Yes\",F29*Lookups!E$44,F29))),\"\")*B29,\"\")","v":""},"kWh/unit",595,"kWh/Unit",{"$f":"ROUND(IF(H29=\"yes\",IF(F29=\"\",'Incremental Cost'!$I$50,IF(F29=17,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M41*((F29-17)))))),IF(F29=\"\",'Incremental Cost'!$H$50,IF(F29=17,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M41*((F29-17))))))),0)","v":79},"$/ton",0,{"$f":"IF((U29*S29)*B29>5000,5000,(U29*S29+IF(G29=\"yes\",250,0))*B29)","v":0},{"$f":"IFERROR(V29/(O29*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U29*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V29+X29)/(O29*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, <=5.4 tons, 17.0 SEER",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I30=\"\",VLOOKUP(M30,Baseline_Eff_lookup,6,FALSE),I30),\"\")","v":""},"SEER",null,{"$f":"IFERROR(VLOOKUP(L30,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C30,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D30*12000)/1000)*N30*((1/(IF(H30=\"yes\",J30*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L30),Lookups!$F$30)))-(1/IF(G30=\"Yes\",F30*Lookups!E$44,F30))),\"\")*B30,\"\")","v":""},"kWh/unit",595,"kWh/Unit",{"$f":"ROUND(IF(H30=\"yes\",IF(F30=\"\",'Incremental Cost'!$I$50,IF(F30=17,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M42*((F30-17)))))),IF(F30=\"\",'Incremental Cost'!$H$50,IF(F30=17,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M42*((F30-17))))))),0)","v":79},"$/ton",{"$f":"D30","v":0},{"$f":"IF((U30*S30)*B30>5000,5000,(U30*S30+IF(G30=\"yes\",250,0))*B30)","v":0},{"$f":"IFERROR(V30/(O30*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U30*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V30+X30)/(O30*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, 5.5 - 11.3 tons, 12.0 EER ",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I31=\"\",VLOOKUP(M31,Baseline_Eff_lookup,6,FALSE),I31),\"\")","v":""},"EER",null,"","",{"$f":"IFERROR(IFERROR(((D31*12000)/1000)*N31*((1/(IF(H31=\"yes\",J31*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L31),Lookups!$H$30)))-(1/IF(G31=\"Yes\",F31*Lookups!E$44,F31))),\"\")*B31,\"\")","v":""},"kWh/unit",1750,"kWh/Unit",{"$f":"ROUND(IF(H31=\"yes\",IF(F31=\"\",'Incremental Cost'!$I$50,IF(F31=12,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M43*((F31-12)))))),IF(F31=\"\",'Incremental Cost'!$H$50,IF(F31=12,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M43*((F31-12))))))),0)","v":79},"$/ton",0,{"$f":"IF((U31*S31)*B31>5000,5000,(U31*S31+IF(G31=\"yes\",250,0))*B31)","v":0},{"$f":"IFERROR(V31/(O31*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U31*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V31+X31)/(O31*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, 5.5 - 11.3 tons, 12.0 EER ",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I32=\"\",VLOOKUP(M32,Baseline_Eff_lookup,8,FALSE),I32),\"\")","v":""},"EER",null,{"$f":"IFERROR(VLOOKUP(L32,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C32,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D32*12000)/1000)*N32*((1/(IF(H32=\"yes\",J32*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L32),Lookups!$H$30)))-(1/IF(G32=\"Yes\",F32*Lookups!E$44,F32))),\"\")*B32,\"\")","v":""},"kWh/unit",1750,"kWh/Unit",{"$f":"ROUND(IF(H32=\"yes\",IF(F32=\"\",'Incremental Cost'!$I$50,IF(F32=12,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M44*((F32-12)))))),IF(F32=\"\",'Incremental Cost'!$H$50,IF(F32=12,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M44*((F32-12))))))),0)","v":79},"$/ton",0,{"$f":"IF((U32*S32)*B32>5000,5000,(U32*S32+IF(G32=\"yes\",250,0))*B32)","v":0},{"$f":"IFERROR(V32/(O32*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U32*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V32+X32)/(O32*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, 5.5 - 11.3 tons, 12.0 EER ",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I33=\"\",VLOOKUP(M33,Baseline_Eff_lookup,8,FALSE),I33),\"\")","v":""},"EER",null,"","",{"$f":"IFERROR(IFERROR(((D33*12000)/1000)*N33*((1/(IF(H33=\"yes\",J33*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L33),Lookups!$H$30)))-(1/IF(G33=\"Yes\",F33*Lookups!E$44,F33))),\"\")*B33,\"\")","v":""},"kWh/unit",1750,"kWh/Unit",{"$f":"ROUND(IF(H33=\"yes\",IF(F33=\"\",'Incremental Cost'!$I$50,IF(F33=12,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M45*((F33-12)))))),IF(F33=\"\",'Incremental Cost'!$H$50,IF(F33=12,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M45*((F33-12))))))),0)","v":79},"$/ton",0,{"$f":"IF((U33*S33)*B33>5000,5000,(U33*S33+IF(G33=\"yes\",250,0))*B33)","v":0},{"$f":"IFERROR(V33/(O33*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U33*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V33+X33)/(O33*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, 5.5 - 11.3 tons, 12.0 EER ",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I34=\"\",VLOOKUP(M34,Baseline_Eff_lookup,8,FALSE),I34),\"\")","v":""},"EER",null,{"$f":"IFERROR(VLOOKUP(L34,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C34,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D34*12000)/1000)*N34*((1/(IF(H34=\"yes\",J34*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L34),Lookups!$H$30)))-(1/IF(G34=\"Yes\",F34*Lookups!E$44,F34))),\"\")*B34,\"\")","v":""},"kWh/unit",1750,"kWh/Unit",{"$f":"ROUND(IF(H34=\"yes\",IF(F34=\"\",'Incremental Cost'!$I$50,IF(F34=12,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M46*((F34-12)))))),IF(F34=\"\",'Incremental Cost'!$H$50,IF(F34=12,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M46*((F34-12))))))),0)","v":79},"$/ton",{"$f":"D34","v":0},{"$f":"IF((U34*S34)*B34>5000,5000,(U34*S34+IF(G34=\"yes\",250,0))*B34)","v":0},{"$f":"IFERROR(V34/(O34*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U34*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V34+X34)/(O34*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, 11.4 - 20 tons, 12.0 EER ",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I35=\"\",VLOOKUP(M35,Baseline_Eff_lookup,8,FALSE),I35),\"\")","v":""},"EER",null,"","",{"$f":"IFERROR(IFERROR(((D35*12000)/1000)*N35*((1/(IF(H35=\"yes\",J35*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L35),Lookups!$J$30)))-(1/IF(G35=\"Yes\",F35*Lookups!E$44,F35))),\"\")*B35,\"\")","v":""},"kWh/unit",3603,"kWh/Unit",{"$f":"ROUND(IF(H35=\"yes\",IF(F35=\"\",'Incremental Cost'!$I$50,IF(F35=12,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M47*((F35-12)))))),IF(F35=\"\",'Incremental Cost'!$H$50,IF(F35=12,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M47*((F35-12))))))),0)","v":79},"$/ton",0,{"$f":"IF((U35*S35)*B35>5000,5000,(U35*S35+IF(G35=\"yes\",250,0))*B35)","v":0},{"$f":"IFERROR(V35/(O35*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U35*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V35+X35)/(O35*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, 11.4 - 20 tons, 12.0 EER ",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I36=\"\",VLOOKUP(M36,Baseline_Eff_lookup,10,FALSE),I36),\"\")","v":""},"EER",null,{"$f":"IFERROR(VLOOKUP(L36,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C36,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D36*12000)/1000)*N36*((1/(IF(H36=\"yes\",J36*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L36),Lookups!$J$30)))-(1/IF(G36=\"Yes\",F36*Lookups!E$44,F36))),\"\")*B36,\"\")","v":""},"kWh/unit",3603,"kWh/Unit",{"$f":"ROUND(IF(H36=\"yes\",IF(F36=\"\",'Incremental Cost'!$I$50,IF(F36=12,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M48*((F36-12)))))),IF(F36=\"\",'Incremental Cost'!$H$50,IF(F36=12,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M48*((F36-12))))))),0)","v":79},"$/ton",{"$f":"D36","v":0},{"$f":"IF((U36*S36)*B36>5000,5000,(U36*S36+IF(G36=\"yes\",250,0))*B36)","v":0},{"$f":"IFERROR(V36/(O36*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U36*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V36+X36)/(O36*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, 11.4 - 20 tons, 12.0 EER ",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I37=\"\",VLOOKUP(M37,Baseline_Eff_lookup,10,FALSE),I37),\"\")","v":""},"EER",null,"","",{"$f":"IFERROR(IFERROR(((D37*12000)/1000)*N37*((1/(IF(H37=\"yes\",J37*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L37),Lookups!$J$30)))-(1/IF(G37=\"Yes\",F37*Lookups!E$44,F37))),\"\")*B37,\"\")","v":""},"kWh/unit",3603,"kWh/Unit",{"$f":"ROUND(IF(H37=\"yes\",IF(F37=\"\",'Incremental Cost'!$I$50,IF(F37=12,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M49*((F37-12)))))),IF(F37=\"\",'Incremental Cost'!$H$50,IF(F37=12,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M49*((F37-12))))))),0)","v":79},"$/ton",0,{"$f":"IF((U37*S37)*B37>5000,5000,(U37*S37+IF(G37=\"yes\",250,0))*B37)","v":0},{"$f":"IFERROR(V37/(O37*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U37*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V37+X37)/(O37*Lookups!$M$3),\"\")","v":""}]
["Rooftop AC Units, 11.4 - 20 tons, 12.0 EER ",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I38=\"\",VLOOKUP(M38,Baseline_Eff_lookup,10,FALSE),I38),\"\")","v":""},"EER",null,{"$f":"IFERROR(VLOOKUP(L38,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C38,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D38*12000)/1000)*N38*((1/(IF(H38=\"yes\",J38*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L38),Lookups!$J$30)))-(1/IF(G38=\"Yes\",F38*Lookups!E$44,F38))),\"\")*B38,\"\")","v":""},"kWh/unit",3603,"kWh/Unit",{"$f":"ROUND(IF(H38=\"yes\",IF(F38=\"\",'Incremental Cost'!$I$50,IF(F38=12,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M50*((F38-12)))))),IF(F38=\"\",'Incremental Cost'!$H$50,IF(F38=12,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M50*((F38-12))))))),0)","v":79},"$/ton",{"$f":"D38","v":0},{"$f":"IF((U38*S38)*B38>5000,5000,(U38*S38+IF(G38=\"yes\",250,0))*B38)","v":0},{"$f":"IFERROR(V38/(O38*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U38*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V38+X38)/(O38*Lookups!$M$3),\"\")","v":""}]
["Split Systems <=5.4 tons, 15 SEER",null,null,null,"tons",null,null,null,null,{"$f":"IFERROR(IF(I39=\"\",VLOOKUP(M39,Baseline_Eff_lookup,6,FALSE),I39),\"\")","v":""},"SEER",null,"","",{"$f":"IFERROR(IFERROR(((D39*12000)/1000)*N39*((1/(IF(H39=\"yes\",J39*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L39),Lookups!$F$30)))-(1/F39)),\"\")*B39,\"\")","v":""},"kWh/unit",1870,"kWh/Unit",{"$f":"ROUND(IF(H39=\"yes\",IF(F39=\"\",'Incremental Cost'!$I$50,IF(F39=15,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M51*((F39-15)))))),IF(F39=\"\",'Incremental Cost'!$H$50,IF(F39=15,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M51*((F39-15))))))),0)","v":79},"$/ton",0,{"$f":"IF((U39*S39)*B39>5000,5000,(U39*S39+IF(G39=\"yes\",250,0))*B39)","v":0},{"$f":"IFERROR(V39/(O39*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U39*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V39+X39)/(O39*Lookups!$M$3),\"\")","v":""}]
["Split Systems <=5.4 tons, 15 SEER",null,null,null,"tons",null,null,null,null,"","SEER",null,{"$f":"IFERROR(VLOOKUP(L40,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C40,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D40*12000)/1000)*N40*((1/(IF(H40=\"yes\",J40*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L40),Lookups!$F$30)))-(1/F40)),\"\")*B40,\"\")","v":""},"kWh/unit",1870,"kWh/Unit",{"$f":"ROUND(IF(H40=\"yes\",IF(F40=\"\",'Incremental Cost'!$I$50,IF(F40=15,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M52*((F40-15)))))),IF(F40=\"\",'Incremental Cost'!$H$50,IF(F40=15,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M52*((F40-15))))))),0)","v":79},"$/ton",{"$f":"D40","v":0},{"$f":"IF((U40*S40)*B40>5000,5000,(U40*S40+IF(G40=\"yes\",250,0))*B40)","v":0},{"$f":"IFERROR(V40/(O40*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U40*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V40+X40)/(O40*Lookups!$M$3),\"\")","v":""}]
["Split Systems <=5.4 tons, 15 SEER",null,null,null,"tons",null,null,null,null,"","SEER",null,"","",{"$f":"IFERROR(IFERROR(((D41*12000)/1000)*N41*((1/(IF(H41=\"yes\",J41*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L41),Lookups!$F$30)))-(1/F41)),\"\")*B41,\"\")","v":""},"kWh/unit",1870,"kWh/Unit",{"$f":"ROUND(IF(H41=\"yes\",IF(F41=\"\",'Incremental Cost'!$I$50,IF(F41=15,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M53*((F41-15)))))),IF(F41=\"\",'Incremental Cost'!$H$50,IF(F41=15,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M53*((F41-15))))))),0)","v":79},"$/ton",0,{"$f":"IF((U41*S41)*B41>5000,5000,(U41*S41+IF(G41=\"yes\",250,0))*B41)","v":0},{"$f":"IFERROR(V41/(O41*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U41*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V41+X41)/(O41*Lookups!$M$3),\"\")","v":""}]
["Split Systems <=5.4 tons, 15 SEER",null,null,null,"tons",null,null,null,null,"","SEER",null,{"$f":"IFERROR(VLOOKUP(L42,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C42,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D42*12000)/1000)*N42*((1/(IF(H42=\"yes\",J42*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!L42),Lookups!$F$30)))-(1/F42)),\"\")*B42,\"\")","v":""},"kWh/unit",1870,"kWh/Unit",{"$f":"ROUND(IF(H42=\"yes\",IF(F42=\"\",'Incremental Cost'!$I$50,IF(F42=15,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M54*((F42-15)))))),IF(F42=\"\",'Incremental Cost'!$H$50,IF(F42=15,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M54*((F42-15))))))),0)","v":79},"$/ton",{"$f":"D42","v":0},{"$f":"IF((U42*S42)*B42>5000,5000,(U42*S42+IF(G42=\"yes\",250,0))*B42)","v":0},{"$f":"IFERROR(V42/(O42*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U42*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V42+X42)/(O42*Lookups!$M$3),\"\")","v":""}]
["Condensing Units 15 SEER",null,null,null,"tons",null,null,null,null,"","SEER",null,"","",{"$f":"IFERROR(IFERROR(((D43*12000)/1000)*N43*((1/(IF(H43=\"yes\",J43*(1-Lookups!I$9)^(2016-'Non-Lighting Rebate Estimator'!L43),Lookups!$F$30)))-(1/F43)),\"\")*B43,\"\")","v":""},"kWh/unit",1120,"kWh/Unit",{"$f":"ROUND(IF(H43=\"yes\",IF(F43=\"\",'Incremental Cost'!$I$50,IF(F43=15,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M55*((F43-15)))))),IF(F43=\"\",'Incremental Cost'!$H$50,IF(F43=15,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M55*((F43-15))))))),0)","v":79},"$/ton",0,{"$f":"IF((U43*S43)*B43>5000,5000,(U43*S43+IF(G43=\"yes\",250,0))*B43)","v":0},{"$f":"IFERROR(V43/(O43*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U43*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V43+X43)/(O43*Lookups!$M$3),\"\")","v":""}]
["Condensing Units 15 SEER",null,null,null,"tons",null,null,null,null,"","SEER",null,"","",{"$f":"IFERROR(IFERROR(((D44*12000)/1000)*N44*((1/(IF(H44=\"yes\",J44*(1-Lookups!I$9)^(2016-'Non-Lighting Rebate Estimator'!L44),Lookups!$F$30)))-(1/F44)),\"\")*B44,\"\")","v":""},"kWh/unit",1120,"kWh/Unit",{"$f":"ROUND(IF(H44=\"yes\",IF(F44=\"\",'Incremental Cost'!$I$50,IF(F44=15,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M56*((F44-15)))))),IF(F44=\"\",'Incremental Cost'!$H$50,IF(F44=15,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M56*((F44-15))))))),0)","v":79},"$/ton",0,{"$f":"IF((U44*S44)*B44>5000,5000,(U44*S44+IF(G44=\"yes\",250,0))*B44)","v":0},{"$f":"IFERROR(V44/(O44*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U44*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V44+X44)/(O44*Lookups!$M$3),\"\")","v":""}]
["Condensing Units 15 SEER",null,null,null,"tons",null,null,null,null,"","SEER",null,{"$f":"IFERROR(VLOOKUP(L45,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C45,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(((D45*12000)/1000)*N45*((1/(IF(H45=\"yes\",J45*(1-Lookups!I$9)^(2016-'Non-Lighting Rebate Estimator'!L45),Lookups!$F$30)))-(1/F45)),\"\")*B45,\"\")","v":""},"kWh/unit",1120,"kWh/Unit",{"$f":"ROUND(IF(H45=\"yes\",IF(F45=\"\",'Incremental Cost'!$I$50,IF(F45=15,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M57*((F45-15)))))),IF(F45=\"\",'Incremental Cost'!$H$50,IF(F45=15,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M57*((F45-15))))))),0)","v":79},"$/ton",{"$f":"D45","v":0},{"$f":"IF((U45*S45)*B45>5000,5000,(U45*S45+IF(G45=\"yes\",250,0))*B45)","v":0},{"$f":"IFERROR(V45/(O45*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U45*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V45+X45)/(O45*Lookups!$M$3),\"\")","v":""}]
["Condensing Units 15 SEER",null,null,null,"tons",null,null,null,null,"","SEER",null,"","",{"$f":"IFERROR(IFERROR(((D46*12000)/1000)*N46*((1/(IF(H46=\"yes\",J46*(1-Lookups!I$9)^(2016-'Non-Lighting Rebate Estimator'!L46),Lookups!$F$30)))-(1/F46)),\"\")*B46,\"\")","v":""},"kWh/unit",1120,"kWh/Unit",{"$f":"ROUND(IF(H46=\"yes\",IF(F46=\"\",'Incremental Cost'!$I$50,IF(F46=15,'Incremental Cost'!$I$50,('Incremental Cost'!$I$50+('Incremental Cost'!$M58*((F46-15)))))),IF(F46=\"\",'Incremental Cost'!$H$50,IF(F46=15,'Incremental Cost'!$H$50,('Incremental Cost'!$H$50+('Incremental Cost'!$M58*((F46-15))))))),0)","v":79},"$/ton",0,{"$f":"IF((U46*S46)*B46>5000,5000,(U46*S46+IF(G46=\"yes\",250,0))*B46)","v":0},{"$f":"IFERROR(V46/(O46*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(U46*'Incremental Cost'!$G$50,\"\")","v":0},{"$f":"IFERROR((V46+X46)/(O46*Lookups!$M$3),\"\")","v":""}]
["Air Side Economizers for all RTU's"]
[null,null,null,"RTU Capacity",null,null,null,null,null,null,null,null,null,null,null,null,"Deemed Savings","Deemed Savings Units"]
["Air Side Economizers for all RTU's",null,null,null,"tons","n/a",null,"n/a","n/a","n/a","n/a",null,{"$f":"IFERROR(VLOOKUP(L49,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C49,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(VLOOKUP(C49,Economizer_Savings_Lookup,2,FALSE)*D49,\"\")*B49,\"\")","v":""},"kwh/unit",250,"kWh/Unit",250,"/unit",null,{"$f":"IF(S49*B49>5000,5000,S49*B49)","v":0},{"$f":"IFERROR(V49/(O49*Lookups!$M$3),\"\")","v":""},0,{"$f":"IFERROR((V49+X49)/(O49*Lookups!$M$3),\"\")","v":""},"• Economizer shall provide first stage cooling. \n• Mechanical cooling will start at second stage. \n• Economizer control shall include an outside air temperature sensor. \n• Replaced equipment must have a fixed fraction outside air intake of at least 5%.\n• Any size air-handling unit will qualify. \n• Installing contractor shall advise owner that yearly preventative \n  maintenance is recommended to ensure proper function over time.\n• This line is intended for economizers added to exisitng units. DO NOT\n  include economizers here that are integral to new AC units recorded above."]
["Air Side Economizers for all RTU's",null,null,null,"tons","n/a",null,"n/a","n/a","n/a","n/a",null,"","",{"$f":"IFERROR(IFERROR(VLOOKUP(C50,Economizer_Savings_Lookup,2,FALSE)*D50,\"\")*B50,\"\")","v":""},"kwh/unit",250,"kWh/Unit",250,"/unit",null,{"$f":"IF(S50*B50>5000,5000,S50*B50)","v":0},{"$f":"IFERROR(V50/(O50*Lookups!$M$3),\"\")","v":""},0,{"$f":"IFERROR((V50+X50)/(O50*Lookups!$M$3),\"\")","v":""},"• Economizer shall provide first stage cooling. \n• Mechanical cooling will start at second stage. \n• Economizer control shall include an outside air temperature sensor. \n• Replaced equipment must have a fixed fraction outside air intake of at least 5%.\n• Any size air-handling unit will qualify. \n• Installing contractor shall advise owner that yearly preventative \n  maintenance is recommended to ensure proper function over time.\n• This line is intended for economizers added to exisitng units. DO NOT\n  include economizers here that are integral to new AC units recorded above."]
["Air Side Economizers for all RTU's",null,null,null,"tons","n/a",null,"n/a","n/a","n/a","n/a",null,{"$f":"IFERROR(VLOOKUP(L51,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C51,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(VLOOKUP(C51,Economizer_Savings_Lookup,2,FALSE)*D51,\"\")*B51,\"\")","v":""},"kwh/unit",250,"kWh/Unit",250,"/unit",null,0,{"$f":"IFERROR(V51/(O51*Lookups!$M$3),\"\")","v":""},0,{"$f":"IFERROR((V51+X51)/(O51*Lookups!$M$3),\"\")","v":""},"• Economizer shall provide first stage cooling. \n• Mechanical cooling will start at second stage. \n• Economizer control shall include an outside air temperature sensor. \n• Replaced equipment must have a fixed fraction outside air intake of at least 5%.\n• Any size air-handling unit will qualify. \n• Installing contractor shall advise owner that yearly preventative \n  maintenance is recommended to ensure proper function over time.\n• This line is intended for economizers added to exisitng units. DO NOT\n  include economizers here that are integral to new AC units recorded above."]
["Air Side Economizers for all RTU's",null,null,null,"tons","n/a",null,"n/a","n/a","n/a","n/a",null,"","",{"$f":"IFERROR(IFERROR(VLOOKUP(C52,Economizer_Savings_Lookup,2,FALSE)*D52,\"\")*B52,\"\")","v":""},"kwh/unit",250,"kWh/Unit",250,"/unit",null,0,{"$f":"IFERROR(V52/(O52*Lookups!$M$3),\"\")","v":""},0,{"$f":"IFERROR((V52+X52)/(O52*Lookups!$M$3),\"\")","v":""},"• Economizer shall provide first stage cooling. \n• Mechanical cooling will start at second stage. \n• Economizer control shall include an outside air temperature sensor. \n• Replaced equipment must have a fixed fraction outside air intake of at least 5%.\n• Any size air-handling unit will qualify. \n• Installing contractor shall advise owner that yearly preventative \n  maintenance is recommended to ensure proper function over time.\n• This line is intended for economizers added to exisitng units. DO NOT\n  include economizers here that are integral to new AC units recorded above."]
["Evaporative coolers"]
[null,null,null,"Exisitng RTU Capacity",null,null,null,null,null,null,null,null,null,null,null,null,"Deemed Savings","Deemed Savings Units"]
["Indirect Evaporative Cooler",null,null,null,"tons","n/a","n/a",null,null,{"$f":"IFERROR(IF(I55=\"\",VLOOKUP(M55,Baseline_Eff_lookup,6,FALSE),I55),\"\")","v":""},"SEER",null,{"$f":"IFERROR(VLOOKUP(L55,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C55,EFLH_lookup,3,FALSE),\"\")","v":""},{"$f":"IFERROR((D55*12000)/1000*N55*(1/(IF(H55=\"yes\",J55*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!L55),VLOOKUP(D55,EvapCooler_lookup,3,FALSE))))-((VLOOKUP(INT(D55),EvapCooler_lookup,2,FALSE))*Lookups!$B$69*Lookups!$B$70/Lookups!$B$71*(VLOOKUP('Non-Lighting Rebate Estimator'!C55,EFLH_lookup,2,FALSE))),\"\")","v":""},"kWh/unit",968,"kWh/1600 cfm",{"$f":"IFERROR(IF(H55=\"Yes\",'Incremental Cost'!H$87,'Incremental Cost'!H$87),\"\")","v":1},"$/cfm",1000,{"$f":"IF((U55*S55)*B55>5000,5000,(U55*S55)*B55)","v":0},{"$f":"IFERROR(V55/(O55*Lookups!$M$3),\"\")","v":""},{"$f":"'Incremental Cost'!F84","v":0},{"$f":"IFERROR((V55+X55)/(O55*Lookups!$M$3),\"\")","v":""},"• Equipment must be permanently installed \n• Equipment must be indirect, hybrid, or two-stage evaporative cooling unit replacing DX cooling equipment.\n• Portable coolers or systems with vapor compression backup are not eligible \n• A minimum Media Saturation Effectiveness of 85% is required \n• Units must be installed with a remote thermostat and a periodic purge water control \n• Only conditioned CFM qualifies for rebate"]
["HVAC Fan VFD"]
["HVAC Fan VFD",null,null,null,"HP / RPM","n/a","n/a","n/a","n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP(L57,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C57,Fan_Operating_Hrs_lookup,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(VLOOKUP(D57,VFD_HP_lookup,2,FALSE)*Lookups!B$52*Lookups!B$58*(1/VLOOKUP(D57,VFD_MotorEff_lookup,3,FALSE))*N57*Lookups!B$55*Lookups!B$56,\"\")*B57,\"\")","v":""},"kWh/unit",".5 - 25","kW",{"$f":"IFERROR(VLOOKUP(D57,VFD_Rebate_lookup,4,FALSE),\"\")","v":""},"$/unit",{"$f":"B57","v":0},{"$f":"IFERROR(IF(U57*S57>5000,5000,U57*S57),\"\")","v":""},{"$f":"IFERROR(V57/(O57*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D57,VFD_Rebate_lookup,5,FALSE),\"\")","v":""},{"$f":"IFERROR((V57+X57)/(O57*Lookups!$M$3),\"\")","v":""},"• Rebates will be offered for new equipment only \n• Motor replacement of currently operating equipment \n• Rebates available for motors and VFDs between 1 and 200 HP \n• Back-up equipment not eligible for rebates \n• Rebates are eligible for HVAC fan applications \n• Customers must scrap the previous motor themselves or have it scrapped by their installer. By signing the application, customers are acknowledging that the motor has been scrapped. "]
["HVAC Fan VFD",null,null,null,"HP / RPM","n/a","n/a","n/a","n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP(L58,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C58,Fan_Operating_Hrs_lookup,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(VLOOKUP(D58,VFD_HP_lookup,2,FALSE)*Lookups!B$52*Lookups!B$58*(1/VLOOKUP(D58,VFD_MotorEff_lookup,3,FALSE))*N58*Lookups!B$55*Lookups!B$56,\"\")*B58,\"\")","v":""},"kWh/unit",".5 - 25","kW",{"$f":"IFERROR(VLOOKUP(D58,VFD_Rebate_lookup,4,FALSE),\"\")","v":""},"$/unit",{"$f":"B58","v":0},{"$f":"IFERROR(IF(U58*S58>5000,5000,U58*S58),\"\")","v":""},{"$f":"IFERROR(V58/(O58*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D58,VFD_Rebate_lookup,5,FALSE),\"\")","v":""},{"$f":"IFERROR((V58+X58)/(O58*Lookups!$M$3),\"\")","v":""},"• Rebates will be offered for new equipment only \n• Motor replacement of currently operating equipment \n• Rebates available for motors and VFDs between 1 and 200 HP \n• Back-up equipment not eligible for rebates \n• Rebates are eligible for HVAC fan applications \n• Customers must scrap the previous motor themselves or have it scrapped by their installer. By signing the application, customers are acknowledging that the motor has been scrapped. "]
["HVAC Fan VFD",null,null,null,"HP / RPM","n/a","n/a","n/a","n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP(L59,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C59,Fan_Operating_Hrs_lookup,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(VLOOKUP(D59,VFD_HP_lookup,2,FALSE)*Lookups!B$52*Lookups!B$58*(1/VLOOKUP(D59,VFD_MotorEff_lookup,3,FALSE))*N59*Lookups!B$55*Lookups!B$56,\"\")*B59,\"\")","v":""},"kWh/unit",".5 - 25","kW",{"$f":"IFERROR(VLOOKUP(D59,VFD_Rebate_lookup,4,FALSE),\"\")","v":""},"$/unit",{"$f":"B59","v":0},"",{"$f":"IFERROR(V59/(O59*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D59,VFD_Rebate_lookup,5,FALSE),\"\")","v":""},{"$f":"IFERROR((V59+X59)/(O59*Lookups!$M$3),\"\")","v":""},"• Rebates will be offered for new equipment only \n• Motor replacement of currently operating equipment \n• Rebates available for motors and VFDs between 1 and 200 HP \n• Back-up equipment not eligible for rebates \n• Rebates are eligible for HVAC fan applications \n• Customers must scrap the previous motor themselves or have it scrapped by their installer. By signing the application, customers are acknowledging that the motor has been scrapped. "]
["HVAC Fan VFD",null,null,null,"HP / RPM","n/a","n/a","n/a","n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP(L60,DateRange_lookup,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C60,Fan_Operating_Hrs_lookup,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IFERROR(VLOOKUP(D60,VFD_HP_lookup,2,FALSE)*Lookups!B$52*Lookups!B$58*(1/VLOOKUP(D60,VFD_MotorEff_lookup,3,FALSE))*N60*Lookups!B$55*Lookups!B$56,\"\")*B60,\"\")","v":""},"kWh/unit",".5 - 25","kW",{"$f":"IFERROR(VLOOKUP(D60,VFD_Rebate_lookup,4,FALSE),\"\")","v":""},"$/unit",{"$f":"B60","v":0},"",{"$f":"IFERROR(V60/(O60*Lookups!$M$3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D60,VFD_Rebate_lookup,5,FALSE),\"\")","v":""},{"$f":"IFERROR((V60+X60)/(O60*Lookups!$M$3),\"\")","v":""},"• Rebates will be offered for new equipment only \n• Motor replacement of currently operating equipment \n• Rebates available for motors and VFDs between 1 and 200 HP \n• Back-up equipment not eligible for rebates \n• Rebates are eligible for HVAC fan applications \n• Customers must scrap the previous motor themselves or have it scrapped by their installer. By signing the application, customers are acknowledging that the motor has been scrapped. "]
["Programmable Thermostat"]
["Measure","# of Units Being Rebated","Building Type","Conditioned Square Feet",null,null,null,null,null,null,null,null,null,null,"Calculated Savings","Calculated Savings Unit","Deemed Savings","Deemed Savings Units","PACE Rebate","Rebate Units","Capacity Units","PACE Reward","$/ ton GHG-saved (PACE Rebate) ","Xcel Rebate","$/ ton GHG-saved (ES+Xcel Rebate) ","Specifications"]
["Programmable Thermostat",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O63*3412","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(D63*VLOOKUP(C63,ProgramThermostat_Savings_lookup,6,FALSE)*B63,\"\")","v":""},"kWh/unit","n/a","n/a",{"$f":"'Incremental Cost'!B94","v":100},"$/unit",{"$f":"B63","v":0},{"$f":"IF((U63*S63)>5000,5000,(U63*S63))","v":0},{"$f":"IFERROR($V$63*($N$63/SUM($N$63:$N$64))/($O$63*Lookups!$M$3),\"\")","v":""},0,{"$f":"IFERROR(($V$63+$X$63)*($N$63/SUM($N$63:$N$64))/($O$63*Lookups!$M$3),\"\")","v":""},"• Rebate offered for elgible programmable thermostats replacing manual thermostats only.\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O64*10*100066","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(D63*VLOOKUP(C63,ProgramThermostat_Savings_lookup,7,FALSE)*B63/10,\"\")","v":""},"dekatherms/ unit",null,null,null,null,null,null,{"$f":"IFERROR($V$63*($N$64/SUM($N$63:$N$64))/(($O$64*10)*Lookups!$M$4),\"\")","v":""},null,{"$f":"IFERROR(($V$63+$X$63)*($N$64/SUM($N$63:$N$64))/(($O$64*10)*Lookups!$M$4),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Estimated Rebate Total\n($5,000 cap per parcel for HVAC projects)",null,null,null,null,{"$f":"IF(SUM(V15:V19,V21:V24,V27:V52,V55:V55,V57:V60,V63)>T8,T8,SUM(V15:V19,V21:V24,V27:V52,V55:V55,V57:V60,V63))","v":0}]
["* This tool is for estimating purposes only and does not serve as a guarantee of a rebate or of final rebate amounts. Rebates will be issued on a first-come, first-served basis until all funding committed. Rebates are contingent on applicants and equipment meeting eligibility requirements. Visit www.PACEYES.com for full terms and conditions."]

{"sheet":"Lookups","index":1,"n_rows":123,"n_cols":18,"rows_kept":123,"cut":false,"hidden":true,"merged":[[1,11,1,12],[1,7,1,9],[20,0,20,13],[64,9,64,12],[96,0,96,3],[22,0,22,2],[22,4,22,13],[30,0,30,1],[33,0,33,7],[60,0,60,3],[76,0,76,3],[35,0,35,3],[41,0,41,3],[45,0,45,3],[65,3,65,5]]}
["Building Type Lookup values"]
["Building Type","Cooling EFLH","Heating EFLH","Fan Operating Hours","EnergySmart Operating Hours",null,null,"Degredation Efficiency:",null,null,null,"Greenhouse Gas Energy Conversion",null,null,null,null,"Install Year","Date Range"]
["Office",868,369,3706,3435,null,null,"From \"Building American Performance Analysis Procedures for Existing Homes\". NREL. May 2006 pgs. 6-14",null,null,null,"kWh to ton of GHG",8.0000000000000004E-4,null,null,null,1920,"Pre 1980"]
["Large Retail",1214,544,5000,4912,null,null,"http://www.nrel.gov/buildings/pdfs/38238.pdf",null,null,null,"therm to ton of GHG",5.3200000000000001E-3,null,null,null,1921,"Pre 1980"]
["Small Retail",860,287,3242,3068,null,null,"Boiler Degradation Equation:","(Base AFUE)*(1-M)^age",null,null,null,null,null,null,null,1922,"Pre 1980"]
["Grocery",1186,482,4777,4612,null,null,"DX Degradation Equation:","(Base Eff)*(1-M)^age",null,null,null,null,null,null,null,1923,"Pre 1980"]
["Restaurant",1094,420,4182,4156,null,null,"Base AFUE: Typical Efficiency of Pre-Retrofit","See Table 5",null,null,null,null,null,null,null,1924,"Pre 1980"]
["Lodging",801,235,2835,2697,null,null,"Base EFF: Pre-retrofit equipment","Original SEER/EER Value",null,null,null,null,null,null,null,1925,"Pre 1980"]
["Healthcare",856,355,3555,3392,null,null,"M: Maintanace Factor (DX)",0.01,null,null,null,null,null,null,null,1926,"Pre 1980"]
["Education",307,253,2264,2080,null,null,"M: Maintanace Factor (Furnace/Boiler)",{"$f":"AVERAGE(J12:J16)","v":5.0000000000000001E-3},null,null,null,null,null,null,null,1927,"Pre 1980"]
["Public Service",868,369,3706,{"$f":"E3","v":3435},null,null,"Table 5: Space Heating Equipment","Base AFUE","Maintanence Factor",null,null,null,null,null,null,1928,"Pre 1980"]
["Churches",790,286,3111,2912,null,null,"Condensing Gas Furnace",90,5.0000000000000001E-3,null,null,null,null,null,null,1929,"Pre 1980"]
["Warehouse",1314,709,5959,5913,null,null,"Gas Furnace, direct vent",80,5.0000000000000001E-3,null,null,null,null,null,null,1930,"Pre 1980"]
["Other Commercial Buildings",660,211,2658,2278,null,null,"Gas Furnace, natural draft",78,5.0000000000000001E-3,null,null,null,null,null,null,1931,"Pre 1980"]
["Heavy Industrial",1336,689,5957,5913,null,null,"Gas hot water boiler, natural draft",80,5.0000000000000001E-3,null,null,null,null,null,null,1932,"Pre 1980"]
["Light Industrial",817,307,3217,3068,null,null,"Condensing gas boiler",90,5.0000000000000001E-3,null,null,null,null,null,null,1933,"Pre 1980"]
["Multifamily",1135,498,4535,4532,null,null,null,null,null,null,null,null,null,null,null,1934,"Pre 1980"]
[null,null,null,null,"Diversity factors and operating hours based on an Xcel Energy study of lighting system operating hours for several facility types (Barakat & Chamberlin 1994)",null,null,null,null,null,null,null,null,null,null,null,1935,"Pre 1980"]
[null,null,null,null,"Interactive Savings from LBNL-39795: Interactions Between Lighting and Space Conditioning Energy Use - Sezgen & Koomey 4/98",null,null,null,null,null,null,null,null,null,null,null,1936,"Pre 1980"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1937,"Pre 1980"]
["Assummed Efficiencies Lookup",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1938,"Pre 1980"]
[null,null,null,null,"<5.4 tons",null,null,null,null,null,null,null,null,null,null,null,1939,"Pre 1980"]
["Boiler Efficiency",null,null,"Furnace Efficiency","Roof Top Units",null,null,null,null,null,null,null,null,null,null,null,1940,"Pre 1980"]
["Equipment Age","Efficiency %        (< 300,000 Btu/h)","Efficiency %        ( >300,000 Btu/h)","Efficiency % (All Sizes)","Unit Size (Cooling Capacity)","Minimum Performace (SEER)","Unit Size (Cooling Capacity)","Minimum Performace (EER)","Unit Size (Cooling Capacity)","Minimum Performace (EER)","Unit Size (Cooling Capacity)","Minimum Performace (EER)","Unit Size (Cooling Capacity)","Minimum Performace (EER)",null,null,1941,"Pre 1980"]
["Pre 1980",0.68,0.72,0.78,"<65,000 Btu/h",10,">65,000 Btu/h and <135,000 Btu/hr",8.3000000000000007,">135,000 Btu/h and <240,000 Btu/hr",8.1999999999999993," <760,000 Btu/hr",8.1999999999999993," >760,000 Btu/hr",8,null,null,1942,"Pre 1980"]
["1980-1988",0.68,0.72,0.78,"<65,000 Btu/h",10,">65,000 Btu/h and <135,000 Btu/hr",8.3000000000000007,">135,000 Btu/h and <240,000 Btu/hr",8.1999999999999993," <760,000 Btu/hr",8.1999999999999993," >760,000 Btu/hr",8,null,null,1943,"Pre 1980"]
["1989-2000",0.8,0.8,0.78,"<65,000 Btu/h",10,">65,000 Btu/h and <135,000 Btu/hr",8.3000000000000007,">135,000 Btu/h and <240,000 Btu/hr",8.5," <760,000 Btu/hr",8.5," >760,000 Btu/hr",8.1999999999999993,null,null,1944,"Pre 1980"]
["2001-2005",0.8,0.8,0.78,"<65,000 Btu/h",10,">65,000 Btu/h and <135,000 Btu/hr",10.3,">135,000 Btu/h and <240,000 Btu/hr",9.6999999999999993,">240,000 Btu/hr and <760,000 Btu/hr",9.5," >760,000 Btu/hr",9.1999999999999993,null,null,1945,"Pre 1980"]
["2006-2010",0.8,0.8,0.78,"<65,000 Btu/h",13,">65,000 Btu/h and <135,000 Btu/hr",10.3,">135,000 Btu/h and <240,000 Btu/hr",9.6999999999999993,">240,000 Btu/hr and <760,000 Btu/hr",9.5," >760,000 Btu/hr",9.3000000000000007,null,null,1946,"Pre 1980"]
["2011 and after",0.8,0.8,0.78,"<65,000 Btu/h",13,">65,000 Btu/h and <135,000 Btu/hr",11,">135,000 Btu/h and <240,000 Btu/hr",10.8,">240,000 Btu/hr and <760,000 Btu/hr",9.5," >760,000 Btu/hr",9.5,null,null,1947,"Pre 1980"]
["Sources: ASHRAE 90.1 (1989, 1999, 2007, 2010)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1948,"Pre 1980"]
[null,null,null,null,5,null,11,null,{"$f":"240/12","v":20},null,null,null,null,null,null,null,1949,"Pre 1980"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1950,"Pre 1980"]
["Savings Algorithms:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1951,"Pre 1980"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1952,"Pre 1980"]
["Boiler/Furnace:",null,null,null,"Source: Xcel Energy CO DSM-2015-2016 Pg. 401",null,null,null,null,null,null,null,null,null,null,null,1953,"Pre 1980"]
["Btu/Hr Upgrade:","Btu/hr_Existing x EFFb/EFFh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1954,"Pre 1980"]
["Btu/Hr Baseline:","Btu/hr_new x EFFh/EFFb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1955,"Pre 1980"]
["New Boiler Savings (Dth):","(Btu/hr_base - Btu/hr_new) x hrs/1,000,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1956,"Pre 1980"]
["Furnace Savings (Dth):","Alt x ((Btu/hr_new x EFFh/EFFb) - Btu/hr_new) x hrs/1,000,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1957,"Pre 1980"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1958,"Pre 1980"]
["Air Conditioning (RTU, Condensing Units, Split Systems):",null,null,null,"Source: Xcel Energy CO DSM-2015-2016 Pg. 401",null,null,null,null,null,null,null,null,null,null,null,1959,"Pre 1980"]
["Gross Annual kWh Saved","Size x EFLH x (1/SEER_standard - 1/SEER_Eff)",null,null,"Economizer SEER Factor",null,null,null,null,null,null,null,null,null,null,null,1960,"Pre 1980"]
["Gross kW Saved","Size x (1/EER_Standard - 1/EER_EFF",null,null,1,null,null,null,null,null,null,null,null,null,null,null,1961,"Pre 1980"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1962,"Pre 1980"]
["VFDs ",null,null,null,"Source: Xcel Energy CO DSM-2015-2016 Pg. 401",null,null,null,null,null,null,null,null,null,null,null,1963,"Pre 1980"]
["Gross Annual kWh Savings per Unit VFD","HP x LF_FanDrive x Conversion x (1/std_eff) x Hrs x %_Savings_Drives x Refrigeration_Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1964,"Pre 1980"]
["Gross Annual kW Savings per unit VFD","HP x LF_FanDrive x Conversion x (1/std_eff) x %_Savings_Drives x Refrigeration_Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1965,"Pre 1980"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1966,"Pre 1980"]
["Variables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1967,"Pre 1980"]
["Hrs","See (Table 2.1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1968,"Pre 1980"]
["LF_Fan Drive",0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1969,"Pre 1980"]
["HP","Customer Input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1970,"Pre 1980"]
["Std_eff","See (Table 2.2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1971,"Pre 1980"]
["%_Savings_Drives",0.33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1972,"Pre 1980"]
["Refrigeration_Factor",{"$f":"1+(1/B57)","v":1.3046428571428572},"=1+1/COP",null,null,null,null,null,null,null,null,null,null,null,null,null,1973,"Pre 1980"]
["COP",{"$f":"11.2/3.412","v":3.2825322391559202},"(for assumed average EER value of 11.2)",null,null,null,null,null,null,null,null,null,null,null,null,null,1974,"Pre 1980"]
["Conversion",0.746,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1975,"Pre 1980"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1976,"Pre 1980"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1977,"Pre 1980"]
["Evap Cooler Algorithm",null,null,null,"Source: Xcel Energy CO DSM-2015-2016 Pg. 401",null,null,null,null,null,null,null,null,null,null,null,1978,"Pre 1980"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1979,"Pre 1980"]
["13 SEER 3 Ton Energy","=Size x EFLH x (1/SEER_standard)",null,"Energy Use of Existing Unit",null,null,"Base DX Capacity (tons)","Evap Cooler Motor HP","Base DX Efficiency",null,null,null,null,null,null,null,1980,"1980-1988"]
["Evap Cooler Energy","=Motor HP x 0.746 x Load Factor / Mottor Eff x OpHr",null,"Energy Use of Evap Cooler",null,null,1,{"$f":"(0.3109*G64)-0.2055","v":0.10540000000000002},{"$f":"$F$30","v":13},"Source: Xcel Energy CO DSM-2015-2016 Pg. 401",null,null,null,null,null,null,1981,"1980-1988"]
[null,null,null,null,null,null,2,{"$f":"(0.3109*G65)-0.2055","v":0.4163},{"$f":"$F$30","v":13},"Table 2.2 to Table 2.4: NEMA Premium Effi (1200/1800/3600 RPM)",null,null,null,null,null,null,1982,"1980-1988"]
[null,null,null,"Evap Cooler ",null,null,3,{"$f":"(0.3109*G66)-0.2055","v":0.72720000000000007},13,"Measure Type","HP","Motor Eff","Boulder Rebate","Xcel Rebate",null,null,1983,"1980-1988"]
["EFLH Front Range:","varies",null,"CFM","HP","Equiv Tons Clg",4,{"$f":"(0.3109*G67)-0.2055","v":1.0381},13,"1 HP 1200 RPM",1,0.82499999999999996,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600},null,null,1984,"1980-1988"]
["Motor HP","varies",null,3600,0.52,3,5,{"$f":"(0.3109*G68)-0.2055","v":1.349},13,"1.5 HP 1200 RPM",1.5,0.86499999999999999,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600},null,null,1985,"1980-1988"]
["HP to kW",0.746,null,6500,1.528,5.4,6,{"$f":"(0.3109*G69)-0.2055","v":1.6599000000000002},{"$f":"$G$32/0.9","v":12.222222222222221},"2 HP 1200 RPM",2,0.875,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600},null,null,1986,"1980-1988"]
["Load Factor",0.8,null,8924.25,2.5,7.4,7,1.9707999999999999,{"$f":"$G$32/0.9","v":12.222222222222221},"3 HP 1200 RPM",3,0.88500000000000001,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600},null,null,1987,"1980-1988"]
["Motor Efficiency",0.8,null,10494.75,2.5,8.6999999999999993,8,2.2817000000000003,12.222222222222221,"5 HP 1200 RPM",5,0.89500000000000002,{"$f":"'Incremental Cost'!$E$56","v":413},{"$f":"'Incremental Cost'!$C$56","v":900},null,null,1988,"1980-1988"]
["CF_AC",0.7,null,13234.5,3,11,9,2.5926000000000005,12.222222222222221,"7.5 HP 1200 RPM",7.5,0.90200000000000002,{"$f":"'Incremental Cost'!$E$57","v":445},{"$f":"'Incremental Cost'!$C$57","v":1130},null,null,1989,"1989-2000"]
["TDLF",7.6999999999999999E-2,null,null,"y=0.3109x-0.2055",null,10,2.9035000000000002,12.222222222222221,"10 HP 1200 RPM",10,0.91700000000000004,{"$f":"'Incremental Cost'!$E$58","v":400},{"$f":"'Incremental Cost'!$C$58","v":1350},null,null,1990,"1989-2000"]
["NTG Tier 1",0.7,null,null,null,null,11,3.2144000000000004,12.222222222222221,"15 HP 1200 RPM",15,0.91700000000000004,{"$f":"'Incremental Cost'!$E$59","v":463},{"$f":"'Incremental Cost'!$C$59","v":1800},null,null,1991,"1989-2000"]
["NTG Tier 2",0.7,null,null,null,null,12,3.5253000000000005,{"$f":"$J$30/0.9","v":12},"20 HP 1200 RPM",20,0.92400000000000004,{"$f":"'Incremental Cost'!$E$60","v":238},{"$f":"'Incremental Cost'!$C$60","v":2300},null,null,1992,"1989-2000"]
[null,null,null,null,null,null,13,3.8362000000000007,{"$f":"$J$30/0.9","v":12},"25 HP 1200 RPM",25,0.93,{"$f":"'Incremental Cost'!$E$61","v":450},{"$f":"'Incremental Cost'!$C$61","v":2750},null,null,1993,"1989-2000"]
["Programmable Thermostats",null,null,null,"Source: Nexant eQuest Model runs",null,null,null,null,"30 HP 1200 RPM",30,0.93600000000000005,{"$f":"'Incremental Cost'!$E$62","v":563},{"$f":"'Incremental Cost'!$C$62","v":3200},null,null,1994,"1989-2000"]
[null,null,null,null,null,null,null,null,null,"40 HP 1200 RPM",40,0.94099999999999995,{"$f":"'Incremental Cost'!$E$63","v":325},{"$f":"'Incremental Cost'!$C$63","v":4000},null,null,1995,"1989-2000"]
[null,"Savings over Occassional Manual Thermostat Setback",null,"Savings over No Manual Thermostat Setback",null,"Weighted Average Savings",null,null,null,"50 HP 1200 RPM",50,0.94099999999999995,{"$f":"'Incremental Cost'!$E$64","v":450},{"$f":"'Incremental Cost'!$C$64","v":4900},null,null,1996,"1989-2000"]
["Building Type","kWh/SF Savings","Therm/SF Savings","kWh/SF Savings","Therm/SF Savings","kWh/SF Savings","Therm/SF Savings",null,null,"60 HP 1200 RPM",60,0.94099999999999995,{"$f":"'Incremental Cost'!$E$65","v":950},{"$f":"'Incremental Cost'!$C$65","v":5600},null,null,1997,"1989-2000"]
["Office",{"$f":"$B$87*(B3/$B$9)","v":0.64680872274143297},{"$f":"$C$87*(C3/$C$9)","v":1.8294084507042254E-2},{"$f":"$D$87*(B3/$B$9)","v":2.3502249221183802},{"$f":"$E$87*(C3/$C$9)","v":7.10281690140845E-2},{"$f":"(0.25*B81+0.75*D81)","v":1.9243708722741433},{"$f":"(0.25*C81+0.75*E81)","v":5.7844647887323943E-2},null,null,"75 HP 1200 RPM",75,0.94499999999999995,{"$f":"'Incremental Cost'!$E$66","v":750},{"$f":"'Incremental Cost'!$C$66","v":6600},null,null,1998,"1989-2000"]
["Large Retail",{"$f":"$B$87*(B4/$B$9)","v":0.90463800623052959},2.6970140845070423E-2,3.2870657320872274,0.10471361502347416,{"$f":"(0.25*B82+0.75*D82)","v":2.6914588006230526},8.5277746478873234E-2,null,null,"100 HP 1200 RPM",100,0.95,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700},null,null,1999,"1989-2000"]
["Small Retail",0.64084735202492216,1.4228732394366199E-2,2.3285638629283492,5.5244131455399061E-2,1.9066347352024924,4.4990281690140847E-2,null,null,"125 HP 1200 RPM",125,0.95,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700},null,null,2000,"1989-2000"]
["Grocery",0.88377320872274157,2.3896338028169015E-2,3.2112520249221186,9.2779342723004685E-2,2.6293823208722746,7.555859154929577E-2,null,null,"150 HP 1200 RPM",150,0.95399999999999996,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700},null,null,2001,"2001-2005"]
["Restaurant",0.81521744548286601,2.0822535211267607E-2,2.9621498442367602,8.0845070422535206E-2,2.4254167445482864,6.5839436619718306E-2,null,null,"200 HP 1200 RPM",200,0.95399999999999996,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700},null,null,2002,"2001-2005"]
["Lodging",0.59688224299065418,1.1650704225352113E-2,2.1688135514018692,4.5234741784037559E-2,1.7758307242990654,3.6838732394366198E-2,null,null,"1 HP 1800 RPM",1,0.85499999999999998,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600},null,null,2003,"2001-2005"]
["Healthcare",0.63786666666666669,1.7600000000000001E-2,2.3177333333333334,6.8333333333333329E-2,1.8977666666666668,5.5649999999999998E-2,null,null,"1.5 HP 1800 RPM",1.5,0.86499999999999999,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600},null,null,2004,"2001-2005"]
["Education",{"$f":"$B$87*(B10/$B$9)","v":0.22876760124610596},{"$f":"$C$87*(C10/$C$9)","v":1.2543098591549298E-2},{"$f":"$D$87*(B10/$B$9)","v":0.83124314641744557},{"$f":"$E$87*(C10/$C$9)","v":4.8699530516431923E-2},0.68062426012461064,3.9660422535211265E-2,null,null,"2 HP 1800 RPM",2,0.86499999999999999,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600},null,null,2005,"2001-2005"]
["Public Service",0.64680872274143297,1.8294084507042254E-2,2.3502249221183802,7.10281690140845E-2,1.9243708722741433,5.7844647887323943E-2,null,null,"3 HP 1800 RPM",3,0.89500000000000002,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600},null,null,2006,"2006-2010"]
["Churches",0.58868535825545176,1.4179154929577466E-2,2.1390295950155762,5.5051643192488259E-2,1.7514435358255451,4.4833521126760562E-2,null,null,"5 HP 1800 RPM",5,0.89500000000000002,{"$f":"'Incremental Cost'!$E$56","v":413},{"$f":"'Incremental Cost'!$C$56","v":900},null,null,2007,"2006-2010"]
["Warehouse",0.97915514018691596,3.5150422535211272E-2,3.5578289719626173,0.13647417840375586,2.913160514018692,0.11114323943661972,null,null,"7.5 HP 1800 RPM",7.5,0.91,{"$f":"'Incremental Cost'!$E$57","v":445},{"$f":"'Incremental Cost'!$C$57","v":1130},null,null,2008,"2006-2010"]
["Other Commercial Buildings",0.49181308411214958,1.0460845070422536E-2,1.7870373831775703,4.0615023474178398E-2,1.4632313084112152,3.3076478873239432E-2,null,null,"10 HP 1800 RPM",10,0.91700000000000004,{"$f":"'Incremental Cost'!$E$58","v":400},{"$f":"'Incremental Cost'!$C$58","v":1350},null,null,2009,"2006-2010"]
["Heavy Industrial",0.9955489096573209,3.4158873239436623E-2,3.6173968847352027,0.13262441314553991,2.9619348909657321,0.10800802816901409,null,null,"15 HP 1800 RPM",15,0.93,{"$f":"'Incremental Cost'!$E$59","v":463},{"$f":"'Incremental Cost'!$C$59","v":1800},null,null,2010,"2006-2010"]
["Light Industrial",0.60880498442367603,1.5220281690140846E-2,2.2121356697819317,5.9093896713615014E-2,1.8113029984423679,4.8125492957746471E-2,null,null,"20 HP 1800 RPM",20,0.93,{"$f":"'Incremental Cost'!$E$60","v":238},{"$f":"'Incremental Cost'!$C$60","v":2300},null,null,2011,"2011 and after"]
["Multifamily",0.8457694704049844,2.4689577464788733E-2,3.0731627725856696,9.5859154929577459E-2,{"$f":"(0.25*B95+0.75*D95)","v":2.5163144470404983},{"$f":"(0.25*C95+0.75*E95)","v":7.8066760563380272E-2},null,null,"25 HP 1800 RPM",25,0.93600000000000005,{"$f":"'Incremental Cost'!$E$61","v":450},{"$f":"'Incremental Cost'!$C$61","v":2750},null,null,2012,"2011 and after"]
[null,null,null,null,null,null,null,null,null,"30 HP 1800 RPM",30,0.94099999999999995,{"$f":"'Incremental Cost'!$E$62","v":563},{"$f":"'Incremental Cost'!$C$62","v":3200}]
["Economizers",null,null,null,"Source: Nexant eQuest Model runs",null,null,null,null,"40 HP 1800 RPM",40,0.94099999999999995,{"$f":"'Incremental Cost'!$E$63","v":325},{"$f":"'Incremental Cost'!$C$63","v":4000}]
["Building Type","Economizer Savings (kWh/ton):",null,null,null,null,null,null,null,"50 HP 1800 RPM",50,0.94499999999999995,{"$f":"'Incremental Cost'!$E$64","v":450},{"$f":"'Incremental Cost'!$C$64","v":4900},null,null,2013,"2011 and after"]
["Office",{"$f":"(B3/$B$13)*$B$109","v":237.05956367326229},null,null,null,null,null,null,null,"60 HP 1800 RPM",60,0.95,{"$f":"'Incremental Cost'!$E$65","v":950},{"$f":"'Incremental Cost'!$C$65","v":5600},null,null,2014,"2011 and after"]
["Large Retail",331.55565702688989,null,null,null,null,null,null,null,"75 HP 1800 RPM",75,0.95,{"$f":"'Incremental Cost'!$E$66","v":750},{"$f":"'Incremental Cost'!$C$66","v":6600},null,null,2015,"2011 and after"]
["Small Retail",234.87468290208017,null,null,null,null,null,null,null,"100 HP 1800 RPM",100,0.95399999999999996,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700},null,null,2016,"2011 and after"]
["Grocery",323.90857432775243,null,null,null,null,null,null,null,"125 HP 1800 RPM",125,0.95399999999999996,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700}]
["Restaurant",298.78244545915777,null,null,null,null,null,null,null,"150 HP 1800 RPM",150,0.95799999999999996,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700}]
["Lodging",218.76118721461188,null,null,null,null,null,null,null,"200 HP 1800 RPM",200,0.95799999999999996,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700}]
["Healthcare",233.78224251648908,null,null,null,null,null,null,null,"1 HP 3600 RPM",1,0.77,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600}]
["Education",83.844799594114662,null,null,null,null,null,null,null,"1.5 HP 36000 RPM",1.5,0.84,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600}]
["Public Service",237.05956367326229,null,null,null,null,null,null,null,"2 HP 3600 RPM",2,0.85499999999999998,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600}]
["Churches",{"$f":"(B12/$B$13)*$B$109","v":215.75697615423644},null,null,null,null,null,null,null,"3 HP 3600 RPM",3,0.85499999999999998,{"$f":"'Incremental Cost'!$E$55","v":613},{"$f":"'Incremental Cost'!$C$55","v":600}]
["Warehouse",{"$f":"10766/30","v":358.86666666666667},null,null,null,null,null,null,null,"5 HP 3600 RPM",5,0.86499999999999999,{"$f":"'Incremental Cost'!$E$56","v":413},{"$f":"'Incremental Cost'!$C$56","v":900}]
["Other Commercial Buildings",{"$f":"(B14/$B$13)*$B$109","v":180.25266362252663},null,null,null,null,null,null,null,"7.5 HP 3600 RPM",7.5,0.88500000000000001,{"$f":"'Incremental Cost'!$E$57","v":445},{"$f":"'Incremental Cost'!$C$57","v":1130}]
["Heavy Industrial",{"$f":"(B15/$B$13)*$B$109","v":364.87508878741755},null,null,null,null,null,null,null,"10 HP 3600 RPM",10,0.89500000000000002,{"$f":"'Incremental Cost'!$E$58","v":400},{"$f":"'Incremental Cost'!$C$58","v":1350}]
["Light Industrial",{"$f":"(B16/$B$13)*$B$109","v":223.13094875697615},null,null,null,null,null,null,null,"15 HP 3600 RPM",15,0.90200000000000002,{"$f":"'Incremental Cost'!$E$59","v":463},{"$f":"'Incremental Cost'!$C$59","v":1800}]
["Multifamily",{"$f":"(B17/$B$13)*$B$109","v":309.97995941146627},null,null,null,null,null,null,null,"20 HP 3600 RPM",20,0.91,{"$f":"'Incremental Cost'!$E$60","v":238},{"$f":"'Incremental Cost'!$C$60","v":2300}]
[null,null,null,null,null,null,null,null,null,"25 HP 3600 RPM",25,0.91700000000000004,{"$f":"'Incremental Cost'!$E$61","v":450},{"$f":"'Incremental Cost'!$C$61","v":2750}]
[null,null,null,null,null,null,null,null,null,"30 HP 3600 RPM",30,0.91700000000000004,{"$f":"'Incremental Cost'!$E$62","v":563},{"$f":"'Incremental Cost'!$C$62","v":3200}]
[null,null,null,null,null,null,null,null,null,"40 HP 3600 RPM",40,0.92400000000000004,{"$f":"'Incremental Cost'!$E$63","v":325},{"$f":"'Incremental Cost'!$C$63","v":4000}]
[null,null,null,null,null,null,null,null,null,"50 HP 3600 RPM",50,0.93,{"$f":"'Incremental Cost'!$E$64","v":450},{"$f":"'Incremental Cost'!$C$64","v":4900}]
[null,null,null,null,null,null,null,null,null,"60 HP 3600 RPM",60,0.93600000000000005,{"$f":"'Incremental Cost'!$E$65","v":950},{"$f":"'Incremental Cost'!$C$65","v":5600}]
[null,null,null,null,null,null,null,null,null,"75 HP 3600 RPM",75,0.93600000000000005,{"$f":"'Incremental Cost'!$E$66","v":750},{"$f":"'Incremental Cost'!$C$66","v":6600}]
[null,null,null,null,null,null,null,null,null,"100 HP 3600 RPM",100,0.93600000000000005,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700}]
[null,null,null,null,null,null,null,null,null,"125 HP 3600 RPM",125,0.94099999999999995,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700}]
[null,null,null,null,null,null,null,null,null,"150 HP 3600 RPM",150,0.94099999999999995,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700}]
[null,null,null,null,null,null,null,null,null,"200 HP 3600 RPM",200,0.95,{"$f":"'Incremental Cost'!$E$67","v":750},{"$f":"'Incremental Cost'!$C$67","v":7700}]

{"sheet":"Incremental Cost","index":2,"n_rows":94,"n_cols":20,"rows_kept":94,"cut":false,"hidden":true,"merged":[[68,6,68,9],[1,7,1,8],[0,0,0,4],[12,0,12,4],[26,0,26,4],[1,3,1,6],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[19,0,19,1],[1,0,1,2],[15,0,15,1],[14,0,14,1],[88,0,88,4],[13,3,13,5],[35,1,35,5],[36,1,36,5],[51,0,51,4],[68,0,68,4],[18,0,18,1],[17,0,17,1],[16,0,16,1]]}
["Table: Hot Water Boiler Cost",null,null,null,null,null,null,null,null,null,"http://www.xcelenergy.com/Energy_Solutions/Business_Solutions/Rebates_&_Energy_Savings/Heating_Efficiency"]
[null,null,null,"Non-Condensing",null,null,null,"Condensing",null,"Incremental ($/kbtu)","Xcel Rebate ($/kbtu)","Boulder Rebate ($/kbtu) - Replace on Burnout","Boulder Rebate ($/kbtu) - Early Replacement"]
["Boiler Nameplate Capacity","kBTU",null,"Baseline - Cost","Baseline Eff. (EFFb)","High Efficient Non Condensing - Cost","High Efficient Non Condensing - Efficiency (EFFh)","High Efficient Condensing - Cost","High Efficient Condensing - Efficiency Cost/kbtu","Baseline to High Efficient - Condensing",null,null,null,null,null,"Bonus Rebate Scaling Factor","Bonus Rebate ($/kbtu)","Min. Efficiency Savings (dekatherms)","Actual Efficiency Savings (dekatherms)","$/GHG Saved (Xcel + ES)"]
["175,000 Btu/hr",175,null,3000,0.8,3500,0.85,4600,{"$f":"H4/B4","v":26.285714285714285},{"$f":"(H4-D4)/B4","v":9.1428571428571423},null,null,null,null,"Boiler, minimum 92% AFUE",1,{"$f":"IFERROR((((S4-R4)*10)*Lookups!$M$4*T4)/'Non-Lighting Rebate Estimator'!$U15*P4,0)","v":0},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D15*1000)*92%/(IF('Non-Lighting Rebate Estimator'!$H15=\"yes\",'Non-Lighting Rebate Estimator'!$J15*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L15),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D15*1000))*'Non-Lighting Rebate Estimator'!$N15/1000000)*'Non-Lighting Rebate Estimator'!$B15,\"\")","v":""},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D15*1000)*'Non-Lighting Rebate Estimator'!$F15/(IF('Non-Lighting Rebate Estimator'!$H15=\"yes\",'Non-Lighting Rebate Estimator'!$J15*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L15),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D15*1000))*'Non-Lighting Rebate Estimator'!$N15/1000000)*'Non-Lighting Rebate Estimator'!$B15,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!$H15=\"yes\",'Incremental Cost'!$M$11*'Non-Lighting Rebate Estimator'!$U15,'Incremental Cost'!$L$11*'Non-Lighting Rebate Estimator'!$U15)+'Non-Lighting Rebate Estimator'!$X15)/(('Non-Lighting Rebate Estimator'!$O15*10)*Lookups!$M$4)","v":{"$error":"#VALUE!"}}]
["500,000 Btu/hr",500,null,5000,0.8,9000,0.85,11200,{"$f":"H5/B5","v":22.4},12.4,null,null,null,null,"Boiler, minimum 92% AFUE",1,{"$f":"IFERROR((((S5-R5)*10)*Lookups!$M$4*T5)/'Non-Lighting Rebate Estimator'!$U16*P5,0)","v":0},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D16*1000)*92%/(IF('Non-Lighting Rebate Estimator'!$H16=\"yes\",'Non-Lighting Rebate Estimator'!$J16*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L16),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D16*1000))*'Non-Lighting Rebate Estimator'!$N16/1000000)*'Non-Lighting Rebate Estimator'!$B16,\"\")","v":""},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D16*1000)*'Non-Lighting Rebate Estimator'!$F16/(IF('Non-Lighting Rebate Estimator'!$H16=\"yes\",'Non-Lighting Rebate Estimator'!$J16*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L16),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D16*1000))*'Non-Lighting Rebate Estimator'!$N16/1000000)*'Non-Lighting Rebate Estimator'!$B16,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!$H16=\"yes\",'Incremental Cost'!$M$11*'Non-Lighting Rebate Estimator'!$U16,'Incremental Cost'!$L$11*'Non-Lighting Rebate Estimator'!$U16)+'Non-Lighting Rebate Estimator'!$X16)/(('Non-Lighting Rebate Estimator'!$O16*10)*Lookups!$M$4)","v":{"$error":"#VALUE!"}}]
["1,000,000 Btu/hr",1000,null,7300,0.8,11700,0.85,15000,15,7.7,null,null,null,null,"Boiler, minimum 92% AFUE",1,{"$f":"IFERROR((((S6-R6)*10)*Lookups!$M$4*T6)/'Non-Lighting Rebate Estimator'!$U17*P6,0)","v":0},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D17*1000)*92%/(IF('Non-Lighting Rebate Estimator'!$H17=\"yes\",'Non-Lighting Rebate Estimator'!$J17*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L17),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D17*1000))*'Non-Lighting Rebate Estimator'!$N17/1000000)*'Non-Lighting Rebate Estimator'!$B17,\"\")","v":""},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D17*1000)*'Non-Lighting Rebate Estimator'!$F17/(IF('Non-Lighting Rebate Estimator'!$H17=\"yes\",'Non-Lighting Rebate Estimator'!$J17*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L17),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D17*1000))*'Non-Lighting Rebate Estimator'!$N17/1000000)*'Non-Lighting Rebate Estimator'!$B17,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!$H17=\"yes\",'Incremental Cost'!$M$11*'Non-Lighting Rebate Estimator'!$U17,'Incremental Cost'!$L$11*'Non-Lighting Rebate Estimator'!$U17)+'Non-Lighting Rebate Estimator'!$X17)/(('Non-Lighting Rebate Estimator'!$O17*10)*Lookups!$M$4)","v":{"$error":"#VALUE!"}}]
["2,000,000 Btu/hr",2000,null,12000,0.8,17000,0.85,26500,13.25,7.25,null,null,null,null,"Boiler, minimum 92% AFUE",1,{"$f":"IFERROR((((S7-R7)*10)*Lookups!$M$4*T7)/'Non-Lighting Rebate Estimator'!$U18*P7,0)","v":0},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D18*1000)*92%/(IF('Non-Lighting Rebate Estimator'!$H18=\"yes\",'Non-Lighting Rebate Estimator'!$J18*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L18),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D18*1000))*'Non-Lighting Rebate Estimator'!$N18/1000000)*'Non-Lighting Rebate Estimator'!$B18,\"\")","v":""},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D18*1000)*'Non-Lighting Rebate Estimator'!$F18/(IF('Non-Lighting Rebate Estimator'!$H18=\"yes\",'Non-Lighting Rebate Estimator'!$J18*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L18),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D18*1000))*'Non-Lighting Rebate Estimator'!$N18/1000000)*'Non-Lighting Rebate Estimator'!$B18,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!$H18=\"yes\",'Incremental Cost'!$M$11*'Non-Lighting Rebate Estimator'!$U18,'Incremental Cost'!$L$11*'Non-Lighting Rebate Estimator'!$U18)+'Non-Lighting Rebate Estimator'!$X18)/(('Non-Lighting Rebate Estimator'!$O18*10)*Lookups!$M$4)","v":{"$error":"#VALUE!"}}]
["4,000,000 Btu/hr",4000,null,24000,0.8,34000,0.85,53000,13.25,7.25,null,null,null,null,"Boiler, minimum 92% AFUE",1,{"$f":"IFERROR((((S8-R8)*10)*Lookups!$M$4*T8)/'Non-Lighting Rebate Estimator'!$U19*P8,0)","v":0},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D19*1000)*92%/(IF('Non-Lighting Rebate Estimator'!$H19=\"yes\",'Non-Lighting Rebate Estimator'!$J19*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L19),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D19*1000))*'Non-Lighting Rebate Estimator'!$N19/1000000)*'Non-Lighting Rebate Estimator'!$B19,\"\")","v":""},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D19*1000)*'Non-Lighting Rebate Estimator'!$F19/(IF('Non-Lighting Rebate Estimator'!$H19=\"yes\",'Non-Lighting Rebate Estimator'!$J19*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L19),Lookups!$B$30)))-('Non-Lighting Rebate Estimator'!$D19*1000))*'Non-Lighting Rebate Estimator'!$N19/1000000)*'Non-Lighting Rebate Estimator'!$B19,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!$H19=\"yes\",'Incremental Cost'!$M$11*'Non-Lighting Rebate Estimator'!$U19,'Incremental Cost'!$L$11*'Non-Lighting Rebate Estimator'!$U19)+'Non-Lighting Rebate Estimator'!$X19)/(('Non-Lighting Rebate Estimator'!$O19*10)*Lookups!$M$4)","v":{"$error":"#VALUE!"}}]
["6,000,000 Btu/hr",6000,null,36000,0.8,51000,0.85,79500,13.25,7.25]
["8,000,000 Btu/hr",8000,null,48000,0.8,68000,0.85,106000,13.25,7.25]
[null,null,null,null,null,null,null,"Average Cost",{"$f":"AVERAGE(I4:I10)","v":16.66938775510204},{"$f":"AVERAGE(J4:J10)","v":8.3204081632653075},3.5,2.5,3]
[]
["Table: Commercial Furnace"]
[null,null,null,"Furnace Cost",null,null,"http://www.xcelenergy.com/Energy_Solutions/Business_Solutions/Rebates_&_Energy_Savings/Heating_Efficiency"]
["Btu Input",null,"Full Cost (92% Furnace)","Btu Input","80% Furnace","Incremental Cost","Xcel Rebate","Boulder Rebate ($/unit) - Replace on Burnout","Boulder Rebate ($/unit) - Early Replacement",null,null,"Bonus Rebate Scaling Factor","Bonus Rebate ($/unit)","Min. Efficiency Savings (dekatherms)","Actual Efficiency Savings (dekatherms)","$/GHG Saved (Xcel + ES)"]
[60000,null,804.95,60000,535,{"$f":"C16-E16","v":269.95000000000005},null,null,null,null,"Natural Gas Furnace <=225 kBTU, minimum 92% AFUE",1,{"$f":"IFERROR(ROUND((($O16-$N16)*10*Lookups!$M$4*$P16/'Non-Lighting Rebate Estimator'!$U21*L16),0),0)","v":0},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D21*1000)*92%/(IF('Non-Lighting Rebate Estimator'!$H21=\"yes\",'Non-Lighting Rebate Estimator'!$J21*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L21),Lookups!$D$30)))-('Non-Lighting Rebate Estimator'!$D21*1000))*'Non-Lighting Rebate Estimator'!$N21/1000000)*'Non-Lighting Rebate Estimator'!$B21,\"\")*'Non-Lighting Rebate Estimator'!$U21","v":{"$error":"#VALUE!"}},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D21*1000)*'Non-Lighting Rebate Estimator'!$F21/(IF('Non-Lighting Rebate Estimator'!$H21=\"yes\",'Non-Lighting Rebate Estimator'!$J21*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L21),Lookups!$D$30)))-('Non-Lighting Rebate Estimator'!$D21*1000))*'Non-Lighting Rebate Estimator'!$N21/1000000)*'Non-Lighting Rebate Estimator'!$B21,\"\")*'Non-Lighting Rebate Estimator'!$U21","v":{"$error":"#VALUE!"}},{"$f":"(IF('Non-Lighting Rebate Estimator'!$H21=\"yes\",'Incremental Cost'!$I$25*'Non-Lighting Rebate Estimator'!U21,'Incremental Cost'!$H$25*'Non-Lighting Rebate Estimator'!U21)+'Non-Lighting Rebate Estimator'!$X21)/(('Non-Lighting Rebate Estimator'!$O21*10)*Lookups!$M$4)","v":{"$error":"#VALUE!"}}]
[70000,null,782.26,60000,535,{"$f":"C17-E17","v":247.26},null,null,null,null,"Natural Gas Furnace <=225 kBTU, minimum 92% AFUE",1,{"$f":"IFERROR(ROUND((($O17-$N17)*10*Lookups!$M$4*$P17/'Non-Lighting Rebate Estimator'!$U22*L17),0),0)","v":0},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D22*1000)*92%/(IF('Non-Lighting Rebate Estimator'!$H22=\"yes\",'Non-Lighting Rebate Estimator'!$J22*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L22),Lookups!$D$30)))-('Non-Lighting Rebate Estimator'!$D22*1000))*'Non-Lighting Rebate Estimator'!$N22/1000000)*'Non-Lighting Rebate Estimator'!$B22,\"\")*'Non-Lighting Rebate Estimator'!$U22","v":{"$error":"#VALUE!"}},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D22*1000)*'Non-Lighting Rebate Estimator'!$F22/(IF('Non-Lighting Rebate Estimator'!$H22=\"yes\",'Non-Lighting Rebate Estimator'!$J22*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L22),Lookups!$D$30)))-('Non-Lighting Rebate Estimator'!$D22*1000))*'Non-Lighting Rebate Estimator'!$N22/1000000)*'Non-Lighting Rebate Estimator'!$B22,\"\")*'Non-Lighting Rebate Estimator'!$U22","v":{"$error":"#VALUE!"}},{"$f":"(IF('Non-Lighting Rebate Estimator'!$H22=\"yes\",'Incremental Cost'!$I$25*'Non-Lighting Rebate Estimator'!U22,'Incremental Cost'!$H$25*'Non-Lighting Rebate Estimator'!U22)+'Non-Lighting Rebate Estimator'!$X22)/(('Non-Lighting Rebate Estimator'!$O22*10)*Lookups!$M$4)","v":{"$error":"#VALUE!"}}]
[80000,null,775.83,75000,575,200.83000000000004,null,null,null,null,"Natural Gas Furnace <=225 kBTU, minimum 92% AFUE",1,{"$f":"IFERROR(ROUND((($O18-$N18)*10*Lookups!$M$4*$P18/'Non-Lighting Rebate Estimator'!$U23*L18),0),0)","v":0},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D23*1000)*92%/(IF('Non-Lighting Rebate Estimator'!$H23=\"yes\",'Non-Lighting Rebate Estimator'!$J23*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L23),Lookups!$D$30)))-('Non-Lighting Rebate Estimator'!$D23*1000))*'Non-Lighting Rebate Estimator'!$N23/1000000)*'Non-Lighting Rebate Estimator'!$B23,\"\")*'Non-Lighting Rebate Estimator'!$U23","v":{"$error":"#VALUE!"}},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D23*1000)*'Non-Lighting Rebate Estimator'!$F23/(IF('Non-Lighting Rebate Estimator'!$H23=\"yes\",'Non-Lighting Rebate Estimator'!$J23*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L23),Lookups!$D$30)))-('Non-Lighting Rebate Estimator'!$D23*1000))*'Non-Lighting Rebate Estimator'!$N23/1000000)*'Non-Lighting Rebate Estimator'!$B23,\"\")*'Non-Lighting Rebate Estimator'!$U23","v":{"$error":"#VALUE!"}},{"$f":"(IF('Non-Lighting Rebate Estimator'!$H23=\"yes\",'Incremental Cost'!$I$25*'Non-Lighting Rebate Estimator'!U23,'Incremental Cost'!$H$25*'Non-Lighting Rebate Estimator'!U23)+'Non-Lighting Rebate Estimator'!$X23)/(('Non-Lighting Rebate Estimator'!$O23*10)*Lookups!$M$4)","v":{"$error":"#VALUE!"}}]
[90000,null,785.68,100000,625,160.67999999999995,null,null,null,null,"Natural Gas Furnace <=225 kBTU, minimum 92% AFUE",1,{"$f":"IFERROR(ROUND((($O19-$N19)*10*Lookups!$M$4*$P19/'Non-Lighting Rebate Estimator'!$U24*L19),0),0)","v":0},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D24*1000)*92%/(IF('Non-Lighting Rebate Estimator'!$H24=\"yes\",'Non-Lighting Rebate Estimator'!$J24*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L24),Lookups!$D$30)))-('Non-Lighting Rebate Estimator'!$D24*1000))*'Non-Lighting Rebate Estimator'!$N24/1000000)*'Non-Lighting Rebate Estimator'!$B24,\"\")*'Non-Lighting Rebate Estimator'!$U24","v":{"$error":"#VALUE!"}},{"$f":"IFERROR((((('Non-Lighting Rebate Estimator'!$D24*1000)*'Non-Lighting Rebate Estimator'!$F24/(IF('Non-Lighting Rebate Estimator'!$H24=\"yes\",'Non-Lighting Rebate Estimator'!$J24*(1-Lookups!$I$10)^(2016-'Non-Lighting Rebate Estimator'!$L24),Lookups!$D$30)))-('Non-Lighting Rebate Estimator'!$D24*1000))*'Non-Lighting Rebate Estimator'!$N24/1000000)*'Non-Lighting Rebate Estimator'!$B24,\"\")*'Non-Lighting Rebate Estimator'!$U24","v":{"$error":"#VALUE!"}},{"$f":"(IF('Non-Lighting Rebate Estimator'!$H24=\"yes\",'Incremental Cost'!$I$25*'Non-Lighting Rebate Estimator'!U24,'Incremental Cost'!$H$25*'Non-Lighting Rebate Estimator'!U24)+'Non-Lighting Rebate Estimator'!$X24)/(('Non-Lighting Rebate Estimator'!$O24*10)*Lookups!$M$4)","v":{"$error":"#VALUE!"}}]
[100000,null,811.8,100000,625,186.79999999999995]
[115000,null,893.02,100000,625,268.02]
[120000,null,912.86,125000,655,257.86]
[125000,null,948.29,125000,655,293.28999999999996]
[140000,null,1079,150000,670,409]
[null,"Avg",{"$f":"AVERAGE(C16:C24)","v":865.9655555555554},null,{"$f":"AVERAGE(E16:E24)","v":611.11111111111109},{"$f":"AVERAGE(F16:F24)","v":254.85444444444445},80,100,120]
[]
["DX Equipment "]
["Table: Deemed Baseline Efficiencies (IECC 2009)",null,null,"Incremental Cost per Ton ($/ton)"]
["Equipment","SEER","EER"]
["Rooftop AC Units, <5.4 tons, 17.0 SEER",13,11.05,{"$f":"79+65","v":144}]
["Rooftop AC Units, 5.5 - 11.3 tons, 12.0 EER ",12.9,11,{"$f":"79+65","v":144}]
["Rooftop AC Units, 11.4 - 20 tons, 12.0 EER ",12.7,10.8,144]
["Split Systems <5.4 tons, 15 SEER",13,11.05,144]
["Condensing Units 15 SEER",13,11.05,144]
[]
[null,"RS Means Green Building Cost Data",null,null,null,null,null,"EER = 0.9 SEER"]
[null,"Full Cost ($)"]
["Equipment","Tons","RTU Cost 13 SEER Baseline ","RTU 13 SEER Full Cost ($/ton)","RTU 15 SEER Full Cost","RTU 15 SEER Full Cost ($/ton)","Xcel Rebate ($/ton)","Bouler Rebate ($/ton) - Replace on Burnout","Bouler Rebate ($/ton) - Early Replacement","Source: CO-DSM Plan 2015/2016 (Deemed Savings Technical Assumptions)",null,"Bonus Rebate Scaling Factor","Bonus Rebate ($/ton)","Min. Efficiency Savings (kWh)","Actual Efficiency Savings (kWh)","$/GHG Saved (Xcel + ES)"]
["3 ton cooling, 60 MBH Heating",3,3850,{"$f":"C39/B39","v":1283.3333333333333},{"$f":"C39+($D$30*B39)","v":4282},{"$f":"E39/B39","v":1427.3333333333333},null,null,null,null,"Rooftop AC Units, <=5.4 tons, 17.0 SEER",1,{"$f":"IFERROR(ROUND((O39-N39)*Lookups!$M$3*P39/'Non-Lighting Rebate Estimator'!U27,0)*L39,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D27*12000)/1000)*'Non-Lighting Rebate Estimator'!$N27*((1/(IF('Non-Lighting Rebate Estimator'!$H27=\"yes\",'Non-Lighting Rebate Estimator'!$J27*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L27),Lookups!$F$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G27=\"Yes\",17*Lookups!$E$44,17))),\"\")*'Non-Lighting Rebate Estimator'!$B27,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D27*12000)/1000)*'Non-Lighting Rebate Estimator'!$N27*((1/(IF('Non-Lighting Rebate Estimator'!$H27=\"yes\",'Non-Lighting Rebate Estimator'!$J27*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L27),Lookups!$F$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G27=\"Yes\",'Non-Lighting Rebate Estimator'!$F27*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F27))),\"\")*'Non-Lighting Rebate Estimator'!$B27,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H27=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U27,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U27)+'Non-Lighting Rebate Estimator'!X27)/(('Non-Lighting Rebate Estimator'!O27)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["4 ton cooling, 95 MBH Heating",4,4525,{"$f":"C40/B40","v":1131.25},5101,1275.25,null,null,null,null,"Rooftop AC Units, <=5.4 tons, 17.0 SEER",1,{"$f":"IFERROR(ROUND((O40-N40)*Lookups!$M$3*P40/'Non-Lighting Rebate Estimator'!U28,0)*L40,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D28*12000)/1000)*'Non-Lighting Rebate Estimator'!$N28*((1/(IF('Non-Lighting Rebate Estimator'!$H28=\"yes\",'Non-Lighting Rebate Estimator'!$J28*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L28),Lookups!$F$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G28=\"Yes\",17*Lookups!$E$44,17))),\"\")*'Non-Lighting Rebate Estimator'!$B28,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D28*12000)/1000)*'Non-Lighting Rebate Estimator'!$N28*((1/(IF('Non-Lighting Rebate Estimator'!$H28=\"yes\",'Non-Lighting Rebate Estimator'!$J28*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L28),Lookups!$F$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G28=\"Yes\",'Non-Lighting Rebate Estimator'!$F28*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F28))),\"\")*'Non-Lighting Rebate Estimator'!$B28,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H28=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U28,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U28)+'Non-Lighting Rebate Estimator'!X28)/(('Non-Lighting Rebate Estimator'!O28)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["5 ton cooling, 112 MBH Heating",5,5275,1055,5995,1199,null,null,null,null,"Rooftop AC Units, <=5.4 tons, 17.0 SEER",1,{"$f":"IFERROR(ROUND((O41-N41)*Lookups!$M$3*P41/'Non-Lighting Rebate Estimator'!U29,0)*L41,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D29*12000)/1000)*'Non-Lighting Rebate Estimator'!$N29*((1/(IF('Non-Lighting Rebate Estimator'!$H29=\"yes\",'Non-Lighting Rebate Estimator'!$J29*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L29),Lookups!$F$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G29=\"Yes\",17*Lookups!$E$44,17))),\"\")*'Non-Lighting Rebate Estimator'!$B29,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D29*12000)/1000)*'Non-Lighting Rebate Estimator'!$N29*((1/(IF('Non-Lighting Rebate Estimator'!$H29=\"yes\",'Non-Lighting Rebate Estimator'!$J29*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L29),Lookups!$F$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G29=\"Yes\",'Non-Lighting Rebate Estimator'!$F29*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F29))),\"\")*'Non-Lighting Rebate Estimator'!$B29,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H29=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U29,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U29)+'Non-Lighting Rebate Estimator'!X29)/(('Non-Lighting Rebate Estimator'!O29)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["6 ton cooling, 140 MBH Heating",6,6200,1033.3333333333333,7064,1177.3333333333333,null,null,null,null,"Rooftop AC Units, <=5.4 tons, 17.0 SEER",1,{"$f":"IFERROR(ROUND((O42-N42)*Lookups!$M$3*P42/'Non-Lighting Rebate Estimator'!U30,0)*L42,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D30*12000)/1000)*'Non-Lighting Rebate Estimator'!$N30*((1/(IF('Non-Lighting Rebate Estimator'!$H30=\"yes\",'Non-Lighting Rebate Estimator'!$J30*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L30),Lookups!$F$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G30=\"Yes\",17*Lookups!$E$44,17))),\"\")*'Non-Lighting Rebate Estimator'!$B30,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D30*12000)/1000)*'Non-Lighting Rebate Estimator'!$N30*((1/(IF('Non-Lighting Rebate Estimator'!$H30=\"yes\",'Non-Lighting Rebate Estimator'!$J30*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L30),Lookups!$F$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G30=\"Yes\",'Non-Lighting Rebate Estimator'!$F30*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F30))),\"\")*'Non-Lighting Rebate Estimator'!$B30,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H30=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U30,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U30)+'Non-Lighting Rebate Estimator'!X30)/(('Non-Lighting Rebate Estimator'!O30)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["7.5 ton cooling, 170 MBH Heating",7.5,8125,1083.3333333333333,9205,1227.3333333333333,null,null,null,null,"Rooftop AC Units, 5.5 - 11.3 tons, 12.0 EER ",1,{"$f":"IFERROR(ROUND((O43-N43)*Lookups!$M$3*P43/'Non-Lighting Rebate Estimator'!U31,0)*L43,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D31*12000)/1000)*'Non-Lighting Rebate Estimator'!$N31*((1/(IF('Non-Lighting Rebate Estimator'!$H31=\"yes\",'Non-Lighting Rebate Estimator'!$J31*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L31),Lookups!$H$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G31=\"Yes\",12*Lookups!$E$44,12))),\"\")*'Non-Lighting Rebate Estimator'!$B31,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D31*12000)/1000)*'Non-Lighting Rebate Estimator'!$N31*((1/(IF('Non-Lighting Rebate Estimator'!$H31=\"yes\",'Non-Lighting Rebate Estimator'!$J31*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L31),Lookups!$H$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G31=\"Yes\",'Non-Lighting Rebate Estimator'!$F31*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F31))),\"\")*'Non-Lighting Rebate Estimator'!$B31,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H31=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U31,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U31)+'Non-Lighting Rebate Estimator'!X31)/(('Non-Lighting Rebate Estimator'!O31)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["8.5 ton cooling, 170 MBH Heating",8.5,8800,1035.2941176470588,10024,1179.2941176470588,null,null,null,null,"Rooftop AC Units, 5.5 - 11.3 tons, 12.0 EER ",1,{"$f":"IFERROR(ROUND((O44-N44)*Lookups!$M$3*P44/'Non-Lighting Rebate Estimator'!U32,0)*L44,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D32*12000)/1000)*'Non-Lighting Rebate Estimator'!$N32*((1/(IF('Non-Lighting Rebate Estimator'!$H32=\"yes\",'Non-Lighting Rebate Estimator'!$J32*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L32),Lookups!$H$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G32=\"Yes\",12*Lookups!$E$44,12))),\"\")*'Non-Lighting Rebate Estimator'!$B32,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D32*12000)/1000)*'Non-Lighting Rebate Estimator'!$N32*((1/(IF('Non-Lighting Rebate Estimator'!$H32=\"yes\",'Non-Lighting Rebate Estimator'!$J32*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L32),Lookups!$H$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G32=\"Yes\",'Non-Lighting Rebate Estimator'!$F32*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F32))),\"\")*'Non-Lighting Rebate Estimator'!$B32,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H32=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U32,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U32)+'Non-Lighting Rebate Estimator'!X32)/(('Non-Lighting Rebate Estimator'!O32)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["10 ton cooling, 200 MBH Heating",10,11600,1160,13040,1304,null,null,null,null,"Rooftop AC Units, 5.5 - 11.3 tons, 12.0 EER ",1,{"$f":"IFERROR(ROUND((O45-N45)*Lookups!$M$3*P45/'Non-Lighting Rebate Estimator'!U33,0)*L45,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D33*12000)/1000)*'Non-Lighting Rebate Estimator'!$N33*((1/(IF('Non-Lighting Rebate Estimator'!$H33=\"yes\",'Non-Lighting Rebate Estimator'!$J33*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L33),Lookups!$H$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G33=\"Yes\",12*Lookups!$E$44,12))),\"\")*'Non-Lighting Rebate Estimator'!$B33,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D33*12000)/1000)*'Non-Lighting Rebate Estimator'!$N33*((1/(IF('Non-Lighting Rebate Estimator'!$H33=\"yes\",'Non-Lighting Rebate Estimator'!$J33*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L33),Lookups!$H$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G33=\"Yes\",'Non-Lighting Rebate Estimator'!$F33*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F33))),\"\")*'Non-Lighting Rebate Estimator'!$B33,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H33=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U33,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U33)+'Non-Lighting Rebate Estimator'!X33)/(('Non-Lighting Rebate Estimator'!O33)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["12.5 ton cooling, 230 MBH Heating",12.5,14900,1192,16700,1336,null,null,null,null,"Rooftop AC Units, 5.5 - 11.3 tons, 12.0 EER ",1,{"$f":"IFERROR(ROUND((O46-N46)*Lookups!$M$3*P46/'Non-Lighting Rebate Estimator'!U34,0)*L46,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D34*12000)/1000)*'Non-Lighting Rebate Estimator'!$N34*((1/(IF('Non-Lighting Rebate Estimator'!$H34=\"yes\",'Non-Lighting Rebate Estimator'!$J34*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L34),Lookups!$H$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G34=\"Yes\",12*Lookups!$E$44,12))),\"\")*'Non-Lighting Rebate Estimator'!$B34,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D34*12000)/1000)*'Non-Lighting Rebate Estimator'!$N34*((1/(IF('Non-Lighting Rebate Estimator'!$H34=\"yes\",'Non-Lighting Rebate Estimator'!$J34*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L34),Lookups!$H$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G34=\"Yes\",'Non-Lighting Rebate Estimator'!$F34*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F34))),\"\")*'Non-Lighting Rebate Estimator'!$B34,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H34=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U34,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U34)+'Non-Lighting Rebate Estimator'!X34)/(('Non-Lighting Rebate Estimator'!O34)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["15 ton cooling, 270 MBH Heating",15,17000,1133.3333333333333,19160,1277.3333333333333,null,null,null,null,"Rooftop AC Units, 11.4 - 20 tons, 12.0 EER ",1,{"$f":"IFERROR(ROUND((O47-N47)*Lookups!$M$3*P47/'Non-Lighting Rebate Estimator'!U35,0)*L47,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D35*12000)/1000)*'Non-Lighting Rebate Estimator'!$N35*((1/(IF('Non-Lighting Rebate Estimator'!$H35=\"yes\",'Non-Lighting Rebate Estimator'!$J35*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L35),Lookups!$J$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G35=\"Yes\",12*Lookups!$E$44,12))),\"\")*'Non-Lighting Rebate Estimator'!$B35,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D35*12000)/1000)*'Non-Lighting Rebate Estimator'!$N35*((1/(IF('Non-Lighting Rebate Estimator'!$H35=\"yes\",'Non-Lighting Rebate Estimator'!$J35*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L35),Lookups!$J$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G35=\"Yes\",'Non-Lighting Rebate Estimator'!$F35*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F35))),\"\")*'Non-Lighting Rebate Estimator'!$B35,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H35=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U35,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U35)+'Non-Lighting Rebate Estimator'!X35)/(('Non-Lighting Rebate Estimator'!O35)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["17.5 ton cooling, 330 MBH Heating",17.5,17800,1017.1428571428571,20320,1161.1428571428571,null,null,null,null,"Rooftop AC Units, 11.4 - 20 tons, 12.0 EER ",1,{"$f":"IFERROR(ROUND((O48-N48)*Lookups!$M$3*P48/'Non-Lighting Rebate Estimator'!U36,0)*L48,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D36*12000)/1000)*'Non-Lighting Rebate Estimator'!$N36*((1/(IF('Non-Lighting Rebate Estimator'!$H36=\"yes\",'Non-Lighting Rebate Estimator'!$J36*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L36),Lookups!$J$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G36=\"Yes\",12*Lookups!$E$44,12))),\"\")*'Non-Lighting Rebate Estimator'!$B36,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D36*12000)/1000)*'Non-Lighting Rebate Estimator'!$N36*((1/(IF('Non-Lighting Rebate Estimator'!$H36=\"yes\",'Non-Lighting Rebate Estimator'!$J36*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L36),Lookups!$J$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G36=\"Yes\",'Non-Lighting Rebate Estimator'!$F36*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F36))),\"\")*'Non-Lighting Rebate Estimator'!$B36,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H36=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U36,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U36)+'Non-Lighting Rebate Estimator'!X36)/(('Non-Lighting Rebate Estimator'!O36)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["20 ton cooling, 360 MBH Heating",20,23800,1190,26680,1334,null,null,null,null,"Rooftop AC Units, 11.4 - 20 tons, 12.0 EER ",1,{"$f":"IFERROR(ROUND((O49-N49)*Lookups!$M$3*P49/'Non-Lighting Rebate Estimator'!U37,0)*L49,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D37*12000)/1000)*'Non-Lighting Rebate Estimator'!$N37*((1/(IF('Non-Lighting Rebate Estimator'!$H37=\"yes\",'Non-Lighting Rebate Estimator'!$J37*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L37),Lookups!$J$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G37=\"Yes\",12*Lookups!$E$44,12))),\"\")*'Non-Lighting Rebate Estimator'!$B37,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D37*12000)/1000)*'Non-Lighting Rebate Estimator'!$N37*((1/(IF('Non-Lighting Rebate Estimator'!$H37=\"yes\",'Non-Lighting Rebate Estimator'!$J37*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L37),Lookups!$J$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G37=\"Yes\",'Non-Lighting Rebate Estimator'!$F37*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F37))),\"\")*'Non-Lighting Rebate Estimator'!$B37,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H37=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U37,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U37)+'Non-Lighting Rebate Estimator'!X37)/(('Non-Lighting Rebate Estimator'!O37)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
[null,null,"Average",{"$f":"AVERAGE(D39:D49)","v":1119.4563916475681},null,{"$f":"AVERAGE(F39:F49)","v":1263.4563916475681},65,{"$f":"D30-G50","v":79},{"$f":"ROUND(F50*30%-G50,0)","v":314},null,"Rooftop AC Units, 11.4 - 20 tons, 12.0 EER ",1,{"$f":"IFERROR(ROUND((O50-N50)*Lookups!$M$3*P50/'Non-Lighting Rebate Estimator'!U38,0)*L50,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D38*12000)/1000)*'Non-Lighting Rebate Estimator'!$N38*((1/(IF('Non-Lighting Rebate Estimator'!$H38=\"yes\",'Non-Lighting Rebate Estimator'!$J38*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L38),Lookups!$J$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G38=\"Yes\",12*Lookups!$E$44,12))),\"\")*'Non-Lighting Rebate Estimator'!$B38,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D38*12000)/1000)*'Non-Lighting Rebate Estimator'!$N38*((1/(IF('Non-Lighting Rebate Estimator'!$H38=\"yes\",'Non-Lighting Rebate Estimator'!$J38*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L38),Lookups!$J$30)))-(1/IF('Non-Lighting Rebate Estimator'!$G38=\"Yes\",'Non-Lighting Rebate Estimator'!$F38*Lookups!$E$44,'Non-Lighting Rebate Estimator'!$F38))),\"\")*'Non-Lighting Rebate Estimator'!$B38,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H38=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U38,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U38)+'Non-Lighting Rebate Estimator'!X38)/(('Non-Lighting Rebate Estimator'!O38)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Split Systems <=5.4 tons, 15 SEER",1,{"$f":"IFERROR(ROUND((O51-N51)*Lookups!$M$3*P51/'Non-Lighting Rebate Estimator'!U39,0)*L51,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D39*12000)/1000)*'Non-Lighting Rebate Estimator'!$N39*((1/(IF('Non-Lighting Rebate Estimator'!$H39=\"yes\",'Non-Lighting Rebate Estimator'!$J39*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L39),Lookups!$F$30)))-(1/15)),\"\")*'Non-Lighting Rebate Estimator'!$B39,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D39*12000)/1000)*'Non-Lighting Rebate Estimator'!$N39*((1/(IF('Non-Lighting Rebate Estimator'!$H39=\"yes\",'Non-Lighting Rebate Estimator'!$J39*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L39),Lookups!$F$30)))-(1/'Non-Lighting Rebate Estimator'!$F39)),\"\")*'Non-Lighting Rebate Estimator'!$B39,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H39=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U39,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U39)+'Non-Lighting Rebate Estimator'!X39)/(('Non-Lighting Rebate Estimator'!O39)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["VFD HVAC Fans",null,null,null,null,null,null,null,null,null,"Split Systems <=5.4 tons, 15 SEER",1,{"$f":"IFERROR(ROUND((O52-N52)*Lookups!$M$3*P52/'Non-Lighting Rebate Estimator'!U40,0)*L52,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D40*12000)/1000)*'Non-Lighting Rebate Estimator'!$N40*((1/(IF('Non-Lighting Rebate Estimator'!$H40=\"yes\",'Non-Lighting Rebate Estimator'!$J40*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L40),Lookups!$F$30)))-(1/15)),\"\")*'Non-Lighting Rebate Estimator'!$B40,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D40*12000)/1000)*'Non-Lighting Rebate Estimator'!$N40*((1/(IF('Non-Lighting Rebate Estimator'!$H40=\"yes\",'Non-Lighting Rebate Estimator'!$J40*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L40),Lookups!$F$30)))-(1/'Non-Lighting Rebate Estimator'!$F40)),\"\")*'Non-Lighting Rebate Estimator'!$B40,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H40=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U40,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U40)+'Non-Lighting Rebate Estimator'!X40)/(('Non-Lighting Rebate Estimator'!O40)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
[null,"RS Means Green Building Cost Data","http://www.xcelenergy.com/staticfiles/xe/PDF/Marketing/CO-Bus-Motors-Drive-Efficiency-Rebate-Application-2015.pdf",null,null,null,null,null,null,null,"Split Systems <=5.4 tons, 15 SEER",1,{"$f":"IFERROR(ROUND((O53-N53)*Lookups!$M$3*P53/'Non-Lighting Rebate Estimator'!U41,0)*L53,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D41*12000)/1000)*'Non-Lighting Rebate Estimator'!$N41*((1/(IF('Non-Lighting Rebate Estimator'!$H41=\"yes\",'Non-Lighting Rebate Estimator'!$J41*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L41),Lookups!$F$30)))-(1/15)),\"\")*'Non-Lighting Rebate Estimator'!$B41,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D41*12000)/1000)*'Non-Lighting Rebate Estimator'!$N41*((1/(IF('Non-Lighting Rebate Estimator'!$H41=\"yes\",'Non-Lighting Rebate Estimator'!$J41*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L41),Lookups!$F$30)))-(1/'Non-Lighting Rebate Estimator'!$F41)),\"\")*'Non-Lighting Rebate Estimator'!$B41,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H41=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U41,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U41)+'Non-Lighting Rebate Estimator'!X41)/(('Non-Lighting Rebate Estimator'!O41)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["VFD Size (HP)","Full Cost ($)","Xcel Rebate","Bouler Rebate  - Replace on Burnout","Bouler Rebate - Early Replacement",null,null,null,null,null,"Split Systems <=5.4 tons, 15 SEER",1,{"$f":"IFERROR(ROUND((O54-N54)*Lookups!$M$3*P54/'Non-Lighting Rebate Estimator'!U42,0)*L54,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D42*12000)/1000)*'Non-Lighting Rebate Estimator'!$N42*((1/(IF('Non-Lighting Rebate Estimator'!$H42=\"yes\",'Non-Lighting Rebate Estimator'!$J42*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L42),Lookups!$F$30)))-(1/15)),\"\")*'Non-Lighting Rebate Estimator'!$B42,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D42*12000)/1000)*'Non-Lighting Rebate Estimator'!$N42*((1/(IF('Non-Lighting Rebate Estimator'!$H42=\"yes\",'Non-Lighting Rebate Estimator'!$J42*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L42),Lookups!$F$30)))-(1/'Non-Lighting Rebate Estimator'!$F42)),\"\")*'Non-Lighting Rebate Estimator'!$B42,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H42=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U42,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U42)+'Non-Lighting Rebate Estimator'!X42)/(('Non-Lighting Rebate Estimator'!O42)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["3 HP",2425,600,"n/a",{"$f":"ROUND(B55*50%-C55,0)","v":613},{"$f":"C55/B55","v":0.24742268041237114},null,null,null,null,"Condensing Units 15 SEER",1,{"$f":"IFERROR(ROUND((O55-N55)*Lookups!$M$3*P55/'Non-Lighting Rebate Estimator'!U43,0)*L55,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D43*12000)/1000)*'Non-Lighting Rebate Estimator'!$N43*((1/(IF('Non-Lighting Rebate Estimator'!$H43=\"yes\",'Non-Lighting Rebate Estimator'!$J43*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L43),Lookups!$F$30)))-(1/15)),\"\")*'Non-Lighting Rebate Estimator'!$B43,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D43*12000)/1000)*'Non-Lighting Rebate Estimator'!$N43*((1/(IF('Non-Lighting Rebate Estimator'!$H43=\"yes\",'Non-Lighting Rebate Estimator'!$J43*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L43),Lookups!$F$30)))-(1/'Non-Lighting Rebate Estimator'!$F43)),\"\")*'Non-Lighting Rebate Estimator'!$B43,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H43=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U43,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U43)+'Non-Lighting Rebate Estimator'!X43)/(('Non-Lighting Rebate Estimator'!O43)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["5 HP",2625,900,"n/a",{"$f":"ROUND(B56*50%-C56,0)","v":413},{"$f":"C56/B56","v":0.34285714285714286},null,null,null,null,"Condensing Units 15 SEER",1,{"$f":"IFERROR(ROUND((O56-N56)*Lookups!$M$3*P56/'Non-Lighting Rebate Estimator'!U44,0)*L56,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D44*12000)/1000)*'Non-Lighting Rebate Estimator'!$N44*((1/(IF('Non-Lighting Rebate Estimator'!$H44=\"yes\",'Non-Lighting Rebate Estimator'!$J44*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L44),Lookups!$F$30)))-(1/15)),\"\")*'Non-Lighting Rebate Estimator'!$B44,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D44*12000)/1000)*'Non-Lighting Rebate Estimator'!$N44*((1/(IF('Non-Lighting Rebate Estimator'!$H44=\"yes\",'Non-Lighting Rebate Estimator'!$J44*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L44),Lookups!$F$30)))-(1/'Non-Lighting Rebate Estimator'!$F44)),\"\")*'Non-Lighting Rebate Estimator'!$B44,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H44=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U44,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U44)+'Non-Lighting Rebate Estimator'!X44)/(('Non-Lighting Rebate Estimator'!O44)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["7.5 HP",3150,1130,"n/a",445,0.35873015873015873,null,null,null,null,"Condensing Units 15 SEER",1,{"$f":"IFERROR(ROUND((O57-N57)*Lookups!$M$3*P57/'Non-Lighting Rebate Estimator'!U45,0)*L57,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D45*12000)/1000)*'Non-Lighting Rebate Estimator'!$N45*((1/(IF('Non-Lighting Rebate Estimator'!$H45=\"yes\",'Non-Lighting Rebate Estimator'!$J45*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L45),Lookups!$F$30)))-(1/15)),\"\")*'Non-Lighting Rebate Estimator'!$B45,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D45*12000)/1000)*'Non-Lighting Rebate Estimator'!$N45*((1/(IF('Non-Lighting Rebate Estimator'!$H45=\"yes\",'Non-Lighting Rebate Estimator'!$J45*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L45),Lookups!$F$30)))-(1/'Non-Lighting Rebate Estimator'!$F45)),\"\")*'Non-Lighting Rebate Estimator'!$B45,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H45=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U45,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U45)+'Non-Lighting Rebate Estimator'!X45)/(('Non-Lighting Rebate Estimator'!O45)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["10 HP",3500,1350,"n/a",400,0.38571428571428573,null,null,null,null,"Condensing Units 15 SEER",1,{"$f":"IFERROR(ROUND((O58-N58)*Lookups!$M$3*P58/'Non-Lighting Rebate Estimator'!U46,0)*L58,0)","v":0},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D46*12000)/1000)*'Non-Lighting Rebate Estimator'!$N46*((1/(IF('Non-Lighting Rebate Estimator'!$H46=\"yes\",'Non-Lighting Rebate Estimator'!$J46*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L46),Lookups!$F$30)))-(1/15)),\"\")*'Non-Lighting Rebate Estimator'!$B46,\"\")","v":""},{"$f":"IFERROR(IFERROR((('Non-Lighting Rebate Estimator'!$D46*12000)/1000)*'Non-Lighting Rebate Estimator'!$N46*((1/(IF('Non-Lighting Rebate Estimator'!$H46=\"yes\",'Non-Lighting Rebate Estimator'!$J46*(1-Lookups!$I$9)^(2016-'Non-Lighting Rebate Estimator'!$L46),Lookups!$F$30)))-(1/'Non-Lighting Rebate Estimator'!$F46)),\"\")*'Non-Lighting Rebate Estimator'!$B46,\"\")","v":""},{"$f":"(IF('Non-Lighting Rebate Estimator'!H46=\"yes\",'Incremental Cost'!$I$50*'Non-Lighting Rebate Estimator'!U46,'Incremental Cost'!$H$50*'Non-Lighting Rebate Estimator'!U46)+'Non-Lighting Rebate Estimator'!X46)/(('Non-Lighting Rebate Estimator'!O46)*Lookups!$M$3)","v":{"$error":"#VALUE!"}}]
["15 HP",4525,1800,"n/a",463,0.39779005524861877]
["20 HP",5075,2300,"n/a",238,0.45320197044334976]
["25 HP",6400,2750,"n/a",450,0.4296875]
["30 HP",7525,3200,"n/a",563,0.42524916943521596]
["40 HP",8650,4000,"n/a",325,0.46242774566473988]
["50 HP",10700,4900,"n/a",450,0.45794392523364486]
["60 HP",13100,5600,"n/a",950,0.42748091603053434]
["75 HP",14700,6600,"n/a",750,0.44897959183673469]
["100 HP",16900,7700,"n/a",750,0.45562130177514792]
[]
["Evaporative Coolers",null,null,null,null,null,"DX Units"]
[null,null,"Incentive Rate",1,null,null,"Tons","CFM Equivalent","RTU Cost 13 SEER Baseline ","RTU 13 SEER Full Cost ($/ton)"]
["From 2014 CA Measure Cost Study, Itron",null,null,null,null,null,{"$f":"B39","v":3},{"$f":"G71*1170","v":3510},3850,{"$f":"I71/H71","v":1.0968660968660968}]
["Direct Evaporative Cooler","Full Cost ($/unit)","Cost/CFM","Xcel Rebate/CFM","Boulder Rebate: Burnout","Boulder Rebate: Early replacement",{"$f":"B40","v":4},{"$f":"G72*1170","v":4680},4525,{"$f":"I72/H72","v":0.96688034188034189}]
["T24 minimum: 13 SEER(11.09 EER) Split System Air Conditioner (for PG&E ROB measures) assumed 2 ton",1268.55085506506,null,null,null,null,5,5850,5275,0.90170940170940173]
["For SCE measures, evap coolers are add-on measures to existing DX systems",0,null,null,null,null,6,7020,6200,0.88319088319088324]
["2,340 CFM, 0.85 media saturation effectiveness (~2 ton equivalent)",1232.8888507205879,{"$f":"B75/2340","v":0.52687557723102052},null,null,null,7.5,8775,8125,0.92592592592592593]
["3,510 CFM, 0.87 media saturation effectiveness (~3 ton equivalent)",1440.236367320588,{"$f":"B76/3510","v":0.41032375137338689},null,null,null,8.5,9945,8800,0.88486676721970836]
["5,850 CFM, 0.9 media saturation effectiveness (~5 ton equivalent)",1830.442510970588,{"$f":"B77/5850","v":0.31289615572146806},null,null,null,10,11700,11600,0.99145299145299148]
["11,700 CFM, 0.9 media saturation effectiveness (~10 ton equivalent)",2622.2911984705879,{"$f":"B78/11700","v":0.22412745286073402},null,null,null,12.5,14625,14900,1.0188034188034187]
["17,550 CFM, 0.9 media saturation effectiveness (~15 ton equivalent)",3414.1398859705878,{"$f":"B79/17550","v":0.19453788524048934},null,null,null,15,17550,17000,0.96866096866096862]
[null,"Average",{"$f":"AVERAGE(C75:C79)","v":0.33375216448541972},{"$f":"D81/1170","v":8.5470085470085472E-2},{"$f":"ROUND((C80-D80)*D70,1)","v":0.2},{"$f":"ROUND(C80*0.3,1)","v":0.1},17.5,20475,17800,0.86935286935286937]
[null,null,null,100,"per ton",null,20,23400,23800,1.017094017094017]
["From 2014 CA Measure Cost Study, Itron",null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(J71:J81)","v":0.95680033474151116}]
["Indirect Evaporative Cooler","DX Cost ($/ton)","DX Cost ($/CFM)","Full Cost ($/unit)","Cost/CFM","Xcel Rebate","Boulder Rebate: Burnout","Boulder Rebate: Early replacement"]
["Absensce of indirect evaporative cooling on T24-compliant HVAC system","n/a","n/a",0]
["indirect evap cooling for make-up air only, 65% effectiveness assumed 3,000 cfm, no gas heat","n/a","n/a",11201.3781008806,{"$f":"D85/3000","v":3.7337927002935332}]
["indirect evap cooling for make-up air only, 65% effectiveness assumed 45,000 cfm, no gas heat","n/a","n/a",127465.526100881,{"$f":"D86/45000","v":2.8325672466862444}]
["Average",{"$f":"D50","v":1119.4563916475681},{"$f":"J82","v":0.95680033474151116},null,{"$f":"AVERAGE(E85:E86)","v":3.2831799734898888},0,1,{"$f":"ROUND(E87*0.3,1)","v":1}]
[]
["Programmable Thermostat"]
["Programmable Thermostat",100,"http://www.homedepot.com/p/Honeywell-Wi-Fi-Programmable-Touchscreen-Thermostat-Free-App-RTH8580WF/203356032"]
["Non-programmable Thermostat",{"$f":"AVERAGE(27,25,25,20)","v":24.25},"http://www.homedepot.com/b/Heating-Venting-Cooling-Thermostats-Non-Programmable-Thermostats/N-5yc1vZc4lt"]
["Incremental Cost  ",{"$f":"B90-B91","v":75.75}]
["Xcel Rebate",0]
["Boulder Rebate $/unit",{"$f":"B90","v":100}]