{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Worksheet","Measure Code","Lookup Table","Export","Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"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":28,"rows_kept":38,"cut":false,"hidden":false,"merged":[[7,1,7,3],[7,6,7,7],[2,1,2,4],[2,6,2,12],[6,1,6,3],[6,6,6,12],[4,1,4,4],[11,14,11,15],[10,26,10,27],[2,14,2,16],[8,19,8,20],[1,14,1,16],[4,22,4,24],[4,25,4,27],[5,22,8,24],[5,25,8,27]]}
["Refrigeration Controls Application"]
["Customer Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Committed:",null,null,{"$f":"SUM(M14:M38)","v":0}]
["Name",null,null,null,null,"Address",null,null,null,null,null,null,null,null,"Total Units Installed:",null,null,{"$f":"SUM(N14:N38)","v":0}]
["Premise",null,null,"Application",null,"Date"]
["Contact",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,null,"Address"]
["Contact",null,null,null," ","Phone"]
["Enhanced Incentive Eligibility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Type"]
[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,"Date","Inspector/Sign-off"]
[null,"Incentive amounts below are estimated based on standard program incentives. These values and any additional enhancements will be verified by the Program Manager prior to approval.",null,null,null,null,null,null,null,null,null,null,null,null,"Totals:",null,{"$f":"SUM(Q14:Q38)","v":0},0,0,0,0,0,0,0]
["Measure Code","Type\nD - Door Heater Control\nE- Electric Defrost Control\nEF - Evaporator Fan Control\nN- Novely Cooler Control\nFH - Floating Head Control\nFS - Floating Suction Control","Application","Manufacturer","Model","Nameplate kW (Door Heater/Electric Defroster Only)","Amps (Evaporator/cooler only)","Volts (Evaporator/cooler only)","Phase (Evaporator/cooler only)","System Tons\n(Floating Head/Suction Controls Only)","Refrigeration Case Temperature (Low, Medium, or High)","Hours Closed per Day\n(Novelty Cooler Shutoff Only)","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","FOUND PRE TYPE","Count","FOUND POST TYPE","count"]
[null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,MeasureCode_Lookup,2,FALSE))","v":""},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B14=\"\",0,IF(B14=\"FH\",75*J14,IF(B14=\"FS\",50*J14,IF(B14=\"EF\",75,50))))","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE)=TRUE,O14,0)","v":0},{"$f":"M14*(O14+P14)","v":0},{"$f":"N14*(O14+P14)","v":0},{"$f":"kwsavings(F14,G14,H14,I14,J14,B14,K14)*M14","v":0},{"$f":"kwsavings(F14,G14,H14,I14,J14,B14,K14)*N14","v":0},{"$f":"kWhSAvings(F14,G14,H14,I14,J14,B14,K14,L14)*M14","v":0},{"$f":"kWhSAvings(F14,G14,H14,I14,J14,B14,K14,L14)*N14","v":0},{"$f":"IF(A14=\"\",0,U14*VLOOKUP(A14,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A14=\"\",0,V14*VLOOKUP(A14,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B15=\"\",0,IF(B15=\"FH\",75*J15,IF(B15=\"FS\",50*J15,IF(B15=\"EF\",75,50))))","v":0},{"$f":"IF(OR($A$10=TRUE,$A$11=TRUE,$B$10=TRUE,$B$11=TRUE)=TRUE,O15,0)","v":0},{"$f":"M15*(O15+P15)","v":0},{"$f":"N15*(O15+P15)","v":0},{"$f":"kwsavings(F15,G15,H15,I15,J15,B15,K15)*M15","v":0},{"$f":"kwsavings(F15,G15,H15,I15,J15,B15,K15)*N15","v":0},{"$f":"kWhSAvings(F15,G15,H15,I15,J15,B15,K15,L15)*M15","v":0},{"$f":"kWhSAvings(F15,G15,H15,I15,J15,B15,K15,L15)*N15","v":0},{"$f":"IF(A15=\"\",0,U15*VLOOKUP(A15,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A15=\"\",0,V15*VLOOKUP(A15,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A16=\"\",0,U16*VLOOKUP(A16,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A16=\"\",0,V16*VLOOKUP(A16,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A17=\"\",0,U17*VLOOKUP(A17,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A17=\"\",0,V17*VLOOKUP(A17,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A18=\"\",0,U18*VLOOKUP(A18,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A18=\"\",0,V18*VLOOKUP(A18,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A19=\"\",0,U19*VLOOKUP(A19,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A19=\"\",0,V19*VLOOKUP(A19,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A20=\"\",0,U20*VLOOKUP(A20,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A20=\"\",0,V20*VLOOKUP(A20,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A21=\"\",0,U21*VLOOKUP(A21,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A21=\"\",0,V21*VLOOKUP(A21,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A22=\"\",0,U22*VLOOKUP(A22,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A22=\"\",0,V22*VLOOKUP(A22,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A23=\"\",0,U23*VLOOKUP(A23,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A23=\"\",0,V23*VLOOKUP(A23,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A24=\"\",0,U24*VLOOKUP(A24,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A24=\"\",0,V24*VLOOKUP(A24,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A25=\"\",0,U25*VLOOKUP(A25,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A25=\"\",0,V25*VLOOKUP(A25,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A26=\"\",0,U26*VLOOKUP(A26,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A26=\"\",0,V26*VLOOKUP(A26,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A27=\"\",0,U27*VLOOKUP(A27,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A27=\"\",0,V27*VLOOKUP(A27,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A28=\"\",0,U28*VLOOKUP(A28,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A28=\"\",0,V28*VLOOKUP(A28,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A29=\"\",0,U29*VLOOKUP(A29,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A29=\"\",0,V29*VLOOKUP(A29,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A30=\"\",0,U30*VLOOKUP(A30,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A30=\"\",0,V30*VLOOKUP(A30,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A31=\"\",0,U31*VLOOKUP(A31,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A31=\"\",0,V31*VLOOKUP(A31,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A32=\"\",0,U32*VLOOKUP(A32,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A32=\"\",0,V32*VLOOKUP(A32,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A33=\"\",0,U33*VLOOKUP(A33,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A33=\"\",0,V33*VLOOKUP(A33,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A34=\"\",0,U34*VLOOKUP(A34,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A34=\"\",0,V34*VLOOKUP(A34,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A35=\"\",0,U35*VLOOKUP(A35,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A35=\"\",0,V35*VLOOKUP(A35,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A36=\"\",0,U36*VLOOKUP(A36,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A36=\"\",0,V36*VLOOKUP(A36,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A37=\"\",0,U37*VLOOKUP(A37,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A37=\"\",0,V37*VLOOKUP(A37,MeasureCode_Lookup,5,FALSE))","v":0}]
[null,"",{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,MeasureCode_Lookup,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"IF(A38=\"\",0,U38*VLOOKUP(A38,MeasureCode_Lookup,5,FALSE))","v":0},{"$f":"IF(A38=\"\",0,V38*VLOOKUP(A38,MeasureCode_Lookup,5,FALSE))","v":0}]

{"sheet":"Measure Code","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Type","Description","Application","Measure Life","Measure Type"]
["RC1","D","D - Door Heater Control","N/A",12,249]
["RC2","E","E- Electric Defrost Control","N/A",10,246]
["RC3","EF","EF - Evaporator Fan Control","N/A",16,247]
["RC4","N","N- Novely Cooler Control","N/A",5,306,null,"kWh/ton",null,"kWh/ton"]
["RC5","FH","FH - Floating Head Control","Commercial Air-Cooled Refrigeration System",16,332,"MED/HIGH",926,"LOW",2376,"PA TRM"]
["RC6","FH","FH - Floating Head Control","Commercial Evap-Cooled Refrigeration System",16,332,"MED/HIGH",926,"LOW",2376,"PA TRM"]
["RC7","FH","FH - Floating Head Control","Process Evap-Cooled Refrigeration System",16,332,"MED/HIGH",926,"LOW",2376,"PA TRM"]
["RC8","FS","FS - Floating Suction Control","Commercial Refrigeration System",16,333,"MED/HIGH",139,"LOW",356,"DOE Better Buildings: Maximizing Supermarket Refrigeration System Energy Efficiency, Mitchell & Zogg"]
["RC9","FS","FS - Floating Suction Control","Process Refrigeration System",16,333,"MED/HIGH",139,"LOW",356,"DOE Better Buildings: Maximizing Supermarket Refrigeration System Energy Efficiency, Mitchell & Zogg"]

