Excel模板_甘特图模板_1.甘特图模板_1.推荐使用模板_gantt-chart_L

[panyName]WBS[ProjectName]ProjectScheduleTEMPLATEROWSInputCellLabelGettingStartedTipsFAQsQ:CreatingTaskDependencies[TaskCategory][Task][Name]ChangingtheColoroftheBarsintheGanttChartUsingtheTemplateRowsandChoosingaWBSLevelA.Enterthedatemanually(e.g.1/3/2015)B.ReferencetheProjectStartDate(e.g.=$E$4)C.SettheStartdatetothenextWorkDayafteranothertask'sEnddate.D.SettheStartdatetothenextCalendarDayafteranothertask'sEnddate.E.SettheStartdatetoanumberofdaysbeforeorafteranotherdate.Findarowthatworks,thencopythecellsthatmakeuptheganttchartareafromthatrowintotherowthatismessedup.SeetheHelpworksheettolearnhowtousetheserows.Youcanhidetheserowsbeforeprinting.PleasereadthelicenseagreementintheTermsOfUseworksheettolearnhowyoumayormaynotuseandsharethisspreadsheet..[Level2Task]..[Level3Task]...[Level4Task]TASKLEADSTARTENDDAYS%DONEWORKDAYSPREDECESSORDisplayWeekProjectStartDateProjectLead[Level1TaskorPhase]ThisGanttChartTemplateprovidesaneasywaytocreateasimpleprojectschedule.Youonlyneedtoknowsomebasicspreadsheetoperations,suchashowtoinsert,delete,copyandpasterowsandcells.Formoreadvanceduses,suchasdefiningtaskdependencies,youwillneedtoknowhowtoenterformulas.•Someofthelabelsincludecellmentstoprovideextrainformation.•Defihetaskstartdateandduration(days)byeditingthelightgreencells.•[BracketedText]ismeanttobeedited,liketheprojecttitleandtaskdescriptions.•Ifyousee"#####"inacell,widenthecolumntodisplaythecellcontents.•ToadjusttherangeofdatesshownintheGanttchart,changetheDisplayWeeknumber.•Backupyourfileregularlytoavoidlosingdata!Excelfilesgetcorruptedoccasionally.InsertingNewTasks(Rows)•InsertanewblankrowbyrightclickingontherownumberandselectingInsert.•Copyarowfromthesetoftemplaterowsatthebottomoftheworksheet.•Withthenewblankrowselected,pressCtrl+dtocopytheformulasandformattingdownfromtherowaboveORusetherowdraghandletocopytheformulasandformattingdown.AboutThisTemplateBesuretoreadtheGettingStartedTipsbelow.WatchingthevideodemosforGanttChartTemplatePromayalsohelpyouseehowtousethespreadsheet.•TheProjectStartDateisusedtodefihefirstweekshownintheganttchart.•Insertnewtasksusingoneofthemethodslistedbelow.Wheninsertinganddeletingtasks,youneedtoinsertanddeleteentirerows.Somecolumnscontainformulas(suchastheEndDateandtheWorkDayscolumns),sotheseformulasneedtocopiedtothenewlyinsertedrows.METHOD2•RightclickontherowwhereyouwanttoinsertthenewtaskandselectInsertCopiedCells.HelpimproveExcelbyvotingonasuggestiontofixthisproblem.METHOD1(remended)Youcaneithercopy/paste/insertthesetemplaterowsviaMethod2asexplainedabove,ORyoucanjustcopy/pastethedesiredWBScellwhenyouwanttochangetheWBSlevel.ThesetoftemplaterowsatthebottomoftheGanttChartworksheetprovideexamplesofdifferentwaystoformatanddefiasksfordifferentWBSlevels.EachdifferentWBSlevelusesadifferentformulaintheWBScolumn.IfyouleaveablankcellaboveaWBSnumber,thenumberingwillresetto1.x.x.Theformulasaremeantforconvenience,butyoucanmanuallyentertheWBSnumbersifyouwantto.YoucanindentthetaskdescriptionforsubtasksbyenteringleadingspacesorusingtheIndentfeatureinExcel.•Usetheformula=WORKDAY(enddate,1)whereenddateisthereferencetotheEnddateofapredecessortask.•Formultiplepredecessors,theformulawouldbe=MAX(WORKDAY(enddate1,1),WORKDAY(enddate2,1))•Thisformulaisverysimple:=enddate+1•Formultiplepredecessors,theformulawouldbe=MAX(enddate1,enddate2,enddate3)+1•ThisformulaisjustliketheoneinCorD,exceptthatinplaceofthe"1"youenterthenumberofdays,suchas=WORKDAY(enddate,5)or=WORKDAY(startdate,5)F.UsealookupformulaandthePredecessorcolumntodefihestartdate.[TheformulasforusingthismethodarebuiltintoGanttChartTemplatePro][Advanced]TheGanttChartiscreatedusingconditionalformatting,soyoucanmodifytheconditionalformattingrulestochangetheformattoadifferentcolor.TheProversionincludesacolumnwhereyoucanchangethecolorbyenteringacolorcode("b"=blue,"g"=green,etc.)HowdoIentertheWorkDaysinsteadofCalendarDays?The%pleteforagroupoftaskscanbecalculatedfromitssubtasksusingtheformulabelow,where"workdays"isareferencetotherangeofworkdayvaluesand"plete"isareferencetothe%pleteforeachofthesubtasks.EnteringworkdaysinsteadofcalendardaysisafeatureoftheProversion.Thereisnothinginthefreeversionpreventingyoufromenteringyourownformulas,though.=SUMPRODUCT(workdays,plete)/SUM(workdays)Example:Let'ssayyouhave3subtasksthatare10days,12days,and14dayslong,respectively.Ifthefirstsubtaskis50%pleteandtheothersare25%plete,youcouldcalculatetheoverallpercentpleteforthegroupas:=(10*50%+12*25%+14*25%)/(10+12+14).HowdoIchangethePrintSettings?(Excel2010,2013)YouwillneedtoaddcolumnstotherightoftheGanttChartviacopy/paste.Copyandpastethecolumnsingroupsof7.Afterwards,youwillalsoprobablyneedtoupdatetheprintarea.IntheStartcolumn,usetheformula=MIN(range_of_start_dates)IntheEndcolumn,usetheformula=MAX(range_of_end_dates)IntheDayscolumn,usetheformula=end_datestart_date+1HelpHowdoIincreasetherangeofdatesdisplayedintheGanttchart?HowdoIcreateasummaryrowthatshowstheMINandMAXdatesforallsubtasks?HowdoIcalculatethe%pleteforanentirecategoryoftasks?I'vemessedupthechartareasomehow.HowdoIfixit?HowdoIcalculateCalendarDaysafterenteringtheStartandEndDates?[Subtask]Method2willwork,butExcelwillsplit/fracture/duplicateconditionalformattingrulesratherthanmergingtherules.Thiscancauseinefficienciesinverylargeandheavilymodifiedfiles.YoucanentertheStartdatemanually,ordefiaskdependenciesusingaformula.BelowaresomemonoptionsfordefiningtheStartdate:SelecttheentirerangeofcellsyouwanttoprintandgotoFile>PrintArea>SetPrintArea.ThengotoFile>PageSetuporFile>PrintPreviewandadjusttheScaling,Margins,andPageOrientationasdesired.Youcancalculatethedurationincalendardays(includingbothstartandenddates)usingtheformula=enddatestartdate+1