{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Start Sheet","Results","OC","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":14,"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":"Start Sheet","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,3,0,6],[2,8,3,11]]}
["2018-05-10",null,null,"Bright, hot and dry with a smell of rubbish truck"]
["Name","Estimated time","Start delay","Recorded time","12 month PB","Lifetime PB","Actual time"]
["Charlotte Siriez","00:17:00",{"$f":"IF(A3=\"\",\"\",MAX($B$3:$B$22)-B3)","v":"00:00:00"},"00:16:46",{"$f":"IF(A3=\"\",\"\",VLOOKUP(A3,[1]!AnalData,12))","v":"00:15:29"},{"$f":"IF(A3=\"\",\"\",VLOOKUP(A3,[1]!AnalData,7))","v":"00:15:29"},{"$f":"IF(D3=\"\",\"\",D3-C3)","v":"00:16:46"},null,"To sort the list in order of Estimated Time (slowest at the top of the list, click the filter arrow in cell B2 and select 'Sort Largest to Smallest'"]
["Jo Collins","00:17:00",{"$f":"IF(A4=\"\",\"\",MAX($B$3:$B$22)-B4)","v":"00:00:00"},"00:15:14",{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,[1]!AnalData,12))","v":"00:14:10"},{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,[1]!AnalData,7))","v":"00:13:17"},{"$f":"IF(D4=\"\",\"\",D4-C4)","v":"00:15:14"}]
["Martin Szczypka","00:16:00",{"$f":"IF(A5=\"\",\"\",MAX($B$3:$B$22)-B5)","v":"00:01:00"},"00:16:07",null,null,{"$f":"IF(D5=\"\",\"\",D5-C5)","v":"00:15:07"}]
["Richard Berry","00:14:30",{"$f":"IF(A6=\"\",\"\",MAX($B$3:$B$22)-B6)","v":"00:02:30"},"00:17:11",{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,[1]!AnalData,12))","v":"00:14:52"},{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,[1]!AnalData,7))","v":"00:14:52"},{"$f":"IF(D6=\"\",\"\",D6-C6)","v":"00:14:41"}]
["Dave Durrant","00:14:00",{"$f":"IF(A7=\"\",\"\",MAX($B$3:$B$22)-B7)","v":"00:03:00"},"00:17:25",{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,[1]!AnalData,12))","v":"00:13:40"},{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,[1]!AnalData,7))","v":"00:12:14"},{"$f":"IF(D7=\"\",\"\",D7-C7)","v":"00:14:25"}]
["Leigh Skilton","00:14:00",{"$f":"IF(A8=\"\",\"\",MAX($B$3:$B$22)-B8)","v":"00:03:00"},"00:17:13",null,null,{"$f":"IF(D8=\"\",\"\",D8-C8)","v":"00:14:13"}]
["Jon Jenner","00:13:30",{"$f":"IF(A9=\"\",\"\",MAX($B$3:$B$22)-B9)","v":"00:03:30"},"00:17:09",{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,[1]!AnalData,12))","v":"00:13:21"},{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,[1]!AnalData,7))","v":"00:13:21"},{"$f":"IF(D9=\"\",\"\",D9-C9)","v":"00:13:39"}]
["Fred Sene","00:13:30",{"$f":"IF(A10=\"\",\"\",MAX($B$3:$B$22)-B10)","v":"00:03:30"},"00:17:05",{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,[1]!AnalData,12))","v":"00:13:15"},{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,[1]!AnalData,7))","v":"00:13:15"},{"$f":"IF(D10=\"\",\"\",D10-C10)","v":"00:13:35"}]
["Stuart Graham","00:12:30",{"$f":"IF(A11=\"\",\"\",MAX($B$3:$B$22)-B11)","v":"00:04:30"},"00:16:50",{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,[1]!AnalData,12))","v":"00:12:24"},{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,[1]!AnalData,7))","v":"00:11:05"},{"$f":"IF(D11=\"\",\"\",D11-C11)","v":"00:12:20"}]
["Anna Najdecka","00:12:00",{"$f":"IF(A12=\"\",\"\",MAX($B$3:$B$22)-B12)","v":"00:05:00"},"00:17:31",{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,[1]!AnalData,12))","v":"00:12:13"},{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,[1]!AnalData,7))","v":"00:12:13"},{"$f":"IF(D12=\"\",\"\",D12-C12)","v":"00:12:31"}]
["Varuna Rajapakse","00:12:00",{"$f":"IF(A13=\"\",\"\",MAX($B$3:$B$22)-B13)","v":"00:05:00"},"00:16:29",{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,[1]!AnalData,12))","v":"00:11:57"},{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,[1]!AnalData,7))","v":"00:10:45"},{"$f":"IF(D13=\"\",\"\",D13-C13)","v":"00:11:29"}]
["David Starley","00:11:30",{"$f":"IF(A14=\"\",\"\",MAX($B$3:$B$22)-B14)","v":"00:05:30"},"00:16:30",{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,[1]!AnalData,12))","v":"00:11:15"},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,[1]!AnalData,7))","v":"00:11:15"},{"$f":"IF(D14=\"\",\"\",D14-C14)","v":"00:11:00"}]
[null,null,null,null,null,null,{"$f":"IF(D15=\"\",\"\",D15-C15)","v":""}]
[null,null,{"$f":"IF(A16=\"\",\"\",MAX($B$3:$B$22)-B16)","v":""},null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,[1]!AnalData,12))","v":""},{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,[1]!AnalData,7))","v":""},{"$f":"IF(D16=\"\",\"\",D16-C16)","v":""}]
[null,null,{"$f":"IF(A17=\"\",\"\",MAX($B$3:$B$22)-B17)","v":""},null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,[1]!AnalData,12))","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,[1]!AnalData,7))","v":""},{"$f":"IF(D17=\"\",\"\",D17-C17)","v":""}]
[null,null,{"$f":"IF(A18=\"\",\"\",MAX($B$3:$B$22)-B18)","v":""},null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,[1]!AnalData,12))","v":""},{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,[1]!AnalData,7))","v":""},{"$f":"IF(D18=\"\",\"\",D18-C18)","v":""}]
[null,null,{"$f":"IF(A19=\"\",\"\",MAX($B$3:$B$22)-B19)","v":""},null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,[1]!AnalData,12))","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,[1]!AnalData,7))","v":""},{"$f":"IF(D19=\"\",\"\",D19-C19)","v":""}]
[null,null,{"$f":"IF(A20=\"\",\"\",MAX($B$3:$B$22)-B20)","v":""},null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,[1]!AnalData,12))","v":""},{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,[1]!AnalData,7))","v":""},{"$f":"IF(D20=\"\",\"\",D20-C20)","v":""}]
[null,null,{"$f":"IF(A21=\"\",\"\",MAX($B$3:$B$22)-B21)","v":""},null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,[1]!AnalData,12))","v":""},{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,[1]!AnalData,7))","v":""},{"$f":"IF(D21=\"\",\"\",D21-C21)","v":""}]
[null,null,{"$f":"IF(A22=\"\",\"\",MAX($B$3:$B$22)-B22)","v":""},null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,[1]!AnalData,12))","v":""},{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,[1]!AnalData,7))","v":""},{"$f":"IF(D22=\"\",\"\",D22-C22)","v":""}]
[]
[]
["Course Record 09:55 by Matt Hallam 08-Jun-2017"]

{"sheet":"Results","index":1,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,10,0,12],[0,0,0,1]]}
[{"$f":"'Start Sheet'!A1:B1","v":"2018-05-10"},null,null,null,null,null,null,null,null,null,{"$f":"[1]Analysis!$D$5","v":"Status"},null,null,null,null,null,{"$f":"'Start Sheet'!D1","v":"Bright, hot and dry with a smell of rubbish truck"}]
["Date","Name","Route","Distance in km","Distance in Miles","Actual Time","Age","Age Grade","Pace / km","Pace / mile","Average","Best","Worst","Lifetime PB","Total Times Run","Last Ran","Comments"]
["2018-05-10","Charlotte Siriez","3k time trial",3.0249999999999999,1.890625,"00:16:46",0,null,"00:05:32.013","00:08:55.106","00:16:28.167","00:15:29","00:17:44","00:15:29",18,"2018-03-08"]
["2018-05-10","Jo Collins","3k time trial",3.0249999999999999,1.890625,"00:15:14",30,0.54892891971506763,"00:05:01.650","00:08:06.170","00:14:37.667","00:14:10","00:15:00","00:13:17",52,"2018-04-05","Probably time to bow out"]
["2018-05-10","Martin Szczypka","3k time trial",3.0249999999999999,1.890625,"00:15:07",0,null,"00:04:59.340","00:08:02.447",null,null,null,null,1,null,"Welcome to the Time Trial!"]
["2018-05-10","Richard Berry","3k time trial",3.0249999999999999,1.890625,"00:14:41",0,null,"00:04:50.759","00:07:48.617","00:14:52","00:14:52","00:14:52","00:14:52",2,"2018-01-20"]
["2018-05-10","Dave Durrant","3k time trial",3.0249999999999999,1.890625,"00:14:25",62,0.64372376642775719,"00:04:45.479","00:07:40.106","00:14:05.900","00:13:40","00:14:48","00:12:14",96,"2018-04-05"]
["2018-05-10","Leigh Skilton","3k time trial",3.0249999999999999,1.890625,"00:14:13",0,null,"00:04:41.518","00:07:33.723","00:13:42","00:13:23","00:14:01","00:13:23",3,"2018-04-05"]
["2018-05-10","Jon Jenner","3k time trial",3.0249999999999999,1.890625,"00:13:39",0,null,"00:04:30.297","00:07:15.638","00:13:26.500","00:13:21","00:13:32","00:13:21",5,"2018-04-05"]
["2018-05-10","Fred Sene","3k time trial",3.0249999999999999,1.890625,"00:13:35",45,0.59333696077975262,"00:04:28.977","00:07:13.511","00:13:35.600","00:13:15","00:14:07","00:13:15",20,"2018-01-23"]
["2018-05-10","Stuart Graham","3k time trial",3.0249999999999999,1.890625,"00:12:20",0,null,"00:04:04.224","00:06:33.617","00:13:04.667","00:12:24","00:13:55","00:11:05",46,"2017-11-16","Best time in the last few years!"]
["2018-05-10","Anna Najdecka","3k time trial",3.0249999999999999,1.890625,"00:12:31",32,0.67021659670262324,"00:04:07.855","00:06:39.468","00:12:26.750","00:12:13","00:12:40","00:12:13",11,"2018-02-15"]
["2018-05-10","Varuna Rajapakse","3k time trial",3.0249999999999999,1.890625,"00:11:29",45,0.70184270397024417,"00:03:47.393","00:06:06.489","00:13:00.500","00:11:57","00:14:05","00:10:45",43,"2018-04-05","Best time for well over a year!"]
["2018-05-10","David Starley","3k time trial",3.0249999999999999,1.890625,"00:11:00",21,0.66920966338753907,"00:03:37.822","00:05:51.064","00:11:27.143","00:11:15","00:11:45","00:11:15",10,"2018-04-05","PB by 15 seconds!!"]
[]
[null,"Note to new runners"]
[]
[null,"Red = Worse than average"]
[null,"Green = Better than average"]

