Spreadsheet: 44907d1243628984-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 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 461 | 600 | 461 | 461 | 600 | 461
H1913 |  | Voluntary | Voluntary | Reorganizations & Entitlements | 1 | 52.2 | 55.95 | 52.8 | 44.7 | 57.15 | 49.8 | 54.6 | 72.3 | 54.6 | 62.84999999999999 | 54 | 62.09999999999999 | 66.6 | 64.05 | 56.1 | 58.8 | 50.1 | 54 | 58.5 | 70.95 | 66.14999999999999 | 56.55 | 62.25 | 62.4 | 56.7 | 92.85 | 73.2 | 59.09999999999999 | 64.5 | 60.45
H1913 |  | Voluntary | Voluntary | Reorganizations & Entitlements | 1 | 34.8 | 37.3 | 35.2 | 29.8 | 38.1 | 33.2 | 36.4 | 48.2 | 36.4 | 41.90000000000001 | 36 | 41.40000000000001 | 44.40000000000001 | 42.7 | 37.4 | 39.2 | 33.4 | 36 | 39 | 47.3 | 44.1 | 37.7 | 41.5 | 41.6 | 37.8 | 61.90000000000001 | 48.8 | 39.40000000000001 | 43 | 40.3
H1913 |  | Voluntary | Voluntary | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H1913 |  | Mandatory | Mandatory | Reorganizations & Entitlements | 1 | 130.2 | 128.1 | 140.7 | 170.8 | 145.6 | 137.9 | 151.2 | 182.7 | 179.9 | 190.4 | 116.9 | 175 | 156.8 | 151.9 | 129.5 | 119 | 114.1 | 156.1 | 114.1 | 147.7 | 200.9 | 113.4 | 116.2 | 149.8 | 130.9 | 179.2 | 151.9 | 120.4 | 219.8 | 324.1 | 229 | 229 | 229 | 229 | 229 | 229
H1913 |  | Mandatory | Mandatory | Reorganizations & Entitlements | 1 | 27.9 | 27.45 | 30.15 | 36.6 | 31.2 | 29.55 | 32.4 | 39.15 | 38.55 | 40.8 | 25.05 | 37.5 | 33.6 | 32.55 | 27.75 | 25.5 | 24.45 | 33.45 | 24.45 | 31.65 | 43.05 | 24.3 | 24.9 | 32.1 | 28.05 | 38.4 | 32.55 | 25.8 | 47.1 | 69.45
H1913 |  | Mandatory | Mandatory | Reorganizations & Entitlements | 1 | 18.6 | 18.3 | 20.1 | 24.4 | 20.8 | 19.7 | 21.6 | 26.1 | 25.7 | 27.2 | 16.7 | 25 | 22.4 | 21.7 | 18.5 | 17 | 16.3 | 22.3 | 16.3 | 21.1 | 28.7 | 16.2 | 16.6 | 21.4 | 18.7 | 25.6 | 21.7 | 17.2 | 31.4 | 46.3
H1913 |  | Mandatory | Mandatory | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H1913 |  | Entitlements | Cash Dividends | Reorganizations & Entitlements | 1 | 1004.5 | 1402.1 | 1180.9 | 908.5999999999999 | 1197 | 1149.4 | 1206.1 | 1507.1 | 1275.4 | 1045.1 | 1345.4 | 1235.5 | 1006.6 | 1516.9 | 1338.4 | 942.1999999999999 | 1360.1 | 1540 | 1222.2 | 1463.7 | 1168.3 | 926.8 | 1446.9 | 1168.3 | 909.9999999999999 | 1608.6 | 1015.7 | 826 | 1260.7 | 1066.1 | 1606 | 1801 | 1606 | 1606 | 1801 | 1606
H1913 |  | Entitlements | Cash Dividends | Reorganizations & Entitlements | 1 | 215.25 | 300.45 | 253.05 | 194.7 | 256.5 | 246.3 | 258.45 | 322.95 | 273.3 | 223.95 | 288.3 | 264.75 | 215.7 | 325.05 | 286.8 | 201.9 | 291.45 | 330 | 261.9 | 313.65 | 250.35 | 198.6 | 310.05 | 250.35 | 195 | 344.7 | 217.65 | 177 | 270.15 | 228.45
H1913 |  | Entitlements | Cash Dividends | Reorganizations & Entitlements | 1 | 143.5 | 200.3 | 168.7 | 129.8 | 171 | 164.2 | 172.3 | 215.3 | 182.2 | 149.3 | 192.2 | 176.5 | 143.8 | 216.7 | 191.2 | 134.6 | 194.3 | 220 | 174.6 | 209.1 | 166.9 | 132.4 | 206.7 | 166.9 | 130 | 229.8 | 145.1 | 118 | 180.1 | 152.3
H1913 |  | Entitlements | Cash Dividends | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H1913 |  | Entitlements | Mutual Funds | Reorganizations & Entitlements | 1 | 655.9 | 1064.7 | 635.5999999999999 | 524.3 | 520.1 | 819 | 791 | 732.1999999999999 | 989.8 | 662.9 | 802.9 | 1217.3 | 763.6999999999999 | 1788.5 | 1181.6 | 786.0999999999999 | 1113 | 1286.6 | 895.3 | 767.1999999999999 | 858.9 | 468.3 | 1033.9 | 919.8 | 1078.7 | 1723.4 | 794.5 | 1074.5 | 1379.7 | 1225.7 | 1729 | 1729 | 1729 | 1729 | 1729 | 1729
H1913 |  | Entitlements | Mutual Funds | Reorganizations & Entitlements | 1 | 140.55 | 228.15 | 136.2 | 112.35 | 111.45 | 175.5 | 169.5 | 156.9 | 212.1 | 142.05 | 172.05 | 260.85 | 163.65 | 383.25 | 253.2 | 168.45 | 238.5 | 275.7 | 191.85 | 164.4 | 184.05 | 100.35 | 221.55 | 197.1 | 231.15 | 369.3 | 170.25 | 230.25 | 295.65 | 262.65
H1913 |  | Entitlements | Mutual Funds | Reorganizations & Entitlements | 1 | 93.7 | 152.1 | 90.80000000000001 | 74.9 | 74.3 | 117 | 113 | 104.6 | 141.4 | 94.7 | 114.7 | 173.9 | 109.1 | 255.5 | 168.8 | 112.3 | 159 | 183.8 | 127.9 | 109.6 | 122.7 | 66.9 | 147.7 | 131.4 | 154.1 | 246.2 | 113.5 | 153.5 | 197.1 | 175.1
H1913 |  | Entitlements | Mutual Funds | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H1913 |  | Entitlements | Premium Dist. | Reorganizations & Entitlements | 1 | 9.799999999999999 | 7 | 7 | 6.3 | 6.3 | 7 | 5.6 | 4.899999999999999 | 4.899999999999999 | 3.5 | 3.5 | 3.5 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.1 | 2.1 | 2.8 | 2.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
H1913 |  | Entitlements | Premium Dist. | Reorganizations & Entitlements | 1 | 2.1 | 1.5 | 1.5 | 1.35 | 1.35 | 1.5 | 1.2 | 1.05 | 1.05 | 0.75 | 0.75 | 0.75 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.45 | 0.45 | 0.6 | 0.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
H1913 |  | Entitlements | Premium Dist. | Reorganizations & Entitlements | 1 | 1.4 | 1 | 1 | 0.9 | 0.9 | 1 | 0.8 | 0.7000000000000001 | 0.7000000000000001 | 0.5 | 0.5 | 0.5 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.3 | 0.3 | 0.4 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
H1913 |  | Entitlements | Premium Dist. | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H1913 |  | Entitlements | DRIP's | Reorganizations & Entitlements | 1 | 98 | 82.6 | 119 | 87.5 | 163.8 | 97.3 | 92.39999999999999 | 93.1 | 97.3 | 88.19999999999999 | 81.89999999999999 | 97.3 | 77.69999999999999 | 98 | 97.3 | 79.8 | 75.6 | 104.3 | 83.3 | 70.69999999999999 | 91 | 76.3 | 68.6 | 233.8 | 79.8 | 73.5 | 84.69999999999999 | 74.19999999999999 | 75.6 | 103.6 | 110 | 121 | 110 | 110 | 121 | 110
H1913 |  | Entitlements | DRIP's | Reorganizations & Entitlements | 1 | 21 | 17.7 | 25.5 | 18.75 | 35.1 | 20.85 | 19.8 | 19.95 | 20.85 | 18.9 | 17.55 | 20.85 | 16.65 | 21 | 20.85 | 17.1 | 16.2 | 22.35 | 17.85 | 15.15 | 19.5 | 16.35 | 14.7 | 50.1 | 17.1 | 15.75 | 18.15 | 15.9 | 16.2 | 22.2
H1913 |  | Entitlements | DRIP's | Reorganizations & Entitlements | 1 | 14 | 11.8 | 17 | 12.5 | 23.4 | 13.9 | 13.2 | 13.3 | 13.9 | 12.6 | 11.7 | 13.9 | 11.1 | 14 | 13.9 | 11.4 | 10.8 | 14.9 | 11.9 | 10.1 | 13 | 10.9 | 9.8 | 33.4 | 11.4 | 10.5 | 12.1 | 10.6 | 10.8 | 14.8
H1913 |  | Entitlements | DRIP's | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H1913 |  | Entitlements | Bond Mat | Reorganizations & Entitlements | 1 | 503.9999999999999 | 468.9999999999999 | 527.1 | 462.7 | 560 | 507.4999999999999 | 542.5 | 568.4 | 482.9999999999999 | 434 | 309.4 | 476.7 | 480.2 | 543.9 | 539.6999999999999 | 666.4 | 444.5 | 489.3 | 488.6 | 445.2 | 410.9 | 317.8 | 400.4 | 460.6 | 428.4 | 480.2 | 444.5 | 386.4 | 396.2 | 412.3 | 610 | 610 | 610 | 610 | 610 | 610
H1913 |  | Entitlements | Bond Mat | Reorganizations & Entitlements | 1 | 108 | 100.5 | 112.95 | 99.14999999999999 | 120 | 108.75 | 116.25 | 121.8 | 103.5 | 93 | 66.3 | 102.15 | 102.9 | 116.55 | 115.65 | 142.8 | 95.25 | 104.85 | 104.7 | 95.39999999999999 | 88.05 | 68.1 | 85.8 | 98.7 | 91.8 | 102.9 | 95.25 | 82.8 | 84.89999999999999 | 88.35
H1913 |  | Entitlements | Bond Mat | Reorganizations & Entitlements | 1 | 72 | 67 | 75.3 | 66.10000000000001 | 80 | 72.5 | 77.5 | 81.2 | 69 | 62 | 44.2 | 68.10000000000001 | 68.60000000000001 | 77.7 | 77.10000000000001 | 95.2 | 63.5 | 69.9 | 69.8 | 63.6 | 58.7 | 45.40000000000001 | 57.2 | 65.8 | 61.2 | 68.60000000000001 | 63.5 | 55.2 | 56.6 | 58.90000000000001
H1913 |  | Entitlements | Bond Mat | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H1913 |  | Other Entitlements | Bond Int | Reorganizations & Entitlements | 1 | 870.8 | 1015.7 | 1061.2 | 946.4 | 1159.9 | 1597.4 | 1059.1 | 1805.3 | 1055.6 | 933.0999999999999 | 1136.1 | 1246 | 1171.1 | 2188.9 | 1135.4 | 1052.1 | 1091.3 | 1015 | 923.3 | 1662.5 | 702.8 | 947.0999999999999 | 976.4999999999999 | 807.0999999999999 | 960.4 | 1152.9 | 553.6999999999999 | 732.9 | 1174.6 | 984.1999999999999 | 1307 | 1678 | 1307 | 1307 | 1678 | 1307
H1913 |  | Other Entitlements | Bond Int | Reorganizations & Entitlements | 1 | 186.6 | 217.65 | 227.4 | 202.8 | 248.55 | 342.3 | 226.95 | 386.85 | 226.2 | 199.95 | 243.45 | 267 | 250.95 | 469.05 | 243.3 | 225.45 | 233.85 | 217.5 | 197.85 | 356.25 | 150.6 | 202.95 | 209.25 | 172.95 | 205.8 | 247.05 | 118.65 | 157.05 | 251.7 | 210.9
H1913 |  | Other Entitlements | Bond Int | Reorganizations & Entitlements | 1 | 124.4 | 145.1 | 151.6 | 135.2 | 165.7 | 228.2 | 151.3 | 257.9 | 150.8 | 133.3 | 162.3 | 178 | 167.3 | 312.7 | 162.2 | 150.3 | 155.9 | 145 | 131.9 | 237.5 | 100.4 | 135.3 | 139.5 | 115.3 | 137.2 | 164.7 | 79.10000000000001 | 104.7 | 167.8 | 140.6
H1913 |  | Other Entitlements | Bond Int | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H1913 |  | Other Entitlements | GIC Mat | Reorganizations & Entitlements | 1 | 1505 | 1330 | 1498.7 | 2628.5 | 1927.1 | 2133.6 | 1193.5 | 1871.1 | 1498.7 | 1460.9 | 893.9 | 1124.9 | 1129.8 | 1138.9 | 993.3 | 1178.8 | 1012.2 | 808.5 | 854 | 1019.2 | 908.5999999999999 | 891.0999999999999 | 890.4 | 977.9 | 1085.7 | 954.8 | 971.5999999999999 | 1197.7 | 1017.1 | 898.0999999999999 | 1493 | 1493 | 1493 | 1493 | 1493 | 1493
H1913 |  | Other Entitlements | GIC Mat | Reorganizations & Entitlements | 1 | 322.5 | 285 | 321.15 | 563.25 | 412.95 | 457.2 | 255.75 | 400.95 | 321.15 | 313.05 | 191.55 | 241.05 | 242.1 | 244.05 | 212.85 | 252.6 | 216.9 | 173.25 | 183 | 218.4 | 194.7 | 190.95 | 190.8 | 209.55 | 232.65 | 204.6 | 208.2 | 256.65 | 217.95 | 192.45
H1913 |  | Other Entitlements | GIC Mat | Reorganizations & Entitlements | 1 | 215 | 190 | 214.1 | 375.5 | 275.3 | 304.8 | 170.5 | 267.3 | 214.1 | 208.7 | 127.7 | 160.7 | 161.4 | 162.7 | 141.9 | 168.4 | 144.6 | 115.5 | 122 | 145.6 | 129.8 | 127.3 | 127.2 | 139.7 | 155.1 | 136.4 | 138.8 | 171.1 | 145.3 | 128.3
H1913 |  | Other Entitlements | GIC Mat | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H1913 |  | Other Entitlements | GIC Int | Reorganizations & Entitlements | 1 | 2767.1 | 2223.9 | 3060.4 | 2416.4 | 3084.2 | 3318 | 3584 | 4522 | 4265.099999999999 | 4045.3 | 2819.6 | 4165.7 | 4157.3 | 3605 | 4406.5 | 4314.099999999999 | 4224.5 | 4525.5 | 4336.5 | 4634 | 4370.099999999999 | 4557 | 4851.7 | 5077.099999999999 | 5354.299999999999 | 5709.2 | 4872 | 4893.7 | 6097 | 5314.4 | 8000 | 7693 | 8000 | 7693 | 8000 | 7693
H1913 |  | Other Entitlements | GIC Int | Reorganizations & Entitlements | 1 | 592.9499999999999 | 476.55 | 655.8 | 517.8 | 660.9 | 711 | 768 | 969 | 913.9499999999999 | 866.85 | 604.1999999999999 | 892.65 | 890.85 | 772.5 | 944.25 | 924.4499999999999 | 905.25 | 969.75 | 929.25 | 993 | 936.4499999999999 | 976.5 | 1039.65 | 1087.95 | 1147.35 | 1223.4 | 1044 | 1048.65 | 1306.5 | 1138.8
H1913 |  | Other Entitlements | GIC Int | Reorganizations & Entitlements | 1 | 395.3 | 317.7 | 437.2 | 345.2 | 440.6 | 474 | 512 | 646 | 609.3000000000001 | 577.9 | 402.8 | 595.1 | 593.9 | 515 | 629.5 | 616.3000000000001 | 603.5 | 646.5 | 619.5 | 662 | 624.3000000000001 | 651 | 693.1 | 725.3000000000001 | 764.9000000000001 | 815.6 | 696 | 699.1 | 871 | 759.2
H1913 |  | Other Entitlements | GIC Int | Reorganizations & Entitlements | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
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