Spreadsheet: 287690d1388942669-creating-a-specific-list-from-large-data-set-loan-payments
Sheet: PA

xx |  |  | NUMBER OF SCHEDULED PAYMENTS |  |  |  |  | ACTIVE MO PAYMENT INCL SALES TAX | MONTH 1 |  |  |  |  |  |  |  | MONTH 2 |  |  |  |  |  |  |  | MONTH 3 |  |  |  |  |  |  |  | MONTH 4 |  |  |  |  |  |  |  | MONTH 5 |  |  |  |  |  |  |  | MONTH 6 |  |  |  |  |  |  |  | MONTH 7 |  |  |  |  |  |  |  | MONTH 8 |  |  |  |  |  |  |  | MONTH 9 |  |  |  |  |  |  |  | MONTH 10 |  |  |  |  |  |  |  | MONTH 11 |  |  |  |  |  |  |  | MONTH 12 |  |  |  |  |  |  |  | MONTH 13 |  |  |  |  |  |  |  | MONTH 14 |  |  |  |  |  |  |  | MONTH 15 |  |  |  |  |  |  |  | MONTH 16 |  |  |  |  |  |  |  | MONTH 17 |  |  |  |  |  |  |  | MONTH 18 |  |  |  |  |  |  |  | MONTH 19 |  |  |  |  |  |  |  | MONTH 20 |  |  |  |  |  |  |  | MONTH 21 |  |  |  |  |  |  |  | MONTH 22 |  |  |  |  |  |  |  | MONTH 23 |  |  |  |  |  |  |  | MONTH 24 |  |  |  |  |  |  |  | MONTH 25 |  |  |  |  |  |  |  | MONTH 26 |  |  |  |  |  |  |  | MONTH 27 |  |  |  |  |  |  |  | MONTH 28 |  |  |  |  |  |  |  | MONTH 29 |  |  |  |  |  |  |  | MONTH 30 |  |  |  |  |  |  |  | MONTH 31 |  |  |  |  |  |  |  | MONTH 32 |  |  |  |  |  |  |  | MONTH 33 |  |  |  |  |  |  |  | MONTH 34 |  |  |  |  |  |  |  | MONTH 35 |  |  |  |  |  |  |  | MONTH 36
 |  |  |  | NUMBER of PAYMENTS REMAINING | AMT NET TAX | 1-ACTIVE     2-PAID OFF 3-REPO'D | PAYOFF AMT RCVD |  | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD
1 | XXX0001 | CUST0001 | 35 |  | 1645 | 1 |  |  | 2013-08-26 00:00:00 |  |  |  |  | 80.72 |  | 80.72 | 2013-09-13 00:00:00 |  |  |  |  | 80.72 | 19.28 | 100 | 2013-10-02 00:00:00 |  |  |  |  | 80.72 | 0.28 | 81 | 2013-11-05 00:00:00 |  |  |  |  |  |  | 100 | 2013-12-06 00:00:00 |  |  |  |  |  |  | 81
2 | XXX0002 | CUST0002 | 35 |  | 2105 | 1 |  |  | 2013-08-10 00:00:00 |  |  |  |  | 103.31 |  | 103.31 | 2013-09-05 00:00:00 |  |  |  |  | 103.31 |  | 103.31 | 2013-10-14 00:00:00 |  | Y | 15 |  | 103.31 |  | 118.31 | 2013-11-16 00:00:00 |  |  |  |  |  |  | 128
3 | XXX0003 | CUST0003 | 35 |  | 1745 | 1 |  |  | 2013-09-05 00:00:00 |  |  |  |  | 85.63 |  | 85.63 | 2013-10-16 00:00:00 |  |  |  | 5 | 85.63 |  | 90.63 | 2013-11-01 00:00:00 |  |  |  | 5 | 85.63 |  | 90.63
4 | XXX0004 | CUST0004 | 35 |  | 4745 | 1 |  |  | 2013-09-16 00:00:00 |  |  |  |  | 232.86 |  | 232.86 | 2013-10-12 00:00:00 |  |  |  |  | 232.86 | 67.14 | 300 | 2013-11-22 00:00:00 |  |  |  |  | 232.86 | 67.14 | 300 | 2013-12-11 00:00:00 |  |  |  |  |  |  | 75
5 | XXX0005 | CUST0005 | 35 |  | 1950 | 1 |  |  | 2013-10-03 00:00:00 |  |  |  |  | 95.7 |  | 95.7 | 2013-11-01 00:00:00 |  |  |  |  | 95.7 |  | 95.7 | 2013-12-10 00:00:00 |  |  |  |  | 95.7 |  | 95.7
 |  |  |  |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of |  |  |  |  |  |  |  | out of
 |  |  |  |  |  |  |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage |  |  |  |  | active accts |  |  | shortage