List of Units (Full Version)

All Forums >> [Current Games From Matrix.] >> [World War II] >> War In The Pacific - Struggle Against Japan 1941 - 1945



Message

ttjhowell -> List of Units (7/11/2008 10:02:34 PM)

Hi

Is it possible for me to get a list in excel or similar of all of the land units in one of the CHS scenarios? I want to start tracking the Japanese divisions so I can figure out how worried I need to be.

Regards

John



rjopel -> RE: List of Units (7/11/2008 10:28:01 PM)

That's cheatin.[:-]  Do it the old fashioned way.  Write them down when and where you see them and find out there movement patterns.  Just like what was done in WW2.

[:)]



VSWG -> RE: List of Units (7/11/2008 10:38:01 PM)

Use this tool to create csv-files (comma separated-values, all data in a simple text file) from your CHS scenario: http://mathubert.free.fr/witp_files/witpload.zip  Excel can read and import these files.

Post here if you need help.



ttjhowell -> RE: List of Units (7/12/2008 8:47:02 AM)

rjopel,

Actually, I hadn't even thought of it that way. There will still be a lot of unknowns like how many divisions he has transferred from the home islands and I will still be writing things down and following movement patterns. It still isn't going to be easy!

VSWG,

thanks. WitpLoad downloaded and used. So three csv files were exported.

- WITPcls which has all of the ship class information
- WITPdev which has the weapon information
- WITPshp which seems to have the individual ship information, along with the leader info

Where should I look for the land unit info?

Regards

John





treespider -> RE: List of Units (7/12/2008 11:35:25 AM)

quote:

ORIGINAL: ttjhowell

rjopel,

Actually, I hadn't even thought of it that way. There will still be a lot of unknowns like how many divisions he has transferred from the home islands and I will still be writing things down and following movement patterns. It still isn't going to be easy!

VSWG,

thanks. WitpLoad downloaded and used. So three csv files were exported.

- WITPcls which has all of the ship class information
- WITPdev which has the weapon information
- WITPshp which seems to have the individual ship information, along with the leader info

Where should I look for the land unit info?

Regards

John





There should be several others ... iiirc witploc###.csv where ### is the scenario # in question is the one you are looking for.



ttjhowell -> RE: List of Units (7/12/2008 12:41:13 PM)

Ah ha... user error. I had WitpLoad in a subdirectory and I thought that I had copied all of the scenario .dat files across but I had missed one that had stopped the code from executing. Problem solved and I have found WITPloc157.csv. This has the starting position of each unit and base within it as well as the 'weapons' (i.e. infantry units, guns, etc). But no assualt value. I take it this is because the game will calculate that by using the number & condition of the weapons present... Is there any way I can calculate that?

Lets take the US 32nd Division as an example. it has the following at the start of the game

Wpn ID Wpn No WpnDisab
390 27 0
251 54 0
250 18 0
252 89 0

Can I turn that into an AV? My plan was to filter by AV so that I could distinguish divisions from brigades and just focus on the large units.




treespider -> RE: List of Units (7/12/2008 12:50:02 PM)

Av -- any squad with >10 firepower + AFV + something else ...but the squads and the AFv should get you close..



VSWG -> RE: List of Units (7/12/2008 1:00:24 PM)

quote:

ORIGINAL: ttjhowell

Ah ha... user error. I had WitpLoad in a subdirectory and I thought that I had copied all of the scenario .dat files across but I had missed one that had stopped the code from executing. Problem solved and I have found WITPloc157.csv. This has the starting position of each unit and base within it as well as the 'weapons' (i.e. infantry units, guns, etc). But no assualt value. I take it this is because the game will calculate that by using the number & condition of the weapons present... Is there any way I can calculate that?

Lets take the US 32nd Division as an example. it has the following at the start of the game

Wpn ID Wpn No WpnDisab
390 27 0
251 54 0
250 18 0
252 89 0

Can I turn that into an AV? My plan was to filter by AV so that I could distinguish divisions from brigades and just focus on the large units.



You can, but it'll be A LOT of work. You need to scan all weapon slots for devices of type 22 (Squads), 23 (AFV) and IIRC also 24 (Engineers) and add them up. Also, you may want to differentiate between max. AV (with full TOE and no disablement) and actual AV on Dec. 7th.

What Excel version are you using? This might be your lucky day... [;)]



n01487477 -> RE: List of Units (7/12/2008 1:42:14 PM)

I can tell you I calculated AV for WitpTracker and it is not an easy task ... the game does indeed calculate this value and even still I tend to be +/- 1 on large LCU's

As is said each slot is different ...

Why don't you just use it to calculate these values automatically ... using Tracker ? Load a game, and look at the LCU Production screen.

If you want me to go into the ins and outs of course I can ... screen shot coming ...




[image]local://upfiles/19798/AB005CDAE20942F3BF1221859DEFA675.jpg[/image]



ttjhowell -> RE: List of Units (7/12/2008 3:30:16 PM)

Wow. I'd played around with WitP decoder before but had to stop because my low spec computer can only just run WitP and:

a) The data files were taking up too much hard-drive space
b) It was hard for me to ALT+TAB between WitP and any other program without crashing the game

I liked what I saw but figured I could do without it (I'm only playing the Allies) and never bothered to look at WitP Tracker assuming it would provide the same advantages at the same price. Big mistake. This is just what I've been looking for and I'm annoyed at myself for not using from the start of the game. As for the two problems listed above I'm just going to have to make more hard-drive space available and Tracker seemed pretty open to switching backwards and forwards to WitP.

So thank you so much for the lead. [&o]

One little thing. I notice that the LCU Production screen gives the AV but the LCU's screen doesn't. Any reason for this? No big deal anyway, it's pretty clear from the names which are division size.

Cheers!



ttjhowell -> RE: List of Units (7/12/2008 3:33:38 PM)

Oh, and VSWG, I'm using Excel 2003. I would still love to have the info in excel format since I assume that it is not possible to export the info from tracker.


John





n01487477 -> RE: List of Units (7/12/2008 4:46:48 PM)

quote:

ORIGINAL: ttjhowell
Wow. I'd played around with WitP decoder before but had to stop because my low spec computer can only just run WitP and:

a) The data files were taking up too much hard-drive space
b) It was hard for me to ALT+TAB between WitP and any other program without crashing the game

I liked what I saw but figured I could do without it (I'm only playing the Allies) and never bothered to look at WitP Tracker assuming it would provide the same advantages at the same price. Big mistake. This is just what I've been looking for and I'm annoyed at myself for not using from the start of the game. As for the two problems listed above I'm just going to have to make more hard-drive space available and Tracker seemed pretty open to switching backwards and forwards to WitP.

So thank you so much for the lead. [&o]

One little thing. I notice that the LCU Production screen gives the AV but the LCU's screen doesn't. Any reason for this? No big deal anyway, it's pretty clear from the names which are division size.
Cheers!

No problem, glad you like it ... also there is probably going to be a new release this weekend, so look out for that ... we will get to printing to file / printer soon... if you really need it now I can export for you and send in xls.

Just Pm me your email and which mod.
Cheers Damian



VSWG -> RE: List of Units (7/12/2008 6:51:44 PM)


quote:

ORIGINAL: ttjhowell

Oh, and VSWG, I'm using Excel 2003. I would still love to have the info in excel format since I assume that it is not possible to export the info from tracker.


John

I made this file a while ago for CHS Scen 156. Should be identical for other CHS scenarios. Have a look, with some sorting and filtering you should be able to create the list of units you want.

http://www.filefactory.com/file/d7ef52/n/LCU_xls

4 MB




ttjhowell -> RE: List of Units (7/12/2008 10:03:03 PM)

File downloaded and that was just what I needed (I'm sure 156 is the same as 157). And I can sort by suffix so that I only pick up divisions. Brillant! Consider the question done and dusted.

I should just point out that I really like WitP Decoder as well and some of the features... the history map for example showing where a unit has been throughout the entire game... I would absolutely expect to see in WitP II. It's just that to get the full use of this it best to load the turn each time and I just don't have hard drive space to do that. Nor the discipline. With the tracker I can see that I might just load a turn now and again to do some housekeeping.

John



ttjhowell -> RE: List of Units (7/12/2008 10:07:35 PM)

Just out of interest. If he were to only spend his PP on releasing divisions from restricted commands (eg the home island), how many months would he take to get each division free?

John



ttjhowell -> RE: List of Units (7/23/2008 3:59:32 PM)

quote:

ORIGINAL: ttjhowell

Just out of interest. If he were to only spend his PP on releasing divisions from restricted commands (eg the home island), how many months would he take to get each division free?

John


You're right, this was a lazy question. Each Jap division costs around 1500-1600PP. The Japs accumulate 50PP per turn so that is 30-32 days, lets say a month.

Judging by the units I have seen in PM, Rabul & Ragoon and estimating the ones I have seening moving around in China I would say I am looking at between 3 to 8 Divs comming into Australia via Perth. Hmm, doesn't help much.



John 3rd -> RE: List of Units (7/23/2008 4:18:55 PM)

A Japanese Brigade costs 2200 PP and a full Division runs about 3300 PP.  If you are running a Mod--like Big B's--then the Japanese have understrength units in China that are much cheaper to buy out (800-1000 PP).

Normal WITP provides around 50 PP a day while Brian's is 100/day and I think Nemo's is more then that.




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.5932617