Spreadsheet: 817504d1676287338-find-value-in-worksheet-then-copy-all-values-in-that-column-directly-below-sample-tenancy-schedules
Sheet: Sample 1

 | London Asset
 | NAME AND STATUS | AREAS |  |  |  | LEASE DATES |  |  |  |  | RENTS |  |  |  | SERVICE CHARGE
 | TENANT | FLOOR | USE | AREA SQ FT | AREA  SQ M | START | [NAME] | NEXT RENT REVIEW | BREAK OPTION | INSIDE L&T 1954 ACT? | RENT PER ANNUM | RENT PSF | RENT PAYMENT DATE | NEXT PAYMENT DATE | S/C PER ANNUM | S/C PSF
 | Tenant 1 | 7th [NAME] | Office Parking (1) | 14643 |  | 2013-10-01 00:00:00 | 2027-08-06 00:00:00 | - |  | No | 772258 |  | EQD | 2021-03-25 00:00:00 | 164103.98
 | [NAME] | 6th Floor Car Space 5 & 6 | Office Parking (2) | 15799 |  | 2012-08-07 00:00:00 | 2027-08-06 00:00:00 | 2022-08-07 00:00:00 | - | Yes | 730000 |  | EQD | 2021-03-25 00:00:00 | 177059.26
 | Tenant 3 | 5th Floor | Office | 18467 |  | 2020-04-01 00:00:00 | 2027-08-06 00:00:00 | - | - | Yes | 1061853 |  | EQD | 2021-03-25 00:00:00 | 206959.51
 | Vacant | 4th Floor | Office | 18873 |  |  |  |  |  |  | 0 |  | EQD | 2021-03-25 00:00:00 | 211509.55
 | [NAME] | 3rd Floor Car Space 16 | Office Parking (1) | 19481 |  | 2011-04-04 00:00:00 | 2027-08-06 00:00:00 | - | - | Yes | 1086890 |  | EQD | 2021-03-25 00:00:00 | 218323.4
 | Tenant 5 | Part 2nd Floor (South) | Office | 11261 |  | 2015-12-30 00:00:00 | 2025-12-29 00:00:00 | - | - | No | 551740 |  | EQD | 2021-03-25 00:00:00 | 126201.93
 | Tenant 6 | Part 2nd Floor (North) | Office | 8089 |  | 2020-12-23 00:00:00 | 2027-08-06 00:00:00 | - | - | No | 460000 |  | EQD | 2021-03-25 00:00:00 | 90653.35
 | Tenant 7 | 1st Floor | Office | 18855 |  | 2020-04-01 00:00:00 | 2027-08-06 00:00:00 | - | - | Yes | 1037025 |  | EQD | 2021-03-25 00:00:00 | 211307.82
 | Tenant 8 | Ground Floor | Office | 13062 |  | 2014-06-06 00:00:00 | 2024-06-05 00:00:00 | - | - | No | 535500 |  | EQD | 2021-03-25 00:00:00 | 146385.72
 | Reception | Ground Floor | Reception | 1239 |  | - | - | - | - | - | 0 |  | EQD | 2021-03-25 00:00:00 | - | -
 | Tenant 9 | Ground Floor Storage Cage 1 | Storage | 292 |  | 2013-10-01 00:00:00 | 2027-08-06 00:00:00 | - | - | No | 3650 |  | EQD | 2021-03-25 00:00:00 | - | -
 | VACANT | Ground Floor Storage Cage 3 | Storage | 116 |  | - | - | - | - | Yes | 0 |  | EQD | 2021-03-25 00:00:00 | - | -
 | Tenant 10 | Ground Floor Storage Cage 2 | Storage | 210 |  | 2020-06-02 00:00:00 | 2030-06-01 00:00:00 | 2025-06-01 00:00:00 | Rolling | Yes | 2625 |  | EQD | 2021-03-25 00:00:00 | - | -
 | VACANT | Lower Ground Floor | Office | 3985 |  | - | - | - | - | Yes | 0 |  | EQD | 2021-03-25 00:00:00 | 44659.86
 | Tenant 11 | Lower Ground Floor | Medical | 5212 |  | 2020-06-02 00:00:00 | 2030-06-01 00:00:00 | 2025-06-01 00:00:00 | - | Yes | 115000 |  | EQD | 2021-03-25 00:00:00 | 58410.84
 | Tenant 12 | Lower Ground Floor | Office / Storage | 2511 |  | 2021-03-25 00:00:00 | 2027-08-06 00:00:00 | - | - | Yes | 37665 |  | EQD | 2021-03-25 00:00:00 | 28140.76
 | Vacant | Lower Ground Floor & Basement | Retail | 8044 | 747.311732 |  |  |  |  |  | 0
 | Management Office | Ground Floor & Basement | BMA | 1550 |  | - | - | - | - | - | 27000 |  | EQD | 2021-03-25 00:00:00 | - | -
 | SUBTOTAL
 | TOTAL