A | C | D | E | |
---|---|---|---|---|
1 | Choose language: | en | ||
2 | Gantt Chart Builder | |||
3 | ||||
4 | Procedure | |||
5 | ||||
6 | Preparatory operations | |||
7 | 1 | Make a copy of the template if you haven't already | https://docs.google.com/spreadsheets/d/1ks9hfoC5bEkcISoVa6W5bttoJ8rbRFflIMlcsZD-bvY/edit?usp=sharing | |
8 | 2 | Create new calendar | Google Calendar | |
9 | 3 | Copy Calendar ID | Calendar settings>>Integrate calendar>>Calendar ID | |
10 | 4 | Insert Project name, Calendar ID and Project Start and End dates into the Settings sheet | Settings sheet | |
11 | 5 | Populate the Gantt sheet with Project milestones | Gantt sheet | |
12 | 6 | Install the Gantt Chart Builder add-on if it's not already installed | Extensions >> Add-ons >> Get add-ons | |
13 | ||||
14 | Building a Gantt Chart | |||
15 | 1 | Select project name | Gant sheet >> Cell B3 | |
16 | 2 | Select an Create Gantt item from the menu | Gantt Chart Builder >> Create Gantt | |
17 | ||||
18 | Uploading project milestones to the calendar | |||
19 | 1 | Fill in the calendar with project data manually | Google Calendar | |
20 | 2 | You can also fill the calendar with data sheet automatically | Gantt Chart Builder >> Send * | |
21 | ||||
22 | Loading project milestones into a sheet from a Calendar | |||
23 | 1 | Select an Show item from the menu | Gantt Chart Builder >> Show | |
24 | 2 | You can also download project stages that meet certain conditions | Show sheet, cells B3, C3, C4 | |
25 | To do this, change the values in the cells and repeat select an Show item. | |||
26 | Mass removal of project milestones from the calendar | |||
27 | 1 | Leave only the milestones you want to delete on the Show sheet | Show sheet | |
28 | 2 | Select an Delete item from the menu | Gantt Chart Builder >> Delete Events >> Delete | |
29 | ||||
30 | Registration | |||
31 | 1 | Enter the password in the cell G1 Settings sheet. | Settings sheet, cell G1 | |
32 | 2 | Select an Registration item from the menu | Gantt Chart Builder >> Registration | |
33 | ||||
34 | More information and feedback | |||
35 | https://baublys.ru/gantt-chart-builder/ | |||
36 | ||||
37 | * Paid option, requires registration at the end of the trial period |