{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SingleRace","CardNameMatch"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"SingleRace","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"First",{"$f":"VLOOKUP($F1,$C:$E,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F1,$C:$E,3,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Second",{"$f":"VLOOKUP($F2,$C:$E,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F2,$C:$E,3,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Third",{"$f":"VLOOKUP($F3,$C:$E,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F3,$C:$E,3,0)","v":{"$error":"#N/A"}}]
[]
["Card","Time","This is the main data collection page. So the first column will be the card # and the second the Timestamp","Name"]
[null,null,{"$f":"IF(E6=\"Start Time\",\" ST \",CHOOSE(MIN(4,_xlfn.RANK.EQ(E6,E:E,1)),\"First\",\"Second\",\"Third\",\" - \"))","v":" ST "},{"$f":"VLOOKUP(A6,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A6,$A$5:B5,2,0)),\"Start Time\",B6-VLOOKUP(A6,$A$5:B5,2,0))","v":"Start Time"},"Counting Laps"]
[null,null," ST ",{"$f":"VLOOKUP(A7,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A7,$A$5:B6,2,0)),\"Start Time\",B7-VLOOKUP(A7,$A$5:B6,2,0))","v":"Start Time"},"Average Times"]
[null,null," ST ",{"$f":"VLOOKUP(A8,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A8,$A$5:B7,2,0)),\"Start Time\",B8-VLOOKUP(A8,$A$5:B7,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A9,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A9,$A$5:B8,2,0)),\"Start Time\",B9-VLOOKUP(A9,$A$5:B8,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A10,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A10,$A$5:B9,2,0)),\"Start Time\",B10-VLOOKUP(A10,$A$5:B9,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A11,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A11,$A$5:B10,2,0)),\"Start Time\",B11-VLOOKUP(A11,$A$5:B10,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A12,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A12,$A$5:B11,2,0)),\"Start Time\",B12-VLOOKUP(A12,$A$5:B11,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A13,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A13,$A$5:B12,2,0)),\"Start Time\",B13-VLOOKUP(A13,$A$5:B12,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A14,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A14,$A$5:B13,2,0)),\"Start Time\",B14-VLOOKUP(A14,$A$5:B13,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A15,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A15,$A$5:B14,2,0)),\"Start Time\",B15-VLOOKUP(A15,$A$5:B14,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A16,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A16,$A$5:B15,2,0)),\"Start Time\",B16-VLOOKUP(A16,$A$5:B15,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A17,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A17,$A$5:B16,2,0)),\"Start Time\",B17-VLOOKUP(A17,$A$5:B16,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A18,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A18,$A$5:B17,2,0)),\"Start Time\",B18-VLOOKUP(A18,$A$5:B17,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A19,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A19,$A$5:B18,2,0)),\"Start Time\",B19-VLOOKUP(A19,$A$5:B18,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A20,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A20,$A$5:B19,2,0)),\"Start Time\",B20-VLOOKUP(A20,$A$5:B19,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A21,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A21,$A$5:B20,2,0)),\"Start Time\",B21-VLOOKUP(A21,$A$5:B20,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A22,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A22,$A$5:B21,2,0)),\"Start Time\",B22-VLOOKUP(A22,$A$5:B21,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A23,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A23,$A$5:B22,2,0)),\"Start Time\",B23-VLOOKUP(A23,$A$5:B22,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A24,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A24,$A$5:B23,2,0)),\"Start Time\",B24-VLOOKUP(A24,$A$5:B23,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A25,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A25,$A$5:B24,2,0)),\"Start Time\",B25-VLOOKUP(A25,$A$5:B24,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A26,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A26,$A$5:B25,2,0)),\"Start Time\",B26-VLOOKUP(A26,$A$5:B25,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A27,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A27,$A$5:B26,2,0)),\"Start Time\",B27-VLOOKUP(A27,$A$5:B26,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A28,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A28,$A$5:B27,2,0)),\"Start Time\",B28-VLOOKUP(A28,$A$5:B27,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A29,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A29,$A$5:B28,2,0)),\"Start Time\",B29-VLOOKUP(A29,$A$5:B28,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A30,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A30,$A$5:B29,2,0)),\"Start Time\",B30-VLOOKUP(A30,$A$5:B29,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A31,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A31,$A$5:B30,2,0)),\"Start Time\",B31-VLOOKUP(A31,$A$5:B30,2,0))","v":"Start Time"}]
[null,null," ST ",{"$f":"VLOOKUP(A32,CardNameMatch!A:B,2,)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(A32,$A$5:B31,2,0)),\"Start Time\",B32-VLOOKUP(A32,$A$5:B31,2,0))","v":"Start Time"}]
[]
[null,null,"Be sure to extend down if you have more than 16 cards."]

{"sheet":"CardNameMatch","index":1,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Enter Card Number Here","Enter Display Name Here"]