Web Hosting

Free Ads

----------------------------

SmileTrain

----------------------------

Our World 2.0

----------------------------

Avaaz.org

----------------------------

ProjectBriatin

----------------------------

CruisingWiki

Keeping Track of Everything–part 3 …

Jeff Seigel, founder of ActiveCaptain, writes…

This series has generated a lot of interest so we’ll pick up the pace and continue with it. After today’s newsletter, there’ll be one more segment and then we’ll provide templates for all of the databases. We’ve been in contact with the HanDBase developers and they’ll host the templates on their own website so boaters everywhere can use them as a starting point.

If this is the first time you’re seeing this series, you might want to refer back to the index of newsletters to see the other segments.

All newsletters are archived here: https://activecaptain.com/newsletters

CAPTAINS LOG TABLE

The most important database in the Keeping Track set is the Captain’s Log table.

This is the main log where all actions are recorded. Although there are about 10 different categories of items, most of the entries fall under two categories – destination travel and maintenance.

Here are all the fields we use in our Captain’s Log:

  • Date/Time – the date and time of the entry.
  • Category – a popup of categories. The categories we use are: Maintenance, Repair, Equipment, Misc, Boat Movement, Water, and a category for each "cruise" we’ve done. Equipment is the log for every new piece of equipment added to the boat. Boat Movement is when we’re moving the boat not associated with cruising. Water is when we’re tracking water usage.
  • Desc – a title description for the entry. For the cruising categories, this is the city, state where we arrived.
  • Location – this is a more descriptive entry of exactly where we arrived. It’s an ActiveCaptain marina or anchorage name in 99% of the cruise entries. This item is also filled out for maintenance and other log entries. It’s very valuable to know where particular projects were done. Here at Chesapeake, VA, we’re having our salon settee re-upholstered this week. We’ve record that as a maintenance item with a location of Atlantic Yacht Basin. This allows us to recall where we can get this type of work done in the future by looking back in the records.
  • Lat/Lon – the latitude/longitude. This is most often only recorded for destination entries.
  • HrsToday – this records the number of hours it took to arrive at a destination. Surprisingly, we often look back on this. It lets us know how long it has taken to go from one location to another over more than a decade of traveling along the waterways. It has been very valuable in fine tuning our planning.
  • Notes – this contains paragraphs of notes appropriate to the entry. It will contain the upholstering company we used in the example above, contact information, pricing, and our (hopefully positive) impressions. For cruising log entries, it details any issues we faced, weather encountered, and other things we’d like to remember about the destination. We often put the names of people we met or experiences we had at the location. These notes also end up as reminders for us when we write a review about a marina or anchorage.
  • EngHours – the hour meter reading of the engine hours. This gives backup timing on many of the entries. For the engine oil change maintenance entries we made last weekend, it’s an important record of the hours for that work. Whenever maintenance is done on our generator, this field is used for the generator engine hours (also done last weekend).
  • NMToday – a record of the nautical miles travelled for destination entries.

We’ve changed the fields collected for the Captain’s Log many times over the years but there hasn’t been a change in about 4 years.

This list of fields works for us. It’s probably a good starting point for others.

FUEL LOG

One more simple database to describe – the Fuel Log. This database logs every drop of fuel we have ever purchased for our boat. We always make entries when we fill all tanks.

This allows the database to provide a running gallons-per-hour tracking which gives us a view into possible issues with the engines.

The fields in the Fuel Log are:

  • Date/Time – when the fuel was purchased.
  • Location – where the fuel was purchased.
  • Gallons – how many gallons were purchased.
  • PerGallon – the cost per gallon paid (the first entry was 5/8/03 for $1.25 per gallon).
  • Total Cost – a calculated field we use to check the math of the charge given to us.
  • CurrentEngHrs – hour meter reading for the engines at the time of fuel purchase.
  • PrevEngHrs – hour meter reading for the engines at the previous fuel purchase.
  • CurrentGenHrs – hour meter reading for the generator at the time of fuel purchase.
  • PrevGenHrs – hour meter reading for the generator at the previous fuel purchase.
  • GPH – a computed field that takes all the hours fields and the number of gallons and computes the gallons-per-hour for this last fuel usage. It automatically removes the generator gallons used to give a better efficiency indication for just the main engines.
  • Notes – any notes we want to remember about the fuel purchase.

This has been a dry look at a few more of our databases used.

Next time, we’ll finish up with the Maintenance, Parts, Spares, and Engine Room Logs.

ActiveCaptain

Share

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Jump start your engine or genset with Lithium-ion ?…

 

WEEGO have produced a jump start battery that fits in your pocket !.. Weego, an innovator in portable battery solutions, announced the launch of its Weego Jump Starter Battery+ for the marine market. A compact and portable jump starter, the Jump Starter Battery+ eliminates the worry and fear of a dead battery, for as little as $99.00.

“Dead batteries at best ruin your day and at worst put you in a tight spot,” said Gerry Toscani, CEO, Weego. “Our small, high-powered Weego Jump Starters are perfect for boaters. Lithium-ion

…….Click Jump start your engine or genset with Lithium-ion ?… …. to continue reading

Share

Keeping Track of Everything – part 2 …

Jeff Seigel, founder of ActiveCaptain, writes…

A couple of weeks ago we wrote a newsletter segment about how we keep databases of projects, logs, parts, and fuel purchases. It generated a lot of emails and responses. So we thought we'd dig into the subject a little deeper and give the next set of ideas about the things we've learned by keeping these databases at our fingertips over the last 13 years.

We're using off-the-shelf database tools to create our solution. While there are many solutions that are laptop or web-based, they have

…….Click Keeping Track of Everything – part 2 … …. to continue reading

Share

Where in the world am I? Ah, that’s the great puzzle….

Apologies to Lewis Carroll for the mis-quote above, but we are so accustomed to knowing exactly where we are – or at least having smartphones and chart plotters telling us.

I have noticed that some power boat skippers and even sailors (hrmphh) plot routes perilously close to hazards or marker buoys. As if the GPS is so accurate that it can help you miss a hazard by metres; that the hazard marker hasn’t drifted since the chart in the plotter was last updated; or that the hazard itself hasn't moved – a sandbank for example.

…….Click Where in the world am I? Ah, that’s the great puzzle…. …. to continue reading

Share

Keeping track of everything…

Jeff Seigel, founder of ActiveCaptain, writes…

One of the most common questions we've been asked over the years revolves around the ways we keep track of our ships logs, maintenance reminders, projects, and other boating lists. It shouldn't surprise anyone that we use technology to solve these needs. We've learned some valuable lessons and will split them into a few newsletter segments to help others keep track of, well, everything. First, an overview of the things we database.

From the first moment we stepped onto our current boat in 2003, we've used

…….Click Keeping track of everything… …. to continue reading

Share