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.

Activity usage spreadsheet issue

1 reply [Last post]
AB Timo
User offline. Last seen 6 years 38 weeks ago. Offline
Joined: 22 Jun 2011
Posts: 108
Groups: None

Hi all P6 Users.

White using activity  usaege spreadsheet  tab to calculate the monthly accumulative PV and Ev, I have encountered the following Problem.I hope someone can suggest the solution.

Activity spreadsheet window- --> right click ---> spreadsheet option ----> "calculate average" --->here i have to enter 1853469.89 (cost is 185346989 Sr / 100 = 1853469.89) , but it is not taking complete value i,e not taking more than 6 digits number). can you check this option and solve the issue????




Aries Arian
User offline. Last seen 10 years 5 weeks ago. Offline
Joined: 21 Oct 2011
Posts: 12
Groups: None

Hi Faiz,

Why do't you export your values from spredsheet in "excel",and work there.