No is a subset of yes?
from WTF Visualizations http://ift.tt/1r5q6Py
via IFTTT
Does your company know who gets the work done? I mean, really does the work. Not talks about it. Brags about it. Or in some cases, even lies about it. I am talking about actually delivering tangible results. How does your company measure productivity? Productivity: You’re Measuring It Wrong In the hasty pursuit of goals, […]
from Time Management Ninja http://ift.tt/1eRjFqQ
via IFTTT
Gumtree Seller/Scammer Gets Spammed With Entire Works of Shakespeare in Revenge
http://feedly.com/e/KxOlnl3J
—
via my feedly.com reader
In the previous series I showed you how to
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.
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.
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.
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
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.