{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Scoresheet","Instructions","IPF GL Formula","WeightClasses"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"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":"Scoresheet","index":0,"n_rows":40,"n_cols":47,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,27,4,28],[4,23,4,24],[4,11,4,12],[4,13,4,14],[4,16,4,17],[4,18,4,19],[4,20,4,21],[2,4,2,16],[3,4,3,16],[4,9,4,10],[4,25,4,26],[1,4,1,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"√","Good"]
[null,null,null,null,"Coupe de Luxembourg Powerlifting PWFL",null,null,null,null,null,null,null,null,null,null,null,null,null,"+","Record"]
[null,null,null,null,"Hamm-Luxembourg",null,null,null,null,null,null,null,null,null,null,null,null,null,"×","NoLift"]
[null,null,null,null,"30 Juin 2024"]
["Gr.","Lot","Last \nName","First Name","Team","Birth Year","Division","Body Wt","WT Class","SQ-1",null,"SQ-2",null,"SQ-3",null,"Best SQ","BP-1",null,"BP-2",null,"BP-3",null,"Best BP","DL-1",null,"DL-2",null,"DL-3",null,"Best DL","RESULT","IPF GL Pts.","IPF GL Coeff.","Place"]
[1,"Op","Sacré","Margault","SC Hamm",1993,"F-CL-PL",67.3,{"$f":"IF(H6=\"\",\"\",VLOOKUP(H6,WeightClasses!$A$2:$E$18,IF(LEFT(G6,1)=\"F\",IF(YEAR(TODAY())-F6<24,4,2),IF(YEAR(TODAY())-F6<24,5,3)),TRUE))","v":69},"√",122.5,"√",130,"×",135.5,{"$f":"IF(OR(K6<>0,M6<>0,O6<>0),MAX(IF(OR(J6=$S$1,J6=$S$2),K6,0),IF(OR(L6=$S$1,L6=$S$2),M6,0),IF(OR(N6=$S$1,N6=$S$2),O6,0)),\"\")","v":130},"√",67.5,"√",72.5,"√",75,{"$f":"IF(OR(R6<>0,T6<>0,V6<>0),MAX(IF(OR(Q6=$S$1,Q6=$S$2),R6,0),IF(OR(S6=$S$1,S6=$S$2),T6,0),IF(OR(U6=$S$1,U6=$S$2),V6,0)),\"\")","v":75},"√",117.5,"√",127.5,"√",132.5,{"$f":"IF(OR(Y6<>0,AA6<>0,AC6<>0),MAX(IF(OR(X6=$S$1,X6=$S$2),Y6,0),IF(OR(Z6=$S$1,Z6=$S$2),AA6,0),IF(OR(AB6=$S$1,AB6=$S$2),AC6,0)),\"\")","v":132.5},{"$f":"IF(OR(P6<>\"\",W6<>\"\",AD6<>\"\"),IF(AU6,\"DSQ\",IF(AND(RIGHT(G6,2)=\"PL\"),IF(P6=\"\",0,P6)+IF(W6=\"\",0,W6)+IF(AD6=\"\",0,AD6),IF(AND(RIGHT(G6,2)=\"BP\",W6<>0),W6,IF(AND(RIGHT(G6,2)=\"DL\",AD6<>0),AD6,IF(AND(RIGHT(G6,2)=\"SQ\",P6<>0),P6,0))))),\"\")","v":337.5},{"$f":"IF(AND(AE6<>\"\",ISNUMBER(AE6)),AG6*AE6,\"\")","v":70.918537499999999},{"$f":"IF(OR(H6=\"\",H6=0),0, ROUND(100/(VLOOKUP($G6,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G6,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G6,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H6)),6))","v":0.21012900000000001},null,{"$f":"J6=$S$3","v":false},{"$f":"L6=$S$3","v":false},{"$f":"N6=$S$3","v":true},{"$f":"Q6=$S$3","v":false},{"$f":"S6=$S$3","v":false},{"$f":"U6=$S$3","v":false},{"$f":"X6=$S$3","v":false},{"$f":"Z6=$S$3","v":false},{"$f":"AB6=$S$3","v":false},{"$f":"AND(AI6,AJ6,AK6)","v":false},{"$f":"AND(AL6,AM6,AN6)","v":false},{"$f":"AND(AO6,AP6,AQ6)","v":false},{"$f":"OR(AR6,AS6,AT6)","v":false}]
[1,"Jr","Alexandreas","Marina","SC Hamm",2000,"F-CL-PL",64.319999999999993,{"$f":"IF(H7=\"\",\"\",VLOOKUP(H7,WeightClasses!$A$2:$E$18,IF(LEFT(G7,1)=\"F\",IF(YEAR(TODAY())-F7<24,4,2),IF(YEAR(TODAY())-F7<24,5,3)),TRUE))","v":69},"√",105,"×",110,"×",110,{"$f":"IF(OR(K7<>0,M7<>0,O7<>0),MAX(IF(OR(J7=$S$1,J7=$S$2),K7,0),IF(OR(L7=$S$1,L7=$S$2),M7,0),IF(OR(N7=$S$1,N7=$S$2),O7,0)),\"\")","v":105},"√",57.5,"√",62.5,"√",65,{"$f":"IF(OR(R7<>0,T7<>0,V7<>0),MAX(IF(OR(Q7=$S$1,Q7=$S$2),R7,0),IF(OR(S7=$S$1,S7=$S$2),T7,0),IF(OR(U7=$S$1,U7=$S$2),V7,0)),\"\")","v":65},"√",112.5,"√",117.5,"×",120,{"$f":"IF(OR(Y7<>0,AA7<>0,AC7<>0),MAX(IF(OR(X7=$S$1,X7=$S$2),Y7,0),IF(OR(Z7=$S$1,Z7=$S$2),AA7,0),IF(OR(AB7=$S$1,AB7=$S$2),AC7,0)),\"\")","v":117.5},{"$f":"IF(OR(P7<>\"\",W7<>\"\",AD7<>\"\"),IF(AU7,\"DSQ\",IF(AND(RIGHT(G7,2)=\"PL\"),IF(P7=\"\",0,P7)+IF(W7=\"\",0,W7)+IF(AD7=\"\",0,AD7),IF(AND(RIGHT(G7,2)=\"BP\",W7<>0),W7,IF(AND(RIGHT(G7,2)=\"DL\",AD7<>0),AD7,IF(AND(RIGHT(G7,2)=\"SQ\",P7<>0),P7,0))))),\"\")","v":287.5},62.079300000000003,{"$f":"IF(OR(H7=\"\",H7=0),0, ROUND(100/(VLOOKUP($G7,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G7,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G7,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H7)),6))","v":0.21592800000000001},null,{"$f":"J7=$S$3","v":false},{"$f":"L7=$S$3","v":true},{"$f":"N7=$S$3","v":true},{"$f":"Q7=$S$3","v":false},{"$f":"S7=$S$3","v":false},{"$f":"U7=$S$3","v":false},{"$f":"X7=$S$3","v":false},{"$f":"Z7=$S$3","v":false},{"$f":"AB7=$S$3","v":true},{"$f":"AND(AI7,AJ7,AK7)","v":false},{"$f":"AND(AL7,AM7,AN7)","v":false},{"$f":"AND(AO7,AP7,AQ7)","v":false},{"$f":"OR(AR7,AS7,AT7)","v":false}]
[1,"Jr","Weydert","Emma","SC Hamm",2004,"F-CL-PL",57.62,{"$f":"IF(H8=\"\",\"\",VLOOKUP(H8,WeightClasses!$A$2:$E$18,IF(LEFT(G8,1)=\"F\",IF(YEAR(TODAY())-F8<24,4,2),IF(YEAR(TODAY())-F8<24,5,3)),TRUE))","v":63},"√",105,"√",112.5,"+",118,{"$f":"IF(OR(K8<>0,M8<>0,O8<>0),MAX(IF(OR(J8=$S$1,J8=$S$2),K8,0),IF(OR(L8=$S$1,L8=$S$2),M8,0),IF(OR(N8=$S$1,N8=$S$2),O8,0)),\"\")","v":118},"√",57.5,"+",61,"×",63.5,{"$f":"IF(OR(R8<>0,T8<>0,V8<>0),MAX(IF(OR(Q8=$S$1,Q8=$S$2),R8,0),IF(OR(S8=$S$1,S8=$S$2),T8,0),IF(OR(U8=$S$1,U8=$S$2),V8,0)),\"\")","v":61},"√",135,"+",145.5,"+",150,{"$f":"IF(OR(Y8<>0,AA8<>0,AC8<>0),MAX(IF(OR(X8=$S$1,X8=$S$2),Y8,0),IF(OR(Z8=$S$1,Z8=$S$2),AA8,0),IF(OR(AB8=$S$1,AB8=$S$2),AC8,0)),\"\")","v":150},{"$f":"IF(OR(P8<>\"\",W8<>\"\",AD8<>\"\"),IF(AU8,\"DSQ\",IF(AND(RIGHT(G8,2)=\"PL\"),IF(P8=\"\",0,P8)+IF(W8=\"\",0,W8)+IF(AD8=\"\",0,AD8),IF(AND(RIGHT(G8,2)=\"BP\",W8<>0),W8,IF(AND(RIGHT(G8,2)=\"DL\",AD8<>0),AD8,IF(AND(RIGHT(G8,2)=\"SQ\",P8<>0),P8,0))))),\"\")","v":329},76.553694000000007,{"$f":"IF(OR(H8=\"\",H8=0),0, ROUND(100/(VLOOKUP($G8,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G8,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G8,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H8)),6))","v":0.232686},null,{"$f":"J8=$S$3","v":false},{"$f":"L8=$S$3","v":false},{"$f":"N8=$S$3","v":false},{"$f":"Q8=$S$3","v":false},{"$f":"S8=$S$3","v":false},{"$f":"U8=$S$3","v":true},{"$f":"X8=$S$3","v":false},{"$f":"Z8=$S$3","v":false},{"$f":"AB8=$S$3","v":false},{"$f":"AND(AI8,AJ8,AK8)","v":false},{"$f":"AND(AL8,AM8,AN8)","v":false},{"$f":"AND(AO8,AP8,AQ8)","v":false},{"$f":"OR(AR8,AS8,AT8)","v":false}]
[1,"Op","Bennaoui","Najia","SC Hamm",1992,"F-CL-PL",85,{"$f":"IF(H9=\"\",\"\",VLOOKUP(H9,WeightClasses!$A$2:$E$18,IF(LEFT(G9,1)=\"F\",IF(YEAR(TODAY())-F9<24,4,2),IF(YEAR(TODAY())-F9<24,5,3)),TRUE))","v":"84+"},"√",147.5,"+",155.5,"+",158.5,158.5,"√",80,"×",85,"×",85,80,"√",150,"√",160,"×",172.5,160,398.5,74.912819499999998,{"$f":"IF(OR(H9=\"\",H9=0),0, ROUND(100/(VLOOKUP($G9,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G9,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G9,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H9)),6))","v":0.18798699999999999},null,false,false,false,false,true,true,false,false,true,false,false,false,false]
[1,"Op","Giacomini","Laura","SC Hamm",1990,"F-CL-PL",84.85,{"$f":"IF(H10=\"\",\"\",VLOOKUP(H10,WeightClasses!$A$2:$E$18,IF(LEFT(G10,1)=\"F\",IF(YEAR(TODAY())-F10<24,4,2),IF(YEAR(TODAY())-F10<24,5,3)),TRUE))","v":"84+"},"√",117.5,"√",122.5,"√",125,125,"√",57.5,"×",62.5,"×",62.5,57.5,"√",130,"√",137.5,"√",142.5,142.5,325,61.137374999999999,{"$f":"IF(OR(H10=\"\",H10=0),0, ROUND(100/(VLOOKUP($G10,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G10,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G10,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H10)),6))","v":0.188115},null,false,false,false,false,true,true,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",VLOOKUP(H11,WeightClasses!$A$2:$E$18,IF(LEFT(G11,1)=\"F\",IF(YEAR(TODAY())-F11<24,4,2),IF(YEAR(TODAY())-F11<24,5,3)),TRUE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(K11<>0,M11<>0,O11<>0),MAX(IF(OR(J11=$S$1,J11=$S$2),K11,0),IF(OR(L11=$S$1,L11=$S$2),M11,0),IF(OR(N11=$S$1,N11=$S$2),O11,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(R11<>0,T11<>0,V11<>0),MAX(IF(OR(Q11=$S$1,Q11=$S$2),R11,0),IF(OR(S11=$S$1,S11=$S$2),T11,0),IF(OR(U11=$S$1,U11=$S$2),V11,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(Y11<>0,AA11<>0,AC11<>0),MAX(IF(OR(X11=$S$1,X11=$S$2),Y11,0),IF(OR(Z11=$S$1,Z11=$S$2),AA11,0),IF(OR(AB11=$S$1,AB11=$S$2),AC11,0)),\"\")","v":""},{"$f":"IF(OR(P11<>\"\",W11<>\"\",AD11<>\"\"),IF(AU11,\"DSQ\",IF(AND(RIGHT(G11,2)=\"PL\"),IF(P11=\"\",0,P11)+IF(W11=\"\",0,W11)+IF(AD11=\"\",0,AD11),IF(AND(RIGHT(G11,2)=\"BP\",W11<>0),W11,IF(AND(RIGHT(G11,2)=\"DL\",AD11<>0),AD11,IF(AND(RIGHT(G11,2)=\"SQ\",P11<>0),P11,0))))),\"\")","v":""},{"$f":"SUM(AF6:AF9)","v":284.46435100000002},{"$f":"IF(OR(H11=\"\",H11=0),0, ROUND(100/(VLOOKUP($G11,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G11,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G11,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H11)),6))","v":0},2,{"$f":"J11=$S$3","v":false},{"$f":"L11=$S$3","v":false},{"$f":"N11=$S$3","v":false},{"$f":"Q11=$S$3","v":false},{"$f":"S11=$S$3","v":false},{"$f":"U11=$S$3","v":false},{"$f":"X11=$S$3","v":false},{"$f":"Z11=$S$3","v":false},{"$f":"AB11=$S$3","v":false},{"$f":"AND(AI11,AJ11,AK11)","v":false},{"$f":"AND(AL11,AM11,AN11)","v":false},{"$f":"AND(AO11,AP11,AQ11)","v":false},{"$f":"OR(AR11,AS11,AT11)","v":false}]
[1,"Op","Castro","Emma","Silverbacks",1999,"F-CL-PL",61.81,{"$f":"IF(H12=\"\",\"\",VLOOKUP(H12,WeightClasses!$A$2:$E$18,IF(LEFT(G12,1)=\"F\",IF(YEAR(TODAY())-F12<24,4,2),IF(YEAR(TODAY())-F12<24,5,3)),TRUE))","v":63},"√",95,"√",100,"√",102.5,102.5,"√",45,"√",50,"×",52.5,50,"√",115,"√",120,"√",125,125,277.5,61.4737425,{"$f":"IF(OR(H12=\"\",H12=0),0, ROUND(100/(VLOOKUP($G12,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G12,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G12,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H12)),6))","v":0.221527},null,false,false,false,false,false,true,false,false,false,false,false,false,false]
[1,"Op","Baustert","Nadia","Silverbacks",1999,"F-CL-PL",61.61,{"$f":"IF(H13=\"\",\"\",VLOOKUP(H13,WeightClasses!$A$2:$E$18,IF(LEFT(G13,1)=\"F\",IF(YEAR(TODAY())-F13<24,4,2),IF(YEAR(TODAY())-F13<24,5,3)),TRUE))","v":63},"+",137.5,"+",142.5,"×",145,142.5,"√",80,"×",83,"×",83,80,"√",152.5,"×",155,"×",155,152.5,375,83.251874999999998,{"$f":"IF(OR(H13=\"\",H13=0),0, ROUND(100/(VLOOKUP($G13,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G13,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G13,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H13)),6))","v":0.22200500000000001},1,false,false,true,false,true,true,false,true,true,false,false,false,false]
[1,"Op","Weber","Elyna","Silverbacks",1997,"F-CL-PL",82.83,{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,WeightClasses!$A$2:$E$18,IF(LEFT(G14,1)=\"F\",IF(YEAR(TODAY())-F14<24,4,2),IF(YEAR(TODAY())-F14<24,5,3)),TRUE))","v":84},"√",135,"√",142.5,"×",147.5,142.5,"√",77.5,"√",82.5,"√",85,85,"√",145,"√",152.5,"√",160,160,387.5,{"$f":"IF(AND(AE14<>\"\",ISNUMBER(AE14)),AG14*AE14,\"\")","v":73.586637499999995},{"$f":"IF(OR(H14=\"\",H14=0),0, ROUND(100/(VLOOKUP($G14,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G14,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G14,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H14)),6))","v":0.18990099999999999},null,false,false,true,false,false,false,false,false,false,false,false,false,false]
[1,"Op","Ewert","Manuela","Silverbacks",1995,"F-CL-PL",82.52,{"$f":"IF(H15=\"\",\"\",VLOOKUP(H15,WeightClasses!$A$2:$E$18,IF(LEFT(G15,1)=\"F\",IF(YEAR(TODAY())-F15<24,4,2),IF(YEAR(TODAY())-F15<24,5,3)),TRUE))","v":84},"√",135,"√",142.5,"×",147.5,142.5,"√",55,"√",60,"√",62.5,62.5,"√",145,"√",155,"×",160,155,360,{"$f":"IF(AND(AE15<>\"\",ISNUMBER(AE15)),AG15*AE15,\"\")","v":68.467680000000001},{"$f":"IF(OR(H15=\"\",H15=0),0, ROUND(100/(VLOOKUP($G15,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G15,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G15,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H15)),6))","v":0.190188},null,false,false,true,false,false,false,false,false,true,false,false,false,false]
[null,null,null,null,null,null,null,null,{"$f":"IF(H16=\"\",\"\",VLOOKUP(H16,WeightClasses!$A$2:$E$18,IF(LEFT(G16,1)=\"F\",IF(YEAR(TODAY())-F16<24,4,2),IF(YEAR(TODAY())-F16<24,5,3)),TRUE))","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","",{"$f":"SUM(AF12:AF15)","v":286.77993500000002},{"$f":"IF(OR(H16=\"\",H16=0),0, ROUND(100/(VLOOKUP($G16,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G16,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G16,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H16)),6))","v":0},1,false,false,false,false,false,false,false,false,false,false,false,false,false]
[2,"Sj","Best","Jonah","SC Hamm",2009,"M-CL-PL",60.74,{"$f":"IF(H17=\"\",\"\",VLOOKUP(H17,WeightClasses!$A$2:$E$18,IF(LEFT(G17,1)=\"F\",IF(YEAR(TODAY())-F17<24,4,2),IF(YEAR(TODAY())-F17<24,5,3)),TRUE))","v":66},"√",95,"√",102.5,"√",110,110,"√",65,"√",72.5,"×",77.5,72.5,"√",115,"√",125,"√",135,135,317.5,51.727417500000001,{"$f":"IF(OR(H17=\"\",H17=0),0, ROUND(100/(VLOOKUP($G17,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G17,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G17,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H17)),6))","v":0.16292100000000001},null,false,false,false,false,false,true,false,false,false,false,false,false,false]
[2,"Sj","Vicente Santana","Thomas","SC Hamm",2006,"M-CL-PL",75.73,{"$f":"IF(H18=\"\",\"\",VLOOKUP(H18,WeightClasses!$A$2:$E$18,IF(LEFT(G18,1)=\"F\",IF(YEAR(TODAY())-F18<24,4,2),IF(YEAR(TODAY())-F18<24,5,3)),TRUE))","v":83},"√",180,"+",192.5,"+",200,200,"+",135,"+",137.5,"+",140,140,"√",207.5,"+",220.5,"×",225,220.5,560.5,81.308372000000006,{"$f":"IF(OR(H18=\"\",H18=0),0, ROUND(100/(VLOOKUP($G18,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G18,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G18,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H18)),6))","v":0.145064},null,false,false,false,false,false,false,false,false,true,false,false,false,false]
[2,"Sj","Ferreira","Aaron","SC Hamm",2006,"M-CL-PL",114.08,{"$f":"IF(H19=\"\",\"\",VLOOKUP(H19,WeightClasses!$A$2:$E$18,IF(LEFT(G19,1)=\"F\",IF(YEAR(TODAY())-F19<24,4,2),IF(YEAR(TODAY())-F19<24,5,3)),TRUE))","v":120},"√",195,"√",207.5,"×",212.5,207.5,"√",130,"√",137.5,"×",140,137.5,"√",195,"√",210,"√",220,220,565,67.164374999999993,{"$f":"IF(OR(H19=\"\",H19=0),0, ROUND(100/(VLOOKUP($G19,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G19,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G19,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H19)),6))","v":0.11887499999999999},null,false,false,true,false,false,true,false,false,false,false,false,false,false]
[2,"Jr","Scheepers","Ethan","SC Hamm",2005,"M-CL-PL",73.02,{"$f":"IF(H20=\"\",\"\",VLOOKUP(H20,WeightClasses!$A$2:$E$18,IF(LEFT(G20,1)=\"F\",IF(YEAR(TODAY())-F20<24,4,2),IF(YEAR(TODAY())-F20<24,5,3)),TRUE))","v":74},"√",155,"√",162.5,"×",170,162.5,"√",95,"√",100,"√",105,105,"√",195,"√",210,"+",214.5,214.5,482,71.254059999999996,{"$f":"IF(OR(H20=\"\",H20=0),0, ROUND(100/(VLOOKUP($G20,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G20,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G20,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H20)),6))","v":0.14782999999999999},null,false,false,true,false,false,false,false,false,false,false,false,false,false]
[2,"Jr","Toth","Bela","SC Hamm",2005,"M-CL-PL",78.319999999999993,{"$f":"IF(H21=\"\",\"\",VLOOKUP(H21,WeightClasses!$A$2:$E$18,IF(LEFT(G21,1)=\"F\",IF(YEAR(TODAY())-F21<24,4,2),IF(YEAR(TODAY())-F21<24,5,3)),TRUE))","v":83},"√",120,"√",130,"√",140,140,"√",90,"√",95,"√",100,100,"√",160,"√",170,"√",182.5,182.5,422.5,60.23836,{"$f":"IF(OR(H21=\"\",H21=0),0, ROUND(100/(VLOOKUP($G21,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G21,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G21,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H21)),6))","v":0.14257600000000001},null,false,false,false,false,false,false,false,false,false,false,false,false,false]
[2,"Jr","Feiereisen","Ben","SC Hamm",2004,"M-CL-PL",90.47,{"$f":"IF(H22=\"\",\"\",VLOOKUP(H22,WeightClasses!$A$2:$E$18,IF(LEFT(G22,1)=\"F\",IF(YEAR(TODAY())-F22<24,4,2),IF(YEAR(TODAY())-F22<24,5,3)),TRUE))","v":93},"√",180,"√",187.5,"√",192.5,192.5,"√",100,"√",105,"√",107.5,107.5,"√",200,"√",215,"√",222.5,222.5,522.5,69.284022499999992,{"$f":"IF(OR(H22=\"\",H22=0),0, ROUND(100/(VLOOKUP($G22,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G22,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G22,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H22)),6))","v":0.132601},null,false,false,false,false,false,false,false,false,false,false,false,false,false]
[2,"Jr","Matos Pedroso","Daniel","SC Hamm",2001,"M-CL-PL",88.49,{"$f":"IF(H23=\"\",\"\",VLOOKUP(H23,WeightClasses!$A$2:$E$18,IF(LEFT(G23,1)=\"F\",IF(YEAR(TODAY())-F23<24,4,2),IF(YEAR(TODAY())-F23<24,5,3)),TRUE))","v":93},"√",170,"√",185,"√",195,195,"√",95,"√",102.5,"√",107.5,107.5,"√",180,"√",200,"×",210,200,502.5,67.364647500000004,{"$f":"IF(OR(H23=\"\",H23=0),0, ROUND(100/(VLOOKUP($G23,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G23,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G23,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H23)),6))","v":0.13405900000000001},null,false,false,false,false,false,false,false,false,true,false,false,false,false]
[2,"Jr","Parage","Philippe","SC Hamm",2001,"M-CL-PL",124.02,{"$f":"IF(H24=\"\",\"\",VLOOKUP(H24,WeightClasses!$A$2:$E$18,IF(LEFT(G24,1)=\"F\",IF(YEAR(TODAY())-F24<24,4,2),IF(YEAR(TODAY())-F24<24,5,3)),TRUE))","v":"120+"},"√",270,"√",282.5,"+",290,290,"√",160,"×",165,"×",165,160,"√",275,"√",285,"×",293,285,735,84.232469999999992,{"$f":"IF(OR(H24=\"\",H24=0),0, ROUND(100/(VLOOKUP($G24,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G24,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G24,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H24)),6))","v":0.114602},null,false,false,false,false,true,true,false,false,true,false,false,false,false]
[3,"Op","Nilles","Kevin","SC Hamm",1998,"M-CL-PL",68.58,{"$f":"IF(H25=\"\",\"\",VLOOKUP(H25,WeightClasses!$A$2:$E$18,IF(LEFT(G25,1)=\"F\",IF(YEAR(TODAY())-F25<24,4,2),IF(YEAR(TODAY())-F25<24,5,3)),TRUE))","v":74},"√",177.5,"√",187.5,"×",195.5,{"$f":"IF(OR(K25<>0,M25<>0,O25<>0),MAX(IF(OR(J25=$S$1,J25=$S$2),K25,0),IF(OR(L25=$S$1,L25=$S$2),M25,0),IF(OR(N25=$S$1,N25=$S$2),O25,0)),\"\")","v":187.5},"√",97.5,"×",102.5,"√",102.5,{"$f":"IF(OR(R25<>0,T25<>0,V25<>0),MAX(IF(OR(Q25=$S$1,Q25=$S$2),R25,0),IF(OR(S25=$S$1,S25=$S$2),T25,0),IF(OR(U25=$S$1,U25=$S$2),V25,0)),\"\")","v":102.5},"√",212.5,"√",220,"+",224,{"$f":"IF(OR(Y25<>0,AA25<>0,AC25<>0),MAX(IF(OR(X25=$S$1,X25=$S$2),Y25,0),IF(OR(Z25=$S$1,Z25=$S$2),AA25,0),IF(OR(AB25=$S$1,AB25=$S$2),AC25,0)),\"\")","v":224},{"$f":"IF(OR(P25<>\"\",W25<>\"\",AD25<>\"\"),IF(AU25,\"DSQ\",IF(AND(RIGHT(G25,2)=\"PL\"),IF(P25=\"\",0,P25)+IF(W25=\"\",0,W25)+IF(AD25=\"\",0,AD25),IF(AND(RIGHT(G25,2)=\"BP\",W25<>0),W25,IF(AND(RIGHT(G25,2)=\"DL\",AD25<>0),AD25,IF(AND(RIGHT(G25,2)=\"SQ\",P25<>0),P25,0))))),\"\")","v":514},{"$f":"IF(AND(AE25<>\"\",ISNUMBER(AE25)),AG25*AE25,\"\")","v":78.520182000000005},{"$f":"IF(OR(H25=\"\",H25=0),0, ROUND(100/(VLOOKUP($G25,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G25,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G25,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H25)),6))","v":0.15276300000000001},null,{"$f":"J25=$S$3","v":false},{"$f":"L25=$S$3","v":false},{"$f":"N25=$S$3","v":true},{"$f":"Q25=$S$3","v":false},{"$f":"S25=$S$3","v":true},{"$f":"U25=$S$3","v":false},{"$f":"X25=$S$3","v":false},{"$f":"Z25=$S$3","v":false},{"$f":"AB25=$S$3","v":false},{"$f":"AND(AI25,AJ25,AK25)","v":false},{"$f":"AND(AL25,AM25,AN25)","v":false},{"$f":"AND(AO25,AP25,AQ25)","v":false},{"$f":"OR(AR25,AS25,AT25)","v":false}]
[3,"Op","Ndoja","Gabriel","SC Hamm",1995,"M-EQ-PL",119.45,{"$f":"IF(H26=\"\",\"\",VLOOKUP(H26,WeightClasses!$A$2:$E$18,IF(LEFT(G26,1)=\"F\",IF(YEAR(TODAY())-F26<24,4,2),IF(YEAR(TODAY())-F26<24,5,3)),TRUE))","v":120},"√",255,"√",265,"×",270,{"$f":"IF(OR(K26<>0,M26<>0,O26<>0),MAX(IF(OR(J26=$S$1,J26=$S$2),K26,0),IF(OR(L26=$S$1,L26=$S$2),M26,0),IF(OR(N26=$S$1,N26=$S$2),O26,0)),\"\")","v":265},"√",175,"√",180,"√",185,{"$f":"IF(OR(R26<>0,T26<>0,V26<>0),MAX(IF(OR(Q26=$S$1,Q26=$S$2),R26,0),IF(OR(S26=$S$1,S26=$S$2),T26,0),IF(OR(U26=$S$1,U26=$S$2),V26,0)),\"\")","v":185},"√",250,"√",260,"×",0,{"$f":"IF(OR(Y26<>0,AA26<>0,AC26<>0),MAX(IF(OR(X26=$S$1,X26=$S$2),Y26,0),IF(OR(Z26=$S$1,Z26=$S$2),AA26,0),IF(OR(AB26=$S$1,AB26=$S$2),AC26,0)),\"\")","v":260},{"$f":"IF(OR(P26<>\"\",W26<>\"\",AD26<>\"\"),IF(AU26,\"DSQ\",IF(AND(RIGHT(G26,2)=\"PL\"),IF(P26=\"\",0,P26)+IF(W26=\"\",0,W26)+IF(AD26=\"\",0,AD26),IF(AND(RIGHT(G26,2)=\"BP\",W26<>0),W26,IF(AND(RIGHT(G26,2)=\"DL\",AD26<>0),AD26,IF(AND(RIGHT(G26,2)=\"SQ\",P26<>0),P26,0))))),\"\")","v":710},{"$f":"IF(AND(AE26<>\"\",ISNUMBER(AE26)),AG26*AE26,\"\")","v":68.739360000000005},{"$f":"IF(OR(H26=\"\",H26=0),0, ROUND(100/(VLOOKUP($G26,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G26,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G26,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H26)),6))","v":9.6815999999999999E-2},null,{"$f":"J26=$S$3","v":false},{"$f":"L26=$S$3","v":false},{"$f":"N26=$S$3","v":true},{"$f":"Q26=$S$3","v":false},{"$f":"S26=$S$3","v":false},{"$f":"U26=$S$3","v":false},{"$f":"X26=$S$3","v":false},{"$f":"Z26=$S$3","v":false},{"$f":"AB26=$S$3","v":true},{"$f":"AND(AI26,AJ26,AK26)","v":false},{"$f":"AND(AL26,AM26,AN26)","v":false},{"$f":"AND(AO26,AP26,AQ26)","v":false},{"$f":"OR(AR26,AS26,AT26)","v":false}]
[3,"Jr","Pouanouko","Issah","SC Hamm",2001,"M-CL-PL",94.69,{"$f":"IF(H27=\"\",\"\",VLOOKUP(H27,WeightClasses!$A$2:$E$18,IF(LEFT(G27,1)=\"F\",IF(YEAR(TODAY())-F27<24,4,2),IF(YEAR(TODAY())-F27<24,5,3)),TRUE))","v":105},"√",217.5,"√",230,"√",235,235,"√",142.5,"√",150,"×",152.5,150,"√",230,"√",245,"√",252.5,252.5,637.5,82.671637499999989,{"$f":"IF(OR(H27=\"\",H27=0),0, ROUND(100/(VLOOKUP($G27,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G27,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G27,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H27)),6))","v":0.12968099999999999},null,false,false,false,false,false,true,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,WeightClasses!$A$2:$E$18,IF(LEFT(G28,1)=\"F\",IF(YEAR(TODAY())-F28<24,4,2),IF(YEAR(TODAY())-F28<24,5,3)),TRUE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(K28<>0,M28<>0,O28<>0),MAX(IF(OR(J28=$S$1,J28=$S$2),K28,0),IF(OR(L28=$S$1,L28=$S$2),M28,0),IF(OR(N28=$S$1,N28=$S$2),O28,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(R28<>0,T28<>0,V28<>0),MAX(IF(OR(Q28=$S$1,Q28=$S$2),R28,0),IF(OR(S28=$S$1,S28=$S$2),T28,0),IF(OR(U28=$S$1,U28=$S$2),V28,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(Y28<>0,AA28<>0,AC28<>0),MAX(IF(OR(X28=$S$1,X28=$S$2),Y28,0),IF(OR(Z28=$S$1,Z28=$S$2),AA28,0),IF(OR(AB28=$S$1,AB28=$S$2),AC28,0)),\"\")","v":""},{"$f":"IF(OR(P28<>\"\",W28<>\"\",AD28<>\"\"),IF(AU28,\"DSQ\",IF(AND(RIGHT(G28,2)=\"PL\"),IF(P28=\"\",0,P28)+IF(W28=\"\",0,W28)+IF(AD28=\"\",0,AD28),IF(AND(RIGHT(G28,2)=\"BP\",W28<>0),W28,IF(AND(RIGHT(G28,2)=\"DL\",AD28<>0),AD28,IF(AND(RIGHT(G28,2)=\"SQ\",P28<>0),P28,0))))),\"\")","v":""},{"$f":"AF27+AF25+AF24+AF20+AF18","v":397.98672149999999},{"$f":"IF(OR(H28=\"\",H28=0),0, ROUND(100/(VLOOKUP($G28,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G28,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G28,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H28)),6))","v":0},1,{"$f":"J28=$S$3","v":false},{"$f":"L28=$S$3","v":false},{"$f":"N28=$S$3","v":false},{"$f":"Q28=$S$3","v":false},{"$f":"S28=$S$3","v":false},{"$f":"U28=$S$3","v":false},{"$f":"X28=$S$3","v":false},{"$f":"Z28=$S$3","v":false},{"$f":"AB28=$S$3","v":false},{"$f":"AND(AI28,AJ28,AK28)","v":false},{"$f":"AND(AL28,AM28,AN28)","v":false},{"$f":"AND(AO28,AP28,AQ28)","v":false},{"$f":"OR(AR28,AS28,AT28)","v":false}]
[2,"Jr","Brazas ","Konstantinas","Silverbacks",2004,"M-CL-PL",90.1,{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,WeightClasses!$A$2:$E$18,IF(LEFT(G29,1)=\"F\",IF(YEAR(TODAY())-F29<24,4,2),IF(YEAR(TODAY())-F29<24,5,3)),TRUE))","v":93},"√",175,"√",185,"√",190,190,"√",105,"√",110,"×",0,110,"√",185,"√",192.5,"×",200,192.5,492.5,{"$f":"IF(AND(AE29<>\"\",ISNUMBER(AE29)),AG29*AE29,\"\")","v":65.43798249999999},{"$f":"IF(OR(H29=\"\",H29=0),0, ROUND(100/(VLOOKUP($G29,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G29,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G29,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H29)),6))","v":0.13286899999999999},null,false,false,false,false,false,true,false,false,true,false,false,false,false]
[3,"Op","Macchi","Mirko","Silverbacks",1998,"M-CL-PL",82.58,{"$f":"IF(H30=\"\",\"\",VLOOKUP(H30,WeightClasses!$A$2:$E$18,IF(LEFT(G30,1)=\"F\",IF(YEAR(TODAY())-F30<24,4,2),IF(YEAR(TODAY())-F30<24,5,3)),TRUE))","v":83},"√",215,"√",225,"√",230,230,"√",155,"×",162.5,"×",162.5,155,"√",270,"√",285,"×",300,285,670,92.98393999999999,{"$f":"IF(OR(H30=\"\",H30=0),0, ROUND(100/(VLOOKUP($G30,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G30,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G30,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H30)),6))","v":0.13878199999999999},1,false,false,false,false,true,true,false,false,true,false,false,false,false]
[3,"Op","Tavares","Dylan","Silverbacks",1995,"M-CL-PL",92.8,{"$f":"IF(H31=\"\",\"\",VLOOKUP(H31,WeightClasses!$A$2:$E$18,IF(LEFT(G31,1)=\"F\",IF(YEAR(TODAY())-F31<24,4,2),IF(YEAR(TODAY())-F31<24,5,3)),TRUE))","v":93},"√",165,"√",175,"√",187.5,{"$f":"IF(OR(K31<>0,M31<>0,O31<>0),MAX(IF(OR(J31=$S$1,J31=$S$2),K31,0),IF(OR(L31=$S$1,L31=$S$2),M31,0),IF(OR(N31=$S$1,N31=$S$2),O31,0)),\"\")","v":187.5},"√",105,"√",115,"×",120,{"$f":"IF(OR(R31<>0,T31<>0,V31<>0),MAX(IF(OR(Q31=$S$1,Q31=$S$2),R31,0),IF(OR(S31=$S$1,S31=$S$2),T31,0),IF(OR(U31=$S$1,U31=$S$2),V31,0)),\"\")","v":115},"√",240,"√",270,"×",288,{"$f":"IF(OR(Y31<>0,AA31<>0,AC31<>0),MAX(IF(OR(X31=$S$1,X31=$S$2),Y31,0),IF(OR(Z31=$S$1,Z31=$S$2),AA31,0),IF(OR(AB31=$S$1,AB31=$S$2),AC31,0)),\"\")","v":270},{"$f":"IF(OR(P31<>\"\",W31<>\"\",AD31<>\"\"),IF(AU31,\"DSQ\",IF(AND(RIGHT(G31,2)=\"PL\"),IF(P31=\"\",0,P31)+IF(W31=\"\",0,W31)+IF(AD31=\"\",0,AD31),IF(AND(RIGHT(G31,2)=\"BP\",W31<>0),W31,IF(AND(RIGHT(G31,2)=\"DL\",AD31<>0),AD31,IF(AND(RIGHT(G31,2)=\"SQ\",P31<>0),P31,0))))),\"\")","v":572.5},{"$f":"IF(AND(AE31<>\"\",ISNUMBER(AE31)),AG31*AE31,\"\")","v":74.974027499999991},{"$f":"IF(OR(H31=\"\",H31=0),0, ROUND(100/(VLOOKUP($G31,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G31,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G31,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H31)),6))","v":0.13095899999999999},null,{"$f":"J31=$S$3","v":false},{"$f":"L31=$S$3","v":false},{"$f":"N31=$S$3","v":false},{"$f":"Q31=$S$3","v":false},{"$f":"S31=$S$3","v":false},{"$f":"U31=$S$3","v":true},{"$f":"X31=$S$3","v":false},{"$f":"Z31=$S$3","v":false},{"$f":"AB31=$S$3","v":true},{"$f":"AND(AI31,AJ31,AK31)","v":false},{"$f":"AND(AL31,AM31,AN31)","v":false},{"$f":"AND(AO31,AP31,AQ31)","v":false},{"$f":"OR(AR31,AS31,AT31)","v":false}]
[3,"Op","Loconte","Sebastiano","Silverbacks",1996,"M-CL-PL",90.05,{"$f":"IF(H32=\"\",\"\",VLOOKUP(H32,WeightClasses!$A$2:$E$18,IF(LEFT(G32,1)=\"F\",IF(YEAR(TODAY())-F32<24,4,2),IF(YEAR(TODAY())-F32<24,5,3)),TRUE))","v":93},"√",175,"√",182.5,"√",190,{"$f":"IF(OR(K32<>0,M32<>0,O32<>0),MAX(IF(OR(J32=$S$1,J32=$S$2),K32,0),IF(OR(L32=$S$1,L32=$S$2),M32,0),IF(OR(N32=$S$1,N32=$S$2),O32,0)),\"\")","v":190},"√",120,"√",125,"√",130,{"$f":"IF(OR(R32<>0,T32<>0,V32<>0),MAX(IF(OR(Q32=$S$1,Q32=$S$2),R32,0),IF(OR(S32=$S$1,S32=$S$2),T32,0),IF(OR(U32=$S$1,U32=$S$2),V32,0)),\"\")","v":130},"√",190,"√",200,"×",205,{"$f":"IF(OR(Y32<>0,AA32<>0,AC32<>0),MAX(IF(OR(X32=$S$1,X32=$S$2),Y32,0),IF(OR(Z32=$S$1,Z32=$S$2),AA32,0),IF(OR(AB32=$S$1,AB32=$S$2),AC32,0)),\"\")","v":200},{"$f":"IF(OR(P32<>\"\",W32<>\"\",AD32<>\"\"),IF(AU32,\"DSQ\",IF(AND(RIGHT(G32,2)=\"PL\"),IF(P32=\"\",0,P32)+IF(W32=\"\",0,W32)+IF(AD32=\"\",0,AD32),IF(AND(RIGHT(G32,2)=\"BP\",W32<>0),W32,IF(AND(RIGHT(G32,2)=\"DL\",AD32<>0),AD32,IF(AND(RIGHT(G32,2)=\"SQ\",P32<>0),P32,0))))),\"\")","v":520},{"$f":"IF(AND(AE32<>\"\",ISNUMBER(AE32)),AG32*AE32,\"\")","v":69.11112},{"$f":"IF(OR(H32=\"\",H32=0),0, ROUND(100/(VLOOKUP($G32,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G32,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G32,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H32)),6))","v":0.132906},null,{"$f":"J32=$S$3","v":false},{"$f":"L32=$S$3","v":false},{"$f":"N32=$S$3","v":false},{"$f":"Q32=$S$3","v":false},{"$f":"S32=$S$3","v":false},{"$f":"U32=$S$3","v":false},{"$f":"X32=$S$3","v":false},{"$f":"Z32=$S$3","v":false},{"$f":"AB32=$S$3","v":true},{"$f":"AND(AI32,AJ32,AK32)","v":false},{"$f":"AND(AL32,AM32,AN32)","v":false},{"$f":"AND(AO32,AP32,AQ32)","v":false},{"$f":"OR(AR32,AS32,AT32)","v":false}]
[3,"Op","Gasparro","Tiziano","Silverbacks",1978,"M-CL-PL",99.4,{"$f":"IF(H33=\"\",\"\",VLOOKUP(H33,WeightClasses!$A$2:$E$18,IF(LEFT(G33,1)=\"F\",IF(YEAR(TODAY())-F33<24,4,2),IF(YEAR(TODAY())-F33<24,5,3)),TRUE))","v":105},"√",200,"√",212.5,"×",225,212.5,"√",132.5,"√",137.5,"√",142.5,142.5,"√",200,"√",207.5,"×",210,207.5,562.5,71.263687500000003,{"$f":"IF(OR(H33=\"\",H33=0),0, ROUND(100/(VLOOKUP($G33,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G33,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G33,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H33)),6))","v":0.126691},null,false,false,true,false,false,false,false,false,true,false,false,false,false]
[3,"M1","Bomfina","Joao","Silverbacks",1978,"M-CL-PL",93.07,{"$f":"IF(H34=\"\",\"\",VLOOKUP(H34,WeightClasses!$A$2:$E$18,IF(LEFT(G34,1)=\"F\",IF(YEAR(TODAY())-F34<24,4,2),IF(YEAR(TODAY())-F34<24,5,3)),TRUE))","v":105},"√",170,"√",182.5,"√",190,190,"√",95,"×",100,"×",102.5,95,"√",180,"√",195,"√",207.5,207.5,492.5,64.405702500000004,{"$f":"IF(OR(H34=\"\",H34=0),0, ROUND(100/(VLOOKUP($G34,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G34,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G34,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H34)),6))","v":0.130773}," ",false,false,false,false,true,true,false,false,false,false,false,false,false]
[3,"M2","Matt","Vincent","Silverbacks",1967,"M-CL-PL",102.65,{"$f":"IF(H35=\"\",\"\",VLOOKUP(H35,WeightClasses!$A$2:$E$18,IF(LEFT(G35,1)=\"F\",IF(YEAR(TODAY())-F35<24,4,2),IF(YEAR(TODAY())-F35<24,5,3)),TRUE))","v":105},"√",80,"×",0,"×",0,80,"√",150,"+",157.5,"×",160,157.5,"√",135,"×",0,"×",0,135,372.5,46.479804999999999,{"$f":"IF(OR(H35=\"\",H35=0),0, ROUND(100/(VLOOKUP($G35,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G35,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G35,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H35)),6))","v":0.124778},null,false,true,true,false,false,true,false,true,true,false,false,false,false]
[null,null,null,null,null,null,null,null,{"$f":"IF(H36=\"\",\"\",VLOOKUP(H36,WeightClasses!$A$2:$E$18,IF(LEFT(G36,1)=\"F\",IF(YEAR(TODAY())-F36<24,4,2),IF(YEAR(TODAY())-F36<24,5,3)),TRUE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(K36<>0,M36<>0,O36<>0),MAX(IF(OR(J36=$S$1,J36=$S$2),K36,0),IF(OR(L36=$S$1,L36=$S$2),M36,0),IF(OR(N36=$S$1,N36=$S$2),O36,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(R36<>0,T36<>0,V36<>0),MAX(IF(OR(Q36=$S$1,Q36=$S$2),R36,0),IF(OR(S36=$S$1,S36=$S$2),T36,0),IF(OR(U36=$S$1,U36=$S$2),V36,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(Y36<>0,AA36<>0,AC36<>0),MAX(IF(OR(X36=$S$1,X36=$S$2),Y36,0),IF(OR(Z36=$S$1,Z36=$S$2),AA36,0),IF(OR(AB36=$S$1,AB36=$S$2),AC36,0)),\"\")","v":""},{"$f":"IF(OR(P36<>\"\",W36<>\"\",AD36<>\"\"),IF(AU36,\"DSQ\",IF(AND(RIGHT(G36,2)=\"PL\"),IF(P36=\"\",0,P36)+IF(W36=\"\",0,W36)+IF(AD36=\"\",0,AD36),IF(AND(RIGHT(G36,2)=\"BP\",W36<>0),W36,IF(AND(RIGHT(G36,2)=\"DL\",AD36<>0),AD36,IF(AND(RIGHT(G36,2)=\"SQ\",P36<>0),P36,0))))),\"\")","v":""},{"$f":"SUM(AF29:AF33)","v":373.7707575},{"$f":"IF(OR(H36=\"\",H36=0),0, ROUND(100/(VLOOKUP($G36,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G36,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G36,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H36)),6))","v":0},2,{"$f":"J36=$S$3","v":false},{"$f":"L36=$S$3","v":false},{"$f":"N36=$S$3","v":false},{"$f":"Q36=$S$3","v":false},{"$f":"S36=$S$3","v":false},{"$f":"U36=$S$3","v":false},{"$f":"X36=$S$3","v":false},{"$f":"Z36=$S$3","v":false},{"$f":"AB36=$S$3","v":false},{"$f":"AND(AI36,AJ36,AK36)","v":false},{"$f":"AND(AL36,AM36,AN36)","v":false},{"$f":"AND(AO36,AP36,AQ36)","v":false},{"$f":"OR(AR36,AS36,AT36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H37=\"\",\"\",VLOOKUP(H37,WeightClasses!$A$2:$E$18,IF(LEFT(G37,1)=\"F\",IF(YEAR(TODAY())-F37<24,4,2),IF(YEAR(TODAY())-F37<24,5,3)),TRUE))","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H37=\"\",H37=0),0, ROUND(100/(VLOOKUP($G37,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G37,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G37,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H37)),6))","v":0},null,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,{"$f":"IF(H38=\"\",\"\",VLOOKUP(H38,WeightClasses!$A$2:$E$18,IF(LEFT(G38,1)=\"F\",IF(YEAR(TODAY())-F38<24,4,2),IF(YEAR(TODAY())-F38<24,5,3)),TRUE))","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H38=\"\",H38=0),0, ROUND(100/(VLOOKUP($G38,'IPF GL Formula'!$A$4:$F$19,3,FALSE)-VLOOKUP($G38,'IPF GL Formula'!$A$4:$F$19,4,FALSE)*EXP(-VLOOKUP($G38,'IPF GL Formula'!$A$4:$F$19,5,FALSE)*H38)),6))","v":0},null,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,null,"Side referee",null,null,"Center referee",null,null,"Side referee"]

{"sheet":"Instructions","index":1,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,"1.  Enter lifter information into the spreadsheet in the approriate columns.  Column titles can be changed or Translated to another language after Unprotecting the Spreadsheet."]
[null,null,"A separate Scoresheet can be created for each Men/Women, Classic/Equipped, Powerlifting/Bench Press or they may all be entered on the same scoresheet."]
[]
[null,"2.  When Birth Year and Body Weight are entered the will automatically determine the correct WT Class."]
[]
[null,"3.  Any of the 8 IPF GL Formulas can be selected for a lifter.  A description of the each formula can be found on the IPF GL Formula sheet.  Use the drop down menu in the cell."]
[null,null,"Lifter1 in the first row is entered in Female-Classic-Powerlifting.  The IPF Formula to calculate her IPF Points is F-CL-PL."]
[]
[null,"4.  The gray areas contain formulas and information that will be protected when you Protect the spreadsheet "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.  You may unprotect the Scoresheet to use the sort functions in Excel to group competitors by weight class, age division, or IPF GL Formula."]
[]
[null,"6.  When a lifter completes an attempt, click in the cell next to the weight."]
[null,null,"For a Good Lift select √.  The cell will turn green. Example:  Osmialowski, SQ-1."]
[null,null,"For a No Lift select ×.  The cell will turn pink with a strikethrough font. Example:  Kupperstein, SQ-1."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7.  When Bench Press only lifters complete a successful lift and when 3-Lift competitors achieve a Total, IPF GL Points are automatically computed."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"8.  To use the file again, Clear Contents or Delete the information in the areas of the Scoresheet that are not not gray in color - shown below. Or push buttom \"Clear All Data\" and confirm the deleting."]

{"sheet":"IPF GL Formula","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[[0,0,1,4]]}
["Reference Values"]
[]
["IPF GL Formula","Description","A","B","C"]
["M-CL-PL","Male Classic 3-Lift",1199.72839,1025.1816200000001,9.2099999999999994E-3]
["M-CL-SQ","Male Classic Squat",491.82393999999999,479.13900999999998,9.5200000000000007E-3]
["M-CL-BP","Male Classic Bench",320.98041000000001,281.40258,1.008E-2]
["M-CL-DL","Male Classic DeadLift",358.44893000000002,721.54069000000004,3.1699999999999999E-2]
["M-EQ-PL","Male Equipped 3-Lift",1236.2511500000001,1449.2186400000001,1.644E-2]
["M-EQ-SQ","Male Equipped Squat",515.91349000000002,501.55605000000003,1.251E-2]
["M-EQ-BP","Male Equipped Bench",381.22073,733.79377999999997,2.3980000000000001E-2]
["M-EQ-DL","Male Equipped DeadLift",373.22847000000002,1048.6461999999999,3.6089999999999997E-2]
["F-CL-PL","Female Classic 3-Lift",610.32795999999996,1045.5928200000001,3.048E-2]
["F-CL-SQ","Female Classic Squat",257.39834000000002,381.74158999999997,2.3990000000000001E-2]
["F-CL-BP","Female Classic Bench",142.40397999999999,442.52670999999998,4.7239999999999997E-2]
["F-CL-DL","Female Classic DeadLift",238.53236999999999,624.91510000000005,4.3470000000000002E-2]
["F-EQ-PL","Female Equipped 3-Lift",758.63878,949.31381999999996,2.435E-2]
["F-EQ-SQ","Female Equipped Squat",319.90471000000002,345.45569999999998,1.9939999999999999E-2]
["F-EQ-BP","Female Equipped Bench",221.82209,357.00376999999997,2.937E-2]
["F-EQ-DL","Female Equipped DeadLift",245.61376000000001,567.83844999999997,4.1950000000000001E-2]

{"sheet":"WeightClasses","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,"F","M","F-Jr","M-Jr"]
[10,47,59,43,53]
[43.01,47,59,47,53]
[47.01,52,59,52,53]
[52.01,57,59,57,53]
[53.01,57,59,57,59]
[57.01,63,59,63,59]
[59.01,63,66,63,66]
[63.01,69,66,69,66]
[66.010000000000005,69,74,69,74]
[69.010000000000005,76,74,76,74]
[74.010000000000005,76,83,76,83]
[76.010000000000005,84,83,84,83]
[83.01,84,93,84,93]
[84.01,"84+",93,"84+",93]
[93.01,"84+",105,"84+",105]
[105.01,"84+",120,"84+",120]
[120.01,"84+","120+","84+","120+"]