Import to Excel

Submitted by alberto claveron on
Primavera Project Planner - P3

Member for

17 years 5 months
Member for 17 years 6 months
Submitted by Safak Vural on Thu, 2010-03-25 06:32
Permalink

Dear Alberto,



Select export to CSV file and use 2 decimals.



You may need to change decimal sign of windows . to , or vice versa.



Regards,



Safak VURAL




Member for

17 years 1 month
Member for 17 years 2 months
Submitted by alberto claveron on Thu, 2010-03-25 01:59
Permalink

Hi Safak & Harzelli,

I did what you have suggested but when i generate report in P3 a message shows "A Rich Text Format Document is too long.Failed to open Document".If i export it in CSV Format some of the activities which i input million units say 11,031,635.21 becomes 11,031.00.Changing number of digits in cell format in excel doesn’t make a difference too. My schedule has 635 activities and 94 weeks duration.

Thank you & Regards...

Member for

17 years 5 months
Member for 17 years 6 months
Submitted by Safak Vural on Wed, 2010-03-24 07:55
Permalink

Hi,



You shall make column width 15(max) and decimal 2(max) at Format Section of your Loading Report Interface in P3.



Regards,



Safak VURAL

Member for

17 years
Member for 17 years
Submitted by harzelli bouasria on Wed, 2010-03-17 05:58
Permalink

hi

open your file with excel and change number of digit with cell format