Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

List of Units

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Current Games From Matrix.] >> [World War II] >> War In The Pacific - Struggle Against Japan 1941 - 1945 >> List of Units Page: [1]
Login
Message << Older Topic   Newer Topic >>
List of Units - 7/11/2008 10:02:34 PM   
ttjhowell


Posts: 28
Joined: 11/25/2007
From: Denmark
Status: offline
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
Post #: 1
RE: List of Units - 7/11/2008 10:28:01 PM   
rjopel

 

Posts: 614
Joined: 12/19/2007
From: Charlottesville, VA, USA
Status: offline
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.


(in reply to ttjhowell)
Post #: 2
RE: List of Units - 7/11/2008 10:38:01 PM   
VSWG


Posts: 3432
Joined: 5/31/2006
From: Germany
Status: offline
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.


_____________________________


(in reply to rjopel)
Post #: 3
RE: List of Units - 7/12/2008 8:47:02 AM   
ttjhowell


Posts: 28
Joined: 11/25/2007
From: Denmark
Status: offline
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



(in reply to VSWG)
Post #: 4
RE: List of Units - 7/12/2008 11:35:25 AM   
treespider


Posts: 9796
Joined: 1/30/2005
From: Edgewater, MD
Status: offline
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.

< Message edited by treespider -- 7/12/2008 11:36:25 AM >


_____________________________

Here's a link to:
Treespider's Grand Campaign of DBB

"It is not the critic who counts, .... The credit belongs to the man who is actually in the arena..." T. Roosevelt, Paris, 1910

(in reply to ttjhowell)
Post #: 5
RE: List of Units - 7/12/2008 12:41:13 PM   
ttjhowell


Posts: 28
Joined: 11/25/2007
From: Denmark
Status: offline
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.


(in reply to treespider)
Post #: 6
RE: List of Units - 7/12/2008 12:50:02 PM   
treespider


Posts: 9796
Joined: 1/30/2005
From: Edgewater, MD
Status: offline
Av -- any squad with >10 firepower + AFV + something else ...but the squads and the AFv should get you close..

_____________________________

Here's a link to:
Treespider's Grand Campaign of DBB

"It is not the critic who counts, .... The credit belongs to the man who is actually in the arena..." T. Roosevelt, Paris, 1910

(in reply to ttjhowell)
Post #: 7
RE: List of Units - 7/12/2008 1:00:24 PM   
VSWG


Posts: 3432
Joined: 5/31/2006
From: Germany
Status: offline
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...

< Message edited by VSWG -- 7/12/2008 1:02:01 PM >


_____________________________


(in reply to ttjhowell)
Post #: 8
RE: List of Units - 7/12/2008 1:42:14 PM   
n01487477


Posts: 4779
Joined: 2/21/2006
Status: offline
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 ...







Attachment (1)

< Message edited by n01487477 -- 7/12/2008 1:47:27 PM >


_____________________________


(in reply to ttjhowell)
Post #: 9
RE: List of Units - 7/12/2008 3:30:16 PM   
ttjhowell


Posts: 28
Joined: 11/25/2007
From: Denmark
Status: offline
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.

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!

(in reply to n01487477)
Post #: 10
RE: List of Units - 7/12/2008 3:33:38 PM   
ttjhowell


Posts: 28
Joined: 11/25/2007
From: Denmark
Status: offline
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



(in reply to VSWG)
Post #: 11
RE: List of Units - 7/12/2008 4:46:48 PM   
n01487477


Posts: 4779
Joined: 2/21/2006
Status: offline
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.

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

(in reply to ttjhowell)
Post #: 12
RE: List of Units - 7/12/2008 6:51:44 PM   
VSWG


Posts: 3432
Joined: 5/31/2006
From: Germany
Status: offline

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



_____________________________


(in reply to ttjhowell)
Post #: 13
RE: List of Units - 7/12/2008 10:03:03 PM   
ttjhowell


Posts: 28
Joined: 11/25/2007
From: Denmark
Status: offline
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

(in reply to VSWG)
Post #: 14
RE: List of Units - 7/12/2008 10:07:35 PM   
ttjhowell


Posts: 28
Joined: 11/25/2007
From: Denmark
Status: offline
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

(in reply to ttjhowell)
Post #: 15
RE: List of Units - 7/23/2008 3:59:32 PM   
ttjhowell


Posts: 28
Joined: 11/25/2007
From: Denmark
Status: offline
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.

(in reply to ttjhowell)
Post #: 16
RE: List of Units - 7/23/2008 4:18:55 PM   
John 3rd


Posts: 17178
Joined: 9/8/2005
From: La Salle, Colorado
Status: offline
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.



_____________________________



Member: Treaty, Reluctant Admiral and Between the Storms Mod Team.

Reluctant Admiral Mod:
https://sites.google.com/site/reluctantadmiral/

(in reply to ttjhowell)
Post #: 17
Page:   [1]
All Forums >> [Current Games From Matrix.] >> [World War II] >> War In The Pacific - Struggle Against Japan 1941 - 1945 >> List of Units Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

1.125