{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Calculator_SM","Incentives_SM","Calculator_MS","Incentives_MS","Measure Totals","Lists","Avoided Costs","Com LU Table"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":138,"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":"Instructions","index":0,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[3,3,3,12],[5,3,5,12],[60,4,60,8],[35,4,35,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[47,4,47,8],[48,4,48,8],[49,4,49,8],[57,4,57,8],[1,3,1,12],[2,3,2,12],[4,3,4,12],[22,4,22,8],[33,4,33,8],[34,4,34,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[29,4,29,8],[30,4,30,8],[58,4,58,8],[59,4,59,8],[50,4,50,8],[51,4,51,8],[52,4,52,8],[53,4,53,8],[54,4,54,8],[55,4,55,8],[56,4,56,8],[31,4,31,8],[32,4,32,8],[46,4,46,8],[16,1,19,1],[11,3,14,12],[21,4,21,8],[4,1,7,1],[6,3,10,12],[18,4,18,8],[19,4,19,8],[20,4,20,8],[17,4,17,8],[16,4,16,9],[9,1,14,1]]}
[]
[null,null,null,"Instructions for use of Energy Trust Cost Effectiveness Calculator"]
[null,null,null,"1. Enter all relevant project information in the boxes at the top left."]
[null,null,null,"2. Enter the project's electric and gas utilities and utility rates in the boxes at the top center."]
[null,"Purpose: The Savings Summary Worksheet tool, containing the Cost Effectiveness Calculator, and its information was developed and is made available by Energy Trust of Oregon, Inc. (Energy Trust) to New Buildings Program participants for the sole purpose of assisting projects with estimating whether incentives may be available in support of a customer's potential commercial new construction or major renovation project enrolling in the Modeled Savings, Path to Net Zero, Data Center and/or Special Measure offerings.",null,"3. Enter the measure name or description in the first column."]
[null,null,null,"4. Select the most applicable sub-sector for the project building type."]
[null,null,null,"5. Choose the best appropriate load profile descriptors for when the savings happen.\n\n  For example, choose the \"Cooling\" electric load profile and the \"Com Heating\" natural gas load profile for HVAC improvement measures which involve natural gas heating.\n\nIf there are no savings for a particular fuel, choose \"None\" for the load profile for that fuel."]
[]
[]
[null,"Program Information:  User should always verify with Energy Trust that it is using the version of the Savings Summary Worksheet currently in effect. The project analyst should input the project's energy efficiency measures (EEMs), estimated kWh and therm savings, and the estimated incremental cost, and the embedded Cost Effectiveness Calculator will return an estimated potential installation incentive for measures that are cost effective, according to the Energy Trust of Oregon cost effectivness criteria. For more information on the Savings Summary Worksheet and participation in the above listed offerings, please see the Program's Technical Guidelines."]
[]
[null,null,null,"6. Enter the measure life (see below for typical measure lifetimes), estimated savings, incremental measure cost, and annual non-energy benefit value (if any) in the remaining columns.\n\nThe utility and TRC benefit-cost ratios will appear when all necessary inputs have been completed.  If there is an error or a necessary entry is missing, the columns will remain blank."]
[]
[]
[]
[]
[null,"Disclaimer/No Liability:  Energy Trust does not guarantee any particular cost or energy savings results from participation in its programs and shall not be responsible for any claims relating to errors, omissions or other inaccuracies resulting from the use of the Savings Summary Worksheet, or from the reliance on information procured therefrom. This worksheet provides estimates only, and is NOT an incentive offer, application or commitment.",null,null,"New Buildings Measure Lifes"]
[null,null,null,null,"Architectural Shading",null,null,null,null,15]
[null,null,null,null,"Boiler Vent Damper",null,null,null,null,12]
[null,null,null,null,"Chillers",null,null,null,null,23]
[null,"v2016.3  160418",null,null,"Clothes Washers",null,null,null,null,14]
[null,null,null,null,"Commercial Clothes Washers",null,null,null,null,9]
[null,null,null,null,"Commercial Kitchen Steamer",null,null,null,null,12]
[null,null,null,null,"Condensing Tank",null,null,null,null,15]
[null,null,null,null,"Cooling Tower",null,null,null,null,20]
[null,null,null,null,"Demand Control Ventilation",null,null,null,null,15]
[null,null,null,null,"Direct Fired Convection Oven",null,null,null,null,12]
[null,null,null,null,"Direct-Fired Radiant Heating",null,null,null,null,18]
[null,null,null,null,"Domestic Tankless / Instantaneous Water Heater ",null,null,null,null,18]
[null,null,null,null,"ECM Motor for Refrigeration",null,null,null,null,12]
[null,null,null,null,"EMS for Food Prep",null,null,null,null,15]
[null,null,null,null,"Freezers",null,null,null,null,12]
[null,null,null,null,"Glazing / Windows Custom",null,null,null,null,15]
[null,null,null,null,"Heat Exchanger",null,null,null,null,20]
[null,null,null,null,"Heat Pumps (Air to Air)",null,null,null,null,20]
[null,null,null,null,"Heat Pumps (Ground Source)",null,null,null,null,20]
[null,null,null,null,"Heat Pumps (Water Source)",null,null,null,null,20]
[null,null,null,null,"Hi Eff Condensing Boiler",null,null,null,null,20]
[null,null,null,null,"Hi Eff Condensing Furnace",null,null,null,null,18]
[null,null,null,null,"Hi Eff Unit Heater",null,null,null,null,18]
[null,null,null,null,"Hot Food Cabinet",null,null,null,null,12]
[null,null,null,null,"Ice Machines",null,null,null,null,12]
[null,null,null,null,"Infared Fryer",null,null,null,null,12]
[null,null,null,null,"Infared Griddle",null,null,null,null,12]
[null,null,null,null,"Kitchen Vent Hood",null,null,null,null,15]
[null,null,null,null,"Lighting Fixtures",null,null,null,null,13]
[null,null,null,null,"Lighting Controls",null,null,null,null,15]
[null,null,null,null,"Low Emissivity Coating",null,null,null,null,25]
[null,null,null,null,"Motors",null,null,null,null,15]
[null,null,null,null,"Occupancy / Daylight Controls",null,null,null,null,10]
[null,null,null,null,"PT Heat Pump",null,null,null,null,12]
[null,null,null,null,"Refrigerators",null,null,null,null,12]
[null,null,null,null,"Roof Insulation",null,null,null,null,45]
[null,null,null,null,"Screw-in CFL ",null,null,null,null,2]
[null,null,null,null,"Showerheads",null,null,null,null,10]
[null,null,null,null,"Single Tank Conveyor Dishwasher",null,null,null,null,20]
[null,null,null,null,"Single Tank Door/Upright Dishwasher",null,null,null,null,15]
[null,null,null,null,"Undercounter Hi Temp Dishwasher",null,null,null,null,10]
[null,null,null,null,"Unit Heaters",null,null,null,null,18]
[null,null,null,null,"VSD",null,null,null,null,15]
[null,null,null,null,"Wall Insulation",null,null,null,null,45]

{"sheet":"Calculator_SM","index":1,"n_rows":40,"n_cols":25,"rows_kept":40,"cut":false,"hidden":false,"merged":[[13,23,13,24],[3,10,9,18],[13,5,14,5],[13,8,13,9],[13,20,13,21],[13,16,14,16],[13,17,14,17],[13,10,14,10],[13,12,14,12],[13,13,14,13],[13,14,14,14],[13,15,14,15],[13,6,13,7],[13,11,14,11],[0,0,0,5],[1,0,1,2],[10,1,10,4],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,13,4],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
["Savings Summary Worksheet - Energy Trust of Oregon New Buildings Program"]
["Based on:  Energy Trust of Oregon Cost Effectiveness Calculator v1.0\nVersion:  1/1/2016"]
[]
["Project Name:",null,null,null,"Electric Utility","PAC","Gas Utility","CNG",null,null,"NOTE TO USERS:  All Special Measures must be tested for cost effectiveness using the Energy Trust Cost Effectiveness Calculator embedded in this worksheet and submitted for review and approval by Energy Trust.\n\nThis worksheet provides estimates of cost effectiveness and program incentives based on information submitted by the project analyst, including savings calculations, supporting documentation, incremental cost estimates, and other information as requested by Energy Trust. \n\nThis spreadsheet will be updated to address changes to savings estimates and incremental costs addressed during the review process and final site verification of installed measures."]
["Project Description:",null,null,null,"Electric Rate",7.6200000000000004E-2,"Gas Rate",0.86650000000000005]
["Organization Name:"]
["Date:"]
["Oregon Energy Code:"]
["Project Type:"]
[]
["Description"]
["Sector","Commercial","←HIDE"]
[null,null,null,null,null,null,null,null,"↓HIDE","↓HIDE",null,null,"↓HIDE",null,null,null,null,null,null,"↓HIDE","↓HIDE","↓HIDE",null,"↓HIDE","↓HIDE"]
["#","Measure","Sub-sector","Assumed Load Profile",null,"Projected Measure Life \n(yrs)","Estimated Savings",null,"Estimated Savings For CEC",null,"Estimated Incremental Cost\n($)","Potential Non-Energy Benefits (Annual $)","NEBs for CEC","Estimated Program Incentive \n($)","Utility BCR","TRC BCR","Meets Energy Trust CE Criteria?","Estimated Payback Before Incentive\n(yrs)",null,null,"Incentive Split",null,null,"Utility Benefit"]
[null,null,null,"Electric","Gas",null,"kWh","therms","kWh","therms",null,null,null,null,null,null,null,null,null,"Full Ele Load Profile","Electric","Gas",null,"Electric","Gas"]
[1,null,null,null,null,null,null,null,{"$f":"IF(G16=\"\",\"\",G16*Incentives_SM!$I$4)","v":""},{"$f":"IF(H16=\"\",\"\",H16*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L16+(NOT(Incentives_SM!$I$4)*G16*$F$5)+(NOT(Incentives_SM!$J$4)*H16*$H$5),\"\")","v":0},{"$f":"IF(B16=\"\",\"\",Incentives_SM!I15)","v":""},{"$f":"IFERROR((GasAC(F16, E16)*J16+EleAC(F16, T16)*I16)/Incentives_SM!F15, \"\")","v":""},{"$f":"IFERROR((GasAC(F16, E16)*J16+EleAC(F16, T16)*I16+PV(discount,F16, -M16))/K16, \"\")","v":""},{"$f":"IF(B16=\"\",\"\",Incentives_SM!H15)","v":""},{"$f":"IFERROR(K16/(I16*$F$5+J16*$H$5+M16),\"\")","v":""},null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D16, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C16,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D16,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F16, T16)*I16/(EleAC(F16,T16)*I16+GasAC(F16,E16)*J16)*N16, \"\")","v":""},{"$f":"IF(U16=\"\", \"\", N16-U16)","v":""},null,{"$f":"IFERROR((EleAC(F16, T16)*I16),\"\")","v":""},{"$f":"IFERROR((GasAC(F16, E16)*J16),\"\")","v":""}]
[{"$f":"A16+1","v":2},null,null,null,null,null,null,null,{"$f":"IF(G17=\"\",\"\",G17*Incentives_SM!$I$4)","v":""},{"$f":"IF(H17=\"\",\"\",H17*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L17+(NOT(Incentives_SM!$I$4)*G17*$F$5)+(NOT(Incentives_SM!$J$4)*H17*$H$5),\"\")","v":0},{"$f":"IF(B17=\"\",\"\",Incentives_SM!I16)","v":""},{"$f":"IFERROR((GasAC(F17, E17)*J17+EleAC(F17, T17)*I17)/Incentives_SM!F16, \"\")","v":""},{"$f":"IFERROR((GasAC(F17, E17)*J17+EleAC(F17, T17)*I17+PV(discount,F17, -M17))/K17, \"\")","v":""},{"$f":"IF(B17=\"\",\"\",Incentives_SM!H16)","v":""},{"$f":"IFERROR(K17/(I17*$F$5+J17*$H$5+M17),\"\")","v":""},null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D17, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C17,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D17,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F17, T17)*I17/(EleAC(F17,T17)*I17+GasAC(F17,E17)*J17)*N17, \"\")","v":""},{"$f":"IF(U17=\"\", \"\", N17-U17)","v":""},null,{"$f":"IFERROR((EleAC(F17, T17)*I17),\"\")","v":""},{"$f":"IFERROR((GasAC(F17, E17)*J17),\"\")","v":""}]
[{"$f":"A17+1","v":3},null,null,null,null,null,null,null,{"$f":"IF(G18=\"\",\"\",G18*Incentives_SM!$I$4)","v":""},{"$f":"IF(H18=\"\",\"\",H18*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L18+(NOT(Incentives_SM!$I$4)*G18*$F$5)+(NOT(Incentives_SM!$J$4)*H18*$H$5),\"\")","v":0},{"$f":"IF(B18=\"\",\"\",Incentives_SM!I17)","v":""},{"$f":"IFERROR((GasAC(F18, E18)*J18+EleAC(F18, T18)*I18)/Incentives_SM!F17, \"\")","v":""},{"$f":"IFERROR((GasAC(F18, E18)*J18+EleAC(F18, T18)*I18+PV(discount,F18, -M18))/K18, \"\")","v":""},{"$f":"IF(B18=\"\",\"\",Incentives_SM!H17)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D18, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C18,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D18,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F18, T18)*I18/(EleAC(F18,T18)*I18+GasAC(F18,E18)*J18)*N18, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F18, T18)*I18),\"\")","v":""},{"$f":"IFERROR((GasAC(F18, E18)*J18),\"\")","v":""}]
[4,null,null,null,null,null,null,null,{"$f":"IF(G19=\"\",\"\",G19*Incentives_SM!$I$4)","v":""},{"$f":"IF(H19=\"\",\"\",H19*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L19+(NOT(Incentives_SM!$I$4)*G19*$F$5)+(NOT(Incentives_SM!$J$4)*H19*$H$5),\"\")","v":0},{"$f":"IF(B19=\"\",\"\",Incentives_SM!I18)","v":""},{"$f":"IFERROR((GasAC(F19, E19)*J19+EleAC(F19, T19)*I19)/Incentives_SM!F18, \"\")","v":""},{"$f":"IFERROR((GasAC(F19, E19)*J19+EleAC(F19, T19)*I19+PV(discount,F19, -M19))/K19, \"\")","v":""},{"$f":"IF(B19=\"\",\"\",Incentives_SM!H18)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D19, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C19,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D19,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F19, T19)*I19/(EleAC(F19,T19)*I19+GasAC(F19,E19)*J19)*N19, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F19, T19)*I19),\"\")","v":""},{"$f":"IFERROR((GasAC(F19, E19)*J19),\"\")","v":""}]
[5,null,null,null,null,null,null,null,{"$f":"IF(G20=\"\",\"\",G20*Incentives_SM!$I$4)","v":""},{"$f":"IF(H20=\"\",\"\",H20*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L20+(NOT(Incentives_SM!$I$4)*G20*$F$5)+(NOT(Incentives_SM!$J$4)*H20*$H$5),\"\")","v":0},{"$f":"IF(B20=\"\",\"\",Incentives_SM!I19)","v":""},{"$f":"IFERROR((GasAC(F20, E20)*J20+EleAC(F20, T20)*I20)/Incentives_SM!F19, \"\")","v":""},{"$f":"IFERROR((GasAC(F20, E20)*J20+EleAC(F20, T20)*I20+PV(discount,F20, -M20))/K20, \"\")","v":""},{"$f":"IF(B20=\"\",\"\",Incentives_SM!H19)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D20, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C20,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D20,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F20, T20)*I20/(EleAC(F20,T20)*I20+GasAC(F20,E20)*J20)*N20, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F20, T20)*I20),\"\")","v":""},{"$f":"IFERROR((GasAC(F20, E20)*J20),\"\")","v":""}]
[6,null,null,null,null,null,null,null,{"$f":"IF(G21=\"\",\"\",G21*Incentives_SM!$I$4)","v":""},{"$f":"IF(H21=\"\",\"\",H21*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L21+(NOT(Incentives_SM!$I$4)*G21*$F$5)+(NOT(Incentives_SM!$J$4)*H21*$H$5),\"\")","v":0},{"$f":"IF(B21=\"\",\"\",Incentives_SM!I20)","v":""},{"$f":"IFERROR((GasAC(F21, E21)*J21+EleAC(F21, T21)*I21)/Incentives_SM!F20, \"\")","v":""},{"$f":"IFERROR((GasAC(F21, E21)*J21+EleAC(F21, T21)*I21+PV(discount,F21, -M21))/K21, \"\")","v":""},{"$f":"IF(B21=\"\",\"\",Incentives_SM!H20)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D21, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C21,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D21,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F21, T21)*I21/(EleAC(F21,T21)*I21+GasAC(F21,E21)*J21)*N21, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F21, T21)*I21),\"\")","v":""},{"$f":"IFERROR((GasAC(F21, E21)*J21),\"\")","v":""}]
[7,null,null,null,null,null,null,null,{"$f":"IF(G22=\"\",\"\",G22*Incentives_SM!$I$4)","v":""},{"$f":"IF(H22=\"\",\"\",H22*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L22+(NOT(Incentives_SM!$I$4)*G22*$F$5)+(NOT(Incentives_SM!$J$4)*H22*$H$5),\"\")","v":0},{"$f":"IF(B22=\"\",\"\",Incentives_SM!I21)","v":""},{"$f":"IFERROR((GasAC(F22, E22)*J22+EleAC(F22, T22)*I22)/Incentives_SM!F21, \"\")","v":""},{"$f":"IFERROR((GasAC(F22, E22)*J22+EleAC(F22, T22)*I22+PV(discount,F22, -M22))/K22, \"\")","v":""},{"$f":"IF(B22=\"\",\"\",Incentives_SM!H21)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D22, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C22,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D22,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F22, T22)*I22/(EleAC(F22,T22)*I22+GasAC(F22,E22)*J22)*N22, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F22, T22)*I22),\"\")","v":""},{"$f":"IFERROR((GasAC(F22, E22)*J22),\"\")","v":""}]
[8,null,null,null,null,null,null,null,{"$f":"IF(G23=\"\",\"\",G23*Incentives_SM!$I$4)","v":""},{"$f":"IF(H23=\"\",\"\",H23*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L23+(NOT(Incentives_SM!$I$4)*G23*$F$5)+(NOT(Incentives_SM!$J$4)*H23*$H$5),\"\")","v":0},{"$f":"IF(B23=\"\",\"\",Incentives_SM!I22)","v":""},{"$f":"IFERROR((GasAC(F23, E23)*J23+EleAC(F23, T23)*I23)/Incentives_SM!F22, \"\")","v":""},{"$f":"IFERROR((GasAC(F23, E23)*J23+EleAC(F23, T23)*I23+PV(discount,F23, -M23))/K23, \"\")","v":""},{"$f":"IF(B23=\"\",\"\",Incentives_SM!H22)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D23, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C23,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D23,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F23, T23)*I23/(EleAC(F23,T23)*I23+GasAC(F23,E23)*J23)*N23, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F23, T23)*I23),\"\")","v":""},{"$f":"IFERROR((GasAC(F23, E23)*J23),\"\")","v":""}]
[9,null,null,null,null,null,null,null,{"$f":"IF(G24=\"\",\"\",G24*Incentives_SM!$I$4)","v":""},{"$f":"IF(H24=\"\",\"\",H24*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L24+(NOT(Incentives_SM!$I$4)*G24*$F$5)+(NOT(Incentives_SM!$J$4)*H24*$H$5),\"\")","v":0},{"$f":"IF(B24=\"\",\"\",Incentives_SM!I23)","v":""},{"$f":"IFERROR((GasAC(F24, E24)*J24+EleAC(F24, T24)*I24)/Incentives_SM!F23, \"\")","v":""},{"$f":"IFERROR((GasAC(F24, E24)*J24+EleAC(F24, T24)*I24+PV(discount,F24, -M24))/K24, \"\")","v":""},{"$f":"IF(B24=\"\",\"\",Incentives_SM!H23)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D24, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C24,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D24,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F24, T24)*I24/(EleAC(F24,T24)*I24+GasAC(F24,E24)*J24)*N24, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F24, T24)*I24),\"\")","v":""},{"$f":"IFERROR((GasAC(F24, E24)*J24),\"\")","v":""}]
[10,null,null,null,null,null,null,null,{"$f":"IF(G25=\"\",\"\",G25*Incentives_SM!$I$4)","v":""},{"$f":"IF(H25=\"\",\"\",H25*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L25+(NOT(Incentives_SM!$I$4)*G25*$F$5)+(NOT(Incentives_SM!$J$4)*H25*$H$5),\"\")","v":0},{"$f":"IF(B25=\"\",\"\",Incentives_SM!I24)","v":""},{"$f":"IFERROR((GasAC(F25, E25)*J25+EleAC(F25, T25)*I25)/Incentives_SM!F24, \"\")","v":""},null,{"$f":"IF(B25=\"\",\"\",Incentives_SM!H24)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D25, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C25,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D25,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F25, T25)*I25/(EleAC(F25,T25)*I25+GasAC(F25,E25)*J25)*N25, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F25, T25)*I25),\"\")","v":""},{"$f":"IFERROR((GasAC(F25, E25)*J25),\"\")","v":""}]
[11,null,null,null,null,null,null,null,{"$f":"IF(G26=\"\",\"\",G26*Incentives_SM!$I$4)","v":""},{"$f":"IF(H26=\"\",\"\",H26*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L26+(NOT(Incentives_SM!$I$4)*G26*$F$5)+(NOT(Incentives_SM!$J$4)*H26*$H$5),\"\")","v":0},{"$f":"IF(B26=\"\",\"\",Incentives_SM!I25)","v":""},{"$f":"IFERROR((GasAC(F26, E26)*J26+EleAC(F26, T26)*I26)/Incentives_SM!F25, \"\")","v":""},{"$f":"IFERROR((GasAC(F26, E26)*J26+EleAC(F26, T26)*I26+PV(discount,F26, -M26))/K26, \"\")","v":""},{"$f":"IF(B26=\"\",\"\",Incentives_SM!H25)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D26, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C26,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D26,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F26, T26)*I26/(EleAC(F26,T26)*I26+GasAC(F26,E26)*J26)*N26, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F26, T26)*I26),\"\")","v":""},{"$f":"IFERROR((GasAC(F26, E26)*J26),\"\")","v":""}]
[12,null,null,null,null,null,null,null,{"$f":"IF(G27=\"\",\"\",G27*Incentives_SM!$I$4)","v":""},{"$f":"IF(H27=\"\",\"\",H27*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L27+(NOT(Incentives_SM!$I$4)*G27*$F$5)+(NOT(Incentives_SM!$J$4)*H27*$H$5),\"\")","v":0},{"$f":"IF(B27=\"\",\"\",Incentives_SM!I26)","v":""},{"$f":"IFERROR((GasAC(F27, E27)*J27+EleAC(F27, T27)*I27)/Incentives_SM!F26, \"\")","v":""},{"$f":"IFERROR((GasAC(F27, E27)*J27+EleAC(F27, T27)*I27+PV(discount,F27, -M27))/K27, \"\")","v":""},{"$f":"IF(B27=\"\",\"\",Incentives_SM!H26)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D27, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C27,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D27,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F27, T27)*I27/(EleAC(F27,T27)*I27+GasAC(F27,E27)*J27)*N27, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F27, T27)*I27),\"\")","v":""},{"$f":"IFERROR((GasAC(F27, E27)*J27),\"\")","v":""}]
[13,null,null,null,null,null,null,null,{"$f":"IF(G28=\"\",\"\",G28*Incentives_SM!$I$4)","v":""},{"$f":"IF(H28=\"\",\"\",H28*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L28+(NOT(Incentives_SM!$I$4)*G28*$F$5)+(NOT(Incentives_SM!$J$4)*H28*$H$5),\"\")","v":0},{"$f":"IF(B28=\"\",\"\",Incentives_SM!I27)","v":""},{"$f":"IFERROR((GasAC(F28, E28)*J28+EleAC(F28, T28)*I28)/Incentives_SM!F27, \"\")","v":""},{"$f":"IFERROR((GasAC(F28, E28)*J28+EleAC(F28, T28)*I28+PV(discount,F28, -M28))/K28, \"\")","v":""},{"$f":"IF(B28=\"\",\"\",Incentives_SM!H27)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D28, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C28,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D28,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F28, T28)*I28/(EleAC(F28,T28)*I28+GasAC(F28,E28)*J28)*N28, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F28, T28)*I28),\"\")","v":""},{"$f":"IFERROR((GasAC(F28, E28)*J28),\"\")","v":""}]
[14,null,null,null,null,null,null,null,{"$f":"IF(G29=\"\",\"\",G29*Incentives_SM!$I$4)","v":""},{"$f":"IF(H29=\"\",\"\",H29*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L29+(NOT(Incentives_SM!$I$4)*G29*$F$5)+(NOT(Incentives_SM!$J$4)*H29*$H$5),\"\")","v":0},{"$f":"IF(B29=\"\",\"\",Incentives_SM!I28)","v":""},{"$f":"IFERROR((GasAC(F29, E29)*J29+EleAC(F29, T29)*I29)/Incentives_SM!F28, \"\")","v":""},{"$f":"IFERROR((GasAC(F29, E29)*J29+EleAC(F29, T29)*I29+PV(discount,F29, -M29))/K29, \"\")","v":""},{"$f":"IF(B29=\"\",\"\",Incentives_SM!H28)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D29, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C29,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D29,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F29, T29)*I29/(EleAC(F29,T29)*I29+GasAC(F29,E29)*J29)*N29, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F29, T29)*I29),\"\")","v":""},{"$f":"IFERROR((GasAC(F29, E29)*J29),\"\")","v":""}]
[15,null,null,null,null,null,null,null,{"$f":"IF(G30=\"\",\"\",G30*Incentives_SM!$I$4)","v":""},{"$f":"IF(H30=\"\",\"\",H30*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L30+(NOT(Incentives_SM!$I$4)*G30*$F$5)+(NOT(Incentives_SM!$J$4)*H30*$H$5),\"\")","v":0},{"$f":"IF(B30=\"\",\"\",Incentives_SM!I29)","v":""},{"$f":"IFERROR((GasAC(F30, E30)*J30+EleAC(F30, T30)*I30)/Incentives_SM!F29, \"\")","v":""},{"$f":"IFERROR((GasAC(F30, E30)*J30+EleAC(F30, T30)*I30+PV(discount,F30, -M30))/K30, \"\")","v":""},{"$f":"IF(B30=\"\",\"\",Incentives_SM!H29)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D30, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C30,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D30,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F30, T30)*I30/(EleAC(F30,T30)*I30+GasAC(F30,E30)*J30)*N30, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F30, T30)*I30),\"\")","v":""},{"$f":"IFERROR((GasAC(F30, E30)*J30),\"\")","v":""}]
[16,null,null,null,null,null,null,null,{"$f":"IF(G31=\"\",\"\",G31*Incentives_SM!$I$4)","v":""},{"$f":"IF(H31=\"\",\"\",H31*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L31+(NOT(Incentives_SM!$I$4)*G31*$F$5)+(NOT(Incentives_SM!$J$4)*H31*$H$5),\"\")","v":0},{"$f":"IF(B31=\"\",\"\",Incentives_SM!I30)","v":""},{"$f":"IFERROR((GasAC(F31, E31)*J31+EleAC(F31, T31)*I31)/Incentives_SM!F30, \"\")","v":""},{"$f":"IFERROR((GasAC(F31, E31)*J31+EleAC(F31, T31)*I31+PV(discount,F31, -M31))/K31, \"\")","v":""},{"$f":"IF(B31=\"\",\"\",Incentives_SM!H30)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D31, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C31,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D31,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F31, T31)*I31/(EleAC(F31,T31)*I31+GasAC(F31,E31)*J31)*N31, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F31, T31)*I31),\"\")","v":""},{"$f":"IFERROR((GasAC(F31, E31)*J31),\"\")","v":""}]
[17,null,null,null,null,null,null,null,{"$f":"IF(G32=\"\",\"\",G32*Incentives_SM!$I$4)","v":""},{"$f":"IF(H32=\"\",\"\",H32*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L32+(NOT(Incentives_SM!$I$4)*G32*$F$5)+(NOT(Incentives_SM!$J$4)*H32*$H$5),\"\")","v":0},{"$f":"IF(B32=\"\",\"\",Incentives_SM!I31)","v":""},{"$f":"IFERROR((GasAC(F32, E32)*J32+EleAC(F32, T32)*I32)/Incentives_SM!F31, \"\")","v":""},{"$f":"IFERROR((GasAC(F32, E32)*J32+EleAC(F32, T32)*I32+PV(discount,F32, -M32))/K32, \"\")","v":""},{"$f":"IF(B32=\"\",\"\",Incentives_SM!H31)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D32, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C32,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D32,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F32, T32)*I32/(EleAC(F32,T32)*I32+GasAC(F32,E32)*J32)*N32, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F32, T32)*I32),\"\")","v":""},{"$f":"IFERROR((GasAC(F32, E32)*J32),\"\")","v":""}]
[18,null,null,null,null,null,null,null,{"$f":"IF(G33=\"\",\"\",G33*Incentives_SM!$I$4)","v":""},{"$f":"IF(H33=\"\",\"\",H33*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L33+(NOT(Incentives_SM!$I$4)*G33*$F$5)+(NOT(Incentives_SM!$J$4)*H33*$H$5),\"\")","v":0},{"$f":"IF(B33=\"\",\"\",Incentives_SM!I32)","v":""},{"$f":"IFERROR((GasAC(F33, E33)*J33+EleAC(F33, T33)*I33)/Incentives_SM!F32, \"\")","v":""},{"$f":"IFERROR((GasAC(F33, E33)*J33+EleAC(F33, T33)*I33+PV(discount,F33, -M33))/K33, \"\")","v":""},{"$f":"IF(B33=\"\",\"\",Incentives_SM!H32)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D33, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C33,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D33,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F33, T33)*I33/(EleAC(F33,T33)*I33+GasAC(F33,E33)*J33)*N33, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F33, T33)*I33),\"\")","v":""},{"$f":"IFERROR((GasAC(F33, E33)*J33),\"\")","v":""}]
[19,null,null,null,null,null,null,null,{"$f":"IF(G34=\"\",\"\",G34*Incentives_SM!$I$4)","v":""},{"$f":"IF(H34=\"\",\"\",H34*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L34+(NOT(Incentives_SM!$I$4)*G34*$F$5)+(NOT(Incentives_SM!$J$4)*H34*$H$5),\"\")","v":0},{"$f":"IF(B34=\"\",\"\",Incentives_SM!I33)","v":""},{"$f":"IFERROR((GasAC(F34, E34)*J34+EleAC(F34, T34)*I34)/Incentives_SM!F33, \"\")","v":""},{"$f":"IFERROR((GasAC(F34, E34)*J34+EleAC(F34, T34)*I34+PV(discount,F34, -M34))/K34, \"\")","v":""},{"$f":"IF(B34=\"\",\"\",Incentives_SM!H33)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D34, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C34,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D34,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F34, T34)*I34/(EleAC(F34,T34)*I34+GasAC(F34,E34)*J34)*N34, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F34, T34)*I34),\"\")","v":""},{"$f":"IFERROR((GasAC(F34, E34)*J34),\"\")","v":""}]
[20,null,null,null,null,null,null,null,{"$f":"IF(G35=\"\",\"\",G35*Incentives_SM!$I$4)","v":""},{"$f":"IF(H35=\"\",\"\",H35*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L35+(NOT(Incentives_SM!$I$4)*G35*$F$5)+(NOT(Incentives_SM!$J$4)*H35*$H$5),\"\")","v":0},{"$f":"IF(B35=\"\",\"\",Incentives_SM!I34)","v":""},{"$f":"IFERROR((GasAC(F35, E35)*J35+EleAC(F35, T35)*I35)/Incentives_SM!F34, \"\")","v":""},{"$f":"IFERROR((GasAC(F35, E35)*J35+EleAC(F35, T35)*I35+PV(discount,F35, -M35))/K35, \"\")","v":""},{"$f":"IF(B35=\"\",\"\",Incentives_SM!H34)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D35, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C35,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D35,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F35, T35)*I35/(EleAC(F35,T35)*I35+GasAC(F35,E35)*J35)*N35, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F35, T35)*I35),\"\")","v":""},{"$f":"IFERROR((GasAC(F35, E35)*J35),\"\")","v":""}]
[21,null,null,null,null,null,null,null,{"$f":"IF(G36=\"\",\"\",G36*Incentives_SM!$I$4)","v":""},{"$f":"IF(H36=\"\",\"\",H36*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L36+(NOT(Incentives_SM!$I$4)*G36*$F$5)+(NOT(Incentives_SM!$J$4)*H36*$H$5),\"\")","v":0},{"$f":"IF(B36=\"\",\"\",Incentives_SM!I35)","v":""},{"$f":"IFERROR((GasAC(F36, E36)*J36+EleAC(F36, T36)*I36)/Incentives_SM!F35, \"\")","v":""},{"$f":"IFERROR((GasAC(F36, E36)*J36+EleAC(F36, T36)*I36+PV(discount,F36, -M36))/K36, \"\")","v":""},{"$f":"IF(B36=\"\",\"\",Incentives_SM!H35)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D36, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C36,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D36,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F36, T36)*I36/(EleAC(F36,T36)*I36+GasAC(F36,E36)*J36)*N36, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F36, T36)*I36),\"\")","v":""},{"$f":"IFERROR((GasAC(F36, E36)*J36),\"\")","v":""}]
[22,null,null,null,null,null,null,null,{"$f":"IF(G37=\"\",\"\",G37*Incentives_SM!$I$4)","v":""},{"$f":"IF(H37=\"\",\"\",H37*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L37+(NOT(Incentives_SM!$I$4)*G37*$F$5)+(NOT(Incentives_SM!$J$4)*H37*$H$5),\"\")","v":0},{"$f":"IF(B37=\"\",\"\",Incentives_SM!I36)","v":""},{"$f":"IFERROR((GasAC(F37, E37)*J37+EleAC(F37, T37)*I37)/Incentives_SM!F36, \"\")","v":""},{"$f":"IFERROR((GasAC(F37, E37)*J37+EleAC(F37, T37)*I37+PV(discount,F37, -M37))/K37, \"\")","v":""},{"$f":"IF(B37=\"\",\"\",Incentives_SM!H36)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D37, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C37,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D37,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F37, T37)*I37/(EleAC(F37,T37)*I37+GasAC(F37,E37)*J37)*N37, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F37, T37)*I37),\"\")","v":""},{"$f":"IFERROR((GasAC(F37, E37)*J37),\"\")","v":""}]
[23,null,null,null,null,null,null,null,{"$f":"IF(G38=\"\",\"\",G38*Incentives_SM!$I$4)","v":""},{"$f":"IF(H38=\"\",\"\",H38*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L38+(NOT(Incentives_SM!$I$4)*G38*$F$5)+(NOT(Incentives_SM!$J$4)*H38*$H$5),\"\")","v":0},{"$f":"IF(B38=\"\",\"\",Incentives_SM!I37)","v":""},{"$f":"IFERROR((GasAC(F38, E38)*J38+EleAC(F38, T38)*I38)/Incentives_SM!F37, \"\")","v":""},{"$f":"IFERROR((GasAC(F38, E38)*J38+EleAC(F38, T38)*I38+PV(discount,F38, -M38))/K38, \"\")","v":""},{"$f":"IF(B38=\"\",\"\",Incentives_SM!H37)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D38, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C38,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D38,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F38, T38)*I38/(EleAC(F38,T38)*I38+GasAC(F38,E38)*J38)*N38, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F38, T38)*I38),\"\")","v":""},{"$f":"IFERROR((GasAC(F38, E38)*J38),\"\")","v":""}]
[24,null,null,null,null,null,null,null,{"$f":"IF(G39=\"\",\"\",G39*Incentives_SM!$I$4)","v":""},{"$f":"IF(H39=\"\",\"\",H39*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L39+(NOT(Incentives_SM!$I$4)*G39*$F$5)+(NOT(Incentives_SM!$J$4)*H39*$H$5),\"\")","v":0},{"$f":"IF(B39=\"\",\"\",Incentives_SM!I38)","v":""},{"$f":"IFERROR((GasAC(F39, E39)*J39+EleAC(F39, T39)*I39)/Incentives_SM!F38, \"\")","v":""},{"$f":"IFERROR((GasAC(F39, E39)*J39+EleAC(F39, T39)*I39+PV(discount,F39, -M39))/K39, \"\")","v":""},{"$f":"IF(B39=\"\",\"\",Incentives_SM!H38)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D39, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C39,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D39,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F39, T39)*I39/(EleAC(F39,T39)*I39+GasAC(F39,E39)*J39)*N39, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F39, T39)*I39),\"\")","v":""},{"$f":"IFERROR((GasAC(F39, E39)*J39),\"\")","v":""}]
[25,null,null,null,null,null,null,null,{"$f":"IF(G40=\"\",\"\",G40*Incentives_SM!$I$4)","v":""},{"$f":"IF(H40=\"\",\"\",H40*Incentives_SM!$J$4)","v":""},null,null,{"$f":"IFERROR(L40+(NOT(Incentives_SM!$I$4)*G40*$F$5)+(NOT(Incentives_SM!$J$4)*H40*$H$5),\"\")","v":0},{"$f":"IF(B40=\"\",\"\",Incentives_SM!I39)","v":""},{"$f":"IFERROR((GasAC(F40, E40)*J40+EleAC(F40, T40)*I40)/Incentives_SM!F39, \"\")","v":""},{"$f":"IFERROR((GasAC(F40, E40)*J40+EleAC(F40, T40)*I40+PV(discount,F40, -M40))/K40, \"\")","v":""},{"$f":"IF(B40=\"\",\"\",Incentives_SM!H39)","v":""},"",null,{"$f":"IF(OR(Calculator_SM!$B$12=\"Residential\",Calculator_SM!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_SM!D40, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_SM!$C40,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_SM!D40,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F40, T40)*I40/(EleAC(F40,T40)*I40+GasAC(F40,E40)*J40)*N40, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F40, T40)*I40),\"\")","v":""},{"$f":"IFERROR((GasAC(F40, E40)*J40),\"\")","v":""}]

{"sheet":"Incentives_SM","index":2,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[null,"New Building Special Measure Incentive Rules",null,null,null,null,null,null,"Utility Eligibility"]
[null,"Measure Type","$/kWh","$/therm",null,"Incremental Cost Cap %","Minimum Payback (yrs)",null,"Electric","Gas"]
[null,"New Construction - Lighting",0.2,0.8,null,1,{"$f":"ROUND(0.95,1)","v":1},null,{"$f":"IF(Calculator_SM!F4<>\"Other\",TRUE,FALSE)","v":true},{"$f":"IF(Calculator_SM!H4<>\"Other\",TRUE,FALSE)","v":true}]
[null,"New Construction - Non-Lighting",0.15,0.8]
[null,"Major Renovation - Lighting",0.2,1]
[null,"Major Renovation - Non-Lighting",0.25,1]
[null,"as of 1/1/2016"]
[]
[]
[]
[]
["Incentive Calculator"]
["Measure","Lighting or Non-Lighting?","Electric Incentive if C/E","Gas Incentive if C/E","Incremental Cost Cap","Incentive if C/E","≥ Min Payback?","Cost Effective?","Eligible Incentive","Total Utility Benefit","Elec Allocation of Utility Benefit","Gas Allocation of Utility Benefit"]
[1,{"$f":"IF(Calculator_SM!B16=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D16)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B15=\"\",\"\",IF(Calculator_SM!I16<0,0,$I$4*Calculator_SM!I16*VLOOKUP(SM_Project_Type&\" - \"&B15,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B15=\"\",\"\",IF(Calculator_SM!J16<0,0,$J$4*Calculator_SM!J16*VLOOKUP(SM_Project_Type&\" - \"&B15,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B15=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K16)","v":""},{"$f":"IFERROR(MIN(C15+D15,E15),\"\")","v":""},{"$f":"IF(B15=\"\",\"\",IFERROR(IF(Calculator_SM!R16>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B15=\"\",\"\",IF(AND(N(Calculator_SM!O16)>=0.95, N(Calculator_SM!P16)>=0.95), \"Yes\", \"No\"))","v":""},{"$f":"IF(B15=\"\",\"\",IFERROR(IF(AND(G15=\"Yes\", H15=\"Yes\"), F15, 0), \"\"))","v":""},{"$f":"IF(AND(G15=\"Yes\",H15=\"Yes\"),SUM(Calculator_SM!X16:Y16),0)","v":0},{"$f":"IF(AND(G15=\"Yes\",H15=\"Yes\"),Calculator_SM!X16/J15,0)","v":0},{"$f":"IF(AND(G15=\"Yes\",H15=\"Yes\"),Calculator_SM!Y16/J15,0)","v":0}]
[2,{"$f":"IF(Calculator_SM!B17=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D17)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B16=\"\",\"\",IF(Calculator_SM!I17<0,0,$I$4*Calculator_SM!I17*VLOOKUP(SM_Project_Type&\" - \"&B16,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B16=\"\",\"\",IF(Calculator_SM!J17<0,0,$J$4*Calculator_SM!J17*VLOOKUP(SM_Project_Type&\" - \"&B16,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B16=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K17)","v":""},{"$f":"IFERROR(MIN(C16+D16,E16),\"\")","v":""},{"$f":"IF(B16=\"\",\"\",IFERROR(IF(Calculator_SM!R17>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B16=\"\",\"\",IF(AND(N(Calculator_SM!O17)>=0.95, N(Calculator_SM!P17)>=0.95), \"Yes\", \"No\"))","v":""},{"$f":"IF(B16=\"\",\"\",IFERROR(IF(AND(G16=\"Yes\", H16=\"Yes\"), F16, 0), \"\"))","v":""},{"$f":"IF(AND(G16=\"Yes\",H16=\"Yes\"),SUM(Calculator_SM!X17:Y17),0)","v":0},{"$f":"IF(AND(G16=\"Yes\",H16=\"Yes\"),Calculator_SM!X17/J16,0)","v":0},{"$f":"IF(AND(G16=\"Yes\",H16=\"Yes\"),Calculator_SM!Y17/J16,0)","v":0}]
[3,{"$f":"IF(Calculator_SM!B18=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D18)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B17=\"\",\"\",IF(Calculator_SM!I18<0,0,$I$4*Calculator_SM!I18*VLOOKUP(SM_Project_Type&\" - \"&B17,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B17=\"\",\"\",IF(Calculator_SM!J18<0,0,$J$4*Calculator_SM!J18*VLOOKUP(SM_Project_Type&\" - \"&B17,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B17=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K18)","v":""},"",{"$f":"IF(B17=\"\",\"\",IFERROR(IF(Calculator_SM!R18>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B17=\"\",\"\",IF(AND(N(Calculator_SM!O18)>=0.95, N(Calculator_SM!P18)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G17=\"Yes\",H17=\"Yes\"),SUM(Calculator_SM!X18:Y18),0)","v":0},{"$f":"IF(AND(G17=\"Yes\",H17=\"Yes\"),Calculator_SM!X18/J17,0)","v":0},{"$f":"IF(AND(G17=\"Yes\",H17=\"Yes\"),Calculator_SM!Y18/J17,0)","v":0}]
[4,{"$f":"IF(Calculator_SM!B19=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D19)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B18=\"\",\"\",IF(Calculator_SM!I19<0,0,$I$4*Calculator_SM!I19*VLOOKUP(SM_Project_Type&\" - \"&B18,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B18=\"\",\"\",IF(Calculator_SM!J19<0,0,$J$4*Calculator_SM!J19*VLOOKUP(SM_Project_Type&\" - \"&B18,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B18=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K19)","v":""},"",{"$f":"IF(B18=\"\",\"\",IFERROR(IF(Calculator_SM!R19>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B18=\"\",\"\",IF(AND(N(Calculator_SM!O19)>=0.95, N(Calculator_SM!P19)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G18=\"Yes\",H18=\"Yes\"),SUM(Calculator_SM!X19:Y19),0)","v":0},{"$f":"IF(AND(G18=\"Yes\",H18=\"Yes\"),Calculator_SM!X19/J18,0)","v":0},{"$f":"IF(AND(G18=\"Yes\",H18=\"Yes\"),Calculator_SM!Y19/J18,0)","v":0}]
[5,{"$f":"IF(Calculator_SM!B20=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D20)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B19=\"\",\"\",IF(Calculator_SM!I20<0,0,$I$4*Calculator_SM!I20*VLOOKUP(SM_Project_Type&\" - \"&B19,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B19=\"\",\"\",IF(Calculator_SM!J20<0,0,$J$4*Calculator_SM!J20*VLOOKUP(SM_Project_Type&\" - \"&B19,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B19=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K20)","v":""},"",{"$f":"IF(B19=\"\",\"\",IFERROR(IF(Calculator_SM!R20>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B19=\"\",\"\",IF(AND(N(Calculator_SM!O20)>=0.95, N(Calculator_SM!P20)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G19=\"Yes\",H19=\"Yes\"),SUM(Calculator_SM!X20:Y20),0)","v":0},{"$f":"IF(AND(G19=\"Yes\",H19=\"Yes\"),Calculator_SM!X20/J19,0)","v":0},{"$f":"IF(AND(G19=\"Yes\",H19=\"Yes\"),Calculator_SM!Y20/J19,0)","v":0}]
[6,{"$f":"IF(Calculator_SM!B21=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D21)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B20=\"\",\"\",IF(Calculator_SM!I21<0,0,$I$4*Calculator_SM!I21*VLOOKUP(SM_Project_Type&\" - \"&B20,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B20=\"\",\"\",IF(Calculator_SM!J21<0,0,$J$4*Calculator_SM!J21*VLOOKUP(SM_Project_Type&\" - \"&B20,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B20=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K21)","v":""},"",{"$f":"IF(B20=\"\",\"\",IFERROR(IF(Calculator_SM!R21>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B20=\"\",\"\",IF(AND(N(Calculator_SM!O21)>=0.95, N(Calculator_SM!P21)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G20=\"Yes\",H20=\"Yes\"),SUM(Calculator_SM!X21:Y21),0)","v":0},{"$f":"IF(AND(G20=\"Yes\",H20=\"Yes\"),Calculator_SM!X21/J20,0)","v":0},{"$f":"IF(AND(G20=\"Yes\",H20=\"Yes\"),Calculator_SM!Y21/J20,0)","v":0}]
[7,{"$f":"IF(Calculator_SM!B22=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D22)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B21=\"\",\"\",IF(Calculator_SM!I22<0,0,$I$4*Calculator_SM!I22*VLOOKUP(SM_Project_Type&\" - \"&B21,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B21=\"\",\"\",IF(Calculator_SM!J22<0,0,$J$4*Calculator_SM!J22*VLOOKUP(SM_Project_Type&\" - \"&B21,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B21=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K22)","v":""},"",{"$f":"IF(B21=\"\",\"\",IFERROR(IF(Calculator_SM!R22>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B21=\"\",\"\",IF(AND(N(Calculator_SM!O22)>=0.95, N(Calculator_SM!P22)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G21=\"Yes\",H21=\"Yes\"),SUM(Calculator_SM!X22:Y22),0)","v":0},{"$f":"IF(AND(G21=\"Yes\",H21=\"Yes\"),Calculator_SM!X22/J21,0)","v":0},{"$f":"IF(AND(G21=\"Yes\",H21=\"Yes\"),Calculator_SM!Y22/J21,0)","v":0}]
[8,{"$f":"IF(Calculator_SM!B23=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D23)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B22=\"\",\"\",IF(Calculator_SM!I23<0,0,$I$4*Calculator_SM!I23*VLOOKUP(SM_Project_Type&\" - \"&B22,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B22=\"\",\"\",IF(Calculator_SM!J23<0,0,$J$4*Calculator_SM!J23*VLOOKUP(SM_Project_Type&\" - \"&B22,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B22=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K23)","v":""},"",{"$f":"IF(B22=\"\",\"\",IFERROR(IF(Calculator_SM!R23>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B22=\"\",\"\",IF(AND(N(Calculator_SM!O23)>=0.95, N(Calculator_SM!P23)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G22=\"Yes\",H22=\"Yes\"),SUM(Calculator_SM!X23:Y23),0)","v":0},{"$f":"IF(AND(G22=\"Yes\",H22=\"Yes\"),Calculator_SM!X23/J22,0)","v":0},{"$f":"IF(AND(G22=\"Yes\",H22=\"Yes\"),Calculator_SM!Y23/J22,0)","v":0}]
[9,{"$f":"IF(Calculator_SM!B24=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D24)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B23=\"\",\"\",IF(Calculator_SM!I24<0,0,$I$4*Calculator_SM!I24*VLOOKUP(SM_Project_Type&\" - \"&B23,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B23=\"\",\"\",IF(Calculator_SM!J24<0,0,$J$4*Calculator_SM!J24*VLOOKUP(SM_Project_Type&\" - \"&B23,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B23=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K24)","v":""},"",{"$f":"IF(B23=\"\",\"\",IFERROR(IF(Calculator_SM!R24>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B23=\"\",\"\",IF(AND(N(Calculator_SM!O24)>=0.95, N(Calculator_SM!P24)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G23=\"Yes\",H23=\"Yes\"),SUM(Calculator_SM!X24:Y24),0)","v":0},{"$f":"IF(AND(G23=\"Yes\",H23=\"Yes\"),Calculator_SM!X24/J23,0)","v":0},{"$f":"IF(AND(G23=\"Yes\",H23=\"Yes\"),Calculator_SM!Y24/J23,0)","v":0}]
[10,{"$f":"IF(Calculator_SM!B25=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D25)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B24=\"\",\"\",IF(Calculator_SM!I25<0,0,$I$4*Calculator_SM!I25*VLOOKUP(SM_Project_Type&\" - \"&B24,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B24=\"\",\"\",IF(Calculator_SM!J25<0,0,$J$4*Calculator_SM!J25*VLOOKUP(SM_Project_Type&\" - \"&B24,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B24=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K25)","v":""},"",{"$f":"IF(B24=\"\",\"\",IFERROR(IF(Calculator_SM!R25>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B24=\"\",\"\",IF(AND(N(Calculator_SM!O25)>=0.95, N(Calculator_SM!P25)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G24=\"Yes\",H24=\"Yes\"),SUM(Calculator_SM!X25:Y25),0)","v":0},{"$f":"IF(AND(G24=\"Yes\",H24=\"Yes\"),Calculator_SM!X25/J24,0)","v":0},{"$f":"IF(AND(G24=\"Yes\",H24=\"Yes\"),Calculator_SM!Y25/J24,0)","v":0}]
[11,{"$f":"IF(Calculator_SM!B26=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D26)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B25=\"\",\"\",IF(Calculator_SM!I26<0,0,$I$4*Calculator_SM!I26*VLOOKUP(SM_Project_Type&\" - \"&B25,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B25=\"\",\"\",IF(Calculator_SM!J26<0,0,$J$4*Calculator_SM!J26*VLOOKUP(SM_Project_Type&\" - \"&B25,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B25=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K26)","v":""},"",{"$f":"IF(B25=\"\",\"\",IFERROR(IF(Calculator_SM!R26>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B25=\"\",\"\",IF(AND(N(Calculator_SM!O26)>=0.95, N(Calculator_SM!P26)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G25=\"Yes\",H25=\"Yes\"),SUM(Calculator_SM!X26:Y26),0)","v":0},{"$f":"IF(AND(G25=\"Yes\",H25=\"Yes\"),Calculator_SM!X26/J25,0)","v":0},{"$f":"IF(AND(G25=\"Yes\",H25=\"Yes\"),Calculator_SM!Y26/J25,0)","v":0}]
[12,{"$f":"IF(Calculator_SM!B27=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D27)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B26=\"\",\"\",IF(Calculator_SM!I27<0,0,$I$4*Calculator_SM!I27*VLOOKUP(SM_Project_Type&\" - \"&B26,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B26=\"\",\"\",IF(Calculator_SM!J27<0,0,$J$4*Calculator_SM!J27*VLOOKUP(SM_Project_Type&\" - \"&B26,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B26=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K27)","v":""},"",{"$f":"IF(B26=\"\",\"\",IFERROR(IF(Calculator_SM!R27>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B26=\"\",\"\",IF(AND(N(Calculator_SM!O27)>=0.95, N(Calculator_SM!P27)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G26=\"Yes\",H26=\"Yes\"),SUM(Calculator_SM!X27:Y27),0)","v":0},{"$f":"IF(AND(G26=\"Yes\",H26=\"Yes\"),Calculator_SM!X27/J26,0)","v":0},{"$f":"IF(AND(G26=\"Yes\",H26=\"Yes\"),Calculator_SM!Y27/J26,0)","v":0}]
[13,{"$f":"IF(Calculator_SM!B28=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D28)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B27=\"\",\"\",IF(Calculator_SM!I28<0,0,$I$4*Calculator_SM!I28*VLOOKUP(SM_Project_Type&\" - \"&B27,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B27=\"\",\"\",IF(Calculator_SM!J28<0,0,$J$4*Calculator_SM!J28*VLOOKUP(SM_Project_Type&\" - \"&B27,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B27=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K28)","v":""},"",{"$f":"IF(B27=\"\",\"\",IFERROR(IF(Calculator_SM!R28>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B27=\"\",\"\",IF(AND(N(Calculator_SM!O28)>=0.95, N(Calculator_SM!P28)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G27=\"Yes\",H27=\"Yes\"),SUM(Calculator_SM!X28:Y28),0)","v":0},{"$f":"IF(AND(G27=\"Yes\",H27=\"Yes\"),Calculator_SM!X28/J27,0)","v":0},{"$f":"IF(AND(G27=\"Yes\",H27=\"Yes\"),Calculator_SM!Y28/J27,0)","v":0}]
[14,{"$f":"IF(Calculator_SM!B29=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D29)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B28=\"\",\"\",IF(Calculator_SM!I29<0,0,$I$4*Calculator_SM!I29*VLOOKUP(SM_Project_Type&\" - \"&B28,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B28=\"\",\"\",IF(Calculator_SM!J29<0,0,$J$4*Calculator_SM!J29*VLOOKUP(SM_Project_Type&\" - \"&B28,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B28=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K29)","v":""},"",{"$f":"IF(B28=\"\",\"\",IFERROR(IF(Calculator_SM!R29>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B28=\"\",\"\",IF(AND(N(Calculator_SM!O29)>=0.95, N(Calculator_SM!P29)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G28=\"Yes\",H28=\"Yes\"),SUM(Calculator_SM!X29:Y29),0)","v":0},{"$f":"IF(AND(G28=\"Yes\",H28=\"Yes\"),Calculator_SM!X29/J28,0)","v":0},{"$f":"IF(AND(G28=\"Yes\",H28=\"Yes\"),Calculator_SM!Y29/J28,0)","v":0}]
[15,{"$f":"IF(Calculator_SM!B30=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D30)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B29=\"\",\"\",IF(Calculator_SM!I30<0,0,$I$4*Calculator_SM!I30*VLOOKUP(SM_Project_Type&\" - \"&B29,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B29=\"\",\"\",IF(Calculator_SM!J30<0,0,$J$4*Calculator_SM!J30*VLOOKUP(SM_Project_Type&\" - \"&B29,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B29=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K30)","v":""},"",{"$f":"IF(B29=\"\",\"\",IFERROR(IF(Calculator_SM!R30>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B29=\"\",\"\",IF(AND(N(Calculator_SM!O30)>=0.95, N(Calculator_SM!P30)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G29=\"Yes\",H29=\"Yes\"),SUM(Calculator_SM!X30:Y30),0)","v":0},{"$f":"IF(AND(G29=\"Yes\",H29=\"Yes\"),Calculator_SM!X30/J29,0)","v":0},{"$f":"IF(AND(G29=\"Yes\",H29=\"Yes\"),Calculator_SM!Y30/J29,0)","v":0}]
[16,{"$f":"IF(Calculator_SM!B31=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D31)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B30=\"\",\"\",IF(Calculator_SM!I31<0,0,$I$4*Calculator_SM!I31*VLOOKUP(SM_Project_Type&\" - \"&B30,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B30=\"\",\"\",IF(Calculator_SM!J31<0,0,$J$4*Calculator_SM!J31*VLOOKUP(SM_Project_Type&\" - \"&B30,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B30=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K31)","v":""},"",{"$f":"IF(B30=\"\",\"\",IFERROR(IF(Calculator_SM!R31>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B30=\"\",\"\",IF(AND(N(Calculator_SM!O31)>=0.95, N(Calculator_SM!P31)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G30=\"Yes\",H30=\"Yes\"),SUM(Calculator_SM!X31:Y31),0)","v":0},{"$f":"IF(AND(G30=\"Yes\",H30=\"Yes\"),Calculator_SM!X31/J30,0)","v":0},{"$f":"IF(AND(G30=\"Yes\",H30=\"Yes\"),Calculator_SM!Y31/J30,0)","v":0}]
[17,{"$f":"IF(Calculator_SM!B32=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D32)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B31=\"\",\"\",IF(Calculator_SM!I32<0,0,$I$4*Calculator_SM!I32*VLOOKUP(SM_Project_Type&\" - \"&B31,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B31=\"\",\"\",IF(Calculator_SM!J32<0,0,$J$4*Calculator_SM!J32*VLOOKUP(SM_Project_Type&\" - \"&B31,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B31=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K32)","v":""},"",{"$f":"IF(B31=\"\",\"\",IFERROR(IF(Calculator_SM!R32>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B31=\"\",\"\",IF(AND(N(Calculator_SM!O32)>=0.95, N(Calculator_SM!P32)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G31=\"Yes\",H31=\"Yes\"),SUM(Calculator_SM!X32:Y32),0)","v":0},{"$f":"IF(AND(G31=\"Yes\",H31=\"Yes\"),Calculator_SM!X32/J31,0)","v":0},{"$f":"IF(AND(G31=\"Yes\",H31=\"Yes\"),Calculator_SM!Y32/J31,0)","v":0}]
[18,{"$f":"IF(Calculator_SM!B33=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D33)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B32=\"\",\"\",IF(Calculator_SM!I33<0,0,$I$4*Calculator_SM!I33*VLOOKUP(SM_Project_Type&\" - \"&B32,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B32=\"\",\"\",IF(Calculator_SM!J33<0,0,$J$4*Calculator_SM!J33*VLOOKUP(SM_Project_Type&\" - \"&B32,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B32=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K33)","v":""},"",{"$f":"IF(B32=\"\",\"\",IFERROR(IF(Calculator_SM!R33>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B32=\"\",\"\",IF(AND(N(Calculator_SM!O33)>=0.95, N(Calculator_SM!P33)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G32=\"Yes\",H32=\"Yes\"),SUM(Calculator_SM!X33:Y33),0)","v":0},{"$f":"IF(AND(G32=\"Yes\",H32=\"Yes\"),Calculator_SM!X33/J32,0)","v":0},{"$f":"IF(AND(G32=\"Yes\",H32=\"Yes\"),Calculator_SM!Y33/J32,0)","v":0}]
[19,{"$f":"IF(Calculator_SM!B34=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D34)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B33=\"\",\"\",IF(Calculator_SM!I34<0,0,$I$4*Calculator_SM!I34*VLOOKUP(SM_Project_Type&\" - \"&B33,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B33=\"\",\"\",IF(Calculator_SM!J34<0,0,$J$4*Calculator_SM!J34*VLOOKUP(SM_Project_Type&\" - \"&B33,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B33=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K34)","v":""},"",{"$f":"IF(B33=\"\",\"\",IFERROR(IF(Calculator_SM!R34>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B33=\"\",\"\",IF(AND(N(Calculator_SM!O34)>=0.95, N(Calculator_SM!P34)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G33=\"Yes\",H33=\"Yes\"),SUM(Calculator_SM!X34:Y34),0)","v":0},{"$f":"IF(AND(G33=\"Yes\",H33=\"Yes\"),Calculator_SM!X34/J33,0)","v":0},{"$f":"IF(AND(G33=\"Yes\",H33=\"Yes\"),Calculator_SM!Y34/J33,0)","v":0}]
[20,{"$f":"IF(Calculator_SM!B35=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D35)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B34=\"\",\"\",IF(Calculator_SM!I35<0,0,$I$4*Calculator_SM!I35*VLOOKUP(SM_Project_Type&\" - \"&B34,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B34=\"\",\"\",IF(Calculator_SM!J35<0,0,$J$4*Calculator_SM!J35*VLOOKUP(SM_Project_Type&\" - \"&B34,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B34=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K35)","v":""},"",{"$f":"IF(B34=\"\",\"\",IFERROR(IF(Calculator_SM!R35>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B34=\"\",\"\",IF(AND(N(Calculator_SM!O35)>=0.95, N(Calculator_SM!P35)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G34=\"Yes\",H34=\"Yes\"),SUM(Calculator_SM!X35:Y35),0)","v":0},{"$f":"IF(AND(G34=\"Yes\",H34=\"Yes\"),Calculator_SM!X35/J34,0)","v":0},{"$f":"IF(AND(G34=\"Yes\",H34=\"Yes\"),Calculator_SM!Y35/J34,0)","v":0}]
[21,{"$f":"IF(Calculator_SM!B36=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D36)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B35=\"\",\"\",IF(Calculator_SM!I36<0,0,$I$4*Calculator_SM!I36*VLOOKUP(SM_Project_Type&\" - \"&B35,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B35=\"\",\"\",IF(Calculator_SM!J36<0,0,$J$4*Calculator_SM!J36*VLOOKUP(SM_Project_Type&\" - \"&B35,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B35=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K36)","v":""},"",{"$f":"IF(B35=\"\",\"\",IFERROR(IF(Calculator_SM!R36>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B35=\"\",\"\",IF(AND(N(Calculator_SM!O36)>=0.95, N(Calculator_SM!P36)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G35=\"Yes\",H35=\"Yes\"),SUM(Calculator_SM!X36:Y36),0)","v":0},{"$f":"IF(AND(G35=\"Yes\",H35=\"Yes\"),Calculator_SM!X36/J35,0)","v":0},{"$f":"IF(AND(G35=\"Yes\",H35=\"Yes\"),Calculator_SM!Y36/J35,0)","v":0}]
[22,{"$f":"IF(Calculator_SM!B37=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D37)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B36=\"\",\"\",IF(Calculator_SM!I37<0,0,$I$4*Calculator_SM!I37*VLOOKUP(SM_Project_Type&\" - \"&B36,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B36=\"\",\"\",IF(Calculator_SM!J37<0,0,$J$4*Calculator_SM!J37*VLOOKUP(SM_Project_Type&\" - \"&B36,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B36=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K37)","v":""},"",{"$f":"IF(B36=\"\",\"\",IFERROR(IF(Calculator_SM!R37>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B36=\"\",\"\",IF(AND(N(Calculator_SM!O37)>=0.95, N(Calculator_SM!P37)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G36=\"Yes\",H36=\"Yes\"),SUM(Calculator_SM!X37:Y37),0)","v":0},{"$f":"IF(AND(G36=\"Yes\",H36=\"Yes\"),Calculator_SM!X37/J36,0)","v":0},{"$f":"IF(AND(G36=\"Yes\",H36=\"Yes\"),Calculator_SM!Y37/J36,0)","v":0}]
[23,{"$f":"IF(Calculator_SM!B38=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D38)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B37=\"\",\"\",IF(Calculator_SM!I38<0,0,$I$4*Calculator_SM!I38*VLOOKUP(SM_Project_Type&\" - \"&B37,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B37=\"\",\"\",IF(Calculator_SM!J38<0,0,$J$4*Calculator_SM!J38*VLOOKUP(SM_Project_Type&\" - \"&B37,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B37=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K38)","v":""},"",{"$f":"IF(B37=\"\",\"\",IFERROR(IF(Calculator_SM!R38>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B37=\"\",\"\",IF(AND(N(Calculator_SM!O38)>=0.95, N(Calculator_SM!P38)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G37=\"Yes\",H37=\"Yes\"),SUM(Calculator_SM!X38:Y38),0)","v":0},{"$f":"IF(AND(G37=\"Yes\",H37=\"Yes\"),Calculator_SM!X38/J37,0)","v":0},{"$f":"IF(AND(G37=\"Yes\",H37=\"Yes\"),Calculator_SM!Y38/J37,0)","v":0}]
[24,{"$f":"IF(Calculator_SM!B39=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D39)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B38=\"\",\"\",IF(Calculator_SM!I39<0,0,$I$4*Calculator_SM!I39*VLOOKUP(SM_Project_Type&\" - \"&B38,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B38=\"\",\"\",IF(Calculator_SM!J39<0,0,$J$4*Calculator_SM!J39*VLOOKUP(SM_Project_Type&\" - \"&B38,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B38=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K39)","v":""},"",{"$f":"IF(B38=\"\",\"\",IFERROR(IF(Calculator_SM!R39>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B38=\"\",\"\",IF(AND(N(Calculator_SM!O39)>=0.95, N(Calculator_SM!P39)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G38=\"Yes\",H38=\"Yes\"),SUM(Calculator_SM!X39:Y39),0)","v":0},{"$f":"IF(AND(G38=\"Yes\",H38=\"Yes\"),Calculator_SM!X39/J38,0)","v":0},{"$f":"IF(AND(G38=\"Yes\",H38=\"Yes\"),Calculator_SM!Y39/J38,0)","v":0}]
[25,{"$f":"IF(Calculator_SM!B40=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_SM!D40)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B39=\"\",\"\",IF(Calculator_SM!I40<0,0,$I$4*Calculator_SM!I40*VLOOKUP(SM_Project_Type&\" - \"&B39,$B$3:$D$7,2,FALSE)))","v":""},{"$f":"IF(B39=\"\",\"\",IF(Calculator_SM!J40<0,0,$J$4*Calculator_SM!J40*VLOOKUP(SM_Project_Type&\" - \"&B39,$B$3:$D$7,3,FALSE)))","v":""},{"$f":"IF(B39=\"\",\"\",SM_inc_cost_cap*Calculator_SM!K40)","v":""},"",{"$f":"IF(B39=\"\",\"\",IFERROR(IF(Calculator_SM!R40>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B39=\"\",\"\",IF(AND(N(Calculator_SM!O40)>=0.95, N(Calculator_SM!P40)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G39=\"Yes\",H39=\"Yes\"),SUM(Calculator_SM!X40:Y40),0)","v":0},{"$f":"IF(AND(G39=\"Yes\",H39=\"Yes\"),Calculator_SM!X40/J39,0)","v":0},{"$f":"IF(AND(G39=\"Yes\",H39=\"Yes\"),Calculator_SM!Y40/J39,0)","v":0}]

{"sheet":"Calculator_MS","index":3,"n_rows":38,"n_cols":27,"rows_kept":38,"cut":false,"hidden":false,"merged":[[13,25,13,26],[33,8,34,8],[30,2,30,5],[31,2,31,5],[32,2,32,5],[13,17,14,17],[13,18,14,18],[13,19,14,19],[13,13,14,13],[13,8,13,9],[13,10,13,11],[13,14,14,14],[13,5,14,5],[13,6,13,7],[13,12,14,12],[13,15,14,15],[10,1,10,4],[37,2,37,5],[37,6,37,7],[32,6,32,7],[36,2,36,5],[36,6,36,7],[35,2,35,5],[33,2,33,5],[34,2,34,5],[13,22,13,23],[13,16,14,16],[12,21,12,23],[2,9,8,17],[0,0,0,5],[1,0,1,5],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,13,4],[3,1,3,2],[4,1,4,2],[6,1,6,2],[7,1,7,2],[5,1,5,2],[8,1,8,2]]}
["Savings Summary Worksheet - Energy Trust of Oregon New Buildings Program"]
["Based on:  Energy Trust of Oregon Cost Effectiveness Calculator v1.0\nVersion:  1/1/2016"]
[null,null,null,null,null,null,null,null,null,"NOTE TO USERS:  All Modeled Savings, Path to Net Zero and Data Center projects requiring cost effectiveness testing must be submitted for review and approval by Energy Trust.\n\nThis worksheet provides estimates of cost effectiveness and program incentives based on information submitted by the project analyst, including savings calculations, supporting documentation, incremental cost estimates, and other information as requested by Energy Trust. \n\nThis spreadsheet will be updated to address changes to savings estimates and incremental costs addressed during the review process and final site verification of installed measures."]
["Project Name:",null,null,null,"Electric Utility","PGE","Gas Utility","NWN"]
["Project Description:",null,null,null,"Electric Rate",7.6200000000000004E-2,"Gas Rate",0.86650000000000005]
["Organization Name:"]
["Date:"]
["Oregon Energy Code:"]
["Program Offering:"]
[]
["Description"]
["Sector","Commercial","←HIDE"]
[null,null,null,null,null,null,null,null,null,null,"↓HIDE","↓HIDE",null,null,"↓HIDE",null,null,null,null,null,null,"↓HIDE",null,null,null,"↓HIDE","↓HIDE"]
["#","Measure","Sub-sector","Assumed Load Profile",null,"Projected Measure Life \n(yrs)","Estimated Savings",null,"Adjusted Savings Estimates",null,"Estimated Savings For CEC",null,"Estimated Incremental Cost\n($)","Potential Non-Energy Benefits (Annual $)","NEBs for CEC","Estimated Program Incentive \n($)","Utility BCR","TRC BCR","Meets Energy Trust CE Criteria?","Payback Before Incentive",null,null,"Incentive Split",null,null,"Utility Benefit"]
[null,null,null,"Electric","Gas",null,"kWh","therms","kWh","therms","kWh","therms",null,null,null,null,null,null,null,null,null,"Full Ele Load Profile","Electric","Gas",null,"Electric","Gas"]
[1,null,null,null,null,null,null,null,{"$f":"IF(G16=\"\",\"\",IF(G16<0,G16,IF(G$32<>G$34,(G16*G$35/G$34),(G16))))","v":""},{"$f":"IF(H16=\"\",\"\",IF(H16<0,H16,IF(H$32<>H$34,(H16*H$35/H$34),(H16))))","v":""},{"$f":"IF(I16=\"\",\"\",I16*Incentives_MS!$I$4)","v":""},{"$f":"IF(J16=\"\",\"\",J16*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N16+(NOT(Incentives_MS!$I$4)*I16*$F$5)+(NOT(Incentives_MS!$J$4)*J16*$H$5),\"\")","v":""},{"$f":"IF(B16=\"\",\"\",Incentives_MS!I15)","v":""},{"$f":"IFERROR((GasAC(F16, E16)*L16+EleAC(F16, V16)*K16)/Incentives_MS!F15, \"\")","v":""},{"$f":"IFERROR((GasAC(F16, E16)*L16+EleAC(F16, V16)*K16+PV(discount,F16, -O16))/M16, \"\")","v":""},{"$f":"IF(B16=\"\",\"\",Incentives_MS!H15)","v":""},{"$f":"IFERROR(M16/(MIN(G16,I16)*$F$5+MIN(H16,J16)*$H$5),\"\")","v":""},null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D16, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C16,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D16,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F16, V16)*MAX(K16,0)/(EleAC(F16,V16)*K16+GasAC(F16,E16)*MAX(L16,0))*P16, \"\")","v":""},{"$f":"IF(W16=\"\", \"\", P16-W16)","v":""},null,{"$f":"IFERROR((EleAC(F16, V16)*K16),\"\")","v":""},{"$f":"IFERROR((GasAC(F16, E16)*L16),\"\")","v":""}]
[{"$f":"A16+1","v":2},null,null,null,null,null,null,null,"","",{"$f":"IF(I17=\"\",\"\",I17*Incentives_MS!$I$4)","v":""},{"$f":"IF(J17=\"\",\"\",J17*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N17+(NOT(Incentives_MS!$I$4)*I17*$F$5)+(NOT(Incentives_MS!$J$4)*J17*$H$5),\"\")","v":""},{"$f":"IF(B17=\"\",\"\",Incentives_MS!I16)","v":""},{"$f":"IFERROR((GasAC(F17, E17)*L17+EleAC(F17, V17)*K17)/Incentives_MS!F16, \"\")","v":""},{"$f":"IFERROR((GasAC(F17, E17)*L17+EleAC(F17, V17)*K17+PV(discount,F17, -O17))/M17, \"\")","v":""},{"$f":"IF(B17=\"\",\"\",Incentives_MS!H16)","v":""},{"$f":"IFERROR(M17/(MIN(G17,I17)*$F$5+MIN(H17,J17)*$H$5),\"\")","v":""},null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D17, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C17,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D17,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F17, V17)*MAX(K17,0)/(EleAC(F17,V17)*K17+GasAC(F17,E17)*MAX(L17,0))*P17, \"\")","v":""},{"$f":"IF(W17=\"\", \"\", P17-W17)","v":""},null,{"$f":"IFERROR((EleAC(F17, V17)*K17),\"\")","v":""},{"$f":"IFERROR((GasAC(F17, E17)*L17),\"\")","v":""}]
[{"$f":"A17+1","v":3},null,null,null,null,null,null,null,"","",{"$f":"IF(I18=\"\",\"\",I18*Incentives_MS!$I$4)","v":""},{"$f":"IF(J18=\"\",\"\",J18*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N18+(NOT(Incentives_MS!$I$4)*I18*$F$5)+(NOT(Incentives_MS!$J$4)*J18*$H$5),\"\")","v":""},{"$f":"IF(B18=\"\",\"\",Incentives_MS!I17)","v":""},{"$f":"IFERROR((GasAC(F18, E18)*L18+EleAC(F18, V18)*K18)/Incentives_MS!F17, \"\")","v":""},{"$f":"IFERROR((GasAC(F18, E18)*L18+EleAC(F18, V18)*K18+PV(discount,F18, -O18))/M18, \"\")","v":""},{"$f":"IF(B18=\"\",\"\",Incentives_MS!H17)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D18, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C18,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D18,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F18, V18)*MAX(K18,0)/(EleAC(F18,V18)*K18+GasAC(F18,E18)*MAX(L18,0))*P18, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F18, V18)*K18),\"\")","v":""},{"$f":"IFERROR((GasAC(F18, E18)*L18),\"\")","v":""}]
[4,null,null,null,null,null,null,null,"","",{"$f":"IF(I19=\"\",\"\",I19*Incentives_MS!$I$4)","v":""},{"$f":"IF(J19=\"\",\"\",J19*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N19+(NOT(Incentives_MS!$I$4)*I19*$F$5)+(NOT(Incentives_MS!$J$4)*J19*$H$5),\"\")","v":""},{"$f":"IF(B19=\"\",\"\",Incentives_MS!I18)","v":""},{"$f":"IFERROR((GasAC(F19, E19)*L19+EleAC(F19, V19)*K19)/Incentives_MS!F18, \"\")","v":""},{"$f":"IFERROR((GasAC(F19, E19)*L19+EleAC(F19, V19)*K19+PV(discount,F19, -O19))/M19, \"\")","v":""},{"$f":"IF(B19=\"\",\"\",Incentives_MS!H18)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D19, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C19,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D19,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F19, V19)*MAX(K19,0)/(EleAC(F19,V19)*K19+GasAC(F19,E19)*MAX(L19,0))*P19, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F19, V19)*K19),\"\")","v":""},{"$f":"IFERROR((GasAC(F19, E19)*L19),\"\")","v":""}]
[5,null,null,null,null,null,null,null,"","",{"$f":"IF(I20=\"\",\"\",I20*Incentives_MS!$I$4)","v":""},{"$f":"IF(J20=\"\",\"\",J20*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N20+(NOT(Incentives_MS!$I$4)*I20*$F$5)+(NOT(Incentives_MS!$J$4)*J20*$H$5),\"\")","v":""},{"$f":"IF(B20=\"\",\"\",Incentives_MS!I19)","v":""},{"$f":"IFERROR((GasAC(F20, E20)*L20+EleAC(F20, V20)*K20)/Incentives_MS!F19, \"\")","v":""},{"$f":"IFERROR((GasAC(F20, E20)*L20+EleAC(F20, V20)*K20+PV(discount,F20, -O20))/M20, \"\")","v":""},{"$f":"IF(B20=\"\",\"\",Incentives_MS!H19)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D20, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C20,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D20,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F20, V20)*MAX(K20,0)/(EleAC(F20,V20)*K20+GasAC(F20,E20)*MAX(L20,0))*P20, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F20, V20)*K20),\"\")","v":""},{"$f":"IFERROR((GasAC(F20, E20)*L20),\"\")","v":""}]
[6,null,null,null,null,null,null,null,"","",{"$f":"IF(I21=\"\",\"\",I21*Incentives_MS!$I$4)","v":""},{"$f":"IF(J21=\"\",\"\",J21*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N21+(NOT(Incentives_MS!$I$4)*I21*$F$5)+(NOT(Incentives_MS!$J$4)*J21*$H$5),\"\")","v":""},{"$f":"IF(B21=\"\",\"\",Incentives_MS!I20)","v":""},{"$f":"IFERROR((GasAC(F21, E21)*L21+EleAC(F21, V21)*K21)/Incentives_MS!F20, \"\")","v":""},{"$f":"IFERROR((GasAC(F21, E21)*L21+EleAC(F21, V21)*K21+PV(discount,F21, -O21))/M21, \"\")","v":""},{"$f":"IF(B21=\"\",\"\",Incentives_MS!H20)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D21, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C21,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D21,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F21, V21)*MAX(K21,0)/(EleAC(F21,V21)*K21+GasAC(F21,E21)*MAX(L21,0))*P21, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F21, V21)*K21),\"\")","v":""},{"$f":"IFERROR((GasAC(F21, E21)*L21),\"\")","v":""}]
[7,null,null,null,null,null,null,null,"","",{"$f":"IF(I22=\"\",\"\",I22*Incentives_MS!$I$4)","v":""},{"$f":"IF(J22=\"\",\"\",J22*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N22+(NOT(Incentives_MS!$I$4)*I22*$F$5)+(NOT(Incentives_MS!$J$4)*J22*$H$5),\"\")","v":""},{"$f":"IF(B22=\"\",\"\",Incentives_MS!I21)","v":""},{"$f":"IFERROR((GasAC(F22, E22)*L22+EleAC(F22, V22)*K22)/Incentives_MS!F21, \"\")","v":""},{"$f":"IFERROR((GasAC(F22, E22)*L22+EleAC(F22, V22)*K22+PV(discount,F22, -O22))/M22, \"\")","v":""},{"$f":"IF(B22=\"\",\"\",Incentives_MS!H21)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D22, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C22,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D22,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F22, V22)*MAX(K22,0)/(EleAC(F22,V22)*K22+GasAC(F22,E22)*MAX(L22,0))*P22, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F22, V22)*K22),\"\")","v":""},{"$f":"IFERROR((GasAC(F22, E22)*L22),\"\")","v":""}]
[8,null,null,null,null,null,null,null,"","",{"$f":"IF(I23=\"\",\"\",I23*Incentives_MS!$I$4)","v":""},{"$f":"IF(J23=\"\",\"\",J23*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N23+(NOT(Incentives_MS!$I$4)*I23*$F$5)+(NOT(Incentives_MS!$J$4)*J23*$H$5),\"\")","v":""},{"$f":"IF(B23=\"\",\"\",Incentives_MS!I22)","v":""},{"$f":"IFERROR((GasAC(F23, E23)*L23+EleAC(F23, V23)*K23)/Incentives_MS!F22, \"\")","v":""},{"$f":"IFERROR((GasAC(F23, E23)*L23+EleAC(F23, V23)*K23+PV(discount,F23, -O23))/M23, \"\")","v":""},{"$f":"IF(B23=\"\",\"\",Incentives_MS!H22)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D23, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C23,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D23,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F23, V23)*MAX(K23,0)/(EleAC(F23,V23)*K23+GasAC(F23,E23)*MAX(L23,0))*P23, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F23, V23)*K23),\"\")","v":""},{"$f":"IFERROR((GasAC(F23, E23)*L23),\"\")","v":""}]
[9,null,null,null,null,null,null,null,"","",{"$f":"IF(I24=\"\",\"\",I24*Incentives_MS!$I$4)","v":""},{"$f":"IF(J24=\"\",\"\",J24*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N24+(NOT(Incentives_MS!$I$4)*I24*$F$5)+(NOT(Incentives_MS!$J$4)*J24*$H$5),\"\")","v":""},{"$f":"IF(B24=\"\",\"\",Incentives_MS!I23)","v":""},{"$f":"IFERROR((GasAC(F24, E24)*L24+EleAC(F24, V24)*K24)/Incentives_MS!F23, \"\")","v":""},{"$f":"IFERROR((GasAC(F24, E24)*L24+EleAC(F24, V24)*K24+PV(discount,F24, -O24))/M24, \"\")","v":""},{"$f":"IF(B24=\"\",\"\",Incentives_MS!H23)","v":""},{"$f":"IFERROR(M24/(MIN(G24,I24)*$F$5+MIN(H24,J24)*$H$5),\"\")","v":""},null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D24, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C24,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D24,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F24, V24)*MAX(K24,0)/(EleAC(F24,V24)*K24+GasAC(F24,E24)*MAX(L24,0))*P24, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F24, V24)*K24),\"\")","v":""},{"$f":"IFERROR((GasAC(F24, E24)*L24),\"\")","v":""}]
[10,null,null,null,null,null,null,null,"","",{"$f":"IF(I25=\"\",\"\",I25*Incentives_MS!$I$4)","v":""},{"$f":"IF(J25=\"\",\"\",J25*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N25+(NOT(Incentives_MS!$I$4)*I25*$F$5)+(NOT(Incentives_MS!$J$4)*J25*$H$5),\"\")","v":""},{"$f":"IF(B25=\"\",\"\",Incentives_MS!I24)","v":""},{"$f":"IFERROR((GasAC(F25, E25)*L25+EleAC(F25, V25)*K25)/Incentives_MS!F24, \"\")","v":""},{"$f":"IFERROR((GasAC(F25, E25)*L25+EleAC(F25, V25)*K25+PV(discount,F25, -O25))/M25, \"\")","v":""},{"$f":"IF(B25=\"\",\"\",Incentives_MS!H24)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D25, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C25,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D25,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F25, V25)*MAX(K25,0)/(EleAC(F25,V25)*K25+GasAC(F25,E25)*MAX(L25,0))*P25, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F25, V25)*K25),\"\")","v":""},{"$f":"IFERROR((GasAC(F25, E25)*L25),\"\")","v":""}]
[11,null,null,null,null,null,null,null,"","",{"$f":"IF(I26=\"\",\"\",I26*Incentives_MS!$I$4)","v":""},{"$f":"IF(J26=\"\",\"\",J26*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N26+(NOT(Incentives_MS!$I$4)*I26*$F$5)+(NOT(Incentives_MS!$J$4)*J26*$H$5),\"\")","v":""},{"$f":"IF(B26=\"\",\"\",Incentives_MS!I25)","v":""},{"$f":"IFERROR((GasAC(F26, E26)*L26+EleAC(F26, V26)*K26)/Incentives_MS!F25, \"\")","v":""},{"$f":"IFERROR((GasAC(F26, E26)*L26+EleAC(F26, V26)*K26+PV(discount,F26, -O26))/M26, \"\")","v":""},{"$f":"IF(B26=\"\",\"\",Incentives_MS!H25)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D26, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C26,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D26,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F26, V26)*MAX(K26,0)/(EleAC(F26,V26)*K26+GasAC(F26,E26)*MAX(L26,0))*P26, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F26, V26)*K26),\"\")","v":""},{"$f":"IFERROR((GasAC(F26, E26)*L26),\"\")","v":""}]
[12,null,null,null,null,null,null,null,"","",{"$f":"IF(I27=\"\",\"\",I27*Incentives_MS!$I$4)","v":""},{"$f":"IF(J27=\"\",\"\",J27*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N27+(NOT(Incentives_MS!$I$4)*I27*$F$5)+(NOT(Incentives_MS!$J$4)*J27*$H$5),\"\")","v":""},{"$f":"IF(B27=\"\",\"\",Incentives_MS!I26)","v":""},{"$f":"IFERROR((GasAC(F27, E27)*L27+EleAC(F27, V27)*K27)/Incentives_MS!F26, \"\")","v":""},{"$f":"IFERROR((GasAC(F27, E27)*L27+EleAC(F27, V27)*K27+PV(discount,F27, -O27))/M27, \"\")","v":""},{"$f":"IF(B27=\"\",\"\",Incentives_MS!H26)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D27, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C27,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D27,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F27, V27)*MAX(K27,0)/(EleAC(F27,V27)*K27+GasAC(F27,E27)*MAX(L27,0))*P27, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F27, V27)*K27),\"\")","v":""},{"$f":"IFERROR((GasAC(F27, E27)*L27),\"\")","v":""}]
[13,null,null,null,null,null,null,null,"","",{"$f":"IF(I28=\"\",\"\",I28*Incentives_MS!$I$4)","v":""},{"$f":"IF(J28=\"\",\"\",J28*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N28+(NOT(Incentives_MS!$I$4)*I28*$F$5)+(NOT(Incentives_MS!$J$4)*J28*$H$5),\"\")","v":""},{"$f":"IF(B28=\"\",\"\",Incentives_MS!I27)","v":""},{"$f":"IFERROR((GasAC(F28, E28)*L28+EleAC(F28, V28)*K28)/Incentives_MS!F27, \"\")","v":""},{"$f":"IFERROR((GasAC(F28, E28)*L28+EleAC(F28, V28)*K28+PV(discount,F28, -O28))/M28, \"\")","v":""},{"$f":"IF(B28=\"\",\"\",Incentives_MS!H27)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D28, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C28,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D28,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F28, V28)*MAX(K28,0)/(EleAC(F28,V28)*K28+GasAC(F28,E28)*MAX(L28,0))*P28, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F28, V28)*K28),\"\")","v":""},{"$f":"IFERROR((GasAC(F28, E28)*L28),\"\")","v":""}]
[14,null,null,null,null,null,null,null,"","",{"$f":"IF(I29=\"\",\"\",I29*Incentives_MS!$I$4)","v":""},{"$f":"IF(J29=\"\",\"\",J29*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N29+(NOT(Incentives_MS!$I$4)*I29*$F$5)+(NOT(Incentives_MS!$J$4)*J29*$H$5),\"\")","v":""},{"$f":"IF(B29=\"\",\"\",Incentives_MS!I28)","v":""},{"$f":"IFERROR((GasAC(F29, E29)*L29+EleAC(F29, V29)*K29)/Incentives_MS!F28, \"\")","v":""},{"$f":"IFERROR((GasAC(F29, E29)*L29+EleAC(F29, V29)*K29+PV(discount,F29, -O29))/M29, \"\")","v":""},{"$f":"IF(B29=\"\",\"\",Incentives_MS!H28)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D29, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C29,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D29,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F29, V29)*MAX(K29,0)/(EleAC(F29,V29)*K29+GasAC(F29,E29)*MAX(L29,0))*P29, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F29, V29)*K29),\"\")","v":""},{"$f":"IFERROR((GasAC(F29, E29)*L29),\"\")","v":""}]
[15,null,null,null,null,null,null,null,"","",{"$f":"IF(I30=\"\",\"\",I30*Incentives_MS!$I$4)","v":""},{"$f":"IF(J30=\"\",\"\",J30*Incentives_MS!$J$4)","v":""},null,null,{"$f":"IFERROR(N30+(NOT(Incentives_MS!$I$4)*I30*$F$5)+(NOT(Incentives_MS!$J$4)*J30*$H$5),\"\")","v":""},{"$f":"IF(B30=\"\",\"\",Incentives_MS!I29)","v":""},{"$f":"IFERROR((GasAC(F30, E30)*L30+EleAC(F30, V30)*K30)/Incentives_MS!F29, \"\")","v":""},{"$f":"IFERROR((GasAC(F30, E30)*L30+EleAC(F30, V30)*K30+PV(discount,F30, -O30))/M30, \"\")","v":""},{"$f":"IF(B30=\"\",\"\",Incentives_MS!H29)","v":""},"",null,{"$f":"IF(OR(Calculator_MS!$B$12=\"Residential\",Calculator_MS!$B$12=\"Industrial\"),INDEX(ShapeNameList,MATCH(Calculator_MS!D30, ShapeDescriptions,0)),INDEX(Com_LP_Table,MATCH(Calculator_MS!$C30,'Com LU Table'!$B$3:$B$13,0),MATCH(Calculator_MS!D30,'Com LU Table'!$C$2:$P$2,0)))","v":{"$error":"#N/A"}},{"$f":"IFERROR(EleAC(F30, V30)*MAX(K30,0)/(EleAC(F30,V30)*K30+GasAC(F30,E30)*MAX(L30,0))*P30, \"\")","v":""},"",null,{"$f":"IFERROR((EleAC(F30, V30)*K30),\"\")","v":""},{"$f":"IFERROR((GasAC(F30, E30)*L30),\"\")","v":""}]
[null,null,"Subtotals",null,null,null,{"$f":"SUM(G16:G30)","v":0},0,0,0,{"$f":"SUM(K16:K30)","v":0},0,0,0,0,0]
[null,null,"Total Estimated Interactive Model Savings"]
[null,null,"Total Estimated Interactive Model Savings (kBtu)",null,null,null,{"$f":"G32*3.412+H32*100","v":0}]
[null,null,"Subtotals - Exclude Negative Savings",null,null,null,{"$f":"SUMIF(G16:G30,\">0\")","v":0},{"$f":"SUMIF(H16:H30,\">0\")","v":0},"←HIDE"]
[null,null,"Total Estimated Interactive Model Savings Plus Negative Savings",null,null,null,{"$f":"G32-(G31-G34)","v":0},{"$f":"H32-(H31-H34)","v":0}]
[null,null,"Total Estimated Baseline Energy Use "]
[null,null,"Total Estimated Baseline Energy Use (kBtu)",null,null,null,{"$f":"G36*3.412+H36*100","v":0}]
[null,null,"Estimated % Savings Over Code",null,null,null,{"$f":"IF(OR(G33=0,G37=0),\"\",ROUND((G33/G37),2))","v":""}]

