I have two columns with the names, units, and range as followsthat look like this:
Start_Post End_Post
---------- --------
102+20.45 153+19.22
120+21.25 220+25.30
... ...
Column1: Start_post
Units: Ft
Min Range And I want to introduce a constraint to each column:
Start_Pos
Min Range: 100+50.30
Max Range: 150+20.65End_Pos
Min Range: 150+60.30
Max Range: 500+20.75
All values are in feet and follow a special format. It's a construction convention and I am not an expert but to my knowledge, 1+00 would be 100 feet. Essentially, taking the above range of 100+50.30
Max Range: to 150+20.65
Column2: End_Post
Units: Ft
Min Range: 150+60 would mean a distance of 4970 ft.30
Max Range: 500+20 What I did was just remove the plus sign and subtract the two numbers.75 Hope that made sense.
Is there a way to define this constraint whilst maintaining the format?