Results 1 to 2 of 2

Thread: Difference in Value in the Program Plan sheet and Actuals Sheet!

  1. #1

    Difference in Value in the Program Plan sheet and Actuals Sheet!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Guys,
    I am confused in doing this and this is little complicated for me also.
    I have already done a Program Plan sheet.In this sheet we enter the plan the project in sprints (each weeks is called as a sprint-June 3rd is the first sprint week followed by June 10 and so on.)

    In each sprints there are different phases of the project (say Phase "Dev" under June 3rd) For Phase "Dev" the resources are

    BA-0.25
    GD-0
    TL-0.25
    Dev-1
    PM-0.2
    QA-0.25

    Its for Dev phase.

    Suppose there is another phase for the same sprint.Then the resource value changes...i.e it increases.

    Now there is another sheet called the Staffing Plan.
    In Staffing Plan the actuals are entered.In the former sheet the forecasted values are entered.

    In staffing plan the actual emp id and employee name are entered and their role is given.(say : emp name "a" and Role is Dev).

    My requirement is

    When the staffing plan role exceeds the role in the program plan then there should be given a warning to the user and the extra value should be added as a buffer value.(i.e. column F in staffing plan sheet)
    the buffer values have to added seperately and actuals should be entered seperately in the Staffin Plan sheet.
    So that i can find the difference from the Program Plan sheet and Staffing Sheet.

    My aim is to find the difference between the actual values and the predicted values.
    Program Plan sheet-Predicted values.
    Staffing Plan sheet-Actual values.

    This verification has to done and carried out for each sprints.

    Can anyone help me on this.
    Thanks a lot for reading this...please help on this too.
    Regards,
    Devpp

    Attached Files Attached Files

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    test.xlsm

    Your question is a bit hard to interpet, but I think I've done what you want

Posting Permissions

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