want to extract Activity Usage Spreadsheet on desired WBS

hi to all,

i am searching a way to extract Activity Usage Spreadsheet from P6 to Excel for desired WBS.

i have loaded cost on Engineering, Procurement & Construction Phases & my Performance Percentage Complete is 12.72%.

here i want to see Planned & Actual Cost only for my Construction phase in Activity Usage Spreadsheet. I tired by using filter as well but it didn’t work.

Would anyone please tell me how to solve this issue.

thanks….

A
Arnold Puy 👤 Member for 19 years 2 months

Hi Irfan,

In order to perform this please follow the following steps as shown below:

1. Go to --> Edit --> Select All, when done, again Edit --> Copy

2. Open an Excel sheet and select Paste

[[wysiwyg_imageupload:1755:]]

 [[wysiwyg_imageupload:1756:]]

You can also go to View --> Group & Sort 

Hope this helps.

Cheers,

Arnold

Featured Partner

Top Posters

Tijo Kurian
11 posts
Zainab El-Beialy
3 posts
Kamlesh Parmessur
4 posts
MR JUDE C ANYAEGBU
0 posts
GeoVe
0 posts
Ashkan Mohammadi
0 posts
Jeroen De Bauw
0 posts
Senior Planning Engineer
0 posts
Kristian Mcwilliams
1 posts
dagogo dan - jumbo
2 posts