{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sheet1","SUMMER 2017","Rules","CoxSprague","CS_Table","CSG_Functions","SKIPPERS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"CSG_Functions","index":5,"reason":"part_missing"}],"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":"Sheet1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SUMMER 2017","index":1,"n_rows":48,"n_cols":69,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,19,2,24],[1,25,2,29],[1,5,2,6],[1,36,2,41],[1,0,5,0],[4,1,6,1],[3,2,3,3],[1,1,2,1],[1,7,2,12],[2,2,2,3],[1,2,1,3],[4,2,4,3],[1,81,2,86],[1,123,2,128],[44,2,44,3],[43,5,43,6],[42,5,42,6],[1,48,2,53],[1,54,2,55],[1,42,2,47],[5,5,5,6],[3,5,3,6],[1,30,2,35],[1,13,2,18],[44,5,44,6],[1,129,2,134],[42,2,42,3],[41,1,41,5],[1,117,2,122],[1,111,2,116],[1,105,2,110],[1,69,2,74],[1,56,2,57],[1,64,2,68],[1,99,2,104],[1,87,2,92],[5,2,5,3],[4,5,4,6],[1,75,2,80],[1,58,2,63],[1,93,2,98]]}
["2017 SJPMYC  ⛵ SUMMER SERIES ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 8/817",null,"8/10/",2017]
["PLACE","🏁","  🚦 HANDICAP GROUPS 🚦 RED / YELLOW / GREEN ",null,{"$f":"SUM(LARGE(E8:E36,{1,2,3,4,5}))","v":244},"DATE",null,"2017-07-04",null,null,null,null,null,"2017-07-06",null,null,null,null,null,"2017-07-11",null,null,null,null,null,"2017-07-18",null,null,null,null,"2017-07-20",null,null,null,null,null,"2017-07-25",null,null,null,null,null,"2017-07-27",null,null,null,null,null,"2017-08-01",null,null,null,null,null,"2017-08-08",null,"2017-08-08",null,"2017-08-15",null,null,null,null,null,"2017-08-17"]
[null,null,"⏳ 30 SECOND HEADSTART ⏳",null,"TOTAL RACES"]
[null,"🚫"," ⏳ 15 SECOND HEADSTART  ⏳",null,{"$f":"COUNT($H4:FB4)","v":62},"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,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,1,2,1,2,3,4,5,6,1,2,3,4,5]
[null," Qualification ","🔔  SCRATCH   🔔",null,{"$f":"AVERAGE(E2)/5","v":48.8},"# of Starters per Heat",null,6,7,7,7,7,5,6,6,6,6,5,4,4,4,5,4,5,5,9,10,9,9,7,5,5,5,5,5,5,11,12,10,11,11,10,7,8,8,8,8,8,3,4,3,3,3,3,5,5,4,5,6,6,6,6,6,6,7,7,7,6,5]
[null,null,"DNF : DID NOT FINISH                                  0 : RACE OFFICIAL ",null,{"$f":"E5/2","v":24.4},"# of Starts                     to Qualify"]
[null,null,"⛵         Sail #","SKIPPERS","Starts","Discards","C-S Score"]
[{"$f":"A7+1","v":1},"🏁",150,"GARRETT  VanKoughnett",{"$f":"COUNTA(H8:EK8)","v":48},{"$f":"MIN(INT(E8/10),25)","v":4},{"$f":"C_S_G($H8:EK8,$H$5:FB$5,csg_table,$E$4,F8)","v":0.92050691244239635},3,2,1,1,3,2,null,null,null,null,null,null,null,null,null,null,null,null,5,1,2,2,1,3,2,2,1,3,1,6,9,null,5,6,4,1,3,4,6,1,1,1,1,1,1,1,2,1,2,null,1,2,3,1,1,1,1,1,1,3,5,2]
[{"$f":"A8+1","v":2},"🏁","108/68","DAN DEETS",{"$f":"COUNTA(H9:DY9)","v":24},{"$f":"MIN(INT(E9/10),25)","v":2},{"$f":"C_S_G($H9:DY9,$H$5:FB$5,csg_table,$E$4,F9)","v":0.91124260355029585},1,1,3,5,2,1,null,null,null,null,null,null,1,1,2,2,1,1,null,null,null,null,null,null,null,null,null,null,null,8,1,1,10,5,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,2,2,4,2,2]
[{"$f":"A9+1","v":3},"🏁","11","TONY DeFILIPPIS",{"$f":"COUNTA(H10:FB10)","v":46},{"$f":"MIN(INT(E10/10),25)","v":4},{"$f":"C_S_G($H10:FB10,$H$5:FB$5,csg_table,$E$4,F10)","v":0.87344794651384905},2,3,2,"DNF",4,4,1,2,1,1,1,2,null,null,null,null,null,null,1,2,4,5,3,1,3,3,2,2,2,2,4,7,6,10,10,0,0,0,0,0,0,2,2,2,3,2,3,null,null,null,null,null,null,null,null,null,null,4,4,2,1,1]
[{"$f":"A10+1","v":4},"🏁",87,"JUDY RUBIN",{"$f":"COUNTA(H11:DY11)","v":50},{"$f":"MIN(INT(E11/10),25)","v":5},{"$f":"C_S_G($H11:DY11,$H$5:FB$5,csg_table,$E$4,F11)","v":0.87014853857211305},null,5,4,4,1,null,0,0,0,0,0,0,3,3,1,1,2,4,6,5,null,null,null,2,1,1,3,4,5,1,5,8,1,1,null,5,1,1,2,3,3,null,null,null,null,null,null,4,3,4,2,4,1,4,3,6,4,0,0,0,0,0]
[{"$f":"A11+1","v":5},"🏁","71","JIM TAYLOR",{"$f":"COUNTA(H12:ED12)","v":31},{"$f":"MIN(INT(E12/10),25)","v":3},{"$f":"C_S_G($H12:EE12,$H$5:FB$5,csg_table,$E$4,F12)","v":0.80110497237569056},0,0,0,0,0,0,2,1,2,4,4,1,0,0,0,0,0,0,7,4,9,7,5,null,null,null,null,null,null,5,7,null,null,null,null,4,7,7,7,7,2]
[{"$f":"A12+1","v":6},"🏁",57,"PAUL RYAN",{"$f":"COUNTA(H13:DY13)","v":57},{"$f":"MIN(INT(E13/10),25)","v":5},{"$f":"C_S_G($H13:DY13,$H$5:FB$5,csg_table,$E$4,F13)","v":0.76725102573666537},6,6,7,6,"DNF",null,6,3,3,3,5,null,2,2,4,4,3,3,4,6,8,3,null,5,5,5,5,1,3,11,3,3,8,9,5,3,4,3,4,8,8,3,3,3,2,3,1,3,4,3,5,0,0,0,0,0,0,6,5,"DNF"]
[{"$f":"A13+1","v":7},"🏁",91,"CAROLYN SHERWIN",{"$f":"COUNTA(H14:DY14)","v":43},{"$f":"MIN(INT(E14/10),25)","v":4},{"$f":"C_S_G($H14:DY14,$H$5:FB$5,csg_table,$E$4,F14)","v":0.7607515657620042},null,null,null,null,null,null,5,6,4,5,3,4,null,null,3,3,5,5,8,8,3,4,6,4,4,4,4,5,4,3,12,4,3,11,1,"DNF",8,8,5,2,5,null,null,null,null,null,null,5,5,1,3,6,5,6,5,5,5]
[{"$f":"A14+1","v":8},"🏁",40,"STEVE SHEPHERD",{"$f":"COUNTA(H15:EJ15)","v":25},{"$f":"MIN(INT(E15/10),25)","v":2},{"$f":"C_S_G($H15:EE15,$H$5:FB$5,csg_table,$E$4,F15)","v":0.74469496021220161},5,7,6,3,6,5,4,5,5,2,2,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,9,7,2,6,6,5,6,8,6,6,null,4]
[{"$f":"A15+1","v":9},"🏁","140","BILL MILLER",{"$f":"COUNTA(H16:DS16)","v":28},{"$f":"MIN(INT(E16/10),25)","v":2},{"$f":"C_S_G($H16:EE16,$H$5:FB$5,csg_table,$E$4,F16)","v":0.73256649892163905},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,7,9,7,null,null,null,null,null,null,7,6,5,9,8,7,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,5,6,3,6,4,3,5,2,6,6,5]
[]
[{"$f":"A16+1","v":10},"🚫","22","ART SOLOMON",{"$f":"COUNTA(H18:EE18)","v":11},{"$f":"MIN(INT(E18/10),25)","v":1},{"$f":"C_S_G($H18:EE18,$H$5:FB$5,csg_table,$E$4,F18)","v":0.92749244712990941},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,2,2,2,4,2,null,null,null,null,null,null,0,0,0,0,0,0]
[{"$f":"A18+1","v":11},"🚫",343,"BILL BROWN",{"$f":"COUNTA(H19:DY19)","v":4},{"$f":"MIN(INT(E19/10),25)","v":0},{"$f":"C_S_G($H19:DY19,$H$5:FB$5,csg_table,$E$4,F19)","v":0.84496124031007747},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,4,2]
[{"$f":"A19+1","v":12},"🚫","03","JIM LILLAGORE",{"$f":"COUNTA(H20:EE20)","v":23},{"$f":"MIN(INT(E20/10),25)","v":2},{"$f":"C_S_G($H20:EE20,$H$5:FB$5,csg_table,$E$4,F20)","v":0.83609756097560972},4,4,5,2,5,3,null,null,null,null,null,null,null,null,null,null,null,null,3,3,1,1,4,null,null,null,null,null,null,9,8,"DNF","DNF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1,null,null,0,0,0,0,0,0]
[{"$f":"A20+1","v":13},"🚫","758","HARRY HOWARD",{"$f":"COUNTA(H21:DY21)","v":14},{"$f":"MIN(INT(E21/10),25)","v":1},{"$f":"C_S_G($H21:EE21,$H$5:FB$5,csg_table,$E$4,F21)","v":0.83037974683544302},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4,1,4,5,2,3,6]
[{"$f":"A21+1","v":14},"🚫",250,"STEVE ANDERMAN",{"$f":"COUNTA(H22:EJ22)","v":21},{"$f":"MIN(INT(E22/10),25)","v":2},{"$f":"C_S_G($H22:EE22,$H$5:FB$5,csg_table,$E$4,F22)","v":0.82079646017699115},null,null,null,null,null,null,3,4,"DNF",6,null,null,null,null,null,null,null,null,2,7,5,8,2,0,0,0,0,0,0,null,null,null,null,null,null,2,2,2,3,5,7]
[{"$f":"A22+1","v":15},"🚫",144,"KARL  THOMSEN",{"$f":"COUNTA(H23:DY23)","v":13},{"$f":"MIN(INT(E23/10),25)","v":1},{"$f":"C_S_G($H23:DY23,$H$5:FB$5,csg_table,$E$4,F23)","v":0.81630170316301698},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DNF",6,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,5,1,4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,6,1,3,3]
[{"$f":"A23+1","v":16},"🚫",142,"LINDA MCKINLEY",{"$f":"COUNTA(H24:DY24)","v":9},{"$f":"MIN(INT(E24/10),25)","v":0},{"$f":"C_S_G($H24:DY24,$H$5:FB$5,csg_table,$E$4,F24)","v":0.78048780487804881},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,3,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"A24+1","v":17},"🚫","72","HARRY THRANHARDT",{"$f":"COUNTA(H25:DY25)","v":14},{"$f":"MIN(INT(E25/10),25)","v":1},{"$f":"C_S_G($H25:DY25,$H$5:FB$5,csg_table,$E$4,F25)","v":0.77184466019417475},0,0,0,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,4,11,6,4,7,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"A25+1","v":18},"🚫","149","ROB McKINLEY",{"$f":"COUNTA(H26:FB26)","v":11},{"$f":"MIN(INT(E26/10),25)","v":1},{"$f":"C_S_G($H26:FB26,$H$5:FB$5,csg_table,$E$4,F26)","v":0.74736842105263157},null,null,null,null,null,null,null,null,null,null,null,null,4,4,"DNF",null,4,2,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[{"$f":"A26+1","v":19},"🚫",80,"MARK HAMER",{"$f":"COUNTA(H27:DY27)","v":5},{"$f":"MIN(INT(E27/10),25)","v":0},{"$f":"C_S_G($H27:DY27,$H$5:FB$5,csg_table,$E$4,F27)","v":0.7129032258064516},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,5,4,4]
[{"$f":"A27+1","v":20},"🚫","78","PETER RUBIN",{"$f":"COUNTA(H28:EE28)","v":12},{"$f":"MIN(INT(E28/10),25)","v":1},{"$f":"C_S_G($H28:EE28,$H$5:FB$5,csg_table,$E$4,F28)","v":0},null,null,null,null,null,null,0,0,0,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,0,0,0,0,0,0]
[{"$f":"A28+1","v":21},"🚫","5","SANDY GRAHAM",{"$f":"COUNTA(H29:EP29)","v":8},{"$f":"MIN(INT(E29/10),25)","v":0},{"$f":"C_S_G($H29:EP29,$H$5:FB$5,csg_table,$E$4,F29)","v":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,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"A29+1","v":22},"🚫","162","LARRY PHELPS",{"$f":"COUNTA(H30:EE30)","v":6},{"$f":"MIN(INT(E30/10),25)","v":0},{"$f":"C_S_G($H30:EE30,$H$5:FB$5,csg_table,$E$4,F30)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[{"$f":"A30+1","v":23},"🚫","145","MIKE HAASE",{"$f":"COUNTA(H31:EV31)","v":5},{"$f":"MIN(INT(E31/10),25)","v":0},{"$f":"C_S_G($H31:EE31,$H$5:FB$5,csg_table,$E$4,F31)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[{"$f":"A31+1","v":24},"🚫","23","JOHN ECKMAN",{"$f":"COUNTA(H32:EE32)","v":5},{"$f":"MIN(INT(E32/10),25)","v":0},{"$f":"C_S_G($H32:EE32,$H$5:FB$5,csg_table,$E$4,F32)","v":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,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,0,0,0,0,0]
[{"$f":"A32+1","v":25},"🚫","08","PETER WILDING",{"$f":"COUNTA(H33:DY33)","v":2},{"$f":"MIN(INT(E33/10),25)","v":0},{"$f":"C_S_G($H33:DY33,$H$5:FB$5,csg_table,$E$4,F33)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"A33+1","v":26},"🚫","143","JIM IRVINE",{"$f":"COUNTA(H34:EK34)","v":0},{"$f":"MIN(INT(E34/10),25)","v":0},{"$f":"C_S_G($H34:EK34,$H$5:FB$5,csg_table,$E$4,F34)","v":0}]
[{"$f":"A34+1","v":27},"🚫","15","ED THOMPSON",{"$f":"COUNTA(H35:DY35)","v":0},{"$f":"MIN(INT(E35/10),25)","v":0},{"$f":"C_S_G($H35:DY35,$H$5:FB$5,csg_table,$E$4,F35)","v":0}]
[{"$f":"A35+1","v":28},"🚫","305","MIKE KADEL",{"$f":"COUNTA(H36:DY36)","v":0},{"$f":"MIN(INT(E36/10),25)","v":0},{"$f":"C_S_G($H36:DY36,$H$5:FB$5,csg_table,$E$4,F36)","v":0}]
[{"$f":"A36+1","v":29},"🚫","169","DON CUNNINGHAM",{"$f":"COUNTA(H37:DY37)","v":0},{"$f":"MIN(INT(E37/10),25)","v":0},{"$f":"C_S_G($H37:DY37,$H$5:FB$5,csg_table,$E$4,F37)","v":0}]
[{"$f":"A37+1","v":30},"🚫",1766,"ART FALK",{"$f":"COUNTA(H38:DY38)","v":0},{"$f":"MIN(INT(E38/10),25)","v":0},{"$f":"C_S_G($H38:DY38,$H$5:FB$5,csg_table,$E$4,F38)","v":0}]
[{"$f":"A38+1","v":31},"🚫","911/36","DICK GREENE",{"$f":"COUNTA(H39:DY39)","v":0},{"$f":"MIN(INT(E39/10),25)","v":0},{"$f":"C_S_G($H39:DY39,$H$5:FB$5,csg_table,$E$4,F39)","v":0}]
[{"$f":"A39+1","v":32},"🚫",6,"JANINE TALBOT",{"$f":"COUNTA(H40:DY40)","v":0},{"$f":"MIN(INT(E40/10),25)","v":0},{"$f":"C_S_G($H40:DY40,$H$5:FB$5,csg_table,$E$4,F40)","v":0}]
[]
[null,"ONE DISCARD EVERY TEN RACES"]
[null,"🏁"]
[null,"🚫"]
[]
[null,"DNF"]
[]
[null,0]

{"sheet":"Rules","index":2,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
["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,"cut":false,"hidden":false,"merged":[]}
["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":58.397940008672037}]
[null,22,null,null,{"$f":"59-2*LOG(B43-19)","v":58.045757490560675}]
[null,23,null,null,57.795880017344075]
[null,24,null,null,57.602059991327963]
[null,25,null,null,57.443697499232712]
[null,30,null,null,56.917214629683549]
[null,40,null,null,56.355561410532161]
[null,50,null,null,56.017276612331457]
[null,100,null,null,55.183029962242699]
[null,200,null,null,54.484642850261629]
[]
["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",null,null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,null,null,"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":1},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":1},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":0.4},2,2,2,null,null,null,null,"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":0.7},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":0.80645161290322576},null,null,null,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":0.80645161290322576},null,null,null,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":0.67741935483870963},null,null,null,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":0.67741935483870963},null,null,null,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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["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",null,null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,null,null,"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":1},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":1},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":0.67123287671232879},2,2,2,2,null,null,null,"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":0.79452054794520544},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":0.79047619047619044},null,null,null,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":0.79047619047619044},null,null,null,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":0.67619047619047623},null,null,null,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":0.67619047619047623},null,null,null,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",null,null,null," "]
["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",null,null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,null,null,"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":0.85542168674698793},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":0.89156626506024095},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":0.88461538461538458},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":0.94230769230769229},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":0.6428571428571429},null,null,null,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":0.6785714285714286},null,null,null,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":0.78378378378378377},null,null,null,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":0.78378378378378377},null,null,null,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,"cut":false,"hidden":false,"merged":[]}
["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",null,null,null,null,null,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,null,null,null,null,1,0,{"$f":"C19/C$19","v":1},{"$f":"D19/D$19","v":1},{"$f":"E19/E$19","v":1},{"$f":"F19/F$19","v":1},{"$f":"G19/G$19","v":1},{"$f":"H19/H$19","v":1},{"$f":"I19/I$19","v":1},{"$f":"J19/J$19","v":1},{"$f":"K19/K$19","v":1},{"$f":"L19/L$19","v":1},{"$f":"M19/M$19","v":1},{"$f":"N19/N$19","v":1},{"$f":"O19/O$19","v":1},{"$f":"P19/P$19","v":1},{"$f":"Q19/Q$19","v":1},{"$f":"R19/R$19","v":1},{"$f":"S19/S$19","v":1},{"$f":"T19/T$19","v":1},{"$f":"U19/U$19","v":1},1]
[2,null,7,25,37,46,54,60,66,70,74,78,81,84,86,88,90,91,92,93,94,2,null,null,null,null,2,null,{"$f":"C20/C$19","v":0.7},0.80645161290322576,0.86046511627906974,0.88461538461538458,0.9,0.90909090909090906,0.91666666666666663,0.92105263157894735,0.92500000000000004,0.9285714285714286,0.93103448275862066,0.93333333333333335,0.93478260869565222,0.93617021276595747,0.9375,0.93814432989690721,0.93877551020408168,0.93939393939393945,0.94,2]
[3,null,null,21,33,42,50,56,62,66,70,74,77,80,82,84,86,87,88,89,90,3,null,null,null,null,3,null,0,0.67741935483870963,0.76744186046511631,0.80769230769230771,0.83333333333333337,0.84848484848484851,0.86111111111111116,0.86842105263157898,0.875,0.88095238095238093,0.88505747126436785,0.88888888888888884,0.89130434782608692,0.8936170212765957,0.89583333333333337,0.89690721649484539,0.89795918367346939,0.89898989898989901,0.9,3]
[4,null,null,null,29,38,46,52,58,62,68,70,73,76,78,80,82,83,84,85,86,4,null,null,null,null,4,null,0,0,0.67441860465116277,0.73076923076923073,0.76666666666666672,0.78787878787878785,0.80555555555555558,0.81578947368421051,0.85,0.83333333333333337,0.83908045977011492,0.84444444444444444,0.84782608695652173,0.85106382978723405,0.85416666666666663,0.85567010309278346,0.8571428571428571,0.85858585858585856,0.86,4]
[5,null,null,null,null,35,43,49,55,59,63,67,70,73,75,77,79,80,81,82,83,5,null,null,null,null,5,null,0,0,0,0.67307692307692313,0.71666666666666667,0.74242424242424243,0.76388888888888884,0.77631578947368418,0.78749999999999998,0.79761904761904767,0.8045977011494253,0.81111111111111112,0.81521739130434778,0.81914893617021278,0.82291666666666663,0.82474226804123707,0.82653061224489799,0.82828282828282829,0.83,5]
[6,null,null,null,null,null,40,46,52,56,60,64,67,70,72,74,76,77,78,79,80,6,null,null,null,null,6,null,0,0,0,0,0.66666666666666663,0.69696969696969702,0.72222222222222221,0.73684210526315785,0.75,0.76190476190476186,0.77011494252873558,0.77777777777777779,0.78260869565217395,0.78723404255319152,0.79166666666666663,0.79381443298969068,0.79591836734693877,0.79797979797979801,0.8,6]
[7,null,null,null,null,null,null,44,50,54,58,62,65,68,70,72,74,75,76,77,78,7,null,null,null,null,7,null,0,0,0,0,0,0.66666666666666663,0.69444444444444442,0.71052631578947367,0.72499999999999998,0.73809523809523814,0.74712643678160917,0.75555555555555554,0.76086956521739135,0.76595744680851063,0.77083333333333337,0.77319587628865982,0.77551020408163263,0.77777777777777779,0.78,7]
[8,null,null,null,null,null,null,null,48,52,56,60,63,66,68,70,72,73,74,75,76,8,null,null," ",null,8,null,0,0,0,0,0,0,0.66666666666666663,0.68421052631578949,0.7,0.7142857142857143,0.72413793103448276,0.73333333333333328,0.73913043478260865,0.74468085106382975,0.75,0.75257731958762886,0.75510204081632648,0.75757575757575757,0.76,8]
[9,null,null,null,null,null,null,null,null,50,54,58,61,64,66,68,70,71,72,73,74,9,null,null,null,null,9,null,0,0,0,0,0,0,0,0.65789473684210531,0.67500000000000004,0.69047619047619047,0.70114942528735635,0.71111111111111114,0.71739130434782605,0.72340425531914898,0.72916666666666663,0.73195876288659789,0.73469387755102045,0.73737373737373735,0.74,9]
[10,null,null,null,null,null,null,null,null,null,52,56,59,62,64,66,68,69,70,71,72,10,null,null,null,null,10,null,0,0,0,0,0,0,0,0,0.65,0.66666666666666663,0.67816091954022983,0.68888888888888888,0.69565217391304346,0.7021276595744681,0.70833333333333337,0.71134020618556704,0.7142857142857143,0.71717171717171713,0.72,10]
[11,null,null,null,null,null,null,null,null,null,null,54,57,60,62,64,66,67,68,69,70,11,null,null,null,null,11,null,0,0,0,0,0,0,0,0,0,0.6428571428571429,0.65517241379310343,0.66666666666666663,0.67391304347826086,0.68085106382978722,0.6875,0.69072164948453607,0.69387755102040816,0.69696969696969702,0.7,11]
[12,null,null,null,null,null,null,null,null,null,null,null,55,58,60,62,64,65,66,67,68,12,null,null,null,null,12,null,0,0,0,0,0,0,0,0,0,0,0.63218390804597702,0.64444444444444449,0.65217391304347827,0.65957446808510634,0.66666666666666663,0.67010309278350511,0.67346938775510201,0.6767676767676768,0.68,12]
[13,null,null,null,null,null,null,null,null,null,null,null,null,56,58,60,62,63,64,65,66,13,null,null,null,null,13,null,0,0,0,0,0,0,0,0,0,0,0,0.62222222222222223,0.63043478260869568,0.63829787234042556,0.64583333333333337,0.64948453608247425,0.65306122448979587,0.65656565656565657,0.66,13]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,57,59,61,62,63,64,65,14,null,null,null,null,14,null,0,0,0,0,0,0,0,0,0,0,0,0,0.61956521739130432,0.62765957446808507,0.63541666666666663,0.63917525773195871,0.6428571428571429,0.64646464646464652,0.65,14]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,60,61,62,63,64,15,null,null,null,null,15,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0.61702127659574468,0.625,0.62886597938144329,0.63265306122448983,0.63636363636363635,0.64,15]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,60,61,62,63,16,null,null,null,null,16,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.61458333333333337,0.61855670103092786,0.62244897959183676,0.6262626262626263,0.63,16]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,60,61,62,17,null,null,null,null,17,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.60824742268041232,0.61224489795918369,0.61616161616161613,0.62,17]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,60,61,18,null,null,null,null,18,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.60204081632653061,0.60606060606060608,0.61,18]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,60,19,null,null,null,null,19,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.59595959595959591,0.6,19]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,20,null,null,null,null,20,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.59,20]
[null,"*","For finishing place n > 20 the points are awarded as follows:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","*"]
[]
[null,null,null,"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,null,null,null,29,38,46,52,58,62,68,70,73,76,78,80,82,83,84,85,86,4]
[5,null,null,null,null,35,43,49,55,59,63,67,70,73,75,77,79,80,81,82,83,5]
[6,null,null,null,null,null,40,46,52,56,60,64,67,70,72,74,76,77,78,79,80,6]
[7,null,null,null,null,null,null,44,50,54,58,62,65,68,70,72,74,75,76,77,78,7]
[8,null,null,null,null,null,null,null,48,52,56,60,63,66,68,70,72,73,74,75,76,8]
[9,null,null,null,null,null,null,null,null,50,54,58,61,64,66,68,70,71,72,73,74,9]
[10,null,null,null,null,null,null,null,null,null,52,56,59,62,64,66,68,69,70,71,72,10]
[11,null,null,null,null,null,null,null,null,null,null,54,57,60,62,64,66,67,68,69,70,11]
[12,null,null,null,null,null,null,null,null,null,null,null,55,58,60,62,64,65,66,67,68,12]
[13,null,null,null,null,null,null,null,null,null,null,null,null,56,58,60,62,63,64,65,66,13]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,57,59,61,62,63,64,65,14]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,60,61,62,63,64,15]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,60,61,62,63,16]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,60,61,62,17]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,60,61,18]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,60,19]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,20]
[null,"*","For finishing place n > 20 the points are awarded as follows:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","*"]
[]
[null,null,null,"n_points = 59 - 2*log(n-19) "]

