SWMM56

Note:    Export  from  WeatherUnderground   using  the  CSV   File   Export   Option  to  InfoSWMM   Weather   Underground   is a site that provides excellent local  weather  information in the form of graphs, tables and  csv  files. You can use the data very easily in  InfoSWMM  by copying from Excel to a  time   series  in  InfoSWMM . Here is the  rainfall  for a storm event in Tampa, Florida in September 11, 2010 Step 1:   Export  from  WeatherUnderground   using  the  CSV   File   Export   Option Step 2:  The data imported from the  csv   file  to Excel and after the text to columns tool is used looks like this in Excel. The data is now ready to be imported into  InfoSWMM  after the  time  column is adjusted to fall on even  5  minute intervals. In Excel yo...

Note:    Export  from  WeatherUnderground   using  the  CSV   File   Export   Option  to  InfoSWMM   Weather Underground   is a site that provides excellent local weather information in the form of graphs, tables and  csv  files. You can use the data very easily in  InfoSWMM  by copying from Excel to a time series in  InfoSWMM . Here is the rainfall for a storm event in Tampa, Florida in September 11, 2010 Step 1:   Export  from  WeatherUnderground   using  the  CSV   File   Export   Option Step 2:  The data imported from the  csv   file  to Excel and after the text to columns tool is used looks like this in Excel. The data is now ready to be imported into  InfoSWMM  after the time column is adjusted to fall on even 5 minute intervals. In Excel you can use the formula @ROUND((B2)/"0:05:00",0)*"0:05:00" to round all of t...

Note: Export from WeatherUnderground using the CSV File Export Option to InfoSWMM Weather Underground is a site that provides excellent local weather information in the form of graphs, tables and csv files. You can use the data very easily in InfoSWMM by copying from Excel to a time series in InfoSWMM. Here is the rainfall for a storm event in Tampa, Florida in September 11, 2010 Step 1: Export from WeatherUnderground using the CSV File Export Option Step 2: The data imported from the csv file to Excel and after the text to columns tool is used looks like this in Excel. The data is now ready to be imported into InfoSWMM after the time column is adjusted to fall on even 5 minute intervals. In Excel you can use the formula @ROUND((B2)/"0:05:00",0)*"0:05:00" to round all of the time values to 5 minutes. If you do not do this step then you will have problems in InfoSWMM due to the rainfall interval not being equal to the defined raingage interval. Step 3: You ...