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.

No comments:

InfoSWMM Version Numbers and the version of Arc Map they use and which EPA SWMM5 Engine is used for Each InfoSWMM Version

 InfoSWMM Version Numbers  InfoSWMM Version 14.7  Update 3 for Arc Map 10 to 10.8 and Windows 7/8/8.1/10 - EPA SWMM 5.1.014   4/12/2020   ...