<content> <p>Logic for Selecting Height</p> </content>

49978d0a-2a76-480d-892d-604c4465ccb4 38 Ian HOOTON 4 5 false false 0 decimal

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

k.2 Height (m) Terrain cat 1 Terrain cat 2 Terrain cat 3 Terrain cat 4 10 m * 1.05 1 0.91 0.8 15 m * 1.09 1.05 0.97 0.8 20 m * 1.12 1.07 1.01 0.8 30 m * 1.15 1.12 1.06 0.97 50 m * 1.2 1.17 1.12 1.1 100 m * 1.26 1.24 1.2 1.2 150 m * 1.3 1.28 1.24 1.24 200 m * 1.32 1.3 1.27 1.27 250 m * 1.34 1.32 1.29 1.28 105 mat :

A Terrain cat 1 2 Terrain cat 2 3 Terrain cat 3 4 Terrain cat 4 542 mat :

Terrain

Height of Stack H.1 100 m * :

Height of each zone must be less than 10m z.h H.1 10 / : 10 m *

Number of Zones must be more than 3 z H.1 z.h / : 10

Create Range H.2 0 m * (H.1 z.h range (:

Remove Om entry H.2 11 removeRows

Elevations To Use H H.2 11 removeRows reverse : 100 m * 90 m * 80 m * 70 m * 60 m * 50 m * 40 m * 30 m * 20 m * 10 m * 101 mat

<content> <p>Logic for Selecting Height</p> </content>

y f.3 y 50 / Floor 50 * :

Lower Height Boundary T.l H 10 m * ≤ T.l 10 m * : H 15 m * ≡ T.l 15 m * : H 20 m * ≡ T.l 20 m * : H 30 m * ≡ T.l 30 m * : H 50 m * ≡ T.l 50 m * : H 100 m * ≡ T.l 100 m * : H 10 m * > (H 15 m * < (& T.l 10 m * : H 15 m * > (H 20 m * < (& T.l 15 m * : H 20 m * > (H 30 m * < (& T.l 20 m * : H 30 m * > (H 50 m * < (& T.l 30 m * : H f.3 if if if if if if if if if if vectorize : 100 m * 50 m * 50 m * 50 m * 50 m * 50 m * 30 m * 30 m * 20 m * 10 m * 101 mat

Upper Height Boundary T.h H 10 m * ≤ T.h 10 m * : H 15 m * ≡ T.h 15 m * : H 20 m * ≡ T.h 20 m * : H 30 m * ≡ T.h 30 m * : H 50 m * ≡ T.h 50 m * : H 100 m * ≡ T.h 100 m * : H 150 m * ≡ T.h 150 m * : H 200 m * ≡ T.h 200 m * : H 250 m * ≡ T.h 250 m * : H 10 m * > (H 15 m * ≤ (& T.h 15 m * : H 15 m * > (H 20 m * ≤ (& T.h 20 m * : H 20 m * > (H 30 m * ≤ (& T.h 30 m * : H 30 m * > (H 50 m * ≤ (& T.h 50 m * : H f.3 50 m * + if if if if if if if if if if if if if vectorize : 100 m * 100 m * 100 m * 100 m * 100 m * 50 m * 50 m * 30 m * 20 m * 10 m * 101 mat

The Value of H should either lay between the two values below, or if a number in the first column of table k.2, both should equal that number

Look up to find k2 factor table value 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 31 line :

Lower Height T.l 100 m * 50 m * 50 m * 50 m * 50 m * 50 m * 30 m * 30 m * 20 m * 10 m * 101 mat

Upper Height T.h 100 m * 100 m * 100 m * 100 m * 100 m * 50 m * 50 m * 30 m * 20 m * 10 m * 101 mat

Look up for lower band k.l k 1 T.l rows range q k el k.2 T.l k el f vlookup : for q 21 line :

Look up for upper band k.h k 1 T.h rows range q k el k.2 T.h k el f vlookup : for q 21 line :

k.l 1.26 11 mat 1.2 11 mat 1.2 11 mat 1.2 11 mat 1.2 11 mat 1.2 11 mat 1.15 11 mat 1.15 11 mat 1.12 11 mat 1.05 11 mat 101 mat

k.h 1.26 11 mat 1.26 11 mat 1.26 11 mat 1.26 11 mat 1.26 11 mat 1.2 11 mat 1.2 11 mat 1.15 11 mat 1.12 11 mat 1.05 11 mat 101 mat

Tidy up of kl k.l joinRows j 1 k.l rows range Rt j el k.l j 1 el : k.l cols 1 > k 2 k.l cols range Rt j el Rt j el k.l j k el augment : for 0 if 21 line for Rt 21 line : tmp k.l joinRows : k.l tmp transpose joinRows transpose 1 el : 31 line

Tidy up of kh k.h joinRows j 1 k.h rows range Rt j el k.h j 1 el : k.h cols 1 > k 2 k.h cols range Rt j el Rt j el k.h j k el augment : for 0 if 21 line for Rt 21 line : tmpk.h k.h joinRows : k.h tmpk.h transpose joinRows transpose 1 el : 31 line

Stack and split the upper and lower range values

k.l k.h stack transpose 1.26 1.26 1.2 1.26 1.2 1.26 1.2 1.26 1.2 1.26 1.2 1.2 1.15 1.2 1.15 1.15 1.12 1.12 1.05 1.05 102 mat

k.l k.h stack transpose 1 col 1.26 1.2 1.2 1.2 1.2 1.2 1.15 1.15 1.12 1.05 101 mat

k.l k.h stack transpose 2 col 1.26 1.26 1.26 1.26 1.26 1.2 1.2 1.15 1.12 1.05 101 mat

Assign to variables for ease

k.2.l k.l k.h stack transpose 1 col :

z.2.l T.l :

k.2.h k.l k.h stack transpose 2 col :

z.2.h T.h :

k.2.l 1.26 1.2 1.2 1.2 1.2 1.2 1.15 1.15 1.12 1.05 101 mat

k.2.h 1.26 1.26 1.26 1.26 1.26 1.2 1.2 1.15 1.12 1.05 101 mat

z.2.l 100 m * 50 m * 50 m * 50 m * 50 m * 50 m * 30 m * 30 m * 20 m * 10 m * 101 mat

z.2.h 100 m * 100 m * 100 m * 100 m * 100 m * 50 m * 50 m * 30 m * 20 m * 10 m * 101 mat

H 100 m * 90 m * 80 m * 70 m * 60 m * 50 m * 40 m * 30 m * 20 m * 10 m * 101 mat

Interpolation of factor k.2 for given H

k.2f1 l 1 k.2.l rows range k.2.l 1 el k.2.h l el ≡ k.2.l 1 el k.2.l 1 el k.2.h l el k.2.l 1 el - z.2.h l el z.2.l 1 el - m / / H 1 el z.2.l 1 el - (m / * + if for f 21 line :

Final Value of K.2 k.2f k.2.l 1 el k.2.h 1 el ≡ k.2.l 1 el k.2.l 1 el k.2.h 1 el k.2.l 1 el - z.2.h 1 el z.2.l 1 el - m / / H 1 el z.2.l 1 el - (m / * + if : 1.26

k.2f1 2

Final Value of K.2 k.2f k.2.l 2 el k.2.h 2 el ≡ k.2.l 2 el k.2.l 2 el k.2.h 2 el k.2.l 2 el - z.2.h 2 el z.2.l 2 el - m / / H 2 el z.2.l 2 el - (m / * + if : 1.248

should be as below

k.2fl 1.26 1.248 # # # # # # 1.12 1.05 101 mat ≡

up to the end, in this case 10 but can be more or less depending on H, zh and z

Final Value of K.2 k.2f k.2.l 10 el k.2.h 10 el ≡ k.2.l 10 el k.2.l 10 el k.2.h 10 el k.2.l 10 el - z.2.h 10 el z.2.l 10 el - m / / H 10 el z.2.l 10 el - (m / * + if : 1.05