Spreadsheet: 124435d1318419198-sumifs-problem-sumifs-problem
Sheet: Raw Data

Year | Status1 | Status2 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Year 12 | Year 13 | Year 14 | Year 15 | Year 16 | Latest Value
1996 | Closed | Paid | 0 | 0 | 189.5 | 189.5 | 189.5 | 189.5 | 189.5 | 1044.9 | 3242.74 | 6870.52 | 7760.02 | 610611 | 616547.85 | 616547.85 | 616547.85 | 616547.85
1996 | Closed | Outstanding | 0 | 16200 | 16200 | 16200 | 16200 | 16200 | 38600 | 999144.6 | 996946.76 | 1993129.48 | 1992429.48 | 2825 | 0 | 0 | 0 | 0
1996 | Closed | Incurred | 0 | 16200 | 16389.5 | 16389.5 | 16389.5 | 16389.5 | 38789.5 | 1000189.5 | 1000189.5 | 2000000 | 2000189.5 | 613436 | 616547.85 | 616547.85 | 616547.85 | 616547.85
1996 | Closed | Paid | 693.32 | 693.32 | 693.32 | 893.32 | 893.32 | 1841.49 | 2646.37 | 7128.46 | 731294.97 | 731294.97 | 731294.97 | 731294.97 | 731294.97 | 731294.97 | 731294.97 | 731294.97
1996 | Closed | Outstanding | 5000 | 250000 | 250000 | 250000 | 250000 | 475000 | 474196 | 1469713.91 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1996 | Closed | Incurred | 5693.32 | 250693.32 | 250693.32 | 250893.32 | 250893.32 | 476841.49 | 476842.37 | 1476842.37 | 731295.97 | 731294.97 | 731294.97 | 731294.97 | 731294.97 | 731294.97 | 731294.97 | 731294.97
1996 | Closed | Paid | 46 | 10072.38 | 42698.29 | 48840.37 | 167876 | 677226 | 697664 | 720253.39 | 1655472.87 | 1657394.18 | 2714745.91 | 3211229 | 2977294.85 | 2977294.85 | 2977294.85 | 2977294.85
1996 | Closed | Outstanding | 750000 | 750000 | 750000 | 750000 | 700000 | 425000 | 425000 | 1275000 | 339780.52 | 502922.87 | 285253.7 | 281 | 0 | 0 | 0 | 0
1996 | Closed | Incurred | 750046 | 760072.38 | 792698.29 | 798840.37 | 867876 | 1102226 | 1122664 | 1995253.39 | 1995253.39 | 2160317.05 | 2999999.61 | 3211510 | 2977294.85 | 2977294.85 | 2977294.85 | 2977294.85
1996 | Closed | Paid | 50 | 918.88 | 2118.88 | 3749.06 | 10528 | 10528 | 1265779 | 1240374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7
1996 | Closed | Outstanding | 1500000 | 1500000 | 1500000 | 1000000 | 1000000 | 1000000 | 34000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1996 | Closed | Incurred | 1500050 | 1500918.88 | 1502118.88 | 1003749.06 | 1010528 | 1010528 | 1299779 | 1240374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7 | 1243374.7
1996 | Closed | Paid | 0 | 2197 | 1977 | 2993 | 3603 | 3728 | 3728.36 | 757953.88 | 766257.38 | 766257.38 | 766257.38 | 766257.38 | 766257.38 | 766257.38 | 766257.38 | 766257.38
1996 | Closed | Outstanding | 0 | 5000 | 250000 | 998983 | 998373 | 998248 | 998248 | 574677 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1996 | Closed | Incurred | 0 | 7197 | 251977 | 1001976 | 1001976 | 1001976 | 1001976.36 | 1332630.88 | 766257.38 | 766257.38 | 766257.38 | 766257.38 | 766257.38 | 766257.38 | 766257.38 | 766257.38
1996 | Open | Paid | 0 | 543 | 543 | 543 | 5330 | 8532 | 17230.91 | 19802.61 | 23358.37 | 37369.01 | 64693.9 | 191229 | 205121 | 677934 | 1522910.8 | 1568323
1996 | Open | Outstanding | 0 | 100000 | 100000 | 1000000 | 107010 | 101445 | 1261838.78 | 1259267.08 | 2489803.02 | 3962631.01 | 3935306.57 | 3808463 | 3794572 | 3299949 | 2474778 | 2429366
1996 | Open | Incurred | 0 | 100543 | 100543 | 1000543 | 112340 | 109977 | 1279069.69 | 1279069.69 | 2513161.39 | 4000000.02 | 4000000.47 | 3999692 | 3999693 | 3977883 | 3997688.8 | 3997689
1997 | Closed | Paid | 50 | 731.6 | 731.6 | 731.6 | 731.6 | 731.6 | 25302.25 | 84040.58 | 98426.97 | 864455.26 | 950085 | 950245.08 | 950245.08 | 950245.08 | 950245.08
1997 | Closed | Outstanding | 5600 | 32500 | 32500 | 32500 | 32500 | 78000 | 1475429.35 | 917646.51 | 913763.73 | 215245 | 129615 | 0 | 0 | 0 | 0
1997 | Closed | Incurred | 5650 | 33231.6 | 33231.6 | 33231.6 | 33231.6 | 78731.6 | 1500731.6 | 1001687.09 | 1012190.7 | 1079700.26 | 1079700 | 950245.08 | 950245.08 | 950245.08 | 950245.08
1997 | Closed | Paid | 499 | 2949 | 89205 | 153965 | 412871 | 439315 | 500439.9 | 2277497.42 | 2319104.9 | 2319104.9 | 2319104.9 | 2319104.9 | 2319104.9 | 2319104.9 | 2319104.9
1997 | Closed | Outstanding | 90000 | 148000 | 210794 | 846035 | 587129 | 560700 | 2000000 | 222942.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1997 | Closed | Incurred | 90499 | 150949 | 299999 | 1000000 | 1000000 | 1000015 | 2500439.9 | 2500439.9 | 2319104.9 | 2319104.9 | 2319104.9 | 2319104.9 | 2319104.9 | 2319104.9 | 2319104.9
1997 | Closed | Paid | 1980 | 287422 | 368627 | 541266 | 838872 | 2551347 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03
1997 | Closed | Outstanding | 2001 | 717166 | 940948 | 1470626 | 1911619 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1997 | Closed | Incurred | 3981 | 1004588 | 1309575 | 2011892 | 2750491 | 2556347 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03 | 2547025.03
1997 | Closed | Paid | 102.88 | 6477 | 6817 | 6817 | 138134 | 160372.41 | 179147.02 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95
1997 | Closed | Outstanding | 26700 | 21000 | 21000 | 250000 | 1025000 | 1839068 | 1817899 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1997 | Closed | Incurred | 26802.88 | 27477 | 27817 | 256817 | 1163134 | 1999440.41 | 1997046.02 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95 | 1316114.95
1997 | Closed | Paid | 0 | 14389.65 | 14389.65 | 14389.65 | 14389.65 | 14389.65 | 14607.04 | 16572 | 17374.01 | 1081103.53 | 1414777 | 1431851 | 1431851 | 1431851 | 1431851
1997 | Closed | Outstanding | 25000 | 25000 | 25000 | 50000 | 70000 | 70000 | 124783 | 429573 | 428771.03 | 1115041 | 299630 | 0 | 0 | 0 | 0
1997 | Closed | Incurred | 0 | 39389.65 | 39389.65 | 64389.65 | 84389.65 | 84389.65 | 139390.04 | 446145 | 446145.04 | 2196144.53 | 1714407 | 1431851 | 1431851 | 1431851 | 1431851
1997 | Closed | Paid | 0 | 2070 | 2420 | 2420 | 5548 | 25356.67 | 41055.15 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35
1997 | Closed | Outstanding | 11050 | 20000 | 20000 | 750000 | 746872 | 1104844 | 1292686 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1997 | Closed | Incurred | 11050 | 22070 | 22420 | 752420 | 752420 | 1130200.67 | 1333741.15 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35 | 1026566.35
1997 | Closed | Paid | 129 | 0 | 0 | 129 | 1206949 | 1207832 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54
1997 | Closed | Outstanding | 0 | 0 | 0 | 1000000 | 100000 | 100000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1997 | Closed | Incurred | 129 | 0 | 0 | 1000129 | 1306949 | 1307832 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54 | 1242296.54
1998 | Closed | Paid | 4293 | 68672 | 73264 | 132252 | 145666.12 | 825556.27 | 844920.6 | 1239801.48 | 1184955.76 | 1184955.76 | 1184955.76 | 1184955.76 | 1184955.76 | 1184955.76
1998 | Closed | Outstanding | 31000 | 115000 | 116000 | 478583 | 1354334 | 677000 | 617634.67 | 222561 | 0 | 0 | 0 | 0 | 0 | 0
1998 | Closed | Incurred | 35293 | 183672 | 189264 | 610835 | 1500000.12 | 1502556.27 | 1462555.27 | 1462362.48 | 1184955.76 | 1184955.76 | 1184955.76 | 1184955.76 | 1184955.76 | 1184955.76
1998 | Closed | Paid | 1000 | 8726 | 13520 | 21508 | 21678.17 | 217767.05 | 258671 | 258671 | 258671 | 258671 | 258671 | 258671 | 258671 | 258671
1998 | Closed | Outstanding | 1000000 | 996500 | 992000 | 984012 | 378322 | 84125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1998 | Closed | Incurred | 1001000 | 1005226 | 1005520 | 1005520 | 400000.17 | 301892.05 | 258671 | 258671 | 258671 | 258671 | 258671 | 258671 | 258671 | 258671
1998 | Closed | Paid | 0 | 1494.56 | 1195.93 | 2588 | 7505.69 | 35761.41 | 1769998.24 | 1929386.17 | 2623987.27 | 2624227.27 | 2625202.27 | 2625202.27 | 2625202.27 | 2625202.27
1998 | Closed | Outstanding | 0 | 98800 | 98800 | 97400 | 2742494 | 2714437 | 980060.98 | 857910.08 | 0 | 0 | 0 | 0 | 0 | 0
1998 | Closed | Incurred | 0 | 100294.56 | 99995.93 | 99988 | 2749999.69 | 2750198.41 | 2750059.22 | 2787296.25 | 2623987.27 | 2624227.27 | 2625202.27 | 2625202.27 | 2625202.27 | 2625202.27
1998 | Open | Paid | 0 | 6901.6 | 9644.1 | 9644.1 | 40085.75 | 77128.85 | 322404.74 | 434048.38 | 681642.28 | 949296 | 1177388 | 2506566 | 3046011.66 | 3198765
1998 | Open | Outstanding | 0 | 75000 | 101000 | 101000 | 86555 | 1535412 | 1290136.53 | 1186571.3 | 1831000 | 1550706 | 1319975 | 8436 | 461619 | 308863
1998 | Open | Incurred | 0 | 81901.6 | 110644.1 | 110644.1 | 126640.75 | 1612540.85 | 1612541.27 | 1620619.68 | 2512642.28 | 2500002 | 2497363 | 2515002 | 3507630.66 | 3507628
1998 | Open | Paid | 0 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 25938
1998 | Open | Outstanding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1995084
1998 | Open | Incurred | 0 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 6021 | 2021022
1998 | Closed | Paid | 16072.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97
1998 | Closed | Outstanding | 48000 | 500000 | 500000 | 500000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1998 | Closed | Incurred | 64072.97 | 1059151.97 | 1059151.97 | 1059151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97 | 559151.97
1999 | Closed | Paid | 50 | 50 | 50 | 50 | 10080.08 | 295108.62 | 295108.62 | 295108.62 | 295108.62 | 295108.62 | 295108.62 | 295108.62 | 295108.62
1999 | Closed | Outstanding | 25740 | 25740 | 25740 | 25740 | 1365659.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1999 | Closed | Incurred | 25790 | 25790 | 25790 | 25790 | 1375739.2 | 295108.62 | 295108.62 | 295108.62 | 295108.62 | 295108.62 | 295108.62 | 295108.62 | 295108.62
1999 | Closed | Paid | 0 | 0 | 0 | 494871.89 | 2686999.66 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57
1999 | Closed | Outstanding | 59250 | 759250 | 1509250 | 3022627 | 46505 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1999 | Closed | Incurred | 59250 | 759250 | 1509250 | 3517498.89 | 2733504.66 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57 | 2663166.57
1999 | Closed | Paid | 0 | 0 | 259 | 259 | 1877.09 | 21774.77 | 262471 | 586020.07 | 586020.07 | 586020.07 | 586020.07 | 586020.07 | 586020.07
1999 | Closed | Outstanding | 0 | 1128 | 125869 | 163369 | 1298122.47 | 1278224.79 | 1040421 | 0 | 0 | 0 | 0 | 0 | 0
1999 | Closed | Incurred | 0 | 1128 | 126128 | 163628 | 1299999.56 | 1299999.56 | 1302892 | 586020.07 | 586020.07 | 586020.07 | 586020.07 | 586020.07 | 586020.07
1999 | Closed | Paid | 0 | 692.52 | 802.52 | 13922.18 | 18761.06 | 31749.48 | 33112.18 | 186316.83 | 201885.91 | 201885.91 | 201885.91 | 201885.91 | 201885.91
1999 | Closed | Outstanding | 0 | 16423 | 66423 | 65001 | 1182722.9 | 1188744.35 | 1196052.18 | 178155.6 | 0 | 0 | 0 | 0 | 0
1999 | Closed | Incurred | 0 | 17115.52 | 67225.52 | 78923.18 | 1201483.96 | 1220493.83 | 1229164.36 | 364472.43 | 201885.91 | 201885.91 | 201885.91 | 201885.91 | 201885.91
1999 | Closed | Paid | 0 | 84840 | 114686 | 267917.74 | 2370200.53 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66
1999 | Closed | Outstanding | 240000 | 415160 | 537514 | 434500 | 379800.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1999 | Closed | Incurred | 240000 | 500000 | 652200 | 702417.74 | 2750000.65 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66 | 2545909.66
1999 | Open | Paid | 5435 | 9533 | 10533 | 42048 | 52900 | 54393 | 65017 | 73283 | 80832 | 91230 | 129006 | 224355.2 | 746829
1999 | Open | Outstanding | 0 | 0 | 0 | 489148 | 485890 | 480530 | 477030 | 465536 | 461216 | 450818 | 870995 | 775648 | 2753171
1999 | Open | Incurred | 5435 | 9533 | 10533 | 531196 | 538790 | 534923 | 542047 | 538819 | 542048 | 542048 | 1000001 | 1000003.2 | 3500000
1999 | Open | Paid | 0 | 6063 | 6204.08 | 6204.08 | 7454.08 | 7454.08 | 8270.71 | 11443.6 | 14650 | 16762 | 12223 | 35262.19 | 1001188
1999 | Open | Outstanding | 0 | 6063 | 729688 | 729688 | 731934.37 | 731934.37 | 729398.25 | 728761.4 | 1565351 | 1563239 | 1415325 | 2100001 | 34082
1999 | Open | Incurred | 0 | 12126 | 735892.08 | 735892.08 | 739388.45 | 739388.45 | 737668.96 | 740205 | 1580001 | 1580001 | 1427548 | 2135263.19 | 1035270
2000 | Closed | Paid | 0 | 83 | 18457.62 | 21622.39 | 177585.26 | 190511.17 | 203909.94 | 204449.03 | 204449.03 | 204449.03 | 204449.03 | 204449.03
2000 | Closed | Outstanding | 0 | 15223 | 15000 | 996835.23 | 840872.36 | 58626 | 46090 | 0 | 0 | 0 | 0 | 0
2000 | Closed | Incurred | 0 | 15306 | 33457.62 | 1018457.62 | 1018457.62 | 249137.17 | 249999.94 | 204449.03 | 204449.03 | 204449.03 | 204449.03 | 204449.03
2000 | Closed | Paid | 0 | 5312.3 | 6775.76 | 26653.31 | 1094986 | 1094986 | 1094986 | 1094986 | 1094986 | 1094986 | 1094986 | 1094986
2000 | Closed | Outstanding | 0 | 200000 | 1100000 | 1085409 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000 | Closed | Incurred | 0 | 205312.3 | 1106775.76 | 1112062.31 | 1094986 | 1094986 | 1094986 | 1094986 | 1094986 | 1094986 | 1094986 | 1094986
2000 | Open | Paid | 0 | 15092 | 19844 | 38333.87 | 91649.3 | 170295 | 248216.18 | 1743127 | 3353316.91 | 3661925 | 3727811.86 | 3781552
2000 | Open | Outstanding | 1000050 | 998407 | 1480156 | 1461666.13 | 1426098.52 | 2625540 | 2547618.12 | 1052707 | 2874557 | 2567292 | 2501409 | 2447670
2000 | Open | Incurred | 1000050 | 1013499 | 1500000 | 1500000 | 1517747.82 | 2795835 | 2795834.3 | 2795834 | 6227873.91 | 6229217 | 6229220.859999999 | 6229222
2000 | Closed | Paid | 0 | 0 | 50 | 752 | 270742.29 | 325652 | 345662.21 | 345662.21 | 345662.21 | 345662.21 | 345662.21 | 345662.21
2000 | Closed | Outstanding | 0 | 12334 | 12334 | 1151683 | 81692.71 | 26783 | 0 | 0 | 0 | 0 | 0 | 0
2000 | Closed | Incurred | 0 | 12334 | 12384 | 1152435 | 352435 | 352435 | 345662.21 | 345662.21 | 345662.21 | 345662.21 | 345662.21 | 345662.21
2000 | Closed | Paid | 0 | 0 | 1016.87 | 1016.87 | 6933.49 | 7057 | 47272.75 | 47272.75 | 47272.75 | 47272.75 | 47272.75 | 47272.75
2000 | Closed | Outstanding | 988.37 | 988.37 | 15500 | 2000000 | 994083.38 | 993960 | 0 | 0 | 0 | 0 | 0 | 0
2000 | Closed | Incurred | 988.37 | 988.37 | 16516.87 | 2001016.87 | 1001016.87 | 1001017 | 47272.75 | 47272.75 | 47272.75 | 47272.75 | 47272.75 | 47272.75
2000 | Closed | Paid | 0 | 24780.9 | 79396.33 | 108051.5 | 479885.58 | 479885.58 | 479885.58 | 479885.58 | 479885.58 | 479885.58 | 479885.58 | 479885.58
2000 | Closed | Outstanding | 0 | 215501 | 1170604 | 2302429.83 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000 | Closed | Incurred | 0 | 240281.9 | 1250000.33 | 2410481.33 | 479885.58 | 479885.58 | 479885.58 | 479885.58 | 479885.58 | 479885.58 | 479885.58 | 479885.58
2000 | Open | Paid | 0 | 1758 | 8095 | 12697 | 484598 | 516461 | 570171.73 | 577181 | 578562 | 575606 | 578502.2 | 579513
2000 | Open | Outstanding | 0 | 12200 | 750000 | 749436 | 277533 | 986740 | 1286365.55 | 1279358 | 1277977 | 1268801 | 1265904.75 | 1264895
2000 | Open | Incurred | 0 | 13958 | 758095 | 762133 | 762131 | 1503201 | 1856537.28 | 1856539 | 1856539 | 1844407 | 1844406.95 | 1844408
2001 | Closed | Paid | 14654.73 | 30439 | 29688.47 | 89516.88 | 93559 | 93898.91 | 853411.8 | 853411.8 | 853411.8 | 853411.8 | 853411.8
2001 | Closed | Outstanding | 222618 | 659561 | 659561 | 599727.59 | 1407755 | 1407756 | 0 | 0 | 0 | 0 | 0
2001 | Closed | Incurred | 237272.73 | 690000 | 689249.47 | 689244.47 | 1501314 | 1501654.91 | 853411.8 | 853411.8 | 853411.8 | 853411.8 | 853411.8
2001 | Closed | Paid | 1138.98 | 1138.98 | 1762.98 | 12097.97 | 17444 | 17444 | 17443.64 | 17443.64 | 17443.64 | 17443.64 | 17443.64
2001 | Closed | Outstanding | 30009 | 1500000 | 1499376 | 1493308.75 | 1502337 | 1502337 | 0 | 0 | 0 | 0 | 0
2001 | Closed | Incurred | 31147.98 | 1501138.98 | 1501138.98 | 1505406.72 | 1519781 | 1519781 | 17443.64 | 17443.64 | 17443.64 | 17443.64 | 17443.64
2001 | Closed | Paid | 0 | 1064.9 | 10867.3 | 17093.9 | 501586 | 721036.95 | 746283 | 3768846 | 4034398 | 4034398 | 4034398
2001 | Closed | Outstanding | 0 | 3623935 | 3614133 | 3607906.76 | 3149997 | 2940467 | 2915227 | 332828 | 0 | 0 | 0
2001 | Closed | Incurred | 0 | 3624999.9 | 3625000.3 | 3625000.66 | 3651583 | 3661503.95 | 3661510 | 4101674 | 4034398 | 4034398 | 4034398
2001 | Closed | Paid | 0 | 3828 | 29612 | 31676 | 54015 | 708049.5 | 710524.35 | 710524.35 | 710524.35 | 710524.35 | 710524.35
2001 | Closed | Outstanding | 0 | 58634 | 879221 | 877157 | 1327220 | 11234 | 0 | 0 | 0 | 0 | 0
2001 | Closed | Incurred | 0 | 62462 | 908833 | 908833 | 1381235 | 719283.5 | 710524.35 | 710524.35 | 710524.35 | 710524.35 | 710524.35
2001 | Closed | Paid | 0 | 11255 | 26406.13 | 882918.77 | 884698.68 | 884698.68 | 884698.68 | 884698.68 | 884698.68 | 884698.68 | 884698.68
2001 | Closed | Outstanding | 0 | 198477 | 981915.67 | 125403.03 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2001 | Closed | Incurred | 0 | 209732 | 1008321.8 | 1008321.8 | 884698.68 | 884698.68 | 884698.68 | 884698.68 | 884698.68 | 884698.68 | 884698.68
2001 | Closed | Paid | 0 | 4122.51 | 12008.95 | 68198.64 | 92152 | 882574.78 | 882574.78 | 882574.78 | 882574.78 | 882574.78 | 882574.78
2001 | Closed | Outstanding | 1234 | 51202 | 994184.51 | 937993.82 | 921471 | 0 | 0 | 0 | 0 | 0 | 0
2001 | Closed | Incurred | 1234 | 55324.51 | 1006193.46 | 1006192.46 | 1013623 | 882574.78 | 882574.78 | 882574.78 | 882574.78 | 882574.78 | 882574.78
2002 | Closed | Paid | 0 | 1681.55 | 14761.31 | 77746 | 287399.82 | 587291.62 | 587291.62 | 587291.62 | 587291.62 | 587291.62
2002 | Closed | Outstanding | 0 | 999559 | 810238.69 | 747254 | 537602 | 0 | 0 | 0 | 0 | 0
2002 | Closed | Incurred | 0 | 1001240.55 | 825000 | 825000 | 825001.82 | 587291.62 | 587291.62 | 587291.62 | 587291.62 | 587291.62
2002 | Closed | Paid | 0 | 2410 | 2410 | 7234 | 25985.3 | 434141 | 587785 | 612027.39 | 612027.39 | 612027.39
2002 | Closed | Outstanding | 0 | 1247695 | 1247695 | 1248790 | 1231029 | 165861 | 48007 | 0 | 0 | 0
2002 | Closed | Incurred | 0 | 1250105 | 1250105 | 1256024 | 1257014.3 | 600002 | 635792 | 612027.39 | 612027.39 | 612027.39
2002 | Open | Paid | 0 | 0 | 0 | 0 | 1291.88 | 2793 | 3197 | 3196.89 | 3196.89 | 3197
2002 | Open | Outstanding | 0 | 3250000 | 3250000 | 3318799 | 3317508 | 3316007 | 3315603 | 3315603 | 3315603 | 3315603
2002 | Open | Incurred | 0 | 3250000 | 3250000 | 3318799 | 3318799.88 | 3318800 | 3318800 | 3318799.89 | 3318799.89 | 3318800
2002 | Closed | Paid | 0 | 2216.71 | 7633.21 | 61837 | 61978 | 61978 | 61978 | 61978 | 61978 | 61978
2002 | Closed | Outstanding | 0 | 996635.5 | 994219 | 1 | 0 | 0 | 0 | 0 | 0 | 0
2002 | Closed | Incurred | 0 | 998852.21 | 1001852.21 | 61838 | 61978 | 61978 | 61978 | 61978 | 61978 | 61978
2002 | Closed | Paid | 0 | 105789.69 | 155096.21 | 1621504.2 | 1621504.2 | 1621504.2 | 1621504.2 | 1621504.2 | 1621504.2 | 1621504.2
2002 | Closed | Outstanding | 0 | 3904140.56 | 3854834.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2002 | Closed | Incurred | 0 | 4009930.25 | 4009930.25 | 1621504.2 | 1621504.2 | 1621504.2 | 1621504.2 | 1621504.2 | 1621504.2 | 1621504.2
2003 | Closed | Paid | 1500 | 87265.2 | 232533.68 | 342966.75 | 1877238.08 | 1877238.08 | 1877238.08 | 1877238.08 | 1877238.08
2003 | Closed | Outstanding | 20699 | 412734.8 | 267466.32 | 2156284 | 0 | 0 | 0 | 0 | 0
2003 | Closed | Incurred | 22199 | 500000 | 500000 | 2499250.75 | 1877238.08 | 1877238.08 | 1877238.08 | 1877238.08 | 1877238.08
2003 | Open | Paid | 0 | 6156.75 | 8966 | 11405.7 | 35782 | 79002 | 106039.55 | 106029.55 | 117306
2003 | Open | Outstanding | 0 | 1993843.25 | 2028384 | 2025944 | 1980930 | 1958349 | 1931310 | 1931320 | 1920043
2003 | Open | Incurred | 0 | 2000000 | 2037350 | 2037349.7 | 2016712 | 2037351 | 2037349.55 | 2037349.55 | 2037349
2003 | Open | Paid | 0 | 5069.25 | 19972.61 | 41660.75 | 46385 | 58871 | 76948 | 154565.62 | 244246
2003 | Open | Outstanding | 0 | 480056.77 | 461011.68 | 459388.58 | 1553615 | 1541130 | 1380473 | 1302857.71 | 1213181
2003 | Open | Incurred | 0 | 485126.02 | 480984.29 | 501049.33 | 1600000 | 1600001 | 1457421 | 1457423.33 | 1457427
2004 | Closed | Paid | 0 | 138 | 20060 | 143869 | 746207 | 922953.95 | 924774.54 | 924774.54
2004 | Closed | Outstanding | 25000 | 703042 | 683120 | 556130 | 453793 | 0 | 0 | 0
2004 | Closed | Incurred | 25000 | 703180 | 703180 | 699999 | 1200000 | 922953.95 | 924774.54 | 924774.54
2004 | Closed | Paid | 0 | 16083 | 535692.8 | 535692.8 | 535692.8 | 535692.8 | 535692.8 | 535692.8
2004 | Closed | Outstanding | 10997 | 4146388 | 0 | 0 | 0 | 0 | 0 | 0
2004 | Closed | Incurred | 10997 | 4162471 | 535692.8 | 535692.8 | 535692.8 | 535692.8 | 535692.8 | 535692.8
2004 | Closed | Paid | 0 | 7732 | 111857.09 | 111857.09 | 111857.09 | 111857.09 | 111857.09 | 111857.09
2004 | Closed | Outstanding | 0 | 1042517 | 0 | 0 | 0 | 0 | 0 | 0
2004 | Closed | Incurred | 0 | 1050249 | 111857.09 | 111857.09 | 111857.09 | 111857.09 | 111857.09 | 111857.09
2004 | Open | Paid | 0 | 1036.35 | 3619.66 | 25250 | 25250 | 45242 | 47725.81 | 47726
2004 | Open | Outstanding | 0 | 48963.65 | 46381 | 1474750 | 1474337 | 1454756 | 1452274 | 1452274
2004 | Open | Incurred | 0 | 50000 | 50000.66 | 1500000 | 1499587 | 1499998 | 1499999.81 | 1500000
2005 | Closed | Paid | 15057 | 96281.78 | 2060066 | 2077383.76 | 2077384 | 2077384 | 2077384
2005 | Closed | Outstanding | 2786141 | 2704918 | 739938 | 0 | 0 | 0 | 0
2005 | Closed | Incurred | 2801198 | 2801199.78 | 2800004 | 2077383.76 | 2077384 | 2077384 | 2077384
2005 | Closed | Paid | 1524.5 | 1524.5 | 3060 | 5621 | 9910 | 335654 | 343191
2005 | Closed | Outstanding | 19999 | 1098473 | 1096938 | 1094378 | 790091 | 34170 | 0
2005 | Closed | Incurred | 21523.5 | 1099997.5 | 1099998 | 1099999 | 800001 | 369824 | 343191
2005 | Open | Paid | 0 | 0 | 4104 | 4104 | 3633243 | 3873750 | 3633243
2005 | Open | Outstanding | 100000 | 100000 | 3995897 | 3995896 | 366757 | 366757 | 761936
2005 | Open | Incurred | 100000 | 100000 | 4000001 | 4000000 | 4000000 | 4240507 | 4395179
2006 | Closed | Paid | 0 | 38939 | 66279.52 | 71610.4 | 71610.4 | 71610.4
2006 | Closed | Outstanding | 11198 | 2961067 | 1433509 | 0 | 0 | 0
2006 | Closed | Incurred | 11198 | 3000006 | 1499788.52 | 71610.4 | 71610.4 | 71610.4
2006 | Closed | Paid | 0 | 111613 | 818511.27 | 849668.13 | 849668.13 | 849668.13
2006 | Closed | Outstanding | 27393 | 1263389 | 555936 | 0 | 0 | 0
2006 | Closed | Incurred | 27393 | 1375002 | 1374447.27 | 849668.13 | 849668.13 | 849668.13
2006 | Closed | Paid | 0 | 55674 | 96357.49 | 153258 | 1199036 | 1200516
2006 | Closed | Outstanding | 0 | 6498428 | 3457636 | 3125327 | 179553 | 0
2006 | Closed | Incurred | 0 | 6554102 | 3553993.49 | 3278585 | 1378589 | 1200516
2006 | Open | Paid | 0 | 11880 | 60451 | 79955 | 97694 | 130755
2006 | Open | Outstanding | 0 | 1488120 | 1268297 | 1147576 | 1129835 | 1096772
2006 | Open | Incurred | 0 | 1500000 | 1328748 | 1227531 | 1227529 | 1227527
2006 | Open | Paid | 0 | 5581 | 5581 | 5581 | 5581 | 16500
2006 | Open | Outstanding | 0 | 0 | 0 | 0 | 0 | 1483500
2006 | Open | Incurred | 0 | 5581 | 5581 | 5581 | 5581 | 1500000
2007 | Closed | Paid | 0 | 5211 | 102914 | 114020 | 202284
2007 | Closed | Outstanding | 11198 | 994791 | 297087 | 285982 | 0
2007 | Closed | Incurred | 11198 | 1000002 | 400001 | 400002 | 202284
2007 | Open | Paid | 0 | 3671.31 | 20599 | 206456 | 737613
2007 | Open | Outstanding | 42193 | 296329 | 1479402 | 1293548 | 762243
2007 | Open | Incurred | 42193 | 300000.31 | 1500001 | 1500004 | 1499856
2007 | Closed | Paid | 0 | 15415 | 27410 | 70153 | 272107
2007 | Closed | Outstanding | 0 | 13101 | 1221030 | 1178290 | 0
2007 | Closed | Incurred | 0 | 28516 | 1248440 | 1248443 | 272107
2007 | Open | Paid | 0 | 5692 | 5869 | 5869 | 22191
2007 | Open | Outstanding | 0 | 0 | 0 | 2250000 | 2239120
2007 | Open | Incurred | 0 | 5692 | 5869 | 2255869 | 2261311
2007 | Closed | Paid | 0 | 1208 | 54619 | 294924 | 294924
2007 | Closed | Outstanding | 0 | 998792 | 844044 | 0 | 0
2007 | Closed | Incurred | 0 | 1000000 | 898663 | 294924 | 294924
2008 | Open | Paid | 0 | 0 | 0 | 8000
2008 | Open | Outstanding | 0 | 100000 | 100000 | 4416000
2008 | Open | Incurred | 0 | 100000 | 100000 | 4424000
2008 | Open | Paid | 0 | 45459 | 172000 | 569000
2008 | Open | Outstanding | 0 | 2069382 | 1960000 | 2274000
2008 | Open | Incurred | 0 | 2114841 | 2132000 | 2843000
2008 | Closed | Paid | 14824 | 66651 | 77846 | 299902
2008 | Closed | Outstanding | 1685177 | 1482794 | 672154 | 0
2008 | Closed | Incurred | 1700001 | 1549445 | 750000 | 299902
2008 | Open | Paid | 0 | 4072 | 66454.38 | 100373
2008 | Open | Outstanding | 0 | 4850001 | 4786626 | 4752717
2008 | Open | Incurred | 0 | 4854073 | 4853080.38 | 4853090
2009 | Open | Paid | 0 | 6000 | 6000
2009 | Open | Outstanding | 0 | 1012000 | 1012000
2009 | Open | Incurred | 0 | 1018000 | 1018000
2009 | Open | Paid | 0 | 60000 | 88000
2009 | Open | Outstanding | 0 | 2270000 | 2241000
2009 | Open | Incurred | 0 | 2330000 | 2329000
2009 | Closed | Paid | 0 | 18452.1 | 1173866
2009 | Closed | Outstanding | 0 | 2732236 | 0
2009 | Closed | Incurred | 0 | 2750688.1 | 1173866
2010 | Open | Paid | 5000 | 86000
2010 | Open | Outstanding | 705870 | 5952000
2010 | Open | Incurred | 710870 | 6038000
2010 | Open | Paid | 0 | 54000
2010 | Open | Outstanding | 0 | 3768000
2010 | Open | Incurred | 0 | 3822000
2010 | Open | Paid | 0 | 33000
2010 | Open | Outstanding | 0 | 3669000
2010 | Open | Incurred | 0 | 3702000
2011 | Open | Paid | 0
2011 | Open | Outstanding | 4750000
2011 | Open | Incurred | 4750000
2011 | Open | Paid | 4000
2011 | Open | Outstanding | 1371000
2011 | Open | Incurred | 1375000
2011 | Open | Paid | 1000
2011 | Open | Outstanding | 2000000
2011 | Open | Incurred | 2001000
2011 | Open | Paid | 0
2011 | Open | Outstanding | 1750000
2011 | Open | Incurred | 1750000