Excel Template Bill - Excel

Document Sample
Excel Template Bill - Excel Powered By Docstoc
					   NARSTO Template Instructions                        Page 1 of 109                                            2/3/2011


                           The NARSTO Atmospheric Measurements Template - Instructions
    Template date: 2005/04/29 (Version 2.302)
    This Instructions worksheet was last updated: 2005/04/29
1.  Introduction
1.1 This template is used by a number of data collection and quality assurance centres (QACs). The current list of
    centres is as follows:
    - NARSTO: Quality Systems Science Center (QSSC), Oak Ridge National Laboratory
    - NAtChem: Meteorological Service of Canada, Environment Canada
    - WDCA: Global Atmosphere Watch - World Data Centre for Aerosols, Ispra, Italy

1.2a The Data Exchange Standard (DES) template is designed to help data originators create DES files. When the
     template has been filled in with metadata and data, a copy is saved in ASCII CSV (comma-separated values)
     format. The ASCII file is the final storage format for the archive. The ASCII file(s) are submitted to the QAC, where
     they are run through a set of quality assurance tests. The QAC provides the results of the QA tests (and some
     QACs also provide statistical summaries and time series plots) to the data originator. The data originator reviews
     the reports, makes corrections as needed, and resubmits the file(s) to the QAC. After a final check, the ASCII file(s)
     becomes the master copy of the data and are placed in the archive.


1.2b The latest version of this template will be available from the NARSTO QSSC (see link near end of instructions).
     However, if you are already using Version 2.212 or later, it is not necessary for you to retrofit the latest version to
     files or installations for which you have already set up the template. When feasible, especially If you are setting up
     for a new season or a new instrument or installation, please obtain and use the latest version. This is especially
     important because an in-use template may have some key phrases deleted that need to be included in the new
     type of file. The "Template history of changes" worksheet will help you see what has changed from the older to the
     current version.

1.3 This Workbook contains multiple worksheets. The worksheet titles are listed in tabs at the bottom of the window.
    We suggest you review the worksheets, especially the examples. Contact your QAC for more examples if needed.
    You may wish to print the following worksheets:
    - Instructions
    - Frequently Asked Questions
    - Worksheets starting with the characters val_. These worksheets contain the pick-lists for the key characteristics
    and a few other fields.
    The Excel comment boxes may be printed by clicking on File, Page Setup, and the Sheet tab and choosing the
    appropriate item from the "Comments:" picklist.

1.4 Key characteristics are a set of descriptive key phrases in the main data table, beginning with *TABLE COLUMN
    OBSERVATION TYPE. These are intended to allow data users to identify data in which they are clearly not
    interested, vs. data in which they might be interested after further investigation of details of sampling, methodology,
    etc. The worksheet titled Detailed metadata contains a possible layout and content of a companion detailed
    metadata document. To use this layout, copy and paste the detailed metadata worksheet to a Word document
    using Paste Special as unformatted text and complete the appropriate sections for the dataset(s). This file, or an
    SOP or similar document with the essential descriptive information, must accompany the data files. It provides
    critical information for data users so that they can determine whether the data are useful for their purposes and so
    they can use the data appropriately. The final version would ideally be provided by the data originator in PDF format
    (PDF-A format when it becomes available).

1.5 This template, with its comments and other advice, replaces the former NARSTO Data Management Handbook,
    which is no longer available. The last handbook revision (Rev. Ed. 2b, February 4, 2000) lacks many
    enhancements to the Data Exchange Standard and the template.
   NARSTO Template Instructions                        Page 2 of 109                                             2/3/2011



1.6 The template is easiest to complete when using a screen resolution of 1024x768 or higher. A README.TXT file will
    be available from the QAC that explains to data users how to use and interpret the Data Exchange Standard ASCII
    CSV files. This README.TXT file should accompany data files when they are sent to data users.


1.7 Optional vs. mandatory key phrases are indicated in comments or in this part of the instructions. The first part of
    the template is the "header" section, down to but not including the first *TABLE NAME key phrase. In the header
    section, the comment in Column B indicates whether each key phrase is mandatory or optional. In the two included
    metadata tables (NARSTO standard flags, and Site information), and in any other metadata tables that a provider
    may insert, all eight of the key phrases shown (including *TABLE BEGINS and *TABLE ENDS) are mandatory
    except for *TABLE COLUMN MISSING CODE, which is mandatory if any entries are missing. The last table is the
    "main data table." Here, the comment in Column A for each key phrase indicates whether the key phrase is
    mandatory or optional.
1.7a After making yourself a master copy of the full template as the source for creating other files and types of data,
     rows with unneeded key phrases may be deleted. To do this, follow the directions below on how to delete a row.
     However, be sure not to use templates with such deletions later as the starting point for files for different kinds of
     data. Instead, use your master copy after checking to be sure it is the latest version.

1.8 Optional vs. required fields in the Site information table are indicated in comments provided with each TABLE
    COLUMN NAME value in this table. Optional fields for which you don't want to provide values can be given missing
    values ("Not applicable" can be entered for character fields), or alternatively they can be carefully deleted following
    the instructions below on how to delete a column within a table.


2.  Using MS-Excel
2.1 For MS-Windows users, the default date and time format needs to be changed to the ISO format on every
    computer used to create Data Exchange Standard files, as follows:
    Windows 2000 instructions:
    a) On the Windows desktop, click on Start, Settings, Control Panel
    b) Click on Regional Settings
    c) Click on Date
    d) In the "Short date style" field, enter yyyy/mm/dd
    e) Click OK, and under Regional Settings, click on Time
    f) In the Time style field, enter hh:mm:ss tt (this causes the hour to display leading zeros. E.g., 08:00)
    g) Click OK.
    Windows XP instructions:
    a) On the Windows desktop, click on Start. Click on Control Panel, or on Settings, Control Panel
    b) Click on Regional and Language Updates
    c) Click on Customize. Click the Date tab
    d) In the "Short date format" field, enter yyyy/MM/dd
    e) Click OK, then click Customize, and click the Time tab
    f) In the Time format field, enter HH:mm:ss
    g) Click OK

2.2 Excel 97, 2000, 2002, and 2003 worksheets are limited to 256 columns and 65,536 rows. To allow room for the
    inserted QAC section, users should limit files to 65,400 or fewer rows. Many high data volume measurements such
    as those made on aircraft and by Lidar will not conveniently fit within those limitations. One option is to create the
    Data Exchange Standard file using other software, and insert warning comments in the header; contact the
    NARSTO QSSC for standard warning comments. Other options may be discussed with the QSSC.
   NARSTO Template Instructions                        Page 3 of 109                                             2/3/2011



2.3 Many of the cells in the template have instructions and examples stored in comment fields. These are indicated by
    a red flag in the upper-right corner of a cell. To display a comment, move the cursor over a cell with a red flag. The
    Frequently Asked Questions worksheet also contains helpful information.

2.4 A validation list in Excel is a drop-down selection list from which a selection can be made to enter a value into a cell.
    In the template, cells with validation lists are highlighted in yellow. When the cursor is placed in such a cell, a down-
    arrow icon appears to the right of the cell. Clicking on the down-arrow displays the validation list from which an entry
    may be selected. Validation lists are stored in worksheets in this workbook with names starting with val_. If the cell
    is too narrow to display the complete text width in the validation list, either increase the cell's column width
    temporarily or refer to the appropriate worksheet to view the entire text. Please co-ordinate with the relevant
    Quality Assurance Center to request additional entries in validation lists. The entry Pending assignment is
    available in most validation lists for temporary use as a place holder in cases where further investigation is needed
    by the data originator to determine the correct entry, or where the QAC needs to be contacted to add a new entry to
    a validation list.

2.5a Use the Insert Rows option to create space for records in tables, or to add key phrases. Do not use the Insert
     Copied Cells option as this causes misalignment of the validation lists.

2.5b To insert one or more columns into a table within the file, the Insert Columns option should not be used as this
     may affect data in other tables Instead, in the worksheet you will use the Cut/Paste option to move multiple
     columns over to the right to open up space for your columns. (1) Make a copy of the workbook in case things go
     wrong. (2) Identify and note the top and bottom working rows in the table within which you want to insert columns
     (normally from the *TABLE NAME through the TABLE ENDS key phrases), the "working column" letter (this is the
     current column to the right of where you want to insert columns), and the letter for the rightmost column in the table
     that contains information. (3) Click on the cell for the top working row and the rightmost column with information.
     (4) Scroll to the left, so the working column is on screen. (5) While holding the Shift key down, click in the cell for
     the top working row in the working column. All cells in this row to the right will be highlighted. (7) Scroll down to the
     bottom working row. {Continue as below}

2.5c (8) While holding the Shift key down, click in the cell for the bottom working row in the working column. Now all the
     material in the table to the right of where you want to insert columns should be highlighted. (9) Click Edit, and left-
     click "Cut". You should see moving dashes around the border of the selected area. (10) Move the cursor to the top
     working row, and identify the column (which may be in the highlighted area) which contains the cell which will
     become the new upper-left corner of the highlighted material. This choice determines how many columns will be
     opened up. Click in that cell. (11) Click Edit, Paste. (12) One or more new columns will be available within the
     table. Note that these new columns will not have picklists. (13) Check to be sure all the material you started with is
     still present.

2.5d To delete a row, such as one with an unneeded key phrase, select the entire row by clicking on the row number at
     the left of the spreadsheet. Click Edit, then Delete. To delete a column within a table, click on the top cell in the
     column within the table. Scroll to the end of the table, hold the Shift key down, and click the bottom cell in the
     column. The column in the table should be highlighted. Click Edit, Delete. In the Delete dialog box which appears,
     be sure the "Shift cells left" choice is selected, and click OK.
   NARSTO Template Instructions                       Page 4 of 109                                            2/3/2011


2.6 When opening a data exchange standard file stored as an ASCII CSV file, the default column width may not be
    sufficient to display all of the text in a column. The following steps should be followed to adjust the columns' widths:
    1. Double-click on the right border of column heading "A" appearing at the top of the worksheet. This will widen
    column A to display all of the key phrases appearing in the file.
    2. Go to the row in the main data table containing the key phrase *TABLE COLUMN NAME. Place the cursor In
    column B and highlight down to the end of the TABLE COLUMN key phrases, and then to the last column by
    holding down the left Shift and Ctrl keys while pressing the right arrow key. Select from the Excel toolbar Format,
    Column, AutoFit Selection.
    3. Adjust any column widths manually as needed by moving the cursor to the right border of the column heading
    that appears at the top of the worksheet, and dragging the border wider or shorter.


2.7 When entering information in a table, the Freeze Panes feature of Excel can maintain the view of the table key
    phrases and column names as you scroll to the right and down. Move the cursor to the second row of the *TABLE
    COLUMN section in the main data table, and to column B. Scroll up so that the cursor is on the second visible row
    of the screen (unless you want to include more rows in the "frozen" headers). Click on Window, Freeze Panes. To
    remove the Freeze Panes (which is necessary to be able to move higher in the table), click on Window,
    Remove Freeze Panes.

3.  Using the template
3.1 Obtain the latest version of the template at the time you are ready to start entering data. The template is available
    from the relevant QAC.

3.2 Once you begin using the template in Excel, we strongly suggest you maintain your master copy in Excel rather
    than as a .csv file. Certain formatting, such as the number of decimal places or even the existence of a decimal
    point when there are trailing zeros, is altered when a .csv-format file is opened with Excel's default mechanism.
    This should not be a problem when data are copied into a formatted part of an Excel worksheet (see further below
    in this section). Consider using the template from the beginning of the data management process, as this may
    reduce the number of times data must be copied. Please be especially careful while copying data from
    external sources to the template. It is very easy to copy data to the wrong column. We suggest you double check
    every column in the template with the original data to confirm that each row was copied correctly.



3.3 Every regular measurement needs to have an associated NARSTO standard flag. "Dimensional" variables (those
    that indicate the setting for measurements, such as site, date, time, altitude, etc.) are assigned *TABLE COLUMN
    OBSERVATION TYPE of "Supplementary data"; these should not have flags. The NARSTO standard flags are
    documented in the template. In cases where it makes more sense to have one flag apply to an entire row of data,
    the variable name "Flag: sample-level" may be used to store the flag (see the "Sample-level flags" worksheet). If
    a network or study has its own set of detailed flags, these may also be included in the file.


3.4 The key phrase *TABLE COLUMN NAME TYPE identifies whether the column contains the primary value
    (type="Variable"), or an associated value such as a flag or statistic. Most of the *TABLE COLUMN measurement
    characteristics key phrases' values appearing in the column with the primary value (i.e., in the column with
    *TABLE COLUMN NAME TYPE="Variable") should be copied to the associated columns. (See the Example
    worksheets.)
   NARSTO Template Instructions                       Page 5 of 109                                           2/3/2011


3.5 The NARSTO QSSC maintains a list of standardized variable names for non-chemical variables, and lists of
    chemicals that have or do not have CAS numbers. These may be obtained from the relevant quality assurance
    center. The WEB Links section in this instruction sheet lists sites where standard names and CAS-9CI
    identification numbers can be obtained for chemical variables.

3.6 Redundancy in the date/time fields is designed to prevent many of the problems encountered in the past. Sample
    dates and times must be reported in two formats: (1) local time (either clock time or standard time for the local
    time zone), and (2) Coordinated Universal Time (UTC). In addition, the local time coordinates (i.e., time zone) is
    specified on every record. Start time must be reported as time at the beginning of the averaging period. End time
    must be reported as the time at the end of the averaging period. End time for a sample can and should equal the
    start time for the next sample when samples are continuous. A formula is provided in the main data table of the
    template for converting dates and times to UTC.


3.7 A file may contain only one "main" table, which must be last, but it may contain multiple "metadata" tables such as
    site information, flag definitions, or uncertainty information. Note that your additional metadata tables need to
    contain the eight key phrases in the metadata tables included in the template. User provided metadata tables may
    also include any of the key phrases that are in the main table that are needed to explain the data. You may create
    additional metadata tables as needed, ahead of the main table. Be sure to use the main table (the 3rd table in
    the template) for the main measurements in the file.


3.8 If a key characteristic needs further investigation to determine the correct entry, you may temporarily use the entry
    "Pending assignment" as a placeholder. This acts as a reminder that information is needed in the cell.


3.9 No invalid values are to be contained in Data Exchange Standard files. Convert any invalid values to the
    missing value code for that variable, and use the M1 or M2 flag.

3.10 Although values for key phrases will usually be constant from data row to data row, values for a few key phrases
     could vary. For example, *TABLE COLUMN SAMPLING HEIGHT ABOVE GROUND (M) will vary from row to row
     for aircraft data. Likewise, key phrases for particle diameter or for wavelength may vary among rows for some
     data layouts. See the "Frequently Asked Questions" worksheet for guidance about mobile sources and for
     guidance about what to do when key characteristics vary.


3.11 Some of the *TABLE COLUMN key phrases are highlighted with a cyan background colour. These key phrases
     together must uniquely define a column in the table. In any one column, the combination of cyan-colored key
     phrases must be different from the combination of these in all other columns in the table. In special circumstances
     this will not seem possible to do. See the "Frequently Asked Questions" worksheet for documentation of four
     additional key phrases which are available when needed to differentiate among columns: *TABLE COLUMN
     BASIS, *TABLE COLUMN GROUP CODE, *TABLE COLUMN BIN, and *TABLE COLUMN BIN BASIS.
   NARSTO Template Instructions                        Page 6 of 109                                            2/3/2011


3.12 Do not use double quotation marks ("), because the .csv archive format uses this character as a structural part of
     the .csv file. Replace double quotation marks with single quotation marks ('). In the template, use only 7-bit
     printable ASCII forms of the characters shown in the *STANDARD CHARACTERS string. This excludes
     superscripts, subscripts, umlauts, the ellipsis character (in Word, can be replaced with two dots), left- and right-
     handed quote marks, and other 8-bit characters. When performing a copy/past from a source document to an
     explanatory field in the Excel template, use the "Paste Special" option, and select "Text". This will prevent some
     non-standard characters from being copied into the template. Be especially careful to convert any remaining 8-bit
     ASCII characters to 7-bit characters, and convert double quotation marks to single quotation marks. This can be
     done manually in Excel, or with an ASCII text editor. After doing this, if ###### marks appear in the cell, reformat it
     to "General" format."
     Elaborate formatting can be used in companion files, which can be in Word, Adobe PDF, or preferably Adobe
     PDF/A format (when available).


3.13 Text (explanatory) fields (character-format fields) should start with an alphabetic character, not a number or an
     arithmetic operator. Otherwise, some spreadsheet programs may mishandle the field. Leading spaces before
     character variables count as part of the width specification, and should be avoided. We don't believe that leading
     spaces before numeric values, nor trailing spaces after any values, should cause problems when .csv-format files
     are read. From the standpoint of file size, we recommend that leading and trailing spaces be suppressed.




3.14 Format numeric columns in the main data table to the proper (and specified) number of decimal places. If data
     from multiple sites are presented within a file, we suggest the data rows be sorted by site, and by date within site. If
     site, date, and time values repeat within a file, we suggest you consult with your QAC about preferred ways to
     indicate what makes rows distinct.


3.15 Name the file appropriately. Consult with your project/study Data Manager for file naming guidance. If your
     project/study does not have a Data Manager, please follow advice on the NARSTO Quality Systems Science
     Center (QSSC) Web site (URL below).

4.  After Completion
4.1 If this is your first time filling out a DES template we suggest sending the first completed or partially completed
    template to the relevant QAC for review to ensure it is being filled out correctly.

4.2a When exporting a worksheet to an ASCII CSV file, extra commas will be inserted at the end of rows, up to the
     number of columns in the longest row. The extra commas will not cause any problems for the QAC. Remember to
     update the information in the key phrases *DATE THIS FILE GENERATED/ARCHIVE VERSION NUMBER and
     *DATE OF LAST MODIFICATION TO DATA IN MAIN TABLE if needed. (Excel should update the file generation
     date automatically; the other information may or may not need to be updated according to guidance from your
     QAC). Save a copy of the spreadsheet in a .CSV file when the file is ready to be sent to the QAC. Note that the
     .CSV ASCII file will lose all of the Excel comments and links to the validation lists, so do not use the Excel
     comments in your data files. The key phrases *COMMENT, *TABLE USER NOTE, and *TABLE COLUMN
     USER NOTE can store comments.
4.2b If you are creating the archival .csv file using other software, remember to surround any field that contains an
     internal comma with double quotation marks. Double quotation marks may not be used anywhere else within a
     Data Exchange Standard .csv file.
   NARSTO Template Instructions                       Page 7 of 109                                            2/3/2011


4.2c Be sure that all of the numeric columns in the main data table are formatted to the proper number of decimal
     places, and that dates and times are formatted as yyyy/MM/dd and hh:mm (or hh:mm:ss tt). We recommend
     formatting all text cells as general rather than as text. This allows longer text strings and appears to avoid
     conversion of long text strings to the "#" character.

4.3 Finally, review the completed template and any associated files (e.g., a detailed metadata report, SOPs) to
    ensure sufficient metadata have been provided to allow data users to interpret your data correctly. Consider the
    following questions:
    a) are values below the Detection Limit (DL) identified with the flag V2 if they are considered nonetheless
    meaningful, V1 if the PI lacks confidence in it but presents/uses the measured value(s) anyway, or (discouraged)
    V7 if the PI insists on substituting the DL itself for the measured value? Are the DLs presented in the detection limit
    key phrase, in the metadata, as a metadata table, or as columns in the main data table? Information on
    representing below detection limit values is provided on the NARSTO QSSC web site in the document "US EPA
    PM Supersites Data Reporting Conversions Guidance".
     b) are descriptions of special numbers (e.g., negative or zero concentrations), of detection limit protocols, of
     uncertainty, and of derivation methods provided in the appropriate key phrases in the main data table?
     c) are there records for every sampling frequency/period in the main data table (i.e., if a sampler making hourly
     measurements malfunctioned for 5 hours, are those 5 hours present in the file with the flag M1 applied to each of
     the measurements)? Explanations for large data gaps should be provided in the metadata.
     d) have the columns in the data section of each table been formatted? (i.e., date=yyyy/MM/dd, time=hh:mm,
     numerical fields entered with the appropriate number of decimal places.)

     e) have the key phrases DATE OF LAST MODIFICATION TO DATA IN MAIN TABLE and DATE THIS FILE
     GENERATED/ARCHIVE VERSION NUMBER been updated if needed?


