{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Aufträge","Rechnung","Artikel","Kunden","Rabatt"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Aufträge","index":0,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":false,"merged":[[71,1,71,2],[72,1,72,2],[73,1,73,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[24,0,24,7],[62,1,62,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2]]}
["Aufträge"]
[]
["Die folgenden Arbeitsaufträge haben die Erstellung verschiedener Angebote bzw. Rechnungen"]
["zum Inhalt."]
[]
["Vorgehensweise"]
["1. Wählen Sie die die Tabelle \"Rechnung\"."]
[]
["2. Klicken Sie auf den Button \"Kundennummer eingeben\" und geben Sie die Kundennummer"]
["    lt. Arbeitsauftrag ein."]
["    (Wenn die Kundennummer nicht bekannt ist, müssen Sie die Kundennummer zuerst "]
["    aus der Kundendatei ermitteln.)"]
[]
["3. Legen Sie durch Aktivierung des entsprechenden Buttons fest, ob Sie ein Angebot oder"]
["    eine Rechnung in deutscher oder englischer Sprache erstellen wollen."]
[]
["4. Geben Sie dann den Auftrag lt. Aufgabenstellung ein."]
["    (Ohne Kenntnis der Artikelnummer müssen Sie diese zunächst aus der"]
["    Artikeldatei ermitteln.)"]
["    Verwenden Sie als Größenangaben Standardbezeichnungen (z.B. XXL, 106, 38, ... )."]
[]
["5. Das Angebot bzw. die Rechnung werden dann automatisch erstellt."]
[]
[]
["Arbeitsaufträge zur Angebots- und Rechnungserstellung"]
[]
["1. ","Der Kunde mit der Kundennummer 129 möchte ein Angebot über die folgenden Artikel:"]
[null,"Artikel-Nr.:","Größe","Menge"]
[null,200010,"xl",50]
[null,200010,"xxl",30]
[null,200011,"xl",40]
[null,200011,"xxl",20]
[]
["2.","Der Kunde Cassidy Ltd. Möchte ein Angebot in englischer Sprache über "]
[null,"die folgenden Artikel:"]
[null,"Artikelbezeichnung",null,"Größe","Menge"]
[null,"Tropic Jeans 001 schwarz",null,"xxl",10]
[null,"Tropic Jeans 001 schwarz",null,"xl",20]
[null,"Tropic Polohemd blau",null,"m",10]
[null,"Tropic Polohemd rot",null,"m",10]
[null,"Tropic Polohemd blau",null,"l",10]
[null,"Tropic Polohemd rot",null,"l",10]
[null,"Tropic Polohemd blau",null,"xl",15]
[null,"Tropic Polohemd rot",null,"xl",15]
[null,"Tropic Polohemd blau",null,"xxl",10]
[null,"Tropic Polohemd rot",null,"xxl",10]
[]
["3.","Erstellen Sie die Rechnung für den Kunden mit der Nummer 128 über die folgenden Artikel:"]
[null,"Artikel-Nr.:","Größe","Menge"]
[null,400010,"m",15]
[null,400011,"m",10]
[null,400020,"m",5]
[null,400021,"m",10]
[null,400030,"m",15]
[null,500010,"m",4]
[null,500011,"m",4]
[null,500020,"m",6]
[null,500021,"m",3]
[null,500022,"m",2]
[]
["4.","Die Fa. Paolo Rosso - Jeans, Milano soll eine Rechnung in englischer Sprache für"]
[null,"die folgenden Artikel erhalten:"]
[null,"Artikelbezeichnung",null,"Größe","Menge"]
[null,"Tropic Sweatshirt rot",null,"xxl",5]
[null,"Tropic Sweatshirt grau",null,"xl",4]
[null,"Tropic Sweatshirt schwarz",null,"m",3]
[null,"Tropic Sweatshirt blau",null,"m",2]
[null,"Tropic Sweatshirt weiß",null,"l",3]
[null,"Tropic Rippkleid schwarz",null,"l",4]
[null,"Tropic Rippkleid schwarz",null,"m",5]
[null,"Tropic Rippkleid rot",null,"l",6]
[null,"Tropic Rippkleid weiß",null,"m",4]
[null,"Tropic Rippkleid meergrün",null,"l",3]
[null,"Tropic Rippkleid pastellblau",null,"m",2]

{"sheet":"Rechnung","index":1,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,8,2,9],[15,0,16,0]]}
[]
[null,null,null,null,null,null,null,null," Legen Sie die Art des Beleges fest"]
["Tropic GmbH, Rheingrafenstr. 20 55543 Bad Kreuznach",null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,"deutsch","englisch"]
[]
[{"$f":"IF(C16<>0,VLOOKUP($C$16,Kunden!$B$7:$G$30,2),\"\")","v":""}]
[{"$f":"IF(C16<>0,VLOOKUP($C$16,Kunden!$B$7:$G$30,3),\"\")","v":""}]
[]
[{"$f":"IF(C16<>0,VLOOKUP($C$16,Kunden!$B$7:$G$30,4),\"\")","v":""}]
[null,null,null,null,"Rheingrafenstr. 20",null,null,null,"   Kundendaten"]
[null,null,null,null,"55543 Bad Kreuznach"]
[null,null,null,null,"Tel.: 0671/2004-0"]
[{"$f":"IF($K$3=1,\"Angebot\",IF($K$3=2,\"Rechnung\",IF($K$3=3,\"Offer\",\"Invoice\")))","v":"Rechnung"},null,null,null,"Fax: (49) 0671/2004-10"]
[]
[]
[{"$f":"IF(OR(K3=1,K3=2),\"bei Zahlung bitte angeben\",\"give in case    of payment\")","v":"bei Zahlung bitte angeben"},{"$f":"IF(OR(K3=1,K3=2),\"Kundenummer:\",\"customernumber:\")","v":"Kundenummer:"}]
[null,{"$f":"IF($K$3=1,\"Angebotsnummer\",IF($K$3=2,\"Rechnungsnummer\",IF($K$3=3,\"offernumber\",\"invoicenumber\")))","v":"Rechnungsnummer"},1,null,null,{"$f":"IF(OR(K3=1,K3=2),\"Datum:\",\"date:\")","v":"Datum:"},{"$f":"TODAY()","v":"2020-08-30"},null,"   Artikeldaten"]
[]
[{"$f":"IF(OR(K3=1,K3=2),\"Artikel-Nr.:\",\"articel-No.:\")","v":"Artikel-Nr.:"},{"$f":"IF(OR(K3=1,K3=2),\"Artikel-Bezeichnung\",\"articel\")","v":"Artikel-Bezeichnung"},{"$f":"IF(OR(K3=1,K3=2),\"Größe\",\"size\")","v":"Größe"},{"$f":"IF(OR(K3=1,K3=2),\"Farbe\",\"color\")","v":"Farbe"},{"$f":"IF(OR(K3=1,K3=2),\"Stückpreis\",\"price\")","v":"Stückpreis"},{"$f":"IF(OR(K3=1,K3=2),\"Menge\",\"amount\")","v":"Menge"},{"$f":"IF(OR(K3=1,K3=2),\"Gesamtpreis\",\"total price\")","v":"Gesamtpreis"}]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A20<>0,VLOOKUP(A20,Artikel!$B$3:$G$101,2),\"\"),IF(A20<>0,VLOOKUP(A20,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A20<>0,VLOOKUP(A20,Artikel!$B$3:$G$101,3),\"\"),IF(A20<>0,VLOOKUP(A20,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A20<>0,VLOOKUP(A20,Artikel!$B$3:$G$101,6),\"\")","v":""},null,{"$f":"IF(A20<>0,E20*F20,\"\")","v":""}]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A21<>0,VLOOKUP(A21,Artikel!$B$3:$G$101,2),\"\"),IF(A21<>0,VLOOKUP(A21,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A21<>0,VLOOKUP(A21,Artikel!$B$3:$G$101,3),\"\"),IF(A21<>0,VLOOKUP(A21,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A21<>0,VLOOKUP(A21,Artikel!$B$3:$G$101,6),\"\")","v":""},null,{"$f":"IF(A21<>0,E21*F21,\"\")","v":""}]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A22<>0,VLOOKUP(A22,Artikel!$B$3:$G$101,2),\"\"),IF(A22<>0,VLOOKUP(A22,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A22<>0,VLOOKUP(A22,Artikel!$B$3:$G$101,3),\"\"),IF(A22<>0,VLOOKUP(A22,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A22<>0,VLOOKUP(A22,Artikel!$B$3:$G$101,6),\"\")","v":""},null,""]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A23<>0,VLOOKUP(A23,Artikel!$B$3:$G$101,2),\"\"),IF(A23<>0,VLOOKUP(A23,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A23<>0,VLOOKUP(A23,Artikel!$B$3:$G$101,3),\"\"),IF(A23<>0,VLOOKUP(A23,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A23<>0,VLOOKUP(A23,Artikel!$B$3:$G$101,6),\"\")","v":""},null,""]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A24<>0,VLOOKUP(A24,Artikel!$B$3:$G$101,2),\"\"),IF(A24<>0,VLOOKUP(A24,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A24<>0,VLOOKUP(A24,Artikel!$B$3:$G$101,3),\"\"),IF(A24<>0,VLOOKUP(A24,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A24<>0,VLOOKUP(A24,Artikel!$B$3:$G$101,6),\"\")","v":""},null,"",null," Rechnung/Angebot"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A25<>0,VLOOKUP(A25,Artikel!$B$3:$G$101,2),\"\"),IF(A25<>0,VLOOKUP(A25,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A25<>0,VLOOKUP(A25,Artikel!$B$3:$G$101,3),\"\"),IF(A25<>0,VLOOKUP(A25,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A25<>0,VLOOKUP(A25,Artikel!$B$3:$G$101,6),\"\")","v":""},null,"",null," Neues Angebot/Rechnung"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A26<>0,VLOOKUP(A26,Artikel!$B$3:$G$101,2),\"\"),IF(A26<>0,VLOOKUP(A26,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A26<>0,VLOOKUP(A26,Artikel!$B$3:$G$101,3),\"\"),IF(A26<>0,VLOOKUP(A26,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A26<>0,VLOOKUP(A26,Artikel!$B$3:$G$101,6),\"\")","v":""},null,"",null," mit neuer Nummer"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A27<>0,VLOOKUP(A27,Artikel!$B$3:$G$101,2),\"\"),IF(A27<>0,VLOOKUP(A27,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A27<>0,VLOOKUP(A27,Artikel!$B$3:$G$101,3),\"\"),IF(A27<>0,VLOOKUP(A27,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A27<>0,VLOOKUP(A27,Artikel!$B$3:$G$101,6),\"\")","v":""},null,"",null," (Erhöhung um 1)"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A28<>0,VLOOKUP(A28,Artikel!$B$3:$G$101,2),\"\"),IF(A28<>0,VLOOKUP(A28,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A28<>0,VLOOKUP(A28,Artikel!$B$3:$G$101,3),\"\"),IF(A28<>0,VLOOKUP(A28,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A28<>0,VLOOKUP(A28,Artikel!$B$3:$G$101,6),\"\")","v":""},null,"",null,"Angebot/Rechnung"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A29<>0,VLOOKUP(A29,Artikel!$B$3:$G$101,2),\"\"),IF(A29<>0,VLOOKUP(A29,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A29<>0,VLOOKUP(A29,Artikel!$B$3:$G$101,3),\"\"),IF(A29<>0,VLOOKUP(A29,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A29<>0,VLOOKUP(A29,Artikel!$B$3:$G$101,6),\"\")","v":""},null,"",null,"korrigieren (Storno mit"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A30<>0,VLOOKUP(A30,Artikel!$B$3:$G$101,2),\"\"),IF(A30<>0,VLOOKUP(A30,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A30<>0,VLOOKUP(A30,Artikel!$B$3:$G$101,3),\"\"),IF(A30<>0,VLOOKUP(A30,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A30<>0,VLOOKUP(A30,Artikel!$B$3:$G$101,6),\"\")","v":""},null,"",null,"alter Nummer)"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A31<>0,VLOOKUP(A31,Artikel!$B$3:$G$101,2),\"\"),IF(A31<>0,VLOOKUP(A31,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A31<>0,VLOOKUP(A31,Artikel!$B$3:$G$101,3),\"\"),IF(A31<>0,VLOOKUP(A31,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A31<>0,VLOOKUP(A31,Artikel!$B$3:$G$101,6),\"\")","v":""},null,"",null," Angebot/Rechnung"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A32<>0,VLOOKUP(A32,Artikel!$B$3:$G$101,2),\"\"),IF(A32<>0,VLOOKUP(A32,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A32<>0,VLOOKUP(A32,Artikel!$B$3:$G$101,3),\"\"),IF(A32<>0,VLOOKUP(A32,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A32<>0,VLOOKUP(A32,Artikel!$B$3:$G$101,6),\"\")","v":""},null,{"$f":"IF(A32<>0,E32*F32,\"\")","v":""},null," drucken"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A33<>0,VLOOKUP(A33,Artikel!$B$3:$G$101,2),\"\"),IF(A33<>0,VLOOKUP(A33,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A33<>0,VLOOKUP(A33,Artikel!$B$3:$G$101,3),\"\"),IF(A33<>0,VLOOKUP(A33,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A33<>0,VLOOKUP(A33,Artikel!$B$3:$G$101,6),\"\")","v":""},null,"",null," (nach Druckereinstellung)"]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A34<>0,VLOOKUP(A34,Artikel!$B$3:$G$101,2),\"\"),IF(A34<>0,VLOOKUP(A34,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A34<>0,VLOOKUP(A34,Artikel!$B$3:$G$101,3),\"\"),IF(A34<>0,VLOOKUP(A34,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A34<>0,VLOOKUP(A34,Artikel!$B$3:$G$101,6),\"\")","v":""},null,""]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A35<>0,VLOOKUP(A35,Artikel!$B$3:$G$101,2),\"\"),IF(A35<>0,VLOOKUP(A35,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A35<>0,VLOOKUP(A35,Artikel!$B$3:$G$101,3),\"\"),IF(A35<>0,VLOOKUP(A35,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A35<>0,VLOOKUP(A35,Artikel!$B$3:$G$101,6),\"\")","v":""},null,""]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A36<>0,VLOOKUP(A36,Artikel!$B$3:$G$101,2),\"\"),IF(A36<>0,VLOOKUP(A36,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A36<>0,VLOOKUP(A36,Artikel!$B$3:$G$101,3),\"\"),IF(A36<>0,VLOOKUP(A36,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A36<>0,VLOOKUP(A36,Artikel!$B$3:$G$101,6),\"\")","v":""},null,""]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A37<>0,VLOOKUP(A37,Artikel!$B$3:$G$101,2),\"\"),IF(A37<>0,VLOOKUP(A37,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A37<>0,VLOOKUP(A37,Artikel!$B$3:$G$101,3),\"\"),IF(A37<>0,VLOOKUP(A37,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A37<>0,VLOOKUP(A37,Artikel!$B$3:$G$101,6),\"\")","v":""},null,""]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A38<>0,VLOOKUP(A38,Artikel!$B$3:$G$101,2),\"\"),IF(A38<>0,VLOOKUP(A38,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A38<>0,VLOOKUP(A38,Artikel!$B$3:$G$101,3),\"\"),IF(A38<>0,VLOOKUP(A38,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A38<>0,VLOOKUP(A38,Artikel!$B$3:$G$101,6),\"\")","v":""},null,""]
[null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A39<>0,VLOOKUP(A39,Artikel!$B$3:$G$101,2),\"\"),IF(A39<>0,VLOOKUP(A39,Artikel!$B$3:$G$101,4),\"\"))","v":""},null,{"$f":"IF(OR($K$3=1,$K$3=2),IF(A39<>0,VLOOKUP(A39,Artikel!$B$3:$G$101,3),\"\"),IF(A39<>0,VLOOKUP(A39,Artikel!$B$3:$G$101,5),\"\"))","v":""},{"$f":"IF(A39<>0,VLOOKUP(A39,Artikel!$B$3:$G$101,6),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IF(OR(K3=1,K3=2),\"Rechnungsbetrag, netto\",\"total account, net\")","v":"Rechnungsbetrag, netto"},null,{"$f":"SUM(G20:G39)","v":0}]
[null,null,null,null,{"$f":"IF(OR(K3=1,K3=2),\"Rabatt\",\"discount\")","v":"Rabatt"},{"$f":"VLOOKUP(G40,Rabatt!$B$3:$C$10,2)","v":0},{"$f":"G40*F41","v":0}]
[null,null,null,null,null,null,{"$f":"G40-G41","v":0}]
[null,null,null,null,{"$f":"IF(OR(K3=1,K3=2),\"Versand und Verpackung\",\"dispatch and packing\")","v":"Versand und Verpackung"},null,{"$f":"IF(G42>0,VLOOKUP(G40,Rabatt!B3:D10,3),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(G42>0,G42+G43,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(OR(K3=1,K3=2),\"Umsatzsteuer\",\"sales tax\")","v":"Umsatzsteuer"},0.19,{"$f":"IF(G42>0,G44*F45,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(OR(K3=1,K3=2),\"Rechnungsbetrag, brutto\",\"total account, gross\")","v":"Rechnungsbetrag, brutto"},null,{"$f":"IF(G42>0,G44+G45,\"\")","v":""}]
[]
[]
[{"$f":"IF(OR(K3=1,K3=2),\"Zahlungsbedingungen: 2% Skonto bei Zahlung bis zum\",\"terms of payment: 2% cash discount in case of payment until\")&TEXT(TODAY()+7,\" TT.MM.JJJJ\")","v":"Zahlungsbedingungen: 2% Skonto bei Zahlung bis zum 06.09.2020"}]
[null,{"$f":"IF(OR(K3=1,K3=2),\"                    oder Zahlung netto Kasse bis zum\",\"             otherwise payment net cash until\")&TEXT(TODAY()+30,\" TT.MM.JJJJ\")","v":"                    oder Zahlung netto Kasse bis zum 29.09.2020"}]
[{"$f":"IF(OR(K3=1,K3=2),\"Bankverbindung: Kto-Nr.: 123 456 bei der Sparkasse Rhein-Nahe, BLZ 560 501 80\",\"account-No.: 123 456, bank: Sparkasse Rhein-Nahe, bank-No.: 560 501 80\")","v":"Bankverbindung: Kto-Nr.: 123 456 bei der Sparkasse Rhein-Nahe, BLZ 560 501 80"}]
[{"$f":"IF(OR(K3=1,K3=2),\"Die Ware bleibt bis zur vollständigen Bezahlung Eigentum der Tropic GmbH, Bad Kreuznach\",\"owner of delivered goods until complete payment: Tropic GmbH, Bad Kreuznach\")","v":"Die Ware bleibt bis zur vollständigen Bezahlung Eigentum der Tropic GmbH, Bad Kreuznach"}]

