{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Race NS","Race C","Race B","Race A","Boats","ScoreSheet","RSinput","Course"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":6,"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":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[14,0,14,14],[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[4,0,4,14],[8,0,8,14],[9,0,9,14],[10,0,10,14],[11,0,11,14],[12,0,12,14],[13,0,13,14],[15,0,15,14],[16,0,16,14],[17,0,17,14],[18,0,18,14],[19,0,19,14]]}
["Instructions:  Wednesday night racing worksheet"]
["ONLY Enter DATA In The SHADED Areas!!!!"]
["1. Select File - Save As, and Save with the \"File name\" as \"Wed<Date>\", eg \"Wed13Apr16\"."]
["2. Select the Committee Boat Name (use pulldown) and Enter the Race Date."]
["3. Enter the Course (ENTER THE START MARK).  Use the Pulldown List.  The Course Length is automatically calculated."]
[null,"The Start location is assumed to be \"X\".  If the start location is moved then the distance must be manually calculated."]
[null,"If the course does not change for later starts, just leave the course selections blank for those starts.  "]
[null,"If later starts have a different course, enter the new course for each start that is different.  "]
["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. "]
["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 2017.Wed.04    - PHRF Boats as of  06/02/17"]
[]
["  Notes/changes:",null,"1)fixed multiple errors in macros and formulas"]
[null,null,"updated boat info"]
[null,null,"2) Split Race results across 3 tabs.  Eliminated CR allowance. "]
[]
[]
[]
[]
["PHRF Race Type:",null,"WL",null,"Mostly Windward Leward Course type"]
[null,null,"NSWL",null,"Mostly Windward Leward Course type"]
[]
[]
[null,null,"(NOT CURRENTLY SUPPORTED)"]
[null,null,"CR",null,"All points of sail, or equal/greater ratio of Reaching to W/L"]
[null,null,"NSWL",null,"Mostly Windward Leward Course type"]
[null,null,"NSCR",null,"All points of sail, or equal/greater ratio of Reaching to W/L"]

