Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2014, 07:56 AM
ketanco ketanco is offline keeping certain items separate from overall % calculation Windows 7 64bit keeping certain items separate from overall % calculation Office 2010 64bit
Expert
keeping certain items separate from overall % calculation
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default keeping certain items separate from overall % calculation


in my project schedule, there are a lot of submittal items which i should show as many installation activities are tied to them.

however, I want to keep them outside of overall % complete calculation, even though I still want to keep them in my schedule, including their durations and links.

can I do that?
Reply With Quote
  #2  
Old 08-22-2014, 08:12 AM
JulieS JulieS is offline keeping certain items separate from overall % calculation Windows 7 64bit keeping certain items separate from overall % calculation Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You cannot. If you set them up with duration - then they count towards % complete. I'd set them up as milestones. You'll still need to mark them as 100% complete when they are done - but if your resources are not working on them - I would not include them as tasks with duration.
Reply With Quote
  #3  
Old 09-01-2014, 09:22 AM
Guloluseus Guloluseus is offline keeping certain items separate from overall % calculation Windows 7 64bit keeping certain items separate from overall % calculation Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

Assuming your submittal tasks have an effect on your programme, there is a way to partialy get around this, as I had asimilar problem. As julie says, use milestones to mark each submittal, but use a start and finish milestone with a lag- if task Submittal X has a duration of 10 days, predecessors A and B, and successors C and D, then set up tasks as below

Submittal X- Start Pred A, B, Successors Submittal X- finish, with lag of 10 (duration of task)

Submittal X-Finish Pred Submittal X-start, succ C,D

both as milestones. this will allow you to preserve the shape and integrity of your programme without giving any % complete.
This will effectively give you a task of any length with 0 duration.
Reply With Quote
  #4  
Old 09-16-2014, 07:52 AM
ketanco ketanco is offline keeping certain items separate from overall % calculation Windows 7 64bit keeping certain items separate from overall % calculation Office 2010 64bit
Expert
keeping certain items separate from overall % calculation
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
You cannot. If you set them up with duration - then they count towards % complete. I'd set them up as milestones. You'll still need to mark them as 100% complete when they are done - but if your resources are not working on them - I would not include them as tasks with duration.
I just saw a schedule done by another scheduler, and it reminded me my question about this.

He gave a 0 hour work duration to items like submittals, and more than 0 hours of work for regular construction activities. Can this be a solution? I assume this can be a solution, if that %complete calculated based on work. But that %complete calculates based on duration so this is not a solution right? so the method presented by the user Guloluseus can be recommended in this case, as the only solution?

How about, using % physical complete? would that work? that calculates based on work and not duration? Actually i dont prefer this as i enter everything as duration when doing my schedules. I saw this at : Under Option>Advanced tab, there is "Default Task Earned Value Method". It can be set as either % complete or Physical % complete.
Reply With Quote
  #5  
Old 09-17-2014, 04:34 AM
JulieS JulieS is offline keeping certain items separate from overall % calculation Windows 7 64bit keeping certain items separate from overall % calculation Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Milestones are zero duration and zero work as I suggested earlier. % complete is a duration measurement and you will still need to update the status of the milestone. % work complete is the same.

You can use Physical % complete, but you need to manually enter summary task physical % complete.
Reply With Quote
  #6  
Old 09-17-2014, 05:43 AM
ketanco ketanco is offline keeping certain items separate from overall % calculation Windows 7 64bit keeping certain items separate from overall % calculation Office 2010 64bit
Expert
keeping certain items separate from overall % calculation
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

so in the other schedulers schedule, when although he assigned zero work to submittals, but gave them durations, then his submittals are still taken into account for % complete correct?
Reply With Quote
  #7  
Old 09-17-2014, 05:27 PM
JulieS JulieS is offline keeping certain items separate from overall % calculation Windows 7 64bit keeping certain items separate from overall % calculation Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

The summary tasks are not mark complete until all tasks (including milestones) are marked complete.
Attached Images
File Type: jpg %.jpg (71.3 KB, 11 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help with age calculation!!! Microsoft Idiot Word 4 10-29-2012 05:54 AM
Keeping track of sent items Eugen_Denoes Outlook 8 10-22-2012 04:24 PM
keeping certain items separate from overall % calculation Can I use the filter function to separate letters into separate files? drhauser Mail Merge 2 12-14-2011 02:18 PM
Any easy way to separate a Word document into separate files? SamHelm Word 0 08-21-2010 05:29 AM
Outlook 2007 Saved sent items list only holds the last ten items david.peake Outlook 0 06-01-2010 07:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:03 AM.


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