Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

Japanese LCU Org Chart

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

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Japanese LCU Org Chart Page: [1]
Login
Message << Older Topic   Newer Topic >>
Japanese LCU Org Chart - 2/9/2011 6:59:21 AM   
FeurerKrieg


Posts: 3397
Joined: 6/15/2005
From: Denver, CO
Status: offline
Has anyone put together a reference in Excel (or any format for that matter) that shows all the Japanese LCUs and what divisions they belong too? I could work on one myself, but just want to make sure someone else hasn't already done it.

_____________________________


Upper portion used with permission of www.subart.net, copyright John Meeks
Post #: 1
RE: Japanese LCU Org Chart - 2/9/2011 6:14:10 PM   
brian800000

 

Posts: 225
Joined: 9/15/2010
Status: offline
I (briefly) started one for the allies with the intention of doing one for the Japanese as well. I'm also interested in this.

(in reply to FeurerKrieg)
Post #: 2
RE: Japanese LCU Org Chart - 2/9/2011 7:08:03 PM   
FeurerKrieg


Posts: 3397
Joined: 6/15/2005
From: Denver, CO
Status: offline
If you want, PM me your work so far. If I start working on it, I can follow you format and maybe we can collaborate and create a comprehensive sheet that covers both sides.



_____________________________


Upper portion used with permission of www.subart.net, copyright John Meeks

(in reply to brian800000)
Post #: 3
RE: Japanese LCU Org Chart - 2/9/2011 8:03:24 PM   
kaleun

 

Posts: 5145
Joined: 5/29/2002
From: Colorado
Status: offline


_____________________________

Appear at places to which he must hasten; move swiftly where he does not expect you.
Sun Tzu

(in reply to FeurerKrieg)
Post #: 4
RE: Japanese LCU Org Chart - 2/9/2011 8:32:43 PM   
Hanzberger


Posts: 921
Joined: 4/26/2006
From: SE Pennsylvania
Status: offline
I cant take credit for it but here is something I have.
You have to change the extention of it to work FROM TXT TO XLS. You can't upload stuff with and xls extention.

Attachment (1)

(in reply to kaleun)
Post #: 5
RE: Japanese LCU Org Chart - 2/9/2011 8:51:01 PM   
FeurerKrieg


Posts: 3397
Joined: 6/15/2005
From: Denver, CO
Status: offline
Thanks, Hanzberger. This looks similar to the export from WITPTracker, and it is a good start. I basically plan to add another column for 'Divisional' ownership, so that it is easier to see which units are part of a division and have been broken down in the editor (as opposed to the in-game /A, /B, /C split).



_____________________________


Upper portion used with permission of www.subart.net, copyright John Meeks

(in reply to Hanzberger)
Post #: 6
RE: Japanese LCU Org Chart - 2/9/2011 9:05:00 PM   
Hanzberger


Posts: 921
Joined: 4/26/2006
From: SE Pennsylvania
Status: offline
Ok PM me your results if you get them thanks or just post them for everyone , better yet.

(in reply to FeurerKrieg)
Post #: 7
RE: Japanese LCU Org Chart - 2/10/2011 7:21:42 AM   
FeurerKrieg


Posts: 3397
Joined: 6/15/2005
From: Denver, CO
Status: offline
Here it is. I did a turn one CSV dump from WITPTracker, and then did a spin through the Editor one unit at a time to put this together. Some units have 'SubParents' so those are in here too.

Hope it helps. I'm going to ask the tracker guys if they can put this in the LCU page of tracker. I would think it is possible, but who knows.

Change the file extension to .zip and then you can decompress into an Excel file.




Attachment (1)

_____________________________


Upper portion used with permission of www.subart.net, copyright John Meeks

(in reply to Hanzberger)
Post #: 8
RE: Japanese LCU Org Chart - 2/10/2011 3:00:04 PM   
Hanzberger


Posts: 921
Joined: 4/26/2006
From: SE Pennsylvania
Status: offline
I will go back into tracker and see what Damian has there for LCU's, I don't think I really took a good look at it.

(in reply to FeurerKrieg)
Post #: 9
RE: Japanese LCU Org Chart - 2/10/2011 4:12:42 PM   
Chris21wen

 

Posts: 6249
Joined: 1/17/2002
From: Cottesmore, Rutland
Status: offline
I've attached one it was done a while ago so itmight be out of date due to update.
Note that it's an .XLSX file so you'll have to rename it

Attachment (1)

(in reply to FeurerKrieg)
Post #: 10
RE: Japanese LCU Org Chart - 2/10/2011 4:18:22 PM   
Chris21wen

 

Posts: 6249
Joined: 1/17/2002
From: Cottesmore, Rutland
Status: offline
I've just tried downloading it and got rubbish. Doen't seem to be a text file any longer. Here it is zipped.

No its not, I'm now being told that it's not zipped, but it is. Sorry I give up.

(in reply to Chris21wen)
Post #: 11
RE: Japanese LCU Org Chart - 2/10/2011 6:24:36 PM   
FeurerKrieg


Posts: 3397
Joined: 6/15/2005
From: Denver, CO
Status: offline
Thanks, Chris. It downloaded just fine for me and opened as an .xlsx file just fine.

Your sheet looks a bit more elegant than the one I put together. Thanks!

_____________________________


Upper portion used with permission of www.subart.net, copyright John Meeks

