{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Worksheet","Measure Code","electric cooking device list","Incentive Structure","Building Type","Export","Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"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":38,"n_cols":47,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,34,4,36],[5,31,8,33],[5,34,8,36],[2,32,2,33],[4,31,4,33],[7,1,7,2],[7,5,7,8],[2,1,2,3],[2,5,2,12],[6,1,6,2],[6,5,6,12],[4,1,4,3],[3,1,3,3]]}
["FY22 SmartStart New Construction - Food Service Equipment v1.0",null,null,"Incentive amounts are estimates until verified by the Program Manager."]
["Customer Information",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($X14:$X38)","v":0}]
["Name",null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Installed:",null,null,{"$f":"SUM($Y14:$Y38)","v":0},null,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,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,null,null,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":"SUM(AB14:AB38)","v":0},{"$f":"SUM(AC14:AC38)","v":0},null,{"$f":"SUM(AD14:AD38)","v":0},0,0,0,0,0,0,0,0,0,"Date",null,"Inspector/Sign-off"]
["Measure Code","Incentive Category","Incentive Subcategory","Description","Manufacturer","Model Number","Unit Capacity (Half, Full)","Building Type","Unit Volume (ft3)","Daily Energy Rate (kWh/day)","Ice Harvest (lb/day)","Ice Machine Energy Consumption (kWh/100 lbs)","Water Heater Energy Source (Gas/Electric)","Dishwasher Temperature (High/Low)","Booster Water Heater Energy Source (Gas/Electric)","Idle Energy Rate (kw or Btu/hr)","Combination Oven Steamer Mode Idle Energy Rate (kw or Btu/hr)","Combination Oven Convection Mode Idle Energy Rate (kw or Btu/hr)","Cooking Efficiency","Combination Oven Steamer Mode Efficiency","Combination Oven Convection Mode Efficiency","Number of Pans","Griddle Width (ft)","Quantity Committed","Quantity Installed","Incentive per Unit","Enhanced Incentive per Unit","Total Committed Incentive","Total Installed Incentive","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","Gas Annual Savings Committed (Therms)","Gas Annual Savings Installed (Therms)","Gas Lifetime Savings Committed (Therms)","Gas Lifetime Savings Installed (Therms)","FOUND PRE TYPE","Count","FOUND POST TYPE","count"," Operating Days/Year","Operating Hours/Day",null,"New or Replaced"]
[null,{"$f":"IF($A14=\"\",\"\",VLOOKUP($A14,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF($A14=\"\",\"\",VLOOKUP($A14,MeasureCode_Lookup,3,FALSE))","v":""},{"$f":"IF($A14=\"\",\"\",VLOOKUP($A14,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D14<>\"\",VLOOKUP(C14&D14,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z14,0)","v":0},{"$f":"(Z14+AA14)*X14","v":0},{"$f":"Y14*(Z14+AA14)","v":0},{"$f":"IF(ISBLANK($AU14)=FALSE, kWSavingsPerUnit(C14,D14,G14,I14,J14,K14,L14,M14,N14,O14,AR14,AS14,P14,S14,V14,W14,T14,U14,Q14,R14)*$X14, 0)","v":0},{"$f":"IF(ISBLANK($AU14)=FALSE,kWSavingsPerUnit(C14,D14,G14,I14,J14,K14,L14,M14,N14,O14,AR14,AS14,P14,S14,V14,W14,T14,U14,Q14,R14)*$Y14,0)","v":0},{"$f":"IF(ISBLANK($AU14)=FALSE,AnnualkWhSavingsPerUnit(C14,D14,G14,I14,J14,K14,L14,M14,N14,O14,AR14,AS14,P14,S14,V14,W14,T14,U14,Q14,R14)*$X14,0)","v":0},{"$f":"IF(ISBLANK($AU14)=FALSE,AnnualkWhSavingsPerUnit(C14,D14,G14,I14,J14,K14,L14,M14,N14,O14,AR14,AS14,P14,S14,V14,W14,T14,U14,Q14,R14)*$Y14,0)","v":0},{"$f":"IF($C14<>\"\",VLOOKUP($C14,'Building Type'!$H$4:$I$24,2,0),0)*$AF14","v":0},{"$f":"IF($C14<>\"\",VLOOKUP($C14,'Building Type'!$H$4:$I$24,2,0),0)*$AG14","v":0},{"$f":"IF(ISBLANK($AU14)=FALSE,AnnualThermSavingsPerUnit(C14,D14,G14,M14,N14,O14,AR14,AS14,P14,S14,V14,W14,T14,U14,Q14,R14)*$X14,0)","v":0},{"$f":"IF(ISBLANK($AU14)=FALSE,AnnualThermSavingsPerUnit(C14,D14,G14,M14,N14,O14,AR14,AS14,P14,S14,V14,W14,T14,U14,Q14,R14)*$Y14,0)","v":0},{"$f":"IF($C14<>\"\",VLOOKUP($C14,'Building Type'!$H$4:$I$24,2,0),0)*$AJ14","v":0},{"$f":"IF($C14<>\"\",VLOOKUP($C14,'Building Type'!$H$4:$I$24,2,0),0)*$AK14","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H14)=FALSE,VLOOKUP($H14,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H14)=FALSE,VLOOKUP($H14,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15<>\"\",VLOOKUP(C15&D15,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z15,0)","v":0},{"$f":"(Z15+AA15)*X15","v":0},{"$f":"Y15*(Z15+AA15)","v":0},{"$f":"IF(ISBLANK($AU15)=FALSE, kWSavingsPerUnit(C15,D15,G15,I15,J15,K15,L15,M15,N15,O15,AR15,AS15,P15,S15,V15,W15,T15,U15,Q15,R15)*$X15, 0)","v":0},{"$f":"IF(ISBLANK($AU15)=FALSE,kWSavingsPerUnit(C15,D15,G15,I15,J15,K15,L15,M15,N15,O15,AR15,AS15,P15,S15,V15,W15,T15,U15,Q15,R15)*$Y15,0)","v":0},{"$f":"IF(ISBLANK($AU15)=FALSE,AnnualkWhSavingsPerUnit(C15,D15,G15,I15,J15,K15,L15,M15,N15,O15,AR15,AS15,P15,S15,V15,W15,T15,U15,Q15,R15)*$X15,0)","v":0},{"$f":"IF(ISBLANK($AU15)=FALSE,AnnualkWhSavingsPerUnit(C15,D15,G15,I15,J15,K15,L15,M15,N15,O15,AR15,AS15,P15,S15,V15,W15,T15,U15,Q15,R15)*$Y15,0)","v":0},{"$f":"IF($C15<>\"\",VLOOKUP($C15,'Building Type'!$H$4:$I$24,2,0),0)*$AF15","v":0},{"$f":"IF($C15<>\"\",VLOOKUP($C15,'Building Type'!$H$4:$I$24,2,0),0)*$AG15","v":0},{"$f":"IF(ISBLANK($AU15)=FALSE,AnnualThermSavingsPerUnit(C15,D15,G15,M15,N15,O15,AR15,AS15,P15,S15,V15,W15,T15,U15,Q15,R15)*$X15,0)","v":0},{"$f":"IF(ISBLANK($AU15)=FALSE,AnnualThermSavingsPerUnit(C15,D15,G15,M15,N15,O15,AR15,AS15,P15,S15,V15,W15,T15,U15,Q15,R15)*$Y15,0)","v":0},{"$f":"IF($C15<>\"\",VLOOKUP($C15,'Building Type'!$H$4:$I$24,2,0),0)*$AJ15","v":0},{"$f":"IF($C15<>\"\",VLOOKUP($C15,'Building Type'!$H$4:$I$24,2,0),0)*$AK15","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H15)=FALSE,VLOOKUP($H15,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H15)=FALSE,VLOOKUP($H15,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16<>\"\",VLOOKUP(C16&D16,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z16,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU16)=FALSE, kWSavingsPerUnit(C16,D16,G16,I16,J16,K16,L16,M16,N16,O16,AR16,AS16,P16,S16,V16,W16,T16,U16,Q16,R16)*$X16, 0)","v":0},{"$f":"IF(ISBLANK($AU16)=FALSE,kWSavingsPerUnit(C16,D16,G16,I16,J16,K16,L16,M16,N16,O16,AR16,AS16,P16,S16,V16,W16,T16,U16,Q16,R16)*$Y16,0)","v":0},{"$f":"IF(ISBLANK($AU16)=FALSE,AnnualkWhSavingsPerUnit(C16,D16,G16,I16,J16,K16,L16,M16,N16,O16,AR16,AS16,P16,S16,V16,W16,T16,U16,Q16,R16)*$X16,0)","v":0},{"$f":"IF(ISBLANK($AU16)=FALSE,AnnualkWhSavingsPerUnit(C16,D16,G16,I16,J16,K16,L16,M16,N16,O16,AR16,AS16,P16,S16,V16,W16,T16,U16,Q16,R16)*$Y16,0)","v":0},{"$f":"IF($C16<>\"\",VLOOKUP($C16,'Building Type'!$H$4:$I$24,2,0),0)*$AF16","v":0},{"$f":"IF($C16<>\"\",VLOOKUP($C16,'Building Type'!$H$4:$I$24,2,0),0)*$AG16","v":0},{"$f":"IF(ISBLANK($AU16)=FALSE,AnnualThermSavingsPerUnit(C16,D16,G16,M16,N16,O16,AR16,AS16,P16,S16,V16,W16,T16,U16,Q16,R16)*$X16,0)","v":0},{"$f":"IF(ISBLANK($AU16)=FALSE,AnnualThermSavingsPerUnit(C16,D16,G16,M16,N16,O16,AR16,AS16,P16,S16,V16,W16,T16,U16,Q16,R16)*$Y16,0)","v":0},{"$f":"IF($C16<>\"\",VLOOKUP($C16,'Building Type'!$H$4:$I$24,2,0),0)*$AJ16","v":0},{"$f":"IF($C16<>\"\",VLOOKUP($C16,'Building Type'!$H$4:$I$24,2,0),0)*$AK16","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H16)=FALSE,VLOOKUP($H16,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H16)=FALSE,VLOOKUP($H16,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D17<>\"\",VLOOKUP(C17&D17,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z17,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU17)=FALSE, kWSavingsPerUnit(C17,D17,G17,I17,J17,K17,L17,M17,N17,O17,AR17,AS17,P17,S17,V17,W17,T17,U17,Q17,R17)*$X17, 0)","v":0},{"$f":"IF(ISBLANK($AU17)=FALSE,kWSavingsPerUnit(C17,D17,G17,I17,J17,K17,L17,M17,N17,O17,AR17,AS17,P17,S17,V17,W17,T17,U17,Q17,R17)*$Y17,0)","v":0},{"$f":"IF(ISBLANK($AU17)=FALSE,AnnualkWhSavingsPerUnit(C17,D17,G17,I17,J17,K17,L17,M17,N17,O17,AR17,AS17,P17,S17,V17,W17,T17,U17,Q17,R17)*$X17,0)","v":0},{"$f":"IF(ISBLANK($AU17)=FALSE,AnnualkWhSavingsPerUnit(C17,D17,G17,I17,J17,K17,L17,M17,N17,O17,AR17,AS17,P17,S17,V17,W17,T17,U17,Q17,R17)*$Y17,0)","v":0},{"$f":"IF($C17<>\"\",VLOOKUP($C17,'Building Type'!$H$4:$I$24,2,0),0)*$AF17","v":0},{"$f":"IF($C17<>\"\",VLOOKUP($C17,'Building Type'!$H$4:$I$24,2,0),0)*$AG17","v":0},{"$f":"IF(ISBLANK($AU17)=FALSE,AnnualThermSavingsPerUnit(C17,D17,G17,M17,N17,O17,AR17,AS17,P17,S17,V17,W17,T17,U17,Q17,R17)*$X17,0)","v":0},{"$f":"IF(ISBLANK($AU17)=FALSE,AnnualThermSavingsPerUnit(C17,D17,G17,M17,N17,O17,AR17,AS17,P17,S17,V17,W17,T17,U17,Q17,R17)*$Y17,0)","v":0},{"$f":"IF($C17<>\"\",VLOOKUP($C17,'Building Type'!$H$4:$I$24,2,0),0)*$AJ17","v":0},{"$f":"IF($C17<>\"\",VLOOKUP($C17,'Building Type'!$H$4:$I$24,2,0),0)*$AK17","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H17)=FALSE,VLOOKUP($H17,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H17)=FALSE,VLOOKUP($H17,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D18<>\"\",VLOOKUP(C18&D18,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z18,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU18)=FALSE, kWSavingsPerUnit(C18,D18,G18,I18,J18,K18,L18,M18,N18,O18,AR18,AS18,P18,S18,V18,W18,T18,U18,Q18,R18)*$X18, 0)","v":0},{"$f":"IF(ISBLANK($AU18)=FALSE,kWSavingsPerUnit(C18,D18,G18,I18,J18,K18,L18,M18,N18,O18,AR18,AS18,P18,S18,V18,W18,T18,U18,Q18,R18)*$Y18,0)","v":0},{"$f":"IF(ISBLANK($AU18)=FALSE,AnnualkWhSavingsPerUnit(C18,D18,G18,I18,J18,K18,L18,M18,N18,O18,AR18,AS18,P18,S18,V18,W18,T18,U18,Q18,R18)*$X18,0)","v":0},{"$f":"IF(ISBLANK($AU18)=FALSE,AnnualkWhSavingsPerUnit(C18,D18,G18,I18,J18,K18,L18,M18,N18,O18,AR18,AS18,P18,S18,V18,W18,T18,U18,Q18,R18)*$Y18,0)","v":0},{"$f":"IF($C18<>\"\",VLOOKUP($C18,'Building Type'!$H$4:$I$24,2,0),0)*$AF18","v":0},{"$f":"IF($C18<>\"\",VLOOKUP($C18,'Building Type'!$H$4:$I$24,2,0),0)*$AG18","v":0},{"$f":"IF(ISBLANK($AU18)=FALSE,AnnualThermSavingsPerUnit(C18,D18,G18,M18,N18,O18,AR18,AS18,P18,S18,V18,W18,T18,U18,Q18,R18)*$X18,0)","v":0},{"$f":"IF(ISBLANK($AU18)=FALSE,AnnualThermSavingsPerUnit(C18,D18,G18,M18,N18,O18,AR18,AS18,P18,S18,V18,W18,T18,U18,Q18,R18)*$Y18,0)","v":0},{"$f":"IF($C18<>\"\",VLOOKUP($C18,'Building Type'!$H$4:$I$24,2,0),0)*$AJ18","v":0},{"$f":"IF($C18<>\"\",VLOOKUP($C18,'Building Type'!$H$4:$I$24,2,0),0)*$AK18","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H18)=FALSE,VLOOKUP($H18,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H18)=FALSE,VLOOKUP($H18,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D19<>\"\",VLOOKUP(C19&D19,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z19,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU19)=FALSE, kWSavingsPerUnit(C19,D19,G19,I19,J19,K19,L19,M19,N19,O19,AR19,AS19,P19,S19,V19,W19,T19,U19,Q19,R19)*$X19, 0)","v":0},{"$f":"IF(ISBLANK($AU19)=FALSE,kWSavingsPerUnit(C19,D19,G19,I19,J19,K19,L19,M19,N19,O19,AR19,AS19,P19,S19,V19,W19,T19,U19,Q19,R19)*$Y19,0)","v":0},{"$f":"IF(ISBLANK($AU19)=FALSE,AnnualkWhSavingsPerUnit(C19,D19,G19,I19,J19,K19,L19,M19,N19,O19,AR19,AS19,P19,S19,V19,W19,T19,U19,Q19,R19)*$X19,0)","v":0},{"$f":"IF(ISBLANK($AU19)=FALSE,AnnualkWhSavingsPerUnit(C19,D19,G19,I19,J19,K19,L19,M19,N19,O19,AR19,AS19,P19,S19,V19,W19,T19,U19,Q19,R19)*$Y19,0)","v":0},{"$f":"IF($C19<>\"\",VLOOKUP($C19,'Building Type'!$H$4:$I$24,2,0),0)*$AF19","v":0},{"$f":"IF($C19<>\"\",VLOOKUP($C19,'Building Type'!$H$4:$I$24,2,0),0)*$AG19","v":0},{"$f":"IF(ISBLANK($AU19)=FALSE,AnnualThermSavingsPerUnit(C19,D19,G19,M19,N19,O19,AR19,AS19,P19,S19,V19,W19,T19,U19,Q19,R19)*$X19,0)","v":0},{"$f":"IF(ISBLANK($AU19)=FALSE,AnnualThermSavingsPerUnit(C19,D19,G19,M19,N19,O19,AR19,AS19,P19,S19,V19,W19,T19,U19,Q19,R19)*$Y19,0)","v":0},{"$f":"IF($C19<>\"\",VLOOKUP($C19,'Building Type'!$H$4:$I$24,2,0),0)*$AJ19","v":0},{"$f":"IF($C19<>\"\",VLOOKUP($C19,'Building Type'!$H$4:$I$24,2,0),0)*$AK19","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H19)=FALSE,VLOOKUP($H19,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H19)=FALSE,VLOOKUP($H19,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D20<>\"\",VLOOKUP(C20&D20,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z20,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU20)=FALSE, kWSavingsPerUnit(C20,D20,G20,I20,J20,K20,L20,M20,N20,O20,AR20,AS20,P20,S20,V20,W20,T20,U20,Q20,R20)*$X20, 0)","v":0},{"$f":"IF(ISBLANK($AU20)=FALSE,kWSavingsPerUnit(C20,D20,G20,I20,J20,K20,L20,M20,N20,O20,AR20,AS20,P20,S20,V20,W20,T20,U20,Q20,R20)*$Y20,0)","v":0},{"$f":"IF(ISBLANK($AU20)=FALSE,AnnualkWhSavingsPerUnit(C20,D20,G20,I20,J20,K20,L20,M20,N20,O20,AR20,AS20,P20,S20,V20,W20,T20,U20,Q20,R20)*$X20,0)","v":0},{"$f":"IF(ISBLANK($AU20)=FALSE,AnnualkWhSavingsPerUnit(C20,D20,G20,I20,J20,K20,L20,M20,N20,O20,AR20,AS20,P20,S20,V20,W20,T20,U20,Q20,R20)*$Y20,0)","v":0},{"$f":"IF($C20<>\"\",VLOOKUP($C20,'Building Type'!$H$4:$I$24,2,0),0)*$AF20","v":0},{"$f":"IF($C20<>\"\",VLOOKUP($C20,'Building Type'!$H$4:$I$24,2,0),0)*$AG20","v":0},{"$f":"IF(ISBLANK($AU20)=FALSE,AnnualThermSavingsPerUnit(C20,D20,G20,M20,N20,O20,AR20,AS20,P20,S20,V20,W20,T20,U20,Q20,R20)*$X20,0)","v":0},{"$f":"IF(ISBLANK($AU20)=FALSE,AnnualThermSavingsPerUnit(C20,D20,G20,M20,N20,O20,AR20,AS20,P20,S20,V20,W20,T20,U20,Q20,R20)*$Y20,0)","v":0},{"$f":"IF($C20<>\"\",VLOOKUP($C20,'Building Type'!$H$4:$I$24,2,0),0)*$AJ20","v":0},{"$f":"IF($C20<>\"\",VLOOKUP($C20,'Building Type'!$H$4:$I$24,2,0),0)*$AK20","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H20)=FALSE,VLOOKUP($H20,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H20)=FALSE,VLOOKUP($H20,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D21<>\"\",VLOOKUP(C21&D21,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z21,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU21)=FALSE, kWSavingsPerUnit(C21,D21,G21,I21,J21,K21,L21,M21,N21,O21,AR21,AS21,P21,S21,V21,W21,T21,U21,Q21,R21)*$X21, 0)","v":0},{"$f":"IF(ISBLANK($AU21)=FALSE,kWSavingsPerUnit(C21,D21,G21,I21,J21,K21,L21,M21,N21,O21,AR21,AS21,P21,S21,V21,W21,T21,U21,Q21,R21)*$Y21,0)","v":0},{"$f":"IF(ISBLANK($AU21)=FALSE,AnnualkWhSavingsPerUnit(C21,D21,G21,I21,J21,K21,L21,M21,N21,O21,AR21,AS21,P21,S21,V21,W21,T21,U21,Q21,R21)*$X21,0)","v":0},{"$f":"IF(ISBLANK($AU21)=FALSE,AnnualkWhSavingsPerUnit(C21,D21,G21,I21,J21,K21,L21,M21,N21,O21,AR21,AS21,P21,S21,V21,W21,T21,U21,Q21,R21)*$Y21,0)","v":0},{"$f":"IF($C21<>\"\",VLOOKUP($C21,'Building Type'!$H$4:$I$24,2,0),0)*$AF21","v":0},{"$f":"IF($C21<>\"\",VLOOKUP($C21,'Building Type'!$H$4:$I$24,2,0),0)*$AG21","v":0},{"$f":"IF(ISBLANK($AU21)=FALSE,AnnualThermSavingsPerUnit(C21,D21,G21,M21,N21,O21,AR21,AS21,P21,S21,V21,W21,T21,U21,Q21,R21)*$X21,0)","v":0},{"$f":"IF(ISBLANK($AU21)=FALSE,AnnualThermSavingsPerUnit(C21,D21,G21,M21,N21,O21,AR21,AS21,P21,S21,V21,W21,T21,U21,Q21,R21)*$Y21,0)","v":0},{"$f":"IF($C21<>\"\",VLOOKUP($C21,'Building Type'!$H$4:$I$24,2,0),0)*$AJ21","v":0},{"$f":"IF($C21<>\"\",VLOOKUP($C21,'Building Type'!$H$4:$I$24,2,0),0)*$AK21","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H21)=FALSE,VLOOKUP($H21,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H21)=FALSE,VLOOKUP($H21,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D22<>\"\",VLOOKUP(C22&D22,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z22,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU22)=FALSE, kWSavingsPerUnit(C22,D22,G22,I22,J22,K22,L22,M22,N22,O22,AR22,AS22,P22,S22,V22,W22,T22,U22,Q22,R22)*$X22, 0)","v":0},{"$f":"IF(ISBLANK($AU22)=FALSE,kWSavingsPerUnit(C22,D22,G22,I22,J22,K22,L22,M22,N22,O22,AR22,AS22,P22,S22,V22,W22,T22,U22,Q22,R22)*$Y22,0)","v":0},{"$f":"IF(ISBLANK($AU22)=FALSE,AnnualkWhSavingsPerUnit(C22,D22,G22,I22,J22,K22,L22,M22,N22,O22,AR22,AS22,P22,S22,V22,W22,T22,U22,Q22,R22)*$X22,0)","v":0},{"$f":"IF(ISBLANK($AU22)=FALSE,AnnualkWhSavingsPerUnit(C22,D22,G22,I22,J22,K22,L22,M22,N22,O22,AR22,AS22,P22,S22,V22,W22,T22,U22,Q22,R22)*$Y22,0)","v":0},{"$f":"IF($C22<>\"\",VLOOKUP($C22,'Building Type'!$H$4:$I$24,2,0),0)*$AF22","v":0},{"$f":"IF($C22<>\"\",VLOOKUP($C22,'Building Type'!$H$4:$I$24,2,0),0)*$AG22","v":0},{"$f":"IF(ISBLANK($AU22)=FALSE,AnnualThermSavingsPerUnit(C22,D22,G22,M22,N22,O22,AR22,AS22,P22,S22,V22,W22,T22,U22,Q22,R22)*$X22,0)","v":0},{"$f":"IF(ISBLANK($AU22)=FALSE,AnnualThermSavingsPerUnit(C22,D22,G22,M22,N22,O22,AR22,AS22,P22,S22,V22,W22,T22,U22,Q22,R22)*$Y22,0)","v":0},{"$f":"IF($C22<>\"\",VLOOKUP($C22,'Building Type'!$H$4:$I$24,2,0),0)*$AJ22","v":0},{"$f":"IF($C22<>\"\",VLOOKUP($C22,'Building Type'!$H$4:$I$24,2,0),0)*$AK22","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H22)=FALSE,VLOOKUP($H22,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H22)=FALSE,VLOOKUP($H22,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D23<>\"\",VLOOKUP(C23&D23,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z23,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU23)=FALSE, kWSavingsPerUnit(C23,D23,G23,I23,J23,K23,L23,M23,N23,O23,AR23,AS23,P23,S23,V23,W23,T23,U23,Q23,R23)*$X23, 0)","v":0},{"$f":"IF(ISBLANK($AU23)=FALSE,kWSavingsPerUnit(C23,D23,G23,I23,J23,K23,L23,M23,N23,O23,AR23,AS23,P23,S23,V23,W23,T23,U23,Q23,R23)*$Y23,0)","v":0},{"$f":"IF(ISBLANK($AU23)=FALSE,AnnualkWhSavingsPerUnit(C23,D23,G23,I23,J23,K23,L23,M23,N23,O23,AR23,AS23,P23,S23,V23,W23,T23,U23,Q23,R23)*$X23,0)","v":0},{"$f":"IF(ISBLANK($AU23)=FALSE,AnnualkWhSavingsPerUnit(C23,D23,G23,I23,J23,K23,L23,M23,N23,O23,AR23,AS23,P23,S23,V23,W23,T23,U23,Q23,R23)*$Y23,0)","v":0},{"$f":"IF($C23<>\"\",VLOOKUP($C23,'Building Type'!$H$4:$I$24,2,0),0)*$AF23","v":0},{"$f":"IF($C23<>\"\",VLOOKUP($C23,'Building Type'!$H$4:$I$24,2,0),0)*$AG23","v":0},{"$f":"IF(ISBLANK($AU23)=FALSE,AnnualThermSavingsPerUnit(C23,D23,G23,M23,N23,O23,AR23,AS23,P23,S23,V23,W23,T23,U23,Q23,R23)*$X23,0)","v":0},{"$f":"IF(ISBLANK($AU23)=FALSE,AnnualThermSavingsPerUnit(C23,D23,G23,M23,N23,O23,AR23,AS23,P23,S23,V23,W23,T23,U23,Q23,R23)*$Y23,0)","v":0},{"$f":"IF($C23<>\"\",VLOOKUP($C23,'Building Type'!$H$4:$I$24,2,0),0)*$AJ23","v":0},{"$f":"IF($C23<>\"\",VLOOKUP($C23,'Building Type'!$H$4:$I$24,2,0),0)*$AK23","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H23)=FALSE,VLOOKUP($H23,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H23)=FALSE,VLOOKUP($H23,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D24<>\"\",VLOOKUP(C24&D24,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z24,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU24)=FALSE, kWSavingsPerUnit(C24,D24,G24,I24,J24,K24,L24,M24,N24,O24,AR24,AS24,P24,S24,V24,W24,T24,U24,Q24,R24)*$X24, 0)","v":0},{"$f":"IF(ISBLANK($AU24)=FALSE,kWSavingsPerUnit(C24,D24,G24,I24,J24,K24,L24,M24,N24,O24,AR24,AS24,P24,S24,V24,W24,T24,U24,Q24,R24)*$Y24,0)","v":0},{"$f":"IF(ISBLANK($AU24)=FALSE,AnnualkWhSavingsPerUnit(C24,D24,G24,I24,J24,K24,L24,M24,N24,O24,AR24,AS24,P24,S24,V24,W24,T24,U24,Q24,R24)*$X24,0)","v":0},{"$f":"IF(ISBLANK($AU24)=FALSE,AnnualkWhSavingsPerUnit(C24,D24,G24,I24,J24,K24,L24,M24,N24,O24,AR24,AS24,P24,S24,V24,W24,T24,U24,Q24,R24)*$Y24,0)","v":0},{"$f":"IF($C24<>\"\",VLOOKUP($C24,'Building Type'!$H$4:$I$24,2,0),0)*$AF24","v":0},{"$f":"IF($C24<>\"\",VLOOKUP($C24,'Building Type'!$H$4:$I$24,2,0),0)*$AG24","v":0},{"$f":"IF(ISBLANK($AU24)=FALSE,AnnualThermSavingsPerUnit(C24,D24,G24,M24,N24,O24,AR24,AS24,P24,S24,V24,W24,T24,U24,Q24,R24)*$X24,0)","v":0},{"$f":"IF(ISBLANK($AU24)=FALSE,AnnualThermSavingsPerUnit(C24,D24,G24,M24,N24,O24,AR24,AS24,P24,S24,V24,W24,T24,U24,Q24,R24)*$Y24,0)","v":0},{"$f":"IF($C24<>\"\",VLOOKUP($C24,'Building Type'!$H$4:$I$24,2,0),0)*$AJ24","v":0},{"$f":"IF($C24<>\"\",VLOOKUP($C24,'Building Type'!$H$4:$I$24,2,0),0)*$AK24","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H24)=FALSE,VLOOKUP($H24,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H24)=FALSE,VLOOKUP($H24,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D25<>\"\",VLOOKUP(C25&D25,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z25,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU25)=FALSE, kWSavingsPerUnit(C25,D25,G25,I25,J25,K25,L25,M25,N25,O25,AR25,AS25,P25,S25,V25,W25,T25,U25,Q25,R25)*$X25, 0)","v":0},{"$f":"IF(ISBLANK($AU25)=FALSE,kWSavingsPerUnit(C25,D25,G25,I25,J25,K25,L25,M25,N25,O25,AR25,AS25,P25,S25,V25,W25,T25,U25,Q25,R25)*$Y25,0)","v":0},{"$f":"IF(ISBLANK($AU25)=FALSE,AnnualkWhSavingsPerUnit(C25,D25,G25,I25,J25,K25,L25,M25,N25,O25,AR25,AS25,P25,S25,V25,W25,T25,U25,Q25,R25)*$X25,0)","v":0},{"$f":"IF(ISBLANK($AU25)=FALSE,AnnualkWhSavingsPerUnit(C25,D25,G25,I25,J25,K25,L25,M25,N25,O25,AR25,AS25,P25,S25,V25,W25,T25,U25,Q25,R25)*$Y25,0)","v":0},{"$f":"IF($C25<>\"\",VLOOKUP($C25,'Building Type'!$H$4:$I$24,2,0),0)*$AF25","v":0},{"$f":"IF($C25<>\"\",VLOOKUP($C25,'Building Type'!$H$4:$I$24,2,0),0)*$AG25","v":0},{"$f":"IF(ISBLANK($AU25)=FALSE,AnnualThermSavingsPerUnit(C25,D25,G25,M25,N25,O25,AR25,AS25,P25,S25,V25,W25,T25,U25,Q25,R25)*$X25,0)","v":0},{"$f":"IF(ISBLANK($AU25)=FALSE,AnnualThermSavingsPerUnit(C25,D25,G25,M25,N25,O25,AR25,AS25,P25,S25,V25,W25,T25,U25,Q25,R25)*$Y25,0)","v":0},{"$f":"IF($C25<>\"\",VLOOKUP($C25,'Building Type'!$H$4:$I$24,2,0),0)*$AJ25","v":0},{"$f":"IF($C25<>\"\",VLOOKUP($C25,'Building Type'!$H$4:$I$24,2,0),0)*$AK25","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H25)=FALSE,VLOOKUP($H25,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H25)=FALSE,VLOOKUP($H25,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D26<>\"\",VLOOKUP(C26&D26,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z26,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU26)=FALSE, kWSavingsPerUnit(C26,D26,G26,I26,J26,K26,L26,M26,N26,O26,AR26,AS26,P26,S26,V26,W26,T26,U26,Q26,R26)*$X26, 0)","v":0},{"$f":"IF(ISBLANK($AU26)=FALSE,kWSavingsPerUnit(C26,D26,G26,I26,J26,K26,L26,M26,N26,O26,AR26,AS26,P26,S26,V26,W26,T26,U26,Q26,R26)*$Y26,0)","v":0},{"$f":"IF(ISBLANK($AU26)=FALSE,AnnualkWhSavingsPerUnit(C26,D26,G26,I26,J26,K26,L26,M26,N26,O26,AR26,AS26,P26,S26,V26,W26,T26,U26,Q26,R26)*$X26,0)","v":0},{"$f":"IF(ISBLANK($AU26)=FALSE,AnnualkWhSavingsPerUnit(C26,D26,G26,I26,J26,K26,L26,M26,N26,O26,AR26,AS26,P26,S26,V26,W26,T26,U26,Q26,R26)*$Y26,0)","v":0},{"$f":"IF($C26<>\"\",VLOOKUP($C26,'Building Type'!$H$4:$I$24,2,0),0)*$AF26","v":0},{"$f":"IF($C26<>\"\",VLOOKUP($C26,'Building Type'!$H$4:$I$24,2,0),0)*$AG26","v":0},{"$f":"IF(ISBLANK($AU26)=FALSE,AnnualThermSavingsPerUnit(C26,D26,G26,M26,N26,O26,AR26,AS26,P26,S26,V26,W26,T26,U26,Q26,R26)*$X26,0)","v":0},{"$f":"IF(ISBLANK($AU26)=FALSE,AnnualThermSavingsPerUnit(C26,D26,G26,M26,N26,O26,AR26,AS26,P26,S26,V26,W26,T26,U26,Q26,R26)*$Y26,0)","v":0},{"$f":"IF($C26<>\"\",VLOOKUP($C26,'Building Type'!$H$4:$I$24,2,0),0)*$AJ26","v":0},{"$f":"IF($C26<>\"\",VLOOKUP($C26,'Building Type'!$H$4:$I$24,2,0),0)*$AK26","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H26)=FALSE,VLOOKUP($H26,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H26)=FALSE,VLOOKUP($H26,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D27<>\"\",VLOOKUP(C27&D27,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z27,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU27)=FALSE, kWSavingsPerUnit(C27,D27,G27,I27,J27,K27,L27,M27,N27,O27,AR27,AS27,P27,S27,V27,W27,T27,U27,Q27,R27)*$X27, 0)","v":0},{"$f":"IF(ISBLANK($AU27)=FALSE,kWSavingsPerUnit(C27,D27,G27,I27,J27,K27,L27,M27,N27,O27,AR27,AS27,P27,S27,V27,W27,T27,U27,Q27,R27)*$Y27,0)","v":0},{"$f":"IF(ISBLANK($AU27)=FALSE,AnnualkWhSavingsPerUnit(C27,D27,G27,I27,J27,K27,L27,M27,N27,O27,AR27,AS27,P27,S27,V27,W27,T27,U27,Q27,R27)*$X27,0)","v":0},{"$f":"IF(ISBLANK($AU27)=FALSE,AnnualkWhSavingsPerUnit(C27,D27,G27,I27,J27,K27,L27,M27,N27,O27,AR27,AS27,P27,S27,V27,W27,T27,U27,Q27,R27)*$Y27,0)","v":0},{"$f":"IF($C27<>\"\",VLOOKUP($C27,'Building Type'!$H$4:$I$24,2,0),0)*$AF27","v":0},{"$f":"IF($C27<>\"\",VLOOKUP($C27,'Building Type'!$H$4:$I$24,2,0),0)*$AG27","v":0},{"$f":"IF(ISBLANK($AU27)=FALSE,AnnualThermSavingsPerUnit(C27,D27,G27,M27,N27,O27,AR27,AS27,P27,S27,V27,W27,T27,U27,Q27,R27)*$X27,0)","v":0},{"$f":"IF(ISBLANK($AU27)=FALSE,AnnualThermSavingsPerUnit(C27,D27,G27,M27,N27,O27,AR27,AS27,P27,S27,V27,W27,T27,U27,Q27,R27)*$Y27,0)","v":0},{"$f":"IF($C27<>\"\",VLOOKUP($C27,'Building Type'!$H$4:$I$24,2,0),0)*$AJ27","v":0},{"$f":"IF($C27<>\"\",VLOOKUP($C27,'Building Type'!$H$4:$I$24,2,0),0)*$AK27","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H27)=FALSE,VLOOKUP($H27,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H27)=FALSE,VLOOKUP($H27,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D28<>\"\",VLOOKUP(C28&D28,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z28,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU28)=FALSE, kWSavingsPerUnit(C28,D28,G28,I28,J28,K28,L28,M28,N28,O28,AR28,AS28,P28,S28,V28,W28,T28,U28,Q28,R28)*$X28, 0)","v":0},{"$f":"IF(ISBLANK($AU28)=FALSE,kWSavingsPerUnit(C28,D28,G28,I28,J28,K28,L28,M28,N28,O28,AR28,AS28,P28,S28,V28,W28,T28,U28,Q28,R28)*$Y28,0)","v":0},{"$f":"IF(ISBLANK($AU28)=FALSE,AnnualkWhSavingsPerUnit(C28,D28,G28,I28,J28,K28,L28,M28,N28,O28,AR28,AS28,P28,S28,V28,W28,T28,U28,Q28,R28)*$X28,0)","v":0},{"$f":"IF(ISBLANK($AU28)=FALSE,AnnualkWhSavingsPerUnit(C28,D28,G28,I28,J28,K28,L28,M28,N28,O28,AR28,AS28,P28,S28,V28,W28,T28,U28,Q28,R28)*$Y28,0)","v":0},{"$f":"IF($C28<>\"\",VLOOKUP($C28,'Building Type'!$H$4:$I$24,2,0),0)*$AF28","v":0},{"$f":"IF($C28<>\"\",VLOOKUP($C28,'Building Type'!$H$4:$I$24,2,0),0)*$AG28","v":0},{"$f":"IF(ISBLANK($AU28)=FALSE,AnnualThermSavingsPerUnit(C28,D28,G28,M28,N28,O28,AR28,AS28,P28,S28,V28,W28,T28,U28,Q28,R28)*$X28,0)","v":0},{"$f":"IF(ISBLANK($AU28)=FALSE,AnnualThermSavingsPerUnit(C28,D28,G28,M28,N28,O28,AR28,AS28,P28,S28,V28,W28,T28,U28,Q28,R28)*$Y28,0)","v":0},{"$f":"IF($C28<>\"\",VLOOKUP($C28,'Building Type'!$H$4:$I$24,2,0),0)*$AJ28","v":0},{"$f":"IF($C28<>\"\",VLOOKUP($C28,'Building Type'!$H$4:$I$24,2,0),0)*$AK28","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H28)=FALSE,VLOOKUP($H28,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H28)=FALSE,VLOOKUP($H28,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29<>\"\",VLOOKUP(C29&D29,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z29,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU29)=FALSE, kWSavingsPerUnit(C29,D29,G29,I29,J29,K29,L29,M29,N29,O29,AR29,AS29,P29,S29,V29,W29,T29,U29,Q29,R29)*$X29, 0)","v":0},{"$f":"IF(ISBLANK($AU29)=FALSE,kWSavingsPerUnit(C29,D29,G29,I29,J29,K29,L29,M29,N29,O29,AR29,AS29,P29,S29,V29,W29,T29,U29,Q29,R29)*$Y29,0)","v":0},{"$f":"IF(ISBLANK($AU29)=FALSE,AnnualkWhSavingsPerUnit(C29,D29,G29,I29,J29,K29,L29,M29,N29,O29,AR29,AS29,P29,S29,V29,W29,T29,U29,Q29,R29)*$X29,0)","v":0},{"$f":"IF(ISBLANK($AU29)=FALSE,AnnualkWhSavingsPerUnit(C29,D29,G29,I29,J29,K29,L29,M29,N29,O29,AR29,AS29,P29,S29,V29,W29,T29,U29,Q29,R29)*$Y29,0)","v":0},{"$f":"IF($C29<>\"\",VLOOKUP($C29,'Building Type'!$H$4:$I$24,2,0),0)*$AF29","v":0},{"$f":"IF($C29<>\"\",VLOOKUP($C29,'Building Type'!$H$4:$I$24,2,0),0)*$AG29","v":0},{"$f":"IF(ISBLANK($AU29)=FALSE,AnnualThermSavingsPerUnit(C29,D29,G29,M29,N29,O29,AR29,AS29,P29,S29,V29,W29,T29,U29,Q29,R29)*$X29,0)","v":0},{"$f":"IF(ISBLANK($AU29)=FALSE,AnnualThermSavingsPerUnit(C29,D29,G29,M29,N29,O29,AR29,AS29,P29,S29,V29,W29,T29,U29,Q29,R29)*$Y29,0)","v":0},{"$f":"IF($C29<>\"\",VLOOKUP($C29,'Building Type'!$H$4:$I$24,2,0),0)*$AJ29","v":0},{"$f":"IF($C29<>\"\",VLOOKUP($C29,'Building Type'!$H$4:$I$24,2,0),0)*$AK29","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H29)=FALSE,VLOOKUP($H29,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H29)=FALSE,VLOOKUP($H29,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D30<>\"\",VLOOKUP(C30&D30,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z30,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU30)=FALSE, kWSavingsPerUnit(C30,D30,G30,I30,J30,K30,L30,M30,N30,O30,AR30,AS30,P30,S30,V30,W30,T30,U30,Q30,R30)*$X30, 0)","v":0},{"$f":"IF(ISBLANK($AU30)=FALSE,kWSavingsPerUnit(C30,D30,G30,I30,J30,K30,L30,M30,N30,O30,AR30,AS30,P30,S30,V30,W30,T30,U30,Q30,R30)*$Y30,0)","v":0},{"$f":"IF(ISBLANK($AU30)=FALSE,AnnualkWhSavingsPerUnit(C30,D30,G30,I30,J30,K30,L30,M30,N30,O30,AR30,AS30,P30,S30,V30,W30,T30,U30,Q30,R30)*$X30,0)","v":0},{"$f":"IF(ISBLANK($AU30)=FALSE,AnnualkWhSavingsPerUnit(C30,D30,G30,I30,J30,K30,L30,M30,N30,O30,AR30,AS30,P30,S30,V30,W30,T30,U30,Q30,R30)*$Y30,0)","v":0},{"$f":"IF($C30<>\"\",VLOOKUP($C30,'Building Type'!$H$4:$I$24,2,0),0)*$AF30","v":0},{"$f":"IF($C30<>\"\",VLOOKUP($C30,'Building Type'!$H$4:$I$24,2,0),0)*$AG30","v":0},{"$f":"IF(ISBLANK($AU30)=FALSE,AnnualThermSavingsPerUnit(C30,D30,G30,M30,N30,O30,AR30,AS30,P30,S30,V30,W30,T30,U30,Q30,R30)*$X30,0)","v":0},{"$f":"IF(ISBLANK($AU30)=FALSE,AnnualThermSavingsPerUnit(C30,D30,G30,M30,N30,O30,AR30,AS30,P30,S30,V30,W30,T30,U30,Q30,R30)*$Y30,0)","v":0},{"$f":"IF($C30<>\"\",VLOOKUP($C30,'Building Type'!$H$4:$I$24,2,0),0)*$AJ30","v":0},{"$f":"IF($C30<>\"\",VLOOKUP($C30,'Building Type'!$H$4:$I$24,2,0),0)*$AK30","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H30)=FALSE,VLOOKUP($H30,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H30)=FALSE,VLOOKUP($H30,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D31<>\"\",VLOOKUP(C31&D31,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z31,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU31)=FALSE, kWSavingsPerUnit(C31,D31,G31,I31,J31,K31,L31,M31,N31,O31,AR31,AS31,P31,S31,V31,W31,T31,U31,Q31,R31)*$X31, 0)","v":0},{"$f":"IF(ISBLANK($AU31)=FALSE,kWSavingsPerUnit(C31,D31,G31,I31,J31,K31,L31,M31,N31,O31,AR31,AS31,P31,S31,V31,W31,T31,U31,Q31,R31)*$Y31,0)","v":0},{"$f":"IF(ISBLANK($AU31)=FALSE,AnnualkWhSavingsPerUnit(C31,D31,G31,I31,J31,K31,L31,M31,N31,O31,AR31,AS31,P31,S31,V31,W31,T31,U31,Q31,R31)*$X31,0)","v":0},{"$f":"IF(ISBLANK($AU31)=FALSE,AnnualkWhSavingsPerUnit(C31,D31,G31,I31,J31,K31,L31,M31,N31,O31,AR31,AS31,P31,S31,V31,W31,T31,U31,Q31,R31)*$Y31,0)","v":0},{"$f":"IF($C31<>\"\",VLOOKUP($C31,'Building Type'!$H$4:$I$24,2,0),0)*$AF31","v":0},{"$f":"IF($C31<>\"\",VLOOKUP($C31,'Building Type'!$H$4:$I$24,2,0),0)*$AG31","v":0},{"$f":"IF(ISBLANK($AU31)=FALSE,AnnualThermSavingsPerUnit(C31,D31,G31,M31,N31,O31,AR31,AS31,P31,S31,V31,W31,T31,U31,Q31,R31)*$X31,0)","v":0},{"$f":"IF(ISBLANK($AU31)=FALSE,AnnualThermSavingsPerUnit(C31,D31,G31,M31,N31,O31,AR31,AS31,P31,S31,V31,W31,T31,U31,Q31,R31)*$Y31,0)","v":0},{"$f":"IF($C31<>\"\",VLOOKUP($C31,'Building Type'!$H$4:$I$24,2,0),0)*$AJ31","v":0},{"$f":"IF($C31<>\"\",VLOOKUP($C31,'Building Type'!$H$4:$I$24,2,0),0)*$AK31","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H31)=FALSE,VLOOKUP($H31,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H31)=FALSE,VLOOKUP($H31,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D32<>\"\",VLOOKUP(C32&D32,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z32,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU32)=FALSE, kWSavingsPerUnit(C32,D32,G32,I32,J32,K32,L32,M32,N32,O32,AR32,AS32,P32,S32,V32,W32,T32,U32,Q32,R32)*$X32, 0)","v":0},{"$f":"IF(ISBLANK($AU32)=FALSE,kWSavingsPerUnit(C32,D32,G32,I32,J32,K32,L32,M32,N32,O32,AR32,AS32,P32,S32,V32,W32,T32,U32,Q32,R32)*$Y32,0)","v":0},{"$f":"IF(ISBLANK($AU32)=FALSE,AnnualkWhSavingsPerUnit(C32,D32,G32,I32,J32,K32,L32,M32,N32,O32,AR32,AS32,P32,S32,V32,W32,T32,U32,Q32,R32)*$X32,0)","v":0},{"$f":"IF(ISBLANK($AU32)=FALSE,AnnualkWhSavingsPerUnit(C32,D32,G32,I32,J32,K32,L32,M32,N32,O32,AR32,AS32,P32,S32,V32,W32,T32,U32,Q32,R32)*$Y32,0)","v":0},{"$f":"IF($C32<>\"\",VLOOKUP($C32,'Building Type'!$H$4:$I$24,2,0),0)*$AF32","v":0},{"$f":"IF($C32<>\"\",VLOOKUP($C32,'Building Type'!$H$4:$I$24,2,0),0)*$AG32","v":0},{"$f":"IF(ISBLANK($AU32)=FALSE,AnnualThermSavingsPerUnit(C32,D32,G32,M32,N32,O32,AR32,AS32,P32,S32,V32,W32,T32,U32,Q32,R32)*$X32,0)","v":0},{"$f":"IF(ISBLANK($AU32)=FALSE,AnnualThermSavingsPerUnit(C32,D32,G32,M32,N32,O32,AR32,AS32,P32,S32,V32,W32,T32,U32,Q32,R32)*$Y32,0)","v":0},{"$f":"IF($C32<>\"\",VLOOKUP($C32,'Building Type'!$H$4:$I$24,2,0),0)*$AJ32","v":0},{"$f":"IF($C32<>\"\",VLOOKUP($C32,'Building Type'!$H$4:$I$24,2,0),0)*$AK32","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H32)=FALSE,VLOOKUP($H32,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H32)=FALSE,VLOOKUP($H32,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D33<>\"\",VLOOKUP(C33&D33,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z33,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU33)=FALSE, kWSavingsPerUnit(C33,D33,G33,I33,J33,K33,L33,M33,N33,O33,AR33,AS33,P33,S33,V33,W33,T33,U33,Q33,R33)*$X33, 0)","v":0},{"$f":"IF(ISBLANK($AU33)=FALSE,kWSavingsPerUnit(C33,D33,G33,I33,J33,K33,L33,M33,N33,O33,AR33,AS33,P33,S33,V33,W33,T33,U33,Q33,R33)*$Y33,0)","v":0},{"$f":"IF(ISBLANK($AU33)=FALSE,AnnualkWhSavingsPerUnit(C33,D33,G33,I33,J33,K33,L33,M33,N33,O33,AR33,AS33,P33,S33,V33,W33,T33,U33,Q33,R33)*$X33,0)","v":0},{"$f":"IF(ISBLANK($AU33)=FALSE,AnnualkWhSavingsPerUnit(C33,D33,G33,I33,J33,K33,L33,M33,N33,O33,AR33,AS33,P33,S33,V33,W33,T33,U33,Q33,R33)*$Y33,0)","v":0},{"$f":"IF($C33<>\"\",VLOOKUP($C33,'Building Type'!$H$4:$I$24,2,0),0)*$AF33","v":0},{"$f":"IF($C33<>\"\",VLOOKUP($C33,'Building Type'!$H$4:$I$24,2,0),0)*$AG33","v":0},{"$f":"IF(ISBLANK($AU33)=FALSE,AnnualThermSavingsPerUnit(C33,D33,G33,M33,N33,O33,AR33,AS33,P33,S33,V33,W33,T33,U33,Q33,R33)*$X33,0)","v":0},{"$f":"IF(ISBLANK($AU33)=FALSE,AnnualThermSavingsPerUnit(C33,D33,G33,M33,N33,O33,AR33,AS33,P33,S33,V33,W33,T33,U33,Q33,R33)*$Y33,0)","v":0},{"$f":"IF($C33<>\"\",VLOOKUP($C33,'Building Type'!$H$4:$I$24,2,0),0)*$AJ33","v":0},{"$f":"IF($C33<>\"\",VLOOKUP($C33,'Building Type'!$H$4:$I$24,2,0),0)*$AK33","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H33)=FALSE,VLOOKUP($H33,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H33)=FALSE,VLOOKUP($H33,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D34<>\"\",VLOOKUP(C34&D34,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z34,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU34)=FALSE, kWSavingsPerUnit(C34,D34,G34,I34,J34,K34,L34,M34,N34,O34,AR34,AS34,P34,S34,V34,W34,T34,U34,Q34,R34)*$X34, 0)","v":0},{"$f":"IF(ISBLANK($AU34)=FALSE,kWSavingsPerUnit(C34,D34,G34,I34,J34,K34,L34,M34,N34,O34,AR34,AS34,P34,S34,V34,W34,T34,U34,Q34,R34)*$Y34,0)","v":0},{"$f":"IF(ISBLANK($AU34)=FALSE,AnnualkWhSavingsPerUnit(C34,D34,G34,I34,J34,K34,L34,M34,N34,O34,AR34,AS34,P34,S34,V34,W34,T34,U34,Q34,R34)*$X34,0)","v":0},{"$f":"IF(ISBLANK($AU34)=FALSE,AnnualkWhSavingsPerUnit(C34,D34,G34,I34,J34,K34,L34,M34,N34,O34,AR34,AS34,P34,S34,V34,W34,T34,U34,Q34,R34)*$Y34,0)","v":0},{"$f":"IF($C34<>\"\",VLOOKUP($C34,'Building Type'!$H$4:$I$24,2,0),0)*$AF34","v":0},{"$f":"IF($C34<>\"\",VLOOKUP($C34,'Building Type'!$H$4:$I$24,2,0),0)*$AG34","v":0},{"$f":"IF(ISBLANK($AU34)=FALSE,AnnualThermSavingsPerUnit(C34,D34,G34,M34,N34,O34,AR34,AS34,P34,S34,V34,W34,T34,U34,Q34,R34)*$X34,0)","v":0},{"$f":"IF(ISBLANK($AU34)=FALSE,AnnualThermSavingsPerUnit(C34,D34,G34,M34,N34,O34,AR34,AS34,P34,S34,V34,W34,T34,U34,Q34,R34)*$Y34,0)","v":0},{"$f":"IF($C34<>\"\",VLOOKUP($C34,'Building Type'!$H$4:$I$24,2,0),0)*$AJ34","v":0},{"$f":"IF($C34<>\"\",VLOOKUP($C34,'Building Type'!$H$4:$I$24,2,0),0)*$AK34","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H34)=FALSE,VLOOKUP($H34,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H34)=FALSE,VLOOKUP($H34,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D35<>\"\",VLOOKUP(C35&D35,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z35,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU35)=FALSE, kWSavingsPerUnit(C35,D35,G35,I35,J35,K35,L35,M35,N35,O35,AR35,AS35,P35,S35,V35,W35,T35,U35,Q35,R35)*$X35, 0)","v":0},{"$f":"IF(ISBLANK($AU35)=FALSE,kWSavingsPerUnit(C35,D35,G35,I35,J35,K35,L35,M35,N35,O35,AR35,AS35,P35,S35,V35,W35,T35,U35,Q35,R35)*$Y35,0)","v":0},{"$f":"IF(ISBLANK($AU35)=FALSE,AnnualkWhSavingsPerUnit(C35,D35,G35,I35,J35,K35,L35,M35,N35,O35,AR35,AS35,P35,S35,V35,W35,T35,U35,Q35,R35)*$X35,0)","v":0},{"$f":"IF(ISBLANK($AU35)=FALSE,AnnualkWhSavingsPerUnit(C35,D35,G35,I35,J35,K35,L35,M35,N35,O35,AR35,AS35,P35,S35,V35,W35,T35,U35,Q35,R35)*$Y35,0)","v":0},{"$f":"IF($C35<>\"\",VLOOKUP($C35,'Building Type'!$H$4:$I$24,2,0),0)*$AF35","v":0},{"$f":"IF($C35<>\"\",VLOOKUP($C35,'Building Type'!$H$4:$I$24,2,0),0)*$AG35","v":0},{"$f":"IF(ISBLANK($AU35)=FALSE,AnnualThermSavingsPerUnit(C35,D35,G35,M35,N35,O35,AR35,AS35,P35,S35,V35,W35,T35,U35,Q35,R35)*$X35,0)","v":0},{"$f":"IF(ISBLANK($AU35)=FALSE,AnnualThermSavingsPerUnit(C35,D35,G35,M35,N35,O35,AR35,AS35,P35,S35,V35,W35,T35,U35,Q35,R35)*$Y35,0)","v":0},{"$f":"IF($C35<>\"\",VLOOKUP($C35,'Building Type'!$H$4:$I$24,2,0),0)*$AJ35","v":0},{"$f":"IF($C35<>\"\",VLOOKUP($C35,'Building Type'!$H$4:$I$24,2,0),0)*$AK35","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H35)=FALSE,VLOOKUP($H35,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H35)=FALSE,VLOOKUP($H35,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D36<>\"\",VLOOKUP(C36&D36,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z36,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU36)=FALSE, kWSavingsPerUnit(C36,D36,G36,I36,J36,K36,L36,M36,N36,O36,AR36,AS36,P36,S36,V36,W36,T36,U36,Q36,R36)*$X36, 0)","v":0},{"$f":"IF(ISBLANK($AU36)=FALSE,kWSavingsPerUnit(C36,D36,G36,I36,J36,K36,L36,M36,N36,O36,AR36,AS36,P36,S36,V36,W36,T36,U36,Q36,R36)*$Y36,0)","v":0},{"$f":"IF(ISBLANK($AU36)=FALSE,AnnualkWhSavingsPerUnit(C36,D36,G36,I36,J36,K36,L36,M36,N36,O36,AR36,AS36,P36,S36,V36,W36,T36,U36,Q36,R36)*$X36,0)","v":0},{"$f":"IF(ISBLANK($AU36)=FALSE,AnnualkWhSavingsPerUnit(C36,D36,G36,I36,J36,K36,L36,M36,N36,O36,AR36,AS36,P36,S36,V36,W36,T36,U36,Q36,R36)*$Y36,0)","v":0},{"$f":"IF($C36<>\"\",VLOOKUP($C36,'Building Type'!$H$4:$I$24,2,0),0)*$AF36","v":0},{"$f":"IF($C36<>\"\",VLOOKUP($C36,'Building Type'!$H$4:$I$24,2,0),0)*$AG36","v":0},{"$f":"IF(ISBLANK($AU36)=FALSE,AnnualThermSavingsPerUnit(C36,D36,G36,M36,N36,O36,AR36,AS36,P36,S36,V36,W36,T36,U36,Q36,R36)*$X36,0)","v":0},{"$f":"IF(ISBLANK($AU36)=FALSE,AnnualThermSavingsPerUnit(C36,D36,G36,M36,N36,O36,AR36,AS36,P36,S36,V36,W36,T36,U36,Q36,R36)*$Y36,0)","v":0},{"$f":"IF($C36<>\"\",VLOOKUP($C36,'Building Type'!$H$4:$I$24,2,0),0)*$AJ36","v":0},{"$f":"IF($C36<>\"\",VLOOKUP($C36,'Building Type'!$H$4:$I$24,2,0),0)*$AK36","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H36)=FALSE,VLOOKUP($H36,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H36)=FALSE,VLOOKUP($H36,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D37<>\"\",VLOOKUP(C37&D37,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z37,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU37)=FALSE, kWSavingsPerUnit(C37,D37,G37,I37,J37,K37,L37,M37,N37,O37,AR37,AS37,P37,S37,V37,W37,T37,U37,Q37,R37)*$X37, 0)","v":0},{"$f":"IF(ISBLANK($AU37)=FALSE,kWSavingsPerUnit(C37,D37,G37,I37,J37,K37,L37,M37,N37,O37,AR37,AS37,P37,S37,V37,W37,T37,U37,Q37,R37)*$Y37,0)","v":0},{"$f":"IF(ISBLANK($AU37)=FALSE,AnnualkWhSavingsPerUnit(C37,D37,G37,I37,J37,K37,L37,M37,N37,O37,AR37,AS37,P37,S37,V37,W37,T37,U37,Q37,R37)*$X37,0)","v":0},{"$f":"IF(ISBLANK($AU37)=FALSE,AnnualkWhSavingsPerUnit(C37,D37,G37,I37,J37,K37,L37,M37,N37,O37,AR37,AS37,P37,S37,V37,W37,T37,U37,Q37,R37)*$Y37,0)","v":0},{"$f":"IF($C37<>\"\",VLOOKUP($C37,'Building Type'!$H$4:$I$24,2,0),0)*$AF37","v":0},{"$f":"IF($C37<>\"\",VLOOKUP($C37,'Building Type'!$H$4:$I$24,2,0),0)*$AG37","v":0},{"$f":"IF(ISBLANK($AU37)=FALSE,AnnualThermSavingsPerUnit(C37,D37,G37,M37,N37,O37,AR37,AS37,P37,S37,V37,W37,T37,U37,Q37,R37)*$X37,0)","v":0},{"$f":"IF(ISBLANK($AU37)=FALSE,AnnualThermSavingsPerUnit(C37,D37,G37,M37,N37,O37,AR37,AS37,P37,S37,V37,W37,T37,U37,Q37,R37)*$Y37,0)","v":0},{"$f":"IF($C37<>\"\",VLOOKUP($C37,'Building Type'!$H$4:$I$24,2,0),0)*$AJ37","v":0},{"$f":"IF($C37<>\"\",VLOOKUP($C37,'Building Type'!$H$4:$I$24,2,0),0)*$AK37","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H37)=FALSE,VLOOKUP($H37,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H37)=FALSE,VLOOKUP($H37,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D38<>\"\",VLOOKUP(C38&D38,'Incentive Structure'!$H$4:$J$60,2,0),0)","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE,$C$10=TRUE,$C$11=TRUE)=TRUE,Z38,0)","v":0},0,0,{"$f":"IF(ISBLANK($AU38)=FALSE, kWSavingsPerUnit(C38,D38,G38,I38,J38,K38,L38,M38,N38,O38,AR38,AS38,P38,S38,V38,W38,T38,U38,Q38,R38)*$X38, 0)","v":0},{"$f":"IF(ISBLANK($AU38)=FALSE,kWSavingsPerUnit(C38,D38,G38,I38,J38,K38,L38,M38,N38,O38,AR38,AS38,P38,S38,V38,W38,T38,U38,Q38,R38)*$Y38,0)","v":0},{"$f":"IF(ISBLANK($AU38)=FALSE,AnnualkWhSavingsPerUnit(C38,D38,G38,I38,J38,K38,L38,M38,N38,O38,AR38,AS38,P38,S38,V38,W38,T38,U38,Q38,R38)*$X38,0)","v":0},{"$f":"IF(ISBLANK($AU38)=FALSE,AnnualkWhSavingsPerUnit(C38,D38,G38,I38,J38,K38,L38,M38,N38,O38,AR38,AS38,P38,S38,V38,W38,T38,U38,Q38,R38)*$Y38,0)","v":0},{"$f":"IF($C38<>\"\",VLOOKUP($C38,'Building Type'!$H$4:$I$24,2,0),0)*$AF38","v":0},{"$f":"IF($C38<>\"\",VLOOKUP($C38,'Building Type'!$H$4:$I$24,2,0),0)*$AG38","v":0},{"$f":"IF(ISBLANK($AU38)=FALSE,AnnualThermSavingsPerUnit(C38,D38,G38,M38,N38,O38,AR38,AS38,P38,S38,V38,W38,T38,U38,Q38,R38)*$X38,0)","v":0},{"$f":"IF(ISBLANK($AU38)=FALSE,AnnualThermSavingsPerUnit(C38,D38,G38,M38,N38,O38,AR38,AS38,P38,S38,V38,W38,T38,U38,Q38,R38)*$Y38,0)","v":0},{"$f":"IF($C38<>\"\",VLOOKUP($C38,'Building Type'!$H$4:$I$24,2,0),0)*$AJ38","v":0},{"$f":"IF($C38<>\"\",VLOOKUP($C38,'Building Type'!$H$4:$I$24,2,0),0)*$AK38","v":0},null,null,null,null,{"$f":"IF(ISBLANK($H38)=FALSE,VLOOKUP($H38,'Building Type'!$A$4:$C$24,2,0),0)","v":0},{"$f":"IF(ISBLANK($H38)=FALSE,VLOOKUP($H38,'Building Type'!$A$4:$C$24,3,0),0)","v":0},null,"N"]

