The day-month format requires the entry of three header lines followed by 31 of lines of daily data, with one column per month of the year. It is useful for entering daily data from one station, for one parameter, for one year.
Header Block
Line 1: Keyword, File description
Line 2: Station_ID, Time, Year, PCode, CCode, Mult
Line 3: Column headings over the day column and month columns.
Line 1: The keyword that describes the format of this file: TABULAR.
The file description is a single line of text used to describe the contents, purpose, and/or origin of the file. It’s contents can be anything defined by the user.
Line 2: Station_ID is the station identifier associated with this entire dataset. The Station_ID must be present in the WRDB STATIONS Support table. If data from more than one station are to be input, they must be placed in separate input files. The governing rule is: one file, one station.
Time is the time of day (standard time) assigned to all samples/readings in one of the following forms:
hh:mm, h:mm, hhmm, hmm, hhmmss, hmmss, hh:mm:ss AM, h, hh
Year is in the form: xxxx (for example, 1996).
PCode is any valid PCode (parameter code) found in the WRDB PCODES Support table used to designate the parameter appearing in the data block below. For example, to designate that the data block contains dissolved oxygen values, enter the PCode of "DO" here.
CCode (compositing code) must be found in the WRDB CCODES Support table and will be applied to all values appearing in the table below.
Mult is numeric multiplier to be applied to all values in data block below. In addition to simple multipliers, the following special keywords are recognized:
blank no multiplier or multiplier is 1.0
C2F convert degrees C to degrees F
F2C convert degrees F to degrees C
COEF2C convert degrees F to degrees C after multiplying by 0.10 (needed for special files created by Corps of Engineers monitors)
Line 3: These column headings are used to verify that the correct number of months are being entered in the correct order and act as column headings. Typically enter:
DAY JAN FEB MAR APR..... DEC
Data Block
The table of daily data appears starting on the 4th line, and 31 data lines must be present; all data lines after the 31st are ignored. For months having only 28, 29, or 30 days, the user should place blanks in the unused cells at the end of the month.
The first column in the data block should be the day of the month. Columns 2 through 13 of the data block contain data corresponding to January through December. When entering values in the month columns, the following special provisions apply:
<x.xx non-detect value, where the detection limit is specified as x.xx. There should be no space between the < and x.xx or DBCONV will consider them to be in different columns.
< or ND non-detect value, where the detection limit is taken from the WRDB PCODES Support table.
>x.xx data exceeded some maximum value for that parameter. The maximum value is specified as x.xx. There should be no space between the < and x.xx or DBCONV will consider them to be in different columns.
NA or N/A skip this value. Upper or lower case are allowed. Blank entry also skips the value. Note that blank cells are not allowed in space-delimited files, but they are allowed if comma or tab delimiters are used. To be safe, always explicitly indicate that a reading is to be skipped using NA or N/A.
See also Example of Day-Month Format.