Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

Allies Set-up Spreadsheet for AE

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

Logged in as: Guest
Users viewing this topic: Aurelian
  Printable Version
All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> The War Room >> Allies Set-up Spreadsheet for AE Page: [1] 2 3 4   next >   >>
Login
Message << Older Topic   Newer Topic >>
Allies Set-up Spreadsheet for AE - 11/30/2009 6:55:11 AM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
UPDATE 3/14/2017: The revised AE-Allies Setup Spreadsheet has been uploaded (previous version "D" was released on 12/28/2009 and had over 2700 downloads). It contains 1586 changes (from a total line count of 4653) For those who have used (or are using) the previous version, just go to column "AA" and filter on "1". This will show ONLY the elements which have changed, making it much easier to edit your starting setup. For a more detailed list of the changes and improvements, see the "changelog" in Post #5 below. (The link in this post has been updated so it contains the new spreadsheet)
--------------------------------------------------------------------------------------------------------------------------------------

The AE-Allies Setup Spreadsheet (like it's Japanese equivalent), is designed to give the player a prescriptive list of actions to take on "Day 2", following the December 7th series of historical moves. There are 4653 individual Bases (878), LCUs (1194), Ships (1427), Air Groups (424), and Industry elements (730), all of which can potentially be adjusted in the course of the Day 2 turn. Needless to say, that is a daunting prospect. So what this spreadsheet offers is a set of instructions for EVERY one of those 4653 individual elements. I don't pretend to be a WitP Master, and my choices are certainly open to debate. Nevertheless, I hope this will help folks get past those opening turn jitters and give you a solid base upon which to build in the days and months to come.

You also have a variety of "game play" options to consider. In particular whether one is playing PBEM or versus the AI, with "Player Defined Upgrades" on or off, and "Realistic R&D" on or off. Personally I prefer games that impose a more historical set of constraints upon the player, plus my games are played against the AI, and thus I tend to shun settings which provide additional advantages against an already crippled opponent. So that means this spreadsheet primarily is intended for those who:

1) Play with PDU "off" (this doesn't matter much to the Allies, especially in the early game)
2) Play with Realistic R&D "on" (likewise not that important in the early game)
3) Play against the AI (although most of the recommendations - China excepted - would still be pertinent against an inexperienced PBEM opponent).
4) Game setting at Hard or Very Hard: This is required in order for the AI to function adequately. The AI is not able to supply the many island outposts and only settings of Hard and above will provide a small amount of supply to ALL of the AI locations.
5) Also worth noting that this spreadsheet is designed for Scenarios 1 or 2. It will probably work fine with the new test AI Scenarios 100 and 102, and possibly even the "Japanese Ironman" scenarios, although it's never been tested with those.

Strategically, all unit movements and/or adjustments were made to support a fairly conservative Allied approach. The top level objectives are as follows:

1) Hold Burma
2) Build up bases in Eastern India
3) Holding action in China (limited offensives, but mostly moving troops into defensible positions)
4) US Carriers positioned to assault either Wake or the Marshalls
5) Limited "Sir Robin" in DEI and Phillipines combined with aggressive SCTF activity
6) Detailed network of Search & ASW planes at key locations (interlocking verified and tweaked)
7) Almost all subs sent on patrol (with patrol zones detailed)
8) Get convoys moving between the US and Pearl Harbor/Australia & Abadan/Aden/Capetown and India
9) Begin to establish a line of bases between the US and Australia
10) Preparations for building out the Aleutians

If this sounds like your cup of tea, here's the plan to get you started:

(Note: The attachment below will always be updated to contain the most recent spreadsheet revision)

Attachment (1)

< Message edited by Kull -- 3/14/2017 12:43:01 AM >
Post #: 1
RE: Allies Set-up Spreadsheet for AE - 11/30/2009 6:55:37 AM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
A picture is worth a thousand words, so here's what the AE-Allies Setup Spreadsheet looks like. Each column has a story:

Col A: Counter - This is the "row count". When using a filter button (lets say you wanted to work on all the "Alaska" region bases and units first), the counter in Cell A6 tells you how many rows of data you are working on (Alaska = 93).
Col B: Region - Every location on the map falls into one of 49 regions. It's one way to work on your Turn 2 selections in "bite size chunks". The Base & Industry data came from the WitP AE Tracker dataset (of which some was edited), and was manually extended to units.
Col C: Location - The hex location of every base, unit, and industry element. Modified WitP AE Tracker data.
Col D: Location Name - If the hex has a name (i.e. it's a Base of some sort), here it is. Modified WitP AE Tracker data.
Col E: Type - There are five row "types": Bases, Air Groups, LCUs, Ships, and Industry. New field, not from Tracker. Some of these cells are color coded:
- Green: Garrison Requirement is met
- Red: Garrison Requirement is NOT met
- Light Blue: Identifies all rows in which follow-on actions are required. You can filter this column by color in the "Day 3 and beyond" turns to identify tasks that still need to be performed (for example, LCUs that travel to one location by rail and then move somewhere else by road)
Col F: Unit Name - The name of each unit. Straight from the WitP AE Tracker datasets.
Col G: Unit Model/Type - Applies only to units. Airframe Model Names in Light Grey cells do not get upgrades. Unmodified data from WitP AE Tracker.
Col H: HQ - Applies only to Bases, Air Groups, and LCUs. Unmodified data from WitP AE Tracker.
Col I: Nation - Applies only to Bases, Air Groups, and LCUs. Heavily modified data from WitP AE Tracker.
Col J: ID - Unit ID. Of limited use, but insofar as it was provided by WitP AE Tracker, it's loaded here.
Col K: Code - Indicates the restriction status of units, and is also used to determine whether a base has a Garrison requirement:
1: Unrestricted units. Can be moved to any base.
2: Restricted units. Can spend PP to switch to an unrestricted HQ (thus allowing moves to any base)
3: Restricted units. Cannot spend PP to change the HQ. Some "static" units allow HQ changes but they are marked as "3" because they can't move anyway.
G: Base has a Garrison Requirement (see Comments in Column L for details). Certain types of damage can occur when requirement is not met (see Manual for details)
Col L: Comments - The meat of the spreadsheet. You can either follow my recommendations or tweak them to apply to your own strategy. Rather obviously, this is a new field, not from Tracker. Here's the meaning of the colored fonts used in the Comments field:
- Black: Take action as indicated
- Red: Either have to make a decision or ensure that indicated action takes place at a later date
- Green: Useful Information ("why" or "what", not "go do")
- Blue: Search coordinates
- Purple: Change made to a pre-existing TF (i.e. on-map on Turn 1)




Attachment (1)

< Message edited by Kull -- 3/13/2017 11:53:52 PM >

(in reply to Kull)
Post #: 2
RE: Allies Set-up Spreadsheet for AE - 11/30/2009 6:55:56 AM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
Here's a screenshot of the second half of the spreadsheet. You may have been wondering about those descriptions in rows 1-5 of column D. They exist because I did something in this spreadsheet which is normally a bad idea - the data in columns M thru AH varies depending upon the "Type" (column E). I did this for a few reasons:
- First of all, this data is interesting but most people won't use it when making their Turn 2 selections.
- Second, it allowed me to shrink the width of the spreadsheet by a factor of three, which greatly enhances "usability".
- Third, all of this data was taken directly from the WitP AE Tracker datasets, and is largely unmodified.

So how do you interpret this? It's actually pretty easy:

- If you are viewing a row in which the "type" is "Industry", then use the column headings in row 1 (applies to columns M-P)
- If you are viewing a row in which the "type" is "Bases", then use the column headings in row 2 (applies to columns M-Z)
- If you are viewing a row in which the "type" is "LCU", then use the column headings in row 3 (applies to columns M-AE)
- If you are viewing a row in which the "type" is "Ship", then use the column headings in row 4 (applies to columns M-AH)
- If you are viewing a row in which the "type" is "Air Group", then use the column headings in row 5 (applies to columns M-AH)




Attachment (1)

< Message edited by Kull -- 3/13/2017 11:52:48 PM >

(in reply to Kull)
Post #: 3
RE: Allies Set-up Spreadsheet for AE - 11/30/2009 6:56:15 AM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
There are eight tabs in this workbook (used to be four), all serving a different purpose:

1) Getting Started (New): Primarily focused on teaching you to how to use and interpret the "Allied Set-up" worksheet, but also provides a synopsis of the other tabs.
2) Allies Set-up (Revised): Discussed extensively above.
3) 12-41 Arrivals (New): This tab contains all the units scheduled to arrive on-map during December 1941. This is not just a list of units, but has the same format as the "Allies Set-up" spreadsheet, to include a full set of comments for each unit! This takes the "hold your hand" ethos one step further, by providing suggestions on what to do with all these near-term new units (182 arrive in this 3-week period).
4) Unit Arrival Dates (New): This is something I had planned to do for a long time, but it took a while to achieve - a single document listing the arrival dates and locations for ALL 8318 units - Land, Air and Sea. Much of this was pulled from Tracker, but it's nice to have all of it in one location. For the most part, use of this worksheet is self-explanatory, but please take note that it follows the same approach as the "Allies Set-up" worksheet, with different column headings in rows 2-4 (applies to data in columns N thru AC). It can help to filter by unit "Type" (column C) in order to see the various units aggregated. The headings for all other columns (A thru M) apply equally to all units, regardless of type. (Screen shot below)
5) Transports for Key LCUs (New): Details (by name) the ships needed to perform three Land Unit transport missions and one Air Unit transport mission. To some extent this is redundant with information in the "Comments" column in the "Allied Set-up" worksheet, but it can be helpful to see it centralized in one place.
6) Region-Base list (New): Information pulled from Tracker, listing all Bases (including the Japanese) and their associated regions.
7) Devices (New): Information pulled from Tracker, listing all the devices (including those shared with or exclusive to Japan) . Can be very helpful when trying to determine the importance of any given device upgrade, especially for LCUs. Redundant with reports available in game, but the sorting here is a bit easier, especially if you have this workbook open during your game.
8) Changelog (Revised): The number of changes between Rev "D" and "E" (this version) takes this update far beyond the 1586 new or revised comments. Cumulatively they also reflect a complexity reduction philosophy more in keeping with a "beginner's how to" as well as a subtle change in the unit movement methodology, particularly as it affects certain theatres in the first month or so of the war. Accordingly, I highly recommend that you review the 7 items listed in the Rev E changelog description. It won't take long to read, and will give you a better understanding of the overall approach.




