{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"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":"Sheet1","index":0,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,0,3,4],[7,0,7,4],[0,0,0,9],[17,0,17,2]]}
["23 West Main Rent Roll"]
[null,null,"Updated","2025-11-01"]
["Unit #","Aprox. Unit Size","Base Rate per S/F"," Monthly Base Rent","Monthly Additional Rent (NNN)","Monthly Total Rent","Annual Total Rent","Start Date","End Date","Options"]
["Net lease enter base rent in column D"]
[101,{"$f":"[1]Expenses!E5","v":1750},{"$f":"(D5/B5)*12","v":27.428571428571427},4000,{"$f":"[1]Expenses!G5","v":1191.6666666666667},{"$f":"SUM(D5:E5)","v":5191.666666666667},{"$f":"F5*12","v":62300},"2025-03-01","2035-02-28","none"]
["Basement",{"$f":"[1]Expenses!E6","v":600},{"$f":"(D6*12)/B6","v":0},null,{"$f":"'[2] EXPENSES'!G6","v":0},{"$f":"SUM(D6:E6)","v":0},{"$f":"F6*12","v":0}]
["TOTAL",{"$f":"SUM(B5:B6)","v":2350},{"$f":"(D7*12)/B7","v":20.425531914893618},{"$f":"SUM(D5:D6)","v":4000},{"$f":"SUM(E5:E6)","v":1191.6666666666667},{"$f":"SUM(F5:F6)","v":5191.666666666667},{"$f":"SUM(G5:G6)","v":62300}]
["Gross leases enter rent in column F"]
[201,{"$f":"[1]Expenses!E9","v":103},{"$f":"(D9/B9)*12","v":40.776699029126213},350,{"$f":"IF((D9>0),[1]Expenses!G9,0)","v":206},{"$f":"D9+E9","v":556},{"$f":"F9*12","v":6672},"2024-05-01","2025-04-30","carryover"]
[202,{"$f":"[1]Expenses!E10","v":281},12.811387900355871,300,{"$f":"IF((D10>0),[1]Expenses!G10,0)","v":532.16999999999996},{"$f":"D10+E10","v":832.17},{"$f":"F10*12","v":9986.0399999999991},"2025-01-01","2026-06-30","None"]
[203,{"$f":"[1]Expenses!E11","v":143},37.789930069930072,450.33,{"$f":"IF((D11>0),[1]Expenses!G11,0)","v":274.67},{"$f":"D11+E11","v":725},{"$f":"F11*12","v":8700},"2025-11-01","2026-10-31","None"]
[204,{"$f":"[1]Expenses!E12","v":105},59.314285714285717,519,{"$f":"IF((D12>0),[1]Expenses!G12,0)","v":206},{"$f":"D12+E12","v":725},{"$f":"F12*12","v":8700},"2025-11-01","2026-10-31","None"]
[205,{"$f":"[1]Expenses!E13","v":118},48.491186440677971,{"$f":"F13-E13","v":476.83000000000004},{"$f":"IF((F13>0),[1]Expenses!G13,0)","v":223.17},700,8400,"2022-03-01","M/M","None"]
[206,{"$f":"[1]Expenses!E14","v":144},18.134999999999998,217.62,{"$f":"IF((D14>0),[1]Expenses!G14,0)","v":274.67},{"$f":"D14+E14","v":492.29},5907.4800000000005,"2024-05-01","2025-04-30","carryover"]
["Pad",null,null,274.35000000000002,null,{"$f":"D15+E15","v":274.35000000000002},3292.2000000000003,"2010-08-01","2040-07-31","1-30Yr."]
["TOTAL",{"$f":"SUM(B9:B15)","v":894},null,{"$f":"SUM(D9:D15)","v":2588.1299999999997},{"$f":"SUM(E9:E15)","v":1716.68},{"$f":"SUM(F9:F15)","v":4304.8100000000004},{"$f":"SUM(G9:G15)","v":51657.72}]
["GRAND TOTAL",{"$f":"B7+B16","v":3244},null,{"$f":"SUM(D7,D16)","v":6588.1299999999992},{"$f":"SUM(E7,E16)","v":2908.3466666666668},{"$f":"SUM(F7,F16)","v":9496.4766666666674},{"$f":"SUM(G7,G16)","v":113957.72}]
["CURRENT NOI",null,null,{"$f":"D17*12","v":79057.56}]
[]
[null,null,null,"Enter current monthly rent"]