Spreadsheet: 754377d1636129219-transfer-specific-information-from-several-files-to-one-october-2021-sample
Sheet: Sheet1

[NAME] | Type | Rent | Past due from | Late Fee $10 | Total Due | AMT PAID | BALANCE | DATE PAID | LEASE START | LEASE END | SECURITY
 |  |  | previous mth. | for the ist $1000 |  |  |  |  |  |  | DEPOSIT
 |  |  |  | 5% on the rest
A1 | 3BR | 1240 | 188.4644999999998 | 1.423224999999991 |  | 1400 |  | 2021-10-05 00:00:00 | 2019-05-17 00:00:00 | 2022-04-30 00:00:00 | 1800
A2 | 3BR | 1245 | -0.1190649996906359 | 0.2440467500154682 |  | 1240 |  | 2021-10-05 00:00:00 | 2019-05-06 00:00:00 | 2022-04-30 00:00:00 | 3000
A3 | 2BR | 1110 | 2241.908699604649 | 15.5 |  |  |  |  | 2019-05-06 00:00:00 | MONTH TO MONTH | 1455
A4 | 2BR | 1010 | 0 | 0 |  | 1010 |  | 2021-10-05 00:00:00 | 2019-05-15 00:00:00 | 2022-04-30 00:00:00 | 970
A5 | 3BR | 1150 | -85.71000000000004 | 13.2145 |  | 1150 |  | 2021-10-18 00:00:00 | 2018-01-25 00:00:00 | 2021-12-31 00:00:00 | 1612.5
A6 | 3BR | 1265 | 8135.453125 | 23.25 |  |  |  |  | 2016-03-01 00:00:00 | MONTH TO MONTH | 2200
A7 | 2BR | 1010 | 0 | 0 |  | 1010 |  | 2021-10-03 00:00:00 | 2019-08-26 00:00:00 | 2022-07-31 00:00:00 | 1940
A8 | 2BR | 1005 | -40 | 0 |  | 1005 |  | 2021-10-05 00:00:00 | 2018-03-14 00:00:00 | 2022-02-28 00:00:00 | 950
A9 | STUDIO | 750 | 0 | 0 |  | 750 |  | 2021-10-05 00:00:00 | 2019-05-07 00:00:00 | 2022-04-30 00:00:00 | 725
A10 | 2BR | 1010 | -1034.075 | 0 |  |  |  |  | 2019-05-10 00:00:00 | 2022-04-30 00:00:00 | 1455
A11 | 2BR | 1010 | -99.99624999999992 | 10 |  | 1000 |  | 2021-10-04 00:00:00 | 2019-05-10 00:00:00 | 2022-04-30 00:00:00 | 900
A12 | 2BR | 800 | -800 | 0 |  |  |  |  | 2019-05-17 00:00:00 | 2021-04-30 00:00:00 | 0
A13 | STUDIO | 755 | 0 | 10 |  |  |  |  | 2019-06-03 00:00:00 | 2022-05-31 00:00:00 | 2175
A14 | 2BR | 1010 | 0 | 0 |  | 1010 |  | 2021-10-01 00:00:00 | 2019-06-01 00:00:00 | 2022-05-31 00:00:00 | 2910
A15 | 2BR | 995 | 45 | 2.25 |  | 995 |  | 2021-10-03 00:00:00 | 2019-07-01 00:00:00 | 2022-06-30 00:00:00 | 1830
A16 | 2BR | 1010 | -180 | 10 |  | 1100 |  | 2021-10-08 00:00:00 | 2019-05-01 00:00:00 | 2022-04-30 00:00:00 | 2425
A17 | 2BR | 1100 | 0 | 0 |  | 1100 |  | 2021-10-05 00:00:00 | 2020-07-15 00:00:00 | 2022-08-31 00:00:00 | 1075
A18 | 2BR | 1080 | 20 | 0 |  | 1100 |  | 2021-10-01 00:00:00 | 2019-08-16 00:00:00 | 2022-07-31 00:00:00 | 1040
A19 | 2BR | 960 | 640.3744228821988 | 10 |  | 1060 |  | 2021-10-05 00:00:00 | 2014-08-01 00:00:00 | 2022-07-31 00:00:00 | 1720
A20 | 2BR | 970 | 975.4967187499997 | 10 |  | 900 |  | 2021-10-29 00:00:00 | 2007-06-15 00:00:00 | 2022-05-31 00:00:00 | 1700
A21 | 2BR | 1120 | 0 | 0 |  | 1120 |  | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | 2022-09-30 00:00:00 | 1120
A22 | 2BR | 1180 | -18 | 8.1 |  | 1000 |  | 2021-10-07 00:00:00 | 2019-04-24 00:00:00 | MONTH TO MONTH | 2080
A23 | 2BR | 990 | -4840 | 0 |  |  |  |  | 2018-11-08 00:00:00 | 2021-10-31 00:00:00 | 1425
A24 | 2BR | 940 | 310 | 0 |  | 1240 |  | 2021-10-05 00:00:00 | 2009-11-17 00:00:00 | 2021-10-31 00:00:00 | 1720
A25 | 3BR | 1190 | -0.0005625000001145963 | 19.49997187499999 |  |  |  |  | 2014-02-20 00:00:00 | 2022-05-31 00:00:00 | 1612.5
A26 | 3BR | 1185 | -60 | 0 |  | 1185 |  | 2021-10-01 00:00:00 | 2013-03-22 00:00:00 | 2022-04-30 00:00:00 | 1612.5
A27 | 2BR | 975 | 0 | 0 |  | 995 |  | 2021-10-05 00:00:00 | 2017-11-03 00:00:00 | 2021-10-31 00:00:00 | 1372.5
A28 | 2BR | 970 | -60 | 0 |  | 970 |  | 2021-10-01 00:00:00 | 2017-06-02 00:00:00 | 2022-05-31 00:00:00 | 1790
A29 | 3BR | 1240 | 0 | 0 |  | 1240 |  | 2021-10-01 00:00:00 | 2019-11-06 00:00:00 | 2021-10-31 00:00:00 | 1220
A30 | 3BR | 1185 | 0 | 0 |  | 1185 |  | 2021-10-01 00:00:00 | 2007-05-05 00:00:00 | 2022-04-30 00:00:00 | 1025
A31 | 2BR | 1010 | 246 | 7.800000000000001 |  | 1100 |  | 2021-10-05 00:00:00 | 2019-07-01 00:00:00 | 2022-06-30 00:00:00 | 1940
A32 | 2BR | 985 | 0 | 0 |  | 985 |  | 2021-10-05 00:00:00 | 2017-10-01 00:00:00 | 2022-09-30 00:00:00 | 1372.5