Page 1 of 2

New version of the Production Excel sheet

Posted: Tue Jul 20, 2004 6:19 pm
by AmiralLaurent
New features included:

_ correction of ressources spelling to resources

But more seriously:

_ there is an "initial number" column and a "fill in" column, used by the formulas so you can do all the tests you want and then fill again the actual numbers.

_ two pages now list respectively Japanese and Allied areas with the output of each.

_ I have added the daily bonus some Allied bases have. I thought that fuel and supplies only arrives in USA and Karachi but in fact Bombay and one Soviet and two North China bases also receive supplies.

_ last feature, a column shows the initial stock of ressources and oil in a given area and the next column show how much day the area will produce before running out of ressources or oil, if the daily output is negative.

RE: New version of the Production Excel sheet

Posted: Tue Jul 20, 2004 6:33 pm
by AmiralLaurent
My results for Australia:

Australia industry will run 8 days at full potential, producing 63600 supplies and 31243 supplies. Then the local oil center and imported US from the USA (500 points a day) will enable to run 950 factories. Select them all in ports and Australia will produce daily 5990 supplies and 1388 fuel.

My advice is to bring as much oil you can from DEI (from Java for example, that will be less risky than from Borneo or Sumatra). Also there is 80000 oil in the USA (30000 of them in ports) that will not be used as the area produces more than its need, so you can ship all of it to Australia, this will allow 13 other days of full production.

My results for India:
Burma and India fiels create 1050 oil points and you have 615 HI in ports and 1690 inland, with a stock of 20000 oil in India. Turn down all inland HI except 500 points. So you will have a economy where the maximum fuel is created and that will last 308 days before the oil is exhausted and you have to reduce a little more.
Or you can turn down all inland HI and save oil for shipping to Australia (435 oil points each day). Australia has no daily supply or fuel arriving each day (Karachi and Bombay have 20000 supplies and 12000 fuel) and needs convoy. Rather than sending a ship with fuel, send her with oil. Australian factories will be able to use it to build fuel (1.33 more) and supplies, as ressources are widely available.

RE: New version of the Production Excel sheet

Posted: Tue Jul 20, 2004 6:34 pm
by AmiralLaurent
Forgot to say that I just sent it to Spooky for putting it on his site. Hope it will be available this evening

Best regards

RE: New version of the Production Excel sheet

Posted: Tue Jul 20, 2004 7:50 pm
by Spooky
ORIGINAL: AmiralLaurent

Forgot to say that I just sent it to Spooky for putting it on his site. Hope it will be available this evening

Best regards

It is now available as a V3 in the WITP Fansite ... and congratulations to Admiral Laurent, it is a really wonderful tool !

RE: New version of the Production Excel sheet

Posted: Tue Jul 20, 2004 8:05 pm
by worr
Not Found
The requested URL /witp_files/resources v3.zip was not found on this server.


--------------------------------------------------------------------------------

Apache1.3.29 - ProXad [Jun 9 2004 15:20:10] Server at mathubert.free.fr Port 80

RE: New version of the Production Excel sheet

Posted: Tue Jul 20, 2004 9:52 pm
by Spooky
The link is now fixed !!!!!
ORIGINAL: worr

Not Found
The requested URL /witp_files/resources v3.zip was not found on this server.


--------------------------------------------------------------------------------

Apache1.3.29 - ProXad [Jun 9 2004 15:20:10] Server at mathubert.free.fr Port 80

RE: New version of the Production Excel sheet

Posted: Tue Jul 20, 2004 10:01 pm
by worr
Thnx!

Any chance we can get a printable format of the map?

Looks great, but would be great to look at off line. Maybe in four pages?

Also what is the legend for the map?

Worr, out

RE: New version of the Production Excel sheet

Posted: Tue Jul 20, 2004 10:13 pm
by Spooky
ORIGINAL: worr

Thnx!

Any chance we can get a printable format of the map?

Looks great, but would be great to look at off line. Maybe in four pages?

Also what is the legend for the map?

Worr, out

Hi Worr