5.  Web Links
5.1 NARSTO Quality Systems Science Center (QSSC) has tables of standard CAS-9CI names and CAS registry
    numbers for routinely measured atmospheric chemicals -
    http://cdiac.ornl.gov/programs/NARSTO/epasupersites.htm
5.2 Search for CAS-9CI names and CAS registry numbers - http://www.epa.gov/srs/

5.3 IUPAC standard name and CAS registry number site for Polycyclic Aromatic Compounds (including Polycyclic
    Aromatic Hydrocarbons) - http://ois.nist.gov/pah/

5.4 Search for CAS-9CI names and CAS registry numbers - http://chem.sis.nlm.nih.gov/chemidplus/

5.5 Search for CAS-9CI names and CAS registry numbers - http://www.cas.org/

5.6 Search for CAS-9CI names and CAS registry numbers -http://chemfinder.cambridgesoft.com/

5.7 Contact the NARSTO QSSC if you need assistance with standard names and CAS numbers.
   NARSTO Template Instructions                      Page 8 of 109                                           2/3/2011


5.8 NARSTO Quality Systems Science Center (QSSC)
    http://cdiac.ornl.gov/programs/NARSTO/narsto.html
    Notes:
    a) The NARSTO Data Management Handbook has been replaced with this template.
    b) This site contains a compendium for state-of-the-art atmospheric measurement techniques for ozone, ozone
    precursors, aerosol precursors, particulate matter, and meteorological variables.
    c) The section "Data and Information Sharing Tool" describes a system called
    Mercury (a.k.a. Beija-flor), which is a Web-based system to search for metadata and retrieve associated data.

5.9 NARSTO Home Page - http://www.cgenv.com/Narsto/
     Note: See the section "WWW links" for links to environmental agencies and studies.
5.10 1999 Southern Oxidants Study - http://www2.ncsu.edu/ncsu/CIL/southern_oxidants/
5.11 The EPA Quality System web site - http://www.epa.gov/quality1/
5.12 The EPA Ambient Monitoring Technology Information Center http://www.epa.gov/ttn/amtic/ See the PM
     Supersites section for examples of Quality Assurance Project Plans.



                        The Reason for Including Metadata In Research Data Sets
          As an atmospheric researcher, consider the needs of the future researcher who, in 10 years time, must
          decide whether or not to use your archived data. The expert will have to determine whether the data are
          suitable for a research activity, which might involve any of the following:
          - comparing your data to other researchers’ data collected at the same location and time,
          - merging your data with data from other sites to investigate spatial patterns and variability,
          - selecting the most accurate of several data sets collected at the same location and time,
          - comparing your data against more recent data to look at the temporal changes,
          - using your data to evaluate model predictions.
          Let us assume that the researcher is not able to talk to you directly, and has access only to your data and
          supporting information. The question is, “What information would this future researcher need to have
          available, besides the actual data values, to make a proper judgement about the suitability of your data for
          use in his/her research?”
     Master Template - Atmospheric Measurements                                                                                                                                                                 Page 9 of 109


                           A                                                            B                                                C                     D                   E                    F   G
 1   *DATA EXCHANGE STANDARD VERSION                NARSTO 2005/04/29 (2.302)
 2   *COMMENT                                       Further instructions on how to fill in this template are provided at:
 3   *COMMENT                                       http://cdiac.ornl.gov/programs/NARSTO/narsto.html
 4   *QUALITY CONTROL LEVEL
 5   *DATE THIS FILE GENERATED/ARCHIVE VERSION NUMBER                                                                 2/3/2011 1
 6   *ORGANIZATION ACRONYM
 7   *ORGANIZATION NAME
 8   *STUDY OR NETWORK ACRONYM
 9   *STUDY OR NETWORK NAME
10   *FILE CONTENTS DESCRIPTION--SHORT/LONG
11   *PRINCIPAL INVESTIGATOR NAME--LAST/FIRST
12   *PRINCIPAL INVESTIGATOR AFFILIATION
13   *CO-INVESTIGATOR NAME--LAST/FIRST
14   *CO-INVESTIGATOR AFFILIATION
15   *COUNTRY CODE
16   *STATE OR PROVINCE CODE
17   *SAMPLING INTERVAL AS REPORTED IN MAIN TABLE
18   *SAMPLING FREQUENCY OF DATA IN MAIN TABLE
19   *PRINCIPAL INVESTIGATOR CONTACT INFORMATION
20   *DATA USAGE ACKNOWLEDGEMENT
21   *NAME AND AFFILIATION OF PERSON WHO GENERATED THIS FILE
22   *DATE OF LAST MODIFICATION TO DATA IN MAIN TABLE
23                                               1
     *FILE CHANGE HISTORY--VERSION NUMBER/DESCRIPTION                                                                         First archived version
24   *NAME AND VERSION OF SOFTWARE USED TO CREATE THIS FILE
25   *STANDARD CHARACTERS                           !#$%&'()*,-+=[]|./0123456789:;<>?@ ABCDEFGHIJKLMNOPQRSTUVWXYZ\^_`abcdefghijklmnopqrstuvwxyz{}~
26   *COMPANION FILE NAME/FORMAT AND VERSION        None                                                                      Not applicable
27
28   *TABLE NAME                                    NARSTO standard flags
29   *TABLE FOCUS                                   Metadata
30   *TABLE COLUMN NAME                             Flag: NARSTO                                                              Description
31   *TABLE COLUMN UNITS                            None                                                                      None
32   *TABLE COLUMN FORMAT TYPE                      Char                                                                      Char
33   *TABLE COLUMN FORMAT FOR DISPLAY               2                                                                         120
34   *TABLE BEGINS
35                                                  V0                                                                        Valid value
36                                                  V1                                                                        Valid value but comprised wholly or partially of below detection limit data




                                                                                    8b1eec91-a769-443a-abf1-7ecbe2b79b10.xls, Template
     Master Template - Atmospheric Measurements                                                                        Page 10 of 109


             H                I               J   K        L              M             N                  O   P   Q        R
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36



                                                      8b1eec91-a769-443a-abf1-7ecbe2b79b10.xls, Template
     Master Template - Atmospheric Measurements                                                                Page 11 of 109


          S           T       U      V     W      X   Y     Z     AA
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36



                                                          8b1eec91-a769-443a-abf1-7ecbe2b79b10.xls, Template
     Master Template - Atmospheric Measurements                                                                                                                                                               Page 12 of 109


                            A                                               B                                     C                     D                    E                  F                     G
37                                                   V2                                                Valid estimated value
38                                                   V3                                                Valid interpolated value
39                                                   V4                                                Valid value despite failing to meet some QC or statistical criteria
40                                                   V5                                                Valid value but qualified because of possible contamination (e.g., pollution source, laboratory contamination source)
41                                                   V6                                                Valid value but qualified due to non-standard sampling conditions (e.g., instrument malfunction, sample handling)
42                                                   V7                                                Valid value but set equal to the detection limit (DL) because the measured value was below the DL
43                                                   M1                                                Missing value because no value is available
44                                                   M2                                                Missing value because invalidated by data originator
45                                                   H1                                                Historical data that have not been assessed or validated
46   *TABLE ENDS
47
48   *TABLE NAME                                     Site information
49   *TABLE FOCUS                                    Metadata
50   *TABLE COLUMN NAME                              Site ID: standard                                                          Description
                                                                                                       Site abbreviation: standard                  Country code                            Latitude: decimal degrees
                                                                                                                                                                        State or province code
51   *TABLE COLUMN UNITS                             None                                              None                     None                None                None                decimal degree
52   *TABLE COLUMN FORMAT TYPE                       Char                                              Char                     Char                Char                Char                Decimal
53   *TABLE COLUMN FORMAT FOR DISPLAY                12                                                                       4 50                  50                  20                  10.5
54   *TABLE COLUMN MISSING CODE                      None                                              None                     None                None                None                -999.99999
55   *TABLE BEGINS
56
57   *TABLE ENDS
58
59   *TABLE NAME
60   *TABLE FOCUS                                 Surface--fixed
61   *TABLE EXPLANATION OF ZERO OR NEGATIVE VALUES
62   *TABLE EXPLANATION OF REPORTED DETECTION LIMIT VALUES
63   *TABLE EXPLANATION OF REPORTED UNCERTAINTY
64   *TABLE USER NOTE
65   *TABLE USER NOTE2
66   *TABLE KEY FIELD NAMES                       Site ID: standard                                                            Date start: local timeime start: local time
                                                                                                       Instrument co-location ID                    T
67   *TABLE COLUMN NAME                           Site ID: standard                                                            Date start: local timeime start: local time
                                                                                                       Instrument co-location ID                    T                    Date end: local timeTime end: local time
68   *TABLE COLUMN NAME TYPE                      Variable                                             Variable                Variable             Variable             Variable             Variable
69   *TABLE COLUMN CAS IDENTIFIER                 None                                                 None                    None                 None                 None                 None
70                                                Not
     *TABLE COLUMN EXPLANATION OF DERIVED VARIABLE applicable                                          Not applicable          Pending assignment   Pending assignment   Pending assignmentPending assignment
71   *TABLE COLUMN USER NOTE                      None                                                 None                    None                 None                 None                 None
72   *TABLE COLUMN USER NOTE2                     None                                                 None                    None                 None                 None                 None
73   *TABLE COLUMN UNITS                          None                                                 None                    yyyy/mm/dd           hh:mm                yyyy/mm/dd           hh:mm
74   *TABLE COLUMN FORMAT TYPE                    Char                                                 Char                    Date                 Time                 Date                 Time
75   *TABLE COLUMN FORMAT FOR DISPLAY                                                               12                       2                  10                     5                   10                     5



                                                                         8b1eec91-a769-443a-abf1-7ecbe2b79b10.xls, Template
              Master Template - Atmospheric Measurements                                                                                                                                                                                    Page 13 of 109


                          H                       I                   J                  K                    L                   M                N                        O                         P                       Q                     R
            37
            38
            39
            40
ory contamination source)
            41
ction, sample handling)
            42
            43
            44
            45
            46
            47
            48
            49
            50 Longitude: decimal degrees                    Sampling height above ground
                                       Lat/lon reference datum                                     Pressure: site ground Site
                                                                                Ground elevation: above mean sea level level land use      Site location setting
                                                                                                                                                               Measurement start date at site                    Co-incident measurements at site ID: study
                                                                                                                                                                                         Measurement end date at site                          Site
            51 decimal degree          None                  m (meter)          m (meter)          hPa (hectopascal)      None             None                yyyy/mm/dd                yyyy/mm/dd              None                          None
            52 Decimal                 Char                  Decimal            Decimal            Decimal                Char             Char                Date                      Date                    Char                          Char
            53 10.5                    120                   8.1                6.1                7.2                                  30 40                  10                        10                      300                           12
            54 -999.99999              None                  -99999.9           -99.9              -99.99                 None             None                9999/12/31                9999/12/31              None                          None
            55
            56
            57
            58
            59
            60
            61
            62
            63
            64
            65
            66
            67 Time zone: local        Date start: UTC       Time start: UTC    Date end: UTC      Time end: UTC          Variable '1'     Variable '1'        Variable 'n'              Variable 'n'
            68 Variable                Variable              Variable           Variable           Variable               Variable         Flag--NARSTO        Variable                  Flag--NARSTO
            69 None                    None                  None               None               None                   None             None                None                      None
            70 Not applicable          Pending assignment Pending assignment Pending assignment    Pending assignment                      Pending assignment
                                                                                                                          Pending assignment                   Pending assignment        Pending assignment
            71 None                    None                  None               None               None                   None             None                None                      None
            72 None                    None                  None               None               None                   None             None                None                      None
            73 None                    yyyy/mm/dd            hh:mm              yyyy/mm/dd         hh:mm                                   Pending assignment
                                                                                                                          Pending assignment                   Pending assignment        Pending assignment
            74 Char                    Date                  Time               Date               Time                   Decimal          Char                Decimal                   Char
            75                       6                    10                  5                10                       5                                    2                                                 2



                                                                                                     8b1eec91-a769-443a-abf1-7ecbe2b79b10.xls, Template
     Master Template - Atmospheric Measurements                                                                                              Page 14 of 109


           S              T            U       V         W       X             Y           Z     AA
37
38
39
40
41
42
43
44
45
46
47
48
49
50                  Lat/lon method
     Lat/lon accuracy                AIRS IDCity/town                  WDCA/GAW station type
                                                        CountyWMO region                  GAWID Comment
51   m (meter)      None             None None          None None      None               None None
52   Decimal        Char             Char Char          Char Char      Char               Char Char
53   7.1            50                   9 25           25           1                 1      6 120
54   -999.9         None             None None          None None      None               None None
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75


                                                                                        8b1eec91-a769-443a-abf1-7ecbe2b79b10.xls, Template
  Master Template - Atmospheric Measurements                                                                                                                                                 Page 15 of 109


                            A                                              B                                  C                  D                E                 F                 G
 76   *TABLE COLUMN MISSING CODE                   None                                              None                 None             None             None              None
 77   *TABLE COLUMN LOOKUP TABLE NAME              Site information                                  None                 None             None             None              None
 78   *TABLE COLUMN OBSERVATION TYPE               Supplementary data                                Supplementary data                    Supplementary data
                                                                                                                          Supplementary data                Supplementary dataSupplementary data
 79                                                PRINCIPLE
      *TABLE COLUMN FIELD SAMPLING OR MEASUREMENTNot applicable                                      Not applicable                        Pending assignment
                                                                                                                          Pending assignment                Pending assignmentPending assignment
 80                                                Not applicable
      *TABLE COLUMN PARTICLE DIAMETER--LOWER BOUND (UM)                                              Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 81                                                Not applicable
      *TABLE COLUMN PARTICLE DIAMETER--UPPER BOUND (UM)                                              Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 82   *TABLE COLUMN PARTICLE DIAMETER--MEDIAN (UM) Not applicable                                    Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 83   *TABLE COLUMN MEDIUM                         Not applicable                                    Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 84                                                Not applicable
      *TABLE COLUMN COATING OR ABSORBING SOLUTION/MEDIA                                              Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 85   *TABLE COLUMN WAVELENGTH (NM)                Not applicable                                    Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 86   *TABLE COLUMN WAVELENGTH--LOWER BOUND (NM) Not applicable                                      Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 87   *TABLE COLUMN WAVELENGTH--UPPER BOUND (NM) Not applicable                                      Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 88                                                Not
      *TABLE COLUMN SAMPLING HEIGHT ABOVE GROUND (M) applicable                                      Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 89   *TABLE COLUMN INLET TYPE                     Not applicable                                    Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 90                                                Not CONTROL
      *TABLE COLUMN SAMPLING HUMIDITY OR TEMPERATUREapplicable                                       Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 91   *TABLE COLUMN LABORATORY ANALYTICAL METHOD Not applicable                                      Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 92   *TABLE COLUMN SAMPLE PREPARATION             Not applicable                                    Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 93   *TABLE COLUMN BLANK CORRECTION               Not applicable                                    Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 94   *TABLE COLUMN VOLUME STANDARDIZATION         Not applicable                                    Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 95                                                Not applicable
      *TABLE COLUMN INSTRUMENT NAME AND MODEL NUMBER                                                 Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 96                                                Not applicable
      *TABLE COLUMN MEASUREMENT PRINCIPAL INVESTIGATOR                                               Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 97   *TABLE COLUMN DETECTION LIMIT                Not applicable                                    Not applicable       Not applicable   Not applicable   Not applicable    Not applicable
 98   *TABLE BEGINS
 99                                                                                                                               1/1/2000             8:00          1/2/2000                7:00
100   *TABLE ENDS
101




                                                                        8b1eec91-a769-443a-abf1-7ecbe2b79b10.xls, Template
  Master Template - Atmospheric Measurements                                                                                                                                                   Page 16 of 109


               H                    I                      J                 K                  L                   M                N                  O                    P             Q        R
 76   None                 None                    None               None             None                                   None                                 None
 77   None                 None                    None               None             None                   None                             flags
                                                                                                                              NARSTO standardNone                  NARSTO standard flags
 78   Supplementary data   Supplementary data      Supplementary data Supplementary data
                                                                                       Supplementary data                     Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 79   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 80   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 81   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 82   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 83   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 84   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 85   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 86   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 87   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 88   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 89   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 90   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 91   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 92   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 93   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 94   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 95   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 96   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 97   Not applicable       Not applicable          Not applicable     Not applicable   Not applicable                         Pending assignment
                                                                                                              Pending assignment              Pending assignment   Pending assignment
 98
 99   EST                               1/1/2000               13:00          1/2/2000                12:00
100
101




                                                                                         8b1eec91-a769-443a-abf1-7ecbe2b79b10.xls, Template
  Master Template - Atmospheric Measurements                                                                Page 17 of 109


       S           T       U      V     W      X   Y     Z     AA
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101




                                                       8b1eec91-a769-443a-abf1-7ecbe2b79b10.xls, Template
Frequently Asked Questions                        Page 18 of 109                                             2/3/2011


           Data
           Originator
           or Data
