Ships Log
Dear All:
Has anyone on the list developed a ships log using Excel or some other
application that they are willing to share? I have been working on one, but
not wanting to re-invent the wheel, thought I would ask.
I have searched the internet and found a number of printed versions and some
that can be purchased on CD, but nothing that can be downloaded.
We are about to leave Hong Kong (on our new trawler) on a voyage that will
take us to the US via the Indian Ocean, Med and Atlantic. I have a log book
that I used on my sailboat, but it is not applicable to a motor vessel.
Gordon
Alchemy
USCG Doc. No.: 1177849 - Station ID (MMSI): 367070010
Call Sign: WDC7347 - FRN: 0014000947
Owners: Gordon & Yu-ching Anderson
Mailing Address: 4004 Wallace Lane, Nashville, TN 37215
Phone: + (615) 297-8289
Current Anchorage - Golf Coast Yacht Club - Hong Kong
Current Cellular: +852-6415-2783 or 6592-4387
Email: alchemy@post.com
[demime 1.01d removed an attachment of type image/jpeg which had a name of image001.jpg]
[demime 1.01d removed an attachment of type image/jpeg which had a name of image002.jpg]
Gordon - Not sure if this is exactly what you are
looking for, but here's a passage report (Dana Point
CA to Ft Lauderdale) that has a log for the journey.
It's in PDF, but the original data was in Excel -
wouldn't take much to adapt. I had multiple tabs for
each piece of machinery.
http://seaskills.com/files/SeaSkillsLONGDeliveryReport.pdf
Peter
www.SeaSkills.com
--- "Dr. Gordon Anderson" alchemy@post.com wrote:
Dear All:
Has anyone on the list developed a ships log using
Excel or some other
application that they are willing to share? I have
been working on one, but
not wanting to re-invent the wheel, thought I would
ask.
I have searched the internet and found a number of
printed versions and some
that can be purchased on CD, but nothing that can be
downloaded.
We are about to leave Hong Kong (on our new trawler)
on a voyage that will
take us to the US via the Indian Ocean, Med and
Atlantic. I have a log book
that I used on my sailboat, but it is not applicable
to a motor vessel.
Gordon
Alchemy
USCG Doc. No.: 1177849 - Station ID (MMSI):
367070010
Call Sign: WDC7347 - FRN: 0014000947
Owners: Gordon & Yu-ching Anderson
Mailing Address: 4004 Wallace Lane, Nashville, TN
37215
Phone: + (615) 297-8289
Current Anchorage - Golf Coast Yacht Club - Hong
Kong
Current Cellular: +852-6415-2783 or 6592-4387
Email: alchemy@post.com
[demime 1.01d removed an attachment of type
image/jpeg which had a name of image001.jpg]
[demime 1.01d removed an attachment of type
image/jpeg which had a name of image002.jpg]
Passagemaking-Under-Power Mailing List
I have a Lotus 123 spreadsheet that I can easily convert to Excel. If you
wish a copy send a note to me at JohnPH@Comcast.net
The response may not be very quick since we are currently boating along the
Atlantic coast of France.
Regards, John Harris
Peter,
Here is the ships log spreadsheet that I have kept this year. Please use it
as you
will. NOTE that some columns are calculated and others are to be filled in
each hour, or logging period.
Note that columns BL thru BX in the 2005 version calculate the straight line
distance traveled from the LAT / LON data entered. I don't know how well
these formulas will convert from Lotus 123 (as written) to Excel so they
need some touchup. There have been minor changes through time and from year
to year so pick the ones you like and throw away the rest. There is also a
departure check list on a separate page.
I always copy the previous line down one line and fill in the new data so
that all the formulas carry forward. I hope you find it of some use and
would appreciate any ideas for additions or improvements.
Regards, John Harris
World Odd At Sea
Presently lying Saint Peters Port, Guernsey
[demime 1.01d removed an attachment of type application/vnd]