Naval Action Repair Calculator

[Bumsebiene]

Hey Guys,

I've created a Repair Calculator for Naval Action in Google Spreadsheets. So far I have not seen any tools for repairs, so I decided to make one. Test it out.

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

Edited September 25, 2018 by Bumsebiene

[William Death]

Thats an excellent tool. I really like that you included the calculator at the bottom so if I want to take 4x of each repair, or 8x, etc. I can simply change the number and it'll perform the necessary multiplication across all 3 repairs and give me the amounts I need to carry in the ship. 

Oh, and it looks great too!

 

A couple suggestions if you are planning on modifying it at all:

If possible, add ability to select the other mods that affect hull HP and sail HP. So permanent upgrades like: basic strong sail, basic hull refit, crooked hull refit; and ship knowledge like: speed trim, reinforced sails, etc. 

Also, I'm not sure if the mods and books affecting mast HP would affect sail repairs or not.

At any rate, its a nice tool to get a quick estimate of how many repairs per use. So many players seem to either be carrying too few or way too many repairs.

[Bumsebiene]

After a couple month of testing i think perks will not affect the amount of repairs. But your suggestions are good, there are some Upgrades i didn't had in mind. I will add it in the next version.

[DeRuyter]

Nice work! 

[jodgi]

Good stuff!

[balticsailor]

One repair is 100 HP per side, right? Putting total and relative amount of recovered HP per repair in could be usefull.

[Bumsebiene]

2 minutes ago, balticsailor said:

One repair is 100 HP per side, right? Putting total and relative amount of recovered HP per repair in could be usefull.

no that isn't right. With each Repair you will repair 20% of your ship (without repair Mods)

[Hethwill, the Red Duke]

Repair cycle, 20%.

Which can be 2 units or 40 ( or other values ), depending on ship, woods, installed hull modules, etc.

Excellent sheet.

[Norfolk nChance]

well done mate o7

 

[balticsailor]

I meant per repair kit

[Thomas Boyle]

Where is 'basic hull refit'? and 'basic strong sail', 'cotton sails', 'crooked hull refit', ''reinforced sails' etc. All mods/books which effect on repair cost(hull hp, sail hp).

Edited September 26, 2018 by Thomas Boyle

[Bumsebiene]

22 minutes ago, Thomas Boyle said:

Where is 'basic hull refit'? and 'basic strong sail', 'cotton sails', 'crooked hull refit', ''reinforced sails' etc. All mods/books which effect on repair cost(hull hp, sail hp).

Please read the post above your post!

[Bluetooth]

This is awesome.

Well done mate !

😀

[Captiva]

On ‎9‎/‎25‎/‎2018 at 2:00 PM, Bumsebiene said:

Hey Guys,

I've created a Repair Calculator for Naval Action in Google Spreadsheets. So far I have not seen any tools for repairs, so I decided to make one. Test it out.

Bumsebiene. I hope you can shed some light on what I may  be doing wrong. I'm including two screenshots with same build and no upgrades on L'Ocean. When I switched to another ship and then back to L'Ocean I'm getting two repair results. As I noted to you in an email, it has happened with other ships as well. Thanks!

[Bumsebiene]

21 hours ago, Captiva said:

Bumsebiene. I hope you can shed some light on what I may  be doing wrong. I'm including two screenshots with same build and no upgrades on L'Ocean. When I switched to another ship and then back to L'Ocean I'm getting two repair results. As I noted to you in an email, it has happened with other ships as well. Thanks!

Which browser do you use? I tried it in Google Chrome a dozen times and it worked all the time.

On the first screenshot are the values of Santisima and the second are the values of the Victory. Strange.

[Captiva]

Used Microsoft Edge. Will try Google Chrome. I will try Firefox as well.

I started on the L'Ocean, switched to the Victory and then went back to the L'Ocean. The numbers were different on the L'Ocean from what was shown the first time, as indicated in the screenshots.

Edited October 3, 2018 by Captiva

[Captiva]

Just tried the calculator on Google Chrome. Works like a charm with no issues.

[Bumsebiene]

New HP updated.. Should work now with Patch 30

[Halsey74]

On 2/28/2019 at 5:18 PM, Bumsebiene said:

New HP updated.. Should work now with Patch 30

Thank hoy very much.

 

 

 

 

[Custard]

Thank you, any chance you could add the Indiaman to your tool please

[Raekur]

Just a few things.

Fantastic job putting this together

 

Ships page:

L13 = 25

Column H calculation suggestion =rounddown(h2*1.3,0) this will do the same calculation you want and return a whole number without the decimal value

Christian values - Guns=96 Hold=1540  Speed=10.99 (I dont have the broadside weight as I dont use that for comparison as it is not linear, I use damage output based on medium guns) 

For ease of use, I would suggest doing a sort so that the ships are listed alphabetically. 

There are a total of 49 ships currently, you are missing all the trade ships including the LGV Refit

Add the Pandora rank=6 guns=42 Hold=395 crew=170 (all the data I have on it currently)

Surprise and Hercules are now shallow draft ships

-----------------------------------------------------

Perks page:

Please consider this option for listing since each option should be unique and thus data lookup should not generate any conflicts from being contained in a single array.

Perk Name / Perk Type / Value (Perk Type value of Knowledge, Upgrade, Other. This permits future additions that do not fit into the existing list)

This will allow you to make additions later to the array without having to alter the lookup functions on other parts of the sheets. For example you can setup the look up to examine the array value of Perks!A1:C200 (For example =vlookup(A2, Perks!A2:C200,3,0)

You can also move the special trims to this page as well. (Sturdy, Shabby ect)

-------------------------------------------------------