Spreadsheet: 105050d1302532054-how-to-add-extra-criteria-to-sumproduct-formula-tstii
Sheet: All

City | ARMS Flag | Will Loan Drop? |  | Account Number | Borrower | Current Balance | Days P/D | Maturity Date |  |  | Amt that will drop | Amt that will not drop
[NAME] |  |  |  |  |  | 12499.46 | 48 | 2013-06-05 00:00:00 | 1 | 0 | 12499.46
[NAME] | ARMS |  |  |  |  | 27987.02 | 223 | 2010-08-17 00:00:00 | 1 | 0 | 27987.02
[NAME] | ARMS |  |  |  |  | 53010.77 | 62 | 2013-04-25 00:00:00 | 1 | 0 | 53010.77
[NAME] |  |  |  |  |  | 10000 | 66 | 2011-01-21 00:00:00 | 1 | 0 | 10000
[NAME] |  |  |  |  |  | 637803.37 | 30 | 2011-03-01 00:00:00 | 1 | 0 | 637803.37
[NAME] |  |  |  |  |  | 33330.59 | 54 | 2015-12-02 00:00:00 | 0 | 1 |  | 33330.59
[NAME] |  |  |  |  |  | 65000 | 46 | 2011-02-10 00:00:00 | 0 | 1 |  | 65000
[NAME] |  |  |  |  |  | 10878.48 | 46 | 2011-03-15 00:00:00 | 0 | 1 |  | 10878.48
[NAME] |  |  |  |  |  | 12572.37 | 41 | 2013-10-15 00:00:00 | 0 | 1 |  | 12572.37
[NAME] |  |  |  |  |  | 74137.18 | 39 | 2011-02-14 00:00:00 | 1 | 0 | 74137.18
[NAME] |  |  |  |  |  | 34406.54 | 65 | 2011-01-22 00:00:00 | 1 | 0 | 34406.54
[NAME] |  |  |  |  |  | 16666.66 | 40 | 2011-02-16 00:00:00 | 1 | 0 | 16666.66 |  |  |  |  | 2011-03-31 00:00:00
[NAME] |  |  |  |  |  | 161600 | 42 | 2011-02-14 00:00:00 | 1 | 0 | 161600 |  |  |  |  | [NAME] | Brownsville | Corpus Christi | East Texas | Harlingen | Houston | International | Laredo | [NAME] | Mission | Weslaco
[NAME] |  |  |  |  |  | 19996 | 31 | 2011-02-25 00:00:00 | 1 | 0 | 19996 |  |  | Total amt. that will drop |  | 1048107 | 9384316.65 | 802871.12 | 2968368.06 | 374436.94 | 4280775.850000001 | 2772177.17 | 8085751.859999999 | 9323143.879999999 | 11562099.05 | 2465118.42
[NAME] |  |  |  |  |  | 100000 | 113 | 2010-12-05 00:00:00 | 0 | 1 |  | 100000 |  | Total amt. that will not drop |  | 5002241.93 | 3491502.3 | 769646.7299999999 | 2430631.88 | 5541152.010000001 | 13247414.04 | 995194.4299999999 | 9418373.73 | 6118496.46 | 4658231.51 | 526303.86
[NAME] |  |  |  |  |  | 179903.42 | 86 | 2011-01-01 00:00:00 | 0 | 1 |  | 179903.42 |  | ARMS Active |  | 24131432.34 | 0
[NAME] | ARMS |  |  |  |  | 277377.87 | 36 | 2015-02-20 00:00:00 | 0 | 1 |  | 277377.87 |  | ARMS Matured
[NAME] |  |  |  |  |  | 71097.34 | 48 | 2011-02-08 00:00:00 | 0 | 1 |  | 71097.34 |  | Active
[NAME] |  |  |  |  |  | 73389.28 | 41 | 2011-02-15 00:00:00 | 0 | 1 |  | 73389.28 |  | Matured
[NAME] |  |  |  |  |  | 1678692.58 | 28 | 2011-02-28 00:00:00 | 0 | 1 |  | 1678692.58
[NAME] |  |  |  |  |  | 2500000 | 30 | 2011-02-26 00:00:00 | 0 | 1 |  | 2500000
East Texas |  |  |  |  |  | 38099.21 | 96 | 2015-02-22 00:00:00 | 0 | 1 |  | 38099.21
East Texas |  |  |  |  |  | 48220.34 | 87 | 2012-11-30 00:00:00 | 1 | 0 | 48220.34
East Texas |  |  |  |  |  | 18367.24 | 71 | 2014-07-13 00:00:00 | 1 | 0 | 18367.24
East Texas |  |  |  |  |  | 17599.27 | 25 | 2021-03-28 00:00:00 | 1 | 0 | 17599.27
East Texas |  |  |  |  |  | 8534.69 | 26 | 2012-08-27 00:00:00 | 1 | 0 | 8534.69
East Texas |  |  |  |  |  | 57459.79 | 28 | 2012-05-23 00:00:00 | 1 | 0 | 57459.79
East Texas |  |  |  |  |  | 624157.94 | 41 | 2018-02-15 00:00:00 | 1 | 0 | 624157.94
East Texas |  |  |  |  |  | 100000 | 55 | 2011-02-01 00:00:00 | 1 | 0 | 100000
East Texas |  |  |  |  |  | 791722.34 | 34 | 2012-07-22 00:00:00 | 0 | 1 |  | 791722.34
East Texas |  |  |  |  |  | 197474.72 | 41 | 2011-02-12 00:00:00 | 0 | 1 |  | 197474.72
East Texas | ARMS |  |  |  |  | 411996.44 | 41 | 2015-03-15 00:00:00 | 0 | 1 |  | 411996.44
East Texas | ARMS |  |  |  |  | 46673.8 | 40 | 2013-08-16 00:00:00 | 0 | 1 |  | 46673.8
East Texas |  |  |  |  |  | 199263.96 | 96 | 2010-12-22 00:00:00 | 0 | 1 |  | 199263.96
East Texas |  |  |  |  |  | 68188.54 | 25 | 2016-01-28 00:00:00 | 0 | 1 |  | 68188.54
East Texas | ARMS |  |  |  |  | 677212.87 | 31 | 2020-05-25 00:00:00 | 0 | 1 |  | 677212.87
East Texas | ARMS |  |  |  |  | 1526791.39 | 28 | 2011-02-28 00:00:00 | 1 | 0 | 1526791.39
East Texas | ARMS |  |  |  |  | 231042.1 | 48 | 2014-07-05 00:00:00 | 1 | 0 | 231042.1
East Texas |  |  |  |  |  | 314466.32 | 25 | 2012-07-29 00:00:00 | 1 | 0 | 314466.32
East Texas |  |  |  |  |  | 19290.18 | 28 | 2011-04-26 00:00:00 | 1 | 0 | 19290.18
East Texas |  |  |  |  |  | 2438.8 | 35 | 2011-12-18 00:00:00 | 1 | 0 | 2438.8
Houston |  |  |  |  |  | 315902.76 | 135 | 2010-11-13 00:00:00 | 0 | 1 |  | 315902.76
Houston |  |  |  |  |  | 59259.64 | 52 | 2011-02-04 00:00:00 | 0 | 1 |  | 59259.64
Houston | ARMS |  |  |  |  | 7712679.22 | 30 | 2011-02-26 00:00:00 | 0 | 1 |  | 7712679.22
Houston | ARMS |  |  |  |  | 1062498.67 | 86 | 2011-01-01 00:00:00 | 0 | 1 |  | 1062498.67
Houston | ARMS |  |  |  |  | 21259.6 | 28 | 2022-11-28 00:00:00 | 0 | 1 |  | 21259.6
Houston | ARMS |  |  |  |  | 198496.45 | 28 | 2013-03-31 00:00:00 | 1 | 0 | 198496.45
Houston | ARMS |  |  |  |  | 76372.73 | 164 | 2010-10-15 00:00:00 | 1 | 0 | 76372.73
Houston | ARMS |  |  |  |  | 1188837.77 | 55 | 2011-02-01 00:00:00 | 1 | 0 | 1188837.77
Houston | ARMS |  |  |  |  | 352162.33 | 55 | 2011-02-01 00:00:00 | 1 | 0 | 352162.33
Houston | ARMS |  |  |  |  | 1840598 | 28 | 2011-03-01 00:00:00 | 1 | 0 | 1840598
Houston |  |  |  |  |  | 11605.95 | 25 | 2011-06-30 00:00:00 | 1 | 0 | 11605.95
Houston | ARMS |  |  |  |  | 622114 | 208 | 2010-09-01 00:00:00 | 0 | 1 |  | 622114
Houston | ARMS |  |  |  |  | 1581800.52 | 84 | 2010-12-31 00:00:00 | 0 | 1 |  | 1581800.52
Houston |  |  |  |  |  | 157952.62 | 46 | 2011-02-10 00:00:00 | 1 | 0 | 157952.62
Houston |  |  |  |  |  | 776827.83 | 55 | 2011-10-01 00:00:00 | 0 | 1 |  | 776827.83
Houston |  |  |  |  |  | 296917 | 55 | 2011-10-01 00:00:00 | 0 | 1 |  | 296917
Houston |  |  |  |  |  | 157250 | 55 | 2011-02-01 00:00:00 | 0 | 1 |  | 157250
Houston |  |  |  |  |  | 157250 | 55 | 2011-02-01 00:00:00 | 1 | 0 | 157250
Houston |  |  |  |  |  | 297500 | 55 | 2011-02-01 00:00:00 | 1 | 0 | 297500
Houston |  |  |  |  |  | 184206.14 | 83 | 2011-01-04 00:00:00 | 0 | 1 |  | 184206.14
Houston |  |  |  |  |  | 300000 | 39 | 2011-02-17 00:00:00 | 0 | 1 |  | 300000
Houston | ARMS |  |  |  |  | 156698.66 | 121 | 2010-11-24 00:00:00 | 0 | 1 |  | 156698.66
International |  |  |  |  |  | 66772.67 | 40 | 2011-02-13 00:00:00 | 1 | 0 | 66772.67
International | ARMS |  |  |  |  | 479857.48 | 32 | 2011-11-24 00:00:00 | 1 | 0 | 479857.48
International | ARMS |  |  |  |  | 2154.27 | 31 | 2011-05-25 00:00:00 | 1 | 0 | 2154.27
International | ARMS |  |  |  |  | 350000 | 45 | 2015-12-11 00:00:00 | 0 | 1 |  | 350000
International | ARMS |  |  |  |  | 244101.24 | 41 | 2011-02-15 00:00:00 | 1 | 0 | 244101.24
International | ARMS |  |  |  |  | 22652.22 | 30 | 2015-09-26 00:00:00 | 0 | 1 |  | 22652.22
International |  |  |  |  |  | 85693.4 | 44 | 2011-07-12 00:00:00 | 1 | 0 | 85693.4
International |  |  |  |  |  | 101073.04 | 49 | 2012-06-07 00:00:00 | 0 | 1 |  | 101073.04
International |  |  |  |  |  | 521469.17 | 68 | 2022-11-19 00:00:00 | 0 | 1 |  | 521469.17
International |  |  |  |  |  | 925725.79 | 54 | 2017-03-02 00:00:00 | 1 | 0 | 925725.79
International |  |  |  |  |  | 222916.71 | 32 | 2014-06-24 00:00:00 | 1 | 0 | 222916.71
International |  |  |  |  |  | 260000 | 31 | 2013-03-25 00:00:00 | 1 | 0 | 260000
International |  |  |  |  |  | 120271.97 | 26 | 2021-11-27 00:00:00 | 1 | 0 | 120271.97
International |  |  |  |  |  | 33483.93 | 62 | 2011-01-22 00:00:00 | 1 | 0 | 33483.93
International |  |  |  |  |  | 190659.69 | 52 | 2017-10-04 00:00:00 | 1 | 0 | 190659.69
International |  |  |  |  |  | 29237.91 | 31 | 2016-04-25 00:00:00 | 1 | 0 | 29237.91
International |  |  |  |  |  | 29560.65 | 41 | 2013-04-15 00:00:00 | 1 | 0 | 29560.65
International |  |  |  |  |  | 15286.28 | 76 | 2011-01-08 00:00:00 | 1 | 0 | 15286.28
International |  |  |  |  |  | 66455.18 | 86 | 2020-11-01 00:00:00 | 1 | 0 | 66455.18
Laredo | ARMS |  |  |  |  | 83001.65 | 42 | 2023-05-14 00:00:00 | 1 | 0 | 83001.65
Laredo | ARMS |  |  |  |  | 222378.58 | 61 | 2017-12-26 00:00:00 | 1 | 0 | 222378.58
Laredo | ARMS |  |  |  |  | 15668.88 | 109 | 2015-12-09 00:00:00 | 0 | 1 |  | 15668.88
Laredo |  |  |  |  |  | 162030 | 37 | 2011-02-19 00:00:00 | 1 | 0 | 162030
Laredo |  |  |  |  |  | 511043.41 | 116 | 2020-05-26 00:00:00 | 0 | 1 |  | 511043.41
Laredo |  |  |  |  |  | 49462.15 | 28 | 2014-01-30 00:00:00 | 0 | 1 |  | 49462.15
Laredo |  |  |  |  |  | 30312.46 | 41 | 2014-09-15 00:00:00 | 0 | 1 |  | 30312.46
Laredo |  |  |  |  |  | 477681.34 | 34 | 2011-02-22 00:00:00 | 0 | 1 |  | 477681.34
Laredo |  |  |  |  |  | 80873.15 | 25 | 2014-04-30 00:00:00 | 0 | 1 |  | 80873.15
Laredo |  |  |  |  |  | 1626945.55 | 30 | 2024-06-23 00:00:00 | 0 | 1 |  | 1626945.55
Laredo |  |  |  |  |  | 1786691.66 | 82 | 2028-06-04 00:00:00 | 0 | 1 |  | 1786691.66
Laredo |  |  |  |  |  | 3722.73 | 46 | 2011-11-07 00:00:00 | 0 | 1 |  | 3722.73
Laredo |  |  |  |  |  | 22625.52 | 54 | 2013-08-30 00:00:00 | 0 | 1 |  | 22625.52
Laredo |  |  |  |  |  | 83753.7 | 46 | 2023-11-10 00:00:00 | 0 | 1 |  | 83753.7
Laredo |  |  |  |  |  | 200000 | 40 | 2011-02-13 00:00:00 | 0 | 1 |  | 200000
Laredo | ARMS |  |  |  |  | 1314557.33 | 40 | 2012-12-22 00:00:00 | 0 | 1 |  | 1314557.33
Laredo | ARMS |  |  |  |  | 9845.59 | 63 | 2011-02-24 00:00:00 | 0 | 1 |  | 9845.59
Laredo | ARMS |  |  |  |  | 787029.36 | 82 | 2011-07-05 00:00:00 | 1 | 0 | 787029.36
Laredo | ARMS |  |  |  |  | 63646.64 | 82 | 2011-07-05 00:00:00 | 1 | 0 | 63646.64
Laredo | ARMS |  |  |  |  | 3210835.12 | 51 | 2029-02-05 00:00:00 | 1 | 0 | 3210835.12
Laredo | ARMS |  |  |  |  | 2101.72 | 55 | 2011-02-01 00:00:00 | 1 | 0 | 2101.72
Laredo | ARMS |  |  |  |  | 410324.59 | 39 | 2011-02-17 00:00:00 | 1 | 0 | 410324.59
Laredo | ARMS |  |  |  |  | 59981.08 | 36 | 2014-02-20 00:00:00 | 1 | 0 | 59981.08
Laredo | ARMS |  |  |  |  | 200723.22 | 28 | 2023-08-28 00:00:00 | 0 | 1 |  | 200723.22
Laredo | ARMS |  |  |  |  | 51634.6 | 55 | 2016-05-01 00:00:00 | 0 | 1 |  | 51634.6
Laredo | ARMS |  |  |  |  | 161971.48 | 78 | 2011-01-09 00:00:00 | 0 | 1 |  | 161971.48
Laredo | ARMS |  |  |  |  | 5685.57 | 46 | 2013-10-10 00:00:00 | 0 | 1 |  | 5685.57
Laredo | ARMS |  |  |  |  | 231367.02 | 53 | 2035-05-01 00:00:00 | 1 | 0 | 231367.02
Laredo | ARMS |  |  |  |  | 76845.93 | 84 | 2015-12-03 00:00:00 | 1 | 0 | 76845.93
Laredo | ARMS |  |  |  |  | 144180.88 | 84 | 2015-12-03 00:00:00 | 1 | 0 | 144180.88
Laredo | ARMS |  |  |  |  | 57567.91 | 84 | 2015-12-03 00:00:00 | 0 | 1 |  | 57567.91
Laredo | ARMS |  |  |  |  | 6037.6 | 113 | 2012-02-05 00:00:00 | 0 | 1 |  | 6037.6
Laredo | ARMS |  |  |  |  | 19264 | 103 | 2010-12-15 00:00:00 | 0 | 1 |  | 19264
Laredo | ARMS |  |  |  |  | 183479.11 | 28 | 2022-02-28 00:00:00 | 1 | 0 | 183479.11
Laredo | ARMS |  |  |  |  | 2490 | 44 | 2011-08-12 00:00:00 | 1 | 0 | 2490
Laredo | ARMS |  |  |  |  | 23910.7 | 145 | 2011-10-03 00:00:00 | 0 | 1 |  | 23910.7
Laredo | ARMS |  |  |  |  | 41789.68 | 104 | 2021-12-14 00:00:00 | 0 | 1 |  | 41789.68
Laredo |  |  |  |  |  | 149544.79 | 73 | 2011-01-14 00:00:00 | 0 | 1 |  | 149544.79
Laredo |  |  |  |  |  | 91906.56 | 82 | 2011-01-05 00:00:00 | 0 | 1 |  | 91906.56
Laredo |  |  |  |  |  | 4982.45 | 33 | 2011-11-20 00:00:00 | 1 | 0 | 4982.45
Laredo |  |  |  |  |  | 42295.47 | 53 | 2027-09-01 00:00:00 | 1 | 0 | 42295.47
Laredo |  |  |  |  |  | 60185.21 | 55 | 2011-02-01 00:00:00 | 0 | 1 |  | 60185.21
Laredo | ARMS |  |  |  |  | 1000000 | 171 | 2010-10-05 00:00:00 | 0 | 1 |  | 1000000
Laredo |  |  |  |  |  | 247000 | 62 | 2011-01-25 00:00:00 | 1 | 0 | 247000
Laredo |  |  |  |  |  | 1963483.02 | 37 | 2011-02-19 00:00:00 | 1 | 0 | 1963483.02
Laredo |  |  |  |  |  | 18169.74 | 54 | 2011-08-30 00:00:00 | 1 | 0 | 18169.74
Laredo |  |  |  |  |  | 100345.95 | 46 | 2011-02-10 00:00:00 | 0 | 1 |  | 100345.95
Laredo |  |  |  |  |  | 289244 | 49 | 2013-08-07 00:00:00 | 0 | 1 |  | 289244
Laredo |  |  |  |  |  | 135729.13 | 80 | 2026-11-07 00:00:00 | 0 | 1 |  | 135729.13
Laredo |  |  |  |  |  | 80970.39 | 74 | 2012-12-21 00:00:00 | 0 | 1 |  | 80970.39
Laredo |  |  |  |  |  | 24509.59 | 26 | 2015-08-27 00:00:00 | 0 | 1 |  | 24509.59
Laredo |  |  |  |  |  | 43921.68 | 31 | 2019-01-25 00:00:00 | 1 | 0 | 43921.68
Laredo |  |  |  |  |  | 41204.65 | 41 | 2017-08-15 00:00:00 | 0 | 1 |  | 41204.65
Laredo |  |  |  |  |  | 38228.04 | 28 | 2015-08-28 00:00:00 | 1 | 0 | 38228.04
Laredo |  |  |  |  |  | 149047.65 | 30 | 2014-06-26 00:00:00 | 0 | 1 |  | 149047.65
Laredo |  |  |  |  |  | 16517.92 | 36 | 2013-07-20 00:00:00 | 1 | 0 | 16517.92
Laredo |  |  |  |  |  | 19631.95 | 28 | 2015-09-25 00:00:00 | 0 | 1 |  | 19631.95
Laredo |  |  |  |  |  | 724.25 | 32 | 2011-04-21 00:00:00 | 1 | 0 | 724.25
Laredo |  |  |  |  |  | 15000 | 55 | 2011-05-01 00:00:00 | 0 | 1 |  | 15000
Laredo |  |  |  |  |  | 65000 | 36 | 2011-02-20 00:00:00 | 1 | 0 | 65000
Laredo |  |  |  |  |  | 461450.73 | 46 | 2012-10-10 00:00:00 | 0 | 1 |  | 461450.73
Laredo |  |  |  |  |  | 5737.61 | 100 | 2011-08-15 00:00:00 | 1 | 0 | 5737.61
Laredo |  |  |  |  |  | 17834.9 | 41 | 2017-02-12 00:00:00 | 0 | 1 |  | 17834.9
Brownsville |  |  |  |  |  | 458310.31 | 51 | 2011-11-05 00:00:00 | 0 | 1 |  | 458310.31
Brownsville | ARMS |  |  |  |  | 269827.92 | 96 | 2010-12-22 00:00:00 | 0 | 1 |  | 269827.92
Brownsville | ARMS |  |  |  |  | 36451.06 | 35 | 2013-12-21 00:00:00 | 1 | 0 | 36451.06
Brownsville |  |  |  |  |  | 1662634.57 | 54 | 2011-02-02 00:00:00 | 1 | 0 | 1662634.57
Brownsville |  |  |  |  |  | 251010.92 | 34 | 2011-02-22 00:00:00 | 1 | 0 | 251010.92
Brownsville |  |  |  |  |  | 40776.26 | 28 | 2011-07-31 00:00:00 | 0 | 1 |  | 40776.26
Brownsville |  |  |  |  |  | 50801.17 | 32 | 2014-04-24 00:00:00 | 0 | 1 |  | 50801.17
Brownsville |  |  |  |  |  | 12537.03 | 31 | 2011-06-25 00:00:00 | 0 | 1 |  | 12537.03
Brownsville |  |  |  |  |  | 23872.34 | 31 | 2012-09-25 00:00:00 | 0 | 1 |  | 23872.34
Brownsville |  |  |  |  |  | 8954.91 | 31 | 2014-06-25 00:00:00 | 1 | 0 | 8954.91
Brownsville |  |  |  |  |  | 9558.9 | 31 | 2016-06-25 00:00:00 | 0 | 1 |  | 9558.9
Brownsville |  |  |  |  |  | 19487.36 | 31 | 2016-08-25 00:00:00 | 1 | 0 | 19487.36
Brownsville |  |  |  |  |  | 143521.2 | 31 | 2017-06-25 00:00:00 | 0 | 1 |  | 143521.2
Brownsville |  |  |  |  |  | 48588.04 | 31 | 2017-06-25 00:00:00 | 1 | 0 | 48588.04
Brownsville |  |  |  |  |  | 23088.29 | 28 | 2017-06-29 00:00:00 | 0 | 1 |  | 23088.29
Brownsville |  |  |  |  |  | 173083.19 | 44 | 2017-11-12 00:00:00 | 1 | 0 | 173083.19
Brownsville |  |  |  |  |  | 263109.99 | 44 | 2018-06-12 00:00:00 | 1 | 0 | 263109.99
Brownsville |  |  |  |  |  | 446208.61 | 44 | 2018-06-12 00:00:00 | 0 | 1 |  | 446208.61
Brownsville |  |  |  |  |  | 257106.35 | 28 | 2019-04-30 00:00:00 | 0 | 1 |  | 257106.35
Brownsville |  |  |  |  |  | 296327.24 | 38 | 2019-06-18 00:00:00 | 0 | 1 |  | 296327.24
Brownsville |  |  |  |  |  | 161478.07 | 46 | 2020-11-10 00:00:00 | 0 | 1 |  | 161478.07
Brownsville |  |  |  |  |  | 66605.01 | 34 | 2014-05-22 00:00:00 | 0 | 1 |  | 66605.01
Brownsville |  |  |  |  |  | 923545.25 | 103 | 2013-10-10 00:00:00 | 0 | 1 |  | 923545.25
Brownsville |  |  |  |  |  | 2000 | 420 | 2014-07-12 00:00:00 | 0 | 1 |  | 2000
Brownsville |  |  |  |  |  | 140970.3 | 86 | 2011-01-01 00:00:00 | 0 | 1 |  | 140970.3
Brownsville |  |  |  |  |  | 64968.05 | 40 | 2011-02-16 00:00:00 | 0 | 1 |  | 64968.05
Brownsville |  |  |  |  |  | 100000 | 48 | 2011-02-08 00:00:00 | 0 | 1 |  | 100000
Brownsville |  |  |  |  |  | 90000 | 37 | 2011-02-19 00:00:00 | 1 | 0 | 90000
Brownsville |  |  |  |  |  | 164896.31 | 28 | 2011-02-28 00:00:00 | 1 | 0 | 164896.31
Brownsville | ARMS |  |  |  |  | 824078.95 | 96 | 2010-12-22 00:00:00 | 1 | 0 | 824078.95
Brownsville | ARMS |  |  |  |  | 4824030.3 | 96 | 2010-12-22 00:00:00 | 1 | 0 | 4824030.3
Brownsville |  |  |  |  |  | 857946.05 | 96 | 2010-12-22 00:00:00 | 1 | 0 | 857946.05
Brownsville |  |  |  |  |  | 160045 | 72 | 2011-01-15 00:00:00 | 1 | 0 | 160045
Harlingen | ARMS |  |  |  |  | 309487.45 | 34 | 2012-04-22 00:00:00 | 0 | 1 |  | 309487.45
Harlingen |  |  |  |  |  | 30000 | 28 | 2011-07-30 00:00:00 | 0 | 1 |  | 30000
Harlingen |  |  |  |  |  | 3861610.08 | 54 | 2011-02-02 00:00:00 | 0 | 1 |  | 3861610.08
Harlingen |  |  |  |  |  | 5284.92 | 36 | 2011-02-20 00:00:00 | 0 | 1 |  | 5284.92
Harlingen |  |  |  |  |  | 162000 | 41 | 2011-02-15 00:00:00 | 0 | 1 |  | 162000
Harlingen |  |  |  |  |  | 136934.05 | 100 | 2010-12-15 00:00:00 | 1 | 0 | 136934.05
Harlingen |  |  |  |  |  | 237502.89 | 100 | 2010-12-15 00:00:00 | 1 | 0 | 237502.89
Harlingen |  |  |  |  |  | 1002241.94 | 25 | 2012-04-28 00:00:00 | 0 | 1 |  | 1002241.94
Harlingen |  |  |  |  |  | 170527.62 | 50 | 2011-02-06 00:00:00 | 0 | 1 |  | 170527.62
Corpus Christi |  |  |  |  |  | 8518.84 | 38 | 2011-02-18 00:00:00 | 1 | 0 | 8518.84
Corpus Christi |  |  |  |  |  | 425000 | 51 | 2011-02-05 00:00:00 | 1 | 0 | 425000
Corpus Christi |  |  |  |  |  | 12710.87 | 33 | 2011-08-23 00:00:00 | 1 | 0 | 12710.87
Corpus Christi |  |  |  |  |  | 295000 | 33 | 2011-02-23 00:00:00 | 0 | 1 |  | 295000
Corpus Christi |  |  |  |  |  | 1761.87 | 31 | 2011-07-22 00:00:00 | 0 | 1 |  | 1761.87
Corpus Christi |  |  |  |  |  | 46078.91 | 25 | 2013-11-30 00:00:00 | 1 | 0 | 46078.91
Corpus Christi |  |  |  |  |  | 114249.92 | 97 | 2017-06-18 00:00:00 | 0 | 1 |  | 114249.92
Corpus Christi | ARMS |  |  |  |  | 148099.91 | 62 | 2012-05-25 00:00:00 | 0 | 1 |  | 148099.91
Corpus Christi | ARMS |  |  |  |  | 60126.53 | 72 | 2018-02-15 00:00:00 | 0 | 1 |  | 60126.53
Corpus Christi | ARMS |  |  |  |  | 35463.48 | 61 | 2018-06-26 00:00:00 | 0 | 1 |  | 35463.48
Corpus Christi | ARMS |  |  |  |  | 8085.52 | 29 | 2015-05-24 00:00:00 | 0 | 1 |  | 8085.52
Corpus Christi | ARMS |  |  |  |  | 193888.05 | 32 | 2021-07-21 00:00:00 | 1 | 0 | 193888.05
Corpus Christi | ARMS |  |  |  |  | 44583.27 | 50 | 2012-06-06 00:00:00 | 1 | 0 | 44583.27
Corpus Christi | ARMS |  |  |  |  | 25325.42 | 28 | 2014-01-28 00:00:00 | 1 | 0 | 25325.42
Corpus Christi |  |  |  |  |  | 67216.43 | 105 | 2017-05-10 00:00:00 | 0 | 1 |  | 67216.43
Corpus Christi |  |  |  |  |  | 46765.76 | 28 | 2015-09-29 00:00:00 | 1 | 0 | 46765.76
Corpus Christi |  |  |  |  |  | 39643.07 | 78 | 2011-01-07 00:00:00 | 0 | 1 |  | 39643.07
[NAME] |  |  |  |  |  | 77808.72 | 53 | 2011-02-03 00:00:00 | 1 | 0 | 77808.72
[NAME] |  |  |  |  |  | 167047.31 | 63 | 2011-01-24 00:00:00 | 0 | 1 |  | 167047.31
[NAME] |  |  |  |  |  | 128282.3 | 37 | 2011-02-19 00:00:00 | 1 | 0 | 128282.3
[NAME] |  |  |  |  |  | 183079.18 | 34 | 2015-02-22 00:00:00 | 0 | 1 |  | 183079.18
[NAME] |  |  |  |  |  | 121977.26 | 50 | 2011-02-03 00:00:00 | 1 | 0 | 121977.26
[NAME] |  |  |  |  |  | 46775.49 | 28 | 2011-10-28 00:00:00 | 0 | 1 |  | 46775.49
[NAME] |  |  |  |  |  | 12271.23 | 51 | 2012-12-02 00:00:00 | 1 | 0 | 12271.23
[NAME] |  |  |  |  |  | 6069.05 | 41 | 2013-12-15 00:00:00 | 0 | 1 |  | 6069.05
[NAME] |  |  |  |  |  | 4006.61 | 57 | 2012-03-30 00:00:00 | 0 | 1 |  | 4006.61
[NAME] |  |  |  |  |  | 17100.7 | 25 | 2012-01-31 00:00:00 | 0 | 1 |  | 17100.7
[NAME] |  |  |  |  |  | 352305.42 | 71 | 2011-08-13 00:00:00 | 0 | 1 |  | 352305.42
[NAME] |  |  |  |  |  | 9613.83 | 29 | 2012-08-27 00:00:00 | 0 | 1 |  | 9613.83
[NAME] | ARMS |  |  |  |  | 100815.5 | 100 | 2011-09-15 00:00:00 | 0 | 1 |  | 100815.5
[NAME] | ARMS |  |  |  |  | 2200000 | 51 | 2011-02-05 00:00:00 | 0 | 1 |  | 2200000
[NAME] | ARMS |  |  |  |  | 309606.43 | 44 | 2017-01-12 00:00:00 | 0 | 1 |  | 309606.43
[NAME] | ARMS |  |  |  |  | 369803.01 | 73 | 2011-01-14 00:00:00 | 1 | 0 | 369803.01
[NAME] | ARMS |  |  |  |  | 61142.2 | 41 | 2011-02-15 00:00:00 | 1 | 0 | 61142.2
[NAME] | ARMS |  |  |  |  | 3193.65 | 56 | 2011-08-30 00:00:00 | 1 | 0 | 3193.65
[NAME] | ARMS |  |  |  |  | 3604.14 | 56 | 2011-08-30 00:00:00 | 1 | 0 | 3604.14
[NAME] | ARMS |  |  |  |  | 457840.11 | 28 | 2012-03-29 00:00:00 | 1 | 0 | 457840.11
[NAME] | ARMS |  |  |  |  | 5492.38 | 44 | 2012-01-09 00:00:00 | 1 | 0 | 5492.38
[NAME] | ARMS |  |  |  |  | 247277.6 | 38 | 2025-06-18 00:00:00 | 1 | 0 | 247277.6
[NAME] | ARMS |  |  |  |  | 306136.04 | 94 | 2010-12-24 00:00:00 | 1 | 0 | 306136.04
[NAME] |  |  |  |  |  | 105126.39 | 63 | 2011-01-24 00:00:00 | 1 | 0 | 105126.39
[NAME] | ARMS |  |  |  |  | 95300.38 | 36 | 2011-11-20 00:00:00 | 0 | 1 |  | 95300.38
[NAME] | ARMS |  |  |  |  | 602413.63 | 32 | 2012-03-24 00:00:00 | 0 | 1 |  | 602413.63
[NAME] | ARMS |  |  |  |  | 9465.48 | 48 | 2011-06-08 00:00:00 | 0 | 1 |  | 9465.48
[NAME] | ARMS |  |  |  |  | 618848.98 | 41 | 2015-02-15 00:00:00 | 0 | 1 |  | 618848.98
[NAME] |  |  |  |  |  | 484972.98 | 82 | 2011-01-05 00:00:00 | 0 | 1 |  | 484972.98
[NAME] |  |  |  |  |  | 500000 | 56 | 2011-01-31 00:00:00 | 0 | 1 |  | 500000
[NAME] |  |  |  |  |  | 191460.47 | 43 | 2011-02-13 00:00:00 | 0 | 1 |  | 191460.47
[NAME] |  |  |  |  |  | 219615.02 | 41 | 2013-06-16 00:00:00 | 0 | 1 |  | 219615.02
[NAME] |  |  |  |  |  | 369772.02 | 56 | 2011-01-28 00:00:00 | 1 | 0 | 369772.02
[NAME] |  |  |  |  |  | 237805.94 | 39 | 2014-02-14 00:00:00 | 1 | 0 | 237805.94
[NAME] |  |  |  |  |  | 370134.72 | 33 | 2011-09-03 00:00:00 | 1 | 0 | 370134.72
[NAME] |  |  |  |  |  | 6442589.92 | 41 | 2011-02-15 00:00:00 | 1 | 0 | 6442589.92
[NAME] |  |  |  |  |  | 2886.25 | 79 | 2011-04-05 00:00:00 | 1 | 0 | 2886.25
Weslaco | ARMS |  |  |  |  | 419946 | 28 | 2011-02-28 00:00:00 | 1 | 0 | 419946
Weslaco | ARMS |  |  |  |  | 66000 | 103 | 2011-03-15 00:00:00 | 1 | 0 | 66000
Weslaco | ARMS |  |  |  |  | 138606.4 | 95 | 2014-03-23 00:00:00 | 1 | 0 | 138606.4
Weslaco |  |  |  |  |  | 7745.31 | 32 | 2011-09-24 00:00:00 | 1 | 0 | 7745.31
Weslaco |  |  |  |  |  | 86542.69 | 30 | 2012-01-26 00:00:00 | 1 | 0 | 86542.69
Weslaco |  |  |  |  |  | 1746278.02 | 36 | 2014-07-20 00:00:00 | 1 | 0 | 1746278.02
Weslaco |  |  |  |  |  | 101071.46 | 30 | 2011-12-28 00:00:00 | 0 | 1 |  | 101071.46
Weslaco |  |  |  |  |  | 24331.36 | 28 | 9999-12-31 00:00:00 | 0 | 1 |  | 24331.36
Weslaco |  |  |  |  |  | 447.52 | 27 | 2011-04-26 00:00:00 | 0 | 1 |  | 447.52
Weslaco |  |  |  |  |  | 16332.01 | 68 | 2011-03-16 00:00:00 | 0 | 1 |  | 16332.01
Weslaco |  |  |  |  |  | 48886.1 | 36 | 2015-11-17 00:00:00 | 0 | 1 |  | 48886.1
Weslaco |  |  |  |  |  | 267318.67 | 59 | 2011-02-28 00:00:00 | 0 | 1 |  | 267318.67
Weslaco |  |  |  |  |  | 18374.26 | 35 | 2012-07-21 00:00:00 | 0 | 1 |  | 18374.26
Weslaco |  |  |  |  |  | 49542.48 | 61 | 2017-07-23 00:00:00 | 0 | 1 |  | 49542.48
Mission | ARMS |  |  |  |  | 266546.42 | 209 | 2010-08-31 00:00:00 | 1 | 0 | 266546.42
Mission | ARMS |  |  |  |  | 281595.27 | 33 | 2012-02-23 00:00:00 | 1 | 0 | 281595.27
Mission | ARMS |  |  |  |  | 93652.39 | 34 | 2011-02-19 00:00:00 | 1 | 0 | 93652.39
Mission | ARMS |  |  |  |  | 1904756.8 | 28 | 2011-04-28 00:00:00 | 1 | 0 | 1904756.8
Mission | ARMS |  |  |  |  | 1230553.55 | 52 | 2012-10-04 00:00:00 | 1 | 0 | 1230553.55
Mission | ARMS |  |  |  |  | 537356.79 | 38 | 2023-11-18 00:00:00 | 1 | 0 | 537356.79
Mission | ARMS |  |  |  |  | 90499.31 | 28 | 2013-05-31 00:00:00 | 1 | 0 | 90499.31
Mission | ARMS |  |  |  |  | 1241313.6 | 37 | 2011-02-19 00:00:00 | 0 | 1 |  | 1241313.6
Mission |  |  |  |  |  | 90024.32 | 65 | 2011-01-22 00:00:00 | 0 | 1 |  | 90024.32
Mission |  |  |  |  |  | 910000 | 103 | 2010-12-15 00:00:00 | 0 | 1 |  | 910000
Mission |  |  |  |  |  | 950000 | 103 | 2010-12-15 00:00:00 | 0 | 1 |  | 950000
Mission |  |  |  |  |  | 665000 | 72 | 2011-01-15 00:00:00 | 0 | 1 |  | 665000
Mission |  |  |  |  |  | 145000 | 73 | 2011-01-14 00:00:00 | 0 | 1 |  | 145000
Mission |  |  |  |  |  | 237303.51 | 28 | 2013-06-25 00:00:00 | 0 | 1 |  | 237303.51
Mission |  |  |  |  |  | 80142.91 | 27 | 2012-06-26 00:00:00 | 0 | 1 |  | 80142.91
Mission |  |  |  |  |  | 339447.17 | 29 | 2012-09-24 00:00:00 | 0 | 1 |  | 339447.17
Mission |  |  |  |  |  | 89388.18 | 25 | 2015-09-29 00:00:00 | 1 | 0 | 89388.18
Mission |  |  |  |  |  | 4402.01 | 57 | 2011-10-30 00:00:00 | 1 | 0 | 4402.01
Mission |  |  |  |  |  | 5027.35 | 34 | 2011-05-19 00:00:00 | 1 | 0 | 5027.35
Mission |  |  |  |  |  | 1063352.8 | 28 | 2012-03-29 00:00:00 | 1 | 0 | 1063352.8
Mission |  |  |  |  |  | 5433043.21 | 34 | 2012-11-05 00:00:00 | 1 | 0 | 5433043.21
Mission |  |  |  |  |  | 451872.16 | 72 | 2015-05-12 00:00:00 | 1 | 0 | 451872.16
Mission |  |  |  |  |  | 6875.98 | 30 | 2011-10-23 00:00:00 | 1 | 0 | 6875.98
Mission |  |  |  |  |  | 103176.83 | 42 | 2018-11-11 00:00:00 | 1 | 0 | 103176.83
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1 | 53067166 | 52199188.87999998
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1