Spreadsheet: 72145d1272873266-age-analysis-match-allocate-to-oldest-debt-balance-age-arrears-matching
Sheet: Sheet3

 | ORIGINAL
 | Closing Balance | 2010-04-01 00:00:00 | 2010-03-01 00:00:00 | 2010-02-01 00:00:00 | 2010-01-01 00:00:00 | 2009-12-01 00:00:00 | Opening Balance
 | 187050.32 | 21683.74 | 33900.99 | -414.6600000000035 | 4959.16 | 34520.12 | 92400.97
 | 146591.56 | 6532.27 | 10481.14 | 6559.25 | 9092.42 | 8263.54 | 105662.94
 | 139946.44 | 1611.35 | 1651.78 | 1634.76 | 1617.9 | 23428.43 | 110002.22
 | 12809.02 | 3533.72 | 3389 | 156.58 | 2823.81 | 3163.22 | -257.3100000000018
 | 4933.1 | 274.59 | 273.68 | 4384.83 | 191.42 | 643.28 | -834.7
 | 405.7000000000007 | -4155.07 | -4015.43 | 8576.2 | 0 | 0 | 0
 | 352.0300000000007 | 352.0300000000007 | -1038.69 | 1038.69 | 0 | 0 | 0
 | 56.34000000000344 | 15.25 | 41.09000000000015 | 0 | -670.2699999999993 | 1497.56 | -827.2899999999973
 | 492144.5100000001 | 29847.88 | 44683.56 | 21935.65 | 18014.44 | 71516.15 | 306146.83
 | 1 | 0.06064860908435206 | 0.09079357605756892 | 0.04457156293382201 | 0.03660396414866031 | 0.1453153465025953 | 0.6220669412730012
 | -124.2799999999945 | -1.299999999999272 | -0.180000000000291 | 1.392663762089796e-12 | -500 | 711.25 | -334.0499999999963
 | -173.739999999995 | -4.259999999998399 | -2.049999999999272 | -125.48 | -5.919999999998254 | 74.51 | -110.5399999999991
 | -176.3900000000031 | 240.26 | 2083.35 | -2500 | -968.5400000000026 | 1380.85 | -412.31
 | -249.5200000000052 | -1.818989403545856e-12 | -1.818989403545856e-12 | 0 | -673.8400000000006 | 875.3899999999991 | -451.07
 | -260.0799999999945 | -260.0799999999981 | -25454.28 | -7433.38 | 32887.66 | 0 | 0
 | -660.1199999999799 | 0 | 0 | 0 | 0 | 0 | -660.1199999999799
 | -2255.420000000003 | -1127.71 | -1127.71 | 0 | -234.06 | 154.72 | 79.33999999999764
 | -2357.489999999999 | -2567.5 | -2568.91 | 294.6500000000005 | -1172.8 | 752.29 | 2904.78
 | -6152.539999999999 | 6237.52 | -12229.68 | -15024.3 | 14863.92 | 0 | 0
 | -12409.57999999997 | 2516.930000000003 | -39299.46 | -24788.51 | 44196.42 | 3949.009999999998 | 1016.030000000023
 | 1 | -0.2028215298180928 | 3.166864632002057 | 1.997530133977141 | -3.561475892012469 | -0.318222695691555 | -0.08187464845708115
 | TEST |  |  |  |  |  |  |  | MATCHED TO OLDEST
 |  |  |  |  |  |  |  |  | Closing Balance | 2010-04-01 00:00:00 | 2010-03-01 00:00:00 | 2010-02-01 00:00:00 | 2010-01-01 00:00:00 | 2009-12-01 00:00:00 | Opening Balance
 | B | C | D | E | F | G | H
 | 187050.32 | 21683.74 | 33900.99 | 0 | 4959.16 | 34520.12 | 91986.31 |  | 187050.32 | 21683.74 | 33900.99 | 0 | 4959.16 | 34520.12 | 91986.31
 | 146591.56 | 6532.27 | 10481.14 | 6559.25 | 9092.42 | 8263.54 | 105662.94 |  | 146591.56 | 6532.27 | 10481.14 | 6559.25 | 9092.42 | 8263.54 | 105662.94
 | 139946.44 | 1611.35 | 1651.78 | 1634.76 | 1617.9 | 23428.43 | 110002.22 |  | 139946.44 | 1611.35 | 1651.78 | 1634.76 | 1617.9 | 23428.43 | 110002.22
 | 12809.02 | 3533.72 | 3389 | 156.58 | 2823.81 | 2905.909999999998 | 0 |  | 12809.02 | 3533.72 | 3389 | 156.58 | 2823.81 | 2905.909999999998 | 0
 | 4933.1 | 274.59 | 273.68 | 4384.83 | 0 | 0 | 0 |  | 4933.1 | 274.59 | 273.68 | 4384.83 | 0 | 0 | 0
 | 405.7000000000007 | 0 | 0 | 405.7000000000007 | 0 | 0 | 0 |  | 405.7000000000007 | 0 | 0 | 405.7000000000007 | 0 | 0 | 0
 | 352.0300000000007 | 352.0300000000007 | 0 | 0 | 0 | 0 | 0 |  | 352.0300000000007 | 352.0300000000007 | 0 | 0 | 0 | 0 | 0
 | 56.34000000000333 | 15.25 | 41.09000000000015 | 0 | 0 | 3.183231456205249e-12 | 0 |  | 56.34000000000344 | 15.25 | 41.09000000000015 | 0 | 0 | 0 | 3.296918293926865e-12
 | 492144.5100000001 | 29847.88 | 44683.56 | 21935.65 | 18014.44 | 71516.15 | 306146.83 |  | 492144.5100000001 | 34002.95 | 49737.67999999999 | 13141.12 | 18493.29 | 69118 | 307651.47
 | 1 | 0.06064860908435206 | 0.09079357605756892 | 0.04457156293382201 | 0.03660396414866031 | 0.1453153465025953 | 0.6220669412730012 |  | 1 | 0.06909139350147377 | 0.1010631613060156 | 0.02670175067075319 | 0.03757695072124242 | 0.1404424891379973 | 0.6251242546625175
 | -124.2799999999945 | -1.299999999999272 | -0.180000000000291 | 0 | -122.799999999995 | 0 | 0 |  | -124.2799999999945 | -1.299999999999272 | -0.180000000000291 | 1.392663762089796e-12 | -122.7999999999963 | 0 | 0
 | -173.739999999995 | -4.259999999998399 | -2.049999999999272 | -125.48 | -5.919999999998254 | 0 | -36.02999999999905 |  | -173.739999999995 | -4.259999999998399 | -2.049999999999272 | -125.48 | -5.919999999998254 | 0 | -36.02999999999905
 | -176.3900000000031 | 0 | 0 | -176.3900000000031 | 0 | 0 | 0 |  | -176.390000000003 | 0 | 0 | -176.3900000000003 | 0 | 0 | -2.671640686457977e-12
 | -249.5200000000051 | -1.818989403545856e-12 | -1.818989403545856e-12 | 0 | -249.5200000000015 | 0 | 0 |  | -249.5200000000015 | 0 | 0 | 0 | -249.5200000000015 | 0 | 0
 | -260.0799999999945 | -260.0799999999945 | 0 | 0 | 0 | 0 | 0 |  | -260.0799999999981 | -260.0799999999981 | 0 | 0 | 0 | 0 | 0
 | -660.1199999999799 | 0 | 0 | 0 | 0 | 0 | -660.1199999999799 |  | -660.1199999999799 | 0 | 0 | 0 | 0 | 0 | -660.1199999999799
 | -2255.420000000002 | -1127.71 | -1127.71 | 0 | -2.359001882723533e-12 | 0 | 0 |  | -2255.420000000002 | -1127.71 | -1127.71 | 0 | 0 | 0 | -2.359001882723533e-12
 | -2357.489999999999 | -2357.489999999999 | 0 | 0 | 0 | 0 | 0 |  | -2357.489999999999 | -2357.489999999999 | 0 | 0 | 0 | 0 | 0
 | -6152.539999999997 | 0 | -6152.539999999997 | 0 | 0 | 0 | 0 |  | -6152.54 | 0 | -6152.54 | 0 | 0 | 0 | 0
 | -12409.57999999997 | 2516.930000000003 | -39299.46 | -24788.51 | 44196.42 | 3949.009999999998 | 1016.030000000023 |  | -12409.57999999997 | -3750.839999999995 | -7282.48 | -301.8699999999989 | -378.2399999999961 | 0 | -696.149999999984
 | 1 | -0.2028215298180929 | 3.166864632002057 | 1.997530133977142 | -3.561475892012469 | -0.318222695691555 | -0.08187464845708115 |  | 1 | 0.3022535815071907 | 0.5868433903484256 | 0.02432556138080415 | 0.03047967779731441 | 0 | 0.05609778896626522