Spreadsheet: 79349d1279635318-creating-worksheets-from-cell-values-buckshead-datasheet-example
Sheet: clearoute file name

 |  |  | Scantech International Ltd- Tunnel profile datasheet
 |  |  | Project | Buckshead
 |  |  | ELR | MLN
 |  |  |  |  | miles | chain | yards |  |  | miles | chain | yards
 |  |  | Tunnel Start Chainage |  | 299 | 10 | 0 | Profile start chainage |  | 299 | 10 | 0
 |  |  | Tunnel End Chainage |  |  |  |  | Profile end chainage |  | 299 | 24 | 10
 |  |  | Section start on cyclone section |  |  |  |  | 5 | interval |  | 1ch= | 20.1168 | m | 1ch= | 22 | yds
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1
Data Range Yard code |  |  |  | cyclone section | miles | ch | ch integer | ch decimal | yds | yd code | m | cyclone section | File name |  | UP RADIUS | DN RADIUS
 |  |  |  | 0 | 299 | 10 | 10 | 0 | 0 | 0 | 201.68 | 0 | 299100AM.SC0
0 | 0 |  |  | 5 | 299 | 10.27399984092897 | 10 | 0.2739998409289743 | 6 | F | 206.68 | 5 | 29910FAM.SC0 |  | 683.219 | 634.433
1 | A |  |  | 10 | 299 | 10.52254831782391 | 10 | 0.5225483178239081 | 11 | K | 211.68 | 10 | 29910KAM.SC0 |  | 591.675 | 563.799
2 | B |  |  | 15 | 299 | 10.77109679471884 | 10 | 0.7710967947188418 | 17 | Q | 216.68 | 15 | 29910QAM.SC0 |  | 771.272 | 569.176
3 | C |  |  | 20 | 299 | 11.01964527161378 | 11 | 0.01964527161377561 | 0 | 0 | 221.68 | 20 | 299110AM.SC0 |  | 591.675 | 563.799
4 | D |  |  | 25 | 299 | 11.26819374850871 | 11 | 0.2681937485087094 | 6 | F | 226.68 | 25 | 29911FAM.SC0 |  | 625.144 | 710.372
5 | E |  |  | 30 | 299 | 11.51674222540364 | 11 | 0.5167422254036431 | 11 | K | 231.68 | 30 | 29911KAM.SC0 |  | 765.073 | 569.544
6 | F |  |  | 35 | 299 | 11.76529070229858 | 11 | 0.7652907022985751 | 17 | Q | 236.68 | 35 | 29911QAM.SC0 |  | 598.799 | 678.833
7 | G |  |  | 40 | 299 | 12.01383917919351 | 12 | 0.01383917919350885 | 0 | 0 | 241.68 | 40 | 299120AM.SC0 |  | 694.576 | 651.631
8 | H |  |  | 45 | 299 | 12.26238765608844 | 12 | 0.2623876560884426 | 6 | F | 246.68 | 45 | 29912FAM.SC0 |  | 634.146 | 741.992
9 | I |  |  | 50 | 299 | 12.51093613298338 | 12 | 0.5109361329833764 | 11 | K | 251.68 | 50 | 29912KAM.SC0 |  | 594.011 | 656.108
10 | J |  |  | 55 | 299 | 12.75948460987831 | 12 | 0.7594846098783101 | 17 | Q | 256.68 | 55 | 29912QAM.SC0 |  | 716.193 | 731.844
11 | K |  |  | 60 | 299 | 13.00803308677324 | 13 | 0.00803308677324388 | 0 | 0 | 261.68 | 60 | 299130AM.SC0 |  | 633.666 | 905.913
12 | L |  |  | 65 | 299 | 13.25658156366818 | 13 | 0.2565815636681776 | 6 | F | 266.68 | 65 | 29913FAM.SC0 |  | 599.447 | 667.288
13 | M |  |  | 70 | 299 | 13.50513004056311 | 13 | 0.5051300405631114 | 11 | K | 271.68 | 70 | 29913KAM.SC0 |  | 1279.089 | 874.528
14 | N |  |  | 75 | 299 | 13.75367851745805 | 13 | 0.7536785174580451 | 17 | Q | 276.68 | 75 | 29913QAM.SC0 |  | 724.07 | 772.415
15 | O |  |  | 80 | 299 | 14.00222699435298 | 14 | 0.00222699435297713 | 0 | 0 | 281.68 | 80 | 299140AM.SC0 |  | 987.179 | 869.941
16 | P |  |  | 85 | 299 | 14.25077547124791 | 14 | 0.2507754712479109 | 6 | F | 286.68 | 85 | 29914FAM.SC0 |  | 833.349 | 740.103
17 | Q |  |  | 90 | 299 | 14.49932394814284 | 14 | 0.4993239481428446 | 11 | K | 291.68 | 90 | 29914KAM.SC0 |  | 871.611 | 730.29
18 | R |  |  | 95 | 299 | 14.74787242503778 | 14 | 0.7478724250377784 | 16 | P | 296.68 | 95 | 29914PAM.SC0 |  | 762.356 | 738.592
19 | S |  |  | 100 | 299 | 14.99642090193271 | 14 | 0.9964209019327122 | 22 | 0 | 301.68 | 100 | 299140AM.SC0 |  | 1075.697 | 617.935
20 | T |  |  | 105 | 299 | 15.24496937882765 | 15 | 0.2449693788276459 | 5 | E | 306.68 | 105 | 29915EAM.SC0 |  | 812.664 | 718.226
21 | U |  |  | 110 | 299 | 15.49351785572258 | 15 | 0.4935178557225797 | 11 | K | 311.68 | 110 | 29915KAM.SC0 |  | 881.835 | 869.174
22 | 0 |  |  | 115 | 299 | 15.74206633261751 | 15 | 0.7420663326175134 | 16 | P | 316.68 | 115 | 29915PAM.SC0 |  | 738.548 | 777.268
 |  |  |  | 120 | 299 | 15.99061480951245 | 15 | 0.9906148095124472 | 22 | 0 | 321.68 | 120 | 299150AM.SC0 |  | 700.534 | 856.113
 |  |  |  | 125 | 299 | 16.23916328640738 | 16 | 0.2391632864073792 | 5 | E | 326.68 | 125 | 29916EAM.SC0 |  | 768.665 | 933.616
 |  |  |  | 130 | 299 | 16.48771176330231 | 16 | 0.4877117633023147 | 11 | K | 331.68 | 130 | 29916KAM.SC0 |  | 617.23 | 741.785
 |  |  |  | 135 | 299 | 16.73626024019725 | 16 | 0.7362602401972467 | 16 | P | 336.68 | 135 | 29916PAM.SC0 |  | 872.368 | 872.368
 |  |  |  | 140 | 299 | 16.98480871709218 | 16 | 0.9848087170921822 | 22 | 0 | 341.68 | 140 | 299160AM.SC0 |  | 767.404 | 939.932
 |  |  |  | 145 | 299 | 17.23335719398711 | 17 | 0.2333571939871142 | 5 | E | 346.68 | 145 | 29917EAM.SC0 |  | 920.397 | 861.48
 |  |  |  | 150 | 299 | 17.48190567088205 | 17 | 0.4819056708820497 | 11 | K | 351.68 | 150 | 29917KAM.SC0 |  | 736.828 | 682.202
 |  |  |  | 155 | 299 | 17.73045414777698 | 17 | 0.7304541477769817 | 16 | P | 356.68 | 155 | 29917PAM.SC0 |  | 853.66 | 788.985
 |  |  |  | 160 | 299 | 17.97900262467191 | 17 | 0.9790026246719137 | 22 | 0 | 361.68 | 160 | 299170AM.SC0 |  | 822.277 | 867.284
 |  |  |  | 165 | 299 | 18.22755110156685 | 18 | 0.2275511015668492 | 5 | E | 366.68 | 165 | 29918EAM.SC0 |  | 939.807 | 786.597
 |  |  |  | 170 | 299 | 18.47609957846178 | 18 | 0.4760995784617812 | 10 | J | 371.68 | 170 | 29918JAM.SC0 |  | 649.892 | 657.312
 |  |  |  | 175 | 299 | 18.72464805535672 | 18 | 0.7246480553567167 | 16 | P | 376.68 | 175 | 29918PAM.SC0 |  | 648.188 | 806.415
 |  |  |  | 180 | 299 | 18.97319653225165 | 18 | 0.9731965322516487 | 21 | U | 381.68 | 180 | 29918UAM.SC0 |  | 1054.426 | 785.951
 |  |  |  | 185 | 299 | 19.22174500914658 | 19 | 0.2217450091465842 | 5 | E | 386.68 | 185 | 29919EAM.SC0 |  | 622.483 | 666.757
 |  |  |  | 190 | 299 | 19.47029348604152 | 19 | 0.4702934860415162 | 10 | J | 391.68 | 190 | 29919JAM.SC0 |  | 755.411 | 737.14
 |  |  |  | 195 | 299 | 19.71884196293645 | 19 | 0.7188419629364518 | 16 | P | 396.68 | 195 | 29919PAM.SC0 |  | 1035.593 | 688.455
 |  |  |  | 200 | 299 | 19.96739043983138 | 19 | 0.9673904398313837 | 21 | U | 401.68 | 200 | 29919UAM.SC0 |  | 572.993 | 832.715
 |  |  |  | 205 | 299 | 20.21593891672632 | 20 | 0.2159389167263157 | 5 | E | 406.68 | 205 | 29920EAM.SC0 |  | 690.039 | 684.912
 |  |  |  | 210 | 299 | 20.46448739362125 | 20 | 0.4644873936212512 | 10 | J | 411.68 | 210 | 29920JAM.SC0 |  | 622.125 | 633.758
 |  |  |  | 215 | 299 | 20.71303587051618 | 20 | 0.7130358705161832 | 16 | P | 416.68 | 215 | 29920PAM.SC0 |  | 689.99 | 789.499
 |  |  |  | 220 | 299 | 20.96158434741112 | 20 | 0.9615843474111188 | 21 | U | 421.68 | 220 | 29920UAM.SC0 |  | 713.037 | 672.13
 |  |  |  | 225 | 299 | 21.21013282430605 | 21 | 0.2101328243060507 | 5 | E | 426.68 | 225 | 29921EAM.SC0 |  | 706.866 | 721.65
 |  |  |  | 230 | 299 | 21.45868130120099 | 21 | 0.4586813012009863 | 10 | J | 431.68 | 230 | 29921JAM.SC0 |  | 721.097 | 602.195
 |  |  |  | 235 | 299 | 21.70722977809592 | 21 | 0.7072297780959182 | 16 | P | 436.68 | 235 | 29921PAM.SC0 |  | 717.575 | 683.404
 |  |  |  | 240 | 299 | 21.95577825499085 | 21 | 0.9557782549908538 | 21 | U | 441.68 | 240 | 29921UAM.SC0 |  | 688.069 | 830.325
 |  |  |  | 245 | 299 | 22.20432673188579 | 22 | 0.2043267318857858 | 4 | D | 446.68 | 245 | 29922DAM.SC0 |  | 652.788 | 732.347
 |  |  |  | 250 | 299 | 22.45287520878072 | 22 | 0.4528752087807177 | 10 | J | 451.68 | 250 | 29922JAM.SC0 |  | 738.798 | 668.154
 |  |  |  | 255 | 299 | 22.70142368567565 | 22 | 0.7014236856756533 | 15 | O | 456.68 | 255 | 29922OAM.SC0 |  | 814.682 | 762.283
 |  |  |  | 260 | 299 | 22.94997216257059 | 22 | 0.9499721625705853 | 21 | U | 461.68 | 260 | 29922UAM.SC0 |  | 602.195 | 673.907
 |  |  |  | 265 | 299 | 23.19852063946552 | 23 | 0.1985206394655208 | 4 | D | 466.68 | 265 | 29923DAM.SC0 |  | 938.337 | 749.641
 |  |  |  | 270 | 299 | 23.44706911636045 | 23 | 0.4470691163604528 | 10 | J | 471.68 | 270 | 29923JAM.SC0 |  | 701.749 | 821.467
 |  |  |  | 275 | 299 | 23.69561759325539 | 23 | 0.6956175932553883 | 15 | O | 476.68 | 275 | 29923OAM.SC0 |  | 783.873 | 740.256
 |  |  |  | 280 | 299 | 23.94416607015032 | 23 | 0.9441660701503203 | 21 | U | 481.68 | 280 | 29923UAM.SC0 |  | 910.124 | 818.623
 |  |  |  | 285 | 299 | 24.19271454704526 | 24 | 0.1927145470452558 | 4 | D | 486.68 | 285 | 29924DAM.SC0 |  | 728.519 | 663.463
 |  |  |  | 290 | 299 | 24.44126302394019 | 24 | 0.4412630239401878 | 10 | J | 491.68 | 290 | 29924JAM.SC0