Appendix B - Microsoft Excel Logic

This appendix contains the logic used in the Microsoft Excel workbook. This information will be useful if there is a need for any reason to re-create part or all of the worksheets. The Data Entry worksheet allows the user to enter geometric and operations data. While there are no equations in this particular worksheet, the values entered are used in subsequent worksheets. Thus, the cell layout for the Data Entry worksheet is provided in figure 19.

The Intermediate Calculations worksheet uses data from the former worksheet and makes a series of calculations as shown in figure 20. There are also several user-defined fields in this worksheet (i.e., K-factor, D-factor, and T-factor) for which the user must input values. Finally, the BCI and LOS Computations worksheet makes use of entries and computed values in both former worksheets as shown in figure 21.n in figure 21.

[Click here to download the Excel Worksheets for FIGURES 19-21]

 
figure 19
figure 20
figure 21