{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Captain","Nats July Mon 1","Nats July Mon 2","Nats July Tues 1","Nats July Tues Campaign","Nats July Wed Cruiser","Nats July Wed Cruiser 2","Nats July Wed Nite","Nats July Thurs 1","Nats July Thurs Campaign","Nats July Fri 1","Nats July Fri Destroyer","Nats July Fri Admirals","Nats July Fri Miss V. Jean","Instructions"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":21,"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":"Captain","index":0,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Captian","Ship","Class","Units",null,null,null,"Enter \"Convoy\" for campaign battles"]
["Tyler Helland","Yamato",7,8]
["Peter Ellison","Montana",6,6.5]
["Tom Palmer","Kongo",4,4.5]
["Bob Hoernemann","Seydlitz",4,4.5]
["Mike Smith","Nagato",6,6]
["Zach Hoernemann","Idaho",5,5.5]
["Andy Terpstra","Fiji",3,3]
["Bryan Box","VV",6,6.5]
["Richard Whitsell","Jean Bart",6,6.5]
["Matt Andrews","Dreadnaught",4,4]
["Steve Andrews","Missouri",7,8]
["Ken Arena","Bismarck",6,6.5]
["Robert Arena","Queen Elizabeth",5,5.5]
["Evan Fowler","Ostfriesland",4,4.5]
["Kas Gaigalas","Rodney",6,6]
["Nathan Graham","Baden",5,5.5]
["Kevin Plumer","Washington",6,6]
["Craig Singer","North Carolina",6,6]
["Caleb Smith","Arizona",5,5.5]
["Thomas Tanner","Courbet",4,4.5]
["Matthew Larson","Iron Duke",5,5]
["Lou Meszaros","Zara",3,3]
["Nathan Armstrong","Topeka",3,3]
["Brian Koehler","Des Moise",3,3.5]
["Alexander Hampton","Ajax",2,2.5]
["Brian Lamb","VDT",4,4]
["Chris Pearce","Texas",5,5.5]
["Mark Roe","Graff Spee",3,3.5]
["Mike Smith","Myoko",3,3]
["Nathan Graham","Radetsky",3,3.5]
["Will Cover","Verti",3,3.5]
["McCoy Helland","Z36",1,1.5]
["Justin Ragucci","Gearing",1,1.5]
["John Stangel","South Dakota",6,6]
[null,"Tromp",1,1.5]
[null,"Glorie",2,2.5]
[null,"Mississippi",3,3.5]
[null,"Duca D' Aosta",2,2.5]
[null,"Suffren",3,3]
[null,"Hannover",3,3.5]

{"sheet":"Nats July Mon 1","index":1,"n_rows":36,"n_cols":20,"rows_kept":36,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",89,"Fleet Weight:",127.5,"Fleet Battle Damage:",21400,"Fleet Score:",13850.001953125,null,"Battle Day","Mon",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",84.5,"Fleet Weight:",143,"Fleet Battle Damage:",15850,"Fleet Score:",21400.00390625,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"]
["Kevin Plumer","Radetsky","Allied",3,3.5,16,6,20,0,0,0,0,880,"Tyler Helland","None,None,None",3.5,435.09803921568624,"Kevin Plumer",435.09803921568624]
["Kevin Plumer","Missouri","Allied",7,8,2,0,2,1,0,1800,0,1280,"Tyler Helland","Declared ,None,None",5,-1178.4313725490197,"Kevin Plumer",-1178.4313725490197]
["Mike Smith","Seydlitz","Axis",4,4.5,29,7,14,0,1,0,0,850,"Steve Andrews","None,None,None",8,1197.2027972027972,"Mike Smith",1197.2027972027972]
["Steve Andrews","Jean Bart","Allied",6,6.5,32,9,9,0,1,0,0,770,"Ken Arena","None,None,None",10,1243.1372549019607,"Steve Andrews",1243.1372549019607]
["Brian Lamb","Seydlitz","Allied",4,4.5,38,8,3,0,1,0,0,630,"Matthew Larson","None,None,None",8,994.50980392156862,"Brian Lamb",994.50980392156862]
["McCoy Helland","Zara","Axis",3,3,3,1,0,0,1,0,0,50,"Tom Tanner","None,None,None",7,1047.5524475524476,"McCoy Helland",1047.5524475524476]
["Ken Arena","Iron Duke","Axis",5,5,9,0,19,0,1,0,0,660,"Matthew Andrews","None,None,None",9,1346.8531468531469,"Ken Arena",1346.8531468531469]
["Matt Andrews","VV","Allied",6,6.5,30,1,21,0,1,0,0,950,"Craig Singer","None,None,None",10,1243.1372549019607,"Matt Andrews",1243.1372549019607]
["Bryan Box","Idaho","Allied",5,5.5,27,0,8,1,1,0,1,1410,"Mark Roe","None,None,None",9,1118.8235294117646,"Bryan Box",918.82352941176464]
["Matthew Larson","Nagato","Axis",6,6,28,0,24,0,1,0,0,1000,"Brian Koehler","None,None,None",10,1496.5034965034965,"Matthew Larson",1496.5034965034965]
["Evan Fowler","Rodney","Allied",6,6,61,9,27,1,1,0,1,2600,"Rob Arena","None,None,None",10,1243.1372549019607,"Evan Fowler",1043.1372549019607]
["Chris Pearce","Bismarck","Allied",6,6.5,41,6,23,0,1,0,0,1220,"Justin Ragucci","None,None,None",10,1243.1372549019607,"Chris Pearce",1243.1372549019607]
["Justin Ragucci","Rodney","Axis",6,6,90,12,18,0,1,0,0,1680,"Chris Pearce","None,None,None",10,1496.5034965034965,"Justin Ragucci",1496.5034965034965]
["Craig Singer","Z36","Axis",1,1.5,0,3,3,1,1,0,1,550,"Tom Tanner","None,None,None",4,598.60139860139861,"Craig Singer",398.60139860139861]
["John Stangel","Kongo","Allied",4,4.5,34,0,14,0,1,0,0,760,"Lou Meszaros","None,None,None",8,994.50980392156862,"John Stangel",994.50980392156862]
["Will Cover","South Dakota","Axis",6,6,12,3,4,0,1,0,0,300,"Steven Andrews","None,None,None",10,1496.5034965034965,"Will Cover",1496.5034965034965]
["Tom Palmer","Montana","Allied",6,6.5,92,13,41,0,1,0,0,2410,"Tyler Helland","None,None,None",10,1243.1372549019607,"Tom Palmer",1243.1372549019607]
["Kas Gaigalas","Washington","Axis",6,6,21,4,11,0,1,0,0,620,"John Stangel","None,None,None",10,1496.5034965034965,"Kas Gaigalas",1496.5034965034965]
["Andy Terpstra","Nagato","Axis",6,6,15,5,23,0,1,0,0,940,"Zach Hoernemann","None,None,None",10,1496.5034965034965,"Andy Terpstra",1496.5034965034965]
["Robert Arena","Arizona","Axis",5,5.5,16,1,8,0,1,0,0,420,"Evan Fowler","None,None,None",9,1346.8531468531469,"Robert Arena",1346.8531468531469]
["Nathan Graham","Bismarck","Axis",6,6.5,30,3,6,0,1,0,0,540,"Richard Whitesell","None,None,None",10,1496.5034965034965,"Nathan Graham",1496.5034965034965]
["Richard Whitsell","Fiji","Allied",3,3,5,0,3,0,1,0,0,140,"Nate Graham","None,None,None",7,870.19607843137248,"Richard Whitsell",870.19607843137248]
["Bob Hoernemann","Nagato","Axis",6,6,25,13,37,0,1,0,0,1620,"Zach Hoernemann","None,None,None",10,1496.5034965034965,"Bob Hoernemann",1496.5034965034965]
["Zach Hoernemann","Nagato","Allied",6,6,87,8,30,0,1,200,0,1930,"Bob Hoernemann","Ram - Below,None,None",10,1043.1372549019607,"Zach Hoernemann",1043.1372549019607]
["Lou Meszaros","Courbet","Axis",4,4.5,6,1,1,0,1,0,0,110,"John Stangel","None,None,None",8,1197.2027972027972,"Lou Meszaros",1197.2027972027972]
["Brian Koehler","Queen Elizabeth","Allied",5,5.5,3,3,1,1,0,0,0,1020,"Alex Hampton","None,None,None",4.5,559.41176470588232,"Brian Koehler",559.41176470588232]
["Alexander Hampton","Dreadnaught","Axis",4,4,42,5,6,0,1,0,0,700,"Nate Armstrong","None,None,None",8,1197.2027972027972,"Alexander Hampton",1197.2027972027972]
["Nathan Armstrong","Baden","Allied",5,5.5,11,7,13,1,0,0,0,1540,"Alex Hampton","None,None,None",4.5,559.41176470588232,"Nathan Armstrong",559.41176470588232]
["Thomas Tanner","Ostfriesland","Allied",4,4.5,40,8,19,1,1,0,1,1930,"McCoy Helland","None,None,None",8,994.50980392156862,"Thomas Tanner",794.50980392156862]
["Mark Roe","North Carolina","Axis",6,6,78,14,37,1,1,0,1,3170,"Bryan Box","None,None,None",10,1496.5034965034965,"Mark Roe",1296.5034965034965]
["Tyler Helland","Yamato","Axis",7,8,120,12,40,0,1,0,0,2640,"Caleb Smith","None,None,None",10,1496.5034965034965,"Tyler Helland",1496.5034965034965]
["Caleb Smith","Jean Bart","Allied",6,6.5,80,7,33,0,1,0,0,1930,"Tyler Helland","None,None,None",10,1243.1372549019607,"Caleb Smith",1243.1372549019607]

{"sheet":"Nats July Mon 2","index":2,"n_rows":34,"n_cols":20,"rows_kept":34,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",78.5,"Fleet Weight:",118.5,"Fleet Battle Damage:",19270,"Fleet Score:",13749.9990234375,null,"Battle Day","Mon",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",79.5,"Fleet Weight:",132,"Fleet Battle Damage:",14550,"Fleet Score:",19020,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"]
["Mark Roe","North Carolina","Axis",6,6,58,6,27,1,0,0,0,2510,"Tom Palmer","None,None,None",5,729.92424242424249,"Mark Roe",729.92424242424249]
["Matt Andrews","VV","Allied",6,6.5,66,4,17,0,1,0,0,1250,"Ken Arena","None,None,None",10,1227.8481012658228,"Matt Andrews",1227.8481012658228]
["Bryan Box","Idaho","Allied",5,5.5,38,3,11,0,1,0,0,770,"Rob Arena","None,None,None",9,1105.0632911392406,"Bryan Box",1105.0632911392406]
["Mike Smith","Seydlitz","Axis",4,4.5,15,7,11,0,1,0,0,620,"Kevin Plumer","None,None,None",8,1167.878787878788,"Mike Smith",1167.878787878788]
["Kas Gaigalas","Washington","Axis",6,6,33,1,3,0,1,0,0,440,"Evan Fowler","None,None,None",10,1459.848484848485,"Kas Gaigalas",1459.848484848485]
["Lou Meszaros","Courbet","Axis",4,4.5,21,6,12,0,1,0,0,690,"Thomas Tanner","None,None,None",8,1167.878787878788,"Lou Meszaros",1167.878787878788]
["Brian Koehler","Queen Elizabeth","Allied",5,5.5,30,3,5,0,1,0,0,510,"Alex Hampton","None,None,None",9,1105.0632911392406,"Brian Koehler",1105.0632911392406]
["Nathan Armstrong","Baden","Allied",5,5.5,0,0,1,1,0,0,0,930,"Alex Hampton","None,None,None",4.5,552.53164556962031,"Nathan Armstrong",552.53164556962031]
["Will Cover","South Dakota","Axis",6,6,58,4,27,0,1,0,0,1470,"Steven Andrews","None,None,None",10,1459.848484848485,"Will Cover",1459.848484848485]
["Justin Ragucci","Rodney","Axis",6,6,41,12,10,0,1,0,0,950,"Zach Hoernemann","None,None,None",10,1459.848484848485,"Justin Ragucci",1459.848484848485]
["McCoy Helland","Zara","Axis",3,3,3,0,4,0,1,0,0,150,"Thomas Tanner","None,None,None",7,1021.8939393939394,"McCoy Helland",1021.8939393939394]
["Tom Palmer","Montana","Allied",6,6.5,71,13,46,0,1,0,0,2350,"Tyler Helland","None,None,None",10,1227.8481012658228,"Tom Palmer",1227.8481012658228]
["Caleb Smith","Jean Bart","Allied",6,6.5,29,5,27,0,1,0,0,1200,"Matthew Larson","None,None,None",10,1227.8481012658228,"Caleb Smith",1227.8481012658228]
["Tyler Helland","Yamato","Axis",7,8,79,4,18,0,1,0,0,1410,"Kevin Plumer","None,None,None",10,1459.848484848485,"Tyler Helland",1459.848484848485]
["Thomas Tanner","Ostfriesland","Allied",4,4.5,14,3,11,0,1,0,0,530,"Lou Meszaros","None,None,None",8,982.27848101265818,"Thomas Tanner",982.27848101265818]
["John Stangel","Verti","Allied",3,3.5,21,1,9,0,1,0,0,500,"Bob Hoernemann","None,None,None",7,859.49367088607596,"John Stangel",859.49367088607596]
["Chris Pearce","Bismarck","Allied",6,6.5,95,13,57,0,1,0,0,2920,"Tyler Helland","None,None,None",10,1227.8481012658228,"Chris Pearce",1227.8481012658228]
["Bob Hoernemann","Nagato","Axis",6,6,28,15,40,0,1,200,0,1780,"Zach Hoernemann","Ram - Below,None,None",10,1259.848484848485,"Bob Hoernemann",1259.848484848485]
["Brian Lamb","Seydlitz","Allied",4,4.5,1,1,0,0,0,800,0,30,"Matthew Larson","Withdraw,None,None",4,-308.86075949367091,"Brian Lamb",-308.86075949367091]
["Matthew Larson","Nagato","Axis",6,6,40,8,26,0,1,0,0,1340,"Brian Lamb","None,None,None",10,1459.848484848485,"Matthew Larson",1459.848484848485]
["Steve Andrews","Jean Bart","Allied",6,6.5,46,4,29,0,1,0,0,1410,"Mark Roe","None,None,None",10,1227.8481012658228,"Steve Andrews",1227.8481012658228]
["Craig Singer","Z36","Axis",1,1.5,0,0,0,0,1,0,0,0,"Caleb Smith","None,None,None",4,583.93939393939399,"Craig Singer",583.93939393939399]
["Andy Terpstra","Nagato","Axis",6,6,22,10,26,0,1,50,0,1200,"Matthew Andrews","Ram - Superstructure,None,None",10,1409.848484848485,"Andy Terpstra",1409.848484848485]
["Robert Arena","Arizona","Axis",5,5.5,23,0,2,0,1,0,0,290,"John Stangel","None,None,None",9,1313.8636363636363,"Robert Arena",1313.8636363636363]
["Zach Hoernemann","Nagato","Allied",6,6,105,7,74,0,1,0,0,3410,"Bob Hoernemann","None,None,None",10,1227.8481012658228,"Zach Hoernemann",1227.8481012658228]
["Ken Arena","Iron Duke","Axis",5,5,3,0,0,0,1,0,0,30,"Evan Fowler","None,None,None",9,1313.8636363636363,"Ken Arena",1313.8636363636363]
["Richard Whitsell","Fiji","Allied",3,3,0,0,0,0,1,0,0,0,"Alex Hampton","None,None,None",7,859.49367088607596,"Richard Whitsell",859.49367088607596]
["Nathan Graham","Gearing","Axis",1,1.5,2,0,1,1,1,0,1,450,"Richard Whitesell","None,None,None",4,583.93939393939399,"Nathan Graham",383.93939393939399]
["Alexander Hampton","Dreadnaught","Axis",4,4,45,16,15,0,1,0,0,1220,"Nate Armstrong","None,None,None",8,1167.878787878788,"Alexander Hampton",1167.878787878788]
["Kevin Plumer","Missouri","Allied",7,8,110,13,30,1,1,0,1,3460,"Justin Ragucci","None,None,None",10,1227.8481012658228,"Kevin Plumer",1027.8481012658228]

{"sheet":"Nats July Tues 1","index":3,"n_rows":35,"n_cols":20,"rows_kept":35,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",84.5,"Fleet Weight:",137,"Fleet Battle Damage:",14350,"Fleet Score:",23239.998046875,null,"Battle Day","Tues",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",84.5,"Fleet Weight:",143,"Fleet Battle Damage:",23240,"Fleet Score:",13549.9990234375,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"]
["John Stangel","Kongo","Allied",4,4.5,26,2,17,0,1,0,0,810,"Bob Horenemann","None,None,None",8,1357.0802919708028,"John Stangel",1357.0802919708028]
["Ken Arena","Iron Duke","Axis",5,5,14,0,4,0,1,0,0,260,"John Stangel","None,None,None",9,903.14685314685323,"Ken Arena",903.14685314685323]
["Brian Koehler","Queen Elizabeth","Allied",5,5.5,3,6,6,0,1,0,0,330,"Alex Hampton","None,None,None",9,1526.7153284671533,"Brian Koehler",1526.7153284671533]
["Alexander Hampton","Dreadnaught","Axis",4,4,51,4,18,0,1,0,0,1130,"Brian Koehler","None,None,None",8,802.79720279720277,"Alexander Hampton",802.79720279720277]
["Robert Arena","Arizona","Axis",5,5.5,49,1,6,0,1,0,0,690,"Matthew Andrews","None,None,None",9,903.14685314685323,"Robert Arena",903.14685314685323]
["Craig Singer","Z36","Axis",1,1.5,3,0,0,0,1,0,0,30,"Caleb Smith","None,None,None",4,401.39860139860139,"Craig Singer",401.39860139860139]
["Bob Hoernemann","Nagato","Axis",6,6,36,13,67,0,1,100,0,2630,"Zach Hoernemann","Ram - Above,None,None",10,903.49650349650358,"Bob Hoernemann",903.49650349650358]
["Justin Ragucci","Rodney","Axis",6,6,101,22,60,0,1,0,0,3250,"Kevin Plumer","None,None,None",10,1003.4965034965036,"Justin Ragucci",1003.4965034965036]
["Kevin Plumer","Missouri","Allied",7,8,54,10,23,0,1,0,0,1430,"Justin Ragucci","None,None,None",10,1696.3503649635036,"Kevin Plumer",1696.3503649635036]
["Brian Lamb","Seydlitz","Allied",4,4.5,9,0,4,0,1,0,0,210,"Tyler Helland","None,None,None",8,1357.0802919708028,"Brian Lamb",1357.0802919708028]
["Nathan Graham","Bismarck","Axis",6,6.5,71,4,10,0,1,0,0,1090,"Rick Whitsell","None,None,None",10,1003.4965034965036,"Nathan Graham",1003.4965034965036]
["McCoy Helland","Zara","Axis",3,3,1,2,9,0,1,0,0,320,"Thomas Tanner","None,None,None",7,702.44755244755243,"McCoy Helland",702.44755244755243]
["Matthew Larson","Nagato","Axis",6,6,20,6,8,0,1,0,0,560,"Thomas Tanner","None,None,None",10,1003.4965034965036,"Matthew Larson",1003.4965034965036]
["Matt Andrews","VV","Allied",6,6.5,23,5,28,0,1,0,0,1170,"Tyler Helland","None,None,None",10,1696.3503649635036,"Matt Andrews",1696.3503649635036]
["Evan Fowler","Iron Duke","Allied",5,5,17,1,2,0,1,0,0,250,"Ken Arena","None,None,None",9,1526.7153284671533,"Evan Fowler",1526.7153284671533]
["Mark Roe","North Carolina","Axis",6,6,1,1,3,1,1,700,1,1120,"Evan Fowler","Ram Sink,None,None",10,303.49650349650358,"Mark Roe",103.49650349650358]
["Chris Pearce","Bismarck","Allied",6,6.5,15,1,8,0,1,0,0,410,"Will Cover","None,None,None",10,1696.3503649635036,"Chris Pearce",1696.3503649635036]
["Nathan Armstrong","Baden","Allied",5,5.5,6,0,4,0,1,0,0,180,"Tyler Helland","None,None,None",9,1526.7153284671533,"Nathan Armstrong",1526.7153284671533]
["Tom Palmer","Montana","Allied",6,6.5,122,17,55,0,1,0,0,3210,"Andy Terpstra","None,None,None",10,1696.3503649635036,"Tom Palmer",1696.3503649635036]
["Andy Terpstra","Nagato","Axis",6,6,41,18,33,0,1,0,0,1760,"Tom Palmer","None,None,None",10,1003.4965034965036,"Andy Terpstra",1003.4965034965036]
["Will Cover","South Dakota","Axis",6,6,57,16,31,1,1,0,1,2820,"Steven Andrews","None,None,None",10,1003.4965034965036,"Will Cover",803.49650349650358]
["Thomas Tanner","Ostfriesland","Allied",4,4.5,34,10,13,0,1,0,0,930,"Tyler Helland","None,None,None",8,1357.0802919708028,"Thomas Tanner",1357.0802919708028]
["Caleb Smith","Jean Bart","Allied",6,6.5,60,16,51,0,1,0,0,2450,"Justin Ragucci","None,None,None",10,1696.3503649635036,"Caleb Smith",1696.3503649635036]
["Richard Whitsell","Fiji","Allied",3,3,2,1,4,0,1,0,0,160,"Nathan Graham","None,None,None",7,1187.4452554744526,"Richard Whitsell",1187.4452554744526]
["Steve Andrews","Jean Bart","Allied",6,6.5,20,3,20,0,1,0,0,860,"Craig Singer","None,None,None",10,1696.3503649635036,"Steve Andrews",1696.3503649635036]
["Kas Gaigalas","Washington","Axis",6,6,89,3,27,1,1,0,1,2760,"John Stangel","None,None,None",10,1003.4965034965036,"Kas Gaigalas",803.49650349650358]
["Zach Hoernemann","Nagato","Allied",6,6,57,4,32,0,1,0,0,1610,"Lou Maszaros","None,None,None",10,1696.3503649635036,"Zach Hoernemann",1696.3503649635036]
["Lou Meszaros","Courbet","Axis",4,4.5,12,6,18,0,1,0,0,780,"Zack Hoernemann","None,None,None",8,802.79720279720277,"Lou Meszaros",802.79720279720277]
["Bryan Box","Idaho","Allied",5,5.5,12,2,6,0,1,0,0,340,"Rob Arena","None,None,None",9,1526.7153284671533,"Bryan Box",1526.7153284671533]
["Mike Smith","Seydlitz","Axis",4,4.5,28,12,37,0,1,0,0,1630,"Kevin Plumer","None,None,None",8,802.79720279720277,"Mike Smith",802.79720279720277]
["Tyler Helland","Yamato","Axis",7,8,126,17,27,0,1,0,0,2410,"Nate Armstrong","None,None,None",10,1003.4965034965036,"Tyler Helland",1003.4965034965036]

{"sheet":"Nats July Tues Campaign","index":4,"n_rows":24,"n_cols":43,"rows_kept":24,"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,null,"Battle Location and Month (i.e. MD May)","Nats July",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":25950},"Fleet Penalties:",{"$f":"B16","v":0},"Fleet Score:",{"$f":"B17","v":25950},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":33650},"Fleet Penalties:",{"$f":"C16","v":0},"Fleet Score:",{"$f":"C17","v":33650},null,null,null,null,"Kevin Plumer","Allied","Bosque",41.5,4,2200,null,"Zach Hoernemann","Allied","Nagato",6,1000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matt Andrews","Allied","Freighter",42,1,550,null,"Bryan Box","Allied","Idaho",5,900]
["Fleet:",{"$f":"B2","v":"Allied"},{"$f":"B3","v":"Axis"},null,null,null,null,null,null,null,null,null,null,null,null,"Nathan Armstrong","Allied","Red Oak Victory",38,3,1650,null,"Caleb Smith","Allied","Tromp",1,400]
["Targets Remaining:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nathan Armstrong","Allied","Patrick Henry",51.25,4,2200,null,"John Stangel","Allied","Verti",3,700]
["Target Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bryan Box","Allied","LST",26.75,3,900,null,"Will Cover","Axis","South Dakota",6,1000]
["Convoy Run Points:",24350,30650,null,null,null,null,null,null,null,null,null,null,null,null,"Bryan Box","Allied","C3",41.5,1,550,null,"Mike Smith","Axis","Glorie",2,600]
["Scuttled Convoy Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evan Fowler","Allied","Shinano ",72,6,5100]
["Sink Points:",1600,3000,null,null,null,null,null,null,null,null,null,null,null,null,"Brian Koehler","Allied","Altmark",48.75,1,550]
["Convoy Friendly Ram Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tom Palmer","Allied","Saratoga",74,8,6800]
["Ram Penalty Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caleb Smith","Allied","Admiral Simms",51.25,1,550]
["No Ship on Water Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thomas Tanner","Allied","Oki-Maru",35.5,6,3300]
["Convoy Run Every 10 Min Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Justin Ragucci","Axis","Hospital",42,10,5500]
["Total Points:",{"$f":"B7+B8+B9+B10+B11+B13+B14","v":25950},{"$f":"C7+C8+C9+C10+C11+C13+C14","v":33650},null,null,null,null,null,null,null,null,null,null,null,null,"Will Cover","Axis","Freighter",42,1,550]
["Total Penalties:",{"$f":"B12","v":0},{"$f":"C12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Matthew Larson","Axis","Carrier",42,4,2200]
["Fleet Score:",{"$f":"B15-B16","v":25950},{"$f":"C15-C16","v":33650},null,null,null,null,null,null,null,null,null,null,null,null,"Craig Singer","Axis","Altmark",48.75,9,4950]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McCoy Helland","Axis","Tyler Maru",42,2,1100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robert Arena","Axis","Saratoga",74,2,1700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lou Meszaros","Axis","Victory ",41.5,7,3850]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ken Arena","Axis","Tyler Maru",42,6,3300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nathan Graham","Axis","Akitsu Maru",38.5,11,6050]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alexander Hampton","Axis","LST",26.75,3,900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mike Smith","Axis","Freighter",42,1,550]

{"sheet":"Nats July Wed Cruiser","index":5,"n_rows":16,"n_cols":20,"rows_kept":16,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",16,"Fleet Weight:",31,"Fleet Battle Damage:",4670,"Fleet Score:",3260.000244140625,null,"Battle Day","Wed",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",21,"Fleet Weight:",46,"Fleet Battle Damage:",3260,"Fleet Score:",4670,null,"Battle Number","Cruiser",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"]
["McCoy Helland","Zara","Allied",3,3,2,1,6,0,1,0,0,220,"McCoy Helland","None,None,None",7,736.12903225806451,"McCoy Helland",736.12903225806451,0]
["Matthew Larson","Glorie","Allied",2,2.5,1,0,1,0,0,0,0,40,"Matthew Larson","None,None,None",3,315.48387096774195,"Matthew Larson",315.48387096774195,0]
["Bob Hoernemann","Radetsky","Allied",3,3.5,39,9,1,0,1,0,0,600,"Bob Hoernemann","None,None,None",7,736.12903225806451,"Bob Hoernemann",736.12903225806451,0]
["John Stangel","Verti","Allied",3,3.5,72,5,33,1,1,0,1,2510,"Bryan Box","None,None,None",7,736.12903225806451,"John Stangel",536.12903225806451,0]
["Zach Hoernemann","Radetsky","Allied",3,3.5,72,8,14,0,1,0,0,1300,"Zach Hoernemann","None,None,None",7,736.12903225806451,"Zach Hoernemann",736.12903225806451,0]
["Caleb Smith","Mississippi","Axis",3,3.5,34,1,9,0,1,0,0,630,"Caleb Smith","None,None,None",7,710.6521739130435,"Caleb Smith",710.6521739130435,214.56518023947012]
["Tyler Helland","Duca D' Aosta","Axis",2,2.5,6,3,1,0,1,0,0,150,"Tyler Helland","None,None,None",6,609.13043478260863,"Tyler Helland",609.13043478260863,183.91301163383153]
["Mike Smith","Glorie","Axis",2,2.5,40,0,5,0,1,0,0,550,"Mike Smith","None,None,None",6,609.13043478260863,"Mike Smith",609.13043478260863,183.91301163383153]
["Kevin Plumer","Radetsky","Axis",3,3.5,34,3,19,0,1,0,0,970,"Tyler Helland","None,None,None",7,710.6521739130435,"Kevin Plumer",710.6521739130435,214.56518023947012]
["Lou Meszaros","Suffren","Axis",3,3,19,2,10,0,1,0,0,530,"Lou Meszaros","None,None,None",7,710.6521739130435,"Lou Meszaros",710.6521739130435,214.56518023947012]
["Andy Terpstra","Glorie","Axis",2,2.5,2,0,1,0,1,0,0,50,"Matthew Larson","None,None,None",6,609.13043478260863,"Andy Terpstra",609.13043478260863,183.91301163383153]
["Thomas Tanner","Hannover","Axis",3,3.5,19,5,3,0,1,0,0,380,"Thomas Tanner","None,None,None",7,710.6521739130435,"Thomas Tanner",710.6521739130435,214.56518023947012]

{"sheet":"Nats July Wed Cruiser 2","index":6,"n_rows":16,"n_cols":20,"rows_kept":16,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",22,"Fleet Weight:",47,"Fleet Battle Damage:",6170,"Fleet Score:",4830.00048828125,null,"Battle Day","Wed",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",15,"Fleet Weight:",33,"Fleet Battle Damage:",4830,"Fleet Score:",5970,null,"Battle Number","Cruiser 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"]
["Thomas Tanner","Hannover","Axis",3,3.5,22,7,6,0,1,200,0,540,"Thomas Tanner","Ram - Below,None,None",7,1108.7878787878788,"Thomas Tanner",1108.7878787878788,241.81807824337122]
["Andy Terpstra","Glorie","Axis",2,2.5,2,1,1,1,1,0,1,670,"Andy Terpstra","None,None,None",6,1121.8181818181818,"Andy Terpstra",921.81818181818176,207.27263849431819]
["Lou Meszaros","Suffren","Axis",3,3,75,13,12,0,1,0,0,1370,"Tyler Helland","None,None,None",7,1308.7878787878788,"Lou Meszaros",1308.7878787878788,241.81807824337122]
["Kevin Plumer","Radetsky","Axis",3,3.5,30,8,10,0,1,0,0,760,"Kevin Plumer","None,None,None",7,1308.7878787878788,"Kevin Plumer",1308.7878787878788,241.81807824337122]
["Mike Smith","Glorie","Axis",2,2.5,43,8,10,1,1,0,1,1490,"Mike Smith","None,None,None",6,1121.8181818181818,"Mike Smith",921.81818181818176,207.27263849431819]
["Tyler Helland","Duca D' Aosta","Allied",2,2.5,6,5,3,0,1,0,0,250,"Tyler Helland","None,None,None",6,616.595744680851,"Tyler Helland",616.595744680851,0]
["Caleb Smith","Mississippi","Allied",3,3.5,29,1,6,1,1,0,1,1190,"Caleb Smith","None,None,None",7,719.36170212765956,"Caleb Smith",519.36170212765956,0]
["Zach Hoernemann","Radetsky","Allied",3,3.5,68,13,17,0,1,0,0,1450,"Zach Hoernemann","None,None,None",7,719.36170212765956,"Zach Hoernemann",719.36170212765956,0]
["Bryan Box","Verti","Allied",3,3.5,39,10,21,0,1,0,0,1220,"Bryan Box","None,None,None",7,719.36170212765956,"Bryan Box",719.36170212765956,0]
["Bob Hoernemann","Radetsky","Allied",3,3.5,76,15,22,0,1,0,0,1720,"Bob Hoernemann","None,None,None",7,719.36170212765956,"Bob Hoernemann",719.36170212765956,0]
["Matthew Larson","Glorie","Allied",2,2.5,4,2,1,0,1,0,0,110,"Matthew Larson","None,None,None",6,616.595744680851,"Matthew Larson",616.595744680851,0]
["McCoy Helland","Zara","Allied",3,3,9,1,4,0,1,0,0,230,"McCoy Helland","None,None,None",7,719.36170212765956,"McCoy Helland",719.36170212765956,0]

{"sheet":"Nats July Wed Nite","index":7,"n_rows":13,"n_cols":20,"rows_kept":13,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",37,"Fleet Weight:",62,"Fleet Battle Damage:",890,"Fleet Score:",4830,null,"Battle Day","Wed",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",10,"Fleet Weight:",18,"Fleet Battle Damage:",4830,"Fleet Score:",890,null,"Battle Number","Nite",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"]
["Chris Pearce","Bismarck","Allied",6,6.5,10,2,3,0,1,0,0,230,"Justin Ragucci","None,None,None",10,779.0322580645161,"Chris Pearce",779.0322580645161]
["Thomas Tanner","Ostfriesland","Allied",4,4.5,5,1,1,0,1,0,0,100,"Ken Arena","None,None,None",8,623.22580645161293,"Thomas Tanner",623.22580645161293]
["Kevin Plumer","Kongo","Allied",4,4.5,17,2,2,0,1,0,0,270,"Justin Ragucci","None,None,None",8,623.22580645161293,"Kevin Plumer",623.22580645161293]
["Caleb Smith","Jean Bart","Allied",6,6.5,3,0,0,0,1,0,0,30,"Robert Arena","None,None,None",10,779.0322580645161,"Caleb Smith",779.0322580645161]
["Richard Whitsell","Fiji","Allied",3,3,1,0,0,0,1,0,0,10,"Thomas Tanner","None,None,None",7,545.32258064516122,"Richard Whitsell",545.32258064516122]
["Tom Palmer","Montana","Allied",6,6.5,5,0,3,0,1,0,0,140,"Thomas Tanner","None,None,None",10,779.0322580645161,"Tom Palmer",779.0322580645161]
["Alexander Hampton","Dreadnaught","Axis",4,4,36,7,15,1,1,0,1,1750,"Nate Armstrong","None,None,None",8,395.55555555555554,"Alexander Hampton",195.55555555555554]
["Bryan Box","Idaho","Allied",5,5.5,6,1,1,0,1,0,0,110,"Tyler Helland","None,None,None",9,701.12903225806451,"Bryan Box",701.12903225806451]
["Kas Gaigalas","Washington","Axis",6,6,73,12,37,1,1,0,1,3080,"Kevin Plumer","None,None,None",10,494.44444444444446,"Kas Gaigalas",294.44444444444446]

{"sheet":"Nats July Thurs 1","index":8,"n_rows":35,"n_cols":20,"rows_kept":35,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",76,"Fleet Weight:",104,"Fleet Battle Damage:",21980,"Fleet Score:",20450,null,"Battle Day","Thurs",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",89,"Fleet Weight:",151,"Fleet Battle Damage:",20450,"Fleet Score:",20880,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"]
["Evan Fowler","Iron Duke","Allied",5,5,44,11,67,1,1,0,1,3570,"Ken Arena","None,None,None",9,1769.7115384615383,null,1569.7115384615383]
["Bob Hoernemann","Nagato","Axis",6,6,8,6,17,0,1,0,0,710,"Evan Fowler","None,None,None",10,1455.6291390728477,null,1455.6291390728477]
["Zach Hoernemann","Nagato","Allied",6,6,78,12,39,0,1,0,0,2190,"Bob Hoernemann","None,None,None",10,1966.346153846154,null,1966.346153846154]
["John Stangel","Verti","Allied",3,3.5,1,0,0,0,0,0,0,10,"Kas","None,None,None",3.5,688.22115384615381,null,688.22115384615381]
["Thomas Tanner","Ostfriesland","Allied",4,4.5,30,6,16,0,1,0,0,900,"McCoy Helland","None,None,None",8,1573.0769230769231,null,1573.0769230769231]
["Matt Andrews","VV","Allied",6,6.5,76,9,33,1,1,0,1,2930,"Tyler Helland","None,None,None",10,1966.346153846154,null,1766.346153846154]
["John Stangel","Kongo","Allied",4,4.5,3,3,10,1,0,0,0,1190,"Matthew Larson","None,None,None",4,786.53846153846155,null,786.53846153846155]
["McCoy Helland","Zara","Axis",3,3,6,0,1,0,1,0,0,90,"Kevin Plumer","None,None,None",7,1018.9403973509934,null,1018.9403973509934]
["Mike Smith","Seydlitz","Axis",4,4.5,18,8,10,0,1,0,0,640,"Kevin Plumer","None,None,None",8,1164.5033112582782,null,1164.5033112582782]
["Kevin Plumer","Missouri","Allied",7,8,73,7,24,0,1,0,0,1590,"Will Cover","None,None,None",10,1966.346153846154,null,1966.346153846154]
["Will Cover","South Dakota","Axis",6,6,125,32,80,1,1,0,1,5290,"Kevin Plumer","None,None,None",10,1455.6291390728477,null,1255.6291390728477]
["Andy Terpstra","Nagato","Axis",6,6,29,6,26,0,1,0,0,1190,"Thomas Tanner","None,None,None",10,1455.6291390728477,null,1455.6291390728477]
["Justin Ragucci","Rodney","Axis",6,6,79,7,11,0,1,100,0,1260,"Matthew Andrews","Ram - Above,None,None",10,1355.6291390728477,null,1355.6291390728477]
["Steve Andrews","Radetsky","Allied",3,3.5,27,8,26,1,0,0,0,1910,"Andy Terpstra","None,None,None",3.5,688.22115384615381,null,688.22115384615381]
["Matthew Larson","Nagato","Axis",6,6,22,2,8,0,0,1000,0,500,"Evan Fowler","None,None,None",10,455.62913907284769,null,455.62913907284769]
["Steve Andrews","VV","Allied",6,6.5,22,1,19,1,0,0,0,1810,"Andy Terpstra","None,None,None",5,983.17307692307702,null,983.17307692307702]
["Nathan Graham","Bismarck","Axis",6,6.5,102,22,29,0,1,0,0,2330,"Richard Whitsell","None,None,None",10,1455.6291390728477,null,1455.6291390728477]
["Richard Whitsell","Fiji","Allied",3,3,13,3,5,0,1,0,0,340,"Nathan Graham","None,None,None",7,1376.4423076923076,null,1376.4423076923076]
["Lou Meszaros","Courbet","Axis",4,4.5,6,3,4,1,1,0,1,1040,"Matthew Andrews","None,None,None",8,1164.5033112582782,null,964.50331125827825]
["Nathan Armstrong","Baden","Allied",5,5.5,24,12,20,0,1,0,0,1080,"Alex Hampton","None,None,None",9,1769.7115384615383,null,1769.7115384615383]
["Alexander Hampton","Dreadnaught","Axis",4,4,25,6,2,0,1,0,0,430,"Nate Armstrong","None,None,None",8,1164.5033112582782,null,1164.5033112582782]
["Kas Gaigalas","Washington","Axis",6,6,40,11,27,0,1,0,0,1430,"Zach Hoernemann","None,None,None",10,1455.6291390728477,null,1455.6291390728477]
["Mark Roe","North Carolina","Axis",6,6,25,3,20,1,1,0,0,910,"Caleb Smith","None,None,None",10,1455.6291390728477,null,1455.6291390728477]
["Tyler Helland","Yamato","Axis",7,8,93,16,16,0,1,0,0,1730,"Chris Pearce","None,None,None",10,1455.6291390728477,null,1455.6291390728477]
["Brian Lamb","Seydlitz","Axis",4,4.5,15,4,10,0,1,0,0,530,"Justin Ragucci","None,None,None",8,1164.5033112582782,null,1164.5033112582782]
["Ken Arena","Iron Duke","Axis",5,5,4,0,6,0,1,0,0,220,"Caleb Smith","None,None,None",9,1310.0662251655629,null,1310.0662251655629]
["Caleb Smith","Jean Bart","Allied",6,6.5,48,8,47,0,1,0,0,2050,"Ken Arena","None,None,None",10,1966.346153846154,null,1966.346153846154]
["Tom Palmer","Montana","Allied",6,6.5,66,4,44,0,1,0,0,2060,"Tyler Helland","None,None,None",10,1966.346153846154,null,1966.346153846154]
["Craig Singer","Z36","Axis",1,1.5,3,0,1,0,1,0,0,60,"Caleb Smith","None,None,None",4,582.25165562913912,null,582.25165562913912]
["Robert Arena","Arizona","Axis",5,5.5,29,6,26,1,1,0,1,2090,"Evan Fowler","None,None,None",9,1310.0662251655629,null,1110.0662251655629]
["Chris Pearce","Bismarck","Allied",6,6.5,18,1,5,0,0,0,0,350,"Tyler Helland","None,None,None",5,983.17307692307702,null,983.17307692307702]

{"sheet":"Nats July Thurs Campaign","index":9,"n_rows":26,"n_cols":43,"rows_kept":26,"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,null,"Battle Location and Month (i.e. MD May)","Nats July",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":32300},"Fleet Penalties:",{"$f":"B16","v":0},"Fleet Score:",{"$f":"B17","v":32300},null,"Battle Day","Thurs",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":31450},"Fleet Penalties:",{"$f":"C16","v":0},"Fleet Score:",{"$f":"C17","v":31450},null,null,null,null,"Justin Ragucci","Axis","Hospital",42,8,4400,null,"Caleb Smith","Allied","Tromp",1,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McCoy Helland","Axis","Freighter",42,6,3300]
["Fleet:",{"$f":"B2","v":"Allied"},{"$f":"B3","v":"Axis"},null,null,null,null,null,null,null,null,null,null,null,null,"Alexander Hampton","Axis","Freighter",42,5,2750]
["Targets Remaining:",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nate","Axis","Akitsu Maru",42,10,5500]
["Target Points:",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matthew Larson","Axis","LST",31.75,2,600]
["Convoy Run Points:",32300,30050,null,null,null,null,null,null,null,null,null,null,null,null,"Andy Terpstra","Axis","Carrier",42,2,1100]
["Scuttled Convoy Points:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,"Bob Hoernemann","Axis","Carrier",42,1,550]
["Sink Points:",null,400,null,null,null,null,null,null,null,null,null,null,null,null,"Craig Singer","Axis","Altmark",42,7,3850]
["Convoy Friendly Ram Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Will Cover","Axis","LST",31.75,1,300]
["Ram Penalty Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Will Cover","Axis","CVL",42,7,3850]
["No Ship on Water Points:",null,1000,null,null,null,null,null,null,null,null,null,null,null,null,"Tyler Helland","Axis","Freighter",42,1,550]
["Convoy Run Every 10 Min Points:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,"Ken Arena","Axis","Freighter",42,6,3300]
["Total Points:",{"$f":"B7+B8+B9+B10+B11+B13+B14","v":32300},{"$f":"C7+C8+C9+C10+C11+C13+C14","v":31450},null,null,null,null,null,null,null,null,null,null,null,null,"Matt Andrews","Allied","Admiral Simms",42,5,2750]
["Total Penalties:",{"$f":"B12","v":0},{"$f":"C12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Nathan Armstrong","Allied","C3",42,5,2750]
["Fleet Score:",{"$f":"B15-B16","v":32300},{"$f":"C15-C16","v":31450},null,null,null,null,null,null,null,null,null,null,null,null,"Nathan Armstrong","Allied","Red Oak Victory",42,3,1650]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bryan Box","Allied","LST",31.75,8,2400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evan Fowler","Allied","Shinano",72,6,5100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brian Lamb","Allied","LST",31.75,4,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tom Palmer","Allied","Saratoga",72,9,7650]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caleb Smith","Allied","Admiral Taylor",42,6,3300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"John Stangel","Allied","Bogue",42,1,550]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"John Stangel","Allied","Patrick Henry",42,5,2750]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thomas Tanner","Allied","Oki-Maru",42,3,1650]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thomas Tanner","Allied","Patrick Henry",42,1,550]

{"sheet":"Nats July Fri 1","index":10,"n_rows":30,"n_cols":20,"rows_kept":30,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",56,"Fleet Weight:",90,"Fleet Battle Damage:",13660,"Fleet Score:",16600,null,"Battle Day","Fri",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",77,"Fleet Weight:",134,"Fleet Battle Damage:",16600,"Fleet Score:",13460.0009765625,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"]
["Nathan Graham","Gearing","Axis",1,1.5,2,0,1,0,1,0,0,50,"Thomas Tanner","None,None,None",4,407.76119402985074,"Nathan Graham",407.76119402985074]
["Kevin Plumer","Missouri","Allied",7,8,46,11,40,0,1,0,0,1880,"Tyler Helland","None,None,None",10,1844.4444444444443,"Kevin Plumer",1844.4444444444443]
["Kas Gaigalas","Washington","Axis",6,6,43,11,25,1,1,0,1,2400,"Caleb Smith","None,None,None",10,1019.4029850746268,"Kas Gaigalas",819.40298507462683]
["Mark Roe","Graff Spee","Axis",3,3.5,3,1,6,0,1,0,0,230,"Tom Palmer","None,None,None",7,713.58208955223881,"Mark Roe",713.58208955223881]
["Justin Ragucci","Rodney","Axis",6,6,84,14,31,1,1,0,1,3050,"Matthew Andrews","None,None,None",10,1019.4029850746268,"Justin Ragucci",819.40298507462683]
["Caleb Smith","Jean Bart","Allied",6,6.5,47,7,32,0,1,0,0,1570,"Justin Ragucci","None,None,None",10,1844.4444444444443,"Caleb Smith",1844.4444444444443]
["Will Cover","South Dakota","Axis",6,6,59,15,60,0,1,0,0,2690,"Chris Pearce","None,None,None",10,1019.4029850746268,"Will Cover",1019.4029850746268]
["Robert Arena","Arizona","Axis",5,5.5,13,0,5,1,1,0,1,1180,"Steven Andrews","None,None,None",9,917.46268656716416,"Robert Arena",717.46268656716416]
["Steve Andrews","Des Moise","Allied",3,3.5,17,4,0,0,1,0,0,250,"Nate Graham","None,None,None",7,1291.1111111111111,"Steve Andrews",1291.1111111111111]
["Ken Arena","Iron Duke","Axis",5,5,18,3,23,0,1,0,0,930,"Evan Fowler","None,None,None",9,917.46268656716416,"Ken Arena",917.46268656716416]
["Tyler Helland","Yamato","Axis",7,8,33,7,10,0,1,0,0,770,"Kevin Plumer","None,None,None",10,1019.4029850746268,"Tyler Helland",1019.4029850746268]
["Mike Smith","Seydlitz","Axis",4,4.5,25,8,20,0,1,0,0,1010,"Kevin Plumer","None,None,None",8,815.52238805970148,"Mike Smith",815.52238805970148]
["Brian Lamb","Seydlitz","Allied",4,4.5,54,8,27,0,1,0,0,1510,"Andy Terpstra","None,None,None",8,1475.5555555555557,"Brian Lamb",1475.5555555555557]
["Lou Meszaros","Courbet","Axis",4,4.5,10,2,19,0,1,0,0,710,"Tommy Tanner","None,None,None",8,815.52238805970148,"Lou Meszaros",815.52238805970148]
["John Stangel","Kongo","Allied",4,4.5,14,6,44,0,1,0,0,1580,"Robert Arena","None,None,None",8,1475.5555555555557,"John Stangel",1475.5555555555557]
["Alexander Hampton","Dreadnaught","Axis",4,4,22,3,9,0,1,0,0,550,"Nathan Armstrong","None,None,None",8,815.52238805970148,"Alexander Hampton",815.52238805970148]
["Andy Terpstra","Nagato","Axis",6,6,7,5,18,0,1,0,0,710,"John Stangel","None,None,None",10,1019.4029850746268,"Andy Terpstra",1019.4029850746268]
["Bryan Box","Idaho","Allied",5,5.5,7,2,5,0,1,0,0,260,"Ken Arena","None,None,None",9,1660,"Bryan Box",1660]
["McCoy Helland","Zara","Axis",3,3,0,0,0,0,1,0,0,0,"Zach Hoernemann","None,None,None",7,713.58208955223881,"McCoy Helland",713.58208955223881]
["Matthew Larson","Nagato","Axis",6,6,57,3,12,0,1,0,0,990,"Caleb Smith","None,None,None",10,1019.4029850746268,"Matthew Larson",1019.4029850746268]
["Bob Hoernemann","Nagato","Axis",6,6,40,7,25,0,1,200,0,1290,"Matthew Andrews","None,None,None",10,819.40298507462683,"Bob Hoernemann",819.40298507462683]
["Craig Singer","Z36","Axis",1,1.5,1,0,1,0,1,0,0,40,"Tom Palmer","None,None,None",4,407.76119402985074,"Craig Singer",407.76119402985074]
["Zach Hoernemann","Nagato","Allied",6,6,65,9,46,0,1,0,0,2210,"Lou Meszaros","None,None,None",10,1844.4444444444443,"Zach Hoernemann",1844.4444444444443]
["Thomas Tanner","Ostfriesland","Allied",4,4.5,41,13,15,0,1,0,0,1120,"Alex Hampton","None,None,None",8,1475.5555555555557,"Thomas Tanner",1475.5555555555557]
["Chris Pearce","Bismarck","Allied",6,6.5,19,4,11,0,1,0,0,600,"Will Cover","None,None,None",10,1844.4444444444443,"Chris Pearce",1844.4444444444443]
["Tom Palmer","Montana","Allied",6,6.5,86,16,50,0,1,0,0,2680,"Mark Roe","None,None,None",10,1844.4444444444443,"Tom Palmer",1844.4444444444443]

{"sheet":"Nats July Fri Destroyer","index":11,"n_rows":6,"n_cols":20,"rows_kept":6,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",1.5,"Fleet Weight:",4,"Fleet Battle Damage:",50,"Fleet Score:",280,null,"Battle Day","Fri",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",1.5,"Fleet Weight:",4,"Fleet Battle Damage:",280,"Fleet Score:",50,null,"Battle Number","Destroyer",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"]
["Nathan Graham","Gearing","Allied",1,1.5,5,0,0,0,1,0,0,50,"Craig Singer","None,None,None",4,280,"Nathan Graham",280,230]
["Craig Singer","Z36","Axis",1,1.5,25,0,1,0,1,0,0,280,"Nate Graham","None,None,None",4,50,"Craig Singer",50,0]

{"sheet":"Nats July Fri Admirals","index":12,"n_rows":6,"n_cols":20,"rows_kept":6,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",8,"Fleet Weight:",10,"Fleet Battle Damage:",1710,"Fleet Score:",2450,null,"Battle Day","Fri",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",8,"Fleet Weight:",10,"Fleet Battle Damage:",2450,"Fleet Score:",1710,null,"Battle Number","Admirals",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"]
["Kevin Plumer","Missouri","Allied",7,8,50,8,35,0,1,0,0,1710,"Tyler Helland","None,None,None",10,2450,"Kevin Plumer",2450,740]
["Tyler Helland","Missouri","Axis",7,8,78,16,45,0,1,0,0,2450,"Kevin Plumer","None,None,None",10,1710,"Tyler Helland",1710,0]

{"sheet":"Nats July Fri Miss V. Jean","index":13,"n_rows":6,"n_cols":20,"rows_kept":6,"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)","Nats July",null,null,null,null,"Fleet"]
["Fleet 1 :","Allied",null,"Fleet Units:",8,"Fleet Weight:",10,"Fleet Battle Damage:",1370,"Fleet Score:",2810,null,"Battle Day","Fri",null,null,null,null,"Mini-Fleet"]
["Fleet 2 :","Axis",null,"Fleet Units:",6.5,"Fleet Weight:",10,"Fleet Battle Damage:",2810,"Fleet Score:",1370,null,"Battle Number","Miss V. Jean",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"]
["Kevin Plumer","Missouri","Allied",7,8,37,5,30,0,1,0,0,1370,"Caleb Smith","None,None,None",10,2810,"Kevin Plumer",2810,1440]
["Caleb Smith","Jean Bart","Axis",6,6.5,67,5,68,0,1,0,0,2810,"Kevin Plumer","None,None,None",10,1370,"Caleb Smith",1370,0]

{"sheet":"Instructions","index":14,"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"]