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

{"sheet":"Worksheet","index":0,"n_rows":46,"n_cols":35,"rows_kept":46,"cut":false,"hidden":false,"merged":[[15,7,19,7],[15,8,19,8],[8,1,8,2],[15,25,19,25],[16,15,19,15],[16,17,19,17],[16,16,19,16],[15,9,19,9],[16,11,19,11],[16,12,19,12],[16,13,19,13],[16,14,19,14],[15,24,19,24],[3,32,3,34],[4,32,7,34],[4,5,4,6],[3,1,3,3],[7,1,7,2],[3,5,3,10],[7,5,7,10],[5,1,5,3],[4,1,4,3],[3,29,3,31],[3,21,3,23],[4,29,7,31],[15,33,19,33],[15,34,19,34],[15,26,19,26],[15,29,19,29],[15,30,19,30],[15,27,19,27],[15,31,19,31],[15,28,19,28],[15,32,19,32],[2,21,2,23],[15,18,18,18],[15,19,19,19],[15,20,19,20],[15,21,19,21],[15,22,19,22],[15,23,19,23],[14,21,14,22],[15,0,19,0],[15,3,19,3],[15,6,19,6],[8,5,8,6],[15,4,19,4],[15,5,19,5],[15,2,19,2],[13,1,13,3]]}
["FY21","Variable Frequency Drive -00"]
[]
["Customer Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Committed:",null,null,{"$f":"SUM(T21:T46)","v":0}]
["Name",null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Installed:",null,null,{"$f":"SUM(U21:U46)","v":0},null,null,null,null,"Pre-Inspection Notes",null,null,"Post-Inspection Notes"]
["Application",null,null,null,"Date"]
["Contact"]
["Contractor/Vendor Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Type"]
["Name",null,null,null,"Address"]
["Contact",null,null," ","Phone"]
["Enhanced Incentive Eligibility"]
[false,false,false]
[false,false,false]
[]
["Project Type"]
[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.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals",null,{"$f":"SUMIF($X$21:$X$46,\"<>#N/A\",$X$21:$X$46)","v":0},{"$f":"SUMIF($Y$21:$Y$46,\"<>#N/A\",$Y$21:$Y$46)","v":0},{"$f":"SUM(Z21:Z46)","v":0},0,0,0,0,0,0,0,0,0]
["Measure Code","Reason","Type or Usage","Motor Application","Drive Manufacturer","Drive Model","Drive Efficiency\n%","Motor Manufacturer","Motor Model","Motor Efficiency\n%","Location","Kitchen SF","Facility Type","Run Hours","Cooling Degree Days","Heating Degree Days","Power Reduction","Flow Reduction","HP of Controlled Motors","# of Units Committed","# of Units Installed","Incentive per VFD","Enhanced Incentive per VFD","Total Committed Incentives","Total Installed Incentives","Committed Annual Electric Energy Usage Savings\n(kWh)","Installed Annual Electric Energy Usage Savings\n(kWh)","Committed Lifetime Electric Energy Usage Savings\n(kWh)","Installed Lifetime Electric Energy Usage Savings\n(kWh)","Committed Peak Demand Reduction\n(kW)","Installed Peak Demand Reduction\n(kW)","Committed Annual Gas Energy Usage Savings\n(Therms)","Installed Annual Gas Energy Usage Savings\n(Therms)","Committed Lifetime Gas Energy Usage Savings\n(Therms)","Installed Lifetime Gas Energy Usage Savings\n(Therms)"]
[null,"N-New",null,null,null,null,null,null,null,null,"(Bldg/Rm)","(For Kitchen Hoods Only)","(For Kitchen Hoods Only)","(For Kitchen Hoods Only)","(For Kitchen Hoods Only)","(For Kitchen Hoods Only)","(For Kitchen Hoods Only)","(For Kitchen Hoods Only)"]
[null,"R-Retrofit"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(per VFD)"]
[null,null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C21<>\"K\",M21=\"\")=TRUE,\"\",VLOOKUP(M21,KitchenHoodTable,2,FALSE))","v":""},{"$f":"IF(OR(C21<>\"K\",M21=\"\")=TRUE,\"\",VLOOKUP(M21,KitchenHoodTable,3,FALSE))","v":""},{"$f":"IF(OR(C21<>\"K\",M21=\"\")=TRUE,\"\",VLOOKUP(M21,KitchenHoodTable,4,FALSE))","v":""},{"$f":"IF(OR(C21<>\"K\",M21=\"\")=TRUE,\"\",VLOOKUP(M21,KitchenHoodTable,5,FALSE))","v":""},{"$f":"IF(OR(C21<>\"K\",M21=\"\")=TRUE,\"\",VLOOKUP(M21,KitchenHoodTable,6,FALSE))","v":""},null,null,null,{"$f":"IF(OR(A21=\"\",C21=\"\",AND(OR(A21=\"VFD1\",A21=\"VFD2\",A21=\"VFD3\",A21=\"VFD4\")=TRUE,D21=\"\")=TRUE,AND(A21=\"VFD11\",OR(J21=\"\",L21=\"\",M21=\"\")=TRUE),S21=\"\",AND($B$14<>\"Existing Building\",A21=\"VFD11\"))=TRUE,0,IF(OR(S21<VLOOKUP(C21,VFDTable,4,FALSE),S21>VLOOKUP(C21,VFDTable,5,FALSE)=TRUE),0,VLOOKUP(S21,VFDIncentives,2,TRUE)))","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$B$11=TRUE,$B$12=TRUE,$C$11=TRUE,$C$12=TRUE)=TRUE,V21,0)","v":0},{"$f":"T21*(V21+W21)","v":0},{"$f":"T21*(V21+W21)","v":0},{"$f":"IF(V21=0,0,IF(C21=\"K\",T21*(S21*0.9*0.746/J21*N21*Q21)+(L21*0.7*1.4*R21*O21*24*1.08/(3*3412)),IF(C21=\"A\",T21*6978*0.186*S21*0.746,T21*S21*IF(OR(A21=\"VFD1\",A21=\"VFD2\",A21=\"VFD3\",A21=\"VFD4\")=TRUE,VLOOKUP(D21,MotorApplication_Lookup,2,FALSE),VLOOKUP(VLOOKUP(C21,VFDTable,2,FALSE),MotorApplication_Lookup,2,FALSE)))))","v":0},{"$f":"IF(V21=0,0,IF(C21=\"K\",U21*(S21*0.9*0.746/J21*N21*Q21)+(L21*0.7*1.4*R21*O21*24*1.08/(3*3412)),IF(C21=\"A\",U21*6978*0.186*S21*0.746,U21*S21*IF(OR(A21=\"VFD1\",A21=\"VFD2\",A21=\"VFD3\",A21=\"VFD4\")=TRUE,VLOOKUP(D21,MotorApplication_Lookup,2,FALSE),VLOOKUP(VLOOKUP(C21,VFDTable,2,FALSE),MotorApplication_Lookup,2,FALSE)))))","v":0},{"$f":"Z21*15","v":0},{"$f":"AA21*15","v":0},{"$f":"IF(V21=0,0,IF(C21=\"K\",0,IF(C21=\"A\",T21*S21*0.186*1.05*0.746,T21*S21*IF(OR(A21=\"VFD1\",A21=\"VFD2\",A21=\"VFD3\",A21=\"VFD4\")=TRUE,VLOOKUP(D21,MotorApplication_Lookup,3,FALSE),VLOOKUP(VLOOKUP(C21,VFDTable,2,FALSE),MotorApplication_Lookup,3,FALSE)))))","v":0},{"$f":"IF(V21=0,0,IF(C21=\"K\",0,IF(C21=\"A\",U21*S21*0.186*1.05*0.746,U21*S21*IF(OR(A21=\"VFD1\",A21=\"VFD2\",A21=\"VFD3\",A21=\"VFD4\")=TRUE,VLOOKUP(D21,MotorApplication_Lookup,3,FALSE),VLOOKUP(VLOOKUP(C21,VFDTable,2,FALSE),MotorApplication_Lookup,3,FALSE)))))","v":0},{"$f":"IF(V21=0,0,IF(C21=\"K\",L21*0.7*1.4*R21*P21*24*1.08/(0.8*100000),0))","v":0},{"$f":"IF(V21=0,0,IF(C21=\"K\",L21*0.7*1.4*R21*P21*24*1.08/(0.8*100000),0))","v":0},{"$f":"AF21*15","v":0},{"$f":"AG21*15","v":0}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$B$11=TRUE,$B$12=TRUE,$C$11=TRUE,$C$12=TRUE)=TRUE,V22,0)","v":0},{"$f":"T22*(V22+W22)","v":0},{"$f":"T22*(V22+W22)","v":0},0,0,{"$f":"Z22*15","v":0},{"$f":"AA22*15","v":0},0,0,0,0,{"$f":"AF22*15","v":0},{"$f":"AG22*15","v":0}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"",null,null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Measure Code","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Application Incentive Table Abbreviation","Worksheet Selection","Description","Measure ID"]
["VFD1","VAV","VAV-F","Variable Air Volume HVAC Systems - Airfoil/Backward Inclined Fan",84]
["VFD2","VAV","VAV-C","Variable Air Volume HVAC Systems - Forward Curved Fan",84]
["VFD3","CV","CV-F","Constant Volume HVAC Systems - Airfoil/Backward Inclined Fan",431]
["VFD4","CV","CV-C","Constant Volume HVAC Systems - Forward Curved Fan",431]
["VFD5","T","T","Cooling Tower Fan",453]
["VFD6","P","P","Chilled Water Pump",85]
["VFD7","A","A","Air Compressor",86]
["VFD8","BP","BP","Boiler Feedwater Pump",454]
["VFD9","BF","BF-F","Boiler Fan Motor - Airfoil/backward Inclined Fan",452]
["VFD10","BF","BF-C","Boiler Fan Motor - Forward Curved",452]
["VFD11","K","K","Kitchen Hoods",455]

{"sheet":"Table","index":2,"n_rows":19,"n_cols":19,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Abbreviation","Description","Measure ID","Minimum HP","Maximum HP",null,"Motor Application","Energy Savings Factor (kWh/HP)","Demand Savings Factor (kW/HP)",null,"Facility Type","Run Hours","CDD","HDD","Power Reduction (PR)","Flow Reduction (FR)",null,"Motor Size (HP)","Incentive ($)"]
["VAV-F","Variable Air Volume HVAC Systems - Airfoil/Backward Inclined Fan",84,5,50,null,"Supply Fan",2033,0.28599999999999998,null,"Campus",5250,824,2792,0.56799999999999995,0.29499999999999998,null,0.5,50]
["VAV-C","Variable Air Volume HVAC Systems - Forward Curved Fan",84,5,50,null,"Return Fan",1788,0.29699999999999999,null,"Lodging",8736,420,1420,0.61799999999999999,0.33,null,1,75]
["CV-F","Constant Volume HVAC Systems - Airfoil/Backward Inclined Fan",431,0.5,50,null,"Makeup Air Fan",2033,0.28599999999999998,null,"Restaurant",5824,1094,3691,0.55200000000000005,0.29499999999999998,null,2,100]
["CV-C","Constant Volume HVAC Systems - Forward Curved Fan",431,0.5,50,null,"Cooling Tower Fan",290,-2.5000000000000001E-2,null,"Supermarket",5824,989,3369,0.59699999999999998,0.32,null,3,200]
["T","Cooling Tower Fan",453,10,50,null,"Chilled Water Pump",1633,0.185,null,"Other",5250,{"$f":"AVERAGE(M2:M5)","v":831.75},{"$f":"AVERAGE(N2:N5)","v":2818},0.58399999999999996,0.31,null,4,300]
["P","Chilled Water Pump",85,20,50,null,"Air Compressor",968,0.14599999999999999,null,null,null,null,null,null,null,null,5,900]
["A","Air Compressor",86,25,200,null,"Boiler Feedwater Pump",1588,0.498,null,null,null,null,null,null,null,null,7.5,1000]
["BP","Boiler Feedwater Pump",454,5,50,null,"Boiler Fan Motor - Airfoil/backward Inclined Fan",1788,0.29699999999999999,null,null,null,null,null,null,null,null,10,1100]
["BF-F","Boiler Fan Motor - Airfoil/backward Inclined Fan",452,5,50,null,"Boiler Fan Motor - Forward Curved",1788,0.29699999999999999,null,null,null,null,null,null,null,null,15,1200]
["BF-C","Boiler Fan Motor - Forward Curved",452,5,50,null,"Kitchen Hood Exhaust Fan","N/A","N/A",null,null,null,null,null,null,null,null,20,1300]
["K","Kitchen Hoods",455,0.5,50,null,null,null,null,null,null,null,null,null,null,null,null,25,1400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,1500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,2500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,3500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,4000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,5000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,7000]

{"sheet":"Export","index":3,"n_rows":27,"n_cols":25,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Measure Type","Manufacturer","Model","Capacity/Size","Capacity/Size Units","EER Efficiency","SEER Efficiency","Incentive Per Unit","Quantity Committed","Annual Electricity Savings","Peak Demand Reduction","Lifetime Electricity Savings","Annual Gas Savings","Lifetime Gas Savings","Efficiency- other","Efficiency- other-type","Measure ID removed","Quantity Installed","Project in UEZ","Project in OZ","Municipality","K-12 School","County","Affordable Housing","Enhanced Incentive per Unit"]
[{"$f":"IF(ISBLANK(Worksheet!T21)=FALSE,VLOOKUP(Worksheet!C21,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E21","v":0},{"$f":"Worksheet!F21","v":0},{"$f":"Worksheet!S21","v":0},"HP",null,null,{"$f":"Worksheet!V21","v":0},{"$f":"IF(ISBLANK(Worksheet!T21)=FALSE,Worksheet!T21,\"\")","v":""},{"$f":"IF(H2=0,0,Worksheet!Z21/I2)","v":0},{"$f":"IF(H2=0,0,Worksheet!AD21/I2)","v":0},{"$f":"J2*15","v":0},{"$f":"IF(H2=0,0,Worksheet!AF21/I2)","v":0},{"$f":"M2*15","v":0},{"$f":"Worksheet!J21","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U21)=FALSE,Worksheet!U21,\"\")","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!W21,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T22)=FALSE,VLOOKUP(Worksheet!C22,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E22","v":0},{"$f":"Worksheet!F22","v":0},{"$f":"Worksheet!S22","v":0},"HP",null,null,{"$f":"Worksheet!V22","v":0},{"$f":"IF(ISBLANK(Worksheet!T22)=FALSE,Worksheet!T22,\"\")","v":""},{"$f":"IF(H3=0,0,Worksheet!Z22/I3)","v":0},{"$f":"IF(H3=0,0,Worksheet!AD22/I3)","v":0},{"$f":"J3*15","v":0},{"$f":"IF(H3=0,0,Worksheet!AF22/I3)","v":0},{"$f":"M3*15","v":0},{"$f":"Worksheet!J22","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U22)=FALSE,Worksheet!U22,\"\")","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!W22,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T23)=FALSE,VLOOKUP(Worksheet!C23,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E23","v":0},{"$f":"Worksheet!F23","v":0},{"$f":"Worksheet!S23","v":0},"HP",null,null,{"$f":"Worksheet!V23","v":0},{"$f":"IF(ISBLANK(Worksheet!T23)=FALSE,Worksheet!T23,\"\")","v":""},{"$f":"IF(H4=0,0,Worksheet!Z23/I4)","v":0},{"$f":"IF(H4=0,0,Worksheet!AD23/I4)","v":0},0,{"$f":"IF(H4=0,0,Worksheet!AF23/I4)","v":0},0,{"$f":"Worksheet!J23","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U23)=FALSE,Worksheet!U23,\"\")","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!W23,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T24)=FALSE,VLOOKUP(Worksheet!C24,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E24","v":0},{"$f":"Worksheet!F24","v":0},{"$f":"Worksheet!S24","v":0},"HP",null,null,{"$f":"Worksheet!V24","v":0},{"$f":"IF(ISBLANK(Worksheet!T24)=FALSE,Worksheet!T24,\"\")","v":""},{"$f":"IF(H5=0,0,Worksheet!Z24/I5)","v":0},{"$f":"IF(H5=0,0,Worksheet!AD24/I5)","v":0},0,{"$f":"IF(H5=0,0,Worksheet!AF24/I5)","v":0},0,{"$f":"Worksheet!J24","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U24)=FALSE,Worksheet!U24,\"\")","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!W24,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T25)=FALSE,VLOOKUP(Worksheet!C25,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E25","v":0},{"$f":"Worksheet!F25","v":0},{"$f":"Worksheet!S25","v":0},"HP",null,null,{"$f":"Worksheet!V25","v":0},{"$f":"IF(ISBLANK(Worksheet!T25)=FALSE,Worksheet!T25,\"\")","v":""},{"$f":"IF(H6=0,0,Worksheet!Z25/I6)","v":0},{"$f":"IF(H6=0,0,Worksheet!AD25/I6)","v":0},0,{"$f":"IF(H6=0,0,Worksheet!AF25/I6)","v":0},0,{"$f":"Worksheet!J25","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U25)=FALSE,Worksheet!U25,\"\")","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!W25,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T26)=FALSE,VLOOKUP(Worksheet!C26,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E26","v":0},{"$f":"Worksheet!F26","v":0},{"$f":"Worksheet!S26","v":0},"HP",null,null,{"$f":"Worksheet!V26","v":0},{"$f":"IF(ISBLANK(Worksheet!T26)=FALSE,Worksheet!T26,\"\")","v":""},{"$f":"IF(H7=0,0,Worksheet!Z26/I7)","v":0},{"$f":"IF(H7=0,0,Worksheet!AD26/I7)","v":0},0,{"$f":"IF(H7=0,0,Worksheet!AF26/I7)","v":0},0,{"$f":"Worksheet!J26","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U26)=FALSE,Worksheet!U26,\"\")","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!W26,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T27)=FALSE,VLOOKUP(Worksheet!C27,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E27","v":0},{"$f":"Worksheet!F27","v":0},{"$f":"Worksheet!S27","v":0},"HP",null,null,{"$f":"Worksheet!V27","v":0},{"$f":"IF(ISBLANK(Worksheet!T27)=FALSE,Worksheet!T27,\"\")","v":""},{"$f":"IF(H8=0,0,Worksheet!Z27/I8)","v":0},{"$f":"IF(H8=0,0,Worksheet!AD27/I8)","v":0},0,{"$f":"IF(H8=0,0,Worksheet!AF27/I8)","v":0},0,{"$f":"Worksheet!J27","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U27)=FALSE,Worksheet!U27,\"\")","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!W27,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T28)=FALSE,VLOOKUP(Worksheet!C28,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E28","v":0},{"$f":"Worksheet!F28","v":0},{"$f":"Worksheet!S28","v":0},"HP",null,null,{"$f":"Worksheet!V28","v":0},{"$f":"IF(ISBLANK(Worksheet!T28)=FALSE,Worksheet!T28,\"\")","v":""},{"$f":"IF(H9=0,0,Worksheet!Z28/I9)","v":0},{"$f":"IF(H9=0,0,Worksheet!AD28/I9)","v":0},0,{"$f":"IF(H9=0,0,Worksheet!AF28/I9)","v":0},0,{"$f":"Worksheet!J28","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U28)=FALSE,Worksheet!U28,\"\")","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!W28,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T29)=FALSE,VLOOKUP(Worksheet!C29,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E29","v":0},{"$f":"Worksheet!F29","v":0},{"$f":"Worksheet!S29","v":0},"HP",null,null,{"$f":"Worksheet!V29","v":0},{"$f":"IF(ISBLANK(Worksheet!T29)=FALSE,Worksheet!T29,\"\")","v":""},{"$f":"IF(H10=0,0,Worksheet!Z29/I10)","v":0},{"$f":"IF(H10=0,0,Worksheet!AD29/I10)","v":0},0,{"$f":"IF(H10=0,0,Worksheet!AF29/I10)","v":0},0,{"$f":"Worksheet!J29","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U29)=FALSE,Worksheet!U29,\"\")","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!W29,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T30)=FALSE,VLOOKUP(Worksheet!C30,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E30","v":0},{"$f":"Worksheet!F30","v":0},{"$f":"Worksheet!S30","v":0},"HP",null,null,{"$f":"Worksheet!V30","v":0},{"$f":"IF(ISBLANK(Worksheet!T30)=FALSE,Worksheet!T30,\"\")","v":""},{"$f":"IF(H11=0,0,Worksheet!Z30/I11)","v":0},{"$f":"IF(H11=0,0,Worksheet!AD30/I11)","v":0},0,{"$f":"IF(H11=0,0,Worksheet!AF30/I11)","v":0},0,{"$f":"Worksheet!J30","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U30)=FALSE,Worksheet!U30,\"\")","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!W30,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T31)=FALSE,VLOOKUP(Worksheet!C31,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E31","v":0},{"$f":"Worksheet!F31","v":0},{"$f":"Worksheet!S31","v":0},"HP",null,null,{"$f":"Worksheet!V31","v":0},{"$f":"IF(ISBLANK(Worksheet!T31)=FALSE,Worksheet!T31,\"\")","v":""},{"$f":"IF(H12=0,0,Worksheet!Z31/I12)","v":0},{"$f":"IF(H12=0,0,Worksheet!AD31/I12)","v":0},0,{"$f":"IF(H12=0,0,Worksheet!AF31/I12)","v":0},0,{"$f":"Worksheet!J31","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U31)=FALSE,Worksheet!U31,\"\")","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!W31,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T32)=FALSE,VLOOKUP(Worksheet!C32,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E32","v":0},{"$f":"Worksheet!F32","v":0},{"$f":"Worksheet!S32","v":0},"HP",null,null,{"$f":"Worksheet!V32","v":0},{"$f":"IF(ISBLANK(Worksheet!T32)=FALSE,Worksheet!T32,\"\")","v":""},{"$f":"IF(H13=0,0,Worksheet!Z32/I13)","v":0},{"$f":"IF(H13=0,0,Worksheet!AD32/I13)","v":0},0,{"$f":"IF(H13=0,0,Worksheet!AF32/I13)","v":0},0,{"$f":"Worksheet!J32","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U32)=FALSE,Worksheet!U32,\"\")","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!W32,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T33)=FALSE,VLOOKUP(Worksheet!C33,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E33","v":0},{"$f":"Worksheet!F33","v":0},{"$f":"Worksheet!S33","v":0},"HP",null,null,{"$f":"Worksheet!V33","v":0},{"$f":"IF(ISBLANK(Worksheet!T33)=FALSE,Worksheet!T33,\"\")","v":""},{"$f":"IF(H14=0,0,Worksheet!Z33/I14)","v":0},{"$f":"IF(H14=0,0,Worksheet!AD33/I14)","v":0},0,{"$f":"IF(H14=0,0,Worksheet!AF33/I14)","v":0},0,{"$f":"Worksheet!J33","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U33)=FALSE,Worksheet!U33,\"\")","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!W33,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T34)=FALSE,VLOOKUP(Worksheet!C34,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E34","v":0},{"$f":"Worksheet!F34","v":0},{"$f":"Worksheet!S34","v":0},"HP",null,null,{"$f":"Worksheet!V34","v":0},{"$f":"IF(ISBLANK(Worksheet!T34)=FALSE,Worksheet!T34,\"\")","v":""},{"$f":"IF(H15=0,0,Worksheet!Z34/I15)","v":0},{"$f":"IF(H15=0,0,Worksheet!AD34/I15)","v":0},0,{"$f":"IF(H15=0,0,Worksheet!AF34/I15)","v":0},0,{"$f":"Worksheet!J34","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U34)=FALSE,Worksheet!U34,\"\")","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!W34,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T35)=FALSE,VLOOKUP(Worksheet!C35,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E35","v":0},{"$f":"Worksheet!F35","v":0},{"$f":"Worksheet!S35","v":0},"HP",null,null,{"$f":"Worksheet!V35","v":0},{"$f":"IF(ISBLANK(Worksheet!T35)=FALSE,Worksheet!T35,\"\")","v":""},{"$f":"IF(H16=0,0,Worksheet!Z35/I16)","v":0},{"$f":"IF(H16=0,0,Worksheet!AD35/I16)","v":0},0,{"$f":"IF(H16=0,0,Worksheet!AF35/I16)","v":0},0,{"$f":"Worksheet!J35","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U35)=FALSE,Worksheet!U35,\"\")","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!W35,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T36)=FALSE,VLOOKUP(Worksheet!C36,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E36","v":0},{"$f":"Worksheet!F36","v":0},{"$f":"Worksheet!S36","v":0},"HP",null,null,{"$f":"Worksheet!V36","v":0},{"$f":"IF(ISBLANK(Worksheet!T36)=FALSE,Worksheet!T36,\"\")","v":""},{"$f":"IF(H17=0,0,Worksheet!Z36/I17)","v":0},{"$f":"IF(H17=0,0,Worksheet!AD36/I17)","v":0},0,{"$f":"IF(H17=0,0,Worksheet!AF36/I17)","v":0},0,{"$f":"Worksheet!J36","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U36)=FALSE,Worksheet!U36,\"\")","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!W36,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T37)=FALSE,VLOOKUP(Worksheet!C37,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E37","v":0},{"$f":"Worksheet!F37","v":0},{"$f":"Worksheet!S37","v":0},"HP",null,null,{"$f":"Worksheet!V37","v":0},{"$f":"IF(ISBLANK(Worksheet!T37)=FALSE,Worksheet!T37,\"\")","v":""},{"$f":"IF(H18=0,0,Worksheet!Z37/I18)","v":0},{"$f":"IF(H18=0,0,Worksheet!AD37/I18)","v":0},0,{"$f":"IF(H18=0,0,Worksheet!AF37/I18)","v":0},0,{"$f":"Worksheet!J37","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U37)=FALSE,Worksheet!U37,\"\")","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!W37,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T38)=FALSE,VLOOKUP(Worksheet!C38,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E38","v":0},{"$f":"Worksheet!F38","v":0},{"$f":"Worksheet!S38","v":0},"HP",null,null,{"$f":"Worksheet!V38","v":0},{"$f":"IF(ISBLANK(Worksheet!T38)=FALSE,Worksheet!T38,\"\")","v":""},{"$f":"IF(H19=0,0,Worksheet!Z38/I19)","v":0},{"$f":"IF(H19=0,0,Worksheet!AD38/I19)","v":0},0,{"$f":"IF(H19=0,0,Worksheet!AF38/I19)","v":0},0,{"$f":"Worksheet!J38","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U38)=FALSE,Worksheet!U38,\"\")","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!W38,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T39)=FALSE,VLOOKUP(Worksheet!C39,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E39","v":0},{"$f":"Worksheet!F39","v":0},{"$f":"Worksheet!S39","v":0},"HP",null,null,{"$f":"Worksheet!V39","v":0},{"$f":"IF(ISBLANK(Worksheet!T39)=FALSE,Worksheet!T39,\"\")","v":""},{"$f":"IF(H20=0,0,Worksheet!Z39/I20)","v":0},{"$f":"IF(H20=0,0,Worksheet!AD39/I20)","v":0},0,{"$f":"IF(H20=0,0,Worksheet!AF39/I20)","v":0},0,{"$f":"Worksheet!J39","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U39)=FALSE,Worksheet!U39,\"\")","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!W39,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T40)=FALSE,VLOOKUP(Worksheet!C40,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E40","v":0},{"$f":"Worksheet!F40","v":0},{"$f":"Worksheet!S40","v":0},"HP",null,null,{"$f":"Worksheet!V40","v":0},{"$f":"IF(ISBLANK(Worksheet!T40)=FALSE,Worksheet!T40,\"\")","v":""},{"$f":"IF(H21=0,0,Worksheet!Z40/I21)","v":0},{"$f":"IF(H21=0,0,Worksheet!AD40/I21)","v":0},0,{"$f":"IF(H21=0,0,Worksheet!AF40/I21)","v":0},0,{"$f":"Worksheet!J40","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U40)=FALSE,Worksheet!U40,\"\")","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!W40,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T41)=FALSE,VLOOKUP(Worksheet!C41,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E41","v":0},{"$f":"Worksheet!F41","v":0},{"$f":"Worksheet!S41","v":0},"HP",null,null,{"$f":"Worksheet!V41","v":0},{"$f":"IF(ISBLANK(Worksheet!T41)=FALSE,Worksheet!T41,\"\")","v":""},{"$f":"IF(H22=0,0,Worksheet!Z41/I22)","v":0},{"$f":"IF(H22=0,0,Worksheet!AD41/I22)","v":0},0,{"$f":"IF(H22=0,0,Worksheet!AF41/I22)","v":0},0,{"$f":"Worksheet!J41","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U41)=FALSE,Worksheet!U41,\"\")","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!W41,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T42)=FALSE,VLOOKUP(Worksheet!C42,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E42","v":0},{"$f":"Worksheet!F42","v":0},{"$f":"Worksheet!S42","v":0},"HP",null,null,{"$f":"Worksheet!V42","v":0},{"$f":"IF(ISBLANK(Worksheet!T42)=FALSE,Worksheet!T42,\"\")","v":""},{"$f":"IF(H23=0,0,Worksheet!Z42/I23)","v":0},{"$f":"IF(H23=0,0,Worksheet!AD42/I23)","v":0},0,{"$f":"IF(H23=0,0,Worksheet!AF42/I23)","v":0},0,{"$f":"Worksheet!J42","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U42)=FALSE,Worksheet!U42,\"\")","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!W42,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T43)=FALSE,VLOOKUP(Worksheet!C43,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E43","v":0},{"$f":"Worksheet!F43","v":0},{"$f":"Worksheet!S43","v":0},"HP",null,null,{"$f":"Worksheet!V43","v":0},{"$f":"IF(ISBLANK(Worksheet!T43)=FALSE,Worksheet!T43,\"\")","v":""},{"$f":"IF(H24=0,0,Worksheet!Z43/I24)","v":0},{"$f":"IF(H24=0,0,Worksheet!AD43/I24)","v":0},0,{"$f":"IF(H24=0,0,Worksheet!AF43/I24)","v":0},0,{"$f":"Worksheet!J43","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U43)=FALSE,Worksheet!U43,\"\")","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!W43,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T44)=FALSE,VLOOKUP(Worksheet!C44,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E44","v":0},{"$f":"Worksheet!F44","v":0},{"$f":"Worksheet!S44","v":0},"HP",null,null,{"$f":"Worksheet!V44","v":0},{"$f":"IF(ISBLANK(Worksheet!T44)=FALSE,Worksheet!T44,\"\")","v":""},{"$f":"IF(H25=0,0,Worksheet!Z44/I25)","v":0},{"$f":"IF(H25=0,0,Worksheet!AD44/I25)","v":0},0,{"$f":"IF(H25=0,0,Worksheet!AF44/I25)","v":0},0,{"$f":"Worksheet!J44","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U44)=FALSE,Worksheet!U44,\"\")","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!W44,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T45)=FALSE,VLOOKUP(Worksheet!C45,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E45","v":0},{"$f":"Worksheet!F45","v":0},{"$f":"Worksheet!S45","v":0},"HP",null,null,{"$f":"Worksheet!V45","v":0},{"$f":"IF(ISBLANK(Worksheet!T45)=FALSE,Worksheet!T45,\"\")","v":""},{"$f":"IF(H26=0,0,Worksheet!Z45/I26)","v":0},{"$f":"IF(H26=0,0,Worksheet!AD45/I26)","v":0},0,{"$f":"IF(H26=0,0,Worksheet!AF45/I26)","v":0},0,{"$f":"Worksheet!J45","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U45)=FALSE,Worksheet!U45,\"\")","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!W45,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!T46)=FALSE,VLOOKUP(Worksheet!C46,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E46","v":0},{"$f":"Worksheet!F46","v":0},{"$f":"Worksheet!S46","v":0},"HP",null,null,{"$f":"Worksheet!V46","v":0},{"$f":"IF(ISBLANK(Worksheet!T46)=FALSE,Worksheet!T46,\"\")","v":""},{"$f":"IF(H27=0,0,Worksheet!Z46/I27)","v":0},{"$f":"IF(H27=0,0,Worksheet!AD46/I27)","v":0},0,{"$f":"IF(H27=0,0,Worksheet!AF46/I27)","v":0},0,{"$f":"Worksheet!J46","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!U46)=FALSE,Worksheet!U46,\"\")","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!W46,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[14,"<-Version"]
[]
["2009-10-13",null,"Fixed export page s.t. incentive calculation is correct for Rotary type (removed per h.p. dependence)"]
["2012-01-13","V5","for 2012, rearranged columns B & C, added hot water pump, boiler draft fan, and kitchen hood options. Note kitchen hood savings not yet implemented"]
["2013-07-09","V7","no change for V7, skipped V6"]
["2018-06-21","V12","Updated to align with FY19 Protocols"]
["2019-07-01","V13","Added Enhanced Incentive Eligibility Section and Updated for FY20 Program"]
["2020-10-01","V14","Updated for FY21 Program"]