ADVANCED EXCEL

profileoguzhansaglik
PERTSampleFormulas.xlsx

Sheet1

Sample ex.
Example Time Estimates (in weeks) for a Project / Cost estimates in $
ACTIVITY OPTIMISTIC MOST LIKELY PESSIMISTIC EXPECTED TIME VARIANCE
a m b t = (a + 4m + b)/6 [(b – a)/6]2
A 1 2 3 2 0.1111111111

Sheet2

Sheet3