I need an Excel spreadsheet, with formulas, showing the following:
Time of High Tide/s - usually two per day
High Tide Water Level for each high tide
Time of Low Tide/s - usually two per day
Low Tide Water Level for each low tide
Time Range - for each high tide, I need the time elapsed since the preceding low tide
Time Range - for each low tide, I need the time elapsed since the preceding high tide
Tidal Range - for each high tide, I need the difference between the high and the preceding low tide
Tidal Range - for each low tide, I need the difference between the low and the preceding high tide
Rate of Tidal Movement - for each tidal change, I need the rate at which the tide changed (Tidal range divided by Time Range)
The area I need this for is Port Lincoln, South Australia and the PDF of the 2014 Tide Times for Port Lincoln is available from this page.
[url removed, login to view]
8 freelancers are bidding on average $57 for this job
Hi, I can do what you need. I' a former employee of Big-4 aufit firm employee and have 12 years of Excel experience, so I complete the job in a swift and accurate manner.
Hey I have 4 years of experience with Excel in advanced working environments. This would be a fun project to work on. Hope you accept my bid so we can get started on this!