{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Rechnungsaufstellung","Firmensetup"],"not_rendered":{"images":1,"defined_names":27},"read":"whole","date_system":"1900"}

{"sheet":"Rechnungsaufstellung","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"merged":[[1,1,1,2],[1,3,2,4],[1,6,2,6],[3,3,3,4],[4,3,4,4],[5,3,5,4],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[34,1,34,4]]}
[null,"RECHNUNG","0005"]
[null,{"$f":"TODAY()","v":"2018-07-13"},null,{"$f":"RechnungsSumme","v":79.65},null," ","Firmensetup"]
[null,"ZAHLUNG FÄLLIG AM:",{"$f":"TODAY()+15","v":"2018-07-28"},null,null," "]
[null,"HELGA SCHUSTEREIT",null,"ADVENTURE WORKS"]
[null,"Fabrikam, Inc.",null,"Ahornstraße 245"]
[null,"Hauptstr. 123",null,"50765 Köln"]
[null,"40597 Düsseldorf"]
[null,"MENGE","DETAILS","EINZELPREIS","ZEILENSUMME"]
[null,2,"Widgets",14.95,{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":{"v":29.9,"d":"29.90"}}]
[null,5,"Unterlegscheiben",9.95,{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":49.75}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(Rechnungsdetails[[#This Row],[EINZELPREIS]]*Rechnungsdetails[[#This Row],[MENGE]],\"\")","v":0}]
[null,"Rabatt"]
[null,"Nettosumme",null,null,{"$f":"SUM(Rechnungsdetails[ZEILENSUMME])-E24","v":{"v":79.65,"d":"79.65 €"}}]
[null,"Steuern"]
[null,{"$f":"\"GESAMT \" & REPT(FirmenSetup_IhrWährungsKürzel,LEN(FirmenSetup_IhrWährungsKürzel)>0)","v":"GESAMT EUR"},null,null,{"$f":"IFERROR(E25+E26, \"\")","v":{"v":79.65,"d":"79.65 €"}}]
[null,"ZAHLUNGSDETAILS",null,null,"WEITERE INFORMATIONEN"]
[null,"Name des Begünstigten:",{"$f":" FirmenSetup_BankBegünstigtenName","v":"Adventure Works"},null,{"$f":"IFERROR(FirmenSetup_IhrName,\"\")","v":""}]
[null,"Name der Bank:",{"$f":"FirmenSetup_BankName","v":"Bankhaus Halbzettel"},null,{"$f":"IFERROR(\"Telefon: \" & FirmenSetup_IhrTelefon,\"\")","v":"Telefon: 0221-55 50 15 0"}]
[null,"Adresse der Bank:",{"$f":"FirmenSetup_BankAdresse","v":"Hauptstr. 134, 50996 Köln"},null,{"$f":"IFERROR(\"Fax: \" & FirmenSetup_IhrFax,\"\")","v":"Fax: 0221-55 50 15 1"}]
[null,"Kontonummer:",{"$f":"FirmenSetup_BankKonto","v":1234567},null,{"$f":"IFERROR(FirmenSetup_IhreURL,\"\")","v":"Adventure-Works.com"}]
[null,"Bankleitzahl (SWIFT-Code):",{"$f":"FirmenSetup_BLZ","v":9876543210},null,{"$f":"IFERROR(FirmenSetup_IhreEMail,\"\")","v":"Buchhaltung@Adventure-Works.com"}]
[null,"Zahlungsreferenz:",{"$f":"RechnungsNummernAnzeige","v":"0005"},null,{"$f":"IFERROR(IF(LEN(Client_PO),\"Contract/PO: \" & Client_PO,\"\"),\"\")","v":""}]
[null,{"$f":"UPPER(\"Zahlung bitte per Bankanweisung oder Scheck zahlbar an \" & FIrmenSetup_ScheckZahlungsempfänger& \".\")","v":"ZAHLUNG BITTE PER BANKANWEISUNG ODER SCHECK ZAHLBAR AN ADVENTURE WORKS."}]

{"sheet":"Firmensetup","index":1,"n_rows":20,"n_cols":5,"rows_kept":20}
[null,"FIRMENSETUP"]
[null,"DETAILS DER RECHNUNGSTELLENDEN FIRMA","WERT",null,"Rechnungsaufstellung"]
[null,"Name","Gebhard Peters"]
[null,"Firmenname","ADVENTURE WORKS"]
[null,"Adresszeile 1","Ahornstraße 245"]
[null,"Adresszeile 2","50765 Köln"]
[null,"Adresszeile 3"]
[null,"Adresszeile 4"]
[null,"Adresszeile 5"]
[null,"Telefon","0221-55 50 15 0"]
[null,"Fax","0221-55 50 15 1"]
[null,"Website","Adventure-Works.com"]
[null,"E-Mail","Buchhaltung@Adventure-Works.com"]
[null,"Währungskürzel","EUR"]
[null,"Name des Begünstigten für Bankanweisung","Adventure Works"]
[null,"Name der Bank","Bankhaus Halbzettel"]
[null,"Adresse der Bank","Hauptstr. 134, 50996 Köln"]
[null,"Kontonummer",1234567]
[null,"Bankleitzahl (SWIFT-Code)",9876543210]
[null,"Schecks auszahlbar an","Adventure Works"]