YSI BODAnalyst - Manual (Page 38)

Reports Section 8
YSI Incorporated BOD Analyst for Windows Software 34
8.1 REPORT DESIGN
The report designer is used to setup spreadsheet type reports. Daily values and monthly summary
values from BOD Analyst software samples can be placed into the spreadsheet. After placement,
normal spreadsheet formulas can be used to calculate sums, averages, etc. of the placed BOD
Analyst software data. Formatting of the report is done through familiar spreadsheet functions to
change fonts, borders and cell colors, etc.
8.1.1 USING REPORT DESIGN
Report design works very much like a basic spreadsheet program. Move to a cell and enter the
text, numeric data, or a formula in the cell. The menu allows you to save, retrieve, print, format,
etc. the spreadsheet in any manner you like.
Use the Locate menu option to place BOD Analyst software data into the spreadsheet.
Locate/Sample places daily values for a selected sample in the spreadsheet at the current cell.
When the report date range is changed the data is automatically updated to reflect the new date
range.
8.1.2 SPREADSHEET NAVIGATION
Primarily, the mouse is used to move around the spreadsheet. To move to a cell (i.e. make it the
active cell) simply click on that cell. To select a block of cells, click on a cell and drag the mouse
to select multiple cells (selected cells appear in black). With a block of cells selected, you can
then change the font, border, color, etc. of all selected cells with a single command.
The following table displays the keystrokes used to move in the spreadsheet.