您好,欢迎访问三七文档
当前位置:首页 > 商业/管理/HR > 管理学资料 > 国外-excel-关键路径图模板
CriticalPathMethodHELP©2010Vertex42LLCStartDateDaystoCompletion2010/1/1120.00FinishDate2010/2/5TimeDistribution:Triangular[42]IDTaskNameO(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.00Predecessors(EnteroneIDpercell)Times(inDays)0123450510152025StartTaskATaskBTaskCTaskDTaskETaskFTaskGFinishWeeks:Days:ESCriticalFlexibleEventsHolidaystoExcludefromWorkingDaysSeehelp(F1)ontheWORKDAY()functionDateNon-WorkingDays2009/1/1NewYear'sDay2011/1/12009/12/25Christmas2010/12/25ThisworksheetletsyoucreatealistofdatestobeexcludedfromthenumberofWorkingDays.TheWORKDAY()functionalreadyexcludesweekends,soyouonlyneedtolistdatesforholidaysandothernon-workingdays.Ifyourprojectspansmorethanoneyear,makesureyouadddatesforeachyear.Thenamedrange,holidays,isadynamicnamedrangeendingatthelastblankcellincolumnA.Thecommentscolumnisjustforyourreference.TermsofUse©2011Vertex42LLC.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:
本文标题:国外-excel-关键路径图模板
链接地址:https://www.777doc.com/doc-4805139 .html