Spreadsheet: 44895d1243619129-how-to-make-my-formula-more-efficient-h1913_reorg_entitl_v2
Sheet: H1913_1914

PCG | LOB | Product | Accounts | Consoldiated Products | WGT | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00
H1913 |  | Voluntary | Voluntary | Reorganizations & Entitlements | 1 | 243.6 | 373 | 352 | 298 | 381 | 332 | 364 | 482 | 364 | 419 | 360 | 414 | 444 | 427 | 374 | 392 | 334 | 360 | 390 | 473 | 441 | 377 | 415 | 416 | 378 | 619 | 488 | 394 | 430 | 403 | 461 | 600 | 461 | 461 | 600 | 461
H1913 |  | Voluntary | Voluntary | Reorganizations & Entitlements | 1 | 52.2
H1913 |  | Voluntary | Voluntary | Reorganizations & Entitlements | 1 | 34.8
H1913 |  | Voluntary | Voluntary | Reorganizations & Entitlements | 1 | 17.4
H1913 |  | Mandatory | Mandatory | Reorganizations & Entitlements | 1 | 186 | 183 | 201 | 244 | 208 | 197 | 216 | 261 | 257 | 272 | 167 | 250 | 224 | 217 | 185 | 170 | 163 | 223 | 163 | 211 | 287 | 162 | 166 | 214 | 187 | 256 | 217 | 172 | 314 | 463 | 229 | 229 | 229 | 229 | 229 | 229
H1913 |  | Mandatory | Mandatory | Reorganizations & Entitlements | 1
H1913 |  | Mandatory | Mandatory | Reorganizations & Entitlements | 1
H1913 |  | Mandatory | Mandatory | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Cash Dividends | Reorganizations & Entitlements | 1 | 1435 | 2003 | 1687 | 1298 | 1710 | 1642 | 1723 | 2153 | 1822 | 1493 | 1922 | 1765 | 1438 | 2167 | 1912 | 1346 | 1943 | 2200 | 1746 | 2091 | 1669 | 1324 | 2067 | 1669 | 1300 | 2298 | 1451 | 1180 | 1801 | 1523 | 1606 | 1801 | 1606 | 1606 | 1801 | 1606
H1913 |  | Entitlements | Cash Dividends | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Cash Dividends | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Cash Dividends | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Mutual Funds | Reorganizations & Entitlements | 1 | 937 | 1521 | 908 | 749 | 743 | 1170 | 1130 | 1046 | 1414 | 947 | 1147 | 1739 | 1091 | 2555 | 1688 | 1123 | 1590 | 1838 | 1279 | 1096 | 1227 | 669 | 1477 | 1314 | 1541 | 2462 | 1135 | 1535 | 1971 | 1751 | 1729 | 1729 | 1729 | 1729 | 1729 | 1729
H1913 |  | Entitlements | Mutual Funds | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Mutual Funds | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Mutual Funds | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Premium Dist. | Reorganizations & Entitlements | 1 | 14 | 10 | 10 | 9 | 9 | 10 | 8 | 7 | 7 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
H1913 |  | Entitlements | Premium Dist. | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Premium Dist. | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Premium Dist. | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | DRIP's | Reorganizations & Entitlements | 1 | 140 | 118 | 170 | 125 | 234 | 139 | 132 | 133 | 139 | 126 | 117 | 139 | 111 | 140 | 139 | 114 | 108 | 149 | 119 | 101 | 130 | 109 | 98 | 334 | 114 | 105 | 121 | 106 | 108 | 148 | 110 | 121 | 110 | 110 | 121 | 110
H1913 |  | Entitlements | DRIP's | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | DRIP's | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | DRIP's | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Bond Mat | Reorganizations & Entitlements | 1 | 720 | 670 | 753 | 661 | 800 | 725 | 775 | 812 | 690 | 620 | 442 | 681 | 686 | 777 | 771 | 952 | 635 | 699 | 698 | 636 | 587 | 454 | 572 | 658 | 612 | 686 | 635 | 552 | 566 | 589 | 610 | 610 | 610 | 610 | 610 | 610
H1913 |  | Entitlements | Bond Mat | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Bond Mat | Reorganizations & Entitlements | 1
H1913 |  | Entitlements | Bond Mat | Reorganizations & Entitlements | 1
H1913 |  | Other Entitlements | Bond Int | Reorganizations & Entitlements | 1 | 1244 | 1451 | 1516 | 1352 | 1657 | 2282 | 1513 | 2579 | 1508 | 1333 | 1623 | 1780 | 1673 | 3127 | 1622 | 1503 | 1559 | 1450 | 1319 | 2375 | 1004 | 1353 | 1395 | 1153 | 1372 | 1647 | 791 | 1047 | 1678 | 1406 | 1307 | 1678 | 1307 | 1307 | 1678 | 1307
H1913 |  | Other Entitlements | Bond Int | Reorganizations & Entitlements | 1
H1913 |  | Other Entitlements | Bond Int | Reorganizations & Entitlements | 1
H1913 |  | Other Entitlements | Bond Int | Reorganizations & Entitlements | 1
H1913 |  | Other Entitlements | GIC Mat | Reorganizations & Entitlements | 1 | 2150 | 1900 | 2141 | 3755 | 2753 | 3048 | 1705 | 2673 | 2141 | 2087 | 1277 | 1607 | 1614 | 1627 | 1419 | 1684 | 1446 | 1155 | 1220 | 1456 | 1298 | 1273 | 1272 | 1397 | 1551 | 1364 | 1388 | 1711 | 1453 | 1283 | 1493 | 1493 | 1493 | 1493 | 1493 | 1493
H1913 |  | Other Entitlements | GIC Mat | Reorganizations & Entitlements | 1
H1913 |  | Other Entitlements | GIC Mat | Reorganizations & Entitlements | 1
H1913 |  | Other Entitlements | GIC Mat | Reorganizations & Entitlements | 1
H1913 |  | Other Entitlements | GIC Int | Reorganizations & Entitlements | 1 | 3953 | 3177 | 4372 | 3452 | 4406 | 4740 | 5120 | 6460 | 6093 | 5779 | 4028 | 5951 | 5939 | 5150 | 6295 | 6163 | 6035 | 6465 | 6195 | 6620 | 6243 | 6510 | 6931 | 7253 | 7649 | 8156 | 6960 | 6991 | 8710 | 7592 | 8000 | 7693 | 8000 | 7693 | 8000 | 7693
H1913 |  | Other Entitlements | GIC Int | Reorganizations & Entitlements | 1
H1913 |  | Other Entitlements | GIC Int | Reorganizations & Entitlements | 1
H1913 |  | Other Entitlements | GIC Int | Reorganizations & Entitlements | 1
H1913 | Spare
H1913 | Spare
H1913 | Spare
H1913 | Spare
H1913 | Spare
H1913 | Spare
H1913 | Spare
H1913 | Spare
H1913 | Spare
H1913 | Spare
H1913 | Spare
 |  |  |  | TOTAL WGT VOL |  | 11127 | 11406 | 12110 | 11943 | 12901 | 14285 | 12686 | 16606 | 14435 | 13081 | 11088 | 14331 | 13224 | 16191 | 14409 | 13451 | 13817 | 14543 | 13132 | 15062 | 12890 | 12234 | 14393 | 14408 | 14704 | 17593 | 13186 | 13688 | 17031 | 15158 | 15545 | 15954 | 15545 | 15238 | 16261 | 15238