{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Von","ScoreList","BattleSummary","Nats Awards","Potential Cap List","Master","Captain","Campaign Master","MIN Sept Sat 1","Min Sept Sat 2","Min Sept Sat 3","Min Sept Sun 1","Min Sept Sun 2","Instructions"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":1},"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":"Von","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Row Labels","Sum of Score",null,null,"List of Battles"]
["Tyler Helland",10631.798245614034,null,null,"MIN Sept"]
["Tom Palmer",10431.798245614034]
["Andy Terpstra",9981.1523934143315]
["Zach Hoernemann",8960.7671474602103]
["Bob Hoernemann",8443.6584511011934]
["McCoy Helland",7410.756200846944]
["Richard Whitsell",6572.2711870886642]
["Mark Roe",5181.2943262411354]
["Peter Ellison",4812.6934712824186]
["Kas Gaigalas",4539.7852960312302]
["Mike Smith",4459.7352135691699]
["Matthew Larson",3364.2898217366301]
["(blank)"]
["Grand Total",84790.000000000015]

{"sheet":"ScoreList","index":1,"n_rows":111,"n_cols":10,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
["Event ID","Battle ID","Battle Type","Captain","Class","Score","Damage","Sink","All Sorties","Individual Pts"]
["MIN Sept","Sat 1","Fleet","Andy Terpstra",6,1941.5094339622642,3060,0,1]
["MIN Sept","Sat 1","Fleet","Kas Gaigalas",6,1741.5094339622642,1730,1,1]
["MIN Sept","Sat 1","Fleet","Peter Ellison",4,1553.2075471698113,580,0,1]
["MIN Sept","Sat 1","Fleet","Mark Roe",6,1789.5833333333335,1610,0,1]
["MIN Sept","Sat 1","Fleet","Mike Smith",4,1553.2075471698113,1310,0,1]
["MIN Sept","Sat 1","Fleet","Richard Whitsell",2,1359.0566037735848,80,0,1]
["MIN Sept","Sat 1","Fleet","Bob Hoernemann",6,1941.5094339622642,1830,0,1]
["MIN Sept","Sat 1","Fleet","Tyler Helland",7,1789.5833333333335,1910,0,1]
["MIN Sept","Sat 1","Fleet","Tom Palmer",6,1589.5833333333335,4210,1,1]
["MIN Sept","Sat 1","Fleet","Zach Hoernemann",6,1789.5833333333335,1980,0,1]
["MIN Sept","Sat 1","Fleet","McCoy Helland",4,1431.6666666666665,580,0,1]
["Min Sept","Sat 2","Fleet","Zach Hoernemann",6,2234.8837209302324,1760,0,1]
["Min Sept","Sat 2","Fleet","Andy Terpstra",6,2234.8837209302324,2440,0,1]
["Min Sept","Sat 2","Fleet","Mike Smith",4,1787.9069767441861,2660,0,1]
["Min Sept","Sat 2","Fleet","Peter Ellison",4,1787.9069767441861,1050,0,1]
["Min Sept","Sat 2","Fleet","Richard Whitsell",2,1564.4186046511629,200,0,1]
["Min Sept","Sat 2","Fleet","Tyler Helland",7,1689.5833333333335,3020,0,1]
["Min Sept","Sat 2","Fleet","Bob Hoernemann",6,1689.5833333333335,2780,0,1]
["Min Sept","Sat 2","Fleet","Mark Roe",6,1689.5833333333335,2220,0,1]
["Min Sept","Sat 2","Fleet","Tom Palmer",6,1689.5833333333335,970,0,1]
["Min Sept","Sat 2","Fleet","McCoy Helland",4,1351.6666666666665,620,0,1]
["Min Sept","Sat 3","Fleet","Zach Hoernemann",6,824.13793103448279,2770,1,0]
["Min Sept","Sat 3","Fleet","Kas Gaigalas",6,148.27586206896558,390,0,1]
["Min Sept","Sat 3","Fleet","Richard Whitsell",2,1153.7931034482758,80,0,1]
["Min Sept","Sat 3","Fleet","Bob Hoernemann",6,1648.2758620689656,1870,0,1]
["Min Sept","Sat 3","Fleet","Mike Smith",4,1118.6206896551723,2770,1,1]
["Min Sept","Sat 3","Fleet","Tyler Helland",7,2089.4736842105262,3430,0,1]
["Min Sept","Sat 3","Fleet","Tom Palmer",6,2089.4736842105262,960,0,1]
["Min Sept","Sat 3","Fleet","Peter Ellison",4,1471.578947368421,1600,1,1]
["Min Sept","Sat 3","Fleet","Andy Terpstra",6,2089.4736842105262,1180,0,1]
["Min Sept","Sat 3","Fleet","McCoy Helland",3,576.89655172413791,60,0,0]
["Min Sept","Sun 1","Fleet","Bob Hoernemann",6,1502.127659574468,3820,1,1]
["Min Sept","Sun 1","Fleet","Mark Roe",6,1702.127659574468,1500,0,1]
["Min Sept","Sun 1","Fleet","Andy Terpstra",6,1502.127659574468,3070,1,1]
["Min Sept","Sun 1","Fleet","Richard Whitsell",2,1191.4893617021276,90,0,1]
["Min Sept","Sun 1","Fleet","Matthew Larson",6,1502.127659574468,4240,1,1]
["Min Sept","Sun 1","Fleet","Tyler Helland",7,2650,2270,0,1]
["Min Sept","Sun 1","Fleet","Zach Hoernemann",6,2450,2450,1,1]
["Min Sept","Sun 1","Fleet","Kas Gaigalas",6,2650,250,0,1]
["Min Sept","Sun 1","Fleet","Tom Palmer",6,2650,2400,0,1]
["Min Sept","Sun 1","Fleet","McCoy Helland",4,2120,630,0,1]
["Min Sept","Sun 2","Fleet","Bob Hoernemann",6,1662.1621621621623,3000,1,1]
["Min Sept","Sun 2","Fleet","Zach Hoernemann",6,1662.1621621621623,3570,1,1]
["Min Sept","Sun 2","Fleet","Matthew Larson",6,1862.1621621621623,2260,0,1]
["Min Sept","Sun 2","Fleet","Richard Whitsell",2,1303.5135135135135,340,0,1]
["Min Sept","Sun 2","Fleet","Tyler Helland",7,2413.1578947368421,1560,0,1]
["Min Sept","Sun 2","Fleet","McCoy Helland",4,1930.5263157894735,780,0,1]
["Min Sept","Sun 2","Fleet","Andy Terpstra",6,2213.1578947368421,2400,1,1]
["Min Sept","Sun 2","Fleet","Tom Palmer",6,2413.1578947368421,2150,0,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,1100]

{"sheet":"BattleSummary","index":2,"n_rows":14,"n_cols":46,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,0,6,6]]}
["Event",null,null,null,null,null,null,null,"Award","Captain","Score","Tie?",null,null,"List of Battles",null,"Points","Class",null,null,null,null,null,null,null,null,"Battles","Class",null,null,null,null,null,null,null,"Average","Class",null,null,null,null,null,null,null,"Individual"]
[null,null,null,null,null,null,null,null,"Individual ","N/A",0,"No",null,null,"MIN Sept",null,"Captain",1,2,3,4,5,6,7,null,null,"Captain",1,2,3,4,5,6,7,null,"Captain",1,2,3,4,5,6,7,null,"Captain","Points"]
["Fleet Battles",1,null,null,null,null,null,null,"Most Damaged (w/ sink)","Tom Palmer",4210,null,null,null,null,null,"Andy Terpstra",null,null,null,null,null,1941.5094339622642,null,null,null,"Andy Terpstra",null,null,null,null,null,1,null,null,"Andy Terpstra",null,null,null,null,null,970.75471698113211,null,null,"Andy Terpstra"]
[null,null,null,null,null,null,null,null,"Most Damaged (w/o sink)","Andy Terpstra",3060,null,null,null,null,null,"Kas Gaigalas",null,null,null,null,null,1741.5094339622642,null,null,null,"Kas Gaigalas",null,null,null,null,null,1,null,null,"Kas Gaigalas",null,null,null,null,null,870.75471698113211,null,null,"Kas Gaigalas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peter Ellison",null,null,null,1553.2075471698113,null,null,null,null,null,"Peter Ellison",null,null,null,1,null,null,null,null,"Peter Ellison",null,null,null,776.60377358490564,null,null,null,null,"Peter Ellison"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark Roe",null,null,null,null,null,1789.5833333333335,null,null,null,"Mark Roe",null,null,null,null,null,1,null,null,"Mark Roe",null,null,null,null,null,894.79166666666674,null,null,"Mark Roe"]
["Fleet Battle Summary",null,null,null,null,null,null,null,"High Sortie Average","Captain","Score","No. of Captains","Tie?",null,null,null,"Mike Smith",null,null,null,1553.2075471698113,null,null,null,null,null,"Mike Smith",null,null,null,1,null,null,null,null,"Mike Smith",null,null,null,776.60377358490564,null,null,null,null,"Mike Smith"]
["Battle","Fleet 1","Fleet 1 Score","Fleet 2","Fleet 2 Score","Winning Fleet","Points Difference",null,"Class 1","N/A",0,0,"No",null,null,null,"Richard Whitsell",null,null,1359.0566037735848,null,null,null,null,null,null,"Richard Whitsell",null,null,1,null,null,null,null,null,"Richard Whitsell",null,null,679.52830188679241,null,null,null,null,null,"Richard Whitsell"]
["Sat 1","Allied",10290,"Axis",8590,"Allied",1700,null,"Class 2","N/A",0,0,"No",null,null,null,"Bob Hoernemann",null,null,null,null,null,1941.5094339622642,null,null,null,"Bob Hoernemann",null,null,null,null,null,1,null,null,"Bob Hoernemann",null,null,null,null,null,970.75471698113211,null,null,"Bob Hoernemann"]
[null,null,null,null,null,null,null,null,"Class 3","Richard Whitsell",679.52830188679241,1,"No",null,null,null,"Tyler Helland",null,null,null,null,null,null,1789.5833333333335,null,null,"Tyler Helland",null,null,null,null,null,null,1,null,"Tyler Helland",null,null,null,null,null,null,894.79166666666674,null,"Tyler Helland"]
[null,null,null,null,null,null,null,null,"Class 4","Peter Ellison",776.60377358490564,3,"Yes",null,null,null,"Tom Palmer",null,null,null,null,null,1589.5833333333335,null,null,null,"Tom Palmer",null,null,null,null,null,1,null,null,"Tom Palmer",null,null,null,null,null,794.79166666666674,null,null,"Tom Palmer"]
[null,null,null,null,null,null,null,null,"Class 5","N/A",0,0,"No",null,null,null,"Zach Hoernemann",null,null,null,null,null,1789.5833333333335,null,null,null,"Zach Hoernemann",null,null,null,null,null,1,null,null,"Zach Hoernemann",null,null,null,null,null,894.79166666666674,null,null,"Zach Hoernemann"]
[null,null,null,null,null,null,null,null,"Class 6","Andy Terpstra",970.75471698113211,6,"Yes",null,null,null,"McCoy Helland",null,null,null,1431.6666666666665,null,null,null,null,null,"McCoy Helland",null,null,null,1,null,null,null,null,"McCoy Helland",null,null,null,715.83333333333326,null,null,null,null,"McCoy Helland"]
[null,null,null,null,null,null,null,null,"Class 7","Tyler Helland",894.79166666666674,1,"No"]

{"sheet":"Nats Awards","index":3,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Awards"]
["Fleet Award"]
["Class 1"]
["Class 2"]
["Class 3"]
["Class 4"]
["Class 5"]
["Class 6"]
["Class 7"]
["Von Fluegel"]
["Ball Breaker"]
["Best of Scale Warship"]
["Best of Scale Convoy"]
["Bessed Dressed"]
["Brian Spychalski Award"]
["Fire Stick Award"]
["Individual Combat Trophy"]
["Life Line Award"]
["Most Damaged Sunk"]
["Most Damaged NOT Sunk"]
["Ring of Death"]
["Allied Most Feared"]
["Axis Most Feared"]
["Individual Combat"]
["Rookie of the Year"]
["Axis Spirit"]
["Allied Spirit"]
["Technology Award"]
["Most Spectacular Sink"]
["Best Ram"]

{"sheet":"Potential Cap List","index":4,"n_rows":134,"n_cols":4,"rows_kept":134,"cut":false,"hidden":false,"merged":[]}
["Captains 2021","Region","Present?","Current Member?"]
["Ginger Andrews","NE",1,"y"]
["Matt Andrews","NE",1,"y"]
["Steve Andrews","NE",1,"y"]
["Ken Arena","NE",1,"y"]
["Robert Arena","NE",1,"y"]
["Evan Fowler","MI",1,"y"]
["Kas Gaigalas","MI",1,"y"]
["Nathan Graham","NE",1,"y"]
["Kevin Plumer","NE",1,"y"]
["Craig Singer","MI",1,"y"]
["Caleb Smith","NE",1,"y"]
["Thomas Tanner","NE",1,"y"]
["William Tustin","NE",1,"y"]
["David Vogtman","NE",1,"y"]
["Holly Andews",null,1]
["Julie Hayden",null,1]
["Peter Ellison","MN",null,"y"]
["Adderley Helland","MN",null,"y"]
["McCoy Helland","MN",null,"y"]
["Tyler Helland","MN",null,"y"]
["Bob Hoernemann","MN",null,"y"]
["Zach Hoernemann","MN",null,"y"]
["Matthew Larson","MN",null,"y"]
["Lou Meszaros","SE",null,"y"]
["Brandon Smith","MN",null,"y"]
["Mike Smith","MN",null,"y"]
["Andy Terpstra","MN",null,"y"]
["Tom Palmer","KC",null,"y"]
["Richard Whitsell","KC",null,"y"]
["Johnny Adams","TX",null,"y"]
["Nathan Armstrong",null,null,"y"]
["Plato Avramides Son",null,null,"y"]
["Plato Avramides",null,null,"y"]
["Lewis Beckett","TX",null,"y"]
["Timothy Beckett","TX",null,"y"]
["Carl Bitondo","SE",null,"y"]
["Eric Bitondo","SE",null,"y"]
["Bryan Box","MN",null,"y"]
["Ted Buehring","TX",null,"y"]
["Michael Butts",null,null,"y"]
["William Byrnes",null,null,"y"]
["Neil Cameron",null,null,"y"]
["Sara Carter","SE",null,"y"]
["Travis Chezick",null,null,"y"]
["Donald Cole",null,null,"y"]
["James Coler",null,null,"y"]
["Steve Crane","NC",null,"y"]
["Heiko Dewald",null,null,"y"]
["Bryan Finster",null,null,"y"]
["D.W. Fluegel",null,null,"y"]
["James Foster",null,null,"y"]
["Joel Goodman","SE",null,"y"]
["John Alvenus","MI",null,"y"]
["Chris Grossaint","SE",null,"y"]
["Alexander Hampton","SE",null,"y"]
["Bob Amend","NE",null,"y"]
["Paul Harrington",null,null,"y"]
["David Haynes","TX",null,"y"]
["Erik Helland","MN",null,"y"]
["Neil Humble","NC",null,"y"]
["Cameron Hunt","NC",null,"y"]
["Ron Hunt","NC",null,"y"]
["Bill Jackson",null,null,"y"]
["Clint Jackson","MN",null,"y"]
["John Jones","SE",null,"y"]
["Carl Camurati","NE",null,"y"]
["Chris Kessler","NC",null,"y"]
["Richard King",null,null,"y"]
["Brian Koehler","SE",null,"y"]
["Christopher Koehler","SE",null,"y"]
["Wade Koehn",null,null,"y"]
["John Kriner",null,null,"y"]
["Mark Kuntz",null,null,"y"]
["Brian Lamb","TX",null,"y"]
["Andrew Le",null,null,"y"]
["Jeff Lide","TX",null,"y"]
["Mark Lide","TX",null,"y"]
["Jeff Lipp","NC",null,"y"]
["Hudson Maiers","MN",null,"y"]
["Michael Mangus","SE",null,"y"]
["Greg McFadden",null,null,"y"]
["Will Cover","MI",null,"y"]
["Weston Dodge","MI",null,"y"]
["Christopher Gaigalas","MI",null,"y"]
["Matthew Mullis","TX",null,"y"]
["Nicholas Myers",null,null,"y"]
["Robert Neumann",null,null,"y"]
["Philip Pace","SE",null,"y"]
["Jason Pagegala",null,null,"y"]
["Michael Pagegala",null,null,"y"]
["Chris Pearce","TX",null,"y"]
["Samuel Pearson","NC",null,"y"]
["Brandon Graham","NE",null,"y"]
["Jeffrey Poindexter",null,null,"y"]
["Gary Powell",null,null,"y"]
["Chase Hargraves","NE",null,"y"]
["David Ranier",null,null,"y"]
["George Reborn",null,null,"y"]
["Gerald Roberts","TX",null,"y"]
["Mark Roe",null,null,"y"]
["Paul Rye",null,null,"y"]
["Jason Schafer",null,null,"y"]
["Brennen Schultz","SE",null,"y"]
["Rick Schultz","SE",null,"y"]
["Trey Schultz","SE",null,"y"]
["Kyle Scott",null,null,"y"]
["David Simmons",null,null,"y"]
["Ken Kelly","NE",null,"y"]
["Isaac McKinzie","NE",null,"y"]
["Karl Smith",null,null,"y"]
["Justin Stalnaker",null,null,"y"]
["Robert Stalnaker","NC",null,"y"]
["Austin Stephens","SE",null,"y"]
["Charley Stephens","SE",null,"y"]
["Sydnee McKinzie","NE",null,"y"]
["Terry McKinzie","NE",null,"y"]
["Michael Tanzillo",null,null,"y"]
["Michael Thomas",null,null,"y"]
["Nathan Thompson",null,null,"y"]
["Barry Tighe",null,null,"y"]
["Mary Tighe",null,null,"y"]
["Hadrian Tucker",null,null,"y"]
["Justin Ragucci","NE",null,"y"]
["Kevin Sundberg","NE",null,"y"]
["Amanda Seltzer","NE",null,"y"]
["Clark Ward","SE",null,"y"]
["Stan Watkins",null,null,"y"]
["Matthew Webb",null,null,"y"]
["Jessica Wheaton",null,null,"y"]
["Gregory Wilson",null,null,"y"]
["Jett Zaruba","TX",null,"y"]
["John Zaruba","TX",null,"y"]
["Mackenzyee Zaruba","TX",null,"y"]

{"sheet":"Master","index":5,"n_rows":4,"n_cols":20,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Winner:",{"$f":"IF(K2>K3, B2, IF(K3>K2, B3, \"Tie\"))","v":"Tie"},null,"Battle Type","Battle Location and Month (i.e. MD May)",null,null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",0,"Fleet Weight:",0,"Fleet Battle Damage:",0,"Fleet Score:",0,null,"Battle Day",null,null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",0,"Fleet Weight:",0,"Fleet Battle Damage:",0,"Fleet Score:",0,null,"Battle Number",null,null,null,null,null,"Individual"]
["Captian","Ship","Fleet","Class","Units","Above","On","Below","Sinks","Participate all Sorties","Penalties Points","2nd Sortie Sink","Damage Points","Scored By","Notes","Weight Factor","Weight Points","Captian","Captain Points","Indiv Points"]

{"sheet":"Captain","index":6,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Captian","Ship","Class","Units",null,null,null,"Enter \"Convoy\" for campaign battles"]
["Tyler Helland","Yamato",7,8]
["Peter Ellison","Erin",4,4.5]
["McCoy Helland","Zara",3,3]
["Tom Palmer","Montana",6,6]
["Kas Gaigalas","Seydlitz",4,4.5]
["Bob Hoernemann","Nagato",6,6]
["Mike Smith","Fiji",3,3]
["Zach Hoernemann","Washington",6,6]
["Andy Terpstra","North Carolina",6,6]
["Richard Whitsell","VU",4,4]
["Mark Roe"]
["Zach Hoernemann"]
["Matthew Larson"]

{"sheet":"Campaign Master","index":7,"n_rows":17,"n_cols":43,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Winner:",{"$f":"IF(K2>K3, B2, IF(K3>K2, B3, \"Tie\"))","v":"Tie"},null,null,"Battle Location and Month (i.e. MD May)","Nats",null,"Convoy Runs",null,null,null,null,null,null,"Sinks",null,null,null,null,null,"Convoy Friendly Ram",null,null,null,null,null,null,"Ram Penalties"]
["Fleet 1 :","Allied",null,null,null,"Fleet Points:",{"$f":"B15","v":0},"Fleet Penalties:",{"$f":"B16","v":0},"Fleet Score:",{"$f":"B17","v":0},null,"Battle Day","Tues",null,"Captain","Fleet","Ship","Ship Length","Number of Runs","Points",null,"Captain","Fleet","Ship","Class","Sink Points",null,"Ramming Captain","Fleet","Convoy Ship","Convoy Captain","Ship Length","Points",null,"Ramming Captain","Fleet","Ram Type","Rammed Captain","Rammed Ship","Rammed Ship Class","Ram Sink","Points"]
["Fleet 2 :","Axis",null,null,null,"Fleet Points:",{"$f":"C15","v":0},"Fleet Penalties:",{"$f":"C16","v":0},"Fleet Score:",{"$f":"C17","v":0}]
[]
["Fleet:",{"$f":"B2","v":"Allied"},{"$f":"B3","v":"Axis"}]
["Targets Remaining:"]
["Target Points:"]
["Convoy Run Points:"]
["Scuttled Convoy Points:"]
["Sink Points:"]
["Convoy Friendly Ram Points:"]
["Ram Penalty Points:"]
["No Ship on Water Points:"]
["Convoy Run Every 10 Min Points:"]
["Total Points:",{"$f":"B7+B8+B9+B10+B11+B13+B14","v":0},{"$f":"C7+C8+C9+C10+C11+C13+C14","v":0}]
["Total Penalties:",{"$f":"B12","v":0},{"$f":"C12","v":0}]
["Fleet Score:",{"$f":"B15-B16","v":0},{"$f":"C15-C16","v":0}]

{"sheet":"MIN Sept Sat 1","index":8,"n_rows":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Winner:",{"$f":"IF(K2>K3, B2, IF(K3>K2, B3, \"Tie\"))","v":"Allied"},null,"Battle Type","Battle Location and Month (i.e. MD May)","MIN Sept",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",29.5,"Fleet Weight:",53,"Fleet Battle Damage:",8590,"Fleet Score:",10290,null,"Battle Day","Sat",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",30,"Fleet Weight:",48,"Fleet Battle Damage:",10290,"Fleet Score:",8590,null,"Battle Number",1,null,null,null,null,"Individual"]
["Captian","Ship","Fleet","Class","Units","Above","On","Below","Sinks","Participate all Sorties","Penalties Points","2nd Sortie Sink","Damage Points","Scored By","Notes","Weight Factor","Weight Points","Captian","Captain Points","Indiv Points"]
["Andy Terpstra","Nagato","Allied",6,6,52,19,72,0,1,0,0,3060,"Andy Terpstra","None,None,None",10,1941.5094339622642,"Andy Terpstra",1941.5094339622642]
["Kas Gaigalas","Washington","Allied",6,6,31,3,12,1,1,0,1,1730,"Tom Palmer","None,None,None",10,1941.5094339622642,"Kas Gaigalas",1741.5094339622642]
["Peter Ellison","Erin","Allied",4,4.5,9,2,15,0,1,0,0,580,"Tyler Helland","None,None,None",8,1553.2075471698113,"Peter Ellison",1553.2075471698113]
["Mark Roe","North Carolina","Axis",6,6,77,3,26,0,1,0,0,1610,"Mark Roe","None,None,None",10,1789.5833333333335,"Mark Roe",1789.5833333333335]
["Mike Smith","Seydlitz","Allied",4,4.5,35,18,20,0,1,0,0,1310,"Mike Smith","None,None,None",8,1553.2075471698113,"Mike Smith",1553.2075471698113]
["Richard Whitsell","Fiji","Allied",2,2.5,5,0,1,0,1,0,0,80,"Tom Palmer","None,None,None",7,1359.0566037735848,"Richard Whitsell",1359.0566037735848]
["Bob Hoernemann","Nagato","Allied",6,6,41,11,40,0,1,0,0,1830,"Zach Hoernemann","None,None,None",10,1941.5094339622642,"Bob Hoernemann",1941.5094339622642]
["Tyler Helland","Yamato","Axis",7,8,63,10,36,0,1,0,0,1910,"Tyler Helland","None,None,None",10,1789.5833333333335,"Tyler Helland",1789.5833333333335]
["Tom Palmer","Montana","Axis",6,6,144,30,39,1,1,0,1,4210,"Rick Whitsell","None,None,None",10,1789.5833333333335,"Tom Palmer",1589.5833333333335]
["Zach Hoernemann","Nagato","Axis",6,6,74,8,36,0,1,0,0,1980,"Zach Hoernemann","None,None,None",10,1789.5833333333335,"Zach Hoernemann",1789.5833333333335]
["McCoy Helland","VU","Axis",4,4,13,3,13,0,1,0,0,580,"McCoy Helland","None,None,None",8,1431.6666666666665,"McCoy Helland",1431.6666666666665]

{"sheet":"Min Sept Sat 2","index":9,"n_rows":14,"n_cols":20,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Winner:",{"$f":"IF(K2>K3, B2, IF(K3>K2, B3, \"Tie\"))","v":"Allied"},null,"Battle Type","Battle Location and Month (i.e. MD May)","Min Sept",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",23.5,"Fleet Weight:",43,"Fleet Battle Damage:",8110,"Fleet Score:",9610,null,"Battle Day","Sat",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",30,"Fleet Weight:",48,"Fleet Battle Damage:",9610,"Fleet Score:",8110,null,"Battle Number",2,null,null,null,null,"Individual"]
["Captian","Ship","Fleet","Class","Units","Above","On","Below","Sinks","Participate all Sorties","Penalties Points","2nd Sortie Sink","Damage Points","Scored By","Notes","Weight Factor","Weight Points","Captian","Captain Points","Indiv Points"]
["Zach Hoernemann","Nagato","Allied",6,6,56,9,34,0,1,0,0,1760,"Zach Hoernemann","None,None,None",10,2234.8837209302324,"Zach Hoernemann",2234.8837209302324]
["Andy Terpstra","Nagato","Allied",6,6,38,16,58,0,1,0,0,2440,"Andy Terpstra","None,None,None",10,2234.8837209302324,"Andy Terpstra",2234.8837209302324]
["Mike Smith","Seydlitz","Allied",4,4.5,46,14,64,0,1,0,0,2660,"Mike Smith","None,None,None",8,1787.9069767441861,"Mike Smith",1787.9069767441861]
["Peter Ellison","Erin","Allied",4,4.5,34,1,23,0,1,0,0,1050,"Tyler Helland","None,None,None",8,1787.9069767441861,"Peter Ellison",1787.9069767441861]
["Richard Whitsell","Fiji","Allied",2,2.5,10,2,2,0,1,0,0,200,"Tom Palmer","None,None,None",7,1564.4186046511629,"Richard Whitsell",1564.4186046511629]
["Tyler Helland","Yamato","Axis",7,8,146,15,42,0,1,0,0,3020,"Tyler Helland","None,None,None",10,1689.5833333333335,"Tyler Helland",1689.5833333333335]
["Bob Hoernemann","Nagato","Axis",6,6,51,31,55,0,1,0,0,2780,"Mike Smith","None,None,None",10,1689.5833333333335,"Bob Hoernemann",1689.5833333333335]
["Mark Roe","North Carolina","Axis",6,6,79,4,45,0,1,0,0,2220,"Mark Roe","None,None,None",10,1689.5833333333335,"Mark Roe",1689.5833333333335]
["Tom Palmer","Montana","Axis",6,6,32,7,17,0,1,0,0,970,"Rick Whitsell","None,None,None",10,1689.5833333333335,"Tom Palmer",1689.5833333333335]
["McCoy Helland","VU","Axis",4,4,1,2,19,0,1,0,0,620,"McCoy Helland","None,None,None",8,1351.6666666666665,"McCoy Helland",1351.6666666666665]

{"sheet":"Min Sept Sat 3","index":10,"n_rows":14,"n_cols":20,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Winner:",{"$f":"IF(K2>K3, B2, IF(K3>K2, B3, \"Tie\"))","v":"Axis"},null,"Battle Type","Battle Location and Month (i.e. MD May)","Min Sept",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",28,"Fleet Weight:",43.5,"Fleet Battle Damage:",7940,"Fleet Score:",5670,null,"Battle Day","Sat",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",24.5,"Fleet Weight:",38,"Fleet Battle Damage:",7170,"Fleet Score:",7940,null,"Battle Number",3,null,null,null,null,"Individual"]
["Captian","Ship","Fleet","Class","Units","Above","On","Below","Sinks","Participate all Sorties","Penalties Points","2nd Sortie Sink","Damage Points","Scored By","Notes","Weight Factor","Weight Points","Captian","Captain Points","Indiv Points"]
["Zach Hoernemann","Nagato","Allied",6,6,50,5,39,1,0,0,0,2770,"Zach Hoernemann","None,None,None",5,824.13793103448279,"Zach Hoernemann",824.13793103448279]
["Kas Gaigalas","Washington","Allied",6,6,18,0,7,0,1,1500,0,390,"Kas Gaigalas","Declared Sunk,None,None",10,148.27586206896558,"Kas Gaigalas",148.27586206896558]
["Richard Whitsell","Fiji","Allied",2,2.5,0,1,2,0,1,0,0,80,"Tyler Helland","None,None,None",7,1153.7931034482758,"Richard Whitsell",1153.7931034482758]
["Bob Hoernemann","Nagato","Allied",6,6,47,10,40,0,1,0,0,1870,"Zach Hoernemann","None,None,None",10,1648.2758620689656,"Bob Hoernemann",1648.2758620689656]
["Mike Smith","Seydlitz","Allied",4,4.5,52,23,33,1,1,0,1,2770,"Andy Terpstra","None,None,None",8,1318.6206896551723,"Mike Smith",1118.6206896551723]
["Tyler Helland","Yamato","Axis",7,8,115,18,64,0,1,0,0,3430,"Tyler Helland","None,None,None",10,2089.4736842105262,"Tyler Helland",2089.4736842105262]
["Tom Palmer","Montana","Axis",6,6,46,7,12,0,1,0,0,960,"Tom Palmer","None,None,None",10,2089.4736842105262,"Tom Palmer",2089.4736842105262]
["Peter Ellison","Erin","Axis",4,4.5,27,1,17,1,1,0,1,1600,"Tyler Helland","None,None,None",8,1671.578947368421,"Peter Ellison",1471.578947368421]
["Andy Terpstra","Nagato","Axis",6,6,38,4,24,0,1,0,0,1180,"Andy Terpstra","None,None,None",10,2089.4736842105262,"Andy Terpstra",2089.4736842105262]
["McCoy Helland","Zara","Allied",3,3,2,2,0,0,0,0,0,60,"McCoy Helland","None,None,None",3.5,576.89655172413791,"McCoy Helland",576.89655172413791]

{"sheet":"Min Sept Sun 1","index":11,"n_rows":14,"n_cols":20,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Winner:",{"$f":"IF(K2>K3, B2, IF(K3>K2, B3, \"Tie\"))","v":"Axis"},null,"Battle Type","Battle Location and Month (i.e. MD May)","Min Sept",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",26.5,"Fleet Weight:",47,"Fleet Battle Damage:",12720,"Fleet Score:",7999.99951171875,null,"Battle Day","Sun",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",30,"Fleet Weight:",48,"Fleet Battle Damage:",8000,"Fleet Score:",12720,null,"Battle Number",1,null,null,null,null,"Individual"]
["Captian","Ship","Fleet","Class","Units","Above","On","Below","Sinks","Participate all Sorties","Penalties Points","2nd Sortie Sink","Damage Points","Scored By","Notes","Weight Factor","Weight Points","Captian","Captain Points","Indiv Points"]
["Bob Hoernemann","Nagato","Allied",6,6,48,21,64,1,1,0,1,3820,"Bob Hoernemann","None,None,None",10,1702.127659574468,"Bob Hoernemann",1502.127659574468]
["Mark Roe","North Carolina","Allied",6,6,26,5,38,0,1,0,0,1500,"Mark Roe","None,None,None",10,1702.127659574468,"Mark Roe",1702.127659574468]
["Andy Terpstra","Nagato","Allied",6,6,59,17,38,1,1,0,1,3070,"Andy Terpstra","None,None,None",10,1702.127659574468,"Andy Terpstra",1502.127659574468]
["Richard Whitsell","Fiji","Allied",2,2.5,1,1,2,0,1,0,0,90,"Tom Palmer","None,None,None",7,1191.4893617021276,"Richard Whitsell",1191.4893617021276]
["Matthew Larson","Nagato","Allied",6,6,113,14,61,1,1,0,1,4240,"Tyler Helland","None,None,None",10,1702.127659574468,"Matthew Larson",1502.127659574468]
["Tyler Helland","Yamato","Axis",7,8,91,8,40,0,1,0,0,2270,"Tyler Helland","None,None,None",10,2650,"Tyler Helland",2650]
["Zach Hoernemann","Nagato","Axis",6,6,65,4,24,1,1,0,1,2450,"Zach Hoernemann","None,None,None",10,2650,"Zach Hoernemann",2450]
["Kas Gaigalas","Washington","Axis",6,6,10,0,5,0,1,0,0,250,"Kas Gaigalas","None,None,None",10,2650,"Kas Gaigalas",2650]
["Tom Palmer","Montana","Axis",6,6,108,12,36,0,1,0,0,2400,"Rick Whitsell","None,None,None",10,2650,"Tom Palmer",2650]
["McCoy Helland","VU","Axis",4,4,34,4,7,0,1,0,0,630,"McCoy Helland","None,None,None",8,2120,"McCoy Helland",2120]

{"sheet":"Min Sept Sun 2","index":12,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Winner:",{"$f":"IF(K2>K3, B2, IF(K3>K2, B3, \"Tie\"))","v":"Axis"},null,"Battle Type","Battle Location and Month (i.e. MD May)","Min Sept",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",20.5,"Fleet Weight:",37,"Fleet Battle Damage:",9170,"Fleet Score:",6890,null,"Battle Day","Sun",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",24,"Fleet Weight:",38,"Fleet Battle Damage:",6890,"Fleet Score:",9170,null,"Battle Number",2,null,null,null,null,"Individual"]
["Captian","Ship","Fleet","Class","Units","Above","On","Below","Sinks","Participate all Sorties","Penalties Points","2nd Sortie Sink","Damage Points","Scored By","Notes","Weight Factor","Weight Points","Captian","Captain Points","Indiv Points"]
["Bob Hoernemann","Nagato","Allied",6,6,37,8,49,1,1,0,1,3000,"Bob Hoernemann","None,None,None",10,1862.1621621621623,"Bob Hoernemann",1662.1621621621623]
["Zach Hoernemann","Nagato","Allied",6,6,64,5,61,1,1,0,1,3570,"Zach Hoernemann","None,None,None",10,1862.1621621621623,"Zach Hoernemann",1662.1621621621623]
["Matthew Larson","Nagato","Allied",6,6,103,18,29,0,1,0,0,2260,"Tyler Helland","None,None,None",10,1862.1621621621623,"Matthew Larson",1862.1621621621623]
["Richard Whitsell","Fiji","Allied",2,2.5,16,3,4,0,1,0,0,340,"Tom Palmer","None,None,None",7,1303.5135135135135,"Richard Whitsell",1303.5135135135135]
["Tyler Helland","Yamato","Axis",7,8,58,4,30,0,1,0,0,1560,"Tyler Helland","None,None,None",10,2413.1578947368421,"Tyler Helland",2413.1578947368421]
["McCoy Helland","VU","Axis",4,4,35,5,11,0,1,0,0,780,"McCoy Helland","None,None,None",8,1930.5263157894735,"McCoy Helland",1930.5263157894735]
["Andy Terpstra","Nagato","Axis",6,6,29,6,33,1,1,0,1,2400,"Andy Terpstra","None,None,None",10,2413.1578947368421,"Andy Terpstra",2213.1578947368421]
["Tom Palmer","Montana","Axis",6,6,69,16,38,0,1,0,0,2150,"Rick Whitsell","None,None,None",10,2413.1578947368421,"Tom Palmer",2413.1578947368421]

{"sheet":"Instructions","index":13,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[[8,1,8,11],[10,0,10,10],[12,0,12,6],[1,0,1,12],[3,0,3,15],[5,0,5,7],[7,0,7,12]]}
[]
["Ensure that all participating captains/ships are entered into the Captian Tab."]
[]
["Make a COPY of the \"Master Score Sheet\" tab and rename it to the name of the battle to be scored."]
[]
["Enter Opposing Fleet Names into Cells B2 & B3"]
[]
["Use the \"Enter Score\" button to enter the socres for ALL battlers in the battle."]
[null,"DO NOT CLOSE THE WINDOW UNTIL ALL SCORES ARE ENTERED"]
[]
["Use the \"Calculate Totals\" button to finish the scoring of the battle"]
[]
["The Winner will be displayed in Cell J1"]