Crash Table Spreadsheet RRS feed

  • Question

  • The book suggests creating a crash table spreadsheet on excel. It’s benefit is that it enables opportunity to compare crashing cost of the tasks.

    Task Name, Duration and Cost columns are taken from MS Project and copied and pasted to Excel spreadsheet.

    Then Crash Reduction, Crash Cost and Cost Per Week Costs are added.

    Crash Reduction is crashing duration of the selected task.

    Cost Per Week is the cost of crashing per week. It is found by Crash Reduction / Crash Cost

    My question is that;

    1. Do we calculate Crash Costs manually?
    2. Do we calculate Crash Reductions manually? (So do we calculate how much time we can crash manually?)
    Tuesday, March 17, 2015 2:00 PM

All replies

  • Hi Jack,

    I suppose you have talking about "The missing manual" from Bonnie.

    On page 353, you'll see that you have first to display the critical path from MS Project to Excel. Then add the column headers crash reduction, crash cost and cost per week. The crash costs and the crash reduction have to be calculated manually. Meaning that on your longest critical task, you have to estimate/evaluate the reduction factor of the task (reduction) and how much it will cost.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller |

    Tuesday, March 17, 2015 2:36 PM