![]() Let’s get started with some advanced data processing with Google Sheets! Time Tracking and Passive Computer Usage from RescueTime Finally, once we’ve done the hard technical work of data processing and data preparation, you’ll discover how easy it is to do some personal data analysis using pivot tables and charts and graphs. I’ll show you how to use array formulas to process columns of data in bulk. You’ll learn how to add and leverage custom code with Google App Scripts to extract information and do calculations. The goal of this post show you some advanced functions for data processing inside Google Sheets. We are turning our tracking data into improved self-understanding. Finally, we will use some simple pivot tables and charts to do some personal data analysis. We will use some custom functions in Google Sheets to create some time dimensions from our date field. We will then leverage some code in Google App Script to process and prepare our data. First, we will use IFTTT for data collection from RescueTime into Google Sheets. In this post, I want to walkthrough setting up a simple time tracking dashboard with RescueTime, IFTTT and Google Sheets. Over time I discovered how time tracking made me conscious of my time usage, I learned to use time data in my weekly reviews and even explored a year of time tracking too. Personally, I started to track using time tracking tools when I become a freelance developer several years. I see a lot of value in time tracking and time data. In turn, the ubiquity of Google Sheets means it’s easy to then pull data from there into your favorite visualization tools like Google Data Studio, Tableau or Plot.ly. Once your data is in Google Sheets, you can leverage custom functions and App Script to process and prepare that data. That way all of your data is stored into Google Sheets for easy access and even simple data visualization and data analysis. ![]() ![]() While you can use manual exports or code like QS Ledger to collect data from different tracking services, an automation service like IFTTT can automate the data collection. Increasingly I’ve been using various automation services as one of my data collection methods. But how to collect your data and what to do with all that data once you get it? It’s a great passive way to know where your time is going on your computer. I don’t need to document it, but the option is there and could come in handy depending on your needs.RescueTime is one of my favorite ways to track my life. I spend an average of 10 hours doing group and individual coaching and 5-10 hours writing per week. Rescuetime also allows you to manually add your offline work activity as well, I obviously do not track my offline time. You can see that it shows me my week at a glance and let’s me run reports, check my productivity and my progress. At the end of the week, you will receive a full report of exactly how you spent your time, if you spent time on things that weren’t productive and every little detail in between.īelow is my Rescuetime dashboard. Rescuetime will silently document how you spend your time for you. Today I’m showing you how I use a brilliant tool called Rescuetime. You can download it, and it runs in the background of your computer. So instead of busting out a spreadsheet and writing down how you spend your day (seriously, I’m depressed even writing that sentence) we want to automate it. When doing anything in life or business, you want to make it as easy as possible to succeed. How to Work Less & Do More 1. Make it Easy and Automate
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |