{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Calculator","INTERNAL Funding Distrubution","Support - Drop Downs","Support - Estimated Savings","Support - Funding Distrubution "],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[30,2,30,4],[31,2,31,4],[57,8,58,8],[50,2,50,4],[51,2,51,4],[48,2,48,4],[46,2,46,4],[47,2,47,4],[66,1,66,2],[67,1,67,2],[49,2,49,4],[44,2,44,4],[45,2,45,4],[57,1,57,2],[65,1,65,2],[54,2,54,4],[60,1,60,2],[53,2,53,4],[66,10,69,15],[25,1,25,5],[69,1,69,2],[62,1,62,2],[63,1,63,2],[61,1,61,2],[55,2,55,4],[27,2,27,4],[65,9,66,9],[68,1,68,2],[28,2,28,4],[29,2,29,4],[42,2,42,4],[43,2,43,4],[34,2,34,4],[32,2,32,4],[64,2,64,8],[17,1,17,5],[12,6,13,7],[11,1,11,5],[18,6,18,7],[35,2,35,4],[59,1,59,2],[26,2,26,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[33,2,33,4],[58,1,58,2],[52,2,52,4],[0,1,0,5],[2,1,2,5],[1,1,1,5],[24,1,24,6],[56,2,56,6],[3,1,3,5],[5,1,5,5],[6,1,6,5],[12,1,12,2],[18,1,18,4],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[36,2,36,4]]}
[null,"INCENTIVE CALCULATOR"]
[null,"Affordable Multifamily "]
[null,"Program Upstate"]
[null,"This is a tool to estimate potential maximum incentives for projects participating in AMP Up. All costs and fees are subject to NYSERDA review and approval. Approved incentives will be provided in the program’s Incentive Offer Letter. Incentive estimates from this tool are not guaranteed."]
[null,"Instructions"]
[null,"1) Enter Total number of units for the project, across all buildings on site."]
[null,"2) Use the dropdown options to select incentive category and measure classification, and enter total construction cost per measure."]
[null,"  Note: Resilience requires the Measure Classification selection to calculate incentives. "]
[null,"  If required, use the + icon on the far left to add more measure rows."]
[null,"3) If applicable, select the Non End-Use support and enter cost."]
[null,"4) If applicable, enter previously received End-Use incentives."]
[]
[null,"Total Estimated Incentive ",null,null,"Project Name (Optional)",null,{"$f":"IF(F14<5,\"A minimum of 5 dwelling units are required to participate in AMP Up. Please including the total number of units in your project.\",\"\")","v":"A minimum of 5 dwelling units are required to participate in AMP Up. Please including the total number of units in your project."}]
[null,"Non End-Use Incentive",{"$f":"E24","v":0},null,"# of Dwelling Units"]
[null,"End-Use Incentive",{"$f":"I63","v":0}]
[null,"Resilience Incentive",{"$f":"J70","v":""}]
[null,"Total",{"$f":"SUM(C14:C16)","v":0}]
[]
[null,"Estimated Non End-Use Incentives ",null,null,null,null,"Previously Received Incentives (for Phased Scopes)"]
[null,"Select Support Type",null,"Total Support Cost ($)","Totals",null,"Appliance"]
[null,null,null,null,{"$f":"IF(D21=\"\",\"\",IF(B21=\"Concierge Services\",MIN(D21,35000),IF(B21=\"Floodproofing Design\",MIN(D21,500000),D21)))","v":""},null,"Prescriptive"]
[null,null,null,null,"",null,"Weatherization"]
[null,null,null,null,{"$f":"IF(D23=\"\",\"\",IF(B23=\"Concierge Services\",MIN(D23,35000),IF(B23=\"Floodproofing Design\",MIN(D23,500000),D23)))","v":""},null,"Electrification "]
[null,"Total Estimated Incentives",null,{"$f":"SUM(D21:D23)","v":0},{"$f":"SUM(E21:E23)","v":0},null,"Deep Retrofit "]
[null,null,null,null,null,null,null,{"$f":"SUM(H20:H24)","v":0}]
[null,"Projected End-Use Workscope",null,null,null,null,"Total Construction Costs ($)"]
[null,"Select Incentive Category","Select Measure Classification",null,null,"Construction Cost ($)",{"$f":"SUM(F28:F56)","v":0},null,null,null,null,"Helper Column",{"$f":"H66","v":"Electrification for Heat Vulnerable Populations"}]
[null,null,null,null,null,null,{"$f":"IF(C28=\"Hurricane Resistant Windows\",\"Enter the cost premium for the windows\",IF(C28=\"Electrification for Heat Vulnerable Populations\",\"Funding calculated from Electrification Incentive Category Cost\",IF(C28=\"Window Replacement \",\"If seeking hurricane resisant window incentive, only enter the base window cost here\",\"\")))","v":""},null,null,null,null,{"$f":"C28","v":0},{"$f":"IF(L28=$M$27,1,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(C29=\"Hurricane Resistant Windows\",\"Enter the cost premium for the windows\",IF(C29=\"Electrification for Heat Vulnerable Populations\",\"Funding calculated from Electrification Incentive Category Cost\",IF(C29=\"Window Replacement \",\"If seeking hurricane resisant window incentive, only enter the base window cost here\",\"\")))","v":""},null,null,null,null,{"$f":"C29","v":0},{"$f":"IF(L29=$M$27,1,0)","v":0}]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,{"$f":"C54","v":0},0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[null,null,null,null,null,null,"",null,null,null,null,0,0]
[]
[null,"Estimated End-Use Incentives",null,"Appliance","Prescriptive","Weatherization","Electrification ","Deep Retrofit ","Totals"]
[null,"Incentive Cap of Total Project Costs",null,{"$f":"IF($F$14<21,0.85,0.7)","v":0.85},{"$f":"IF($F$14<21,0.85,0.7)","v":0.85},{"$f":"IF($F$14<21,0.85,0.7)","v":0.85},{"$f":"IF($F$14<21,0.85,0.7)","v":0.85},{"$f":"IF($F$14<21,0.85,0.7)","v":0.85}]
[null,"Maximum Incentives per Incentive Schedule per dwelling unit",null,400,1750,2500,5750,6750,{"$f":"SUM(D60:H60)","v":17150}]
[null,"Maximum Incentives available for Project",null,{"$f":"(D60*$F$14)-H20","v":0},{"$f":"(E60*$F$14)-H21","v":0},{"$f":"(F60*$F$14)-H22","v":0},{"$f":"(G60*$F$14)-H23","v":0},{"$f":"(H60*$F$14)-H24","v":0},{"$f":"SUM(D61:H61)","v":0}]
[null,"Total Estimated Measure Costs",null,{"$f":"SUM(IF(LEFT($B28:$B56,LEN(D58))=D58,$F$28:$F$56,\"\"))","v":0},{"$f":"SUM(IF(LEFT($B28:$B56,LEN(E58))=E58,$F$28:$F$56,\"\"))","v":0},{"$f":"SUM(IF(LEFT($B28:$B56,LEN(F58))=F58,$F$28:$F$56,\"\"))","v":0},{"$f":"SUM(IF(LEFT($B28:$B56,LEN(G58))=G58,$F$28:$F$56,\"\"))","v":0},{"$f":"SUM(IF(LEFT($B28:$B56,LEN(H58))=H58,$F$28:$F$56,\"\"))","v":0},0]
[null,"Total Estimated Incentives",null,{"$f":"MIN((D62*$D$59),D61)","v":0},{"$f":"MIN((E62*$D$59),E61)","v":0},{"$f":"MIN((F62*$D$59),F61)","v":0},{"$f":"MIN((G62*$G$59),G61)","v":0},{"$f":"MIN((H62*$D$59),H61)","v":0},0]
[null,"Total Remaining Incentives Available",null,{"$f":"D61-D63","v":0},{"$f":"E61-E63","v":0},{"$f":"F61-F63","v":0},{"$f":"G61-G63","v":0},{"$f":"H61-H63","v":0},0]
[]
[null,"Estimated Resilience End-Use Incentives",null,"Heat Pump Floodproofing","Heat Pump Water Heater Floodproofing","Advanced Ventilation Floodproofing","Electrical Panel Elevation","Electrification for Heat Vulnerable Populations","Hurricane Resistant Windows","Totals"]
[null,"Incentive Cap of Total Project Costs",null,1,1,1,{"$f":"IF($F$14<21,0.85,0.7)","v":0.85},0.3,0.5,null,{"$f":"_xlfn.IFNA(IF(OR((SUM(D70:I70)>500000),VLOOKUP(\"Floodproofing Design\",B21:E23,3,FALSE)>500000),\"The combined total Resilience Enhancement end-use incentives and Floodproofing Design Assistance incentives may not exceed $500,000 per project, subject to NYSERDA review and approval.\",\"\"),\"\")","v":""}]
[null,"Total Estimated Measure Costs",null,{"$f":"SUMIF($C$28:$E$56,D66,$F$28:$F$56)","v":0},{"$f":"SUMIF($C$28:$E$56,E66,$F$28:$F$56)","v":0},0,0,{"$f":"IF(SUM(M28:M56)>0,(SUMIF(L28:L56,'Support - Drop Downs'!D51,Calculator!F28:F56)+(SUMIF(L28:L56,'Support - Drop Downs'!D52,Calculator!F28:F56))+SUMIF(L28:L56,'Support - Drop Downs'!D53,Calculator!F28:F56)),0)","v":0},0,{"$f":"SUM(D68:I68)","v":0}]
[null,"Incentive Cap for Electrification H&C Measures Only",null,null,null,null,null,{"$f":"H68*G59","v":0}]
[null,"Total Estimated Incentives",null,{"$f":"D68*D67","v":0},{"$f":"E68*E67","v":0},0,0,{"$f":"IF(((G62-G63)-H67*H68)>=0,H67*H68,IF(G62-G63>0,(G62-G63),0))","v":0},0,{"$f":"_xlfn.IFNA(MIN(SUM(D70:I70),IF((500000-VLOOKUP(\"Floodproofing Design\",B21:E23,3,FALSE))<0,0,500000-VLOOKUP(\"Floodproofing Design\",B21:E23,3,FALSE))),\"\")","v":""}]

{"sheet":"INTERNAL Funding Distrubution","index":1,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":true,"merged":[[4,1,4,5],[5,1,5,5],[12,1,12,5],[3,1,3,5],[42,1,42,8],[34,1,34,7],[18,1,18,2],[19,1,21,1],[22,1,26,1],[27,1,32,1],[35,1,35,7]]}
[null,"Amp Up Incentive Calculator"]
[]
[null,"Instructions"]
[null,"In the Calculator tab,"]
[null,"1) Enter total number of units for the project, across all buildings on site."]
[null,"2) Use the dropdown options to select incentive category and total construction cost per measure. "]
[null,"If the incentive category is Resilience, then also enter the measure classification."]
[null,"If required, use the + icon on the far left to add more measure rows."]
[null,"3) If applicable, select the Non End-Use support and enter cost."]
[null,"4) If applicable, enter previously received End-Use incentives."]
[null,"In the INTERNAL Funding Distribution tab,"]
[null,"5) Select the project stage."]
[null,"6) Update Salesforce and NEIS with the updated project funding and route the contract accordingly. "]
[]
[null,null,{"$f":"Calculator!E13","v":"Project Name (Optional)"},{"$f":"IF(Calculator!F13=\"\",\"\",Calculator!F13)","v":""}]
[null,null,{"$f":"Calculator!E14","v":"# of Dwelling Units"},{"$f":"Calculator!F14","v":0}]
[null,null,"Select Stage ","Initial Application"]
[]
[null,"For Salesforce",null,"Stage 1","Stage 2","Stage 3","Stage 4","Total ","Account","Dept","Fund","NEIS Project ID","Activity","Concate"]
[null,"Non End-Use","Technical Assistance",{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C20,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!C2,VLOOKUP(C20,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!J2),0)","v":0},{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C20,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!D2,VLOOKUP(C20,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!K2),0)","v":0},{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C20,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!E2,VLOOKUP(C20,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!L2),0)","v":0},{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C20,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!F2,VLOOKUP(C20,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!M2),0)","v":0},{"$f":"SUM(D20:G20)","v":0},4210,5500,"EEBEL","EBL029","TECHASSISTUP",{"$f":"_xlfn.CONCAT(I20:M20)","v":"42105500EEBELEBL029TECHASSISTUP"}]
[null,null,"Concierge Services",{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C21,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!C3,VLOOKUP(C21,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!J3),0)","v":0},{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C21,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!D3,VLOOKUP(C21,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!K3),0)","v":0},{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C21,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!E3,VLOOKUP(C21,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!L3),0)","v":0},{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C21,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!F3,VLOOKUP(C21,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!M3),0)","v":0},0,4210,5500,"EEBEL","EBL029","TECHASSISTUP","42105500EEBELEBL029TECHASSISTUP"]
[null,null,"Floodproofing Design",{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C22,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!C4,VLOOKUP(C22,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!J4),0)","v":0},{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C22,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!D4,VLOOKUP(C22,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!K4),0)","v":0},{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C22,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!E4,VLOOKUP(C22,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!L4),0)","v":0},{"$f":"_xlfn.IFNA(IF($D$16<21,VLOOKUP(C22,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!F4,VLOOKUP(C22,Calculator!$B$20:$E$23,3,FALSE)*'Support - Funding Distrubution '!M4),0)","v":0},0,4226,9100,"RGGI",6081,"TECHASSIST","42269100RGGI6081TECHASSIST"]
[null,"End-Use ","Appliance",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C5,'Support - Funding Distrubution '!J5)*IF(COUNTIF(Calculator!$B$28:$B$37,$C23),INDEX(Calculator!$D$61:$H$61,MATCH($C23,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D5,'Support - Funding Distrubution '!K5)*IF(COUNTIF(Calculator!$B$28:$B$37,$C23),INDEX(Calculator!$D$61:$H$61,MATCH($C23,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E5,'Support - Funding Distrubution '!L5)*IF(COUNTIF(Calculator!$B$28:$B$37,$C23),INDEX(Calculator!$D$61:$H$61,MATCH($C23,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F5,'Support - Funding Distrubution '!M5)*IF(COUNTIF(Calculator!$B$28:$B$37,$C23),INDEX(Calculator!$D$61:$H$61,MATCH($C23,Calculator!$D$58:$H$58,0)))","v":0},0,4218,2030,"RGGI",6414,"PROJECTINCENTIV","42182030RGGI6414PROJECTINCENTIV"]
[null,null,"Prescriptive",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C6,'Support - Funding Distrubution '!J6)*IF(COUNTIF(Calculator!$B$28:$B$37,$C24),INDEX(Calculator!$D$61:$H$61,MATCH($C24,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D6,'Support - Funding Distrubution '!K6)*IF(COUNTIF(Calculator!$B$28:$B$37,$C24),INDEX(Calculator!$D$61:$H$61,MATCH($C24,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E6,'Support - Funding Distrubution '!L6)*IF(COUNTIF(Calculator!$B$28:$B$37,$C24),INDEX(Calculator!$D$61:$H$61,MATCH($C24,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F6,'Support - Funding Distrubution '!M6)*IF(COUNTIF(Calculator!$B$28:$B$37,$C24),INDEX(Calculator!$D$61:$H$61,MATCH($C24,Calculator!$D$58:$H$58,0)))","v":0},0,4210,5500,"EEBEL","EBL030","ENDUSEINCENTIVE","42105500EEBELEBL030ENDUSEINCENTIVE"]
[null,null,"Weatherization",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C7,'Support - Funding Distrubution '!J7)*IF(COUNTIF(Calculator!$B$28:$B$37,$C25),INDEX(Calculator!$D$61:$H$61,MATCH($C25,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D7,'Support - Funding Distrubution '!K7)*IF(COUNTIF(Calculator!$B$28:$B$37,$C25),INDEX(Calculator!$D$61:$H$61,MATCH($C25,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E7,'Support - Funding Distrubution '!L7)*IF(COUNTIF(Calculator!$B$28:$B$37,$C25),INDEX(Calculator!$D$61:$H$61,MATCH($C25,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F7,'Support - Funding Distrubution '!M7)*IF(COUNTIF(Calculator!$B$28:$B$37,$C25),INDEX(Calculator!$D$61:$H$61,MATCH($C25,Calculator!$D$58:$H$58,0)))","v":0},0,4210,5500,"EEBEL","EBL030","ENDUSEINCENTIVE","42105500EEBELEBL030ENDUSEINCENTIVE"]
[null,null,"Electrification ",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C8,'Support - Funding Distrubution '!J8)*IF(COUNTIF(Calculator!$B$28:$B$37,$C26),INDEX(Calculator!$D$61:$H$61,MATCH($C26,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D8,'Support - Funding Distrubution '!K8)*IF(COUNTIF(Calculator!$B$28:$B$37,$C26),INDEX(Calculator!$D$61:$H$61,MATCH($C26,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E8,'Support - Funding Distrubution '!L8)*IF(COUNTIF(Calculator!$B$28:$B$37,$C26),INDEX(Calculator!$D$61:$H$61,MATCH($C26,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F8,'Support - Funding Distrubution '!M8)*IF(COUNTIF(Calculator!$B$28:$B$37,$C26),INDEX(Calculator!$D$61:$H$61,MATCH($C26,Calculator!$D$58:$H$58,0)))","v":0},0,4210,5500,"EEBEL","EBL030","ENDUSEINCENTIVE","42105500EEBELEBL030ENDUSEINCENTIVE"]
[null,null,"Deep Retrofit ",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C9,'Support - Funding Distrubution '!J9)*IF(COUNTIF(Calculator!$B$28:$B$37,$C27),INDEX(Calculator!$D$61:$H$61,MATCH($C27,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D9,'Support - Funding Distrubution '!K9)*IF(COUNTIF(Calculator!$B$28:$B$37,$C27),INDEX(Calculator!$D$61:$H$61,MATCH($C27,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E9,'Support - Funding Distrubution '!L9)*IF(COUNTIF(Calculator!$B$28:$B$37,$C27),INDEX(Calculator!$D$61:$H$61,MATCH($C27,Calculator!$D$58:$H$58,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F9,'Support - Funding Distrubution '!M9)*IF(COUNTIF(Calculator!$B$28:$B$37,$C27),INDEX(Calculator!$D$61:$H$61,MATCH($C27,Calculator!$D$58:$H$58,0)))","v":0},0,4210,5500,"EEBEL","EBL030","ENDUSEINCENTIVE","42105500EEBELEBL030ENDUSEINCENTIVE"]
[null,"Resilience ","Heat Pump Floodproofing",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C10,'Support - Funding Distrubution '!J10)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C28,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D10,'Support - Funding Distrubution '!K10)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C28,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E10,'Support - Funding Distrubution '!L10)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C28,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F10,'Support - Funding Distrubution '!M10)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C28,Calculator!$D$66:$I$66,0)))","v":0},0,4210,9100,"RGGI",6081,"ENDUSEINCENTIVE","42109100RGGI6081ENDUSEINCENTIVE"]
[null,null,"Heat Pump Water Heater Floodproofing",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C11,'Support - Funding Distrubution '!J11)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C29,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D11,'Support - Funding Distrubution '!K11)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C29,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E11,'Support - Funding Distrubution '!L11)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C29,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F11,'Support - Funding Distrubution '!M11)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C29,Calculator!$D$66:$I$66,0)))","v":0},0,4210,9100,"RGGI",6081,"ENDUSEINCENTIVE","42109100RGGI6081ENDUSEINCENTIVE"]
[null,null,"Advanced Ventilation Floodproofing",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C12,'Support - Funding Distrubution '!J12)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C30,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D12,'Support - Funding Distrubution '!K12)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C30,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E12,'Support - Funding Distrubution '!L12)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C30,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F12,'Support - Funding Distrubution '!M12)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C30,Calculator!$D$66:$I$66,0)))","v":0},0,4210,9100,"RGGI",6081,"ENDUSEINCENTIVE","42109100RGGI6081ENDUSEINCENTIVE"]
[null,null,"Electrical Panel Elevation",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C13,'Support - Funding Distrubution '!J13)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C31,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D13,'Support - Funding Distrubution '!K13)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C31,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E13,'Support - Funding Distrubution '!L13)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C31,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F13,'Support - Funding Distrubution '!M13)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C31,Calculator!$D$66:$I$66,0)))","v":0},0,4210,9100,"RGGI",6081,"ENDUSEINCENTIVE","42109100RGGI6081ENDUSEINCENTIVE"]
[null,null,"Electrification for Heat Vulnerable Populations",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C14,'Support - Funding Distrubution '!J14)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C32,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D14,'Support - Funding Distrubution '!K14)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C32,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E14,'Support - Funding Distrubution '!L14)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C32,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F14,'Support - Funding Distrubution '!M14)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C32,Calculator!$D$66:$I$66,0)))","v":0},0,4210,9100,"RGGI",6081,"ENDUSEINCENTIVE","42109100RGGI6081ENDUSEINCENTIVE"]
[null,null,"Hurricane Resistant Windows",{"$f":"IF($D$16<21,'Support - Funding Distrubution '!C15,'Support - Funding Distrubution '!J15)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C33,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!D15,'Support - Funding Distrubution '!K15)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C33,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!E15,'Support - Funding Distrubution '!L15)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C33,Calculator!$D$66:$I$66,0)))","v":0},{"$f":"IF($D$16<21,'Support - Funding Distrubution '!F15,'Support - Funding Distrubution '!M15)*IF(COUNTIF(Calculator!$B$28:$B$37,$B$28),INDEX(Calculator!$D$70:$I$70,MATCH($C33,Calculator!$D$66:$I$66,0)))","v":0},0,4210,9100,"RGGI",6081,"ENDUSEINCENTIVE","42109100RGGI6081ENDUSEINCENTIVE"]
[]
[null,"Estimated Savings/Year For Salesforce "]
[null,"These estimates are only entered at Application Stage. At Stage 1 approval, saving will come directly from the EAST. "]
[null,"Incentive Category","Appliance","Prescriptive","Weatherization","Electrification ","Deep Retrofit ","Total"]
[null,"MMBtu Savings/yr",{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF($D$17=\"Stage 1 Approval\",\"\",IF(C37=\"Appliance\",'Support - Estimated Savings'!N6,IF(C37=\"Prescriptive\",SUM('Support - Estimated Savings'!N8,'Support - Estimated Savings'!N16),IF(C37=\"Weatherization\",'Support - Estimated Savings'!N24,IF(C37=\"Electrification \",SUM('Support - Estimated Savings'!N24,'Support - Estimated Savings'!O26),IF(C37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!O36,'Support - Estimated Savings'!N8),\"-\")))))))","v":""},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(D37=\"Appliance\",'Support - Estimated Savings'!N6,IF(D37=\"Prescriptive\",SUM('Support - Estimated Savings'!N8,'Support - Estimated Savings'!N16),IF(D37=\"Weatherization\",'Support - Estimated Savings'!N24,IF(D37=\"Electrification \",SUM('Support - Estimated Savings'!N24,'Support - Estimated Savings'!O26),IF(D37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!O36,'Support - Estimated Savings'!N8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(E37=\"Appliance\",'Support - Estimated Savings'!N6,IF(E37=\"Prescriptive\",SUM('Support - Estimated Savings'!N8,'Support - Estimated Savings'!N16),IF(E37=\"Weatherization\",'Support - Estimated Savings'!N24,IF(E37=\"Electrification \",SUM('Support - Estimated Savings'!N24,'Support - Estimated Savings'!O26),IF(E37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!O36,'Support - Estimated Savings'!N8),\"-\"))))))","v":""},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(F37=\"Appliance\",'Support - Estimated Savings'!N6,IF(F37=\"Prescriptive\",SUM('Support - Estimated Savings'!N8,'Support - Estimated Savings'!N16),IF(F37=\"Weatherization\",'Support - Estimated Savings'!N24,IF(F37=\"Electrification \",SUM('Support - Estimated Savings'!N24,'Support - Estimated Savings'!O26),IF(F37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!O36,'Support - Estimated Savings'!N8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(G37=\"Appliance\",'Support - Estimated Savings'!N6,IF(G37=\"Prescriptive\",SUM('Support - Estimated Savings'!N8,'Support - Estimated Savings'!N16),IF(G37=\"Weatherization\",'Support - Estimated Savings'!N24,IF(G37=\"Electrification \",SUM('Support - Estimated Savings'!N24,'Support - Estimated Savings'!O26),IF(G37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!O36,'Support - Estimated Savings'!N8),\"-\"))))))","v":0},{"$f":"SUM(C38:G38)","v":0}]
[null,"kWh Savings/yr",{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(C37=\"Appliance\",'Support - Estimated Savings'!Q6,IF(C37=\"Prescriptive\",SUM('Support - Estimated Savings'!Q8,'Support - Estimated Savings'!Q16),IF(C37=\"Weatherization\",'Support - Estimated Savings'!Q24,IF(C37=\"Electrification \",SUM('Support - Estimated Savings'!Q24,'Support - Estimated Savings'!R26),IF(C37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!R36,'Support - Estimated Savings'!Q8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(D37=\"Appliance\",'Support - Estimated Savings'!Q6,IF(D37=\"Prescriptive\",SUM('Support - Estimated Savings'!Q8,'Support - Estimated Savings'!Q16),IF(D37=\"Weatherization\",'Support - Estimated Savings'!Q24,IF(D37=\"Electrification \",SUM('Support - Estimated Savings'!Q24,'Support - Estimated Savings'!R26),IF(D37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!R36,'Support - Estimated Savings'!Q8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(E37=\"Appliance\",'Support - Estimated Savings'!Q6,IF(E37=\"Prescriptive\",SUM('Support - Estimated Savings'!Q8,'Support - Estimated Savings'!Q16),IF(E37=\"Weatherization\",'Support - Estimated Savings'!Q24,IF(E37=\"Electrification \",SUM('Support - Estimated Savings'!Q24,'Support - Estimated Savings'!R26),IF(E37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!R36,'Support - Estimated Savings'!Q8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(F37=\"Appliance\",'Support - Estimated Savings'!Q6,IF(F37=\"Prescriptive\",SUM('Support - Estimated Savings'!Q8,'Support - Estimated Savings'!Q16),IF(F37=\"Weatherization\",'Support - Estimated Savings'!Q24,IF(F37=\"Electrification \",SUM('Support - Estimated Savings'!Q24,'Support - Estimated Savings'!R26),IF(F37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!R36,'Support - Estimated Savings'!Q8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(G37=\"Appliance\",'Support - Estimated Savings'!Q6,IF(G37=\"Prescriptive\",SUM('Support - Estimated Savings'!Q8,'Support - Estimated Savings'!Q16),IF(G37=\"Weatherization\",'Support - Estimated Savings'!Q24,IF(G37=\"Electrification \",SUM('Support - Estimated Savings'!Q24,'Support - Estimated Savings'!R26),IF(G37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!R36,'Support - Estimated Savings'!Q8),\"-\"))))))","v":0},{"$f":"SUM(C39:G39)","v":0}]
[null,"Demand kW/yr",{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(C37=\"Appliance\",'Support - Estimated Savings'!T6,IF(C37=\"Prescriptive\",SUM('Support - Estimated Savings'!T8,'Support - Estimated Savings'!T16),IF(C37=\"Weatherization\",'Support - Estimated Savings'!T24,IF(C37=\"Electrification \",SUM('Support - Estimated Savings'!T24,'Support - Estimated Savings'!U26),IF(C37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!U36,'Support - Estimated Savings'!T8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(D37=\"Appliance\",'Support - Estimated Savings'!T6,IF(D37=\"Prescriptive\",SUM('Support - Estimated Savings'!T8,'Support - Estimated Savings'!T16),IF(D37=\"Weatherization\",'Support - Estimated Savings'!T24,IF(D37=\"Electrification \",SUM('Support - Estimated Savings'!T24,'Support - Estimated Savings'!U26),IF(D37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!U36,'Support - Estimated Savings'!T8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(E37=\"Appliance\",'Support - Estimated Savings'!T6,IF(E37=\"Prescriptive\",SUM('Support - Estimated Savings'!T8,'Support - Estimated Savings'!T16),IF(E37=\"Weatherization\",'Support - Estimated Savings'!T24,IF(E37=\"Electrification \",SUM('Support - Estimated Savings'!T24,'Support - Estimated Savings'!U26),IF(E37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!U36,'Support - Estimated Savings'!T8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(F37=\"Appliance\",'Support - Estimated Savings'!T6,IF(F37=\"Prescriptive\",SUM('Support - Estimated Savings'!T8,'Support - Estimated Savings'!T16),IF(F37=\"Weatherization\",'Support - Estimated Savings'!T24,IF(F37=\"Electrification \",SUM('Support - Estimated Savings'!T24,'Support - Estimated Savings'!U26),IF(F37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!U36,'Support - Estimated Savings'!T8),\"-\"))))))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",IF(G37=\"Appliance\",'Support - Estimated Savings'!T6,IF(G37=\"Prescriptive\",SUM('Support - Estimated Savings'!T8,'Support - Estimated Savings'!T16),IF(G37=\"Weatherization\",'Support - Estimated Savings'!T24,IF(G37=\"Electrification \",SUM('Support - Estimated Savings'!T24,'Support - Estimated Savings'!U26),IF(G37=\"Deep Retrofit \",SUM('Support - Estimated Savings'!U36,'Support - Estimated Savings'!T8),\"-\"))))))","v":0},0]
[null,"Total MMBtu Savings/yr",{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",SUM(C38,C39*3412/1000000))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",SUM(D38,D39*3412/1000000))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",SUM(E38,E39*3412/1000000))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",SUM(F38,F39*3412/1000000))","v":0},{"$f":"IF($D$17=\"Stage 1 Approval\",\"\",SUM(G38,G39*3412/1000000))","v":0}]
[]
[null,"For NEIS"]
[null,"Account","Dept","Fund","NEIS Project ID","Activity","Encumber","Pre-Encumber","Total",null,null,null,null,"Concate"]
[null,4210,5500,"EEBEL","EBL029","TECHASSISTUP",{"$f":"IF(OR($D$17=\"\",$D$17=\"Initial Application\"),SUMIF($N$20:$N$33,N45,$H$20:$H$33),SUMIF($N$20:$N$33,N45,$H$20:$H$33))","v":0},{"$f":"(SUMIF($N$20:$N$33,N45,$H$20:$H$33)-G45)","v":0},{"$f":"SUM(G45:H45)","v":0},null,null,null,null,{"$f":"_xlfn.CONCAT(B45:F45)","v":"42105500EEBELEBL029TECHASSISTUP"}]
[null,4226,9100,"RGGI",6081,"TECHASSIST",{"$f":"IF(OR($D$17=\"\",$D$17=\"Initial Application\"),SUMIF($N$20:$N$33,N46,$H$20:$H$33),SUMIF($N$20:$N$33,N46,$H$20:$H$33))","v":0},{"$f":"(SUMIF($N$20:$N$33,N46,$H$20:$H$33)-G46)","v":0},{"$f":"SUM(G46:H46)","v":0},null,null,null,null,{"$f":"_xlfn.CONCAT(B46:F46)","v":"42269100RGGI6081TECHASSIST"}]
[null,4218,2030,"RGGI",6414,"PROJECTINCENTIV",{"$f":"IF(OR($D$17=\"\",$D$17=\"Initial Application\"),0,SUMIF($N$20:$N$33,N47,$H$20:$H$33))","v":0},{"$f":"(SUMIF($N$20:$N$33,N47,$H$20:$H$33)-G47)","v":0},0,null,null,null,null,{"$f":"_xlfn.CONCAT(B47:F47)","v":"42182030RGGI6414PROJECTINCENTIV"}]
[null,4210,5500,"EEBEL","EBL030","ENDUSEINCENTIVE",{"$f":"IF(OR($D$17=\"\",$D$17=\"Initial Application\"),0,SUMIF($N$20:$N$33,N48,$H$20:$H$33))","v":0},{"$f":"(SUMIF($N$20:$N$33,N48,$H$20:$H$33)-G48)","v":0},0,null,null,null,null,{"$f":"_xlfn.CONCAT(B48:F48)","v":"42105500EEBELEBL030ENDUSEINCENTIVE"}]
[null,4210,9100,"RGGI",6081,"ENDUSEINCENTIVE",{"$f":"IF(OR($D$17=\"\",$D$17=\"Initial Application\"),0,SUMIF($N$20:$N$33,N49,$H$20:$H$33))","v":0},{"$f":"(SUMIF($N$20:$N$33,N49,$H$20:$H$33)-G49)","v":0},0,null,null,null,null,{"$f":"_xlfn.CONCAT(B49:F49)","v":"42109100RGGI6081ENDUSEINCENTIVE"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G45:G49)","v":0},{"$f":"SUM(H45:H49)","v":0},0]

{"sheet":"Support - Drop Downs","index":2,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Appliance and Plug-Load",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,\" \",\"\"),\"-\",\"\"),\"/\",\"\")","v":"ApplianceandPlugLoad"},"Refrigerator (w. Freezer)",null,null,null,{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(B2:B20))","v":"Appliance and Plug-Load"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(C2:C20))","v":"ApplianceandPlugLoad"}]
[null,"Domestic Hot Water - Controls","DomesticHotWaterControls","Efficient-flow showerheads",null,null,null,"Domestic Hot Water - Controls","DomesticHotWaterControls"]
[null,"Domestic Hot Water - Controls","DomesticHotWaterControls","Faucet aerators",null,null,null,"Envelope/Shell","EnvelopeShell"]
[null,"Domestic Hot Water - Controls","DomesticHotWaterControls","Thermostatic Shower Restriction Valve",null,null,null,"Heating and Cooling","HeatingandCooling"]
[null,"Envelope/Shell","EnvelopeShell","Room (RAC) Cover and Gap Sealer",null,null,null,"Heating and Cooling - Controls","HeatingandCoolingControls"]
[null,"Envelope/Shell","EnvelopeShell","Heating/Cooling, Steam Pipe Insulation",null,null,null,"Lighting","Lighting"]
[null,"Heating and Cooling","HeatingandCooling","Primary HVAC combustion tune-up (Boiler/Furnace)"]
[null,"Heating and Cooling - Controls","HeatingandCoolingControls","Advanced Thermostat"]
[null,"Heating and Cooling - Controls","HeatingandCoolingControls","Install TRVs or radiator valves",null,null,null,"ApplianceandPlugLoad","DomesticHotWaterControls","EnvelopeShell","HeatingandCooling","HeatingandCoolingControls","Lighting"]
[null,"Heating and Cooling - Controls","HeatingandCoolingControls","Steam Trap - Low Pressure",null,null,null,"Refrigerator (w. Freezer)","Efficient-flow showerheads","Airsealing","Primary HVAC combustion tune-up (Boiler/Furnace)","Advanced Thermostat","Exterior Lighting"]
[null,"Lighting","Lighting","Exterior Lighting",null,null,null,null,"Faucet aerators","Duct Sealing and Insulation",null,"Install TRVs or radiator valves","Interior Lighting"]
[null,"Lighting","Lighting","Interior Lighting",null,null,null,null,"Thermostatic Shower Restriction Valve","Heating/Cooling, Steam Pipe Insulation",null,"Steam Trap - Low Pressure"]
[null,"Envelope/Shell","EnvelopeShell","Airsealing",null,null,null,null,null,"Insulation (Attic Access)"]
[null,"Envelope/Shell","EnvelopeShell","Duct Sealing and Insulation",null,"MeasureType1","Non End Use Incentive Category",null,null,"Insulation (basement)"]
[null,"Envelope/Shell","EnvelopeShell","Insulation (Attic Access)",null,"Deep Retrofit","Technical Assistance",null,null,"Insulation (roof)"]
[null,"Envelope/Shell","EnvelopeShell","Insulation (basement)",null,"Electrification - DHW","Concierge Services",null,null,"Insulation (Wall)"]
[null,"Envelope/Shell","EnvelopeShell","Insulation (roof)",null,"Electrification - H&C","Floodproofing Design",null,null,"Room (RAC) Cover and Gap Sealer"]
[null,"Envelope/Shell","EnvelopeShell","Insulation (Wall)",null,"Prescriptive",null,null,null,"Window Replacement"]
[null,"Envelope/Shell","EnvelopeShell","Window Replacement",null,"Resilience Enhancement"]
[null,null,null,null,null,"Weatherization"]
[]
[]
[]
[]
[]
[]
[null,"Incentive Category","Measure Category","Measure Classification"]
[null,"Appliance","Appliances","Refrigerator (w. Freezer)",null,"Measure Type",null,{"$f":"TRANSPOSE(_xlfn._xlws.SORT(_xlfn.UNIQUE(B29:B61)))","v":"Appliance"},"Deep Retrofit ","Electrification ","Prescriptive","Resilience ","Weatherization"]
[null,"Prescriptive","Hot Water","Efficient-flow showerheads",null,"MeasureType",null,{"$f":"SUBSTITUTE(SUBSTITUTE(H29,\" \",\"\"),\"-\",\"\")","v":"Appliance"},{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(I29,\" \",\"\"),\"-\",\"\"),\"&\",\"_\")","v":"DeepRetrofit"},{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(J29,\" \",\"\"),\"-\",\"\"),\"&\",\"_\")","v":"Electrification"},{"$f":"SUBSTITUTE(SUBSTITUTE(K29,\" \",\"\"),\"-\",\"\")","v":"Prescriptive"},"Resilience","Weatherization",""]
[null,"Prescriptive","Hot Water","Faucet aerators",null,{"$f":"\"Support!\"&SUBSTITUTE(CELL(\"address\",F32),\"$\",\"\")&\"#\"","v":"Support!F32#"},null,{"$f":"\"Support!\"&SUBSTITUTE(CELL(\"address\",H32),\"$\",\"\")&\"#\"","v":"Support!H32#"},{"$f":"\"Support!\"&SUBSTITUTE(CELL(\"address\",I32),\"$\",\"\")&\"#\"","v":"Support!I32#"},{"$f":"\"Support!\"&SUBSTITUTE(CELL(\"address\",J32),\"$\",\"\")&\"#\"","v":"Support!J32#"},{"$f":"\"Support!\"&SUBSTITUTE(CELL(\"address\",K32),\"$\",\"\")&\"#\"","v":"Support!K32#"},{"$f":"\"Support!\"&SUBSTITUTE(CELL(\"address\",L32),\"$\",\"\")&\"#\"","v":"Support!L32#"},{"$f":"\"Support!\"&SUBSTITUTE(CELL(\"address\",M32),\"$\",\"\")&\"#\"","v":"Support!M32#"},{"$f":"\"Support!\"&SUBSTITUTE(CELL(\"address\",N32),\"$\",\"\")&\"#\"","v":"Support!N32#"}]
[null,"Prescriptive","Hot Water","Thermostatic Shower Restriction Valve",null,{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(B29:B61))","v":"Appliance"},null,{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER($D$29:$D$61,($B$29:$B$61)=H29)))","v":"Refrigerator (w. Freezer)"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER($D$29:$D$61,($B$29:$B$61)=I29)))","v":"Advanced Ventilation with Heat or Energy Recovery"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER($D$29:$D$61,($B$29:$B$61)=J29)))","v":"ASHP"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER($D$29:$D$61,($B$29:$B$61)=K29)))","v":"Advanced Thermostat"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER($D$29:$D$61,($B$29:$B$61)=L29)))","v":"Advanced Ventilation Floodproofing"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER($D$29:$D$61,($B$29:$B$61)=M29)))","v":"Airsealing"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER($D$29:$D$61,($B$29:$B$61)=N29)))","v":{"$error":"#VALUE!"}}]
[null,"Prescriptive","Envelope/Shell","Room (RAC) Cover and Gap Sealer",null,"Deep Retrofit ",null,null,"Envelope – overclad (Insulation - Opaque Shell)","ASHP - HPWH","Efficient-flow showerheads","Electrical Panel Elevation","Duct Sealing and Insulation"]
[null,"Prescriptive","HVAC","Heating/Cooling, Steam Pipe Insulation",null,"Electrification ",null,null,null,"GSHP","Exterior Lighting","Electrification for Heat Vulnerable Populations","Insulation (Attic Access)"]
[null,"Prescriptive","HVAC","Primary HVAC combustion tune-up (Boiler/Furnace)",null,"Prescriptive",null,null,null,"GSHP - HPWH","Faucet aerators","Heat Pump Floodproofing","Insulation (basement)"]
[null,"Prescriptive","Controls","Advanced Thermostat",null,"Resilience ",null,null,null,"PTHP","Heating/Cooling, Steam Pipe Insulation","Heat Pump Water Heater Floodproofing","Insulation (roof)"]
[null,"Prescriptive","Controls","Install TRVs or radiator valves",null,"Weatherization",null,null,null,"WSHP - HPWH","Install TRVs or radiator valves","Hurricane Resistant Windows","Insulation (Wall) "]
[null,"Prescriptive","Controls","Steam Trap - Low Pressure",null,null,null,null,null,null,"Interior Lighting",null,"Window Replacement "]
[null,"Prescriptive","Lighting","Exterior Lighting",null,null,null,null,null,null,"Primary HVAC combustion tune-up (Boiler/Furnace)"]
[null,"Prescriptive","Lighting","Interior Lighting",null,null,null,null,null,null,"Room (RAC) Cover and Gap Sealer"]
[null,"Weatherization","Envelope/Shell","Airsealing",null,null,null,null,null,null,"Steam Trap - Low Pressure"]
[null,"Weatherization","HVAC","Duct Sealing and Insulation",null,null,null,null,null,null,"Thermostatic Shower Restriction Valve"]
[null,"Weatherization","Envelope/Shell","Insulation (Attic Access)"]
[null,"Weatherization","Envelope/Shell","Insulation (basement)",null,null,"Initial Application"]
[null,"Weatherization","Envelope/Shell","Insulation (roof)",null,null,"Stage 1 Approval"]
[null,"Weatherization","Envelope/Shell","Insulation (Wall) "]
[null,"Weatherization","Envelope/Shell","Window Replacement ",null,{"$f":"INDIRECT(INDIRECT(\"MeasureType\"))","v":{"$error":"#REF!"}}]
[null,"Electrification ","Hot Water - Electrification","ASHP - HPWH"]
[null,"Electrification ","Hot Water - Electrification","WSHP - HPWH"]
[null,"Electrification ","Hot Water - Electrification","GSHP - HPWH"]
[null,"Electrification ","Heating and Cooling - Electrification","ASHP"]
[null,"Electrification ","Heating and Cooling - Electrification","PTHP"]
[null,"Electrification ","Heating and Cooling - Electrification","GSHP"]
[null,"Deep Retrofit ","HVAC","Advanced Ventilation with Heat or Energy Recovery"]
[null,"Deep Retrofit ","Envelope/Shell","Envelope – overclad (Insulation - Opaque Shell)"]
[null,"Resilience ","Heating and Cooling - Electrification","Heat Pump Floodproofing"]
[null,"Resilience ","Hot Water - Electrification","Heat Pump Water Heater Floodproofing"]
[null,"Resilience ","HVAC","Advanced Ventilation Floodproofing"]
[null,"Resilience ","Electrical Infrastructure","Electrical Panel Elevation"]
[null,"Resilience ","Heating and Cooling - Electrification","Electrification for Heat Vulnerable Populations"]
[null,"Resilience ","Envelope/Shell ","Hurricane Resistant Windows"]

