Hallo,
Calculating the course to steer is easy with the Excel worksheet y have made.
The excel file is too big to post on the forum, so I made a picture of the worksheet "COURSE TO STEER".
If anyone is interested in the excel worksheet please contact me and I can send the files to your
email address.
You can choose from three sizes, according to the size of your
screen. (There is also a possibility to adjust the columns and rows, if your
screen size differs from the three created sizes in the attachment. Choose a size that is closest to fits your screen size).
This Excel worksheet should simplify
navigation and can also be used to check your own calculations.
For the people who know excel, this worksheet should not cause any problems.
If you have looked up the tidal data on the nautical chart or almanac and entered in the green boxes, the tidal vector, which otherwise has to be drawn on the nautical chart, can be calculated for you in this worksheet and with input from all other data available. , the course to steer is then also calculated.
The course to steer can be easily recalculated every hour.
The helmsman can then sail with the calculated course to steer on the
steering compass.
It took several hours to realize this worksheet in excel.
Additional worksheets were also made to support the main worksheet “COURSE TO STEER”
Unfortunately, I have not been able to test the excel worksheet “COURSE to STEER” sufficiently in practice and I ask the people who read this to test this excel worksheet in practice.
Hopefully I will get a lot of comments about how user-friendly the excel worksheet works and also where improvements can be made. Also whether the calculations are correct and certainly the calculations that are made when there is a crossing, so if the course can not be sailed.
When you open the excel, the program starts on the excel worksheet “COURSE to STEER”. There you can enter all data in the green boxes. It may be that the sheet does not fit completely on your screen, but you can adjust that. Please read the Excel worksheet ”HELP” (click on the light blue box “HELP” to do so.
All worksheets are protected with a code so that the formulas cannot be changed.
To display the worksheet completely on the screen, press the “ctrl” key and the “a” key at the same time.
Any change to a formula in the worksheets can be detrimental to the calculations.
Good luck with the testing and be sure to let us know.