![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
I know Sinvraal and t_c_da were both interested in my creativity/productivity tracking log, and I think I have most of the kinks worked out. This link *should* let you view and copy it. I think.
2014 productivity log
Change the headings to reflect what you want to keep track of. The first category is set up to track wordcount; the other two are based on time spent. You set your goals in the upper right hand corner of the first sheet -- enter the target amount of words and/or time spent, with yellow being the 'okay' target and green being 'great'. Then the cells should change automagically when you meet your goal!
I've been thinking of sharing it on tumblr, but with how google docs works, everyone could see my full name. It may finally be the impetus I need to set up the minecraft gmail account emony42 and I've been talking about making. Then people could get their spreadsheet from Rapid Rail, the transit and tourism authority of scenic Haven. :P
NB:
1. This uses the new google sheets. I don't know whether it'll ask you to switch over if you make a copy.
2. Copying conditional formatting does not seem to work properly, so if you'd like to make more columns I highly recommend going into the conditional formatting dialogue box of a pre-formatted cell and copying each formula individually (and modifying it for the new range) rather than trying to use "Copy -- paste conditional formatting."
2014 productivity log
Change the headings to reflect what you want to keep track of. The first category is set up to track wordcount; the other two are based on time spent. You set your goals in the upper right hand corner of the first sheet -- enter the target amount of words and/or time spent, with yellow being the 'okay' target and green being 'great'. Then the cells should change automagically when you meet your goal!
I've been thinking of sharing it on tumblr, but with how google docs works, everyone could see my full name. It may finally be the impetus I need to set up the minecraft gmail account emony42 and I've been talking about making. Then people could get their spreadsheet from Rapid Rail, the transit and tourism authority of scenic Haven. :P
NB:
1. This uses the new google sheets. I don't know whether it'll ask you to switch over if you make a copy.
2. Copying conditional formatting does not seem to work properly, so if you'd like to make more columns I highly recommend going into the conditional formatting dialogue box of a pre-formatted cell and copying each formula individually (and modifying it for the new range) rather than trying to use "Copy -- paste conditional formatting."
