Spreadsheet: 84429d1284482992-excel-2007-vlookup-for-additional-factor-in-the-table-andy9988
Sheet: UNITED

AGE | SUM INSURED
0 - 35 Yrs | 100000 | 150000 | 200000 | 250000 | 300000 | 350000 | 400000 | 450000 | 500000 | 600000 | 700000 | 800000 | 900000 | 1000000
1A + 1A | 1638 | 2400 | 3086 | 3695 | 4305 | 4838 | 5371 | 5904 | 6439 | 7634 | 8466 | 9131 | 9741 | 10303
2A + 1C | 1834 | 2688 | 3457 | 4138 | 4822 | 5418 | 6016 | 6612 | 7211 | 8550 | 9482 | 10227 | 10910 | 11539
2A + 2C | 2031 | 2976 | 3827 | 4582 | 5338 | 5999 | 6660 | 7321 | 7984 | 9466 | 10498 | 11393 | 12079 | 12775
1A + 1C | 1507 | 2208 | 2839 | 3399 | 3961 | 4451 | 4942 | 5431 | 5924 | 7023 | 7789 | 8401 | 8962 | 9478
1A + 2C | 1703 | 2496 | 3210 | 3843 | 4477 | 5031 | 5586 | 6140 | 6696 | 7939 | 8805 | 9497 | 10131 | 10715
Per Addi.Chd | 197 | 282 | 370 | 443 | 517 | 581 | 645 | 708 | 773 | 916 | 1016 | 1096 | 1169 | 1236
AGE | SUM INSURED
36 - 45 Yrs | 100000 | 150000 | 200000 | 250000 | 300000 | 350000 | 400000 | 450000 | 500000 | 600000 | 700000 | 800000 | 900000 | 1000000
1A + 1A | 1960 | 2870 | 3689 | 4418 | 5146 | 5785 | 6421 | 7061 | 7698 | 9126 | 10124 | 10916 | 11658 | 12316
2A + 1C | 2195 | 3214 | 4131 | 4948 | 5764 | 6479 | 7192 | 7909 | 8621 | 10221 | 11339 | 12226 | 13049 | 13794
2A + 2C | 2430 | 3559 | 4574 | 5478 | 6381 | 7173 | 7962 | 8756 | 9545 | 11317 | 12553 | 13536 | 14448 | 15272
1A + 1C | 1803 | 2640 | 3394 | 4064 | 4735 | 5322 | 5908 | 6496 | 7082 | 8396 | 9314 | 10043 | 10719 | 11331
1A + 2C | 2038 | 2985 | 3836 | 4594 | 5352 | 6016 | 6678 | 7344 | 8005 | 9491 | 10529 | 11353 | 12117 | 12509
Per Addi.Chd | 235 | 344 | 443 | 530 | 618 | 694 | 771 | 847 | 924 | 1095 | 1215 | 1310 | 1398 | 1478
AGE | SUM INSURED
46 - 50 Yrs | 100000 | 150000 | 200000 | 250000 | 300000 | 350000 | 400000 | 450000 | 500000 | 600000 | 700000 | 800000 | 900000 | 1000000
1A + 1A | 3049 | 4492 | 5831 | 7067 | 8302 | 9435 | 10568 | 11701 | 12835 | 15218 | 16513 | 17965 | 19308 | 20536
2A + 1C | 3400 | 5010 | 6503 | 7882 | 9260 | 10524 | 11787 | 13051 | 14316 | 16974 | 18418 | 20038 | 21535 | 22906
2A + 2C | 3752 | 5528 | 7176 | 8698 | 10218 | 11613 | 13006 | 14402 | 15797 | 18730 | 20323 | 22110 | 23763 | 25275
1A + 1C | 2697 | 3973 | 5158 | 6251 | 7344 | 8347 | 9348 | 10351 | 11354 | 13462 | 14607 | 15892 | 17080 | 18167
1A + 2C | 3049 | 4492 | 5831 | 7067 | 8302 | 9435 | 10568 | 11701 | 12835 | 15218 | 16513 | 17965 | 19308 | 20536
Per Addi.Chd | 352 | 518 | 673 | 815 | 958 | 1089 | 1219 | 1350 | 1481 | 1756 | 1905 | 2073 | 2228 | 2370
AGE | SUM INSURED
51 - 55 Yrs | 100000 | 150000 | 200000 | 250000 | 300000 | 350000 | 400000 | 450000 | 500000 | 600000 | 700000 | 800000 | 900000 | 1000000
1A + 1A | 3854 | 5681 | 7385 | 8968 | 10552 | 12012 | 13474 | 14935 | 16395 | 19440 | 21021 | 22905 | 24643 | 26233
2A + 1C | 4267 | 6290 | 8176 | 9929 | 11682 | 13299 | 14917 | 16535 | 18152 | 21523 | 23273 | 25360 | 27283 | 29044
2A + 2C | 4680 | 6899 | 8968 | 10890 | 12813 | 14586 | 16361 | 18136 | 19909 | 23606 | 25526 | 27814 | 29923 | 31855
1A + 1C | 3166 | 4667 | 6066 | 7367 | 8668 | 9867 | 11068 | 12268 | 13468 | 15969 | 17267 | 18815 | 20242 | 21549
1A + 2C | 3579 | 5275 | 6858 | 8328 | 9798 | 11154 | 12511 | 13868 | 15224 | 18052 | 19520 | 21269 | 22883 | 24359
Per Addi.Chd | 413 | 609 | 791 | 961 | 1131 | 1287 | 1444 | 1600 | 1757 | 2083 | 2252 | 2454 | 2640 | 2811
 | A = Adult |  | C = Child