{"sheet":"SKIPPERS","index":6,"n_rows":73,"n_cols":2,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["#","SKIPPER"]
["OO","ED PRINCIPE"]
["O1","BRAD WELLS"]
["O3","JIM LILLAGORE"]
["04","NATE LIPSEN"]
["O5","SANDY GRAHAM"]
["O6","JANINE TALBOT"]
["OO7","ED PRINCIPE"]
["O8","PETER WILDING"]
[10,"JAY FREEDMAN"]
[11,"TONY DeFILIPPIS"]
[15,"ED THOMPSON"]
[22,"ART SOLOMON"]
[23,"JOHN ECKMAN"]
[28,"CHUCK WALSTEN"]
[32,"JACK EYLER"]
[34,"PETER WILDING"]
[36,"RICHARD GREENE"]
[39,"DON SAVAGE"]
[41,"JACK EYLER"]
[42,"BOB SLEGHT"]
[43,"RON SMITH"]
[44,"CHUCK JACKSON"]
[45,"RICHARD LeFEBVRE"]
[48,"HARRY DeHaven"]
[49,"LAURA MILLER"]
[52,"TOM BEDNARCZYK"]
[58,"JOE MEISSNER"]
[59,"JOHN MUSKETT"]
[62,"LARRY PHELPS"]
[64,"TED SMYTHE"]
[67,"CHRISTY CARTER"]
[68,"DAN DEETS"]
[70,"RALPH ORLANDO"]
[72,"HARRY THRANHARDT"]
[73,"JIM KESSEL"]
[75,"JOHN MUSKETT"]
[76,"PAUL WLOSTOWSKI"]
[77,"DAVID PAXTON"]
[78,"PETER RUBIN"]
[83,"DAVID PAXTON"]
[86,"GLEN HALSEY"]
[93,"CHRIS CHRISTIANSON"]
[98,"MIKE KIEL"]
[108,"DAN DEETS"]
[109,"KIM WILDING"]
[140,"BILL MILLER"]
[141,"BOB STENHOUSE"]
[142,"LYNDA MCKINLEY"]
[143,"JIM IRVINE"]
[144,"KARL THOMSEN"]
[145,"MIKE HAASE"]
[149,"ROB McKINLEY"]
[150,"GARRETT VANKOUGHNETT"]
[162,"LARRY PHELPS"]
[169,"DON CUNNINGHAM"]
[171,"JAMES TAYLOR"]
[176,"PAUL WLOSTOWSKI"]
[192,"SHERMAN HELLER"]
[207,"BOB SBOTO"]
[220,"JACK SHIMANOSKI"]
[240,"ANDREA ANDERMAN"]
[250,"STEVE ANDERMAN"]
[263,"ANDREA ANDERMAN"]
[305,"MIKE KADEL"]
[306,"PETER KOPYSCANSKI"]
[309,"FRANK HENJE"]
[312,"RON SCHNAPPINGER"]
[314,"DAVID LEACH"]
[343,"BILL BROWN"]
[911,"DICK GREENE"]
[1766,"ART FALK"]
[1776,"BRAD WELLS"]