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 How to Get out of a Rut: 12 Useful Ways to Get Unstuck 2 15 Ways to Cultivate Lifelong Learning for a Sharper Brain 3 How to Get Promoted When You Feel Stuck in Your Current Position 4 Building Relationships: 11 Rules for Self-Promotion 5 7 Steps For Making a New Year’s Resolution and Keeping It

    Read Next

    Advertising
    Advertising
    Advertising

    Last Updated on March 13, 2019

    How to Get out of a Rut: 12 Useful Ways to Get Unstuck

    How to Get out of a Rut: 12 Useful Ways to Get Unstuck

    Have you gotten into a rut before? Or are you in a rut right now?

    You know you’re in a rut when you run out of ideas and inspiration. I personally see a rut as a productivity vacuum. It might very well be a reason why you aren’t getting results. Even as you spend more time on your work, you can’t seem to get anything constructive done. While I’m normally productive, I get into occasional ruts (especially when I’ve been working back-to-back without rest). During those times, I can spend an entire day in front of the computer and get nothing done. It can be quite frustrating.

    Over time, I have tried and found several methods that are helpful to pull me out of a rut. If you experience ruts too, whether as a working professional, a writer, a blogger, a student or other work, you will find these useful. Here are 12 of my personal tips to get out of ruts:

    1. Work on the small tasks.

    When you are in a rut, tackle it by starting small. Clear away your smaller tasks which have been piling up. Reply to your emails, organize your documents, declutter your work space, and reply to private messages.

    Whenever I finish doing that, I generate a positive momentum which I bring forward to my work.

    2. Take a break from your work desk.

    Get yourself away from your desk and go take a walk. Go to the washroom, walk around the office, go out and get a snack.

    Your mind is too bogged down and needs some airing. Sometimes I get new ideas right after I walk away from my computer.

    Advertising

    3. Upgrade yourself

    Take the down time to upgrade yourself. Go to a seminar. Read up on new materials (#7). Pick up a new language. Or any of the 42 ways here to improve yourself.

    The modern computer uses different typefaces because Steve Jobs dropped in on a calligraphy class back in college. How’s that for inspiration?

    4. Talk to a friend.

    Talk to someone and get your mind off work for a while.

    Talk about anything, from casual chatting to a deep conversation about something you really care about. You will be surprised at how the short encounter can be rejuvenating in its own way.

    5. Forget about trying to be perfect.

    If you are in a rut, the last thing you want to do is step on your own toes with perfectionist tendencies.

    Just start small. Do what you can, at your own pace. Let yourself make mistakes.

    Soon, a little trickle of inspiration will come. And then it’ll build up with more trickles. Before you know it, you have a whole stream of ideas.

    Advertising

    6. Paint a vision to work towards.

    If you are continuously getting in a rut with your work, maybe there’s no vision inspiring you to move forward.

    Think about why you are doing this, and what you are doing it for. What is the end vision in mind?

    Make it as vivid as possible. Make sure it’s a vision that inspires you and use that to trigger you to action.

    7. Read a book (or blog).

    The things we read are like food to our brain. If you are out of ideas, it’s time to feed your brain with great materials.

    Here’s a list of 40 books you can start off with. Stock your browser with only the feeds of high quality blogs, such as Lifehack.org, DumbLittleMan, Seth Godin’s Blog, Tim Ferris’ Blog, Zen Habits or The Personal Excellence Blog.

    Check out the best selling books; those are generally packed with great wisdom.

    8. Have a quick nap.

    If you are at home, take a quick nap for about 20-30 minutes. This clears up your mind and gives you a quick boost. Nothing quite like starting off on a fresh start after catching up on sleep.

    Advertising

    9. Remember why you are doing this.

    Sometimes we lose sight of why we do what we do, and after a while we become jaded. A quick refresher on why you even started on this project will help.

    What were you thinking when you thought of doing this? Retrace your thoughts back to that moment. Recall why you are doing this. Then reconnect with your muse.

    10. Find some competition.

    Nothing quite like healthy competition to spur us forward. If you are out of ideas, then check up on what people are doing in your space.

    Colleagues at work, competitors in the industry, competitors’ products and websites, networking conventions.. you get the drill.

    11. Go exercise.

    Since you are not making headway at work, might as well spend the time shaping yourself up.

    Sometimes we work so much that we neglect our health and fitness. Go jog, swim, cycle, whichever exercise you prefer.

    As you improve your physical health, your mental health will improve, too. The different facets of ourselves are all interlinked.

    Advertising

    Here’re 15 Tips to Restart the Exercise Habit (and How to Keep It).

    12. Take a good break.

    Ruts are usually signs that you have been working too long and too hard. It’s time to get a break.

    Beyond the quick tips above, arrange for a 1-day or 2-days of break from your work. Don’t check your (work) emails or do anything work-related. Relax and do your favorite activities. You will return to your work recharged and ready to start.

    Contrary to popular belief, the world will not end from taking a break from your work. In fact, you will be much more ready to make an impact after proper rest. My best ideas and inspiration always hit me whenever I’m away from my work.

    Take a look at this to learn the importance of rest: The Importance of Scheduling Downtime

    More Resources About Getting out of a Rut

    Featured photo credit: Joshua Earle via unsplash.com

    Read Next