Entrar
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
MS Project 2010 - planned graph instead of linear graph

Answered MS Project 2010 - planned graph instead of linear graph

  • terça-feira, 28 de fevereiro de 2012 10:14
     
     
    Entrar para Votar
    0

    I am using MS Project 2010. I track project progress by plotting actual % completion vs expected % completion.

    I currently use a linear "expected % completion" by taking the start and finish dates of the project and dividing by the number of weeks.

    I would like to use the planned data instead of linear data.

    How do I do it?

     

Todas as Respostas

  • terça-feira, 28 de fevereiro de 2012 14:36
    Moderador
     
     
    Entrar para Votar
    0

    Hello HFprojects,

    I'm not sure I follow exactly how you are calculating expected % completion but typically this sort of question is handled through earned value calculations.  Built into Project 2010 are visual reports including the "Earned Value Over Time" report.  Have you looked at that report?

    Please be aware that in order to calculate Earned Value you need the following:

    1. Resources with standard cost rates assigned to tasks.
    2. Baseline data saved
    3. Tracking data
    4. Status date

    Do you have this data?

    Julie

    • Marcado como Resposta Mike GlenModerator sexta-feira, 27 de abril de 2012 19:49
    • Não Marcado como Resposta HFprojects terça-feira, 22 de maio de 2012 12:11
    •  
     
  • segunda-feira, 21 de maio de 2012 10:55
     
     
    Entrar para Votar
    0

    Hi

    Sorry that I didn't answer this before.

    My projects don't work with costs and, at the moment, we don't baseline.

    Instead I use the % complete field in MS Project to show me the status of the project. I'll tell you what I have done to show the 'planned data'.

    I use the resource useage view with a timescale of weeks and months. I copy and paste all the hours into MS Excel.

    Once it is in Excel and do a total of all the hours per week and a grand total at the end. I then insert another row which shows the % complete of each week (cummulative) of the grand total.

    I then plot actual progress agains the planned.

     
  • segunda-feira, 21 de maio de 2012 17:50
    Moderador
     
     
    Entrar para Votar
    0

    Hi,

    The result of your calculation in Excel seems to be wht Project calls % Wprk Complete. Try that!

    Greetings,

     
  • terça-feira, 22 de maio de 2012 12:10
     
     
    Entrar para Votar
    0

    Hi

    I want to draw a graph showing actual (in red) versus target (in blue) as shown in the picture. My challenge is how to do the target line? In other words, how do I know what the expected (i.e. target) % completion should be? Actual % complete is easy to find as I can take it every week from my MS Project file. The target, however, gets set at the start of the project.

    This is what I was trying to describe in my reply above.

    Hessel

     
  • terça-feira, 22 de maio de 2012 12:24
    Moderador
     
     
    Entrar para Votar
    0

    Hello,

    The "target" would be saved when you save a baseline.  As you have said in an earlier reply that you don't baseline -- this information is unavailable to you.

    The baseline is saved after you have the initial plan and without it, you have no method of showing the initial plan.

    Julie

     
  • terça-feira, 22 de maio de 2012 12:58
     
     
    Entrar para Votar
    0

    Julie

    You are 100% correct that I don't have the info if I don't save a baseline. That is why I do my copy and paste into MS Excel to calculate the target.

    If I save a baseline would I be able to find the target % complete for each week from the start until the end of the project? If yes, where would I find it please?

    Hessel

     
  • terça-feira, 22 de maio de 2012 13:12
    Moderador
     
     Respondido
    Entrar para Votar
    0

    Hello Hessel,

    Yes, what you are referring to is Earned Value calculation.  There are visual reports which create pivot tables and charts in Excel available if you have the correct data saved.

    See:

    http://office.microsoft.com/en-us/project-help/about-earned-value-analysis-HP001034258.aspx

    for a primer on earned value analysis in MS Project.

    See:

    http://office.microsoft.com/en-us/project-help/create-a-visual-report-of-project-data-in-excel-or-visio-HA101811060.aspx

    for information on visual reports in Project.

    Julie

     
  • quarta-feira, 18 de julho de 2012 05:19
     
     
    Entrar para Votar
    0

    Julie

    Thanks for the input.

    I don't baseline my projects (yet) so I have to rely on what is in the project plan at the start to show the weekly planned % completion. Each week I update the actual % complete and I plot my progress as per the above graph.

    We can close this discussion.

    Hessel