{"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":55,"n_cols":8,"rows_kept":55}
["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:27:13"},"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:04:22"}]
["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:26:42"},"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:03:46"}]
["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:25:49"},"00:23:28","-0:02:21"]
["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:26:54"},"00:23:29","-0:03: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:27:08"},"00:24:06","-0:03:02"]
["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:33"},"00:24:18","-0:02:15"]
["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:26:38"},"00:24:49","-0:01:49"]
["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:26:13"},"00:24:50","-0:01:23"]
["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:27:18"},"00:25:07","-0:02:11"]
["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:26:46"},"00:25:26","-0:01:20"]
["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:29:16"},"00:25:46","-0:03:30"]
["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:27:52"},"00:25:46","-0:02:06"]
["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:26:13"},"00:25:54","-0:00:19"]
["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:27:29"},"00:27:06","-0:00:23"]
["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:28:02"},"00:27:57","-0:00:05"]
[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,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 +/-"]
["Bill Yearwood",null,"M",59,"00:27:13","00:22:51","-0:04:22"]
["Ray Wagner",null,"M",52,"00:26:42","00:22:56","-0:03:46"]
["Dick Nicholls",null,"M",75,"00:29:16","00:25:46","-0:03:30"]
["Chris Cameron",null,"M",55,"00:26:54","00:23:29","-0:03:25"]
["Mike Sevcov",null,"M",58,"00:27:08","00:24:06","-0:03:02"]
["David Huntley",null,"M",30,"00:25:49","00:23:28","-0:02:21"]
["Charles Hamer",null,"M",50,"00:26:33","00:24:18","-0:02:15"]
["Duane Martindale",null,"M",60,"00:27:18","00:25:07","-0:02:11"]
["Rhonda Callendar",null,"F",40,"00:27:52","00:25:46","-0:02:06"]
["Steve Crowley",null,"M",51,"00:26:38","00:24:49","-0:01:49"]
["Chris Paul",null,"M",45,"00:26:13","00:24:50","-0:01:23"]
["John Guthrie",null,"M",53,"00:26:46","00:25:26","-0:01:20"]
["Chris Hahlen",null,"M",62,"00:27:29","00:27:06","-0:00:23"]
["Ian Smith",null,"M",45,"00:26:13","00:25:54","-0:00:19"]
["Harry Balke",null,"M",67,"00:28:02","00:27:57","-0:00:05"]

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