BASIC ship model data?

[Norfolk nChance]

Can anybody show me how to get the ship base model into excel? Via API or whatever…

So speed Armour Structure Bow TurnR etc…

 

Norfolk.

 

[qw569😳]

 

I already forgot VBA
You can parse ItemTemplates_cleanopenworldprodeu1.json to csv with commandline utilites jq and import to excel

I suppose you use Windows.

The most usefull commandline utilites such as curl and sed is absent.

1. Download curl (https://curl.haxx.se/download.html)
2. Download sed and dependencies (http://gnuwin32.sourceforge.net/packages/sed.htm)
3. Download jq (https://stedolan.github.io/jq/)
4. And now command line kung fu

	curl http://storage.googleapis.com/nacleanopenworldprodshards/ItemTemplates_cleanopenworldprodeu1.json | sed "s/^.\{20\}//" | sed "s/.\{1\}$//" | jq-win64 -r ".[]|select(.ShipTemplateName!= null)|[.ShipTemplateName,.Specs.MaxSpeed,.Specs.SpeedToWind[],.HealthInfo.LeftArmor,.HealthInfo.FrontArmor,.HealthInfo.BackArmor,.HealthInfo.InternalStructure,.HealthInfo.Sails]|@csv"  >stats.csv
	

You can skip steps 1-2.

1. Then you must download ItemTemplates_cleanopenworldprodeu1.json
2. Delete "var ItemTemplates = " in the begining and ";" in the end of file ItemTemplates_cleanopenworldprodeu1.json.
3. Save new file as 1.json

	jq-win64 -r ".[]|select(.ShipTemplateName!= null)|[.ShipTemplateName,.Specs.MaxSpeed,.Specs.SpeedToWind[],.HealthInfo.LeftArmor,.HealthInfo.FrontArmor,.HealthInfo.BackArmor,.HealthInfo.InternalStructure,.HealthInfo.Sails]|@csv"  1.json >stats.csv
	

And we get file stats.csv

 

"BrigMR",129.360000610352,0.826148629188538,0.912718594074249,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.474649310112,0.501676023006439,0.323229432106018,0.239175021648407,-0.259320199489594,1613,403,161,807,1613
"Hermione",161.673614501953,0.816173374652863,0.894985318183899,0.968717694282532,0.99427318572998,0.964730858802795,0.921610474586487,0.928746402263641,0.832743287086487,0.677251100540161,0.50856339931488,0.258964389562607,0.168681815266609,-0.212512999773026,3472,868,347,1736,3472
"Niagara",168.960006713867,0.830660879611969,0.912714421749115,0.972128987312317,0.99762225151062,0.957572162151337,0.896801114082336,0.975587129592896,0.810507297515869,0.630711197853088,0.567409038543701,0.437655121088028,0.243285745382309,-0.259320199489594,1875,469,188,938,1875

where columns:

1. ShipTemplateName
2. MaxSpeed
3. SpeedToWind
4. LeftArmor
5. FrontArmor
6. BackArmor
7. InternalStructure
8. Sails

 

Edited October 12, 2017 by qw569

[jodgi]

I guess I can help a little when it comes to speed, but I have published everything I've found already.

I'm on vacation right now so I'll make a proper reply when back at my computer.

Some of the people that REALLY know their shit are Black Spawn and qw569.

[Norfolk nChance]

Yep I hear ya... I need to reverse engineer the different wood adjustments. Cross reference check it so it will reveal the actual BASE number. Didn't want to manually crunch it 

From there I can add different cannon weight effects etc and check against the in-game Pop-Up...

From that BASE its an easy jump to add Perm Mod adjustments and compare like with like. I did this ages ago with "Norfolk nChance Sea" but this is a complete rebuild now.

[Norfolk nChance]

Thank you