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.

Time Distributed curve

28 replies [Last post]
Sat, 2008-04-26 23:29
shiv rao
User offline. Last seen 11 years 38 weeks ago. Offline
Joined: 10 Mar 2008
Posts: 62
Groups: Petro-Chem / Oil & Gas
Hi Guys ,

While doing the time distributed curves , i have found that some places planners are using early and late curve . How do we select this data as i dont see then in the column Selection .

Please help.

Regards

Shiv Rao
Top

Replies

Sat, 2016-06-18 15:08
#1
Sooraj Sivarajan
User offline. Last seen 7 years 44 weeks ago. Offline
Joined: 18 Jun 2016
Posts: 3
Groups: None
Hi sir, Please help to do weekly Progress report in Epc sector.plz send to a format to sooraj39@gmail.com
Top
Sat, 2016-06-18 15:05
#2
Sooraj Sivarajan
User offline. Last seen 7 years 44 weeks ago. Offline
Joined: 18 Jun 2016
Posts: 3
Groups: None
Hi sir, Please help to do weekly Progress report in Epc sector.
Top
Thu, 2008-05-15 13:46
#3
Arnold Puy
User offline. Last seen 9 years 12 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Thanks Alex.
Top
Wed, 2008-05-14 21:08
#4
Alex Wong
User offline. Last seen 11 years 4 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Arnold

I had already addressed it if you read my postings.

You don’t need to export it to see by %. Check how - read the posting.

Good luck.

Alex
Top
Fri, 2008-05-09 10:43
#5
Arnold Puy
User offline. Last seen 9 years 12 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Alex,

Yes you are right! We can easily Copy & Paste the "RESOURCE ASSIGNMENT" to excel. however, we are talking about the Activity & Resource Usage Spreadsheet according to Mr. Sad’s question.

If there is a way to Export directly to Excel for Activity & Resource Usage without generating Reports then, perhaps you can share to us if HOW to do it? For showing the Values of Curves & Histograms, I think this features is not supported by P6.

Regards,

Arnold
Top
Thu, 2008-05-08 20:31
#6
Alex Wong
User offline. Last seen 11 years 4 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Arnold

Dont understand, U can directly copy and paste from the "ASSIGMENT" screen, In addition you can display format / unit ... what ever you like in the scale.

Unless we are using a different software, I believe this is rather simply to do what you are asking for.

Good Luck

Alex
Top
Thu, 2008-05-08 00:11
#7
Satya Narayana
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
Thank you, I have tried but couldnt find the options for displaying values and i thought Primavera should have such obvious features and may be i am missing them.

Thanks

Sat
Top
Wed, 2008-05-07 13:28
#8
Arnold Puy
User offline. Last seen 9 years 12 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Sad,

You cannot export directly the activity and resource usage spreadsheet to excel without generating reports and you cannot show the values on the curves and histograms.

Arnold
Top
Wed, 2008-05-07 03:15
#9
Oliver Melling
User offline. Last seen 4 years 30 weeks ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
But how are you supposed to make your performance match what the PM says it is if you don’t export it into excel?
Top
Wed, 2008-05-07 03:00
#10
Satya Narayana
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
Thank you, U r right.
I was wrongly thinking it shall allow only up to 999,999 but we can go up to 99 million, though the project cost is in billions we can just keep at as billion of currency.
It works.

Coming to the question again, can i export the activity and reosurce usage spead sheet directly to excel without going to reports. can we show the values on the curves and histograms??
Top
Wed, 2008-05-07 02:15
#11
Alex Wong
User offline. Last seen 11 years 4 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
and beside you only have 2 decial points you can display in P6

it becomes pointless to be accurate down to 6 decimal point

Your management team need to be a bean counter to be so accurate.

Well Project Management is never about pin point accuracy, its about how to manage the info to give the best possible outcome

Good Luck

Al
Top
Wed, 2008-05-07 02:11
#12
Alex Wong
User offline. Last seen 11 years 4 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
you can divid up to 6 digit

meaning up Divid 1 to 99,999,999

