Convoy Calculator Spreadsheet

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

Convoy Calculator Spreadsheet

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> The War Room >> Convoy Calculator Spreadsheet

Page: [1]

Message

<< Older Topic Newer Topic >>

Convoy Calculator Spreadsheet - 5/28/2013 12:11:18 AM

Amoral

Posts: 378
Joined: 7/28/2010
Status: offline

This is a google documents spreadsheet that helps you calculate a good size for a resource convoy of ships between two ports. It is intended to help Japan plan out its initial resource convoys to the Home Islands, but it has many other applications. The main limitations are that you have to be using ships of all the same class for it to be able to calculate anything for you; and that it only knows load/unload rates for resources, supplies and oil.

It is a translation of the ship and port load ability table 6.3.3.2.4, pg 125 in the manual.
It is driven by data on a tab called Port Information and another called ship information. These tables are not complete, so you will ned to add to them to use the tool for your own campaign. To be able to edit the dheet you will need to goto file->save a copy. Then you will have your own copy and gain edit priviledges.

Please let me know if you see any errors in the calculations!
Google Docs Convoy Calculator

Post #: 1

RE: Convoy Calculator Spreadsheet - 5/28/2013 12:35:11 AM

caballo71

Posts: 12
Joined: 7/24/2010
From: Teruel (Spain)
Status: offline

Excellent idea.
Thank you.

(in reply to Amoral)

Post #: 2

RE: Convoy Calculator Spreadsheet - 5/28/2013 6:22:08 PM

Lokasenna

Posts: 9297
Joined: 3/3/2012
From: Iowan in MD/DC
Status: offline

There is also a tool in Tracker that is useful for this

. It wasn't all that intuitive to me at first, and I don't use it to plan my convoys except for reference... However: in the Industry data set, there is a CS Convoy Planning tab. Click on it.

Inside you will be able to select two ports, and it will then give you the resource/oil/fuel load per ship and per day for the whole port. For example, if there is a 3k per ship load at the port and a 36k total load for the port per day, I make convoys of 12 ships that carry 3k (or slightly less) each.

(in reply to caballo71)

Post #: 3

RE: Convoy Calculator Spreadsheet - 6/15/2013 6:58:20 AM

Mac Linehan

Posts: 1484
Joined: 12/19/2004
From: Denver Colorado
Status: offline

quote:

ORIGINAL: Lokasenna

There is also a tool in Tracker that is useful for this . It wasn't all that intuitive to me at first, and I don't use it to plan my convoys except for reference... However: in the Industry data set, there is a CS Convoy Planning tab. Click on it.

Inside you will be able to select two ports, and it will then give you the resource/oil/fuel load per ship and per day for the whole port. For example, if there is a 3k per ship load at the port and a 36k total load for the port per day, I make convoys of 12 ships that carry 3k (or slightly less) each.

Great Scott, Lockasenna!

Here I am, a professed Tracker Man, and I have not yet taken the time to check out that particular tool. So much for my powers of observation...

I will fire up tracker and check it out.

Thank You for bringing it to my attention.

EDIT: I do not use the CS Convoy routine, and thus have been overlooking this useful tool.

Mac

< Message edited by Mac Linehan -- 6/15/2013 7:16:39 AM >

_____________________________

LAV-25 2147

(in reply to Lokasenna)

Post #: 4