Matrix Games Forums

I'm not sure if any of you will find this useful, but I've been this spreadsheet to help me figure out my allied convoys. It is an Excel spreadsheet that should work with both Excel and OpenOffice. There are instructions in the spreadsheet. Various cells and sheets are protected to make sure the right values are always available, but if you want to play around with the data in it, there are no passwords.

What this tool does is let you pick a scenario and then an origin base and a destination base. It then calculates various statistics for you like spoilage, distance, travel time, mean daily transfer rates for supply and fuel and stuff like that. You can also modify things like how long it takes to load/unload and what would happen if you increased port or AF sizes.

My last few spreadsheets have had various errors in them that I've corrected, so I'm sure this one will also! =)

Know Limitiations:

• Distances are straight line, "as the crow flies". There is no fancy pathfinding. A trip like S.F. to Seattle, for example, is not accurate because of the need to go around the horn of Washington into Seattle. Just double check with a real ship or on a planning map.
• There is no error checking logic to make sure it really has a port. So selecting Boise to S.F. will do the calculations for you anyway =)

Acknowledgements: Mostly all the posters in the various production and convoy threads. Most are JFBs so they will remain nameless [:D] As a AFB, I feel like I'm in the class with all the slow kids in remedial math.

EDIT: The file type is *.xls (not txt or zip as the download might say)

If you made it in Open office, then it is possible to save it as an excel file, but if you saved it as an open office spreadsheet, then excel won't be able to open it.

See, that from a fellow AFB, or a slow kid that needs remedial math [:)].

One question though, what do you mean with spoilage, is it spoilage in the bases or something to do with losses underway ?

Base spoilage. I am at home until tomorrow. When I get to work tomorrow, I will convert it to something that Excel can read.

Here is a screenshot (including a nice "unregistered version" from the printscreen software I download, anyone have a good free one?).

Changed the spreadsheet to Excel (xls). Should work with both Excel and OpenOffice now!

Nice, thx !

Extremely useful, thanks.