{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Setup","Lists","Weigh-In","Lifting","DATA","ContestResults","QuickPrint","LoadingChart","Awards"],"not_rendered":{"charts":1,"images":24,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Setup","index":0,"n_rows":26,"n_cols":23,"rows_kept":26,"cut":false,"hidden":false,"merged":[[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[28,2,28,4],[2,1,3,5],[6,1,7,5],[10,2,10,4],[11,2,11,4],[2,14,3,17],[4,15,4,17],[5,15,5,17],[6,15,6,17],[2,7,3,9],[2,12,3,12],[2,10,3,11],[20,7,21,7],[20,10,21,10],[20,8,21,9],[20,11,21,12],[11,15,11,17],[12,15,12,17],[15,15,15,17],[16,15,16,17],[19,7,19,8],[23,10,24,12],[25,10,26,12],[7,15,7,17],[8,15,8,17],[9,15,9,17],[10,15,10,17],[19,15,19,17],[20,15,20,17],[13,15,13,17],[14,15,14,17],[17,15,17,17],[18,15,18,17],[21,15,21,17],[22,15,22,17],[19,10,19,11],[28,15,28,17],[23,15,23,17],[24,15,24,17],[25,15,25,17],[26,15,26,17],[27,15,27,17],[23,7,24,9],[25,7,26,9],[29,2,29,4],[30,2,30,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(B7,W2:W6,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Powerlifting (3 lift meet)"]
[null,"Enter Meet Name Here",null,null,null,null,null,"Platform Weights",null,null,"Platform Weight Set",null,"Kg",null,"Teams",null,null,null,null,null,null,null,"Bench Press Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squat Only"]
[null,null,null,null,null,null,null,null,{"$f":"M3","v":"Kg"},null,null,{"$f":"M3","v":"Kg"},null,null,"Abrev","Team Name",null,null,null,null,null,null,"Deadlift Only"]
[null,null,null,null,null,null,null,null,{"$f":"ABS(Lifting!C2)","v":0},{"$f":"2*(J9*I9+J10*I10+J11*I11+J12*I12+J13*I13+J14*I14+J15*I15+J16*I16+J17*I17+J18*I18+J19*I19)+55","v":55},null,{"$f":"I6","v":0},{"$f":"2*(M9*L9+M10*L10+M11*L11+M12*L12+M13*L13+M14*L14+M15*L15+M16*L16+M17*L17+M18*L18+M19*L19)+25","v":25},null,null,null,null,null,null,null,null,null,"Push Pull (Bench & Deadlift)"]
[null,"Select Type of Meet from List",null,null,null,null,null,"How","Pound","LOAD","How","Kilo","LOAD"]
[null,null,null,null,null,null,null,"Many?","Plates","on Bar","Many?","Plates","on Bar"]
[null,null,null,null,null,null,null,0,110,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20)/(2*I9)),H9/2))","v":0},0,50,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20)/(2*L9)),K9/2))","v":0}]
[null,null,null,null,null,null,null,6,100,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9)/(2*I10)),H10/2))","v":0},0,45,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9)/(2*L10)),K10/2))","v":0}]
[null,"M/F-Div","Description",null,null,"Pl Code",null,0,50,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9-2*J10*I10)/(2*I11)),H11/2))","v":0},12,25,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9-2*M10*L10)/(2*L11)),K11/2))","v":0}]
[null,"M-BL","Best Lifter Men",null,null,2,null,4,45,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9-2*J10*I10-2*J11*I11)/(2*I12)),H12/2))","v":0},2,20,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9-2*M10*L10-2*M11*L11)/(2*L12)),K12/2))","v":0}]
[null,"F-BL","Best Lifter Women",null,null,2,null,4,35,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9-2*J10*I10-2*J11*I11-2*J12*I12)/(2*I13)),H13/2))","v":0},2,15,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9-2*M10*L10-2*M11*L11-2*M12*L12)/(2*L13)),K13/2))","v":0}]
[null,"M-O","Mens Open",null,null,1,null,2,25,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9-2*J10*I10-2*J11*I11-2*J12*I12-2*J13*I13)/(2*I14)),H14/2))","v":0},2,10,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9-2*M10*L10-2*M11*L11-2*M12*L12-2*M13*L13)/(2*L14)),K14/2))","v":0}]
[null,"F-O","Womens Open",null,null,1,null,4,10,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9-2*J10*I10-2*J11*I11-2*J12*I12-2*J13*I13-2*J14*I14)/(2*I15)),H15/2))","v":0},2,5,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9-2*M10*L10-2*M11*L11-2*M12*L12-2*M13*L13-2*M14*L14)/(2*L15)),K15/2))","v":0}]
[null,null,null,null,null,null,null,2,5,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9-2*J10*I10-2*J11*I11-2*J12*I12-2*J13*I13-2*J14*I14-2*J15*I15)/(2*I16)),H16/2))","v":0},2,2.5,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9-2*M10*L10-2*M11*L11-2*M12*L12-2*M13*L13-2*M14*L14-2*M15*L15)/(2*L16)),K16/2))","v":0}]
[null,null,null,null,null,null,null,2,2.5,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9-2*J10*I10-2*J11*I11-2*J12*I12-2*J13*I13-2*J14*I14-2*J15*I15-2*J16*I16)/(2*I17)),H17/2))","v":0},2,1.25,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9-2*M10*L10-2*M11*L11-2*M12*L12-2*M13*L13-2*M14*L14-2*M15*L15-2*M16*L16)/(2*L17)),K17/2))","v":0}]
[null,null,null,null,null,null,null,0,1,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9-2*J10*I10-2*J11*I11-2*J12*I12-2*J13*I13-2*J14*I14-2*J15*I15-2*J16*I16-2*J17*I17)/(2*I18)),H18/2))","v":0},4,0.5,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9-2*M10*L10-2*M11*L11-2*M12*L12-2*M13*L13-2*M14*L14-2*M15*L15-2*M16*L16-2*M17*L17)/(2*L18)),K18/2))","v":0}]
[null,null,null,null,null,null,null,0,0.5,{"$f":"IF(OR(I6<J20,I5=\"Kg\"),0,MIN(INT((I6-J20-2*J9*I9-2*J10*I10-2*J11*I11-2*J12*I12-2*J13*I13-2*J14*I14-2*J15*I15-2*J16*I16-2*J17*I17-2*J18*I18)/(2*I19)),H19/2))","v":0},4,0.25,{"$f":"IF(OR(I6<M20,L5=\"Lb\"),0,MIN(INT((L6-M20-2*M9*L9-2*M10*L10-2*M11*L11-2*M12*L12-2*M13*L13-2*M14*L14-2*M15*L15-2*M16*L16-2*M17*L17-2*M18*L18)/(2*L19)),K19/2))","v":0}]
[null,null,null,null,null,null,null,"bar & collars",null,55,"bar & collars",null,25]
[null,null,null,null,null,null,null,{"$f":"H9*I9+H10*I10+H11*I11+H12*I12+H13*I13+H14*I14+H15*I15+H16*I16+H17*I17+H18*I18+H19*I19+55","v":1080},"Lbs Available on the Platform",null,{"$f":"K9*L9+K10*L10+K11*L11+K12*L12+K13*L13+K14*L14+K15*L15+K16*L16+K17*L17+K18*L18+K19*L19+25","v":435.5},"Kilos Available on the Platform"]
[]
[]
[null,null,null,null,null,null,null,"Min. Attempt Increment",null,null,"Print Loading Chart?"]
[]
[null,null,null,null,null,null,null,1,null,null,"Color"]

