A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | To use this template, you must go to File → Make a copy using a Google account. | |||||||||||||||||||
2 | Link: https://teambuilding.com/spreadsheet-battleship | |||||||||||||||||||
3 | Spreadsheet Battleship | Instructions | ||||||||||||||||||
4 | #1: Make a copy of this sheet for each player. Login to a Gmail account, then go to File → Make a copy #2: Each player add the ships in the bottom right table to the board on the left. Add by placing an “s” in each cell, with a length equal to the size of each ship. No layering! #3: Players take turns firing “shots” at each other’s boards. To fire a shot, just name the coordinates. For example, “F-5” would target Column F, Row 5. The defending player marks the spot with an “X” if it hits a ship and an “O” if it missed. Players can track their own shots on the "Enemy Ships" tab. #4: When every spot on a ship has been hit, you say “you sunk my battleship!” or the name of the ship that went down. The last player with remaining ships wins. #5: Have fun! | |||||||||||||||||||
5 | ||||||||||||||||||||
6 | ||||||||||||||||||||
7 | ||||||||||||||||||||
8 | add ships here | |||||||||||||||||||
9 | Legend | Ship | Size | |||||||||||||||||
10 | Hit | X | 💥 | Carrier | 5 | |||||||||||||||
11 | Miss | O | 🕳️ | Battleship | 4 | |||||||||||||||
12 | Ship | S | 🛥️ | Cruiser | 3 | |||||||||||||||
13 | Destroyer | 2 | ||||||||||||||||||
14 | Submarine | 1 | ||||||||||||||||||
15 | ✨ More fun activities at teambuilding.com ✨ |