DIP SHORT OF THE HORIZON
The spreadsheet dip_short.xls implements the formula behind Table 14 in Bowditch. The height of eye can be entered in meters or feet (enter "m" or "ft" in cell C1). The distance to the waterline in cell B2 is in nautical miles. The resulting dip is output in cell B3 in nautical miles.
Summary for spreadsheet dip_short.xls:
Input cells: B1, C1, B2
Output cells: B3