Well it’s September now and this is my second post of the year!
It’s been a busy year but no excuses – I have neglected my blog. To make up for this I treated my blog to a new host. Gone are PlusNet and in are TSOHost.
I can’t recommend TSOHost highly enough. Within hours of me sending my backup to them they had migrated my blog and it was up and running and it’s MUCH faster! More importantly it’s back onto a supported software stack and it’s patched and up to date !
I have stacks of ideas for blog posts; specifically a series on using Tasker on android phones to send data to web forms , collating and analysing data in google spreadsheets then using web services to send data back to tasker to display a dashboard on your phone!
As an added bonus – previously some of my posts were password protected – these are now free and open!
One of my New Year resolutions was to keep in touch with more people.
I also need to clear out my contact list as there are lots of “old” and incomplete entries in my Google contacts list.
Ever the productivity geek I wanted to automate this. I ended up writing the following Google Apps Script:
I’m a huge fan of keeping my inbox empty, but not very good and keeping it that way.
I’m becoming more interested in the “Quantified Self” concept i.e. you can only fix things that you can measure.
The obvious answer is to monitor what my GMail inbox looks like on a daily basis. Continue reading
Social Media – there are so many sites out there all wanting my input.
There are so many other web sites that produce content that want me to read their content.
You can see what my plumbing looks like here.
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.
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
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)
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.
I’m a huge fan of Google Reader.
They recently introduced a “Send To” feature to allow you to share items with other users.
The one that was not included by default was Send To GMail !
Whoops, just noticed there is a big “EMail” button at the bottom of every article that does just this!