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??
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.
HI, I have a question regarding the Standard Manhours. The formula is showing Manhours= Qty x Standard MHR. Where we get from Standard MH based on what? Could you expain?
Hi Mohammed This depends on many factors like the items and the ability of labours. This can be different from one company to another at the same country and it can be different from one area to another. Anyway, I can provide you with a standard manpower productivity at your email.
@@extrainch4188 All video are good bit little bit speed and I can recommend some more lesson like EVM calculations, recovery and revised through in P6, risk analysis, extensions of time in P6.....I would appreciate if you provide.. 👏👏👍
@@extrainch4188 one more thing, as shown in P6...in s curve. Wheyher it's possible to o provide in excel sheet How to do.......I can recommend some of my colleagues to watch and subscribe...you are doing very nice effort and good dedication 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?
Hi, this is one of best tutuorials I have watched on P6, however regarding values in the the quantity column, how did you come by ,can help me with that, is it a default column in P6? THANKS
Hi Ayebida, You can get this columns in several ways, on of them is to add a new materials resource. To do that go to Enterprise then choose resources... then from there you can add a new resources from many choices like labours, non-labours and materials ... etc. Hope this is useful ❣️
manhour got distributed monthly, then he divided with no, of working hours per month to get no. of person. when you add calendar of 6 working day with 10 hour per day work, monthly hour will become 260.
@@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
![FNAF vs TF2 - Episode 2 [SFM]](http://i.ytimg.com/vi/z5b3V2-VLb0/mqdefault.jpg)
Good explanation we are expecting more videos to update our knowledge
Will upload soon ❣️
Sir, Very Good Explaining, Useful and Guidance, Thanks
Thank you Farooq
Grt ! Video crystal clear explained.
Glad you liked it
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??
Great Video!!!!
For manhour average, why do you devided by 260.
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
How did you incorporate Qty and Std.Mh in user defined fields? Manually or Automatically?
You can import by excel
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
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
HI, I have a question regarding the Standard Manhours. The formula is showing Manhours= Qty x Standard MHR. Where we get from Standard MH based on what? Could you expain?
Hi Mohammed
This depends on many factors like the items and the ability of labours. This can be different from one company to another at the same country and it can be different from one area to another. Anyway, I can provide you with a standard manpower productivity at your email.
@@extrainch4188 All video are good bit little bit speed and I can recommend some more lesson like EVM calculations, recovery and revised through in P6, risk analysis, extensions of time in P6.....I would appreciate if you provide.. 👏👏👍
@@extrainch4188 one more thing, as shown in P6...in s curve. Wheyher it's possible to o provide in excel sheet
How to do.......I can recommend some of my colleagues to watch and subscribe...you are doing very nice effort and good dedication
Thank you
Thanks alot Mohammed
@@noufalsm ME TOO
Good video. One advice is to please improve the video clarity...
Thanx Fasi for your comment, we are working to improve our quality. Thanx for passing by ❣️
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 have a logical question. How come that the quantity graph represents more than one unit of measurement in the histogram
Logically it is not correct. But he added qty as non labor unit. so P6 is treating it like hours.
Hi, this is one of best tutuorials I have watched on P6,
however regarding values in the the quantity column,
how did you come by ,can help me with that, is it a default column in P6?
THANKS
Hi Ayebida,
You can get this columns in several ways, on of them is to add a new materials resource. To do that go to Enterprise then choose resources... then from there you can add a new resources from many choices like labours, non-labours and materials ... etc. Hope this is useful ❣️
@@extrainch4188 Thanks, Do you offer live online courses in P6. I need more clarification on this please
Hi please do you offer one on one online courses in P6
@@ayebida6620 he has added user defined field
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
For manpower calculation, why do you calculate the average by an average of 260?
52 weeks (1 year) x 5 days work week = 260
manhour got distributed monthly, then he divided with no, of working hours per month to get no. of person. when you add calendar of 6 working day with 10 hour per day work, monthly hour will become 260.
Thank you
You are welcome
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