{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Riders & Times","Results","Standards"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":35,"n_cols":5,"rows_kept":35}
["What is in this spreadsheet"]
[]
[null,"There are 4 Sheets (including this one)"]
[null,null,"Instructions:  You're looking at it"]
[null,null,"Riders & Times: Race Information"]
[null,null,"Results:  Results based on finish or standard times"]
[null,null,"Standards:  Time standards for 16, 40 and 80km distances (Avoid modifying this page unless time standards change)."]
[]
[]
["Race Setup"]
[]
[null,"All race information is entered on the \"Riders & Times\" sheet"]
[]
[null,"To prepare the spreadsheet for a new race, delete the Rider, Team, Age and Finish Time columns"]
[null,"     (clear the values only so the formatting does not get messed up)"]
[]
[null,"Adding Race Information"]
[null,null,"Enter the race distance in KM"]
[null,null,"Enter the standards distance you want to use.  This is either 16, 40 or 80km"]
[null,null,"Clear the data from the following columns:  Rider, Team, Age, Finish Time"]
[null,null,"Add Rider data as follows"]
[{"$nulls":3},"Rider","Mandatory"]
[{"$nulls":3},"Team","Optional"]
[{"$nulls":3},"Gender","Select or enter M or F"]
[{"$nulls":3},"Age","Mandatory"]
[{"$nulls":3},"Finish Time","Mandatory (times must be entered in h:mm:ss format.  If there are no hours, use 0.  eg  0:22:41)"]
[null,null,"When both age and gender are defined for a rider, the spreadsheet will calculate the standard time as follows:"]
[{"$nulls":3},"Locates the age standard record in the Standards sheet based on age and gender"]
[{"$nulls":3},"Retrieves the 16, 40 or 80km standard time as instructed"]
[{"$nulls":3},"Adjusts the standard time based on the actual race distance"]
[null,null,"When you enter a finish time, the spreadsheet will populate the Std column with the difference between the standard and finish times"]
[]
["Results"]
[null,"To generate results, go to \"Results\" sheet"]
[null,"Click the appropriate button to get results based on Finish or Standard times"]

