{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","RegistationFormwithVlookup","AthleteForms","PTVI","Set up ","Setup"],"not_rendered":{"charts":0,"images":2,"macros":1,"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":"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 (PTVI Male & Female)"]
[3,"Complete the next steps with the PTVI Male or PTVI Female start list and then repeat the process for the other start list "]
[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 601and 602)"]
[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":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,1,34,2],[34,5,34,6],[1,6,2,6],[1,2,2,2],[29,0,29,2],[29,4,29,6],[5,1,5,2],[1,1,2,1],[1,5,2,5],[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:$C,3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C2,AthleteForms!$A:$D,4)","v":{"$error":"#N/A"}},null,"Athlete Name",{"$f":"VLOOKUP(G2,AthleteForms!$A:$C,3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G2,AthleteForms!$A:$D,4)","v":{"$error":"#N/A"}}]
["Country",{"$f":"VLOOKUP(C2,AthleteForms!$A:$D,2)","v":{"$error":"#N/A"}},null,null,"Country",{"$f":"VLOOKUP(G2,AthleteForms!$A:$D,2)","v":{"$error":"#N/A"}}]
[]
["Tri Suit Checks Athlete & Guide","√ / x","Correction / Notes",null,"Tri Suit Checks Athlete & Guide","√ / x","Correction /Notes"]
["Bib Number /Body Marking Vertical",null,null,null,"Bib Number /Body Marking Vertical"]
["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 Cap If applicable)",null,null,null,"Athlete Swim Cap (if applicable)"]
["Wetsuit (if applicable)",null,null,null,"Wetsuit (if applicable)"]
[]
["Swim Tether  (Bright Colour)\nMax 80cms without tension                             ",null,null,null,"Swim Tether  (Bright Colour)\nMax 80cms without tension                             "]
["Run Tether - non elastic",null,null,null,"Run Tether - non elastic"]
["Black Out Goggles (PTVI 1)  ",null,null,null,"Black Out Goggles (PTVI 1)    "]
["Black Out Glasses (PTVI 1)  ",null,null,null,"Black Out Glasses (PTVI 1)  "]
[null,"Make","Model",null,null,"Make","Model"]
["Running Shoes",null,null,null,"Running Shoes"]
["Running Shoes Guide",null,null,null,"Running Shoes Guide"]
[]
[null,"√ / x","Correction / Notes",null,null,"√ / x","Correction / Notes"]
["Helmet Check - Safety Athlete & Guide",null,null,null,"Helmet Check - Safety Athlete & Guide"]
["Helmet Check - logos Athlete & Guide",null,null,null,"Helmet Check - logos Athlete & Guide"]
[]
["Tandem",null,null,null,"Tandem"]
["270cm length/50cm wide",null,null,null,"270cm length/50cm wide"]
["Handle bar Plugs",null,null,null,"Handle bar Plugs"]
["Technology Fraud Check (if applicable)",null,null,null,"Technology 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":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["START NUMBER","NATIONALITY","ATHLETE FIRST","ATHLETE LAST"]
[1]

{"sheet":"PTVI","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]