RE: Allies Set-up Spreadsheet for AE

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

RE: Allies Set-up Spreadsheet for AE

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 >> The War Room >> RE: Allies Set-up Spreadsheet for AE

Page: << < prev 1 [2] 3 4 5 next > >>

Message

<< Older Topic Newer Topic >>

RE: Allies Set-up Spreadsheet for AE - 4/29/2010 9:12:34 AM

Galahad78

Posts: 386
Joined: 9/28/2009
Status: offline

Just a quick question as I'm afraid I've made a (yet another) mistake:

On Airgroup orders, when you say: ASW Patrol, Search: 20-60, Level: 50...

This Search arc is for ASW or for Naval Search? And the level refers to this Naval Search?

(in reply to Galahad78)

Post #: 31

RE: Allies Set-up Spreadsheet for AE - 5/12/2010 6:48:43 AM

Kull

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

Sorry I missed the question - hadn't been here for a few weeks. Anyway, I never assign ASW and Naval Search to the same units, so the description you cite means:

1) "ASW Patrol": Unit is on ASW, and all the descriptions that follow pertain to this mode
2) "Search: 20-60": The ASW Search arc for this unit
3) "Level: 50": My shorthand for the percentage of aircraft assigned to this mission

The only "mission sharing" I assign to aircraft is a combat mode of some sort plus training. In those cases you will see a "Level" listed for each mission type.

Edit: One major exception is Carrier Air. It's usually a good idea to have some of your Dauntlesses assigned to Naval Search (20% or so). The spreadsheet has several examples of this.

< Message edited by Kull -- 5/22/2010 11:43:26 PM >

(in reply to Galahad78)

Post #: 32

RE: Allies Set-up Spreadsheet for AE - 5/13/2010 8:47:26 AM

Cornstar

Posts: 14
Joined: 7/27/2008
Status: offline

Thanks a lot for the spreadsheet, it greatly helped me in starting a full game for the first time. Just by implementing your moves you learn the game and it's mechanics. Manuals can only tell that much. December 21st now, and I'm actually playing with some sense of what I'm supposed to do. Still a terrifying piece of game though :-).

Cheers, Martijn

(in reply to Kull)

Post #: 33

RE: Allies Set-up Spreadsheet for AE - 5/22/2010 11:44:37 PM

Kull

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

quote:

ORIGINAL: Cornstar

Thanks a lot for the spreadsheet, it greatly helped me in starting a full game for the first time. Just by implementing your moves you learn the game and it's mechanics. Manuals can only tell that much. December 21st now, and I'm actually playing with some sense of what I'm supposed to do. Still a terrifying piece of game though :-).

Cheers, Martijn

As always, glad to be of assistance. And yes, it really IS scary the first time you sit down and have to put all your units into motion on Day 2!

(in reply to Cornstar)

Post #: 34

RE: Allies Set-up Spreadsheet for AE - 6/20/2010 2:38:34 PM

SuluSea

Posts: 2358
Joined: 11/17/2006
Status: offline

Bump for the new comers to this game.

_____________________________

"There�s no such thing as a bitter person who keeps the bitterness to himself.� ~ Erwin Lutzer

(in reply to Kull)

Post #: 35

RE: Allies Set-up Spreadsheet for AE - 1/4/2011 10:34:26 PM

Kwik E Mart

Posts: 2447
Joined: 7/22/2004
Status: offline

curious if this app is up date with all the data base patches? guessing not, but may not make any difference...

_____________________________

Kirk Lazarus: I know who I am. I'm the dude playin' the dude, disguised as another dude!
Ron Swanson: Clear alcohols are for rich women on diets.

(in reply to SuluSea)

Post #: 36

RE: Allies Set-up Spreadsheet for AE - 2/12/2013 4:24:31 AM

Sorta

Posts: 189
Joined: 11/30/2009
Status: offline

Many thanks Kull for this just starting first full campaign. I was going to read the manual first but now I have this I wont. I believe in 'intuitiveness'!

(in reply to Kwik E Mart)

Post #: 37

RE: Allies Set-up Spreadsheet for AE - 2/14/2013 2:22:15 AM

