Page 1 of 1
Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 6:32 am
by 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.
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 7:03 am
by 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]
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 8:41 am
by usecase
Excellent - thanks for putting in all the hard work.
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 12:41 pm
by 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.
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 12:52 pm
by 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
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 1:04 pm
by Bodhi
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 1:48 pm
by Damien Thorn
How did you extract the information? What program did you use?
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 1:57 pm
by 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!
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 7:21 pm
by Spooky
Now - also available in the WITP Fansite [:)]
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 7:29 pm
by olivier_slith
This is basic Excel stuff: slide the bars and clicks on the tabs at the bottom of the window
RE: Scenario 15 base information in an Excel file
Posted: Wed Jul 28, 2004 9:55 pm
by 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.[;)]
RE: Scenario 15 base information in an Excel file
Posted: Thu Jul 29, 2004 2:48 pm
by 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.
RE: Scenario 15 base information in an Excel file
Posted: Thu Jul 29, 2004 5:44 pm
by brisd
Excellent job guys, thanks!
RE: Scenario 15 base information in an Excel file
Posted: Fri Jul 30, 2004 8:53 am
by 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
RE: Scenario 15 base information in an Excel file
Posted: Fri Jul 30, 2004 12:07 pm
by 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.
RE: Scenario 15 base information in an Excel file
Posted: Fri Jul 30, 2004 12:54 pm
by 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.
RE: Scenario 15 base information in an Excel file
Posted: Fri Jul 30, 2004 11:17 pm
by 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.
RE: Scenario 15 base information in an Excel file
Posted: Sat Jul 31, 2004 12:49 am
by 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.