{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Rechnung","Preisliste"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Rechnung","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
["Kaufvertrag /",null,null,"Elektroblitz GmbH"]
["Rechnung",null,null,"Elektrische Anlagen und Einzelhandel"]
[null,null,null,"Buchfinkweg 28, 12359 Berlin, Tel.: 601 12 39"]
[]
[null,"Datum","Verkäufer"]
[null,{"$f":"TODAY()","v":"2019-10-09"}]
[]
[null,"Herrn / Frau / Firma             Rechnungs- und Lieferanschrift"]
[null,null,null,null,null,"Vielen"]
[null,"Straße"]
[null,null,null,null,null,"Dank für"]
[null,"Postleitzahl / Ort"]
[null,null,null,null,null,"Ihren"]
[null,"Telefonnr."]
[null,null,null,null,null,"Einkauf !"]
[]
[null,"Artikelnr.","Menge","Artikel - Bezeichnung","Rab.","Preis"]
[null,null,null,{"$f":"VLOOKUP(B19,Preisliste,2,FALSE)","v":" "},null,{"$f":"VLOOKUP(B19,Preisliste,3,FALSE)*C19*(1-E19)","v":0}]
[null,null,null,{"$f":"VLOOKUP(B20,Preisliste,2,FALSE)","v":" "},null,{"$f":"VLOOKUP(B20,Preisliste,3,FALSE)*C20*(1-E20)","v":0}]
[null,null,null," ",null,{"$f":"VLOOKUP(B21,Preisliste,3,FALSE)*C21*(1-E21)","v":0}]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null," ",null,0]
[null,null,null,{"$f":"VLOOKUP(B36,Preisliste,2,FALSE)","v":" "},null,0]
[]
[null,"Liefertermin: ca.",null,"Gesamtbetrag:",null,{"$f":"SUM(F19:F36)","v":0}]
[null,null,null,"Mehrwertsteuer:",0.19,{"$f":"E39*F38","v":0}]
[null,null,null,"Gesamtpreis inkl. Mehrwertsteuer:",null,{"$f":"SUM(F38:F39)","v":0}]
[]
[]
[]
[]
[null,"Unterschrift Käufer",null,null,"Unterschrift Verkaufsberater"]
[]
[null,"Bankverbindung: Postbank Berlin, BLZ 10010010, Konto- Nr. 68 26 - 109"]

{"sheet":"Preisliste","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Artikelnr.","Bezeichnung","Preis (ohne MWST)"]
[0," ",0]
[10200,"LED-Lampe, 13 W",1.98]
[10201,"LED-Lampe, 11 W",1.75]
[10202,"Batterie, 9V Block",8.75]
[10203,"Batterie, 1,5V Mignon",1.8]
[10204,"Verlängerungskabel, 2m",3.1]
[10205,"Verlängerungskabel, 5m",4.9000000000000004]