{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["товар и данные по нему","количество поставок","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"товар и данные по нему","index":0,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["ДАТА","дата-макрос","ТОВАР","ЦЕНА",null,null,null,null,null,"товар","количество поставок","дата выставлена при помощи макроса",null,"начало периода","конец периода"]
["2014-07-14","14.07.2014","яблоко",null,null,null,null,null,null,"яблоко",{"$f":"COUNTIFS($C:$C,$J2,$A:$A,\">=\"&$N$2,$A:$A,\"<=\"&$O$2)","v":7},{"$f":"COUNTIFS($C:$C,$J2,$B:$B,\">=\"&$N$2,B:B,\"<=\"&$O$2)","v":0},null,"2014-07-14","2014-11-01"]
["2014-07-14","14.07.2014","слива",null,null,null,null,null,null,"груша",{"$f":"COUNTIFS($C:$C,$J3,$A:$A,\">=\"&$N$2,$A:$A,\"<=\"&$O$2)","v":2},{"$f":"COUNTIFS($C:$C,$J3,$B:$B,\">=\"&$N$2,B:B,\"<=\"&$O$2)","v":0}]
["2014-07-18","18.07.2014","картофель",null,null,null,null,null,null,"слива",7,0]
["2014-07-18","18.07.2014","яблоко",null,null,null,null,null,null,"картофель",7,0]
["2014-07-18","18.07.2014","яблоко",null,null,null,null,null,null,"помидор",2,0]
["2014-07-22","22.07.2014","груша",null,null,null,null,null,null,"капуста",4,0]
["2014-08-22","22.08.2014","слива"]
["2014-09-05","5.09.2014","картофель"]
["2014-09-06","6.09.2014","картофель"]
["2014-09-07","7.09.2014","помидор"]
["2014-09-07","7.09.2014","яблоко"]
["2014-09-07","7.09.2014","помидор"]
["2014-09-10","10.09.2014","груша"]
["2014-09-10","10.09.2014","слива"]
["2014-09-10","10.09.2014","яблоко"]
["2014-09-11","11.09.2014","капуста",null,null,null,null,null,null,null,{"$f":"SUM(K2:K16)","v":29}]
["2014-09-10","10.09.2014","картофель"]
["2014-09-15","15.09.2014","яблоко"]
["2014-08-17","17.08.2014","картофель"]
["2014-09-17","17.09.2014","картофель"]
["2014-08-18","18.08.2014","картофель"]
["2014-08-18","18.08.2014","слива"]
["2014-08-18","18.08.2014","слива"]
["2014-08-18","18.08.2014","слива"]
["2014-08-25","25.08.2014","капуста"]
["2014-09-15","15.09.2014","капуста"]
["2014-09-16","16.09.2014","капуста"]
["2014-10-10","10.10.2014","яблоко"]
["2014-10-25","25.10.2014","слива"]

{"sheet":"количество поставок","index":1,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"товар","количество поставок",null,null,null,"дата начала","дата завершения"]
[null,"яблоко",{"$f":"COUNTIFS('товар и данные по нему'!$C:$C,$B3,'товар и данные по нему'!$A:$A,\">=\"&$G$3,'товар и данные по нему'!$A:$A,\"<=\"&$H$3)","v":7},null,null,null,"2014-07-01","2014-11-11"]
[null,"груша",{"$f":"COUNTIFS('товар и данные по нему'!$C:$C,$B4,'товар и данные по нему'!$A:$A,\">=\"&$G$3,'товар и данные по нему'!$A:$A,\"<=\"&$H$3)","v":2}]
[null,"слива",{"$f":"COUNTIFS('товар и данные по нему'!$C:$C,$B5,'товар и данные по нему'!$A:$A,\">=\"&$G$3,'товар и данные по нему'!$A:$A,\"<=\"&$H$3)","v":7}]
[null,"картофель",{"$f":"COUNTIFS('товар и данные по нему'!$C:$C,$B6,'товар и данные по нему'!$A:$A,\">=\"&$G$3,'товар и данные по нему'!$A:$A,\"<=\"&$H$3)","v":7}]
[null,"помидор",{"$f":"COUNTIFS('товар и данные по нему'!$C:$C,$B7,'товар и данные по нему'!$A:$A,\">=\"&$G$3,'товар и данные по нему'!$A:$A,\"<=\"&$H$3)","v":2}]
[null,"капуста",{"$f":"COUNTIFS('товар и данные по нему'!$C:$C,$B8,'товар и данные по нему'!$A:$A,\">=\"&$G$3,'товар и данные по нему'!$A:$A,\"<=\"&$H$3)","v":4}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C3:C17)","v":29}]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}