Software

Ask something
Discussion Locked

MS Project macros...

0 helpful
2 replies

by srini_devi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

I am looking for genrating metrics from the MS Project Database.. I need to know shcedule variance, effort variance from the MS Project Database and plot them as graphs in MS Excel..

Could anyone guide me in the right direction? Thanks

2 replies

by kees.valkenswaard

I am not sure what you are aiming at. I suppose you are looking for fields like Cost Variance, Duration Variance, Finish Variance, Work Variance?
Save your project as an Excel file. [File, Save As, Save as type: Excel Workbook].
In Export Mapping make a New Map, with the fields you need.
In Excel, it may be necessary to use a few formulas to strip off the text. I usually look for the space to determine how many characters [-1] I need in the Left function.
I assume you know how to make a graph from numeric data?
Good luck.

by kees.valkenswaard

Your answer is now up for nearly two months. Are you going to accept it or providing additional comment? Why do we answer questions?

If you would like to mail me at kees.valkenswaard@planet.nl do not forget to put Q&A as part of the subject line.Else the message would be deleted.

This discussion is closed to new replies.