{"sheet":"Artikel","index":2,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nr.","Bezeichnung","Farbe","article","Colour","€"]
[null,100010,"Tropic Jeans 001","blau","Tropic Jeans 001","blue",70]
[null,100011,"Tropic Jeans 001","schwarz","Tropic Jeans 001","black",70]
[null,100012,"Tropic Jeans 001","grau","Tropic Jeans 001","grey",70]
[null,100020,"Tropic Jeans 002","blau","Tropic Jeans 002","blue",80]
[null,100021,"Tropic Jeans 002","schwarz","Tropic Jeans 002","black",80]
[null,100022,"Tropic Jeans 002","grau","Tropic Jeans 002","grey",80]
[null,100030,"Tropic Jeansjacke","blau","Tropic Jeansjacket","blue",90]
[null,200010,"Tropic T-Shirt","blau","Tropic T-Shirt","blue",25]
[null,200011,"Tropic T-Shirt","schwarz","Tropic T-Shirt","black",25]
[null,200012,"Tropic T-Shirt","rot","Tropic T-Shirt","red",25]
[null,200013,"Tropic T-Shirt","grau","Tropic T-Shirt","grey",25]
[null,200014,"Tropic T-Shirt","grau","Tropic T-Shirt","grey",25]
[null,200015,"Tropic T-Shirt","weiß","Tropic T-Shirt","white",25]
[null,200016,"Tropic T-Shirt","grün","Tropic T-Shirt","green",25]
[null,200017,"Tropic T-Shirt","pastellblau","Tropic T-Shirt","pastel blue",25]
[null,200018,"Tropic T-Shirt","pink","Tropic T-Shirt","pink",25]
[null,200019,"Tropic T-Shirt","meergrün","Tropic T-Shirt","ocean green",25]
[null,200020,"Tropic Polohemd","blau","Tropic polo shirt","blue",40]
[null,200021,"Tropic Polohemd","schwarz","Tropic polo shirt","black",40]
[null,200022,"Tropic Polohemd","rot","Tropic polo shirt","red",40]
[null,200023,"Tropic Polohemd","grau","Tropic polo shirt","grey",40]
[null,200024,"Tropic Polohemd","grau","Tropic polo shirt","grey",40]
[null,200025,"Tropic Polohemd","weiß","Tropic polo shirt","white",40]
[null,200026,"Tropic Polohemd","grün","Tropic polo shirt","green",40]
[null,200027,"Tropic Polohemd","pastellblau","Tropic polo shirt","pastel blue",40]
[null,200028,"Tropic Polohemd","pink","Tropic polo shirt","pink",40]
[null,200029,"Tropic Polohemd","meergrün","Tropic polo shirt","ocean green",40]
[null,200030,"Tropic Sweatshirt","blau","Tropic Sweatshirt","blue",60]
[null,200031,"Tropic Sweatshirt","schwarz","Tropic Sweatshirt","black",60]
[null,200032,"Tropic Sweatshirt","rot","Tropic Sweatshirt","red",60]
[null,200033,"Tropic Sweatshirt","grau","Tropic Sweatshirt","grey",60]
[null,200034,"Tropic Sweatshirt","grau","Tropic Sweatshirt","grey",60]
[null,200035,"Tropic Sweatshirt","weiß","Tropic Sweatshirt","white",60]
[null,200040,"Tropic Rippenshirt","blau","Tropic rip shirt","blue",40]
[null,200041,"Tropic Rippenshirt","schwarz","Tropic rip shirt","black",40]
[null,200042,"Tropic Rippenshirt","rot","Tropic rip shirt","red",40]
[null,200043,"Tropic Rippenshirt","blau","Tropic rip shirt","blue",40]
[null,200044,"Tropic Rippenshirt","grau","Tropic rip shirt","grey",40]
[null,200045,"Tropic Rippenshirt","weiß","Tropic rip shirt","white",40]
[null,300010,"Tropic Trainingsanzug","blau/rot/meergrün","Tropic training overall","blue/red/ocean green",110]
[null,300011,"Tropic Trainingsanzug","schwarz/orange/rot","Tropic training overall","black/orange/red",110]
[null,400010,"Tropic Badeanzug","gelb/orange","Tropic bathing-dress","yellow/orange",65]
[null,400011,"Tropic Badeanzug","grün/orange","Tropic bathing-dress","green/orange",65]
[null,400020,"Tropic Bikini","gelb/orange","Tropic Bikini","yellow/orange",55]
[null,400021,"Tropic Bikini","grün/orange","Tropic Bikini","green/orange",55]
[null,400030,"Tropic Badehose","blau","Tropic bathing-drawer","blue",30]
[null,500010,"Tropic Partykleid","gelb/orange","Tropic party-dress","yellow/orange",80]
[null,500011,"Tropic Partykleid","grün/orange","Tropic party-dress","green/orange",80]
[null,500020,"Tropic Rippkleid","schwarz","Tropic rip-dress","black",70]
[null,500021,"Tropic Rippkleid","rot","Tropic rip-dress","red",70]
[null,500022,"Tropic Rippkleid","weiß","Tropic rip-dress","white",70]
[null,500023,"Tropic Rippkleid","pastellblau","Tropic rip-dress","pastel blue",70]
[null,500024,"Tropic Rippkleid","meergrün","Tropic rip-dress","ocean green",70]

{"sheet":"Kunden","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Nr.","Firma","Straße","Ort","Tel-Nr.:","Fax-Nr.:"]
[null,125,"Boutique Simone Sommer","Mannheimer Str. 128","55543 Bad Kreuznach","0671/1234","0671/1235"]
[null,126,"Paolo Russo - Jeans","C.P. 202020","I-20110 Milano","0039-2879949","0039-2879950"]
[null,127,"Schickeria Moden","Friedrich-Eber-Str. 1","65335 Gustavsburg","06134/2045","16134/2046"]
[null,128,"Marinas Collection GmbH","Zeil 123","60123 Frankurt/Main","069/123456","069/123457"]
[null,129,"Route 66 GmbH","Goethestr. 44","68345 Mannheim","0621/9876","0621/9875"]
[null,130,"Black and Blue Jeans GmbH","Ludwigstr. 13","55264 Mainz","06131/61810","06131/6182"]
[null,131,"Kick Moden GmbH","Langgasse 7a","65123 Wiesbaden","0611/98765","0611/98766"]
[null,132,"Jeans and Shirts","Olympiaweg 25","A-6020 Insbruck","0043-512-489","0043-512-490"]
[null,133,"Cassidy Ltd.","Bourbon Street 66a","GB-30001 London East"]

{"sheet":"Rabatt","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nettobetrag","Rabatt","Versand/Verpackung"]
[null,0,0,50]
[null,1000,0.05,75]
[null,{"$f":"B4+1000","v":2000},0.1,100]
[null,{"$f":"B5+1000","v":3000},0.15,125]
[null,{"$f":"B6+1000","v":4000},0.2,150]
[null,{"$f":"B7+1000","v":5000},0.25,0]
[null,10000,0.3,0]
[null,20000,0.35,0]