{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Incentive Estimator","Support","Versions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":12,"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":"Incentive Estimator","index":0,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,2,5,3],[27,1,35,1],[9,1,16,1],[4,2,4,3],[1,2,2,3]]}
[]
[null,null,"New Construction Program Incentive Estimation Calculator v1.0"]
[]
[]
[null,null,"DISCLAIMER: This tool is intended for use by Partners and potential applicants to New Jersey's Clean Energy Program, New Construction Program (NCP). The purpose of this tool is to evaluate potential incentive opportunities for prospective projects. The information presented here is to be used for estimation purposes only and is not reflective of actual project costs, savings, or incentives. The results generated by this tool do no constitute binding program documentation. Final project benefits and available incentives will be calculated upon receipt of an application and supporting documentation to the NCP, subject to program review and approval. Any questions about this tool, the results, or general inquiries about the program can be directed to NCP@NJCleanEnergy.com "]
[null,null,"Instructions: Input project data in shaded fields below; white cells will auto populate. If calculating incentives for a Single Family Home or Townhome, only enter the information for a the single residence, then multiply by the number of same residences outside of this tool. For Multifamily or Commerical/Industrial, enter information for the total building. Incentives are based on conditioned square feet (row 11). Please see Program Guide for complete incentive information. except for the Alternative Performance Pathway, which is based on energy savings (rows 15 and/or 16).  See Program Guide for additional information.  ",null,null,"\n\n\n\n"]
[null,null,"Year of Construction Completion"]
[null,null,"Project Sector"]
[null,null,"Building Type"]
[null,"Inputs","Is the building considered \"High Energy Intensity\" (C&I Only)?"]
[null,null,"Conditioned Square Footage of the project building"]
[null,null,"Program Pathway"]
[null,null,"Is the project located in the state's UEZ, OZ, or OBC area? Or is the property designated as affordable housing? (links below) "]
[null,null,"Lifetime of Benefits (years)"]
[null,null,"Estimated Annual Electric Savings (kWh)"]
[null,null,"Estimated Annual Natural Gas Savings (therms)"]
[null,null,"Tons CO2e per kSF (select value only if energy savings above are unknown; otherwise leave blank)"]
[null,null,"Lifetime Energy Impacts"]
[null,null,"Estimated Lifetime Electric Savings (kWh)",{"$f":"D15*ROUND(D14,0)","v":0}]
[]
[]
[null,null,"CO2e Emissions Impacts"]
[null,null,"Estimated CH4 Emissions Reduction (tons)",{"$f":"IFERROR(D15*0.097/1000/2000+D16*1/454/2000,0)","v":0}]
[null,null,"Estimated N2O Emissions Reduction (tons)",{"$f":"IFERROR(D15*0.013/1000/2000+D16*0.1/454/2000,0)","v":0}]
[null,null,"Estimated Annual CO2e Emissions Reductions (tons)",{"$f":"IFERROR(INDEX(tblElectricEmissionsFactors,MATCH(D7,Support!$A$4:$A$42,0),2)*(1+Support!$B$62)*D15/1000,0)+IFERROR(INDEX(tblFuelEmissionsFactors,MATCH(\"Natural Gas\",Support!$A$53:$A$55,0),2)/2000*(1+INDEX(tblTDLosses,MATCH(\"Natural Gas\",Support!$A$62:$A$65,0),2))*D16/INDEX(tblFuelType_Units,MATCH(\"Natural Gas\",ddFuelType,0),3),0)","v":0}]
[null,null,"Estimated Lifetime CO2e Emissions Reductions (tons)",{"$f":"IFERROR(SUM(INDEX(greethumb3,MATCH(D7,Support!$A$4:$A$42,0),2):INDEX(greethumb3,MATCH(D7+ROUND(D14,0)-1,Support!$A$4:$A$42,0),2))*(1+Support!$B$62)*D15/1000,0)+IFERROR(ROUND(D14,0)*INDEX(tblFuelEmissionsFactors,MATCH(#REF!,Support!$A$53:$A$55,0),2)/2000*(1+INDEX(tblTDLosses,MATCH(#REF!,Support!$A$62:$A$65,0),2))*D16/INDEX(tblFuelType_Units,MATCH(#REF!,ddFuelType,0),3),0)+IFERROR(ROUND(D14,0)*INDEX(tblFuelEmissionsFactors,MATCH(#REF!,Support!$A$53:$A$55,0),2)/2000*(1+INDEX(tblTDLosses,MATCH(#REF!,Support!$A$62:$A$65,0),2))*#REF!/INDEX(tblFuelType_Units,MATCH(#REF!,ddFuelType,0),3),0)+IFERROR(ROUND(D14,0)*INDEX(tblFuelEmissionsFactors,MATCH(#REF!,Support!$A$53:$A$55,0),2)/2000*(1+INDEX(tblTDLosses,MATCH(#REF!,Support!$A$62:$A$65,0),2))*#REF!/INDEX(tblFuelType_Units,MATCH(#REF!,ddFuelType,0),3),0)+((D23*Support!$B$93)+(D24*Support!$B$94))*D14","v":0}]
[null,null,"CO2e Emissions Reductions per 1,000 sq. ft. of the Building (tons per 1,000 sq. ft.)",{"$f":"IFERROR(D25/(D11/1000),0)","v":0}]
[null,"Outputs"]
[]
[null,null,"Incentives"]
[null,null,"Base Incentive",{"$f":"IFERROR(IF(OR(D8=\"\",D9=\"\",D11=\"\",D12=\"\")=TRUE,0,IF(D8=\"Residential\",IF(OR(D9=\"Townhome\",D9=\"Single-Family Home\"),MAX(2000, MIN(4000, D11)),D11)*INDEX(Support!H8:H10,MATCH(D12,Support!G8:G10,0)),D11*INDEX(Support!L8:L11,MATCH(D12,Support!K8:K11,0)))),0)","v":0}]
[null,null,"Greenhouse Gas Reduction Bonus (if eligible)",{"$f":"IFERROR(IF(OR(D8=\"\",D9=\"\",D11=\"\",D12=\"\",N(D31)=0)=TRUE,0,IF(OR(D12=\"Alternative Performance-based Pathway (for indoor ag and select industrial only)\",D12=\"Bundled\"),0,IF(AND(D8=\"Residential\",OR(D9=\"Single-Family Home\",D9=\"Townhome\")),MAX(2000,MIN(4000,D11)),D11)*IF(D27<=0,INDEX(Support!H13:H18,MATCH(D17,GHG_ReductionBonus,0)),IF(D27<0.7,0,IF(AND(D27>=0.7,D27<1),0.25,IF(AND(D27>=1,D27<2),0.5,IF(AND(D27>=2,D27<3),1,IF(D27>=3,1.5)))))))),0)","v":0}]
[null,null,"Location/Status Bonus (if eligible)",{"$f":"IFERROR(IF(OR(D8=\"\",D9=\"\",D11=\"\",D12=\"\",N(D31)=0)=TRUE,0,IF(OR(D12=\"Alternative Performance-based Pathway (for indoor ag and select industrial only)\",D12=\"Bundled\"),0,IF(D8=\"Residential\",IF(OR(D9=\"Single-Family Home\",D9=\"Townhome\"),MAX(2000,MIN(4000,D11)),D11)*INDEX(Support!Q2:Q4,MATCH(D13,ResidentialOptions,0)),D11*INDEX(IF(D12=\"Streamlined\",Support!U2:U5,Support!V2:V5),MATCH(D13,NonResidentialOptions,0))))),0)","v":0}]
[null,null,"High Energy Intensity Bonus (if eligible)",{"$f":"IFERROR(IF(OR(D8=\"\",D9=\"\",D11=\"\",D12=\"\",N(D31)=0)=TRUE,0,IF(OR(D12=\"Alternative Performance-based Pathway (for indoor ag and select industrial only)\",D12=\"Bundled\"),0,IF(AND(D8=\"Non-Residential\",D10=\"Yes\"),D11*IF(D12=\"Streamlined\",0.6,1),0))),0)","v":0}]
[]
[null,null,"Alternative Performance-Based Incentive",{"$f":"IFERROR(IF(AND(D8=\"Non-Residential\",D12=\"Alternative Performance-based Pathway (for indoor ag and select industrial only)\"),(D15*0.16)+(D16*1.6),0),0)","v":0}]
[]
[null,null,"Total Estimated Incentive ($)",{"$f":"IFERROR(SUMIF(D31:D36, \"<>#N/A\"),0)","v":0}]
[]
[]
[null,"Links for Lookup of:"]
[]
[null,"Urban Enterprise Zone (UEZ) and Opportunity Zone (OZ)"]
[null,"Overburdened Community (OBC)"]
[]
["© 2025 TRC Companies, Inc. TRC Companies, Inc. and its affiliates reserve all rights associated with this body of work. Content cannot be edited or replicated without the express, written consent of TRC Companies, Inc. or its affiliates."]

{"sheet":"Support","index":1,"n_rows":97,"n_cols":23,"rows_kept":97,"cut":false,"hidden":true,"merged":[[76,0,76,2],[77,0,78,0],[77,1,78,1],[77,2,78,2],[84,1,84,2],[96,0,100,0],[96,1,100,1],[85,0,86,0],[85,1,86,2],[89,0,89,1],[90,0,91,0],[90,1,91,1],[0,0,0,3],[1,0,2,0],[1,1,1,3],[49,0,49,1],[50,0,51,0],[43,1,43,3],[44,0,45,0],[44,1,45,3],[67,0,70,0],[67,1,70,1],[58,3,58,4],[59,3,64,4],[65,3,70,4],[58,0,58,1],[59,0,60,0],[59,1,60,1]]}
["Electric Emissions Factors",null,null,null,null,null,"Residential","Sector Type","Pathway",null,"Non-Residential",null,"Affordable Status",null,null,"Additional Incentive for Residential","Incentive",null,null,"Additional Incentive for Non-Residential","Streamlined Incentive","High-Performance Incentive"]
["Year","Tons per MWh",null,null,null,null,"Single-Family Home","Residential","High Performance nonprox/LEED",null,"Commercial",null,"Affordable",null,null,"Overburdened Community (OBC)",0.25,null,null,"Urban Enterprise Zone (UEZ)",0.15,0.25]
[null,"CO2","SO2","NOx",null,null,"Townhome","Non-Residential","High Performance PHI/PHIUS",null,"Industrial",null,"Market Rate",null,null,"Affordable Housing Designation",0.25,null,null,"Opportunity Zone (OZ)",0.15,0.25]
[2022,0.5,1.3999999999999999E-4,3.2699999999999998E-4,null,null,"Multi-Family",null,"Streamlined",null,null,null,"N/A",null,null,"N/A",0,null,null,"Overburdened Community (OBC)",0.15,0.25]
[2023,0.49,1.3799999999999999E-4,3.21E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",0,0]
[2024,0.48,1.35E-4,3.1500000000000001E-4]
[2025,0.48,1.3300000000000001E-4,3.1E-4,null,null,"Residential Base Incentive","$ per conditioned sq. ft.",null,null,"Non-Residential Base Incentive","Commercial","Industrial/High Energy Intensity Bonus (depends only on the base incentive)",null,null,"C&I Bonus",null,null,null,"Industrial Bonus"]
[2026,0.47,1.2999999999999999E-4,3.0400000000000002E-4,null,null,"High Performance: ENERGY STAR",1,null,null,"Bundled",0.25,null,null,null,"UEZ/OZ Bonus Streamlined",0.15,null,null," Streamlined",0.6]
[2027,0.46,1.2799999999999999E-4,2.9799999999999998E-4,null,null,"High Performance: DOE Zero Energy Ready Home",1.75,null,null,"Streamlined",0.5,0.6,null,null,"UEZ/OZ Bonus HP",0.25,null,null," High Performance",1]
[2028,0.45,1.25E-4,2.92E-4,null,null,"High Performance: Passive House (PHIUS or PHI)",2.5,null,null,"High Performance: LEED or non-Proxy",1,1]
[2029,0.44,1.2300000000000001E-4,2.8600000000000001E-4,null,null,null,null,null,null,"High Performance: Passive House (PHIUS or PHI)",2.5,1]
[2030,0.43,1.2E-4,2.7999999999999998E-4,null,null,"GHG Reduction Bonus",null,null,null,"Alternative Performance-based Pathway (for indoor ag and select industrial only)",0.16]
[2031,0.42,1.18E-4,2.7500000000000002E-4,null,null,"N/A",0,null,null,"*indoor agriculture  or manufacturing only",null,null,null,null,"Region Bonus"]
[2032,0.41,1.15E-4,2.6899999999999998E-4,null,null,"<0.7",0,null,null,null,null,null,null,null,"N/A",0,null,null,"Residential"]
[2033,0.4,1.13E-4,2.63E-4,null,null,"0.7-.99 tons",0.25,null,null,null,null,null,null,null,"Opportunity Zone (OZ)",0,null,null,"AH/UEZ/OZ Bonus","0.25*sq ft","($0.25/sqft)"]
[2034,0.4,1.1E-4,2.5700000000000001E-4,null,null,"1-1.99 tons",0.5,null,null,null,null,null,null,null,"Overburdened Community (OBC)",0.25]
[2035,0.39,1.08E-4,2.5099999999999998E-4,null,null,"2-2.99 tons",1,null,null,null,null,null,null,null,"Urban Enterprise Zone (UEZ)",0.25]
[2036,0.38,1.05E-4,2.4499999999999999E-4,null,null,"3+ tons",1.5,null,null,null,null,null,null,null,"Enhanced Incentive Eligibility",0,null,null,"Commercial"]
[2037,0.37,1.03E-4,2.3900000000000001E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UEZ/OZ Bonus","0.15*sq ft","($0.15/sqft)","streamlined"]
[2038,0.36,1E-4,2.34E-4,null,null,"Affordable Housing Bonus",null,null,null,null,null,null,null,null,null,null,null,null,"UEZ/OZ Bonus","0.25*sq ft","($0.25/sqft)","HP"]
[2039,0.35,9.7999999999999997E-5,2.2800000000000001E-4,null,null,"\"Any housing that an official document identifies as participating in a federal, state or local affordable housing program.\"",0.25]
[2040,0.34,9.5000000000000005E-5,2.22E-4]
[2041,0.33,9.2999999999999997E-5,2.1599999999999999E-4]
[2042,0.32,9.0000000000000006E-5,2.1000000000000001E-4]
[2043,0.31,8.7999999999999998E-5,2.04E-4,null,null,null,null,null,null,null,"Regional Bonus - Non-Residental"]
[2044,0.31,8.5000000000000006E-5,1.9900000000000001E-4,null,null,null,null,null,null,"Non-Residential","Bundled",0,null,null,4100]
[2045,0.3,8.2999999999999998E-5,1.93E-4,null,null,null,null,null,null,"Non-Residential","Alternative Performance-based Pathway*",0]
[2046,0.28999999999999998,8.0000000000000007E-5,1.8699999999999999E-4,null,null,null,null,null,null,"Non-Residential","High Performance nonprox/LEED",0.25,null,null,{"$f":"MAX(2000, MIN(4000,P26))","v":4000}]
[2047,0.28000000000000003,7.7999999999999999E-5,1.8100000000000001E-4,null,null,null,null,null,null,"Non-Residential","High Performance PHI/PHIUS",0.25]
[2048,0.27,7.4999999999999993E-5,1.75E-4,null,null,null,null,null,null,"Non-Residential","Streamlined",0.15]
[2049,0.26,7.2999999999999999E-5,1.6899999999999999E-4]
[2050,0.25,6.9999999999999994E-5,1.64E-4]
[2051,0.24,6.7999999999999999E-5,1.5799999999999999E-4]
[2052,0.23,6.4999999999999994E-5,1.5200000000000001E-4]
[2053,0.22,6.3E-5,1.46E-4]
[2054,0.22,6.0000000000000002E-5,1.3999999999999999E-4]
[2055,0.21,5.8E-5,1.34E-4]
[2056,0.2,5.5000000000000002E-5,1.2799999999999999E-4]
[2057,0.19,5.3000000000000001E-5,1.2300000000000001E-4]
[2058,0.18,5.0000000000000002E-5,1.17E-4]
[2059,0.17,4.8000000000000001E-5,1.11E-4]
[2060,0.16,4.5000000000000003E-5,1.05E-4]
[]
["Source:","Tri-2 Board Order"]
["Link:","https://www.nj.gov/bpu/pdf/boardorders/2023/20230726/8C%20ORDER%20Second%20Triennium.pdf"]
[]
[]
[]
[]
["Fuel Emissions Factors"]
["Fuel","Pounds per MMBtu"]
[null,"CO2"]
["Natural Gas",116.65]
["Propane",138.63]
["Fuel Oil",163.44999999999999]
["Source:","EIA Fuel Emissions"]
["Link:","https://www.eia.gov/environment/emissions/co2_vol_mass.php"]
[]
["Transmission & Distribution Losses",null,null,"Notes"]
["Fuel","% Losses",null,"1. For electric values (page 14 of Attachment B in the order): The site-to-source conversion values in the table include line losses, which are calculated using a statewide average of 5.8% multiplied by a marginal loss factor of 1.5, as per the NJCT (5.8% x 1.5 = 8.7%)."]
[]
["Electric",8.6999999999999994E-2]
["Natural Gas",2.3E-2]
["Propane",0]
["Fuel Oil",0]
[null,null,null,"2. For natural gas values (footnote 26 on page 18 of Attachment B in the order): Losses of 2.3% are from production and delivery to buildings per Alvarez, et al., Assessment of Methane Emissions from the U.S. Oil and Gas Supply Chain (2018), Science, Vol. 361, Issue 6398"]
["Source:","Tri-2 Board Order"]
["Link:","https://www.nj.gov/bpu/pdf/boardorders/2023/20230726/8C%20ORDER%20Second%20Triennium.pdf"]
[]
[]
[]
[]
[]
[]
[]
[]
["Fuel Type & Units"]
["Fuel Type","Units","MMBtu Conversion\n(units/MMBtu)"]
[]
["<Fuel Type>","<units>","N/A"]
["Natural Gas","Therms",{"$f":"1000000/100000","v":10}]
["Propane","Gallons",{"$f":"1000000/91452","v":10.934697983641692}]
["Fuel Oil","Gallons",{"$f":"1000000/138500","v":7.2202166064981945}]
[]
["Source:","EIA BTU Conversions"]
["Link:","https://www.eia.gov/energyexplained/units-and-calculators/british-thermal-units.php"]
[]
[]
[]
["Global Warming Potential"]
["GHG Type","GWP Factor\n(equivalent units of CO2)"]
[]
["CH4",28]
["N2O",265]
[]
["Source:","Greenhouse Gas Protocol"]
["Link:","https://ghgprotocol.org/sites/default/files/ghgp/Global-Warming-Potential-Values%20%28Feb%2016%202016%29_1.pdf"]

{"sheet":"Versions","index":2,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["2025-03-19","v1.0","First draft for release. Alternative Performance Pathway has been hidden as an option from the dropdown pending BPU instruction. "]