week 4 ass 2

CPM

Critical Path Method
HELP																© 2010-2020 Vertex42 LLC
	Start Date								Days to Completion
	1/11/15								20.00
	Finish Date Vertex42: Finish Date: The Finish Date uses the WORKDAY() function to calculate the date to completion, excluding weekends and the holidays listed in the Holidays worksheet. If you see a #NAME or other error in the Finish Date, you probably need to install the Analysis ToolPak and then recalculate the worksheet by pressing Ctrl+Alt+F9.
	2/5/15
								Times (in Days)
									Time Distribution:	Triangular						[42]																																																												Series Used in the Gantt Chart								Weeks	Days
ID Vertex42: Task ID: Normally, you would start by assigning IDs as 10, 20, 30, etc. However, the ID can be anything you want, including text.	Task Name Vertex42: Task Name: The task name is a description that will show up in the gantt chart. The task name will be bolded if the task is a critical task. This is done through conditional formatting.	Predecessors (Enter one ID per cell) Vertex42: Predecessors: The set of events immediately preceding the task. In a network diagram or PERT chart, the predecessors for a particular task are all the tasks which have arrows pointing to that particular task. - Each predecessor needs to refer to the ID in column A. Successors: The set of events immediately following a particular task. In a network diagram or PERT chart, arrows are drawn from a task to its successors.						O (min) Vertex42: Optimistic Time (O): The minimum time required to complete the task. Assumes that everything proceeds faster than normal.	M (most likely) Vertex42: Most Likely Time (M): The most likely time required to complete the task, assuming everything proceeds as normal.	P (max) Vertex42: Pessimistic Time (P): The maximum time required to complete the task. Assumes that everything proceeds slower than normal.	Duration (exp. time) Vertex42: Duration or Expected Time: Using a Beta distribution, where O is the minimum, P is the maximum, and M is the most likely value, the formula for calculating the mean or expected time is: Duration = (O+4M+P)/6 Using a Triangular distribution, the mean of the distribution would be: Duration = (O+M+P)/3	ES Vertex42: Early Start Time: The ES is the maximum EF of all predecessors, except for the first task where the ES=0.	EF Vertex42: Early Finish Time: The EF time is the ES time plus the duration (EF=ES+Duration).	LS Vertex42: Late Start Time: The LS time is calculated as the LF time minus the duration (LS=LF-Duration).	LF Vertex42: Late Finish Time: The LF time is the minimum LS of all the successors, except for the last task where LF equals EF.	Slack Vertex42: Slack Time: The Slack time is calculated as LF minus EF. It can also be calculated as LS minus ES. If the slack is zero, then the task is on the critical path.		EF of Predecessors							Successors																									LS of Successors																										ES	Critical	+T	-T	Duration	+T	-T	Slack	Events	Events	Axis
10	Start										0.00	0.00	0.00	0.00	0.00	0.00		0	0	0	0	0	0			20	30																								0	3.6666666667																								ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	0	0	-0.5
20	Task A	10						2	4	6	4.00	0.00	4.00	0.00	4.00	0.00		0	0	0	0	0	0					40	50																								4	8.3333333333																						0	4.00	2.00	2.00	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	0	ERROR:#N/A	ERROR:#N/A	0.5
30	Task B	10						3	5	9	5.67	0.00	5.67	3.67	9.33	3.67		0	0	0	0	0	0							60																									9.3333333333																					0	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	5.67	3.33	2.67	3.66667	ERROR:#N/A	ERROR:#N/A	1.5
40	Task C	20						4	5	7	5.33	4.00	9.33	4.00	9.33	0.00		4	0	0	0	0	0							60																									9.3333333333																					4	5.33	1.67	1.33	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	0	ERROR:#N/A	ERROR:#N/A	2.5
50	Task D	20						4	6	10	6.67	4.00	10.67	8.33	15.00	4.33		4	0	0	0	0	0								70																									15																				4	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	6.67	3.33	2.67	4.33333	ERROR:#N/A	ERROR:#N/A	3.5
60	Task E	30	40					4	5	7	5.33	9.33	14.67	9.33	14.67	0.00		5.6666666667	9.3333333333	0	0	0	0									80																									14.6666666667																			9.3333333333	5.33	1.67	1.33	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	0	ERROR:#N/A	ERROR:#N/A	4.5
70	Task F	50						3	4	8	5.00	10.67	15.67	15.00	20.00	4.33		10.6666666667	0	0	0	0	0										90																									20																		10.6666666667	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	5.00	3.00	2.00	4.33333	ERROR:#N/A	ERROR:#N/A	5.5
80	Task G	60						3	5	8	5.33	14.67	20.00	14.67	20.00	0.00		14.6666666667	0	0	0	0	0										90																									20																		14.6666666667	5.33	2.67	2.33	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	0	ERROR:#N/A	ERROR:#N/A	6.5
90	Finish	70	80								0.00	20.00	20.00	20.00	20.00	0.00		15.6666666667	20	0	0	0	0																																																					ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	4	20	7.5

&8http://www.vertex42.com/ExcelTemplates/critical-path-method.html

ES Start Task A Task B Task C Task D Task E Task F Task G Finish #N/A 0 0 4 4 9.3333333333333321 10.666666666666668 14.666666666666664 #N/A Critical Start Task A Task B Task C Task D Task E Task F Task G Finish #N/A 4 #N/A 5.333333333333333 #N/A 5.333333333333333 #N/A 5.333333333333333 #N/A Flexible #N/A #N/A 5.666666666666667 #N/A 6.666666666666667 #N/A 5 #N/A #N/A Slack Start Task A Task B Task C Task D Task E Task F Task G Finish #N/A 0 3.6666699999999999 0 4.3333300000000001 0 4.3333300000000001 0 #N/A Events 0 #N/A #N/A #N/A #N/A #N/A #N/A #N/A 3.9999999999999991 -0.5 0.5 1.5 2.5 3.5 4.5 5.5 6.5 7.5

Days:

Weeks:

http://www.vertex42.com/ExcelTemplates/critical-path-method.html

Holidays

Holidays to Exclude from Working Days
See help (F1) on the WORKDAY() function
This worksheet lets you create a list of dates to be excluded from the number of Working Days. The WORKDAY() function already excludes weekends, so you only need to list dates for holidays and other non-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 ending at the last blank cell in column A. The comments column is just for your reference.
Date	Non-Working Days
1/1/09	New Year's Day
1/1/11
12/25/09	Christmas
12/25/10

©

Critical Path Method
	By Vertex42.com
	http://www.vertex42.com/ExcelTemplates/critical-path-method.html
	© 2010-2020 Vertex42 LLC
	This spreadsheet, including all worksheets and associated content is a copyrighted work under the United States and other copyright laws.
	Do not submit copies or modifications of this template to any website or online template gallery.
	Please review the following license agreement to learn how you may or may not use this template. Thank you.
	See License Agreement
	http://www.vertex42.com/licensing/EULA_privateuse.html
	Do not delete this worksheet. If necessary, you may hide it by right-clicking on the tab and selecting Hide.

http://www.vertex42.com/licensing/EULA_privateuse.html http://www.vertex42.com/ExcelTemplates/critical-path-method.html

image1.png