{"sheet":"Measure Code","index":1,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Incentive Category","Incentive Subcategory","Description","Measure ID in DB"]
["FOOD1","Cooking","Combination Oven Steamer Electric","Combination Oven Steamer Electric - <15 Pans",1404]
["FOOD2","Cooking","Combination Oven Steamer Electric","Combination Oven Steamer Electric - 15 to 28 pans",1404]
["FOOD3","Cooking","Combination Oven Steamer Electric","Combination Oven Steamer Electric - >28 Pans",1404]
["FOOD4","Cooking","Combination Oven Steamer Natural Gas","Combination Oven Steamer Natural Gas - <15 Pans",1405]
["FOOD5","Cooking","Combination Oven Steamer Natural Gas","Combination Oven Steamer Natural Gas - 15 to 28 pans",1405]
["FOOD6","Cooking","Combination Oven Steamer Natural Gas","Combination Oven Steamer Natural Gas - >28 Pans",1405]
["FOOD7","Cooling","Glass Door Refrigerators","Energy Star - Internal Volume <15 CF",1406]
["FOOD8","Cooling","Glass Door Refrigerators","Energy Star - Internal Volume 15-29.9 CF",1406]
["FOOD9","Cooling","Glass Door Refrigerators","Energy Star - Internal Volume 30-49.9 CF",1406]
["FOOD10","Cooling","Glass Door Refrigerators","Energy Star - Internal Volume >50 CF",1406]
["FOOD11","Cooling","Solid Door Refrigerators","Energy Star - Internal Volume <15 CF",1407]
["FOOD12","Cooling","Solid Door Refrigerators","Energy Star - Internal Volume 15-29.9 CF",1407]
["FOOD13","Cooling","Solid Door Refrigerators","Energy Star - Internal Volume 30-49.9 CF",1407]
["FOOD14","Cooling","Solid Door Refrigerators","Energy Star - Internal Volume >50 CF",1407]
["FOOD15","Cooling","Glass Door Freezers","Energy Star - Internal Volume <15 CF",1408]
["FOOD16","Cooling","Glass Door Freezers","Energy Star - Internal Volume 15-29.9 CF",1408]
["FOOD17","Cooling","Glass Door Freezers","Energy Star - Internal Volume 30-49.9 CF",1408]
["FOOD18","Cooling","Glass Door Freezers","Energy Star - Internal Volume >50 CF",1408]
["FOOD19","Cooling","Solid Door Freezers","Energy Star - Internal Volume <15 CF",1409]
["FOOD20","Cooling","Solid Door Freezers","Energy Star - Internal Volume 15-29.9 CF",1409]
["FOOD21","Cooling","Solid Door Freezers","Energy Star - Internal Volume 30-49.9 CF",1409]
["FOOD22","Cooling","Solid Door Freezers","Energy Star - Internal Volume >50 CF",1409]
["FOOD23","Cooling","Ice Machines","Energy Star Ice Machine 101-200 lbs/day",1397]
["FOOD24","Cooling","Ice Machines","Energy Star Ice Machine 201-300 lbs/day",1397]
["FOOD25","Cooling","Ice Machines","Energy Star Ice Machine 301-400 lbs/day",1397]
["FOOD26","Cooling","Ice Machines","Energy Star Ice Machine 401-500 lbs/day",1397]
["FOOD27","Cooling","Ice Machines","Energy Star Ice Machine 501-1,000 lbs/day",1397]
["FOOD28","Cooling","Ice Machines","Energy Star Ice Machine 1,001-1,500 lbs/day",1397]
["FOOD29","Cooling","Ice Machines","Energy Star Ice Machine >1,500 lbs/day",1397]
["FOOD30","Cooling","Ice Machines","Super-Efficient Ice Machine 101-200 lbs/day",1397]
["FOOD31","Cooling","Ice Machines","Super-Efficient Ice Machine 201-300 lbs/day",1397]
["FOOD32","Cooling","Ice Machines","Super-Efficient Ice Machine 301-400 lbs/day",1397]
["FOOD33","Cooling","Ice Machines","Super-Efficient Ice Machine 401-500 lbs/day",1397]
["FOOD34","Cooling","Ice Machines","Super-Efficient Ice Machine 501-1,000 lbs/day",1397]
["FOOD35","Cooling","Ice Machines","Super-Efficient Ice Machine 1,001-1,500 lbs/day",1397]
["FOOD36","Cooling","Ice Machines","Super-Efficient Ice Machine >1,500 lbs/day",1397]
["FOOD37","Cooking","Convection Oven Electric","Convection Oven Electric",1398]
["FOOD38","Cooking","Convection Oven Natural Gas","Convection Oven Natural Gas",1399]
["FOOD39","Cooking","Rack Oven Natural Gas","Rack Oven Single Natural Gas",1400]
["FOOD40","Cooking","Rack Oven Natural Gas","Rack Oven Double Natural Gas",1400]
["FOOD41","Cooking","Conveyor Oven Natural Gas","Conveyor Oven Small Natural Gas",1401]
["FOOD42","Cooking","Conveyor Oven Natural Gas","Conveyor Oven Large Natural Gas",1401]
["FOOD43","Cooking","Fryer Electric","Fryer Electric",1392]
["FOOD44","Cooking","Fryer Natural Gas","Fryer Natural Gas",1393]
["FOOD45","Cooking","Large Vat Fryer Electric","Large Vat Fryer Electric",1392]
["FOOD46","Cooking","Large Vat Fryer Natural Gas","Large Vat Fryer Natural Gas",1393]
["FOOD47","Cooking","Griddle Electric","Griddle Electric",1394]
["FOOD48","Cooking","Griddle Natural Gas","Griddle Natural Gas",1395]
["FOOD49","Cooking","Steam Cooker Electric","Steam Cooker Electric",1402]
["FOOD50","Cooking","Steam Cooker Natural Gas","Steam Cooker Natural Gas",1403]
["FOOD51","Holding","Insulated Holding Cabinets","Insulated Holding Cabinets - Full Size",1396]
["FOOD52","Holding","Insulated Holding Cabinets","Insulated Holding Cabinets - 3/4 Size",1396]
["FOOD53","Holding","Insulated Holding Cabinets","Insulated Holding Cabinets - 1/2 Size",1396]
["FOOD54","Cleaning","Dishwasher","Under Counter",1391]
["FOOD55","Cleaning","Dishwasher","Door Type",1391]
["FOOD56","Cleaning","Dishwasher","Single Tank Conveyor",1391]
["FOOD57","Cleaning","Dishwasher","Multiple Tank Conveyor",1391]

{"sheet":"electric cooking device list","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,"equivalent max btuh","kW"]
[null,"FOOD1","Cooking","Combination Oven Steamer Electric","Combination Oven Steamer Electric - <15 Pans",1404,{"$f":"200*15+6511","v":9511},{"$f":"((G3-6511)/200)*0.133+0.64","v":2.6350000000000002}]
[null,"FOOD2","Cooking","Combination Oven Steamer Electric","Combination Oven Steamer Electric - 15 to 28 pans",1404,{"$f":"200*28+6511","v":12111},{"$f":"((G4-6511)/200)*0.133+0.64","v":4.3639999999999999}]
[null,"FOOD3","Cooking","Combination Oven Steamer Electric","Combination Oven Steamer Electric - >28 Pans",1404,{"$f":"200*29+6511","v":12311},4.4969999999999999]
[null,"FOOD37","Cooking","Convection Oven Electric","Convection Oven Electric",1398,12000,1.6]
[null,"FOOD43","Cooking","Fryer Electric","Fryer Electric",1392,9000,0.8]
[null,"FOOD45","Cooking","Large Vat Fryer Electric","Large Vat Fryer Electric",1392,12000,1.1000000000000001]
[null,"FOOD47","Cooking","Griddle Electric","Griddle Electric",1394,2650,0.35499999999999998]
[null,"FOOD49","Cooking","Steam Cooker Electric","Steam Cooker Electric",1402,6250,0.4]

{"sheet":"Incentive Structure","index":3,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":true,"merged":[[2,11,2,14],[1,1,1,9]]}
[]
[null,"Food Service Equipment Incentives"]
[null,"Category","Subcategory","Measure ID",null,"Subcategory","Description","Key","Incentive","Unit Measure",null,"TEST"]
[null,"Cooking","Combination Oven Steamer Electric",1404,null,"Combination Oven Steamer Electric","Combination Oven Steamer Electric - <15 Pans",{"$f":"C4&G4","v":"Combination Oven Steamer ElectricCombination Oven Steamer Electric - <15 Pans"},1000,"oven",null,"Cooking","Convection Oven Natural Gas","Convection Oven Natural Gas",{"$f":"VLOOKUP(N4,G4:J56,2,0)","v":"Convection Oven Natural GasConvection Oven Natural Gas"}]
[null,"Cooking","Combination Oven Steamer Natural Gas",1405,null,"Combination Oven Steamer Electric","Combination Oven Steamer Electric - 15 to 28 pans",{"$f":"C4&G5","v":"Combination Oven Steamer ElectricCombination Oven Steamer Electric - 15 to 28 pans"},1000,"oven"]
[null,"Cooking","Convection Oven Electric",1398,null,"Combination Oven Steamer Electric","Combination Oven Steamer Electric - >28 Pans",{"$f":"C4&G6","v":"Combination Oven Steamer ElectricCombination Oven Steamer Electric - >28 Pans"},1000,"oven"]
[null,"Cooking","Convection Oven Natural Gas",1399,null,"Combination Oven Steamer Natural Gas","Combination Oven Steamer Natural Gas - <15 Pans",{"$f":"C5&G7","v":"Combination Oven Steamer Natural GasCombination Oven Steamer Natural Gas - <15 Pans"},750,"oven"]
[null,"Cooking","Rack Oven Natural Gas",1400,null,"Combination Oven Steamer Natural Gas","Combination Oven Steamer Natural Gas - 15 to 28 pans",{"$f":"C5&G8","v":"Combination Oven Steamer Natural GasCombination Oven Steamer Natural Gas - 15 to 28 pans"},750,"oven",null,"Cooling","Glass Door Freezers","Energy Star - Internal Volume 15-29.9 CF",{"$f":"VLOOKUP(N8,G8:J60,2,0)","v":"Glass Door RefrigeratorsEnergy Star - Internal Volume 15-29.9 CF"}]
[null,"Cooking","Conveyor Oven Natural Gas",1401,null,"Combination Oven Steamer Natural Gas","Combination Oven Steamer Natural Gas - >28 Pans",{"$f":"C5&G9","v":"Combination Oven Steamer Natural GasCombination Oven Steamer Natural Gas - >28 Pans"},750,"oven"]
[null,"Cooking","Fryer Electric",1392,null,"Convection Oven Electric","Convection Oven Electric",{"$f":"C6&Convection_Oven_Electric","v":"Convection Oven ElectricConvection Oven Electric"},350,"oven"]
[null,"Cooking","Fryer Natural Gas",1393,null,"Convection Oven Natural Gas","Convection Oven Natural Gas",{"$f":"C7&Convection_Oven_Natural_Gas","v":"Convection Oven Natural GasConvection Oven Natural Gas"},500,"oven"]
[null,"Cooking","Large Vat Fryer Electric",1392,null,"Rack Oven Natural Gas","Rack Oven Single Natural Gas",{"$f":"C8&G12","v":"Rack Oven Natural GasRack Oven Single Natural Gas"},1000,"single oven"]
[null,"Cooking","Large Vat Fryer Natural Gas",1393,null,"Rack Oven Natural Gas","Rack Oven Double Natural Gas",{"$f":"C8&G13","v":"Rack Oven Natural GasRack Oven Double Natural Gas"},2000,"double oven"]
[null,"Cooking","Griddle Electric",1394,null,"Conveyor Oven Natural Gas","Conveyor Oven Small Natural Gas",{"$f":"C9&G14","v":"Conveyor Oven Natural GasConveyor Oven Small Natural Gas"},500,"deck"]
[null,"Cooking","Griddle Natural Gas",1395,null,"Conveyor Oven Natural Gas","Conveyor Oven Large Natural Gas",{"$f":"C9&G15","v":"Conveyor Oven Natural GasConveyor Oven Large Natural Gas"},750,"deck"]
[null,"Cooking","Steam Cooker Electric",1402,null,"Fryer Electric","Fryer Electric",{"$f":"C10&Fryer_Electric","v":"Fryer ElectricFryer Electric"},200,"vat"]
[null,"Cooking","Steam Cooker Natural Gas",1403,null,"Fryer Natural Gas","Fryer Natural Gas",{"$f":"C11&Fryer_Natural_Gas","v":"Fryer Natural GasFryer Natural Gas"},749,"vat"]
[null,"Holding","Insulated Holding Cabinets",1396,null,"Large Vat Fryer Electric","Large Vat Fryer Electric",{"$f":"C12&Large_Vat_Fryer_Electric","v":"Large Vat Fryer ElectricLarge Vat Fryer Electric"},200,"vat"]
[null,"Cooling","Glass Door Refrigerators",1406,null,"Large Vat Fryer Natural Gas","Large Vat Fryer Natural Gas",{"$f":"C13&Large_Vat_Fryer_Natural_Gas","v":"Large Vat Fryer Natural GasLarge Vat Fryer Natural Gas"},500,"vat"]
[null,"Cooling","Solid Door Refrigerators",1407,null,"Griddle Electric","Griddle Electric",{"$f":"C14&Griddle_Electric","v":"Griddle ElectricGriddle Electric"},300,"griddle"]
[null,"Cooling","Glass Door Freezers",1408,null,"Griddle Natural Gas","Griddle Natural Gas",{"$f":"C15&Griddle_Natural_Gas","v":"Griddle Natural GasGriddle Natural Gas"},125,"griddle"]
[null,"Cooling","Solid Door Freezers",1409,null,"Steam Cooker Electric","Steam Cooker Electric",{"$f":"C16&Steam_Cooker_Electric","v":"Steam Cooker ElectricSteam Cooker Electric"},1250,"steamer"]
[null,"Cooling","Ice Machines",1397,null,"Steam Cooker Natural Gas","Steam Cooker Natural Gas",{"$f":"C17&Steam_Cooker_Natural_Gas","v":"Steam Cooker Natural GasSteam Cooker Natural Gas"},2000,"steamer"]
[null,"Cleaning","Dishwasher",1391,null,"Insulated Holding Cabinets","Insulated Holding Cabinets - Full Size",{"$f":"Holding&G24","v":"Insulated Holding CabinetsInsulated Holding Cabinets - Full Size"},300,"unit"]
[null,null,null,null,null,"Insulated Holding Cabinets","Insulated Holding Cabinets - 3/4 Size",{"$f":"Holding&G25","v":"Insulated Holding CabinetsInsulated Holding Cabinets - 3/4 Size"},250,"unit"]
[null,null,null,null,null,"Insulated Holding Cabinets","Insulated Holding Cabinets - 1/2 Size",{"$f":"Holding&G26","v":"Insulated Holding CabinetsInsulated Holding Cabinets - 1/2 Size"},200,"unit"]
[null,null,null,null,null,"Glass Door Refrigerators","Energy Star - Internal Volume <15 CF",{"$f":"$C$19&G27","v":"Glass Door RefrigeratorsEnergy Star - Internal Volume <15 CF"},75,"unit"]
[null,null,null,null,null,"Glass Door Refrigerators","Energy Star - Internal Volume 15-29.9 CF",{"$f":"$C$19&G28","v":"Glass Door RefrigeratorsEnergy Star - Internal Volume 15-29.9 CF"},100,"unit"]
[null,null,"Combination Oven Steamer Natural Gas -15 to 28 pans",null,null,"Glass Door Refrigerators","Energy Star - Internal Volume 30-49.9 CF",{"$f":"$C$19&G29","v":"Glass Door RefrigeratorsEnergy Star - Internal Volume 30-49.9 CF"},125,"unit"]
[null,null,null,null,null,"Glass Door Refrigerators","Energy Star - Internal Volume >50 CF",{"$f":"$C$19&G30","v":"Glass Door RefrigeratorsEnergy Star - Internal Volume >50 CF"},150,"unit"]
[null,null,null,null,null,"Solid Door Refrigerators","Energy Star - Internal Volume <15 CF",{"$f":"$C$20&G31","v":"Solid Door RefrigeratorsEnergy Star - Internal Volume <15 CF"},50,"unit"]
[null,null,null,null,null,"Solid Door Refrigerators","Energy Star - Internal Volume 15-29.9 CF",{"$f":"$C$20&G32","v":"Solid Door RefrigeratorsEnergy Star - Internal Volume 15-29.9 CF"},75,"unit"]
[null,null,null,null,null,"Solid Door Refrigerators","Energy Star - Internal Volume 30-49.9 CF",{"$f":"$C$20&G33","v":"Solid Door RefrigeratorsEnergy Star - Internal Volume 30-49.9 CF"},125,"unit"]
[null,null,null,null,null,"Solid Door Refrigerators","Energy Star - Internal Volume >50 CF",{"$f":"$C$20&G34","v":"Solid Door RefrigeratorsEnergy Star - Internal Volume >50 CF"},200,"unit"]
[null,null,null,null,null,"Glass Door Freezers","Energy Star - Internal Volume <15 CF",{"$f":"$C$21&G35","v":"Glass Door FreezersEnergy Star - Internal Volume <15 CF"},200,"unit"]
[null,null,null,null,null,"Glass Door Freezers","Energy Star - Internal Volume 15-29.9 CF",{"$f":"$C$21&G36","v":"Glass Door FreezersEnergy Star - Internal Volume 15-29.9 CF"},250,"unit"]
[null,null,null,null,null,"Glass Door Freezers","Energy Star - Internal Volume 30-49.9 CF",{"$f":"$C$21&G37","v":"Glass Door FreezersEnergy Star - Internal Volume 30-49.9 CF"},500,"unit"]
[null,null,null,null,null,"Glass Door Freezers","Energy Star - Internal Volume >50 CF",{"$f":"$C$21&G38","v":"Glass Door FreezersEnergy Star - Internal Volume >50 CF"},1000,"unit"]
[null,null,null,null,null,"Solid Door Freezers","Energy Star - Internal Volume <15 CF",{"$f":"$C$22&G39","v":"Solid Door FreezersEnergy Star - Internal Volume <15 CF"},100,"unit"]
[null,null,null,null,null,"Solid Door Freezers","Energy Star - Internal Volume 15-29.9 CF",{"$f":"$C$22&G40","v":"Solid Door FreezersEnergy Star - Internal Volume 15-29.9 CF"},150,"unit"]
[null,null,null,null,null,"Solid Door Freezers","Energy Star - Internal Volume 30-49.9 CF",{"$f":"$C$22&G41","v":"Solid Door FreezersEnergy Star - Internal Volume 30-49.9 CF"},300,"unit"]
[null,null,null,null,null,"Solid Door Freezers","Energy Star - Internal Volume >50 CF",{"$f":"$C$22&G42","v":"Solid Door FreezersEnergy Star - Internal Volume >50 CF"},600,"unit"]
[null,null,null,null,null,"Ice Machines","Energy Star Ice Machine 101-200 lbs/day",{"$f":"$C$23&G43","v":"Ice MachinesEnergy Star Ice Machine 101-200 lbs/day"},50,"unit"]
[null,null,null,null,null,"Ice Machines","Energy Star Ice Machine 201-300 lbs/day",{"$f":"$C$23&G44","v":"Ice MachinesEnergy Star Ice Machine 201-300 lbs/day"},50,"unit"]
[null,null,null,null,null,"Ice Machines","Energy Star Ice Machine 301-400 lbs/day","Ice MachinesEnergy Star Ice Machine 301-400 lbs/day",75,"unit"]
[null,null,null,null,null,"Ice Machines","Energy Star Ice Machine 401-500 lbs/day","Ice MachinesEnergy Star Ice Machine 401-500 lbs/day",75,"unit"]
[null,null,null,null,null,"Ice Machines","Energy Star Ice Machine 501-1,000 lbs/day","Ice MachinesEnergy Star Ice Machine 501-1,000 lbs/day",125,"unit"]
[null,null,null,null,null,"Ice Machines","Energy Star Ice Machine 1,001-1,500 lbs/day","Ice MachinesEnergy Star Ice Machine 1,001-1,500 lbs/day",200,"unit"]
[null,null,null,null,null,"Ice Machines","Energy Star Ice Machine >1,500 lbs/day","Ice MachinesEnergy Star Ice Machine >1,500 lbs/day",250,"unit"]
[null,null,null,null,null,"Ice Machines","Super-Efficient Ice Machine 101-200 lbs/day","Ice MachinesSuper-Efficient Ice Machine 101-200 lbs/day",100,"unit"]
[null,null,null,null,null,"Ice Machines","Super-Efficient Ice Machine 201-300 lbs/day","Ice MachinesSuper-Efficient Ice Machine 201-300 lbs/day",100,"unit"]
[null,null,null,null,null,"Ice Machines","Super-Efficient Ice Machine 301-400 lbs/day","Ice MachinesSuper-Efficient Ice Machine 301-400 lbs/day",150,"unit"]
[null,null,null,null,null,"Ice Machines","Super-Efficient Ice Machine 401-500 lbs/day","Ice MachinesSuper-Efficient Ice Machine 401-500 lbs/day",150,"unit"]
[null,null,null,null,null,"Ice Machines","Super-Efficient Ice Machine 501-1,000 lbs/day","Ice MachinesSuper-Efficient Ice Machine 501-1,000 lbs/day",250,"unit"]
[null,null,null,null,null,"Ice Machines","Super-Efficient Ice Machine 1,001-1,500 lbs/day","Ice MachinesSuper-Efficient Ice Machine 1,001-1,500 lbs/day",400,"unit"]
[null,null,null,null,null,"Ice Machines","Super-Efficient Ice Machine >1,500 lbs/day","Ice MachinesSuper-Efficient Ice Machine >1,500 lbs/day",500,"unit"]
[null,null,null,null,null,"Dishwasher","Under Counter",{"$f":"Cleaning&G57","v":"DishwasherUnder Counter"},400,"each"]
[null,null,null,null,null,"Dishwasher","Door Type",{"$f":"Cleaning&G58","v":"DishwasherDoor Type"},700,"each"]
[null,null,null,null,null,"Dishwasher","Single Tank Conveyor",{"$f":"Cleaning&G59","v":"DishwasherSingle Tank Conveyor"},1000,"each"]
[null,null,null,null,null,"Dishwasher","Multiple Tank Conveyor",{"$f":"Cleaning&G60","v":"DishwasherMultiple Tank Conveyor"},1500,"each"]

{"sheet":"Building Type","index":4,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[[1,0,1,2],[1,6,1,8]]}
[]
["Table 2 - Operating Days/Hours by Building Type                                        (pg 118 - 3/14/2014 Protocols)",null,null,null,null,null,"Appendix A - Measure Lives Used in Cost Effectiveness Screening      April 2012"]
["Building Type - For Insulated Holding Cabinents","Days/Year","Hours/Day",null,null,null,"Category","Subcategory","Appliance Lifetime"]
["Education - Primary School",180,8,null,null,null,"Cooking","Combination Oven Steamer Electric",12]
["Education - Secondary School",210,11,null,null,null,"Cooking","Combination Oven Steamer Natural Gas",12]
["Education - Community College",237,16,null,null,null,"Cooking","Convection Oven Electric",12]
["Education - University",192,16,null,null,null,"Cooking","Convection Oven Natural Gas",12]
["Grocery",364,16,null,null,null,"Cooking","Rack Oven Natural Gas",12]
["Medical - Hospital",364,24,null,null,null,"Cooking","Conveyor Oven Natural Gas",12]
["Medical - Clinic",351,12,null,null,null,"Cooking","Fryer Electric",12]
["Lodging Hotel (Guest Rooms)",229,5,null,null,null,"Cooking","Fryer Natural Gas",12]
["Lodging Motel",364,24,null,null,null,"Cooking","Large Vat Fryer Electric",12]
["Manufacturing - Light Industrial",330,13,null,null,null,"Cooking","Large Vat Fryer Natural Gas",12]
["Office - Large",234,12,null,null,null,"Cooking","Griddle Electric",12]
["Office - Small",234,12,null,null,null,"Cooking","Griddle Natural Gas",12]
["Restaurant - Sit Down",364,12,null,null,null,"Cooking","Steam Cooker Electric",12]
["Restaurant - Fast Food",364,17,null,null,null,"Cooking","Steam Cooker Natural Gas",12]
["Retail - 3 Story Large",355,12,null,null,null,"Holding","Insulated Holding Cabinets",12]
["Retail - Single-Story Large",364,12,null,null,null,"Cooling","Glass Door Refrigerators",12]
["Retail - Small",364,11,null,null,null,"Cooling","Solid Door Refrigerators",12]
["Storage Conditioned",330,13,null,null,null,"Cooling","Glass Door Freezers",12]
["Storage Unconditioned",330,13,null,null,null,"Cooling","Solid Door Freezers",12]
["Warehouse",325,12,null,null,null,"Cooling","Ice Machines",10]
["Other",303,14,null,null,null,"Cleaning","Dishwasher",15]

{"sheet":"Export","index":5,"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(Worksheet!$B14<>\"\",VLOOKUP(Worksheet!C14,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E14","v":0},{"$f":"Worksheet!F14","v":0},null,null,null,null,{"$f":"Worksheet!Z14","v":0},{"$f":"IF(ISBLANK(Worksheet!X14)=FALSE,Worksheet!X14,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X14)=FALSE,Worksheet!AF14/Worksheet!$X14,Worksheet!AG14/Worksheet!$Y14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X14)=FALSE,Worksheet!AD14/Worksheet!$X14,Worksheet!AE14/Worksheet!$Y14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X14)=FALSE,Worksheet!AH14/Worksheet!$X14,Worksheet!AI14/Worksheet!$Y14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X14)=FALSE,Worksheet!AJ14/Worksheet!$X14,Worksheet!AK14/Worksheet!$Y14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X14)=FALSE,Worksheet!AL14/Worksheet!$X14,Worksheet!AM14/Worksheet!$Y14),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y14)=FALSE,Worksheet!Y14,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA14,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B15<>\"\",VLOOKUP(Worksheet!C15,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E15","v":0},{"$f":"Worksheet!F15","v":0},null,null,null,null,{"$f":"Worksheet!Z15","v":0},{"$f":"IF(ISBLANK(Worksheet!X15)=FALSE,Worksheet!X15,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X15)=FALSE,Worksheet!AF15/Worksheet!$X15,Worksheet!AG15/Worksheet!$Y15),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X15)=FALSE,Worksheet!AD15/Worksheet!$X15,Worksheet!AE15/Worksheet!$Y15),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X15)=FALSE,Worksheet!AH15/Worksheet!$X15,Worksheet!AI15/Worksheet!$Y15),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X15)=FALSE,Worksheet!AJ15/Worksheet!$X15,Worksheet!AK15/Worksheet!$Y15),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X15)=FALSE,Worksheet!AL15/Worksheet!$X15,Worksheet!AM15/Worksheet!$Y15),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y15)=FALSE,Worksheet!Y15,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA15,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B16<>\"\",VLOOKUP(Worksheet!C16,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E16","v":0},{"$f":"Worksheet!F16","v":0},null,null,null,null,{"$f":"Worksheet!Z16","v":0},{"$f":"IF(ISBLANK(Worksheet!X16)=FALSE,Worksheet!X16,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X16)=FALSE,Worksheet!AF16/Worksheet!$X16,Worksheet!AG16/Worksheet!$Y16),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X16)=FALSE,Worksheet!AD16/Worksheet!$X16,Worksheet!AE16/Worksheet!$Y16),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X16)=FALSE,Worksheet!AH16/Worksheet!$X16,Worksheet!AI16/Worksheet!$Y16),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X16)=FALSE,Worksheet!AJ16/Worksheet!$X16,Worksheet!AK16/Worksheet!$Y16),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X16)=FALSE,Worksheet!AL16/Worksheet!$X16,Worksheet!AM16/Worksheet!$Y16),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y16)=FALSE,Worksheet!Y16,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA16,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B17<>\"\",VLOOKUP(Worksheet!C17,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E17","v":0},{"$f":"Worksheet!F17","v":0},null,null,null,null,{"$f":"Worksheet!Z17","v":0},{"$f":"IF(ISBLANK(Worksheet!X17)=FALSE,Worksheet!X17,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X17)=FALSE,Worksheet!AF17/Worksheet!$X17,Worksheet!AG17/Worksheet!$Y17),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X17)=FALSE,Worksheet!AD17/Worksheet!$X17,Worksheet!AE17/Worksheet!$Y17),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X17)=FALSE,Worksheet!AH17/Worksheet!$X17,Worksheet!AI17/Worksheet!$Y17),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X17)=FALSE,Worksheet!AJ17/Worksheet!$X17,Worksheet!AK17/Worksheet!$Y17),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X17)=FALSE,Worksheet!AL17/Worksheet!$X17,Worksheet!AM17/Worksheet!$Y17),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y17)=FALSE,Worksheet!Y17,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA17,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B18<>\"\",VLOOKUP(Worksheet!C18,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E18","v":0},{"$f":"Worksheet!F18","v":0},null,null,null,null,{"$f":"Worksheet!Z18","v":0},{"$f":"IF(ISBLANK(Worksheet!X18)=FALSE,Worksheet!X18,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X18)=FALSE,Worksheet!AF18/Worksheet!$X18,Worksheet!AG18/Worksheet!$Y18),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X18)=FALSE,Worksheet!AD18/Worksheet!$X18,Worksheet!AE18/Worksheet!$Y18),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X18)=FALSE,Worksheet!AH18/Worksheet!$X18,Worksheet!AI18/Worksheet!$Y18),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X18)=FALSE,Worksheet!AJ18/Worksheet!$X18,Worksheet!AK18/Worksheet!$Y18),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X18)=FALSE,Worksheet!AL18/Worksheet!$X18,Worksheet!AM18/Worksheet!$Y18),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y18)=FALSE,Worksheet!Y18,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA18,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B19<>\"\",VLOOKUP(Worksheet!C19,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E19","v":0},{"$f":"Worksheet!F19","v":0},null,null,null,null,{"$f":"Worksheet!Z19","v":0},{"$f":"IF(ISBLANK(Worksheet!X19)=FALSE,Worksheet!X19,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X19)=FALSE,Worksheet!AF19/Worksheet!$X19,Worksheet!AG19/Worksheet!$Y19),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X19)=FALSE,Worksheet!AD19/Worksheet!$X19,Worksheet!AE19/Worksheet!$Y19),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X19)=FALSE,Worksheet!AH19/Worksheet!$X19,Worksheet!AI19/Worksheet!$Y19),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X19)=FALSE,Worksheet!AJ19/Worksheet!$X19,Worksheet!AK19/Worksheet!$Y19),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X19)=FALSE,Worksheet!AL19/Worksheet!$X19,Worksheet!AM19/Worksheet!$Y19),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y19)=FALSE,Worksheet!Y19,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA19,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B20<>\"\",VLOOKUP(Worksheet!C20,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E20","v":0},{"$f":"Worksheet!F20","v":0},null,null,null,null,{"$f":"Worksheet!Z20","v":0},{"$f":"IF(ISBLANK(Worksheet!X20)=FALSE,Worksheet!X20,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X20)=FALSE,Worksheet!AF20/Worksheet!$X20,Worksheet!AG20/Worksheet!$Y20),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X20)=FALSE,Worksheet!AD20/Worksheet!$X20,Worksheet!AE20/Worksheet!$Y20),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X20)=FALSE,Worksheet!AH20/Worksheet!$X20,Worksheet!AI20/Worksheet!$Y20),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X20)=FALSE,Worksheet!AJ20/Worksheet!$X20,Worksheet!AK20/Worksheet!$Y20),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X20)=FALSE,Worksheet!AL20/Worksheet!$X20,Worksheet!AM20/Worksheet!$Y20),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y20)=FALSE,Worksheet!Y20,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA20,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B21<>\"\",VLOOKUP(Worksheet!C21,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E21","v":0},{"$f":"Worksheet!F21","v":0},null,null,null,null,{"$f":"Worksheet!Z21","v":0},{"$f":"IF(ISBLANK(Worksheet!X21)=FALSE,Worksheet!X21,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X21)=FALSE,Worksheet!AF21/Worksheet!$X21,Worksheet!AG21/Worksheet!$Y21),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X21)=FALSE,Worksheet!AD21/Worksheet!$X21,Worksheet!AE21/Worksheet!$Y21),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X21)=FALSE,Worksheet!AH21/Worksheet!$X21,Worksheet!AI21/Worksheet!$Y21),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X21)=FALSE,Worksheet!AJ21/Worksheet!$X21,Worksheet!AK21/Worksheet!$Y21),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X21)=FALSE,Worksheet!AL21/Worksheet!$X21,Worksheet!AM21/Worksheet!$Y21),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y21)=FALSE,Worksheet!Y21,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA21,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B22<>\"\",VLOOKUP(Worksheet!C22,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E22","v":0},{"$f":"Worksheet!F22","v":0},null,null,null,null,{"$f":"Worksheet!Z22","v":0},{"$f":"IF(ISBLANK(Worksheet!X22)=FALSE,Worksheet!X22,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X22)=FALSE,Worksheet!AF22/Worksheet!$X22,Worksheet!AG22/Worksheet!$Y22),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X22)=FALSE,Worksheet!AD22/Worksheet!$X22,Worksheet!AE22/Worksheet!$Y22),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X22)=FALSE,Worksheet!AH22/Worksheet!$X22,Worksheet!AI22/Worksheet!$Y22),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X22)=FALSE,Worksheet!AJ22/Worksheet!$X22,Worksheet!AK22/Worksheet!$Y22),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X22)=FALSE,Worksheet!AL22/Worksheet!$X22,Worksheet!AM22/Worksheet!$Y22),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y22)=FALSE,Worksheet!Y22,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA22,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B23<>\"\",VLOOKUP(Worksheet!C23,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E23","v":0},{"$f":"Worksheet!F23","v":0},null,null,null,null,{"$f":"Worksheet!Z23","v":0},{"$f":"IF(ISBLANK(Worksheet!X23)=FALSE,Worksheet!X23,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X23)=FALSE,Worksheet!AF23/Worksheet!$X23,Worksheet!AG23/Worksheet!$Y23),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X23)=FALSE,Worksheet!AD23/Worksheet!$X23,Worksheet!AE23/Worksheet!$Y23),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X23)=FALSE,Worksheet!AH23/Worksheet!$X23,Worksheet!AI23/Worksheet!$Y23),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X23)=FALSE,Worksheet!AJ23/Worksheet!$X23,Worksheet!AK23/Worksheet!$Y23),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X23)=FALSE,Worksheet!AL23/Worksheet!$X23,Worksheet!AM23/Worksheet!$Y23),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y23)=FALSE,Worksheet!Y23,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA23,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B24<>\"\",VLOOKUP(Worksheet!C24,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E24","v":0},{"$f":"Worksheet!F24","v":0},null,null,null,null,{"$f":"Worksheet!Z24","v":0},{"$f":"IF(ISBLANK(Worksheet!X24)=FALSE,Worksheet!X24,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X24)=FALSE,Worksheet!AF24/Worksheet!$X24,Worksheet!AG24/Worksheet!$Y24),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X24)=FALSE,Worksheet!AD24/Worksheet!$X24,Worksheet!AE24/Worksheet!$Y24),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X24)=FALSE,Worksheet!AH24/Worksheet!$X24,Worksheet!AI24/Worksheet!$Y24),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X24)=FALSE,Worksheet!AJ24/Worksheet!$X24,Worksheet!AK24/Worksheet!$Y24),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X24)=FALSE,Worksheet!AL24/Worksheet!$X24,Worksheet!AM24/Worksheet!$Y24),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y24)=FALSE,Worksheet!Y24,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA24,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B25<>\"\",VLOOKUP(Worksheet!C25,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E25","v":0},{"$f":"Worksheet!F25","v":0},null,null,null,null,{"$f":"Worksheet!Z25","v":0},{"$f":"IF(ISBLANK(Worksheet!X25)=FALSE,Worksheet!X25,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X25)=FALSE,Worksheet!AF25/Worksheet!$X25,Worksheet!AG25/Worksheet!$Y25),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X25)=FALSE,Worksheet!AD25/Worksheet!$X25,Worksheet!AE25/Worksheet!$Y25),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X25)=FALSE,Worksheet!AH25/Worksheet!$X25,Worksheet!AI25/Worksheet!$Y25),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X25)=FALSE,Worksheet!AJ25/Worksheet!$X25,Worksheet!AK25/Worksheet!$Y25),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X25)=FALSE,Worksheet!AL25/Worksheet!$X25,Worksheet!AM25/Worksheet!$Y25),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y25)=FALSE,Worksheet!Y25,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA25,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B26<>\"\",VLOOKUP(Worksheet!C26,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E26","v":0},{"$f":"Worksheet!F26","v":0},null,null,null,null,{"$f":"Worksheet!Z26","v":0},{"$f":"IF(ISBLANK(Worksheet!X26)=FALSE,Worksheet!X26,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X26)=FALSE,Worksheet!AF26/Worksheet!$X26,Worksheet!AG26/Worksheet!$Y26),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X26)=FALSE,Worksheet!AD26/Worksheet!$X26,Worksheet!AE26/Worksheet!$Y26),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X26)=FALSE,Worksheet!AH26/Worksheet!$X26,Worksheet!AI26/Worksheet!$Y26),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X26)=FALSE,Worksheet!AJ26/Worksheet!$X26,Worksheet!AK26/Worksheet!$Y26),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X26)=FALSE,Worksheet!AL26/Worksheet!$X26,Worksheet!AM26/Worksheet!$Y26),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y26)=FALSE,Worksheet!Y26,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA26,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B27<>\"\",VLOOKUP(Worksheet!C27,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E27","v":0},{"$f":"Worksheet!F27","v":0},null,null,null,null,{"$f":"Worksheet!Z27","v":0},{"$f":"IF(ISBLANK(Worksheet!X27)=FALSE,Worksheet!X27,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X27)=FALSE,Worksheet!AF27/Worksheet!$X27,Worksheet!AG27/Worksheet!$Y27),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X27)=FALSE,Worksheet!AD27/Worksheet!$X27,Worksheet!AE27/Worksheet!$Y27),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X27)=FALSE,Worksheet!AH27/Worksheet!$X27,Worksheet!AI27/Worksheet!$Y27),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X27)=FALSE,Worksheet!AJ27/Worksheet!$X27,Worksheet!AK27/Worksheet!$Y27),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X27)=FALSE,Worksheet!AL27/Worksheet!$X27,Worksheet!AM27/Worksheet!$Y27),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y27)=FALSE,Worksheet!Y27,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA27,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B28<>\"\",VLOOKUP(Worksheet!C28,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E28","v":0},{"$f":"Worksheet!F28","v":0},null,null,null,null,{"$f":"Worksheet!Z28","v":0},{"$f":"IF(ISBLANK(Worksheet!X28)=FALSE,Worksheet!X28,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X28)=FALSE,Worksheet!AF28/Worksheet!$X28,Worksheet!AG28/Worksheet!$Y28),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X28)=FALSE,Worksheet!AD28/Worksheet!$X28,Worksheet!AE28/Worksheet!$Y28),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X28)=FALSE,Worksheet!AH28/Worksheet!$X28,Worksheet!AI28/Worksheet!$Y28),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X28)=FALSE,Worksheet!AJ28/Worksheet!$X28,Worksheet!AK28/Worksheet!$Y28),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X28)=FALSE,Worksheet!AL28/Worksheet!$X28,Worksheet!AM28/Worksheet!$Y28),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y28)=FALSE,Worksheet!Y28,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA28,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B29<>\"\",VLOOKUP(Worksheet!C29,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E29","v":0},{"$f":"Worksheet!F29","v":0},null,null,null,null,{"$f":"Worksheet!Z29","v":0},{"$f":"IF(ISBLANK(Worksheet!X29)=FALSE,Worksheet!X29,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X29)=FALSE,Worksheet!AF29/Worksheet!$X29,Worksheet!AG29/Worksheet!$Y29),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X29)=FALSE,Worksheet!AD29/Worksheet!$X29,Worksheet!AE29/Worksheet!$Y29),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X29)=FALSE,Worksheet!AH29/Worksheet!$X29,Worksheet!AI29/Worksheet!$Y29),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X29)=FALSE,Worksheet!AJ29/Worksheet!$X29,Worksheet!AK29/Worksheet!$Y29),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X29)=FALSE,Worksheet!AL29/Worksheet!$X29,Worksheet!AM29/Worksheet!$Y29),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y29)=FALSE,Worksheet!Y29,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA29,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B30<>\"\",VLOOKUP(Worksheet!C30,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E30","v":0},{"$f":"Worksheet!F30","v":0},null,null,null,null,{"$f":"Worksheet!Z30","v":0},{"$f":"IF(ISBLANK(Worksheet!X30)=FALSE,Worksheet!X30,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X30)=FALSE,Worksheet!AF30/Worksheet!$X30,Worksheet!AG30/Worksheet!$Y30),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X30)=FALSE,Worksheet!AD30/Worksheet!$X30,Worksheet!AE30/Worksheet!$Y30),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X30)=FALSE,Worksheet!AH30/Worksheet!$X30,Worksheet!AI30/Worksheet!$Y30),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X30)=FALSE,Worksheet!AJ30/Worksheet!$X30,Worksheet!AK30/Worksheet!$Y30),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X30)=FALSE,Worksheet!AL30/Worksheet!$X30,Worksheet!AM30/Worksheet!$Y30),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y30)=FALSE,Worksheet!Y30,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA30,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B31<>\"\",VLOOKUP(Worksheet!C31,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E31","v":0},{"$f":"Worksheet!F31","v":0},null,null,null,null,{"$f":"Worksheet!Z31","v":0},{"$f":"IF(ISBLANK(Worksheet!X31)=FALSE,Worksheet!X31,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X31)=FALSE,Worksheet!AF31/Worksheet!$X31,Worksheet!AG31/Worksheet!$Y31),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X31)=FALSE,Worksheet!AD31/Worksheet!$X31,Worksheet!AE31/Worksheet!$Y31),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X31)=FALSE,Worksheet!AH31/Worksheet!$X31,Worksheet!AI31/Worksheet!$Y31),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X31)=FALSE,Worksheet!AJ31/Worksheet!$X31,Worksheet!AK31/Worksheet!$Y31),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X31)=FALSE,Worksheet!AL31/Worksheet!$X31,Worksheet!AM31/Worksheet!$Y31),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y31)=FALSE,Worksheet!Y31,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA31,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B32<>\"\",VLOOKUP(Worksheet!C32,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E32","v":0},{"$f":"Worksheet!F32","v":0},null,null,null,null,{"$f":"Worksheet!Z32","v":0},{"$f":"IF(ISBLANK(Worksheet!X32)=FALSE,Worksheet!X32,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X32)=FALSE,Worksheet!AF32/Worksheet!$X32,Worksheet!AG32/Worksheet!$Y32),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X32)=FALSE,Worksheet!AD32/Worksheet!$X32,Worksheet!AE32/Worksheet!$Y32),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X32)=FALSE,Worksheet!AH32/Worksheet!$X32,Worksheet!AI32/Worksheet!$Y32),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X32)=FALSE,Worksheet!AJ32/Worksheet!$X32,Worksheet!AK32/Worksheet!$Y32),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X32)=FALSE,Worksheet!AL32/Worksheet!$X32,Worksheet!AM32/Worksheet!$Y32),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y32)=FALSE,Worksheet!Y32,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA32,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B33<>\"\",VLOOKUP(Worksheet!C33,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E33","v":0},{"$f":"Worksheet!F33","v":0},null,null,null,null,{"$f":"Worksheet!Z33","v":0},{"$f":"IF(ISBLANK(Worksheet!X33)=FALSE,Worksheet!X33,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X33)=FALSE,Worksheet!AF33/Worksheet!$X33,Worksheet!AG33/Worksheet!$Y33),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X33)=FALSE,Worksheet!AD33/Worksheet!$X33,Worksheet!AE33/Worksheet!$Y33),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X33)=FALSE,Worksheet!AH33/Worksheet!$X33,Worksheet!AI33/Worksheet!$Y33),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X33)=FALSE,Worksheet!AJ33/Worksheet!$X33,Worksheet!AK33/Worksheet!$Y33),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X33)=FALSE,Worksheet!AL33/Worksheet!$X33,Worksheet!AM33/Worksheet!$Y33),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y33)=FALSE,Worksheet!Y33,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA33,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B34<>\"\",VLOOKUP(Worksheet!C34,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E34","v":0},{"$f":"Worksheet!F34","v":0},null,null,null,null,{"$f":"Worksheet!Z34","v":0},{"$f":"IF(ISBLANK(Worksheet!X34)=FALSE,Worksheet!X34,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X34)=FALSE,Worksheet!AF34/Worksheet!$X34,Worksheet!AG34/Worksheet!$Y34),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X34)=FALSE,Worksheet!AD34/Worksheet!$X34,Worksheet!AE34/Worksheet!$Y34),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X34)=FALSE,Worksheet!AH34/Worksheet!$X34,Worksheet!AI34/Worksheet!$Y34),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X34)=FALSE,Worksheet!AJ34/Worksheet!$X34,Worksheet!AK34/Worksheet!$Y34),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X34)=FALSE,Worksheet!AL34/Worksheet!$X34,Worksheet!AM34/Worksheet!$Y34),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y34)=FALSE,Worksheet!Y34,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA34,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B35<>\"\",VLOOKUP(Worksheet!C35,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E35","v":0},{"$f":"Worksheet!F35","v":0},null,null,null,null,{"$f":"Worksheet!Z35","v":0},{"$f":"IF(ISBLANK(Worksheet!X35)=FALSE,Worksheet!X35,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X35)=FALSE,Worksheet!AF35/Worksheet!$X35,Worksheet!AG35/Worksheet!$Y35),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X35)=FALSE,Worksheet!AD35/Worksheet!$X35,Worksheet!AE35/Worksheet!$Y35),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X35)=FALSE,Worksheet!AH35/Worksheet!$X35,Worksheet!AI35/Worksheet!$Y35),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X35)=FALSE,Worksheet!AJ35/Worksheet!$X35,Worksheet!AK35/Worksheet!$Y35),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X35)=FALSE,Worksheet!AL35/Worksheet!$X35,Worksheet!AM35/Worksheet!$Y35),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y35)=FALSE,Worksheet!Y35,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA35,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B36<>\"\",VLOOKUP(Worksheet!C36,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E36","v":0},{"$f":"Worksheet!F36","v":0},null,null,null,null,{"$f":"Worksheet!Z36","v":0},{"$f":"IF(ISBLANK(Worksheet!X36)=FALSE,Worksheet!X36,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X36)=FALSE,Worksheet!AF36/Worksheet!$X36,Worksheet!AG36/Worksheet!$Y36),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X36)=FALSE,Worksheet!AD36/Worksheet!$X36,Worksheet!AE36/Worksheet!$Y36),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X36)=FALSE,Worksheet!AH36/Worksheet!$X36,Worksheet!AI36/Worksheet!$Y36),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X36)=FALSE,Worksheet!AJ36/Worksheet!$X36,Worksheet!AK36/Worksheet!$Y36),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X36)=FALSE,Worksheet!AL36/Worksheet!$X36,Worksheet!AM36/Worksheet!$Y36),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y36)=FALSE,Worksheet!Y36,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA36,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B37<>\"\",VLOOKUP(Worksheet!C37,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E37","v":0},{"$f":"Worksheet!F37","v":0},null,null,null,null,{"$f":"Worksheet!Z37","v":0},{"$f":"IF(ISBLANK(Worksheet!X37)=FALSE,Worksheet!X37,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X37)=FALSE,Worksheet!AF37/Worksheet!$X37,Worksheet!AG37/Worksheet!$Y37),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X37)=FALSE,Worksheet!AD37/Worksheet!$X37,Worksheet!AE37/Worksheet!$Y37),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X37)=FALSE,Worksheet!AH37/Worksheet!$X37,Worksheet!AI37/Worksheet!$Y37),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X37)=FALSE,Worksheet!AJ37/Worksheet!$X37,Worksheet!AK37/Worksheet!$Y37),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X37)=FALSE,Worksheet!AL37/Worksheet!$X37,Worksheet!AM37/Worksheet!$Y37),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y37)=FALSE,Worksheet!Y37,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA37,\"\")","v":0}]
[{"$f":"IF(Worksheet!$B38<>\"\",VLOOKUP(Worksheet!C38,'Incentive Structure'!$C$4:$D$24,2,FALSE),\"\")","v":""},{"$f":"Worksheet!E38","v":0},{"$f":"Worksheet!F38","v":0},null,null,null,null,{"$f":"Worksheet!Z38","v":0},{"$f":"IF(ISBLANK(Worksheet!X38)=FALSE,Worksheet!X38,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X38)=FALSE,Worksheet!AF38/Worksheet!$X38,Worksheet!AG38/Worksheet!$Y38),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X38)=FALSE,Worksheet!AD38/Worksheet!$X38,Worksheet!AE38/Worksheet!$Y38),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X38)=FALSE,Worksheet!AH38/Worksheet!$X38,Worksheet!AI38/Worksheet!$Y38),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X38)=FALSE,Worksheet!AJ38/Worksheet!$X38,Worksheet!AK38/Worksheet!$Y38),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$X38)=FALSE,Worksheet!AL38/Worksheet!$X38,Worksheet!AM38/Worksheet!$Y38),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Worksheet!Y38)=FALSE,Worksheet!Y38,\"\")","v":""},{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AA38,\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(Worksheet!$Y39)=FALSE,Worksheet!AM39/Worksheet!$Y39,Worksheet!AN39/Worksheet!$Z39),\"\")","v":""},null,null,null,null,{"$f":"IF(Worksheet!$A$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$10=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!AB39,\"\")","v":0}]

{"sheet":"Version","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[14,"<- Version"]
[]
["Log"]
["2013-04-23","Updated with more granular measure breakdown per AEG's measures"]
["2013-07-09","no change for V7, skipped V6"]
["2013-07-16","fixed incentive lookup table to distinguish between different types of cooling applications"]
["2013-09-19","fixed incentive lookup table which had lots of mistakes in the cooking section"]
["2018-06-26","Updated to align with FY19 Protocols"]
["2019-07-01","Added Enhanced Incentive Eligibility Section and Updated for FY20 Program"]
["2020-10-01","Updated for FY21 Program"]