Hello. I am a project manager for a design consultancy and we currently use P6 to manage out programmes, and then an excel sheet as a visual representation for lookahed purposes. My manager has requested that i investigate whether there is a better way of doing things rathetr than doubling ip on work and populating a s/s from multiple P6 printouts.
Do you have any specific filters that you use / excel sheets that you populate that make P6 a bit more visual to look at for a lookahead point of view?
I currently have an excel ‘workload planner’ (below example) that has everyone on one excel sheet and their daily tasks (green for work, light green for checking, yellow for out of office work, red for annual leave). I find that P6 is a little too much information overload and doesn’t often go into the nooks and cranny’s of daily tasks as it simply has a timescale that you know an activity is happening over.
I have made myself a lookahead filter but seems I can only do this by project and again I feel that I need more control over resources.
[[wysiwyg_imageupload:5877:]]
view show on bottom activity usage spreadsheet or resouce usage spreadsheet
"Essentially my manager does not want to read any programmes and just wants a brief excel version of what each engineer is doing on a daily basis. I have allocated the correct number of hours per activity in my plan and update them on a scheduled timeframe, however I am siply looking for a simple visual way of showing the day and what activity is carried out that day."
Using the REsource usage pane, Organize the layout as follows:
1. Start .. Group Interval by Day
2. Task
3. Responsibility
In my prior posting I was showing cummulative hours for a single resource. But reports can be as per other requirements. In the following image I show for all resources hours/day/job. Just save your reports definitions and get them at a single click of the mouse, cannot be any easier.
Zoltan,
Apologies I'm maybe finding it difficult to explain as I am relatively new to the world of P6 and planning.
Essentially my manager does not want to read any programmes and just wants a brief excel version of what each engineer is doing on a daily basis. I have allocated the correct number of hours per activity in my plan and update them on a scheduled timeframe, however I am siply looking for a simple visual way of showing the day and what activity is carried out that day.
I currently use filters for 2-weeks, 4-weeks and 6-months but was just wondering if there was a better visualisation tool to show this.
Thanks for any help
thsi statement contraticts itself
"I find that P6 is a little too much information overload and doesn’t often go into the nooks and cranny’s of daily tasks as it simply has a timescale that you know an activity is happening over."
"you could nto be more wrong to say that it simply has a timescale that you know an activity is happening over"
you excel worksheet is NOT time sensitive noting in the world is except a cpm schedule. When you change 1 litle thing in excel you NEVER see how it effects other things.
I would like to point out that you can use chaneg the palnning units to hours and you can sechedule down to minute if you wish to. you can create as many nook and crannies that you like.
P6 is used for outage work that cost millions of dollars per day whee there is an outage. They schedule down to the hour or minute so I dobnt that your engineering schedule would need more nooks and crannies than an outage schedule.
I suggest creating the enginerring activites and assign resource to them with the appropriate manhopurs per activity and tack it that way.