Categories
Uncategorized

Gumtree Seller/Scammer Gets Spammed With Entire Works of Shakespeare in Revenge feedly

Gumtree Seller/Scammer Gets Spammed With Entire Works of Shakespeare in Revenge
http://feedly.com/e/KxOlnl3J


via my feedly.com reader

Categories
Uncategorized

Test Post

I’m just testing a new feature – nothing to see here : yet !

Categories
Quantified Self Technology

Quantified Self – Google And Android – Reporting

In the previous series I showed you how to

  • capture your data automatically,
  • collate and summarise your data.

Now it is time to show you how you can extract this information, with the final goal being the ability to get your (android in this case)phone polling for the data, and using it to make decisions.

In order to do this we will be using:

Google Apps Script (GAS) javascript functions to obtain values from the Google Spreadsheet where your data lives.

Google Web Services to provide a web interface to call the function and return the data over the internet.

Tasker to provide a programmatic interface on your phone to call the web service, handle the resulting data and do “something” with it.

Minimalistic Text to display the output on the home screen of your phone.

Categories
Quantified Self

Quantified Self – Google And Android – Aggregation

In this post I’m going to show you how to consolidate and aggregate your data easily between Google SpreadSheets.

To implement this I’ll be using Google SpreadSheets and SQL.

Categories
Quantified Self

Quantified Self – Google And Android – Capture

In this post I’m going to show you how to implement a data capture system that will allow you to get your data easily into Google SpreadSheets. In my case I need this to be enabled from my Android phone but once you see the method you will see how it can be extended to other applications.

To implement this I’ll be using Google Forms, Google SpreadSheets and Tasker.

Categories
Quantified Self

Quantified Self – Google And Android

Working as a Business Intelligence consultant I work with numbers every day and have to deliver benefit from them. I also do the same in my personal life, I LOVE my FitBit, and have macros that pull my stats out using the FitBit API and store it in a Google SpreadSheet and then aggregate the data and publish it to my dashboard.

This works fine for my automatically captured data, I needed a solution for more manual data points. I wanted a way to be able to capture data on my phone, store the data in Google SpreadSheets so that I can integrate it with my existing data and then send a summary spreadsheet back to my Android phone.

I will break the steps down in the following series of posts:

Quantified Self – Google And Android – Capture

Quantified Self – Google And Android – Aggregation

Quantified Self – Google And Android – Reporting

 

Categories
Microsoft Office Productivity Technology

Useful Outlook Macros

Quite often I want to create a task immediately off the back of sending an e-mail – usually to remind me to follow up with the recipient after a period of time. I created a macro to do this rather than having to remember to go into tasks and do this manually – better to keep the flow rather than having to remember the steps.

Categories
This Site Wordpress

I’m Back – And Faster !

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!

Enjoy

Categories
Productivity Technology

Contacts – Keep In Touch or Update Details

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:

Categories
Microsoft Misc Office Productivity Technology Work

Add Reminders To Outlook Appointments

A Reminder
Creative Commons License photo credit: Andrew Coulter Enright

If like me your Outlook calendar can get a bit hectic and others can add meetings to your calendar sometimes you end up simply “reacting” to your schedule and jumping from one appointment to the next on “autopilot”. It’s at times like these that Outlook’s ability to create a reminder can save your dignity.

However, sometimes the meeting organiser does not set a reminder. I have created an Outlook macro that will look for incoming meeting requests, without a reminder set and give you the option to set a reminder.