{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Scoresheet","SortLookup","Help"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":52,"n_cols":113,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,80,0,90],[0,91,0,101],[0,10,0,14],[0,44,0,55],[0,15,0,30],[0,56,0,67],[0,102,0,112],[0,31,0,43],[0,8,0,9],[0,68,0,79]]}
["Competitor",null,null,null,null,null,"Rank?","Promote?","Sort Keys",null,"Match Totals",null,null,null,null,"Stage 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 2",null,null,null,null,null,null,null,null,null,null,null,null,"Stage 3",null,null,null,null,null,null,null,null,null,null,null,"Stage 4",null,null,null,null,null,null,null,null,null,null,null,"Stage 5",null,null,null,null,null,null,null,null,null,null,null,"Stage 6",null,null,null,null,null,null,null,null,null,null,"Stage 7",null,null,null,null,null,null,null,null,null,null,"Stage 8"]
["Entry #","Name (Last, First)","IDPA #","Spl Cat","Div","Class","n","n","Sort Div","Sort Class","Total Match Score","Tot Raw Time","Tot Pen Time","Tot Pts Dn/2","Tot Pts Dn","Str 1 Raw Time","Str 2 Raw Time","Str 3 Raw Time","Str 4 Raw Time","Str 5 Raw Time","Str 6 Raw Time","Str 7 Raw Time","Pts Dn","PE","FTN","HNS","FTDR","Stage Raw Time","Pts Dn/2","Pen Sec","Total Stage Score","Str 1 Raw Time","Str 2 Raw Time","Str 3 Raw Time","Str 4 Raw Time","Pts Dn","PE","FTN","HNS","FTDR","Stage Raw Time","Pts Dn/2","Pen Sec","Total Stage Score","Str 1 Raw Time","Str 2 Raw Time","Str 3 Raw Time","Pts Dn","PE","FTN","HNS","FTDR","Stage Raw Time","Pts Dn/2","Pen Sec","Total Stage Score","Str 1 Raw Time","Str 2 Raw Time","Str 3 Raw Time","Pts Dn","PE","FTN","HNS","FTDR","Stage Raw Time","Pts Dn/2","Pen Sec","Total Stage Score","Str 1 Raw Time","Str 2 Raw Time","Str 3 Raw Time","Pts Dn","PE","FTN","HNS","FTDR","Stage Raw Time","Pts Dn/2","Pen Sec","Total Stage Score","Str 1 Raw Time","Str 2 Raw Time","Pts Dn","PE","FTN","HNS","FTDR","Stage Raw Time","Pts Dn/2","Pen Sec","Total Stage Score","Str 1 Raw Time","Str 2 Raw Time","Pts Dn","PE","FTN","HNS","FTDR","Stage Raw Time","Pts Dn/2","Pen Sec","Total Stage Score","Str 1 Raw Time","Str 2 Raw Time","Pts Dn","PE","FTN","HNS","FTDR","Stage Raw Time","Pts Dn/2","Pen Sec","Total Stage Score"]
[1,"Keith Porco",null,null,"ESP","SS",{"$f":"IF(AND(OR($G$2=\"Y\",$H$2=\"Y\"),I3<5,J3<5),IF(AND(I3=I2,J3=J2),G2+1,1),\"\")","v":""},{"$f":"IF(AND($H$2=\"Y\",J3>0,OR(AND(G3=1,G12=10),AND(G3=2,G21=20),AND(G3=3,G30=30),AND(G3=4,G39=40),AND(G3=5,G48=50),AND(G3=6,G57=60),AND(G3=7,G66=70),AND(G3=8,G75=80),AND(G3=9,G84=90),AND(G3=10,G93=100))),VLOOKUP(J3-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E3,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E3,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F3,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F3,SortLookup!$A$7:$B$11,2,FALSE))","v":2},{"$f":"L3+M3+N3","v":79.27},{"$f":"AB3+AO3+BA3+BM3+BY3+CJ3+CU3+DF3","v":70.27},{"$f":"AD3+AQ3+BC3+BO3+CA3+CL3+CW3+DH3","v":5},{"$f":"O3/2","v":4},{"$f":"W3+AJ3+AV3+BH3+BT3+CE3+CP3+DA3","v":8},25.02,null,null,null,null,null,null,0,null,null,null,null,{"$f":"P3+Q3+R3+S3+T3+U3+V3","v":25.02},{"$f":"W3/2","v":0},{"$f":"(X3*3)+(Y3*5)+(Z3*5)+(AA3*20)","v":0},{"$f":"AB3+AC3+AD3","v":25.02},8.5,null,null,null,1,null,null,null,null,{"$f":"AF3+AG3+AH3+AI3","v":8.5},{"$f":"AJ3/2","v":0.5},{"$f":"(AK3*3)+(AL3*5)+(AM3*5)+(AN3*20)","v":0},{"$f":"AO3+AP3+AQ3","v":9},19.68,null,null,3,null,null,null,null,{"$f":"AS3+AT3+AU3","v":19.68},{"$f":"AV3/2","v":1.5},{"$f":"(AW3*3)+(AX3*5)+(AY3*5)+(AZ3*20)","v":0},{"$f":"BA3+BB3+BC3","v":21.18},17.07,null,null,4,null,null,1,null,{"$f":"BE3+BF3+BG3","v":17.07},{"$f":"BH3/2","v":2},{"$f":"(BI3*3)+(BJ3*5)+(BK3*5)+(BL3*20)","v":5},{"$f":"BM3+BN3+BO3","v":24.07},null,null,null,null,null,null,null,null,{"$f":"BQ3+BR3+BS3","v":0},{"$f":"BT3/2","v":0},{"$f":"(BU3*3)+(BV3*5)+(BW3*5)+(BX3*20)","v":0},{"$f":"BY3+BZ3+CA3","v":0},null,null,null,null,null,null,null,{"$f":"CC3+CD3","v":0},{"$f":"CE3/2","v":0},{"$f":"(CF3*3)+(CG3*5)+(CH3*5)+(CI3*20)","v":0},{"$f":"CJ3+CK3+CL3","v":0},null,null,null,null,null,null,null,{"$f":"CN3+CO3","v":0},{"$f":"CP3/2","v":0},{"$f":"(CQ3*3)+(CR3*5)+(CS3*5)+(CT3*20)","v":0},{"$f":"CU3+CV3+CW3","v":0},null,null,null,null,null,null,null,{"$f":"CY3+CZ3","v":0},{"$f":"DA3/2","v":0},{"$f":"(DB3*3)+(DC3*5)+(DD3*5)+(DE3*20)","v":0},{"$f":"DF3+DG3+DH3","v":0}]
[2,"Gene Villella",null,null,"ESP","SS",{"$f":"IF(AND(OR($G$2=\"Y\",$H$2=\"Y\"),I4<5,J4<5),IF(AND(I4=I3,J4=J3),G3+1,1),\"\")","v":""},{"$f":"IF(AND($H$2=\"Y\",J4>0,OR(AND(G4=1,G13=10),AND(G4=2,G22=20),AND(G4=3,G31=30),AND(G4=4,G40=40),AND(G4=5,G49=50),AND(G4=6,G58=60),AND(G4=7,G67=70),AND(G4=8,G76=80),AND(G4=9,G85=90),AND(G4=10,G94=100))),VLOOKUP(J4-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E4,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E4,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F4,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F4,SortLookup!$A$7:$B$11,2,FALSE))","v":2},104.47,94.47,5,5,10,29.6,null,null,null,null,null,null,0,null,null,null,null,29.6,0,0,{"$f":"AB4+AC4+AD4","v":29.6},7.32,null,null,null,4,null,null,null,null,7.32,2,0,{"$f":"AO4+AP4+AQ4","v":9.32},28.03,null,null,0,null,null,null,null,28.03,0,0,{"$f":"BA4+BB4+BC4","v":28.03},29.52,null,null,6,null,null,1,null,29.52,3,5,{"$f":"BM4+BN4+BO4","v":37.520000000000003},null,null,null,null,null,null,null,null,0,0,0,{"$f":"BY4+BZ4+CA4","v":0},null,null,null,null,null,null,null,0,0,0,{"$f":"CJ4+CK4+CL4","v":0},null,null,null,null,null,null,null,0,0,0,{"$f":"CU4+CV4+CW4","v":0},null,null,null,null,null,null,null,0,0,0,{"$f":"DF4+DG4+DH4","v":0}]
[3,"Terry Hanes",null,null,"ESP","SS",{"$f":"IF(AND(OR($G$2=\"Y\",$H$2=\"Y\"),I5<5,J5<5),IF(AND(I5=I4,J5=J4),G4+1,1),\"\")","v":""},{"$f":"IF(AND($H$2=\"Y\",J5>0,OR(AND(G5=1,G14=10),AND(G5=2,G23=20),AND(G5=3,G32=30),AND(G5=4,G41=40),AND(G5=5,G50=50),AND(G5=6,G59=60),AND(G5=7,G68=70),AND(G5=8,G77=80),AND(G5=9,G86=90),AND(G5=10,G95=100))),VLOOKUP(J5-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E5,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E5,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F5,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F5,SortLookup!$A$7:$B$11,2,FALSE))","v":2},72.739999999999995,68.239999999999995,0,4.5,9,20.72,null,null,null,null,null,null,1,null,null,null,null,20.72,0.5,0,21.22,8.36,null,null,null,1,null,null,null,null,8.36,0.5,0,8.86,25.19,null,null,3,null,null,null,null,25.19,1.5,0,26.69,13.97,null,null,4,null,null,null,null,13.97,2,0,15.97,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[4,"Jerry Williams",null,null,"ESP","UN",{"$f":"IF(AND(OR($G$2=\"Y\",$H$2=\"Y\"),I6<5,J6<5),IF(AND(I6=I5,J6=J5),G5+1,1),\"\")","v":""},{"$f":"IF(AND($H$2=\"Y\",J6>0,OR(AND(G6=1,G15=10),AND(G6=2,G24=20),AND(G6=3,G33=30),AND(G6=4,G42=40),AND(G6=5,G51=50),AND(G6=6,G60=60),AND(G6=7,G69=70),AND(G6=8,G78=80),AND(G6=9,G87=90),AND(G6=10,G96=100))),VLOOKUP(J6-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E6,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E6,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F6,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F6,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},120.26,115.26,0,5,10,40.74,null,null,null,null,null,null,1,null,null,null,null,40.74,0.5,0,41.24,10.44,null,null,null,0,null,null,null,null,10.44,0,0,10.44,34.03,null,null,1,null,null,null,null,34.03,0.5,0,34.53,30.05,null,null,8,null,null,null,null,30.05,4,0,34.049999999999997,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[5,"Paul Day",null,null,"ESP","SS","",{"$f":"IF(AND($H$2=\"Y\",J7>0,OR(AND(G7=1,G16=10),AND(G7=2,G25=20),AND(G7=3,G34=30),AND(G7=4,G43=40),AND(G7=5,G52=50),AND(G7=6,G61=60),AND(G7=7,G70=70),AND(G7=8,G79=80),AND(G7=9,G88=90),AND(G7=10,G97=100))),VLOOKUP(J7-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E7,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E7,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F7,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F7,SortLookup!$A$7:$B$11,2,FALSE))","v":2},87.88,82.88,0,5,10,26.86,null,null,null,null,null,null,1,null,null,null,null,26.86,0.5,0,27.36,11.77,null,null,null,2,null,null,null,null,11.77,1,0,12.77,23.96,null,null,5,null,null,null,null,23.96,2.5,0,26.46,20.29,null,null,2,null,null,null,null,20.29,1,0,21.29,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[6,"Brandon Williams",null,null,"ESP","UN","",{"$f":"IF(AND($H$2=\"Y\",J8>0,OR(AND(G8=1,G17=10),AND(G8=2,G26=20),AND(G8=3,G35=30),AND(G8=4,G44=40),AND(G8=5,G53=50),AND(G8=6,G62=60),AND(G8=7,G71=70),AND(G8=8,G80=80),AND(G8=9,G89=90),AND(G8=10,G98=100))),VLOOKUP(J8-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E8,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E8,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F8,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F8,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},163.44,137.44,5,21,42,53.24,null,null,null,null,null,null,7,null,null,null,null,53.24,3.5,0,56.74,15.74,null,null,null,2,null,null,null,null,15.74,1,0,16.739999999999998,39.25,null,null,24,null,null,null,null,39.25,12,0,51.25,29.21,null,null,9,null,null,1,null,29.21,4.5,5,38.71,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[7,"John Connacher",null,null,"ESP","NV","",{"$f":"IF(AND($H$2=\"Y\",J9>0,OR(AND(G9=1,G18=10),AND(G9=2,G27=20),AND(G9=3,G36=30),AND(G9=4,G45=40),AND(G9=5,G54=50),AND(G9=6,G63=60),AND(G9=7,G72=70),AND(G9=8,G81=80),AND(G9=9,G90=90),AND(G9=10,G99=100))),VLOOKUP(J9-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E9,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E9,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F9,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F9,SortLookup!$A$7:$B$11,2,FALSE))","v":4},187.57,163.57,10,14,28,55.75,null,null,null,null,null,null,8,null,null,null,null,55.75,4,0,59.75,20.9,null,null,null,1,null,null,null,null,20.9,0.5,0,21.4,54.69,null,null,17,null,null,null,null,54.69,8.5,0,63.19,32.229999999999997,null,null,2,null,null,2,null,32.229999999999997,1,10,43.23,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[8,"Jim Shipley",null,null,"ESP","UN","",{"$f":"IF(AND($H$2=\"Y\",J10>0,OR(AND(G10=1,G19=10),AND(G10=2,G28=20),AND(G10=3,G37=30),AND(G10=4,G46=40),AND(G10=5,G55=50),AND(G10=6,G64=60),AND(G10=7,G73=70),AND(G10=8,G82=80),AND(G10=9,G91=90),AND(G10=10,G100=100))),VLOOKUP(J10-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E10,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E10,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F10,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F10,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},90.89,70.39,8,12.5,25,22.49,null,null,null,null,null,null,6,1,null,null,null,22.49,3,3,28.49,9.06,null,null,null,5,null,null,null,null,9.06,2.5,0,11.56,22.76,null,null,3,null,null,null,null,22.76,1.5,0,24.26,16.079999999999998,null,null,11,null,1,null,null,16.079999999999998,5.5,5,26.58,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[9,"Austin Steele",null,null,"ESP","UN","",{"$f":"IF(AND($H$2=\"Y\",J11>0,OR(AND(G11=1,G20=10),AND(G11=2,G29=20),AND(G11=3,G38=30),AND(G11=4,G47=40),AND(G11=5,G56=50),AND(G11=6,G65=60),AND(G11=7,G74=70),AND(G11=8,G83=80),AND(G11=9,G92=90),AND(G11=10,G101=100))),VLOOKUP(J11-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E11,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E11,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F11,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F11,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},115.99,70.989999999999995,13,32,64,25.6,null,null,null,null,null,null,23,1,null,null,null,25.6,11.5,3,40.1,7.94,null,null,null,5,null,null,null,null,7.94,2.5,0,10.44,19.63,null,null,18,null,null,null,null,19.63,9,0,28.63,17.82,null,null,18,null,1,1,null,17.82,9,10,36.82,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[10,"Chris Kline",null,null,"ESP","UN","",{"$f":"IF(AND($H$2=\"Y\",J12>0,OR(AND(G12=1,G21=10),AND(G12=2,G30=20),AND(G12=3,G39=30),AND(G12=4,G48=40),AND(G12=5,G57=50),AND(G12=6,G66=60),AND(G12=7,G75=70),AND(G12=8,G84=80),AND(G12=9,G93=90),AND(G12=10,G102=100))),VLOOKUP(J12-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E12,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E12,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F12,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F12,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},110.69,91.19,8,11.5,23,29.33,null,null,null,null,null,null,5,null,null,null,null,29.33,2.5,0,31.83,11.35,null,null,null,1,null,null,null,null,11.35,0.5,0,11.85,31.24,null,null,12,1,null,null,null,31.24,6,3,40.24,19.27,null,null,5,null,null,1,null,19.27,2.5,5,26.77,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[11,"Wayne Steele",null,null,"ESP","UN","",{"$f":"IF(AND($H$2=\"Y\",J13>0,OR(AND(G13=1,G22=10),AND(G13=2,G31=20),AND(G13=3,G40=30),AND(G13=4,G49=40),AND(G13=5,G58=50),AND(G13=6,G67=60),AND(G13=7,G76=70),AND(G13=8,G85=80),AND(G13=9,G94=90),AND(G13=10,G103=100))),VLOOKUP(J13-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E13,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E13,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F13,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F13,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},{"$error":"#VALUE!"},{"$error":"#VALUE!"},3,5.5,11,24.04,null,null,null,null,null,null,3,1,null,null,null,24.04,1.5,3,28.54,7.91,null,null,null,1,null,null,null,null,7.91,0.5,0,8.41,20.57,null,null,7,null,null,null,null,20.57,3.5,0,24.07,"DNF",null,null,null,null,null,null,null,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[12,"Bob (FTR) Rogan",null,null,"ESP","UN","",{"$f":"IF(AND($H$2=\"Y\",J14>0,OR(AND(G14=1,G23=10),AND(G14=2,G32=20),AND(G14=3,G41=30),AND(G14=4,G50=40),AND(G14=5,G59=50),AND(G14=6,G68=60),AND(G14=7,G77=70),AND(G14=8,G86=80),AND(G14=9,G95=90),AND(G14=10,G104=100))),VLOOKUP(J14-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E14,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E14,SortLookup!$A$1:$B$5,2,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP(F14,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F14,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},102.87,90.37,0,12.5,25,30.28,null,null,null,null,null,null,9,null,null,null,null,30.28,4.5,0,34.78,11.54,null,null,null,3,null,null,null,null,11.54,1.5,0,13.04,27.34,null,null,4,null,null,null,null,27.34,2,0,29.34,21.21,null,null,9,null,null,null,null,21.21,4.5,0,25.71,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[13,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J15>0,OR(AND(G15=1,G24=10),AND(G15=2,G33=20),AND(G15=3,G42=30),AND(G15=4,G51=40),AND(G15=5,G60=50),AND(G15=6,G69=60),AND(G15=7,G78=70),AND(G15=8,G87=80),AND(G15=9,G96=90),AND(G15=10,G105=100))),VLOOKUP(J15-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E15,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E15,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F15,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F15,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[14,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J16>0,OR(AND(G16=1,G25=10),AND(G16=2,G34=20),AND(G16=3,G43=30),AND(G16=4,G52=40),AND(G16=5,G61=50),AND(G16=6,G70=60),AND(G16=7,G79=70),AND(G16=8,G88=80),AND(G16=9,G97=90),AND(G16=10,G106=100))),VLOOKUP(J16-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E16,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E16,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F16,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F16,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[15,"Bruce Wehler",null,null,"CDP","UN","",{"$f":"IF(AND($H$2=\"Y\",J17>0,OR(AND(G17=1,G26=10),AND(G17=2,G35=20),AND(G17=3,G44=30),AND(G17=4,G53=40),AND(G17=5,G62=50),AND(G17=6,G71=60),AND(G17=7,G80=70),AND(G17=8,G89=80),AND(G17=9,G98=90),AND(G17=10,G107=100))),VLOOKUP(J17-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E17,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E17,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F17,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F17,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},126.19,98.19,5,23,46,31.01,null,null,null,null,null,null,9,null,null,null,null,31.01,4.5,0,35.51,10.61,null,null,null,5,null,null,null,null,10.61,2.5,0,13.11,32.119999999999997,null,null,18,null,null,null,null,32.119999999999997,9,0,41.12,24.45,null,null,14,null,1,null,null,24.45,7,5,36.450000000000003,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[16,"Duane Schmader",null,null,"CDP","UN","",{"$f":"IF(AND($H$2=\"Y\",J18>0,OR(AND(G18=1,G27=10),AND(G18=2,G36=20),AND(G18=3,G45=30),AND(G18=4,G54=40),AND(G18=5,G63=50),AND(G18=6,G72=60),AND(G18=7,G81=70),AND(G18=8,G90=80),AND(G18=9,G99=90),AND(G18=10,G108=100))),VLOOKUP(J18-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E18,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E18,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F18,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F18,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},165.24,130.24,15,20,40,43.16,null,null,null,null,null,null,2,null,null,null,null,43.16,1,0,44.16,13.13,null,null,null,11,null,1,null,null,13.13,5.5,5,23.63,45.05,null,null,12,null,null,null,null,45.05,6,0,51.05,28.9,null,null,15,null,1,1,null,28.9,7.5,10,46.4,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[17,"Joe Wortman",null,null,"CDP","MM","",{"$f":"IF(AND($H$2=\"Y\",J19>0,OR(AND(G19=1,G28=10),AND(G19=2,G37=20),AND(G19=3,G46=30),AND(G19=4,G55=40),AND(G19=5,G64=50),AND(G19=6,G73=60),AND(G19=7,G82=70),AND(G19=8,G91=80),AND(G19=9,G100=90),AND(G19=10,G109=100))),VLOOKUP(J19-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E19,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E19,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F19,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F19,SortLookup!$A$7:$B$11,2,FALSE))","v":3},98.57,91.07,0,7.5,15,27.52,null,null,null,null,null,null,1,null,null,null,null,27.52,0.5,0,28.02,9.09,null,null,null,0,null,null,null,null,9.09,0,0,9.09,29.33,null,null,13,null,null,null,null,29.33,6.5,0,35.83,25.13,null,null,1,null,null,null,null,25.13,0.5,0,25.63,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[18,"Ed Novak",null,null,"CDP","NV","",{"$f":"IF(AND($H$2=\"Y\",J20>0,OR(AND(G20=1,G29=10),AND(G20=2,G38=20),AND(G20=3,G47=30),AND(G20=4,G56=40),AND(G20=5,G65=50),AND(G20=6,G74=60),AND(G20=7,G83=70),AND(G20=8,G92=80),AND(G20=9,G101=90),AND(G20=10,G110=100))),VLOOKUP(J20-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E20,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E20,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F20,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F20,SortLookup!$A$7:$B$11,2,FALSE))","v":4},152.44,125.94,9,17.5,35,44.54,null,null,null,null,null,null,18,2,null,null,null,44.54,9,6,59.54,7.02,null,null,null,1,null,null,null,null,7.02,0.5,0,7.52,40.29,null,null,3,null,null,null,null,40.29,1.5,0,41.79,34.090000000000003,null,null,13,1,null,null,null,34.090000000000003,6.5,3,43.59,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[19,"Herb Barnickel",null,null,"CDP","NV","",{"$f":"IF(AND($H$2=\"Y\",J21>0,OR(AND(G21=1,G30=10),AND(G21=2,G39=20),AND(G21=3,G48=30),AND(G21=4,G57=40),AND(G21=5,G66=50),AND(G21=6,G75=60),AND(G21=7,G84=70),AND(G21=8,G93=80),AND(G21=9,G102=90),AND(G21=10,G111=100))),VLOOKUP(J21-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E21,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E21,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F21,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F21,SortLookup!$A$7:$B$11,2,FALSE))","v":4},168.82,164.32,3,1.5,3,59.01,null,null,null,null,null,null,0,null,null,null,null,59.01,0,0,59.01,15.3,null,null,null,0,1,null,null,null,15.3,0,3,18.3,53.24,null,null,1,null,null,null,null,53.24,0.5,0,53.74,36.770000000000003,null,null,2,null,null,null,null,36.770000000000003,1,0,37.770000000000003,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[20,"Roger Decker",null,null,"CDP","NV","",{"$f":"IF(AND($H$2=\"Y\",J22>0,OR(AND(G22=1,G31=10),AND(G22=2,G40=20),AND(G22=3,G49=30),AND(G22=4,G58=40),AND(G22=5,G67=50),AND(G22=6,G76=60),AND(G22=7,G85=70),AND(G22=8,G94=80),AND(G22=9,G103=90),AND(G22=10,G112=100))),VLOOKUP(J22-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E22,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E22,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F22,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F22,SortLookup!$A$7:$B$11,2,FALSE))","v":4},176.28,163.28,0,13,26,39.76,null,null,null,null,null,null,4,null,null,null,null,39.76,2,0,41.76,28.97,null,null,null,1,null,null,null,null,28.97,0.5,0,29.47,62.67,null,null,12,null,null,null,null,62.67,6,0,68.67,31.88,null,null,9,null,null,null,null,31.88,4.5,0,36.380000000000003,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[21,"Jim Maletto",null,null,"CDP","SS","",{"$f":"IF(AND($H$2=\"Y\",J23>0,OR(AND(G23=1,G32=10),AND(G23=2,G41=20),AND(G23=3,G50=30),AND(G23=4,G59=40),AND(G23=5,G68=50),AND(G23=6,G77=60),AND(G23=7,G86=70),AND(G23=8,G95=80),AND(G23=9,G104=90),AND(G23=10,G113=100))),VLOOKUP(J23-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E23,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E23,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F23,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F23,SortLookup!$A$7:$B$11,2,FALSE))","v":2},92.57,81.569999999999993,0,11,22,27.16,null,null,null,null,null,null,4,null,null,null,null,27.16,2,0,29.16,8.9,null,null,null,1,null,null,null,null,8.9,0.5,0,9.4,21.69,null,null,14,null,null,null,null,21.69,7,0,28.69,23.82,null,null,3,null,null,null,null,23.82,1.5,0,25.32,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[22,"Daren Mensch",null,null,"CDP","UN","",{"$f":"IF(AND($H$2=\"Y\",J24>0,OR(AND(G24=1,G33=10),AND(G24=2,G42=20),AND(G24=3,G51=30),AND(G24=4,G60=40),AND(G24=5,G69=50),AND(G24=6,G78=60),AND(G24=7,G87=70),AND(G24=8,G96=80),AND(G24=9,G105=90),AND(G24=10,G114=100))),VLOOKUP(J24-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E24,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E24,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F24,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F24,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},99.16,93.66,0,5.5,11,35.82,null,null,null,null,null,null,3,null,null,null,null,35.82,1.5,0,37.32,10.77,null,null,null,0,null,null,null,null,10.77,0,0,10.77,28.61,null,null,6,null,null,null,null,28.61,3,0,31.61,18.46,null,null,2,null,null,null,null,18.46,1,0,19.46,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[23,"Jared Shaffer",null,null,"CDP","SS","",{"$f":"IF(AND($H$2=\"Y\",J25>0,OR(AND(G25=1,G34=10),AND(G25=2,G43=20),AND(G25=3,G52=30),AND(G25=4,G61=40),AND(G25=5,G70=50),AND(G25=6,G79=60),AND(G25=7,G88=70),AND(G25=8,G97=80),AND(G25=9,G106=90),AND(G25=10,G115=100))),VLOOKUP(J25-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E25,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E25,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F25,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F25,SortLookup!$A$7:$B$11,2,FALSE))","v":2},72.099999999999994,67.599999999999994,0,4.5,9,19.91,null,null,null,null,null,null,3,null,null,null,null,19.91,1.5,0,21.41,6.66,null,null,null,2,null,null,null,null,6.66,1,0,7.66,22.57,null,null,2,null,null,null,null,22.57,1,0,23.57,18.46,null,null,2,null,null,null,null,18.46,1,0,19.46,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[24,"Mike (1 arm) Newell",null,null,"CDP","SS","",{"$f":"IF(AND($H$2=\"Y\",J26>0,OR(AND(G26=1,G35=10),AND(G26=2,G44=20),AND(G26=3,G53=30),AND(G26=4,G62=40),AND(G26=5,G71=50),AND(G26=6,G80=60),AND(G26=7,G89=70),AND(G26=8,G98=80),AND(G26=9,G107=90),AND(G26=10,G116=100))),VLOOKUP(J26-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E26,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E26,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F26,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F26,SortLookup!$A$7:$B$11,2,FALSE))","v":2},89.58,80.08,3,6.5,13,27.4,null,null,null,null,null,null,4,null,null,null,null,27.4,2,0,29.4,8.98,null,null,null,1,null,null,null,null,8.98,0.5,0,9.48,24.07,null,null,6,null,null,null,null,24.07,3,0,27.07,19.63,null,null,2,1,null,null,null,19.63,1,3,23.63,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[25,"Darell Duttry",null,null,"CDP","SS","",{"$f":"IF(AND($H$2=\"Y\",J27>0,OR(AND(G27=1,G36=10),AND(G27=2,G45=20),AND(G27=3,G54=30),AND(G27=4,G63=40),AND(G27=5,G72=50),AND(G27=6,G81=60),AND(G27=7,G90=70),AND(G27=8,G99=80),AND(G27=9,G108=90),AND(G27=10,G117=100))),VLOOKUP(J27-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E27,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E27,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F27,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F27,SortLookup!$A$7:$B$11,2,FALSE))","v":2},82.88,70.88,0,12,24,20.2,null,null,null,null,null,null,9,null,null,null,null,20.2,4.5,0,24.7,7.46,null,null,null,2,null,null,null,null,7.46,1,0,8.4600000000000009,24.66,null,null,11,null,null,null,null,24.66,5.5,0,30.16,18.559999999999999,null,null,2,null,null,null,null,18.559999999999999,1,0,19.559999999999999,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[26,"Rick Brecht",null,null,"CDP","SS","",{"$f":"IF(AND($H$2=\"Y\",J28>0,OR(AND(G28=1,G37=10),AND(G28=2,G46=20),AND(G28=3,G55=30),AND(G28=4,G64=40),AND(G28=5,G73=50),AND(G28=6,G82=60),AND(G28=7,G91=70),AND(G28=8,G100=80),AND(G28=9,G109=90),AND(G28=10,G118=100))),VLOOKUP(J28-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E28,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E28,SortLookup!$A$1:$B$5,2,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP(F28,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F28,SortLookup!$A$7:$B$11,2,FALSE))","v":2},79.290000000000006,63.79,5,10.5,21,22.15,null,null,null,null,null,null,6,null,null,null,null,22.15,3,0,25.15,5.97,null,null,null,1,null,null,null,null,5.97,0.5,0,6.47,19.899999999999999,null,null,13,null,null,null,null,19.899999999999999,6.5,0,26.4,15.77,null,null,1,null,null,1,null,15.77,0.5,5,21.27,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[27,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J29>0,OR(AND(G29=1,G38=10),AND(G29=2,G47=20),AND(G29=3,G56=30),AND(G29=4,G65=40),AND(G29=5,G74=50),AND(G29=6,G83=60),AND(G29=7,G92=70),AND(G29=8,G101=80),AND(G29=9,G110=90),AND(G29=10,G119=100))),VLOOKUP(J29-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E29,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E29,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F29,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F29,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[28,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J30>0,OR(AND(G30=1,G39=10),AND(G30=2,G48=20),AND(G30=3,G57=30),AND(G30=4,G66=40),AND(G30=5,G75=50),AND(G30=6,G84=60),AND(G30=7,G93=70),AND(G30=8,G102=80),AND(G30=9,G111=90),AND(G30=10,G120=100))),VLOOKUP(J30-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E30,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E30,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F30,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F30,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[29,"Frankie Decker",null,null,"SSP","MM","",{"$f":"IF(AND($H$2=\"Y\",J31>0,OR(AND(G31=1,G40=10),AND(G31=2,G49=20),AND(G31=3,G58=30),AND(G31=4,G67=40),AND(G31=5,G76=50),AND(G31=6,G85=60),AND(G31=7,G94=70),AND(G31=8,G103=80),AND(G31=9,G112=90),AND(G31=10,G121=100))),VLOOKUP(J31-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E31,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E31,SortLookup!$A$1:$B$5,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(F31,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F31,SortLookup!$A$7:$B$11,2,FALSE))","v":3},132.97,121.97,0,11,22,41.34,null,null,null,null,null,null,11,null,null,null,null,41.34,5.5,0,46.84,11.84,null,null,null,0,null,null,null,null,11.84,0,0,11.84,38.729999999999997,null,null,3,null,null,null,null,38.729999999999997,1.5,0,40.229999999999997,30.06,null,null,8,null,null,null,null,30.06,4,0,34.06,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[30,"Bill Kraus",null,null,"SSP","UN","",{"$f":"IF(AND($H$2=\"Y\",J32>0,OR(AND(G32=1,G41=10),AND(G32=2,G50=20),AND(G32=3,G59=30),AND(G32=4,G68=40),AND(G32=5,G77=50),AND(G32=6,G86=60),AND(G32=7,G95=70),AND(G32=8,G104=80),AND(G32=9,G113=90),AND(G32=10,G122=100))),VLOOKUP(J32-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E32,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E32,SortLookup!$A$1:$B$5,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(F32,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F32,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},203.34,134.34,25,44,88,41.67,null,null,null,null,null,null,4,null,null,null,null,41.67,2,0,43.67,19.12,null,null,null,11,null,2,null,null,19.12,5.5,10,34.619999999999997,43.46,null,null,52,null,null,null,null,43.46,26,0,69.459999999999994,30.09,null,null,21,null,1,2,null,30.09,10.5,15,55.59,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[31,"Brian Kraus",null,null,"SSP","UN","",{"$f":"IF(AND($H$2=\"Y\",J33>0,OR(AND(G33=1,G42=10),AND(G33=2,G51=20),AND(G33=3,G60=30),AND(G33=4,G69=40),AND(G33=5,G78=50),AND(G33=6,G87=60),AND(G33=7,G96=70),AND(G33=8,G105=80),AND(G33=9,G114=90),AND(G33=10,G123=100))),VLOOKUP(J33-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E33,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E33,SortLookup!$A$1:$B$5,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(F33,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F33,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},133.01,74.010000000000005,20,39,78,20.63,null,null,null,null,null,null,12,null,null,null,null,20.63,6,0,26.63,16.32,null,null,null,19,null,2,null,null,16.32,9.5,10,35.82,19.07,null,null,27,null,null,null,null,19.07,13.5,0,32.57,17.989999999999998,null,null,20,null,1,1,null,17.989999999999998,10,10,37.99,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[32,"Bran Haines",null,null,"SSP","UN","",{"$f":"IF(AND($H$2=\"Y\",J34>0,OR(AND(G34=1,G43=10),AND(G34=2,G52=20),AND(G34=3,G61=30),AND(G34=4,G70=40),AND(G34=5,G79=50),AND(G34=6,G88=60),AND(G34=7,G97=70),AND(G34=8,G106=80),AND(G34=9,G115=90),AND(G34=10,G124=100))),VLOOKUP(J34-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E34,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E34,SortLookup!$A$1:$B$5,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(F34,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F34,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},133.63,103.13,8,22.5,45,26.76,null,null,null,null,null,null,11,null,null,null,null,26.76,5.5,0,32.26,9.8800000000000008,null,null,null,6,null,null,null,null,9.8800000000000008,3,0,12.88,34.04,null,null,26,null,null,null,null,34.04,13,0,47.04,32.450000000000003,null,null,2,1,null,1,null,32.450000000000003,1,8,41.45,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[33,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J35>0,OR(AND(G35=1,G44=10),AND(G35=2,G53=20),AND(G35=3,G62=30),AND(G35=4,G71=40),AND(G35=5,G80=50),AND(G35=6,G89=60),AND(G35=7,G98=70),AND(G35=8,G107=80),AND(G35=9,G116=90),AND(G35=10,G125=100))),VLOOKUP(J35-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E35,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E35,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F35,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F35,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},{"$f":"L35+M35+N35","v":0},{"$f":"AB35+AO35+BA35+BM35+BY35+CJ35+CU35+DF35","v":0},{"$f":"AD35+AQ35+BC35+BO35+CA35+CL35+CW35+DH35","v":0},{"$f":"O35/2","v":0},{"$f":"W35+AJ35+AV35+BH35+BT35+CE35+CP35+DA35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P35+Q35+R35+S35+T35+U35+V35","v":0},{"$f":"W35/2","v":0},{"$f":"(X35*3)+(Y35*5)+(Z35*5)+(AA35*20)","v":0},0,null,null,null,null,null,null,null,null,null,{"$f":"AF35+AG35+AH35+AI35","v":0},{"$f":"AJ35/2","v":0},{"$f":"(AK35*3)+(AL35*5)+(AM35*5)+(AN35*20)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"AS35+AT35+AU35","v":0},{"$f":"AV35/2","v":0},{"$f":"(AW35*3)+(AX35*5)+(AY35*5)+(AZ35*20)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"BE35+BF35+BG35","v":0},{"$f":"BH35/2","v":0},{"$f":"(BI35*3)+(BJ35*5)+(BK35*5)+(BL35*20)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"BQ35+BR35+BS35","v":0},{"$f":"BT35/2","v":0},{"$f":"(BU35*3)+(BV35*5)+(BW35*5)+(BX35*20)","v":0},0,null,null,null,null,null,null,null,{"$f":"CC35+CD35","v":0},{"$f":"CE35/2","v":0},{"$f":"(CF35*3)+(CG35*5)+(CH35*5)+(CI35*20)","v":0},0,null,null,null,null,null,null,null,{"$f":"CN35+CO35","v":0},{"$f":"CP35/2","v":0},{"$f":"(CQ35*3)+(CR35*5)+(CS35*5)+(CT35*20)","v":0},0,null,null,null,null,null,null,null,{"$f":"CY35+CZ35","v":0},{"$f":"DA35/2","v":0},{"$f":"(DB35*3)+(DC35*5)+(DD35*5)+(DE35*20)","v":0},0]
[34,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J36>0,OR(AND(G36=1,G45=10),AND(G36=2,G54=20),AND(G36=3,G63=30),AND(G36=4,G72=40),AND(G36=5,G81=50),AND(G36=6,G90=60),AND(G36=7,G99=70),AND(G36=8,G108=80),AND(G36=9,G117=90),AND(G36=10,G126=100))),VLOOKUP(J36-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E36,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E36,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F36,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F36,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[35,"Adam Ginther",null,null,"SSR","MM","",{"$f":"IF(AND($H$2=\"Y\",J37>0,OR(AND(G37=1,G46=10),AND(G37=2,G55=20),AND(G37=3,G64=30),AND(G37=4,G73=40),AND(G37=5,G82=50),AND(G37=6,G91=60),AND(G37=7,G100=70),AND(G37=8,G109=80),AND(G37=9,G118=90),AND(G37=10,G127=100))),VLOOKUP(J37-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E37,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E37,SortLookup!$A$1:$B$5,2,FALSE))","v":4},{"$f":"IF(ISNA(VLOOKUP(F37,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F37,SortLookup!$A$7:$B$11,2,FALSE))","v":3},124.59,110.09,0,14.5,29,38.76,null,null,null,null,null,null,10,null,null,null,null,38.76,5,0,43.76,18.48,null,null,null,0,null,null,null,null,18.48,0,0,18.48,26.57,null,null,15,null,null,null,null,26.57,7.5,0,34.07,26.28,null,null,4,null,null,null,null,26.28,2,0,28.28,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[36,"Chris Jovenitti",null,null,"SSR","NV","",{"$f":"IF(AND($H$2=\"Y\",J38>0,OR(AND(G38=1,G47=10),AND(G38=2,G56=20),AND(G38=3,G65=30),AND(G38=4,G74=40),AND(G38=5,G83=50),AND(G38=6,G92=60),AND(G38=7,G101=70),AND(G38=8,G110=80),AND(G38=9,G119=90),AND(G38=10,G128=100))),VLOOKUP(J38-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E38,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E38,SortLookup!$A$1:$B$5,2,FALSE))","v":4},{"$f":"IF(ISNA(VLOOKUP(F38,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F38,SortLookup!$A$7:$B$11,2,FALSE))","v":4},279.98,242.48,5,32.5,65,91.85,null,null,null,null,null,null,23,null,null,null,null,91.85,11.5,0,103.35,33.72,null,null,null,5,null,null,null,null,33.72,2.5,0,36.22,62.86,null,null,20,null,null,null,null,62.86,10,0,72.86,54.05,null,null,17,null,1,null,null,54.05,8.5,5,67.55,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[37,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J39>0,OR(AND(G39=1,G48=10),AND(G39=2,G57=20),AND(G39=3,G66=30),AND(G39=4,G75=40),AND(G39=5,G84=50),AND(G39=6,G93=60),AND(G39=7,G102=70),AND(G39=8,G111=80),AND(G39=9,G120=90),AND(G39=10,G129=100))),VLOOKUP(J39-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E39,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E39,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F39,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F39,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[38,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J40>0,OR(AND(G40=1,G49=10),AND(G40=2,G58=20),AND(G40=3,G67=30),AND(G40=4,G76=40),AND(G40=5,G85=50),AND(G40=6,G94=60),AND(G40=7,G103=70),AND(G40=8,G112=80),AND(G40=9,G121=90),AND(G40=10,G130=100))),VLOOKUP(J40-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E40,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E40,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F40,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F40,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[39,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J41>0,OR(AND(G41=1,G50=10),AND(G41=2,G59=20),AND(G41=3,G68=30),AND(G41=4,G77=40),AND(G41=5,G86=50),AND(G41=6,G95=60),AND(G41=7,G104=70),AND(G41=8,G113=80),AND(G41=9,G122=90),AND(G41=10,G131=100))),VLOOKUP(J41-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E41,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E41,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F41,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F41,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[40,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J42>0,OR(AND(G42=1,G51=10),AND(G42=2,G60=20),AND(G42=3,G69=30),AND(G42=4,G78=40),AND(G42=5,G87=50),AND(G42=6,G96=60),AND(G42=7,G105=70),AND(G42=8,G114=80),AND(G42=9,G123=90),AND(G42=10,G132=100))),VLOOKUP(J42-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E42,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E42,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F42,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F42,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[41,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J43>0,OR(AND(G43=1,G52=10),AND(G43=2,G61=20),AND(G43=3,G70=30),AND(G43=4,G79=40),AND(G43=5,G88=50),AND(G43=6,G97=60),AND(G43=7,G106=70),AND(G43=8,G115=80),AND(G43=9,G124=90),AND(G43=10,G133=100))),VLOOKUP(J43-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E43,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E43,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F43,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F43,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[42,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J44>0,OR(AND(G44=1,G53=10),AND(G44=2,G62=20),AND(G44=3,G71=30),AND(G44=4,G80=40),AND(G44=5,G89=50),AND(G44=6,G98=60),AND(G44=7,G107=70),AND(G44=8,G116=80),AND(G44=9,G125=90),AND(G44=10,G134=100))),VLOOKUP(J44-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E44,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E44,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F44,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F44,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[43,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J45>0,OR(AND(G45=1,G54=10),AND(G45=2,G63=20),AND(G45=3,G72=30),AND(G45=4,G81=40),AND(G45=5,G90=50),AND(G45=6,G99=60),AND(G45=7,G108=70),AND(G45=8,G117=80),AND(G45=9,G126=90),AND(G45=10,G135=100))),VLOOKUP(J45-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E45,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E45,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F45,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F45,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[44,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J46>0,OR(AND(G46=1,G55=10),AND(G46=2,G64=20),AND(G46=3,G73=30),AND(G46=4,G82=40),AND(G46=5,G91=50),AND(G46=6,G100=60),AND(G46=7,G109=70),AND(G46=8,G118=80),AND(G46=9,G127=90),AND(G46=10,G136=100))),VLOOKUP(J46-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E46,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E46,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F46,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F46,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[45,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J47>0,OR(AND(G47=1,G56=10),AND(G47=2,G65=20),AND(G47=3,G74=30),AND(G47=4,G83=40),AND(G47=5,G92=50),AND(G47=6,G101=60),AND(G47=7,G110=70),AND(G47=8,G119=80),AND(G47=9,G128=90),AND(G47=10,G137=100))),VLOOKUP(J47-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E47,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E47,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F47,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F47,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[46,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J48>0,OR(AND(G48=1,G57=10),AND(G48=2,G66=20),AND(G48=3,G75=30),AND(G48=4,G84=40),AND(G48=5,G93=50),AND(G48=6,G102=60),AND(G48=7,G111=70),AND(G48=8,G120=80),AND(G48=9,G129=90),AND(G48=10,G138=100))),VLOOKUP(J48-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E48,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E48,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F48,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F48,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[47,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J49>0,OR(AND(G49=1,G58=10),AND(G49=2,G67=20),AND(G49=3,G76=30),AND(G49=4,G85=40),AND(G49=5,G94=50),AND(G49=6,G103=60),AND(G49=7,G112=70),AND(G49=8,G121=80),AND(G49=9,G130=90),AND(G49=10,G139=100))),VLOOKUP(J49-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E49,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E49,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F49,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F49,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[48,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J50>0,OR(AND(G50=1,G59=10),AND(G50=2,G68=20),AND(G50=3,G77=30),AND(G50=4,G86=40),AND(G50=5,G95=50),AND(G50=6,G104=60),AND(G50=7,G113=70),AND(G50=8,G122=80),AND(G50=9,G131=90),AND(G50=10,G140=100))),VLOOKUP(J50-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E50,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E50,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F50,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F50,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[49,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J51>0,OR(AND(G51=1,G60=10),AND(G51=2,G69=20),AND(G51=3,G78=30),AND(G51=4,G87=40),AND(G51=5,G96=50),AND(G51=6,G105=60),AND(G51=7,G114=70),AND(G51=8,G123=80),AND(G51=9,G132=90),AND(G51=10,G141=100))),VLOOKUP(J51-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E51,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E51,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F51,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F51,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]
[50,null,null,null,null,null,"",{"$f":"IF(AND($H$2=\"Y\",J52>0,OR(AND(G52=1,G61=10),AND(G52=2,G70=20),AND(G52=3,G79=30),AND(G52=4,G88=40),AND(G52=5,G97=50),AND(G52=6,G106=60),AND(G52=7,G115=70),AND(G52=8,G124=80),AND(G52=9,G133=90),AND(G52=10,G142=100))),VLOOKUP(J52-1,SortLookup!$A$13:$B$16,2,FALSE),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E52,SortLookup!$A$1:$B$5,2,FALSE)),\" \",VLOOKUP(E52,SortLookup!$A$1:$B$5,2,FALSE))","v":" "},{"$f":"IF(ISNA(VLOOKUP(F52,SortLookup!$A$7:$B$11,2,FALSE)),\" \",VLOOKUP(F52,SortLookup!$A$7:$B$11,2,FALSE))","v":" "},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0]

{"sheet":"SortLookup","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["SSP",0,"IDPA Match Scoring Spreadsheet Sort Key lookup table"]
["ESP",1,"Table used to convert IDPA Divisions and classes into numeric sort keys."]
["CDP",2,"The sort keys can then be used with the total match scores to produce a sort by score within division and class."]
["ESR",3,"The shooter's division is looked up in the upper table and converted to anumber."]
["SSR",4,"Then his or her class is looked up in the lower table and converted to a number."]
[]
["MA",0,"A three-column sort on the division sort key first, class sort key next, and total match score third will yield a properly-ordered report."]
["EX",1]
["SS",2]
["MM",3]
["NV",4]
[]
[0,"MA","This table is used to look up IDPA Classes using the numeric Class Sort Key value for purposes of promotions at sanctioned matches."]
[1,"EX"]
[2,"SS"]
[3,"MM"]
[4," ","Invalid Shooter Class entered on spreadsheet!"]

{"sheet":"Help","index":2,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Help and instructions for this spreadsheet are available on the CCIDPA web site at http://www.ccidpa.org/scoring/spreadsheets.html"]
[]
[]
["If you delete rows in the scoring spreadsheet, and column H \"blows up\" with #REF! errors, replace the formulas in column H:"]
["(Remember to add the equal sign at the beginning of this formula!)"]
[]
["   1. Unprotect the scoring worksheet using Tools->Protection->Unprotect Sheet. "]
["   2. Select this Help worksheet, and copy the formula below."]
["   3. Return to the scoring worksheet."]
["   4. Paste the copied formula into cell H3, and add an equal sign to the beginning of it."]
["   5. Left-click and select the cell at location H3."]
["   6. Place the cursor on the little black box that appears at the bottom right of cell H3. "]
["   7. Press and hold the left mouse button, and drag the little black box all the way down to the last active row of your spreadsheet. "]
["   8. Re-protect the worksheet using Tools->Protection->Protect Sheet. Uncheck all boxes, except for \"Select unlocked cells.\" "]
[]
["IF(AND($H$2=\"Y\",J3>0,OR(AND(G3=1,G12=10),AND(G3=2,G21=20),AND(G3=3,G30=30),AND(G3=4,G39=40),AND(G3=5,G48=50),AND(G3=6,G57=60),AND(G3=7,G66=70),AND(G3=8,G75=80),AND(G3=9,G84=90),AND(G3=10,G93=100))),VLOOKUP(J3-1,SortLookup!$A$12:$B$15,2,FALSE),\"\")"]
[]
[]
["The Match Ranking and Match Promotion features (columns G and H) won't work properly until you have sorted your results by Division, Class, and Total Match Score."]
[]
[]
["Columns I and J (Sort Div and Sort Class) are provided to allow a quick, three-column sort for final match results."]
["   1. Unprotect the scoring worksheet using Tools->Protection->Unprotect Sheet. "]
["   2. Select any cell in the spreadsheet."]
["   3. Select Data->Sort"]
["   4. In the Sort By box, select Sort Div."]
["   5. In the first Then By box, select Sort Class."]
["   6. In the second Then By box, select Total Match Score."]
["   7. In most cases, you will want to select Ascending order in all three radio buttons."]
["   8. Click OK to sort your match results."]
["   9. Re-protect the worksheet using Tools->Protection->Protect Sheet. Uncheck all boxes, except for \"Select unlocked cells.\""]