Page 1 of 1
Excel file listing all ressources of the map, Scenario 15
Posted: Sat Jul 17, 2004 3:31 pm
by AmiralLaurent
Before designing my long-term strategy and industry changes for my first big IJN game (secen 15), I listed in a file all ressources (manpower, HI, oil, ressources) and factories on the map on 7th Dec 1941.
I sent the Excel file to Spooky, so hope it will be available on his site in the future.
The Japanese Empire starts with:
781 manpower
13240 heavy industry
750 oil..... you see the problem ?
12120 ressources
1174 naval shipyard
1000 merchant shipyard
535 repair yard
678 aircraft assemby
1521 aircraft engine
501 armament assembly
90 AFW assembly
And Allied side owns (for a more or less long time):
530 manpower
11400 heavy industry
3425 oil
24310 ressources
860 repair yard
1240 aircraft assembly
That is including USA, Soviet Union, Australia, New Zealand and India. Without those areas (but with all China), you can hope to seize in your first move:
91 manpower (most of them Chinese)
1605 heavy industry
2225 oil
8250 ressources
100 repair yard (Singapore & Hong Kong)
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Sat Jul 17, 2004 5:21 pm
by AmiralLaurent
Excel file will be modified to include the fact that bases are port or not (so they may create fuel or not).
I promize I had read the manual before.... but not with enough attention, OK, OK.
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Sat Jul 17, 2004 6:19 pm
by brisd
Thanks Admiral, this will be a huge help with planning the Japanese economy and conquest targets! [8D]
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Sat Jul 17, 2004 6:24 pm
by Spooky
The file is now available in the WITP Fansite !
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Sat Jul 17, 2004 7:04 pm
by AmiralLaurent
I just have a new version with a formula page to try to manage the economy of the Rising Sun Empire.
Assuming that all ressources and oil are in place so all manpower centers and factories produce (magic world, so situation should be actually worse in reality), the Empire (if I'm right in my calculation) :
_ loses 5900 ressource points each day
_ loses 8740 oil points each day
_ generates 25360 supply points each day
_ generates 15530 fuel points each day
_ generates 1298 heavy industry points each day (production less expenses)
_ generates 3905 manpower points each day
_ builds 15 single-engine, 7 2-engine and 0.33 4-engine plane each day
_ creates 50.7 aircraft engine each day (and needs 30 for planes really built)
_ generates 501 armament point
_ generates 90 vehicle points
_ generates 1174 naval ship points
_ generates 1000 merchant ship points
At first sight, the fact that there is an extra production in engine and heavy industry points allows to increase plane production.
Another notice, there is a huge manpower creation but each manpower point should be combined with an armament or a vehicle point to be really used, so this is a waste of ressources until you build more armament factories. And at the start stocks are 100 000 manpower, 20 000 armament and 0 vehicle.
(edited) I just sent to Spooky the new Excel file and a word file explaining my formulas (coming from the manual).
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Sat Jul 17, 2004 9:10 pm
by Spooky
The new version is now available at the WITP Fansite [:)]
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Sun Jul 18, 2004 4:36 am
by Spectra
Hi There,
I'm worried about Japan's Armament shortage... I've done a couple of trial tests, and it seems that Japan doesn't have anywhere near enough armament prodcution to equip her army.... Just in the first 60 days alone, the 20,000 points at the start are exhausted, including all new production... I'm roughtly estimated that to stay above 0, you'd need closer to 1500 armaments production, and you can't build that much that quickly anyway...
In these calculations, I'm ignoring vechicle production (its pretty small, and there aren't a lot of groups at the start which need them). Since you spend 1 Manpower, and 1 Armament point per load value of a unit, just looking at the load values for future military units gives an excellent approximation to your needs. And the base forces that require ~4600 load points to build are very expensive... Am I doing this correctly??
I also noticed during the game that Manpower producution (4 per 10 resources, for each Manpower production center) seems correct, but they seem to be getting used up at twice the rate of armament production.
Anyway, I'm worried... If you want to have 300 Reppu fighters on your carriers by Mar 1944 (to deal with Hellcats & Corsairs), you need to advance the production date by 18 months. With 100 planes of research, this means you have to start the research project by June 1942... Its more fun to plan out future aircraft & ship production, but if my armaments production needs to triple just to equip my army, I'm skeptical it can be done..
Any confirmations, or thoughts???
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Sun Jul 18, 2004 9:10 am
by Apollo11
Hi all,
Many many thanks for GREAT XLS and DOC regarding WitP production!
Leo "Apollo11"
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Mon Jul 19, 2004 8:16 pm
by Oznoyng
ORIGINAL: Spectra
Anyway, I'm worried... If you want to have 300 Reppu fighters on your carriers by Mar 1944 (to deal with Hellcats & Corsairs), you need to advance the production date by 18 months. With 100 planes of research, this means you have to start the research project by June 1942... Its more fun to plan out future aircraft & ship production, but if my armaments production needs to triple just to equip my army, I'm skeptical it can be done..
From all reports, you will be likely to advance the Reppu by a few months at best. Mar 44 just ain't happening from what I have read.
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Mon Jul 19, 2004 8:38 pm
by Oznoyng
I don't know if you can, but if halting Manpower production is a possibility, sounds like you would want to halt like 75% of it. With 781 Manpower centers, if you could halt around 550 of them, you would reduce your resource leakage by 5500 per day and eliminate one hell of a lot of shipping of resources into the Home islands. If the Manpower centers produce that great a surplus, it seems foolish to actually let them if there is a choice not to. I guess the question is, is there a reason to?
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Mon Jul 19, 2004 9:05 pm
by AmiralLaurent
ORIGINAL: Oznoyng
I don't know if you can, but if halting Manpower production is a possibility, sounds like you would want to halt like 75% of it. With 781 Manpower centers, if you could halt around 550 of them, you would reduce your resource leakage by 5500 per day and eliminate one hell of a lot of shipping of resources into the Home islands. If the Manpower centers produce that great a surplus, it seems foolish to actually let them if there is a choice not to. I guess the question is, is there a reason to?
Except that you can't stop them. And you probably need them for reinforcements and replacements.
No the only solution I see is to increase to 5 or 6 points for each factory point the armament and vehicle production.
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Wed Jul 21, 2004 12:36 am
by RUPD3658
Thanks for the files. They really help in planning.
Now if Matrix would be willing to sell a poster sized map they could make some $ while helping us players better plot our grand stratagies.
I would pay $10 for a map. Anyone else?
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Wed Jul 21, 2004 3:31 pm
by Spectra
Is is possible that the resources -> Manpower represent the effort needed to feed the population, or at least the Japanese friendly portion of it..? And that manpower takes resources from the pool before HI?
Any manpower points generated are simply a consequence of a young and well-fed population?
This could have an impact later in the game, in a situation where you have lots of oil but few resources, the resources you have may be tapped first to feed everybody, with little left over for HI production..
It may very well be Japan's manpower & armaments levels are correct, (Mr. Frag has hinted as much)...
In which case the Japanese army will be in sad shape unless a significant increase in armaments production (instead of naval or air) occurs... Mind you, to the Japanese fanboy, the army just isn't as cool...
Any ideas as to the long term effects of airpower vs. naval power vs. ground power (ie. where should Japan concentrate its very, very limited industry ) ??
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Thu Jul 22, 2004 7:36 pm
by Oznoyng
ORIGINAL: RUPD3658
Thanks for the files. They really help in planning.
Now if Matrix would be willing to sell a poster sized map they could make some $ while helping us players better plot our grand stratagies.
I would pay $10 for a map. Anyone else?
I printed the maps onto regular paper, cut them, glued/taped them together, and went to Kinko's to get them laminated. If you do that, make sure the Kinko's that you go to has a 36 inch laminator. I used ultra fine point Sharpie pens to label all the base information and I use transparency pens to think out my plans.
Who needs wallpaper? [:'(]
RE: Excel file listing all ressources of the map, Scenario 15
Posted: Thu Jul 22, 2004 8:00 pm
by AmiralLaurent
Glad to see that at least one people here is still able to do something with his hands other than clicking a mouse.
I sure can do. I can hurt myself with anything other than a mouse.