User blog:Syntax Terror/Ship list spreadsheet

Download link: Quick reference ship list.ods

This spreadship has been made to see quickly what ships you have, which ones you need and when you can remodel and modernize them.

It is an ODF file, OpenOffice Calc or LibreOffice Calc are free/open source spreadsheet programs that can read and edit it.


 * Notes
 * The names and ship numbers are the ones of the base ship.
 * The ships have been choosen thanks to the informations from the Ship Maximum Status articles, it is not said to be the best list nor the one to choose, feel free to adapt it to your needs.
 * All the obtainable submarines and auxiliary ships are present, although it may be quite long to get them all.
 * There is no data on this list for the destroyers used for expeditions (Mutsuki Class) and the one you may want for their sonar/radar when they get remodeled (Yuugumo Class). Look at Best destroyers - Radar - Expedition to see the cards of the destroyers to keep.

How to use

 * To change the ships, change the ship number, its romanji name (name in latin alphabet), name and level for modernization.
 * The romanji names are linked to the wikia articles, so the URL has to be changed to have correct links:
 * Select the cell of the name and click on the URL button:
 * Change the name of the ship and its URL.


 * Change also the ships caracteristics:
 * Look at the ship's article and it's last remodel and put the Firepower, Torpedo attack , Anti-Air and  Armor  figures in the Actu (actual figure) column. Put the corresponding figures between brackets in the Max (maximum caracteristic) column. The figure in the Diff (difference between Max and Actu) column will be calculated automaticaly: it is the number of points needed to reach the maximum of the caracteristic.


 * To remove ships, delete the corresponding cells.
 * To add ships, copy/paste a group of cells and edit them as indicated above.
 * The cell colours can be changed to indicate the still needed ships, the ones that are ready to be modernized and the ones that should be used for expeditions (that must not be modernized so their ammo and fuel consumption stay low). The maxed up caracteristics should also have a different colour to see quickly what needs to be done.
 * Example:
 * Before modernizing a ship, compare the Diff columns to avoid wasting ships by merging them while some of their bonuses are already maxed:
 * Try to merge first the ships with Anti-Air bonuses (mainly the carriers, seaplane tenders and battleships) because it is the rarest caracteristic.
 * Then add the ships with Firepower bonuses (Battleships, cruisers and remodeled destroyers).
 * Then the ships with only Armor and Torpedo attack and finally the ones with only torpedo attack if this caracteristic still needs to be raisen.
 * (Note that some ships have 0 torpedo attack (battleships, aviation battleships, carriers and auxiliary ships) and that submarines have 0 Anti-Air.)
 * Use the Prob (probability) column if you want to note the increase probability of the caracteristics before confirming the modernization.