{"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":37,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,10,3,21],[15,9,18,9],[15,20,19,20],[15,6,19,6],[15,7,19,7],[15,0,19,0],[15,3,19,3],[15,11,19,11],[15,4,19,4],[15,5,19,5],[15,2,19,2],[4,10,4,11],[13,22,13,24],[12,22,12,24],[13,2,13,4],[8,2,8,5],[8,10,8,12],[15,34,19,34],[15,35,19,35],[15,27,19,27],[15,30,19,30],[15,31,19,31],[15,28,19,28],[15,32,19,32],[15,29,19,29],[15,33,19,33],[3,36,3,38],[4,36,7,38],[3,33,3,35],[4,33,7,35],[7,2,7,5],[7,10,7,21],[5,2,5,5],[4,2,4,5],[3,2,3,5],[15,26,19,26],[16,17,19,17],[16,19,19,19],[16,18,19,18],[15,10,19,10],[16,13,19,13],[16,14,19,14],[16,15,19,15],[16,16,19,16],[15,25,19,25],[15,21,19,21],[15,22,19,22],[15,23,19,23],[15,24,19,24]]}
["FY25 SmartStart New Construction - Variable Frequency Drives v1.0",null,null,null,null,null,null,null,null,"Incentive amounts are estimates until verified by the Program Manager."]
[]
["Customer Information"]
["Name",null,null,null,null,null,null,null,null,"Address",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"]
["Application",null,null,null,null,null,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,null,null,null,null,"Inspection Type"]
["Name",null,null,null,null,null,null,null,null,"Address"]
["Contact",null,null,null,null,null,null,null,null,"Phone"]
["Enhanced Incentive Eligibility"]
[false,null,false,false]
[false,null,false,false]
[null,null,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(U21:U46)","v":0}]
["Project Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Installed:",null,null,{"$f":"SUM(V21:V46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals",null,{"$f":"SUMIF($Y$21:$Y$46,\"<>#N/A\",$Y$21:$Y$46)","v":0},{"$f":"SUMIF($Z$21:$Z$46,\"<>#N/A\",$Z$21:$Z$46)","v":0},{"$f":"SUM(AA21:AA46)","v":0},0,0,0,0,0,0,0,0,0]
["Measure Code","Reason","Type or Usage","Motor Application","Variable Speed Air Compressor Manufacturer","Variable Speed Air Compressor\n Model Number","Motor Manufacturer","Motor Model Number",null,"HP of Controlled Motor","Motor Efficiency\n%","Drive Efficiency\n%","Air Compressor Location","Kitchen SF","Facility Type","Run Hours","Cooling Degree Days","Heating Degree Days","Power Reduction","Flow Reduction","# 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,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,"(per VFD)"]
[null,"N",{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(K21=\"\",N21=\"\",O21=\"\")=TRUE),J21=\"\",AND($C$14<>\"Existing Building\",A21=\"VFD11\"))=TRUE,0,IF(OR(J21<VLOOKUP(C21,VFDTable,4,FALSE),J21>VLOOKUP(C21,VFDTable,5,FALSE)=TRUE),0,VLOOKUP(J21,VFDIncentives,2,TRUE)))","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,W21,0)","v":0},{"$f":"U21*(W21+X21)","v":0},{"$f":"V21*(W21+X21)","v":0},{"$f":"IF(W21=0,0,IF(C21=\"K\",U21*(J21*0.9*0.746/K21*P21*S21)+(N21*0.7*1.4*T21*Q21*24*1.08/(3*3412)),IF(C21=\"A\",U21*6978*0.186*J21*0.746,U21*J21*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(W21=0,0,IF(C21=\"K\",V21*(J21*0.9*0.746/K21*P21*S21)+(N21*0.7*1.4*T21*Q21*24*1.08/(3*3412)),IF(C21=\"A\",V21*6978*0.186*J21*0.746,V21*J21*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":"AA21*15","v":0},{"$f":"AB21*15","v":0},{"$f":"IF(W21=0,0,IF(C21=\"K\",0,IF(C21=\"A\",U21*J21*0.186*1.05*0.746,U21*J21*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(W21=0,0,IF(C21=\"K\",0,IF(C21=\"A\",V21*J21*0.186*1.05*0.746,V21*J21*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(W21=0,0,IF(C21=\"K\",N21*0.7*1.4*T21*R21*24*1.08/(0.8*100000),0))","v":0},{"$f":"IF(W21=0,0,IF(C21=\"K\",N21*0.7*1.4*T21*R21*24*1.08/(0.8*100000),0))","v":0},{"$f":"AG21*15","v":0},{"$f":"AH21*15","v":0}]
[null,"N","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C22<>\"K\",O22=\"\")=TRUE,\"\",VLOOKUP(O22,KitchenHoodTable,2,FALSE))","v":""},{"$f":"IF(OR(C22<>\"K\",O22=\"\")=TRUE,\"\",VLOOKUP(O22,KitchenHoodTable,3,FALSE))","v":""},{"$f":"IF(OR(C22<>\"K\",O22=\"\")=TRUE,\"\",VLOOKUP(O22,KitchenHoodTable,4,FALSE))","v":""},{"$f":"IF(OR(C22<>\"K\",O22=\"\")=TRUE,\"\",VLOOKUP(O22,KitchenHoodTable,5,FALSE))","v":""},{"$f":"IF(OR(C22<>\"K\",O22=\"\")=TRUE,\"\",VLOOKUP(O22,KitchenHoodTable,6,FALSE))","v":""},null,null,{"$f":"IF(OR(A22=\"\",C22=\"\",AND(OR(A22=\"VFD1\",A22=\"VFD2\",A22=\"VFD3\",A22=\"VFD4\")=TRUE,D22=\"\")=TRUE,AND(A22=\"VFD11\",OR(K22=\"\",N22=\"\",O22=\"\")=TRUE),J22=\"\",AND($C$14<>\"Existing Building\",A22=\"VFD11\"))=TRUE,0,IF(OR(J22<VLOOKUP(C22,VFDTable,4,FALSE),J22>VLOOKUP(C22,VFDTable,5,FALSE)=TRUE),0,VLOOKUP(J22,VFDIncentives,2,TRUE)))","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,W22,0)","v":0},{"$f":"U22*(W22+X22)","v":0},{"$f":"U22*(W22+X22)","v":0},{"$f":"IF(W22=0,0,IF(C22=\"K\",U22*(J22*0.9*0.746/K22*P22*S22)+(N22*0.7*1.4*T22*Q22*24*1.08/(3*3412)),IF(C22=\"A\",U22*6978*0.186*J22*0.746,U22*J22*IF(OR(A22=\"VFD1\",A22=\"VFD2\",A22=\"VFD3\",A22=\"VFD4\")=TRUE,VLOOKUP(D22,MotorApplication_Lookup,2,FALSE),VLOOKUP(VLOOKUP(C22,VFDTable,2,FALSE),MotorApplication_Lookup,2,FALSE)))))","v":0},0,0,0,0,0,0,0,{"$f":"AG22*15","v":0},{"$f":"AH22*15","v":0}]
[null,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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,"N","",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!U21)=FALSE,VLOOKUP(Worksheet!C21,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E21","v":0},{"$f":"Worksheet!F21","v":0},{"$f":"Worksheet!J21","v":0},"HP",null,null,{"$f":"Worksheet!W21","v":0},{"$f":"IF(ISBLANK(Worksheet!U21)=FALSE,Worksheet!U21,\"\")","v":""},{"$f":"IF(H2=0,0,Worksheet!AA21/I2)","v":0},{"$f":"IF(H2=0,0,Worksheet!AE21/I2)","v":0},{"$f":"J2*15","v":0},{"$f":"IF(H2=0,0,Worksheet!AG21/I2)","v":0},{"$f":"M2*15","v":0},{"$f":"Worksheet!K21","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V21)=FALSE,Worksheet!V21,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X21,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U22)=FALSE,VLOOKUP(Worksheet!C22,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E22","v":0},{"$f":"Worksheet!F22","v":0},{"$f":"Worksheet!J22","v":0},"HP",null,null,{"$f":"Worksheet!W22","v":0},{"$f":"IF(ISBLANK(Worksheet!U22)=FALSE,Worksheet!U22,\"\")","v":""},{"$f":"IF(H3=0,0,Worksheet!AA22/I3)","v":0},{"$f":"IF(H3=0,0,Worksheet!AE22/I3)","v":0},{"$f":"J3*15","v":0},{"$f":"IF(H3=0,0,Worksheet!AG22/I3)","v":0},{"$f":"M3*15","v":0},{"$f":"Worksheet!K22","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V22)=FALSE,Worksheet!V22,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X22,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U23)=FALSE,VLOOKUP(Worksheet!C23,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E23","v":0},{"$f":"Worksheet!F23","v":0},{"$f":"Worksheet!J23","v":0},"HP",null,null,{"$f":"Worksheet!W23","v":0},{"$f":"IF(ISBLANK(Worksheet!U23)=FALSE,Worksheet!U23,\"\")","v":""},{"$f":"IF(H4=0,0,Worksheet!AA23/I4)","v":0},{"$f":"IF(H4=0,0,Worksheet!AE23/I4)","v":0},0,{"$f":"IF(H4=0,0,Worksheet!AG23/I4)","v":0},0,{"$f":"Worksheet!K23","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V23)=FALSE,Worksheet!V23,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X23,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U24)=FALSE,VLOOKUP(Worksheet!C24,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E24","v":0},{"$f":"Worksheet!F24","v":0},{"$f":"Worksheet!J24","v":0},"HP",null,null,{"$f":"Worksheet!W24","v":0},{"$f":"IF(ISBLANK(Worksheet!U24)=FALSE,Worksheet!U24,\"\")","v":""},{"$f":"IF(H5=0,0,Worksheet!AA24/I5)","v":0},{"$f":"IF(H5=0,0,Worksheet!AE24/I5)","v":0},0,{"$f":"IF(H5=0,0,Worksheet!AG24/I5)","v":0},0,{"$f":"Worksheet!K24","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V24)=FALSE,Worksheet!V24,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X24,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U25)=FALSE,VLOOKUP(Worksheet!C25,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E25","v":0},{"$f":"Worksheet!F25","v":0},{"$f":"Worksheet!J25","v":0},"HP",null,null,{"$f":"Worksheet!W25","v":0},{"$f":"IF(ISBLANK(Worksheet!U25)=FALSE,Worksheet!U25,\"\")","v":""},{"$f":"IF(H6=0,0,Worksheet!AA25/I6)","v":0},{"$f":"IF(H6=0,0,Worksheet!AE25/I6)","v":0},0,{"$f":"IF(H6=0,0,Worksheet!AG25/I6)","v":0},0,{"$f":"Worksheet!K25","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V25)=FALSE,Worksheet!V25,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X25,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U26)=FALSE,VLOOKUP(Worksheet!C26,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E26","v":0},{"$f":"Worksheet!F26","v":0},{"$f":"Worksheet!J26","v":0},"HP",null,null,{"$f":"Worksheet!W26","v":0},{"$f":"IF(ISBLANK(Worksheet!U26)=FALSE,Worksheet!U26,\"\")","v":""},{"$f":"IF(H7=0,0,Worksheet!AA26/I7)","v":0},{"$f":"IF(H7=0,0,Worksheet!AE26/I7)","v":0},0,{"$f":"IF(H7=0,0,Worksheet!AG26/I7)","v":0},0,{"$f":"Worksheet!K26","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V26)=FALSE,Worksheet!V26,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X26,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U27)=FALSE,VLOOKUP(Worksheet!C27,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E27","v":0},{"$f":"Worksheet!F27","v":0},{"$f":"Worksheet!J27","v":0},"HP",null,null,{"$f":"Worksheet!W27","v":0},{"$f":"IF(ISBLANK(Worksheet!U27)=FALSE,Worksheet!U27,\"\")","v":""},{"$f":"IF(H8=0,0,Worksheet!AA27/I8)","v":0},{"$f":"IF(H8=0,0,Worksheet!AE27/I8)","v":0},0,{"$f":"IF(H8=0,0,Worksheet!AG27/I8)","v":0},0,{"$f":"Worksheet!K27","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V27)=FALSE,Worksheet!V27,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X27,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U28)=FALSE,VLOOKUP(Worksheet!C28,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E28","v":0},{"$f":"Worksheet!F28","v":0},{"$f":"Worksheet!J28","v":0},"HP",null,null,{"$f":"Worksheet!W28","v":0},{"$f":"IF(ISBLANK(Worksheet!U28)=FALSE,Worksheet!U28,\"\")","v":""},{"$f":"IF(H9=0,0,Worksheet!AA28/I9)","v":0},{"$f":"IF(H9=0,0,Worksheet!AE28/I9)","v":0},0,{"$f":"IF(H9=0,0,Worksheet!AG28/I9)","v":0},0,{"$f":"Worksheet!K28","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V28)=FALSE,Worksheet!V28,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X28,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U29)=FALSE,VLOOKUP(Worksheet!C29,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E29","v":0},{"$f":"Worksheet!F29","v":0},{"$f":"Worksheet!J29","v":0},"HP",null,null,{"$f":"Worksheet!W29","v":0},{"$f":"IF(ISBLANK(Worksheet!U29)=FALSE,Worksheet!U29,\"\")","v":""},{"$f":"IF(H10=0,0,Worksheet!AA29/I10)","v":0},{"$f":"IF(H10=0,0,Worksheet!AE29/I10)","v":0},0,{"$f":"IF(H10=0,0,Worksheet!AG29/I10)","v":0},0,{"$f":"Worksheet!K29","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V29)=FALSE,Worksheet!V29,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X29,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U30)=FALSE,VLOOKUP(Worksheet!C30,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E30","v":0},{"$f":"Worksheet!F30","v":0},{"$f":"Worksheet!J30","v":0},"HP",null,null,{"$f":"Worksheet!W30","v":0},{"$f":"IF(ISBLANK(Worksheet!U30)=FALSE,Worksheet!U30,\"\")","v":""},{"$f":"IF(H11=0,0,Worksheet!AA30/I11)","v":0},{"$f":"IF(H11=0,0,Worksheet!AE30/I11)","v":0},0,{"$f":"IF(H11=0,0,Worksheet!AG30/I11)","v":0},0,{"$f":"Worksheet!K30","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V30)=FALSE,Worksheet!V30,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X30,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U31)=FALSE,VLOOKUP(Worksheet!C31,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E31","v":0},{"$f":"Worksheet!F31","v":0},{"$f":"Worksheet!J31","v":0},"HP",null,null,{"$f":"Worksheet!W31","v":0},{"$f":"IF(ISBLANK(Worksheet!U31)=FALSE,Worksheet!U31,\"\")","v":""},{"$f":"IF(H12=0,0,Worksheet!AA31/I12)","v":0},{"$f":"IF(H12=0,0,Worksheet!AE31/I12)","v":0},0,{"$f":"IF(H12=0,0,Worksheet!AG31/I12)","v":0},0,{"$f":"Worksheet!K31","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V31)=FALSE,Worksheet!V31,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X31,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U32)=FALSE,VLOOKUP(Worksheet!C32,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E32","v":0},{"$f":"Worksheet!F32","v":0},{"$f":"Worksheet!J32","v":0},"HP",null,null,{"$f":"Worksheet!W32","v":0},{"$f":"IF(ISBLANK(Worksheet!U32)=FALSE,Worksheet!U32,\"\")","v":""},{"$f":"IF(H13=0,0,Worksheet!AA32/I13)","v":0},{"$f":"IF(H13=0,0,Worksheet!AE32/I13)","v":0},0,{"$f":"IF(H13=0,0,Worksheet!AG32/I13)","v":0},0,{"$f":"Worksheet!K32","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V32)=FALSE,Worksheet!V32,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X32,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U33)=FALSE,VLOOKUP(Worksheet!C33,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E33","v":0},{"$f":"Worksheet!F33","v":0},{"$f":"Worksheet!J33","v":0},"HP",null,null,{"$f":"Worksheet!W33","v":0},{"$f":"IF(ISBLANK(Worksheet!U33)=FALSE,Worksheet!U33,\"\")","v":""},{"$f":"IF(H14=0,0,Worksheet!AA33/I14)","v":0},{"$f":"IF(H14=0,0,Worksheet!AE33/I14)","v":0},0,{"$f":"IF(H14=0,0,Worksheet!AG33/I14)","v":0},0,{"$f":"Worksheet!K33","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V33)=FALSE,Worksheet!V33,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X33,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U34)=FALSE,VLOOKUP(Worksheet!C34,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E34","v":0},{"$f":"Worksheet!F34","v":0},{"$f":"Worksheet!J34","v":0},"HP",null,null,{"$f":"Worksheet!W34","v":0},{"$f":"IF(ISBLANK(Worksheet!U34)=FALSE,Worksheet!U34,\"\")","v":""},{"$f":"IF(H15=0,0,Worksheet!AA34/I15)","v":0},{"$f":"IF(H15=0,0,Worksheet!AE34/I15)","v":0},0,{"$f":"IF(H15=0,0,Worksheet!AG34/I15)","v":0},0,{"$f":"Worksheet!K34","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V34)=FALSE,Worksheet!V34,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X34,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U35)=FALSE,VLOOKUP(Worksheet!C35,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E35","v":0},{"$f":"Worksheet!F35","v":0},{"$f":"Worksheet!J35","v":0},"HP",null,null,{"$f":"Worksheet!W35","v":0},{"$f":"IF(ISBLANK(Worksheet!U35)=FALSE,Worksheet!U35,\"\")","v":""},{"$f":"IF(H16=0,0,Worksheet!AA35/I16)","v":0},{"$f":"IF(H16=0,0,Worksheet!AE35/I16)","v":0},0,{"$f":"IF(H16=0,0,Worksheet!AG35/I16)","v":0},0,{"$f":"Worksheet!K35","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V35)=FALSE,Worksheet!V35,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X35,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U36)=FALSE,VLOOKUP(Worksheet!C36,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E36","v":0},{"$f":"Worksheet!F36","v":0},{"$f":"Worksheet!J36","v":0},"HP",null,null,{"$f":"Worksheet!W36","v":0},{"$f":"IF(ISBLANK(Worksheet!U36)=FALSE,Worksheet!U36,\"\")","v":""},{"$f":"IF(H17=0,0,Worksheet!AA36/I17)","v":0},{"$f":"IF(H17=0,0,Worksheet!AE36/I17)","v":0},0,{"$f":"IF(H17=0,0,Worksheet!AG36/I17)","v":0},0,{"$f":"Worksheet!K36","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V36)=FALSE,Worksheet!V36,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X36,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U37)=FALSE,VLOOKUP(Worksheet!C37,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E37","v":0},{"$f":"Worksheet!F37","v":0},{"$f":"Worksheet!J37","v":0},"HP",null,null,{"$f":"Worksheet!W37","v":0},{"$f":"IF(ISBLANK(Worksheet!U37)=FALSE,Worksheet!U37,\"\")","v":""},{"$f":"IF(H18=0,0,Worksheet!AA37/I18)","v":0},{"$f":"IF(H18=0,0,Worksheet!AE37/I18)","v":0},0,{"$f":"IF(H18=0,0,Worksheet!AG37/I18)","v":0},0,{"$f":"Worksheet!K37","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V37)=FALSE,Worksheet!V37,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X37,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U38)=FALSE,VLOOKUP(Worksheet!C38,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E38","v":0},{"$f":"Worksheet!F38","v":0},{"$f":"Worksheet!J38","v":0},"HP",null,null,{"$f":"Worksheet!W38","v":0},{"$f":"IF(ISBLANK(Worksheet!U38)=FALSE,Worksheet!U38,\"\")","v":""},{"$f":"IF(H19=0,0,Worksheet!AA38/I19)","v":0},{"$f":"IF(H19=0,0,Worksheet!AE38/I19)","v":0},0,{"$f":"IF(H19=0,0,Worksheet!AG38/I19)","v":0},0,{"$f":"Worksheet!K38","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V38)=FALSE,Worksheet!V38,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X38,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U39)=FALSE,VLOOKUP(Worksheet!C39,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E39","v":0},{"$f":"Worksheet!F39","v":0},{"$f":"Worksheet!J39","v":0},"HP",null,null,{"$f":"Worksheet!W39","v":0},{"$f":"IF(ISBLANK(Worksheet!U39)=FALSE,Worksheet!U39,\"\")","v":""},{"$f":"IF(H20=0,0,Worksheet!AA39/I20)","v":0},{"$f":"IF(H20=0,0,Worksheet!AE39/I20)","v":0},0,{"$f":"IF(H20=0,0,Worksheet!AG39/I20)","v":0},0,{"$f":"Worksheet!K39","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V39)=FALSE,Worksheet!V39,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X39,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U40)=FALSE,VLOOKUP(Worksheet!C40,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E40","v":0},{"$f":"Worksheet!F40","v":0},{"$f":"Worksheet!J40","v":0},"HP",null,null,{"$f":"Worksheet!W40","v":0},{"$f":"IF(ISBLANK(Worksheet!U40)=FALSE,Worksheet!U40,\"\")","v":""},{"$f":"IF(H21=0,0,Worksheet!AA40/I21)","v":0},{"$f":"IF(H21=0,0,Worksheet!AE40/I21)","v":0},0,{"$f":"IF(H21=0,0,Worksheet!AG40/I21)","v":0},0,{"$f":"Worksheet!K40","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V40)=FALSE,Worksheet!V40,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X40,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U41)=FALSE,VLOOKUP(Worksheet!C41,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E41","v":0},{"$f":"Worksheet!F41","v":0},{"$f":"Worksheet!J41","v":0},"HP",null,null,{"$f":"Worksheet!W41","v":0},{"$f":"IF(ISBLANK(Worksheet!U41)=FALSE,Worksheet!U41,\"\")","v":""},{"$f":"IF(H22=0,0,Worksheet!AA41/I22)","v":0},{"$f":"IF(H22=0,0,Worksheet!AE41/I22)","v":0},0,{"$f":"IF(H22=0,0,Worksheet!AG41/I22)","v":0},0,{"$f":"Worksheet!K41","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V41)=FALSE,Worksheet!V41,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X41,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U42)=FALSE,VLOOKUP(Worksheet!C42,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E42","v":0},{"$f":"Worksheet!F42","v":0},{"$f":"Worksheet!J42","v":0},"HP",null,null,{"$f":"Worksheet!W42","v":0},{"$f":"IF(ISBLANK(Worksheet!U42)=FALSE,Worksheet!U42,\"\")","v":""},{"$f":"IF(H23=0,0,Worksheet!AA42/I23)","v":0},{"$f":"IF(H23=0,0,Worksheet!AE42/I23)","v":0},0,{"$f":"IF(H23=0,0,Worksheet!AG42/I23)","v":0},0,{"$f":"Worksheet!K42","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V42)=FALSE,Worksheet!V42,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X42,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U43)=FALSE,VLOOKUP(Worksheet!C43,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E43","v":0},{"$f":"Worksheet!F43","v":0},{"$f":"Worksheet!J43","v":0},"HP",null,null,{"$f":"Worksheet!W43","v":0},{"$f":"IF(ISBLANK(Worksheet!U43)=FALSE,Worksheet!U43,\"\")","v":""},{"$f":"IF(H24=0,0,Worksheet!AA43/I24)","v":0},{"$f":"IF(H24=0,0,Worksheet!AE43/I24)","v":0},0,{"$f":"IF(H24=0,0,Worksheet!AG43/I24)","v":0},0,{"$f":"Worksheet!K43","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V43)=FALSE,Worksheet!V43,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X43,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U44)=FALSE,VLOOKUP(Worksheet!C44,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E44","v":0},{"$f":"Worksheet!F44","v":0},{"$f":"Worksheet!J44","v":0},"HP",null,null,{"$f":"Worksheet!W44","v":0},{"$f":"IF(ISBLANK(Worksheet!U44)=FALSE,Worksheet!U44,\"\")","v":""},{"$f":"IF(H25=0,0,Worksheet!AA44/I25)","v":0},{"$f":"IF(H25=0,0,Worksheet!AE44/I25)","v":0},0,{"$f":"IF(H25=0,0,Worksheet!AG44/I25)","v":0},0,{"$f":"Worksheet!K44","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V44)=FALSE,Worksheet!V44,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X44,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U45)=FALSE,VLOOKUP(Worksheet!C45,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E45","v":0},{"$f":"Worksheet!F45","v":0},{"$f":"Worksheet!J45","v":0},"HP",null,null,{"$f":"Worksheet!W45","v":0},{"$f":"IF(ISBLANK(Worksheet!U45)=FALSE,Worksheet!U45,\"\")","v":""},{"$f":"IF(H26=0,0,Worksheet!AA45/I26)","v":0},{"$f":"IF(H26=0,0,Worksheet!AE45/I26)","v":0},0,{"$f":"IF(H26=0,0,Worksheet!AG45/I26)","v":0},0,{"$f":"Worksheet!K45","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V45)=FALSE,Worksheet!V45,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X45,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!U46)=FALSE,VLOOKUP(Worksheet!C46,VFDTable,3,FALSE),\"\")","v":""},{"$f":"Worksheet!E46","v":0},{"$f":"Worksheet!F46","v":0},{"$f":"Worksheet!J46","v":0},"HP",null,null,{"$f":"Worksheet!W46","v":0},{"$f":"IF(ISBLANK(Worksheet!U46)=FALSE,Worksheet!U46,\"\")","v":""},{"$f":"IF(H27=0,0,Worksheet!AA46/I27)","v":0},{"$f":"IF(H27=0,0,Worksheet!AE46/I27)","v":0},0,{"$f":"IF(H27=0,0,Worksheet!AG46/I27)","v":0},0,{"$f":"Worksheet!K46","v":0},"%",null,{"$f":"IF(ISBLANK(Worksheet!V46)=FALSE,Worksheet!V46,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!X46,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"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"]
["2023-06-04",null,"Updated for FY24 Program by Jassimran Oberoi"]