{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","RegistationFormwithVlookup","AthleteForms","Elite","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":14,"n_cols":2,"rows_kept":14,"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"]
[3,"From the Excel start list, copy the columns of Athlete number, Athlete First, Athlete Last, Nationality, to the \"AthleteForms\" sheet"]
[4,"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 "]
[5,"Copy saddle position exceptions (if any) against the correct athlete in Column E on the AthleteForms sheet. "]
[6,"Saddle Exceptions can be found here: https://www.triathlon.org/uploads/docs/World_Triathlon_Sport_Elite_Bike_Saddle_Position_Rule_Exceptions_20230210.pdf"]
[7,"On the RegistationFormwithVlookup, type in the first  athlete number into cell C2 and the next athlete number into cell G2 (eg 1 and 2)"]
[8,"The form will populate the Nationality, First and Last Name and any Saddle Exception."]
[9,"The BLUE \"Print\" button will print just the current page"]
[10,"The GREY \"Print Forms\" button will pop up a window, type in the athlete number range you would like to print"]
[11,"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"]
[12,"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":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,1,24,2],[24,5,24,6],[1,2,2,2],[1,6,2,6],[1,1,2,1],[1,5,2,5],[5,1,5,2],[5,5,5,6]]}
[null,"Event",null,null,null,"Event"]
[null,"Race Number",null,null,null,"Race Number"]
[]
[]
["Athlete Name",{"$f":"VLOOKUP(C2,AthleteForms!A:B,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C2,AthleteForms!A:C,3,0)","v":{"$error":"#N/A"}},null,"Athlete Name",{"$f":"VLOOKUP(G2,AthleteForms!A:B,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G2,AthleteForms!A:C,3,0)","v":{"$error":"#N/A"}}]
["Country ",{"$f":"VLOOKUP(C2,AthleteForms!A:D,4,)","v":{"$error":"#N/A"}},null,null,"Country ",{"$f":"VLOOKUP(G2,AthleteForms!A:D,4,0)","v":{"$error":"#N/A"}}]
[]
[null,"Y / N","Correction / Notes",null,null,"Y / N","Correction / Notes"]
["Body Marking Vertical",null,null,null,"Body Marking Vertical"]
["Uniform In Catalogue \n(WTCS & Championships)",null,null,null,"Uniform In Catalogue \n(WTCS & 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 (max 40cms)",null,null,null,"Zipper (max 40cms)"]
["Athlete  Swim Hat (if applicable)",null,null,null,"Athlete  Swim Hat (if applicable)"]
["Wetsuit (if Applicable)",null,null,null,"Wetsuit (if Applicable)"]
[null,"Make","Model",null,null,"Make","Model"]
["Running Shoes",null,null,null,"Running Shoes"]
[]
[null,"Y / N","Correction / Notes",null,null,"Y / N","Correction / Notes"]
["Helmet Check - Safety",null,null,null,"Helmet Check - Safety"]
["Helmet Check - Logos",null,null,null,"Helmet Check - Logos"]
[]
["Saddle Position \n-5cm Men   -2cm Women",null,null,null,"Saddle Position          \n-5cm Men   -2cm Women"]
["Rule Exemption on Saddle Position",{"$f":"VLOOKUP(C2,AthleteForms!$A:$E,5,0)","v":{"$error":"#N/A"}},null,null,"Rule Exemption on Saddle Position",{"$f":"VLOOKUP(G2,AthleteForms!$A:$E,5,0)","v":{"$error":"#N/A"}}]
[]
["Technology Fraud (If Applicable)",null,null,null,"Technology Fraud (If Applicable)"]
[]
["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":[]}
["ATHLETE NUMBER","ATHLETE FIRST","ATHLETE LAST","NATIONALITY","Rule Exception on Saddle Position"]

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

{"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]