Scenario 15 base information in an Excel file

[Bodhi]

Scenario 15 base information in an Excel file, including base name, x,y coords, ownership, port size, port Standard Potential Size (SPS), airfield size, airfield SPS, daily supply, daily fuel, starting resource points, starting oil points, Japanese/Allied victory point value, and base oil/resource/manpower/heavy industry/naval shipyard/merchant shipyard/repair shipyard/armament assembly/vehicle assembly points.

Available here
Have fun.

[Arkady]

ORIGINAL: Bodhi

Scenario 15 base information in an Excel file, including base name, x,y coords, ownership, port size, port Standard Potential Size (SPS), airfield size, airfield SPS, daily supply, daily fuel, starting resource points, starting oil points, Japanese/Allied victory point value, and base oil/resource/manpower/heavy industry/naval shipyard/merchant shipyard/repair shipyard/armament assembly/vehicle assembly points.

Available here
Have fun.

Amazing, thanks [&o]

[usecase]

Excellent - thanks for putting in all the hard work.

[Nomad]

I hate to sound stupid but how do I open this file? it is a *.rar file and nothing seems to be able to open it.

[Bodhi]

Sorry, I should have mentioned it's a rar file. Force of habit to save as rar rather than zip.

You can use WinRar, which has a free trial period.

http://www.rarlab.com/download.htm

[Bodhi]

Alternatively, here's a zip version

[Damien Thorn]

How did you extract the information? What program did you use?

[goodwood]

This is a silly question, but how do you change pages? The only way it appears i can change pages is to go to print preview and up anddown there!

[Spooky]

Now - also available in the WITP Fansite [:)]

[olivier_slith]

This is basic Excel stuff: slide the bars and clicks on the tabs at the bottom of the window

[Bodhi]

ORIGINAL: Damien Thorn

How did you extract the information? What program did you use?

A small program I wrote. Currently it'll run though each scenario file and dump out this info as a csv file (unformatted list). I'm currently working on something else, but if that goes well this functionality will be added to that program. Then you'll be able to do this for any scenario, including any add-ons. Still lots of work to go yet though, so don't hold your breath.[;)]

[Sonny]

OK. I took all that base data and put it into a text file (csv file separated by semi-colons) and wrote a .NET program to give you distances between bases you select.

You can select any two bases at a time and save the results and write all the saved results to a txt file. So if you are planning in the Philipines you can save all the distances from and to where you might need to know the distance, say, Manila to Davao etc. and print them out and have a handy distance chart.

Of course this is only the air distances and for something like the Philipines you can count them just as easily but it is still a neat tool.

The big catch is that it is a .NET program so you need to have the Dotnetfx.exe installed on your machine. This is a free download from Microsoft and it is just like installing the JAVA VM om your system.

[brisd]

Excellent job guys, thanks!

[Arkady]

ORIGINAL: Sonny

OK. I took all that base data and put it into a text file (csv file separated by semi-colons) and wrote a .NET program to give you distances between bases you select.

You can select any two bases at a time and save the results and write all the saved results to a txt file. So if you are planning in the Philipines you can save all the distances from and to where you might need to know the distance, say, Manila to Davao etc. and print them out and have a handy distance chart.

Of course this is only the air distances and for something like the Philipines you can count them just as easily but it is still a neat tool.

The big catch is that it is a .NET program so you need to have the Dotnetfx.exe installed on your machine. This is a free download from Microsoft and it is just like installing the JAVA VM om your system.

Is your program somewhere for download (and if not, I can host it for you) ?

thx
Arkady

[Sonny]

ORIGINAL: Arkady

ORIGINAL: Sonny

OK. I took all that base data and put it into a text file (csv file separated by semi-colons) and wrote a .NET program to give you distances between bases you select.

You can select any two bases at a time and save the results and write all the saved results to a txt file. So if you are planning in the Philipines you can save all the distances from and to where you might need to know the distance, say, Manila to Davao etc. and print them out and have a handy distance chart.

Of course this is only the air distances and for something like the Philipines you can count them just as easily but it is still a neat tool.

The big catch is that it is a .NET program so you need to have the Dotnetfx.exe installed on your machine. This is a free download from Microsoft and it is just like installing the JAVA VM om your system.

Is your program somewhere for download (and if not, I can host it for you) ?

thx
Arkady

PM me your email address and I will send it to you tonight when I get home.

[Sonny]

BTW - Bodhi, do you anything similar for ships?
I want to print a list of subs so I can keep track of their kills.

[Bodhi]

ORIGINAL: Sonny

BTW - Bodhi, do you anything similar for ships?
I want to print a list of subs so I can keep track of their kills.

Sonny, not currently. At the moment I was mainly interested in getting base info out. It's not difficult so I'll probably add the functionality to get ships/lcu/air group info out as well. I'll post here when/if it gets down.

[Sonny]

ORIGINAL: Bodhi

ORIGINAL: Sonny

BTW - Bodhi, do you anything similar for ships?
I want to print a list of subs so I can keep track of their kills.

Oh well, I'll just have to scrbble their names on a piece of paper.
Sonny, not currently. At the moment I was mainly interested in getting base info out. It's not difficult so I'll probably add the functionality to get ships/lcu/air group info out as well. I'll post here when/if it gets down.