Resource lookahead

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.

• If you run multiple design jobs at the same time and they share designers you shall be using Enterprise Portfolio Management Software capable of resource leveling common resources among different jobs.
• If your designers work on several jobs at the same time a few hours per day on each job you shall be using partial workloads assignments.
• If you use several designers that must work together as a team and others that can work as a separate team you need to use team assignments.
• The table reports shall give you the information you need.  If you do not know at any time at a click of the mouse where your resources are assigned you are lost.

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.