{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Worksheet","Measure Code","Tables","Export","Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Worksheet","index":0,"n_rows":43,"n_cols":37,"rows_kept":43,"cut":false,"hidden":false,"merged":[[8,2,8,4],[7,2,7,4],[5,2,5,4],[8,6,8,8],[14,35,16,35],[12,27,13,27],[14,29,16,29],[14,30,16,30],[14,33,16,33],[14,34,16,34],[14,32,16,32],[0,0,0,3],[3,11,3,12],[2,11,2,12],[14,17,14,21],[5,15,5,17],[5,18,5,20],[6,15,10,17],[6,18,10,20],[14,0,17,0],[13,2,13,3],[14,14,14,16],[3,2,3,4],[3,15,3,16],[4,2,4,4],[14,2,17,2],[13,6,13,8]]}
["FY23 SmartStart New Construction - Electric Chillers v1.0",null,null,null,"Incentive amounts are estimates until verified by the Program Manager."]
[]
["Customer Information",null,null,null,null,null,null,null,null,null,null,"Total Units Committed:",null,{"$f":"SUM($M19:$M43)","v":0}]
["Name",null,null,null,null,"Address",null,null,null,null,null,"Total Units Installed:",null,{"$f":"SUM($N19:$N43)","v":0},null,"Inspection Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EFLH is set in the protocol",null,null,null,"Lifetime"]
["Application",null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$14=\"\",\"\",VLOOKUP($G$14,Building_Lookup,2,FALSE))","v":""},null,"hrs/year",null,20,"years"]
["Contact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-Inspection Notes",null,null,"Post-Inspection Notes"]
["Contractor/Vendor Information"]
["Name",null,null,null,null,"Address"]
["Contact",null,null,null,null,"Phone"]
["Enhanced Incentive Eligibility"]
[false,null,false,false]
[false,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Incentive",null,null,null,null,null,null,null,null,null,"Committed","Installed",null,null,"Total Savings"]
["Project Type",null,"New Construction",null,null,"Building Type",null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,{"$f":"SUM(X19:X43)","v":0},{"$f":"SUM(Y19:Y43)","v":0},null,null,null,null,null,{"$f":"SUM(AD19:AD43)","v":0},{"$f":"SUM(AE19:AE43)","v":0},null,{"$f":"SUM(AG19:AG43)","v":0},{"$f":"SUM(AH19:AH43)","v":0},{"$f":"SUM(AI19:AI43)","v":0},{"$f":"SUM(AJ19:AJ43)","v":0}]
["Measure Code","Reason","Type & Capacity Range","Application","Speed","Manufacturer","Model Number","Unit Size","Location in Building","Full Load","Part Load","Eff","# of Units","# of Units","Reference",null,null,"Incentive Calculations",null,null,null,null,null,"Total","Total",null,"Baseline","Peak Duty","Demand","Committed Peak Reduction","Installed Peak Reduction","Energy","Committed Annual Savings","Installed Annual Savings","Committed Lifetime Savings","Installed Lifetime Savings"]
[null,"New",null,"Comfort Cooling","Constant",null,null,"(Tons)",null,"Efficiency","Efficiency","Units","Committed","Installed","Min","Min",null,"Base","Base","Performance","Performanace","Enhanced","Total","Committed","Installed",null,"Equipment","Cycle","Savings",null,null,"Savings"]
[null,"Replaced",null,null,"Variable",null,null,null,null,"Rating","Rating",null,null,null,"Qualifying","Incentive","Qualified?","Incentive","Incentive","Incentive","Incentive","Incentive","Incentive","Incentives","Incentive",null,"Efficiency","Fraction","per Unit",null,null,"per Unit"]
[null," ",null,null," ",null,null,null,null,"FLV","IPLV",null,null,null,"Efficiency","Efficiency",null,"Per Ton","Per Unit","Per Ton","Per Unit","Per Unit","Per Unit","$","$",null,"kW/ton",null,"kW","kW","kW","kWh","kWh","kWh","kWh","kWh"]
[null,"New",{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A19=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A19=\"\")=TRUE,\"\",VLOOKUP(A19,MeasureCode_Lookup,IF(E19=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A19=\"\")=TRUE,\"\",VLOOKUP(A19,MeasureCode_Lookup,IF(E19=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A19=\"\",J19=\"\",K19=\"\",H19=\"\")=TRUE,\"\",IF(OR(AND(L19=\"EER\",OR(J19<VLOOKUP(A19,MeasureCode_Lookup,7,FALSE),K19<VLOOKUP(A19,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L19=\"kW/Ton\",OR(J19>VLOOKUP(A19,MeasureCode_Lookup,7,FALSE),K19>VLOOKUP(A19,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H19<VLOOKUP(A19,MeasureCode_Lookup,5,FALSE),H19>VLOOKUP(A19,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q19=\"Yes\",VLOOKUP(A19,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R19*H19","v":0},{"$f":"IF(Q19=\"Yes\",VLOOKUP(A19,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L19=\"EER\",ROUNDDOWN((IF(E19=\"Constant\",J19+0.0001,K19+0.0001)-VLOOKUP(A19,MeasureCode_Lookup,IF(E19=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A19,MeasureCode_Lookup,IF(E19=\"Constant\",7,8),FALSE)-IF(E19=\"Constant\",J19-0.0001,K19-0.0001))/0.01,0)),0)","v":0},{"$f":"T19*H19","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,S19+U19,0)","v":0},{"$f":"IF(Q19=\"Yes\",S19+U19+V19,0)","v":0},{"$f":"M19*W19","v":0},{"$f":"N19*W19","v":0},null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A19=\"\",\"\",0.67)","v":""},{"$f":"IF(Q19=\"Yes\",IF(L19=\"EER\",H19*AB19*(AA19-12/IF(E19=\"Constant\",J19,K19)),H19*AB19*(AA19-IF(E19=\"Constant\",J19,K19))),0)","v":0},{"$f":"M19*AC19","v":0},{"$f":"N19*AC19","v":0},{"$f":"IF(Q19=\"Yes\",IF(L19=\"EER\",H19*$AE$5*(AA19-12/IF(E19=\"Constant\",J19,K19)),H19*$AE$5*(AA19-IF(E19=\"Constant\",J19,K19))),0)","v":0},{"$f":"M19*AF19","v":0},{"$f":"N19*AF19","v":0},{"$f":"AG19*$AI$5","v":0},{"$f":"AH19*$AI$5","v":0}]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,S20+U20,0)","v":0},{"$f":"IF(Q20=\"Yes\",S20+U20+V20,0)","v":0},0,0,null,"","",0,0,0,0,0,0,{"$f":"AG20*$AI$5","v":0},{"$f":"AH20*$AI$5","v":0}]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]
[null,"New","","","",null,null,null,null,null,null,"",null,null,"","","",0,0,0,0,0,0,0,0,null,"","",0,0,0,0,0,0,0,0]

