Enabling Performance for Businesses through Software


About Us

Contact Us

Our Values


Tools & Templates



Feedback & Sign Up

Customer Support

© Copyright owned by Connoizor Software Pvt Ltd

Book for Microsoft Project & EVM Reporting Tool for Projects



Schedule and cost management is the most essential part of project lifecycle management. Many projects fail as a result of not managing these critical components effectively. Every project manager irrespective of the domain he or she is working in will need to manage schedule and cost as part of their duties.


The most commonly used tool for schedule management is Microsoft® Office Project, a project management software program developed and sold by Microsoft which is designed to assist project managers in developing schedules, assigning resources to tasks, tracking progress, managing budgets and analyzing workloads.


The most common technique used for cost management is earned value management (EVM), a project management technique used for measuring project progress in an objective manner that combines measurements of project scope performance, schedule performance, and cost performance within a single integrated methodology. Earned value management is becoming the standard across the world for this purpose in both the private and public sector and many organizations are now adopting this technique to manage their projects. In the public sector, earned value management is mandated for all the government projects in the United States and many other countries are following the suit. Despite this growing trend, Earned Value Project Management and the Practice Standard for Earned Value Management both published by the Project Management InstituteÒ, are among the few quality books available on this important technique.


Earned Value Management Using MicrosoftÒ Office Project is the first reference to effectively combine the most widely used scheduling tool with the most widely accepted cost management technique. It is a practical guide to a end to end schedule and cost management using Microsoft ÒOffice Project with a limited version and license of a unique EVM software tool that will help practitioners more effectively manage their projects, track and report status and progress of projects using the earned value management technique and take necessary action before their project fail beyond repair.  This manual is an excellent complement to whatever Microsoft® Office Project guide that you may be using and a significant addition to the literature on how to use EVM.


Key Features


·    Covers the knowledge areas of schedule management and cost management in depth and it is aligned with the Practice Standard for Earned Value Management published by Project Management InstituteÒ

·    Provides a practical step by step approach to building a schedule and managing it throughout the lifecycle of the project and how to setup the schedule in such a way so as to enable effective cost management through EVM technique and how to use the EVM tool provided with the manual to manage current and future projects

·    Includes valuable tips and practical illustrations of every step in the process

·    Demonstrates how EVM can be effectively applied to any size project or program with the same rigor as that of a large and critical project 

·    WAV offers free downloads of all the tables along with the calculations of the different parameters of the EVM technique, the sample project schedule used in the book, Limited and licensed version EVM Software — available from the Web Added Value™ Download Resource Center at


About Author


Sham Dayal, V.D., is a Certified Project Management Professional (PMP) from November 2004, Post Graduate in Applied Statistics and a Graduate in Computer Science, with over 12 years of practical experience in the IT industry.  Sham currently is a Group Manager with Mphasis, an EDS company. Sham was the first person at Mphasis to successfully implement EVM for project tracking (progress, status & forecasting) and he was instrumental in creating a new and unique technique for tracking the progress of production support projects. This new technique based on the EVM concept won a Quality Knowledge Excellence Award.  Sham has spoken and written articles on EVM pertaining to more effective project life cycle management which were recognized and published in leading journals. He is an active member of the Project Management Institute, and the Bangalore PMI Chapter.  Sham has been managing projects with EVM and Microsoft® Project using some innovative techniques for quite some time with significantly improved results.  He decided to write this book to help other project management practitioners achieve similar results.



List Price :

Price US $79.95


USA Customers

International Customers

Table of Contents:


Chapter 1: Introduction
    General Problems Faced in Projects
    Solution to Be Implemented
    EVM Reporting Tool

Chapter 2: Schedule Management
    Basic Elements of a Schedule
    Work Breakdown Structure (WBS)
    Resource Costs
    Task Dependencies