Kull

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

quote:

ORIGINAL: Sorta

Many thanks Kull for this just starting first full campaign. I was going to read the manual first but now I have this I wont. I believe in 'intuitiveness'!

If I even hinted that this spreadsheet was a replacement for the Manual, Alfred would remove my head with a rusty hacksaw! I highly recommend that you do take a few hours and go through the manual - this game will consume vast quantities of time, so it's well worth a few on the front end to save far more on the back. Do that KNOWING that there's a wealth of detail and it's impossible to retain all (or even most) of it. However, once you begin following the spreadsheet's recommendations, some of that reading will come back to you in the form of "Ah! I seee why he's doing that!" And you'll get even more once you start playing. If anything, that first read through really helps your intuition!

One caveat on the spreadsheet. Most of the recommendations are still good, but in the aspect of air unit training, ignore the spreadsheet percentages and set your units at 100% trainig, 0 Range. The results will come faster that way.

_____________________________

AE-Japan Setup

AE-Allied Setup

Japan Air-Engine Plan

(in reply to Sorta)

Post #: 38

RE: Allies Set-up Spreadsheet for AE - 2/16/2013 1:53:56 AM

Alfred

Posts: 6685
Joined: 9/28/2006
Status: offline

quote:

ORIGINAL: Kull

If I even hinted that this spreadsheet was a replacement for the Manual, Alfred would remove my head with a rusty hacksaw...!

You would be lucky if I restricted myself to being so merciful as to use a hacksaw.

First you would be subjected to watching THAT movie in order to, ahem, learn the "true history" of what should have transpired. Only when you could repeat from memory every line of THAT movie from memory would we proceed to stage two.

Next you would be kept back at school to write out, in long hand, 100 times the entire AE manual. Any misspellings or inaccuracies would result in immediate decapitation using a fish knife.

Having successfully completed stage two, you would be required to compile the updated manual, incorporating all the changes introduced through the various patches. Once that was completed, your access to post in the forum would be reinstated.

Alfred

(in reply to Kull)

Post #: 39

RE: Allies Set-up Spreadsheet for AE - 2/16/2013 2:45:43 AM

PaxMondo

Posts: 9750
Joined: 6/6/2008
Status: offline

quote:

ORIGINAL: Alfred

... you would be required to compile the updated manual, incorporating all the changes introduced through the various patches. Once that was completed, your access to post in the forum would be reinstated.

Alfred

We need a volunteer for this one ...

_____________________________

Pax

(in reply to Alfred)

Post #: 40

RE: Allies Set-up Spreadsheet for AE - 2/16/2013 6:10:05 AM

Kull

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

quote:

ORIGINAL: Alfred

You would be lucky if I restricted myself to being so merciful as to use a hacksaw.

First you would be subjected to watching THAT movie in order to, ahem, learn the "true history" of what should have transpired. Only when you could repeat from memory every line of THAT movie from memory would we proceed to stage two.

Next you would be kept back at school to write out, in long hand, 100 times the entire AE manual. Any misspellings or inaccuracies would result in immediate decapitation using a fish knife.

Having successfully completed stage two, you would be required to compile the updated manual, incorporating all the changes introduced through the various patches. Once that was completed, your access to post in the forum would be reinstated.

Alfred

Hacksaw is startin' to look mighty appealing!

_____________________________

AE-Japan Setup

AE-Allied Setup

Japan Air-Engine Plan

(in reply to Alfred)

Post #: 41

RE: Allies Set-up Spreadsheet for AE - 4/12/2013 8:16:15 PM

98ZJUSMC

Posts: 44
Joined: 3/16/2013
Status: offline

Day 2 nightmare.

That's a good way to put it.

_____________________________

(in reply to Kull)

Post #: 42

RE: Allies Set-up Spreadsheet for AE - 6/26/2013 2:35:28 PM

Knucles2

Posts: 37
Joined: 1/8/2012
Status: offline

Hi Kull,
Thanx for the work you put into this lil gem :D I find myself almost looking forward to starting a new game :D. Still a lot of clicking ahead but at least I know I wont be screwing it up too badly.
One question- in the comments collum, where it says,"create cargo TF(#)-what is the # in quotes referring to?

