{"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":11,"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":40,"n_cols":25,"rows_kept":40,"cut":false,"hidden":false,"merged":[[13,6,13,8],[3,6,3,10],[0,0,0,3],[3,13,3,14],[2,13,2,14],[7,6,7,10],[13,2,13,3],[8,2,8,3],[7,2,7,3],[5,2,5,4],[3,2,3,4],[4,2,4,4],[8,6,8,8],[9,22,9,24],[2,21,2,23],[3,21,7,23],[2,24,2,26],[3,24,7,26]]}
["FY23 SmartStart New Construction - Gas Heating v1.1",null,null,null,"Incentive amounts below are estimates until verified by the Program Manager."]
[]
["Customer Information",null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Committed:",null,{"$f":"SUM(N16:N40)","v":0},null,null,null,null,null,"Pre-Inspection Notes",null,null,"Post-Inspection Notes"]
["Company",null,null,null,null,"Address",null,null,null,null,null,null,null,"Total Units Installed:",null,{"$f":"SUM(O16:O40)","v":0}]
["Application",null,null,null,null,"Date"]
["Contact"]
["Contractor/Vendor Information"]
["Company",null,null,null,null,"Address"]
["Contact",null,null,null," ","Phone"]
["Enhanced Incentive Eligibility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Type"]
[false,null,false,false]
[false,null,false,false]
[]
["Project Type",null,"New Construction",null,null,"Building Type",null,null,null,null,null,null,null,null,null,"Totals",null,{"$f":"SUM(R16:R40)","v":0},{"$f":"SUM(S16:S40)","v":0},null,{"$f":"SUM(T16:T40)","v":0},{"$f":"SUM(U16:U40)","v":0},{"$f":"SUM(V16:V40)","v":0},0]
["Measure Code","New or Replaced","Type","Manufacturer","Model Number","Boiler Type \n(If Applicable)","Unit Size (MBH Input) \nNote: 1 MBH = 1000 Btu/h","Existing     Unit Size (MBH Input) Note: 1 MBH = 1000 Btu/h","Baseline Equipment Efficiency ","Proposed Equipment Efficiency ","Units","Pipe Diameter\n(in)","Insulation Thickness\n(in)","Quantity Committed\n\nPipe Wrap Insulation: Enter length of insulated pipe (in ft)","Quantity Installed\n\nPipe Wrap Insulation: Enter length of insulated pipe (in ft)","Incentive per Unit","Enhanced Incentive per Unit","Total Committed Incentive","Total Installed Incentive","Annual Gas Committed Savings (Therms)","Annual Gas Installed Savings (Therms)","Lifetime Committed Gas Savings (Therms)","Lifetime Installed Gas Savings (Therms)"]
[null,"N",{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,MeasureCode_Lookup,2,FALSE))","v":""},null,null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,MeasureCode_Lookup,3,FALSE))","v":""},null,{"$f":"G16","v":0},{"$f":"IF(OR(C16=\"Infrared Heater\",C16=\"Boiler Fuel Economizer\",C16=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A16=\"\",C16=\"\",F16=\"\",G16=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G16,Table!$D$2:$D$6,1),MATCH(C16&\": \"&F16,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C16=\"Infrared Heater\",C16=\"Boiler Fuel Economizer\",C16=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A16=\"\",C16=\"\",F16=\"\",G16=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G16,Table!$D$2:$D$6,1),MATCH(C16&\": \"&F16,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A16=\"\",AND(G16=\"\",C16<>\"Pipe Wrap Insulation\")=TRUE,AND(C16<>\"Infrared Heater\",C16<>\"Boiler Fuel Economizer\",C16<>\"Pipe Wrap Insulation\",J16=\"\")=TRUE,AND(C16=\"Pipe Wrap Insulation\",OR(L16=\"\",M16=\"\")=TRUE)=TRUE,AND(A16=\"GH31\",L16>0.5)=TRUE,AND(A16=\"GH32\",L16<=0.5)=TRUE,G16<VLOOKUP(A16,MeasureCode_Lookup,4,FALSE),G16>VLOOKUP(A16,MeasureCode_Lookup,5,FALSE),J16<VLOOKUP(A16,MeasureCode_Lookup,6,FALSE),AND(C16=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G16*VLOOKUP(A16,MeasureCode_Lookup,8,FALSE),VLOOKUP(A16,MeasureCode_Lookup,9,FALSE))),0)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,P16,0)","v":0},{"$f":"N16*(P16+Q16)","v":0},{"$f":"O16*(P16+Q16)","v":0},{"$f":"IF(P16=0,0,IF(C16=\"Pipe Wrap Insulation\",N16*INDEX(PipeWrapSavings,MATCH(L16,PipeDiameter,0),MATCH(M16,InsulationThickness,0))*4282/0.8/100000,IF(C16=\"Boiler Fuel Economizer\",N16*G16*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE)*0.13/100,IF(C16=\"Infrared Heater\",N16*120,N16*G16*((J16/I16)-1)*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE)/100))))","v":0},{"$f":"IF(P16=0,0,IF(C16=\"Pipe Wrap Insulation\",O16*INDEX(PipeWrapSavings,MATCH(L16,PipeDiameter,0),MATCH(M16,InsulationThickness,0))*4282/0.8/100000,IF(C16=\"Boiler Fuel Economizer\",O16*G16*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE)*0.13/100,IF(C16=\"Infrared Heater\",O16*120,O16*G16*((J16/I16)-1)*VLOOKUP($G$14,BuildingType_Lookup,2,FALSE)/100))))","v":0},{"$f":"IF(A16=\"\",0,T16*VLOOKUP(A16,MeasureCode_Lookup,10,FALSE))","v":0},{"$f":"IF(A16=\"\",0,U16*VLOOKUP(A16,MeasureCode_Lookup,10,FALSE))","v":0}]
[null,"N","",null,null,"",null,{"$f":"G17","v":0},{"$f":"IF(OR(C17=\"Infrared Heater\",C17=\"Boiler Fuel Economizer\",C17=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A17=\"\",C17=\"\",F17=\"\",G17=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G17,Table!$D$2:$D$6,1),MATCH(C17&\": \"&F17,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C17=\"Infrared Heater\",C17=\"Boiler Fuel Economizer\",C17=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A17=\"\",C17=\"\",F17=\"\",G17=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G17,Table!$D$2:$D$6,1),MATCH(C17&\": \"&F17,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A17=\"\",AND(G17=\"\",C17<>\"Pipe Wrap Insulation\")=TRUE,AND(C17<>\"Infrared Heater\",C17<>\"Boiler Fuel Economizer\",C17<>\"Pipe Wrap Insulation\",J17=\"\")=TRUE,AND(C17=\"Pipe Wrap Insulation\",OR(L17=\"\",M17=\"\")=TRUE)=TRUE,AND(A17=\"GH31\",L17>0.5)=TRUE,AND(A17=\"GH32\",L17<=0.5)=TRUE,G17<VLOOKUP(A17,MeasureCode_Lookup,4,FALSE),G17>VLOOKUP(A17,MeasureCode_Lookup,5,FALSE),J17<VLOOKUP(A17,MeasureCode_Lookup,6,FALSE),AND(C17=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G17*VLOOKUP(A17,MeasureCode_Lookup,8,FALSE),VLOOKUP(A17,MeasureCode_Lookup,9,FALSE))),0)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,P17,0)","v":0},{"$f":"N17*(P17+Q17)","v":0},{"$f":"O17*(P17+Q17)","v":0},0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C18=\"Infrared Heater\",C18=\"Boiler Fuel Economizer\",C18=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A18=\"\",C18=\"\",F18=\"\",G18=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G18,Table!$D$2:$D$6,1),MATCH(C18&\": \"&F18,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C18=\"Infrared Heater\",C18=\"Boiler Fuel Economizer\",C18=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A18=\"\",C18=\"\",F18=\"\",G18=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G18,Table!$D$2:$D$6,1),MATCH(C18&\": \"&F18,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A18=\"\",AND(G18=\"\",C18<>\"Pipe Wrap Insulation\")=TRUE,AND(C18<>\"Infrared Heater\",C18<>\"Boiler Fuel Economizer\",C18<>\"Pipe Wrap Insulation\",J18=\"\")=TRUE,AND(C18=\"Pipe Wrap Insulation\",OR(L18=\"\",M18=\"\")=TRUE)=TRUE,AND(A18=\"GH31\",L18>0.5)=TRUE,AND(A18=\"GH32\",L18<=0.5)=TRUE,G18<VLOOKUP(A18,MeasureCode_Lookup,4,FALSE),G18>VLOOKUP(A18,MeasureCode_Lookup,5,FALSE),J18<VLOOKUP(A18,MeasureCode_Lookup,6,FALSE),AND(C18=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G18*VLOOKUP(A18,MeasureCode_Lookup,8,FALSE),VLOOKUP(A18,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C19=\"Infrared Heater\",C19=\"Boiler Fuel Economizer\",C19=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A19=\"\",C19=\"\",F19=\"\",G19=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G19,Table!$D$2:$D$6,1),MATCH(C19&\": \"&F19,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C19=\"Infrared Heater\",C19=\"Boiler Fuel Economizer\",C19=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A19=\"\",C19=\"\",F19=\"\",G19=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G19,Table!$D$2:$D$6,1),MATCH(C19&\": \"&F19,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A19=\"\",AND(G19=\"\",C19<>\"Pipe Wrap Insulation\")=TRUE,AND(C19<>\"Infrared Heater\",C19<>\"Boiler Fuel Economizer\",C19<>\"Pipe Wrap Insulation\",J19=\"\")=TRUE,AND(C19=\"Pipe Wrap Insulation\",OR(L19=\"\",M19=\"\")=TRUE)=TRUE,AND(A19=\"GH31\",L19>0.5)=TRUE,AND(A19=\"GH32\",L19<=0.5)=TRUE,G19<VLOOKUP(A19,MeasureCode_Lookup,4,FALSE),G19>VLOOKUP(A19,MeasureCode_Lookup,5,FALSE),J19<VLOOKUP(A19,MeasureCode_Lookup,6,FALSE),AND(C19=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G19*VLOOKUP(A19,MeasureCode_Lookup,8,FALSE),VLOOKUP(A19,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C20=\"Infrared Heater\",C20=\"Boiler Fuel Economizer\",C20=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A20=\"\",C20=\"\",F20=\"\",G20=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G20,Table!$D$2:$D$6,1),MATCH(C20&\": \"&F20,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C20=\"Infrared Heater\",C20=\"Boiler Fuel Economizer\",C20=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A20=\"\",C20=\"\",F20=\"\",G20=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G20,Table!$D$2:$D$6,1),MATCH(C20&\": \"&F20,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A20=\"\",AND(G20=\"\",C20<>\"Pipe Wrap Insulation\")=TRUE,AND(C20<>\"Infrared Heater\",C20<>\"Boiler Fuel Economizer\",C20<>\"Pipe Wrap Insulation\",J20=\"\")=TRUE,AND(C20=\"Pipe Wrap Insulation\",OR(L20=\"\",M20=\"\")=TRUE)=TRUE,AND(A20=\"GH31\",L20>0.5)=TRUE,AND(A20=\"GH32\",L20<=0.5)=TRUE,G20<VLOOKUP(A20,MeasureCode_Lookup,4,FALSE),G20>VLOOKUP(A20,MeasureCode_Lookup,5,FALSE),J20<VLOOKUP(A20,MeasureCode_Lookup,6,FALSE),AND(C20=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G20*VLOOKUP(A20,MeasureCode_Lookup,8,FALSE),VLOOKUP(A20,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C21=\"Infrared Heater\",C21=\"Boiler Fuel Economizer\",C21=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A21=\"\",C21=\"\",F21=\"\",G21=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G21,Table!$D$2:$D$6,1),MATCH(C21&\": \"&F21,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C21=\"Infrared Heater\",C21=\"Boiler Fuel Economizer\",C21=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A21=\"\",C21=\"\",F21=\"\",G21=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G21,Table!$D$2:$D$6,1),MATCH(C21&\": \"&F21,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A21=\"\",AND(G21=\"\",C21<>\"Pipe Wrap Insulation\")=TRUE,AND(C21<>\"Infrared Heater\",C21<>\"Boiler Fuel Economizer\",C21<>\"Pipe Wrap Insulation\",J21=\"\")=TRUE,AND(C21=\"Pipe Wrap Insulation\",OR(L21=\"\",M21=\"\")=TRUE)=TRUE,AND(A21=\"GH31\",L21>0.5)=TRUE,AND(A21=\"GH32\",L21<=0.5)=TRUE,G21<VLOOKUP(A21,MeasureCode_Lookup,4,FALSE),G21>VLOOKUP(A21,MeasureCode_Lookup,5,FALSE),J21<VLOOKUP(A21,MeasureCode_Lookup,6,FALSE),AND(C21=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G21*VLOOKUP(A21,MeasureCode_Lookup,8,FALSE),VLOOKUP(A21,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C22=\"Infrared Heater\",C22=\"Boiler Fuel Economizer\",C22=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A22=\"\",C22=\"\",F22=\"\",G22=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G22,Table!$D$2:$D$6,1),MATCH(C22&\": \"&F22,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C22=\"Infrared Heater\",C22=\"Boiler Fuel Economizer\",C22=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A22=\"\",C22=\"\",F22=\"\",G22=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G22,Table!$D$2:$D$6,1),MATCH(C22&\": \"&F22,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A22=\"\",AND(G22=\"\",C22<>\"Pipe Wrap Insulation\")=TRUE,AND(C22<>\"Infrared Heater\",C22<>\"Boiler Fuel Economizer\",C22<>\"Pipe Wrap Insulation\",J22=\"\")=TRUE,AND(C22=\"Pipe Wrap Insulation\",OR(L22=\"\",M22=\"\")=TRUE)=TRUE,AND(A22=\"GH31\",L22>0.5)=TRUE,AND(A22=\"GH32\",L22<=0.5)=TRUE,G22<VLOOKUP(A22,MeasureCode_Lookup,4,FALSE),G22>VLOOKUP(A22,MeasureCode_Lookup,5,FALSE),J22<VLOOKUP(A22,MeasureCode_Lookup,6,FALSE),AND(C22=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G22*VLOOKUP(A22,MeasureCode_Lookup,8,FALSE),VLOOKUP(A22,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C23=\"Infrared Heater\",C23=\"Boiler Fuel Economizer\",C23=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A23=\"\",C23=\"\",F23=\"\",G23=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G23,Table!$D$2:$D$6,1),MATCH(C23&\": \"&F23,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C23=\"Infrared Heater\",C23=\"Boiler Fuel Economizer\",C23=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A23=\"\",C23=\"\",F23=\"\",G23=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G23,Table!$D$2:$D$6,1),MATCH(C23&\": \"&F23,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A23=\"\",AND(G23=\"\",C23<>\"Pipe Wrap Insulation\")=TRUE,AND(C23<>\"Infrared Heater\",C23<>\"Boiler Fuel Economizer\",C23<>\"Pipe Wrap Insulation\",J23=\"\")=TRUE,AND(C23=\"Pipe Wrap Insulation\",OR(L23=\"\",M23=\"\")=TRUE)=TRUE,AND(A23=\"GH31\",L23>0.5)=TRUE,AND(A23=\"GH32\",L23<=0.5)=TRUE,G23<VLOOKUP(A23,MeasureCode_Lookup,4,FALSE),G23>VLOOKUP(A23,MeasureCode_Lookup,5,FALSE),J23<VLOOKUP(A23,MeasureCode_Lookup,6,FALSE),AND(C23=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G23*VLOOKUP(A23,MeasureCode_Lookup,8,FALSE),VLOOKUP(A23,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C24=\"Infrared Heater\",C24=\"Boiler Fuel Economizer\",C24=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A24=\"\",C24=\"\",F24=\"\",G24=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G24,Table!$D$2:$D$6,1),MATCH(C24&\": \"&F24,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C24=\"Infrared Heater\",C24=\"Boiler Fuel Economizer\",C24=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A24=\"\",C24=\"\",F24=\"\",G24=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G24,Table!$D$2:$D$6,1),MATCH(C24&\": \"&F24,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A24=\"\",AND(G24=\"\",C24<>\"Pipe Wrap Insulation\")=TRUE,AND(C24<>\"Infrared Heater\",C24<>\"Boiler Fuel Economizer\",C24<>\"Pipe Wrap Insulation\",J24=\"\")=TRUE,AND(C24=\"Pipe Wrap Insulation\",OR(L24=\"\",M24=\"\")=TRUE)=TRUE,AND(A24=\"GH31\",L24>0.5)=TRUE,AND(A24=\"GH32\",L24<=0.5)=TRUE,G24<VLOOKUP(A24,MeasureCode_Lookup,4,FALSE),G24>VLOOKUP(A24,MeasureCode_Lookup,5,FALSE),J24<VLOOKUP(A24,MeasureCode_Lookup,6,FALSE),AND(C24=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G24*VLOOKUP(A24,MeasureCode_Lookup,8,FALSE),VLOOKUP(A24,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C25=\"Infrared Heater\",C25=\"Boiler Fuel Economizer\",C25=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A25=\"\",C25=\"\",F25=\"\",G25=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G25,Table!$D$2:$D$6,1),MATCH(C25&\": \"&F25,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C25=\"Infrared Heater\",C25=\"Boiler Fuel Economizer\",C25=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A25=\"\",C25=\"\",F25=\"\",G25=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G25,Table!$D$2:$D$6,1),MATCH(C25&\": \"&F25,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A25=\"\",AND(G25=\"\",C25<>\"Pipe Wrap Insulation\")=TRUE,AND(C25<>\"Infrared Heater\",C25<>\"Boiler Fuel Economizer\",C25<>\"Pipe Wrap Insulation\",J25=\"\")=TRUE,AND(C25=\"Pipe Wrap Insulation\",OR(L25=\"\",M25=\"\")=TRUE)=TRUE,AND(A25=\"GH31\",L25>0.5)=TRUE,AND(A25=\"GH32\",L25<=0.5)=TRUE,G25<VLOOKUP(A25,MeasureCode_Lookup,4,FALSE),G25>VLOOKUP(A25,MeasureCode_Lookup,5,FALSE),J25<VLOOKUP(A25,MeasureCode_Lookup,6,FALSE),AND(C25=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G25*VLOOKUP(A25,MeasureCode_Lookup,8,FALSE),VLOOKUP(A25,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C26=\"Infrared Heater\",C26=\"Boiler Fuel Economizer\",C26=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A26=\"\",C26=\"\",F26=\"\",G26=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G26,Table!$D$2:$D$6,1),MATCH(C26&\": \"&F26,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C26=\"Infrared Heater\",C26=\"Boiler Fuel Economizer\",C26=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A26=\"\",C26=\"\",F26=\"\",G26=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G26,Table!$D$2:$D$6,1),MATCH(C26&\": \"&F26,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A26=\"\",AND(G26=\"\",C26<>\"Pipe Wrap Insulation\")=TRUE,AND(C26<>\"Infrared Heater\",C26<>\"Boiler Fuel Economizer\",C26<>\"Pipe Wrap Insulation\",J26=\"\")=TRUE,AND(C26=\"Pipe Wrap Insulation\",OR(L26=\"\",M26=\"\")=TRUE)=TRUE,AND(A26=\"GH31\",L26>0.5)=TRUE,AND(A26=\"GH32\",L26<=0.5)=TRUE,G26<VLOOKUP(A26,MeasureCode_Lookup,4,FALSE),G26>VLOOKUP(A26,MeasureCode_Lookup,5,FALSE),J26<VLOOKUP(A26,MeasureCode_Lookup,6,FALSE),AND(C26=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G26*VLOOKUP(A26,MeasureCode_Lookup,8,FALSE),VLOOKUP(A26,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C27=\"Infrared Heater\",C27=\"Boiler Fuel Economizer\",C27=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A27=\"\",C27=\"\",F27=\"\",G27=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G27,Table!$D$2:$D$6,1),MATCH(C27&\": \"&F27,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C27=\"Infrared Heater\",C27=\"Boiler Fuel Economizer\",C27=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A27=\"\",C27=\"\",F27=\"\",G27=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G27,Table!$D$2:$D$6,1),MATCH(C27&\": \"&F27,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A27=\"\",AND(G27=\"\",C27<>\"Pipe Wrap Insulation\")=TRUE,AND(C27<>\"Infrared Heater\",C27<>\"Boiler Fuel Economizer\",C27<>\"Pipe Wrap Insulation\",J27=\"\")=TRUE,AND(C27=\"Pipe Wrap Insulation\",OR(L27=\"\",M27=\"\")=TRUE)=TRUE,AND(A27=\"GH31\",L27>0.5)=TRUE,AND(A27=\"GH32\",L27<=0.5)=TRUE,G27<VLOOKUP(A27,MeasureCode_Lookup,4,FALSE),G27>VLOOKUP(A27,MeasureCode_Lookup,5,FALSE),J27<VLOOKUP(A27,MeasureCode_Lookup,6,FALSE),AND(C27=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G27*VLOOKUP(A27,MeasureCode_Lookup,8,FALSE),VLOOKUP(A27,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C28=\"Infrared Heater\",C28=\"Boiler Fuel Economizer\",C28=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A28=\"\",C28=\"\",F28=\"\",G28=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G28,Table!$D$2:$D$6,1),MATCH(C28&\": \"&F28,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C28=\"Infrared Heater\",C28=\"Boiler Fuel Economizer\",C28=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A28=\"\",C28=\"\",F28=\"\",G28=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G28,Table!$D$2:$D$6,1),MATCH(C28&\": \"&F28,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A28=\"\",AND(G28=\"\",C28<>\"Pipe Wrap Insulation\")=TRUE,AND(C28<>\"Infrared Heater\",C28<>\"Boiler Fuel Economizer\",C28<>\"Pipe Wrap Insulation\",J28=\"\")=TRUE,AND(C28=\"Pipe Wrap Insulation\",OR(L28=\"\",M28=\"\")=TRUE)=TRUE,AND(A28=\"GH31\",L28>0.5)=TRUE,AND(A28=\"GH32\",L28<=0.5)=TRUE,G28<VLOOKUP(A28,MeasureCode_Lookup,4,FALSE),G28>VLOOKUP(A28,MeasureCode_Lookup,5,FALSE),J28<VLOOKUP(A28,MeasureCode_Lookup,6,FALSE),AND(C28=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G28*VLOOKUP(A28,MeasureCode_Lookup,8,FALSE),VLOOKUP(A28,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C29=\"Infrared Heater\",C29=\"Boiler Fuel Economizer\",C29=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A29=\"\",C29=\"\",F29=\"\",G29=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G29,Table!$D$2:$D$6,1),MATCH(C29&\": \"&F29,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C29=\"Infrared Heater\",C29=\"Boiler Fuel Economizer\",C29=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A29=\"\",C29=\"\",F29=\"\",G29=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G29,Table!$D$2:$D$6,1),MATCH(C29&\": \"&F29,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A29=\"\",AND(G29=\"\",C29<>\"Pipe Wrap Insulation\")=TRUE,AND(C29<>\"Infrared Heater\",C29<>\"Boiler Fuel Economizer\",C29<>\"Pipe Wrap Insulation\",J29=\"\")=TRUE,AND(C29=\"Pipe Wrap Insulation\",OR(L29=\"\",M29=\"\")=TRUE)=TRUE,AND(A29=\"GH31\",L29>0.5)=TRUE,AND(A29=\"GH32\",L29<=0.5)=TRUE,G29<VLOOKUP(A29,MeasureCode_Lookup,4,FALSE),G29>VLOOKUP(A29,MeasureCode_Lookup,5,FALSE),J29<VLOOKUP(A29,MeasureCode_Lookup,6,FALSE),AND(C29=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G29*VLOOKUP(A29,MeasureCode_Lookup,8,FALSE),VLOOKUP(A29,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C30=\"Infrared Heater\",C30=\"Boiler Fuel Economizer\",C30=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A30=\"\",C30=\"\",F30=\"\",G30=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G30,Table!$D$2:$D$6,1),MATCH(C30&\": \"&F30,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C30=\"Infrared Heater\",C30=\"Boiler Fuel Economizer\",C30=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A30=\"\",C30=\"\",F30=\"\",G30=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G30,Table!$D$2:$D$6,1),MATCH(C30&\": \"&F30,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A30=\"\",AND(G30=\"\",C30<>\"Pipe Wrap Insulation\")=TRUE,AND(C30<>\"Infrared Heater\",C30<>\"Boiler Fuel Economizer\",C30<>\"Pipe Wrap Insulation\",J30=\"\")=TRUE,AND(C30=\"Pipe Wrap Insulation\",OR(L30=\"\",M30=\"\")=TRUE)=TRUE,AND(A30=\"GH31\",L30>0.5)=TRUE,AND(A30=\"GH32\",L30<=0.5)=TRUE,G30<VLOOKUP(A30,MeasureCode_Lookup,4,FALSE),G30>VLOOKUP(A30,MeasureCode_Lookup,5,FALSE),J30<VLOOKUP(A30,MeasureCode_Lookup,6,FALSE),AND(C30=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G30*VLOOKUP(A30,MeasureCode_Lookup,8,FALSE),VLOOKUP(A30,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C31=\"Infrared Heater\",C31=\"Boiler Fuel Economizer\",C31=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A31=\"\",C31=\"\",F31=\"\",G31=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G31,Table!$D$2:$D$6,1),MATCH(C31&\": \"&F31,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C31=\"Infrared Heater\",C31=\"Boiler Fuel Economizer\",C31=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A31=\"\",C31=\"\",F31=\"\",G31=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G31,Table!$D$2:$D$6,1),MATCH(C31&\": \"&F31,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A31=\"\",AND(G31=\"\",C31<>\"Pipe Wrap Insulation\")=TRUE,AND(C31<>\"Infrared Heater\",C31<>\"Boiler Fuel Economizer\",C31<>\"Pipe Wrap Insulation\",J31=\"\")=TRUE,AND(C31=\"Pipe Wrap Insulation\",OR(L31=\"\",M31=\"\")=TRUE)=TRUE,AND(A31=\"GH31\",L31>0.5)=TRUE,AND(A31=\"GH32\",L31<=0.5)=TRUE,G31<VLOOKUP(A31,MeasureCode_Lookup,4,FALSE),G31>VLOOKUP(A31,MeasureCode_Lookup,5,FALSE),J31<VLOOKUP(A31,MeasureCode_Lookup,6,FALSE),AND(C31=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G31*VLOOKUP(A31,MeasureCode_Lookup,8,FALSE),VLOOKUP(A31,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C32=\"Infrared Heater\",C32=\"Boiler Fuel Economizer\",C32=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A32=\"\",C32=\"\",F32=\"\",G32=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G32,Table!$D$2:$D$6,1),MATCH(C32&\": \"&F32,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C32=\"Infrared Heater\",C32=\"Boiler Fuel Economizer\",C32=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A32=\"\",C32=\"\",F32=\"\",G32=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G32,Table!$D$2:$D$6,1),MATCH(C32&\": \"&F32,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A32=\"\",AND(G32=\"\",C32<>\"Pipe Wrap Insulation\")=TRUE,AND(C32<>\"Infrared Heater\",C32<>\"Boiler Fuel Economizer\",C32<>\"Pipe Wrap Insulation\",J32=\"\")=TRUE,AND(C32=\"Pipe Wrap Insulation\",OR(L32=\"\",M32=\"\")=TRUE)=TRUE,AND(A32=\"GH31\",L32>0.5)=TRUE,AND(A32=\"GH32\",L32<=0.5)=TRUE,G32<VLOOKUP(A32,MeasureCode_Lookup,4,FALSE),G32>VLOOKUP(A32,MeasureCode_Lookup,5,FALSE),J32<VLOOKUP(A32,MeasureCode_Lookup,6,FALSE),AND(C32=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G32*VLOOKUP(A32,MeasureCode_Lookup,8,FALSE),VLOOKUP(A32,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C33=\"Infrared Heater\",C33=\"Boiler Fuel Economizer\",C33=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A33=\"\",C33=\"\",F33=\"\",G33=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G33,Table!$D$2:$D$6,1),MATCH(C33&\": \"&F33,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C33=\"Infrared Heater\",C33=\"Boiler Fuel Economizer\",C33=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A33=\"\",C33=\"\",F33=\"\",G33=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G33,Table!$D$2:$D$6,1),MATCH(C33&\": \"&F33,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A33=\"\",AND(G33=\"\",C33<>\"Pipe Wrap Insulation\")=TRUE,AND(C33<>\"Infrared Heater\",C33<>\"Boiler Fuel Economizer\",C33<>\"Pipe Wrap Insulation\",J33=\"\")=TRUE,AND(C33=\"Pipe Wrap Insulation\",OR(L33=\"\",M33=\"\")=TRUE)=TRUE,AND(A33=\"GH31\",L33>0.5)=TRUE,AND(A33=\"GH32\",L33<=0.5)=TRUE,G33<VLOOKUP(A33,MeasureCode_Lookup,4,FALSE),G33>VLOOKUP(A33,MeasureCode_Lookup,5,FALSE),J33<VLOOKUP(A33,MeasureCode_Lookup,6,FALSE),AND(C33=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G33*VLOOKUP(A33,MeasureCode_Lookup,8,FALSE),VLOOKUP(A33,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C34=\"Infrared Heater\",C34=\"Boiler Fuel Economizer\",C34=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A34=\"\",C34=\"\",F34=\"\",G34=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G34,Table!$D$2:$D$6,1),MATCH(C34&\": \"&F34,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C34=\"Infrared Heater\",C34=\"Boiler Fuel Economizer\",C34=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A34=\"\",C34=\"\",F34=\"\",G34=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G34,Table!$D$2:$D$6,1),MATCH(C34&\": \"&F34,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A34=\"\",AND(G34=\"\",C34<>\"Pipe Wrap Insulation\")=TRUE,AND(C34<>\"Infrared Heater\",C34<>\"Boiler Fuel Economizer\",C34<>\"Pipe Wrap Insulation\",J34=\"\")=TRUE,AND(C34=\"Pipe Wrap Insulation\",OR(L34=\"\",M34=\"\")=TRUE)=TRUE,AND(A34=\"GH31\",L34>0.5)=TRUE,AND(A34=\"GH32\",L34<=0.5)=TRUE,G34<VLOOKUP(A34,MeasureCode_Lookup,4,FALSE),G34>VLOOKUP(A34,MeasureCode_Lookup,5,FALSE),J34<VLOOKUP(A34,MeasureCode_Lookup,6,FALSE),AND(C34=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G34*VLOOKUP(A34,MeasureCode_Lookup,8,FALSE),VLOOKUP(A34,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C35=\"Infrared Heater\",C35=\"Boiler Fuel Economizer\",C35=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A35=\"\",C35=\"\",F35=\"\",G35=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G35,Table!$D$2:$D$6,1),MATCH(C35&\": \"&F35,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C35=\"Infrared Heater\",C35=\"Boiler Fuel Economizer\",C35=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A35=\"\",C35=\"\",F35=\"\",G35=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G35,Table!$D$2:$D$6,1),MATCH(C35&\": \"&F35,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A35=\"\",AND(G35=\"\",C35<>\"Pipe Wrap Insulation\")=TRUE,AND(C35<>\"Infrared Heater\",C35<>\"Boiler Fuel Economizer\",C35<>\"Pipe Wrap Insulation\",J35=\"\")=TRUE,AND(C35=\"Pipe Wrap Insulation\",OR(L35=\"\",M35=\"\")=TRUE)=TRUE,AND(A35=\"GH31\",L35>0.5)=TRUE,AND(A35=\"GH32\",L35<=0.5)=TRUE,G35<VLOOKUP(A35,MeasureCode_Lookup,4,FALSE),G35>VLOOKUP(A35,MeasureCode_Lookup,5,FALSE),J35<VLOOKUP(A35,MeasureCode_Lookup,6,FALSE),AND(C35=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G35*VLOOKUP(A35,MeasureCode_Lookup,8,FALSE),VLOOKUP(A35,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C36=\"Infrared Heater\",C36=\"Boiler Fuel Economizer\",C36=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A36=\"\",C36=\"\",F36=\"\",G36=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G36,Table!$D$2:$D$6,1),MATCH(C36&\": \"&F36,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C36=\"Infrared Heater\",C36=\"Boiler Fuel Economizer\",C36=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A36=\"\",C36=\"\",F36=\"\",G36=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G36,Table!$D$2:$D$6,1),MATCH(C36&\": \"&F36,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A36=\"\",AND(G36=\"\",C36<>\"Pipe Wrap Insulation\")=TRUE,AND(C36<>\"Infrared Heater\",C36<>\"Boiler Fuel Economizer\",C36<>\"Pipe Wrap Insulation\",J36=\"\")=TRUE,AND(C36=\"Pipe Wrap Insulation\",OR(L36=\"\",M36=\"\")=TRUE)=TRUE,AND(A36=\"GH31\",L36>0.5)=TRUE,AND(A36=\"GH32\",L36<=0.5)=TRUE,G36<VLOOKUP(A36,MeasureCode_Lookup,4,FALSE),G36>VLOOKUP(A36,MeasureCode_Lookup,5,FALSE),J36<VLOOKUP(A36,MeasureCode_Lookup,6,FALSE),AND(C36=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G36*VLOOKUP(A36,MeasureCode_Lookup,8,FALSE),VLOOKUP(A36,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C37=\"Infrared Heater\",C37=\"Boiler Fuel Economizer\",C37=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A37=\"\",C37=\"\",F37=\"\",G37=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G37,Table!$D$2:$D$6,1),MATCH(C37&\": \"&F37,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C37=\"Infrared Heater\",C37=\"Boiler Fuel Economizer\",C37=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A37=\"\",C37=\"\",F37=\"\",G37=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G37,Table!$D$2:$D$6,1),MATCH(C37&\": \"&F37,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A37=\"\",AND(G37=\"\",C37<>\"Pipe Wrap Insulation\")=TRUE,AND(C37<>\"Infrared Heater\",C37<>\"Boiler Fuel Economizer\",C37<>\"Pipe Wrap Insulation\",J37=\"\")=TRUE,AND(C37=\"Pipe Wrap Insulation\",OR(L37=\"\",M37=\"\")=TRUE)=TRUE,AND(A37=\"GH31\",L37>0.5)=TRUE,AND(A37=\"GH32\",L37<=0.5)=TRUE,G37<VLOOKUP(A37,MeasureCode_Lookup,4,FALSE),G37>VLOOKUP(A37,MeasureCode_Lookup,5,FALSE),J37<VLOOKUP(A37,MeasureCode_Lookup,6,FALSE),AND(C37=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G37*VLOOKUP(A37,MeasureCode_Lookup,8,FALSE),VLOOKUP(A37,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C38=\"Infrared Heater\",C38=\"Boiler Fuel Economizer\",C38=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A38=\"\",C38=\"\",F38=\"\",G38=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G38,Table!$D$2:$D$6,1),MATCH(C38&\": \"&F38,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C38=\"Infrared Heater\",C38=\"Boiler Fuel Economizer\",C38=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A38=\"\",C38=\"\",F38=\"\",G38=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G38,Table!$D$2:$D$6,1),MATCH(C38&\": \"&F38,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A38=\"\",AND(G38=\"\",C38<>\"Pipe Wrap Insulation\")=TRUE,AND(C38<>\"Infrared Heater\",C38<>\"Boiler Fuel Economizer\",C38<>\"Pipe Wrap Insulation\",J38=\"\")=TRUE,AND(C38=\"Pipe Wrap Insulation\",OR(L38=\"\",M38=\"\")=TRUE)=TRUE,AND(A38=\"GH31\",L38>0.5)=TRUE,AND(A38=\"GH32\",L38<=0.5)=TRUE,G38<VLOOKUP(A38,MeasureCode_Lookup,4,FALSE),G38>VLOOKUP(A38,MeasureCode_Lookup,5,FALSE),J38<VLOOKUP(A38,MeasureCode_Lookup,6,FALSE),AND(C38=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G38*VLOOKUP(A38,MeasureCode_Lookup,8,FALSE),VLOOKUP(A38,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C39=\"Infrared Heater\",C39=\"Boiler Fuel Economizer\",C39=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A39=\"\",C39=\"\",F39=\"\",G39=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G39,Table!$D$2:$D$6,1),MATCH(C39&\": \"&F39,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C39=\"Infrared Heater\",C39=\"Boiler Fuel Economizer\",C39=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A39=\"\",C39=\"\",F39=\"\",G39=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G39,Table!$D$2:$D$6,1),MATCH(C39&\": \"&F39,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A39=\"\",AND(G39=\"\",C39<>\"Pipe Wrap Insulation\")=TRUE,AND(C39<>\"Infrared Heater\",C39<>\"Boiler Fuel Economizer\",C39<>\"Pipe Wrap Insulation\",J39=\"\")=TRUE,AND(C39=\"Pipe Wrap Insulation\",OR(L39=\"\",M39=\"\")=TRUE)=TRUE,AND(A39=\"GH31\",L39>0.5)=TRUE,AND(A39=\"GH32\",L39<=0.5)=TRUE,G39<VLOOKUP(A39,MeasureCode_Lookup,4,FALSE),G39>VLOOKUP(A39,MeasureCode_Lookup,5,FALSE),J39<VLOOKUP(A39,MeasureCode_Lookup,6,FALSE),AND(C39=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G39*VLOOKUP(A39,MeasureCode_Lookup,8,FALSE),VLOOKUP(A39,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]
[null,"N","",null,null,"",null,0,{"$f":"IF(OR(C40=\"Infrared Heater\",C40=\"Boiler Fuel Economizer\",C40=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A40=\"\",C40=\"\",F40=\"\",G40=\"\")=TRUE,\"\",INDEX(BF_BaselineTable,MATCH(G40,Table!$D$2:$D$6,1),MATCH(C40&\": \"&F40,Table!$D$2:$I$2,0))))","v":""},null,{"$f":"IF(OR(C40=\"Infrared Heater\",C40=\"Boiler Fuel Economizer\",C40=\"Pipe Wrap Insulation\")=TRUE,\"N/A\",IF(OR(A40=\"\",C40=\"\",F40=\"\",G40=\"\")=TRUE,\"\",INDEX(BF_EffUnitsTable,MATCH(G40,Table!$D$2:$D$6,1),MATCH(C40&\": \"&F40,Table!$D$2:$I$2,0))))","v":""},null,null,null,null,{"$f":"IFERROR(IF(OR($C$14=\"\",$G$14=\"\",A40=\"\",AND(G40=\"\",C40<>\"Pipe Wrap Insulation\")=TRUE,AND(C40<>\"Infrared Heater\",C40<>\"Boiler Fuel Economizer\",C40<>\"Pipe Wrap Insulation\",J40=\"\")=TRUE,AND(C40=\"Pipe Wrap Insulation\",OR(L40=\"\",M40=\"\")=TRUE)=TRUE,AND(A40=\"GH31\",L40>0.5)=TRUE,AND(A40=\"GH32\",L40<=0.5)=TRUE,G40<VLOOKUP(A40,MeasureCode_Lookup,4,FALSE),G40>VLOOKUP(A40,MeasureCode_Lookup,5,FALSE),J40<VLOOKUP(A40,MeasureCode_Lookup,6,FALSE),AND(C40=\"Boiler Fuel Economizer\",$C$14<>\"Existing Building\"))=TRUE,0,MAX(G40*VLOOKUP(A40,MeasureCode_Lookup,8,FALSE),VLOOKUP(A40,MeasureCode_Lookup,9,FALSE))),0)","v":0},0,0,0,0,0,0,0]

{"sheet":"Measure Code","index":1,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Type","Boiler Type","Min Capacity (MBH)","Max Capacity (MBH)","Min Eligible Efficiency","Efficiency Units","Incentive $/MBH","Min Incentive per Unit","Measure Life"]
["GH1","Hot Water Boiler","Non-Condensing",0.01,299.99,0.85,"AFUE",0.95,400,20]
["GH2","Hot Water Boiler","Non-Condensing",300,1500,0.85,"Et",1.75,0,20]
["GH3","Hot Water Boiler","Non-Condensing",1500.01,2500,0.85,"Et",1.5,0,20]
["GH4","Hot Water Boiler","Non-Condensing",2500.0100000000002,4000,0.85,"Ec",1.3,0,20]
["GH5","Steam Boiler","Non-Natural Draft",0.01,299.99,0.82,"AFUE",1.4,400,20]
["GH6","Steam Boiler","Non-Natural Draft",300,1500,0.81,"Et",1.2,0,20]
["GH7","Steam Boiler","Non-Natural Draft",1500.01,2500,0.81,"Et",1.2,0,20]
["GH8","Steam Boiler","Non-Natural Draft",2500.0100000000002,4000,0.81,"Et",1,0,20]
["GH9","Steam Boiler","Natural Draft",0.01,299.99,0.82,"AFUE",1.4,300,20]
["GH10","Steam Boiler","Natural Draft",300,1500,0.79,"Et",1,0,20]
["GH11","Steam Boiler","Natural Draft",1500.01,2500,0.79,"Et",0.9,0,20]
["GH12","Steam Boiler","Natural Draft",2500.0100000000002,4000,0.79,"Et",0.7,0,20]
["GH13","Hot Water Boiler","Condensing",0.01,299.99,0.93,"AFUE",2,1000,20]
["GH14","Hot Water Boiler","Condensing",300,1500,0.91,"Et",2.2000000000000002,1000,20]
["GH15","Hot Water Boiler","Condensing",1500.01,2500,0.91,"Et",2.2000000000000002,0,20]
["GH16","Hot Water Boiler","Condensing",2500.0100000000002,4000,0.93,"Ec",2,0,20]
["GH17","Hot Water Boiler","Condensing",0.01,299.99,0.88,"AFUE",1.35,1000,20]
["GH18","Hot Water Boiler","Condensing",300,1500,0.88,"Et",2,1000,20]
["GH19","Hot Water Boiler","Condensing",1500.01,2500,0.88,"Et",1.85,0,20]
["GH20","Hot Water Boiler","Condensing",2500.0100000000002,4000,0.88,"Ec",1.55,0,20]
["GH21","Furnace","N/A",0.01,999999,0.95,"AFUE",0,400,20]
["GH22","Furnace","N/A",0.01,999999,0.97,"AFUE",0,500,20]
["GH23","Infrared Heater","N/A",0.01,100,0,"N/A",0,500,17]
["GH24","Infrared Heater","N/A",100.01,999999,0,"N/A",0,300,17]
["GH25","Boiler Fuel Economizer","N/A",0.01,800,0,"N/A",0,1200,15]
["GH26","Boiler Fuel Economizer","N/A",800.01,1599.99,0,"N/A",0,1500,15]
["GH27","Boiler Fuel Economizer","N/A",1600,2999.99,0,"N/A",0,1800,15]
["GH28","Boiler Fuel Economizer","N/A",3000,3499.99,0,"N/A",0,2100,15]
["GH29","Boiler Fuel Economizer","N/A",3500,3999.99,0,"N/A",0,2400,15]
["GH30","Boiler Fuel Economizer","N/A",4000,999999,0,"N/A",0,2700,15]
["GH31","Pipe Wrap Insulation","N/A",0,999999,0,"N/A",0,1,11]
["GH32","Pipe Wrap Insulation","N/A",0,999999,0,"N/A",0,2,11]

{"sheet":"Table","index":2,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,3,0,8],[7,3,7,8],[15,3,16,3],[15,4,15,7],[14,3,14,7]]}
["Facility Type","Heating EFLH",null,"Boiler/Furnace Baseline Efficiencies",null,null,null,null,null,null,"Types"]
["Assembly",603,null,"MBH","Hot Water Boiler: Non-Condensing","Hot Water Boiler: Condensing","Steam Boiler: Non-Natural Draft","Steam Boiler: Natural Draft","Furnace: N/A",null,"Boiler Fuel EconomizerN/A",274]
["Auto repair",1910,null,0,0.82,0.82,0.8,0.8,0.78,null,"Boiler Fuel EconomizerN/A",275]
["Dormitory",465,null,225,0.82,0.82,0.8,0.8,0.8,null,"FurnaceN/A",11]
["Hospital",3366,null,300,0.8,0.8,0.79,0.77,0.8,null,"Hot Water BoilerCondensing",81]
["Light industrial",714,null,2500,0.82,0.82,0.79,0.77,0.8,null,"Hot Water BoilerNon-Condensing",81]
["Lodging – Hotel",1077,null,null,null,null,null,null,null,null,"Infrared HeaterN/A",240]
["Lodging – Motel",619,null,"Boiler/Furnace Efficiency Units",null,null,null,null,null,null,"Steam BoilerNatural Draft",82]
["Office – large",2034,null,"MBH","Hot Water Boiler: Non-Condensing","Hot Water Boiler: Condensing","Steam Boiler: Non-Natural Draft","Steam Boiler: Natural Draft","Furnace: N/A",null,"Steam BoilerNon-Natural Draft",82]
["Office – small",431,null,0,"AFUE","AFUE","AFUE","AFUE","AFUE",null,"Pipe Wrap InsulationN/A",243]
["Other",681,null,225,"AFUE","AFUE","AFUE","AFUE","Ec"]
["Religious worship",722,null,300,"Et","Et","Et","Et","Ec"]
["Restaurant – fast food",813,null,2500,"Ec","Ec","Ec","Ec","Ec"]
["Restaurant – full service",821]
["Retail – big box",191,null,"Pipe Wrap Insulation Savings (Btu/hr-ft)"]
["Retail – Grocery",191,null,"Pipe Diameter\n(in)","Insulation Thickness (in)"]
["Retail – small",545,null,null,0.5,1,1.5,2]
["Retail – large",2101,null,0.5,47,53,56,57]
["School – Community college",1431,null,0.75,58,64,68,70]
["School – postsecondary",1191,null,1,72,82,85,87]
["School – primary",840,null,1.25,89,100,107,108]
["School – secondary",901,null,1.5,100,115,120,125]
["Warehouse",452,null,2,128,143,148,153]
["Multifamily: Low-rise, Prior to 1979",757,null,2.5,153,171,182,185]
["Multifamily: Low-rise, From 1979 to 2006",723,null,3,195,221,230,236]
["Multifamily: Low-rise, From 2007 through present",503,null,3.5,224,241,248,253]
["Multifamily: High-rise, Prior to 1979",526,null,4,232,263,274,281]
["Multifamily: High-rise, From 1979 to 2006",395]
["Multifamily: High-rise, From 2007 through present",219]

{"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":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C16,Worksheet!F16),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D16) = FALSE,Worksheet!D16,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E16) = FALSE,Worksheet!E16,\"\")","v":""},{"$f":"IF(OR(Worksheet!A16=\"GH30\",Worksheet!A16=\"GH31\")=TRUE,IF(Worksheet!M16=\"\",\"\",Worksheet!M16),IF(Worksheet!G16=\"\",\"\",Worksheet!G16))","v":""},{"$f":"IF(OR(Worksheet!A16=\"GH30\",Worksheet!A16=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P16) = FALSE,Worksheet!P16,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N16) = FALSE,Worksheet!N16,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N16)=FALSE,Worksheet!T16/Worksheet!N16,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N16)=FALSE,Worksheet!V16/Worksheet!N16,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J16) = FALSE,Worksheet!J16,\"\")","v":""},{"$f":"Worksheet!K16","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O16) = FALSE,Worksheet!O16,\"\")","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!Q16,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C17,Worksheet!F17),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D17) = FALSE,Worksheet!D17,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E17) = FALSE,Worksheet!E17,\"\")","v":""},{"$f":"IF(OR(Worksheet!A17=\"GH30\",Worksheet!A17=\"GH31\")=TRUE,IF(Worksheet!M17=\"\",\"\",Worksheet!M17),IF(Worksheet!G17=\"\",\"\",Worksheet!G17))","v":""},{"$f":"IF(OR(Worksheet!A17=\"GH30\",Worksheet!A17=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P17) = FALSE,Worksheet!P17,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N17) = FALSE,Worksheet!N17,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N17)=FALSE,Worksheet!T17/Worksheet!N17,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N17)=FALSE,Worksheet!V17/Worksheet!N17,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J17) = FALSE,Worksheet!J17,\"\")","v":""},{"$f":"Worksheet!K17","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O17) = FALSE,Worksheet!O17,\"\")","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!Q17,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C18,Worksheet!F18),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D18) = FALSE,Worksheet!D18,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E18) = FALSE,Worksheet!E18,\"\")","v":""},{"$f":"IF(OR(Worksheet!A18=\"GH30\",Worksheet!A18=\"GH31\")=TRUE,IF(Worksheet!M18=\"\",\"\",Worksheet!M18),IF(Worksheet!G18=\"\",\"\",Worksheet!G18))","v":""},{"$f":"IF(OR(Worksheet!A18=\"GH30\",Worksheet!A18=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P18) = FALSE,Worksheet!P18,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N18) = FALSE,Worksheet!N18,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N18)=FALSE,Worksheet!T18/Worksheet!N18,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N18)=FALSE,Worksheet!V18/Worksheet!N18,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J18) = FALSE,Worksheet!J18,\"\")","v":""},{"$f":"Worksheet!K18","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O18) = FALSE,Worksheet!O18,\"\")","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!Q18,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C19,Worksheet!F19),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D19) = FALSE,Worksheet!D19,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E19) = FALSE,Worksheet!E19,\"\")","v":""},{"$f":"IF(OR(Worksheet!A19=\"GH30\",Worksheet!A19=\"GH31\")=TRUE,IF(Worksheet!M19=\"\",\"\",Worksheet!M19),IF(Worksheet!G19=\"\",\"\",Worksheet!G19))","v":""},{"$f":"IF(OR(Worksheet!A19=\"GH30\",Worksheet!A19=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P19) = FALSE,Worksheet!P19,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N19) = FALSE,Worksheet!N19,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N19)=FALSE,Worksheet!T19/Worksheet!N19,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N19)=FALSE,Worksheet!V19/Worksheet!N19,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J19) = FALSE,Worksheet!J19,\"\")","v":""},{"$f":"Worksheet!K19","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O19) = FALSE,Worksheet!O19,\"\")","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!Q19,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C20,Worksheet!F20),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D20) = FALSE,Worksheet!D20,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E20) = FALSE,Worksheet!E20,\"\")","v":""},{"$f":"IF(OR(Worksheet!A20=\"GH30\",Worksheet!A20=\"GH31\")=TRUE,IF(Worksheet!M20=\"\",\"\",Worksheet!M20),IF(Worksheet!G20=\"\",\"\",Worksheet!G20))","v":""},{"$f":"IF(OR(Worksheet!A20=\"GH30\",Worksheet!A20=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P20) = FALSE,Worksheet!P20,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N20) = FALSE,Worksheet!N20,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N20)=FALSE,Worksheet!T20/Worksheet!N20,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N20)=FALSE,Worksheet!V20/Worksheet!N20,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J20) = FALSE,Worksheet!J20,\"\")","v":""},{"$f":"Worksheet!K20","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O20) = FALSE,Worksheet!O20,\"\")","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!Q20,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C21,Worksheet!F21),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D21) = FALSE,Worksheet!D21,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E21) = FALSE,Worksheet!E21,\"\")","v":""},{"$f":"IF(OR(Worksheet!A21=\"GH30\",Worksheet!A21=\"GH31\")=TRUE,IF(Worksheet!M21=\"\",\"\",Worksheet!M21),IF(Worksheet!G21=\"\",\"\",Worksheet!G21))","v":""},{"$f":"IF(OR(Worksheet!A21=\"GH30\",Worksheet!A21=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P21) = FALSE,Worksheet!P21,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N21) = FALSE,Worksheet!N21,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N21)=FALSE,Worksheet!T21/Worksheet!N21,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N21)=FALSE,Worksheet!V21/Worksheet!N21,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J21) = FALSE,Worksheet!J21,\"\")","v":""},{"$f":"Worksheet!K21","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O21) = FALSE,Worksheet!O21,\"\")","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!Q21,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C22,Worksheet!F22),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D22) = FALSE,Worksheet!D22,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E22) = FALSE,Worksheet!E22,\"\")","v":""},{"$f":"IF(OR(Worksheet!A22=\"GH30\",Worksheet!A22=\"GH31\")=TRUE,IF(Worksheet!M22=\"\",\"\",Worksheet!M22),IF(Worksheet!G22=\"\",\"\",Worksheet!G22))","v":""},{"$f":"IF(OR(Worksheet!A22=\"GH30\",Worksheet!A22=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P22) = FALSE,Worksheet!P22,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N22) = FALSE,Worksheet!N22,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N22)=FALSE,Worksheet!T22/Worksheet!N22,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N22)=FALSE,Worksheet!V22/Worksheet!N22,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J22) = FALSE,Worksheet!J22,\"\")","v":""},{"$f":"Worksheet!K22","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O22) = FALSE,Worksheet!O22,\"\")","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!Q22,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C23,Worksheet!F23),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D23) = FALSE,Worksheet!D23,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E23) = FALSE,Worksheet!E23,\"\")","v":""},{"$f":"IF(OR(Worksheet!A23=\"GH30\",Worksheet!A23=\"GH31\")=TRUE,IF(Worksheet!M23=\"\",\"\",Worksheet!M23),IF(Worksheet!G23=\"\",\"\",Worksheet!G23))","v":""},{"$f":"IF(OR(Worksheet!A23=\"GH30\",Worksheet!A23=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P23) = FALSE,Worksheet!P23,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N23) = FALSE,Worksheet!N23,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N23)=FALSE,Worksheet!T23/Worksheet!N23,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N23)=FALSE,Worksheet!V23/Worksheet!N23,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J23) = FALSE,Worksheet!J23,\"\")","v":""},{"$f":"Worksheet!K23","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O23) = FALSE,Worksheet!O23,\"\")","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!Q23,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C24,Worksheet!F24),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D24) = FALSE,Worksheet!D24,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E24) = FALSE,Worksheet!E24,\"\")","v":""},{"$f":"IF(OR(Worksheet!A24=\"GH30\",Worksheet!A24=\"GH31\")=TRUE,IF(Worksheet!M24=\"\",\"\",Worksheet!M24),IF(Worksheet!G24=\"\",\"\",Worksheet!G24))","v":""},{"$f":"IF(OR(Worksheet!A24=\"GH30\",Worksheet!A24=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P24) = FALSE,Worksheet!P24,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N24) = FALSE,Worksheet!N24,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N24)=FALSE,Worksheet!T24/Worksheet!N24,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N24)=FALSE,Worksheet!V24/Worksheet!N24,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J24) = FALSE,Worksheet!J24,\"\")","v":""},{"$f":"Worksheet!K24","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O24) = FALSE,Worksheet!O24,\"\")","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!Q24,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C25,Worksheet!F25),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D25) = FALSE,Worksheet!D25,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E25) = FALSE,Worksheet!E25,\"\")","v":""},{"$f":"IF(OR(Worksheet!A25=\"GH30\",Worksheet!A25=\"GH31\")=TRUE,IF(Worksheet!M25=\"\",\"\",Worksheet!M25),IF(Worksheet!G25=\"\",\"\",Worksheet!G25))","v":""},{"$f":"IF(OR(Worksheet!A25=\"GH30\",Worksheet!A25=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P25) = FALSE,Worksheet!P25,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N25) = FALSE,Worksheet!N25,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N25)=FALSE,Worksheet!T25/Worksheet!N25,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N25)=FALSE,Worksheet!V25/Worksheet!N25,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J25) = FALSE,Worksheet!J25,\"\")","v":""},{"$f":"Worksheet!K25","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O25) = FALSE,Worksheet!O25,\"\")","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!Q25,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C26,Worksheet!F26),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D26) = FALSE,Worksheet!D26,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E26) = FALSE,Worksheet!E26,\"\")","v":""},{"$f":"IF(OR(Worksheet!A26=\"GH30\",Worksheet!A26=\"GH31\")=TRUE,IF(Worksheet!M26=\"\",\"\",Worksheet!M26),IF(Worksheet!G26=\"\",\"\",Worksheet!G26))","v":""},{"$f":"IF(OR(Worksheet!A26=\"GH30\",Worksheet!A26=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P26) = FALSE,Worksheet!P26,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N26) = FALSE,Worksheet!N26,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N26)=FALSE,Worksheet!T26/Worksheet!N26,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N26)=FALSE,Worksheet!V26/Worksheet!N26,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J26) = FALSE,Worksheet!J26,\"\")","v":""},{"$f":"Worksheet!K26","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O26) = FALSE,Worksheet!O26,\"\")","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!Q26,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C27,Worksheet!F27),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D27) = FALSE,Worksheet!D27,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E27) = FALSE,Worksheet!E27,\"\")","v":""},{"$f":"IF(OR(Worksheet!A27=\"GH30\",Worksheet!A27=\"GH31\")=TRUE,IF(Worksheet!M27=\"\",\"\",Worksheet!M27),IF(Worksheet!G27=\"\",\"\",Worksheet!G27))","v":""},{"$f":"IF(OR(Worksheet!A27=\"GH30\",Worksheet!A27=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P27) = FALSE,Worksheet!P27,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N27) = FALSE,Worksheet!N27,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N27)=FALSE,Worksheet!T27/Worksheet!N27,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N27)=FALSE,Worksheet!V27/Worksheet!N27,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J27) = FALSE,Worksheet!J27,\"\")","v":""},{"$f":"Worksheet!K27","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O27) = FALSE,Worksheet!O27,\"\")","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!Q27,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C28,Worksheet!F28),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D28) = FALSE,Worksheet!D28,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E28) = FALSE,Worksheet!E28,\"\")","v":""},{"$f":"IF(OR(Worksheet!A28=\"GH30\",Worksheet!A28=\"GH31\")=TRUE,IF(Worksheet!M28=\"\",\"\",Worksheet!M28),IF(Worksheet!G28=\"\",\"\",Worksheet!G28))","v":""},{"$f":"IF(OR(Worksheet!A28=\"GH30\",Worksheet!A28=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P28) = FALSE,Worksheet!P28,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N28) = FALSE,Worksheet!N28,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N28)=FALSE,Worksheet!T28/Worksheet!N28,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N28)=FALSE,Worksheet!V28/Worksheet!N28,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J28) = FALSE,Worksheet!J28,\"\")","v":""},{"$f":"Worksheet!K28","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O28) = FALSE,Worksheet!O28,\"\")","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!Q28,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C29,Worksheet!F29),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D29) = FALSE,Worksheet!D29,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E29) = FALSE,Worksheet!E29,\"\")","v":""},{"$f":"IF(OR(Worksheet!A29=\"GH30\",Worksheet!A29=\"GH31\")=TRUE,IF(Worksheet!M29=\"\",\"\",Worksheet!M29),IF(Worksheet!G29=\"\",\"\",Worksheet!G29))","v":""},{"$f":"IF(OR(Worksheet!A29=\"GH30\",Worksheet!A29=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P29) = FALSE,Worksheet!P29,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N29) = FALSE,Worksheet!N29,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N29)=FALSE,Worksheet!T29/Worksheet!N29,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N29)=FALSE,Worksheet!V29/Worksheet!N29,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J29) = FALSE,Worksheet!J29,\"\")","v":""},{"$f":"Worksheet!K29","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O29) = FALSE,Worksheet!O29,\"\")","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!Q29,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C30,Worksheet!F30),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D30) = FALSE,Worksheet!D30,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E30) = FALSE,Worksheet!E30,\"\")","v":""},{"$f":"IF(OR(Worksheet!A30=\"GH30\",Worksheet!A30=\"GH31\")=TRUE,IF(Worksheet!M30=\"\",\"\",Worksheet!M30),IF(Worksheet!G30=\"\",\"\",Worksheet!G30))","v":""},{"$f":"IF(OR(Worksheet!A30=\"GH30\",Worksheet!A30=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P30) = FALSE,Worksheet!P30,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N30) = FALSE,Worksheet!N30,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N30)=FALSE,Worksheet!T30/Worksheet!N30,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N30)=FALSE,Worksheet!V30/Worksheet!N30,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J30) = FALSE,Worksheet!J30,\"\")","v":""},{"$f":"Worksheet!K30","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O30) = FALSE,Worksheet!O30,\"\")","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!Q30,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C31,Worksheet!F31),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D31) = FALSE,Worksheet!D31,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E31) = FALSE,Worksheet!E31,\"\")","v":""},{"$f":"IF(OR(Worksheet!A31=\"GH30\",Worksheet!A31=\"GH31\")=TRUE,IF(Worksheet!M31=\"\",\"\",Worksheet!M31),IF(Worksheet!G31=\"\",\"\",Worksheet!G31))","v":""},{"$f":"IF(OR(Worksheet!A31=\"GH30\",Worksheet!A31=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P31) = FALSE,Worksheet!P31,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N31) = FALSE,Worksheet!N31,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N31)=FALSE,Worksheet!T31/Worksheet!N31,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N31)=FALSE,Worksheet!V31/Worksheet!N31,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J31) = FALSE,Worksheet!J31,\"\")","v":""},{"$f":"Worksheet!K31","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O31) = FALSE,Worksheet!O31,\"\")","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!Q31,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C32,Worksheet!F32),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D32) = FALSE,Worksheet!D32,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E32) = FALSE,Worksheet!E32,\"\")","v":""},{"$f":"IF(OR(Worksheet!A32=\"GH30\",Worksheet!A32=\"GH31\")=TRUE,IF(Worksheet!M32=\"\",\"\",Worksheet!M32),IF(Worksheet!G32=\"\",\"\",Worksheet!G32))","v":""},{"$f":"IF(OR(Worksheet!A32=\"GH30\",Worksheet!A32=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P32) = FALSE,Worksheet!P32,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N32) = FALSE,Worksheet!N32,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N32)=FALSE,Worksheet!T32/Worksheet!N32,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N32)=FALSE,Worksheet!V32/Worksheet!N32,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J32) = FALSE,Worksheet!J32,\"\")","v":""},{"$f":"Worksheet!K32","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O32) = FALSE,Worksheet!O32,\"\")","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!Q32,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C33,Worksheet!F33),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D33) = FALSE,Worksheet!D33,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E33) = FALSE,Worksheet!E33,\"\")","v":""},{"$f":"IF(OR(Worksheet!A33=\"GH30\",Worksheet!A33=\"GH31\")=TRUE,IF(Worksheet!M33=\"\",\"\",Worksheet!M33),IF(Worksheet!G33=\"\",\"\",Worksheet!G33))","v":""},{"$f":"IF(OR(Worksheet!A33=\"GH30\",Worksheet!A33=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P33) = FALSE,Worksheet!P33,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N33) = FALSE,Worksheet!N33,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N33)=FALSE,Worksheet!T33/Worksheet!N33,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N33)=FALSE,Worksheet!V33/Worksheet!N33,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J33) = FALSE,Worksheet!J33,\"\")","v":""},{"$f":"Worksheet!K33","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O33) = FALSE,Worksheet!O33,\"\")","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!Q33,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C34,Worksheet!F34),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D34) = FALSE,Worksheet!D34,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E34) = FALSE,Worksheet!E34,\"\")","v":""},{"$f":"IF(OR(Worksheet!A34=\"GH30\",Worksheet!A34=\"GH31\")=TRUE,IF(Worksheet!M34=\"\",\"\",Worksheet!M34),IF(Worksheet!G34=\"\",\"\",Worksheet!G34))","v":""},{"$f":"IF(OR(Worksheet!A34=\"GH30\",Worksheet!A34=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P34) = FALSE,Worksheet!P34,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N34) = FALSE,Worksheet!N34,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N34)=FALSE,Worksheet!T34/Worksheet!N34,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N34)=FALSE,Worksheet!V34/Worksheet!N34,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J34) = FALSE,Worksheet!J34,\"\")","v":""},{"$f":"Worksheet!K34","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O34) = FALSE,Worksheet!O34,\"\")","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!Q34,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C35,Worksheet!F35),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D35) = FALSE,Worksheet!D35,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E35) = FALSE,Worksheet!E35,\"\")","v":""},{"$f":"IF(OR(Worksheet!A35=\"GH30\",Worksheet!A35=\"GH31\")=TRUE,IF(Worksheet!M35=\"\",\"\",Worksheet!M35),IF(Worksheet!G35=\"\",\"\",Worksheet!G35))","v":""},{"$f":"IF(OR(Worksheet!A35=\"GH30\",Worksheet!A35=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P35) = FALSE,Worksheet!P35,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N35) = FALSE,Worksheet!N35,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N35)=FALSE,Worksheet!T35/Worksheet!N35,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N35)=FALSE,Worksheet!V35/Worksheet!N35,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J35) = FALSE,Worksheet!J35,\"\")","v":""},{"$f":"Worksheet!K35","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O35) = FALSE,Worksheet!O35,\"\")","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!Q35,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C36,Worksheet!F36),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D36) = FALSE,Worksheet!D36,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E36) = FALSE,Worksheet!E36,\"\")","v":""},{"$f":"IF(OR(Worksheet!A36=\"GH30\",Worksheet!A36=\"GH31\")=TRUE,IF(Worksheet!M36=\"\",\"\",Worksheet!M36),IF(Worksheet!G36=\"\",\"\",Worksheet!G36))","v":""},{"$f":"IF(OR(Worksheet!A36=\"GH30\",Worksheet!A36=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P36) = FALSE,Worksheet!P36,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N36) = FALSE,Worksheet!N36,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N36)=FALSE,Worksheet!T36/Worksheet!N36,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N36)=FALSE,Worksheet!V36/Worksheet!N36,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J36) = FALSE,Worksheet!J36,\"\")","v":""},{"$f":"Worksheet!K36","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O36) = FALSE,Worksheet!O36,\"\")","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!Q36,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C37,Worksheet!F37),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D37) = FALSE,Worksheet!D37,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E37) = FALSE,Worksheet!E37,\"\")","v":""},{"$f":"IF(OR(Worksheet!A37=\"GH30\",Worksheet!A37=\"GH31\")=TRUE,IF(Worksheet!M37=\"\",\"\",Worksheet!M37),IF(Worksheet!G37=\"\",\"\",Worksheet!G37))","v":""},{"$f":"IF(OR(Worksheet!A37=\"GH30\",Worksheet!A37=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P37) = FALSE,Worksheet!P37,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N37) = FALSE,Worksheet!N37,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N37)=FALSE,Worksheet!T37/Worksheet!N37,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N37)=FALSE,Worksheet!V37/Worksheet!N37,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J37) = FALSE,Worksheet!J37,\"\")","v":""},{"$f":"Worksheet!K37","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O37) = FALSE,Worksheet!O37,\"\")","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!Q37,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C38,Worksheet!F38),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D38) = FALSE,Worksheet!D38,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E38) = FALSE,Worksheet!E38,\"\")","v":""},{"$f":"IF(OR(Worksheet!A38=\"GH30\",Worksheet!A38=\"GH31\")=TRUE,IF(Worksheet!M38=\"\",\"\",Worksheet!M38),IF(Worksheet!G38=\"\",\"\",Worksheet!G38))","v":""},{"$f":"IF(OR(Worksheet!A38=\"GH30\",Worksheet!A38=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P38) = FALSE,Worksheet!P38,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N38) = FALSE,Worksheet!N38,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N38)=FALSE,Worksheet!T38/Worksheet!N38,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N38)=FALSE,Worksheet!V38/Worksheet!N38,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J38) = FALSE,Worksheet!J38,\"\")","v":""},{"$f":"Worksheet!K38","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O38) = FALSE,Worksheet!O38,\"\")","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!Q38,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C39,Worksheet!F39),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D39) = FALSE,Worksheet!D39,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E39) = FALSE,Worksheet!E39,\"\")","v":""},{"$f":"IF(OR(Worksheet!A39=\"GH30\",Worksheet!A39=\"GH31\")=TRUE,IF(Worksheet!M39=\"\",\"\",Worksheet!M39),IF(Worksheet!G39=\"\",\"\",Worksheet!G39))","v":""},{"$f":"IF(OR(Worksheet!A39=\"GH30\",Worksheet!A39=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P39) = FALSE,Worksheet!P39,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N39) = FALSE,Worksheet!N39,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N39)=FALSE,Worksheet!T39/Worksheet!N39,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N39)=FALSE,Worksheet!V39/Worksheet!N39,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J39) = FALSE,Worksheet!J39,\"\")","v":""},{"$f":"Worksheet!K39","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O39) = FALSE,Worksheet!O39,\"\")","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!Q39,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(CONCATENATE(Worksheet!C40,Worksheet!F40),Table!$K$2:$L$10,2,FALSE),\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!D40) = FALSE,Worksheet!D40,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E40) = FALSE,Worksheet!E40,\"\")","v":""},{"$f":"IF(OR(Worksheet!A40=\"GH30\",Worksheet!A40=\"GH31\")=TRUE,IF(Worksheet!M40=\"\",\"\",Worksheet!M40),IF(Worksheet!G40=\"\",\"\",Worksheet!G40))","v":""},{"$f":"IF(OR(Worksheet!A40=\"GH30\",Worksheet!A40=\"GH31\")=TRUE,\"Inches\",\"MBh\")","v":"MBh"},null,null,{"$f":"IF(ISBLANK(Worksheet!P40) = FALSE,Worksheet!P40,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!N40) = FALSE,Worksheet!N40,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!N40)=FALSE,Worksheet!T40/Worksheet!N40,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!N40)=FALSE,Worksheet!V40/Worksheet!N40,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!J40) = FALSE,Worksheet!J40,\"\")","v":""},{"$f":"Worksheet!K40","v":""},null,{"$f":"IF(ISBLANK(Worksheet!O40) = FALSE,Worksheet!O40,\"\")","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!Q40,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Version",null,"Protocol"]
[14,null,"FY21"]
["Log"]
["2007-10-02",null,"Added project information in rows 5-9"]
["2007-10-16",null,"Added manufacturer and model number"]
["2007-01-08",null,"No changes for new protocol"]
["2008-12-01",null,"Updated for compatability with measure tracking"]
["2012-01-13","V5","addition of infrared gas heaters and fuel use economizers for boilers"]
["2012-07-11","V6","Updated efficiency from >= 92 to 95 as per 2012 gas heating incentive cap for gas furnace applications"]
["2013-07-09","V7","no change for V7, skipped V6.. Strange that it is mentioned above"]
["2013-08-06",7.1,"Fixed bug on export tab where per unit savings were being multiplied by committed quantity!"]
["2013-08-07",7.2,"Fixed incorrect savings equation (2011 protocol was incorrect, and the worksheet was never updated for the 2012 protocol)"]
["2013-08-14",7.3,"Fixed incorrect infrared heater savings equation"]
["2015-06-23",9,"updated protocol (7/1/2015) and fixed ir, furnace eqns"]
["2018-06-21",12,"Updated to align with FY19 Protocols"]
["2019-07-01",13,"Added Enhanced Incentive Eligibility Section and Updated for FY20 Program"]
["2020-10-01",14,"Updated for FY21 Program"]