P3 to Excel Template Reports

Gary,

IMHO one of the major drawbacks of P3 is the quality of presentation of reports available. The reason people export data to Excel is to provide the presentation that is common place these days. The actual data is no different, but the presentation of the data is always a useful means toward acceptance.

There are several methods of exporting data to Excel (or Access), from within P3 you can export info to Excel readable files (Lotus) or export to DBF files that can be read by Access.

Easiest method is to copy & paste directly.

There are some reports which provide output to Excel which can be then used for further processing (Tools, Tabular Reports, Resouce, Loading) gives the distribution of Quantity over time (there is an equivalent one for cost)


HTH

Gary,

IMHO one of the major drawbacks of P3 is the quality of presentation of reports available. The reason people export data to Excel is to provide the presentation that is common place these days. The actual data is no different, but the presentation of the data is always a useful means toward acceptance.

There are several methods of exporting data to Excel (or Access), from within P3 you can export info to Excel readable files (Lotus) or export to DBF files that can be read by Access.

Easiest method is to copy & paste directly.

There are some reports which provide output to Excel which can be then used for further processing (Tools, Tabular Reports, Resouce, Loading) gives the distribution of Quantity over time (there is an equivalent one for cost)but with large numbers (I think the field limit is 10 characters) I have noticed some inaccuracies in the transfer.


HTH

Hi

I did found P3 can produce some very useful report like
S-Curve with EV
Resource Histogram in $ & Hrs

for the basic operation of Project

Alex :)

Exporting outside P3, is better using the dbf format, also if you will organize your data with excel.
Exporting in wk1 you can find with big surprise that all the data were not exported successfully.
There is a limitation in 1024 rows (including one heading row).

Exporting with ODBC is great for small schedule, or you can encore in an out of time message.
More over I had always problems with the P3 ODBC, as look like P3 is not able to replicate completely the its own databases. Having problem after to link the tables.

Primavera has also nice tools like RA engine and Report maker or writer that may be another solution.

Gary,

I would suggest that you get to grips with the standard graphic reports in P3 first.

Once you know the graphic reports, you can start to create custom reports and pull it into Excel.

Regards

Erik