Spreadsheet: 728843d1618700035-interpolated-data-look-up-in-xls-sheet-using-4-variables-how-to-do-this-reference-brake-energy-3-
Sheet: Sheet1

 |  | BRAKES ON SPEED (KIAS)
 |  | 80 |  |  | 100 |  |  | 120 |  |  | 140 |  |  | 160 |  |  | 180 |  |  |  |  |  |  |  |  |  | Match
WEIGHT | OAT | PRESSURE ALTITUDE (1000 FT) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rows/Columns
(1000 KG) | (°C) | 0 | 5 | 10 | 0 | 5 | 10 | 0 | 5 | 10 | 0 | 5 | 10 | 0 | 5 | 10 | 0 | 5 | 10 |  |  | 1. Brake on speed: 150 KIAS |  |  |  | 150 |  |  | error by <80 |  | SPD < 80 wordt 80
300 | 0 | 18.3 | 20.7 | 23.4 | 27.3 | 31.3 | 36 | 37.8 | 43.7 | 50.6 | 49.5 | 57.5 | 67 | 62.2 | 72.4 | 84.5 | 75.2 | 87.4 | 101 | 1 |  | 2. Weight: 250 TONS |  |  |  | 250 |  |  | error by >300 |  | WT <=180T wordt 179.99 ter voorkoming [NAME] buiten de bracket
 | 10 | 18.8 | 21.3 | 24.1 | 28.2 | 32.3 | 37.1 | 39 | 45.1 | 52.2 | 51.1 | 59.4 | 69.1 | 64.2 | 74.7 | 87.1 | 77.5 | 90.1 | 104 | 2 |  | 3. Temperature: 25 DEGREES C |  |  |  | 25 |  |  | error by <0 |  | OAT >= 40 wordt 39.99 ter voorkoming [NAME] buiten de bracket, OAT <0 wordt 0
 | 15 | 19.1 | 21.6 | 24.5 | 28.7 | 32.8 | 37.7 | 39.7 | 45.9 | 53.2 | 52 | 60.4 | 70.3 | 65.3 | 76 | 88.5 | 78.8 | 91.5 | 106 | 3 |  | 4. Pressure Altitude: 2000 FT |  |  |  | 2000 |  |  | error by <0 |  | PA >= 10.000 wordt 9.999 ter voorkoming [NAME] buiten de bracket, PA <0 wordt 0
 | 20 | 19.5 | 22 | 24.9 | 29.2 | 33.4 | 38.4 | 40.4 | 46.7 | 54.1 | 52.9 | 61.4 | 71.5 | 66.4 | 77.2 | 89.9 | 80.1 | 92.9 | 107 | 4
 | 30 | 19.9 | 22.5 | 25.5 | 29.9 | 34.3 | 39.4 | 41.5 | 48 | 55.6 | 54.4 | 63.2 | 73.5 | 68.3 | 79.4 | 92.3 | 82.3 | 95.4 | 110 | 5 |  | should return the output of 56.24
 | 40 | 20.1 | 22.8 | 25.8 | 30.3 | 34.8 | 40.1 | 42.2 | 48.8 | 56.7 | 55.4 | 64.5 | 75.1 | 69.7 | 81.1 | 94.3 | 84.1 | 97.5 | 112 | 6
280 | 0 | 17.3 | 19.5 | 22.1 | 25.8 | 29.6 | 33.9 | 35.7 | 41.2 | 47.6 | 46.7 | 54.2 | 63 | 58.6 | 68.2 | 79.5 | 70.9 | 82.5 | 96.2 | 7
 | 10 | 17.8 | 20.1 | 22.7 | 26.6 | 30.4 | 34.9 | 36.8 | 42.5 | 49.2 | 48.2 | 55.9 | 65 | 60.5 | 70.4 | 82 | 73.2 | 85.1 | 99 | 8 |  |  | <==Result
 | 15 | 18.1 | 20.5 | 23.1 | 27.1 | 31 | 35.6 | 37.5 | 43.2 | 50 | 49 | 56.9 | 66.2 | 61.5 | 71.6 | 83.4 | 74.4 | 86.5 | 100 | 9
 | 20 | 18.4 | 20.8 | 23.5 | 27.6 | 31.5 | 36.2 | 38.1 | 44 | 50.9 | 49.9 | 57.9 | 67.3 | 62.6 | 72.8 | 84.7 | 75.6 | 87.8 | 102 | 10
 | 30 | 18.9 | 21.3 | 24.1 | 28.3 | 32.3 | 37.1 | 39.1 | 45.2 | 52.3 | 51.3 | 59.5 | 69.2 | 64.4 | 74.8 | 87 | 77.8 | 90.2 | 104 | 11
 | 40 | 19 | 21.5 | 24.4 | 28.6 | 32.8 | 37.7 | 39.8 | 46 | 53.3 | 52.2 | 60.7 | 70.7 | 65.7 | 76.4 | 88.9 | 79.5 | 92.2 | 106 | 12
