{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Sheet1","Winter 2023","Rules","CoxSprague","CS_Table","SKIPPERS","CSG_Functions"],"not_rendered":{"macros":1,"defined_names":6},"unopened":[{"sheet":"CSG_Functions","index":6,"reason":"part_missing"}],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Winter 2023","index":1,"n_rows":42,"n_cols":163,"rows_kept":42,"merged":[[0,0,0,6],[1,0,5,0],[1,1,2,1],[1,2,1,3],[1,5,2,6],[1,7,2,12],[1,13,2,18],[1,19,2,24],[1,25,2,30],[1,31,2,36],[1,37,2,42],[1,43,2,48],[1,49,2,54],[1,55,2,60],[1,61,2,66],[1,67,2,72],[1,73,2,78],[1,79,2,84],[1,85,2,90],[1,91,2,96],[1,97,2,102],[1,103,2,108],[1,109,2,114],[1,115,2,120],[1,121,2,126],[1,127,2,132],[1,133,2,138],[1,139,2,144],[1,145,2,150],[1,151,2,156],[1,157,2,162],[1,163,2,168],[1,169,2,174],[1,175,2,180],[1,181,2,186],[1,187,2,192],[1,193,2,198],[2,2,2,3],[3,2,3,3],[3,5,3,6],[4,1,6,1],[4,2,4,3],[4,5,4,6],[5,2,5,3],[5,5,5,6],[35,1,35,5],[36,2,36,3],[36,5,36,6],[37,5,37,6],[38,2,38,3],[38,5,38,6]]}
["2024 SJPMYC  ⛵ WINTER SERIES "]
["PLACE","🏁","  🚦 HANDICAP GROUPS 🚦 RED / YELLOW / GREEN ",null,{"$f":"SUM(LARGE(E8:E34,{1,2,3,4,5}))","v":420},"DATE",null,"2024-01-04",{"$nulls":5},"2024-01-11",{"$nulls":5},"2024-01-16",{"$nulls":5},"2024-01-18",{"$nulls":5},"2024-01-23",{"$nulls":5},"2024-01-25",{"$nulls":5},"2024-01-30",{"$nulls":5},"2024-02-01",{"$nulls":5},"2024-02-06",{"$nulls":5},"2024-02-08",{"$nulls":5},"2024-02-13",{"$nulls":5},"2024-02-15",{"$nulls":5},"2024-02-20",{"$nulls":5},"2024-02-22",{"$nulls":5},"2024-02-27",{"$nulls":5},"2024-02-29",{"$nulls":5},"2024-03-05",{"$nulls":5},"2024-03-07",{"$nulls":5},"2024-03-12",{"$nulls":5},"2024-03-19",{"$nulls":5},"2024-03-21",{"$nulls":5},"2024-03-26",{"$nulls":5}," ",{"$nulls":5}," ",{"$nulls":5}," ",{"$nulls":5}," "]
[null,null,"⏳ 30 SECOND HEADSTART ⏳",null,"TOTAL RACES"]
[null,"🚫"," ⏳ 15 SECOND HEADSTART  ⏳",null,{"$f":"COUNT($H4:EZ4)","v":132},"RACE",null,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6]
[null," Qualification ","🔔  SCRATCH   🔔",null,{"$f":"AVERAGE(E2)/5","v":84},"# of Starters per Heat",null,5,5,5,5,5,5,7,7,7,7,7,7,3,3,{"$nulls":4},5,5,4,5,5,5,4,4,4,4,4,4,5,5,5,5,5,5,9,11,12,10,9,8,4,4,4,4,4,4,4,5,5,5,4,4,6,6,6,6,7,6,6,6,4,6,5,5,4,4,4,4,4,4,6,6,6,5,5,5,4,4,4,4,4,4,5,5,5,5,null,null,7,6,7,7,7,7,7,7,5,5,5,5,7,7,7,6,7,7,7,8,7,6,6,6,6,6,5,5,5,5,4,5,5,4,4,4,5,5,5,5,4,4]
[null,null,"DNF : DID NOT FINISH                                  0 : RACE OFFICIAL ",null,{"$f":"E5/2","v":42},"# of Starts                     to Qualify",null,{"$f":"IF(COUNTA(H8:H34)=0,\"\",COUNTA(H8:H34))","v":5},5,5,5,5,5,7,7,7,7,7,7,3,3,"","","","",5,5,4,5,5,5,5,4,4,4,4,4,5,5,{"$f":"IF(COUNTA(AN8:AN34)=0,\"\",COUNTA(AN8:AN34))","v":5},5,5,5,9,11,12,10,9,8,4,4,4,4,4,4,4,5,5,5,4,4,6,6,6,6,7,6,6,6,4,6,{"$f":"IF(COUNTA(BT8:BT34)=0,\"\",COUNTA(BT8:BT34))","v":5},5,4,4,4,4,4,4,6,6,6,5,5,5,4,4,4,4,4,4,5,5,5,5,"","",7,6,7,7,7,7,{"$f":"IF(COUNTA(CZ8:CZ34)=0,\"\",COUNTA(CZ8:CZ34))","v":7},7,5,5,5,5,7,7,7,6,7,7,7,8,7,6,6,6,6,6,5,5,5,5,4,5,5,4,4,4,5,5,{"$f":"IF(COUNTA(EF8:EF34)=0,\"\",COUNTA(EF8:EF34))","v":5},5,4,4,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"⛵         Sail #","SKIPPERS","Starts","Discards","C-S Score"]
[1,"🏁","593","Dick Denzler",{"$f":"COUNTA(H8:EC8)","v":114},{"$f":"MIN(INT(E8/10),25)","v":11},{"$f":"C_S_G($H8:EZ8,$H$5:EZ$5,csg_table,$E$4,F8)","v":{"v":0.9262392150228388,"d":"0.9262"}},2,3,1,2,3,2,1,2,1,2,1,2,1,1,{"$nulls":4},1,2,1,2,4,4,1,1,4,2,3,2,{"$nulls":6},9,1,1,1,1,1,1,1,3,1,4,1,3,"dnf",1,1,1,2,1,1,1,1,3,2,3,4,1,1,4,3,4,2,2,4,1,3,4,2,2,2,2,1,1,"DNF",1,1,2,3,1,1,2,1,null,null,3,1,1,1,1,1,1,4,2,4,1,3,1,2,2,5,5,4,3,5,4,1,1,1,2,1,1,1,1,1,2,4,2,2,2,2,1,1,1,1,2,1]
[2,"🏁","810","Charlie  Sweeney",{"$f":"COUNTA(H9:EC9)","v":79},{"$f":"MIN(INT(E9/10),25)","v":7},{"$f":"C_S_G($H9:EZ9,$H$5:EZ$5,csg_table,$E$4,F9)","v":{"v":0.9133777549974372,"d":"0.9134"}},{"$nulls":6},3,3,2,3,3,3,2,2,{"$nulls":4},2,1,2,1,3,1,3,1,4,1,1,1,2,4,2,2,2,1,3,4,2,2,7,5,{"$nulls":6},1,3,2,2,3,1,2,2,3,2,1,1,1,3,3,2,1,1,1,1,1,3,3,4,1,1,1,1,1,"DNF",{"$nulls":30},1,1,7,2,6,3,4,2,2,null,3,2,1,1,1,1,1,1]
[3,"🏁","508","Ken Bates",{"$f":"COUNTA(H10:EC10)","v":63},{"$f":"MIN(INT(E10/10),25)","v":6},{"$f":"C_S_G($H10:EZ10,$H$5:EZ$5,csg_table,$E$4,F10)","v":{"v":0.8659509202453988,"d":"0.8660"}},1,2,3,1,4,1,2,1,7,1,2,4,{"$nulls":6},4,4,null,4,1,3,2,2,3,1,2,3,4,3,3,1,1,2,1,3,11,{"$nulls":15},3,3,4,3,4,4,{"$nulls":24},2,3,1,2,null,null,4,2,3,6,5,2,6,1,1,2,5,5,2,1,3,2,2,2,7,7,6]
[4,"🏁","11","Tony DeFilippis",{"$f":"COUNTA(H11:EC11)","v":77},{"$f":"MIN(INT(E11/10),25)","v":7},{"$f":"C_S_G($H11:EZ11,$H$5:EZ$5,csg_table,$E$4,F11)","v":{"v":0.8229166666666666,"d":"0.8229"}},3,1,4,4,5,4,6,4,3,4,4,5,{"$nulls":18},1,2,5,4,3,5,4,2,9,4,2,6,3,2,2,2,3,3,3,2,4,4,2,4,5,6,2,4,2,5,2,1,4,3,2,2,3,4,4,1,2,1,5,5,3,4,3,2,{"$nulls":12},"dnf",null,2,5,2,6,2,5,3,1,3,2,5,5,1,3,1,5]
[5,"🏁",34,"Steve Stopa",{"$f":"COUNTA(H12:EC12)","v":82},{"$f":"MIN(INT(E12/10),25)","v":8},{"$f":"C_S_G($H12:EZ12,$H$5:EZ$5,csg_table,$E$4,F12)","v":{"v":0.8099929627023223,"d":"0.8100"}},4,4,2,5,1,3,4,5,5,5,5,6,{"$nulls":6},5,3,3,3,2,5,3,4,2,3,4,4,{"$nulls":6},8,5,8,10,8,7,4,3,1,3,1,4,{"$nulls":18},2,3,3,2,4,2,{"$nulls":6},2,3,2,2,4,1,3,2,3,3,null,null,2,4,4,2,4,4,3,2,5,3,4,4,7,6,4,1,3,1,2,3,1,4,3,5,1,4,4,3,2,3,{"$nulls":6},2,4,3,2,4,3]
[6,"🏁",150,"Garrett VanKoughnett",{"$f":"COUNTA(H13:EC13)","v":56},{"$f":"MIN(INT(E13/10),25)","v":5},{"$f":"C_S_G($H13:EZ13,$H$5:EZ$5,csg_table,$E$4,F13)","v":{"v":0.7712294043092522,"d":"0.7712"}},{"$nulls":6},5,6,6,7,7,1,{"$nulls":18},5,5,4,3,5,4,null,8,5,5,5,8,2,4,4,4,2,2,{"$nulls":6},6,5,6,5,6,3,5,2,2,4,3,4,{"$nulls":6},3,3,5,3,4,3,3,1,3,3,1,2,"dnf",5,5,4,{"$nulls":21},4,5,6,4,2,{"$nulls":12},3,2,4,3,3,4]
[7,"🏁","220","Mark Hamer",{"$f":"COUNTA(H14:EC14)","v":68},{"$f":"MIN(INT(E14/10),25)","v":6},{"$f":"C_S_G($H14:EZ14,$H$5:EZ$5,csg_table,$E$4,F14)","v":{"v":0.7580040380732622,"d":"0.7580"}},5,5,5,3,2,5,7,7,4,6,6,7,{"$nulls":6},3,5,4,4,5,2,4,{"$nulls":13},10,{"$nulls":9},4,1,3,3,4,3,4,null,5,6,7,{"$nulls":13},2,4,4,"DNF",null,null,4,2,4,4,3,4,4,4,4,5,null,null,1,3,5,3,3,5,4,"dnf",{"$nulls":4},4,3,5,null,6,6,4,8,2,3,2,6,3,5,null,5,5,5]
[]
[8,"🚫",93,"Dick P ",{"$f":"COUNTA(H16:EC16)","v":12},{"$f":"MIN(INT(E16/10),25)","v":1},{"$f":"C_S_G($H16:EZ16,$H$5:EZ$5,csg_table,$E$4,F16)","v":{"v":0.8563300142247511,"d":"0.8563"}},{"$nulls":30},3,1,1,5,4,3,2,7,4,3,3,3]
[10,"🚫","NN","Bill Proseus",{"$f":"COUNTA(H17:EC17)","v":6},0,{"$f":"C_S_G($H17:EZ17,$H$5:EZ$5,csg_table,$E$4,F17)","v":{"v":0.7705263157894737,"d":"0.7705"}},{"$nulls":36},5,6,7,8,6,2]
[11,"🚫",999,"Tim Leonard",{"$f":"COUNTA(H18:FC18)","v":30},3,{"$f":"C_S_G($H18:EZ18,$H$5:EZ$5,csg_table,$E$4,F18)","v":{"v":0.7672998643147897,"d":"0.7673"}},{"$nulls":102},3,4,7,4,7,7,6,2,3,5,5,4,6,6,5,2,4,4,3,2,3,3,3,3,5,5,5,5,1,2]
[9,"🚫",154,"Karl Thomsen",{"$f":"COUNTA(H19:EC19)","v":21},2,{"$f":"C_S_G($H19:EZ19,$H$5:EZ$5,csg_table,$E$4,F19)","v":{"v":0.7663716814159292,"d":"0.7664"}},{"$nulls":36},6,10,3,7,{"$nulls":15},4,null,null,5,6,4,5,null,5,{"$nulls":32},5,3,4,"dnf",2,1,{"$nulls":19},3,4,4,4,4]
[12,"🚫",60,"Jim Proseus",{"$f":"COUNTA(H20:EC20)","v":6},0,{"$f":"C_S_G($H20:EZ20,$H$5:EZ$5,csg_table,$E$4,F20)","v":{"v":0.7473684210526316,"d":"0.7474"}},{"$nulls":36},7,11,6,6,4,4]
[13,"🚫",714,"Ray Cook",{"$f":"COUNTA(H21:EC21)","v":23},2,{"$f":"C_S_G($H21:EZ21,$H$5:EZ$5,csg_table,$E$4,F21)","v":{"v":0.7388704318936877,"d":"0.7389"}},{"$nulls":90},6,6,6,4,6,3,7,"dnf",{"$nulls":4},6,7,6,6,4,3,5,6,{"$nulls":4},5,3,3,4,null,null,4,5,"dnf",{"$nulls":3},4,3,2,4]
[14,"🚫",969,"Duane Stewart",{"$f":"COUNTA(H22:EC22)","v":23},2,{"$f":"C_S_G($H22:EZ22,$H$5:EZ$5,csg_table,$E$4,F22)","v":{"v":0.6815336463223787,"d":"0.6815"}},{"$nulls":37},9,12,9,9,{"$nulls":8},4,5,5,{"$nulls":8},6,6,null,6,5,5,{"$nulls":6},6,6,6,null,5,4,{"$nulls":12},5,5,7,7,7,7]
[15,"🚫",93,"Bob Murphy",{"$f":"COUNTA(H23:EC23)","v":2},0,{"$f":"C_S_G($H23:EZ23,$H$5:EZ$5,csg_table,$E$4,F23)","v":{"v":0.6774193548387096,"d":"0.6774"}},{"$nulls":12},3,3]
[null,"🚫","46","Ron Hawkins",{"$f":"COUNTA(H24:EC24)","v":0},{"$f":"MIN(INT(E24/10),25)","v":0},{"$f":"C_S_G($H24:EZ24,$H$5:EZ$5,csg_table,$E$4,F24)","v":0}]
[null,"🚫",345,"Jay Schach",0,0,{"$f":"C_S_G($H25:EZ25,$H$5:EZ$5,csg_table,$E$4,F25)","v":0}]
[null,"🚫",25,"Gerry Ryerson",0,0,{"$f":"C_S_G($H26:EZ26,$H$5:EZ$5,csg_table,$E$4,F26)","v":0}]
[null,"🚫",999,"Mike Haase",0,0,{"$f":"C_S_G($H27:EZ27,$H$5:EZ$5,csg_table,$E$4,F27)","v":0}]
[null,"🚫",108,"Dan Deets",0,0,{"$f":"C_S_G($H28:EZ28,$H$5:EZ$5,csg_table,$E$4,F28)","v":0}]
[null,"🚫",5,"Harri Beutler",0,0,{"$f":"C_S_G($H29:EZ29,$H$5:EZ$5,csg_table,$E$4,F29)","v":0}]
[null,"🚫",null,null,0,0,{"$f":"C_S_G($H30:EZ30,$H$5:EZ$5,csg_table,$E$4,F30)","v":0}]
[null,"🚫",null,null,0,{"$f":"MIN(INT(E31/10),25)","v":0},{"$f":"C_S_G($H31:EZ31,$H$5:EZ$5,csg_table,$E$4,F31)","v":0}]
[null,"🚫",null,null,0,{"$f":"MIN(INT(E32/10),25)","v":0},{"$f":"C_S_G($H32:EZ32,$H$5:EZ$5,csg_table,$E$4,F32)","v":0}]
[null,"🚫",null,null,0,0,{"$f":"C_S_G($H33:EZ33,$H$5:EZ$5,csg_table,$E$4,F33)","v":0}]
[null,"🚫",null,null,0,0,{"$f":"C_S_G($H34:EZ34,$H$5:EZ$5,csg_table,$E$4,F34)","v":0}]
[null,null," "," "]
[null,"ONE DISCARD EVERY TEN RACES"]
[null,"🏁"]
[null,"🚫"]
[]
[null,"DNF"]
[]
[null,"E"]

{"sheet":"Rules","index":2,"n_rows":37,"n_cols":2,"rows_kept":37}
[]
[]
["Scoring:"]
[null,"SJPMYC uses the Cox-Sprague system with the table given in the CS_Table tab of this workbook. This table differs from the YRA Year book table in the score assigned to the boat that finishes second in a two boat race, the scores assigned to boats that finish 21st or higher and the boats that are disqualified or do not finish."]
[]
[]
[]
[]
[]
["Qualification:","The owner must start at least 50% ofthe races, but not less than 10, designated by each fleet from the Schedule."]
["Throw Outs:","1 after 10 starts; 2 after 20 starts, 3 after 30 starts"]
["Scoring:","Cox/Sprague"]
[]
[]
[]
[]
["Qualification:","AVG OF TOP 5 SKIPPERS STARTS starts on SERIES schedule."]
["Throw Outs:","1 after 10 starts; 2 after 20 starts, 3 after 30"]
["Scoring:","Cox/Sprague"]
[]
[]
["Spring Series "]
[]
["Qualification:","50% of starts on YRA schedule prior to the LYC Race Week"]
["Throw Outs:","1 after 10 starts; 2 after 20 starts"]
["Scoring:","Cox/Sprague"]
[]
[]
["Summer Series","All the races on the SJPMYC scheduleand all the Saturday YRA races with exception of the Crew Race on Sept 22, 2007."]
[]
["Qualification:","50% of starts on SERIES schedule, not counting the races in the NOOD regatta"]
["Throw Outs:","1 after 10 starts; 2 after 20 starts"]
["Scoring:","Cox/Sprague"]
[]
[]
[]
["Qualification:  ","The series consists of the QUATERLY RACING."]

