To export Activity Codes or WBS as bands to Excel
Forum Sponsor
Top Posters
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
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
Eastwood Harris Pty Ltd