I need to finish this final term report. I have finished most of them. However, I have no idea about rationale and priority...... maybe it needs more information.
Michelle_Michy
20200718230854final_grant_chart.xlsxGanttChart
| [Carve On Marketing research ] Project Schedule | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| [Carve On ] | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Project Start Date | 43862.0 | Display Week | 1 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Project Lead | Alan | 27 Jan 2020 | 3 Feb 2020 | 10 Feb 2020 | 17 Feb 2020 | 24 Feb 2020 | 2 Mar 2020 | 9 Mar 2020 | 16 Mar 2020 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | ||||||||||
| WBS Vertex42: Work Breakdown Structure Level 1: 1, 2, 3, ... Level 2: 1.1, 1.2, 1.3, ... Level 3: 1.1.1, 1.1.2, 1.1.3, … - The WBS uses a formula to control the numbering, but the formulas are different for different levels. Copy and Paste the cells in the WBS column from the examples at the bottom of the worksheet. | TASK Vertex42: Task Description Enter the name of each task and sub-task. Use indents for sub-tasks. | LEAD Vertex42: Task Lead Enter the name of the Task Lead in this column. | PREDECESSOR Vertex42: Predecessor Tasks: You can use this column to enter the WBS of a predecessor for reference. The PRO version uses formulas to automatically calculate the Start Date based on the Predecessor. | START Vertex42: Task Start Date You can manually enter the Start Date for each task or use a formula to create a dependency on a Predecessor. For example, you could enter =enddate+1 to set the Start date to the next calendar day, or =WORKDAY(enddate,1) to set the Start date to the next work day (excluding weekends), where enddate is the cell reference for the End date of the Predecessor task. | END Vertex42.com Templates: End Date: The End Date is calculated based on the Start Date and the Calendar Days columns. | DAYS Vertex42: Duration (Calendar Days) The duration is the number of calendar days for the given task. The duration is calculated as the End Date minus the Start Date plus 1 day, so that a task starting and ending on the same day has a duration of 1 day. Note: The conditional formatting used to create the gantt chart references this column. | % DONE Vertex42: Percent Complete Update the status of this task by entering the percent complete (between 0% and 100%). | WORK DAYS Vertex42: Work Days Counts the number of work days, excluding the weekends (Saturday and Sunday). In the PRO version, you can customize the work week and list specific non-working days like holidays. In the PRO version, the default input is the Work Days instead of the Calendar Days. | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | |
| 1 | [Task Category] | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.1 | Project Plan | Sat 2/15/20 | Sun 3/01/20 | 5 | 100% | 10 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.2 | Hire Intern | Mon 2/03/20 | Tue 3/31/20 | 5 | 60% | 42 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.3 | Build Website | Tue 3/10/20 | Mon 4/20/20 | 4 | 45% | 30 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.4 | Find collaboration | Fri 5/01/20 | Fri 7/31/20 | 4 | 25% | 66 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.4.1 | Do the propaganda | Sat 5/02/20 | Sun 8/02/20 | 2 | 50% | 65 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.4.2 | Final project inspection | Mon 8/31/20 | Wed 9/30/20 | 3 | 0% | 23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.5 | [Task] | Mon 2/05/18 | Fri 2/09/18 | 5 | 0% | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.6 | [Task] | Sat 2/03/18 | Fri 2/09/18 | 7 | 0% | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.7 | [Task] | Sat 2/10/18 | Fri 2/16/18 | 7 | 0% | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1.8 | [Task] | Sat 2/10/18 | Tue 2/13/18 | 4 | 0% | 2 |
