Copyright © 2008 – 2019 DARE!! International
Page 29
5.1.4
Combine the text strings of the frequencies to one text string
This can be done by applying the following formula:
“=CONCAT(AI14:AI106)”
-
“AI14” must be the cell which is the top of the list with text strings per frequency.
-
“AI106” must be the last cell of the list with text strings per frequency.
The result will be one cell with a long string. This string contains the correction factors (X, Y and Z)
for all frequencies. In this format, the string can be send to the RadiSense 10 probe.
As an example, the complete string will look like the following:
“9000,1.05,1.08,1.09;10000,1.04,1.07,1.08;20000,1.00,1.02,1.02;30000,0.99,1.01,1.00;40000,0.99,1.01,1.00;50
000,0.98,1.00,0.99;60000,0.98,1.00,0.99;70000,0.98,1.00,0.98;80000,0.98,1.00,0.98;90000,0.98,1.00,0.98;1000
00,0.98,0.99,0.98;200000,0.97,0.99,0.97;300000,0.97,0.99,0.97;400000,0.97,0.98,0.97;500000,0.97,0.99,0.97;6
00000,0.97,0.98,0.97;700000,0.97,0.98,0.96;800000,0.98,0.98,0.96;900000,0.98,0.98,0.96;1000000,0.98,0.98,0
.97;2000000,0.99,0.99,0.97;3000000,1.00,1.00,0.98;4000000,1.00,1.01,1.00;5000000,1.00,1.00,1.00;6000000,1
.01,1.00,1.00;7000000,1.01,1.00,1.01;8000000,1.00,1.00,1.00;9000000,1.00,1.00,1.00;10000000,1.00,1.00,1.00
;20000000,0.98,0.99,0.99;30000000,0.99,1.00,1.00;40000000,1.00,1.01,1.01;50000000,1.00,1.01,1.01;6000000
0,1.00,1.00,1.01;70000000,1.00,1.00,1.00;80000000,1.00,0.99,1.00;90000000,0.99,0.99,0.98;100000000,0.98,0
.97,0.96;150000000,0.95,0.97,0.96;200000000,0.95,0.96,0.96;250000000,0.94,0.95,0.95;300000000,0.93,0.93,
0.93;350000000,0.91,0.92,0.92;400000000,0.93,0.94,0.94;450000000,0.91,0.92,0.92;500000000,0.89,0.90,0.90
;550000000,0.87,0.88,0.88;600000000,0.90,0.91,0.91;650000000,0.91,0.92,0.92;700000000,0.88,0.89,0.90;750
000000,0.90,0.90,0.91;800000000,0.86,0.87,0.87;850000000,0.85,0.86,0.85;900000000,0.85,0.87,0.87;950000
000,0.87,0.89,0.89;1000000000,0.86,0.87,0.87;1200000000,0.88,0.88,0.89;1400000000,0.85,0.85,0.85;160000
0000,0.80,0.80,0.80;1800000000,0.78,0.78,0.78;2000000000,0.79,0.80,0.79;2200000000,0.74,0.73,0.73;24000
00000,0.73,0.73,0.73;2600000000,0.69,0.69,0.69;2800000000,0.70,0.70,0.70;3000000000,0.70,0.69,0.70;3200
000000,0.73,0.73,0.74;3400000000,0.76,0.75,0.76;3600000000,0.76,0.76,0.77;3800000000,0.82,0.81,0.82;400
0000000,0.85,0.85,0.85;4200000000,0.89,0.89,0.90;4400000000,0.92,0.92,0.94;4600000000,0.98,0.98,0.99;48
00000000,1.02,1.02,1.04;5000000000,1.04,1.04,1.05;5200000000,1.09,1.09,1.11;5400000000,1.07,1.07,1.09;5
600000000,1.08,1.07,1.09;5800000000,1.12,1.12,1.14;6000000000,1.12,1.11,1.15;6500000000,1.16,1.15,1.19;
7000000000,1.13,1.12,1.17;7500000000,1.08,1.06,1.11;8000000000,1.06,1.05,1.10;8500000000,1.08,1.06,1.11
;9000000000,1.07,1.05,1.09;9500000000,1.13,1.13,1.11;10000000000,1.09,1.18,1.10;10500000000,1.06,1.09,1
.17;11000000000,1.07,1.07,1.19;11500000000,1.04,1.09,1.17;12000000000,1.06,1.24,1.18;”
5.1.5
Upload the user correction data
Download and install the program “Putty”. It can be download from the following website:
https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html
Choose the 32- or 64-bit installer for Windows. Check your Windows to see of you need a 32- or
64-bit variant. Note: Normally, the 32-bit installer will work on a 64-bit Windows as well, so this would be
the safe option if you don’t know if you have a 32 bit or 64 bit version.
