Team Member Guide

  Capstone Spreadsheet Navigation

Decisions

Decision entry spreadsheets are selected from the Decisions menu item or from the tool palette on the right side of the spreadsheet.

In each decision area, the cell displays are either green or yellow:

Values in green cells can be changed, values in yellow cannot be changed directly, but will update as the values in the green cells change.

Numbers with decimal points are in units of 1. Numbers without decimals are in 1000’s. Some green cells will turn red and the numbers will be slashed if an entry becomes too large.

Each decision area works independently from the others, however, some areas depend on values entered on other areas. For example, the Production area relies on the Forecast and Accounts Payable information on the Marketing area.