Earned Value Management Template for Projects

Product Description:

Project Managers across the world face huge problems in managing projects. They are often faced with challenges of projects incurring a Cost Overrun and a Schedule Overrun apart from other project management challenges. Most often than not they realize this only after the project has reached the end or has been terminated due to these reasons. Though both the client and the vendor are party to this, Project managers often do have objective evidence to this. All the project managers are spending huge amounts of time and energy in preparing, updating and showing status of the project at any point in time. There are tasks going on hold many times before it is completed due to the dependencies with the client. But we as project managers did not have a good mechanism to account for these delays and report the actual schedule or cost overruns.

Earned value Management technique coupled with good planning and effective use of the Microsoft Project will eliminate the problem faced and we will be able to report the actual schedule and cost parameters at any given point in time with ease. As part of this effort we have created a Dashboard which would enable any project manager to apply the earned value management technique in managing projects.

Check out more details of our Product on our website

http://www.connoizor.com/index_files/EVMProjectsPMHUB.htm

Product Screen Shot:

Frequently Asked Questions

Does this EVM Template take care of the Earned Value Calculations?

Yes the EVM Template is designed to take care of all the calculations. The only input needed for this template on a periodical basis is the EV, AC & % Complete.

Does this EVM Template provide options for setup of different periods?

Yes the EVM Template is designed to provide three different types of periods. Weekly, Fortnightly, Monthly & Bi-Monthly. Depending on your project requirements you can setup the tool for any type of period. This is a one time setup.

Does this EVM Template automatically calculate the number of reporting periods?

Yes the EVM Template is designed to calculate the number of reporting periods automatically based on the inputs of the Project Start and End Dates and the reporting frequency (periods).

Does this E

Earned Value Management Template for Projects

Product Description:

Project Managers across the world face huge problems in managing projects. They are often faced with challenges of projects incurring a Cost Overrun and a Schedule Overrun apart from other project management challenges. Most often than not they realize this only after the project has reached the end or has been terminated due to these reasons. Though both the client and the vendor are party to this, Project managers often do have objective evidence to this. All the project managers are spending huge amounts of time and energy in preparing, updating and showing status of the project at any point in time. There are tasks going on hold many times before it is completed due to the dependencies with the client. But we as project managers did not have a good mechanism to account for these delays and report the actual schedule or cost overruns.

Earned value Management technique coupled with good planning and effective use of the Microsoft Project will eliminate the problem faced and we will be able to report the actual schedule and cost parameters at any given point in time with ease. As part of this effort we have created a Dashboard which would enable any project manager to apply the earned value management technique in managing projects.

Check out more details of our Product on our website

http://www.connoizor.com/index_files/EVMProjectsPMHUB.htm

Product Screen Shot:

Earned Value Management Template for Projects

Product Description:

Project Managers across the world face huge problems in managing projects. They are often faced with challenges of projects incurring a Cost Overrun and a Schedule Overrun apart from other project management challenges. Most often than not they realize this only after the project has reached the end or has been terminated due to these reasons. Though both the client and the vendor are party to this, Project managers often do have objective evidence to this. All the project managers are spending huge amounts of time and energy in preparing, updating and showing status of the project at any point in time. There are tasks going on hold many times before it is completed due to the dependencies with the client. But we as project managers did not have a good mechanism to account for these delays and report the actual schedule or cost overruns.

Earned value Management technique coupled with good planning and effective use of the Microsoft Project will eliminate the problem faced and we will be able to report the actual schedule and cost parameters at any given point in time with ease. As part of this effort we have created a Dashboard which would enable any project manager to apply the earned value management technique in managing projects.

Check out more details of our Product on our website

http://www.connoizor.com/index_files/EVMProjectsPMHUB.htm

Product Screen Shot:

Frequently Asked Questions

Does this EVM Template take care of the Earned Value Calculations?

Yes the EVM Template is designed to take care of all the calculations. The only input needed for this template on a periodical basis is the EV, AC & % Complete.

Does this EVM Template provide options for setup of different periods?

Yes the EVM Template is designed to provide three different types of periods. Weekly, Fortnightly, Monthly & Bi-Monthly. Depending on your project requirements you can setup the tool for any type of period. This is a one time setup.

