{"text_format":"3","workbook":"xlsx","n_sheets":16,"sheets":["S. 1","S. 2","S. 3","S. 4","S. 5","S. 6","S. 7","S. 8","S. 9","S. 10","S. 11","S. 12","S. ","Konten","Kunden","Lief."],"not_rendered":{"defined_names":85,"comments":16},"read":"whole","date_system":"1900"}

{"sheet":"S. 1","index":0,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$nulls":11},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-01-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"DATE(2000,Q1+1,0)","v":"2020-01-31"},241,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 1"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"1"}]
[]
["Monat:",{"$f":"P1","v":"2020-01-31"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-01-31"},{"v":1600,"d":" Konto Nr. 1600"},{"v":1,"d":"                          Seite  1"},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 1"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":1}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":1},{"$f":"L3","v":"2020-01-31"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",null,"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"DAY(L1)","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},{"v":806820,"d":"80 6820"},1,{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 2","index":1,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-02-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-01-31"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 2"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"2"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-02-29"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-02-29"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":2,"d":"                          Seite  2"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 2"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":2}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":2},{"$f":"L3","v":"2020-02-29"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 3","index":2,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-03-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-02-29"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 3"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"3"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-03-31"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-03-31"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":3,"d":"                          Seite  3"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 3"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":3}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":3},{"$f":"L3","v":"2020-03-31"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 4","index":3,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-04-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-03-31"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 4"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"4"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-04-30"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-04-30"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":4,"d":"                          Seite  4"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 4"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":4}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":4},{"$f":"L3","v":"2020-04-30"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 5","index":4,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-05-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-04-30"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 5"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"5"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-05-31"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-05-31"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":5,"d":"                          Seite  5"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 5"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":5}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":5},{"$f":"L3","v":"2020-05-31"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 6","index":5,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-06-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-05-31"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 6"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"6"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-06-30"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-06-30"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":6,"d":"                          Seite  6"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 6"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":6}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":6},{"$f":"L3","v":"2020-06-30"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 7","index":6,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-07-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-06-30"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 7"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"7"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-07-31"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-07-31"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":7,"d":"                          Seite  7"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 7"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":7}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":7},{"$f":"L3","v":"2020-07-31"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 8","index":7,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-08-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-07-31"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 8"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"8"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-08-31"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-08-31"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":8,"d":"                          Seite  8"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 8"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":8}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":8},{"$f":"L3","v":"2020-08-31"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 9","index":8,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-09-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-08-31"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 9"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"9"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-09-30"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-09-30"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":9,"d":"                          Seite  9"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 9"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":9}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":9},{"$f":"L3","v":"2020-09-30"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 10","index":9,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-10-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-09-30"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 10"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"10"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-10-31"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-10-31"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":10,"d":"                          Seite  10"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 10"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":10}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":10},{"$f":"L3","v":"2020-10-31"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 11","index":10,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-11-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-10-31"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 11"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"11"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-11-30"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-11-30"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":11,"d":"                          Seite  11"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 11"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":11}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":11},{"$f":"L3","v":"2020-11-30"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. 12","index":11,"n_rows":44,"n_cols":27,"rows_kept":44,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2020-12-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-11-30"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 12"},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":"12"}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2020-12-31"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2020},{"$f":"B3","v":"2020-12-31"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":12,"d":"                          Seite  12"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. 12"},{"$f":"MID(P3,SEARCH(\" \",P3)+1,3)*1","v":12}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":12},{"$f":"L3","v":"2020-12-31"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":""}]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"MIN('S. 1:S. '!K42)","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"S. ","index":12,"n_rows":44,"n_cols":27,"rows_kept":44,"hidden":true,"merged":[[0,0,0,4],[0,12,0,14],[2,1,2,4],[2,13,2,14]]}
[{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!A1\")","v":0},{"$nulls":10},{"$f":"DATE(YEAR(B3),MONTH(B3),1)","v":"2021-01-01"},"K  a  s  s  e  n  b  u  c  h",null,null,{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B3\")","v":"2020-12-31"},2,{"$nulls":7},{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. "},{"$f":"LEFT(Y1,SEARCH(\" \",Y1))","v":"S. "},{"$f":"RIGHT(Y1,LEN(Y1)-SEARCH(\" \",Y1))","v":""}]
[]
["Monat:",{"$f":"DATE(YEAR(P1),MONTH(P1)+Q1,0)","v":"2021-01-31"},{"$nulls":7},{"$f":"\"F\"&LARGE(IF(F8:F40<>\" \",ROW(F8:F40)),1)","v":"F8"},{"$f":"YEAR(L3)","v":2021},{"$f":"B3","v":"2021-01-31"},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!M3\")","v":{"v":1600,"d":" Konto Nr. 1600"}},{"$f":"IF(ISERROR(P3),1,IF(RIGHT(P3,1)=\")\",LEFT(RIGHT(P3,7),3)+1,Q3))","v":{"v":13,"d":"                          Seite  13"}},null,{"$f":"RIGHT(CELL(\"Dateiname\",A1),LEN(CELL(\"Dateiname\",A1))-FIND(\"]\",CELL(\"Dateiname\",A1)))","v":"S. "},{"$f":"IF(ISERROR(MID(P3,SEARCH(\" \",P3)+1,3)*1),Q4,MID(P3,SEARCH(\" \",P3)+1,3)*1)","v":13}]
[{"$nulls":10},{"$f":"MONTH(L4)","v":1},{"$f":"L3","v":"2021-01-31"},null,{"$f":"IF(ISERROR(P3),\"\",IF(AND(RIGHT(P3,2)<>TEXT(N3,\" #\"),RIGHT(P3,2)<>TEXT(N3,\"##\"),RIGHT(P3,3)<>TEXT(N3,\"###\")),\"Name Tabellenblatt ändern in ' S. \"&N3&\" ' \",\"\"))","v":"Name Tabellenblatt ändern in ' S. 13 ' "},null,null,13]
["Einnahmen","Ausgaben","Einnahmen","Bestand","Gegen-","Beleg-","Beleg-","USt.-","BU","Gegenkonto","Gegenkonto","Konto","Kontierung","Text","Skonto","Festschreibung"]
["€","€","Ausgaben",{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!B42\")","v":{"v":0,"d":"0.00"}},"konto","Nr.","Datum","Satz",null,"ASCII","ASCII"]
[{"$nulls":6},{"$f":"IF(MONTH(INDIRECT(\"'S. \"&N3-1&\"'!B3\"))=MONTH(B3),MAX(INDIRECT(\"'S. \"&N3-1&\"'!G7:G42\")),DAY(L1))","v":1}]
[null,null,{"$f":"A8-B8","v":{"v":0,"d":"0.00"}},{"$f":"D6+C8","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDIRECT(\"'S. \"&N3-1&\"'!A43\")=0,1,IF(ROUND(A41+B41,2)=0,INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\")),INDIRECT(\"'S. \"&N3-1&\"'!\"&INDIRECT(\"'S. \"&N3-1&\"'!J3\"))+1))","v":1},{"$nulls":5},{"$f":"$M$3","v":1600},{"$nulls":3},0]
[null,null,{"$f":"A9-B9","v":{"v":0,"d":"0.00"}},{"$f":"IF(ROUND(C9,2)=0,\"\",D8+C9)","v":""},null,{"$f":"IF(A9+B9=0,\" \",F8+1)","v":" "},{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(ROUND(C10,2)=0,\"\",D9+C10)","v":""},null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[null,null,{"v":0,"d":"0.00"},"",null," ",{"$nulls":5},1600,{"$nulls":3},0]
[{"$f":"SUM(A8:A40)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B8:B40)","v":{"v":0,"d":"0.00"}},null,"  Summen",{"$nulls":8}," Unterschrift:"]
[{"$f":"D6","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(\"D\"&COUNT(D8:D40)+7)","v":{"v":0,"d":"0.00"}},null,"  Bestand Anfang / Ende",{"$nulls":6},{"$f":"MIN(D8:D42)","v":{"v":0,"d":"0.00"}},null," geprüft:",{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]
[{"$f":"SUM(A41:A42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B41:B42)","v":{"v":0,"d":"0.00"}},null,"  Kontrollsummen",{"$nulls":6},{"$f":"INDIRECT(\"'S. \"&N3-1&\"'!K43\")","v":{"v":0,"d":"0.00"}},null," gebucht:"]
[{"$f":"IF(ROUND(A43-B43,2)<>0,\"Kassendifferenz !!!\",\"\")","v":""}]

{"sheet":"Konten","index":13,"n_rows":98,"n_cols":5,"rows_kept":98}
["Kontenplan SKR 04"]
["\" Stichwort  \"","Konto"]
[null,{"$f":"IF(YEAR('S. 1'!B3)<2007,16,19)","v":{"v":19,"d":"19%"}},{"$f":"IF(YEAR('S. 1'!B3)<2007,15,16)","v":{"v":16,"d":"16%"}},{"v":7,"d":"7%"},{"v":0,"d":"0%"}]
["Abfallbeseitigung",{"v":906859,"d":"90 6859"},{"$f":"B4-200000","v":{"v":706859,"d":"70 6859"}},"USt. ?",{"$f":"B4-800000","v":{"v":106859,"d":"10 6859"}}]
["Aufmerksamkeiten",{"v":906643,"d":"90 6643"},{"$f":"B5-200000","v":{"v":706643,"d":"70 6643"}},{"$f":"B5-100000","v":{"v":806643,"d":"80 6643"}},{"$f":"B5-800000","v":{"v":106643,"d":"10 6643"}}]
["Ausgangsfracht",{"v":906740,"d":"90 6740"},{"$f":"B6-200000","v":{"v":706740,"d":"70 6740"}},"USt. ?",{"v":106740,"d":"10 6740"}]
["Auszahlung Aushilfen","USt. ?","USt. ?","USt. ?",{"v":3720,"d":" 3720"}]
["Auszahlung Gehalt","USt. ?","USt. ?","USt. ?",{"v":3720,"d":" 3720"}]
["Auszahlung Lohn","USt. ?","USt. ?","USt. ?",{"v":3720,"d":" 3720"}]
["Bankeinzahlung","USt. ?","USt. ?","USt. ?",{"v":1460,"d":" 1460"}]
["Bargeld für Kasse","USt. ?","USt. ?","USt. ?",{"v":1460,"d":" 1460"}]
["Barverkauf",{"v":4400,"d":" 4400"},{"$f":"IF(C$3=15,504200,4340)","v":{"v":4340,"d":" 4340"}},{"v":4300,"d":" 4300"},{"v":4120,"d":" 4120"}]
["Barverkauf EG","USt. ?","USt. ?","USt. ?",{"v":4125,"d":" 4125"}]
["Benzin",{"v":906530,"d":"90 6530"},{"$f":"B14-200000","v":{"v":706530,"d":"70 6530"}},"USt. ?",{"v":106530,"d":"10 6530"}]
["Betriebsbedarf",{"v":906850,"d":"90 6850"},{"$f":"B15-200000","v":{"v":706850,"d":"70 6850"}},{"$f":"B15-100000","v":{"v":806850,"d":"80 6850"}},{"v":106850,"d":"10 6850"}]
["Bewirtungskosten",{"v":906640,"d":"90 6640"},{"$f":"B16-200000","v":{"v":706640,"d":"70 6640"}},{"$f":"B16-100000","v":{"v":806640,"d":"80 6640"}},{"v":106640,"d":"10 6640"}]
["Bewirtung in Geschäftsräumen",{"v":906641,"d":"90 6641"},{"$f":"B17-200000","v":{"v":706641,"d":"70 6641"}},{"$f":"B17-100000","v":{"v":806641,"d":"80 6641"}},{"$f":"B17-800000","v":{"v":106641,"d":"10 6641"}}]
["Bezugsnebenkosten",{"v":905800,"d":"90 5800"},{"v":705800,"d":"70 5800"},{"$f":"B18-100000","v":{"v":805800,"d":"80 5800"}},{"v":105800,"d":"10 5800"}]
["Bufü-Gebühren",{"v":906830,"d":"90 6830"},{"v":706830,"d":"70 6830"},"USt. ?",{"v":106830,"d":"10 6830"}]
["Bürobedarf",{"v":906815,"d":"90 6815"},{"v":706815,"d":"70 6815"},"USt. ?",{"v":106815,"d":"10 6815"}]
["Büromaterial",{"v":906815,"d":"90 6815"},{"v":706815,"d":"70 6815"},"USt. ?",{"v":106815,"d":"10 6815"}]
["Diesel",{"v":906530,"d":"90 6530"},{"v":706530,"d":"70 6530"},"USt. ?",{"v":106530,"d":"10 6530"}]
["Erlöse",{"v":4400,"d":" 4400"},{"$f":"IF(C$3=15,504200,4340)","v":{"v":4340,"d":" 4340"}},{"v":4300,"d":" 4300"},{"v":4120,"d":" 4120"}]
["Erlöse Abfallverw.",{"v":304510,"d":"30 4510"},{"v":504510,"d":"50 4510"},"USt. ?",{"v":104510,"d":"10 4510"}]
["Erlöse EG","USt. ?","USt. ?","USt. ?",{"v":4125,"d":" 4125"}]
["Fachliteratur",{"v":906820,"d":"90 6820"},{"v":706820,"d":"70 6820"},{"$f":"B26-100000","v":{"v":806820,"d":"80 6820"}},{"v":106820,"d":"10 6820"}]
["Fahrtk.Wohng./Betrieb","USt. ?","USt. ?","USt. ?",{"v":6090,"d":" 6090"}]
["Fortbildungskosten",{"v":906821,"d":"90 6821"},{"v":706821,"d":"70 6821"},{"$f":"B28-100000","v":{"v":806821,"d":"80 6821"}},{"$f":"B28-800000","v":{"v":106821,"d":"10 6821"}}]
["Freiwillige Sozialleistungen",{"v":906822,"d":"90 6822"},{"v":706822,"d":"70 6822"},{"$f":"B29-100000","v":{"v":806822,"d":"80 6822"}},{"$f":"B29-800000","v":{"v":106822,"d":"10 6822"}}]
["Fremdarbeiten",{"v":906780,"d":"90 6780"},{"v":706780,"d":"70 6780"},{"$f":"B30-100000","v":{"v":806780,"d":"80 6780"}},{"v":106780,"d":"10 6780"}]
["Garagenmiete",{"v":906550,"d":"90 6550"},{"v":706550,"d":"70 6550"},"USt. ?",{"v":106550,"d":"10 6550"}]
["Gas",{"v":906325,"d":"90 6325"},{"v":706325,"d":"70 6325"},"USt. ?",{"v":106325,"d":"10 6325"}]
["Gebühren, sonst.Abgaben",{"v":906430,"d":"90 6430"},{"v":706430,"d":"70 6430"},"USt. ?",{"v":106430,"d":"10 6430"}]
["Geldtransit","USt. ?","USt. ?","USt. ?",{"v":1460,"d":" 1460"}]
["Geschenk bis 35,- €",{"v":906610,"d":"90 6610"},{"v":706610,"d":"70 6610"},{"$f":"B35-100000","v":{"v":806610,"d":"80 6610"}},{"v":106610,"d":"10 6610"}]
["Geschenk über 35,- €",{"v":906620,"d":"90 6620"},{"v":706620,"d":"70 6620"},{"$f":"B36-100000","v":{"v":806620,"d":"80 6620"}},{"v":106620,"d":"10 6620"}]
["GWG bis 800 €",{"v":900670,"d":"90 0670"},{"v":700670,"d":"70 0670"},{"$f":"B37-100000","v":{"v":800670,"d":"80 0670"}},{"v":100670,"d":"10 0670"}]
["GWG (Sammelpsten)",{"v":900675,"d":"90 0675"},{"v":700675,"d":"70 0675"},{"$f":"B38-100000","v":{"v":800675,"d":"80 0675"}},{"v":100675,"d":"10 0675"}]
["Heizkosten",{"v":906320,"d":"90 6320"},{"v":706320,"d":"70 6320"},"USt. ?",{"v":106320,"d":"10 6320"}]
["Instandh.Betriebsräume",{"v":906335,"d":"90 6335"},{"v":706335,"d":"70 6335"},"USt. ?",{"v":106335,"d":"10 6335"}]
["Instandh.BGA",{"v":906470,"d":"90 6470"},{"v":706470,"d":"70 6470"},"USt. ?",{"v":106470,"d":"10 6470"}]
["Instandh.Maschinen",{"v":906460,"d":"90 6460"},{"v":706460,"d":"70 6460"},"USt. ?",{"v":106460,"d":"10 6460"}]
["Kfz-Reparaturen",{"v":906540,"d":"90 6540"},{"v":706540,"d":"70 6540"},"USt. ?",{"v":106540,"d":"10 6540"}]
["Kfz-Versicherungen","USt. ?","USt. ?","USt. ?",{"v":6520,"d":" 6520"}]
["Kleingeräte",{"v":906845,"d":"90 6845"},{"v":706845,"d":"70 6845"},{"$f":"B45-100000","v":{"v":806845,"d":"80 6845"}},{"v":106845,"d":"10 6845"}]
["km-Geld Arbeitnehmer","USt. ?","USt. ?","USt. ?",{"v":6668,"d":" 6668"}]
["km-Geld Unternehmer","USt. ?","USt. ?","USt. ?",{"v":6688,"d":" 6688"}]
["lfd.Kfz-Kosten",{"v":906530,"d":"90 6530"},{"$f":"B48-200000","v":{"v":706530,"d":"70 6530"}},"USt. ?",{"v":106530,"d":"10 6530"}]
["Miete",{"v":906310,"d":"90 6310"},{"v":706310,"d":"70 6310"},{"$f":"B49-100000","v":{"v":806310,"d":"80 6310"}},{"v":106310,"d":"10 6310"}]
["Pacht",{"v":906315,"d":"90 6315"},{"v":706315,"d":"70 6315"},{"$f":"B50-100000","v":{"v":806315,"d":"80 6315"}},{"v":106315,"d":"10 6315"}]
["Parkgebühren Arbeitn.",{"v":906650,"d":"90 6650"},{"v":706650,"d":"70 6650"},{"$f":"B51-100000","v":{"v":806650,"d":"80 6650"}},{"$f":"B51-800000","v":{"v":106650,"d":"10 6650"}}]
["Parkgebühren Untern.",{"v":906670,"d":"90 6670"},{"v":706670,"d":"70 6670"},{"$f":"B52-100000","v":{"v":806670,"d":"80 6670"}},{"$f":"B52-800000","v":{"v":106670,"d":"10 6670"}}]
["Porto",{"v":906800,"d":"90 6800"},{"v":706800,"d":"70 6800"},"USt. ?",{"v":106800,"d":"10 6800"}]
["Privateinlage","USt. ?","USt. ?","USt. ?",{"v":2180,"d":" 2180"}]
["Privatentnahme","USt. ?","USt. ?","USt. ?",{"v":2100,"d":" 2100"}]
["Provisionserlöse",{"v":304500,"d":"30 4500"},{"v":504500,"d":"50 4500"},{"$f":"B56-100000","v":{"v":204500,"d":"20 4500"}},{"v":104500,"d":"10 4500"}]
["Putzmittel",{"v":906330,"d":"90 6330"},{"$f":"B57-200000","v":{"v":706330,"d":"70 6330"}},{"v":806330,"d":"80 6330"},{"v":106330,"d":"10 6330"}]
["Reinigung",{"v":906330,"d":"90 6330"},{"v":706330,"d":"70 6330"},{"v":806330,"d":"80 6330"},{"v":106330,"d":"10 6330"}]
["Reinigungsmittel",{"v":906330,"d":"90 6330"},{"v":706330,"d":"70 6330"},{"v":806330,"d":"80 6330"},{"v":106330,"d":"10 6330"}]
["Reisekosten Arbeitn.",{"v":906650,"d":"90 6650"},{"v":706650,"d":"70 6650"},{"v":806650,"d":"80 6650"},{"v":106650,"d":"10 6650"}]
["Reisekosten Untern.",{"v":906670,"d":"90 6670"},{"v":706670,"d":"70 6670"},{"v":806670,"d":"80 6670"},{"v":106670,"d":"10 6670"}]
["sonst.Betriebsbedarf",{"v":906850,"d":"90 6850"},{"v":706850,"d":"70 6850"},{"v":806850,"d":"80 6850"},{"v":106850,"d":"10 6850"}]
["sonst.Instandhaltungsk.",{"v":906490,"d":"90 6490"},{"v":706490,"d":"70 6490"},"USt. ?",{"v":106490,"d":"10 6490"}]
["sonst.Kfz.-Kosten",{"v":906570,"d":"90 6570"},{"v":706570,"d":"70 6570"},"USt. ?",{"v":106570,"d":"10 6570"}]
["Strom",{"v":906325,"d":"90 6325"},{"v":706325,"d":"70 6325"},"USt. ?",{"v":106325,"d":"10 6325"}]
["Tageseinnahme",{"v":4400,"d":" 4400"},{"$f":"IF(C$3=15,504200,4340)","v":{"v":4340,"d":" 4340"}},{"v":4300,"d":" 4300"},"USt. ?"]
["Telefax",{"v":906810,"d":"90 6810"},{"v":706810,"d":"70 6810"},"USt. ?",{"v":106810,"d":"10 6810"}]
["Telefon",{"v":906805,"d":"90 6805"},{"v":706805,"d":"70 6805"},"USt. ?",{"v":106805,"d":"10 6805"}]
["Trinkgeld","USt. ?","USt. ?","USt. ?",{"v":106781,"d":"10 6781"}]
["Übernacht.Arbeitn.",{"v":906660,"d":"90 6660"},{"v":706660,"d":"70 6660"},"USt. ?",{"$f":"B70-800000","v":{"v":106660,"d":"10 6660"}}]
["Übernacht.Untern.",{"v":906680,"d":"90 6680"},{"v":706680,"d":"70 6680"},"USt. ?",{"v":106680,"d":"10 6680"}]
["Verk. Anlagevermögen ",{"v":4845,"d":" 4845"},{"v":4846,"d":" 4846"},"USt. ?",{"v":104849,"d":"10 4849"}]
["Verkaufsprovision",{"v":906770,"d":"90 6770"},{"v":706770,"d":"70 6770"},"USt. ?",{"v":106770,"d":"10 6770"}]
["Verpackungsmaterial",{"v":906710,"d":"90 6710"},{"v":706710,"d":"70 6710"},"USt. ?",{"v":106710,"d":"10 6710"}]
["Verpfl.mehraufw.Arbeitn.",{"v":906664,"d":"90 6664"},{"v":706664,"d":"70 6664"},{"$f":"B75-100000","v":{"v":806664,"d":"80 6664"}},{"v":106664,"d":"10 6664"}]
["Verpfl.mehraufw.Untern.",{"v":906674,"d":"90 6674"},{"v":706674,"d":"70 6674"},{"$f":"B76-100000","v":{"v":806674,"d":"80 6674"}},{"$f":"B76-800000","v":{"v":106674,"d":"10 6674"}}]
["Wartung Hard-/Softw.",{"v":906495,"d":"90 6495"},{"v":706495,"d":"70 6495"},"USt. ?",{"v":106495,"d":"10 6495"}]
["Wareneingang",{"v":5400,"d":" 5400"},{"$f":"IF(C$3=15,705200,5340)","v":{"v":5340,"d":" 5340"}},{"v":5300,"d":" 5300"},{"v":5200,"d":" 5200"}]
["Wareneingang EG",{"v":5425,"d":" 5425"},{"v":5433,"d":" 5433"},{"v":5420,"d":" 5420"},"USt. ?"]
["Werbekosten",{"v":906600,"d":"90 6600"},{"$f":"B80-200000","v":{"v":706600,"d":"70 6600"}},{"$f":"B80-100000","v":{"v":806600,"d":"80 6600"}},{"$f":"B80-800000","v":{"v":106600,"d":"10 6600"}}]
["Werkzeuge bis 60 €",{"v":906845,"d":"90 6845"},{"$f":"B81-200000","v":{"v":706845,"d":"70 6845"}},"USt. ?",{"$f":"B81-800000","v":{"v":106845,"d":"10 6845"}}]
["Werkzeuge bis 800 €",{"v":900670,"d":"90 0670"},{"$f":"B82-200000","v":{"v":700670,"d":"70 0670"}},{"$f":"B82-100000","v":{"v":800670,"d":"80 0670"}},{"$f":"B82-800000","v":{"v":100670,"d":"10 0670"}}]
["Werkzeuge über 800 €",{"v":900690,"d":"90 0690"},{"$f":"B83-200000","v":{"v":700690,"d":"70 0690"}},{"$f":"B83-100000","v":{"v":800690,"d":"80 0690"}},{"$f":"B83-800000","v":{"v":100690,"d":"10 0690"}}]
["Zeitschriften",{"v":906820,"d":"90 6820"},{"$f":"B84-200000","v":{"v":706820,"d":"70 6820"}},{"$f":"B84-100000","v":{"v":806820,"d":"80 6820"}},{"v":106820,"d":"10 6820"}]
[]
["diverse Kunden"," ",null," "," "]
["Anzahlung von Kunde",{"$f":"IF(B3=16,3270,3272)","v":{"v":3272,"d":" 3272"}},{"$f":"IF(C3=15,3271,3270)","v":{"v":3270,"d":" 3270"}},{"v":3260,"d":" 3260"},{"v":3250,"d":" 3250"}]
[]
["Anton GmbH",{"v":10102,"d":"1 0102"},{"$f":"B89+500000","v":{"v":510102,"d":"51 0102"}},{"$f":"B89+200000","v":{"v":210102,"d":"21 0102"}},{"$f":"B89+100000","v":{"v":110102,"d":"11 0102"}}]
["Berta GmbH",{"v":10202,"d":"1 0202"},{"$f":"B90+500000","v":{"v":510202,"d":"51 0202"}},{"$f":"B90+200000","v":{"v":210202,"d":"21 0202"}},{"$f":"B90+100000","v":{"v":110202,"d":"11 0202"}}]
["Cäsar GmbH",{"v":10302,"d":"1 0302"},{"$f":"B91+500000","v":{"v":510302,"d":"51 0302"}},{"$f":"B91+200000","v":{"v":210302,"d":"21 0302"}},{"$f":"B91+100000","v":{"v":110302,"d":"11 0302"}}]
["Dora AG",{"v":10402,"d":"1 0402"},{"$f":"B92+500000","v":{"v":510402,"d":"51 0402"}},{"$f":"B92+200000","v":{"v":210402,"d":"21 0402"}},{"$f":"B92+100000","v":{"v":110402,"d":"11 0402"}}]
[]
[]
["diverse Lieferanten"," ",null," "," "]
["Anzahlung an Lieferant",{"$f":"IF(B3=16,1184,1186)","v":{"v":1186,"d":" 1186"}},{"$f":"IF(C3=15,1185,1184)","v":{"v":1184,"d":" 1184"}},{"v":1181,"d":" 1181"},{"v":1180,"d":" 1180"}]
[]
["Alpha AG",{"v":70102,"d":"7 0102"},{"$f":"B98+700000","v":{"v":770102,"d":"77 0102"}},{"$f":"B98+800000","v":{"v":870102,"d":"87 0102"}},{"$f":"B98+100000","v":{"v":170102,"d":"17 0102"}}]

{"sheet":"Kunden","index":14,"n_rows":30,"n_cols":5,"rows_kept":30}
["Debitorenliste"]
["diverse Kunden","Konto"]
[null,{"$f":"IF(YEAR('S. 1'!B3)<2007,16,19)","v":{"v":19,"d":"19%"}},{"$f":"IF(YEAR('S. 1'!B3)<2007,15,16)","v":{"v":16,"d":"16%"}},{"v":7,"d":"7%"},{"v":0,"d":"0%"}]
[" ","Name?","Name?","Name?","Name?"]
["A",{"v":10101,"d":"1 0101"},{"$f":"B5+500000","v":{"v":510101,"d":"51 0101"}},{"$f":"B5+200000","v":{"v":210101,"d":"21 0101"}},{"$f":"B5+100000","v":{"v":110101,"d":"11 0101"}}]
["B",{"v":10201,"d":"1 0201"},{"$f":"B6+500000","v":{"v":510201,"d":"51 0201"}},{"$f":"B6+200000","v":{"v":210201,"d":"21 0201"}},{"$f":"B6+100000","v":{"v":110201,"d":"11 0201"}}]
["C",{"v":10301,"d":"1 0301"},{"v":510301,"d":"51 0301"},{"v":210301,"d":"21 0301"},{"v":110301,"d":"11 0301"}]
["D",{"v":10401,"d":"1 0401"},{"v":510401,"d":"51 0401"},{"v":210401,"d":"21 0401"},{"v":110401,"d":"11 0401"}]
["E",{"v":10501,"d":"1 0501"},{"v":510501,"d":"51 0501"},{"v":210501,"d":"21 0501"},{"v":110501,"d":"11 0501"}]
["F",{"v":10601,"d":"1 0601"},{"v":510601,"d":"51 0601"},{"v":210601,"d":"21 0601"},{"v":110601,"d":"11 0601"}]
["G",{"v":10701,"d":"1 0701"},{"v":510701,"d":"51 0701"},{"v":210701,"d":"21 0701"},{"v":110701,"d":"11 0701"}]
["H",{"v":10801,"d":"1 0801"},{"v":510801,"d":"51 0801"},{"v":210801,"d":"21 0801"},{"v":110801,"d":"11 0801"}]
["I",{"v":10901,"d":"1 0901"},{"v":510901,"d":"51 0901"},{"v":210901,"d":"21 0901"},{"v":110901,"d":"11 0901"}]
["K",{"v":11001,"d":"1 1001"},{"v":511001,"d":"51 1001"},{"v":211001,"d":"21 1001"},{"v":111001,"d":"11 1001"}]
["L",{"v":11101,"d":"1 1101"},{"v":511101,"d":"51 1101"},{"v":211101,"d":"21 1101"},{"v":111101,"d":"11 1101"}]
["M",{"v":11201,"d":"1 1201"},{"v":511201,"d":"51 1201"},{"v":211201,"d":"21 1201"},{"v":111201,"d":"11 1201"}]
["N",{"v":11301,"d":"1 1301"},{"v":511301,"d":"51 1301"},{"v":211301,"d":"21 1301"},{"v":111301,"d":"11 1301"}]
["O",{"v":11401,"d":"1 1401"},{"v":511401,"d":"51 1401"},{"v":211401,"d":"21 1401"},{"v":111401,"d":"11 1401"}]
["P",{"v":11501,"d":"1 1501"},{"v":511501,"d":"51 1501"},{"v":211501,"d":"21 1501"},{"v":111501,"d":"11 1501"}]
["R",{"v":11601,"d":"1 1601"},{"v":511601,"d":"51 1601"},{"v":211601,"d":"21 1601"},{"v":111601,"d":"11 1601"}]
["S",{"v":11701,"d":"1 1701"},{"v":511701,"d":"51 1701"},{"v":211701,"d":"21 1701"},{"v":111701,"d":"11 1701"}]
["Sch",{"v":11801,"d":"1 1801"},{"v":511801,"d":"51 1801"},{"v":211801,"d":"21 1801"},{"v":111801,"d":"11 1801"}]
["Sci",{"v":11701,"d":"1 1701"},{"v":511701,"d":"51 1701"},{"v":211701,"d":"21 1701"},{"v":111701,"d":"11 1701"}]
["St",{"v":11901,"d":"1 1901"},{"v":511901,"d":"51 1901"},{"v":211901,"d":"21 1901"},{"v":111901,"d":"11 1901"}]
["Su",{"v":11701,"d":"1 1701"},{"v":511701,"d":"51 1701"},{"v":211701,"d":"21 1701"},{"v":111701,"d":"11 1701"}]
["T",{"v":12001,"d":"1 2001"},{"v":512001,"d":"51 2001"},{"v":212001,"d":"21 2001"},{"v":112001,"d":"11 2001"}]
["U",{"v":12101,"d":"1 2101"},{"v":512101,"d":"51 2101"},{"v":212101,"d":"21 2101"},{"v":112101,"d":"11 2101"}]
["V",{"v":12201,"d":"1 2201"},{"v":512201,"d":"51 2201"},{"v":212201,"d":"21 2201"},{"v":112201,"d":"11 2201"}]
["W",{"v":12301,"d":"1 2301"},{"v":512301,"d":"51 2301"},{"v":212301,"d":"21 2301"},{"v":112301,"d":"11 2301"}]
["X",{"v":12401,"d":"1 2401"},{"v":512401,"d":"51 2401"},{"v":212401,"d":"21 2401"},{"v":112401,"d":"11 2401"}]

{"sheet":"Lief.","index":15,"n_rows":30,"n_cols":5,"rows_kept":30}
["Kreditorenliste"]
["diverse Lieferanten","Konto"]
[null,{"$f":"IF(YEAR('S. 1'!B3)<2007,16,19)","v":{"v":19,"d":"19%"}},{"$f":"IF(YEAR('S. 1'!B3)<2007,15,16)","v":{"v":16,"d":"16%"}},{"v":7,"d":"7%"},{"v":0,"d":"0%"}]
[" ","Name?","Name?","Name?","Name?"]
["A",{"v":70101,"d":"7 0101"},{"$f":"B5+700000","v":{"v":770101,"d":"77 0101"}},{"$f":"B5+800000","v":{"v":870101,"d":"87 0101"}},{"$f":"B5+100000","v":{"v":170101,"d":"17 0101"}}]
["B",{"v":70201,"d":"7 0201"},{"$f":"B6+700000","v":{"v":770201,"d":"77 0201"}},{"$f":"B6+800000","v":{"v":870201,"d":"87 0201"}},{"$f":"B6+100000","v":{"v":170201,"d":"17 0201"}}]
["C",{"v":70301,"d":"7 0301"},{"v":770301,"d":"77 0301"},{"v":870301,"d":"87 0301"},{"v":170301,"d":"17 0301"}]
["D",{"v":70401,"d":"7 0401"},{"v":770401,"d":"77 0401"},{"v":870401,"d":"87 0401"},{"v":170401,"d":"17 0401"}]
["E",{"v":70501,"d":"7 0501"},{"v":770501,"d":"77 0501"},{"v":870501,"d":"87 0501"},{"v":170501,"d":"17 0501"}]
["F",{"v":70601,"d":"7 0601"},{"v":770601,"d":"77 0601"},{"v":870601,"d":"87 0601"},{"v":170601,"d":"17 0601"}]
["G",{"v":70701,"d":"7 0701"},{"v":770701,"d":"77 0701"},{"v":870701,"d":"87 0701"},{"v":170701,"d":"17 0701"}]
["H",{"v":70801,"d":"7 0801"},{"v":770801,"d":"77 0801"},{"v":870801,"d":"87 0801"},{"v":170801,"d":"17 0801"}]
["I",{"v":70901,"d":"7 0901"},{"v":770901,"d":"77 0901"},{"v":870901,"d":"87 0901"},{"v":170901,"d":"17 0901"}]
["K",{"v":71001,"d":"7 1001"},{"v":771001,"d":"77 1001"},{"v":871001,"d":"87 1001"},{"v":171001,"d":"17 1001"}]
["L",{"v":71101,"d":"7 1101"},{"v":771101,"d":"77 1101"},{"v":871101,"d":"87 1101"},{"v":171101,"d":"17 1101"}]
["M",{"v":71201,"d":"7 1201"},{"v":771201,"d":"77 1201"},{"v":871201,"d":"87 1201"},{"v":171201,"d":"17 1201"}]
["N",{"v":71301,"d":"7 1301"},{"v":771301,"d":"77 1301"},{"v":871301,"d":"87 1301"},{"v":171301,"d":"17 1301"}]
["O",{"v":71401,"d":"7 1401"},{"v":771401,"d":"77 1401"},{"v":871401,"d":"87 1401"},{"v":171401,"d":"17 1401"}]
["P",{"v":71501,"d":"7 1501"},{"v":771501,"d":"77 1501"},{"v":871501,"d":"87 1501"},{"v":171501,"d":"17 1501"}]
["R",{"v":71601,"d":"7 1601"},{"v":771601,"d":"77 1601"},{"v":871601,"d":"87 1601"},{"v":171601,"d":"17 1601"}]
["S",{"v":71701,"d":"7 1701"},{"v":771701,"d":"77 1701"},{"v":871701,"d":"87 1701"},{"v":171701,"d":"17 1701"}]
["Sch",{"v":71801,"d":"7 1801"},{"v":771801,"d":"77 1801"},{"v":871801,"d":"87 1801"},{"v":171801,"d":"17 1801"}]
["Sci",{"v":71701,"d":"7 1701"},{"v":771701,"d":"77 1701"},{"v":871701,"d":"87 1701"},{"v":171701,"d":"17 1701"}]
["St",{"v":71901,"d":"7 1901"},{"v":771901,"d":"77 1901"},{"v":871901,"d":"87 1901"},{"v":171901,"d":"17 1901"}]
["Su",{"v":71701,"d":"7 1701"},{"v":771701,"d":"77 1701"},{"v":871701,"d":"87 1701"},{"v":171701,"d":"17 1701"}]
["T",{"v":72001,"d":"7 2001"},{"v":772001,"d":"77 2001"},{"v":872001,"d":"87 2001"},{"v":172001,"d":"17 2001"}]
["U",{"v":72101,"d":"7 2101"},{"v":772101,"d":"77 2101"},{"v":872101,"d":"87 2101"},{"v":172101,"d":"17 2101"}]
["V",{"v":72201,"d":"7 2201"},{"v":772201,"d":"77 2201"},{"v":872201,"d":"87 2201"},{"v":172201,"d":"17 2201"}]
["W",{"v":72301,"d":"7 2301"},{"v":772301,"d":"77 2301"},{"v":872301,"d":"87 2301"},{"v":172301,"d":"17 2301"}]
["X",{"v":72401,"d":"7 2401"},{"v":772401,"d":"77 2401"},{"v":872401,"d":"87 2401"},{"v":172401,"d":"17 2401"}]