* username: your AddThis username
Tuesday, February 28, 2012
Friday, February 24, 2012
Saturday, February 18, 2012
Tuesday, February 14, 2012
Saturday, February 11, 2012
Brunei Tides in Google public calendar
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
Friday, February 10, 2012
Thursday, February 9, 2012
Brunei Prayer Times in Google public calendar
This is the google calendar for you to subscribe
https://www.google.com/calendar/ical/9niq9o5l3al38qgf0ohll2v4bc%40group.calendar.google.com/public/basic.ics
This is how you link it to your outlook calendar (tip from howtogeek)
http://www.howtogeek.com/howto/18353/view-your-google-calendar-in-outlook-2010/
This is how I put everything together using ms-excel and ms-access:-
- download: brunei prayer times.xls.xls, brunei prayer times.accdb and an example of .csv file from this link - https://docs.google.com/open?id=0By9wZJZxlnqQMWRkNzBmOTgtZTFiMS00Y2QxLWEwZTEtOWEwNzEzMzJkMzJi
- source for prayer time is from http://www.information.gov.bn/
VER2/content/view/611/197/ - copy and paste the data (on monthly) to excel (i.e. brunei prayer times.xls), put additional columns for month and date (highlighted in yellow).
- then copy the whole data and paste in ms-access table called Sheet1 (i.e. brunei prayer times.accdb), remember to delete the table Sheet1 before paste.
- run query "z paste this query for google calendar output" and copy the data and paste it to excel and save it as .csv file (i.e. a.csv), import in google calendar
Subscribe to:
Posts (Atom)