{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Angebotsformular","Adressdatenbank","Tabelle1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":57,"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":"Angebotsformular","index":0,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[42,7,42,9],[1,9,5,10],[47,3,47,6],[47,7,47,9],[19,6,20,6],[8,6,10,10],[19,4,20,5],[19,3,20,3],[24,1,24,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[32,1,32,6],[34,7,34,8],[34,9,34,10],[31,1,31,6],[25,1,25,6],[42,3,42,6],[26,1,26,6],[27,1,27,6],[19,9,20,10],[41,3,41,6],[41,7,41,9],[40,3,40,6],[40,7,40,9],[33,7,33,8],[35,9,35,10],[35,7,35,8],[33,9,33,10],[35,1,35,5],[33,1,33,5],[34,1,34,5],[43,3,43,6],[43,7,43,9],[46,3,46,6],[46,7,46,9],[45,3,45,6],[45,7,45,9],[44,3,44,6],[44,7,44,9]]}
[]
[null,"Name Firma",null,null,null,null,null,null,null,"LOGO",null,null,null,null,null,null,null,"Merktafel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Adresse der Firma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,"Steuernr. / c.f.  ",null,null,null,null,{"$f":"IF(ISERROR(IF(VLOOKUP(G9,Adressdatenbank!B2:J52,2,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,2,FALSE)))=TRUE,\"\",IF(VLOOKUP(G9,Adressdatenbank!B2:J52,2,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,2,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,10]
[null,"Mwst. Nr./ partita IVA ",null,null,null,null,{"$f":"IF(ISERROR(IF(VLOOKUP(G9,Adressdatenbank!B2:J52,3,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,3,FALSE)))=TRUE,\"\",IF(VLOOKUP(G9,Adressdatenbank!B2:J52,3,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,3,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(VLOOKUP(G9,Adressdatenbank!B2:J52,4,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,4,FALSE)))=TRUE,\"\",IF(VLOOKUP(G9,Adressdatenbank!B2:J52,4,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,4,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,12]
[]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(J16=\"\",\"\",\"Steuernummer / codice fiscale\"))=TRUE,\"\",IF(J16=\"\",\"\",\"Steuernummer / codice fiscale\"))","v":""},null,null,{"$f":"IF(ISERROR(IF(VLOOKUP(G9,Adressdatenbank!B2:J52,5,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,5,FALSE)))=TRUE,\"\",IF(VLOOKUP(G9,Adressdatenbank!B2:J52,5,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,5,FALSE)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(J17=\"\",\"\",\"Mwst-Nr. / partita IVA\"))=TRUE,\"\",IF(J17=\"\",\"\",\"Mwst-Nr. / partita IVA\"))","v":""},null,null,{"$f":"IF(ISERROR(IF(VLOOKUP(G9,Adressdatenbank!B2:J52,6,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,6,FALSE)))=TRUE,\"\",IF(VLOOKUP(G9,Adressdatenbank!B2:J52,6,FALSE)=0,\"\",VLOOKUP(G9,Adressdatenbank!B2:J52,6,FALSE)))","v":""}]
[]
[]
[null,"Angebotsnummer",null,{"$f":"IF(INDEX(B:B,43)=\"\",1,LEFT(INDEX(B:B,43),FIND(\"/\",INDEX(B:B,43),1)-1)+1)","v":1},{"$f":"CONCATENATE(\"/\",YEAR(J20),\"/\")","v":"/2020/"},null,"A",null,"Datum",{"$f":"TODAY()","v":"2020-04-11"}]
[null,"Numero offerta",null,null,null,null,null,null,"data"]
[]
[null,"Beschreibung",null,null,null,null,null,"Betrag","Menge","Rabatt","Betrag"]
[null,"Descrizione",null,null,null,null,null,"importo","quantità","Sconto","importo"]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"+I25*H25","v":0},{"$f":"+L25*J25","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"+I26*H26","v":0},{"$f":"+L26*J26","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,0,0]
[4,null,null,null,null,null,null,null,null,null,null,0,0]
[5,null,null,null,null,null,null,null,null,null,null,0,0]
[6,null,null,null,null,null,null,null,null,null,null,0,0]
[10,null,null,null,null,null,null,null,null,null,null,0,0]
[11,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[null,"· Mwst. nicht enthalten / IVA esente\n· Stempelsteuer 2,00 € nicht enthalten / imposta bollo di 2,00 € esente",null,null,null,null,null,"Summe\nsomma",null,{"$f":"IF(SUM(L25:L32)=0,\"\",SUM(L25:L32))","v":""}]
[null,null,null,null,null,null,null,"Rabatt\nSconto",null,{"$f":"IF(SUM(M25:M32)=0,\"\",SUM(M25:M32))","v":""}]
[null,"· gültig bis 30 Tage nach Angebotsdatum / valido fino a 30 gg dopo data dell'offerta",null,null,null,null,null,"Insgesamt\nTotale",null,{"$f":"IF(J34=\"\",\"\",J34-J35)","v":""}]
[]
[]
[null,"Bestätigung/conferma"]
[null,"Datum/data:",null,null,null,null,null,null,"Unterschrift Auftraggeber/firma del cliente:"]
[null,{"$f":"CONCATENATE(D20,E20,G20)","v":"1/2020/A"},{"$f":"J20","v":"2020-04-11"},{"$f":"CONCATENATE(LEFT(G9,30),\"  \",MID(G13,7,50),)","v":"  "},null,null,null,{"$f":"CONCATENATE(B25,\" \",B26,\" \",B27,\" \",B28,\" \",B29,\" \",B30,\" \",B31,\" \",B32,)","v":"       "},null,null,{"$f":"J36","v":""}]
[null,"Ang.nr.","Rech.Datum","Empfänger",null,null,null,"Beschreibung",null,null,"Betrag"]

{"sheet":"Adressdatenbank","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Nr.","Name","Adresse","Ort","Land","Steuernummer","Mehwerts-steuernummer","Telefon","Email","PEC"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]

{"sheet":"Tabelle1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}