Average Ceiling Height

Problem

average ceiling height is wrong!

Diagnosis

In order for the average ceiling height to calculate correctly, the user must not type anything for the ceiling heights of non-existent floors, while entering dimensions for MacNail construction estimating software. E.g. to get the correct avg ceil ht for a 2-story job, user must type in heights for floors 1 and 2, and leave heights for upper floors blank.

Solution

This error occurs because some people type in zero for the ceiling height of non-existent floors. MacNail construction estimating software then adds that in with the others (since we use the AVERAGE() function and that's how it works).

Comments

NOTE-- in 1994 we changed the formula so it now takes a weighted average, which won't have problems even if they type zeros for some floors (as long as they have zero floor area).

Entered 1/14/93 by Vinay. Updated 11/16/2010.