Scribd Logo
Upload

Welcome to Scribd!

  • 63 views

    Instruction Manual: 1. Set Up The Schedule Table

    Uploaded by

    Radoslav Robert
    The instruction manual provides guidance on how to set up and use a project schedule table. It instructs the user to enter workstreams, tasks, and activities in columns with start dates in cell D4 to set the timeline. For each item, the user can enter the planned start date, end date, and critical deadline, and the system will automatically draw a gray line from start to end. Additional information like responsibilities can also be added. The status of each item will update automatically based on whether it is on schedule, started, finished, or past deadline.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Instruction Manual: 1. Set Up The Schedule Table

    Uploaded by

    Radoslav Robert
    63 views3 pages
    The instruction manual provides guidance on how to set up and use a project schedule table. It instructs the user to enter workstreams, tasks, and activities in columns with start dates in cell D4 to set the timeline. For each item, the user can enter the planned start date, end date, and critical deadline, and the system will automatically draw a gray line from start to end. Additional information like responsibilities can also be added. The status of each item will update automatically based on whether it is on schedule, started, finished, or past deadline.

    Original Description:

    Consulting

    Original Title

    Project Scheduling

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The instruction manual provides guidance on how to set up and use a project schedule table. It instructs the user to enter workstreams, tasks, and activities in columns with start dates in cell D4 to set the timeline. For each item, the user can enter the planned start date, end date, and critical deadline, and the system will automatically draw a gray line from start to end. Additional information like responsibilities can also be added. The status of each item will update automatically based on whether it is on schedule, started, finished, or past deadline.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    63 views3 pages

    Instruction Manual: 1. Set Up The Schedule Table

    Uploaded by

    Radoslav Robert
    The instruction manual provides guidance on how to set up and use a project schedule table. It instructs the user to enter workstreams, tasks, and activities in columns with start dates in cell D4 to set the timeline. For each item, the user can enter the planned start date, end date, and critical deadline, and the system will automatically draw a gray line from start to end. Additional information like responsibilities can also be added. The status of each item will update automatically based on whether it is on schedule, started, finished, or past deadline.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 3

    Instruction manual

    1. Set up the schedule table


    Enter workstreams, tasks and activities with a index in columns B and C
    Adjust the time line by entering the start date of the schedule in cell D4. Then adjust the the months in row 8

    2. Define the time schedule for each workstream, task and activity
    You can enter three dates per item: the planned start date, the planned end date and the critical deadline
    A grey line is automatically drawn from the start to the end date
    Usually each item is marked with "Not Started" in column E in the beginning

    3. Addition information
    You may enter additional information, e.g. responsibilities or interdependencies

    4. Status
    As long as the start date of an item is in the future and the activity is marked with "Not Started" the Status is white
    If the acitivity is started and the item is in time (<end date) the status is green
    If the acitivity is finished the status is always green
    The status turns red if the item is not in time (end date is passed and acitivity is not started or started) or the activity
    e months in row 8

    critical deadline

    rted" the Status is white

    d or started) or the activity is not started and the start date is passed
    371586087.xlsSchedule 3

    [PROJECT NAME]

    Project start date (Please enter Monday of first week) 6/1/2007

    Project plan

    Status June 2007 July 2007 August 2007


    Responsible Necessary Pre- Dura-
    [F=Finished, End Deadline
    Project task / activity department / preliminary requisite for Start date tion
    NS= Not started, date (Date)
    person activity activity (days)
    S=Started] 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
    Timeline 14/11/17 ### ######### ######### ######### ######### ###### ######### ######### ######### ######### ###### ######### ######### ######### ######### ###### ######### ######### ######### ######### ###### ######### ######### ######### ######### ###### ######### ######### ######### ######### ###### ######### ######### ###

    Milestones

    A Workstream A S 6/25/2007 64 8/28/2007 8/31/2007

    A1 Task A1 S 6/25/2007 37 8/1/2007 8/31/2007

    A2 Task A2 S 7/1/2007 45 8/15/2007 8/31/2007

    A2.1 Activity A2.1 S 7/1/2007 45 8/15/2007 8/23/2007

    A2.2 Activity A2.2 S 7/7/2007 32 8/8/2007 8/31/2007

    A3 Task A3 S 7/10/2007 49 8/28/2007 8/31/2007

    A3.1 Activity A3.1 S 7/10/2007 36 8/15/2007 8/23/2007

    A3.2 Activity A3.2 S 7/14/2007 109 10/31/2007 10/31/2007

    11/14/2017 3

    You might also like