Spreadsheet: 838428d1690998016-create-projection-recovery-of-report-02082023-excel-forum-file
Sheet: Criteria

 |  | Report Date |  | 2023-06-30 00:00:00
Conditions | Bucket | Period | From Date | To Date | Criteria 1 | [NAME] | Criteria 3 | Amount
1 | 1 | Next day |  | 2023-07-01 00:00:00 | [NAME] <= D5 |  |  | Outstanding
2 |  |  |  |  | Day of installment date = day of To Date | expiry date > To Date | Outstanding > InstalmentAmt | InstalmentAmt
3 |  |  |  |  | Day of installment date = day of To Date | expiry date > To Date | Outstanding < InstalmentAmt | Outstanding
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 2 | 2 -7 days |  | 2023-07-07 00:00:00 | [NAME] from C9 to D9 |  |  | Outstanding
2 |  |  |  |  | Day of installment date >= day of C9 Day of installment date <= day of D9 | [NAME]  > D9 | Outstanding > InstalmentAmt | InstalmentAmt
3 |  |  |  |  | Day of installment date >= day of C9 Day of installment date <= day of D9 | [NAME]  > D9 | Outstanding < InstalmentAmt | Outstanding
4 | 4 |  |  |  | ELSE |  |  | ZERO
1 | 3 | 8 - 14 days |  | 2023-07-14 00:00:00 | [NAME] from C13 to D13 |  |  | Outstanding
2 |  |  |  |  | Day of installment date >= day of C13 Day of installment date <= day of D13 | expiry date > D13 | Outstanding > InstalmentAmt | InstalmentAmt
3 |  |  |  |  | Day of installment date >= day of C13 Day of installment date <= day of D13 | expiry date > D13 | Outstanding < InstalmentAmt | Outstanding
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 4 | 15 - 28 days |  | 2023-07-28 00:00:00 | [NAME] from C17 to D17 |  |  | Outstanding
2 |  |  |  |  | Day of installment date >= day of C17 Day of installment date <= day of D17 | expiry date > D17 | Outstanding > InstalmentAmt | InstalmentAmt
3 |  |  |  |  | Day of installment date >= day of C17 Day of installment date <= day of D17 | expiry date > D17 | Outstanding < InstalmentAmt | Outstanding
4 |  |  |  |  | ELSE |  |  | ZERO
 |  | HENCEFORTH CRITERIA FOR AMOUNT CHANGED
1 | 5 | 29 days - 3 months |  | 2023-09-30 00:00:00 | [NAME] from C22 to D22 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > D21 | Outstanding > InstalmentAmt | InstalmentAmt (*) 2
3 |  |  |  |  |  | expiry date > D21 | Outstanding < InstalmentAmt | Outstanding
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 6 | over 3 months to 6 months |  | 2023-12-30 00:00:00 | [NAME] from C26 to D26 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > D26 | Outstanding > InstalmentAmt | InstalmentAmt (*) 3
3 |  |  |  |  |  | expiry date > D26 | Outstanding < InstalmentAmt | Outstanding
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 7 | over 6 months to 1 year |  | 2024-06-30 00:00:00 | [NAME] from C30 to D30 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > D30 | Outstanding > InstalmentAmt | InstalmentAmt (*) 6
3 |  |  |  |  |  | expiry date > D30 | Outstanding < InstalmentAmt | Outstanding
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 8 | over 1 year to 3 years |  | 2026-06-30 00:00:00 | [NAME] from C34 to D34 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > D34 | Outstanding > InstalmentAmt | InstalmentAmt (*) 24
3 |  |  |  |  |  | expiry date > D34 | Outstanding < InstalmentAmt | Outstanding
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 9 | over 3 years to 5 years |  | 2028-06-30 00:00:00 | [NAME] from C38 to D38 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > D38 | Outstanding > InstalmentAmt | InstalmentAmt (*) 24
3 |  |  |  |  |  | expiry date > D38 | Outstanding < InstalmentAmt | Outstanding
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 10 | over 5 years |  | 2053-06-30 00:00:00 | [NAME] from C42 to D42 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > D42 | Outstanding > InstalmentAmt | InstalmentAmt (*) 24
3 |  |  |  |  |  | expiry date > D42 | Outstanding < InstalmentAmt | Outstanding
4 |  |  |  |  | ELSE |  |  | ZERO