{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","RegistationFormwithVlookup","AthleteForms","PTWC","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 PTWC 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."]
[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. It will only print the odd numbers. Do the same again, but type the first even number into Cell C2 and print from that number to print all the even numbers. "]
[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,"1 forms will print per page in Portrait view"]

{"sheet":"RegistationFormwithVlookup","index":1,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,2,2,2],[20,0,20,2],[28,0,28,1],[32,0,32,2]]}
[null,"Event","Race Number"]
[null,null,4]
[null,{"$f":"VLOOKUP(C2,AthleteForms!$A:$B,2,0)","v":"NZL"}]
["Athlete Name",{"$f":"VLOOKUP(C2,AthleteForms!$A:$C,3,0)","v":"Iwish"},{"$f":"VLOOKUP(C2,AthleteForms!$A:$D,4,0)","v":"Wehadsome"}]
[null,"√ / x","Correction"]
["Bib Number"]
["Uniform in Catalogue                                          (WPS & Championships)"]
["Front Name                                                                     Front Country Code"]
["Back Name                                                                       Back Country Code"]
["Zipper Max 40 cm"]
["ITU Logo"]
["Sponsors Logos"]
["Athlete Swim Hat"]
["Wetsuit (if applicable)"]
["Helmet Check - Safety"]
["Helmet Check - Logos"]
["Handler 1 Confirmed"]
["Handler 1 T shirt / Bib Number"]
["Knee Brace"]
["Technological Fraud Check                                          (If applicable)"]
["Recumbent position Hand-cycle (AP) "]
["Max Dimensions 250cm (L) 70cm (W)"]
["Wheels 406mm 622mm "]
["Double wheels 55-70cm"]
["Eyes <= Crank"]
["Crank set protection"]
["Mirror"]
["Two independent braking system"]
["Safety Bar (Y/N)"]
["280mm +/- 10mm"]
["15mm +/-2mm"]
[">= 18mm"]
["Race wheelchair"]
["Wheel 70 - 50"]
["Chair not past wheels"]
["Number on back"]
["Only one plain, round, hand rim for each large wheel"]
["No mechanical gears or levers "]
["Brake at the front wheel (not a disc Brake)"]
["Lower Limb Support (if applicable)"]
["Wave Number"]
["Swim Cap & Timing Chip Delivered","Athlete Signature"]

{"sheet":"AthleteForms","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["START NUMBER","NATIONALITY","ATHLETE FIRST","ATHLETE LAST"]
[1,"GBR","Jo ","Blow"]
[2,"AUS","Jo ","Roo"]
[3,"CAN","Aida","Test"]
[4,"NZL","Iwish","Wehadsome"]

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