国外-excel-关键路径图模板.xls

国外-excel-关键路径图模板.xls

《国外-excel-关键路径图模板.xls》由会员分享，可在线阅读，更多相关《国外-excel-关键路径图模板.xls（5页珍藏版）》请在冰豆网上搜索。

CriticalPathMethodHELP2010Vertex42LLCStartDateDaystoCompletion1/11/201020.00FinishDate2/5/2010Times（inDays）TimeDistribution:

Triangular42IDTaskNamePredecessors（EnteroneIDpercell）O（min）M（mostlikely）P（max）Duration（exp.time）ESEFLSLFSlack10Start0.000.000.000.000.000.0020TaskA102464.000.004.000.004.000.0030TaskB103595.670.005.673.679.333.6740TaskC204575.334.009.334.009.330.0050TaskD2046106.674.0010.678.3315.004.3360TaskE30404575.339.3314.679.3314.670.0070TaskF503485.0010.6715.6715.0020.004.3380TaskG603585.3314.6720.0014.6720.000.0090Finish70800.0020.0020.0020.0020.000.00StartTaskATaskBTaskCTaskDTaskETaskFTaskGFinish25201510502520151050Days:

Weeks:

CriticalFlexibleSlackEventsHolidaystoExcludefromWorkingDaysSeehelp（F1）ontheWORKDAY（）functionDateNon-WorkingDays1/1/2009NewYearsDay1/1/201112/25/2009Christmas12/25/2010ThisworksheetletsyoucreatealistofdatestobeexcludedfromthenumberofWorkingDays.TheWORKDAY（）functionalreadyexcludesweekends,soyouonlyneedtolistdatesforholidaysandothernon-workingdays.Ifyourprojectspansmorethanoneyear,makesureyouadddatesforeachyear.Thenamedrange,holidays,isadynamicnamedrangeendingatthelastblankcellincolumnA.Thecommentscolumnisjustforyourreference.TermsofUse2011Vertex42LLC.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.SeethefollowingpageonVforthecompletelicenseagreementandexamplesofotheralloweduses:

http:

/templateisprovidedforinformationaloreducationaluseonlyandisnotintendedtobereliedonasmedical,financial,legal,orotherprofessionaladvice.Vertex42LLCmakesnoguaranteeorrepresentationsaboutthistemplate,ortheaccuracyorcompletenessofthecontentcontainedwithinthistemplate.Vertex42LLCencouragesyoutoseektheaidofaqualifiedprofessionalbeforemakingdecisionsregardinghealth,financial,orlegalissues.