全自动项目管控甘特图

[ProjectName]ProjectScheduleGanttChartTemplate©2006-2018byVertex42.com[CompanyName]ProjectStartDateDisplayWeek1ProjectLead2930311234567891011121314151617181920212223242526272812345678910111213141516171819202122232425WBSTASKLEADSTARTENDDAYS%DONEWORKDAYSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSS1[TaskCategory]1.1[Task][Name]Mon1/29/18Fri2/02/185100%51.2[Task]Sat2/03/18Wed2/07/18560%31.3[Task]Thu2/08/18Sun2/11/1840%21.4[Task]Thu2/01/18Sun2/04/18475%21.4.1[Sub-Task]Fri2/02/18Sat2/03/18250%11.4.2[Sub-Task]Sun2/04/18Tue2/06/18350%21.5[Task]Mon2/05/18Fri2/09/1850%51.6[Task]Sat2/03/18Fri2/09/1870%51.7[Task]Sat2/10/18Fri2/16/1870%52[TaskCategory]2.1[Task]Sat2/10/18Tue2/13/1840%22.2[Task]Wed2/14/18Fri2/16/1830%32.3[Task]Wed2/14/18Fri2/16/1830%32.4[Task]Sat2/17/18Thu2/22/1860%42.5[Task]Fri2/23/18Sun2/25/1830%13[TaskCategory]3.1[Task]Sat2/10/18Tue2/13/1840%23.2[Task]Wed2/14/18Fri2/16/1830%33.3[Task]Wed2/14/18Fri2/16/1830%33.4[Task]Sat2/17/18Thu2/22/1860%43.5[Task]Fri2/23/18Sun2/25/1830%14[TaskCategory]4.1[Task]Mon1/29/18Mon1/29/1810%14.2[Task]Tue1/30/18Tue1/30/1810%14.3[Task]Wed1/31/18Wed1/31/1810%14.4[Task]Thu2/01/18Thu2/01/1810%14.5[Task]Fri2/02/18Fri2/02/1810%1Week819Mar201826Feb2018Week65Mar2018Week5Week712Mar2018LearnabouttheProversionWeek419Feb2018Week2Week11/29/2018(Monday)5Feb201829Jan2018Week312Feb2018Help•[BracketedText]ismeanttobeedited,liketheprojecttitleandtaskdescriptions.•Someofthelabelsincludecellcommentstoprovideextrainformation.•ToadjusttherangeofdatesshownintheGanttchart,changetheDisplayWeeknumber.•TheProjectStartDateisusedtodefinethefirstweekshownintheganttchart.•Foreachtask,entertheStartDateandthedurationofthetaskinDays.TheEndDateandWorkDayscolumnsarecalculatedusingformulas.•Ifyousee#####inacell,widenthecolumntodisplaythecellcontents.•Backupyourfileregularlytoavoidlosingdata!Excelfilesgetcorruptedoccasionally.Wheninsertinganddeletingtasks,youneedtoinsertanddeleteentirerows.Somecolumnscontainformulas(suchastheEndDateandtheWorkDayscolumns),sotheseformulasneedtocopiedtothenewlyinsertedrows.METHOD1(recommended)•Insertanewblankrowbyright-clickingontherownumberandselectingInsert.•Withthenewblankrowselected,pressCtrl+dtocopytheformulasandformattingdownfromtherowaboveORusetherowdraghandletocopytheformulasandformattingdown.METHOD2•Copyarowfromthesetoftemplaterowsatthebottomoftheworksheet.•Right-clickontherowwhereyouwanttoinsertthenewtaskandselectInsertCopiedCells.Method2willwork,butExcelwillsplit/fracture/duplicateconditionalformattingrulesratherthanmergingtherules.Thiscancauseinefficienciesinverylargeandheavilymodifiedfiles.HelpimproveExcelbyvotingonasuggestiontofixthisproblem.InsertingNewTasks(Rows)GettingStartedTipsUsingtheTemplateRowsandChoosingaWBSLevelThesetoftemplaterowsatthebottomoftheGanttChartworksheetprovideexamplesofdifferentwaystoformatanddefinetasksfordifferentWBSlevels.EachdifferentWBSlevelusesadifferentformulaintheWBScolumn.Youcaneithercopy/paste/insertthesetemplaterowsviaMethod2asexplainedabove,ORyoucanjustcopy/pastethedesiredWBScellwhenyouwanttochangetheWBSlevel.IfyouleaveablankcellaboveaWBSnumber,thenumberingwillresetto1.x.x.Theformulasaremeantforconvenience,butyoucanmanuallyentertheWBSnumbersifyouwantto.Youcanindentthetaskdescriptionforsub-tasksbyenteringleadingspacesorusingtheIndentfeatureinExcel.YoucanentertheStartdatemanually,ordefinetaskdependenciesusingaformula.BelowaresomecommonoptionsfordefiningtheStartdate:A.Enterthedatemanually(e.g.1/3/2015)B.ReferencetheProjectStartDate(e.g.=$E$4)C.SettheStartdatetothenextWorkDayafteranothertask'sEnddate.•Usetheformula=WORKDAY(enddate,1)whereenddateisthereferencetotheEnddateofapredecessortask.•Formultiplepredecessors,theformulawouldbe=MAX(WORKDAY(enddate1,1),WORKDAY(enddate2,1))D.SettheStartdatetothenextCalendarDayafteranothertask'sEnddate.•Thisformulaisverysimple:=enddate+1•Formultiplepredecessors,theformulawouldbe=MAX(enddate1,enddate2,enddate3)+1E.SettheStartdatetoanumberofdaysbeforeorafteranotherdate.•ThisformulaisjustliketheoneinCorD,exceptthatinplaceofthe1youenterthenumberofdays,suchas=WORKDAY(enddate,5)or=WORKDAY(startdate,-5)F.UsealookupformulaandthePredecessorcolumntodefinethestartdate.[TheformulasforusingthismethodarebuiltintoGanttChartTemplatePro][Advanced]TheGanttChartiscreatedusingconditionalformatting,soyoucanmodifytheconditionalformattingrulestochangetheformattoadifferentcolor.TheProversionincludesacolumnwhereyoucanchang