{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Rent Roll","Instructions","Reference"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Rent Roll","index":0,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["Harvard Industrial Rent Roll"]
["4050 E 116th St Cleveland OH 44105"]
[]
["Unit ID","Description","Tenant Name","Square Feet","Lease Start","Lease End","Mo. Rent","Annual Rent","Rent/SF","Status","Sec Deposit","Lease Type","Notes"]
["Unit 1","Shops 1,2,3 +Offices","Ohio Art Landscaping",3568,"2024-11-01","2026-05-15",1750,{"$f":"G5*12","v":21000},{"$f":"H5/D5","v":5.88565022421525},"Vacant",1750,"Annual"]
["Unit 2","Central Offices","Ohio Art Landscaping",520,"2024-11-01","2026-05-15",300,{"$f":"G6*12","v":3600},{"$f":"H6/D6","v":6.92307692307692},"Vacant",300,"month to month"]
["Unit 3","Unit C – 2 rooms","Maryam M eBay bus.",530,"2025-08-16","2026-08-15",400,{"$f":"G7*12","v":4800},{"$f":"H7/D7","v":9.05660377358491},"Leased",400,"Annual"]
["Unit 4","Shop  4","Ohio Art Landscaping",885,"2025-08-16","2026-05-15",480,{"$f":"G8*12","v":5760},{"$f":"H8/D8","v":6.50847457627119},"Vacant",0,"month to month"]
["Unit 5","Shop 5","Allen Electric – Storage",2655,"2025-10-07","2026-09-06",900,{"$f":"G9*12","v":10800},{"$f":"H9/D9","v":4.06779661016949},"Leased",1600,"Annual"]
[]
["TOTALS",null,null,{"$f":"SUM(D5:D10)","v":8158},null,null,{"$f":"SUM(G5:G10)","v":3830},{"$f":"SUM(H5:H10)","v":45960},{"$f":"AVERAGE(I$5:I$9)","v":6.48832042146355},null,{"$f":"SUM(K5:K10)","v":4050}]
[]
[]
[]
[{"$nulls":11}," "]

{"sheet":"Instructions","index":1,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["RENT ROLL TEMPLATE - INSTRUCTIONS"]
[]
["HOW TO USE THIS TEMPLATE"]
[]
["1. UNIT ID","Enter the unit number, suite, or space identifier"]
["2. TENANT NAME","Enter tenant name, or \"Vacant\" for empty units"]
["3. SQUARE FEET","Enter the rentable square footage for the unit"]
["4. LEASE START","Enter lease commencement date (MM/DD/YYYY)"]
["5. LEASE END","Enter lease expiration date (MM/DD/YYYY)"]
["6. MONTHLY RENT","Enter base monthly rent amount"]
["7. ANNUAL RENT","Auto-calculated: Monthly Rent x 12"]
["8. RENT/SF","Auto-calculated: Annual Rent / Square Feet"]
["9. STATUS","Enter: Occupied, Vacant, or MTM (Month-to-Month)"]
["10. SECURITY DEPOSIT","Enter security deposit amount held"]
["11. LEASE TYPE","Enter: Gross, NNN, Modified Gross, or other"]
["12. NOTES","Any additional notes or comments"]
[]
["STATUS OPTIONS"]
["Occupied","Unit is leased and tenant is in place"]
["Vacant","Unit is available for lease"]
["MTM","Month-to-month lease (expired but continuing)"]
[]
["TIPS"]
["- Keep dates in consistent format (MM/DD/YYYY recommended)"]
["- Use numbers only for rent and sqft (no $ or commas)"]
["- The TOTALS row at the bottom auto-calculates"]
[]
["NEED HELP?"]
["Upload your completed rent roll to CleanRoll.ai for instant analysis,"]
["including occupancy metrics, lease rollover, and rent comparisons."]
["Visit: https://cleanroll.ai"]

{"sheet":"Reference","index":2,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["DATA VALIDATION OPTIONS"]
[]
["Status Options:"]
["Occupied"]
["Vacant"]
["MTM"]
[]
["Lease Type Options:"]
["Gross","Landlord pays operating expenses"]
["NNN","Tenant pays taxes, insurance, maintenance"]
["Modified Gross","Shared expense responsibility"]
["Full Service","All-inclusive rent"]
["Industrial Gross","Common for warehouse/industrial"]