Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2015, 09:06 AM
appelguy@gmail.com appelguy@gmail.com is offline MS Project Date Range Issue Windows 7 64bit MS Project Date Range Issue Office 2013
Novice
MS Project Date Range Issue
 
Join Date: Oct 2015
Posts: 1
appelguy@gmail.com is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 10-23-2015, 04:09 AM
Guloluseus Guloluseus is offline MS Project Date Range Issue Windows 7 64bit MS Project Date Range Issue Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 10-31-2015, 11:52 AM
JulieS JulieS is offline MS Project Date Range Issue Windows 7 64bit MS Project Date Range Issue Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

For a quick look - try the Task usage view and zoom the timescaled portion (right side) out to show months.
Reply With Quote
Reply

Thread Tools
Display Modes


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
MS Project Date Range Issue Count how many have completed each Training Course within a Date Range dmcmillion Excel 3 10-20-2014 09:59 AM
MS Project Date Range Issue Restrict Date Range Calculations akatz85 Excel 4 03-27-2014 08:46 PM
MS Project Date Range Issue 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft