Spreadsheet: 689956d1596781090-index-match-substitute-formula-not-working-index-match-formula
Sheet: Sheet1

Account Number / Site Code | Lease Number / CADD Code | Lease Name | Building / Land | Floor / Parcel | Site Description | Commencement  / Occupancy Date | Original Termination / Expiration Date | Updated Termination Date | Lease Option | Frequency | Lease Status | Lease Type | Rentable Area (m2) | Current Charges | Annual Charges | Annual Charges psqm | Outgoings Type | Purpose | Next Review Date | Rent Review Type
DP918225 | AG501 |  |  |  |  | 18-APR-14 | 31-MAR-17 |  |  |  | Active | PROPERTY LICENCE | 48.81
628-2-628231 |  |  |  |  |  | 03-NOV-14 | 31-JUL-20 |  |  |  |  |  | 19.51 |  |  |  | Net |  |  |  |  |  |  |  |  |  | Look Value | Results | Desired Results
628-2-628245 |  |  |  |  |  | 18-APR-14 | 31-JUL-20 |  |  |  |  |  | 29.3 |  |  |  | Net
DP918243 | AD508 |  |  |  |  | 08-DEC-14 | 10-SEP-16 |  |  |  | Active | PROPERTY LEASE | 1328.7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 006010 |  | Net
07-AV-007072 |  |  |  |  |  | 08-DEC-14 | 31-DEC-20 |  |  | Monthly |  |  | 1328.7 |  |  |  | Net | BUILDING RENT |  |  |  |  |  |  |  |  | 31328 |  | Net
DP901000 | AE505 |  |  |  |  | 01-OCT-19 | 30-SEP-22 |  |  |  | Active | PROPERTY LEASE | 625.7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 031062 |  | Gross
06-HE-006010 |  |  |  |  |  | 01-OCT-19 | 30-SEP-22 |  |  | Monthly |  |  | 115.7 |  |  |  | Net | SITE LICENCE FEE |  |  |  |  |  |  |  |  | 06009 |  | Net
06-HE-006011 | 06011 |  |  |  |  | 01-OCT-19 | 30-SEP-22 |  |  | Monthly |  |  | 305 |  |  |  | Net | HANGAR RENT
06-HE-06008A |  |  |  |  |  | 01-OCT-19 | 30-SEP-22 |  |  | Monthly |  |  | 62 |  |  |  | Net | SITE LICENCE FEE
06-HE-06009A | 06009 |  |  |  |  | 01-OCT-19 | 30-SEP-22 |  |  | Monthly |  |  | 143 |  |  |  | Net | HANGAR RENT
DP903545 | AA005 |  |  |  |  | 01-FEB-16 | 31-JAN-19 |  |  |  | Active | PROPERTY LEASE | 39.8
T1-L3-031062 | 3-1062 |  |  |  |  | 01-FEB-16 | 30-NOV-20 |  |  | Monthly |  |  | 39.8 |  |  |  | Gross | OFFICE RENT
T1-L3-031062 | 3-1062 |  |  |  |  | 01-FEB-16 | 30-NOV-20 |  |  | Monthly |  |  | 39.8 |  |  |  | Gross | OUTGOINGS - INT TERMINAL
T1-L3-031062 | 3-1062 |  |  |  |  | 01-FEB-16 | 30-NOV-20 |  |  | Monthly |  |  | 39.8 |  |  |  | Gross | TRADE WASTE RECHARGE
DP600000 | [NAME] |  |  |  |  | 01-JUL-15 | 30-JUN-20 |  |  |  | Active | PROPERTY LEASE | 30
T1-L3-031328 | 3-1328 |  |  |  |  | 01-JUL-15 | 31-DEC-20 |  |  | Monthly |  |  | 30 |  |  |  | Net | TRADE WASTE RECHARGE
T1-L3-031328 | 3-1328 |  |  |  |  | 01-JUL-15 | 31-DEC-20 |  |  | Monthly |  |  | 30 |  |  |  | Net | T1 OFFICE RENT
T1-L3-031328 | 3-1328 |  |  |  |  | 01-JUL-15 | 31-DEC-20 |  |  | Monthly |  |  | 30 |  |  |  | Net | T1 OFFICE RENT
T1-L3-031328 | 3-1328 |  |  |  |  | 01-JUL-15 | 31-DEC-20 |  |  | Monthly |  |  | 30 |  |  |  | Net | OUTGOINGS - INT TERMINAL
DP601000 | CP007 |  |  |  |  | 01-JAN-18 | 31-DEC-20 |  |  |  | Active | PROPERTY LEASE | 48.34
T1-L3-031241 | 3-1241 |  |  |  |  | 01-JAN-18 | 31-DEC-20 |  |  | Monthly |  |  | 48.34 |  |  |  |  | TRADE WASTE RECHARGE
T1-L3-031241 | 3-1241 |  |  |  |  | 01-JAN-18 | 31-DEC-20 |  |  | Monthly |  |  | 48.34 |  |  |  |  | OUTGOINGS - INT TERMINAL
T1-L3-031241 | 3-1241 |  |  |  |  | 01-JAN-18 | 31-DEC-20 |  |  | Monthly |  |  | 48.34 |  |  |  |  | OFFICE RENT