{"sheet":"Incentives_MS","index":4,"n_rows":69,"n_cols":12,"rows_kept":69,"cut":false,"hidden":true,"merged":[[33,3,33,4],[32,3,32,6],[33,5,33,6]]}
[]
[null,"New Building Modeled Savings Incentive Rules",null,null,null,null,null,null,"Utility Eligibility"]
[null,"Project Type","$/kWh","$/therm",null,"Incremental Cost Cap %","Minimum Payback (yrs)",null,"Electric","Gas"]
[null,"Modeled Savings - Major Renovation - Lighting",{"$f":"VLOOKUP(Calculator_MS!$G$38,$C$36:$G$65,4)","v":{"$error":"#N/A"}},1,null,1,{"$f":"ROUND(0.95,0)","v":1},null,{"$f":"IF(Calculator_MS!F4<>\"Other\",TRUE,FALSE)","v":true},{"$f":"IF(Calculator_MS!H4<>\"Other\",TRUE,FALSE)","v":true}]
[null,"Modeled Savings - Major Renovation - Non-Lighting",{"$f":"VLOOKUP(Calculator_MS!$G$38,$C$36:$G$65,5)","v":{"$error":"#N/A"}},1]
[null,"Modeled Savings - New Construction - Lighting",{"$f":"VLOOKUP(Calculator_MS!$G$38,$C$36:$G$65,2)","v":{"$error":"#N/A"}},0.8]
[null,"Modeled Savings - New Construction - Non-Lighting",{"$f":"VLOOKUP(Calculator_MS!$G$38,$C$36:$G$65,3)","v":{"$error":"#N/A"}},0.8]
[null,"Data Center - Lighting",0.2,0.8]
[null,"Data Center - Non-Lighting",0.2,0.8]
[null,"Path to Net Zero - Lighting",0.4,1.2]
[null,"Path to Net Zero - Non-Lighting",0.4,1.2]
[null,"as of 1/1/2016"]
["Incentive Calculator"]
["Measure","Lighting or Non-Lighting?","Electric Incentive if C/E","Gas Incentive if C/E","Incremental Cost Cap","Incentive if C/E","≥ Min Payback?","Cost Effective?","Eligible Incentive","Total Utility Benefit","Elec Allocation of Utility Benefit","Gas Allocation of Utility Benefit"]
[1,{"$f":"IF(Calculator_MS!B16=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D16)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B15=\"\",\"\",IF(Calculator_MS!I16<0,0,$I$4*Calculator_MS!I16*VLOOKUP(MS_Project_Type&\" - \"&B15,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B15=\"\",\"\",IF(Calculator_MS!J16<0,0,$J$4*Calculator_MS!J16*VLOOKUP(MS_Project_Type&\" - \"&B15,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B15=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M16,\"n/a\"))","v":""},{"$f":"IFERROR(MIN(C15+D15,E15),\"\")","v":""},{"$f":"IF(B15=\"\",\"\",IFERROR(IF(Calculator_MS!T16>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B15=\"\",\"\",IF(AND(N(Calculator_MS!Q16)>=0.95, N(Calculator_MS!R16)>=0.95), \"Yes\", \"No\"))","v":""},{"$f":"IF(B15=\"\",\"\",IFERROR(IF(AND(G15=\"Yes\", H15=\"Yes\"), F15, 0), \"\"))","v":""},{"$f":"IF(AND(G15=\"Yes\",H15=\"Yes\"),SUM(Calculator_MS!Z16:AA16),0)","v":0},{"$f":"IF(AND(G15=\"Yes\",H15=\"Yes\"),Calculator_MS!Z16/J15,0)","v":0},{"$f":"IF(AND(G15=\"Yes\",H15=\"Yes\"),Calculator_MS!AA16/J15,0)","v":0}]
[2,{"$f":"IF(Calculator_MS!B17=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D17)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B16=\"\",\"\",IF(Calculator_MS!I17<0,0,$I$4*Calculator_MS!I17*VLOOKUP(MS_Project_Type&\" - \"&B16,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B16=\"\",\"\",IF(Calculator_MS!J17<0,0,$J$4*Calculator_MS!J17*VLOOKUP(MS_Project_Type&\" - \"&B16,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B16=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M17,\"n/a\"))","v":""},{"$f":"IFERROR(MIN(C16+D16,E16),\"\")","v":""},{"$f":"IF(B16=\"\",\"\",IFERROR(IF(Calculator_MS!T17>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B16=\"\",\"\",IF(AND(N(Calculator_MS!Q17)>=0.95, N(Calculator_MS!R17)>=0.95), \"Yes\", \"No\"))","v":""},{"$f":"IF(B16=\"\",\"\",IFERROR(IF(AND(G16=\"Yes\", H16=\"Yes\"), F16, 0), \"\"))","v":""},{"$f":"IF(AND(G16=\"Yes\",H16=\"Yes\"),SUM(Calculator_MS!Z17:AA17),0)","v":0},{"$f":"IF(AND(G16=\"Yes\",H16=\"Yes\"),Calculator_MS!Z17/J16,0)","v":0},{"$f":"IF(AND(G16=\"Yes\",H16=\"Yes\"),Calculator_MS!AA17/J16,0)","v":0}]
[3,{"$f":"IF(Calculator_MS!B18=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D18)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B17=\"\",\"\",IF(Calculator_MS!I18<0,0,$I$4*Calculator_MS!I18*VLOOKUP(MS_Project_Type&\" - \"&B17,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B17=\"\",\"\",IF(Calculator_MS!J18<0,0,$J$4*Calculator_MS!J18*VLOOKUP(MS_Project_Type&\" - \"&B17,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B17=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M18,\"n/a\"))","v":""},"",{"$f":"IF(B17=\"\",\"\",IFERROR(IF(Calculator_MS!T18>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B17=\"\",\"\",IF(AND(N(Calculator_MS!Q18)>=0.95, N(Calculator_MS!R18)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G17=\"Yes\",H17=\"Yes\"),SUM(Calculator_MS!Z18:AA18),0)","v":0},{"$f":"IF(AND(G17=\"Yes\",H17=\"Yes\"),Calculator_MS!Z18/J17,0)","v":0},{"$f":"IF(AND(G17=\"Yes\",H17=\"Yes\"),Calculator_MS!AA18/J17,0)","v":0}]
[4,{"$f":"IF(Calculator_MS!B19=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D19)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B18=\"\",\"\",IF(Calculator_MS!I19<0,0,$I$4*Calculator_MS!I19*VLOOKUP(MS_Project_Type&\" - \"&B18,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B18=\"\",\"\",IF(Calculator_MS!J19<0,0,$J$4*Calculator_MS!J19*VLOOKUP(MS_Project_Type&\" - \"&B18,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B18=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M19,\"n/a\"))","v":""},"",{"$f":"IF(B18=\"\",\"\",IFERROR(IF(Calculator_MS!T19>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B18=\"\",\"\",IF(AND(N(Calculator_MS!Q19)>=0.95, N(Calculator_MS!R19)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G18=\"Yes\",H18=\"Yes\"),SUM(Calculator_MS!Z19:AA19),0)","v":0},{"$f":"IF(AND(G18=\"Yes\",H18=\"Yes\"),Calculator_MS!Z19/J18,0)","v":0},{"$f":"IF(AND(G18=\"Yes\",H18=\"Yes\"),Calculator_MS!AA19/J18,0)","v":0}]
[5,{"$f":"IF(Calculator_MS!B20=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D20)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B19=\"\",\"\",IF(Calculator_MS!I20<0,0,$I$4*Calculator_MS!I20*VLOOKUP(MS_Project_Type&\" - \"&B19,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B19=\"\",\"\",IF(Calculator_MS!J20<0,0,$J$4*Calculator_MS!J20*VLOOKUP(MS_Project_Type&\" - \"&B19,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B19=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M20,\"n/a\"))","v":""},"",{"$f":"IF(B19=\"\",\"\",IFERROR(IF(Calculator_MS!T20>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B19=\"\",\"\",IF(AND(N(Calculator_MS!Q20)>=0.95, N(Calculator_MS!R20)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G19=\"Yes\",H19=\"Yes\"),SUM(Calculator_MS!Z20:AA20),0)","v":0},{"$f":"IF(AND(G19=\"Yes\",H19=\"Yes\"),Calculator_MS!Z20/J19,0)","v":0},{"$f":"IF(AND(G19=\"Yes\",H19=\"Yes\"),Calculator_MS!AA20/J19,0)","v":0}]
[6,{"$f":"IF(Calculator_MS!B21=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D21)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B20=\"\",\"\",IF(Calculator_MS!I21<0,0,$I$4*Calculator_MS!I21*VLOOKUP(MS_Project_Type&\" - \"&B20,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B20=\"\",\"\",IF(Calculator_MS!J21<0,0,$J$4*Calculator_MS!J21*VLOOKUP(MS_Project_Type&\" - \"&B20,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B20=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M21,\"n/a\"))","v":""},"",{"$f":"IF(B20=\"\",\"\",IFERROR(IF(Calculator_MS!T21>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B20=\"\",\"\",IF(AND(N(Calculator_MS!Q21)>=0.95, N(Calculator_MS!R21)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G20=\"Yes\",H20=\"Yes\"),SUM(Calculator_MS!Z21:AA21),0)","v":0},{"$f":"IF(AND(G20=\"Yes\",H20=\"Yes\"),Calculator_MS!Z21/J20,0)","v":0},{"$f":"IF(AND(G20=\"Yes\",H20=\"Yes\"),Calculator_MS!AA21/J20,0)","v":0}]
[7,{"$f":"IF(Calculator_MS!B22=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D22)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B21=\"\",\"\",IF(Calculator_MS!I22<0,0,$I$4*Calculator_MS!I22*VLOOKUP(MS_Project_Type&\" - \"&B21,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B21=\"\",\"\",IF(Calculator_MS!J22<0,0,$J$4*Calculator_MS!J22*VLOOKUP(MS_Project_Type&\" - \"&B21,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B21=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M22,\"n/a\"))","v":""},"",{"$f":"IF(B21=\"\",\"\",IFERROR(IF(Calculator_MS!T22>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B21=\"\",\"\",IF(AND(N(Calculator_MS!Q22)>=0.95, N(Calculator_MS!R22)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G21=\"Yes\",H21=\"Yes\"),SUM(Calculator_MS!Z22:AA22),0)","v":0},{"$f":"IF(AND(G21=\"Yes\",H21=\"Yes\"),Calculator_MS!Z22/J21,0)","v":0},{"$f":"IF(AND(G21=\"Yes\",H21=\"Yes\"),Calculator_MS!AA22/J21,0)","v":0}]
[8,{"$f":"IF(Calculator_MS!B23=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D23)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B22=\"\",\"\",IF(Calculator_MS!I23<0,0,$I$4*Calculator_MS!I23*VLOOKUP(MS_Project_Type&\" - \"&B22,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B22=\"\",\"\",IF(Calculator_MS!J23<0,0,$J$4*Calculator_MS!J23*VLOOKUP(MS_Project_Type&\" - \"&B22,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B22=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M23,\"n/a\"))","v":""},"",{"$f":"IF(B22=\"\",\"\",IFERROR(IF(Calculator_MS!T23>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B22=\"\",\"\",IF(AND(N(Calculator_MS!Q23)>=0.95, N(Calculator_MS!R23)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G22=\"Yes\",H22=\"Yes\"),SUM(Calculator_MS!Z23:AA23),0)","v":0},{"$f":"IF(AND(G22=\"Yes\",H22=\"Yes\"),Calculator_MS!Z23/J22,0)","v":0},{"$f":"IF(AND(G22=\"Yes\",H22=\"Yes\"),Calculator_MS!AA23/J22,0)","v":0}]
[9,{"$f":"IF(Calculator_MS!B24=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D24)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B23=\"\",\"\",IF(Calculator_MS!I24<0,0,$I$4*Calculator_MS!I24*VLOOKUP(MS_Project_Type&\" - \"&B23,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B23=\"\",\"\",IF(Calculator_MS!J24<0,0,$J$4*Calculator_MS!J24*VLOOKUP(MS_Project_Type&\" - \"&B23,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B23=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M24,\"n/a\"))","v":""},"",{"$f":"IF(B23=\"\",\"\",IFERROR(IF(Calculator_MS!T24>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B23=\"\",\"\",IF(AND(N(Calculator_MS!Q24)>=0.95, N(Calculator_MS!R24)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G23=\"Yes\",H23=\"Yes\"),SUM(Calculator_MS!Z24:AA24),0)","v":0},{"$f":"IF(AND(G23=\"Yes\",H23=\"Yes\"),Calculator_MS!Z24/J23,0)","v":0},{"$f":"IF(AND(G23=\"Yes\",H23=\"Yes\"),Calculator_MS!AA24/J23,0)","v":0}]
[10,{"$f":"IF(Calculator_MS!B25=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D25)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B24=\"\",\"\",IF(Calculator_MS!I25<0,0,$I$4*Calculator_MS!I25*VLOOKUP(MS_Project_Type&\" - \"&B24,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B24=\"\",\"\",IF(Calculator_MS!J25<0,0,$J$4*Calculator_MS!J25*VLOOKUP(MS_Project_Type&\" - \"&B24,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B24=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M25,\"n/a\"))","v":""},"",{"$f":"IF(B24=\"\",\"\",IFERROR(IF(Calculator_MS!T25>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B24=\"\",\"\",IF(AND(N(Calculator_MS!Q25)>=0.95, N(Calculator_MS!R25)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G24=\"Yes\",H24=\"Yes\"),SUM(Calculator_MS!Z25:AA25),0)","v":0},{"$f":"IF(AND(G24=\"Yes\",H24=\"Yes\"),Calculator_MS!Z25/J24,0)","v":0},{"$f":"IF(AND(G24=\"Yes\",H24=\"Yes\"),Calculator_MS!AA25/J24,0)","v":0}]
[11,{"$f":"IF(Calculator_MS!B26=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D26)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B25=\"\",\"\",IF(Calculator_MS!I26<0,0,$I$4*Calculator_MS!I26*VLOOKUP(MS_Project_Type&\" - \"&B25,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B25=\"\",\"\",IF(Calculator_MS!J26<0,0,$J$4*Calculator_MS!J26*VLOOKUP(MS_Project_Type&\" - \"&B25,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B25=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M26,\"n/a\"))","v":""},"",{"$f":"IF(B25=\"\",\"\",IFERROR(IF(Calculator_MS!T26>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B25=\"\",\"\",IF(AND(N(Calculator_MS!Q26)>=0.95, N(Calculator_MS!R26)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G25=\"Yes\",H25=\"Yes\"),SUM(Calculator_MS!Z26:AA26),0)","v":0},{"$f":"IF(AND(G25=\"Yes\",H25=\"Yes\"),Calculator_MS!Z26/J25,0)","v":0},{"$f":"IF(AND(G25=\"Yes\",H25=\"Yes\"),Calculator_MS!AA26/J25,0)","v":0}]
[12,{"$f":"IF(Calculator_MS!B27=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D27)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B26=\"\",\"\",IF(Calculator_MS!I27<0,0,$I$4*Calculator_MS!I27*VLOOKUP(MS_Project_Type&\" - \"&B26,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B26=\"\",\"\",IF(Calculator_MS!J27<0,0,$J$4*Calculator_MS!J27*VLOOKUP(MS_Project_Type&\" - \"&B26,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B26=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M27,\"n/a\"))","v":""},"",{"$f":"IF(B26=\"\",\"\",IFERROR(IF(Calculator_MS!T27>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B26=\"\",\"\",IF(AND(N(Calculator_MS!Q27)>=0.95, N(Calculator_MS!R27)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G26=\"Yes\",H26=\"Yes\"),SUM(Calculator_MS!Z27:AA27),0)","v":0},{"$f":"IF(AND(G26=\"Yes\",H26=\"Yes\"),Calculator_MS!Z27/J26,0)","v":0},{"$f":"IF(AND(G26=\"Yes\",H26=\"Yes\"),Calculator_MS!AA27/J26,0)","v":0}]
[13,{"$f":"IF(Calculator_MS!B28=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D28)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B27=\"\",\"\",IF(Calculator_MS!I28<0,0,$I$4*Calculator_MS!I28*VLOOKUP(MS_Project_Type&\" - \"&B27,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B27=\"\",\"\",IF(Calculator_MS!J28<0,0,$J$4*Calculator_MS!J28*VLOOKUP(MS_Project_Type&\" - \"&B27,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B27=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M28,\"n/a\"))","v":""},"",{"$f":"IF(B27=\"\",\"\",IFERROR(IF(Calculator_MS!T28>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B27=\"\",\"\",IF(AND(N(Calculator_MS!Q28)>=0.95, N(Calculator_MS!R28)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G27=\"Yes\",H27=\"Yes\"),SUM(Calculator_MS!Z28:AA28),0)","v":0},{"$f":"IF(AND(G27=\"Yes\",H27=\"Yes\"),Calculator_MS!Z28/J27,0)","v":0},{"$f":"IF(AND(G27=\"Yes\",H27=\"Yes\"),Calculator_MS!AA28/J27,0)","v":0}]
[14,{"$f":"IF(Calculator_MS!B29=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D29)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B28=\"\",\"\",IF(Calculator_MS!I29<0,0,$I$4*Calculator_MS!I29*VLOOKUP(MS_Project_Type&\" - \"&B28,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B28=\"\",\"\",IF(Calculator_MS!J29<0,0,$J$4*Calculator_MS!J29*VLOOKUP(MS_Project_Type&\" - \"&B28,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B28=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M29,\"n/a\"))","v":""},"",{"$f":"IF(B28=\"\",\"\",IFERROR(IF(Calculator_MS!T29>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B28=\"\",\"\",IF(AND(N(Calculator_MS!Q29)>=0.95, N(Calculator_MS!R29)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G28=\"Yes\",H28=\"Yes\"),SUM(Calculator_MS!Z29:AA29),0)","v":0},{"$f":"IF(AND(G28=\"Yes\",H28=\"Yes\"),Calculator_MS!Z29/J28,0)","v":0},{"$f":"IF(AND(G28=\"Yes\",H28=\"Yes\"),Calculator_MS!AA29/J28,0)","v":0}]
[15,{"$f":"IF(Calculator_MS!B30=\"\",\"\",IF(ISERROR(FIND(\"Lighting\",Calculator_MS!D30)),\"Non-Lighting\",\"Lighting\"))","v":""},{"$f":"IF(B29=\"\",\"\",IF(Calculator_MS!I30<0,0,$I$4*Calculator_MS!I30*VLOOKUP(MS_Project_Type&\" - \"&B29,$B$3:$D$11,2,FALSE)))","v":""},{"$f":"IF(B29=\"\",\"\",IF(Calculator_MS!J30<0,0,$J$4*Calculator_MS!J30*VLOOKUP(MS_Project_Type&\" - \"&B29,$B$3:$D$11,3,FALSE)))","v":""},{"$f":"IF(B29=\"\",\"\",IF(MS_Project_Type=\"Modeled Savings - Major Renovation\",MS_inc_cost_cap*Calculator_MS!M30,\"n/a\"))","v":""},"",{"$f":"IF(B29=\"\",\"\",IFERROR(IF(Calculator_MS!T30>=$G$4, \"Yes\", \"No\"), \"\"))","v":""},{"$f":"IF(B29=\"\",\"\",IF(AND(N(Calculator_MS!Q30)>=0.95, N(Calculator_MS!R30)>=0.95), \"Yes\", \"No\"))","v":""},"",{"$f":"IF(AND(G29=\"Yes\",H29=\"Yes\"),SUM(Calculator_MS!Z30:AA30),0)","v":0},{"$f":"IF(AND(G29=\"Yes\",H29=\"Yes\"),Calculator_MS!Z30/J29,0)","v":0},{"$f":"IF(AND(G29=\"Yes\",H29=\"Yes\"),Calculator_MS!AA30/J29,0)","v":0}]
[]
[]
[]
[null,null,null,"Electric Incentive Rate($ per kWh)"]
[null,null,null,"2010/2014 Code - New Construction Projects",null,"2010/2014 Code - Major Renovation Projects"]
[null,null,"% savings beyond code","Lighting","Non-Lighting","Lighting","Non-Lighting"]
[null,null,0.01,0.2,0.15,0.2,0.25]
[null,null,0.02,0.2,0.15,0.2,0.25]
[null,null,0.03,0.2,0.15,0.2,0.25]
[null,null,0.04,0.2,0.15,0.2,0.25]
[null,null,0.05,0.2,0.15,0.2,0.25]
[null,null,0.06,0.2,0.15,0.2,0.25]
[null,null,7.0000000000000007E-2,0.2,0.15,0.2,0.25]
[null,null,0.08,0.2,0.15,0.2,0.25]
[null,null,0.09,0.2,0.15,0.2,0.25]
[null,null,0.1,0.2,0.15,0.2,0.25]
[null,null,0.11,0.2,0.15,0.2,0.25]
[null,null,0.12,0.2,0.15,0.2,0.25]
[null,null,0.13,0.2,0.15,0.2,0.25]
[null,null,0.14000000000000001,0.2,0.15,0.2,0.25]
[null,null,0.15,0.2,0.15,0.2,0.25]
[null,null,0.16,0.2,0.16,0.2,0.25]
[null,null,0.17,0.2,0.17,0.2,0.25]
[null,null,0.18,0.2,0.18,0.2,0.25]
[null,null,0.19,0.2,0.19,0.2,0.25]
[null,null,0.2,0.2,0.2,0.2,0.25]
[null,null,0.21,0.21,0.21,0.21,0.25]
[null,null,0.22,0.22,0.22,0.22,0.25]
[null,null,0.23,0.23,0.23,0.23,0.25]
[null,null,0.24,0.24,0.24,0.24,0.25]
[null,null,0.25,0.25,0.25,0.25,0.25]
[null,null,0.26,0.26,0.26,0.26,0.26]
[null,null,0.27,0.27,0.27,0.27,0.27]
[null,null,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003]
[null,null,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998]
[null,null,0.3,0.3,0.3,0.3,0.3]
[]
[null,null,"1. Major renovation lighting incentives are capped at 35% of eligible project cost, not to exceed 100% of incremental cost."]
[null,null,"2. Major renovation non-lighting incentives are capped at 50% of eligible project cost, not to exceed 100% of incremental cost."]
[null,null,"3. Major renovation gas incentives are capped at 35% of eligible project cost, not to exceed 100% of incremental cost."]

{"sheet":"Measure Totals","index":5,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":true,"merged":[[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[40,1,40,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[24,1,24,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[12,1,12,2],[0,0,0,1],[0,2,0,4],[1,0,1,1],[2,0,2,1],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2]]}
["Project Name"]
["Project #"]
["PT ID"]
[]
["Special Measures"]
["#","Measure Name",null,"Project Track Name","Incremental Cost","Measure Life","kWh savings","therm savings","kWh incentive","therm incentive","total incentive","Payback before incentive","negative kWh","negative therms","Elec Allocation of Utility Benefits","Gas Allocation of Utility Benefits"]
[1,{"$f":"Calculator_SM!B16","v":0},null,null,{"$f":"IF(K7=\"\", \"\",Calculator_SM!K16)","v":""},{"$f":"IF(K7=\"\", \"\", Calculator_SM!F16)","v":""},{"$f":"IF(OR(K7=\"\",Calculator_SM!I16<0),0,Calculator_SM!I16)","v":0},{"$f":"IF(OR(K7=\"\",Calculator_SM!J16<0),0,Calculator_SM!J16)","v":0},{"$f":"IF(K7=\"\",\"\",Calculator_SM!U16)","v":""},{"$f":"IF(K7=\"\",\"\",Calculator_SM!V16)","v":""},{"$f":"IF(OR(Incentives_SM!G15=\"No\",Incentives_SM!H15=\"No\"),\"\",Incentives_SM!I15)","v":""},{"$f":"Calculator_SM!R16","v":""},{"$f":"IF(OR(K7=\"\",Calculator_SM!I16>=0),\"\",Calculator_SM!I16)","v":""},{"$f":"IF(OR(K7=\"\",Calculator_SM!J16>=0),\"\",Calculator_SM!J16)","v":""},{"$f":"Incentives_SM!K15","v":0},{"$f":"Incentives_SM!L15","v":0}]
[2,{"$f":"Calculator_SM!B17","v":0},null,null,{"$f":"IF(K8=\"\", \"\",Calculator_SM!K17)","v":""},{"$f":"IF(K8=\"\", \"\", Calculator_SM!F17)","v":""},{"$f":"IF(OR(K8=\"\",Calculator_SM!I17<0),0,Calculator_SM!I17)","v":0},{"$f":"IF(OR(K8=\"\",Calculator_SM!J17<0),0,Calculator_SM!J17)","v":0},{"$f":"IF(K8=\"\",\"\",Calculator_SM!U17)","v":""},{"$f":"IF(K8=\"\",\"\",Calculator_SM!V17)","v":""},{"$f":"IF(OR(Incentives_SM!G16=\"No\",Incentives_SM!H16=\"No\"),\"\",Incentives_SM!I16)","v":""},{"$f":"Calculator_SM!R17","v":""},{"$f":"IF(OR(K8=\"\",Calculator_SM!I17>=0),\"\",Calculator_SM!I17)","v":""},{"$f":"IF(OR(K8=\"\",Calculator_SM!J17>=0),\"\",Calculator_SM!J17)","v":""},{"$f":"Incentives_SM!K16","v":0},{"$f":"Incentives_SM!L16","v":0}]
[3,{"$f":"Calculator_SM!B18","v":0},null,null,{"$f":"IF(K9=\"\", \"\",Calculator_SM!K18)","v":""},{"$f":"IF(K9=\"\", \"\", Calculator_SM!F18)","v":""},{"$f":"IF(OR(K9=\"\",Calculator_SM!I18<0),0,Calculator_SM!I18)","v":0},{"$f":"IF(OR(K9=\"\",Calculator_SM!J18<0),0,Calculator_SM!J18)","v":0},{"$f":"IF(K9=\"\",\"\",Calculator_SM!U18)","v":""},{"$f":"IF(K9=\"\",\"\",Calculator_SM!V18)","v":""},{"$f":"IF(OR(Incentives_SM!G17=\"No\",Incentives_SM!H17=\"No\"),\"\",Incentives_SM!I17)","v":""},{"$f":"Calculator_SM!R18","v":""},{"$f":"IF(OR(K9=\"\",Calculator_SM!I18>=0),\"\",Calculator_SM!I18)","v":""},{"$f":"IF(OR(K9=\"\",Calculator_SM!J18>=0),\"\",Calculator_SM!J18)","v":""},{"$f":"Incentives_SM!K17","v":0},{"$f":"Incentives_SM!L17","v":0}]
[4,{"$f":"Calculator_SM!B19","v":0},null,null,{"$f":"IF(K10=\"\", \"\",Calculator_SM!K19)","v":""},{"$f":"IF(K10=\"\", \"\", Calculator_SM!F19)","v":""},{"$f":"IF(OR(K10=\"\",Calculator_SM!I19<0),0,Calculator_SM!I19)","v":0},{"$f":"IF(OR(K10=\"\",Calculator_SM!J19<0),0,Calculator_SM!J19)","v":0},{"$f":"IF(K10=\"\",\"\",Calculator_SM!U19)","v":""},{"$f":"IF(K10=\"\",\"\",Calculator_SM!V19)","v":""},{"$f":"IF(OR(Incentives_SM!G18=\"No\",Incentives_SM!H18=\"No\"),\"\",Incentives_SM!I18)","v":""},{"$f":"Calculator_SM!R19","v":""},{"$f":"IF(OR(K10=\"\",Calculator_SM!I19>=0),\"\",Calculator_SM!I19)","v":""},{"$f":"IF(OR(K10=\"\",Calculator_SM!J19>=0),\"\",Calculator_SM!J19)","v":""},{"$f":"Incentives_SM!K18","v":0},{"$f":"Incentives_SM!L18","v":0}]
[5,{"$f":"Calculator_SM!B20","v":0},null,null,{"$f":"IF(K11=\"\", \"\",Calculator_SM!K20)","v":""},{"$f":"IF(K11=\"\", \"\", Calculator_SM!F20)","v":""},{"$f":"IF(OR(K11=\"\",Calculator_SM!I20<0),0,Calculator_SM!I20)","v":0},{"$f":"IF(OR(K11=\"\",Calculator_SM!J20<0),0,Calculator_SM!J20)","v":0},{"$f":"IF(K11=\"\",\"\",Calculator_SM!U20)","v":""},{"$f":"IF(K11=\"\",\"\",Calculator_SM!V20)","v":""},{"$f":"IF(OR(Incentives_SM!G19=\"No\",Incentives_SM!H19=\"No\"),\"\",Incentives_SM!I19)","v":""},{"$f":"Calculator_SM!R20","v":""},{"$f":"IF(OR(K11=\"\",Calculator_SM!I20>=0),\"\",Calculator_SM!I20)","v":""},{"$f":"IF(OR(K11=\"\",Calculator_SM!J20>=0),\"\",Calculator_SM!J20)","v":""},{"$f":"Incentives_SM!K19","v":0},{"$f":"Incentives_SM!L19","v":0}]
[6,{"$f":"Calculator_SM!B21","v":0},null,null,{"$f":"IF(K12=\"\", \"\",Calculator_SM!K21)","v":""},{"$f":"IF(K12=\"\", \"\", Calculator_SM!F21)","v":""},{"$f":"IF(OR(K12=\"\",Calculator_SM!I21<0),0,Calculator_SM!I21)","v":0},{"$f":"IF(OR(K12=\"\",Calculator_SM!J21<0),0,Calculator_SM!J21)","v":0},{"$f":"IF(K12=\"\",\"\",Calculator_SM!U21)","v":""},{"$f":"IF(K12=\"\",\"\",Calculator_SM!V21)","v":""},{"$f":"IF(OR(Incentives_SM!G20=\"No\",Incentives_SM!H20=\"No\"),\"\",Incentives_SM!I20)","v":""},{"$f":"Calculator_SM!R21","v":""},{"$f":"IF(OR(K12=\"\",Calculator_SM!I21>=0),\"\",Calculator_SM!I21)","v":""},{"$f":"IF(OR(K12=\"\",Calculator_SM!J21>=0),\"\",Calculator_SM!J21)","v":""},{"$f":"Incentives_SM!K20","v":0},{"$f":"Incentives_SM!L20","v":0}]
[7,{"$f":"Calculator_SM!B22","v":0},null,null,{"$f":"IF(K13=\"\", \"\",Calculator_SM!K22)","v":""},{"$f":"IF(K13=\"\", \"\", Calculator_SM!F22)","v":""},{"$f":"IF(OR(K13=\"\",Calculator_SM!I22<0),0,Calculator_SM!I22)","v":0},{"$f":"IF(OR(K13=\"\",Calculator_SM!J22<0),0,Calculator_SM!J22)","v":0},{"$f":"IF(K13=\"\",\"\",Calculator_SM!U22)","v":""},{"$f":"IF(K13=\"\",\"\",Calculator_SM!V22)","v":""},{"$f":"IF(OR(Incentives_SM!G21=\"No\",Incentives_SM!H21=\"No\"),\"\",Incentives_SM!I21)","v":""},{"$f":"Calculator_SM!R22","v":""},{"$f":"IF(OR(K13=\"\",Calculator_SM!I22>=0),\"\",Calculator_SM!I22)","v":""},{"$f":"IF(OR(K13=\"\",Calculator_SM!J22>=0),\"\",Calculator_SM!J22)","v":""},{"$f":"Incentives_SM!K21","v":0},{"$f":"Incentives_SM!L21","v":0}]
[8,{"$f":"Calculator_SM!B23","v":0},null,null,{"$f":"IF(K14=\"\", \"\",Calculator_SM!K23)","v":""},{"$f":"IF(K14=\"\", \"\", Calculator_SM!F23)","v":""},{"$f":"IF(OR(K14=\"\",Calculator_SM!I23<0),0,Calculator_SM!I23)","v":0},{"$f":"IF(OR(K14=\"\",Calculator_SM!J23<0),0,Calculator_SM!J23)","v":0},{"$f":"IF(K14=\"\",\"\",Calculator_SM!U23)","v":""},{"$f":"IF(K14=\"\",\"\",Calculator_SM!V23)","v":""},{"$f":"IF(OR(Incentives_SM!G22=\"No\",Incentives_SM!H22=\"No\"),\"\",Incentives_SM!I22)","v":""},{"$f":"Calculator_SM!R23","v":""},{"$f":"IF(OR(K14=\"\",Calculator_SM!I23>=0),\"\",Calculator_SM!I23)","v":""},{"$f":"IF(OR(K14=\"\",Calculator_SM!J23>=0),\"\",Calculator_SM!J23)","v":""},{"$f":"Incentives_SM!K22","v":0},{"$f":"Incentives_SM!L22","v":0}]
[9,{"$f":"Calculator_SM!B24","v":0},null,null,{"$f":"IF(K15=\"\", \"\",Calculator_SM!K24)","v":""},{"$f":"IF(K15=\"\", \"\", Calculator_SM!F24)","v":""},{"$f":"IF(OR(K15=\"\",Calculator_SM!I24<0),0,Calculator_SM!I24)","v":0},{"$f":"IF(OR(K15=\"\",Calculator_SM!J24<0),0,Calculator_SM!J24)","v":0},{"$f":"IF(K15=\"\",\"\",Calculator_SM!U24)","v":""},{"$f":"IF(K15=\"\",\"\",Calculator_SM!V24)","v":""},{"$f":"IF(OR(Incentives_SM!G23=\"No\",Incentives_SM!H23=\"No\"),\"\",Incentives_SM!I23)","v":""},{"$f":"Calculator_SM!R24","v":""},{"$f":"IF(OR(K15=\"\",Calculator_SM!I24>=0),\"\",Calculator_SM!I24)","v":""},{"$f":"IF(OR(K15=\"\",Calculator_SM!J24>=0),\"\",Calculator_SM!J24)","v":""},{"$f":"Incentives_SM!K23","v":0},{"$f":"Incentives_SM!L23","v":0}]
[10,{"$f":"Calculator_SM!B25","v":0},null,null,{"$f":"IF(K16=\"\", \"\",Calculator_SM!K25)","v":""},{"$f":"IF(K16=\"\", \"\", Calculator_SM!F25)","v":""},{"$f":"IF(OR(K16=\"\",Calculator_SM!I25<0),0,Calculator_SM!I25)","v":0},{"$f":"IF(OR(K16=\"\",Calculator_SM!J25<0),0,Calculator_SM!J25)","v":0},{"$f":"IF(K16=\"\",\"\",Calculator_SM!U25)","v":""},{"$f":"IF(K16=\"\",\"\",Calculator_SM!V25)","v":""},{"$f":"IF(OR(Incentives_SM!G24=\"No\",Incentives_SM!H24=\"No\"),\"\",Incentives_SM!I24)","v":""},{"$f":"Calculator_SM!R25","v":""},{"$f":"IF(OR(K16=\"\",Calculator_SM!I25>=0),\"\",Calculator_SM!I25)","v":""},{"$f":"IF(OR(K16=\"\",Calculator_SM!J25>=0),\"\",Calculator_SM!J25)","v":""},{"$f":"Incentives_SM!K24","v":0},{"$f":"Incentives_SM!L24","v":0}]
[11,{"$f":"Calculator_SM!B26","v":0},null,null,{"$f":"IF(K17=\"\", \"\",Calculator_SM!K26)","v":""},{"$f":"IF(K17=\"\", \"\", Calculator_SM!F26)","v":""},{"$f":"IF(OR(K17=\"\",Calculator_SM!I26<0),0,Calculator_SM!I26)","v":0},{"$f":"IF(OR(K17=\"\",Calculator_SM!J26<0),0,Calculator_SM!J26)","v":0},{"$f":"IF(K17=\"\",\"\",Calculator_SM!U26)","v":""},{"$f":"IF(K17=\"\",\"\",Calculator_SM!V26)","v":""},{"$f":"IF(OR(Incentives_SM!G25=\"No\",Incentives_SM!H25=\"No\"),\"\",Incentives_SM!I25)","v":""},{"$f":"Calculator_SM!R26","v":""},{"$f":"IF(OR(K17=\"\",Calculator_SM!I26>=0),\"\",Calculator_SM!I26)","v":""},{"$f":"IF(OR(K17=\"\",Calculator_SM!J26>=0),\"\",Calculator_SM!J26)","v":""},{"$f":"Incentives_SM!K25","v":0},{"$f":"Incentives_SM!L25","v":0}]
[12,{"$f":"Calculator_SM!B27","v":0},null,null,{"$f":"IF(K18=\"\", \"\",Calculator_SM!K27)","v":""},{"$f":"IF(K18=\"\", \"\", Calculator_SM!F27)","v":""},{"$f":"IF(OR(K18=\"\",Calculator_SM!I27<0),0,Calculator_SM!I27)","v":0},{"$f":"IF(OR(K18=\"\",Calculator_SM!J27<0),0,Calculator_SM!J27)","v":0},{"$f":"IF(K18=\"\",\"\",Calculator_SM!U27)","v":""},{"$f":"IF(K18=\"\",\"\",Calculator_SM!V27)","v":""},{"$f":"IF(OR(Incentives_SM!G26=\"No\",Incentives_SM!H26=\"No\"),\"\",Incentives_SM!I26)","v":""},{"$f":"Calculator_SM!R27","v":""},{"$f":"IF(OR(K18=\"\",Calculator_SM!I27>=0),\"\",Calculator_SM!I27)","v":""},{"$f":"IF(OR(K18=\"\",Calculator_SM!J27>=0),\"\",Calculator_SM!J27)","v":""},{"$f":"Incentives_SM!K26","v":0},{"$f":"Incentives_SM!L26","v":0}]
[13,{"$f":"Calculator_SM!B28","v":0},null,null,{"$f":"IF(K19=\"\", \"\",Calculator_SM!K28)","v":""},{"$f":"IF(K19=\"\", \"\", Calculator_SM!F28)","v":""},{"$f":"IF(OR(K19=\"\",Calculator_SM!I28<0),0,Calculator_SM!I28)","v":0},{"$f":"IF(OR(K19=\"\",Calculator_SM!J28<0),0,Calculator_SM!J28)","v":0},{"$f":"IF(K19=\"\",\"\",Calculator_SM!U28)","v":""},{"$f":"IF(K19=\"\",\"\",Calculator_SM!V28)","v":""},{"$f":"IF(OR(Incentives_SM!G27=\"No\",Incentives_SM!H27=\"No\"),\"\",Incentives_SM!I27)","v":""},{"$f":"Calculator_SM!R28","v":""},{"$f":"IF(OR(K19=\"\",Calculator_SM!I28>=0),\"\",Calculator_SM!I28)","v":""},{"$f":"IF(OR(K19=\"\",Calculator_SM!J28>=0),\"\",Calculator_SM!J28)","v":""},{"$f":"Incentives_SM!K27","v":0},{"$f":"Incentives_SM!L27","v":0}]
[14,{"$f":"Calculator_SM!B29","v":0},null,null,{"$f":"IF(K20=\"\", \"\",Calculator_SM!K29)","v":""},{"$f":"IF(K20=\"\", \"\", Calculator_SM!F29)","v":""},{"$f":"IF(OR(K20=\"\",Calculator_SM!I29<0),0,Calculator_SM!I29)","v":0},{"$f":"IF(OR(K20=\"\",Calculator_SM!J29<0),0,Calculator_SM!J29)","v":0},{"$f":"IF(K20=\"\",\"\",Calculator_SM!U29)","v":""},{"$f":"IF(K20=\"\",\"\",Calculator_SM!V29)","v":""},{"$f":"IF(OR(Incentives_SM!G28=\"No\",Incentives_SM!H28=\"No\"),\"\",Incentives_SM!I28)","v":""},{"$f":"Calculator_SM!R29","v":""},{"$f":"IF(OR(K20=\"\",Calculator_SM!I29>=0),\"\",Calculator_SM!I29)","v":""},{"$f":"IF(OR(K20=\"\",Calculator_SM!J29>=0),\"\",Calculator_SM!J29)","v":""},{"$f":"Incentives_SM!K28","v":0},{"$f":"Incentives_SM!L28","v":0}]
[15,{"$f":"Calculator_SM!B30","v":0},null,null,{"$f":"IF(K21=\"\", \"\",Calculator_SM!K30)","v":""},{"$f":"IF(K21=\"\", \"\", Calculator_SM!F30)","v":""},{"$f":"IF(OR(K21=\"\",Calculator_SM!I30<0),0,Calculator_SM!I30)","v":0},{"$f":"IF(OR(K21=\"\",Calculator_SM!J30<0),0,Calculator_SM!J30)","v":0},{"$f":"IF(K21=\"\",\"\",Calculator_SM!U30)","v":""},{"$f":"IF(K21=\"\",\"\",Calculator_SM!V30)","v":""},{"$f":"IF(OR(Incentives_SM!G29=\"No\",Incentives_SM!H29=\"No\"),\"\",Incentives_SM!I29)","v":""},{"$f":"Calculator_SM!R30","v":""},{"$f":"IF(OR(K21=\"\",Calculator_SM!I30>=0),\"\",Calculator_SM!I30)","v":""},{"$f":"IF(OR(K21=\"\",Calculator_SM!J30>=0),\"\",Calculator_SM!J30)","v":""},{"$f":"Incentives_SM!K29","v":0},{"$f":"Incentives_SM!L29","v":0}]
[16,{"$f":"Calculator_SM!B31","v":0},null,null,{"$f":"IF(K22=\"\", \"\",Calculator_SM!K31)","v":""},{"$f":"IF(K22=\"\", \"\", Calculator_SM!F31)","v":""},{"$f":"IF(OR(K22=\"\",Calculator_SM!I31<0),0,Calculator_SM!I31)","v":0},{"$f":"IF(OR(K22=\"\",Calculator_SM!J31<0),0,Calculator_SM!J31)","v":0},{"$f":"IF(K22=\"\",\"\",Calculator_SM!U31)","v":""},{"$f":"IF(K22=\"\",\"\",Calculator_SM!V31)","v":""},{"$f":"IF(OR(Incentives_SM!G30=\"No\",Incentives_SM!H30=\"No\"),\"\",Incentives_SM!I30)","v":""},{"$f":"Calculator_SM!R31","v":""},{"$f":"IF(OR(K22=\"\",Calculator_SM!I31>=0),\"\",Calculator_SM!I31)","v":""},{"$f":"IF(OR(K22=\"\",Calculator_SM!J31>=0),\"\",Calculator_SM!J31)","v":""},{"$f":"Incentives_SM!K30","v":0},{"$f":"Incentives_SM!L30","v":0}]
[17,{"$f":"Calculator_SM!B32","v":0},null,null,{"$f":"IF(K23=\"\", \"\",Calculator_SM!K32)","v":""},{"$f":"IF(K23=\"\", \"\", Calculator_SM!F32)","v":""},{"$f":"IF(OR(K23=\"\",Calculator_SM!I32<0),0,Calculator_SM!I32)","v":0},{"$f":"IF(OR(K23=\"\",Calculator_SM!J32<0),0,Calculator_SM!J32)","v":0},{"$f":"IF(K23=\"\",\"\",Calculator_SM!U32)","v":""},{"$f":"IF(K23=\"\",\"\",Calculator_SM!V32)","v":""},{"$f":"IF(OR(Incentives_SM!G31=\"No\",Incentives_SM!H31=\"No\"),\"\",Incentives_SM!I31)","v":""},{"$f":"Calculator_SM!R32","v":""},{"$f":"IF(OR(K23=\"\",Calculator_SM!I32>=0),\"\",Calculator_SM!I32)","v":""},{"$f":"IF(OR(K23=\"\",Calculator_SM!J32>=0),\"\",Calculator_SM!J32)","v":""},{"$f":"Incentives_SM!K31","v":0},{"$f":"Incentives_SM!L31","v":0}]
[18,{"$f":"Calculator_SM!B33","v":0},null,null,{"$f":"IF(K24=\"\", \"\",Calculator_SM!K33)","v":""},{"$f":"IF(K24=\"\", \"\", Calculator_SM!F33)","v":""},{"$f":"IF(OR(K24=\"\",Calculator_SM!I33<0),0,Calculator_SM!I33)","v":0},{"$f":"IF(OR(K24=\"\",Calculator_SM!J33<0),0,Calculator_SM!J33)","v":0},{"$f":"IF(K24=\"\",\"\",Calculator_SM!U33)","v":""},{"$f":"IF(K24=\"\",\"\",Calculator_SM!V33)","v":""},{"$f":"IF(OR(Incentives_SM!G32=\"No\",Incentives_SM!H32=\"No\"),\"\",Incentives_SM!I32)","v":""},{"$f":"Calculator_SM!R33","v":""},{"$f":"IF(OR(K24=\"\",Calculator_SM!I33>=0),\"\",Calculator_SM!I33)","v":""},{"$f":"IF(OR(K24=\"\",Calculator_SM!J33>=0),\"\",Calculator_SM!J33)","v":""},{"$f":"Incentives_SM!K32","v":0},{"$f":"Incentives_SM!L32","v":0}]
[19,{"$f":"Calculator_SM!B34","v":0},null,null,{"$f":"IF(K25=\"\", \"\",Calculator_SM!K34)","v":""},{"$f":"IF(K25=\"\", \"\", Calculator_SM!F34)","v":""},{"$f":"IF(OR(K25=\"\",Calculator_SM!I34<0),0,Calculator_SM!I34)","v":0},{"$f":"IF(OR(K25=\"\",Calculator_SM!J34<0),0,Calculator_SM!J34)","v":0},{"$f":"IF(K25=\"\",\"\",Calculator_SM!U34)","v":""},{"$f":"IF(K25=\"\",\"\",Calculator_SM!V34)","v":""},{"$f":"IF(OR(Incentives_SM!G33=\"No\",Incentives_SM!H33=\"No\"),\"\",Incentives_SM!I33)","v":""},{"$f":"Calculator_SM!R34","v":""},{"$f":"IF(OR(K25=\"\",Calculator_SM!I34>=0),\"\",Calculator_SM!I34)","v":""},{"$f":"IF(OR(K25=\"\",Calculator_SM!J34>=0),\"\",Calculator_SM!J34)","v":""},{"$f":"Incentives_SM!K33","v":0},{"$f":"Incentives_SM!L33","v":0}]
[20,{"$f":"Calculator_SM!B35","v":0},null,null,{"$f":"IF(K26=\"\", \"\",Calculator_SM!K35)","v":""},{"$f":"IF(K26=\"\", \"\", Calculator_SM!F35)","v":""},{"$f":"IF(OR(K26=\"\",Calculator_SM!I35<0),0,Calculator_SM!I35)","v":0},{"$f":"IF(OR(K26=\"\",Calculator_SM!J35<0),0,Calculator_SM!J35)","v":0},{"$f":"IF(K26=\"\",\"\",Calculator_SM!U35)","v":""},{"$f":"IF(K26=\"\",\"\",Calculator_SM!V35)","v":""},{"$f":"IF(OR(Incentives_SM!G34=\"No\",Incentives_SM!H34=\"No\"),\"\",Incentives_SM!I34)","v":""},{"$f":"Calculator_SM!R35","v":""},{"$f":"IF(OR(K26=\"\",Calculator_SM!I35>=0),\"\",Calculator_SM!I35)","v":""},{"$f":"IF(OR(K26=\"\",Calculator_SM!J35>=0),\"\",Calculator_SM!J35)","v":""},{"$f":"Incentives_SM!K34","v":0},{"$f":"Incentives_SM!L34","v":0}]
[21,{"$f":"Calculator_SM!B36","v":0},null,null,{"$f":"IF(K27=\"\", \"\",Calculator_SM!K36)","v":""},{"$f":"IF(K27=\"\", \"\", Calculator_SM!F36)","v":""},{"$f":"IF(OR(K27=\"\",Calculator_SM!I36<0),0,Calculator_SM!I36)","v":0},{"$f":"IF(OR(K27=\"\",Calculator_SM!J36<0),0,Calculator_SM!J36)","v":0},{"$f":"IF(K27=\"\",\"\",Calculator_SM!U36)","v":""},{"$f":"IF(K27=\"\",\"\",Calculator_SM!V36)","v":""},{"$f":"IF(OR(Incentives_SM!G35=\"No\",Incentives_SM!H35=\"No\"),\"\",Incentives_SM!I35)","v":""},{"$f":"Calculator_SM!R36","v":""},{"$f":"IF(OR(K27=\"\",Calculator_SM!I36>=0),\"\",Calculator_SM!I36)","v":""},{"$f":"IF(OR(K27=\"\",Calculator_SM!J36>=0),\"\",Calculator_SM!J36)","v":""},{"$f":"Incentives_SM!K35","v":0},{"$f":"Incentives_SM!L35","v":0}]
[22,{"$f":"Calculator_SM!B37","v":0},null,null,{"$f":"IF(K28=\"\", \"\",Calculator_SM!K37)","v":""},{"$f":"IF(K28=\"\", \"\", Calculator_SM!F37)","v":""},{"$f":"IF(OR(K28=\"\",Calculator_SM!I37<0),0,Calculator_SM!I37)","v":0},{"$f":"IF(OR(K28=\"\",Calculator_SM!J37<0),0,Calculator_SM!J37)","v":0},{"$f":"IF(K28=\"\",\"\",Calculator_SM!U37)","v":""},{"$f":"IF(K28=\"\",\"\",Calculator_SM!V37)","v":""},{"$f":"IF(OR(Incentives_SM!G36=\"No\",Incentives_SM!H36=\"No\"),\"\",Incentives_SM!I36)","v":""},{"$f":"Calculator_SM!R37","v":""},{"$f":"IF(OR(K28=\"\",Calculator_SM!I37>=0),\"\",Calculator_SM!I37)","v":""},{"$f":"IF(OR(K28=\"\",Calculator_SM!J37>=0),\"\",Calculator_SM!J37)","v":""},{"$f":"Incentives_SM!K36","v":0},{"$f":"Incentives_SM!L36","v":0}]
[23,{"$f":"Calculator_SM!B38","v":0},null,null,{"$f":"IF(K29=\"\", \"\",Calculator_SM!K38)","v":""},{"$f":"IF(K29=\"\", \"\", Calculator_SM!F38)","v":""},{"$f":"IF(OR(K29=\"\",Calculator_SM!I38<0),0,Calculator_SM!I38)","v":0},{"$f":"IF(OR(K29=\"\",Calculator_SM!J38<0),0,Calculator_SM!J38)","v":0},{"$f":"IF(K29=\"\",\"\",Calculator_SM!U38)","v":""},{"$f":"IF(K29=\"\",\"\",Calculator_SM!V38)","v":""},{"$f":"IF(OR(Incentives_SM!G37=\"No\",Incentives_SM!H37=\"No\"),\"\",Incentives_SM!I37)","v":""},{"$f":"Calculator_SM!R38","v":""},{"$f":"IF(OR(K29=\"\",Calculator_SM!I38>=0),\"\",Calculator_SM!I38)","v":""},{"$f":"IF(OR(K29=\"\",Calculator_SM!J38>=0),\"\",Calculator_SM!J38)","v":""},{"$f":"Incentives_SM!K37","v":0},{"$f":"Incentives_SM!L37","v":0}]
[24,{"$f":"Calculator_SM!B39","v":0},null,null,{"$f":"IF(K30=\"\", \"\",Calculator_SM!K39)","v":""},{"$f":"IF(K30=\"\", \"\", Calculator_SM!F39)","v":""},{"$f":"IF(OR(K30=\"\",Calculator_SM!I39<0),0,Calculator_SM!I39)","v":0},{"$f":"IF(OR(K30=\"\",Calculator_SM!J39<0),0,Calculator_SM!J39)","v":0},{"$f":"IF(K30=\"\",\"\",Calculator_SM!U39)","v":""},{"$f":"IF(K30=\"\",\"\",Calculator_SM!V39)","v":""},{"$f":"IF(OR(Incentives_SM!G38=\"No\",Incentives_SM!H38=\"No\"),\"\",Incentives_SM!I38)","v":""},{"$f":"Calculator_SM!R39","v":""},{"$f":"IF(OR(K30=\"\",Calculator_SM!I39>=0),\"\",Calculator_SM!I39)","v":""},{"$f":"IF(OR(K30=\"\",Calculator_SM!J39>=0),\"\",Calculator_SM!J39)","v":""},{"$f":"Incentives_SM!K38","v":0},{"$f":"Incentives_SM!L38","v":0}]
[25,{"$f":"Calculator_SM!B40","v":0},null,null,{"$f":"IF(K31=\"\", \"\",Calculator_SM!K40)","v":""},{"$f":"IF(K31=\"\", \"\", Calculator_SM!F40)","v":""},{"$f":"IF(OR(K31=\"\",Calculator_SM!I40<0),0,Calculator_SM!I40)","v":0},{"$f":"IF(OR(K31=\"\",Calculator_SM!J40<0),0,Calculator_SM!J40)","v":0},{"$f":"IF(K31=\"\",\"\",Calculator_SM!U40)","v":""},{"$f":"IF(K31=\"\",\"\",Calculator_SM!V40)","v":""},{"$f":"IF(OR(Incentives_SM!G39=\"No\",Incentives_SM!H39=\"No\"),\"\",Incentives_SM!I39)","v":""},{"$f":"Calculator_SM!R40","v":""},{"$f":"IF(OR(K31=\"\",Calculator_SM!I40>=0),\"\",Calculator_SM!I40)","v":""},{"$f":"IF(OR(K31=\"\",Calculator_SM!J40>=0),\"\",Calculator_SM!J40)","v":""},{"$f":"Incentives_SM!K39","v":0},{"$f":"Incentives_SM!L39","v":0}]
["Total",null,null,null,null,null,{"$f":"SUM(G7:G31)","v":0},{"$f":"SUM(H7:H31)","v":0},0,0,0,null,null,null,{"$f":"SUMPRODUCT(O7:O31,Incentives_SM!J15:J39)/SUM(Incentives_SM!J15:J39)","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(P7:P31,Incentives_SM!J15:J39)/SUM(Incentives_SM!J15:J39)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Modeled Savings/PTNZ/Data Center"]
["#","Measure Name",null,"Project Track Name","Incremental Cost","Measure Life","kWh savings","therm savings","kWh incentive","therm incentive","total incentive","Payback before incentive","negative kWh","negative therms","Elec Allocation of Utility Benefits","Gas Allocation of Utility Benefits"]
[1,{"$f":"Calculator_MS!B16","v":0},null,null,{"$f":"IF(K37=\"\", \"\",Calculator_MS!M16)","v":""},{"$f":"IF(K37=\"\", \"\", Calculator_MS!F16)","v":""},{"$f":"IF(OR(K37=\"\",Calculator_MS!I16<0),0,Calculator_MS!I16)","v":0},{"$f":"IF(OR(K37=\"\",Calculator_MS!J16<0),0,Calculator_MS!J16)","v":0},{"$f":"IF(K37=\"\",\"\",Calculator_MS!W16)","v":""},{"$f":"IF(K37=\"\",\"\",Calculator_MS!X16)","v":""},{"$f":"IF(OR(Incentives_MS!G15=\"No\",Incentives_MS!H15=\"No\"),\"\",Incentives_MS!I15)","v":""},{"$f":"Calculator_MS!T16","v":""},{"$f":"IF(OR(K37=\"\",Calculator_MS!I16>=0),\"\",Calculator_MS!I16)","v":""},{"$f":"IF(OR(K37=\"\",Calculator_MS!J16>=0),\"\",Calculator_MS!J16)","v":""},{"$f":"Incentives_MS!K15","v":0},{"$f":"Incentives_MS!L15","v":0}]
[2,{"$f":"Calculator_MS!B17","v":0},null,null,{"$f":"IF(K38=\"\", \"\",Calculator_MS!M17)","v":""},{"$f":"IF(K38=\"\", \"\", Calculator_MS!F17)","v":""},{"$f":"IF(OR(K38=\"\",Calculator_MS!I17<0),0,Calculator_MS!I17)","v":0},{"$f":"IF(OR(K38=\"\",Calculator_MS!J17<0),0,Calculator_MS!J17)","v":0},{"$f":"IF(K38=\"\",\"\",Calculator_MS!W17)","v":""},{"$f":"IF(K38=\"\",\"\",Calculator_MS!X17)","v":""},{"$f":"IF(OR(Incentives_MS!G16=\"No\",Incentives_MS!H16=\"No\"),\"\",Incentives_MS!I16)","v":""},{"$f":"Calculator_MS!T17","v":""},{"$f":"IF(OR(K38=\"\",Calculator_MS!I17>=0),\"\",Calculator_MS!I17)","v":""},{"$f":"IF(OR(K38=\"\",Calculator_MS!J17>=0),\"\",Calculator_MS!J17)","v":""},{"$f":"Incentives_MS!K16","v":0},{"$f":"Incentives_MS!L16","v":0}]
[3,{"$f":"Calculator_MS!B18","v":0},null,null,{"$f":"IF(K39=\"\", \"\",Calculator_MS!M18)","v":""},{"$f":"IF(K39=\"\", \"\", Calculator_MS!F18)","v":""},{"$f":"IF(OR(K39=\"\",Calculator_MS!I18<0),0,Calculator_MS!I18)","v":0},{"$f":"IF(OR(K39=\"\",Calculator_MS!J18<0),0,Calculator_MS!J18)","v":0},{"$f":"IF(K39=\"\",\"\",Calculator_MS!W18)","v":""},{"$f":"IF(K39=\"\",\"\",Calculator_MS!X18)","v":""},{"$f":"IF(OR(Incentives_MS!G17=\"No\",Incentives_MS!H17=\"No\"),\"\",Incentives_MS!I17)","v":""},{"$f":"Calculator_MS!T18","v":""},{"$f":"IF(OR(K39=\"\",Calculator_MS!I18>=0),\"\",Calculator_MS!I18)","v":""},{"$f":"IF(OR(K39=\"\",Calculator_MS!J18>=0),\"\",Calculator_MS!J18)","v":""},{"$f":"Incentives_MS!K17","v":0},{"$f":"Incentives_MS!L17","v":0}]
[4,{"$f":"Calculator_MS!B19","v":0},null,null,{"$f":"IF(K40=\"\", \"\",Calculator_MS!M19)","v":""},{"$f":"IF(K40=\"\", \"\", Calculator_MS!F19)","v":""},{"$f":"IF(OR(K40=\"\",Calculator_MS!I19<0),0,Calculator_MS!I19)","v":0},{"$f":"IF(OR(K40=\"\",Calculator_MS!J19<0),0,Calculator_MS!J19)","v":0},{"$f":"IF(K40=\"\",\"\",Calculator_MS!W19)","v":""},{"$f":"IF(K40=\"\",\"\",Calculator_MS!X19)","v":""},{"$f":"IF(OR(Incentives_MS!G18=\"No\",Incentives_MS!H18=\"No\"),\"\",Incentives_MS!I18)","v":""},{"$f":"Calculator_MS!T19","v":""},{"$f":"IF(OR(K40=\"\",Calculator_MS!I19>=0),\"\",Calculator_MS!I19)","v":""},{"$f":"IF(OR(K40=\"\",Calculator_MS!J19>=0),\"\",Calculator_MS!J19)","v":""},{"$f":"Incentives_MS!K18","v":0},{"$f":"Incentives_MS!L18","v":0}]
[5,{"$f":"Calculator_MS!B20","v":0},null,null,{"$f":"IF(K41=\"\", \"\",Calculator_MS!M20)","v":""},{"$f":"IF(K41=\"\", \"\", Calculator_MS!F20)","v":""},{"$f":"IF(OR(K41=\"\",Calculator_MS!I20<0),0,Calculator_MS!I20)","v":0},{"$f":"IF(OR(K41=\"\",Calculator_MS!J20<0),0,Calculator_MS!J20)","v":0},{"$f":"IF(K41=\"\",\"\",Calculator_MS!W20)","v":""},{"$f":"IF(K41=\"\",\"\",Calculator_MS!X20)","v":""},{"$f":"IF(OR(Incentives_MS!G19=\"No\",Incentives_MS!H19=\"No\"),\"\",Incentives_MS!I19)","v":""},{"$f":"Calculator_MS!T20","v":""},{"$f":"IF(OR(K41=\"\",Calculator_MS!I20>=0),\"\",Calculator_MS!I20)","v":""},{"$f":"IF(OR(K41=\"\",Calculator_MS!J20>=0),\"\",Calculator_MS!J20)","v":""},{"$f":"Incentives_MS!K19","v":0},{"$f":"Incentives_MS!L19","v":0}]
[6,{"$f":"Calculator_MS!B21","v":0},null,null,{"$f":"IF(K42=\"\", \"\",Calculator_MS!M21)","v":""},{"$f":"IF(K42=\"\", \"\", Calculator_MS!F21)","v":""},{"$f":"IF(OR(K42=\"\",Calculator_MS!I21<0),0,Calculator_MS!I21)","v":0},{"$f":"IF(OR(K42=\"\",Calculator_MS!J21<0),0,Calculator_MS!J21)","v":0},{"$f":"IF(K42=\"\",\"\",Calculator_MS!W21)","v":""},{"$f":"IF(K42=\"\",\"\",Calculator_MS!X21)","v":""},{"$f":"IF(OR(Incentives_MS!G20=\"No\",Incentives_MS!H20=\"No\"),\"\",Incentives_MS!I20)","v":""},{"$f":"Calculator_MS!T21","v":""},{"$f":"IF(OR(K42=\"\",Calculator_MS!I21>=0),\"\",Calculator_MS!I21)","v":""},{"$f":"IF(OR(K42=\"\",Calculator_MS!J21>=0),\"\",Calculator_MS!J21)","v":""},{"$f":"Incentives_MS!K20","v":0},{"$f":"Incentives_MS!L20","v":0}]
[7,{"$f":"Calculator_MS!B22","v":0},null,null,{"$f":"IF(K43=\"\", \"\",Calculator_MS!M22)","v":""},{"$f":"IF(K43=\"\", \"\", Calculator_MS!F22)","v":""},{"$f":"IF(OR(K43=\"\",Calculator_MS!I22<0),0,Calculator_MS!I22)","v":0},{"$f":"IF(OR(K43=\"\",Calculator_MS!J22<0),0,Calculator_MS!J22)","v":0},{"$f":"IF(K43=\"\",\"\",Calculator_MS!W22)","v":""},{"$f":"IF(K43=\"\",\"\",Calculator_MS!X22)","v":""},{"$f":"IF(OR(Incentives_MS!G21=\"No\",Incentives_MS!H21=\"No\"),\"\",Incentives_MS!I21)","v":""},{"$f":"Calculator_MS!T22","v":""},{"$f":"IF(OR(K43=\"\",Calculator_MS!I22>=0),\"\",Calculator_MS!I22)","v":""},{"$f":"IF(OR(K43=\"\",Calculator_MS!J22>=0),\"\",Calculator_MS!J22)","v":""},{"$f":"Incentives_MS!K21","v":0},{"$f":"Incentives_MS!L21","v":0}]
[8,{"$f":"Calculator_MS!B23","v":0},null,null,{"$f":"IF(K44=\"\", \"\",Calculator_MS!M23)","v":""},{"$f":"IF(K44=\"\", \"\", Calculator_MS!F23)","v":""},{"$f":"IF(OR(K44=\"\",Calculator_MS!I23<0),0,Calculator_MS!I23)","v":0},{"$f":"IF(OR(K44=\"\",Calculator_MS!J23<0),0,Calculator_MS!J23)","v":0},{"$f":"IF(K44=\"\",\"\",Calculator_MS!W23)","v":""},{"$f":"IF(K44=\"\",\"\",Calculator_MS!X23)","v":""},{"$f":"IF(OR(Incentives_MS!G22=\"No\",Incentives_MS!H22=\"No\"),\"\",Incentives_MS!I22)","v":""},{"$f":"Calculator_MS!T23","v":""},{"$f":"IF(OR(K44=\"\",Calculator_MS!I23>=0),\"\",Calculator_MS!I23)","v":""},{"$f":"IF(OR(K44=\"\",Calculator_MS!J23>=0),\"\",Calculator_MS!J23)","v":""},{"$f":"Incentives_MS!K22","v":0},{"$f":"Incentives_MS!L22","v":0}]
[9,{"$f":"Calculator_MS!B24","v":0},null,null,{"$f":"IF(K45=\"\", \"\",Calculator_MS!M24)","v":""},{"$f":"IF(K45=\"\", \"\", Calculator_MS!F24)","v":""},{"$f":"IF(OR(K45=\"\",Calculator_MS!I24<0),0,Calculator_MS!I24)","v":0},{"$f":"IF(OR(K45=\"\",Calculator_MS!J24<0),0,Calculator_MS!J24)","v":0},{"$f":"IF(K45=\"\",\"\",Calculator_MS!W24)","v":""},{"$f":"IF(K45=\"\",\"\",Calculator_MS!X24)","v":""},{"$f":"IF(OR(Incentives_MS!G23=\"No\",Incentives_MS!H23=\"No\"),\"\",Incentives_MS!I23)","v":""},{"$f":"Calculator_MS!T24","v":""},{"$f":"IF(OR(K45=\"\",Calculator_MS!I24>=0),\"\",Calculator_MS!I24)","v":""},{"$f":"IF(OR(K45=\"\",Calculator_MS!J24>=0),\"\",Calculator_MS!J24)","v":""},{"$f":"Incentives_MS!K23","v":0},{"$f":"Incentives_MS!L23","v":0}]
[10,{"$f":"Calculator_MS!B25","v":0},null,null,{"$f":"IF(K46=\"\", \"\",Calculator_MS!M25)","v":""},{"$f":"IF(K46=\"\", \"\", Calculator_MS!F25)","v":""},{"$f":"IF(OR(K46=\"\",Calculator_MS!I25<0),0,Calculator_MS!I25)","v":0},{"$f":"IF(OR(K46=\"\",Calculator_MS!J25<0),0,Calculator_MS!J25)","v":0},{"$f":"IF(K46=\"\",\"\",Calculator_MS!W25)","v":""},{"$f":"IF(K46=\"\",\"\",Calculator_MS!X25)","v":""},{"$f":"IF(OR(Incentives_MS!G24=\"No\",Incentives_MS!H24=\"No\"),\"\",Incentives_MS!I24)","v":""},{"$f":"Calculator_MS!T25","v":""},{"$f":"IF(OR(K46=\"\",Calculator_MS!I25>=0),\"\",Calculator_MS!I25)","v":""},{"$f":"IF(OR(K46=\"\",Calculator_MS!J25>=0),\"\",Calculator_MS!J25)","v":""},{"$f":"Incentives_MS!K24","v":0},{"$f":"Incentives_MS!L24","v":0}]
[11,{"$f":"Calculator_MS!B26","v":0},null,null,{"$f":"IF(K47=\"\", \"\",Calculator_MS!M26)","v":""},{"$f":"IF(K47=\"\", \"\", Calculator_MS!F26)","v":""},{"$f":"IF(OR(K47=\"\",Calculator_MS!I26<0),0,Calculator_MS!I26)","v":0},{"$f":"IF(OR(K47=\"\",Calculator_MS!J26<0),0,Calculator_MS!J26)","v":0},{"$f":"IF(K47=\"\",\"\",Calculator_MS!W26)","v":""},{"$f":"IF(K47=\"\",\"\",Calculator_MS!X26)","v":""},{"$f":"IF(OR(Incentives_MS!G25=\"No\",Incentives_MS!H25=\"No\"),\"\",Incentives_MS!I25)","v":""},{"$f":"Calculator_MS!T26","v":""},{"$f":"IF(OR(K47=\"\",Calculator_MS!I26>=0),\"\",Calculator_MS!I26)","v":""},{"$f":"IF(OR(K47=\"\",Calculator_MS!J26>=0),\"\",Calculator_MS!J26)","v":""},{"$f":"Incentives_MS!K25","v":0},{"$f":"Incentives_MS!L25","v":0}]
[12,{"$f":"Calculator_MS!B27","v":0},null,null,{"$f":"IF(K48=\"\", \"\",Calculator_MS!M27)","v":""},{"$f":"IF(K48=\"\", \"\", Calculator_MS!F27)","v":""},{"$f":"IF(OR(K48=\"\",Calculator_MS!I27<0),0,Calculator_MS!I27)","v":0},{"$f":"IF(OR(K48=\"\",Calculator_MS!J27<0),0,Calculator_MS!J27)","v":0},{"$f":"IF(K48=\"\",\"\",Calculator_MS!W27)","v":""},{"$f":"IF(K48=\"\",\"\",Calculator_MS!X27)","v":""},{"$f":"IF(OR(Incentives_MS!G26=\"No\",Incentives_MS!H26=\"No\"),\"\",Incentives_MS!I26)","v":""},{"$f":"Calculator_MS!T27","v":""},{"$f":"IF(OR(K48=\"\",Calculator_MS!I27>=0),\"\",Calculator_MS!I27)","v":""},{"$f":"IF(OR(K48=\"\",Calculator_MS!J27>=0),\"\",Calculator_MS!J27)","v":""},{"$f":"Incentives_MS!K26","v":0},{"$f":"Incentives_MS!L26","v":0}]
[13,{"$f":"Calculator_MS!B28","v":0},null,null,{"$f":"IF(K49=\"\", \"\",Calculator_MS!M28)","v":""},{"$f":"IF(K49=\"\", \"\", Calculator_MS!F28)","v":""},{"$f":"IF(OR(K49=\"\",Calculator_MS!I28<0),0,Calculator_MS!I28)","v":0},{"$f":"IF(OR(K49=\"\",Calculator_MS!J28<0),0,Calculator_MS!J28)","v":0},{"$f":"IF(K49=\"\",\"\",Calculator_MS!W28)","v":""},{"$f":"IF(K49=\"\",\"\",Calculator_MS!X28)","v":""},{"$f":"IF(OR(Incentives_MS!G27=\"No\",Incentives_MS!H27=\"No\"),\"\",Incentives_MS!I27)","v":""},{"$f":"Calculator_MS!T28","v":""},{"$f":"IF(OR(K49=\"\",Calculator_MS!I28>=0),\"\",Calculator_MS!I28)","v":""},{"$f":"IF(OR(K49=\"\",Calculator_MS!J28>=0),\"\",Calculator_MS!J28)","v":""},{"$f":"Incentives_MS!K27","v":0},{"$f":"Incentives_MS!L27","v":0}]
[14,{"$f":"Calculator_MS!B29","v":0},null,null,{"$f":"IF(K50=\"\", \"\",Calculator_MS!M29)","v":""},{"$f":"IF(K50=\"\", \"\", Calculator_MS!F29)","v":""},{"$f":"IF(OR(K50=\"\",Calculator_MS!I29<0),0,Calculator_MS!I29)","v":0},{"$f":"IF(OR(K50=\"\",Calculator_MS!J29<0),0,Calculator_MS!J29)","v":0},{"$f":"IF(K50=\"\",\"\",Calculator_MS!W29)","v":""},{"$f":"IF(K50=\"\",\"\",Calculator_MS!X29)","v":""},{"$f":"IF(OR(Incentives_MS!G28=\"No\",Incentives_MS!H28=\"No\"),\"\",Incentives_MS!I28)","v":""},{"$f":"Calculator_MS!T29","v":""},{"$f":"IF(OR(K50=\"\",Calculator_MS!I29>=0),\"\",Calculator_MS!I29)","v":""},{"$f":"IF(OR(K50=\"\",Calculator_MS!J29>=0),\"\",Calculator_MS!J29)","v":""},{"$f":"Incentives_MS!K28","v":0},{"$f":"Incentives_MS!L28","v":0}]
[15,{"$f":"Calculator_MS!B30","v":0},null,null,{"$f":"IF(K51=\"\", \"\",Calculator_MS!M30)","v":""},{"$f":"IF(K51=\"\", \"\", Calculator_MS!F30)","v":""},{"$f":"IF(OR(K51=\"\",Calculator_MS!I30<0),0,Calculator_MS!I30)","v":0},{"$f":"IF(OR(K51=\"\",Calculator_MS!J30<0),0,Calculator_MS!J30)","v":0},{"$f":"IF(K51=\"\",\"\",Calculator_MS!W30)","v":""},{"$f":"IF(K51=\"\",\"\",Calculator_MS!X30)","v":""},{"$f":"IF(OR(Incentives_MS!G29=\"No\",Incentives_MS!H29=\"No\"),\"\",Incentives_MS!I29)","v":""},{"$f":"Calculator_MS!T30","v":""},{"$f":"IF(OR(K51=\"\",Calculator_MS!I30>=0),\"\",Calculator_MS!I30)","v":""},{"$f":"IF(OR(K51=\"\",Calculator_MS!J30>=0),\"\",Calculator_MS!J30)","v":""},{"$f":"Incentives_MS!K29","v":0},{"$f":"Incentives_MS!L29","v":0}]
["Total",null,null,null,null,null,{"$f":"SUM(G37:G51)","v":0},{"$f":"SUM(H37:H51)","v":0},0,0,0,null,null,null,{"$f":"SUMPRODUCT(O37:O51,Incentives_MS!J15:J29)/SUM(Incentives_MS!J15:J29)","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(P37:P51,Incentives_MS!J15:J29)/SUM(Incentives_MS!J15:J29)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Lists","index":6,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["LOOKUPS"]
["Sector","Commercial","Industrial","Residential","Com End Use","Ind End Use","Res End Use","Gas Load Profiles",null,"Electric Utility","Gas Utility",null,"Code Year",null,null,"Program Offering","Project Type",null,"Y/N",null,"Fast Track Name"]
["Commercial","College","Not applicable","Not applicable","Compressed Air","Ag-Irrigation","Res Refrigerator","DHW",null,"PGE","NWN",null,2010,null,null,"Modeled Savings - Major Renovation","New Construction",null,"Yes",null,"Controls - Custom"]
["Industrial","Grocery",null,null,"Cooking","Flat","Res Freezer","Flat",null,"PAC","NWN-Firm",null,2014,null,null,"Modeled Savings - New Construction","Major Renovation",null,"No",null,"Custom"]
["Residential","Healthcare",null,null,"Cooling","1-Shift Industrial","Res Dryer","Res Heating",null,"Other","CNG",null,null,null,null,"Data Center",null,null,null,null,"Custom Gas"]
[null,"Lodging",null,null,"Exterior Lighting","2-Shift Industrial","Res Clotheswasher","Com Heating",null,null,"Other",null,null,null,null,"Path to Net Zero",null,null,null,null,"Envelope - Shell - Custom"]
[null,"Large Office",null,null,"Heating","3-Shift Industrial","Res Central AC","Solar DHW",null,null,null,null,null,null,null,null,null,null,null,null,"HVAC - Custom"]
[null,"Other",null,null,"Hot Water","None","Res Window AC","Solar Pool",null,null,null,null,null,null,null,null,null,null,null,null,"Lighting - Custom"]
[null,"Restaurant",null,null,"Indoor Lighting",null,"Res Water Heat","Clotheswasher",null,null,null,null,null,null,null,null,null,null,null,null,"Lighting Controls - Custom"]
[null,"Retail",null,null,"Misc",null,"Res HP Water Heat","None",null,null,null,null,null,null,null,null,null,null,null,null,"Motors - Custom"]
[null,"School",null,null,"Motors",null,"Res Solar Water Heat",null,null,null,null,null,null,null,null,null,null,null,null,null,"VSD - Custom"]
[null,"Small Office",null,null,"Office Equipment",null,"Res Air Source HP",null,null,null,null,null,null,null,null,null,null,null,null,null,"Windows - Custom"]
[null,"Warehouse",null,null,"Process",null,"Res Ductless HP",null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom LED"]
[null,null,null,null,"Refrigeration",null,"Res Zonal Ele Heat",null,null,null,null,null,null,null,null,null,null,null,null,null,"Grocer Refrigeration Case - Custom"]
[null,null,null,null,"Ventilation",null,"Res Ele Resistance Heat",null,null,null,null,null,null,null,null,null,null,null,null,null,"Grocer Refrigeration VFD - Custom"]
[null,null,null,null,"None",null,"Res Lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,"VRF Pilot - Custom"]
[null,null,null,null,null,null,"Res Other"]
[null,null,null,null,null,null,"Res Whole Home"]
[null,null,null,null,null,null,"Res Spa Cover"]
[null,null,null,null,null,null,"Res Power Strip"]
[null,null,null,null,null,null,"None"]

{"sheet":"Avoided Costs","index":7,"n_rows":171,"n_cols":21,"rows_kept":171,"cut":false,"hidden":true,"merged":[[1,5,1,6],[1,10,1,17],[1,19,1,20]]}
["Gas Avoided Costs",null,null,null,null,null,null,null,"Electric Avoided Costs"]
["Load Profile Name","Lifetime","Concatenation","PV Avoided Cost",null,"Gas Avoided Cost Info",null,null,null,null,"Lifetime (yrs)",null,null,null,null,null,null,null,null,"Electric Avoided Cost Info"]
["Res Heating",0,{"$f":"A3&B3","v":"Res Heating0"},0,null,"Updated on","2015-07-13",null,"Load Profile Name","Friendly Name",0,10,20,30,40,50,60,70,null,"Updated on","2015-07-22"]
["Res Heating",10,{"$f":"A4&B4","v":"Res Heating10"},3.931562312890617,null,"Base Year","2016$",null,"R-All-Ref-Refrig-All-All-C","Res Refrigerator",0,0.55127783907000272,0.98764535510293783,1.2728336939643505,1.4563802009827103,1.5745102773145194,1.6505385012281635,1.6994700774274989,null,"Base Year","2016$"]
["Res Heating",20,"Res Heating20",6.7022996923005653,null,"Discount Rate",4.4999999999999998E-2,null,"R-All-Ref-Freezer-All-All-R","Res Freezer",0,0.55007635338632677,0.98599314877457267,1.2707944343941067,1.4540918349067069,1.572061586909723,1.6479866264833007,1.6968517934974854,null,"Discount Rate",4.4999999999999998E-2]
["Res Heating",30,"Res Heating30",8.4924997701368934,null,"Source","Link",null,"R-All-Plug-Dryer-All-All-R","Res Dryer",0,0.73628348028433765,1.2914478012327126,1.6539230546331216,1.8872112280130664,2.0373549173502039,2.1339870231323173,2.1961792065608075,null,"Source","Link"]
["Res Heating",40,"Res Heating40",9.6452591566280432,null,"Inputs","NWN 2014; CNG 2015",null,"R-All-WH-Cwash-All-All-R","Res Clotheswasher",0,0.62634981297556314,1.115978997691911,1.435444401098096,1.6410515417775426,1.7733797871763979,1.8585459174599752,1.9133586275175816,null,"Inputs","PGE 2015; PAC 2014"]
["Res Heating",50,"Res Heating50",10.387552836309663,null,null,null,null,"R-All-HVAC-CAC-All-All-E","Res Central AC",0,1.0324786485419224,1.7847150295130538,2.2733418540611168,2.5878208655078381,2.7902187766990165,2.9204815699649282,3.0043183803824522]
["Res Heating",60,"Res Heating60",10.865536284852597,null,null,null,null,"R-All-HVAC-RAC-All-All-E","Res Window AC",0,1.1188938363606715,1.9277518131654232,2.4528542844574388,2.7908089316114855,3.0083157036744592,3.1483025222953902,3.238397691295166]
["Res Heating",70,"Res Heating70",11.17332305892158,null,null,null,null,"Residential-res-Water Heating","Res Water Heat",0,0.61561482851666982,1.0980413772535176,1.4130584023027029,1.6158025777130121,1.7462882257708847,1.8302684649793615,1.8843179384845623]
["DHW",0,"DHW0",0,null,null,null,null,"R-All-WH-HPWH-All-All-R","Res HP Water Heat",0,0.63485342541950029,1.1285806069677697,1.4510351582907723,1.658566107150047,1.7921325107183081,1.878095516526453,1.9334210936937277]
["DHW",10,"DHW10",3.7288146774267581,null,null,null,null,"R-All-WH-SWH-All-All-C","Res Solar Water Heat",0,0.59612727431798385,1.0641845747576695,1.3700242466100232,1.5668619002821806,1.6935461256100992,1.7750797785851804,1.8275546352632976]
["DHW",20,"DHW20",6.3562356491869751,null,null,null,null,"R-All-HVAC-ASHP-All-All-E","Res Air Source HP",0,0.68110545674346012,1.1985711926808134,1.5367377920026764,1.7543809759547653,1.8944555889289394,1.9846072621565467,2.042628655278194]
["DHW",30,"DHW30",8.0538276454123761,null,null,null,null,"R-All-HVAC-DHP-HZ1-All-N","Res Ductless HP",0,0.63087470504294196,1.1168116845243941,1.4346556667869128,1.6392192648428647,1.7708758887994407,1.8556097651898156,1.9101442777146644]
["DHW",40,"DHW40",9.1469541245745489,null,null,null,null,"R-All-HVAC-Zonal-All-All-E","Res Zonal Ele Heat",0,0.65223553423369729,1.1514965011387288,1.4780150601663311,1.6881615942969148,1.8234113820535838,1.9104578097470197,1.9664806745504797]
["DHW",50,"DHW50",9.8508485244671125,null,null,null,null,"R-All-HVAC-ER-All-All-E","Res Ele Resistance Heat",0,0.70371901740730869,1.2384544155940025,1.5877742214181261,1.8125955813914267,1.9572900506357296,2.050415051891735,2.1103500715522907]
["DHW",60,"DHW60",10.304105613783856,null,null,null,null,"R-All-Lgt-Lighting-All-All-R","Res Lighting",0,0.61420739523925805,1.094002996567863,1.4073538056396864,1.6090256085827197,1.738821080382416,1.8223571238642335,1.8761207141023051]
["DHW",70,"DHW70",10.59597040067127,null,null,null,null,"Residential-res-Other","Res Other",0,0.57060323772503063,1.02117722486889,1.3156399696744512,1.5051554613382379,1.6271271613720835,1.7056278447649718,1.7561506897481975]
["Flat",0,"Flat0",0,null,null,null,null,"R-All-Bld-Bldg-All-All-R","Res Whole Home",0,0.59573904664669908,1.0622055857976376,1.3671451139874458,1.5634034374326573,1.6897148072644828,1.771008491367752,1.8233289046756043]
["Flat",10,"Flat10",3.6942136805232249,null,null,null,null,"Residential-Spa Heater","Res Spa Cover",0,0.68983609497605447,1.2230255824718044,1.5704022949413161,1.7939730848545874,1.9378626903123253,2.0304696832330693,2.0900713140148115]
["Flat",20,"Flat20",6.2971762137622322,null,null,null,null,"Residential-Res-TV","Res Power Strip",0,0.59402538161873963,1.0594022546804345,1.3634670419225154,1.5591623842649851,1.6851114208564753,1.7661719081856209,1.8183422366284698]
["Flat",30,"Flat30",7.9789636757560487,null,null,null,null,"A-Irr-Irr-Irrigation-All-All-E","Ag-Irrigation",0,0.56782847431728567,1.0193191377939916,1.3133870674978934,1.5026484571422325,1.6244566177470745,1.7028520475693809,1.7533071516158323]
["Flat",40,"Flat40",9.0619131778249145,null,null,null,null,"DSI-0","Flat",0,0.52494080667824372,0.94231394743870656,1.2152305096352987,1.3908789316522518,1.5039258200811829,1.5766825168776382,1.6235085463446868]
["Flat",50,"Flat50",9.7592543404477095,null,null,null,null,"IndShift1","1-Shift Industrial",0,0.57886624444868673,1.0384096385492578,1.3384907553485945,1.5316222172820784,1.6559211468062147,1.7359196293225814,1.7874064541039536]
["Flat",60,"Flat60",10.208291618879544,null,null,null,null,"IndShift2","2-Shift Industrial",0,0.57360658925277352,1.0289599364761508,1.32634139605816,1.5177353653074566,1.6409160488527219,1.7201948310327131,1.7712184584639799]
["Flat",70,"Flat70",10.497439152725233,null,null,null,null,"IndShift3","3-Shift Industrial",0,0.54629395764055555,0.98093984914252819,1.2649851679229593,1.4477960300543165,1.565452647162813,1.6411761538955181,1.6899116148735467]
["Clotheswasher",0,"Clotheswasher0",0,null,null,null,null,"S-All-Lgt-Streetlight-All-All-U","Street Lighting",0,0.54539247803976609,0.96592078352808186,1.2411163438082757,1.4182315233350784,1.5322224132566751,1.6055866670706804,1.6528037187261926]
["Clotheswasher",10,"Clotheswasher10",3.6662849266811546,null,null,null,null,"Commercial-college-AirComp","College Compressed Air",0,0.6040693812196839,1.0821320522690656,1.3942708010482574,1.595162524995438,1.7244559398896557,1.807668860793274,1.8612244901420476]
["Clotheswasher",20,"Clotheswasher20",6.2495054359916375,null,null,null,null,"Commercial-college-Cook","College Cooking",0,0.59400968083931283,1.0642497452448445,1.3713478695837575,1.5689954601526299,1.6962009588569098,1.7780701020831522,1.830760879454189]
["Clotheswasher",30,"Clotheswasher30",7.9185360127612165,null,null,null,null,"Commercial-college-Cool","College Cooling",0,0.67129501402158409,1.1929349180911901,1.5328424086511063,1.7516060258828978,1.8924017469348344,1.9830175235314096,2.0413376124293636]
["Clotheswasher",40,"Clotheswasher40",8.9932710032977123,null,null,null,null,"Commercial-college-ExtLight","College Exterior Lights",0,0.54359604066274025,0.96387192797691812,1.2388385961363164,1.4158064612623145,1.5297025400012054,1.6030057735733549,1.6501835527526683]
["Clotheswasher",50,"Clotheswasher50",9.6853226145504614,null,null,null,null,"Commercial-college-Heat","College Heating",0,0.63098663671127941,1.1220532912010726,1.4427879975734306,1.649212058491339,1.7820660717279708,1.8675705848869202,1.9226010773232081]
["Clotheswasher",60,"Clotheswasher60",10.130953804429597,null,null,null,null,"Commercial-college-HotWater","College Hot Water",0,0.61255305002065774,1.0958871519367661,1.4114811271068044,1.6145966261828326,1.745321257230291,1.8294553052976794,1.8836037698027031]
["Clotheswasher",70,"Clotheswasher70",10.417908063568763,null,null,null,null,"C-Unv-Lgt-LPD Int-All-All-C","College Interior Lights",0,0.60228047230905146,1.0784741746169371,1.3894224786657816,1.5895480353393419,1.7183483468779799,1.8012439076858906,1.854595284864794]
["Com Heating",0,"Com Heating0",0,null,null,null,null,"Commercial-college-Misc","College Other",0,0.59010546449854251,1.0567968822625566,1.3616221028297144,1.557806858172714,1.6840708797565613,1.7653340906449562,1.8176348914673526]
["Com Heating",10,"Com Heating10",3.9495916066441854,null,null,null,null,"Commercial-college-Motors","College Motors",0,0.60557031321601662,1.0847146338001603,1.3975511201423019,1.5988919062531248,1.7284743364412356,1.8118732668706314,1.8655486114884965]
["Com Heating",20,"Com Heating20",6.7330733695203664,null,null,null,null,"Commercial-college-OffEquip","College Office Eqpmt",0,0.59751694038529712,1.0695509797200622,1.377803667009591,1.5761943314277107,1.7038780706169654,1.7860550082322844,1.8389438813081473]
["Com Heating",30,"Com Heating30",8.53150860286663,null,null,null,null,"Commercial-college-Process","College Process",0,0.62226351910121303,1.1123469567769695,1.4322662344330732,1.6381654874531957,1.7706817356294502,1.8559688640339156,1.9108594481817938]
["Com Heating",40,"Com Heating40",9.6895708339564504,null,null,null,null,"Commercial-college-Refrig","College Refrigeration",0,0.54307132290781901,0.97439405145103664,1.2564068167240265,1.4379095324630442,1.5547242298004127,1.6299058790581689,1.6782926019102782]
["Com Heating",50,"Com Heating50",10.43527916206866,null,null,null,null,"Commercial-college-Vent","College Ventilation",0,0.58419905865959343,1.0474509725580474,1.3500358333669829,1.5447786987304413,1.6701147235024056,1.7507806779460753,1.8026970860031122]
["Com Heating",60,"Com Heating60",10.915461397260454,null,null,null,null,"Commercial-Grocery-AirComp","Grocery Compressed Air",0,0.57676108825523253,1.0349829804795874,1.3343295889065721,1.5269883230747519,1.6509830061825068,1.7307856764604681,1.782146476971233]
["Com Heating",70,"Com Heating70",11.224664030919508,null,null,null,null,"Commercial-Grocery-Cook","Grocery Cooking",0,0.57867377036138579,1.0373428461641341,1.336970082054824,1.5298094273620919,1.6539203513506655,1.7337978339709963,1.7852067835196175]
["Solar DHW",0,"Solar DHW0",0,null,null,null,null,"Commercial-Grocery-Cool","Grocery Cooling",0,0.64994981096074489,1.1564671541952445,1.4865622445799038,1.6990106254144948,1.8357418759963939,1.9237417694869734,1.980378282510854]
["Solar DHW",10,"Solar DHW10",3.7426022192470412,null,null,null,null,"Commercial-Grocery-ExtLight","Grocery Exterior Lights",0,0.54710351067516771,0.97114291493022487,1.2485136516928521,1.4270287694046913,1.5419206560673566,1.6158647891475286,1.6634550496594136]
["Solar DHW",20,"Solar DHW20",6.3797692033811284,null,null,null,null,"Commercial-Grocery-Heat","Grocery Heating",0,0.76007845690251907,1.3201574424322517,1.6860812983133422,1.9215889836899942,2.0731611454391081,2.1707126125199236,2.2334964945982909]
["Solar DHW",30,"Solar DHW30",8.0836588700833545,null,null,null,null,"Commercial-Grocery-HotWater","Grocery Hot Water",0,0.58045806069064809,1.0409017573549764,1.3417359892534977,1.535352154195492,1.6599630373728123,1.7401622924860607,1.7917783340124445]
["Solar DHW",40,"Solar DHW40",9.1808405935978588,null,null,null,null,"C-Gro-Lgt-LPD Int-All-All-C","Grocery Interior Lights",0,0.56049021634969753,1.005847059538181,1.2969054552685439,1.4842299163175499,1.6047914744861327,1.6823845940746849,1.7323233332461256]
["Solar DHW",50,"Solar DHW50",9.8873462775862873,null,null,null,null,"Commercial-Grocery-Misc","Grocery Other",0,0.56543360530172848,1.0145210844821662,1.3079798341028517,1.4968491569576932,1.6184049843499728,1.6966380131429963,1.7469885962901002]
["Solar DHW",60,"Solar DHW60",10.342284845018005,null,null,null,null,"Commercial-Grocery-Motors","Grocery Motors",0,0.57057006054057025,1.0237486958477746,1.3198464945915047,1.51041430291149,1.6330632713332847,1.7119998429795926,1.7628032245607903]
["Solar DHW",70,"Solar DHW70",10.635232382210379,null,null,null,null,"Commercial-Grocery-OffEquip","Grocery Office Eqpmt",0,0.5795675659279631,1.039629962998557,1.3401615567194956,1.5335829444815832,1.6580684695493766,1.7381870444944874,1.7897511604649154]
["Solar Pool",0,"Solar Pool0",0,null,null,null,null,"Commercial-Grocery-Process","Grocery Process",0,0.57950880957556217,1.0403096325696304,1.3413217741626733,1.535052441342468,1.6597370178758275,1.7399837018501068,1.7916302684737258]
["Solar Pool",10,"Solar Pool10",3.6227752788131058,null,null,null,null,"Commercial-Grocery-Refrig","Grocery Refrigeration",0,0.54712677518887465,0.98104629065623516,1.2646818109681561,1.4472289278223507,1.5647157991251144,1.6403300578785791,1.6889952071283358]
["Solar Pool",20,"Solar Pool20",6.1752400832973056,null,null,null,null,"Commercial-Grocery-Vent","Grocery Ventilation",0,0.55167019328674349,0.99010749784393726,1.2766872426532467,1.4611292550860298,1.5798356764798067,1.6562348346447733,1.705405143207555]
["Solar Pool",30,"Solar Pool30",7.8243969633334629,null,null,null,null,"Commercial-Healthcare-AirComp","Healthcare Compressed Air",0,0.56795263461021772,1.0181618297239547,1.3123401298363941,1.5016725536017146,1.6235264315905045,1.7019512850076444,1.7524253260066971]
["Solar Pool",40,"Solar Pool40",8.8863347303990423,null,null,null,null,"Commercial-Healthcare-Cook","Healthcare Cooking",0,0.59256829045039872,1.0620595834563491,1.3686575598384754,1.5659832564237888,1.6929815849592311,1.7747173939790317,1.8273223577857542]
["Solar Pool",50,"Solar Pool50",9.570145855205741,null,null,null,null,"Commercial-Healthcare-Cool","Healthcare Cooling",0,0.62866099114322105,1.1199199959264166,1.4402157787436316,1.6463573495509125,1.7790295528535196,1.864417053590206,1.9193722371219641]
["Solar Pool",60,"Solar Pool60",10.010470767748878,null,null,null,null,"Commercial-Healthcare-ExtLight","Healthcare Exterior Lights",0,0.54255483946419514,0.96300095195072144,1.2380565973462776,1.4150817280006143,1.5290146626914036,1.6023416166627138,1.6495346622320501]
["Solar Pool",70,"Solar Pool70",10.294008168022858,null,null,null,null,"Commercial-Healthcare-Heat","Healthcare Heating",0,0.56754344036864923,1.0110886270832724,1.3011742675426228,1.4878726657137042,1.6080312913680206,1.6853650845905193,1.7351369219564476]
["None",0,{"$f":"A59&B59","v":"None0"},0,null,null,null,null,"Commercial-Healthcare-HotWater","Healthcare Hot Water",0,0.57481128063770215,1.0291502404662181,1.3260597953915907,1.5171500479752018,1.6401352602282946,1.7192882375698268,1.7702308973193246]
["None",10,"None10",0,null,null,null,null,"C-Hos-Lgt-LPD Int-All-All-C","Healthcare Interior Lights",0,0.56304669160233822,1.009981580900976,1.3020529823478819,1.4900294113616492,1.6110105744940872,1.6888737507958644,1.7389862977976229]
["None",20,"None20",0,null,null,null,null,"Commercial-Healthcare-Misc","Healthcare Other",0,0.56918567049201763,1.0202613296331138,1.3149988345170989,1.5046911610853708,1.6267766716248173,1.7053506031766179,1.7559205904931086]
["None",30,"None30",0,null,null,null,null,"Commercial-Healthcare-Motors","Healthcare Motors",0,0.56468674512789996,1.0125848061209748,1.30527552523047,1.4936505455546567,1.6148882410651273,1.6929165209686614,1.7431353282387025]
["None",40,"None40",0,null,null,null,null,"Commercial-Healthcare-OffEquip","Healthcare Office Eqpmt",0,0.56801453628405874,1.0181252188685064,1.3122413849179118,1.5015338193544885,1.6233619603105576,1.7017702494373206,1.7522336297002015]
["None",50,"None50",0,null,null,null,null,"Commercial-Healthcare-Process","Healthcare Process",0,0.56649607752131825,1.0155892547825691,1.3090502252102971,1.4979209773710389,1.6194777246610483,1.6977113454979675,1.7480623096830534]
["None",60,"None60",0,null,null,null,null,"Commercial-Healthcare-Refrig","Healthcare Refrigeration",0,0.5427037203163132,0.97372526706668872,1.2555379542362395,1.4369119002045025,1.5536437216370362,1.6287720321681489,1.677124426348183]
["None",70,"None70",0,null,null,null,null,"Commercial-Healthcare-Vent","Healthcare Ventilation",0,0.54349018973676078,0.9749487463483022,1.2570439842015002,1.4385997790884328,1.5554486380336505,1.6306522736174249,1.6790531468143863]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-AirComp","Lodging Compressed Air",0,0.56583735116131295,1.015344831524094,1.3090748810955859,1.4981188119253661,1.6197870165769179,1.6980923710950753,1.7484895028993539]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-Cook","Lodging Cooking",0,0.58684185756563845,1.0524352995264572,1.3565184031418762,1.5522255338567632,1.6781821574154805,1.7592475276979018,1.8114209987973595]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-Cool","Lodging Cooling",0,0.62661499985874514,1.1158793987288975,1.4349027932547331,1.6402254581159084,1.772370615584228,1.8574189109301593,1.9121557827143782]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-ExtLight","Lodging Exterior Lights",0,0.54443997927021237,0.96571221236874671,1.2412955460349324,1.4186602955504584,1.5328118080973334,1.6062794382342831,1.6535630226346489]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-Heat","Lodging Heating",0,0.68108736537414649,1.1923539880556064,1.5266704745475199,1.7418357354387104,1.8803155632814035,1.9694408367568437,2.0268016415456485]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-HotWater","Lodging Hot Water",0,0.57906755362164686,1.0364879441455124,1.3353533805153504,1.5277024335418785,1.6514978066355344,1.7311722014831334,1.7824504442453131]
[null,null,null,null,null,null,null,null,"C-Lod-Lgt-LPD Int-All-All-C","Lodging Interior Lights",0,0.56066898033937962,1.0049229255529912,1.2952656933726094,1.4821295780745378,1.6023947104493488,1.6797970511327953,1.7296130054744461]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-Misc","Lodging Other",0,0.55925528523530299,1.0029059995839456,1.2928604651056785,1.4794744394125019,1.5995787300773323,1.6768775534354639,1.7266268842834855]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-Motors","Lodging Motors",0,0.57106156726163271,1.024055342892251,1.3200304616815952,1.5105193134874448,1.6331174656927212,1.7120213321482105,1.7628036647497747]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-OffEquip","Lodging Office Eqpmt",0,0.55991998462658854,1.0045070604390043,1.2950675312679023,1.4820715290862367,1.6024268379149891,1.6798872159403626,1.729740522971223]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-Misc","Lodging Other",0,0.55925528523530299,1.0029059995839456,1.2928604651056785,1.4794744394125019,1.5995787300773323,1.6768775534354639,1.7266268842834855]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-Refrig","Lodging Refrigeration",0,0.54249393322078221,0.97345644031033596,1.255234566770711,1.4365862695523326,1.5533037753251537,1.6284228723332088,1.6767693367126724]
[null,null,null,null,null,null,null,null,"Commercial-Lodging-Vent","Lodging Ventilation",0,0.54322615952829445,0.97417106813572008,1.2559345640548987,1.4372768506565208,1.5539882961992668,1.6291034928582877,1.6774474469827942]
[null,null,null,null,null,null,null,null,"Commercial-large Office-AirComp","Large Office Compressed Air",0,0.60240843155343926,1.0781238491725842,1.3887309137531074,1.5886368495518548,1.7172958136405894,1.8001004035805845,1.8533932321346978]
[null,null,null,null,null,null,null,null,"Commercial-large Office-Cook","Large Office Cooking",0,0.64550932089254487,1.1528806022691984,1.4838755358421856,1.6969030535192617,1.8340070351354942,1.9222468173946061,1.9790377222344808]
[null,null,null,null,null,null,null,null,"Commercial-large Office-Cool","Large Office Cooling",0,0.65503834510669801,1.165543783297843,1.4983161543619476,1.7124876263964863,1.8503278541977457,1.9390414826740856,1.9961373537632237]
[null,null,null,null,null,null,null,null,"Commercial-large Office-ExtLight","Large Office Exterior Lights",0,0.5427216482135544,0.96402929572093854,1.2396299709196363,1.4170058814024431,1.5311645771201572,1.6046368303280287,1.6519233901253658]
[null,null,null,null,null,null,null,null,"Commercial-large Office-Heat","Large Office Heating",0,0.6218986761923897,1.1056396056381927,1.4216594569726544,1.6250490488910283,1.7559500854114878,1.8401976676034395,1.8944192023892261]
[null,null,null,null,null,null,null,null,"Commercial-large Office-HotWater","Large Office Hot Water",0,0.57396879560307856,1.0276870445337154,1.3241858249129235,1.5150117040182161,1.6378267661568713,1.7168702353070853,1.7677424158564641]
[null,null,null,null,null,null,null,null,"C-LOff-Lgt-LPD Int-All-All-C","Large Office Interior Lights",0,0.58756765691875235,1.052939393950775,1.3568876138507753,1.5525079337412167,1.6784086860687959,1.7594380977655353,1.8115884260085022]
[null,null,null,null,null,null,null,null,"Commercial-large Office-Misc","Large Office Other",0,0.57174748904560491,1.0245406890748536,1.3203849162286236,1.5107895265027069,1.6333334610672365,1.7122024331837165,1.7629623078753063]
[null,null,null,null,null,null,null,null,"Commercial-large Office-Motors","Large Office Motors",0,0.61538600900971929,1.1006707920635002,1.4174412595936501,1.621313946232446,1.7525259013158687,1.8369735899232047,1.8913239127012436]
[null,null,null,null,null,null,null,null,"Commercial-large Office-OffEquip","Large Office Office Eqpmt",0,0.56570333480356982,1.0138037965561413,1.3066251164901197,1.495084191180776,1.6163759838728731,1.6944390805882266,1.7446802958719345]
[null,null,null,null,null,null,null,null,"Commercial-large Office-Process","Large Office Process",0,0.55367154518714501,0.99331259973952513,1.2806882985151353,1.465642584944973,1.5846787046117266,1.6612900557668293,1.7105969312113731]
[null,null,null,null,null,null,null,null,"Commercial-large Office-Refrig","Large Office Refrigeration",0,0.54219277816806466,0.97268911567986072,1.2541665739284344,1.4353247673952363,1.5519177310533538,1.6269566730655145,1.6752515498885752]
[null,null,null,null,null,null,null,null,"Commercial-large Office-Vent","Large Office Ventilation",0,0.57717408808543502,1.0342025558200116,1.3327720713811411,1.524930670509697,1.6486034679473474,1.7281989734069894,1.7794264431548932]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-AirComp","Other Compressed Air",0,0.61123659038549738,1.0936995580096391,1.4086474115464132,1.6113470683430267,1.7418040643316262,1.8257658631394362,1.8798034684485392]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-Cook","Other Cooking",0,0.58346219253970211,1.0461376777315892,1.3483539467075938,1.5428595872822688,1.6680429347689933,1.748610626490847,1.8004637929040237]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-Cool","Other Cooling",0,0.70228082304848738,1.2440210182378459,1.5967791439147647,1.8238133980109879,1.9699320804201261,2.0639737017339455,2.1244986557885457]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-ExtLight","Other Exterior Lights",0,0.56994356966869308,1.0107134677475753,1.2988523721708036,1.4842978558610775,1.6036501088654351,1.6804649226519377,1.7299027461410303]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-Heat","Other Heating",0,0.75433253201693518,1.3188870499379894,1.6875360439357305,1.9247976214401277,2.0774985838092808,2.1757765441673302,2.239027995515678]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-HotWater","Other Hot Water",0,0.58183246317569459,1.0421343533947978,1.3428886669799733,1.5364533966938656,1.6610311762860479,1.7412091260140683,1.7928114554474019]
[null,null,null,null,null,null,null,null,"C-Oth-Lgt-LPD Int-All-All-C","Other Interior Lights",0,0.59151364739303003,1.0599308631876898,1.3658453215241717,1.5627311075918853,1.6894463108101125,1.7709999010785049,1.8234875893491116]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-Misc","Other Other",0,0.58644500874115091,1.051016430310578,1.3544572532511607,1.5497510137179431,1.6754415932110165,1.7563357381931435,1.8083990091143343]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-Motors","Other Motors",0,0.58741145946428941,1.0524658520421293,1.3561874422708833,1.5516619038674333,1.677468782159103,1.7584377767593375,1.8105492207089569]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-OffEquip","Other Office Eqpmt",0,0.60061275023145178,1.0749809712565794,1.3847237934920948,1.5840735050627519,1.712374484618906,1.7949486766022944,1.8480932216034116]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-Process","Other Process",0,0.56334364126102088,1.0098939814726289,1.3017175902252804,1.4895345404760778,1.610413063472514,1.6882101808375267,1.7382802124715495]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-Refrig","Other Refrigeration",0,0.54302576964644633,0.97418718124219095,1.2560728884641255,1.437493829956858,1.5542558975922915,1.6294036745045157,1.677768597199115]
[null,null,null,null,null,null,null,null,"Commercial-Misc. Com-Vent","Other Ventilation",0,0.58221546086208964,1.0423223541829882,1.3428642094898415,1.5362922015831533,1.6607819771821299,1.74090328775856,1.7924691643745152]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-AirComp","Restaurant Compressed Air",0,0.5855943654157223,1.0500624504407328,1.3534326842295119,1.5486810136934048,1.6743423539057842,1.7552176805594319,1.8072688400511225]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-Cook","Restaurant Cooking",0,0.58864211296746127,1.0554889581132705,1.3603930356069351,1.5566285430721019,1.6829252285958027,1.7642094619148108,1.8165237927213704]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-Cool","Restaurant Cooling",0,0.64662947581957442,1.1518344129495894,1.4810997770575789,1.6930141481199887,1.8294017113379903,1.9171804084942397,1.9736745601063828]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-ExtLight","Restaurant Exterior Lights",0,0.56165135139542843,0.99650711997154484,1.2808315768590364,1.4638220915832418,1.5815943326545758,1.6573922546827697,1.7061756091602669]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-Heat","Restaurant Heating",0,0.76492935958315433,1.3369316147280086,1.7105063983582571,1.9509382018437154,2.1056795137853839,2.2052706380639044,2.2693672384520314]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-HotWater","Restaurant Hot Water",0,0.59943013509839149,1.0733988305622884,1.382942911815479,1.5821647141832118,1.7103833716938499,1.7929045814130771,1.8460150271604894]
[null,null,null,null,null,null,null,null,"C-Res-Lgt-LPD Int-All-All-C","Restaurant Interior Lights",0,0.58224433497883554,1.0442057492767687,1.3459620672657122,1.5401716845267703,1.6651645121436176,1.7456095857501122,1.7973838354485965]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-Misc","Restaurant Other",0,0.57340084321923357,1.0274904077221523,1.3241728722985631,1.5151169700972484,1.638008117493537,1.7171005549267115,1.7680042513414573]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-Motors","Restaurant Motors",0,0.58544272260820407,1.0495009385086613,1.352601787304859,1.5476767412561732,1.6732264974189961,1.7540300088553151,1.8060349482513876]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-OffEquip","Restaurant Office Eqpmt",0,0.58433263896984378,1.0478047826087054,1.3505328521116202,1.5453678862350622,1.6707632305921774,1.7514673629736119,1.8034083422566309]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-Process","Restaurant Process",0,0.72077813406084479,1.282473094464379,1.648452226240293,1.8839954870456519,2.0355905450523792,2.1331567481077629,2.1959501142227849]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-Refrig","Restaurant Refrigeration",0,0.54303006920658659,0.97420918986737592,1.2561154789703226,1.4375496669105876,1.5543202599267734,1.629473523752889,1.67784197781165]
[null,null,null,null,null,null,null,null,"Commercial-Resturant-Vent","Restaurant Ventilation",0,0.56498178500118379,1.0133570700949233,1.3063058461284416,1.4948469512484002,1.6161915385211865,1.6942886136976281,1.7445516974345545]
[null,null,null,null,null,null,null,null,"Commercial-Retail-AirComp","Retail Compressed Air",0,0.62012772893618984,1.1097902634302024,1.4293818818002189,1.6350702541171065,1.7674507799961907,1.8526505578670776,1.9074849234283584]
[null,null,null,null,null,null,null,null,"Commercial-Retail-Cook","Retail Cooking",0,0.60883280702601272,1.0907347624505279,1.4053309624796519,1.6078042959515897,1.7381156308101899,1.8219836824762823,1.8759609523576664]
[null,null,null,null,null,null,null,null,"Commercial-Retail-Cool","Retail Cooling",0,0.70050569547816588,1.2419851740595065,1.594566421745768,1.8214868376062379,1.9675322540094051,2.0615267215036375,2.1220213274769932]
[null,null,null,null,null,null,null,null,"Commercial-Retail-ExtLight","Retail Exterior Lights",0,0.56562628767182266,1.0030214011163117,1.2889679113381274,1.4730023755621666,1.5914464999403815,1.6676768443971859,1.7167385048764108]
[null,null,null,null,null,null,null,null,"Commercial-Retail-Heat","Retail Heating",0,0.82693120087719962,1.4386919947048002,1.837823536763832,2.0947036065390097,2.2600309818381041,2.3664352702175404,2.4349168061098974]
[null,null,null,null,null,null,null,null,"Commercial-Retail-HotWater","Retail Hot Water",0,0.59476239287142607,1.0650211652259407,1.3721824548045403,1.5698706983648907,1.6971023612335805,1.7789883436510938,1.8316899586838351]
[null,null,null,null,null,null,null,null,"C-Ret-Lgt-LPD Int-All-All-C","Retail Interior Lights",0,0.58366031048090428,1.0466693809633978,1.3490983711930646,1.5437409186385962,1.6690123790475848,1.7496367800274997,1.8015264443784051]
[null,null,null,null,null,null,null,null,"Commercial-Retail-Misc","Retail Other",0,0.5837495817057845,1.0466919475511891,1.3490782745017922,1.5436933639668133,1.6689471524876998,1.7495601798842959,1.8014425242252072]
[null,null,null,null,null,null,null,null,"Commercial-Retail-Motors","Retail Motors",0,0.59644524142350663,1.0689700310162948,1.3775283958245561,1.5761157935350025,1.7039261497828821,1.7861845778228531,1.8391258979337521]
[null,null,null,null,null,null,null,null,"Commercial-Retail-OffEquip","Retail Office Eqpmt",0,0.59131679421431749,1.0595237304208207,1.3652998957565321,1.5620966767922095,1.6887545965927406,1.7702713193956883,1.822735279857044]
[null,null,null,null,null,null,null,null,"Commercial-Retail-Process","Retail Process",0,0.58920261493616854,1.0557100622467503,1.3604054693350049,1.5565066770451961,1.682716927579943,1.7639455315546031,1.8162240594532193]
[null,null,null,null,null,null,null,null,"Commercial-Retail-Refrig","Retail Refrigeration",0,0.54372863172888508,0.97541920107035784,1.2576407670224381,1.4392778663602495,1.5561790526482446,1.6314163659799477,1.6798389140918837]
[null,null,null,null,null,null,null,null,"Commercial-Retail-Vent","Retail Ventilation",0,0.57893879603854581,1.0380140586629794,1.3378743662148052,1.5308637158646676,1.6550711822758051,1.7350107993596691,1.786459738494794]
[null,null,null,null,null,null,null,null,"Commercial-School-AirComp","School Compressed Air",0,0.6384481393664645,1.1377595673096184,1.4636027894446111,1.6733146784273811,1.8082847296457603,1.8951511195974939,1.9510581125572704]
[null,null,null,null,null,null,null,null,"Commercial-School-Cook","School Cooking",0,0.71043033591408744,1.2607586348711401,1.6194507748725644,1.8503041458590794,1.998880802419287,2.0945043697957386,2.1560474604096616]
[null,null,null,null,null,null,null,null,"Commercial-School-Cool","School Cooling",0,0.85789039413053825,1.5050297092440332,1.9256503608273465,2.1963607681537152,2.3705893143721419,2.4827223742614497,2.5548909332780392]
[null,null,null,null,null,null,null,null,"Commercial-School-ExtLight","School Exterior Lights",0,0.55443326960284278,0.98313650377017869,1.2635002225946572,1.4439416161325509,1.5600732491356097,1.634815279883254,1.6829190653534432]
[null,null,null,null,null,null,null,null,"Commercial-School-Heat","School Heating",0,0.96356226639396891,1.6673338783148539,2.1256884647161067,2.4206843388309927,2.6105429511949674,2.7327354828597863,2.8113782929422371]
[null,null,null,null,null,null,null,null,"Commercial-School-HotWater","School Hot Water",0,0.67285172813539429,1.1968158674548195,1.5385546760350546,1.7584969249991644,1.900051210508511,1.9911551973070245,2.0497894970791473]
[null,null,null,null,null,null,null,null,"C-K12-Lgt-LPD Int-All-All-C","School Interior Lights",0,0.64357061140132799,1.1477859138878472,1.4767640841605547,1.6884936179834276,1.8247622204128524,1.9124643547008493,1.9689092306410236]
[null,null,null,null,null,null,null,null,"Commercial-School-Misc","School Other",0,0.66738882162575219,1.1862014062103259,1.5245875203426695,1.7423719834819198,1.8825375233902795,1.9727477169670364,2.0308067736401418]
[null,null,null,null,null,null,null,null,"Commercial-School-Motors","School Motors",0,0.64694871338240412,1.1517324533778182,1.4810913131765648,1.6930658578334778,1.8294921486275433,1.9172957707556206,1.9738059640177656]
[null,null,null,null,null,null,null,null,"Commercial-School-OffEquip","School Office Eqpmt",0,0.64325786677014862,1.1453684153645298,1.4729832851718423,1.6838354021990678,1.8195393013566712,1.9068779940205871,1.9630889598336103]
[null,null,null,null,null,null,null,null,"Commercial-School-Process","School Process",0,0.88433557638753335,1.549798204801216,1.9827856819002643,2.2614553474325638,2.4408064524764614,2.556236378511016,2.6305267923954556]
[null,null,null,null,null,null,null,null,"Commercial-School-Refrig","School Refrigeration",0,0.54381496823353914,0.97540850268447876,1.2575898386889017,1.4392010461322564,1.5560855684612462,1.6313121569102955,1.679727802514376]
[null,null,null,null,null,null,null,null,"Commercial-School-Vent","School Ventilation",0,0.66723260376708493,1.1884709418466746,1.5284962759677401,1.7473357370229845,1.8881802709714419,1.9788274634270591,2.0371677714939134]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-AirComp","Small Office Compressed Air",0,0.63464692632542774,1.1337124157064093,1.4593598847140103,1.6689457874698743,1.803834754265331,1.890648958483732,1.9465223648350674]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-Cook","Small Office Cooking",0,0.68373132211067689,1.2182756180240424,1.5667738934996054,1.7910665185797128,1.9354206953591417,2.0283266852294024,2.0881207497057073]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-Cool","Small Office Cooling",0,0.77951497926385327,1.3745593366288325,1.7617091347224352,2.0108777838216376,2.1712421079143778,2.2744521888563134,2.3408779407703149]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-ExtLight","Small Office Exterior Lights",0,0.54899961494599503,0.97328958669124443,1.2508227854891527,1.4294424633636478,1.5444016446874675,1.6183890884445247,1.6660072236005499]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-Heat","Small Office Heating",0,1.0110916849034901,1.7424922624503005,2.2187250470843267,2.5252272852059181,2.722491364884386,2.8494500369315237,2.9311603231338834]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-HotWater","Small Office Hot Water",0,0.57514930023883903,1.0295748813854151,1.3265364822251968,1.5176602314301375,1.6406670020255749,1.7198338542627303,1.7707854438606117]
[null,null,null,null,null,null,null,null,"C-SOff-Lgt-LPD Int-All-All-C","Small Office Interior Lights",0,0.63756271337031967,1.1396149271339431,1.4671925516080633,1.6780206976312941,1.8137091691102256,1.9010379325584421,1.9572425079528861]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-Misc","Small Office Other",0,0.61108424974607045,1.0927599010703681,1.4072044751420441,1.6095802225241225,1.7398287512175099,1.8236563809915638,1.8776076354435649]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-Motors","Small Office Motors",0,0.60589642076497352,1.0841704282491311,1.3963819267236934,1.5973204721942407,1.7266440213046803,1.809876336515063,1.8634444479915302]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-OffEquip","Small Office Office Eqpmt",0,0.60132753438406916,1.0756118263956003,1.3852977297605216,1.5846108084873445,1.712888211236133,1.7954472292448216,1.8485820083134861]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-Process","Small Office Process",0,0.67003809873767683,1.1951152260546249,1.5375234741386206,1.7578965727057192,1.8997281519501275,1.9910106043082485,2.0497597640715615]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-Refrig","Small Office Refrigeration",0,0.54285597341516889,0.9736809375061567,1.2553751769497148,1.436672890255531,1.5533556485357327,1.6284523821437857,1.6767844534945167]
[null,null,null,null,null,null,null,null,"Commercial-Small Office-Vent","Small Office Ventilation",0,0.6237088088092414,1.114499527093237,1.4348299523102683,1.6409938188800848,1.7736803716801191,1.8590771077177317,1.9140382350662433]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-AirComp","Warehouse Compressed Air",0,0.60389763111589945,1.0811039110779861,1.392676716867747,1.5932042013116703,1.7222631925656791,1.8053252389963281,1.8587837659087871]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-Cook","Warehouse Cooking",0,0.64945817681577422,1.1601298183659265,1.4932510833252579,1.707647102604767,1.845631848455535,1.9344384883898273,1.9915942214224371]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-Cool","Warehouse Cooling",0,0.80937482784841419,1.4225675112844545,1.821312896000197,2.0779444358677237,2.2431118579351366,2.3494132008116857,2.4178284812339088]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-ExtLight","Warehouse Exterior Lights",0,0.54558297318368221,0.96782187343846271,1.2440422225257446,1.4218169535851368,1.5362323292360192,1.6098697810117666,1.6572626621973445]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-Heat","Warehouse Heating",0,1.0628148751959974,1.8351270428491537,2.337784645422317,2.6612938307798601,2.8695035394860331,3.0035067912069922,3.0897509514019017]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-HotWater","Warehouse Hot Water",0,0.60118107486151584,1.0754038572103839,1.3851096634212672,1.5844355515703494,1.7127211984315096,1.795285522330458,1.8484237162569237]
[null,null,null,null,null,null,null,null,"C-War-Lgt-LPD Int-All-All-C","Warehouse Interior Lights",0,0.60008678808668214,1.0746758917981314,1.3845642275408117,1.5840075912434981,1.712368845079369,1.7949818294395752,1.8481513411181256]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-Misc","Warehouse Other",0,0.59110459866006737,1.0591064633096727,1.3647506472976239,1.5614624854654768,1.6880657362471152,1.7695472742051988,1.8219885897877326]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-Motors","Warehouse Motors",0,0.58907812036957696,1.0550492014037953,1.3593839412998885,1.5552530245004244,1.6813138802769194,1.7624463341559851,1.8146629800917331]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-OffEquip","Warehouse Office Eqpmt",0,0.61353888081451236,1.0975813495930178,1.413553676405628,1.6169126816596999,1.7477940326789347,1.8320289453311596,1.8862423260326253]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-Process","Warehouse Process",0,0.62485553042829678,1.1196023855912984,1.4424787923050784,1.6502812462467598,1.784022389812149,1.8700978578487191,1.9254958154270636]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-Refrig","Warehouse Refrigeration",0,0.55020777341192162,0.98614732968550711,1.2710668724656904,1.4544403829933554,1.5724591192131527,1.6484156849070661,1.6973011420540467]
[null,null,null,null,null,null,null,null,"Commercial-not-refrig-warehouse-Vent","Warehouse Ventilation",0,0.60143069656151837,1.0749706538765513,1.3841921248648688,1.5832062960668871,1.7112913226746378,1.7937265278764558,1.8467816213299371]
[null,null,null,null,null,null,null,null,"None","None",0,0,0,0,0,0,0,0]

