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

    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 32 Hacks for Sticking to Your Budget

    Trending in Featured

    1 How to Motivate Yourself: 13 Simple Ways You Can Try Right Now 2 15 Ways to Cultivate Lifelong Learning for a Sharper Brain 3 How to Overcome Procrastination and Start Doing What Truly Matters 4 10 Key Characteristics of a Highly Successful Entrepreneur 5 Why Do I Have Bad Luck? 2 Simple Things to Change Your Destiny

    Read Next

    Advertising
    Advertising

    Last Updated on October 30, 2018

    How to Motivate Yourself: 13 Simple Ways You Can Try Right Now

    How to Motivate Yourself: 13 Simple Ways You Can Try Right Now

    Who needs Tony Robbins when you can motivate yourself? Overcoming the emotional hurdle to get stuff done when you’d rather sit on the couch isn’t always easy. But unless calling in sick and waking up at noon have no consequences for you, it’s often a must.

    For those of you who never procrastinate, distract yourself or drag your feet when you should be doing something important, well done so far! But for the rest of you, it’s good to have a library of motivational boosters to move along.

    Whether you’re starting a buisiness, trying to los weight or breaking a bad habit, you’ll learn how to motivate yourself with different techniques in this article.

    13 Simple Ways to Motivate Yourself Right Now

    Despite your best efforts, passion, habits and a flow-producing environment can fail. In that case, it’s time to find whatever emotional pump-up you can use to get started:

    1. Go back to “why”

    Focusing on a dull task doesn’t make it any more attractive. Zooming out and asking yourself why you are bothering in the first place will make it more appealing.

    If you can’t figure out why, then there’s a good chance you shouldn’t bother with it in the first place.

    2. Go for five

    Start working for five minutes. Often that little push will be enough to get you going.

    3. Move around

    Get your body moving as you would if you were extremely motivated to do something. This ‘faking it’ approach to motivation may seem silly or crude but it works.

    Advertising

    4. Find the next step

    If it seems impossible to work on a project for you, you can try to focus on the next immediate step.

    Fighting an amorphous blob of work will only cause procrastination. Chunk it up so that it becomes manageable. Learn how to stop procrastinating in this guide.

    5. Find your itch

    What is keeping you from working? Don’t let the itch continue without isolating it and removing the problem.

    Are you unmotivated because you feel overwhelmed, tired, afraid, bored, restless or angry? Maybe it is because you aren’t sure you have time or delegated tasks haven’t been finished yet?

    6. Deconstruct your fears

    I’m sure you don’t have a phobia about getting stuff done. But at the same time, hidden fears or anxieties can keep you from getting real work completed.

    Isolate the unknowns and make yourself confident, you can handle the worst case scenario.

    7. Get a partner

    Find someone who will motivate you when you’re feeling lazy. I have a friend I go to the gym with. Besides spotting weight, having a friend can help motivate you to work hard when you’d normally quit.

    8. Kickstart your day

    Plan out tomorrow. Get up early and place all the important things early in the morning. Building momentum early in the day can usually carry you forward far later.

    Advertising

    Having a morning routine is a good idea for you to stay motivated!

    9. Read books

    Read not just self-help or motivational books but any book that has new ideas. New ideas get your mental gears turning and can build motivation. Here’re more reasons to read every day.

    Learning new ideas puts your brain in motion so it requires less time to speed up to your tasks.

    10. Get the right tools

    Your environment can have a profound effect on your enthusiasm. Computers that are too slow, inefficient applications or a vehicle that breaks down constantly can kill your motivation.

    Building motivation is almost as important as avoiding the traps that can stop it.

    11. Be careful with the small problems

    The worst killer of motivation is facing a seemingly small problem that creates endless frustration.

    Reframe little problems that must be fixed as bigger ones or they will kill any drive you have.

    12. Develop a mantra

    Find a few statements that focus your mind and motivate you. It doesn’t matter whether they are pulled from a tacky motivational poster or just a few words to tell you what to do.

    Advertising

    If you aren’t sure where to start, a good personal mantra is “Do it now!” You can find more here too: 7 Empowering Affirmations That Will Help You Be Mentally Strong

    13. Build on success

    Success creates success. When you’ve just won, it is easy to feel motivated about almost anything. Emotions tend not to be situation specific, so a small win, whether it is a compliment from a colleague or finishing two thirds of your tasks before noon can turn you into a juggernaut.

    There are many ways you can place small successes earlier on to spur motivation later. Structuring your to-do lists, placing straightforward tasks such as exercising early in the day or giving yourself an affirmation can do the trick.

    How to Stay Motivated Forever (Without Motivation Tricks)

    The best way to motivate yourself is to organize your life so you don’t have to. If work is a constant battle for you, perhaps it is time to start thinking about a new job. The idea is that explicit motivational techniques should be a backup, not your regular routine.

    Here are some other things to consider making work flow more naturally:

    Passion

    Do things you have a passion for. We all have to do things we don’t want to. But if life has become a chronic source of dull chores, you’ve got a big problem that needs fixing.

    Not sure what your passion is to get you motivated? This will help you:

    How to Get Motivated and Be Happy Every Day When You Wake Up

    Advertising

    Habits

    You can’t put everything on autopilot. I’ve found putting a few core habits in place creates a structure for the day.

    Waking up at the same time, working at the same times and having a similar productive routine makes it easier to do the next day.

    This guide will be useful for you if you’re looking to build good habits:

    Understand Your Habits to Control Them 100%

    Flow

    Flow is the state where your mind is completely focused on the task at hand. While there are many factors that go into producing this state, having the right challenge level is a big part.

    Find ways to tweak your tasks so they hover in that sweet spot between boredom and maddening frustration.

    Easily distracted and hard to focus? Here’s your solution.

    Final Thoughts

    With all these tips I’ve shared with you, now you know what to do when you’re feeling unmotivated.

    Find your passion and develop a positive mantra so when the next time negativity hits you again, you know how to stay positive and motivated!

    Featured photo credit: Pexels via pexels.com

    Read Next