Click "File" then click "Make a Copy."

Provided the raw data used to create this sheet

To start you have to select a sailor type. The sheet will automatically add the lvl 1 stats for your selected sailor.

Too many ppl helped test the sheet to list here, but TY all :D

for the sheet to function correctly, you must also provide a name. This can be from the drop down list, or a manualy typed name.

The sheet is designed to be easy to understand for all. Use the drop-down boxes to select the sailor Type and Name. You can then fill in the data for each level.

You do not need the data for every level to use the sheet. Partial data is fine.

In the "Sailor Stats - Goals" section of My Sailors sheet, you will be able to assign goals for each type of sailor.

Red = Goal is impossible to reach; Yellow = Goal is possible to reach; Green = Goal is likely to be reached.

To add your stats, simply type them in the light grey section undert the Lv.2-Lv.10 sections, marked as Stats Area above

The sheet will assume the level of the sailor based on the highest level with stats provided. This means that it will continue to function even if no stats are provided for some levels.

Under the image of each sailor, you can assign it to upto 4 groups. The group's stats can then be compared using the "Sailor Stats - Groups" section.

To make it easier to find sailors within the main list, you can check the box next to any sailor in the "Condensed - Sailor List" section which will highlight the sailor red in the main list.

This section will be updated to show any new changes that are made to sailor stats, or the sheet in general

1) The sheet has been updated to include, minimum possible rolls

2) The sheet has been updated to allow up to 100 unique sailors

3) The sheet has been updated to allow up to 4 groups per sailor

To remove a sailor, simple use Backspace to delete the stats in the Stats Area, being careful not to delete Lv.1 stats, as this will break the sheet.

4) The sheet has been updated to include 9 unique groups to be assigned

Ensure you also remove the Name and Sailor Type, everything marked red below should be removed

5) The sheet has been updated to allow goals to be set for 10 unique types of sailor

6) The sheet has been updated to show the min, and avg sailor stats in the All Sailors page

7) The sheet now works with duplicate names, if the name+sailor type combo is unique

My Sailors V0.2

1) Fixed ref error if invalid data provided in sailor type

2) Likely stat has been changed to highlight green: for above avg, yellow for avg, and orange for below avg

3) Max R stat now shows red if avg stat is impossible to reach

4) Goals are more clearly identified when they are reached or impossible to reach

5) Minimum rolls are now highlighted as red text

6) Goals section now correctly displays max rolls for each sailor type

My Sailors V0.3

1) Fixed groups not correctly being assigned in Condenced Sailor List

In the images above, you can see that some stats are highlighted as Green, while others are Red or Black. This is an indicator to show you if your sailor Min or Maxed rolled

2) Data below the minimum value for each level, now highlights errors

In the example above, we can see that Lv.8 speed is Green, this indicates that 1.2 is the maximum possible stat for speed at Level 8.

3) Multi Sorting is now implemented

This highlighting, also works to tell us if the roll for the current level was a max roll, for example Turn Lv.2 is Green. This is not the Max possible stat for the level, instead its max growth from 3.3.

4) Sailor Type filtering has now been added

This highlighting works the exact same way for Minimums, only showing as Red for minimum or minimum growth.

5) Non Unique sailors type+name will now function correctly ie, multiple innos called jeff

Finaly, the sheet has built in Error detection, where it will go very red if a given value is not possible. This can be seen below

6) Border lines added to sorting list to indicate the max limits of Panok and Carrack (red and blue)

My Sailors V0.4

1) Fixed bug where blank slots in sailor list would break the rest of the sheet

2) Removed redundant Conditional Formatting in sort list

3) Added simple nav system for getting to sailors from the condenced list

4) Added conditional formatting for Goal tracking in compact lists

5) Modified the sort list to use fliter rather than query, to improve the navigation system

Public Sheet V1.0

1) Fixed Conditional Formatting on Likely Section

2) Fixed Navigation Links for sailor 100

3) Added Guide based on NekoNeko Guide to Info Page

BUG FIX: Fixed expired image links, all sailors should have images again!

The likely stat tracks what your currently likely to roll on a sailor, the highlighting indicates possible outcomes.

Yellow, means that you are likely to reach AVG stat. Orange, means you are only able to get to AVG stat if you max roll every future level

Green, means that you will hit AVG stat, and Finaly, Red means you cannot reach the AVG stat.

Find the section marked as: Sailor Stats - Goals, in this area, you can assign goals for each stat for each type of sailor.

The assigned values will be used to highlight differnt areas of the sheet indicating if a sailor is going to reach, likely to reach or cannot reach a given goal.

Sailor Goal Highlighting

The sheet will highlight in differnt places to indicate if the current sailor will reach its goal.

Green, means sailor will likely meet its goal, Yellow, means sailor can only meet the goal if it max rolls, Red meens sailor cannot reach its goal