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

{"sheet":"Average Place_Example","index":0,"n_rows":34,"n_cols":31,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Shields Fleet One 2021 Season Rankings up to and including the LYC Race Week Using the Average Place Scoring System"]
[null,{"$f":"TODAY()","v":"2023-12-26"}]
[]
[null,"The Average Place score for a race series is the average of the boat's finishing places in all races it started."]
[null,"DNF, DSQ etc. are scored as number of starters plus one. DNS and DNC are not scored. Lowest score wins."]
[]
[null,null,null,null,null,null,null,null,null,null,"Independence Day Regatta",null,null,null,null,null,null,"Race Week"]
[null,null,null,null,"Number of Starters",{"$f":"COUNTIF(F11:F21,\">0\")","v":6},{"$f":"COUNTIF(G11:G21,\">0\")","v":6},4,6,7,7,6,6,6,6,4,4,9,9,9,9,9,9,0,0,0]
[null,"Boat Name","Starts","Discards","Average","Race 1","Race 2","Race 3","Race 4","Race 5","Race 6","Race 7","Race 8","Race 9","Race 10","Race 11","Race 12","Race 13","Race 14","Race 15","Race 16","Race 17","Race 18",null,null,null,null,"Average Place","with 1 Discard","with 2 Discards","with 3 Discards"]
[{"$f":"IF(C11<$B$23,\"*\",1+A10)","v":1},"Rascal",{"$f":"COUNTIF($F11:$Z11,\">0\")","v":18},{"$f":"MIN($B$24*INT(C11/$F$24),$L$24)","v":1},{"$f":"INDEX(AB11:AE11,$D11+1)","v":1.5294117647058822},3,1,2,1,1,2,2,1,1,1,1,2,1,5,2,1,2,2,null,null,null,null,{"$f":"AVERAGE($F11:$Z11)","v":1.7222222222222223},{"$f":"IF($C11-1>0,((SUM($F11:$Z11)-MAX($F11:$Z11))/($C11-1)),\"\")","v":1.5294117647058822},{"$f":"IF($C11-2>0,((SUM($F11:$Z11)-MAX($F11:$Z11)-LARGE($F11:$Z11,2))/($C11-2)),\"\")","v":1.4375},{"$f":"IF($C11-3>0,((SUM($F11:$Z11)-MAX($F11:$Z11)-LARGE($F11:$Z11,2)-LARGE($F11:$Z11,3))/($C11-3)),\"\")","v":1.4}]
[2,"Lure",{"$f":"COUNTIF($F12:$Z12,\">0\")","v":17},{"$f":"MIN($B$24*INT(C12/$F$24),$L$24)","v":1},3,2,4,null,3,2,4,3,3,2,4,3,3,2,1,4,8,5,3,null,null,null,null,{"$f":"AVERAGE($F12:$Z12)","v":3.2941176470588234},3,{"$f":"IF($C12-2>0,((SUM($F12:$Z12)-MAX($F12:$Z12)-LARGE($F12:$Z12,2))/($C12-2)),\"\")","v":2.8666666666666667},2.7857142857142856]
[3,"Katherine",18,1,3.2352941176470589,1,3,1,2,4,5,4,4,3,2,2,1,4,4,3,6,6,6,null,null,null,null,3.3888888888888888,3.2352941176470589,3.0625,2.8666666666666667]
[4,"Tango",18,1,4,7,2,3,5,3,1,1,2,4,6,4,4,3,6,8,9,4,5,null,null,null,null,4.2777777777777777,4,3.75,3.5333333333333332]
[5,"Lady",12,1,4.0909090909090908,4,7,null,null,null,null,5,5,5,3,null,null,7,3,5,3,1,4,null,null,null,null,4.333333333333333,4.0909090909090908,3.8,3.6666666666666665]
[6,"Swamp Fox",15,1,6.4285714285714288,5,5,null,4,7,8,6,6,6,5,null,null,9,9,7,5,8,9,null,null,null,null,6.6,6.4285714285714288,6.2307692307692308,6]
["*","Mermaid",8,0,6.5,null,null,null,null,5,3,null,null,null,null,null,null,6,7,10,7,7,7,null,null,null,null,6.5,6,5.833333333333333,5.6]
["*","Checkmate",6,0,2.3333333333333335,null,null,null,null,null,null,null,null,null,null,null,null,5,2,1,2,3,1,null,null,null,null,2.3333333333333335,1.8,1.5,1.3333333333333333]
["*","Coquetta",2,0,5,null,null,4,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,4,"",""]
["*","Intime",6,0,6.5,null,null,null,null,6,6,null,null,null,null,null,null,null,null,6,4,9,8,null,null,null,null,6.5,6,5.5,5.333333333333333]
["*","Nemesis",2,0,8,null,null,null,null,null,null,null,null,null,null,null,null,8,8,null,null,null,null,null,null,null,null,8,8,"",""]
[]
["*",{"$f":"ROUND(G23*COUNTIF($F$9:$Z$9,\">0\"),0)","v":9}," starts needed to \"qualify\" (",null,null,null,0.5,"of all races)"]
[null,1,"one discard for every",null,null,10,"races sailed, Maximum of ",null,null,null,null,3,"discards"]
[]
[null,"Points for DNF and DSQ (red numbers) are awarded as number of starters + 1."]
[]
[]
[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," "]

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