{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Mieterspiegel","Dropdown"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Mieterspiegel","index":0,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,2,1,5],[3,2,3,5]]}
[]
["Mieterspiegel Liegenschaft",null,"5-Fam. Wohnhaus MFH Strehlgasse 10, 6430 Schwyz",null,null,null,null,null,null,"Mieterspiegel vom",{"$f":"TEXT(TODAY(),\"tt.MM.jjjj\")","v":"15.03.2022"}]
[]
["Eigentümer",null,"Felix Muster, Gassenweg 10, 6430 Schwyz"]
[]
["Objekt-Nr. *)","Nutzungsart","Objektbezeichnung","Etage","Fläche m2","Typ/Fläche *)","Name Mieter","Leerstand","Mietverhältnis/Leerstand\ngültig ab","Nettomiete p.M.","NK-Akonto p.M.","Nettomietertrag p.a.","Bruttomiete p.M.","Bruttomietertrag p.a."]
["EG01","Wohnen","4.5 Zimmerwohnung","1.OG",119,"NWF","Hans Muster","Nein","2017-12-01",1550,250,{"$f":"IF(J7=0,\"\",J7*12)","v":18600},{"$f":"IF(J7=0,\"\",J7+K7)","v":1800},{"$f":"IF(J7=0,\"\",M7*12)","v":21600}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=0,\"\",J8*12)","v":""},{"$f":"IF(J8=0,\"\",J8+K8)","v":""},{"$f":"IF(J8=0,\"\",M8*12)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"Total p.a. (vermietet)",{"$f":"SUM(J7:J22)","v":1550},{"$f":"SUM(K7:K22)","v":250},{"$f":"SUM(L7:L22)","v":18600},{"$f":"SUM(M7:M22)","v":1800},21600]
["*) Bei diesen Feldern handelt es sich um freiwillige Angaben. Die anderen Spalten sind Pflichtfelder."]
[]
[null,"Zusammenzug","Bruttomietertrag p.a.",null,"Nettomietertrag p.a."]
[]
[null,"Wohnen",{"$f":"SUMIF(B7:B22,\"Wohnen\",N7:N22)","v":21600},null,{"$f":"SUMIF(B7:B22,\"Wohnen\",L7:L22)","v":18600}]
[null,"Büro",{"$f":"SUMIF(B7:B22,\"Büro\",N7:N22)","v":0},null,{"$f":"SUMIF(B7:B22,\"Büro\",L7:L22)","v":0}]
[null,"Verkauf",{"$f":"SUMIF(B7:B22,\"Verkauf\",N7:N22)","v":0},null,{"$f":"SUMIF(B7:B22,\"Verkauf\",L7:L22)","v":0}]
[null,"Gewerbe/Industrie",{"$f":"SUMIF(B7:B22,\"Gewerbe/Industrie\",N7:N22)","v":0},null,{"$f":"SUMIF(B7:B22,\"Gewerbe/Industrie\",L7:L22)","v":0}]
[null,"Lager",{"$f":"SUMIF(B7:B22,\"Lager\",N7:N22)","v":0},null,{"$f":"SUMIF(B7:B22,\"Lager\",L7:L22)","v":0}]
[null,"Gastronomie",{"$f":"SUMIF(B7:B22,\"Gastronomie\",N7:N22)","v":0},null,{"$f":"SUMIF(B7:B22,\"Gastronomie\",L7:L22)","v":0}]
[null,"Nebennutzen innen",{"$f":"SUMIF(B7:B22,\"Nebennutzen innen\",N7:N22)","v":0},null,{"$f":"SUMIF(B7:B22,\"Nebennutzen innen\",L7:L22)","v":0}]
[null,"Parken innen",{"$f":"SUMIF(B7:B22,\"Parken innen\",N7:N22)","v":0},null,{"$f":"SUMIF(B7:B22,\"Parken innen\",L7:L22)","v":0}]
[null,"Parken aussen",{"$f":"SUMIF(B7:B22,\"Parken aussen\",N7:N22)","v":0},null,{"$f":"SUMIF(B7:B22,\"Parken aussen\",L7:L22)","v":0}]
[null,"Sondernutzung",{"$f":"SUMIF(B7:B22,\"Sondernutzung\",N7:N22)","v":0},null,{"$f":"SUMIF(B7:B22,\"Sondernutzung\",L7:L22)","v":0}]
[]
[null,"Total Ist-Mietertrag",{"$f":"SUM(C28:C38)","v":21600},null,{"$f":"SUM(E28:E38)","v":18600},{"$f":"E39/E43","v":1},"vermietet"]
[]
[null,"Leerstand",{"$f":"SUMIF(H7:H22,\"ja\",N7:N22)","v":0},null,{"$f":"SUMIF(H7:H22,\"ja\",L7:L22)","v":0},{"$f":"E41/E43","v":0},"Leerstände"]
[]
[null,"Total Soll-Mietertrag",{"$f":"C41+C39","v":21600},null,{"$f":"E41+E39","v":18600},1]
[]
[]
[]
[null,"Ort/Datum:"]
[]
[]
[]
[null,"Unterschrift:"]

{"sheet":"Dropdown","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Wohnen",null,"NWF",null,"Ja"]
["Büro",null,"BGF",null,"Nein"]
["Verkauf",null,"Andere"]
["Gewerbe/Industrie"]
["Lager"]
["Gastronomie"]
["Nebennutzen innen"]
["Parken innen"]
["Parken aussen"]
["Sondernutzung"]