Hello all,sir!.i have been tried so hard with the data input of a historical rainfall data INTO times series USER DEFINED GRID of EPA SWMM5.1, but i keep getting the ERROR telling me "time out of order" in which I have a daily rainfall data recorded at 9:00:00 every day for 25 years(only available data) in excel. how can i make it work sir?? in case my data is attached below,thanx a %28FORMAT%29%20SWMM%20INPUT%20Time%20series%20of%20all%20station%20in%20mekelle.xlsx lot.
You need to be a member of SWMM 5 or SWMM or EPASWMM and SWMM5 in ICM_SWMM to add comments!
Replies
Good morning, as I said it works for me in another model. Why don't you send me the actual model that is failing for you to robert.dickinson@gmail.com so I can look? You do NOT have to have the file using any particular extension such as .DAT
and is it necessary to save it txt file first and next save it as dat file? may be if it is must, how can i save it as a dat file then import to SWMM?b/c i see such discussions before.
OK then sir i have tried it repeatedly ..fail again...but is there any sensitive conditions in importing the data through txt. or gap between columns..while saving to text file or any?
Hi, Your 2nd format worked for me, i added a comment to the top line
*********************
Rainfall File Summary
*********************
Station First Last Recording Periods Periods Periods
ID Date Date Frequency w/Precip Missing Malfunc.
-------------------------------------------------------------------------------
airport24 01/01/1992 03/30/1992 1440 min 14 0 0
;Station ID year month day hour Minute VALUE(mm)
Airport24 1992 1 1 9 0 0.2
Airport24 1992 1 10 9 0 0.1
Airport24 1992 1 15 9 0 0.2
Airport24 1992 1 17 9 0 4.9
Airport24 1992 1 19 9 0 2.8
Airport24 1992 1 22 9 0 0.1
Airport24 1992 1 28 9 0 0.6
Airport24 1992 2 1 9 0 2.1
Airport24 1992 3 14 9 0 3.2
Airport24 1992 3 16 9 0 4.1
Airport24 1992 3 17 9 0 30
Airport24 1992 3 18 9 0 0.3
Airport24 1992 3 19 9 0 0.2
Airport24 1992 3 30 9 0 0.7
and incase am using EPA SWMM Version 5.12
Sir!i don"t really understand the time format u used and i have already done it same as u recommend me and keep getting error 363 and 336.can u check what format i used?
second format trial
Hi, The format should be like this for use defined rainfall
Rainfall 1994 09 01 14 00 0.020
Rainfall 1994 09 03 11 00 0.010
Rainfall 1994 09 13 19 00 0.024
Rainfall 1994 09 13 20 00 0.136
Rainfall 1994 09 21 07 00 0.100
Rainfall 1994 09 21 16 00 0.100
Rainfall 1994 10 03 19 00 0.200
Rainfall 1994 10 04 09 00 0.110
Rainfall 1994 10 05 16 00 0.115
Rainfall 1994 10 05 22 00 0.115