EXCEL甘特图模板-gantt-chart-L

[ProjectName][CompanyName]Today'sDate:Tuesday(verticalredline)ProjectLead:StartDate:Monday[42]FirstDayofWeek(Mon=2):2WBSTasksTaskLeadStartEndDuration(Days)%CompleteWorkingDaysDaysCompleteDaysRemaining1TaskCategory1[Name]1/2/121/31/12300%220301.1SubTasklevel21/2/121/6/1250%5051.2SubTasklevel21/7/121/11/1250%3051.2.1SubTasklevel31/12/121/16/1250%3051.2.2SubTasklevel31/17/121/21/1250%4051.3SubTasklevel21/22/121/26/1250%4051.4SubTasklevel21/27/121/31/1250%3052TaskCategory2[Name]1/2/121/27/122625%206202.1SubTasklevel21/2/121/6/12525%5142.2SubTasklevel21/9/121/13/12525%5142.3SubTasklevel21/16/121/20/12525%5142.4SubTasklevel21/23/121/27/12525%5143TaskCategory3[Name]1/2/121/28/122750%2013143.1SubTasklevel21/2/121/7/12650%5333.2SubTasklevel21/9/121/14/12650%5333.3SubTasklevel21/16/121/21/12650%5333.4SubTasklevel21/23/121/28/12650%5334TaskCategory4[Name]1/2/121/21/12200%150204.1SubTasklevel21/2/121/6/1250%5054.2SubTasklevel21/7/121/11/1250%3054.3SubTasklevel21/12/121/16/1250%3054.4SubTasklevel21/17/121/21/1250%40507-May-1220-Feb-1221-May-1214-May-1230-Apr-122012/1/2[Name]13-Feb-1226-Mar-1202-Apr-1209-Apr-1227-Feb-1205-Mar-1212-Mar-1219-Mar-1216-Apr-1223-Apr-1206-Aug-1209-Jul-1216-Jul-1223-Jul-1230-Jul-1220-Aug-1213-Aug-122009/2/2430-Jan-1206-Feb-1202-Jan-1209-Jan-1216-Jan-1223-Jan-1202-Jul-1204-Jun-1211-Jun-1218-Jun-1225-Jun-1228-May-12GanttChartTemplatebyVertex42.com©2008Vertex42LLCGanttChartTemplateProGanttChartTemplateProissimilartothisfreeversion,butitisunlocked,morefeature-packed,andincludesotherbonuscontentsuchassampleprojectschedules.Alreadyspentalotoftimeworkingwiththisfreeversion?That'sokay.InadditiontodownloadingtheGanttChartTemplateProfiles,youwillbegiventhepasswordforunlockingthisspreadsheet.LearnMoreAboutGanttChartTemplatePro(worksheetsarenotpassword-protected)ByunlockingthefreeversionorusingGanttChartTemplatePro,youwillbeabletouseallofthefunctionsandfeaturesavailableinExcel,suchasformattingcells,insertingcolumns,andgroupingrows.MoreWaystoDefineaTaskChoosefromalargersetoftemplaterowsthatprovidemoreoptionsfordefiningtheStartdate,Enddate,duration,anddependencyoftasks.Defineataskbasedonthe…-StartdateandEnddate-StartdateandWorkdays-StartdateandCalendardays-PredecessorandEnddate-PredecessorandWorkdays-PredecessorandCalendardaysEasilyCreateTaskDependenciesThoughyoucanstilluseyourownformulasforcreatingtaskdependencies,thenewPredecessoroptionsmakeitverysimple.Oneofthedemovideosdiscussesthisindetail.ExcludeHolidaysfromWorkDaysListholidaysinaseparatesheetthatyouwanttoexcludefromworkdays.SampleProjectSchedulesTogetaheadstartondefiningyourprojectschedule,youcanuseoneofthe3sampleganttcharts:-HomeConstructionProjectSchedule-CustomSoftwareProjectSchedule-WebsiteDevelopmentProjectScheduleNewExcel2007+Version(XLSX)InadditiontoGanttChartTemplateProforExcel2003,youwillbeabletodownloadanXLSXversion,forExcel2007orlater,thatallowsyoutoeasilycolor-codethebarsoftheganttchart.LearnMoreAboutGanttChartTemplateProGanttChartTemplateProissimilartothisfreeversion,butitisunlocked,morefeature-packed,andincludesotherAlreadyspentalotoftimeworkingwiththisfreeversion?That'sokay.InadditiontodownloadingtheGanttChartTemplateProfiles,youwillbegiventhepasswordforunlockingthisspreadsheet.LearnMoreAboutGanttChartTemplateProTermsofUse©2006-2012Vertex42LLC.Allrightsreserved.ThistemplateisconsideredacopyrightedworkundertheUnitesStatesandothercopyrightlawsandisthepropertyofVertex42LLC.Theitemslistedbelowareadditionalpointstohelpclarifyhowyoumayusethistemplate.NotforResaleorPublicSharingYoumaymakearchivalcopiesandcustomizethistemplateonlyforyourpersonaluseorusewithinyourcompanyororganizationandnotforresaleorpublicsharing.Youmaynotremoveoralteranylogo,trademark,copyright,disclaimer,brand,termsofuse,attribution,orotherproprietarynoticesormarkswithinthistemplate.ThistemplateandanycustomizedormodifiedversionofthistemplatemayNOTbesold,distributed,publishedtoanonlinegallery,hostedonawebsite,orplacedonapublicserver.LimitedPrivateSharingProvidedthatyouobservetheaboveterms,youmayshareyoureditedversionofthistemplate*privately*withthosespecificpeoplewho**require**accesstoitwithinyourimmediatefamily,organization,orcompany.*Privatelymeansonlyaccessibletothosefewpeoplewhoyouexpressivelygivepermissiontovieworedityourfile.Itisyourresponsibilitytoensurethatadequatesecuritymeasuresareusedsothatyourfileisnotavailabletothepublic.**Examplesofacceptableprivatesharingwithpeoplewhorequireaccessmayinclude(a)sharingabudgetspreadsheetwithaspouse,(b)sharingaprojectschedulewithyourprojectteam,or(c)sharingatimesheetwithyouremployeeormanager.SeethefollowingpageonVertex42.comforthecompletelicenseagreementandexamplesofotheralloweduses: