Spreadsheet: 739327d1625650005-how-to-condense-a-lot-of-test-results-example
Sheet: Sheet1

Pile no | R_dyn | [NAME] | R_d
 | kN | kN | kN
26 | 2622.217349271946 | 1748.14489951463 | 1344.726845780485 |  |  |  | Result
26 | 2748.428276243629 | 1832.285517495752 | 1409.450398073656
26 | 2680.635663982564 | 1787.090442655043 | 1374.684955888495
26 | 2607.235300014864 | 1738.156866676576 | 1337.043743597366
26 | 3218.867915690782 | 2145.911943793854 | 1650.701495226042
25 | 2642.895119781043 | 1761.930079854029 | 1355.330830656945
25 | 2423.353081633233 | 1615.568721088822 | 1242.745170068324
25 | 2573.659794570314 | 1715.773196380209 | 1319.825535677084
25 | 2710.061664417676 | 1806.707776278451 | 1389.775212521885
25 | 2531.235282572961 | 1687.490188381974 | 1298.069375678441
25eftet | 3733.525171479815 | 2871.942439599858 | 2209.18649199989
24 | 2625.668740829708 | 1750.445827219805 | 1346.496790169081
24 | 2751.61284667325 | 1834.408564448833 | 1411.083511114487
24 | 2798.878321681821 | 1865.918881121214 | 1435.322216247088
24 | 2893.682055502382 | 1929.121370334921 | 1483.939515642247
24 | 2731.411183686256 | 1820.940789124171 | 1400.72368394167
9 | 3316.848512838472 | 2211.232341892315 | 1700.94795530178
9 | 3301.125915571662 | 2200.750610381108 | 1692.885084908545
9 | 3334.595832673251 | 2223.063888448834 | 1710.049144960641
9 | 3426.762290059236 | 2284.508193372824 | 1757.313994902172
9 | 3218.867915690782 | 2145.911943793854 | 1650.701495226042
8 | 3374.764407915779 | 2249.842938610519 | 1730.648414315784
8 | 3463.802922532376 | 2309.201948354917 | 1776.309191042244
8 | 3513.625193075417 | 2342.416795383612 | 1801.859073372009
8 | 3588.419236859058 | 2392.279491239372 | 1840.214993261056
8 | 3643.453359061863 | 2428.968906041242 | 1868.437620031724
11 | 3356.652734371116 | 2237.768489580744 | 1721.360376600572
11 | 3442.060704253408 | 2294.707136168939 | 1765.159335514569
11 | 3456.308210683468 | 2304.205473788978 | 1772.465749068445
11 | 3593.632268932233 | 2395.754845954822 | 1842.888343042171
11 | 3585.672819216816 | 2390.448546144544 | 1838.806573957342
12 | 3395.710350963869 | 2263.806900642579 | 1741.389923571215
12 | 3401.775330064026 | 2267.850220042684 | 1744.500169263603
12 | 3456.948605798017 | 2304.632403865344 | 1772.794156819496
12 | 3559.786592849469 | 2373.191061899646 | 1825.53158607665
12 | 3527.479132876722 | 2351.652755251148 | 1808.963657885498
13 | 3365.84095752842 | 2243.893971685613 | 1726.07228591201
13 | 3395.036018971839 | 2263.357345981226 | 1741.04411229325
13 | 3517.811849425121 | 2345.207899616747 | 1804.006076628267
13 | 3471.711993219424 | 2314.474662146282 | 1780.365124727909
13 | 3602.85454949143 | 2401.903032994287 | 1847.617717687913
27 | 3077.700084397215 | 2051.80005626481 | 1578.307735588315
27 | 3091.359796093715 | 2060.906530729143 | 1585.312715945495
27 | 3085.388109822336 | 2056.925406548224 | 1582.250312729403
27 | 3121.115589006811 | 2080.74372600454 | 1600.572096926569
27 | 2941.524183190887 | 1961.016122127258 | 1508.473940097891
28 | 2932.641394915319 | 1955.094263276879 | 1503.918664059138
28 | 3151.135778673918 | 2100.757185782612 | 1615.967065986624
28 | 2942.008921292387 | 1961.339280861591 | 1508.722523739685
28 | 3057.748388222831 | 2038.498925481887 | 1568.076096524529
28 | 2932.641394915319 | 1955.094263276879 | 1503.918664059138
29 | 2986.963129407338 | 1991.308752938225 | 1531.775963798635
29 | 3130.859832524613 | 2087.239888349742 | 1605.569144884417
29 | 2870.237894441231 | 1913.491929627487 | 1471.916868944221
29 | 3063.020473080505 | 2042.013648720337 | 1570.779729784874
29 | 2838.642662310313 | 1892.428441540209 | 1455.714185800161
30 | 3064.004151520133 | 2042.669434346755 | 1571.284180266735
30 | 2876.13368780787 | 1917.42245853858 | 1474.940352721984
30 | 2926.958248433159 | 1951.305498955439 | 1501.004229965723
30 | 3135.501322829583 | 2090.334215219722 | 1607.949396322863
30 | 2726.88652698929 | 1817.924351326194 | 1398.403347173995
33 | 2708.214521358138 | 1805.476347572092 | 1388.82795967084
33 | 2829.49297483545 | 1886.3286498903 | 1451.022038377154
33 | 2548.088453258794 | 1698.725635505863 | 1306.712027312202
33 | 2687.267727288645 | 1791.51181819243 | 1378.086013994177
33 | 2595.949535067063 | 1730.633023378042 | 1331.256171829263
33efter | 3668.307465484043 | 2821.774973449264 | 2170.596133422511
32 | 1857.47652237074 | 1238.317681580493 | 952.5520627542256
32 | #[NAME]! | #[NAME]! | #[NAME]!
32 | 594.5822724528432 | 396.3881816352288 | 304.913985873253
32 | 527.1363920977666 | 351.4242613985111 | 270.3263549219316
32 | 593.0491012479433 | 395.3660674986289 | 304.1277442297145
34 | 2300.811669206443 | 1533.874446137628 | 1179.903420105868
34 | 2617.611998770537 | 1745.074665847024 | 1342.365127574634
34 | 2861.381695552833 | 1907.587797035222 | 1467.375228488632
34 | 2783.503490538532 | 1855.668993692355 | 1427.437687455658
34 | 2520.372790735468 | 1680.248527156979 | 1292.498867043829
34efter | 3801.10382291923 | 2923.926017630176 | 2249.17385971552
35 | 2488.892845244385 | 1659.26189682959 | 1276.355305253531
35 | 2562.491727963357 | 1708.327818642238 | 1314.098322032491
35 | 2829.49297483545 | 1886.3286498903 | 1451.022038377154
35 | 2968.661619398264 | 1979.107746265509 | 1522.390574050392
35 | 2391.734918728197 | 1594.489945818798 | 1226.530727552921
35Efter | 3943.876035052146 | 3033.750796193958 | 2333.654458610737
14 | 3219.627055347267 | 2146.418036898178 | 1651.090797613983
14 | 3381.444789283439 | 2254.296526188959 | 1734.074250914584
14 | 3557.222420252078 | 2371.481613501385 | 1824.216625770296
14 | 3623.107134052424 | 2415.40475603495 | 1858.003658488423
14 | 3686.042275227403 | 2457.361516818269 | 1890.278089860207
15 | 3291.812393777952 | 2194.541595851968 | 1688.10891988613
15 | 3445.578162255067 | 2297.052108170044 | 1766.963160130803
15 | 3358.220936329845 | 2238.81395755323 | 1722.164582733254
15 | 3377.595051889456 | 2251.730034592971 | 1732.100026609977
15 | 3361.606625579752 | 2241.071083719835 | 1723.900833630642
16 | 3145.17430709525 | 2096.782871396833 | 1612.909901074487
16 | 3320.64719998985 | 2213.764799993234 | 1702.895999994795
16 | 3436.756344113608 | 2291.170896075739 | 1762.439150827491
16 | 3437.386987624197 | 2291.591325082798 | 1762.762557755998
16 | 3337.38096086562 | 2224.92064057708 | 1711.477415828523
17 | 3145.713449615084 | 2097.142299743389 | 1613.186384417992
17 | 3261.206923450793 | 2174.137948967195 | 1672.413806897842
17 | 3379.501684782893 | 2253.001123188595 | 1733.07778706815
17 | 3366.633057884959 | 2244.422038589973 | 1726.478491223056
17 | 3432.970819312822 | 2288.647212875214 | 1760.497856057857
18 | 3227.635873470336 | 2151.757248980224 | 1655.197883830942
18 | 3366.533123235916 | 2244.355415490611 | 1726.427242685085
18 | 3478.210435411744 | 2318.806956941162 | 1783.697659185509
18 | 3562.64509510939 | 2375.096730072927 | 1826.997484671482
18 | 3548.909407154827 | 2365.939604769885 | 1819.95354213068
19 | 3266.474789692569 | 2177.649859795046 | 1675.11527676542
19 | 3262.712578959745 | 2175.141719306497 | 1673.185937928074
19 | 3393.012487538947 | 2262.008325025965 | 1740.006403866127
19 | 3520.036671653326 | 2346.691114435551 | 1805.14701110427
19 | 3621.275470830116 | 2414.183647220077 | 1857.064344015444
20 | 3354.059759360573 | 2236.039839573715 | 1720.030645825935
20 | 3361.775988266554 | 2241.183992177702 | 1723.98768629054
20 | 3405.459387013598 | 2270.306258009065 | 1746.389429237742
20 | 3436.125621428444 | 2290.750414285629 | 1762.115703296638
20 | 3545.402294142207 | 2363.601529428138 | 1818.155022637029
36 | 2997.00155017907 | 1998.001033452714 | 1536.923871886703
36 | 3047.188179133078 | 2031.458786088719 | 1562.66060468363
36 | 3047.188179133078 | 2031.458786088719 | 1562.66060468363
36 | 3037.489103337332 | 2024.992735558222 | 1557.68671966017
36 | 3098.529431145822 | 2065.686287430548 | 1588.989451869653
1 | 3190.075380814324 | 2126.716920542883 | 1635.936092725295
1 | 3272.488610851648 | 2181.659073901099 | 1678.19928761623
1 | 3332.52279976604 | 2221.681866510693 | 1708.986051162072
1 | 3185.283231570086 | 2123.522154380058 | 1633.478580292352
1 | 3007.930545856714 | 2005.287030571142 | 1542.528485054725
2 | 1438.966993400043 | 959.311328933362 | 737.9317914872015
2 | 1599.277493267916 | 1066.184995511944 | 820.1423042399572
2 | 1259.548374328549 | 839.698916219033 | 645.92224324541
2 | 1443.133833898417 | 962.0892225989445 | 740.0686327684189
2 | 1067.358437307671 | 711.5722915384472 | 547.3633011834208
3 | 3015.203856999101 | 2010.135904666067 | 1546.258388204667
3 | 2973.19073754734 | 1982.127158364893 | 1524.713198742226
3 | 2916.245041558989 | 1944.163361039326 | 1495.510277722558
3 | 3183.684859949933 | 2122.456573299955 | 1632.658902538427
3 | 3315.421189036108 | 2210.280792690739 | 1700.215994377491
4 | 3246.881129318735 | 2164.587419545824 | 1665.06724580448
4 | 3405.250413514296 | 2270.166942342864 | 1746.282263340664
4 | 3122.589326933664 | 2081.726217955776 | 1601.327859965982
4 | 3305.41871414273 | 2203.612476095153 | 1695.086520073195
4 | 3533.986442292968 | 2355.990961528646 | 1812.30073963742
22 | 2760.09561940454 | 1840.063746269693 | 1415.433650976687
22 | 2863.351040357212 | 1908.900693571474 | 1468.385148901134
22 | 2861.381695552833 | 1907.587797035222 | 1467.375228488632
22 | 2847.575375401019 | 1898.383583600679 | 1460.295064308215
22 | 2914.623425439199 | 1943.082283626133 | 1494.67867971241
23 | 2495.152685217582 | 1663.435123478388 | 1279.56547959876
23 | 2840.673769196495 | 1893.782512797663 | 1456.755779075125
23 | 2566.086489440077 | 1710.724326293385 | 1315.94178945645
23 | 2828.475360003556 | 1885.650240002371 | 1450.500184617208
23 | 2828.475360003556 | 1885.650240002371 | 1450.500184617208
7 | 3065.718134325819 | 2043.812089550546 | 1572.163145808112
7 | 3158.04325668953 | 2105.362171126354 | 1619.509362404887
7 | 3321.345544688149 | 2214.230363125433 | 1703.254125481102
7 | 3478.800902378194 | 2319.200601585463 | 1784.000462758048
7 | 3434.863938412028 | 2289.909292274685 | 1761.468686365143
6 | 3080.264030279797 | 2053.509353519865 | 1579.622579630665
6 | 3268.332887973413 | 2178.888591982276 | 1676.068147678674
6 | 3253.595539926941 | 2169.063693284627 | 1668.510533295867
6 | 3355.52785027563 | 2237.01856685042 | 1720.783512961862
6 | 3486.885175446295 | 2324.590116964197 | 1788.146243818613
32 A | 2347.71259462009 | 1565.141729746727 | 1203.955176728251
32 A | 2367.262215023311 | 1578.174810015541 | 1213.980623088878
32 A | 2387.747879450844 | 1591.831919633896 | 1224.486092026074
32 A | 2258.405373310623 | 1505.603582207082 | 1158.156601697755
32 A | 2226.102795533322 | 1484.068530355548 | 1141.591177196576
32 B | 1805.29746270804 | 1203.53164180536 | 925.7935706195077
32 B | 1887.64620813124 | 1258.430805420827 | 968.023696477559
32 B | 2056.688196265409 | 1371.125464176939 | 1054.711895520723
32 B | 2355.125715284138 | 1570.083810189425 | 1207.756777068789
32 B | 2234.49707556565 | 1489.664717043766 | 1145.895936187512
2 A | 1779.960130434346 | 1186.640086956231 | 912.8000668894081
2 A | 1912.3726824362 | 1274.915121624133 | 980.7039397108717
2 A | 2069.266871773725 | 1379.51124784915 | 1061.1624983455
2 A | 2188.520705482774 | 1459.013803655183 | 1122.318310503987
2 A | 2281.428922466975 | 1520.952614977983 | 1169.963549983064
2 B | 2373.750436384024 | 1582.500290922683 | 1217.307916094371
2 B | 2369.230769230769 | 1579.487179487179 | 1214.990138067061
2 B | 2531.35537341357 | 1687.57024894238 | 1298.130960724908
2 B | 2329.083220298214 | 1552.722146865476 | 1194.401651434982
2 B | 2491.876722193434 | 1661.251148128956 | 1277.885498560736