{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Price-List"],"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":"Лист1","index":0,"n_rows":76,"n_cols":6,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Заштрихованную часть получаем макросом из статьи, остальное см. формулы."]
["Остается отфильтровать строчки без цен и удалить их."]
[]
[null,"Ход","Diam.","-","Р","B"]
["MDM",10,8,38.64,{"$f":"IF(AND(D5>0,C5>=16,C5<=25),D5*1.5,\"\")","v":""},{"$f":"IF(AND(D5>0,C5>=12,C5<=25),D5*1.15,\"\")","v":""}]
["MDM",10,10,38.85,{"$f":"IF(AND(D6>0,C6>=16,C6<=25),D6*1.5,\"\")","v":""},{"$f":"IF(AND(D6>0,C6>=12,C6<=25),D6*1.15,\"\")","v":""}]
["MDM",10,12,31.11,"",35.776499999999999]
["MDM",10,16,29.02,43.53,33.372999999999998]
["MDM",10,20,32.770000000000003,49.155000000000001,37.685499999999998]
["MDM",10,25,35.6,53.400000000000006,40.94]
["MDM",25,8,40.43,"",""]
["MDM",25,10,40.85,"",""]
["MDM",25,12,31.71,"",36.466499999999996]
["MDM",25,16,30.81,46.214999999999996,35.431499999999993]
["MDM",25,20,33.51,50.265000000000001,38.536499999999997]
["MDM",25,25,36.5,54.75,41.974999999999994]
["MDM",50,8,42.43,"",""]
["MDM",50,10,42.75,"",""]
["MDM",50,12,32.31,"",37.156500000000001]
["MDM",50,16,32.31,48.465000000000003,37.156500000000001]
["MDM",50,20,34.700000000000003,52.050000000000004,39.905000000000001]
["MDM",50,25,38.29,57.435000000000002,44.033499999999997]
["MDM",80,8,43.5,"",""]
["MDM",80,10,43.68,"",""]
["MDM",80,12,32.909999999999997,"",37.846499999999992]
["MDM",80,16,33.51,50.265000000000001,38.536499999999997]
["MDM",80,20,35.9,53.849999999999994,41.284999999999997]
["MDM",80,25,39.79,59.685000000000002,45.758499999999998]
["MDM",100,8,44.54,"",""]
["MDM",100,10,44.75,"",""]
["MDM",100,12,33.51,"",38.536499999999997]
["MDM",100,16,34.1,51.150000000000006,39.214999999999996]
["MDM",100,20,37.1,55.650000000000006,42.664999999999999]
["MDM",100,25,41.28,61.92,47.471999999999994]
["MDM",125,8,46.33,"",""]
["MDM",125,10,46.63,"",""]
["MDM",125,12,34.700000000000003,"",39.905000000000001]
["MDM",125,16,34.700000000000003,52.050000000000004,39.905000000000001]
["MDM",125,20,37.99,56.984999999999999,43.688499999999998]
["MDM",125,25,42.48,63.72,48.85199999999999]
["MDM",160,8,null,"",""]
["MDM",160,10,null,"",""]
["MDM",160,12,36.5,"",41.974999999999994]
["MDM",160,16,36.5,54.75,41.974999999999994]
["MDM",160,20,40.68,61.019999999999996,46.781999999999996]
["MDM",160,25,45.47,68.204999999999998,52.290499999999994]
["MDM",200,8,null,"",""]
["MDM",200,10,null,"",""]
["MDM",200,12,37.69,"",43.343499999999992]
["MDM",200,16,38.29,57.435000000000002,44.033499999999997]
["MDM",200,20,42.48,63.72,48.85199999999999]
["MDM",200,25,47.87,71.804999999999993,55.050499999999992]
["MDM",250,8,null,"",""]
["MDM",250,10,null,"",""]
["MDM",250,12,42.96,"",49.403999999999996]
["MDM",250,16,43.08,64.62,49.541999999999994]
["MDM",250,20,47.57,71.355000000000004,54.705499999999994]
["MDM",250,25,54.45,81.675000000000011,62.6175]
["MDM",320,8,null,"",""]
["MDM",320,10,null,"",""]
["MDM",320,12,45.09,"",51.853499999999997]
["MDM",320,16,45.47,68.204999999999998,52.290499999999994]
["MDM",320,20,50.86,76.289999999999992,58.488999999999997]
["MDM",320,25,58.63,87.945000000000007,67.424499999999995]
["MDM",400,8,null,"",""]
["MDM",400,10,null,"",""]
["MDM",400,12,null,"",""]
["MDM",400,16,48.6,72.900000000000006,55.89]
["MDM",400,20,55.16,82.74,63.43399999999999]
["MDM",400,25,63.9,{"$f":"IF(AND(D70>0,C70>=16,C70<=25),D70*1.5,\"\")","v":95.85},{"$f":"IF(AND(D70>0,C70>=12,C70<=25),D70*1.15,\"\")","v":73.484999999999999}]
["MDM",500,8,null,"",""]
["MDM",500,10,null,"",""]
["MDM",500,12,null,"",""]
["MDM",500,16,53.18,79.77,61.156999999999996]
["MDM",500,20,60.55,90.824999999999989,69.632499999999993]
["MDM",500,25,70.48,105.72,81.051999999999992]

{"sheet":"Price-List","index":1,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Тип MDM"]
[]
[null,null,"Diam.",null,null,null,null,null,null,null,null,"Желаемый результат:"]
[null,null,8,10,12,16,20,25]
["Ход",10,38.64,38.85,31.11,29.02,32.770000000000003,35.6,null,null,null,"MDM",8,10,"-",38.64]
[null,25,40.43,40.85,31.71,30.81,33.51,36.5,null,null,null,"MDM",10,10,"-",38.85]
[null,50,42.43,42.75,32.31,32.31,34.700000000000003,38.29,null,null,null,"MDM",12,10,"-",31.11]
[null,80,43.5,43.68,32.909999999999997,33.51,35.9,39.79,null,null,null,"MDM",16,10,"-",29.02]
[null,100,44.54,44.75,33.51,34.1,37.1,41.28,null,null,null,"MDM",20,10,"-",32.770000000000003]
[null,125,46.33,46.63,34.700000000000003,34.700000000000003,37.99,42.48,null,null,null,"MDM",25,10,"-",35.6]
[null,160,null,null,36.5,36.5,40.68,45.47,null,null,null,"MDM",8,25,"-",40.43]
[null,200,null,null,37.69,38.29,42.48,47.87,null,null,null,"MDM",10,25,"-",40.85]
[null,250,null,null,42.96,43.08,47.57,54.45,null,null,null,"MDM",12,25,"-",31.71]
[null,320,null,null,45.09,45.47,50.86,58.63,null,null,null,"MDM",16,25,"-",30.81]
[null,400,null,null,null,48.6,55.16,63.9,null,null,null,"MDM",20,25,"-",33.51]
[null,500,null,null,null,53.18,60.55,70.48,null,null,null,"MDM",25,25,"-",36.5]
[]
["Опция",null,"-","нет опции",null,null,null,null,null,null,null,"……………………………………………………………………………………………………."]
[null,null,"P",0.5,"(16-20-25)"]
[null,null,"B",0.15,"(12-16-20-25)"]
[null,null,null,null,null,null,null,null,null,null,null,"MDM",16,25,"P",null,"46.62"]