Summary Maintenance

In order to prevent miscalculations in our statistic Summary spreadsheets, spreadsheet formulas should be checked quarterly to verify that formulas are present in a sufficient number of unfilled rows so as to prevent workflow disruption during the upcoming quarter.

These checks require the following steps:

1) Open each spreadsheet in Google docs to the Individual Responses tab, taking note of the number of rows filled in starting at Column A, and the date at which they began.

2) After reaching the last row where Column A has data, look to the columns still filled in at the right side of the sheet (usually starting around Column H), taking note of the row number at which they continue, and scroll down to the last row with this right-side data filled in (usually around row 1,000 or higher).

3) There should be a sufficient number of rows with this right-side data filled in so that, as staff submit additional statistic forms to record their metrics and this information fills in the rows starting at Column A, each row will be completely filled in (e.g., from Column A through Column N).

4) If more rows need to be added, copy the last populated row of right-side data and fill the columns downward.