{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["How to use","Teams","Ranking","Sprint","H2H","Slalom","Downriver","Defaults","Points"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"How to use","index":0,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["How to use this excel sheet when timing a rafting competition with RaceGorilla"]
[]
[null,"This sheet is made to help organising a rafting competition."]
[null,"It is an addition to the RaceGorilla software. It's free to use when using RaceGorilla in a payed competition."]
[null,"This excel file can be used for rafting competitions from 4 up to 32 teams. For each category a different sheet has te be used."]
[null,"Of course RaceGorilla can handle many more teams and starts, it's just that the pairing for teams is set in this sheet up to 32 teams."]
[null,"There is an extended tutorial available to run your competition step by step."]
[]
[null,"Note that organising a race is time consuming."]
[null,"Timekeeping is an additional task / mission. It requires dedication, skill and experience."]
[null,"Timekeeping requires an experienced team on key positions."]
[]
[null,"The RaceGorilla software is designed to manually time and score races and get live results, in order to have a low budget solution while still having accurate and live results."]
[null,"A rafting competition is quite special in the set-up, as there are 4 different stages and"]
[null,"a ranking system."]
[null,"This excel sheet is based on earlier versions of the available ICF-score sheets."]
[null,"In addition to the official sheet, there are import macros to process the RaceGorilla results."]
[null,"Make sure that you are well informed about the recent rules and regulations!"]
[]
[null,"How it works:"]
[null,1,"Download a blank sheet"]
[null,2,"Set up a rafting competition in RaceGorilla",null,null,null,null,"https://my.racegorilla.com/competitions"]
[null,null,null,"Use Sport Rafting, Format Sprint, H2H, Slalom, Downriver"]
[null,3,"Set the catogeries you want to use, both in RaceGorilla as well as in the settings tab of this sheet.  "]
[null,null,null,"default category in RaceGorilla are Men and Women, but you might want to use Competition, Recreational, Juniors etc."]
[null,4,"Enter all team subscribtions in the Teams tab, including the correct bibnumbers, tags etc."]
[null,5,"Export the start list to CSV, Use the button on the team tab"]
[]
[null,6,"Import the start list in RaceGorilla at the participants tab of your competition using the dashboard."]
[]
[null,"You are now ready to have your race."]
[null,"Start with the sprint. Make sure your team of volunteers (start, finish, race office) is well trained for the job!"]
[]
[null,"After the sprint, export the results per category as a .CSV-file from the print section in the RaceGorilla dashboard "]
[null,"For each category, you will need a separate excel sheet for the import macro's to work correct."]
[]
[null,"Import the sprint results into the Sprint tab, using the macro button"]
[null,null,"This macro will import the sprint results, place the team names on the ranking tab and will make the start list for the H2H."]
[null,null,"There is always discussion going on about the pairing of the H2H, I've done my utmost to follow the IRF rules, but i'm always open for improvement."]
[]
[null,"When timing the H2H, Use a new run in RaceGorilla for each next round."]
[null,"All teams are available to start in each run, as a race admin, you can DNS each eliminated team to make things esier for the starter"]
[null,"As a timing official, it is wise to keep an eye on the finish as well, and check which teams are progressing and eliminated, to make sure the timers at the finishline can stick to their job of timming."]
[null,"The starter has to select the 2 team at the start, so the starter has to recieve pairs for each round (on paper or by portophone)"]
[]
[null,"The H2H times have to be filled in by hand into the H2H tab. (the red marked cells have to be filled in)."]
[null,"After the H2H, the Ranking tab is updated automatically, and sorted to the maximum points."]
[]
[null,"That was the hardest part…."]
[null,"The slalom and the downriver can be done using RaceGorilla and the RceGorilla-Competition app with the live results available (especially interesting for slalom)"]
[null,"The exports from RaceGorilla can be made and imported to this excel sheet,using the import buttons on the slalom and downriver tabs."]
[null,"If you want, you can make multiple start groups (start waves) for the downriver."]
[]
[null,"Check your results before publishing and the award ceremony!"]

{"sheet":"Teams","index":1,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Bib","Team","First Name","Last Name","Gender","Category","Tags","Club","Country"]
[1,"Team 1","Captain","Name","Male","Competition",null,"Ajax","Netherlands"]
[2,"Team 2","Captain","Name","Male","Competition",null,"Barcelona","Spain"]
[3,"Team 3","Captain","Name","Male","Competition","Juniors","Arsenal","Italy"]
[4,"Team 4","Captain","Name","Male","Competition",null,"Ajax","Poland"]
[5,"Team 5","Captain","Name","Male","Competition",null,"Ajax","Portugal"]
[6,"Team 6","Captain","Name","Male","Competition",null,"Barcelona","Spain"]
[7,"Team 7","Captain","Name","Female","Competition","Women","Ajax","Netherlands"]
[8,"Team 8","Captain","Name","Male","Competition",null,"Barcelona","Spain"]
[9,"Team 9","Captain","Name","Male","Competition",null,"Arsenal","Italy"]
[10,"Team 10","Captain","Name","Mixed","Competition","Mixed","Ajax","Poland"]
[11,"Team 11","Captain","Name","Mixed","Competition","Mixed","Ajax","Portugal"]
[12,"Team 12","Captain","Name","Male","Competition",null,"Barcelona","Spain"]
[13,"Team 13","Captain","Name","Male","Competition","Juniors","Ajax","Netherlands"]
[14,"Team 14","Captain","Name","Male","Competition",null,"Barcelona","Spain"]
[15,"Team 15","Captain","Name","Male","Competition",null,"Arsenal","Italy"]
[16,"Team 16","Captain","Name","Mixed","Competition","Mixed","Ajax","Poland"]
[17,"Team 17","Captain","Name","Mixed","Competition","Mixed","Ajax","Portugal"]
[18,"Team 18","Captain","Name","Male","Competition",null,"Barcelona","Spain"]
[19,"Team 19","Captain","Name","Male","Competition","Juniors","Ajax","Netherlands"]
[20,"Team 20","Captain","Name","Male","Competition",null,"Barcelona","Spain"]
[21,"Team 21","Captain","Name","Mixed","Competition","Mixed","Ajax","Portugal"]

{"sheet":"Ranking","index":2,"n_rows":7,"n_cols":25,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,3,3,4],[3,6,3,14],[3,23,3,24],[3,16,3,17],[3,21,3,22]]}
[null,null,null,null,"My Rafting Race",null,null,null,null,"Location",null,null,null,{"$f":"TODAY()","v":"2021-03-14"}]
[]
[]
[5,25,"Cat.:","Catogery",null,null,"Points",null,null,null,null,null,null,null,null,null,"Sprint",null,"Head to  Head",null,null,"Slalom",null,"Downriver"]
[6,31,"Rank","Bib","Teams","Tag","Total","Sprint","Points sprint","H2H","Points H2H","Slalom","Points Slalom","Downriver","Points Downriver","Kolom5","Time Sprint","Rank Sprint","Time H2H","Level","Rank H2H","Best Time Slalom","Rank Slalom","Time Downriver","Rank Downriver"]
[7,24,1,null,null,null,{"$f":"Tabel1[[#This Row],[Points sprint]]+Tabel1[[#This Row],[Points H2H]]+Tabel1[[#This Row],[Points Slalom]]","v":{"$error":"#N/A"}},{"$f":"Tabel1[[#This Row],[Rank Sprint]]","v":{"$error":"#N/A"}},{"$f":"IF(Q6=\"\",\"0\",(VLOOKUP(R6,Points!$A$2:$E$32,2,FALSE)))","v":{"$error":"#N/A"}},{"$f":"Tabel1[[#This Row],[Rank H2H]]","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,H2H!$F$2:$K$32,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"W6","v":{"$error":"#N/A"}},{"$f":"IF(L6=\"\",\"0\",(VLOOKUP(L6,Points!$A$2:$E$32,3,FALSE)))","v":{"$error":"#N/A"}},{"$f":"Y6","v":{"$error":"#N/A"}},{"$f":"IF(X6=\"\",\"0\",(VLOOKUP(Y6,Points!$A$2:$E$32,5,FALSE)))","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(D6,Sprint!B$2:E$33,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,Sprint!B$2:F$33,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,H2H!F$2:J$37,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,H2H!F$2:J$37,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,H2H!$F$2:$J$37,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,Slalom!$B$2:$H$33,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,Slalom!$B$2:$H$33,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,Downriver!$B$2:$F$33,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,Downriver!$B$2:$F$33,5,FALSE)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"C6+1","v":2},null,null,null,{"$f":"Tabel1[[#This Row],[Points sprint]]+Tabel1[[#This Row],[Points H2H]]+Tabel1[[#This Row],[Points Slalom]]","v":{"$error":"#N/A"}},{"$f":"Tabel1[[#This Row],[Rank Sprint]]","v":{"$error":"#N/A"}},{"$f":"IF(Q7=\"\",\"0\",(VLOOKUP(R7,Points!$A$2:$E$32,2,FALSE)))","v":{"$error":"#N/A"}},{"$f":"Tabel1[[#This Row],[Rank H2H]]","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,H2H!$F$2:$K$32,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"W7","v":{"$error":"#N/A"}},{"$f":"IF(L7=\"\",\"0\",(VLOOKUP(L7,Points!$A$2:$E$32,3,FALSE)))","v":{"$error":"#N/A"}},{"$f":"Y7","v":{"$error":"#N/A"}},{"$f":"IF(X7=\"\",\"0\",(VLOOKUP(Y7,Points!$A$2:$E$32,5,FALSE)))","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(D7,Sprint!B$2:E$33,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,Sprint!B$2:F$33,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,H2H!F$2:J$37,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,H2H!F$2:J$37,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,H2H!$F$2:$J$37,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,Slalom!$B$2:$H$33,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,Slalom!$B$2:$H$33,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,Downriver!$B$2:$F$33,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,Downriver!$B$2:$F$33,5,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Sprint","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Rank"]
[null,null,null,null,null,1]
[null,null,null,null,null,2]
[null,null,null,null,null,3]
[null,null,null,null,null,4]
[null,null,null,null,null,5]
[null,null,null,null,null,6]
[null,null,null,null,null,7]
[null,null,null,null,null,8]
[null,null,null,null,null,9]
[null,null,null,null,null,10]
[null,null,null,null,null,11]
[null,null,null,null,null,12]
[null,null,null,null,null,13]
[null,null,null,null,null,14]
[null,null,null,null,null,15]
[null,null,null,null,null,16]
[null,null,null,null,null,17]
[null,null,null,null,null,18]
[null,null,null,null,null,19]
[null,null,null,null,null,20]
[null,null,null,null,null,21]
[null,null,null,null,null,22]
[null,null,null,null,null,23]
[null,null,null,null,null,24]
[null,null,null,null,null,25]
[null,null,null,null,null,26]
[null,null,null,null,null,27]
[null,null,null,null,null,28]
[null,null,null,null,null,29]
[null,null,null,null,null,30]
[null,null,null,null,null,31]
[null,null,null,null,null,32]

{"sheet":"H2H","index":4,"n_rows":65,"n_cols":53,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Results sprint:",null,null,"Results H2H:","Rank","Bib","Team","Time","Position","Round","Points","Max teams",{"$f":"MAX(A:A)","v":0},"Print column N-O-P as startlist",null,null,null,null,null,"Print column T-U-V-W as startlist"]
[null,null,null,"Final",1,{"$f":"IF(BA9=1,AV9,AV11)","v":{"$error":"#N/A"}},{"$f":"IF(BA9=1,AW9,AW11)","v":{"$error":"#N/A"}},{"$f":"IF(BA9=1,AZ9,AZ11)","v":0},{"$f":"E2","v":1},"Final",200,null,null,"Fill in the red marked cells from the CloudTimer results",null,null,null,null,null,"Fill in the red marked cells from the CloudTimer results"]
[null,null,null,null,2,{"$f":"IF(BA11=1,AV9,AV11)","v":{"$error":"#N/A"}},{"$f":"IF(BA11=1,AW9,AW11)","v":{"$error":"#N/A"}},{"$f":"IF(BA11=1,AZ9,AZ11)","v":1},{"$f":"E3","v":2},"Final",176,null,1,"Run 1",null,"Chooses Lane","Enter time","Rank",null,"Run 2",null,"best time","Chooses Lane","Enter time","Rank",null,null,"Quarter Finals Copetition",null,null,null,null,null,null,"Semifinals Competition",null,null,null,null,null,null,"B-finals",null,null,null,null,null,null,"A-Finals"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A17","v":0},{"$f":"VLOOKUP(M4,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M4,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q4,Q4:Q5,1)","v":1},null,{"$f":"IF(R4=1,N4,N5)","v":{"$error":"#N/A"}},{"$f":"IF(R4=1,O4,O5)","v":{"$error":"#N/A"}},{"$f":"IF(R4=1,Q4,Q5)","v":0},{"$f":"IF(V4<V5,\"*\",\"\")","v":""},51.64,{"$f":"RANK(X4,X4:X5,1)","v":2},null,null,"Run 3",null,"best time","Chooses Lane","Enter time","Rank",null,"Run 4",null,null,null,"Enter time","Rank",null,"Run 4",null,null,null,null,null,null,"Run 4"]
[null,null,null,"Final B",3,{"$f":"IF(AU8=3,AP8,AP12)","v":{"$error":"#N/A"}},{"$f":"IF(AU8=3,AQ8,AQ12)","v":{"$error":"#N/A"}},{"$f":"IF(AU8=3,AT8,AT12)","v":0},3,"Final B",158,null,{"$f":"IF(M$1>32-M4,M$1-16+M4,\"\")","v":""},{"$f":"VLOOKUP(M5,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M5,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q5,Q4:Q5,1)","v":2},null,{"$f":"IF(R8=1,N8,N9)","v":{"$error":"#N/A"}},{"$f":"IF(R8=1,O8,O9)","v":{"$error":"#N/A"}},{"$f":"IF(R8=1,Q8,Q9)","v":0},{"$f":"IF(V4>V5,\"*\",\"\")","v":""},43.81,{"$f":"RANK(X5,X4:X5,1)","v":1},null,null,{"$f":"IF(Y4=1,T4,T5)","v":{"$error":"#N/A"}},{"$f":"IF(Y4=1,U4,U5)","v":{"$error":"#N/A"}},{"$f":"IF(Y4=1,X4,X5)","v":43.81},{"$f":"IF(AD5<AD6,\"*\",\"\")","v":"*"},0.5,{"$f":"RANK(AF5,AF$5:AF$6,1)","v":1},null,"bib","team","best time","Chooses Lane"]
[null,null,null,null,4,{"$f":"IF(AU12=3,AP8,AP12)","v":{"$error":"#N/A"}},{"$f":"IF(AU12=3,AQ8,AQ12)","v":{"$error":"#N/A"}},{"$f":"IF(AU12=3,AT8,AT12)","v":1},4,"Final B",144,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y8=1,T8,T9)","v":{"$error":"#N/A"}},{"$f":"IF(Y8=1,U8,U9)","v":{"$error":"#N/A"}},{"$f":"IF(Y8=1,X8,X9)","v":54.88},{"$f":"IF(AD5>AD6,\"*\",\"\")","v":""},6,{"$f":"RANK(AF6,AF$5:AF$6,1)","v":2},"winner =>",{"$f":"IF(AG5=1,AB5,AB6)","v":{"$error":"#N/A"}},{"$f":"IF(AG5=1,AC5,AC6)","v":{"$error":"#N/A"}},{"$f":"IF(AG5=1,AF5,AF6)","v":0.5},{"$f":"IF(AK6<AK8,\"*\",\"\")","v":""},0.3,{"$f":"RANK(AM6,AM$6:AM$8,1)","v":1},"winner => =>",null,null,null,null,null," => =>"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,"Rank",null,null,null,null,null,null,"Rank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"team","best time","Chooses Lane","vul tijd in","End Rank"]
[null,null,null,"Quarter finals",{"$f":"4+RANK(H8,H$8:H$11,1)","v":5},{"$f":"IF(AG5=2,AB5,AB6)","v":{"$error":"#N/A"}},{"$f":"IF(AG5=2,AC5,AC6)","v":{"$error":"#N/A"}},{"$f":"IF(AG5=2,AF5,AF6)","v":6},5,"Quarter finals",{"$f":"VLOOKUP(E8,Points!A$6:D$10,4,1)","v":138},null,{"$f":"A9","v":0},{"$f":"VLOOKUP(M8,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M8,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q8,Q8:Q9,1)","v":1},null,{"$f":"IF(R12=1,N12,N13)","v":{"$error":"#N/A"}},{"$f":"IF(R12=1,O12,O13)","v":{"$error":"#N/A"}},{"$f":"IF(R12=1,Q12,Q13)","v":0},{"$f":"IF(V8<V9,\"*\",\"\")","v":""},56.22,{"$f":"RANK(X8,X8:X9,1)","v":2},null,null,{"$f":"IF(Y12=1,T12,T13)","v":{"$error":"#N/A"}},{"$f":"IF(Y12=1,U12,U13)","v":{"$error":"#N/A"}},{"$f":"IF(Y12=1,X12,X13)","v":55.48},{"$f":"IF(AD8<AD9,\"*\",\"\")","v":"*"},0,{"$f":"RANK(AF8,AF$8:AF$9,1)","v":1},"winner =>",{"$f":"IF(AG8=1,AB8,AB9)","v":{"$error":"#N/A"}},{"$f":"IF(AG8=1,AC8,AC9)","v":{"$error":"#N/A"}},{"$f":"IF(AG8=1,AF8,AF9)","v":0},{"$f":"IF(AK6>AK8,\"*\",\"\")","v":"*"},1,{"$f":"RANK(AM8,AM$6:AM$8,1)","v":2},"Loser =>",{"$f":"IF(AN8=1,AI6,AI8)","v":{"$error":"#N/A"}},{"$f":"IF(AN8=1,AJ6,AJ8)","v":{"$error":"#N/A"}},{"$f":"IF(AN6=2,AM6,AM8)","v":1},{"$f":"IF(AR8<AR12,\"*\",\"\")","v":""},0,{"$f":"2+RANK(AT8,AT$8:AT$12,1)","v":3},null,"team","best time","Chooses Lane","vul tijd in"]
[null,null,null,null,{"$f":"4+RANK(H9,H$8:H$11,1)","v":6},{"$f":"IF(AG8=2,AB8,AB9)","v":{"$error":"#N/A"}},{"$f":"IF(AG8=2,AC8,AC9)","v":{"$error":"#N/A"}},{"$f":"IF(AG8=2,AF8,AF9)","v":46},6,"Quarter finals",{"$f":"VLOOKUP(E9,Points!A$6:D$10,4,1)","v":132},null,{"$f":"IF(M$1>32-M8,M$1-16+M8,\"\")","v":""},{"$f":"VLOOKUP(M9,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M9,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q9,Q8:Q9,1)","v":2},null,{"$f":"IF(R16=1,N16,N17)","v":{"$error":"#N/A"}},{"$f":"IF(R16=1,O16,O17)","v":{"$error":"#N/A"}},{"$f":"IF(R16=1,Q16,Q17)","v":0},{"$f":"IF(V8>V9,\"*\",\"\")","v":""},54.88,{"$f":"RANK(X9,X8:X9,1)","v":1},null,null,{"$f":"IF(Y16=1,T16,T17)","v":{"$error":"#N/A"}},{"$f":"IF(Y16=1,U16,U17)","v":{"$error":"#N/A"}},{"$f":"IF(Y16=1,X16,X17)","v":57.18},{"$f":"IF(AD8>AD9,\"*\",\"\")","v":""},46,{"$f":"RANK(AF9,AF$8:AF$9,1)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AN6=1,AI6,AI8)","v":{"$error":"#N/A"}},{"$f":"IF(AN6=1,AJ6,AJ8)","v":{"$error":"#N/A"}},{"$f":"IF(AN6=1,AM6,AM8)","v":0.3},{"$f":"IF(AX9<AX11,\"*\",\"\")","v":""},0,{"$f":"RANK(AZ9,AZ$9:AZ$11,1)","v":1}]
[null,null,null,null,7,{"$f":"IF(AG11=2,AB11,AB12)","v":{"$error":"#N/A"}},{"$f":"IF(AG11=2,AC11,AC12)","v":{"$error":"#N/A"}},{"$f":"IF(AG11=2,AF11,AF12)","v":75},7,"Quarter finals",{"$f":"VLOOKUP(E10,Points!A$6:D$10,4,1)","v":126}]
[null,null,null,null,8,{"$f":"IF(AG14=2,AB14,AB15)","v":{"$error":"#N/A"}},{"$f":"IF(AG14=2,AC14,AC15)","v":{"$error":"#N/A"}},{"$f":"IF(AG14=2,AF14,AF15)","v":668},8,"Quarter finals",{"$f":"VLOOKUP(E11,Points!A$6:D$10,4,1)","v":120},null,3,null,null,null,null,"Rank",null,null,null,null,null,null,"Rank",null,null,{"$f":"IF(Y20=1,T20,T21)","v":{"$error":"#N/A"}},{"$f":"IF(Y20=1,U20,U21)","v":{"$error":"#N/A"}},{"$f":"IF(Y16=1,X16,X17)","v":57.18},{"$f":"IF(AD11<AD12,\"*\",\"\")","v":"*"},0.6,{"$f":"RANK(AF11,AF$11:AF$12,1)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AN12=1,AI12,AI14)","v":{"$error":"#N/A"}},{"$f":"IF(AN12=1,AJ12,AJ14)","v":{"$error":"#N/A"}},{"$f":"IF(AN12=1,AM12,AM14)","v":0.2},{"$f":"IF(AX9>AX11,\"*\",\"\")","v":"*"},1,{"$f":"RANK(AZ11,AZ$9:AZ$11,1)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A15","v":0},{"$f":"VLOOKUP(M12,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M12,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q12,Q12:Q13,1)","v":1},null,{"$f":"IF(R20=1,N20,N21)","v":{"$error":"#N/A"}},{"$f":"IF(R20=1,O20,O21)","v":{"$error":"#N/A"}},{"$f":"IF(R20=1,Q20,Q21)","v":0},{"$f":"IF(V12<V13,\"*\",\"\")","v":""},58.42,{"$f":"RANK(X12,X12:X13,1)","v":2},null,null,{"$f":"IF(Y24=1,T24,T25)","v":{"$error":"#N/A"}},{"$f":"IF(Y24=1,U24,U25)","v":{"$error":"#N/A"}},{"$f":"IF(Y24=1,X24,X25)","v":65},{"$f":"IF(AD11>AD12,\"*\",\"\")","v":""},75,{"$f":"RANK(AF12,AF$11:AF$12,1)","v":2},"winner =>",{"$f":"IF(AG11=1,AB11,AB12)","v":{"$error":"#N/A"}},{"$f":"IF(AG11=1,AC11,AC12)","v":{"$error":"#N/A"}},{"$f":"IF(AG11=1,AF11,AF12)","v":0.6},{"$f":"IF(AK12<AK14,\"*\",\"\")","v":""},0.2,{"$f":"RANK(AM12,AM$12:AM$14,1)","v":1},"Loser =>",{"$f":"IF(AN12=1,AI14,AI12)","v":{"$error":"#N/A"}},{"$f":"IF(AN12=1,AJ14,AJ12)","v":{"$error":"#N/A"}},{"$f":"IF(AN12=2,AM12,AM14)","v":0.8},{"$f":"IF(AR8>AR12,\"*\",\"\")","v":"*"},1,{"$f":"2+RANK(AT12,AT$8:AT$12,1)","v":4}]
[null,null,null,"Round 1",{"$f":"IF(F13>0,(17-RANK(H13,H$13:H$20,0)),\"NB\")","v":{"$error":"#N/A"}},{"$f":"IF(Y4=2,T4,T5)","v":{"$error":"#N/A"}},{"$f":"IF(Y4=2,U4,U5)","v":{"$error":"#N/A"}},{"$f":"IF(Y4=2,X4,X5)","v":51.64},{"$error":"#N/A"},"Round 1",{"$f":"VLOOKUP(E13,Points!A$10:D$40,4,1)","v":{"$error":"#N/A"}},null,{"$f":"IF(M$1>32-M12,M$1-16+M12,\"\")","v":""},{"$f":"VLOOKUP(M13,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M13,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1.5,{"$f":"RANK(Q13,Q12:Q13,1)","v":2},null,{"$f":"IF(R24=1,N24,N25)","v":{"$error":"#N/A"}},{"$f":"IF(R24=1,O24,O25)","v":{"$error":"#N/A"}},{"$f":"IF(R24=1,Q24,Q25)","v":0},{"$f":"IF(V12>V13,\"*\",\"\")","v":""},55.48,{"$f":"RANK(X13,X12:X13,1)","v":1}]
[null,null,null,null,{"$f":"IF(F14>0,(17-RANK(H14,H$13:H$20,0)),\"NB\")","v":{"$error":"#N/A"}},{"$f":"IF(Y8=2,T8,T9)","v":{"$error":"#N/A"}},{"$f":"IF(Y8=2,U8,U9)","v":{"$error":"#N/A"}},{"$f":"IF(Y8=2,X8,X9)","v":56.22},{"$error":"#N/A"},"Round 1",{"$f":"VLOOKUP(E14,Points!A$10:D$40,4,1)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y28=1,T28,T29)","v":{"$error":"#N/A"}},{"$f":"IF(Y28=1,U28,U29)","v":{"$error":"#N/A"}},{"$f":"IF(Y28=1,X28,X29)","v":69.12},{"$f":"IF(AD14<AD15,\"*\",\"\")","v":""},0,{"$f":"RANK(AF14,AF$14:AF$15,1)","v":1},"winner =>",{"$f":"IF(AG14=1,AB14,AB15)","v":{"$error":"#N/A"}},{"$f":"IF(AG14=1,AC14,AC15)","v":{"$error":"#N/A"}},{"$f":"IF(AG14=1,AF14,AF15)","v":0},{"$f":"IF(AK12>AK14,\"*\",\"\")","v":"*"},0.8,{"$f":"RANK(AM14,AM$12:AM$14,1)","v":2},"winner => =>",null,null,null,null,null," => =>"]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(Y12=2,T12,T13)","v":{"$error":"#N/A"}},{"$f":"IF(Y12=2,U12,U13)","v":{"$error":"#N/A"}},{"$f":"IF(Y12=2,X12,X13)","v":58.42},{"$error":"#N/A"},"Round 1",{"$f":"VLOOKUP(E15,Points!A$10:D$40,4,1)","v":{"$error":"#N/A"}},null,4,null,null,null,null,"Rank",null,null,null,null,null,null,"Rank",null,null,{"$f":"IF(Y32=1,T32,T33)","v":{"$error":"#N/A"}},{"$f":"IF(Y32=1,U32,U33)","v":{"$error":"#N/A"}},{"$f":"IF(Y32=1,X32,X33)","v":55.66},{"$f":"IF(AD14>AD15,\"*\",\"\")","v":"*"},668,{"$f":"RANK(AF15,AF$14:AF$15,1)","v":2}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(Y16=2,T16,T17)","v":{"$error":"#N/A"}},{"$f":"IF(Y16=2,U16,U17)","v":{"$error":"#N/A"}},{"$f":"IF(Y16=2,X16,X17)","v":60.37},{"$error":"#N/A"},"Round 1",{"$f":"VLOOKUP(E16,Points!A$10:D$40,4,1)","v":{"$error":"#N/A"}},null,{"$f":"A5","v":0},{"$f":"VLOOKUP(M16,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M16,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q16,Q16:Q17,1)","v":1},null,{"$f":"IF(R28=1,N28,N29)","v":{"$error":"#N/A"}},{"$f":"IF(R28=1,O28,O29)","v":{"$error":"#N/A"}},{"$f":"IF(R28=1,Q28,Q29)","v":0},{"$f":"IF(V16<V17,\"*\",\"\")","v":""},57.18,{"$f":"RANK(X16,X16:X17,1)","v":1}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(Y20=2,T20,T21)","v":{"$error":"#N/A"}},{"$f":"IF(Y8=2,U8,U9)","v":{"$error":"#N/A"}},{"$f":"IF(Y20=2,X20,X21)","v":61.21},{"$error":"#N/A"},"Round 1",{"$f":"VLOOKUP(E17,Points!A$10:D$40,4,1)","v":{"$error":"#N/A"}},null,{"$f":"IF(M$1>32-M16,M$1-16+M16,\"\")","v":""},{"$f":"VLOOKUP(M17,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M17,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q17,Q16:Q17,1)","v":2},null,{"$f":"IF(R32=1,N32,N33)","v":{"$error":"#N/A"}},{"$f":"IF(R32=1,O32,O33)","v":{"$error":"#N/A"}},{"$f":"IF(R32=1,Q32,Q33)","v":0},{"$f":"IF(V16>V17,\"*\",\"\")","v":""},60.37,{"$f":"RANK(X17,X16:X17,1)","v":2},null,null,"DNS for run 3,4,5 (Quarter, semi, and final)",null,null,null,null,null,null,"DNS for run 3 and 4 (semifinal and final)"]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(Y24=2,T24,T25)","v":{"$error":"#N/A"}},{"$f":"IF(Y24=2,U24,U25)","v":{"$error":"#N/A"}},{"$f":"IF(Y24=2,X24,X25)","v":68.239999999999995},{"$error":"#N/A"},"Round 1",{"$f":"VLOOKUP(E18,Points!A$10:D$40,4,1)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DNS:",{"$f":"IF(Y4=2,U4,U5)","v":{"$error":"#N/A"}},null,null,null,null,null,"DNS:",{"$f":"IF(AG5=2,AC5,AC6)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(Y28=2,T28,T29)","v":{"$error":"#N/A"}},{"$f":"IF(Y28=2,U28,U29)","v":{"$error":"#N/A"}},{"$f":"IF(Y28=2,X28,X29)","v":85.24},{"$error":"#N/A"},"Round 1",{"$f":"VLOOKUP(E19,Points!A$10:D$40,4,1)","v":{"$error":"#N/A"}},null,5,null,null,null,null,"Rank",null,null,null,null,null,null,"Rank",null,null,"DNS:",{"$f":"IF(Y8=2,U8,U9)","v":{"$error":"#N/A"}},null,null,null,null,null,"DNS:",{"$f":"IF(AG8=2,AC8,AC9)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(Y32=2,T32,T33)","v":{"$error":"#N/A"}},{"$f":"IF(Y32=2,U32,U33)","v":{"$error":"#N/A"}},{"$f":"IF(Y32=2,X32,X33)","v":63.28},{"$error":"#N/A"},"Round 1",{"$f":"VLOOKUP(E20,Points!A$10:D$40,4,1)","v":{"$error":"#N/A"}},null,{"$f":"A13","v":0},{"$f":"VLOOKUP(M20,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M20,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q20,Q20:Q21,1)","v":1},null,{"$f":"IF(R36=1,N36,N37)","v":{"$error":"#N/A"}},{"$f":"IF(R36=1,O36,O37)","v":{"$error":"#N/A"}},{"$f":"IF(R36=1,Q36,Q37)","v":0},{"$f":"IF(V20<V21,\"*\",\"\")","v":""},55.682000000000002,{"$f":"RANK(X20,X20:X21,1)","v":1},null,null,"DNS:",{"$f":"IF(Y12=2,U12,U13)","v":{"$error":"#N/A"}},null,null,null,null,null,"DNS:",{"$f":"IF(AG11=2,AC11,AC12)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$1>32-M20,M$1-16+M20,\"\")","v":""},{"$f":"VLOOKUP(M21,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M21,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,2,{"$f":"RANK(Q21,Q20:Q21,1)","v":2},null,{"$f":"IF(R40=1,N40,N41)","v":{"$error":"#N/A"}},{"$f":"IF(R40=1,O40,O41)","v":{"$error":"#N/A"}},{"$f":"IF(R40=1,Q40,Q41)","v":0},{"$f":"IF(V20>V21,\"*\",\"\")","v":""},61.21,{"$f":"RANK(X21,X20:X21,1)","v":2},null,null,"DNS:",{"$f":"IF(Y16=2,U16,U17)","v":{"$error":"#N/A"}},null,null,null,null,null,"DNS:",{"$f":"IF(AG14=2,AC14,AC15)","v":{"$error":"#N/A"}}]
[null,null,null,"Pre-round",{"$f":"IF(F22>0,(M$1+1-RANK(H22,H$22:H$37,0)),\"NB\")","v":{"$error":"#N/A"}},{"$f":"IF(R4=2,N4,N5)","v":{"$error":"#N/A"}},{"$f":"IF(R4=2,O4,O5)","v":{"$error":"#N/A"}},{"$f":"IF(F22=\"NB\",\"\",IF(R4=2,Q4,Q5))","v":{"$error":"#N/A"}},{"$f":"E22","v":{"$error":"#N/A"}},"Round 0",{"$f":"VLOOKUP(E22,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DNS:",{"$f":"IF(Y20=2,U20,U21)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"IF(F23>0,(M$1+1-RANK(H23,H$22:H$37,0)),\"NB\")","v":{"$error":"#N/A"}},{"$f":"IF(R8=2,N8,N9)","v":{"$error":"#N/A"}},{"$f":"IF(R8=2,O8,O9)","v":{"$error":"#N/A"}},{"$f":"IF(R8=2,Q8,Q9)","v":1},{"$f":"E23","v":{"$error":"#N/A"}},"Round 0",{"$f":"VLOOKUP(E23,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,6,null,null,null,null,"Rank",null,null,null,null,null,null,"Rank",null,null,"DNS:",{"$f":"IF(Y24=2,U24,U25)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R12=2,N12,N13)","v":{"$error":"#N/A"}},{"$f":"IF(R12=2,O12,O13)","v":{"$error":"#N/A"}},{"$f":"IF(R12=2,Q12,Q13)","v":1.5},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E24,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,{"$f":"A7","v":0},{"$f":"VLOOKUP(M24,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M24,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q24,Q24:Q25,1)","v":1},null,{"$f":"IF(R44=1,N44,N45)","v":{"$error":"#N/A"}},{"$f":"IF(R44=1,O44,O45)","v":{"$error":"#N/A"}},{"$f":"IF(R44=1,Q44,Q45)","v":0},{"$f":"IF(V24<V25,\"*\",\"\")","v":""},68.239999999999995,{"$f":"RANK(X24,X24:X25,1)","v":2},null,null,"DNS:",{"$f":"IF(Y28=2,U28,U29)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R16=2,N16,N17)","v":{"$error":"#N/A"}},{"$f":"IF(R16=2,O16,O17)","v":{"$error":"#N/A"}},{"$f":"IF(R16=2,Q16,Q17)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E25,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,{"$f":"IF(M$1>32-M24,M$1-16+M24,\"\")","v":""},{"$f":"VLOOKUP(M25,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M25,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q25,Q24:Q25,1)","v":2},null,{"$f":"IF(R48=1,N48,N49)","v":{"$error":"#N/A"}},{"$f":"IF(R48=1,O48,O49)","v":{"$error":"#N/A"}},{"$f":"IF(R48=1,Q48,Q49)","v":0},{"$f":"IF(V24>V25,\"*\",\"\")","v":""},65,{"$f":"RANK(X25,X24:X25,1)","v":1},null,null,"DNS:",{"$f":"IF(Y32=2,U32,U33)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R20=2,N20,N21)","v":{"$error":"#N/A"}},{"$f":"IF(R20=2,O20,O21)","v":{"$error":"#N/A"}},{"$f":"IF(R20=2,Q20,Q21)","v":2},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E26,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R24=2,N24,N25)","v":{"$error":"#N/A"}},{"$f":"IF(R24=2,O24,O25)","v":{"$error":"#N/A"}},{"$f":"IF(R24=2,Q24,Q25)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E27,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,7,null,null,null,null,"Rank",null,null,null,null,null,null,"Rank"]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R28=2,N28,N29)","v":{"$error":"#N/A"}},{"$f":"IF(R28=2,O28,O29)","v":{"$error":"#N/A"}},{"$f":"IF(R28=2,Q28,Q29)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E28,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,{"$f":"A11","v":0},{"$f":"VLOOKUP(M28,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M28,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q28,Q28:Q29,1)","v":1},null,{"$f":"IF(R52=1,N52,N53)","v":{"$error":"#N/A"}},{"$f":"IF(R52=1,O52,O53)","v":{"$error":"#N/A"}},{"$f":"IF(R56=1,Q56,Q57)","v":0},{"$f":"IF(V28<V29,\"*\",\"\")","v":""},85.24,{"$f":"RANK(X28,X28:X29,1)","v":2}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R32=2,N32,N33)","v":{"$error":"#N/A"}},{"$f":"IF(R32=2,O32,O33)","v":{"$error":"#N/A"}},{"$f":"IF(R32=2,Q32,Q33)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E29,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,{"$f":"IF(M$1>32-M28,M$1-16+M28,\"\")","v":""},{"$f":"VLOOKUP(M29,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M29,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q29,Q28:Q29,1)","v":2},null,{"$f":"IF(R56=1,N56,N57)","v":{"$error":"#N/A"}},{"$f":"IF(R56=1,O56,O57)","v":{"$error":"#N/A"}},{"$f":"IF(R52=1,Q52,Q53)","v":0},{"$f":"IF(V28>V29,\"*\",\"\")","v":""},69.12,{"$f":"RANK(X29,X28:X29,1)","v":1}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R36=2,N36,N37)","v":{"$error":"#N/A"}},{"$f":"IF(R36=2,O36,O37)","v":{"$error":"#N/A"}},{"$f":"IF(R36=2,Q36,Q37)","v":3},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E30,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R40=2,N40,N41)","v":{"$error":"#N/A"}},{"$f":"IF(R40=2,O40,O41)","v":{"$error":"#N/A"}},{"$f":"IF(R40=2,Q40,Q41)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E31,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,8,null,null,null,null,"Rank",null,null,null,null,null,null,"Rank"]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R44=2,N44,N45)","v":{"$error":"#N/A"}},{"$f":"IF(R44=2,O44,O45)","v":{"$error":"#N/A"}},{"$f":"IF(R44=2,Q44,Q45)","v":4},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E32,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,{"$f":"A3","v":0},{"$f":"VLOOKUP(M32,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M32,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q32,Q32:Q33,1)","v":1},null,{"$f":"IF(R60=1,N60,N61)","v":{"$error":"#N/A"}},{"$f":"IF(R60=1,O60,O61)","v":{"$error":"#N/A"}},{"$f":"IF(R60=1,Q60,Q61)","v":0},{"$f":"IF(V32<V33,\"*\",\"\")","v":""},55.66,{"$f":"RANK(X32,X32:X33,1)","v":1}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R48=2,N48,N49)","v":{"$error":"#N/A"}},{"$f":"IF(R48=2,O48,O49)","v":{"$error":"#N/A"}},{"$f":"IF(R48=2,Q48,Q49)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E33,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,{"$f":"IF(M$1>32-M32,M$1-16+M32,\"\")","v":""},{"$f":"VLOOKUP(M33,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M33,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q33,Q32:Q33,1)","v":2},null,{"$f":"IF(R64=1,N64,N65)","v":{"$error":"#N/A"}},{"$f":"IF(R64=1,O64,O65)","v":{"$error":"#N/A"}},{"$f":"IF(R64=1,Q64,Q65)","v":0},{"$f":"IF(V32>V33,\"*\",\"\")","v":""},63.28,{"$f":"RANK(X33,X32:X33,1)","v":2}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R52=2,N52,N53)","v":{"$error":"#N/A"}},{"$f":"IF(R52=2,O52,O53)","v":{"$error":"#N/A"}},{"$f":"IF(R52=2,Q52,Q53)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E34,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R56=2,N56,N57)","v":{"$error":"#N/A"}},{"$f":"IF(R56=2,O56,O57)","v":{"$error":"#N/A"}},{"$f":"IF(R56=2,Q56,Q57)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E35,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,9,null,null,null,null,"Rank"]
[null,null,null,null,{"$error":"#N/A"},{"$f":"IF(R60=2,N60,N61)","v":{"$error":"#N/A"}},{"$f":"IF(R60=2,O60,O61)","v":{"$error":"#N/A"}},{"$f":"IF(R60=2,Q60,Q61)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E36,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,{"$f":"A16","v":0},{"$f":"VLOOKUP(M36,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M36,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q36,Q36:Q37,1)","v":1},null,"DNS for run 2, 3,4,5 (Quarter, semi, and final)"]
[null,null,null,null,{"$f":"IF(F37>0,(M$1+1-RANK(H37,H$22:H$37,0)),\"NB\")","v":{"$error":"#N/A"}},{"$f":"IF(R61=2,N61,N62)","v":{"$error":"#N/A"}},{"$f":"IF(R61=2,O61,O62)","v":{"$error":"#N/A"}},{"$f":"IF(R64=2,Q64,Q65)","v":1},{"$error":"#N/A"},"Round 0",{"$f":"VLOOKUP(E37,Points!A$10:D$33,4,1)","v":{"$error":"#N/A"}},null,{"$f":"IF(M$1>32-M36,M$1-16+M36,\"\")","v":""},{"$f":"VLOOKUP(M37,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M37,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,3,{"$f":"RANK(Q37,Q36:Q37,1)","v":2},null,"DNS:",{"$f":"IF(R4=2,N4,N5)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DNS:",{"$f":"IF(R8=2,N8,N9)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,"Rank",null,"DNS:",{"$f":"IF(R12=2,N12,N13)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A8","v":0},{"$f":"VLOOKUP(M40,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M40,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q40,Q40:Q41,1)","v":1},null,"DNS:",{"$f":"IF(R16=2,N16,N17)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$1>32-M40,M$1-16+M40,\"\")","v":""},{"$f":"VLOOKUP(M41,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M41,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q41,Q40:Q41,1)","v":2},null,"DNS:",{"$f":"IF(R20=2,N20,N21)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DNS:",{"$f":"IF(R24=2,N24,N25)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,"Rank",null,"DNS:",{"$f":"IF(R28=2,N28,N29)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A14","v":0},{"$f":"VLOOKUP(M44,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M44,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q44,Q44:Q45,1)","v":1},null,"DNS:",{"$f":"IF(R32=2,N32,N33)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$1>32-M44,M$1-16+M44,\"\")","v":""},{"$f":"VLOOKUP(M45,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M45,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,4,{"$f":"RANK(Q45,Q44:Q45,1)","v":2},null,"DNS:",{"$f":"IF(R36=2,N36,N37)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DNS:",{"$f":"IF(R40=2,N40,N41)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,"Rank",null,"DNS:",{"$f":"IF(R44=2,N44,N45)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A4","v":0},{"$f":"VLOOKUP(M48,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M48,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q48,Q48:Q49,1)","v":1},null,"DNS:",{"$f":"IF(R48=2,N48,N49)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$1>32-M48,M$1-16+M48,\"\")","v":""},{"$f":"VLOOKUP(M49,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M49,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q49,Q48:Q49,1)","v":2},null,"DNS:",{"$f":"IF(R52=2,N52,N53)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DNS:",{"$f":"IF(R56=2,N56,N57)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,null,null,"Rank",null,"DNS:",{"$f":"IF(R60=2,N60,N61)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A12","v":0},{"$f":"VLOOKUP(M52,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M52,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q52,Q52:Q53,1)","v":1},null,"DNS:",{"$f":"IF(R64=2,N64,N65)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$1>32-M52,M$1-16+M52,\"\")","v":""},{"$f":"VLOOKUP(M53,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M53,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q53,Q52:Q53,1)","v":2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,"Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A6","v":0},{"$f":"VLOOKUP(M56,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M56,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q56,Q56:Q57,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$1>32-M56,M$1-16+M56,\"\")","v":""},{"$f":"VLOOKUP(M57,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M57,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q57,Q56:Q57,1)","v":2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,15,null,null,null,null,"Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A10","v":0},{"$f":"VLOOKUP(M60,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M60,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q60,Q60:Q61,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$1>32-M60,M$1-16+M60,\"\")","v":""},{"$f":"VLOOKUP(M61,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M61,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q61,Q60:Q61,1)","v":2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,"Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A2","v":0},{"$f":"VLOOKUP(M64,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M64,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},"*",0,{"$f":"RANK(Q64,Q64:Q65,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$1>32-M64,M$1-16+M64,\"\")","v":""},{"$f":"VLOOKUP(M65,$A$2:$C$33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M65,$A$2:$C$33,3,0)","v":{"$error":"#N/A"}},null,1,{"$f":"RANK(Q65,Q64:Q65,1)","v":2}]

{"sheet":"Slalom","index":5,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Rank"]
[null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,32]

{"sheet":"Downriver","index":6,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Rank"]
[null,null,null,null,null,1]
[null,null,null,null,null,2]
[null,null,null,null,null,3]
[null,null,null,null,null,4]
[null,null,null,null,null,5]
[null,null,null,null,null,6]
[null,null,null,null,null,7]
[null,null,null,null,null,8]
[null,null,null,null,null,9]
[null,null,null,null,null,10]
[null,null,null,null,null,11,null,"Export from RaceGorilla: Rank,Bib,Name, Tags, Best"]
[null,null,null,null,null,12]
[null,null,null,null,null,13]
[null,null,null,null,null,14]
[null,null,null,null,null,15]
[null,null,null,null,null,16]
[null,null,null,null,null,17]
[null,null,null,null,null,18]
[null,null,null,null,null,19]
[null,null,null,null,null,20]
[null,null,null,null,null,21]
[null,null,null,null,null,22]
[null,null,null,null,null,23]
[null,null,null,null,null,24]
[null,null,null,null,null,25]
[null,null,null,null,null,26]
[null,null,null,null,null,27]
[null,null,null,null,null,28]
[null,null,null,null,null,29]
[null,null,null,null,null,30]
[null,null,null,null,null,31]
[null,null,null,null,null,32]

{"sheet":"Defaults","index":7,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Gender","Category","Countries","Clubs"]
["Male","Competition","Australia","Ajax"]
["Female","Recreational","Austria","Barcelona"]
["Mixed","Competition","Belgium"]
[null,"Men","Bulgaria"]
[null,"Women","Canada"]
[null,"Juniors","Czech Republic"]
[null,null,"England"]
[null,null,"Finland"]
[null,null,"France"]
[null,null,"Germany"]
[null,null,"Great Brittain"]
[null,null,"Ireland"]
[null,null,"Italy"]
[null,null,"Netherlands"]
[null,null,"Poland"]
[null,null,"Portugal"]
[null,null,"Russia"]
[null,null,"Scotland"]
[null,null,"Slovakia"]
[null,null,"Slovenia"]
[null,null,"South Africa"]
[null,null,"Spain"]
[null,null,"Sweden"]
[null,null,"Switzerland"]
[null,null,"United Kingdom"]
[null,null,"United states of America"]
[null,null,"Other"]

{"sheet":"Points","index":8,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Rank","Sprint","Slalom","H2H","Downriver"]
[1,100,300,200,400]
[2,88,264,176,352]
[3,79,237,158,316]
[4,72,216,144,288]
[5,69,207,138,276]
[6,66,198,132,264]
[7,63,189,126,252]
[8,60,180,120,240]
[9,57,171,114,228]
[10,54,162,108,216]
[11,51,153,102,204]
[12,48,144,96,192]
[13,45,135,90,180]
[14,42,126,84,168]
[15,39,117,78,156]
[16,36,108,72,144]
[17,33,99,66,132]
[18,30,90,60,120]
[19,28,84,56,112]
[20,26,78,52,104]
[21,24,72,48,96]
[22,22,66,44,88]
[23,20,60,40,80]
[24,18,54,36,72]
[25,16,48,32,64]
[26,14,42,28,56]
[27,12,36,24,48]
[28,10,30,20,40]
[29,8,24,16,32]
[30,6,18,12,24]
[31,4,12,8,16]
[32,2,6,4,8]
[33,0,0,0,0]
[34,0,0,0,0]
[35,0,0,0,0]
[36,0,0,0,0]