{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Rechnungsformular","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":"Rechnungsformular","index":0,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,9,5,10],[43,3,43,6],[43,7,43,9],[8,6,10,10],[38,0,38,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],[42,7,42,9],[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],[39,0,39,10],[33,7,33,8],[35,1,35,5],[33,1,34,5],[35,9,35,10],[35,7,35,8],[33,9,33,10]]}
[null,null,null,null,null,null,null,null,null,"Logo"]
[null,"Firmenname"]
[]
[]
[null,"Adresse"]
[]
[]
[]
[]
[]
[]
[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,"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,{"$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,{"$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,"Rechnungsnummer",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,"Rechnungsdatum",null,null,{"$f":"TODAY()","v":"2020-04-11"}]
[null,"numero fattura",null,null,null,null,"data fattura"]
[]
[null,"Beschreibung",null,"Proj. Nr. :",null,null,null,"Preis","Anzahl","Betrag","Mwst."]
[null,"Descrizione",null,null,null,null,null,"prezzo","quantità","importo","IVA"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(H:H,25)=\"\",\"\",INDEX(I:I,25)*INDEX(H:H,25))","v":""},null,{"$f":"IF(K25=0,0,J25*K25)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(H:H,26)=\"\",\"\",INDEX(I:I,26)*INDEX(H:H,26))","v":""},null,{"$f":"IF(K26=0,0,J26*K26)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(H:H,27)=\"\",\"\",INDEX(I:I,27)*INDEX(H:H,27))","v":""},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(H:H,28)=\"\",\"\",INDEX(I:I,28)*INDEX(H:H,28))","v":""},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(H:H,29)=\"\",\"\",INDEX(I:I,29)*INDEX(H:H,29))","v":""},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(H:H,30)=\"\",\"\",INDEX(I:I,30)*INDEX(H:H,30))","v":""},null,{"$f":"IF(K30=0,0,J30*K30)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(H:H,31)=\"\",\"\",INDEX(I:I,31)*INDEX(H:H,31))","v":""},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(H:H,32)=\"\",\"\",INDEX(I:I,32)*INDEX(H:H,32))","v":""},null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Bestimmungen für Steuerabrechung/Stempelsteuer….",null,null,null,null,null,"Steuergrundlage\nImponibile",null,{"$f":"SUM(J25:J32)","v":0}]
[null,null,null,null,null,null,null,"Mehrwertssteuer\nImporto IVA",null,{"$f":"SUM(L25:L32)","v":0}]
[null,"Zahlungsziel: 30 Tage nach Erhalt\nTermine di pagamento: 30 gg dopo ricevimento",null,null,null,null,null,"Rechnungsbetrag\nImporto fattura",null,{"$f":"IF(J34=\"\",\"\",J34+J35)","v":0}]
[]
[]
["Südtiroler Volksbank Welsberg - IBAN: IT 33 A0585658600011570022647"]
["Banca Popolare Monguelfo - BIC/SWIFT: BPAAIT2B011"]
[null,{"$f":"CONCATENATE(D20,E20)","v":"1/2020"},{"$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":0}]
[null,"Rech.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":[]}