Chapter 3: What is Earned Value Management?
    EVM Introduction
    Basic Elements of EVM
    Planned Value (PV)
    Earned Value (EV)
    Actual Cost (AC)
    Planned Time (PT)
    Elapsed Time (ET)
    Calculation of the EV Performance Measures
    Schedule Variance (SV)
    Schedule Variance % (SV %)
    Schedule Performance Indicator (SPI)
    To-complete Schedule Performance Indicator -TSPI
    Schedule Variance (Time)
    Schedule Variance % (Time)
    Schedule Performance Indicator (Time)
    To-complete Schedule Performance Indicator (Time)
    Cost/Effort Variance (CV)
    Cost Variance % (CV%)
    Cost Performance Indicator (CPI)
    To-complete Cost Performance Indicator - TCPI
    Budget At Completion (BAC)
    Budget At Completion Time (BACt)
    Estimate To Complete (ETC)
    Estimate At Completion (EAC)
    Estimate At Completion Time (EACt)
    Variance At Completion (VAC)
    Variance At Completion Time (VACt)

Chapter 4: Why EVM?
    EVM Performance Measures De-mystified
    Benefits Explored
    Monitoring the Project as it Progresses
    Schedule/Cost Performance at a Glance
    Dealing with Numbers Versus Dates
    Quantify & Track Delays Caused by External Factors
    Embrace Changes in the Project
    Project Monitoring Made Simple
    Projects On-Time & Under Budget
    Improved Customer Satisfaction
    Forecast Cost/Efforts and Time Required
    Forecast Future Efficiency Needed
    Managing Trends
    Total Control of the Project

Chapter 5: Creating your Schedule
    Preparing Your Schedule
    Microsoft Project Setup
    MS Project Options
    Calendar Options
    Project Setup Information
    Project Setup Calendar
    Creating the Work Breakdown Structure (WBS)
    Assigning the Estimates
    Creating Resources
    Resource Calendar Setup
    Assigning Resources
    Sequencing Last Level Tasks
    Assigning Priority to Summary Tasks
    Creating Recurring Tasks
    Resource Leveling
    Baseline Schedule

Chapter 6: EVM Report Template Setup
    Preparing Your EVM Report Template for First Use
    EVM Template Project Options
    Configuration Options
    Populate Reporting Periods

Chapter 7: Tracking Progress on the Schedule
    Tracking Progress in MPP
    Summary Level Tracking
    Task Level Day Wise Tracking
    Resource Level Day Wise Tracking
    Adjusting Schedule while Tracking
    Tracking Progress in the EVM Tool

Chapter 8: Monitoring the Schedule
    Checking and Updating the Summary Sheet
    Checking the Earned Value Graph
    Checking the Forecast ($) Graph
    Checking the Forecast (Time) Graph
    Checking the Forecast (Index) Graph
    Checking the Variances ($) Graph
    Checking the Variances (Time) Graph
    Checking the Indices Graph
    Checking the Other Indices Graph

Chapter 9: Additional Schedule Management Techniques
    Drilling Down to Check Tasks at Risk
    Re-sequencing Tasks in Your Schedule
    Putting Your Schedule on Hold
    Entire Schedule on Hold
    Selective Resources on Hold
    Updating Resource Leave/Vacation
    Checking for Scope Creep
    When to Re-baseline the Schedule?
    Re-baseline your Schedule
    Re-baseline your EVM Report Template

Appendix A
Appendix B
Quick Reference & Glossary

Shipping: US Shipping generally takes around 4-5 days and International shipping generally takes around 2-4 weeks. All Shipping is done through United States Postal Service (USPS).


Returns: All Returns should be done within 14 days of payment. Returns should be sent to the below mentioned address. The book should be in a “re-saleable as new” condition for the refund to be processed. Once the book is received in good condition, the refund will be processed within 72 hours. Returns shipping costs need to be borne by the customer.


Shipment address for Returns:


Connoizor Software Pvt Ltd.

#397, 25th B Main, 22nd Cross,

HSR Layout, Sector 2,




Please contact us on the following Email Address should you have any queries or concerns.

sales at

Our Price :

Price US $72.00 + Shipping & Handling


Earned Value Management Using Microsoft® Office Project
A Guide for Managing Any Size Project Effectively

By Sham Dayal, PMP

Softcover, 7.5 x 9.25, 248 Pages
ISBN: 978-1-932159-98-1

September 2008
Includes a CD-ROM with the EVM Reporting Tool