Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

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.

Import to Excel

4 replies [Last post]
Wed, 2010-03-17 01:27
alberto claveron
User offline. Last seen 10 years 16 weeks ago. Offline
Joined: 8 Sep 2008
Posts: 7
Groups: Petro-Chem / Oil & Gas

Some activities of my resources has 8 digits number,but when i import it in Excel using Resources-Tabular-Loading and save it in DBF format the figures has been limited to 5 digits.Please help how to correct so i can make my weekly plan & "S" cuve.

Thank you.
Top

Replies

Thu, 2010-03-25 05:32
#1
Safak Vural
User offline. Last seen 4 years 23 weeks ago. Offline
Joined: 12 May 2008
Posts: 117
Groups: Petro-Chem / Oil & Gas
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


Top
Thu, 2010-03-25 00:59
#2
alberto claveron
User offline. Last seen 10 years 16 weeks ago. Offline
Joined: 8 Sep 2008
Posts: 7
Groups: Petro-Chem / Oil & Gas
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...
Top
Wed, 2010-03-24 06:55
#3
Safak Vural
User offline. Last seen 4 years 23 weeks ago. Offline
Joined: 12 May 2008
Posts: 117
Groups: Petro-Chem / Oil & Gas
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
Top
Wed, 2010-03-17 04:58
#4
harzelli bouasria
User offline. Last seen 5 years 5 weeks ago. Offline
Joined: 15 Oct 2008
Posts: 42
Groups: Petro-Chem / Oil & Gas
hi
open your file with excel and change number of digit with cell format
Top