App Icon
Create and modify a planning schedule for project management with WBS work breakdown and Gantt time chart both in one sheet.
Listing updated:July 30, 2022
Works with:
989,457
Overview
This free add-on helps you to create and modify a project schedule in a spreadsheet fast and accurately using a WBS work breakdown structure of tasks and start and finish dates per task. The Gantt chart can be set to show the project schedule for the range of weeks you like. During project execution, options for progress indication give color alerts in the schedule or Gantt for progress and delay. The add-on is available in several languages or a language can be requested.

The in-app PRO version adds resource assignment, cost calculation, scheduling with task duration and waterfall chaining of tasks to ProjectSheet, which help you in calculating and selling your project. The scheduling takes weekends and holidays into account.

A Work Breakdown Structure gives an overview of the tasks which fulfill the project scope:
- Create summary tasks and sub-tasks
- Increase/decrease the task level to change the indent
- Collapse/expand summary tasks

The schedule contains the tasks in time:
- Enter start and finish dates per sub-task
- Start and finish date of summary task are calculated from its sub-tasks
- Create milestones to mark agreed dates
- Use function to shift part or entire schedule in time

The generated Gantt chart shows the tasks as bars in time:
- Set start date of the Gantt chart
- Set scale of the Gantt chart
- Today's date is indicated as a vertical line
- Start day of period can be set to Sunday or Monday

Progress tracking during project execution:
- Indicate progress per task as a percentage
- Progress of summary task is calculated from its sub-tasks
- Progress is visible per task bar in Gantt chart
- Color indication of progress status per task relative to current date

PRO version:

Resource assignment:
- Assign resources to task
- Select work (per hour) or material (per unit) resources
- Overall work and cost calculation per resource in Resource sheet

Budget calculation:
- Each resource can have a cost rate per unit
- ProjectSheet calculates per task the cost based on its assigned resources
- Summary tasks calculate cost based on its sub-tasks
- ProjectSheet calculates per resource the cost based on all the tasks

Scheduling with task duration:
- Finish date will follow entered start date and task duration
- Task duration will follow entered finish date
- Start day and length of working week can be adjusted per document
- Weekends and holidays will be skipped as task duration

Chaining of tasks:
- Subsequent tasks on the same WBS level can be linked like a waterfall
- Summary tasks on same WBS level can be chained
- Sub-tasks will follow summary task or can be set to a fixed date
Additional information
PricingNot available
Developer
Non-trader
Privacy policy
Terms of service
ProjectSheet planning will ask for the permissions shown below. Learn more
ProjectSheet planning will need access to your Google account
This will allow ProjectSheet planning to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu