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)Ĭol F: Unit Name - The name of each unit. Light Blue: Identifies all rows in which follow-on actions are required. Modified WitP AE Tracker data.Ĭol E: Type - There are five row "types": Bases, Air Groups, LCUs, Ships, and Industry. Modified WitP AE Tracker data.Ĭol D: Location Name - If the hex has a name (i.e. The Base & Industry data came from the WitP AE Tracker dataset (of which some was edited), and was manually extended to units.Ĭol C: Location - The hex location of every base, unit, and industry element. It's one way to work on your Turn 2 selections in "bite size chunks". 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).Ĭol B: Region - Every location on the map falls into one of 49 regions. Each column has a story:Ĭol A: Counter - This is the "row count". ( Note: The attachment below will always be updated to contain the most recent spreadsheet revision)ĪE Set-up (E).zip (1.94 MiB) Downloaded 5094 timesĪ picture is worth a thousand words, so here's what the AE-Allies Setup Spreadsheet looks like. If this sounds like your cup of tea, here's the plan to get you started: The top level objectives are as follows:ģ) Holding action in China (limited offensives, but mostly moving troops into defensible positions)Ĥ) US Carriers positioned to assault either Wake or the Marshallsĥ) Limited "Sir Robin" in DEI and Phillipines combined with aggressive SCTF activityĦ) Detailed network of Search & ASW planes at key locations (interlocking verified and tweaked)ħ) Almost all subs sent on patrol (with patrol zones detailed)Ĩ) Get convoys moving between the US and Pearl Harbor/Australia & Abadan/Aden/Capetown and Indiaĩ) Begin to establish a line of bases between the US and Australiaġ0) Preparations for building out the Aleutians Strategically, all unit movements and/or adjustments were made to support a fairly conservative Allied approach. 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. 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.ĥ) Also worth noting that this spreadsheet is designed for Scenarios 1 or 2. So that means this spreadsheet primarily is intended for those who:ġ) Play with PDU "off" (this doesn't matter much to the Allies, especially in the early game)Ģ) Play with Realistic R&D "on" (likewise not that important in the early game)ģ) Play against the AI (although most of the recommendations - China excepted - would still be pertinent against an inexperienced PBEM opponent).Ĥ) Game setting at Hard or Very Hard: This is required in order for the AI to function adequately. 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. 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. You also have a variety of "game play" options to consider. 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. I don't pretend to be a WitP Master, and my choices are certainly open to debate. So what this spreadsheet offers is a set of instructions for EVERY one of those 4653 individual elements. Needless to say, that is a daunting prospect. 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. 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. (The link in this post has been updated so it contains the new spreadsheet) For a more detailed list of the changes and improvements, see the "changelog" in Post #5 below. This will show ONLY the elements which have changed, making it much easier to edit your starting setup. 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". UPDATE : The revised AE-Allies Setup Spreadsheet has been uploaded (previous version "D" was released on and had over 2700 downloads).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |