Spreadsheet: 694741d1599769487-index-and-match-constant-array-row-height-but-variable-text-row-height-sample-workbook
Sheet: second edit

Unit | Unit Type | Unit2 | Resident | Name | Market | Charge | Actual | Resident3 | Other | Move In | Lease | Move Out | Balance
 |  | Sq Ft |  |  | Rent | Code | Rent | Deposit | Deposit |  | Expiration
Current/Notice/Vacant Residents |  |  |  |  |  |  |  |  |  |  |  |  |  | Unit | SF | Name | Vacant? | Mkt Rent | Actual Rent | Lease Start | Lease End | UW Rent
630A | 4312A1 | 560.00 | t0524396 | First Name, Last Name | 706 | rent | 685 | 0 | 0 | 02/01/2020 | 01/31/2021 |  | 0
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | Total | 728
630B | 4312A2 | 560.00 | t0450995 | First Name, Last Name | 706 | sec8rent | 605 | 0 | 0 | 09/21/2018 | 09/19/2020 |  | 0
 |  |  |  |  |  | Total | 605
630C | 4312B1 | 827.00 | t0516544 | First Name, Last Name | 823 | sec8rent | 709 | 236.83 | 0 | 12/06/2019 | 11/30/2020 |  | 111.17
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 723
630D | 4312B1 | 827.00 | t0505473 | First Name, Last Name | 823 | rent | 670 | 0 | 0 | 10/15/2019 | 10/14/2020 |  | 1461.5
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 713
630E | 4312C1 | 1,003.00 | t0476281 | First Name, Last Name | 872 | wtradmin | 3 | 250 | 0 | 03/09/2019 | 05/06/2021 |  | 0
 |  |  |  |  |  | rent | 846
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 860
630F | 4312B1 | 827.00 | t0506437 | First Name, Last Name | 823 | rent | 670 | 0 | 0 | 10/09/2019 | 10/08/2020 | 09/05/2020 | 2249
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 713
630G | 4312C1 | 1,003.00 | t0519908 | First Name, Last Name | 872 | wtradmin | 3 | 250 | 0 | 01/01/2020 | 12/31/2020 |  | 0
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | sec8rent | 791
 |  |  |  |  |  | Total | 805
630H | 4312B1 | 827.00 | t0505540 | First Name, Last Name | 823 | wtradmin | 3 | 0 | 0 | 10/01/2019 | 09/30/2020 |  | -1
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | sec8rent | 566
 |  |  |  |  |  | rent | 104
 |  |  |  |  |  | Total | 684
630I | 4312C1 | 1,003.00 | t0486240 | First Name, Last Name | 872 | acreins | 11 | 0 | 0 | 06/08/2019 | 05/31/2020 |  | -2.13
 |  |  |  |  |  | rent | 832
 |  |  |  |  |  | Total | 843
630J | 4312B1 | 827.00 | [NAME] | First Name, Last Name | 823 | sec8rent | 419 | 250 | 0 | [NAME] | 11/30/2020 |  | 0
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | mtm | 100
 |  |  |  |  |  | rent | 290
 |  |  |  |  |  | Total | 723
630K | 4312C1 | 1,003.00 | t0506862 | First Name, Last Name | 872 | rent | 770 | 0 | 0 | 10/05/2019 | 10/04/2020 |  | -30.38
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 813
630L | 4312B1 | 827.00 | t0546769 | First Name, Last Name | 823 | rent | 799 | 0 | 0 | 06/20/2020 | 06/19/2021 |  | 14.07
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 842
630M | 4312C3 | 1,107.00 | t0370915 | First Name, Last Name | 938 | rent | 887 | 250 | 0 | 12/19/2014 | 01/31/2020 |  | 951
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | Total | 901
635A | 4312A1 | 560.00 | t0477412 | First Name, Last Name | 706 | wtradmin | 3 | 250 | 0 | 04/03/2019 | 03/31/2021 |  | 0
 |  |  |  |  |  | rent | 675
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 689
635B | 4312A2 | 564.00 | t1695269 | First Name, Last Name | 706 | rent | 663 | 500 | 0 | 11/12/2018 | 11/11/2020 |  | 0
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 677
635C | 4312B1 | 827.00 | [NAME] | First Name, Last Name | 823 | rent | 799 | 0 | 0 | 03/28/2018 | 05/28/2020 | 08/21/2020 | 963
 |  |  |  |  |  | mtm | 100
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 913
635D | 4312B1 | 827.00 | t0370919 | First Name, Last Name | 823 | rent | 250 | 250 | 0 | 11/12/2013 | 10/31/2020 |  | -1.7
 |  |  |  |  |  | sec8rent | 459
 |  |  |  |  |  | Total | 709
635E | 4312C1 | 1,003.00 | t0549142 | First Name, Last Name | 872 | rent | 846 | 0 | 0 | 07/18/2020 | 07/17/2021 |  | 0
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | concothr | -50
 |  |  |  |  |  | Total | 810
