Floor Bay Analysis – Circular Reference

There is a potential for a circular reference in the Floor Bay Analysis spreadsheet.  Here are the steps to resolve this:

  1. If you’re using Excel 2010 or later, click File > Options > Formulas. If you’re using Excel for Mac, click the Excel menu, and then click Preferences > Calculation.
    If you’re using Excel 2007, click the Microsoft Office Button Office , click Excel Options, and then click the Formulas category.
  2. In the Calculation options section, select the Enable iterative calculation check box. On the Mac, click Use iterative calculation.
  3. To set the maximum number of times that Excel will recalculate, type 100 in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet.
  4. In the Maximum Change box, type 0.001 which is the smallest value required for iteration to continue. This is the smallest change in any calculated value. The smaller the number, the more precise the result and the more time that Excel needs to calculate a worksheet.