Advertising
Advertising

The Humble Spreadsheet: A Tool for the True Lifehacker

The Humble Spreadsheet: A Tool for the True Lifehacker

    When I was very young—I can’t remember how old, but let’s call it six or seven—I was introduced to spreadsheets. It introduced me to the world of statistics, of using data to track progress and predict the future, to work towards tangible, measurable goals instead of lofty, obtuse and too-often forgotten resolutions that people so often make about a month from now each year.

    I have my father to thank for this, a mindset and skill I consider vital to the successes I’ve had in many areas of my life, most especially those areas of my life that have to do with business and money. Each evening we’d go for a run, a habit that unfortunately didn’t stick as well as the interest in statistics, and when we got home we’d track the various details on some ancient (well, not at the time) and hefty Apple computer.
    I was fascinated to see how the data changed over time. How our best times improved—now doubt they would’ve looked different if a kid wasn’t tagging along!—and progress could be seen, right there, in solid numbers.

    The spreadsheet is often looked at as purely the realm of accountants, businessmen, and sometimes, for those smart enough to have one, the family budget. But that’s not the spreadsheet’s only utility. Not by a long shot! You can use spreadsheets in many aspects of your lifehacking and personal development.

    Advertising

    1. Budgeting and Expense Tracking

    We’ll start off by looking at something that doesn’t veer too far from the traditional domain of the spreadsheet—money. It’s an area that many people are looking to deal with in their lives. Spending gets out of control, bills come in with figures higher than the figure in your bank account, and without proper money management, life is the pits.

    But a spreadsheet, better configured to your own circumstances than any watered-down software application, can help anyone solve their money problems. You can see where the income comes in and how much of it there is, track where it disappears, and see how much you really have to spend once both your bills and savings have been taken into account.

    If you can see in black and white on your screen that you only have X amount of money left each week after your requisite expenses have been dealt with, it’s easy to stay in control. Figures can and do provide that extra bit of discipline and insight you may need.

    2. Exercise & Fitness

    As I mentioned, my first encounter with spreadsheets had nothing to do with money, but fitness. It’s great and truly motivating to see how your fitness level is improving in a tangible way. But it’s not just a self-lovefest, either; that insight allows you to plan for increased fitness. You can see how much you’re capable of improving over a given amount of time, and create a plan based on that ability to adapt that’ll take you to the next level.

    Advertising

    You’ll be able to determine a goal—whether that’s a best time you’d like to achieve or a certain amount of weight you’d like to be able to lift—and work towards on it on a truly achievable schedule. And as the cycle continues, you’ll reap the motivation to continue your fitness plan by seeing the numbers improve before your eyes.

    3. Nutrition

    I’ve heard it said that calorie counting is so eighties, but really, if you throw the stupid fad diets away, what is weight loss if it’s not burning more calories than you take in? You have to put yourself into calorie deficit or loss just won’t occur; that’s a fact. The trouble is often with determining how to put yourself into calorie deficit in a sensible way.

    With a spreadsheet, a knowledge of how many calories are in what you’re eating, and the tools available to figure out how much your body burns on its own, you can track your calorie intake and weight loss. By tracking your progress with numbers rather than a mere visual check on your waistline, you can make sure you’re losing weight. Again, you can use that data to make adjustments to your plan so it works better—losing weight the smart way without resorting to extreme and unhealthy measures.

    The same goes with gaining weight, or just eating right in general if you’ve got a specific plan that can be calculated with numbers of some kind.

    Advertising

    4. Productivity

    There are so many methods of tracking productivity out there it’s not funny. Some are ridiculously complicated and some are incredibly simple. If you use a GTD system where everything is captured as a task (if you’re doing it properly), you can see how many of those tasks you are completing and how many you’re not. You can tell when you’re getting dangerously close to unacceptable procrastination, or when you’re really on a roll.

    If your goal is to get more done in less time, you can track your working hours and see whether your hours-worked to tasks-completed ratio is getting better or worse. This gives you insight enabling you to figure out where your time-wasters are and maximize the productivity of each hour you’ve assigned for working.

    Whether you suffer from workaholicism or procrastination, then data can help—many problems occur when you just don’t know what’s going on.

    Spreadsheets Aren’t So Boring After All

    Where there’s a need for data, a spreadsheet can be your best friend. We’ve just had a baby daughter who sometimes has trouble feeding and data is essential to ensuring that she’s getting enough food often enough, and gaining enough weight, and so far that data has helped immensely; she’s been on an upward spiral. If anything goes to show that spreadsheets are infinitely versatile, as far as I’m concerned, that’s the proof.

    Advertising

    At sites I manage like AudioJungle, I use spreadsheets to ensure that we’re experiencing true growth on all fronts and not just getting hopeful over heightened statistics in one category. That data has helped make many smart business decisions before anything bad happened to us. That’s a pretty typical use for sheets, contrary to the unusual one I just mentioned.

    I’ve barely scratched the surface. How do you—or could you—use spreadsheets to get better results from life?

    More by this author

    The Importance of Scheduling Downtime How to Make Decisions Under Pressure 11 Free Mind Mapping Applications & Web Services How to Use Parkinson’s Law to Your Advantage 19 Free GTD Apps for Windows, Mac & Linux

    Trending in Featured

    1 8 Replacements for Google Notebook 2 22 Tips for Effective Deadlines 3 How to Get out of a Rut: 12 Useful Ways to Get Unstuck 4 15 Ways to Cultivate Lifelong Learning for a Sharper Brain 5 How to Get Promoted When You Feel Stuck in Your Current Position

    Read Next

    Advertising
    Advertising
    Advertising

    Last Updated on May 14, 2019

    8 Replacements for Google Notebook

    8 Replacements for Google Notebook

    Exploring alternatives to Google Notebook? There are more than a few ‘notebooks’ available online these days, although choosing the right one will likely depend on just what you use Google Notebook for.

    1. Zoho Notebook
      If you want to stick with something as close to Google Notebook as possible, Zoho Notebook may just be your best bet. The user interface has some significant changes, but in general, Zoho Notebook has pretty similar features. There is even a Firefox plugin that allows you to highlight content and drop it into your Notebook. You can go a bit further, though, dropping in any spreadsheets or documents you have in Zoho, as well as some applications and all websites — to the point that you can control a desktop remotely if you pare it with something like Zoho Meeting.
    2. Evernote
      The features that Evernote brings to the table are pretty great. In addition to allowing you to capture parts of a website, Evernote has a desktop search tool mobil versions (iPhone and Windows Mobile). It even has an API, if you’ve got any features in mind not currently available. Evernote offers 40 MB for free accounts — if you’ll need more, the premium version is priced at $5 per month or $45 per year. Encryption, size and whether you’ll see ads seem to be the main differences between the free and premium versions.
    3. Net Notes
      If the major allure for Google Notebooks lays in the Firefox extension, Net Notes might be a good alternative. It’s a Firefox extension that allows you to save notes on websites in your bookmarks. You can toggle the Net Notes sidebar and access your notes as you browse. You can also tag websites. Net Notes works with Mozilla Weave if you need to access your notes from multiple computers.
    4. i-Lighter
      You can highlight and save information from any website while you’re browsing with i-Lighter. You can also add notes to your i-Lighted information, as well as email it or send the information to be posted to your blog or Twitter account. Your notes are saved in a notebook on your computer — but they’re also synchronized to the iLighter website. You can log in to the site from any computer.
    5. Clipmarks
      For those browsers interested in sharing what they find with others, Clipmarks provides a tool to select clips of text, images and video and share them with friends. You can easily syndicate your finds to a whole list of sites such as Facebook, Twitter and Digg. You can also easily review your past clips and use them as references through Clipmarks’ website.
    6. UberNote
      If you can think of a way to send notes to UberNote, it can handle it. You can clip material while browsing, email, IM, text message or even visit the UberNote sites to add notes to the information you have saved. You can organize your notes, tag them and even add checkboxes if you want to turn a note into some sort of task list. You can drag and drop information between notes in order to manage them.
    7. iLeonardo
      iLeonardo treats research as a social concern. You can create a notebook on iLeonardo on a particular topic, collecting information online. You can also access other people’s notebooks. It may not necessarily take the place of Google Notebook — I’m pretty sure my notes on some subjects are cryptic — but it’s a pretty cool tool. You can keep notebooks private if you like the interface but don’t want to share a particular project. iLeonardo does allow you to follow fellow notetakers and receive the information they find on a particular topic.
    8. Zotero
      Another Firefox extension, Zotero started life as a citation management tool targeted towards academic researchers. However, it offers notetaking tools, as well as a way to save files to your notebook. If you do a lot of writing in Microsoft Word or Open Office, Zotero might be the tool for you — it’s integrated with both word processing software to allow you to easily move your notes over, as well as several blogging options. Zotero’s interface is also available in more than 30 languages.

    I’ve been relying on Google Notebook as a catch-all for blog post ideas — being able to just highlight information and save it is a great tool for a blogger.

    Advertising

    In replacing it, though, I’m starting to lean towards Evernote. I’ve found it handles pretty much everything I want, especially with the voice recording feature. I’m planning to keep trying things out for a while yet — I’m sticking with Google Notebook until the Firefox extension quits working — and if you have any recommendations that I missed when I put together this list, I’d love to hear them — just leave a comment!

    Advertising

    Advertising

    Read Next