{"sheet":"OC","index":2,"n_rows":102,"n_cols":3,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
[null,"Male","Female"]
["Age",3,3]
["OC sec",440,501.42]
["OC",{"$f":"B3/3600/24","v":"00:07:20"},"00:08:21.420"]
[5,"00:11:14.226","00:11:31.614"]
[6,"00:10:37.774","00:11:01.591"]
[7,"00:10:06.897","00:10:35.836"]
[8,"00:09:40.552","00:10:13.658"]
[9,"00:09:17.951","00:09:54.522"]
[10,"00:08:58.490","00:09:38.006"]
[11,"00:08:41.698","00:09:23.773"]
[12,"00:08:27.205","00:09:11.556"]
[13,"00:08:14.716","00:09:01.140"]
[14,"00:08:03.995","00:08:52.350"]
[15,"00:07:54.854","00:08:45.047"]
[16,"00:07:47.141","00:08:38.532"]
[17,"00:07:40.733","00:08:32.176"]
[18,"00:07:35.016","00:08:26.843"]
[19,"00:07:29.438","00:08:23.383"]
[20,"00:07:24.759","00:08:21.621"]
[21,"00:07:21.678","00:08:21.420"]
[22,"00:07:20.176","00:08:21.420"]
[23,"00:07:20","00:08:21.420"]
[24,"00:07:20","00:08:21.420"]
[25,"00:07:20","00:08:21.420"]
[26,"00:07:20","00:08:21.420"]
[27,"00:07:20","00:08:21.420"]
[28,"00:07:20.044","00:08:21.420"]
[29,"00:07:20.396","00:08:21.420"]
[30,"00:07:21.103","00:08:21.721"]
[31,"00:07:22.122","00:08:22.375"]
[32,"00:07:23.459","00:08:23.333"]
[33,"00:07:25.119","00:08:24.701"]
[34,"00:07:27.154","00:08:26.383"]
[35,"00:07:29.530","00:08:28.488"]
[36,"00:07:32.256","00:08:30.975"]
[37,"00:07:35.392","00:08:33.803"]
[38,"00:07:38.716","00:08:37.088"]
[39,"00:07:42.136","00:08:40.794"]
[40,"00:07:45.559","00:08:44.882"]
[41,"00:07:49.083","00:08:49.483"]
[42,"00:07:52.610","00:08:54.563"]
[43,"00:07:56.190","00:09:00.149"]
[44,"00:07:59.878","00:09:06.209"]
[45,"00:08:03.570","00:09:12.773"]
[46,"00:08:07.373","00:09:19.496"]
[47,"00:08:11.181","00:09:26.320"]
[48,"00:08:15.050","00:09:33.379"]
[49,"00:08:19.036","00:09:40.616"]
[50,"00:08:23.030","00:09:48.038"]
[51,"00:08:27.146","00:09:55.581"]
[52,"00:08:31.271","00:10:03.394"]
[53,"00:08:35.464","00:10:11.413"]
[54,"00:08:39.787","00:10:19.649"]
[55,"00:08:44.122","00:10:28.031"]
[56,"00:08:48.592","00:10:36.724"]
[57,"00:08:53.075","00:10:45.661"]
[58,"00:08:57.634","00:10:54.852"]
[59,"00:09:02.339","00:11:04.220"]
[60,"00:09:07.060","00:11:13.952"]
[61,"00:09:11.932","00:11:23.972"]
[62,"00:09:16.821","00:11:34.295"]
[63,"00:09:21.798","00:11:44.836"]
[64,"00:09:26.937","00:11:55.803"]
[65,"00:09:32.097","00:12:07.117"]
[66,"00:09:37.428","00:12:18.795"]
[67,"00:09:42.781","00:12:30.854"]
[68,"00:09:48.314","00:12:43.196"]
[69,"00:09:54.434","00:12:56.072"]
[70,"00:10:01.175","00:13:09.389"]
[71,"00:10:08.575","00:13:23.172"]
[72,"00:10:16.765","00:13:37.311"]
[73,"00:10:25.800","00:13:52.094"]
[74,"00:10:35.563","00:14:07.423"]
[75,"00:10:46.298","00:14:23.326"]
[76,"00:10:57.993","00:14:39.684"]
[77,"00:11:10.834","00:14:56.834"]
[78,"00:11:24.825","00:15:14.666"]
[79,"00:11:40.080","00:15:33.222"]
[80,"00:11:56.846","00:15:53.814"]
[81,"00:12:15.171","00:16:17.236"]
[82,"00:12:35.365","00:16:44.246"]
[83,"00:12:57.385","00:17:14.923"]
[84,"00:13:21.749","00:17:50.038"]
[85,"00:13:48.781","00:18:30.073"]
[86,"00:14:18.704","00:19:16.411"]
[87,"00:14:51.952","00:20:09.698"]
[88,"00:15:29.250","00:21:11.994"]
[89,"00:16:11.088","00:22:24.650"]
[90,"00:16:58.283","00:23:50.177"]
[91,"00:17:52.125","00:25:32.926"]
[92,"00:18:53.728","00:27:37.039"]
[93,"00:20:04.819","00:30:10.181"]
[94,"00:21:28.056","00:33:23.276"]
[95,"00:23:06.263","00:37:33.573"]
[96,"00:25:03.759","00:43:09.979"]
[97,"00:27:27.323","00:51:03.042"]
[98,"00:30:26.484","01:02:58.598"]
[99,"00:34:14.155","01:23:04.294"]
[100,"00:39:15.460","02:03:59.466"]
[]
[1,3,3]

{"sheet":"Instructions","index":3,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":true,"merged":[[15,1,15,16],[16,1,16,16],[5,1,5,16],[13,1,13,16],[14,1,14,16],[9,1,9,16],[10,1,10,16],[3,1,3,16],[4,1,4,16],[6,1,6,16],[7,1,7,16],[8,1,8,16],[18,1,18,16],[19,1,19,16],[20,1,20,16],[23,1,23,16],[17,1,17,16]]}
[]
["1. Prior to the Time Trial, on the Start Sheet worksheet;"]
[null,"Cells for data entry are colour coded  as",null,null,null,null,"Other cells have formulae and should not have data manually entered into them."]
[1.1000000000000001,"Enter the date of the Time Trial in cell A1 in the format dd/mmm/yy"]
[1.2,"Enter the weather conditions in cell D1"]
[1.3,"Enter the names of the runners in column A.  Note: Names must exactly match the entries in the Analysis List worksheet of the Running Club Master Data file."]
[1.4,"Data in columns E and F will be populated automatically from the Running Club Master Data file."]
[1.5,"Complete the Estimated Time field based on the 12 month PB values. These should be to the nearest 30 seconds"]
[1.6,"The Start Delay will be calculated automatically"]
[1.7,"To sort the Estimated Time column with slowest at the top, click on the Filter button in cell C2 and select 'Sort Largest to Smallest'.  "]
[1.8,"Click the 'Print Sheet' button to print out two copies for the race (one for the time logger and one for the last runner to leave the start point)"]
[]
["2. After the Time Trial"]
[null,"You should not need to make any manual entries in the Results worksheet. All values are calculated by formulae"]
[2.1,"After the race, enter the recorded times in column D of the Start Sheet   i.e. the time the runner crossed the line from the time the first runner set off. The actual race times will be calculated automatically."]
[2.2000000000000002,"Enter any information in the Comments field on the Results worksheet"]
[2.2999999999999998,"All the statistical data on the Results worksheet will be imported automatically from the Running Club Master Data file.  Note that the Master Data File is updated after this event is published and so will not include the Time Trial data in this workbook. The formulae for the number of time trials automatically adds 1 for the event you are entering data for."]
[2.4,"On the Results worksheeet, when all data is complete and before issuing the spreadsheet, click on the 'Convert Formulae to Values' button.  This will convert all formulae to values and is not a reversible operation"]
[2.5,"Save the file and e-mail out."]
[2.6,"Put a copy on the Running Club SharePoint site in the Time Trial folder.  The name format is 'Time Trial month yy'.  Change the InfoCode value to 2 so that the file appears in the right order on the SharePoint site"]
[2.7,"Put a copy on the Flyers website in the Events, Time Trial page"]
[]
["3. General"]
[3.1,"Cells on the Results worksheets are locked to prevent accidental changes.  The worksheet is not password protected if you do need to make changes"]