{"sheet":"Lists","index":1,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Attempts",null,"col",null,{"$f":"MATCH(Setup!B7,Lists!F1:J1,0)","v":{"$error":"#N/A"}},"Powerlifting (3 lift meet)","Squat Only","Bench Press Only","Deadlift Only","Push Pull (Bench & Deadlift)",null,null,null,null,"Barload for Next Lifter"]
["Squat 1","SQ-1",12,null,{"$f":"OFFSET(E2,0,$E$1)","v":{"$error":"#N/A"}},"Squat 1","Squat 1","Bench Press 1","Deadlift 1","Bench Press 1",null,null,null,null,null,{"$f":"Setup!I5","v":"Kg"}]
["Squat 2","SQ-2",13,null,{"$f":"OFFSET(E3,0,$E$1)","v":{"$error":"#N/A"}},"Squat 2","Squat 2","Bench Press 2","Deadlift 2","Bench Press 2",null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(Lifting!AY5+1,Lifting!BD4,,,\"Lifting\"))","v":{"$error":"#N/A"}},{"$f":"2*(Q6*P6+Q7*P7+Q8*P8+Q9*P9+Q10*P10+Q11*P11+Q12*P12+Q13*P13+Q14*P14+Q15*P15+Q16*P16)+Q35","v":{"$error":"#N/A"}}]
["Squat 3","SQ-3",14,null,{"$error":"#N/A"},"Squat 3","Squat 3","Bench Press 3","Deadlift 3","Bench Press 3",null,null,null,null,"How","Pound","LOAD"]
["Bench Press 1","BP-1",17,null,{"$error":"#N/A"},"Bench Press 1","New Lifter","New Lifter","New Lifter","Deadlift 1",null,null,null,null,"Many?","Plates","on Bar"]
["Bench Press 2","BP-2",18,null,{"$error":"#N/A"},"Bench Press 2",null,null,null,"Deadlift 2",null,null,null,null,{"$f":"Setup!H9","v":0},110,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35)/(2*P6)),O6/2))","v":{"$error":"#N/A"}},{"$f":"IF(Q6=0,\"\",IF(Q6>1,CONCATENATE(Q6,\"/\",P6,\" \"),CONCATENATE(P6,\" \")))","v":{"$error":"#N/A"}}]
["Bench Press 3","BP-3",19,null,{"$error":"#N/A"},"Bench Press 3",null,null,null,"Deadlift 3",null,null,null,null,{"$f":"Setup!H10","v":6},100,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6)/(2*P7)),O7/2))","v":{"$error":"#N/A"}},{"$f":"IF(Q7=0,\"\",IF(Q7>1,CONCATENATE(Q7,\"/\",P7,\" \"),CONCATENATE(P7,\" \")))","v":{"$error":"#N/A"}}]
["Deadlift 1","DL-1",22,null,{"$error":"#N/A"},"Deadlift 1",null,null,null,"New Lifter",null,null,null,null,{"$f":"Setup!H11","v":0},55,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6-2*Q7*P7)/(2*P8)),O8/2))","v":{"$error":"#N/A"}},{"$f":"IF(Q8=0,\"\",IF(Q8>1,CONCATENATE(Q8,\"/\",P8,\" \"),CONCATENATE(P8,\" \")))","v":{"$error":"#N/A"}}]
["Deadlift 2","DL-2",23,null,{"$error":"#N/A"},"Deadlift 2",null,null,null,null,null,null,null,null,{"$f":"Setup!H12","v":4},45,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6-2*Q7*P7-2*Q8*P8)/(2*P9)),O9/2))","v":{"$error":"#N/A"}},{"$f":"IF(Q9=0,\"\",IF(Q9>1,CONCATENATE(Q9,\"/\",P9,\" \"),CONCATENATE(P9,\" \")))","v":{"$error":"#N/A"}}]
["Deadlift 3","DL-3",24,null,{"$error":"#N/A"},"Deadlift 3",null,null,null,null,null,null,null,null,{"$f":"Setup!H13","v":4},35,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6-2*Q7*P7-2*Q8*P8-2*Q9*P9)/(2*P10)),O10/2))","v":{"$error":"#N/A"}},{"$f":"IF(Q10=0,\"\",IF(Q10>1,CONCATENATE(P10,\"/\",Q10,\" \"),CONCATENATE(P10,\" \")))","v":{"$error":"#N/A"}}]
["New Lifter",null,null,null,{"$error":"#N/A"},"New Lifter",null,null,null,null,null,null,null,null,{"$f":"Setup!H14","v":2},25,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6-2*Q7*P7-2*Q8*P8-2*Q9*P9-2*Q10*P10)/(2*P11)),O11/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Setup!H15","v":4},10,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6-2*Q7*P7-2*Q8*P8-2*Q9*P9-2*Q10*P10-2*Q11*P11)/(2*P12)),O12/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Setup!H16","v":2},5,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6-2*Q7*P7-2*Q8*P8-2*Q9*P9-2*Q10*P10-2*Q11*P11-2*Q12*P12)/(2*P13)),O13/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
["weightclass lookup",{"$f":"'Weigh-In'!E2","v":"Bwt (kg)"},null,null,null,null,null,null,"weightclass rank",null,null,null,null,null,{"$f":"Setup!H17","v":2},2.5,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6-2*Q7*P7-2*Q8*P8-2*Q9*P9-2*Q10*P10-2*Q11*P11-2*Q12*P12-2*Q13*P13)/(2*P14)),O14/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,"YOUTH","OPEN","YOUTH","OPEN",null,null,null,null,null,null,null,null,{"$f":"Setup!H18","v":0},1.25,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6-2*Q7*P7-2*Q8*P8-2*Q9*P9-2*Q10*P10-2*Q11*P11-2*Q12*P12-2*Q13*P13-2*Q14*P14)/(2*P15)),O15/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
["men's classes",25,{"$f":"IF($B$14=\"Bwt (lb)\",G16,E16)","v":56},{"$f":"IF($B$14=\"Bwt (lb)\",G17,F16)","v":62},56,62,123,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K16,J16)","v":"120+"},"120+","264+",null,null,null,{"$f":"Setup!H19","v":0},0.5,{"$f":"IF(OR(P3<Q35,P2=\"Kg\"),0,MIN(INT((P3-Q35-2*Q6*P6-2*Q7*P7-2*Q8*P8-2*Q9*P9-2*Q10*P10-2*Q11*P11-2*Q12*P12-2*Q13*P13-2*Q14*P14-2*Q15*P15)/(2*P16)),O16/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,56.000999999999998,{"$f":"IF($B$14=\"Bwt (lb)\",G17,E17)","v":62},{"$f":"IF($B$14=\"Bwt (lb)\",G17,F17)","v":62},62,62,136,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K17,J17)","v":120},120,264,null,null,null,null,{"$f":"P2","v":"Kg"}]
[null,62.000999999999998,69,69,69,69,152,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K18,J18)","v":"105+"},"105+","231+",null,null,null,null,{"$f":"P3","v":{"$error":"#N/A"}},{"$f":"2*(Q21*P21+Q22*P22+Q23*P23+Q24*P24+Q25*P25+Q26*P26+Q27*P27+Q28*P28+Q29*P29+Q30*P30+Q31*P31)+Q36","v":{"$error":"#N/A"}}]
[null,69.001000000000005,77,77,77,77,169,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K19,J19)","v":105},105,231,null,null,null,"How","Kilo","LOAD"]
[null,77.001000000000005,85,85,85,85,187,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K20,J20)","v":"100+"},"100+","220+",null,null,null,"Many?","Plates","on Bar"]
[null,85.001000000000005,94,94,94,94,207,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K21,J21)","v":100},100,220,null,null,null,{"$f":"Setup!K9","v":0},50,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36)/(2*P21)),O21/2))","v":{"$error":"#N/A"}},{"$f":"IF(Q21=0,\"\",IF(Q21>1,CONCATENATE(Q21,\"/\",P21,\" \"),CONCATENATE(P21,\" \")))","v":{"$error":"#N/A"}}]
[null,94.001000000000005,105,105,105,105,231,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K22,J22)","v":94},94,207,null,null,null,{"$f":"Setup!K10","v":0},45,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21)/(2*P22)),O22/2))","v":{"$error":"#N/A"}},{"$f":"IF(Q22=0,\"\",IF(Q22>1,CONCATENATE(Q22,\"/\",P22,\" \"),CONCATENATE(P22,\" \")))","v":{"$error":"#N/A"}}]
[null,105.001,{"$f":"IF($B$14=\"Bwt (lb)\",\"231+\",E23)","v":"105+"},120,"105+",120,264,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K23,J23)","v":85},85,187,null,null,null,{"$f":"Setup!K11","v":12},25,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21-2*Q22*P22)/(2*P23)),O23/2))","v":{"$error":"#N/A"}},{"$f":"IF(Q23=0,\"\",IF(Q23>1,CONCATENATE(Q23,\"/\",P23,\" \"),CONCATENATE(P23,\" \")))","v":{"$error":"#N/A"}}]
[null,120.001,{"$f":"IF($B$14=\"Bwt (lb)\",\"231+\",E24)","v":"105+"},"120+","105+","120+","264+",null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K24,J24)","v":"84+"},"84+","185+",null,null,null,{"$f":"Setup!K12","v":2},20,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21-2*Q22*P22-2*Q23*P23)/(2*P24)),O24/2))","v":{"$error":"#N/A"}},{"$f":"IF(Q24=0,\"\",IF(Q24>1,CONCATENATE(P24,\"/\",Q24,\" \"),CONCATENATE(P24,\" \")))","v":{"$error":"#N/A"}}]
[null,null,"YOUTH","OPEN","YOUTH","OPEN",null,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K25,J25)","v":84},84,185,null,null,null,{"$f":"Setup!K13","v":2},15,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21-2*Q22*P22-2*Q23*P23-2*Q24*P24)/(2*P25)),O25/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
["women's classes",25,{"$f":"IF($B$14=\"Bwt (lb)\",G26,E26)","v":44},{"$f":"IF($B$14=\"Bwt (lb)\",G27,F26)","v":48},44,48,94,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K26,J26)","v":77},77,169,null,null,null,{"$f":"Setup!K14","v":2},10,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21-2*Q22*P22-2*Q23*P23-2*Q24*P24-2*Q25*P25)/(2*P26)),O26/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,44.000999999999998,48,{"$f":"IF($B$14=\"Bwt (lb)\",G27,F27)","v":48},48,48,103,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K27,J27)","v":72},72,158,null,null,null,{"$f":"Setup!K15","v":2},5,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21-2*Q22*P22-2*Q23*P23-2*Q24*P24-2*Q25*P25-2*Q26*P26)/(2*P27)),O27/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,48.000999999999998,53,53,53,53,114,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K28,J28)","v":69},69,152,null,null,null,{"$f":"Setup!K16","v":2},2.5,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21-2*Q22*P22-2*Q23*P23-2*Q24*P24-2*Q25*P25-2*Q26*P26-2*Q27*P27)/(2*P28)),O28/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,53.000999999999998,58,58,58,58,125,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K29,J29)","v":64},64,141,null,null,null,{"$f":"Setup!K17","v":2},1.25,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21-2*Q22*P22-2*Q23*P23-2*Q24*P24-2*Q25*P25-2*Q26*P26-2*Q27*P27-2*Q28*P28)/(2*P29)),O29/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,58.000999999999998,64,64,64,64,138,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K30,J30)","v":62},62,136,null,null,null,{"$f":"Setup!K18","v":4},0.5,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21-2*Q22*P22-2*Q23*P23-2*Q24*P24-2*Q25*P25-2*Q26*P26-2*Q27*P27-2*Q28*P28-2*Q29*P29)/(2*P30)),O30/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,64.001000000000005,72,72,72,72,158,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K31,J31)","v":58},58,127,null,null,null,{"$f":"Setup!K19","v":4},0.25,{"$f":"IF(OR(P3<Q36,P17=\"Lb\"),0,MIN(INT((P18-Q36-2*Q21*P21-2*Q22*P22-2*Q23*P23-2*Q24*P24-2*Q25*P25-2*Q26*P26-2*Q27*P27-2*Q28*P28-2*Q29*P29-2*Q30*P30)/(2*P31)),O31/2))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,72.001000000000005,84,84,84,84,185,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K32,J32)","v":56},56,123]
[null,84.001000000000005,{"$f":"IF($B$14=\"Bwt (lb)\",\"185+\",E33)","v":"84+"},100,"84+",100,220,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K33,J33)","v":53},53,116]
[null,100.001,{"$f":"IF($B$14=\"Bwt (lb)\",\"185+\",E34)","v":"84+"},"100+","84+","100+","220+",null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K34,J34)","v":48},48,105]
[null,null,null,null,null,null,null,null,{"$f":"IF('Weigh-In'!$E$2=\"Bwt (lb)\",K35,J35)","v":44},44,97,null,null,null,"bar & collars - lbs",null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bar & collars - kg",null,25]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lifting!AY5=Lifting!BA6,\"\",CONCATENATE(\"Next Barload \",R6,R7,R8,R9,R10,R11,R12,R13,R14,R15,R16,R21,R22,R23,R24,R25,R26,R27,R28,R29,R30,R31))","v":{"$error":"#N/A"}}]

{"sheet":"Weigh-In","index":2,"n_rows":2,"n_cols":60,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Grp","Name","Team","Div","Bwt (kg)","lot#","Age","SQ rack",{"$f":"CONCATENATE(\"SQ-1 (\",Setup!M3,\")\")","v":"SQ-1 (Kg)"},"BP rack",{"$f":"CONCATENATE(\"BP-1 (\",Setup!M3,\")\")","v":"BP-1 (Kg)"},{"$f":"CONCATENATE(\"DL-1 (\",Setup!M3,\")\")","v":"DL-1 (Kg)"},"Events Entered",null,null,{"$f":"Setup!M3","v":"Kg"},{"$f":"COUNTA(E:E)+1","v":2},{"$f":"CONCATENATE(\"Setup!B12:B\",COUNTA(Setup!B:B)+8)","v":"Setup!B12:B15"},{"$f":"CONCATENATE(\"Setup!O6:O\",COUNTA(Setup!O:O)+3)","v":"Setup!O6:O5"},null,null,null,null,null,null,11,{"$f":"COUNTA(E:E)+1","v":2},null,null,null,null,null,null,null,null,"flight sort data","att sort data",null,null,null,null,null,null,null,null,null,"SQ-1","SQ-2","SQ-3","Best SQ Att","BP rack","BP-1","BP-2","BP-3","Best BP Att","Sub Total","DL-1","DL-2","DL-3","Best DL Att"]

{"sheet":"Lifting","index":3,"n_rows":8,"n_cols":79,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,5,3,6],[0,0,0,5],[1,2,2,3],[1,4,2,4],[1,5,1,6],[2,5,2,6],[4,0,4,1],[2,0,2,1],[3,0,3,1],[1,0,1,1],[3,2,3,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Lists!E2:E\",IF(Lists!E1=1,11,IF(OR(Lists!E1=4,Lists!E1=3,Lists!E1=2),5,8)))","v":{"$error":"#N/A"}},null,null,{"$f":"COUNTIF(AU:AU,1)","v":0},null,null,null,null,"A","B","C","D","E","F","G","H",null,null,null,1]
[{"$f":"IFERROR(CONCATENATE(INDIRECT(ADDRESS(AY5,6)),\" kg cls\"),\"\")","v":""},null,{"$f":"IFERROR(INDIRECT(AY4),0)","v":0},null,{"$f":"Setup!M3","v":"Kg"},{"$f":"IFERROR(ROUND(IF(E2=\"kg\",C2*2.2046,C2/2.2046),1),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"B9:B\",BA6)","v":"B9:B8"},"(1) PL Total","PL",null,null,null,null,null,{"$f":"IF(BA1=RIGHT($A$7,1),0,BH2+1)","v":0},{"$f":"IF(BB1=RIGHT($A$7,1),0,BA2+1)","v":1},2,3,4,5,6,7,null,null,null,1]
[{"$f":"IFERROR(INDIRECT(CONCATENATE(\"Setup!C\",MATCH(INDIRECT(ADDRESS(AY5,4)),Setup!B:B,0))),\"\")","v":""},null,null,null,null,{"$f":"IF(E2=\"Kg\",\"Pounds\", \"Kilograms\")","v":"Pounds"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Setup!B12:B\",COUNTA(Setup!B:B)+8)","v":"Setup!B12:B15"},"(1) Best SQ","SQ","Good/no lift",null,null,"Attempt cell",null,"1st flight","sort data",null,"attempt column","New att flight","Lifting range","next flight",null,null,null,null,1]
[{"$f":"OFFSET(Setup!P1,MATCH(INDIRECT(ADDRESS(AY5,3)),Setup!O:O,0)-1,0)","v":{"$error":"#N/A"}},null,"Squat 1",null,null,{"$f":"IFERROR(CONCATENATE(IF(BD4<20,\"Rack = \",\"Total = \"),INDIRECT(ADDRESS(AY5,IF(LEFT(C4,1)=\"S\",11,IF(LEFT(C4,1)=\"B\",16,26))))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Setup!O6:O\",COUNTA(Setup!O:O)+3)","v":"Setup!O6:O5"},"(1) Best BP","BP","sort on",null,null,{"$f":"ADDRESS(MATCH(A1,INDIRECT(AS2),0)+8,BD4)","v":{"$error":"#N/A"}},null,{"$f":"CONCATENATE(\"B\",$BA$5,\":\",\"B\",BA6)","v":"B9:B8"},14,"column",{"$f":"OFFSET(Lists!C1,MATCH(C4,Attempts,0),0)","v":12},"A",{"$f":"CONCATENATE(\"$A$\",BF5,\":$A$\",BF6)","v":"$A$9:$A$8"},{"$f":"IF(C4=\"Squat 3\",17,22)","v":22},null,null,null,null,1]
["QuickPrint     Results",null,null,null,null,"Next Lifter","Auto",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(AY5,36))","v":{"$error":"#N/A"}},null,null,null,null,null,null,"(1) Best DL","DL",null,"WtCls",275,{"$f":"MATCH(A1,INDIRECT(AS2),0)+8","v":{"$error":"#N/A"}},"A",9,9,"start row",{"$f":"IF(BD4<20,IF(BD4<15,15,20),25)","v":15},{"$f":"MATCH($BE$4,INDIRECT(BF4),0)+8","v":{"$error":"#N/A"}},9,{"$f":"BB6+1","v":18},null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()-TODAY()","v":0.79905833333032206}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) PP Total","PP",{"$f":"CONCATENATE(\"AV9:AV\",BF6)","v":"AV9:AV8"},"Div","M-O",null,null,{"$f":"COUNTIF(INDIRECT(BF4),AZ5)+8","v":8},17,"end row",{"$f":"MATCH(A1,INDIRECT(AS2),0)+8","v":{"$error":"#N/A"}},{"$f":"COUNTIF(INDIRECT(BF4),BE4)+BE5-1","v":{"$error":"#N/A"}},{"$f":"COUNTA($BL:$BL)","v":8},{"$f":"COUNTIF(A:A,INDIRECT(ADDRESS(BG5,1)))+BG5-1","v":17},null,null,null,null,1]
["Grp A","Name","Team","Div",{"$f":"'Weigh-In'!E2","v":"Bwt (kg)"},{"$f":"IF(E7=\"Bwt (lb)\",\"WtCls (lb)\",\"WtCls (kg)\")","v":"WtCls (kg)"},"lot#","Wilks Coeff","Age","Age Coeff","SQ rack","SQ-1","SQ-2","SQ-3","Best SQ","BP rack","BP-1","BP-2","BP-3","Best BP","Sub Total","DL-1","DL-2","DL-3","Best DL","(1) PL Total","(2)          Wilks Pts","(3)       Age-Wilks","Pl Code","Pl-Div-WtCls-Evt","Events Entered",null,1,"Scoring value","ABS rank","Div & Cls Wt","Div & Cls Wt Rank","Place",null,"Event rank","bwt","Bwt rank","time rank",null,null,null,{"$f":"OFFSET(AU1,MATCH(Z7,AT2:AT6,0),0)","v":"PL"},null,null,null,null,null,"flight sort priority","att sort data",null,null,null,null,null,null,null,null,null,"SQ-1","SQ-2","SQ-3","Best SQ Att","BP rack","BP-1","BP-2","BP-3","Best BP Att","Sub Total","DL-1","DL-2","DL-3","Best DL Att","last good attempt","last lift"]
[null,"NAME",null,null,0,{"$f":"IF(LEFT(D8,1)=\"M\",VLOOKUP(IF($E$7=\"Bwt (kg)\",E8,E8/2.2046),Lists!$B$16:$D$24,IF(ISERROR(FIND(\"Y\",D8)),3,2)),VLOOKUP(IF($E$7=\"Bwt (kg)\",E8,E8/2.2046),Lists!$B$26:$D$34,IF(ISERROR(FIND(\"Y\",D8)),3,2)))","v":{"$error":"#N/A"}},0,{"$f":"IF(AND(VALUE(E8)>0,OR(LEFT(D8,1)=\"M\",LEFT(D8,1)=\"F\")),IF(LEFT(D8,1)=\"M\",Wilks2_Men(IF(RIGHT($F$7,4)=\"(lb)\",E8/2.2046,E8)),Wilks2_Women(IF(RIGHT($F$7,4)=\"(lb)\",E8/2.2046,E8))),0)","v":0},0,{"$f":"IF(I8,VLOOKUP(I8,DATA!$A$2:$B$53,2,TRUE),0)","v":0},null,0,null,null,{"$f":"IF(MAX(BL8:BN8)>0,MAX(ABS(L8)*BL8,ABS(M8)*BM8,ABS(N8)*BN8),0)","v":0},null,0,null,null,{"$f":"IF(MAX(BQ8:BS8)>0,MAX(ABS(Q8)*BQ8,ABS(R8)*BR8,ABS(S8)*BS8),0)","v":0},{"$f":"IF(OR(O8=0,T8=0),0,_xlfn.FLOOR.MATH(O8,Setup!$H$26)+_xlfn.FLOOR.MATH(T8,Setup!$H$26))","v":0},0,null,null,{"$f":"IF(MAX(BV8:BX8)>0,MAX(ABS(V8)*BV8,ABS(W8)*BW8,ABS(X8)*BX8),0)","v":0},{"$f":"AU8*IF($AU$7=\"SQ\",_xlfn.FLOOR.MATH(O8,Setup!$H$26),IF($AU$7=\"BP\",_xlfn.FLOOR.MATH(T8,Setup!$H$26),IF($AU$7=\"DL\",_xlfn.FLOOR.MATH(Y8,Setup!$H$26),IF($AU$7=\"PP\",IF(OR(T8=0,Y8=0),0,_xlfn.FLOOR.MATH(T8,Setup!$H$26)+_xlfn.FLOOR.MATH(Y8,Setup!$H$26)),IF(OR($U8=0,$Y8=0),0,_xlfn.FLOOR.MATH($O8,Setup!$H$26)+_xlfn.FLOOR.MATH($T8,Setup!$H$26)+_xlfn.FLOOR.MATH($Y8,Setup!$H$26))))))","v":0},{"$f":"IF($E$2=\"Lb\",Z8*H8/2.2046,Z8*H8)","v":0},{"$f":"IF(AND(I8>23,I8<40),0,AA8*J8)","v":0},{"$f":"OFFSET(Setup!$F$1,MATCH(D8,Setup!B:B,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"IF(OR(Z8=0,AU8=0,AH8=0),\"\",CONCATENATE(AL8,\"-\",D8,IF(AC8>1,\"\",\"-\"),IF(AC8>1,\"\",F8),\"-\",$AU$7))","v":""},null,null,null,{"$f":"AU8*(IF(OR(D8=\"\",E8=\"\"),0,MATCH(D8,Setup!B:B,0)*100000000+IF(AC8=1,(MATCH(F8,Lists!$I$16:$I$35,0)),0)*1000000+IF(Z8=0,0,IF(AC8=1,AN8*1000,IF(AC8=2,AA8,AB8))+IF(AC8=1,AP8+AQ8/1000,0))))","v":0},{"$f":"RANK(AH8,AH:AH,0)","v":1},{"$f":"INT(AH8/1000000)","v":0},{"$f":"RANK(AJ8,AJ:AJ,0)","v":1},{"$f":"AI8-AK8+1","v":1},null,{"$f":"RANK(Z8,Z:Z,-1)","v":1},{"$f":"E8","v":0},{"$f":"RANK(AO8,AO:AO)","v":1},{"$f":"RANK(BZ8,BZ:BZ,-1)","v":1},null,null,null,{"$f":"IF(ISERROR(FIND($AU$7,AE8)),0,1)","v":0},null,null,null,null,null,{"$f":"HLOOKUP($A8,$BA$1:$BH$2,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW(BB8),$BB$4))=\"\",INDIRECT(ADDRESS(ROW(BB8),$BB$4))=0),\"\",ABS(INDIRECT(ADDRESS(ROW(BB8),$BB$4)))+0.0001*INDIRECT(ADDRESS(ROW(BB8),7)))","v":""},null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,{"$f":"IF(BX8=1,3,IF(BW8=1,2,IF(BV8=1,1,0)))","v":0},{"$f":"IF($AU$7=\"SQ\",BO8,IF($AU$7=\"BP\",BT8,BY8))","v":0}]

{"sheet":"DATA","index":4,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":true,"merged":[[1,2,10,2],[12,2,21,2],[17,4,19,7],[0,4,0,5],[0,6,0,7]]}
["Age","Coeff",null,{"$f":"'Weigh-In'!E2","v":"Bwt (kg)"},"Open and Master Wt Classes",null,"Junior and Sub Jr Wt Classes",null,null,"Age","USAPL Age Div","IPF Age Division"]
[14,1.23,"Foster Age Multiples",null,"Men","Women","Men","Women",null,11,"Youth",null,null,{"$f":"H3","v":44},1]
[15,1.18,null,15,{"$f":"IF($D$1=\"Bwt (kg)\",56,123)","v":56},{"$f":"IF($D$1=\"Bwt (kg)\",48,105)","v":48},{"$f":"IF($D$1=\"Bwt (kg)\",52,114)","v":52},{"$f":"IF($D$1=\"Bwt (kg)\",44,97)","v":44},null,14,"T1","SubJr",null,{"$f":"H4","v":48},2]
[16,1.1299999999999999,null,44.000999999999998,{"$f":"IF($D$1=\"Bwt (kg)\",56,123)","v":56},{"$f":"IF($D$1=\"Bwt (kg)\",48,105)","v":48},{"$f":"IF($D$1=\"Bwt (kg)\",52,114)","v":52},{"$f":"IF($D$1=\"Bwt (kg)\",48,105)","v":48},null,16,"T2","SubJr",null,52,3]
[17,1.08,null,48.000999999999998,56,{"$f":"IF($D$1=\"Bwt (kg)\",52,114)","v":52},{"$f":"IF($D$1=\"Bwt (kg)\",52,114)","v":52},{"$f":"IF($D$1=\"Bwt (kg)\",52,114)","v":52},null,18,"T3","Jr",null,56,4]
[18,1.06,null,52.000999999999998,56,56,56,56,null,20,"Jr","Jr",null,60,5]
[19,1.04,null,56.000999999999998,{"$f":"IF($D$1=\"Bwt (kg)\",60,132)","v":60},{"$f":"IF($D$1=\"Bwt (kg)\",60,132)","v":60},{"$f":"IF($D$1=\"Bwt (kg)\",60,132)","v":60},{"$f":"IF($D$1=\"Bwt (kg)\",60,132)","v":60},null,24,"Open","O",null,67.5,6]
[20,1.03,null,60.000999999999998,{"$f":"IF($D$1=\"Bwt (kg)\",67.5,148)","v":67.5},{"$f":"IF($D$1=\"Bwt (kg)\",67.5,148)","v":67.5},{"$f":"IF($D$1=\"Bwt (kg)\",67.5,148)","v":67.5},{"$f":"IF($D$1=\"Bwt (kg)\",67.5,148)","v":67.5},null,35,"SM","O",null,75,7]
[21,1.02,null,67.501000000000005,{"$f":"IF($D$1=\"Bwt (kg)\",75,165)","v":75},{"$f":"IF($D$1=\"Bwt (kg)\",75,165)","v":75},{"$f":"IF($D$1=\"Bwt (kg)\",75,165)","v":75},{"$f":"IF($D$1=\"Bwt (kg)\",75,165)","v":75},null,40,"M1","M1",null,82.5,8]
[22,1.01,null,75.001000000000005,{"$f":"IF($D$1=\"Bwt (kg)\",82.5,181)","v":82.5},{"$f":"IF($D$1=\"Bwt (kg)\",82.5,181)","v":82.5},{"$f":"IF($D$1=\"Bwt (kg)\",82.5,181)","v":82.5},{"$f":"IF($D$1=\"Bwt (kg)\",82.5,181)","v":82.5},null,45,"M2","M1",null,90,9]
[23,1,null,82.501000000000005,{"$f":"IF($D$1=\"Bwt (kg)\",90,198)","v":90},{"$f":"IF($D$1=\"Bwt (kg)\",90,198)","v":90},{"$f":"IF($D$1=\"Bwt (kg)\",90,198)","v":90},{"$f":"IF($D$1=\"Bwt (kg)\",90,198)","v":90},null,50,"M3","M2",null,"90+",10]
[30,1,null,90.001000000000005,{"$f":"IF($D$1=\"Bwt (kg)\",100,220)","v":100},{"$f":"IF($D$1=\"Bwt (kg)\",\"90+\",\"198+\")","v":"90+"},{"$f":"IF($D$1=\"Bwt (kg)\",100,220)","v":100},{"$f":"IF($D$1=\"Bwt (kg)\",\"90+\",\"198+\")","v":"90+"},null,55,"M4","M2",null,{"$f":"E12","v":100},11]
[40,1,"McCulloch Numbers",100.001,{"$f":"IF($D$1=\"Bwt (kg)\",110,242)","v":110},{"$f":"IF($D$1=\"Bwt (kg)\",\"90+\",\"198+\")","v":"90+"},{"$f":"IF($D$1=\"Bwt (kg)\",110,242)","v":110},"90+",null,60,"M5","M3",null,{"$f":"E13","v":110},12]
[41,1.01,null,110.001,{"$f":"IF($D$1=\"Bwt (kg)\",125,275)","v":125},"90+",{"$f":"IF($D$1=\"Bwt (kg)\",125,275)","v":125},"90+",null,65,"M6","M3",null,{"$f":"E14","v":125},13]
[42,1.02,null,125.001,{"$f":"IF($D$1=\"Bwt (kg)\",\"125+\",\"275+\")","v":"125+"},"90+",{"$f":"IF($D$1=\"Bwt (kg)\",\"125+\",\"275+\")","v":"125+"},"90+",null,70,"M7","M3",null,{"$f":"E15","v":"125+"},14]
[43,1.0309999999999999,null,null,null,null,null,null,null,75,"M8","M3"]
[44,1.0429999999999999,null,null,null,null,null,null,null,80,"M9","M3"]
[45,1.0549999999999999,null,null,"Copyright - Joe Marksteiner - 2005",null,null,null,null,85,"M10","M3"]
[46,1.0680000000000001,null,null,null,null,null,null,null,90,"M11","M3"]
[47,1.0820000000000001]
[48,1.097]
[49,1.113]
[50,1.1299999999999999]
[51,1.147]
[52,1.165]
[53,1.1839999999999999]
[54,1.204]
[55,1.2250000000000001]
[56,1.246]
[57,1.258]
[58,1.292]
[59,1.3149999999999999]
[60,1.34]
[61,1.3660000000000001]
[62,1.393]
[63,1.421]
[64,1.45]
[65,1.48]
[66,1.5109999999999999]
[67,1.5429999999999999]
[68,1.5780000000000001]
[69,1.61]
[70,1.645]
[71,1.681]
[72,1.718]
[73,1.756]
[74,1.7949999999999999]
[75,1.835]
[76,1.8759999999999999]
[77,1.9179999999999999]
[78,1.9610000000000001]
[79,2.0049999999999999]
[80,2.0499999999999998]

{"sheet":"ContestResults","index":5,"n_rows":3,"n_cols":33,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,2,1,29],[0,1,1,1]]}
[null,{"$f":"TODAY()","v":"2020-02-12"},{"$f":"Setup!B3","v":"Enter Meet Name Here"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(A:A)+8","v":9}]
[]
["Flt","Powerlifting Results Name","Team","Div",{"$f":"Lifting!$E$7","v":"Bwt (kg)"},{"$f":"IF(E3=\"Bwt (lb)\",\"WtCls (lb)\",\"WtCls (kg)\")","v":"WtCls (kg)"},"lot#","Wilks Coeff","Age","Age Coeff","SQ rack","SQ-1","SQ-2","SQ-3","Best SQ","BP rack","BP-1","BP-2","BP-3","Best BP","Sub Total","DL-1","DL-2","DL-3","Best DL","(1) PL Total","(2)          Wilks Pts","(3)       Age-Wilks","Pl Code","Pl-Div- WtCls-Evt"]

{"sheet":"QuickPrint","index":6,"n_rows":3,"n_cols":77,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,1,1],[0,2,1,31]]}
[null,{"$f":"TODAY()","v":"2020-02-12"},{"$f":"Setup!B3","v":"Enter Meet Name Here"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(A:A)+4","v":5}]
[]
["Flt B","Name","Team","Div",{"$f":"'Weigh-In'!E2","v":"Bwt (kg)"},{"$f":"Lifting!F7","v":"WtCls (kg)"},"lot#","Wilks Coeff","Age","Age Coeff","SQ rack","SQ-1","SQ-2","SQ-3","Best SQ","BP rack","BP-1","BP-2","BP-3","Best BP","Sub Total","DL-1","DL-2","DL-3","Best DL",{"$f":"Lifting!Z7","v":"(1) PL Total"},"(2)          Wilks Pts","(3)       Age-Wilks","Pl Code","Pl-Div- WtCls-Evt","Events Entered",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},"Scoring value","ABS rank",-1,1,1,"flight sort data","att sort data",null,null,null,null,null,null,null,null,"best att #","SQ-1","SQ-2","SQ-3","Best SQ Att","BP rack","BP-1","BP-2","BP-3","Best BP Att","Sub Total","DL-1","DL-2","DL-3","Best DL Att"]

{"sheet":"LoadingChart","index":7,"n_rows":167,"n_cols":23,"rows_kept":167,"cut":false,"hidden":false,"merged":[]}
[null,1,0,{"$f":"IF(Setup!M3=\"Kg\",Setup!K10,Setup!H10)","v":0},{"$f":"IF(Setup!M3=\"Kg\",Setup!K11,Setup!H11)","v":12},{"$f":"IF(Setup!M3=\"Kg\",Setup!K12,Setup!H12)","v":2},{"$f":"IF(Setup!M3=\"Kg\",Setup!K13,Setup!H13)","v":2},{"$f":"IF(Setup!M3=\"Kg\",Setup!K14,Setup!H14)","v":2},{"$f":"IF(Setup!M3=\"Kg\",Setup!K15,Setup!H15)","v":2},{"$f":"IF(Setup!M3=\"Kg\",Setup!K16,Setup!H16)","v":2},{"$f":"IF(Setup!M3=\"Kg\",Setup!K17,Setup!H17)","v":2},1,1,1,{"$f":"D1","v":0},12,2,2,2,2,2,2,1]
[0,{"$f":"Setup!M3","v":"Kg"},110,{"$f":"IF(Setup!M3=\"Kg\",Setup!L10,Setup!I10)","v":45},{"$f":"IF(Setup!M3=\"Kg\",Setup!L11,Setup!I11)","v":25},{"$f":"IF(Setup!M3=\"Kg\",Setup!L12,Setup!I12)","v":20},{"$f":"IF(Setup!M3=\"Kg\",Setup!L13,Setup!I13)","v":15},{"$f":"IF(Setup!M3=\"Kg\",Setup!L14,Setup!I14)","v":10},{"$f":"IF(Setup!M3=\"Kg\",Setup!L15,Setup!I15)","v":5},{"$f":"IF(Setup!M3=\"Kg\",Setup!L16,Setup!I16)","v":2.5},{"$f":"IF(Setup!M3=\"Kg\",Setup!L17,Setup!I17)","v":1.25},null,null,{"$f":"B2","v":"Kg"},110,45,25,20,15,10,5,2.5,1.25]
[{"$f":"IF($B$2=\"Kg\",B3-25,B3-55)","v":0},{"$f":"IF(B2=\"Kg\",25,55)","v":25},{"$f":"IF($C$1=0,0,MAX(C1/2,INT(A3/(2*C2))))","v":0},{"$f":"IF($D$1=0,0,MIN(INT((A3-2*$C$2*C3)/(2*$D$2)),$D$1/2))","v":0},{"$f":"IF($E$1=0,0,MIN(INT((A3-2*$C$2*C3-2*$D$2*D3)/(2*$E$2)),$E$1/2))","v":0},{"$f":"IF($F$1=0,0,MIN(INT((A3-2*$C$2*C3-2*$D$2*D3-2*$E$2*E3)/(2*$F$2)),$F$1/2))","v":0},{"$f":"IF($G$1=0,0,MIN(INT((A3-2*$C$2*C3-2*$D$2*D3-2*$E$2*E3-2*$F$2*F3)/(2*$G$2)),$G$1/2))","v":0},{"$f":"IF($H$1=0,0,MIN(INT((A3-2*$C$2*C3-2*$D$2*D3-2*$E$2*E3-2*$F$2*F3-2*$G$2*G3)/(2*$H$2)),$H$1/2))","v":0},{"$f":"IF($I$1=0,0,MIN(INT((A3-2*$C$2*C3-2*$D$2*D3-2*$E$2*E3-2*$F$2*F3-2*$G$2*G3-2*$H$2*H3)/(2*$I$2)),$I$1/2))","v":0},{"$f":"IF($J$1=0,0,MIN(INT((A3-2*$C$2*C3-2*$D$2*D3-2*$E$2*E3-2*$F$2*F3-2*$G$2*G3-2*$H$2*H3-2*$I$2*I3)/(2*$J$2)),$J$1/2))","v":0},{"$f":"IF($K$1=0,0,MIN(INT((A3-2*$C$2*C3-2*$D$2*D3-2*$E$2*E3-2*$F$2*F3-2*$G$2*G3-2*$H$2*H3-2*$I$2*I3-2*$J$2*J3)/(2*$K$2)),$K$1/2))","v":0},null,null,25,0,0,0,0,0,0,0,0,0]
[{"$f":"IF($B$2=\"Kg\",B4-25,B4-55)","v":2.5},{"$f":"IF($B$2=\"Kg\",B3+2.5,B3+5)","v":27.5},{"$f":"IF($C$1=0,0,MAX(C2/2,INT(A4/(2*C3))))","v":0},{"$f":"IF($D$1=0,0,MIN(INT((A4-2*$C$2*C4)/(2*$D$2)),$D$1/2))","v":0},{"$f":"IF($E$1=0,0,MIN(INT((A4-2*$C$2*C4-2*$D$2*D4)/(2*$E$2)),$E$1/2))","v":0},{"$f":"IF($F$1=0,0,MIN(INT((A4-2*$C$2*C4-2*$D$2*D4-2*$E$2*E4)/(2*$F$2)),$F$1/2))","v":0},{"$f":"IF($G$1=0,0,MIN(INT((A4-2*$C$2*C4-2*$D$2*D4-2*$E$2*E4-2*$F$2*F4)/(2*$G$2)),$G$1/2))","v":0},{"$f":"IF($H$1=0,0,MIN(INT((A4-2*$C$2*C4-2*$D$2*D4-2*$E$2*E4-2*$F$2*F4-2*$G$2*G4)/(2*$H$2)),$H$1/2))","v":0},{"$f":"IF($I$1=0,0,MIN(INT((A4-2*$C$2*C4-2*$D$2*D4-2*$E$2*E4-2*$F$2*F4-2*$G$2*G4-2*$H$2*H4)/(2*$I$2)),$I$1/2))","v":0},{"$f":"IF($J$1=0,0,MIN(INT((A4-2*$C$2*C4-2*$D$2*D4-2*$E$2*E4-2*$F$2*F4-2*$G$2*G4-2*$H$2*H4-2*$I$2*I4)/(2*$J$2)),$J$1/2))","v":0},{"$f":"IF($K$1=0,0,MIN(INT((A4-2*$C$2*C4-2*$D$2*D4-2*$E$2*E4-2*$F$2*F4-2*$G$2*G4-2*$H$2*H4-2*$I$2*I4-2*$J$2*J4)/(2*$K$2)),$K$1/2))","v":1},null,null,27.5,0,0,0,0,0,0,0,0,1]
[{"$f":"IF($B$2=\"Kg\",B5-25,B5-55)","v":5},{"$f":"IF($B$2=\"Kg\",B4+2.5,B4+5)","v":30},{"$f":"IF($C$1=0,0,MAX(C3/2,INT(A5/(2*C4))))","v":0},{"$f":"IF($D$1=0,0,MIN(INT((A5-2*$C$2*C5)/(2*$D$2)),$D$1/2))","v":0},{"$f":"IF($E$1=0,0,MIN(INT((A5-2*$C$2*C5-2*$D$2*D5)/(2*$E$2)),$E$1/2))","v":0},{"$f":"IF($F$1=0,0,MIN(INT((A5-2*$C$2*C5-2*$D$2*D5-2*$E$2*E5)/(2*$F$2)),$F$1/2))","v":0},{"$f":"IF($G$1=0,0,MIN(INT((A5-2*$C$2*C5-2*$D$2*D5-2*$E$2*E5-2*$F$2*F5)/(2*$G$2)),$G$1/2))","v":0},{"$f":"IF($H$1=0,0,MIN(INT((A5-2*$C$2*C5-2*$D$2*D5-2*$E$2*E5-2*$F$2*F5-2*$G$2*G5)/(2*$H$2)),$H$1/2))","v":0},{"$f":"IF($I$1=0,0,MIN(INT((A5-2*$C$2*C5-2*$D$2*D5-2*$E$2*E5-2*$F$2*F5-2*$G$2*G5-2*$H$2*H5)/(2*$I$2)),$I$1/2))","v":0},{"$f":"IF($J$1=0,0,MIN(INT((A5-2*$C$2*C5-2*$D$2*D5-2*$E$2*E5-2*$F$2*F5-2*$G$2*G5-2*$H$2*H5-2*$I$2*I5)/(2*$J$2)),$J$1/2))","v":1},{"$f":"IF($K$1=0,0,MIN(INT((A5-2*$C$2*C5-2*$D$2*D5-2*$E$2*E5-2*$F$2*F5-2*$G$2*G5-2*$H$2*H5-2*$I$2*I5-2*$J$2*J5)/(2*$K$2)),$K$1/2))","v":0},null,null,{"$f":"B5","v":30},{"$f":"C5","v":0},{"$f":"D5","v":0},{"$f":"E5","v":0},{"$f":"F5","v":0},{"$f":"G5","v":0},{"$f":"H5","v":0},{"$f":"I5","v":0},{"$f":"J5","v":1},{"$f":"K5","v":0}]
[7.5,32.5,0,0,0,0,0,0,0,1,1,null,null,32.5,0,0,0,0,0,0,0,1,1]
[10,35,0,0,0,0,0,0,1,0,0,null,null,35,0,0,0,0,0,0,1,0,0]
[12.5,37.5,0,0,0,0,0,0,1,0,1,null,null,37.5,0,0,0,0,0,0,1,0,1]
[15,40,0,0,0,0,0,0,1,1,0,null,null,40,0,0,0,0,0,0,1,1,0]
[17.5,42.5,0,0,0,0,0,0,1,1,1,null,null,42.5,0,0,0,0,0,0,1,1,1]
[20,45,0,0,0,0,0,1,0,0,0,null,null,45,0,0,0,0,0,1,0,0,0]
[22.5,47.5,0,0,0,0,0,1,0,0,1,null,null,47.5,0,0,0,0,0,1,0,0,1]
[25,50,0,0,0,0,0,1,0,1,0,null,null,50,0,0,0,0,0,1,0,1,0]
[27.5,52.5,0,0,0,0,0,1,0,1,1,null,null,52.5,0,0,0,0,0,1,0,1,1]
[30,55,0,0,0,0,1,0,0,0,0,null,null,55,0,0,0,0,1,0,0,0,0]
[32.5,57.5,0,0,0,0,1,0,0,0,1,null,null,57.5,0,0,0,0,1,0,0,0,1]
[35,60,0,0,0,0,1,0,0,1,0,null,null,60,0,0,0,0,1,0,0,1,0]
[37.5,62.5,0,0,0,0,1,0,0,1,1,null,null,62.5,0,0,0,0,1,0,0,1,1]
[40,65,0,0,0,1,0,0,0,0,0,null,null,65,0,0,0,1,0,0,0,0,0]
[42.5,67.5,0,0,0,1,0,0,0,0,1,null,null,67.5,0,0,0,1,0,0,0,0,1]
[45,70,0,0,0,1,0,0,0,1,0,null,null,70,0,0,0,1,0,0,0,1,0]
[47.5,72.5,0,0,0,1,0,0,0,1,1,null,null,72.5,0,0,0,1,0,0,0,1,1]
[50,75,0,0,1,0,0,0,0,0,0,null,null,75,0,0,1,0,0,0,0,0,0]
[52.5,77.5,0,0,1,0,0,0,0,0,1,null,null,77.5,0,0,1,0,0,0,0,0,1]
[55,80,0,0,1,0,0,0,0,1,0,null,null,80,0,0,1,0,0,0,0,1,0]
[57.5,82.5,0,0,1,0,0,0,0,1,1,null,null,82.5,0,0,1,0,0,0,0,1,1]
[60,85,0,0,1,0,0,0,1,0,0,null,null,85,0,0,1,0,0,0,1,0,0]
[62.5,87.5,0,0,1,0,0,0,1,0,1,null,null,87.5,0,0,1,0,0,0,1,0,1]
[65,90,0,0,1,0,0,0,1,1,0,null,null,90,0,0,1,0,0,0,1,1,0]
[67.5,92.5,0,0,1,0,0,0,1,1,1,null,null,92.5,0,0,1,0,0,0,1,1,1]
[70,95,0,0,1,0,0,1,0,0,0,null,null,95,0,0,1,0,0,1,0,0,0]
[72.5,97.5,0,0,1,0,0,1,0,0,1,null,null,97.5,0,0,1,0,0,1,0,0,1]
[75,100,0,0,1,0,0,1,0,1,0,null,null,100,0,0,1,0,0,1,0,1,0]
[77.5,102.5,0,0,1,0,0,1,0,1,1,null,null,102.5,0,0,1,0,0,1,0,1,1]
[80,105,0,0,1,0,1,0,0,0,0,null,null,105,0,0,1,0,1,0,0,0,0]
[82.5,107.5,0,0,1,0,1,0,0,0,1,null,null,107.5,0,0,1,0,1,0,0,0,1]
[85,110,0,0,1,0,1,0,0,1,0,null,null,110,0,0,1,0,1,0,0,1,0]
[87.5,112.5,0,0,1,0,1,0,0,1,1,null,null,112.5,0,0,1,0,1,0,0,1,1]
[90,115,0,0,1,1,0,0,0,0,0,null,null,115,0,0,1,1,0,0,0,0,0]
[92.5,117.5,0,0,1,1,0,0,0,0,1,null,null,117.5,0,0,1,1,0,0,0,0,1]
[95,120,0,0,1,1,0,0,0,1,0,null,null,120,0,0,1,1,0,0,0,1,0]
[97.5,122.5,0,0,1,1,0,0,0,1,1,null,null,122.5,0,0,1,1,0,0,0,1,1]
[100,125,0,0,2,0,0,0,0,0,0,null,null,125,0,0,2,0,0,0,0,0,0]
[102.5,127.5,0,0,2,0,0,0,0,0,1,null,null,127.5,0,0,2,0,0,0,0,0,1]
[105,130,0,0,2,0,0,0,0,1,0,null,null,130,0,0,2,0,0,0,0,1,0]
[107.5,132.5,0,0,2,0,0,0,0,1,1,null,null,132.5,0,0,2,0,0,0,0,1,1]
[110,135,0,0,2,0,0,0,1,0,0,null,null,135,0,0,2,0,0,0,1,0,0]
[112.5,137.5,0,0,2,0,0,0,1,0,1,null,null,137.5,0,0,2,0,0,0,1,0,1]
[115,140,0,0,2,0,0,0,1,1,0,null,null,140,0,0,2,0,0,0,1,1,0]
[117.5,142.5,0,0,2,0,0,0,1,1,1,null,null,142.5,0,0,2,0,0,0,1,1,1]
[120,145,0,0,2,0,0,1,0,0,0,null,null,145,0,0,2,0,0,1,0,0,0]
[122.5,147.5,0,0,2,0,0,1,0,0,1,null,null,147.5,0,0,2,0,0,1,0,0,1]
[125,150,0,0,2,0,0,1,0,1,0,null,null,150,0,0,2,0,0,1,0,1,0]
[127.5,152.5,0,0,2,0,0,1,0,1,1,null,null,152.5,0,0,2,0,0,1,0,1,1]
[130,155,0,0,2,0,1,0,0,0,0,null,null,155,0,0,2,0,1,0,0,0,0]
[132.5,157.5,0,0,2,0,1,0,0,0,1,null,null,157.5,0,0,2,0,1,0,0,0,1]
[135,160,0,0,2,0,1,0,0,1,0,null,null,160,0,0,2,0,1,0,0,1,0]
[137.5,162.5,0,0,2,0,1,0,0,1,1,null,null,162.5,0,0,2,0,1,0,0,1,1]
[140,165,0,0,2,1,0,0,0,0,0,null,null,165,0,0,2,1,0,0,0,0,0]
[142.5,167.5,0,0,2,1,0,0,0,0,1,null,null,167.5,0,0,2,1,0,0,0,0,1]
[145,170,0,0,2,1,0,0,0,1,0,null,null,170,0,0,2,1,0,0,0,1,0]
[147.5,172.5,0,0,2,1,0,0,0,1,1,null,null,172.5,0,0,2,1,0,0,0,1,1]
[150,175,0,0,3,0,0,0,0,0,0,null,null,175,0,0,3,0,0,0,0,0,0]
[152.5,177.5,0,0,3,0,0,0,0,0,1,null,null,177.5,0,0,3,0,0,0,0,0,1]
[155,180,0,0,3,0,0,0,0,1,0,null,null,180,0,0,3,0,0,0,0,1,0]
[157.5,182.5,0,0,3,0,0,0,0,1,1,null,null,182.5,0,0,3,0,0,0,0,1,1]
[160,185,0,0,3,0,0,0,1,0,0,null,null,185,0,0,3,0,0,0,1,0,0]
[162.5,187.5,0,0,3,0,0,0,1,0,1,null,null,187.5,0,0,3,0,0,0,1,0,1]
[{"$f":"IF($B$2=\"Kg\",B69-25,B69-55)","v":165},{"$f":"IF($B$2=\"Kg\",B68+2.5,B68+5)","v":190},{"$f":"IF($C$1=0,0,MAX(C67/2,INT(A69/(2*C68))))","v":0},{"$f":"IF($D$1=0,0,MIN(INT((A69-2*$C$2*C69)/(2*$D$2)),$D$1/2))","v":0},{"$f":"IF($E$1=0,0,MIN(INT((A69-2*$C$2*C69-2*$D$2*D69)/(2*$E$2)),$E$1/2))","v":3},{"$f":"IF($F$1=0,0,MIN(INT((A69-2*$C$2*C69-2*$D$2*D69-2*$E$2*E69)/(2*$F$2)),$F$1/2))","v":0},{"$f":"IF($G$1=0,0,MIN(INT((A69-2*$C$2*C69-2*$D$2*D69-2*$E$2*E69-2*$F$2*F69)/(2*$G$2)),$G$1/2))","v":0},{"$f":"IF($H$1=0,0,MIN(INT((A69-2*$C$2*C69-2*$D$2*D69-2*$E$2*E69-2*$F$2*F69-2*$G$2*G69)/(2*$H$2)),$H$1/2))","v":0},{"$f":"IF($I$1=0,0,MIN(INT((A69-2*$C$2*C69-2*$D$2*D69-2*$E$2*E69-2*$F$2*F69-2*$G$2*G69-2*$H$2*H69)/(2*$I$2)),$I$1/2))","v":1},{"$f":"IF($J$1=0,0,MIN(INT((A69-2*$C$2*C69-2*$D$2*D69-2*$E$2*E69-2*$F$2*F69-2*$G$2*G69-2*$H$2*H69-2*$I$2*I69)/(2*$J$2)),$J$1/2))","v":1},{"$f":"IF($K$1=0,0,MIN(INT((A69-2*$C$2*C69-2*$D$2*D69-2*$E$2*E69-2*$F$2*F69-2*$G$2*G69-2*$H$2*H69-2*$I$2*I69-2*$J$2*J69)/(2*$K$2)),$K$1/2))","v":0},null,null,{"$f":"B69","v":190},{"$f":"C69","v":0},{"$f":"D69","v":0},{"$f":"E69","v":3},{"$f":"F69","v":0},{"$f":"G69","v":0},{"$f":"H69","v":0},{"$f":"I69","v":1},{"$f":"J69","v":1},{"$f":"K69","v":0}]
[167.5,192.5,0,0,3,0,0,0,1,1,1,null,null,192.5,0,0,3,0,0,0,1,1,1]
[170,195,0,0,3,0,0,1,0,0,0,null,null,195,0,0,3,0,0,1,0,0,0]
[172.5,197.5,0,0,3,0,0,1,0,0,1,null,null,197.5,0,0,3,0,0,1,0,0,1]
[175,200,0,0,3,0,0,1,0,1,0,null,null,200,0,0,3,0,0,1,0,1,0]
[177.5,202.5,0,0,3,0,0,1,0,1,1,null,null,202.5,0,0,3,0,0,1,0,1,1]
[180,205,0,0,3,0,1,0,0,0,0,null,null,205,0,0,3,0,1,0,0,0,0]
[182.5,207.5,0,0,3,0,1,0,0,0,1,null,null,207.5,0,0,3,0,1,0,0,0,1]
[185,210,0,0,3,0,1,0,0,1,0,null,null,210,0,0,3,0,1,0,0,1,0]
[187.5,212.5,0,0,3,0,1,0,0,1,1,null,null,212.5,0,0,3,0,1,0,0,1,1]
[190,215,0,0,3,1,0,0,0,0,0,null,null,215,0,0,3,1,0,0,0,0,0]
[192.5,217.5,0,0,3,1,0,0,0,0,1,null,null,217.5,0,0,3,1,0,0,0,0,1]
[195,220,0,0,3,1,0,0,0,1,0,null,null,220,0,0,3,1,0,0,0,1,0]
[197.5,222.5,0,0,3,1,0,0,0,1,1,null,null,222.5,0,0,3,1,0,0,0,1,1]
[200,225,0,0,4,0,0,0,0,0,0,null,null,225,0,0,4,0,0,0,0,0,0]
[202.5,227.5,0,0,4,0,0,0,0,0,1,null,null,227.5,0,0,4,0,0,0,0,0,1]
[205,230,0,0,4,0,0,0,0,1,0,null,null,230,0,0,4,0,0,0,0,1,0]
[207.5,232.5,0,0,4,0,0,0,0,1,1,null,null,232.5,0,0,4,0,0,0,0,1,1]
[210,235,0,0,4,0,0,0,1,0,0,null,null,235,0,0,4,0,0,0,1,0,0]
[212.5,237.5,0,0,4,0,0,0,1,0,1,null,null,237.5,0,0,4,0,0,0,1,0,1]
[215,240,0,0,4,0,0,0,1,1,0,null,null,240,0,0,4,0,0,0,1,1,0]
[217.5,242.5,0,0,4,0,0,0,1,1,1,null,null,242.5,0,0,4,0,0,0,1,1,1]
[220,245,0,0,4,0,0,1,0,0,0,null,null,245,0,0,4,0,0,1,0,0,0]
[222.5,247.5,0,0,4,0,0,1,0,0,1,null,null,247.5,0,0,4,0,0,1,0,0,1]
[225,250,0,0,4,0,0,1,0,1,0,null,null,250,0,0,4,0,0,1,0,1,0]
[227.5,252.5,0,0,4,0,0,1,0,1,1,null,null,252.5,0,0,4,0,0,1,0,1,1]
[230,255,0,0,4,0,1,0,0,0,0,null,null,255,0,0,4,0,1,0,0,0,0]
[232.5,257.5,0,0,4,0,1,0,0,0,1,null,null,257.5,0,0,4,0,1,0,0,0,1]
[235,260,0,0,4,0,1,0,0,1,0,null,null,260,0,0,4,0,1,0,0,1,0]
[237.5,262.5,0,0,4,0,1,0,0,1,1,null,null,262.5,0,0,4,0,1,0,0,1,1]
[240,265,0,0,4,1,0,0,0,0,0,null,null,265,0,0,4,1,0,0,0,0,0]
[242.5,267.5,0,0,4,1,0,0,0,0,1,null,null,267.5,0,0,4,1,0,0,0,0,1]
[245,270,0,0,4,1,0,0,0,1,0,null,null,270,0,0,4,1,0,0,0,1,0]
[247.5,272.5,0,0,4,1,0,0,0,1,1,null,null,272.5,0,0,4,1,0,0,0,1,1]
[250,275,0,0,5,0,0,0,0,0,0,null,null,275,0,0,5,0,0,0,0,0,0]
[252.5,277.5,0,0,5,0,0,0,0,0,1,null,null,277.5,0,0,5,0,0,0,0,0,1]
[255,280,0,0,5,0,0,0,0,1,0,null,null,280,0,0,5,0,0,0,0,1,0]
[257.5,282.5,0,0,5,0,0,0,0,1,1,null,null,282.5,0,0,5,0,0,0,0,1,1]
[260,285,0,0,5,0,0,0,1,0,0,null,null,285,0,0,5,0,0,0,1,0,0]
[262.5,287.5,0,0,5,0,0,0,1,0,1,null,null,287.5,0,0,5,0,0,0,1,0,1]
[265,290,0,0,5,0,0,0,1,1,0,null,null,290,0,0,5,0,0,0,1,1,0]
[267.5,292.5,0,0,5,0,0,0,1,1,1,null,null,292.5,0,0,5,0,0,0,1,1,1]
[270,295,0,0,5,0,0,1,0,0,0,null,null,295,0,0,5,0,0,1,0,0,0]
[272.5,297.5,0,0,5,0,0,1,0,0,1,null,null,297.5,0,0,5,0,0,1,0,0,1]
[275,300,0,0,5,0,0,1,0,1,0,null,null,300,0,0,5,0,0,1,0,1,0]
[277.5,302.5,0,0,5,0,0,1,0,1,1,null,null,302.5,0,0,5,0,0,1,0,1,1]
[280,305,0,0,5,0,1,0,0,0,0,null,null,305,0,0,5,0,1,0,0,0,0]
[282.5,307.5,0,0,5,0,1,0,0,0,1,null,null,307.5,0,0,5,0,1,0,0,0,1]
[285,310,0,0,5,0,1,0,0,1,0,null,null,310,0,0,5,0,1,0,0,1,0]
[287.5,312.5,0,0,5,0,1,0,0,1,1,null,null,312.5,0,0,5,0,1,0,0,1,1]
[290,315,0,0,5,1,0,0,0,0,0,null,null,315,0,0,5,1,0,0,0,0,0]
[292.5,317.5,0,0,5,1,0,0,0,0,1,null,null,317.5,0,0,5,1,0,0,0,0,1]
[295,320,0,0,5,1,0,0,0,1,0,null,null,320,0,0,5,1,0,0,0,1,0]
[297.5,322.5,0,0,5,1,0,0,0,1,1,null,null,322.5,0,0,5,1,0,0,0,1,1]
[300,325,0,0,6,0,0,0,0,0,0,null,null,325,0,0,6,0,0,0,0,0,0]
[302.5,327.5,0,0,6,0,0,0,0,0,1,null,null,327.5,0,0,6,0,0,0,0,0,1]
[305,330,0,0,6,0,0,0,0,1,0,null,null,330,0,0,6,0,0,0,0,1,0]
[307.5,332.5,0,0,6,0,0,0,0,1,1,null,null,332.5,0,0,6,0,0,0,0,1,1]
[310,335,0,0,6,0,0,0,1,0,0,null,null,335,0,0,6,0,0,0,1,0,0]
[312.5,337.5,0,0,6,0,0,0,1,0,1,null,null,337.5,0,0,6,0,0,0,1,0,1]
[315,340,0,0,6,0,0,0,1,1,0,null,null,340,0,0,6,0,0,0,1,1,0]
[317.5,342.5,0,0,6,0,0,0,1,1,1,null,null,342.5,0,0,6,0,0,0,1,1,1]
[320,345,0,0,6,0,0,1,0,0,0,null,null,345,0,0,6,0,0,1,0,0,0]
[322.5,347.5,0,0,6,0,0,1,0,0,1,null,null,347.5,0,0,6,0,0,1,0,0,1]
[{"$f":"IF($B$2=\"Kg\",B133-25,B133-55)","v":325},{"$f":"IF($B$2=\"Kg\",B132+2.5,B132+5)","v":350},{"$f":"IF($C$1=0,0,MAX(C131/2,INT(A133/(2*C132))))","v":0},{"$f":"IF($D$1=0,0,MIN(INT((A133-2*$C$2*C133)/(2*$D$2)),$D$1/2))","v":0},{"$f":"IF($E$1=0,0,MIN(INT((A133-2*$C$2*C133-2*$D$2*D133)/(2*$E$2)),$E$1/2))","v":6},{"$f":"IF($F$1=0,0,MIN(INT((A133-2*$C$2*C133-2*$D$2*D133-2*$E$2*E133)/(2*$F$2)),$F$1/2))","v":0},{"$f":"IF($G$1=0,0,MIN(INT((A133-2*$C$2*C133-2*$D$2*D133-2*$E$2*E133-2*$F$2*F133)/(2*$G$2)),$G$1/2))","v":0},{"$f":"IF($H$1=0,0,MIN(INT((A133-2*$C$2*C133-2*$D$2*D133-2*$E$2*E133-2*$F$2*F133-2*$G$2*G133)/(2*$H$2)),$H$1/2))","v":1},{"$f":"IF($I$1=0,0,MIN(INT((A133-2*$C$2*C133-2*$D$2*D133-2*$E$2*E133-2*$F$2*F133-2*$G$2*G133-2*$H$2*H133)/(2*$I$2)),$I$1/2))","v":0},{"$f":"IF($J$1=0,0,MIN(INT((A133-2*$C$2*C133-2*$D$2*D133-2*$E$2*E133-2*$F$2*F133-2*$G$2*G133-2*$H$2*H133-2*$I$2*I133)/(2*$J$2)),$J$1/2))","v":1},{"$f":"IF($K$1=0,0,MIN(INT((A133-2*$C$2*C133-2*$D$2*D133-2*$E$2*E133-2*$F$2*F133-2*$G$2*G133-2*$H$2*H133-2*$I$2*I133-2*$J$2*J133)/(2*$K$2)),$K$1/2))","v":0},null,null,{"$f":"B133","v":350},{"$f":"C133","v":0},{"$f":"D133","v":0},{"$f":"E133","v":6},{"$f":"F133","v":0},{"$f":"G133","v":0},{"$f":"H133","v":1},{"$f":"I133","v":0},{"$f":"J133","v":1},{"$f":"K133","v":0}]
[327.5,352.5,0,0,6,0,0,1,0,1,1,null,null,352.5,0,0,6,0,0,1,0,1,1]
[330,355,0,0,6,0,1,0,0,0,0,null,null,355,0,0,6,0,1,0,0,0,0]
[332.5,357.5,0,0,6,0,1,0,0,0,1,null,null,357.5,0,0,6,0,1,0,0,0,1]
[335,360,0,0,6,0,1,0,0,1,0,null,null,360,0,0,6,0,1,0,0,1,0]
[337.5,362.5,0,0,6,0,1,0,0,1,1,null,null,362.5,0,0,6,0,1,0,0,1,1]
[340,365,0,0,6,1,0,0,0,0,0,null,null,365,0,0,6,1,0,0,0,0,0]
[342.5,367.5,0,0,6,1,0,0,0,0,1,null,null,367.5,0,0,6,1,0,0,0,0,1]
[345,370,0,0,6,1,0,0,0,1,0,null,null,370,0,0,6,1,0,0,0,1,0]
[347.5,372.5,0,0,6,1,0,0,0,1,1,null,null,372.5,0,0,6,1,0,0,0,1,1]
[350,375,0,0,6,1,0,0,1,0,0,null,null,375,0,0,6,1,0,0,1,0,0]
[352.5,377.5,0,0,6,1,0,0,1,0,1,null,null,377.5,0,0,6,1,0,0,1,0,1]
[355,380,0,0,6,1,0,0,1,1,0,null,null,380,0,0,6,1,0,0,1,1,0]
[357.5,382.5,0,0,6,1,0,0,1,1,1,null,null,382.5,0,0,6,1,0,0,1,1,1]
[360,385,0,0,6,1,0,1,0,0,0,null,null,385,0,0,6,1,0,1,0,0,0]
[362.5,387.5,0,0,6,1,0,1,0,0,1,null,null,387.5,0,0,6,1,0,1,0,0,1]
[365,390,0,0,6,1,0,1,0,1,0,null,null,390,0,0,6,1,0,1,0,1,0]
[367.5,392.5,0,0,6,1,0,1,0,1,1,null,null,392.5,0,0,6,1,0,1,0,1,1]
[370,395,0,0,6,1,1,0,0,0,0,null,null,395,0,0,6,1,1,0,0,0,0]
[372.5,397.5,0,0,6,1,1,0,0,0,1,null,null,397.5,0,0,6,1,1,0,0,0,1]
[375,400,0,0,6,1,1,0,0,1,0,null,null,400,0,0,6,1,1,0,0,1,0]
[377.5,402.5,0,0,6,1,1,0,0,1,1,null,null,402.5,0,0,6,1,1,0,0,1,1]
[380,405,0,0,6,1,1,0,1,0,0,null,null,405,0,0,6,1,1,0,1,0,0]
[382.5,407.5,0,0,6,1,1,0,1,0,1,null,null,407.5,0,0,6,1,1,0,1,0,1]
[385,410,0,0,6,1,1,0,1,1,0,null,null,410,0,0,6,1,1,0,1,1,0]
[387.5,412.5,0,0,6,1,1,0,1,1,1,null,null,412.5,0,0,6,1,1,0,1,1,1]
[390,415,0,0,6,1,1,1,0,0,0,null,null,415,0,0,6,1,1,1,0,0,0]
[392.5,417.5,0,0,6,1,1,1,0,0,1,null,null,417.5,0,0,6,1,1,1,0,0,1]
[395,420,0,0,6,1,1,1,0,1,0,null,null,420,0,0,6,1,1,1,0,1,0]
[397.5,422.5,0,0,6,1,1,1,0,1,1,null,null,422.5,0,0,6,1,1,1,0,1,1]
[400,425,0,0,6,1,1,1,1,0,0,null,null,425,0,0,6,1,1,1,1,0,0]
[402.5,427.5,0,0,6,1,1,1,1,0,1,null,null,427.5,0,0,6,1,1,1,1,0,1]
[405,430,0,0,6,1,1,1,1,1,0,null,null,430,0,0,6,1,1,1,1,1,0]
[407.5,432.5,0,0,6,1,1,1,1,1,1,null,null,432.5,0,0,6,1,1,1,1,1,1]
[410,435,0,0,6,1,1,1,1,1,1,null,null,435,0,0,6,1,1,1,1,1,1]

{"sheet":"Awards","index":8,"n_rows":27,"n_cols":19,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,0,10,1],[9,2,9,3],[10,2,10,3],[3,2,3,3],[4,2,4,3],[6,2,6,3],[7,2,7,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,"WtCls","lb","kg",null,"Event",null,{"$f":"OFFSET(P2,MATCH(C11,O3:O7,0),1)","v":"SQ"},"Pl-Div- WtCls-Evt","row"]
["Add your Logo here.",null,null,null,null,null,null,null,null,null,43,97,44,null,"PL Total",null,"PL",{"$f":"CONCATENATE(\"1-\",$P$11,IF($P$12>1,\"\",CONCATENATE(\"-\",$C$8)),\"-\",$Q$2)","v":{"$error":"#N/A"}},{"$f":"IF(OR(C5=\"Best Lifter Men\",C5=\"Best Lifter Women\"),B26,MATCH(R3,ContestResults!AD:AD,0))","v":{"$error":"#N/A"}}]
[null,null,"Division",null,null,null,null,null,null,null,47,105,48,null,"Squat",null,"SQ",{"$f":"CONCATENATE(\"2-\",$P$11,IF($P$12>1,\"\",CONCATENATE(\"-\",$C$8)),\"-\",$Q$2)","v":{"$error":"#N/A"}},{"$f":"MATCH(R4,ContestResults!AD:AD,0)","v":{"$error":"#N/A"}}]
[null,null,"Open Men",null,null,null,null,null,null,null,52,114,52,null,"Benchpress",null,"BP",{"$f":"CONCATENATE(\"3-\",$P$11,IF($P$12>1,\"\",CONCATENATE(\"-\",$C$8)),\"-\",$Q$2)","v":{"$error":"#N/A"}},{"$f":"MATCH(R5,ContestResults!AD:AD,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,53,123,56,null,"Deadlift",null,"DL",{"$f":"CONCATENATE(\"4-\",$P$11,IF($P$12>1,\"\",CONCATENATE(\"-\",$C$8)),\"-\",$Q$2)","v":{"$error":"#N/A"}},{"$f":"MATCH(R6,ContestResults!AD:AD,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"CONCATENATE(\"WtCls \",RIGHT('Weigh-In'!E2,4))","v":"WtCls (kg)"},null,null,null,null,null,null,null,57,132,60,null,"PP Total",null,"PP",{"$f":"CONCATENATE(\"5-\",$P$11,IF($P$12>1,\"\",CONCATENATE(\"-\",$C$8)),\"-\",$Q$2)","v":{"$error":"#N/A"}},{"$f":"MATCH(R7,ContestResults!AD:AD,0)","v":{"$error":"#N/A"}}]
[null,null,74,null,null,null,null,null,null,null,59,148,67.5]
[null,null,null,null,null,null,null,null,null,null,63,165,75,null,"division lookup"]
[null,null,"Event",null,null,null,null,null,null,null,66,181,82.5,null,"range",{"$f":"CONCATENATE(\"Setup!C12:C\",COUNTA(Setup!B:B)+8)","v":"Setup!C12:C15"}]
[null,null,"Squat",null,null,null,null,null,null,null,72,198,90,null,"Abbrev",{"$f":"OFFSET(Setup!B1,MATCH(C5,Setup!C:C,0)-1,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,74,"198+","90+",null,"pl code",{"$f":"OFFSET(Setup!F1,MATCH(C5,Setup!C:C,0)-1,0)","v":{"$error":"#N/A"}}]
["Place","Name",{"$f":"IF(Lifting!F2=\"Lb\",\"Pounds\",\"Kilos\")","v":"Kilos"},{"$f":"IF(P12=1,\"\",IF(P12=2,\"Wilks Pts\",\"Wilks-Age Pts\"))","v":{"$error":"#N/A"}},null,null,null,null,null,null,83,220,100]
[{"$f":"IF(B14=\"\",\"\",1)","v":""},{"$f":"IF(ISERROR(S3),\"\",OFFSET(ContestResults!$B$1,S3-1,0))","v":""},{"$f":"IF(ISERROR(S3),\"\",OFFSET(ContestResults!$Z$1,S3-1,0))","v":""},{"$f":"IF(OR($P$12=1,ISERROR(S3)),\"\",IF(P12=2,OFFSET(ContestResults!$AA$1,S3-1,0),OFFSET(ContestResults!$AB$1,S3-1,0)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,84,242,110]
[{"$f":"IF(B15=\"\",\"\",2)","v":""},{"$f":"IF(ISERROR(S4),\"\",OFFSET(ContestResults!$B$1,S4-1,0))","v":""},{"$f":"IF(ISERROR(S4),\"\",OFFSET(ContestResults!$Z$1,S4-1,0))","v":""},{"$f":"IF(OR($P$12=1,ISERROR(S4)),\"\",IF(P12=2,OFFSET(ContestResults!$AA$1,S4-1,0),OFFSET(ContestResults!$AB$1,S4-1,0)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,"84+",275,125]
[{"$f":"IF(B16=\"\",\"\",3)","v":""},{"$f":"IF(ISERROR(S5),\"\",OFFSET(ContestResults!$B$1,S5-1,0))","v":""},{"$f":"IF(ISERROR(S5),\"\",OFFSET(ContestResults!$Z$1,S5-1,0))","v":""},{"$f":"IF(OR($P$12=1,ISERROR(S5)),\"\",IF(P12=2,OFFSET(ContestResults!$AA$1,S5-1,0),OFFSET(ContestResults!$AB$1,S5-1,0)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,93,"275+","125+"]
[{"$f":"IF(B17=\"\",\"\",4)","v":""},{"$f":"IF(ISERROR(S6),\"\",OFFSET(ContestResults!$B$1,S6-1,0))","v":""},{"$f":"IF(ISERROR(S6),\"\",OFFSET(ContestResults!$Z$1,S6-1,0))","v":""},{"$f":"IF(OR($P$12=1,ISERROR(S6)),\"\",IF(P12=2,OFFSET(ContestResults!$AA$1,S6-1,0),OFFSET(ContestResults!$AB$1,S6-1,0)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,105]
[{"$f":"IF(B18=\"\",\"\",5)","v":""},{"$f":"IF(ISERROR(S7),\"\",OFFSET(ContestResults!$B$1,S7-1,0))","v":""},{"$f":"IF(ISERROR(S7),\"\",OFFSET(ContestResults!$Z$1,S7-1,0))","v":""},{"$f":"IF(OR($P$12=1,ISERROR(S7)),\"\",IF(P12=2,OFFSET(ContestResults!$AA$1,S7-1,0),OFFSET(ContestResults!$AB$1,S7-1,0)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,120]
[null,null,null,null,null,null,null,null,null,null,"120+"]
[]
[]
[]
[]
[]
[null,"row","code","Best lifter pts","div","M/F","Event"]
[null,26,null,467.64400448090129,null,{"$f":"LEFT(P11,1)","v":{"$error":"#N/A"}},{"$f":"Q2","v":"SQ"}]
[null,50,null,null,null,{"$f":"LEFT(E27,1)","v":""},{"$f":"RIGHT(C27,2)","v":""}]