I know you guys have been immensely interested in how I spend my day (here and here and here). I pivoted the data from my TaskIt worksheet for this week and here it is. I think I’ll turn that into an add-in that creates the pivot table automatically and has a couple of menus.
If you don’t get the title, see YouTube. And if you like accounting humor (aka humour), then see Smurf On Spreadsheets
So Misc is the code word for Goofing Off?
Dick
Who discovered lions were scared of chairs?
I don’t see Tetris, unless that’s lumped into Misc.
Yes, Misc is goofing off, but I might show this to my boss some day, so better to obfuscate it. It includes Labor Day, lunch, reading blogs and newsgroups, and taking my car to the mechanic (3 times this week). Even if I take out the holiday, it’s still the biggest category. That’s sad.
You’re doing very well, Dick. 80% of my days are Misc. 90% if you don’t count lunch as work.
Anyone else see the irony in the fact that “quality” is misspelled?
It passed “qualtiy” control, but my head accountant caught it in about 2 seconds. That’s one of the down sides of on-the-fly categories; one misspelling lives forever.
See, where i have been going wrong all this time is i put Goofing off down as J-Walkblog.
I have been a happy user of TaskItv3 since Feb. Outside of a couple of little ‘ticks and fleas’ that I caused when tinkering the program has been an unquestionable success for me keeping track of my time and appropriately assigning it to the right accounts. On Sept 1, I got this message that I have never seen before (and haven’t seen since):
09/01/09 09:43:26 [TaskItv3.xlsm]MHelpers.WriteTask(), Error -2147417848: Method ‘Save’ of object ‘_Workbook’ failed
I had just completed a windows update so I shut everything down and rebooted, voila no problem. In my never ending battle to not let something just be, I wonder what happened?
Any ideas?
Ed
Ed: How many rows are used in that worksheet? (just curious, I don’t think it’s related to the problem) Here’s the offending code:
If rNext was nothing, you would get a different error (Object variable or With Block variable not set). I guess if the folder or file was read only or you otherwise didn’t have permission you would get Method Save…failed. But I doubt that happened and then magically unhappened. I wonder if the ‘temp’ file became corrupted somehow and the reboot cleaned it out. I really need to take Walkenbach’s suggestion of writing to a CSV.
Anyway, I’m glad it’s been useful to you.