{"sheet":"Measure Code","index":1,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Type & Capacity Range","Speed","Efficiency Units","Min Capacity (Tons)","Max Capacity (Tons)","Min Full Load Efficiency","Min IPLV Efficiency","Base Incentive ($/Ton)\nEB","Base Incentive ($/Ton)\nNC","Performance Incentive ($/Ton)\nEB","Performance Incentive\n($/Ton)\nNC","Baseline Efficiency\n(kW/Ton)"]
["CHILL1","Air Cooled Chiller Capacity: tons < 150","Constant","EER",0.01,149.99,10.3,13.7,20,10,3.5,3.5,1.1879999999999999]
["CHILL2","Air Cooled Chiller Capacity: tons < 150","Variable","EER",0.01,149.99,9.6999999999999993,16.12,90,45,4,4,0.75900000000000001]
["CHILL3","Air Cooled Chiller Capacity: tons ≥ 150","Constant","EER",150,999999,10.3,14,20,10,2.75,2.75,1.1879999999999999]
["CHILL4","Air Cooled Chiller Capacity: tons ≥ 150","Variable","EER",150,999999,9.6999999999999993,16.420000000000002,92,46,4,4,0.745]
["CHILL5","Water Cooled Positive Displacement Chiller Capacity: tons < 75","Constant","kW/Ton",0.01,74.989999999999995,0.73499999999999999,0.6,13,6.5,2.25,2.25,0.75]
["CHILL6","Water Cooled Positive Displacement Chiller Capacity: tons < 75","Variable","kW/Ton",0.01,74.989999999999995,0.78,0.49,40,20,2.5,2.5,0.5]
["CHILL7","Water Cooled Positive Displacement Chiller Capacity: 75 ≤ tons < 150","Constant","kW/Ton",75,149.99,0.70599999999999996,0.56000000000000005,20,10,2,2,0.72]
["CHILL8","Water Cooled Positive Displacement Chiller Capacity: 75 ≤ tons < 150","Variable","kW/Ton",75,149.99,0.75,0.48,43,21.5,2,2,0.49]
["CHILL9","Water Cooled Positive Displacement Chiller Capacity: 150 ≤ tons < 300","Constant","kW/Ton",150,299.99,0.64700000000000002,0.54,17,8.5,2,2,0.66]
["CHILL10","Water Cooled Positive Displacement Chiller Capacity: 150 ≤ tons < 300","Variable","kW/Ton",150,299.99,0.68,0.43099999999999999,43,21.5,2,2,0.44]
["CHILL11","Water Cooled Positive Displacement Chiller Capacity: 300 ≤ tons < 600","Constant","kW/Ton",300,599.99,0.59799999999999998,0.52,15,7.5,2.25,2.25,0.61]
["CHILL12","Water Cooled Positive Displacement Chiller Capacity: 300 ≤ tons < 600","Variable","kW/Ton",300,599.99,0.625,0.40200000000000002,37,18.5,2,2,0.41]
["CHILL13","Water Cooled Positive Displacement Chiller Capacity: tons ≥ 600","Constant","kW/Ton",600,999999,0.54900000000000004,0.5,30,15,2,2,0.56000000000000005]
["CHILL14","Water Cooled Positive Displacement Chiller Capacity: tons ≥ 600","Variable","kW/Ton",600,999999,0.58499999999999996,0.372,44,22,2,2,0.38]
["CHILL15","Water Cooled Centrifugal Chiller Capacity: tons < 150","Constant","kW/Ton",0.01,149.99,0.59799999999999998,0.55000000000000004,24,12,2.25,2.25,0.61]
["CHILL16","Water Cooled Centrifugal Chiller Capacity: tons < 150","Variable","kW/Ton",0.01,149.99,0.69499999999999995,0.43099999999999999,24,12,2.75,2.75,0.44]
["CHILL17","Water Cooled Centrifugal Chiller Capacity: 150 ≤ tons < 300","Constant","kW/Ton",150,299.99,0.59799999999999998,0.55000000000000004,10,5,2,2,0.61]
["CHILL18","Water Cooled Centrifugal Chiller Capacity: 150 ≤ tons < 300","Variable","kW/Ton",150,299.99,0.63500000000000001,0.39200000000000002,30,15,2.5,2.5,0.4]
["CHILL19","Water Cooled Centrifugal Chiller Capacity: 300 ≤ tons < 400","Constant","kW/Ton",300,399.99,0.54900000000000004,0.52,8,4,2,2,0.56000000000000005]
["CHILL20","Water Cooled Centrifugal Chiller Capacity: 300 ≤ tons < 400","Variable","kW/Ton",300,399.99,0.59499999999999997,0.38200000000000001,20,10,2,2,0.39]
["CHILL21","Water Cooled Centrifugal Chiller Capacity: 400 ≤ tons < 600","Constant","kW/Ton",400,599.99,0.54900000000000004,0.5,8,4,2,2,0.56000000000000005]
["CHILL22","Water Cooled Centrifugal Chiller Capacity: 400 ≤ tons < 600","Variable","kW/Ton",400,599.99,0.58499999999999996,0.372,25,12.5,2,2,0.38]
["CHILL23","Water Cooled Centrifugal Chiller Capacity: tons ≥ 600","Constant","kW/Ton",600,999999,0.54900000000000004,0.5,8,4,2,2,0.56000000000000005]
["CHILL24","Water Cooled Centrifugal Chiller Capacity: tons ≥ 600","Variable","kW/Ton",600,999999,0.58499999999999996,0.372,25,12.5,2,2,0.38]

{"sheet":"Tables","index":2,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Facility Type","Cooling EFLHc"]
["Assembly",669]
["Auto repair",426]
["Dormitory",800]
["Hospital",1424]
["Light industrial",549]
["Lodging – Hotel",2918]
["Lodging – Motel",1233]
["Office – large",720]
["Office – small",955]
["Other",736]
["Religious worship",279]
["Restaurant – fast food",645]
["Restaurant – full service",574]
["Retail – big box",1279]
["Retail – Grocery",1279]
["Retail – small",882]
["Retail – large",1068]
["School – Community college",846]
["School – postsecondary",1208]
["School – primary",394]
["School – secondary",466]
["Warehouse",400]
["Multifamily: Low-rise, Prior to 1979",507]
["Multifamily: Low-rise, From 1979 to 2006",550]
["Multifamily: Low-rise, From 2007 through present",562]
["Multifamily: High-rise, Prior to 1979",793]
["Multifamily: High-rise, From 1979 to 2006",843]
["Multifamily: High-rise, From 2007 through present",954]

{"sheet":"Export","index":3,"n_rows":26,"n_cols":25,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Measure Type","Manufacturer","Model","Capacity/Size","Capacity/Size Units","EER Efficiency","SEER Efficiency","Incentive Per Unit","Quantity Committed","Annual Electricity Savings","Peak Demand Reduction","Lifetime Electricity Savings","Annual Gas Savings","Lifetime Gas Savings","Efficiency- other","Efficiency- other-type","Measure ID removed","Quantity Installed","Project in UEZ","Project in OZ","Municipality","K-12 School","County","Affordable Housing","Enhanced Incentive per Unit"]
[{"$f":"IF(ISBLANK(Worksheet!M19)=TRUE,\"\",(IF(LEFT(Worksheet!C19,1)=\"A\",70,IF(Worksheet!E19=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F19","v":0},{"$f":"Worksheet!G19","v":0},{"$f":"Worksheet!H19","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S19+Worksheet!U19,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M19)=FALSE,Worksheet!M19,\"\")","v":""},{"$f":"Worksheet!AF19","v":0},{"$f":"Worksheet!AC19","v":0},{"$f":"Worksheet!AF19*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N19)=FALSE,Worksheet!N19,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V19,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M20)=TRUE,\"\",(IF(LEFT(Worksheet!C20,1)=\"A\",70,IF(Worksheet!E20=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F20","v":0},{"$f":"Worksheet!G20","v":0},{"$f":"Worksheet!H20","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S20+Worksheet!U20,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M20)=FALSE,Worksheet!M20,\"\")","v":""},{"$f":"Worksheet!AF20","v":0},{"$f":"Worksheet!AC20","v":0},{"$f":"Worksheet!AF20*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N20)=FALSE,Worksheet!N20,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V20,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M21)=TRUE,\"\",(IF(LEFT(Worksheet!C21,1)=\"A\",70,IF(Worksheet!E21=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F21","v":0},{"$f":"Worksheet!G21","v":0},{"$f":"Worksheet!H21","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S21+Worksheet!U21,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M21)=FALSE,Worksheet!M21,\"\")","v":""},{"$f":"Worksheet!AF21","v":0},{"$f":"Worksheet!AC21","v":0},{"$f":"Worksheet!AF21*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N21)=FALSE,Worksheet!N21,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V21,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M22)=TRUE,\"\",(IF(LEFT(Worksheet!C22,1)=\"A\",70,IF(Worksheet!E22=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F22","v":0},{"$f":"Worksheet!G22","v":0},{"$f":"Worksheet!H22","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S22+Worksheet!U22,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M22)=FALSE,Worksheet!M22,\"\")","v":""},{"$f":"Worksheet!AF22","v":0},{"$f":"Worksheet!AC22","v":0},{"$f":"Worksheet!AF22*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N22)=FALSE,Worksheet!N22,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V22,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M23)=TRUE,\"\",(IF(LEFT(Worksheet!C23,1)=\"A\",70,IF(Worksheet!E23=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F23","v":0},{"$f":"Worksheet!G23","v":0},{"$f":"Worksheet!H23","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S23+Worksheet!U23,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M23)=FALSE,Worksheet!M23,\"\")","v":""},{"$f":"Worksheet!AF23","v":0},{"$f":"Worksheet!AC23","v":0},{"$f":"Worksheet!AF23*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N23)=FALSE,Worksheet!N23,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V23,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M24)=TRUE,\"\",(IF(LEFT(Worksheet!C24,1)=\"A\",70,IF(Worksheet!E24=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F24","v":0},{"$f":"Worksheet!G24","v":0},{"$f":"Worksheet!H24","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S24+Worksheet!U24,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M24)=FALSE,Worksheet!M24,\"\")","v":""},{"$f":"Worksheet!AF24","v":0},{"$f":"Worksheet!AC24","v":0},{"$f":"Worksheet!AF24*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N24)=FALSE,Worksheet!N24,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V24,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M25)=TRUE,\"\",(IF(LEFT(Worksheet!C25,1)=\"A\",70,IF(Worksheet!E25=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F25","v":0},{"$f":"Worksheet!G25","v":0},{"$f":"Worksheet!H25","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S25+Worksheet!U25,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M25)=FALSE,Worksheet!M25,\"\")","v":""},{"$f":"Worksheet!AF25","v":0},{"$f":"Worksheet!AC25","v":0},{"$f":"Worksheet!AF25*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N25)=FALSE,Worksheet!N25,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V25,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M26)=TRUE,\"\",(IF(LEFT(Worksheet!C26,1)=\"A\",70,IF(Worksheet!E26=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F26","v":0},{"$f":"Worksheet!G26","v":0},{"$f":"Worksheet!H26","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S26+Worksheet!U26,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M26)=FALSE,Worksheet!M26,\"\")","v":""},{"$f":"Worksheet!AF26","v":0},{"$f":"Worksheet!AC26","v":0},{"$f":"Worksheet!AF26*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N26)=FALSE,Worksheet!N26,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V26,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M27)=TRUE,\"\",(IF(LEFT(Worksheet!C27,1)=\"A\",70,IF(Worksheet!E27=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F27","v":0},{"$f":"Worksheet!G27","v":0},{"$f":"Worksheet!H27","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S27+Worksheet!U27,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M27)=FALSE,Worksheet!M27,\"\")","v":""},{"$f":"Worksheet!AF27","v":0},{"$f":"Worksheet!AC27","v":0},{"$f":"Worksheet!AF27*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N27)=FALSE,Worksheet!N27,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V27,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M28)=TRUE,\"\",(IF(LEFT(Worksheet!C28,1)=\"A\",70,IF(Worksheet!E28=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F28","v":0},{"$f":"Worksheet!G28","v":0},{"$f":"Worksheet!H28","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S28+Worksheet!U28,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M28)=FALSE,Worksheet!M28,\"\")","v":""},{"$f":"Worksheet!AF28","v":0},{"$f":"Worksheet!AC28","v":0},{"$f":"Worksheet!AF28*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N28)=FALSE,Worksheet!N28,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V28,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M29)=TRUE,\"\",(IF(LEFT(Worksheet!C29,1)=\"A\",70,IF(Worksheet!E29=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F29","v":0},{"$f":"Worksheet!G29","v":0},{"$f":"Worksheet!H29","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S29+Worksheet!U29,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M29)=FALSE,Worksheet!M29,\"\")","v":""},{"$f":"Worksheet!AF29","v":0},{"$f":"Worksheet!AC29","v":0},{"$f":"Worksheet!AF29*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N29)=FALSE,Worksheet!N29,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V29,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M30)=TRUE,\"\",(IF(LEFT(Worksheet!C30,1)=\"A\",70,IF(Worksheet!E30=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F30","v":0},{"$f":"Worksheet!G30","v":0},{"$f":"Worksheet!H30","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S30+Worksheet!U30,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M30)=FALSE,Worksheet!M30,\"\")","v":""},{"$f":"Worksheet!AF30","v":0},{"$f":"Worksheet!AC30","v":0},{"$f":"Worksheet!AF30*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N30)=FALSE,Worksheet!N30,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V30,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M31)=TRUE,\"\",(IF(LEFT(Worksheet!C31,1)=\"A\",70,IF(Worksheet!E31=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F31","v":0},{"$f":"Worksheet!G31","v":0},{"$f":"Worksheet!H31","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S31+Worksheet!U31,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M31)=FALSE,Worksheet!M31,\"\")","v":""},{"$f":"Worksheet!AF31","v":0},{"$f":"Worksheet!AC31","v":0},{"$f":"Worksheet!AF31*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N31)=FALSE,Worksheet!N31,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V31,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M32)=TRUE,\"\",(IF(LEFT(Worksheet!C32,1)=\"A\",70,IF(Worksheet!E32=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F32","v":0},{"$f":"Worksheet!G32","v":0},{"$f":"Worksheet!H32","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S32+Worksheet!U32,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M32)=FALSE,Worksheet!M32,\"\")","v":""},{"$f":"Worksheet!AF32","v":0},{"$f":"Worksheet!AC32","v":0},{"$f":"Worksheet!AF32*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N32)=FALSE,Worksheet!N32,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V32,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M33)=TRUE,\"\",(IF(LEFT(Worksheet!C33,1)=\"A\",70,IF(Worksheet!E33=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F33","v":0},{"$f":"Worksheet!G33","v":0},{"$f":"Worksheet!H33","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S33+Worksheet!U33,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M33)=FALSE,Worksheet!M33,\"\")","v":""},{"$f":"Worksheet!AF33","v":0},{"$f":"Worksheet!AC33","v":0},{"$f":"Worksheet!AF33*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N33)=FALSE,Worksheet!N33,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V33,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M34)=TRUE,\"\",(IF(LEFT(Worksheet!C34,1)=\"A\",70,IF(Worksheet!E34=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F34","v":0},{"$f":"Worksheet!G34","v":0},{"$f":"Worksheet!H34","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S34+Worksheet!U34,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M34)=FALSE,Worksheet!M34,\"\")","v":""},{"$f":"Worksheet!AF34","v":0},{"$f":"Worksheet!AC34","v":0},{"$f":"Worksheet!AF34*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N34)=FALSE,Worksheet!N34,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V34,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M35)=TRUE,\"\",(IF(LEFT(Worksheet!C35,1)=\"A\",70,IF(Worksheet!E35=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F35","v":0},{"$f":"Worksheet!G35","v":0},{"$f":"Worksheet!H35","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S35+Worksheet!U35,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M35)=FALSE,Worksheet!M35,\"\")","v":""},{"$f":"Worksheet!AF35","v":0},{"$f":"Worksheet!AC35","v":0},{"$f":"Worksheet!AF35*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N35)=FALSE,Worksheet!N35,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V35,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M36)=TRUE,\"\",(IF(LEFT(Worksheet!C36,1)=\"A\",70,IF(Worksheet!E36=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F36","v":0},{"$f":"Worksheet!G36","v":0},{"$f":"Worksheet!H36","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S36+Worksheet!U36,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M36)=FALSE,Worksheet!M36,\"\")","v":""},{"$f":"Worksheet!AF36","v":0},{"$f":"Worksheet!AC36","v":0},{"$f":"Worksheet!AF36*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N36)=FALSE,Worksheet!N36,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V36,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M37)=TRUE,\"\",(IF(LEFT(Worksheet!C37,1)=\"A\",70,IF(Worksheet!E37=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F37","v":0},{"$f":"Worksheet!G37","v":0},{"$f":"Worksheet!H37","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S37+Worksheet!U37,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M37)=FALSE,Worksheet!M37,\"\")","v":""},{"$f":"Worksheet!AF37","v":0},{"$f":"Worksheet!AC37","v":0},{"$f":"Worksheet!AF37*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N37)=FALSE,Worksheet!N37,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V37,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M38)=TRUE,\"\",(IF(LEFT(Worksheet!C38,1)=\"A\",70,IF(Worksheet!E38=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F38","v":0},{"$f":"Worksheet!G38","v":0},{"$f":"Worksheet!H38","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S38+Worksheet!U38,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M38)=FALSE,Worksheet!M38,\"\")","v":""},{"$f":"Worksheet!AF38","v":0},{"$f":"Worksheet!AC38","v":0},{"$f":"Worksheet!AF38*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N38)=FALSE,Worksheet!N38,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V38,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M39)=TRUE,\"\",(IF(LEFT(Worksheet!C39,1)=\"A\",70,IF(Worksheet!E39=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F39","v":0},{"$f":"Worksheet!G39","v":0},{"$f":"Worksheet!H39","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S39+Worksheet!U39,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M39)=FALSE,Worksheet!M39,\"\")","v":""},{"$f":"Worksheet!AF39","v":0},{"$f":"Worksheet!AC39","v":0},{"$f":"Worksheet!AF39*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N39)=FALSE,Worksheet!N39,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V39,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M40)=TRUE,\"\",(IF(LEFT(Worksheet!C40,1)=\"A\",70,IF(Worksheet!E40=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F40","v":0},{"$f":"Worksheet!G40","v":0},{"$f":"Worksheet!H40","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S40+Worksheet!U40,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M40)=FALSE,Worksheet!M40,\"\")","v":""},{"$f":"Worksheet!AF40","v":0},{"$f":"Worksheet!AC40","v":0},{"$f":"Worksheet!AF40*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N40)=FALSE,Worksheet!N40,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V40,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M41)=TRUE,\"\",(IF(LEFT(Worksheet!C41,1)=\"A\",70,IF(Worksheet!E41=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F41","v":0},{"$f":"Worksheet!G41","v":0},{"$f":"Worksheet!H41","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S41+Worksheet!U41,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M41)=FALSE,Worksheet!M41,\"\")","v":""},{"$f":"Worksheet!AF41","v":0},{"$f":"Worksheet!AC41","v":0},{"$f":"Worksheet!AF41*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N41)=FALSE,Worksheet!N41,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V41,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M42)=TRUE,\"\",(IF(LEFT(Worksheet!C42,1)=\"A\",70,IF(Worksheet!E42=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F42","v":0},{"$f":"Worksheet!G42","v":0},{"$f":"Worksheet!H42","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S42+Worksheet!U42,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M42)=FALSE,Worksheet!M42,\"\")","v":""},{"$f":"Worksheet!AF42","v":0},{"$f":"Worksheet!AC42","v":0},{"$f":"Worksheet!AF42*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N42)=FALSE,Worksheet!N42,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V42,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M43)=TRUE,\"\",(IF(LEFT(Worksheet!C43,1)=\"A\",70,IF(Worksheet!E43=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F43","v":0},{"$f":"Worksheet!G43","v":0},{"$f":"Worksheet!H43","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S43+Worksheet!U43,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M43)=FALSE,Worksheet!M43,\"\")","v":""},{"$f":"Worksheet!AF43","v":0},{"$f":"Worksheet!AC43","v":0},{"$f":"Worksheet!AF43*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N43)=FALSE,Worksheet!N43,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V43,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[14]
["Log"]
["Updated for new Baseline Efficiencies for Protocol effective 1/1/08"]
["Updated for compatability with Measure Tracking on 12/1/2008"]
["Updated to reflect new incentive structure on 7/13/09.  Changes in red."]
["2012-01-01","no changfe for V5"]
["2012-09-20","changed IPLV/PLV columns to a efficiency type and efficiency column and lined up savings calc to protocol (now references both IPLV and FLV)"]
["2013-04-01","fixed formula in Savings per Unit column, but this shouldn't have any effect on results whatsover. Also changed the measure ID column of the export tab to reference the Efficiency Rating Type column when deciding whether to use the \"part load chiller\" or \"full load chiller\" measure ID."]
["2013-07-09","no change for V7, skipped V6"]
["2015-06-20","Worksheet and Tables Tabs updated for V9 by Aimee Lalonde, QC Mike Roberts"]
["2018-06-21","Updated to align with FY19 Protocols"]
["2019-07-01","Added Enhanced Incentive Eligibility Section and Updated for FY20 Program"]
["2020-10-01","Updated for FY21 Program"]