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.
Member for
19 years 5 months
Member for19 years5 months
Submitted by James Griffiths on Mon, 2006-09-11 10:07
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.
Member for
19 years 2 monthsRE: Exporting timescaled data to Excel
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.
Member for
19 years 5 monthsRE: Exporting timescaled data to Excel
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.