I'm looking for a way to get a notice that when I've overcommitted myself - e.g. according to my estimates I'm already globally committed for 42 hours over say the next 120 hours (5 days), but I've only set aside 40 hours for work during the same period. I guess this requires a query of some sort that takes into account 1) the time estimate; 2) the work day; and 3) the due date of all the tasks in a list. Any idea how to get this info out of TDL? The idea is that, before the pressure gets too intense, I will be able to either postpone some due dates, renegotiate my commitments, figure out how to eat and sleep less, etc.
Unsure how exactly you deal with your tasks, but assuming each task has an estimated duration and will be dealt with in the time period you specify...
I would go to Listview, and then filter for the tasks you are interested in reviewing (hiding parents) - tasks that are to be completed in a given time period, tasks to be done in a work day (if you have non-work tasks in there as well), etc, etc. You can set up a customer filter through the "Find Tasks" function.
You could then either sum up the estimated hours visually in the grid, or run the stylesheet Z_TimeSpentReport.xsl (via print preview). You would still need to sum up the estimated times though.
For something a bit better looking (with some summated time estimates), you could apply the same filter to the tree view, and then run the stylesheet. For a focus on just the tasks, and not the parents, you could modify the stylesheet (using a text editor) as follows:
<xsl:param name="showOnlyLeaves" select="0" />
<xsl:param name="showOnlyLeaves" select="1" />
Either way, this is a somewhat manual process, and doesn't automatically alert you.
PS: "showOnlyLeaves" defaults to showing the task path. I was going to make this an option, but forgot. You can get it to not show the tasks path by commenting out the code below under section 46:
<xsl:if test="$showOnlyLeaves=1"><!--Need to see the task ancestors-->
<xsl:text> [Path: </xsl:text>
Neither of the two custom columns that I created in TDL 6.6 beta appear in the Column Selection dialog. Both columns are listed in the Add Custom Task Attribute to Tasklist dialog, though, so they still exist.
It looks like a bug that I reported earlier made it back into TDL. I like to color tasks by category, but in this release I can't add any to the "Colour task titles by" option. Also, if I select a different radio button for the color choices, the radio button for "Colour task titles by" is disabled and I can't select it again.