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.
Member for
19 years 3 monthsRE: Data field missing in P3 ?
thanks
for BQWS, I am using the current project for calculating earned and planned value
regards
MORPH
Member for
21 yearsRE: Data field missing in P3 ?
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.