{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Verkaufsbeleg"],"read":"whole","date_system":"1900"}

{"sheet":"Verkaufsbeleg","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[0,1,1,3],[0,5,1,6],[8,1,8,2],[9,1,9,2],[25,1,25,3],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[33,1,33,3]]}
[null,"MODERN DESIGN CO.",{"$nulls":3},"VERKAUFSBELEG"]
[]
[null,"ELEGANTE LÖSUNGEN FÜR DEN MODERNEN KÜNSTLER"]
[null,"RECHNUNGSEMPFÄNGER",null,"RECHNUNGSNR.","DATUM"]
[null,"Saara Teinemaa",null,"XYZ123","01/01/XX"]
[null,"FIRMA",null,"ADRESSE","TELEFON"]
[null,"Create & Co.",null,"321 Sycamore","(0415) 555-0123"]
[{"$nulls":3},"Albany, NY 12345","(0415) 555-0124"]
[null,"ZAHLUNGSMETHODE",null,"RECHNUNGSNR.","AUFTRAG"]
[null,"Überweisung",null,987654,"Design-Studio-Shooting"]
[]
[null,"MENGE","ARTIKELNR.","BESCHREIBUNG","EINZELPREIS","RABATT","ZEILENSUMME"]
[null,3,"K.A.","Fotoshooting (in Stunden)",{"v":100,"d":"100.00 €"},{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":{"v":270,"d":"270.00 €"}}]
[null,1,100,"USB-Stick mit Fotos",{"v":45,"d":"45.00 €"},null,{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":{"v":45,"d":"45.00 €"}}]
[null,2.5,"K.A.","Bearbeitungen (in Stunden)",{"v":35,"d":"35.00 €"},null,{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":{"v":87.5,"d":"87.50 €"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[MENGE]]=\"\",Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[MENGE]]*(1-Table_SalesReceiptDetails[[#This Row],[RABATT]])*Table_SalesReceiptDetails[[#This Row],[EINZELPREIS]]),\"\")","v":""}]
[]
[null,"WENN SIE FRAGEN ZU DIESER RECHNUNG HABEN, VERWENDEN SIE BITTE DIE FOLGENDEN KONTAKTINFORMATIONEN:",null,null,"GESAMTRABATT"]
[null,"Nathan Rigby | (0123) 456-7890 | nathan@example.com",null,null,"ZWISCHENSUMME",null,{"$f":"SUM(Table_SalesReceiptDetails[ZEILENSUMME])","v":{"v":402.5,"d":"402.50 €"}}]
[{"$nulls":4},"MEHRWERTSTEUER",null,{"v":0.06,"d":"6.00%"}]
[null,"VIELEN DANK FÜR IHREN AUFTRAG!",null,null,"ERGEBNIS",null,{"$f":"(G27-(G27*G26))*(1+G28)","v":{"v":426.65000000000003,"d":"426.65 €"}}]