Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2013, 05:43 AM
hanvyj hanvyj is offline 36 days task at 40% effort - only "0.86 days" in resource Windows XP 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Advanced Beginner
36 days task at 40% effort - only "0.86 days" in resource
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default 36 days task at 40% effort - only "0.86 days" in resource

Hi,



I've got a set of tasks in project and I'm using the resource view to see the efforts so I can do the costing.

My manual calculations came out higher, I looked into the difference and I found at least one Task that hasn't been calculated properly.

The Task shows 36 days duration, with 40% effort for "bob bobson" - but only "0.86 days" in resource view. For another employee "John Johnson" with a 20% effort against the same task it shows the expected 7.2 days!

Bob bobsons other tasks seem to calculate appropriately, he has a 0.5 day 100% effort coming up as 0.5 days of resource.

What on earth could be causing it to pick out a specific resource and task and somehow work it out differently? I have no idea where the 0.86 days is coming from.

I'd also expect it to be spread out across the task duration (as it is for John Johnson) but it's confusingly split over two days in the middle of the 36 day window!

Has anyone come across this before?

(Project 2003)
Reply With Quote
  #2  
Old 07-09-2013, 06:05 AM
JulieS JulieS is offline 36 days task at 40% effort - only "0.86 days" in resource Windows 7 64bit 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Does Bob Bobson have non-working time in his calendar? Have you resource leveled Bob?
Reply With Quote
  #3  
Old 07-09-2013, 06:16 AM
hanvyj hanvyj is offline 36 days task at 40% effort - only "0.86 days" in resource Windows XP 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Advanced Beginner
36 days task at 40% effort - only "0.86 days" in resource
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default

I've checked working time calendar, the only non-working time is the weekends. I'm not sure what you mean by resource leveled? I certainly haven't tried to do it :S
Reply With Quote
  #4  
Old 07-09-2013, 06:32 AM
JulieS JulieS is offline 36 days task at 40% effort - only "0.86 days" in resource Windows 7 64bit 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

What happens if you unassign bob and then re-assign? Assignments can certainly be edited in the Task or Resource usage view - do you see a pencil in the indicator column to the left of the assignment?
Reply With Quote
  #5  
Old 07-09-2013, 06:39 AM
hanvyj hanvyj is offline 36 days task at 40% effort - only "0.86 days" in resource Windows XP 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Advanced Beginner
36 days task at 40% effort - only "0.86 days" in resource
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default

I'm not sure if I did what you meant, I deleted the name and added it back in and there isn't a little pencil 'edited assignment' in the task view.

Now however, it has changed to "0 days"!
Reply With Quote
  #6  
Old 07-09-2013, 06:41 AM
hanvyj hanvyj is offline 36 days task at 40% effort - only "0.86 days" in resource Windows XP 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Advanced Beginner
36 days task at 40% effort - only "0.86 days" in resource
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default

Aha, for some reason the start and finish dates are the same for that particular assignment!
Reply With Quote
  #7  
Old 07-09-2013, 06:42 AM
hanvyj hanvyj is offline 36 days task at 40% effort - only "0.86 days" in resource Windows XP 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Advanced Beginner
36 days task at 40% effort - only "0.86 days" in resource
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default

And I can see a few where the start and finish date are different. That seems to be the problem I've been having.
Reply With Quote
  #8  
Old 07-09-2013, 06:52 AM
JulieS JulieS is offline 36 days task at 40% effort - only "0.86 days" in resource Windows 7 64bit 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Is this a file that you can zip and email to me? I'll take a look.
Reply With Quote
  #9  
Old 07-09-2013, 07:23 AM
hanvyj hanvyj is offline 36 days task at 40% effort - only "0.86 days" in resource Windows XP 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Advanced Beginner
36 days task at 40% effort - only "0.86 days" in resource
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
Is this a file that you can zip and email to me? I'll take a look.
Sorry, I wasn't being clear. It's fixed! I'm not sure how it happened, but somehow the assignments managed to get different end dates to the task so the "Task View" looked like this: (hope whitespace works properly)

-Task1 35 days Thu 11/04/13 Thu 30/05/13
- Bob Bobson 0 days Thu 11/04/13 Thu 11/04/13

So Bob Bobson was down for that task, but his assignment was 40% of 0 days. Changing the assignments end dates to match the task end dates fixed the issue.

The only thing is how it got like that in the first place, I'd never been in the Task view before.
Reply With Quote
  #10  
Old 07-09-2013, 07:27 AM
JulieS JulieS is offline 36 days task at 40% effort - only "0.86 days" in resource Windows 7 64bit 36 days task at 40% effort - only "0.86 days" in resource Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Great. Glad you have it sorted out. Not sure how the start and finish dates of the assignment got altered - sadly there is no method of finding that out.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
36 days task at 40% effort - only "0.86 days" in resource How do I get auto-updated "number of days since specified date" on MS word? terry795 Word 16 01-07-2016 04:33 PM
36 days task at 40% effort - only "0.86 days" in resource 5 days/week during planning & 7 days/week during implementation sanlen Project 1 06-25-2012 04:17 PM
Resources "Available From" Date in resource sheet bluphoto Project 3 04-05-2012 09:33 AM
How to have the "days" in other languages? Jamal NUMAN Excel 6 08-26-2011 08:34 AM
36 days task at 40% effort - only "0.86 days" in resource How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:40 PM.


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