{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","RegistationFormwithVlookup","AthleteForms","PTS 2, 3, 4, 5","Set up ","Setup"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Instructions"]
[1,"Copy the start list of Athlete, Nationality, Athlete First, Athlete Last to the PTS 2, 3, 4, 5 Tab"]
[2,"Select all columns and go to the Data tab, Sort, by Athlete number"]
[3,"Copy all the columns to the AthleteForms worksheet"]
[4,"Copy any Adaptations to the columns against the correct athlete"]
[5,"On the RegistationFormwithVlookup, type in the Athlete number into cell C2 and the next athlete G2 eg 1 and 2"]
[6,"The form will populate the Nationality, First and Last Name and adaptations."]
[7,"Print button will print the current page"]
[8,"Print Forms button will pop up a window, type in the number range you would like to print"]
[null,"Note: Any missing numbers will print as the previous numbered athlete. You can either print these off and remove them or only print the numbers you require"]
[null,"You will need to enable macros to use this spreadsheet"]
[null,"2 forms will print per page in Landscape view"]

{"sheet":"RegistationFormwithVlookup","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,6,2,6],[1,2,2,2]]}
[null,"Event","Race Number",null,null,"Event","Race Number"]
[null,null,1,null,null,null,2]
[null,{"$f":"VLOOKUP(C2,AthleteForms!$A:$E,2,0)","v":{"$error":"#N/A"}},null,null,null,{"$f":"VLOOKUP(G2,AthleteForms!$A:$E,2,0)","v":{"$error":"#N/A"}}]
["Athlete Name",{"$f":"VLOOKUP(C2,AthleteForms!$A:$E,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C2,AthleteForms!$A:$E,4,0)","v":{"$error":"#N/A"}},null,"Athlete Name",{"$f":"VLOOKUP(G2,AthleteForms!$A:$E,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G2,AthleteForms!$A:$E,4,0)","v":{"$error":"#N/A"}}]
[null,"√ / x","Correction",null,null,"√ / x","Correction"]
["Bib Number",null,null,null,"Bib Number"]
["Uniform in Catalogue                                       (WPS & Championships)",null,null,null,"Uniform in Catalogue                                       (WPS & Championships)"]
["Front Name\nFront Country Code",null,null,null,"Front Name\nFront Country Code"]
["Back Name\nBack Country Code",null,null,null,"Back Name\nBack Country Code"]
["Zipper\nMax 40 cm",null,null,null,"Zipper\nMax 40 cm"]
["ITU Logo",null,null,null,"ITU Logo"]
["Sponsors Logos",null,null,null,"Sponsors Logos"]
["Helmet Check - Safety",null,null,null,"Helmet Check - Safety"]
["Helmet Check- Logos",null,null,null,"Helmet Check- Logos"]
["Prosthesis Numbered",null,null,null,"Prosthesis Numbered"]
["Athlete Swim Hat",null,null,null,"Athlete Swim Hat"]
["Wetsuit (if applicable)",null,null,null,"Wetsuit (if applicable)"]
["Handler 1 Confirmed                                         (to be approved by ITU)",null,null,null,"Handler 1 Confirmed                                         (to be approved by ITU)"]
["Handler 1 T shirt / Bib Number",null,null,null,"Handler 1 T shirt / Bib Number"]
["Handle bar",null,null,null,"Handle bar"]
["Bike adaptation",{"$f":"VLOOKUP(C2,AthleteForms!$A:$E,5,0)","v":{"$error":"#N/A"}},null,null,"Bike adaptation",{"$f":"VLOOKUP(G2,AthleteForms!$A:$E,5,0)","v":{"$error":"#N/A"}}]
["Technological Fraud Check                                    (if applicable)",null,null,null,"Technological Fraud Check                                    (if applicable)"]
["Wave Number",null,null,null,"Wave Number"]
["Swim Cap & Timing Chip Delivered","Athlete Signature",null,null,"Swim Cap & Timing Chip Delivered","Athlete Signature"]

{"sheet":"AthleteForms","index":2,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["START NUMBER","NATIONALITY","ATHLETE FIRST","ATHLETE LAST","ADAPTATION"]

{"sheet":"PTS 2, 3, 4, 5","index":3,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["START NUMBER","NATIONALITY","ATHLETE FIRST","ATHLETE LAST","ADAPTATION"]

{"sheet":"Set up ","index":4,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]

{"sheet":"Setup","index":5,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]