{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["EWB verwalten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"EWB verwalten","index":0,"n_rows":51,"n_cols":33,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,4,5,21],[26,5,26,17],[27,6,28,6],[27,14,28,17],[9,5,9,13],[9,14,9,17],[10,6,11,6],[10,17,11,17],[32,14,32,17],[33,14,33,17],[34,14,34,17],[29,14,29,17],[30,14,30,17],[31,14,31,17],[35,14,35,17],[40,14,40,17],[36,14,36,17],[37,14,37,17],[38,14,38,17],[39,14,39,17]]}
[]
[]
[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,"Jahr","Monat","Tag","Jahr","Monat","Tag"]
[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,{"$f":"+YEAR(#REF!)","v":{"$error":"#REF!"}},{"$f":"+MONTH(#REF!)","v":{"$error":"#REF!"}},{"$f":"+DAY(#REF!)","v":{"$error":"#REF!"}},{"$f":"+AB4-1","v":{"$error":"#REF!"}},{"$f":"+AC4","v":{"$error":"#REF!"}},{"$f":"+AD4","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,"Einzelwertberichtigungen verwalten"]
[]
[null,null,null,null,null,"Abschlussjahr:",null,2018]
[]
[null,null,null,null,null,{"$f":"+IF($H$8=\"\",\"Werte aus Vorhahr\",\"Werte von \"&$H$8-1)","v":"Werte von 2017"},null,null,null,null,null,null,null,null,{"$f":"+IF($H$8=\"\",\"Werte aus aktuellem Jahr\",\"Werte von \"&$H$8)","v":"Werte von 2018"}]
[null,null,null,null,null,"Debi-","Name","Anspruch","Buchwert","Zahlungen","Zusätzliche","Verzugs-","EWB","Saldo","Kosten und","Weitere Ab-","Bewertung","Gründe für Abwertungen"]
[null,null,null,null,null,"tor",null,"fällig seit",{"$f":"+IF($H$8=\"\",\"Vorjahr\",$H$8-1)","v":2017},{"$f":"IF($H$8=\"\",\"Vorjahr\",\" \"&$H$8-1)","v":" 2017"},{"$f":"+IF($H$8=\"\",\"Kosten\",\"Kosten \"&$H$8-1)","v":"Kosten 2017"},{"$f":"+IF($H$8=\"\",\"zinsen\",\"zinsen \"&$H$8-1)","v":"zinsen 2017"},{"$f":"+IF($H$8=\"\",\"\"\"Vorjahr\",+$H$8-1)","v":2017},{"$f":"IF($H$8=\"\",\"Vorjahr\",+\"Ende \"&$H$8-1)","v":"Ende 2017"},{"$f":"+IF($H$8=\"\",\"Zinsen\",\"Zinsen \"&$H$8)","v":"Zinsen 2018"},{"$f":"IF($H$8=\"\",\"wertung\",+\"wertung \"&$H$8)","v":"wertung 2018"},{"$f":"+IF($H$8=\"\",\"Jahr\",$H$8)","v":2018}]
[null,null,null,null,null,"4711","Müller GmbH","2018-02-13",35000,5000,0,0,0,{"$f":"+IF(F13=\"\",\"\",SUM(I13,-J13,K13:L13,-M13))","v":30000},1000,16000,{"$f":"IF(ISERROR(N13+O13-P13),\"\",N13+O13-P13)","v":15000},"drohender Konkurs"]
[null,null,null,null,null,4712,"Meier OHG","2018-06-14",20000,5000,100,200,0,15300,250,5550,{"$f":"IF(ISERROR(N14+O14-P14),\"\",N14+O14-P14)","v":10000},"Vergleich"]
[null,null,null,null,null,4713,"Schulze GmbH & KO","2018-09-25",16500,0,0,0,6500,10000,0,5000,5000,"Mahnbescheid"]
[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,{"$f":"+IF($H$8=\"\",\"Abwertungen aus Vorjahr und Jahr\",\"Abwertungen für \"&$H$8-1&\" und \"&$H$8)","v":"Abwertungen für 2017 und 2018"},null,null,{"$f":"SUM(I13:I23)","v":71500},10000,100,200,6500,55300,1250,26550,30000]
[]
[]
[null,null,null,null,null,{"$f":"+IF(H8=\"\",\"Werte ausschließlich aus aktuellem Jahr\",\"Werte ausschließlich von \"&H8)","v":"Werte ausschließlich von 2018"}]
[null,null,null,null,null,"Debitoren-","Name","Anspruch","Buchwert","Zahlungen","Zusätzliche","Verzugs-","EWB","Saldo","Gründe für Abwertungen"]
[null,null,null,null,null,"Nummern",null,"fällig seit",{"$f":"+IF($H$8=\"\",\"Vorjahr\",$H$8)","v":2018},{"$f":"IF($H$8=\"\",\"Vorjahr\",\" \"&$H$8)","v":" 2018"},{"$f":"+IF($H$8=\"\",\"Kosten\",\"Kosten \"&$H$8)","v":"Kosten 2018"},{"$f":"+IF($H$8=\"\",\"zinsen\",\"zinsen \"&$H$8)","v":"zinsen 2018"},{"$f":"+IF($H$8=\"\",\"\"\"Vorjahr\",+$H$8)","v":2018},{"$f":"IF($H$8=\"\",\"Vorjahr\",+\"Ende \"&$H$8)","v":"Ende 2018"}]
[null,null,null,null,null,"123","Silbereisen Gbr.","2018-04-01",50000,0,1000,500,{"$f":"23250+5000","v":28250},{"$f":"+IF(F30=\"\",\"\",SUM(I30,-J30,K30:L30,-M30))","v":23250},"Vergleich"]
[null,null,null,null,null,"124","Müller KG","2018-06-08",40000,0,0,250,16100,24150,"Vergleich"]
[null,null,null,null,null,"125","Neumann GmbH","2018-09-12",25000,0,0,250,24000,1250,"Konkurs"]
[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,{"$f":"+IF($H$8=\"\",\"Abwertungen aktuellem Jahr\",\"Abwertungen für \"&$H$8)","v":"Abwertungen für 2018"},null,null,{"$f":"SUM(I30:I40)","v":115000},0,1000,1000,68350,48650]
[]
[null,null,null,null,null,"Zusammenfassung",null,null,{"$f":"+IF(H8=\"\",\"Vorjahr\",H8-1)","v":2017},{"$f":"+IF(H8=\"\",\"Jahr\",H8)","v":2018},"Summen"]
[null,null,null,null,null,"Buchwerte",null,null,{"$f":"+I24","v":71500},{"$f":"+I41","v":115000},{"$f":"+SUM(I44:J44)","v":186500}]
[null,null,null,null,null,"Zahlungen",null,null,{"$f":"+J24","v":10000},{"$f":"+J41","v":0},{"$f":"+SUM(I45:J45)","v":10000}]
[null,null,null,null,null,"Kosten und Zinsen",null,null,{"$f":"SUM(K24:L24)","v":300},{"$f":"SUM(K41:L41)+O24","v":3250},{"$f":"+SUM(I46:J46)","v":3550}]
[null,null,null,null,null,"Neue Forderungssumme",null,null,{"$f":"+I44-I45+I46","v":61800},{"$f":"+J44-J45+J46","v":118250},{"$f":"+SUM(I47:J47)","v":180050}]
[]
[null,null,null,null,null,"EWB",null,null,{"$f":"+M24","v":6500},{"$f":"+M41+P24","v":94900},{"$f":"+SUM(I49:J49)","v":101400}]
[]
[null,null,null,null,null,"Summe wertberichtigter Forderungen",null,null,{"$f":"+I47-I49","v":55300},{"$f":"+J47-J49","v":23350},{"$f":"+SUM(I51:J51)","v":78650}]