05.29.08

Spreadsheet to-do-list

Posted in Organization tagged , , , , , , , , , , , at 11:25 pm by andreak64

I recently dug up and refreshed a to-do list I had created in Excel, because from September to December of last year, it worked so well for me use a spreadsheet to keep track of big and small projects. When I first opened the file and looked it over, it was one very long list, with lots of stuff checked off and almost as much stuff still not checked off. I found it overwhelming to look at and darn near closed it up right then and there! I know I could have removed the rows with the checked off stuff, but I like to see that I’ve accomplished things, so that wasn’t the answer. I know it sounds dumb, but it works for me.

I decided to break the tasks into categories as tabbed sections, since I had roughly organized them this way they developed last fall. What better way to keep each list separate and more manageable, yet still together in one Excel file. I find that I like seeing the main categories on the tabs and viewing just one tab at a time, but with the others just a click away. It’s so much easier to focus on the tasks listed there and know how far along I’m coming on a big project. Just for the record– I’ve tried to organize my tasks in Microsoft’s Outlook by assigning them to categories, but every so often, my computer hiccups and rearranges my task list. Then I waste time trying to reconstruct the view so I can figure out where I left off.

I guess the thing I like about the spreadsheet method for my to-do list is that it doesn’t have annoying reminders. If I use Outlook and try to set deadlines on too many tasks, they seem to pop up at inopportune times and I end up ignoring the reminders. It’s too hard to predict that at 8 am the next day, I will definitely be doing a particular task, which will then be followed by an additional task with another reminder. If I can’t do a task as it was originally scheduled, I know I can move the reminder to another time or day, but then I’m just putting it off, sometimes indefinitely. I’m very good at procrastinating on my own, so I don’t need help from any software.

I do try to use reminders sparingly, though, so I won’t forget to do really important things, like attend meetings or do something by a specific date. I find that I tend to pay more attention to those types of reminders and never ignore them or put them off. It’s a rare occasion that I miss a meeting or turn in paperwork late when I set a reminder for it. For everything else, the spreadsheet gives me much more flexibility to work my tasks into my schedule, rather than schedule tasks into my workday.

05.21.08

To-do lists

Posted in Organization tagged , , , , , , , at 11:34 pm by andreak64

Only a packrat like me can accumulate multiple to-do lists. I recently mentioned the scraps of paper I’ve been collecting with tasks and projects to do and the need to put them all together. In trying to think of a location to compile them (and do them- including checking them off), I remembered the Excel spreadsheet I started last fall. I still had it on my thumb drive, so I plugged it into my laptop and began transferring tasks and projects from scraps of paper to the spreadsheet.

It was nice to see all the things I’d accomplished last fall. I knew I felt busy at the time and the spreadsheet confirmed it– it had lots of stuff checked off. Ahhh, a rare sense of accomplishment. But when I opened the file, I noticed the last time I updated it was 12/4/07. Hmmm…. had it really been that long since I last used it? I discovered a few tasks and projects that weren’t checked off and yes, they still needed to be done. Darn–forgetting them didn’t make them go away.

I know I should work harder at delegating things to other people, but it’s a skill I’m not very good at. There are lots of things at my library where I’m the only one trained or authorized in the software to do them, so delegation isn’t as simple as picking an employee and saying, “Here- this is your project. I want it done by…” If I get too many questions when I assign something, I feel like I didn’t explain it clearly enough or train the person well enough so they could work on it independently.

I also need to break down bigger projects into smaller steps that either have deadlines or target dates, so I can know if I’m on track or way off it. I recently worked with an employee to do this for our digitization plan and we both like having a general timeline in which to begin digitizing and cataloging local maps and photographs. I need to go back to my other big projects that have been hanging around my neck like an albatross and put them on timelines as well. Maybe that will give me an incentive to squeeze them in and stay on track– and maybe even complete them before I retire decades from now.

05.12.08

Workload exceeds maximum!

Posted in Organization, Time management tagged , , , , , , , , , , , , , at 11:09 pm by andreak64

Each time I got a voice mail today, my voice mail system gave me an ominous warning that my inbox was getting so full, it was considering not letting me hear any messages. It told me I had to delete or move emails first in order to free up space. It came down to my basic curiosity– how bad did I want to know who the caller was or what they wanted? Would it be worth it to free up inbox space just to find out I had a new task, project, or problem to handle?

Hmmm… curiosity got the better of me. I decided to squirrel away some unread newsletters that were piling up. I stuffed them into a folder on my hard drive, along with dozens of other unread newsletters from the same sender. Sigh… wish I had time to read them. Maybe someday…. Wait- forget that daydream of getting caught up– the voice mail beckons. After hearing it, I was right. I have a new project to work on and a phone call to return. Guess I’ll have to read those newsletters later, whenever that is…

I’m so far behind on reading my blogs I might as well clear out the aggregator and start over. When I worry about what I may have missed in unread blog posts, I try to tell myself if it were that important, I’d find time to read them every day. Of course, that’s easier said than done, especially when the voice mail and email inboxes are full to bursting.

In addition to emails, voice mails, and newsletters, I tried desperately to keep up with new projects today by writing them down on a pad of paper. It was a great idea– until I remembered I had several pads of paper scattered about my desktop with lots of old projects written on them. Guess it’s time to consolidate them on one large piece of paper and figure out which ones need to be done first.

I’ve tried putting new projects or tasks into Microsoft Outlook’s tasks and assigning due dates, reminders, and priorities. But they only end up annoying me when the reminder pops up and I don’t have time to do the task or project right then, usually because something else has come up. I know I can change the reminder or even dismiss it. I can also ignore it and have the software tell me how many hours, days, or even weeks I’ve been ignoring it. There’s nothing like being reminded you’re really far behind on your to-do list–and like a true packrat, I can accumulate overdue reminders like nobody else.