{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Final Results","WorkingSheet","BoatRatingSheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Final Results","index":0,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Pursuit Style Race Start Times",null,null,null,null,null,"Only edit/change entries in yellow shaded cells--updates are automatic!"]
[null,null,null,null,null,null,"Click the button 'Sort Boats by Rating' to get the ordered boat starting times"]
[]
[]
["Wind speed",null,null,"Wind Spinnaker Adjustment",null,null,"race length (miles)",null,"start time of slowest boat"]
[12,"mph",null,9,"sec/mile",null,9.8,null,"13:00:00"]
["If no spinnaker adjustment is desired, enter value greater than 26"]
[]
["Boat name","Fleet","Elapsed Time","Rating","Pole Adj","NS Adjustment Enter 1 for no spinnaker","Actual Rating","Differential Time (seconds)","D Time (Minutes)","Min","Seconds","Specific Boat Start Time"]
["H2O Sprite",1,"1:42:51",120,null,null,120,323.4,5.39,5,23.4,"13:05:23.400"]
["1 Lucky Dog",1,"2:02:59",82,null,null,82,695.8,11.5966666666667,11,35.8000000000001,"13:11:35.800"]
["SV Galactica",1,"2:20:01",144,null,null,144,88.2,1.47,1,28.2,"13:01:28.200"]
["Sanctuary",1,"2:25:02",138,null,1,147,58.8,0.98,0,58.8,"13:00:58.800"]
["Dream Retriever",1,"3:02:29",144,null,1,153,0,0,0,0,"13:00:00"]
["Nauti Cat",1,"3:03:10",118,null,1,127,254.8,4.24666666666667,4,14.8,"13:04:14.800"]
["Boat name",1,null,40,null,null,40,1107.4,18.4566666666667,18,27.4,"13:18:27.400"]
["Boat name",1,null,20,null,null,20,1303.4,21.7233333333333,21,43.4000000000002,"13:21:43.400"]
["Boat name",1,null,20,null,null,20,1303.4,21.7233333333333,21,43.4000000000002,"13:21:43.400"]
["Hushgully",1,null,null,-3,1,12,1381.8,23.03,23,1.80000000000028,"13:23:01.800"]
["Lake Shark",1,null,null,null,null,0,0,0,0,0,"13:00:00"]
["Endurance",1,null,null,null,null,0,1499.4,24.99,24,59.4000000000001,"13:24:59.400"]
["Blew J",1,null,null,-3,null,0,1499.4,24.99,24,59.4000000000001,"13:24:59.400"]
["Sonshine",1,null,null,null,null,0,1499.4,24.99,24,59.4000000000001,"13:24:59.400"]
["MaKani Nu",1,null,null,null,null,0,1499.4,24.99,24,59.4000000000001,"13:24:59.400"]
["Phoenix",1,null,null,null,null,0,1499.4,24.99,24,59.4000000000001,"13:24:59.400"]
["McPuff",1,null,null,null,null,0,1499.4,24.99,24,59.4000000000001,"13:24:59.400"]
["Irish Joy",1,null,null,null,null,0,1499.4,24.99,24,59.4000000000001,"13:24:59.400"]
["Piranha",1,null,null,null,null,0,1499.4,24.99,24,59.4000000000001,"13:24:59.400"]
["Split Second",1,null,null,null,null,0,1499.4,24.99,24,59.4000000000001,"13:24:59.400"]

