Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Help with Histogram Excel

5 replies [Last post]
Mohamed Abraar
User offline. Last seen 5 years 15 weeks ago. Offline
Joined: 26 Feb 2017
Posts: 11

hi guys,

 

i want to make a labor histogram for interior fitout manufacture or production, 

how can i make days ,hours for 4 month, i have labors catergory carpenter, fabricators, helpers.

 

with MS EXCEL i want to make siomple with 2d graph.please help me guys all i wnat is column and formula,hope i ll get some help

Replies

Zoltan Palffy
User offline. Last seen 27 weeks 17 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

create a resource call it lumpsum make it labor and the default 8 hr/day

make sure that calculate costs from units is NOT checked.

filter for all of the activites that you want resources on

then highlight them all right click and select Assign then resource and select lumpsum or the one you just created

this will automatically multiply the duration by 8 to give you units ie. 5 days = 5*8=40 hours so thats 1 man on that activity for 5 days 

you change the unist to whatver you want or you can export the Budgeted Labor units to excel then change the units in excel 

and then import the correct units back into p6

after that select view show on bottom resource usage profile and you histogram is there

 

 

Mohamed Abraar
User offline. Last seen 5 years 15 weeks ago. Offline
Joined: 26 Feb 2017
Posts: 11

someone reply,its urgent

Mohamed Abraar
User offline. Last seen 5 years 15 weeks ago. Offline
Joined: 26 Feb 2017
Posts: 11

primavera and excel i have

Mohamed Abraar
User offline. Last seen 5 years 15 weeks ago. Offline
Joined: 26 Feb 2017
Posts: 11

primavera and excel i have

Zoltan Palffy
User offline. Last seen 27 weeks 17 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

what schedule package are you using  ?