Oil Supply Hexes

Please post here for questions and discussion about scenario design and the game editor for WITP.

Moderators: wdolson, Don Bowen, mogami

Post Reply
takacssteve
Posts: 96
Joined: Wed Dec 21, 2005 2:42 pm

Oil Supply Hexes

Post by takacssteve »

Some of the Borneo ports are marked with an Oil supply symbol.
The v7 Excel reference sheet does not reflect oil or fuel at these Borneo ports.
Please explain.
User avatar
Mike Solli
Posts: 16367
Joined: Wed Oct 18, 2000 8:00 am
Location: the flight deck of the Zuikaku

RE: Oil Supply Hexes

Post by Mike Solli »

Which ports?
Image
Created by the amazing Dixie
el cid again
Posts: 16983
Joined: Mon Oct 10, 2005 4:40 pm

RE: Oil Supply Hexes

Post by el cid again »

The Level 7 Resources spreadsheet corresponds perfectly with the oil symbols on Borneo: just verified every one:


526 Tarakan 1200 oil
527 Samarinda 400 oil
528 Balikpapan 2000 oil
524 Brunei 750 oil
523 Miri 300 oil
529 Bandjermasin 400 oil

These values are found in column AF of the spreadsheet.
takacssteve
Posts: 96
Joined: Wed Dec 21, 2005 2:42 pm

RE: Oil Supply Hexes

Post by takacssteve »

The spread sheet is somewhat confusing:

Column AF heading is Axis Daily Oil
Column AG heading is Allied Daily Oil

Column AK heading is Fuel Supply
Column AL heading is Oil Supply

Please explain the differences in these columns. Thank you for your help.
el cid again
Posts: 16983
Joined: Mon Oct 10, 2005 4:40 pm

RE: Oil Supply Hexes

Post by el cid again »

Daily oil is oil from oil centers.

Fuel is not the same thing as oil - WITP fuel is ships fuel (only) - not avgas or other POL products - and not oil either. Oil is PURELY fuel for industry. Fuel is PURELY fuel for ships. Supplies are fuel for everything else - including airplanes and tanks and trucks.

Daily fuel fuel from HI in port cities - or from oil centers - if I remember right.

takacssteve
Posts: 96
Joined: Wed Dec 21, 2005 2:42 pm

RE: Oil Supply Hexes

Post by takacssteve »

I downloaded the v7 Resource excel file dated 03-Jul- 2007 again from the RHS site.
It doesn't exactly match the information you gave me above.

el cid again stated;

column AF

523 Miri 300 oil
524 Brunei 750 oil
526 Tarakan 1200 oil
527 Samarinda 400 0il
528 Balikpapan 2000 oil
529 Banjermasin 400 oil


the RHS site 03-07 resource u..> file v7 states:

column AL

309 Miri 3000 oil
310 Brunei 22500 oil
312 Tarakan 12000 oil
313 Samarinda 4000 0il
314 Balikpapan 20000 oil
315 Banjermasin 4000 oil


Is the RHS file the current post?
Also why not put Oil symbols on other high centers such as:
88 Karachi 22500 oil
86 Colon 18000 oil
264 Muscat 120000 oil
220 Bangkok 93600 oil
etc

ie. it makes the Borneo & CW sites not all that special except for Australians. Am I being to picky?
el cid again
Posts: 16983
Joined: Mon Oct 10, 2005 4:40 pm

RE: Oil Supply Hexes

Post by el cid again »

ORIGINAL: S Lee T

I downloaded the v7 Resource excel file dated 03-Jul- 2007 again from the RHS site.
It doesn't exactly match the information you gave me above.

el cid again stated;

column AF

523 Miri 300 oil
524 Brunei 750 oil
526 Tarakan 1200 oil
527 Samarinda 400 0il
528 Balikpapan 2000 oil
529 Banjermasin 400 oil


the RHS site 03-07 resource u..> file v7 states:

column AL

309 Miri 3000 oil
310 Brunei 22500 oil
312 Tarakan 12000 oil
313 Samarinda 4000 0il
314 Balikpapan 20000 oil
315 Banjermasin 4000 oil


Is the RHS file the current post?

Yes. It varies - but in forward areas like Borneo - the SOP (and the normal economic case in the world in general IRL) is that you have ten days of production on hand. Thus - Miri - recieving 300 oil per day - also has a stockpile of 3000 oil.
That is necessary so a ship can load at a reasonable rate - and not have to wait a long time to get a cargo. That is why there are oil storage tanks in an oil port!

However, if your copy does not show Miri as location 523, it is not a current file. It may even be corrupted - because I don't think Miri ever was anything else. Nope - it was 523 in stock - 523 in CHS - and never changed in any variation of RHS - it was always 523 - as indeed so always was listed by all versions of the economic utility.

I bet you are reading the Excel file line number - not the slot number - which is in column C. [Name, Nation, Slot = A, B, C - for convenience of users - since WITP is slot oriented] For best understanding, read the top of the page Column headers - these are two lines - for more complete indication of what the content of the column is. Not that Slot is ambiguous - other cases benefit from both lines.

Thus Columns AJ, AK, AL and AM are "Hex Supply/Resource Stocks" for Supply, Fuel, Oil and Resources (respectively).
So AL is the total Oil in the hex - available to consume or load on a ship - or ship by a rail line (etc).

AX and AY are the working and damaged Manpower Centers.
AZ and BA are the working and damaged Resource Centers.
BD and BE are the working and damaged Heavy Industry Centers.
BF and BG are the working and damaged Oil Centers.

These are the base values which are multiplied by various factors to get daily resources, oil, fuel, supplies, manpower and HI points. The spreadsheet is supposed to make it easy to get totals for such things for each location, for each nation, for each side, etc.
Post Reply

Return to “Scenario Design”