{"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":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ОПТ","Наценка","Объем","Сравн","Р.цена",null,"ОПТ","Объем +","Объем -","Ср.взвеш Р.цена"]
[250,15,6,245,{"$f":"A2+B2","v":265},null,200,3,null,224]
[250,16,-9,246,266,null,200,null,-3,222.66666000000001]
[250,16,-1,245,266,null,220,9]
[250,14,-2,245,264,null,220,null,-7]
[220,21,-7,220,241,null,250,12]
[220,20,1,215,240,null,250,null,-19]
[220,21,5,220,241,null,300,4]
[250,16,-1,245,266,null,300,null,-6]
[200,24,3,205,{"$f":"A10+B10","v":224}]
[220,21,3,215,241]
[300,5,-1,280,305]
[250,17,-1,240,267]
[300,4,3,285,304]
[300,5,1,280,305]
[300,6,-4,280,306]
[300,4,-1,280,304]
[250,15,-1,245,265]
[250,16,-4,245,266]
[250,15,6,240,265]
[200,22,-1,210,222]
[200,23,-2,210,{"$f":"A22+B22","v":223}]

{"sheet":"Лист2","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ОПТ","Наценка","Объем","Сравн","Р.цена",null,"ОПТ","Объем +","Объем -","Ср.взвеш Р.цена"]
[250,15,6,245,{"$f":"A2+B2","v":265},null,{"$f":"Opt(tabl14[ОПТ],INT(ROW()/2))","v":200},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":3},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")","v":224}]
[250,16,-9,246,266,null,{"$f":"Opt(tabl14[ОПТ],INT(ROW()/2))","v":200},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":-3},{"$f":"SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")","v":222.5}]
[250,16,-1,245,266,null,{"$f":"Opt(tabl14[ОПТ],INT(ROW()/2))","v":220},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":9},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")","v":240.66666666666666}]
[250,14,-2,245,264,null,{"$f":"Opt(tabl14[ОПТ],INT(ROW()/2))","v":220},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":-7},{"$f":"SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")","v":241}]
[220,21,-7,220,241,null,{"$f":"Opt(tabl14[ОПТ],INT(ROW()/2))","v":250},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":12},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")","v":265}]
[220,20,1,215,240,null,{"$f":"Opt(tabl14[ОПТ],INT(ROW()/2))","v":250},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":-19},{"$f":"SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")","v":265.71428571428572}]
[220,21,5,220,241,null,{"$f":"Opt(tabl14[ОПТ],INT(ROW()/2))","v":300},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":4},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")","v":304.5}]
[250,16,-1,245,266,null,{"$f":"Opt(tabl14[ОПТ],INT(ROW()/2))","v":300},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":-6},{"$f":"SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")","v":305}]
[200,24,3,205,224]
[220,21,3,215,241]
[300,5,-1,280,305]
[250,17,-1,240,267]
[300,4,3,285,304]
[300,5,1,280,305]
[300,6,-4,280,306]
[300,4,-1,280,304]
[250,15,-1,245,265]
[250,16,-4,245,266]
[250,15,6,240,265]
[200,22,-1,210,222]
[200,23,-2,210,{"$f":"A22+B22","v":223}]

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