I had some free time last night, so I worked out a way to estimate voyage duration based on skill/starting AM input:

https://codepen.io/somnivore/full/Nabyzw

Switch to editor view to see the source code with the formulas, or click here:

https://codepen.io/somnivore/pen/Nabyzw

My original spreadsheet that also has this calculator as well as some raw data:

https://docs.google.com/spreadsheets/d/1IS2qEggZKo1P1kBJq-qoDxJvxtKfQXpfVna9z4E_dNo/edit?usp=sharing

It would help to have more data. I’ve created a form where anybody can submit their skill/ship voyage stats along with the actual voyage time. I can use this to refine the variables used by the estimation formulas:

https://docs.google.com/forms/d/e/1FAIpQLSdWEJWABCVZiBKWeTnFevCYeg9f9DCG_x49KdlSnGTOh3acEQ/viewform?usp=sf_link

*Please contribute all your data points - not just the outliers (i.e. don’t just contribute when the estimate is off for you)*

Here is another form for hazard check totals to help us narrow down the exact chance of primary vs secondary vs other skills being checked for hazards:

Quick crew allocation tips:

* Don’t give up skills for traits. Each trait only adds about 1 minute (per refill)

* Prioritize primary and secondary skills. The chance of primary, secondary, and other skills being tested for hazards are (roughly!): 1/3, 1/4, and 1/10

* Go for crew that have the highest total skills

* Avoid any one skill being very high (even primary/secondary skills). The goal is to reach a point where all hazard checks fail. If one skill is too high, the voyage will end while that skill is done making successful hazard rolls. I will try to add automated warnings to my estimator later, but try to keep your highest skill to be under 1000*hours estimated.

* Although I’m not entirely sure yet, I believe the optimal distribution is to have primary and secondary skills at the aforementioned “cap”. So, something like 8000/8000/1000/1000/1000/1000. Ultimately, it depends on the crew you have available. Basically, to compute the value of each crew, add the product of each skill multiplied by the skill check chance (I may at a little calculator panel for this later)

* Slots only restrict what crew can go there. So out of the crew you want to use, arrange them such that you get the most trait bonuses (without sacrificing total skill levels for it)

P.S. If you’re near the end (failing all hazard checks) and want to estimate the time left, just divide AM by 21 for an accurate estimate (in minutes), or by 22 for a safe estimate. I plan to add this to the estimator page later when I have a bit more free time. If the difference between your highest and lowest skills is very large, this estimate will be less accurate.

This is not Spam. This is not Spam! This is not spam.