Attachment (1)

< Message edited by Kull -- 3/14/2017 12:09:40 AM >

(in reply to Kull)
Post #: 4
RE: Allies Set-up Spreadsheet for AE - 11/30/2009 6:56:34 AM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
Changes in Version "E" (Various strategic/tactical improvements & formats revised to match "Japan Set-up")

1) Format & Terminology changes:
A lot of changes were made to format in order to fully align the "Allies Set-up" worksheet with it's Japan counterpart. You'll also notice that the color coding is identical, as are the expanded data fields (columns M-AH) imported from Tracker. Much of this isn't immediately apparent, but users of both spreadsheets will now find them to be almost fully in synch.

The comments section was extensively revised in order to use terminology "shortcuts" that are identical to those in the Japanese version. For example:
Original ASW Patrol Settings: ASW Patrol, Search: 310-40, Level: 50, Alt: 5K, Train: 20 (all else no change)
New "Japan-style" Description: ASW Patrol (50): 310-40, Alt: 5K, Train: 20

2) Naval Air Units:
Air units aboard ship now have their own "data row" (same as the Japan spreadsheet)

3) Veteran Pilot Reallocation Process:
The previous version of the spreadsheet contained detailed recommendations on how many Veteran Pilots should be harvested and moved from one unit to another, literally noting how many pilots should be pulled from unit "X" and reassigned to units "Y & Z". On further consideration, that's too much micro-management for a "getting started" spreadsheet. All that is gone, replaced by an occasional notation for any unit that might benefit from adding replacements or even swapping in some Veteran Pilots (in general, that would be any pilot with 60+ experience).

4) Allied Pilot Training:
A major change in the new version is a much larger number of air units assigned to Training missions. Most Allied pilots begin the game with very low experience and their across-the-board specialized skill numbers are frequently atrocious. Accordingly, the number of air units flying missions (Naval Search and ASW Patrols in particular) have been greatly reduced so you can get an early start on building up those important skill sets.

5) Submarine Patrol Zones:
I have provided specific Patrol Zones for most submarines, but it can be very time consuming to match them exactly. Accordingly, you should feel free to set your own zones, or simply note the designated area for each zone - always specified in the Comments - and then use the "Patrol Around Target" button. The resulting computer choices are often less than optimal, but are easy to alter in the Patrol Zone selection screen. Tip: When using the "Patrol Around Target" button, do not select any land hex. For some reason that sets only two patrol zone points, whereas selecting an ocean hex gives three.

The AI doesn't deal with enemy subs as well as a Human player, so to reduce their impact a bit, Submarine Reaction limits are always kept at "1"

