What You Can Do

  • Break down tasks into five levels

  • Automatically paint charts based on dates you enter

  • Automatically calculate workloads related to parent tasks

  • Automatically place bars based on progress you enter

  • Automatically calculate progress related to parent tasks based on workload weight

  • Change holidays as you want (*the default is Japanese holidays)

Specification

Add-on Menu

  • Create Gantt Chart

    • Create a schedule sheet and a holiday sheet

  • Show Sidebar

    • Show a sidebar


schedule sheet

  • Work Breakdown Structure

    • Assign task ID

  • Planned Start & Planned Finish

    • Paint a chart in blue

  • Planned Finish

    • Set a milestone in orange

  • Actual Start & Actual Finish

    • Paint a chart in green（*be hidden in the default）

  • Workload (plan)

    • Calculate parent's workload (sum children workloads)

  • Progress

    • Place bars in a chart & calculate parent's progress if tasks have workload (plan)


holiday sheet

  • A column

    • Make a holiday line in pink


Sidebar

  • Edit Gantt Chart

    • Change start date

    • Change chart width in week

    • Change timescale in day or week *only for premium users

  • Reflesh Gantt Chart

    • Repaint all of the Chart

    • Calculate all parents' workload and progress

  • Show Color Indication

    • Indicate progress like blue means "completed" or "not start," yellow means "in progress" and red means "delayed"

  • Show Parents' Charts

    • Automatically show total duration of parents' charts

  • Cheack assignment availability *only for premium users

    • Automatically Sort tasks by assignment

  • Initialize Gantt Chart

    • Initialize schedule sheet and holiday sheet

Recommended Usage

  • Place a project name in the top hierarchy and make all of the tasks its children. That is to say, you can automatically calculate progress of your project.

  • Break down tasks in detail like Parent tasks, child tasks and grandchild tasks.

  • Place planned start and planned finish in tasks which you have to watch daily or weekly.

  • Utilize "workday function." You can refer to A column in holiday sheet and workload (plan).

  • Place workload in man-day.

  • Watch progress by using actual start and actual finish or progress bar.

  • If you use progress bars, you may want to active Color Indication.

  • If you update numbers in progress column by using functions, charts won't be automatically updated. You need to use "Reflesh Gantt Chart."

Restriction

  • Do not change the name (schedule sheet and holiday sheet)

  • Do not insert rows above the item row

  • Do not edit or delete the hidden second row

  • Do not insert columns after the progress column

FAQ

The painting function does not work in my gantt chart..

This add-on is sometimes updated without notification. In most of those cases, you can activate the new version by using "Edit Gantt Chart," If your gantt chart still does not work, you may have to create a new spreadsheet and use this add-on from scratch. Then, you transfer the date from the previous one by copy & paste.


I got a system error when using sidebar...

There is possibility that a problem related to authority has occurred. Please try to delete browser cache. If you are using Google docs with more than two IDs at the same time, please use only one ID or utilize something like a secret browser which means there is no cache.


Date on my gantt chart is not correct...

There is a possibility that the timezone on your laptop differs from the timezone on your spreadsheet. Please check the setting and ensure the same timezone is used. *How to check the timezone on your spreadsheet


Date is not correct after a specific month...

Daylight saving time may cause this kind of problem. As a workaround, you can solve this by adding balance values like "2019/04/01 1:00:00" as this picture shown.


How do I extend the width of my gantt chart?

You can change the width on the sidebar. However, it is not recommended that you extend the width too much because processing speed in spread sheets gets slow as the number of columns increases.


How do I change the color of charts?

The color of charts can not be changed as you like. In the current specification, Show Color Indication is the function related to change of color, which shows blue means "completed" or "not yet start," yellow means "in progress," and red means "delayed".


Parents' progress always show zero...

Parents' progress are calculated based on the weighted average of their child's workload, which means that parents’s progress always shows 0% unless you enter "planned workload." Note: "Actual workload" does not have to do with any program. This is just space to make a note which allows you to look back your project after it finished.