260 | 0 | 16.4 | 18.4 | 20.8 | 24.4 | 27.8 | 31.8 | 33.5 | 38.6 | 44.6 | 43.8 | 50.8 | 59 | 54.9 | 63.9 | 74.5 | 66.5 | 77.5 | 90.4 | 13
 | 10 | 16.8 | 19 | 21.4 | 25.1 | 28.6 | 32.8 | 34.6 | 39.8 | 46.1 | 45.2 | 52.4 | 60.9 | 56.7 | 65.9 | 76.8 | 68.7 | 79.9 | 93.1 | 14
 | 15 | 17.1 | 19.3 | 21.8 | 25.5 | 29.1 | 33.4 | 35.2 | 40.6 | 46.9 | 46 | 53.3 | 62 | 57.7 | 67.1 | 78.1 | 69.9 | 81.2 | 94.5 | 15 |  | [NAME]. T 1 | Cel 1 | Corr. T 2 | [NAME] | Cel 1 + T | [NAME] T | [NAME] | Interpolated
 | 20 | 17.4 | 19.6 | 22.1 | 26 | 29.7 | 34 | 35.8 | 41.3 | 47.7 | 46.8 | 54.2 | 63 | 58.7 | 68.2 | 79.4 | 71 | 82.5 | 96 | 16
 | 30 | 17.8 | 20.1 | 22.7 | 26.6 | 30.4 | 34.8 | 36.8 | 42.4 | 49 | 48.1 | 55.8 | 64.8 | 60.3 | 70.1 | 81.6 | 73 | 84.8 | 98.5 | 17
 | 40 | 18 | 20.3 | 22.9 | 26.9 | 30.8 | 35.4 | 37.3 | 43.1 | 49.9 | 49 | 56.8 | 66.1 | 61.6 | 71.6 | 83.4 | 74.6 | 86.7 | 100 | 18
240 | 0 | 15.5 | 17.4 | 19.5 | 22.9 | 26.1 | 29.7 | 31.4 | 36.1 | 41.6 | 40.9 | 47.3 | 54.9 | 51.2 | 59.5 | 69.3 | 62 | 72.2 | 84.2 | 19
 | 10 | 15.9 | 17.8 | 20.1 | 23.5 | 26.8 | 30.6 | 32.4 | 37.2 | 43 | 42.2 | 48.8 | 56.7 | 52.8 | 61.4 | 71.5 | 64 | 74.5 | 86.8 | 20
 | 15 | 16.2 | 18.2 | 20.4 | 24 | 27.3 | 31.2 | 32.9 | 37.9 | 43.7 | 42.9 | 49.7 | 57.7 | 53.8 | 62.5 | 72.7 | 65.1 | 75.8 | 88.2 | 21
 | 20 | 16.4 | 18.5 | 20.8 | 24.4 | 27.8 | 31.7 | 33.5 | 38.6 | 44.5 | 43.7 | 50.6 | 58.7 | 54.7 | 63.5 | 74 | 66.2 | 77 | 89.6 | 22
 | 30 | 16.8 | 18.9 | 21.2 | 25 | 28.5 | 32.6 | 34.4 | 39.6 | 45.7 | 44.9 | 52 | 60.3 | 56.2 | 65.3 | 76 | 68.1 | 79.2 | 92.1 | 23
 | 40 | 16.9 | 19 | 21.5 | 25.3 | 28.9 | 33 | 34.9 | 40.2 | 46.5 | 45.7 | 53 | 61.6 | 57.3 | 66.7 | 77.7 | 69.6 | 80.9 | 94.1 | 24 |  | T basis