{"sheet":"Support - Estimated Savings","index":3,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":true,"merged":[[2,4,2,12],[2,13,2,21],[3,4,3,6],[3,7,3,9],[3,10,3,12],[3,13,3,15],[3,16,3,18],[3,19,3,21]]}
["* Data from \"AMP Up Estimated Savings Calculator Rev0\" Excel sent to Pam Miller and Jackie Albanese from Eva Spazzarini on 4/2/2026. Email titled \"AMP Up - Estimated Savings\""]
[]
[null,null,null,null,"Salesforce Estimated Savings Inputs (per unit per year)",null,null,null,null,null,null,null,null,"Salesforce Estimated Savings Inputs per year"]
[null,null,null,null,"MMBtu",null,null,"kWh",null,null,"Demand kW",null,null,"MMBtu",null,null,"kWh",null,null,"Demand kW"]
["Measure #","Incentive Category","Measure Category","Measure Classification","Low","Mid","High","Low","Mid","High","Low","Mid","High","Low","Mid","High","Low","Mid","High","Low","Mid","High","Low Total MMBtu","Mid Total MMBtu","High Total MMBtu","Included in Results table above?","Total MMBtu Savings Low","Total MMBtu Savings Mid","Total MMBtu Savings Mid"]
[1,"Appliance","Appliances","Refrigerator (w. Freezer)","-","-","-",73.2072,73.2072,73.2072,1.5591900000000001E-2,1.5591900000000001E-2,1.5591900000000001E-2,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E6,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F6,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G6,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H6,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I6,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J6,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K6,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L6,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M6,2),\"\")","v":0},{"$f":"IFERROR(VALUE(Q6),0)*3412/1000000+IFERROR(VALUE(N6),0)","v":0},{"$f":"IFERROR(VALUE(R6),0)*3412/1000000+IFERROR(VALUE(O6),0)","v":0},{"$f":"IFERROR(VALUE(S6),0)*3412/1000000+IFERROR(VALUE(P6),0)","v":0},"Yes",{"$f":"SUM(IFERROR(Q6*3412/1000000,0),N6)","v":0},{"$f":"SUM(IFERROR(R6*3412/1000000,0),O6)","v":0},{"$f":"SUM(IFERROR(S6*3412/1000000,0),P6)","v":0}]
[2,"Prescriptive","Hot Water","Efficient-flow showerheads","-",1.3463100000000001,2.0053550000000002,346.38649500000002,"-","-","-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E7,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F7,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G7,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H7,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I7,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J7,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K7,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L7,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M7,2),\"\")","v":""},0,0,0,null,0,0,0]
[3,"Prescriptive","Hot Water","Faucet aerators","-",8.7645000000000001E-2,0.13055,22.550065,"-","-","-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E8,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F8,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G8,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H8,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I8,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J8,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K8,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L8,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M8,2),\"\")","v":""},0,0,0,"Yes",0,0,0]
[4,"Prescriptive","Hot Water","Thermostatic Shower Restriction Valve","-",0.31030999999999997,0.46220999999999995,79.837864999999994,"-","-","-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E9,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F9,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G9,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H9,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I9,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J9,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K9,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L9,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M9,2),\"\")","v":""},0,0,0,null,0,0,0]
[5,"Prescriptive","Envelope/Shell","Room (RAC) Cover and Gap Sealer","-",3.9343000000000004,3.9343000000000004,"-","-","-","-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E10,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F10,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G10,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H10,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I10,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J10,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K10,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L10,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M10,2),\"\")","v":""},0,0,0,null,0,0,0]
[6,"Prescriptive","HVAC","Heating/Cooling, Steam Pipe Insulation",3.68E-5,3.68E-5,3.68E-5,"-","-","-","-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E11,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F11,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G11,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H11,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I11,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J11,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K11,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L11,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M11,2),\"\")","v":""},0,0,0,null,0,0,0]
[7,"Prescriptive","HVAC","Primary HVAC combustion tune-up (Boiler/Furnace)","-",0.18036885714285716,0.18036885714285716,"-","-","-","-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E12,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F12,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G12,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H12,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I12,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J12,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K12,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L12,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M12,2),\"\")","v":""},0,0,0,null,0,0,0]
[8,"Prescriptive","Controls","Advanced Thermostat","-",3.6358347107438016,3.6358347107438016,"-",284.1229917355372,284.1229917355372,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E13,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F13,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G13,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H13,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I13,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J13,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K13,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L13,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M13,2),\"\")","v":""},0,0,0,null,0,0,0]
[9,"Prescriptive","Controls","Install TRVs or radiator valves",2.5990839694656489,2.5990839694656489,2.5990839694656489,"-","-","-","-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E14,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F14,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G14,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H14,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I14,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J14,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K14,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L14,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M14,2),\"\")","v":""},0,0,0,null,0,0,0]
[10,"Prescriptive","Controls","Steam Trap - Low Pressure",0.16033444999999999,0.16033444999999999,0.16033444999999999,"-","-","-","-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E15,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F15,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G15,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H15,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I15,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J15,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K15,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L15,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M15,2),\"\")","v":""},0,0,0,null,0,0,0]
[11,"Prescriptive","Lighting","Exterior Lighting","-","-","-",12.512865,45.354890173410404,64.94285714285715,5.5049999999999995E-3,1.9953757225433525E-2,2.8571428571428574E-2,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E16,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F16,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G16,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H16,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I16,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J16,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K16,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L16,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M16,2),\"\")","v":0},0,0,0,"Yes",0,0,0]
[12,"Prescriptive","Lighting","Interior Lighting",-0.95808661849710985,"-","-",577.61351523121391,482.76293994219651,482.76293994219651,0.65299727167630062,0.65299727167630062,0.65299727167630062,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E17,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F17,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G17,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H17,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I17,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J17,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K17,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L17,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M17,2),\"\")","v":0},0,0,0,null,0,0,0]
[13,"Weatherization","Envelope/Shell","Airsealing","-",5.2564892023121388,5.2564892023121388,733.71828439306364,32.853057225433531,32.853057225433531,6.0449624277456641E-2,6.0449624277456641E-2,6.0449624277456641E-2,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E18,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F18,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G18,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H18,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I18,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J18,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K18,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L18,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M18,2),\"\")","v":0},0,0,0,null,0,0,0]
[14,"Weatherization","HVAC","Duct Sealing and Insulation","-",0.70500924277456645,0.70500924277456645,7.1262011560693637,7.1262011560693637,7.1262011560693637,1.7880289017341042E-2,1.7880289017341042E-2,1.7880289017341042E-2,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E19,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F19,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G19,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H19,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I19,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J19,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K19,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L19,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M19,2),\"\")","v":0},0,0,0,null,0,0,0]
[15,"Weatherization","Envelope/Shell","Insulation (Attic Access)","-",2.3355924855491327E-2,2.3355924855491327E-2,1.0893549132947977,2.7784393063583816E-2,2.7784393063583816E-2,1.2601156069364162E-6,1.2601156069364162E-6,1.2601156069364162E-6,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E20,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F20,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G20,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H20,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I20,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J20,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K20,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L20,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M20,2),\"\")","v":0},0,0,0,null,0,0,0]
[16,"Weatherization","Envelope/Shell","Insulation (basement)","-",1.74639995,1.74639995,174.90778499999999,17.731794999999998,17.731794999999998,3.7075549999999999E-2,3.7075549999999999E-2,3.7075549999999999E-2,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E21,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F21,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G21,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H21,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I21,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J21,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K21,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L21,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M21,2),\"\")","v":0},0,0,0,null,0,0,0]
[17,"Weatherization","Envelope/Shell","Insulation (roof)","-",0.88767403703703707,0.88767403703703707,88.903518518518524,9.0128574074074077,9.0128574074074077,1.8845055555555556E-2,1.8845055555555556E-2,1.8845055555555556E-2,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E22,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F22,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G22,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H22,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I22,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J22,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K22,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L22,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M22,2),\"\")","v":0},0,0,0,null,0,0,0]
[18,"Weatherization","Envelope/Shell","Insulation (Wall) ","-",1.1289074074074075,1.1289074074074075,113.06384814814815,11.462181481481482,11.462181481481482,1.0545203703703702E-2,1.0545203703703702E-2,1.0545203703703702E-2,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E23,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F23,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G23,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H23,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I23,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J23,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K23,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L23,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M23,2),\"\")","v":0},0,0,0,null,0,0,0]
[19,"Weatherization","Envelope/Shell","Window Replacement ","-",2.6217302222222223,2.6217302222222223,26.619320370370367,26.619320370370367,26.619320370370367,2.1229000000000001E-2,2.1229000000000001E-2,2.1229000000000001E-2,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E24,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F24,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G24,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H24,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I24,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J24,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K24,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L24,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M24,2),\"\")","v":0},0,0,0,"Yes (went with windows for a more accurate representation of savings for weatherization compared to attic hatch sealing)",0,0,0]
[20,"Weatherization","Envelope/Shell","Airsealing","-",5.2564892023121388,5.2564892023121388,733.71828439306364,32.853057225433531,32.853057225433531,6.0449624277456641E-2,6.0449624277456641E-2,6.0449624277456641E-2,{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E25,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F25,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G25,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H25,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I25,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J25,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K25,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L25,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M25,2),\"\")","v":0},0,0,0,null,0,0,0]
[21,"Electrification ","Hot Water - Electrification","ASHP - HPWH",7.3222120473560013,31.326058818653813,43.977039688249299,-3720.099352943857,-2565.7889169262407,0.31727947048474597,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E26,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F26,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G26,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H26,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I26,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J26,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K26,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L26,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M26,2),\"\")","v":""},0,0,0,"Yes",0,0,0]
[22,"Electrification ","Hot Water - Electrification","WSHP - HPWH",7.3222120473560013,31.326058818653813,43.977039688249299,-3720.099352943857,-2565.7889169262407,0.31727947048474597,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E27,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F27,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G27,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H27,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I27,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J27,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K27,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L27,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M27,2),\"\")","v":""},0,0,0,null,0,0,0]
[23,"Electrification ","Hot Water - Electrification","GSHP - HPWH",7.3222120473560013,31.326058818653813,43.977039688249299,-3720.099352943857,-2565.7889169262407,0.31727947048474597,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E28,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F28,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G28,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H28,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I28,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J28,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K28,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L28,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M28,2),\"\")","v":""},0,0,0,null,0,0,0]
[24,"Electrification ","Heating and Cooling - Electrification","ASHP",28.647722047285914,38.30950204658437,72.287065789980005,-4199.6063289369476,-2577.316253371514,-6.5853770429593856,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E29,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F29,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G29,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H29,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I29,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J29,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K29,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L29,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M29,2),\"\")","v":""},0,0,0,null,0,0,0]
[25,"Electrification ","Heating and Cooling - Electrification","PTHP",28.647722047285914,38.30950204658437,72.287065789980005,-4199.6063289369476,-2577.316253371514,-6.5853770429593856,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E30,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F30,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G30,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H30,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I30,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J30,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K30,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L30,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M30,2),\"\")","v":""},0,0,0,null,0,0,0]
[26,"Electrification ","Heating and Cooling - Electrification","Room A/C Heat Pumps, <20kbtuh, with louvered sides",28.647722047285914,38.30950204658437,72.287065789980005,-4199.6063289369476,-2577.316253371514,-6.5853770429593856,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E31,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F31,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G31,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H31,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I31,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J31,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K31,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L31,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M31,2),\"\")","v":""},0,0,0,null,0,0,0]
[27,"Electrification ","Heating and Cooling - Electrification","Room A/C Heat Pumps, >=20kbtuh, with louvered sides",28.647722047285914,38.30950204658437,72.287065789980005,-4199.6063289369476,-2577.316253371514,-6.5853770429593856,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E32,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F32,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G32,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H32,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I32,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J32,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K32,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L32,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M32,2),\"\")","v":""},0,0,0,null,0,0,0]
[28,"Electrification ","Heating and Cooling - Electrification","Room A/C Heat Pumps, <14kbtuh, without louvered sides",28.647722047285914,38.30950204658437,72.287065789980005,-4199.6063289369476,-2577.316253371514,-6.5853770429593856,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E33,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F33,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G33,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H33,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I33,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J33,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K33,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L33,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M33,2),\"\")","v":""},0,0,0,null,0,0,0]
[29,"Electrification ","Heating and Cooling - Electrification","Room A/C Heat Pumps,>=14kbtuh, without louvered sides",28.647722047285914,38.30950204658437,72.287065789980005,-4199.6063289369476,-2577.316253371514,-6.5853770429593856,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E34,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F34,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G34,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H34,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I34,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J34,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K34,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L34,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M34,2),\"\")","v":""},0,0,0,null,0,0,0]
[30,"Electrification ","Heating and Cooling - Electrification","GSHP",28.647722047285914,38.30950204658437,72.287065789980005,-4199.6063289369476,-2577.316253371514,-6.5853770429593856,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E35,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F35,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G35,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H35,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I35,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J35,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K35,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L35,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M35,2),\"\")","v":""},0,0,0,null,0,0,0]
[31,"Deep Retrofit ","HVAC","Advanced Ventilation with Heat or Energy Recovery",-7.3635561928292056E-2,1.1452416964467635,7.9712678571428572,-366.23997231687548,-21.581348748034014,1.661968178835582,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E36,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F36,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G36,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H36,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I36,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J36,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K36,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L36,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M36,2),\"\")","v":""},0,0,0,"Yes (went with Mid savings for this one to have positive value)",0,0,0]
[32,"Deep Retrofit ","Envelope/Shell (Deep Retrofit)","Envelope – overclad (Insulation - Opaque Shell)",18.435763800223828,24.461684587177182,31.798693692350831,-381.4776993048992,-203.17503583534014,0.67000408377142584,"-","-","-",{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*E37,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*F37,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*G37,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*H37,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*I37,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*J37,2),\"\")","v":0},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*K37,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*L37,2),\"\")","v":""},{"$f":"IFERROR(ROUND('INTERNAL Funding Distrubution'!$D$16*M37,2),\"\")","v":""},0,0,0,null,0,0,0]

