Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Difficult Layout Question

12 replies [Last post]
John Peter
User offline. Last seen 11 years 16 weeks ago. Offline
Joined: 12 Mar 2011
Posts: 26
Groups: None

Can we do layout in Primavera where we show spreadsheet view on top and underneath we show resource histogram

I try to create this in excel to give you clear pitcure of my question

849
possiblelayoutinprimavera.jpg

Replies

Rafael Davila
User offline. Last seen 5 weeks 1 day ago. Offline
Joined: 1 Mar 2004
Posts: 5241

Photobucket

Note: Resource center 1 was defined to include all labor resources.

  • Do you mean P6 cannot handle correct distribution for multiple past periods ending at different dates? Still incapable of figuring the simple math, similar to ancient P3?
  • What do you do when different jobs on a same portfolio require different updating periods?
  • Do you know we report payroll usually on a weekly basis and that our months almost never end at the same time our weeks do? Any serious software shall be capable of applying the correct distribution no matter if actuals were reported uniform or not, just apply the distribution in accordance to reported values.

I do not expected for P6 reports be in the form of tables you can horizontal scroll, sort and filter before printing as you can in Excel and Spider Project Reports, this in most instances can eliminate the need for printing long reports from multiple report definitions. But I was hoping at least that by this time the limitation on financial periods was already solved. Hard to believe.

As a matter of fact many times our payment applications are dated a couple of days after end of month, this to include work like a big concrete pour that represents a large amount of money. We are not penalized because of a couple of days but our certifications represent legal documents that must be accurate. I remember having issues when required to model Payment Applications using old P3 and SureTrak, it was difficult for some inspectors to understand this flaw in these products that would change distributions because of unfinished activities from previous periods when your cutoff did not matched a pre-defined financial period. Of course the limitations on SureTrak were even worst.

I must be missing something as even Asta PP got it right, after you report some update the rate of progress remain fixed on reported periods and any new period can be updated with its own progress rate.

Photobucket

Paul Harris
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 11 Apr 2001
Posts: 618

Financial periods is a logical way to do this but they may not be displayed in the Projects window.

If you wanted to create  Financial Periods for each month and do period processing for each period this should be achievable, but I think it would be a bit of messing around. You would need to opem all the projects and in the activity view and sumerise at project level.

You could also create a User Definable field for each period and put the data against each value.

Maybe get a report written! 

Paul E Harris

Director Eastwood Harris Pty Ltd
www.eh.com.au and  www.eastwoodharris.com
www.primavera.com.au - this is a new Primavera Software resources web site.
Project Control Consultants and Planning and scheduling software book and training manual publishers

Paul Harris
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 11 Apr 2001
Posts: 618

Financial periods is a logical way to do this but they may not be displayed in the Projects window.

If you wanted to create Financial Periods for each month and do period processing for each period this should be achievable, but I think it would be a bit of messing around. You would need to open all the projects and in the activity view and sumerise at project level.

You could also create a User Definable field for each period and put the data against each value.

Maybe get a report written! 

Paul E Harris

Director Eastwood Harris Pty Ltd
www.eh.com.au and  www.eastwoodharris.com
www.primavera.com.au - this is a new Primavera Software resources web site.
Project Control Consultants and Planning and scheduling software book and training manual publishers

Rafael Davila
User offline. Last seen 5 weeks 1 day ago. Offline
Joined: 1 Mar 2004
Posts: 5241

I am not a P6 user but occurs to me maybe at the Bucket Planning View you can see the resource usage at the top and the histogram at the bottom.

Unless bucket planning respect rules of logic as implemented on your software it shall not be used for resource assignments per se.

In any case by creating a report template at a single click of the mouse you shall be able to get the table, at another click you shall be able to export it to Excel and there with another few clicks you will get your histogram.

click, click, click ...

John Peter
User offline. Last seen 11 years 16 weeks ago. Offline
Joined: 12 Mar 2011
Posts: 26
Groups: None

<blink>still no reply from world leadingplanning  platform</blink>

John Peter
User offline. Last seen 11 years 16 weeks ago. Offline
Joined: 12 Mar 2011
Posts: 26
Groups: None
Please reply
John Peter
User offline. Last seen 11 years 16 weeks ago. Offline
Joined: 12 Mar 2011
Posts: 26
Groups: None

No Possible Solution Yet

John Peter
User offline. Last seen 11 years 16 weeks ago. Offline
Joined: 12 Mar 2011
Posts: 26
Groups: None

Thanks Sam did you try to print this out its not printing it just shows spreadsheet when i do the print preview 

 

Any comment on it 

Sam .
User offline. Last seen 8 years 28 weeks ago. Offline
Joined: 20 Aug 2009
Posts: 15

850
tracking.jpg

Hey John,

 

Try going to the "Tracking" area in P6.

 

You can manipulate the top area to Gantt, Spreadsheet or Resource Profile, and the bottom area should show the histogram.

 

You can select one or multiple projects in the left hand "Project" Display.

 

Hope that helps.

Sam .
User offline. Last seen 8 years 28 weeks ago. Offline
Joined: 20 Aug 2009
Posts: 15

edit above ^^

John Peter
User offline. Last seen 11 years 16 weeks ago. Offline
Joined: 12 Mar 2011
Posts: 26
Groups: None
No answer yet
John Peter
User offline. Last seen 11 years 16 weeks ago. Offline
Joined: 12 Mar 2011
Posts: 26
Groups: None

No replies :(