This worksheet reads data from a file using either comma separated values (.csv) or space separated text files. The file can be created by a text editor such as Notepad, or generated by most spreadsheets. Only numbers can be entered into the file. This means that station identifiers must be integer values. Angular values are entered in the DDD MM SS format. Thus an angle of 23°14'56" is entered as 23 14 56. The format for the file is
Num of dist (ndist), num of ang (nang), num of az (naz), num of control stations (nsta), number of stations (nsta)
Unknown station data: id (integer), x, y //Note this is the opposite order for stations from ADJUST
Control station data: id (integer), x, y
Distance observations: from station id, to station id, horizontal distance, standard deviation
Angle observations: backsight station id, instrument station id, foresight station id, angle, standard deviation (")
Azimuth observations: from station id, to station id, azimuth, standard deviation (")
The example file Example 21.1 is entered as
19 17 0 2 13 //ndist, nang, naz, nctl, nsta
1 2477233.72 420353.59 //unknown stations
2 2477497.89 419951.98 //id x y
3 2477832.55 420210.21
4 2477991.64 420400.58
5 2477630.43 420567.45
6 2477665.22 420323.32
102 2476455.89 419741.38
103 2476735.05 419912.42
201 2476576.23 419589.23
202 2476948.74 419331.29
203 2477463.84 419819.58
2000 2476334.60 419710.09 //control stations
2001 2476297.98 419266.82 //id x y
2001 201 425.90 0.022 //distance observations
201 202 453.10 0.022 //from to distance s
202 203 709.78 0.022
203 3 537.18 0.022
5 3 410.46 0.022
5 4 397.89 0.022
5 6 246.61 0.022
5 1 450.67 0.022
5 2 629.58 0.022
3 2 422.70 0.022
3 1 615.74 0.022
3 5 410.44 0.022
3 6 201.98 0.022
3 4 298.10 0.022
1 2 480.71 0.022
1 3 615.74 0.022
2000 102 125.24 0.022
102 103 327.37 0.022
103 1 665.79 0.022
102 2000 2001 109.10540 25.5 //angle observations
2000 102 103 162.58160 28.9 // backsight occupied foresight ° ' " s"
102 103 1 172.01430 11.8
2000 2001 201 36.04262 7.4
2001 201 202 263.54187 9.7
201 202 203 101.49550 8.1
202 203 3 176.49100 8.4
203 3 2 8.59560 6.5
2 1 3 316.48005 6.3
3 5 4 324.17440 8.1
6 5 3 338.36385 10.7
1 5 3 268.49325 9.8
2 5 3 318.20545 7.0
2 3 1 51.07110 7.2
2 3 5 98.09365 10.3
2 3 6 71.42515 15.1
2 3 4 167.32280 14.5