{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Aktuell"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Tabelle1","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Buchungsart","Datum","lfdNr.Berechn.","lfdNr.Anz."]
[]
[]
[null,null,1,{"$f":"C4","v":1}]
[2,"2025-05-24",{"$f":"IF(AND(A4=\"\",A5<>0),D4+1,IF(AND(A5=\"\",B5<>0),D4+1,IF(AND(A5=1,B5<>0),D4,IF(AND(A5=2,A4=1),D4+1,IF(AND(A4=2,B5<>0),D4,IF(AND(A5=2,A4=2),D4,\"\"))))))","v":2},{"$f":"C5","v":2}]
[2,"2025-05-24",{"$f":"IF(AND(A5=\"\",A6<>0),D5+1,IF(AND(A6=\"\",B6<>0),D5+1,IF(AND(A6=1,B6<>0),D5,IF(AND(A6=2,A5=1),D5+1,IF(AND(A5=2,B6<>0),D5,IF(AND(A6=2,A5=2),D5,\"\"))))))","v":2},2]
[null,"2025-05-24",{"$f":"IF(AND(A6=\"\",A7<>0),D6+1,IF(AND(A7=\"\",B7<>0),D6+1,IF(AND(A7=1,B7<>0),D6,IF(AND(A7=2,A6=1),D6+1,IF(AND(A6=2,B7<>0),D6,IF(AND(A7=2,A6=2),D6,\"\"))))))","v":3},3]
[null,null,null,0]
[null,null,null,0]

{"sheet":"Aktuell","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Buchungsart","Datum","lfdNum"]
[]
[]
[null,null,1]
[null,null,{"$f":"IF(AND(A4=\"\",A5<>0),C4+1,IF(AND(A5=\"\",B5<>0),C4+1,IF(AND(A5=1,B5<>0),C4,IF(AND(A5=2,A4=1),C4+1,IF(AND(A4=2,B5<>0),C4,IF(AND(A5=2,A4=2),C4,\"\"))))))","v":""},null,null,"Erläuterung zur Buchungsart"]
[null,null,{"$f":"IF(AND(A5=\"\",A6<>0),C5+1,IF(AND(A6=\"\",B6<>0),C5+1,IF(AND(A6=1,B6<>0),C5,IF(AND(A6=2,A5=1),C5+1,IF(AND(A5=2,B6<>0),C5,IF(AND(A6=2,A5=2),C5,\"\"))))))","v":""},null,null,"keine Eingabe: normale Einzelbuchung"]
[null,null,"",null,null,"\"1\": Umbuchung zwischen zwei Geldkonten, belegt zwei Zeilen"]
[null,null,{"$f":"IF(AND(A7=\"\",A8<>0),C7+1,IF(AND(A8=\"\",B8<>0),C7+1,IF(AND(A8=1,B8<>0),C7,IF(AND(A8=2,A7=1),C7+1,IF(AND(A7=2,B8<>0),C7,IF(AND(A8=2,A7=2),C7,\"\"))))))","v":""},null,null,"\"2\": Splittbuchung, belegt mind. Zwei Zeilen"]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]