Should we assign qty and man-hours to every activity? If Management demands Resource loaded schedule should we provide this schedule?
@mohammednaseef3980Ай бұрын
good explanation.
@DineshKumar-qk5stАй бұрын
Paste link edges are not showing in the presentation, do you have any reason?
@blainecote8134Ай бұрын
Thank you very easy to follow
@GK.finansal2 ай бұрын
Hi, I lost the connection between powerpoint and excel. So, how can I reconnect them? In powerpoint screen, there is just always pop-ups that saying "there is no connection".
@extrainch41882 ай бұрын
It depend on the file location
@noorbassam39293 ай бұрын
Useful . Thanks ❤
@extrainch41882 ай бұрын
Happy to help
@ahmetsoner91063 ай бұрын
hi download link please
@sbyessix3 ай бұрын
For manhour average, why do you devided by 260.
@extrainch41882 ай бұрын
26 working days per month
@ayebida66206 күн бұрын
@@extrainch4188 This means you are using 10hrs calender
@badriabdellatif21654 ай бұрын
Many thanks for your effort
@extrainch41882 ай бұрын
My pleasure
@Alex-dn2ln4 ай бұрын
Thank you for this tutorial! Maybe you can help me with the following question. Ok, we added quantities for each activity here, and then got the sum of all the quantities at the WBS line (node) which is not desired because we have different UoM. So, is it possible not to sum these values at WBS level??
@extrainch41882 ай бұрын
Yes, you can
@karimwaleedelmohandes16744 ай бұрын
THAT WAS DOPE NOT USEFUL MAN !! THX
@extrainch41882 ай бұрын
Glad it helped
@dejifamilola33974 ай бұрын
Great Video!!!!
@extrainch41882 ай бұрын
Many thanks
@battlefieldtours4 ай бұрын
To create a live dashboard, how can you update PP with excel data whilst running the slide show in a loop?
@rondagallagher84795 ай бұрын
If you are linking a date formula from excel to PowerPoint is there a way to set it so the date updates daily. Using this as a "days since" counter and would like to have the PowerPoint display the new date and count daily without having to refresh manually. Thank you for the video
@Shahanshababa6 ай бұрын
good
@extrainch41886 ай бұрын
Thanks
@HassanAhmed-nc7kc6 ай бұрын
❤️👍🌹
@reginaldibenne68756 ай бұрын
Nice video! How do you get the Quantities and Standard Manhour?
@extrainch41886 ай бұрын
Many thanks, you can get quantities from BOQ and manhours by devided on the productivities
@aaqilrm5646 ай бұрын
Thank u
@extrainch41886 ай бұрын
Welcome
@whereisdamn227 ай бұрын
thanks man
@extrainch41886 ай бұрын
Happy to help
@muhammadanjum49988 ай бұрын
How did you incorporate Qty and Std.Mh in user defined fields? Manually or Automatically?
@extrainch41886 ай бұрын
You can import by excel
@abdulrauf-qj6ds8 ай бұрын
EXCELLENT
@extrainch41886 ай бұрын
Many thanks!
@ivanrojas91948 ай бұрын
Clear, concise, easy and practical. Thank you Useful Information
@extrainch41888 ай бұрын
Glad it was helpful!
@ElizabethPerez-cx5nj9 ай бұрын
How did you insert all of those check boxes at once? Did you speed up the video or can something else be done? Because when I tried to follow your video, the path developer > insert > checkboxes does not look like that as it includes a text box also and have to do 1 at a time.
@extrainch41886 ай бұрын
It depends on the revision your usuling
@CatMedia-iy1gk9 ай бұрын
So if we want to change Activity for each WBS, means that each WBS has a different Activity ID, how we can do that?. Thanks!
@extrainch41886 ай бұрын
Many ways such change it in excel and import or using user feilds
@CatMedia-iy1gk9 ай бұрын
When import activity from excel to Primavera, all the start date are not the same with start date in execl. How to fix it? Thanks!
@extrainch41886 ай бұрын
First you need to link to each other, if there is no links it will be the same starting dates
@mouh4810 ай бұрын
GREAT PRESENTATION SIR , just a question is it possible to do in the same way for the planned mahours % , thanks in advance for your precious reply
@extrainch41886 ай бұрын
Yes, definitely
@MustafaAhmed-uy6qk10 ай бұрын
When i changes rows it doesn't reflect changes to powerpoint, how to do it.
@extrainch41886 ай бұрын
Actually it should change
@895games210 ай бұрын
Process did not complete successfully. See log file for details. what to do.., tried multiple times. can you help..?!
@extrainch41886 ай бұрын
Send me the files
@reginaldibenne687511 ай бұрын
Nice one, sir. Pls, is Project report different from Cash flow generation?
@extrainch41886 ай бұрын
Yes, it is
@ShahTV8811 ай бұрын
I am facing an import issue after calculation. The sumif formula was not working in the Excel sheet, so I removed the error in the Excel cell and converted it to a number. After the formula worked and when I imported the file it was successful.
@extrainch418811 ай бұрын
Well done! All the luck Shah
@AbdulKareemAbdulRahman11 ай бұрын
does this work with pivot tables?
@extrainch418811 ай бұрын
Sure, it will work with pivot table
@summitengineeringconsultan170011 ай бұрын
assalamu alaikum...usefull videos good explanation..how can i add that three columns(qty,std.mh,mh)
@extrainch418811 ай бұрын
Welcome, you can added it from the columns options
@Loganstjohn8 Жыл бұрын
Thank you so much, this worked like a charm!
@extrainch4188 Жыл бұрын
I'm glad you like it Logan ❣️
@davidpius6676 Жыл бұрын
Nice!
@extrainch4188 Жыл бұрын
Thank you! Cheers!
@bubble1231 Жыл бұрын
Need more Power Bi videos and cover DAx
@extrainch4188 Жыл бұрын
Sure, we are working on it
@bubble1231 Жыл бұрын
Explained very nicely and quickly
@extrainch4188 Жыл бұрын
Thanks alot ❤️
@jayaraza8469 Жыл бұрын
Hi, Thanks for sharing this. Is there a way to import the exact dates from excel to P6?
@extrainch4188 Жыл бұрын
Sure, you need to arrange those dates along with each activity ID number
@LaiDerek-yg9rg Жыл бұрын
I tried your method. It works at the beginning, however, after I save and leave the file. Open it again, all excel links are not working. How can I deal with it? Thanks
@extrainch4188 Жыл бұрын
It may happen if you changed the files location
@farooqbashir4111 Жыл бұрын
Very Useful, Thanks
@extrainch4188 Жыл бұрын
Thank you Farooq
@TJ-pn4sp Жыл бұрын
🌹 "promo sm"
@sathishvelayudham9289 Жыл бұрын
Good explanation we are expecting more videos to update our knowledge
@extrainch4188 Жыл бұрын
Will upload soon ❣️
@shaivyasingh5417 Жыл бұрын
Hello. Can the source of the Excel be changed in the powerpoint that's linked to it?
@extrainch4188 Жыл бұрын
Then you have to link it with the new source
@leelopez160 Жыл бұрын
😁What an amazing introduction to VBA.Thank you for sharing your knowledge with us all.👍👍👍👍
@extrainch4188 Жыл бұрын
Thanks Lee, Glad you like it ❣️
@ganeshfluor Жыл бұрын
Perfect video, 100% practical
@extrainch4188 Жыл бұрын
Thanks gp, Glad you found it useful ❣️
@balakrishnadoddabele528 Жыл бұрын
Hi ! This small video has found solutions to many big issues... !! in a single shot.P6-Excel-P6-V-Look Up !! Loading through & reconciling data on Excel is super fast unlike the P6. Same logic for material/labor loading as the cost. 👍👍
@extrainch4188 Жыл бұрын
Glad it helped!
@Fatimalnx Жыл бұрын
Short and helpful. I appreciate it.
@extrainch4188 Жыл бұрын
Glad it was helpful!
@RamintaSøsted Жыл бұрын
Short and clear. Advantages and disadvantages. Loved it, thank you.