Allied Convoy Spreadsheet
Posted: Fri Nov 25, 2022 5:23 pm
Here is an Open Office spreadsheet I use to help manage Allied Convoy paths. As it is Open Office, I suspect that it will not work on Excel. Open Office does have the advantage of being free.
The example given is for the S/O '39 turn, assuming that the Axis has declared war on and occupied Belgium and the Netherlands, since this is the maximum CPs the Allies will need on S/O '39. To do later turns, copy the SO 39 sheet to ND 39, and work from there. Each turn should get its own sheet. Usually, things settle down after a bit, and there is no need to do a sheet every turn.
The upper left part of the sheet is where the sources of goods are, with each different destanation getting its own line. Canada, for example, gets two lines, one for the two resources used by its own factories, and one for goods being shipped to Britain.
The yellow shaded area is where how many goods are being shipped, and might change each turn; the other items generally don't change, or are computed.
The upper right part of the sheet shows which sea areas are in each convoy chain. Some convoy chains have no sea areas at all (Britain to Britain, for example).
The key to the spreadsheet is the C column on the lower right, which gives how many CPs are needed in each sea are.
There is an instruction page on the second sheet.
I will be grateful for any suggestions for improvements.
The example given is for the S/O '39 turn, assuming that the Axis has declared war on and occupied Belgium and the Netherlands, since this is the maximum CPs the Allies will need on S/O '39. To do later turns, copy the SO 39 sheet to ND 39, and work from there. Each turn should get its own sheet. Usually, things settle down after a bit, and there is no need to do a sheet every turn.
The upper left part of the sheet is where the sources of goods are, with each different destanation getting its own line. Canada, for example, gets two lines, one for the two resources used by its own factories, and one for goods being shipped to Britain.
The yellow shaded area is where how many goods are being shipped, and might change each turn; the other items generally don't change, or are computed.
The upper right part of the sheet shows which sea areas are in each convoy chain. Some convoy chains have no sea areas at all (Britain to Britain, for example).
The key to the spreadsheet is the C column on the lower right, which gives how many CPs are needed in each sea are.
There is an instruction page on the second sheet.
- Allied Conv.jpg (1.08 MiB) Viewed 827 times
