{"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":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":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Instructions"]
[1,"Copy the start list of Athlete, Nationality, Athlete First, Athlete Last to the Elite 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 exemptions into the Bike brand, bike model, Rule Exception on Saddle Position, Approved 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 Saddle Exception."]
[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,"2 forms will print per page in Landscape view"]

{"sheet":"RegistationFormwithVlookup","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[18,1,18,2],[17,5,17,6],[1,2,2,2],[16,1,16,2],[1,6,2,6],[16,5,16,6],[17,1,17,2]]}
[null,"Event","Race Number",null,null,"Event","Race Number"]
[null,null,1,null,null,null,2]
[null,{"$f":"VLOOKUP(C2,AthleteForms!$A:$D,2)","v":{"$error":"#N/A"}},null,null,null,{"$f":"VLOOKUP(G2,AthleteForms!$A:$D,2)","v":{"$error":"#N/A"}}]
["Athlete Name",{"$f":"VLOOKUP(C2,AthleteForms!$A:$D,3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C2,AthleteForms!A:D,4,0)","v":{"$error":"#N/A"}},null,"Athlete Name",{"$f":"VLOOKUP(G2,AthleteForms!$A:$D,3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G2,AthleteForms!$A:$D,4)","v":{"$error":"#N/A"}}]
[null,"√ / x","Correction",null,null,"√ / x","Correction"]
["Body Marking\nVertical",null,null,null,"Body Marking\nVertical"]
["Uniform in Catalogue                                           (WTS & Championships)",null,null,null,"Uniform in Catalogue                                           (WTS & 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"]
["Athlete Swim Hat",null,null,null,"Athlete Swim Hat"]
["Wetsuit (if applicable)"]
["Helmet Check - Safety",null,null,null,"Helmet Check - Safety"]
["Helmet Check - logos",null,null,null,"Helmet Check - logos"]
["Bike brand ",{"$f":"VLOOKUP(C2,AthleteForms!A:E,5,0)","v":{"$error":"#N/A"}},null,null,"Bike brand ",{"$f":"VLOOKUP(G2,AthleteForms!A:E,5,0)","v":{"$error":"#N/A"}}]
["Bike Model",{"$f":"VLOOKUP(C2,AthleteForms!A:F,6,0)","v":{"$error":"#N/A"}},null,null,"Bike Model",{"$f":"VLOOKUP(G2,AthleteForms!A:F,6,0)","v":{"$error":"#N/A"}}]
["Saddle position - 5cm Men 2cm Women",null,null,null,"Saddle position - 5cm Men 2cm Women"]
["Rule Exception on Saddle Position",{"$f":"VLOOKUP(C2,AthleteForms!A:G,7,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C2,AthleteForms!A:H,8,0)","v":{"$error":"#N/A"}},null,"Rule Exception on Saddle Position",{"$f":"VLOOKUP(G2,AthleteForms!$A:$G,7,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G2,AthleteForms!$A:$H,8,0)","v":{"$error":"#N/A"}}]
["UCI sticker YES/NO",null,null,null,"UCI sticker YES/NO"]
["Front Wheel Check - UCI                                             Make / Model   ",null,null,null,"Front Wheel Check - UCI                                             Make / Model   "]
["Back Wheel Check - UCI                                            Make / Model",null,null,null,"Back Wheel Check - UCI                                            Make / Model"]
["Clip - On Handlebar - Yes/No",null,null,null,"Clip - On Handlebar - Yes/No"]
["Clip - On Height - max 10cm",null,null,null,"Clip - On Height - max 10cm"]
["Clip - On Length - Not past brakes",null,null,null,"Clip - On Length - Not past brakes"]
["Technological Fraud Check (if applicable)",null,null,null,"Technological Fraud Check (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":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["START NUMBER","NATIONALITY","ATHLETE FIRST","ATHLETE LAST","Bike brand","Bike Model ","Rule Exception on Saddle Position","Approved"]

{"sheet":"Elite","index":3,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"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":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]