Spreadsheet: 849624d1700050104-help-request-for-two-accurate-formulas-for-a-report-of-pivot-table-data-in-excel-excel-help-req-15-11-23
Sheet: Data Sheet

S.No. | Customer Name | Face Value of Investment | Currency | Issue Date | 1st Coupon | 2nd Coupon | 3rd Coupon | 4th Coupon | 5th Coupon | 6th Coupon | 7th Coupon | 8th Coupon | 9th Coupon | 10th Coupon | Maturity Date | Bond Nature | Coupon Today | Maturity Today | Tenor | Status | Certificate # | GL Number | BANK A/C Number | Classification
1 | [NAME] | 1000000 | GBP | 2020-10-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2021-10-10 00:00:00 |  |  |  | 1-Year | Matured | 373000-002 | S-00101-000003440 | 3341413000000493 | NON-RESIDENT
 | Sophia | 500000 | EUR | 2022-01-25 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2022-04-25 00:00:00 |  |  |  | 3-Months | Matured | 371000-002 | S-00101-000003439 | 3387413000000550 | NON-RESIDENT
 | [NAME] | 100000 | AED | 2023-05-14 00:00:00 | 2022-05-14 00:00:00 | 2022-11-14 00:00:00 | 2023-05-14 00:00:00 | 2023-11-14 00:00:00 | 2024-05-14 00:00:00 | 2024-11-14 00:00:00 | 2025-05-14 00:00:00 | 2025-11-14 00:00:00 | 2026-05-14 00:00:00 | 2026-11-14 00:00:00 | 2026-11-14 00:00:00 | Coupon Bond |  |  | 5-Years | Outstanding | 375000-002 | S-00101-000003278 | 3228413000000835 | NON-RESIDENT
 | [NAME] | 5000 | USD | 2021-10-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2022-10-05 00:00:00 |  |  |  | 1-Year | Matured | 393000-002 | S-00101-000003644 | 3098414000003822 | NON-RESIDENT
 | [NAME] | 100000 | SAR | 2020-11-15 00:00:00 | 2023-11-14 00:00:00 | 2024-05-14 00:00:00 | 2024-11-14 00:00:00 | 2025-05-14 00:00:00 | 2025-11-14 00:00:00 | 2026-05-14 00:00:00 |  |  |  |  | 2023-11-15 00:00:00 | Coupon Bond |  |  | 3-Years | Prematured | 375000-003 | S-00101-000003406 | 3228413000001400 | NON-RESIDENT
 | Emma | 100000 | USD | 2023-05-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2023-08-02 00:00:00 |  |  |  | 3-Months | Matured | 371000-003 | S-00101-000003451 | 8341413000000009 | NON-RESIDENT
 | [NAME] | 500000 | USD | 2023-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2023-11-17 00:00:00 |  |  |  | 3-Months | Outstanding | 371000-003 | S-00101-000003452 | 3387413000000513 | NON-RESIDENT
 | [NAME] | 5000 | USD | 2020-10-21 00:00:00 | 2021-04-21 00:00:00 | 2021-10-21 00:00:00 | 2022-04-21 00:00:00 | 2022-10-21 00:00:00 | 2023-04-21 00:00:00 | 2023-10-21 00:00:00 | 2024-04-21 00:00:00 | 2024-10-21 00:00:00 | 2025-04-21 00:00:00 | 2025-10-21 00:00:00 | 2025-10-21 00:00:00 | Coupon Bond |  |  | 5-Years | Outstanding | 395000-003 | S-00101-000003703 | 3228414000000834 | NON-RESIDENT
 | Olivia | 5000 | USD | 2022-06-07 00:00:00 | 2022-12-07 00:00:00 | 2023-06-07 00:00:00 | 2023-12-07 00:00:00 | 2024-06-07 00:00:00 | 2024-12-07 00:00:00 | 2025-06-07 00:00:00 |  |  |  |  | 2025-06-07 00:00:00 | Coupon Bond |  |  | 3-Years | Outstanding | 395000-003 | S-00101-000003648 | 3228414000001108 | NON-RESIDENT
 | [NAME] | 500000 | EUR | 2023-03-28 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2023-09-28 00:00:00 |  |  |  | 6-Months | Matured | 372000-004 | S-00101-000003444 | 3228413000001328 | NON-RESIDENT
 | STATUS
 | Outstanding | Hold by Customer till Maturity date |  |  |  | BLANK
 | Matured | Matured at the date of Maturity |  |  |  | MATURED
 | Pre-Matured | Pre-Matured by Customer before Maturity date |  |  |  | Pre-Matured
 | CLASSIFICATION
 | Resident
 | Non-Resident
 | Resident & Non-Resident
 | CURRENCY
 | USD
 | EUR
 | GBP
 | AED
 | SAR
 | TENORS
 | 3-Months
 | 6-Months
 | 1-Year
 | 3-Years
 | 5-Years