Scheduling Number Errors

Problem!

getting #DIV/0 or #NUM errors throughout schedule when using MacNail construction scheduling software

Diagnosis

possible explanation: they have typed 0 into cells E2 or F2, # of skilled & unskilled workers respectively. To work correctly these cells must be non-zero. If they don't have any skilled workers (or no unskilled workers), they can get the schedule to work by typing the same number into each of these cells, or figuring unskilled workers at 1/4 of # of skilled workers.

Solution

if this isn't the problem- use usual tricks for #DIV/0 errors: pick the first error, look at the formula, see where the division occurs, check the value of the denominator.
Can get these errors if the WEEKSIZE name is defined as 0 or otherwise badly defined.

Comments

Entered 3/10/94 by Vinay. Updated 11/23/2010.