A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Digital Fabrication Course | Start Date: | May 21, 2014 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 | open main doc | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | Task | Start Date | End Date | Duration (days) | Percent Complete | May | June | July | |||||||||||||||||||||||||||||||||||||||||||||||||||
4 | Date: | 5/21 | 5/22 | 5/23 | 5/24 | 5/25 | 5/26 | 5/27 | 5/28 | 5/29 | 5/30 | 5/31 | 6/1 | 6/2 | 6/3 | 6/4 | 6/5 | 6/6 | 6/7 | 6/8 | 6/9 | 6/10 | 6/11 | 6/12 | 6/13 | 6/14 | 6/15 | 6/16 | 6/17 | 6/18 | 6/19 | 6/20 | 6/21 | 6/22 | 6/23 | 6/24 | 6/25 | 6/26 | 6/27 | 6/28 | 6/29 | 6/30 | 7/1 | 7/2 | 7/3 | 7/4 | 7/5 | 7/6 | 7/7 | 7/8 | 7/9 | 7/10 | 7/11 | 7/12 | |||||
5 | 1.0 Finalise list of Forums and usefull resources | 5/21/2014 | 5/24/2014 | 4 | 0.00% | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||||||||||
6 | 2.0 Look at similar course + establish price | 5/21/2014 | 5/25/2014 | 5 | 0.00% | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||||||
7 | 3.0 Determine course content | 5/21/2014 | 6/6/2014 | 17 | 0.00% | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||
8 | 4.0 Create student handout document | 6/2/2014 | 6/10/2014 | 9 | 0.00% | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||
9 | 5.0 Create feedback sheet | 6/9/2014 | 6/14/2014 | 6 | 0.00% | X | X | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||||||||
10 | 6.0 Create pamphlets | 6/9/2014 | 6/16/2014 | 8 | 0.00% | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||||||
11 | 7.0 Determine webpage content | 6/6/2014 | 6/20/2014 | 15 | 0.00% | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||
12 | 8.0 Create webpage | 6/9/2014 | 6/27/2014 | 19 | 0.00% | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||
13 | 9.0 Advertisement campaign | 6/16/2014 | 7/7/2014 | 22 | 0.00% | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||||
14 | 10.0 Determine location & arrangement | 6/16/2014 | 6/24/2014 | 9 | 0.00% | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||
15 | 11.0 Test and ask for feedback | 6/24/2014 | 6/27/2014 | 4 | 0.00% | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||||||||||
16 | 12.0 Give first course | 7/7/2014 | 7/8/2014 | 2 | 0.00% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
17 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
18 | Template Rows: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
19 | Highlight a row by clicking on row number at left, right-click and Copy, then highlight empty row, right-click and paste (formulas should stay intact). Insert a row above or below where you intend to paste before pasting. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
20 | 1.0 Task Heading | 2011-01-20 | 2011-01-20 | 1 | 0.00% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
21 | 1.1 Subtask 1 | 2011-01-20 | 2011-01-20 | 1 | 0.00% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
22 | 1.2 Subtask 2 | 2011-01-20 | 2011-01-20 | 1 | 0.00% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
24 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
25 | Help: | Credits | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
26 | - Go to File => Make a copy... to copy this file to your own Google Docs folder for editing. - Modify only the GREEN cells and the Task and Subtask text. The other cells contain formulas which will fill in the other data and colorize the Gantt chart. - In the TASK column, precede the task name with the WBS number (technical note: Google Spreadsheet only allows 5 columns to be frozen, so I included the WBS number in with the Task name for simplicity's sake). - Double-clicking a field in the Start Date and End Date columns should expose a pop-out calendar for date selection (though it seems to be buggy from time to time). - In the graph, incomplete percentages are shown in dark gray (main tasks are almost black), while completed percentages are show in color (yellow for main tasks and blue for subtasks.) - Percentages on the charts are rounded down. If you have 50% completed on an item that is 5 days duration, 50% of 5 days is 2.5 days; the chart will round this down to 2 days so only 2 out of 5 cells will be shown as "done". - The TASK headings rows contain formulas that calculate based on the range of Subtasks under that heading. If something is fishy with the Task heading calculations or the way the chart is displayed, ensure that the Task heading formulas include the proper range of subtask cells. - This spreadsheet does NOT export well into other applications, though the PDF should be usuable. |