Importing data tables from a spreadsheet

Importing data tables from a spreadsheet

Rainfall hyetographs and stream flow hydrographs can be imported into DRAINS via the Windows Clipboard using the following procedure:

      (a) Set up the data in a table of values, with the times of the start of each period in one column, and the rainfall intensities or flow values in the second, as shown below, in the DRAINS Utility Spreadsheet:


Time intervals must be the same throughout.

      (b) Highlight the numbers in the table, as shown, and copy this to the Clipboard using the Edit -> Copy option.

      (c) Within the DRAINS Rainfall Data property sheet, select Add a New Storm,

      (d) Press the <- Paste button to enter the pattern.

 

This procedure can be applied in the Rainfall Data property sheet, the Inflow Hydrograph property sheet and the Pit Data Base property sheet.

    • Related Articles

    • DRAINS spreadsheet formats and data

      The spreadsheet copy options in the Edit menu of DRAINS can transfer input data and results to spreadsheets and other programs that can interface with DRAINS. Data can be transferred both ways - from and to DRAINS. This has the following advantages: ...

    • Importing and Exporting GIS Files

      DRAINS provides transfers of system data and results to between GIS programs and DRAINS, reading from and creating ESRI (ArcView) shapefiles and Mapinfo MIF files, the most commonly-used GIS formats. This facility is not standard in DRAINS, but is ...

    • Spreadsheet transfers

      The data that makes up a DRAINS model and the results of runs can be transferred to spreadsheet programs using facilities in the Edit menu. Other spreadsheet transfers can be made for any results that can be pasted to the Windows Clipboard. In the ...

    • Importing a DB1 data base

      DRAINS stores information on pipes, pits and overflow routes in two places: in each .drn file containing the information on a system in binary formats, in a file with a .db1 suffix, which is located in the C:\Program Files\Drains\Program or ...

    • Importing MapInfo files

      This process enables you to import data into DRAINS from one to six sets of MapInfo files, plus an optional background from a DXF file. The procedure is pretty much the reverse of the exporting process for MapInfo files. MapInfo stores spatial ...