Lake Buoy Data
Lake buoy data for 2000-2003 are stored in the 'buoy_all' table of buoy_data.mdb.
The buoy_all table was created by appending linked excel worksheets stored in the /buoy subdirectory. Each worksheet contains results for a given year and depth.
A 'level' field is added to indicate the nominal buoy depth (2, 6, 12, 15 m).
Each excel table is assigned a named range of the form 'depth_x' where depth = 2 , 6, 12, 15 and linked to the access database.
To help access recoginize the field type, each numeric field in each sheet should be formated as a number in excel. The number of decimal places doesnt matter.
If the first row of data is blank in a given sheet, it is sometimes necessary to add a dummy row with numeric values in order to force access to recognize the field as a numeric data type. The corresponding record can be flagged (see below) so that the results won't appear in the query output. See the 2-meter depth sheet in buoy-2003.xls for example.
The append queries used to copy each worksheet into the 'buoy_all' table are provided. These queries were run in sequence, starting with an empty 'buoy_all' table.
Follow these templates to add future data.
If the 2000-2003 data are edited in the excel files, the corresponding records in the buoy_all table should be deleted and the corresponding append query repeated to put the edited records back into the database.
The linked excel file 'buoy_flags' allows flagging of data to restrict appearance in query output.
The buoy_pivot_tables.xls file generates cross-tabs and graphs of buoy data. It works one year at a time using data from the 'master_filtered' query of buoy_data.mdb. The structure and operation are similar to pivot_tables.xls .
The 2000-2003 buoy data have not been screened.
