Page 22 of 25

Re: Allies Set-up Spreadsheet for AE

Posted: Sun Aug 28, 2022 4:51 pm
by Rofar
Thanks for the answer. I kinda thought it might mean Assault Value but wasn't sure. Thanks for confirming.

Re: Allies Set-up Spreadsheet for AE

Posted: Sun Aug 28, 2022 5:03 pm
by RangerJoe
You are welcome.

QoL Enhancement for Allies Kull Spreadsheet: Base Forces

Posted: Sat Sep 24, 2022 5:14 pm
by Moltrey
Hey everyone:
I am posting a pic showing a small modification I made to my copy of Kull's Allies Spreadsheet regarding US Base Forces. I isn't hard to do on your own file.
Here is a pic of the Base Force example:
Image

So, I have found during my time learning WITP:AE that it can be confusing when you are trying to match the Base Force and Detachment units to game bases you intend on creating and/or expanding.
In order to more quickly see which units in the spreadsheet have the all-important Naval Support (Stevedores for loading/unloading, etc.) along with Air Support, I have gone through on column O and using the same tint of light green as the "Nav" on line 3 to designate the units in question in the US sections of the whole spreadsheet.

Why do this? Well, from experience, mobile Naval Support units are limited and vary in support type and amount, so one needs to plan which units to allocate on which missions. For instance, I tend to flip the original destinations as you can see in the pic under "comments" so that the 108th USN Base Force is tasked with going from Nome to Cold Bay and is one that doesn't have any Naval Support but it does have 6 Air Support. All I want it to do is support air squadrons at Cold Bay and (for my purposes) isn't going to be expanded into a major base.
Adak, on the other hand, is a forward future base that absolutely needs immediate Naval (and Air) Support to help with loading and unloading of supplies, men and equipment to establish a beachhead before the Japanese get wind of the operation and decide to spoil the show. The 106th USN Base Force with 50 Naval and 6 Air Support is just the unit I am looking for to do the job. Lack of Naval Support really slows down transfers and efficient use of transport ships. The faster you can turn around those transports, the faster the fledgling base will become strong enough to resist a strike.

As mentioned, it shouldn't take long to make the highlights in the appropriate Nav cells so you can tell at a glance when planning.
Hope this is helpful.

Re: Allies Set-up Spreadsheet for AE

Posted: Sun Dec 25, 2022 1:03 am
by jallison86
I'm an old (in all senses of the word :) ) WitP original version player who has finally decided it's time to give AE a proper go. This spreadsheet IS AMAZING. Absolute gold for someone like me who's overwhelmed with the number of units to deal with. Even coming from the original game, which was not small, it's a LOT to deal with. Having this spreadsheet not only gets you going on the right foot it's an incredible learning tool. Thank you!!

Re: Allies Set-up Spreadsheet for AE

Posted: Thu Dec 29, 2022 11:28 pm
by kaybayray
Kull <S> Sir !
What a fantastic set of documents you have created here my friend. 8-)

After many years of looking at this I finally picked it up with the new sale price. I am currently going over Tutorial videos, your documents, the Manual and checking out the Forums. I found your spreadsheets from one of the Tutorial video's by Strategy Gaming Dojo and have been going over it.

Thank you for all your hard and very detailed work!

Regards,
kaybayray

Re: Allies Set-up Spreadsheet for AE

Posted: Wed Feb 08, 2023 9:45 pm
by s96825
Thank you Kull for this amazingly helpful tool for this game!


I know it was asked a few years before but it sounded like the answer at the time was "no", so I thought I would ask again:

Is there any place to download a saved game or scenario where all the initial items are set per the checklist?

I am willing to accept the events of turn 1 (ie, did the Repulse sink, Y or N)


I have gone through a portion of this checklist now and have learned quite a bit. However, in the interest of time, it would be nice to have the option to start the game with the entire checklist completed.

Thanks

Re: Allies Set-up Spreadsheet for AE

Posted: Fri Feb 10, 2023 10:21 pm
by Moltrey
s96825:

To my knowledge no such setup savegame exists; perhaps someone else knows more?
Unfortunately Kull has been under the radar for almost a year on this board. He's fine, but I suppose has bigger fish to fry. So I don't see any changes likely.

It might be small solace, but I have found that going through the spreadsheet helps me learn my units and I end up making my own version with changes to Kull's original (for reasons like I pointed out in my post above here).
Typically it takes me a couple weeks or more to complete it if I am not on vacation!
Good luck.

Re: Allies Set-up Spreadsheet for AE

Posted: Sat Feb 11, 2023 5:31 pm
by BBfanboy
Part of the problem is that the Allied turn is done after the Japanese one, so any saved turn 1 would include whatever Japanese situation there was. That would negate the variability in the 13 versions of Scenario 1 (original game, not the one-off "update" that was done before the current revamp started). And if you are playing PBEM against an opponent I am not sure you can save both players' turn 1.

Re: Allies Set-up Spreadsheet for AE

Posted: Sat Feb 11, 2023 7:49 pm
by RangerJoe
Once you select the game scenario and start to play, the AI plans are set. A player can not save the setup and expect a different AI plan so it will play out the same way. Which is not necessarily a problem for learning but if you expect different AI targets, you will be disappointed.

Re: Allies Set-up Spreadsheet for AE

Posted: Fri Feb 17, 2023 2:31 am
by Nurn
I have owned this game for years, but only installed it a month ago. I am learning the game from your spreadsheet, Kull.

