Showing posts with label How to Use Excel to Make Random X Y Coordinates in SWMM 5. Show all posts
Showing posts with label How to Use Excel to Make Random X Y Coordinates in SWMM 5. Show all posts

Saturday, June 15, 2013

How to Use Excel to Make Random X, Y Coordinates in SWMM 5


NodeXYRand XRand Y
A2465753425-17995018681114137518-1734364827
B1220423412-915317559.2959332294.5-427183555.6
C1207970112-2970112080939805860-417442286.9
D-485678704.92970112080-172000249.51835904922
E-27895392281388542964-2050647732326604825.1
F-4221668742-130759651.3-3537896272-59872442.99

If you have a SWMM 5 file without any X, Y  coordinates you can assume an X and a Y and then use Excel to make each pair random by using the RAND() function.  You at least will see each of the nodes on the screen with associated links.

The Goal of SWMM5 Input Files

 ðŸŒŸ SWMM5 (Storm Water Management Model 5) is a widely used urban hydrology and hydraulic modeling software developed by the United States E...