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.