Japan Set-up Spreadsheet for AE
Moderators: wdolson, MOD_War-in-the-Pacific-Admirals-Edition
RE: Japan Set-up Spreadsheet for AE
still see no indication of the 2nd div at all, together or broken up .....
I must be having a senior moment
I must be having a senior moment
- Shellshock
- Posts: 576
- Joined: Fri Dec 31, 2010 2:23 pm
- Location: U.S.
RE: Japan Set-up Spreadsheet for AE
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.

- Attachments
-
- Sendaiarea.jpg (55.44 KiB) Viewed 2312 times
RE: Japan Set-up Spreadsheet for AE
see them now .... thanks ....
RE: Japan Set-up Spreadsheet for AE
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.
Thanks in advance.
RE: Japan Set-up Spreadsheet for AE
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!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
; Julia Child

I'm not a complete idiot, some parts are missing!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
- PharaohVirgoCompy
- Posts: 55
- Joined: Wed Mar 02, 2022 4:52 pm
Re: Japan Set-up Spreadsheet for AE
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)
Re: Japan Set-up Spreadsheet for AE
Well, go through the steps again. If it doesn't work, post a picture and exactly what you do.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?
Seek peace but keep your gun handy.
I'm not a complete idiot, some parts are missing!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
; Julia Child

I'm not a complete idiot, some parts are missing!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
- PharaohVirgoCompy
- Posts: 55
- Joined: Wed Mar 02, 2022 4:52 pm
Re: Japan Set-up Spreadsheet for AE
Post a picture of what?
VirgoShelter (I can't figure out how to change my username so this works I guess)
Re: Japan Set-up Spreadsheet for AE
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!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
; Julia Child

I'm not a complete idiot, some parts are missing!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
- PharaohVirgoCompy
- Posts: 55
- Joined: Wed Mar 02, 2022 4:52 pm
Re: Japan Set-up Spreadsheet for AE

Not sure how this would help but ok
VirgoShelter (I can't figure out how to change my username so this works I guess)
Re: Japan Set-up Spreadsheet for AE
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!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
; Julia Child

I'm not a complete idiot, some parts are missing!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
Re: Japan Set-up Spreadsheet for AE
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).
Re: Japan Set-up Spreadsheet for AE
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
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.
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"
Re: Japan Set-up Spreadsheet for AE
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
Re: Japan Set-up Spreadsheet for AE
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!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”
; Julia Child

I'm not a complete idiot, some parts are missing!
“Illegitemus non carborundum est (“Don’t let the bastards grind you down”).”