{"sheet":"CoxSprague","index":3,"n_rows":315,"n_cols":22,"rows_kept":315}
["Cox Sprague Scoring Program"]
[]
["This program computes a series score for a yacht participating in a series"]
[" of n races with m discards using the modified Cox-Sprague Scoring System."]
[]
[" Proprietary Notice:"]
[]
[" This software was developed by Witold Gesing."]
[" This software may be copied and re-distributed freely."]
[" To protect the innocent, please clearly identify and document any changes, improvements, modifications or additions."]
[]
["Modified Cox-Sprague Scoring System:"]
[]
["In each race the number of starters will determine the column to be used in the table below, and each boat will be credited "]
["with the number of points indicated for her finishing place. A boat's series score shall be her \"Percentage of Perfection\" calculated by dividing"]
["her total points scored by the total points she would have had, had she won every race in which she started. A boat which does not finish"]
["or is disqualified in a race shall receive a score for the place one greater than the number of starters in that race using the next "]
["column in the table to determine the number of points."]
[]
["Discards:"]
[]
["If one of the results is to be discarded in computing the boat's series score, the race result whose removal results in the"]
["greatest improvement in the resulting C-S score is discarted and the improved C-S score is returned."]
[" If there is more than one discard, this process is repeated using the remaining race results."]
[]
["Explanation of modifications to the LISYRA Cox-Sprague scoring system:"]
[]
["There are three differences between the modified Cox-Sprague Scoring System and the Cox-Sprague Scoring"]
["system published in the LISYRA handbook:"]
[]
["1) The sub-diagonal of the Cox-Sprague table containing the DNF and DSQ scores is removed. "]
["The DNF and DSQ are awarded a score for a place equal to the number of starters plus one "]
["obtained from the column of the CSG table for number of starters plus one.  This change was"]
["made for consistency with the current SJPMYC scoring systems and is much less punishing"]
["for the boats that fail to finish or are disqualified than the original Cox-Sprague system."]
["This change only affects the boats which were disqualified (DSQ, OCS) and the boats that did not finish (DNF)."]
[]
["2) The score for boats that finish worse than 20 is computed using a formula which results in scores ranging from "]
["58.4% for the 21'st place to 54.5% for the 200'th place. "]
[]
[null,"Place",null,null,"Score"]
[null,21,null,null,{"$f":"59-2*LOG(B42-19)","v":{"v":58.39794000867204,"d":"58.4"}}]
[null,22,null,null,{"$f":"59-2*LOG(B43-19)","v":{"v":58.045757490560675,"d":"58.0"}}]
[null,23,null,null,{"v":57.795880017344075,"d":"57.8"}]
[null,24,null,null,{"v":57.60205999132796,"d":"57.6"}]
[null,25,null,null,{"v":57.44369749923271,"d":"57.4"}]
[null,30,null,null,{"v":56.91721462968355,"d":"56.9"}]
[null,40,null,null,{"v":56.35556141053216,"d":"56.4"}]
[null,50,null,null,{"v":56.01727661233146,"d":"56.0"}]
[null,100,null,null,{"v":55.1830299622427,"d":"55.2"}]
[null,200,null,null,{"v":54.48464285026163,"d":"54.5"}]
[]
["This is more in line with the rest of the CS table which assigns scores for the last place"]
[" finish ranging 70% to 59% in races with 20 or fewer boats than the scores assigned "]
["by the LISYRA version in which the 21'st place gets a score of 58% and subsequent scores decrease "]
["by 1% per place. For large fleets this would result in negative scores for boats finishing 80'th or higher."]
["This change only affects races with more than 20 participants."]
[]
["3) The score for a boat that finishes second in a two boat race has been changed from 40% to 70%."]
["This is more consistent with the 67.7% score assigned to a boat that finishes third in a three boat"]
["race and a 59% score assigned to the boat that finishes last in a 20 boat race."]
["This change only affects races with exactly 2 participants."]
[]
["Examples:"]
[]
["Here are some examples of what can go wrong when the uncorrected LISYRA table is used:"]
[]
["The (uncorrected) LISYRA C-S scoring table assigns 40% score to a boat finishing"]
["second in a two boat race. This is a much worse score than any other "]
["in the LISYRA C-S table (for example a boat finishing 20th in a 20 boat race"]
["receives a  score of 59%). As the result of this,"]
["the LISYRA C-S scoring system may result in incorrect ranking of boats if there"]
["are one or more races in which there are only 2 starters."]
[]
["Example 1: "]
[]
[null,"Using LISYRA Cox-Sprague Scoring System",{"$nulls":10},"Using Modified Cox-Sprague Scoring System"]
[]
[null,"LIS YRA",{"$f":"COUNTIF(E79:K79,\">0\")","v":6},null,"Starters:",{"$f":"COUNTA(F81:F84)","v":2},2,2,3,3,3,null,"CSG",{"$f":"COUNTIF(P79:V79,\">0\")","v":6},null,"Starters:",{"$f":"COUNTA(Q81:Q84)","v":2},2,2,3,3,3]
[null,null,"Starts","Discards","C-S Score",{"$nulls":8},"Starts","Discards","C-S Score"]
[null,"Boat A",{"$f":"COUNTA(F81:K81)","v":6},{"$f":"INT(COUNT(F81:K81)/10)","v":0},{"$f":"C_S_G(F81:K81,F79:K79,LISYRA_table,C79,D81)","v":{"v":1,"d":"1.000"}},1,1,1,1,1,1,null,"Boat A",{"$f":"COUNTA(Q81:V81)","v":6},{"$f":"INT(COUNT(Q81:V81)/10)","v":0},{"$f":"C_S_G(Q81:V81,Q79:V79,csg_table,N79,O81)","v":{"v":1,"d":"1.000"}},1,1,1,1,1,1]
[null,"Boat B",{"$f":"COUNTA(F82:K82)","v":3},{"$f":"INT(COUNT(F82:K82)/10)","v":0},{"$f":"C_S_G(F82:K82,F79:K79,LISYRA_table,C79,D82)","v":{"v":0.4,"d":"0.400"}},2,2,2,{"$nulls":4},"Boat B",{"$f":"COUNTA(Q82:V82)","v":3},{"$f":"INT(COUNT(Q82:V82)/10)","v":0},{"$f":"C_S_G(Q82:V82,Q79:V79,csg_table,N79,O82)","v":{"v":0.7,"d":"0.700"}},2,2,2]
[null,"Boat C",{"$f":"COUNTA(F83:K83)","v":3},{"$f":"INT(COUNT(F83:K83)/10)","v":0},{"$f":"C_S_G(F83:K83,F79:K79,LISYRA_table,C79,D83)","v":{"v":0.8064516129032258,"d":"0.806"}},{"$nulls":3},2,2,2,null,"Boat C",{"$f":"COUNTA(Q83:V83)","v":3},{"$f":"INT(COUNT(Q83:V83)/10)","v":0},{"$f":"C_S_G(Q83:V83,Q79:V79,csg_table,N79,O83)","v":{"v":0.8064516129032258,"d":"0.806"}},{"$nulls":3},2,2,2]
[null,"Boat D",{"$f":"COUNTA(F84:K84)","v":3},{"$f":"INT(COUNT(F84:K84)/10)","v":0},{"$f":"C_S_G(F84:K84,F79:K79,LISYRA_table,C79,D84)","v":{"v":0.6774193548387096,"d":"0.677"}},{"$nulls":3},3,3,3,null,"Boat D",{"$f":"COUNTA(Q84:V84)","v":3},{"$f":"INT(COUNT(Q84:V84)/10)","v":0},{"$f":"C_S_G(Q84:V84,Q79:V79,csg_table,N79,O84)","v":{"v":0.6774193548387096,"d":"0.677"}},{"$nulls":3},3,3,3]
[]
["In this example boat B which finishes second in 3 races with 2 starters"]
["receives Cox-Sprague \"percentage-of-perfection\" score of 40%, well behind"]
["boats C and D which finish second and third respectively in three races with"]
["3 starters.  If the 4 points assigned for the second place in a two boat",{"$nulls":15}," "]
["race is changed to 7, Boat B's score would be 70% and the other scores would"]
["be unchanged. This would place Boat B behind Boat C which finished second in"]
["races with three starters and slightly ahead of Boat D which finished last"]
["in these races."]
[]
["Example 2:"]
[]
[null,"Using LISYRA Cox-Sprague Scoring System",{"$nulls":10},"Using Modified Cox-Sprague Scoring System"]
[]
[null,"LISYRA",{"$f":"COUNTIF(E99:K99,\">0\")","v":6},null,"Starters:",{"$f":"COUNTA(F101:F104)","v":2},2,2,4,3,3,null,null,{"$f":"COUNTIF(P99:V99,\">0\")","v":6},null,"Starters:",{"$f":"COUNTA(Q101:Q104)","v":2},2,2,4,3,3]
[null,null,"Starts","Discards","C-S Score",{"$nulls":8},"Starts","Discards","C-S Score"]
[null,"Boat A",{"$f":"COUNTA(F101:K101)","v":6},{"$f":"INT(COUNT(F101:K101)/10)","v":0},{"$f":"C_S_G(F101:K101,F99:K99,LISYRA_table,C99,D101)","v":{"v":1,"d":"1.000"}},1,1,1,1,1,1,null,"Boat A",{"$f":"COUNTA(Q101:V101)","v":6},{"$f":"INT(COUNT(Q101:V101)/10)","v":0},{"$f":"C_S_G(Q101:V101,Q99:V99,csg_table,N99,O101)","v":{"v":1,"d":"1.000"}},1,1,1,1,1,1]
[null,"Boat B",{"$f":"COUNTA(F102:K102)","v":4},{"$f":"INT(COUNT(F102:K102)/10)","v":0},{"$f":"C_S_G(F102:K102,F99:K99,LISYRA_table,C99,D102)","v":{"v":0.6712328767123288,"d":"0.671"}},2,2,2,2,{"$nulls":3},"Boat B",{"$f":"COUNTA(Q102:V102)","v":4},{"$f":"INT(COUNT(Q102:V102)/10)","v":0},{"$f":"C_S_G(Q102:V102,Q99:V99,csg_table,N99,O102)","v":{"v":0.7945205479452054,"d":"0.795"}},2,2,2,2]
[null,"Boat C",{"$f":"COUNTA(F103:K103)","v":3},{"$f":"INT(COUNT(F103:K103)/10)","v":0},{"$f":"C_S_G(F103:K103,F99:K99,LISYRA_table,C99,D103)","v":{"v":0.7904761904761904,"d":"0.790"}},{"$nulls":3},3,2,2,null,"Boat C",{"$f":"COUNTA(Q103:V103)","v":3},{"$f":"INT(COUNT(Q103:V103)/10)","v":0},{"$f":"C_S_G(Q103:V103,Q99:V99,csg_table,N99,O103)","v":{"v":0.7904761904761904,"d":"0.790"}},{"$nulls":3},3,2,2]
[null,"Boat D",{"$f":"COUNTA(F104:K104)","v":3},{"$f":"INT(COUNT(F104:K104)/10)","v":0},{"$f":"C_S_G(F104:K104,F99:K99,LISYRA_table,C99,D104)","v":{"v":0.6761904761904762,"d":"0.676"}},{"$nulls":3},4,3,3,null,"Boat D",{"$f":"COUNTA(Q104:V104)","v":3},{"$f":"INT(COUNT(Q104:V104)/10)","v":0},{"$f":"C_S_G(Q104:V104,Q99:V99,csg_table,N99,O104)","v":{"v":0.6761904761904762,"d":"0.676"}},{"$nulls":3},4,3,3]
[]
["In this example Boat B manages to sail in one more race and finishes true to"]
["form second, beating boats C and D in the process. We now have a situation"]
["in which Boat B with four  second place finishes is ranked behind not only"]
["Boat C which has 3,2 and 2 but also behind the hapless boat D which always"]
["finishes last. With the suggested correction boat B's score changes to 79.5%"]
["and as before the other scores are not affected, resulting in a more",{"$nulls":3}," "]
["intuitive ranking {A,B,C,D}, with B and C virtually tied for second."]
[]
["Example 3."]
[]
["This example is added to illustrate how ties are broken"]
["between boats with identical results. "]
[]
[null,"Using LISYRA Cox-Sprague Scoring System",{"$nulls":10},"Using Modified Cox-Sprague Scoring System"]
[]
[null,"LISYRA",{"$f":"COUNTIF(E121:K121,\">0\")","v":6},null,"Starters:",{"$f":"COUNTA(F123:F126)","v":2},2,2,4,3,2,null,null,{"$f":"COUNTIF(P121:V121,\">0\")","v":6},null,"Starters:",{"$f":"COUNTA(Q123:Q126)","v":2},2,2,4,3,2]
[null,null,"Starts","Discards","C-S Score",{"$nulls":8},"Starts","Discards","C-S Score"]
[null,"Boat A",{"$f":"COUNTA(F123:K123)","v":5},{"$f":"INT(COUNT(F123:K123)/10)","v":0},{"$f":"C_S_G(F123:K123,F121:K121,LISYRA_table,C121,D123)","v":{"v":0.8554216867469879,"d":"0.855"}},1,2,1,2,null,1,null,"Boat A",{"$f":"COUNTA(Q123:V123)","v":5},{"$f":"INT(COUNT(Q123:V123)/10)","v":0},{"$f":"C_S_G(Q123:V123,Q121:V121,csg_table,N121,O123)","v":{"v":0.891566265060241,"d":"0.892"}},1,2,1,2,null,1]
[null,"Boat B",{"$f":"COUNTA(F124:K124)","v":5},{"$f":"INT(COUNT(F124:K124)/10)","v":0},{"$f":"C_S_G(F124:K124,F121:K121,LISYRA_table,C121,D124)","v":{"v":0.8846153846153846,"d":"0.885"}},2,1,2,1,1,null,null,"Boat B",{"$f":"COUNTA(Q124:V124)","v":5},{"$f":"INT(COUNT(Q124:V124)/10)","v":0},{"$f":"C_S_G(Q124:V124,Q121:V121,csg_table,N121,O124)","v":{"v":0.9423076923076923,"d":"0.942"}},2,1,2,1,1]
[null,"Boat C",{"$f":"COUNTA(F125:K125)","v":3},{"$f":"INT(COUNT(F125:K125)/10)","v":0},{"$f":"C_S_G(F125:K125,F121:K121,LISYRA_table,C121,D125)","v":{"v":0.6428571428571429,"d":"0.643"}},{"$nulls":3},4,3,2,null,"Boat C",{"$f":"COUNTA(Q125:V125)","v":3},{"$f":"INT(COUNT(Q125:V125)/10)","v":0},{"$f":"C_S_G(Q125:V125,Q121:V121,csg_table,N121,O125)","v":{"v":0.6785714285714286,"d":"0.679"}},{"$nulls":3},4,3,2]
[null,"Boat D",{"$f":"COUNTA(F126:K126)","v":2},{"$f":"INT(COUNT(F126:K126)/10)","v":0},{"$f":"C_S_G(F126:K126,F121:K121,LISYRA_table,C121,D126)","v":{"v":0.7837837837837838,"d":"0.784"}},{"$nulls":3},3,2,null,null,"Boat D",{"$f":"COUNTA(Q126:V126)","v":2},{"$f":"INT(COUNT(Q126:V126)/10)","v":0},{"$f":"C_S_G(Q126:V126,Q121:V121,csg_table,N121,O126)","v":{"v":0.7837837837837838,"d":"0.784"}},{"$nulls":3},3,2]
[]
[]
["Here A and B have identical finishing records of  three firsts and two seconds and under"]
["both systems B is ahead, as she should be, by winning races with more starters."]
[]
["Program Listing"]
[]
["' This program computes a score for a yacht participating in a series"]
["' of n_races with m_discards using the modified Cox-Sprague Scoring System."]
["'"]
["'   C_S_G   Modified Cox-Sprague (Cox-Sprague-Gesing) system"]
["'"]
["' Proprietary Notice:"]
["'"]
["' This software was developed by Witold Gesing."]
["' This software may be copied and re-distributed freely."]
["' To protect the innocent, please clearly identify and document any changes,"]
["' improvements, modifications or additions."]
["'"]
["' Inputs: (To all programs)"]
["'"]
["' results:      a vector of race results:"]
["'                   numbers are scored as finishing places in a race"]
["'                   entries starting with \"d\" of \"D\" are scored as DNF/DSQ"]
["'                   DNE or dne is scored as DSQ and is not excludable (discartable) (Rule 88.3(b))"]
["'                   blank or zero entries are scored as DNS"]
["'                   absolute value of negative entries is used as the score assigned under RDG or SCP (see below for definition of abbreviations)"]
["' n_starters:   a vector containing number of starters in each race"]
["' n_races:      number of races (defaults to Count(n_starters) )"]
["' m_discards:   number of discards (defaults to 0 ). The program discards the race result that results in the greatest improvement of the CS score."]
["' CSG_Table:    Cox-Sprague-Gesing table (20x20 modified CS table)"]
["'"]
["' Outputs:"]
["'"]
["' Total score for a yacht participating in a series of n_races with m_discards:"]
["'"]
["' C_S_G(results,n_starters,CSG_table,n_races,m_discards):   Modified Cox-Sprague score"]
["' G_C_S(results,n_starters,n_races,m_discards):             Gesing-Cox-Sprague score"]
["'"]
["' Abbreviations: (Appendix A of the ISF Racing Rules of Sailing for 2001-2004)"]
["'"]
["' The following are scored as number of starters + 1 using the next column of the C-S table:"]
["'"]
[" DSQ   Disqualified"]
["' DNF   Did not finish"]
[" RAF   Retired after finishing"]
[" OCS   Did not start; on the course side of the starting line"]
["' BFD   Disqualification under rule 30.3 (Black Flag Rule)"]
["' DNE   Disqualification not excludable under rule 88.3(b)"]
[]
["' The following are not counted under the C-S system:"]
[]
["' DNC   Did not compete; did not come to the starting area"]
["' DNS   Did not start; (other than DNC and OCS)"]
[]
["' The following are not implemented:"]
[]
["' SCP   Took a scoring penalty under rule 44.3 (not implemented)"]
["' RDG   Redress given"]
["' ZFP   20% penalty under rule 30.2 (not implemented)"]
["' TLE   Time limit expired (For TLE enter the finishing position as prescribed"]
["'       by the race instructions. YRALIS 2005 race instructions prescribe that"]
["'       TLE is scored by adding 50% of the difference between the number of"]
["'       finishers and starters, truncated if a fraction, to the number of finishers.)"]
[]
[]
["'Explanation of modifications to the LISYRA Cox-Sprague scoring system:"]
[]
["'There are three differences between the modified Cox-Sprague-Gesing Scoring System"]
["' and the Cox-Sprague Scoring system published in the LISYRA handbook:"]
[]
["'1) The sub-diagonal of the Cox-Sprague table containing the DNF and DSQ scores is removed."]
["'   The DNF and DSQ are awarded a score for a place equal to the number of starters plus one"]
["'   obtained from the column of the CSG table for number of starters plus one.  This change was"]
["'   for the boats that fail to finish or are disqualified than the original Cox-Sprague system."]
["'   This change only affects the boats which were disqualified (DSQ/DNF/RAF/OCS/BFD/DNE)."]
[]
["'2) The score for boats that finish worse than 20 is computed using a formula which results in scores ranging from"]
["'   58.4% for the 21'st place to 54.5% for the 200'th place."]
["'   This is more in line with the rest of the CS table which assigns scores for the last place"]
["'   finish ranging 70% to 59% in races with 20 or fewer boats than the scores assigned"]
["'   by the LISYRA version in which the 21'st place gets a score of 58% and subsequent scores decrease"]
["'   by 1% per place. For large fleets this would result in negative scores for boats finishing 80'th or higher."]
["'   This change only affects races with more than 20 participants."]
[]
["'3) The score for a boat that finishes second in a two boat race has been changed from 40% to 70%."]
["'   This is more consistent with the 67.7% score assigned to a boat that finishes third in a three boat"]
["'   race and a 59% score assigned to the boat that finishes last in a 20 boat race."]
["'   This change only affects races with exactly 2 participants."]
[]
["' 2005-10-10: Additional comments added"]
[]
["Option Base 1"]
[]
["Function VER()"]
["        VER = \"Cox_Sprague Scoring System Version 1d, September 26, 2003, Witold Gesing\""]
["        'Changes:"]
["        '2003-09-26: DNF/DSQ/OCS/BDF/RAF scored as n_starters+1 for C_S_G and G_C_S"]
["        '1b: inputs/outputs documented"]
["        '1c: Excess Scoring Systems removed for simplicity"]
["        '2003-09-26: DNS/dns/DNC/dnc not counted"]
["End Function"]
["Function C_S_G(results As Variant, n_starters, CSG_table, Optional n_races, Optional m_discards)"]
[]
["' Cox-Sprague score for from table CSG_table indexed by results(i) and n_starters(i)"]
["' as modified by Witold Gesing"]
["' Witold Gesing, Oct. 19, 1999"]
[]
["    Dim vx() 'vector C-S scores in the nx'th race started (for computing discards)"]
["    Dim vw() 'vector of perfect C-S scores (for computing discards)"]
[]
["    If IsMissing(n_races) Then n_races = Application.Count(n_starters)"]
["    If IsMissing(m_discards) Then m_discards = 0"]
["    "]
["    ReDim vx(n_races)"]
["    ReDim vw(n_races)"]
["        "]
["    xx = 0 ' Initialize running C-S total"]
["    ww = 0 ' Initialize running C-S \"perfect\" total"]
["    nx = 0 ' Initialize counter of races started"]
["       "]
["    For i = 1 To n_races"]
["        r = 0"]
["        c = n_starters(i)"]
["        l = Left(results(i), 1) ' Check for DSQ/DNF/DNE/OCS/BFD/RAF, score as n_starters(i) + 1"]
["        If l = \"D\" Or l = \"d\" Or l = \"O\" Or l = \"o\" Or l = \"B\" Or l = \"b\" Or l = \"R\" Or l = \"r\" Then"]
["            c = c + 1"]
["            r = c"]
["        End If"]
["        "]
["        l = Left(results(i), 3)"]
["        If l = \"DNS\" Or l = \"dns\" Or l = \"DNC\" Or l = \"dnc\" Then 'Do not count DNS/DNC"]
["            r = 0"]
["        End If"]
["                "]
["        If c > 20 Then c = 20"]
["        "]
["        If Application.IsNumber(results(i)) Then r = results(i)"]
["            If r > 0 Then"]
["                If r < 20 Then z = Abs(CSG_table(r, c)) Else z = 59 - 2 * Log(r - 19)"]
["                nx = nx + 1 'counter of races started"]
["                vx(nx) = z 'vector C-S score in the nx'th race started (for computing discards)"]
["                xx = xx + z ' running C-S total"]
["                If (results(i) = \"DNE\" Or results(i) = \"dne\") Then vx(nx) = 0 ' Disqualification not Excludable (setting vx(nx)=0 prevents result of race nx from being discarded)"]
["                z = CSG_table(1, c)"]
["                vw(nx) = z ' vector of perfect C-S scores (for computing discards)"]
["                ww = ww + z ' running C-S \"perfect\" total"]
["            End If 'r > 0"]
["    Next i"]
["    "]
["    If ww > 0 Then cs = xx / ww Else cs = 0"]
["    "]
["'Discards:"]
[]
["'The race result whose removal results in the greates improvement to the"]
["'C-S score cs is discarted and the improved CS score is returned."]
["'This process is repeated if there is more than one discard."]
["'"]
["    If m_discards > nx - 1 Then m_discards = nx - 1"]
["    If m_discards > 0 Then"]
["   "]
["        For j = 1 To m_discards"]
[]
["           For i = 1 To nx"]
["                If vx(i) > 0 Then ' skip if Disqualification Not Exludable (DNE) or if already discarded"]
["                    If (ww - vw(i) > 0) Then"]
["                        csz = (xx - vx(i)) / (ww - vw(i))"]
["                    Else"]
["                        csz = 0"]
["                    End If"]
["                    If csz > cs Then"]
["                        cs = csz"]
["                        im = i"]
["                    End If ' csz > cm"]
["                End If ' vx(i) > 0"]
["           Next i"]
["                      "]
["               xx = xx - vx(im) 'Discard the worst race"]
["               ww = ww - vw(im)"]
["               vx(im) = 0"]
["               vw(im) = 0"]
["           "]
["        Next j"]
["                "]
["    End If 'm_discards > 0"]
["        "]
["    C_S_G = cs"]
["       "]
["End Function"]

