{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Belegverwaltung","Kontoauszug einzeilig MB Alpha","EDV-Handel","EDV-Handel Rabatt","AR oder Rabatt","TL+Kontoauszug MB Beta","AR.","Kontoauszug BKS","Kassenbon Rabatt&Skonto","Logoübersicht","Hilfe","Kontakt und Impressum","intern_Datenblatt","intern_DropDown","intern_Zahlen in Text umwandeln","intern_Tabelle2","intern_BM_HAKLE2","intern_Belegexport"],"not_rendered":{"charts":0,"images":103,"macros":1,"external_links":0,"defined_names":101,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Belegverwaltung","index":0,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[[28,1,30,1],[52,1,54,1],[56,1,58,1],[2,1,2,3],[36,1,38,1],[20,1,22,1],[40,1,42,1],[44,1,46,1],[48,1,50,1],[32,1,34,1],[3,1,3,4],[6,3,6,5],[12,1,14,1],[16,1,18,1],[8,1,10,1],[24,1,26,1],[36,4,38,5],[40,4,42,5],[44,4,46,5],[4,3,4,4],[8,4,8,5],[10,4,10,5],[12,4,12,5],[14,4,14,5],[16,4,16,5],[18,4,18,5],[20,4,20,5],[22,4,22,5],[24,4,24,5],[26,4,26,5],[28,4,28,5],[30,4,30,5]]}
[]
[null,"Belegmappe zu den Lerneinheiten"]
[null,"Rabatte und Rechnungsausgleich verbuchen"]
[]
[null,"Belege",null,"Unternehmensstammdaten"]
[]
[null,"Zum Ausdrucken und Bearbeiten der Belege klicken Sie auf den entsprechenden Button.",null,"In den farbig hinterlegten Feldern können Sie die Unternehmensstammdaten individuell Ihren Bedürfnissen anpassen."]
[]
[null,"Kontoauszug einzeilig Musterbank Alpha",null,{"$f":"+intern_Datenblatt!A7","v":"Anrede"},"Firma"]
[]
[null,null,null,{"$f":"+intern_Datenblatt!A29","v":"Firma"},"Ira Dittmann e.U."]
[]
[null,"EDV-Handel",null,{"$f":"+intern_Datenblatt!A27","v":"Geschäftsbezeichnung"},"Musikhaus"]
[]
[null,null,null,{"$f":"+intern_Datenblatt!A64","v":"Straße"},"Bahngasse 25"]
[]
[null,"EDV-Handel Rabatt",null,{"$f":"+intern_Datenblatt!A51","v":"PLZ und Ort"},"2700 Wiener Neustadt"]
[]
[null,null,null,{"$f":"+intern_Datenblatt!A66","v":"Telefon"},"+43 2622 24 163"]
[]
[null,"Ausgangsrechnung oder Rabattgutschrift",null,{"$f":"+intern_Datenblatt!A25","v":"Fax"},"+43 2622 24 163 - 49"]
[]
[null,null,null,{"$f":"+intern_Datenblatt!A73","v":"Website"},"www.musikhaus.ac.at"]
[]
[null,"Tageslosung und Kontoauszug Musterbank Beta",null,{"$f":"+intern_Datenblatt!A67","v":"UID-Nummer"},"ATU15354408"]
[]
[null,null,null,{"$f":"+intern_Datenblatt!A10","v":"Bank"},"BKS Bank AG"]
[]
[null,"Ausgangsrechnung ",null,{"$f":"+intern_Datenblatt!A18","v":"BIC"},"BFKKAT2K"]
[]
[null,null,null,{"$f":"intern_Datenblatt!A33","v":"IBAN"},"AT761700000180024810"]
[]
[null,"Kontoauszug & Zahlungseingang BKS Bank"]
[]
[]
[]
[null,"Kassenbon mit Rabatt & Skonto",null,null,"Logoübersicht"]
[]
[]
[]
[null,null,null,null,"Hilfe"]
[]
[]
[]
[null,null,null,null,"Kontakt & Impressum"]

{"sheet":"Kontoauszug einzeilig MB Alpha","index":1,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,2,17,7],[18,5,19,7],[13,10,13,11],[13,12,13,13],[13,6,13,7],[16,2,16,7],[9,10,9,11],[9,12,9,13],[9,4,9,5],[10,10,10,11],[10,12,10,13],[10,4,10,5],[11,10,11,11],[11,12,11,13],[11,4,11,5],[12,10,12,11],[12,12,12,13],[3,2,3,3],[3,10,3,11],[3,12,3,13],[4,2,4,3],[4,10,4,11],[4,12,4,13],[8,10,8,11],[8,12,8,13],[6,4,6,5],[5,10,5,11],[5,12,5,13],[6,10,6,11],[6,12,6,13],[7,10,7,11],[7,12,7,13],[8,4,8,5],[7,4,7,5],[0,10,0,13],[0,15,1,15],[2,2,2,3],[2,4,2,5],[2,10,2,11],[2,12,2,13]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!B1","v":"Verändern Sie hier den Beleg:"},null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[]
[null,null,{"$f":"+IF(M3=\"\",\"\",M3)","v":"Ira Dittmann e.U."},null,"Buchungen berücksichtigt",null,"Kontoauszug ",{"$f":"+IF(M11=\"\",\"\",M11)","v":"9/1"},null,null,{"$f":"intern_Datenblatt!A29","v":"Firma"},null,{"$f":"+Belegverwaltung!E11","v":"Ira Dittmann e.U."}]
[null,null,{"$f":"+IF(M4=\"\",\"\",M4)","v":"Bahngasse 25"},null,"bis Datum","IBAN",{"$f":"intern_Datenblatt!A74","v":"Währung"},"BIC",null,null,{"$f":"+intern_Datenblatt!A64","v":"Straße"},null,{"$f":"+Belegverwaltung!E15","v":"Bahngasse 25"}]
[null,null,{"$f":"+IF(M5=\"\",\"\",M5)","v":"2700 Wiener Neustadt"},null,{"$f":"IF(M9=\"\",\"\",M9)","v":"2020-03-31"},{"$f":"+IF(M6=\"\",\"\",M6)","v":"AT431921000001008524"},{"$f":"+IF(M10=\"\",\"\",M10)","v":"EUR"},{"$f":"+IF(M7=\"\",\"\",M7)","v":"INGDAT21"},null,null,{"$f":"+intern_Datenblatt!A51","v":"PLZ und Ort"},null,{"$f":"+Belegverwaltung!E17","v":"2700 Wiener Neustadt"},null,null,{"$f":"intern_Datenblatt!B4","v":"Beleg kopieren"}]
[null,null,"Bg.Tag","Wert","Buchungstext",null,null,"Betrag",null,null,{"$f":"+intern_Datenblatt!A33","v":"IBAN"},null,"AT431921000001008524"]
[null,null,{"$f":"+IF(K18=\"\",\"\",K18)","v":"2020-03-31"},{"$f":"IF(L18=\"\",\"\",+L18)","v":"2020-03-31"},{"$f":"IF(M18=\"\",\"\",M18)","v":"Sollzinsen"},null,null,{"$f":"IF(N18=\"\",\"\",+N18)","v":-14.87},null,null,{"$f":"intern_Datenblatt!A18","v":"BIC"},null,"INGDAT21"]
[null,null,"2020-03-31",{"$f":"+IF(L19=\"\",\"\",L19)","v":"2020-03-31"},{"$f":"IF(M19=\"\",\"\",M19)","v":"Habenzinsen"},null,null,9.16,null,null,"Bank",null,"Alphabank Österreich"]
[null,null,"2020-03-31",{"$f":"+IF(L20=\"\",\"\",L20)","v":"2020-03-31"},{"$f":"+IF(M20=\"\",\"\",M20)","v":"Kapitalertragsteuer"},null,null,-2.29,null,null,{"$f":"+intern_Datenblatt!A20","v":"Datum"},null,{"$f":"DATE(YEAR(TODAY()),3,31)","v":"2020-03-31"}]
[null,null,"2020-03-31",{"$f":"+IF(L21=\"\",\"\",L21)","v":"2020-03-31"},{"$f":"+IF(M21=\"\",\"\",M21)","v":"Buchungs- und Abschlusskosten"},null,null,-19.899999999999999,null,null,{"$f":"intern_Datenblatt!A74","v":"Währung"},null,"EUR"]
[null,null,"2020-03-31",{"$f":"+IF(L22=\"\",\"\",L22)","v":"2020-03-31"},{"$f":"+IF(M22=\"\",\"\",M22)","v":"Kontoführungsentgelt"},null,null,-14.9,null,null,"Auszugsnummer",null,"9/1"]
[null,null,"",{"$f":"+IF(L23=\"\",\"\",L23)","v":""},{"$f":"+IF(M23=\"\",\"\",M23)","v":""},null,null,"",null,null,"alter Kontostand",null,10256.31]
[null,null,null,null,null,null,null,null,null,null,"Infotext Zeile 1",null,"Jetzt können Sie Bankgeschäfte auch per Telefon erledigen."]
[null,null,null,null,null,"Alter Kontostand","Neuer Kontostand",null,null,null,"Infotext Zeile 2",null,"Kostenlos von 7:00 bis 19:00 - Infos +43 1 512 33 97-01"]
[null,null,null,null,null,{"$f":"IF(M12=\"\",\"\",M12)","v":10256.31},null,{"$f":"IF((M12+SUM(H7:H13))=0,\"\",(M12+SUM(H7:H13)))","v":10213.51}]
[]
[null,null,{"$f":"+IF(M13=\"\",\"\",M13)","v":"Jetzt können Sie Bankgeschäfte auch per Telefon erledigen."},null,null,null,null,null,null,null,"Bg.Tag","Wert","Buchungstext","Betrag"]
[null,null,{"$f":"+IF(M14=\"\",\"\",M14)","v":"Kostenlos von 7:00 bis 19:00 - Infos +43 1 512 33 97-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(TODAY()),3,31)","v":"2020-03-31"},{"$f":"IF(K18=\"\",\"\",K18)","v":"2020-03-31"},"Sollzinsen",-14.87]
[null,null,null,null,null,{"$f":"IF(M8=\"\",\"\",M8)","v":"Alphabank Österreich"},null,null,null,null,{"$f":"DATE(YEAR(TODAY()),3,31)","v":"2020-03-31"},{"$f":"IF(K19=\"\",\"\",K19)","v":"2020-03-31"},"Habenzinsen",9.16]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(TODAY()),3,31)","v":"2020-03-31"},"2020-03-31","Kapitalertragsteuer",-2.29]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(TODAY()),3,31)","v":"2020-03-31"},"2020-03-31","Buchungs- und Abschlusskosten",-19.899999999999999]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(TODAY()),3,31)","v":"2020-03-31"},"2020-03-31","Kontoführungsentgelt",-14.9]

{"sheet":"EDV-Handel","index":2,"n_rows":47,"n_cols":20,"rows_kept":47,"cut":false,"hidden":false,"merged":[[37,2,38,6],[31,2,31,3],[33,12,33,13],[33,14,33,15],[39,2,39,6],[32,2,33,4],[36,12,36,13],[37,12,37,13],[37,14,37,15],[38,12,38,13],[38,14,38,15],[31,5,31,6],[46,2,46,3],[46,4,46,6],[41,2,41,3],[41,4,41,6],[42,2,42,3],[42,4,42,6],[43,2,43,3],[43,4,43,6],[44,2,44,3],[44,4,44,6],[45,2,45,3],[45,4,45,6],[7,12,7,13],[7,14,7,15],[15,12,15,13],[15,14,15,15],[36,14,36,15],[16,14,16,15],[31,12,31,13],[31,14,31,15],[32,12,32,13],[32,14,32,15],[28,14,28,15],[35,12,35,13],[35,14,35,15],[34,12,34,13],[34,14,34,15],[12,9,12,10],[28,4,28,5],[8,12,8,13],[8,14,8,15],[29,12,30,13],[29,14,30,15],[26,4,26,5],[12,12,12,13],[12,14,12,15],[10,2,10,4],[13,12,13,13],[13,14,13,15],[11,12,11,13],[11,14,11,15],[29,2,29,5],[28,12,28,13],[27,4,27,5],[6,12,6,13],[6,14,6,15],[4,2,4,6],[4,9,4,10],[4,12,4,13],[4,14,4,15],[15,2,16,6],[18,9,18,10],[22,9,22,10],[27,12,27,13],[27,14,27,15],[25,4,25,5],[11,2,11,4],[14,12,14,13],[14,14,14,15],[0,12,0,15],[0,17,1,17],[2,9,2,10],[2,12,2,13],[2,14,2,15],[2,3,3,6],[16,12,16,13],[5,9,5,10],[5,12,5,13],[5,14,5,15],[10,12,10,13],[10,14,10,15],[9,2,9,4],[9,5,9,6],[3,9,3,10],[3,12,3,13],[3,14,3,15],[9,12,9,13],[9,14,9,15],[7,9,7,10],[12,2,12,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!B1","v":"Verändern Sie hier den Beleg:"},null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[]
[null,null,null,{"$f":"IF(O3=\"\",\"\",O3)","v":"BTC Bürotechnik"},null,null,null,null,null,"** KUNDENBELEG **",null,null,{"$f":"intern_Datenblatt!A62","v":"Slogan"},null,"BTC Bürotechnik",null,null,null,null,{"$f":"O3","v":"BTC Bürotechnik"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O4=\"\",\"\",O4)","v":"BTC Handels- und Service GmbH"},null,null,{"$f":"intern_Datenblatt!A29","v":"Firma"},null,"BTC Handels- und Service GmbH",null,null,null,null,{"$f":"O4","v":"BTC Handels- und Service GmbH"}]
[null,null,{"$f":"IF(O4=\"\",\"\",O4)","v":"BTC Handels- und Service GmbH"},null,null,null,null,null,null,{"$f":"IF(O5=\"\",\"\",O5)","v":"Steinschneidergasse 25"},null,null,{"$f":"intern_Datenblatt!A64","v":"Straße"},null,"Steinschneidergasse 25",null,null,{"$f":"intern_Datenblatt!B4","v":"Beleg kopieren"},null,"Steinschneidergasse 25"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O6=\"\",\"\",O6)","v":"2700 Wiener Neustadt"},null,null,{"$f":"intern_Datenblatt!A51","v":"PLZ und Ort"},null,"2700 Wiener Neustadt",null,null,null,null,"2700 Wiener Neustadt"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A66","v":"Telefon"},null,"+43 2622 78 930",null,null,null,null,{"$f":"O10","v":"Firma"}]
[null,null,null,null,null,null,null,null,null,"VERKAUF",null,null,{"$f":"intern_Datenblatt!A73","v":"Website"},null,"www.btc.at",null,null,null,null,{"$f":"O11","v":"Ira Dittmann e.U."}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O15=\"\",\"\",O15)","v":"2020-04-01"},{"$f":"NOW()","v":44005.679105902775},null,{"$f":"intern_Datenblatt!A22","v":"E-Mail"},null,"office@btc.at",null,null,null,null,{"$f":"O12","v":"Bahngasse 25"}]
[null,null,{"$f":"IF(O10=\"\",\"\",O10)","v":"Firma"},null,null,"RECHNUNG",null,null,null,"Terminal-ID:",{"$f":"RANDBETWEEN(100000,999999)","v":503288},null,{"$f":"intern_Datenblatt!A7","v":"Anrede"},null,{"$f":"Belegverwaltung!E9","v":"Firma"},null,null,null,null,{"$f":"O13","v":"2700 Wiener Neustadt"}]
[null,null,{"$f":"IF(O11=\"\",\"\",O11)","v":"Ira Dittmann e.U."},null,null,{"$f":"IF(O15=\"\",\"\",\"Datum\")","v":"Datum"},{"$f":"IF(O15=\"\",\"\",O15)","v":"2020-04-01"},null,null,"VU-Nr:",{"$f":"RANDBETWEEN(1000000,9999999)","v":7190244},null,{"$f":"intern_Datenblatt!A29","v":"Firma"},null,{"$f":"Belegverwaltung!E11","v":"Ira Dittmann e.U."},null,null,null,null,{"$f":"O14","v":"ATU15354408"}]
[null,null,{"$f":"IF(O12=\"\",\"\",O12)","v":"Bahngasse 25"},null,null,{"$f":"IF(O16=\"\",\"\",\"Re-Nr.\")","v":"Re-Nr."},{"$f":"IF(O16=\"\",\"\",O16)","v":"RE_10268"},null,null,"Beleg-Nr:",{"$f":"RANDBETWEEN(10000,99999)","v":56083},null,{"$f":"intern_Datenblatt!A64","v":"Straße"},null,{"$f":"Belegverwaltung!E15","v":"Bahngasse 25"}]
[null,null,{"$f":"IF(O13=\"\",\"\",O13)","v":"2700 Wiener Neustadt"},null,null,{"$f":"IF(O14=\"\",\"\",\"Ihre UID\")","v":"Ihre UID"},{"$f":"IF(O14=\"\",\"\",O14)","v":"ATU15354408"},null,null,{"$f":"IF(O33=\"\",\"\",O33)","v":"VISA"},null,null,{"$f":"intern_Datenblatt!A51","v":"PLZ und Ort"},null,{"$f":"+Belegverwaltung!E17","v":"2700 Wiener Neustadt"},null,null,null,null,{"$f":"O16","v":"RE_10268"}]
[null,null,null,null,null,null,null,null,null,"AID:",{"$f":"+CONCATENATE(\"A000000\",RANDBETWEEN(10000,99999))","v":"A00000050417"},null,{"$f":"intern_Datenblatt!A68","v":"UID-Nr."},null,{"$f":"Belegverwaltung!E25","v":"ATU15354408"}]
[null,null,null,null,null,null,null,null,null,"Crypto:",{"$f":"RANDBETWEEN(10000000000,99999999999)","v":63210253429},null,{"$f":"intern_Datenblatt!A57","v":"Rechnungsdatum"},null,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2020-04-01"},null,null,{"$f":"IF(O32=\"\",\"\",O15)","v":"2020-04-01"}]
[null,null,"Wir bedanken uns für die Beauftragung und erlauben uns, wie folgt in Rechnung zu stellen:",null,null,null,null,null,null,"Nr:",{"$f":"+CONCATENATE(\"*********\",RANDBETWEEN(1000,9999))","v":"*********8947"},null,{"$f":"intern_Datenblatt!A58","v":"Rechnungsnummer"},null,"RE_10268"]
[null,null,null,null,null,null,null,null,null,"Ablaufdatum:",{"$f":"O15+101","v":"2020-07-11"},null,{"$f":"+intern_Datenblatt!A28","v":"Logoauswahl"},null,"Logo09"]
[null,null,null,null,null,null,null,null,null,"SEQ:","001"]
[null,null,"Pos","Bezeichung","Menge","Preis €","Gesamt €",null,null,"BEZAHLT"]
[null,null,{"$f":"IF(M21=\"\",\"\",M21)","v":"1"},{"$f":"IF(O21=\"\",\"\",O21)","v":"Acer Aspire5 15,6 Zoll Full-HD"},{"$f":"IF(N21=\"\",\"\",N21)","v":1},{"$f":"IF(P21=\"\",\"\",P21)","v":499},{"$f":"IF(N21=\"\",\"\",N21*P21)","v":499},null,null,"GEN.NR.:",{"$f":"RANDBETWEEN(100000,999999)","v":568730},null,{"$f":"intern_Datenblatt!A53","v":"Position"},{"$f":"intern_Datenblatt!A42","v":"Menge"},{"$f":"intern_Datenblatt!A17","v":"Bezeichnung"},{"$f":"intern_Datenblatt!A46","v":"Netto/EH"}]
[null,null,{"$f":"IF(M22=\"\",\"\",M22)","v":"2"},{"$f":"IF(O22=\"\",\"\",O22)","v":"Brother MFC-J533DW 4in1 Drucker"},{"$f":"IF(N22=\"\",\"\",N22)","v":1},{"$f":"IF(P22=\"\",\"\",P22)","v":124.99},{"$f":"IF(N22=\"\",\"\",N22*P22)","v":124.99},null,null,"Betrag:",{"$f":"IF(G30=\"\",\"\",G30)","v":751.22},null,"1",1,"Acer Aspire5 15,6 Zoll Full-HD",499]
[null,null,{"$f":"IF(M23=\"\",\"\",M23)","v":"3"},{"$f":"IF(O23=\"\",\"\",O23)","v":"Logitech M185 Maus schnurlos"},{"$f":"IF(N23=\"\",\"\",N23)","v":1},{"$f":"IF(P23=\"\",\"\",P23)","v":9.99},{"$f":"IF(N23=\"\",\"\",N23*P23)","v":9.99},null,null,null,null,null,"2",1,"Brother MFC-J533DW 4in1 Drucker",124.99]
[null,null,{"$f":"IF(M24=\"\",\"\",M24)","v":"4"},{"$f":"IF(O24=\"\",\"\",O24)","v":"Logitech MK270 Combo Tastatur"},{"$f":"IF(N24=\"\",\"\",N24)","v":1},{"$f":"IF(P24=\"\",\"\",P24)","v":24.99},{"$f":"IF(N24=\"\",\"\",N24*P24)","v":24.99},null,null,"VIELEN DANK!",null,null,"3",1,"Logitech M185 Maus schnurlos",9.99]
[null,null,{"$f":"IF(M25=\"\",\"\",M25)","v":""},{"$f":"IF(O25=\"\",\"\",O25)","v":""},{"$f":"IF(N25=\"\",\"\",N25)","v":""},{"$f":"IF(P25=\"\",\"\",P25)","v":""},{"$f":"IF(N25=\"\",\"\",N25*P25)","v":""},null,null,null,null,null,"4",1,"Logitech MK270 Combo Tastatur",24.99]
[]
[null,null,null,null,{"$f":"IF(SUM(G20:G24)=0,\"\",\"Zwischensumme\")","v":"Zwischensumme"},null,{"$f":"IF(SUM(G20:G24)=0,\"\",SUM(G20:G24))","v":658.97}]
[null,null,null,null,{"$f":"IF(O28=\"\",\"\",O28)","v":"Stammkundenrabatt"},null,{"$f":"IF(P21=\"\",\"\",IF(O29=\"\",\"\",ROUND(G26*O29/-100,2)))","v":-32.950000000000003}]
[null,null,null,null,{"$f":"IF(SUM(G20:G24)=0,\"\",\"Nettobetrag\")","v":"Nettobetrag"},null,{"$f":"(ROUND(SUM(G26:G27),2))","v":626.02},null,null,null,null,null,{"$f":"intern_Datenblatt!A78","v":"Rabattart"},null,"Stammkundenrabatt",null,null,null,null,{"$f":"O7","v":"+43 2622 78 930"}]
[null,null,null,null,{"$f":"IF(SUM(G20:G24)=0,\"\",\"zzgl. 20 % USt\")","v":"zzgl. 20 % USt"},null,{"$f":"(ROUND(G28*0.2,2))","v":125.2},null,null,null,null,null,{"$f":"intern_Datenblatt!A79","v":"Rabatt Prozentsatz"},null,"5",null,null,null,null,{"$f":"O8","v":"www.btc.at"}]
[null,null,"Summe total",null,null,null,{"$f":"IF(G26=\"\",\"\",SUM(G28:G29))","v":751.22},null,null,null,null,null,{"$f":"+intern_Datenblatt!A76","v":"Zahlungskonditionen"},null,"prompt fällig",null,null,null,null,{"$f":"O9","v":"office@btc.at"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O34","v":"Wiener Neustädter Sparkasse"}]
[null,null,{"$f":"IF(O30=\"\",\"\",M30)","v":"Zahlungskonditionen"},null,null,{"$f":"IF(O33=\"auf ziel\",\"\",CONCATENATE(\"Zahlung - \",O33,\" - Kassa: 00\",RANDBETWEEN(1,5)))","v":"Zahlung - VISA - Kassa: 001"},null,null,null,null,null,null,{"$f":"intern_Datenblatt!A81","v":"Stempel"},null,"Ware ausgefolgt",null,null,{"$f":"IF(O32=\"\",\"\",UPPER(O32))","v":"WARE AUSGEFOLGT"},null,"AT872026700600007052"]
[null,null,{"$f":"IF(O30=\"\",\"\",O30)","v":"prompt fällig"},null,null,{"$f":"IF(O33=\"auf ziel\",\"\",K9)","v":44005.679105902775},null,null,null,null,null,null,{"$f":"intern_Datenblatt!A75","v":"Auswahl Zahlungsart"},null,"VISA",null,null,{"$f":"IF(OR(O33=\"BAR\",O33=\"auf ziel\"),\"B2:H48\",\"B2:K48\")","v":"B2:K48"},"R32 definiert den variablen Druckbereich","WINSATWNXXX"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A10","v":"Bank"},null,"Wiener Neustädter Sparkasse",null,null,{"$f":"IF(O33=\"AUF ZIEL\",\"NEIN\",\"JA\")","v":"JA"},null,"ATU20457001"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A33","v":"IBAN"},null,"AT872026700600007052",null,null,null,null,"FN 228850h"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A18","v":"BIC"},null,"WINSATWNXXX",null,null,null,null,"LG Wiener Neustadt"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A67","v":"UID-Nummer"},null,"ATU20457001"]
[null,null,{"$f":"IF(O4=\"\",\"\",CONCATENATE(\"Die Ware bleibt bis zur vollständigen Bezahlung im Eigentum der \",O4,\". Umtausch und Rückgabe sind für diese Artikel ausgeschlossen.\"))","v":"Die Ware bleibt bis zur vollständigen Bezahlung im Eigentum der BTC Handels- und Service GmbH. Umtausch und Rückgabe sind für diese Artikel ausgeschlossen."},null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A26","v":"FB-Nummer"},null,"FN 228850h"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A30","v":"Gerichtsstand"},null,"LG Wiener Neustadt"]
[null,null,"Rechnungsdatum = Lieferdatum"]
[]
[null,null,{"$f":"IF(O4=\"\",\"\",O4)","v":"BTC Handels- und Service GmbH"},null,{"$f":"IF(O34=\"\",\"\",O34)","v":"Wiener Neustädter Sparkasse"}]
[null,null,"Steinschneidergasse 25",null,"AT872026700600007052"]
[null,null,"2700 Wiener Neustadt",null,"WINSATWNXXX"]
[null,null,"+43 2622 78 930",null,"ATU20457001"]
[null,null,"www.btc.at",null,"FN 228850h"]
[null,null,"office@btc.at",null,"LG Wiener Neustadt"]

{"sheet":"EDV-Handel Rabatt","index":3,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,2,34,3],[34,4,34,6],[30,2,30,3],[30,4,30,6],[31,2,31,3],[31,4,31,6],[32,2,32,3],[32,4,32,6],[24,9,24,10],[24,11,24,12],[2,3,3,6],[33,2,33,3],[33,4,33,6],[29,2,29,3],[29,4,29,6],[20,4,20,5],[12,2,12,4],[10,2,10,4],[25,9,25,10],[25,11,25,12],[18,11,18,12],[19,9,19,10],[19,11,19,12],[23,9,23,10],[23,11,23,12],[20,9,20,10],[20,11,20,12],[21,2,21,5],[18,9,18,10],[22,9,22,10],[22,11,22,12],[23,4,23,6],[12,9,12,10],[12,11,12,12],[13,9,15,10],[13,11,15,12],[21,9,21,10],[21,11,21,12],[15,2,17,6],[16,9,16,10],[16,11,16,12],[17,9,17,10],[17,11,17,12],[10,9,10,10],[10,11,10,12],[11,2,11,4],[11,9,11,10],[11,11,11,12],[8,9,8,10],[8,11,8,12],[9,2,9,4],[9,5,9,6],[9,9,9,10],[9,11,9,12],[24,4,24,5],[6,9,6,10],[6,11,6,12],[0,9,0,12],[0,14,1,14],[2,9,2,10],[2,11,2,12],[3,9,3,10],[3,11,3,12],[4,2,4,6],[4,9,4,10],[4,11,4,12],[5,9,5,10],[5,11,5,12],[7,9,7,10],[7,11,7,12]]}
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!B1","v":"Verändern Sie hier den Beleg:"},null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[]
[null,null,null,{"$f":"IF(L3=\"\",\"\",L3)","v":"BTC Bürotechnik"},null,null,null,null,null,{"$f":"intern_Datenblatt!A62","v":"Slogan"},null,{"$f":"'EDV-Handel'!T3","v":"BTC Bürotechnik"},null,null,null,null,{"$f":"IF($L$3=\"\",\"\",L3)","v":"BTC Bürotechnik"}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A29","v":"Firma"},null,{"$f":"'EDV-Handel'!T4","v":"BTC Handels- und Service GmbH"}]
[null,null,{"$f":"IF(L4=\"\",\"\",L4)","v":"BTC Handels- und Service GmbH"},null,null,null,null,null,null,{"$f":"intern_Datenblatt!A64","v":"Straße"},null,{"$f":"'EDV-Handel'!T5","v":"Steinschneidergasse 25"},null,null,{"$f":"intern_Datenblatt!B4","v":"Beleg kopieren"}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A51","v":"PLZ und Ort"},null,{"$f":"'EDV-Handel'!T6","v":"2700 Wiener Neustadt"}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A7","v":"Anrede"},null,{"$f":"'EDV-Handel'!T7","v":"Firma"}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A29","v":"Firma"},null,{"$f":"'EDV-Handel'!T8","v":"Ira Dittmann e.U."}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A64","v":"Straße"},null,{"$f":"'EDV-Handel'!T9","v":"Bahngasse 25"}]
[null,null,{"$f":"IF(L7=\"\",\"\",L7)","v":"Firma"},null,null,"GUTSCHRIFT ",null,null,null,{"$f":"intern_Datenblatt!A51","v":"PLZ und Ort"},null,{"$f":"'EDV-Handel'!T10","v":"2700 Wiener Neustadt"}]
[null,null,{"$f":"IF(L8=\"\",\"\",L8)","v":"Ira Dittmann e.U."},null,null,{"$f":"IF(L12=\"\",\"\",\"Datum\")","v":"Datum"},{"$f":"IF(L12=\"\",\"\",L12)","v":"2020-04-08"},null,null,{"$f":"intern_Datenblatt!A68","v":"UID-Nr."},null,{"$f":"'EDV-Handel'!T11","v":"ATU15354408"}]
[null,null,{"$f":"IF(L9=\"\",\"\",L9)","v":"Bahngasse 25"},null,null,{"$f":"IF(L13=\"\",\"\",\"zu Re-Nr.\")","v":"zu Re-Nr."},{"$f":"IF(L13=\"\",\"\",L13)","v":"RE_10268"},null,null,{"$f":"intern_Datenblatt!A57","v":"Rechnungsdatum"},null,{"$f":"DATE(YEAR(TODAY()),4,8)","v":"2020-04-08"}]
[null,null,{"$f":"IF(L10=\"\",\"\",L10)","v":"2700 Wiener Neustadt"},null,null,{"$f":"IF(L11=\"\",\"\",\"Ihre UID\")","v":"Ihre UID"},{"$f":"IF(L11=\"\",\"\",L11)","v":"ATU15354408"},null,null,{"$f":"intern_Datenblatt!A58","v":"Rechnungsnummer"},null,{"$f":"'EDV-Handel'!T13","v":"RE_10268"}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A80","v":"Text"},null,"Wie heute telefonisch vereinbart, gewähren wir Ihnen nachträglich einen Rabatt von 15 %."]
[]
[null,null,{"$f":"IF(L14=\"\",\"\",L14)","v":"Wie heute telefonisch vereinbart, gewähren wir Ihnen nachträglich einen Rabatt von 15 %."}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A79","v":"Rabatt Prozentsatz"},null,"15"]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A66","v":"Telefon"},null,{"$f":"+'EDV-Handel'!T28","v":"+43 2622 78 930"}]
[null,null,null,null,null,null,"Gesamt €",null,null,{"$f":"intern_Datenblatt!A73","v":"Website"},null,{"$f":"+'EDV-Handel'!T29","v":"www.btc.at"}]
[null,null,null,{"$f":"IF(L17=\"\",\"\",CONCATENATE(L17,\" %\"))","v":"15 %"},{"$f":"IF(L17=\"\",\"\",\"von\")","v":"von"},{"$f":"IF(L17=\"\",\"\",SUM('EDV-Handel'!G26:G27))","v":626.02},{"$f":"IF(L17=\"\",\"\",ROUND(F20*L17/100,2))","v":93.9},null,null,{"$f":"intern_Datenblatt!A22","v":"E-Mail"},null,{"$f":"+'EDV-Handel'!T30","v":"office@btc.at"}]
[null,null,null,{"$f":"IF(L17=\"\",\"\",\"+ 20 %\")","v":"+ 20 %"},{"$f":"IF(L17=\"\",\"\",intern_Datenblatt!A69)","v":"Umsatzsteuer"},null,{"$f":"IF(G20=\"\",\"\",ROUND(G20*0.2,2))","v":18.78},null,null,{"$f":"intern_Datenblatt!A67","v":"UID-Nummer"},null,{"$f":"+'EDV-Handel'!T34","v":"ATU20457001"}]
[null,null,"Rabatt total",null,null,null,{"$f":"IF(G20=\"\",\"\",SUM(G20:G21))","v":112.68},null,null,{"$f":"intern_Datenblatt!A26","v":"FB-Nummer"},null,{"$f":"+'EDV-Handel'!T35","v":"FN 228850h"}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A30","v":"Gerichtsstand"},null,{"$f":"+'EDV-Handel'!T36","v":"LG Wiener Neustadt"}]
[null,null,null,null,{"$f":"IF('EDV-Handel'!O33=\"auf ziel\",\"\",CONCATENATE(\"Auszahlung - \",'EDV-Handel'!O33,\" - Kassa: 00\",RANDBETWEEN(1,5)))","v":"Auszahlung - VISA - Kassa: 003"},null,null,null,null,{"$f":"intern_Datenblatt!A10","v":"Bank"},null,{"$f":"+'EDV-Handel'!T31","v":"Wiener Neustädter Sparkasse"}]
[null,null,null,null,{"$f":"IF('EDV-Handel'!O33=\"auf ziel\",\"\",CONCATENATE(RANDBETWEEN(10,18),\":\",RANDBETWEEN(10,59),\":\",RANDBETWEEN(10,59)))","v":"15:30:38"},null,null,null,null,{"$f":"intern_Datenblatt!A33","v":"IBAN"},null,{"$f":"+'EDV-Handel'!T32","v":"AT872026700600007052"}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A18","v":"BIC"},null,{"$f":"+'EDV-Handel'!T33","v":"WINSATWNXXX"}]
[]
[]
[]
[null,null,{"$f":"IF(L4=\"\",\"\",L4)","v":"BTC Handels- und Service GmbH"},null,{"$f":"IF(L24=\"\",\"\",L24)","v":"Wiener Neustädter Sparkasse"}]
[null,null,{"$f":"IF(L5=\"\",\"\",L5)","v":"Steinschneidergasse 25"},null,{"$f":"IF(L25=\"\",\"\",L25)","v":"AT872026700600007052"}]
[null,null,{"$f":"IF(L6=\"\",\"\",L6)","v":"2700 Wiener Neustadt"},null,"WINSATWNXXX"]
[null,null,{"$f":"IF(L18=\"\",\"\",L18)","v":"+43 2622 78 930"},null,{"$f":"IF(L21=\"\",\"\",L21)","v":"ATU20457001"}]
[null,null,{"$f":"IF(L19=\"\",\"\",L19)","v":"www.btc.at"},null,{"$f":"IF(L22=\"\",\"\",L22)","v":"FN 228850h"}]
[null,null,{"$f":"IF(L20=\"\",\"\",L20)","v":"office@btc.at"},null,{"$f":"IF(L23=\"\",\"\",L23)","v":"LG Wiener Neustadt"}]

{"sheet":"AR oder Rabatt","index":4,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[5,2,6,5],[5,11,5,13],[6,11,6,13],[7,2,7,5],[7,11,7,13],[0,10,0,13],[0,15,1,15],[2,11,2,13],[3,2,4,5],[3,11,3,13],[4,11,4,13],[10,11,10,13],[11,11,11,13],[12,11,12,13],[8,2,8,5],[9,11,9,13],[8,11,8,13],[20,10,20,11],[12,2,12,3],[12,5,12,6],[13,11,13,13],[14,11,14,13],[15,11,15,13],[15,2,15,4],[16,11,16,13],[17,2,17,4],[18,2,18,4],[18,10,18,11],[19,2,19,4],[19,10,19,11],[20,2,20,4],[29,11,29,13],[21,2,21,4],[21,10,21,11],[22,2,22,4],[22,10,22,11],[23,10,23,11],[24,2,24,5],[24,10,24,11],[25,2,25,5],[26,2,26,5],[25,10,28,10],[25,11,28,13],[30,2,30,7],[30,11,30,13],[34,2,35,7],[31,10,32,10],[31,11,32,13],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[33,11,33,13],[34,11,34,13],[38,5,38,7],[35,11,35,13],[39,5,39,7],[36,11,36,13],[40,5,40,7],[37,11,37,13],[41,5,41,7],[38,2,38,4]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!B1","v":"Verändern Sie hier den Beleg:"},null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A14","v":"Belegauswahl"},"Rechnung"]
[null,null,{"$f":"IF(L3=\"\",\"\",L3)","v":"Rechnung"},null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A29","v":"Firma"},{"$f":"+Belegverwaltung!E11","v":"Ira Dittmann e.U."}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A27","v":"Geschäftsbezeichnung"},{"$f":"+Belegverwaltung!E13","v":"Musikhaus"},null,null,null,{"$f":"intern_Datenblatt!B4","v":"Beleg kopieren"}]
[null,null,{"$f":"IF(L16=\"\",\"\",CONCATENATE(YEAR(L15),\"-\",L16))","v":"2020-521"},null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A64","v":"Straße"},{"$f":"+Belegverwaltung!E15","v":"Bahngasse 25"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A51","v":"PLZ und Ort"},{"$f":"+Belegverwaltung!E17","v":"2700 Wiener Neustadt"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A66","v":"Telefon"},{"$f":"Belegverwaltung!E19","v":"+43 2622 24 163"}]
[null,null,{"$f":"+IF(L10=\"\",\"\",L10)","v":"Firma"},null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A67","v":"UID-Nummer"},{"$f":"Belegverwaltung!E25","v":"ATU15354408"}]
[null,null,{"$f":"+IF(L11=\"\",\"\",L11)","v":"Carlos Steindl e.U."},null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A7","v":"Anrede"},"Firma"]
[null,null,{"$f":"+IF(L12=\"\",\"\",L12)","v":"Gartengasse 17"},null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A29","v":"Firma"},"Carlos Steindl e.U."]
[null,null,{"$f":"IF(L13=\"\",\"\",L13)","v":"65431 Kuchl"},null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A64","v":"Straße"},"Gartengasse 17"]
[null,null,{"$f":"IF(L14=\"\",\"\",CONCATENATE(\"Ihre UID-Nr.: \",L14))","v":"Ihre UID-Nr.: ATU52014698"},null,null,{"$f":"IF(L7=\"\",\"\",CONCATENATE(RIGHT(L7,LEN(L7)-5),\",\"))","v":"Wiener Neustadt,"},null,{"$f":"IF(L15=\"\",\"\",L15)","v":"2020-04-10"},null,null,{"$f":"intern_Datenblatt!A51","v":"PLZ und Ort"},"65431 Kuchl"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A67","v":"UID-Nummer"},"ATU52014698"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A57","v":"Rechnungsdatum"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2020-04-10"}]
[null,null,{"$f":"IF(L3=\"Rechnung\",IF(K20=\"\",\"\",UPPER(K19)),\"\")","v":"ARTIKELBEZEICHNUNG"},null,null,{"$f":"IF(L3=\"Rechnung\",IF(N20=\"\",\"\",UPPER(N19)),\"\")","v":"PREIS/EH"},{"$f":"IF(L3=\"Rechnung\",IF(M20=\"\",\"\",UPPER(M19)),\"\")","v":"MENGE"},{"$f":"IF(L3=\"Rechnung\",IF(H18=\"\",\"\",\"BETRAG\"),\"\")","v":"BETRAG"},null,null,{"$f":"intern_Datenblatt!A58","v":"Rechnungsnummer"},"521"]
[]
[null,null,{"$f":"IF($L$3=\"Rechnung\",IF(K20=\"\",\"\",K20),\"\")","v":"the t.mix 201-USB Play"},null,null,{"$f":"IF($L$3=\"Rechnung\",IF(N20=\"\",\"\",N20),\"\")","v":88},{"$f":"IF($L$3=\"Rechnung\",IF(M20=\"\",\"\",M20),\"\")","v":1},{"$f":"IF($L$3=\"Rechnung\",IF(N20=\"\",\"\",N20*M20),\"\")","v":88}]
[null,null,"Denon MCX8000",null,null,{"$f":"IF($L$3=\"Rechnung\",IF(N21=\"\",\"\",N21),\"\")","v":1299},{"$f":"IF($L$3=\"Rechnung\",IF(M21=\"\",\"\",M21),\"\")","v":1},{"$f":"IF($L$3=\"Rechnung\",IF(N21=\"\",\"\",N21*M21),\"\")","v":1299},null,null,{"$f":"+intern_Datenblatt!A8","v":"Artikelbezeichnung"},null,{"$f":"+intern_Datenblatt!A42","v":"Menge"},{"$f":"+intern_Datenblatt!A55","v":"Preis/EH"}]
[null,null,"Sennheiser HD-25",null,null,29,1,29,null,null,"the t.mix 201-USB Play",null,1,88]
[null,null,"K&M 12190 Laptopstand",null,null,77,1,77,null,null,"Denon MCX8000",null,1,1299]
[null,null,"LD Systems PPA 2",null,null,24.9,1,24.9,null,null,"Sennheiser HD-25",null,1,29]
[null,null,"Ortofon Concorde Pro S Styles",null,null,19.899999999999999,5,99.5,null,null,"K&M 12190 Laptopstand",null,1,77]
[null,null,null,null,null,null,null,null,null,null,"LD Systems PPA 2",null,1,24.9]
[null,null,{"$f":"IF(H25=\"\",\"\",\"Gesamtbetrag brutto in EUR\")","v":"Gesamtbetrag brutto in EUR"},null,null,null,null,{"$f":"+IF(SUM(H18:H23)=0,\"\",SUM(H18:H23))","v":1617.4},null,null,"Ortofon Concorde Pro S Styles",null,5,19.899999999999999]
[null,null,{"$f":"IF(H25=\"\",\"\",\"enthaltene Umsatzsteuer 20 %\")","v":"enthaltene Umsatzsteuer 20 %"},null,null,null,null,{"$f":"IF(H25=\"\",\"\",ROUND(H25/6,2))","v":269.57},null,null,{"$f":"IF(L3=\"Gutschrift\",\"Text für Rabattgutschrift\",\"\")","v":""},"Wie telefonisch vereinbart, gewähren wir Ihnen für die bei der Lieferung entstandenen optischen Schäden einen Sonderrabatt von",null,null,null,{"$f":"IF(L3=\"Gutschrift\",L26,\"\")","v":""}]
[null,null,{"$f":"IF(H25=\"\",\"\",\"Gesamtbetrag netto in EUR \")","v":"Gesamtbetrag netto in EUR "},null,null,null,null,{"$f":"IF(H25=\"\",\"\",H25-H26)","v":1347.8300000000002}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L3=\"Gutschrift\",IF(L30=\"\",\"\",\"+ 20 % Umsatzsteuer\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L3=\"Gutschrift\",intern_Datenblatt!A79,\"\")","v":""},10,null,null,null,{"$f":"IF(L3=\"Gutschrift\",IF(L30=\"\",\"\",CONCATENATE(L30,\" % von \")),\"\")","v":""}]
[null,null,{"$f":"IF(L3=\"Gutschrift\",\"\",IF(L32=\"\",\"\",CONCATENATE(K32,\": \",L32)))","v":"Zahlungskonditionen: 30 Tage netto bzw. 7 Tage abzüglich 2 % Skonto"},null,null,null,null,null,null,null,{"$f":"IF(L3=\"Gutschrift\",intern_Datenblatt!A32,\"\")","v":""},980,null,null,null,{"$f":"IF(L3=\"Gutschrift\",IF(L31=\"\",\"\",L31),\"\")","v":""}]
[null,null,{"$f":"IF(L3=\"Gutschrift\",\"\",IF(K20=\"\",\"\",\"Die Lieferung erfolgt am Tag der Rechnungslegung.\"))","v":"Die Lieferung erfolgt am Tag der Rechnungslegung."},null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A76","v":"Zahlungskonditionen"},"30 Tage netto bzw. 7 Tage abzüglich 2 % Skonto",null,null,null,null,{"$f":"IF(L3=\"Gutschrift\",IF(Q34=\"\",\"\",Q34*0.2),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A10","v":"Bank"},{"$f":"Belegverwaltung!E27","v":"BKS Bank AG"},null,null,null,null,{"$f":"IF(L3=\"Gutschrift\",IF(L31=\"\",\"\",L31*L30/100),\"\")","v":""}]
[null,null,{"$f":"IF(K20=\"\",\"\",\"Wir danken Ihnen für das uns entgegengebrachte Vertrauen und freuen uns, Sie auch in Zukunft zu unseren Kunden zählen zu dürfen.\")","v":"Wir danken Ihnen für das uns entgegengebrachte Vertrauen und freuen uns, Sie auch in Zukunft zu unseren Kunden zählen zu dürfen."},null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A33","v":"IBAN"},{"$f":"Belegverwaltung!E31","v":"AT761700000180024810"},null,null,null,null,{"$f":"IF(L3=\"Gutschrift\",IF(Q34=\"\",\"\",Q34+Q32),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A18","v":"BIC"},{"$f":"Belegverwaltung!E29","v":"BFKKAT2K"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A30","v":"Gerichtsstand"},"Wien"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A26","v":"FB-Nummer"},"FN 296339v"]
[null,null,{"$f":"IF(L4=\"\",\"\",L4)","v":"Ira Dittmann e.U."},null,null,{"$f":"IF(L34=\"\",\"\",L34)","v":"BKS Bank AG"}]
[null,null,{"$f":"IF(L6=\"\",\"\",L6)","v":"Bahngasse 25"},null,null,{"$f":"IF(L35=\"\",\"\",L35)","v":"AT761700000180024810"}]
[null,null,{"$f":"IF(L7=\"\",\"\",L7)","v":"2700 Wiener Neustadt"},null,null,{"$f":"IF(L36=\"\",\"\",L36)","v":"BFKKAT2K"}]
[null,null,{"$f":"IF(L8=\"\",\"\",L8)","v":"+43 2622 24 163"},null,null,{"$f":"IF(L37=\"\",\"\",CONCATENATE(\"Gerichtsstand \",L37))","v":"Gerichtsstand Wien"},{"$f":"IF(L37=\"\",\"\",CONCATENATE(K37,\" \",L37))","v":"Gerichtsstand Wien"}]
[null,null,{"$f":"IF(L9=\"\",\"\",L9)","v":"ATU15354408"},null,null,null,null,{"$f":"IF(L38=\"\",\"\",L38)","v":"FN 296339v"}]

{"sheet":"TL+Kontoauszug MB Beta","index":5,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[26,3,26,4],[19,9,19,10],[19,11,19,12],[37,5,37,6],[27,3,27,4],[22,9,22,10],[22,11,22,12],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[34,5,34,6],[35,5,35,6],[36,5,36,6],[24,9,24,10],[25,3,25,4],[20,9,20,10],[20,11,20,12],[23,9,23,10],[24,11,24,12],[17,2,18,6],[17,9,17,10],[17,11,17,12],[18,9,18,10],[18,11,18,12],[13,9,13,10],[23,11,23,12],[21,9,21,10],[21,11,21,12],[14,9,14,10],[6,2,6,3],[6,9,6,10],[6,11,6,12],[7,2,7,3],[8,2,8,3],[8,9,8,10],[9,2,9,3],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[4,2,4,3],[4,9,4,10],[4,11,4,12],[5,2,5,3],[5,9,5,10],[5,11,5,12],[3,9,3,10],[3,11,3,12],[0,9,0,12],[0,14,1,14],[1,2,2,4],[2,9,2,10],[2,11,2,12]]}
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!B1","v":"Verändern Sie hier den Beleg:"},null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[null,null,"T a g e s a b s c h l u s s   C o m p u t e r k a s s e"]
[null,null,null,null,null,{"$f":"IF(L6=\"\",\"\",L6)","v":"2020-04-14"},{"$f":"CONCATENATE(RANDBETWEEN(16,20),\":\",RANDBETWEEN(10,59),\":\",RANDBETWEEN(10,59))","v":"17:41:23"},null,null,{"$f":"intern_Datenblatt!A29","v":"Firma"},null,{"$f":"+Belegverwaltung!E11","v":"Ira Dittmann e.U."}]
[null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A64","v":"Straße"},null,{"$f":"+Belegverwaltung!E15","v":"Bahngasse 25"}]
[null,null,{"$f":"IF(J10=\"\",\"\",CONCATENATE(J10,\" \",M10,\" % USt\"))","v":"BAR 20 % USt"},null,null,{"$f":"IF(L10=\"\",\"\",\"EUR\")","v":"EUR"},{"$f":"IF(L10=\"\",\"\",L10)","v":579.5},null,null,{"$f":"+intern_Datenblatt!A51","v":"PLZ und Ort"},null,{"$f":"+Belegverwaltung!E17","v":"2700 Wiener Neustadt"},null,null,{"$f":"intern_Datenblatt!B4","v":"Beleg kopieren"}]
[null,null,"MASTERCARD 20 % USt",null,null,"EUR",39.9,null,null,{"$f":"+intern_Datenblatt!A20","v":"Datum"},null,{"$f":"DATE(YEAR(TODAY()),4,14)","v":"2020-04-14"}]
[null,null,"MAESTRO 20 % USt",null,null,"EUR",79.900000000000006,null,null,{"$f":"+intern_Datenblatt!A37","v":"Kassier/in"},null,"Heidi"]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"Zahlungsart/Umsatzart",null,{"$f":"intern_Datenblatt!A16","v":"Betrag"},{"$f":"+intern_Datenblatt!A72","v":"USt %"}]
[null,null,"",null,null,"","",null,null,"BAR",null,579.5,20]
[null,null,{"$f":"IF(L7=\"\",\"\",CONCATENATE(J7,\": \",L7))","v":"Kassier/in: Heidi"},null,null,{"$f":"IF(G11=\"\",\"\",\"EUR\")","v":"EUR"},{"$f":"IF(SUM(L10:L15)=0,\"\",SUM(L10:L15))","v":699.3},null,null,"MASTERCARD",null,39.9,20]
[null,null,{"$f":"CONCATENATE(\"Kassa Nummer: 00\",RANDBETWEEN(1,7))","v":"Kassa Nummer: 006"},null,null,null,null,null,null,"MAESTRO",null,79.900000000000006,20]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(L21=\"\",\"\",CONCATENATE(L21,\" - \",L22,\" - \",L23))","v":"Beta-Bank AG - Hauptplatz 17 - 2700 Wiener Neustadt"},null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A20","v":"Datum"},null,{"$f":"IF(L6=\"\",\"\",L6+6)","v":"2020-04-20"}]
[null,null,null,null,null,null,null,null,null,"Auszugsnummer",null,"08 - 1 von 1"]
[null,null,null,null,null,null,null,null,null,"alter Kontostand",null,-59.87]
[null,null,null,null,null,null,null,null,null,"Bankbezeichnung",null,"Beta-Bank AG"]
[null,null,{"$f":"+IF(L3=\"\",\"\",L3)","v":"Ira Dittmann e.U."},null,null,{"$f":"+IF(L6=\"\",\"\",CONCATENATE(J6,\":\"))","v":"Datum:"},{"$f":"+IF(L18=\"\",\"\",L18)","v":"2020-04-20"},null,null,{"$f":"+intern_Datenblatt!A64","v":"Straße"},null,"Hauptplatz 17"]
[null,null,{"$f":"+IF(L4=\"\",\"\",L4)","v":"Bahngasse 25"},null,null,{"$f":"+IF(L24=\"\",\"\",CONCATENATE(J24,\":\"))","v":"IBAN:"},{"$f":"IF(L24=\"\",\"\",L24)","v":"AT701912000002663986"},null,null,{"$f":"+intern_Datenblatt!A51","v":"PLZ und Ort"},null,"2700 Wiener Neustadt"]
[null,null,{"$f":"+IF(L5=\"\",\"\",L5)","v":"2700 Wiener Neustadt"},null,null,{"$f":"+IF(L25=\"\",\"\",CONCATENATE(J25,\":\"))","v":"BIC:"},{"$f":"+IF(L25=\"\",\"\",L25)","v":"MBBAATWW"},null,null,{"$f":"+intern_Datenblatt!A33","v":"IBAN"},null,"AT701912000002663986"]
[null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A18","v":"BIC"},null,"MBBAATWW"]
[null,null,"DATUM","BUCHUNGSTEXT",null,"VALUTA","BETRAG EUR"]
[null,null,{"$f":"+IF(J28=\"\",\"\",J28)","v":"2020-04-15"},{"$f":"IF(L28=\"\",\"\",L28)","v":"Taxi 2700 dankt MAESTRO "},null,{"$f":"IF(K28=\"\",\"\",+K28)","v":"2020-04-16"},{"$f":"IF(M28=\"\",\"\",+M28)","v":-9},null,null,{"$f":"+intern_Datenblatt!A20","v":"Datum"},"Valuta","Buchungstext","Betrag"]
[null,null,"2020-04-17",{"$f":"IF(L29=\"\",\"\",L29)","v":"Gutschrift, Verkäufe MASTERCARD"},null,{"$f":"+IF(K29=\"\",\"\",K29)","v":"2020-04-20"},759.2,null,null,{"$f":"+IF($L$6=\"\",\"\",$L$6+1)","v":"2020-04-15"},{"$f":"+IF($L$6=\"\",\"\",$L$6+2)","v":"2020-04-16"},"Taxi 2700 dankt MAESTRO ",-9]
[null,null,"2020-04-17",{"$f":"+IF(L30=\"\",\"\",L30)","v":"Bareinlage"},null,"2020-04-20",1500,null,null,{"$f":"+IF($L$6=\"\",\"\",$L$6+3)","v":"2020-04-17"},{"$f":"+IF($L$6=\"\",\"\",$L$6+6)","v":"2020-04-20"},"Gutschrift, Verkäufe MASTERCARD",759.2]
[null,null,"2020-04-20",{"$f":"+IF(L31=\"\",\"\",L31)","v":"Gutschrift, Verkäufe MAESTRO"},null,"2020-04-21",249.8,null,null,{"$f":"+IF($L$6=\"\",\"\",$L$6+3)","v":"2020-04-17"},{"$f":"+IF($L$6=\"\",\"\",$L$6+6)","v":"2020-04-20"},"Bareinlage",1500]
[null,null,"",{"$f":"+IF(L32=\"\",\"\",L32)","v":""},null,"","",null,null,{"$f":"+IF($L$6=\"\",\"\",$L$6+6)","v":"2020-04-20"},{"$f":"+IF($L$6=\"\",\"\",$L$6+7)","v":"2020-04-21"},"Gutschrift, Verkäufe MAESTRO",249.8]
[null,null,"",{"$f":"+IF(L33=\"\",\"\",L33)","v":""},null,"",""]
[null,null,"",{"$f":"+IF(L34=\"\",\"\",L34)","v":""},null,"",""]
[]
[null,null,"Alter","Summe","Summe ","Neuer","Neuer"]
[null,null,"Kontostand","Belastungen","Gutschriften","Kontostand"]
[null,null,{"$f":"+IF(L20=\"\",0,L20)","v":-59.87},{"$f":"+SUMIFS(G27:G33,G27:G33,\"<0\")","v":-9},{"$f":"+SUMIFS(G27:G33,G27:G33,\">0\")","v":2509},{"$f":"+SUM(C37:E37)","v":2440.13}]
[null,null,null,null,null,{"$f":"+IF(L19=\"\",\"\",CONCATENATE(\"Auszug \",L19))","v":"Auszug 08 - 1 von 1"}]

{"sheet":"AR.","index":6,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[52,2,52,3],[52,4,52,5],[52,6,52,8],[53,2,53,3],[53,4,53,5],[53,6,53,8],[51,2,51,5],[32,5,32,6],[32,12,32,15],[33,12,33,15],[34,12,34,15],[35,12,35,15],[36,12,36,15],[40,6,42,8],[41,2,41,3],[42,2,42,3],[46,2,48,6],[27,2,27,4],[27,11,27,12],[28,2,28,4],[29,2,29,4],[30,11,31,11],[30,12,31,15],[31,5,31,6],[24,2,24,4],[24,11,24,12],[25,2,25,4],[25,11,25,12],[26,2,26,4],[26,11,26,12],[23,2,23,4],[23,11,23,12],[14,2,14,4],[13,12,13,15],[15,12,15,15],[16,12,16,15],[18,2,18,3],[19,11,19,12],[20,11,20,12],[21,4,21,8],[21,11,21,12],[22,2,22,4],[22,11,22,12],[14,12,14,15],[11,2,11,3],[10,12,10,15],[12,2,12,4],[11,12,11,15],[13,2,13,4],[12,12,12,15],[9,12,9,15],[0,11,0,15],[0,17,1,17],[2,2,4,3],[2,12,2,15],[3,5,3,6],[3,7,3,8],[3,12,3,15],[4,5,4,6],[4,7,4,8],[4,12,4,15],[4,17,5,17],[5,12,5,15],[6,12,6,15],[7,12,7,15],[8,12,8,15]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!B1","v":"Verändern Sie hier den Beleg:"},null,null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[]
[null,null,{"$f":"IF(M4=\"\",\"\",M4)","v":"Ira Dittmann e.U."},null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A27","v":"Geschäftsbezeichnung"},{"$f":"+Belegverwaltung!E13","v":"Musikhaus"}]
[null,null,null,null,{"$f":"+IF(M7=\"\",\"\",M7)","v":"+43 2622 24 163"},{"$f":"+IF(M5=\"\",\"\",M5)","v":"Bahngasse 25"},null,{"$f":"+IF(M9=\"\",\"\",M9)","v":"www.musikhaus.ac.at"},null,null,null,{"$f":"intern_Datenblatt!A29","v":"Firma"},{"$f":"+Belegverwaltung!E11","v":"Ira Dittmann e.U."}]
[null,null,null,null,{"$f":"+IF(M8=\"\",\"\",M8)","v":"+43 2622 24 163 - 49"},{"$f":"+IF(M6=\"\",\"\",M6)","v":"2700 Wiener Neustadt"},null,{"$f":"+IF(M9=\"\",\"\",CONCATENATE(\"office@\",MID(M9,5,LEN(M9)-4)))","v":"office@musikhaus.ac.at"},null,null,null,{"$f":"+intern_Datenblatt!A64","v":"Straße"},{"$f":"+Belegverwaltung!E15","v":"Bahngasse 25"},null,null,null,null,"Zum Zahlungseingang"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A51","v":"PLZ und Ort"},{"$f":"+Belegverwaltung!E17","v":"2700 Wiener Neustadt"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A66","v":"Telefon"},{"$f":"+Belegverwaltung!E19","v":"+43 2622 24 163"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A25","v":"Fax"},{"$f":"+Belegverwaltung!E21","v":"+43 2622 24 163 - 49"},null,null,null,null,{"$f":"intern_Datenblatt!B4","v":"Beleg kopieren"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A73","v":"Website"},{"$f":"+Belegverwaltung!E23","v":"www.musikhaus.ac.at"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A67","v":"UID-Nummer"},{"$f":"+Belegverwaltung!E25","v":"ATU15354408"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A7","v":"Anrede"},"Frau"]
[null,null,{"$f":"+IF(M11=\"\",\"\",M11)","v":"Frau"},null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A34","v":"Kundenname"},"Nina Rauscher"]
[null,null,{"$f":"+IF(M12=\"\",\"\",M12)","v":"Nina Rauscher"},null,null,null,null,{"$f":"IF(M17=\"\",\"\",\"Rechnung\")","v":"Rechnung"},{"$f":"IF(M17=\"\",\"\",M17)","v":1058},null,null,{"$f":"intern_Datenblatt!A64","v":"Straße"},"Fabrikstraße 4",null,null,null,null,{"$f":"M12","v":"Nina Rauscher"}]
[null,null,{"$f":"+IF(M13=\"\",\"\",M13)","v":"Fabrikstraße 4"},null,null,null,null,{"$f":"IF(M16=\"\",\"\",\"Kunde\")","v":"Kunde"},{"$f":"IF(M16=\"\",\"\",M16)","v":4526},null,null,{"$f":"intern_Datenblatt!A51","v":"PLZ und Ort"},"2522 Oberwaltersdorf"]
[null,null,{"$f":"+IF(M14=\"\",\"\",M14)","v":"2522 Oberwaltersdorf"},null,null,null,null,{"$f":"IF(M15=\"\",\"\",L15)","v":"Datum"},{"$f":"IF(M15=\"\",\"\",M15)","v":"2020-04-22"},null,null,{"$f":"+intern_Datenblatt!A20","v":"Datum"},{"$f":"+DATE(YEAR(TODAY()),4,22)","v":"2020-04-22"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A35","v":"Kundennummer"},4526]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A58","v":"Rechnungsnummer"},1058]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A17","v":"Bezeichnung"},null,{"$f":"+intern_Datenblatt!A42","v":"Menge"},{"$f":"intern_Datenblatt!A46","v":"Netto/EH"},{"$f":"+intern_Datenblatt!A72","v":"USt %"}]
[null,null,null,null,null,null,null,null,null,null,null,"ProArte Konzertgitarre GC230 II ",null,1,245,20]
[null,null,null,null,null,null,null,null,null,null,null,"Gigbag schwarz",null,1,24,20]
[null,null,{"$f":"IF(L21=\"\",\"\",L21)","v":"ProArte Konzertgitarre GC230 II "},null,null,{"$f":"IF(O21=\"\",\"\",O21)","v":245},{"$f":"IF(N21=\"\",\"\",N21)","v":1},{"$f":"IF(P21=\"\",\"\",CONCATENATE(P21,\" %\"))","v":"20 %"},{"$f":"IFERROR(IF(F23=\"\",O21,G23*F23),\"\")","v":245},null,null,"Hercules Stands GS414B",null,1,29,20]
[null,null,"Gigbag schwarz",null,null,{"$f":"IF(O22=\"\",\"\",O22)","v":24},{"$f":"IF(N22=\"\",\"\",N22)","v":1},{"$f":"IF(P22=\"\",\"\",CONCATENATE(P22,\" %\"))","v":"20 %"},24,null,null,"K&M 14670 Footrest Black",null,1,12,20]
[null,null,"Hercules Stands GS414B",null,null,29,1,"20 %",29,null,null,"Harley Benton Security Locks BK",null,1,6,20]
[null,null,"K&M 14670 Footrest Black",null,null,12,1,"20 %",12,null,null,"Ernie Ball 14037 Nylongurt",null,1,7,20]
[null,null,"Harley Benton Security Locks BK",null,null,6,1,"20 %",6]
[null,null,"Ernie Ball 14037 Nylongurt",null,null,7,1,"20 %",7]
[null,null,"",null,null,"","","",0]
[null,null,"",null,null,"","","",0]
[null,null,null,null,null,"Zwischensumme",null,null,{"$f":"IF(I23=\"\",\"\",SUM(I23:I30))","v":323},null,null,{"$f":"+intern_Datenblatt!A76","v":"Zahlungskonditionen"},"7 Tage 2 % Skonto; 30 Tage netto"]
[null,null,null,null,null,{"$f":"IF(I32=0,\"\",\"Umsatzsteuer 20 %\")","v":"Umsatzsteuer 20 %"},null,null,{"$f":"SUMIFS($I$23:$I$30,$P$21:$P$28,20)*0.2","v":64.600000000000009}]
[null,null,null,null,null,{"$f":"IF(I33=0,\"\",\"Umsatzsteuer 10 %\")","v":""},null,null,{"$f":"SUMIFS($I$23:$I$30,$P$21:$P$28,10)*0.1","v":0},null,null,{"$f":"intern_Datenblatt!A10","v":"Bank"},{"$f":"Belegverwaltung!E27","v":"BKS Bank AG"}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I31:I33)","v":387.6},null,null,{"$f":"intern_Datenblatt!A33","v":"IBAN"},{"$f":"Belegverwaltung!E31","v":"AT761700000180024810"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A18","v":"BIC"},{"$f":"Belegverwaltung!E29","v":"BFKKAT2K"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A30","v":"Gerichtsstand"},"Wien"]
[null,null,{"$f":"IF(M31=\"\",\"\",L31)","v":"Zahlungskonditionen"},null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A70","v":"Unterschrift"},"Dittmann"]
[null,null,{"$f":"IF(M31=\"\",\"\",M31)","v":"7 Tage 2 % Skonto; 30 Tage netto"}]
[null,null,"Lieferdatum entspricht Rechnungsdatum"]
[]
[null,null,null,null,null,null,{"$f":"IF(M37=\"\",\"\",M37)","v":"Dittmann"}]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(M4=\"\",\"\",M4)","v":"Ira Dittmann e.U."}]
[]
[null,null,"Es gelten die allgemeinen Geschäftsbedingungen des Unternehmens in der aktuellen Fassung.\nDer Kaufgegenstand bleibt bis zur vollständigen Bezahlung des Kaufpreises und aller damit verbundenen Kosten und Spesen in unserem Eigentum."]
[]
[]
[]
[]
[null,null,{"$f":"+IF(M33=\"\",\"\",CONCATENATE(L33,\": \",M33))","v":"Bank: BKS Bank AG"}]
[null,null,{"$f":"+IF(M34=\"\",\"\",CONCATENATE(L34,\": \",M34))","v":"IBAN: AT761700000180024810"},null,{"$f":"+IF(M10=\"\",\"\",CONCATENATE(L10,\": \",M10))","v":"UID-Nummer: ATU15354408"},null,{"$f":"IF(M3=\"\",\"\",M3)","v":"Musikhaus"}]
[null,null,{"$f":"+IF(M35=\"\",\"\",CONCATENATE(L35,\": \",M35))","v":"BIC: BFKKAT2K"},null,{"$f":"+IF(M36=\"\",\"\",CONCATENATE(L36,\": \",M36))","v":"Gerichtsstand: Wien"},null,{"$f":"IF(M4=\"\",\"\",M4)","v":"Ira Dittmann e.U."}]

{"sheet":"Kontoauszug BKS","index":7,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,2,32,4],[32,6,33,7],[35,2,35,3],[25,11,25,12],[25,13,25,14],[26,11,26,12],[26,13,26,14],[27,2,27,3],[31,2,31,4],[22,11,23,12],[22,13,23,14],[22,16,23,16],[24,2,24,3],[24,11,24,12],[24,13,24,14],[21,11,21,12],[21,13,21,14],[9,3,9,4],[11,2,11,3],[12,2,12,3],[13,2,13,3],[15,11,16,11],[15,12,16,12],[15,14,16,14],[16,2,16,6],[20,6,20,7],[20,11,20,12],[20,13,20,14],[7,3,7,4],[7,11,7,12],[7,13,7,14],[8,3,8,4],[8,11,8,12],[8,13,8,14],[5,3,5,4],[5,11,5,12],[5,13,5,14],[6,3,6,4],[6,11,6,12],[6,13,6,14],[3,3,3,4],[3,6,3,7],[3,11,3,12],[3,13,3,14],[4,3,4,4],[4,11,4,12],[4,13,4,14],[0,11,0,14],[0,16,1,16],[0,17,1,17],[1,5,1,6],[2,5,2,6],[2,11,2,12],[2,13,2,14]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!B1","v":"Verändern Sie hier den Beleg:"},null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[null,null,null,null,null,{"$f":"IF(N6=\"\",\"\",CONCATENATE(L6,\": \",N6))","v":"BIC: BFKKAT2K"}]
[null,null,null,null,"Kontoauszug",{"$f":"IF(N7=\"\",\"\",CONCATENATE(L7,\":  \",N7))","v":"IBAN:  AT761700000180024810"},null,null,null,null,null,{"$f":"intern_Datenblatt!A29","v":"Firma"},null,{"$f":"+Belegverwaltung!E11","v":"Ira Dittmann e.U."}]
[null,null,{"$f":"+intern_Datenblatt!A20","v":"Datum"},"Buchungstext",null,"Wert","Betrag",null,null,null,null,{"$f":"+intern_Datenblatt!A64","v":"Straße"},null,{"$f":"+Belegverwaltung!E15","v":"Bahngasse 25"}]
[null,null,{"$f":"IF(N21=\"\",\"\",N21)","v":"2020-04-27"},{"$f":"CONCATENATE(N22,\"  \",N27)","v":"Nina Rauscher  Re. 1058 abzgl. Skonto"},null,{"$f":"IF(N21=\"\",\"\",N21)","v":"2020-04-27"},{"$f":"IF(N26=\"\",\"\",N26)","v":379.84800000000001},null,null,null,null,{"$f":"+intern_Datenblatt!A51","v":"PLZ und Ort"},null,{"$f":"+Belegverwaltung!E17","v":"2700 Wiener Neustadt"},null,null,{"$f":"intern_Datenblatt!B4","v":"Beleg kopieren"}]
[null,null,{"$f":"IF(L13=\"\",\"\",L13)","v":"2020-04-27"},{"$f":"IF(N13=\"\",\"\",N13)","v":"Geschäftsmiete"},null,{"$f":"IF(M13=\"\",\"\",M13)","v":"2020-04-27"},{"$f":"IF(O13=\"\",\"\",O13)","v":-825.47},{"$f":"IF(O13<0,\"-\",\"\")","v":"-"},null,null,null,{"$f":"+intern_Datenblatt!A18","v":"BIC"},null,{"$f":"+Belegverwaltung!E29","v":"BFKKAT2K"}]
[null,null,{"$f":"IF(L14=\"\",\"\",L14)","v":"2020-04-24"},{"$f":"IF(N14=\"\",\"\",N14)","v":"Barabhebung"},null,{"$f":"IF(M14=\"\",\"\",M14)","v":"2020-04-24"},{"$f":"IF(O14=\"\",\"\",O14)","v":-1200},{"$f":"IF(O14<0,\"-\",\"\")","v":"-"},null,null,null,{"$f":"+intern_Datenblatt!A33","v":"IBAN"},null,{"$f":"+Belegverwaltung!E31","v":"AT761700000180024810"},null,null,{"$f":"LEFT(N7,9)","v":"AT7617000"}]
[null,null,{"$f":"IF(L15=\"\",\"\",L15)","v":"2020-04-23"},{"$f":"IF(N15=\"\",\"\",N15)","v":"Gehälter"},null,{"$f":"IF(M15=\"\",\"\",M15)","v":"2020-04-23"},{"$f":"IF(O15=\"\",\"\",O15)","v":-9852.15},{"$f":"IF(O15<0,\"-\",\"\")","v":"-"},null,null,null,"Alter Kontostand",null,24256.2,null,null,{"$f":"RIGHT(Q7,5)","v":"17000"}]
[null,null,{"$f":"IF(L16=\"\",\"\",L16)","v":""},{"$f":"IF(N16=\"\",\"\",N16)","v":""},null,{"$f":"IF(M16=\"\",\"\",M16)","v":""},{"$f":"IF(O16=\"\",\"\",O16)","v":""},{"$f":"IF(O16<0,\"-\",\"\")","v":""},null,null,null,"Auszug",null,19]
[null,null,null,{"$f":"IF(N17=\"\",\"\",N17)","v":""}]
[null,null,null,null,"Alter Kontostand",null,{"$f":"IF(N8=\"\",\"\",N8)","v":24256.2},{"$f":"IF(N8<0,\"-\",\"\")","v":""}]
[null,null,{"$f":"IF(N3=\"\",\"\",N3)","v":"Ira Dittmann e.U."},null,"Summe Gutschriften",null,{"$f":"SUMIFS($G$5:$G$9,$H$5:$H$9,\"\")","v":379.84800000000001},null,null,null,null,"Datum","Wert","Text",{"$f":"+intern_Datenblatt!A16","v":"Betrag"}]
[null,null,{"$f":"IF(N4=\"\",\"\",N4)","v":"Bahngasse 25"},null,"Summe Belastungen",null,{"$f":"SUMIFS($G$5:$G$9,$H$5:$H$9,\"-\")","v":-11877.619999999999},{"$f":"IF(G13=0,\"\",\"-\")","v":"-"},null,null,null,{"$f":"+IF(N21=\"\",\"\",N21)","v":"2020-04-27"},{"$f":"+IF(L13=\"\",\"\",L13)","v":"2020-04-27"},"Geschäftsmiete",-825.47]
[null,null,{"$f":"IF(N5=\"\",\"\",N5)","v":"2700 Wiener Neustadt"},null,"Neuer Kontostand in EUR",null,{"$f":"SUM(G11:G13)","v":12758.428000000004},{"$f":"IF(SUM(G11:G13)<0,\"-\",\"\")","v":""},null,null,null,{"$f":"+IF(N21=\"\",\"\",N21-3)","v":"2020-04-24"},{"$f":"+IF(L14=\"\",\"\",L14)","v":"2020-04-24"},"Barabhebung",-1200]
[null,null,null,null,"Buchungen bis",{"$f":"IF(N9=\"\",\"\",CONCATENATE(L9,\":   \",N9))","v":"Auszug:   19"},"Blatt 1 von 1",null,null,null,null,{"$f":"+IF(N21=\"\",\"\",N21-4)","v":"2020-04-23"},{"$f":"+IF(L15=\"\",\"\",L15)","v":"2020-04-23"},"Gehälter",-9852.15]
[null,null,"* vor Buchungstext = Beleg liegt bei. Rechtsform: Aktiengesellschaft, Sitz Klagenfurt, Firmenbuch-Nr: FN 91810s/Klagenfurt"]
[null,null,"Guthaben auf diesem Konto sind gemäß Einlagensicherungs- und Anlegerentschädigungsgesetz erstattungsfähig. Details finden Sie im \"Informationsbogen für Einleger\" in Ihrer Filiale oder unter www.bks.at"]
[]
[]
[]
[null,null,"Überweisung ",{"$f":"IF(Q25=\"\",\"\",Q25)","v":"43000"},null,{"$f":"IF(C25=\"\",\"\",C25)","v":"00180024810"},"Gutschrift",null,null,null,null,{"$f":"+intern_Datenblatt!A20","v":"Datum"},null,{"$f":"+IF(AR.!M15=\"\",\"\",AR.!M15+5)","v":"2020-04-27"},null,null,{"$f":"CONCATENATE(\"/ \",RANDBETWEEN(10000000000,99999999999))","v":"/ 85992008367"}]
[null,null,"durch",{"$f":"IF(N21=\"\",\"\",N21)","v":"2020-04-27"},"1900 /",{"$f":"IF(N21=\"\",\"\",N21)","v":"2020-04-27"},null,null,null,null,null,"Auftraggeber",null,{"$f":"AR.!M12","v":"Nina Rauscher"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A33","v":"IBAN"},null,"AT094300000000044152",null,null,{"$f":"LEFT(N23,9)","v":"AT0943000"}]
[]
[null,null,{"$f":"RIGHT(N7,11)","v":"00180024810"},null,null,null,{"$f":"IF(Q8=\"\",\"\",Q8)","v":"17000"},null,null,null,null,{"$f":"+intern_Datenblatt!A18","v":"BIC"},null,"VBOEATWW",null,null,{"$f":"RIGHT(Q23,5)","v":"43000"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A16","v":"Betrag"},null,{"$f":"AR.!I34*0.98","v":379.84800000000001}]
[null,null,null,null,null,null,null,null,null,null,null,"Verwendungszweck",null,{"$f":"+CONCATENATE(\"Re. \",AR.!M17,\" abzgl. Skonto\")","v":"Re. 1058 abzgl. Skonto"}]
[null,null,{"$f":"IF(N27=\"\",\"\",N27)","v":"Re. 1058 abzgl. Skonto"}]
[]
[]
[]
[null,null,{"$f":"IF(N23=\"\",\"\",CONCATENATE(\"AUFTRAGGEBER-IBAN: \",N23))","v":"AUFTRAGGEBER-IBAN: AT094300000000044152"}]
[null,null,{"$f":"IF(N25=\"\",\"\",CONCATENATE(\"AUFTRAGGEBER-BIC: \",N25))","v":"AUFTRAGGEBER-BIC: VBOEATWW"},null,null,null,{"$f":"IF(N26=\"\",\"\",N26)","v":379.84800000000001}]
[]
[]
[null,null,{"$f":"IF(N23=\"\",\"\",RIGHT(N23,11))","v":"00000044152"},null,{"$f":"IF(N22=\"\",\"\",N22)","v":"Nina Rauscher"}]

{"sheet":"Kassenbon Rabatt&Skonto","index":8,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,3,3,6],[38,2,38,6],[33,3,33,4],[33,5,33,6],[34,3,34,4],[34,5,34,6],[35,2,35,6],[37,2,37,6],[36,2,36,6],[32,3,32,6],[26,2,26,3],[27,2,27,4],[27,5,27,6],[28,2,28,4],[29,2,29,5],[23,2,23,4],[25,10,25,12],[25,2,25,3],[4,3,5,6],[30,2,30,6],[21,2,21,4],[14,2,14,6],[12,10,12,12],[15,2,15,6],[16,2,16,4],[17,9,17,10],[17,2,17,4],[18,9,18,10],[18,2,18,4],[19,2,19,4],[20,9,20,10],[21,9,21,10],[15,10,15,12],[19,9,19,10],[24,10,24,12],[10,5,10,6],[14,10,14,12],[23,10,23,12],[11,3,11,4],[9,10,9,12],[12,2,12,6],[10,10,10,12],[13,2,13,6],[11,10,11,12],[8,2,8,6],[13,10,13,12],[0,9,0,12],[0,14,1,14],[2,10,2,12],[3,10,3,12],[4,10,4,12],[5,10,5,12],[6,2,6,6],[6,10,6,12],[7,2,7,6],[7,10,7,12],[9,2,9,3],[9,5,9,6],[8,10,8,12],[10,2,10,3]]}
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!B1","v":"Verändern Sie hier den Beleg:"},null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[]
[null,null,null,{"$f":"IF(K4=\"\",\"\",UPPER(K4))","v":"FARBEN & EISENWAREN"},null,null,null,null,null,{"$f":"+intern_Datenblatt!A29","v":"Firma"},"Golla OG",null,null,null,null,null,{"$f":"+K3","v":"Golla OG"}]
[null,null,null,null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A62","v":"Slogan"},"Farben & Eisenwaren"]
[null,null,null,{"$f":"IF(K3=\"\",\"\",K3)","v":"Golla OG"},null,null,null,null,null,{"$f":"intern_Datenblatt!A64","v":"Straße"},"Bräunlichgasse 11",null,null,null,{"$f":"intern_Datenblatt!B4","v":"Beleg kopieren"}]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A51","v":"PLZ und Ort"},"2700 Wiener Neustadt"]
[null,null,{"$f":"(IF(K6=\"\",\"\",CONCATENATE(K6,\", \",K5)))","v":"2700 Wiener Neustadt, Bräunlichgasse 11"},null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A67","v":"UID-Nummer"},"ATU69869324"]
[null,null,{"$f":"+IF(K7=\"\",\"\",K7)","v":"ATU69869324"},null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A37","v":"Kassier/in"},"Grasser"]
[null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!A73","v":"Website"},"www.golla.at"]
[null,null,{"$f":"+CONCATENATE(\"Kasse: \",RANDBETWEEN(1,4))","v":"Kasse: 3"},null,null,{"$f":"+CONCATENATE(\"Filiale: \",RANDBETWEEN(10,99))","v":"Filiale: 56"},null,null,null,{"$f":"+intern_Datenblatt!A34","v":"Kundenname"},{"$f":"Belegverwaltung!E11","v":"Ira Dittmann e.U."}]
[null,null,{"$f":"+CONCATENATE(J8,\": \",K8)","v":"Kassier/in: Grasser"},null,"Bon:",{"$f":"+CONCATENATE(RANDBETWEEN(10,99),\"-\",K14,\"-\",RANDBETWEEN(10000,99999))","v":"80-43949-69495"},null,null,null,{"$f":"intern_Datenblatt!A64","v":"Straße"},{"$f":"Belegverwaltung!E15","v":"Bahngasse 25"}]
[null,null,{"$f":"CONCATENATE(J14,\":\",)","v":"Datum:"},{"$f":"IF(K14=\"\",\"\",K14)","v":"2020-04-28"},null,"Zeit:",{"$f":"+RAND()*0.375+0.375","v":"12:09:53.491"},null,null,{"$f":"intern_Datenblatt!A51","v":"PLZ und Ort"},{"$f":"Belegverwaltung!E17","v":"2700 Wiener Neustadt"}]
[null,null,{"$f":"IF(K10=\"\",\"\",\"KUNDENDATEN\")","v":"KUNDENDATEN"},null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A67","v":"UID-Nummer"},{"$f":"Belegverwaltung!E25","v":"ATU15354408"}]
[null,null,{"$f":"IF(K10=\"\",\"\",K10)","v":"Ira Dittmann e.U."},null,null,null,null,null,null,{"$f":"intern_Datenblatt!A20","v":"Datum"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2020-04-28"}]
[null,null,{"$f":"CONCATENATE(K11,\"  \",K12)","v":"Bahngasse 25  2700 Wiener Neustadt"},null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A75","v":"Auswahl Zahlungsart"},"MAESTRO",null,null,null,{"$f":"IF(K15=\"AUF ZIEL\",\"NEIN\",\"JA\")","v":"JA"}]
[null,null,{"$f":"IF(K13=\"\",\"\",K13)","v":"ATU15354408"},null,null,null,null,null,null,{"$f":"+intern_Datenblatt!A28","v":"Logoauswahl"},"Logo14"]
[null,null,{"$f":"(IF(J19=\"\",\"\",J19))","v":"TecTake Werkstattregal 180"},null,null,{"$f":"IF(M19=20,\"20 %\",IF(M19=10,\"10 %\",\"\"))","v":"20 %"},{"$f":"+IF(L19=\"\",\"\",L19)","v":49.9}]
[null,null,{"$f":"(IF(J20=\"\",\"\",J20))","v":"TecTake Werkstattregal 100"},null,null,{"$f":"IF(M20=20,\"20 %\",IF(M20=10,\"10 %\",\"\"))","v":"20 %"},{"$f":"+IF(L20=\"\",\"\",L20)","v":35.9},null,null,{"$f":"intern_Datenblatt!A17","v":"Bezeichnung"},null,{"$f":"intern_Datenblatt!A46","v":"Netto/EH"},{"$f":"intern_Datenblatt!A72","v":"USt %"}]
[null,null,{"$f":"(IF(J21=\"\",\"\",J21))","v":"Bosch DIY Akku-Schrauber IXO"},null,null,"20 %",{"$f":"+IF(L21=\"\",\"\",L21)","v":38.99},null,null,"TecTake Werkstattregal 180",null,49.9,20]
[null,null,{"$f":"(IF(J22=\"\",\"\",J22))","v":"Wandbefestigung Regal"},null,null,{"$f":"IF(M22=20,\"20 %\",IF(M22=10,\"10 %\",\"\"))","v":"20 %"},{"$f":"+IF(L22=\"\",\"\",L22)","v":11.9},null,null,"TecTake Werkstattregal 100",null,35.9,20]
[null,null,null,null,null,null,{"$f":"SUM(G17:G20)","v":136.69},null,null,"Bosch DIY Akku-Schrauber IXO",null,38.99,20]
[null,null,{"$f":"IF(K24=\"\",\"\",CONCATENATE(\"- \",K24,\" % \",K25))","v":"- 5 % Stammkundenrabatt"},null,null,null,{"$f":"IF(K24=\"\",0,ROUND(G21*K24/100,2))","v":6.83},null,null,"Wandbefestigung Regal",null,11.9,20]
[null,null,null,null,null,null,{"$f":"G21-G22","v":129.85999999999999}]
[null,null,{"$f":"IF(K26=\"\",\"\",CONCATENATE(\"- \",K26,\" % Skonto\"))","v":"- 2 % Skonto"},null,null,null,{"$f":"IF(K26=\"\",0,ROUND(G23*K26/100,2))","v":2.6},null,null,{"$f":"intern_Datenblatt!A79","v":"Rabatt Prozentsatz"},5]
[null,null,null,null,null,null,{"$f":"G23-G24","v":127.25999999999999},null,null,{"$f":"intern_Datenblatt!A78","v":"Rabattart"},"Stammkundenrabatt"]
[null,null,{"$f":"IF(E26=0,\"\",\"20 % USt von\")","v":"20 % USt von"},null,{"$f":"+SUMIFS(L19:L22,M19:M22,20)*(100-K24)/100*(100-K26)/100","v":127.25839000000001},null,{"$f":"E26*0.2","v":25.451678000000001},null,null,"Skonto Prozentsatz",2]
[null,null,{"$f":"IF(E27=0,\"\",\"10 % USt von\")","v":""},null,{"$f":"SUMIFS(L19:L22,M19:M22,10)*(100-K24)/100*(100-K26)/100","v":0},null,{"$f":"+E27*0.1","v":0}]
[null,null,"TOTAL IN EUR",null,null,{"$f":"SUM(G25:G27)","v":152.71167800000001}]
[null,null,{"$f":"+CONCATENATE(\"Gegeben \",IF(K15=\"BAR\",\"BAR EUR\",\"Karte EUR\"))","v":"Gegeben Karte EUR"},null,null,null,{"$f":"IF(K15=\"BAR\",ROUNDUP(F28,-1),F28)","v":152.71167800000001}]
[null,null,{"$f":"IF(K15=\"\",\"\",IF(K15=\"BAR\",\"Rückgeld EUR\",K15))","v":"MAESTRO"},null,null,null,{"$f":"IF(K15=\"BAR\",G29-F28,\"\")","v":""}]
[null,null,{"$f":"IF(K15=\"\",\"\",IF(C30=\"Rückgeld EUR\",\"\",\"BEZAHLT\"))","v":"BEZAHLT"}]
[null,null,{"$f":"IF(K15=\"\",\"\",IF(C30=\"Rückgeld EUR\",\"Stammkunde werden\",\"\"))","v":""},{"$f":"IF(K15=\"\",\"\",IF($C$30=\"Rückgeld EUR\",\"\",$K$14/3))","v":14649.666666666666},{"$f":"IF(K15=\"\",\"\",IF($C$30=\"Rückgeld EUR\",\"\",$K$14*56))","v":2461144},{"$f":"IF(K15=\"\",\"\",IF(K15=\"BAR\",\"\",K14))","v":"2020-04-28"},{"$f":"IF(K15=\"\",\"\",IF($C$30=\"Rückgeld EUR\",\"\",$K$14*561))","v":24655389}]
[null,null,{"$f":"IF(K15=\"\",\"\",IF(C30=\"Rückgeld EUR\",\"lohnt sich doppelt!\",\"\"))","v":""},{"$f":"IF(K15=\"\",\"\",IF($C$30=\"Rückgeld EUR\",\"\",\"EA0000000041359\"))","v":"EA0000000041359"}]
[null,null,{"$f":"IF(K15=\"\",\"\",IF(C30=\"Rückgeld EUR\",\"Laufend tolle Aktionen!\",\"\"))","v":""},{"$f":"IF(K15=\"\",\"\",IF($C$30=\"Rückgeld EUR\",\"\",IF($C$30=\"MAESTRO\",\"PAN: \",\"Karte:\")))","v":"PAN: "},null,{"$f":"IF(K15=\"\",\"\",IF($C$30=\"Rückgeld EUR\",\"\",IF($C$30=\"MAESTRO\",\"**** **** **** 4523\",\" **** **** **** 4523\")))","v":"**** **** **** 4523"}]
[null,null,null,{"$f":"IF(K15=\"\",\"\",IF($C$30=\"Rückgeld EUR\",\"\",IF($C$30=\"MAESTRO\",\"\",\"Gültig bis:\")))","v":""},null,{"$f":"IF(K15=\"\",\"\",IF($C$30=\"Rückgeld EUR\",\"\",IF($C$30=\"MAESTRO\",\"\",K14+458)))","v":""}]
[null,null,"VIELEN DANK FÜR IHREN EINKAUF!"]
[null,null,"Rechnungsdatum = Lieferdatum"]
[]
[null,null,{"$f":"IF(K9=\"\",\"\",K9)","v":"www.golla.at"}]

{"sheet":"Logoübersicht","index":9,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[23,1,23,2],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[1,1,1,10],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10]]}
[]
[null,"Logoübersicht",null,null,null,null,null,null,null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[]
[null,"Logo 01",null,"Logo 02",null,"Logo 03",null,"Logo 04",null,"Logo 05"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Logo 06",null,"Logo 07",null,"Logo 08",null,"Logo 09",null,"Logo 10"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Logo 11",null,"Logo 12",null,"Logo 13",null,"Logo 14",null,"Logo 15"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Logo 16",null,"Logo 17",null,"Logo 18",null,"Logo 19",null,"Logo 20"]

{"sheet":"Hilfe","index":10,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[3,1,4,3],[8,1,9,3],[33,1,34,4],[29,1,30,1],[29,2,30,2],[6,1,6,4],[24,1,27,4],[29,3,30,3]]}
[]
[null,"Hilfe"]
[]
[null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[]
[]
[null,"Diesen Button finden Sie rechts neben jedem Beleg. Sie kommen damit schnell zurück zur Übersicht."]
[]
[null,{"$f":"intern_Datenblatt!B4","v":"Beleg kopieren"}]
[]
[]
[null,"Mit wenigen Klicks können Sie nun die Belege zur Weiterverwendung (z.B. in Word) kopieren."]
[null,"1.       Aktivieren Sie die Makros (Erklärung siehe unten)."]
[null,"2.       Klicken Sie auf den Button „Beleg kopieren“."]
[null,"3.       Öffnen Sie Word."]
[null,"4.       Mit der Tastenkombination STRG+V können Sie den Beleg nun in Word einfügen."]
[]
[null,"So sorgen Sie dafür, dass Excel die Arbeit mit Makros zulässt:"]
[null,"1.       Klicken Sie auf die Registerkarte „Datei“."]
[null,"2.       Wählen Sie „Optionen“ (meist ganz unten auf der Seite zu finden)."]
[null,"3.       In den Optionen wechseln Sie in die Rubrik „Trust Center/Sicherheitscenter“."]
[null,"4.       Klicken Sie auf den Button „Einstellungen für das „Trust Center/Sicherheitscenter“."]
[null,"5.       Wechseln Sie danach in die Rubrik „Makroeinstellungen“."]
[null,"6.       Klicken Sie auf „Alle Makros aktivieren“."]
[null,"Lassen Sie sich dabei von der Sicherheitswarnung nicht irritieren. Nach erfolgter Arbeit mit der Belegkiste können Sie die Makros ganz einfach wieder ausschalten, indem Sie auf „Alle Makros mit Benachrichtigung deaktivieren“ klicken."]
[]
[]
[]
[]
[null,null,"Dropdown Felder"]
[]
[]
[null,null,"Dieses Symbol kennzeichnet Felder, welche eine Auswahlliste enthalten."]
[null,"Durch das Klicken in das jeweilige Feld haben Sie die Möglichkeit, die Beleg- oder Zahlungsart, das Logo, den Umsatzsteuersatz und vieles mehr auszuwählen."]

{"sheet":"Kontakt und Impressum","index":11,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[13,2,13,3],[6,1,6,4],[8,1,8,4],[12,1,12,4],[7,1,7,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[5,1,5,2],[17,2,17,3],[14,2,14,3],[27,1,27,4],[16,2,16,3],[22,2,22,3],[19,2,19,3],[21,2,21,3],[20,2,20,3],[15,2,15,3],[18,2,18,3],[25,2,25,4]]}
[]
[null,"Kontakt",null,null,null,null,null,{"$f":"intern_Datenblatt!B3","v":"Zurück zur Belegverwaltung"}]
[]
[null,"Ihre Meinung ist uns wichtig! Bitte senden Sie Wünsche, Anregungen, Kritik und Lob an folgende Adresse:"]
[]
[null,"rechnungswesen@lernenwillmehr.at"]
[]
[null,"Impressum"]
[]
[null,"Projektleitung:","Mag. Petra Salzer"]
[null,null,"Mag. Lydia Schneider"]
[null,"Inhalte und Produktion:","Mag. Silke Ramsenthaler"]
[]
[null,"Bilder: ","antishock/Shutterstock",null,"Logo 9, 13, 14, 16, 17, 18"]
[null,null,"artyway/Shutterstock",null,"Logo 7"]
[null,null,"Crystal Eye Studio/Shutterstock",null,"Logo 6"]
[null,null,"moobeer/Shutterstock",null,"Logo 1, 3, 4, 15, 20"]
[null,null,"NartGraphic/Shutterstock",null,"Logo 11"]
[null,null,"Nizwa Design/Shutterstock",null,"Logo 12"]
[null,null,"Sentavio/Shutterstock",null,"Logo 5"]
[null,null,"Sergey Korkin/Shutterstock",null,"Logo 8"]
[null,null,"svtdesign/Shutterstock",null,"Logo 10"]
[null,null,"vectortwins/Shutterstock",null,"Logo 2, 19"]
[]
[null,"Version:","V34","2020-06-01"]
[null,null,"Bitte beachten Sie, dass die Belegkiste auf Microsoft Excel 2016 entwickelt wurde."]
[]
[null,"© Hölzel Verlag GmbH"]

{"sheet":"intern_Datenblatt","index":12,"n_rows":84,"n_cols":6,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
["Überschrift für die veränderbaren Zellen:","Verändern Sie hier den Beleg:",null,null,"RGB Code für Hintergrund der Überschrift","84-168-255"]
[null,null,null,null,"RGB Code für Schattierung der veränderbaren Felder","227-233-244"]
[null,"Zurück zur Belegverwaltung"]
[null,"Beleg kopieren"]
["%","NICHT VERWENDEN"]
["Adresse",null,"Listensymbol"]
["Anrede",null,"Farbe (Grau 3)"]
["Artikelbezeichnung"]
["Art.Nr."]
["Bank"]
["Bedienung"]
["Beförderungsart"]
["Belegnummer"]
["Belegauswahl"]
["Beschreibung"]
["Betrag"]
["Bezeichnung"]
["BIC"]
["Brutto"]
["Datum"]
["Datum und Uhrzeit"]
["E-Mail"]
["EUR"]
["Es bediente Sie"]
["Fax"]
["FB-Nummer"]
["Geschäftsbezeichnung"]
["Logoauswahl"]
["Firma"]
["Gerichtsstand"]
["Gesamt"]
["Gesamtbetrag"]
["IBAN"]
["Kundenname"]
["Kundennummer"]
["Kunden-Nr."]
["Kassier/in"]
["laufende Nummer"]
["Leistung"]
["Lieferdatum"]
["LKW-Maut"]
["Menge"]
["MwSt","NICHT VERWENDEN"]
["MwSt %","NICHT VERWENDEN"]
["Netto"]
["Netto/EH"]
["Nettobetrag"]
["Nettopreis/Stk."]
["Nummer des Kassiers"]
["Ort"]
["PLZ und Ort"]
["Postleitzahl"]
["Position"]
["Preis"]
["Preis/EH"]
["Preis/Stk."]
["Rechnungsdatum"]
["Rechnungsnummer"]
["Re-Datum"]
["Re-Nr."]
["Sachbearbeiter"]
["Slogan"]
["Summe"]
["Straße"]
["Tageslosung"]
["Telefon"]
["UID-Nummer"]
["UID-Nr."]
["Umsatzsteuer"]
["Unterschrift"]
["USt","NICHT VERWENDEN"]
["USt %"]
["Website"]
["Währung"]
["Auswahl Zahlungsart"]
["Zahlungskonditionen"]
["Barzahlung","NICHT VERWENDEN"]
["Rabattart"]
["Rabatt Prozentsatz"]
["Text"]
["Stempel"]
["Staat"]
["Hinweis"]
["Einheit"]

{"sheet":"intern_DropDown","index":13,"n_rows":8,"n_cols":20,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["USt vollständig","USt Hotel","USt Taxi","USt ohne 10","LEER","Zahlungsart mit Beleg","Belegauswahl","Tageslosung Auswahl","Belegart ER","Belegart AR","Privat","Zahlungsart BK","USt Ausweis","USt Gasthaus","Berichtsart","TST","Leistungsart","Belegauswahl Anz.","Bezugsart LV","QR Code Anzeige"]
[0,0,"Personenfahrt \ninkl. 10 % USt",20,"LEER","BAR","Eingang","BAR","Rechnung","Rechnung","Private Warenentnahme","Bar","JA",10,"Tagesbericht","Umweltheizöl ÖKO","Arbeit","Anzahlung","Angestellte","JA"]
[10,10,"Botenfahrt \ninkl. 20 % USt",0,"LEER","MAESTRO","Ausgang","MAESTRO","Lieferschein","Gutschrift","Privatentnahme","Überweisung","NEIN",20,"Monatsbericht","Heizöl Extraleicht","Teile","Schlussrechnung","Arbeiter","NEIN"]
[20,20,null,null,"LEER","MASTERCARD",null,"MASTERCARD",null,null,"Privateinlage",null,null,null,null,"Diesel"]
[null,null,null,null,null,"VISA",null,"VISA ",null,null,null,null,null,null,null,"Bio-Diesel"]
[null,null,null,null,null,"AMERICAN EXPRESS",null,"AMEX",null,null,null,null,null,null,null,"Euro Super 95"]
[null,null,null,null,null,"AUF ZIEL",null,null,null,null,null,null,null,null,null,"Benzin 91"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heizöl leicht"]

{"sheet":"intern_Zahlen in Text umwandeln","index":14,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Zahlen in Worten"]
[]
[]
[]
[null,81369.47,{"$f":"IF(ROUND(VALUE(10*(100*B6-INT(100*B6))),0)>0,\"maximal 2 Nachkommastellen\",\"\")","v":""}]
[]
["a",{"$f":"IF(B6>=1000000000,\"nur unter 1 Milliarde\",IF(ABS(B6)<1,\"null\",IF(B6<0,\"minus   \",\"\")&IF(B13=0,\"\",C13)&IF(AND(B14=0,B15=0),\"\",D14)&IF(B16=0,\"\",C16)&IF(AND(B17=0,B18=0),\"\",D17)&IF(B19=0,\"\",C19)&IF(AND(B20=0,B21=0),\"\",IF(AND(B20=0,B21=1),\"eins\",D20))))&IF(F19=0,\"\",IF(A8=1,H19,H20))","v":"einundachtzigtausenddreihundertneunundsechzig    Komma siebenundvierzig"}]
[]
[null,{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B6,0,\"Null   \"),1,\"Eins   \"),2,\"Zwo   \"),3,\"Drei   \"),4,\"Vier   \"),5,\"Fünf   \"),6,\"Sechs   \"),7,\"Sieben   \")","v":"8Eins   Drei   Sechs   9,Vier   Sieben   "}]
[]
[null,null,null,null,null,null,{"$f":"ABS(100*(MOD(B6,1)-(B6<0)))","v":47.000000000116415}]
[null,{"$f":"VALUE(RIGHT(INT(ABS(B6)/100000000)))","v":0},{"$f":"IF(B13=1,\"ein\",IF(B13=2,\"zwei\",IF(B13=3,\"drei\",IF(B13=4,\"vier\",IF(B13=5,\"fünf\",IF(B13=6,\"sechs\",IF(B13=7,\"sieben\",IF(B13=8,\"acht\",\"neun\"))))))))&\"hundert\"&IF(AND(B14=0,B15=0),\"millionen\",\"\")","v":"neunhundertmillionen"},null,null,null,{"$f":"ROUND(100*(ABS(B6)-INT(ABS(B6))),0)","v":47}]
[null,{"$f":"VALUE(RIGHT(INT(ABS(B6)/10000000)))","v":0},{"$f":"IF(B14=1,\"zehn\",IF(B14=2,\"zwanzig\",IF(B14=3,\"dreißig\",IF(B14=4,\"vierzig\",IF(B14=5,\"fünfzig\",IF(B14=6,\"sechzig\",IF(B14=7,\"siebzig\",IF(B14=8,\"achtzig\",\"neunzig\"))))))))","v":"neunzig"},{"$f":"IF(AND(B14=0,B15=1),\"einemillion\",IF(AND(B14=1,B15=1),\"elf\",IF(AND(B14=1,B15=2),\"zwölf\",IF(AND(B14=1,B15=6),\"sechzehn\",IF(AND(B14=1,B15=7),\"siebzehn\",IF(B15=0,C14,IF(B14=0,C15,C15&IF(B14>1,\"und\",\"\")&C14))))))&\"millionen\")","v":"neunzigmillionen"}]
[null,{"$f":"VALUE(RIGHT(INT(ABS(B6)/1000000)))","v":0},{"$f":"IF(B15=1,\"ein\",IF(B15=2,\"zwei\",IF(B15=3,\"drei\",IF(B15=4,\"vier\",IF(B15=5,\"fünf\",IF(B15=6,\"sechs\",IF(B15=7,\"sieben\",IF(B15=8,\"acht\",\"neun\"))))))))","v":"neun"}]
[null,{"$f":"VALUE(RIGHT(INT(ABS(B6)/100000)))","v":0},{"$f":"IF(B16=1,\"ein\",IF(B16=2,\"zwei\",IF(B16=3,\"drei\",IF(B16=4,\"vier\",IF(B16=5,\"fünf\",IF(B16=6,\"sechs\",IF(B16=7,\"sieben\",IF(B16=8,\"acht\",\"neun\"))))))))&\"hundert\"&IF(AND(B17=0,B18=0),\"tausend\",\"\")","v":"neunhundert"}]
[null,{"$f":"VALUE(RIGHT(INT(ABS(B6)/10000)))","v":8},{"$f":"IF(B17=1,\"zehn\",IF(B17=2,\"zwanzig\",IF(B17=3,\"dreißig\",IF(B17=4,\"vierzig\",IF(B17=5,\"fünfzig\",IF(B17=6,\"sechzig\",IF(B17=7,\"siebzig\",IF(B17=8,\"achtzig\",\"neunzig\"))))))))","v":"achtzig"},{"$f":"IF(AND(B17=1,B18=1),\"elf\",IF(AND(B17=1,B18=2),\"zwölf\",IF(AND(B17=1,B18=6),\"sechzehn\",IF(AND(B17=1,B18=7),\"siebzehn\",IF(B18=0,C17,IF(B17=0,C18,C18&IF(B17>1,\"und\",\"\")&C17))))))&\"tausend\"","v":"einundachtzigtausend"}]
[null,{"$f":"VALUE(RIGHT(INT(ABS(B6)/1000)))","v":1},{"$f":"IF(B18=1,\"ein\",IF(B18=2,\"zwei\",IF(B18=3,\"drei\",IF(B18=4,\"vier\",IF(B18=5,\"fünf\",IF(B18=6,\"sechs\",IF(B18=7,\"sieben\",IF(B18=8,\"acht\",\"neun\"))))))))","v":"ein"}]
[null,{"$f":"VALUE(RIGHT(INT(ABS(B6)/100)))","v":3},{"$f":"IF(B19=1,\"ein\",IF(B19=2,\"zwei\",IF(B19=3,\"drei\",IF(B19=4,\"vier\",IF(B19=5,\"fünf\",IF(B19=6,\"sechs\",IF(B19=7,\"sieben\",IF(B19=8,\"acht\",\"neun\"))))))))&\"hundert\"","v":"dreihundert"},null,null,{"$f":"IF(A8=0,0,ROUND(100*(ABS(B6)-INT(ABS(B6))),0))","v":47},null,{"$f":"TEXT(F19,\"   00\")&\"/100\"","v":"   47/100"}]
[null,{"$f":"VALUE(RIGHT(INT(ABS(B6)/10)))","v":6},{"$f":"IF(B20=1,\"zehn\",IF(B20=2,\"zwanzig\",IF(B20=3,\"dreißig\",IF(B20=4,\"vierzig\",IF(B20=5,\"fünfzig\",IF(B20=6,\"sechzig\",IF(B20=7,\"siebzig\",IF(B20=8,\"achtzig\",\"neunzig\"))))))))","v":"sechzig"},{"$f":"IF(AND(B20=1,B21=1),\"elf\",IF(AND(B20=1,B21=2),\"zwölf\",IF(AND(B20=1,B21=6),\"sechzehn\",IF(AND(B20=1,B21=7),\"siebzehn\",IF(B21=0,C20,IF(B20=0,C21,C21&IF(B20>1,\"und\",\"\")&C20))))))","v":"neunundsechzig"},null,{"$f":"VALUE(RIGHT(INT(ABS(F19)/10)))","v":4},{"$f":"IF(F20=1,\"zehn\",IF(F20=2,\"zwanzig\",IF(F20=3,\"dreißig\",IF(F20=4,\"vierzig\",IF(F20=5,\"fünfzig\",IF(F20=6,\"sechzig\",IF(F20=7,\"siebzig\",IF(F20=8,\"achtzig\",\"neunzig\"))))))))","v":"vierzig"},{"$f":"\"    Komma \"&IF(F19<10,\"null \",\"\")&IF(F19=1,\"eins\",IF(AND(F20=1,F21=1),\"elf\",IF(AND(F20=1,F21=2),\"zwölf\",IF(AND(F20=1,F21=6),\"sechzehn\",IF(AND(F20=1,F21=7),\"siebzehn\",IF(F21=0,G20,IF(F20=0,G21,G21&IF(F20>1,\"und\",\"\")&G20)))))))","v":"    Komma siebenundvierzig"}]
[null,{"$f":"VALUE(RIGHT(INT(ABS(B6))))","v":9},{"$f":"IF(B21=1,\"ein\",IF(B21=2,\"zwei\",IF(B21=3,\"drei\",IF(B21=4,\"vier\",IF(B21=5,\"fünf\",IF(B21=6,\"sechs\",IF(B21=7,\"sieben\",IF(B21=8,\"acht\",\"neun\"))))))))","v":"neun"},null,null,{"$f":"VALUE(RIGHT(INT(ABS(F19))))","v":7},{"$f":"IF(F21=1,\"ein\",IF(F21=2,\"zwei\",IF(F21=3,\"drei\",IF(F21=4,\"vier\",IF(F21=5,\"fünf\",IF(F21=6,\"sechs\",IF(F21=7,\"sieben\",IF(F21=8,\"acht\",\"neun\"))))))))","v":"sieben"}]
[]
[null,{"$f":"IF(B6<0,\"minus   \",\"\")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B10,8,\"Acht   \"),9,\"Neun   \"),\",\",\"Komma   \"),\"-\",\"\")","v":"Acht   Eins   Drei   Sechs   Neun   Komma   Vier   Sieben   "}]

{"sheet":"intern_Tabelle2","index":15,"n_rows":120,"n_cols":21,"rows_kept":120,"cut":false,"hidden":true,"merged":[[99,6,99,7],[0,15,0,21],[1,15,1,19],[7,13,8,14],[9,13,10,14],[7,18,7,19],[2,15,2,16],[7,15,7,16],[12,11,13,11],[12,13,13,14],[6,15,6,16]]}
["Logo01",null,null,null,null,null,{"$f":"Belegverwaltung!#REF!","v":{"$error":"#REF!"}},"Ergebnis für Belegverwaltungsblatt",null,null,null,"Musterbeleg blau",null,null,null,"Gitternetzlinie ausblenden, damit die Logos \nkeinen  Rahmen haben\nSpalte B und N muss so breit sein wie die Logos"]
["Logo02",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Steuerberatung",null,null,null,"Musterbeleg gelb",null,null,null,"Farbauswahl für Musterbeleg"]
["Logo03",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für  LS oder ER",null,null,null,"Musterbeleg grün",null,null,null,"Musterbeleg grün",null,null,{"$f":"P3","v":"Musterbeleg grün"}]
["Logo04",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für  Bank EIN-AUS",null,null,null,"Musterbeleg lila"]
["Logo05",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Zahlungsanweisung",null,null,null,"Musterbeleg magenta"]
["Logo06",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Elektrofachmarkt",null,null,null,"Musterbeleg orange"]
["Logo07",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Möbelhaus",null,null,null,null,null,null,null,"Auswahl QR Code für Belege ohne Auswahl einer Zahlungsart (z.B. Tageslosung, Post)",null,null,null,null,"minimale Größe für gute Lesbarkeit"]
["Logo08",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Telefon",null,null,null,null,null,null,null,"QR Code 1",null,null,{"$f":"P8","v":"QR Code 1"}]
["Logo09",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für WEK oder LS",null,null,null,"QR Code 1"]
["Logo10",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Catering",null,null,null,"QR Code 2",null,null,null,"Code 2 ist nur aktuell ein Platzhalter"]
["Logo11",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Gasthaus"]
["Logo12",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Hotel-Restaurant"]
["Logo13",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Büromaterial",null,null,null,"ANZEIGE QR Code wenn Barzahlung \n\nund bei LS","JA",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Tischlerei",null,"ACHTUNG NICHT IN DER KORREKTEN REIHENFOLGE"]
["Logo14",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für KFZ-Werkstätte",null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Transport",null,"ACHTUNG NICHT IN DER KORREKTEN REIHENFOLGE"]
["Logo15",null,null,null,null,null,"Logo01","Ergebnis für Musterbank 3 (BAWAG)",null,null,null,null,"NEIN",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Büromaterial"]
["Logo16",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Tischlerei",null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Restaurant"]
["Logo17",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für Getränkehandel",null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis Trafik"]
["Logo18",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis für WEK auf Ziel Gastro",null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis Tankstelle"]
["Logo19",null,null,null,null,null,{"$f":"'EDV-Handel'!O17","v":"Logo09"},"Ergebnis EDV-Handel",null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis Hotel"]
["Logo20",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Transport",null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis Blumen"]
["kein Logo",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Bürobedarf",null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis Paper Diskont"]
[null,null,null,null,null,null,{"$f":"'Kassenbon Rabatt&Skonto'!K16","v":"Logo14"},"Ergebnis Kassenbon Rabatt&Skonto",null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis Elektrofachhandel"]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis ER EU",null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis Supermarkt"]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis ER Import",null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis Baumarkt"]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Restaurant FW",null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis KFZ-Werkstätte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Gasthaus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Maut"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Handyshop"]
[null,null,null,null,null,null,"Ab G101 - Logoauswahl-Felder für Tabellenblatt Logoauswahl",null,null,null,null,null,null,null,null,{"$f":"'EDV-Handel'!R34","v":"JA"},"Ergebnis EDV-Handel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Heizmaterial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Taxi Registrierkasse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Kassenbon Rabatt&Skonto'!O15","v":"JA"},"Ergebnis Kassenbon Rabatt & Skonto"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis Kassenbon Gutschein"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"Ergebnis Getränkehandel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Ergebnis WEK Gastro"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Logos in aufsteigender Reihenfolge für \"Logoauswahl\" Blatt"]
[]
[null,null,null,null,null,null,"Logo01","Logoauswahl Logo01"]
[null,null,null,null,null,null,"Logo02","Logoauswahl Logo02"]
[null,null,null,null,null,null,"Logo03","Logoauswahl Logo03"]
[null,null,null,null,null,null,"Logo04","Logoauswahl Logo04"]
[null,null,null,null,null,null,"Logo05","Logoauswahl Logo05"]
[null,null,null,null,null,null,"Logo06","Logoauswahl Logo06"]
[null,null,null,null,null,null,"Logo07","Logoauswahl Logo07"]
[null,null,null,null,null,null,"Logo08","Logoauswahl Logo08"]
[null,null,null,null,null,null,"Logo09","Logoauswahl Logo09"]
[null,null,null,null,null,null,"Logo10","Logoauswahl Logo10"]
[null,null,null,null,null,null,"Logo11","Logoauswahl Logo11"]
[null,null,null,null,null,null,"Logo12","Logoauswahl Logo12"]
[null,null,null,null,null,null,"Logo13","Logoauswahl Logo13"]
[null,null,null,null,null,null,"Logo14","Logoauswahl Logo14"]
[null,null,null,null,null,null,"Logo15","Logoauswahl Logo15"]
[null,null,null,null,null,null,"Logo16","Logoauswahl Logo16"]
[null,null,null,null,null,null,"Logo17","Logoauswahl Logo17"]
[null,null,null,null,null,null,"Logo18","Logoauswahl Logo18"]
[null,null,null,null,null,null,"Logo19","Logoauswahl Logo19"]
[null,null,null,null,null,null,"Logo20","Logoauswahl Logo20"]

{"sheet":"intern_BM_HAKLE2","index":16,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Blätternamen","Links"]
["Belegverwaltung"]
["Kontoauszug einzeilig MB Alpha","Kontoauszug einzeilig Musterbank Alpha"]
["EDV-Handel","EDV-Handel"]
["EDV-Handel Rabatt","EDV-Handel Rabatt"]
["AR oder Rabatt","Ausgangsrechnung oder Rabattgutschrift"]
["TL+Kontoauszug MB Beta","Tageslosung und Kontoauszug Musterbank Beta"]
["AR.","Ausgangsrechnung "]
["Kontoauszug BKS","Kontoauszug & Zahlungseingang BKS Bank"]
["Kassenbon Rabatt&Skonto","Kassenbon mit Rabatt & Skonto"]
["Logoübersicht","Logoübersicht"]
["Hilfe","Hilfe"]
["Kontakt und Impressum","Kontakt & Impressum"]

{"sheet":"intern_Belegexport","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}