Thanx again for this,
Bob S

(in reply to 98ZJUSMC)

Post #: 43

RE: Allies Set-up Spreadsheet for AE - 6/27/2013 2:51:57 AM

Kull

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

quote:

ORIGINAL: Knucles2

Hi Kull,
Thanx for the work you put into this lil gem :D I find myself almost looking forward to starting a new game :D. Still a lot of clicking ahead but at least I know I wont be screwing it up too badly.
One question- in the comments collum, where it says,"create cargo TF(#)-what is the # in quotes referring to?

Thanx again for this,
Bob S

Hi Bob - Hope this helps get you started with a little less agita!

As for the "TF#" designation, it's a way to easily distinguish which TF a given ship is supposed to join. For example, let's say you are creating TFs in Los Angeles. You filter location name to "Los Angeles", Type to "Ship", and (for example) Comments to "Create Tanker TF (1) etc". That will reduce the list to six Tankers and an AO. Now go into the LA port and and create the Tanker TF and add all seven of these ships and give them the mission listed in the rest of the Comments section (in this case, Dock, Load Fuel, Set destination to Pearl Harbor). Next do the same with "Create Cargo TF (2)", and rinse repeat until all TFs in that city have been created and and then move on to the next city. It really does help to have the game on one PC and the spreadsheet on another as you can really fly through the process without lots of toggling.

Any other questions, please feel free to ask. Regards, Kull

_____________________________

AE-Japan Setup

AE-Allied Setup

Japan Air-Engine Plan

(in reply to Knucles2)

Post #: 44

RE: Allies Set-up Spreadsheet for AE - 6/28/2013 12:10:58 AM

Knucles2

Posts: 37
Joined: 1/8/2012
Status: offline

Hi Kull,
OK, the TF(#) makes sense now :D I'm using this to set up a new game. Once I'm done I intend to protect the 'save' with deadly force if need be

Re; the second pc. Can't do it right now and my printer chose this week to go TU t'boot.

I'll click thru it somehow tho :D

Thanx again

Bob S

(in reply to Kull)

Post #: 45

RE: Allies Set-up Spreadsheet for AE - 6/28/2013 2:21:12 PM

Kull

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

When both applications are running on the same PC, the toggling is a little quicker if you have AE playing in "window mode". Also provides the option of having both apps on two monitors, even if using only one system. And yes, save often! Losing hours of changes to a system crash or power outtage - though rare - is teeth grindingly frustrating. Regards, Kull

_____________________________

AE-Japan Setup

AE-Allied Setup

Japan Air-Engine Plan

(in reply to Knucles2)

Post #: 46

RE: Allies Set-up Spreadsheet for AE - 11/13/2013 1:41:49 PM

BlitzimX

Posts: 190
Joined: 1/22/2013
Status: offline

Hello there Kull :)

Thanks for that awsome spreadheet i'm following to get a better set up of the first turn. I'm barely a quarter in but i have a question about something:

Among the first actions of the ships, you have some cargo leaving from Australia to Los Angeles, with a waypoint somewhere in the ocean. However, LA is much behond their fuel capacity (almost twice the amount). Will the problem be solved if we set a replenishment at sea, even if it's not precised, or is it something brought by a recent patch which reduced the cargos endurance?

Thanks!

< Message edited by BlitzX -- 11/13/2013 4:04:10 PM >

(in reply to Kull)

Post #: 47

RE: Allies Set-up Spreadsheet for AE - 11/13/2013 2:08:23 PM

nashvillen

Posts: 3836
Joined: 7/3/2006
From: Christiana, TN
Status: offline

Set the home port of those ships to LA, then, once you have a fuel CS TF set to keep fuel at Pearl, set the convoys assembled from those ships to waypoint Pearl with full refuel and sent them to Sydney that way.

_____________________________

(in reply to BlitzimX)

Post #: 48

RE: Allies Set-up Spreadsheet for AE - 11/14/2013 11:12:14 PM

Kull

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