635F | 4312B1 | 827.00 | t0509623 | First Name, Last Name | 823 | rent | 635 | 0 | 0 | 04/26/2016 | 09/30/2018 |  | 3615
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | Total | 667
635G | 4312C1 | 1,003.00 | t0531454 | First Name, Last Name | 872 | rent | 846 | 0 | 0 | 03/31/2020 | 03/30/2021 |  | -1
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 889
635H | 4312B1 | 827.00 | t0370923 | First Name, Last Name | 823 | wtradmin | 3 | 500 | 0 | 08/15/2015 | 09/30/2021 |  | 0
 |  |  |  |  |  | rent | 681
 |  |  |  |  |  | Total | 684
635I | 4312C1 | 1,003.00 | t0532287 | First Name, Last Name | 872 | rent | 846 | 0 | 0 | 03/21/2020 | 03/20/2021 |  | 0
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 889
635J | 4312B1 | 827.00 | t0370925 | First Name, Last Name | 823 | rent | 720 | 250 | 0 | 12/20/2013 | 01/31/2021 |  | 0
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | Total | 734
635K | 4312C1 | 1,003.00 | t0507412 | First Name, Last Name | 872 | rent | 770 | 0 | 0 | 10/07/2019 | 10/06/2020 |  | -855
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 813
635L | 4312B1 | 827.00 | t0532115 | First Name, Last Name | 823 | rent | 799 | 0 | 0 | 03/21/2020 | 03/20/2021 |  | -0.42
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 842
635M | 4312C3 | 1,107.00 | t0477865 | First Name, Last Name | 938 | acreins | 11 | 500 | 0 | 04/19/2019 | 04/18/2021 |  | 0
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | rent | 899
 |  |  |  |  |  | Total | 913
640A | 4312C3 | 1,107.00 | t0508383 | First Name, Last Name | 938 | rent | 899 | 0 | 0 | 10/04/2019 | 04/03/2020 |  | 1498.86
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 942
640B | 4312B1 | 827.00 | t0552714 | First Name, Last Name | 823 | rent | 799 | 250 | 0 | 08/01/2020 | 07/31/2021 |  | 13
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | Total | 802
640C | 4312B1 | 827.00 | t0370931 | First Name, Last Name | 823 | rent | 174 | 500 | 0 | 11/03/2014 | 10/31/2018 |  | 0
 |  |  |  |  |  | sec8rent | 535
 |  |  |  |  |  | Total | 709
640D | 4312C1 | 1,003.00 | t0451809 | First Name, Last Name | 872 | rent | 829 | 250 | 0 | 09/01/2018 | 08/31/2020 |  | 23
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 843
640E | 4312B1 | 827.00 | t0501293 | First Name, Last Name | 823 | rent | 670 | 0 | 0 | 09/06/2019 | 09/05/2021 |  | 360.5
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 713
640F | 4312C1 | 1,003.00 | VACANT | VACANT | 872 |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  | Total | 0
640G | 4312B1 | 827.00 | t0549190 | First Name, Last Name | 823 | rent | 799 | 0 | 0 | 07/06/2020 | 07/05/2021 |  | 0
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 813
640H | 4312C1 | 1,003.00 | t0370992 | First Name, Last Name | 872 | rent | 685 | 500 | 0 | 06/28/2014 | 10/31/2021 |  | 0
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | Total | 699
640I | 4312B1 | 827.00 | t0525228 | First Name, Last Name | 823 | rent | 799 | 0 | 0 | 02/01/2020 | 01/31/2021 |  | 0
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 842
640J | 4312C1 | 1,003.00 | t0515404 | First Name, Last Name | 872 | rent | 846 | 0 | 0 | 12/16/2019 | 12/15/2020 |  | 0
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 889
640K | 4312B1 | 827.00 | t0482491 | First Name, Last Name | 823 | wtradmin | 3 | 0 | 0 | 09/17/2019 | 08/31/2020 |  | -32.93
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | sec8rent | 670
 |  |  |  |  |  | Total | 684
640L | 4312A1 | 564.00 | t0514358 | First Name, Last Name | 706 | rent | 685 | 0 | 0 | 11/22/2019 | 11/21/2020 |  | 552
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | llock | 29
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 728
640M | 4312A2 | 560.00 | t0416968 | First Name, Last Name | 706 | rent | 125 | 0 | 0 | 01/12/2018 | 01/11/2019 |  | 0
 |  |  |  |  |  | sec8rent | 487
 |  |  |  |  |  | Total | 612
645A | 4312C3 | 1,107.00 | t0457081 | First Name, Last Name | 938 | wtradmin | 3 | 500 | 0 | 09/28/2018 | 09/27/2020 |  | -6.1
 |  |  |  |  |  | rent | 869
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 883
645B | 4312B1 | 827.00 | VACANT | VACANT | 823 |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  | Total | 0
645C | 4312B1 | 827.00 | t0370999 | First Name, Last Name | 823 | rent | 775 | 250 | 0 | 11/21/2014 | 01/31/2020 |  | 0
 |  |  |  |  |  | mtm | 100
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | Total | 889
645D | 4312C1 | 1,003.00 | t0493856 | First Name, Last Name | 872 | llock | 29 | 0 | 0 | 07/15/2019 | 07/14/2020 |  | 0
 |  |  |  |  |  | acreins | 11
 |  |  |  |  |  | wtradmin | 3
 |  |  |  |  |  | rent | 846
 |  |  |  |  |  | mtm | 100
 |  |  |  |  |  | xyz
 |  |  |  |  |  | abc
 |  |  |  |  |  | Total | 989 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x