Could you please write your comments on the WITP large maps in this thread tm.asp?m=665221 - in order to keep them in only one thread

Thanks to your feed-back, I hope Carniflex will release a new version soon [:)]

RE: New version of the Production Excel sheet

Posted: Tue Jul 20, 2004 10:42 pm
by brisd
AmiralLaurent - what does the column G labelled 'delay' on the Japanese production mean/work??? Thanks, this will be very useful!

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 7:04 am
by AmiralLaurent
When an area is using more resources or oil than it is producing, the column delay shows how much day it will produce until the initial stock are gone and the factories will stop producing.

Ex: Indochina has 10000 oil at start (in Saigon) and the stock will be reduced by 330 each day. 10000 / 330 = 30 (rounded down), so HI here will produce during 30 days and then need some more oil.

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 10:19 am
by Rainerle
Hi,
is manpower production cleared up? Your (excellent) sheet and the manual state MP x 5, while many users in this forum claim MP x 4, what is correct ?

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 10:26 am
by AmiralLaurent
My tests show that manpower output = manpower centers * 5, and that roughly 20% of it will be used with armament and vehicle production, so manpower pool rise by manpower centers * 4 each day, once the armament pool is empty.

But these things are rather hard to test as even when turning all ground units replacement off, my armament pool continue to fall... I just copied the manual here, so hope it's OK.

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 10:31 am
by Mr.Frag
But these things are rather hard to test as even when turning all ground units replacement off, my armament pool continue to fall... I just copied the manual here, so hope it's OK.

Turning off replacements will not turn off technology upgrades.

You've probably noticed that a large number of 47mm AT's are getting produced right off the bat to upgrade the 37mm.

To shut it down completely, go into the device table and change the availability dates on a bunch of the early stuff. That will give you a clean run.

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 11:27 am
by AmiralLaurent
Thanks Mr Frag, I had completly forgotten about the armament upgrades.

What is you point of view about manpower and armament production ? It seems to me that the model is flawed here and manpower production is far too strong or armament production far too low, the latter more probably as it is unable to cope with just the reinforcement coming in.

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 11:29 am
by cverbrug
Hi,
can you please enlighten me / us with the full path name? if have no idea where to look for this file?Thank you in advance
Beste regards

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 11:45 am
by Apollo11
Hi all,

Thanks!


Leo "Apollo11"

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 11:56 am
by Mr.Frag
It seems to me that the model is flawed here

What makes you think they could cope? [:'(]

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 6:06 pm
by AmiralLaurent
ORIGINAL: Mr.Frag
It seems to me that the model is flawed here

What makes you think they could cope? [:'(]

I think they couldn't cope the losses but at least they should be able to create new units in Japan.

I think it is flawed because the manpower generated is 6 time more than the needs... and Japan will never be able to build six time more armament. So two possibilities :

1) Armament factories produce more than 1 point per factory point each turn and that's OK. My model is wrong

2) Japan is generated thousand of youg men each day (1 manpower = 1 man by squad size) but 3000 of them only receive bamboo pole and train to repulse the American landings excepted in 1946....

As far as I know, only France begin WWII like that. 5 million French men were mobilized in September 1939 but once they were in basements the High Command realizes they were enough weapons and military equipment for 3 millions of them, so he sents 2 million back to factories (mainly) and fields.

RE: New version of the Production Excel sheet

Posted: Wed Jul 21, 2004 6:40 pm
by brisd
Thanks AmiralLaurent for the explanation. I am setting up my first attempt at the campaign game as Japan and all these files help ALOT.

RE: New version of the Production Excel sheet

Posted: Thu Jul 22, 2004 4:56 pm
by brisd
AmiralLaurent - I have been playing with my own excell spreadsheet to help me manage my aircraft production and the formula you use on your formula sheet doesn't seem to be correct according to the manual. From my reading of the manual, a single engine aircraft will cost 18 HI (for its engine) plus 18 Hi (for its single engine airframe). That equals 36 HI. Your formula adds 18 to each aircraft produced? Why? Thanks!