全自动项目管控甘特图

1、Project Name Project ScheduleGantt Chart Template 2006-2018 by VLearn about the Pro version Company NameProject Start Date1/29/2018 (星期一)Display Week1Week 1Week 2Week 3Week 4Week 5Week 6Week 7Week 8Project Lead2929 1 1月月 201820185 5 2 2月月 201820181212 2 2月月 201820181919 2 2月月 201820182626 2 2月月 2018

2、20185 5 3 3月月 201820181212 3 3月月 201820181919 3 3月月 201820182018/1/292018/1/302018/1/312018/2/12018/2/22018/2/32018/2/42018/2/52018/2/62018/2/72018/2/82018/2/92018/2/102018/2/112018/2/122018/2/132018/2/142018/2/152018/2/162018/2/172018/2/182018/2/192018/2/202018/2/212018/2/222018/2/232018/2/242018/2

3、/252018/2/262018/2/272018/2/282018/3/12018/3/22018/3/32018/3/42018/3/52018/3/62018/3/72018/3/82018/3/92018/3/102018/3/112018/3/122018/3/132018/3/142018/3/152018/3/162018/3/172018/3/182018/3/192018/3/202018/3/212018/3/222018/3/232018/3/242018/3/25WBSTASKLEADSTARTENDDAYS% DONEWORKDAYSMT WTFSSMT WTFSSM

4、T WTFSSMT WTFSSMT WTFSSMT WTFSSMT WTFSSMT WTFSS1Task Category1.1TaskName周一 1/29/18周五 2/02/185100%51.2Task周六 2/03/18周三 2/07/18560%31.3Task周四 2/08/18周日 2/11/1840%21.4Task周四 2/01/18周日 2/04/18475%21.4.1Sub-Task周五 2/02/18周六 2/03/18250%11.4.2Sub-Task周日 2/04/18周二 2/06/18350%21.5Task周一 2/05/18周五 2/09/1850%5

5、1.6Task周六 2/03/18周五 2/09/1870%51.7Task周六 2/10/18周五 2/16/1870%52Task Category2.1Task周六 2/10/18周二 2/13/1840%22.2Task周三 2/14/18周五 2/16/1830%32.3Task周三 2/14/18周五 2/16/1830%32.4Task周六 2/17/18周四 2/22/1860%42.5Task周五 2/23/18周日 2/25/1830%13Task Category3.1Task周六 2/10/18周二 2/13/1840%23.2Task周三 2/14/18周五 2/16

6、/1830%33.3Task周三 2/14/18周五 2/16/1830%33.4Task周六 2/17/18周四 2/22/1860%43.5Task周五 2/23/18周日 2/25/1830%14Task Category4.1Task周一 1/29/18周一 1/29/1810%14.2Task周二 1/30/18周二 1/30/1810%14.3Task周三 1/31/18周三 1/31/1810%14.4Task周四 2/01/18周四 2/01/1810%14.5Task周五 2/02/18周五 2/02/1810%1Helphttps:/ This TemplateThis G

7、antt Chart Template provides an easy way to create a simple project schedule. You onlyneed to know some basic spreadsheet operations, such as how to insert, delete, copy and pasterows and cells. For more advanced uses, such as defining task dependencies, you will need toknow how to enter formulas.Be

8、 sure to read the Getting Started Tips below. Watching the video demos for Gantt ChartTemplate Pro may also help you see how to use the spreadsheet.Watch Demo Videos of the Pro Version on VPlease read the license agreement in the TermsOfUse worksheet to learn how you may or maynot use and share this

9、 spreadsheet.Getting Started Tips Bracketed Text is meant to be edited, like the project title and task descriptions. Some of the labels include cell comments to provide extra information. To adjust the range of dates shown in the Gantt chart, change the Display Week number. The Project Start Date i

10、s used to define the first week shown in the gantt chart. For each task, enter the Start Date and the duration of the task in Days. The End Date andWork Days columns are calculated using formulas. If you see # in a cell, widen the column to display the cell contents. Backup your file regularly to av

11、oid losing data! Excel files get corrupted occasionally.Inserting New Tasks (Rows)When inserting and deleting tasks, you need to insert and delete entire rows. Some columnscontain formulas (such as the End Date and the Work Days columns), so these formulas needto copied to the newly inserted rows.ME

12、THOD 1 (recommended) Insert a new blank row by right-clicking on the row number and selecting Insert. With the new blank row selected, press Ctrl+d to copy the formulas and formatting down fromthe row above OR use the row drag handle to copy the formulas and formatting down.METHOD 2 Copy a row from

13、the set of template rows at the bottom of the worksheet. Right-click on the row where you want to insert the new task and select Insert Copied Cells.Method 2 will work, but Excel will split/fracture/duplicate conditional formatting rules rather thanmerging the rules. This can cause inefficiencies in

14、 very large and heavily modified files.Help improve Excel by voting on a suggestion to fix this problem.Using the Template Rows and Choosing a WBS LevelThe set of template rows at the bottom of the Gantt Chart worksheet provide examples ofdifferent ways to format and define tasks for different WBS l

