My Sailors Sheet Guide: Sailor Stats, Goals & Groups

My Sailors Sheet Guide

Setting Sailor Goals
Adding Your Stats Groups
Finding Sailors
Updates
Removing a Sailor
My Sailors V0.2
My Sailors V0.3
My Sailors V0.4
Public Sheet V1.0
Additional Context and Data

---

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.

Adding Your Stats Groups

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.

Finding Sailors

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.

Updates

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 Removing a Sailor 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
7) This version also introduces enhanced sorting and groupings in the navigation

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 Likely Stat Highlighting
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. Updated Quick Sailors to reflect new changes Oct 16th 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.

Setting Sailor Goals

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 means sailor cannot reach its goal

In addition to this, if the sailor cannot reach a goal or can reach its goal even if it min rolls, special highlighting will occur

This same system is used in the Condenced Sailor List section, Green being that it can reach the goal, Red being it cannot, Yellow means it requires max roll, just like before

Assigning Sailor Groups

The sheet has a built in Group system, this is intended to make it easier to compare differnt sailor sets. To assign sailor groups just select a number in the sailor group section. Each sailor can be a part of 4 unique groups.

We can see the total stats for a group in the Sailor Stats - Groups Section, for this example, 5 Innocents have been assigned to Group 1

The group assignment of each sailor also appers in the Condensed List and Sorted List,

Sailor Filter/Sorting

In many cases, we just want to find out who is our best or worst sailors of a given type. To do this the Sorted Sailor List section can be used. You can select a given sailor type to filter by (or leave blank to sort all sailors) then select the sort order of up to 5 different stats The checkboxes next to each stat indicate ascending or descending order. The example below shows the list being filtered to only show Innocents, and sort them by highest to lowest speed and turn.

The sheet has a simple navagation system built into it. To get to a sailor quickly, you can select the group section in the Condenced or Sorted List, then click the small link that it shows. This will move you to that sailor in the main sailor list.

To return to the sailor in the condenced list, you can click on the small navigation icons under each sailor

Sheet by: Sheen

For: Black Desert - Sailing Race Location Appetite Cabin Cost Weight Endurance Wits Awareness Strength Patience Force Focus Vision

Speed Acceleration Turn Brake Reload Range Accuracy Angle

Ambitious Goblin 150.0 10 200 LT

Base 1.6% 0.2% 0.2% 0.2% 0.0% 0.0% 0.0% 0.0%

Velia Min 2.7% 1.1% 1.1% 1.1% 0.0% 0.0% 0.0% 0.0%

Epheria AVG 3.1% 1.3% 1.3% 1.3% 0.0% 0.0% 0.0% 0.0%

Max 3.4% 1.5% 1.5% 1.5% 0.0% 0.0% 0.0% 0.0%

Born on the Sea Giant 150 10 500 LT

Base 2.0% 0.3% 0.3% 0.3% 0.0% 0.0% 0.0% 0.0%

Iliya Min 3.0% 1.3% 0.6% 0.6% 0.0% 0.0% 0.0% 0.0%

AVG 3.2% 1.5% 0.8% 0.8% 0.0% 0.0% 0.0% 0.0%

Max 3.4% 1.7% 1.0% 1.0% 0.0% 0.0% 0.0% 0.0%

Calculating Dwarf 150 10 300 LT

Base 0.3% 1.2% 0.3% 0.3% 0.0% 0.0% 0.0% 0.0%

Epheria Min 1.3% 2.8% 1.9% 1.9% 0.0% 0.0% 0.0% 0.0%

Velia AVG 1.5% 3.4% 2.5% 2.5% 0.0% 0.0% 0.0% 0.0%

Max 1.7% 4.0% 3.1% 3.1% 0.0% 0.0% 0.0% 0.0%

Confident Dwarf 100 5 300 LT

Base 0.3% 0.3% 3.0% 0.6% 0.0% 0.0% 0.0% 0.0%

Epheria Min 1.3% 1.3% 7.1% 2.6% 0.0% 0.0% 0.0% 0.0%

Velia AVG 1.5% 1.5% 7.7% 3.3% 0.0% 0.0% 0.0% 0.0%

Max 1.7% 1.7% 8.3% 3.9% 0.0% 0.0% 0.0% 0.0%

[1] This must be changed to match the new sailors when they are added

[2] This must be changed to match the new sailors when they are added

[3] This must be changed to match the new sailors when they are added

[4] This must be changed to match the new sailors when they are added

[5] This must be changed to match the new sailors when they are added

[6] This must be changed to match the new sailors when they are added

[7] This must be changed to match the new sailors when they are added

[8] This must be changed to match the new sailors when they are added

[9] This must be changed to match the new sailors when they are added

[10] This must be changed to match the new sailors when they are added

[11] This must be changed to match the new sailors when they are added

[12] This must be changed to match the new sailors when they are added

[13] The minimum possible stat the sailor can achieve given its current stat and level

Min R = Min Roll

[14] The Likely stat the sailor will achieve given its current stat and level

[15] The maximum possible stat the sailor can achieve given its current stat and level

Max R = Max Roll

[16] Goal set in the Sailor Stats - Goals section

[17] The Average stat for this type of sailor.

[18] The Max known stat for this type of sailor

[19] The Max known possible speed for this type of sailor

MaxSpeed = mSpeed

[19] The Max known possible speed for this type of sailor

MaxSpeed = mSpeed

[20] The speed of this group if every sailor in group Max rolls every level

MaxRollSpeed = mrSpeed

[21] "mr" prefix stands for Max Roll

