Spreadsheet: 838617d1691167854-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] <= E5 |  |  | 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 D9 to E9 |  |  | Outstanding
2 |  |  |  |  | Day of installment date >= day of D9 Day of installment date <= day of E9 | [NAME]> E9 | Outstanding > (InstalmentAmt + summation of Previous all buckets value of the account) | InstalmentAmt
3 |  |  |  |  | Day of installment date >= day of D9 Day of installment date <= day of E9 | [NAME]> E9 | Outstanding < (InstalmentAmt + summation of Previous all buckets value of the account) | (Outstanding - summation of Previous all buckets value of the account)
4 | 4 |  |  |  | ELSE |  |  | ZERO
1 | 3 | 8 - 14 days |  | 2023-07-14 00:00:00 | [NAME] from D13 to [NAME] |  |  | Outstanding
2 |  |  |  |  | Day of installment date >= day of D13 Day of installment date <= day of [NAME] | expiry date > E13 | Outstanding > (InstalmentAmt + summation of Previous all buckets value of the account) | InstalmentAmt
3 |  |  |  |  | Day of installment date >= day of D13 Day of installment date <= day of [NAME] | expiry date > E13 | Outstanding < (InstalmentAmt + summation of Previous all buckets value of the account) | (Outstanding - summation of Previous all buckets value of the account)
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 4 | 15 - 28 days |  | 2023-07-28 00:00:00 | [NAME] from D17 to E17 |  |  | Outstanding
2 |  |  |  |  | Day of installment date >= day of D17 Day of installment date <= day of E17 | expiry date > E17 | Outstanding > (InstalmentAmt + summation of Previous all buckets value of the account) | InstalmentAmt
3 |  |  |  |  | Day of installment date >= day of D17 Day of installment date <= day of E17 | expiry date > E17 | Outstanding < (InstalmentAmt + summation of Previous all buckets value of the account) | (Outstanding - summation of Previous all buckets value of the account)
4 |  |  |  |  | ELSE |  |  | ZERO
 |  | HENCEFORTH CRITERIA FOR AMOUNT CHANGED
1 | 5 | 29 days - 3 months |  | 2023-09-30 00:00:00 | [NAME] from D22 to E22 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > E21 | Outstanding > (InstalmentAmt (*) 2 + summation of Previous all buckets value of the account) | InstalmentAmt (*) 2
3 |  |  |  |  |  | expiry date > E21 | Outstanding < (InstalmentAmt (*) 2 + summation of Previous all buckets value of the account) | (Outstanding - summation of Previous all buckets value of the account)
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 6 | over 3 months to 6 months |  | 2023-12-30 00:00:00 | [NAME] from D26 to E26 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > E26 | Outstanding > (InstalmentAmt (*) 3 + summation of Previous all buckets value of the account) | InstalmentAmt (*) 3
3 |  |  |  |  |  | expiry date > E26 | Outstanding < (InstalmentAmt (*) 3 + summation of Previous all buckets value of the account) | (Outstanding - summation of Previous all buckets value of the account)
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 7 | over 6 months to 1 year |  | 2024-06-30 00:00:00 | [NAME] from D30 to E30 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > E30 | Outstanding > (InstalmentAmt (*) 6 + summation of Previous all buckets value of the account) | InstalmentAmt (*) 6
3 |  |  |  |  |  | expiry date > E30 | Outstanding < (InstalmentAmt (*) 6 + summation of Previous all buckets value of the account) | (Outstanding - summation of Previous all buckets value of the account)
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 8 | over 1 year to 3 years |  | 2026-06-30 00:00:00 | [NAME] from D34 to E34 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > E34 | Outstanding > (InstalmentAmt (*) 24 + summation of Previous all buckets value of the account) | InstalmentAmt (*) 24
3 |  |  |  |  |  | expiry date > E34 | Outstanding < (InstalmentAmt (*) 24 + summation of Previous all buckets value of the account) | (Outstanding - summation of Previous all buckets value of the account)
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 9 | over 3 years to 5 years |  | 2028-06-30 00:00:00 | [NAME] from D38 to E38 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > E38 | Outstanding > (InstalmentAmt (*) 24 + summation of Previous all buckets value of the account) | InstalmentAmt (*) 24
3 |  |  |  |  |  | expiry date > E38 | Outstanding < (InstalmentAmt (*) 24 + summation of Previous all buckets value of the account) | (Outstanding - summation of Previous all buckets value of the account)
4 |  |  |  |  | ELSE |  |  | ZERO
1 | 10 | over 5 years |  | 2053-06-30 00:00:00 | [NAME] from D42 to E42 |  |  | Outstanding (-) summation of Previous all buckets value of the account
2 |  |  |  |  |  | expiry date > E42 | Outstanding > summation of Previous all buckets value of the account | Outstanding (-) summation of Previous all buckets value of the account
3 |  |  |  |  |  | expiry date > E42 | Outstanding < summation of Previous all buckets value of the account | (Outstanding - summation of Previous all buckets value of the account)
4 |  |  |  |  | ELSE |  |  | ZERO