The following four spreadsheets solve a number of variations of the set and drift problem. The preset values are taken from the end of the "Dead Reckoning" chapter in Bowditch.

set_and_drift.xls:

Calculation of set and drift from the difference between dead-reckoning and estimated positions.

ground_speed.xls:

Calculation of the ground speed from the current’s speed and direction (i.e. set and drift) and the vessel speed relative to the water.

course_to_steer.xls:

Given the set and drift, the vessel's speed and the intended direction relative to ground, this spreadsheet calculates the required vessel course and the resulting ground speed. If the vessel's speed is too small to counteract the current, an error message is displayed in row 4.

course_and_speed.xls:

Calculation of the required vessel speed and course from the set and drift and the desired ground speed and track.