Allies Set-up Spreadsheet for AE

Share your gameplay tips, secret tactics and fabulous strategies with fellow gamers here.

Moderators: wdolson, MOD_War-in-the-Pacific-Admirals-Edition

User avatar
Gridley380
Posts: 464
Joined: Mon Dec 19, 2011 10:24 pm

RE: Allies Set-up Spreadsheet for AE

Post by Gridley380 »

ORIGINAL: Kull

For ships (and even air and LCUs) I'll often create 1-ship TFs back in LA or SF and put "reminders" in the TF title. The TF itself isn't going anywhere, but "looking at TFs in Port" is one of my standard processes, so it's a good way to ensure I remember things, plus it's a reminder system that exists entirely inside the game (rather than external notebooks or scraps of paper).

Good idea, I'm going to steal it. :-)
User avatar
Kull
Posts: 2744
Joined: Tue Jul 03, 2007 3:43 am
Location: El Paso, TX

RE: Allies Set-up Spreadsheet for AE

Post by Kull »

Hotkey & Credits Screen Swap:

(This was originally intended as a response to a thread in the main forum, but that one has a size and type limitation on attachments, whereas it will work here. Plus it's a useful feature that new players in particular may find helpful.)

One of the nice features of the chemkid map system is the "Credits" button (top right of the game GUI) now displays the "Hotkey" list. Meanwhile, the credits aren't lost, but are the last screen which displays when you load up a save game. I don't consider this switch to be a slap at the devs, since the player is going to see the credits MUCH more frequently this way.

Anyway, you can get the same result regardless of which map system you use, simply by downloading the 2 attached zips (this one and the one below) and copying the two files into your "War in the Pacific Admiral's Edition\ART" folder. I have to say, it's a real blessing to have the hotkey list so readily available!

This first file is the new "credits" screen (actually the hotkeys):
Attachments
Credits1024.zip
(860.94 KiB) Downloaded 52 times
User avatar
Kull
Posts: 2744
Joined: Tue Jul 03, 2007 3:43 am
Location: El Paso, TX

RE: Allies Set-up Spreadsheet for AE

Post by Kull »

And here is the second file (the credits, which will now appear in the game load screen):

Attachments
UV1024.zip
(1.07 MiB) Downloaded 33 times
Aksully
Posts: 98
Joined: Tue Feb 16, 2016 9:45 pm

RE: Allies Set-up Spreadsheet for AE

Post by Aksully »

ORIGINAL: Kull

And here is the second file (the credits, which will now appear in the game load screen):


Thanks Kull this is great! A couple of questions for you if you don't mind?
First in your experience against the AI is it better to put most of your forces in Manila or Bataan?

Second, I must be blind but I can't find a list of terrain defense bonuses? This applies to the above question of is it better to defend in Urban Light or Jungle? Thx!
Schorsch
Posts: 81
Joined: Mon Jan 25, 2010 2:51 pm
Location: Germany

RE: Allies Set-up Spreadsheet for AE

Post by Schorsch »

page 189 in the manual (8.3.1) has the terrainmodifiers
User avatar
jdsrae
Posts: 2795
Joined: Mon Mar 01, 2010 6:58 am
Location: Gandangara Country

RE: Allies Set-up Spreadsheet for AE

Post by jdsrae »

ORIGINAL: Aksully

ORIGINAL: Kull

And here is the second file (the credits, which will now appear in the game load screen):


Thanks Kull this is great! A couple of questions for you if you don't mind?
First in your experience against the AI is it better to put most of your forces in Manila or Bataan?

Second, I must be blind but I can't find a list of terrain defense bonuses? This applies to the above question of is it better to defend in Urban Light or Jungle? Thx!

Also look at Clark Field which I believe is Jungle Rough. Do not give that hex up without a fight.
I’m no expert, but I’d prioritise Clark/Bataan over Manila but still leave enough at Manila to give anything less than a fully formed IJA Division a bloody nose.
Once you see what IJA lands where, and with a bit of recon, you may have time to adjust.
Currently playing my first PBEM, no house rules Scenario 1 as IJ.
AAR link (no SolInvictus): https://www.matrixgames.com/forums/tm.asp?m=4684655
User avatar
rustysi
Posts: 7472
Joined: Tue Feb 21, 2012 3:23 am
Location: LI, NY

RE: Allies Set-up Spreadsheet for AE

Post by rustysi »

First in your experience against the AI is it better to put most of your forces in Manila or Bataan?

Neither.
is it better to defend in Urban Light or Jungle?

Both are the same, x2.

The above being said, Clark is jungle rough, which equates to x3 terrain.

So I'd say your best defense, at least in scen1 on a standard map, is to defend Clark/Bataan. This is because Bataan controls the CD's guns that in turn control the approaches not only to herself, but to Clark and Manila as well. While its true you get some supply form Manilas' LI, its not a whole lot. Additionally if Japan doesn't change anything she has only ~2.5 divisions to conquer Luzon, and provide a garrison for Manila. That's a pretty steep pair of objectives for such a small force given the terrain they must overcome.

Being a JFB, that's my humble opinion. Of course as usual, YMMV.[:)]

It is seldom that liberty of any kind is lost all at once. Hume

In every party there is one member who by his all-too-devout pronouncement of the party principles provokes the others to apostasy. Nietzsche

Cave ab homine unius libri. Ltn Prvb
User avatar
Kull
Posts: 2744
Joined: Tue Jul 03, 2007 3:43 am
Location: El Paso, TX

RE: Allies Set-up Spreadsheet for AE

Post by Kull »

ORIGINAL: jdsrae

Also look at Clark Field which I believe is Jungle Rough. Do not give that hex up without a fight.
I’m no expert, but I’d prioritise Clark/Bataan over Manila but still leave enough at Manila to give anything less than a fully formed IJA Division a bloody nose.
Once you see what IJA lands where, and with a bit of recon, you may have time to adjust.

+1

Against the AI (always that qualifier), I leave a few PA units in Manila so it isn't a walkover, but the real defense is at Clark and Bataan. 4th Marines are the toughest unit, and the one that can ensure a longer siege in Bataan, so they always go there, along with enough Eng units to build the defenses as high as possible. The real problem with sticking all your units in Bataan is they eat a lot of supply AND the Japs will soon bomb your surplus supply down to nothing. So spread things out a bit to make that harder to do, for a while anyway.

ORIGINAL: Schorsch

page 189 in the manual (8.3.1) has the terrainmodifiers

Correct, thanks. Worth noting that the Bellum Pacifica map places this table in the top right of the map (instead of the terrain-type pictorial. Very helpful to have that information readily visible:


Image
Attachments
BellumPacificum.jpg
BellumPacificum.jpg (164.41 KiB) Viewed 849 times
User avatar
rustysi
Posts: 7472
Joined: Tue Feb 21, 2012 3:23 am
Location: LI, NY

RE: Allies Set-up Spreadsheet for AE

Post by rustysi »

Worth noting that the Bellum Pacifica map places this table in the top right of the map

Is that a 'standard' type map otherwise?
It is seldom that liberty of any kind is lost all at once. Hume

In every party there is one member who by his all-too-devout pronouncement of the party principles provokes the others to apostasy. Nietzsche

Cave ab homine unius libri. Ltn Prvb
Schorsch
Posts: 81
Joined: Mon Jan 25, 2010 2:51 pm
Location: Germany

RE: Allies Set-up Spreadsheet for AE

Post by Schorsch »

same goes for the topo map project btw ;)
User avatar
Kull
Posts: 2744
Joined: Tue Jul 03, 2007 3:43 am
Location: El Paso, TX

RE: Allies Set-up Spreadsheet for AE

Post by Kull »

ORIGINAL: rustysi
Worth noting that the Bellum Pacifica map places this table in the top right of the map

Is that a 'standard' type map otherwise?

Yes it is. Large Slow Target highly recommended it (as have others) as a good compromise that features both beauty and clear delineation of terrain types (the primary fault of the otherwise wonderful chemkid offerings).
User avatar
rustysi
Posts: 7472
Joined: Tue Feb 21, 2012 3:23 am
Location: LI, NY

RE: Allies Set-up Spreadsheet for AE

Post by rustysi »

Thanks. Any idea where I may view and then down load?

And yes, I like chemkids' maps, but they seemed to 'blur' some map features. Like the shallow ocean hexes, at least to my old eyes.
It is seldom that liberty of any kind is lost all at once. Hume

In every party there is one member who by his all-too-devout pronouncement of the party principles provokes the others to apostasy. Nietzsche

Cave ab homine unius libri. Ltn Prvb
User avatar
Kull
Posts: 2744
Joined: Tue Jul 03, 2007 3:43 am
Location: El Paso, TX

RE: Allies Set-up Spreadsheet for AE

Post by Kull »

ORIGINAL: rustysi

Thanks. Any idea where I may view and then down load?

And yes, I like chemkids' maps, but they seemed to 'blur' some map features. Like the shallow ocean hexes, at least to my old eyes.

The link to MakeeLearn's thread was in my earlier post:

Bellum Pacifica
Aksully
Posts: 98
Joined: Tue Feb 16, 2016 9:45 pm

RE: Allies Set-up Spreadsheet for AE

Post by Aksully »

ORIGINAL: Schorsch

page 189 in the manual (8.3.1) has the terrainmodifiers
Found it in my manual on page 186 8.3.1 Overland Movement! Duh. I was looking in the index for Terrain Modifiers! Silly me. Thx!
Aksully
Posts: 98
Joined: Tue Feb 16, 2016 9:45 pm

RE: Allies Set-up Spreadsheet for AE

Post by Aksully »

ORIGINAL: Schorsch

page 189 in the manual (8.3.1) has the terrainmodifiers
Thx Schorsch! Found it on page 186 Overland Movement. I'm a logical guy so not the heading I thought I'd find it under! :)
Aksully
Posts: 98
Joined: Tue Feb 16, 2016 9:45 pm