(in reply to Chris21wen)
Post #: 12
RE: Japanese LCU Org Chart - 2/12/2011 2:32:13 PM   
brian800000

 

Posts: 225
Joined: 9/15/2010
Status: offline
I've attached what I've done so far--I haven't gotten very far yet. It is in excel, but attached as a txt.

My concept was that I would go through the editor and add in all infantry and armor allied units with their arrival dates, restricted/unrestricted command, and grouped by division (if any). When I finish, I'll organize it so the divisions (along with their components that may arrive/start separately) are in one section, and permanently separated units in another.

Attachment (1)

(in reply to FeurerKrieg)
Post #: 13
RE: Japanese LCU Org Chart - 2/12/2011 6:10:50 PM   
FeurerKrieg


Posts: 3397
Joined: 6/15/2005
From: Denver, CO
Status: offline
Great, thanks!

_____________________________


Upper portion used with permission of www.subart.net, copyright John Meeks

(in reply to brian800000)
Post #: 14
RE: Japanese LCU Org Chart - 2/12/2011 6:23:46 PM   
John 3rd


Posts: 17178
Joined: 9/8/2005
From: La Salle, Colorado
Status: offline
When this is complete please let us know. It would be great to have a hard copy!

_____________________________



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

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

(in reply to FeurerKrieg)
Post #: 15
RE: Japanese LCU Org Chart - 2/13/2011 6:16:54 PM   
Chris21wen

 

Posts: 6249
Joined: 1/17/2002
From: Cottesmore, Rutland
Status: offline

quote:

ORIGINAL: brian800000

I've attached what I've done so far--I haven't gotten very far yet. It is in excel, but attached as a txt.

My concept was that I would go through the editor and add in all infantry and armor allied units with their arrival dates, restricted/unrestricted command, and grouped by division (if any). When I finish, I'll organize it so the divisions (along with their components that may arrive/start separately) are in one section, and permanently separated units in another.


If your intereseted I have a preadsheet with this info on but have no way to get to post it as a spreadsheet.

(in reply to brian800000)
Post #: 16
RE: Japanese LCU Org Chart - 2/13/2011 7:50:51 PM   
USSAmerica


Posts: 18715
Joined: 10/28/2002
From: Graham, NC, USA
Status: offline
Chris, you can attach it to a post, if you rename the extension from .xls to .txt.

_____________________________

Mike

"Good times will set you free" - Jimmy Buffett

"They need more rum punch" - Me


Artwork by The Amazing Dixie

(in reply to Chris21wen)
Post #: 17
RE: Japanese LCU Org Chart - 2/14/2011 10:37:22 AM   
Chris21wen

 

Posts: 6249
Joined: 1/17/2002
From: Cottesmore, Rutland
Status: offline

quote:

ORIGINAL: USS America

Chris, you can attach it to a post, if you rename the extension from .xls to .txt.


It's too big, even split into Allied and Japan. I've also tried to zip it but zip is not supported. I'll open a thread in tech support with I know does allow Zip and bigger files.

(in reply to USSAmerica)
Post #: 18
RE: Japanese LCU Org Chart - 2/14/2011 11:02:58 AM   
Chris21wen

 

Posts: 6249
Joined: 1/17/2002
From: Cottesmore, Rutland
Status: offline
Link to Scenario 1 OOB below.

http://www.matrixgames.com/forums/tm.asp?m=2726540

(in reply to Chris21wen)
Post #: 19
RE: Japanese LCU Org Chart - 2/14/2011 12:26:42 PM   
brian800000

 

Posts: 225
Joined: 9/15/2010
Status: offline

quote:

ORIGINAL: Chris H

Link to Scenario 1 OOB below.

http://www.matrixgames.com/forums/tm.asp?m=2726540


Chris, that is awesome--thanks for the link! How did you put that together?

(in reply to Chris21wen)
Post #: 20
RE: Japanese LCU Org Chart - 2/14/2011 2:35:09 PM   
Hanzberger


Posts: 921
Joined: 4/26/2006
From: SE Pennsylvania
Status: offline
Great job~!

(in reply to brian800000)
Post #: 21
RE: Japanese LCU Org Chart - 2/14/2011 4:49:37 PM   
Chris21wen

 

Posts: 6249
Joined: 1/17/2002
From: Cottesmore, Rutland
Status: offline

quote:

ORIGINAL: brian800000


quote:

ORIGINAL: Chris H

Link to Scenario 1 OOB below.

http://www.matrixgames.com/forums/tm.asp?m=2726540


Chris, that is awesome--thanks for the link! How did you put that together?


Opened the CSV files in Excel and used Excel's NAME and LOOKUP functions. If you know how to use them it's fairly straight forward but does take a sometime. It is easy to screwup so multi saves are necessary.

(in reply to brian800000)
Post #: 22
RE: Japanese LCU Org Chart - 2/14/2011 7:06:20 PM   
FeurerKrieg


Posts: 3397
Joined: 6/15/2005
From: Denver, CO
Status: offline
Nice job, Chris. Not sure if you follow the WITPAEtracker thread, but they have added a column in there for parent units too.

Now to build this same spreadsheet for the Da Babes....

_____________________________


Upper portion used with permission of www.subart.net, copyright John Meeks

(in reply to Chris21wen)
Post #: 23
Page:   [1]
All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Japanese LCU Org Chart 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

0.672