{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Rechnung","Einstellungen"],"not_rendered":{"images":1,"defined_names":40},"read":"whole","date_system":"1900"}

{"sheet":"Rechnung","index":0,"n_rows":50,"n_cols":13,"rows_kept":50,"merged":[[6,1,6,3],[6,6,6,8],[7,1,7,3],[7,6,7,8],[11,1,11,3],[11,5,11,6],[14,1,14,3],[14,5,14,6],[14,8,14,12],[23,3,23,8],[24,3,24,8],[25,3,25,8],[26,3,26,8],[27,3,27,8],[28,3,28,8],[29,3,29,8],[30,3,30,8],[31,3,31,8],[32,3,32,8],[33,3,33,8],[34,3,34,8],[35,3,35,8],[48,1,48,12],[49,1,49,12]]}
[]
[]
[null,"VERKÄUFER",{"$nulls":4},"KÄUFER"]
[null,"Contoso, Ltd.",{"$nulls":4},"Fachbereich Grafikdesign"]
[null,"Bahnstraße 567",{"$nulls":4},"Hauptstraße 2345"]
[null,"23456 Chemnitz",{"$nulls":4},"12345 Gütersloh"]
[null,8885550104,{"$nulls":4},5095550192]
[null,8885550105,{"$nulls":4},5095550193]
[]
[]
[null,"VERTRIEBSMITARBEITER",{"$nulls":3},"BESTELLNUMMER",null,null,"DATUM",null,"PAKETE",null,"GELIEFERT"]
[null,"Elisabeth Krenthaller",{"$nulls":3},123,null,null,"2012-01-01",null,1,null,"USPS"]
[]
[null,"BEDINGUNGEN",{"$nulls":3},"FOB/INCOTERM",null,null,"BESCHREIBUNG"]
[null,"Keine",{"$nulls":3},"Frachtfrei",null,null,{"$f":"IFERROR(INDEX(tblFOBBedingungen[],MATCH(F15,tblFOBBedingungen[FOB/INCOTERM],0),2),\"\")","v":"Bestimmungsort"}]
{"$rows_empty":7}
[null,"MENGE",null,"BESCHREIBUNG",{"$nulls":6},"EINZELPREIS",null,"BETRAG"]
[null,1,null,"Ries Papier",{"$nulls":6},{"v":15,"d":"15.00 €"},null,{"$f":"IF(AND(K24<>\"\",B24<>\"\"),B24*K24,\"\")","v":{"v":15,"d":"15.00 €"}}]
[null,5,null,"Schreibtisch, Bodenmontage",{"$nulls":6},{"v":275,"d":"275.00 €"},null,{"v":1375,"d":"1,375.00 €"}]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":10},"Zwischensumme",null,{"$f":"SUM(M24:M36)","v":{"v":1390,"d":"1,390.00 €"}}]
[{"$nulls":10},"Steuersatz",null,{"v":0.075,"d":"8%"}]
[{"$nulls":10},"Steuern",null,{"$f":"Steuersatz*Zwischensumme","v":{"v":104.25,"d":"104.25 €"}}]
[{"$nulls":10},"Sonstige",null,{"v":0,"d":"0.00 €"}]
[{"$nulls":10},"Gesamtsumme",null,{"$f":"SUM(Sonstige,SteuernGesamt,Zwischensumme)","v":{"v":1494.25,"d":"1,494.25 €"}}]
[]
[]
[]
[]
[]
[]
[null,"LIEFER- UND ZAHLUNGSBEDINGUNGEN"]
[null,"Hier bestimmte Liefer- und Zahlungsbedingungen auflisten"]
[null,"Diese Zeile kann ebenfalls verwendet werden."]

{"sheet":"Einstellungen","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"merged":[[1,0,1,6]]}
[]
["Bedingungen entsprechend den International Commerce Terms (\"Incoterms\"), aktualisiert am 1. Januar 2011, achte Ausgabe, Incoterms 2010."]
[]
[]
["FOB/INCOTERM","BEDEUTUNG",null,"SPEDITEUR",null,"REGELN FÜR DIE BEDINGTE FORMATIERUNG","EIN/AUS"]
["DAT","Geliefert Terminal (1)",null,"USPS",null,"Firmenname (Käufer) nicht leer","EIN"]
["DAP","Geliefert am benannten Lieferort (1)",null,"FedEx",null,"Firmenanschrift (Käufer) nicht leer","EIN"]
["DDP","Geliefert verzollt (1)",null,"UPS",null,"Firmensitz und PLZ (Käufer) nicht leer","EIN"]
["EXW","Ab Werk (1)",null,"Sonstige",null,"Telefonnummer (Käufer) nicht leer","EIN"]
["Versandstelle","Versandstelle",{"$nulls":3},"Faxnummer (Käufer) nicht leer","AUS"]
["Unfrei","Bestimmungsort",{"$nulls":3},"Firmenname (Verkäufer) nicht leer","EIN"]
["Frachtfrei","Bestimmungsort",{"$nulls":3},"Firmenanschrift (Verkäufer) nicht leer","EIN"]
[{"$nulls":5},"Firmensitz und PLZ (Verkäufer) nicht leer","EIN"]
[{"$nulls":5},"Telefonnummer (Verkäufer) nicht leer","EIN"]
[{"$nulls":5},"Faxnummer (Verkäufer) nicht leer","AUS"]
[{"$nulls":5},"Bestellnummer nicht leer","EIN"]
[{"$nulls":5},"Vertriebsmitarbeiter nicht leer","EIN"]
[{"$nulls":5},"Geliefert nicht leer","AUS"]
[{"$nulls":5},"Bedingungen nicht leer","AUS"]
[{"$nulls":5},"FOB/Incoterm nicht leer","AUS"]
[{"$nulls":5},"Anzahl Pakete nicht leer","EIN"]