How to get planned % weight from P3.1?
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Joseph,
The process to get planned % weight and eventually the actual one is very long and complex but it gives very good results :
1 ) Declare a resource (weight);
2 ) Assign the weight of each tash of the schedule;
3 ) Declare resource variables under Custom Data Items;
4 ) Run Report Writer to generate Level 1/2/3 Progress Reports. This requires a good understanding of P3 macro-programming under Report Writer ;
5 ) Generate reports in CSV Format to allow use with Excel;
6 ) Update your "S" Curve in Excel Format.
Regards,
Lotfi
Rollen,
tnx for that, it surely helps..
tnx guys
Why Excel?
Just because it’s a program they know
or are they gonna use it for something?
Svein
Hi Joseph,
Here is one way you can transfer your curve, graphics to excel or word.
In primavera look, where your curve, graphics are being displayed. Choose menu option - Edit, Select all,or simply control A.
Now, switch to your excel file choose menu option, edit,paste special, (make sure you do not paste this time),select picture(enhanced metafile). Then you will see your graphics in the same way as what you see in Primavera Look. You may resize according to your preference.
Hope this helps,
Cheers,
Rollen
Thank you james...
joseph
Joseph,
Im sure there is a way to export the curve to excel, I think its been discussed else where on these forums. As a last resort to could always transfer the curve into excel manually.
You can show planned percentage complete based on duration. You should be able to select planned percentage complete as one of the columns to display, if I remember correctly.
Regards
James
Good day,i already generated a curve...but our client want it to be ploted on excel format...is there any way that a curve generated from p3 can be transfered to excel?
and if there will be no resources is it possible for p3 to give the planned percent weight each week?
tnx,
joseph
You need to add a resource or cost to each activity before you can generate a curve.