#1
|
|||
|
|||
MS Project Date Range Issue
I'm desperately trying to get the pre-built date range filter to work the way I need it to.
Specifically, I have been asked to provide detail for how many project hours are expected to be spent within 30 days for resource allocation. My superior does not use MS project, but rather a crude excel spreadsheet for his own tracking. No matter how I format the date range, I am given the entire duration of work left to be performed for the entire task. For example, if I have a task spanning 6 weeks, and I am only supposed to provide detail for 30 days, the duration still shows the entire duration, even the hours outside of the 30 days. Does anyone know of a way to rectify this? I'm at a complete loss. |
#2
|
|||
|
|||
The time filters in MSP tend to relate to task start and finish dates, and will not cut a task off- if a task starts/finishes within the specified time frame, then the task will be shown completely. As far as I know, there is no way to cut atask up in the way you want using these filters.
However, that doesn't mean it cant be done. As you superior is using Excel, I would suggest using the same output type. I use MSP 2010, but I assume that 2013 is fairly similar- sure someone can assist if the buttons are different. Go into visual reports, under the Project tab, and choose either "Resource work availability" or "Resource work summary"- one of these will give a result that is most likely the one you want, but will need to try both to see which is best for you. select the chart and choose the level of usage- I generally go weeks, as days can take a while, but again depends what you want- then click view. In the excel sheet that comes up, you can change date ranges to actual dates (non task dependent) and show whichever work attribute is suited (generally "work" will give actual or predicted hours). Filter by date range and resource to the level you want, and you have a nice graph that should appeal to the excel minded person who wants to keep it simple. If this doesnt give what you want or you need more help with anything, let us know- sure others will have other solutions too |
#3
|
|||
|
|||
For a quick look - try the Task usage view and zoom the timescaled portion (right side) out to show months.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula for sumifs with less than a date range | lynchbro | Excel | 6 | 04-15-2015 01:18 PM |
Count how many have completed each Training Course within a Date Range | dmcmillion | Excel | 3 | 10-20-2014 09:59 AM |
Restrict Date Range Calculations | akatz85 | Excel | 4 | 03-27-2014 08:46 PM |
Date Range Prompt | MikeWooZ | Excel | 6 | 12-04-2011 02:10 PM |
Connectivity issue of Project Professional with Project Server | kashif | Project | 0 | 03-27-2009 06:37 AM |