import progress updates with actual dates to primavera p6

[@moaazsleem4740]

Simple and to the point as usual, thanks Eng. Hani

[@Hasshirkhanbri]

Thank you so much Sir for teaching step by step in very easy, understandable way... thanks again.. :) God bless you .

[@01234msk]

Thanks for your knowledge sharing. It will helpful for all planners

[@FernandoRodriguez-gx1gq]

Oh wow, super grateful for this. Thank you sir!

[@obadaabuarisheh4129]

this video is of great value. I appreciate the content and the hints that saved a lot of time and effort. thank you very much 👍👍

[@danysoty]

I really appreciate this video, very useful and informative directly to the point. Thank you Sr.

[@PlanningengineerNet]

You are very welcome

[@thefutureisnow2934]

You are the best! I love you! ❤

[@mouh48]

Thanks for you Mr Hany

[@GABSIAN1838]

Thank you for the explanation

[@marilynyballa809]

this video helped me. thanks

[@abdullateefmatar2397]

مشكور أستاذ هاني... تحياتي

[@ranjithkumarsakthivel7488]

Thank you for sharing KT. I downloaded the Excel sheet and the same step followed. The sheet didn't work during Ctr+C. Kindly help on this.

[@habibmohiuddin8396]

Can we use the same method for Physical % completion type? Secondly, once we import the file then do we have to schedule the p6 file again with that particular date as "data date"? Thanks

[@ahmed.elnebishi]

planned % column shown in your layout eng hany .. is this the same schedule % complete ?

[@PlanningengineerNet]

Yes, both are the same.

[@LSTSPERU]

@@PlanningengineerNet Sir, the ACTUAL % column shown in your layout .. is this the same PHYSICAL % COMPLETE?

[@praneshnevalib.e2694]

Sir, Thanks for this. I have a doubt. How can we get planned % monthly based on physical activity but not by cost. Can you please reply sir

[@ZUBAIR-l6b]

I have updated the Project as per actual dates and the schedule % is showing progress values like 50% completed for each activity but for whole project the schedule % is still 0. please help me in this regard

[@jervettabruce1467]

How do you get the WBS colors?

[@PlanningengineerNet]

Please check this post: planningengineer.net/from-primavera-to-excel-sheet/

[@giovannilevering5353]

when Ctrl + C doesn't activite the macro, you probably should activate this in Excel by opening the properties of the macro. in this menu you can allow the working of macros from other docs.

[@mohamedghobashy207]

right click in the file than make it unbolcked file to work

[@usmanali-fm3ih]

Can you change the Short key from Control+C to Some other key because this is using mostly in Excel and its repeating every time

[@tinaenowenow9537]

So smart. Thanks

[@azamkhan4363]

Good information.

[@Hussam07]

Thanks, useful tips

[@LSTSPERU]

can we update RELATIONSHIP too?

[@PlanningengineerNet]

Yes, we can do this. If you are interested in such smart ways, i recommend this course to you: planningengineer.net/courses/construction-project-planning-intermediate-level-with-p6-excel-powerbi/

[@TheJawid69]

How can I contact you Eng. Hani?

[@ahmedshehata6920]

excel file template is not working properly.how can i fix this issue

[@irshadilamdeen2630]

Engineer How did you get planned % column, you mean schedule %?

[@waqasamin933]

Yes u have to rename it

[@tarrynbosman1302]

Hi may I please get this excel document of yours its really cool. Thanks

[@jousalek7507]

how to add the Planned percentage and Actual Percentage Column?

[@howyousa2956]

thank you

[@ahmadyassin1089]

hi sir, i already push ctrl + C but nothing change as per P6. please help. thanks

[@tarysen3113]

yes. Nothing is working.. please help.

[@RamblingPen143]

Try shft+ctrl+c

[@404maciek]

Something doesn't work here, how are you getting the time in the VLookup when the site engineer document doesn't have that. No engineer will give you the time something will finish at either....

[@ahmdrafa887]

Thank you Eng.Hany

[@TANMOYCHATTERJEE-gn3wx]

Useful

[@hamzarehman4948]

Sir by importing the data I don't get exact performance percentage

[@PlanningengineerNet]

If it is a small variance then please check the decimals. You might need to increase it in your P6 settings so P6 will accept them. Otherwise, we need to do further investigation about the reason behind it.

[@hamzarehman4948]

Okay sir I try again its same

[@hamzarehman4948]

Sir pm ask me to make the 3 schedule of 1 project. How can we make a 3 schedule of 1 project. Is that possible

[@ehabsalah8446]

I paused on ctrl c nothing changed

[@mubashiramir892]

Ctrl+C not working

[@aceringor8290]

There is no marco

[@PlanningengineerNet]

Why you need macro?

[@404maciek]

Enable it in the settings...

[@SaadKallih]

@@PlanningengineerNet me too the Macro was not there, I need it to give the colors to the shchedule