“Hydrological Statistics Utility”
http://www.jice.or.jp/tech/software/rivers/hydrology/programdl

User’s Manual
September, 2017
Development of the system and manual (in Japanese):Japan Institute of country-ology and Engineering (JICE)
English translation:
International Centre for Water Hazard and Risk Management (ICHARM) under the auspices of UNESCO,
Public Works Research Institute (PWRI)
andCTI Engineering Co., Ltd

1

“Hydrological Statistics Utility”

User’s Manual
1. What is “Hydrological Statistics Utility”?
2. Characteristics of “Hydrological Statistics Utility”
3. How to use “Hydrological Statistics Utility”

21. What is “Hydrological Statistics Utility”?
What is “Hydrological Statistics Utility”?
• “Hydrological Statistics Utility” is software for statistical analysis ofhydrological data.
• In this analysis, hydrological data such as rainfall and discharge arestatistically processed to obtain the probabilities of occurrence of hydrologicalevents. This statistical analysis is essential for the development of a flood
management plan, an important part of river management conducted by riveradministrators of national and local governments. For example, calculating
the probability of occurrence of rainfall provides the most important data as
the first step in the development of a flood management plan.
• This software was developed by the Japan Institute of Country-ology andEngineering (JICE).
• The software can be downloaded from the JICE homepage for free of charge.
User registration is required before the use of this product.
32. Characteristics of “Hydrological Statistics Utility”
Characteristics of “Hydrological Statistics Utility”
1. Probability distribution models
16 types of probability distribution models
13 annual distributions & 3 non-annual distributions
2. Calculations
Different types of statistical values are calculated to help select proper
probability distribution models.
e.g. outlier criteria
fitness functions (estimated values and errors by resampling,
standard
least-squares
criterion,etc.)
3. Probability papers (graphs)
4 types of probability paper can be used to show calculated results on agraph.
4. Print out of calculated results
Calculated results can be output onto Microsoft Excel sheets in a pre-set
format.

4

3. How to use “Hydrological Statistics Utility”
 Steps for downloading Hydrological Statistics Utility:
Please access website below and download “Hydrological Statistics Utility”

http://www.jice.or.jp/tech/software/rivers/hydrology/programdl

Step 1: Scroll down
and find terms andconditions of the useof Hydrological
Statistics Utility
Terms and conditions of
the use of Hydrological
Statistics Utility5

3. How to use “Hydrological Statistics Utility”

Terms and conditionsof the use of
Hydrological
Statistics Utility

Step 2: Pleaseconfirm these terms
and conditions ofthe use of
Hydrological
Statistics Utility (seethe English
translation in nextslide)6

3. How to use “Hydrological Statistics Utility”
Terms and conditions of the use of Hydrological Statistics Utility (English Translation)
This Hydrological Statistics Utility (hereinafter the “Program”) is “Free Software” intended for wide public use. The
copyright of the Program belongs to Japan Institute of Country-ology and Engineering (hereinafter the “CopyrightHolder”). By downloading the Program, the user is deemed to agree to the following terms and conditions.
Terms and conditions of the use of Hydrological Statistics Utility:[Disclaimers]
The user shall be responsible for the Program, the results obtained from the use of the Program, and all other direct orindirect results from the use of the documents relevant to the Program, and the Copyright Holder shall not bear any
responsibility for the consequences from the action of the user associated with the use of the Program.
[Redistribution of the Program]
The user shall not redistribute the Program to any third party, including but not limited to the redistribution of theProgram as a supplement to a publication or product, without a prior written consent of the Copyright Holder.
[Commercial use of the Program]
The user shall not sell the Program or a modified version of the Program.
[Disclosure of Results]
The user wishing to publicize the results obtained from the use of the Program shall inform the Copyright Holder to that
effect and clearly state the use of the Program in the publication of the user.
[Modification of the Program]
The user shall not modify the Program in any way including but not limited to reverse engineering, reverse compiling, orreverse assembling.
[Support for the user]
The Copyright Holder is not liable to provide the user with any support including but not limited to technical support.
The user agreeing to this terms and conditions of the use of the Program may use the Program without requesting apermission of the use of the Program from the Copyright Holder.
Please email (kasen-keikaku@jice.or.jp) a notification of the publication of the results obtained from the use of theProgram, reports on programming bugs, or other comments regarding the Program. Again, please note that any
support including technical support will not be provided in principle.

