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

{"sheet":"Instructions","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[[13,0,13,14],[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[4,0,4,14],[7,0,7,14],[8,0,8,14],[9,0,9,14],[10,0,10,14],[11,0,11,14],[12,0,12,14],[14,0,14,14],[15,0,15,14],[16,0,16,14],[17,0,17,14],[18,0,18,14]]}
["Instructions:  Double Handed Race"]
["ONLY Enter DATA In The SHADED Areas!!!!"]
["1. Select File - Save As, and Save with the \"File name\" as \"DH<Date>\", eg \"DH15May11\"."]
["2. Select the Committee Boat Name (use pulldown) and Enter the Race Date."]
["3. Enter the Course (ENTER THE START MARK).  ONLY IF COURSE IS MODIFIED FROM Sis"]
[null,"use pulldown menus to modify or overide distance calculation"]
[null,"Course calculation should match Sis.  Calculation assumes offset from B"]
["4. Enter each Yacht Name for the appropriate start.  Use the pulldown list.  The Sail Number and PHRF Rating is automatically completed.  "]
["    If a Yacht Name is NOT in the pull down list, inquire about their race application and race fees.  No fees = No race"]
["5. If the Start Time is different than the default, enter the New Start Time in 24-hour military format: (hr) (min) (sec)."]
["6. Save the File."]
["7. Enter the Finish Time for each boat in 24-hour military format: (hr) (min) (sec). "]
["     If a boat is DNS or DNF, leave the Finish Time as 23:00:00.  Enter the DNS or DNF in the Remarks column to the right of Corrected Time."]
["8. Save the File."]
["9. Select the Sort Fleet Button for each Class, located to the right of each Class's Remarks column."]
["10. Save the File."]
["11. Email the File to the Scorer at score@smsa.com"]
[]
["V 2011.Weekend.02 - Double Handed"]
[]
["  Notes/changes:"]
[null,"*  Updated for 2011 Racing program changes"]
[null,"*  added new Boat table with mail links.  Also includes Spin and NonSpin ratings and certificate info.  "]
[null,"*  Boats that have paid fees and do not have a valid PHRF certificate will have a PHRF rating of 0 (zero) in the spreadsheet.  "]
[null,"     Competitiors will have to submit valid 2011 PHRF certificates to be scored with their normal rating.  "]
[null,"* 04/16/2011 - fixed course problems, added boats, and fixed start times.  Saved as Macro Enabled (default)"]
[null,"* 04/26/2011 fixed elapsed time calculation for A and B fleets."]

{"sheet":"Race","index":1,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":false,"merged":[[32,9,32,11],[32,14,32,18],[33,4,33,6],[33,9,33,11],[33,14,33,18],[29,1,29,3],[30,2,30,3],[9,4,9,6],[31,2,31,3],[31,4,31,5],[3,3,3,5],[2,3,2,7],[8,9,8,11],[9,9,9,11],[6,2,6,3],[7,2,7,3],[5,1,5,3],[7,4,7,5],[4,3,4,19],[8,14,8,18],[9,14,9,18]]}
[]
["   Race Name :  --->",null,null,"Double Handed Race"]
["  Committee Boat Name -->  "]
[null," Date  -->"]
[null," Conditions --> (optional)"]
[null,"NonSpin Class - Start =    ",null,null,10,5,0]
[null,null,"  Course   =      ",null,"B","C","H",null,null,"I","E","B",null,null,"<--- Enter start loacation mark first"]
[null,null,"  Distance  =   ",null,{"$f":"IF(ISBLANK(F7), 0, VLOOKUP(E7,Course!$A$23:$T$41, LOOKUP(F7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(G7), 0, VLOOKUP(F7,Course!$A$23:$T$41, LOOKUP(G7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(J7), 0, VLOOKUP(G7,Course!$A$23:$T$41, LOOKUP(J7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(K7), 0, VLOOKUP(J7,Course!$A$23:$T$41, LOOKUP(K7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(L7), 0, VLOOKUP(K7,Course!$A$23:$T$41, LOOKUP(L7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(M7), 0, VLOOKUP(L7,Course!$A$23:$T$41, LOOKUP(M7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))","v":12.5},null,null,null,null,null,null,null,null,null,"<--  Override Distance for W/L courses or Drop mark start location"]
[null,null,null,null,null,null,null,null,null,"Uncorrected",null,null,null,"PHRF","Corrected"]
[null,"Sail","Yacht","PHRF","Finish Time",null,null,null,null,"Elapsed Time",null,null,null,"Allowance","Time",null,null,null,null,"Remarks"]
[null,"Number","Name","Rating","(hr)","(min)","(sec)",null,null,"(hr)","(min)","(sec)",null,"(Sec)","(Total Sec)",null,"(hr)","(min)","(sec)","(DNS/DNF)"]
[1,{"$f":"LOOKUP(C12, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C12, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E12*60*60+F12*60+G12)-(E$6*60*60+F$6*60+G$6))","v":46500},{"$f":"J12*60*60+K12*60","v":46500},{"$f":"ROUNDDOWN(H12/60/60, 0)","v":12},{"$f":"ROUNDDOWN((H12 - (J12*60*60))/60, 0)","v":55},{"$f":"H12-I12","v":0},null,{"$f":"D12*$E$8","v":{"$error":"#N/A"}},{"$f":"((J12*60+K12)*60+L12)-N12","v":{"$error":"#N/A"}},{"$f":"Q12*60*60+R12*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O12/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O12 - (Q12*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O12-P12","v":{"$error":"#N/A"}}]
[2,{"$f":"LOOKUP(C13, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C13, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[3,{"$f":"LOOKUP(C14, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C14, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[4,{"$f":"LOOKUP(C15, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C15, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,{"$f":"LOOKUP(C16, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C16, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,{"$f":"LOOKUP(C17, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C17, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,{"$f":"LOOKUP(C18, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C18, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,{"$f":"LOOKUP(C19, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C19, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,{"$f":"LOOKUP(C20, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C20, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,{"$f":"LOOKUP(C21, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C21, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[11,{"$f":"LOOKUP(C22, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C22, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[12,{"$f":"LOOKUP(C23, Boats!$A$3:B$42,Boats!B$3:B$42)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C23, Boats!$A$3:D$42,Boats!F$3:F$42)","v":{"$error":"#N/A"}},23,0,0,46500,46500,12,55,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[13,null,null,null,23,0,0,46500,46500,12,55,0,null,0,46500,46500,12,55,0]
[14,null,null,null,23,0,0,46500,46500,12,55,0,null,0,46500,46500,12,55,0]
[15,null,null,null,23,0,0,46500,46500,12,55,0,null,0,46500,46500,12,55,0]
[16,null,null,null,23,0,0,46500,46500,12,55,0,null,0,46500,46500,12,55,0]
[]
[]
[null,"Spin   - Start (A,B,C) =    ",null,null,10,10,0]
[null,null,"  Course   =      ",null,null,null,null,null,null,null,null,null,null,null,"Leave course blank if the same as prior section start"]
[null,null,"  Distance  =   ",null,{"$f":"IF(ISBLANK(E31),E8,(IF(ISBLANK(F31),0,VLOOKUP(E31,Course!$A$23:$T$41,LOOKUP(F31,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(G31),0,VLOOKUP(F31,Course!$A$23:$T$41,LOOKUP(G31,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(J31),0,VLOOKUP(G31,Course!$A$23:$T$41,LOOKUP(J31,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(K31),0,VLOOKUP(J31,Course!$A$23:$T$41,LOOKUP(K31,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(L31),0,VLOOKUP(K31,Course!$A$23:$T$41,LOOKUP(L31,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(M31),0,VLOOKUP(L31,Course!$A$23:$T$41,LOOKUP(M31,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))))","v":12.5}]
[null,null,null,null,null,null,null,null,null,"Uncorrected",null,null,null,"PHRF","Corrected"]
[null,"Sail","Yacht","PHRF","Finish Time",null,null,null,null,"Elapsed Time",null,null,null,"Allowance","Time",null,null,null,null,"Remarks"]
[null,"Number","Name","Rating","(hr)","(min)","(sec)",null,null,"(hr)","(min)","(sec)",null,"(Sec)","(Total Sec)",null,"(hr)","(min)","(sec)","(DNS/DNF)"]
[1,{"$f":"LOOKUP(C36, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C36, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E36*60*60+F36*60+G36)-(E$30*60*60+F$30*60+G$30))","v":46200},{"$f":"J36*60*60+K36*60","v":46200},{"$f":"ROUNDDOWN(H36/60/60, 0)","v":12},{"$f":"ROUNDDOWN((H36 - (J36*60*60))/60, 0)","v":50},{"$f":"H36-I36","v":0},null,{"$f":"D36*$E$32","v":{"$error":"#N/A"}},{"$f":"((J36*60+K36)*60+L36)-N36","v":{"$error":"#N/A"}},{"$f":"Q36*60*60+R36*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O36/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O36 - (Q36*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O36-P36","v":{"$error":"#N/A"}}]
[2,{"$f":"LOOKUP(C37, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C37, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$f":"D37*$E$32","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[3,{"$f":"LOOKUP(C38, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C38, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[4,{"$f":"LOOKUP(C39, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C39, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,{"$f":"LOOKUP(C40, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C40, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,{"$f":"LOOKUP(C41, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C41, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,{"$f":"LOOKUP(C42, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C42, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,{"$f":"LOOKUP(C43, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C43, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,{"$f":"LOOKUP(C44, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C44, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,{"$f":"LOOKUP(C45, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C45, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[11,{"$f":"LOOKUP(C46, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C46, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[12,{"$f":"LOOKUP(C47, Boats!$A$3:B$42,Boats!B$3:B$42)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(C47, Boats!$A$3:D$42,Boats!E$3:E$42)","v":{"$error":"#N/A"}},23,0,0,46200,46200,12,50,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[13,null,null,null,23,0,0,46200,46200,12,50,0,null,0,46200,46200,12,50,0]
[14,null,null,null,23,0,0,46200,46200,12,50,0,null,0,46200,46200,12,50,0]
[15,null,null,null,23,0,0,46200,46200,12,50,0,null,0,46200,46200,12,50,0]
[16,null,null,null,23,0,0,46200,46200,12,50,0,null,0,46200,46200,12,50,0]

{"sheet":"Boats","index":2,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
[null,"N",null,null,"PHRF"]
["Boat","SailNo","Owner","email","Spin","NonSpin","Race Fee","Spinclass","I","J","P","E","LOA","LWL","Disp","UpSAD","DWSAD","DLWL"]
[]
["Age of Reason",14,"Stovy Brown","stovy@chesapeake.net",162,162,"yes","C",47,15,40.75,12.25,35.5,27.5,15000,17.329999999999998,33.47,{"$f":"((O4/(2240*POWER((N4/100),3))))","v":321.99205752924752}]
["Akoni",93227,"John Kriz","jkriz@md.metrocast.net",180,null,"yes","C",31.56,9.32,32.57,11,25.25,21.83,4200,22.55,40.36,180.2353876411932]
["American Flyer",39519,"Dan Schneider","dc_schneider@msn.com",48,54,"yes","A",51.25,14.04,50.45,18.47,39.4,34.119999999999997,13000,29.96,63.34,146.10607247052613,null,"American Flyer"]
["Bandit",93575,"Daniel Rossi","danielrossi@earthlink.net",78,84,"yes","A",41.33,12.5,41.33,14.25,33,30,6400,28.77,80.33,105.82010582010582]
["Cheetah",36051,"Mark Briere","marcbriere@amewas.com",105,111,"yes *","A",41.94,12.79,46.5,16,35.729999999999997,29.5,10500,24.19,51.76,182.58926180378717]
["Crocodile",93063,"Scott Ward","scott.c.ward1@navy.mil",48,48,"yes","A",51.61,14.47,48.45,17.72,39.299999999999997,34.83,15211,23.46,42.47,160.71237703615463]
["Easy Button",93084,"David Meiser","meiser@comcast.net",159,null,"yes","C",27.75,8.25,29.75,11.72,25.7,20,2600,27.79,46.9,145.08928571428567]
["Elan",43162,"Gary Shaw","garyshaw75@aol.com",153,153,"yes","C",49.5,15.33,42,11,36.83,29.5,13500,18.71,39.33,234.7576223191549]
["Fine",43019,"Johnathan Phillips","samandteddy@hotmail.com",174,180,"yes","C",26.75,9,30.25,11.25,25.2,20.75,3100,24.78,49.66,154.90283719536922]
["Krugerrand",53477,"Sarah Southworth","write2ss@cs.com",132,132,"yes","B",48.42,14.33,42.33,13,36.17,29.42,15300,17.77,35.47,268.2349766677014]
["Lakahi",25260,"Jim Young","youngjw1203@earthlink.net",72,72,"yes","A",48,14.25,47,14.58,35.42,30,9800,26.64,50.21,162.03703703703704]
["Lickety Split",43067,"Donna Maneely","damaneely@verizon.net",168,168,"yes","C",40.86,13,35.36,11.79,31.71,25,9400,18.73,33.700000000000003,{"$f":"((O15/(2240*POWER((N15/100),3))))","v":268.57142857142856}]
["O'Yeller",30714,"Thomas Moulds","tmoulds@dtiweb.net",108,108,"yes","A",36,11.75,31.5,10.75,30,27.5,3600,28.56,57.33,77.278093807019403]
["Pursuit",23798,"Norm Dawley","normdawley@norms-site.com",51,57,"yes","A",52,16,55,18,47.67,37.17,18689,23.26,45.15,162.46520482011175]
["Rakali","USA 158","Mark Witte","mcwitte@md.metrocast.net",120,129,"yes","B",31.5,9.5,30,12.5,26.25,22,2900,29.88,72.56,121.58554255661696]
["Rhumb Punch","USA 41","John Edwards","rhumbpunch@msn.com",54,null,"yes","A",38.26,10.89,40.5,14.57,30.94,27.56,4558,33.200000000000003,78.209999999999994,97.205013026621927]
["Rum Ration",73052,"Scott Pankiewicz","rumration@verizon.net",162,162,"yes","C",42.5,12.83,36.83,12,30.79,25.42,10200,18.5,33.26,277.22060997294335]
["Shermax",2276,"Max Munger","maxmunger@verizon.net",177,177,"yes","C",43,13.16,37.5,12,29.91,25,10200,19.02,37.85,291.42857142857144]
["Spinnster",161,"Betsy Dodge","bdodge33@comcast.net",171,null,"yes","C",30.5,9.5,29.5,12.25,25.92,21.67,4250,22.36,39.880000000000003,186.45076850448498]
["Splash","USA 173","Tom Attick","tattick@chattick.com",111,111,"yes","B",40,12,35,12,29.5,25,5500,25.56,49.85,157.14285714285714]
["Status Quo",63076,"Jimmy Yurko","jimmydyurko@yahoo.com",108,108,"yes","A",36,11.75,31.5,10.75,30,27.5,3750,27.8,55.79,80.498014382311879]
["Stingray",63383,"Elliot Peterson","tepeterson@dcscorp.com",129,129,"yes","B",38,10.95,32.4,12,27.9,23.8,5100,24.12,45.56,{"$f":"((O25/(2240*POWER((N25/100),3))))","v":168.88508104322156}]
["Sv",83096,"Peter LaRoche","no email",168,168,"no","C",39,12.5,34.25,11.5,29.96,25.25,7950,19.5,37.94,220.46261931499356]
["Sw",99,"John Mckinney","no email",null,174,"no","C",41.5,13.87,35,13.75,33.17,26.25,10500,19.46,19.46,259.1512795594428]
["The Doghouse",63199,"Dan Shannon","shannon63199@verizon.net",111,111,"yes","B",40,12,35,12,29.5,25,6000,24.12,47.08,171.42857142857142]
["The Riddler",63243,"Clarke McKinney","cmckinney@quantumsails.com",108,114,"yes","A",34,11,32.5,11.5,29.67,27.5,3600,28.36,58.78,77.278093807019403]
["Toby",142,"Chris Eggert","christopher.eggert@navy.mil",141,141,"yes","B",47.5,15,41.75,11.5,36,29,12800,19.03,37.770000000000003,234.29766346655111]
["Valiant",60177,"L. Allen, Navy PAX SC","robert@luckritz.com",93,93,"yes *","A",58.71,18.45,50.75,16,44,35.799999999999997,31641,16.63,33.83,307.8598847550997]
["Whiskers",63063,"Jim Whited","jimw625@comcast.net",96,96,"yes","A",50.9,15.16,44.1,13.1,37,30.32,12938,21.49,42.34,207.21993712386671]
["Wicked Good",93121,"Mark Gyorgy","mygorgy@dscorp.com",132,132,"yes","B",35.25,10.199999999999999,37.200000000000003,12,26.83,23.42,3800,29.81,51.7,132.06109868494102]
["Wild Thing",87638,"Jimmy Yurko","jimmydyurko@yahoo.com",183,186,"yes","C",22.6,7.25,24.04,9.33,20.329999999999998,18.420000000000002,1160,31.82,54.07,{"$f":"((O34/(2240*POWER((N34/100),3))))","v":82.859268190743165}]

{"sheet":"Course","index":3,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,20,20,null,null,null,20,20,null,null,20,20]
[null,2,2,null,null,"A",2,2,null,"A",2,2,null,"Page has been customized for Wednesday night MARKS"]
["A",2,2,null,null,"B",3,3,null,"B",3,3]
["B",3,3,null,null,"C",4,4,null,"E",5,5]
["C",4,4,null,null,"E",5,5,null,"K",10,10]
["E",5,5,null,null,"G",6,6,null,"L",11,11]
["G",6,6,null,null,"H",7,7,null,"M",12,12]
["H",7,7,null,null,"I",8,8,null,"S",17,17]
["I",8,8,null,null,"J",9,9,null,"T",14,14]
["J",9,9,null,null,"K",10,10,null,"X",16,16]
["K",10,10,null,null,"L",11,11,null,"Y",18,18]
["L",11,11,null,null,"M",12,12,null,"Z",19,19]
["M",12,12,null,null,"S",17,17]
["S",17,17,null,null,"T",14,14]
["T",14,14,null,null,"V",16,16]
["V",16,16,null,null,"X",16,16]
[null,null,null,null,null,"Y",18,18]
[null,null,null,null,null,"Z",19,19]
[null,"Active",null,null,null,null,"All",null,null,null,"Bay"]
[]
[]
[null,"A","B","C","E","G","H","I","J","K","L","M","N","T","U","V","S","Y","Z","X"]
["A",0,0.94,3.41,2.15,3.72,5.41,5.95,6.47,1.76,2.36,2.83,0,0.9,2.54,0.9,2.38,1.41,2.35,1.35]
["B",0.94,0,2.35,1.2,2.82,4.47,5.01,5.53,2.75,3.22,3.71,0,1.58,3.37,1.84,3.2,2.17,3.11,2.15]
["C",3.41,2.4700000000000002,0,2.57,3.11,2.14,3.79,3.23,null,null,null,null,null,null,null,null,null,null,0]
["E",2.15,1.17,2.57,0,1.57,4.1399999999999997,4,5.09,null,null,null,null,null,null,null,null,null,null,0]
["G",3.72,2.82,3.11,1.57,0,3.85,2.7,4.57,null,null,null,null,null,null,null,null,null,null,0]
["H",5.41,4.47,2.14,4.1399999999999997,3.85,0,2.84,1.1000000000000001,null,null,null,null,null,null,null,null,null,null,0]
["I",5.95,5.01,3.79,4,2.7,2.84,0,2.87,null,null,null,null,null,null,null,null,null,null,0]
["J",6.47,5.53,3.23,5.09,4.57,1.1000000000000001,2.87,0,null,null,null,null,null,null,null,null,null,null,0]
["K",1.76,2.75,null,null,null,null,null,null,0,1.08,1.99,0,1.5,0,0.91,1.54,1.33,2.14,1.1499999999999999]
["L",2.36,3.22,null,null,null,null,null,null,1.08,0,1,0,1.68,0,1.74,0.76,1.22,1.9,1.06]
["M",2.83,3.71,null,null,null,null,null,null,1.99,1,0,0,2.16,0,2.41,0.56000000000000005,1.7,2.38,1.45]
["N",1.67,2.5,null,null,null,null,null,null,0,0,0,0,0,0,0,null,0,0,0]
["T",0.9,1.58,null,null,null,null,null,null,1.5,1.68,2.16,0,0,0,1.05,1.64,0.61,1.55,0.56999999999999995]
["U",2.54,3.37,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
["V",0.9,1.84,null,null,null,null,null,null,0.91,1.74,2.41,0,1.05,0,0,1.89,1.24,2.16,1.1000000000000001]
["S",2.38,3.2,null,null,null,null,null,null,1.54,0.76,0.56000000000000005,0,1.64,null,1.89,0,1.2,1.86,1.1100000000000001]
["Y",1.41,2.17,null,null,null,null,null,null,1.33,1.22,1.7,0,0.61,0,1.24,1.2,0,0.94,0.15]
["Z",2.35,3.11,null,null,null,null,null,null,2.14,1.9,2.38,0,1.55,0,2.16,1.86,0.94,0,1.1499999999999999]
["X",1.35,2.15,0,0,0,0,0,0,1.1499999999999999,1.06,1.45,0,0.56999999999999995,0,1.1000000000000001,1.1100000000000001,0.15,1.1499999999999999,0]
[]
[]
[]
["Middle Distance Series Course Table"]
[null,null,null,null,"NS","Spin"]
["Sharps Island Race",null,null,null,39.9,39.9]
["Little Choptank Race",null,null,null,32.5,32.5]
["Smith Point Race",null,null,null,42,59]
["Hooper Island Point-No-Point Race",null,null,null,29.4,29.4]

{"sheet":"RSinput","index":4,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Sail","BoatName","PHRF",null,null,null,"Finish","Division"]
[null,null,null,null,null,null,{"$f":"TIME(D2,E2,F2)","v":"00:00:00"}]