excel-甘特图模板

WebsiteDevelopmentProjectSchedule[CompanyName][42]0WBSTaskLeadStartEndWorkDays%CompleteDuration(Days)DaysCompleteDaysRemaining1InceptionPhaseMikeMon1/03/11Mon1/24/11160%220221.1ClientPlanningMeetingMon1/03/11Mon1/03/1110%1011.2WebsiteRequirementsSurvey1.1Tue1/04/11Thu1/06/1130%3031.3AnalyzeSurvey1.2Fri1/07/11Mon1/10/1120%4041.4StoryboardConcept1.3Tue1/11/11Wed1/12/1120%2021.5ConceptApproval1.4Thu1/13/11Fri1/14/1120%2021.6RiskAnalysis1.5Tue1/18/11Wed1/19/1120%2021.7CompeletedContract1.6Thu1/20/11Thu1/20/1110%1011.8Kick-offMeeting1.7Fri1/21/11Mon1/24/1120%4041.9[InsertRowsabovethisone,thenHideorDeletethisrow]2RequirementsPhaseSallyTue1/25/11Wed2/09/11120%160162.1CustomerRequirements(Draft)1Tue1/25/11Thu1/27/1130%3032.2Definescope2.1Fri1/28/11Fri1/28/1110%1012.3DesignBranding(LookandFeel)2.2Mon1/31/11Tue2/01/1120%2022.4SEOStrategy2.2Mon1/31/11Tue2/01/1120%2022.5DefineKeywordList2.4Wed2/02/11Wed2/02/1110%1012.6DefineTechnicalRequirements2.2Mon1/31/11Tue2/01/1120%2022.7IdentifyHardwareRequirements2.6Wed2/02/11Thu2/03/1120%2022.8FinalRequirements2.52.7Fri2/04/11Mon2/07/1120%4042.9PhaseReview2.8Tue2/08/11Wed2/09/1120%2022.10[InsertRowsabovethisone,thenHideorDeletethisrow]3SpecificationsPhaseSallyThu2/10/11Fri3/11/11220%300303.1DefineSiteMap2Thu2/10/11Mon2/14/1130%5053.2DefinePageList3.1Tue2/15/11Wed2/16/1120%2023.3Createpagelayouts3.2Thu2/17/11Tue2/22/1130%6063.4Definegraphiclists3.3Wed2/23/11Thu2/24/1120%2023.5UIDesignPrototypes3.4Fri2/25/11Tue3/01/1130%5053.6DefineFormRequirements3.5Wed3/02/11Fri3/04/1130%3033.7CreateProductionGuide3.6Mon3/07/11Wed3/09/1130%3033.8PhaseReview3.7Thu3/10/11Fri3/11/1120%2023.9[InsertRowsabovethisone,thenHideorDeletethisrow]4Construction(Development)BillMon3/14/11Tue4/05/11170%230234.1Createpagetemplates3Mon3/14/11Thu3/17/1140%4044.2SetupDatabase3Mon3/14/11Fri3/18/1150%5054.3SetupCMS3Mon3/14/11Tue3/15/1120%2024.4Customprogramming4.14.24.3Mon3/21/11Fri3/25/1150%5054.5ValidationTesting4.4Mon3/28/11Wed3/30/1130%3034.6Refinementofprogramming4.5Thu3/31/11Fri4/01/1120%2024.7PhaseReview4.6Mon4/04/11Tue4/05/1120%2024.8[InsertRowsabovethisone,thenHideorDeletethisrow]5ContentPopulation&TestingBillWed4/06/11Thu4/21/11120%160165.1Createpagecontent4Wed4/06/11Fri4/08/1130%3035.2Createadditionalcustomgraphics4Wed4/06/11Fri4/08/1130%3035.3IntegrationTesting5.1Mon4/11/11Wed4/13/1130%3035.4UserTesting5.3Thu4/14/11Tue4/19/1140%60603-Jan-1110-Jan-11Predecessors[Name]1/3/2011(Monday)4/5/2020(Sunday)ProjectLead:ProjectStartDate:Today'sDate:17-Jan-1124-Jan-1131-Jan-1107-Feb-1114-Feb-1121-Feb-1128-Feb-1107-Mar-1120-Jun-1127-Jun-1104-Jul-1114-Mar-1121-Mar-1128-Mar-1104-Apr-1111-Apr-1118-Apr-1125-Apr-1102-May-1109-May-1116-May-1106-Jun-1113-Jun-1123-May-1130-May-1122-Aug-1111-Jul-1118-Jul-1125-Jul-1101-Aug-1108-Aug-1115-Aug-11WBSTaskLeadStartEndWorkDays%CompleteDuration(Days)DaysCompleteDaysRemaining03-Jan-1110-Jan-11Predecessors17-Jan-1124-Jan-1131-Jan-1107-Feb-1114-Feb-1121-Feb-1128-Feb-1107-Mar-1120-Jun-1127-Jun-1104-Jul-1114-Mar-1121-Mar-1128-Mar-1104-Apr-1111-Apr-1118-Apr-1125-Apr-1102-May-1109-May-1116-May-1106-Jun-1113-Jun-1123-May-1130-May-1122-Aug-1111-Jul-1118-Jul-1125-Jul-1101-Aug-1108-Aug-1115-Aug-115.5PhaseReview5.4Wed4/20/11Thu4/21/1120%2025.6[InsertRowsabovethisone,thenHideorDeletethisrow]6LaunchMikeFri4/22/11Tue5/17/11180%260266.1MigratetoProductionEnvironment5Fri4/22/11Tue4/26/1130%5056.2UserTraining6.1Wed4/27/11Thu4/28/1120%2026.3GoLive(Turnonsite)6.2Fri4/29/11Mon5/02/1120%4046.4ExternalPromotion6.3Tue5/03/11Wed5/04/1120%2026.5OnGoingSupport6.4Thu5/05/11Wed5/11/1150%7076.6PostGoLiveAnalysis6.5Thu5/12/11Fri5/13/1120%2026.7PostGoLiveReview6.6Mon5/16/11Tue5/17/1120%2026.8[InsertRowsabovethisone,thenHideorDeletethisrow]WebsiteDevelopmentProjectSchedule[CompanyName][42]0WBSTaskLeadStartEndWorkDays%CompleteDuration(Days)DaysCompleteDaysRemaining1InceptionPhaseMikeMon1/03/11Mon1/24/11160%220221.1ClientPlanningMeetingMon1/03/11Mon1/03/1110%1011.2WebsiteRequirementsSurvey1.1Tue1/04/11Thu1/06/1130%3031.3AnalyzeSurvey1.2Fri1/07/11Mon1/10/1120%4041.4StoryboardConcept1.3Tue1/11/11Wed1/12/1120%2021.5ConceptApproval1.4Thu1/13/11Fri1/14/1120%2021.6RiskAnalysis1.5Tue1/18/11Wed1/19/1120%2021.7CompeletedContract1.6Thu1/20/11Thu1/20/1110%1011.8Kick-offMeeting1.7Fri1/21/11Mon1/24/1120%4041.9[InsertRowsabovethisone,thenHideorDeletethisrow]2RequirementsPhaseSallyTue1/25/11Wed2/09/11120%160162.1CustomerRequirements(Draft)1Tue1/25/11Thu1/27/1130%3032.2Definescope2.1Fri1/28/11Fri1/28/1110%1012.3DesignBranding(LookandFeel)2.2Mon1/31/11Tue2/01/1120%2022.4SEOStrategy2.2Mon1/31/11Tue2/01/1120%2022.5DefineKeywordList2.4Wed2/02/11Wed2/02/1110%1012.6DefineTechnicalRequirements2.2Mon1/31/11Tue2/01/1120%2022.7IdentifyHardwareRequirements2.6Wed2/02/11Thu2/03/1120%2022.8FinalRequirements2.52.7Fri2/04/11Mon2/07/1120%4042.9PhaseReview2.8Tue2/08/11Wed2/09/1120%2022.10[InsertRowsabovethisone,thenHideorDeletethisrow]3SpecificationsPhaseSallyThu2/10/11Fri3/11/11220%300303.1DefineSiteMap2Thu2/10/11Mon2/14/1130%5053.2DefinePageList3.1T