Exporting time based periodic data to Excel

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...

Hi,
Actually I need to prepare a Progress S-curve from the periodic data in Excel.

Harish

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

Support \ Utilities \ ImportExport

Dear Tamas Sipos,

I tried the Import / Export, but I couldn’t get periodic data, means loading of cost or resources.

Regards,

Harish

Hi,

Can somebody help me out??

Regards,

harish

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

I forgot to log in... :(
I posted this one below.

Regards

Tamas

Thanks Mr.Tamas Sipos

It is working very much..

Regards,

Harish