Spreadsheet: 681362d1591526050-formula-required-to-work-out-differences-between-two-ticks-tick-difference
Sheet: Sheet1

Table A | [NAME] |  | [NAME] | [NAME] | Difference
1.01000001642283 | 0 |  | 1.71 | 1.8
1.02000001625525 | 1 |  | 3.7 | 3.4 | ?
1.03000001608767 | 2 |  | 4.6 | 5.5 | ?
1.04000001592009 | 3 |  | 4.6 | 5.6 | ?
1.05000001575251 | 4 |  | 4.3 | 4.2 | ?
1.06000001558493 | 5 |  | 3.7 | 3.25 | ?
1.07000001541736 | 6 |  | 6.6 | 6.8 | ?
1.08000001524977 | 7 |  | 3.9 | 3.85 | ?
1.09000001508219 | 8 |  | 2.48 | 2.02 | ?
1.10000001491461 | 9 |  | 1.96 | 1.59 | ?
1.11000001474704 | 10 |  | 7.4 | 7.4 | ?
1.12000001457946 | 11 |  | 3.8 | 3.8 | ?
1.13000001441188 | 12 |  | 5.4 | 5.2 | ?
1.14000001424429 | 13
1.15000001407672 | 14
1.16000001390913 | 15
1.17000001374155 | 16
1.18000001357397 | 17
1.1900000134064 | 18
1.20000001323882 | 19
1.21000001307123 | 20
1.22000001290366 | 21
1.23000001273608 | 22
1.2400000125685 | 23
1.25000001240092 | 24
1.26000001223334 | 25
1.27000001206576 | 26
1.28000001189818 | 27
1.2900000117306 | 28
1.30000001156302 | 29
1.31000001139544 | 30
1.32000001122786 | 31
1.33000001106028 | 32
1.3400000108927 | 33
1.35000001072512 | 34
1.36000001055754 | 35
1.37000001038996 | 36
1.38000001022238 | 37
1.3900000100548 | 38
1.40000000988722 | 39
1.41000000971964 | 40
1.42000000955206 | 41
1.43000000938448 | 42
1.4400000092169 | 43
1.45000000904932 | 44
1.46000000888174 | 45
1.47000000871416 | 46
1.48000000854658 | 47
1.490000008379 | 48
1.50000000821142 | 49
1.51000000804384 | 50
1.52000000787626 | 51
1.53000000770868 | 52
1.5400000075411 | 53
1.55000000737352 | 54
1.56000000720594 | 55
1.57000000703836 | 56
1.58000000687078 | 57
1.5900000067032 | 58
1.60000000653562 | 59
1.61000000636804 | 60
1.62000000620046 | 61
1.63000000603288 | 62
1.6400000058653 | 63
1.65000000569772 | 64
1.66000000553014 | 65
1.67000000536256 | 66
1.68000000519498 | 67
1.6900000050274 | 68
1.70000000485982 | 69
1.71000000469224 | 70
1.72000000452466 | 71
1.73000000435708 | 72
1.7400000041895 | 73
1.75000000402192 | 74
1.76000000385434 | 75
1.77000000368676 | 76
1.78000000351918 | 77
1.7900000033516 | 78
1.80000000318402 | 79
1.81000000301644 | 80
1.82000000284886 | 81
1.83000000268128 | 82
1.8400000025137 | 83
1.85000000234612 | 84
1.86000000217854 | 85
1.87000000201096 | 86
1.88000000184338 | 87
1.8900000016758 | 88
1.90000000150822 | 89
1.91000000134064 | 90
1.92000000117306 | 91
1.93000000100548 | 92
1.9400000008379 | 93
1.95000000067032 | 94
1.96000000050274 | 95
1.97000000033516 | 96
1.98000000016758 | 97
1.99 | 98
1.99999999983242 | 99
2.01999999983584 | 100
2.03999999983926 | 101
2.05999999984268 | 102
2.0799999998461 | 103
2.09999999984952 | 104
2.11999999985294 | 105
2.13999999985636 | 106
2.15999999985978 | 107
2.1799999998632 | 108
2.19999999986662 | 109
2.21999999987004 | 110
2.23999999987346 | 111
2.25999999987688 | 112
2.2799999998803 | 113
2.29999999988372 | 114
2.31999999988714 | 115
2.33999999989056 | 116
2.35999999989398 | 117
2.3799999998974 | 118
2.39999999990082 | 119
2.41999999990424 | 120
2.43999999990766 | 121
2.45999999991108 | 122
2.4799999999145 | 123
2.49999999991792 | 124
2.51999999992134 | 125
2.53999999992476 | 126
2.55999999992818 | 127
2.5799999999316 | 128
2.59999999993502 | 129
2.61999999993844 | 130
2.63999999994186 | 131
2.65999999994528 | 132
2.6799999999487 | 133
2.69999999995212 | 134
2.71999999995554 | 135
2.73999999995896 | 136
2.75999999996238 | 137
2.7799999999658 | 138
2.79999999996922 | 139
2.81999999997264 | 140
2.83999999997606 | 141
2.85999999997948 | 142
2.8799999999829 | 143
2.89999999998632 | 144
2.91999999998974 | 145
2.93999999999316 | 146
2.95999999999658 | 147
2.98 | 148
3.00000000000342 | 149
3.05000000000324 | 150
3.10000000000306 | 151
3.15000000000288 | 152
3.2000000000027 | 153
3.25000000000252 | 154
3.30000000000234 | 155
3.35000000000216 | 156
3.40000000000198 | 157
3.4500000000018 | 158
3.50000000000162 | 159
3.55000000000144 | 160
3.60000000000126 | 161
3.65000000000108 | 162
3.7000000000009 | 163
3.75000000000072 | 164
3.80000000000054 | 165
3.85000000000036 | 166
3.90000000000018 | 167
3.95 | 168
3.99999999999982 | 169
4.09999999999983 | 170
4.19999999999984 | 171
4.29999999999985 | 172
4.39999999999986 | 173
4.49999999999987 | 174
4.59999999999988 | 175
4.69999999999989 | 176
4.7999999999999 | 177
4.89999999999991 | 178
4.99999999999992 | 179
5.09999999999993 | 180
5.19999999999993 | 181
5.29999999999994 | 182
5.39999999999995 | 183
5.49999999999996 | 184
5.59999999999997 | 185
5.69999999999998 | 186
5.79999999999999 | 187
5.9 | 188
6.00000000000001 | 189
6.20000000000001 | 190
6.40000000000001 | 191
6.60000000000001 | 192
6.80000000000001 | 193
7.00000000000001 | 194
7.20000000000001 | 195
7.40000000000001 | 196
7.60000000000001 | 197
7.80000000000001 | 198
8.00000000000001 | 199
8.20000000000001 | 200
8.40000000000001 | 201
8.6 | 202
8.8 | 203
9 | 204
9.2 | 205
9.4 | 206
9.6 | 207
9.8 | 208
10 | 209
10.5 | 210
11 | 211
11.5 | 212
12 | 213
12.5 | 214
13 | 215
13.5 | 216
14 | 217
14.5 | 218
15 | 219
15.5 | 220
16 | 221
16.5 | 222
17 | 223
17.5 | 224
18 | 225
18.5 | 226
19 | 227
19.5 | 228
20 | 229
21 | 230
22 | 231
23 | 232
24 | 233
25 | 234
26 | 235
27 | 236
28 | 237
29 | 238
30 | 239
32 | 240
34 | 241
36 | 242
38 | 243
40 | 244
42 | 245
44 | 246
46 | 247
48 | 248
50 | 249
55 | 250
60 | 251
65 | 252
70 | 253
75 | 254
80 | 255
85 | 256
90 | 257
95 | 258
100 | 259
110 | 260
120 | 261
130 | 262
140 | 263
150 | 264
160 | 265
170 | 266
180 | 267
190 | 268
200 | 269
210 | 270
220 | 271
230 | 272
240 | 273
250 | 274
260 | 275
270 | 276
280 | 277
290 | 278
300 | 279
310 | 280
320 | 281
330 | 282
340 | 283
350 | 284
360 | 285
370 | 286
380 | 287
390 | 288
400 | 289
410 | 290
420 | 291
430 | 292
440 | 293
450 | 294
460 | 295
470 | 296
480 | 297
490 | 298
500 | 299
510 | 300
520 | 301
530 | 302
540 | 303
550 | 304
560 | 305
570 | 306
580 | 307
590 | 308
600 | 309
610 | 310
620 | 311
630 | 312
640 | 313
650 | 314
660 | 315
670 | 316
680 | 317
690 | 318
700 | 319
710 | 320
720 | 321
730 | 322
740 | 323
750 | 324
760 | 325
770 | 326
780 | 327
790 | 328
800 | 329
810 | 330
820 | 331
830 | 332
840 | 333
850 | 334
860 | 335
870 | 336
880 | 337
890 | 338
900 | 339
910 | 340
920 | 341
930 | 342
940 | 343
950 | 344
960 | 345
970 | 346
980 | 347
990 | 348
1000 | 349