{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Apartment layout","P&L","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"Apartment layout","index":0,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,4,6,5],[9,4,9,5],[11,4,11,5],[0,4,1,20],[2,4,2,6],[2,8,2,16],[2,18,2,20],[3,7,4,7],[3,17,4,17],[31,0,31,1],[13,4,13,5],[15,4,15,5],[25,2,26,2],[30,0,30,1],[17,4,17,5]]}
["APT","Level","if paid before the 7th",null,"APARTMENT LAYOUT"]
[1,"B",{"$f":"G7","v":625}]
[2,"B",{"$f":"G7","v":625},null,"Building 1",null,null,null,"Building 2",{"$nulls":9},"Building 3"]
[3,"B",{"$f":"G7","v":625},null,4,5,6,null,11,12,13,"14A","14B",18,19,"20A","20B",null,24,25,26]
[4,"T",{"$f":"G7","v":625},null,1,2,3,null,7,8,9,"10A","10B",15,16,17,"LR",null,21,22,23]
[5,"T",{"$f":"G7","v":625}]
[6,"T",{"$f":"G7","v":625},null,"1 Bedroom",null,625,null,1,2,3,4,5,6,8,9,"10A"," ",12,13,"14A"]
[7,"B",{"$f":"G10","v":425},{"$nulls":5},15,16,17,18,19,"20A",25,26]
[8,"B",625]
[9,"B",{"$f":"G7","v":625},null,"Efficiency",null,425,null,7,"10B",11,"14B",21,24]
[10,"B",{"$f":"G7","v":625}]
["10B","B",{"$f":"G10","v":425},null,"Bigger Efficiency",null,450,null,"20B"]
[11,"T",{"$f":"G10","v":425}]
[12,"T",{"$f":"G7","v":625},null,"Laundry room",null,0,null,"LR"]
[13,"T",{"$f":"G7","v":625}]
[14,"T",{"$f":"G7","v":625},null,"2 bed room",null,925,null,"22 & 23"]
["14B","T",{"$f":"G10","v":425}]
[15,"B",625,null,"Used by managment",null,0,null,"15,20 &21"]
[16,"B",625]
[17,"B",{"$f":"G7","v":625}]
[18,"T",{"$f":"G7","v":625}]
[19,"T",{"$f":"G7","v":625}]
[20,"T",625,{"$nulls":7},"   "]
["20B","T",{"$f":"G12","v":450}]
[21,"B",425]
[22,"B",{"$f":"G16","v":925}]
[23,"B"]
[24,"T",{"$f":"G10","v":425}]
[25,"T",{"$f":"G7","v":625}]
[26,"T",{"$f":"G7","v":625}]
["TOTAL monthly",null,{"$f":"SUM(C2:C30)","v":16425}]
["TOTAL Yearly",null,{"$f":"C31*12","v":197100}]

{"sheet":"P&L","index":1,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[2026,"Budget total","Big electric 7-26","Small electric 1-6","GAS","Water","taxes","Insurance","Loss Total","Total"]
["Jan",10432,1277.8499999999999,497.28,755.06,906.11,773.88,720.11,{"$f":"SUM(C2:H2)","v":4930.2899999999991},{"$f":"B2-I2","v":5501.7100000000009}]
["Feb",12014,1353.54,492.26,688.11,906.99,773.88,720.11,{"$f":"SUM(C3:H3)","v":4934.8899999999994},7079.1100000000006]
["March",11125.54,749.72,242.11,503.5,906.11,773.88,720.71,3896.03,7229.51]
["April",10300.07,837.18,331.68,485.15,906.11,773.88,720.71,4054.71,6245.36]
["May",{"$nulls":7},0,0]
["June",{"$nulls":7},0,0]
["July",{"$nulls":7},0,0]
["Aug",{"$nulls":7},0,0]
["Sep",{"$nulls":7},0,0]
["Oct",{"$nulls":7},0,0]
["Nov",{"$nulls":7},0,0]
["Dec",{"$nulls":7},0,0]
["Total",{"$f":"SUM(B2:B13)","v":43871.61},{"$f":"SUM(C2:C13)","v":4218.29},1563.3300000000002,2431.8200000000002,3625.32,3095.52,2881.6400000000003,17815.919999999998,26055.690000000002]
[]
[2026,"JAN","Feb","March","April","May","June","July","Aug","Sep","Oct","Nov","Dec"]
["Vacant",9,7,8,9]
["Occupied",{"$f":"B20-B17-B19","v":16},{"$f":"C20-C17-C19","v":18},17,16]
["Used by management",3,3,3,3]
["Total",28,28,28,28]
{"$rows_empty":18}
[{"$nulls":7},"      "]

{"sheet":"Sheet1","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Apt","SM  ELEC CAL"]
[1,78.459999999999994]
[2,78.06]
[3,57.71]
[4,50.83]
[5,37.25]
[6,29.37]
["total",{"$f":"SUM(B2:B7)","v":331.68}]