Many thanks, it is an excellent teaching tool.

Re: Allies Set-up Spreadsheet for AE

Posted: Sun Feb 19, 2023 8:46 pm
by Willderyes
jallison86 wrote: Sun Dec 25, 2022 1:03 am I'm an old (in all senses of the word :) ) WitP original version player who has finally decided it's time to give AE a proper go. This spreadsheet IS AMAZING. Absolute gold for someone like me who's overwhelmed with the number of units to deal with. Even coming from the original game, which was not small, it's a LOT to deal with. Having this spreadsheet not only gets you going on the right foot it's an incredible learning tool. Thank you!!
I'm old also, 75 to be exact. And like you, I played the original on what would be considered an ancient computer today. I am really excited about this spreadsheet Kull has made. I couldn't agree with you more on this spreadsheet.

Re: Allies Set-up Spreadsheet for AE

Posted: Thu Mar 09, 2023 10:54 pm
by Willderyes
Kull makes reference to "KB" a number of times in the comments section of her spreadsheet. Like move after KB leaves. Who or what is KB?

Re: Allies Set-up Spreadsheet for AE

Posted: Thu Mar 09, 2023 11:19 pm
by Platoonist
Willderyes wrote: Thu Mar 09, 2023 10:54 pm Kull makes reference to "KB" a number of times in the comments section of her spreadsheet. Like move after KB leaves. Who or what is KB?
KB is the Kido Butai or Mobile Force. It was the Japanese term used to designate the carrier fleet comprising most of the aircraft carriers and carrier air groups of the Imperial Japanese Navy during the first eight months of the Pacific War. So, basically Kull is referring to the carrier fleet that is poised to strike Pearl Harbor. For many Allied ship movements he advises you want to wait until the KB departs Hawaiian waters when it's safer to move without fear of air attack. In addition, the Japanese light carriers Ryujo, Zuiho and Hosho are often referred to as the mini-KB when in a group.

Re: Allies Set-up Spreadsheet for AE

Posted: Fri Mar 10, 2023 12:13 am
by RangerJoe
Willderyes wrote: Thu Mar 09, 2023 10:54 pm Kull makes reference to "KB" a number of times in the comments section of her spreadsheet. Like move after KB leaves. Who or what is KB?
BTW, I don't think that Kull is a "she."

Re: Allies Set-up Spreadsheet for AE

Posted: Fri Mar 10, 2023 3:18 am
by RADM.Yamaguchi
RangerJoe wrote: Fri Mar 10, 2023 12:13 am
Willderyes wrote: Thu Mar 09, 2023 10:54 pm Kull makes reference to "KB" a number of times in the comments section of her spreadsheet. Like move after KB leaves. Who or what is KB?
BTW, I don't think that Kull is a "she."
I always thought that there are a lot of very nice looking women playing this game based on some of the avatars.

Now RJ has to go and spoil it for me.

Re: Allies Set-up Spreadsheet for AE

Posted: Fri Mar 10, 2023 4:06 am
by RangerJoe
RADM.Yamaguchi wrote: Fri Mar 10, 2023 3:18 am
RangerJoe wrote: Fri Mar 10, 2023 12:13 am
Willderyes wrote: Thu Mar 09, 2023 10:54 pm Kull makes reference to "KB" a number of times in the comments section of her spreadsheet. Like move after KB leaves. Who or what is KB?
BTW, I don't think that Kull is a "she."
I always thought that there are a lot of very nice looking women playing this game based on some of the avatars.

Now RJ has to go and spoil it for me.
I used to have a lovely and deadly killer for my avatar. Look up Roza Shanina besides just this link:

https://en.wikipedia.org/wiki/Roza_Shanina

Then look more of this young lady . . .

https://www.warhistoryonline.com/guest- ... tvyak.html

Re: Allies Set-up Spreadsheet for AE

Posted: Wed Jun 14, 2023 2:51 pm
by draverros
Hello,

I am working my way through the spreadsheet and I got stuck at AM Cairns (I can't find an update/fix for this). Basically it tells me to create a soldiers transport and a tanker using MineSweepers. Can anyone confirm what the correct move here is?

Thanks

Re: Allies Set-up Spreadsheet for AE

Posted: Wed Jun 14, 2023 3:48 pm
by RangerJoe
Operator error? Not to be rude but those AMs are the escorts, if you look further down the list you will see the other ships included in the task force such as the TK British Motorist.

Re: Allies Set-up Spreadsheet for AE

Posted: Wed Jun 14, 2023 4:08 pm
by draverros
RangerJoe wrote: Wed Jun 14, 2023 3:48 pm Operator error? Not to be rude but those AMs are the escorts, if you look further down the list you will see the other ships included in the task force such as the TK British Motorist.
I see what I missed now, thanks - makes sense If I will look at the whole task force, not just the individual ship. I forgot to apply a filter to the comment section :)

Thank you!

Re: Allies Set-up Spreadsheet for AE

Posted: Wed Jun 14, 2023 5:06 pm
by RangerJoe
draverros wrote: Wed Jun 14, 2023 4:08 pm
RangerJoe wrote: Wed Jun 14, 2023 3:48 pm Operator error? Not to be rude but those AMs are the escorts, if you look further down the list you will see the other ships included in the task force such as the TK British Motorist.
I see what I missed now, thanks - makes sense If I will look at the whole task force, not just the individual ship. I forgot to apply a filter to the comment section :)

Thank you!
You are most welcome. We all make errors in this game - especially when learning!