So, I record my time tracking by hand, and later I sum it up and divide it out by hand.
It takes me about an hour a week. I regularly get the suggestion that I should get it into a spreadsheet or an application to cut that time down.
By doing it by hand, relatively slowly, I'm forced to turn the implications over in my mind of the numbers.
For instance, I slept 8.2 hours on average over the last 13 days.
If I saw that on the sheet, I wouldn't pay much attention to it.
But... here's how I got there -
6 + 11 + 6.5 + 6.5 + 11 + 6.5 + 2 + 12.5 + 9.5 + 8 + 10 + 8 + 9.5 = 107 /13 = 8.2
Note that there's only two days in there between 7 and 9 hours. Five days were under 7 hours and five days were over 9 hours.
That's probably not good, and I should work on it.
And actually, these numbers don't even tell the whole story - a lot of those large numbers are a 7 hour sleep and a 4 hour nap later - it's just my sleep-per-day count.
This is one advantage of going through numbers slowly, by hand, instead of on a computer. If I saw 8.2 while skimming a spreadsheet, I'd say okay, that's pretty normal. Instead, I see my sleep is all over the place, and I think I should structure my day a little more systematically to smooth that out.
Hmm. Interesting sleep data. Not so much about the deviations or the mean, but the actual amount slept - 8.2 per night.
I'm not sure how much an ideal amount of sleep is. I do know that I like 7.5 - 9 hours of sleep, averaging 8. I feel about guilty about all my sleeping but I can't take naps. I can't function well on less than 7 hours nightly sleep. But it still sucks that I can't cut sleep to increase production because productivity goes down so badly!
The hidden benefit in adding this all up by hand is that you also get better at mental arithmetic - an often overlook but very valuable skill to have.
If you don't have the associated standard deviation, a mean is generally useless.
Look at yours: it's 2.8. This indeed shows that your sleep pattern is irregular and that your mean does not make any sense.
If your data was 8, 9, 7.5, 6.5, 9, 8.5, 6, 10.5, 9.5, 8, 9, 8 and 9.5, it would give you the same mean but the stdev would be 1.25, which would show a much more stable dataset.
What's the use of tracking 'average hours' anyway? I think it would make more sense, especially in your case, to track deviations. Anything below 6:30 hours and anything above 9:30 gets flagged for night sleep; anything above, say, 1 hour gets flagged for day naps. Having a '8.2 hours average' doesn't say anything if you have as unhealthy deviations as the ones you demonstrate here. It is only justified to track averages in sleep hours if the deviations are small. I'm curious to see if you start tracking your sleeping goals in a different way. Of course, that also means *defining* them in a new way.
Keep us updated ;-)
I use Fitbit to track a lot of metrics, including sleep hours. It updates automatically and creates nice graphs for you to see.
I find 5 cycles a night (~7.5 hours) and a 20 minute nap ideal, at least for me; you might try aiming for it for a week to see how you do on it.
I see no benefit to manual tracking; all the data's visible on the spreadsheet too, not just the totals. Hell, the spreadsheet should show night sleep and day naps as separate entries, right? And as far back as you like....
I don't think this detracts from your point (manual review has its own merit), but it sounds like you aren't tracking the right things in your hypothetical spreadsheet. It sounds as though regularity of sleep (e.g. something like standard deviation, which is around 2.7 for your figures) is more important to you than mean average sleep (or is at least measurably important). Your central point that manual review can help us ensure we are tracking the right things is important, but at the same time, when we have identified those things that can be tracked there is no reason not to automate away metrics provided we don't obscure useful patterns in the process.
"What gets measured, gets managed." - Peter Drucker
There is so much power in this quote. If you've never tracked yourself, you don't even know how much power there is in tracking. I couldn't even explain it adequately. You wouldn't believe me. You'd think I was exaggerating. The simple act of paying attention to something will cause you to make connections you never did before, and you'll improve the those areas - almost without any extra effort.
I'm not a believer in "free lunch" and I don't think the universe vibrates things to you just by thinking about them. But the closest thing to a free lunch getting vibrated to you by the universe is writing things down as they happen.
Before I go any further, I need to give you one piece of advice - start small and build up, so you don't overwhelm yourself. This is just being pragmatic. You want to scale up gradually, as I wrote up in "The Evolution of My Time/Habit/Life Tracking." You want to build small wins, lock them so they become automatic, and then expand.
I'd have a hard time convincing you of the power of tracking, so I'll just show you. I fill this out every single day.
I think that some might be surprised to hear how much I sleep and how important it is to me. I average right around eight hours per day (tracked for a few months), and prioritize sleep very strongly, even over most work.
Once ten pm comes around, I have four options for things I'm allowed to do: I can play violin, read a book, work, or sleep. Computer is off at midnight every day, at which point I usually read for an hour or two, and then go to sleep.
The other night I was tired at ten, but I was really excited about my work so I tried to push through and keep at it. I was stuck trying to fix something, but I managed to try five or ten solutions out before getting in bed. At the time, it felt like a good choice.
I woke up the next morning, took one look at the code, and spotted the solution instantly. Within five minutes it was fixed. Once is a fluke, but I've noticed this pattern over and over again with work when I'm tired-- it feels like I'm working, but often I'm just spinning my wheels.