{"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":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["ОПТ","Наценка","Объем","Сравн","Р.цена",null,"ОПТ","Объем +","Объем -","Ср.взвеш Р.цена"]
[250,15,6,245,{"$f":"A2+B2","v":265},null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G1)","v":185.5},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":0},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[250,16,-9,246,266,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G2)","v":185.5},{"$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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":188}]
[250,16,-1,245,266,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G3)","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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":224.9}]
[250,14.7,-2,245,264.7,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G4)","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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":222.5}]
[220,21,-7,220,241,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G5)","v":200.1},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":40},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":210.1}]
[220,20,1,215,240,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G6)","v":200.1},{"$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":0},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[220,21,5,220,241,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G7)","v":200.2},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":5},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":212.2}]
[250,16,-1,245,266,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G8)","v":200.2},{"$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":0},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[200,24.9,3,205,224.9,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G9)","v":200.6},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":2},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":211.6}]
[220,21,3,215,241,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G10)","v":200.6},{"$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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":212.6}]
[300,5,-1,280,305,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G11)","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":"IFERROR(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,17,-1,240,267,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G12)","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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":241}]
[300,4,3,285,304,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G13)","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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":265}]
[300,5,1,280,305,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G14)","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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":265.81428571428575}]
[300,6,-4,280,306,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G15)","v":266.3},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":15},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":270.3}]
[300,4,-1,280,304,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G16)","v":266.3},{"$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":0},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[250,15,-1,245,265,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G17)","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":"IFERROR(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,-4,245,266,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G18)","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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":305}]
[250,15,6,240,265,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G19)","v":303.2},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":0},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[200,22,-1,210,222,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G20)","v":303.2},{"$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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":323.2}]
[200,23,-2,210,{"$f":"A22+B22","v":223},null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G21)","v":400},{"$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":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":406}]
[200.6,12,-3,205,212.6,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G22)","v":400},{"$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":0},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[200.6,11,2,205,211.6,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl14[ОПТ],ROW()/2),G23)","v":""},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\">0\"),\"\")","v":0},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl14[Объем],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl14[Р.цена],tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl14[ОПТ],tabl55[[#This Row],[ОПТ]],tabl14[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[400,6,3,405,406]
[303.2,20,-6,310,323.2]
[200.2,12,5,205,212.2]
[200.1,10,40,201,210.1]
[266.3,4,15,270,270.3]
[185.5,2.5,-3,190,188]

{"sheet":"Лист3","index":2,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["ОПТ","Наценка","Объем","Сравн","Р.цена",null,"ОПТ","Объем +","Объем -","Ср.взвеш Р.цена"]
[250,15,6,245,{"$f":"A2+B2","v":265},null,185.5,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":0},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[250,16,-9,246,266,null,185.5,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":-3},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":188}]
[250,16,-1,245,266,null,200,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":3},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":224.9}]
[250,14.7,-2,245,264.7,null,200,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":-3},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":222.5}]
[220,21,-7,220,241,null,200.1,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":40},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":210.1}]
[220,20,1,215,240,null,200.1,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":0},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[220,21,5,220,241,null,200.2,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":5},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":212.2}]
[250,16,-1,245,266,null,200.2,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":0},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[200,24.9,3,205,224.9,null,200.6,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":2},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":211.6}]
[220,21,3,215,241,null,200.6,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":-3},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":212.6}]
[300,5,-1,280,305,null,220,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":9},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":240.66666666666666}]
[250,17,-1,240,267,null,220,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":-7},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":241}]
[300,4,3,285,304,null,250,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":12},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":265}]
[300,5,1,280,305,null,250,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":-19},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":265.81428571428575}]
[300,6,-4,280,306,null,266.3,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":15},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":270.3}]
[300,4,-1,280,304,null,266.3,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":0},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[250,15,-1,245,265,null,300,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":4},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":304.5}]
[250,16,-4,245,266,null,300,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":-6},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":305}]
[250,15,6,240,265,null,303.2,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":0},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[200,22,-1,210,222,null,303.2,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":-6},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":323.2}]
[200,23,-2,210,223,null,400,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":3},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":406}]
[200.6,12,-3,205,212.6,null,400,{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":""},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":0},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[200.6,11,2,205,211.6,null,{"$f":"IF(ISEVEN(ROW()),Opt(tabl148[ОПТ],ROW()/2),G23)","v":""},{"$f":"IF(ISEVEN(ROW()),SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\">0\"),\"\")","v":0},{"$f":"IF(ISEVEN(ROW()),\"\",SUMIFS(tabl148[Объем],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],\"<0\"))","v":""},{"$f":"IFERROR(SUMIFS(tabl148[Р.цена],tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\")/COUNTIFS(tabl148[ОПТ],tabl559[[#This Row],[ОПТ]],tabl148[Объем],IF(ISEVEN(ROW()),\">\",\"<\")&\"0\"),\"\")","v":""}]
[400,6,3,405,406]
[303.2,20,-6,310,323.2]
[200.2,12,5,205,212.2]
[200.1,10,40,201,210.1]
[266.3,4,15,270,270.3]
[185.5,2.5,-3,190,188]