This is the google calendar for you to subscribe
This is how I put everything together using ms-excel:-
- Step 1:- Download the excel file from this link - https://docs.google.com/open?id=0By9wZJZxlnqQMGY5MDkyMjctMjY5Ny00NTcwLThkYjYtY2E3YTdkZDc4OWRk
- Step 2: Get the source data from http://www.marine.gov.bn/tide_forecast_information.htm
- Step 3: Copy the tide table (1 month data), paste in "Sheet 1", delete any empty columns, and click the macro "convert crosstab to list"
- Step 4: A new sheet will be generated. Copy the data and paste it in Sheet "For Calendar" - select your month and year.
- Step 5: Copy the data from the calendar sheet to a new sheet and save it as .csv file
- Step 6: Import the .csv file in google calendar