Creating tide levels in Excel
Creating tide levels in Excel
(OP)
OK, I'm trying to model vessel movements in a port. My model requires the tide levels. They don't need to be 100% accurate, but I want them to be better than simply a sine curve. At present, this is all I am using, in the form:
={Tidal Height}*SIN({Time}/{Tide period}*2*PI())
Tidal height is a constant (so far) but I'd like it to vary between springs and neaps, and also provide different heights for each daily high/low tide.
Can anybody help?
={Tidal Height}*SIN({Time}/{Tide period}*2*PI())
Tidal height is a constant (so far) but I'd like it to vary between springs and neaps, and also provide different heights for each daily high/low tide.
Can anybody help?





RE: Creating tide levels in Excel
https://en.wikipedia.org/wiki/Tide
https://en.wikipedia.org/wiki/Arthur_Thomas_Doodso...
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm