-
Hello,
I was wondering whether it was possible to restart Walter's thread on DWM for Excel fresh, and have a post of Walter's latest version with any important tips (like what are the hotkeys, and "don't rename the file", etc) handy.
It's a fantastic application that I'm sure lots of people are finding very useful.
Ben
24 March 2010 at 23:30 | Ben
-
Hi,
I actually have an update that I'm testing for a few days before posting.
At moises' request, it's possible now to highlight the "active" task and register the starting time. After completing the task, it will calculate the invested time. (The stopwatch is still available as a different approach).
This version will also display a pop-up with the tasks that are about to be moved to the expired worksheet.
And there's some tweaking here and there (and some vba code reorganization).
I'll post as soon as I feel that it's stable enough.
Thanks for your kind words, Ben!
Walter
25 March 2010 at 0:19 | Walter
-
Hi,
It took me some time but here's the new version.
Basically, the new functionality involves "activating" a task. This is an alternative to using the stopwatch.
Upon activation, the starting time is registered, and when the task is completed, the ending time is also registered and the invested time is calculated.
An activated task is displayed with a yellow background.
When completing or re-entering, the active task will be selected, not the one where the cursor is placed.
New shortcuts:
Ctrl-Shift-A: Activate/deactivate a task
Ctrl-Shift-J: Jump to the active task
Please notice that there are new columns in the "Open Tasks" and "Closed Tasks" worksheets, so you'll have to re-arrange your tasks accordingly.
To do this, there are a few steps involved:
1. Press Ctrl-Shift-Z: This disables some automatic functionality that would mess things up when copying and pasting.
2. Copy your tasks, and rearrange the columns
3. Press Ctrl-Shift-Z to restore functionality.
There are a lot of changes in this version, so I suggest to keep a backup copy.
Please let me know of any bug.
Download it from here:
http://rapidshare.com/files/372612499/DWM.xls 6 April 2010 at 11:37 | Walter
-
Crazy idea here, but why not just use one column per day and that's it? Set the entire grid to wrap text and make columns 40 chars wide. Each day delete A.
6 April 2010 at 12:39 | Alan Baljeu
-
Alan,
The flat list seems more intuitive to me (and to some people that wouldn't use the paper version for this reason).
Additionally, my file records completed and expired tasks in different worksheets, has a stopwatch, automatically reenters tasks, calculate dates, expires tasks and some other functions.
The list method also allows you to filter tasks by different columns.
6 April 2010 at 12:46 | Walter
-
Walter,
I have used your new version for about 30 minutes, and I am enjoying it immensely. .
The two new shortcuts are fantastic! Thank you very much for writing them.
Ben's suggestion at the top of this thread is still a good one.
Thanks again,
moises
6 April 2010 at 21:58 | moises
-
This is truly an impressive tool! I have now used this for one full day and the information it's giving me is so valuable. With almost no effort, I get a complete picture of exactly how I am spending all my time. Very nicely done!
7 April 2010 at 22:16 | moises
-
Thanks again Walter.
I've also enjoyed having an excuse to look at VB code again, too.
:-)
Ben
8 April 2010 at 8:14 | Ben
-
I'm glad you find it useful. It works fine for me as well.
I wonder how many people are using it. Since yesterday, there are 22 downloads.
Appart from the list of keys, what else could I add?
9 April 2010 at 2:56 | Walter
-
Hi Walter,
I d/led your sheet. It looks great, but I am still using by clunky excel sheet instead. Mine has a Days left column which I filter on to get a page view, an and a few other columns I find that I need.
The main reason though, is that when I think of something to add to the list, I have a macro that inserts it right above the item I am working on (I don't worry about sorting the list until later). This way I can continue working on the task from where I left off. Your sheet inserts at the bottom off the list, which for me means a lot of scrolling up to get back to the current task.
It's a great sheet, though, clearly useful to many, and helpful to me as well for getting ideas.
9 April 2010 at 14:48 | vegheadjones
-
Hi, VegHeadJones (does your name imply that you are a fellow vegetarian?)
Just to let you know, this last version lets you declare an "active task" (the one you are working on), and you can quickly jump back to it by pressing Ctrl-Shift-J
I like your "days left" idea, I'll try how it works for me.
Thanks,
9 April 2010 at 17:29 | Walter
-
Hi Walter,
I'll check out your Jump function, that is a cool idea-- and I do like how your new version highlights the active task.
When you work the list, do you filter by due date to get the "closed list" page idea or to you tend to look at it as one big list? I have been filtering mine based on days left.
And Yep, vegan since 1997!
9 April 2010 at 17:39 | vegheadjones
-
VegHead,
I see it as a long list, but with quite bold separation lines between dates.
Seeing isolated sub-lists causes me some anxiety. This way, I can quickly browse my entire list (very short, some 40 tasks), a few times x day.
11 April 2010 at 12:11 | Walter
-
Hi Walter,
That's a big difference for us. I tend to have about 100 items on the list (and I notice I get through about 1/5th of them every day). With this number of items I do go through it as sub-lists, looking at each day separately.
12 April 2010 at 14:01 | vegheadjones
-
People don't get very excited by daily postings stating that "nothing's changed." Nonetheless, I wanted to share the exciting news that nothing's changed. I am as happy with this new version after 1 week as I was after 1 day.
How many time management articles and books tell us to create a log for a day or week, so that we can track how we spend our time? I had tried to do that years ago (pre-GTD, pre-DIT) and learned next to nothing from the process. How do I categorize what I am doing? How fine-grained do I get?
Now, with Walter's new tool, as a side benefit I get a complete log of what I am dong every single day. And, this time, I am learning stuff. I make it as fine-grained as it needs to be.
This tool is making me even more self-aware. My only concern now is what I will do once I've filled all 65,536 rows on my Excel spreadsheet.
13 April 2010 at 15:39 | moises
-
That's good non news, moises!
For those not using this sheet but working mainly from PC, Qlockwork is astounding, though pricey, at giving you an honest appraisal of what you've been up to.
The answer to your final question is, of course, to upgrade to Office 2007. This will give you more than a million rows to play with, which should keep you going for a week or two.
14 April 2010 at 8:22 | Will
-
I'm sorry, Moses, but I've just posted a new version :-)
The changes are smaller, but quite useful.
- Highlight task function (Ctrl-Shift-H on/off)
- The invested time formula is inserted even if the start or end time are missing, so that if the values are entered/updated manually, the invested time is always recalculated
- Reenter task: The cursor is positioned on the reentered task's row
- Reenter expired task: new expiration date is today instead of next week
The highlighting function can have many uses: Next Pass Mark-Up, marking a few tasks that have to be done today, or whatever you wish.
Download link:
http://rapidshare.com/files/375759943/DWM.xlsDon't forget to backup your old file, press Ctrl-Alt-Z before copying tasks, and the same shortcut after the copying is completed.
That's for now,
14 April 2010 at 13:37 | Walter
-
"Reenter task: The cursor is positioned on the reentered task's row"
Walter,
I haven't done the download yet, but I don't know if I'll like this one. And, (here comes an argument from authority), I think it violates Mark's rules. :)
If I have tasks:
1
2
3
4
5
6
7
8
If I am working on 3, and then stop, re-entering it. Shouldn't I then be taken to 4?
The other modifications sound good to me.
14 April 2010 at 19:08 | moises
-
Mh... maybe you have a point.
I'm checking and I see that it didn't work like you say before either.
I think that some kind of feedback is needed when a task is reentered
15 April 2010 at 8:31 | Walter
-
Ok, here's the new version:
- After reentering an open task, move the cursor to the next one
- After reentering a closed or expired task, return to the last active one
I think this is the expected behaviour
http://rapidshare.com/files/376153688/DWM.xlsWalter
15 April 2010 at 13:16 | Walter
-
Walter,
Thank you for your immense good work. Please tell me how to activate CTRL+SHIFT+H so that it works. It seems to fail me on my computer. Do you know the reason?
Marcin
15 April 2010 at 14:12 | Marcin
-
Hi, Walter
Is there any one place in which all the functions of this are explained? I downloaded it today, having read all the good reports, but I regret to say that I have not the faintest idea how it works!
15 April 2010 at 17:45 | Mark Forster
-
Functions for Walter's Tool.
Note: precede each of the letters below with CTRL + SHIFT.
N enter new task
R re-enter the active task, if not task is activated, re-enter the task currently selected
A activate / deactivate the task currently selected
J jump to the active task
Z disable / enable the automatic functions when copying-pasting from an old version to a new version. (Not needed for when you are starting fresh. Use only when you have an older version of DWM and you want to transfer your data to a newer version.)
H highlight / unhighlight task currently selected. (I haven't used this yet and Marcin has identified a possible problem with it.)
15 April 2010 at 18:05 | moises
-
Hi Marcin,
What happens when you press Ctrl-Shift-H?
The highlighting function is pretty simple. It only paints the current task with a green background.
16 April 2010 at 0:41 | Walter
-
Hi Mark,
It's actually pretty simple. You enter the text of your tasks on the "Description" column, press Enter, and the expiration is automatically computed.
After your list is built, the basic functions are:
Ctrl-Shift-C: Mark a task as complete. It's actually moved to the "Closed Tasks" worksheet.
Ctrl-Shift-R: Reenters a task, changing it's expiration to today's date + 7
Tasks that are about to expired tomorrow will be shown in red, and the expiration will be performed automatically (they are moved to the "Expired Tasks" worksheet).
This is the full list of commands (some of them explained by Moises above)
Ctrl + Shift + A: Activate/Deactivate task (start working on it)
Ctrl + Shift +C: Complete
Ctrl + Shift + D: Delete
Ctrl + Shift + J: Jump to active task
Ctrl + Shift + H: Highlight/Dehighlight task
Ctrl + Shift + N: New
Ctrl + Shift + P: Print
Ctrl + Shift + R: Reenter
Ctrl + Shift + S: Sort tasks
Ctrl + Shift + W: Work on a specific task (similar to Ctrl-Shift-A, but with a stopwatch)
Ctrl + Shift + Z: Events On/Off
I think that I'm going to write a short guide and post it here.
Walter
16 April 2010 at 0:52 | Walter
-
The time recording function is the interesting part.
Even when working on reentered tasks, since they shares the creation time of the originals, it's easy to see what's the total time invested on each specific task.
I'll explain that in the guide.
Walter
16 April 2010 at 0:56 | Walter
-
Walter,
A Password Manager is activated which is going to omit the functionality of Microsoft Clipboard.
Or else nothing happens. No password manager, nothing.
My laptop is Lenovo 3000 C200.
How do I have your CTRL+SHIFT+H functionality?
Regards
Marcin
16 April 2010 at 15:31 | Marcin
-
Hi Marcin,
I really don't understand what you're saying.
What a password manager has to do with it?
16 April 2010 at 19:48 | Walter
-
I downloaded the new version this afternoon and the highlight function works. Thanks for giving the full list of commands.
16 April 2010 at 22:09 | moises
-
17 April 2010 at 4:11 | Walter
-
The guide is good. Thanks. With respect to Ben's post at the top of this thread, you might want to add to the guide, "Do not rename the file." That's one of the errors that I made.
Well, I still haven't gotten around to learning VBA, but my 1-month deadline hasn't arrived yet. So, now I am going to give you a list of things that would be nice, but are not necessary. Since I still know very little about VBA, I have no idea how realistic these requests are.
I think that I learned from Mike the word "configurable." In the best of all possible worlds, I would like to see DWM for Excel made configurable.
I am making this request, because the tempo and pace of my work differ at home and at work. At home, I use the tool only on weekends. At work, I use it only on weekdays. The rigidity of the definitions of "week" and "month" do not mesh satisfactorily with my schedule.
I would like to be able to configure your tool. Accordingly I would like to specify how many days a "week" comprises and how many days a "month" comprises.
I can give examples of why this would help me, in another post, if anyone is interested.
Lastly, I would like to be able to configure the date format. I know that dd/mm has the benefit of logical consistency and near-universal acceptance, but in my backwards corner of the universe this format is jarring.
Right now, I modify your code to get these changes, and I do not mind continuing to do so. I just had the narcissistic notion that if I wanted to make these changes, others might want to make them as well.
On a less prosaic note, I am still finding DWM, in general, and DWM for Excel, specifically, the ne plus ultra of systems. Others have found that it leads them to focus on getting a lot of things done but not on getting the best things done. I am glad to say that, thus far, that has not been the case for me.
18 April 2010 at 13:16 | moises
-
Re: Changes. When you make the changes I'd make the names "Entry" and "Reentry" rather than week and month as that would make things more logical. Also, look into the options on Excel. If it is ISO 9000 (?) compliant it should allow you to configure the date in Excel itself. Check it out before making a change in VBA.
18 April 2010 at 13:22 | Mike
-
Re: Configurable. A programming tip from someone who did a lot of it and is happy to be not doing it any longer ;-) Make almost EVERYTHING configurable to start with. Simply hard code nothing, if you can manage it. Even if, to start with only YOU set the variables in the program and don't allow the user to do so ... make them variables so that when you (inevitably) decide that they must be configurable, you'll be at least part way there.
18 April 2010 at 13:26 | Mike
-
Oh, and one more thing. It is good programming practice for the following reason:
daysinweek=7
weeksinmonth=4
enter in today()+(weeksinmonth*daysinweek)
is self documenting where as simply using "7" or "4" or "28" or "30" in a formula leaves you guessing when you've (again, inevitably) forgotten what the hell you were trying to do in this section of code. ;-)
18 April 2010 at 13:32 | Mike
-
Hi, all
I thought about making some options configurable, as was the case with my old AFx excel files.
I also wanted to play with the "month" and "week" values, to see what happens, for example, with a two weeks month, and a 3 days week.
It would be done on an additional worksheet ("Configuration"), with two columns, "Item" and "Value".
This could take a while. I'm suspecting that I'm using all this as an excuse to neglect my tasks ;-)
About programming practices, the code isn't all that pure. It's not object-oriented, for starters, but all in all, it's legible.
18 April 2010 at 14:06 | Walter
-
Thanks for the instructions, Walter. I started trying it out yesterday evening and it seems to be working very well, even for me who normally hates electronic time-management.
If it continues to work fine for me, would you have any objection to my hosting your two files (Excel and PDF) on this website?
19 April 2010 at 8:32 | Mark Forster
-
I'm finding one bug in the programme, which is that it tends to locate re-entered items rather unpredictably. They should go at the end of the 1-week day, but I'm finding that sometimes they are at the end of the day, sometimes at the beginning and sometimes in the middle. At least they are all so far on the right day, but it does have the effect of putting re-entered tasks in a different sequence to what I did them in. This could prevent my building up a routine of doing certain tasks each day.
19 April 2010 at 9:57 | Mark Forster
-
Hi, Mark
For starters, I'm glad that you find it useful, and of course you can post it on your site.
About the bug, I see what you mean. I didn't think about it.
The explanation for this is that each task keeps their creation date/time also after reentering.
Then, if newer tasks fell under the same expiration date as the reentered one, they will be shown after it, because their creation date is newer.
As I wrote in the guide, this is on purpose. This way if lets say, I worked four times on a specific task, I can know how much total time I invested on it.
There are two workarounds for this:
- Keep both a “Created” column (fixed between sessions) and a new “Entered” column (that varies after reentering, and good for tracking).
- Create a new column, “Task Number”, generate it automatically, and keep it between sessions.
I'd appreciate to hear some feedback from the users about this.
19 April 2010 at 11:02 | Walter
-
There's a new version on its way, that includes the following changes:
- A configuration worksheet, including the requested month/week parameters, date and time format, and some colors (I hope I wont regret that last one). This was easier than I thought and it's mostly finished.
- More importantly, I almost finished a procedure that will automatically import every task from older versions of the file, when I post a new one. I guess this will make life easier.
19 April 2010 at 11:05 | Walter
-
Walter:
Thanks for the explanation about the "bug". I don't have strong feelings about it.
I'll wait till the new version before hosting the file on this website.
19 April 2010 at 14:17 | Mark Forster
-
Walter,
Something happened and I don't know what. Everything was working fine until we lost power. I turned my machine back on and everything seemed OK.
However, the "Match entire cell contents" option in the "Find" dialogue box keeps getting checked. This wasn't happening last week. But I've reinstalled your app three times today, and I can't get the search function to work properly.
19 April 2010 at 18:36 | moises
-
Walter
is there a place one could discuss some fine detail of your valuable contribution? I have some suggestions that are of a more technical nature than is really suitable for this forum.
David
20 April 2010 at 9:37 | David C
-
I seem to be the only person with the problem with the Excel "Find" command switching to "match entire cell contents."
But, just for the record, I found a solution to that problem here:
http://www.mrexcel.com/forum/showthread.php?t=77988So far, it seems to have fixed my problem.
20 April 2010 at 19:57 | moises
-
The Excel "Find" command switching to "match entire cell contents." is the result of programming in the DWM code. The code can be altered to prevent this irritation from happening. I've done that in my version.
21 April 2010 at 0:36 | David C
-
Hi Walter,
Thank you again.
A couple of suggestions if I may.
1. I think it's almost time this thread was retired. When you post the next update, you may want to start a new thread.
2. I've tweaked your code a little to add an extra column or two that works well for me. (Please ignore this if you're reading and don't know any VB) I've got a 'notes/location' column that I can put urls, permanent links to emails, or physical locations of items in, if that's useful (it's blank for most rows).
I've also made a column that tells me automatically how many days there are to go. I find this useful information, though others may not.
I've added the following line (or equivalent) in a few places...
Sheets(OPEN_TASKS_SHEET).Cells(lngSourceRow, COL_OPEN_REMAINING) = "=CONCATENATE((B" & lngSourceRow & " - TODAY()), "" days"")"
I've defined COL-OPEN_REMAINING globally elsewhere, of course.
21 April 2010 at 7:10 | Ben
-
Hi,
Ben, someone already asked for what you say (remaining days), so I think I'll add it.
Moises, I'm glad you could find a solution. I was off-forum for a couple of days so I couldn't help.
David C, my email is "walrez" at google's mail.
I think I need to slow down a bit, though.
I'm really using a lot of time as my tasks are expiring :-)
Additionally, I wouldn't want it to get bloated.
Finally, I'm still trying to decide between adding a task number column, or keeping two dates (Original, reentered), to fix Mark's bug. Opinions?
Walter
21 April 2010 at 8:22 | Walter
-
Walter,
Password Manager is some kind of a "branded" part of my Lenovo soft.
I don't know where to configure it and how to change the mapping of shortcuts so that CTRL+SHIFT+H means highlight as defined by you.
Regards
Marcin
21 April 2010 at 15:05 | Marcin
-
21 April 2010 at 15:45 | Walter
-
Walter,
Many thanks.
Simple and working.
Thanks for your constant updates. BTW, do you have any rss service so that I get informed immediately when you post your update?
This forum has no RSS unfortunately and sometimes I get lost which tread I was participating in.
Regards
Marcin
21 April 2010 at 16:09 | Marcin