Scheduling formula question
in [Project]
|
Prev: Formulas/custom field
Next: Resource Leveling - Cash
From: TBol on 5 Mar 2010 11:36 I know both are the same equation. Which one is by definition ? "Duration = Work / Units" or "Work = Duration x Units". I have a three day task with a resource assigned (Max. Units 100%, Units:100%). All calendars are the default Standard base calendar; Hours per day is 9 hours. How do we build the equation to calculate 27 hours of work ?
From: Dale Howard [MVP] on 5 Mar 2010 11:46 TBol -- To be technically correct, the Duration Equation formula is written as: Duration = Work/(Hours Per Day x Units) You find the Hours Per Day value on the Calendar page of the Options dialog, accessed by clicking Tools - Options - Calendar. You were missing one key part of the formula, which is the Hours Per Day value. Hope this helps. -- Dale A. Howard [MVP] VP of Educational Services msProjectExperts http://www.msprojectexperts.com http://www.projectserverexperts.com "We write the books on Project Server" "TBol" <TBol(a)discussions.microsoft.com> wrote in message news:2C6FDDC6-0416-4AB4-81AC-5296328BE166(a)microsoft.com... > I know both are the same equation. Which one is by definition ? "Duration > = > Work / Units" or "Work = Duration x Units". > I have a three day task with a resource assigned (Max. Units 100%, > Units:100%). All calendars are the default Standard base calendar; Hours > per > day is 9 hours. How do we build the equation to calculate 27 hours of work > ? > > >
From: Andrew Lavinsky on 5 Mar 2010 11:52 Most people use D = U X W, which means W = D/U It's really D = (U X PHPD) X W, where PHPD = Person Hours Per Day. Then just pick which variable to solve for. - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > I know both are the same equation. Which one is by definition ? > "Duration = > Work / Units" or "Work = Duration x Units". > I have a three day task with a resource assigned (Max. Units 100%, > Units:100%). All calendars are the default Standard base calendar; > Hours per > day is 9 hours. How do we build the equation to calculate 27 hours of > work ?
From: Andrew Lavinsky on 5 Mar 2010 11:55 My bad. Please belay that last note, let's try it again: D X U = W, should really be D X (U X PHPD) = W, with PHPD = Person Hours Per Day. Then solve for the correct variable. - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > I know both are the same equation. Which one is by definition ? > "Duration = > Work / Units" or "Work = Duration x Units". > I have a three day task with a resource assigned (Max. Units 100%, > Units:100%). All calendars are the default Standard base calendar; > Hours per > day is 9 hours. How do we build the equation to calculate 27 hours of > work ?
From: TBol on 5 Mar 2010 12:46
Thanks Dale. Sorry, I did not explain well. I've changed "Hours per day" setting into 9 hours on Calendar tab of the Options DB. My task duration is 3 x 9 = 27 hours and I need 27 person-hours to complete the task. On the other hand, resource has 8 hours per day. Project will spread the resource hours as 8,8,8,3. I am fine with all that. The formula is (single task - single resource) as follows: Work = Task Duration x (Resource Hours Per Day x Units). What I don't understand is that if we build the work formula based on the working hours of resource (which is 8 hours per day) how can we get 27 person-hours out of "Work = Duration * Units" calculation. "Dale Howard [MVP]" wrote: > TBol -- > > To be technically correct, the Duration Equation formula is written as: > > Duration = Work/(Hours Per Day x Units) > > You find the Hours Per Day value on the Calendar page of the Options dialog, > accessed by clicking Tools - Options - Calendar. You were missing one key > part of the formula, which is the Hours Per Day value. Hope this helps. > > -- > Dale A. Howard [MVP] > VP of Educational Services > msProjectExperts > http://www.msprojectexperts.com > http://www.projectserverexperts.com > "We write the books on Project Server" > > > "TBol" <TBol(a)discussions.microsoft.com> wrote in message > news:2C6FDDC6-0416-4AB4-81AC-5296328BE166(a)microsoft.com... > > I know both are the same equation. Which one is by definition ? "Duration > > = > > Work / Units" or "Work = Duration x Units". > > I have a three day task with a resource assigned (Max. Units 100%, > > Units:100%). All calendars are the default Standard base calendar; Hours > > per > > day is 9 hours. How do we build the equation to calculate 27 hours of work > > ? > > > > > > |