{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Scoring Sheet","Peel Raw Data","Original Sheet","MWE Results"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"1904"}

{"sheet":"Instructions","index":0,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,0,4,1],[28,0,28,1]]}
[]
[]
[null,"Last edited by Brad Russell, 6:30 on 3/19/2013"]
[]
["Thistle Southern Series Scorer Instructions"]
[1,"Copy the Orange Peel scores from HTML document, copying ONLY the scoring table (exclude all the other info)"]
[2,"Delete all data in 'Peel Raw Data' sheet and delete any rows with merged cells (shouldn't be any)"]
[3,"Click upper left cell of sheet, select Paste > Paste Special > Text"]
[4,"Verify the data pasted in correctly and Race 1 for the Peel is in Column F and Boat Numbers are in Column B"]
[null,"Manually change scores with letters to the correct numerical score"]
[5,"Click this button to clean all letters/characters from the scores: "]
[6,"Check 'Scoring Sheet' to make sure no race results include letters or characters"]
[7,"Check Series Score, Raw Sum, Races Count, & Throwout Values to make sure they pass the sanity test"]
[8,"Separately for Skipper & Open divisions, highlight columns B through W and sort by column W (Series Score)"]
[9,"Check for ties - Rank calculation will give them the same rank, but doesn't break ties according to US Sailing rules - rearrange rows manually"]
[10,"Hide any columns you don't want displayed on printout"]
[11,"Save & Print"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Notes/To Do"]
[null,"Clean Scores only checks for DNF, DNS, DSQ, OCS, and RDG.  Are there any others?"]
[null,"Check boat numbers for crew…I just filled in the MWE number for crew who didn't have another number listed"]
[null,"Setup 'Scoring Sheet' to auto populate with the output data you get from SPYC/MWE - send me the raw data and I can work on that"]
[null,"Add MWE place to hidden column on 'Scoring Sheet'"]
[null,"Currently hardcoded for 7 races at MWE and 0-5 at the Peel.  Need to make it more flexible for next year"]
[null,"Update logo to 2013"]
[null,"Format 'Scoring Sheet' for print with desired borders, etc"]
[null,"Find a workaround for leaving letters in scores and getting scores to sum properly, if it really matters"]
[]
[]
["Done","2 scoring programs use different slash for scores with letters…need to edit macro to check for both"]

{"sheet":"Scoring Sheet","index":1,"n_rows":42,"n_cols":32,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,6,23],[7,6,7,14],[8,6,8,14],[9,6,9,14],[12,0,12,23],[7,18,7,32],[8,18,8,32],[9,18,9,32],[24,0,24,23]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Midwinters East Championship",null,null,null,null,null,null,null,null,null,null,null,"Orange Peel Regatta"]
[null,null,null,null,null,null,"St. Petersburg Yacht Club",null,null,null,null,null,null,null,null,null,null,null,"The Florida Yacht Club"]
[null,null,null,null,null,null,"March 3-7, 2014",null,null,null,null,null,null,null,null,null,null,null,"March 22-23, 2014"]
[]
["Place","MWE Sail #","Peel Sail #","Competitor","Hometown",null,1,2,3,4,5,6,7,8,"Total","W/1\nDiscard","MWE\nFinish",null,1,2,3,4,5,"Series Score","Raw Sum","Races Count","Large 1 MWE","Large 2 MWE","Large 1 Peel","Large 2 Peel","Discard 1","Discard 2"]
["Skipper Division"]
[{"$f":"_xlfn.RANK.EQ(X14,$X$14:$X$24,1)","v":{"$error":"#NAME?"}},3976,3976,"Greg Griffin",null,null,6,2,1,1,5,1,1,2,{"$f":"SUM(G14:N14)","v":19},{"$f":"SUMIF(G14:N14,\"<\"&MAX(G14:N14))","v":13},null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C14,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":2},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C14,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":3},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C14,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C14,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C14,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},{"$f":"IF((SUM(COUNT($G14:$N14),COUNT($S14:$W14)))<10,SUM($G14:$N14)+SUM($S14:$W14)-$AE14,SUM($G14:$N14)+SUM($S14:$W14)-$AE14-$AF14)","v":13},{"$f":"SUM(G14:N14,S14:W14)","v":24},{"$f":"SUM(COUNT($G14:$N14),COUNT($S14:$W14))","v":10},{"$f":"IF(ISERR(LARGE($G14:$N14,1)),0,LARGE($G14:$N14,1))","v":6},{"$f":"IF(ISERR(LARGE($G14:$N14,2)),0,LARGE($G14:$N14,2))","v":5},{"$f":"IF(ISERR(LARGE($S14:$W14,1)),0,LARGE($S14:$W14,1))","v":3},{"$f":"IF(ISERR(LARGE($S14:$W14,2)),0,LARGE($S14:$W14,2))","v":2},{"$f":"LARGE(AA14:AD14,1)","v":6},{"$f":"LARGE(AA14:AD14,2)","v":5}]
[{"$f":"_xlfn.RANK.EQ(X15,$X$14:$X$24,1)","v":{"$error":"#NAME?"}},4035,4035,"Paul Abdullah",null,null,7,6,3,2,6,7,2,6,39,25,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C15,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C15,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C15,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C15,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C15,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},27,41,{"$f":"SUM(COUNT($G15:$N15),COUNT($S15:$W15))","v":10},7,7,1,1,{"$f":"LARGE(AA15:AD15,1)","v":7},{"$f":"LARGE(AA15:AD15,2)","v":7}]
[{"$f":"_xlfn.RANK.EQ(X16,$X$14:$X$24,1)","v":{"$error":"#NAME?"}},779,779,"Kevin Bradley",null,null,2,10,10,19,3,13,13,8,78,59,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C16,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":27},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C16,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":6},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C16,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C16,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C16,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},65,111,10,19,13,27,6,27,19]
[4,3652,3652,"Tom Hubbell",null,null,13,14,9,9,9,6,35,5,100,65,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C17,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":11},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C17,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":8},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C17,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C17,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C17,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},70,119,10,35,14,11,8,35,14]
[{"$f":"_xlfn.RANK.EQ(X18,$X$14:$X$24,1)","v":{"$error":"#NAME?"}},870,870,"Stu Gulke",null,null,11,15,7,8,18,9,4,13,85,67,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C18,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":7},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C18,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":11},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C18,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C18,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C18,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},70,103,10,18,15,11,7,18,15]
[6,4037,4037,"Downing Nightingdale",null,null,9,7,8,17,27,11,14,35,128,93,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C19,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":8},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C19,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":9},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C19,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C19,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C19,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},83,145,10,35,27,9,8,35,27]
[7,3624,3624,"Gerry Christman",null,null,26,25,30,23,32,24,22,35,null,null,null,null,20,16,null,null,null,186]
[8,4032,4032,"Sam Brauer",null,null,28,30,23,26,31,20,21,21,null,null,null,null,29,19,null,null,null,187]
[{"$f":"_xlfn.RANK.EQ(X22,$X$14:$X$24,1)","v":{"$error":"#NAME?"}},4045,4045,"David Deptula",null,null,27,28,27,13,28,35,35,35,{"$f":"SUM(G22:N22)","v":228},{"$f":"SUMIF(G22:N22,\"<\"&MAX(G22:N22))","v":123},null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C22,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":14},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C22,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":21},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C22,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C22,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C22,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},{"$f":"IF((SUM(COUNT($G22:$N22),COUNT($S22:$W22)))<10,SUM($G22:$N22)+SUM($S22:$W22)-$AE22,SUM($G22:$N22)+SUM($S22:$W22)-$AE22-$AF22)","v":193},{"$f":"SUM(G22:N22,S22:W22)","v":263},{"$f":"SUM(COUNT($G22:$N22),COUNT($S22:$W22))","v":10},{"$f":"IF(ISERR(LARGE($G22:$N22,1)),0,LARGE($G22:$N22,1))","v":35},{"$f":"IF(ISERR(LARGE($G22:$N22,2)),0,LARGE($G22:$N22,2))","v":35},{"$f":"IF(ISERR(LARGE($S22:$W22,1)),0,LARGE($S22:$W22,1))","v":21},{"$f":"IF(ISERR(LARGE($S22:$W22,2)),0,LARGE($S22:$W22,2))","v":14},{"$f":"LARGE(AA22:AD22,1)","v":35},{"$f":"LARGE(AA22:AD22,2)","v":35}]
[10,4023,4023,"Edward John",null,null,30,34,31,30,25,28,23,24,null,null,null,null,26,25,null,null,null,211]
[]
["Open Division"]
[{"$f":"_xlfn.RANK.EQ(X26,$X$26:$X$39,1)","v":{"$error":"#NAME?"}},3976,3976,"Mark Reddaway",null,null,6,2,1,1,5,1,1,2,{"$f":"SUM(G26:N26)","v":19},22,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C26,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":2},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C26,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":3},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C26,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C26,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C26,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},{"$f":"IF((SUM(COUNT($G26:$N26),COUNT($S26:$W26)))<10,SUM($G26:$N26)+SUM($S26:$W26)-$AE26,SUM($G26:$N26)+SUM($S26:$W26)-$AE26-$AF26)","v":13},{"$f":"SUM(G26:N26,S26:W26)","v":24},10,{"$f":"IF(ISERR(LARGE($G26:$N26,1)),0,LARGE($G26:$N26,1))","v":6},{"$f":"IF(ISERR(LARGE($G26:$N26,2)),0,LARGE($G26:$N26,2))","v":5},{"$f":"IF(ISERR(LARGE($S26:$W26,1)),0,LARGE($S26:$W26,1))","v":3},{"$f":"IF(ISERR(LARGE($S26:$W26,2)),0,LARGE($S26:$W26,2))","v":2},{"$f":"LARGE(AA26:AD26,1)","v":6},{"$f":"LARGE(AA26:AD26,2)","v":5}]
[{"$f":"_xlfn.RANK.EQ(X27,$X$26:$X$39,1)","v":{"$error":"#NAME?"}},3976,3976,"Ryanne Gallagher",null,null,6,2,1,1,5,1,1,2,19,22,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C27,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":2},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C27,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":3},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C27,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C27,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C27,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},13,24,10,6,5,3,2,{"$f":"LARGE(AA27:AD27,1)","v":6},{"$f":"LARGE(AA27:AD27,2)","v":5}]
[{"$f":"_xlfn.RANK.EQ(X28,$X$26:$X$39,1)","v":{"$error":"#NAME?"}},4035,4035,"Marie Thompson",null,null,7,6,3,2,6,7,2,6,39,20,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C28,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C28,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C28,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C28,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C28,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},27,41,10,7,7,1,1,7,7]
[4,4033,3997,"Abby Freeman",null,null,5,5,4,4,4,3,7,7,null,null,null,null,15,2,null,null,null,34]
[5,3945,4045,"Jack Finefrock",null,null,1,8,19,5,10,4,3,15,{"$f":"SUM(G30:N30)","v":65},17,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C30,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":14},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C30,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":21},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C30,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C30,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C30,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},{"$f":"IF((SUM(COUNT($G30:$N30),COUNT($S30:$W30)))<10,SUM($G30:$N30)+SUM($S30:$W30)-$AE30,SUM($G30:$N30)+SUM($S30:$W30)-$AE30-$AF30)","v":60},{"$f":"SUM(G30:N30,S30:W30)","v":100},{"$f":"SUM(COUNT($G30:$N30),COUNT($S30:$W30))","v":10},{"$f":"IF(ISERR(LARGE($G30:$N30,1)),0,LARGE($G30:$N30,1))","v":19},{"$f":"IF(ISERR(LARGE($G30:$N30,2)),0,LARGE($G30:$N30,2))","v":15},{"$f":"IF(ISERR(LARGE($S30:$W30,1)),0,LARGE($S30:$W30,1))","v":21},{"$f":"IF(ISERR(LARGE($S30:$W30,2)),0,LARGE($S30:$W30,2))","v":14},{"$f":"LARGE(AA30:AD30,1)","v":21},{"$f":"LARGE(AA30:AD30,2)","v":19}]
[6,870,870,"Chris Alexander",null,null,11,15,7,8,18,9,4,13,null,null,null,null,7,11,null,null,null,70]
[6,3652,3652,"Kathy Duckworth",null,null,13,14,9,9,9,6,35,5,100,39,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C32,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":11},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C32,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":8},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C32,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C32,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C32,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},70,119,10,35,14,11,8,35,14]
[8,4037,3997,"Bill Wiggins",null,null,9,7,8,17,27,11,14,35,128,62,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C33,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":15},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C33,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":2},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C33,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C33,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C33,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},83,145,10,35,27,15,2,35,27]
[8,4037,4037,"Kayla Bennett",null,null,9,7,8,17,27,11,14,35,128,67,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C34,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":8},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C34,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":9},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C34,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C34,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C34,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},83,145,10,35,27,9,8,35,27]
[10,1473,3841,"Brad Russell",null,null,15,13,5,7,20,10,35,35,140,62,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C35,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":23},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C35,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":7},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C35,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C35,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C35,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},100,170,10,35,35,23,7,35,35]
[11,3849,3725,"Craig Ambler",null,null,19,16,20,21,14,14,18,11,null,null,null,null,5,17,null,null,null,114]
[11,3849,3725,"Diana Young-Paiva",null,null,19,16,20,21,14,14,18,11,{"$f":"SUM(G37:N37)","v":133},20,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C37,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C37,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":17},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C37,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C37,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C37,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},{"$f":"IF((SUM(COUNT($G37:$N37),COUNT($S37:$W37)))<10,SUM($G37:$N37)+SUM($S37:$W37)-$AE37,SUM($G37:$N37)+SUM($S37:$W37)-$AE37-$AF37)","v":114},{"$f":"SUM(G37:N37,S37:W37)","v":155},{"$f":"SUM(COUNT($G37:$N37),COUNT($S37:$W37))","v":10},{"$f":"IF(ISERR(LARGE($G37:$N37,1)),0,LARGE($G37:$N37,1))","v":21},{"$f":"IF(ISERR(LARGE($G37:$N37,2)),0,LARGE($G37:$N37,2))","v":20},{"$f":"IF(ISERR(LARGE($S37:$W37,1)),0,LARGE($S37:$W37,1))","v":17},{"$f":"IF(ISERR(LARGE($S37:$W37,2)),0,LARGE($S37:$W37,2))","v":5},{"$f":"LARGE(AA37:AD37,1)","v":21},{"$f":"LARGE(AA37:AD37,2)","v":20}]
[13,1473,3709,"Catherine Ryals",null,null,15,13,5,7,20,10,35,35,{"$f":"SUM(G38:N38)","v":140},67,null,null,{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!E$1)=1,VLOOKUP($C38,'Peel Raw Data'!$B:$O,5,FALSE),\"\"),\"\")","v":24},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!F$1)=1,VLOOKUP($C38,'Peel Raw Data'!$B:$O,6,FALSE),\"\"),\"\")","v":22},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!H$1)=1,VLOOKUP($C38,'Peel Raw Data'!$B:$O,7,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!I$1)=1,VLOOKUP($C38,'Peel Raw Data'!$B:$O,8,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNT('Peel Raw Data'!J$1)=1,VLOOKUP($C38,'Peel Raw Data'!$B:$O,9,FALSE),\"\"),\"\")","v":""},{"$f":"IF((SUM(COUNT($G38:$N38),COUNT($S38:$W38)))<10,SUM($G38:$N38)+SUM($S38:$W38)-$AE38,SUM($G38:$N38)+SUM($S38:$W38)-$AE38-$AF38)","v":116},{"$f":"SUM(G38:N38,S38:W38)","v":186},{"$f":"SUM(COUNT($G38:$N38),COUNT($S38:$W38))","v":10},{"$f":"IF(ISERR(LARGE($G38:$N38,1)),0,LARGE($G38:$N38,1))","v":35},{"$f":"IF(ISERR(LARGE($G38:$N38,2)),0,LARGE($G38:$N38,2))","v":35},{"$f":"IF(ISERR(LARGE($S38:$W38,1)),0,LARGE($S38:$W38,1))","v":24},{"$f":"IF(ISERR(LARGE($S38:$W38,2)),0,LARGE($S38:$W38,2))","v":22},{"$f":"LARGE(AA38:AD38,1)","v":35},{"$f":"LARGE(AA38:AD38,2)","v":35}]
[14,3624,3624,"Phillip Christman",null,null,26,25,30,23,32,24,22,35,null,null,null,null,20,16,null,null,null,186]
[15,4032,4032,"Sveinn Bragason",null,null,28,30,23,26,31,20,21,21,null,null,null,null,29,19,null,null,null,187]
[16,4045,4045,"Sally Rusk",null,null,27,28,27,13,28,35,35,35,null,null,null,null,14,21,null,null,null,193]
[17,4023,4023,"Tory Gibbs",null,null,30,34,31,30,25,28,23,24,null,null,null,null,26,25,null,null,null,211]

{"sheet":"Peel Raw Data","index":2,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Pos","Sail","Boat","Skipper",1,2,"Total"]
["Points","Pos"]
[1,4035," "," Abdullah, Paul",1,1,1,1]
[2,3976," "," Griffin, Greg",2,2,3,2]
[3,3854," "," Vanderhorst, Surge",9,9,4,3]
[4,1915," "," Adams, Sean",10,10,5,4]
[5,3997," "," Griffin, Scott",15,15,2,5]
[6,4037," "," Nightingale III, Downing",8,8,9,6]
[7,3985," "," Paisner, Sara",4,4,14,7]
[8,870," "," Grulke, Stu",7,7,11,8]
[9,3998," "," Roberts, Jim",6,6,13,9]
[10,3652," "," Hubbell, Tom",11,11,8,10]
[11,3725," "," Norton, John",5,5,17,11]
[12,3975," "," Ross, Mike",13,13,10,12]
[13,4007," "," Vaughan, Loy",12,12,15,13]
[14,1," "," Klotz, Chris",16,16,12,14]
[15,3841," "," Russell, Brad",23,23,7,15]
[16,3883," "," Reddaway, David",3,3,29,16]
[17,779," "," Bradley, Kevin",27,27,6,17]
[18,4045," "," Deptula, David",14,14,21,18]
[19,3624," "," Christman, Gerry",20,20,16,19]
[20,3579," "," Collins, Reid",17,17,20,20]
[21,3682," "," Vaughan, Graham",19,19,18,21]
[22,3739," "," Cardoze, Steven",18,18,24,22]
[23,3709," "," Derr, Bill",24,24,22,23]
[24,4032," "," Brauer, Sam",29,29,19,24]
[25,3905," "," Coker, Adam",22,22,26,25]
[26,3828," "," Russell, Dan",21,21,28,26]
[27,976," "," Fewell, Johnny",28,28,23,27]
[28,4023," "," John, Edward",26,26,25,28]
[29,4031," "," Wagner, Larry",30,30,27,29]
[30,3600," "," Glenn, Tommy",25,25,33,30]
[31,1995," "," Graham, Laura",31,31,30,31]
[32,3868," "," Woodard, Amy",32,32,33,32]

{"sheet":"Original Sheet","index":3,"n_rows":53,"n_cols":22,"rows_kept":53,"cut":false,"hidden":false,"merged":[[8,16,8,19],[9,16,9,19],[0,0,6,21],[29,0,29,21],[7,5,7,12],[8,5,8,12],[9,5,9,12],[7,16,7,19],[12,0,12,21]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Midwinters East Championship",null,null,null,null,null,null,null,null,null,null,"Orange Peel Regatta"]
[null,null,null,null,null,"St. Petersburg Yacht Club",null,null,null,null,null,null,null,null,null,null,"The Florida Yacht Club"]
[null,null,null,null,null,"March 2-8, 2013",null,null,null,null,null,null,null,null,null,null,"March 22-24, 2013"]
[]
["Place","Sail #","Competitor","Hometown",null,1,2,3,4,5,6,7,"Total","W/1\nDiscard","MWE\nFinish",null,1,2,3,4,5,"Series\nTotal"]
["Skipper Division"]
[1,4034,"Skip Dieball ","Rochester, NY",null,1,4,4,1,2,1,2,{"$f":"SUM(F14:L14)","v":15},{"$f":"SUMIF(F14:L14,\"<\"&MAX(F14:L14))","v":7},2]
[2,3969,"Mike Ingham","Taylors, SC","Jacksonville, FL",6,10,1,2,6,3,1,{"$f":"SUM(F15:L15)","v":29},{"$f":"SUMIF(F15:L15,\"<\"&MAX(F15:L15))","v":19},4]
[3,3839,"Allan Terhune","Jacksonville, FL","Mason, OH",2,14,2,4,1,4,8,{"$f":"SUM(F16:L16)","v":35},21,3]
[4,3901,"Paul Abdullah","Charleston, SC","Nashville, TN",14,13,5,3,3,2,3,{"$f":"SUM(F17:L17)","v":43},29,5]
[5,3841,"Brad Russell","Bloomington, IL",null,3,1,9,19,8,5.3,5,{"$f":"SUM(F18:L18)","v":50.3},{"$f":"SUMIF(F18:L18,\"<\"&MAX(F18:L18))","v":31.3},15]
[7,4017,"Chris Klotz","Asheville, NC","St. Petersburg, FL",7,19,8,9,9,7,6,{"$f":"SUM(F19:L19)","v":65},{"$f":"SUMIF(F19:L19,\"<\"&MAX(F19:L19))","v":46},16]
[10,3810,"Tom Hubbell ",null,"Leawood, KS",39,2,13,24,7,5,10,100,{"$f":"SUMIF(F20:L20,\"<\"&MAX(F20:L20))","v":61},24]
[11,844,"Craig Koschalk",null,"Charleston, SC",20,45,11,5,5,10.3,10.3,106.6,61.599999999999994,26]
[12,3624,"Michael Gillian",null,"Newark, DE",25,7,12,15,17,23,21,120,95,31]
[13,16,"Dan Russell, & Kelly Holleran",null,"Baltimore, MD",28,21,28,27,13,27,20,164,108,36]
[14,4031,"Downing Nightingale","Birmingham, AL","Jacksonville, FL",18,45,22,13,20,18.3,28,{"$f":"SUM(F24:L24)","v":164.3},{"$f":"SUMIF(F24:L24,\"<\"&MAX(F24:L24))","v":119.3},22]
[15,3682,"Graham Vaughan",null,"Townsend,DE",24,35,29,33,25,26,30,{"$f":"SUM(F25:L25)","v":202},{"$f":"SUMIF(F25:L25,\"<\"&MAX(F25:L25))","v":167},30]
[16,1329,"Scott Latham",null,30,16,30,27,20,31,45,37,206,161,37]
[17,3735,"John Hutt, Max Hutt & Mark Pytel",null,null,36,41,31,35,37,38,31]
[18,4023,"Edward John",null,null,33,38,40,42,42,39,42]
[19,16,"David Deptula",null,"Lizella, GA",42,40,41,41,41,37,38,280,{"$f":"SUMIF(F29:L29,\"<\"&MAX(F29:L29))","v":238},39]
["Open Division"]
[1,4034,"Abby Freeman","Jacksonville, FL",null,1,4,4,1,2,1,2,{"$f":"SUM(F31:L31)","v":15},22,4]
[1,4034," Jeff Eiber","Jacksonville, FL",null,1,4,4,1,2,1,2,{"$f":"SUM(F32:L32)","v":15},22,4]
[3,3839," Katie Terhune","Columbus, OH",null,2,14,2,4,1,4,8,{"$f":"SUM(F33:L33)","v":35},20,3]
[4,3841,"Christy Illius","Columbus, OH",null,3,1,9,19,8,5.3,5,50.3,20,3]
[4,3841,"Mark Gise",null,"Kansas City, MO",3,1,9,19,8,5.3,5,{"$f":"SUM(F35:L35)","v":50.3},17,2]
[6,4017,"Antoinette Klotz",null,"?",7,19,8,9,9,7,6,65,{"$f":"SUMIF(F36:L36,\"<\"&MAX(F36:L36))","v":46},5]
[6,"4017/3901"," Chris LaBorde",null,"Charleston, SC",7,19,8,9,9,7,6,65,62,15]
[8,"4033/3976","Jessica Bradburn","Akron, OH","Glendale, MO",4,18,23,11,10,10.8,13,89.8,39,10]
[8,3652,"Christine Rice","Toledo, OH","Knoxville, TN",39,2,13,24,7,5,10,100,39,10]
[8,3652,"John Yingling","Charlestown, MA",null,39,2,13,24,7,5,10,100,62,14]
[11,4028,"Lauren O'Hara",null,"St. Petersburg, FL",20,45,11,5,5,10.3,10.3,106.6,67,16]
[12,4028,"Karl Felger","Charlestown, MA",null,20,45,11,5,5,10.3,10.3,106.6,67,12]
[13,"821\n/844"," Beryl Foster","Jacksonville, FL",null,25,7,12,15,17,23,21,{"$f":"SUM(F43:L43)","v":120},43,9]
[16,3845,"Kevin Tschantz","Akron, OH","Las Vegas, NV",15,16,7,21,21,20,14,114,107,20]
[17,3828," Bill Wiggins","Knoxville, TN","Jacksonville, FL",28,21,28,27,13,27,20,164,127,22]
[18,4032,"Kayla Bennett","Tom & \"B\"","Chaleston, SC",18,45,22,13,20,18.3,28,164.3,151,26]
[19,4032,"Dan Borrer","Bloomington, IL",null,18,45,22,13,20,18.3,28,164.3,163,31]
[20,"3810/4028","Tim Fitzgerald","Hixson, TN","?",12,24,33,29,29,19,19,{"$f":"SUM(F48:L48)","v":165},133,23]
[21,"3682/3464"," Suzanne Kissel",null,null,24,35,29,33,25,26,30]
[22,1329,"Aaron Holland",null,null,16,30,27,20,31,45,37,206,219,39]
[null,"3732/3579","Eleanor Newnham",null,null,34,12,37,36,33,29,27]
[null,4023,"Victoria Gibb",null,null,33,38,40,42,42,39,42]
[null,16,"Sally Rusk",null,null,42,40,41,41,41,37,38]

{"sheet":"MWE Results","index":4,"n_rows":108,"n_cols":12,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["St. Petersburg Yacht Club"]
["2014 Thistles Midwinters East Regatta"]
["January 16-21, 2014"]
["Final"]
["All BoatsSeries Summary"]
["Pl","Sail","Crew","Tot",1,2,3,4,5,6,7,8]
[1,3976,"G.Griffin",19,6,2,1,1,5,1,1,2]
[null,null,"M.Reddaway"]
[null,null,"R.Gallagher"]
[2,3969,"M.Ingham",27,3,1,2,3,1,2,6,9]
[null,null,"D.Stehle"]
[null,null,"S.Paisley"]
[3,4035,"P.Abdullah",39,7,6,3,2,6,7,2,6]
[null,null,"K.Felger"]
[null,null,"M.Thompson"]
[4,4033,"B.Swingly",39]
[null,null,"J.Eiber"]
[null,null,"A.Freeman"]
[5,4028,"C.Koschalk",60,8,3,18,18,2,5,5,1]
[null,null,"L.O'Hara"]
[null,null,"J.Shedden"]
[6,3945,"J.Finefrock",65,1,8,19,5,10,4,3,15]
[null,null,"K.Finefrock"]
[null,null,"B.Weible"]
[7,779,"K.Bradley",78,2,10,10,19,3,13,13,8]
[null,null,"E.Frissell"]
[null,null,"M.Dubik"]
[8,870,"S.Grulke",85,11,15,7,8,18,9,4,13]
[null,null,"C.Alexander"]
[null,null,"B.Lebowski"]
[9,3874,"J.Ridder",95,4,19,14,10,8,8,15,17]
[null,null,"E.Hardy"]
[null,null,"L.Miller"]
[10,3889,"C.Glover",97,14,11,11,12,23,12,11,3]
[null,null,"P.Nuechterlein"]
[null,null,"K.Finefrock"]
[11,3652,"T.Hubbell",100,13,14,9,9,9,6,"35\\DNF",5]
[null,null,"K.Duckworth"]
[null,null,"J.Yingling"]
[12,3869,"D.HulseCo",104,12,18,16,11,16,18,9,4]
[null,null,"I.MarshCo"]
[null,null,"A.Liggett"]
[13,821,"L.Liggett",118,25,12,6,31,7,17,8,12]
[null,null,"B.Liggett"]
[null,null,"L.vanWiggler"]
[14,3979,"J. Gillian",118,23,20,15,6,13,21,10,10]
[null,null,"M.Gillian"]
[null,null,"M.Gillian"]
[15,3858,"B.Harrison",122,17,9,17,25,11,15,12,16]
[null,null,"R.Harrison"]
[null,null,"M.Hennessy"]
[16,4037,"D.NightingaleIII",128,9,7,8,17,27,11,14,"35\\DNS"]
[null,null,"B.Wiggins"]
[null,null,"K.Bennett"]
[17,3849,"J.Howell",133,19,16,20,21,14,14,18,11]
[null,null,"D.Young-Paiva"]
[null,null,"C.Ambler"]
[18,1473,"K.Arrow",140,15,13,5,7,20,10,"35\\DNC","35\\DNC"]
[null,null,"B.Russell"]
[null,null,"C.Ryals"]
[19,4020,"M.Calore",155,18,4,22,28,21,19,25,18]
[null,null,"M.Andrew"]
[null,null,"A.Lagoutchev"]
[20,4003,"M.McBride",166,16,22,25,27,15,22,16,23]
[null,null,"K.McBride"]
[null,null,"K.Mahaney"]
[21,3664,"W.Balsiger",171,20,17,12,15,12,25,"35\\DNF","35\\DNF"]
[null,null,"A.Sanders"]
[null,null,"J.Duckworth"]
[22,3952,"E.McMaster",175,21,23,32,20,24,16,20,19]
[null,null,"S.Issler"]
[null,null,"B.Jahic"]
[23,3973,"B.McCutcheon",188,10,29,13,14,29,23,"35\\DNC","35\\DNC"]
[null,null,"P.Metcalf"]
[null,null,"F.Goetz"]
[24,3687,"S.Buehler",193,32,26,21,29,19,29,17,20]
[null,null,"M.Farrugia"]
[null,null,"D.Bower"]
[25,4026,"M.Udell",197,29,24,29,34,22,26,19,14]
[null,null,"J.Hutt"]
[null,null,"N.Luegers"]
[26,4032,"S.Brauer",200,28,30,23,26,31,20,21,21]
[null,null,"S.Bragasson"]
[null,null,"G.GarethEich"]
[27,3788,"B.France",214,24,27,28,16,17,32,"35\\DNF","35\\DNF"]
[null,null,"K.Tshantz"]
[null,null,"C.Tshantz"]
[28,3624,"G.Chistman",217,26,25,30,23,32,24,22,"35\\DNF"]
[null,null,"P.Christman"]
[null,null,"R.Wojnar"]
[29,4023,"E.John",225,30,34,31,30,25,28,23,24]
[null,null,"T.Gibb"]
[null,null,"J.Virden"]
[30,3856,"R.Wood",226,22,33,24,24,26,27,"35\\DNF","35\\DNC"]
[null,null,"K.Wood"]
[null,null,"L.Wood"]
[31,4045,"D.Deptula",228,27,28,27,13,28,"35\\OCS","35\\DNF","35\\DNS"]
[null,null,"S.Rusk"]
[null,null,"A.Vanderheyden"]
[32,3077,"G.Bonner",241,33,32,34,32,33,31,24,22]
[null,null,"R.Bonner"]
[null,null,"C.Smith"]
[33,4021,"C.Annand",242,31,21,26,33,"28\\RDG",33,"35\\DNF","35\\DNS"]
[null,null,"M.Rendon"]
[null,null,"K.Leef"]
[34,3450,"R.Romer",250,34,31,33,22,30,30,"35\\DNC","35\\DNC"]
[null,null,"M.Pytell"]
[null,null,"L.Hoffman"]