rainidfautomated...

RainIDF:automated derivation of rainfall intensity–duration–frequency relationship
from annual maxima and partial duration series Kian Boon Chang,Sai Hin Lai and Othman Faridah
ABSTRACT
RainIDF,a software tool for derivation of rainfall intensity–duration–frequency(IDF)relationship is developed as an Excel add-in by using Visual Basics for Applications(VBA).The tool is integrated with two of the most widely used statistical distributions for determination of IDF relationship:the generalized extreme value(GEV)distribution for annual maxima series,and the generalized Pareto (GPA)distribution for partial duration series(PDS).It provides automated distributionfitting for rainfall data in the form of annual maxima or PDS for multiple intervals,solving and plotting of rainfall IDF curves.RainIDF uses the Solver add-in function in Excel to solve the coefficients of the empirical IDF formula in one step.The methodology built into RainIDF is discussed and rainfall IDF relationships for several stations in Peninsular Malaysia are derived and compared.RainIDF is available for download on GitHub(/kbchang/rainidf)as an Excel add-in.Kian Boon Chang
Sai Hin Lai(corresponding author) Othman Faridah
Department of Civil Engineering, Faculty of Engineering Building, University of Malaya,
50603Kuala Lumpur,
Malaysia
E-mail:************.my
Key words|annual maxima series,Excel,generalized extreme value distribution,generalized Pareto distribution,partial duration series,rainfall intensity–duration–frequency
INTRODUCTION
The rainfall intensity–duration–frequency(IDF)relation-ship is an important tool for the determination of design rainfall in water resources structural design,urban storm-water management,flood modeling,etc.In some cases, depth–duration–frequency(DDF)and intensity–duration–area–frequency(IDAF)relationships are used,which serve the same purpose as the IDF relationship.Generally, there are two types of rainfall data series that are widely applied for derivation of IDF relationship:annual maxima series(AMS)and partial duration series(PDS). There are different methods or approaches to derive rain-fall IDF relationship(e.g.Koutsoyiannis&Baloutsos ;Overeem et al. ;Palynchuk&Guo ;Ben-Zvi ;Madsen et al. ;Van de Vyver&Demarée ;De Michele et al. ),where the selection of good fitting probabilistic distributions for the target region is very important.
RainIDF is developed by using Visual Basics for Appli-cations(VBA)and can be installed as an Excel add-in. Basically,input data in the form of annual maxima or PDS for multiple intervals are inserted into an Excel work-sheet and the RainIDF add-in willfit the data with the corresponding probabilistic distribution(generalized extreme value(GEV)or generalized Pareto(GPA)distri-bution),list out all statistical parameters and optimization procedures to obtain the empirical IDF formula.Besides,it also takes the advantage of Excel’s chart plotting functional-ity to plot the IDF curves automatically based on the derived empirical IDF formula.The output return periods or annual recurrence intervals(ARI)for the IDF relationship derived are3-month,6-month,9-month,1-year,2-year,5-year,10-year,20-year,50-year and100-year.For other return periods or ARI,it has to be performed manually based on the par-ameters of thefitted distribution.
doi:10.2166/hydro.2013.192
Below is given annual work summary, do not need friends can download after editor deleted Welcome to visit again
XXXX annual work summary
Dear every leader, colleagues:
Look back end of XXXX, XXXX years of work, have the joy of success in your work, have a collaboration with colleagues, working hard, also have disappointed when encountered difficulties and setbacks. Imperceptible in tense and orderly to be over a year, a year, under the loving care and guidance of the leadership of the company, under the support and help of colleagues, through their own efforts, various aspects have made certain progress, better to complete the job. For better work, sum up experience and lessons, will now work a brief summary.
To continuously strengthen learning, improve their comprehensive quality. With good comprehensive quality is the precondition of completes the labor of duty and conditions. A year always put learning in the important position, trying to improve their comprehensive quality. Continuous learning professional skills, learn from surrounding colleagues with rich work experience, equip themselves with knowledge, the expanded aspect of knowledge, efforts to improve their comprehensive quality.
The second Do best, strictly perform their responsibilities. Set up the company, to maximize the customer to the satisfaction of the company's products, do a good job in technical services and product promotion to the company. And collected on the properties of the products of the company, in order to make improvement in time, make the products better meet the using demand of the scene.
Three to learn to be good at communication, coordinating assistance. On‐site technical service personnel should not only have strong professional technology, should also have good communication ability, a lot of a product due to improper operation to appear problem, but often not customers reflect the quality of no, so this time we need to find out the crux, and customer communication, standardized operation, to avoid customer's mistrust of the products and even the damage of the company's image. Some experiences in the past work, mentality is very important in the work, work to have passion, keep the smile of sunshine, can close the distance between people, easy to communicate with the customer. Do better in the daily work to communicate with customers and achieve customer satisfaction, excellent technical service every time, on behalf of the customer on our products much a understanding and trust.
Fourth, we need to continue to learn professional knowledge, do practical grasp skilled operation. Over the past year, through continuous learning and fumble, studied the gas generation, collection and methods, gradually familiar with and master the company introduced the working principle, operation method of gas machine. With the help of the department leaders and colleagues, familiar with and master the launch of the division principle, debugging method of the control system, and to wuhan Chen Guchong garbage power plant of gas machine control system transformation, learn to debug, accumulated some experience. All in all, over the past year, did some work, have also made some achievements, but the results can only represent the past, there are some problems to work, can't meet the higher requirements. In the future work, I must develop the oneself advantage, lack of correct, foster strengths and circumvent weaknesses, for greater achievements. Looking forward to XXXX years of work, I'll be more efforts, constant progress in their jobs, make greater achievements. Every year I have progress, the growth of believe will get greater returns, I will my biggest contribution to the development of the company, believe in
yourself do better next year!
I wish you all work study progress in the year to come.。