Unless you have 100 million then you should be ok
Top
Wed, 2008-05-07 01:58
#13
Satya Narayana
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
But unfortunately we have quantities and costs in millions so that was not working unless we change the units to million of Cu.m etc.
Top
Wed, 2008-05-07 01:50
#14
Alex Wong
User offline. Last seen 11 years 4 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Hey PPs

Don’t export it out
its very very simple - all you need is some basic maths knowledge

Using the same example
Total plan quantity is says 15,000 m3

then all you need to do is to use
the resource usage profile, resource usage profile option,- Graph, tick the "calculate average" and Divide the total by 150 (% = Accumulated value / 15,000 * 100%) and change the symbol to %

Done

Simple

Alex
Top
Tue, 2008-05-06 11:22
#15
Oliver Melling
User offline. Last seen 4 years 30 weeks ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
1-0
Top
Tue, 2008-05-06 11:19
#16
Gordon Blair
User offline. Last seen 6 years 12 weeks ago. Offline
Joined: 29 Jul 2005
Posts: 166
Groups: None
or even create a new one if you’re not as workshy as Oliver.
Top
Tue, 2008-05-06 10:32
#17
Oliver Melling
User offline. Last seen 4 years 30 weeks ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
Not used P6 but you will be able to export reports into .csv format for manipulation.

Use the wizard to edit an existing report.
Top
Tue, 2008-05-06 07:12
#18
Satya Narayana
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
thank You, can i export the resource usage and activity usage spread sheets directly into excel or csv.
If i can How??
Top
Tue, 2008-05-06 04:04
#19
Oliver Melling
User offline. Last seen 4 years 30 weeks ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
Export a budgeted units profile to excel, then work out the monthly cumulative as a percentage of the total budget.
Top
Mon, 2008-05-05 05:47
#20
Satya Narayana
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
"I don’t know how long you sat already. "

What does this mean.

The feature i was asking was already in P3 and i have used it a lot for presenting things to higher management who understand percentages.

coming to the calculator can we use the formulas as we use in spread sheets in P6??

Top
Mon, 2008-05-05 04:16
#21
Dieter Wambach
User offline. Last seen 7 years 5 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
I don’t know how long you sat already.
1. m3: Material is a resource. You can enter the budgeted quantity, P6 will then calculate the qty per day based on the duration. For the percentage you can use a UDF and a calculator or Global Change
2. Cash flow is related to money. Price per m3 will give the figure per month to you. For material resources histograms and curves are displayed for costs, not for the physical quantities. It is a requirement for an add-on from some German companies to Primavera.
3. Resources: See resource usage profile or -Spreadsheet

Top
Mon, 2008-05-05 01:13
#22
Satya Narayana
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
suppose i have 1 million m3 of earthwork (fill) to be executed then i just want to see what percentage of work should i execute each month. same with the cash flow or resources etc.
Top
Mon, 2008-05-05 01:06
#23
Dieter Wambach
User offline. Last seen 7 years 5 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Mouse into the histogram area --> right click --> "Resource Profile Options" --> cumulative --> I assume you mean Budgeted --> select --> "Apply"
You’re welcome!
Top
Mon, 2008-05-05 00:55
#24
Satya Narayana
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
The percentage of Quantities of work to be executed or the percentage distrubution of resource usage.
Top
Sun, 2008-05-04 02:59
#25
Dieter Wambach
User offline. Last seen 7 years 5 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Hi
which percentage option? What do you want to express and where?
Dieter
Top
Thu, 2008-05-01 01:34
#26
Satya Narayana
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
I found the early, late on Resource usage profile but could not find the Perecntage option
Top
Thu, 2008-05-01 01:26
#27
Satya Narayana
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
Dieter,

I am using p6 and do not see that early, late there. I cannot get the Percentage as i used to get in p3, can you help me out.
Top
Sun, 2008-04-27 03:53
#28
Dieter Wambach
User offline. Last seen 7 years 5 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Hi Shiv
It’s the resource usage profile.
moe the mouse inside --> right click --> ...options
Hope that helps
Dieter
Top