ed5395d0-c219-44a8-85a9-3cb8c46fc354 151 4 5 false false 0 decimal

&[DATE] &[TIME] - &[FILENAME]

User Defined lookup functions for use in this workbook.

value table column vlookup k 1 : j 1 : j table rows ≤ j j 1 + : table j 1 el value ≡ result k 1 el table j column el : k k 1 + : 21 line 0 if for result IsDefined result no match if 31 line :

value table row hlookup k 1 : j 1 : j table cols ≤ j j 1 + : table 1 j el value ≡ result 1 k el table row j el : k k 1 + : 21 line 0 if for 21 line result 21 line :

Input point values for baseline, as taken from InRoads report or other reference. Define line segments (start and end point numbers) that define the baseline.

points.head point no. type STA Northing Easting 15 mat :

segs.head No. type start pt. end pt. center 15 mat :

NOTE: A "lookup function is used later in these calculations. Make sure that the "point no." column is listed in ascending order...for now...

points.1 1001 linePT 726.32 0015 mat :

segs.1 101 line 10011002015 mat :

points.2 1002 PI/PT 770.83 21.5 5.75 15 mat :

segs.2 201 line 10021003015 mat :

points.3 1003 PC 770.83 43 11.5 15 mat :

segs.3 301 curve 10031006100515 mat :

points.4 1004 PI 05000500015 mat :

segs.4 401 line 10061007015 mat :

points.5 1005 CC 0 445.3870 1858.0027 15 mat :

points.6 1006 PT 899.33 166 48.5 15 mat :

points.7 1007 PI/PT 1000 261.5 8115 mat :

points points.1 points.2 points.3 points.4 points.5 points.6 points.7 stack :

segs segs.1 segs.2 segs.3 segs.4 stack :

points 1001 linePT 726.32 001002 PI/PT 770.83 21.5 5.75 1003 PC 770.83 43 11.5 1004 PI 0500050001005 CC 0 445.387 1858.0027 1006 PT 899.33 166 48.5 1007 PI/PT 1000 261.5 8175 mat

segs 101 line 100110020201 line 100210030301 curve 100310061005401 line 10061007045 mat

Assuming fascia lines are parallel the baseline, define offset distance.

Δ.o 10 :

Routine that will assemble table with Northing and Eastings for baseline coordinates.

i 1 segs rows range Seg i el segs i 1 el : Type i el segs i 2 el : Nor_b i el segs i 3 el points 4 vlookup det : East_b i el segs i 3 el points 5 vlookup det : Nor_e i el segs i 4 el points 4 vlookup det : East_e i el segs i 4 el points 5 vlookup det : segs i 2 el curve ≡ Nor_c i el segs i 5 el points 4 vlookup det : East_c i el segs i 5 el points 5 vlookup det : 21 line Nor_c i el 0 : East_c i el 0 : 21 line if 71 line for

coor Seg Type Nor_b East_b Nor_e East_e Nor_c East_c augment :

coor 101 line 00 21.5 5.75 00201 line 21.5 5.75 43 11.5 00301 curve 43 11.5 166 48.5 445.387 1858.0027 401 line 166 48.5 261.5 810048 mat

Routine assemble table of baseline's segment (line and curve) geometric properties.

prop.head No. type length slope, m y-int, b theta chord radius central andgle 19 mat :

i 1 coor rows range Type i el line ≡ Len i el Nor_e i el Nor_b i el - (2^East_e i el East_b i el - (2^+ sqrt : slope i el Nor_e i el Nor_b i el - (East_e i el East_b i el - (/ : yint i el Nor_b i el slope i el East_b i el * - : theta i el East_e i el East_b i el - Nor_e i el Nor_b i el - / atan 180 π / * : chord i el 0 : radius i el 0 : central i el 0 : 71 line Type i el curve ≡ central i el East_e i el East_c i el - Nor_e i el Nor_c i el - / atan East_b i el East_c i el - Nor_b i el Nor_c i el - / atan - (180 π / * : radius i el Nor_c i el Nor_b i el - (2^East_c i el East_b i el - (2^+ sqrt : chord i el Nor_e i el Nor_b i el - (2^East_e i el East_b i el - (2^+ sqrt : theta i el 0 : yint i el 0 : slope 0 : Len i el radius i el central i el * π 180 / * : 71 line Check segment type definition. if if 11 line for

prop Seg Type Len slope yint theta chord radius central augment :

Len 1 el 22.2556

slope 1 el 0

Nor_e 1 el Nor_b 1 el - (21.5

yint 1 el 0

East_e 1 el East_b 1 el - (5.75

Nor_b 1 el slope 1 el East_b 1 el * - 0

Nor_e 1 el Nor_b 1 el - (East_e 1 el East_b 1 el - (/ 3.7391

Nor_e 4 el Nor_b 4 el - (95.5

yint 4 el 23.4846

Len 4 el 100.8786

slope 4 el 2.9385

East_e 4 el East_b 4 el - (32.5

Nor_b 4 el slope 4 el East_b 4 el * - 23.4846

Nor_e 4 el Nor_b 4 el - (East_e 4 el East_b 4 el - (/ 2.9385

Len 2 el 22.2556

slope 2 el 0

Nor_e 2 el Nor_b 2 el - (21.5

yint 2 el 0

East_e 2 el East_b 2 el - (5.75

Nor_b 2 el slope 2 el East_b 2 el * - 21.5

Nor_e 2 el Nor_b 2 el - (East_e 2 el East_b 2 el - (/ 3.7391

Len 3 el 115.9865

chord 3 el 128.4445

radius 3 el 1889.838

central 3 el 3.5165

Nor_e 4 el Nor_b 4 el - (95.5

yint 4 el 23.4846

Len 4 el 100.8786

slope 4 el 2.9385

East_e 4 el East_b 4 el - (32.5

Nor_b 4 el slope 4 el East_b 4 el * - 23.4846

Nor_e 4 el Nor_b 4 el - (East_e 4 el East_b 4 el - (/ 2.9385

prop 101 line 22.2556 00 14.9729 000201 line 22.2556 00 14.9729 000301 curve 115.9865 000 128.4445 1889.838 3.5165 401 line 100.8786 2.9385 23.4846 18.7942 00049 mat