Monthly Archives: April 2010

Google Spreadsheet & SQL Queries

Learning SQL
Creative Commons License photo credit: therefromhere
I am a big fan of Google Spreadsheets, they give you most of the features of a desktop “office” based spreadsheet but your data is stored online, no more need to carry your data on a USB stick.
I’m also a huge fan of databases, SQL is a fantastic tool for querying data.
Now you can combine the best of both worlds: store your data in a spreadsheet and then summarise the data using SQL.
Continue reading

Marathon Training Update

how about this one
Creative Commons License photo credit: damianromero

Parkrun

Last Saturday (10th April) saw the the launch of the Strathclyde Park Parkrun.
After recieving so much encouragement from the folks at the Glasgow Parkrun I decided to give something back and volunteer to help. This is a win-win situation as I can run the ~4 miles from home to the park run, help out then run home so I’m doing my good deed for the day AND getting a run in !

Injury

Unfortunately on my run home after just 2 miles I got to experience just how bad “shin splints” are!
My other half was working so I had to hobble the last two miles home where the kids were great keeping me supplied with frozen peas.
To try and speed my recovery: 5 weeks until Edinburgh marathon (donate here: http://www.JustGiving.com/26Miles4CHAS) I did not do any running at all.

I’m Back!

It’s only a tiny niggle now so I thought I would brave a wee short run: 3 miles, Chatelherault and back. My time was “down” but no new or reoccurrence of any injuries. Despite having wun ~25 miles in my new shoes I have swapped back to my old ones “just in case”, and I’ll stick with them until post Edinburgh.
Hopefully a week of short runs will set me up for a longer run at the weekend then I’ll get back on track.

Google Calendar Sync – Auto Run

A nice quick hint.

I kept forgetting to start Google Calendar Sync when I started Outlook. I don’t always start Outlook when I start my laptop and I’m not always online when I run Outlook so puting it in my Startup folder is not really an option.
My solution, a macro that runs when Outlook starts that gives me the option of running Google Calendar Sync if I feel it’s appropriate.

Private Sub Application_Startup()
Dim response As Integer
Dim RetVal
op
response = MsgBox(prompt:=”Do you want to run Google Calendar Sync?”, buttons:=vbYesNo)

If response = vbYes Then
RetVal = Shell(“C:\Program Files\Google\Google Calendar Sync\GoogleCalendarSync.exe”, vbMinimizedNoFocus)
End If

End Sub

NOTE: WordPress seems to “prettyfy” the quotes so when copying the code above it is better to delete and retype the quotation marks in your code editor of choice.

Edinburgh Marathon Training Update

yellow
Creative Commons License photo credit: darkmatter
It’s been a while since I have written anything so apologies in advance about the length!

Marathon Team Update

Start with the good news: as of today the fundraising total hit £300 which is great but the marathon is no sprint, so lots more time (6 weeks gulp) to go. http://www.justgiving.com/26miles4chas
The not so good news: unfortunately Paul has had to pull out of the Edinburgh Marathon due to an injury he has picked up during training.
The better news: Paul has agreed to competitively run the distance of the marathon before the end of the year. Due to this, we will be keeping the fundraising page open until the end of the year so you can show your support.
Continue reading

Last updated by at .