RE: Allies Set-up Spreadsheet for AE

Post by Aksully »

ORIGINAL: jdsrae

ORIGINAL: Aksully

ORIGINAL: Kull

And here is the second file (the credits, which will now appear in the game load screen):


Thanks Kull this is great! A couple of questions for you if you don't mind?
First in your experience against the AI is it better to put most of your forces in Manila or Bataan?

Second, I must be blind but I can't find a list of terrain defense bonuses? This applies to the above question of is it better to defend in Urban Light or Jungle? Thx!

Also look at Clark Field which I believe is Jungle Rough. Do not give that hex up without a fight.
I’m no expert, but I’d prioritise Clark/Bataan over Manila but still leave enough at Manila to give anything less than a fully formed IJA Division a bloody nose.
Once you see what IJA lands where, and with a bit of recon, you may have time to adjust.

Thank you JD for this. I think I'll plan for a defensive line like you suggest here which seems to coincide with Kull's SS. Then I'll adjust as results dictate. Much appreciated! :)
Aksully
Posts: 98
Joined: Tue Feb 16, 2016 9:45 pm

RE: Allies Set-up Spreadsheet for AE

Post by Aksully »

ORIGINAL: Kull

ORIGINAL: jdsrae

Also look at Clark Field which I believe is Jungle Rough. Do not give that hex up without a fight.
I’m no expert, but I’d prioritise Clark/Bataan over Manila but still leave enough at Manila to give anything less than a fully formed IJA Division a bloody nose.
Once you see what IJA lands where, and with a bit of recon, you may have time to adjust.