6) Actions/Descriptions for Damaged Units:
The previous version provided comments based on the "after Day 1" state of all units, to include those damaged in the various Japanese attacks. However, even with the "Historical First Turn" toggled on, the results of these attacks are highly variable - especially the list of ships that are sunk, and even the damage levels on those which survive. Some air units can also be damaged so severely as to have few flying airframes. Pearl Harbor is the primary example, but similar issues affect the Philippines, Burma, & Malaya.

Accordingly, the new spreadsheet assumes all units are present and undamaged, but does try to minimize the assignment of actions to those likely to be impacted. You will just have to go through each port and airfield and make adjustments according to the true state of affairs in your game.

7) Historical Game Play Considerations:
WitP-AE is not a simulation, and there is no requirement for the human player to try and "replicate history". However, there are certain areas where I find the game is improved if you impose limitations on what the engine otherwise allows. Specifically:

7a) Several changes to the China Theatre:
Certain Chinese units are no longer recommended to move outside of China (except for possible offensive action against Japanese units in Border zones) unless PPs are paid to release them. Basically it's a gameplay/historical improvement - in particular to avoid the temptation of building up a non-historical defense force in Burma. There is no code which would prevent you from just marching them over the border (for free), but it's a better game if you don't.

Although there's no way to visibly distinguish Red Chinese from Kuomintang forces (to say nothing of trying to separate Chiang Kai Shek loyalists from the Warlords leading their own private armies), I've tried to add some additional realism by not grouping the two together. In sum, the game has some Kuomintang armies in Yenan (the communist capital) while two Red Chinese units occupy Sian (a Kuomintang city). Units that are moving only for this reason will contain a simple notation in the comment column ("Communist" or "Kuomintang"), so players who do not care for this level of granularity can simply ignore the movement instructions given to those units. This was the result of a pretty detailed analysis on the affiliation of in-game units:

7b) ABDA Command:
Historically, the "American-British-Dutch-Australian" command system was not finalized until very late December. Accordingly, the new version of the spreadsheet actively avoids combinations of forces that would not have taken place until that time. So no mixed Naval, Ground, or Air Forces forces from the outset - in particular ANY combination involving the Dutch - until January 1st.

This does not apply to Cargo ships and escorts moving fuel or supply (but it does apply to Troop Transports), or to existing Allies like Britain-Commonwealth-Australia-NZ, nor also the Australian-US strategic cooperation that began very shortly after the Pacific War commenced. More problematic is British-US cooperation. Although already coordinating closely in the Atlantic, the US was very concerned about appearing to support British colonial activities in the Far East, and actively avoided doing so throughout the war. So aside from Naval Task force combinations, the spreadsheet deliberately avoids combined land and air operations involving the US and Britain (AVG being the sole exception, for historical reasons). The same "colonial conundrum" likewise bars the movement of US land forces into Dutch possessions, while British/Australian/NZ land forces never move to Dutch bases as politically those countries were far more concerned about homeland (or "own colony") defenses.

It should also be remembered that the purpose of ABDA was to defend the "Malay Barrier" (which extended through the southern islands of the Dutch East Indies), not facilitate it's evacuation. Accordingly, I've reduced (or added significant "degree of difficulty") to all "Brave Sir Robin" activities. This means:
- Evacuating units from the North Coast of Borneo (or from Hong Kong), now requires British-owned ships, bases, and air transports. No more pull-outs using Dutch or US air and sea units (nor into into Dutch or US bases)
- Likewise, no more buying out of Dutch units for use in Australia or other theatres. Moving them in limited numbers to Dutch-owned bases that are closer to Australia is OK, since that is in accordance with the ABDA charter.
- Although not strictly related to ABDA, the wholesale evacuation of US units from the Philippines has also been significantly curtailed. Gen. Douglas MacArthur commanded this theatre, and historically would NEVER have supported a major reduction in ground forces - quite the contrary, he was pushing for more. Air and Naval units are a different matter, as historically they were pulled out early in the campaign.

Obviously you can choose to ignore all these limitations, but please remember that it's very easy to break the AI early in the war, especially when the human player can use all sorts of historically impossible force combinations ("Fortress Palembang" and "Fortress Java" in particular). You want to have a fun game here, and the best way to do that is to impose the actual historical limits on your options, thereby giving the AI a decent chance to grab the bases it needs to support the Japanese economy in the years to come. Strategies that are totally "OK" against a human player (who can react to them) will strangle the script-driven AI before it even has a chance to get going.