220 | 0 | 14.5 | 16.3 | 18.2 | 21.4 | 24.3 | 27.7 | 29.2 | 33.5 | 38.6 | 37.9 | 43.8 | 50.8 | 47.4 | 55 | 64 | 57.4 | 66.8 | 77.9 | 25 |  | Delta T
 | 10 | 14.9 | 16.7 | 18.7 | 22 | 25 | 28.5 | 30.1 | 34.6 | 39.8 | 39.1 | 45.2 | 52.4 | 48.9 | 56.8 | 66.1 | 59.2 | 68.9 | 80.3 | 26 |  | PA basis
 | 15 | 15.2 | 17 | 19.1 | 22.4 | 25.5 | 29 | 30.7 | 35.2 | 40.5 | 39.8 | 46 | 53.4 | 49.8 | 57.8 | 67.2 | 60.3 | 70.1 | 81.7 | 27 |  | Delta PA | 5000
 | 20 | 15.5 | 17.3 | 19.4 | 22.8 | 25.9 | 29.5 | 31.2 | 35.8 | 41.2 | 40.5 | 46.8 | 54.3 | 50.6 | 58.8 | 68.4 | 61.3 | 71.3 | 83 | 28
 | 30 | 15.8 | 17.7 | 19.9 | 23.3 | 26.6 | 30.3 | 32 | 36.8 | 42.4 | 41.6 | 48.1 | 55.8 | 52.1 | 60.4 | 70.3 | 63 | 73.3 | 85.3 | 29
 | 40 | 15.9 | 17.8 | 20 | 23.6 | 26.9 | 30.7 | 32.5 | 37.3 | 43.1 | 42.3 | 49 | 56.9 | 53 | 61.7 | 71.8 | 64.3 | 74.9 | 87.1 | 30
200 | 0 | 13.6 | 15.2 | 17 | 19.9 | 22.6 | 25.6 | 27.1 | 31 | 35.6 | 35 | 40.3 | 46.6 | 43.5 | 50.4 | 58.6 | 52.6 | 61.2 | 71.3 | 31
 | 10 | 14 | 15.7 | 17.5 | 20.5 | 23.2 | 26.4 | 27.9 | 31.9 | 36.7 | 36 | 41.6 | 48.1 | 44.9 | 52 | 60.5 | 54.3 | 63.1 | 73.5 | 32
 | 15 | 14.3 | 15.9 | 17.8 | 20.9 | 23.6 | 26.9 | 28.4 | 32.5 | 37.3 | 36.7 | 42.3 | 49 | 45.7 | 53 | 61.6 | 55.3 | 64.2 | 74.8 | 33
 | 20 | 14.5 | 16.2 | 18.1 | 21.2 | 24.1 | 27.3 | 28.9 | 33.1 | 38 | 37.3 | 43.1 | 49.8 | 46.5 | 53.9 | 62.6 | 56.2 | 65.3 | 76 | 34
 | 30 | 14.8 | 16.6 | 18.5 | 21.7 | 24.6 | 28 | 29.6 | 33.9 | 39 | 38.3 | 44.2 | 51.2 | 47.8 | 55.4 | 64.4 | 57.8 | 67.2 | 78.2 | 35
 | 40 | 14.9 | 16.7 | 18.6 | 21.9 | 24.9 | 28.4 | 30 | 34.4 | 39.6 | 38.9 | 45 | 52.2 | 48.7 | 56.5 | 65.7 | 58.9 | 68.6 | 79.9 | 36
180 | 0 | 12.8 | 14.2 | 15.8 | 18.4 | 20.8 | 23.6 | 24.9 | 28.4 | 32.5 | 31.9 | 36.7 | 42.4 | 39.6 | 45.8 | 53.1 | 47.7 | 55.4 | 64.4 | 37
 | 10 | 13.1 | 14.6 | 16.2 | 19 | 21.4 | 24.3 | 25.6 | 29.3 | 33.5 | 32.9 | 37.9 | 43.7 | 40.8 | 47.2 | 54.8 | 49.2 | 57.1 | 66.5 | 38
 | 15 | 13.3 | 14.8 | 16.5 | 19.3 | 21.8 | 24.7 | 26.1 | 29.8 | 34.1 | 33.5 | 38.6 | 44.5 | 41.6 | 48.1 | 55.8 | 50.1 | 58.2 | 67.7 | 39
 | 20 | 13.5 | 15.1 | 16.8 | 19.6 | 22.2 | 25.2 | 26.5 | 30.3 | 34.7 | 34.1 | 39.2 | 45.3 | 42.3 | 48.9 | 56.7 | 51 | 59.2 | 68.8 | 40
 | 30 | 13.8 | 15.4 | 17.2 | 20.1 | 22.7 | 25.8 | 27.2 | 31.1 | 35.6 | 35 | 40.3 | 46.6 | 43.4 | 50.3 | 58.3 | 52.4 | 60.8 | 70.8 | 41
 | 40 | 13.9 | 15.5 | 17.3 | 20.3 | 23 | 26.1 | 27.5 | 31.5 | 36.2 | 35.5 | 41 | 47.4 | 44.2 | 51.2 | 59.5 | 53.4 | 62.1 | 72.3 | 42
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18