{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Finish Times","Fleet 1","Finish Times (2)","Fleet 2","Fleet 3","Fleet 4","Fleet 1 and 2 Combo","Fleet 3 and 4 Combo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":5,"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":"Finish Times","index":0,"n_rows":40,"n_cols":31,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["MUST",null,"FLEET 1"]
["BE",null,"FLEET 2"]
["IN ALPHA",null,"FLEET 3"]
["ORDER",null,"FLEET 4"]
[null,null,null,null,null,"Finish Time"]
["BOAT NAME","FLEET","BOAT","SAIL #","SKIPPER","MINUTES","SECONDS"]
["Alarming",4,"S-2 9.2",505,"Oginz",80,19]
["Always Something",3,"Hunter 23",1256,"Gobble",78,50]
["Bandit",1,"J/24",2792,"Cliborne",66,11,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Boogie Board",1,"J/24",1742,"Maloney",66,53,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Catch 22",1,"J22",826,"Schiable",77,9," ",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Courageous",2,"Harbor 20",278,"Tunnell",82,13,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Dark Horse",1,"J/24",1024,"Forqurean",65,51,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Destiny",2,"Alerion 20",6,"Whitt",70,40,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Felicite",4,"S-2 27 IB",13,"Johnson",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Fenix",2,"San Juan 24",556,"Firing",77,24,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Fever",3,"Ericson 23",269,"Short",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Fools Game",2,"Pearson 26",1183,"Hull",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[" "," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Gotcha",2,"S-2 6.7",75,"Theis",70,55,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["ie ie bang bang",4,"Hunter 365",8,"Gillespie",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["King Bills Revenge",3,"San Juan 21",null,"Gillespie",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Little Wing",4,"Beneteau 29",485,"DeMestro",47,14,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Majical",3,"Cal 25",1687,"Witten",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Miss Virginia",3,"Hunter 23.5",1309,"Perdue",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["More Mischief",4,"Beneteau 285",144,"Gearhart"]
["Rascal",1,"J/24",3511,"Phillip",64,22]
["Second Wind",3,"Ericson 23",470,"Schraw",78,49]
["Severence",2,"C&C 25",14755,"Evans"]
["Stoic",2,"Harbor 20",330,"Hemler",75,56]
["StressLess",2,"Harbor 20",212,"Breckenridge",66,56]
["Synergy",2,"Harbor 20",215,"Miekina",80,54]
["Te Aroha",4,"Beneteau 285",285,"Short"]
["Time Warp",1,"J/24",1248,"Sampson",82,5]
["Tundra Swan",3,"Hunter 23",1256,"Gobble"]
["UDO",1,"VX One",119,"Gietl"]
["Willaway",4,"Columbia 29",222,"Conover"]

{"sheet":"Fleet 1","index":1,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,0,4,14],[5,0,5,14],[6,0,6,14],[6,19,6,21],[7,6,7,7],[7,8,7,9],[7,10,7,11]]}
["Control Z to run macro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N23)","v":60.155763239875384}]
[0,"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Sign Up Sheet Fleet I (ONE)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
["Date: Sept 10, 2016      2016 Fall Series Races 1 & 2       RC: Perdue and Johnson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC23)","v":6}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Cliborne","Bandit",null,null,"J/24",2792,170,{"$f":"IFERROR(G10+15,\"\")","v":185},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.93457943925233644},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":66},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":11},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":66.183333333333337},{"$f":"IFERROR(U10,\" \")","v":61.853582554517139},3,{"$f":"IFERROR(N10-$Y$2,\"\")","v":1.6978193146417553},0.31152647975078906,{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":200},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":61.853582554517139},{"$f":"IFERROR(RANK(N10,$N$10:$N$23,1),\"\")","v":3},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":0.90892616328192466},{"$f":"IFERROR(M10*Y10,\"\")","v":60.155763239875384},null,1,3,1.6978193146417553,0.31152647975078906,null,null,55,39,null,{"$f":"(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE))","v":66}]
["Forqurean","Dark Horse",null,null,"J/24",1024,170,185,0.93457943925233644,{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":""},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":65},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":51},{"$f":"IF(AK11>0,(K11+L11/60)-A$3,\" \")","v":65.849999999999994},61.54205607476635,2,1.3862928348909662,1.3862928348909662,195,null,"s",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":61.54205607476635},2,null,null,0.9135271562623446,{"$f":"IFERROR(M11*Y11,\"\")","v":60.155763239875384},null,2,2,1.3862928348909662,1.3862928348909662,null,null,56,22,null,{"$f":"(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE))","v":65}]
["Maloney","Boogie Board",null,null,"J/24",1742,170,185,0.93457943925233644,{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":""},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":66},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":53},66.88333333333334,62.507788161993773,4,2.3520249221183889,0.65420560747663359,212,null,"s",62.507788161993773,4,null,null,0.89941335519375099,60.155763239875384,null,3,4,2.3520249221183889,0.65420560747663359,null,null,54,9,null,{"$f":"(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE))","v":66}]
["Phillip","Rascal",null,null,"J/24",3511,170,185,0.93457943925233644,{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":""},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":64},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":22},64.36666666666666,60.155763239875384,1,0,null,170,null,"s",60.155763239875384,1,null,null,0.93457943925233644,60.155763239875384,null,4,1,0,null,null,null,62,59,null,{"$f":"(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE))","v":64}]
["Sampson","Time Warp",null,null,"J/24",1248,170,185,0.93457943925233644,{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":""},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":5},82.083333333333329,76.713395638629279,6,16.557632398753896,5.0792266506998374,465,null,"s",76.713395638629279,6,null,null,0.73286209023198445,60.155763239875384,null,5,6,16.557632398753896,5.0792266506998374,null,null,59,12,null,{"$f":"(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
["Schiable","Catch 22",null,null,"J22",826,177,192,0.92850510677808729,"",{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":77},{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":9},77.150000000000006,71.634168987929442,5,11.478405748054058,9.1263808259356693,383,null,"s",71.634168987929442,5,null,null,0.77972473415262966,60.155763239875384,null,6,5,11.478405748054058,9.1263808259356693,null,null,56,58,null,{"$f":"(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE))","v":77}]
["Gietl","UDO",null,null,"VX One",119,107,122,0.99304865938430986,"",{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,8,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(T17 =\"n\",1000/(900+H17),\"\")","v":""},null,null,null," ","","","","",null,"s"," ","",null,null,"","",null,9,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K18>0,(K18+L18/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U18,\" \")","v":""},{"$f":"IFERROR(V18,\" \")","v":""},{"$f":"IFERROR(N18-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y18)-900,0),\"\")","v":""},null,"n","","",null,null,"","",null,10,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null," ","","","","","",null,"n","","",null,null,"","",null,11,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"n"," ","",null,null,"","",null,12,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K21>0,(K21+L21/60)-A$3,\" \")","v":" "},"","","","","",null,"n","","",null,null,"","",null,13,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null," ","","","","","",null,"n","","",null,null,"","",null,14,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null," ","","","","","",null,"n","","",null,null,"","",null,15,"","",""]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET ONE",null,null,0,null,null,null,null,null,null,null,null,null,null,16,null,null,0]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,17,null,null,0]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,18,null,null,0]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,19,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FLEET ONE",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]

{"sheet":"Finish Times (2)","index":2,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["MUST",null,"FLEET 1"]
["BE",null,"FLEET 2"]
["IN ALPHA",null,"FLEET 3"]
["ORDER",null,"FLEET 4"]
[null,null,null,null,null,"Finish Time"]
["BOAT NAME","FLEET","BOAT","SAIL #","SKIPPER","MINUTES","SECONDS"]
["Bandit",1,"J/24",2792,"Cliborne"]
["Blunder Bus",1,"J/24",null,"Hardy"]
["Boogie Board",1,"J/24",1742,"Maloney"]
["Catch 22",1,"J22",826,"Schiable"]
["Dark Horse",1,"J/24",1024,"Forqurean"]
["Fox Trot",1,"Colgate 26",null,"Haddon"]
["Rascal",1,"J/24",3511,"Phillip"]
["Time Warp",1,"J/24",1248,"Sampson"]
["UDO",1,"VX One",119,"Gietl"]
["Destiny",2,"Alerion 20",6,"Whitt"]
["Fools Game",2,"Pearson 26",1183,"Hull"]
["Gotcha",2,"S-2 6.7",75,"Theis"]
["Majical",2,"Cal 25",1687,"Witten"]
["Severence",2,"C&C 25",14755,"Evans"]
["Stoic",2,"Harbor 20",330,"Hemler"]
["StressLess",2,"Harbor 20",212,"Breckenridge"]
["Synergy",2,"Harbor 20",215,"Miekina"]
["Circle Back",3,"Catalina 22","C22","Nash"]
["Miss Virginia",3,"Hunter 23.5",1309,"Perdue"]
["Norse Raider",3,"Ericson 23",23,"Short"]
["Second Wind",3,"Ericson 23",470,"Schraw"]
["Tundra Swan",3,"Hunter 23",1256,"Gobble"]
["Alarming",4,"S-2 9.2",505,"Oginz"]
["BILL",4,"Hunter 356",null,"Gillespie"]
["Felicite",4,"S-2 27 IB",13,"Johnson"]
["Got to Go",4,"Catalina 30",97,"Forrester"]
["Janet Anne",4,"Catalina 25",5155,"Tunnell"]
["Little Wing",4,"Beneteau 29",485,"DeMestro"]
["More Mischief",4,"Beneteau 285",144,"Gearhart"]
["Willaway",4,"Columbia 29",222,"Conover"]

{"sheet":"Fleet 2","index":3,"n_rows":30,"n_cols":37,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,0,4,14],[5,0,5,14],[6,0,6,14],[6,19,6,21],[7,6,7,7],[7,8,7,9],[7,10,7,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N24)","v":58.972099853157125}]
[0,"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Sign Up Sheet Fleet II (TWO)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
["Date: Sept 10, 2016      2016 Fall Series Races 1 & 2       RC: Perdue and Johnson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC24)","v":7}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Theis","Gotcha",null,null,"S-2 6.7",75,208,{"$f":"IFERROR(G10+15,\"\")","v":223},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.90252707581227432},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":70},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":55},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":70.916666666666671},{"$f":"IFERROR(U10,\" \")","v":64.00421179302046},3,{"$f":"IFERROR(N10-$Y$2,\"\")","v":5.0321119398633343},1.9069651615031731,{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":303},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":64.00421179302046},{"$f":"IFERROR(RANK(N10,$N$10:$N$24,1),\"\")","v":3},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":0.83156897560268561},{"$f":"IFERROR(M10*Y10,\"\")","v":58.972099853157125},null,1,3,5.0321119398633343,1.9069651615031731,null,null,55,39,null,{"$f":"VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)","v":70}]
["Hull","Fools Game",null,null,"Pearson 26",1183,216,{"$f":"IFERROR(G11+15,\"\")","v":231},{"$f":"IF(T11 = \"s\",1000/(900+G11),\"\")","v":0.89605734767025091},{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":""},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":""},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":""},{"$f":"IF(AK11>0,(K11+L11/60)-A$3,\" \")","v":" "},"","","","","",null,"s",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":""},{"$f":"IFERROR(RANK(N11,$N$10:$N$24,1),\"\")","v":""},null,null,"",{"$f":"IFERROR(M11*Y11,\"\")","v":""},null,2,"","","",null,null,56,22,null,{"$f":"VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Evans","Severence",null,null,"C&C 25",14755,218,233,{"$f":"IF(T12 = \"s\",1000/(900+G12),\"\")","v":0.89445438282647582},{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":""},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":""},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,3,"","","",null,null,54,9,null,{"$f":"VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Witten","Majical",null,null,"Cal 25",1687,224,239,{"$f":"IF(T13 = \"s\",1000/(900+G13),\"\")","v":0.88967971530249113},{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":""},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":""},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,4,"","","",null,null,62,59,null,{"$f":"VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Breckenridge","StressLess",null,null,"Harbor 20",212,220,{"$f":"IFERROR(G14+15,\"\")","v":235},{"$f":"IF(T14 = \"s\",1000/(900+G14),\"\")","v":""},{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":0.88105726872246692},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":66},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":56},66.933333333333337,{"$f":"IFERROR(U14,\" \")","v":58.972099853157125},{"$f":"IFERROR(V14,\" \")","v":1},{"$f":"IFERROR(N14-$Y$2,\"\")","v":0},null,{"$f":"IFERROR(ROUND((1000/Y14)-900,0),\"\")","v":235},null,"n",58.972099853157125,1,null,null,0.88105726872246692,58.972099853157125,null,5,1,0,null,null,null,59,12,null,{"$f":"VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)","v":66}]
["Miekina","Synergy",null,null,"Harbor 20",215,220,235,"",0.88105726872246692,{"$f":"IF(AK15>0,VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":80},{"$f":"IF(AK15>0,VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":54},80.900000000000006,71.277533039647579,6,12.305433186490454,2.0467638088783389,472,null,"n",71.277533039647579,6,null,null,0.7289505544271585,58.972099853157125,null,6,6,12.305433186490454,2.0467638088783389,null,null,56,58,null,{"$f":"VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)","v":80}]
["Hemler","Stoic",null,null,"Harbor 20",330,220,235,"",0.88105726872246692,{"$f":"IF(AK16>0,VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":75},{"$f":"IF(AK16>0,VLOOKUP($B16,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":56},75.933333333333337,66.901615271659324,4,7.9295154185021985,2.8974034786388643,388,null,"n",66.901615271659324,4,null,null,0.77662993660874169,58.972099853157118,null,7,4,7.9295154185021985,2.8974034786388643,null,null,64,47,null,{"$f":"VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)","v":75}]
["Tunnell","Courageous",null,null,"Harbor 20",278,220,235,"",0.88105726872246692,{"$f":"IF(AK17>0,VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":82},{"$f":"IF(AK17>0,VLOOKUP($B17,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":13},82.216666666666669,72.437591776798826,7,13.4654919236417,1.1600587371512461,494,null,"n",72.437591776798826,7,null,null,0.71727670609962035,58.972099853157118,null,8,7,13.4654919236417,1.1600587371512461,null,null,null,null,null,{"$f":"VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)","v":82}]
["Whitt","Destiny",null,null,"Alerion 20",6,223,{"$f":"IFERROR(G18+15,\"\")","v":238},{"$f":"IF(T18 = \"s\",1000/(900+G18),\"\")","v":""},{"$f":"IF(T18 =\"n\",1000/(900+H18),\"\")","v":0.87873462214411246},{"$f":"IF(AK18>0,VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":70},{"$f":"IF(AK18>0,VLOOKUP($B18,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":40},{"$f":"IF(AK18>0,(K18+L18/60)-A$3,\" \")","v":70.666666666666671},{"$f":"IFERROR(U18,\" \")","v":62.097246631517287},{"$f":"IFERROR(V18,\" \")","v":2},{"$f":"IFERROR(N18-$Y$2,\"\")","v":3.1251467783601612},3.1251467783601612,{"$f":"IFERROR(ROUND((1000/Y18)-900,0),\"\")","v":298},null,"n",62.097246631517287,2,null,null,0.83451084697863853,58.972099853157125,null,9,2,3.1251467783601612,3.1251467783601612,null,null,null,null,null,{"$f":"VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE)","v":70}]
["Firing","Fenix",null,null,"San Juan 24",556,218,{"$f":"IFERROR(G19+15,\"\")","v":233},{"$f":"IF(T19 = \"s\",1000/(900+G19),\"\")","v":0.89445438282647582},{"$f":"IF(T19 =\"n\",1000/(900+H19),\"\")","v":""},{"$f":"IF(AK19>0,VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":77},{"$f":"IF(AK19>0,VLOOKUP($B19,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":24},{"$f":"IF(AK19>0,(K19+L19/60)-A$3,\" \")","v":77.400000000000006},{"$f":"IFERROR(U19,\" \")","v":69.230769230769241},{"$f":"IFERROR(V19,\" \")","v":5},{"$f":"IFERROR(N19-$Y$2,\"\")","v":10.258669377612115},2.3291539591099166,{"$f":"IFERROR(ROUND((1000/Y19)-900,0),\"\")","v":412},null,"s",69.230769230769241,5,null,null,0.76191343479531159,58.972099853157118,null,10,5,10.258669377612115,2.3291539591099166,null,null,null,null,null,{"$f":"VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)","v":77}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"s"," ","",null,null,"","",null,11,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,12,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,14,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,15,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B24,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET TWO",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["FLEET TWO",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]

{"sheet":"Fleet 3","index":4,"n_rows":30,"n_cols":37,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,0,4,14],[5,0,5,14],[6,0,6,14],[6,19,6,21],[7,6,7,7],[7,8,7,9],[7,10,7,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N24)","v":63.814462690867181}]
[5,"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Sign Up Sheet Fleet III (THREE)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
["Date: Sept 10, 2016      2016 Fall Series Races 1 & 2       RC: Perdue and Johnson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC24)","v":2}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Perdue","Miss Virginia",null,null,"Hunter 23.5",1309,244,{"$f":"IFERROR(G10+15,\"\")","v":259},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.87412587412587417},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U10,\" \")","v":""},"",{"$f":"IFERROR(N10-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":""},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":""},{"$f":"IFERROR(RANK(N10,$N$10:$N$24,1),\"\")","v":""},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":""},{"$f":"IFERROR(M10*Y10,\"\")","v":""},null,1,"","","",null,null,55,39,null,{"$f":"VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Schraw","Second Wind",null,null,"Ericson 23",470,240,{"$f":"IFERROR(G11+15,\"\")","v":255},{"$f":"IF(T11 = \"s\",1000/(900+G11),\"\")","v":""},{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":0.86580086580086579},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":78},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":49},{"$f":"IF(AK11>0,(K11+L11/60)-A$3,\" \")","v":73.816666666666663},63.910533910533907,2,9.6071219666725938E-2,9.6071219666725938E-2,257,null,"n",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":63.910533910533907},{"$f":"IFERROR(RANK(N11,$N$10:$N$24,1),\"\")","v":2},null,null,0.86449938167803819,{"$f":"IFERROR(M11*Y11,\"\")","v":63.814462690867181},null,2,2,9.6071219666725938E-2,9.6071219666725938E-2,null,null,56,22,null,{"$f":"VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)","v":78}]
["Short","Fever",null,null,"Ericson 23",269,{"$f":"241+3","v":244},259,{"$f":"IF(T12 = \"s\",1000/(900+G12),\"\")","v":""},{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":0.86281276962899056},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "}," ","","","","","",null,"n","","",null,null,"","",null,3,"","","",null,null,54,9,null,{"$f":"VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Gobble","Always Something",null,null,"Hunter 23",1256,242,257,{"$f":"IF(T13 = \"s\",1000/(900+G13),\"\")","v":""},{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":0.86430423509075194},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":78},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":50},73.833333333333329,63.814462690867181,1,0,null,257,null,"n",63.814462690867181,1,null,null,0.86430423509075194,63.814462690867181,null,4,1,0,null,null,null,62,59,null,{"$f":"VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)","v":78}]
["Witten","Majical",null,null,"Cal 25",1687,224,239,{"$f":"IF(T14 = \"s\",1000/(900+G14),\"\")","v":0.88967971530249113},{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":""},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "}," ","","","","","",null,"s","","",null,null,"","",null,5,"","","",null,null,59,12,null,{"$f":"VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Gillespie","King Bills Revenge",null,null,"San Juan 21",153,251,266,"",0.85763293310463118,null,null,null,{"$f":"IFERROR(U15,\" \")","v":" "},{"$f":"IFERROR(V15,\" \")","v":""},{"$f":"IFERROR(N15-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y15)-900,0),\"\")","v":""},null,"n"," ","",null,null,"","",null,6,"","","",null,null,56,58,null,{"$f":"VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,7,"","","",null,null,64,47,null,{"$f":"VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,8,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,9,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,10,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"s"," ","",null,null,"","",null,11,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,12,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,14,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,15,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B24,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET THREE",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["FLEET THREE",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]

{"sheet":"Fleet 4","index":5,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,0,4,14],[5,0,5,14],[6,0,6,14],[6,19,6,21],[7,6,7,7],[7,8,7,9],[7,10,7,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N23)","v":38.996614342874729}]
[5,"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Sign Up Sheet Fleet IV (FOUR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
["Date: Sept 10, 2016      2016 Fall Series Races 1 & 2       RC: Perdue and Johnson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC23)","v":2}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["DeMestro","Little Wing",null,null,"Beneteau 29",485,168,{"$f":"IFERROR(G10+15,\"\")","v":183},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":""},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":0.92336103416435822},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":47},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":14},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":42.233333333333334},{"$f":"IFERROR(U10,\" \")","v":38.996614342874729},1,{"$f":"IFERROR(N10-$Y$2,\"\")","v":0},null,{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":183},null,"n",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":38.996614342874729},{"$f":"IFERROR(RANK(N10,$N$10:$N$23,1),\"\")","v":1},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":0.92336103416435822},{"$f":"IFERROR(M10*Y10,\"\")","v":38.996614342874729},null,1,1,0,null,null,null,55,39,null,{"$f":"VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)","v":47}]
["Oginz","Alarming",null,null,"S-2 9.2",505,{"$f":"183+3+3","v":189},{"$f":"IFERROR(G11+15,\"\")","v":204},{"$f":"IF(T11 = \"s\",1000/(900+G11),\"\")","v":""},{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":0.90579710144927539},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":80},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":19},{"$f":"IF(AK11>0,(K11+L11/60)-A$3,\" \")","v":75.316666666666663},68.221618357487927,2,29.225004014613198,29.225004014613198,1031,null,"n",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":68.221618357487927},2,null,null,0.51776872329552637,{"$f":"IFERROR(M11*Y11,\"\")","v":38.996614342874729},null,2,2,29.225004014613198,29.225004014613198,null,null,56,22,null,{"$f":"VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)","v":80}]
["Gearhart","More Mischief",null,null,"Beneteau 285",144,{"$f":"193+6","v":199},214,{"$f":"IF(T12 = \"s\",1000/(900+G12),\"\")","v":""},{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":0.89766606822262118},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "}," ","","","","","",null,"n","","",null,null,"","",null,4,"","","",null,null,62,59,null,{"$f":"VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Johnson","Felicite",null,null,"S-2 27 IB",13,{"$f":"188+6","v":194},209,{"$f":"IF(T13 = \"s\",1000/(900+G13),\"\")","v":""},{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":0.90171325518485124},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "}," ","","","","","",null,"n","","",null,null,"","",null,5,"","","",null,null,59,12,null,{"$f":"VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Conover","Willaway",null,null,"Columbia 29",222,{"$f":"225+6","v":231},{"$f":"IFERROR(G14+15,\"\")","v":246},{"$f":"IF(T14 = \"s\",1000/(900+G14),\"\")","v":""},{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":0.87260034904013961},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "}," ",{"$f":"IFERROR(U14,\" \")","v":""},{"$f":"IFERROR(V14,\" \")","v":""},{"$f":"IFERROR(N14-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y14)-900,0),\"\")","v":""},null,"n","","",null,null,"","",null,6,"","","",null,null,56,58,null,{"$f":"VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Gillespie","ie ie bang bang",null,null,"Hunter 365",null,{"$f":"139+3+3+3","v":148},163,"",0.94073377234242705,{"$f":"IF(AK15>0,VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK15>0,VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "}," ","","","","","",null,"n","","",null,null,"","",null,7,"","","",null,null,64,47,null,{"$f":"VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Short","Te Aroha",null,null,"Beneteau 285",285,199,{"$f":"IFERROR(G16+15,\"\")","v":214},{"$f":"IF(T16 = \"s\",1000/(900+G16),\"\")","v":""},{"$f":"IF(T16 =\"n\",1000/(900+H16),\"\")","v":0.89766606822262118},{"$f":"IF(AK16>0,VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK16>0,VLOOKUP($B16,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "},{"$f":"IF(AK16>0,(K16+L16/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U16,\" \")","v":""},{"$f":"IFERROR(V16,\" \")","v":""},{"$f":"IFERROR(N16-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y16)-900,0),\"\")","v":""},null,"n","","",null,null,"","",null,8,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,9,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,10,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,11,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,12,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,14,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,15,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET FOUR",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FLEET FOUR",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]

{"sheet":"Fleet 1 and 2 Combo","index":6,"n_rows":33,"n_cols":37,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,14],[5,0,5,14],[6,0,6,14],[6,19,6,21],[7,6,7,7],[7,8,7,9],[7,10,7,11]]}
["Control Z to run macro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N27)","v":58.972099853157125}]
[0,"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Race Results Fleets I & 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
["Date: Sept 10, 2016      2016 Fall Series Races 1 & 2       RC: Perdue and Johnson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC27)","v":13}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Cliborne","Bandit",null,null,"J/24",2792,170,{"$f":"IFERROR(G10+15,\"\")","v":185},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.93457943925233644},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":66},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":11},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":66.183333333333337},{"$f":"IFERROR(U10,\" \")","v":61.853582554517139},4,{"$f":"IFERROR(N10-$Y$2,\"\")","v":2.8814827013600137},0.31152647975078906,{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":222},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":61.853582554517139},{"$f":"IFERROR(RANK(N10,$N$10:$N$27,1),\"\")","v":4},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":0.89104154902780841},{"$f":"IFERROR(M10*Y10,\"\")","v":58.972099853157125},null,1,4,2.8814827013600137,0.31152647975078906,null,null,55,39,null,{"$f":"(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE))","v":66}]
["Forqurean","Dark Horse",null,null,"J/24",1024,170,185,0.93457943925233644,{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":""},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":65},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":51},{"$f":"IF(AK11>0,(K11+L11/60)-A$3,\" \")","v":65.849999999999994},61.54205607476635,3,2.5699562216092247,1.3862928348909662,217,null,"s",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":61.54205607476635},3,null,null,0.89555200991886308,{"$f":"IFERROR(M11*Y11,\"\")","v":58.972099853157125},null,2,3,2.5699562216092247,1.3862928348909662,null,null,56,22,null,{"$f":"(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE))","v":65}]
["Maloney","Boogie Board",null,null,"J/24",1742,170,185,0.93457943925233644,{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":""},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":66},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":53},66.88333333333334,62.507788161993773,6,3.5356883088366473,0.41054153047648612,234,null,"s",62.507788161993773,6,null,null,0.88171592105393148,58.972099853157125,null,3,6,3.5356883088366473,0.41054153047648612,null,null,54,9,null,{"$f":"(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE))","v":66}]
["Phillip","Rascal",null,null,"J/24",3511,170,185,0.93457943925233644,{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":""},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":64},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":22},64.36666666666666,60.155763239875384,2,1.1836633867182584,1.1836633867182584,191,null,"s",60.155763239875384,2,null,null,0.91619005468395331,58.972099853157125,null,4,2,1.1836633867182584,1.1836633867182584,null,null,62,59,null,{"$f":"(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE))","v":64}]
["Sampson","Time Warp",null,null,"J/24",1248,170,185,0.93457943925233644,{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":""},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":5},82.083333333333329,76.713395638629279,13,17.741295785472154,4.2758038618304539,492,null,"s",76.713395638629279,13,null,null,0.71844182562221881,58.972099853157125,null,5,13,17.741295785472154,4.2758038618304539,null,null,59,12,null,{"$f":"(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
["Firing","Fenix",null,null,"San Juan 24",556,218,233,0.89445438282647582,"",{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":77},{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":24},77.400000000000006,69.230769230769241,9,10.258669377612115,2.3291539591099166,412,null,"s",69.230769230769241,9,null,null,0.76191343479531159,58.972099853157118,null,6,9,10.258669377612115,2.3291539591099166,null,null,56,58,null,{"$f":"(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE))","v":77}]
["Schiable","Catch 22",null,null,"J22",826,177,192,0.92850510677808729,"",{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":77},{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":9},77.150000000000006,71.634168987929442,11,12.662069134772317,0.35663594828186262,408,null,"s",71.634168987929442,11,null,null,0.76438237009924981,58.972099853157125,null,7,11,12.662069134772317,0.35663594828186262,null,null,64,47,null,{"$f":"(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE))","v":77}]
["Gietl","UDO",null,null,"VX One",119,107,122,0.99304865938430986,"",{"$f":"IF($AK17>0,(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK17>0,(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,9,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Theis","Gotcha",null,null,"S-2 6.7",75,208,{"$f":"IFERROR(G18+15,\"\")","v":223},{"$f":"IF(T18 = \"s\",1000/(900+G18),\"\")","v":0.90252707581227432},{"$f":"IF(T18 =\"n\",1000/(900+H18),\"\")","v":""},{"$f":"IF($AK18>0,(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":70},{"$f":"IF($AK18>0,(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":55},{"$f":"IF(AK18>0,(K18+L18/60)-A$3,\" \")","v":70.916666666666671},{"$f":"IFERROR(U18,\" \")","v":64.00421179302046},{"$f":"IFERROR(V18,\" \")","v":7},{"$f":"IFERROR(N18-$Y$2,\"\")","v":5.0321119398633343},1.496423631026687,{"$f":"IFERROR(ROUND((1000/Y18)-900,0),\"\")","v":303},null,"s",64.00421179302046,7,null,null,0.83156897560268561,58.972099853157125,null,10,7,5.0321119398633343,1.496423631026687,null,null,null,null,null,{"$f":"(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE))","v":70}]
["Hull","Fools Game",null,null,"Pearson 26",1183,216,231,0.89605734767025091,{"$f":"IF(T19 =\"n\",1000/(900+H19),\"\")","v":""},{"$f":"IF($AK19>0,(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK19>0,(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""},{"$f":"IF(AK19>0,(K19+L19/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U19,\" \")","v":""},{"$f":"IFERROR(V19,\" \")","v":""},{"$f":"IFERROR(N19-$Y$2,\"\")","v":""},"","",null,"s","","",null,null,"","",null,11,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Evans","Severence",null,null,"C&C 25",14755,218,233,0.89445438282647582,"",{"$f":"IF($AK20>0,(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK20>0,(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,12,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Witten","Majical",null,null,"Cal 25",1687,224,239,0.88967971530249113,"",{"$f":"IF($AK21>0,(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK21>0,(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Breckenridge","StressLess",null,null,"Harbor 20",212,220,235,"",0.88105726872246692,{"$f":"IF($AK22>0,(VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":66},{"$f":"IF($AK22>0,(VLOOKUP($B22,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":56},66.933333333333337,58.972099853157125,1,0,null,235,null,"n",58.972099853157125,1,null,null,0.88105726872246692,null,null,14,1,0,null,null,null,null,null,null,{"$f":"(VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE))","v":66}]
["Miekina","Synergy",null,null,"Harbor 20",215,220,235,"",0.88105726872246692,{"$f":"IF($AK23>0,(VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":80},{"$f":"IF($AK23>0,(VLOOKUP($B23,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":54},80.900000000000006,71.277533039647579,10,12.305433186490454,2.0467638088783389,472,null,"n",71.277533039647579,10,null,null,0.7289505544271585,null,null,15,10,12.305433186490454,2.0467638088783389,null,null,null,null,null,{"$f":"(VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE))","v":80}]
["Hemler","Stoic",null,null,"Harbor 20",330,220,235,"",0.88105726872246692,{"$f":"IF($AK24>0,(VLOOKUP($B24,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":75},{"$f":"IF($AK24>0,(VLOOKUP($B24,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":56},75.933333333333337,66.901615271659324,8,7.9295154185021985,0.24366407700014747,388,null,"n",66.901615271659324,8,null,null,0.77662993660874169,null,null,null,5,3.1251467783601612,0.24366407700014747,null,null,null,null,null,{"$f":"(VLOOKUP($B24,'Finish Times'!$A$10:$G$40,6,FALSE))","v":75}]
["Tunnell","Courageous",null,null,"Harbor 20",278,220,235,"",0.88105726872246692,{"$f":"IF($AK25>0,(VLOOKUP($B25,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK25>0,(VLOOKUP($B25,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":13},82.216666666666669,72.437591776798826,12,13.4654919236417,2.8974034786388643,494,null,"n",72.437591776798826,12,null,null,0.71727670609962035,null,null,null,8,7.9295154185021985,2.8974034786388643,null,null,null,null,null,{"$f":"(VLOOKUP($B25,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
["Whitt","Destiny",null,null,"Alerion 20",6,223,{"$f":"IFERROR(G26+15,\"\")","v":238},{"$f":"IF(T26 = \"s\",1000/(900+G26),\"\")","v":""},{"$f":"IF(T26 =\"n\",1000/(900+H26),\"\")","v":0.87873462214411246},{"$f":"IF($AK26>0,(VLOOKUP($B26,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":70},{"$f":"IF($AK26>0,(VLOOKUP($B26,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":40},{"$f":"IF(AK26>0,(K26+L26/60)-A$3,\" \")","v":70.666666666666671},{"$f":"IFERROR(U26,\" \")","v":62.097246631517287},{"$f":"IFERROR(V26,\" \")","v":5},{"$f":"IFERROR(N26-$Y$2,\"\")","v":3.1251467783601612},0.80342278886938345,{"$f":"IFERROR(ROUND((1000/Y26)-900,0),\"\")","v":298},null,"n",62.097246631517287,5,null,null,0.83451084697863853,58.972099853157125,null,null,12,13.4654919236417,0.80342278886938345,null,null,null,null,null,{"$f":"(VLOOKUP($B26,'Finish Times'!$A$10:$G$40,6,FALSE))","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K27>0,(K27+L27/60)-A$3,\" \")","v":" "},"","","","","",null,"n","","",null,null,"","",null,null,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B27,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET ONE & TWO",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["(In case race timer has issues, use clock time as backup and do the math)"]
["(1) Convert seconds to decimal equivalent - see reference sheet"]
["(2) Multiply time in minutes by circled TCF"]
[]
["FLEET ONE",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]

{"sheet":"Fleet 3 and 4 Combo","index":7,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,0,4,14],[5,0,5,14],[6,0,6,14],[6,19,6,21],[7,6,7,7],[7,8,7,9],[7,10,7,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N23)","v":38.996614342874729}]
[5,"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Race Results Fleets 3 & 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
["Date: Sept 10, 2016      2016 Fall Series Races 1 & 2       RC: Perdue and Johnson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC23)","v":4}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Perdue","Miss Virginia",null,null,"Hunter 23.5",1309,244,{"$f":"IFERROR(G10+15,\"\")","v":259},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.87412587412587417},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U10,\" \")","v":""},"",{"$f":"IFERROR(N10-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":""},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":""},{"$f":"IFERROR(RANK(N10,$N$10:$N$23,1),\"\")","v":""},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":""},{"$f":"IFERROR(M10*Y10,\"\")","v":""},null,1,"","","",null,null,55,39,null,{"$f":"(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Schraw","Second Wind",null,null,"Ericson 23",470,240,{"$f":"IFERROR(G11+15,\"\")","v":255},{"$f":"IF(T11 = \"s\",1000/(900+G11),\"\")","v":""},{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":0.86580086580086579},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":78},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":49},73.816666666666663,63.910533910533907,3,24.913919567659178,9.6071219666725938E-2,993,null,"n",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":63.910533910533907},3,null,null,0.52829010173232871,{"$f":"IFERROR(M11*Y11,\"\")","v":38.996614342874729},null,2,3,24.913919567659178,9.6071219666725938E-2,null,null,56,22,null,{"$f":"(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE))","v":78}]
["Short","Fever",null,null,"Ericson 23",269,{"$f":"241+3","v":244},259,{"$f":"IF(T12 = \"s\",1000/(900+G12),\"\")","v":""},{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":0.86281276962899056},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""},{"$f":"IF(AK12>0,(K12+L12/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U12,\" \")","v":""},{"$f":"IFERROR(V12,\" \")","v":""},{"$f":"IFERROR(N12-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y12)-900,0),\"\")","v":""},null,"n","","",null,null,"","",null,3,"","","",null,null,54,9,null,{"$f":"(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Gobble","Always Something",null,null,"Hunter 23",1256,242,257,{"$f":"IF(T13 = \"s\",1000/(900+G13),\"\")","v":""},{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":0.86430423509075194},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":78},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":50},73.833333333333329,63.814462690867181,2,24.817848347992452,24.817848347992452,993,null,"n",63.814462690867181,2,null,null,0.52817084888769383,38.996614342874729,null,4,2,24.817848347992452,24.817848347992452,null,null,62,59,null,{"$f":"(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE))","v":78}]
["Witten","Majical",null,null,"Cal 25",1687,224,239,{"$f":"IF(T14 = \"s\",1000/(900+G14),\"\")","v":0.88967971530249113},{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":""},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,5,"","","",null,null,59,12,null,{"$f":"(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["DeMestro","Little Wing",null,null,"Beneteau 29",485,168,{"$f":"IFERROR(G15+15,\"\")","v":183},{"$f":"IF(T15 = \"s\",1000/(900+G15),\"\")","v":""},{"$f":"IF(T15 =\"n\",1000/(900+H15),\"\")","v":0.92336103416435822},{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":47},{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":14},42.233333333333334,{"$f":"IFERROR(U15,\" \")","v":38.996614342874729},{"$f":"IFERROR(V15,\" \")","v":1},{"$f":"IFERROR(N15-$Y$2,\"\")","v":0},null,{"$f":"IFERROR(ROUND((1000/Y15)-900,0),\"\")","v":183},null,"n",38.996614342874729,1,null,null,0.92336103416435822,38.996614342874729,null,6,1,0,null,null,null,56,58,null,{"$f":"(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE))","v":47}]
["Oginz","Alarming",null,null,"S-2 9.2",505,{"$f":"183+3+3","v":189},204,"",0.90579710144927539,{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":80},{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":19},75.316666666666663,68.221618357487927,4,29.225004014613198,4.3110844469540197,1031,null,"n",68.221618357487927,4,null,null,0.51776872329552637,38.996614342874729,null,7,4,29.225004014613198,4.3110844469540197,null,null,64,47,null,{"$f":"(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE))","v":80}]
["Gearhart","More Mischief",null,null,"Beneteau 285",144,{"$f":"193+6","v":199},214,"",0.89766606822262118,{"$f":"IF($AK17>0,(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK17>0,(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""},{"$f":"IF(AK17>0,(K17+L17/60)-A$3,\" \")","v":" "},"","","","","",null,"n","","",null,null,"","",null,9,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Johnson","Felicite",null,null,"S-2 27 IB",13,{"$f":"188+6","v":194},209,"",0.90171325518485124,{"$f":"IF($AK18>0,(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK18>0,(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"n","","",null,null,"","",null,10,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Conover","Willaway",null,null,"Columbia 29",222,{"$f":"225+6","v":231},246,"",0.87260034904013961,{"$f":"IF($AK19>0,(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK19>0,(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"n","","",null,null,"","",null,11,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Gillespie","ie ie bang bang",null,null,"Hunter 365",8,{"$f":"139+3+3+3","v":148},{"$f":"IFERROR(G20+15,\"\")","v":163},"",0.94073377234242705,{"$f":"IF($AK20>0,(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK20>0,(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"n","","",null,null,"","",null,12,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Short","Te Aroha",null,null,"Beneteau 285",285,199,{"$f":"IFERROR(G21+15,\"\")","v":214},{"$f":"IF(T21 = \"s\",1000/(900+G21),\"\")","v":""},{"$f":"IF(T21 =\"n\",1000/(900+H21),\"\")","v":0.89766606822262118},{"$f":"IF($AK21>0,(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK21>0,(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""},{"$f":"IF(AK21>0,(K21+L21/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U21,\" \")","v":""},{"$f":"IFERROR(V21,\" \")","v":""},{"$f":"IFERROR(N21-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y21)-900,0),\"\")","v":""},null,"n","","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Gillespie","Kiing Bill",null,null,"San Juan 21",153,251,{"$f":"IFERROR(G22+15,\"\")","v":266},null,0.85763293310463118,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,14,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,15,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET THREE & FOUR",null,null,"",null,null,null,null,null,null,null,null,null,null,16,null,null,"",null,null,null,null,null,{"$f":"(VLOOKUP($B24,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,17,null,null,0,null,null,null,null,null,{"$f":"(VLOOKUP($B25,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,18,null,null,0,null,null,null,null,null,{"$f":"(VLOOKUP($B26,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,19,null,null,0,null,null,null,null,null,{"$f":"(VLOOKUP($B27,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FLEET THREE",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]