Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver 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.

Data field missing in P3 ?

2 replies [Last post]
Thu, 2006-09-07 12:07
Morph T
User offline. Last seen 18 years 22 weeks ago. Offline
Joined: 8 Aug 2006
Posts: 55
Groups: None
Hi all

I linked excel to P3 using ODBC Btrieve driver, using advanced mode so all data table are load, but I can’t find data field BQWP, and BQWS.

Basically, what I want to do, is having my spreadsheet dynamically link to P3, showing activities grouped by resource and columns BQWS, and BQWP, AQWP.

Ps: I can do that by tool, tabular report, resource. But exporting then coping and posting each time when I update my plan is rather a painful process.

Regards
Morph

Top

Replies

Sat, 2006-09-09 06:18
#1
Morph T
User offline. Last seen 18 years 22 weeks ago. Offline
Joined: 8 Aug 2006
Posts: 55
Groups: None
thanks

for BQWS, I am using the current project for calculating earned and planned value



regards

MORPH
Top
Thu, 2006-09-07 14:12
#2
David Kelly
User offline. Last seen 2 years 46 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630
Groups: Petro-Chem / Oil & Gas
Morph,

Its a while since I have done this. But if I remember correctly BQWP can only be inferred from the resource table by multiplying the BQ by the percent complete in that table. BQWS is NOT held in the current project, but is calculated on the fly depending on which target project is chosen ( needing two projects connected by ODBC will slow your spreadsheet down to a crawl) and AQWP is just QTYToDate in the resource table.

I wish you luck, Calculating BQWS from a dynamically linked target project sounds too difficult.
Top