Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Exporting time based periodic data to Excel

9 replies [Last post]
T M Harish
User offline. Last seen 12 years 1 week ago. Offline
Joined: 29 Jul 2003
Posts: 19
Hi all,
Can anyone explain me about how to export time baased periodic data to excel from P3e/c, similar to what we were doing in tabular reports in P3(*.wk1 extension)?

Regards,

Harish

Replies

T M Harish
User offline. Last seen 12 years 1 week ago. Offline
Joined: 29 Jul 2003
Posts: 19
Thanks Mr.Tamas Sipos

It is working very much..

Regards,

Harish

Tamas Sipos
User offline. Last seen 5 years 17 weeks ago. Offline
Joined: 2 Mar 2004
Posts: 13
I forgot to log in... :(
I posted this one below.

Regards

Tamas
Forum Guest
User offline. Last seen 2 years 28 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
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
T M Harish
User offline. Last seen 12 years 1 week ago. Offline
Joined: 29 Jul 2003
Posts: 19
Hi,

Can somebody help me out??

Regards,

harish
T M Harish
User offline. Last seen 12 years 1 week ago. Offline
Joined: 29 Jul 2003
Posts: 19
Dear Tamas Sipos,

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

Regards,

Harish
Tamas Sipos
User offline. Last seen 5 years 17 weeks ago. Offline
Joined: 2 Mar 2004
Posts: 13
Support \ Utilities \ ImportExport
Tamas Sipos
User offline. Last seen 5 years 17 weeks ago. Offline
Joined: 2 Mar 2004
Posts: 13
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
T M Harish
User offline. Last seen 12 years 1 week ago. Offline
Joined: 29 Jul 2003
Posts: 19
Hi,
Actually I need to prepare a Progress S-curve from the periodic data in Excel.

Harish
Forum Guest
User offline. Last seen 2 years 28 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
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...