{"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":105,"n_cols":47,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,4,1,16],[2,4,2,16],[3,9,3,10],[3,25,3,26],[0,4,0,16],[3,27,3,28],[3,23,3,24],[3,11,3,12],[3,13,3,14],[3,16,3,17],[3,18,3,19],[3,20,3,21]]}
[null,null,null,null,"World Open Championships",null,null,null,null,null,null,null,null,null,null,null,null,null,"√","Good"]
[null,null,null,null,"United Arab Emirates, Dubai",null,null,null,null,null,null,null,null,null,null,null,null,null,"×","NoLift"]
[null,null,null,null,"18-23 NOV 2019"]
["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","TOTAL","IPF GL Pts.","IPF GL Coeff."]
[null,null,null,null,null,null,null,null,{"$f":"IF(H5=\"\",\"\",VLOOKUP(H5,WeightClasses!$A$2:$E$18,IF(LEFT(G5,1)=\"F\",IF(YEAR(TODAY())-F5<24,4,2),IF(YEAR(TODAY())-F5<24,5,3)),TRUE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(K5<>0,M5<>0,O5<>0),MAX(IF(J5=$S$1,K5,0),IF(L5=$S$1,M5,0),IF(N5=$S$1,O5,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(R5<>0,T5<>0,V5<>0),MAX(IF(Q5=$S$1,R5,0),IF(S5=$S$1,T5,0),IF(U5=$S$1,V5,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(Y5<>0,AA5<>0,AC5<>0),MAX(IF(X5=$S$1,Y5,0),IF(Z5=$S$1,AA5,0),IF(AB5=$S$1,AC5,0)),\"\")","v":""},{"$f":"IF(OR(P5<>\"\",W5<>\"\",AD5<>\"\"),IF(AU5,\"DSQ\",IF(AND(RIGHT(G5,2)=\"PL\"),IF(P5=\"\",0,P5)+IF(W5=\"\",0,W5)+IF(AD5=\"\",0,AD5),IF(AND(RIGHT(G5,2)=\"BP\",W5<>0),W5,0))),\"\")","v":""},{"$f":"IF(AND(AE5<>\"\",ISNUMBER(AE5)),AG5*AE5,\"\")","v":""},{"$f":"IF(OR(H5=\"\",H5=0),0, ROUND(100/(VLOOKUP($G5,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G5,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G5,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H5)),6))","v":0},null,{"$f":"J5=$S$2","v":false},{"$f":"L5=$S$2","v":false},{"$f":"N5=$S$2","v":false},{"$f":"Q5=$S$2","v":false},{"$f":"S5=$S$2","v":false},{"$f":"U5=$S$2","v":false},{"$f":"X5=$S$2","v":false},{"$f":"Z5=$S$2","v":false},{"$f":"AB5=$S$2","v":false},{"$f":"AND(AI5,AJ5,AK5)","v":false},{"$f":"AND(AL5,AM5,AN5)","v":false},{"$f":"AND(AO5,AP5,AQ5)","v":false},{"$f":"OR(AR5,AS5,AT5)","v":false}]
[null,null,null,null,null,null,null,null,{"$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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"IF(OR(R6<>0,T6<>0,V6<>0),MAX(IF(Q6=$S$1,R6,0),IF(S6=$S$1,T6,0),IF(U6=$S$1,V6,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(Y6<>0,AA6<>0,AC6<>0),MAX(IF(X6=$S$1,Y6,0),IF(Z6=$S$1,AA6,0),IF(AB6=$S$1,AC6,0)),\"\")","v":""},{"$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,0))),\"\")","v":""},"",{"$f":"IF(OR(H6=\"\",H6=0),0, ROUND(100/(VLOOKUP($G6,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G6,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G6,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H6)),6))","v":0},null,{"$f":"J6=$S$2","v":false},{"$f":"L6=$S$2","v":false},{"$f":"N6=$S$2","v":false},{"$f":"Q6=$S$2","v":false},{"$f":"S6=$S$2","v":false},{"$f":"U6=$S$2","v":false},{"$f":"X6=$S$2","v":false},{"$f":"Z6=$S$2","v":false},{"$f":"AB6=$S$2","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}]
[null,null,null,null,null,null,null,null,{"$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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H7=\"\",H7=0),0, ROUND(100/(VLOOKUP($G7,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G7,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G7,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H7)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H8=\"\",H8=0),0, ROUND(100/(VLOOKUP($G8,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G8,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G8,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H8)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H9=\"\",H9=0),0, ROUND(100/(VLOOKUP($G9,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G9,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G9,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H9)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H10=\"\",H10=0),0, ROUND(100/(VLOOKUP($G10,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G10,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G10,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H10)),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(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,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H11=\"\",H11=0),0, ROUND(100/(VLOOKUP($G11,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G11,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G11,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H11)),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(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":""},null,null,null,null,null,null,{"$f":"IF(OR(K12<>0,M12<>0,O12<>0),MAX(IF(J12=$S$1,K12,0),IF(L12=$S$1,M12,0),IF(N12=$S$1,O12,0)),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"","",{"$f":"IF(AND(AE12<>\"\",ISNUMBER(AE12)),AG12*AE12,\"\")","v":""},{"$f":"IF(OR(H12=\"\",H12=0),0, ROUND(100/(VLOOKUP($G12,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G12,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G12,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H12)),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(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":""},null,null,null,null,null,null,{"$f":"IF(OR(K13<>0,M13<>0,O13<>0),MAX(IF(J13=$S$1,K13,0),IF(L13=$S$1,M13,0),IF(N13=$S$1,O13,0)),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"","",{"$f":"IF(AND(AE13<>\"\",ISNUMBER(AE13)),AG13*AE13,\"\")","v":""},{"$f":"IF(OR(H13=\"\",H13=0),0, ROUND(100/(VLOOKUP($G13,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G13,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G13,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H13)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H14=\"\",H14=0),0, ROUND(100/(VLOOKUP($G14,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G14,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G14,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H14)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H15=\"\",H15=0),0, ROUND(100/(VLOOKUP($G15,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G15,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G15,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H15)),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(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":"IF(OR(H16=\"\",H16=0),0, ROUND(100/(VLOOKUP($G16,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G16,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G16,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H16)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H17=\"\",H17=0),0, ROUND(100/(VLOOKUP($G17,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G17,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G17,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H17)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H18=\"\",H18=0),0, ROUND(100/(VLOOKUP($G18,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G18,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G18,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H18)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H19=\"\",H19=0),0, ROUND(100/(VLOOKUP($G19,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G19,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G19,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H19)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H20=\"\",H20=0),0, ROUND(100/(VLOOKUP($G20,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G20,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G20,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H20)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H21=\"\",H21=0),0, ROUND(100/(VLOOKUP($G21,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G21,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G21,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H21)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H22=\"\",H22=0),0, ROUND(100/(VLOOKUP($G22,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G22,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G22,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H22)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H23=\"\",H23=0),0, ROUND(100/(VLOOKUP($G23,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G23,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G23,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H23)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H24=\"\",H24=0),0, ROUND(100/(VLOOKUP($G24,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G24,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G24,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H24)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H25=\"\",H25=0),0, ROUND(100/(VLOOKUP($G25,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G25,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G25,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H25)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H26=\"\",H26=0),0, ROUND(100/(VLOOKUP($G26,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G26,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G26,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H26)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H27=\"\",H27=0),0, ROUND(100/(VLOOKUP($G27,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G27,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G27,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H27)),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(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,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H28=\"\",H28=0),0, ROUND(100/(VLOOKUP($G28,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G28,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G28,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H28)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H29=\"\",H29=0),0, ROUND(100/(VLOOKUP($G29,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G29,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G29,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H29)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H30=\"\",H30=0),0, ROUND(100/(VLOOKUP($G30,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G30,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G30,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H30)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H31=\"\",H31=0),0, ROUND(100/(VLOOKUP($G31,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G31,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G31,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H31)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H32=\"\",H32=0),0, ROUND(100/(VLOOKUP($G32,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G32,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G32,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H32)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H33=\"\",H33=0),0, ROUND(100/(VLOOKUP($G33,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G33,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G33,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H33)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H34=\"\",H34=0),0, ROUND(100/(VLOOKUP($G34,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G34,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G34,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H34)),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(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":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H35=\"\",H35=0),0, ROUND(100/(VLOOKUP($G35,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G35,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G35,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H35)),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(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,"",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","",{"$f":"IF(OR(H36=\"\",H36=0),0, ROUND(100/(VLOOKUP($G36,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G36,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G36,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H36)),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(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$11,3,FALSE)-VLOOKUP($G37,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G37,'IPF GL Formula'!$A$4:$F$11,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$11,3,FALSE)-VLOOKUP($G38,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G38,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H38)),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(H39=\"\",\"\",VLOOKUP(H39,WeightClasses!$A$2:$E$18,IF(LEFT(G39,1)=\"F\",IF(YEAR(TODAY())-F39<24,4,2),IF(YEAR(TODAY())-F39<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(H39=\"\",H39=0),0, ROUND(100/(VLOOKUP($G39,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G39,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G39,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H39)),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(H40=\"\",\"\",VLOOKUP(H40,WeightClasses!$A$2:$E$18,IF(LEFT(G40,1)=\"F\",IF(YEAR(TODAY())-F40<24,4,2),IF(YEAR(TODAY())-F40<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(H40=\"\",H40=0),0, ROUND(100/(VLOOKUP($G40,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G40,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G40,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H40)),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(H41=\"\",\"\",VLOOKUP(H41,WeightClasses!$A$2:$E$18,IF(LEFT(G41,1)=\"F\",IF(YEAR(TODAY())-F41<24,4,2),IF(YEAR(TODAY())-F41<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(H41=\"\",H41=0),0, ROUND(100/(VLOOKUP($G41,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G41,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G41,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H41)),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(H42=\"\",\"\",VLOOKUP(H42,WeightClasses!$A$2:$E$18,IF(LEFT(G42,1)=\"F\",IF(YEAR(TODAY())-F42<24,4,2),IF(YEAR(TODAY())-F42<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(H42=\"\",H42=0),0, ROUND(100/(VLOOKUP($G42,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G42,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G42,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H42)),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(H43=\"\",\"\",VLOOKUP(H43,WeightClasses!$A$2:$E$18,IF(LEFT(G43,1)=\"F\",IF(YEAR(TODAY())-F43<24,4,2),IF(YEAR(TODAY())-F43<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(H43=\"\",H43=0),0, ROUND(100/(VLOOKUP($G43,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G43,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G43,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H43)),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(H44=\"\",\"\",VLOOKUP(H44,WeightClasses!$A$2:$E$18,IF(LEFT(G44,1)=\"F\",IF(YEAR(TODAY())-F44<24,4,2),IF(YEAR(TODAY())-F44<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(H44=\"\",H44=0),0, ROUND(100/(VLOOKUP($G44,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G44,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G44,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H44)),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(H45=\"\",\"\",VLOOKUP(H45,WeightClasses!$A$2:$E$18,IF(LEFT(G45,1)=\"F\",IF(YEAR(TODAY())-F45<24,4,2),IF(YEAR(TODAY())-F45<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(H45=\"\",H45=0),0, ROUND(100/(VLOOKUP($G45,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G45,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G45,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H45)),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(H46=\"\",\"\",VLOOKUP(H46,WeightClasses!$A$2:$E$18,IF(LEFT(G46,1)=\"F\",IF(YEAR(TODAY())-F46<24,4,2),IF(YEAR(TODAY())-F46<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(H46=\"\",H46=0),0, ROUND(100/(VLOOKUP($G46,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G46,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G46,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H46)),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(H47=\"\",\"\",VLOOKUP(H47,WeightClasses!$A$2:$E$18,IF(LEFT(G47,1)=\"F\",IF(YEAR(TODAY())-F47<24,4,2),IF(YEAR(TODAY())-F47<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(H47=\"\",H47=0),0, ROUND(100/(VLOOKUP($G47,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G47,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G47,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H47)),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(H48=\"\",\"\",VLOOKUP(H48,WeightClasses!$A$2:$E$18,IF(LEFT(G48,1)=\"F\",IF(YEAR(TODAY())-F48<24,4,2),IF(YEAR(TODAY())-F48<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(H48=\"\",H48=0),0, ROUND(100/(VLOOKUP($G48,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G48,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G48,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H48)),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(H49=\"\",\"\",VLOOKUP(H49,WeightClasses!$A$2:$E$18,IF(LEFT(G49,1)=\"F\",IF(YEAR(TODAY())-F49<24,4,2),IF(YEAR(TODAY())-F49<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(H49=\"\",H49=0),0, ROUND(100/(VLOOKUP($G49,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G49,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G49,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H49)),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(H50=\"\",\"\",VLOOKUP(H50,WeightClasses!$A$2:$E$18,IF(LEFT(G50,1)=\"F\",IF(YEAR(TODAY())-F50<24,4,2),IF(YEAR(TODAY())-F50<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(H50=\"\",H50=0),0, ROUND(100/(VLOOKUP($G50,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G50,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G50,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H50)),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(H51=\"\",\"\",VLOOKUP(H51,WeightClasses!$A$2:$E$18,IF(LEFT(G51,1)=\"F\",IF(YEAR(TODAY())-F51<24,4,2),IF(YEAR(TODAY())-F51<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(H51=\"\",H51=0),0, ROUND(100/(VLOOKUP($G51,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G51,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G51,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H51)),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(H52=\"\",\"\",VLOOKUP(H52,WeightClasses!$A$2:$E$18,IF(LEFT(G52,1)=\"F\",IF(YEAR(TODAY())-F52<24,4,2),IF(YEAR(TODAY())-F52<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(H52=\"\",H52=0),0, ROUND(100/(VLOOKUP($G52,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G52,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G52,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H52)),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(H53=\"\",\"\",VLOOKUP(H53,WeightClasses!$A$2:$E$18,IF(LEFT(G53,1)=\"F\",IF(YEAR(TODAY())-F53<24,4,2),IF(YEAR(TODAY())-F53<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(H53=\"\",H53=0),0, ROUND(100/(VLOOKUP($G53,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G53,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G53,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H53)),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(H54=\"\",\"\",VLOOKUP(H54,WeightClasses!$A$2:$E$18,IF(LEFT(G54,1)=\"F\",IF(YEAR(TODAY())-F54<24,4,2),IF(YEAR(TODAY())-F54<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(H54=\"\",H54=0),0, ROUND(100/(VLOOKUP($G54,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G54,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G54,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H54)),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(H55=\"\",\"\",VLOOKUP(H55,WeightClasses!$A$2:$E$18,IF(LEFT(G55,1)=\"F\",IF(YEAR(TODAY())-F55<24,4,2),IF(YEAR(TODAY())-F55<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(H55=\"\",H55=0),0, ROUND(100/(VLOOKUP($G55,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G55,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G55,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H55)),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(H56=\"\",\"\",VLOOKUP(H56,WeightClasses!$A$2:$E$18,IF(LEFT(G56,1)=\"F\",IF(YEAR(TODAY())-F56<24,4,2),IF(YEAR(TODAY())-F56<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(H56=\"\",H56=0),0, ROUND(100/(VLOOKUP($G56,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G56,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G56,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H56)),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(H57=\"\",\"\",VLOOKUP(H57,WeightClasses!$A$2:$E$18,IF(LEFT(G57,1)=\"F\",IF(YEAR(TODAY())-F57<24,4,2),IF(YEAR(TODAY())-F57<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(H57=\"\",H57=0),0, ROUND(100/(VLOOKUP($G57,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G57,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G57,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H57)),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(H58=\"\",\"\",VLOOKUP(H58,WeightClasses!$A$2:$E$18,IF(LEFT(G58,1)=\"F\",IF(YEAR(TODAY())-F58<24,4,2),IF(YEAR(TODAY())-F58<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(H58=\"\",H58=0),0, ROUND(100/(VLOOKUP($G58,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G58,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G58,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H58)),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(H59=\"\",\"\",VLOOKUP(H59,WeightClasses!$A$2:$E$18,IF(LEFT(G59,1)=\"F\",IF(YEAR(TODAY())-F59<24,4,2),IF(YEAR(TODAY())-F59<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(H59=\"\",H59=0),0, ROUND(100/(VLOOKUP($G59,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G59,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G59,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H59)),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(H60=\"\",\"\",VLOOKUP(H60,WeightClasses!$A$2:$E$18,IF(LEFT(G60,1)=\"F\",IF(YEAR(TODAY())-F60<24,4,2),IF(YEAR(TODAY())-F60<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(H60=\"\",H60=0),0, ROUND(100/(VLOOKUP($G60,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G60,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G60,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H60)),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(H61=\"\",\"\",VLOOKUP(H61,WeightClasses!$A$2:$E$18,IF(LEFT(G61,1)=\"F\",IF(YEAR(TODAY())-F61<24,4,2),IF(YEAR(TODAY())-F61<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(H61=\"\",H61=0),0, ROUND(100/(VLOOKUP($G61,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G61,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G61,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H61)),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(H62=\"\",\"\",VLOOKUP(H62,WeightClasses!$A$2:$E$18,IF(LEFT(G62,1)=\"F\",IF(YEAR(TODAY())-F62<24,4,2),IF(YEAR(TODAY())-F62<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(H62=\"\",H62=0),0, ROUND(100/(VLOOKUP($G62,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G62,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G62,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H62)),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(H63=\"\",\"\",VLOOKUP(H63,WeightClasses!$A$2:$E$18,IF(LEFT(G63,1)=\"F\",IF(YEAR(TODAY())-F63<24,4,2),IF(YEAR(TODAY())-F63<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(H63=\"\",H63=0),0, ROUND(100/(VLOOKUP($G63,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G63,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G63,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H63)),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(H64=\"\",\"\",VLOOKUP(H64,WeightClasses!$A$2:$E$18,IF(LEFT(G64,1)=\"F\",IF(YEAR(TODAY())-F64<24,4,2),IF(YEAR(TODAY())-F64<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(H64=\"\",H64=0),0, ROUND(100/(VLOOKUP($G64,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G64,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G64,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H64)),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(H65=\"\",\"\",VLOOKUP(H65,WeightClasses!$A$2:$E$18,IF(LEFT(G65,1)=\"F\",IF(YEAR(TODAY())-F65<24,4,2),IF(YEAR(TODAY())-F65<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(H65=\"\",H65=0),0, ROUND(100/(VLOOKUP($G65,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G65,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G65,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H65)),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(H66=\"\",\"\",VLOOKUP(H66,WeightClasses!$A$2:$E$18,IF(LEFT(G66,1)=\"F\",IF(YEAR(TODAY())-F66<24,4,2),IF(YEAR(TODAY())-F66<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(H66=\"\",H66=0),0, ROUND(100/(VLOOKUP($G66,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G66,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G66,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H66)),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(H67=\"\",\"\",VLOOKUP(H67,WeightClasses!$A$2:$E$18,IF(LEFT(G67,1)=\"F\",IF(YEAR(TODAY())-F67<24,4,2),IF(YEAR(TODAY())-F67<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(H67=\"\",H67=0),0, ROUND(100/(VLOOKUP($G67,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G67,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G67,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H67)),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(H68=\"\",\"\",VLOOKUP(H68,WeightClasses!$A$2:$E$18,IF(LEFT(G68,1)=\"F\",IF(YEAR(TODAY())-F68<24,4,2),IF(YEAR(TODAY())-F68<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(H68=\"\",H68=0),0, ROUND(100/(VLOOKUP($G68,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G68,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G68,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H68)),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(H69=\"\",\"\",VLOOKUP(H69,WeightClasses!$A$2:$E$18,IF(LEFT(G69,1)=\"F\",IF(YEAR(TODAY())-F69<24,4,2),IF(YEAR(TODAY())-F69<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(H69=\"\",H69=0),0, ROUND(100/(VLOOKUP($G69,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G69,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G69,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H69)),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(H70=\"\",\"\",VLOOKUP(H70,WeightClasses!$A$2:$E$18,IF(LEFT(G70,1)=\"F\",IF(YEAR(TODAY())-F70<24,4,2),IF(YEAR(TODAY())-F70<24,5,3)),TRUE))","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"IF(OR(R70<>0,T70<>0,V70<>0),MAX(IF(Q70=$S$1,R70,0),IF(S70=$S$1,T70,0),IF(U70=$S$1,V70,0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(Y70<>0,AA70<>0,AC70<>0),MAX(IF(X70=$S$1,Y70,0),IF(Z70=$S$1,AA70,0),IF(AB70=$S$1,AC70,0)),\"\")","v":""},{"$f":"IF(OR(P70<>\"\",W70<>\"\",AD70<>\"\"),IF(AU70,\"DSQ\",IF(AND(RIGHT(G70,2)=\"PL\"),IF(P70=\"\",0,P70)+IF(W70=\"\",0,W70)+IF(AD70=\"\",0,AD70),IF(AND(RIGHT(G70,2)=\"BP\",W70<>0),W70,0))),\"\")","v":""},"",{"$f":"IF(OR(H70=\"\",H70=0),0, ROUND(100/(VLOOKUP($G70,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G70,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G70,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H70)),6))","v":0},null,{"$f":"J70=$S$2","v":false},{"$f":"L70=$S$2","v":false},{"$f":"N70=$S$2","v":false},{"$f":"Q70=$S$2","v":false},{"$f":"S70=$S$2","v":false},{"$f":"U70=$S$2","v":false},{"$f":"X70=$S$2","v":false},{"$f":"Z70=$S$2","v":false},{"$f":"AB70=$S$2","v":false},{"$f":"AND(AI70,AJ70,AK70)","v":false},{"$f":"AND(AL70,AM70,AN70)","v":false},{"$f":"AND(AO70,AP70,AQ70)","v":false},{"$f":"OR(AR70,AS70,AT70)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H71=\"\",\"\",VLOOKUP(H71,WeightClasses!$A$2:$E$18,IF(LEFT(G71,1)=\"F\",IF(YEAR(TODAY())-F71<24,4,2),IF(YEAR(TODAY())-F71<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(H71=\"\",H71=0),0, ROUND(100/(VLOOKUP($G71,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G71,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G71,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H71)),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(H72=\"\",\"\",VLOOKUP(H72,WeightClasses!$A$2:$E$18,IF(LEFT(G72,1)=\"F\",IF(YEAR(TODAY())-F72<24,4,2),IF(YEAR(TODAY())-F72<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(H72=\"\",H72=0),0, ROUND(100/(VLOOKUP($G72,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G72,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G72,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H72)),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(H73=\"\",\"\",VLOOKUP(H73,WeightClasses!$A$2:$E$18,IF(LEFT(G73,1)=\"F\",IF(YEAR(TODAY())-F73<24,4,2),IF(YEAR(TODAY())-F73<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(H73=\"\",H73=0),0, ROUND(100/(VLOOKUP($G73,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G73,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G73,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H73)),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(H74=\"\",\"\",VLOOKUP(H74,WeightClasses!$A$2:$E$18,IF(LEFT(G74,1)=\"F\",IF(YEAR(TODAY())-F74<24,4,2),IF(YEAR(TODAY())-F74<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(H74=\"\",H74=0),0, ROUND(100/(VLOOKUP($G74,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G74,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G74,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H74)),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(H75=\"\",\"\",VLOOKUP(H75,WeightClasses!$A$2:$E$18,IF(LEFT(G75,1)=\"F\",IF(YEAR(TODAY())-F75<24,4,2),IF(YEAR(TODAY())-F75<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(H75=\"\",H75=0),0, ROUND(100/(VLOOKUP($G75,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G75,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G75,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H75)),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(H76=\"\",\"\",VLOOKUP(H76,WeightClasses!$A$2:$E$18,IF(LEFT(G76,1)=\"F\",IF(YEAR(TODAY())-F76<24,4,2),IF(YEAR(TODAY())-F76<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(H76=\"\",H76=0),0, ROUND(100/(VLOOKUP($G76,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G76,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G76,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H76)),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(H77=\"\",\"\",VLOOKUP(H77,WeightClasses!$A$2:$E$18,IF(LEFT(G77,1)=\"F\",IF(YEAR(TODAY())-F77<24,4,2),IF(YEAR(TODAY())-F77<24,5,3)),TRUE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(K77<>0,M77<>0,O77<>0),MAX(IF(J77=$S$1,K77,0),IF(L77=$S$1,M77,0),IF(N77=$S$1,O77,0)),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"","",{"$f":"IF(AND(AE77<>\"\",ISNUMBER(AE77)),AG77*AE77,\"\")","v":""},{"$f":"IF(OR(H77=\"\",H77=0),0, ROUND(100/(VLOOKUP($G77,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G77,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G77,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H77)),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(H78=\"\",\"\",VLOOKUP(H78,WeightClasses!$A$2:$E$18,IF(LEFT(G78,1)=\"F\",IF(YEAR(TODAY())-F78<24,4,2),IF(YEAR(TODAY())-F78<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(H78=\"\",H78=0),0, ROUND(100/(VLOOKUP($G78,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G78,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G78,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H78)),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(H79=\"\",\"\",VLOOKUP(H79,WeightClasses!$A$2:$E$18,IF(LEFT(G79,1)=\"F\",IF(YEAR(TODAY())-F79<24,4,2),IF(YEAR(TODAY())-F79<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(H79=\"\",H79=0),0, ROUND(100/(VLOOKUP($G79,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G79,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G79,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H79)),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(H80=\"\",\"\",VLOOKUP(H80,WeightClasses!$A$2:$E$18,IF(LEFT(G80,1)=\"F\",IF(YEAR(TODAY())-F80<24,4,2),IF(YEAR(TODAY())-F80<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(H80=\"\",H80=0),0, ROUND(100/(VLOOKUP($G80,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G80,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G80,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H80)),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(H81=\"\",\"\",VLOOKUP(H81,WeightClasses!$A$2:$E$18,IF(LEFT(G81,1)=\"F\",IF(YEAR(TODAY())-F81<24,4,2),IF(YEAR(TODAY())-F81<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(H81=\"\",H81=0),0, ROUND(100/(VLOOKUP($G81,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G81,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G81,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H81)),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(H82=\"\",\"\",VLOOKUP(H82,WeightClasses!$A$2:$E$18,IF(LEFT(G82,1)=\"F\",IF(YEAR(TODAY())-F82<24,4,2),IF(YEAR(TODAY())-F82<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(H82=\"\",H82=0),0, ROUND(100/(VLOOKUP($G82,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G82,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G82,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H82)),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(H83=\"\",\"\",VLOOKUP(H83,WeightClasses!$A$2:$E$18,IF(LEFT(G83,1)=\"F\",IF(YEAR(TODAY())-F83<24,4,2),IF(YEAR(TODAY())-F83<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(H83=\"\",H83=0),0, ROUND(100/(VLOOKUP($G83,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G83,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G83,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H83)),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(H84=\"\",\"\",VLOOKUP(H84,WeightClasses!$A$2:$E$18,IF(LEFT(G84,1)=\"F\",IF(YEAR(TODAY())-F84<24,4,2),IF(YEAR(TODAY())-F84<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(H84=\"\",H84=0),0, ROUND(100/(VLOOKUP($G84,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G84,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G84,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H84)),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(H85=\"\",\"\",VLOOKUP(H85,WeightClasses!$A$2:$E$18,IF(LEFT(G85,1)=\"F\",IF(YEAR(TODAY())-F85<24,4,2),IF(YEAR(TODAY())-F85<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(H85=\"\",H85=0),0, ROUND(100/(VLOOKUP($G85,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G85,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G85,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H85)),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(H86=\"\",\"\",VLOOKUP(H86,WeightClasses!$A$2:$E$18,IF(LEFT(G86,1)=\"F\",IF(YEAR(TODAY())-F86<24,4,2),IF(YEAR(TODAY())-F86<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(H86=\"\",H86=0),0, ROUND(100/(VLOOKUP($G86,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G86,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G86,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H86)),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(H87=\"\",\"\",VLOOKUP(H87,WeightClasses!$A$2:$E$18,IF(LEFT(G87,1)=\"F\",IF(YEAR(TODAY())-F87<24,4,2),IF(YEAR(TODAY())-F87<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(H87=\"\",H87=0),0, ROUND(100/(VLOOKUP($G87,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G87,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G87,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H87)),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(H88=\"\",\"\",VLOOKUP(H88,WeightClasses!$A$2:$E$18,IF(LEFT(G88,1)=\"F\",IF(YEAR(TODAY())-F88<24,4,2),IF(YEAR(TODAY())-F88<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(H88=\"\",H88=0),0, ROUND(100/(VLOOKUP($G88,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G88,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G88,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H88)),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(H89=\"\",\"\",VLOOKUP(H89,WeightClasses!$A$2:$E$18,IF(LEFT(G89,1)=\"F\",IF(YEAR(TODAY())-F89<24,4,2),IF(YEAR(TODAY())-F89<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(H89=\"\",H89=0),0, ROUND(100/(VLOOKUP($G89,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G89,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G89,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H89)),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(H90=\"\",\"\",VLOOKUP(H90,WeightClasses!$A$2:$E$18,IF(LEFT(G90,1)=\"F\",IF(YEAR(TODAY())-F90<24,4,2),IF(YEAR(TODAY())-F90<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(H90=\"\",H90=0),0, ROUND(100/(VLOOKUP($G90,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G90,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G90,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H90)),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(H91=\"\",\"\",VLOOKUP(H91,WeightClasses!$A$2:$E$18,IF(LEFT(G91,1)=\"F\",IF(YEAR(TODAY())-F91<24,4,2),IF(YEAR(TODAY())-F91<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(H91=\"\",H91=0),0, ROUND(100/(VLOOKUP($G91,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G91,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G91,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H91)),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(H92=\"\",\"\",VLOOKUP(H92,WeightClasses!$A$2:$E$18,IF(LEFT(G92,1)=\"F\",IF(YEAR(TODAY())-F92<24,4,2),IF(YEAR(TODAY())-F92<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(H92=\"\",H92=0),0, ROUND(100/(VLOOKUP($G92,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G92,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G92,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H92)),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(H93=\"\",\"\",VLOOKUP(H93,WeightClasses!$A$2:$E$18,IF(LEFT(G93,1)=\"F\",IF(YEAR(TODAY())-F93<24,4,2),IF(YEAR(TODAY())-F93<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(H93=\"\",H93=0),0, ROUND(100/(VLOOKUP($G93,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G93,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G93,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H93)),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(H94=\"\",\"\",VLOOKUP(H94,WeightClasses!$A$2:$E$18,IF(LEFT(G94,1)=\"F\",IF(YEAR(TODAY())-F94<24,4,2),IF(YEAR(TODAY())-F94<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(H94=\"\",H94=0),0, ROUND(100/(VLOOKUP($G94,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G94,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G94,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H94)),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(H95=\"\",\"\",VLOOKUP(H95,WeightClasses!$A$2:$E$18,IF(LEFT(G95,1)=\"F\",IF(YEAR(TODAY())-F95<24,4,2),IF(YEAR(TODAY())-F95<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(H95=\"\",H95=0),0, ROUND(100/(VLOOKUP($G95,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G95,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G95,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H95)),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(H96=\"\",\"\",VLOOKUP(H96,WeightClasses!$A$2:$E$18,IF(LEFT(G96,1)=\"F\",IF(YEAR(TODAY())-F96<24,4,2),IF(YEAR(TODAY())-F96<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(H96=\"\",H96=0),0, ROUND(100/(VLOOKUP($G96,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G96,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G96,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H96)),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(H97=\"\",\"\",VLOOKUP(H97,WeightClasses!$A$2:$E$18,IF(LEFT(G97,1)=\"F\",IF(YEAR(TODAY())-F97<24,4,2),IF(YEAR(TODAY())-F97<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(H97=\"\",H97=0),0, ROUND(100/(VLOOKUP($G97,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G97,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G97,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H97)),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(H98=\"\",\"\",VLOOKUP(H98,WeightClasses!$A$2:$E$18,IF(LEFT(G98,1)=\"F\",IF(YEAR(TODAY())-F98<24,4,2),IF(YEAR(TODAY())-F98<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(H98=\"\",H98=0),0, ROUND(100/(VLOOKUP($G98,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G98,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G98,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H98)),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(H99=\"\",\"\",VLOOKUP(H99,WeightClasses!$A$2:$E$18,IF(LEFT(G99,1)=\"F\",IF(YEAR(TODAY())-F99<24,4,2),IF(YEAR(TODAY())-F99<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(H99=\"\",H99=0),0, ROUND(100/(VLOOKUP($G99,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G99,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G99,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H99)),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(H100=\"\",\"\",VLOOKUP(H100,WeightClasses!$A$2:$E$18,IF(LEFT(G100,1)=\"F\",IF(YEAR(TODAY())-F100<24,4,2),IF(YEAR(TODAY())-F100<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(H100=\"\",H100=0),0, ROUND(100/(VLOOKUP($G100,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G100,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G100,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H100)),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(H101=\"\",\"\",VLOOKUP(H101,WeightClasses!$A$2:$E$18,IF(LEFT(G101,1)=\"F\",IF(YEAR(TODAY())-F101<24,4,2),IF(YEAR(TODAY())-F101<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(H101=\"\",H101=0),0, ROUND(100/(VLOOKUP($G101,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G101,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G101,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H101)),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(H102=\"\",\"\",VLOOKUP(H102,WeightClasses!$A$2:$E$18,IF(LEFT(G102,1)=\"F\",IF(YEAR(TODAY())-F102<24,4,2),IF(YEAR(TODAY())-F102<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(H102=\"\",H102=0),0, ROUND(100/(VLOOKUP($G102,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G102,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G102,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H102)),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(H103=\"\",\"\",VLOOKUP(H103,WeightClasses!$A$2:$E$18,IF(LEFT(G103,1)=\"F\",IF(YEAR(TODAY())-F103<24,4,2),IF(YEAR(TODAY())-F103<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(H103=\"\",H103=0),0, ROUND(100/(VLOOKUP($G103,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G103,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G103,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H103)),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(H104=\"\",\"\",VLOOKUP(H104,WeightClasses!$A$2:$E$18,IF(LEFT(G104,1)=\"F\",IF(YEAR(TODAY())-F104<24,4,2),IF(YEAR(TODAY())-F104<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(H104=\"\",H104=0),0, ROUND(100/(VLOOKUP($G104,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G104,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G104,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H104)),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(H105=\"\",\"\",VLOOKUP(H105,WeightClasses!$A$2:$E$18,IF(LEFT(G105,1)=\"F\",IF(YEAR(TODAY())-F105<24,4,2),IF(YEAR(TODAY())-F105<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(H105=\"\",H105=0),0, ROUND(100/(VLOOKUP($G105,'IPF GL Formula'!$A$4:$F$11,3,FALSE)-VLOOKUP($G105,'IPF GL Formula'!$A$4:$F$11,4,FALSE)*EXP(-VLOOKUP($G105,'IPF GL Formula'!$A$4:$F$11,5,FALSE)*H105)),6))","v":0},null,false,false,false,false,false,false,false,false,false,false,false,false,false]

{"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":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"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-BP","Male Classic Bench",320.98041000000001,281.40258,1.008E-2]
["M-EQ-PL","Male Equipped 3-Lift",1236.2511500000001,1449.2186400000001,1.644E-2]
["M-EQ-BP","Male Equipped Bench",381.22073,733.79377999999997,2.3980000000000001E-2]
["F-CL-PL","Female Classic 3-Lift",610.32795999999996,1045.5928200000001,3.048E-2]
["F-CL-BP","Female Classic Bench",142.40397999999999,442.52670999999998,4.7239999999999997E-2]
["F-EQ-PL","Female Equipped 3-Lift",758.63878,949.31381999999996,2.435E-2]
["F-EQ-BP","Female Equipped Bench",221.82209,357.00376999999997,2.937E-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+"]