Skip to content
ProjectControls.com
Oracle Primavera - PM6

Updating Activity Percentage Complete

In the Open Standard
Anbin PonnithMember for 17 years 4 months
Created
11
6
0
Dear All,

I Exported a set of activities to Excel and I changed the percentage complete and then imported back.But it is not getting updated in P6.

Is it not possible to update activity percentage complete in this way.

Please give me a solution,

With Thanks & Regards,

Anbin
Save Follow Follow forum Report
Reply New topic

11 replies

Oldest first
  1. 0
    Arnold Puy ·
    #1
    Hi Anbin,

    Unfortunately No. All Columns Header having an asterisk (*) cannot be modified in Excel Sheet.

    You can change the %age in Excel by changing the Remaining Duration or by creating UDF and run the global Change.

    Regards,

    Arnold
    Report
  2. 0
    Anbin Ponnith ·
    #2
    Dear Sir,

    Actually my Planning manger asked me to update the percentage of complete.I have already done it in Excel with the sequence of Activity id.As there are more than 5000 activities in my program I though I could use Lookup fromula in excel w.r.t activity ID and then change in the Exported Excel file from P6 and then Import.

    I saw in help option ,

    To import data from an XLS file, you must have the Project Superuser security profile.
    The percentage value must be between 0 and 1. If the value is between 0 and 100, the Project Management module recognizes that value as a percentage. For example, if the value in the import file is 5, the value is imported as 5%

    Is there any way possible..

    Thanks & regards,

    Anbin Ponnith
    Report
  3. 0
    Alan Phillips ·
    #3
    Hi Guys,

    I’ve just tried exporting my activities to a spreadsheet, then updated the Activity % Complete Field (of which there is no asterisk marked against it as said in a previous reply) and then re-imported the spreadsheet back into P6.
    The percentages all changed to what I put in the spreadsheet.
    I am using version 6.2
    Maybe you need to upgrade?
    Regards
    Alan
    Report
  4. 0
    Dieter Wambach ·
    #4
    Hi

    In my opinion the difference is due to the percent complete type.

    Alan: "Physical" --> entered manually
    Arnold: "Duration" or "Units" --> Calculated by P6

    Regards

    Dieter
    Report
  5. 0
    Anbin Ponnith ·
    #5
    Hi all,

    I tried by changing the percentage completion type from Duration to Physical.But still there is * symbol in the transfered excel file.Also the datas didnot get changed.

    But when I exported the program to P3 then transfered to excel changed and once again imported to p6 it got changed.

    But I felt there was changes in the dates...


    Regards,

    Anbin Ponnith
    Report
  6. 0
    Dieter Wambach ·
    #6
    Anbin

    If you’ll use "Activity %-complete" it should work without P§ as an intermediate. But all exported activities must be of the type "physical".

    The change of dates is due to your autocost rules in P3, I assume.

    Regards
    Dieter
    Report
  7. 0
    Zq qz ·
    #7
    just want to know
    Report
  8. 0
    Bijoy Koodhathinkal ·
    #8

    I am also still lokking for

    I am also still lokking for an anwer to this post.

    Regrads

    Bijoy. K

    Report
  9. 0
    Bijoy Koodhathinkal ·
    #9

    I am also still looking for

    I am also still looking for an anwer to this post.

    Regrads

    Bijoy. K

    Report
  10. 0
    Arend Woltjer ·
    #10

    An old post, it is mentioned

    An old post, it is mentioned by some that answering to these is not appropiate....

    But being a real planner I think I know better.. :)

     

    To use the excel way to update: 

    An activity’s percent complete can be calculated according to activity duration, activity units, or a physical percent complete that you enter for each activity.

    Choose Project, Activities, and display the Activity Details General tab or add a column for 'Percent Complete Type' in the Activity Table. In the Activities window, select the activity to update and display the Activity Details Status tab. .In the Activities window, select the activity to update and display the Activity Details Status tab. In the Activities window, select the activity to update and display the Activity Details Status tab. In the Activities window, select the activity to update and display the Activity Details Status tab.       

    If the selected activity’s percent complete type is set to Physical, you can enter its physical percent complete in the Physical % field.

    To edit the Physical % field, the activity must have started.
    Enter the physical percent complete and the remaining duration for the activity.

    If resources are assigned, you must also update each resource’s actual regular units.

     

     Cheers
     

    Report
  11. 0
    Arend Woltjer ·
    #11

    In the Activities window,

    In the Activities window, select the activity to update and display the Activity Details Status tab. -3x

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?