Japan 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
scout1
Posts: 3124
Joined: Mon Aug 23, 2004 11:26 pm
Location: South Bend, In

RE: Japan Set-up Spreadsheet for AE

Post by scout1 »

still see no indication of the 2nd div at all, together or broken up .....

I must be having a senior moment
User avatar
Shellshock
Posts: 576
Joined: Fri Dec 31, 2010 2:23 pm
Location: U.S.

RE: Japan Set-up Spreadsheet for AE

Post by Shellshock »

ORIGINAL: scout1

still see no indication of the 2nd div at all, together or broken up .....

I must be having a senior moment

Try looking in the Sendai area in northeastern Japan. The components of the 2nd division are in the city of Sendai and the adjacent city of Iwaki and some are on board ships.(Task force 124) They won't be the full 2nd Division again until such times as they are all in one location and reunited.

Image
Attachments
Sendaiarea.jpg
Sendaiarea.jpg (55.44 KiB) Viewed 2311 times
User avatar
scout1
Posts: 3124
Joined: Mon Aug 23, 2004 11:26 pm
Location: South Bend, In

RE: Japan Set-up Spreadsheet for AE

Post by scout1 »

see them now .... thanks ....
User avatar
pbiggar
Posts: 151
Joined: Sat Aug 31, 2002 3:51 am
Location: Surrey, BC, Canada

RE: Japan Set-up Spreadsheet for AE

Post by pbiggar »

I am going to give Japan a try against the AI as a learning experience. I was wondering if there is a post with a save file of Day2 with all of these moves already input. This looks likes 20 hours of input on Day 2 which I would like to avoid if possible.

Thanks in advance.
User avatar
RangerJoe
Posts: 19549
Joined: Mon Nov 16, 2015 2:39 pm
Location: Who knows?

RE: Japan Set-up Spreadsheet for AE

Post by RangerJoe »

ORIGINAL: pbiggar

I am going to give Japan a try against the AI as a learning experience. I was wondering if there is a post with a save file of Day2 with all of these moves already input. This looks likes 20 hours of input on Day 2 which I would like to avoid if possible.

Thanks in advance.

You do not have to do it all at once but you need to do it. Save frequently. Decide when airframes that you want to research but you don't have to fix all of the factories on the first day. The second or third day will also work fine. Then, since you know what engines that you will need, you can fix those as well. You don't have to turn off ships that you will not need right away, you can wait until the fourth day. You can move the merchant ships the first day to the ports where they will be needed right away, then you can start your CS convoys. You can then do ship conversions when the ships make it to a proper port and are empty.

You may want to expand the LI and the port at Fusan (Korean War Pusan) to increase the Resource demand there to get them there for shipment to the mainland. Increase the ports on Hokkaido and the Honshu for the resource convoys there. As well as the port on Hokkaido for the resource and oil convoys from Sahklin (sp?).

You may also want to expand vehicle factories as well as converting an armaments factory to vehicle production. You might want to slowly expand HI as well. I suggest either the main cities on Honshu which you will defend very heavily, any city on the Home Islands with little to no manpower to have Firestorms. I would also expand the HI in Manchuria and Northern China as well - do so 10 points at a time. If you expand there, you will need to move supplies to Fusan to support these expansions.

You will also need to set your supply demand to support any industrial expansion and/or conversions - it does not make sense to expand it, not have the supply there, then wonder why the expansion is not being done. [8|]
Seek peace but keep your gun handy.

I'm not a complete idiot, some parts are missing! :o

“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
:twisted: ; Julia Child


Image
User avatar
PharaohVirgoCompy
Posts: 55
Joined: Wed Mar 02, 2022 4:52 pm

Re: Japan Set-up Spreadsheet for AE

Post by PharaohVirgoCompy »

When trying to resize Zuiho's airgroups it won't work despite following the intrusions, is there something else I need to do?
VirgoShelter (I can't figure out how to change my username so this works I guess)
User avatar
RangerJoe
Posts: 19549
Joined: Mon Nov 16, 2015 2:39 pm
Location: Who knows?

Re: Japan Set-up Spreadsheet for AE

Post by RangerJoe »

PharaohVirgoCompy wrote: Wed Nov 26, 2025 9:17 pm When trying to resize Zuiho's airgroups it won't work despite following the intrusions, is there something else I need to do?
Well, go through the steps again. If it doesn't work, post a picture and exactly what you do.
Seek peace but keep your gun handy.

I'm not a complete idiot, some parts are missing! :o

“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
:twisted: ; Julia Child


Image
User avatar
PharaohVirgoCompy
Posts: 55
Joined: Wed Mar 02, 2022 4:52 pm

Re: Japan Set-up Spreadsheet for AE

Post by PharaohVirgoCompy »

Post a picture of what?
VirgoShelter (I can't figure out how to change my username so this works I guess)
User avatar
RangerJoe
Posts: 19549
Joined: Mon Nov 16, 2015 2:39 pm
Location: Who knows?

Re: Japan Set-up Spreadsheet for AE

Post by RangerJoe »

PharaohVirgoCompy wrote: Thu Nov 27, 2025 10:40 pm Post a picture of what?
The carrier and the air unit.

When you have a problem, please post a picture or pictures when you ask a question. Sometimes someone else can see the solution to the problem.
Seek peace but keep your gun handy.

I'm not a complete idiot, some parts are missing! :o

“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
:twisted: ; Julia Child


Image
User avatar
PharaohVirgoCompy
Posts: 55
Joined: Wed Mar 02, 2022 4:52 pm

Re: Japan Set-up Spreadsheet for AE

Post by PharaohVirgoCompy »

Image
Not sure how this would help but ok
VirgoShelter (I can't figure out how to change my username so this works I guess)
User avatar
RangerJoe
Posts: 19549
Joined: Mon Nov 16, 2015 2:39 pm
Location: Who knows?

Re: Japan Set-up Spreadsheet for AE

Post by RangerJoe »

PharaohVirgoCompy wrote: Fri Nov 28, 2025 1:44 am Image
Not sure how this would help but ok
There can be no other air units on the Zuiho. The capacity is limited to 115% of listed capacity, any higher than that and the aircraft can only fly off but not return. You have to disband the aircraft carrier into a port and then reform it into an aircraft carrier task force. The same goes for the CS. Or wait until the next turn and the air unit should resize itself by then.
Seek peace but keep your gun handy.

I'm not a complete idiot, some parts are missing! :o

“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
:twisted: ; Julia Child


Image
sfatula
Posts: 154
Joined: Mon Sep 07, 2015 9:17 pm
Location: Calera, OK
Contact:

Re: Japan Set-up Spreadsheet for AE

Post by sfatula »

I have a question regarding Kulls Japan spreadsheet and restricted units. I see that there are a few HQ (col G) LCUs listed as "code 2", i.e., implying the LCU can switch it's own HQ with the expenditure of PP according to the spreadsheet comments. My question is why is the LCU HQ "Western Army" itself listed as a code 2? It's implying to me that the western army hq lcu can switch away from the general defence army? I don't get the code 2 for this unit (and a couple others).
User avatar
BBfanboy
Posts: 20706
Joined: Wed Aug 04, 2010 5:36 pm
Location: Winnipeg, MB
Contact:

Re: Japan Set-up Spreadsheet for AE

Post by BBfanboy »

My guess is that Western Command includes islands so the HQ must be able to travel by ship. That does not mean the sub-HQs and units are all unrestricted.
No matter how bad a situation is, you can always make it worse. - Chris Hadfield : An Astronaut's Guide To Life On Earth
ADB_Iceman
Posts: 117
Joined: Thu Sep 19, 2019 6:07 pm

Re: Japan Set-up Spreadsheet for AE

Post by ADB_Iceman »

I thought I would post that the latest Beta (at least) might change some of the decisions in the Japan Set Up.

For example, I do not know when this change was made but the connection between Kyushu and Honshu is severed between hex 104,58 and Shimonoseki the latest beta. This divides Japan into 4 separate micro economies. In the latest beta (at least) Kyushu has an excess of resources to light and heavy industry of 21,600 resource points per turn. Honshu has a deficit of 109,400 per turn. This has some ramifications on setting up convoys and excess will accumulate at Nagasaki.

Certainly small convoys can be set up to transfer excess to Honshu.

Likewise, at some revision China is further divided into sub-regions by blocking the bridges at Pengpu. The Allied scripts have changed a bit because Foochow is now Chinese and units come from "nowhere" to attack Amoy.

Just a a thought, Playing the Allied scripts 4 times to turn 100 I found the new scripts?/code changes? makes Singapore a tougher nut to crack that might be a counter to the early invasion of Port Moresby using the 4th and 33rd divisions. Others might have a different experience with the latest beta, but I found the IJA gets remarkably delayed and attritioned in the Singapore campaign without these forces.
AKA "Crackaces"
User avatar
BBfanboy
Posts: 20706
Joined: Wed Aug 04, 2010 5:36 pm
Location: Winnipeg, MB
Contact:

Re: Japan Set-up Spreadsheet for AE

Post by BBfanboy »

I don't agree with the severing of Kyushu from Honshu. With that much need for communication between them, there would have been railroad and vehicle/personnel ferries running continuously - in effect a bridge. Perhaps it could be shown as a secondary road to slow the flow a bit, but the flow should be there.
No matter how bad a situation is, you can always make it worse. - Chris Hadfield : An Astronaut's Guide To Life On Earth
User avatar
RangerJoe
Posts: 19549
Joined: Mon Nov 16, 2015 2:39 pm
Location: Who knows?

Re: Japan Set-up Spreadsheet for AE

Post by RangerJoe »

Actually, only Hokkaido is separated from the other 3 main Home Islands. While the direct links for unit movement are removed, this does not hinder the movement of the industrial inputs and outputs. With the bridges out in China, this does make river transportation of units somewhat more important than using the now broken rail lines.
Seek peace but keep your gun handy.

I'm not a complete idiot, some parts are missing! :o

“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
:twisted: ; Julia Child


Image
Post Reply

Return to “The War Room”