BlackDog_slith
Posts: 23
Joined: 8/7/2005
Status: offline
|
Hi all,
I am still slowly trying to understand the whole production system and to help me on that I have created a few tables and excel spreadsheets.
For example I now have a complete Excel table listing all production-related bases data : resource centers, oil centers, Heavy Industries, Manpower centers, Shipyards, Factories, etc, sorted by countries... That's a lengthy table with more than 178 lines !
I now can do the sum of all such data in a whole area I am managing.
For example, if I focus on the Indochina-Siam-Malaya-Burma area (this is a complete area with inland supply roads, so I guess the system could manage inter-dependance of all bases for production needs), in 1942 as Japanese player I own inter-linked bases for a total of :
Resource Centers : 2800
Oil Centers (Inland) : 50
Oil Centers (Port) : 50
Heavy Industry (Inland) : 0
Heavy Industry (Port) : 630
Manpower Centers : 8
I am now trying to pour and stir all those numbers with formulas given inside the manual, in order to find the resulting data : do I need to import Oil and/or Resource points to this area, or can I export Oil or Resource to other areas ?
I created a small Excel formula using those numbers as data source. Here is the math :
Oil Points (OP) = (6 * Oil Centers Inland) + (6 * Oil Centers Port)
Resource Points (RP) = 1.25 * Resource Centers
Manpower Points (MP) = 5 * Manpower Centers (it will also consumes RP, see below)
Heavy Industry Points (HIP) = Heavy Industry Inland + Heavy Industry Port (it will also consumes OP
and RP, see below)
Supply Points = Resource Centers + Heavy Industry Inland + Heavy Industry Port
Fuel Points = Oil Centers Ports + (1.33 * Heavy Industry Port)
So for Indochina-Siam-Malaya-Burma area I get :
OP = 600
RP = 3500
MP = 40
HIP = 630
Supply = 3430
Fuel = 887.9
This is all I get from my production system.
I must also substract from the OP and RP the amount consumed by the production of HIP, MP, fuel and supply :
for OP I need to substract :
HIP : consumed when supply + fuel are produced
+ 2 * HIP : consumed when HIP are produced
for RP I need to substract :
MP : consumed when Manpower Points are produced
+ HIP : consumed when supply + fuel are produced
+ 2 * HIP : consumed when HIP are produced
So for Indochina-Siam-Malaya-Burma area my final OP and RP numbers are :
OP = 600 - 630 - 2*630 = -1290
RP = 3500 - 40 - 630 - 2*630 = 2160
So from those numbers, and if my formulaes are correct, I have a positive balance of 2160 RP each day that I can export to other areas (Japan mostly), and I have a negative balance of -1290 OP that I need to import to this area in order to get a fully efficient production system.
Now for my questions about all this :
1. Am I right with those numbers ? or is there a fatal flaw somewhere inside those maths ??
2. If this is more or less correct, how can I be sure that I am able to import 1290 OP/day (or by month*30), and to export 2160 RP ???
3. Most important question : even if all this data above is correct, maybe is it better just to focus on trend of RP/OP/HIP pools on the main intelligence screen, and try to adjust production to get even pools ??? but doing this, how can I be sure that each independant production area (not linked to other areas by land) is able to get enough RP/OP to function properly ???
Thanks to the (few?) readers with enough courage to read all that :-)
If I can get all those numbers right, and if there is interest for it, I will post my Excel tables.
Chris
< Message edited by Ainurdolin -- 8/7/2005 10:38:25 PM >
|
Printable Version
Production engine - more questions and lot of data - 
RE: Production engine - more questions and lot of data - 
I guess that using a few Excel tables with a monthly management goal should be doable... 
(tries to pick up jaw off of ground) 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread