First we are going to type the title of the report.  Simply move to a cell and type.  If the text does not fit in the cell, text will wrap into the next cell providing that the next cell is empty.

1. Move to Cell E2 and type: “Monthly BOD/TSS Report”

2. Click on Cell B7:

3. In the menu bar select: Locate, Daily Values.  The Locate Variable Formula window opens:

4. Select Variable “1 Influent Flow” and click the  button.

5. Check Place Date beside Data and click OK. 

Data will be placed on the report for the currently selected month (Jan 2009):

 

6. Change Report Dates. 

Use the Date Picker to scroll to Jan 2009.  Use the  button, or click on the displayed date  button to pick the month from a list.  The data for the month of January will now be on the report.

 
 

7. Locate other variables. Now we will locate several variables.  Referring to the list below, move to the cell indicated and select Locate, Daily Values.  Choose the variable and click OK.

Cell: D7   Variable: 11 - Inf BOD 
Cell: E7   Variable: 41 - Inf TSS
Cell: F7   Variable: 4011 - Eff BOD 
Cell: G7   Variable: 4041 - Eff TSS
 

8. Printing and Page Layout Settings:  To view and edit the printing options select Sheets, Properties.  Set the orientation to landscape.  NOTE: The page orientation MUST be set here, using the printer settings in Windows will not work.  Click OK to save the settings:

9. Save the Report and Exit.  Select File, Save.  Enter “Monthly BOD/TSS” and click OK.

10. Click File, Exit to exit Spread Reports.

You have just set up a simple report.  
 

In Lab 2.2.3 you will learn how to add summary statistics and formulas to improve this report. 

Next>