7

3. How to use “Hydrological Statistics Utility”

Step 3: Scroll down and find theinput field for your information

Input field (See next slide)8

3. How to use “Hydrological Statistics Utility”
Step 4: Input your informationIf you agree to the terms and conditions of the use of
Hydrological Statistics Utility, please check here (mandatory)
Terms and conditions of the useof Hydrological Statistics Utility(mandatory)

AcceptLocal
government

National

Independentadministrative
agencyEducational/research instituteCategory of your organization(mandatory)

OthersName of your organization
Please input name of yourorganization
Purpose of use

Step 5: Click here to confirm
the input information

Please selectcategory of yourorganization

Construction
consultant

Please describe yourpurposes of use of
Hydrological Statistics Utility

To confirmation

93. How to use “Hydrological Statistics Utility”
Step 6: Please confirm your information and click “Send” button
Please confirm your input information.
If OK, click send button.
If edit is necessary, click back button toedit the information.

Scroll downBack

Step 7: Download Hydrological Statistics Utility

Send

Please click here tosend information

After sending theinformation, download
page will appear

suimon-u15.lzh(LHA形式:2.53MB)

After download, please
open the folder where
suimon‐u15.lzh is saved.
Please click here to download
Hydrological Statistics Utility

10

3. How to use “Hydrological Statistics Utility”
 Steps for installing Hydrological Statistics Utility:
Open Downloaded Folder
1. Click this and unzip the downloaded Hydrological Statistics
Utility“suimon-u15.lzh”

2. Double click this to open unzip folder

3. Double click this to open software installation setup file

4. Double click this (Setup) to install the program
Version installation information
User Manual in Japanese113. How to use “Hydrological Statistics Utility”
Steps for installation of the program

Click here at “Next”
button forinstallation process

Cancel Button

If you want to define folder
location for the installation
Please click here tobrowse the folder
Click here at “Next” button
for installation process
Back Button

Cancel Button

12

3. How to use “Hydrological Statistics Utility”
Steps for installation of the program

Back Button

Click here at “Next”
button for installation
process
Cancel Button

Back Button

Click here at “Next”
button to install
softwareCancel Button
13

3. How to use “Hydrological Statistics Utility”
Steps for installation of the program

Click here at “Finish”
button for completionof installation

14

3. How to use “Hydrological Statistics Utility”
 Steps for Starting Hydrological Statistics Utility (水文統計ﾕｰﾃｨﾘﾃｨ)3. Find “流出解析ｼﾐｭﾚｰﾀ” (Outflow AnalysisSimulator) program
folder and click it
2. Click AllProgram

流出解析ｼﾐｭﾚｰﾀ
4. Click here at “水文統計ﾕｰﾃｨﾘﾃｨ ”(HydrologicalStatistics Utility) toopen the program

1. Click start up
水文統計ﾕｰﾃｨﾘﾃｨ

15

3. How to use “Hydrological Statistics Utility”
Explanation of Hydrological Statistics Utility Buttons

Calculation Condition Setting Window
Calculation Result Plotting Window

Data Input Excel Sheet
Result Viewer in Excel Sheet
Exit16

3. How to use “Hydrological Statistics Utility”
 Steps for statistical analysis using “Hydrological Statistics Utility”
1. Open Data Input Excel Sheet and Create Data File

Name of basin(1) Click here
(Data InputExcel Sheet)

Name ofriver

Name ofstation

After click, the excel
sheet will be opened
automatically.
In this sheet, input discharge (orprecipitation) to be used in the hydrologicalstatistics utility. Output file will be created in
the format that can be used in thehydrological statistics utility program.

(See next slide for detail)17

3. How to use “Hydrological Statistics Utility”
 Calculate probabilistic discharge using “Hydrological Statistics Utility “(2) Input Data in Excel Sheet

Year
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004

Discharge(m3/s)
Thabeikkyin
22,12021,70021,66020,20021,70024,99023,54021,70024,13017,26023,53013,73022,59022,88024,82023,75022,82019,18019,77020,96019,15027,540

2005
2006
2007
2008
2009
2010
2011
2012
2013

18,22016,65023,45019,630 Name of basin
17,440 Name of river
20,150Name of station
15,18021,08021,660

Data in years mustcorrespond toobserved actualyears, while monthand day does notaffect the results.

Input name of basin,river, and station

Unnecessary to change

Input annual maximum
data (discharge)18

3. How to use “Hydrological Statistics Utility”
 Calculate probabilistic discharge using “Hydrological Statistics Utility “(3) Create Output Data to be used in the Program
HydrometricInput Menu

(iii) Create a data file(ii) Select Add-in

Data FileCreation
Click here tocreate data file(i) Select all cellsof input data asshown in the right(iv) Save file（with filename such as“ThabeikkyinQ”）

19

3. How to use “Hydrological Statistics Utility”
2. Calculation Condition Setting(1) Click here (CalculationCondition Setting Window)

If data areannualIf data are nonannual

AnnualNon-annual

Select all
Select none
Rainfall
Discharge
Calculation
File Setting
Select all
Select noneStart
Calculation
Close(See next slide for detail)20

3. How to use “Hydrological Statistics Utility”(2) Setting Calculation Conditions

Unnecessary tochange

Probability distribution method tobe calculated. Normally, all boxes
should be checked.

Unchecked

When calculating
1000-year flood,
1000 should beentered here.

Select in the case of
precipitation
Select in the case ofdischarge

Exp : Exponential distribution
Gumbel : Gumbel distribution
SQRTET : Square-root exponential type maximum distribution
GEV : Generalized extreme value distribution
LP3Rs : Log-Pearson Type III Distribution (Real coordinate space)
LogP3 : Log-Pearson Type III Distribution (Log coordinate space)
Iwai : Iwai method
IshiTaka :Ishihara Takase method
LN3Q~ LN4PM : Log-normal distribution21

3. How to use “Hydrological Statistics Utility”(3) Select Calculation Data Files and Start Calculation

Directory to load condition data
Directory to save results③

filename of the result① Click here toselect data file

⑤ Click here to startcalculation②

Select the previously
created data file
(ThabeikkyinQ).

⑥ Close④
OKClearCancel22

3. How to use “Hydrological Statistics Utility”
3. Calculation Results Plotting(1) Click here (Calculation
Result Plotting Window)

Graph Type

Select all
Graph
Types

Select noneRedraw
View
Histogram

Lognormal Probability Paper

View IndexPrint

Normal Probability Paper
Gumbel Probability Paper(See next slides for detail)Exponential Probability Paper

Close23

3. How to use “Hydrological Statistics Utility”(2) Plotting Graphs

Select from calculated stochastic distributions (graph type) to beplotted, then click at redraw button.

Graph Type(i) Select to showeach calculated
methods(iii) Click here
(redraw) to plot
the graphs(ii) Select Graph Type24

3. How to use “Hydrological Statistics Utility”(3) Check the Graph

Among these calculated distributions,select one that well corresponds to theplots.

25

3. How to use “Hydrological Statistics Utility”(3) Check the Graph (Contd.)(ii) Check if thedistribution
matches!

Matching
Check #1

(i) Click here to viewhistogram26

3. How to use “Hydrological Statistics Utility”
SLSC (standard least-square criterion)(3) Check the Graph (Contd.)

SLSC: fit index-> smaller valuemeans better matching of thestochastic distribution and the plots.

When a file is read, the file name isshown here.

(ii) Choose
returnperiod(A)

Quantile

Matching
Check #2
(i) Click here to view index

error

If this isshown, reload
the result fileby clicking (A).
27

3. How to use “Hydrological Statistics Utility”
4. View Results in Excel Sheet(2) Click here (at ADD-INS) for selecting
the calculation result file in excel(1) Click here (ResultViewer in Excel Sheet)28

3. How to use “Hydrological Statistics Utility”(3) Create new sheet

Sheet Creation(4) Select reading types andopen the output file
Output File (Reading
Type 1)
Output File (Reading
Type 2)

 To read the result file, there are twotypes of reading depending on theformat to be displayed on the sheet.
 Select the output file reading typeand open the output file.
 The results will be loaded in thedisplayed sheet.

Display the results

29