7c) American Pilot Considerations (AVG & Philippines):
The AVG (literally the "All Volunteer Group") was composed of civilians operating under contract, and realistically the player should not treat these pilots like the rest of the American pilot pool. You start the war with 79 pilots assigned to the 3 AVG units in Burma, but since there were originally 99 under contract, it's historically reasonable to add 20 more into the AVG pool.....but no more until such time as the units withdraw. For similar reasons, these units should restrict their movement to bases in Burma and China, as was historically true.

During the early part of the war the US was not able to easily move pilots in or out of the Philippines theatre of operations. Certainly not as easily as one can by using the Pilot replacement buttons. To play as historically as possible, the human player should NOT move veteran pilots in (or out) of these units, at least until the end of December. That would reflect the early war chaos, after which the player should feel free to take whatever actions seem appropriate.

As always, these are only recommendations and the player can choose to operate differently.

< Message edited by Kull -- 3/14/2017 4:05:16 AM >

(in reply to Kull)
Post #: 5
RE: Allies Set-up Spreadsheet for AE - 11/30/2009 8:51:44 AM   
d0mbo

 

Posts: 579
Joined: 8/21/2009
From: Holland
Status: offline
Looks great, too bad i only play Japanese. I don't think a spreadsheet for that side is in order? :-)

Keep it up,

d0mbo.


(in reply to Kull)
Post #: 6
RE: Allies Set-up Spreadsheet for AE - 11/30/2009 12:47:00 PM   
Blackhorse


Posts: 1936
Joined: 8/20/2000
From: Eastern US
Status: offline
Outstanding!

This will be enormously helpful.

_____________________________

WitP-AE -- US LCU & AI Stuff

Oddball: Why don't you knock it off with them negative waves? Why don't you dig how beautiful it is out here? Why don't you say something righteous and hopeful for a change?
Moriarty: Crap!

(in reply to d0mbo)
Post #: 7
RE: Allies Set-up Spreadsheet for AE - 11/30/2009 2:19:32 PM   
n01487477


Posts: 4768
Joined: 2/21/2006
Status: offline
quote:

Kull wrote: One major element missing from this spreadsheet is the "Arrival Location". Unfortunately that's not captured in the WitP AE Tracker data dump, although it would be very useful!


Actually it is ... but it is in the LCU production area.

_____________________________


(in reply to Kull)
Post #: 8
RE: Allies Set-up Spreadsheet for AE - 11/30/2009 6:34:15 PM   
Knavey

 

Posts: 2989
Joined: 9/12/2002
From: Valrico, Florida
Status: offline
Wow!

Will be taking a close look at this one.

Thanks,

_____________________________

x-Nuc twidget
CVN-71
USN 87-93
"Going slow in the fast direction"

(in reply to n01487477)
Post #: 9
RE: Allies Set-up Spreadsheet for AE - 11/30/2009 9:33:01 PM   
stuman


Posts: 3886
Joined: 9/14/2008
From: Elvis' Hometown
Status: offline
Very nice of you to go to the trouble Kull. Looks quite helpful.

_____________________________

" Gentlemen, you can't fight in here! This is the War Room. " President Muffley


(in reply to Knavey)
Post #: 10
RE: Allies Set-up Spreadsheet for AE - 12/4/2009 5:10:53 PM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
quote:

ORIGINAL: Blackhorse

Outstanding!

This will be enormously helpful.


quote:

ORIGINAL: Knavey

Wow!

Will be taking a close look at this one.

Thanks,


quote:

ORIGINAL: stuman

Very nice of you to go to the trouble Kull. Looks quite helpful.


Thanks for the supportive comments, guys! And also to the 72 folks (and counting) who've already downloaded it! As I play further into the game, I'll come back and create revisions if it turns out that some of my force dispositions are....less than optimal! So far it's already obvious that AI-KB's tendency to loiter around Pearl Harbor means that most of my recommended TFs there are little more than suicide missions. Plus, I'm pretty sure that I can improve the West Coast Search & ASW net. Otherwise it seems to be playing out rather well.

Comments or questions are always welcome!

(in reply to stuman)
Post #: 11
RE: Allies Set-up Spreadsheet for AE - 12/16/2009 2:00:22 PM   
xj900uk

 

Posts: 1221
Joined: 3/22/2007
Status: offline
Err, where is the spreadsheet or it's URL?  I'd love to download & look at it, but can't seem to see the handle on any of the Forums quoted...

(in reply to Kull)
Post #: 12
RE: Allies Set-up Spreadsheet for AE - 12/16/2009 2:29:43 PM   
n01487477


Posts: 4768
Joined: 2/21/2006
Status: offline

quote:

ORIGINAL: xj900uk

Err, where is the spreadsheet or it's URL?  I'd love to download & look at it, but can't seem to see the handle on any of the Forums quoted...

Check the first post in this thread - I believe the attachment is the file in Q.

_____________________________


(in reply to xj900uk)
Post #: 13
RE: Allies Set-up Spreadsheet for AE - 12/16/2009 10:05:57 PM   
Chromius


Posts: 20
Joined: 12/13/2009
Status: offline
Wow this is great thanks, I have spent the last 4-5 days on day 2, and I am only half done this will help immensely.

Cheers

_____________________________

The origin of the word "Apocalypse" = The revealing of hidden knowledge.

(in reply to n01487477)
Post #: 14
RE: Allies Set-up Spreadsheet for AE - 12/17/2009 12:43:15 AM   
Menser

 

Posts: 206
Joined: 5/2/2005
From: Peabody, Massachusetts
Status: offline
ANy revisions since patch 2 Kull? very nice spreadsheet :)


_____________________________

"Alea iacta est." Caius Julius
"If you can't beat your computer at chess, try kickboxing." Emo Philips
"Caedite eos! Novit enim Dominus qui sunt eius." Abbot Arnaud Amalric

(in reply to Chromius)
Post #: 15
RE: Allies Set-up Spreadsheet for AE - 12/17/2009 2:36:18 AM   
Gary D


Posts: 159
Joined: 6/6/2002
From: Southern California
Status: offline
Yes Kull, thank you for sharing this with us. It is one of the few things pertaining to AE that I can smuggle on to a government laptop to enjoy on a airline trip.

All the best!

(in reply to Menser)
Post #: 16
RE: Allies Set-up Spreadsheet for AE - 12/17/2009 3:40:57 AM   
DivePac88


Posts: 3123
Joined: 10/9/2008
From: Somewhere in the South Pacific.
Status: offline
Excellent tool Kull, thank you for the time and sweat, this spreadsheet will come in real handy.

_____________________________


When you see the Southern Cross, For the first time
You understand now, Why you came this way

(in reply to Kull)
Post #: 17
RE: Allies Set-up Spreadsheet for AE - 12/17/2009 1:28:18 PM   
xj900uk

 

Posts: 1221
Joined: 3/22/2007
Status: offline
quote:

Check the first post in this thread - I believe the attachment is the file in Q.

Thanx, found it now...

(in reply to DivePac88)
Post #: 18
RE: Allies Set-up Spreadsheet for AE - 12/17/2009 1:59:37 PM   
Canoerebel


Posts: 12883
Joined: 12/14/2002
From: Northwestern Georgia, USA
Status: offline
Kull,

Thanks!  This will be a huge help next time I start a game.

How long did you work on this?

Canoe "I won't have to do it on the fly now" Rebel

< Message edited by Canoerebel -- 12/17/2009 2:00:01 PM >

(in reply to xj900uk)
Post #: 19
RE: Allies Set-up Spreadsheet for AE - 12/28/2009 1:50:42 AM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
quote:

ORIGINAL: Menser

ANy revisions since patch 2 Kull? very nice spreadsheet :)


Actually, yes! I just finished off a MAJOR revision:

1) Every move was set-up and tested on a new Patch 2 (w/Hotfix) game.

2) Uses the Enhanced Japan Scenario 2 as the baseline instead of Ironman Scenario 9 (S-2 is more likely to be the scenario of choice for new players, which is probably the majority of folks who will use this)