15、evels.Each different WBS level uses a different formula in the WBS column.You can either copy/paste/insert these template rows via Method 2 as explained above, OR youcan just copy/paste the desired WBS cell when you want to change the WBS level.If you leave a blank cell above a WBS number, the numbe

16、ring will reset to 1.x.x. The formulas aremeant for convenience, but you can manually enter the WBS numbers if you want to.You can indent the task description for sub-tasks by entering leading spaces or using the Indentfeature in Excel.Creating Task DependenciesYou can enter the Start date manually,

17、 or define task dependencies using a formula. Below aresome common options for defining the Start date:A. Enter the date manually (e.g. 1/3/2015)B. Reference the Project Start Date (e.g. =$E$4 )C. Set the Start date to the next Work Day after another tasks End date. Use the formula =WORKDAY(enddate,

18、1) where enddate is the reference to the End date of apredecessor task. For multiple predecessors, the formula would be=MAX(WORKDAY(enddate1,1),WORKDAY(enddate2,1)D. Set the Start date to the next Calendar Day after another tasks End date. This formula is very simple: =enddate+1 For multiple predece

19、ssors, the formula would be =MAX(enddate1,enddate2,enddate3)+1E. Set the Start date to a number of days before or after another date. This formula is just like the one in C or D, except that in place of the 1 you enter the number ofdays, such as =WORKDAY(enddate,5) or =WORKDAY(startdate,-5)F. Use a

20、lookup formula and the Predecessor column to define the start date.The formulas for using this method are built into Gantt Chart Template ProChanging the Color of the Bars in the Gantt ChartAdvanced The Gantt Chart is created using conditional formatting, so you can modify theconditional formatting

21、rules to change the format to a different color. The Pro version includes acolumn where you can change the color by entering a color code (b=blue, g=green, etc.)FAQsQ: How do I enter the Work Days instead of Calendar Days?Entering work days instead of calendar days is a feature of the Pro version. T

22、here is nothing inthe free version preventing you from entering your own formulas, though.Q: How do I calculate Calendar Days after entering the Start and End Dates?You can calculate the duration in calendar days (including both start and end dates) using theformula =enddate-startdate+1Q: How do I c

23、hange the Print Settings? (Excel 2010, 2013)Select the entire range of cells you want to print and go to File Print Area Set Print Area. Thengo to File Page Setup or File Print Preview and adjust the Scaling, Margins, and PageOrientation as desired.Q: How do I increase the range of dates displayed i

24、n the Gantt chart?You will need to add columns to the right of the Gantt Chart via copy/paste. Copy and paste thecolumns in groups of 7. Afterwards, you will also probably need to update the print area.Q: How do I create a summary row that shows the MIN and MAX dates for all sub-tasks?In the Start c

25、olumn, use the formula =MIN(range_of_start_dates)In the End column, use the formula =MAX(range_of_end_dates)In the Days column, use the formula =end_date-start_date+1Q: How do I calculate the %Complete for an entire category of tasks?The %Complete for a group of tasks can be calculated from its sub

26、tasks using the formulabelow, where workdays is a reference to the range of work day values and complete is areference to the %complete for each of the subtasks.=SUMPRODUCT(workdays,complete)/SUM(workdays)Example: Lets say you have 3 sub tasks that are 10 days, 12 days, and 14 days long,respectively

27、. If the first subtask is 50% complete and the others are 25% complete, you couldcalculate the overall percent complete for the group as:=(10*50%+12*25%+14*25%)/(10+12+14).Q: Ive messed up the chart area somehow. How do I fix it?Find a row that works, then copy the cells that make up the gantt chart

28、 area from that row into therow that is messed up. 2006-2018 Vertex42 LLCGantt Chart Template ProGantt Chart Template Pro is similar to this free version, butit is more feature-packed. It also comes with other bonus content.Learn About Gantt Chart Template Prohttps:/ following link is a blog post th

29、at talks specifically about thePro version for Excel Online.Gantt Chart Template Pro for Excel OnlineBenefits and Features of Gantt Chart Template ProSimple Color-CodingThe Pro version includes a column for specifying the color of bars in the chart. For example,you could change the color based on ur

30、gency or task lead.Daily, Weekly, or Monthly ViewThe Pro version includes a drop-down next to the Display Week that lets you choose to displaythe columns in the chart area as days, weeks, or months.Use Work Days as an InputBy default, the Pro version is set up to have you enter Work Days instead of

31、Calendar Days.The expanded set of template rows provides more options for defining the Start date, End date,and Duration of tasks. Define a task based on - Start date and End date - Start date and Work days - Start date and Calendar daysEasily Create Task DependenciesThough you can still use your ow

32、n formulas for creating task dependencies, the Pro versionincludes template rows that calculate the Start date based on the WBS number that you enterin the Predecessor column.Exclude Holidays from Work DaysList holidays and other specific non-working days that you want to exclude from work days.Customize Your Work WeekThe versions designed for Excel 2010+ use the WORKDAY.INTL() and NETWORKDAYS.INTL()functions that allow you define the work week as somethi