{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Player 1 ships","Player 2 ships","PLAY"],"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"merged":[[1,1,4,8],[6,1,9,8],[11,1,14,8]]}
[]
[null,"1)  Player 1 Enter ships into the \"Player 1 ships\" sheet by entering the number 4 consecutively for 4 cell ships, 3 for 3, and 2 for 2.  After Player 1 has entered all the ships, click on \"Player 2 ships\" sheet and let player 2 enter ships into the grid.  After Player 2 has entered ships, Player 2 should click on the sheet labeled PLAY and the players can begin play.  (Note:  \"SHIP TOTAL MET\" should appear at the bottom of each screen when the grid is ready)   NO peaking while opponent is entering ships and do not return to the other sheets until a player has won the game."]
[]
[]
[]
[]
[null,"2)  Enter S for shoot into the cell that you want to shoot at.  You will be able to see the number of shots as well as the number of hits left at the top of the screen on the PLAY sheet.  Take turns shooting at the opponents ships.  When you have sunk all of the opponents ships, SUNK will show up at the bottom of the sheet in red.  If one player gets ahead of another, the cells that contain the number of shots will turn yellow."]
[]
[]
[]
[]
[null,"3)  To reset the game, simply select all of the unlocked cells and hit the delete key.  If you want to change the number of 4, 3, and 2 cell ships, change that at the top of the \"Player 1 ships\" sheet only.  The password to unlock any of the sheets in necc."]

{"sheet":"Player 1 ships","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"merged":[[0,1,0,9],[18,3,18,8]]}
[null,"Player 1"]
[{"$nulls":5},"4 Cell ships",3]
[{"$nulls":5},"3 Cell ships",1]
[null,null,"Enter ships",null,null,"2 Cell ships",2]
[]
[]
[{"$nulls":3},4]
[{"$nulls":3},4,null,null,2,2]
[{"$nulls":3},4]
[{"$nulls":3},4]
[{"$nulls":6},4,4,4,4]
[]
[{"$nulls":6},2]
[{"$nulls":4},3,null,2,null,4]
[{"$nulls":4},3,{"$nulls":3},4]
[{"$nulls":4},3,{"$nulls":3},4]
[{"$nulls":8},4]
[]
[null,null,{"$f":"IF(COUNT(B6:J17)=(G2*4)+(G3*3)+(G4*2),SUM(B6:J17),0)","v":65},"SHIP TOTAL MET",{"$nulls":5},{"$f":"(G2*4*4)+(G3*3*3)+(G4*2*2)","v":65}]
[null,null,{"$f":"COUNT(B6:J17)","v":19}]

{"sheet":"Player 2 ships","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,1,0,9],[18,3,18,8]]}
[null,"Player 2"]
[{"$nulls":5},"4 Cell ships",{"$f":"'Player 1 ships'!G2","v":3}]
[{"$nulls":5},"3 Cell ships",{"$f":"'Player 1 ships'!G3","v":1}]
[null,null,"Enter ships",null,null,"2 Cell ships",{"$f":"'Player 1 ships'!G4","v":2}]
{"$rows_empty":14}
[null,null,{"$f":"IF(COUNT(B6:J17)=(G2*4)+(G3*3)+(G4*2),SUM(B6:J17),0)","v":0},"SHIP TOTAL MET",{"$nulls":5},{"$f":"(G2*4*4)+(G3*3*3)+(G4*2*2)","v":65}]

{"sheet":"PLAY","index":3,"n_rows":30,"n_cols":20,"rows_kept":30,"merged":[[15,1,15,9],[15,11,15,19],[29,1,33,9],[29,11,33,19]]}
[]
[null,"Number of Shots",{"$nulls":3},{"$f":"COUNTIF(B4:J15,\"S\")","v":60},null,null,"Enter S to shoot",null,null,"Number of Shots",{"$nulls":3},{"$f":"COUNTIF(L4:T15,\"S\")","v":60}]
[null,"Hits left",{"$nulls":3},{"$f":"A30-COUNTIF(B17:J28,\"HIT\")","v":0},{"$nulls":5},"Hits left",{"$nulls":3},{"$f":"A30-COUNTIF(L17:T28,\"HIT\")","v":19}]
["Player 2 Shots","s","s","s","s",{"$nulls":3},"s","s","Player 1 Shots","s"]
[null,"s","s","s",{"$nulls":4},"s","s",null,null,"s","s","s","s","s","s","s"]
[null,null,"s","s","s","s","s","s",{"$nulls":3},"s","s",null,"s","s","s","s","s"]
[null,"s",null,"s",null,null,"s","s",{"$nulls":5},"s","s","s","s",null,"s"]
[null,"s",null,"s",null,null,"s","s","s","s",null,null,"s","s","s","s","s","s","s"]
[{"$nulls":6},"s","s","s","s",{"$nulls":3},"s","s",null,"s",null,"s"]
[null,"s",null,null,"s","s","s",null,"s",{"$nulls":3},"s",null,"s","s","s",null,"s"]
[{"$nulls":4},"s","s","s",null,"s",{"$nulls":3},"s",null,"s",null,"s","s","s"]
[{"$nulls":4},"s","s","s","s","s","s",null,null,"s","s","s","s","s",null,"s"]
[{"$nulls":4},"s",null,null,"s","s",{"$nulls":3},"s","s",null,"s","s","s","s"]
[null,null,"s",null,"s",null,null,"s","s","s",null,null,"s","s","s","s","s","s","s"]
[null,null,"s","s","s",null,null,"s","s","s"]
[null,{"$f":"IF('Player 1 ships'!C19='Player 1 ships'!J19,\"READY\",\"SHIPS NOT IN WATER YET\")","v":"READY"},{"$nulls":9},{"$f":"IF('Player 2 ships'!C19='Player 2 ships'!J19,\"READY\",\"SHIPS NOT IN WATER YET\")","v":"SHIPS NOT IN WATER YET"}]
["Player 1 ",{"$f":"IF(B4=\"\",\"\",IF(B4=\"S\",IF('Player 1 ships'!B6>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(C4=\"\",\"\",IF(C4=\"S\",IF('Player 1 ships'!C6>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(D4=\"\",\"\",IF(D4=\"S\",IF('Player 1 ships'!D6>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(E4=\"\",\"\",IF(E4=\"S\",IF('Player 1 ships'!E6>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(F4=\"\",\"\",IF(F4=\"S\",IF('Player 1 ships'!F6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(G4=\"\",\"\",IF(G4=\"S\",IF('Player 1 ships'!G6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(H4=\"\",\"\",IF(H4=\"S\",IF('Player 1 ships'!H6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(I4=\"\",\"\",IF(I4=\"S\",IF('Player 1 ships'!I6>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(J4=\"\",\"\",IF(J4=\"S\",IF('Player 1 ships'!J6>1,\"HIT\",\"MISS\")))","v":"MISS"},"Player 2",{"$f":"IF(L4=\"\",\"\",IF(L4=\"S\",IF('Player 2 ships'!B6>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(M4=\"\",\"\",IF(M4=\"S\",IF('Player 2 ships'!C6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(N4=\"\",\"\",IF(N4=\"S\",IF('Player 2 ships'!D6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(O4=\"\",\"\",IF(O4=\"S\",IF('Player 2 ships'!E6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(P4=\"\",\"\",IF(P4=\"S\",IF('Player 2 ships'!F6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(Q4=\"\",\"\",IF(Q4=\"S\",IF('Player 2 ships'!G6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(R4=\"\",\"\",IF(R4=\"S\",IF('Player 2 ships'!H6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(S4=\"\",\"\",IF(S4=\"S\",IF('Player 2 ships'!I6>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(T4=\"\",\"\",IF(T4=\"S\",IF('Player 2 ships'!J6>1,\"HIT\",\"MISS\")))","v":""}]
["Status",{"$f":"IF(B5=\"\",\"\",IF(B5=\"S\",IF('Player 1 ships'!B7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(C5=\"\",\"\",IF(C5=\"S\",IF('Player 1 ships'!C7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(D5=\"\",\"\",IF(D5=\"S\",IF('Player 1 ships'!D7>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(E5=\"\",\"\",IF(E5=\"S\",IF('Player 1 ships'!E7>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(F5=\"\",\"\",IF(F5=\"S\",IF('Player 1 ships'!F7>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(G5=\"\",\"\",IF(G5=\"S\",IF('Player 1 ships'!G7>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(H5=\"\",\"\",IF(H5=\"S\",IF('Player 1 ships'!H7>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(I5=\"\",\"\",IF(I5=\"S\",IF('Player 1 ships'!I7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(J5=\"\",\"\",IF(J5=\"S\",IF('Player 1 ships'!J7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"A18","v":"Status"},{"$f":"IF(L5=\"\",\"\",IF(L5=\"S\",IF('Player 2 ships'!B7>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M5=\"\",\"\",IF(M5=\"S\",IF('Player 2 ships'!C7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(N5=\"\",\"\",IF(N5=\"S\",IF('Player 2 ships'!D7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(O5=\"\",\"\",IF(O5=\"S\",IF('Player 2 ships'!E7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(P5=\"\",\"\",IF(P5=\"S\",IF('Player 2 ships'!F7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(Q5=\"\",\"\",IF(Q5=\"S\",IF('Player 2 ships'!G7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R5=\"\",\"\",IF(R5=\"S\",IF('Player 2 ships'!H7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(S5=\"\",\"\",IF(S5=\"S\",IF('Player 2 ships'!I7>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T5=\"\",\"\",IF(T5=\"S\",IF('Player 2 ships'!J7>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B6=\"\",\"\",IF(B6=\"S\",IF('Player 1 ships'!B8>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(C6=\"\",\"\",IF(C6=\"S\",IF('Player 1 ships'!C8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(D6=\"\",\"\",IF(D6=\"S\",IF('Player 1 ships'!D8>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(E6=\"\",\"\",IF(E6=\"S\",IF('Player 1 ships'!E8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(F6=\"\",\"\",IF(F6=\"S\",IF('Player 1 ships'!F8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(G6=\"\",\"\",IF(G6=\"S\",IF('Player 1 ships'!G8>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(H6=\"\",\"\",IF(H6=\"S\",IF('Player 1 ships'!H8>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(I6=\"\",\"\",IF(I6=\"S\",IF('Player 1 ships'!I8>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(J6=\"\",\"\",IF(J6=\"S\",IF('Player 1 ships'!J8>1,\"HIT\",\"MISS\")))","v":""},null,{"$f":"IF(L6=\"\",\"\",IF(L6=\"S\",IF('Player 2 ships'!B8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(M6=\"\",\"\",IF(M6=\"S\",IF('Player 2 ships'!C8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(N6=\"\",\"\",IF(N6=\"S\",IF('Player 2 ships'!D8>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(O6=\"\",\"\",IF(O6=\"S\",IF('Player 2 ships'!E8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(P6=\"\",\"\",IF(P6=\"S\",IF('Player 2 ships'!F8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(Q6=\"\",\"\",IF(Q6=\"S\",IF('Player 2 ships'!G8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R6=\"\",\"\",IF(R6=\"S\",IF('Player 2 ships'!H8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(S6=\"\",\"\",IF(S6=\"S\",IF('Player 2 ships'!I8>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T6=\"\",\"\",IF(T6=\"S\",IF('Player 2 ships'!J8>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B7=\"\",\"\",IF(B7=\"S\",IF('Player 1 ships'!B9>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(C7=\"\",\"\",IF(C7=\"S\",IF('Player 1 ships'!C9>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(D7=\"\",\"\",IF(D7=\"S\",IF('Player 1 ships'!D9>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(E7=\"\",\"\",IF(E7=\"S\",IF('Player 1 ships'!E9>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(F7=\"\",\"\",IF(F7=\"S\",IF('Player 1 ships'!F9>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G7=\"S\",IF('Player 1 ships'!G9>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(H7=\"\",\"\",IF(H7=\"S\",IF('Player 1 ships'!H9>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(I7=\"\",\"\",IF(I7=\"S\",IF('Player 1 ships'!I9>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(J7=\"\",\"\",IF(J7=\"S\",IF('Player 1 ships'!J9>1,\"HIT\",\"MISS\")))","v":""},null,{"$f":"IF(L7=\"\",\"\",IF(L7=\"S\",IF('Player 2 ships'!B9>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M7=\"\",\"\",IF(M7=\"S\",IF('Player 2 ships'!C9>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(N7=\"\",\"\",IF(N7=\"S\",IF('Player 2 ships'!D9>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(O7=\"\",\"\",IF(O7=\"S\",IF('Player 2 ships'!E9>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(P7=\"\",\"\",IF(P7=\"S\",IF('Player 2 ships'!F9>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(Q7=\"\",\"\",IF(Q7=\"S\",IF('Player 2 ships'!G9>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R7=\"\",\"\",IF(R7=\"S\",IF('Player 2 ships'!H9>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(S7=\"\",\"\",IF(S7=\"S\",IF('Player 2 ships'!I9>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T7=\"\",\"\",IF(T7=\"S\",IF('Player 2 ships'!J9>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B8=\"\",\"\",IF(B8=\"S\",IF('Player 1 ships'!B10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(C8=\"\",\"\",IF(C8=\"S\",IF('Player 1 ships'!C10>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(D8=\"\",\"\",IF(D8=\"S\",IF('Player 1 ships'!D10>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(E8=\"\",\"\",IF(E8=\"S\",IF('Player 1 ships'!E10>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=\"S\",IF('Player 1 ships'!F10>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(G8=\"\",\"\",IF(G8=\"S\",IF('Player 1 ships'!G10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(H8=\"\",\"\",IF(H8=\"S\",IF('Player 1 ships'!H10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(I8=\"\",\"\",IF(I8=\"S\",IF('Player 1 ships'!I10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(J8=\"\",\"\",IF(J8=\"S\",IF('Player 1 ships'!J10>1,\"HIT\",\"MISS\")))","v":"MISS"},null,{"$f":"IF(L8=\"\",\"\",IF(L8=\"S\",IF('Player 2 ships'!B10>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M8=\"\",\"\",IF(M8=\"S\",IF('Player 2 ships'!C10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(N8=\"\",\"\",IF(N8=\"S\",IF('Player 2 ships'!D10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(O8=\"\",\"\",IF(O8=\"S\",IF('Player 2 ships'!E10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(P8=\"\",\"\",IF(P8=\"S\",IF('Player 2 ships'!F10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(Q8=\"\",\"\",IF(Q8=\"S\",IF('Player 2 ships'!G10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R8=\"\",\"\",IF(R8=\"S\",IF('Player 2 ships'!H10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(S8=\"\",\"\",IF(S8=\"S\",IF('Player 2 ships'!I10>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T8=\"\",\"\",IF(T8=\"S\",IF('Player 2 ships'!J10>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B9=\"\",\"\",IF(B9=\"S\",IF('Player 1 ships'!B11>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(C9=\"\",\"\",IF(C9=\"S\",IF('Player 1 ships'!C11>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(D9=\"\",\"\",IF(D9=\"S\",IF('Player 1 ships'!D11>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(E9=\"\",\"\",IF(E9=\"S\",IF('Player 1 ships'!E11>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(F9=\"\",\"\",IF(F9=\"S\",IF('Player 1 ships'!F11>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(G9=\"\",\"\",IF(G9=\"S\",IF('Player 1 ships'!G11>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(H9=\"\",\"\",IF(H9=\"S\",IF('Player 1 ships'!H11>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(I9=\"\",\"\",IF(I9=\"S\",IF('Player 1 ships'!I11>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(J9=\"\",\"\",IF(J9=\"S\",IF('Player 1 ships'!J11>1,\"HIT\",\"MISS\")))","v":"HIT"},null,{"$f":"IF(L9=\"\",\"\",IF(L9=\"S\",IF('Player 2 ships'!B11>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M9=\"\",\"\",IF(M9=\"S\",IF('Player 2 ships'!C11>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(N9=\"\",\"\",IF(N9=\"S\",IF('Player 2 ships'!D11>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(O9=\"\",\"\",IF(O9=\"S\",IF('Player 2 ships'!E11>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(P9=\"\",\"\",IF(P9=\"S\",IF('Player 2 ships'!F11>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(Q9=\"\",\"\",IF(Q9=\"S\",IF('Player 2 ships'!G11>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R9=\"\",\"\",IF(R9=\"S\",IF('Player 2 ships'!H11>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(S9=\"\",\"\",IF(S9=\"S\",IF('Player 2 ships'!I11>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T9=\"\",\"\",IF(T9=\"S\",IF('Player 2 ships'!J11>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B10=\"\",\"\",IF(B10=\"S\",IF('Player 1 ships'!B12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(C10=\"\",\"\",IF(C10=\"S\",IF('Player 1 ships'!C12>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(D10=\"\",\"\",IF(D10=\"S\",IF('Player 1 ships'!D12>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(E10=\"\",\"\",IF(E10=\"S\",IF('Player 1 ships'!E12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(F10=\"\",\"\",IF(F10=\"S\",IF('Player 1 ships'!F12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(G10=\"\",\"\",IF(G10=\"S\",IF('Player 1 ships'!G12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(H10=\"\",\"\",IF(H10=\"S\",IF('Player 1 ships'!H12>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(I10=\"\",\"\",IF(I10=\"S\",IF('Player 1 ships'!I12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(J10=\"\",\"\",IF(J10=\"S\",IF('Player 1 ships'!J12>1,\"HIT\",\"MISS\")))","v":""},null,{"$f":"IF(L10=\"\",\"\",IF(L10=\"S\",IF('Player 2 ships'!B12>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M10=\"\",\"\",IF(M10=\"S\",IF('Player 2 ships'!C12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(N10=\"\",\"\",IF(N10=\"S\",IF('Player 2 ships'!D12>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(O10=\"\",\"\",IF(O10=\"S\",IF('Player 2 ships'!E12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(P10=\"\",\"\",IF(P10=\"S\",IF('Player 2 ships'!F12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(Q10=\"\",\"\",IF(Q10=\"S\",IF('Player 2 ships'!G12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R10=\"\",\"\",IF(R10=\"S\",IF('Player 2 ships'!H12>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(S10=\"\",\"\",IF(S10=\"S\",IF('Player 2 ships'!I12>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T10=\"\",\"\",IF(T10=\"S\",IF('Player 2 ships'!J12>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B11=\"\",\"\",IF(B11=\"S\",IF('Player 1 ships'!B13>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(C11=\"\",\"\",IF(C11=\"S\",IF('Player 1 ships'!C13>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(D11=\"\",\"\",IF(D11=\"S\",IF('Player 1 ships'!D13>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(E11=\"\",\"\",IF(E11=\"S\",IF('Player 1 ships'!E13>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(F11=\"\",\"\",IF(F11=\"S\",IF('Player 1 ships'!F13>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(G11=\"\",\"\",IF(G11=\"S\",IF('Player 1 ships'!G13>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(H11=\"\",\"\",IF(H11=\"S\",IF('Player 1 ships'!H13>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=\"S\",IF('Player 1 ships'!I13>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(J11=\"\",\"\",IF(J11=\"S\",IF('Player 1 ships'!J13>1,\"HIT\",\"MISS\")))","v":""},null,{"$f":"IF(L11=\"\",\"\",IF(L11=\"S\",IF('Player 2 ships'!B13>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M11=\"\",\"\",IF(M11=\"S\",IF('Player 2 ships'!C13>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(N11=\"\",\"\",IF(N11=\"S\",IF('Player 2 ships'!D13>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(O11=\"\",\"\",IF(O11=\"S\",IF('Player 2 ships'!E13>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(P11=\"\",\"\",IF(P11=\"S\",IF('Player 2 ships'!F13>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(Q11=\"\",\"\",IF(Q11=\"S\",IF('Player 2 ships'!G13>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R11=\"\",\"\",IF(R11=\"S\",IF('Player 2 ships'!H13>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(S11=\"\",\"\",IF(S11=\"S\",IF('Player 2 ships'!I13>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T11=\"\",\"\",IF(T11=\"S\",IF('Player 2 ships'!J13>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B12=\"\",\"\",IF(B12=\"S\",IF('Player 1 ships'!B14>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(C12=\"\",\"\",IF(C12=\"S\",IF('Player 1 ships'!C14>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(D12=\"\",\"\",IF(D12=\"S\",IF('Player 1 ships'!D14>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(E12=\"\",\"\",IF(E12=\"S\",IF('Player 1 ships'!E14>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(F12=\"\",\"\",IF(F12=\"S\",IF('Player 1 ships'!F14>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(G12=\"\",\"\",IF(G12=\"S\",IF('Player 1 ships'!G14>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(H12=\"\",\"\",IF(H12=\"S\",IF('Player 1 ships'!H14>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(I12=\"\",\"\",IF(I12=\"S\",IF('Player 1 ships'!I14>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(J12=\"\",\"\",IF(J12=\"S\",IF('Player 1 ships'!J14>1,\"HIT\",\"MISS\")))","v":"MISS"},null,{"$f":"IF(L12=\"\",\"\",IF(L12=\"S\",IF('Player 2 ships'!B14>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M12=\"\",\"\",IF(M12=\"S\",IF('Player 2 ships'!C14>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(N12=\"\",\"\",IF(N12=\"S\",IF('Player 2 ships'!D14>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(O12=\"\",\"\",IF(O12=\"S\",IF('Player 2 ships'!E14>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(P12=\"\",\"\",IF(P12=\"S\",IF('Player 2 ships'!F14>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(Q12=\"\",\"\",IF(Q12=\"S\",IF('Player 2 ships'!G14>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R12=\"\",\"\",IF(R12=\"S\",IF('Player 2 ships'!H14>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(S12=\"\",\"\",IF(S12=\"S\",IF('Player 2 ships'!I14>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T12=\"\",\"\",IF(T12=\"S\",IF('Player 2 ships'!J14>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B13=\"\",\"\",IF(B13=\"S\",IF('Player 1 ships'!B15>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(C13=\"\",\"\",IF(C13=\"S\",IF('Player 1 ships'!C15>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(D13=\"\",\"\",IF(D13=\"S\",IF('Player 1 ships'!D15>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(E13=\"\",\"\",IF(E13=\"S\",IF('Player 1 ships'!E15>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(F13=\"\",\"\",IF(F13=\"S\",IF('Player 1 ships'!F15>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(G13=\"\",\"\",IF(G13=\"S\",IF('Player 1 ships'!G15>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(H13=\"\",\"\",IF(H13=\"S\",IF('Player 1 ships'!H15>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(I13=\"\",\"\",IF(I13=\"S\",IF('Player 1 ships'!I15>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(J13=\"\",\"\",IF(J13=\"S\",IF('Player 1 ships'!J15>1,\"HIT\",\"MISS\")))","v":""},null,{"$f":"IF(L13=\"\",\"\",IF(L13=\"S\",IF('Player 2 ships'!B15>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M13=\"\",\"\",IF(M13=\"S\",IF('Player 2 ships'!C15>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(N13=\"\",\"\",IF(N13=\"S\",IF('Player 2 ships'!D15>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(O13=\"\",\"\",IF(O13=\"S\",IF('Player 2 ships'!E15>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(P13=\"\",\"\",IF(P13=\"S\",IF('Player 2 ships'!F15>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(Q13=\"\",\"\",IF(Q13=\"S\",IF('Player 2 ships'!G15>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R13=\"\",\"\",IF(R13=\"S\",IF('Player 2 ships'!H15>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(S13=\"\",\"\",IF(S13=\"S\",IF('Player 2 ships'!I15>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T13=\"\",\"\",IF(T13=\"S\",IF('Player 2 ships'!J15>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B14=\"\",\"\",IF(B14=\"S\",IF('Player 1 ships'!B16>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(C14=\"\",\"\",IF(C14=\"S\",IF('Player 1 ships'!C16>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(D14=\"\",\"\",IF(D14=\"S\",IF('Player 1 ships'!D16>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(E14=\"\",\"\",IF(E14=\"S\",IF('Player 1 ships'!E16>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(F14=\"\",\"\",IF(F14=\"S\",IF('Player 1 ships'!F16>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(G14=\"\",\"\",IF(G14=\"S\",IF('Player 1 ships'!G16>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(H14=\"\",\"\",IF(H14=\"S\",IF('Player 1 ships'!H16>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(I14=\"\",\"\",IF(I14=\"S\",IF('Player 1 ships'!I16>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(J14=\"\",\"\",IF(J14=\"S\",IF('Player 1 ships'!J16>1,\"HIT\",\"MISS\")))","v":"MISS"},null,{"$f":"IF(L14=\"\",\"\",IF(L14=\"S\",IF('Player 2 ships'!B16>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M14=\"\",\"\",IF(M14=\"S\",IF('Player 2 ships'!C16>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(N14=\"\",\"\",IF(N14=\"S\",IF('Player 2 ships'!D16>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(O14=\"\",\"\",IF(O14=\"S\",IF('Player 2 ships'!E16>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(P14=\"\",\"\",IF(P14=\"S\",IF('Player 2 ships'!F16>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(Q14=\"\",\"\",IF(Q14=\"S\",IF('Player 2 ships'!G16>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(R14=\"\",\"\",IF(R14=\"S\",IF('Player 2 ships'!H16>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(S14=\"\",\"\",IF(S14=\"S\",IF('Player 2 ships'!I16>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(T14=\"\",\"\",IF(T14=\"S\",IF('Player 2 ships'!J16>1,\"HIT\",\"MISS\")))","v":""}]
[null,{"$f":"IF(B15=\"\",\"\",IF(B15=\"S\",IF('Player 1 ships'!B17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(C15=\"\",\"\",IF(C15=\"S\",IF('Player 1 ships'!C17>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(D15=\"\",\"\",IF(D15=\"S\",IF('Player 1 ships'!D17>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(E15=\"\",\"\",IF(E15=\"S\",IF('Player 1 ships'!E17>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(F15=\"\",\"\",IF(F15=\"S\",IF('Player 1 ships'!F17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(G15=\"\",\"\",IF(G15=\"S\",IF('Player 1 ships'!G17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(H15=\"\",\"\",IF(H15=\"S\",IF('Player 1 ships'!H17>1,\"HIT\",\"MISS\")))","v":"MISS"},{"$f":"IF(I15=\"\",\"\",IF(I15=\"S\",IF('Player 1 ships'!I17>1,\"HIT\",\"MISS\")))","v":"HIT"},{"$f":"IF(J15=\"\",\"\",IF(J15=\"S\",IF('Player 1 ships'!J17>1,\"HIT\",\"MISS\")))","v":"MISS"},null,{"$f":"IF(L15=\"\",\"\",IF(L15=\"S\",IF('Player 2 ships'!B17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(M15=\"\",\"\",IF(M15=\"S\",IF('Player 2 ships'!C17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(N15=\"\",\"\",IF(N15=\"S\",IF('Player 2 ships'!D17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(O15=\"\",\"\",IF(O15=\"S\",IF('Player 2 ships'!E17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(P15=\"\",\"\",IF(P15=\"S\",IF('Player 2 ships'!F17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(Q15=\"\",\"\",IF(Q15=\"S\",IF('Player 2 ships'!G17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(R15=\"\",\"\",IF(R15=\"S\",IF('Player 2 ships'!H17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(S15=\"\",\"\",IF(S15=\"S\",IF('Player 2 ships'!I17>1,\"HIT\",\"MISS\")))","v":""},{"$f":"IF(T15=\"\",\"\",IF(T15=\"S\",IF('Player 2 ships'!J17>1,\"HIT\",\"MISS\")))","v":""}]
[]
[{"$f":"'Player 1 ships'!C20","v":19},{"$f":"IF(COUNTIF(B17:J28,\"HIT\")=A30,\"SUNK\",\"\")","v":"SUNK"},{"$nulls":9},{"$f":"IF(COUNTIF(L17:T28,\"HIT\")=A30,\"SUNK\",\"\")","v":""}]