{"sheet":"Race NS","index":1,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,4,10,6],[3,3,3,5],[2,3,2,7],[9,9,9,11],[10,9,10,11],[6,2,6,3],[7,2,7,3],[5,1,5,3],[7,4,7,5],[4,3,4,19],[9,14,9,18],[10,14,10,18]]}
[]
["   Race Name :  --->",null,null,"Wednesday Night race - xx"]
["  Committee Boat Name -->  "]
[null," Date  -->",null,"xx/xx/xx"]
[null," Conditions --> (optional)",null," "]
[null,"NonSpin Class - Start =    ",null,null,18,30,0]
[null,null,"  Course   =      ",null,"X",null,null,null,null,null,null,null,null,null,"<--  Default start location is 'X'."]
[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":0},null,null,null,null,null,null,null,null,null,"<--  Override Distance for Windward/Leward courses"]
[null,null,"PHRF Type =  ",null,"NSWL"]
[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(C13, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C13, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C13, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C13, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E13*60*60+F13*60+G13)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J13*60*60+K13*60","v":16200},{"$f":"ROUNDDOWN(H13/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H13 - (J13*60*60))/60, 0)","v":30},{"$f":"H13-I13","v":0},null,{"$f":"D13*$E$8","v":{"$error":"#N/A"}},{"$f":"((J13*60+K13)*60+L13)-N13","v":{"$error":"#N/A"}},{"$f":"Q13*60*60+R13*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O13/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O13 - (Q13*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O13-P13","v":{"$error":"#N/A"}}]
[2,{"$f":"LOOKUP(C14, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C14, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C14, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C14, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E14*60*60+F14*60+G14)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J14*60*60+K14*60","v":16200},{"$f":"ROUNDDOWN(H14/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H14 - (J14*60*60))/60, 0)","v":30},{"$f":"H14-I14","v":0},null,{"$f":"D14*$E$8","v":{"$error":"#N/A"}},{"$f":"((J14*60+K14)*60+L14)-N14","v":{"$error":"#N/A"}},{"$f":"Q14*60*60+R14*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O14/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O14 - (Q14*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O14-P14","v":{"$error":"#N/A"}}]
[3,{"$f":"LOOKUP(C15, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C15, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C15, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C15, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},20,6,6,{"$f":"((E15*60*60+F15*60+G15)-(E$6*60*60+F$6*60+G$6))","v":5766},{"$f":"J15*60*60+K15*60","v":5760},{"$f":"ROUNDDOWN(H15/60/60, 0)","v":1},{"$f":"ROUNDDOWN((H15 - (J15*60*60))/60, 0)","v":36},{"$f":"H15-I15","v":6},null,{"$f":"D15*$E$8","v":{"$error":"#N/A"}},{"$f":"((J15*60+K15)*60+L15)-N15","v":{"$error":"#N/A"}},{"$f":"Q15*60*60+R15*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O15/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O15 - (Q15*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O15-P15","v":{"$error":"#N/A"}}]
[4,{"$f":"LOOKUP(C16, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C16, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C16, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C16, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E16*60*60+F16*60+G16)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J16*60*60+K16*60","v":16200},{"$f":"ROUNDDOWN(H16/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H16 - (J16*60*60))/60, 0)","v":30},{"$f":"H16-I16","v":0},null,{"$f":"D16*$E$8","v":{"$error":"#N/A"}},{"$f":"((J16*60+K16)*60+L16)-N16","v":{"$error":"#N/A"}},{"$f":"Q16*60*60+R16*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O16/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O16 - (Q16*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O16-P16","v":{"$error":"#N/A"}}]
[5,{"$f":"LOOKUP(C17, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C17, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C17, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C17, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E17*60*60+F17*60+G17)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J17*60*60+K17*60","v":16200},{"$f":"ROUNDDOWN(H17/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H17 - (J17*60*60))/60, 0)","v":30},{"$f":"H17-I17","v":0},null,{"$f":"D17*$E$8","v":{"$error":"#N/A"}},{"$f":"((J17*60+K17)*60+L17)-N17","v":{"$error":"#N/A"}},{"$f":"Q17*60*60+R17*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O17/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O17 - (Q17*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O17-P17","v":{"$error":"#N/A"}}]
[6,{"$f":"LOOKUP(C18, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C18, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C18, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C18, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E18*60*60+F18*60+G18)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J18*60*60+K18*60","v":16200},{"$f":"ROUNDDOWN(H18/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H18 - (J18*60*60))/60, 0)","v":30},{"$f":"H18-I18","v":0},null,{"$f":"D18*$E$8","v":{"$error":"#N/A"}},{"$f":"((J18*60+K18)*60+L18)-N18","v":{"$error":"#N/A"}},{"$f":"Q18*60*60+R18*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O18/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O18 - (Q18*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O18-P18","v":{"$error":"#N/A"}}]
[7,{"$f":"LOOKUP(C19, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C19, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C19, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C19, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E19*60*60+F19*60+G19)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J19*60*60+K19*60","v":16200},{"$f":"ROUNDDOWN(H19/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H19 - (J19*60*60))/60, 0)","v":30},{"$f":"H19-I19","v":0},null,{"$f":"D19*$E$8","v":{"$error":"#N/A"}},{"$f":"((J19*60+K19)*60+L19)-N19","v":{"$error":"#N/A"}},{"$f":"Q19*60*60+R19*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O19/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O19 - (Q19*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O19-P19","v":{"$error":"#N/A"}}]
[8,{"$f":"LOOKUP(C20, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C20, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C20, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C20, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E20*60*60+F20*60+G20)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J20*60*60+K20*60","v":16200},{"$f":"ROUNDDOWN(H20/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H20 - (J20*60*60))/60, 0)","v":30},{"$f":"H20-I20","v":0},null,{"$f":"D20*$E$8","v":{"$error":"#N/A"}},{"$f":"((J20*60+K20)*60+L20)-N20","v":{"$error":"#N/A"}},{"$f":"Q20*60*60+R20*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O20/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O20 - (Q20*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O20-P20","v":{"$error":"#N/A"}}]
[9,{"$f":"LOOKUP(C21, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C21, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C21, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C21, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E21*60*60+F21*60+G21)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J21*60*60+K21*60","v":16200},{"$f":"ROUNDDOWN(H21/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H21 - (J21*60*60))/60, 0)","v":30},{"$f":"H21-I21","v":0},null,{"$f":"D21*$E$8","v":{"$error":"#N/A"}},{"$f":"((J21*60+K21)*60+L21)-N21","v":{"$error":"#N/A"}},{"$f":"Q21*60*60+R21*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O21/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O21 - (Q21*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O21-P21","v":{"$error":"#N/A"}}]
[10,{"$f":"LOOKUP(C22, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C22, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C22, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C22, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E22*60*60+F22*60+G22)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J22*60*60+K22*60","v":16200},{"$f":"ROUNDDOWN(H22/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H22 - (J22*60*60))/60, 0)","v":30},{"$f":"H22-I22","v":0},null,{"$f":"D22*$E$8","v":{"$error":"#N/A"}},{"$f":"((J22*60+K22)*60+L22)-N22","v":{"$error":"#N/A"}},{"$f":"Q22*60*60+R22*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O22/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O22 - (Q22*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O22-P22","v":{"$error":"#N/A"}}]
[11,{"$f":"LOOKUP(C23, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C23, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C23, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C23, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E23*60*60+F23*60+G23)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J23*60*60+K23*60","v":16200},{"$f":"ROUNDDOWN(H23/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H23 - (J23*60*60))/60, 0)","v":30},{"$f":"H23-I23","v":0},null,{"$f":"D23*$E$8","v":{"$error":"#N/A"}},{"$f":"((J23*60+K23)*60+L23)-N23","v":{"$error":"#N/A"}},{"$f":"Q23*60*60+R23*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O23/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O23 - (Q23*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O23-P23","v":{"$error":"#N/A"}}]
[12,{"$f":"LOOKUP(C24, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C24, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C24, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C24, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E24*60*60+F24*60+G24)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J24*60*60+K24*60","v":16200},{"$f":"ROUNDDOWN(H24/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H24 - (J24*60*60))/60, 0)","v":30},{"$f":"H24-I24","v":0},null,{"$f":"D24*$E$8","v":{"$error":"#N/A"}},{"$f":"((J24*60+K24)*60+L24)-N24","v":{"$error":"#N/A"}},{"$f":"Q24*60*60+R24*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O24/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O24 - (Q24*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O24-P24","v":{"$error":"#N/A"}}]
[13,{"$f":"LOOKUP(C25, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C25, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C25, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C25, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E25*60*60+F25*60+G25)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J25*60*60+K25*60","v":16200},{"$f":"ROUNDDOWN(H25/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H25 - (J25*60*60))/60, 0)","v":30},{"$f":"H25-I25","v":0},null,{"$f":"D25*$E$8","v":{"$error":"#N/A"}},{"$f":"((J25*60+K25)*60+L25)-N25","v":{"$error":"#N/A"}},{"$f":"Q25*60*60+R25*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O25/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O25 - (Q25*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O25-P25","v":{"$error":"#N/A"}}]
[14,{"$f":"LOOKUP(C26, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C26, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C26, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C26, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E26*60*60+F26*60+G26)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J26*60*60+K26*60","v":16200},{"$f":"ROUNDDOWN(H26/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H26 - (J26*60*60))/60, 0)","v":30},{"$f":"H26-I26","v":0},null,{"$f":"D26*$E$8","v":{"$error":"#N/A"}},{"$f":"((J26*60+K26)*60+L26)-N26","v":{"$error":"#N/A"}},{"$f":"Q26*60*60+R26*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O26/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O26 - (Q26*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O26-P26","v":{"$error":"#N/A"}}]
[15,{"$f":"LOOKUP(C27, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C27, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C27, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C27, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E27*60*60+F27*60+G27)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J27*60*60+K27*60","v":16200},{"$f":"ROUNDDOWN(H27/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H27 - (J27*60*60))/60, 0)","v":30},{"$f":"H27-I27","v":0},null,{"$f":"D27*$E$8","v":{"$error":"#N/A"}},{"$f":"((J27*60+K27)*60+L27)-N27","v":{"$error":"#N/A"}},{"$f":"Q27*60*60+R27*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O27/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O27 - (Q27*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O27-P27","v":{"$error":"#N/A"}}]
[16,{"$f":"LOOKUP(C28, Boats!$A$3:B$47,Boats!B$3:B$47)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C28, Boats!$A$3:D$47,Boats!G$3:G$47),(IF(E$9=\"WL\",LOOKUP(C28, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"NSCR\",LOOKUP(C28, Boats!$A$3:D$47,Boats!H$3:H$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E28*60*60+F28*60+G28)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J28*60*60+K28*60","v":16200},{"$f":"ROUNDDOWN(H28/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H28 - (J28*60*60))/60, 0)","v":30},{"$f":"H28-I28","v":0},null,{"$f":"D28*$E$8","v":{"$error":"#N/A"}},{"$f":"((J28*60+K28)*60+L28)-N28","v":{"$error":"#N/A"}},{"$f":"Q28*60*60+R28*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O28/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O28 - (Q28*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O28-P28","v":{"$error":"#N/A"}}]

{"sheet":"Race C","index":2,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,1,5,3],[2,3,2,7],[3,3,3,5],[4,3,4,19],[6,2,6,3],[7,2,7,3],[7,4,7,5],[9,9,9,11],[9,14,9,18],[10,4,10,6],[10,9,10,11],[10,14,10,18]]}
[]
["   Race Name :  --->",null,null,{"$f":"'Race NS'!D2","v":"Wednesday Night race - xx"}]
["  Committee Boat Name -->  ",null,null,{"$f":"'Race NS'!D3","v":0}]
[null," Date  -->",null,{"$f":"'Race NS'!D4","v":"xx/xx/xx"}]
[null," Conditions --> (optional)",null,{"$f":"'Race NS'!D5","v":" "}]
[null,"Spin  'C'  - Start =    ",null,null,18,30,0]
[null,null,"  Course   =      ",null,"X",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(F7),'Race NS'!$E$8, 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":0}]
[null,null,"PHRF Type =  ",null,"WL"]
[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(C13, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C13, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C13, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C13, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E13*60*60+F13*60+G13)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J13*60*60+K13*60","v":16200},{"$f":"ROUNDDOWN(H13/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H13 - (J13*60*60))/60, 0)","v":30},{"$f":"H13-I13","v":0},null,{"$f":"D13*$E$8","v":{"$error":"#N/A"}},{"$f":"((J13*60+K13)*60+L13)-N13","v":{"$error":"#N/A"}},{"$f":"Q13*60*60+R13*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O13/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O13 - (Q13*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O13-P13","v":{"$error":"#N/A"}}]
[2,{"$f":"LOOKUP(C14, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C14, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C14, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C14, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E14*60*60+F14*60+G14)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J14*60*60+K14*60","v":16200},{"$f":"ROUNDDOWN(H14/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H14 - (J14*60*60))/60, 0)","v":30},{"$f":"H14-I14","v":0},null,{"$f":"D14*$E$8","v":{"$error":"#N/A"}},{"$f":"((J14*60+K14)*60+L14)-N14","v":{"$error":"#N/A"}},{"$f":"Q14*60*60+R14*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O14/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O14 - (Q14*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O14-P14","v":{"$error":"#N/A"}}]
[3,{"$f":"LOOKUP(C15, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C15, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C15, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C15, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E15*60*60+F15*60+G15)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J15*60*60+K15*60","v":16200},{"$f":"ROUNDDOWN(H15/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H15 - (J15*60*60))/60, 0)","v":30},{"$f":"H15-I15","v":0},null,{"$f":"D15*$E$8","v":{"$error":"#N/A"}},{"$f":"((J15*60+K15)*60+L15)-N15","v":{"$error":"#N/A"}},{"$f":"Q15*60*60+R15*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O15/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O15 - (Q15*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O15-P15","v":{"$error":"#N/A"}}]
[4,{"$f":"LOOKUP(C16, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C16, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C16, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C16, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E16*60*60+F16*60+G16)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J16*60*60+K16*60","v":16200},{"$f":"ROUNDDOWN(H16/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H16 - (J16*60*60))/60, 0)","v":30},{"$f":"H16-I16","v":0},null,{"$f":"D16*$E$8","v":{"$error":"#N/A"}},{"$f":"((J16*60+K16)*60+L16)-N16","v":{"$error":"#N/A"}},{"$f":"Q16*60*60+R16*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O16/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O16 - (Q16*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O16-P16","v":{"$error":"#N/A"}}]
[5,{"$f":"LOOKUP(C17, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C17, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C17, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C17, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E17*60*60+F17*60+G17)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J17*60*60+K17*60","v":16200},{"$f":"ROUNDDOWN(H17/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H17 - (J17*60*60))/60, 0)","v":30},{"$f":"H17-I17","v":0},null,{"$f":"D17*$E$8","v":{"$error":"#N/A"}},{"$f":"((J17*60+K17)*60+L17)-N17","v":{"$error":"#N/A"}},{"$f":"Q17*60*60+R17*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O17/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O17 - (Q17*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O17-P17","v":{"$error":"#N/A"}}]
[6,{"$f":"LOOKUP(C18, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C18, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C18, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C18, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E18*60*60+F18*60+G18)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J18*60*60+K18*60","v":16200},{"$f":"ROUNDDOWN(H18/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H18 - (J18*60*60))/60, 0)","v":30},{"$f":"H18-I18","v":0},null,{"$f":"D18*$E$8","v":{"$error":"#N/A"}},{"$f":"((J18*60+K18)*60+L18)-N18","v":{"$error":"#N/A"}},{"$f":"Q18*60*60+R18*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O18/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O18 - (Q18*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O18-P18","v":{"$error":"#N/A"}}]
[7,{"$f":"LOOKUP(C19, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C19, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C19, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C19, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E19*60*60+F19*60+G19)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J19*60*60+K19*60","v":16200},{"$f":"ROUNDDOWN(H19/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H19 - (J19*60*60))/60, 0)","v":30},{"$f":"H19-I19","v":0},null,{"$f":"D19*$E$8","v":{"$error":"#N/A"}},{"$f":"((J19*60+K19)*60+L19)-N19","v":{"$error":"#N/A"}},{"$f":"Q19*60*60+R19*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O19/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O19 - (Q19*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O19-P19","v":{"$error":"#N/A"}}]
[8,{"$f":"LOOKUP(C20, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C20, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C20, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C20, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E20*60*60+F20*60+G20)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J20*60*60+K20*60","v":16200},{"$f":"ROUNDDOWN(H20/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H20 - (J20*60*60))/60, 0)","v":30},{"$f":"H20-I20","v":0},null,{"$f":"D20*$E$8","v":{"$error":"#N/A"}},{"$f":"((J20*60+K20)*60+L20)-N20","v":{"$error":"#N/A"}},{"$f":"Q20*60*60+R20*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O20/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O20 - (Q20*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O20-P20","v":{"$error":"#N/A"}}]
[9,{"$f":"LOOKUP(C21, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C21, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C21, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C21, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E21*60*60+F21*60+G21)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J21*60*60+K21*60","v":16200},{"$f":"ROUNDDOWN(H21/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H21 - (J21*60*60))/60, 0)","v":30},{"$f":"H21-I21","v":0},null,{"$f":"D21*$E$8","v":{"$error":"#N/A"}},{"$f":"((J21*60+K21)*60+L21)-N21","v":{"$error":"#N/A"}},{"$f":"Q21*60*60+R21*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O21/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O21 - (Q21*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O21-P21","v":{"$error":"#N/A"}}]
[10,{"$f":"LOOKUP(C22, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C22, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C22, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C22, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E22*60*60+F22*60+G22)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J22*60*60+K22*60","v":16200},{"$f":"ROUNDDOWN(H22/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H22 - (J22*60*60))/60, 0)","v":30},{"$f":"H22-I22","v":0},null,{"$f":"D22*$E$8","v":{"$error":"#N/A"}},{"$f":"((J22*60+K22)*60+L22)-N22","v":{"$error":"#N/A"}},{"$f":"Q22*60*60+R22*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O22/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O22 - (Q22*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O22-P22","v":{"$error":"#N/A"}}]
[11,{"$f":"LOOKUP(C23, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C23, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C23, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C23, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E23*60*60+F23*60+G23)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J23*60*60+K23*60","v":16200},{"$f":"ROUNDDOWN(H23/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H23 - (J23*60*60))/60, 0)","v":30},{"$f":"H23-I23","v":0},null,{"$f":"D23*$E$8","v":{"$error":"#N/A"}},{"$f":"((J23*60+K23)*60+L23)-N23","v":{"$error":"#N/A"}},{"$f":"Q23*60*60+R23*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O23/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O23 - (Q23*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O23-P23","v":{"$error":"#N/A"}}]
[12,{"$f":"LOOKUP(C24, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C24, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C24, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C24, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E24*60*60+F24*60+G24)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J24*60*60+K24*60","v":16200},{"$f":"ROUNDDOWN(H24/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H24 - (J24*60*60))/60, 0)","v":30},{"$f":"H24-I24","v":0},null,{"$f":"D24*$E$8","v":{"$error":"#N/A"}},{"$f":"((J24*60+K24)*60+L24)-N24","v":{"$error":"#N/A"}},{"$f":"Q24*60*60+R24*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O24/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O24 - (Q24*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O24-P24","v":{"$error":"#N/A"}}]
[13,{"$f":"LOOKUP(C25, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C25, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C25, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C25, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E25*60*60+F25*60+G25)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J25*60*60+K25*60","v":16200},{"$f":"ROUNDDOWN(H25/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H25 - (J25*60*60))/60, 0)","v":30},{"$f":"H25-I25","v":0},null,{"$f":"D25*$E$8","v":{"$error":"#N/A"}},{"$f":"((J25*60+K25)*60+L25)-N25","v":{"$error":"#N/A"}},{"$f":"Q25*60*60+R25*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O25/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O25 - (Q25*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O25-P25","v":{"$error":"#N/A"}}]
[14,{"$f":"LOOKUP(C26, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C26, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C26, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C26, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E26*60*60+F26*60+G26)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J26*60*60+K26*60","v":16200},{"$f":"ROUNDDOWN(H26/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H26 - (J26*60*60))/60, 0)","v":30},{"$f":"H26-I26","v":0},null,{"$f":"D26*$E$8","v":{"$error":"#N/A"}},{"$f":"((J26*60+K26)*60+L26)-N26","v":{"$error":"#N/A"}},{"$f":"Q26*60*60+R26*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O26/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O26 - (Q26*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O26-P26","v":{"$error":"#N/A"}}]
[15,{"$f":"LOOKUP(C27, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C27, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C27, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C27, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E27*60*60+F27*60+G27)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J27*60*60+K27*60","v":16200},{"$f":"ROUNDDOWN(H27/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H27 - (J27*60*60))/60, 0)","v":30},{"$f":"H27-I27","v":0},null,{"$f":"D27*$E$8","v":{"$error":"#N/A"}},{"$f":"((J27*60+K27)*60+L27)-N27","v":{"$error":"#N/A"}},{"$f":"Q27*60*60+R27*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O27/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O27 - (Q27*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O27-P27","v":{"$error":"#N/A"}}]
[16,{"$f":"LOOKUP(C28, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C28, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C28, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C28, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E28*60*60+F28*60+G28)-(E$6*60*60+F$6*60+G$6))","v":16200},{"$f":"J28*60*60+K28*60","v":16200},{"$f":"ROUNDDOWN(H28/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H28 - (J28*60*60))/60, 0)","v":30},{"$f":"H28-I28","v":0},null,{"$f":"D28*$E$8","v":{"$error":"#N/A"}},{"$f":"((J28*60+K28)*60+L28)-N28","v":{"$error":"#N/A"}},{"$f":"Q28*60*60+R28*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O28/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O28 - (Q28*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O28-P28","v":{"$error":"#N/A"}}]

{"sheet":"Race B","index":3,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,9,9,11],[9,14,9,18],[10,4,10,6],[10,9,10,11],[10,14,10,18],[2,3,2,7],[3,3,3,5],[4,3,4,19],[5,1,5,3],[6,2,6,3],[7,2,7,3],[7,4,7,5]]}
[]
["   Race Name :  --->",null,null,{"$f":"'Race NS'!D2","v":"Wednesday Night race - xx"}]
["  Committee Boat Name -->  ",null,null,{"$f":"'Race NS'!D3","v":0}]
[null," Date  -->",null,{"$f":"'Race NS'!D4","v":"xx/xx/xx"}]
[null," Conditions --> (optional)",null,{"$f":"'Race NS'!D5","v":" "}]
[null,"Spin  'B'  - Start =    ",null,null,18,35,0]
[null,null,"  Course   =      ",null,"X",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(F7),'Race NS'!$E$8, 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":0}]
[null,null,"PHRF Type =  ",null,"WL"]
[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(C13, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C13, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C13, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C13, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E13*60*60+F13*60+G13)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J13*60*60+K13*60","v":15900},{"$f":"ROUNDDOWN(H13/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H13 - (J13*60*60))/60, 0)","v":25},{"$f":"H13-I13","v":0},null,{"$f":"D13*$E$8","v":{"$error":"#N/A"}},{"$f":"((J13*60+K13)*60+L13)-N13","v":{"$error":"#N/A"}},{"$f":"Q13*60*60+R13*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O13/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O13 - (Q13*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O13-P13","v":{"$error":"#N/A"}}]
[2,{"$f":"LOOKUP(C14, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C14, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C14, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C14, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E14*60*60+F14*60+G14)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J14*60*60+K14*60","v":15900},{"$f":"ROUNDDOWN(H14/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H14 - (J14*60*60))/60, 0)","v":25},{"$f":"H14-I14","v":0},null,{"$f":"D14*$E$8","v":{"$error":"#N/A"}},{"$f":"((J14*60+K14)*60+L14)-N14","v":{"$error":"#N/A"}},{"$f":"Q14*60*60+R14*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O14/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O14 - (Q14*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O14-P14","v":{"$error":"#N/A"}}]
[3,{"$f":"LOOKUP(C15, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C15, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C15, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C15, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E15*60*60+F15*60+G15)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J15*60*60+K15*60","v":15900},{"$f":"ROUNDDOWN(H15/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H15 - (J15*60*60))/60, 0)","v":25},{"$f":"H15-I15","v":0},null,{"$f":"D15*$E$8","v":{"$error":"#N/A"}},{"$f":"((J15*60+K15)*60+L15)-N15","v":{"$error":"#N/A"}},{"$f":"Q15*60*60+R15*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O15/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O15 - (Q15*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O15-P15","v":{"$error":"#N/A"}}]
[4,{"$f":"LOOKUP(C16, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C16, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C16, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C16, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E16*60*60+F16*60+G16)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J16*60*60+K16*60","v":15900},{"$f":"ROUNDDOWN(H16/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H16 - (J16*60*60))/60, 0)","v":25},{"$f":"H16-I16","v":0},null,{"$f":"D16*$E$8","v":{"$error":"#N/A"}},{"$f":"((J16*60+K16)*60+L16)-N16","v":{"$error":"#N/A"}},{"$f":"Q16*60*60+R16*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O16/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O16 - (Q16*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O16-P16","v":{"$error":"#N/A"}}]
[5,{"$f":"LOOKUP(C17, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C17, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C17, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C17, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E17*60*60+F17*60+G17)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J17*60*60+K17*60","v":15900},{"$f":"ROUNDDOWN(H17/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H17 - (J17*60*60))/60, 0)","v":25},{"$f":"H17-I17","v":0},null,{"$f":"D17*$E$8","v":{"$error":"#N/A"}},{"$f":"((J17*60+K17)*60+L17)-N17","v":{"$error":"#N/A"}},{"$f":"Q17*60*60+R17*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O17/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O17 - (Q17*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O17-P17","v":{"$error":"#N/A"}}]
[6,{"$f":"LOOKUP(C18, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C18, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C18, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C18, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E18*60*60+F18*60+G18)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J18*60*60+K18*60","v":15900},{"$f":"ROUNDDOWN(H18/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H18 - (J18*60*60))/60, 0)","v":25},{"$f":"H18-I18","v":0},null,{"$f":"D18*$E$8","v":{"$error":"#N/A"}},{"$f":"((J18*60+K18)*60+L18)-N18","v":{"$error":"#N/A"}},{"$f":"Q18*60*60+R18*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O18/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O18 - (Q18*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O18-P18","v":{"$error":"#N/A"}}]
[7,{"$f":"LOOKUP(C19, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C19, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C19, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C19, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E19*60*60+F19*60+G19)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J19*60*60+K19*60","v":15900},{"$f":"ROUNDDOWN(H19/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H19 - (J19*60*60))/60, 0)","v":25},{"$f":"H19-I19","v":0},null,{"$f":"D19*$E$8","v":{"$error":"#N/A"}},{"$f":"((J19*60+K19)*60+L19)-N19","v":{"$error":"#N/A"}},{"$f":"Q19*60*60+R19*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O19/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O19 - (Q19*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O19-P19","v":{"$error":"#N/A"}}]
[8,{"$f":"LOOKUP(C20, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C20, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C20, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C20, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E20*60*60+F20*60+G20)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J20*60*60+K20*60","v":15900},{"$f":"ROUNDDOWN(H20/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H20 - (J20*60*60))/60, 0)","v":25},{"$f":"H20-I20","v":0},null,{"$f":"D20*$E$8","v":{"$error":"#N/A"}},{"$f":"((J20*60+K20)*60+L20)-N20","v":{"$error":"#N/A"}},{"$f":"Q20*60*60+R20*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O20/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O20 - (Q20*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O20-P20","v":{"$error":"#N/A"}}]
[9,{"$f":"LOOKUP(C21, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C21, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C21, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C21, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E21*60*60+F21*60+G21)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J21*60*60+K21*60","v":15900},{"$f":"ROUNDDOWN(H21/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H21 - (J21*60*60))/60, 0)","v":25},{"$f":"H21-I21","v":0},null,{"$f":"D21*$E$8","v":{"$error":"#N/A"}},{"$f":"((J21*60+K21)*60+L21)-N21","v":{"$error":"#N/A"}},{"$f":"Q21*60*60+R21*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O21/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O21 - (Q21*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O21-P21","v":{"$error":"#N/A"}}]
[10,{"$f":"LOOKUP(C22, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C22, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C22, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C22, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E22*60*60+F22*60+G22)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J22*60*60+K22*60","v":15900},{"$f":"ROUNDDOWN(H22/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H22 - (J22*60*60))/60, 0)","v":25},{"$f":"H22-I22","v":0},null,{"$f":"D22*$E$8","v":{"$error":"#N/A"}},{"$f":"((J22*60+K22)*60+L22)-N22","v":{"$error":"#N/A"}},{"$f":"Q22*60*60+R22*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O22/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O22 - (Q22*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O22-P22","v":{"$error":"#N/A"}}]
[11,{"$f":"LOOKUP(C23, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C23, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C23, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C23, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E23*60*60+F23*60+G23)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J23*60*60+K23*60","v":15900},{"$f":"ROUNDDOWN(H23/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H23 - (J23*60*60))/60, 0)","v":25},{"$f":"H23-I23","v":0},null,{"$f":"D23*$E$8","v":{"$error":"#N/A"}},{"$f":"((J23*60+K23)*60+L23)-N23","v":{"$error":"#N/A"}},{"$f":"Q23*60*60+R23*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O23/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O23 - (Q23*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O23-P23","v":{"$error":"#N/A"}}]
[12,{"$f":"LOOKUP(C24, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C24, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C24, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C24, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E24*60*60+F24*60+G24)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J24*60*60+K24*60","v":15900},{"$f":"ROUNDDOWN(H24/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H24 - (J24*60*60))/60, 0)","v":25},{"$f":"H24-I24","v":0},null,{"$f":"D24*$E$8","v":{"$error":"#N/A"}},{"$f":"((J24*60+K24)*60+L24)-N24","v":{"$error":"#N/A"}},{"$f":"Q24*60*60+R24*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O24/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O24 - (Q24*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O24-P24","v":{"$error":"#N/A"}}]
[13,{"$f":"LOOKUP(C25, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C25, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C25, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C25, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E25*60*60+F25*60+G25)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J25*60*60+K25*60","v":15900},{"$f":"ROUNDDOWN(H25/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H25 - (J25*60*60))/60, 0)","v":25},{"$f":"H25-I25","v":0},null,{"$f":"D25*$E$8","v":{"$error":"#N/A"}},{"$f":"((J25*60+K25)*60+L25)-N25","v":{"$error":"#N/A"}},{"$f":"Q25*60*60+R25*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O25/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O25 - (Q25*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O25-P25","v":{"$error":"#N/A"}}]
[14,{"$f":"LOOKUP(C26, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C26, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C26, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C26, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E26*60*60+F26*60+G26)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J26*60*60+K26*60","v":15900},{"$f":"ROUNDDOWN(H26/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H26 - (J26*60*60))/60, 0)","v":25},{"$f":"H26-I26","v":0},null,{"$f":"D26*$E$8","v":{"$error":"#N/A"}},{"$f":"((J26*60+K26)*60+L26)-N26","v":{"$error":"#N/A"}},{"$f":"Q26*60*60+R26*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O26/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O26 - (Q26*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O26-P26","v":{"$error":"#N/A"}}]
[15,{"$f":"LOOKUP(C27, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C27, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C27, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C27, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E27*60*60+F27*60+G27)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J27*60*60+K27*60","v":15900},{"$f":"ROUNDDOWN(H27/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H27 - (J27*60*60))/60, 0)","v":25},{"$f":"H27-I27","v":0},null,{"$f":"D27*$E$8","v":{"$error":"#N/A"}},{"$f":"((J27*60+K27)*60+L27)-N27","v":{"$error":"#N/A"}},{"$f":"Q27*60*60+R27*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O27/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O27 - (Q27*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O27-P27","v":{"$error":"#N/A"}}]
[16,{"$f":"LOOKUP(C28, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C28, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C28, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C28, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E28*60*60+F28*60+G28)-(E$6*60*60+F$6*60+G$6))","v":15900},{"$f":"J28*60*60+K28*60","v":15900},{"$f":"ROUNDDOWN(H28/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H28 - (J28*60*60))/60, 0)","v":25},{"$f":"H28-I28","v":0},null,{"$f":"D28*$E$8","v":{"$error":"#N/A"}},{"$f":"((J28*60+K28)*60+L28)-N28","v":{"$error":"#N/A"}},{"$f":"Q28*60*60+R28*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O28/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O28 - (Q28*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O28-P28","v":{"$error":"#N/A"}}]

{"sheet":"Race A","index":4,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,9,9,11],[9,14,9,18],[10,4,10,6],[10,9,10,11],[10,14,10,18],[2,3,2,7],[3,3,3,5],[4,3,4,19],[5,1,5,3],[6,2,6,3],[7,2,7,3],[7,4,7,5]]}
[]
["   Race Name :  --->",null,null,{"$f":"'Race NS'!D2","v":"Wednesday Night race - xx"}]
["  Committee Boat Name -->  ",null,null,{"$f":"'Race NS'!D3","v":0}]
[null," Date  -->",null,{"$f":"'Race NS'!D4","v":"xx/xx/xx"}]
[null," Conditions --> (optional)",null,{"$f":"'Race NS'!D5","v":" "}]
[null,"Spin  'A'  - Start =    ",null,null,18,40,0]
[null,null,"  Course   =      ",null,"X",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(F7),'Race NS'!$E$8, 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":0}]
[null,null,"PHRF Type =  ",null,"WL"]
[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(C13, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C13, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C13, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C13, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E13*60*60+F13*60+G13)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J13*60*60+K13*60","v":15600},{"$f":"ROUNDDOWN(H13/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H13 - (J13*60*60))/60, 0)","v":20},{"$f":"H13-I13","v":0},null,{"$f":"D13*$E$8","v":{"$error":"#N/A"}},{"$f":"((J13*60+K13)*60+L13)-N13","v":{"$error":"#N/A"}},{"$f":"Q13*60*60+R13*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O13/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O13 - (Q13*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O13-P13","v":{"$error":"#N/A"}}]
[2,{"$f":"LOOKUP(C14, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C14, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C14, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C14, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E14*60*60+F14*60+G14)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J14*60*60+K14*60","v":15600},{"$f":"ROUNDDOWN(H14/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H14 - (J14*60*60))/60, 0)","v":20},{"$f":"H14-I14","v":0},null,{"$f":"D14*$E$8","v":{"$error":"#N/A"}},{"$f":"((J14*60+K14)*60+L14)-N14","v":{"$error":"#N/A"}},{"$f":"Q14*60*60+R14*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O14/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O14 - (Q14*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O14-P14","v":{"$error":"#N/A"}}]
[3,{"$f":"LOOKUP(C15, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C15, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C15, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C15, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E15*60*60+F15*60+G15)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J15*60*60+K15*60","v":15600},{"$f":"ROUNDDOWN(H15/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H15 - (J15*60*60))/60, 0)","v":20},{"$f":"H15-I15","v":0},null,{"$f":"D15*$E$8","v":{"$error":"#N/A"}},{"$f":"((J15*60+K15)*60+L15)-N15","v":{"$error":"#N/A"}},{"$f":"Q15*60*60+R15*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O15/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O15 - (Q15*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O15-P15","v":{"$error":"#N/A"}}]
[4,{"$f":"LOOKUP(C16, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C16, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C16, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C16, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E16*60*60+F16*60+G16)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J16*60*60+K16*60","v":15600},{"$f":"ROUNDDOWN(H16/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H16 - (J16*60*60))/60, 0)","v":20},{"$f":"H16-I16","v":0},null,{"$f":"D16*$E$8","v":{"$error":"#N/A"}},{"$f":"((J16*60+K16)*60+L16)-N16","v":{"$error":"#N/A"}},{"$f":"Q16*60*60+R16*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O16/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O16 - (Q16*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O16-P16","v":{"$error":"#N/A"}}]
[5,{"$f":"LOOKUP(C17, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C17, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C17, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C17, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E17*60*60+F17*60+G17)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J17*60*60+K17*60","v":15600},{"$f":"ROUNDDOWN(H17/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H17 - (J17*60*60))/60, 0)","v":20},{"$f":"H17-I17","v":0},null,{"$f":"D17*$E$8","v":{"$error":"#N/A"}},{"$f":"((J17*60+K17)*60+L17)-N17","v":{"$error":"#N/A"}},{"$f":"Q17*60*60+R17*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O17/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O17 - (Q17*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O17-P17","v":{"$error":"#N/A"}}]
[6,{"$f":"LOOKUP(C18, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C18, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C18, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C18, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E18*60*60+F18*60+G18)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J18*60*60+K18*60","v":15600},{"$f":"ROUNDDOWN(H18/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H18 - (J18*60*60))/60, 0)","v":20},{"$f":"H18-I18","v":0},null,{"$f":"D18*$E$8","v":{"$error":"#N/A"}},{"$f":"((J18*60+K18)*60+L18)-N18","v":{"$error":"#N/A"}},{"$f":"Q18*60*60+R18*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O18/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O18 - (Q18*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O18-P18","v":{"$error":"#N/A"}}]
[7,{"$f":"LOOKUP(C19, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C19, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C19, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C19, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E19*60*60+F19*60+G19)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J19*60*60+K19*60","v":15600},{"$f":"ROUNDDOWN(H19/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H19 - (J19*60*60))/60, 0)","v":20},{"$f":"H19-I19","v":0},null,{"$f":"D19*$E$8","v":{"$error":"#N/A"}},{"$f":"((J19*60+K19)*60+L19)-N19","v":{"$error":"#N/A"}},{"$f":"Q19*60*60+R19*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O19/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O19 - (Q19*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O19-P19","v":{"$error":"#N/A"}}]
[8,{"$f":"LOOKUP(C20, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C20, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C20, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C20, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E20*60*60+F20*60+G20)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J20*60*60+K20*60","v":15600},{"$f":"ROUNDDOWN(H20/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H20 - (J20*60*60))/60, 0)","v":20},{"$f":"H20-I20","v":0},null,{"$f":"D20*$E$8","v":{"$error":"#N/A"}},{"$f":"((J20*60+K20)*60+L20)-N20","v":{"$error":"#N/A"}},{"$f":"Q20*60*60+R20*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O20/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O20 - (Q20*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O20-P20","v":{"$error":"#N/A"}}]
[9,{"$f":"LOOKUP(C21, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C21, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C21, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C21, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E21*60*60+F21*60+G21)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J21*60*60+K21*60","v":15600},{"$f":"ROUNDDOWN(H21/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H21 - (J21*60*60))/60, 0)","v":20},{"$f":"H21-I21","v":0},null,{"$f":"D21*$E$8","v":{"$error":"#N/A"}},{"$f":"((J21*60+K21)*60+L21)-N21","v":{"$error":"#N/A"}},{"$f":"Q21*60*60+R21*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O21/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O21 - (Q21*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O21-P21","v":{"$error":"#N/A"}}]
[10,{"$f":"LOOKUP(C22, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C22, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C22, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C22, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E22*60*60+F22*60+G22)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J22*60*60+K22*60","v":15600},{"$f":"ROUNDDOWN(H22/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H22 - (J22*60*60))/60, 0)","v":20},{"$f":"H22-I22","v":0},null,{"$f":"D22*$E$8","v":{"$error":"#N/A"}},{"$f":"((J22*60+K22)*60+L22)-N22","v":{"$error":"#N/A"}},{"$f":"Q22*60*60+R22*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O22/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O22 - (Q22*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O22-P22","v":{"$error":"#N/A"}}]
[11,{"$f":"LOOKUP(C23, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C23, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C23, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C23, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E23*60*60+F23*60+G23)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J23*60*60+K23*60","v":15600},{"$f":"ROUNDDOWN(H23/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H23 - (J23*60*60))/60, 0)","v":20},{"$f":"H23-I23","v":0},null,{"$f":"D23*$E$8","v":{"$error":"#N/A"}},{"$f":"((J23*60+K23)*60+L23)-N23","v":{"$error":"#N/A"}},{"$f":"Q23*60*60+R23*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O23/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O23 - (Q23*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O23-P23","v":{"$error":"#N/A"}}]
[12,{"$f":"LOOKUP(C24, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C24, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C24, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C24, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E24*60*60+F24*60+G24)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J24*60*60+K24*60","v":15600},{"$f":"ROUNDDOWN(H24/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H24 - (J24*60*60))/60, 0)","v":20},{"$f":"H24-I24","v":0},null,{"$f":"D24*$E$8","v":{"$error":"#N/A"}},{"$f":"((J24*60+K24)*60+L24)-N24","v":{"$error":"#N/A"}},{"$f":"Q24*60*60+R24*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O24/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O24 - (Q24*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O24-P24","v":{"$error":"#N/A"}}]
[13,{"$f":"LOOKUP(C25, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C25, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C25, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C25, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E25*60*60+F25*60+G25)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J25*60*60+K25*60","v":15600},{"$f":"ROUNDDOWN(H25/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H25 - (J25*60*60))/60, 0)","v":20},{"$f":"H25-I25","v":0},null,{"$f":"D25*$E$8","v":{"$error":"#N/A"}},{"$f":"((J25*60+K25)*60+L25)-N25","v":{"$error":"#N/A"}},{"$f":"Q25*60*60+R25*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O25/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O25 - (Q25*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O25-P25","v":{"$error":"#N/A"}}]
[14,{"$f":"LOOKUP(C26, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C26, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C26, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C26, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E26*60*60+F26*60+G26)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J26*60*60+K26*60","v":15600},{"$f":"ROUNDDOWN(H26/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H26 - (J26*60*60))/60, 0)","v":20},{"$f":"H26-I26","v":0},null,{"$f":"D26*$E$8","v":{"$error":"#N/A"}},{"$f":"((J26*60+K26)*60+L26)-N26","v":{"$error":"#N/A"}},{"$f":"Q26*60*60+R26*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O26/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O26 - (Q26*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O26-P26","v":{"$error":"#N/A"}}]
[15,{"$f":"LOOKUP(C27, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C27, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C27, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C27, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E27*60*60+F27*60+G27)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J27*60*60+K27*60","v":15600},{"$f":"ROUNDDOWN(H27/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H27 - (J27*60*60))/60, 0)","v":20},{"$f":"H27-I27","v":0},null,{"$f":"D27*$E$8","v":{"$error":"#N/A"}},{"$f":"((J27*60+K27)*60+L27)-N27","v":{"$error":"#N/A"}},{"$f":"Q27*60*60+R27*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O27/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O27 - (Q27*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O27-P27","v":{"$error":"#N/A"}}]
[16,{"$f":"LOOKUP(C28, Boats!$A$3:B$47,Boats!B$3:B$47)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NS\",LOOKUP(C28, Boats!$A$3:D$47,Boats!H$3:H$47),(IF(E$9=\"WL\",LOOKUP(C28, Boats!$A$3:D$47,Boats!E$3:E$47),(IF(E$9=\"CR\",LOOKUP(C28, Boats!$A$3:D$47,Boats!F$3:F$47))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E28*60*60+F28*60+G28)-(E$6*60*60+F$6*60+G$6))","v":15600},{"$f":"J28*60*60+K28*60","v":15600},{"$f":"ROUNDDOWN(H28/60/60, 0)","v":4},{"$f":"ROUNDDOWN((H28 - (J28*60*60))/60, 0)","v":20},{"$f":"H28-I28","v":0},null,{"$f":"D28*$E$8","v":{"$error":"#N/A"}},{"$f":"((J28*60+K28)*60+L28)-N28","v":{"$error":"#N/A"}},{"$f":"Q28*60*60+R28*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O28/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O28 - (Q28*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O28-P28","v":{"$error":"#N/A"}}]

{"sheet":"Boats","index":5,"n_rows":103,"n_cols":22,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,4,0,7]]}
[null,"N",null,null,"PHRF"]
["Boat","SailNo","Owner","email","Spin - WL","Spin - CR","NonSpin-WL","NonSpin-CR","Race Fee","Spinclass","I","J","P","E","LOA","LWL","Disp","UpSAD","DWSAD","DLWL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U4:U40)","v":23}]
["American Flyer",39519,"Dan Schneider","dc_schneider@msn.com",36,36,42,42,"no","A",51.25,14.04,50.45,18.47,39.4,34.119999999999997,13000,29.96,63.34,146.10607247052599,null,"American Flyer"]
["Arctic Tern",93642,"PAX",null,168,168,168,168,"yes","C",null,null,null,null,null,null,null,null,null,null,1]
["Bad Cat","063","Jim Whited","jimw625@comcast.net",39,33,48,48,"yes","A",48.36,13.84,45.17,45.17,36.5,32.700000000000003,9300,23.92,70.47,118.74,1]
["Badger",144,"Carl Feusaherns","feus@comcast.net",177,177,177,177,"yes","C",30.5,9.5,29.42,12.29,25.9,21.7,4250,19.829999999999998,41.94,185.68,1]
["Blue Boat Home",4856,"Lowell Martin",null,231,231,231,231,"yes","C",34,11.25,28.67,10.5,26.8,21.8,6850,15.14,35.43,295.17,1]
["Blue Goose",93643,"PAX",null,168,168,168,168,"no","C"]
["Cheetah",50473,"Marc Briere","race@smsa.com",36,30,45,45,"yes","A",43.7,12.6,44.7,16.5,35.86,31.76,8150,25.41,73.319999999999993,113.14,1]
["Easy Button",93084,"David Meiser","meiser@comcast.net",159,162,159,159,"yes","C",27.75,8.25,29.75,11.72,25.7,20,2600,24.41,49.25,145.08928571428601,1]
["Elan",43162,"Gary Shaw","garyshaw75@aol.com",153,153,153,153,"yes","C",49.5,15.33,42,11,36.83,29.5,13500,18.71,39.33,234.75762231915499,1]
["Flyer",25126,"Michael Major","mjamesmajor@gmail.com",111,111,114,114,"no","B",40.18,11.65,42.27,15.79,34.4,27.2,8825,21.24,39.65,195.78]
["J Ray","USA47","Larry Ray","mlray@gmail.com",114,111,120,120,"yes","B",26.77,7.68,26.16,9.44,22.8,20.5,1750,29.6,43,90.68,1]
["Juggernaut",51277,"David Ahearn",null,39,39,39,39,"no","A",50.82,14.7,51.75,16.5,37.700000000000003,34.200000000000003,11400,25.24,71.02,127.23]
["Kraken",43289,"Scott Roland",null,180,180,180,180,"yes","C",26.75,9,30.25,11.25,25.2,20.9,3150,21.6,41.93,154.04,1]
["Krugerrand",53477,"Sarah Southworth","write2ss@cs.com",132,132,132,132,"yes","B",48.42,14.33,42.33,13,36.17,29.42,15300,17.77,35.47,{"$f":"((Q17/(2240*POWER((P17/100),3))))","v":268.2349766677014},1]
["Lickety Split",43067,"Donna Maneely","damaneely@verizon.net",168,168,168,168,"yes","C",40.86,13,35.36,11.79,31.71,25,9400,18.73,33.700000000000003,268.57142857142901,1]
["Natural Disaster",63243,"Thomas Moulds","tmoulds@dtiweb.net",114,114,114,114,"yes","B",36,11.75,31.5,10.75,30,27.5,3600,28.56,57.33,{"$f":"((Q19/(2240*POWER((P19/100),3))))","v":77.278093807019403},1]
["Pony Express",50588,"Jimmy Yurko","jimmydyurko@gmail.com",132,129,138,138,"yes","B",28,8.5,28,11,25,21.3,2000,27.49,61.72,92.39,1]
["Pursuit",23798,"Norm Dawley","normdawley@norms-site.com",51,45,66,66,"yes","A",52,16,55,18,47.67,37.17,18689,20.66,49.83,162.07,1]
["Rakali","USAxxx","Mark Witte","mcwitte@md.metrocast.net",90,90,96,96,"yes","A",40.6,13.5,41.5,14.6,34.5,29.5,7750,23.54,51.36,134.77000000000001,1]
["Shamal",23827,"Jeff Carlsen",null,174,174,174,174,"yes","C",30.75,9.83,26.5,9.5,24.58,19.170000000000002,2950,23.78,46.61,187,1]
["Shermax",2276,"Max Munger","maxmunger@verizon.net",177,177,177,177,"no","C",43,13.16,37.5,12,29.91,25,10200,19.02,37.85,291.42857142857099]
["Short Bus",71221,"Hawk Caldwell","hawkcaldwell@gmail.com",45,36,54,54,"yes","A",36.71,10.99,38.630000000000003,14.38,30.8,28.3,4028,36.86,92.16,79.34,1]
["Spinnster",161,"Betsy Dodge","bdodge33@comcast.net",171,171,171,171,"yes","C",30.5,9.5,29.5,12.25,25.92,21.67,4250,22.36,39.880000000000003,186.45076850448501,1]
["Splash","USA xxx","Tom Attick","tattick@chattick.com",90,90,96,96,"yes","A",40.6,13.5,41.5,14.6,34.5,29.5,7750,23.54,51.36,134.77000000000001,1]
["Stingray",63383,"Elliot Peterson","tepeterson@dcscorp.com",129,129,129,129,"yes","B",38,10.95,32.4,12,27.9,23.8,5100,24.12,45.56,168.88508104322199,1]
["Stormy Petrel",93644,"PAX",null,168,168,168,168,"no","C"]
["Supra Turbo",2610,"Peter D'Arista","peterd@toyotamd.com",78,78,87,87,"Yes","A",30.3,9.6,33,12.8,26,24.7,2447,31.39,99.92,72.489999999999995,1]
["The Doghouse",63199,"Dan Shannon","shannon63199@verizon.net",111,111,111,111,"yes","B",40,12,35,12,29.5,25,6000,24.12,47.08,{"$f":"((Q31/(2240*POWER((P31/100),3))))","v":171.42857142857142},1]
["Triton's Fury",499,"T. J. O'Farrell","triton499@gmail.com",252,252,252,252,"no","C",31,10,32.979999999999997,12.83,28.5,20.5,8200,14.4,26.05,424.92]
["Wicked Good",93121,"Mark Gyorgy","mygorgy@dscorp.com",132,132,132,132,"yes","B",35.25,10.199999999999999,37.200000000000003,12,26.83,23.42,3800,29.81,51.7,132.06109868494099,1]
["Wild Thing",87638,"Jimmy Yurko","jimmydyurko@yahoo.com",186,186,186,186,"no","C",22.6,7.25,24.04,9.33,20.329999999999998,18.420000000000002,1160,28.1,58.28,83.13]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Old Boat Data:"]
["American Flyer",39519,"Dan Schneider","dc_schneider@msn.com",36,36,42,42,"yes","A",51.25,14.04,50.45,18.47,39.4,34.119999999999997,13000,29.96,63.34,146.10607247052599,1]
["Antagonist",217,"Eddie Sierra/Scott Roland","ed.sierra347@gmail.com",114,111,120,120,"yes","B",26.77,7.68,26.16,9.44,22.8,20.5,1750,29.6,43,90.68,1]
["Arctic Tern",93642,"PAX",null,168,168,168,168,"no","C"]
["Audrey",764,"Trevor Harney","Trevor.Harney@atkinsglobal.com",174,174,174,174,"no","C"]
["Bad Cat","063","Jim Whited","jimw625@comcast.net",39,33,48,48,"yes","A",48.36,13.84,45.17,45.17,36.5,32.700000000000003,9300,26.65,73.27,119,1]
["Badger",144,"Carl Feusaherns","feus@comcast.net",177,177,177,177,"yes","C",28.75,9.66,28,9.75,24.5,20.5,2900,24.11,46.03,150.27557431179,1]
["Blue Goose",93643,"PAX",null,168,168,168,168,"no","C"]
["Cheetah",50473,"Marc Briere","race@smsa.com",36,36,45,45,"yes","A",43.7,12.6,44.7,16.5,35.86,31.76,8150,28.76,70.08,114,1]
["Deju Vue",41299,"Douglas Aulson",null,147,147,147,147,"yes","B"]
["Easy Button",93084,"David Meiser","meiser@comcast.net",159,159,159,159,"yes","C",27.75,8.25,29.75,11.72,25.7,20,2600,27.79,46.9,145.08928571428601,1]
["Elan",43162,"Gary Shaw","garyshaw75@aol.com",153,153,153,153,"yes","C",49.5,15.33,42,11,36.83,29.5,13500,18.71,39.33,234.75762231915499,1]
["Flyer",25126,"Michael Major","mjamesmajor@gmail.com",111,111,114,114,"yes","B",40.18,11.65,42.27,15.79,34.4,27.2,8825,21.24,39.65,195.78,1]
["Gift Horse",87012,"Jimmy Yurko","jimmydyurko@gmail.com",111,111,111,111,"yes","B",null,null,null,null,null,null,null,null,null,null,1]
["J Ray","USA47","Larry Ray","mlray@gmail.com",114,114,120,120,"yes","B",26.77,7.68,26.16,9.44,22.8,20.5,1750,29.6,43,90.68,1]
["Krugerrand",53477,"Sarah Southworth","write2ss@cs.com",132,132,132,132,"yes","B",48.42,14.33,42.33,13,36.17,29.42,15300,17.77,35.47,{"$f":"((Q71/(2240*POWER((P71/100),3))))","v":268.2349766677014},1]
["Lakahi",25260,"Jim Young","youngjw1203@earthlink.net",72,72,72,72,"no","A",48,14.25,47,14.58,35.42,30,9800,26.64,50.21,162.03703703703701]
["Lickety Split",43067,"Donna Maneely","damaneely@verizon.net",168,168,168,168,"yes","C",40.86,13,35.36,11.79,31.71,25,9400,18.73,33.700000000000003,268.57142857142901]
["Natural Disaster",63243,"Thomas Moulds","tmoulds@dtiweb.net",114,114,114,114,"yes","B",36,11.75,31.5,10.75,30,27.5,3600,28.56,57.33,{"$f":"((Q74/(2240*POWER((P74/100),3))))","v":77.278093807019403},1]
["Pony Express",50588,"Jimmy Yurko","jimmydyurko@gmail.com",132,129,138,138,"yes","B",28,8.5,28,11,25,21.3,2000,27.49,61.72,92.39,1]
["Pursuit",23798,"Norm Dawley","normdawley@norms-site.com",51,45,66,66,"yes","A",52,16,55,18,47.67,37.17,18689,23.26,45.15,162.46520482011201,1]
["Rakali","USAxxx","Mark Witte","mcwitte@md.metrocast.net",90,90,96,96,"yes","A"]
["Rhumb Punch",26007,"John Edwards","rhumbpunch@msn.com",81,81,90,90,"yes","A"]
["Shamal",23827,"Jeff Carlsen",null,174,174,174,174,"yes","C",30.75,9.83,26.5,9.5,24.58,19.170000000000002,2950,23.78,46.61,187,1]
["Shermax",2276,"Max Munger","maxmunger@verizon.net",177,177,177,177,"yes","C",43,13.16,37.5,12,29.91,25,10200,19.02,37.85,291.42857142857099,1]
["Short Bus",71221,"Hawk Caldwell","hawkcaldwell@gmail.com",42,42,51,51,"yes","A",null,null,null,null,null,null,null,null,null,null,1]
["Spinnster",161,"Betsy Dodge","bdodge33@comcast.net",171,171,171,171,"yes","C",30.5,9.5,29.5,12.25,25.92,21.67,4250,22.36,39.880000000000003,186.45076850448501,1]
["Splash","USA xxx","Tom Attick","tattick@chattick.com",90,90,96,96,"yes","A"]
["Stingray",63383,"Elliot Peterson","tepeterson@dcscorp.com",129,129,129,129,"yes","B",38,10.95,32.4,12,27.9,23.8,5100,24.12,45.56,168.88508104322199,1]
["Stormy Petrel",93644,"PAX",null,168,168,168,168,"no","C"]
["Supra Turbo",2610,"Peter D'Arista","peterd@toyotamd.com",78,78,87,87,"Yes","A"]
["The Doghouse",63199,"Dan Shannon","shannon63199@verizon.net",111,111,111,111,"yes","B",40,12,35,12,29.5,25,6000,24.12,47.08,{"$f":"((Q87/(2240*POWER((P87/100),3))))","v":171.42857142857142},1]
["Valiant",60177,"John Durniak","johndurniak@yahoo.com",93,93,93,93,"no","A",58.71,18.45,50.75,16,44,35.799999999999997,31641,16.63,33.83,{"$f":"((Q88/(2240*POWER((P88/100),3))))","v":307.8598847550997}]
["Wicked Good",93121,"Mark Gyorgy","mygorgy@dscorp.com",132,132,132,132,"yes","B",35.25,10.199999999999999,37.200000000000003,12,26.83,23.42,3800,29.81,51.7,132.06109868494099,1]
["Spinnster",161,"Betsy Dodge","bdodge33@comcast.net",171,null,null,null,"yes","C",30.5,9.5,29.5,12.25,25.92,21.67,4250,22.36,39.880000000000003,{"$f":"((Q90/(2240*POWER((P90/100),3))))","v":186.45076850448498}]
["Splash","USA 173","Tom Attick","tattick@chattick.com",111,null,null,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,null,null,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,null,null,129,"yes","B",38,10.95,32.4,12,27.9,23.8,5100,24.12,45.56,168.88508104322156]
["Synergy",83096,"Peter LaRoche","no email",168,null,null,168,"no","C",39,12.5,34.25,11.5,29.96,25.25,7950,19.5,37.94,220.46261931499356]
["Tenounce",99,"John Mckinney","no email",null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,186,"yes","C",22.6,7.25,24.04,9.33,20.329999999999998,18.420000000000002,1160,31.82,54.07,82.859268190743165]
["Family Truckster","USA788","Clarke Mckinney","cmckinney@quantumsails.com",120,null,null,129,"no","B",31.5,9.5,30,12.5,26.25,22,2900,29.88,72.56,121.585542556617]

{"sheet":"ScoreSheet","index":6,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,2,2,4],[0,4,0,9]]}
["SMSA Scoring Worksheet",null,null,null,"Race Name _________________________________"]
[null,"Date : ","_____________________",null,null,"RC: ","____________________"]
[null,"Course: ","_______________________________________",null,null,null,null,null,null,null,"Finish time"]
["Boat","SailNo","Owner","Spin","NonSpin","Race Fee","Spinclass","Checked In","Start Class ","(hr)","(min)","(sec)","Notes"]
[" "," "," "," "," "," "," "]
[{"$f":"Boats!A4","v":"American Flyer"},{"$f":"Boats!B4","v":39519},{"$f":"Boats!C4","v":"Dan Schneider"},{"$f":"Boats!E4","v":36},{"$f":"Boats!H4","v":42},{"$f":"Boats!I4","v":"no"},{"$f":"Boats!J4","v":"A"}]
[{"$f":"Boats!A5","v":"Arctic Tern"},{"$f":"Boats!B5","v":93642},{"$f":"Boats!C5","v":"PAX"},{"$f":"Boats!E5","v":168},{"$f":"Boats!H5","v":168},{"$f":"Boats!I5","v":"yes"},{"$f":"Boats!J5","v":"C"}]
[{"$f":"Boats!A6","v":"Bad Cat"},{"$f":"Boats!B6","v":"063"},{"$f":"Boats!C6","v":"Jim Whited"},{"$f":"Boats!E6","v":39},{"$f":"Boats!H6","v":48},{"$f":"Boats!I6","v":"yes"},{"$f":"Boats!J6","v":"A"}]
[{"$f":"Boats!A7","v":"Badger"},{"$f":"Boats!B7","v":144},{"$f":"Boats!C7","v":"Carl Feusaherns"},{"$f":"Boats!E7","v":177},{"$f":"Boats!H7","v":177},{"$f":"Boats!I7","v":"yes"},{"$f":"Boats!J7","v":"C"}]
[{"$f":"Boats!A8","v":"Blue Boat Home"},{"$f":"Boats!B8","v":4856},{"$f":"Boats!C8","v":"Lowell Martin"},{"$f":"Boats!E8","v":231},{"$f":"Boats!H8","v":231},{"$f":"Boats!I8","v":"yes"},{"$f":"Boats!J8","v":"C"}]
[{"$f":"Boats!A9","v":"Blue Goose"},{"$f":"Boats!B9","v":93643},{"$f":"Boats!C9","v":"PAX"},{"$f":"Boats!E9","v":168},{"$f":"Boats!H9","v":168},{"$f":"Boats!I9","v":"no"},{"$f":"Boats!J9","v":"C"}]
[{"$f":"Boats!A10","v":"Cheetah"},{"$f":"Boats!B10","v":50473},{"$f":"Boats!C10","v":"Marc Briere"},{"$f":"Boats!E10","v":36},{"$f":"Boats!H10","v":45},{"$f":"Boats!I10","v":"yes"},{"$f":"Boats!J10","v":"A"}]
[{"$f":"Boats!A11","v":"Easy Button"},{"$f":"Boats!B11","v":93084},{"$f":"Boats!C11","v":"David Meiser"},{"$f":"Boats!E11","v":159},{"$f":"Boats!H11","v":159},{"$f":"Boats!I11","v":"yes"},{"$f":"Boats!J11","v":"C"}]
[{"$f":"Boats!A12","v":"Elan"},{"$f":"Boats!B12","v":43162},{"$f":"Boats!C12","v":"Gary Shaw"},{"$f":"Boats!E12","v":153},{"$f":"Boats!H12","v":153},{"$f":"Boats!I12","v":"yes"},{"$f":"Boats!J12","v":"C"}]
[{"$f":"Boats!A13","v":"Flyer"},{"$f":"Boats!B13","v":25126},{"$f":"Boats!C13","v":"Michael Major"},{"$f":"Boats!E13","v":111},{"$f":"Boats!H13","v":114},{"$f":"Boats!I13","v":"no"},{"$f":"Boats!J13","v":"B"}]
[{"$f":"Boats!A14","v":"J Ray"},{"$f":"Boats!B14","v":"USA47"},{"$f":"Boats!C14","v":"Larry Ray"},{"$f":"Boats!E14","v":114},{"$f":"Boats!H14","v":120},{"$f":"Boats!I14","v":"yes"},{"$f":"Boats!J14","v":"B"}]
[{"$f":"Boats!A15","v":"Juggernaut"},{"$f":"Boats!B15","v":51277},{"$f":"Boats!C15","v":"David Ahearn"},{"$f":"Boats!E15","v":39},{"$f":"Boats!H15","v":39},{"$f":"Boats!I15","v":"no"},{"$f":"Boats!J15","v":"A"}]
[{"$f":"Boats!A16","v":"Kraken"},{"$f":"Boats!B16","v":43289},{"$f":"Boats!C16","v":"Scott Roland"},{"$f":"Boats!E16","v":180},{"$f":"Boats!H16","v":180},{"$f":"Boats!I16","v":"yes"},{"$f":"Boats!J16","v":"C"}]
[{"$f":"Boats!A17","v":"Krugerrand"},{"$f":"Boats!B17","v":53477},{"$f":"Boats!C17","v":"Sarah Southworth"},{"$f":"Boats!E17","v":132},{"$f":"Boats!H17","v":132},{"$f":"Boats!I17","v":"yes"},{"$f":"Boats!J17","v":"B"}]
[{"$f":"Boats!A18","v":"Lickety Split"},{"$f":"Boats!B18","v":43067},{"$f":"Boats!C18","v":"Donna Maneely"},{"$f":"Boats!E18","v":168},{"$f":"Boats!H18","v":168},{"$f":"Boats!I18","v":"yes"},{"$f":"Boats!J18","v":"C"}]
[{"$f":"Boats!A19","v":"Natural Disaster"},{"$f":"Boats!B19","v":63243},{"$f":"Boats!C19","v":"Thomas Moulds"},{"$f":"Boats!E19","v":114},{"$f":"Boats!H19","v":114},{"$f":"Boats!I19","v":"yes"},{"$f":"Boats!J19","v":"B"}]
[{"$f":"Boats!A20","v":"Pony Express"},{"$f":"Boats!B20","v":50588},{"$f":"Boats!C20","v":"Jimmy Yurko"},{"$f":"Boats!E20","v":132},{"$f":"Boats!H20","v":138},{"$f":"Boats!I20","v":"yes"},{"$f":"Boats!J20","v":"B"}]
[{"$f":"Boats!A21","v":"Pursuit"},{"$f":"Boats!B21","v":23798},{"$f":"Boats!C21","v":"Norm Dawley"},{"$f":"Boats!E21","v":51},{"$f":"Boats!H21","v":66},{"$f":"Boats!I21","v":"yes"},{"$f":"Boats!J21","v":"A"}]
[{"$f":"Boats!A22","v":"Rakali"},{"$f":"Boats!B22","v":"USAxxx"},{"$f":"Boats!C22","v":"Mark Witte"},{"$f":"Boats!E22","v":90},{"$f":"Boats!H22","v":96},{"$f":"Boats!I22","v":"yes"},{"$f":"Boats!J22","v":"A"}]
[{"$f":"Boats!A23","v":"Shamal"},{"$f":"Boats!B23","v":23827},{"$f":"Boats!C23","v":"Jeff Carlsen"},{"$f":"Boats!E23","v":174},{"$f":"Boats!H23","v":174},{"$f":"Boats!I23","v":"yes"},{"$f":"Boats!J23","v":"C"}]
[{"$f":"Boats!A24","v":"Shermax"},{"$f":"Boats!B24","v":2276},{"$f":"Boats!C24","v":"Max Munger"},{"$f":"Boats!E24","v":177},{"$f":"Boats!H24","v":177},{"$f":"Boats!I24","v":"no"},{"$f":"Boats!J24","v":"C"}]
[{"$f":"Boats!A25","v":"Short Bus"},{"$f":"Boats!B25","v":71221},{"$f":"Boats!C25","v":"Hawk Caldwell"},{"$f":"Boats!E25","v":45},{"$f":"Boats!H25","v":54},{"$f":"Boats!I25","v":"yes"},{"$f":"Boats!J25","v":"A"}]
[{"$f":"Boats!A26","v":"Spinnster"},{"$f":"Boats!B26","v":161},{"$f":"Boats!C26","v":"Betsy Dodge"},{"$f":"Boats!E26","v":171},{"$f":"Boats!H26","v":171},{"$f":"Boats!I26","v":"yes"},{"$f":"Boats!J26","v":"C"}]
[{"$f":"Boats!A27","v":"Splash"},{"$f":"Boats!B27","v":"USA xxx"},{"$f":"Boats!C27","v":"Tom Attick"},{"$f":"Boats!E27","v":90},{"$f":"Boats!H27","v":96},{"$f":"Boats!I27","v":"yes"},{"$f":"Boats!J27","v":"A"}]
[{"$f":"Boats!A28","v":"Stingray"},{"$f":"Boats!B28","v":63383},{"$f":"Boats!C28","v":"Elliot Peterson"},{"$f":"Boats!E28","v":129},{"$f":"Boats!H28","v":129},{"$f":"Boats!I28","v":"yes"},{"$f":"Boats!J28","v":"B"}]
[{"$f":"Boats!A29","v":"Stormy Petrel"},{"$f":"Boats!B29","v":93644},{"$f":"Boats!C29","v":"PAX"},{"$f":"Boats!E29","v":168},{"$f":"Boats!H29","v":168},{"$f":"Boats!I29","v":"no"},{"$f":"Boats!J29","v":"C"}]
[{"$f":"Boats!A30","v":"Supra Turbo"},{"$f":"Boats!B30","v":2610},{"$f":"Boats!C30","v":"Peter D'Arista"},{"$f":"Boats!E30","v":78},{"$f":"Boats!H30","v":87},{"$f":"Boats!I30","v":"Yes"},{"$f":"Boats!J30","v":"A"}]
[{"$f":"Boats!A31","v":"The Doghouse"},{"$f":"Boats!B31","v":63199},{"$f":"Boats!C31","v":"Dan Shannon"},{"$f":"Boats!E31","v":111},{"$f":"Boats!H31","v":111},{"$f":"Boats!I31","v":"yes"},{"$f":"Boats!J31","v":"B"}]
[{"$f":"Boats!A32","v":"Triton's Fury"},{"$f":"Boats!B32","v":499},{"$f":"Boats!C32","v":"T. J. O'Farrell"},{"$f":"Boats!E32","v":252},{"$f":"Boats!H32","v":252},{"$f":"Boats!I32","v":"no"},{"$f":"Boats!J32","v":"C"}]
[{"$f":"Boats!A33","v":"Wicked Good"},{"$f":"Boats!B33","v":93121},{"$f":"Boats!C33","v":"Mark Gyorgy"},{"$f":"Boats!E33","v":132},{"$f":"Boats!H33","v":132},{"$f":"Boats!I33","v":"yes"},{"$f":"Boats!J33","v":"B"}]
[{"$f":"Boats!A34","v":"Wild Thing"},{"$f":"Boats!B34","v":87638},{"$f":"Boats!C34","v":"Jimmy Yurko"},{"$f":"Boats!E34","v":186},{"$f":"Boats!H34","v":186},{"$f":"Boats!I34","v":"no"},{"$f":"Boats!J34","v":"C"}]
[]
[]
[]
[]
[]
[null,null,"Boats without Handicap ratings will be scored with a 0 rating.  Scores will be updated when the Provisional Handicap is assigned."]

{"sheet":"RSinput","index":7,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Sail","BoatName","PHRF",null,null,null,"Finish","Division"]

{"sheet":"Course","index":8,"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,20,20,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]
["E",5,5,null,null,"E",5,5,null,"K",10,10]
["K",10,10,null,null,"G",6,6,null,"L",11,11]
["L",11,11,null,null,"H",7,7,null,"M",12,12]
["M",12,12,null,null,"I",8,8,null,"S",17,17]
["S",17,17,null,null,"J",9,9,null,"T",14,14]
["T",14,14,null,null,"K",10,10,null,"X",16,16]
["V",16,16,null,null,"L",11,11,null,"Y",18,18]
["X",20,20,null,null,"M",12,12,null,"Z",19,19]
["Y",18,18,null,null,"S",17,17]
["Z",19,19,null,null,"T",14,14]
[null,null,null,null,null,"V",16,16]
[null,null,null,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.92,2.54,0.9,2.38,1.41,2.35,1.35]
["B",0.94,0,2.4700000000000002,1.28,2.82,4.47,5.01,5.53,2.75,3.22,3.71,0,1.6,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.28,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.45,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.63,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.11,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.45,1.63,2.11,0,0,0,1.01,1.55,0.56999999999999995,1.55,0.52]
["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.01,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.55,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.56999999999999995,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.52,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]