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

    Joel Falconer

    Editor, content marketer, product manager and writer with 12+ years of experience in the startup, design and tech digital media industries.

    How to Master the Art of Prioritization 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

    Trending in Featured

    1 How to Become an Early Riser and Stay Energetic 2 50 Ways to Increase Productivity and Achieve More in Less Time 3 20 Time Management Tips to Super Boost Your Productivity 4 How to Cultivate Continuous Learning to Stay Competitive 5 Simple Productivity: 10 Ways to Do More by Focusing on the Essentials

    Read Next

    Advertising
    Advertising
    Advertising

    Last Updated on November 19, 2019

    How to Become an Early Riser and Stay Energetic

    How to Become an Early Riser and Stay Energetic

    When you become an early riser, you’ll experience a lot of benefits including feeling more energized and having more time to do what you want.

    If you’d like to become an early riser, there are some things you should know before you run off to set your oft-ignored alarm clock.

    So how to become an early riser?

    Here are five tips I’ve discovered to be most helpful in making the transition from erratic sleeper to early morning wizard:

    1. Choose to Get up Before You Go to Sleep

    You’re not very good at making decisions when you’ve just woken up. You were in the middle of a dream in which [insert celebrity crush of choice here] is serving you breakfast in bed only to be rudely awakened by the harsh tones of your alarm clock. You’re frustrated, angry, confused, and surprised. This is not the time to be making decisions about whether or not you should stay in bed! And yet, most of us leave the first decision of our day to be made in a blur of partial wakefulness.

    Advertising

    No more!

    If you want to be a consistently early riser, try making your decision to rise at a specific time before you go to sleep the night before. This frees you from making the decision in the morning when you’ve just woken up. Instead of making a decision, you have only to follow through on your decision from the night before.

    Easier said than done? Of course. But only for the first few times. Eventually, your need for raw willpower to get out of bed will diminish and you’ll be the proud parent of a new habit!

    Steve Pavlina suggests you practice getting out of bed during the day[1] to get a few of the “practice sessions” out of the way without the early morning fog in your head.

    2. Have a Plan for Your Extra Time

    Let’s say you’ve actually made it out of bed 2 hours before you normally would. Now what? What are you going to do with all this time you’ve discovered in your day?

    Advertising

    If you don’t have something planned to do with your extra time, you risk falling for the temptation of a “morning nap” that wipes out all the work you put into getting up.

    What to do? Before you go to bed, make a quick note of what you’d like to get done during your extra hours the following day. Do you have a book to write, paper to read, or garage to clean? Make a plan for your early hours and you’ll do more than protect yourself from backsliding into bed.

    You’ll get things done and those results will fuel your desire to build rising early into a habit!

    3. Make Rising Early a Social Activity

    Your internet or social media buddies just don’t have enough pull to make your new habit stick in the long term. The same cannot be said for the people you spend time with as part of your early morning routine.

    Sure, you could choose to read blogs for two hours every morning. But wouldn’t it be great to join an early breakfast club, running group, or play chess in the park at 5am?

    Advertising

    The more people you get involved in making your new habit a daily part of your life, the easier it’ll be to succeed.

    4. Don’t Use an Alarm That Makes You Angry

    If we’re all wired differently, why do we all insist on torturing ourselves with the same sort of alarm each morning?

    I spent years trying to wake up before my alarm went off so I wouldn’t have to hear it. I got pretty good, too. Then I started using a cellphone as my alarm clock and quickly realized that different ring tones irritated me less but worked just as well to wake me up. I now use the ring tone alarm as a back up for my bedside lamp plugged in to a timer.

    When the bright light doesn’t work, the cellphone picks up the slack and I wake up on time. The lesson learned? Experiment a bit and see what works best for you. Light, sound, smells, temperature, or even some contraption that dumps water on you might be more pleasant than your old alarm clock. Give something new a try!

    5. Get Your Blood Flowing Right After Waking

    If you don’t have a neighbor, you can pick fights with at 5am, you’ll have to settle with a more mundane exercise. It doesn’t take much to get your blood flowing and chase the sleep from your head.

    Advertising

    Just pick something you don’t mind doing and go through the motions until your heart rate is up. Jumping rope, push-ups, crunches, or a few minutes of yoga are typically enough to do the trick. (Just don’t do anything your doctor hasn’t approved.)

    If you live in a beautiful part of the world like me, you might want to use a bit of your early morning to go for a walk and enjoy the beauty of the world around you.

    If you have a coffee shop open within walking distance, dragging yourself out of bed for a cup of coffee to savor on your walk home as the world wakes around you is a wonderful experience. Try it!

    More to Power Up Your Day

    Featured photo credit: Nomadic Julien via unsplash.com

    Reference

    Read Next