Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Changing Activity % Complete Back Zero and remove actuals

16 replies [Last post]
Sun, 2011-10-09 20:08
Henry Chiu
User offline. Last seen 10 years 46 weeks ago. Offline
Joined: 15 Jul 2011
Posts: 22
Groups: None

Hi Everyone,

 

I have encountered a problem in P6 update wherein I made a mistake for the previous week update. I want to change the percent complete of an activity back to zero and remove the actual date. The P6 wont allow me to change. Can somebody advise the steps to revert back the percent complete of an activity to zero percent and remove the actual date.

 

thanks

Top

Replies

Mon, 2022-01-31 07:20
#1
Mohammed Azharuddin
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 17 Aug 2015
Posts: 11
Groups: None

Hi,

Quick and easy way to remove actuals using only 1 Global Change.

Check out my article here

https://www.linkedin.com/pulse/quick-way-remove-actuals-from-p6-schedule-one-go-using-azharuddin/?trackingId=kLitu4dDuCP3jndDcGzifQ%3D%3D

Top
Wed, 2016-03-23 12:09
#2
Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

my posting includes 2 global changes 

Top
Tue, 2016-03-22 20:17
#3
Rafael Davila
User offline. Last seen 16 hours 12 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team

I am not a P6 user but suggest you try either the Global Change approach or the Export/Import approach as per following link.

http://simplexgroup.com/dates-and-durations-in-oracle-primavera-p6/

Also make sure you verify the durations as they migh have been changed after updatings.

Good Luck

Top
Tue, 2016-03-22 18:00
#4
Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None
How to de-status a schedule1. Choose Enterprise, Projects and select the Calculations tab. Choose to "Link Budget andAt Completion for not started activities" and "Reset Remaining Duration and Units toOriginal2. Choose View, Columns and add the columns for Actual Labor Units, Actual NonlaborUnits.3. Choose Tools, Schedule and set the data date equal to the Project Start Date and schedule.To find the Project Start date, choose Enterprise, Projects. Click on the Dates tab andnote the Planned Start date.4. For the first activity in the list, set the Actual Labor Units to 0. Highlight the activities inthis column and choose Edit, Fill Down.5. For the first activity in the list, set the Actual Nonlabor Units to 0. Highlight the activitiesin this column and choose Edit, Fill Down.6. Choose Tools, Global Change and run the 1st Global Change. This will set the ActualMaterial Units to zero.7. Run the 2nd global change which sets the activity status to Not Started. 1st Global Change:Subject Area:  Activity Resource AssignmentsIf:      Where Resource Type           equals   MaterialThen:  Actual Material Units      =          0 2nd Global changeSubject Area: ActivitiesIf:Where Activity Status     is not equal to   Not StartedThen:  Activity Status     Equals              Not Started
Top
Thu, 2016-03-17 12:10
#5
Vishal Gourgonda
User offline. Last seen 5 years 35 weeks ago. Offline
Joined: 22 Aug 2012
Posts: 9
Groups: None

Hi all...

is there any short cut to change all activity 'completed' to 'not started'?

 

Regards

Top
Tue, 2014-09-30 14:55
#6
Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

here is a link to the detailed instructions on how to do this 

http://pmsite.com/forums/viewthread/3064/

Top
Sun, 2012-07-15 11:35
#7
SM PUM
User offline. Last seen 10 years 9 weeks ago. Offline
Joined: 15 Nov 2011
Posts: 77
Groups: None

use following;

When activity Status   is not equal to     not started 

Then;

Actual labour units         equal to        zero

Actual non labour unit    equal to        zero

activity status                equa to         not started.

 

Always keep a copy of your origional project before applying the global change because it can not be undone.

 

Regards; 

Top
Sun, 2012-07-15 11:00
#8
Michael Jubilo
User offline. Last seen 11 years 40 weeks ago. Offline
Joined: 29 Jun 2011
Posts: 3
Groups: None

Hi SM PUM, yes it will take years to remove actuals of thousands activities. What operation in global change should be done then?

Top
Sun, 2012-07-15 08:45
#9
SM PUM
User offline. Last seen 10 years 9 weeks ago. Offline
Joined: 15 Nov 2011
Posts: 77
Groups: None

For Removing Actual you will have to apply global change.Removing actuals one by one will be waste of time

Top
Sat, 2012-07-14 15:26
#10
Michael Jubilo
User offline. Last seen 11 years 40 weeks ago. Offline
Joined: 29 Jun 2011
Posts: 3
Groups: None

Hi gentlemen, how about changing % complete to zero and removing actuals for multiple activities in P6? I tried global change however I was not able to find the right operation. Perhaps someone knows the trick. TIA

Top
Tue, 2011-10-18 17:48
#11
Henry Chiu
User offline. Last seen 10 years 46 weeks ago. Offline
Joined: 15 Jul 2011
Posts: 22
Groups: None

Zhang Ting,

 

Thanks a lot. Problem solved.

 

Henry

Top
Tue, 2011-10-18 11:55
#12
zhang ting
User offline. Last seen 6 years 15 weeks ago. Offline
Joined: 24 Aug 2011
Posts: 11
Groups: Petro-Chem / Oil & Gas
First convert % complete to zero，and then change tick off “started”
Top
Fri, 2011-10-14 06:37
#13
Henry Chiu
User offline. Last seen 10 years 46 weeks ago. Offline
Joined: 15 Jul 2011
Posts: 22
Groups: None

Hi Roland,

 

I did the same thing as I do in P3, unfortunately the same message appears "Cannot Set Status to Not Started if Activity Has Actuals". Is there something wrong in my settings or any options that I need to do just to clear this problem.

 

Thanks

Top
Mon, 2011-10-10 19:11
#14
Henry Chiu
User offline. Last seen 10 years 46 weeks ago. Offline
Joined: 15 Jul 2011
Posts: 22
Groups: None

Gary,

 

Thanks for your reply, but one thing bothered me is I have an activity that is 20% complete with an actual start of 01 oct as an example. When I update the following week I noticed that I made a mistake on the activity that was updated, so I want to change the percent complete to zero and remove the tick in the actual start but a message will appear "Cannot Set Status to Not Started if Activity Has Actuals". I never encounter this problem in P3.

Thanks

Top
Mon, 2011-10-10 07:51
#15
Gary Whitehead
User offline. Last seen 4 years 46 weeks ago. Offline
Joined: 24 Mar 2009
Posts: 1215
Groups: Building Information Modelling, Content Moderators, Petro-Chem / Oil & Gas, The GrapeVine

Just to add you have to do this in the right order -eg if you try and uncheck the stated box with the finished one still checked, you would get an error saying something like "activity cannot have an actual finish without an actual start"

 

Uncheck your finsh, then any % completees / actual durations / actual resources, then the start date.

 

Also,  double check the relationships to ensure doing this won't cause any OOS (out of equence) working

Top
Mon, 2011-10-10 01:23
#16
Roland Payawan
User offline. Last seen 4 years 34 weeks ago. Offline
Joined: 5 Jun 2003
Posts: 20
Groups: None

Hi Henry,

Just go to the activity status, untick the STARTED and FINISHED date and put the Percent (%) back to zero and there you go.

Hope this wull do.

Cheers,

Top