{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BASE DATI","Riepilogo con Pivot","Riepilogo con Formula"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"BASE DATI","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["QUANTITA'","Data","ARTICOLO"]
[419,"2014-01-01","A123"]
[262,"2014-01-02","B523"]
[452,"2014-01-03","Z101"]
[165,"2014-01-04","B523"]
[62,"2014-01-05","W683"]
[269,"2014-01-06","W683"]
[121,"2014-01-07","A123"]
[163,"2014-01-08","Z101"]
[81,"2014-01-09","W683"]
[142,"2014-01-10","Z101"]
[369,"2014-01-11","W683"]
[243,"2014-01-12","B523"]
[303,"2014-01-13","Z101"]
[130,"2014-01-14","W683"]
[420,"2014-01-15","Z101"]
[155,"2014-01-16","A123"]

{"sheet":"Riepilogo con Pivot","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["ARTICOLO","TOTALE QUANTITA'","Numero ARTICOLI"]
["A123",695,3]
["B523",670,3]
["W683",911,5]
["Z101",1480,5]
["Grand Total",3756,16]

{"sheet":"Riepilogo con Formula","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["ARTICOLO","TOTALE QUANTITA'","Numero ARTICOLI"]
["A123",{"$f":"SUMIF('BASE DATI'!C:C,A2,'BASE DATI'!A:A)","v":695},{"$f":"COUNTIF('BASE DATI'!C:C,A2)","v":3}]
["B523",{"$f":"SUMIF('BASE DATI'!C:C,A3,'BASE DATI'!A:A)","v":670},{"$f":"COUNTIF('BASE DATI'!C:C,A3)","v":3}]
["W683",{"$f":"SUMIF('BASE DATI'!C:C,A4,'BASE DATI'!A:A)","v":911},{"$f":"COUNTIF('BASE DATI'!C:C,A4)","v":5}]
["Z101",{"$f":"SUMIF('BASE DATI'!C:C,A5,'BASE DATI'!A:A)","v":1480},{"$f":"COUNTIF('BASE DATI'!C:C,A5)","v":5}]
[null,{"$f":"SUM(B2:B5)","v":3756},{"$f":"SUM(C2:C5)","v":16}]