Note

Help file has not been fully updated since some new features have been added. New functions are (1) total rainfall for each calendar day, (2) maximum rainfall for given duration for each calendar day

Large dataset is also processed correctly. It may take up to a minute if data for 10 years is used.

Purpose

Rainfall Return Periods and more

Methodology

Compare maximum rainfall depths for given duration with SF SF Depth-Duration curves.
Result Table

Steps

1. Input Data
• Paste a CSV or TSV data
• TSV data can be copied from Excel spreadsheet


• Example of TSV
DATETIME East West Downtown Tanktop 10/19/2009 14:10 0 0 0 0 10/19/2009 14:15 0 0.12 0 0 10/19/2009 14:20 0 0 0 0 10/19/2009 14:25 0.12 0 0 0 10/19/2009 14:30 0 0.24 0.12 0 10/19/2009 14:35 0.12 0.12 0.12 0 10/19/2009 14:40 0 0 0.06 0 10/19/2009 14:45 0 0.12 0.06 0 10/19/2009 14:50 0 0 0.12 0.12 10/19/2009 14:55 0.24 0 0 0 10/19/2009 15:00 0.36 0.48 0 0 10/19/2009 15:05 1.56 1.08 0 0 10/19/2009 15:10 1.44 3.84 0.18 0 10/19/2009 15:15 0.6 1.08 1.2 0 10/19/2009 15:20 0.36 0.36 0.96 0 10/19/2009 15:25 0 0.72 0.18 0 10/19/2009 15:30 0 0.12 0.18 0 10/19/2009 15:35 0 0 0 0 10/19/2009 15:40 0 0 0 0 10/19/2009 15:45 0 0 0 0 10/19/2009 15:50 0 0 0.24 0.48 10/19/2009 15:55 0 0 0.18 0.36 10/19/2009 16:00 0 0 0.24 0.48 10/19/2009 16:05 0 0 0.12 0.24 10/19/2009 16:10 0 0 0.12 0.24 10/19/2009 16:15 0 0 0.12 0.24 10/19/2009 16:20 0 0 0.18 0.36 10/19/2009 16:25 0 0 0.12 0.24 10/19/2009 16:30 0 0 0.42 0.84 10/19/2009 16:35 0 0 0.12 0.24 10/19/2009 16:40 0.12 0 0.42 0.84 10/19/2009 16:45 0 0 0.12 0.24 10/19/2009 16:50 0 0 0 0 10/19/2009 16:55 0 0 0 0 10/19/2009 17:00 0 0 0 0 10/19/2009 17:05 0 0 0 0


