Scheduling formula question
in [Project]
|
Prev: Formulas/custom field
Next: Resource Leveling - Cash
From: Dale Howard [MVP] on 5 Mar 2010 16:24 Steve -- Thanks for your excellent clarification! :) -- Dale A. Howard [MVP] VP of Educational Services msProjectExperts http://www.msprojectexperts.com http://www.projectserverexperts.com "We write the books on Project Server" "Steve House" <sjhouse at hotmail dot com> wrote in message news:e7Q$Z8JvKHA.5940(a)TK2MSFTNGP02.phx.gbl... > Note that chqanging the "hours per day" field on the Tools/Options menu, > Calendar page DOES NOT affect the calculations where the hours worked per > day enter in. This field is actually a conversion factor, used by Project > to convert a duration entered in the units of "Days" or "Weeks" into units > of hours, hence minutes, for storage in the task database. To change the > hours per day that the resource works such as is used in the equation Dale > cites, you must modify the calendar workday using the Tools, > ChangeWorkingTime menu option. The Calendar Options page does not affecgt > that. > -- > Steve House > MS Project Trainer & Consultant > > > "TBol" <TBol(a)discussions.microsoft.com> wrote in message > news:F0AA5024-434B-4262-8371-86ED35C96BAB(a)microsoft.com... >> 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 >>> > ? >>> > >>> > >>> > > |