Does this EVM Template automatically calculate the number of reporting periods?

Yes the EVM Template is designed to calculate the number of reporting periods automatically based on the inputs of the Project Start and End Dates and the reporting frequency (periods).

Does this EVM Template show a snapshot of a reporting period?

Yes this EVM Template shows a snapshot on any reporting period giving the details of that period and allowing the user to enter the Performance Measure Outcome and provide reasons and corrective actions. This periodical snapshot can be stored as a history for future use of the data or for creating the lessons learnt at the end of the project.

Does this EVM Template allow the user to store data on some other indices which is not part of EVM?

Yes the EVM Template is designed to allow the users to store and report data on other indices like the Customer Satisfaction Index, Risk Index, Project Health Index, etc. Totally three indices are allowed to be captured, stored and reported through this template.

Is this EVM Template designed as per the PMBOK Third Edition EVM Guidelines ?

Yes this EVM Template is as per the PMBOK Third Edition EVM Guidelines and it is as per the PMI’s Practice Standard for EVM.

Does this EVM Template allow the users to track Labor Hours instead of Cost?

Yes this EVM Template has an option for Labor Hours Tracking or Cost Tracking. You would need to specify the option needed at the time of purchasing the template by sending us a mail at contact@connoizor.com.

Is this template fully automatic or is there any manual intervention needed?

This template is fully automatic once it is setup. There is a one time setup needed which is also very easy to do and does not require any great skills. Any person with a little bit of computer knowledge can set it up.

Does this EVM Template have color coding for performance measures?

Yes this EVM Template has color coding embedded in it for performance measures. The color coding ranges are as follows Green for 0, Yellow for 0—10, Red for >10. It can however be customized on request.

When I open this template it asks me whether to Enable/Disable Macros. What should I do?

This template uses Macros and so you would need to Enable Macros to be able to use this template.

Nothing works in the EVM Template. What do I do?

This template uses Macros and so you would need to Enable Macros to be able to use this template. Please go to the Tools —> Macros —> Security and choose the Macro Security level to Medium or Low.

I get a error “?NAME” in one of the fields. What do I do?

This template uses Excel Add-ins and so you would need to install Add-ins to be able to use this template. Please go to the Tools —> Add-ins... and select the first two Add-ins “Analysis Toolpak” and “Analysis Toolpak—VBA” and install them.

I get a error “#NA” in most of the fields in the Summary Sheet. What do I do?

“#NA” indicates that the requested value is not available. Please enter the correct status date which is available as a reporting period in the EVM data Sheet and click on Update Status Date button to view the right data.

I get a Automation error. What do I do?

This product uses the internet for some of the actions. Please ensure that you are connected to the internet and try the same action once again.

Frequently Asked Questions

Does this EVM Template take care of the Earned Value Calculations?

Yes the EVM Template is designed to take care of all the calculations. The only input needed for this template on a periodical basis is the EV, AC & % Complete.

Does this EVM Template provide options for setup of different periods?

Yes the EVM Template is designed to provide three different types of periods. Weekly, Fortnightly, Monthly & Bi-Monthly. Depending on your project requirements you can setup the tool for any type of period. This is a one time setup.

Does this EVM Template automatically calculate the number of reporting periods?

Yes the EVM Template is designed to calculate the number of reporting periods automatically based on the inputs of the Project Start and End Dates and the reporting frequency (periods).

Does this EVM Template show a snapshot of a reporting period?

Yes this EVM Template shows a snapshot on any reporting period giving the details of that period and allowing the user to enter the Performance Measure Outcome and provide reasons and corrective actions. This periodical snapshot can be stored as a history for future use of the data or for creating the lessons learnt at the end of the project.

Does this EVM Template allow the user to store data on some other indices which is not part of EVM?

Yes the EVM Template is designed to allow the users to store and report data on other indices like the Customer Satisfaction Index, Risk Index, Project Health Index, etc. Totally three indices are allowed to be captured, stored and reported through this template.

Is this EVM Template designed as per the PMBOK Third Edition EVM Guidelines ?

Yes this EVM Template is as per the PMBOK Third Edition EVM Guidelines and it is as per the PMI’s Practice Standard for EVM.

Does this EVM Template allow the users to track Labor Hours instead of Cost?

Yes this EVM Template has an option for Labor Hours Tracking or Cost Tracking. You would need to specify the option needed at the time of purchasing the template by sending us a mail at contact@connoizor.com.

Is this template fully automatic or is there any manual intervention needed?

This template is fully automatic once it is setup. There is a one time setup needed which is also very easy to do and does not require any great skills. Any person with a little bit of computer knowledge can set it up.

Does this EVM Template have color coding for performance measures?

Yes this EVM Template has color coding embedded in it for performance measures. The color coding ranges are as follows Green for 0, Yellow for 0—10, Red for >10. It can however be customized on request.

When I open this template it asks me whether to Enable/Disable Macros. What should I do?

This template uses Macros and so you would need to Enable Macros to be able to use this template.

Nothing works in the EVM Template. What do I do?

This template uses Macros and so you would need to Enable Macros to be able to use this template. Please go to the Tools —> Macros —> Security and choose the Macro Security level to Medium or Low.

I get a error “?NAME” in one of the fields. What do I do?

This template uses Excel Add-ins and so you would need to install Add-ins to be able to use this template. Please go to the Tools —> Add-ins... and select the first two Add-ins “Analysis Toolpak” and “Analysis Toolpak—VBA” and install them.

I get a error “#NA” in most of the fields in the Summary Sheet. What do I do?

“#NA” indicates that the requested value is not available. Please enter the correct status date which is available as a reporting period in the EVM data Sheet and click on Update Status Date button to view the right data.

I get a Automation error. What do I do?

This product uses the internet for some of the actions. Please ensure that you are connected to the internet and try the same action once again.

VM Template show a snapshot of a reporting period?

Yes this EVM Template shows a snapshot on any reporting period giving the details of that period and allowing the user to enter the Performance Measure Outcome and provide reasons and corrective actions. This periodical snapshot can be stored as a history for future use of the data or for creating the lessons learnt at the end of the project.

Does this EVM Template allow the user to store data on some other indices which is not part of EVM?

Yes the EVM Template is designed to allow the users to store and report data on other indices like the Customer Satisfaction Index, Risk Index, Project Health Index, etc. Totally three indices are allowed to be captured, stored and reported through this template.

Is this EVM Template designed as per the PMBOK Third Edition EVM Guidelines ?

Yes this EVM Template is as per the PMBOK Third Edition EVM Guidelines and it is as per the PMI’s Practice Standard for EVM.

Does this EVM Template allow the users to track Labor Hours instead of Cost?

Yes this EVM Template has an option for Labor Hours Tracking or Cost Tracking. You would need to specify the option needed at the time of purchasing the template by sending us a mail at contact@connoizor.com.

Is this template fully automatic or is there any manual intervention needed?

This template is fully automatic once it is setup. There is a one time setup needed which is also very easy to do and does not require any great skills. Any person with a little bit of computer knowledge can set it up.

Does this EVM Template have color coding for performance measures?

Yes this EVM Template has color coding embedded in it for performance measures. The color coding ranges are as follows Green for 0, Yellow for 0—10, Red for >10. It can however be customized on request.

When I open this template it asks me whether to Enable/Disable Macros. What should I do?

This template uses Macros and so you would need to Enable Macros to be able to use this template.

Nothing works in the EVM Template. What do I do?

This template uses Macros and so you would need to Enable Macros to be able to use this template. Please go to the Tools —> Macros —> Security and choose the Macro Security level to Medium or Low.

I get a error “?NAME” in one of the fields. What do I do?

This template uses Excel Add-ins and so you would need to install Add-ins to be able to use this template. Please go to the Tools —> Add-ins... and select the first two Add-ins “Analysis Toolpak” and “Analysis Toolpak—VBA” and install them.

I get a error “#NA” in most of the fields in the Summary Sheet. What do I do?

“#NA” indicates that the requested value is not available. Please enter the correct status date which is available as a reporting period in the EVM data Sheet and click on Update Status Date button to view the right data.

I get a Automation error. What do I do?

This product uses the internet for some of the actions. Please ensure that you are connected to the internet and try the same action once again.