• Example of CSV
TIMESTAMP,10-OSP,11-FSK,12-LOH,13-S2S,14-FMC,15-HHS,16-SFS,17-LMD,20-SEP,21-GFS,22-HIL,23-GUA,24-BAL,25-MED,26-SUN,30-CHS,31-1680,32-ASH,33-COB,34-PFA,35-NSS 02/25/2004 01:25,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 02:55,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 03:00,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0 02/25/2004 03:05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,1 02/25/2004 03:10,1,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,0,0 02/25/2004 03:20,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0 02/25/2004 04:45,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 05:05,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0 02/25/2004 05:10,2,1,0,1,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,1,1 02/25/2004 05:15,2,2,0,1,2,3,0,1,1,0,0,0,0,1,0,0,0,0,3,2,0 02/25/2004 05:20,1,0,0,1,1,3,0,4,0,0,0,1,1,0,0,1,2,0,1,1,4 02/25/2004 05:25,0,1,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,2,1,1 02/25/2004 05:30,1,1,0,2,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2 02/25/2004 05:35,0,2,0,6,0,0,0,0,0,0,0,0,1,1,1,0,0,0,1,2,1 02/25/2004 05:40,2,3,0,3,2,1,0,1,1,0,0,1,1,0,0,1,1,0,2,3,1 02/25/2004 05:45,1,2,0,3,3,1,0,1,1,0,0,1,1,2,2,1,1,0,2,3,2 02/25/2004 05:50,2,2,0,2,2,2,0,1,1,0,0,1,1,1,1,1,1,0,1,1,2 02/25/2004 05:55,1,0,0,2,2,1,0,2,1,2,0,2,2,2,2,1,1,0,2,2,0 02/25/2004 06:00,2,0,0,1,2,2,0,2,2,1,0,2,3,1,2,1,1,0,2,2,2 02/25/2004 06:05,3,0,0,3,3,3,0,0,3,2,0,2,3,3,3,2,2,0,2,3,2 02/25/2004 06:10,4,0,0,3,3,4,0,0,2,3,0,4,2,3,3,3,2,0,3,2,2 02/25/2004 06:15,2,0,0,3,3,4,0,0,2,3,0,1,2,3,2,3,3,0,3,2,2 02/25/2004 06:20,1,0,0,1,2,1,0,0,1,2,0,2,2,2,2,1,0,0,0,1,2 02/25/2004 06:25,1,0,0,0,1,1,0,0,1,2,0,2,1,2,1,2,2,0,2,0,1 02/25/2004 06:30,2,0,0,1,1,2,1,0,2,2,0,3,2,2,3,1,1,0,1,2,1 02/25/2004 06:35,3,0,0,3,2,2,0,0,2,2,0,2,2,2,2,2,1,0,1,1,1 02/25/2004 06:40,2,0,0,2,3,3,1,0,3,2,0,2,1,2,2,2,1,0,3,2,1 02/25/2004 06:45,1,0,0,1,2,1,3,0,1,4,0,1,1,2,1,2,2,0,1,1,2 02/25/2004 06:50,0,0,0,1,1,1,6,0,1,2,0,2,1,1,1,1,0,0,0,1,0 02/25/2004 06:55,1,0,0,0,0,1,25,0,2,2,0,1,1,1,2,1,1,0,1,0,1 02/25/2004 07:00,2,0,0,1,2,1,18,0,1,1,0,2,2,2,2,1,1,0,1,2,1 02/25/2004 07:05,1,0,0,1,1,2,24,2,2,1,0,2,1,1,1,1,0,0,2,1,0 02/25/2004 07:10,1,0,0,1,1,1,35,1,2,2,0,2,1,2,3,2,1,0,1,1,2 02/25/2004 07:15,1,0,0,0,1,1,17,0,3,2,0,2,1,2,2,2,2,0,1,0,1 02/25/2004 07:20,0,0,0,1,1,1,20,0,2,3,0,2,2,2,2,3,1,0,1,1,1 02/25/2004 07:25,1,0,0,0,1,1,42,0,0,2,0,1,0,2,2,2,1,0,1,1,1 02/25/2004 07:30,1,0,0,1,1,0,0,0,1,2,0,0,1,1,0,1,1,0,1,0,1 02/25/2004 07:35,1,0,0,1,0,1,0,0,0,0,0,0,1,1,1,1,1,0,1,1,1 02/25/2004 07:40,1,0,0,1,2,1,0,0,2,1,0,1,1,0,1,1,0,0,1,1,0 02/25/2004 07:45,2,0,0,0,1,1,0,0,3,1,0,2,2,2,3,1,1,0,2,1,1 02/25/2004 07:50,2,0,0,2,1,2,0,0,1,2,0,3,1,2,3,3,1,0,2,1,2 02/25/2004 07:55,2,0,0,1,2,2,0,0,1,3,0,1,1,2,1,2,2,0,1,1,2 02/25/2004 08:00,0,0,0,1,1,1,0,0,1,2,0,1,0,1,1,1,1,0,1,1,2 02/25/2004 08:05,2,0,0,0,1,0,0,0,0,1,0,1,2,1,1,1,0,0,1,1,0 02/25/2004 08:10,1,0,0,1,1,3,0,1,1,0,0,1,1,2,2,2,2,0,3,2,1 02/25/2004 08:15,1,0,0,1,3,1,0,3,1,1,0,1,2,2,1,2,3,0,3,3,4 02/25/2004 08:20,2,0,1,2,2,3,0,2,1,0,0,2,1,2,2,1,2,0,3,2,2 02/25/2004 08:25,2,0,1,3,3,2,0,2,1,2,0,2,2,3,2,3,2,0,2,3,0 02/25/2004 08:30,2,0,1,3,3,3,0,2,3,1,0,2,2,2,3,2,2,0,3,3,0 02/25/2004 08:35,2,0,1,2,2,2,0,2,2,3,0,3,1,3,4,3,2,0,3,2,0 02/25/2004 08:40,1,0,1,1,2,3,0,2,3,3,0,2,2,3,4,4,3,0,3,2,0 02/25/2004 08:45,2,0,1,2,3,1,0,2,3,1,0,2,2,2,3,4,2,0,2,2,0 02/25/2004 08:50,1,0,1,1,2,2,0,1,2,3,0,3,1,2,3,3,1,0,2,2,0 02/25/2004 08:55,2,0,1,2,2,2,0,2,2,5,0,1,1,2,2,3,2,0,2,2,0 02/25/2004 09:00,1,0,1,1,2,1,0,1,1,2,0,0,0,1,1,2,1,0,2,1,0 02/25/2004 09:05,1,0,2,2,1,1,0,2,0,0,0,1,1,1,1,2,1,0,2,2,0 02/25/2004 09:10,1,0,1,1,1,1,0,1,0,1,0,1,1,1,2,1,1,0,2,1,0 02/25/2004 09:15,1,0,1,2,1,0,0,0,2,0,0,2,2,1,3,2,2,0,1,2,0 02/25/2004 09:20,2,0,5,2,1,1,0,1,1,1,0,1,2,2,3,5,2,0,3,3,0 02/25/2004 09:25,24,0,5,7,3,2,0,2,1,0,0,2,7,3,2,3,3,0,5,11,0 02/25/2004 09:30,19,0,1,9,13,20,0,3,1,1,0,1,34,2,4,2,3,0,22,17,0 02/25/2004 09:35,3,0,1,2,19,4,0,14,14,1,0,17,18,25,18,9,32,0,5,1,18 02/25/2004 09:40,3,0,0,1,2,6,0,6,12,0,0,18,21,22,20,20,9,0,3,1,10 02/25/2004 09:45,3,0,0,1,2,9,0,12,5,6,0,6,25,17,15,12,7,0,3,1,3 02/25/2004 09:50,5,0,0,1,2,10,0,9,4,5,0,3,12,28,15,16,21,0,4,2,4 02/25/2004 09:55,15,0,2,3,3,11,0,9,3,2,0,3,2,27,8,19,20,0,7,4,7 02/25/2004 10:00,13,0,7,8,9,13,0,20,2,4,0,2,3,5,2,10,12,0,11,8,10 02/25/2004 10:05,9,0,8,10,10,7,0,13,3,3,0,3,3,2,3,4,5,0,10,8,9 02/25/2004 10:10,6,0,3,8,8,3,0,8,4,3,0,3,2,2,2,3,4,0,5,4,8 02/25/2004 10:15,4,0,1,3,4,2,0,5,2,5,0,2,2,3,2,3,5,0,3,2,3 02/25/2004 10:20,2,0,2,3,4,2,0,4,1,8,0,1,1,2,1,2,2,0,3,2,2 02/25/2004 10:25,1,0,1,2,2,1,0,3,3,3,0,3,2,1,2,1,2,0,1,2,2 02/25/2004 10:30,0,0,1,1,1,0,0,2,2,2,0,2,0,1,2,2,0,0,0,0,0 02/25/2004 10:35,1,0,0,0,0,0,0,0,0,1,0,1,1,1,0,1,1,0,1,0,1 02/25/2004 10:40,0,0,0,1,0,0,0,0,0,1,0,1,1,0,1,0,0,0,0,0,0 02/25/2004 10:45,1,0,1,0,1,1,0,0,1,0,0,0,1,0,0,0,1,0,1,1,0 02/25/2004 10:50,2,0,1,2,0,1,0,1,3,0,0,2,2,1,2,1,1,0,1,2,1 02/25/2004 10:55,0,0,0,1,2,0,0,2,1,1,0,3,3,1,1,1,1,0,1,0,0 02/25/2004 11:00,2,0,3,0,0,1,0,1,2,1,0,3,2,1,3,2,1,0,1,2,0 02/25/2004 11:05,3,0,2,4,3,2,0,2,0,1,0,0,1,3,0,1,3,0,3,2,2 02/25/2004 11:10,1,0,0,2,2,1,0,4,2,1,0,3,2,1,2,1,1,0,1,0,2 02/25/2004 11:15,1,0,1,1,1,1,0,1,1,1,0,2,1,1,1,1,2,0,1,1,0 02/25/2004 11:20,2,0,0,1,1,1,0,1,2,0,0,1,1,2,0,1,2,0,2,2,1 02/25/2004 11:25,0,0,1,1,1,1,0,1,0,1,0,1,1,0,1,1,1,0,0,0,1 02/25/2004 11:30,0,0,0,1,0,0,0,1,0,0,0,0,0,1,1,1,1,0,1,0,0 02/25/2004 11:35,1,0,1,0,0,0,0,1,2,1,0,1,2,0,1,0,0,0,1,1,1 02/25/2004 11:40,2,0,0,1,1,2,0,0,1,2,0,2,0,4,2,2,3,0,1,1,0 02/25/2004 11:45,0,0,0,1,1,1,0,1,0,0,0,0,0,0,1,2,1,0,1,0,1 02/25/2004 11:50,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,1 02/25/2004 11:55,0,0,0,0,0,0,0,1,0,0,0,0,1,1,0,0,0,0,0,0,0 02/25/2004 12:00,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 12:05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0 02/25/2004 12:10,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0 02/25/2004 12:15,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0 02/25/2004 12:20,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 12:40,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0 02/25/2004 12:45,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0 02/25/2004 12:50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 02/25/2004 12:55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0 02/25/2004 13:10,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0 02/25/2004 13:20,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 15:25,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 15:55,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 17:20,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 17:25,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 18:15,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 18:20,0,0,0,0,0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 18:50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1 02/25/2004 19:05,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 19:10,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 21:20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0 02/25/2004 22:00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0 02/25/2004 22:05,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 22:10,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0 02/25/2004 22:15,0,0,0,0,0,0,0,0,2,0,0,3,0,1,3,0,0,0,0,0,0 02/25/2004 22:20,0,0,0,0,0,0,0,0,0,2,0,0,0,2,0,3,4,0,0,0,0 02/25/2004 22:25,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0 02/25/2004 22:35,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0 02/25/2004 22:40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0 02/25/2004 22:45,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,1,0,0,0,0 02/25/2004 22:50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0 02/25/2004 22:55,0,0,0,0,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0 02/25/2004 23:00,0,0,0,0,0,0,0,0,0,3,0,1,1,1,1,0,0,0,0,0,0 02/25/2004 23:05,0,0,0,0,0,0,0,0,1,1,0,2,2,0,1,0,0,0,0,0,0 02/25/2004 23:10,0,0,0,0,0,1,0,0,3,5,0,4,2,2,4,1,0,0,0,0,0 02/25/2004 23:15,2,2,0,0,0,2,0,3,1,3,0,2,1,4,1,1,2,0,1,1,0 02/25/2004 23:20,1,1,0,0,1,0,0,2,0,1,0,0,0,1,0,2,2,0,1,3,1 02/25/2004 23:25,0,0,0,2,1,0,0,0,0,0,0,1,0,2,0,0,1,0,0,1,1 02/25/2004 23:30,0,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0,1,0,0,0,0 02/25/2004 23:55,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0
• Or Select sample data file and Press Sample
2. Select unit used in the original data.
3. Select minute interval of the data was recorded.
4. Select 1990 or 2003 IDF coefficients.
5. Click Warm Up
6. That should populate all gage names
7. Select one or more gages
8. Click Analyze
9. Result Tables will be created.

• Check symbol to show • instead of numerical values.
• If no raingage is selected, all of them will be analyzed by default.
• Click check to see data interpretation.
• Total gives total rainfall depth.
• Quick Glance gives maximum totals for various durations.
• Sparkline gives charts.
• Table can be sorted by clicking on headers.
• etc

Limitations

Updated Jan 2017

Updated Dec 2015

Updated Dec 2014

Updated Feb 2014

Original Aug 2013

Error possible

Tested in Firefox only.

For TSV data, do not use spaces in gage names in the header.

Use only upto 24 hours of data.

Date time format should be as shown in sample.

Datetimes do not have to be sequential.

Datetime without any rain value can be optionally excluded.

Glossary

CSV : Comma Separated Variables File

TSV : Tab Separated Variables File

Disclaimer

Use at your own risk.

Content and data is experimental and meant for academic purpose only.

bshrestha elev8848@mailcity.com