{"sheet":"Support - Funding Distrubution ","index":4,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,7,3,7],[4,7,8,7],[9,7,14,7],[0,7,0,8],[0,0,0,1],[1,0,3,0],[4,0,8,0],[9,0,14,0]]}
["Low-Rise (5-20 units)",null,"Stage 1","Stage 2","Stage 3","Stage 4",null,"Large Building (21+ units)",null,"Stage 1","Stage 2","Stage 3","Stage 4"]
["Non End-Use","Technical Assistance",0.75,0.25,0,0,null,"Non End-Use","Technical Assistance",0.75,0.25,0,0]
[null,"Concierge Services",0.75,0.25,0,0,null,null,"Concierge",0.75,0.25,0,0]
[null,"Floodproofing Design",1,0,0,0,null,null,"Floodproofing Design",1,0,0,0]
["End-Use ","Appliances ",0,0,1,0,null,"End-Use ","Appliances ",0,0,1,0]
[null,"Prescriptive",0.25,0.25,0.25,0.25,null,null,"Prescriptive",0.25,0,0.4,0.35]
[null,"Weatherization",0.25,0.25,0.25,0.25,null,null,"Weatherization",0.25,0,0.4,0.35]
[null,"Electrification",0.25,0.25,0.25,0.25,null,null,"Electrification",0.25,0,0.4,0.35]
[null,"Deep Retrofit",0.25,0.25,0.25,0.25,null,null,"Deep Retrofit",0.25,0,0.4,0.35]
["Resilience","Heat Pump Floodproofing",0.25,0.25,0.25,0.25,null,"Resilience","Heat Pump Floodproofing",0.25,0,0.4,0.35]
[null,"Heat Pump Water Heater Floodproofing",0.25,0.25,0.25,0.25,null,null,"Heat Pump Water Heater Floodproofing",0.25,0,0.4,0.35]
[null,"Advanced Ventilation Floodproofing",0.25,0.25,0.25,0.25,null,null,"Advanced Ventilation Floodproofing",0.25,0,0.4,0.35]
[null,"Electrical Panel Elevation",0.25,0.25,0.25,0.25,null,null,"Electrical Panel Elevation",0.25,0,0.4,0.35]
[null,"Electrification for Heat Vulnerable Populations",0,0,0,1,null,null,"Electrification for Heat Vulnerable Populations",0,0,0,1]
[null,"Hurricane Resistant Windows",0,0,0,1,null,null,"Hurricane Resistant Windows",0,0,0,1]