AGE | SUM INSURED
56 - 60 Yrs | 100000 | 150000 | 200000 | 250000 | 300000 | 350000 | 400000 | 450000 | 500000 | 600000 | 700000 | 800000 | 900000 | 1000000
1A + 1A | 4877 | 7193 | 9362 | 11388 | 13415 | 15294 | 17177 | 19058 | 20937 | 24825 | 26765 | 29201 | 31445 | 33500
2A + 1C | 5364 | 7912 | 10298 | 12527 | 14756 | 16823 | 18894 | 20963 | 23031 | 27308 | 29441 | 32121 | 34589 | 36849
2A + 2C | 5852 | 8631 | 11234 | 13666 | 16097 | 18353 | 20612 | 22869 | 25124 | 29790 | 32117 | 35041 | 37733 | 40199
1A + 1C | 3739 | 5514 | 7177 | 8731 | 10284 | 11725 | 13169 | 14611 | 16052 | 19033 | 20519 | 22387 | 24107 | 25683
1A + 2C | 4226 | 6234 | 8113 | 9870 | 11626 | 13255 | 14886 | 16517 | 18145 | 21515 | 23196 | 25307 | 27252 | 29033
Per Addi.Chd | 488 | 719 | 936 | 1139 | 1341 | 1529 | 1718 | 1906 | 2094 | 2483 | 2676 | 2920 | 3144 | 3350
AGE | SUM INSURED
61 - 65 Yrs | 100000 | 150000 | 200000 | 250000 | 300000 | 350000 | 400000 | 450000 | 500000 | 600000 | 700000 | 800000 | 900000 | 1000000
1A + 1A | 5701 | 8410 | 10946 | 13315 | 15683 | 17882 | 20082 | 22282 | 24478 | 29024 | 31293 | 34139 | 36765 | 39165
2A + 1C | 6235 | 9198 | 11972 | 14564 | 17154 | 19558 | 21964 | 24371 | 26773 | 31745 | 34227 | 37340 | 40212 | 42837
2A + 2C | 6770 | 9986 | 12998 | 15812 | 18624 | 21234 | 23847 | 26459 | 29068 | 34466 | 37160 | 40540 | 43658 | 46508
1A + 1C | 4097 | 6044 | 7867 | 9570 | 11272 | 12852 | 14434 | 16015 | 17594 | 20861 | 22492 | 24538 | 26425 | 28150
1A + 2C | 4632 | 6833 | 8893 | 10819 | 12743 | 14529 | 16316 | 18104 | 19889 | 23582 | 25425 | 27738 | 29871 | 31821
Per Addi.Chd | 534 | 788 | 1026 | 1248 | 1470 | 1676 | 1883 | 2089 | 2295 | 2721 | 2934 | 3201 | 3447 | 3672
AGE | SUM INSURED
66 - 70 Yrs | 100000 | 150000 | 200000 | 250000 | 300000 | 350000 | 400000 | 450000 | 500000 | 600000 | 700000 | 800000 | 900000 | 1000000
1A + 1A | 6995 | 10334 | 13491 | 16458 | 19426 | 22210 | 24992 | 27776 | 30558 | 36232 | 38867 | 42486 | 45830 | 48393
2A + 1C | 7651 | 11308 | 14756 | 18001 | 21247 | 24292 | 27335 | 30380 | 33423 | 39629 | 42511 | 46470 | 50127 | 53477
2A + 2C | 8307 | 12272 | 16021 | 19543 | 23068 | 26374 | 29678 | 32984 | 36288 | 43026 | 43155 | 50453 | 54424 | 58060
1A + 1C | 5028 | 7428 | 9697 | 11829 | 13962 | 15963 | 17963 | 19964 | 21964 | 26042 | 27936 | 30537 | 32941 | 35142
1A + 2C | 5684 | 8397 | 10962 | 13372 | 15783 | 18045 | 20306 | 22568 | 24829 | 29439 | 31580 | 34520 | 37237 | 39725
Per Addi.Chd | 656 | 969 | 1265 | 15043 | 18021 | 2082 | 23043 | 2604 | 2865 | 3397 | 3644 | 3982 | 4297 | 4584