Data field missing in P3 ?
Forum Sponsor
Top Posters
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
thanks
for BQWS, I am using the current project for calculating earned and planned value
regards
MORPH
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.