{"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":1,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Worksheet","index":0,"n_rows":41,"n_cols":38,"rows_kept":41,"cut":false,"hidden":false,"merged":[[14,31,15,31],[14,32,15,32],[14,33,15,33],[14,1,15,1],[14,25,15,25],[14,26,15,26],[14,27,15,27],[14,28,15,28],[14,29,15,29],[14,30,15,30],[14,14,15,14],[14,15,15,15],[14,16,15,16],[14,19,15,19],[14,20,15,20],[14,24,15,24],[14,5,14,9],[5,28,5,30],[6,25,8,27],[6,28,8,30],[3,1,3,3],[3,5,3,13],[7,1,7,2],[5,1,5,3],[3,26,3,27],[5,25,5,27],[4,1,4,3],[2,17,2,19],[3,17,3,19],[14,0,15,0],[14,21,15,21],[14,22,15,22],[7,5,7,11],[8,1,8,2],[8,5,8,6],[13,1,13,3],[13,17,13,18],[14,17,15,17],[14,18,15,18],[14,10,14,13],[14,2,15,2],[14,3,15,3],[14,4,15,4]]}
["FY21","Gas Cooling-00"]
[]
["Customer Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Committed:",null,null,{"$f":"SUM(P17:P41)","v":0}]
["Name",null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Installed:",null,null,{"$f":"SUM(Q17:Q41)","v":0},null,null,null,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,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."]
["Building Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals:",null,{"$f":"SUM(T17:T41)","v":0},{"$f":"SUM(U17:U41)","v":0},null,null,null,{"$f":"SUM(Y17:Y41)","v":0},0,0,0,0,0,0,0,0,0,null,"Date","Inspector/Sign-off"]
["Measure Code","New or Replaced","Type \nA- Absorbant \nD -Dessicant","Manufacturer","Model","For Absorbant System Only",null,null,null,null,"For Desiccant System Only",null,null,null,"Incentive per Ton or CFM","Quantity Committed","Quantity Installed","Incentive Per Unit","Enhanced Incentive Per Unit","Total Committed Incentive","Total Installed Incentive","Baseline kW/Ton","Baseline EER",null,"Net Annual Committed Gas Savings (Therms)","Net Annual Installed gas Savings (Therms)","Net Lifetime Committed Gas Savings (Therms)","Net Lifetime Installed Gas Savings (Therms)","Electric  Demand Committed Savings kW","Electric Demand Installed Savings kW","Electric Annual Committed Savings kWh","Electric Annual Installed Savings kWh","Electric Lifetime Committed Savings kWh","Electric Lifetime Installed Savings kWh"]
[null,null,null,null,null,"Vaccum Boiler Efficiency (%)","Input Rating (Therms/hr)","Parasitic Electric Requirement (kW/Ton)","Unit Size (Tons)","Unit Efficiency (COP)","Capacity (Btu/h)","Total Supply Air CFM ","CFM through Desiccant System","Post Heat or Regenerative Heat\n(Btu/h)\n(If Applicable)",null,null,null,null,null,null,null,null,null,"EFLH",null,null,null,null,null,null,null,null,null,null,"FOUND PRE TYPE","Count","FOUND POST TYPE","count"]
[null,null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,MeasureCode_Lookup,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($B$14=\"\",A17=\"\",AND(C17=\"A\",OR(F17=\"\",G17=\"\",H17=\"\",I17=\"\",J17=\"\")=TRUE)=TRUE,AND(C17=\"D\",OR(K17=\"\",L17=\"\",M17=\"\")=TRUE)=TRUE)=TRUE,0,IF(AND(C17=\"A\",OR(I17<VLOOKUP(A17,MeasureCode_Lookup,4,FALSE),I17>VLOOKUP(A17,MeasureCode_Lookup,5,FALSE),J17<=1.1)=TRUE)=TRUE,0,VLOOKUP(A17,MeasureCode_Lookup,6,FALSE)))","v":0},null,null,{"$f":"IF(O17=0,0,IF(C17=\"A\",O17*I17,O17*M17))","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$B$11=TRUE,$B$12=TRUE,$C$11=TRUE,$C$12=TRUE)=TRUE,R17,0)","v":0},{"$f":"P17*(R17+S17)","v":0},{"$f":"Q17*(R17+S17)","v":0},{"$f":"IF(O17=0,0,IF(C17=\"A\",IF(I17<150,0.703,IF(I17<300,0.634,0.577)),0))","v":0},{"$f":"IF(O17=0,0,IF(C17=\"D\",IF(K17<65000,13,IF(K17<135000,11,IF(K17<240000,10.8,IF(K17<760000,9.8,9.5)))),0))","v":0},{"$f":"IF(O17=0,0,VLOOKUP($B$14,EFLH_Lookup,2,FALSE))","v":0},{"$f":"IF(O17=0,0,IF(C17=\"A\",P17*(((F17-75)/F17)*G17*X17-(I17*12000/100000)/J17*X17),P17*-N17*X17/100000))","v":0},{"$f":"IF(O17=0,0,IF(C17=\"A\",Q17*(((F17-75)/F17)*G17*X17-(I17*12000/100000)/J17*X17),Q17*-N17*X17/100000))","v":0},{"$f":"Y17*25","v":0},{"$f":"Z17*25","v":0},{"$f":"IF(O17=0,0,IF(C17=\"A\",P17*(V17-H17)*I17*0.67,P17*((((K17*0.67)/(W17*1000))/(1-0.3*(M17/L17)))-((K17*0.67)/(W17*1000)))))","v":0},{"$f":"IF(O17=0,0,IF(C17=\"A\",Q17*(V17-H17)*I17*0.67,Q17*((((K17*0.67)/(W17*1000))/(1-0.3*(M17/L17)))-((K17*0.67)/(W17*1000)))))","v":0},{"$f":"IF(O17=0,0,IF(C17=\"A\",P17*(V17-H17)*I17*X17,P17*((((K17*X17)/(W17*1000))/(1-0.3*(M17/L17)))-((K17*X17)/(W17*1000)))))","v":0},{"$f":"IF(O17=0,0,IF(C17=\"A\",Q17*(V17-H17)*I17*X17,Q17*((((K17*X17)/(W17*1000))/(1-0.3*(M17/L17)))-((K17*X17)/(W17*1000)))))","v":0},{"$f":"AE17*25","v":0},{"$f":"AF17*25","v":0}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(O18=0,0,IF(C18=\"A\",O18*I18,O18*M18))","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$B$11=TRUE,$B$12=TRUE,$C$11=TRUE,$C$12=TRUE)=TRUE,R18,0)","v":0},{"$f":"P18*(R18+S18)","v":0},{"$f":"Q18*(R18+S18)","v":0},{"$f":"IF(O18=0,0,IF(C18=\"A\",IF(I18<150,0.703,IF(I18<300,0.634,0.577)),0))","v":0},{"$f":"IF(O18=0,0,IF(C18=\"D\",IF(K18<65000,13,IF(K18<135000,11,IF(K18<240000,10.8,IF(K18<760000,9.8,9.5)))),0))","v":0},0,0,0,{"$f":"Y18*25","v":0},{"$f":"Z18*25","v":0},0,0,0,0,{"$f":"AE18*25","v":0},{"$f":"AF18*25","v":0}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Measure Code","index":1,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Type","Measure Description","Min Capacity (Tons)","Max Capacity (Tons)","Incentive per Unit","Incentive Units","Measure Type"]
["GC1","A","<100 ton Gas Absorption Chiller, Indirect-Fired",0.01,99.99,450,"per Ton",71]
["GC2","A","100 to 400 ton Gas Absorption Chiller, Indirect-Fired",100,400,230,"per Ton",71]
["GC3","A",">400 ton Gas Absorption Chiller, Indirect-Fired, two-stage",400.01,999999,185,"per Ton",71]
["GC4","A","<100 ton Gas Absorption Chiller,Direct-Fired",0.01,99.99,450,"per Ton",71]
["GC5","A","100 to 400 ton Gas Absorption Chiller, Direct-Fired",100,400,230,"per Ton",71]
["GC6","A",">400 ton Gas Absorption Chiller, Direct-Fired, two-stage",400.01,999999,185,"per Ton",71]
["GC7","D","Regenerative Desiccant Units",0.01,999999,1,"per CFM",72]

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

{"sheet":"Export","index":3,"n_rows":26,"n_cols":25,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Measure Type","Manufacturer","Model","Capacity/Size","Capacity/Size Units","EER Efficiency","SEER Efficiency","Incentive Per Unit","Quantity","Annual Electricity Savings","Peak Demand Reduction","Lifetime Electricity Savings","Annual Gas Savings","Lifetime Gas Savings","Efficiency- other","Efficiency- other-type","Measure ID removed","Quantity Installed","Project in UEZ","Project in OZ","Municipality","K-12 School","County","Affordable Housing","Enhanced Incentive per Unit"]
[{"$f":"IF(ISBLANK(Worksheet!P17)=FALSE,IF(Worksheet!C17=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D17","v":0},{"$f":"Worksheet!E17","v":0},{"$f":"Worksheet!I17","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R17,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P17)=FALSE,Worksheet!P17,\"\")","v":""},{"$f":"IF(A2=\"\",0,Worksheet!AE17/Worksheet!P17)","v":0},{"$f":"IF(A2=\"\",0,Worksheet!AC17/Worksheet!P17)","v":0},{"$f":"J2*25","v":0},{"$f":"IF(A2=\"\",0,Worksheet!Y17/Worksheet!P17)","v":0},{"$f":"M2*25","v":0},{"$f":"Worksheet!J17","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q17)=FALSE,Worksheet!Q17,\"\")","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!S17,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P18)=FALSE,IF(Worksheet!C18=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D18","v":0},{"$f":"Worksheet!E18","v":0},{"$f":"Worksheet!I18","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R18,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P18)=FALSE,Worksheet!P18,\"\")","v":""},{"$f":"IF(A3=\"\",0,Worksheet!AE18/Worksheet!P18)","v":0},{"$f":"IF(A3=\"\",0,Worksheet!AC18/Worksheet!P18)","v":0},{"$f":"J3*25","v":0},{"$f":"IF(A3=\"\",0,Worksheet!Y18/Worksheet!P18)","v":0},{"$f":"M3*25","v":0},{"$f":"Worksheet!J18","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q18)=FALSE,Worksheet!Q18,\"\")","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!S18,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P19)=FALSE,IF(Worksheet!C19=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D19","v":0},{"$f":"Worksheet!E19","v":0},{"$f":"Worksheet!I19","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R19,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P19)=FALSE,Worksheet!P19,\"\")","v":""},{"$f":"IF(A4=\"\",0,Worksheet!AE19/Worksheet!P19)","v":0},{"$f":"IF(A4=\"\",0,Worksheet!AC19/Worksheet!P19)","v":0},0,{"$f":"IF(A4=\"\",0,Worksheet!Y19/Worksheet!P19)","v":0},0,{"$f":"Worksheet!J19","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q19)=FALSE,Worksheet!Q19,\"\")","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!S19,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P20)=FALSE,IF(Worksheet!C20=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D20","v":0},{"$f":"Worksheet!E20","v":0},{"$f":"Worksheet!I20","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R20,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P20)=FALSE,Worksheet!P20,\"\")","v":""},{"$f":"IF(A5=\"\",0,Worksheet!AE20/Worksheet!P20)","v":0},{"$f":"IF(A5=\"\",0,Worksheet!AC20/Worksheet!P20)","v":0},0,{"$f":"IF(A5=\"\",0,Worksheet!Y20/Worksheet!P20)","v":0},0,{"$f":"Worksheet!J20","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q20)=FALSE,Worksheet!Q20,\"\")","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!S20,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P21)=FALSE,IF(Worksheet!C21=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D21","v":0},{"$f":"Worksheet!E21","v":0},{"$f":"Worksheet!I21","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R21,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P21)=FALSE,Worksheet!P21,\"\")","v":""},{"$f":"IF(A6=\"\",0,Worksheet!AE21/Worksheet!P21)","v":0},{"$f":"IF(A6=\"\",0,Worksheet!AC21/Worksheet!P21)","v":0},0,{"$f":"IF(A6=\"\",0,Worksheet!Y21/Worksheet!P21)","v":0},0,{"$f":"Worksheet!J21","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q21)=FALSE,Worksheet!Q21,\"\")","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!S21,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P22)=FALSE,IF(Worksheet!C22=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D22","v":0},{"$f":"Worksheet!E22","v":0},{"$f":"Worksheet!I22","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R22,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P22)=FALSE,Worksheet!P22,\"\")","v":""},{"$f":"IF(A7=\"\",0,Worksheet!AE22/Worksheet!P22)","v":0},{"$f":"IF(A7=\"\",0,Worksheet!AC22/Worksheet!P22)","v":0},0,{"$f":"IF(A7=\"\",0,Worksheet!Y22/Worksheet!P22)","v":0},0,{"$f":"Worksheet!J22","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q22)=FALSE,Worksheet!Q22,\"\")","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!S22,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P23)=FALSE,IF(Worksheet!C23=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D23","v":0},{"$f":"Worksheet!E23","v":0},{"$f":"Worksheet!I23","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R23,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P23)=FALSE,Worksheet!P23,\"\")","v":""},{"$f":"IF(A8=\"\",0,Worksheet!AE23/Worksheet!P23)","v":0},{"$f":"IF(A8=\"\",0,Worksheet!AC23/Worksheet!P23)","v":0},0,{"$f":"IF(A8=\"\",0,Worksheet!Y23/Worksheet!P23)","v":0},0,{"$f":"Worksheet!J23","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q23)=FALSE,Worksheet!Q23,\"\")","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!S23,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P24)=FALSE,IF(Worksheet!C24=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D24","v":0},{"$f":"Worksheet!E24","v":0},{"$f":"Worksheet!I24","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R24,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P24)=FALSE,Worksheet!P24,\"\")","v":""},{"$f":"IF(A9=\"\",0,Worksheet!AE24/Worksheet!P24)","v":0},{"$f":"IF(A9=\"\",0,Worksheet!AC24/Worksheet!P24)","v":0},0,{"$f":"IF(A9=\"\",0,Worksheet!Y24/Worksheet!P24)","v":0},0,{"$f":"Worksheet!J24","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q24)=FALSE,Worksheet!Q24,\"\")","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!S24,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P25)=FALSE,IF(Worksheet!C25=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D25","v":0},{"$f":"Worksheet!E25","v":0},{"$f":"Worksheet!I25","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R25,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P25)=FALSE,Worksheet!P25,\"\")","v":""},{"$f":"IF(A10=\"\",0,Worksheet!AE25/Worksheet!P25)","v":0},{"$f":"IF(A10=\"\",0,Worksheet!AC25/Worksheet!P25)","v":0},0,{"$f":"IF(A10=\"\",0,Worksheet!Y25/Worksheet!P25)","v":0},0,{"$f":"Worksheet!J25","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q25)=FALSE,Worksheet!Q25,\"\")","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!S25,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P26)=FALSE,IF(Worksheet!C26=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D26","v":0},{"$f":"Worksheet!E26","v":0},{"$f":"Worksheet!I26","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R26,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P26)=FALSE,Worksheet!P26,\"\")","v":""},{"$f":"IF(A11=\"\",0,Worksheet!AE26/Worksheet!P26)","v":0},{"$f":"IF(A11=\"\",0,Worksheet!AC26/Worksheet!P26)","v":0},0,{"$f":"IF(A11=\"\",0,Worksheet!Y26/Worksheet!P26)","v":0},0,{"$f":"Worksheet!J26","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q26)=FALSE,Worksheet!Q26,\"\")","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!S26,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P27)=FALSE,IF(Worksheet!C27=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D27","v":0},{"$f":"Worksheet!E27","v":0},{"$f":"Worksheet!I27","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R27,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P27)=FALSE,Worksheet!P27,\"\")","v":""},{"$f":"IF(A12=\"\",0,Worksheet!AE27/Worksheet!P27)","v":0},{"$f":"IF(A12=\"\",0,Worksheet!AC27/Worksheet!P27)","v":0},0,{"$f":"IF(A12=\"\",0,Worksheet!Y27/Worksheet!P27)","v":0},0,{"$f":"Worksheet!J27","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q27)=FALSE,Worksheet!Q27,\"\")","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!S27,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P28)=FALSE,IF(Worksheet!C28=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D28","v":0},{"$f":"Worksheet!E28","v":0},{"$f":"Worksheet!I28","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R28,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P28)=FALSE,Worksheet!P28,\"\")","v":""},{"$f":"IF(A13=\"\",0,Worksheet!AE28/Worksheet!P28)","v":0},{"$f":"IF(A13=\"\",0,Worksheet!AC28/Worksheet!P28)","v":0},0,{"$f":"IF(A13=\"\",0,Worksheet!Y28/Worksheet!P28)","v":0},0,{"$f":"Worksheet!J28","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q28)=FALSE,Worksheet!Q28,\"\")","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!S28,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P29)=FALSE,IF(Worksheet!C29=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D29","v":0},{"$f":"Worksheet!E29","v":0},{"$f":"Worksheet!I29","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R29,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P29)=FALSE,Worksheet!P29,\"\")","v":""},{"$f":"IF(A14=\"\",0,Worksheet!AE29/Worksheet!P29)","v":0},{"$f":"IF(A14=\"\",0,Worksheet!AC29/Worksheet!P29)","v":0},0,{"$f":"IF(A14=\"\",0,Worksheet!Y29/Worksheet!P29)","v":0},0,{"$f":"Worksheet!J29","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q29)=FALSE,Worksheet!Q29,\"\")","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!S29,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P30)=FALSE,IF(Worksheet!C30=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D30","v":0},{"$f":"Worksheet!E30","v":0},{"$f":"Worksheet!I30","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R30,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P30)=FALSE,Worksheet!P30,\"\")","v":""},{"$f":"IF(A15=\"\",0,Worksheet!AE30/Worksheet!P30)","v":0},{"$f":"IF(A15=\"\",0,Worksheet!AC30/Worksheet!P30)","v":0},0,{"$f":"IF(A15=\"\",0,Worksheet!Y30/Worksheet!P30)","v":0},0,{"$f":"Worksheet!J30","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q30)=FALSE,Worksheet!Q30,\"\")","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!S30,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P31)=FALSE,IF(Worksheet!C31=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D31","v":0},{"$f":"Worksheet!E31","v":0},{"$f":"Worksheet!I31","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R31,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P31)=FALSE,Worksheet!P31,\"\")","v":""},{"$f":"IF(A16=\"\",0,Worksheet!AE31/Worksheet!P31)","v":0},{"$f":"IF(A16=\"\",0,Worksheet!AC31/Worksheet!P31)","v":0},0,{"$f":"IF(A16=\"\",0,Worksheet!Y31/Worksheet!P31)","v":0},0,{"$f":"Worksheet!J31","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q31)=FALSE,Worksheet!Q31,\"\")","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!S31,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P32)=FALSE,IF(Worksheet!C32=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D32","v":0},{"$f":"Worksheet!E32","v":0},{"$f":"Worksheet!I32","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R32,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P32)=FALSE,Worksheet!P32,\"\")","v":""},{"$f":"IF(A17=\"\",0,Worksheet!AE32/Worksheet!P32)","v":0},{"$f":"IF(A17=\"\",0,Worksheet!AC32/Worksheet!P32)","v":0},0,{"$f":"IF(A17=\"\",0,Worksheet!Y32/Worksheet!P32)","v":0},0,{"$f":"Worksheet!J32","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q32)=FALSE,Worksheet!Q32,\"\")","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!S32,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P33)=FALSE,IF(Worksheet!C33=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D33","v":0},{"$f":"Worksheet!E33","v":0},{"$f":"Worksheet!I33","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R33,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P33)=FALSE,Worksheet!P33,\"\")","v":""},{"$f":"IF(A18=\"\",0,Worksheet!AE33/Worksheet!P33)","v":0},{"$f":"IF(A18=\"\",0,Worksheet!AC33/Worksheet!P33)","v":0},0,{"$f":"IF(A18=\"\",0,Worksheet!Y33/Worksheet!P33)","v":0},0,{"$f":"Worksheet!J33","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q33)=FALSE,Worksheet!Q33,\"\")","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!S33,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P34)=FALSE,IF(Worksheet!C34=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D34","v":0},{"$f":"Worksheet!E34","v":0},{"$f":"Worksheet!I34","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R34,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P34)=FALSE,Worksheet!P34,\"\")","v":""},{"$f":"IF(A19=\"\",0,Worksheet!AE34/Worksheet!P34)","v":0},{"$f":"IF(A19=\"\",0,Worksheet!AC34/Worksheet!P34)","v":0},0,{"$f":"IF(A19=\"\",0,Worksheet!Y34/Worksheet!P34)","v":0},0,{"$f":"Worksheet!J34","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q34)=FALSE,Worksheet!Q34,\"\")","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!S34,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P35)=FALSE,IF(Worksheet!C35=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D35","v":0},{"$f":"Worksheet!E35","v":0},{"$f":"Worksheet!I35","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R35,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P35)=FALSE,Worksheet!P35,\"\")","v":""},{"$f":"IF(A20=\"\",0,Worksheet!AE35/Worksheet!P35)","v":0},{"$f":"IF(A20=\"\",0,Worksheet!AC35/Worksheet!P35)","v":0},0,{"$f":"IF(A20=\"\",0,Worksheet!Y35/Worksheet!P35)","v":0},0,{"$f":"Worksheet!J35","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q35)=FALSE,Worksheet!Q35,\"\")","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!S35,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P36)=FALSE,IF(Worksheet!C36=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D36","v":0},{"$f":"Worksheet!E36","v":0},{"$f":"Worksheet!I36","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R36,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P36)=FALSE,Worksheet!P36,\"\")","v":""},{"$f":"IF(A21=\"\",0,Worksheet!AE36/Worksheet!P36)","v":0},{"$f":"IF(A21=\"\",0,Worksheet!AC36/Worksheet!P36)","v":0},0,{"$f":"IF(A21=\"\",0,Worksheet!Y36/Worksheet!P36)","v":0},0,{"$f":"Worksheet!J36","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q36)=FALSE,Worksheet!Q36,\"\")","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!S36,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P37)=FALSE,IF(Worksheet!C37=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D37","v":0},{"$f":"Worksheet!E37","v":0},{"$f":"Worksheet!I37","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R37,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P37)=FALSE,Worksheet!P37,\"\")","v":""},{"$f":"IF(A22=\"\",0,Worksheet!AE37/Worksheet!P37)","v":0},{"$f":"IF(A22=\"\",0,Worksheet!AC37/Worksheet!P37)","v":0},0,{"$f":"IF(A22=\"\",0,Worksheet!Y37/Worksheet!P37)","v":0},0,{"$f":"Worksheet!J37","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q37)=FALSE,Worksheet!Q37,\"\")","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!S37,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P38)=FALSE,IF(Worksheet!C38=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D38","v":0},{"$f":"Worksheet!E38","v":0},{"$f":"Worksheet!I38","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R38,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P38)=FALSE,Worksheet!P38,\"\")","v":""},{"$f":"IF(A23=\"\",0,Worksheet!AE38/Worksheet!P38)","v":0},{"$f":"IF(A23=\"\",0,Worksheet!AC38/Worksheet!P38)","v":0},0,{"$f":"IF(A23=\"\",0,Worksheet!Y38/Worksheet!P38)","v":0},0,{"$f":"Worksheet!J38","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q38)=FALSE,Worksheet!Q38,\"\")","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!S38,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P39)=FALSE,IF(Worksheet!C39=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D39","v":0},{"$f":"Worksheet!E39","v":0},{"$f":"Worksheet!I39","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R39,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P39)=FALSE,Worksheet!P39,\"\")","v":""},{"$f":"IF(A24=\"\",0,Worksheet!AE39/Worksheet!P39)","v":0},{"$f":"IF(A24=\"\",0,Worksheet!AC39/Worksheet!P39)","v":0},0,{"$f":"IF(A24=\"\",0,Worksheet!Y39/Worksheet!P39)","v":0},0,{"$f":"Worksheet!J39","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q39)=FALSE,Worksheet!Q39,\"\")","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!S39,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P40)=FALSE,IF(Worksheet!C40=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D40","v":0},{"$f":"Worksheet!E40","v":0},{"$f":"Worksheet!I40","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R40,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P40)=FALSE,Worksheet!P40,\"\")","v":""},{"$f":"IF(A25=\"\",0,Worksheet!AE40/Worksheet!P40)","v":0},{"$f":"IF(A25=\"\",0,Worksheet!AC40/Worksheet!P40)","v":0},0,{"$f":"IF(A25=\"\",0,Worksheet!Y40/Worksheet!P40)","v":0},0,{"$f":"Worksheet!J40","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q40)=FALSE,Worksheet!Q40,\"\")","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!S40,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!P41)=FALSE,IF(Worksheet!C41=\"A\",71,72),\"\")","v":""},{"$f":"Worksheet!D41","v":0},{"$f":"Worksheet!E41","v":0},{"$f":"Worksheet!I41","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!R41,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!P41)=FALSE,Worksheet!P41,\"\")","v":""},{"$f":"IF(A26=\"\",0,Worksheet!AE41/Worksheet!P41)","v":0},{"$f":"IF(A26=\"\",0,Worksheet!AC41/Worksheet!P41)","v":0},0,{"$f":"IF(A26=\"\",0,Worksheet!Y41/Worksheet!P41)","v":0},0,{"$f":"Worksheet!J41","v":0},"COP",null,{"$f":"IF(ISBLANK(Worksheet!Q41)=FALSE,Worksheet!Q41,\"\")","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!S41,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[14,"<- version"]
["Log"]
["2007-10-02",null,"Added project information in rows 6-10"]
["2007-01-07",null,"Fixed Savings Calculations to take quantity into account"]
["2008-01-08",null,"Updated baseline efficiencies to comply with new protocol"]
["2008-12-01",null,"Updated for compatability with measure tracking"]
["2012-01-13","V5","no change for 2012"]
["2018-06-26","V12","Updated to align with FY19 Protocols"]
["2019-07-01","V13","Added Enhanced Incentive Eligibility Section and Updated for FY20 Program"]
["2020-10-01","V14","Updated for FY21 Program"]