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.

    3 Simple Strategies for Dealing With External Distractions How to Use Parkinson’s Law to Get More Done in Less Time How to Master the Art of Prioritization the Right Way The Importance of Scheduling Downtime How to Make Decisions Under Pressure

    Trending in Featured

    1 15 Tips to Restart the Exercise Habit (and How to Keep It) 2 8 Simple Ways to Be a Better Listener 3 The Art of Humble Confidence 4 How to Learn Something New Every Day and Stay Smart 5 How to Overcome Procrastination and Start Doing What Truly Matters

    Read Next

    Advertising
    Advertising
    Advertising

    Last Updated on November 18, 2020

    15 Tips to Restart the Exercise Habit (and How to Keep It)

    15 Tips to Restart the Exercise Habit (and How to Keep It)

    It’s okay, you can finally admit it. It’s been two months since you’ve seen the inside of the gym. Getting sick, family crisis, overtime at work and school papers that needed to get finished all kept you for exercising. Now, the question is: how do you start again?
    Once you have an exercise habit, it becomes automatic. You just go to the gym, there is no force involved. But after a month, two months or possibly a year off, it can be hard to get started again. Here are some tips to climb back on that treadmill after you’ve fallen off.

    1. Don’t Break the Habit – The easiest way to keep things going is simply not to stop. Avoid long breaks in exercising or rebuilding the habit will take some effort. This may be advice a little too late for some people. But if you have an exercise habit going, don’t drop it at the first sign of trouble.
    2. Reward Showing Up – Woody Allen once said that, “Half of life is showing up.” I’d argue that 90% of making a habit is just making the effort to get there. You can worry about your weight, amount of laps you run or the amount you can bench press later.
    3. Commit for Thirty Days – Make a commitment to go every day (even just for 20 minutes) for one month. This will solidify the exercise habit. By making a commitment you also take pressure off yourself in the first weeks back of deciding whether to go.
    4. Make it Fun – If you don’t enjoy yourself at the gym, it is going to be hard to keep it a habit. There are thousands of ways you can move your body and exercise, so don’t give up if you’ve decided lifting weights or doing crunches isn’t for you. Many large fitness centers will offer a range of programs that can suit your tastes.
    5. Schedule During Quiet Hours – Don’t put exercise time in a place where it will easily be pushed aside by something more important. Right after work or first thing in the morning are often good places to put it. Lunch-hour workouts might be too easy to skip if work demands start mounting.
    6. Get a Buddy – Grab a friend to join you. Having a social aspect to exercising can boost your commitment to the exercise habit.
    7. X Your Calendar – One person I know has the habit of drawing a red “X” through any day on the calendar he goes to the gym. The benefit of this is it quickly shows how long it has been since you’ve gone to the gym. Keeping a steady amount of X’s on your calendar is an easy way to motivate yourself.
    8. Enjoyment Before Effort – After you finish any work out, ask yourself what parts you enjoyed and what parts you did not. As a rule, the enjoyable aspects of your workout will get done and the rest will be avoided. By focusing on how you can make workouts more enjoyable, you can make sure you want to keep going to the gym.
    9. Create a Ritual – Your workout routine should become so ingrained that it becomes a ritual. This means that the time of day, place or cue automatically starts you towards grabbing your bag and heading out. If your workout times are completely random, it will be harder to benefit from the momentum of a ritual.
    10. Stress Relief – What do you do when your stressed? Chances are it isn’t running. But exercise can be a great way to relieve stress, releasing endorphin which will improve your mood. The next time you feel stressed or tired, try doing an exercise you enjoy. When stress relief is linked to exercise, it is easy to regain the habit even after a leave of absence.
    11. Measure Fitness – Weight isn’t always the best number to track. Increase in muscle can offset decreases in fat so the scale doesn’t change even if your body is. But fitness improvements are a great way to stay motivated. Recording simple numbers such as the number of push-ups, sit-ups or speed you can run can help you see that the exercise is making you stronger and faster.
    12. Habits First, Equipment Later – Fancy equipment doesn’t create a habit for exercise. Despite this, some people still believe that buying a thousand dollar machine will make up for their inactivity. It won’t. Start building the exercise habit first, only afterwards should you worry about having a personal gym.
    13. Isolate Your Weakness – If falling off the exercise wagon is a common occurrence for you, find out why. Do you not enjoy exercising? Is it a lack of time? Is it feeling self-conscious at the gym? Is it a lack of fitness know-how? As soon as you can isolate your weakness, you can make steps to improve the situation.
    14. Start Small – Trying to run fifteen miles your first workout isn’t a good way to build a habit. Work below your capacity for the first few weeks to build the habit. Otherwise you might scare yourself off after a brutal workout.
    15. Go for Yourself, Not to Impress – Going to the gym with the only goal of looking great is like starting a business with only the goal to make money. The effort can’t justify the results. But if you go to the gym to push yourself, gain energy and have a good time, then you can keep going even when results are slow.

    Read Next