‹  ALL DSC TOOLS

Surveillance Data Analysis Tool

A tool for advanced processing, comparison, graphing and interpretation of dam safety related surveillance data in multiple formats.

New here? Press ⓘ How to (under the tool name) for a walkthrough. Your data stays in this browser: Save project keeps your work as a .json file you can re-open with Load project.

Section 1  ·  Project and Data

Set up your project and get your data ready: upload, name your series, and create any calculated series you need.

▾Step 1  ·  Setup Project and Upload Data

Upload your data to get started.

Download the template, add your data, then drag and drop it here. Alternatively, press "Load sample project" to explore the tool: choose sample data only, or a full project including worked graphs. To refresh your data later, upload an updated file: new series are added, and for series with the same name you choose whether to replace them. Your graphs and settings are kept.

Click to choose a file, or drop it here
.xlsx, .xls, .csv or .tsv — reads the Data tab: Date/Reading pairs (one pair per instrument), or a table with date/time in the first column and one instrument per column

▾Step 2  ·  Global Series Settings

Set chart names or key values for each series.

  • Chart Name Override: the name used on chart axes and legends only. Lists in the tool keep the original name from your file.
  • Add reference value: sets a key value (e.g. FSL, MOL) that can be toggled on or off per chart.
No data uploaded — go to Step 1

▾Step 3  ·  Synthesise Data (Optional)

Create new series calculated from your data.

  • Daily summary: one value per day from frequent readings (time-weighted average, minimum, maximum, last or total).
  • Trailing total: running total over the last N days (e.g. 5-day rainfall).
  • Trailing average: running average over the last N days (e.g. 5-day average lake level).
  • Interpolate: fill the days between readings with straight-line values.
  • Date range filter: keep only the readings inside a date range.
  • Filter A by B: keep readings of one series only when another series meets a condition.
No data uploaded — go to Step 1

Section 2  ·  Chart Builder

Build, preview, and save your charts here, using the data prepared in Section 1.

Layout

▾Step 4  ·  Chart Type and Series

Choose which series appear on this chart, and how it's laid out.

Pick a chart type, then use '+ Add series' to bring in data.

This chart is an uploaded image, so series and chart-type settings don't apply. Annotate it in Step 6, and set an optional title in Step 5.
Set order of series by dragging or using arrows. Order controls location of plot within stack.
No series added — add one using the +Add series button.

▾Step 5  ·  Chart SettingsTime series

Leave any value blank for automatic. The chart updates as you type.

Uploaded image: only the chart title (optional) applies here. Annotate the image in Step 6.

Whole chart

Give the chart a title and, optionally, limit the date range shown on the X axis. Leave the dates blank to show the full record.

Chart reference valuesThis chart only: a labelled line across the chart at a fixed value, e.g. a trigger level or design value.

Stack Settings  ·  Axes & Secondary Data

Set axis min/max and tick increments for each stack, overlay secondary data with "+ Add secondary data", and choose which reference lines to show, or add one for this graph only. Leave axis values blank for automatic.

No series added yet — add one in Step 4.

Graph Preview and Management

Preview and annotate your chart, then save it with the buttons in the bar above. Saved graphs are in Step 7.

Quick review Folder Graph

Step 6  ·  Chart

Your chart, ready to annotate, copy and save.

Updates automatically as you change Steps 4 and 5. Use the tool strip above the chart to zoom, draw shapes, add text boxes or lettered notes, and copy the chart for reports. Save it with the buttons in the bar at the top of Section 2.

No data uploaded — go to Step 1
Click legend entries to show or hide them
R² info R² is the share of the scatter that the straight line of best fit explains, from 0 (none) to 1 (all).

None below 0.05 · Weak 0.05–0.15 · Mod. 0.15–0.5 · Strong above 0.5

R² shows how consistent the relationship is, not how big it is. See Step 5 (under each line of best fit) for its slope and the number of paired readings (n).

Text boxes: click "Add text box", then click anywhere on the chart to place it. Double-click a placed box to edit its text (Enter for a new line; click away or Ctrl+Enter to finish); drag to move it. Shapes: pick the line, box or circle tool in the strip, then drag on the chart.

Notes

Click "Add note" in the tool strip above the chart, then click the chart where it applies. Notes are lettered (A), (B), (C)… in list order; drag or use the arrows to reorder and the letters on the chart update.

▾Step 7  ·  Available Graphs

Save chart configurations to come back to later, and organize them into folders.

Save a chart from Step 6 with a name — it remembers everything. Group related graphs into folders by dragging them in.

No saved graphs yet — build one in Steps 4–6, then click 'Save as new'.

Section 3  ·  Instrumentation and Interpretation

Summarise the instruments installed and how often they are read, then record your engineering commentary on the saved graphs. Save your project to keep everything.

▾Step 9  ·  Interpretation

Record your engineering commentary for an instrument or a group.

  • Add interpretation: one for a single instrument, or for a group (e.g. groundwater).
  • Add linked graph: choose the saved graphs it refers to.
  • Fill in the boxes. Drag or use the arrows to change the order.