Scribd Logo
Upload

Welcome to Scribd!

  • 82 views

    Gantt Chart Template For Google Sheets

    Uploaded by

    Ramdhan Mazid Abdullah
    This document contains a Gantt chart template that can be used to plan and track projects over time. The template includes columns for task name, start date, end date, duration, team member, and a chart to visualize the timeline. An example is provided with 4 sample projects that are broken down into specific tasks assigned to team members along with start and end dates. The template also includes a progress bar chart to track percent completion of each task on a weekly basis.

    Copyright:

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

    Gantt Chart Template For Google Sheets

    Uploaded by

    Ramdhan Mazid Abdullah
    82 views11 pages
    This document contains a Gantt chart template that can be used to plan and track projects over time. The template includes columns for task name, start date, end date, duration, team member, and a chart to visualize the timeline. An example is provided with 4 sample projects that are broken down into specific tasks assigned to team members along with start and end dates. The template also includes a progress bar chart to track percent completion of each task on a weekly basis.

    Original Description:

    Gantt Chart Template

    Original Title

    Gantt Chart Template for Google Sheets

    Copyright

    © © All Rights Reserved

    Available Formats

    ODS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a Gantt chart template that can be used to plan and track projects over time. The template includes columns for task name, start date, end date, duration, team member, and a chart to visualize the timeline. An example is provided with 4 sample projects that are broken down into specific tasks assigned to team members along with start and end dates. The template also includes a progress bar chart to track percent completion of each task on a weekly basis.

    Copyright:

    © All Rights Reserved
    Download as ODS, PDF, TXT or read online from Scribd
    Download as ods, pdf, or txt
    82 views11 pages

    Gantt Chart Template For Google Sheets

    Uploaded by

    Ramdhan Mazid Abdullah
    This document contains a Gantt chart template that can be used to plan and track projects over time. The template includes columns for task name, start date, end date, duration, team member, and a chart to visualize the timeline. An example is provided with 4 sample projects that are broken down into specific tasks assigned to team members along with start and end dates. The template also includes a progress bar chart to track percent completion of each task on a weekly basis.

    Copyright:

    © All Rights Reserved
    Download as ODS, PDF, TXT or read online from Scribd
    Download as ods, pdf, or txt
    of 11
    At a glance
    Powered by AI
    The document outlines multiple sample projects scheduled over several weeks using gantt charts. It shows tasks, start and end dates, resources assigned, and progress.

    The main projects outlined are a first sample project, second sample project, third sample project, and fourth sample project.

    Some examples of tasks involved in the projects include writing landing pages, designing promotional emails, reserving rooms, finalizing presentations, coding calculators, and updating messaging.

    ###

    GANTT CHART TEMPLATE Build better gantt charts with Team

    To edit this chart, you must first make a copy. Go to File, the select Make a Copy.
    * = an automatically calculated cell
    DAY OF DURATION*
    TASK NAME START DATE MONTH* END DATE (WORK DAYS)
    First Sample Project
    Write Landing Page Copy 1/5 5 1/8 3
    Approve Page Copy 1/8 8 1/11 3
    Review Landing Page Design 1/11 11 1/16 5
    Build Landing Page 1/14 14 1/19 5
    Code Review Landing Page 1/17 17 1/23 6
    Second Sample Project
    Write Promotional Email 1/9 9 1/12 3
    Design Promotional Email 1/12 12 1/19 7
    Send Promotional Email 1/17 17 1/19 2
    Analyze Campaign Results 1/22 22 1/26 4
    Third Sample Project
    Plan Agenda for Meeting 1/15 15 1/19 4
    Reserve Room 1/22 22 1/23 1
    Finalize Presentation 1/22 22 1/26 4
    Approve Presentation 1/26 26 1/29 3
    Create Invitations 1/22 22 1/25 3
    Fourth Sample Project
    Rewrite Online Calculator 1/15 15 1/24 9
    Code Review Calculator 1/25 25 1/30 5
    Update Messaging 1/24 24 1/30 6
    Publish Calculator 1/30 30 1/31 1
    antt charts with TeamGantt for FREE!

    DAYS DAYS PERCENT WEEK 1


    COMPLETE* REMAINING* TEAM MEMBER COMPLETE

    3 0 Nathan 100%
    2.4 0.6 Meredith 80%
    3 2 Brandon 60%
    2 3 Michael 40%
    1.2 4.8 Rachel 20%

    3 0 Nathan 100%
    5.6 1.4 Meredith 80%
    1.2 0.8 Brandon 60%
    1.6 2.4 Michael 40%

    4 0 Nathan 100%
    0.8 0.2 Meredith 80%
    2.4 1.6 Brandon 60%
    1.2 1.8 Michael 40%
    0.6 2.4 Rachel 20%

    9 0 Nathan 100%
    4 1 Meredith 80%
    3.6 2.4 Michael 60%
    0 1 Rachel 0%

    -4 1 6 11
    WEEK 1 WEEK 2 WEEK 3 WEEK 4

    6 11 16 21 26 31

    Days of the Month


    GANTT CHART TEMPLATE
    * = an automatically calculated cell
    START ON DURATION*
    TASK NAME START DATE END DATE DAY* (WORK DAYS)
    First Sample Project
    Write Landing Page Copy 1/5 1/8 0 3
    Approve Page Copy 1/8 1/11 3 3
    Review Landing Page Design 1/11 1/16 6 5
    Build Landing Page 1/14 1/19 9 5
    Code Review Landing Page 1/17 1/23 12 6
    Second Sample Project
    Write Promotional Email 1/9 1/12 4 3
    Design Promotional Email 1/12 1/19 7 7
    Send Promotional Email 1/17 1/19 12 2
    Analyze Campaign Results 1/22 1/26 17 4
    Third Sample Project
    Plan Agenda for Meeting 1/15 1/19 10 4
    Reserve Room 1/22 1/23 17 1
    Finalize Presentation 1/22 1/26 17 4
    Approve Presentation 1/26 1/29 21 3
    Create Invitations 1/22 1/25 17 3
    Fourth Sample Project
    Rewrite Online Calculator 1/15 1/24 10 9
    Code Review Calculator 1/25 1/30 20 5
    Update Messaging 1/24 1/30 19 6
    Publish Calculator 1/30 1/31 25 1
    PERCENT WEEK 1 WEEK 2
    TEAM MEMBER COMPLETE
    Write Landing Page Copy
    Approve Page Copy
    Nathan 100%
    Review Landing Page Design
    Meredith 80%
    Brandon 60% Build Landing Page
    Michael 40% Code Review Landing Page
    Rachel 20%
    Write Promotional Email
    Nathan 100%
    Design Promotional Email
    Meredith 80%
    Brandon 60% Send Promotional Email
    Michael 40% Analyze Campaign Results

    Nathan 100% Plan Agenda for Meeting


    Meredith 80% Reserve Room
    Brandon 60%
    Finalize Presentation
    Michael 40%
    Rachel 20% Approve Presentation
    Create Invitations
    Nathan 100%
    Meredith 80% Rewrite Online Calculator
    Michael 60% Code Review Calculator
    Rachel 0%
    Update Messaging
    Publish Calculator
    0 5 10 15

    Days of the Month


    WEEK 2 WEEK 3 WEEK 4

    0 15 20 25 30

    ys of the Month
    GANTT CHART TEMPLATE
    DURATION
    TASK NAME START DATE END DATE (WORK DAYS) TEAM MEMBER
    First Sample Project
    Write Landing Page Copy 1/5 1/8 3 Nathan
    0 Meredith
    Review Landing Page Design 1/11 1/16 5 Brandon
    Build Landing Page 1/14 1/19 5 Michael
    Code Review Landing Page 1/17 1/21 4 Rachel
    Promote Landing Page 1/20 1/23 3 Annie
    Second Sample Project
    Write Promotional Email 2/5 2/8 3 Nathan
    Design Promotional Email 2/8 2/13 5 Meredith
    Send Promotional Email to Contacts 2/11 2/16 5 Michael
    Analyze Results of Email Campagin 2/14 2/23 9 Annie
    Third Sample Project
    Plan Agenda for Team Meeting 3/5 3/8 3 Rachel
    Reserve Room and Resources for Meeting 3/8 3/13 5 Michael
    Finalize Team Presentation 3/11 3/16 5 Brandon
    Review & Approve Presentation 3/14 3/19 5 Meredith
    Create Invitations for Meeting 3/17 3/21 4 Annie
    Setup Room for Meeting 3/20 3/25 5 Nathan
    Fourth Sample Project
    Rewrite Code for Online Calculator 4/5 4/8 3 Nathan
    Code Review Updated Calculator 4/8 4/10 2 Meredith
    Update Messaging for Calculator 4/11 4/16 5 Michael
    Publish New Calculator to Site 4/14 4/18 4 Rachel
    PERCENT WEEK 1 WEEK 2 WEEK 3 WEEK 4
    COMPLETE M T W Th F M T W Th F M T W Th F M T

    100%
    80%
    60%
    40%
    20%
    10%

    100%
    80%
    60%
    40%

    100%
    80%
    60%
    40%
    20%
    10%

    100%
    80%
    60%
    40%
    WEEK 4 WEEK 5 WEEK 6 WEEK 7 WEEK 8
    W Th F M T W Th F M T W Th F M T W Th F M T
    WEEK 8 WEEK 9 WEEK 10 WEEK 11 WEEK 12
    W Th F M T W Th F M T W Th F M T W Th F M T
    WEEK 12
    W Th F

    You might also like