Spreadsheet Color Coding

Color coding

The calculation spreadsheets contain green input cells, gray informational cells, and red-bordered results cells filled with yellow or white. Users should use green input cells to enter all data specific to their facility, unit, or process. Gray informational cells contain parameter names, column and row headings, equation constants and subtotals. Calculation results are displayed in red-bordered results cells filled with yellow or white. For red-bordered, yellow-filled results cells, the values in these cells should be entered in the appropriate and separate calculation spreadsheet (as directed below cell) where additional calculations will be made. For red-bordered, white filled results cells, the values in these cells should be entered in e-GGRT for the appropriate process units. All cells that are not green input cells are locked and cannot be modified.

Green input cell (data entry)

Gray informational cells (locked)

Red-bordered, yellow-filled results cells (enter in appropriate and separate calculation spreadsheet)

Red-bordered, white filled results cells (enter in e-GGRT)

This web site is maintained by a contractor to the U.S. Environmental Protection Agency (RY2023.R.01)