Spreadsheets / Organization

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

Spreadsheets / Organization

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 >> Spreadsheets / Organization

Page: [1]

Message

<< Older Topic Newer Topic >>

Spreadsheets / Organization - 9/17/2010 4:04:25 PM

brian800000

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

I recently purchased this game, which is undoubtedly going to cause nothing but chaos and trauma in my life.

The first problem I wanted to tackle was to work out a way to stay organized (in the game, not in my life, any organizational hopes I had irl were dashed when I bought this game). After reading the forums I envisioned doing this through a series of spreadsheets--one category to track naval ships, one for ground units, one for bases, and one for air units. As the turns play I could update key changes (such as location and combat losses), and then once a month review to update the other data. By sorting and using pivot tables, I could quickly customize almost any report I would ever need.

I think this was a great idea, until I opened the game and saw the incredible number of units. There is no way I can type that info into a spreadsheet! Are there perhaps already made spreadsheets out there with this info? I did a search and found some that may help (primarily around allied set up).

Also, I was planning putting in units under construction. So for example, for CVs I would list all that both I and the enemy have on 12/7/1941, and also all that are under construction with a note of the date in service. However, when I reviewed this I noticed that I have the Lexington (makes sense), but a new Lexington is under construction. That makes sense historically, but what if the first Lexington doesn't get sunk? Will I have two Lexington carriers floating around?

Post #: 1

RE: Spreadsheets / Organization - 9/17/2010 4:16:21 PM

Nomad

Posts: 5905
Joined: 9/5/2001
From: West Yellowstone, Montana
Status: offline

1. Download Tracker, the best there is for seeing how your forces are. Plus, many of the screens can be downloaded into a CVS file that can then be uploaded into a spread sheet.

2. Any of the ships with a II at the end can be renamed before they are on the map. On the ship available list, select one, and you will see the name is in yellow, not white. You click on it and put in a new name.

3. You should also look at WitPLoadAE. It comes with the game and is in the scen folder of the installed game. It will download the scenario files into CVS files also.

< Message edited by Nomad -- 9/17/2010 4:18:31 PM >

_____________________________

(in reply to brian800000)

Post #: 2

RE: Spreadsheets / Organization - 9/17/2010 4:20:10 PM

Mike Solli

Posts: 15792
Joined: 10/18/2000
From: the flight deck of the Zuikaku
Status: offline

Yeah, the game is a shocker the first time you open it.

Concerning the Lexington II, you can rename her, along with any ship with a "II" designation.

I fancy myself as the spreadsheet king, and find them very helpful. Unfortunately, I play the good guys. Can't help you with my spreadsheets. There are many spreadsheets from the bad guy (Allied) perspective. You just have to dig a bit.

Good luck, have fun, and welcome to the best game ever created!

_____________________________

Created by the amazing Dixie

(in reply to brian800000)

Post #: 3

RE: Spreadsheets / Organization - 9/17/2010 4:20:11 PM

Mike Solli

Posts: 15792
Joined: 10/18/2000
From: the flight deck of the Zuikaku
Status: offline

Duplicate.

_____________________________

Created by the amazing Dixie

(in reply to brian800000)

Post #: 4

RE: Spreadsheets / Organization - 9/17/2010 4:49:29 PM

brian800000

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

Thanks guys. I think those tips are going to help a lot.

(in reply to Mike Solli)

Post #: 5

RE: Spreadsheets / Organization - 9/17/2010 5:44:09 PM

Djordje

Posts: 537
Joined: 9/12/2004
Status: offline

You can find tracker and all information about it here:

http://sites.google.com/site/witptracker/

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

(in reply to brian800000)

Post #: 6

RE: Spreadsheets / Organization - 9/17/2010 5:48:38 PM

pws1225

Posts: 1166
Joined: 8/9/2010
From: Tate's Hell, Florida
Status: offline

When i first bought the game almost a year ago, I too thought spreadsheets might help bring order to the maze of units being offered. However, I found two other simpler approaches that helped simplify the task. The first is the editor. I used it to tell me in a rather convenient form when major combat ships would become available, and when the components of the major (division level) land units would arrive. The editor provides a convenient way of seeing which regs combine to form a division.

The other device is uased is simply a dedicated pen and pad of paper. For me, the most challenging task at the outset was organizing an amphibious invasion. The pad of paper approach simply lists the units I wanted to include and where they are located. That list helped enormously when it came time to load and go.

The bottom line, imo, is to keep it simple at first.

(in reply to brian800000)

Post #: 7