quote:

ORIGINAL: BlitzX

Hello there Kull :)

Thanks for that awsome spreadheet i'm following to get a better set up of the first turn. I'm barely a quarter in but i have a question about something:

Among the first actions of the ships, you have some cargo leaving from Australia to Los Angeles, with a waypoint somewhere in the ocean. However, LA is much behond their fuel capacity (almost twice the amount). Will the problem be solved if we set a replenishment at sea, even if it's not precised, or is it something brought by a recent patch which reduced the cargos endurance?

Thanks!

Which port, and which ships? I pulled up an old start game and didn't notice any TFs that looked particularly problematic. If you are talking about some individual ships within a larger TF, the assumption would be that they'd refuel from the other ships with larger capacity (that's often true for long distance TFs that have escorts).

Edit: Pretty sure none of the official patches changed the individual ship fuel capacities, but if you are playing a game using the "Da Babes" mod, that might very well be true.

quote:

ORIGINAL: nashvillen

Set the home port of those ships to LA, then, once you have a fuel CS TF set to keep fuel at Pearl, set the convoys assembled from those ships to waypoint Pearl with full refuel and sent them to Sydney that way.

Unless absolutely necessary, the spreadsheet does not send TFs to/from Australia via Pearl Harbor, simply because it's surrounded by a nest of submarines. All things being equal (i.e no additional fuel consumption and ships that can make the full trip without refueling), I avoid the "Pearl"!

< Message edited by Kull -- 11/15/2013 12:15:31 AM >

_____________________________

AE-Japan Setup

AE-Allied Setup

Japan Air-Engine Plan

(in reply to BlitzimX)

Post #: 49

RE: Allies Set-up Spreadsheet for AE - 11/14/2013 11:47:08 PM

nashvillen

Posts: 3836
Joined: 7/3/2006
From: Christiana, TN
Status: offline

Kull has a point, after several months, though, the waters around Pearl will be less dense with Subs.

_____________________________

(in reply to Kull)

Post #: 50

RE: Allies Set-up Spreadsheet for AE - 11/15/2013 9:31:32 AM

BlitzimX

Posts: 190
Joined: 1/22/2013
Status: offline

Hi Kull :)

I'm talking about the Cargo TF created from Adelaide with the xAK Allara,xAK Dundula,xAK Iron Knob and xAK Michael Goulandris .

When i set them as you suggest, their range number is red, and when checking the fuel required it's almost double of their capacity. I haven't tried by setting Los Angeles as their base home though.

< Message edited by BlitzX -- 11/15/2013 10:31:56 AM >

(in reply to nashvillen)

Post #: 51

RE: Allies Set-up Spreadsheet for AE - 11/15/2013 12:05:40 PM

USSAmerica

Posts: 18715
Joined: 10/28/2002
From: Graham, NC, USA
Status: offline

quote:

ORIGINAL: BlitzX

Hi Kull :)

I'm talking about the Cargo TF created from Adelaide with the xAK Allara,xAK Dundula,xAK Iron Knob and xAK Michael Goulandris .

When i set them as you suggest, their range number is red, and when checking the fuel required it's almost double of their capacity. I haven't tried by setting Los Angeles as their base home though.

That should do it for you. The normal fuel required is for a round trip, but obviously would be half as much if you set the destination to be the new home port.

_____________________________

Mike

"Good times will set you free" - Jimmy Buffett

"They need more rum punch" - Me

Artwork by The Amazing Dixie

(in reply to BlitzimX)

Post #: 52

RE: Allies Set-up Spreadsheet for AE - 11/17/2013 3:41:06 PM

Kull

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

quote:

ORIGINAL: BlitzX

Hi Kull :)

I'm talking about the Cargo TF created from Adelaide with the xAK Allara,xAK Dundula,xAK Iron Knob and xAK Michael Goulandris .

When i set them as you suggest, their range number is red, and when checking the fuel required it's almost double of their capacity. I haven't tried by setting Los Angeles as their base home though.

As USS indicates, the one way trip is the way to go, as you'll definitely be refueling in the US. I have a revised version of the spreadsheet that clears up a lot of inconsistencies such as this, and eventually I'm planning to add some of the depth found in the Japan version. But I'm working on a non-AE game-mod project at the moment, so it may be a while before my time frees up and I can revisit this. In the meantime, the vast majority of the recommendations are exactly the same.

The spreadsheet is not a strategy intended to win the war, but just a way to help the new player get through the first few days and weeks without being completely inundated. Hopefully it reduces the initial "shock and awe" ("I have to make how many 1000's of adjustments to how many 1000's of units? Que WHAT!?") and buys you enough time to truly embrace the depth of this fantastic game.

_____________________________

AE-Japan Setup

AE-Allied Setup

Japan Air-Engine Plan

(in reply to BlitzimX)

Post #: 53

RE: Allies Set-up Spreadsheet for AE - 11/18/2013 5:45:27 PM

BlitzimX

Posts: 190
Joined: 1/22/2013
Status: offline

Indeed, it's a formidable tool. When do you plan to release that updated spreadsheet? :)

(in reply to Kull)

Post #: 54

RE: Allies Set-up Spreadsheet for AE - 11/21/2013 2:19:00 AM

Kull

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

quote:

ORIGINAL: BlitzX

Indeed, it's a formidable tool. When do you plan to release that updated spreadsheet? :)

It's probably going to be many months, so please don't wait for an update. There a few generic changes you should make - they are mentioned in this thread - but nothing earth-shatteringly-bad will happen to your game even if you use the current set-up exactly as-is. Again, the spreadsheet is just here to help you get started. All games diverge pretty rapidly from the opening setup, as each person chooses a strategy that appeals to them. Enjoy!

< Message edited by Kull -- 11/21/2013 3:20:37 AM >

_____________________________

AE-Japan Setup

AE-Allied Setup

Japan Air-Engine Plan

(in reply to BlitzimX)

Post #: 55

RE: Allies Set-up Spreadsheet for AE - 3/22/2014 7:46:52 PM

wegman58

Posts: 460
Joined: 12/28/2013
From: Edina, MN (FROM the Bronx)
Status: offline

I've been trying to download said spreadsheet and it gives me an .html file. Am I missing something?

(in reply to Kull)

Post #: 56

RE: Allies Set-up Spreadsheet for AE - 3/22/2014 8:39:57 PM

nashvillen

Posts: 3836
Joined: 7/3/2006
From: Christiana, TN
Status: offline

Left click on the "Attachment" and then left click on the link, it will be put in your downloads folder under a long funny looking name. To access that download folder click on the "Show all downloads". It will take you to where it is, you can then unzip it from there and give it a name you need to use.

_____________________________

(in reply to wegman58)

Post #: 57

RE: Allies Set-up Spreadsheet for AE - 3/22/2014 10:25:08 PM

wegman58

Posts: 460
Joined: 12/28/2013
From: Edina, MN (FROM the Bronx)
Status: offline

It was my bad - I have MAX Pop-up blocker settings. Works now!

(in reply to nashvillen)

Post #: 58

RE: Allies Set-up Spreadsheet for AE - 3/24/2014 5:21:20 AM

Kull

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

Hope it helps - any questions, feel free to ask.

_____________________________

AE-Japan Setup

AE-Allied Setup

Japan Air-Engine Plan

(in reply to wegman58)

Post #: 59

RE: Allies Set-up Spreadsheet for AE - 3/24/2014 3:28:36 PM

uncivil_servant

Posts: 200
Joined: 2/19/2013
Status: offline

I just wanted to say it was immensely helpful for my first time and I will definitely use it again. I would have remained slack-jawed if without it.

Some things - for convoys would it be helpful/possible to list recommended distance DD capacity? I am still in the game of which types of DD/DE do I assign to which type of convoy. i.e give this LA to Sydney convoy a (4500+) endurance DD when possible.

_____________________________

It is by caffeine alone I set my mind in motion,
It is by the beans of Java that thoughts acquire speed,
The hands acquire shaking, the shaking becomes a warning,
It is by caffeine alone I set my mind in motion.

(in reply to Kull)

Post #: 60