Bumsebiene Posted September 25, 2018 Share Posted September 25, 2018 (edited) 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 36 Link to comment Share on other sites More sharing options...
William Death Posted September 25, 2018 Share Posted September 25, 2018 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. 1 Link to comment Share on other sites More sharing options...
Bumsebiene Posted September 25, 2018 Author Share Posted September 25, 2018 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. 1 Link to comment Share on other sites More sharing options...
DeRuyter Posted September 25, 2018 Share Posted September 25, 2018 Nice work! 2 Link to comment Share on other sites More sharing options...
jodgi Posted September 26, 2018 Share Posted September 26, 2018 Good stuff! 1 Link to comment Share on other sites More sharing options...
balticsailor Posted September 26, 2018 Share Posted September 26, 2018 One repair is 100 HP per side, right? Putting total and relative amount of recovered HP per repair in could be usefull. 1 Link to comment Share on other sites More sharing options...
Bumsebiene Posted September 26, 2018 Author Share Posted September 26, 2018 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) 1 Link to comment Share on other sites More sharing options...
Hethwill Posted September 26, 2018 Share Posted September 26, 2018 Repair cycle, 20%. Which can be 2 units or 40 ( or other values ), depending on ship, woods, installed hull modules, etc. Excellent sheet. 2 Link to comment Share on other sites More sharing options...
Norfolk nChance Posted September 26, 2018 Share Posted September 26, 2018 well done mate o7 2 Link to comment Share on other sites More sharing options...
balticsailor Posted September 26, 2018 Share Posted September 26, 2018 I meant per repair kit 1 Link to comment Share on other sites More sharing options...
Thomas Boyle Posted September 26, 2018 Share Posted September 26, 2018 (edited) 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 Link to comment Share on other sites More sharing options...
Bumsebiene Posted September 26, 2018 Author Share Posted September 26, 2018 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! 1 Link to comment Share on other sites More sharing options...
Bluetooth Posted September 28, 2018 Share Posted September 28, 2018 This is awesome. Well done mate ! 😀 Link to comment Share on other sites More sharing options...
Captiva Posted October 2, 2018 Share Posted October 2, 2018 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! Link to comment Share on other sites More sharing options...
Bumsebiene Posted October 3, 2018 Author Share Posted October 3, 2018 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. Link to comment Share on other sites More sharing options...
Captiva Posted October 3, 2018 Share Posted October 3, 2018 (edited) 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 1 Link to comment Share on other sites More sharing options...
Captiva Posted October 3, 2018 Share Posted October 3, 2018 Just tried the calculator on Google Chrome. Works like a charm with no issues. 1 Link to comment Share on other sites More sharing options...
Bumsebiene Posted February 28, 2019 Author Share Posted February 28, 2019 New HP updated.. Should work now with Patch 30 2 Link to comment Share on other sites More sharing options...
Halsey74 Posted March 2, 2019 Share Posted March 2, 2019 On 2/28/2019 at 5:18 PM, Bumsebiene said: New HP updated.. Should work now with Patch 30 Thank hoy very much. Link to comment Share on other sites More sharing options...
Custard Posted March 2, 2019 Share Posted March 2, 2019 Thank you, any chance you could add the Indiaman to your tool please Link to comment Share on other sites More sharing options...
Raekur Posted March 3, 2019 Share Posted March 3, 2019 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) ------------------------------------------------------- Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now