{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Index sheet","ScoringTemplate","csScore_Example","ScoringAbbreviations"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index sheet","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"2022_CoxSpragueCalculator_2022-07-25.xlsm"]
[null,{"$f":"csScoreVer()","v":"Cox Sprague Scoring Calculator Version 1.1, July 25, 2022, Witold Gesing"}]
[]
[]
[null,"Sheet index:"]
[null,"ScoringTemplate",{"$f":"INDIRECT(B7&\"!b2\")","v":"Shields Fleet One 2022 Season Race Results to and including 2022 Race Week"}]
[null,"csScore_Example","Cox-Sprague Scoring System Example and Cox-Sprague Table"]
[null,"ScoringAbbreviations","Scoring Abbreviations "]

{"sheet":"ScoringTemplate","index":1,"n_rows":32,"n_cols":38,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,32,4,33],[4,35,4,36],[6,4,6,5],[4,11,4,13],[4,14,4,20],[4,29,4,30],[4,21,4,24]]}
[]
[null,"Shields Fleet One 2022 Season Race Results to and including 2022 Race Week"]
[null,"As of",{"$f":"TODAY()","v":"2022-07-26"}]
[null,null,{"$f":"csScoreVer()","v":"Cox Sprague Scoring Calculator Version 1.1, July 25, 2022, Witold Gesing"},null,null,null,"Spring Series",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer Series"]
[null,null,null,null,null,null,"YRA",null,"YRA","YRA",null,"AYC Independence",null,null,"LYC 123rd Larchmont Race Week",null,null,null,null,null,null,"YRA One Design",null,null,null,"YRA",null,"YRA","YRA","IHYC Classic Yacht",null,"YRA","LYC Finale",null,null,"RC Credits"]
[null,null,null,null,null,"Starters:",{"$f":"COUNTA(G9:G27)-COUNTIF(G9:G27,\"DNS\")-COUNTIF(G9:G27,\"DNC\")","v":6},6,8,5,5,7,7,7,9,9,9,9,9,{"$f":"COUNTA(T9:T27)-COUNTIF(T9:T27,\"DNS\")-COUNTIF(T9:T27,\"DNC\")","v":9},9,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"COUNTA(AJ9:AJ27)-COUNTIF(AJ9:AJ27,\"DNS\")-COUNTIF(AJ9:AJ27,\"DNC\")","v":5},{"$f":"COUNTA(AK9:AK27)-COUNTIF(AK9:AK27,\"DNS\")-COUNTIF(AK9:AK27,\"DNC\")","v":0}]
[null,null,null,{"$f":"COUNTIF($G6:$AH$6,\">0\")","v":15},"Finishers:",null,{"$f":"MAX(G9:G24)","v":6},6,8,5,5,7,7,7,9,9,9,9,9,{"$f":"MAX(T9:T24)","v":9},9,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"MAX(AJ9:AJ24)","v":1},{"$f":"MAX(AK9:AK24)","v":0}]
[null,"Sail #","Owners","Starts","Discards**","C-S Score","2022-06-04","2022-06-04","2022-06-11","2022-06-25","2022-06-25","2022-07-02","2022-07-02","2022-07-02","2022-07-16","2022-07-17","2022-07-17","2022-07-23","2022-07-24","2022-07-24","2022-07-24","2022-08-06","2022-08-06","2021-08-07","2021-08-07","2022-08-27","2022-08-27","2022-09-03","2021-08-08","2022-09-10",null,"2022-09-24","2022-10-01","2022-10-01",null,"2021-06-18","2022-08-13"]
[{"$f":"IF(D9<$B$28,\"*\",1+A8)","v":1},25,"Ward Young",{"$f":"COUNTA(G9:AK9)-COUNTIF(G9:AK9,\"DNC\")-COUNTIF(G9:AK9, \"DNS\")","v":10},{"$f":"MIN(INT($B$29*D9/10),3)","v":1},{"$f":"csScore(G9:AH9,$G$6:$AH$6,cst,$G$7:$AH$7,$E9)","v":0.93119266055045868},null,null,null,null,null,5,1,3,2,1,1,2,1,2,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B9","v":25}]
[2,23,"Kurt Weisenfluh",16,1,0.87368421052631584,1,1,1,2,2,1,2,4,7,2,2,3,9,6,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,23]
[3,26,"Karen and Dan Ronan",8,0,0.86092715231788075,null,null,2,null,null,null,null,null,4,7,3,7,3,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[4,176,"Greg Takata / Doug Campbell / Andrew Wertheim",15,1,0.83894736842105266,4,3,5,1,1,2,4,6,1,3,7,5,5,9,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,176]
[5,182,"Skip McGuire",13,1,0.83333333333333337,3,2,3,null,null,4,3,5,6,8,4,1,2,4,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,182]
[6,41,"Tim Sawyer / PJ O'Shea",13,1,0.78192771084337354,null,null,6,4,4,6,7,2,3,9,6,4,4,3,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[7,106,"John Mawe / Doug Millar / Gary Owen",11,1,0.7737003058103975,null,null,null,null,null,3,6,1,5,5,9,8,8,7,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,106]
[8,220,"Dan VanderWoude",13,1,0.76329787234042556,2,5,7,3,3,null,null,null,9,6,8,6,7,5,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,220]
[9,5,"James Lawless IV / Tom O'Brien",16,1,0.69789473684210523,5,6,8,5,5,7,5,7,8,4,5,9,9,8,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,5]
[{"$f":"IF(D18<$B$28,\"*\",1+A17)","v":"*"},231,"Ed Briganti / Owen Turnbull",{"$f":"COUNTA(G18:AK18)-COUNTIF(G18:AK18,\"DNC\")-COUNTIF(G18:AK18, \"DNS\")","v":3},{"$f":"MIN(INT($B$29*D18/10),3)","v":0},0.75,6,4,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,null,null,null,null,{"$f":"B18","v":231}]
["*",142,"Michael Kohler",1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,142]
[{"$f":"IF(D20<$B$28,\"*\",1+#REF!)","v":"*"},16,"Tom Sanford",{"$f":"COUNTA(G20:AK20)-COUNTIF(G20:AK20,\"DNC\")-COUNTIF(G20:AK20, \"DNS\")","v":0},{"$f":"MIN(INT($B$29*D20/10),3)","v":0},0,null,null,null,null,null,null,null,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":"B20","v":16}]
[{"$f":"IF(D21<$B$28,\"*\",1+A20)","v":"*"},49,"Greg Davis",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49]
["*",54,"Neil Meyer",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54]
["*",70,"Roland Schulz",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70]
["*",183,"Shileds Foundation",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,183]
["*",205,"Jonathan Krumeich Fleet #2",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,205]
["*",207,"Tom McManus Fleet #2",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,207]
[]
["*",{"$f":"ROUND((D7)*0.4,0)","v":6}," starts are needed to \"qualify\" (40% of all races)"]
["**",1,"discard for every ten races (3 maximum)",null," ",null," "]
[null,null,null,null,null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"YRA LIS Mid-Sound One Design Race Results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,"LYC 124'th Race Week Results"]

{"sheet":"csScore_Example","index":2,"n_rows":128,"n_cols":26,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Cox-Sprague Scoring System Example and Cox-Sprague Table"]
[null,{"$f":"csScoreVer()","v":"Cox Sprague Scoring Calculator Version 1.1, July 25, 2022, Witold Gesing"}]
[null,{"$f":"TODAY()","v":"2022-07-26"}]
[]
[null,"The Cox-Sprague scoring system is useful for scoring a series of races where the number of boats"]
[null,"varies from race to race as it allows the boats to compete for series prizes without having to enter every race."]
[]
[null,"The Cox-Sprague percentage score for a race series is the total number of points the boat earned in"]
[null,"the series divided by the total number of points it could have earned by placing first in every race it started."]
[]
[null,"For example, if  Boat A places 2nd among 5 boats in one race and 3rd among 4 in another,"]
[null,"then the boat earns 46 out of a possible 52 in the first race and 33 out of a possible 43 in the second."]
[null,"Her Cox-Sprague percentage for the two-races she sailed is (46+33)/(52+43) = 79/95 = 83.16%."]
[]
[null,"Number of Starters",null,null,null,5,4,3,3]
[null,"Number of Finishers",null,null,null,5,4,3,3]
[null,null,"Starts","Discards","csScore","Race 1","Race 2","Race 3","Race 4","Race 5","Race 6","Race 7","Race 8","Race 9","Race 10",null,null,null,null,null,null,null,null,null," "," "]
[null,"Boat A",{"$f":"COUNTA(F19:P19)-COUNTIF(F19:P19,\"DNC\")-COUNTIF(F19:P19, \"DNS\")","v":2},0,{"$f":"csScore(F19:O19,$F$16:$O$16,cst,$F$17:$O$17,$D19)","v":0.83157894736842108},2,3,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,"Boat B",{"$f":"COUNTA(F20:P20)-COUNTIF(F20:P20,\"DNC\")-COUNTIF(F20:P20, \"DNS\")","v":1},0,{"$f":"csScore(F20:O20,$F$16:$O$16,cst,$F$17:$O$17,$D20)","v":0.61538461538461542},"DNF",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[]
[null,"Cox-Sprague Table"]
[true,"Modified: ",true,null,{"$f":"IF(C24,\"'The modified csTable(2,2) = 7; csTable(3,2)=5 and points assigned for Place > 21 = 58-2*LOG10(Place-20)\",\"The 'original' csTable(2,2) = 4; csTable(3,2)=0; Points assigned for Place > 21 = 79 - Place; (negative ponts for Place > 79)\")","v":"'The modified csTable(2,2) = 7; csTable(3,2)=5 and points assigned for Place > 21 = 58-2*LOG10(Place-20)"}]
[false]
[]
[null,null,"Number of Starters"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Place",1,{"$f":"csTable1($B29,C$28,$C$24)","v":0},{"$f":"csTable1($B29,D$28,$C$24)","v":10},31,43,52,60,66,72,76,80,84,87,90,92,94,96,97,{"$f":"csTable1($B29,T$28,$C$24)","v":98},99,100,1]
[null,2,{"$f":"csTable1($B30,C$28,$C$24)","v":0},7,25,37,46,54,{"$f":"csTable1($B30,I$28,$C$24)","v":60},66,70,74,78,81,84,86,88,90,91,92,93,94,2]
[null,3,0,5,21,33,42,50,56,62,66,70,74,77,80,82,84,86,87,88,89,90,3]
[null,4,0,0,17,29,38,46,52,58,62,66,70,73,76,78,80,82,83,84,85,86,4]
[null,5,0,0,0,26,35,43,49,55,59,63,67,70,73,75,77,79,80,81,82,83,5]
[null,6,0,0,0,0,32,40,46,52,56,60,64,67,70,72,74,76,77,78,79,80,6]
[null,7,0,0,0,0,0,38,44,50,54,58,62,65,68,70,72,74,75,76,77,78,7]
[null,8,0,0,0,0,0,0,42,48,52,56,60,63,66,68,70,72,73,74,75,76,8]
[null,9,0,0,0,0,0,0,0,46,50,54,58,61,64,66,68,70,71,72,73,74,9]
[null,10,0,0,0,0,0,0,0,0,48,52,56,59,62,64,66,68,69,70,71,72,10]
[null,11,0,0,0,0,0,0,0,0,0,50,54,57,60,62,64,66,67,68,69,70,11]
[null,12,0,0,0,0,0,0,0,0,0,0,52,55,58,60,62,64,65,66,67,68,12]
[null,13,0,0,0,0,0,0,0,0,0,0,0,53,56,58,60,62,63,64,65,66,13]
[null,14,0,0,0,0,0,0,0,0,0,0,0,0,55,57,59,61,62,63,64,65,14]
[null,15,0,0,0,0,0,0,0,0,0,0,0,0,0,56,58,60,61,62,63,64,15]
[null,16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,57,59,{"$f":"csTable1($B44,S$28,$C$24)","v":60},61,62,63,16]
[null,17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,58,59,60,61,62,17]
[null,18,{"$f":"csTable1($B46,C$28,$C$24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,58,59,60,61,18]
[null,19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,58,59,60,19]
[null,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,58,59,20]
[null,21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,58,21]
[null,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,57.397940008672037,22]
[null,23,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,57.045757490560675,23]
[null,24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56.795880017344075,24]
[null,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56.602059991327963,25]
[null,26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"csTable1($B54,V$28,$C$24)","v":56.443697499232712},26]
[null,27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56.309803919971486,27]
[null,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56.193820026016112,28]
[null,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56.09151498112135,29]
[null,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56,30]
[null,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.917214629683549,31]
[null,32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"csTable1($B60,S$28,$C$24)","v":0},0,0,55.84163750790475,32]
[null,33,0,0,0,0,{"$f":"csTable1($B61,G$28,$C$24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.772113295386326,33]
[null,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.707743928643524,34]
[null,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.647817481888637,35]
[null,36,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.59176003468815,36]
[null,37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.539102157243455,37]
[null,38,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.489454989793387,38]
[null,39,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.442492798094342,39]
[null,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.397940008672037,40]
[null,41,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.355561410532161,41]
[null,42,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.315154638355587,42]
[null,43,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.276544327964814,43]
[null,44,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.239577516576787,44]
[null,45,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.204119982655925,45]
[null,46,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.170053304058364,46]
[null,47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.137272471682024,47]
[null,48,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.105683937315561,48]
[null,49,0,0,0,{"$f":"csTable1($B77,F$28,$C$24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.075204004202085,49]
[null,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.045757490560675,50]
[null,51,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55.017276612331457,51]
[null,52,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.989700043360187,52]
[null,53,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.962972120244224,53]
[null,54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.937042165915493,54]
[null,55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.911863911299449,55]
[null,56,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.887394998465425,56]
[null,57,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.86359655186601,57]
[null,58,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.84043280676638,58]
[null,59,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.817870785947001,59]
[null,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.795880017344075,60]
[null,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.774432286560533,61]
[null,62,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.753501419204198,62]
[null,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.733063088840829,63]
[null,64,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.713094647027624,64]
[null,65,0,0,{"$f":"csTable1($B93,E$28,$C$24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.693574972449312,65]
[null,66,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.674484336636851,66]
[null,67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.655804284128564,67]
[null,68,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.637517525248825,68]
[null,69,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.619607839942972,69]
[null,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.602059991327963,70]
[null,71,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.58485964780413,71]
[null,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.567993312730401,72]
[null,73,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.551448260798423,73]
[null,74,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.535212480354062,74]
[null,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.519274621011512,75]
[null,76,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.503623945987599,76]
[null,77,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.488250288655017,77]
[null,78,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.473144012874123,78]
[null,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.458295976715711,79]
[null,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.443697499232712,80]
[null,81,0,{"$f":"csTable1($B109,D$28,$C$24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.429340329978466,81]
[null,82,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.415216621003495,82]
[null,83,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.401318901092836,83]
[null,84,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.387640052032225,84]
[null,85,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.374173286714289,85]
[null,86,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.360912128916262,86]
[null,87,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.347850394598346,87]
[null,88,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.33498217458753,88]
[null,89,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.322301818525489,89]
[null,90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.309803919971486,90]
[null,91,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.297483302561851,91]
[null,92,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.285335007137462,92]
[null,93,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.27335427975909,93]
[null,94,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.261536560538048,94]
[null,95,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"csTable1($B123,V$28,$C$24)","v":54.2498774732166},95]
[null,96,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"csTable1($B124,S$28,$C$24)","v":0},0,0,54.238372815438417,96]
[null,97,{"$f":"csTable1($B125,C$28,$C$24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.227018549655035,97]
[null,98,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.215810794619038,98]
[null,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.204745817419116,99]
[null,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54.193820026016112,100]

{"sheet":"ScoringAbbreviations","index":3,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Scoring Abbreviations "]
[null,"from Appendix A10 of the 2021-2024 Racing Rules of Sailing"]
[]
[null,"Under the Cox-Sprague system the following are scored as number of starters + 1:"]
[null,null,"DNF Did not finish"]
[null,null,"RET Retired "]
[null,null,"DSQ Disqualification"]
[null,null,"OCS Did not start; on the course side of the starting line at her starting signal and failed to start,"]
[null,null,"BFD Disqualification under rule 30.4 (Black Flag Rule)"]
[null,null,"UFD Disqualification under rule 30.3 (U Flag Rule)"]
[]
[null,"The following are scored as number of starters + 1 and are not excludable:"]
[null,null,"DNE  Disqualification (other than DGM) not excludable under rule 90.3(b) "]
[null,null,"DGM  Disqualification for gross misconduct not excludable under 90.3(b) "]
[]
[null,"The following are not scored:"]
[null,null,"DNC Did not compete; did not come to the starting area "]
[null,null,"DNS Did not start (other than DNC and OCS)"]
[]
[null,"If nFinishersVector is provided,"]
[null,null,"TLE (Time Limit Expired) is scored as number of finishers + 2 but not worse than DNF,"]
[null,null,"otherwise TLE is scored as DNF."]
[]
[null,"For the following abbreviations enter the place assigned by the jury. "]
[null,null,"SCP Scoring Penalty applied"]
[null,null,"RDG Redress given"]
[null,null,"DPI Discretionary penalty imposed"]
[null,null,"ZFP  20% penalty under rule 30.2"]
[null,null,"Fractional finishing places awarded by the jury are interpolated linearly between CS scores."]