{"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":[[4,1,4,3],[44,10,44,12],[14,19,16,19],[43,10,43,12],[6,19,9,21],[7,5,7,11],[2,13,2,15],[3,13,3,15],[14,18,17,18],[15,17,16,17],[8,5,8,6],[13,5,13,7],[14,13,17,13],[14,14,17,14],[13,13,13,14],[3,1,3,3],[7,1,7,2],[5,1,5,3],[13,1,13,3],[14,23,16,23],[14,21,16,21],[14,22,16,22],[3,20,3,21],[3,18,3,19],[3,5,3,11],[5,19,5,21],[5,22,5,24],[6,22,9,24],[8,1,8,2],[14,24,16,24],[14,20,16,20]]}
["FY20","Geothermal Heat Pump-03"]
[]
["Customer Information",null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Committed:",null,null,{"$f":"SUM($L19:$L43)","v":0}]
["Name",null,null,null,"Address",null,null,null,null,null,null,null,null,"Total Units Installed:",null,null,{"$f":"SUM($M19:$M43)","v":0},null,"Inspection Type"]
["Application",null,null,null,"Date"]
["Contact",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,"Address"]
["Contact",null,null," ","Phone"]
["Enhanced Incentive Eligibility"]
[false,false,false]
[false,false,false]
[null,"Incentive amounts below are estimated based on standard program incentives. These values and any additional enhancements will be verified by the Program Manager prior to approval."]
["Project Type",null,null,null,"Building Type",null,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},0,0,0,0,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,null,{"$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($B$14=\"\",$F$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($B$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,$B$11=TRUE,$B$12=TRUE,$C$11=TRUE,$C$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($F$14,BuildingType_Lookup,3,FALSE)+(I19/1000)*(1/(VLOOKUP(A19,MeasureCode_Lookup,9,FALSE)*3.412)-1/(J19*3.412))*VLOOKUP($F$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,null,"","",null,null,null,null,null,null,0,null,null,{"$f":"IF(K20=0,0,G20/12000*K20)","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$B$11=TRUE,$B$12=TRUE,$C$11=TRUE,$C$12=TRUE)=TRUE,N20,0)","v":0},{"$f":"L20*(N20+O20)","v":0},{"$f":"M20*(N20+O20)","v":0},0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",null,null,null,null,null,null,0,null,null,0,0,0,0,0,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,48,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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"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!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$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":"IFERROR(Worksheet!O43,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[13,"<-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"]