{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Utility Information","Project Info","Estimated Incentive Calculation","Support","Incentive Calculation Support"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":10,"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":"Utility Information","index":0,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[[29,4,29,7],[15,1,15,7],[21,4,21,7],[26,4,26,7],[27,4,27,7],[18,4,18,7],[19,4,19,7],[20,4,20,7],[22,4,22,7],[24,4,24,7],[25,4,25,7],[25,1,25,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[74,1,74,2],[74,5,74,6],[62,4,62,5],[63,4,63,5],[64,4,64,5],[65,4,65,5],[66,4,66,5],[67,4,67,5],[68,4,68,5],[69,4,69,5],[70,4,70,5],[71,4,71,5],[73,5,73,6],[30,4,30,7],[28,4,28,7],[61,4,61,5],[32,1,32,7],[51,5,51,6],[52,1,52,2],[52,5,52,6],[54,1,54,7],[55,4,55,5],[56,4,56,5],[57,4,57,5],[58,4,58,5],[59,4,59,5],[60,4,60,5],[29,1,29,3],[30,1,30,3],[28,1,28,3],[24,1,24,3],[9,1,9,7],[11,5,11,6],[22,1,22,3],[26,1,26,3],[27,1,27,3],[16,4,16,7],[17,4,17,7],[17,1,17,3],[16,1,16,3],[10,1,10,7],[12,1,12,7],[13,1,13,7],[14,1,14,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Custom Measure Worksheet - New Construction"]
[null,"FY23 July 1, 2022 – June 30, 2023"]
[null,"Customer Name",null,"Project Name",null,"Application Number \n(assigned upon submission)"]
[null,"Utility Rate Analysis"]
[null,"Instructions"]
[null,"Select the electric and gas utility provider(s) for the project facility from dropdown menu below. Enter all account number(s) for the facility in the space provided."]
[null,"Please enter estimated utility consumption information below, which this form will use to calculate an estimated $/kWh and/or $/therm rates. Note, these rates will be updated once actual bills are available to ensure the project complies with program requirements."]
[null,"Electric Delivery Utility (dropdown)",null,null,"Electric Acct. Number"]
[]
[]
[]
[]
[]
[]
[]
[null,"Gas Delivery Utility (dropdown)",null,null,"Gas Acct. Number"]
[]
[]
[]
[]
[]
[]
[]
[null,"Electric Energy Use and Cost"]
[null,"Service Period \nStart Date","Service Period \nEnd Date","Account Number","Billed kWh","kW Peak","Delivery Cost","Supply Cost"]
[null,"(Example)  7/1/2019","2019-08-01","abc123",1214847,2764,64454.7,112739.14]
[null,null,null,{"$f":"IF(E18=0,\"\",E18)","v":""}]
[null,null,null,{"$f":"IF(E19=0,\"\",E19)","v":""}]
[null,null,null,{"$f":"IF(E20=0,\"\",E20)","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Subtotal/Max",null,{"$f":"SUM(E36:E49)","v":0},{"$f":"MAX(F36:F49)","v":0},{"$f":"SUM(G36:G49)","v":0},{"$f":"SUM(H36:H49)","v":0}]
[]
[null,null,null,null,"Total Billed kWh","Total Electric Cost",null,"$/kWh"]
[null,"Electric Summary",null,null,{"$f":"SUM(E36:E49)","v":0},{"$f":"G50+H50","v":0},null,{"$f":"IF(E53=0,0,F53/E53)","v":0}]
[]
[null,"Natural Gas Energy Use and Cost"]
[null,"Service Period \nStart Date","Service Period \nEnd Date","Account Number","Billed Therms",null,"Delivery Cost","Supply Cost"]
[null,"(Example)  7/1/2019","2019-08-01","abc234",1214847,null,64454.7,112739.14]
[null,null,null,{"$f":"IF(E26=0,\"\",E26)","v":""}]
[null,null,null,{"$f":"IF(E27=0,\"\",E27)","v":""}]
[null,null,null,{"$f":"IF(E28=0,\"\",E28)","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Subtotal",null,{"$f":"SUM(E58:E71)","v":0},null,{"$f":"SUM(G58:G71)","v":0},{"$f":"SUM(H58:H71)","v":0}]
[]
[null,null,null,null,"Total Billed Therms","Total Gas Cost",null,"$/therm"]
[null,"Gas Summary",null,null,{"$f":"SUM(E58:E71)","v":0},{"$f":"G72+H72","v":0},null,{"$f":"IF(E75=0,0,F75/E75)","v":0}]

{"sheet":"Project Info","index":1,"n_rows":258,"n_cols":7,"rows_kept":258,"cut":false,"hidden":false,"merged":[[42,1,42,9],[43,1,48,9],[35,1,35,9],[36,1,41,9],[64,1,64,9],[66,1,66,5],[66,6,66,9],[67,4,67,5],[67,6,67,7],[67,8,67,9],[11,1,11,9],[12,2,12,3],[28,1,28,9],[16,1,16,9],[22,6,22,8],[29,1,34,9],[49,1,49,9],[50,1,55,9],[56,1,56,9],[57,1,62,9],[18,1,18,5],[18,6,18,9],[19,8,19,9],[25,1,25,9],[26,1,26,3],[26,5,26,8],[23,6,23,9],[21,6,21,8],[19,4,19,5],[20,6,20,8],[19,6,19,7],[83,1,83,9],[84,1,89,9],[90,1,90,9],[91,1,96,9],[74,1,74,3],[74,5,74,8],[76,1,76,9],[77,1,82,9],[68,6,68,8],[69,6,69,8],[70,6,70,8],[71,6,71,9],[73,1,73,9],[113,1,113,9],[115,1,115,5],[115,6,115,9],[116,4,116,5],[116,6,116,7],[116,8,116,9],[97,1,97,9],[98,1,103,9],[104,1,104,9],[105,1,110,9],[123,1,123,3],[123,5,123,8],[125,1,125,9],[126,1,131,9],[117,6,117,8],[118,6,118,8],[119,6,119,8],[120,6,120,9],[122,1,122,9],[161,1,161,9],[163,1,163,5],[163,6,163,9],[146,1,146,9],[147,1,152,9],[153,1,153,9],[154,1,159,9],[132,1,132,9],[133,1,138,9],[139,1,139,9],[140,1,145,9],[181,1,186,9],[187,1,187,9],[170,1,170,9],[171,1,171,3],[171,5,171,8],[173,1,173,9],[165,6,165,8],[166,6,166,8],[164,4,164,5],[164,6,164,7],[164,8,164,9],[167,6,167,8],[168,6,168,9],[249,1,249,9],[250,1,255,9],[228,1,228,9],[229,1,234,9],[235,1,235,9],[236,1,241,9],[219,1,219,3],[219,5,219,8],[221,1,221,9],[222,1,227,9],[9,1,9,9],[10,1,10,9],[13,1,13,9],[14,1,14,9],[242,1,242,9],[243,1,248,9],[213,6,213,8],[214,6,214,8],[215,6,215,8],[216,6,216,9],[218,1,218,9],[209,1,209,9],[211,1,211,5],[211,6,211,9],[212,4,212,5],[212,6,212,7],[212,8,212,9],[188,1,193,9],[194,1,194,9],[195,1,200,9],[201,1,201,9],[202,1,207,9],[174,1,179,9],[180,1,180,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Custom Measure Worksheet - New Construction"]
[null,"FY23 July 1, 2022 – June 30, 2023"]
[null,"Custom Project Details"]
[]
[null,"Instructions"]
[null,"Complete the information below for each custom measure. Fields are shown for the first measure, additional fields can be unhidden by clicking on the \"plus sign\" to the left of the rows below."]
[]
[null,"Measure #1"]
[]
[null,"Measure Savings",null,null,null,null,"Measure  Operational Details"]
[null,null,"Baseline","After Measure Implementation","Resource Savings ",null,"Equipment Location(s)"]
[null,"System(s) Annual kWh ",null,null,{"$f":"C21-D21","v":0},"kWh","Measure Life (per operating hours; 18 year Max)"]
[null,"System(s) Annual kW Demand",null,null,{"$f":"C22-D22","v":0},"kW","Pre-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual Therms",null,null,0,"Therms","Post-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual O&M Costs",null,null,0,"Dollars"]
[]
[null,"Measure Associated Implementation Costs"]
[null,"Total Measure Cost (Material and Labor)",null,null,null,"Total Baseline Cost (Material and Labor), if applicable"]
[]
[null,"A - Baseline Equipment Description and Operation:"]
[null,"Enter Text Here"]
[]
[]
[]
[]
[]
[null,"B - Proposed Equipment Description and Operation:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"C - Savings Methodology Description: "]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"D - Baseline Determination Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"E - Operation and Maintenance Savings Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[]
[null,"Measure #2"]
[]
[null,"Measure Savings",null,null,null,null,"Measure  Operational Details"]
[null,null,"Baseline","After Measure Implementation","Resource Savings ",null,"Equipment Location(s)"]
[null,"System(s) Annual kWh ",null,null,{"$f":"C69-D69","v":0},"kWh","Measure Life (per operating hours; 18 year Max)"]
[null,"System(s) Annual kW Demand",null,null,{"$f":"C70-D70","v":0},"kW","Pre-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual Therms",null,null,0,"Therms","Post-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual O&M Costs",null,null,0,"Dollars"]
[]
[null,"Measure Associated Implementation Costs"]
[null,"Total Measure Cost (Material and Labor)",null,null,null,"Total Baseline Cost (Material and Labor), if applicable"]
[]
[null,"A - Baseline Equipment Description and Operation:"]
[null,"Enter Text Here"]
[]
[]
[]
[]
[]
[null,"B - Proposed Equipment Description and Operation:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"C - Savings Methodology Description: "]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"D - Baseline Determination Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"E - Operation and Maintenance Savings Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
["←","Click plus sign for additional measure"]
[]
[null,"Measure #3"]
[]
[null,"Measure Savings",null,null,null,null,"Measure  Operational Details"]
[null,null,"Baseline","After Measure Implementation","Resource Savings ",null,"Equipment Location(s)"]
[null,"System(s) Annual kWh ",null,null,{"$f":"C118-D118","v":0},"kWh","Measure Life (per operating hours; 18 year Max)"]
[null,"System(s) Annual kW Demand",null,null,{"$f":"C119-D119","v":0},"kW","Pre-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual Therms",null,null,0,"Therms","Post-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual O&M Costs",null,null,0,"Dollars"]
[]
[null,"Measure Associated Implementation Costs"]
[null,"Total Measure Cost (Material and Labor)",null,null,null,"Total Baseline Cost (Material and Labor), if applicable"]
[]
[null,"A - Baseline Equipment Description and Operation:"]
[null,"Enter Text Here"]
[]
[]
[]
[]
[]
[null,"B - Proposed Equipment Description and Operation:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"C - Savings Methodology Description: "]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"D - Baseline Determination Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"E - Operation and Maintenance Savings Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
["←","Click plus sign for additional measure"]
[null,"Measure #4"]
[]
[null,"Measure Savings",null,null,null,null,"Measure  Operational Details"]
[null,null,"Baseline","After Measure Implementation","Resource Savings ",null,"Equipment Location(s)"]
[null,"System(s) Annual kWh ",null,null,{"$f":"C166-D166","v":0},"kWh","Measure Life (per operating hours; 18 year Max)"]
[null,"System(s) Annual kW Demand",null,null,{"$f":"C167-D167","v":0},"kW","Pre-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual Therms",null,null,0,"Therms","Post-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual O&M Costs",null,null,0,"Dollars"]
[]
[null,"Measure Associated Implementation Costs"]
[null,"Total Measure Cost (Material and Labor)",null,null,null,"Total Baseline Cost (Material and Labor), if applicable"]
[]
[null,"A - Baseline Equipment Description and Operation:"]
[null,"Enter Text Here"]
[]
[]
[]
[]
[]
[null,"B - Proposed Equipment Description and Operation:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"C - Savings Methodology Description: "]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"D - Baseline Determination Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"E - Operation and Maintenance Savings Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
["←","Click plus sign for additional measure"]
[null,"Measure #5"]
[]
[null,"Measure Savings",null,null,null,null,"Measure  Operational Details"]
[null,null,"Baseline","After Measure Implementation","Resource Savings ",null,"Equipment Location(s)"]
[null,"System(s) Annual kWh ",null,null,{"$f":"C214-D214","v":0},"kWh","Measure Life (per operating hours; 18 year Max)"]
[null,"System(s) Annual kW Demand",null,null,{"$f":"C215-D215","v":0},"kW","Pre-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual Therms",null,null,0,"Therms","Post-Install Annual Hours (associated w/ measure)"]
[null,"System(s) Annual O&M Costs",null,null,0,"Dollars"]
[]
[null,"Measure Associated Implementation Costs"]
[null,"Total Measure Cost (Material and Labor)",null,null,null,"Total Baseline Cost (Material and Labor), if applicable"]
[]
[null,"A - Baseline Equipment Description and Operation:"]
[null,"Enter Text Here"]
[]
[]
[]
[]
[]
[null,"B - Proposed Equipment Description and Operation:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"C - Savings Methodology Description: "]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"D - Baseline Determination Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[null,"E - Operation and Maintenance Savings Description:"]
[null,"Insert Text Here"]
[]
[]
[]
[]
[]
[]
["←","Click plus sign for additional measure"]

{"sheet":"Estimated Incentive Calculation","index":2,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[13,1,13,4],[14,1,14,4],[15,1,15,4],[10,1,10,9],[11,1,11,9],[12,1,12,9],[13,6,13,8],[14,6,14,8],[18,1,18,4],[18,6,18,8],[20,1,20,9],[15,6,15,8],[16,6,16,8],[9,1,9,9],[26,1,26,9],[22,1,25,1],[22,9,25,9],[23,7,23,8],[24,7,24,8],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[25,7,25,8],[21,1,21,9],[22,7,22,8],[16,1,16,4],[17,6,17,8],[17,1,17,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Custom Measure Worksheet - New Construction"]
[null,"FY23 July 1, 2022 – June 30, 2023"]
[null,"Project Summary"]
[null,"Totals gathered from applicant input on prior tabs, subject to program review. "]
[null,"Total Annual kWh Saved",null,null,null,{"$f":"'Incentive Calculation Support'!J9","v":0},"Total Project Cost ",null,null,{"$f":"'Incentive Calculation Support'!J13","v":0}]
[null,"Total Annual kW Demand Saved",null,null,null,{"$f":"'Incentive Calculation Support'!J10","v":0},"Total Baseline Project Cost, if applicable",null,null,{"$f":"'Incentive Calculation Support'!J14","v":0}]
[null,"Total Annual Therms Saved",null,null,null,{"$f":"'Incentive Calculation Support'!J11","v":0},"Incremental Cost",null,null,{"$f":"'Incentive Calculation Support'!E22","v":0}]
[null,"Total Annual O&M Costs Saved",null,null,null,{"$f":"'Incentive Calculation Support'!J12","v":0},"Annual Energy Cost Savings",null,null,{"$f":"'Incentive Calculation Support'!E20","v":0}]
[null,"Electric Utility Rate $/kWh",null,null,null,{"$f":"'Incentive Calculation Support'!E18","v":0},"Total Annual Cost Savings",null,null,{"$f":"'Incentive Calculation Support'!E21","v":0}]
[null,"Gas Utility Rate $/Therm",null,null,null,{"$f":"'Incentive Calculation Support'!E19","v":0},"Payback Without Incentives",null,null,{"$f":"'Incentive Calculation Support'!E23","v":0}]
[]
[null,"Estimated Incentive "]
[null,"Based on applicant input on Project Info tab, subject to program review. "]
[null,null,{"$f":"IF('Incentive Calculation Support'!$D$6=1,'Incentive Calculation Support'!D30,'Incentive Calculation Support'!D25)","v":"$0.16/kWh & $1.60/Therm"},null,null,null,null,{"$f":"'Incentive Calculation Support'!E25","v":0}]
[null,null,{"$f":"IF('Incentive Calculation Support'!$D$6=1,'Incentive Calculation Support'!D31,'Incentive Calculation Support'!D26)","v":"50% of Incremental Cost"},null,null,null,null,{"$f":"'Incentive Calculation Support'!E26","v":0}]
[null,null,{"$f":"IF('Incentive Calculation Support'!$D$6=1,'Incentive Calculation Support'!D32,'Incentive Calculation Support'!D27)","v":"Buydown to 1 year payback"},null,null,null,null,{"$f":"'Incentive Calculation Support'!E27","v":0}]
[null,null,{"$f":"IF('Incentive Calculation Support'!$D$6=1,'Incentive Calculation Support'!D33,'Incentive Calculation Support'!D28)","v":"Estimated Incentive"},null,null,null,null,{"$f":"'Incentive Calculation Support'!E28","v":0}]
[null,"Incentive calculation is the lesser of the three calculations displayed above. All figures are subject to program review."]

{"sheet":"Support","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Company Type","Incorporated","Payee","Electric Utility","Gas Utility","Tech Code","Measure Life","Building Type","Enhanced Incentives"]
["Commercial","Yes","Customer","Atlantic City Electric","South Jersey Gas","Lighting",15,"Bank / Financial Center","Yes"]
["Industrial","No","Contractor","PSE&G","New Jersey Natural Gas","HVAC",15,"Center / Club / Meeting Hall / Public Assembly","No"]
["Municipality","Other","Other","Rockland Electric Co.","Elizabethtown Gas","AMC",15,"Classroom / Laboratory / Administrative","Located in an Urban Enterprise Zone (UEZ)"]
["County",null,null,"Jersey Central P&L","PSE&G","Refrigeration",10,"Clinic / Medical Office","Located in an Opportunity Zone (OZ)"]
["State",null,null,null,null,"WHR",18,"Convenience Store ","Owned or operated by a Municipal Entity"]
["Regional Authority",null,null,null,null,"Other","-","Court House","Owned or operated by a County Entity"]
["Federal",null,null,null,null,null,null,"Datacenter / Telecommunications","Owned or operated by K-12 Public School"]
["School: K-12",null,null,null,null,null,null,"Dormitory","Designated as Affordable Housing"]
["School: College / University : Public",null,null,null,null,null,null,"Elementary School"]
["School: College / University : Private",null,null,null,null,null,null,"Emergency Services "]
["School: Vocational / Technical",null,null,null,null,null,null,"Energy/Power Station"]
["School: Other",null,null,null,null,null,null,"Garage / Parking Structure"]
["Multifamily",null,null,null,null,null,null,"Gas Station (stand-alone)"]
["Non-Profit",null,null,null,null,null,null,"Gas Station (w/ Convenience Store)"]
["Other",null,null,null,null,null,null,"Grocery / Supermarket / Food Sales ","Please select all that apply below. See Enhanced Incentive Eligibilty tab for more information."]
[null,null,null,null,null,null,null,"Gymnasium / Fitness Center"]
[null,null,null,null,null,null,null,"High School"]
[null,null,null,null,null,null,null,"Hospital / Medical Center"]
[null,null,null,null,null,null,null,"Hotel / Casino / Convention Center"]
[null,null,null,null,null,null,null,"Hotel / Motel"]
[null,null,null,null,null,null,null,"Laundromat"]
[null,null,null,null,null,null,null,"Library"]
[null,null,null,null,null,null,null,"Mall"]
[null,null,null,null,null,null,null,"Middle School"]
[null,null,null,null,null,null,null,"Mixed-Use"]
[null,null,null,null,null,null,null,"Multifamily - Low Rise / Garden"]
[null,null,null,null,null,null,null,"Multifamily - Mid/High Rise"]
[null,null,null,null,null,null,null,"Nursing Home / Assisted Living"]
[null,null,null,null,null,null,null,"Office"]
[null,null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,"Parking Lot / Street / Traffic Lights"]
[null,null,null,null,null,null,null,"Penitentiary / Jail / Prison"]
[null,null,null,null,null,null,null,"Pharmaceutical / Laboratory"]
[null,null,null,null,null,null,null,"Post Office / Mailing Center"]
[null,null,null,null,null,null,null,"Pre-school / Daycare"]
[null,null,null,null,null,null,null,"Private School / Mixed Grades"]
[null,null,null,null,null,null,null,"Production / Manufacturing"]
[null,null,null,null,null,null,null,"Recreation / Entertainment / Parks"]
[null,null,null,null,null,null,null,"Refinery"]
[null,null,null,null,null,null,null,"Religious Institution"]
[null,null,null,null,null,null,null,"Restaurant - Fast Food / Food Service"]
[null,null,null,null,null,null,null,"Restaurant - Sit Down / Bar "]
[null,null,null,null,null,null,null,"Retail"]
[null,null,null,null,null,null,null,"Service"]
[null,null,null,null,null,null,null,"Storage - Conditioned"]
[null,null,null,null,null,null,null,"Storage - Unconditioned"]
[null,null,null,null,null,null,null,"Student Center / Cafeteria"]
[null,null,null,null,null,null,null,"Transportation"]
[null,null,null,null,null,null,null,"University / College - General"]
[null,null,null,null,null,null,null,"Warehouse - Conditioned / Refrigerated"]
[null,null,null,null,null,null,null,"Warehouse - Unconditioned"]
[null,null,null,null,null,null,null,"Water / Wastewater Treatment / Pumping"]

{"sheet":"Incentive Calculation Support","index":4,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Enhanced?"]
[null,null,null,"Test = A x B"]
[null,null,null,"Customer Claim (A)"]
[]
[]
[null,null,null,"measure",1,2,3,4,5,"Total"]
[null,null,null,"kWh annual",{"$f":"'Project Info'!E21","v":0},{"$f":"'Project Info'!E69","v":0},{"$f":"'Project Info'!E118","v":0},{"$f":"'Project Info'!E166","v":0},{"$f":"'Project Info'!E214","v":0},{"$f":"SUM(E9:I9)","v":0}]
[null,null,null,"kW demand",{"$f":"'Project Info'!E22","v":0},{"$f":"'Project Info'!E70","v":0},{"$f":"'Project Info'!E119","v":0},{"$f":"'Project Info'!E167","v":0},{"$f":"'Project Info'!E215","v":0},0]
[null,null,null,"Therms Annual",{"$f":"'Project Info'!E23","v":0},{"$f":"'Project Info'!E71","v":0},{"$f":"'Project Info'!E120","v":0},{"$f":"'Project Info'!E168","v":0},{"$f":"'Project Info'!E216","v":0},0]
[null,null,null,"O&M",{"$f":"'Project Info'!E24","v":0},{"$f":"'Project Info'!E72","v":0},{"$f":"'Project Info'!E121","v":0},{"$f":"'Project Info'!E169","v":0},{"$f":"'Project Info'!E217","v":0},0]
[null,null,null,"Proposed Project Cost ",{"$f":"'Project Info'!E27","v":0},{"$f":"'Project Info'!E75","v":0},{"$f":"'Project Info'!E124","v":0},{"$f":"'Project Info'!E172","v":0},{"$f":"'Project Info'!E220","v":0},0]
[null,null,null,"Baseline Cost",{"$f":"'Project Info'!J27","v":0},{"$f":"'Project Info'!J75","v":0},{"$f":"'Project Info'!J124","v":0},{"$f":"'Project Info'!J172","v":0},{"$f":"'Project Info'!J220","v":0},0]
[]
[]
[null,null,null,"Utility Rates"]
[null,null,null,"$/kWh",{"$f":"'Utility Information'!H53","v":0}]
[null,null,null,"$/Therm",{"$f":"'Utility Information'!H75","v":0}]
[null,null,null,"Annual Energy Cost Savings",{"$f":"(J9*E18)+(J11*E19)","v":0}]
[null,null,null,"Total Annual Cost Savings",{"$f":"E20+J12","v":0}]
[null,null,null,"Incremental Cost",{"$f":"J13-J14","v":0}]
[null,null,null,"Payback Without Incentives",{"$f":"IFERROR(E22/E21,0)","v":0}]
[]
[null,null,null,"$0.16/kWh & $1.60/Therm",{"$f":"(J9*0.16)+(J11*1.6)","v":0}]
[null,null,null,"50% of Incremental Cost",{"$f":"E22*0.5","v":0}]
[null,null,null,"Buydown to 1 year payback",{"$f":"E22-E21","v":0}]
[null,null,null,"Estimated Incentive",{"$f":"MIN(E25:E27)","v":0}]