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:

Today is day 356 or 97.5 percent of the year 2024

English: Today is day 356 or 97.5 percent of the year 2024 Mandarin Chinese: 今天是2024年的第356天,即97.5% Hindi: आज 2024 का 356वां दिन या 97.5 प्रत...