3) Changes include:
- Improved strategy for Chinese LCUs.
- Greater use of Naval Search vs. ASW for "short-range" air units
- Pearl Harbor Naval Unit instructions are listed, but most of the TFs are not created until KB leaves the area - this averts a horrible slaughter on the 8th.
- No PPs are expended, but those which are recommended can be sorted on and counted up (the player can easily make his own changes and follow the count to ensure it's less than 150).
- Accounts for all the new Garrison requirement changes (mostly in China, Burma, & India).
- New strategies involving mines and Air-evac using Transports.
- A wholesales clarification of the recommendations involving "auto-disband" (which only works when the TF arrives at it's home port, NOT the target port!)
- Reinforcements are now "fixed". The previous spreadsheet used the +/-14 day setting, and that meant the spreadsheet was using units which most players won't have in hand for days or weeks, lus the "delay" tabs were completely unreliable.

I'm making a few minor adjustments to make it a bit more "user-friendly", and will try and post it later tonite.


quote:

ORIGINAL: Canoerebel

How long did you work on this?


The first version took over two months to build, and the Patch 2 revision took about another month to finish and test!

(in reply to Menser)
Post #: 20
RE: Allies Set-up Spreadsheet for AE - 12/28/2009 6:32:51 PM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
Bump for release of new "Rev D" version of the AE-Allies setup spreadsheet

(Rev C had 192 downloads)

(in reply to Kull)
Post #: 21
RE: Allies Set-up Spreadsheet for AE - 12/28/2009 9:28:21 PM   
IS2m

 

Posts: 194
Joined: 5/2/2005
Status: offline
Awesome spreadsheet Kull, thanks for the hard work.


(in reply to Kull)
Post #: 22
RE: Allies Set-up Spreadsheet for AE - 1/7/2010 12:41:56 AM   
dr. smith

 

Posts: 221
Joined: 6/30/2004
From: lost in space
Status: offline
This is superb!  Great job, Think with the latest patch and 3 hotfixes, I am almost ready to start an Ironman!!

I will definitely have the spreadsheet open to assist.   Though, of course the plans will be different.

Before deciding on the Ironman, wanted to find out just HOW much harder it is over the Base and 2nd Scenario.  Thanks to WitP Tracker, am finishing up a comparison of the difference in Forces from Scenario 1 (Base Case), Scenario 2 (Hakko Ichiu - enhanced Japan) and Scenario 10 (Ironman - bad-ass Japan).  Found a few data anomalies - will post those, those are mainly double-named units/ships - so no real "errors".  Doing a Word document but can place in an Excel spreadsheet - loaded all the exported data into Access and did work in there. 

Here's the just Fighter Aircraft Diffs:

Aircraft Type   Base    Hakko   Ironman   Iron-Dec41
=========================================
A6M2 Zero       249       357      478         +144
A5M4 Claude    171       174      189
Ki-27b Nate      518      518       493
Ki-43-Ia Oscar    24        24        49
Ki-43-Ib Oscar    32        80        80
=======================================
TOTALS           994      1153    1289       1433

The main diff for other planes is the Betty bumpup:
G4M1 Betty       157       277      277     +144

The biggest increase in ships is in DDs and Escorts, plus lots more Transports/Cargo.  Think I may do the Ironman on Historical level of difficulty, and with all those new Escorts, may have to have Reliable USN Torps.


< Message edited by dr. smith -- 1/7/2010 12:42:49 AM >

(in reply to IS2m)
Post #: 23
RE: Allies Set-up Spreadsheet for AE - 1/7/2010 4:38:59 AM   
ckk

 

Posts: 1259
Joined: 10/18/2000
From: Pensacola Beach FL
Status: offline

quote:

ORIGINAL: Kull

Bump for release of new "Rev D" version of the AE-Allies setup spreadsheet

(Rev C had 192 downloads)

Remarkable work. It got me started on AE

(in reply to Kull)
Post #: 24
RE: Allies Set-up Spreadsheet for AE - 1/16/2010 5:31:31 PM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
quote:

ORIGINAL: IS2m

Awesome spreadsheet Kull, thanks for the hard work.



Thanks for the thanks!


quote:

ORIGINAL: dr. smith

This is superb! Great job, Think with the latest patch and 3 hotfixes, I am almost ready to start an Ironman!!

I will definitely have the spreadsheet open to assist. Though, of course the plans will be different.

Before deciding on the Ironman, wanted to find out just HOW much harder it is over the Base and 2nd Scenario. Thanks to WitP Tracker, am finishing up a comparison of the difference in Forces from Scenario 1 (Base Case), Scenario 2 (Hakko Ichiu - enhanced Japan) and Scenario 10 (Ironman - bad-ass Japan). Found a few data anomalies - will post those, those are mainly double-named units/ships - so no real "errors". Doing a Word document but can place in an Excel spreadsheet - loaded all the exported data into Access and did work in there.

Here's the just Fighter Aircraft Diffs:

Aircraft Type Base Hakko Ironman Iron-Dec41
=========================================
A6M2 Zero 249 357 478 +144
A5M4 Claude 171 174 189
Ki-27b Nate 518 518 493
Ki-43-Ia Oscar 24 24 49
Ki-43-Ib Oscar 32 80 80
=======================================
TOTALS 994 1153 1289 1433

The main diff for other planes is the Betty bumpup:
G4M1 Betty 157 277 277 +144

The biggest increase in ships is in DDs and Escorts, plus lots more Transports/Cargo. Think I may do the Ironman on Historical level of difficulty, and with all those new Escorts, may have to have Reliable USN Torps.




Hope you find it useful. Your garrison contributions to the original thread were the very first things to go into the spreadsheet (although they've since been modified since partisan action can longer damage industry). Some interesting observations on the differences between the Japanese starting forces in each scenario. I knew there was a big bump up in S-9, but was surprised to see that much of a delta between S-1 and S-2


quote:

ORIGINAL: ckk

Remarkable work. It got me started on AE


Really glad to hear that - it's one of the main reasons I developed the spreadsheet! It'll probably be a while until the next release, but a few things you'll see in the next version (which means "go ahead and do this now!"):

1) Move most of the Chinese air units from Chengtu to Chunking (not enough Aviation Support in Chengtu, plus it's only a size 1 A/F)

2) Doublecheck the transports and cargo TFs that are traveling to small bases. Only amphibous TFs can drop supply or troops into a base with a Size-0 port. You can switch Cargo TFs to amphibious at sea or even at destination, but not so with transports (apparently because the Strat Move troop mode is "transport only")

3) Get an AGP on the way to Jolo on the very first turn (you'll need it to keep your PT TFs fully stocked with torpedoes for use in the Phillipines)

(in reply to ckk)
Post #: 25
RE: Allies Set-up Spreadsheet for AE - 3/7/2010 5:00:58 AM   
morleron1


Posts: 112
Joined: 12/29/2006
Status: offline
I'm a newcomer to the world of WiTP-AE and this spreadsheet will be helpful in figuring out what to do on the 2nd day.  It will definitely take a while to study and figure out all of the interconnections with this, but I suspect it will be worthwhile.  Thanks for making this available.

_____________________________

Free men do not ask permission to bear arms.
GnuPG public key available at: pgp.mit.edu

(in reply to Kull)
Post #: 26
RE: Allies Set-up Spreadsheet for AE - 3/7/2010 3:16:00 PM   
sdevault


Posts: 141
Joined: 10/28/2008
Status: offline
Glad I found this gem! Thanks Kull.... I wish I had your time

(in reply to morleron1)
Post #: 27
RE: Allies Set-up Spreadsheet for AE - 3/10/2010 2:04:20 AM   
Kull


Posts: 1174
Joined: 7/3/2007
From: El Paso, TX
Status: offline
quote:

ORIGINAL: morleron1

I'm a newcomer to the world of WiTP-AE and this spreadsheet will be helpful in figuring out what to do on the 2nd day.  It will definitely take a while to study and figure out all of the interconnections with this, but I suspect it will be worthwhile.  Thanks for making this available.


quote:

ORIGINAL: sdevault

Glad I found this gem! Thanks Kull.... I wish I had your time


One reason I took the time is because I undertand so well how intimidating AE is to a new player. And it's such a great game, that it was worth it to me to do something that might help folks get started on their long, slow, journey up the "learning cliff". Everytime I hear the words, "this will really help", it just makes all the effort worthwhile!

Enjoy the ride!

(in reply to morleron1)
Post #: 28
RE: Allies Set-up Spreadsheet for AE - 3/10/2010 5:07:53 AM   
ckk

 

Posts: 1259
Joined: 10/18/2000
From: Pensacola Beach FL
Status: offline
Plus those of us that have been here since the getgo WIP-UV-WITP needed some encouragement to get into this new game which is much more accurate but much more harder to start appreciate the effort

(in reply to Kull)
Post #: 29
RE: Allies Set-up Spreadsheet for AE - 3/25/2010 12:27:23 PM   
Galahad78

 

Posts: 262
Joined: 9/28/2009
Status: offline
I'm just starting my first full blown campaign and was fighting with all the Search Arcs, Airgroups, etc. (still haven't done anything with LCUs, TFs or supplies, etc.) when I discovered this fantastic spreadsheet! I also was glad to discover (being a totally n00b to this game) that some of the decisions I took were the same as you suggest

Thanks a lot for the work mate!

(in reply to ckk)
Post #: 30
Page:   [1] 2 3 4   next >   >>
All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> The War Room >> Allies Set-up Spreadsheet for AE Page: [1] 2 3 4   next >   >>
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.172