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.

InfoSWMM: A 2030 AI-Assisted Study Guide

  InfoSWMM: A 2030 AI-Assisted Study Guide delete   InfoSWMM: A 2030 AI-Assisted Study Guide A comprehensive study guide for someone in 2030...