Line Import Data
Description
A Design Lines or Setting Out Object may be imported from .xls spreadsheet files created by packages such as Bentley MXROAD® by using the Import function. It is important that the data in the spreadsheet file matches the format shown below.
Spreadsheet Format Example
Model Name = DESIGN
String Name = MC34
| Point Number | X | Y | Z | Chainage | Bearing | Radius |
|---|---|---|---|---|---|---|
| 1 | 450.346 | 858.761 | 93.379 | .000 | 78.818 | 999999.9 |
| 2 | 460.156 | 860.700 | 93.379 | 10.000 | 78.818 | 999999.9 |
| 3 | 469.966 | 862.640 | 93.415 | 20.000 | 78.818 | 999999.9 |
| 4 | 479.776 | 864.579 | 93.433 | 30.000 | 78.818 | 999999.9 |
| 5 | 489.586 | 866.518 | 93.451 | 40.000 | 78.818 | 999999.9 |
| 6 | 499.397 | 868.458 | 93.469 | 50.000 | 78.818 | 999999.9 |
| 7 | 509.207 | 870.397 | 93.487 | 60.000 | 78.818 | 999999.9 |
| 8 | 515.440 | 871.629 | 93.498 | 66.354 | 78.818 | 999999.9 |
| 9 | 519.017 | 872.334 | 93.505 | 70.000 | 78.924 | 987.365 |
| 10 | 528.849 | 874.160 | 93.523 | 80.000 | 80.3 | 263.812 |
| 11 | 533.147 | 874.854 | 93.531 | 84.354 | 81.396 | 200 |
| 12 | 538.741 | 875.620 | 93.541 | 90.000 | 83.014 | 200 |
| 13 | 548.693 | 876.588 | 93.559 | 100.000 | 85.878 | 200 |
| 14 | 558.681 | 877.057 | 93.577 | 110.000 | 88.743 | 200 |
| 15 | 567.043 | 877.066 | 93.592 | 118.362 | 91.139 | 200 |
| 16 | 568.680 | 877.026 | 93.596 | 120.000 | 91.608 | 200 |
| 17 | 578.665 | 876.496 | 93.655 | 130.000 | 94.473 | 200 |
| 18 | 584.974 | 875.902 | 93.725 | 136.337 | 96.288 | 200 |
| 19 | 588.611 | 875.470 | 93.777 | 140.000 | 97.231 | 251.091 |
| 20 | 598.511 | 874.060 | 93.962 | 150.000 | 98.717 | 829.985 |
| 21 | 601.631 | 873.576 | 94.033 | 153.158 | 98.835 | 3044.377 |
In the above example the Link Type can be deduced from the 'Bearing' and 'Radius' columns as...
1 to 8) Line
8 to 11) Transition
11 to 18) Arc
18 to 21) Transition