{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Erfassung","Dashboard Umsätze","Dashboard Kunden","Dashboard Ausgaben","Ansprechpartner","AGB","Hilfstabelle","Testfunktion_Registrierung"],"not_rendered":{"charts":5,"images":7,"macros":1,"defined_names":20,"pivot_tables":10},"read":"whole","date_system":"1900"}

{"sheet":"Erfassung","index":0,"n_rows":12,"n_cols":16,"rows_kept":12}
[null,"Einnahmen/Ausgaben Erfassung",{"$nulls":12},"Saldo:",{"$f":"SUBTOTAL(9,$D:$D)","v":{"v":130,"d":"130.00 €"}}]
{"$rows_empty":8}
[null,"Rechnungsdatum ","Art","Betrag","Rechnungsart/-Nr.","Name Kunde/Empfänger","Kundennummer","Zahlung offen      ","Hilfsspalte Ausgaben","Jahr","Monat in Zahlen","Monat in Buchstaben","Quartal","Tag","Prüf-","Hinweis"]
[null,"2022-01-01","Ausgabe",{"v":-20,"d":"-20.00 €"},4711,"Muster",4711,null,{"$f":"IF(tblErfassung[[#This Row],[Art]]=\"Einnahme\",tblErfassung[[#This Row],[Betrag]],tblErfassung[[#This Row],[Betrag]]*-1)","v":{"v":20,"d":"20.00 €"}},{"$f":"YEAR(tblErfassung[[#This Row],[Rechnungsdatum ]])*1","v":2022},{"$f":"MONTH(tblErfassung[[#This Row],[Rechnungsdatum ]])*1","v":1},{"$f":"IF(tblErfassung[[#This Row],[Monat in Zahlen]]=1,\"Jan\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=2,\"Feb\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=3,\"Mrz\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=4,\"Apr\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=5,\"Mai\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=6,\"Jun\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=7,\"Jul\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=8,\"Aug\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=9,\"Sep\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=10,\"Okt\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=11,\"Nov\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=12,\"Dez\",\"\"))))))))))))","v":"Jan"},{"$f":"IF(tblErfassung[[#This Row],[Monat in Zahlen]]<4,\"1. Quartal\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]<7,\"2. Quartal\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]<10,\"3. Quartal\",\"4. Quartal\")))","v":"1. Quartal"},{"$f":"DAY(tblErfassung[[#This Row],[Rechnungsdatum ]])*1","v":1},{"$f":"IF(OR(tblErfassung[[#This Row],[Hilfsspalte Ausgaben]]=\"\",tblErfassung[[#This Row],[Jahr]]=\"\",tblErfassung[[#This Row],[Monat in Zahlen]]=\"\",tblErfassung[[#This Row],[Monat in Buchstaben]]=\"\",tblErfassung[[#This Row],[Quartal]]=\"\",tblErfassung[[#This Row],[Tag]]=\"\"),2,IF(OR(tblErfassung[[#This Row],[Jahr]]=1900,tblErfassung[[#This Row],[Art]]=\"\"),1,0))","v":0},{"$f":"IF(tblErfassung[[#This Row],[Prüf-]]=1,\"Eingabe fehlerhaft bzw. unvollständig\",IF(tblErfassung[[#This Row],[Prüf-]]=2,\"Formelfehler\",\"i.O.\"))","v":"i.O."}]
[null,"2025-01-01","Einnahme",{"v":150,"d":"150.00 €"},4711,"Müller",4711,"x",{"$f":"IF(tblErfassung[[#This Row],[Art]]=\"Einnahme\",tblErfassung[[#This Row],[Betrag]],tblErfassung[[#This Row],[Betrag]]*-1)","v":{"v":150,"d":"150.00 €"}},{"$f":"YEAR(tblErfassung[[#This Row],[Rechnungsdatum ]])*1","v":2025},{"$f":"MONTH(tblErfassung[[#This Row],[Rechnungsdatum ]])*1","v":1},{"$f":"IF(tblErfassung[[#This Row],[Monat in Zahlen]]=1,\"Jan\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=2,\"Feb\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=3,\"Mrz\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=4,\"Apr\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=5,\"Mai\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=6,\"Jun\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=7,\"Jul\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=8,\"Aug\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=9,\"Sep\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=10,\"Okt\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=11,\"Nov\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]=12,\"Dez\",\"\"))))))))))))","v":"Jan"},{"$f":"IF(tblErfassung[[#This Row],[Monat in Zahlen]]<4,\"1. Quartal\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]<7,\"2. Quartal\",IF(tblErfassung[[#This Row],[Monat in Zahlen]]<10,\"3. Quartal\",\"4. Quartal\")))","v":"1. Quartal"},{"$f":"DAY(tblErfassung[[#This Row],[Rechnungsdatum ]])*1","v":1},{"$f":"IF(OR(tblErfassung[[#This Row],[Hilfsspalte Ausgaben]]=\"\",tblErfassung[[#This Row],[Jahr]]=\"\",tblErfassung[[#This Row],[Monat in Zahlen]]=\"\",tblErfassung[[#This Row],[Monat in Buchstaben]]=\"\",tblErfassung[[#This Row],[Quartal]]=\"\",tblErfassung[[#This Row],[Tag]]=\"\"),2,IF(OR(tblErfassung[[#This Row],[Jahr]]=1900,tblErfassung[[#This Row],[Art]]=\"\"),1,0))","v":0},{"$f":"IF(tblErfassung[[#This Row],[Prüf-]]=1,\"Eingabe fehlerhaft bzw. unvollständig\",IF(tblErfassung[[#This Row],[Prüf-]]=2,\"Formelfehler\",\"i.O.\"))","v":"i.O."}]

{"sheet":"Dashboard Umsätze","index":1,"n_rows":43,"n_cols":38,"rows_kept":43}
[]
[]
[{"$nulls":34},"Zeilenbeschriftungen","Mittelwert","Höchster Betrag","Kleinster Betrag"]
[{"$nulls":34},"Einnahme",{"v":150,"d":"150.00"},{"v":150,"d":"150.00"},{"v":150,"d":"150.00"}]
[{"$nulls":34},"Ausgabe",{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"}]
[{"$nulls":34},"Gesamtergebnis",{"v":85,"d":"85.00"},{"v":150,"d":"150.00"},{"v":20,"d":"20.00"}]
[]
[]
[{"$nulls":34},"Zeilenbeschriftungen","Anzahl von Betrag"]
[{"$nulls":34},"Einnahme",1]
[{"$nulls":34},"Ausgabe",1]
[{"$nulls":34},"Gesamtergebnis",2]
[]
[]
[{"$nulls":34},"Zeilenbeschriftungen","Summe von Betrag"]
[{"$nulls":34},"Einnahme",{"v":150,"d":"150.00"}]
[{"$nulls":34},"Ausgabe",{"v":-20,"d":"-20.00"}]
[{"$nulls":34},"Gesamtergebnis",{"v":130,"d":"130.00"}]
{"$rows_empty":18}
[null,null,"Jan",null,"Gesamt: Anzahl","Gesamt: Betrag Euro"]
[null,null,"Anzahl","Betrag Euro"]
[null,2022,1,{"v":-20,"d":"-20.00"},1,{"v":-20,"d":"-20.00"}]
[null,"Ausgabe",1,{"v":-20,"d":"-20.00"},1,{"v":-20,"d":"-20.00"}]
[null,2025,1,{"v":150,"d":"150.00"},1,{"v":150,"d":"150.00"}]
[null,"Einnahme",1,{"v":150,"d":"150.00"},1,{"v":150,"d":"150.00"}]
[null,"Gesamtergebnis",2,{"v":130,"d":"130.00"},2,{"v":130,"d":"130.00"}]

{"sheet":"Dashboard Kunden","index":2,"n_rows":39,"n_cols":29,"rows_kept":39}
[{"$nulls":26},"Art","Einnahme"]
[]
[{"$nulls":26},"Zeilenbeschriftungen","Summe von Betrag","Summe von Betrag2"]
[{"$nulls":26},"Müller",{"v":150,"d":"150.00"},{"v":1,"d":"100.00%"}]
[{"$nulls":26},"Gesamtergebnis",{"v":150,"d":"150.00"},{"v":1,"d":"100.00%"}]
{"$rows_empty":29}
[null,"Art","Einnahme",{"$nulls":4},"Art","Einnahme"]
[]
[null,null,"% Anteil","Betrag Euro","Mittelwert Euro","Anzahl Rechnungen",null,null,"Betrag Euro"]
[null,"Müller",{"v":1,"d":"100.00%"},{"v":150,"d":"150.00"},{"v":150,"d":"150.00"},1,null,4711,{"v":150,"d":"150.00"}]
[null,"Gesamtergebnis",{"v":1,"d":"100.00%"},{"v":150,"d":"150.00"},{"v":150,"d":"150.00"},1,null,"Gesamtergebnis",{"v":150,"d":"150.00"}]

{"sheet":"Dashboard Ausgaben","index":3,"n_rows":39,"n_cols":29,"rows_kept":39}
[{"$nulls":26},"Art","Ausgabe"]
[]
[{"$nulls":26},"Zeilenbeschriftungen","Summe von Hilfsspalte Ausgaben","Summe von Hilfsspalte Ausgaben2"]
[{"$nulls":26},"Muster",{"v":20,"d":"20.00"},{"v":1,"d":"100.00%"}]
[{"$nulls":26},"Gesamtergebnis",{"v":20,"d":"20.00"},{"v":1,"d":"100.00%"}]
{"$rows_empty":29}
[null,"Art","Ausgabe",{"$nulls":4},"Art","Ausgabe"]
[]
[null,null,"% Anteil","Betrag Euro","Mittelwert Euro","Anzahl Vorgänge",null,null,"Betrag Euro"]
[null,"Muster",{"v":1,"d":"100.00%"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},1,null,4711,{"v":20,"d":"20.00"}]
[null,"Gesamtergebnis",{"v":1,"d":"100.00%"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},1,null,"Gesamtergebnis",{"v":20,"d":"20.00"}]

{"sheet":"Ansprechpartner","index":4,"n_rows":30,"n_cols":3,"rows_kept":30}
{"$rows_empty":29}
[null,null,"E-Mail schreiben und Kontakt aufnehmen"]

{"sheet":"AGB","index":5,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Hilfstabelle","index":6,"n_rows":2,"n_cols":1,"rows_kept":2,"hidden":true}
["Ausgabe"]
["Einnahme"]

{"sheet":"Testfunktion_Registrierung","index":7,"n_rows":7,"n_cols":2,"rows_kept":7,"hidden":true}
["Registrierungscode","x3-56z-2j5"]
["Registriert"]
[]
["Test gestartet"]
["Test Start"]
["Dauer",10]
["Test Ende",{"$f":"B5+B6","v":"1900-01-10"}]