{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Tabelle1","InternDeckblatt","Geschenke","Prüfung","Auswertung","Bewirtung","Kundendaten","Bewirtungsorte","Info","Tabelle2","AufbauAuswertung","__Goal_Metadata"],"not_rendered":{"images":34,"macros":1,"defined_names":9,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":22,"n_cols":15,"rows_kept":22,"merged":[[5,3,5,4],[7,3,7,4],[9,3,9,4],[17,1,17,2],[17,3,17,4]]}
[{"$nulls":14},"Hiller_Müller AG"]
[{"$nulls":14},"Meiers Bäckerladen um die Ecke"]
[null,"Eigenbelege - Geschenke und Bewirtung",{"$nulls":12},"Müller Streichquartett"]
[{"$nulls":14},"Emmerich und Partner"]
[{"$nulls":14},"Heinrich Heine, Malerarbeiten"]
[null,"Auswertung für",{"$nulls":12},"z"]
{"$rows_empty":7}
[{"$nulls":3},"Bearbeiter"]
[]
[{"$nulls":3},"Erstellt am"]
[]
[]
[]
[{"$nulls":5},"Beträge in","Euro"]
[]
[{"$nulls":5},"Jahr"]

{"sheet":"InternDeckblatt","index":1,"n_rows":22,"n_cols":6,"rows_kept":22}
[]
[]
[]
[]
[]
[null,null,"Auswertung Zeile 1",null,null,{"$f":"Tabelle1!D6","v":0}]
[]
[null,null,"Auswertung Zeile 2",null,null,{"$f":"Tabelle1!D8","v":0}]
[]
[null,null,"Auswertung Zeile 3",null,null,{"$f":"Tabelle1!D10","v":0}]
[]
[]
[]
[]
[null,null,"Bearbeiter",null,null,{"$f":"Tabelle1!E14","v":0}]
[]
[null,null,"Datum",null,null,{"$f":"Tabelle1!E16","v":0}]
[]
[]
[]
[null,null,"Beträge in",null,null,{"$f":"Tabelle1!G20","v":"Euro"}]
[null,null,"Jahr",null,null,{"$f":"Tabelle1!G22","v":0}]

{"sheet":"Geschenke","index":2,"n_rows":20,"n_cols":15,"rows_kept":20}
[{"$nulls":14},"test1"]
[]
[null,{"$f":"\"Eigenbeleg - Geschenke \" & InternDeckblatt!F22","v":"Eigenbeleg - Geschenke 0"}]
[null,{"$f":"\"Beträge in \" & InternDeckblatt!F21","v":"Beträge in Euro"}]
[]
[]
[]
[]
[]
[null,"Nr.","Kunde","Datum","Anlass","Betrag","Geschenk"]
[null,1]
[null,{"$f":"1+B11","v":2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"Prüfung","index":3,"n_rows":11,"n_cols":5,"rows_kept":11}
[]
[null,{"$f":"\"Eigenbeleg - Geschenke \" & InternDeckblatt!F22","v":"Eigenbeleg - Geschenke 0"}]
[null,{"$f":"\"Beträge in \" & InternDeckblatt!F21","v":"Beträge in Euro"}]
[]
[]
[]
[null,"Kunde","Anzahl Geschenke","summierter Betrag","Differenz zur Freigrenze"]
[null,"Meier",1,{"v":123,"d":"123.00"},{"v":-88,"d":"-88.00"}]
[null,"Summe der Aufwendungen",null,{"v":123,"d":"123.00"}]
[null,"davon ansetzbar",null,{"v":0,"d":"0.00"}]
[null,"davon nicht ansetzbar",null,{"v":123,"d":"123.00"}]

{"sheet":"Auswertung","index":4,"n_rows":18,"n_cols":8,"rows_kept":18}
[]
[]
[null,{"$f":"\"Aufstellung der Geschenke im Geschäftsjahr \" & InternDeckblatt!F22","v":"Aufstellung der Geschenke im Geschäftsjahr 0"}]
[null,{"$f":"\"Angaben in \" & InternDeckblatt!F21","v":"Angaben in Euro"}]
[{"$nulls":7},"Info Drucken"]
[]
[]
[]
[]
[]
[null,"Kunde",null,"test1"]
[null,"Straße",null,"test"]
[null,"Ort",null,"test"]
[]
[null,"Geschenke",null,"Datum","Anlass","Betrag"]
[{"$nulls":3},"2013-01-01","besprechung",{"v":22.5,"d":"22.50"}]
[]
[null,"Summe",{"$nulls":3},"22,50"]

{"sheet":"Bewirtung","index":5,"n_rows":22,"n_cols":9,"rows_kept":22}
[]
[null,null,{"$f":"\"Eigenbeleg - Bewirtung \" & InternDeckblatt!F22","v":"Eigenbeleg - Bewirtung 0"}]
[null,null,{"$f":"\"Beträge in \" & InternDeckblatt!F21","v":"Beträge in Euro"}]
[]
[]
[]
[]
[]
[]
[null,"Nr.","Bewirtungsort","Datum","Teilnehmer (Firma/Name)","Anzahl Personen","Anlass","Betrag ","Belegnr."]
[null,1]
[null,{"$f":"1+B11","v":2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,{"$f":"1+B17","v":8}]
[null,{"$f":"1+B18","v":9}]
[null,{"$f":"1+B19","v":10}]
[null,null,"Summe",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"davon",{"$f":"Bewirtungsorte!D6","v":{"v":0.7,"d":"70.00%"}},{"$nulls":3},{"$f":"H21*D22","v":{"v":0,"d":"0.00"}}]

{"sheet":"Kundendaten","index":6,"n_rows":20,"n_cols":15,"rows_kept":20,"merged":[[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4]]}
[{"$nulls":14},"Meier"]
[{"$nulls":14},"Schmitt"]
[null,"Stammdaten - Kundendaten",{"$nulls":12},"Holbein"]
[{"$nulls":14},"Otto"]
[null,"Freigrenze für Geschenke an Kunden in Euro",null,{"v":35,"d":"35.00"},{"$nulls":10},"Karwenzel"]
[{"$nulls":14},"Diwidag"]
[{"$nulls":14},"Beiersdorf"]
[{"$nulls":14},"Nixdorf"]
[{"$nulls":14},"Microsoft"]
[null,"Nr.","Firma / Name","Straße / Hausnr.",null,"PLZ / Ort",{"$nulls":8},"Kalauer"]
[null,1,{"$nulls":12},"Heinzche"]
[null,{"$f":"B11+1","v":2},{"$nulls":12},"Lieschen"]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"Bewirtungsorte","index":7,"n_rows":20,"n_cols":6,"rows_kept":20}
[]
[]
[]
[null,"Stammdaten - Bewirtungsorte"]
[]
[null,null,"Angemessenheitsgrenze",{"v":0.7,"d":"70.00%"}]
[]
[]
[]
[null,"Nr.","Verwendeter Name","Voller Name","Straße / Hausnr.","PLZ / Ort"]
[null,1]
[null,{"$f":"1+B11","v":2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"Info","index":8,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle2","index":9,"n_rows":24,"n_cols":5,"rows_kept":24}
{"$rows_empty":17}
["Kunde"]
["Straße"]
["Ort"]
[]
["Geschenke",null,"Datum","Anlass","Betrag"]
[]
["Summe"]

{"sheet":"AufbauAuswertung","index":10,"n_rows":1,"n_cols":6,"rows_kept":1}
["test1","2013-01-01","besprechung",{"v":22.5,"d":"22.50"},"test","test"]

{"sheet":"__Goal_Metadata","index":11,"n_rows":2,"n_cols":2,"rows_kept":2,"hidden":true}
["_KAW999934","J"]
["_KAW999929","0bc2c166-e85e-4513-86ea-10ffaa0eaa63"]