Spreadsheet: 99505d1298121256-obtain-selective-data-from-different-worksheet-activity-1a
Sheet: Collections

MAIN DATA |  |  |  |  |  |  |  |  |  | HIDE | Week 53 |  |  |  |  |  | Week 1
NAMES | ID | FRQ | DATE | Num | Term | Rate | OPENING |  |  | A/C | 2011-01-01 00:00:00 |  |  |  |  |  | 2011-01-08 00:00:00 |  |  |  |  |  | TEST | TEST | TEST
 |  |  |  |  |  |  | [NAME] | Arrears | Balance | W/D | [NAME] | Rate | Collect | Adj | Arrears | Balance | [NAME] | Rate | Collect | Adj | Arrears | Balance | COLUMN | COLUMN | COLUMN
[NAME] | 179065 | W | 2007-12-15 00:00:00 | 719 | 56 | 4.5 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
[NAME] | 179065 | W | 2007-12-15 00:00:00 | 842 | 56 | 15 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
[NAME] | 179065 | W | 2008-03-08 00:00:00 | 665 | 56 | 9 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
[NAME] | 179065 | W | 2008-05-24 00:00:00 | 526 | 56 | 21 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
[NAME] | 179065 | W | 2008-09-06 00:00:00 | 26 | 56 | 3 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
[NAME] | 179065 | W | 2008-11-29 00:00:00 | 461 | 57 | 18 | 3 | 0 | 954 | L | 108 | 18 | 0 | 0 | 446 | 446 | 109 | 18 | 0 | 0 | 446 | 446 | 10 | 1 | 446
Week 1/11 - Arrears = | 446 | Arrears Stage |  | 9 | A/C Status: |  | L |  | TOTALS |  |  | 18 | 0 |  | 446 | 446 |  | 18 | 0 |  | 446 | 446 |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Freda [NAME] | 294274 | M | 2010-09-11 00:00:00 | 487 | 31 | 10 | 0 | 0 | 310 | L | 15 | 10 | 0 | 0 | 0 | 150 | 16 | 10 | 0 | 0 | 10 | 150 | 13 | 1 | 150
Week 1/11 - Arrears = | 10 | Arrears Stage |  | 0 | A/C Status: |  | L |  | TOTALS |  |  | 10 | 0 |  | 0 | 150 |  | 10 | 0 |  | 10 | 150 |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Master Chef | 453293 | W | 2007-12-15 00:00:00 | 834 | 56 | 15 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Master Chef | 453293 | W | 2008-03-01 00:00:00 | 563 | 56 | 6 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Master Chef | 453293 | W | 2008-05-24 00:00:00 | 533 | 56 | 3 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Master Chef | 453293 | W | 2008-09-06 00:00:00 | 19 | 56 | 3 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Master Chef | 453293 | W | 2008-10-25 00:00:00 | 29 | 56 | 15 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Master Chef | 453293 | W | 2009-01-10 00:00:00 | 919 | 57 | 18 | 0 | 0 | 1026 | L | 102 | 18 | 0 | 0 | 766 | 766 | 103 | 18 | 0 | 0 | 766 | 766 | 21 | 1 | 766
Week 1/11 - Arrears = | 766 | Arrears Stage |  | 10 | A/C Status: |  | L |  | TOTALS |  |  | 18 | 0 |  | 766 | 766 |  | 18 | 0 |  | 766 | 766 |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | 701488 | M | 2009-08-01 00:00:00 | 670 | 50 | 5.25 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | -1.4210854715202e-14 | -1.4210854715202e-14 | 0 | 0 | 0 | 0 | -1.4210854715202e-14 | -1.4210854715202e-14 |  |  | #N/A
[NAME] | 701488 | M | 2009-12-26 00:00:00 | 704 | 50 | 14 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
[NAME] | 701488 | M | 2010-09-04 00:00:00 | 746 | 50 | 35 | 0 | 0 | 1750 | L | 16 | 35 | 0 | 0 | 125 | 1280 | 17 | 35 | 0 | 0 | 160 | 1280 | 26 | 1 | 1280
Week 1/11 - Arrears = | 160 | Arrears Stage |  | 7 | A/C Status: |  | L |  | TOTALS |  |  | 35 | 0 |  | 125 | 1280 |  | 35 | 0 |  | 160 | 1280 |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | 810564 | W | 2010-09-18 00:00:00 | 634 | 31 | 7.5 | 32 | 15.5 | 232.5 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
[NAME] | 810564 | W | 2010-09-18 00:00:00 | 882 | 52 | 3.5 | 21 | 14 | 182 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
[NAME] | 810564 | W | 2010-10-02 00:00:00 | 791 | 31 | 7.5 | 0 | 0 | 232.5 | L | 12 | 7.5 | 0 | 0 | 7.5 | 142.5 | 13 | 7.5 | 0 | 0 | 15 | 142.5 | 31 | 1 | 327.5
[NAME] | 810564 | W | 2010-12-04 00:00:00 | 403 | 50 | 7 | 0 | 0 | 350 | L | 3 | 7 | 0 | 0 | 5.5 | 327.5 | 4 | 7 | 0 | 0 | 12.5 | 327.5 | 32 | 1 | 470
Week 1/11 - Arrears = | 27.5 | Arrears Stage |  | 2 | A/C Status: |  | L |  | TOTALS |  |  | 14.5 | 0 |  | 13 | 470 |  | 14.5 | 0 |  | 27.5 | 470 |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Chromium Plate | 810571 | W | 2010-09-18 00:00:00 | 641 | 31 | 7.5 | 32 | 15.5 | 232.5 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Chromium Plate | 810571 | W | 2010-09-18 00:00:00 | 837 | 52 | 3.5 | 21 | 14 | 182 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Chromium Plate | 810571 | W | 2010-10-02 00:00:00 | 746 | 31 | 7.5 | 0 | 0 | 232.5 | L | 12 | 7.5 | 0 | 0 | 7.5 | 142.5 | 13 | 7.5 | 0 | 0 | 15 | 142.5 | 37 | 1 | 327.5
Chromium Plate | 810571 | W | 2010-12-04 00:00:00 | 395 | 50 | 7 | 0 | 0 | 350 | L | 3 | 7 | 0 | 0 | 5.5 | 327.5 | 4 | 7 | 0 | 0 | 12.5 | 327.5 | 38 | 1 | 470
Week 1/11 - Arrears = | 27.5 | Arrears Stage |  | 2 | A/C Status: |  | L |  | TOTALS |  |  | 14.5 | 0 |  | 13 | 470 |  | 14.5 | 0 |  | 27.5 | 470 |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Heather Softee | 879240 | W | 2008-03-29 00:00:00 | 4 | 56 | 9 | 0 | 0 | 0 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Heather Softee | 879240 | W | 2009-01-10 00:00:00 | 926 | 57 | 15 | 0 | 0 | 855 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Heather Softee | 879240 | W | 2009-03-21 00:00:00 | 642 | 57 | 3 | 0 | 0 | 171 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Heather Softee | 879240 | W | 2009-12-19 00:00:00 | 797 | 50 | 24.5 | 0 | 0 | 1225 | L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Heather Softee | 879240 | W | 2010-04-17 00:00:00 | 22 | 50 | 10.5 | 0 | 0 | 525 | L | 36 | 10.5 | 120.76 | 15.74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
Heather Softee | 879240 | W | 2010-09-25 00:00:00 | 118 | 50 | 24.5 | 0 | 0 | 1225 | L | 13 | 24.5 | 110 | 0 | -97 | 785 | 14 | 24.5 | 0 | 0 | -72.5 | 785 | 46 | 1 | 885
Heather Softee | 879240 | W | 2011-01-01 00:00:00 | 96 | 60 | 15 | 0 | 0 | 900 | L | 0 | 0 | 0 | 0 | 0 | 900 | 0 | 15 | 15 | 0 | 0 | 885 | 47 | 1 | 1670
Week 1/11 - Arrears = | -72.5 | Arrears Stage |  | 0 | A/C Status: |  | L |  | TOTALS |  |  | 35 | 230.76 |  | -97 | 1685 |  | 39.5 | 15 |  | -72.5 | 1670 |  |  | #N/A
TOTAL ROWS WITH BALANCE >0 |  |  | 17
TOTAL ROWS WITH TOTALS IN COLUMN J |  |  | 7
TOTAL ROWS REQUIRED FOR SUMMARY |  |  | 10