{"sheet":"CS_Table","index":4,"n_rows":67,"n_cols":48,"rows_kept":67}
["Fleet 1 Season Scoring "]
[]
["A boat must participate in 50% of races for her score to be considered for the Season Championship."]
["A boat will be allowed to discard one off her starts for every 10 races sailed to the maximum of 3."]
["Any boat that crosses the starting line then withdraws is scored one point worse than the number of starters."]
[]
[]
["Cox-Sprague Scoring System "]
[]
["Cox-Sprague scoring system recommended by SJPMYC of L.I.S, modified as described below will be used."]
[]
["In each race the number of starters will determine the column to be used in the table below, and each boat will be credited "]
["with the number of points indicated for her finishing place. A boat's series score shall be her \"Percentage of Perfection\" calculated by dividing"]
["her total points scored by the total points she would have had, had she won every race in which she started. A boat which does not finish"]
[" or is disqualified in a race shall receive a score for the place one greater than the number of starters in that race using the next "]
["column in the table to determine the number of points."]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,"20 or more",{"$nulls":6},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,"20 or more"]
[1,0,10,31,43,52,60,66,72,76,80,84,87,90,92,94,96,97,98,99,100,1,{"$nulls":4},1,0,{"$f":"C19/C$19","v":{"v":1,"d":"100.0%"}},{"$f":"D19/D$19","v":{"v":1,"d":"100.0%"}},{"$f":"E19/E$19","v":{"v":1,"d":"100.0%"}},{"$f":"F19/F$19","v":{"v":1,"d":"100.0%"}},{"$f":"G19/G$19","v":{"v":1,"d":"100.0%"}},{"$f":"H19/H$19","v":{"v":1,"d":"100.0%"}},{"$f":"I19/I$19","v":{"v":1,"d":"100.0%"}},{"$f":"J19/J$19","v":{"v":1,"d":"100.0%"}},{"$f":"K19/K$19","v":{"v":1,"d":"100.0%"}},{"$f":"L19/L$19","v":{"v":1,"d":"100.0%"}},{"$f":"M19/M$19","v":{"v":1,"d":"100.0%"}},{"$f":"N19/N$19","v":{"v":1,"d":"100.0%"}},{"$f":"O19/O$19","v":{"v":1,"d":"100.0%"}},{"$f":"P19/P$19","v":{"v":1,"d":"100.0%"}},{"$f":"Q19/Q$19","v":{"v":1,"d":"100.0%"}},{"$f":"R19/R$19","v":{"v":1,"d":"100.0%"}},{"$f":"S19/S$19","v":{"v":1,"d":"100.0%"}},{"$f":"T19/T$19","v":{"v":1,"d":"100.0%"}},{"$f":"U19/U$19","v":{"v":1,"d":"100.0%"}},1]
[2,null,7,25,37,46,54,60,66,70,74,78,81,84,86,88,90,91,92,93,94,2,{"$nulls":4},2,null,{"$f":"C20/C$19","v":{"v":0.7,"d":"70.0%"}},{"v":0.8064516129032258,"d":"80.6%"},{"v":0.8604651162790697,"d":"86.0%"},{"v":0.8846153846153846,"d":"88.5%"},{"v":0.9,"d":"90.0%"},{"v":0.9090909090909091,"d":"90.9%"},{"v":0.9166666666666666,"d":"91.7%"},{"v":0.9210526315789473,"d":"92.1%"},{"v":0.925,"d":"92.5%"},{"v":0.9285714285714286,"d":"92.9%"},{"v":0.9310344827586207,"d":"93.1%"},{"v":0.9333333333333333,"d":"93.3%"},{"v":0.9347826086956522,"d":"93.5%"},{"v":0.9361702127659575,"d":"93.6%"},{"v":0.9375,"d":"93.8%"},{"v":0.9381443298969072,"d":"93.8%"},{"v":0.9387755102040817,"d":"93.9%"},{"v":0.9393939393939394,"d":"93.9%"},{"v":0.94,"d":"94.0%"},2]
[3,null,null,21,33,42,50,56,62,66,70,74,77,80,82,84,86,87,88,89,90,3,{"$nulls":4},3,null,{"v":0,"d":"0.0%"},{"v":0.6774193548387096,"d":"67.7%"},{"v":0.7674418604651163,"d":"76.7%"},{"v":0.8076923076923077,"d":"80.8%"},{"v":0.8333333333333334,"d":"83.3%"},{"v":0.8484848484848485,"d":"84.8%"},{"v":0.8611111111111112,"d":"86.1%"},{"v":0.868421052631579,"d":"86.8%"},{"v":0.875,"d":"87.5%"},{"v":0.8809523809523809,"d":"88.1%"},{"v":0.8850574712643678,"d":"88.5%"},{"v":0.8888888888888888,"d":"88.9%"},{"v":0.8913043478260869,"d":"89.1%"},{"v":0.8936170212765957,"d":"89.4%"},{"v":0.8958333333333334,"d":"89.6%"},{"v":0.8969072164948454,"d":"89.7%"},{"v":0.8979591836734694,"d":"89.8%"},{"v":0.898989898989899,"d":"89.9%"},{"v":0.9,"d":"90.0%"},3]
[4,{"$nulls":3},29,38,46,52,58,62,68,70,73,76,78,80,82,83,84,85,86,4,{"$nulls":4},4,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6744186046511628,"d":"67.4%"},{"v":0.7307692307692307,"d":"73.1%"},{"v":0.7666666666666667,"d":"76.7%"},{"v":0.7878787878787878,"d":"78.8%"},{"v":0.8055555555555556,"d":"80.6%"},{"v":0.8157894736842105,"d":"81.6%"},{"v":0.85,"d":"85.0%"},{"v":0.8333333333333334,"d":"83.3%"},{"v":0.8390804597701149,"d":"83.9%"},{"v":0.8444444444444444,"d":"84.4%"},{"v":0.8478260869565217,"d":"84.8%"},{"v":0.851063829787234,"d":"85.1%"},{"v":0.8541666666666666,"d":"85.4%"},{"v":0.8556701030927835,"d":"85.6%"},{"v":0.8571428571428571,"d":"85.7%"},{"v":0.8585858585858586,"d":"85.9%"},{"v":0.86,"d":"86.0%"},4]
[5,{"$nulls":4},35,43,49,55,59,63,67,70,73,75,77,79,80,81,82,83,5,{"$nulls":4},5,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6730769230769231,"d":"67.3%"},{"v":0.7166666666666667,"d":"71.7%"},{"v":0.7424242424242424,"d":"74.2%"},{"v":0.7638888888888888,"d":"76.4%"},{"v":0.7763157894736842,"d":"77.6%"},{"v":0.7875,"d":"78.8%"},{"v":0.7976190476190477,"d":"79.8%"},{"v":0.8045977011494253,"d":"80.5%"},{"v":0.8111111111111111,"d":"81.1%"},{"v":0.8152173913043478,"d":"81.5%"},{"v":0.8191489361702128,"d":"81.9%"},{"v":0.8229166666666666,"d":"82.3%"},{"v":0.8247422680412371,"d":"82.5%"},{"v":0.826530612244898,"d":"82.7%"},{"v":0.8282828282828283,"d":"82.8%"},{"v":0.83,"d":"83.0%"},5]
[6,{"$nulls":5},40,46,52,56,60,64,67,70,72,74,76,77,78,79,80,6,{"$nulls":4},6,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6666666666666666,"d":"66.7%"},{"v":0.696969696969697,"d":"69.7%"},{"v":0.7222222222222222,"d":"72.2%"},{"v":0.7368421052631579,"d":"73.7%"},{"v":0.75,"d":"75.0%"},{"v":0.7619047619047619,"d":"76.2%"},{"v":0.7701149425287356,"d":"77.0%"},{"v":0.7777777777777778,"d":"77.8%"},{"v":0.782608695652174,"d":"78.3%"},{"v":0.7872340425531915,"d":"78.7%"},{"v":0.7916666666666666,"d":"79.2%"},{"v":0.7938144329896907,"d":"79.4%"},{"v":0.7959183673469388,"d":"79.6%"},{"v":0.797979797979798,"d":"79.8%"},{"v":0.8,"d":"80.0%"},6]
[7,{"$nulls":6},44,50,54,58,62,65,68,70,72,74,75,76,77,78,7,{"$nulls":4},7,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6666666666666666,"d":"66.7%"},{"v":0.6944444444444444,"d":"69.4%"},{"v":0.7105263157894737,"d":"71.1%"},{"v":0.725,"d":"72.5%"},{"v":0.7380952380952381,"d":"73.8%"},{"v":0.7471264367816092,"d":"74.7%"},{"v":0.7555555555555555,"d":"75.6%"},{"v":0.7608695652173914,"d":"76.1%"},{"v":0.7659574468085106,"d":"76.6%"},{"v":0.7708333333333334,"d":"77.1%"},{"v":0.7731958762886598,"d":"77.3%"},{"v":0.7755102040816326,"d":"77.6%"},{"v":0.7777777777777778,"d":"77.8%"},{"v":0.78,"d":"78.0%"},7]
[8,{"$nulls":7},48,52,56,60,63,66,68,70,72,73,74,75,76,8,null,null," ",null,8,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6666666666666666,"d":"66.7%"},{"v":0.6842105263157895,"d":"68.4%"},{"v":0.7,"d":"70.0%"},{"v":0.7142857142857143,"d":"71.4%"},{"v":0.7241379310344828,"d":"72.4%"},{"v":0.7333333333333333,"d":"73.3%"},{"v":0.7391304347826086,"d":"73.9%"},{"v":0.7446808510638298,"d":"74.5%"},{"v":0.75,"d":"75.0%"},{"v":0.7525773195876289,"d":"75.3%"},{"v":0.7551020408163265,"d":"75.5%"},{"v":0.7575757575757576,"d":"75.8%"},{"v":0.76,"d":"76.0%"},8]
[9,{"$nulls":8},50,54,58,61,64,66,68,70,71,72,73,74,9,{"$nulls":4},9,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6578947368421053,"d":"65.8%"},{"v":0.675,"d":"67.5%"},{"v":0.6904761904761905,"d":"69.0%"},{"v":0.7011494252873564,"d":"70.1%"},{"v":0.7111111111111111,"d":"71.1%"},{"v":0.717391304347826,"d":"71.7%"},{"v":0.723404255319149,"d":"72.3%"},{"v":0.7291666666666666,"d":"72.9%"},{"v":0.7319587628865979,"d":"73.2%"},{"v":0.7346938775510204,"d":"73.5%"},{"v":0.7373737373737373,"d":"73.7%"},{"v":0.74,"d":"74.0%"},9]
[10,{"$nulls":9},52,56,59,62,64,66,68,69,70,71,72,10,{"$nulls":4},10,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.65,"d":"65.00%"},{"v":0.6666666666666666,"d":"66.7%"},{"v":0.6781609195402298,"d":"67.8%"},{"v":0.6888888888888889,"d":"68.9%"},{"v":0.6956521739130435,"d":"69.6%"},{"v":0.7021276595744681,"d":"70.2%"},{"v":0.7083333333333334,"d":"70.8%"},{"v":0.711340206185567,"d":"71.1%"},{"v":0.7142857142857143,"d":"71.4%"},{"v":0.7171717171717171,"d":"71.7%"},{"v":0.72,"d":"72.0%"},10]
[11,{"$nulls":10},54,57,60,62,64,66,67,68,69,70,11,{"$nulls":4},11,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6428571428571429,"d":"64.3%"},{"v":0.6551724137931034,"d":"65.5%"},{"v":0.6666666666666666,"d":"66.7%"},{"v":0.6739130434782609,"d":"67.4%"},{"v":0.6808510638297872,"d":"68.1%"},{"v":0.6875,"d":"68.8%"},{"v":0.6907216494845361,"d":"69.1%"},{"v":0.6938775510204082,"d":"69.4%"},{"v":0.696969696969697,"d":"69.7%"},{"v":0.7,"d":"70.0%"},11]
[12,{"$nulls":11},55,58,60,62,64,65,66,67,68,12,{"$nulls":4},12,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.632183908045977,"d":"63.2%"},{"v":0.6444444444444445,"d":"64.4%"},{"v":0.6521739130434783,"d":"65.2%"},{"v":0.6595744680851063,"d":"66.0%"},{"v":0.6666666666666666,"d":"66.7%"},{"v":0.6701030927835051,"d":"67.0%"},{"v":0.673469387755102,"d":"67.3%"},{"v":0.6767676767676768,"d":"67.7%"},{"v":0.68,"d":"68.0%"},12]
[13,{"$nulls":12},56,58,60,62,63,64,65,66,13,{"$nulls":4},13,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6222222222222222,"d":"62.2%"},{"v":0.6304347826086957,"d":"63.0%"},{"v":0.6382978723404256,"d":"63.8%"},{"v":0.6458333333333334,"d":"64.6%"},{"v":0.6494845360824743,"d":"64.9%"},{"v":0.6530612244897959,"d":"65.3%"},{"v":0.6565656565656566,"d":"65.7%"},{"v":0.66,"d":"66.0%"},13]
[14,{"$nulls":13},57,59,61,62,63,64,65,14,{"$nulls":4},14,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6195652173913043,"d":"62.0%"},{"v":0.6276595744680851,"d":"62.8%"},{"v":0.6354166666666666,"d":"63.5%"},{"v":0.6391752577319587,"d":"63.9%"},{"v":0.6428571428571429,"d":"64.3%"},{"v":0.6464646464646465,"d":"64.6%"},{"v":0.65,"d":"65.0%"},14]
[15,{"$nulls":14},58,60,61,62,63,64,15,{"$nulls":4},15,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6170212765957447,"d":"61.7%"},{"v":0.625,"d":"62.5%"},{"v":0.6288659793814433,"d":"62.9%"},{"v":0.6326530612244898,"d":"63.3%"},{"v":0.6363636363636364,"d":"63.6%"},{"v":0.64,"d":"64.0%"},15]
[16,{"$nulls":15},59,60,61,62,63,16,{"$nulls":4},16,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6145833333333334,"d":"61.5%"},{"v":0.6185567010309279,"d":"61.9%"},{"v":0.6224489795918368,"d":"62.2%"},{"v":0.6262626262626263,"d":"62.6%"},{"v":0.63,"d":"63.0%"},16]
[17,{"$nulls":16},59,60,61,62,17,{"$nulls":4},17,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6082474226804123,"d":"60.8%"},{"v":0.6122448979591837,"d":"61.2%"},{"v":0.6161616161616161,"d":"61.6%"},{"v":0.62,"d":"62.0%"},17]
[18,{"$nulls":17},59,60,61,18,{"$nulls":4},18,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.6020408163265306,"d":"60.2%"},{"v":0.6060606060606061,"d":"60.6%"},{"v":0.61,"d":"61.0%"},18]
[19,{"$nulls":18},59,60,19,{"$nulls":4},19,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.5959595959595959,"d":"59.6%"},{"v":0.6,"d":"60.0%"},19]
[20,{"$nulls":19},59,20,{"$nulls":4},20,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0.59,"d":"59.0%"},20]
[null,"*","For finishing place n > 20 the points are awarded as follows:",{"$nulls":17},"*","*"]
[]
[{"$nulls":3},"n_points = 59 - 2*log(n-19) "]
[]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,"20 or more"]
[1,0,10,31,43,52,60,66,72,76,80,84,87,90,92,94,96,97,98,99,100,1]
[2,null,4,25,37,46,54,60,66,70,74,78,81,84,86,88,90,91,92,93,94,2]
[3,null,null,21,33,42,50,56,62,66,70,74,77,80,82,84,86,87,88,89,90,3]
[4,{"$nulls":3},29,38,46,52,58,62,68,70,73,76,78,80,82,83,84,85,86,4]
[5,{"$nulls":4},35,43,49,55,59,63,67,70,73,75,77,79,80,81,82,83,5]
[6,{"$nulls":5},40,46,52,56,60,64,67,70,72,74,76,77,78,79,80,6]
[7,{"$nulls":6},44,50,54,58,62,65,68,70,72,74,75,76,77,78,7]
[8,{"$nulls":7},48,52,56,60,63,66,68,70,72,73,74,75,76,8]
[9,{"$nulls":8},50,54,58,61,64,66,68,70,71,72,73,74,9]
[10,{"$nulls":9},52,56,59,62,64,66,68,69,70,71,72,10]
[11,{"$nulls":10},54,57,60,62,64,66,67,68,69,70,11]
[12,{"$nulls":11},55,58,60,62,64,65,66,67,68,12]
[13,{"$nulls":12},56,58,60,62,63,64,65,66,13]
[14,{"$nulls":13},57,59,61,62,63,64,65,14]
[15,{"$nulls":14},58,60,61,62,63,64,15]
[16,{"$nulls":15},59,60,61,62,63,16]
[17,{"$nulls":16},59,60,61,62,17]
[18,{"$nulls":17},59,60,61,18]
[19,{"$nulls":18},59,60,19]
[20,{"$nulls":19},59,20]
[null,"*","For finishing place n > 20 the points are awarded as follows:",{"$nulls":17},"*","*"]
[]
[{"$nulls":3},"n_points = 59 - 2*log(n-19) "]

{"sheet":"SKIPPERS","index":5,"n_rows":28,"n_cols":5,"rows_kept":28}
["Sail #","NIRVANA/DF-65 SKIPPERs",null,"Sail #","DF-95 SKIPPERs"]
["None","Jay Schach",null,11,"Tony DeFilippis"]
[5,"Harri Beutler",null,24,"Ken Bates"]
[8,"Paul Ryan",null,27,"Jay Schach"]
[11,"Tony DeFilippis",null,34,"Steve Stopa"]
[14,"Ray Cook",null,46,"Ron Hawkins"]
[20,"Bruce Blomgren",null,55,"Rob McKinley"]
[24,"Ken Bates",null,93,"Sandy Graham"]
[25,"Gerry Ryerson",null,144,"Karl Thomsen"]
[26,"Harry Oakley",null,150,"Garrett VanKoughnett"]
[31,"Terry McCormick",null,220,"Mark Hamer"]
[33,"Dick Denzler",null,335,"Larry Rogers"]
[46,"Ron Hawkins",null,462,"Charlie Sweeney"]
[61,"Neal Boucher",null,632,"Dave Ham"]
[66,"Duane Stewart",null,753,"Dick Denzler"]
[72,"Harry Thranhardt",null,969,"Duane Stewart"]
[80,"Mark Hamer",null,999,"Mike Haase"]
[108,"Dan Deets",null,"NN-Red","Jim Blackburn"]
[140,"Bill Miller"]
[142,"Kevin Richter"]
[143,"Dave Williams"]
[150,"Garrett VanKoughnett"]
[154,"Karl Thomsen"]
[220,"Jim Sheldon"]
[250,"Steve Anderman"]
[462,"Charlie Sweeney"]
[663,"Pete Flynn"]
[758,"Harry Howard"]