Project Management Example A D E F G G H 1 1 2 Spreadsheet Modeling Project 3 4 Activity Description Predecessor Time EST EFT LST LFT Slack 5 A Problem Statement 3 0 3 0 3 0 30 6 B Data Collection A 4 3 7 3 7 0 7 0 7 Assumption Specification B 3 3 7 7 10 22 25 15 8 D Structure Formulation B 10 7 17 7 17 0 7 7 9 9 E Problem Solving D 8 17 25 17 25 0 0 10 F Model Analyzing D 4 17 21 21 25 4 4 11 G Decision Making D 6 17 23 19 25 2 2 12 H Workbook Development C,E,F,G 8 8 25 33 25 33 0 0 13 1 Assessment H 5 33 38 33 38 0 0 14 J Analysis H 5 6 33 38 35 40 2 15 K Correction 1 4 4 38 42 38 42 0 0 16 L L Improvement J 2 38 40 40 42 2 17 M Implementation KL 4 42 46 42 46 0 CPM with Spreadsheet Learning Tip o Formulas->Evaluate Formula Use the command to step through the evaluation of the array formulas for the EST and LFT calculations Value: 4 : 4 Please match the following formulae with different time elements for Activity A. Note: You may want to copy the complex array formulae for the individual assignment. a. EFT b. EST C. LET d. LST 1. {MAX(IFISERR(FIND($A$5:$A$17,C53,0,SF$5:$E$17)} a a 2. =ES+D5 b 3. =H5-D5 c 4. {=MINIFISERR(FIND(AS,$C$5:$C$17), MAX($F$5:$F$17),$G$5:$G$17)}} d Check