Jump to content
Game-Labs Forum
SS Minnow

Naval Action Explorer

Recommended Posts

Captains -

I am uploading an Open Office Calc spreadsheet I programmed to import data directly from the Game Labs provided API .json files and your local game .xml files:

http://www.northeastliquidators.com/Naval Action/

Naval Action Explorer folder contains version 1.3.  Check back and I may have updates to try.  Hope this will help us keep up to date with patch changes and provide accurate and meaningful feedback for the development team.  Let me know if you find any bugs or would like something added or changed.

Fair Winds!

Minnow

  • Like 5

Share this post


Link to post
Share on other sites

Should be there, some US guys been testing it for a couple weeks.  Hehe...most seemed to like it.

Edited by SS Minnow

Share this post


Link to post
Share on other sites
2 minutes ago, Sir Texas Sir said:

grrrrr I don't have uptodate (expired) outlook

Oh this is Open Office...its like Microsoft Office except free.  Here's what you need: 

https://www.openoffice.org/download/

Not promoting anything here, just that's the only way I could do it

 

Edited by SS Minnow

Share this post


Link to post
Share on other sites

Stunning work Minnow, truly. Makes most of my custom tools obsolete in ways that improve on what we've built.  Very well done and I'll continue to test things and stay tuned to continued updates.  Bravo! :) 

Share this post


Link to post
Share on other sites
4 hours ago, SS Minnow said:

Should be there, some US guys been testing it for a couple weeks.  Hehe...most seemed to like it.

proxy issue with the wifi I was on. 

Share this post


Link to post
Share on other sites

 

14 hours ago, Wraith said:

Stunning work Minnow, truly. Makes most of my custom tools obsolete in ways that improve on what we've built.  Very well done and I'll continue to test things and stay tuned to continued updates.  Bravo! :) 

Thank you Wraith!  Ver 1.4 posted.  I changed the hull and sail repair calculation back to .025 * actual side hp and .025 * actual sail hp.

Share this post


Link to post
Share on other sites

I posted version 1.07 which is updated with all the ship data if anyone wants to check out.  I was thinking of working on a BR formula this weekend.  With your input on which ship stats are important, we might be able to help the dev team on BR formula.

Share this post


Link to post
Share on other sites

This is great!

How do I get more ships into this list?

93038f643a8501e1b5d4113c157cb7e7.png

Also "Drive letter for NA install"... The root drive or entire path to NA exe?

  • Like 1

Share this post


Link to post
Share on other sites

On the ship data sheet, use shift click to select all the classes 1 - 7 and you should see the ship list box fill with all the ships.  Use shift click again on the ship list to select all the ships and then click Update ships.  Now you have all the ships in the ship data sheet.  This list controls the ships that are listed in the dropdown on the ship builder sheet.  It also controls the ships listed on the PB calculator and Chart data sheet.

The game path drive on the Guide sheet is on C.  If you installed on D, just change the C to D.

The 2.0 version I hastily put up there has some new sheets that aren't done yet but work to some degree....maybe I will finish the shops sheet if its any use to you all.

I could try to empirically modify the sailing profiles for the sail force mods if I had some data showing wind angle and speeds at major points of sail.  For example, give me the Bellona speed with elite Spanish sails at a few angles and I could calculate the extra bonus/penalty it gives.  Would be nice huh?

Also when I post a newer version, you can copy any ships that you saved on the older ship builder list to the newer version.  Just copy and paste them at the bottom of the list of saved ships.

Edited by SS Minnow

Share this post


Link to post
Share on other sites

i am amazed!! it is what I wanted to do, but too lazy to do :o

thank you good sir, you are legend!

may i ask, since i did not find it so far, would it be possible to add a ship crafting calculator: ressources required, materials, labour hours total, and estimated price based on values set by user, or default ressource price from the api?

Share this post


Link to post
Share on other sites

Hey @SS Minnow, it seems like your cannon data are wrong in the spreadsheet (vertical dispersion for most cannons isn't up to date and carronade penetration values are not correct). And I don't see a "Refresh" button or option for the gun data.  It might be something to add in the future!  Thanks again for the tool!

  • Like 1

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×