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.

AI Rivers of Wisdom about ICM SWMM

Here's the text "Rivers of Wisdom" formatted with one sentence per line: [Verse 1] 🌊 Beneath the ancient oak, where shadows p...