Exporting time based periodic data to Excel

I forgot to log in... :(

I posted this one below.



Regards



Tamas

Harish,



Try this, but I have a sense that you don’t need THIS solution.



1. Open your project,

2. Click on ’Activities’ bitbtn on the places-bar on the left,

3. Click on ’Activity Usage Profile’ tool on the upper Toolbar,

4. Select ’Show usage for’ ’All activities’ radio-button,

5. Select ’Tools // Report Wizard...’ from the main menu,

6. Select ’Use Current Screen’ radio-button, click Next,

7. Turn on ’Time Distributed Data’ check-box and then

Select ’Resources’ from the list, click Next,

9. Click ’Fields...’ button and select required fields from ’Available Options’, click OK, click Next,

10. Select ’Timescale’, ’Time interval’ fields with the buttons,

and other options with checkboxes below, click Next,

11. Group and sort in the next screen,

12. Filter in the next screen,

13. Change column sizes or Autosize if it’s ok for you, click Next,

14. Title your report, click Next,

15. Run your new report with ’Run Report...’ button,

16. Send report to an ASCII Text File by selecting ’ASCII Text File’ radio-button,

(browse target folder and type filename with

the ’...’ button next to Output file input-box.), click OK,

17. Click ’Next’ to save your new report,

18. Click ’Finish’,

19. Browse your saved text file in Excel, select All files from File type listbox

20. Check ’Comma’ check-box to separate fields.



Best regards,



Tamas

Support \ Utilities \ ImportExport

Hello!

There is a folder named Support on the P3E CD #2. In this folder you can find SDK Samples and Utilities.

So in the SupportUtilitiesImportExport folder you can find the "magical" Import/Export utility.

This is a self explaining tool, so have a nice exporting.

Regards

Tamas

GOOD DAY



Actually ..u dont need to transfer data to excel anymore



only u can export to p3 or ms project and then u can start from there to the excel...



but y ????



they r both a data base now....



i think so...