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:-

Thursday, February 9, 2012

birthday ladies

happy birthday to Hjh Nani and Askinah

Brunei Prayer Times in Google public calendar

This is the google calendar for you to subscribe

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