How to get planned % weight from P3.1?
Mon, 2006-06-05 07:53
Good day guys,
does anyone know how i can determine the Planned % weight for the whole project? so that i can plot it on S-Curve using Excel.
thanks
does anyone know how i can determine the Planned % weight for the whole project? so that i can plot it on S-Curve using Excel.
thanks
Printer-friendly version- Login or register to post comments
Send to friend
Wed, 2006-06-14 06:26
#1
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
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
Sun, 2006-06-11 01:51
#2
Rollen,
tnx for that, it surely helps..
tnx guys
tnx for that, it surely helps..
tnx guys
Fri, 2006-06-09 08:18
#3
Why Excel?
Just because it’s a program they know
or are they gonna use it for something?
Svein
Just because it’s a program they know
or are they gonna use it for something?
Svein
Fri, 2006-06-09 01:19
#4
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
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
Wed, 2006-06-07 00:47
#5
Thank you james...
joseph
joseph
Tue, 2006-06-06 11:25
#6
Joseph,
I’m sure there is a way to export the curve to excel, I think it’s 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
Tue, 2006-06-06 08:42
#7
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
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
Tue, 2006-06-06 07:51
#8
You need to add a resource or cost to each activity before you can generate a curve.
Replies