{"sheet":"Com LU Table","index":8,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Compressed Air","Cooking","Cooling","Exterior Lighting","Heating","Hot Water","Indoor Lighting","Misc","Motors","Office Equipment","Process","Refrigeration","Ventilation","None"]
[null,"College","Commercial-college-AirComp","Commercial-college-Cook","Commercial-college-Cool","Commercial-college-ExtLight","Commercial-college-Heat","Commercial-college-HotWater","C-Unv-Lgt-LPD Int-All-All-C","Commercial-college-Misc","Commercial-college-Motors","Commercial-college-OffEquip","Commercial-college-Process","Commercial-college-Refrig","Commercial-college-Vent","None"]
[null,"Grocery","Commercial-Grocery-AirComp","Commercial-Grocery-Cook","Commercial-Grocery-Cool","Commercial-Grocery-ExtLight","Commercial-Grocery-Heat","Commercial-Grocery-HotWater","C-Gro-Lgt-LPD Int-All-All-C","Commercial-Grocery-Misc","Commercial-Grocery-Motors","Commercial-Grocery-OffEquip","Commercial-Grocery-Process","Commercial-Grocery-Refrig","Commercial-Grocery-Vent","None"]
[null,"Healthcare","Commercial-Healthcare-AirComp","Commercial-Healthcare-Cook","Commercial-Healthcare-Cool","Commercial-Healthcare-ExtLight","Commercial-Healthcare-Heat","Commercial-Healthcare-HotWater","C-Hos-Lgt-LPD Int-All-All-C","Commercial-Healthcare-Misc","Commercial-Healthcare-Motors","Commercial-Healthcare-OffEquip","Commercial-Healthcare-Process","Commercial-Healthcare-Refrig","Commercial-Healthcare-Vent","None"]
[null,"Lodging","Commercial-Lodging-AirComp","Commercial-Lodging-Cook","Commercial-Lodging-Cool","Commercial-Lodging-ExtLight","Commercial-Lodging-Heat","Commercial-Lodging-HotWater","C-Lod-Lgt-LPD Int-All-All-C","Commercial-Lodging-Misc","Commercial-Lodging-Motors","Commercial-Lodging-OffEquip","Commercial-Lodging-Misc","Commercial-Lodging-Refrig","Commercial-Lodging-Vent","None"]
[null,"Large Office","Commercial-large Office-AirComp","Commercial-large Office-Cook","Commercial-large Office-Cool","Commercial-large Office-ExtLight","Commercial-large Office-Heat","Commercial-large Office-HotWater","C-LOff-Lgt-LPD Int-All-All-C","Commercial-large Office-Misc","Commercial-large Office-Motors","Commercial-large Office-OffEquip","Commercial-large Office-Process","Commercial-large Office-Refrig","Commercial-large Office-Vent","None"]
[null,"Other","Commercial-Misc. Com-AirComp","Commercial-Misc. Com-Cook","Commercial-Misc. Com-Cool","Commercial-Misc. Com-ExtLight","Commercial-Misc. Com-Heat","Commercial-Misc. Com-HotWater","C-Oth-Lgt-LPD Int-All-All-C","Commercial-Misc. Com-Misc","Commercial-Misc. Com-Motors","Commercial-Misc. Com-OffEquip","Commercial-Misc. Com-Process","Commercial-Misc. Com-Refrig","Commercial-Misc. Com-Vent","None"]
[null,"Restaurant","Commercial-Resturant-AirComp","Commercial-Resturant-Cook","Commercial-Resturant-Cool","Commercial-Resturant-ExtLight","Commercial-Resturant-Heat","Commercial-Resturant-HotWater","C-Res-Lgt-LPD Int-All-All-C","Commercial-Resturant-Misc","Commercial-Resturant-Motors","Commercial-Resturant-OffEquip","Commercial-Resturant-Process","Commercial-Resturant-Refrig","Commercial-Resturant-Vent","None"]
[null,"Retail","Commercial-Retail-AirComp","Commercial-Retail-Cook","Commercial-Retail-Cool","Commercial-Retail-ExtLight","Commercial-Retail-Heat","Commercial-Retail-HotWater","C-Ret-Lgt-LPD Int-All-All-C","Commercial-Retail-Misc","Commercial-Retail-Motors","Commercial-Retail-OffEquip","Commercial-Retail-Process","Commercial-Retail-Refrig","Commercial-Retail-Vent","None"]
[null,"School","Commercial-School-AirComp","Commercial-School-Cook","Commercial-School-Cool","Commercial-School-ExtLight","Commercial-School-Heat","Commercial-School-HotWater","C-K12-Lgt-LPD Int-All-All-C","Commercial-School-Misc","Commercial-School-Motors","Commercial-School-OffEquip","Commercial-School-Process","Commercial-School-Refrig","Commercial-School-Vent","None"]
[null,"Small Office","Commercial-Small Office-AirComp","Commercial-Small Office-Cook","Commercial-Small Office-Cool","Commercial-Small Office-ExtLight","Commercial-Small Office-Heat","Commercial-Small Office-HotWater","C-SOff-Lgt-LPD Int-All-All-C","Commercial-Small Office-Misc","Commercial-Small Office-Motors","Commercial-Small Office-OffEquip","Commercial-Small Office-Process","Commercial-Small Office-Refrig","Commercial-Small Office-Vent","None"]
[null,"Warehouse","Commercial-not-refrig-warehouse-AirComp","Commercial-not-refrig-warehouse-Cook","Commercial-not-refrig-warehouse-Cool","Commercial-not-refrig-warehouse-ExtLight","Commercial-not-refrig-warehouse-Heat","Commercial-not-refrig-warehouse-HotWater","C-War-Lgt-LPD Int-All-All-C","Commercial-not-refrig-warehouse-Misc","Commercial-not-refrig-warehouse-Motors","Commercial-not-refrig-warehouse-OffEquip","Commercial-not-refrig-warehouse-Process","Commercial-not-refrig-warehouse-Refrig","Commercial-not-refrig-warehouse-Vent","None"]
[]
[]
[null,null,"How to lookup:"]
[null,null,"Select Sector","End Use","Load Profile"]
[null,null,"College","Cooling",{"$f":"INDEX(C3:O13, MATCH(C18, B3:B13, 0), MATCH(D18, C2:O2, 0))","v":"Commercial-college-Cool"}]