{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Kontoauszug"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Kontoauszug","index":0,"n_rows":48,"n_cols":6,"rows_kept":48,"merged":[[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[47,0,47,4]]}
["Musterfirma GmbH"]
["Musterstraße 12",null,null,"Auszugsdatum",{"$f":"TODAY()","v":"2026-02-10"}]
["26122 Oldenburg",null,null,"Fälligkeitsdatum","2026-02-24"]
["+49 441 123456"]
[]
["Kontoauszug"]
["Max Mustermann"]
["Beispielweg 8"]
["10115 Berlin"]
["Datum","Beschreibung","Abbuchungen","Einzahlungen","Kontostand"]
[]
[null,"Übertrag",null,null,850]
[]
["2026-01-11","Rechnung #2026-001 (Webdesign)",490,0,{"$f":"IF(AND(A14=\"\",B14=\"\",C14=\"\",D14=\"\"),\"\", $E$12 + N(C14) - N(D14))","v":1340},{"$f":"IF(AND(A14=\"\",B14=\"\",C14=\"\",D14=\"\"),$E$12,$E$12 + N(C14) - N(D14))","v":1340}]
["2026-01-16","Zahlungseingang (Überweisung)",0,200,{"$f":"IF(AND(A15=\"\",B15=\"\",C15=\"\",D15=\"\"),\"\", E14 + N(C15) - N(D15))","v":1140},{"$f":"IF(AND(A15=\"\",B15=\"\",C15=\"\",D15=\"\"),F14,F14 + N(C15) - N(D15))","v":1140}]
["2026-01-19","Rechnung #2026-002 (Wartung)",120,0,{"$f":"IF(AND(A16=\"\",B16=\"\",C16=\"\",D16=\"\"),\"\", E15 + N(C16) - N(D16))","v":1260},{"$f":"IF(AND(A16=\"\",B16=\"\",C16=\"\",D16=\"\"),F15,F15 + N(C16) - N(D16))","v":1260}]
["2026-01-21","Rechnung #2026-003 (SEO Audit)",350,0,{"$f":"IF(AND(A17=\"\",B17=\"\",C17=\"\",D17=\"\"),\"\", E16 + N(C17) - N(D17))","v":1610},{"$f":"IF(AND(A17=\"\",B17=\"\",C17=\"\",D17=\"\"),F16,F16 + N(C17) - N(D17))","v":1610}]
["2026-01-23","Zahlungseingang (PayPal)",0,300,{"$f":"IF(AND(A18=\"\",B18=\"\",C18=\"\",D18=\"\"),\"\", E17 + N(C18) - N(D18))","v":1310},{"$f":"IF(AND(A18=\"\",B18=\"\",C18=\"\",D18=\"\"),F17,F17 + N(C18) - N(D18))","v":1310}]
["2026-01-26","Rechnung #2026-004 (Hosting)",45,0,{"$f":"IF(AND(A19=\"\",B19=\"\",C19=\"\",D19=\"\"),\"\", E18 + N(C19) - N(D19))","v":1355},{"$f":"IF(AND(A19=\"\",B19=\"\",C19=\"\",D19=\"\"),F18,F18 + N(C19) - N(D19))","v":1355}]
["2026-01-29","Gutschrift (Kulanz)",0,25,{"$f":"IF(AND(A20=\"\",B20=\"\",C20=\"\",D20=\"\"),\"\", E19 + N(C20) - N(D20))","v":1330},{"$f":"IF(AND(A20=\"\",B20=\"\",C20=\"\",D20=\"\"),F19,F19 + N(C20) - N(D20))","v":1330}]
["2026-01-31","Rechnung #2026-005 (Content Paket)",280,0,{"$f":"IF(AND(A21=\"\",B21=\"\",C21=\"\",D21=\"\"),\"\", E20 + N(C21) - N(D21))","v":1610},{"$f":"IF(AND(A21=\"\",B21=\"\",C21=\"\",D21=\"\"),F20,F20 + N(C21) - N(D21))","v":1610}]
["2026-02-03","Zahlungseingang (Überweisung)",0,400,{"$f":"IF(AND(A22=\"\",B22=\"\",C22=\"\",D22=\"\"),\"\", E21 + N(C22) - N(D22))","v":1210},{"$f":"IF(AND(A22=\"\",B22=\"\",C22=\"\",D22=\"\"),F21,F21 + N(C22) - N(D22))","v":1210}]
["2026-02-05","Rechnung #2026-006 (Beratung)",150,0,{"$f":"IF(AND(A23=\"\",B23=\"\",C23=\"\",D23=\"\"),\"\", E22 + N(C23) - N(D23))","v":1360},{"$f":"IF(AND(A23=\"\",B23=\"\",C23=\"\",D23=\"\"),F22,F22 + N(C23) - N(D23))","v":1360}]
["2026-02-07","Zahlungseingang (Überweisung)",0,100,{"$f":"IF(AND(A24=\"\",B24=\"\",C24=\"\",D24=\"\"),\"\", E23 + N(C24) - N(D24))","v":1260},{"$f":"IF(AND(A24=\"\",B24=\"\",C24=\"\",D24=\"\"),F23,F23 + N(C24) - N(D24))","v":1260}]
["2026-02-09","Rechnung #2026-007 (Support)",60,0,{"$f":"IF(AND(A25=\"\",B25=\"\",C25=\"\",D25=\"\"),\"\", E24 + N(C25) - N(D25))","v":1320},{"$f":"IF(AND(A25=\"\",B25=\"\",C25=\"\",D25=\"\"),F24,F24 + N(C25) - N(D25))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A26=\"\",B26=\"\",C26=\"\",D26=\"\"),\"\", E25 + N(C26) - N(D26))","v":null},{"$f":"IF(AND(A26=\"\",B26=\"\",C26=\"\",D26=\"\"),F25,F25 + N(C26) - N(D26))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A27=\"\",B27=\"\",C27=\"\",D27=\"\"),\"\", E26 + N(C27) - N(D27))","v":null},{"$f":"IF(AND(A27=\"\",B27=\"\",C27=\"\",D27=\"\"),F26,F26 + N(C27) - N(D27))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A28=\"\",B28=\"\",C28=\"\",D28=\"\"),\"\", E27 + N(C28) - N(D28))","v":null},{"$f":"IF(AND(A28=\"\",B28=\"\",C28=\"\",D28=\"\"),F27,F27 + N(C28) - N(D28))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A29=\"\",B29=\"\",C29=\"\",D29=\"\"),\"\", E28 + N(C29) - N(D29))","v":null},{"$f":"IF(AND(A29=\"\",B29=\"\",C29=\"\",D29=\"\"),F28,F28 + N(C29) - N(D29))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A30=\"\",B30=\"\",C30=\"\",D30=\"\"),\"\", E29 + N(C30) - N(D30))","v":null},{"$f":"IF(AND(A30=\"\",B30=\"\",C30=\"\",D30=\"\"),F29,F29 + N(C30) - N(D30))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A31=\"\",B31=\"\",C31=\"\",D31=\"\"),\"\", E30 + N(C31) - N(D31))","v":null},{"$f":"IF(AND(A31=\"\",B31=\"\",C31=\"\",D31=\"\"),F30,F30 + N(C31) - N(D31))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A32=\"\",B32=\"\",C32=\"\",D32=\"\"),\"\", E31 + N(C32) - N(D32))","v":null},{"$f":"IF(AND(A32=\"\",B32=\"\",C32=\"\",D32=\"\"),F31,F31 + N(C32) - N(D32))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A33=\"\",B33=\"\",C33=\"\",D33=\"\"),\"\", E32 + N(C33) - N(D33))","v":null},{"$f":"IF(AND(A33=\"\",B33=\"\",C33=\"\",D33=\"\"),F32,F32 + N(C33) - N(D33))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A34=\"\",B34=\"\",C34=\"\",D34=\"\"),\"\", E33 + N(C34) - N(D34))","v":null},{"$f":"IF(AND(A34=\"\",B34=\"\",C34=\"\",D34=\"\"),F33,F33 + N(C34) - N(D34))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A35=\"\",B35=\"\",C35=\"\",D35=\"\"),\"\", E34 + N(C35) - N(D35))","v":null},{"$f":"IF(AND(A35=\"\",B35=\"\",C35=\"\",D35=\"\"),F34,F34 + N(C35) - N(D35))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A36=\"\",B36=\"\",C36=\"\",D36=\"\"),\"\", E35 + N(C36) - N(D36))","v":null},{"$f":"IF(AND(A36=\"\",B36=\"\",C36=\"\",D36=\"\"),F35,F35 + N(C36) - N(D36))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A37=\"\",B37=\"\",C37=\"\",D37=\"\"),\"\", E36 + N(C37) - N(D37))","v":null},{"$f":"IF(AND(A37=\"\",B37=\"\",C37=\"\",D37=\"\"),F36,F36 + N(C37) - N(D37))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A38=\"\",B38=\"\",C38=\"\",D38=\"\"),\"\", E37 + N(C38) - N(D38))","v":null},{"$f":"IF(AND(A38=\"\",B38=\"\",C38=\"\",D38=\"\"),F37,F37 + N(C38) - N(D38))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A39=\"\",B39=\"\",C39=\"\",D39=\"\"),\"\", E38 + N(C39) - N(D39))","v":null},{"$f":"IF(AND(A39=\"\",B39=\"\",C39=\"\",D39=\"\"),F38,F38 + N(C39) - N(D39))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A40=\"\",B40=\"\",C40=\"\",D40=\"\"),\"\", E39 + N(C40) - N(D40))","v":null},{"$f":"IF(AND(A40=\"\",B40=\"\",C40=\"\",D40=\"\"),F39,F39 + N(C40) - N(D40))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A41=\"\",B41=\"\",C41=\"\",D41=\"\"),\"\", E40 + N(C41) - N(D41))","v":null},{"$f":"IF(AND(A41=\"\",B41=\"\",C41=\"\",D41=\"\"),F40,F40 + N(C41) - N(D41))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A42=\"\",B42=\"\",C42=\"\",D42=\"\"),\"\", E41 + N(C42) - N(D42))","v":null},{"$f":"IF(AND(A42=\"\",B42=\"\",C42=\"\",D42=\"\"),F41,F41 + N(C42) - N(D42))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A43=\"\",B43=\"\",C43=\"\",D43=\"\"),\"\", E42 + N(C43) - N(D43))","v":null},{"$f":"IF(AND(A43=\"\",B43=\"\",C43=\"\",D43=\"\"),F42,F42 + N(C43) - N(D43))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A44=\"\",B44=\"\",C44=\"\",D44=\"\"),\"\", E43 + N(C44) - N(D44))","v":null},{"$f":"IF(AND(A44=\"\",B44=\"\",C44=\"\",D44=\"\"),F43,F43 + N(C44) - N(D44))","v":1320}]
[{"$nulls":4},{"$f":"IF(AND(A45=\"\",B45=\"\",C45=\"\",D45=\"\"),\"\", E44 + N(C45) - N(D45))","v":null},{"$f":"IF(AND(A45=\"\",B45=\"\",C45=\"\",D45=\"\"),F44,F44 + N(C45) - N(D45))","v":1320}]
[]
[{"$nulls":3},"Saldo (aktuell)",{"$f":"F45","v":1320}]
[{"$f":"IF($E$47>0,\"Offener Betrag: \"&$E$47&\" EUR. Bitte bis zum Fälligkeitsdatum überweisen.\",IF($E$47<0,\"Guthaben: \"&ABS($E$47)&\" EUR.\",\"Kontostand ausgeglichen.\"))","v":"Offener Betrag: 1320 EUR. Bitte bis zum Fälligkeitsdatum überweisen."}]