{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Foglio1","Foglio2","Foglio3"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Foglio1","index":0,"n_rows":47,"n_cols":10,"rows_kept":47,"merged":[[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[16,0,16,1],[16,2,16,4],[16,5,16,7],[16,8,16,9],[17,3,17,4],[17,6,17,7],[17,8,17,9],[18,3,18,4],[18,6,18,7],[18,8,18,9],[19,0,19,1],[19,2,19,4],[19,6,19,9],[20,0,20,1],[20,2,20,4],[20,6,20,9],[21,2,21,4],[21,6,21,7],[35,0,35,1],[35,3,35,4],[35,8,35,9],[36,0,36,1],[36,3,36,4],[36,8,36,9],[37,0,37,1],[37,3,37,5],[37,6,37,7],[37,8,37,9],[38,0,38,1],[38,3,38,5],[38,6,38,7],[38,8,38,9],[39,0,39,1],[39,3,39,5],[39,6,39,7],[39,8,39,9],[40,0,40,1],[40,3,40,5],[40,6,40,7],[40,8,40,9],[41,0,41,1],[41,3,41,5],[41,6,41,7],[41,8,41,9],[42,0,42,1],[42,4,42,5],[42,6,44,9],[45,0,45,1],[45,7,45,9],[46,0,46,9]]}
{"$rows_empty":8}
["Codice Cliente"]
[]
["Partita IVA"]
[]
[]
[]
[]
[]
["Fattura commerciale",null,"Ordine",null,null,"D.d.t.",null,null,"Spedizione"]
["Data","N.","Data","N.",null,"Data","N.",null,"a mezzo"]
[]
["Pagamento",null,"Scadenze",null,null,"N. rate","Banca d'appoggio"]
[]
["Cod. Art.","Quantità","Descrizione",null,null,"Prezzo","Sconto",null,"Importo","IVA"]
[{"$nulls":8},{"$f":"(B23*F23)*(1-G23)*(1-H23)","v":0}]
[{"$nulls":8},{"$f":"(B24*F24)*(1-G24)*(1-H24)","v":0}]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
["Totale merce",null,"Sconto","Importo netto",null,"Trasporto","Imballo",null,"Spese non documentate"]
[{"$f":"SUM(I23:I35)","v":0},null,null,{"$f":"A37*(1-C37)","v":0},{"$nulls":4},{"$f":"SUM(F37:H37)","v":0}]
["Imponibile merce",null,"Aliq. IVA","Riparto Spese",null,null,"Imponibile",null,"IVA"]
[{"$f":"SUMIF($J$23:$J$35,C39,$I$23:$I$35)*(1-$C$37)","v":0},null,{"v":0.04,"d":"4.00%"},{"$f":"($I$37/$A$42)*A39","v":{"$error":"#DIV/0!"}},null,null,{"$f":"A39+D39","v":{"$error":"#DIV/0!"}},null,{"$f":"G39*C39","v":{"$error":"#DIV/0!"}}]
[{"$f":"SUMIF($J$23:$J$35,C40,$I$23:$I$35)*(1-$C$37)","v":0},null,{"v":0.1,"d":"10.00%"},{"$f":"($I$37/$A$42)*A40","v":{"$error":"#DIV/0!"}},null,null,{"$f":"A40+D40","v":{"$error":"#DIV/0!"}},null,{"$f":"G40*C40","v":{"$error":"#DIV/0!"}}]
[{"$f":"SUMIF($J$23:$J$35,C41,$I$23:$I$35)*(1-$C$37)","v":0},null,{"v":0.2,"d":"20.00%"},{"$f":"($I$37/$A$42)*A41","v":{"$error":"#DIV/0!"}},null,null,{"$f":"A41+D41","v":{"$error":"#DIV/0!"}},null,{"$f":"G41*C41","v":{"$error":"#DIV/0!"}}]
[{"$f":"SUM(A39:A41)","v":0},null,null,{"$f":"SUM(D39:D41)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(G39:G41)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(I39:I41)","v":{"$error":"#DIV/0!"}}]
["Totale imponibile",null,"Totale IVA","Art. 10 (esenti) Acconto","Art. 15 (esclusi)",null,"TOTALE FATTURA                              S.E. & O."]
[]
[]
[{"$f":"G42","v":{"$error":"#DIV/0!"}},null,{"$f":"I42","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D44:D45)","v":0},null,{"$f":"SUM(F44:F45)","v":0},"€",{"$f":"A46+C46+D46+F46","v":{"$error":"#DIV/0!"}}]
["Contributo Conai ove dovuto"]

{"sheet":"Foglio2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Foglio3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}