Skip to main content

Taking Myself to Task: Excel Spreadsheets for Procrastinators


As I've documented in many, many posts, I have more clever ways to procrastinate than just about anyone. Which means that if I want to get anything done, consistently, I need to figure out a way to hold myself accountable.

Which is when I came up with this Excel spreadsheet.

Yes, it's crude and lacking both in sophistication and beauty. But it gets the job done. Since I began using it last month, my productivity has increased in every area. And when I slack off, I can see where and how long it's lasted.

Creating the spreadsheet was simple. On one axis I listed the days of the week. On the other, I listed the activities that currently meant the most to me, things that would improve my life if practiced consistently.  These included: exercise, writing, and reading. Each day, as I spend time on a different task, I color in that activity.

As you can see, last week I did a better job of working on MAP than this week. On the other hand, I've gotten more exercise in this week. Either way, the spreadsheet is a convenient way for me to hold myself accountable and to see, over time, where I spend my time and where I need to focus if I want to meet my goals.

How do you keep track of your progress on important projects?


larramiefg said…
Simply by setting and meeting the mental deadlines for the week. If something isn't completed I can't move on.
Keetha said…
Color me impressed!

I made a chart for my word count goal and then fill it in. That works great until I get out of the habit and forget to update it!
Anonymous said…
It varies. But charting progress sure helps to keep your mind on the job. I've noticed that i make weight loss charts when it's going well an abandon them when they aren't ..can you spell self denial??!
And on the more recent focus of the film editing, I actually pulled open my MS project app in exaseration and did a full blown project plan Gantt chart..because this shows the dependencies of one task on another (horrible) and then, if the date to finish is missed and you move estimated completion date, the date of every task that depends on it moves automatically too, duh! This is real life..and it sure puts a keener sense of urgency into making and keeping commitments to complete stuff..and to making your estimates good..and to being realistic in the first place. Most project managers will tell you that one or more of those componenets are usually missing from their projects, hence why so many of them go off the rails. Maybe I should blog about this??
Candy Gourlay said…
that's brilliant ... i might try that.

Popular posts from this blog

Women are Highly Esteemed in the Eyes of This Man

I enter the sanctuary of Our Lady of Peace Church and my eyes adjust to the dimmed lights as the only illumination comes from candles on the altar and their glowing reflection in the monstrance holding the Blessed Sacrament.
My friend and I had come to join the Mary and Martha’s quarterly meeting which started with an hour of Adoration.
I took my seat in one of the pews, knelt, and surreptitiously glanced around the sanctuary. In the gloaming, I could see thirty other women kneeling like sentinels in silent prayer. 
Over the course of the hour, we would remain in contemplative silence.
As I slipped in and out of my prayers and wandering thoughts, I considered how pleased God must be when he sees us gathered in the simple and divine act of Adoration.
But in fact, women are highly esteemed in God’s sight not matter where we are. 
We only look at the life of Jesus Christ to understand how dearly he cherishes every woman.
In the Gospel of Saint John, a group of men bring a woman caught i…

When our spirit hungers

The precocious toddler’s interest in talking to her mother grew in insistence as the gathered group settled in for an hour of silent prayer. Shushing didn’t work, so the mother led her child into an adjoining room where she would still be part of the sanctuary, but sound would be dampened. Despite the closed door and heavy glass walls, the child’s fervent desire to speak with her mother was still audible.
I said a prayer for the patient mother determined to stay, and for the child who was either tired or hungry or impatient for Mom’s undivided attention. And then tried to bring my wandering thoughts back to prayer. I had come to Adoration with my own pressing need for answers.
Over the past few weeks I’ve noticed a growing emptiness in my heart. A void, as if something is missing. It’s not psychological. Not physical. After doing an internal check, I determined it’s a spiritual void that I’m experiencing.
No, I’m not doubting God, his existence or goodness. I have full confidence in…

If you are tired of the guilt trip you usually feel at church, here’s a different perspective

I am counting the days until I fly to Fort Lauderdale to see Mom for Christmas. Yes, I speak with her every day, sometimes twice a day. But as you know, phone calls just aren’t the same as being with someone you love. I look forward to seeing Mom’s smile, to holding her hand, to going for a drive along the beach with her. Spending time in the presence of someone we love enriches our relationship with them.
I believe the love I feel for Mom, is a sliver of what God feels for each of us. I believe God longs to share that love with us. Which is why we are called to spend time in God’s presence daily. We experience God’s presence when we meet him in our prayers, in church, and hopefully in one another. If I could make one wish for each of us, it would be that at some point during the next four weeks of Advent we would experience how much Jesus loves us.

The Best Christmas

During my morning devotions, I read these two verses of Psalm 117:
Praise theLord,all you nations;
extol him, all you peop…