[22] The minimum possible stat the sailor can achieve given its current stat and level

Min R = Min Roll

[23] The Likely stat the sailor will achieve given its current stat and level

[24] The maximum possible stat the sailor can achieve given its current stat and level

Max R = Max Roll

[25] Goal set in the Sailor Stats - Goals section

[26] The Average stat for this type of sailor.

[27] The Max known stat for this type of sailor

[28] Check the box to identify sailors in the main sailor list, This will also count the sailors checked as the On Board group in the Sailor Stats - Groups section

[29] The maximum possible stat the sailor can achieve given its current stat and level

Max R = Max Roll

[30] The minimum possible stat the sailor can achieve given its current stat and level

Min R = Min Roll

[31] The Likely stat the sailor will achieve given its current stat and level

[32] The maximum possible stat the sailor can achieve given its current stat and level

Max R = Max Roll

[33] Goal set in the Sailor Stats - Goals section

[34] The Average stat for this type of sailor.

[35] The Max known stat for this type of sailor

[36] The minimum possible stat the sailor can achieve given its current stat and level

Min R = Min Roll

[37] The Likely stat the sailor will achieve given its current stat and level

[38] The maximum possible stat the sailor can achieve given its current stat and level

Max R = Max Roll

[39] Goal set in the Sailor Stats - Goals section

[40] The Average stat for this type of sailor.

[41] The Max known stat for this type of sailor

[42] The minimum possible stat the sailor can achieve given its current stat and level

Min R = Min Roll

[43] The Likely stat the sailor will achieve given its current stat and level

[44] The maximum possible stat the sailor can achieve given its current stat and level

Max R = Max Roll

[45] Goal set in the Sailor Stats - Goals section

[46] The Average stat for this type of sailor.

[47] The Max known stat for this type of sailor

[48] The minimum possible stat the sailor can achieve given its current stat and level

Min R = Min Roll

[49] The Likely stat the sailor will achieve given its current stat and level

[50] The maximum possible stat the sailor can achieve given its current stat and level

Max R = Max Roll

[51] Goal set in the Sailor Stats - Goals section

[52] The Average stat for this type of sailor.

[53] The Max known stat for this type of sailor

[54] The minimum possible stat the sailor can achieve given its current stat and level

Min R = Min Roll

[55] The Likely stat the sailor will achieve given its current stat and level

[56] The maximum possible stat the sailor can achieve given its current stat and level

Max R = Max Roll

[57] Goal set in the Sailor Stats - Goals section

[58] The Average stat for this type of sailor.

[59] The Max known stat for this type of sailor

[60] The minimum possible stat the sailor can achieve given its current stat and level

Min R = Min Roll

[61] The Likely stat the sailor will achieve given its current stat and level

[62] The maximum possible stat the sailor can achieve given its current stat and level

Max R = Max Roll

[63] The Goal set in the Sailor Stats - Goals section

Sheet by: Sheen

For: Black Desert - Sailing Race Location Appetite Cabin Cost Weight Endurance Wits Awareness Strength Patience Force Focus Vision

Speed Acceleration Turn Brake Reload Range Accuracy Angle

Treasure-Seeking Min Growth Level 1 Level 2 Level 3 Level 4 Level 5 Level 6 Level 7 Level 8 Level 9 Level 10

Endurance (Speed) 0.2 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 Wits (Acceleration) 0.2 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1

Awareness (Turn) 4.0 0.1 0.1 0.2 0.1 0.1 0.3 0.2 0.2 0.3

Strength (Brake) 0.8 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.2

Patience (Reload) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Force (Range) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Focus (Accuracy) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Vision (Angle) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Max Growth Level 1 Level 2 Level 3 Level 4 Level 5 Level 6 Level 7 Level 8 Level 9 Level 10

Endurance (Speed) 0.2 0.1 0.1 0.2 0.1 0.1 0.2 0.1 0.1 0.3 Wits (Acceleration) 0.2 0.1 0.1 0.2 0.1 0.1 0.2 0.1 0.1 0.3

Misc Stats Awareness (Turn) 4.0 0.1 0.1 0.3 0.2 0.2 0.4 0.3 0.3 0.5

Required LT 200 Strength (Brake) 0.2 0.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Required Cabins 10 Patience (Reload) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Appetite 150 Force (Range) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Spawn Location 1 Iliya Focus (Accuracy) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Spawn Location 2 Vision (Angle) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Minimum Stats Level 1 Level 2 Level 3 Level 4 Level 5 Level 6 Level 7 Level 8 Level 9 Level 10

Endurance (Speed) 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1

Wits (Acceleration) 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1

Awareness (Turn) 0.8 0.9 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.8

Strength (Brake) 4.0 4.1 4.2 4.4 4.5 4.6 4.9 5.1 5.3 5.6

Patience (Reload) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Force (Range) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Focus (Accuracy) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Vision (Angle) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Max Growth Level 1 Level 2 Level 3 Level 4 Level 5 Level 6 Level 7 Level 8 Level 9 Level 10

Endurance (Speed) 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1 1.3

Wits (Acceleration) 0.3 0.4 0.5 0.6 0.7 0.8 1.0 1.1 1.2 1.5

Awareness (Turn) 0.3 0.4 0.5 0.7 0.8 0.9 1.2 1.4 1.6 1.9

Strength (Brake) 0.3 0.4 0.5 0.7 0.8 0.9 1.2 1.4 1.6 1.9

Patience (Reload) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Force (Range) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Focus (Accuracy) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Vision (Angle) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Endorsements and Annotations