tool: enhanced data exporter from tracker

[Marc]

Without tracker this game is in my opinion hard to master, especially if you are playing the japanese side. So a big thank you again to Floyd and Damian.
But there are still some things that I missed so I thought about taking the tracker database and export data for importing it in a spreadsheet.

This is my first try for now with LCU data and I would like your help and feedback.
Please try it only if your computer is your friend. It is not entirely easy to make it work and it is by far not thourougly tested. That is your task...

what it does:
It shows the most relevant LCU data and lets you sort and filter it with your favorite spreadsheet program.

how does it work:
It copies the tracker database to another folder and with a rather long SQL script it generates relevant data and saves it to a CSV file.
It makes sende to use it after tracker imported the last turn. It should not matter if tracker is running or not.

what data does it extract:
See the data.jpg attachment. It shows the CSV file in Excel.

data.jpg

Some columns that are not self explanatory:

• CMBTVAL: the AV value is real simple and not very realistic value of the combat strength of a unit. I tried to find a more realistic value and calculated it like this: for every object add the values ARMOR, ANTIARMOR, ANTISOFT and multiply this with the number of the enabled objects. After all the values of all objects are added I then did the following: * XP/100 *MRL/100 *(100-DISR)/100 *(100-FAT)/100. After that I divided it by 10 because that value has enough digits.
  If you have a better idea of finding a realistic combat value feel free to share it.

• RDY: this simplys shows the relation between enabled and disabled objects in the unit. No disabled objects -> 100. A badly shaken unit -> way lower number. It does NOT show if the unit misses objects completely.

• PLANREGION AND ISREGION: I wanted to see all units that are planning for an operation. Where are they? How many ENG AIR NAV do I have? How much troop and cargo space do I need? ... If you are willing to let all units that you want to take part in the operation plan ingame for a base in the target region then all you have to do is filter it in the spreadsheet and you can see where they are and so on. See regionfilter.jpg.
  regionfilter.jpg

what is missing:
Static status of the LCUs. As far as I can tell the static value is not stored in the trackerdb. A possible way would be to save this information in an extra CSV file you would have to fill by hand per scenario and import this data.

how to use it:
First save your tracker folder just to make sure nothing bad happens.
Download the TrackerCSVExport.zip
Create a directory next to your tracker folder with a name of your choice and extract all files in there.
Edit the go.cmd file to match the location of the java.exe. You should know to edit this cmd file.

remarks:
I am really a noob SQL scripter and had to learn very much in the process. (It was a rough ride with my increased age ... ) If you happen to be a Pro then you are very welcome to optimize the code.
Anyway I need you to test this script and your ideas what could be better or added are very welcome.

future plans:
Excel table that imports the CSVs.
A similar export for planes.
Development of pilot experience per plane type.
Ship building planning for Japan.

Marc

[Marc]

I am working on my mentioned tool and am now using Excel to make more of the data.
At the moment I am at a planning tool for the japanese shipbuilding.
As this is in my opinion very interesting I thought of sharing this picture.

It is a screenshot of the development of the pools from scenario 1 if you do nothing at all.
No halting, expanding yards, no nothing.
I calculated the pools day by day from day 1 to the end of 1946.

I made a test run over the first 3 weeks and the merchant pools were ingame exactly as predicted.
The navy pools couldn't because as predicted they went below 0 pretty early.
So I have some good hope that the data is at least quite correct.

On the left you can see that the naval pool would drop to a theoretical -55,184 and at the end it would have +58,0755
Even worse is the merchant pool.

In the diagram in the middle you can see which classes did cost how much in the end. The cost of the subs is immense .

On the right you see the development of the pools from day 1 to the end of 1946


It will take a while for the next update.

jap_shipbuilding_scen1.png (84.15 KiB) Viewed 1129 times

[morphin]

Great! Thank's

[LargeSlowTarget]

Don't create wrong impressions for newbies or prospects. Tracker might be useful for some, but the game is perfectly playable without resorting to any third party tools.

[Sardaukar]

Tracker is useful tool, but I have never used it as Allies.

[Marc]

Don't create wrong impressions for newbies or prospects. Tracker might be useful for some, but the game is perfectly playable without resorting to any third party tools.

You are right that my wording could have been misunderstood. I changed the first sentence.

In my opinion this is the most complex but on the other side best wargame I ever played.
My first two were Warship and War in Russia by SSI/Gary Grigsby on my Atari XL, so I played a few.

btw: I miss your classic signature picture

[HMSDevonshire]

the tracker is Useful for the allies - for tracking ship upgrades for all types, aircraft Production, leaders and easier to see /read intel

[Marc]

I now have a version ready that does in short words the following:

• Group, filter, sum LCU data
• Group, filter, sum Airgroup data
• Plan shipbuilding for Japan with development of the pools

What you need:

• Tracker
• Excel (not the oldest version)

some screenshots:

If someone is interested then let me know and I will post it here.

[dchunghk]

Great tool. Thanks!

Instead of combat value, an improved estimate of av, why not just have list unit's arnor, antisoft, and antiarmor?