A simple Macro to convert a selection of cells in a worksheet into a set of Text Boxes

A simple macro to help you determine what distribution type to use when performing a monte carlo simulation on a three point risk estimate.

When you need to plot several series on a chart (like 3 or 4 different forecasts in an S-curve) you can sometimes want to hide different series temporarily. This little trick helps do just that!

Step one is to (somewhere in the workbook) define a Yes, No list. Type in “Yes” and “No” in two cells
Go [...]

A quick way of ignoring the infamous #N/A in an excel sum

Scheduling is a fairly complex beast. it requires time, effort, dedication and  alot of understanding about how the scheduling tool is doing it’s job. What is worse, is that each tool will handle the same situation with slight variations. The forward and backward pass is the mainstay for all scheduling tools. Without the algorithm, we [...]