{"sheet":"WorkingSheet","index":1,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Pursuit Style Race Start Times",null,null,null,null,null,"Only edit/change entries in yellow shaded cells--updates are automatic!"]
[null,null,null,null,null,null,"Click the button 'Sort Boats by Rating' to get the ordered boat starting times"]
[]
[]
["Wind speed",null,null,"Wind Spinnaker Adjustment",null,null,"race length (miles)",null,"start time of slowest boat"]
[12,"mph",null,{"$f":"IF(A6<6,15,IF(A6<11,12,IF(A6<16,9,IF(A6<21,6,(IF(A6<26,3,0))))))","v":9},"sec/mile",null,{"$f":"4.9*2","v":9.8},null,"13:00:00"]
["If no spinnaker adjustment is desired, enter value greater than 26"]
[]
["Boat name","Fleet","Elapsed Time","Rating","Pole Adj","NS Adjustment Enter 1 for no spinnaker","Actual Rating","Differential Time (seconds)","D Time (Minutes)","Min","Seconds","Specific Boat Start Time"]
["Dream Retriever",1,"3:02:29",144,null,1,{"$f":"IF(F10=1,D10-E10+D$6,D10)","v":153},{"$f":"(G$10-G10)*G$6","v":0},{"$f":"H10/60","v":0},{"$f":"INT(H10/60)","v":0},{"$f":"(H10/60-J10)*60","v":0},{"$f":"I$6+I10/(60*24)","v":"13:00:00"}]
["Sanctuary",1,"2:25:02",138,null,1,{"$f":"IF(F11=1,D11-E11+D$6,D11)","v":147},{"$f":"(G$10-G11)*G$6","v":58.8},{"$f":"H11/60","v":0.98},{"$f":"INT(H11/60)","v":0},{"$f":"(H11/60-J11)*60","v":58.8},{"$f":"I$6+I11/(60*24)","v":"13:00:58.800"}]
["SV Galactica",1,"2:20:01",144,null,null,{"$f":"IF(F12=1,D12-E12+D$6,D12)","v":144},{"$f":"(G$10-G12)*G$6","v":88.2},{"$f":"H12/60","v":1.47},{"$f":"INT(H12/60)","v":1},{"$f":"(H12/60-J12)*60","v":28.2},{"$f":"I$6+I12/(60*24)","v":"13:01:28.200"}]
["Nauti Cat",1,"3:03:10",118,null,1,{"$f":"IF(F13=1,D13-E13+D$6,D13)","v":127},{"$f":"(G$10-G13)*G$6","v":254.8},{"$f":"H13/60","v":4.24666666666667},{"$f":"INT(H13/60)","v":4},{"$f":"(H13/60-J13)*60","v":14.8},{"$f":"I$6+I13/(60*24)","v":"13:04:14.800"}]
["H2O Sprite",1,"1:42:51",120,null,null,{"$f":"IF(F14=1,D14-E14+D$6,D14)","v":120},{"$f":"(G$10-G14)*G$6","v":323.4},{"$f":"H14/60","v":5.39},{"$f":"INT(H14/60)","v":5},{"$f":"(H14/60-J14)*60","v":23.4},{"$f":"I$6+I14/(60*24)","v":"13:05:23.400"}]
["1 Lucky Dog",1,"2:02:59",82,null,null,{"$f":"IF(F15=1,D15-E15+D$6,D15)","v":82},{"$f":"(G$10-G15)*G$6","v":695.8},{"$f":"H15/60","v":11.5966666666667},{"$f":"INT(H15/60)","v":11},{"$f":"(H15/60-J15)*60","v":35.8000000000001},{"$f":"I$6+I15/(60*24)","v":"13:11:35.800"}]
["Boat name",1,null,40,null,null,{"$f":"IF(F16=1,D16-E16+D$6,D16)","v":40},{"$f":"(G$10-G16)*G$6","v":1107.4},{"$f":"H16/60","v":18.4566666666667},{"$f":"INT(H16/60)","v":18},{"$f":"(H16/60-J16)*60","v":27.4},{"$f":"I$6+I16/(60*24)","v":"13:18:27.400"}]
["Boat name",1,null,20,null,null,{"$f":"IF(F17=1,D17-E17+D$6,D17)","v":20},{"$f":"(G$10-G17)*G$6","v":1303.4},{"$f":"H17/60","v":21.7233333333333},{"$f":"INT(H17/60)","v":21},{"$f":"(H17/60-J17)*60","v":43.4000000000002},{"$f":"I$6+I17/(60*24)","v":"13:21:43.400"}]
["Boat name",1,null,20,null,null,{"$f":"IF(F18=1,D18-E18+D$6,D18)","v":20},{"$f":"(G$10-G18)*G$6","v":1303.4},{"$f":"H18/60","v":21.7233333333333},{"$f":"INT(H18/60)","v":21},{"$f":"(H18/60-J18)*60","v":43.4000000000002},{"$f":"I$6+I18/(60*24)","v":"13:21:43.400"}]
["Hushgully",1,null,null,-3,1,{"$f":"IF(F19=1,D19-E19+D$6,D19)","v":12},{"$f":"(G$10-G19)*G$6","v":1381.8},{"$f":"H19/60","v":23.03},{"$f":"INT(H19/60)","v":23},{"$f":"(H19/60-J19)*60","v":1.80000000000028},{"$f":"I$6+I19/(60*24)","v":"13:23:01.800"}]
["Lake Shark",1,null,null,null,null,{"$f":"IF(F20=1,D20-E20+D$6,D20)","v":0},0,0,0,0,{"$f":"I$6+I20","v":"13:00:00"}]
["Endurance",1,null,null,null,null,{"$f":"IF(F21=1,D21-E21+D$6,D21)","v":0},{"$f":"(G$10-G21)*G$6","v":1499.4},{"$f":"H21/60","v":24.99},{"$f":"INT(H21/60)","v":24},{"$f":"(H21/60-J21)*60","v":59.4000000000001},{"$f":"I$6+I21/(60*24)","v":"13:24:59.400"}]
["Blew J",1,null,null,-3,null,{"$f":"IF(F22=1,D22-E22+D$6,D22)","v":0},{"$f":"(G$10-G22)*G$6","v":1499.4},{"$f":"H22/60","v":24.99},{"$f":"INT(H22/60)","v":24},{"$f":"(H22/60-J22)*60","v":59.4000000000001},{"$f":"I$6+I22/(60*24)","v":"13:24:59.400"}]
["Sonshine",1,null,null,null,null,{"$f":"IF(F23=1,D23-E23+D$6,D23)","v":0},{"$f":"(G$10-G23)*G$6","v":1499.4},{"$f":"H23/60","v":24.99},{"$f":"INT(H23/60)","v":24},{"$f":"(H23/60-J23)*60","v":59.4000000000001},{"$f":"I$6+I23/(60*24)","v":"13:24:59.400"}]
["MaKani Nu",1,null,null,null,null,{"$f":"IF(F24=1,D24-E24+D$6,D24)","v":0},{"$f":"(G$10-G24)*G$6","v":1499.4},{"$f":"H24/60","v":24.99},{"$f":"INT(H24/60)","v":24},{"$f":"(H24/60-J24)*60","v":59.4000000000001},{"$f":"I$6+I24/(60*24)","v":"13:24:59.400"}]
["Phoenix",1,null,null,null,null,{"$f":"IF(F25=1,D25-E25+D$6,D25)","v":0},{"$f":"(G$10-G25)*G$6","v":1499.4},{"$f":"H25/60","v":24.99},{"$f":"INT(H25/60)","v":24},{"$f":"(H25/60-J25)*60","v":59.4000000000001},{"$f":"I$6+I25/(60*24)","v":"13:24:59.400"}]
["McPuff",1,null,null,null,null,{"$f":"IF(F26=1,D26-E26+D$6,D26)","v":0},{"$f":"(G$10-G26)*G$6","v":1499.4},{"$f":"H26/60","v":24.99},{"$f":"INT(H26/60)","v":24},{"$f":"(H26/60-J26)*60","v":59.4000000000001},{"$f":"I$6+I26/(60*24)","v":"13:24:59.400"}]
["Irish Joy",1,null,null,null,null,{"$f":"IF(F27=1,D27-E27+D$6,D27)","v":0},{"$f":"(G$10-G27)*G$6","v":1499.4},{"$f":"H27/60","v":24.99},{"$f":"INT(H27/60)","v":24},{"$f":"(H27/60-J27)*60","v":59.4000000000001},{"$f":"I$6+I27/(60*24)","v":"13:24:59.400"}]
["Piranha",1,null,null,null,null,{"$f":"IF(F28=1,D28-E28+D$6,D28)","v":0},{"$f":"(G$10-G28)*G$6","v":1499.4},{"$f":"H28/60","v":24.99},{"$f":"INT(H28/60)","v":24},{"$f":"(H28/60-J28)*60","v":59.4000000000001},{"$f":"I$6+I28/(60*24)","v":"13:24:59.400"}]
["Split Second",1,null,null,null,null,{"$f":"IF(F29=1,D29-E29+D$6,D29)","v":0},{"$f":"(G$10-G29)*G$6","v":1499.4},{"$f":"H29/60","v":24.99},{"$f":"INT(H29/60)","v":24},{"$f":"(H29/60-J29)*60","v":59.4000000000001},{"$f":"I$6+I29/(60*24)","v":"13:24:59.400"}]

{"sheet":"BoatRatingSheet","index":2,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Boat name","Fleet","Finish Time","Rating","Pole Adj","NS Adjustment Enter 1 for no spinnaker","Actual Rating"]
["Lake Shark",1,null,241,null,null,{"$f":"IF(F10=1,D10-E10+D$6,D10)","v":241}]
["Endurance",1,null,189,null,null,{"$f":"IF(F11=1,D11-E11+D$6,D11)","v":189}]
["Hushgully",1,null,147,-3,1,{"$f":"IF(F12=1,D12-E12+D$6,D12)","v":150}]
["SV Galactica",1,null,144,null,1,{"$f":"IF(F13=1,D13-E13+D$6,D13)","v":144}]
["Blew J",1,null,147,-3,null,{"$f":"IF(F14=1,D14-E14+D$6,D14)","v":147}]
["Sonshine",1,null,147,null,null,{"$f":"IF(F15=1,D15-E15+D$6,D15)","v":147}]
["Sanctuary",1,null,147,null,null,{"$f":"IF(F16=1,D16-E16+D$6,D16)","v":147}]
["MaKani Nu",1,null,138,null,null,{"$f":"IF(F17=1,D17-E17+D$6,D17)","v":138}]
["H2O Sprite",1,null,120,null,null,{"$f":"IF(F18=1,D18-E18+D$6,D18)","v":120}]
["Phoenix",1,null,108,null,null,{"$f":"IF(F19=1,D19-E19+D$6,D19)","v":108}]
["McPuff",1,null,96,null,null,{"$f":"IF(F20=1,D20-E20+D$6,D20)","v":96}]
["Irish Joy",1,null,96,null,null,{"$f":"IF(F21=1,D21-E21+D$6,D21)","v":96}]
["Piranha",1,null,87,null,null,{"$f":"IF(F22=1,D22-E22+D$6,D22)","v":87}]
["1 Lucky Dog",1,null,82,null,null,{"$f":"IF(F23=1,D23-E23+D$6,D23)","v":82}]
["Split Second",1,null,81,null,null,{"$f":"IF(F24=1,D24-E24+D$6,D24)","v":81}]
["Boat name",1,null,60,null,1,{"$f":"IF(F25=1,D25-E25+D$6,D25)","v":60}]
["Boat name",1,null,45,null,null,{"$f":"IF(F26=1,D26-E26+D$6,D26)","v":45}]
["Boat name",1,null,40,null,null,{"$f":"IF(F27=1,D27-E27+D$6,D27)","v":40}]
["Boat name",1,null,20,null,null,{"$f":"IF(F28=1,D28-E28+D$6,D28)","v":20}]
["Boat name",1,null,20,null,null,{"$f":"IF(F29=1,D29-E29+D$6,D29)","v":20}]