{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Worksheet","Measure Code","Table","Export","Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,4],[44,11,44,13],[43,11,43,13],[13,13,13,14],[13,6,13,9],[3,2,3,4],[7,2,7,3],[5,2,5,4],[13,2,13,4],[14,23,16,23],[14,21,16,21],[14,22,16,22],[3,21,3,22],[3,19,3,20],[3,6,3,12],[5,20,5,22],[5,23,5,25],[6,23,9,25],[8,2,8,3],[14,24,16,24],[14,20,16,20],[0,12,0,14],[1,12,1,14],[14,18,17,18],[15,17,16,17],[8,6,8,7],[14,13,17,13],[14,14,17,14],[4,2,4,4],[14,19,16,19],[6,20,9,22],[7,6,7,12]]}
["FY22 SmartStart New Construction - Ground Source Heat Pump v1.0",null,null,null,null,"Incentive amounts are estimates until verified by the Program Manager.",null,null,null,null,null,null,"Total Units Committed:",null,null,{"$f":"SUM($L19:$L43)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Installed:",null,null,{"$f":"SUM($M19:$M43)","v":0}]
["Customer Information"]
["Name",null,null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Type"]
["Application",null,null,null,null,"Date"]
["Contact",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"]
["Name",null,null,null,null,"Address"]
["Contact",null,null,null," ","Phone"]
["Enhanced Incentive Eligibility"]
[false,null,false,false]
[false,null,false,false]
[]
["Project Type",null,"New Construction",null,null,"Building Type",null,null,null,null,null,null,null,"Totals:",null,{"$f":"SUM(P19:P43)","v":0},{"$f":"SUM(Q19:Q43)","v":0},null,null,{"$f":"SUM(T19:T43)","v":0},{"$f":"SUM(U19:U43)","v":0},{"$f":"SUM(V19:V43)","v":0},{"$f":"SUM(W19:W43)","v":0},{"$f":"SUM(X19:X43)","v":0},{"$f":"SUM(Y19:Y43)","v":0}]
["Measure Code","Reason","Type 1","Type 2","Manufacturer","Model","A","B","C","D","E","F1","F2","Incentive Per Unit","Enhanced Incentive Per Unit","G1","G2",null,"Unit Total Energy Savings","Committed Peak Savings","Installed Peak Savings","Committed Energy Savings","Installed Energy Savings","Committed Lifetime Savings","Committed Lifetime Savings"]
[null,"N-New","G-Ground","C-Closed Loop",null,null,"Unit Size","Unit Efficiency","Unit Size","Unit Efficiency","Incentive","Quantity","Quantity",null,null,"Committed Equipment","Installed Equipment","Unit Demand Savings"]
[null,"R-Replaced","W-Groundwater",null,null,null,"Cooling","Cooling","Heating","Heating","$/ton","Committed","Installed",null,null,"Incentives","Incentives"]
[null,null,null,null,null,null,"(Btuh)","(EER)","(Btuh)","(COP)",null,null,null,null,null,null,null,null,null,"kW","kW","kWh","kWh","kWh","kWh"]
[null,"N",{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A19=\"\",G19=\"\",H19=\"\",I19=\"\",J19=\"\")=TRUE,0,IF(OR(G19<VLOOKUP(A19,MeasureCode_Lookup,6,FALSE),G19>VLOOKUP(A19,MeasureCode_Lookup,7,FALSE),H19<VLOOKUP(A19,MeasureCode_Lookup,10,FALSE),J19<VLOOKUP(A19,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A19,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K19=0,0,G19/12000*K19)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N19,0)","v":0},{"$f":"L19*(N19+O19)","v":0},{"$f":"M19*(N19+O19)","v":0},{"$f":"IF(K19=0,0,(G19/1000)*(1/VLOOKUP(A19,MeasureCode_Lookup,8,FALSE)-1/H19)*0.5)","v":0},{"$f":"IF(K19=0,0,(G19/1000)*(1/VLOOKUP(A19,MeasureCode_Lookup,8,FALSE)-1/H19)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I19/1000)*(1/(VLOOKUP(A19,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J19*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},{"$f":"IF(K19=0,0,L19*R19)","v":0},{"$f":"IF(K19=0,0,M19*R19)","v":0},{"$f":"IF(M19=0,0,L19*S19)","v":0},{"$f":"IF(M19=0,0,M19*S19)","v":0},{"$f":"IF(M19=0,0,V19*15)","v":0},{"$f":"IF(M19=0,0,V19*15)","v":0}]
[null,"N",{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A20=\"\",G20=\"\",H20=\"\",I20=\"\",J20=\"\")=TRUE,0,IF(OR(G20<VLOOKUP(A20,MeasureCode_Lookup,6,FALSE),G20>VLOOKUP(A20,MeasureCode_Lookup,7,FALSE),H20<VLOOKUP(A20,MeasureCode_Lookup,10,FALSE),J20<VLOOKUP(A20,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A20,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K20=0,0,G20/12000*K20)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N20,0)","v":0},{"$f":"L20*(N20+O20)","v":0},{"$f":"M20*(N20+O20)","v":0},{"$f":"IF(K20=0,0,(G20/1000)*(1/VLOOKUP(A20,MeasureCode_Lookup,8,FALSE)-1/H20)*0.5)","v":0},{"$f":"IF(K20=0,0,(G20/1000)*(1/VLOOKUP(A20,MeasureCode_Lookup,8,FALSE)-1/H20)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I20/1000)*(1/(VLOOKUP(A20,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J20*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A21=\"\",G21=\"\",H21=\"\",I21=\"\",J21=\"\")=TRUE,0,IF(OR(G21<VLOOKUP(A21,MeasureCode_Lookup,6,FALSE),G21>VLOOKUP(A21,MeasureCode_Lookup,7,FALSE),H21<VLOOKUP(A21,MeasureCode_Lookup,10,FALSE),J21<VLOOKUP(A21,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A21,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K21=0,0,G21/12000*K21)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N21,0)","v":0},{"$f":"L21*(N21+O21)","v":0},{"$f":"M21*(N21+O21)","v":0},{"$f":"IF(K21=0,0,(G21/1000)*(1/VLOOKUP(A21,MeasureCode_Lookup,8,FALSE)-1/H21)*0.5)","v":0},{"$f":"IF(K21=0,0,(G21/1000)*(1/VLOOKUP(A21,MeasureCode_Lookup,8,FALSE)-1/H21)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I21/1000)*(1/(VLOOKUP(A21,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J21*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A22=\"\",G22=\"\",H22=\"\",I22=\"\",J22=\"\")=TRUE,0,IF(OR(G22<VLOOKUP(A22,MeasureCode_Lookup,6,FALSE),G22>VLOOKUP(A22,MeasureCode_Lookup,7,FALSE),H22<VLOOKUP(A22,MeasureCode_Lookup,10,FALSE),J22<VLOOKUP(A22,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A22,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K22=0,0,G22/12000*K22)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N22,0)","v":0},{"$f":"L22*(N22+O22)","v":0},{"$f":"M22*(N22+O22)","v":0},{"$f":"IF(K22=0,0,(G22/1000)*(1/VLOOKUP(A22,MeasureCode_Lookup,8,FALSE)-1/H22)*0.5)","v":0},{"$f":"IF(K22=0,0,(G22/1000)*(1/VLOOKUP(A22,MeasureCode_Lookup,8,FALSE)-1/H22)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I22/1000)*(1/(VLOOKUP(A22,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J22*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A23=\"\",G23=\"\",H23=\"\",I23=\"\",J23=\"\")=TRUE,0,IF(OR(G23<VLOOKUP(A23,MeasureCode_Lookup,6,FALSE),G23>VLOOKUP(A23,MeasureCode_Lookup,7,FALSE),H23<VLOOKUP(A23,MeasureCode_Lookup,10,FALSE),J23<VLOOKUP(A23,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A23,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K23=0,0,G23/12000*K23)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N23,0)","v":0},{"$f":"L23*(N23+O23)","v":0},{"$f":"M23*(N23+O23)","v":0},{"$f":"IF(K23=0,0,(G23/1000)*(1/VLOOKUP(A23,MeasureCode_Lookup,8,FALSE)-1/H23)*0.5)","v":0},{"$f":"IF(K23=0,0,(G23/1000)*(1/VLOOKUP(A23,MeasureCode_Lookup,8,FALSE)-1/H23)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I23/1000)*(1/(VLOOKUP(A23,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J23*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A24=\"\",G24=\"\",H24=\"\",I24=\"\",J24=\"\")=TRUE,0,IF(OR(G24<VLOOKUP(A24,MeasureCode_Lookup,6,FALSE),G24>VLOOKUP(A24,MeasureCode_Lookup,7,FALSE),H24<VLOOKUP(A24,MeasureCode_Lookup,10,FALSE),J24<VLOOKUP(A24,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A24,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K24=0,0,G24/12000*K24)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N24,0)","v":0},{"$f":"L24*(N24+O24)","v":0},{"$f":"M24*(N24+O24)","v":0},{"$f":"IF(K24=0,0,(G24/1000)*(1/VLOOKUP(A24,MeasureCode_Lookup,8,FALSE)-1/H24)*0.5)","v":0},{"$f":"IF(K24=0,0,(G24/1000)*(1/VLOOKUP(A24,MeasureCode_Lookup,8,FALSE)-1/H24)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I24/1000)*(1/(VLOOKUP(A24,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J24*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A25=\"\",G25=\"\",H25=\"\",I25=\"\",J25=\"\")=TRUE,0,IF(OR(G25<VLOOKUP(A25,MeasureCode_Lookup,6,FALSE),G25>VLOOKUP(A25,MeasureCode_Lookup,7,FALSE),H25<VLOOKUP(A25,MeasureCode_Lookup,10,FALSE),J25<VLOOKUP(A25,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A25,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K25=0,0,G25/12000*K25)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N25,0)","v":0},{"$f":"L25*(N25+O25)","v":0},{"$f":"M25*(N25+O25)","v":0},{"$f":"IF(K25=0,0,(G25/1000)*(1/VLOOKUP(A25,MeasureCode_Lookup,8,FALSE)-1/H25)*0.5)","v":0},{"$f":"IF(K25=0,0,(G25/1000)*(1/VLOOKUP(A25,MeasureCode_Lookup,8,FALSE)-1/H25)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I25/1000)*(1/(VLOOKUP(A25,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J25*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A26=\"\",G26=\"\",H26=\"\",I26=\"\",J26=\"\")=TRUE,0,IF(OR(G26<VLOOKUP(A26,MeasureCode_Lookup,6,FALSE),G26>VLOOKUP(A26,MeasureCode_Lookup,7,FALSE),H26<VLOOKUP(A26,MeasureCode_Lookup,10,FALSE),J26<VLOOKUP(A26,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A26,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K26=0,0,G26/12000*K26)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N26,0)","v":0},{"$f":"L26*(N26+O26)","v":0},{"$f":"M26*(N26+O26)","v":0},{"$f":"IF(K26=0,0,(G26/1000)*(1/VLOOKUP(A26,MeasureCode_Lookup,8,FALSE)-1/H26)*0.5)","v":0},{"$f":"IF(K26=0,0,(G26/1000)*(1/VLOOKUP(A26,MeasureCode_Lookup,8,FALSE)-1/H26)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I26/1000)*(1/(VLOOKUP(A26,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J26*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A27=\"\",G27=\"\",H27=\"\",I27=\"\",J27=\"\")=TRUE,0,IF(OR(G27<VLOOKUP(A27,MeasureCode_Lookup,6,FALSE),G27>VLOOKUP(A27,MeasureCode_Lookup,7,FALSE),H27<VLOOKUP(A27,MeasureCode_Lookup,10,FALSE),J27<VLOOKUP(A27,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A27,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K27=0,0,G27/12000*K27)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N27,0)","v":0},{"$f":"L27*(N27+O27)","v":0},{"$f":"M27*(N27+O27)","v":0},{"$f":"IF(K27=0,0,(G27/1000)*(1/VLOOKUP(A27,MeasureCode_Lookup,8,FALSE)-1/H27)*0.5)","v":0},{"$f":"IF(K27=0,0,(G27/1000)*(1/VLOOKUP(A27,MeasureCode_Lookup,8,FALSE)-1/H27)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I27/1000)*(1/(VLOOKUP(A27,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J27*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A28=\"\",G28=\"\",H28=\"\",I28=\"\",J28=\"\")=TRUE,0,IF(OR(G28<VLOOKUP(A28,MeasureCode_Lookup,6,FALSE),G28>VLOOKUP(A28,MeasureCode_Lookup,7,FALSE),H28<VLOOKUP(A28,MeasureCode_Lookup,10,FALSE),J28<VLOOKUP(A28,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A28,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K28=0,0,G28/12000*K28)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N28,0)","v":0},{"$f":"L28*(N28+O28)","v":0},{"$f":"M28*(N28+O28)","v":0},{"$f":"IF(K28=0,0,(G28/1000)*(1/VLOOKUP(A28,MeasureCode_Lookup,8,FALSE)-1/H28)*0.5)","v":0},{"$f":"IF(K28=0,0,(G28/1000)*(1/VLOOKUP(A28,MeasureCode_Lookup,8,FALSE)-1/H28)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I28/1000)*(1/(VLOOKUP(A28,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J28*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A29=\"\",G29=\"\",H29=\"\",I29=\"\",J29=\"\")=TRUE,0,IF(OR(G29<VLOOKUP(A29,MeasureCode_Lookup,6,FALSE),G29>VLOOKUP(A29,MeasureCode_Lookup,7,FALSE),H29<VLOOKUP(A29,MeasureCode_Lookup,10,FALSE),J29<VLOOKUP(A29,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A29,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K29=0,0,G29/12000*K29)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N29,0)","v":0},{"$f":"L29*(N29+O29)","v":0},{"$f":"M29*(N29+O29)","v":0},{"$f":"IF(K29=0,0,(G29/1000)*(1/VLOOKUP(A29,MeasureCode_Lookup,8,FALSE)-1/H29)*0.5)","v":0},{"$f":"IF(K29=0,0,(G29/1000)*(1/VLOOKUP(A29,MeasureCode_Lookup,8,FALSE)-1/H29)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I29/1000)*(1/(VLOOKUP(A29,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J29*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A30=\"\",G30=\"\",H30=\"\",I30=\"\",J30=\"\")=TRUE,0,IF(OR(G30<VLOOKUP(A30,MeasureCode_Lookup,6,FALSE),G30>VLOOKUP(A30,MeasureCode_Lookup,7,FALSE),H30<VLOOKUP(A30,MeasureCode_Lookup,10,FALSE),J30<VLOOKUP(A30,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A30,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K30=0,0,G30/12000*K30)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N30,0)","v":0},{"$f":"L30*(N30+O30)","v":0},{"$f":"M30*(N30+O30)","v":0},{"$f":"IF(K30=0,0,(G30/1000)*(1/VLOOKUP(A30,MeasureCode_Lookup,8,FALSE)-1/H30)*0.5)","v":0},{"$f":"IF(K30=0,0,(G30/1000)*(1/VLOOKUP(A30,MeasureCode_Lookup,8,FALSE)-1/H30)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I30/1000)*(1/(VLOOKUP(A30,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J30*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A31=\"\",G31=\"\",H31=\"\",I31=\"\",J31=\"\")=TRUE,0,IF(OR(G31<VLOOKUP(A31,MeasureCode_Lookup,6,FALSE),G31>VLOOKUP(A31,MeasureCode_Lookup,7,FALSE),H31<VLOOKUP(A31,MeasureCode_Lookup,10,FALSE),J31<VLOOKUP(A31,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A31,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K31=0,0,G31/12000*K31)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N31,0)","v":0},{"$f":"L31*(N31+O31)","v":0},{"$f":"M31*(N31+O31)","v":0},{"$f":"IF(K31=0,0,(G31/1000)*(1/VLOOKUP(A31,MeasureCode_Lookup,8,FALSE)-1/H31)*0.5)","v":0},{"$f":"IF(K31=0,0,(G31/1000)*(1/VLOOKUP(A31,MeasureCode_Lookup,8,FALSE)-1/H31)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I31/1000)*(1/(VLOOKUP(A31,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J31*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A32=\"\",G32=\"\",H32=\"\",I32=\"\",J32=\"\")=TRUE,0,IF(OR(G32<VLOOKUP(A32,MeasureCode_Lookup,6,FALSE),G32>VLOOKUP(A32,MeasureCode_Lookup,7,FALSE),H32<VLOOKUP(A32,MeasureCode_Lookup,10,FALSE),J32<VLOOKUP(A32,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A32,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K32=0,0,G32/12000*K32)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N32,0)","v":0},{"$f":"L32*(N32+O32)","v":0},{"$f":"M32*(N32+O32)","v":0},{"$f":"IF(K32=0,0,(G32/1000)*(1/VLOOKUP(A32,MeasureCode_Lookup,8,FALSE)-1/H32)*0.5)","v":0},{"$f":"IF(K32=0,0,(G32/1000)*(1/VLOOKUP(A32,MeasureCode_Lookup,8,FALSE)-1/H32)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I32/1000)*(1/(VLOOKUP(A32,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J32*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A33=\"\",G33=\"\",H33=\"\",I33=\"\",J33=\"\")=TRUE,0,IF(OR(G33<VLOOKUP(A33,MeasureCode_Lookup,6,FALSE),G33>VLOOKUP(A33,MeasureCode_Lookup,7,FALSE),H33<VLOOKUP(A33,MeasureCode_Lookup,10,FALSE),J33<VLOOKUP(A33,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A33,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K33=0,0,G33/12000*K33)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N33,0)","v":0},{"$f":"L33*(N33+O33)","v":0},{"$f":"M33*(N33+O33)","v":0},{"$f":"IF(K33=0,0,(G33/1000)*(1/VLOOKUP(A33,MeasureCode_Lookup,8,FALSE)-1/H33)*0.5)","v":0},{"$f":"IF(K33=0,0,(G33/1000)*(1/VLOOKUP(A33,MeasureCode_Lookup,8,FALSE)-1/H33)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I33/1000)*(1/(VLOOKUP(A33,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J33*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A34=\"\",G34=\"\",H34=\"\",I34=\"\",J34=\"\")=TRUE,0,IF(OR(G34<VLOOKUP(A34,MeasureCode_Lookup,6,FALSE),G34>VLOOKUP(A34,MeasureCode_Lookup,7,FALSE),H34<VLOOKUP(A34,MeasureCode_Lookup,10,FALSE),J34<VLOOKUP(A34,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A34,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K34=0,0,G34/12000*K34)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N34,0)","v":0},{"$f":"L34*(N34+O34)","v":0},{"$f":"M34*(N34+O34)","v":0},{"$f":"IF(K34=0,0,(G34/1000)*(1/VLOOKUP(A34,MeasureCode_Lookup,8,FALSE)-1/H34)*0.5)","v":0},{"$f":"IF(K34=0,0,(G34/1000)*(1/VLOOKUP(A34,MeasureCode_Lookup,8,FALSE)-1/H34)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I34/1000)*(1/(VLOOKUP(A34,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J34*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A35=\"\",G35=\"\",H35=\"\",I35=\"\",J35=\"\")=TRUE,0,IF(OR(G35<VLOOKUP(A35,MeasureCode_Lookup,6,FALSE),G35>VLOOKUP(A35,MeasureCode_Lookup,7,FALSE),H35<VLOOKUP(A35,MeasureCode_Lookup,10,FALSE),J35<VLOOKUP(A35,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A35,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K35=0,0,G35/12000*K35)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N35,0)","v":0},{"$f":"L35*(N35+O35)","v":0},{"$f":"M35*(N35+O35)","v":0},{"$f":"IF(K35=0,0,(G35/1000)*(1/VLOOKUP(A35,MeasureCode_Lookup,8,FALSE)-1/H35)*0.5)","v":0},{"$f":"IF(K35=0,0,(G35/1000)*(1/VLOOKUP(A35,MeasureCode_Lookup,8,FALSE)-1/H35)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I35/1000)*(1/(VLOOKUP(A35,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J35*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A36=\"\",G36=\"\",H36=\"\",I36=\"\",J36=\"\")=TRUE,0,IF(OR(G36<VLOOKUP(A36,MeasureCode_Lookup,6,FALSE),G36>VLOOKUP(A36,MeasureCode_Lookup,7,FALSE),H36<VLOOKUP(A36,MeasureCode_Lookup,10,FALSE),J36<VLOOKUP(A36,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A36,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K36=0,0,G36/12000*K36)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N36,0)","v":0},{"$f":"L36*(N36+O36)","v":0},{"$f":"M36*(N36+O36)","v":0},{"$f":"IF(K36=0,0,(G36/1000)*(1/VLOOKUP(A36,MeasureCode_Lookup,8,FALSE)-1/H36)*0.5)","v":0},{"$f":"IF(K36=0,0,(G36/1000)*(1/VLOOKUP(A36,MeasureCode_Lookup,8,FALSE)-1/H36)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I36/1000)*(1/(VLOOKUP(A36,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J36*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A37=\"\",G37=\"\",H37=\"\",I37=\"\",J37=\"\")=TRUE,0,IF(OR(G37<VLOOKUP(A37,MeasureCode_Lookup,6,FALSE),G37>VLOOKUP(A37,MeasureCode_Lookup,7,FALSE),H37<VLOOKUP(A37,MeasureCode_Lookup,10,FALSE),J37<VLOOKUP(A37,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A37,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K37=0,0,G37/12000*K37)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N37,0)","v":0},{"$f":"L37*(N37+O37)","v":0},{"$f":"M37*(N37+O37)","v":0},{"$f":"IF(K37=0,0,(G37/1000)*(1/VLOOKUP(A37,MeasureCode_Lookup,8,FALSE)-1/H37)*0.5)","v":0},{"$f":"IF(K37=0,0,(G37/1000)*(1/VLOOKUP(A37,MeasureCode_Lookup,8,FALSE)-1/H37)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I37/1000)*(1/(VLOOKUP(A37,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J37*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A38=\"\",G38=\"\",H38=\"\",I38=\"\",J38=\"\")=TRUE,0,IF(OR(G38<VLOOKUP(A38,MeasureCode_Lookup,6,FALSE),G38>VLOOKUP(A38,MeasureCode_Lookup,7,FALSE),H38<VLOOKUP(A38,MeasureCode_Lookup,10,FALSE),J38<VLOOKUP(A38,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A38,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K38=0,0,G38/12000*K38)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N38,0)","v":0},{"$f":"L38*(N38+O38)","v":0},{"$f":"M38*(N38+O38)","v":0},{"$f":"IF(K38=0,0,(G38/1000)*(1/VLOOKUP(A38,MeasureCode_Lookup,8,FALSE)-1/H38)*0.5)","v":0},{"$f":"IF(K38=0,0,(G38/1000)*(1/VLOOKUP(A38,MeasureCode_Lookup,8,FALSE)-1/H38)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I38/1000)*(1/(VLOOKUP(A38,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J38*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A39=\"\",G39=\"\",H39=\"\",I39=\"\",J39=\"\")=TRUE,0,IF(OR(G39<VLOOKUP(A39,MeasureCode_Lookup,6,FALSE),G39>VLOOKUP(A39,MeasureCode_Lookup,7,FALSE),H39<VLOOKUP(A39,MeasureCode_Lookup,10,FALSE),J39<VLOOKUP(A39,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A39,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K39=0,0,G39/12000*K39)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N39,0)","v":0},{"$f":"L39*(N39+O39)","v":0},{"$f":"M39*(N39+O39)","v":0},{"$f":"IF(K39=0,0,(G39/1000)*(1/VLOOKUP(A39,MeasureCode_Lookup,8,FALSE)-1/H39)*0.5)","v":0},{"$f":"IF(K39=0,0,(G39/1000)*(1/VLOOKUP(A39,MeasureCode_Lookup,8,FALSE)-1/H39)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I39/1000)*(1/(VLOOKUP(A39,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J39*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A40=\"\",G40=\"\",H40=\"\",I40=\"\",J40=\"\")=TRUE,0,IF(OR(G40<VLOOKUP(A40,MeasureCode_Lookup,6,FALSE),G40>VLOOKUP(A40,MeasureCode_Lookup,7,FALSE),H40<VLOOKUP(A40,MeasureCode_Lookup,10,FALSE),J40<VLOOKUP(A40,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A40,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K40=0,0,G40/12000*K40)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N40,0)","v":0},{"$f":"L40*(N40+O40)","v":0},{"$f":"M40*(N40+O40)","v":0},{"$f":"IF(K40=0,0,(G40/1000)*(1/VLOOKUP(A40,MeasureCode_Lookup,8,FALSE)-1/H40)*0.5)","v":0},{"$f":"IF(K40=0,0,(G40/1000)*(1/VLOOKUP(A40,MeasureCode_Lookup,8,FALSE)-1/H40)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I40/1000)*(1/(VLOOKUP(A40,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J40*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A41=\"\",G41=\"\",H41=\"\",I41=\"\",J41=\"\")=TRUE,0,IF(OR(G41<VLOOKUP(A41,MeasureCode_Lookup,6,FALSE),G41>VLOOKUP(A41,MeasureCode_Lookup,7,FALSE),H41<VLOOKUP(A41,MeasureCode_Lookup,10,FALSE),J41<VLOOKUP(A41,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A41,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K41=0,0,G41/12000*K41)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N41,0)","v":0},{"$f":"L41*(N41+O41)","v":0},{"$f":"M41*(N41+O41)","v":0},{"$f":"IF(K41=0,0,(G41/1000)*(1/VLOOKUP(A41,MeasureCode_Lookup,8,FALSE)-1/H41)*0.5)","v":0},{"$f":"IF(K41=0,0,(G41/1000)*(1/VLOOKUP(A41,MeasureCode_Lookup,8,FALSE)-1/H41)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I41/1000)*(1/(VLOOKUP(A41,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J41*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A42=\"\",G42=\"\",H42=\"\",I42=\"\",J42=\"\")=TRUE,0,IF(OR(G42<VLOOKUP(A42,MeasureCode_Lookup,6,FALSE),G42>VLOOKUP(A42,MeasureCode_Lookup,7,FALSE),H42<VLOOKUP(A42,MeasureCode_Lookup,10,FALSE),J42<VLOOKUP(A42,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A42,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K42=0,0,G42/12000*K42)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N42,0)","v":0},{"$f":"L42*(N42+O42)","v":0},{"$f":"M42*(N42+O42)","v":0},{"$f":"IF(K42=0,0,(G42/1000)*(1/VLOOKUP(A42,MeasureCode_Lookup,8,FALSE)-1/H42)*0.5)","v":0},{"$f":"IF(K42=0,0,(G42/1000)*(1/VLOOKUP(A42,MeasureCode_Lookup,8,FALSE)-1/H42)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I42/1000)*(1/(VLOOKUP(A42,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J42*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]
[null,"N",{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A43=\"\",G43=\"\",H43=\"\",I43=\"\",J43=\"\")=TRUE,0,IF(OR(G43<VLOOKUP(A43,MeasureCode_Lookup,6,FALSE),G43>VLOOKUP(A43,MeasureCode_Lookup,7,FALSE),H43<VLOOKUP(A43,MeasureCode_Lookup,10,FALSE),J43<VLOOKUP(A43,MeasureCode_Lookup,11,FALSE))=TRUE,0,VLOOKUP(A43,MeasureCode_Lookup,IF($C$14=\"Existing Building\",12,13),FALSE)))","v":0},null,null,{"$f":"IF(K43=0,0,G43/12000*K43)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,N43,0)","v":0},{"$f":"L43*(N43+O43)","v":0},{"$f":"M43*(N43+O43)","v":0},{"$f":"IF(K43=0,0,(G43/1000)*(1/VLOOKUP(A43,MeasureCode_Lookup,8,FALSE)-1/H43)*0.5)","v":0},{"$f":"IF(K43=0,0,(G43/1000)*(1/VLOOKUP(A43,MeasureCode_Lookup,8,FALSE)-1/H43)*VLOOKUP($G$14,BuildingType_Lookup,3,FALSE)+(I43/1000)*(1/(VLOOKUP(A43,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J43*3.412))*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE))","v":0},0,0,0,0,0,0]

{"sheet":"Measure Code","index":1,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Type 1","Type 2","Description","Tier","Min Capacity\n(Btuh)","Max Capacity\n(Btuh)","Baseline EER","Baseline COP","Min Qualifying EER","Min Qualifying COP","Incentive per Ton\nEB","Incentive per Ton\nNC","Measure Type"]
["GSHP1","W","C","Groundwater Source Heat Pump",1,1,134999,18,3.7,18.399999999999999,3.7,80,40,80]
["GSHP2","W","C","Groundwater Source Heat Pump",2,1,134999,18,3.7,22,3.9,96,48,80]
["GSHP3","G","C","Ground Source Heat Pump",1,1,134999,14.1,3.2,14.4,3.2,80,40,80]
["GSHP4","G","C","Ground Source Heat Pump",2,1,134999,14.1,3.2,18,3.6,100,50,80]

{"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",{"$f":"Worksheet!E15","v":"Manufacturer"},{"$f":"Worksheet!F15","v":"Model"},"Capacity/Size","Capacity 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!L19>0, IF(Worksheet!D19=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E19) = FALSE,Worksheet!E19,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F19) = FALSE,Worksheet!F19,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G19) = FALSE,Worksheet!G19,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H19) = FALSE,Worksheet!H19,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N19,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L19) = FALSE,Worksheet!L19,\"\")","v":""},{"$f":"IFERROR(Worksheet!S19,0)","v":0},{"$f":"IFERROR(Worksheet!R19,0)","v":0},{"$f":"IF(N(Worksheet!$T19)>0, J2*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M19) = FALSE,Worksheet!M19,\"\")","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!O19,\"\")","v":0}]
[{"$f":"IF(Worksheet!L20>0, IF(Worksheet!D20=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E20) = FALSE,Worksheet!E20,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F20) = FALSE,Worksheet!F20,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G20) = FALSE,Worksheet!G20,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H20) = FALSE,Worksheet!H20,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N20,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L20) = FALSE,Worksheet!L20,\"\")","v":""},{"$f":"IFERROR(Worksheet!S20,0)","v":0},{"$f":"IFERROR(Worksheet!R20,0)","v":0},{"$f":"IF(N(Worksheet!$T20)>0, J3*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M20) = FALSE,Worksheet!M20,\"\")","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!O20,\"\")","v":0}]
[{"$f":"IF(Worksheet!L21>0, IF(Worksheet!D21=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E21) = FALSE,Worksheet!E21,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F21) = FALSE,Worksheet!F21,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G21) = FALSE,Worksheet!G21,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H21) = FALSE,Worksheet!H21,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N21,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L21) = FALSE,Worksheet!L21,\"\")","v":""},{"$f":"IFERROR(Worksheet!S21,0)","v":0},{"$f":"IFERROR(Worksheet!R21,0)","v":0},{"$f":"IF(N(Worksheet!$T21)>0, J4*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M21) = FALSE,Worksheet!M21,\"\")","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!O21,\"\")","v":0}]
[{"$f":"IF(Worksheet!L22>0, IF(Worksheet!D22=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E22) = FALSE,Worksheet!E22,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F22) = FALSE,Worksheet!F22,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G22) = FALSE,Worksheet!G22,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H22) = FALSE,Worksheet!H22,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N22,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L22) = FALSE,Worksheet!L22,\"\")","v":""},{"$f":"IFERROR(Worksheet!S22,0)","v":0},{"$f":"IFERROR(Worksheet!R22,0)","v":0},{"$f":"IF(N(Worksheet!$T22)>0, J5*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M22) = FALSE,Worksheet!M22,\"\")","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!O22,\"\")","v":0}]
[{"$f":"IF(Worksheet!L23>0, IF(Worksheet!D23=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E23) = FALSE,Worksheet!E23,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F23) = FALSE,Worksheet!F23,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G23) = FALSE,Worksheet!G23,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H23) = FALSE,Worksheet!H23,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N23,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L23) = FALSE,Worksheet!L23,\"\")","v":""},{"$f":"IFERROR(Worksheet!S23,0)","v":0},{"$f":"IFERROR(Worksheet!R23,0)","v":0},{"$f":"IF(N(Worksheet!$T23)>0, J6*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M23) = FALSE,Worksheet!M23,\"\")","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!O23,\"\")","v":0}]
[{"$f":"IF(Worksheet!L24>0, IF(Worksheet!D24=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E24) = FALSE,Worksheet!E24,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F24) = FALSE,Worksheet!F24,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G24) = FALSE,Worksheet!G24,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H24) = FALSE,Worksheet!H24,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N24,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L24) = FALSE,Worksheet!L24,\"\")","v":""},{"$f":"IFERROR(Worksheet!S24,0)","v":0},{"$f":"IFERROR(Worksheet!R24,0)","v":0},{"$f":"IF(N(Worksheet!$T24)>0, J7*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M24) = FALSE,Worksheet!M24,\"\")","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!O24,\"\")","v":0}]
[{"$f":"IF(Worksheet!L25>0, IF(Worksheet!D25=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E25) = FALSE,Worksheet!E25,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F25) = FALSE,Worksheet!F25,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G25) = FALSE,Worksheet!G25,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H25) = FALSE,Worksheet!H25,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N25,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L25) = FALSE,Worksheet!L25,\"\")","v":""},{"$f":"IFERROR(Worksheet!S25,0)","v":0},{"$f":"IFERROR(Worksheet!R25,0)","v":0},{"$f":"IF(N(Worksheet!$T25)>0, J8*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M25) = FALSE,Worksheet!M25,\"\")","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!O25,\"\")","v":0}]
[{"$f":"IF(Worksheet!L26>0, IF(Worksheet!D26=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E26) = FALSE,Worksheet!E26,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F26) = FALSE,Worksheet!F26,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G26) = FALSE,Worksheet!G26,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H26) = FALSE,Worksheet!H26,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N26,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L26) = FALSE,Worksheet!L26,\"\")","v":""},{"$f":"IFERROR(Worksheet!S26,0)","v":0},{"$f":"IFERROR(Worksheet!R26,0)","v":0},{"$f":"IF(N(Worksheet!$T26)>0, J9*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M26) = FALSE,Worksheet!M26,\"\")","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!O26,\"\")","v":0}]
[{"$f":"IF(Worksheet!L27>0, IF(Worksheet!D27=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E27) = FALSE,Worksheet!E27,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F27) = FALSE,Worksheet!F27,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G27) = FALSE,Worksheet!G27,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H27) = FALSE,Worksheet!H27,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N27,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L27) = FALSE,Worksheet!L27,\"\")","v":""},{"$f":"IFERROR(Worksheet!S27,0)","v":0},{"$f":"IFERROR(Worksheet!R27,0)","v":0},{"$f":"IF(N(Worksheet!$T27)>0, J10*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M27) = FALSE,Worksheet!M27,\"\")","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!O27,\"\")","v":0}]
[{"$f":"IF(Worksheet!L28>0, IF(Worksheet!D28=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E28) = FALSE,Worksheet!E28,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F28) = FALSE,Worksheet!F28,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G28) = FALSE,Worksheet!G28,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H28) = FALSE,Worksheet!H28,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N28,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L28) = FALSE,Worksheet!L28,\"\")","v":""},{"$f":"IFERROR(Worksheet!S28,0)","v":0},{"$f":"IFERROR(Worksheet!R28,0)","v":0},{"$f":"IF(N(Worksheet!$T28)>0, J11*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M28) = FALSE,Worksheet!M28,\"\")","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!O28,\"\")","v":0}]
[{"$f":"IF(Worksheet!L29>0, IF(Worksheet!D29=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E29) = FALSE,Worksheet!E29,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F29) = FALSE,Worksheet!F29,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G29) = FALSE,Worksheet!G29,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H29) = FALSE,Worksheet!H29,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N29,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L29) = FALSE,Worksheet!L29,\"\")","v":""},{"$f":"IFERROR(Worksheet!S29,0)","v":0},{"$f":"IFERROR(Worksheet!R29,0)","v":0},{"$f":"IF(N(Worksheet!$T29)>0, J12*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M29) = FALSE,Worksheet!M29,\"\")","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!O29,\"\")","v":0}]
[{"$f":"IF(Worksheet!L30>0, IF(Worksheet!D30=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E30) = FALSE,Worksheet!E30,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F30) = FALSE,Worksheet!F30,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G30) = FALSE,Worksheet!G30,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H30) = FALSE,Worksheet!H30,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N30,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L30) = FALSE,Worksheet!L30,\"\")","v":""},{"$f":"IFERROR(Worksheet!S30,0)","v":0},{"$f":"IFERROR(Worksheet!R30,0)","v":0},{"$f":"IF(N(Worksheet!$T30)>0, J13*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M30) = FALSE,Worksheet!M30,\"\")","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!O30,\"\")","v":0}]
[{"$f":"IF(Worksheet!L31>0, IF(Worksheet!D31=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E31) = FALSE,Worksheet!E31,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F31) = FALSE,Worksheet!F31,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G31) = FALSE,Worksheet!G31,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H31) = FALSE,Worksheet!H31,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N31,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L31) = FALSE,Worksheet!L31,\"\")","v":""},{"$f":"IFERROR(Worksheet!S31,0)","v":0},{"$f":"IFERROR(Worksheet!R31,0)","v":0},{"$f":"IF(N(Worksheet!$T31)>0, J14*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M31) = FALSE,Worksheet!M31,\"\")","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!O31,\"\")","v":0}]
[{"$f":"IF(Worksheet!L32>0, IF(Worksheet!D32=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E32) = FALSE,Worksheet!E32,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F32) = FALSE,Worksheet!F32,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G32) = FALSE,Worksheet!G32,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H32) = FALSE,Worksheet!H32,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N32,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L32) = FALSE,Worksheet!L32,\"\")","v":""},{"$f":"IFERROR(Worksheet!S32,0)","v":0},{"$f":"IFERROR(Worksheet!R32,0)","v":0},{"$f":"IF(N(Worksheet!$T32)>0, J15*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M32) = FALSE,Worksheet!M32,\"\")","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!O32,\"\")","v":0}]
[{"$f":"IF(Worksheet!L33>0, IF(Worksheet!D33=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E33) = FALSE,Worksheet!E33,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F33) = FALSE,Worksheet!F33,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G33) = FALSE,Worksheet!G33,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H33) = FALSE,Worksheet!H33,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N33,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L33) = FALSE,Worksheet!L33,\"\")","v":""},{"$f":"IFERROR(Worksheet!S33,0)","v":0},{"$f":"IFERROR(Worksheet!R33,0)","v":0},{"$f":"IF(N(Worksheet!$T33)>0, J16*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M33) = FALSE,Worksheet!M33,\"\")","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!O33,\"\")","v":0}]
[{"$f":"IF(Worksheet!L34>0, IF(Worksheet!D34=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E34) = FALSE,Worksheet!E34,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F34) = FALSE,Worksheet!F34,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G34) = FALSE,Worksheet!G34,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H34) = FALSE,Worksheet!H34,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N34,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L34) = FALSE,Worksheet!L34,\"\")","v":""},{"$f":"IFERROR(Worksheet!S34,0)","v":0},{"$f":"IFERROR(Worksheet!R34,0)","v":0},{"$f":"IF(N(Worksheet!$T34)>0, J17*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M34) = FALSE,Worksheet!M34,\"\")","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!O34,\"\")","v":0}]
[{"$f":"IF(Worksheet!L35>0, IF(Worksheet!D35=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E35) = FALSE,Worksheet!E35,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F35) = FALSE,Worksheet!F35,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G35) = FALSE,Worksheet!G35,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H35) = FALSE,Worksheet!H35,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N35,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L35) = FALSE,Worksheet!L35,\"\")","v":""},{"$f":"IFERROR(Worksheet!S35,0)","v":0},{"$f":"IFERROR(Worksheet!R35,0)","v":0},{"$f":"IF(N(Worksheet!$T35)>0, J18*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M35) = FALSE,Worksheet!M35,\"\")","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!O35,\"\")","v":0}]
[{"$f":"IF(Worksheet!L36>0, IF(Worksheet!D36=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E36) = FALSE,Worksheet!E36,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F36) = FALSE,Worksheet!F36,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G36) = FALSE,Worksheet!G36,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H36) = FALSE,Worksheet!H36,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N36,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L36) = FALSE,Worksheet!L36,\"\")","v":""},{"$f":"IFERROR(Worksheet!S36,0)","v":0},{"$f":"IFERROR(Worksheet!R36,0)","v":0},{"$f":"IF(N(Worksheet!$T36)>0, J19*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M36) = FALSE,Worksheet!M36,\"\")","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!O36,\"\")","v":0}]
[{"$f":"IF(Worksheet!L37>0, IF(Worksheet!D37=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E37) = FALSE,Worksheet!E37,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F37) = FALSE,Worksheet!F37,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G37) = FALSE,Worksheet!G37,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H37) = FALSE,Worksheet!H37,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N37,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L37) = FALSE,Worksheet!L37,\"\")","v":""},{"$f":"IFERROR(Worksheet!S37,0)","v":0},{"$f":"IFERROR(Worksheet!R37,0)","v":0},{"$f":"IF(N(Worksheet!$T37)>0, J20*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M37) = FALSE,Worksheet!M37,\"\")","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!O37,\"\")","v":0}]
[{"$f":"IF(Worksheet!L38>0, IF(Worksheet!D38=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E38) = FALSE,Worksheet!E38,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F38) = FALSE,Worksheet!F38,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G38) = FALSE,Worksheet!G38,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H38) = FALSE,Worksheet!H38,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N38,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L38) = FALSE,Worksheet!L38,\"\")","v":""},{"$f":"IFERROR(Worksheet!S38,0)","v":0},{"$f":"IFERROR(Worksheet!R38,0)","v":0},{"$f":"IF(N(Worksheet!$T38)>0, J21*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M38) = FALSE,Worksheet!M38,\"\")","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!O38,\"\")","v":0}]
[{"$f":"IF(Worksheet!L39>0, IF(Worksheet!D39=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E39) = FALSE,Worksheet!E39,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F39) = FALSE,Worksheet!F39,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G39) = FALSE,Worksheet!G39,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H39) = FALSE,Worksheet!H39,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N39,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L39) = FALSE,Worksheet!L39,\"\")","v":""},{"$f":"IFERROR(Worksheet!S39,0)","v":0},{"$f":"IFERROR(Worksheet!R39,0)","v":0},{"$f":"IF(N(Worksheet!$T39)>0, J22*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M39) = FALSE,Worksheet!M39,\"\")","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!O39,\"\")","v":0}]
[{"$f":"IF(Worksheet!L40>0, IF(Worksheet!D40=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E40) = FALSE,Worksheet!E40,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F40) = FALSE,Worksheet!F40,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G40) = FALSE,Worksheet!G40,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H40) = FALSE,Worksheet!H40,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N40,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L40) = FALSE,Worksheet!L40,\"\")","v":""},{"$f":"IFERROR(Worksheet!S40,0)","v":0},{"$f":"IFERROR(Worksheet!R40,0)","v":0},{"$f":"IF(N(Worksheet!$T40)>0, J23*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M40) = FALSE,Worksheet!M40,\"\")","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!O40,\"\")","v":0}]
[{"$f":"IF(Worksheet!L41>0, IF(Worksheet!D41=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E41) = FALSE,Worksheet!E41,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F41) = FALSE,Worksheet!F41,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G41) = FALSE,Worksheet!G41,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H41) = FALSE,Worksheet!H41,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N41,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L41) = FALSE,Worksheet!L41,\"\")","v":""},{"$f":"IFERROR(Worksheet!S41,0)","v":0},{"$f":"IFERROR(Worksheet!R41,0)","v":0},{"$f":"IF(N(Worksheet!$T41)>0, J24*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M41) = FALSE,Worksheet!M41,\"\")","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!O41,\"\")","v":0}]
[{"$f":"IF(Worksheet!L42>0, IF(Worksheet!D42=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E42) = FALSE,Worksheet!E42,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F42) = FALSE,Worksheet!F42,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G42) = FALSE,Worksheet!G42,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H42) = FALSE,Worksheet!H42,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N42,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L42) = FALSE,Worksheet!L42,\"\")","v":""},{"$f":"IFERROR(Worksheet!S42,0)","v":0},{"$f":"IFERROR(Worksheet!R42,0)","v":0},{"$f":"IF(N(Worksheet!$T42)>0, J25*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M42) = FALSE,Worksheet!M42,\"\")","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!O42,\"\")","v":0}]
[{"$f":"IF(Worksheet!L43>0, IF(Worksheet!D43=\"C\",80,79),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E43) = FALSE,Worksheet!E43,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!F43) = FALSE,Worksheet!F43,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!G43) = FALSE,Worksheet!G43,\"\")","v":""},"Btuh",{"$f":"IF(ISBLANK(Worksheet!H43) = FALSE,Worksheet!H43,\"\")","v":""},null,{"$f":"IFERROR(Worksheet!N43,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!L43) = FALSE,Worksheet!L43,\"\")","v":""},{"$f":"IFERROR(Worksheet!S43,0)","v":0},{"$f":"IFERROR(Worksheet!R43,0)","v":0},{"$f":"IF(N(Worksheet!$T43)>0, J26*15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!M43) = FALSE,Worksheet!M43,\"\")","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!O43,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[14,"<-Version"]
[]
["Log"]
["12/1/2008 - updated for measure tracaking compatability"]
["7/14/09 - changed minimum qualifying efficiency from 16.2 to 16 EER in accordance with form incentive structure"]
["2012-01-13","V5","no change for 2012"]
["2013-07-09","V7","no change for V7, skipped V6"]
["2018-06-21","V12","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"]