- 99
- 322 090
Extra Inch
United Arab Emirates
Приєднався 12 бер 2020
I believe that when people are leaning, they are growing. I’m on the quest to make excellence a part of those lives that I come in contact with. My name is ‘’Saed Shamout’’ and welcome to my ‘’Extra Inch channel’’. I have 16 years of experience in difference fields of engineering and Solving data problems. I will share videos related to different software productivity which will help you save time and improve your techniques.
I hope to inspire you to experiment and share with others.
Subscribe if you’d like to improve your skills.
I hope to inspire you to experiment and share with others.
Subscribe if you’d like to improve your skills.
How to create a dynamic filter with advance filter & macro?
At this video you will learn how to create a dynamic filter with advance filter & macro.
Переглядів: 153
Відео
Impressive Excel Function - =GPT3()
Переглядів 8322 роки тому
Impressive Excel function, It can figure out and match exsiting data patterns and retreive any information available on the web such as state populations or peoples twitter usernames
Fill Down Command in Primavera P6 #construction management
Переглядів 5922 роки тому
I will share with you today one of my knowledge areas on Oracle's Primavera solutions which integrates project and portfolio planning and delivery teams for planning, resourcing, risk mitigation, scheduling, and program management. Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource managem...
Amazing Excel Trick
Переглядів 892 роки тому
This is an Excel trick for importing data from online pages, hope you enjoy it and find it useful @extrainch4188
Suspense Activities in Primavera P6 #planning engineer
Переглядів 8142 роки тому
I will share with you today one of my knowledge areas on Oracle's Primavera solutions which integrates project and portfolio planning and delivery teams for planning, resourcing, risk mitigation, scheduling, and program management. Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource managem...
Automatic Activity ID settings in Primavera #project control
Переглядів 6462 роки тому
I will share with you today one of my knowledge areas on Oracle's Primavera solutions which integrates project and portfolio planning and delivery teams for planning, resourcing, risk mitigation, scheduling, and program management. Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource managem...
Resource Levelling in Primavera P6 #project management
Переглядів 7712 роки тому
Resource Levelling in Primavera P6 #project management
Earned Value Management in Primavera P6 #Project Management
Переглядів 1,3 тис.2 роки тому
Earned Value Management in Primavera P6 #Project Management
Modify Activities ID in Primavera P6 #oracle primavera
Переглядів 6062 роки тому
Modify Activities ID in Primavera P6 #oracle primavera
Create & Modify Cash Flow in Primavera #Project Management
Переглядів 1,9 тис.2 роки тому
Create & Modify Cash Flow in Primavera #Project Management
How to use Project Reflections in Primavera P6 #p6 tutorial
Переглядів 1,3 тис.2 роки тому
How to use Project Reflections in Primavera P6 #p6 tutorial
Prepare Scurve, no Resource Loading in Primavera P6 #SCURVE
Переглядів 1,2 тис.2 роки тому
Prepare Scurve, no Resource Loading in Primavera P6 #SCURVE
Prepare Lookahead Schedule #Primavera P6 #Planning Engineer
Переглядів 1,2 тис.2 роки тому
Prepare Lookahead Schedule #Primavera P6 #Planning Engineer
Prepare and Save Layouts in Primavera P6 #Planning Engineer
Переглядів 5802 роки тому
Prepare and Save Layouts in Primavera P6 #Planning Engineer
How to use Global Change in Primavera P6 #Planning Engineer
Переглядів 1,1 тис.2 роки тому
How to use Global Change in Primavera P6 #Planning Engineer
How to use Activity Codes in Primavera P6 #Planning Engineer
Переглядів 1 тис.2 роки тому
How to use Activity Codes in Primavera P6 #Planning Engineer
Protect your Schedule in Primavera P6 #Planning Engineer
Переглядів 4012 роки тому
Protect your Schedule in Primavera P6 #Planning Engineer
Link my Schedule to External Schedules #Primavera P6
Переглядів 4932 роки тому
Link my Schedule to External Schedules #Primavera P6
Create lags Report in Primavera P6 #project management
Переглядів 4192 роки тому
Create lags Report in Primavera P6 #project management
Fix Open Relationships in Primavera P6 #Planning Engineer
Переглядів 5362 роки тому
Fix Open Relationships in Primavera P6 #Planning Engineer
How to Create a Professional Organization Chart in PowerPoint
Переглядів 2662 роки тому
How to Create a Professional Organization Chart in PowerPoint
How to Export & Import Excel file #Import Excel to Primavera
Переглядів 1 тис.2 роки тому
How to Export & Import Excel file #Import Excel to Primavera
How to Create Animated YouTube Videos - Beginners Tutorial
Переглядів 632 роки тому
How to Create Animated UA-cam Videos - Beginners Tutorial
How to Assign documents in Primavera P6 #Planning Engineer
Переглядів 7102 роки тому
How to Assign documents in Primavera P6 #Planning Engineer
How to Trace Logic in Primavera P6 #planning engineer
Переглядів 1,3 тис.2 роки тому
How to Trace Logic in Primavera P6 #planning engineer
Define & Mark Critical Activities in Primavera P6 #Planning
Переглядів 7392 роки тому
Define & Mark Critical Activities in Primavera P6 #Planning
How to Import Activities from Excel to Primavera P6
Переглядів 5 тис.2 роки тому
How to Import Activities from Excel to Primavera P6
How to create a new report in Primavera P6 #Create Reports
Переглядів 3,9 тис.2 роки тому
How to create a new report in Primavera P6 #Create Reports
Activity duration types in Primavera P6 #Planning Engineer
Переглядів 2,7 тис.2 роки тому
Activity duration types in Primavera P6 #Planning Engineer
Program copy options in Primavera P6 #primavera p6 training
Переглядів 5412 роки тому
Program copy options in Primavera P6 #primavera p6 training
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".
It depend on the file location
Useful . Thanks ❤
Happy to help
hi download link please
For manhour average, why do you devided by 260.
26 working days per month
Many thanks for your effort
My pleasure
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??
Yes, you can
THAT WAS DOPE NOT USEFUL MAN !! THX
Glad it helped
Great Video!!!!
Many thanks
To create a live dashboard, how can you update PP with excel data whilst running the slide show in a loop?
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
good
Thanks
❤️👍🌹
Nice video! How do you get the Quantities and Standard Manhour?
Many thanks, you can get quantities from BOQ and manhours by devided on the productivities
Thank u
Welcome
thanks man
Happy to help
How did you incorporate Qty and Std.Mh in user defined fields? Manually or Automatically?
You can import by excel
EXCELLENT
Many thanks!
Clear, concise, easy and practical. Thank you Useful Information
Glad it was helpful!
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.
It depends on the revision your usuling
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!
Many ways such change it in excel and import or using user feilds
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!
First you need to link to each other, if there is no links it will be the same starting dates
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
Yes, definitely
When i changes rows it doesn't reflect changes to powerpoint, how to do it.
Actually it should change
Process did not complete successfully. See log file for details. what to do.., tried multiple times. can you help..?!
Send me the files
Nice one, sir. Pls, is Project report different from Cash flow generation?
Yes, it is
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.
Well done! All the luck Shah
does this work with pivot tables?
Sure, it will work with pivot table
assalamu alaikum...usefull videos good explanation..how can i add that three columns(qty,std.mh,mh)
Welcome, you can added it from the columns options
Thank you so much, this worked like a charm!
I'm glad you like it Logan ❣️
Nice!
Thank you! Cheers!
Need more Power Bi videos and cover DAx
Sure, we are working on it
Explained very nicely and quickly
Thanks alot ❤️
Hi, Thanks for sharing this. Is there a way to import the exact dates from excel to P6?
Sure, you need to arrange those dates along with each activity ID number
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
It may happen if you changed the files location
Very Useful, Thanks
Thank you Farooq
🌹 "promo sm"
Good explanation we are expecting more videos to update our knowledge
Will upload soon ❣️
Hello. Can the source of the Excel be changed in the powerpoint that's linked to it?
Then you have to link it with the new source
😁What an amazing introduction to VBA.Thank you for sharing your knowledge with us all.👍👍👍👍
Thanks Lee, Glad you like it ❣️
Perfect video, 100% practical
Thanks gp, Glad you found it useful ❣️
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. 👍👍
Glad it helped!
Short and helpful. I appreciate it.
Glad it was helpful!
Short and clear. Advantages and disadvantages. Loved it, thank you.
Glad it was helpful!
OMG thanks for this great tutorial/ tips & tricks
You're so welcome!
this video deserves 100b likes
Thank you ❣️
Hi, as the Unit of Measurement for different types of activities are different, the quantity histogram and s-curve is not reasonable. Is there any good method to show the quantity of different types of activities and generate graphs for different types of activities separately?
Sure it can be done, one of the methods is to assign an activity coding to activities and filter those reasources using activity coding.
i think the BOQ was in the other content creator who also teach Primavera P6. Can we have a copy of the BOQ sir?
I'm sorry I can't. it includes private prices
calculate 260 average, 12:02 ???? Explain please
Its 26 working day per month mutiply by 10 working hours per day
@@extrainch4188 He never mentioned daily working hour and he used 5 work week calendar. Hence, the best answer was from @pohhio who says 52 weeks (1 year) x 5 days work week = 260
how you ll import the activities to the desired WBS using excel
If you mean import from excel, then you have to add a column for the WBS level you want that activity to be imported to
Sir, Very Good Explaining, Useful and Guidance, Thanks
Thank you Farooq