Exporting timescaled data to Excel
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
I like the pivot table idea, Ill look into that. Ideally Id like this to be a direct data dump from MSP which requires no further work in excel.
It will be used by bid managers to help compile a future work model for each discipline based on the probability of winning the work. It would be much easier to do in P3e but unfortunately were stuck with this system at the moment.
Cheers for the tip.
Kym.
Kym,
There is a variety of ways that you can do something very similar. The best method is dependent upon exactly what results youd like to achieve. You could save/export as a pivot table. You could do a "Group By...Resource Code", select the relevant activities, and then use the Analyse Timescale Data. This would give you one "XL file" per resource group. Subsequently you could transfer all the other data to just one of the files and combine them.
Another way, is to go into the Resource Sheet, select the individual resource names that form one resource group, and then Analyse Timescale Data. This would also give you one XL file per "resource group". Combine them all afterwards.
Precisely what you do will be dependent on whether it is just a one-off, something regular /frequent and how many resources you have.
HTH.
James.