Mosquito - Sabah Hussein Gantt Chart
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
Mosquito - Dr Hussain's labStart Date:November 14, 2011
2
Sensorica
3
TaskStart DateEnd DateDuration
(days)
Percent CompleteJanuaryFebruaryMarchApril
4
Date:1/201/211/221/231/241/251/261/271/281/291/301/312/12/22/32/42/52/62/72/82/92/102/112/122/132/142/152/162/172/182/192/202/212/222/232/242/252/262/272/283/13/23/33/43/53/63/73/83/93/103/113/123/133/143/153/163/173/183/193/203/213/223/233/243/253/263/273/283/293/303/314/14/24/34/44/54/64/74/84/94/104/114/124/134/144/154/164/174/184/194/204/214/224/234/24
5
1.0 Electronics2011-11-152011-11-1950.00%
6
1.1 amplifier2011-11-152011-11-1510.00%
7
1.2 noise filter2011-11-162011-11-1720.00%
8
1.3 gain2011-11-182011-11-1920.00%
9
2.0 Analysis2011-02-182011-03-071860.80%YYYYYYYYYYXXXXXXXX
10
2.1 Subtask 12011-02-182011-03-071865.00%YYYYYYYYYYYXXXXXXX
11
2.2 Subtask 22011-02-212011-02-27750.00%YYYXXXX
12
3.0 Design2011-02-232011-03-091532.95%YYYYXXXXXXXXXXX
13
3.1 Subtask 12011-02-232011-03-091525.00%YYYXXXXXXXXXXXX
14
3.2 Subtask 22011-02-282011-03-06750.00%YYYXXXX
15
4.0 Implementation2011-02-282011-03-131426.67%YYYXXXXXXXXXXX
16
4.1 Subtask 12011-02-282011-03-131430.00%YYYYXXXXXXXXXX
17
4.2 Subtask 22011-03-072011-03-13720.00%YXXXXXX
18
5.0 Testing2011-03-132011-03-221010.00%YXXXXXXXXX
19
5.1 Subtask 12011-03-132011-03-19710.00%XXXXXXX
20
5.2 Subtask 22011-03-162011-03-22710.00%XXXXXXX
21
6.0 Deployment2011-03-182011-04-06200.00%XXXXXXXXXXXXXXXXXXXX
22
6.1 Subtask 12011-03-182011-03-27100.00%XXXXXXXXXX
23
6.2 Subtask 22011-03-242011-04-06140.00%XXXXXXXXXXXXXX
24
25
26
27
28
Template Rows:
29
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.
30
1.0 Task Heading2011-01-202011-01-2010.00%X
31
1.1 Subtask 12011-01-202011-01-2010.00%X
32
1.2 Subtask 22011-01-202011-01-2010.00%X
33
34
35
Help:Credits
36
- 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.
Loading...