+ Reply to Thread
Results 1 to 4 of 4

EVMS Template

  1. #1
    Registered User
    Join Date
    02-17-2022
    Location
    Toronto, Canada
    MS-Off Ver
    365
    Posts
    11

    EVMS Template

    Hello All

    I need help. I'm at the ***** and afraid level confused here.

    I need to build out an EVMS template that is a clean and functioning document. I have a few ideas as to what I want to do with it and its as follows:

    1. Auto-create or auto-populate cells. Say for example in one worksheet I want to add tasks it will auto-populate and adjust accordingly to added tasks.
    2. Can I create dynamic work charts as you can see in the work breakdown and organization breakdown charts. How would you organize it to be dynamic and constantly changing with inputs.
    3. Any other suggestions and tips to get the best document available.

    I understand its currently just a mish mash of tabs but I really need assistance. Thanks for any you give me!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: EVMS Template

    I will take a look at this because this is my area of expertise but it's going to take a little time. You are asking for a lot here.

    1. Auto-create or auto-populate cells. Say for example in one worksheet I want to add tasks it will auto-populate and adjust accordingly to added tasks.
    You are going to need to be much more specific here. Where do you want to add tasks, and what do you want auto-populated?

    2. Can I create dynamic work charts as you can see in the work breakdown and organization breakdown charts. How would you organize it to be dynamic and constantly changing with inputs.
    Are you saying that you want to automatically update graphical diagrams based on some data inputs? I wouldn't say it's impossible, but that is an enormous effort in Excel and I would go so far as to say it's prohibitive. It's like developing a whole application.

    Honestly, you are trying to do something by cobbling it together in Excel when there are professional applications out there to do specifically this, such as Microsoft Project, Primavera, and Deltek.

    Also I see nothing in here that tries to implement EVMS, only record raw inputs such as task data. There is no reporting.

    Also in Budget, column K, your calculation of % complete is not correct. You cannot take an average of several percentages to get an overall percentage, unless each percentage has equal weight. That is, suppose you have an activity with two subtasks. If Joe is 10% done with a subtask that is 100 hours, and Frances is 90% done with a subtask that is 5 hours, your task is not 50% done.

    You seem to be using % complete as the method to earn value for every task. However, this is rarely a realistic way to measure completion as it almost always involves subjective judgement by the person who is doing the task, and that person is almost always going to overestimate completion. Methods for earning value are:

    • Milestones
    • Percent complete
    • 50/50
    • 0/100
    • Equivalent Units
    • Apportioned effort


    A method that gives credit only when some atomic task can be objectively judged as complete is the closest to reality. For example, let's the say the task is that a piece of software must be tested. If you ask the tester for a % complete they might count test cases executed, but it's more reliable to carry it as 0% until all test cases are complete then go to 100%. This is because the tester may not have an objective way to measure how much work was done and how much remains. Even if they count test cases, different test cases require a different amount of effort. Also encountering bugs in the code will slow down testing, which cannot be predicted before running the tests.

    I have managed projects for contracts for the U.S. federal government that use EVMS over the last 35 years. You are biting off an awful lot to chew here.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-17-2022
    Location
    Toronto, Canada
    MS-Off Ver
    365
    Posts
    11

    Re: EVMS Template

    Hi Jeff
    You are writing alot and I REALLY appreciate all of this. I'm trying to digest all of what you've written.
    I also sent a DM and would love to chat more.

  4. #4
    Registered User
    Join Date
    02-17-2022
    Location
    Toronto, Canada
    MS-Off Ver
    365
    Posts
    11

    Re: EVMS Template

    Quote Originally Posted by 6StringJazzer View Post
    I will take a look at this because this is my area of expertise but it's going to take a little time. You are asking for a lot here.


    You are going to need to be much more specific here. Where do you want to add tasks, and what do you want auto-populated?


    Are you saying that you want to automatically update graphical diagrams based on some data inputs? I wouldn't say it's impossible, but that is an enormous effort in Excel and I would go so far as to say it's prohibitive. It's like developing a whole application.

    Honestly, you are trying to do something by cobbling it together in Excel when there are professional applications out there to do specifically this, such as Microsoft Project, Primavera, and Deltek.

    Also I see nothing in here that tries to implement EVMS, only record raw inputs such as task data. There is no reporting.

    Also in Budget, column K, your calculation of % complete is not correct. You cannot take an average of several percentages to get an overall percentage, unless each percentage has equal weight. That is, suppose you have an activity with two subtasks. If Joe is 10% done with a subtask that is 100 hours, and Frances is 90% done with a subtask that is 5 hours, your task is not 50% done.

    You seem to be using % complete as the method to earn value for every task. However, this is rarely a realistic way to measure completion as it almost always involves subjective judgement by the person who is doing the task, and that person is almost always going to overestimate completion. Methods for earning value are:

    • Milestones
    • Percent complete
    • 50/50
    • 0/100
    • Equivalent Units
    • Apportioned effort


    A method that gives credit only when some atomic task can be objectively judged as complete is the closest to reality. For example, let's the say the task is that a piece of software must be tested. If you ask the tester for a % complete they might count test cases executed, but it's more reliable to carry it as 0% until all test cases are complete then go to 100%. This is because the tester may not have an objective way to measure how much work was done and how much remains. Even if they count test cases, different test cases require a different amount of effort. Also encountering bugs in the code will slow down testing, which cannot be predicted before running the tests.

    I have managed projects for contracts for the U.S. federal government that use EVMS over the last 35 years. You are biting off an awful lot to chew here.
    Hi Jeff...I'm trying to DM you but nothing seems to be going through.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 06-23-2020, 11:18 AM
  2. [SOLVED] Copy 4 sheets from template and dynamically name, Save template and leave workin file open
    By Webbers in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2019, 02:39 PM
  3. Replies: 1
    Last Post: 06-26-2019, 02:47 AM
  4. Replies: 0
    Last Post: 06-25-2019, 12:04 PM
  5. Template for query that can span multiple pages or sheets of a template if needed
    By anthallen_dps in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2013, 11:52 AM
  6. Replies: 3
    Last Post: 05-15-2013, 11:34 PM
  7. Replies: 3
    Last Post: 10-13-2010, 04:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1