Prj 2007: Trouble with date calculation for a lead-time
in [Project]
|
Prev: Project 2010
Next: OutlineGrandParent.duration
From: smw on 12 May 2010 12:38 I need to have a separate line item in my plan for the lead-times on several purchases. Example: order is placed on 6/30/2010, lead time to delivery is 60 calendar days, delivery would be on 8/28/2010. To do this I created a lead-time calendar that makes every day a work day by setting all days to 8:00 AM - 5:00 PM. Task is fixed duration, 60d, non-estimated, calendar LeadTime is assigned to the task, no resources specified. The problem; project computes the Planned End Date at 8/22/2010 which by my calculation is 7 days short of 60. Changing the calendar attached to this task to the 24hour one increases the discrepancy. Any suggestions will of course be greatly appreciated. Steven Wheeler
From: JulieS on 12 May 2010 13:00 Hello Steven Wheeler, Assuming that your project is set to a "day" equals 8 hours, the 9 hour day on Saturday and Sunday could explain the discrepancy. Change your "Leadtime" calendar to 8:00 - 4:00 pm with no lunch time and you should be all set. I hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project On 5/12/2010 12:38 PM, smw wrote: > I need to have a separate line item in my plan for the lead-times on several > purchases. Example: order is placed on 6/30/2010, lead time to delivery is > 60 calendar days, delivery would be on 8/28/2010. To do this I created a > lead-time calendar that makes every day a work day by setting all days to > 8:00 AM - 5:00 PM. Task is fixed duration, 60d, non-estimated, calendar > LeadTime is assigned to the task, no resources specified. > > The problem; project computes the Planned End Date at 8/22/2010 which by my > calculation is 7 days short of 60. Changing the calendar attached to this > task to the 24hour one increases the discrepancy. > > Any suggestions will of course be greatly appreciated. > > Steven Wheeler
From: smw on 12 May 2010 14:11 That did the trick, thank you! What a nuckle-headed mistake on my part. "JulieS" wrote: > Hello Steven Wheeler, > > Assuming that your project is set to a "day" equals 8 hours, the > 9 hour day on Saturday and Sunday could explain the discrepancy. > Change your "Leadtime" calendar to 8:00 - 4:00 pm with no lunch > time and you should be all set. > > I hope this helps. Let us know how you get along. > > Julie > Project MVP > > Visit http://project.mvps.org/ for the FAQs and additional > information about Microsoft Project > > On 5/12/2010 12:38 PM, smw wrote: > > I need to have a separate line item in my plan for the lead-times on several > > purchases. Example: order is placed on 6/30/2010, lead time to delivery is > > 60 calendar days, delivery would be on 8/28/2010. To do this I created a > > lead-time calendar that makes every day a work day by setting all days to > > 8:00 AM - 5:00 PM. Task is fixed duration, 60d, non-estimated, calendar > > LeadTime is assigned to the task, no resources specified. > > > > The problem; project computes the Planned End Date at 8/22/2010 which by my > > calculation is 7 days short of 60. Changing the calendar attached to this > > task to the 24hour one increases the discrepancy. > > > > Any suggestions will of course be greatly appreciated. > > > > Steven Wheeler > . >
From: JulieS on 12 May 2010 14:25 You're most welcome and don't be too hard on yourself. Project has a lot of moving parts and sometimes we forget to keep them synchronized. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project On 5/12/2010 2:11 PM, smw wrote: > That did the trick, thank you! > What a nuckle-headed mistake on my part. > > "JulieS" wrote: > >> Hello Steven Wheeler, >> >> Assuming that your project is set to a "day" equals 8 hours, the >> 9 hour day on Saturday and Sunday could explain the discrepancy. >> Change your "Leadtime" calendar to 8:00 - 4:00 pm with no lunch >> time and you should be all set. >> >> I hope this helps. Let us know how you get along. >> >> Julie >> Project MVP >> >> Visit http://project.mvps.org/ for the FAQs and additional >> information about Microsoft Project >> >> On 5/12/2010 12:38 PM, smw wrote: >>> I need to have a separate line item in my plan for the lead-times on several >>> purchases. Example: order is placed on 6/30/2010, lead time to delivery is >>> 60 calendar days, delivery would be on 8/28/2010. To do this I created a >>> lead-time calendar that makes every day a work day by setting all days to >>> 8:00 AM - 5:00 PM. Task is fixed duration, 60d, non-estimated, calendar >>> LeadTime is assigned to the task, no resources specified. >>> >>> The problem; project computes the Planned End Date at 8/22/2010 which by my >>> calculation is 7 days short of 60. Changing the calendar attached to this >>> task to the 24hour one increases the discrepancy. >>> >>> Any suggestions will of course be greatly appreciated. >>> >>> Steven Wheeler >> . >>
From: Roland on 12 May 2010 16:19
Hi Steven, Just curious. Why did you create another calendar just for lead-time? You could use "edays" instead which would have given you the results needed without additional calendar maintenance. RC "smw" wrote: > I need to have a separate line item in my plan for the lead-times on several > purchases. Example: order is placed on 6/30/2010, lead time to delivery is > 60 calendar days, delivery would be on 8/28/2010. To do this I created a > lead-time calendar that makes every day a work day by setting all days to > 8:00 AM - 5:00 PM. Task is fixed duration, 60d, non-estimated, calendar > LeadTime is assigned to the task, no resources specified. > > The problem; project computes the Planned End Date at 8/22/2010 which by my > calculation is 7 days short of 60. Changing the calendar attached to this > task to the 24hour one increases the discrepancy. > > Any suggestions will of course be greatly appreciated. > > Steven Wheeler |