{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Paste entries here","Check In","Rating Pt Sort","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[null,"TEAMS EVENTS ONLY"]
[1,"Download Excel from NZB website"]
[2,"Copy Columns B to AX - IMPORTANT: Click on these columns along the top ",null,null,null,"Step 2.","Left click on the letter of the columns to copy. \nThis will select the entire column which is important to do"]
[3,"Paste into \"Paste Entries here page\" (starting at Column A)"]
[4,"Click on the icon below to create a check in list",null,null,null,null,null,null,null,"……AX"]
[]
[]
[5,"Once satified save this file with the name of the event, so that you always have a template file as well"]

{"sheet":"Paste entries here","index":1,"n_rows":1,"n_cols":49,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Player 5 Number","Player 5 Name","Player 5 Club","Player 5 Grade","Player 5 Rank","Player 5 Rating","Player 5 Registered","Player 5 Paid","Player 6 Number","Player 6 Name","Player 6 Club","Player 6 Grade","Player 6 Rank","Player 6 Rating","Player 6 Registered","Player 6 Paid","Entry notes"]

{"sheet":"Check In","index":2,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SURNAME",null,"FIRST NAME","PAID","ENTRY NOTES"]

{"sheet":"Rating Pt Sort","index":3,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["RK","PLAYER 1","GRADE","RATING","PLAYER 2","GRADE","RATING","PLAYER 1","GRADE","RATING","PLAYER 2","GRADE","RATING","TOTAL RP"]
[{"$f":"IF(N2>0,RANK(N2,$N$2:$N$80,0),\"\")","v":""},{"$f":"'Paste entries here'!B2","v":0},{"$f":"'Paste entries here'!D2","v":0},{"$f":"'Paste entries here'!F2","v":0},{"$f":"'Paste entries here'!J2","v":0},{"$f":"'Paste entries here'!L2","v":0},{"$f":"'Paste entries here'!N2","v":0},{"$f":"'Paste entries here'!R2","v":0},{"$f":"'Paste entries here'!T2","v":0},{"$f":"'Paste entries here'!V2","v":0},{"$f":"'Paste entries here'!Z2","v":0},{"$f":"'Paste entries here'!AB2","v":0},{"$f":"'Paste entries here'!AD2","v":0},{"$f":"M2+J2+G2+D2","v":0}]

{"sheet":"Data","index":4,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SURNAME",null,"FIRST NAME","PAID","ENTRY NOTES"]