{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Лист1","index":0,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,5,35,6]]}
["Товар","дата покупки","кол-во","куплено","продано","прибыль","%","дата продажи"]
["товар1","2013-01-01",1,100,200,{"$f":"IF(0<E2,SUM(E2-D2),0)","v":100},{"$f":"IF(0=F2,0,SUM(E2*100/D2/100-100%))","v":1},"2013-01-02",null,null,null,null,"2013-07-05"]
["товар2","2013-01-02",1,200,250,50,0.25,"2013-01-02",null,null,null,"куплено ","продано","прибыль","ср. %"]
["товар3","2013-02-01",1,300,500,200,0.66666666666666652,"2013-02-02",null,null,"2013-01-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$4))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":300},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$4))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":450},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$4))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":150},{"$f":"AVERAGE((MONTH($H$2:$H$376)=MONTH(K$4))*((YEAR($H$2:$H376)=YEAR(M$2))*$G$2:$G$376))","v":3.3333333333333335E-3}]
["товар4","2013-02-02",1,100,750,{"$f":"IF(0<E5,SUM(E5-D5),0)","v":650},{"$f":"IF(0=F5,0,SUM(E5*100/D5/100-100%))","v":6.5},"2013-02-02",null,null,"1900-02-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$5))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":400},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$5))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":1250},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$5))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":850}]
["товар5","2013-03-01",1,50,300,250,5,"2013-03-02",null,null,"1900-03-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$6))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":650},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$6))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":1500},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$6))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":850}]
["товар6","2013-03-02",1,600,1200,600,1,"2013-03-02",null,null,"1900-04-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$7))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":1650},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$7))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$7))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":0}]
["товар7","2013-04-01",2,500,null,{"$f":"IF(0<E8,SUM(E8-D8),0)","v":0},{"$f":"IF(0=F8,0,SUM(E8*100/D8/100-100%))","v":0},null,null,null,"1900-05-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$8))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$8))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$8))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":0}]
["товар8","2013-04-02",3,550,null,0,0,null,null,null,"1900-06-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$9))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$9))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$9))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":0}]
["товар9","2013-04-03",4,600,null,0,0,null,null,null,"1900-07-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$10))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$10))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$10))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1900-08-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$11))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$11))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$11))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1900-09-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$12))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$12))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$12))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1900-10-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$13))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$13))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$13))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1900-11-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$14))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$14))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$14))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1900-12-01",{"$f":"SUM((MONTH($B$2:$B$376)=MONTH(K$15))*((YEAR($B$2:$B376)=YEAR(M$2))*$D$2:$D$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$15))*((YEAR($H$2:$H376)=YEAR(M$2))*$E$2:$E$376))","v":0},{"$f":"SUM((MONTH($H$2:$H$376)=MONTH(K$15))*((YEAR($H$2:$H376)=YEAR(M$2))*$F$2:$F$376))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Итог:",{"$f":"SUM(L4:L15)","v":3000},{"$f":"SUM(M4:M15)","v":3200},{"$f":"SUM(N4:N15)","v":1850}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"2013-10-17"]
[null,"2013-10-17"]
[null,"2013-10-17"]

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

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