I have an issue with being sleepy in the afternoon. It goes all the way back to high school when I used to fall asleep in my 6th hour class no matter what the class was. It is bad enough that in college I always tried to make sure I didn’t schedule classes for anytime between 1 and 3 pm. Unfortunately, I can’t schedule my work day like I did my college classes which means I have to work during those hours that my body wants to be napping. Generally I just try to make a point to have a variety of stuff to do during the afternoon so that I don’t get too dazed out doing any one thing. And the other day I was reminded WHY I need to continue doing that.
I was working with a particular spreadsheet editing some formulas. The spreadsheets I work with always have the panes frozen which, if you didn’t know, can make it look like you’re at the top of the sheet when in fact you are NOT. The sheet had dates on the left side, and the one at the top was January 2010. I didn’t think much of it even though EVERY OTHER TAB in this file started with January 2009. I just went through editing and copying the formulas down the column. Only at some point I scrolled all the way to the top and then when I looked back through the formulas I had edited they were all wrong! I could not for the life of me figure out what had happened. I just changed all these! Why are they not changed?! And I freaked out a little wondering what in the world happened to all the work I’d just done. Then I figured it out and felt like a giant idiot.
The mistake was easily fixable, but I really thought I might be crazy there for a minute when I couldn’t find any of my work. I was definitely awake after that though.