Secondary Ports, Estimated Position, Course to Steer

Spreadsheets are beyond my comprehension.

I asume to create a spreadsheet you can somehow set it to calculate a formula to fugure out the value.

I would have thought the creation of a working spreadsheet would demonstrate a good working knowladge of the proccess required.

The end result a cleaver usefull aid to nav.
 
alant said:
Secondary ports, only need 3 bits of information, which are HW ht/LW ht/HW time, at secondary port, then enter into standard port tidal curve. What could be easier?
Click to expand...

alant said:
+1

PS,
Don't forget the LW curves around the Solent area.
Click to expand...


Secondary ports need 4 bits of information - you also need low water times. Secondary port rise and fall durations are often not the same as standard port rise and fall durations - that's one of the reasons you do the corrections.

For some intermediate ports you should not calculate intermediate times from the standard curve - although this not published in the leisure almanacs. This applies to about 20% of the ports on the south coast, and about 10% of those in the Thames estuary (as well as many other ports in the UK and around the world).
 
Hi Richard,

I'm sitting my Yacht Masters in a couple of weeks time and would really appreciate copies of the self calculating spread sheets for all three if you would be so kind.

Thanks
Rob
 
RobKarsten said:
Hi Richard,

I'm sitting my Yacht Masters in a couple of weeks time and would really appreciate copies of the self calculating spread sheets for all three if you would be so kind.

Thanks
Rob
Click to expand...

Hi Rob

The files are in post 3. It's only the secondary ports one which self-calculates as the calculations are quite complex. The other two have simple calculations but the spreadsheets helps with the order.

PM me with your email address if you can't download them from above for some reason.

Richard
 
John Barry said:
Secondary ports need 4 bits of information - you also need low water times. Secondary port rise and fall durations are often not the same as standard port rise and fall durations - that's one of the reasons you do the corrections.

For some intermediate ports you should not calculate intermediate times from the standard curve - although this not published in the leisure almanacs. This applies to about 20% of the ports on the south coast, and about 10% of those in the Thames estuary (as well as many other ports in the UK and around the world).
Click to expand...

Why do you need LW times, unless its a LW curve, like Southampton Water?
Its the back of a cigarette packet calculation, not a degree course.
 
alant said:
While they obviously work for you, can't help but think your over-egging fairly simple navigation tasks.

Whilst secondary port calcs, require use of a tidal height curve, both CTS & EP's are best by simply drawing them on your chart as generations of seamen have done. All you need to consider, is the tidal hour(s) in order to determine set/drift. Just constructing a tidal hour ladder on a convenient section of the chart, will allow easy reference, without looking for 'spreadsheets'.
Jotting the times from HW +/- into the relevant tidal atlas, is even easier.

Secondary ports, only need 3 bits of information, which are HW ht/LW ht/HW time, at secondary port, then enter into standard port tidal curve. What could be easier?
Read more at http://www.ybw.com/forums/showthrea...ion-Course-to-Steer/page2#ArxeQS8TcE2cpJ7o.99
Click to expand...
alant said:
+1

PS,
Don't forget the LW curves around the Solent area.
Click to expand...

Selfie plus one! Far out!
 
Last edited:
RichardS said:
Piotaskipper's helpful recent "decision tree approach to ColRegs" aid to RYA students reminded me that I'd written a spreadsheet approach for secondary ports, estimated positon and course to steer which I used when I took the Yachtmaster exam last year.

They're designed to make sure that the corrections are done in the correct order for the northern hemisphere using the fictional RYA charts and time zones. However, they can be applied to the real world as well.

For the RYA course I used paper versions of the spreadsheets as I obviously couldn't use a PC in the exam although the spreadsheet version of the Secondary Ports spreadsheet does the calculations automatically if you enter the data onscreen.

If they help anyone understand the principles (or pass the exam!) please feel free to print them out.

If you want to edit them or if any maths-junkies out there want the self-calculating secondary ports Excel spreadsheet (if you feel it's important to get a result that is precise to as many decimal places as you like!!), please add a post and I'll sort out a zip version as I don't think I can attach xls files.


Richard

PS It turned out to be trickier than I expected to attach even pdfs as the maximum file size for pdfs is pathetically small. I've therefore had to attach zips even though they are no smaller!
Click to expand...
RichardS said:
Piotaskipper's helpful recent "decision tree approach to ColRegs" aid to RYA students reminded me that I'd written a spreadsheet approach for secondary ports, estimated positon and course to steer which I used when I took the Yachtmaster exam last year.

They're designed to make sure that the corrections are done in the correct order for the northern hemisphere using the fictional RYA charts and time zones. However, they can be applied to the real world as well.

For the RYA course I used paper versions of the spreadsheets as I obviously couldn't use a PC in the exam although the spreadsheet version of the Secondary Ports spreadsheet does the calculations automatically if you enter the data onscreen.

If they help anyone understand the principles (or pass the exam!) please feel free to print them out.

If you want to edit them or if any maths-junkies out there want the self-calculating secondary ports Excel spreadsheet (if you feel it's important to get a result that is precise to as many decimal places as you like!!), please add a post and I'll sort out a zip version as I don't think I can attach xls files.


Richard

PS It turned out to be trickier than I expected to attach even pdfs as the maximum file size for pdfs is pathetically small. I've therefore had to attach zips even though they are no smaller!
Click to expand...
 
Hi Richard,

Would you be so kind as to share your files on the dropbox share below?
They would greatly help my current studying.

All the best.

Michael
 
You must log in or register to reply here.

Other threads that may be of interest

mogmog2
Maxwell windlass 10 VW looks interesting (to a windlass noob)
2 3
Replies
59
Views
1K
mogmog2
mogmog2

Share this page

Top