YSI BODAnalyst - Manual (Page 46)

Reports Section 8
YSI Incorporated BOD Analyst for Windows Software 42
8.2 EDIT MENU FUNCTIONS
To cut numbers, data values or text within the currently selected cells to the clipboard, use Cut
from the Edit menu. Formulas and format settings will NOT be cut. Data values that have been
cut from cells containing formulas will reappear the next time the spreadsheet calculates itself. In
order to remove formulas along with their resulting values or to reset cell formatting, use Clear
on the Edit menu instead of Cut. See Copying Data and Moving Data for more information.
Use Copy to copy currently selected numbers, results of functions (data values) and text to the
clipboard. Formulas and formatting will NOT be copied. In order to copy formulas along with
their resulting values or to copy cell formatting, use the method explained in Copying Data and
Moving Data.
Paste places items in the clipboard to the current cell. If the data in the clipboard originated in a
range of cells, it will be pasted in a similar range of cells. For example, if text was copied from
three rows and two columns, it will be pasted into three rows and two columns using the currently
selected cell as the upper left-hand corner.
Edit, Clear removes all data, formulas, and formatting from the currently selected cells.
To force the report to recalculate, select Calculate from the Edit menu. Calculation of the report
occurs automatically when the report is opened or saved, after a formula is entered or edited and
immediately prior to printing.
Formulas may be edited in a number of ways. First select the cell with the formula to be edited.
Then do one of the following:
•
Click the mouse pointer into the Formula Edit Box.
•
Select Formula on the Edit menu.
•
Press the F4 function key.
Edit the formula as needed.
Insert Row inserts an entire row above the current cell. All formulas are automatically adjusted.
Insert Column inserts an entire column before (to the left of) the current cell. All formulas are
automatically adjusted.
Use Edit, Delete Row to delete the current row and Edit, Delete Column to delete the current
column.
8.3 LOCATING DATA ON THE REPORT
8.3.1 LOCATING DAILY DATA
Locate, Sample is used to place daily sample values on the spreadsheet. It builds a formula that
the spreadsheet uses during calculations to retrieve data from the BOD Analyst software database.
It places the column starting at the current cell. When Locate, Sample is selected the following
dialog appears: