To simplify data entry and review, the XPE cells are color coded. A color Legend appears at the bottom of the Summary sheet as shown in the following figure:
Figure 1. Color Legend (Summary Sheet)
A description of the spreadsheet color-coding scheme is provided in the following table:
| Cell Color | Cell Use | Available User Action |
|---|---|---|
| White | Allows user to enter data | Editable |
| Grey | Displays a calculated value | Read-only |
| Green | Displays a summary value | Read-only |
| Blue | User override of cells normally calculated by XPE | Editable |
| Orange | Flags a warning. Indicates that a resource is not available or a specification is invalid. | Editable |
| Red |
Flags an error. Following are a few examples:
|
Read-only. Edit other cells to correct the error. |