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

1、Critical Path MethodHELP 2010 Vertex42 LLCStart DateDays to Completion1/11/201020.00Finish Date2/5/2010Times(in Days)Time Distribution:Triangular42IDTask NamePredecessors(Enter one ID per cell)O(min)M(most likely)P(max)Duration(exp.time)ESEFLSLFSlack10Start0.000.000.000.000.000.0020Task A102464.000.

2、004.000.004.000.0030Task B103595.670.005.673.679.333.6740Task C204575.334.009.334.009.330.0050Task D2046106.674.0010.678.3315.004.3360Task E30404575.339.3314.679.3314.670.0070Task F503485.0010.6715.6715.0020.004.3380Task G603585.3314.6720.0014.6720.000.0090Finish70800.0020.0020.0020.0020.000.00Start

3、Task ATask BTask CTask DTask ETask FTask GFinish25201510502520151050Days:Weeks:CriticalFlexibleSlackEventsHolidays to Exclude from Working DaysSee help(F1)on the WORKDAY()functionDateNon-Working Days1/1/2009 New Years Day1/1/201112/25/2009 Christmas12/25/2010This worksheet lets you create a list of

4、dates to be excluded from the number of Working Days.TheWORKDAY()function already excludes weekends,so you only need to list dates for holidays and othernon-working days.If your project spans more than one year,make sure you add dates for each year.The named range,holidays,is a dynamic named range e

5、nding at the last blank cell in column A.Thecomments column is just for your reference.Terms of Use 2011 Vertex42 LLC.All rights reserved.This template is considered a copyrighted work under the Unites States and other copyrightlaws and is the property of Vertex42 LLC.The items listed below are addi

6、tional points to helpclarify how you may use this template.Not for Resale or Public SharingYou may make archival copies and customize this template only for your personal use oruse within your company or organization and not for resale or public sharing.You may not remove or alter any logo,trademark

7、,copyright,disclaimer,brand,termsof use,attribution,or other proprietary notices or marks within this template.This template and any customized or modified version of this template may NOT besold,distributed,published to an online gallery,hosted on a website,or placed on apublic server.Limited Priva

8、te SharingProvided that you observe the above terms,you may share your edited version of thistemplate*privately*with those specific people who*require*access to it within yourimmediate family,organization,or company.*Privately means only accessible to those few people who you expressively give permi

9、ssionto view or edit your file.It is your responsibility to ensure that adequate security measures areused so that your file is not available to the public.*Examples of acceptable private sharing with people who require access may include(a)sharing a budget spreadsheet with a spouse,(b)sharing a pro

10、ject schedule with your projectteam,or(c)sharing a timesheet with your employee or manager.See the following page on V for the complete license agreement and examples ofother allowed uses:http:/ template is provided for informational or educational use only and is not intended to berelied on as medi

11、cal,financial,legal,or other professional advice.Vertex42 LLC makes no guarantee or representations about this template,or the accuracy orcompleteness of the content contained within this template.Vertex42 LLC encourages you to seek the aid of a qualified professional before makingdecisions regarding health,financial,or legal issues.