Date Added User          Question                    Answer

  2/18/2001 Data User    How do I read a CSV         Use a free-format read (asterisk) to input a CSV record.
                         file in FORTRAN?            FORTRAN requires character fields of varying length to be
                                                     surrounded by quotations. A Perl script is available that
                                                     reads a CSV file and places quotation marks around
                                                     character fields.
  2/18/2001 Data User    My programming              Use a spreadsheet to open up the file, and insert a row just
                         language does not           above the key phrase "*TABLE BEGINS". In column A,
                         allow variable names        insert the key phrase *TABLE COLUMN USER NAME (this
                         longer than X               end-user key phrase is not used in archived files). For
                         characters. How do I        each column, assign a name to the column. Reserve the
                         assign short variable       last 4 characters in the name for associated variables, such
                         names?                      as "_dt" for flag - detailed, "_fst" for flag - Standard, "_l95"
                                                     for Uncertainty--95% lower bound. Write your program to
                                                     detect this line, and use the values as variable names for
                                                     the columns. Alternatively, hard code these names in your
                                                     program. This approach is not as robust when you are
                                                     reading in multiple files, as the order of the variables may
                                                     change from file to file.

  3/23/2001 Data         How do I represent          Dates and times must not be missing in any record
            Originator   missing dates?              containing non-missing values in the main data table. For
                                                     metadata tables, use 9999/12/31 to represent missing
                                                     dates (e.g., For the field "Measurement end date at site", if
                                                     the measurements are ongoing, enter 9999/12/31. See
                                                     template comment on time start: local time for handling of
                                                     missing time values.

  3/23/2001 Data         How can I                   A formula for calculating UTC dates and times is provided
            Originator   automatically calculate     in the main data table of the template. The formula must be
                         UTC dates and times?        adjusted by entering the UTC offset for each site location.
                                                     See the Instructions sheet for details.

   4/2/2001 Data         I would like to record      NARSTO standard flags must always be provided with
            Originator   the flags used by the       measurement data. Study flags can also accompany the
                         network. Do I have to       data, and are identified by using the picklist value of
                         also record the             "Flag--study" for the key phrase *TABLE COLUMN NAME
                         NARSTO flags?               TYPE. A metadata table must be created to document the
                                                     study flags.
Frequently Asked Questions                      Page 19 of 109                                             2/3/2011


            Data
            Originator
            or Data
Date Added User          Question                   Answer
   4/2/2001 Data         The sampling               If the sampling interval and frequency change regularly, we
            Originator   frequency of our           suggest you identify the interval and frequency using the
                         measurements               terms Variable interval and Variable frequency,
                         changed from every 10      respectively. If they change infrequently, we suggest you
                         minutes to every 30        separate the different sampling periods into separate files.
                         minutes. How should I
                         record the sampling
                         interval and
                         frequency?
  5/22/2001 Data         I want to use scientific   In the *TABLE COLUMN FORMAT FOR DISPLAY, enter
            Originator   notation for some of       Ew., where w is at least 7. Your data values would then be
                         my data. How should I      entered with seven (or more, depending on w) characters
                         specify and format it?     as follows (also see examples below):
                                                    1. The sign of the value (blank if positive, - if negative). The
                                                    blank for positive values may be omitted in the file.
                                                    2. A single nonzero digit (1 through 9).
                                                    3. A decimal point.
                                                    (Optionally, there will usually be a few additional digits
                                                    following the decimal point, representing more precision for
                                                    the value).
                                                    4. A capital E.
                                                    5. A sign for the exponent (+ or -).
                                                    6-7. Two final digits (0 through 9) indicating the magnitude
                                                    of the exponent.
                                                    A main point to understand is that w minus 7 indicates the
                                                    number of digits to the right of the decimal point in the
                                                    displayed number.
                                                    (Continued below)
  5/22/2001 Data         Scientific notation        Scientific notation examples:
            Originator   (continued)                  E11. (w=11) would characterize this number:
                                                           -1.0437E-12
                                                      E9. (w=9) would characterize these numbers:
                                                           -3.42E+02 and 2.51E+12
                                                      E7. (w=7, the smallest allowed value) would characterize
                                                          -1.E+00
                                                    See the Excel comment on the *TABLE COLUMN
                                                    MISSING CODE key phrase in the template for advice
                                                    about selecting missing code values in scientific
                                                    notation.
Frequently Asked Questions                         Page 20 of 109                                            2/3/2011


            Data
            Originator
            or Data
Date Added User          Question                     Answer
  5/24/2001 Data         My data file has             A special "cyan" (see 3.11 in Instructions) key phrase,
            Originator   multiple, repeated           *TABLE COLUMN GROUP CODE, exists to handle this
                         measurements of the          (maximum of 20 characters). To avoid confusing the
                         same variable, each          majority of template users who don't need this, we have not
                         associated with two          built it into the template. If you need it, add this key phrase
                         accompanying                 to the others in your data table. It belongs with the colored
                         variables (lower and         key phrases.
                         upper wavenumbers).          Enter values of "Not applicable" for variables such as site,
                         Although the "*TABLE         date, and time information and other variables for which it is
                         COLUMN USER                  not relevant. Use values like "Group = 1", "Group = 2", etc.
                         NOTE sometimes               for each of the associated variables (including each
                         differs, none of the         variable's flag, uncertainty, etc.) that group together (that
                         colored key phrases          conceptually are part of the same measurement).
                         have values that differ      (Continues below)
                         for these. What
                         should I do?

  5/24/2001 Data         (Continued) My data           In this case, each group would consist of a lower
            Originator   file has multiple,           wavenumber column, an upper wavenumber column, the
                         repeated                     variable, its flag(s), and perhaps its uncertainty column.
                         measurements of the          The group contains the attributes (wavenumbers) that
                         same variable, each          explain why this group is different from other groups.
                         associated with two
                         accompanying                 For cases where a single variable repeats and no other
                         variables (lower and         colored key phrases differ, but there are not accompanying
                         upper wavenumbers).          explanatory variables such as wavenumber in the example
                         Although the "*TABLE         above, use the *TABLE COLUMN BASIS key phrase
                         COLUMN USER                  (explained below) to provide a brief explanation of what
                         NOTE sometimes               differs.
                         differs, none of the
                         colored key phrases
                         have values that differ
                         for these. What
                         should I do?
Frequently Asked Questions                        Page 21 of 109                                          2/3/2011


            Data
            Originator
            or Data
Date Added User          Question                    Answer
  9/24/2001 Data         My data file has            We may eventually define four different variable names for
            Originator   repeated                    this situation. However, until and unless this happens, a
                         measurements of the         special "cyan" (see 3.11 in Instructions) key phrase,
                         same variable,              *TABLE COLUMN BASIS, exists to handle this kind of
                         Organic fraction, with      situation (maximum of 30 characters). To avoid confusing
                         four fractions of           the majority of template users who don't need this, we have
                         increasing polarity         not built it into the template. If you need it, add this key
                         (these do not vary).        phrase to the others in your data table. It belongs with the
                         None of the colored         colored key phrases.
                         key phrases have            Enter values like "Polar fraction 1 (highest=4)", "Polar
                         values that differ for      fraction 2 (highest=4)" etc. to differentiate the
                         these. What should I        measurements.
                         do?

  9/24/2001 Data         Repeated                    The *TABLE COLUMN BASIS key phrase will be captured
            Originator   measurements                in some integrated data bases derived from these files,
                         (continued)                 unlike the *TABLE COLUMN USER NOTE key phrases, so
                                                     the basis key phrase should be used to capture important
                                                     defining information. The basis key phrase can be used for
                                                     many purposes, such as to differentiate "Particles: size"
                                                     measurements of diameter obtained with aerodynamic,
                                                     mobility, or light scattering methods; or to indicate that
                                                     "Wind direction" is referenced to true {preferred}, magnetic,
                                                     or grid North.
  9/21/2001 Data         Should I standardize        The EPA Supersites Quality Assurance Working Group has
            Originator   my measurements to          developed Data Reporting Convention Guidance about this.
                         standard temperature        It is available on the NARSTO QSSC Web site (
                         and pressure                http://cdiac.esd.ornl.gov/programs/NARSTO/ ).
                         conditions?
  9/21/2001 Data         How should I                The EPA Supersites Quality Assurance Working Group has
            Originator   represent below-MDL         developed Data Reporting Convention Guidance about this.
                         data?                       It is available on the NARSTO QSSC Web site (
                                                     http://cdiac.esd.ornl.gov/programs/NARSTO/ ).
Frequently Asked Questions                     Page 22 of 109                                              2/3/2011


            Data
            Originator
            or Data
Date Added User          Question                  Answer
   6/4/2002 Data         Mobile sites 1a: My       In the Site information table, insert a column for "Site
            Originator   samples are from a        nature" at the right of the existing columns (e.g., to the right
                         mobile site. What do I    of the "Comments"), according to advice in the section in
                         need to do differently?   the Instructions that explains how to safely insert columns
                                                   into the template (this column is present in the worksheet
                                                   Site Information Template, near the right side of this
                                                   workbook.) Include a row for the takeoff airport (or other
                                                   ground starting location for a surface mobile source such as
                                                   a motor vehicle or boat) in the Site Information Table, with
                                                   "Site nature" value of "Fixed". For example, for an aircraft
                                                   use the official airport name code in the last four characters
                                                   of the "Site ID: standard” identifier. (These instructions are
                                                   continued immediately below.)


   6/4/2002 Data         Mobile sites 1b:          (Mobile sites, Site information table, continued:) Include
            Originator   continuation              another row identifying the aircraft (or other mobile source)
                                                   itself, including the aircraft's, motor vehicle's, or boat's Site
                                                   ID value (but not the Flight ID or Trip ID). Use a desired
                                                   identifying code for that platform as the last four characters
                                                   of the "Site ID: standard” identifier. This platform identifier
                                                   code should be used consistently in the "Site ID: standard”
                                                   of subsequent sampling efforts. (Contact the NARSTO
                                                   QSSC for platform code information.) Use missing values
                                                   for the lat and lon information, and values for other columns
                                                   as appropriate (including missing codes for numeric
                                                   varriables, and "Not applicable" for character fields, if these
                                                   best describe the situation). Do not change numeric
                                                   variables in the Site information table to character variables.
                                                   The "Site nature" value will be "Mobile". (These instructions
                                                   are continued immediately below.)

   6/4/2001 Data         Mobile sites 1c:          (Mobile sites, continued:) In the main data table, the mobile
            Originator   continuation              source's "Site ID: standard" will be used in every row. Add
                                                   after Site ID: standard" a column for "Flight ID" or "Trip ID".
                                                   After the date, time etc. key phrases, add columns for
                                                   "Latitude: decimal degrees" and "Longitude: decimal
                                                   degrees", and for "Lat/lon accuracy" if possible. Use a
                                                   *TABLE USER NOTE key phrase to indicate the "datum" for
                                                   latitude and longitude (see the Site information table's
                                                   picklist for the Lat/lon reference datum variable). Also
                                                   add columns for as many of the following as you can
                                                   provide to indicate the vertical aspects of the samples:
                                                   "Height: above ground", "Ground elevation: above mean
                                                   sea level", and "Altitude: above mean sea level" (i.e., of the
                                                   sample itself). (These instructions are continued
                                                   immediately below.)
Frequently Asked Questions                       Page 23 of 109                                            2/3/2011


            Data
            Originator
            or Data
Date Added User          Question                    Answer
   6/4/2001 Data         Mobile sites 1d:            (Mobile sites, continued:) In *TABLE COLUMN KEY
            Originator   continuation                FIELDS, include the "Latitude: decimal degrees" and
                                                     "Longitude: decimal degrees" variables, and any
                                                     height/altitude variables (also keep Site ID: standard, "Date
                                                     start: local time" and "Time start: local time"). For each
                                                     variable in the table (after the dates, times, etc.), give the
                                                     *TABLE COLUMN SAMPLING HEIGHT ABOVE GROUND
                                                     (M) key phrase an appropriate picklist value (such as
                                                     "Varies--see variable Height: above ground", based on your
                                                     having included a corresponding variable in the data).



   9/6/2001 Data         If detailed "study" flags   Yes, this information should be stored in the final dataset,
            Originator   are used to identify        as this may be useful for future users. A measurement
                         situations such as          variable would have two associated flag columns. The
                         power failures and          *TABLE COLUMN NAME TYPE values would be
                         calibrations, should        "Flag--NARSTO", and "Flag--study". The study flags must
                         these flags be stored       be described in a metadata table similar to the one
                         in the final data, in       describing the NARSTO flags that appears in the template.
                         addition to the
                         NARSTO standard
                         flags?

   9/6/2001 Data         Should invalid data be      Invalid data values should be changed to the missing value
            Originator   removed from the final      code (e.g., -999.99), and flagged M1 or M2. Calibrations
                         dataset? If so, should      can be submitted as separate "companion" datasets. The
                         a copy of the dataset       archive does not normally store data values that have been
                         be maintained that          invalidated.
                         retains calibrations
                         and data values that
                         have been invalidated?


   9/6/2001 Data         Should the original         Raw datasets are not normally stored in the archive. Each
            Originator   data files produced by      study or network should define a protocol for storage of raw
                         data acquisition            data files.
                         systems be sent to the
                         archive as companion
                         files? If not, how long
                         should the PI keep
                         these files?
Frequently Asked Questions                      Page 24 of 109                                          2/3/2011


            Data
            Originator
            or Data
Date Added User          Question                  Answer
   9/6/2001 Data         Should the data           It is recommended that records be inserted during periods
            Originator   originator insert         with no data so that every sampling period is accounted for.
                         records for missing       The key phrase *TABLE USER NOTE can be used to
                         time periods? For         explain large blocks of missing results, or short periods of
                         example, if a power       regularly occurring missing results such as daily calibration
                         failure lasted one        periods.
                         hour, and the sampling
                         was performed every
                         10 minutes, should 6
                         records be added to
                         the dataset with
                         missing value codes in
                         the concentration field
                         and M1 in the flag
                         field?

  9/24/2001 Data         The values of some        In some cases, including MOUDI data and wind profiler
            Originator   key characteristics       data, one or more of the following key characteristics may
                         vary within my data.      vary from row to row within the main data table:
                         What should I do?         *TABLE COLUMN PARTICLE DIAMETER--LOWER
                                                   BOUND (UM),
                                                   *TABLE COLUMN PARTICLE DIAMETER--UPPER
                                                   BOUND (UM),
                                                   *TABLE COLUMN PARTICLE DIAMETER--MEDIAN (UM),
                                                   *TABLE COLUMN WAVELENGTH (NM),
                                                   *TABLE COLUMN WAVELENGTH--LOWER BOUND
                                                   (NM),
                                                   *TABLE COLUMN WAVELENGTH--UPPER BOUND (NM),
                                                   and
                                                   *TABLE COLUMN SAMPLING HEIGHT ABOVE GROUND
                                                   (M).
                                                   We have included in the picklist values for these entries,
                                                   with the form:
                                                   Varies--see variable {name of variable}
                                                   where {name of variable} is the name of a variable found in
                                                   the list of "Variable Names for Non-chemical Variables",
                                                   maintained on the NARSTO QSSC web site
                                                   (http://cdiac.ornl.gov/programs/NARSTO/). Select the
                                                   appropriate value for each variable (after the site, date,
                                                   time, etc. information) in the main data table. Add a column
                                                   with the appropriate {name of variable} as the value of the
                                                   *TABLE COLUMN NAME key phrase, and include this
                                                   name in the *TABLE KEY FIELD NAMES list.
Frequently Asked Questions                       Page 25 of 109                                         2/3/2011


            Data
            Originator
            or Data
Date Added User          Question                   Answer
  8/23/2004 Data         Binned data 1a: My         For data organized by bins, the "cyan" (see 3.11 in
            originator   data within a row are      Instructions) key phrase *TABLE COLUMN BIN (20
                         for particle sizes         characters maximum) can be added to the template to
                         sorted into bins. How      identify the categories for repetitive measurements. Bins,
                         should I represent         for example, could carry the values of the mass to charge
                         these data?                ratio for single particle mass spec data. Use "Not
                                                    applicable" as the entry for Site ID: standard, dates and
                                                    times, etc., and for variables to which it does not apply.
                                                    The "cyan" *TABLE COLUMN BIN BASIS (30 characters
                                                    maximum) is then also added to explain the basis for
                                                    *TABLE COLUMN BIN values.
   Example1. PM composition                                                                                                                                                                   Page 26 of 109


*DATA EXCHANGE STANDARD VERSION NARSTO 2005/04/29 (2.302)
*COMMENT                            Further instructions on how to fill in this template are provided at:
*COMMENT                            http://cdiac.ornl.gov/programs/NARSTO/narsto.html
*QUALITY CONTROL LEVEL              2 (a complete, externally consistent data set of specified quality that consists of research products that have undergone interpretative and diagnostic analyses by the project staff o
                                    2005/04/26
*DATE THIS FILE GENERATED/ARCHIVE VERSION NUMBER                                                 1
*ORGANIZATION ACRONYM               EPA_PM_SS
*ORGANIZATION NAME                  EPA Particulate Matter Supersites Program
*STUDY OR NETWORK ACRONYM           EPA_SS_QSSC
*STUDY OR NETWORK NAME              EPA Supersites--Qssc
                                    FILTER_METALS_PM2.5
*FILE CONTENTS DESCRIPTION--SHORT/LONG                                                           Manual filter-based PM2.5 element measurements from microwave decomposition of filters and Inductively Coupled Plasm
                                    Smith
*PRINCIPAL INVESTIGATOR NAME--LAST/FIRST                                                         Dr. John
*PRINCIPAL INVESTIGATOR AFFILIATION Department of Examples, College University, University City, PA
*CO-INVESTIGATOR NAME--LAST/FIRST None                                                           None
*CO-INVESTIGATOR AFFILIATION        None
*COUNTRY CODE                       US (UNITED STATES)
*STATE OR PROVINCE CODE             PA
                                    Variable interval
*SAMPLING INTERVAL AS REPORTED IN MAIN TABLE
                                    Variable
*SAMPLING FREQUENCY OF DATA IN MAIN TABLE frequency
                                    Dr. John Smith, Department of Examples, College University, University City, PA 15201, smith.john@collegeu.edu
*PRINCIPAL INVESTIGATOR CONTACT INFORMATION
*DATA USAGE ACKNOWLEDGEMENT         Department of Examples, College University, University City, PA
                                    Sigurd Les, Department of
*NAME AND AFFILIATION OF PERSON WHO GENERATED THIS FILE Examples, College University, University City, PA 15201, les.sigurd@collegeu.edu
                                    2005/04/27
*DATE OF LAST MODIFICATION TO DATA IN MAIN TABLE
                                    1
*FILE CHANGE HISTORY--VERSION NUMBER/DESCRIPTION                                                 First archived version
                                    MS Excel/2003
*NAME AND VERSION OF SOFTWARE USED TO CREATE THIS FILE
*STANDARD CHARACTERS                !#$%&'()*,-+=[]|./0123456789:;<>?@ ABCDEFGHIJKLMNOPQRSTUVWXYZ\^_`abcdefghijklmnopqrstuvwxyz{}~
                                    None
*COMPANION FILE NAME/FORMAT AND VERSION                                                          Not applicable

*TABLE NAME                                 NARSTO standard flags
*TABLE FOCUS                                Metadata
*TABLE COLUMN NAME                          Flag: NARSTO                                            Description
*TABLE COLUMN UNITS                         None                                                    None
*TABLE COLUMN FORMAT TYPE                   Char                                                    Char
*TABLE COLUMN FORMAT FOR DISPLAY            2                                                       120
*TABLE BEGINS
                                            V0                                                      Valid value
                                            V1                                                      Valid value but comprised wholly or partially of below detection limit data
                                            V2                                                      Valid estimated value
                                            V3                                                      Valid interpolated value
   Example1. PM composition                                                                                                                                                                     Page 27 of 109


                                            V4                                                    Valid value despite failing to meet some QC or statistical criteria
                                            V5                                                    Valid value but qualified because of possible contamination (e.g., pollution source, laboratory contamination source)
                                            V6                                                    Valid value but qualified due to non-standard sampling conditions (e.g., instrument malfunction, sample handling)
                                            V7                                                    Valid value but set equal to the detection limit (DL) because the measured value was below the DL
                                            M1                                                    Missing value because no value is available
                                            M2                                                    Missing value because invalidated by data originator
                                            H1                                                    Historical data that have not been assessed or validated
*TABLE ENDS

*TABLE NAME                                 Site information
*TABLE FOCUS                                Metadata
*TABLE COLUMN NAME                          Site ID: standard                                                              DescriptionCountry code
                                                                                                  Site abbreviation: standard                               Latitude: decimal degrees
                                                                                                                                                                                  Lat/lon degrees
                                                                                                                                                                                             Sampling height above grou
                                                                                                                                                State or province code Longitude: decimalreference datum
*TABLE COLUMN UNITS                         None                                                  None                     None       None      None                    decimal degree
                                                                                                                                                            decimal degree        None       m (meter)
*TABLE COLUMN FORMAT TYPE                   Char                                                  Char                     Char       Char      Char        Decimal Decimal Char             Decimal
*TABLE COLUMN FORMAT FOR DISPLAY            12                                                    4                        50         50        20          10.5        10.5      120        8.1
*TABLE COLUMN MISSING CODE                  None                                                  None                     None       None      None        -999.99999-999.99999None         -99999.9
*TABLE BEGINS
                                            ES2QUSPAXMPL                                          XMPL                             US (UNITED site
                                                                                                                                              PA                                    6.0
                                                                                                                           NARSTO QSSC fictional STATES)41.23456 -79.01234 NAD83 (North American Datum 1983)
*TABLE ENDS

*TABLE NAME                       PM2.5 Element Concentrations
*TABLE FOCUS                      Surface--fixed
                                  Zero VALUES
*TABLE EXPLANATION OF ZERO OR NEGATIVE and negative values appear in table due to blank correction. These values are below detection limit and are flagged as V1.
                                  The laboratory VALUES
*TABLE EXPLANATION OF REPORTED DETECTION LIMIT reported all measured values. Those values below detection limit are flagged as V1. Detection limit defined as (3.3 times the standard deviation of the field blank m
                                  Each tabulated uncertainty value is a number which, when added to or subtracted from the variable's value, provides a confidence interval for the true value. Value of uncertainty is
*TABLE EXPLANATION OF REPORTED UNCERTAINTY
*TABLE USER NOTE                  This file is a FICTIONAL EXAMPLE although it is based on actual data. It is intended solely as (1) a format and (2) somewhat as a type-of-content example of a NARSTO Data Ex
*TABLE USER NOTE2                 Manual filter samples collected with ThermoAndersen hi vol sampler with a PM2.5 size-selective inlet. Filters are Whatman 41 cellulose, 8 inches x10 inches.
*TABLE USER NOTE3                 Two strips of each filter were digested in a MARS5 laboratory microwave (CEM Corp.) and analyzed by an Agilent Technologies HP4500 ICP-MS.
*TABLE USER NOTE4                 All measurements have been blank-corrected by subtracting an average field blank concentration. Field blanks were averaged approximately monthly.
*TABLE USER NOTE5                 For above detection limit data, data for which PM10 < PM2.5 (within one standard deviation) are flagged as V4.
*TABLE USER NOTE6                 Minimum detection limits (MDLs) reported in the *TABLE COLUMN DETECTION LIMIT row are equal to (3.3*standard deviation of field blank measurements)/volume of air sample
*TABLE USER NOTE7                 It is possible for a reported element concentration to be below the average MDL but not be flagged V1; MDLs vary depending on the period of time for which the field blanks were a
*TABLE KEY FIELD NAMES            Site ID: standard                                                                                Time start:
                                                                                             Instrument co-location IDDate start: local time local time
*TABLE COLUMN NAME                Site ID: standard                                                                                Time start: Date end: Time end: Time zone: local       Time
                                                                                             Instrument co-location IDDate start: local time local time local time local time Date start: UTC start: UTC
*TABLE COLUMN NAME TYPE           Variable                                                   Variable                 Variable Variable Variable Variable Variable Variable Variable
*TABLE COLUMN CAS IDENTIFIER      None                                                       None                     None         None        None      None       None      None        None
                                  Not applicable
*TABLE COLUMN EXPLANATION OF DERIVED VARIABLE                                                Not applicable                        Not
                                                                                                                      Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                                                               Not       Not        Not       Not         Not
*TABLE COLUMN USER NOTE           None                                                       None                     None         None        None      None       None      None        None
  Example1. PM composition                                                                                                                 Page 28 of 109


*TABLE COLUMN USER NOTE2           None                  None                 None       None       None       None       None       None       None
*TABLE COLUMN UNITS                None                  None                 yyyy/mm/dd hh:mm      yyyy/mm/dd hh:mm      None       yyyy/mm/dd hh:mm
*TABLE COLUMN FORMAT TYPE          Char                  Char                 Date       Time       Date       Time       Char       Date       Time
*TABLE COLUMN FORMAT FOR DISPLAY 12                      2                    10         5          10         5          6          10         5
*TABLE COLUMN MISSING CODE         None                  None                 None       None       None       None       None       None       None
*TABLE COLUMN LOOKUP TABLE NAME Site information         None                 None       None       None       None       None       None       None
*TABLE COLUMN OBSERVATION TYPE     Supplementary data    Supplementary data              Supplementary data Supplementary data Supplementary data
                                                                              Supplementary data Supplementary data Supplementary data Supplementary data
                                   Not applicable
*TABLE COLUMN FIELD SAMPLING OR MEASUREMENT PRINCIPLE    Not applicable                                                                         Not
                                                                              Data loggerData loggerData loggerData loggerData loggerNot applicable applicable
                                   Not applicable
*TABLE COLUMN PARTICLE DIAMETER--LOWER BOUND (UM)        Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   Not applicable
*TABLE COLUMN PARTICLE DIAMETER--UPPER BOUND (UM)        Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   Not applicable
*TABLE COLUMN PARTICLE DIAMETER--MEDIAN (UM)             Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
*TABLE COLUMN MEDIUM               Not applicable        Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   Not applicable
*TABLE COLUMN COATING OR ABSORBING SOLUTION/MEDIA        Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
*TABLE COLUMN WAVELENGTH (NM)      Not applicable        Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   Not applicable
*TABLE COLUMN WAVELENGTH--LOWER BOUND (NM)               Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   Not applicable
*TABLE COLUMN WAVELENGTH--UPPER BOUND (NM)               Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   Not applicable
*TABLE COLUMN SAMPLING HEIGHT ABOVE GROUND (M)           Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
*TABLE COLUMN INLET TYPE           Not applicable        Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   TEMPERATURE CONTROL
*TABLE COLUMN SAMPLING HUMIDITY OR Not applicable        Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   Not applicable
*TABLE COLUMN LABORATORY ANALYTICAL METHOD               Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
*TABLE COLUMN SAMPLE PREPARATION Not applicable          Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
*TABLE COLUMN BLANK CORRECTION     Not applicable        Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   Not
*TABLE COLUMN VOLUME STANDARDIZATIONapplicable           Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
                                   MODEL NUMBER
*TABLE COLUMN INSTRUMENT NAME ANDNot applicable          Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
*TABLE COLUMN DETECTION LIMIT      Not applicable        Not applicable                  Not
                                                                              Not applicable applicable applicable applicable applicable applicable applicable
                                                                                                    Not        Not        Not        Not        Not
*TABLE BEGINS
                                   ES2QUSPAXMPL          P                    2001/07/111:00      2001/07/1123:45      EST       2001/07/116:00
                                   ES2QUSPAXMPL          P                    2001/07/120:55      2001/07/130:47       EST       2001/07/125:55
                                   ES2QUSPAXMPL          P                    2001/07/131:10      2001/07/140:56       EST       2001/07/136:10
                                   ES2QUSPAXMPL          P                    2001/07/141:14      2001/07/150:00       EST       2001/07/146:14
                                   ES2QUSPAXMPL          P                    2001/07/150:15      2001/07/160:16       EST       2001/07/155:15
*TABLE ENDS
             Example1. PM composition                   Page 29 of 109




lyses by the project staff or user community.)




Inductively Coupled Plasma Mass Spectrometer analysis
             Example1. PM composition                                                                                                                                                                    Page 30 of 109



ontamination source)
 sample handling)




                   Pressure: site ground level location setting Measurement end date measurements at site Lat/lon method ID
                              Site land use
                                          Site
         Ground elevation: above mean sea level                            Co-incidentSitesite study
                                                      Measurement start date at site   at ID:     Lat/lon accuracy   AIRS               City/town   County              W       GAWID       Comment
                                                                                                                                                               WMO region DCA/GAW station type
                              None
         m (meter) hPa (hectopascal)      None        yyyy/mm/ddyyyy/mm/dd None       None        m (meter) None     None               None        None       None     None    None        None
         Decimal Decimal Char             Char        Date      Date       Char       Char        Decimal Char       Char               Char        Char       Char     Char    Char        Char
         6.1       7.2        30          40          10        10         200        12          7.1        50      9                  25          25         1        1       6           120
         -999.9    -99.99     None        None        9999/12/319999/12/31None        None        -999.9     None    None               None        None       None     None    None        None

         312.4         972.51                       2001/07/112002/08/12Temperature, pressure, wind speed, wind direction, ozone, EBC, CNC Position (SA Off) N
                                Urban parkUrban and center city                   EXAMP      5.0                    (Pseudo University City
                                                                                                        GPS Code NONE Range) Standard    Allegheny N                                  N           None




viation of the field blank measurements) divided by the volume of air sampled.
ue. Value of uncertainty is error compounded from uncertainty in concentration from two separate fil
ple of a NARSTO Data Exchange Standard template (Version 2.302)




ents)/volume of air sampled. Average MDLs are given in this row for the entire study, assuming a 1.13 m^3/min fl
hich the field blanks were averaged, and the volume of air sampled.

                    Time
         Date end: UTC end: UTCLithium    Lithium    Lithium     Beryllium Beryllium Beryllium MagnesiumMagnesiumMagnesiumPotassium Potassium Potassium
         Variable Variable Variable Flag--NARSTO                 Variable Flag--NARSTO   Uncertainty--confidence interval (+/-)
                                                     Uncertainty--confidence interval (+/-)         Variable Flag--NARSTO              Variable Flag--NARSTO   Uncertainty--confidence interval (+/-)
                                                                                                                            Uncertainty--confidence interval (+/-)
         None       None       C7439-93-2 C7439-93-2 C7439-93-2  C7440-41-7  C7440-41-7  C7440-41-7 C7439-95-4 C7439-95-4   C7439-95-4 C7440-09-7 C7440-09-7   C7440-09-7
                    Not        Not        Not        Not         Not         Not
         Not applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable
                                                                                         Not        Not        Not          Not        Not        Not          Not
         None       None       Column-specific information information informationhere.Lithium) could go here. None
                                          Column-specific (for Lithium) could go (for None
                                                     Column-specific (for Lithium) could go here. None
                                                                 None        None                                           None       None       None         None
   Example1. PM composition                                                                                                                                                                            Page 31 of 109


None       None       None         None         None         None         None         None         None         None         None         None         None         None
yyyy/mm/dd hh:mm                   None         cubic (microgram(microgram per ug/m3meter)
                      ug/m3 (microgram per ug/m3meter)                    cubic
                                                             ug/m3 per None meter)     cubic (microgram(microgram per ug/m3meter)
                                                                                                    ug/m3 per None meter)
                                                                                                                 cubic        cubic (microgram(microgram per ug/m3meter)
                                                                                                                                                        cubic
                                                                                                                                           ug/m3 per None meter)     cubic (microgram per cubic meter)
Date       Time       Decimal Char              Decimal Decimal Char                   Decimal Decimal Char                   Decimal Decimal Char                   Decimal
10         5          9.6          2            9.6          9.6          2            9.6          9.6          2            9.6          9.6          2            9.6
None       None       -9.999999 None            -9.999999 -9.999999 None               -9.999999 -9.999999 None               -9.999999 -9.999999 None               -9.999999
None       None       None                      None
                                   NARSTO standard flags     None         NARSTO standard flags
                                                                                       None         None                      None
                                                                                                                 NARSTO standard flags     None                      None
                                                                                                                                                        NARSTO standard flags
           Supplementary data
Supplementary data Particles Particles Particles Particles Particles Particles Particles Particles Particles Particles Particles Particles
           Not        Single filterSingle filterSingle filterSingle filterSingle filterSingle filterSingle filterSingle filterSingle filterSingle filterSingle filterSingle filter
Not applicable applicable
           Not        0
Not applicable applicable          0            0            0            0            0            0            0            0            0            0            0
           Not        2.5
Not applicable applicable          2.5          2.5          2.5          2.5          2.5          2.5          2.5          2.5          2.5          2.5          2.5
           Not        Not          Not          Not          Not          Not
Not applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable
                                                                                       Not          Not          Not          Not          Not          Not          Not
           Not        Cellulose Cellulose Cellulose Cellulose Cellulose Cellulose Cellulose Cellulose Cellulose Cellulose Cellulose Cellulose
Not applicable applicable
           Not        None
Not applicable applicable          None         None         None         None         None         None         None         None         None         None         None
           Not        Not          Not          Not          Not          Not
Not applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable
                                                                                       Not          Not          Not          Not          Not          Not          Not
           Not        Not          Not          Not          Not          Not
Not applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable
                                                                                       Not          Not          Not          Not          Not          Not          Not
           Not        Not          Not          Not          Not          Not
Not applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable applicable
                                                                                       Not          Not          Not          Not          Not          Not          Not
           Not        6
Not applicable applicable          6            6            6            6            6            6            6            6            6            6            6
           Not        Impactor--direct
Not applicable applicable                       Impactor--direct
                                   Impactor--direct          Impactor--direct
                                                                          Impactor--direct
                                                                                       Impactor--direct
                                                                                                    Impactor--direct          Impactor--direct
                                                                                                                 Impactor--direct                       Impactor--direct
                                                                                                                                           Impactor--direct          Impactor--direct
           Not        None
Not applicable applicable          None         None         None         None         None         None         None         None         None         None         None
           Not        ICP/MS (Inductively(Inductively(Inductively(Inductively(Inductively(Inductively(Inductively(Inductively(Inductively(Inductively(Inductively(Inductively coupled plasma--mass spectrometry)
Not applicable applicable                       ICP/MS coupled plasma--masscoupled plasma--masscoupled plasma--masscoupled plasma--masscoupled plasma--mass spectrometry)
                                                             ICP/MS spectrometry)
                                   ICP/MS coupled plasma--masscoupled plasma--masscoupled plasma--masscoupled plasma--masscoupled plasma--masscoupled plasma--mass spectrometry)
                                                                          ICP/MS spectrometry)
                                                                                       ICP/MS spectrometry)
                                                                                                    ICP/MS spectrometry)      ICP/MS spectrometry)
                                                                                                                 ICP/MS spectrometry)                   ICP/MS spectrometry)
                                                                                                                                           ICP/MS spectrometry)      ICP/MS spectrometry)
           Not        Acid         Acid         Acid         Acid         Acid
Not applicable applicable digestion digestion digestion digestion digestion digestion digestion digestion digestion digestion digestion digestion
                                                                                       Acid         Acid         Acid         Acid         Acid         Acid         Acid
           Not        Blank        Blank        Blank        Blank        Blank
Not applicable applicable corrected corrected corrected corrected corrected corrected corrected corrected corrected corrected corrected corrected
                                                                                       Blank        Blank        Blank        Blank        Blank        Blank        Blank
           Not        Ambient temperature and pressure pressure pressure pressure pressure pressure pressure pressure pressure pressure pressure pressure
Not applicable applicable                       Ambient temperature and
                                   Ambient temperature and   Ambient temperature and
                                                                          Ambient temperature and
                                                                                       Ambient temperature and
                                                                                                    Ambient temperature and   Ambient temperature and
                                                                                                                 Ambient temperature and                Ambient temperature and
                                                                                                                                           Ambient temperature and   Ambient temperature and
           Not        Thermo-Andersen PM2.5 hi vol Thermo-Andersen PM2.5 hi vol Thermo-Andersen PM2.5 hi vol Thermo-Andersen PM2.5 hi vol
Not applicable applicable                       Thermo-Andersen PM2.5 hi vol Thermo-Andersen PM2.5 hi vol Thermo-Andersen PM2.5 hi vol Thermo-Andersen PM2.5 hi vol
                                   Thermo-Andersen PM2.5 hi vol Thermo-Andersen PM2.5 hi vol Thermo-Andersen PM2.5 hi vol Thermo-Andersen PM2.5 hi vol
           Not        0.000282 0.000282 0.000282 0.000044 0.000044 0.000044 0.007098 0.007098 0.007098 0.019727 0.019727 0.019727
Not applicable applicable

2001/07/124:45         0.000011    V1         0.000287   -0.000125   V1         0.000111    0.016161   V0          0.002502   0.047774    V0         0.007752
2001/07/135:47         0.000110    V1         0.000297   -0.000118   V1         0.000110    0.024765   V0          0.000975   0.063452    V0         0.005814
2001/07/145:56         -0.000006   V1         0.000343   -0.000131   V1         0.000103    0.018569   V0          0.002853   0.053228    V0         0.009596
2001/07/155:00         0.000184    V0         0.000188   -0.000116   V1         0.000107    0.016837   V0          0.000941   0.068125    V0         0.004720
2001/07/165:16         -0.000014   V1         0.000278   -0.000140   V1         0.000102    0.028386   V0          0.001182   0.086217    V0         0.008651
An example of a companion metadata document.
1. STUDY
1.1. Study Name
1.2. Principal Investigator/Team and Agency:
1.3. Data Availability
1.4. Data completeness (explanation of large data gaps, etc)
2. Site Information
2.1. Pictures, Site layout diagram, description, lat, lon, elev
3. Measurements
3.1. Objective(s):
3.2. Species and Size Range(s) (if PM):
3.3. Units (e.g., mg/l)
3.4. Measurement Details (brief description)
3.5. Field Information
3.5.1. Instrument Location
3.5.2. Measurement Platform (surface, tower, airborne)
3.5.3. Instrumentation Description (type/principle/make/model/media/coatings)
3.5.4. Inlet Type (cyclone, 10 um SSI, filter, none, etc.)
3.5.5. Inlet Height above Ground (and length if applicable)
3.5.6. Sampling Times/Frequency/Period
3.5.7. Sample Handling Methods
3.5.8. Nominal flow rate
3.5.9. Flow measurement/control
3.5.10. Flow Temperature/pressure Conditions
3.6. Standard Operating Procedures
4. Laboratory (if applicable)
4.1. Analytical method and instrumentation
4.2. Extraction method
4.3. Method/Instrument Detection Limit
4.4. Uncertainty Estimates
5. Measurement QA/QC Procedures
5.1. Field QA/QC
5.1.1. Sample Handling, Documentation, Storage, Chain of Custody
5.1.2. Traceable to (Standard Reference)
5.1.3. Calibrations
5.1.4. Zeroes and Spans
5.1.5. Audits
5.1.6. Blanks (frequency, type)
5.1.7. Field QC (for filter methods)
5.1.8. Precision Determination (collocation, duplication)
5.1.9. Comparison with other methods
5.2. Laboratory QA/QC
5.2.1. Sample Handling, Documentation, Storage, Chain of Custody
5.2.2. Traceable to (Standard reference)
5.2.3. Calibrations
5.2.4. Blanks (frequency, type)
5.2.5. Other lab QC (check solutions, spikes, blinds, recoveries, etc)
5.2.6. Precision Determination (duplicates)
5.2.7. Comparison with other methods
5.2.8. Audits
6. Data Management QA/QC
6.1. Data recording method
6.2. Frequency of raw data record
6.3. Frequency of reported data record (averaging period)
6.4. Data Chain of Custody
6.5. Data QC Procedures
6.6. Validity Flags used
6.7. Calibrations or other adjustments performed on measurements
7. Data Quality Measures
7.1. Measurement Quality Objectives (Pre-campaign)
7.1.1. Anticipated Detection Limits ( method/analytical) and method of determination:
7.1.2. Accuracy
7.1.3. Precision
7.1.4. Comparability
7.1.5. Representativeness
7.1.6. Completeness
7.2. Post-Campaign DQIs (Data Quality Indicators)
7.2.1. Detection Limits ( method/analytical) and method of determination:
7.2.2. Accuracy
7.2.3. Precision
7.2.4. Comparability
7.2.5. Representativeness
7.2.6. Completeness
8. Blank correction (describe whether done and method used)
9. Other Quality Information
Give special information about the measurement and its quality. For example:
 Filter blanks had high nitrate levels causing the rejection of many active samples
 the analytical method for sulphate was found to be biased high during laboratory round-robin study (reference)
 Measurements were biased high compared to collocated xxxxxx method (reference) or external audit.
 References to publications related to the measurements.
bin study (reference)
xternal audit.
                                              Sample-level flags


                                             SAMPLE-LEVEL FLAGS
1 NARSTO and study flags may be provided at the sample level, rather than the individual measurement level,
  for a large group of repetitive measurements of the same type. Sample-level flags may be used where these
  four conditions are met: (1) the measurement name (*TABLE COLUMN NAME) is the same for a large group
  of measurements which differ only by a single key characteristic or related set of key characteristics, such as
  size; (2) this group of measurements constitutes the vast majority of the measurements included in the table;
  (3) if any "different" measurements are provided (e.g., temperature, pressure, and humidity conditions
  associated with a particle size distribution sample), these are strongly related to the group of measurements;
  (4) flags in general apply to the entire sample (all columns) rather than only to selected columns within the
  group of measurements.

2 Exceptional event flags have been developed by some studies such as the EPA Supersites. They apply to
  the entire sample, and have the variable name "Flag: exceptional event". The *TABLE COLUMN NAME TYPE
  for exceptional event flags must be "Flag--exceptional event". If more than one flag is required, separate
  the flags with a semi-colon. The NARSTO QSSC web site contains a document describing the EPA Supersite
  exceptional event flags.
3 Column(s) with sample-level flags must preceed the variables to which they apply, and must be given
  appropriate names from the non-chemical names table (e.g., Flag: NARSTO sample-level.). The *TABLE
  COLUMN NAME TYPE for sample-level flags must be the picklist value appropriate for the type of flag (e.g.,
  "Flag--NARSTO", "Flag--Supersites detailed", or "Flag--study"). The lookup table for sample-level flags will be
  the same (have the same table name, variable name, etc.) as for regular flags. The sample-level quality flag's
  value would normally be the most extreme valid value that applied to any of the sample data. If some
  measurements with missing values are contained in the row, these measurements must have the missing
  value code, but they need not carry their own dedicated M1 or M2 flag. The NARSTO Supersites or study flag
  in this case would still be the appropriate NARSTO (most extreme) valid code associated with the non-missing
  measurements. If all sample values were missing, the sample-level flag would carry the M1 or M2 code, as
  appropriate.

4 Sample-level flags may be used along with dedicated flags for particular columns that need them. For
  example, accompanying meteorological variables may need dedicated columns for flags while sample-level
  flags are appropriate for the main data. Or it may be deemed important for some missing values to include
  dedicated flag columns indicating M1 vs. M2 flags. When dedicated flag columns are included for some
  variables, in a file where sample-level flags are also used, flag values in the dedicated columns will take
  precedence. Please be sure such dedicated flag columns contain values for all data rows.

5 Subsample-level flags can also be used. Sometimes several sample-level flags may be needed, each
  applying to a group of data columns (for example, if several different instruments are used to collect one
  particle size distribution). These are termed "subsample-level flags." Use the version of flags from the non-
  chemical variable names table that indicate they are subsample-level. Example: "Flag: NARSTO subsample-
  level". Define the first subsample-level flag, as usual for the sample-level flag, followed by the columns of
  data to which it applies. Then define another subsample-level flag column, followed by the columns of data to
  which it applies, and so forth. A NARSTO subsample-level flag's coverage stops when the next NARSTO flag
  occurs. Any ambiguity in coverage of a study subsample-level flag needs to be explained elsewhere in the
  file. Add the *TABLE COLUMN GROUP CODE key phrase (see the 2001/05/24 entry in the Frequently
  Asked Questions worksheet), and use this special key phrase to define the groups to which each subsample-
  level flag applies.

  Last updated: 2002/05/28




                                                                                                         Page: 36
    UNCERTAINTY AND STATISTICS

  Sources of information: There are comments in the template in a number of places
  explaining how to represent uncertainty in a Data Exchange Standard file. This
  worksheet provides some expanded explanation, focusing on how to use the *TABLE
  COLUMN NAME TYPE key phrases relating to uncertainty and statistics. The
1 "Representing uncertainty" worksheet provides detailed advice on that topic.

  "Statistic--..." name types may apply when each row summarizes a number of
  underlying observations or samples. For example, if observations are made each
  minute, but the file presents hourly values, the main value presented would have a
  *TABLE COLUMN NAME TYPE of "Variable". This would implicitly be an arithmetic
  mean, but the *TABLE COLUMN EXPLANATION OF DERIVED VARIABLE key phrase
  should nonetheless be used to explain how it is derived (e.g., "Arithmetic mean").
  Additional statistics for the same variable may be presented in other columns, using
  other "Statistic"-type TABLE COLUMN NAME TYPE values. "Statistic"-type name types
  are calculated from the measurements themselves and do not make assumptions about
2 how the measurements are distributed.

  "Uncertainty--...." name types represent various kinds of estimates or inferences that
  can be made about the main variable. Again, the *TABLE COLUMN EXPLANATION OF
  DERIVED VARIABLE key phrase should be used to explain how these uncertainty values
  are obtained. Companion documents (see the header section of the Template) should
  be used where the explanation is too long (>1000 characters) or where superscripts,
3 subscripts, or other special characters are needed in the explanation.

     The "combined standard uncertainty" is the standard uncertainty of the result (y) of a
    measurement when the result is obtained from the values of a number of other
    quantities, equal to the positive square root of a sum of terms, the terms being the
    variances or covariances of these other quantities weighted according to how the
    measurement result varies with these quantities (GUM 2.3.4)

    "Guide to the Expression of Uncertainty in Measurement," ISO, Geneva, Switzerland
    1993 (ISBN 92- 67-10188-9) Known as "GUM"
4
    The "expanded uncertainty" is a quantity defining an interval about the result of a
    measurement that may be expected to encompass a large fraction of the distribution of
    values that could reasonably be attributed to the measurand. Obtained by multiplying the
    combined standard uncertainty by a coverage factor. Usually expressed as 'k". (GUM
    2.3.5) (see reference above)
5
  *TABLE COLUMN NAME and *TABLE COLUMN OBSERVATION TYPE for "Statistic--
  ..." "Detection limit", or "Uncertainty--..." name type entries remains whatever it is for the
  main variable. The flag for the variable should be provided after the collection of
6 variables.
Reporting          The comments for the *TABLE EXPLANATION OF REPORTED
uncertainty        UNCERTAINTY key phrase, and the "Uncertainty and statistics" worksheet,
                   provide recommendations for representing uncertainty in Data Exchange
                   Standard files. This "Reporting uncertainty" worksheet provides additional
                   advice.
CONDITION          RECOMMENDED ACTION


Uncertainty        Please provide one or more uncertainty columns, containing the estimated
varies for each    uncertainty for each measurement value. The header information for the blue
measurement        key phrases except *TABLE COLUMN NAME TYPE and possibly *TABLE
and can be         COLUMN UNITS will be the same as for the variable to which the uncertainty
estimated          value applies. For *TABLE COLUMN NAME TYPE, select a value that
                   characterizes the uncertainty (request new values from the NARSTO QSSC if
                   needed). Indicate the appropriate units; these are usually the same as the base
                   measurement, but a percentage would sometimes be possible. In the *TABLE
                   EXPLANATION OF REPORTED UNCERTAINTY key phrase, provide a verbal
                   description of how the uncertainty value should be applied and interpreted (for
                   example, "Each tabulated uncertainty value is a number which, when added to or
                   subtracted from the variable's value, provides a 95% confidence interval for the
                   true value.").
(Continued)        If this single description does not apply to all of the uncertainty columns, the
                   *TABLE EXPLANATION OF REPORTED UNCERTAINTY can refer to a
                   *TABLE COLUMN USER NOTE key phrase, in which is presented a column-by-
                   column explanation of how the uncertainty values are interpreted.


Uncertainty is     A *TABLE COLUMN USER NOTE should be used to carry the value with its
constant for all   units [e.g., "11% (percent)"]. An adjacent *TABLE COLUMN USER NOTE (e.g.,
of the sample      *TABLE COLUMN USER NOTE2) should carry the explanation of the meaning
data in a          of the value (e.g., "Tabulated value +/- above percentage of the value gives 95%
column             CI"). NOTE: NEED TO CHECK THIS WORDING AGAINST THE FINAL, IT MAY
                   BE INCORRECT - BOB VET AND BILL ARE INVESTIGATING The *TABLE
                   EXPLANATION OF REPORTED UNCERTAINTY key phrase should refer
                   explicitly (by name) to the two *TABLE COLUMN USER NOTE key phrases
                   which are used to explain, column by column, the interpretation of uncertainty.

(Continued)        If desired, a separate column(s) may also be provided to provide the result of
                   applying the constant uncertainty value to the measured value. The *TABLE
                   COLUMN USER NOTE key phrases used to explain the constant uncertainty
                   can provide helpful explanation to these columns as well. We recommend
                   reducing the number of significant digits for such columns, as appropriate.
Uncertainty is     Sample-level uncertainty is reported using a column preceding the variables to
constant for all   which the uncertainty applies (i.e., after the site, date, and time information).
of the             This column has the special *TABLE COLUMN NAME
measured           "Uncertainty: sample-level", with the *TABLE COLUMN NAME TYPE and
variables in a     *TABLE COLUMN UNITS selected as appropriate. The other blue-colored key
sample, but        phrases can be assigned the same picklist entry as all of the variables to which it
varies from        applies, if a single picklist entry applies to all of them; otherwise, "Not applicable"
sample to          can be entered. Use the the *TABLE EXPLANATION OF REPORTED
sample             UNCERTAINTY key phrase to provide a detailed description of how the
(sample-level      uncertainty values are applied and interpreted.
uncertainty)
(Continued)        Subsample-level uncertainty can also be used, where the same value of
                   uncertainty applies to a group of variables, then another value of uncertainty
                   applies to another group of variables. The special variable name for this
                   situation is "Uncertainty: subsample-level". See the "Sample-level flags"
                   worksheet's section on "Subsample-level flags" to see how subsample-level
                   modifying variables work; adapt the flags instructions to uncertainty.


Uncertainty is Use the *TABLE EXPLANATION OF REPORTED UNCERTAINTY key phrase to
constant for all provide the constant value, and describe there in words how the value is applied
of the           and interpreted.
measured
variables in
the
file
Template history of changes                     Page 40 of 109                                              2/3/2011


Date       Version    Description of change
  2/3/2001 2.201      Key characteristics key phrases added to main table, sampling interval and frequency
                      key phrases added.
  2/18/2001 2.202     Changed "Droplet size" to "Droplet light scattering" in Field and Sampling Principle table,
                      changed entries in Observation Type table, used the colon separator for variables with
                      compound names (e.g., station ID: Standard)
  3/12/2001 2.203     Changed "station" to "site".
  3/20/2001 2.204     Added examples for Filter pack chemistry, light absorption + black carbon, and light
                      scattering. Added instructions to the template and instructions worksheets.
   4/1/2001 2.205     Updated instructions, improved the print formatting in the example worksheets.
            2.206     Updated frequently asked questions sheet.
   4/5/2001 2.207     Updated instructions, improved additional print formatting, updated the comments (swc)

   4/9/2001 2.207     Per 2/5/2001 discussions, continued updating instructions and one comment; added
                      validation list for sampling height; inserted blank in row two of other validation lists.

  4/23/2001 2.208     Added the key phrase *CO-INVESTIGATOR NAME-LAST/FIRST and *CO-
                      INVESTIGATOR AFFILIATION. Highlighted the TABLE COLUMN key phrases that
                      together uniquely identify a column in the main table.
  5/18/2001 2.209     Added the key phrase *TABLE USER NOTE
  5/18/2001 2.209     Changed the key phrase TABLE COLUMN VARIABLE TYPE to TABLE COLUMN
                      NAME TYPE, and changed the first selection in the list from "Primary" to "Variable".

  5/18/2001 2.209     Added "Scientific" to the TABLE COLUMN FORMAT TYPE list.
                      Chaned "*LAST REVISION TO DATA-DATE/REVISION NUMBER" to "*DATE THIS
                      FILE GENERATED/ARCHIVE VERSION NUMBER".
                      Changed *DATE THIS FILE GENERATED to *DATE OF LAST MODIFICATION TO
                      DATA IN MAIN TABLE

  5/18/2001 2.209     Added the key phrase *TABLE EXPLANATION OF ZERO OR NEGATIVE VALUES.

  5/18/2001 2.209     Handoff to SWC: Incorporated template Key Phrase changes into examples.
  5/22/2001 2.209     Added instructions for scientific notation to FAQ worksheet.
  5/29/2001 2.209     Added a worksheet explaining use of sample-level flags. Added instructions to FAQ
                      worksheet on use of the *TABLE COLUMN GROUP CODE key phrase.
   6/5/2001 2.209     Revised Site information table in the template.
   6/6/2001 2.209     Added instructions to FAQ worksheet on use of the *TABLE COLUMN BASIS key
                      phrase.
   6/6/2001 2.209     Added instructions for mobile sites to FAQ worksheet.
  6/11/2001 2.209     Modified Example 1.
  6/12/2001 2.209     Removed Example 2. Exported and imported Example 3 to remove comments.
                      Completed modifications of Example 1 and Example 3. Made minor modifications to
                      FAQs and Instructions relating to mobile sources.
  6/12/2001 2.209     Released Version 2.209 of the template to the Data Management Group
  6/28/2001 2.210     Specified "mandatory" or "optional" for each key phrase.
                      Modified the key phrase *NAME AND AFFILIATION OF PERSON WHO GENERATED
                      THIS FILE.
                      Modified the key phrase *NAME AND VERSION OF SOFTWARE USED TO CREATE
                      THIS FILE.
                      Modified the key phrase *ANCILLARY FILE NAME/FORMAT AND VERSION.
Template history of changes                    Page 41 of 109                                           2/3/2011


   7/9/2001 2.210     In the Site information table, updated the comments on the TABLE COLUMN NAME
                      entries to indicate which ones are required vs. optional.
   7/9/2001 2.210     Added to Section 1 of Instructions information about how to know which key phrases are
                      optional vs. mandatory, and which columns in the Site information table are optional vs.
                      required.
   7/9/2001 2.210     Updated Examples 1 and 3 with the three revised key phrases (as changed 20010628),
                      and confirmed correct key phrases in their header section and main data table (Note:
                      each main table lacks the optional sampling height and measurement PI key phrases,
                      which is acceptable).
   7/9/2001 2.210     Added to the val_lab_analytical_method validation list: Colorimetry-Greiss, Colorimetry-
                      indophenol, Colorimetry-Thorin
  7/18/2001 2.210     Added to the val_lab_analytical_method validation list:Capillary electrophoresis
  7/18/2001 2.210     Released Version 2.210 of the template to the Data Management Group
  7/24/2001 2.211     Updated the comments for the *TABLE COLUMN NAME key phrases in the template
  7/25/2001 2.211     Revised wording of the V1 and V7 flags in the template and in Examples 1 and 3.

  7/25/2001 2.211     In the NARSTO standard flags table, added to the V0 flag's comment a note that this
                      flag uses the number zero, not the letter O.
  7/25/2001 2.211     Expanded the allowable length to 1000 characters, including spaces, for the following
                      key phrases: *COMMENT, *DATA USAGE ACKNOWLEDGEMENT, *TABLE
                      EXPLANATION OF ZERO OR NEGATIVE VALUES, and *TABLE USER NOTE

  7/25/2001 2.211     Added a Section 1.2b to Instructions, explaining how to get updated versions of the
                      template and indicating that it is not necessary to retrofit the updates where Versions
                      2.209 or higher are already being used.
  7/25/2001 2.211     Revised Instructions Sections 2.2, 3.4, 4.2, and 4.3(e) to reflect new wording of key
                      phrases in Version 2.210.
  7/25/2001 2.211     Revised Instructions Sections 4.3(a) and (b) to reflect evolved guidance for handling
                      below-detection-limit data.
  7/26/2001 2.211     Added *TABLE USER NOTE2 to illustrate capability to use many of these, and modified
                      table user note comments.
  7/27/2001 2.211     Added optional key phrase *TABLE EXPLANATION OF REPORTED DETECTION
                      LIMIT VALUES
   8/2/2001 2.211     To the Site information table, added a required Lat/lon reference datum field, and added
                      optional Lat/lon method, Town/city, and County fields. Also, modified the specifications
                      for Lat/lon accuracy (now decimal, not character) and the comment instructions for this
                      field.
   8/6/2001 2.211     Added information to the general comment on the Site information table.
   8/7/2001 2.211     Rewrote the comments for *TABLE COLUMN NAME in the NARSTO standard flags
                      and the Site information metadata tables, to provide detailed guidance specific to those
                      tables.
  8/10/2001 2.211     Made minor changes in the Frequently Asked Questions table
  8/14/2001 2.211     Corrected spelling of *CO-INVESTIGATOR AFFILIATION and *TABLE COLUMN
                      WAVELENGTH (NM) in template and examples.
  8/14/2001 2.211     In picklist for *TABLE COLUMN FIELD SAMPLING OR MEASUREMENT PRINCIPLE,
                      changed "Anaeroid barometer" to "Barometer-anaeroid", and added "Barometer-
                      mercury" and "Thermometer-liquid in glass".
  8/14/2001 2.211     In picklist for *TABLE COLUMN NAME TYPE, added "Flag - Supersites detailed" and
                      decapitalized "Study" in "Flag - study".
  8/14/2001 2.211     Released Version 2.211 of the template to be posted on the NARSTO QSSC Web site
Template history of changes                      Page 42 of 109                                              2/3/2011


  8/15/2001 2.212     Made additions/corrections to many of the key characteristics tables, including changing
                      single dashes to double dashes (e.g., Filter pack--multiple filters)
  8/15/2001 2.212     Modified sample-level flags worksheet instructions
  9/17/2001 2.212     Changed the key phrase *ANCILLARY FILE NAME/FORMAT AND VERSION to
                      *COMPANION FILE NAME/FORMAT AND VERSION
  9/17/2001 2.212     Added key characteristics phrases *TABLE COLUMN WAVELENGTH--LOWER
                      BOUND (NM) and *TABLE COLUMN WAVELENGTH--UPPER BOUND (NM)
  9/21/2001 2.212     Updated guidance in the Frequently Asked Questions worksheet concerning volume
                      standardization (temperature and pressure conditions) and below-MDL data.

  9/24/2001 2.212     Updated guidance in the Frequently Asked Questions worksheet concerning repeated
                      measurements of the same variable
  9/24/2001 2.212     Updated guidance relating to the sampling height key phrase value in the Frequently
                      Asked Questions worksheet concerning mobile sites.
  9/24/2001 2.212     Added to Frequently Asked Questions a discussion of what to do when values of some
                      key characteristics vary within the data.
  9/25/2001 2.212     In the Instructions, revised Sections 3.10 (handling cases where values of key
                      characteristics vary among rows) and 3.11 (special key phrases which can help
                      maintain the required uniqueness among columns).
  9/26/2001 2.212     Changed the single dash to double dashes in the following key phrases:
                      *FILE CONTENTS DESCRIPTION--SHORT/LONG
                      *PRINCIPAL INVESTIGATOR NAME--LAST/FIRST
                      *CO-INVESTIGATOR NAME--LAST/FIRST
                      *TABLE COLUMN PARTICLE DIAMETER--LOWER BOUND (UM)
                      *TABLE COLUMN PARTICLE DIAMETER--UPPER BOUND (UM)
                      *TABLE COLUMN PARTICLE DIAMETER--MEDIAN (UM)
  9/26/2001 2.212     Updated Examples 1 and 3 to conform to Version 2.212, and made a few additional
                      corrections.
  9/27/2001 2.212     Released Version 2.212 of the template to be posted on the NARSTO QSSC Web site

10/24/2001 2.213      Incorporated the formerly separate "Site Information Template" with its particuar
                      picklists, instructions, and updates list as far-right-hand worksheets in this workbook,
                      and updated its designation from Version 1.6 to Version 1.7. (It also shares some
                      picklists with the main template.) Updated many of the Site informaiton template
                      comments.
            2.213     Updated the "Site land use" picklist, and modified (reduced) the "Site location setting"
                      picklist. These changes should correspond to results from the Data Management
                      Working Group calls, and should allow reasonable consistency with AIRS.


            2.213     Updated the advice in comments about Co-location ID.
            2.213     Updated slightly in Frequently Asked Questions the advice about mobile sites.
            2.213     Updated comments for the two key phrases concerning "ORGANIZATION" in the
                      header section, to clarify that this refers to the sponsor, and reflecting that this will no
                      longer be used in constructing archive file names.
            2.213     Added to the Instructions worksheet a Section 3.12 concerning file naming.
            2.213     Made minor modifications to the picklist for *TABLE COLUMN FIELD SAMPLING OR
                      MEASUREMENT PRINCIPLE
Template history of changes                   Page 43 of 109                                          2/3/2011


            2.213     Augmented comment on "Site ID: standard" name in the Site information table, to reflect
                      that site names are centrally assigned and that site abbreviations must be 4 characters
                      long.
            2.213     Released Version 2.213 2001/10/31
            2.301     Removed wavelength validation list requirement (enabled ad hoc number entry); added
                      key phrases TABLE EXPLANATION OF REPORTED UNCERTAINTY, TABLE
                      COLUMN DETECTION LIMIT, *TABLE COLUMN EXPLANATION OF DERIVED
                      VARIABLE; and added Units picklist

            2.301     Added the characters +={}| to the list of allowable characters in the key phrase
                      *STANDARD CHARACTERS.
                      Added the key phrase *FILE CHANGE HISTORY--VERSION NUMBER/DESCRIPTION
                      Limited the number of TABLE KEY FIELDS entries to 10.
                      Added "Detection limit" and additional uncertainty selections to TABLE COLUMN NAME
                      TYPE

            2.301     Changed sampling height key phrase to *TABLE COLUMN SAMPLING HEIGHT
                      ABOVE GROUND (M)
ISO3166 Country code                  Last Updated

AF (AFGHANISTAN)                          3/14/2001
AL (ALBANIA)                              3/14/2001
DZ (ALGERIA)                              3/14/2001
AS (AMERICAN SAMOA)                       3/14/2001
AD (ANDORRA)                              3/14/2001
AO (ANGOLA)                               3/14/2001
AI (ANGUILLA)                             3/14/2001
AQ (ANTARCTICA)                           3/14/2001
AG (ANTIGUA & BARBUDA)                    3/14/2001
AR (ARGENTINA)                            3/14/2001
AM (ARMENIA)                              3/14/2001
AW (ARUBA)                                3/14/2001
AU (AUSTRALIA)                            3/14/2001
AT (AUSTRIA)                              3/14/2001
AZ (AZERBAIJAN)                           3/14/2001
BS (BAHAMAS)                              3/14/2001
BH (BAHRAIN)                              3/14/2001
BD (BANGLADESH)                           3/14/2001
BB (BARBADOS)                             3/14/2001
BY (BELARUS)                              3/14/2001
BE (BELGIUM)                              3/14/2001
BZ (BELIZE)                               3/14/2001
BJ (BENIN)                                3/14/2001
BM (BERMUDA)                              3/14/2001
BT (BHUTAN)                               3/14/2001
BO (BOLIVIA)                              3/14/2001
BA (BOSNIA & HERZEGOWINA)                 3/14/2001
BW (BOTSWANA)                             3/14/2001
BV (BOUVET ISLAND)                        3/14/2001
BR (BRAZIL)                               3/14/2001
IO (BRITISH INDIAN OCEAN TERRITORY)       3/14/2001
BN (BRUNEI DARUSSALAM)                    3/14/2001
BG (BULGARIA)                             3/14/2001
BF (BURKINA FASO)                         3/14/2001
BI (BURUNDI)                              3/14/2001
KH (CAMBODIA)                             3/14/2001
CM (CAMEROON)                             3/14/2001
CA (CANADA)                               3/14/2001
CV (CAPE VERDE)                           3/14/2001
KY (CAYMAN ISLANDS)                       3/14/2001
CF (CENTRAL AFRICAN REPUBLIC)             3/14/2001
TD (CHAD)                                 3/14/2001
CL (CHILE)                                3/14/2001
CN (CHINA)                                3/14/2001
CX (CHRISTMAS ISLAND)                     3/14/2001
CC (COCOS (KEELING) ISLANDS)              3/14/2001
CO (COLOMBIA)                             3/14/2001
KM (COMOROS)                              3/14/2001
CG (CONGO)                                3/14/2001
CK (COOK ISLANDS)                         3/14/2001
CR (COSTA RICA)                           3/14/2001
CI (COTE D'IVOIRE)                        3/14/2001
HR (CROATIA)                              3/14/2001
CU (CUBA)                                 3/14/2001
CY (CYPRUS)                               3/14/2001
CZ (CZECH REPUBLIC)                       3/14/2001
DK (DENMARK)                              3/14/2001
DJ (DJIBOUTI)                                 3/14/2001
DM (DOMINICA)                                 3/14/2001
DO (DOMINICAN REPUBLIC)                       3/14/2001
TP (EAST TIMOR)                               3/14/2001
EC (ECUADOR)                                  3/14/2001
EG (EGYPT)                                    3/14/2001
SV (EL SALVADOR)                              3/14/2001
GQ (EQUATORIAL GUINEA)                        3/14/2001
ER (ERITREA)                                  3/14/2001
EE (ESTONIA)                                  3/14/2001
ET (ETHIOPIA)                                 3/14/2001
FK (FALKLAND ISLANDS)                         3/14/2001
FO (FAROE ISLANDS)                            3/14/2001
FJ (FIJI)                                     3/14/2001
FI (FINLAND)                                  3/14/2001
FR (FRANCE)                                   3/14/2001
GF (FRENCH GUIANA)                            3/14/2001
PF (FRENCH POLYNESIA)                         3/14/2001
TF (FRENCH SOUTHERN TERRITORIES)              3/14/2001
GA (GABON)                                    3/14/2001
GM (GAMBIA)                                   3/14/2001
GE (GEORGIA)                                  3/14/2001
DE (GERMANY)                                  3/14/2001
GH (GHANA)                                    3/14/2001
GI (GIBRALTAR)                                3/14/2001
GR (GREECE)                                   3/14/2001
GL (GREENLAND)                                3/14/2001
GD (GRENADA)                                  3/14/2001
GP (GUADELOUPE)                               3/14/2001
GU (GUAM)                                     3/14/2001
GT (GUATEMALA)                                3/14/2001
GN (GUINEA)                                   3/14/2001
GW (GUINEA-BISSAU)                            3/14/2001
GY (GUYANA)                                   3/14/2001
HT (HAITI)                                    3/14/2001
HM (HEARD & MC DONALD ISLANDS)                3/14/2001
HN (HONDURAS)                                 3/14/2001
HK (HONG KONG)                                3/14/2001
HU (HUNGARY)                                  3/14/2001
IS (ICELAND)                                  3/14/2001
IN (INDIA)                                    3/14/2001
ID (INDONESIA)                                3/14/2001
IR (IRAN, ISLAMIC REPUBLIC OF)                3/14/2001
IQ (IRAQ)                                     3/14/2001
IE (IRELAND)                                  3/14/2001
IL (ISRAEL)                                   3/14/2001
IT (ITALY)                                    3/14/2001
JM (JAMAICA)                                  3/14/2001
JP (JAPAN)                                    3/14/2001
JO (JORDAN)                                   3/14/2001
KZ (KAZAKHSTAN)                               3/14/2001
KE (KENYA)                                    3/14/2001
KI (KIRIBATI)                                 3/14/2001
KP (KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF)   3/14/2001
KR (KOREA, REPUBLIC OF)                       3/14/2001
KW (KUWAIT)                                   3/14/2001
KG (KYRGYZSTAN)                               3/14/2001
LA (LAO PEOPLE'S DEMOCRATIC REPUBLIC)         3/14/2001
LV (LATVIA)                                   3/14/2001
LB (LEBANON)                                      3/14/2001
LS (LESOTHO)                                      3/14/2001
LR (LIBERIA)                                      3/14/2001
LY (LIBYAN ARAB JAMAHIRIYA)                       3/14/2001
LI (LIECHTENSTEIN)                                3/14/2001
LT (LITHUANIA)                                    3/14/2001
LU (LUXEMBOURG)                                   3/14/2001
MO (MACAU)                                        3/14/2001
MK (MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF)   3/14/2001
MG (MADAGASCAR)                                   3/14/2001
MW (MALAWI)                                       3/14/2001
MY (MALAYSIA)                                     3/14/2001
MV (MALDIVES)                                     3/14/2001
ML (MALI)                                         3/14/2001
MT (MALTA)                                        3/14/2001
MH (MARSHALL ISLANDS)                             3/14/2001
MQ (MARTINIQUE)                                   3/14/2001
MR (MAURITANIA)                                   3/14/2001
MU (MAURITIUS)                                    3/14/2001
YT (MAYOTTE)                                      3/14/2001
MX (MEXICO)                                       3/14/2001
FM (MICRONESIA, FEDERATED STATES OF)              3/14/2001
MD (MOLDOVA, REPUBLIC OF)                         3/14/2001
MC (MONACO)                                       3/14/2001
MN (MONGOLIA)                                     3/14/2001
MS (MONTSERRAT)                                   3/14/2001
MA (MOROCCO)                                      3/14/2001
MZ (MOZAMBIQUE)                                   3/14/2001
MM (MYANMAR)                                      3/14/2001
NA (NAMIBIA)                                      3/14/2001
NR (NAURU)                                        3/14/2001
NP (NEPAL)                                        3/14/2001
NL (NETHERLANDS)                                  3/14/2001
AN (NETHERLANDS ANTILLES)                         3/14/2001
NC (NEW CALEDONIA)                                3/14/2001
NZ (NEW ZEALAND)                                  3/14/2001
NI (NICARAGUA)                                    3/14/2001
NE (NIGER)                                        3/14/2001
NG (NIGERIA)                                      3/14/2001
NU (NIUE)                                         3/14/2001
NF (NORFOLK ISLAND)                               3/14/2001
MP (NORTHERN MARIANA ISLANDS)                     3/14/2001
NO (NORWAY)                                       3/14/2001
OM (OMAN)                                         3/14/2001
PK (PAKISTAN)                                     3/14/2001
PW (PALAU)                                        3/14/2001
PA (PANAMA)                                       3/14/2001
PG (PAPUA NEW GUINEA)                             3/14/2001
PY (PARAGUAY)                                     3/14/2001
PE (PERU)                                         3/14/2001
PH (PHILIPPINES)                                  3/14/2001
PN (PITCAIRN)                                     3/14/2001
PL (POLAND)                                       3/14/2001
PT (PORTUGAL)                                     3/14/2001
PR (PUERTO RICO)                                  3/14/2001
QA (QATAR)                                        3/14/2001
RE (REUNION)                                      3/14/2001
RO (ROMANIA)                                      3/14/2001
RU (RUSSIAN FEDERATION)                           3/14/2001
RW (RWANDA)                                 3/14/2001
KN (SAINT KITTS & NEVIS)                    3/14/2001
LC (SAINT LUCIA)                            3/14/2001
VC (SAINT VINCENT & THE GRENADINES)         3/14/2001
WS (SAMOA)                                  3/14/2001
SM (SAN MARINO)                             3/14/2001
ST (SAO TOME & PRINCIPE)                    3/14/2001
SA (SAUDI ARABIA)                           3/14/2001
SN (SENEGAL)                                3/14/2001
SC (SEYCHELLES)                             3/14/2001
SL (SIERRA LEONE)                           3/14/2001
SG (SINGAPORE)                              3/14/2001
SK (SLOVAKIA ,SLOVAK REPUBLIC)              3/14/2001
SI (SLOVENIA)                               3/14/2001
SB (SOLOMON ISLANDS)                        3/14/2001
SO (SOMALIA)                                3/14/2001
ZA (SOUTH AFRICA)                           3/14/2001
ES (SPAIN)                                  3/14/2001
LK (SRI LANKA)                              3/14/2001
SH (ST. HELENA)                             3/14/2001
PM (ST. PIERRE & MIQUELON)                  3/14/2001
SD (SUDAN)                                  3/14/2001
SR (SURINAME)                               3/14/2001
SJ (SVALBARD & JAN MAYEN ISLANDS)           3/14/2001
SZ (SWAZILAND)                              3/14/2001
SE (SWEDEN)                                 3/14/2001
CH (SWITZERLAND)                            3/14/2001
SY (SYRIAN ARAB REPUBLIC)                   3/14/2001
TW (TAIWAN, PROVINCE OF CHINA)              3/14/2001
TJ (TAJIKISTAN)                             3/14/2001
TZ (TANZANIA, UNITED REPUBLIC OF)           3/14/2001
TH (THAILAND)                               3/14/2001
TG (TOGO)                                   3/14/2001
TK (TOKELAU)                                3/14/2001
TO (TONGA)                                  3/14/2001
TT (TRINIDAD & TOBAGO)                      3/14/2001
TN (TUNISIA)                                3/14/2001
TR (TURKEY)                                 3/14/2001
TM (TURKMENISTAN)                           3/14/2001
TC (TURKS & CAICOS ISLANDS)                 3/14/2001
TV (TUVALU)                                 3/14/2001
UG (UGANDA)                                 3/14/2001
UA (UKRAINE)                                3/14/2001
AE (UNITED ARAB EMIRATES)                   3/14/2001
GB (UNITED KINGDOM)                         3/14/2001
US (UNITED STATES)                          3/14/2001
UM (UNITED STATES MINOR OUTLYING ISLANDS)   3/14/2001
UY (URUGUAY)                                3/14/2001
UZ (UZBEKISTAN)                             3/14/2001
VU (VANUATU)                                3/14/2001
VA (VATICAN STATE)                          3/14/2001
VE (VENEZUELA)                              3/14/2001
VN (VIET NAM)                               3/14/2001
VG (VIRGIN ISLANDS (BRITISH))               3/14/2001
VI (VIRGIN ISLANDS (U.S.))                  3/14/2001
WF (WALLIS & FUTUNA ISLANDS)                3/14/2001
EH (WESTERN SAHARA)                         3/14/2001
YE (YEMEN)                                  3/14/2001
YU (YUGOSLAVIA)                             3/14/2001
ZR (ZAIRE)      3/14/2001
ZM (ZAMBIA)     3/14/2001
ZW (ZIMBABWE)   3/14/2001
quality control level                                                                       Last updated

0 (a reasonably complete data set of unspecified quality that consists of research
products subjected to minimum processing in the field and/or in the laboratory by project
staff.)                                                                                                2/3/2001

1 (a complete data set of specified quality that consists of research products subjected
to quality assurance and quality control checks and data management procedures.)                       2/3/2001
2 (a complete, externally consistent data set of specified quality that consists of
research products that have undergone interpretative and diagnostic analyses by the
project staff or user community.)                                                                      2/3/2001

3 (data that have received intense scrutiny through analysis or use in modeling.)                      2/3/2001
9 (data submitted with no indication of the quality control level.)                                    2/3/2001
6
Table focus                           Last updated

Aloft--aircraft                           9/6/2001
Aloft--balloon                            9/6/2001
Aloft--tethersonde                        9/6/2001
Aloft--tower                              9/6/2001
Indoor                                   8/24/2004
Surface--fixed                            9/6/2001
Surface--mobile                           9/6/2001
Remote sensed profile--from surface       9/6/2001
Remote sensed profile--from aloft         9/6/2001
Horizontally integrated                  7/21/2004
Vertically integrated                     9/6/2001
Metadata                                  9/6/2001
Table column name type                   Last updated Status

Variable                                    5/12/2001
Flag--NARSTO                                 9/6/2001
Flag--Supersites detailed                    9/6/2001
Flag--study                                  9/6/2001
Flag--exceptional event                      9/6/2001
Detection limit                              5/3/2002
Statistic--maximum                          9/19/2002
Statistic--minimum                          9/19/2002
Statistic--number of observations (N)       9/19/2002
Statistic--standard deviation               9/19/2002
Statistic--5th percentile                   9/19/2002
Statistic--10th percentile                 11/21/2002
Statistic--90th percentile                 11/21/2002
Statistic--95th percentile                  9/19/2002
Uncertainty--accuracy                       9/19/2002
Uncertainty--precision                      9/19/2002
Uncertainty--confidence interval (+/-)      9/19/2002
Uncertainty--lower confidence bound         9/19/2002
Uncertainty--upper confidence bound         9/19/2002
Uncertainty--combined standard              9/19/2002
Uncertainty--expanded                       9/19/2002
Table format
type           Last updated

Char                2/3/2001
Int                 2/3/2001
Decimal             2/3/2001
Date                2/3/2001
Time                2/3/2001
Scientific         5/12/2001
Observation type          Last Updated


Cloud/fog                        2/3/2001
Flow                             2/3/2001
Gas                              2/3/2001
Meteorology                      2/3/2001
Particles                        2/3/2001
Particles+gas                    2/3/2001
Precipitation chemistry          2/3/2001
Radiation                        2/3/2001
Supplementary data               4/5/2001
Pending assignment              8/23/2004
Field sampling or measurement principle                                             Last updated      Status

----CLOUD/FOG/PRECIPITATION CHEMISTRY----
CCN (Cloud condensation nuclei)                                                            2/3/2001
Cloud/fog water--active                                                                    2/3/2001
Cloud/fog water--passive                                                                   2/3/2001
Droplet light scattering                                                                  2/18/2001
Wet/dry precipitation sampler                                                              2/3/2001
----FLOW----                                                                               2/3/2001
Critical orifice                                                                           2/3/2001
Critical orifice/rotometer                                                                5/16/2002
Magnahelic gauge                                                                           2/3/2001
Manometer                                                                                  2/3/2001
Mass flow controller                                                                       2/3/2001
Mass flowmeter                                                                             2/3/2001
Orifice meter                                                                             7/21/2004
Rotometer                                                                                  2/3/2001
---- GAS ----                                                                              2/3/2001
Absorbing solution                                                                         2/3/2001
Bag                                                                                        2/3/2001
Canister                                                                                   2/3/2001
Cartridge                                                                                 3/28/2001
Cartridge+scrubber                                                                         2/3/2001
Cartridge+scrubber+ultraviolet absorption                                                  1/7/2003   Requested by Bill
CIMS (Chemical ionization mass spectrometry)                                               9/6/2001
Chemiluminescence                                                                          2/3/2002
Coil Hantz fluorescence                                                                    7/2/2002
Denuder--annular+filter(s)                                                                 2/3/2002
Denuder--cylinder+filter(s)                                                                2/3/2002
Denuder--parallel plates+filter(s)                                                         2/3/2002
DACOM (Differential absorption CO measurement)                                             9/6/2001
Electrochemical oxidation of iodide                                                      10/16/2003
Enzymatic derivitization with fluorometric detection                                       9/6/2001
Fenton derivitization with fluorometric detection                                          9/6/2001
FID with cutter (Flame ionization detection)                                             10/27/2004
Filter pack--multiple filters                                                              2/3/2001
Fluorescence--other (see metadata)                                                        6/17/2003
FTIR (Fourier transform infrared spectrometer)                                            7/21/2004
GC (Gas chromatograph)                                                                     2/3/2001
GC/MS (Gas chromatograph/mass spectrometer)                                                2/3/2001
GC-ECD (Gas chromatography with electron capture detection)                                9/6/2001
GC-FID (Gas chromatography with flame ionization detection)                                9/6/2001
GC-PDD (Gas chromatography with pulse discharge detection)                               10/27/2004
Gold cartridge--cold vapour atomic fluorescence                                            9/6/2001
Hantz fluorescence                                                                         3/1/2002
HRP (horseradish peroxidase)-catalyzed thiamine oxidation thiochrome fluorescence          3/1/2002
Infrared absorption                                                                        2/3/2001
LIF (Laser induced fluorescence)                                                           9/6/2001
Lidar (Light detection and ranging)                                                        9/6/2001
Liquid chromatography with fluorometric detection                                          9/6/2001
NDIR (Nondispersive infrared)                                                              2/3/2001
DOAS (Optical attenuation--differential optical absorption spectrometer)                   9/6/2001
Photofragmentation                                                          9/6/2001
Photolysis                                                                  9/6/2001
PTR-MS (Proton transfer mass spectrometry)                                  9/6/2001
PUF (Polyurethane foam)                                                     2/3/2001
Pulsed fluorescence                                                         9/6/2001
Radical amplifier                                                           2/3/2001
Tandem mass spectrometer                                                    2/3/2001
TDLAS (Tunable diode laser absorption)                                      9/6/2001
Two-photon laser induced fluorescence (LIF)                                 9/6/2001
Ultraviolet absorption                                                      2/3/2001
UV fluorescence                                                           10/29/2004
Vacuum UV resonance fluorescence (VUV)                                      9/6/2001
WEDD (Wet effluent diffusion denuder)                                     11/24/2004
---- METEOROLOGY ----                                                       2/3/2001
Acoustic radar                                                              2/3/2001
Acoustic sounder                                                            2/3/2001
Aircraft instrumentation                                                    6/4/2002
Anemometer--cup                                                             2/3/2001
Anemometer--propeller                                                       2/3/2001
Anemometer--sonic                                                           2/3/2001
Barometer--aneroid                                                         8/14/2001
Barometer--mercury                                                         8/14/2001
Capacitance thin film humidity                                              2/3/2001
Ceilometer                                                                  2/3/2001
Chilled mirror                                                             5/18/2002
Gust probe                                                                  8/4/2002
Hygrometer                                                                  2/3/2001
Lidar (Light detection and ranging)                                         2/3/2001
Lyman alpha absorption                                                     5/18/2002
Magnetic compass                                                          10/16/2003
Pressure transducer                                                       10/27/2004
Pyranometer                                                                 2/3/2001
Pyrheliometer                                                               2/3/2001
Radar                                                                       2/3/2001
Radiometer                                                                  2/3/2001
Rain gauge                                                                  2/3/2001
Snow ruler                                                                  2/3/2001
Thermistor-based temperature sensor                                         2/3/2001
Thermometer--liquid in glass                                               8/14/2001
Tipping bucket rain gauge                                                   2/3/2001
Visibility sensor                                                           2/3/2001
Wetness sensor                                                              2/3/2001
Wind direction vane                                                         2/3/2001
----OPTICAL PROPERTIES----                                                  9/6/2001
Direct and diffuse radiation--shadowband radiometer                         9/6/2001
Optical absorption                                                          2/3/2001
DOAS (Optical attenuation-differential optical absorption spectrometer)     9/6/2001
Optical backscatter--lidar (Light detection and ranging)                    9/6/2001
Optical extinction--transmissometers                                        9/6/2001
Optical particle counter/size spectrometer                                  9/6/2001
Optical particle counter/DMA (Differential mobility analyzer)               5/1/2002
Optical radiances--teleradiometers                                          9/6/2001
Optical scattering--integrating nephelometer                                       9/6/2001
Optical transmission--sun-tracking photometer                                      9/6/2001
PSAP (Particle soot absorption photometer)                                       10/31/2001
PSAP with sampling control (Particle soot absorption photometer)                 10/31/2001
Optical attenuation--aethalometer                                                  9/6/2001
---- PARTICLES ----                                                                2/3/2001
Aerodynamic particle sizer                                                         9/6/2001
AMS (Aerosol mass spectrometer--single particle)                                   9/6/2001
ATOFMS (Aerosol time-of-flight mass spectrometry--single particle)                 9/6/2001
APCM (Ambient particulate carbon monitor)                                          9/6/2001
Automated particulate nitrate monitor                                              9/6/2001
Automated particulate sulfate monitor                                              9/6/2001
BAM (Beta attenuation monitor)                                                     9/6/2001
CAMMS (Continuous ambient mass monitor system)                                     9/6/2001
CNC (Condensation nucleus counter)                                                8/29/2002
Continuous ammonia analyzer                                                        9/6/2001
Continuous sulfate analyzer                                                        9/6/2001
Denuder+filter(s)                                                                  7/2/2002
DMA (Differential mobility analyzer)                                               9/6/2001
EPI (Epiphaniometer)                                                              2/25/2002
Filter pack--multiple filters                                                      2/3/2001
FPD (Flame photometric detection)                                                  9/6/2001
FRM (Federal Reference Method)                                                     2/3/2001
FSSP (Forward scattering spectrometer probe)                                       8/4/2002
Gravimetric                                                                        2/3/2001
Heterogeneous nucleation--condensation particle counter (CPC)                      9/6/2001
Hygroscopic growth/impaction                                                       2/3/2001
Impactor                                                                           2/3/2001
ELPI (Impactor--electrical low pressure)                                           9/6/2001
In-situ thermal/optical carbon analyzer                                            9/6/2001
LIPM (Laser integrating plate method)                                              9/6/2001
Lidar (Light detection and ranging)                                                2/3/2001
Nephelometer                                                                       2/3/2001
OC/EC monitor (Organic carbon/elemental carbon)                                    2/3/2001
PALMS (Particle analysis by laser mass spectrometry--single particle)              9/6/2001
Particles in liquid sampler                                                        2/5/2003
PAS (Phototoelectric aerosol sensor)                                              6/17/2003
PCASP (Passive cavity aerosol spectrometer probe)                                  8/4/2002
Piezoelectric microbalance                                                         9/6/2001
Pressure drop                                                                      2/3/2001
RSMS (Rapid single-particle mass spectrometer--single particle)                    9/6/2001
RAMS (Real-time total ambient mass sampler)                                        9/3/2001
SEM/XRF (Scanning electron microscope with X-ray fluorescence-single particle)     9/6/2001
SMPS (Scanning mobility particle sizer)                                            9/6/2001
SEAS (Semi-continuous elements in aerosol system)                                  9/6/2001
Single filter                                                                      2/3/2001
Streaker                                                                           9/6/2001
TEOM (Tapered element oscillating microbalance)                                    9/6/2001
Total carbon analyzer                                                              9/6/2001
---- PARTICLES+GAS ----                                                            2/3/2001
Continuous gas and particle speciation monitor                                     9/6/2001
Denuder+filter(s)                                                                  7/2/2002
Filter pack--multiple filters                                                        9/6/2001
Single filter                                                                        2/3/2001
----PRECIPITATION CHEMISTRY----                                                      2/3/2001
NOTE: Choose an entry from the “Cloud/fog/precipitation chemistry” section above     2/3/2001
----RADIATION----                                                                    2/3/2001
Infrared thermometer                                                                5/22/2002
Pyranometer                                                                          2/3/2001
Pyrheliometer                                                                        2/3/2001
Radar                                                                                2/3/2001
Radiometer                                                                           2/3/2001
---- SUPPLEMENTARY DATA ----                                                         2/3/2001
Aircraft instrumentation                                                             6/4/2002
Data logger                                                                          2/3/2001
Derived variable--see *TABLE COLUMN EXPLANATION OF DERIVED VARIABLE                 9/19/2002
GPS (Global Positioning System)                                                    10/16/2003
Sample history form                                                                  2/3/2001
Not applicable                                                                       2/3/2001
Pending assignment                                                                   2/3/2001
Comments
Requested by Les Hook for G1
Requested by Bill




Requested by PNW2001




Mod. Stephen S.
Dana
Requested by PNW2001
Particle size - lower bound in micormeters             Last updated

{enter value, e.g., 0, 0.003}                              2/3/2001
Undetermined                                               2/3/2001
Varies--see variable Particles: lower diameter bound      9/24/2001
Not applicable                                             2/3/2001
Pending assignment                                         2/3/2001
Particle size - median                            Last updated


{enter value, e.g., 0.003}                             9/6/2001
Varies--see variable Particles: median diameter       9/24/2001
Varies--see variable Particles: size                  9/24/2001
Undetermined                                           2/3/2001
Not applicable                                         2/3/2001
Pending assignment                                     2/3/2001
Particle size - upper bound in micormeters             Last updated


{enter value, e.g., 0.003}                                 9/6/2001
Varies--see variable Particles: upper diameter bound     9/24/2001
Undetermined                                               2/3/2001
Not applicable                                             2/3/2001
Pending assignment                                         2/3/2001
Medium                                                                             Last updated


---- FILTER MEDIA ----
Cellulose                                                                                 2/3/2001
Cellulose+nylon                                                                           2/3/2001
Glass fiber                                                                               2/3/2001
Nylazorb                                                                                  2/3/2001
Nylon                                                                                     2/3/2001
PUF (Polyurethane foam)                                                                   2/3/2001
Quartz                                                                                    2/3/2001
Quartz+glass fiber                                                                        2/3/2001
Teflon                                                                                    2/3/2001
Teflon-coated glass                                                                       1/7/2003
Teflon-coated quartz                                                                      2/3/2001
Teflon membrane                                                                           2/3/2001
Teflon+nylon                                                                              2/3/2001
Filter--other                                                                             9/6/2001
Filters--multiple not impregnated (see metadata)                                          9/6/2001
Filters--multiple impregnated (see metadata)                                              9/6/2001
Filters--multiple--combination of impregnated and non-impregnated (see metadata)          9/6/2001
---- COLLECTION MEDIA ----                                                                2/3/2001
Charcoal                                                                                  2/3/2001
Coating or absorbing solution                                                            7/21/2004
Gold                                                                                      2/3/2002
Impaction surface                                                                         2/3/2002
PUF (Polyurethane foam)                                                                   2/3/2001
Silica                                                                                    2/3/2002
Tenax                                                                                     2/3/2001
XAD                                                                                       9/6/2001
---- COMBINED FILTER AND COLLECTION MEDIA -----
Filter(s)+PUF (Polyurethane foam)                                                        7/21/2004
---- OTHER -----                                                                          2/3/2001
Filter(s) and impaction surface (see metadata)                                           3/31/2004
Not applicable                                                                            2/3/2001
Pending assignment                                                                        2/3/2001
Coating or absorbing solution    Last updated



Citric acid                             2/3/2001
DCM                                     2/3/2001
DNPH (Dinitrophenyl hydrazine)          2/3/2001
H2O2                                    2/3/2002
H2SO4                                 10/27/2004
K2CO3                                   2/3/2001
KCl                                     2/3/2001
KOH                                     2/3/2001
Na2CO3                                 8/15/2001
NaCl                                  10/27/2004
NaF                                     2/3/2001
Nal                                     2/3/2001
NaOH                                    2/3/2001
Oxalic acid                             2/3/2001
Water                                   2/3/2002
None                                    2/3/2001
Not applicable                          2/3/2001
Pending assignment                      2/3/2001
Units                                              Last updated    Status   Notes
                                                                            References: http://physics.nist.gov/cuu/Units/units.
---- MIXING RATIO (MOLE FRACTION) ----
g/kg (gram per kilogram)                                5/9/2002
ppbv (part per billion by volume)                       2/3/2002
ppmv (part per million by volume)                       2/3/2002
ppmvC (part per million Carbon by volume)               5/9/2002
pptv (part per trillion by volume)                      2/3/2002
ppbvC (part per billion Carbon by volume)               2/3/2002
mol/mol (mole per mole)                                 2/3/2002            SI unit, 1 nanomol/mol = 1 ppbv
nmol/mol (nanomole per mole)                           7/21/2004
---- CONCENTRATION ----
g/m3 (gram per cubic meter)                           10/16/2003            For 'Humidity: absolute'
mol/L (mole/liter)                                      2/3/2002
mg/L (milligram per liter)                              2/3/2002
ng/m3 (nanogram per cubic meter)                        2/3/2002
pg/ml (picogram per milliliter)                         5/9/2002
pg/m3 (picogram per cubic meter)                        2/3/2002
ug/m3 (microgram per cubic meter)                       2/3/2002
umol/L (micromole per liter)                            1/7/2003
umol/m3 (micromole per cubic meter)                   11/24/2004
---- OTHER PARTICLE MEASUREMENT ----
cm2/cm3 (square centimeter per cubic centimeter)        2/5/2003            Stephen S.
cm3/cm3 (cubic centimeter per cubic centimeter)         2/5/2003            Stephen S.
dN/d(lnDp)                                              8/4/2002
dN/d(logDp)                                             8/4/2002
g/cm3 (gram per cubic centimeter)                       5/9/2002
number/cm3 (number per cubic centimeter)                2/3/2002
number/m3 (number per cubic meter)                      5/9/2002
um3/cm3 (cubic micrometer per cubic centimeter)         2/3/2002
molecule/cm3 (molecule per cubic centimeter)            2/3/2002
---- AREA ----
absorbance area units                                   8/4/2002            Requested by Gary M for FTIR
cm2 (square centimeter)                                 8/4/2002            Requested by Bill Sukloff
m2/g (square meter per gram)                            8/4/2002            Requested by Bill Sukloff
um2/cm3 (square micrometer per cubic centimeter)        2/3/2002
---- TEMPERATURE ----
deg C (degree Celsius)                                  2/3/2002
K (kelvin)                                              8/4/2002
---- DIRECTION ----
degree from true north                                  2/3/2002
---- LENGTH/ALTITUDE/HEIGHT----
1/cm (inverse centimeter)                               8/8/2002
km (kilometer)                                          2/3/2002
m (meter)                                               2/3/2002
mm (millimeter)                                         2/3/2002
nm (nanometer)                                          2/3/2002
1/km (inverse kilometer)                              10/16/2003
1/m (inverse meter)                                     8/8/2002
1/Mm (inverse megameter)                                8/8/2002
um (micrometer)                                         5/9/2002
---- VOLUME ----
cc (cubic centimeter)                                   1/3/2003
mL (milliliter)                                        7/21/2004
m3 (cubic meter)                                        2/3/2002
---- FLOW ----
L/min (liter per minute)                                8/4/2002
m3/h (cubic meter per hour)                            7/29/2002
---- TIME ----
yyyy/mm/dd                                          2/3/2002
hh:mm                                               2/3/2002
hh:mm:ss                                           3/28/2002
hh:mm:ss.s                                          8/4/2002                                Decimal seconds. Usable also for more than one d
d (day)                                             2/3/2002
h (hour)                                            2/3/2002
min (minute)                                        2/3/2002
s (second)                                          2/3/2002
---- PRESSURE ----
hPa (hectopascal)                                   2/3/2002
kPa (kilopascal)                                    2/3/2002
Pa (pascal)                                         2/3/2002
mb (millibar)                                       2/3/2002                                Non-SI
---- SPEED ----
km/h (kilometer per hour)                           2/3/2002
m/s (meter per second)                              2/3/2002
---- FREQUENCY ----
Hz (hertz)                                          2/3/2002
---- FORCE ----
N (newton)                                          2/3/2002
---- ENERGY ----
joule                                               2/3/2002
kJ/m2 (kilojoule per square meter)                 7/21/2004                                Elton Chan
---- POWER ----
W (watt)                                            2/3/2002
W/m2 (watt per square meter)                        2/3/2002
W/m2/mm (watt per square meter per millimeter)     8/29/2002                                For pnw2001
mW/m3 (milliwat per cubic meter)                    2/3/2002
---- ELECTRIC CHARGE ----
C (coulomb)                                         2/3/2002
---- LOCATION ----
decimal degree                                     3/18/2002
---- OTHER ----
dalton (atomic mass unit)                           8/4/2002                                For SPMS - revised compromise format
dB (decibel)                                        2/5/2003                                Req. Carlos
dimensionless                                     10/29/2004
DV (deciview)                                       8/4/2002
fA (femptoampere)                                  4/17/2003                                For Dana- PAHs
kg/m/s2 (kilogram per meter per second squared)   10/16/2003
molecule/cm2 (molecule per square centimeter)      7/21/2004
mV (millivolt)                                      8/4/2002                                For SPMS
optical depth units                                2/12/2003                                For optical depth
% (percent)                                         2/3/2002
0/00 (per mil)                                     7/21/2004 Same as 'part per thousand'.   Needed for radioisotopes
pH units                                            5/9/2002
proportion                                          8/4/2002                                For SPMS
volt                                                5/9/2002
None                                                2/3/2002
Not applicable                                      2/3/2002
Pending assignment                                  2/3/2002
 http://physics.nist.gov/cuu/Units/units.html; Standard for Metric Practice, Pub: American Society for Testing and Materials, 1980. E 380-79




nomol/mol = 1 ppbv




by Gary M for FTIR
onds. Usable also for more than one decimal place. BEWARE of Excel behavior with decimal seconds; check results frequently.




revised compromise format
Wavelength-lower bound (nm)                    Last updated


{enter value, e.g., 450}                            2/3/2002
Varies--see variable Wavelength: lower bound       9/24/2001
Not applicable                                     3/21/2001
Pending assignment                                 3/21/2001
Wavelength (nm)                   Last updated

{enter value, e.g., 450}                 2/3/2002
Varies--see variable Wavelength         9/24/2001
Not applicable                          3/21/2001
Pending assignment                      3/21/2001
Wavelength-upper bound (nm)                    Last updated


{enter value, e.g., 450}                            2/3/2002
Varies--see variable Wavelength: upper bound       9/24/2001
Not applicable                                     3/21/2001
Pending assignment                                 3/21/2001
Detection limit (same units as the variable)            Last updated


{enter value, e.g., 0.01}                                      5/28/2002
Varies--see Detection limit column                             5/28/2002
Varies--see variable Detection limit: sample-level             5/28/2002
Varies--see variable Detection limit: subsample-level          5/28/2002
Not applicable                                                 5/28/2002
Not available                                                 10/27/2004
Pending assignment                                             5/28/2002
Sampling height in meters above ground level          Last updated


{enter value, e.g., 0, 50}                                    4/9/2001
Undetermined                                                  4/9/2001
Varies--see variable Height: above ground                    9/24/2001
Varies--see variable Altitude: above mean sea level          5/27/2002
Varies by site--see Site information table                   7/21/2004
Not applicable                                                4/9/2001
Pending assignment                                            4/9/2001
Inlet type                         Last updated      Status   Comments

---- PARTICLES ----
Cyclone                                   2/3/2001
Diffuser cone                             8/4/2002            Requested by PNW2001
Elutriator                                9/6/2001
Hat or hood                               2/3/2001
Impactor--direct                          9/6/2001
Impactor--virtual/concentrator            9/6/2001
Impactor--elutriator combination          9/6/2001
Isokinetic                              10/16/2003
None--open-face filter                    9/6/2001
Open conductive tubing                   6/17/2003            LA
Selective filtration                      9/6/2001
---- GAS ----
Canister valve opening                    9/6/2001
Filter in front of sampling line          9/6/2001
Open sampling line                        9/6/2001
Stacked filters                          7/21/2004
Not applicable                            2/3/2001
Pending assignment                        2/3/2001
Sampling humidity or temperature control                    Last updated


Diffusion dryer                                                 2/3/2001
Humidification                                                  2/3/2001
Humidification with temperature condition at ambient          2/21/2002
Humidification with temperature conditioning at 50 deg. C     3/11/2003
Manual control (see metadata)                                   2/5/2003
Nafion dryer                                                    2/3/2001
Nafion dryer with temperature conditioning at 30 deg. C       3/11/2003
Temperature conditioning at 20 deg. C                         3/23/2001
Temperature conditioning at 25 deg. C                         3/23/2001
Temperature conditioning at 30 deg. C                           2/3/2001
Temperature conditioning at 40 deg. C                           2/3/2001
Temperature conditioning at 50 deg. C                           2/3/2001
Temperature conditioning at ambient                             2/3/2001
Temperature controlled                                        3/28/2001
Other (see metadata)                                            2/3/2001
None                                                            2/3/2001
Not applicable                                                  2/3/2001
Pending assignment                                              2/3/2001
Laboratory analytical method                                         Last updated

AAS (Atomic absorption spectrometer)                                    2/3/2001
Analytical balance                                                    10/30/2002
Atomic force microscopy                                                 2/3/2001
Capillary electrophoresis                                              7/18/2001
Colorimetry--Greiss                                                     9/6/2001
Colorimetry--indophenol                                                 9/6/2001
Colorimetry--salicylate                                               11/21/2002
Colorimetry--Thorin                                                     9/6/2001
Cytokine response                                                       7/2/2002
Fluorescence--other (see metadata)                                      2/3/2002
FTIR (Fourier transform infrared spectrometer)                         8/15/2001
GC (Gas chromatograph)                                                  2/3/2001
GC-ECD (Gas chromatograph with electron capture detection)             7/21/2004
GC/MS (Gas chromatograph/mass spectrometer)                             2/3/2001
GC-PDD (Gas chromatography with pulse discharge detection)            11/21/2002
IBA (Ion beam analysis)                                                 2/3/2001
IC (Ion chromatograph)                                                  2/3/2001
ICP/AES (Inductively coupled plasma--atomic emission spectrometry)      9/6/2001
ICP/MS (Inductively coupled plasma--mass spectrometry)                  9/6/2001
INAA (Instrumental neutron activation analysis)                         2/3/2001
IRMS (Isotope ratio mass spectrometry)                                10/27/2004
Infrared absorption                                                    10/1/2002
IR/MS (Infrared mass spectrometer)                                      2/3/2001
Isotope ratio mass spectrometer                                       11/21/2002
Laser-induced fluorescence                                              2/3/2002
LC (Liquid chromatograph)                                               2/3/2001
LC/MS (Liquid chromatograph/mass spectrometry)                          2/3/2001
Mass spectrometer                                                       2/3/2001
Microbalance                                                            2/3/2001
Oxidation conversion to CO2                                           10/27/2004
PESA (Proton Elastic Scattering Analysis)                              7/21/2004
pH meter                                                              10/30/2002
PIXE (Particle induced X-ray excitation)                                2/3/2001
Raman spectroscopy                                                      2/3/2001
Reactive oxygen species response                                        2/3/2001
Scanning electron microscopy--computer controlled operation             9/6/2001
Scanning electron microscopy--manual operation                          9/6/2001
SXRF (Synchotron X-ray fluorescence)                                    2/3/2001
Thermal analysis of liquid samples                                      1/3/2003
Thermooptical reflection                                                2/3/2001
Thermooptical transmission                                              2/3/2001
Transmission EM (Electron microscopy)                                   2/3/2001
XRF (X-ray fluorescence)                                                2/3/2001
Derived                                                                7/21/2004
Not applicable                                                          2/3/2001
Pending assignment                                                      2/3/2001
Sample preparation                       Last updated


Acid digestion                               2/3/2001
Acid extraction                              2/3/2001
Base extraction                           10/27/2004
Filtration                                   1/3/2003
Fractionation by sequential extraction     7/21/2004
Organic extraction                           2/3/2001
Temperature and humidity equilibration     4/19/2002
Thermal desorption                           2/3/2001
Total digestion                              2/3/2001
Water extraction                             2/3/2001
Water+base extraction                     10/27/2004
Not applicable                               2/3/2001
Pending assignment                           2/3/2001
Blank corrected       Last updated

Blank corrected           2/3/2001
Not blank corrected       2/3/2001
Not applicable            2/3/2001
Pending assignment        2/3/2001
Volume standardization             Last updated

0 deg. C; 1 atmosphere                 2/3/2001
0 deg. C; ambient pressure             2/3/2001
20 deg. C; 1 atmosphere                2/3/2001
20 deg. C; ambient pressure            2/3/2001
25 deg. C; 1 atmosphere                2/3/2001
25 deg. C; ambient pressure            2/3/2001
30 deg. C; ambient pressure          10/30/2002
Ambient temperature and pressure       2/3/2001
Not applicable                         2/3/2001
Pending assignment                     2/3/2001
State or province code    Last updated Status   Notes

Not applicable               3/15/2001
---- UNITED STATES ----
AL                          10/23/2000
AK                          10/23/2000
AZ                          10/23/2000
AR                          10/23/2000
CA                          10/23/2000
CO                          10/23/2000
CT                          10/23/2000
DE                          10/23/2000
DC                          10/23/2000
FL                          10/23/2000
GA                          10/23/2000
GU                          10/23/2000
HI                          10/23/2000
ID                          10/23/2000
IL                          10/23/2000
IN                          10/23/2000
IA                          10/23/2000
KS                          10/23/2000
KY                          10/23/2000
LA                          10/23/2000
ME                          10/23/2000
MD                          10/23/2000
MA                          10/23/2000
MI                          10/23/2000
MN                          11/21/2002
MS                          10/23/2000
MO                          10/23/2000
MT                          10/23/2000
NE                          10/23/2000
NV                          10/23/2000
NH                          10/23/2000
NJ                          10/23/2000
NM                          10/23/2000
NY                          10/23/2000
NC                          10/23/2000
ND                          10/23/2000
OH                          10/23/2000
OK                          10/23/2000
OR                          10/23/2000
PA                          10/23/2000
PR                          10/23/2000
RI                          10/23/2000
SC                          10/23/2000
SD                          10/23/2000
TN                          10/23/2000
TX                          10/23/2000
UT                          10/23/2000
VT                          10/23/2000
VA                          10/23/2000
VI                          10/23/2000
WA                          10/23/2000
WV                          10/23/2000
WI                          10/23/2000
WY                          10/23/2000
---- CANADA ----
AB                 10/23/2000
BC                 10/23/2000
MB                 10/23/2000
NB                 10/23/2000
NL                  7/21/2004
NT                 10/23/2000
NS                 10/23/2000
NU                 10/23/2000
ON                 10/23/2000
PE                 10/23/2000
PQ                 10/23/2000
SK                 10/23/2000
YT                 10/23/2000
---- MEXICO ----
AG                  6/17/2003
BC                  6/17/2003
BS                  6/17/2003
CA                  6/17/2003
CH                  6/17/2003
CL                  6/17/2003
CO                  6/17/2003
CU                  6/17/2003
DF                  6/17/2003
DG                  6/17/2003
GR                  6/17/2003
GT                  6/17/2003
HG                  6/17/2003
JA                  6/17/2003
ME                  6/17/2003
MI                  6/17/2003
MO                  6/17/2003
NA                  6/17/2003
NL                  6/17/2003
OA                  6/17/2003
PU                  6/17/2003
QO                  6/17/2003
QR                  6/17/2003
SI                  6/17/2003
SL                  6/17/2003
SO                  6/17/2003
TA                  6/17/2003
TL                  6/17/2003
TP                  6/17/2003
VE                  6/17/2003
YU                  6/17/2003
ZA                  6/17/2003
Station land use           Last updated: Notes

Agricultural                   2/3/2001
Airport                      10/24/2001   Not in AIRS list
Blighted area                10/24/2001   Modified from AIRS list
Commercial                     2/3/2001
Desert                         2/3/2001
Forest                         2/3/2001
Industrial                     2/3/2001
Military reservation         10/24/2001
Mobile                         2/3/2001
Remote park                  10/24/2001   Not in AIRS list
Residential                    2/3/2001
Single point source area     10/24/2001   Not in AIRS list
Snowfield                     3/15/2001   Not in AIRS list
Urban park                   10/24/2001   Not in AIRS list
Other                          2/3/2001
Not available                  2/3/2001
Station location setting Last updated:

Rural                        2/3/2001
Suburban                     2/3/2001
Urban and center city        2/3/2001
Other                        2/3/2001
Not available                2/3/2001
Sampling frequency of data in main table   Last Updated: Status


Same as sampling interval                      2/2/2001
Every minute                                   2/2/2001
Every 5 minutes                             10/27/2004
Every hour                                     2/2/2001
2 times per day                              6/17/2003
Every day                                      2/2/2001
1 day in 3                                     2/2/2001
1 day in 6                                     2/2/2001
1 day in 12                                    2/2/2001
2 days per week (Wed., Sat.)                   9/6/2001
Every week                                     2/2/2001
Every 4 weeks                                7/21/2004
Every month                                  7/21/2004
Variable frequency                          11/21/2002
Not applicable                                 2/2/2001
Sampling interval as reported in main table   Last Updated:


1 second                                           2/2/2001
5 second                                           2/2/2001
10 second                                        10/27/2004
1 minute                                           2/2/2001
5 minute                                           2/2/2001
10 minute                                         3/14/2001
15 minute                                          2/2/2001
30 minute                                         3/15/2001
1 hour                                             2/2/2001
3 hour                                             2/2/2001
4 hour                                             2/2/2001
4 h day/8 h night                                10/27/2004
8 hour                                             2/2/2001
8 h day/16 h night                                7/21/2004
12 hour                                            2/2/2001
24 hour                                            2/2/2001
1 week                                             2/2/2001
28 day                                            7/21/2004
1 month                                           7/21/2004
Variable interval                                  9/6/2002
Grab                                               2/2/2001
Not applicable                                     2/2/2001
Lat/lon (geospatial) reference method                     Date added

ETRS89 (European Terrestrial Reference System 1989)          8/7/2001
NAD27 (North American Datum 1927)                            8/2/2001
NAD83 (North American Datum 1983)                            8/2/2001
WGS84 (World Geodetic System 1984)                           8/2/2001
WGS84 (G730) (World Geodetic System 1984, upgrade G730)     8/14/2001
WGS84 (G873) (World Geodetic System 1984, upgrade G873)     8/26/2004
Pending assignment                                           8/2/2001
Description

European Terrestrial Reference System of 1989
North American Datum of 1927
North American Datum of 1983
World Geodetic System of 1984
World Geodetic System of 1984-upgrade made at start of GPS Week 730
World Geodetic System of 1984-upgrade made at start of GPS Week 873
Placeholder while PI determines the correct value
Lat/lon method                                       Date added

Address Matching-Block Face                             8/2/2001
Address Matching-Digitized                              8/2/2001
Address Matching-House Number                           8/2/2001
Address Matching-Nearest Intersection                   8/2/2001
Address Matching-Other                                  8/2/2001
Address Matching-Primary Name                           8/2/2001
Address Matching-Street Centerline                      8/2/2001
Census Block-1990-Centroid                              8/2/2001
Census Block/Group-1990-Centroid                        8/2/2001
Census Block/Tract-1990-Centroid                        8/2/2001
Census-Other                                            8/2/2001
Classical Surveying Techniques                          8/2/2001
GPS Carrier Phase Kinematic Relative Position           8/2/2001
GPS Carrier Phase Static Relative Position              8/2/2001
GPS Code (Pseudo Range) Differential                    8/2/2001
GPS Code (Pseudo Range) Precise Position                8/2/2001
GPS Code (Pseudo Range) Standard Position (SA Off)      8/2/2001
GPS Code (Pseudo Range) Standard Position (SA On)       8/2/2001
GPS, with Canadian Active Control System                8/2/2001
GPS-Unspecified                                         8/2/2001
Interpolation - Digital Map Source (TIGER)              8/2/2001
Interpolation-MSS                                       8/2/2001
Interpolation-Map                                       8/2/2001
Interpolation-Other                                     8/2/2001
Interpolation-Photo                                     8/2/2001
Interpolation-SPOT                                      8/2/2001
Interpolation-Satellite                                 8/2/2001
Interpolation-TM                                        8/2/2001
Loran C                                                 8/2/2001
Public Land Survey-Eighth Section                       8/2/2001
Public Land Survey-Footing                              8/2/2001
Public Land Survey-Quarter Section                      8/2/2001
Public Land Survey-Section                              8/2/2001
Public Land Survey-Sixteenth Section                    8/2/2001
Unknown                                                 8/2/2001
ZIP Code-Centroid                                       8/2/2001
ZIP+2 Centroid                                          8/2/2001
ZIP+4 Centroid                                          8/2/2001
                                                        8/2/2001
Site nature   Last updated

Fixed                        3/8/2001
Mobile                       3/8/2001
Site location type               Last updated

Background ambient monitoring                   3/8/2001
Boundary                                        3/8/2001
Extreme downwind                                3/8/2001
Gradient                                        3/8/2001
Max ozone concentrations                        3/8/2001
Max precursor emissions Impact                  3/8/2001
Max ozone precursor                             3/8/2001
Max primary PM                                  3/8/2001
Max secondary PM                                3/8/2001
Representative concentration                    3/8/2001
Routine                                         3/9/2001
Source                                          3/8/2001
Transport                                       3/8/2001
Upwind background                               3/8/2001
Visibility                                      3/8/2001
Other                                           3/8/2001
Unknown                                         3/8/2001
Site population class         Last updated

< 1000 inhabitants                           3/8/2001
1000-100,000 inhabitants                     3/8/2001
0.1-0.5 million inhabitants                  3/8/2001
0.5-1 million                                3/8/2001
1-2 million                                  3/8/2001
2 million                                    3/8/2001
Unknown                                      3/8/2001
Site type         Last updated

Air quality                      3/8/2001
Anchor                           3/8/2001
Met/Air quality                  3/8/2001
Meteorological                   3/8/2001
Satellite                        3/8/2001
Traffic                          3/8/2001
Other                            3/8/2001
Unknown                          3/8/2001
Site monitoring support             Last updated

Aircraft                                            3/8/2001
Balloon                                             3/8/2001
Boat                                                3/8/2001
Building roof (<=10 m height)                      3/14/2001
Building roof (10.1-50 m height)                   3/14/2001
Building roof (50.1-100 m height)                  3/14/2001
Building roof (>=100 m height)                     3/14/2001
Buoy                                                3/8/2001
Ground-based site (<=2 m)                          3/14/2001
Motor vehicle                                       3/8/2001
Satellite                                           3/8/2001
Tower (2.1-10 m height)                            3/14/2001
Tower (10.1-50 m height)                           3/14/2001
Tower (50.1-100 m height)                          3/14/2001
Tower (>100 m height)                              3/14/2001
Trailer (parked)                                    3/8/2001
Train                                               3/8/2001
Multiple supports                                   3/8/2001
Other                                               3/8/2001
Unknown                                             3/8/2001
Site topography   Last updated

Bluffs                            3/8/2001
Coastal                           3/8/2001
Desert                            3/8/2001
Flat lands                       7/21/2004
Foothill                          3/8/2001
Mountainous                       3/8/2001
Plateau                           3/8/2001
Prairie (flat)                    3/8/2001
Riparian                          3/8/2001
Rolling hills                     3/8/2001
Valley                            3/8/2001
Water (fresh)                    3/14/2001
Water (saline)                   3/14/2001
Unknown                           3/8/2001
Site monitoring duration                  Last updated

Long term (more than 5 years)                            3/14/2001
Short term (from 1 to 5 years)                           3/14/2001
Temporary (less than one year)                           3/14/2001
Special study (no specific time period)                  3/14/2001
1.
1.1




1.2




1.3




1.4




2.
                        The NARSTO Site Information Template - Instructions

Site information template date: 2005/04/29 (Version 1.9)
This Instructions worksheet was last updated: 2005/04/28

Introduction
This Site Information Template is used by a number of data collection and quality assurance centres
(QACs). The current list of centres is as follows:
- NARSTO: Quality Systems Science Center (QSSC), Oak Ridge National Laboratory
- NAtChem: Meteorological Service of Canada, Environment Canada
- WDCA: GAW Aerosols

The Site Information template is designed to help data originators create the site table information for
the Data Exchange Standard template, or to help site data managers create a master list of sites
containing the information needed or requested in the Data Exchange Standard template. Data
managers can also send the filled-out Excel spreadsheet to the NARSTO QSSC for posting on the
Web.

Important notes for use: Unless you are developing this file for the World Data Center for Aerosols,
you should delete the three columns "WMO region", "WDCA/GAW station type", and "GAWID". Also,
the first three rows (those preceding the *TABLE NAME key phrase) and the example data row
between the *TABLE BEGINS and the *TABLE ENDS key phrases must be deleted before
incorporating the information into a Data Exchange Standard file. The version information is, however,
helpful to the QAC if you are a project data manager sending a sites file. Note that the columns
through the "Comment" column are requested for inclusion in Data Exchange Standard files,
even if vaules are not available for all of them. Site nature is required if mobile sites are included.
Other columns following the "Comment" column may be also be useful, but their inclusion is up to the
data submitter.

If you hold your mouse pointer over cell A1 in the "Site Information template…" tab, an Excel
comment box should appear. This has some helpful information, as do other comments in the
worksheet. Also see the leftmost "Instructions" worksheet in this workbook for additional advice,
including how to deal with comments.


Using MS-Excel
Please see the corresponding section in the Instructions for the main Data Exchange Standard
Template for hints about using MS-Excel.
Acknowledgments
Designed by:
Sig Christensen, Les Hook - NARSTO Quality Systems Science Center, Oak Ridge National
Laboratory.
Bob Vet, Bill Sukloff - Environment Canada, Meteorological Service of Canada

In collaboration with:
US EPA PM SuperSites Data Management Working Group:
Sig Christensen, Oak Ridge National Laboratory
Tim Coleman, Atmospheric Sciences Research Center
Stefan Falke, US EPA EMPACT Program
Mike Jones, Environmental Protection Agency
Les Hook, Oak Ridge National Laboratory
Philip Hopke, Clarkson University
Vernon Hughes, Central California Air Quality Studies
Elena McDonald-Buller, University of Texas
Gary McGaughey, University of Texas
Greg O'Brien, Central California Air Quality Studies
Bret Schichtel, Cooperative Institute for Research in the Atmosphere (CIRA)
Bill Sukloff, Environment Canada
Jeffrey West, Environmental Protection Agency
Global Atmosphere Watch World Data Centre for Aerosols:
Julian Wilson, Environment Institute, European Commission
NARSTO Site Information Template, Version 1.9 (2005/04/29)

*TABLE NAME             Site information
*TABLE FOCUS         Metadata
                                 Site          Description
*TABLE COLUMN NAME Site ID: standard abbreviation: standard   Country code                  Latitude:    Longitude: decimal degrees
                                                                             State or province code decimal degrees
*TABLE COLUMN UNITS None         None          None           None           None                        d
                                                                                            decimal degreeecimal degree
                      TYPE
*TABLE COLUMN FORMATChar         Char          Char           Char           Char           Decimal      Decimal
*TABLE COLUMN FORMAT12FOR DISPLAY           4 50              50             20             10.5         10.5
                      CODE
*TABLE COLUMN MISSINGNone        None          None           None           None           -999.99999 -999.99999
*TABLE BEGINS


*TABLE ENDS
               Sampling     Ground elevation:
Lat/lon reference datum height above ground abovesite Site land use
                                         Pressure: mean sea level
                                                      ground level                   Measurement Measurement Co-incident measurements at site
                                                                      Site location setting                      end
                                                                                                 start date at site date at site
None           m (meter)    m (meter)                 None
                                         hPa (hectopascal)            None           yyyy/mm/dd yyyy/mm/dd None
Char           Decimal      Decimal      Decimal      Char            Char           Date        Date           Char
120            8.1          6.1          7.2                     30   40             10          10             300
None           -99999.9     -99.9        -99.99       None            None           9999/12/31 9999/12/31 None
Site ID: study                 Lat/lon method
                 Lat/lon accuracy               AIRS ID     City/town   County   WMO region             GAWID
                                                                                              WDCA/GAW station type
None             m (meter)     None             None        None        None     None         None      None
Char             Decimal       Char             Char        Char        Char     Char         Char      Char
12               7.1           50                         9 25          25                1           1             6
None             -999.9        None             None        None        None     None         None      None
Comment   Site nature                   Site:                                      Site: study end date
                        Site location type start dateSite: end date Site: study start date                     Site type
                                                                                                 Site population class     Site monitoring support
None      None          None            yyyy/mm/dd yyyy/mm/dd yyyy/mm/dd yyyy/mm/dd None                       None        None
Char      Char          Char            Date         Date           Date           Date          Char          Char        Char
120       6                         20 10            10             10             10            30            20          30
None      None          None            9999/12/31 9999/12/31 9999/12/31 9999/12/31 None                       None        None
              Site
Site topography monitoring duration
None          None
Char          Char
15            50
None          None
Changes from Version 1.1 (3/7/2001) to 1.2 (3/8/2001): A column to capture Station nature (fixed or
mobile) was added. Comments were added to some fields. The Urban entry for station location
setting was expanded per the AIRS code. Comments for station location type were augmented, and
"Routine" was added as a value. Instructions for start and end date, and for monitoring duration, were
expanded. Station study start and end date variables were added, with explanation, to capture
information about the study-specific station use.


Changes from Version 1.1 (3/7/2001) to 1.2 (3/8/2001) (continued): Monitoring platform was changed
to Monitoring support, new explanation was provided, and many entries were added or modified. The
example was changed to a quasi-realistic site, for which some of the entries are nonetherless
fictitious. Page setups were adjusted to facilitate printing.


Changes from Version 1.2 (3/8/2001) to 1.3 (3/12/2001): "Station" was changed to "Site" throughout,
for consistency with AIRS and the "Consensus Metadata Standard: Site Identifier (Site)." A column
was added for "Site abbreviation: standard". Additional comments boxes were added. A parentheses
syntax insead of hyphens is now used for "Monitoring duration" picklist entries, for consistency with
other site characterization categories.

Changes from Version 1.3 (3/12/2001) to 1.4 (3/14/2001): For the most part, these are based on the
3/13/2001 Data Management call, site start and end dates were renamed for more consistency. Site:
study start date and Site: study end date were moved to follow Site: start date and Site: end date.
Some comments were revised slightly. The key word "site" was moved or added to the front of the
various site classification categories. Roof, Ground-based site, and Tower height ranges were altered
under the "Monitoring support" category, and instructions were added to its comment. Water (fresh)
and Water (saline) were added to the Topography category. The format of the Special study entry
under Monitoring duration was modified.


Changes from Version 1.4 (3/14/2001) to 1.5 (5/7/2001): Extended range of all picklist worksheets to
65536, to allow unlimited expansion. Inserted a blank row in row 2 of each picklist, per convention
established March 2001.


Changes from Version 1.5 (5/7/2001) to 1.6 (6/25/2001): Made the layout (order), the variable names,
and the Excel comments consistent with Version 2.209 of the Data Exchange Standard template.
Added the Instructions for Site Template spreadsheet. Extended picklist spreadsheet ranges to row
65536, and extended the site information table picklist ranges to row 65536 as well. Added labels to
the picklist cells.
Changes from Version 1.6 (6/25/2001) to Version 1.7 (10/24/2001): Incorporated into the main Data
Exchange Template. Added/modified many comments. Revised the Site land use picklist (shared
with main template) slightly (added Snowfield). Updated the Instructions-Site Info Template.
Changes from Version 1.7 (2001/10/24) to 1.8 (2002/05/27): Changed names and units of "Sample
elevation" and "Ground altitude" to conform to current practice (removing agl and asl from the units
and putting this information into the names).
Changes from Version 1.8 (2002/05/27) to 1.9 (2005/04/29): Updated the Excel comments
(instructions) for many cells, conforming to updates in the template itself. Especially, clarified that in
the *TABLE COLUMN FORMAT TYPE key phrase, numeric variables may not be changed to
character, nor vice-versa, and that units for numeric variables may not be changed. Corrected details
of the units specification for several variables.

				
DOCUMENT INFO
Description: Excel Template Bill document sample