Spreadsheet: 82901d1282906495-vlookup-incorrect-answer-lv-rates11
Sheet: SERRATES

PRINCIPLE - COMPREHENSIVE - 01 August 2010
 | [NAME]
Age | V | A | B | C | D | E | F | G | H | I | J | K | L | M | N
25 | 1430.990626522191 | 1497.955201547868 | 1618.624576634724 | 1943.631731408987 | 1979.108712164822 | 2088.073724486318 | 2234.173632896469 | 2280.998686168075 | 2564.692930428595 | 2542.179078161012 | 2733.386067049668 | 2850.195293223283 | 3227.595296640023 | 3940.712068396695 | 4126.518320482787
26 | 1208.392084618739 | 1233.896486084109 | 1332.261990183782 | 1581.259713688667 | 1630.674079741438 | 1701.780085456348 | 1830.836092090381 | 1861.093585404265 | 1875.690917298326 | 2072.48919365429 | 2228.378848200512 | 2324.75586752882 | 2631.619460827035 | 3212.846058649541 | 3365.439521573039
27 | 1187.599913122263 | 1211.992998165456 | 1259.749575588908 | 1555.919013148785 | 1600.265239093579 | 1671.764025666858 | 1764.931265161281 | 1827.97804117999 | 1839.568481658486 | 2043.220684530725 | 2186.984813868613 | 2292.699881345868 | 2583.533390944814 | 3040.830849314766 | 3185.779656402893
28 | 1175.369224006689 | 1199.824393766205 | 1248.68835980325 | 1531.845347635897 | 1586.327853796644 | 1654.798426655407 | 1747.796010159716 | 1809.433336414396 | 1814.148989911933 | 2018.133390996242 | 2169.047398991458 | 2242.525294276902 | 2583.533390944814 | 2868.815639979989 | 3004.705146625109
29 | 1131.338743190621 | 1154.800557488974 | 1248.68835980325 | 1506.504647096014 | 1526.77720752792 | 1593.461260998621 | 1716.161693233748 | 1740.553004427904 | 1753.944930512201 | 1941.477771863097 | 2086.259330327662 | 2178.413321910999 | 2462.589639422863 | 2639.935898633716 | 2764.215563326489
30 | 948.5134614687772 | 993.004921303541 | 1074.734197020241 | 1278.706368877397 | 1313.330537595833 | 1384.704082629905 | 1465.621958861741 | 1514.068155429418 | 1524.166103803223 | 1685.003079735454 | 1813.775138946725 | 1891.195974138 | 2140.642753130995 | 2208.995697625439 | 2314.140940465361
31 | 928.9208383278667 | 972.3650961494254 | 1049.255584590882 | 1246.470073863682 | 1285.869989991556 | 1355.189963639569 | 1432.086541158972 | 1480.366720807329 | 1490.127654834912 | 1649.543155220366 | 1786.470997070107 | 1851.796058010124 | 2093.957792511076 | 2179.524560361789 | 2283.481239065186
32 | 904.7181862126249 | 947.1386431832848 | 1002.93083471932 | 1214.233778849965 | 1252.43975812548 | 1321.986579775442 | 1409.729596023794 | 1445.417084902941 | 1457.349889161725 | 1608.829908554895 | 1774.769221980129 | 1805.82948919427 | 2044.526657737044 | 2146.034631653095 | 2247.489415682373
33 | 885.1255630717143 | 926.4988180291696 | 1000.614597225741 | 1181.99748383625 | 1224.979210521205 | 1292.472460785106 | 1376.194178321025 | 1411.715650280851 | 1422.050756898292 | 1572.056653502212 | 1692.856796350277 | 1766.429573066396 | 1996.468610040068 | 2101.82792575762 | 2200.833348334281
34 | 864.380432687221 | 905.8589928750545 | 977.4522222899603 | 1170.058115312651 | 1196.324726064568 | 1261.728586836841 | 1341.416708110747 | 1380.51061822336 | 1391.794357815349 | 1535.283398449529 | 1653.85087938368 | 1724.402995863329 | 1985.483913423617 | 2076.375579939012 | 2175.505768916746
35 | 852.8553602513911 | 893.2457663919841 | 962.396678581703 | 1154.536936231973 | 1181.99748383625 | 1245.741772383742 | 1325.270025513116 | 1361.787598988867 | 1371.623425093388 | 1518.210101460783 | 1633.047723668162 | 1700.763046186604 | 1963.514520190713 | 2032.168874043536 | 2128.849701568654
36 | 842.4827950591446 | 882.9258538149264 | 951.9736098606012 | 1133.046072889496 | 1166.476304755572 | 1229.754957930644 | 1296.702817840388 | 1343.064579754373 | 1355.234542256794 | 1497.19681285925 | 1609.644173488205 | 1678.436427047474 | 1929.187343264303 | 2002.697736779886 | 2098.190000168478
37 | 833.262737110481 | 872.6059412378688 | 941.5505411394997 | 1116.330956956458 | 1153.342999379613 | 1217.457408351337 | 1290.492555302838 | 1328.086164366778 | 1340.106342715323 | 1481.4368464081 | 1591.441412237127 | 1660.049799521133 | 1907.2179500314 | 1963.849419477801 | 2056.866054803025
38 | 820.5851574310686 | 859.9927147547985 | 929.9693536716092 | 1094.840093613981 | 1135.433946594215 | 1199.011083982377 | 1274.345872705209 | 1309.363145132284 | 1319.935409993361 | 1459.110227268971 | 1568.037862057169 | 1660.049799521133 | 1879.756208490271 | 1925.001102175716 | 2015.542109437573
39 | 805.6025632644901 | 842.7928604597025 | 912.5975724697736 | 1084.094661942742 | 1116.330956956458 | 1174.415984823765 | 1263.167400137619 | 1309.363145132284 | 1299.764477271399 | 1434.156947054649 | 1552.43549527053 | 1631.156527694024 | 1850.921379872086 | 1904.9071449505 | 1995.546652002676
40 | 803.2269871093494 | 841.2717849097961 | 909.9504439056839 | 1084.289590408433 | 1112.310557351573 | 1173.286618025665 | 1259.796114760092 | 1281.316826523878 | 1292.843583263482 | 1428.581992935875 | 1535.02877314122 | 1652.384237607818 | 1866.277537386921 | 1923.278762984984 | 2015.868565885489
41 | 776.1783477191372 | 813.1903901422924 | 880.406598324331 | 1039.212382717296 | 1076.979772945006 | 1135.641058089013 | 1211.634895081135 | 1245.653932743889 | 1249.105591391882 | 1380.337197677253 | 1484.612962095959 | 1606.819708752453 | 1821.442040993241 | 1864.500520761561 | 1953.297746701459
42 | 776.1783477191372 | 813.1903901422924 | 880.406598324331 | 1029.465959432726 | 1067.233349660436 | 1135.641058089013 | 1205.297892491798 | 1245.653932743889 | 1249.105591391882 | 1369.616132064226 | 1483.286230226347 | 1596.098643139426 | 1815.837603944031 | 1845.363418642308 | 1932.894218706668
43 | 763.2420419238183 | 799.1496927585405 | 863.862044798773 | 1023.37444487987 | 1057.486926375865 | 1115.563426122798 | 1188.821685759523 | 1234.19085974318 | 1243.95994528934 | 1358.895066451198 | 1459.405056573328 | 1584.037444324769 | 1771.002107550351 | 1824.859380657394 | 1912.490690711875
44 | 763.2420419238183 | 799.1496927585405 | 863.862044798773 | 1023.37444487987 | 1055.050320554723 | 1113.053722127021 | 1183.752083688054 | 1234.19085974318 | 1241.38712223807 | 1356.214800047941 | 1458.078324703717 | 1573.316378711743 | 1726.166611156671 | 1805.722278538141 | 1890.72692751743
45 | 763.2420419238183 | 799.1496927585405 | 863.862044798773 | 1022.156141969298 | 1052.613714733581 | 1113.053722127021 | 1172.345479027249 | 1231.643510187466 | 1227.236595456081 | 1353.534533644685 | 1455.424860964492 | 1562.595313098716 | 1692.539988861412 | 1786.585176418887 | 1870.323399522637
46 | 757.3619029259459 | 792.1293440666648 | 856.7715218592483 | 1018.501233237585 | 1050.177108912438 | 1109.289166133356 | 1166.008476437912 | 1209.991038963901 | 1219.51812630227 | 1350.854267241429 | 1450.117933486044 | 1550.53411428406 | 1664.517803615362 | 1766.081138433972 | 1849.919871527845
47 | 755.0098473267973 | 790.9592859513522 | 856.7715218592483 | 1012.409718684729 | 1048.958806001867 | 1106.779462137579 | 1160.938874366443 | 1206.170014630331 | 1219.51812630227 | 1349.5141340398 | 1448.791201616432 | 1539.813048671033 | 1647.704492467732 | 1756.512587374346 | 1840.398225130275
48 | 752.6577917276484 | 788.6191697207269 | 856.7715218592483 | 1012.409718684729 | 1045.303897270153 | 1104.269758141802 | 1160.938874366443 | 1202.348990296761 | 1219.51812630227 | 1346.833867636543 | 1446.137737877207 | 1527.751849856377 | 1642.100055418522 | 1746.944036314719 | 1829.516343533052
49 | 751.4817639280736 | 786.2790534901018 | 856.7715218592483 | 1009.973112863586 | 1044.085594359581 | 1101.760054146025 | 1160.938874366443 | 1199.801640741047 | 1219.51812630227 | 1344.153601233286 | 1443.484274137984 | 1522.391317049864 | 1636.495618369312 | 1737.375485255092 | 1819.994697135482
50 | 708.4519651666642 | 741.3710529662867 | 810.248828222291 | 952.8272747100383 | 985.0874484608016 | 1040.747769671493 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1269.898696717538 | 1363.848387723198 | 1434.656012658936 | 1542.333790174421 | 1633.987017668651 | 1710.877989654532
51 | 706.2276261865493 | 740.2645290066354 | 810.248828222291 | 952.8272747100383 | 982.7831503357471 | 1038.374342602687 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1267.363968779979 | 1361.339007065014 | 1432.121284721376 | 1531.733557939545 | 1623.645327683406 | 1700.586994228039
52 | 704.0032872064338 | 738.0514810873332 | 810.248828222291 | 952.8272747100383 | 981.6310012732195 | 1036.000915533881 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1264.829240842419 | 1358.82962640683 | 1429.586556783816 | 1529.083499880826 | 1623.645327683406 | 1700.586994228039
53 | 704.0032872064338 | 738.0514810873332 | 810.248828222291 | 952.8272747100383 | 979.3267031481652 | 1033.627488465075 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1263.561876873639 | 1356.320245748645 | 1429.586556783816 | 1526.433441822106 | 1623.645327683406 | 1700.586994228039
54 | 704.0032872064338 | 738.0514810873332 | 810.248828222291 | 952.8272747100383 | 977.0224050231105 | 1031.254061396269 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1261.027148936079 | 1355.065555419553 | 1428.319192815036 | 1525.108412792747 | 1623.645327683406 | 1700.586994228039
55 | 704.0032872064338 | 738.0514810873332 | 810.248828222291 | 952.8272747100383 | 977.0224050231105 | 1030.067347861866 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1261.027148936079 | 1355.065555419553 | 1427.051828846257 | 1521.133325704669 | 1623.645327683406 | 1700.586994228039
56 | 704.0032872064338 | 738.0514810873332 | 810.248828222291 | 952.8272747100383 | 977.0224050231105 | 1027.69392079306 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1261.027148936079 | 1355.065555419553 | 1425.784464877476 | 1519.808296675309 | 1623.645327683406 | 1700.586994228039
57 | 704.0032872064338 | 738.0514810873332 | 810.248828222291 | 952.8272747100383 | 977.0224050231105 | 1025.320493724253 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1261.027148936079 | 1355.065555419553 | 1424.517100908696 | 1515.833209587231 | 1623.645327683406 | 1700.586994228039
58 | 704.0032872064338 | 738.0514810873332 | 810.248828222291 | 952.8272747100383 | 977.0224050231105 | 1025.320493724253 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1261.027148936079 | 1355.065555419553 | 1423.249736939916 | 1515.833209587231 | 1623.645327683406 | 1700.586994228039
59 | 704.0032872064338 | 738.0514810873332 | 810.248828222291 | 952.8272747100383 | 977.0224050231105 | 1025.320493724253 | 1097.899893488345 | 1134.652411648808 | 1153.298292044056 | 1261.027148936079 | 1355.065555419553 | 1421.982372971136 | 1515.833209587231 | 1623.645327683406 | 1700.586994228039
60 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1451.002421399119 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
61 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1449.709192859547 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
62 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1448.415964319976 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
63 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1447.122735780405 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
64 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1445.829507240834 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
65 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1441.949821622119 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
66 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1441.949821622119 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
67 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1441.949821622119 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
68 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1441.949821622119 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
69 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1441.949821622119 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101
70 | 718.3707012310554 | 753.1137562115644 | 826.7845185941746 | 972.2727292959577 | 996.9616377786845 | 1046.245401759442 | 1120.306013763618 | 1157.80858331511 | 1176.83499188169 | 1286.76239687355 | 1382.719954509748 | 1441.949821622119 | 1546.768581211461 | 1656.78094661572 | 1735.292851253101