Exporting Data to Another Application

As powerful as WRDB is, it is inevitable that there will be times when you need to use other applications to further analyze or display the data. For example, suppose the time series graphing of DO in the mainstem is sufficient for data analysis but you want to prepare a graphic that superimposes population trends on observed DO readings at mainstem station CR0024. You could print a report and manually re-enter the DO observations into a spreadsheet program that contains census data. However you’d be more wise to use WRDB’s data export capabilities to create a file you can further manipulate.

Let’s use the above example and follow the step-by-step procedure:

  1. Open the Master table containing historic trend monitoring data.

  2. Select Output | Select Data Ranges, click on Select All to clear any earlier conditions, and click on CR0024 in the Station list and DO in the Parameter list. Then select Execute.

  3. Now that you’ve selected only the data you are interested in, export it by selecting Output | Export to File. Select the desired spreadsheet format and then enter the subdirectory where you want the exported file to go. The file will be given the name you enter and be given the appropriate extension. You do not need to check the "Export all Support Tables, too" or "Convert to a New Project" check boxes.

  4. When complete, start your spreadsheet program and open the exported file.