{"sheet":"Lookup Table","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["D",249]
["E",246]
["EF",247]
["N",306]
["FH",252]
["FS",253]

{"sheet":"Export","index":3,"n_rows":26,"n_cols":23,"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","Enhanced Incentive per Unit"]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B14,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D14","v":0},{"$f":"Worksheet!E14","v":0},null,null,null,null,{"$f":"Worksheet!O14","v":0},{"$f":"IF(ISBLANK(Worksheet!M14)=FALSE,Worksheet!M14,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U14/Worksheet!$M$14,Worksheet!V14/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S14/Worksheet!$M$14,Worksheet!T14/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W14/Worksheet!$M$14,Worksheet!X14/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N14)=FALSE,Worksheet!N14,\"\")","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":"IFERROR(Worksheet!P14,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B15,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D15","v":0},{"$f":"Worksheet!E15","v":0},null,null,null,null,{"$f":"Worksheet!O15","v":0},{"$f":"IF(ISBLANK(Worksheet!M15)=FALSE,Worksheet!M15,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U15/Worksheet!$M$14,Worksheet!V15/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S15/Worksheet!$M$14,Worksheet!T15/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W15/Worksheet!$M$14,Worksheet!X15/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N15)=FALSE,Worksheet!N15,\"\")","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":"IFERROR(Worksheet!P15,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B16,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D16","v":0},{"$f":"Worksheet!E16","v":0},null,null,null,null,{"$f":"Worksheet!O16","v":0},{"$f":"IF(ISBLANK(Worksheet!M16)=FALSE,Worksheet!M16,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U16/Worksheet!$M$14,Worksheet!V16/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S16/Worksheet!$M$14,Worksheet!T16/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W16/Worksheet!$M$14,Worksheet!X16/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N16)=FALSE,Worksheet!N16,\"\")","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":"IFERROR(Worksheet!P16,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B17,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D17","v":0},{"$f":"Worksheet!E17","v":0},null,null,null,null,{"$f":"Worksheet!O17","v":0},{"$f":"IF(ISBLANK(Worksheet!M17)=FALSE,Worksheet!M17,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U17/Worksheet!$M$14,Worksheet!V17/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S17/Worksheet!$M$14,Worksheet!T17/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W17/Worksheet!$M$14,Worksheet!X17/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N17)=FALSE,Worksheet!N17,\"\")","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":"IFERROR(Worksheet!P17,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B18,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D18","v":0},{"$f":"Worksheet!E18","v":0},null,null,null,null,{"$f":"Worksheet!O18","v":0},{"$f":"IF(ISBLANK(Worksheet!M18)=FALSE,Worksheet!M18,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U18/Worksheet!$M$14,Worksheet!V18/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S18/Worksheet!$M$14,Worksheet!T18/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W18/Worksheet!$M$14,Worksheet!X18/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N18)=FALSE,Worksheet!N18,\"\")","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":"IFERROR(Worksheet!P18,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B19,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D19","v":0},{"$f":"Worksheet!E19","v":0},null,null,null,null,{"$f":"Worksheet!O19","v":0},{"$f":"IF(ISBLANK(Worksheet!M19)=FALSE,Worksheet!M19,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U19/Worksheet!$M$14,Worksheet!V19/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S19/Worksheet!$M$14,Worksheet!T19/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W19/Worksheet!$M$14,Worksheet!X19/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N19)=FALSE,Worksheet!N19,\"\")","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":"IFERROR(Worksheet!P19,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B20,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D20","v":0},{"$f":"Worksheet!E20","v":0},null,null,null,null,{"$f":"Worksheet!O20","v":0},{"$f":"IF(ISBLANK(Worksheet!M20)=FALSE,Worksheet!M20,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U20/Worksheet!$M$14,Worksheet!V20/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S20/Worksheet!$M$14,Worksheet!T20/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W20/Worksheet!$M$14,Worksheet!X20/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N20)=FALSE,Worksheet!N20,\"\")","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":"IFERROR(Worksheet!P20,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B21,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D21","v":0},{"$f":"Worksheet!E21","v":0},null,null,null,null,{"$f":"Worksheet!O21","v":0},{"$f":"IF(ISBLANK(Worksheet!M21)=FALSE,Worksheet!M21,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U21/Worksheet!$M$14,Worksheet!V21/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S21/Worksheet!$M$14,Worksheet!T21/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W21/Worksheet!$M$14,Worksheet!X21/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N21)=FALSE,Worksheet!N21,\"\")","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":"IFERROR(Worksheet!P21,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B22,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D22","v":0},{"$f":"Worksheet!E22","v":0},null,null,null,null,{"$f":"Worksheet!O22","v":0},{"$f":"IF(ISBLANK(Worksheet!M22)=FALSE,Worksheet!M22,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U22/Worksheet!$M$14,Worksheet!V22/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S22/Worksheet!$M$14,Worksheet!T22/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W22/Worksheet!$M$14,Worksheet!X22/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N22)=FALSE,Worksheet!N22,\"\")","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":"IFERROR(Worksheet!P22,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B23,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D23","v":0},{"$f":"Worksheet!E23","v":0},null,null,null,null,{"$f":"Worksheet!O23","v":0},{"$f":"IF(ISBLANK(Worksheet!M23)=FALSE,Worksheet!M23,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U23/Worksheet!$M$14,Worksheet!V23/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S23/Worksheet!$M$14,Worksheet!T23/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W23/Worksheet!$M$14,Worksheet!X23/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N23)=FALSE,Worksheet!N23,\"\")","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":"IFERROR(Worksheet!P23,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B24,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D24","v":0},{"$f":"Worksheet!E24","v":0},null,null,null,null,{"$f":"Worksheet!O24","v":0},{"$f":"IF(ISBLANK(Worksheet!M24)=FALSE,Worksheet!M24,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U24/Worksheet!$M$14,Worksheet!V24/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S24/Worksheet!$M$14,Worksheet!T24/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W24/Worksheet!$M$14,Worksheet!X24/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N24)=FALSE,Worksheet!N24,\"\")","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":"IFERROR(Worksheet!P24,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B25,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D25","v":0},{"$f":"Worksheet!E25","v":0},null,null,null,null,{"$f":"Worksheet!O25","v":0},{"$f":"IF(ISBLANK(Worksheet!M25)=FALSE,Worksheet!M25,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U25/Worksheet!$M$14,Worksheet!V25/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S25/Worksheet!$M$14,Worksheet!T25/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W25/Worksheet!$M$14,Worksheet!X25/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N25)=FALSE,Worksheet!N25,\"\")","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":"IFERROR(Worksheet!P25,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B26,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D26","v":0},{"$f":"Worksheet!E26","v":0},null,null,null,null,{"$f":"Worksheet!O26","v":0},{"$f":"IF(ISBLANK(Worksheet!M26)=FALSE,Worksheet!M26,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U26/Worksheet!$M$14,Worksheet!V26/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S26/Worksheet!$M$14,Worksheet!T26/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W26/Worksheet!$M$14,Worksheet!X26/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N26)=FALSE,Worksheet!N26,\"\")","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":"IFERROR(Worksheet!P26,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B27,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D27","v":0},{"$f":"Worksheet!E27","v":0},null,null,null,null,{"$f":"Worksheet!O27","v":0},{"$f":"IF(ISBLANK(Worksheet!M27)=FALSE,Worksheet!M27,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U27/Worksheet!$M$14,Worksheet!V27/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S27/Worksheet!$M$14,Worksheet!T27/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W27/Worksheet!$M$14,Worksheet!X27/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N27)=FALSE,Worksheet!N27,\"\")","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":"IFERROR(Worksheet!P27,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B28,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D28","v":0},{"$f":"Worksheet!E28","v":0},null,null,null,null,{"$f":"Worksheet!O28","v":0},{"$f":"IF(ISBLANK(Worksheet!M28)=FALSE,Worksheet!M28,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U28/Worksheet!$M$14,Worksheet!V28/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S28/Worksheet!$M$14,Worksheet!T28/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W28/Worksheet!$M$14,Worksheet!X28/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N28)=FALSE,Worksheet!N28,\"\")","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":"IFERROR(Worksheet!P28,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B29,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D29","v":0},{"$f":"Worksheet!E29","v":0},null,null,null,null,{"$f":"Worksheet!O29","v":0},{"$f":"IF(ISBLANK(Worksheet!M29)=FALSE,Worksheet!M29,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U29/Worksheet!$M$14,Worksheet!V29/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S29/Worksheet!$M$14,Worksheet!T29/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W29/Worksheet!$M$14,Worksheet!X29/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N29)=FALSE,Worksheet!N29,\"\")","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":"IFERROR(Worksheet!P29,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B30,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D30","v":0},{"$f":"Worksheet!E30","v":0},null,null,null,null,{"$f":"Worksheet!O30","v":0},{"$f":"IF(ISBLANK(Worksheet!M30)=FALSE,Worksheet!M30,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U30/Worksheet!$M$14,Worksheet!V30/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S30/Worksheet!$M$14,Worksheet!T30/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W30/Worksheet!$M$14,Worksheet!X30/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N30)=FALSE,Worksheet!N30,\"\")","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":"IFERROR(Worksheet!P30,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B31,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D31","v":0},{"$f":"Worksheet!E31","v":0},null,null,null,null,{"$f":"Worksheet!O31","v":0},{"$f":"IF(ISBLANK(Worksheet!M31)=FALSE,Worksheet!M31,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U31/Worksheet!$M$14,Worksheet!V31/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S31/Worksheet!$M$14,Worksheet!T31/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W31/Worksheet!$M$14,Worksheet!X31/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N31)=FALSE,Worksheet!N31,\"\")","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":"IFERROR(Worksheet!P31,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B32,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D32","v":0},{"$f":"Worksheet!E32","v":0},null,null,null,null,{"$f":"Worksheet!O32","v":0},{"$f":"IF(ISBLANK(Worksheet!M32)=FALSE,Worksheet!M32,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U32/Worksheet!$M$14,Worksheet!V32/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S32/Worksheet!$M$14,Worksheet!T32/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W32/Worksheet!$M$14,Worksheet!X32/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N32)=FALSE,Worksheet!N32,\"\")","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":"IFERROR(Worksheet!P32,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B33,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D33","v":0},{"$f":"Worksheet!E33","v":0},null,null,null,null,{"$f":"Worksheet!O33","v":0},{"$f":"IF(ISBLANK(Worksheet!M33)=FALSE,Worksheet!M33,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U33/Worksheet!$M$14,Worksheet!V33/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S33/Worksheet!$M$14,Worksheet!T33/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W33/Worksheet!$M$14,Worksheet!X33/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N33)=FALSE,Worksheet!N33,\"\")","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":"IFERROR(Worksheet!P33,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B34,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D34","v":0},{"$f":"Worksheet!E34","v":0},null,null,null,null,{"$f":"Worksheet!O34","v":0},{"$f":"IF(ISBLANK(Worksheet!M34)=FALSE,Worksheet!M34,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U34/Worksheet!$M$14,Worksheet!V34/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S34/Worksheet!$M$14,Worksheet!T34/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W34/Worksheet!$M$14,Worksheet!X34/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N34)=FALSE,Worksheet!N34,\"\")","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":"IFERROR(Worksheet!P34,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B35,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D35","v":0},{"$f":"Worksheet!E35","v":0},null,null,null,null,{"$f":"Worksheet!O35","v":0},{"$f":"IF(ISBLANK(Worksheet!M35)=FALSE,Worksheet!M35,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U35/Worksheet!$M$14,Worksheet!V35/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S35/Worksheet!$M$14,Worksheet!T35/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W35/Worksheet!$M$14,Worksheet!X35/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N35)=FALSE,Worksheet!N35,\"\")","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":"IFERROR(Worksheet!P35,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B36,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D36","v":0},{"$f":"Worksheet!E36","v":0},null,null,null,null,{"$f":"Worksheet!O36","v":0},{"$f":"IF(ISBLANK(Worksheet!M36)=FALSE,Worksheet!M36,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U36/Worksheet!$M$14,Worksheet!V36/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S36/Worksheet!$M$14,Worksheet!T36/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W36/Worksheet!$M$14,Worksheet!X36/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N36)=FALSE,Worksheet!N36,\"\")","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":"IFERROR(Worksheet!P36,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B37,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D37","v":0},{"$f":"Worksheet!E37","v":0},null,null,null,null,{"$f":"Worksheet!O37","v":0},{"$f":"IF(ISBLANK(Worksheet!M37)=FALSE,Worksheet!M37,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U37/Worksheet!$M$14,Worksheet!V37/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S37/Worksheet!$M$14,Worksheet!T37/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W37/Worksheet!$M$14,Worksheet!X37/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N37)=FALSE,Worksheet!N37,\"\")","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":"IFERROR(Worksheet!P37,\"\")","v":0}]
[{"$f":"IFERROR(VLOOKUP(Worksheet!B38,'Lookup Table'!$A$1:$B$6,2,FALSE),\"\")","v":""},{"$f":"Worksheet!D38","v":0},{"$f":"Worksheet!E38","v":0},null,null,null,null,{"$f":"Worksheet!O38","v":0},{"$f":"IF(ISBLANK(Worksheet!M38)=FALSE,Worksheet!M38,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!U38/Worksheet!$M$14,Worksheet!V38/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!S38/Worksheet!$M$14,Worksheet!T38/Worksheet!$N$14),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!$M$14)=FALSE,Worksheet!W38/Worksheet!$M$14,Worksheet!X38/Worksheet!$N$14),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Worksheet!N38)=FALSE,Worksheet!N38,\"\")","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":"IFERROR(Worksheet!P38,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[13]
["Log"]
["2012-01-13","no changes for 2012, V5"]
["2013-07-09","no change for V7, skipped V6"]
["2018-06-26","Updated to align with FY19 Protocols"]
["2019-07-01","Added Enhanced Incentive Eligibility Section and Updated for FY20 Program"]