a different way to look at my logs
Feb. 25th, 2018 09:41 pmAs my long-time readers are well aware, the last time I started a PhD project I started a spreadsheet to log how I was spending my time, the theory being that if I ever wondered "why am I not done yet?" I would be able to look at the logs and see exactly why. Well, that and the hope that having to write down how I spent my time, and occasionally report it here would encourage me to be productive.
For the most part it did help, and I continued maintaining the logs after I finished the degree, which meant that when my job at LTU switched to to the half-time laboratory managing gig I was already set up to keep track of my hours to know when I was at 20 hours a week. However, since the actual demands on the job tend to fluctuate seasonally, I just set up a new sheet that listed how many hours a day the uni thought I should be working (they helpfully provide a list on a web page that shows which days are normal work days, which are half-work days, and which are holidays), so which I added a column of how many hours I thought I should work each day (there is an important psychological difference between 5 four-hour days, and 4 five-hour days), another for how many I should work, and another to calculate if I were behind, ahead, or on target. I then alternated between getting ahead in hours (sometimes as much as 20 hours ahead), and behind in hours (again often as much as 20 hours behind).
Other than that ahead/behind calculation, I never really looked at the total hours I did anything, but instead set up formulas to calculate the average number of hours per day for each category over the course of each month. Some of these I simply ignored after setting up the formulas, but I have had fun over the years gradually increasing the average hours per day of exercise from about half an hour a day when I first started tracking it, to 2 hrs a day these days.
Now, however, I have two half-time "jobs", and I need to learn how to balance my life to actually accommodate both of them without completely giving up the other things in life that are important. I have been aware that I didn't do any work on either job on Friday or Saturday, and that my Durham work was somewhat neglected. This morning I awoke with an inspiration on how to get myself back on track, inspired in part by the tables
fjorlief regularly posts on how she is doing with her goals. Therefore I spent a couple of happy hours setting up new formulas to calculate how many hours a week I am spending on each task, and a new spreadsheet to contain those week summaries, along with a row for "goal" values.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
The first thing I needed to know was, how many hours are there in a week? (168) How many hours a week would I be sleeping, if I slept 8 hours/day? (56) Then I calculated how many hours would be left if I always worked exactly 20 hours per week both at my LTU job, and on my thesis, and started thinking about how those might be reasonably divided to give a reasonable work-life balance. After playing with the numbers I was left with the following goals vs what I actually did so far this year:
Goal: | 56 | 25 | 20 | 20 | 20 | 15 | 10 | 2 |
Week | Sleep | Useful | Durham | LTU | Social | Exercise | Reading | Music |
1 | 48 | 40 | 0 | 13 | 37 | 15 | 14 | 0 |
2 | 56 | 38 | 20 | 14 | 20 | 7 | 15 | 0 |
3 | 52 | 25 | 11 | 24 | 37 | 12 | 6 | 0 |
4 | 54 | 25 | 44 | 1 | 25 | 10 | 10 | 0 |
5 | 53 | 28 | 38 | 1 | 22 | 11 | 14 | 0 |
6 | 52 | 38 | 9 | 22 | 16 | 17 | 13 | 0 |
7 | 51 | 29 | 8 | 17 | 23 | 19 | 22 | 0 |
Week 8 isn't quite done yet*, since it is only 22:00, and I want to head to bed, so I won't add it here, but I can already report (since this part won't change) that Durham got only 9 hours this week, while LTU managed 23. However, this approach has already worked, in that it inspired me to put in more than 5 hours today on Durham stuff, thereby more than doubling the week's effort in one category.
I can already see that my "goal" to sleep eight hours a day doesn't really happen often (though it did in week 2!), but I think I will leave it like that, since my tendency to sleep fewer hours can then, with a bit of effort, be turned into improving my scores in Uni work. On the other hand, the goal of 15 hours a week (or better) for exercise is something that I have only managed three out of seven weeks so far (and week 8 isn't looking good for that either), but, again, seeing it spelled out like that in red and blue inspired me to do a workout this morning, and I predict that it will continue to to so. Music is already looking much better, too.
*for the purposes of this table I have decided to do the Swedish approach to the week, and call Monday the first day of the week, so that the whole weekend falls into the same week, which makes sense, since a weekend at home has a greater chance of seeing work done than a weekend away, and I want to see what the pattern looks like, and if I can make the numbers do what I want, now that I am watching it.