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 Is Procrastination Bad? The Truth About Procrastination Revealed 2 What to Do in Free Time? 20 Productive Ways to Use the Time 3 20 Time Management Tips to Super Boost Your Productivity 4 How to Take Notes: 3 Effective Note-Taking Techniques 5 How to Stay Motivated and Reach Your Big Goals in Life

    Read Next

    Advertising
    Advertising
    Advertising

    Last Updated on March 31, 2020

    Is Procrastination Bad? The Truth About Procrastination Revealed

    Is Procrastination Bad? The Truth About Procrastination Revealed

    Procrastination is very literally the opposite of productivity. To produce something is to pull it forward, while to procrastinate is to push it forward — to tomorrow, to next week, or ultimately to never.

    Procrastination fills us with shame — we curse ourselves for our laziness, our inability to focus on the task at hand, our tendency to be easily led into easier and more immediate gratifications. And with good reason: for the most part, time spent procrastinating is time spent not doing things that are, in some way or other, important to us.

    There is a positive side to procrastination, but it’s important not to confuse procrastination at its best with everyday garden-variety procrastination.

    Sometimes — sometimes! — procrastination gives us the time we need to sort through a thorny issue or to generate ideas. In those rare instances, we should embrace procrastination — even as we push it away the rest of the time.

    Why We Procrastinate After All?

    We procrastinate for a number of reasons, some better than others. One reason we procrastinate is that, while we know what we want to do, we need time to let the ideas “ferment” before we are ready to sit down and put them into action.

    Some might call this “creative faffing”; I call it, following copywriter Ray Del Savio’s lead, “concepting”.[1]

    Whatever you choose to call it, it’s the time spent dreaming up what you want to say or do, weighing ideas in your mind, following false leads and tearing off on mental wild goose chases, and generally thinking things through.

    Advertising

    To the outside observer, concepting looks like… well, like nothing much at all. Maybe you’re leaning back in your chair, feet up, staring at the wall or ceiling, or laying in bed apparently dozing, or looking out over the skyline or feeding pigeons in the park or fiddling with the Japanese vinyl toys that stand watch over your desk.

    If ideas are the lifeblood of your work, you have to make time for concepting, and you have to overcome the sensation— often overpowering in our work-obsessed culture — that faffing, however creative, is not work.

    Is Procrastination Bad?

    Yes it is.

    Don’t fool yourself into thinking that you’re “concepting” when in fact you’re just not sure what you’re supposed to be doing.

    Spending an hour staring at the wall while thinking up the perfect tagline for a marketing campaign is creative faffing; staring at the wall for an hour because you don’t know how to come up with a tagline, or don’t know the product you’re marketing well enough to come up with one, is just wasting time.

    Lack of definition is perhaps the biggest friend of your procrastination demons. When we’re not sure what to do — whether because we haven’t planned thoroughly enough, we haven’t specified the scope of what we hope to accomplish in the immediate present, or we lack important information, skills, or resources to get the job done.

    It’s easy to get distracted or to trick ourselves into spinning our wheels doing nothing. It takes our mind off the uncomfortable sensation of failing to make progress on something important.

    Advertising

    The answer to this is in planning and scheduling. Rather than giving yourself an unspecified length of time to perform an unspecified task (“Let’s see, I guess I’ll work on that spreadsheet for a while”) give yourself a limited amount of time to work on a clearly defined task (“Now I’ll enter the figures from last months sales report into the spreadsheet for an hour”).

    Giving yourself a deadline, even an artificial one, helps build a sense of urgency and also offers the promise of time to “screw around” later, once more important things are done.

    For larger projects, planning plays a huge role in whether or not you’ll spend too much time procrastinating to reach the end reasonably quickly.

    A good plan not only lists the steps you have to take to reach the end, but takes into account the resources, knowledge and inputs from other people you’re going to need to perform those steps.

    Instead of futzing around doing nothing because you don’t have last month’s sales report, getting the report should be a step in the project.

    Otherwise, you’ll spend time cooling your heels, justifying your lack of action as necessary: you aren’t wasting time because you want to, but because you have to.

    How Bad Procrastination Can Be

    Our mind can often trick us into procrastinating, often to the point that we don’t realize we’re procrastinating at all.

    Advertising

    After all, we have lots and lots of things to do; if we’re working on something, aren’t we being productive – even if the one big thing we need to work on doesn’t get done?

    One way this plays out is that we scan our to-do list, skipping over the big challenging projects in favor of the short, easy projects. At the end of the day, we feel very productive: we’ve crossed twelve things off our list!

    That big project we didn’t work on gets put onto the next day’s list, and when the same thing happens, it gets moved forward again. And again.

    Big tasks often present us with the problem above – we aren’t sure what to do exactly, so we look for other ways to occupy ourselves.

    In many cases too, big tasks aren’t really tasks at all; they’re aggregates of many smaller tasks. If something’s sitting on your list for a long time, each day getting skipped over in favor of more immediately doable tasks, it’s probably not very well thought out.

    You’re actively resisting it because you don’t really know what it is. Try to break it down into a set of small tasks, something more like the tasks you are doing in place of the one big task you aren’t doing.

    More consequences of procrastination can be found in this article: 8 Dreadful Effects of Procrastination That Can Destroy Your Life

    Advertising

    Procrastination, a Technical Failure

    Procrastination is, more often than not, a sign of a technical failure, not a moral failure.

    It’s not because we’re bad people that we procrastinate. Most times, procrastination serves as a symptom of something more fundamentally wrong with the tasks we’ve set ourselves.

    It’s important to keep an eye on our procrastinating tendencies, to ask ourselves whenever we notice ourselves pushing things forward what it is about the task we’ve set ourselves that simply isn’t working for us.

    Learn more about how to fix your procrastination problem here: What Is Procrastination and How to Stop It (The Complete Guide)

    Featured photo credit: chuttersnap via unsplash.com

    Reference

    Read Next