{"sheet":"Riders & Times","index":1,"n_rows":56,"n_cols":8,"rows_kept":56}
["Event","Nanaimo TT"]
[]
["Race Distance",16,"km"]
["Standards Distance",16,"km",null,{"$f":"IF(B4=16,\"Standards!B2:B105\",IF(B4=40,\"Standards!C2:C105\",\"Standards!D2:D105\"))","v":"Standards!B2:B105"}]
[]
["Rider","Team Affiliation","Gender","Age",null,"Standard Time","Finish Time","Std +/-"]
["Bill Yearwood",null,"M",59,{"$f":"IF(AND(C7<>\"\",D7<>\"\"),CONCATENATE($C7,IF($C7=\"M\",IF($D7<30,30,IF($D7>85,85,$D7)),IF($D7<30,30,IF($D7>77,77,$D7)))),\"\")","v":"M59"},{"$f":"IF($E7<>\"\",LOOKUP($E7,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:28:43"},"00:22:51",{"$f":"IF(AND(G7<>\"\",F7<>\"\"),IF(G7>F7, TEXT(G7-F7,\"h:mm:ss\"), TEXT(F7-G7,\"-h:mm:ss\")),\"\")","v":"-0:05:52"}]
["Ray Wagner",null,"M",52,{"$f":"IF(AND(C8<>\"\",D8<>\"\"),CONCATENATE($C8,IF($C8=\"M\",IF($D8<30,30,IF($D8>85,85,$D8)),IF($D8<30,30,IF($D8>77,77,$D8)))),\"\")","v":"M52"},{"$f":"IF($E8<>\"\",LOOKUP($E8,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:27:18"},"00:22:56",{"$f":"IF(AND(G8<>\"\",F8<>\"\"),IF(G8>F8, TEXT(G8-F8,\"h:mm:ss\"), TEXT(F8-G8,\"-h:mm:ss\")),\"\")","v":"-0:04:22"}]
["David Huntley",null,"M",30,"M30",{"$f":"IF($E9<>\"\",LOOKUP($E9,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:23:30"},"00:23:28","-0:00:02"]
["Chris Cameron",null,"M",55,"M55",{"$f":"IF($E10<>\"\",LOOKUP($E10,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:27:54"},"00:23:29","-0:04:25"]
["Mike Sevcov",null,"M",58,"M58",{"$f":"IF($E11<>\"\",LOOKUP($E11,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:28:30"},"00:24:06","-0:04:24"]
["Charles Hamer",null,"M",50,"M50",{"$f":"IF($E12<>\"\",LOOKUP($E12,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:26:54"},"00:24:18","-0:02:36"]
["Steve Crowley",null,"M",51,"M51",{"$f":"IF($E13<>\"\",LOOKUP($E13,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:27:06"},"00:24:49","-0:02:17"]
["Chris Paul",null,"M",45,"M45",{"$f":"IF($E14<>\"\",LOOKUP($E14,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:25:55"},"00:24:50","-0:01:05"]
["Duane Martindale",null,"M",60,"M60",{"$f":"IF($E15<>\"\",LOOKUP($E15,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:28:56"},"00:25:07","-0:03:49"]
["John Guthrie",null,"M",53,"M53",{"$f":"IF($E16<>\"\",LOOKUP($E16,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:27:30"},"00:25:26","-0:02:04"]
["Dick Nicholls",null,"M",75,"M75",{"$f":"IF($E17<>\"\",LOOKUP($E17,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:32:18"},"00:25:46","-0:06:32"]
["Rhonda Callendar",null,"F",40,"F40",{"$f":"IF($E18<>\"\",LOOKUP($E18,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:26:30"},"00:25:46","-0:00:44"]
["Ian Smith",null,"M",45,"M45",{"$f":"IF($E19<>\"\",LOOKUP($E19,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:25:55"},"00:25:54","-0:00:01"]
["Chris Hahlen",null,"M",62,"M62",{"$f":"IF($E20<>\"\",LOOKUP($E20,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:29:22"},"00:27:06","-0:02:16"]
["Harry Balke",null,"M",67,"M67",{"$f":"IF($E21<>\"\",LOOKUP($E21,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":"00:30:27"},"00:27:57","-0:02:30"]
[null,null,"M",null,"",{"$f":"IF($E22<>\"\",LOOKUP($E22,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E23<>\"\",LOOKUP($E23,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E24<>\"\",LOOKUP($E24,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E25<>\"\",LOOKUP($E25,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E26<>\"\",LOOKUP($E26,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E27<>\"\",LOOKUP($E27,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E28<>\"\",LOOKUP($E28,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E29<>\"\",LOOKUP($E29,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E30<>\"\",LOOKUP($E30,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E31<>\"\",LOOKUP($E31,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E32<>\"\",LOOKUP($E32,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E33<>\"\",LOOKUP($E33,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E34<>\"\",LOOKUP($E34,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E35<>\"\",LOOKUP($E35,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E36<>\"\",LOOKUP($E36,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E37<>\"\",LOOKUP($E37,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E38<>\"\",LOOKUP($E38,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E39<>\"\",LOOKUP($E39,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M",null,"",{"$f":"IF($E40<>\"\",LOOKUP($E40,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,""]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]
[null,null,"M"]

{"sheet":"Results","index":2,"n_rows":21,"n_cols":7,"rows_kept":21}
[]
[]
[]
["Results based on Standard Times"]
[]
["Rider","Team Affiliation","Gender","Age","Standard Time","Finish Time","Std +/-"]
["Dick Nicholls",null,"M",75,"00:32:18","00:25:46","-0:06:32"]
["Bill Yearwood",null,"M",59,"00:28:43","00:22:51","-0:05:52"]
["Chris Cameron",null,"M",55,"00:27:54","00:23:29","-0:04:25"]
["Mike Sevcov",null,"M",58,"00:28:30","00:24:06","-0:04:24"]
["Ray Wagner",null,"M",52,"00:27:18","00:22:56","-0:04:22"]
["Duane Martindale",null,"M",60,"00:28:56","00:25:07","-0:03:49"]
["Charles Hamer",null,"M",50,"00:26:54","00:24:18","-0:02:36"]
["Harry Balke",null,"M",67,"00:30:27","00:27:57","-0:02:30"]
["Steve Crowley",null,"M",51,"00:27:06","00:24:49","-0:02:17"]
["Chris Hahlen",null,"M",62,"00:29:22","00:27:06","-0:02:16"]
["John Guthrie",null,"M",53,"00:27:30","00:25:26","-0:02:04"]
["Chris Paul",null,"M",45,"00:25:55","00:24:50","-0:01:05"]
["Rhonda Callendar",null,"F",40,"00:26:30","00:25:46","-0:00:44"]
["David Huntley",null,"M",30,"00:23:30","00:23:28","-0:00:02"]
["Ian Smith",null,"M",45,"00:25:55","00:25:54","-0:00:01"]

{"sheet":"Standards","index":3,"n_rows":105,"n_cols":4,"rows_kept":105}
["Class","16km","40km","80km"]
["F30","00:24:40","01:04:14","02:12:37"]
["F31","00:24:50","01:04:40","02:13:31"]
["F32","00:25:00","01:05:06","02:14:25"]
["F33","00:25:11","01:05:34","02:15:24"]
["F34","00:25:22","01:06:03","02:16:23"]
["F35","00:25:33","01:06:32","02:17:22"]
["F36","00:25:44","01:07:00","02:18:21"]
["F37","00:25:55","01:07:30","02:19:20"]
["F38","00:26:06","01:07:58","02:20:19"]
["F39","00:26:18","01:08:29","02:21:24"]
["F40","00:26:30","01:09:01","02:22:28"]
["F41","00:26:42","01:09:32","02:23:33"]
["F42","00:26:54","01:10:03","02:24:37"]
["F43","00:27:06","01:10:34","02:25:42"]
["F44","00:27:18","01:11:06","02:26:46"]
["F45","00:27:30","01:11:37","02:27:51"]
["F46","00:27:42","01:12:08","02:28:55"]
["F47","00:27:54","01:12:39","02:30:00"]
["F48","00:28:06","01:13:11","02:31:05"]
["F49","00:28:18","01:13:42","02:32:09"]
["F50","00:28:30","01:14:13","02:33:14"]
["F51","00:28:43","01:14:48","02:34:23"]
["F52","00:28:56","01:15:21","02:35:33"]
["F53","00:29:09","01:15:55","02:36:43"]
["F54","00:29:22","01:16:29","02:37:53"]
["F55","00:29:35","01:17:02","02:39:03"]
["F56","00:29:48","01:17:36","02:40:13"]
["F57","00:30:01","01:18:10","02:41:23"]
["F58","00:30:14","01:18:44","02:42:33"]
["F59","00:30:27","01:19:18","02:43:43"]
["F60","00:30:40","01:19:52","02:44:53"]
["F61","00:30:54","01:20:28","02:46:08"]
["F62","00:31:08","01:21:05","02:47:23"]
["F63","00:31:22","01:21:41","02:48:38"]
["F64","00:31:36","01:22:18","02:49:54"]
["F65","00:31:50","01:22:54","02:51:09"]
["F66","00:32:04","01:23:30","02:52:24"]
["F67","00:32:18","01:24:07","02:53:39"]
["F68","00:32:32","01:24:43","02:54:55"]
["F69","00:32:46","01:25:20","02:56:10"]
["F70","00:33:00","01:25:56","02:57:25"]
["F71","00:33:15","01:26:35","02:58:46"]
["F72","00:33:30","01:27:14","03:00:06"]
["F73","00:33:45","01:27:53","03:01:27"]
["F74","00:34:00","01:28:33","03:02:48"]
["F75","00:34:15","01:29:12","03:04:08"]
["F76","00:34:30","01:29:51","03:05:29"]
["F77","00:34:45","01:30:30","03:06:50"]
["M30","00:23:30","01:01:12","02:06:21"]
["M31","00:23:38","01:01:32","02:07:04"]
["M32","00:23:46","01:01:53","02:07:47"]
["M33","00:23:54","01:02:14","02:08:30"]
["M34","00:24:03","01:02:38","02:09:18"]
["M35","00:24:12","01:03:01","02:10:06"]
["M36","00:24:21","01:03:24","02:10:55"]
["M37","00:24:30","01:03:48","02:11:43"]
["M38","00:24:40","01:04:14","02:12:37"]
["M39","00:24:50","01:04:40","02:13:31"]
["M40","00:25:00","01:05:06","02:14:25"]
["M41","00:25:11","01:05:34","02:15:24"]
["M42","00:25:22","01:06:03","02:16:23"]
["M43","00:25:33","01:06:32","02:17:22"]
["M44","00:25:44","01:07:00","02:18:21"]
["M45","00:25:55","01:07:30","02:19:20"]
["M46","00:26:06","01:07:58","02:20:19"]
["M47","00:26:18","01:08:29","02:21:24"]
["M48","00:26:30","01:09:01","02:22:28"]
["M49","00:26:42","01:09:32","02:23:33"]
["M50","00:26:54","01:10:03","02:24:37"]
["M51","00:27:06","01:10:34","02:25:42"]
["M52","00:27:18","01:11:06","02:26:46"]
["M53","00:27:30","01:11:37","02:27:51"]
["M54","00:27:42","01:12:08","02:28:55"]
["M55","00:27:54","01:12:39","02:30:00"]
["M56","00:28:06","01:13:11","02:31:05"]
["M57","00:28:18","01:13:42","02:32:09"]
["M58","00:28:30","01:14:13","02:33:14"]
["M59","00:28:43","01:14:48","02:34:23"]
["M60","00:28:56","01:15:21","02:35:33"]
["M61","00:29:09","01:15:55","02:36:43"]
["M62","00:29:22","01:16:29","02:37:53"]
["M63","00:29:35","01:17:02","02:39:03"]
["M64","00:29:48","01:17:36","02:40:13"]
["M65","00:30:01","01:18:10","02:41:23"]
["M66","00:30:14","01:18:44","02:42:33"]
["M67","00:30:27","01:19:18","02:43:43"]
["M68","00:30:40","01:19:52","02:44:53"]
["M69","00:30:54","01:20:28","02:46:08"]
["M70","00:31:08","01:21:05","02:47:23"]
["M71","00:31:22","01:21:41","02:48:38"]
["M72","00:31:36","01:22:18","02:49:54"]
["M73","00:31:50","01:22:54","02:51:09"]
["M74","00:32:04","01:23:30","02:52:24"]
["M75","00:32:18","01:24:07","02:53:39"]
["M76","00:32:32","01:24:43","02:54:55"]
["M77","00:32:46","01:25:20","02:56:10"]
["M78","00:33:00","01:25:56","02:57:25"]
["M79","00:33:15","01:26:35","02:58:46"]
["M80","00:33:30","01:27:14","03:00:06"]
["M81","00:33:45","01:27:53","03:01:27"]
["M82","00:34:00","01:28:33","03:02:48"]
["M83","00:34:15","01:29:12","03:04:08"]
["M84","00:34:30","01:29:51","03:05:29"]
["M85","00:34:45","01:30:30","03:06:50"]