To export Activity Codes or WBS as bands to Excel

Hi friends,
1- export all activities to DBF Format. (Tools/Project Utilities/Export)
2- open created Dbf format file into Excel.
3- save mentioned file to excel format.
4- select all data
5- sort based on WBS or Suitable Activity code ( as per your request)
6- create subtotal ( data/subtotals/) based on Wbs coulmn or activity code column ( as per your request)
7- have a good time

thanks

Hi All!
Pivot Table is the easiest way out but difficult if you want to do further arithmetic operations.
You can use Infomaker or even MSaccess database (via ODBC) to create custom report. For your case, "Activity Codes" have to be placed in Header. Specify grouping levels and description, Act ID, PCT, OD, RES, BQ etc. may be placed in Details field. The report you generate here can later be copied into Excel.
Another workaround is to ask your boss/customers to wait for the next release of P3.

:D
Neeraj

Yes I aggree w/ Mr Taguinod, But Using Database is more efficient. Try

Not possible.

But what you can do is export activity codes or wbs together with activites and then use Excels Pivot Table or Group and Outline Function to attain this format.

Good luck.

Jorge

I usually copy and paste the activities from Excel as it is possible to display the Activity Code Descriptions in columns, whereas in P3 you are only able to disply the Activity Codes.

I the use the Excel Subtotal function to put in the band headings and then delete the subtotal, that one has to generate with the subtotal function, if I do not want the sbtotal.

Regards

Paul E Harris
<a href="http://www.eh.com.au">Eastwood Harris Pty Ltd</a>