i need a excel tracking spreadsheet i will give you an example

profilejackson
adams2allunits.xlsx
Home>Mathematics homework help>i need a excel tracking spreadsheet i will give you an example

Sheet1

OneSite Rents v3.0 Grady Management Inc - Adams Crossing II Page 1 of 4
12/07/2017 10:18:56AM ALL UNITS mgt-507-001
Source Site
As of 12/6/2017
Parameters: Sub Property: ALL Unit Range Start: first unit; Unit Range End: last unit; Report Type: Details + Summary ; Sort By:Floorplan
Bldg/Unit Floorplan SQFT Market Rent Amt/SQFT Lease Rent Actual Amt/SQFT Name Move-In Lease Start Lease End Deposits On Hand Made Ready
3265-11103 2x1 1,049 1,351.00 1.29 Vacant - pending resident: Bowman, Crystal 12/15/2017 12/14/2018 0.00 N
3265-11108 2x1 1,049 1,351.00 1.29 1,351.00 1.29 Shaw, Antoinette 12/01/2017 12/01/2017 11/30/2018 0.00 N
3265-11203 2x1 1,049 1,351.00 1.29 Vacant - pending resident: Waul, Timothy Dante 12/08/2017 12/07/2018 0.00 N
3265-11208 2x1 1,049 1,351.00 1.29 Vacant - pending resident: Hancock, Rodney 12/22/2017 12/21/2018 0.00 N
3265-11303 2x1 1,049 1,351.00 1.29 Vacant - pending resident: Jones, Shernita Ann 12/20/2017 12/19/2018 0.00 N
3265-11308 2x1 1,049 1,351.00 1.29 Vacant - pending resident: Johnson, Jennise 12/15/2017 12/14/2018 0.00 N
3300-9101 2x1 1,049 1,351.00 1.29 1,351.00 1.29 Olds, Teresa yvonne 09/28/2017 09/28/2017 09/27/2018 0.00 N
3300-9106 2x1 1,049 1,351.00 1.29 1,351.00 1.29 Carr, Shanti Renee 08/21/2017 08/21/2017 08/20/2018 0.00 N
3300-9201 2x1 1,049 1,351.00 1.29 1,351.00 1.29 Poindexter, Sharmika 09/25/2017 09/25/2017 09/24/2018 750.00 N
3300-9206 2x1 1,049 1,351.00 1.29 1,351.00 1.29 Holland, Anthony Delonte 09/01/2017 09/01/2017 08/31/2018 500.00 N
3300-9301 2x1 1,049 1,351.00 1.29 1,351.00 1.29 Mcgurty, Muna Hassen 09/01/2017 09/01/2017 08/30/2018 0.00 N
3300-9306 2x1 1,049 1,351.00 1.29 1,351.00 1.29 Farmer, Tawanna Geneiva 09/29/2017 09/29/2017 10/01/2018 0.00 N
12 total for: 2x1 12,588 16,212.00 1.29 9,457.00 1.29 7,343 occupied SQFT
3265-11101 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Long, Shelia 11/21/2017 11/21/2017 11/20/2018 500.00 N
3265-11102 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Brown, Monique Simone 10/18/2017 10/18/2017 10/17/2018 500.00 N
3265-11104 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Anderson, Jacqueline 12/01/2017 12/01/2017 12/01/2018 500.00 N
3265-11105 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Coates, Brenda 11/27/2017 11/27/2017 11/26/2018 500.00 N
3265-11106 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Mayo, Dominique Nicole 12/02/2017 12/02/2017 12/01/2018 0.00 N
3265-11107 2x2 1,049 1,351.00 1.29 Vacant - pending resident: Thompson, Justin Carlos 12/08/2017 12/07/2018 0.00 N
3265-11201 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Yates, Kesha LaJuan 10/26/2017 10/26/2017 10/25/2018 750.00 N
3265-11202 2x2 1,049 1,351.00 1.29 Vacant - pending resident: Gerald, Christian 12/22/2017 12/21/2018 0.00 N
3265-11204 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Epkin, Devirge Aileen 11/10/2017 11/10/2017 11/09/2018 0.00 N
3265-11205 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Pratt, Brittany Nashae 11/27/2017 11/27/2017 11/26/2018 750.00 N
3265-11206 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Riley, Tameka 11/21/2017 11/21/2017 11/20/2018 750.00 N
3265-11207 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Barber, Tamara 12/02/2017 12/02/2017 12/01/2018 500.00 N
3265-11301 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Saunders, Jaleesha Monet 11/01/2017 11/01/2017 10/31/2018 0.00 N
3265-11302 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Banks, Christina 11/02/2017 11/02/2017 11/01/2018 0.00 N
3265-11304 2x2 1,049 1,351.00 1.29 Vacant - pending resident: Hanks, Ron Renorde 12/22/2017 12/21/2019 0.00 N
3265-11305 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Rust, Elizabeth 11/24/2017 11/24/2017 11/23/2018 0.00 N
3265-11306 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Luke, Timothy darrell 12/01/2017 12/01/2017 11/30/2018 0.00 N
3265-11307 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Lewis, Kenja Jenay 11/24/2017 11/24/2017 11/23/2018 0.00 N
3300-9102 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Clark, Landon 08/18/2017 08/18/2017 08/17/2018 750.00 N
3300-9103 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Jones, Kyana 09/01/2017 09/01/2017 08/30/2018 0.00 N
3300-9104 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Baker, Shekia 08/18/2017 08/18/2017 08/17/2018 750.00 N
3300-9105 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Turner, Lydia Denise 09/08/2017 09/08/2017 09/07/2018 500.00 N
3300-9107 2x2 1,049 1,351.00 1.29 1,351.00 1.29 O`connor, Deborah 08/18/2017 08/18/2017 08/09/2018 0.00 N
3300-9108 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Harris, Tina 09/01/2017 09/01/2017 08/31/2018 750.00 N
3300-9202 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Smith, Tracy 08/25/2017 08/25/2017 08/24/2018 0.00 N
3300-9203 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Holmes, Tamera La Juan 08/08/2017 08/08/2017 08/07/2018 0.00 N
3300-9204 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Petty, Kiesha 08/04/2017 08/04/2017 08/03/2018 0.00 N
3300-9205 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Gardner, Qiara Tamar 09/29/2017 09/29/2017 09/28/2018 500.00 N
3300-9207 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Shakespeare, Brittany 09/01/2017 09/01/2017 08/17/2018 750.00 N
3300-9208 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Ellis, Charlotte Denise 08/21/2017 08/21/2017 08/20/2018 0.00 N
3300-9302 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Morsell, Sharnae Patrice 08/25/2017 08/25/2017 08/24/2018 0.00 N
3300-9303 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Adusei, Prince George 09/01/2017 09/01/2017 08/31/2018 500.00 N
3300-9304 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Tyler, Brandi 08/17/2017 08/17/2017 08/16/2018 750.00 N
3300-9305 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Tolson, Erin deneane 09/06/2017 09/06/2017 09/05/2018 0.00 N
3300-9307 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Sinclair, Selma 09/02/2017 09/02/2017 09/01/2018 0.00 N
3300-9308 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Briscoe, Jessica Renee 08/11/2017 08/11/2017 08/10/2018 0.00 N
12375-10102 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Berdikhalov, Bakhrom 09/29/2017 09/29/2017 09/28/2018 0.00 N
12375-10104 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Jacks, Tina 10/27/2017 10/27/2017 10/26/2018 0.00 N
12375-10105 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Mercer, Maria 09/15/2017 09/15/2017 09/14/2018 750.00 N
12375-10107 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Jordan, Michelle 09/29/2017 09/29/2017 09/28/2018 750.00 N
12375-10202 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Williams, Sherica 10/18/2017 10/18/2017 10/17/2018 749.00 N
12375-10204 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Smith, Erica 11/01/2017 11/01/2017 10/26/2018 0.00 N
12375-10205 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Jones, Monica Danielle 10/11/2017 10/11/2017 10/10/2018 0.00 N
12375-10207 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Phelps, Juanita grace 10/17/2017 10/17/2017 10/16/2018 500.00 N
12375-10302 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Cain, Shelly 10/13/2017 10/13/2017 10/12/2018 500.00 N
12375-10304 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Mobley, Tiara 09/29/2017 09/29/2017 09/28/2018 0.00 N
12375-10305 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Anderson, Anthony Terrance 09/29/2017 09/29/2017 08/25/2018 500.00 N
12375-10307 2x2 1,049 1,351.00 1.29 1,351.00 1.29 Holmes, Aaron Keith 09/29/2017 09/29/2017 09/28/2018 500.00 N
48 total for: 2x2 50,352 64,848.00 1.29 60,795.00 1.29 47,205 occupied SQFT
12375-10101 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Fofana, Haja Mabinty 09/01/2017 09/01/2017 08/31/2018 750.00 N
12375-10103 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Farmer, Joel; Sweetney, Tabitha 10/19/2017 10/19/2017 10/18/2018 0.00 N
12375-10106 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Mcleod-Oredugba, Tonicia Lucind 08/22/2017 08/22/2017 08/21/2018 0.00 N
12375-10108 3x2 1,220 1,565.00 1.28 1,565.00 1.28 McRae, Tyrell 11/06/2017 11/06/2017 11/05/2018 0.00 N
12375-10201 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Cook, Bianca Denice 08/25/2017 08/25/2017 08/24/2018 750.00 N
12375-10203 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Jones, Teaira 08/26/2017 08/26/2017 08/25/2018 750.00 N
12375-10206 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Hancock, David C 09/01/2017 09/01/2017 08/20/2018 0.00 N
12375-10208 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Dixon, Sharonda 11/09/2017 11/09/2017 11/08/2018 500.00 N
12375-10301 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Lennon, Lisha 09/01/2017 09/01/2017 08/19/2018 0.00 N
12375-10303 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Carmichael, Nella 11/01/2017 11/01/2017 10/05/2018 0.00 N
12375-10306 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Beamon, Remy Jeremiah 09/08/2017 09/08/2017 09/07/2018 500.00 N
12375-10308 3x2 1,220 1,565.00 1.28 1,565.00 1.28 Banks, Jonathan christopher 08/26/2017 08/26/2017 08/25/2018 500.00 N
12 total for: 3x2 14,640 18,780.00 1.28 18,780.00 1.28 14,640 occupied SQFT
72 total for property: 77,580 99,840.00 1.29 89,032.00 1.29 69,188 total occupied SQFT
Floorplan Total Units # Units Occ. Phys. Occ. % Avg. SQFT Occ. SQFT Total SQFT Avg. Market Rent Market Amt/SQFT Avg. Lease Lease Amt/SQFT Tot. Market rent Tot. Lease Rent Loss to Lease Made Ready Not Ready Unavailable
Admin Down
2x1 12 7 58.33 1,049 7,343 12,588 1,351.00 1.29 1,351.00 1.29 16,212.00 9,457.00 0.00 0 5 0 0
2x2 48 45 93.75 1,049 47,205 50,352 1,351.00 1.29 1,351.00 1.29 64,848.00 60,795.00 0.00 0 3 0 0
3x2 12 12 100.00 1,220 14,640 14,640 1,565.00 1.28 1,565.00 1.28 18,780.00 18,780.00 0.00 0 0 0 0
Total: 72 64 88.89 1,078 69,188 77,580 1,386.67 1.29 1,391.13 1.29 99,840.00 89,032.00 0.00 0 8 0 0
Physical Occupancy Excluding Unavailable Including Unavailable
Occupied % Vacant % Total Occupancy %
SQFT 69,188 89.18 8,392 10.82 77,580 Include Vacant Leased 100.00 100.00
Unit Count 64 88.89 8 11.11 72 Exclude Vacant Leased 88.89 88.89
Total Leased Admin/ Down Total Available
Exposure to Vacancy Number % Vacant Units Make Ready Status
Moves/Transfers Number %
Currently Vacant Units 8 11.11 December In 5 Ready 0 0.00 0 0 0
Less Vacant Leased (8) 11.11 December Out 0 Not Ready 8 100.00 8 0 0
Plus Occupied On Notice 0 0.00
Less Occupied Pre-leased 0 0.00 Total Vacant Units 8 100.00 -8 0 0
Net Exposure to Vacancy 0 0.00
Rental Rates Occupied Amt/SQFT % Vacant Amt/SQFT % Total Amt/SQFT %
Market Rent 89,032.00 1.29 89.17 10,808.00 1.29 10.83 99,840.00 1.29 100.00
Lease Rent 89,032.00 1.29 89.17 89,032.00 1.29 89.17
Loss to Lease 0.00 0.00 0.00 10,808.00 0.00