98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Office general help » Earned Value
Earned Value
Resolved · Low Priority · Version 2007
Carl has attended:
Excel Advanced course
Project Management - Framework & Processes course
Excel VBA Introduction course
Excel VBA Intermediate course
Earned Value
Would be interested to hear more on Earned Value calculations.
RE: Earned Value
Hi Carl
Thank you for your question.
We have a blog dedicated to project training which you can find at
https://www.stl-training.co.uk/b/category/project-training/
which has an article on this subject:
https://www.stl-training.co.uk/b/how-to-effectively-monitor-your-project-by-learning-earned-value-equations/
We saw on the training that a useful place to start with Earned Value is to work with some simple numbers from your Project. For example:
Budgeted Cost of Work Scheduled (BCWS) - what we agreed we'd spend to complete the project
Budgeted Cost of Work Performed (BCWP) - what we agreed we'd pay for the work that's been completed
Actual Cost of Work Performed (ACWP) - what we really paid for the work completed.
With these figures we can do some simple analysis. For example Performance Indices can be calculated:
BCWP/ACWP = CPI or Cost Performance Index. If it's less than 1 the project is over spending
BCWP/BCWS = SPI or Schedule Performance Index. This time a result less than 1 means the project is behind schedule
The following related Microsoft article may also be of interest:
http://office.microsoft.com/en-us/project-help/analyze-project-performance-with-earned-value-analysis-HA101819808.aspx
And one more link for you: https://www.stl-training.co.uk/post-29374-ev.html #ixzz2TAKTrweW
I hope this helps.
Kind regards,
Andrew
Mon 20 May 2013: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Microsoft Office tip:Prevent macros from running when you start ApplicationsMacros are automated programs that can help you speed up your work. They can be embedded in caommands like AutoExec which will make them run as soon as an application like MS Word or MS Access are launched. |