+1

Against the AI (always that qualifier), I leave a few PA units in Manila so it isn't a walkover, but the real defense is at Clark and Bataan. 4th Marines are the toughest unit, and the one that can ensure a longer siege in Bataan, so they always go there, along with enough Eng units to build the defenses as high as possible. The real problem with sticking all your units in Bataan is they eat a lot of supply AND the Japs will soon bomb your surplus supply down to nothing. So spread things out a bit to make that harder to do, for a while anyway.

ORIGINAL: Schorsch

page 189 in the manual (8.3.1) has the terrainmodifiers

Correct, thanks. Worth noting that the Bellum Pacifica map places this table in the top right of the map (instead of the terrain-type pictorial. Very helpful to have that information readily visible:


Image
I was debating on loading this Map. But I've got the info and you all have been a big help with my question. Thanks again!
Aksully
Posts: 98
Joined: Tue Feb 16, 2016 9:45 pm

RE: Allies Set-up Spreadsheet for AE

Post by Aksully »

ORIGINAL: rustysi
First in your experience against the AI is it better to put most of your forces in Manila or Bataan?

Neither.
is it better to defend in Urban Light or Jungle?

Both are the same, x2.

The above being said, Clark is jungle rough, which equates to x3 terrain.

So I'd say your best defense, at least in scen1 on a standard map, is to defend Clark/Bataan. This is because Bataan controls the CD's guns that in turn control the approaches not only to herself, but to Clark and Manila as well. While its true you get some supply form Manilas' LI, its not a whole lot. Additionally if Japan doesn't change anything she has only ~2.5 divisions to conquer Luzon, and provide a garrison for Manila. That's a pretty steep pair of objectives for such a small force given the terrain they must overcome.

Being a JFB, that's my humble opinion. Of course as usual, YMMV.[:)]

Thanks Rusty for your input! It's not a humble opinion, but one based on knowledge of the game and it's mechanics. That's what I lack so again...Thx!
User avatar
Steven545
Posts: 4
Joined: Sat Oct 03, 2015 3:43 pm

RE: Allies Set-up Spreadsheet for AE

Post by Steven545 »

Just downloaded your spreadsheet, it looks the dogs,lol.
I've been trying to get into a campaign game for months but always have up after an hour or so due too overwhelming feeling of hopelessness. So tonight I'm going to finally over come my fear lol.
Thanks for all your hard work
User avatar
Kull
Posts: 2744
Joined: Tue Jul 03, 2007 3:43 am
Location: El Paso, TX

RE: Allies Set-up Spreadsheet for AE

Post by Kull »

ORIGINAL: Steven545

Just downloaded your spreadsheet, it looks the dogs,lol.
I've been trying to get into a campaign game for months but always have up after an hour or so due too overwhelming feeling of hopelessness. So tonight I'm going to finally over come my fear lol.
Thanks for all your hard work

Happy to help, and good for you! Even now, 10 years later, I can still remember that feeling! Feel free to ask any questions, but keep in mind that it's easy to get bogged down in the minutuae. If something isn't immediately clear, just make your best guess (or highlighlight the row as something to revisit later) and just keep going. This literally takes days of human time to finish, but the good news is that you will figure out a LOT in the process. Which is really the main idea.

And the turns that follow will be infinitely easier, if for no other reason than you have most of the balls rolling so there's far less to do!
Post Reply

Return to “The War Room”