{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Worksheet","Measure Code","Tables","Export","Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Worksheet","index":0,"n_rows":43,"n_cols":37,"rows_kept":43,"cut":false,"hidden":false,"merged":[[14,2,17,2],[13,6,13,8],[8,2,8,4],[7,2,7,4],[5,2,5,4],[8,6,8,8],[4,2,4,4],[14,35,16,35],[12,27,13,27],[14,29,16,29],[14,30,16,30],[14,33,16,33],[14,34,16,34],[14,32,16,32],[0,0,0,3],[3,11,3,12],[2,11,2,12],[14,17,14,21],[5,15,5,17],[5,18,5,20],[6,15,10,17],[6,18,10,20],[14,0,17,0],[13,2,13,3],[14,14,14,16],[3,2,3,4],[3,15,3,16]]}
["FY22 SmartStart New Construction - Electric Chillers v1.0",null,null,null,"Incentive amounts are estimates until verified by the Program Manager."]
[]
["Customer Information",null,null,null,null,null,null,null,null,null,null,"Total Units Committed:",null,{"$f":"SUM($M19:$M43)","v":0}]
["Name",null,null,null,null,"Address",null,null,null,null,null,"Total Units Installed:",null,{"$f":"SUM($N19:$N43)","v":0},null,"Inspection Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EFLH is set in the protocol",null,null,null,"Lifetime"]
["Application",null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$14=\"\",\"\",VLOOKUP($G$14,Building_Lookup,2,FALSE))","v":""},null,"hrs/year",null,20,"years"]
["Contact",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,null,"Address"]
["Contact",null,null,null,null,"Phone"]
["Enhanced Incentive Eligibility"]
[false,null,false,false]
[false,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Incentive",null,null,null,null,null,null,null,null,null,"Committed","Installed",null,null,"Total Savings"]
["Project Type",null,"New Construction",null,null,"Building Type",null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,{"$f":"SUM(X19:X43)","v":0},{"$f":"SUM(Y19:Y43)","v":0},null,null,null,null,null,{"$f":"SUM(AD19:AD43)","v":0},{"$f":"SUM(AE19:AE43)","v":0},null,{"$f":"SUM(AG19:AG43)","v":0},{"$f":"SUM(AH19:AH43)","v":0},{"$f":"SUM(AI19:AI43)","v":0},{"$f":"SUM(AJ19:AJ43)","v":0}]
["Measure Code","Reason","Type & Capacity Range","Application","Speed","Manufacturer","Model Number","Unit Size","Location in Building","Full Load","Part Load","Eff","# of Units","# of Units","Reference",null,null,"Incentive Calculations",null,null,null,null,null,"Total","Total",null,"Baseline","Peak Duty","Demand","Committed Peak Reduction","Installed Peak Reduction","Energy","Committed Annual Savings","Installed Annual Savings","Committed Lifetime Savings","Installed Lifetime Savings"]
[null,"New",null,"Comfort Cooling","Constant",null,null,"(Tons)",null,"Efficiency","Efficiency","Units","Committed","Installed","Min","Min",null,"Base","Base","Performance","Performanace","Enhanced","Total","Committed","Installed",null,"Equipment","Cycle","Savings",null,null,"Savings"]
[null,"Replaced",null,null,"Variable",null,null,null,null,"Rating","Rating",null,null,null,"Qualifying","Incentive","Qualified?","Incentive","Incentive","Incentive","Incentive","Incentive","Incentive","Incentives","Incentive",null,"Efficiency","Fraction","per Unit",null,null,"per Unit"]
[null," ",null,null," ",null,null,null,null,"FLV","IPLV",null,null,null,"Efficiency","Efficiency",null,"Per Ton","Per Unit","Per Ton","Per Unit","Per Unit","Per Unit","$","$",null,"kW/ton",null,"kW","kW","kW","kWh","kWh","kWh","kWh","kWh"]
[null,"New",{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A19=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A19=\"\")=TRUE,\"\",VLOOKUP(A19,MeasureCode_Lookup,IF(E19=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A19=\"\")=TRUE,\"\",VLOOKUP(A19,MeasureCode_Lookup,IF(E19=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A19=\"\",J19=\"\",K19=\"\",H19=\"\")=TRUE,\"\",IF(OR(AND(L19=\"EER\",OR(J19<VLOOKUP(A19,MeasureCode_Lookup,7,FALSE),K19<VLOOKUP(A19,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L19=\"kW/Ton\",OR(J19>VLOOKUP(A19,MeasureCode_Lookup,7,FALSE),K19>VLOOKUP(A19,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H19<VLOOKUP(A19,MeasureCode_Lookup,5,FALSE),H19>VLOOKUP(A19,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q19=\"Yes\",VLOOKUP(A19,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R19*H19","v":0},{"$f":"IF(Q19=\"Yes\",VLOOKUP(A19,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L19=\"EER\",ROUNDDOWN((IF(E19=\"Constant\",J19+0.0001,K19+0.0001)-VLOOKUP(A19,MeasureCode_Lookup,IF(E19=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A19,MeasureCode_Lookup,IF(E19=\"Constant\",7,8),FALSE)-IF(E19=\"Constant\",J19-0.0001,K19-0.0001))/0.01,0)),0)","v":0},{"$f":"T19*H19","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,S19+U19,0)","v":0},{"$f":"IF(Q19=\"Yes\",S19+U19+V19,0)","v":0},{"$f":"M19*W19","v":0},{"$f":"N19*W19","v":0},null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A19=\"\",\"\",0.67)","v":""},{"$f":"IF(Q19=\"Yes\",IF(L19=\"EER\",H19*AB19*(AA19-12/IF(E19=\"Constant\",J19,K19)),H19*AB19*(AA19-IF(E19=\"Constant\",J19,K19))),0)","v":0},{"$f":"M19*AC19","v":0},{"$f":"N19*AC19","v":0},{"$f":"IF(Q19=\"Yes\",IF(L19=\"EER\",H19*$AE$5*(AA19-12/IF(E19=\"Constant\",J19,K19)),H19*$AE$5*(AA19-IF(E19=\"Constant\",J19,K19))),0)","v":0},{"$f":"M19*AF19","v":0},{"$f":"N19*AF19","v":0},{"$f":"AG19*$AI$5","v":0},{"$f":"AH19*$AI$5","v":0}]
[null,"New",{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A20=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A20=\"\")=TRUE,\"\",VLOOKUP(A20,MeasureCode_Lookup,IF(E20=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A20=\"\")=TRUE,\"\",VLOOKUP(A20,MeasureCode_Lookup,IF(E20=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A20=\"\",J20=\"\",K20=\"\",H20=\"\")=TRUE,\"\",IF(OR(AND(L20=\"EER\",OR(J20<VLOOKUP(A20,MeasureCode_Lookup,7,FALSE),K20<VLOOKUP(A20,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L20=\"kW/Ton\",OR(J20>VLOOKUP(A20,MeasureCode_Lookup,7,FALSE),K20>VLOOKUP(A20,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H20<VLOOKUP(A20,MeasureCode_Lookup,5,FALSE),H20>VLOOKUP(A20,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q20=\"Yes\",VLOOKUP(A20,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R20*H20","v":0},{"$f":"IF(Q20=\"Yes\",VLOOKUP(A20,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L20=\"EER\",ROUNDDOWN((IF(E20=\"Constant\",J20+0.0001,K20+0.0001)-VLOOKUP(A20,MeasureCode_Lookup,IF(E20=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A20,MeasureCode_Lookup,IF(E20=\"Constant\",7,8),FALSE)-IF(E20=\"Constant\",J20-0.0001,K20-0.0001))/0.01,0)),0)","v":0},{"$f":"T20*H20","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$C$11=TRUE,$C$12=TRUE,$D$11=TRUE,$D$12=TRUE)=TRUE,S20+U20,0)","v":0},{"$f":"IF(Q20=\"Yes\",S20+U20+V20,0)","v":0},{"$f":"M20*W20","v":0},{"$f":"N20*W20","v":0},null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A20=\"\",\"\",0.67)","v":""},{"$f":"IF(Q20=\"Yes\",IF(L20=\"EER\",H20*AB20*(AA20-12/IF(E20=\"Constant\",J20,K20)),H20*AB20*(AA20-IF(E20=\"Constant\",J20,K20))),0)","v":0},{"$f":"M20*AC20","v":0},{"$f":"N20*AC20","v":0},{"$f":"IF(Q20=\"Yes\",IF(L20=\"EER\",H20*$AE$5*(AA20-12/IF(E20=\"Constant\",J20,K20)),H20*$AE$5*(AA20-IF(E20=\"Constant\",J20,K20))),0)","v":0},{"$f":"M20*AF20","v":0},{"$f":"N20*AF20","v":0},{"$f":"AG20*$AI$5","v":0},{"$f":"AH20*$AI$5","v":0}]
[null,"New",{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A21=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A21=\"\")=TRUE,\"\",VLOOKUP(A21,MeasureCode_Lookup,IF(E21=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A21=\"\")=TRUE,\"\",VLOOKUP(A21,MeasureCode_Lookup,IF(E21=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A21=\"\",J21=\"\",K21=\"\",H21=\"\")=TRUE,\"\",IF(OR(AND(L21=\"EER\",OR(J21<VLOOKUP(A21,MeasureCode_Lookup,7,FALSE),K21<VLOOKUP(A21,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L21=\"kW/Ton\",OR(J21>VLOOKUP(A21,MeasureCode_Lookup,7,FALSE),K21>VLOOKUP(A21,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H21<VLOOKUP(A21,MeasureCode_Lookup,5,FALSE),H21>VLOOKUP(A21,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q21=\"Yes\",VLOOKUP(A21,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R21*H21","v":0},{"$f":"IF(Q21=\"Yes\",VLOOKUP(A21,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L21=\"EER\",ROUNDDOWN((IF(E21=\"Constant\",J21+0.0001,K21+0.0001)-VLOOKUP(A21,MeasureCode_Lookup,IF(E21=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A21,MeasureCode_Lookup,IF(E21=\"Constant\",7,8),FALSE)-IF(E21=\"Constant\",J21-0.0001,K21-0.0001))/0.01,0)),0)","v":0},{"$f":"T21*H21","v":0},0,0,{"$f":"M21*W21","v":0},{"$f":"N21*W21","v":0},null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A21=\"\",\"\",0.67)","v":""},{"$f":"IF(Q21=\"Yes\",IF(L21=\"EER\",H21*AB21*(AA21-12/IF(E21=\"Constant\",J21,K21)),H21*AB21*(AA21-IF(E21=\"Constant\",J21,K21))),0)","v":0},{"$f":"M21*AC21","v":0},{"$f":"N21*AC21","v":0},{"$f":"IF(Q21=\"Yes\",IF(L21=\"EER\",H21*$AE$5*(AA21-12/IF(E21=\"Constant\",J21,K21)),H21*$AE$5*(AA21-IF(E21=\"Constant\",J21,K21))),0)","v":0},{"$f":"M21*AF21","v":0},{"$f":"N21*AF21","v":0},0,0]
[null,"New",{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A22=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A22=\"\")=TRUE,\"\",VLOOKUP(A22,MeasureCode_Lookup,IF(E22=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A22=\"\")=TRUE,\"\",VLOOKUP(A22,MeasureCode_Lookup,IF(E22=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A22=\"\",J22=\"\",K22=\"\",H22=\"\")=TRUE,\"\",IF(OR(AND(L22=\"EER\",OR(J22<VLOOKUP(A22,MeasureCode_Lookup,7,FALSE),K22<VLOOKUP(A22,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L22=\"kW/Ton\",OR(J22>VLOOKUP(A22,MeasureCode_Lookup,7,FALSE),K22>VLOOKUP(A22,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H22<VLOOKUP(A22,MeasureCode_Lookup,5,FALSE),H22>VLOOKUP(A22,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q22=\"Yes\",VLOOKUP(A22,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R22*H22","v":0},{"$f":"IF(Q22=\"Yes\",VLOOKUP(A22,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L22=\"EER\",ROUNDDOWN((IF(E22=\"Constant\",J22+0.0001,K22+0.0001)-VLOOKUP(A22,MeasureCode_Lookup,IF(E22=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A22,MeasureCode_Lookup,IF(E22=\"Constant\",7,8),FALSE)-IF(E22=\"Constant\",J22-0.0001,K22-0.0001))/0.01,0)),0)","v":0},{"$f":"T22*H22","v":0},0,0,{"$f":"M22*W22","v":0},{"$f":"N22*W22","v":0},null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A22=\"\",\"\",0.67)","v":""},{"$f":"IF(Q22=\"Yes\",IF(L22=\"EER\",H22*AB22*(AA22-12/IF(E22=\"Constant\",J22,K22)),H22*AB22*(AA22-IF(E22=\"Constant\",J22,K22))),0)","v":0},{"$f":"M22*AC22","v":0},{"$f":"N22*AC22","v":0},{"$f":"IF(Q22=\"Yes\",IF(L22=\"EER\",H22*$AE$5*(AA22-12/IF(E22=\"Constant\",J22,K22)),H22*$AE$5*(AA22-IF(E22=\"Constant\",J22,K22))),0)","v":0},{"$f":"M22*AF22","v":0},{"$f":"N22*AF22","v":0},0,0]
[null,"New",{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A23=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A23=\"\")=TRUE,\"\",VLOOKUP(A23,MeasureCode_Lookup,IF(E23=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A23=\"\")=TRUE,\"\",VLOOKUP(A23,MeasureCode_Lookup,IF(E23=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A23=\"\",J23=\"\",K23=\"\",H23=\"\")=TRUE,\"\",IF(OR(AND(L23=\"EER\",OR(J23<VLOOKUP(A23,MeasureCode_Lookup,7,FALSE),K23<VLOOKUP(A23,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L23=\"kW/Ton\",OR(J23>VLOOKUP(A23,MeasureCode_Lookup,7,FALSE),K23>VLOOKUP(A23,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H23<VLOOKUP(A23,MeasureCode_Lookup,5,FALSE),H23>VLOOKUP(A23,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q23=\"Yes\",VLOOKUP(A23,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R23*H23","v":0},{"$f":"IF(Q23=\"Yes\",VLOOKUP(A23,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L23=\"EER\",ROUNDDOWN((IF(E23=\"Constant\",J23+0.0001,K23+0.0001)-VLOOKUP(A23,MeasureCode_Lookup,IF(E23=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A23,MeasureCode_Lookup,IF(E23=\"Constant\",7,8),FALSE)-IF(E23=\"Constant\",J23-0.0001,K23-0.0001))/0.01,0)),0)","v":0},{"$f":"T23*H23","v":0},0,0,{"$f":"M23*W23","v":0},{"$f":"N23*W23","v":0},null,{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A23=\"\",\"\",0.67)","v":""},{"$f":"IF(Q23=\"Yes\",IF(L23=\"EER\",H23*AB23*(AA23-12/IF(E23=\"Constant\",J23,K23)),H23*AB23*(AA23-IF(E23=\"Constant\",J23,K23))),0)","v":0},{"$f":"M23*AC23","v":0},{"$f":"N23*AC23","v":0},{"$f":"IF(Q23=\"Yes\",IF(L23=\"EER\",H23*$AE$5*(AA23-12/IF(E23=\"Constant\",J23,K23)),H23*$AE$5*(AA23-IF(E23=\"Constant\",J23,K23))),0)","v":0},{"$f":"M23*AF23","v":0},{"$f":"N23*AF23","v":0},0,0]
[null,"New",{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A24=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A24=\"\")=TRUE,\"\",VLOOKUP(A24,MeasureCode_Lookup,IF(E24=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A24=\"\")=TRUE,\"\",VLOOKUP(A24,MeasureCode_Lookup,IF(E24=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A24=\"\",J24=\"\",K24=\"\",H24=\"\")=TRUE,\"\",IF(OR(AND(L24=\"EER\",OR(J24<VLOOKUP(A24,MeasureCode_Lookup,7,FALSE),K24<VLOOKUP(A24,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L24=\"kW/Ton\",OR(J24>VLOOKUP(A24,MeasureCode_Lookup,7,FALSE),K24>VLOOKUP(A24,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H24<VLOOKUP(A24,MeasureCode_Lookup,5,FALSE),H24>VLOOKUP(A24,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q24=\"Yes\",VLOOKUP(A24,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R24*H24","v":0},{"$f":"IF(Q24=\"Yes\",VLOOKUP(A24,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L24=\"EER\",ROUNDDOWN((IF(E24=\"Constant\",J24+0.0001,K24+0.0001)-VLOOKUP(A24,MeasureCode_Lookup,IF(E24=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A24,MeasureCode_Lookup,IF(E24=\"Constant\",7,8),FALSE)-IF(E24=\"Constant\",J24-0.0001,K24-0.0001))/0.01,0)),0)","v":0},{"$f":"T24*H24","v":0},0,0,{"$f":"M24*W24","v":0},{"$f":"N24*W24","v":0},null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A24=\"\",\"\",0.67)","v":""},{"$f":"IF(Q24=\"Yes\",IF(L24=\"EER\",H24*AB24*(AA24-12/IF(E24=\"Constant\",J24,K24)),H24*AB24*(AA24-IF(E24=\"Constant\",J24,K24))),0)","v":0},{"$f":"M24*AC24","v":0},{"$f":"N24*AC24","v":0},{"$f":"IF(Q24=\"Yes\",IF(L24=\"EER\",H24*$AE$5*(AA24-12/IF(E24=\"Constant\",J24,K24)),H24*$AE$5*(AA24-IF(E24=\"Constant\",J24,K24))),0)","v":0},{"$f":"M24*AF24","v":0},{"$f":"N24*AF24","v":0},0,0]
[null,"New",{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A25=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A25=\"\")=TRUE,\"\",VLOOKUP(A25,MeasureCode_Lookup,IF(E25=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A25=\"\")=TRUE,\"\",VLOOKUP(A25,MeasureCode_Lookup,IF(E25=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A25=\"\",J25=\"\",K25=\"\",H25=\"\")=TRUE,\"\",IF(OR(AND(L25=\"EER\",OR(J25<VLOOKUP(A25,MeasureCode_Lookup,7,FALSE),K25<VLOOKUP(A25,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L25=\"kW/Ton\",OR(J25>VLOOKUP(A25,MeasureCode_Lookup,7,FALSE),K25>VLOOKUP(A25,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H25<VLOOKUP(A25,MeasureCode_Lookup,5,FALSE),H25>VLOOKUP(A25,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q25=\"Yes\",VLOOKUP(A25,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R25*H25","v":0},{"$f":"IF(Q25=\"Yes\",VLOOKUP(A25,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L25=\"EER\",ROUNDDOWN((IF(E25=\"Constant\",J25+0.0001,K25+0.0001)-VLOOKUP(A25,MeasureCode_Lookup,IF(E25=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A25,MeasureCode_Lookup,IF(E25=\"Constant\",7,8),FALSE)-IF(E25=\"Constant\",J25-0.0001,K25-0.0001))/0.01,0)),0)","v":0},{"$f":"T25*H25","v":0},0,0,{"$f":"M25*W25","v":0},{"$f":"N25*W25","v":0},null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A25=\"\",\"\",0.67)","v":""},{"$f":"IF(Q25=\"Yes\",IF(L25=\"EER\",H25*AB25*(AA25-12/IF(E25=\"Constant\",J25,K25)),H25*AB25*(AA25-IF(E25=\"Constant\",J25,K25))),0)","v":0},{"$f":"M25*AC25","v":0},{"$f":"N25*AC25","v":0},{"$f":"IF(Q25=\"Yes\",IF(L25=\"EER\",H25*$AE$5*(AA25-12/IF(E25=\"Constant\",J25,K25)),H25*$AE$5*(AA25-IF(E25=\"Constant\",J25,K25))),0)","v":0},{"$f":"M25*AF25","v":0},{"$f":"N25*AF25","v":0},0,0]
[null,"New",{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A26=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A26=\"\")=TRUE,\"\",VLOOKUP(A26,MeasureCode_Lookup,IF(E26=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A26=\"\")=TRUE,\"\",VLOOKUP(A26,MeasureCode_Lookup,IF(E26=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A26=\"\",J26=\"\",K26=\"\",H26=\"\")=TRUE,\"\",IF(OR(AND(L26=\"EER\",OR(J26<VLOOKUP(A26,MeasureCode_Lookup,7,FALSE),K26<VLOOKUP(A26,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L26=\"kW/Ton\",OR(J26>VLOOKUP(A26,MeasureCode_Lookup,7,FALSE),K26>VLOOKUP(A26,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H26<VLOOKUP(A26,MeasureCode_Lookup,5,FALSE),H26>VLOOKUP(A26,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q26=\"Yes\",VLOOKUP(A26,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R26*H26","v":0},{"$f":"IF(Q26=\"Yes\",VLOOKUP(A26,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L26=\"EER\",ROUNDDOWN((IF(E26=\"Constant\",J26+0.0001,K26+0.0001)-VLOOKUP(A26,MeasureCode_Lookup,IF(E26=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A26,MeasureCode_Lookup,IF(E26=\"Constant\",7,8),FALSE)-IF(E26=\"Constant\",J26-0.0001,K26-0.0001))/0.01,0)),0)","v":0},{"$f":"T26*H26","v":0},0,0,{"$f":"M26*W26","v":0},{"$f":"N26*W26","v":0},null,{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A26=\"\",\"\",0.67)","v":""},{"$f":"IF(Q26=\"Yes\",IF(L26=\"EER\",H26*AB26*(AA26-12/IF(E26=\"Constant\",J26,K26)),H26*AB26*(AA26-IF(E26=\"Constant\",J26,K26))),0)","v":0},{"$f":"M26*AC26","v":0},{"$f":"N26*AC26","v":0},{"$f":"IF(Q26=\"Yes\",IF(L26=\"EER\",H26*$AE$5*(AA26-12/IF(E26=\"Constant\",J26,K26)),H26*$AE$5*(AA26-IF(E26=\"Constant\",J26,K26))),0)","v":0},{"$f":"M26*AF26","v":0},{"$f":"N26*AF26","v":0},0,0]
[null,"New",{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A27=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A27=\"\")=TRUE,\"\",VLOOKUP(A27,MeasureCode_Lookup,IF(E27=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A27=\"\")=TRUE,\"\",VLOOKUP(A27,MeasureCode_Lookup,IF(E27=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A27=\"\",J27=\"\",K27=\"\",H27=\"\")=TRUE,\"\",IF(OR(AND(L27=\"EER\",OR(J27<VLOOKUP(A27,MeasureCode_Lookup,7,FALSE),K27<VLOOKUP(A27,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L27=\"kW/Ton\",OR(J27>VLOOKUP(A27,MeasureCode_Lookup,7,FALSE),K27>VLOOKUP(A27,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H27<VLOOKUP(A27,MeasureCode_Lookup,5,FALSE),H27>VLOOKUP(A27,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q27=\"Yes\",VLOOKUP(A27,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R27*H27","v":0},{"$f":"IF(Q27=\"Yes\",VLOOKUP(A27,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L27=\"EER\",ROUNDDOWN((IF(E27=\"Constant\",J27+0.0001,K27+0.0001)-VLOOKUP(A27,MeasureCode_Lookup,IF(E27=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A27,MeasureCode_Lookup,IF(E27=\"Constant\",7,8),FALSE)-IF(E27=\"Constant\",J27-0.0001,K27-0.0001))/0.01,0)),0)","v":0},{"$f":"T27*H27","v":0},0,0,{"$f":"M27*W27","v":0},{"$f":"N27*W27","v":0},null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A27=\"\",\"\",0.67)","v":""},{"$f":"IF(Q27=\"Yes\",IF(L27=\"EER\",H27*AB27*(AA27-12/IF(E27=\"Constant\",J27,K27)),H27*AB27*(AA27-IF(E27=\"Constant\",J27,K27))),0)","v":0},{"$f":"M27*AC27","v":0},{"$f":"N27*AC27","v":0},{"$f":"IF(Q27=\"Yes\",IF(L27=\"EER\",H27*$AE$5*(AA27-12/IF(E27=\"Constant\",J27,K27)),H27*$AE$5*(AA27-IF(E27=\"Constant\",J27,K27))),0)","v":0},{"$f":"M27*AF27","v":0},{"$f":"N27*AF27","v":0},0,0]
[null,"New",{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A28=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A28=\"\")=TRUE,\"\",VLOOKUP(A28,MeasureCode_Lookup,IF(E28=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A28=\"\")=TRUE,\"\",VLOOKUP(A28,MeasureCode_Lookup,IF(E28=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A28=\"\",J28=\"\",K28=\"\",H28=\"\")=TRUE,\"\",IF(OR(AND(L28=\"EER\",OR(J28<VLOOKUP(A28,MeasureCode_Lookup,7,FALSE),K28<VLOOKUP(A28,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L28=\"kW/Ton\",OR(J28>VLOOKUP(A28,MeasureCode_Lookup,7,FALSE),K28>VLOOKUP(A28,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H28<VLOOKUP(A28,MeasureCode_Lookup,5,FALSE),H28>VLOOKUP(A28,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q28=\"Yes\",VLOOKUP(A28,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R28*H28","v":0},{"$f":"IF(Q28=\"Yes\",VLOOKUP(A28,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L28=\"EER\",ROUNDDOWN((IF(E28=\"Constant\",J28+0.0001,K28+0.0001)-VLOOKUP(A28,MeasureCode_Lookup,IF(E28=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A28,MeasureCode_Lookup,IF(E28=\"Constant\",7,8),FALSE)-IF(E28=\"Constant\",J28-0.0001,K28-0.0001))/0.01,0)),0)","v":0},{"$f":"T28*H28","v":0},0,0,{"$f":"M28*W28","v":0},{"$f":"N28*W28","v":0},null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A28=\"\",\"\",0.67)","v":""},{"$f":"IF(Q28=\"Yes\",IF(L28=\"EER\",H28*AB28*(AA28-12/IF(E28=\"Constant\",J28,K28)),H28*AB28*(AA28-IF(E28=\"Constant\",J28,K28))),0)","v":0},{"$f":"M28*AC28","v":0},{"$f":"N28*AC28","v":0},{"$f":"IF(Q28=\"Yes\",IF(L28=\"EER\",H28*$AE$5*(AA28-12/IF(E28=\"Constant\",J28,K28)),H28*$AE$5*(AA28-IF(E28=\"Constant\",J28,K28))),0)","v":0},{"$f":"M28*AF28","v":0},{"$f":"N28*AF28","v":0},0,0]
[null,"New",{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A29=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A29=\"\")=TRUE,\"\",VLOOKUP(A29,MeasureCode_Lookup,IF(E29=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A29=\"\")=TRUE,\"\",VLOOKUP(A29,MeasureCode_Lookup,IF(E29=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A29=\"\",J29=\"\",K29=\"\",H29=\"\")=TRUE,\"\",IF(OR(AND(L29=\"EER\",OR(J29<VLOOKUP(A29,MeasureCode_Lookup,7,FALSE),K29<VLOOKUP(A29,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L29=\"kW/Ton\",OR(J29>VLOOKUP(A29,MeasureCode_Lookup,7,FALSE),K29>VLOOKUP(A29,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H29<VLOOKUP(A29,MeasureCode_Lookup,5,FALSE),H29>VLOOKUP(A29,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q29=\"Yes\",VLOOKUP(A29,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R29*H29","v":0},{"$f":"IF(Q29=\"Yes\",VLOOKUP(A29,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L29=\"EER\",ROUNDDOWN((IF(E29=\"Constant\",J29+0.0001,K29+0.0001)-VLOOKUP(A29,MeasureCode_Lookup,IF(E29=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A29,MeasureCode_Lookup,IF(E29=\"Constant\",7,8),FALSE)-IF(E29=\"Constant\",J29-0.0001,K29-0.0001))/0.01,0)),0)","v":0},{"$f":"T29*H29","v":0},0,0,{"$f":"M29*W29","v":0},{"$f":"N29*W29","v":0},null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A29=\"\",\"\",0.67)","v":""},{"$f":"IF(Q29=\"Yes\",IF(L29=\"EER\",H29*AB29*(AA29-12/IF(E29=\"Constant\",J29,K29)),H29*AB29*(AA29-IF(E29=\"Constant\",J29,K29))),0)","v":0},{"$f":"M29*AC29","v":0},{"$f":"N29*AC29","v":0},{"$f":"IF(Q29=\"Yes\",IF(L29=\"EER\",H29*$AE$5*(AA29-12/IF(E29=\"Constant\",J29,K29)),H29*$AE$5*(AA29-IF(E29=\"Constant\",J29,K29))),0)","v":0},{"$f":"M29*AF29","v":0},{"$f":"N29*AF29","v":0},0,0]
[null,"New",{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A30=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A30=\"\")=TRUE,\"\",VLOOKUP(A30,MeasureCode_Lookup,IF(E30=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A30=\"\")=TRUE,\"\",VLOOKUP(A30,MeasureCode_Lookup,IF(E30=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A30=\"\",J30=\"\",K30=\"\",H30=\"\")=TRUE,\"\",IF(OR(AND(L30=\"EER\",OR(J30<VLOOKUP(A30,MeasureCode_Lookup,7,FALSE),K30<VLOOKUP(A30,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L30=\"kW/Ton\",OR(J30>VLOOKUP(A30,MeasureCode_Lookup,7,FALSE),K30>VLOOKUP(A30,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H30<VLOOKUP(A30,MeasureCode_Lookup,5,FALSE),H30>VLOOKUP(A30,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q30=\"Yes\",VLOOKUP(A30,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R30*H30","v":0},{"$f":"IF(Q30=\"Yes\",VLOOKUP(A30,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L30=\"EER\",ROUNDDOWN((IF(E30=\"Constant\",J30+0.0001,K30+0.0001)-VLOOKUP(A30,MeasureCode_Lookup,IF(E30=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A30,MeasureCode_Lookup,IF(E30=\"Constant\",7,8),FALSE)-IF(E30=\"Constant\",J30-0.0001,K30-0.0001))/0.01,0)),0)","v":0},{"$f":"T30*H30","v":0},0,0,{"$f":"M30*W30","v":0},{"$f":"N30*W30","v":0},null,{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A30=\"\",\"\",0.67)","v":""},{"$f":"IF(Q30=\"Yes\",IF(L30=\"EER\",H30*AB30*(AA30-12/IF(E30=\"Constant\",J30,K30)),H30*AB30*(AA30-IF(E30=\"Constant\",J30,K30))),0)","v":0},{"$f":"M30*AC30","v":0},{"$f":"N30*AC30","v":0},{"$f":"IF(Q30=\"Yes\",IF(L30=\"EER\",H30*$AE$5*(AA30-12/IF(E30=\"Constant\",J30,K30)),H30*$AE$5*(AA30-IF(E30=\"Constant\",J30,K30))),0)","v":0},{"$f":"M30*AF30","v":0},{"$f":"N30*AF30","v":0},0,0]
[null,"New",{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A31=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A31=\"\")=TRUE,\"\",VLOOKUP(A31,MeasureCode_Lookup,IF(E31=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A31=\"\")=TRUE,\"\",VLOOKUP(A31,MeasureCode_Lookup,IF(E31=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A31=\"\",J31=\"\",K31=\"\",H31=\"\")=TRUE,\"\",IF(OR(AND(L31=\"EER\",OR(J31<VLOOKUP(A31,MeasureCode_Lookup,7,FALSE),K31<VLOOKUP(A31,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L31=\"kW/Ton\",OR(J31>VLOOKUP(A31,MeasureCode_Lookup,7,FALSE),K31>VLOOKUP(A31,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H31<VLOOKUP(A31,MeasureCode_Lookup,5,FALSE),H31>VLOOKUP(A31,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q31=\"Yes\",VLOOKUP(A31,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R31*H31","v":0},{"$f":"IF(Q31=\"Yes\",VLOOKUP(A31,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L31=\"EER\",ROUNDDOWN((IF(E31=\"Constant\",J31+0.0001,K31+0.0001)-VLOOKUP(A31,MeasureCode_Lookup,IF(E31=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A31,MeasureCode_Lookup,IF(E31=\"Constant\",7,8),FALSE)-IF(E31=\"Constant\",J31-0.0001,K31-0.0001))/0.01,0)),0)","v":0},{"$f":"T31*H31","v":0},0,0,{"$f":"M31*W31","v":0},{"$f":"N31*W31","v":0},null,{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A31=\"\",\"\",0.67)","v":""},{"$f":"IF(Q31=\"Yes\",IF(L31=\"EER\",H31*AB31*(AA31-12/IF(E31=\"Constant\",J31,K31)),H31*AB31*(AA31-IF(E31=\"Constant\",J31,K31))),0)","v":0},{"$f":"M31*AC31","v":0},{"$f":"N31*AC31","v":0},{"$f":"IF(Q31=\"Yes\",IF(L31=\"EER\",H31*$AE$5*(AA31-12/IF(E31=\"Constant\",J31,K31)),H31*$AE$5*(AA31-IF(E31=\"Constant\",J31,K31))),0)","v":0},{"$f":"M31*AF31","v":0},{"$f":"N31*AF31","v":0},0,0]
[null,"New",{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A32=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A32=\"\")=TRUE,\"\",VLOOKUP(A32,MeasureCode_Lookup,IF(E32=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A32=\"\")=TRUE,\"\",VLOOKUP(A32,MeasureCode_Lookup,IF(E32=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A32=\"\",J32=\"\",K32=\"\",H32=\"\")=TRUE,\"\",IF(OR(AND(L32=\"EER\",OR(J32<VLOOKUP(A32,MeasureCode_Lookup,7,FALSE),K32<VLOOKUP(A32,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L32=\"kW/Ton\",OR(J32>VLOOKUP(A32,MeasureCode_Lookup,7,FALSE),K32>VLOOKUP(A32,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H32<VLOOKUP(A32,MeasureCode_Lookup,5,FALSE),H32>VLOOKUP(A32,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q32=\"Yes\",VLOOKUP(A32,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R32*H32","v":0},{"$f":"IF(Q32=\"Yes\",VLOOKUP(A32,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L32=\"EER\",ROUNDDOWN((IF(E32=\"Constant\",J32+0.0001,K32+0.0001)-VLOOKUP(A32,MeasureCode_Lookup,IF(E32=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A32,MeasureCode_Lookup,IF(E32=\"Constant\",7,8),FALSE)-IF(E32=\"Constant\",J32-0.0001,K32-0.0001))/0.01,0)),0)","v":0},{"$f":"T32*H32","v":0},0,0,{"$f":"M32*W32","v":0},{"$f":"N32*W32","v":0},null,{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A32=\"\",\"\",0.67)","v":""},{"$f":"IF(Q32=\"Yes\",IF(L32=\"EER\",H32*AB32*(AA32-12/IF(E32=\"Constant\",J32,K32)),H32*AB32*(AA32-IF(E32=\"Constant\",J32,K32))),0)","v":0},{"$f":"M32*AC32","v":0},{"$f":"N32*AC32","v":0},{"$f":"IF(Q32=\"Yes\",IF(L32=\"EER\",H32*$AE$5*(AA32-12/IF(E32=\"Constant\",J32,K32)),H32*$AE$5*(AA32-IF(E32=\"Constant\",J32,K32))),0)","v":0},{"$f":"M32*AF32","v":0},{"$f":"N32*AF32","v":0},0,0]
[null,"New",{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A33=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A33=\"\")=TRUE,\"\",VLOOKUP(A33,MeasureCode_Lookup,IF(E33=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A33=\"\")=TRUE,\"\",VLOOKUP(A33,MeasureCode_Lookup,IF(E33=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A33=\"\",J33=\"\",K33=\"\",H33=\"\")=TRUE,\"\",IF(OR(AND(L33=\"EER\",OR(J33<VLOOKUP(A33,MeasureCode_Lookup,7,FALSE),K33<VLOOKUP(A33,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L33=\"kW/Ton\",OR(J33>VLOOKUP(A33,MeasureCode_Lookup,7,FALSE),K33>VLOOKUP(A33,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H33<VLOOKUP(A33,MeasureCode_Lookup,5,FALSE),H33>VLOOKUP(A33,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q33=\"Yes\",VLOOKUP(A33,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R33*H33","v":0},{"$f":"IF(Q33=\"Yes\",VLOOKUP(A33,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L33=\"EER\",ROUNDDOWN((IF(E33=\"Constant\",J33+0.0001,K33+0.0001)-VLOOKUP(A33,MeasureCode_Lookup,IF(E33=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A33,MeasureCode_Lookup,IF(E33=\"Constant\",7,8),FALSE)-IF(E33=\"Constant\",J33-0.0001,K33-0.0001))/0.01,0)),0)","v":0},{"$f":"T33*H33","v":0},0,0,{"$f":"M33*W33","v":0},{"$f":"N33*W33","v":0},null,{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A33=\"\",\"\",0.67)","v":""},{"$f":"IF(Q33=\"Yes\",IF(L33=\"EER\",H33*AB33*(AA33-12/IF(E33=\"Constant\",J33,K33)),H33*AB33*(AA33-IF(E33=\"Constant\",J33,K33))),0)","v":0},{"$f":"M33*AC33","v":0},{"$f":"N33*AC33","v":0},{"$f":"IF(Q33=\"Yes\",IF(L33=\"EER\",H33*$AE$5*(AA33-12/IF(E33=\"Constant\",J33,K33)),H33*$AE$5*(AA33-IF(E33=\"Constant\",J33,K33))),0)","v":0},{"$f":"M33*AF33","v":0},{"$f":"N33*AF33","v":0},0,0]
[null,"New",{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A34=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A34=\"\")=TRUE,\"\",VLOOKUP(A34,MeasureCode_Lookup,IF(E34=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A34=\"\")=TRUE,\"\",VLOOKUP(A34,MeasureCode_Lookup,IF(E34=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A34=\"\",J34=\"\",K34=\"\",H34=\"\")=TRUE,\"\",IF(OR(AND(L34=\"EER\",OR(J34<VLOOKUP(A34,MeasureCode_Lookup,7,FALSE),K34<VLOOKUP(A34,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L34=\"kW/Ton\",OR(J34>VLOOKUP(A34,MeasureCode_Lookup,7,FALSE),K34>VLOOKUP(A34,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H34<VLOOKUP(A34,MeasureCode_Lookup,5,FALSE),H34>VLOOKUP(A34,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q34=\"Yes\",VLOOKUP(A34,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R34*H34","v":0},{"$f":"IF(Q34=\"Yes\",VLOOKUP(A34,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L34=\"EER\",ROUNDDOWN((IF(E34=\"Constant\",J34+0.0001,K34+0.0001)-VLOOKUP(A34,MeasureCode_Lookup,IF(E34=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A34,MeasureCode_Lookup,IF(E34=\"Constant\",7,8),FALSE)-IF(E34=\"Constant\",J34-0.0001,K34-0.0001))/0.01,0)),0)","v":0},{"$f":"T34*H34","v":0},0,0,{"$f":"M34*W34","v":0},{"$f":"N34*W34","v":0},null,{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A34=\"\",\"\",0.67)","v":""},{"$f":"IF(Q34=\"Yes\",IF(L34=\"EER\",H34*AB34*(AA34-12/IF(E34=\"Constant\",J34,K34)),H34*AB34*(AA34-IF(E34=\"Constant\",J34,K34))),0)","v":0},{"$f":"M34*AC34","v":0},{"$f":"N34*AC34","v":0},{"$f":"IF(Q34=\"Yes\",IF(L34=\"EER\",H34*$AE$5*(AA34-12/IF(E34=\"Constant\",J34,K34)),H34*$AE$5*(AA34-IF(E34=\"Constant\",J34,K34))),0)","v":0},{"$f":"M34*AF34","v":0},{"$f":"N34*AF34","v":0},0,0]
[null,"New",{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A35=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A35=\"\")=TRUE,\"\",VLOOKUP(A35,MeasureCode_Lookup,IF(E35=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A35=\"\")=TRUE,\"\",VLOOKUP(A35,MeasureCode_Lookup,IF(E35=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A35=\"\",J35=\"\",K35=\"\",H35=\"\")=TRUE,\"\",IF(OR(AND(L35=\"EER\",OR(J35<VLOOKUP(A35,MeasureCode_Lookup,7,FALSE),K35<VLOOKUP(A35,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L35=\"kW/Ton\",OR(J35>VLOOKUP(A35,MeasureCode_Lookup,7,FALSE),K35>VLOOKUP(A35,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H35<VLOOKUP(A35,MeasureCode_Lookup,5,FALSE),H35>VLOOKUP(A35,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q35=\"Yes\",VLOOKUP(A35,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R35*H35","v":0},{"$f":"IF(Q35=\"Yes\",VLOOKUP(A35,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L35=\"EER\",ROUNDDOWN((IF(E35=\"Constant\",J35+0.0001,K35+0.0001)-VLOOKUP(A35,MeasureCode_Lookup,IF(E35=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A35,MeasureCode_Lookup,IF(E35=\"Constant\",7,8),FALSE)-IF(E35=\"Constant\",J35-0.0001,K35-0.0001))/0.01,0)),0)","v":0},{"$f":"T35*H35","v":0},0,0,{"$f":"M35*W35","v":0},{"$f":"N35*W35","v":0},null,{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A35=\"\",\"\",0.67)","v":""},{"$f":"IF(Q35=\"Yes\",IF(L35=\"EER\",H35*AB35*(AA35-12/IF(E35=\"Constant\",J35,K35)),H35*AB35*(AA35-IF(E35=\"Constant\",J35,K35))),0)","v":0},{"$f":"M35*AC35","v":0},{"$f":"N35*AC35","v":0},{"$f":"IF(Q35=\"Yes\",IF(L35=\"EER\",H35*$AE$5*(AA35-12/IF(E35=\"Constant\",J35,K35)),H35*$AE$5*(AA35-IF(E35=\"Constant\",J35,K35))),0)","v":0},{"$f":"M35*AF35","v":0},{"$f":"N35*AF35","v":0},0,0]
[null,"New",{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A36=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A36=\"\")=TRUE,\"\",VLOOKUP(A36,MeasureCode_Lookup,IF(E36=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A36=\"\")=TRUE,\"\",VLOOKUP(A36,MeasureCode_Lookup,IF(E36=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A36=\"\",J36=\"\",K36=\"\",H36=\"\")=TRUE,\"\",IF(OR(AND(L36=\"EER\",OR(J36<VLOOKUP(A36,MeasureCode_Lookup,7,FALSE),K36<VLOOKUP(A36,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L36=\"kW/Ton\",OR(J36>VLOOKUP(A36,MeasureCode_Lookup,7,FALSE),K36>VLOOKUP(A36,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H36<VLOOKUP(A36,MeasureCode_Lookup,5,FALSE),H36>VLOOKUP(A36,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q36=\"Yes\",VLOOKUP(A36,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R36*H36","v":0},{"$f":"IF(Q36=\"Yes\",VLOOKUP(A36,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L36=\"EER\",ROUNDDOWN((IF(E36=\"Constant\",J36+0.0001,K36+0.0001)-VLOOKUP(A36,MeasureCode_Lookup,IF(E36=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A36,MeasureCode_Lookup,IF(E36=\"Constant\",7,8),FALSE)-IF(E36=\"Constant\",J36-0.0001,K36-0.0001))/0.01,0)),0)","v":0},{"$f":"T36*H36","v":0},0,0,{"$f":"M36*W36","v":0},{"$f":"N36*W36","v":0},null,{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A36=\"\",\"\",0.67)","v":""},{"$f":"IF(Q36=\"Yes\",IF(L36=\"EER\",H36*AB36*(AA36-12/IF(E36=\"Constant\",J36,K36)),H36*AB36*(AA36-IF(E36=\"Constant\",J36,K36))),0)","v":0},{"$f":"M36*AC36","v":0},{"$f":"N36*AC36","v":0},{"$f":"IF(Q36=\"Yes\",IF(L36=\"EER\",H36*$AE$5*(AA36-12/IF(E36=\"Constant\",J36,K36)),H36*$AE$5*(AA36-IF(E36=\"Constant\",J36,K36))),0)","v":0},{"$f":"M36*AF36","v":0},{"$f":"N36*AF36","v":0},0,0]
[null,"New",{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A37=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A37=\"\")=TRUE,\"\",VLOOKUP(A37,MeasureCode_Lookup,IF(E37=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A37=\"\")=TRUE,\"\",VLOOKUP(A37,MeasureCode_Lookup,IF(E37=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A37=\"\",J37=\"\",K37=\"\",H37=\"\")=TRUE,\"\",IF(OR(AND(L37=\"EER\",OR(J37<VLOOKUP(A37,MeasureCode_Lookup,7,FALSE),K37<VLOOKUP(A37,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L37=\"kW/Ton\",OR(J37>VLOOKUP(A37,MeasureCode_Lookup,7,FALSE),K37>VLOOKUP(A37,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H37<VLOOKUP(A37,MeasureCode_Lookup,5,FALSE),H37>VLOOKUP(A37,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q37=\"Yes\",VLOOKUP(A37,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R37*H37","v":0},{"$f":"IF(Q37=\"Yes\",VLOOKUP(A37,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L37=\"EER\",ROUNDDOWN((IF(E37=\"Constant\",J37+0.0001,K37+0.0001)-VLOOKUP(A37,MeasureCode_Lookup,IF(E37=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A37,MeasureCode_Lookup,IF(E37=\"Constant\",7,8),FALSE)-IF(E37=\"Constant\",J37-0.0001,K37-0.0001))/0.01,0)),0)","v":0},{"$f":"T37*H37","v":0},0,0,{"$f":"M37*W37","v":0},{"$f":"N37*W37","v":0},null,{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A37=\"\",\"\",0.67)","v":""},{"$f":"IF(Q37=\"Yes\",IF(L37=\"EER\",H37*AB37*(AA37-12/IF(E37=\"Constant\",J37,K37)),H37*AB37*(AA37-IF(E37=\"Constant\",J37,K37))),0)","v":0},{"$f":"M37*AC37","v":0},{"$f":"N37*AC37","v":0},{"$f":"IF(Q37=\"Yes\",IF(L37=\"EER\",H37*$AE$5*(AA37-12/IF(E37=\"Constant\",J37,K37)),H37*$AE$5*(AA37-IF(E37=\"Constant\",J37,K37))),0)","v":0},{"$f":"M37*AF37","v":0},{"$f":"N37*AF37","v":0},0,0]
[null,"New",{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A38=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A38=\"\")=TRUE,\"\",VLOOKUP(A38,MeasureCode_Lookup,IF(E38=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A38=\"\")=TRUE,\"\",VLOOKUP(A38,MeasureCode_Lookup,IF(E38=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A38=\"\",J38=\"\",K38=\"\",H38=\"\")=TRUE,\"\",IF(OR(AND(L38=\"EER\",OR(J38<VLOOKUP(A38,MeasureCode_Lookup,7,FALSE),K38<VLOOKUP(A38,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L38=\"kW/Ton\",OR(J38>VLOOKUP(A38,MeasureCode_Lookup,7,FALSE),K38>VLOOKUP(A38,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H38<VLOOKUP(A38,MeasureCode_Lookup,5,FALSE),H38>VLOOKUP(A38,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q38=\"Yes\",VLOOKUP(A38,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R38*H38","v":0},{"$f":"IF(Q38=\"Yes\",VLOOKUP(A38,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L38=\"EER\",ROUNDDOWN((IF(E38=\"Constant\",J38+0.0001,K38+0.0001)-VLOOKUP(A38,MeasureCode_Lookup,IF(E38=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A38,MeasureCode_Lookup,IF(E38=\"Constant\",7,8),FALSE)-IF(E38=\"Constant\",J38-0.0001,K38-0.0001))/0.01,0)),0)","v":0},{"$f":"T38*H38","v":0},0,0,{"$f":"M38*W38","v":0},{"$f":"N38*W38","v":0},null,{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A38=\"\",\"\",0.67)","v":""},{"$f":"IF(Q38=\"Yes\",IF(L38=\"EER\",H38*AB38*(AA38-12/IF(E38=\"Constant\",J38,K38)),H38*AB38*(AA38-IF(E38=\"Constant\",J38,K38))),0)","v":0},{"$f":"M38*AC38","v":0},{"$f":"N38*AC38","v":0},{"$f":"IF(Q38=\"Yes\",IF(L38=\"EER\",H38*$AE$5*(AA38-12/IF(E38=\"Constant\",J38,K38)),H38*$AE$5*(AA38-IF(E38=\"Constant\",J38,K38))),0)","v":0},{"$f":"M38*AF38","v":0},{"$f":"N38*AF38","v":0},0,0]
[null,"New",{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A39=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A39=\"\")=TRUE,\"\",VLOOKUP(A39,MeasureCode_Lookup,IF(E39=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A39=\"\")=TRUE,\"\",VLOOKUP(A39,MeasureCode_Lookup,IF(E39=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A39=\"\",J39=\"\",K39=\"\",H39=\"\")=TRUE,\"\",IF(OR(AND(L39=\"EER\",OR(J39<VLOOKUP(A39,MeasureCode_Lookup,7,FALSE),K39<VLOOKUP(A39,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L39=\"kW/Ton\",OR(J39>VLOOKUP(A39,MeasureCode_Lookup,7,FALSE),K39>VLOOKUP(A39,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H39<VLOOKUP(A39,MeasureCode_Lookup,5,FALSE),H39>VLOOKUP(A39,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q39=\"Yes\",VLOOKUP(A39,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R39*H39","v":0},{"$f":"IF(Q39=\"Yes\",VLOOKUP(A39,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L39=\"EER\",ROUNDDOWN((IF(E39=\"Constant\",J39+0.0001,K39+0.0001)-VLOOKUP(A39,MeasureCode_Lookup,IF(E39=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A39,MeasureCode_Lookup,IF(E39=\"Constant\",7,8),FALSE)-IF(E39=\"Constant\",J39-0.0001,K39-0.0001))/0.01,0)),0)","v":0},{"$f":"T39*H39","v":0},0,0,{"$f":"M39*W39","v":0},{"$f":"N39*W39","v":0},null,{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A39=\"\",\"\",0.67)","v":""},{"$f":"IF(Q39=\"Yes\",IF(L39=\"EER\",H39*AB39*(AA39-12/IF(E39=\"Constant\",J39,K39)),H39*AB39*(AA39-IF(E39=\"Constant\",J39,K39))),0)","v":0},{"$f":"M39*AC39","v":0},{"$f":"N39*AC39","v":0},{"$f":"IF(Q39=\"Yes\",IF(L39=\"EER\",H39*$AE$5*(AA39-12/IF(E39=\"Constant\",J39,K39)),H39*$AE$5*(AA39-IF(E39=\"Constant\",J39,K39))),0)","v":0},{"$f":"M39*AF39","v":0},{"$f":"N39*AF39","v":0},0,0]
[null,"New",{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A40=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A40=\"\")=TRUE,\"\",VLOOKUP(A40,MeasureCode_Lookup,IF(E40=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A40=\"\")=TRUE,\"\",VLOOKUP(A40,MeasureCode_Lookup,IF(E40=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A40=\"\",J40=\"\",K40=\"\",H40=\"\")=TRUE,\"\",IF(OR(AND(L40=\"EER\",OR(J40<VLOOKUP(A40,MeasureCode_Lookup,7,FALSE),K40<VLOOKUP(A40,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L40=\"kW/Ton\",OR(J40>VLOOKUP(A40,MeasureCode_Lookup,7,FALSE),K40>VLOOKUP(A40,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H40<VLOOKUP(A40,MeasureCode_Lookup,5,FALSE),H40>VLOOKUP(A40,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q40=\"Yes\",VLOOKUP(A40,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R40*H40","v":0},{"$f":"IF(Q40=\"Yes\",VLOOKUP(A40,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L40=\"EER\",ROUNDDOWN((IF(E40=\"Constant\",J40+0.0001,K40+0.0001)-VLOOKUP(A40,MeasureCode_Lookup,IF(E40=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A40,MeasureCode_Lookup,IF(E40=\"Constant\",7,8),FALSE)-IF(E40=\"Constant\",J40-0.0001,K40-0.0001))/0.01,0)),0)","v":0},{"$f":"T40*H40","v":0},0,0,{"$f":"M40*W40","v":0},{"$f":"N40*W40","v":0},null,{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A40=\"\",\"\",0.67)","v":""},{"$f":"IF(Q40=\"Yes\",IF(L40=\"EER\",H40*AB40*(AA40-12/IF(E40=\"Constant\",J40,K40)),H40*AB40*(AA40-IF(E40=\"Constant\",J40,K40))),0)","v":0},{"$f":"M40*AC40","v":0},{"$f":"N40*AC40","v":0},{"$f":"IF(Q40=\"Yes\",IF(L40=\"EER\",H40*$AE$5*(AA40-12/IF(E40=\"Constant\",J40,K40)),H40*$AE$5*(AA40-IF(E40=\"Constant\",J40,K40))),0)","v":0},{"$f":"M40*AF40","v":0},{"$f":"N40*AF40","v":0},0,0]
[null,"New",{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A41=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A41=\"\")=TRUE,\"\",VLOOKUP(A41,MeasureCode_Lookup,IF(E41=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A41=\"\")=TRUE,\"\",VLOOKUP(A41,MeasureCode_Lookup,IF(E41=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A41=\"\",J41=\"\",K41=\"\",H41=\"\")=TRUE,\"\",IF(OR(AND(L41=\"EER\",OR(J41<VLOOKUP(A41,MeasureCode_Lookup,7,FALSE),K41<VLOOKUP(A41,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L41=\"kW/Ton\",OR(J41>VLOOKUP(A41,MeasureCode_Lookup,7,FALSE),K41>VLOOKUP(A41,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H41<VLOOKUP(A41,MeasureCode_Lookup,5,FALSE),H41>VLOOKUP(A41,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q41=\"Yes\",VLOOKUP(A41,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R41*H41","v":0},{"$f":"IF(Q41=\"Yes\",VLOOKUP(A41,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L41=\"EER\",ROUNDDOWN((IF(E41=\"Constant\",J41+0.0001,K41+0.0001)-VLOOKUP(A41,MeasureCode_Lookup,IF(E41=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A41,MeasureCode_Lookup,IF(E41=\"Constant\",7,8),FALSE)-IF(E41=\"Constant\",J41-0.0001,K41-0.0001))/0.01,0)),0)","v":0},{"$f":"T41*H41","v":0},0,0,{"$f":"M41*W41","v":0},{"$f":"N41*W41","v":0},null,{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A41=\"\",\"\",0.67)","v":""},{"$f":"IF(Q41=\"Yes\",IF(L41=\"EER\",H41*AB41*(AA41-12/IF(E41=\"Constant\",J41,K41)),H41*AB41*(AA41-IF(E41=\"Constant\",J41,K41))),0)","v":0},{"$f":"M41*AC41","v":0},{"$f":"N41*AC41","v":0},{"$f":"IF(Q41=\"Yes\",IF(L41=\"EER\",H41*$AE$5*(AA41-12/IF(E41=\"Constant\",J41,K41)),H41*$AE$5*(AA41-IF(E41=\"Constant\",J41,K41))),0)","v":0},{"$f":"M41*AF41","v":0},{"$f":"N41*AF41","v":0},0,0]
[null,"New",{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A42=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A42=\"\")=TRUE,\"\",VLOOKUP(A42,MeasureCode_Lookup,IF(E42=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A42=\"\")=TRUE,\"\",VLOOKUP(A42,MeasureCode_Lookup,IF(E42=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A42=\"\",J42=\"\",K42=\"\",H42=\"\")=TRUE,\"\",IF(OR(AND(L42=\"EER\",OR(J42<VLOOKUP(A42,MeasureCode_Lookup,7,FALSE),K42<VLOOKUP(A42,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L42=\"kW/Ton\",OR(J42>VLOOKUP(A42,MeasureCode_Lookup,7,FALSE),K42>VLOOKUP(A42,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H42<VLOOKUP(A42,MeasureCode_Lookup,5,FALSE),H42>VLOOKUP(A42,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q42=\"Yes\",VLOOKUP(A42,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R42*H42","v":0},{"$f":"IF(Q42=\"Yes\",VLOOKUP(A42,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L42=\"EER\",ROUNDDOWN((IF(E42=\"Constant\",J42+0.0001,K42+0.0001)-VLOOKUP(A42,MeasureCode_Lookup,IF(E42=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A42,MeasureCode_Lookup,IF(E42=\"Constant\",7,8),FALSE)-IF(E42=\"Constant\",J42-0.0001,K42-0.0001))/0.01,0)),0)","v":0},{"$f":"T42*H42","v":0},0,0,{"$f":"M42*W42","v":0},{"$f":"N42*W42","v":0},null,{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A42=\"\",\"\",0.67)","v":""},{"$f":"IF(Q42=\"Yes\",IF(L42=\"EER\",H42*AB42*(AA42-12/IF(E42=\"Constant\",J42,K42)),H42*AB42*(AA42-IF(E42=\"Constant\",J42,K42))),0)","v":0},{"$f":"M42*AC42","v":0},{"$f":"N42*AC42","v":0},{"$f":"IF(Q42=\"Yes\",IF(L42=\"EER\",H42*$AE$5*(AA42-12/IF(E42=\"Constant\",J42,K42)),H42*$AE$5*(AA42-IF(E42=\"Constant\",J42,K42))),0)","v":0},{"$f":"M42*AF42","v":0},{"$f":"N42*AF42","v":0},0,0]
[null,"New",{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A43=\"\",\"\",\"Comfort\")","v":""},{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,MeasureCode_Lookup,3,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,MeasureCode_Lookup,4,FALSE))","v":""},null,null,{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A43=\"\")=TRUE,\"\",VLOOKUP(A43,MeasureCode_Lookup,IF(E43=\"Constant\",8,7),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A43=\"\")=TRUE,\"\",VLOOKUP(A43,MeasureCode_Lookup,IF(E43=\"Constant\",7,8),FALSE))","v":""},{"$f":"IF(OR($C$14=\"\",$G$14=\"\",A43=\"\",J43=\"\",K43=\"\",H43=\"\")=TRUE,\"\",IF(OR(AND(L43=\"EER\",OR(J43<VLOOKUP(A43,MeasureCode_Lookup,7,FALSE),K43<VLOOKUP(A43,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,AND(L43=\"kW/Ton\",OR(J43>VLOOKUP(A43,MeasureCode_Lookup,7,FALSE),K43>VLOOKUP(A43,MeasureCode_Lookup,8,FALSE))=TRUE)=TRUE,H43<VLOOKUP(A43,MeasureCode_Lookup,5,FALSE),H43>VLOOKUP(A43,MeasureCode_Lookup,6,FALSE))=TRUE,\"No\",\"Yes\"))","v":""},{"$f":"IF(Q43=\"Yes\",VLOOKUP(A43,MeasureCode_Lookup,IF($C$14=\"Existing Building\",9,10),FALSE),0)","v":0},{"$f":"R43*H43","v":0},{"$f":"IF(Q43=\"Yes\",VLOOKUP(A43,MeasureCode_Lookup,IF($C$14=\"Existing Building\",11,12),FALSE)*IF(L43=\"EER\",ROUNDDOWN((IF(E43=\"Constant\",J43+0.0001,K43+0.0001)-VLOOKUP(A43,MeasureCode_Lookup,IF(E43=\"Constant\",7,8),FALSE))/0.1,0),ROUNDDOWN((VLOOKUP(A43,MeasureCode_Lookup,IF(E43=\"Constant\",7,8),FALSE)-IF(E43=\"Constant\",J43-0.0001,K43-0.0001))/0.01,0)),0)","v":0},{"$f":"T43*H43","v":0},0,0,{"$f":"M43*W43","v":0},{"$f":"N43*W43","v":0},null,{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,MeasureCode_Lookup,13,FALSE))","v":""},{"$f":"IF(A43=\"\",\"\",0.67)","v":""},{"$f":"IF(Q43=\"Yes\",IF(L43=\"EER\",H43*AB43*(AA43-12/IF(E43=\"Constant\",J43,K43)),H43*AB43*(AA43-IF(E43=\"Constant\",J43,K43))),0)","v":0},{"$f":"M43*AC43","v":0},{"$f":"N43*AC43","v":0},{"$f":"IF(Q43=\"Yes\",IF(L43=\"EER\",H43*$AE$5*(AA43-12/IF(E43=\"Constant\",J43,K43)),H43*$AE$5*(AA43-IF(E43=\"Constant\",J43,K43))),0)","v":0},{"$f":"M43*AF43","v":0},{"$f":"N43*AF43","v":0},0,0]

{"sheet":"Measure Code","index":1,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Type & Capacity Range","Speed","Efficiency Units","Min Capacity (Tons)","Max Capacity (Tons)","Min Full Load Efficiency","Min IPLV Efficiency","Base Incentive ($/Ton)\nEB","Base Incentive ($/Ton)\nNC","Performance Incentive ($/Ton)\nEB","Performance Incentive\n($/Ton)\nNC","Baseline Efficiency\n(kW/Ton)"]
["CHILL1","Air Cooled Chiller Capacity: tons < 150","Constant","EER",0.01,149.99,10.3,13.7,20,10,3.5,3.5,1.1879999999999999]
["CHILL2","Air Cooled Chiller Capacity: tons < 150","Variable","EER",0.01,149.99,9.6999999999999993,16.12,90,45,4,4,0.75900000000000001]
["CHILL3","Air Cooled Chiller Capacity: tons ≥ 150","Constant","EER",150,999999,10.3,14,20,10,2.75,2.75,1.1879999999999999]
["CHILL4","Air Cooled Chiller Capacity: tons ≥ 150","Variable","EER",150,999999,9.6999999999999993,16.420000000000002,92,46,4,4,0.745]
["CHILL5","Water Cooled Positive Displacement Chiller Capacity: tons < 75","Constant","kW/Ton",0.01,74.989999999999995,0.73499999999999999,0.6,13,6.5,2.25,2.25,0.75]
["CHILL6","Water Cooled Positive Displacement Chiller Capacity: tons < 75","Variable","kW/Ton",0.01,74.989999999999995,0.78,0.49,40,20,2.5,2.5,0.5]
["CHILL7","Water Cooled Positive Displacement Chiller Capacity: 75 ≤ tons < 150","Constant","kW/Ton",75,149.99,0.70599999999999996,0.56000000000000005,20,10,2,2,0.72]
["CHILL8","Water Cooled Positive Displacement Chiller Capacity: 75 ≤ tons < 150","Variable","kW/Ton",75,149.99,0.75,0.48,43,21.5,2,2,0.49]
["CHILL9","Water Cooled Positive Displacement Chiller Capacity: 150 ≤ tons < 300","Constant","kW/Ton",150,299.99,0.64700000000000002,0.54,17,8.5,2,2,0.66]
["CHILL10","Water Cooled Positive Displacement Chiller Capacity: 150 ≤ tons < 300","Variable","kW/Ton",150,299.99,0.68,0.43099999999999999,43,21.5,2,2,0.44]
["CHILL11","Water Cooled Positive Displacement Chiller Capacity: 300 ≤ tons < 600","Constant","kW/Ton",300,599.99,0.59799999999999998,0.52,15,7.5,2.25,2.25,0.61]
["CHILL12","Water Cooled Positive Displacement Chiller Capacity: 300 ≤ tons < 600","Variable","kW/Ton",300,599.99,0.625,0.40200000000000002,37,18.5,2,2,0.41]
["CHILL13","Water Cooled Positive Displacement Chiller Capacity: tons ≥ 600","Constant","kW/Ton",600,999999,0.54900000000000004,0.5,30,15,2,2,0.56000000000000005]
["CHILL14","Water Cooled Positive Displacement Chiller Capacity: tons ≥ 600","Variable","kW/Ton",600,999999,0.58499999999999996,0.372,44,22,2,2,0.38]
["CHILL15","Water Cooled Centrifugal Chiller Capacity: tons < 150","Constant","kW/Ton",0.01,149.99,0.59799999999999998,0.55000000000000004,24,12,2.25,2.25,0.61]
["CHILL16","Water Cooled Centrifugal Chiller Capacity: tons < 150","Variable","kW/Ton",0.01,149.99,0.69499999999999995,0.43099999999999999,24,12,2.75,2.75,0.44]
["CHILL17","Water Cooled Centrifugal Chiller Capacity: 150 ≤ tons < 300","Constant","kW/Ton",150,299.99,0.59799999999999998,0.55000000000000004,10,5,2,2,0.61]
["CHILL18","Water Cooled Centrifugal Chiller Capacity: 150 ≤ tons < 300","Variable","kW/Ton",150,299.99,0.63500000000000001,0.39200000000000002,30,15,2.5,2.5,0.4]
["CHILL19","Water Cooled Centrifugal Chiller Capacity: 300 ≤ tons < 400","Constant","kW/Ton",300,399.99,0.54900000000000004,0.52,8,4,2,2,0.56000000000000005]
["CHILL20","Water Cooled Centrifugal Chiller Capacity: 300 ≤ tons < 400","Variable","kW/Ton",300,399.99,0.59499999999999997,0.38200000000000001,20,10,2,2,0.39]
["CHILL21","Water Cooled Centrifugal Chiller Capacity: 400 ≤ tons < 600","Constant","kW/Ton",400,599.99,0.54900000000000004,0.5,8,4,2,2,0.56000000000000005]
["CHILL22","Water Cooled Centrifugal Chiller Capacity: 400 ≤ tons < 600","Variable","kW/Ton",400,599.99,0.58499999999999996,0.372,25,12.5,2,2,0.38]
["CHILL23","Water Cooled Centrifugal Chiller Capacity: tons ≥ 600","Constant","kW/Ton",600,999999,0.54900000000000004,0.5,8,4,2,2,0.56000000000000005]
["CHILL24","Water Cooled Centrifugal Chiller Capacity: tons ≥ 600","Variable","kW/Ton",600,999999,0.58499999999999996,0.372,25,12.5,2,2,0.38]

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

{"sheet":"Export","index":3,"n_rows":26,"n_cols":25,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Measure Type","Manufacturer","Model","Capacity/Size","Capacity/Size Units","EER Efficiency","SEER Efficiency","Incentive Per Unit","Quantity Committed","Annual Electricity Savings","Peak Demand Reduction","Lifetime Electricity Savings","Annual Gas Savings","Lifetime Gas Savings","Efficiency- other","Efficiency- other-type","Measure ID removed","Quantity Installed","Project in UEZ","Project in OZ","Municipality","K-12 School","County","Affordable Housing","Enhanced Incentive per Unit"]
[{"$f":"IF(ISBLANK(Worksheet!M19)=TRUE,\"\",(IF(LEFT(Worksheet!C19,1)=\"A\",70,IF(Worksheet!E19=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F19","v":0},{"$f":"Worksheet!G19","v":0},{"$f":"Worksheet!H19","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S19+Worksheet!U19,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M19)=FALSE,Worksheet!M19,\"\")","v":""},{"$f":"Worksheet!AF19","v":0},{"$f":"Worksheet!AC19","v":0},{"$f":"Worksheet!AF19*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N19)=FALSE,Worksheet!N19,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V19,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M20)=TRUE,\"\",(IF(LEFT(Worksheet!C20,1)=\"A\",70,IF(Worksheet!E20=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F20","v":0},{"$f":"Worksheet!G20","v":0},{"$f":"Worksheet!H20","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S20+Worksheet!U20,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M20)=FALSE,Worksheet!M20,\"\")","v":""},{"$f":"Worksheet!AF20","v":0},{"$f":"Worksheet!AC20","v":0},{"$f":"Worksheet!AF20*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N20)=FALSE,Worksheet!N20,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V20,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M21)=TRUE,\"\",(IF(LEFT(Worksheet!C21,1)=\"A\",70,IF(Worksheet!E21=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F21","v":0},{"$f":"Worksheet!G21","v":0},{"$f":"Worksheet!H21","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S21+Worksheet!U21,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M21)=FALSE,Worksheet!M21,\"\")","v":""},{"$f":"Worksheet!AF21","v":0},{"$f":"Worksheet!AC21","v":0},{"$f":"Worksheet!AF21*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N21)=FALSE,Worksheet!N21,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V21,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M22)=TRUE,\"\",(IF(LEFT(Worksheet!C22,1)=\"A\",70,IF(Worksheet!E22=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F22","v":0},{"$f":"Worksheet!G22","v":0},{"$f":"Worksheet!H22","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S22+Worksheet!U22,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M22)=FALSE,Worksheet!M22,\"\")","v":""},{"$f":"Worksheet!AF22","v":0},{"$f":"Worksheet!AC22","v":0},{"$f":"Worksheet!AF22*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N22)=FALSE,Worksheet!N22,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V22,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M23)=TRUE,\"\",(IF(LEFT(Worksheet!C23,1)=\"A\",70,IF(Worksheet!E23=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F23","v":0},{"$f":"Worksheet!G23","v":0},{"$f":"Worksheet!H23","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S23+Worksheet!U23,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M23)=FALSE,Worksheet!M23,\"\")","v":""},{"$f":"Worksheet!AF23","v":0},{"$f":"Worksheet!AC23","v":0},{"$f":"Worksheet!AF23*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N23)=FALSE,Worksheet!N23,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V23,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M24)=TRUE,\"\",(IF(LEFT(Worksheet!C24,1)=\"A\",70,IF(Worksheet!E24=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F24","v":0},{"$f":"Worksheet!G24","v":0},{"$f":"Worksheet!H24","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S24+Worksheet!U24,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M24)=FALSE,Worksheet!M24,\"\")","v":""},{"$f":"Worksheet!AF24","v":0},{"$f":"Worksheet!AC24","v":0},{"$f":"Worksheet!AF24*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N24)=FALSE,Worksheet!N24,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V24,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M25)=TRUE,\"\",(IF(LEFT(Worksheet!C25,1)=\"A\",70,IF(Worksheet!E25=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F25","v":0},{"$f":"Worksheet!G25","v":0},{"$f":"Worksheet!H25","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S25+Worksheet!U25,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M25)=FALSE,Worksheet!M25,\"\")","v":""},{"$f":"Worksheet!AF25","v":0},{"$f":"Worksheet!AC25","v":0},{"$f":"Worksheet!AF25*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N25)=FALSE,Worksheet!N25,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V25,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M26)=TRUE,\"\",(IF(LEFT(Worksheet!C26,1)=\"A\",70,IF(Worksheet!E26=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F26","v":0},{"$f":"Worksheet!G26","v":0},{"$f":"Worksheet!H26","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S26+Worksheet!U26,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M26)=FALSE,Worksheet!M26,\"\")","v":""},{"$f":"Worksheet!AF26","v":0},{"$f":"Worksheet!AC26","v":0},{"$f":"Worksheet!AF26*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N26)=FALSE,Worksheet!N26,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V26,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M27)=TRUE,\"\",(IF(LEFT(Worksheet!C27,1)=\"A\",70,IF(Worksheet!E27=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F27","v":0},{"$f":"Worksheet!G27","v":0},{"$f":"Worksheet!H27","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S27+Worksheet!U27,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M27)=FALSE,Worksheet!M27,\"\")","v":""},{"$f":"Worksheet!AF27","v":0},{"$f":"Worksheet!AC27","v":0},{"$f":"Worksheet!AF27*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N27)=FALSE,Worksheet!N27,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V27,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M28)=TRUE,\"\",(IF(LEFT(Worksheet!C28,1)=\"A\",70,IF(Worksheet!E28=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F28","v":0},{"$f":"Worksheet!G28","v":0},{"$f":"Worksheet!H28","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S28+Worksheet!U28,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M28)=FALSE,Worksheet!M28,\"\")","v":""},{"$f":"Worksheet!AF28","v":0},{"$f":"Worksheet!AC28","v":0},{"$f":"Worksheet!AF28*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N28)=FALSE,Worksheet!N28,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V28,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M29)=TRUE,\"\",(IF(LEFT(Worksheet!C29,1)=\"A\",70,IF(Worksheet!E29=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F29","v":0},{"$f":"Worksheet!G29","v":0},{"$f":"Worksheet!H29","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S29+Worksheet!U29,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M29)=FALSE,Worksheet!M29,\"\")","v":""},{"$f":"Worksheet!AF29","v":0},{"$f":"Worksheet!AC29","v":0},{"$f":"Worksheet!AF29*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N29)=FALSE,Worksheet!N29,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V29,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M30)=TRUE,\"\",(IF(LEFT(Worksheet!C30,1)=\"A\",70,IF(Worksheet!E30=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F30","v":0},{"$f":"Worksheet!G30","v":0},{"$f":"Worksheet!H30","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S30+Worksheet!U30,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M30)=FALSE,Worksheet!M30,\"\")","v":""},{"$f":"Worksheet!AF30","v":0},{"$f":"Worksheet!AC30","v":0},{"$f":"Worksheet!AF30*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N30)=FALSE,Worksheet!N30,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V30,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M31)=TRUE,\"\",(IF(LEFT(Worksheet!C31,1)=\"A\",70,IF(Worksheet!E31=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F31","v":0},{"$f":"Worksheet!G31","v":0},{"$f":"Worksheet!H31","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S31+Worksheet!U31,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M31)=FALSE,Worksheet!M31,\"\")","v":""},{"$f":"Worksheet!AF31","v":0},{"$f":"Worksheet!AC31","v":0},{"$f":"Worksheet!AF31*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N31)=FALSE,Worksheet!N31,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V31,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M32)=TRUE,\"\",(IF(LEFT(Worksheet!C32,1)=\"A\",70,IF(Worksheet!E32=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F32","v":0},{"$f":"Worksheet!G32","v":0},{"$f":"Worksheet!H32","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S32+Worksheet!U32,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M32)=FALSE,Worksheet!M32,\"\")","v":""},{"$f":"Worksheet!AF32","v":0},{"$f":"Worksheet!AC32","v":0},{"$f":"Worksheet!AF32*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N32)=FALSE,Worksheet!N32,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V32,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M33)=TRUE,\"\",(IF(LEFT(Worksheet!C33,1)=\"A\",70,IF(Worksheet!E33=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F33","v":0},{"$f":"Worksheet!G33","v":0},{"$f":"Worksheet!H33","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S33+Worksheet!U33,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M33)=FALSE,Worksheet!M33,\"\")","v":""},{"$f":"Worksheet!AF33","v":0},{"$f":"Worksheet!AC33","v":0},{"$f":"Worksheet!AF33*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N33)=FALSE,Worksheet!N33,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V33,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M34)=TRUE,\"\",(IF(LEFT(Worksheet!C34,1)=\"A\",70,IF(Worksheet!E34=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F34","v":0},{"$f":"Worksheet!G34","v":0},{"$f":"Worksheet!H34","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S34+Worksheet!U34,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M34)=FALSE,Worksheet!M34,\"\")","v":""},{"$f":"Worksheet!AF34","v":0},{"$f":"Worksheet!AC34","v":0},{"$f":"Worksheet!AF34*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N34)=FALSE,Worksheet!N34,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V34,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M35)=TRUE,\"\",(IF(LEFT(Worksheet!C35,1)=\"A\",70,IF(Worksheet!E35=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F35","v":0},{"$f":"Worksheet!G35","v":0},{"$f":"Worksheet!H35","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S35+Worksheet!U35,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M35)=FALSE,Worksheet!M35,\"\")","v":""},{"$f":"Worksheet!AF35","v":0},{"$f":"Worksheet!AC35","v":0},{"$f":"Worksheet!AF35*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N35)=FALSE,Worksheet!N35,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V35,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M36)=TRUE,\"\",(IF(LEFT(Worksheet!C36,1)=\"A\",70,IF(Worksheet!E36=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F36","v":0},{"$f":"Worksheet!G36","v":0},{"$f":"Worksheet!H36","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S36+Worksheet!U36,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M36)=FALSE,Worksheet!M36,\"\")","v":""},{"$f":"Worksheet!AF36","v":0},{"$f":"Worksheet!AC36","v":0},{"$f":"Worksheet!AF36*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N36)=FALSE,Worksheet!N36,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V36,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M37)=TRUE,\"\",(IF(LEFT(Worksheet!C37,1)=\"A\",70,IF(Worksheet!E37=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F37","v":0},{"$f":"Worksheet!G37","v":0},{"$f":"Worksheet!H37","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S37+Worksheet!U37,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M37)=FALSE,Worksheet!M37,\"\")","v":""},{"$f":"Worksheet!AF37","v":0},{"$f":"Worksheet!AC37","v":0},{"$f":"Worksheet!AF37*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N37)=FALSE,Worksheet!N37,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V37,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M38)=TRUE,\"\",(IF(LEFT(Worksheet!C38,1)=\"A\",70,IF(Worksheet!E38=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F38","v":0},{"$f":"Worksheet!G38","v":0},{"$f":"Worksheet!H38","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S38+Worksheet!U38,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M38)=FALSE,Worksheet!M38,\"\")","v":""},{"$f":"Worksheet!AF38","v":0},{"$f":"Worksheet!AC38","v":0},{"$f":"Worksheet!AF38*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N38)=FALSE,Worksheet!N38,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V38,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M39)=TRUE,\"\",(IF(LEFT(Worksheet!C39,1)=\"A\",70,IF(Worksheet!E39=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F39","v":0},{"$f":"Worksheet!G39","v":0},{"$f":"Worksheet!H39","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S39+Worksheet!U39,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M39)=FALSE,Worksheet!M39,\"\")","v":""},{"$f":"Worksheet!AF39","v":0},{"$f":"Worksheet!AC39","v":0},{"$f":"Worksheet!AF39*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N39)=FALSE,Worksheet!N39,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V39,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M40)=TRUE,\"\",(IF(LEFT(Worksheet!C40,1)=\"A\",70,IF(Worksheet!E40=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F40","v":0},{"$f":"Worksheet!G40","v":0},{"$f":"Worksheet!H40","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S40+Worksheet!U40,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M40)=FALSE,Worksheet!M40,\"\")","v":""},{"$f":"Worksheet!AF40","v":0},{"$f":"Worksheet!AC40","v":0},{"$f":"Worksheet!AF40*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N40)=FALSE,Worksheet!N40,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V40,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M41)=TRUE,\"\",(IF(LEFT(Worksheet!C41,1)=\"A\",70,IF(Worksheet!E41=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F41","v":0},{"$f":"Worksheet!G41","v":0},{"$f":"Worksheet!H41","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S41+Worksheet!U41,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M41)=FALSE,Worksheet!M41,\"\")","v":""},{"$f":"Worksheet!AF41","v":0},{"$f":"Worksheet!AC41","v":0},{"$f":"Worksheet!AF41*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N41)=FALSE,Worksheet!N41,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V41,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M42)=TRUE,\"\",(IF(LEFT(Worksheet!C42,1)=\"A\",70,IF(Worksheet!E42=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F42","v":0},{"$f":"Worksheet!G42","v":0},{"$f":"Worksheet!H42","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S42+Worksheet!U42,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M42)=FALSE,Worksheet!M42,\"\")","v":""},{"$f":"Worksheet!AF42","v":0},{"$f":"Worksheet!AC42","v":0},{"$f":"Worksheet!AF42*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N42)=FALSE,Worksheet!N42,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V42,\"\")","v":0}]
[{"$f":"IF(ISBLANK(Worksheet!M43)=TRUE,\"\",(IF(LEFT(Worksheet!C43,1)=\"A\",70,IF(Worksheet!E43=\"Variable\",68,69))))","v":""},{"$f":"Worksheet!F43","v":0},{"$f":"Worksheet!G43","v":0},{"$f":"Worksheet!H43","v":0},"Tons",null,null,{"$f":"IFERROR(Worksheet!S43+Worksheet!U43,\"\")","v":0},{"$f":"IF(ISBLANK(Worksheet!M43)=FALSE,Worksheet!M43,\"\")","v":""},{"$f":"Worksheet!AF43","v":0},{"$f":"Worksheet!AC43","v":0},{"$f":"Worksheet!AF43*Worksheet!$AI$5","v":0},null,null,null,"kW/ton",null,{"$f":"IF(ISBLANK(Worksheet!N43)=FALSE,Worksheet!N43,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$D$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!V43,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[14]
["Log"]
["Updated for new Baseline Efficiencies for Protocol effective 1/1/08"]
["Updated for compatability with Measure Tracking on 12/1/2008"]
["Updated to reflect new incentive structure on 7/13/09.  Changes in red."]
["2012-01-01","no changfe for V5"]
["2012-09-20","changed IPLV/PLV columns to a efficiency type and efficiency column and lined up savings calc to protocol (now references both IPLV and FLV)"]
["2013-04-01","fixed formula in Savings per Unit column, but this shouldn't have any effect on results whatsover. Also changed the measure ID column of the export tab to reference the Efficiency Rating Type column when deciding whether to use the \"part load chiller\" or \"full load chiller\" measure ID."]
["2013-07-09","no change for V7, skipped V6"]
["2015-06-20","Worksheet and Tables Tabs updated for V9 by Aimee Lalonde, QC Mike Roberts"]
["2018-06-21","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"]