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)
