{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Worksheet","Measure Codes","Table","Export","Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":44,"n_cols":46,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,18,1,20],[2,18,2,20],[5,32,5,33],[12,2,12,7],[2,10,2,12],[12,10,12,12],[0,0,0,5],[13,0,18,0],[14,2,17,2],[14,6,15,6],[13,5,13,9],[14,9,16,9],[17,9,18,9],[14,5,17,5],[13,35,15,35],[13,36,15,36],[13,37,15,37],[13,30,15,30],[14,7,17,7],[14,8,16,8],[17,8,18,8],[16,26,18,26],[13,22,15,22],[13,23,15,23],[13,10,14,10],[15,15,18,15],[15,12,18,12],[13,12,14,12],[13,11,14,11],[16,24,18,24],[13,41,15,41],[13,14,13,15],[13,16,14,16],[13,17,14,17],[13,38,15,38],[13,39,15,39],[13,32,15,32],[13,18,14,18],[13,24,15,24],[13,33,15,33],[13,26,15,26],[13,40,15,40],[13,34,15,34],[14,14,15,14],[13,19,15,19],[13,25,15,25],[13,13,14,13],[15,13,16,13],[16,22,18,22],[16,23,18,23],[13,20,15,20],[13,21,15,21],[16,25,18,25],[4,38,4,40],[5,30,5,31],[2,2,2,7],[5,35,8,37],[5,38,8,40],[3,2,3,7],[4,35,4,37],[6,2,6,7],[6,10,6,12],[7,2,7,3],[7,10,7,11],[13,27,15,27],[16,27,18,27],[13,28,15,28],[13,29,15,29],[16,28,18,28],[16,29,18,29],[16,30,18,30],[13,31,15,31],[16,31,18,31],[16,32,18,32],[16,33,18,33],[16,39,18,39],[16,40,18,40],[16,41,18,41],[16,34,18,34],[16,35,18,35],[16,36,18,36],[16,37,18,37],[16,38,18,38]]}
["FY24 SmartStart New Construction - Electric Unitary HVAC v1.0",null,null,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,null,null,null,null,null,null,null,"Total Units Committed:",null,null,{"$f":"SUM($Q20:$Q44)","v":0}]
["Name",null,null,null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,null,"Total Units Installed:",null,null,{"$f":"SUM($R20:$R44)","v":0}]
["Contact",null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,"Pre-Inspection Notes",null,null,"Post-Inspection Notes"]
["Contractor/Vendor Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Type"]
["Name",null,null,null,null,null,null,null,null,"Address"]
["Contact",null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","Inspector/Sign-off"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-Inspection"]
["Project Type",null,null,null,null,null,null,null,null,"Building Type",null,null,null,null,null,null,null,"Totals:",null,null,{"$f":"SUM(U20:U44)","v":0},{"$f":"SUM(V20:V44)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG20:AG44)","v":0},0,0,0,0,0,0,0,0,0,"Post Inspection"]
["Measure Code","Reason","Type","Manufacturer","Model","Occ. Cont. T-Stat Only",null,null,null,null,"Unit Size Cooling","Is equipment rated in SEER2/HSPF2?","Unit Cooling Efficiency","AC & ASHP ≥ 65,000 Btuh Only","HP And Occ. Cont.T-Stat Only",null,"Quantity Committed","Quantity Installed","Incentive Per Unit","Enhanced Incentive Per Unit","Total Committed Incentive","Total Installed Incentive","Baseline Efficiency Cooling","Baseline Efficiency Heating","Baseline Efficiency Cooling","Baseline Efficiency Cooling","Baseline Efficiency Heating","Peak Demand Savings per Unit","Annual Cooling  Savings per Unit","Annual Heating Savings per Unit","Total Annual Savings per Unit","Annual Heating Savings per Unit","Peak Demand Savings Committed","Peak Demand Savings Installed","Annual Energy Savings Committed","Annual Energy Savings\nInstalled","Annual Energy Savings Committed","Annual Energy Savings\nInstalled","Lifetime Energy Savings Committed","Lifetime Energy Savings\nInstalled","Lifetime Energy Savings Committed","Lifetime Energy Savings\nInstalled"]
[null,"N-New","<Hover over cell C14 for abbreviation definitions>",null,null,"Heating Season Facility Temp.","Heating Type","Cooling Season Facility Temp.","Weekly Occupied Hours","Number of hotel/hospitality units",null,null,null,null,"Unit Size Heating","Heating Efficiency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOUND PRE",null,"FOUND POST"]
[null,"R-Replaced",null,null,null,null,null,null,null,null,"(Btuh)",null,"(SEER/SEER2 or EER)\n\n<Hover over cell M14 for units>","Unit Cooling Efficiency",null,"(HSPF/HSPF2, COP, AFUE, Et, or Ec)\n<Hover over cell P15 for units>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Type)","Count","(Type)","Count"]
[null,null,null,null,null,null,"G - Gas",null,null,null,null,null,null,null,"(Btuh)",null,null,null,null,null,null,null,"(SEER2)","(HSPF2)","(SEER or EER)","(IEER)","(HSPF or COP)","(kW)","(kWh)","(kWh)","(kWh)","(Therms)","(kW)","(kW)","(kWh)","(kWh)","(Therms)","(Therms)","(kWh)","(kWh)","(Therms)","(Therms)"]
[null,null,null,null,null,null,"E - Electric",null,"(use 84 as default)","(total number of guest rooms)",null,null,null,"(IEER)"]
[null,null,null,null,null,"(°F) ","G - Gas","(°F) "]
[null,"N",{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,MeasureCode_Lookup,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($C$13=\"\",$K$13=\"\",A20=\"\",AND(C20=\"O\",OR(AND($K$13<>\"Dormitory\",$K$13<>\"Hospital\",$K$13<>\"Lodging – Hotel\",$K$13<>\"Lodging – Motel\")=TRUE,F20=\"\",G20=\"\",H20=\"\",I20=\"\", J20=\"\",AND($C$13=\"New Construction\",J20>50)=TRUE)=TRUE)=TRUE,K20=\"\",M20=\"\",AND(OR(C20=\"S\",C20=\"P\", C20=\"S/P\",C20=\"D\",C20=\"AP\",C20=\"AS\")=TRUE,K20>=65000,N20=\"\")=TRUE,AND(OR(C20=\"AP\",C20=\"AS\",C20=\"W\",C20=\"PTHP\",C20=\"PVHP\",C20=\"O\")=TRUE,OR(O20=\"\",P20=\"\")=TRUE)=TRUE)=TRUE,0,IF(OR(K20<VLOOKUP(A20,MeasureCode_Lookup,4,FALSE),K20>VLOOKUP(A20,MeasureCode_Lookup,5,FALSE),M20<IF(VLOOKUP(A20,MeasureCode_Lookup,IF(L20=\"Yes\",27,11),FALSE)=\"N/A\",N(VLOOKUP(A20,MeasureCode_Lookup,IF($C$13=\"Existing Building\",15,16),FALSE)),N(VLOOKUP(A20,MeasureCode_Lookup,IF(L20=\"Yes\",27,IF($C$13=\"Existing Building\",11,12)),FALSE))),N20<N(VLOOKUP(A20,MeasureCode_Lookup,IF($C$13=\"Existing Building\",17,18),FALSE)),P20<IF(VLOOKUP(A20,MeasureCode_Lookup,IF(L20=\"Yes\",28,13),FALSE)=\"N/A\",N(VLOOKUP(A20,MeasureCode_Lookup,IF($C$13=\"Existing Building\",19,20),FALSE)),N(VLOOKUP(A20,MeasureCode_Lookup,IF(L20=\"Yes\",28,IF($C$13=\"Existing Building\",13,14)),FALSE))))=TRUE,0,ROUND(VLOOKUP(A20,MeasureCode_Lookup,IF($C$13=\"Existing Building\",21,22),FALSE)*IF(OR(C20=\"E\",C20=\"O\")=TRUE,1,K20/12000),2)))","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$C$10=TRUE,$C$11=TRUE,$D$10=TRUE,$D$11=TRUE)=TRUE,S20,0)","v":0},{"$f":"IF(S20=0,0,Q20*(S20+T20))","v":0},{"$f":"IF(S20=0,0,R20*(S20+T20))","v":0},{"$f":"IF(S20=0,\"\",IF(L20=\"Yes\",VLOOKUP(A20,MeasureCode_Lookup,25,FALSE),\"\"))","v":""},{"$f":"IF(S20=0,\"\",IF(L20=\"Yes\",VLOOKUP(A20,MeasureCode_Lookup,26,FALSE),\"\"))","v":""},{"$f":"IF(S20=0,\"\",IF(OR(C20=\"O\",C20=\"E\")=TRUE,\"N/A\",\nIF(OR(C20=\"PTAC\",C20=\"PTHP\")=TRUE,IF(ISNUMBER(VLOOKUP(A20,MeasureCode_Lookup,8,FALSE)),VLOOKUP(A20,MeasureCode_Lookup,8,FALSE),14-(0.3*K20/1000)),\nIF(VLOOKUP(A20,MeasureCode_Lookup,6,FALSE)=\"N/A\",VLOOKUP(A20,MeasureCode_Lookup,8,FALSE),VLOOKUP(A20,MeasureCode_Lookup,6,FALSE)))))","v":""},{"$f":"IF(S20=0,\"\",IF(OR(C20=\"O\",C20=\"E\")=TRUE,\"N/A\",VLOOKUP(A20,MeasureCode_Lookup,9,FALSE)))","v":""},{"$f":"IF(S20=0,\"\",IF(OR(C20=\"O\",C20=\"E\")=TRUE,\"N/A\",\nIF(C20=\"PTHP\",IF(ISNUMBER(VLOOKUP(A20,MeasureCode_Lookup,10,FALSE)),VLOOKUP(A20,MeasureCode_Lookup,10,FALSE),3.7-(0.052*O20/1000)),\nIF(VLOOKUP(A20,MeasureCode_Lookup,7,FALSE)=\"N/A\",VLOOKUP(A20,MeasureCode_Lookup,10,FALSE),VLOOKUP(A20,MeasureCode_Lookup,7,FALSE)))))","v":""},{"$f":"IF(S20=0,0,IF(OR(C20=\"O\",C20=\"E\")=TRUE,0,(K20/1000)*((1/IF(ISNUMBER(W20),W20,Y20))-(1/M20))*0.5))","v":0},{"$f":"IF(S20=0,0,IF(C20=\"O\",(((H20*(I20+5)+(H20+5)*(168-(I20+5)))/168)-H20)*(0.06*K20/1000/M20),IF(C20=\"E\",(K20*0.13)/(M20*1000),(K20/1000)*IF(Z20<>\"N/A\",1/Z20-1/N20,((1/IF(ISNUMBER(W20),W20,Y20))-(1/M20)))))*VLOOKUP($K$13,EFLH_Lookup,3,FALSE))","v":0},{"$f":"IF(S20=0,0,IF(C20=\"O\",IF(G20<>\"E\",0,(F20-(F20*(I20+5)+(F20-5)*(168-(I20+5)))/168)*(0.03*O20/1000/(P20*IF(K20<65000,1,3.412)))),IF(C20=\"E\",0,IF(OR(C20=\"AS\",C20=\"AP\",C20=\"W\",C20=\"PTHP\",C20=\"PVHP\")=TRUE,(O20/1000)*((1/(IF(ISNUMBER(X20),X20,AA20)*IF(K20<65000,1,3.412)))-(1/(P20*IF(K20<65000,1,3.412)))),0)))*VLOOKUP($K$13,EFLH_Lookup,2,FALSE))","v":0},{"$f":"IF(S20=0,0,AC20+AD20)","v":0},{"$f":"IF(S20=0,0,IF(C20=\"O\",IF(G20<>\"G\",0,(F20-(F20*(I20+5)+(F20-5)*(168-(I20+5)))/168)*(0.03*O20*VLOOKUP($K$13,EFLH_Lookup,2,FALSE)/P20/100000)),0))","v":0},{"$f":"IF(S20=0,0,Q20*AB20)","v":0},{"$f":"IF(S20=0,0,R20*AB20)","v":0},{"$f":"IF(S20=0,0,Q20*AE20)","v":0},{"$f":"IF(S20=0,0,R20*AE20)","v":0},{"$f":"IF(S20=0,0,Q20*AF20)","v":0},{"$f":"IF(S20=0,0,R20*AF20)","v":0},{"$f":"IF(S20=0,0,AI20*VLOOKUP(A20,MeasureCode_Lookup,23,FALSE))","v":0},{"$f":"IF(S20=0,0,AJ20*VLOOKUP(A20,MeasureCode_Lookup,23,FALSE))","v":0},{"$f":"IF(S20=0,0,AK20*VLOOKUP(A20,MeasureCode_Lookup,23,FALSE))","v":0},{"$f":"IF(S20=0,0,AL20*VLOOKUP(A20,MeasureCode_Lookup,23,FALSE))","v":0}]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$C$10=TRUE,$C$11=TRUE,$D$10=TRUE,$D$11=TRUE)=TRUE,S21,0)","v":0},{"$f":"IF(S21=0,0,Q21*(S21+T21))","v":0},{"$f":"IF(S21=0,0,R21*(S21+T21))","v":0},"","","",{"$f":"IF(S21=0,\"\",IF(OR(C21=\"O\",C21=\"E\")=TRUE,\"N/A\",VLOOKUP(A21,MeasureCode_Lookup,9,FALSE)))","v":""},"",{"$f":"IF(S21=0,0,IF(OR(C21=\"O\",C21=\"E\")=TRUE,0,(K21/1000)*((1/IF(ISNUMBER(W21),W21,Y21))-(1/M21))*0.5))","v":0},0,0,{"$f":"IF(S21=0,0,AC21+AD21)","v":0},0,{"$f":"IF(S21=0,0,Q21*AB21)","v":0},{"$f":"IF(S21=0,0,R21*AB21)","v":0},{"$f":"IF(S21=0,0,Q21*AE21)","v":0},{"$f":"IF(S21=0,0,R21*AE21)","v":0},{"$f":"IF(S21=0,0,Q21*AF21)","v":0},{"$f":"IF(S21=0,0,R21*AF21)","v":0},0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Measure Codes","index":1,"n_rows":69,"n_cols":28,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Type Abbreviation","System Type","Min Capacity (BTUh","Max Capacity (BTUh","Baseline SEER","Baseline HSPF","Baseline EER","Baseline IEER","Baseline COP","Min Qualifying SEER\nEB","Min Qualifying SEER\nNC","Min Qualifying HSPF\nEB","Min Qualifying HSPF\nNC","Min Qualifying EER\nEB","Min Qualifying EER\nNC","Min Qualifying IEER\nEB","Min Qualifying IEER\nNC","Min Qualifying COP\nEB","Min Qualifying COP\nNC","Incentive per Ton\nEB","Incentive per Ton\nNC","Measure Life","Tier","Baseline SEER2","Baseline HSPF2","Min Qualifying SEER2","Min Qualifying HSPF2"]
["HVAC1","S","Split System - S",1,64999,{"$f":"Y2/0.95","v":14.105263157894738},"N/A","N/A","N/A","N/A",14,15.2,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",92,92,15,1,13.4,{"$f":"IF(NOT(ISNUMBER(G2)),\"N/A\",\"\")","v":"N/A"},14.4,{"$f":"IF(NOT(ISNUMBER(N2)),\"N/A\",\"\")","v":"N/A"}]
["HVAC2","S","Split System - S",1,64999,{"$f":"Y3/0.95","v":14.105263157894738},"N/A","N/A","N/A","N/A",16,17.399999999999999,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",105,105,15,2,13.4,{"$f":"IF(NOT(ISNUMBER(G3)),\"N/A\",\"\")","v":"N/A"},16.5,{"$f":"IF(NOT(ISNUMBER(N3)),\"N/A\",\"\")","v":"N/A"}]
["HVAC3","P","Single Package - P",1,64999,14.105263157894738,"N/A","N/A","N/A","N/A",14.3,15.2,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",92,92,15,1,13.4,"N/A",14.4,"N/A"]
["HVAC4","P","Single Package - P",1,64999,14.105263157894738,"N/A","N/A","N/A","N/A",16,17.399999999999999,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",103,103,15,2,13.4,"N/A",16.5,"N/A"]
["HVAC5","S/P","Split System - S or Single Package - P",65000,134999,"N/A","N/A",11,14.6,"N/A","N/A","N/A","N/A","N/A",11.5,11.5,13,15,"N/A","N/A",73,73,15,1,{"$f":"IF(NOT(ISNUMBER(F6)),\"N/A\",\"\")","v":"N/A"},"N/A",{"$f":"IF(NOT(ISNUMBER(L6)),\"N/A\",\"\")","v":"N/A"},"N/A"]
["HVAC6","S/P","Split System - S or Single Package - P",65000,134999,"N/A","N/A",11,14.6,"N/A","N/A","N/A","N/A","N/A",12.5,12.5,14,16.100000000000001,"N/A","N/A",79,79,15,2,"N/A","N/A","N/A","N/A"]
["HVAC7","S/P","Split System - S or Single Package - P",135000,239999,"N/A","N/A",10.8,14,"N/A","N/A","N/A","N/A","N/A",11.5,11.5,12.4,14.2,"N/A","N/A",79,79,15,1,"N/A","N/A","N/A","N/A"]
["HVAC8","S/P","Split System - S or Single Package - P",135000,239999,"N/A","N/A",10.8,14,"N/A","N/A","N/A","N/A","N/A",12,12,14,16.100000000000001,"N/A","N/A",89,89,15,2,"N/A","N/A","N/A","N/A"]
["HVAC9","D","Central DX AC - D",240000,759999,"N/A","N/A",9.8000000000000007,13,"N/A","N/A","N/A","N/A","N/A",10.5,10.5,11.6,13.2,"N/A","N/A",79,79,15,1,"N/A","N/A","N/A","N/A"]
["HVAC10","D","Central DX AC - D",240000,759999,"N/A","N/A",9.8000000000000007,13,"N/A","N/A","N/A","N/A","N/A",11,11,12.5,14.2,"N/A","N/A",85,85,15,2,"N/A","N/A","N/A","N/A"]
["HVAC11","D","Central DX AC - D",760000,999999999,"N/A","N/A",9.5,12.3,"N/A","N/A","N/A","N/A","N/A",9.6999999999999993,9.6999999999999993,11.2,12.5,"N/A","N/A",72,72,15,1,"N/A","N/A","N/A","N/A"]
["HVAC12","D","Central DX AC - D",760000,999999999,"N/A","N/A",9.5,12.3,"N/A","N/A","N/A","N/A","N/A",10,10,12,13.4,"N/A","N/A",77,77,15,2,"N/A","N/A","N/A","N/A"]
["HVAC13","AS","Air Source Heat Pump (Split System) - AS",1,64999,{"$f":"Y14/0.95","v":15.05263157894737},{"$f":"Z14/0.85","v":8.8235294117647065},"N/A","N/A","N/A",14.3,15.4,8.4,9.1,"N/A","N/A","N/A","N/A","N/A","N/A",92,92,15,1,14.3,7.5,14.6,7.7]
["HVAC14","AS","Air Source Heat Pump (Split System) - AS",1,64999,15.05263157894737,{"$f":"Z15/0.85","v":8.8235294117647065},"N/A","N/A","N/A",15.5,16.600000000000001,8.5,9.1999999999999993,"N/A","N/A","N/A","N/A","N/A","N/A",100,100,15,2,14.3,7.5,15.8,7.8]
["HVAC15","AP","Air Source Heat Pump (Single Package) - AP",1,64999,14.105263157894738,7.882352941176471,"N/A","N/A","N/A",14.3,14.4,8.1999999999999993,8.1999999999999993,"N/A","N/A","N/A","N/A","N/A","N/A",92,92,15,1,13.4,6.7,13.7,6.9]
["HVAC16","AP","Air Source Heat Pump (Single Package) - AP",1,64999,14.105263157894738,7.882352941176471,"N/A","N/A","N/A",15.5,15.6,8.5,8.5,"N/A","N/A","N/A","N/A","N/A","N/A",100,100,15,2,13.4,6.7,14.8,7.1]
["HVAC17","AS","Air Source Heat Pump (Split System) - AS",65000,134999,"N/A","N/A",10.8,13.9,3.4,"N/A","N/A","N/A","N/A",11.5,11.5,12.2,14.1,3.4,3.5,73,73,15,1,{"$f":"IF(NOT(ISNUMBER(F18)),\"N/A\",\"\")","v":"N/A"},{"$f":"IF(NOT(ISNUMBER(G18)),\"N/A\",\"\")","v":"N/A"},"N/A","N/A"]
["HVAC18","AS","Air Source Heat Pump (Split System) - AS",65000,134999,"N/A","N/A",10.8,13.9,3.4,"N/A","N/A","N/A","N/A",12.1,12.1,12.8,14.8,3.5,3.6,77,77,15,2,"N/A","N/A","N/A","N/A"]
["HVAC19","AS","Air Source Heat Pump (Split System) - AS",135000,239999,"N/A","N/A",10.4,13.3,3.3,"N/A","N/A","N/A","N/A",11.5,11.5,11.6,13.5,3.3,3.4,79,79,15,1,"N/A","N/A","N/A","N/A"]
["HVAC20","AS","Air Source Heat Pump (Split System) - AS",135000,239999,"N/A","N/A",10.4,13.3,3.3,"N/A","N/A","N/A","N/A",11.7,11.7,15,15,3.3,3.4,82,82,15,2,"N/A","N/A","N/A","N/A"]
["HVAC21","AS","Air Source Heat Pump (Split System) - AS",240000,999999999,"N/A","N/A",9.3000000000000007,12.3,3.2,"N/A","N/A","N/A","N/A",9.5,9.5,10.6,12.5,3.2,3.3,78,79,15,1,"N/A","N/A","N/A","N/A"]
["HVAC22","AS","Air Source Heat Pump (Split System) - AS",240000,999999999,"N/A","N/A",9.3000000000000007,12.3,3.2,"N/A","N/A","N/A","N/A",9.6999999999999993,9.6999999999999993,12,14.2,3.2,3.3,82,82,15,2,"N/A","N/A","N/A","N/A"]
["HVAC23","AP","Air Source Heat Pump (Single Package) - AP",65000,134999,"N/A","N/A",10.8,13.9,3.4,"N/A","N/A","N/A","N/A",11.5,11.5,12.2,14.1,3.4,3.5,73,73,15,1,"N/A","N/A","N/A","N/A"]
["HVAC24","AP","Air Source Heat Pump (Single Package) - AP",65000,134999,"N/A","N/A",10.8,13.9,3.4,"N/A","N/A","N/A","N/A",12.1,12.1,12.8,14.8,3.5,3.6,77,77,15,2,"N/A","N/A","N/A","N/A"]
["HVAC25","AP","Air Source Heat Pump (Single Package) - AP",135000,239999,"N/A","N/A",10.4,13.3,3.3,"N/A","N/A","N/A","N/A",11.5,11.5,11.6,13.5,3.3,3.4,79,79,15,1,"N/A","N/A","N/A","N/A"]
["HVAC26","AP","Air Source Heat Pump (Single Package) - AP",135000,239999,"N/A","N/A",10.4,13.3,3.3,"N/A","N/A","N/A","N/A",11.7,11.7,15,15,3.3,3.4,82,82,15,2,"N/A","N/A","N/A","N/A"]
["HVAC27","AP","Air Source Heat Pump (Single Package) - AP",240000,999999999,"N/A","N/A",9.3000000000000007,12.3,3.2,"N/A","N/A","N/A","N/A",9.5,9.5,10.6,12.5,3.2,3.3,79,79,15,1,"N/A","N/A","N/A","N/A"]
["HVAC28","AP","Air Source Heat Pump (Single Package) - AP",240000,999999999,"N/A","N/A",9.3000000000000007,12.3,3.2,"N/A","N/A","N/A","N/A",9.6999999999999993,9.6999999999999993,12,14.2,3.2,3.3,82,82,15,2,"N/A","N/A","N/A","N/A"]
["HVAC29","W","Water Source Heat Pump - W",1,16999,"N/A","N/A",12.2,"N/A",4.3,"N/A","N/A","N/A","N/A",12.4,12.4,"N/A","N/A",4.3,4.3,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC30","W","Water Source Heat Pump - W",1,16999,"N/A","N/A",12.2,"N/A",4.3,"N/A","N/A","N/A","N/A",14,14,"N/A","N/A",4.8,4.8,45,23,15,2,"N/A","N/A","N/A","N/A"]
["HVAC31","W","Water Source Heat Pump - W",17000,64999,"N/A","N/A",13,"N/A",4.3,"N/A","N/A","N/A","N/A",13.3,13.3,"N/A","N/A",4.3,4.3,60,30,15,1,"N/A","N/A","N/A","N/A"]
["HVAC32","W","Water Source Heat Pump - W",17000,64999,"N/A","N/A",13,"N/A",4.3,"N/A","N/A","N/A","N/A",15,15,"N/A","N/A",4.5,4.5,68,34,15,2,"N/A","N/A","N/A","N/A"]
["HVAC33","W","Water Source Heat Pump - W",65000,134999,"N/A","N/A",13,"N/A",4.3,"N/A","N/A","N/A","N/A",13.3,13.3,"N/A","N/A",4.3,4.3,80,40,15,1,"N/A",{"$f":"IF(NOT(ISNUMBER(G34)),\"N/A\",\"\")","v":"N/A"},"N/A","N/A"]
["HVAC34","W","Water Source Heat Pump - W",65000,134999,"N/A","N/A",13,"N/A",4.3,"N/A","N/A","N/A","N/A",15,15,"N/A","N/A",4.5,4.5,90,45,15,2,"N/A","N/A","N/A","N/A"]
["HVAC35","PTAC","Packaged Terminal AC - PTAC",1,6999,"N/A","N/A",11.9,"N/A","N/A","N/A","N/A","N/A","N/A",12,12,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC36","PTAC","Packaged Terminal AC - PTAC",7000,7999,"N/A","N/A","Calc","N/A","N/A","N/A","N/A","N/A","N/A",12,12,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC37","PTAC","Packaged Terminal AC - PTAC",8000,8999,"N/A","N/A","Calc","N/A","N/A","N/A","N/A","N/A","N/A",11.7,11.7,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC38","PTAC","Packaged Terminal AC - PTAC",9000,9999,"N/A","N/A","Calc","N/A","N/A","N/A","N/A","N/A","N/A",11.4,11.4,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC39","PTAC","Packaged Terminal AC - PTAC",10000,10999,"N/A","N/A","Calc","N/A","N/A","N/A","N/A","N/A","N/A",11.1,11.1,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC40","PTAC","Packaged Terminal AC - PTAC",11000,11999,"N/A","N/A","Calc","N/A","N/A","N/A","N/A","N/A","N/A",10.8,10.8,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC41","PTAC","Packaged Terminal AC - PTAC",12000,12999,"N/A","N/A","Calc","N/A","N/A","N/A","N/A","N/A","N/A",10.5,10.5,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC42","PTAC","Packaged Terminal AC - PTAC",13000,13999,"N/A","N/A","Calc","N/A","N/A","N/A","N/A","N/A","N/A",10.199999999999999,10.199999999999999,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC43","PTAC","Packaged Terminal AC - PTAC",14000,14999,"N/A","N/A","Calc","N/A","N/A","N/A","N/A","N/A","N/A",9.9,9.9,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC44","PTAC","Packaged Terminal AC - PTAC",15000,999999999,"N/A","N/A",9.5,"N/A","N/A","N/A","N/A","N/A","N/A",9.6,9.6,"N/A","N/A","N/A","N/A",40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC45","PTHP","Packaged Terminal HP - PTHP",1,6999,"N/A","N/A",11.9,"N/A",3.3,"N/A","N/A","N/A","N/A",12,12,"N/A","N/A",3.4,3.4,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC46","PTHP","Packaged Terminal HP - PTHP",7000,7999,"N/A","N/A","Calc","N/A","Calc","N/A","N/A","N/A","N/A",12,12,"N/A","N/A",3.4,3.4,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC47","PTHP","Packaged Terminal HP - PTHP",8000,8999,"N/A","N/A","Calc","N/A","Calc","N/A","N/A","N/A","N/A",11.7,11.7,"N/A","N/A",3.3,3.3,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC48","PTHP","Packaged Terminal HP - PTHP",9000,9999,"N/A","N/A","Calc","N/A","Calc","N/A","N/A","N/A","N/A",11.4,11.4,"N/A","N/A",3.3,3.3,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC49","PTHP","Packaged Terminal HP - PTHP",10000,10999,"N/A","N/A","Calc","N/A","Calc","N/A","N/A","N/A","N/A",11.1,11.1,"N/A","N/A",3.2,3.2,40,20,15,1,{"$f":"IF(NOT(ISNUMBER(F50)),\"N/A\",\"\")","v":"N/A"},{"$f":"IF(NOT(ISNUMBER(G50)),\"N/A\",\"\")","v":"N/A"},"N/A","N/A"]
["HVAC50","PTHP","Packaged Terminal HP - PTHP",11000,11999,"N/A","N/A","Calc","N/A","Calc","N/A","N/A","N/A","N/A",10.8,10.8,"N/A","N/A",3.2,3.2,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC51","PTHP","Packaged Terminal HP - PTHP",12000,12999,"N/A","N/A","Calc","N/A","Calc","N/A","N/A","N/A","N/A",10.5,10.5,"N/A","N/A",3.1,3.1,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC52","PTHP","Packaged Terminal HP - PTHP",13000,13999,"N/A","N/A","Calc","N/A","Calc","N/A","N/A","N/A","N/A",10.199999999999999,10.199999999999999,"N/A","N/A",3.1,3.1,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC53","PTHP","Packaged Terminal HP - PTHP",14000,14999,"N/A","N/A","Calc","N/A","Calc","N/A","N/A","N/A","N/A",9.9,9.9,"N/A","N/A",3,3,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC54","PTHP","Packaged Terminal HP - PTHP",15000,999999999,"N/A","N/A",9.5,"N/A",2.9,"N/A","N/A","N/A","N/A",9.6,9.6,"N/A","N/A",3,3,40,20,15,1,"N/A","N/A","N/A","N/A"]
["HVAC55","PVAC","Single Packaged Vertical AC - PVAC",1,64999,"N/A","N/A",11,"N/A","N/A","N/A","N/A","N/A","N/A",10.199999999999999,11.2,"N/A","N/A","N/A","N/A",45,10,15,1,"N/A","N/A","N/A","N/A"]
["HVAC56","PVAC","Single Packaged Vertical AC - PVAC",1,64999,"N/A","N/A",11,"N/A","N/A","N/A","N/A","N/A","N/A",10.7,11.8,"N/A","N/A","N/A","N/A",47,12,15,2,"N/A","N/A","N/A","N/A"]
["HVAC57","PVAC","Single Packaged Vertical AC - PVAC",65000,134999,"N/A","N/A",10,"N/A","N/A","N/A","N/A","N/A","N/A",10.199999999999999,10.199999999999999,"N/A","N/A","N/A","N/A",45,10,15,1,"N/A","N/A","N/A","N/A"]
["HVAC58","PVAC","Single Packaged Vertical AC - PVAC",65000,134999,"N/A","N/A",10,"N/A","N/A","N/A","N/A","N/A","N/A",10.7,10.7,"N/A","N/A","N/A","N/A",47,12,15,2,"N/A","N/A","N/A","N/A"]
["HVAC59","PVAC","Single Packaged Vertical AC - PVAC",135000,239999,"N/A","N/A",10,"N/A","N/A","N/A","N/A","N/A","N/A",10.199999999999999,10.199999999999999,"N/A","N/A","N/A","N/A",45,10,15,1,"N/A","N/A","N/A","N/A"]
["HVAC60","PVAC","Single Packaged Vertical AC - PVAC",135000,239999,"N/A","N/A",10,"N/A","N/A","N/A","N/A","N/A","N/A",10.7,10.7,"N/A","N/A","N/A","N/A",47,12,15,2,"N/A","N/A","N/A","N/A"]
["HVAC61","PVHP","Single Packaged Vertical HP - PVHP",1,64999,"N/A","N/A",11,"N/A",3.3,"N/A","N/A","N/A","N/A",10.199999999999999,11.2,"N/A","N/A",3.1,3.4,45,10,15,1,"N/A","N/A","N/A","N/A"]
["HVAC62","PVHP","Single Packaged Vertical HP - PVHP",1,64999,"N/A","N/A",11,"N/A",3.3,"N/A","N/A","N/A","N/A",10.7,11.8,"N/A","N/A",3.2,3.5,47,12,15,2,"N/A","N/A","N/A","N/A"]
["HVAC63","PVHP","Single Packaged Vertical HP - PVHP",65000,134999,"N/A","N/A",10,"N/A",3,"N/A","N/A","N/A","N/A",10.199999999999999,10.199999999999999,"N/A","N/A",3.1,3.1,45,10,15,1,"N/A","N/A","N/A","N/A"]
["HVAC64","PVHP","Single Packaged Vertical HP - PVHP",65000,134999,"N/A","N/A",10,"N/A",3,"N/A","N/A","N/A","N/A",10.7,10.7,"N/A","N/A",3.2,3.2,47,12,15,2,"N/A","N/A","N/A","N/A"]
["HVAC65","PVHP","Single Packaged Vertical HP - PVHP",135000,239999,"N/A","N/A",10,"N/A",3,"N/A","N/A","N/A","N/A",10.199999999999999,10.199999999999999,"N/A","N/A",3.1,3.1,45,10,15,1,"N/A",{"$f":"IF(NOT(ISNUMBER(G66)),\"N/A\",\"\")","v":"N/A"},"N/A","N/A"]
["HVAC66","PVHP","Single Packaged Vertical HP - PVHP",135000,239999,"N/A","N/A",10,"N/A",3,"N/A","N/A","N/A","N/A",10.7,10.7,"N/A","N/A",3.2,3.2,47,12,15,2,"N/A","N/A",{"$f":"IF(NOT(ISNUMBER(L67)),\"N/A\",\"\")","v":"N/A"},{"$f":"IF(NOT(ISNUMBER(N67)),\"N/A\",\"\")","v":"N/A"}]
["HVAC67","O","Occupancy Controlled Thermostats",0,999999999,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",75,75,11,"N/A","N/A","N/A","N/A","N/A"]
["HVAC68","E","A/C Economizing Controls",1,53999,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",85,85,15,"N/A","N/A","N/A","N/A","N/A"]

{"sheet":"Table","index":2,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Facility Type","Heating EFLHh","Cooling EFLHc"]
["Assembly",603,669]
["Auto repair",1910,426]
["Dormitory",465,800]
["Hospital",3366,1424]
["Light industrial",714,549]
["Lodging – Hotel",1077,2918]
["Lodging – Motel",619,1233]
["Office – large",2034,720]
["Office – small",431,955]
["Other",681,736]
["Religious worship",722,279]
["Restaurant – fast food",813,645]
["Restaurant – full service",821,574]
["Retail – big box",191,1279]
["Retail – Grocery",191,1279]
["Retail – small",545,882]
["Retail – large",2101,1068]
["School – Community college",1431,846]
["School – postsecondary",1191,1208]
["School – primary",840,394]
["School – secondary",901,466]
["Warehouse",452,400]
["Multifamily: Low-rise, Prior to 1979",757,507]
["Multifamily: Low-rise, From 1979 to 2006",723,550]
["Multifamily: Low-rise, From 2007 through present",503,562]
["Multifamily: High-rise, Prior to 1979",526,793]
["Multifamily: High-rise, From 1979 to 2006",395,843]
["Multifamily: High-rise, From 2007 through present",219,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(Worksheet!S20=0,\"\",IF(OR(Worksheet!C20=\"AS\",Worksheet!C20=\"AP\")=TRUE,74,IF(Worksheet!C20=\"E\",340,IF(Worksheet!C20=\"D\",77,IF(OR(Worksheet!C20=\"PTAC\",Worksheet!C20=\"PTHP\")=TRUE,75,IF(Worksheet!C20=\"W\",78,IF(Worksheet!C20=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D20)=FALSE,Worksheet!D20,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E20)=FALSE,Worksheet!E20,\"\")","v":""},{"$f":"Worksheet!K20","v":0},"Btuh",{"$f":"IF(Worksheet!K20>=65000,Worksheet!M20,\"\")","v":""},{"$f":"IF(Worksheet!K20<65000,Worksheet!M20,\"\")","v":0},{"$f":"Worksheet!S20","v":0},{"$f":"IF(ISBLANK(Worksheet!Q20)=FALSE,Worksheet!Q20,\"\")","v":""},{"$f":"Worksheet!AE20","v":0},{"$f":"Worksheet!AB20","v":0},{"$f":"IFERROR(Worksheet!AM20/I2,\"\")","v":""},{"$f":"IF(ISBLANK($I2),\"\",IFERROR(Worksheet!AK20/$I2,\"\"))","v":""},{"$f":"IF(ISBLANK($I2),\"\",IFERROR(Worksheet!AO20/$I2,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R20)=FALSE,Worksheet!R20,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T20,\"\")","v":0}]
[{"$f":"IF(Worksheet!S21=0,\"\",IF(OR(Worksheet!C21=\"AS\",Worksheet!C21=\"AP\")=TRUE,74,IF(Worksheet!C21=\"E\",340,IF(Worksheet!C21=\"D\",77,IF(OR(Worksheet!C21=\"PTAC\",Worksheet!C21=\"PTHP\")=TRUE,75,IF(Worksheet!C21=\"W\",78,IF(Worksheet!C21=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D21)=FALSE,Worksheet!D21,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E21)=FALSE,Worksheet!E21,\"\")","v":""},{"$f":"Worksheet!K21","v":0},"Btuh",{"$f":"IF(Worksheet!K21>=65000,Worksheet!M21,\"\")","v":""},{"$f":"IF(Worksheet!K21<65000,Worksheet!M21,\"\")","v":0},{"$f":"Worksheet!S21","v":0},{"$f":"IF(ISBLANK(Worksheet!Q21)=FALSE,Worksheet!Q21,\"\")","v":""},{"$f":"Worksheet!AE21","v":0},{"$f":"Worksheet!AB21","v":0},{"$f":"IFERROR(Worksheet!AM21/I3,\"\")","v":""},{"$f":"IF(ISBLANK($I3),\"\",IFERROR(Worksheet!AK21/$I3,\"\"))","v":""},{"$f":"IF(ISBLANK($I3),\"\",IFERROR(Worksheet!AO21/$I3,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R21)=FALSE,Worksheet!R21,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T21,\"\")","v":0}]
[{"$f":"IF(Worksheet!S22=0,\"\",IF(OR(Worksheet!C22=\"AS\",Worksheet!C22=\"AP\")=TRUE,74,IF(Worksheet!C22=\"E\",340,IF(Worksheet!C22=\"D\",77,IF(OR(Worksheet!C22=\"PTAC\",Worksheet!C22=\"PTHP\")=TRUE,75,IF(Worksheet!C22=\"W\",78,IF(Worksheet!C22=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D22)=FALSE,Worksheet!D22,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E22)=FALSE,Worksheet!E22,\"\")","v":""},{"$f":"Worksheet!K22","v":0},"Btuh",{"$f":"IF(Worksheet!K22>=65000,Worksheet!M22,\"\")","v":""},{"$f":"IF(Worksheet!K22<65000,Worksheet!M22,\"\")","v":0},{"$f":"Worksheet!S22","v":0},{"$f":"IF(ISBLANK(Worksheet!Q22)=FALSE,Worksheet!Q22,\"\")","v":""},{"$f":"Worksheet!AE22","v":0},{"$f":"Worksheet!AB22","v":0},{"$f":"IFERROR(Worksheet!AM22/I4,\"\")","v":""},{"$f":"IF(ISBLANK($I4),\"\",IFERROR(Worksheet!AK22/$I4,\"\"))","v":""},{"$f":"IF(ISBLANK($I4),\"\",IFERROR(Worksheet!AO22/$I4,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R22)=FALSE,Worksheet!R22,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T22,\"\")","v":0}]
[{"$f":"IF(Worksheet!S23=0,\"\",IF(OR(Worksheet!C23=\"AS\",Worksheet!C23=\"AP\")=TRUE,74,IF(Worksheet!C23=\"E\",340,IF(Worksheet!C23=\"D\",77,IF(OR(Worksheet!C23=\"PTAC\",Worksheet!C23=\"PTHP\")=TRUE,75,IF(Worksheet!C23=\"W\",78,IF(Worksheet!C23=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D23)=FALSE,Worksheet!D23,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E23)=FALSE,Worksheet!E23,\"\")","v":""},{"$f":"Worksheet!K23","v":0},"Btuh",{"$f":"IF(Worksheet!K23>=65000,Worksheet!M23,\"\")","v":""},{"$f":"IF(Worksheet!K23<65000,Worksheet!M23,\"\")","v":0},{"$f":"Worksheet!S23","v":0},{"$f":"IF(ISBLANK(Worksheet!Q23)=FALSE,Worksheet!Q23,\"\")","v":""},{"$f":"Worksheet!AE23","v":0},{"$f":"Worksheet!AB23","v":0},{"$f":"IFERROR(Worksheet!AM23/I5,\"\")","v":""},{"$f":"IF(ISBLANK($I5),\"\",IFERROR(Worksheet!AK23/$I5,\"\"))","v":""},{"$f":"IF(ISBLANK($I5),\"\",IFERROR(Worksheet!AO23/$I5,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R23)=FALSE,Worksheet!R23,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T23,\"\")","v":0}]
[{"$f":"IF(Worksheet!S24=0,\"\",IF(OR(Worksheet!C24=\"AS\",Worksheet!C24=\"AP\")=TRUE,74,IF(Worksheet!C24=\"E\",340,IF(Worksheet!C24=\"D\",77,IF(OR(Worksheet!C24=\"PTAC\",Worksheet!C24=\"PTHP\")=TRUE,75,IF(Worksheet!C24=\"W\",78,IF(Worksheet!C24=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D24)=FALSE,Worksheet!D24,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E24)=FALSE,Worksheet!E24,\"\")","v":""},{"$f":"Worksheet!K24","v":0},"Btuh",{"$f":"IF(Worksheet!K24>=65000,Worksheet!M24,\"\")","v":""},{"$f":"IF(Worksheet!K24<65000,Worksheet!M24,\"\")","v":0},{"$f":"Worksheet!S24","v":0},{"$f":"IF(ISBLANK(Worksheet!Q24)=FALSE,Worksheet!Q24,\"\")","v":""},{"$f":"Worksheet!AE24","v":0},{"$f":"Worksheet!AB24","v":0},{"$f":"IFERROR(Worksheet!AM24/I6,\"\")","v":""},{"$f":"IF(ISBLANK($I6),\"\",IFERROR(Worksheet!AK24/$I6,\"\"))","v":""},{"$f":"IF(ISBLANK($I6),\"\",IFERROR(Worksheet!AO24/$I6,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R24)=FALSE,Worksheet!R24,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T24,\"\")","v":0}]
[{"$f":"IF(Worksheet!S25=0,\"\",IF(OR(Worksheet!C25=\"AS\",Worksheet!C25=\"AP\")=TRUE,74,IF(Worksheet!C25=\"E\",340,IF(Worksheet!C25=\"D\",77,IF(OR(Worksheet!C25=\"PTAC\",Worksheet!C25=\"PTHP\")=TRUE,75,IF(Worksheet!C25=\"W\",78,IF(Worksheet!C25=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D25)=FALSE,Worksheet!D25,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E25)=FALSE,Worksheet!E25,\"\")","v":""},{"$f":"Worksheet!K25","v":0},"Btuh",{"$f":"IF(Worksheet!K25>=65000,Worksheet!M25,\"\")","v":""},{"$f":"IF(Worksheet!K25<65000,Worksheet!M25,\"\")","v":0},{"$f":"Worksheet!S25","v":0},{"$f":"IF(ISBLANK(Worksheet!Q25)=FALSE,Worksheet!Q25,\"\")","v":""},{"$f":"Worksheet!AE25","v":0},{"$f":"Worksheet!AB25","v":0},{"$f":"IFERROR(Worksheet!AM25/I7,\"\")","v":""},{"$f":"IF(ISBLANK($I7),\"\",IFERROR(Worksheet!AK25/$I7,\"\"))","v":""},{"$f":"IF(ISBLANK($I7),\"\",IFERROR(Worksheet!AO25/$I7,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R25)=FALSE,Worksheet!R25,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T25,\"\")","v":0}]
[{"$f":"IF(Worksheet!S26=0,\"\",IF(OR(Worksheet!C26=\"AS\",Worksheet!C26=\"AP\")=TRUE,74,IF(Worksheet!C26=\"E\",340,IF(Worksheet!C26=\"D\",77,IF(OR(Worksheet!C26=\"PTAC\",Worksheet!C26=\"PTHP\")=TRUE,75,IF(Worksheet!C26=\"W\",78,IF(Worksheet!C26=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D26)=FALSE,Worksheet!D26,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E26)=FALSE,Worksheet!E26,\"\")","v":""},{"$f":"Worksheet!K26","v":0},"Btuh",{"$f":"IF(Worksheet!K26>=65000,Worksheet!M26,\"\")","v":""},{"$f":"IF(Worksheet!K26<65000,Worksheet!M26,\"\")","v":0},{"$f":"Worksheet!S26","v":0},{"$f":"IF(ISBLANK(Worksheet!Q26)=FALSE,Worksheet!Q26,\"\")","v":""},{"$f":"Worksheet!AE26","v":0},{"$f":"Worksheet!AB26","v":0},{"$f":"IFERROR(Worksheet!AM26/I8,\"\")","v":""},{"$f":"IF(ISBLANK($I8),\"\",IFERROR(Worksheet!AK26/$I8,\"\"))","v":""},{"$f":"IF(ISBLANK($I8),\"\",IFERROR(Worksheet!AO26/$I8,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R26)=FALSE,Worksheet!R26,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T26,\"\")","v":0}]
[{"$f":"IF(Worksheet!S27=0,\"\",IF(OR(Worksheet!C27=\"AS\",Worksheet!C27=\"AP\")=TRUE,74,IF(Worksheet!C27=\"E\",340,IF(Worksheet!C27=\"D\",77,IF(OR(Worksheet!C27=\"PTAC\",Worksheet!C27=\"PTHP\")=TRUE,75,IF(Worksheet!C27=\"W\",78,IF(Worksheet!C27=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D27)=FALSE,Worksheet!D27,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E27)=FALSE,Worksheet!E27,\"\")","v":""},{"$f":"Worksheet!K27","v":0},"Btuh",{"$f":"IF(Worksheet!K27>=65000,Worksheet!M27,\"\")","v":""},{"$f":"IF(Worksheet!K27<65000,Worksheet!M27,\"\")","v":0},{"$f":"Worksheet!S27","v":0},{"$f":"IF(ISBLANK(Worksheet!Q27)=FALSE,Worksheet!Q27,\"\")","v":""},{"$f":"Worksheet!AE27","v":0},{"$f":"Worksheet!AB27","v":0},{"$f":"IFERROR(Worksheet!AM27/I9,\"\")","v":""},{"$f":"IF(ISBLANK($I9),\"\",IFERROR(Worksheet!AK27/$I9,\"\"))","v":""},{"$f":"IF(ISBLANK($I9),\"\",IFERROR(Worksheet!AO27/$I9,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R27)=FALSE,Worksheet!R27,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T27,\"\")","v":0}]
[{"$f":"IF(Worksheet!S28=0,\"\",IF(OR(Worksheet!C28=\"AS\",Worksheet!C28=\"AP\")=TRUE,74,IF(Worksheet!C28=\"E\",340,IF(Worksheet!C28=\"D\",77,IF(OR(Worksheet!C28=\"PTAC\",Worksheet!C28=\"PTHP\")=TRUE,75,IF(Worksheet!C28=\"W\",78,IF(Worksheet!C28=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D28)=FALSE,Worksheet!D28,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E28)=FALSE,Worksheet!E28,\"\")","v":""},{"$f":"Worksheet!K28","v":0},"Btuh",{"$f":"IF(Worksheet!K28>=65000,Worksheet!M28,\"\")","v":""},{"$f":"IF(Worksheet!K28<65000,Worksheet!M28,\"\")","v":0},{"$f":"Worksheet!S28","v":0},{"$f":"IF(ISBLANK(Worksheet!Q28)=FALSE,Worksheet!Q28,\"\")","v":""},{"$f":"Worksheet!AE28","v":0},{"$f":"Worksheet!AB28","v":0},{"$f":"IFERROR(Worksheet!AM28/I10,\"\")","v":""},{"$f":"IF(ISBLANK($I10),\"\",IFERROR(Worksheet!AK28/$I10,\"\"))","v":""},{"$f":"IF(ISBLANK($I10),\"\",IFERROR(Worksheet!AO28/$I10,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R28)=FALSE,Worksheet!R28,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T28,\"\")","v":0}]
[{"$f":"IF(Worksheet!S29=0,\"\",IF(OR(Worksheet!C29=\"AS\",Worksheet!C29=\"AP\")=TRUE,74,IF(Worksheet!C29=\"E\",340,IF(Worksheet!C29=\"D\",77,IF(OR(Worksheet!C29=\"PTAC\",Worksheet!C29=\"PTHP\")=TRUE,75,IF(Worksheet!C29=\"W\",78,IF(Worksheet!C29=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D29)=FALSE,Worksheet!D29,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E29)=FALSE,Worksheet!E29,\"\")","v":""},{"$f":"Worksheet!K29","v":0},"Btuh",{"$f":"IF(Worksheet!K29>=65000,Worksheet!M29,\"\")","v":""},{"$f":"IF(Worksheet!K29<65000,Worksheet!M29,\"\")","v":0},{"$f":"Worksheet!S29","v":0},{"$f":"IF(ISBLANK(Worksheet!Q29)=FALSE,Worksheet!Q29,\"\")","v":""},{"$f":"Worksheet!AE29","v":0},{"$f":"Worksheet!AB29","v":0},{"$f":"IFERROR(Worksheet!AM29/I11,\"\")","v":""},{"$f":"IF(ISBLANK($I11),\"\",IFERROR(Worksheet!AK29/$I11,\"\"))","v":""},{"$f":"IF(ISBLANK($I11),\"\",IFERROR(Worksheet!AO29/$I11,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R29)=FALSE,Worksheet!R29,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T29,\"\")","v":0}]
[{"$f":"IF(Worksheet!S30=0,\"\",IF(OR(Worksheet!C30=\"AS\",Worksheet!C30=\"AP\")=TRUE,74,IF(Worksheet!C30=\"E\",340,IF(Worksheet!C30=\"D\",77,IF(OR(Worksheet!C30=\"PTAC\",Worksheet!C30=\"PTHP\")=TRUE,75,IF(Worksheet!C30=\"W\",78,IF(Worksheet!C30=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D30)=FALSE,Worksheet!D30,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E30)=FALSE,Worksheet!E30,\"\")","v":""},{"$f":"Worksheet!K30","v":0},"Btuh",{"$f":"IF(Worksheet!K30>=65000,Worksheet!M30,\"\")","v":""},{"$f":"IF(Worksheet!K30<65000,Worksheet!M30,\"\")","v":0},{"$f":"Worksheet!S30","v":0},{"$f":"IF(ISBLANK(Worksheet!Q30)=FALSE,Worksheet!Q30,\"\")","v":""},{"$f":"Worksheet!AE30","v":0},{"$f":"Worksheet!AB30","v":0},{"$f":"IFERROR(Worksheet!AM30/I12,\"\")","v":""},{"$f":"IF(ISBLANK($I12),\"\",IFERROR(Worksheet!AK30/$I12,\"\"))","v":""},{"$f":"IF(ISBLANK($I12),\"\",IFERROR(Worksheet!AO30/$I12,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R30)=FALSE,Worksheet!R30,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T30,\"\")","v":0}]
[{"$f":"IF(Worksheet!S31=0,\"\",IF(OR(Worksheet!C31=\"AS\",Worksheet!C31=\"AP\")=TRUE,74,IF(Worksheet!C31=\"E\",340,IF(Worksheet!C31=\"D\",77,IF(OR(Worksheet!C31=\"PTAC\",Worksheet!C31=\"PTHP\")=TRUE,75,IF(Worksheet!C31=\"W\",78,IF(Worksheet!C31=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D31)=FALSE,Worksheet!D31,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E31)=FALSE,Worksheet!E31,\"\")","v":""},{"$f":"Worksheet!K31","v":0},"Btuh",{"$f":"IF(Worksheet!K31>=65000,Worksheet!M31,\"\")","v":""},{"$f":"IF(Worksheet!K31<65000,Worksheet!M31,\"\")","v":0},{"$f":"Worksheet!S31","v":0},{"$f":"IF(ISBLANK(Worksheet!Q31)=FALSE,Worksheet!Q31,\"\")","v":""},{"$f":"Worksheet!AE31","v":0},{"$f":"Worksheet!AB31","v":0},{"$f":"IFERROR(Worksheet!AM31/I13,\"\")","v":""},{"$f":"IF(ISBLANK($I13),\"\",IFERROR(Worksheet!AK31/$I13,\"\"))","v":""},{"$f":"IF(ISBLANK($I13),\"\",IFERROR(Worksheet!AO31/$I13,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R31)=FALSE,Worksheet!R31,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T31,\"\")","v":0}]
[{"$f":"IF(Worksheet!S32=0,\"\",IF(OR(Worksheet!C32=\"AS\",Worksheet!C32=\"AP\")=TRUE,74,IF(Worksheet!C32=\"E\",340,IF(Worksheet!C32=\"D\",77,IF(OR(Worksheet!C32=\"PTAC\",Worksheet!C32=\"PTHP\")=TRUE,75,IF(Worksheet!C32=\"W\",78,IF(Worksheet!C32=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D32)=FALSE,Worksheet!D32,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E32)=FALSE,Worksheet!E32,\"\")","v":""},{"$f":"Worksheet!K32","v":0},"Btuh",{"$f":"IF(Worksheet!K32>=65000,Worksheet!M32,\"\")","v":""},{"$f":"IF(Worksheet!K32<65000,Worksheet!M32,\"\")","v":0},{"$f":"Worksheet!S32","v":0},{"$f":"IF(ISBLANK(Worksheet!Q32)=FALSE,Worksheet!Q32,\"\")","v":""},{"$f":"Worksheet!AE32","v":0},{"$f":"Worksheet!AB32","v":0},{"$f":"IFERROR(Worksheet!AM32/I14,\"\")","v":""},{"$f":"IF(ISBLANK($I14),\"\",IFERROR(Worksheet!AK32/$I14,\"\"))","v":""},{"$f":"IF(ISBLANK($I14),\"\",IFERROR(Worksheet!AO32/$I14,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R32)=FALSE,Worksheet!R32,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T32,\"\")","v":0}]
[{"$f":"IF(Worksheet!S33=0,\"\",IF(OR(Worksheet!C33=\"AS\",Worksheet!C33=\"AP\")=TRUE,74,IF(Worksheet!C33=\"E\",340,IF(Worksheet!C33=\"D\",77,IF(OR(Worksheet!C33=\"PTAC\",Worksheet!C33=\"PTHP\")=TRUE,75,IF(Worksheet!C33=\"W\",78,IF(Worksheet!C33=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D33)=FALSE,Worksheet!D33,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E33)=FALSE,Worksheet!E33,\"\")","v":""},{"$f":"Worksheet!K33","v":0},"Btuh",{"$f":"IF(Worksheet!K33>=65000,Worksheet!M33,\"\")","v":""},{"$f":"IF(Worksheet!K33<65000,Worksheet!M33,\"\")","v":0},{"$f":"Worksheet!S33","v":0},{"$f":"IF(ISBLANK(Worksheet!Q33)=FALSE,Worksheet!Q33,\"\")","v":""},{"$f":"Worksheet!AE33","v":0},{"$f":"Worksheet!AB33","v":0},{"$f":"IFERROR(Worksheet!AM33/I15,\"\")","v":""},{"$f":"IF(ISBLANK($I15),\"\",IFERROR(Worksheet!AK33/$I15,\"\"))","v":""},{"$f":"IF(ISBLANK($I15),\"\",IFERROR(Worksheet!AO33/$I15,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R33)=FALSE,Worksheet!R33,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T33,\"\")","v":0}]
[{"$f":"IF(Worksheet!S34=0,\"\",IF(OR(Worksheet!C34=\"AS\",Worksheet!C34=\"AP\")=TRUE,74,IF(Worksheet!C34=\"E\",340,IF(Worksheet!C34=\"D\",77,IF(OR(Worksheet!C34=\"PTAC\",Worksheet!C34=\"PTHP\")=TRUE,75,IF(Worksheet!C34=\"W\",78,IF(Worksheet!C34=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D34)=FALSE,Worksheet!D34,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E34)=FALSE,Worksheet!E34,\"\")","v":""},{"$f":"Worksheet!K34","v":0},"Btuh",{"$f":"IF(Worksheet!K34>=65000,Worksheet!M34,\"\")","v":""},{"$f":"IF(Worksheet!K34<65000,Worksheet!M34,\"\")","v":0},{"$f":"Worksheet!S34","v":0},{"$f":"IF(ISBLANK(Worksheet!Q34)=FALSE,Worksheet!Q34,\"\")","v":""},{"$f":"Worksheet!AE34","v":0},{"$f":"Worksheet!AB34","v":0},{"$f":"IFERROR(Worksheet!AM34/I16,\"\")","v":""},{"$f":"IF(ISBLANK($I16),\"\",IFERROR(Worksheet!AK34/$I16,\"\"))","v":""},{"$f":"IF(ISBLANK($I16),\"\",IFERROR(Worksheet!AO34/$I16,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R34)=FALSE,Worksheet!R34,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T34,\"\")","v":0}]
[{"$f":"IF(Worksheet!S35=0,\"\",IF(OR(Worksheet!C35=\"AS\",Worksheet!C35=\"AP\")=TRUE,74,IF(Worksheet!C35=\"E\",340,IF(Worksheet!C35=\"D\",77,IF(OR(Worksheet!C35=\"PTAC\",Worksheet!C35=\"PTHP\")=TRUE,75,IF(Worksheet!C35=\"W\",78,IF(Worksheet!C35=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D35)=FALSE,Worksheet!D35,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E35)=FALSE,Worksheet!E35,\"\")","v":""},{"$f":"Worksheet!K35","v":0},"Btuh",{"$f":"IF(Worksheet!K35>=65000,Worksheet!M35,\"\")","v":""},{"$f":"IF(Worksheet!K35<65000,Worksheet!M35,\"\")","v":0},{"$f":"Worksheet!S35","v":0},{"$f":"IF(ISBLANK(Worksheet!Q35)=FALSE,Worksheet!Q35,\"\")","v":""},{"$f":"Worksheet!AE35","v":0},{"$f":"Worksheet!AB35","v":0},{"$f":"IFERROR(Worksheet!AM35/I17,\"\")","v":""},{"$f":"IF(ISBLANK($I17),\"\",IFERROR(Worksheet!AK35/$I17,\"\"))","v":""},{"$f":"IF(ISBLANK($I17),\"\",IFERROR(Worksheet!AO35/$I17,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R35)=FALSE,Worksheet!R35,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T35,\"\")","v":0}]
[{"$f":"IF(Worksheet!S36=0,\"\",IF(OR(Worksheet!C36=\"AS\",Worksheet!C36=\"AP\")=TRUE,74,IF(Worksheet!C36=\"E\",340,IF(Worksheet!C36=\"D\",77,IF(OR(Worksheet!C36=\"PTAC\",Worksheet!C36=\"PTHP\")=TRUE,75,IF(Worksheet!C36=\"W\",78,IF(Worksheet!C36=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D36)=FALSE,Worksheet!D36,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E36)=FALSE,Worksheet!E36,\"\")","v":""},{"$f":"Worksheet!K36","v":0},"Btuh",{"$f":"IF(Worksheet!K36>=65000,Worksheet!M36,\"\")","v":""},{"$f":"IF(Worksheet!K36<65000,Worksheet!M36,\"\")","v":0},{"$f":"Worksheet!S36","v":0},{"$f":"IF(ISBLANK(Worksheet!Q36)=FALSE,Worksheet!Q36,\"\")","v":""},{"$f":"Worksheet!AE36","v":0},{"$f":"Worksheet!AB36","v":0},{"$f":"IFERROR(Worksheet!AM36/I18,\"\")","v":""},{"$f":"IF(ISBLANK($I18),\"\",IFERROR(Worksheet!AK36/$I18,\"\"))","v":""},{"$f":"IF(ISBLANK($I18),\"\",IFERROR(Worksheet!AO36/$I18,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R36)=FALSE,Worksheet!R36,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T36,\"\")","v":0}]
[{"$f":"IF(Worksheet!S37=0,\"\",IF(OR(Worksheet!C37=\"AS\",Worksheet!C37=\"AP\")=TRUE,74,IF(Worksheet!C37=\"E\",340,IF(Worksheet!C37=\"D\",77,IF(OR(Worksheet!C37=\"PTAC\",Worksheet!C37=\"PTHP\")=TRUE,75,IF(Worksheet!C37=\"W\",78,IF(Worksheet!C37=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D37)=FALSE,Worksheet!D37,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E37)=FALSE,Worksheet!E37,\"\")","v":""},{"$f":"Worksheet!K37","v":0},"Btuh",{"$f":"IF(Worksheet!K37>=65000,Worksheet!M37,\"\")","v":""},{"$f":"IF(Worksheet!K37<65000,Worksheet!M37,\"\")","v":0},{"$f":"Worksheet!S37","v":0},{"$f":"IF(ISBLANK(Worksheet!Q37)=FALSE,Worksheet!Q37,\"\")","v":""},{"$f":"Worksheet!AE37","v":0},{"$f":"Worksheet!AB37","v":0},{"$f":"IFERROR(Worksheet!AM37/I19,\"\")","v":""},{"$f":"IF(ISBLANK($I19),\"\",IFERROR(Worksheet!AK37/$I19,\"\"))","v":""},{"$f":"IF(ISBLANK($I19),\"\",IFERROR(Worksheet!AO37/$I19,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R37)=FALSE,Worksheet!R37,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T37,\"\")","v":0}]
[{"$f":"IF(Worksheet!S38=0,\"\",IF(OR(Worksheet!C38=\"AS\",Worksheet!C38=\"AP\")=TRUE,74,IF(Worksheet!C38=\"E\",340,IF(Worksheet!C38=\"D\",77,IF(OR(Worksheet!C38=\"PTAC\",Worksheet!C38=\"PTHP\")=TRUE,75,IF(Worksheet!C38=\"W\",78,IF(Worksheet!C38=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D38)=FALSE,Worksheet!D38,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E38)=FALSE,Worksheet!E38,\"\")","v":""},{"$f":"Worksheet!K38","v":0},"Btuh",{"$f":"IF(Worksheet!K38>=65000,Worksheet!M38,\"\")","v":""},{"$f":"IF(Worksheet!K38<65000,Worksheet!M38,\"\")","v":0},{"$f":"Worksheet!S38","v":0},{"$f":"IF(ISBLANK(Worksheet!Q38)=FALSE,Worksheet!Q38,\"\")","v":""},{"$f":"Worksheet!AE38","v":0},{"$f":"Worksheet!AB38","v":0},{"$f":"IFERROR(Worksheet!AM38/I20,\"\")","v":""},{"$f":"IF(ISBLANK($I20),\"\",IFERROR(Worksheet!AK38/$I20,\"\"))","v":""},{"$f":"IF(ISBLANK($I20),\"\",IFERROR(Worksheet!AO38/$I20,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R38)=FALSE,Worksheet!R38,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T38,\"\")","v":0}]
[{"$f":"IF(Worksheet!S39=0,\"\",IF(OR(Worksheet!C39=\"AS\",Worksheet!C39=\"AP\")=TRUE,74,IF(Worksheet!C39=\"E\",340,IF(Worksheet!C39=\"D\",77,IF(OR(Worksheet!C39=\"PTAC\",Worksheet!C39=\"PTHP\")=TRUE,75,IF(Worksheet!C39=\"W\",78,IF(Worksheet!C39=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D39)=FALSE,Worksheet!D39,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E39)=FALSE,Worksheet!E39,\"\")","v":""},{"$f":"Worksheet!K39","v":0},"Btuh",{"$f":"IF(Worksheet!K39>=65000,Worksheet!M39,\"\")","v":""},{"$f":"IF(Worksheet!K39<65000,Worksheet!M39,\"\")","v":0},{"$f":"Worksheet!S39","v":0},{"$f":"IF(ISBLANK(Worksheet!Q39)=FALSE,Worksheet!Q39,\"\")","v":""},{"$f":"Worksheet!AE39","v":0},{"$f":"Worksheet!AB39","v":0},{"$f":"IFERROR(Worksheet!AM39/I21,\"\")","v":""},{"$f":"IF(ISBLANK($I21),\"\",IFERROR(Worksheet!AK39/$I21,\"\"))","v":""},{"$f":"IF(ISBLANK($I21),\"\",IFERROR(Worksheet!AO39/$I21,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R39)=FALSE,Worksheet!R39,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T39,\"\")","v":0}]
[{"$f":"IF(Worksheet!S40=0,\"\",IF(OR(Worksheet!C40=\"AS\",Worksheet!C40=\"AP\")=TRUE,74,IF(Worksheet!C40=\"E\",340,IF(Worksheet!C40=\"D\",77,IF(OR(Worksheet!C40=\"PTAC\",Worksheet!C40=\"PTHP\")=TRUE,75,IF(Worksheet!C40=\"W\",78,IF(Worksheet!C40=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D40)=FALSE,Worksheet!D40,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E40)=FALSE,Worksheet!E40,\"\")","v":""},{"$f":"Worksheet!K40","v":0},"Btuh",{"$f":"IF(Worksheet!K40>=65000,Worksheet!M40,\"\")","v":""},{"$f":"IF(Worksheet!K40<65000,Worksheet!M40,\"\")","v":0},{"$f":"Worksheet!S40","v":0},{"$f":"IF(ISBLANK(Worksheet!Q40)=FALSE,Worksheet!Q40,\"\")","v":""},{"$f":"Worksheet!AE40","v":0},{"$f":"Worksheet!AB40","v":0},{"$f":"IFERROR(Worksheet!AM40/I22,\"\")","v":""},{"$f":"IF(ISBLANK($I22),\"\",IFERROR(Worksheet!AK40/$I22,\"\"))","v":""},{"$f":"IF(ISBLANK($I22),\"\",IFERROR(Worksheet!AO40/$I22,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R40)=FALSE,Worksheet!R40,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T40,\"\")","v":0}]
[{"$f":"IF(Worksheet!S41=0,\"\",IF(OR(Worksheet!C41=\"AS\",Worksheet!C41=\"AP\")=TRUE,74,IF(Worksheet!C41=\"E\",340,IF(Worksheet!C41=\"D\",77,IF(OR(Worksheet!C41=\"PTAC\",Worksheet!C41=\"PTHP\")=TRUE,75,IF(Worksheet!C41=\"W\",78,IF(Worksheet!C41=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D41)=FALSE,Worksheet!D41,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E41)=FALSE,Worksheet!E41,\"\")","v":""},{"$f":"Worksheet!K41","v":0},"Btuh",{"$f":"IF(Worksheet!K41>=65000,Worksheet!M41,\"\")","v":""},{"$f":"IF(Worksheet!K41<65000,Worksheet!M41,\"\")","v":0},{"$f":"Worksheet!S41","v":0},{"$f":"IF(ISBLANK(Worksheet!Q41)=FALSE,Worksheet!Q41,\"\")","v":""},{"$f":"Worksheet!AE41","v":0},{"$f":"Worksheet!AB41","v":0},{"$f":"IFERROR(Worksheet!AM41/I23,\"\")","v":""},{"$f":"IF(ISBLANK($I23),\"\",IFERROR(Worksheet!AK41/$I23,\"\"))","v":""},{"$f":"IF(ISBLANK($I23),\"\",IFERROR(Worksheet!AO41/$I23,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R41)=FALSE,Worksheet!R41,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T41,\"\")","v":0}]
[{"$f":"IF(Worksheet!S42=0,\"\",IF(OR(Worksheet!C42=\"AS\",Worksheet!C42=\"AP\")=TRUE,74,IF(Worksheet!C42=\"E\",340,IF(Worksheet!C42=\"D\",77,IF(OR(Worksheet!C42=\"PTAC\",Worksheet!C42=\"PTHP\")=TRUE,75,IF(Worksheet!C42=\"W\",78,IF(Worksheet!C42=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D42)=FALSE,Worksheet!D42,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E42)=FALSE,Worksheet!E42,\"\")","v":""},{"$f":"Worksheet!K42","v":0},"Btuh",{"$f":"IF(Worksheet!K42>=65000,Worksheet!M42,\"\")","v":""},{"$f":"IF(Worksheet!K42<65000,Worksheet!M42,\"\")","v":0},{"$f":"Worksheet!S42","v":0},{"$f":"IF(ISBLANK(Worksheet!Q42)=FALSE,Worksheet!Q42,\"\")","v":""},{"$f":"Worksheet!AE42","v":0},{"$f":"Worksheet!AB42","v":0},{"$f":"IFERROR(Worksheet!AM42/I24,\"\")","v":""},{"$f":"IF(ISBLANK($I24),\"\",IFERROR(Worksheet!AK42/$I24,\"\"))","v":""},{"$f":"IF(ISBLANK($I24),\"\",IFERROR(Worksheet!AO42/$I24,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R42)=FALSE,Worksheet!R42,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T42,\"\")","v":0}]
[{"$f":"IF(Worksheet!S43=0,\"\",IF(OR(Worksheet!C43=\"AS\",Worksheet!C43=\"AP\")=TRUE,74,IF(Worksheet!C43=\"E\",340,IF(Worksheet!C43=\"D\",77,IF(OR(Worksheet!C43=\"PTAC\",Worksheet!C43=\"PTHP\")=TRUE,75,IF(Worksheet!C43=\"W\",78,IF(Worksheet!C43=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D43)=FALSE,Worksheet!D43,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E43)=FALSE,Worksheet!E43,\"\")","v":""},{"$f":"Worksheet!K43","v":0},"Btuh",{"$f":"IF(Worksheet!K43>=65000,Worksheet!M43,\"\")","v":""},{"$f":"IF(Worksheet!K43<65000,Worksheet!M43,\"\")","v":0},{"$f":"Worksheet!S43","v":0},{"$f":"IF(ISBLANK(Worksheet!Q43)=FALSE,Worksheet!Q43,\"\")","v":""},{"$f":"Worksheet!AE43","v":0},{"$f":"Worksheet!AB43","v":0},{"$f":"IFERROR(Worksheet!AM43/I25,\"\")","v":""},{"$f":"IF(ISBLANK($I25),\"\",IFERROR(Worksheet!AK43/$I25,\"\"))","v":""},{"$f":"IF(ISBLANK($I25),\"\",IFERROR(Worksheet!AO43/$I25,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R43)=FALSE,Worksheet!R43,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T43,\"\")","v":0}]
[{"$f":"IF(Worksheet!S44=0,\"\",IF(OR(Worksheet!C44=\"AS\",Worksheet!C44=\"AP\")=TRUE,74,IF(Worksheet!C44=\"E\",340,IF(Worksheet!C44=\"D\",77,IF(OR(Worksheet!C44=\"PTAC\",Worksheet!C44=\"PTHP\")=TRUE,75,IF(Worksheet!C44=\"W\",78,IF(Worksheet!C44=\"O\",222,73)))))))","v":""},{"$f":"IF(ISBLANK(Worksheet!D44)=FALSE,Worksheet!D44,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E44)=FALSE,Worksheet!E44,\"\")","v":""},{"$f":"Worksheet!K44","v":0},"Btuh",{"$f":"IF(Worksheet!K44>=65000,Worksheet!M44,\"\")","v":""},{"$f":"IF(Worksheet!K44<65000,Worksheet!M44,\"\")","v":0},{"$f":"Worksheet!S44","v":0},{"$f":"IF(ISBLANK(Worksheet!Q44)=FALSE,Worksheet!Q44,\"\")","v":""},{"$f":"Worksheet!AE44","v":0},{"$f":"Worksheet!AB44","v":0},{"$f":"IFERROR(Worksheet!AM44/I26,\"\")","v":""},{"$f":"IF(ISBLANK($I26),\"\",IFERROR(Worksheet!AK44/$I26,\"\"))","v":""},{"$f":"IF(ISBLANK($I26),\"\",IFERROR(Worksheet!AO44/$I26,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!R44)=FALSE,Worksheet!R44,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!T44,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[15,"<-Version"]
[]
["Log"]
["1/1/2008 Baseline efficiencies updated to comply with new protocol"]
["12/1/2008 updated for measure tracking compatability"]
["7/13/2009 entered formula for baseline efficiency into \"n\"-column cells to reflect protocol."]
["10/18/2009 added separate Dual Enthalpy Control system in order for correct incentive to export"]
["(missed updates)"]
["2011-03-15",null,"fixed error in export tab where the quantity was left out in a certain row"]
["2012-01-13","V5","added fuel use economizers"]
["2013-07-09","V7","no change for V7, skipped V6"]
["2014-08-13",null,"updated dual enthalpy formula for demand savings in VBA code; updated central dx baseline to match other DX systems, also in VBA code"]
["2018-06-21","V12","Removed Dual Enthalpy Economizer measure and updated to align with FY19 Protocols"]
["2019-07-01","V13","Added Enhanced Incentive Eligibility Section and Updated for FY20 Program"]
["2020-10-01","V14","Updated for FY21 Program"]
["2023-07-01","V15","Updated for FY24 Program by Caner Kilinc"]