{"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":3,"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":"Instructions","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Instructions"]
[1,"Complete the event details in cells C1 & G1 on the \"RegistationFormwithVlookup\" sheet"]
[2,"Download the start list for your event from the World Triathlon Website as an Excel document( PTS 2, 3, 4, 5 Male & Female)"]
[3,"Complete the next steps with each of the PTS 2 -5 Male and PTS 2 - 5  Female start lists"]
[4,"From the Excel start list, copy the columns of Athlete number, Athlete First, Athlete Last, Nationality, to the \"AthleteForms\" sheet"]
[5,"Ensure that the \"AthleteForms\" sheet is sorted by athlete number. If not, select all columns and go to the Data tab, Sort by Athlete number "]
[6,"On the RegistationFormwithVlookup, type in the first  athlete number into cell C2 and the next athlete number into cell G2 (eg  201 and 202)"]
[7,"The form will populate the Nationality, First and Last Name "]
[8,"The BLUE \"Print\" button will print just the current page"]
[9,"The GREY \"Print Forms\" button will pop up a window, type in the athlete number range you would like to print"]
[10,"Note: Any missing numbers will print as the previous numbered athlete. You can either print these off and remove them or only print just the numbers ranges you require"]
[11,"2 forms will print per page in landscape view. Click \"Cancel\" on the pop-up when printing is complete."]
[null,"NB.  It is always useful to have spare blank forms available for wait list athletes"]

{"sheet":"RegistationFormwithVlookup","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,2,1],[5,1,5,2],[25,1,25,2],[1,5,2,5],[5,5,5,6],[25,5,25,6],[1,6,2,6],[1,2,2,2]]}
[null,"Event",null,null,null,"Event"]
[null,"Race Number",null,null,null,"Race Number"]
[]
[]
["Athlete Name",{"$f":"VLOOKUP(C2,AthleteForms!A:C,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C2,AthleteForms!A:D,4,0)","v":{"$error":"#N/A"}},null,"Athlete Name",{"$f":"VLOOKUP(G2,AthleteForms!A:C,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G2,AthleteForms!A:D,4,0)","v":{"$error":"#N/A"}}]
["Country",{"$f":"VLOOKUP(C2,AthleteForms!A:B,2,0)","v":{"$error":"#N/A"}},null,null,"Country",{"$f":"VLOOKUP(G2,AthleteForms!A:B,2,0)","v":{"$error":"#N/A"}}]
[]
[null,"√ / x","Correction / Notes",null,null,"√ / x","Correction / Notes"]
["Bib Number/ Body Marking Verical",null,null,null,"Bib Number/ Body Marking Verical"]
["Uniform in Catalogue  \n  (WPS & Championships)",null,null,null,"Uniform in Catalogue  \n  (WPS & Championships)"]
["Name & Country Code Front & Back",null,null,null,"Name & Country Code Front & Back"]
["TRI Logo ",null,null,null,"TRI Logo"]
["Sponsors Logos",null,null,null,"Sponsors Logos"]
["Zipper\nMax 40 cm",null,null,null,"Zipper\nMax 40 cm"]
["Athlete Swim Hat (If applicable)",null,null,null,"Athlete Swim Hat (if applicable)"]
["Wetsuit (if applicable)",null,null,null,"Wetsuit (if applicable)"]
["Prosthesis Numbered",null,null,null,"Prosthesis Numbered"]
[null,"Make","Model",null,null,"Make","Model"]
["Running Shoes",null,null,null,"Running Shoes"]
[]
[null,"√ / x","Correction",null,null,"√ / x","Correction"]
["Helmet Check - Safety",null,null,null,"Helmet Check - Safety"]
["Helmet Check- Logos",null,null,null,"Helmet Check- Logos"]
[]
["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\n(if applicable)",null,null,null,"Technological Fraud Check \n(if applicable)"]
[]
["Handler 1 Confirmed  \n  (to be approved by World Triathlon)",null,null,null,"Handler 1 Confirmed  \n  (to be approved by World Triathlon)"]
["Handler 1 T shirt / Bib Number",null,null,null,"Handler 1 T shirt / Bib Number"]
[]
["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":true,"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":true,"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]