{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Схема","Оборудование","Статистика","Изготовлено","Буфер","Брак","Работа","Потери.ПустойБуфер","EXCEL2.RU"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":28,"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":66,"n_cols":24,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Файл скачан с сайта excel2.ru >>>"]
["Перейти к статье >>>"]
["Модель MS EXCEL выполнения заказа на производственной линии с произвольной схемой (задача 1.1)"]
[null,null,null,null,null,null,null,"Стирает все результаты расчетов и статистику","Стирает схему, результаты анализа схемы, все результаты расчетов, статистику и пользовательские настройки оборудования"]
[null,null,null,null,null,null,null,null,null,null,"Заказ","Изготовлено",null,"Начальное оборудование",{"$f":"COUNTIF(M24:M43,0)","v":3},"д.б. от 1 до 5 (потребляет исходный материал)"]
[null,null,null,null,null,null,null,null,null,"Колич-во шт",1500,{"$f":"IF(ISTEXT(Буфер!W13),\"\",Буфер!W13)","v":1517},null,"Продукт",{"$f":"COUNTIF(L24:L43,0)=1","v":true},"ровно 1 продукт"]
[null,null,null,null,null,null,null,null,null,"Средняя производительность схемы, шт/час",{"$f":"OrderNew/(L11-S21)","v":34.883720930232556},null,null,"Кол-во Сборок",{"$f":"COUNTIF(M24:M43,\">1\")","v":2},"добавляется столько же типов материалов"]
[null,null,null,null,null,null,null,null,null,"с поправкой на время наработки НЗП от начального оборудования до конечного",null,null,null,"Проверка нач.об.",{"$f":"SUM(O24:O43)-COUNTIF(O24:O43,\">0\")+1=O5","v":true},"Начального оборуд. д.б. больше на 1 чем сборок"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Всего единиц",{"$f":"COUNT(J24:J43)","v":10},"Максимум 20"]
[null,null,null,null,null,null,null,null,null,null,"Заказ изготовлен","Статистика (среднее)",null,"Настройки оборуд.",{"$f":"IF(StandartEqSettingsFlag,TRUE,EqClear=EqCount)","v":true},"пользовательские настройки заполнены (лист оборудование)"]
[null,null,null,null,null,null,null,null,null,"Срок исполнения заказа",{"$f":"ProdClear","v":48},{"$f":"Статистика!B3","v":48},null,"Кол-во Нач.оборуд",{"$f":"O5<6","v":true},"д.б. меньше 6"]
[null,null,null,null,null,null,null,null,null,"Потребность в сырье1",2400,{"$f":"Статистика!D3","v":2316},null,"Проверка финальная",{"$f":"AND(N24:N43,O6,O8,O10,O11,SchFilled<=20)","v":true}]
[null,null,null,null,null,null,null,null,null,"Потребность в сырье2",2150,{"$f":"Статистика!E3","v":2264}]
[null,null,null,null,null,null,null,null,null,"Потребность в сырье3",2000,{"$f":"Статистика!F3","v":2146},null,"Нач.строка",{"$f":"ROW(J23)","v":23}]
[null,null,null,null,null,null,null,false,true,"Потребность в сырье4",null,{"$f":"Статистика!G3","v":{"$error":"#DIV/0!"}},null,"Нач.столбец",{"$f":"COLUMN(J23)","v":10}]
[null,null,null,null,null,null,null,null,null,"Потребность в сырье5",null,{"$f":"Статистика!H3","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,"Кол-во циклов для набора статистики",300]
[null,null,null,null,null,null,null,null,null,"% выполнения",1]
[null,null,null,null,null,null,null,"Ср.производ.схемы, шт/час",{"$f":"IF(Progress=1,MAX(BottleNeckSearch),\"\")","v":38.46153846153846},null,null,null,null,null,null,null,null,null,"Вычисление самой длинной последовательности"]
[null,null,null,null,null,null,null,"Узкое место",{"$f":"IF(Progress=1,MATCH(MAX(BottleNeckSearch),BottleNeckSearch,0),\"\")","v":1},"Результаты анализа схемы",null,null,null,null,null,null,null,null,{"$f":"MAX(T21:X21)","v":5},{"$f":"IFERROR(MATCH(0,T24:T43,0)-2,0)","v":4},{"$f":"IFERROR(MATCH(0,U24:U43,0)-2,0)","v":5},3,0,0]
[null,null,null,null,null,null,null,null,null,null,"+1","+2","+3","+4","+5","+6","+7"]
[null,null,null,null,null,null,null,null,null,"№ оборудования","Последователь","Число исх.","Число входящих","Проверка на соединение","Проверка нач.об.","# исх. Материала","Предшественники",null,"№","Начало1","Начало2","Начало3","Начало4","Начало5"]
[null,null,null,null,null,null,null,null,null,1,2,1,1,{"$f":"IF(ISBLANK(J24),\"\",OR(L24>0,M24>0))","v":true},{"$f":"IF(M24>1,M24,0)","v":0},{"$f":"COUNTIF($M$24:M24,0)","v":0},"06",null,1,{"$f":"MATCH(0,M24:M43,0)","v":8},{"$f":"MATCH(0,OFFSET($M$24,T24,,COUNT($M$24:$M$43)-T24),0)+T24","v":9},{"$f":"MATCH(0,OFFSET($M$24,U24,,COUNT($M$24:$M$43)-U24),0)+U24","v":10},{"$f":"MATCH(0,OFFSET($M$24,V24,,COUNT($M$24:$M$43)-V24),0)+V24","v":{"$error":"#REF!"}},{"$f":"MATCH(0,OFFSET($M$24,W24,,COUNT($M$24:$M$43)-W24),0)+W24","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,2,3,1,1,true,0,{"$f":"COUNTIF($M$24:M25,0)","v":0},"01",null,2,{"$f":"VLOOKUP(T24,$J$24:$K$43,2,0)","v":7},{"$f":"VLOOKUP(U24,$J$24:$K$43,2,0)","v":6},{"$f":"VLOOKUP(V24,$J$24:$K$43,2,0)","v":4},{"$f":"VLOOKUP(W24,$J$24:$K$43,2,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,3,5,1,2,true,2,{"$f":"COUNTIF($M$24:M26,0)","v":0},"0204",null,3,{"$f":"VLOOKUP(T25,$J$24:$K$43,2,0)","v":4},{"$f":"VLOOKUP(U25,$J$24:$K$43,2,0)","v":1},{"$f":"VLOOKUP(V25,$J$24:$K$43,2,0)","v":3},{"$f":"VLOOKUP(W25,$J$24:$K$43,2,0)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(X25,$J$24:$K$43,2,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,4,3,1,2,true,2,{"$f":"COUNTIF($M$24:M27,0)","v":0},"0710",null,4,{"$f":"VLOOKUP(T26,$J$24:$K$43,2,0)","v":3},2,5,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,5,0,0,1,true,0,{"$f":"COUNTIF($M$24:M28,0)","v":0},"03",null,5,5,3,0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,6,1,1,1,true,0,{"$f":"COUNTIF($M$24:M29,0)","v":0},"09",null,6,0,5,{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"№ Оборудования",null,5,null,null,null,null,null,7,4,1,1,true,0,{"$f":"COUNTIF($M$24:M30,0)","v":0},"08",null,7,{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,8,7,1,0,true,0,{"$f":"COUNTIF($M$24:M31,0)","v":1},null,null,8,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,9,6,1,0,true,0,{"$f":"COUNTIF($M$24:M32,0)","v":2},null,null,9,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,10,4,1,0,true,0,{"$f":"COUNTIF($M$24:M33,0)","v":3},null,null,10,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$f":"COUNTIF($M$24:M34,0)","v":3},null,null,11,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$f":"COUNTIF($M$24:M35,0)","v":3},null,null,12,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J36),\"\",OR(L36>0,M36>0))","v":""},0,{"$f":"COUNTIF($M$24:M36,0)","v":3},null,null,13,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$f":"COUNTIF($M$24:M37,0)","v":3},null,null,14,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$f":"COUNTIF($M$24:M38,0)","v":3},null,null,15,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$f":"COUNTIF($M$24:M39,0)","v":3},null,null,16,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$f":"COUNTIF($M$24:M40,0)","v":3},null,null,17,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J41),\"\",OR(L41>0,M41>0))","v":""},{"$f":"IF(M41>1,M41,0)","v":0},{"$f":"COUNTIF($M$24:M41,0)","v":3},null,null,18,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$f":"COUNTIF($M$24:M42,0)","v":3},null,null,19,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$f":"COUNTIF($M$24:M43,0)","v":3},null,null,20,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,null,null,null,null,null,null,null,"Занятость оборудования, час"]
[null,{"$f":"\"Оборудование №\"&D30","v":"Оборудование №5"},null,null,null,null,null,null,null,{"$f":"J23","v":"№ оборудования"},"работа, ч","поломка, ч","простой, ч"]
[null,"Показатель","шт","Смещение","%",null,null,null,null,{"$f":"IF(ISNUMBER(J24),J24,\"\")","v":1},{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J47),\"\")","v":43},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J47),\"\")","v":0},{"$f":"IFERROR($K$11-K47-L47,\"\")","v":5}]
[null,"Мощность, шт",{"$f":"INDEX(Оборудование!B19:B38,Схема!D30)*K11","v":2400},null,null,null,null,null,null,2,{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J48),\"\")","v":42},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J48),\"\")","v":0},6]
[null,"Изготовлено (до вычета брака)",{"$f":"OFFSET(Изготовлено!A13,,Схема!D30,)","v":1534},null,{"$f":"C49/$C$48","v":0.63916666666666666},null,null,null,null,3,{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J49),\"\")","v":41},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J49),\"\")","v":0},7]
[null,"Брак",{"$f":"OFFSET(Брак!A13,,Схема!D30,)","v":17},{"$f":"C49-C50","v":1517},{"$f":"C50/$C$48","v":7.083333333333333E-3},null,null,null,null,4,{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J50),\"\")","v":38},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J50),\"\")","v":4},6]
[null,"Потери из-за поломки",{"$f":"OFFSET(Работа!A9,,Схема!D30,)","v":0},{"$f":"C49","v":1534},0,null,null,null,null,5,{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J51),\"\")","v":40},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J51),\"\")","v":0},8]
[null,"Потери из-за опустош. буфера",{"$f":"OFFSET(Потери.ПустойБуфер!A13,,Схема!D30,)","v":866},{"$f":"D51+C51","v":1534},{"$f":"C52/$C$48","v":0.36083333333333334},null,null,null,null,6,{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J52),\"\")","v":41},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J52),\"\")","v":0},7]
[null,null,null,null,{"$f":"E52+E51+E49","v":1},null,null,null,null,7,{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J53),\"\")","v":43},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J53),\"\")","v":4},1]
[null,null,null,null,null,null,null,null,null,8,{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J54),\"\")","v":48},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J54),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,null,9,{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J55),\"\")","v":43},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J55),\"\")","v":5},0]
[null,null,null,null,null,null,null,null,null,10,{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J56),\"\")","v":40},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J56),\"\")","v":3},5]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J57),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J57),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J58),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J58),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J59),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J59),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J60),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J60),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J61),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J61),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J62),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J62),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J63),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J63),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J64),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J64),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J65),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J65),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(OFFSET(Изготовлено!$A$11,,Схема!J66),\"\")","v":""},{"$f":"IFERROR(OFFSET(Работа!$A$13,,Схема!J66),\"\")","v":""},""]

{"sheet":"Оборудование","index":1,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Стандартные настройки для оборудования"]
[]
[null,1,2,3,4,5,6]
["Стандарт","Мощность оборудования, шт в час","Вероятность брака, %","Вероятность простоя оборудования, %","Простой оборудования - Минимум, час","Простой оборудования - Максимум, час","Критический уровень буфера, шт"]
[1,50,0.02,0.01,3,5,{"$f":"B5*F5","v":250}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Пользовательские настройки для оборудования",null,null,null,null,null,null,"% увеличения мощности оборудования (для определения узкого места системы)"]
[{"$f":"COUNT(A19:A38)","v":10},{"$f":"COUNT(B19:B38)","v":10},null,null,null,null,null,0.5]
[]
["Оборудование","Мощность оборудования, шт в час","Вероятность брака, %","Вероятность простоя оборудования, %","Простой оборудования - Минимум, час","Простой оборудования - Максимум, час","Критический уровень буфера, шт",{"$f":"\"Производительность системы при увеличении мощности ед.оборуд. на \"&TEXT(H16,\"0%\")","v":"Производительность системы при увеличении мощности ед.оборуд. на 50%"},null,"Начальное?","Сборка?","Конечное?"]
[{"$f":"IF(Схема!J24,Схема!J24,\"\")","v":1},40,0.02,0.01,3,5,{"$f":"B19*F19","v":200},38.46153846153846,null,{"$f":"IF(AND(ISNUMBER(A19),Схема!M24=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A19),Схема!M24>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A19),Схема!K24=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J25,Схема!J25,\"\")","v":2},50,0.01,0.01,3,5,250,34.883720930232556,null,{"$f":"IF(AND(ISNUMBER(A20),Схема!M25=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A20),Схема!M25>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A20),Схема!K25=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J26,Схема!J26,\"\")","v":3},50,0.01,0.01,2,3,150,34.883720930232556,null,{"$f":"IF(AND(ISNUMBER(A21),Схема!M26=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A21),Схема!M26>1),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(A21),Схема!K26=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J27,Схема!J27,\"\")","v":4},50,0.02,0.01,3,5,250,34.883720930232556,null,{"$f":"IF(AND(ISNUMBER(A22),Схема!M27=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A22),Схема!M27>1),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(A22),Схема!K27=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J28,Схема!J28,\"\")","v":5},50,0.01,0.01,3,5,{"$f":"B23*F23","v":250},34.883720930232556,null,{"$f":"IF(AND(ISNUMBER(A23),Схема!M28=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A23),Схема!M28>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A23),Схема!K28=0),TRUE,\"\")","v":true}]
[{"$f":"IF(Схема!J29,Схема!J29,\"\")","v":6},50,0.01,0.01,3,5,{"$f":"B24*F24","v":250},34.090909090909093,null,{"$f":"IF(AND(ISNUMBER(A24),Схема!M29=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A24),Схема!M29>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A24),Схема!K29=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J30,Схема!J30,\"\")","v":7},50,0.01,0.01,3,5,250,34.883720930232556,null,{"$f":"IF(AND(ISNUMBER(A25),Схема!M30=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A25),Схема!M30>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A25),Схема!K30=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J31,Схема!J31,\"\")","v":8},50,0.01,0.01,3,5,250,34.883720930232556,null,{"$f":"IF(AND(ISNUMBER(A26),Схема!M31=0),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(A26),Схема!M31>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A26),Схема!K31=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J32,Схема!J32,\"\")","v":9},50,0.01,0.01,3,5,250,34.883720930232556,null,{"$f":"IF(AND(ISNUMBER(A27),Схема!M32=0),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(A27),Схема!M32>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A27),Схема!K32=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J33,Схема!J33,\"\")","v":10},50,0.01,0.01,3,5,250,34.883720930232556,null,{"$f":"IF(AND(ISNUMBER(A28),Схема!M33=0),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(A28),Схема!M33>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A28),Схема!K33=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J34,Схема!J34,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A29),Схема!M34=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A29),Схема!M34>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A29),Схема!K34=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J35,Схема!J35,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A30),Схема!M35=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A30),Схема!M35>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A30),Схема!K35=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J36,Схема!J36,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A31),Схема!M36=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A31),Схема!M36>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A31),Схема!K36=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J37,Схема!J37,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A32),Схема!M37=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A32),Схема!M37>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A32),Схема!K37=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J38,Схема!J38,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A33),Схема!M38=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A33),Схема!M38>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A33),Схема!K38=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J39,Схема!J39,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A34),Схема!M39=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A34),Схема!M39>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A34),Схема!K39=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J40,Схема!J40,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A35),Схема!M40=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A35),Схема!M40>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A35),Схема!K40=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J41,Схема!J41,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A36),Схема!M41=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A36),Схема!M41>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A36),Схема!K41=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J42,Схема!J42,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A37),Схема!M42=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A37),Схема!M42>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A37),Схема!K42=0),TRUE,\"\")","v":""}]
[{"$f":"IF(Схема!J43,Схема!J43,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(AND(ISNUMBER(A38),Схема!M43=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A38),Схема!M43>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(A38),Схема!K43=0),TRUE,\"\")","v":""}]

{"sheet":"Статистика","index":2,"n_rows":314,"n_cols":18,"rows_kept":314,"cut":false,"hidden":false,"merged":[]}
["Таблица статистики"]
[null,{"$f":"B14","v":"Время выполнения, часов"},"Ст.отклонение",{"$f":"D14","v":"Сырье1"},{"$f":"E14","v":"Сырье2"},"Сырье3","Сырье4","Сырье5"]
[0.5,{"$f":"INT($K$22+C3*$K$23)","v":48},0,{"$f":"INT(K$43+$C3*K$44)","v":2316},{"$f":"INT(L$43+$C3*L$44)","v":2264},{"$f":"INT(M$43+$C3*M$44)","v":2146},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+A3+34.1%","v":0.84099999999999997},{"$f":"INT($K$22+C4*$K$23)","v":52},1,{"$f":"INT(K$43+$C4*K$44)","v":2477},2391,2252,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"A4+13.6%","v":0.97699999999999998},{"$f":"INT($K$22+C5*$K$23)","v":55},2,2639,2519,2359,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"A5+2.1%","v":0.998},{"$f":"INT($K$22+C6*$K$23)","v":58},3,2801,2646,2465,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"количество суперциклов",{"$f":"COUNT(A15:A500)","v":300}]
[null,"проверка исполнения заказа",{"$f":"COUNTIF(OFFSET(C15,,,StatCount),\"<\"&OrderNew)","v":0},"должно быть 0 (значит заказ был выполнен при каждом суперцикле)"]
[]
[]
[]
[null,null,null,"Использовано исх.сырья, шт (изготовлено)"]
["№","Время выполнения, часов","Изготовлено, шт","Сырье1","Сырье2","Сырье3","Сырье4","Сырье5"]
[1,48,1522,2300,2200,2200]
[2,48,1510,2400,2300,2150]
[3,46,1500,2150,2300,2100]
[4,46,1515,2300,2050,1750]
[5,47,1512,2350,2050,2200]
[6,50,1514,2500,2000,2200,null,null,null,"Числовые характеристики массива Время выполнения","Значение",null,null,"№","Интервалы","Границы интервалов","Частота","Частота2"]
[7,48,1524,2350,2250,2150,null,null,null,"Количество",{"$f":"StatCount","v":300},null,null,1,{"$f":"K29","v":44.5},{"$f":"\"<\"&O21&\"]\"","v":"<44,5]"},{"$f":"FREQUENCY(Исходные_данные,O21:O38)","v":1},{"$f":"(N21=$K$30)*Q21","v":0}]
[8,45,1516,2250,2250,2150,null,null,null,"Среднее",{"$f":"AVERAGE(Исходные_данные)","v":48.853333333333332},null,null,2,{"$f":"O21+$K$28","v":45.5},{"$f":"\"(\"&O21&\"-\"&O22&\"]\"","v":"(44,5-45,5]"},63,0]
[9,46,1526,2300,2050,2000,null,null,null,"Стандартное отклонение",{"$f":"_xlfn.STDEV.S(Исходные_данные)","v":3.3510077686831488},{"$f":"K23/K22","v":6.8593226706123403E-2},null,3,46.5,{"$f":"\"(\"&O22&\"-\"&O23&\"]\"","v":"(45,5-46,5]"},22,0]
[10,54,1504,2500,2300,2200,null,null,null,"Минимальное",{"$f":"MIN(Исходные_данные)","v":44},{"$f":"K22-K23*3","v":38.800310027283885},null,4,47.5,"(46,5-47,5]",30,0]
[11,57,1542,2450,2350,2250,null,null,null,"Максимальное",{"$f":"MAX(Исходные_данные)","v":62},{"$f":"K22+K23*3","v":58.906356639382778},null,5,48.5,"(47,5-48,5]",41,41]
[12,45,1519,2050,2000,2000,null,null,null,"Число интервалов (карманов)",{"$f":"INT(SQRT(K21))+1","v":18},{"$f":"COUNT(N21:N38)","v":18},null,6,49.5,"(48,5-49,5]",30,0]
[13,51,1546,2550,2100,2200,null,null,null,"Ширина интервала (точная)",{"$f":"(K25-K24)/K26","v":1},null,null,7,50.5,"(49,5-50,5]",30,0]
[14,51,1513,2350,2300,2050,null,null,null,"Ширина интервала (приблизит)",{"$f":"MROUND(K27,10^INT(LOG10(ABS(K27))))","v":1},null,null,8,51.5,"(50,5-51,5]",25,0]
[15,50,1535,2400,2350,2200,null,null,null,"Начало 1-го интервала",{"$f":"K24+K28/2","v":44.5},null,null,9,52.5,"(51,5-52,5]",15,0]
[16,48,1520,2200,2200,1950,null,null,null,"Карман со средним",{"$f":"MATCH(K22,O21:O38)","v":5},null,null,10,53.5,"(52,5-53,5]",13,0]
[17,48,1545,2400,2300,1950,null,null,null,null,null,null,null,11,54.5,"(53,5-54,5]",10,0]
[18,49,1511,2450,2300,2200,null,null,null,null,null,null,null,12,55.5,"(54,5-55,5]",8,0]
[19,48,1518,2400,2400,2200,null,null,null,null,null,null,null,13,56.5,"(55,5-56,5]",4,0]
[20,51,1502,2350,2150,2200,null,null,null,null,null,null,null,14,57.5,"(56,5-57,5]",2,0]
[21,54,1520,2500,2300,2200,null,null,null,null,null,null,null,15,58.5,"(57,5-58,5]",4,0]
[22,49,1516,2250,2100,2050,null,null,null,null,null,null,null,16,59.5,"(58,5-59,5]",0,0]
[23,51,1536,2450,2300,2150,null,null,null,null,null,null,null,17,60.5,"(59,5-60,5]",0,0]
[24,53,1530,2450,2650,2250,null,null,null,null,null,null,null,18,61.5,{"$f":"\">\"&O37","v":">60,5"},1,0]
[25,46,1525,2100,2300,2000]
[26,45,1525,2250,2250,2150]
[27,45,1512,1850,2250,2000]
[28,45,1526,2250,2250,1950,null,null,null,"Числовые характеристики массива Использовано сырья",{"$f":"D14","v":"Сырье1"},{"$f":"E14","v":"Сырье2"},"Сырье3","Сырье4","Сырье5"]
[29,45,1520,2100,2250,2150,null,null,null,"Среднее",{"$f":"AVERAGE(OFFSET(D15,,,StatCount))","v":2316.3333333333335},{"$f":"AVERAGE(OFFSET(E15,,,StatCount))","v":2264.5},{"$f":"AVERAGE(OFFSET(F15,,,StatCount))","v":2146.6666666666665},{"$f":"AVERAGE(OFFSET(G15,,,StatCount))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(OFFSET(H15,,,StatCount))","v":{"$error":"#DIV/0!"}}]
[30,47,1512,2350,2100,2150,null,null,null,"Стандартное отклонение",{"$f":"_xlfn.STDEV.S(OFFSET(D15,,,StatCount))","v":161.56598480820671},{"$f":"_xlfn.STDEV.S(OFFSET(E15,,,StatCount))","v":127.41873926961001},{"$f":"_xlfn.STDEV.S(OFFSET(F15,,,StatCount))","v":106.19075828923333},{"$f":"_xlfn.STDEV.S(OFFSET(G15,,,StatCount))","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(OFFSET(H15,,,StatCount))","v":{"$error":"#DIV/0!"}}]
[31,45,1525,2250,2200,2200,null,null,null,"Минимальное",{"$f":"MIN(OFFSET(D15,,,StatCount))","v":1800},{"$f":"MIN(OFFSET(E15,,,StatCount))","v":1850},{"$f":"MIN(OFFSET(F15,,,StatCount))","v":1700},{"$f":"MIN(OFFSET(G15,,,StatCount))","v":0},{"$f":"MIN(OFFSET(H15,,,StatCount))","v":0}]
[32,45,1524,2250,2250,2200,null,null,null,"Максимальное",{"$f":"MAX(OFFSET(D15,,,StatCount))","v":2650},{"$f":"MAX(OFFSET(E15,,,StatCount))","v":2650},{"$f":"MAX(OFFSET(F15,,,StatCount))","v":2300},{"$f":"MAX(OFFSET(G15,,,StatCount))","v":0},{"$f":"MAX(OFFSET(H15,,,StatCount))","v":0}]
[33,45,1523,2250,2250,2200]
[34,46,1507,2100,2100,2250]
[35,53,1524,2500,2350,2200]
[36,46,1513,2100,1950,2100]
[37,45,1527,2150,2250,2000]
[38,45,1505,2250,2000,2200]
[39,51,1544,2300,2450,2300]
[40,45,1513,2050,2250,1950]
[41,45,1520,2100,2250,2100]
[42,52,1527,2400,2450,2250]
[43,50,1502,2500,2300,2050]
[44,48,1506,1900,2150,2050]
[45,53,1516,2450,2250,2200]
[46,49,1502,2100,2250,2000]
[47,49,1503,1950,2450,1700]
[48,48,1527,2400,2300,2200]
[49,45,1509,2000,2250,2000]
[50,48,1506,2400,2350,2200]
[51,55,1545,2350,2600,2000]
[52,48,1520,2000,2200,1950]
[53,56,1506,2400,2400,2200]
[54,45,1532,2250,2250,1900]
[55,45,1510,2250,2250,2200]
[56,45,1517,2050,2250,2000]
[57,50,1501,2500,2200,2200]
[58,50,1531,2250,2300,2200]
[59,50,1520,2350,2250,2000]
[60,53,1518,2500,2350,2200]
[61,48,1528,2400,2300,2250]
[62,49,1520,2350,1950,2200]
[63,49,1525,2350,2350,2050]
[64,50,1527,2500,2200,2150]
[65,50,1516,2250,2300,2150]
[66,48,1530,2150,2200,2200]
[67,54,1532,2500,2300,2200]
[68,46,1521,2250,2050,2200]
[69,58,1509,2600,2450,2300]
[70,51,1533,2400,2350,2150]
[71,47,1528,2350,2350,2100]
[72,45,1517,2250,2250,2200]
[73,45,1513,2250,2000,2100]
[74,58,1529,2450,2300,2050]
[75,50,1527,2300,2300,2000]
[76,45,1522,2100,2250,2200]
[77,50,1548,2500,2400,2250]
[78,51,1516,2500,2150,2200]
[79,51,1528,2300,2300,2200]
[80,56,1518,2400,2300,2200]
[81,45,1521,2250,2000,2150]
[82,56,1533,2450,2300,2250]
[83,58,1548,2550,2500,2250]
[84,45,1518,2250,2250,2150]
[85,49,1533,2450,2150,2250]
[86,51,1521,2300,2400,1950]
[87,45,1527,2250,2250,2200]
[88,48,1546,2400,2350,2200]
[89,45,1505,2250,2100,2150]
[90,45,1526,2050,2250,2000]
[91,47,1532,2200,2350,2200]
[92,50,1514,2300,2300,2150]
[93,47,1507,2300,2350,2250]
[94,52,1530,2200,2300,2200]
[95,51,1545,2400,2550,2300]
[96,54,1537,2550,2500,2000]
[97,48,1539,2200,2400,2200]
[98,48,1509,2400,2400,2200]
[99,50,1518,2500,2350,2200]
[100,45,1527,2050,2250,2200]
[101,47,1524,2350,2250,2200]
[102,47,1502,2250,2050,2150]
[103,47,1512,2200,2350,2150]
[104,52,1531,2600,2450,2250]
[105,52,1502,2150,2350,2200]
[106,47,1502,2350,2200,2200]
[107,48,1516,2400,2200,2250]
[108,49,1523,2450,2300,2150]
[109,45,1524,2250,2100,2200]
[110,47,1535,2350,2300,2200]
[111,53,1534,2300,2350,1950]
[112,45,1530,2250,2250,2150]
[113,48,1525,2400,2200,2200]
[114,52,1537,2600,2200,2300]
[115,45,1515,1800,2250,1950]
[116,45,1505,1800,2250,1950]
[117,46,1512,2300,2150,1950]
[118,47,1522,2150,2300,2100]
[119,53,1530,2500,2350,2200]
[120,47,1508,2150,2150,2150]
[121,45,1531,2250,2250,2200]
[122,51,1521,2500,2300,2200]
[123,45,1515,2000,2000,2150]
[124,45,1521,2050,2250,2150]
[125,47,1540,2200,2000,2200]
[126,48,1530,2250,2250,2150]
[127,45,1512,2250,2250,2200]
[128,46,1509,2300,2300,1950]
[129,49,1515,2200,2100,1950]
[130,48,1516,2400,2400,2200]
[131,48,1528,2250,2150,2200]
[132,55,1535,2550,2350,2250]
[133,53,1535,2000,2100,1950]
[134,45,1503,2250,2250,2200]
[135,45,1538,2050,2250,1950]
[136,49,1521,2450,2300,2200]
[137,50,1525,2350,2150,2050]
[138,52,1538,2500,2350,2250]
[139,49,1501,2300,2150,2200]
[140,51,1533,2200,2450,2000]
[141,45,1521,2250,2050,1950]
[142,48,1514,2350,2250,1850]
[143,45,1514,2250,2250,2150]
[144,54,1526,2500,2300,2200]
[145,48,1522,2350,2300,2200]
[146,49,1524,2450,2250,2200]
[147,48,1513,2400,2350,2200]
[148,61,1510,2450,2200,2150]
[149,54,1548,2500,2550,2300]
[150,45,1527,2250,2250,1900]
[151,48,1507,2150,2200,2050]
[152,47,1538,2350,2350,2200]
[153,45,1505,2250,2250,2150]
[154,51,1530,2400,2300,2250]
[155,49,1505,2450,2350,2250]
[156,47,1516,2200,2200,2200]
[157,45,1517,2250,2200,2200]
[158,52,1510,2500,2250,2150]
[159,53,1517,2550,2450,2250]
[160,48,1507,2400,1900,2050]
[161,47,1547,2350,2200,2250]
[162,49,1518,2450,2300,2250]
[163,50,1528,2300,2250,2100]
[164,48,1500,2250,1950,2250]
[165,45,1521,2250,2250,2200]
[166,52,1501,2350,2350,2200]
[167,48,1539,2400,2150,2250]
[168,45,1512,2250,2200,2100]
[169,50,1515,2500,2300,2200]
[170,47,1501,2200,2100,2150]
[171,47,1512,2350,2350,2150]
[172,50,1508,2250,2350,2200]
[173,53,1522,2400,2100,2150]
[174,52,1533,2400,2450,2100]
[175,51,1511,2400,2350,1850]
[176,62,1528,2550,2450,2300]
[177,50,1529,2250,2300,2200]
[178,53,1529,2550,2400,2250]
[179,50,1502,2450,2050,2200]
[180,51,1521,2500,2350,2200]
[181,55,1537,2350,2350,2200]
[182,54,1547,2650,2400,2300]
[183,50,1534,2500,2500,2300]
[184,45,1524,2100,2100,2100]
[185,45,1521,2250,2250,2000]
[186,50,1502,2500,2350,2250]
[187,45,1509,2000,2250,2100]
[188,46,1516,2050,2300,1950]
[189,45,1523,2250,2250,2000]
[190,46,1535,2300,2300,2200]
[191,51,1501,2400,2200,2050]
[192,49,1503,2450,2300,2200]
[193,51,1506,2500,2300,2200]
[194,48,1517,2400,2200,2200]
[195,48,1548,2000,2350,2150]
[196,51,1526,2300,2400,2200]
[197,58,1535,2550,2400,2200]
[198,51,1545,2550,2400,2300]
[199,45,1518,2250,2250,2150]
[200,46,1545,2300,2300,2200]
[201,45,1529,1950,2050,2050]
[202,49,1514,2150,2000,2050]
[203,46,1528,2300,2100,2200]
[204,55,1528,2550,2450,2250]
[205,49,1503,2000,2350,1950]
[206,45,1511,1900,2250,2050]
[207,47,1528,2150,2050,1900]
[208,53,1537,2550,2400,2250]
[209,50,1535,2200,2000,2250]
[210,45,1515,2050,2250,2200]
[211,50,1529,2450,2250,2200]
[212,50,1515,2500,2350,2100]
[213,48,1521,2200,2300,2200]
[214,47,1518,2350,2350,2100]
[215,46,1514,2300,2300,2050]
[216,50,1508,2500,2300,2200]
[217,55,1543,2550,2400,2250]
[218,48,1524,2400,2400,2250]
[219,47,1546,2350,2350,2150]
[220,47,1523,2350,2350,2200]
[221,50,1514,2500,2300,2150]
[222,47,1503,2350,1950,2150]
[223,45,1511,2250,2250,2000]
[224,49,1515,2250,2200,2050]
[225,52,1510,2450,2250,2100]
[226,49,1543,2250,2450,2200]
[227,46,1516,2300,2300,2250]
[228,45,1522,2100,2250,2050]
[229,48,1509,2400,2300,2200]
[230,47,1528,2250,2350,2100]
[231,47,1515,2350,2300,2200]
[232,52,1527,2350,2300,2250]
[233,45,1522,2050,2200,2200]
[234,49,1516,2450,2250,2300]
[235,45,1524,2250,2000,1900]
[236,52,1536,2550,2250,2200]
[237,45,1526,2250,2100,2200]
[238,45,1535,2250,2150,2100]
[239,45,1528,2250,2200,2200]
[240,49,1532,2300,2450,2200]
[241,50,1527,2350,2300,2200]
[242,52,1514,2500,2300,2200]
[243,53,1531,2250,2100,2150]
[244,49,1507,2450,2300,2200]
[245,49,1536,2250,2350,2200]
[246,46,1534,2300,2300,2250]
[247,49,1527,2450,2300,2200]
[248,45,1503,2250,2250,2200]
[249,46,1508,2150,2300,2200]
[250,51,1531,2550,2250,2050]
[251,45,1513,2250,2250,1950]
[252,48,1510,2150,2100,2250]
[253,52,1507,2500,2300,2200]
[254,48,1530,2400,2150,2200]
[255,45,1512,2000,2250,2100]
[256,50,1534,2500,2200,2250]
[257,51,1501,2500,2300,2200]
[258,54,1524,2200,2500,1950]
[259,50,1522,2500,2300,2100]
[260,47,1528,2050,2350,2200]
[261,52,1505,2500,2200,2150]
[262,55,1518,2500,2300,2200]
[263,51,1529,2550,2300,2250]
[264,54,1519,2250,2350,2200]
[265,51,1522,2400,2550,2300]
[266,51,1521,2350,2550,2250]
[267,50,1504,2350,2300,2200]
[268,47,1539,2350,2350,2150]
[269,50,1522,2500,2250,2250]
[270,45,1522,2250,2250,2100]
[271,48,1512,2400,2200,2200]
[272,47,1501,2350,2200,2200]
[273,46,1533,2300,2050,2100]
[274,49,1523,2050,2400,1950]
[275,49,1500,2450,2300,2200]
[276,49,1524,2450,2200,2200]
[277,46,1512,2050,2300,2000]
[278,48,1508,2300,2300,2200]
[279,44,1503,2050,2200,2000]
[280,48,1537,2400,2350,2200]
[281,49,1520,2300,2350,1950]
[282,53,1512,2250,2550,2300]
[283,46,1506,2300,1850,1900]
[284,48,1520,2400,2250,2200]
[285,57,1543,2550,2450,2250]
[286,56,1531,2550,2400,2200]
[287,46,1525,2300,2000,2100]
[288,54,1515,2500,2250,2250]
[289,48,1503,2350,2300,2150]
[290,48,1520,2400,2400,2200]
[291,47,1545,2150,2100,2050]
[292,55,1519,2600,2500,2300]
[293,46,1524,2300,2100,2200]
[294,51,1524,2500,2200,2200]
[295,47,1535,2150,2200,2000]
[296,55,1505,2550,2400,2250]
[297,49,1512,2450,2300,2150]
[298,45,1520,2250,2100,2200]
[299,49,1519,2300,2300,2250]
[300,48,1526,2000,2400,2050]

{"sheet":"Изготовлено","index":3,"n_rows":63,"n_cols":21,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Детализация работы оборудования"]
["Изготовленное количество (до разбраковки, т.е. до вычета бракованных)"]
[]
[]
[]
[]
[]
[]
[]
[]
["Кол-во рабочих часов, ч",{"$f":"COUNTIF(OFFSET(B16,,,ProdClear),\">\"&0)","v":43},42,41,38,40,41,43,48,43,40,0,0,0,0,0,0,0,0,0,0]
[]
["всего",{"$f":"SUM(OFFSET(B16,,,StatCount))","v":1718},1645,1590,1872,1534,2027,2138,2400,2150,2000,0,0,0,0,0,0,0,0,0,0]
[{"$f":"COUNTA(A16:A10006)","v":48}]
["Час","Изг. #1","Изг. #2","Изг. #3","Изг. #4","Изг. #5","Изг. #6","Изг. #7","Изг. #8","Изг. #9","Изг. #10","Изг. #11","Изг. #12","Изг. #13","Изг. #14","Изг. #15","Изг. #16","Изг. #17","Изг. #18","Изг. #19","Изг. #20"]
[1,0,0,0,0,0,0,0,50,50,50]
[2,0,0,0,0,0,49,47,50,50,50]
[3,40,0,0,46,0,49,48,50,50,50]
[4,40,38,0,47,0,49,50,50,50,50]
[5,40,39,38,50,0,50,49,50,50,50]
[6,40,39,38,49,38,50,50,50,50,50]
[7,40,40,39,49,38,50,50,50,50,50]
[8,40,39,37,49,39,48,49,50,50,50]
[9,40,40,39,48,36,49,49,50,50,50]
[10,40,40,39,48,38,48,49,50,0,50]
[11,40,40,40,49,39,0,49,50,0,50]
[12,40,40,38,49,40,0,49,50,0,50]
[13,38,39,40,49,37,0,50,50,0,50]
[14,0,38,39,49,40,0,49,50,0,50]
[15,0,0,38,48,39,0,50,50,50,50]
[16,0,0,0,50,37,49,50,50,50,50]
[17,40,0,0,50,0,49,0,50,50,50]
[18,40,39,0,0,0,50,0,50,50,50]
[19,40,40,39,0,0,50,0,50,50,50]
[20,40,40,40,0,39,50,0,50,50,50]
[21,40,40,40,0,40,50,50,50,50,0]
[22,40,40,39,50,40,49,50,50,50,50]
[23,40,40,40,48,39,50,50,50,50,50]
[24,40,38,39,49,40,50,50,50,50,50]
[25,40,40,38,49,39,49,50,50,50,50]
[26,40,40,40,48,38,49,50,50,50,50]
[27,40,39,40,48,39,49,50,50,50,50]
[28,40,39,39,0,40,49,50,50,50,0]
[29,40,40,39,0,37,50,50,50,50,0]
[30,40,40,40,0,39,48,50,50,50,0]
[31,40,38,40,0,40,50,50,50,50,0]
[32,40,40,37,50,39,49,50,50,50,50]
[33,40,38,40,50,37,50,50,50,50,50]
[34,40,38,38,50,40,50,50,50,50,50]
[35,40,39,38,50,38,49,50,50,50,50]
[36,40,39,38,50,37,50,50,50,50,50]
[37,40,38,38,50,37,50,50,50,50,50]
[38,40,39,37,50,38,49,50,50,50,50]
[39,40,38,39,50,36,48,50,50,50,50]
[40,40,40,38,50,38,50,50,50,50,50]
[41,40,40,39,50,38,50,50,50,50,50]
[42,40,37,40,50,37,49,50,50,50,50]
[43,40,40,36,50,40,50,50,50,50,50]
[44,40,38,40,50,36,50,50,50,50,50]
[45,40,40,38,50,39,0,50,50,50,0]
[46,40,39,40,50,38,50,50,50,50,0]
[47,40,38,38,50,39,50,50,50,50,0]
[48,40,39,38,50,36,50,50,50,50,50]

{"sheet":"Буфер","index":4,"n_rows":63,"n_cols":23,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Детализация работы оборудования"]
["Состояние буфера оборудования на конец часа"]
["Буфер оборудования: в него оборудование кладет изготовленный материал, а последующее оборудование - забирает"]
[]
[]
[]
[]
[]
["Макс",{"$f":"MAX(B16:B1016)","v":40},40,40,286,1517,291,245,249,99,268,0,0,0,0,0,0,0,0,0,0]
[{"$f":"COUNTA(A16:A10006)","v":48}]
["Конечное?",{"$f":"IF(AND(ISNUMBER(B16),OFFSET(Схема!$K$23,Буфер!B14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(C16),OFFSET(Схема!$K$23,Буфер!C14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D16),OFFSET(Схема!$K$23,Буфер!D14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E16),OFFSET(Схема!$K$23,Буфер!E14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(F16),OFFSET(Схема!$K$23,Буфер!F14,)=0),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(G16),OFFSET(Схема!$K$23,Буфер!G14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(H16),OFFSET(Схема!$K$23,Буфер!H14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I16),OFFSET(Схема!$K$23,Буфер!I14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J16),OFFSET(Схема!$K$23,Буфер!J14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(K16),OFFSET(Схема!$K$23,Буфер!K14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L16),OFFSET(Схема!$K$23,Буфер!L14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(M16),OFFSET(Схема!$K$23,Буфер!M14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(N16),OFFSET(Схема!$K$23,Буфер!N14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(O16),OFFSET(Схема!$K$23,Буфер!O14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(P16),OFFSET(Схема!$K$23,Буфер!P14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(Q16),OFFSET(Схема!$K$23,Буфер!Q14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(R16),OFFSET(Схема!$K$23,Буфер!R14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(S16),OFFSET(Схема!$K$23,Буфер!S14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(T16),OFFSET(Схема!$K$23,Буфер!T14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(U16),OFFSET(Схема!$K$23,Буфер!U14,)=0),TRUE,\"\")","v":""}]
["Сборка?",{"$f":"IF(AND(ISNUMBER(B16),OFFSET(Схема!$M$23,Буфер!B14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(C16),OFFSET(Схема!$M$23,Буфер!C14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D16),OFFSET(Схема!$M$23,Буфер!D14,)>1),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(E16),OFFSET(Схема!$M$23,Буфер!E14,)>1),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(F16),OFFSET(Схема!$M$23,Буфер!F14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(G16),OFFSET(Схема!$M$23,Буфер!G14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(H16),OFFSET(Схема!$M$23,Буфер!H14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I16),OFFSET(Схема!$M$23,Буфер!I14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J16),OFFSET(Схема!$M$23,Буфер!J14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(K16),OFFSET(Схема!$M$23,Буфер!K14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L16),OFFSET(Схема!$M$23,Буфер!L14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(M16),OFFSET(Схема!$M$23,Буфер!M14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(N16),OFFSET(Схема!$M$23,Буфер!N14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(O16),OFFSET(Схема!$M$23,Буфер!O14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(P16),OFFSET(Схема!$M$23,Буфер!P14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(Q16),OFFSET(Схема!$M$23,Буфер!Q14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(R16),OFFSET(Схема!$M$23,Буфер!R14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(S16),OFFSET(Схема!$M$23,Буфер!S14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(T16),OFFSET(Схема!$M$23,Буфер!T14,)>1),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(U16),OFFSET(Схема!$M$23,Буфер!U14,)>1),TRUE,\"\")","v":""}]
["Начальное?",{"$f":"IF(AND(ISNUMBER(B16),OFFSET(Схема!$M$23,Буфер!B14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(C16),OFFSET(Схема!$M$23,Буфер!C14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D16),OFFSET(Схема!$M$23,Буфер!D14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E16),OFFSET(Схема!$M$23,Буфер!E14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(F16),OFFSET(Схема!$M$23,Буфер!F14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(G16),OFFSET(Схема!$M$23,Буфер!G14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(H16),OFFSET(Схема!$M$23,Буфер!H14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I16),OFFSET(Схема!$M$23,Буфер!I14,)=0),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(J16),OFFSET(Схема!$M$23,Буфер!J14,)=0),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(K16),OFFSET(Схема!$M$23,Буфер!K14,)=0),TRUE,\"\")","v":true},{"$f":"IF(AND(ISNUMBER(L16),OFFSET(Схема!$M$23,Буфер!L14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(M16),OFFSET(Схема!$M$23,Буфер!M14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(N16),OFFSET(Схема!$M$23,Буфер!N14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(O16),OFFSET(Схема!$M$23,Буфер!O14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(P16),OFFSET(Схема!$M$23,Буфер!P14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(Q16),OFFSET(Схема!$M$23,Буфер!Q14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(R16),OFFSET(Схема!$M$23,Буфер!R14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(S16),OFFSET(Схема!$M$23,Буфер!S14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(T16),OFFSET(Схема!$M$23,Буфер!T14,)=0),TRUE,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(U16),OFFSET(Схема!$M$23,Буфер!U14,)=0),TRUE,\"\")","v":""},null,{"$f":"OFFSET(W15,BuffClear,,1)","v":1517}]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Час","Буфер #1","Буфер #2","Буфер #3","Буфер #4","Буфер #5","Буфер #6","Буфер #7","Буфер #8","Буфер #9","Буфер #10","Буфер #11","Буфер #12","Буфер #13","Буфер #14","Буфер #15","Буфер #16","Буфер #17","Буфер #18","Буфер #19","Буфер #20",null,"Готовая"]
[1,0,0,0,0,0,0,0,47,49,50,null,null,null,null,null,null,null,null,null,null,null,0]
[2,0,0,0,0,0,49,46,48,49,100,null,null,null,null,null,null,null,null,null,null,null,0]
[3,38,0,0,46,0,58,47,50,49,103,null,null,null,null,null,null,null,null,null,null,null,0]
[4,39,38,0,91,0,67,50,49,50,106,null,null,null,null,null,null,null,null,null,null,null,0]
[5,39,38,38,101,0,77,49,50,50,105,null,null,null,null,null,null,null,null,null,null,null,0]
[6,40,39,38,112,38,86,49,50,50,106,null,null,null,null,null,null,null,null,null,null,null,38]
[7,39,37,39,122,75,95,49,49,48,106,null,null,null,null,null,null,null,null,null,null,null,75]
[8,40,39,36,133,114,102,48,49,49,107,null,null,null,null,null,null,null,null,null,null,null,114]
[9,40,39,38,141,150,110,48,49,48,109,null,null,null,null,null,null,null,null,null,null,null,150]
[10,40,40,39,150,187,118,49,49,0,111,null,null,null,null,null,null,null,null,null,null,null,187]
[11,40,38,40,158,226,78,49,49,0,111,null,null,null,null,null,null,null,null,null,null,null,226]
[12,39,40,37,167,265,38,49,50,0,112,null,null,null,null,null,null,null,null,null,null,null,265]
[13,38,39,40,173,302,0,49,49,0,113,null,null,null,null,null,null,null,null,null,null,null,302]
[14,0,38,39,183,342,0,48,50,0,114,null,null,null,null,null,null,null,null,null,null,null,342]
[15,0,0,37,191,381,0,50,50,49,116,null,null,null,null,null,null,null,null,null,null,null,381]
[16,0,0,0,239,418,49,50,50,49,116,null,null,null,null,null,null,null,null,null,null,null,418]
[17,39,0,0,286,418,57,0,100,50,116,null,null,null,null,null,null,null,null,null,null,null,418]
[18,40,39,0,286,418,67,0,150,50,166,null,null,null,null,null,null,null,null,null,null,null,418]
[19,40,40,39,247,418,77,0,199,50,215,null,null,null,null,null,null,null,null,null,null,null,418]
[20,40,40,40,207,457,87,0,249,50,264,null,null,null,null,null,null,null,null,null,null,null,457]
[21,40,39,40,167,495,95,50,249,49,264,null,null,null,null,null,null,null,null,null,null,null,495]
[22,40,40,39,178,534,103,48,248,50,263,null,null,null,null,null,null,null,null,null,null,null,534]
[23,38,39,40,185,572,112,49,248,50,264,null,null,null,null,null,null,null,null,null,null,null,572]
[24,40,38,39,194,612,122,49,248,49,264,null,null,null,null,null,null,null,null,null,null,null,612]
[25,40,40,38,204,651,130,48,248,49,265,null,null,null,null,null,null,null,null,null,null,null,651]
[26,39,40,39,212,689,137,48,248,49,267,null,null,null,null,null,null,null,null,null,null,null,689]
[27,39,39,40,218,727,146,49,247,49,268,null,null,null,null,null,null,null,null,null,null,null,727]
[28,40,39,37,179,767,155,97,247,50,268,null,null,null,null,null,null,null,null,null,null,null,767]
[29,40,40,39,140,804,164,147,247,48,268,null,null,null,null,null,null,null,null,null,null,null,804]
[30,38,40,40,100,843,172,196,247,50,268,null,null,null,null,null,null,null,null,null,null,null,843]
[31,40,37,39,60,883,181,245,247,49,268,null,null,null,null,null,null,null,null,null,null,null,883]
[32,38,40,37,72,922,190,245,247,50,266,null,null,null,null,null,null,null,null,null,null,null,922]
[33,38,38,40,81,959,197,245,247,50,265,null,null,null,null,null,null,null,null,null,null,null,959]
[34,39,38,38,92,999,207,244,245,49,265,null,null,null,null,null,null,null,null,null,null,null,999]
[35,39,38,37,104,1036,214,244,245,50,265,null,null,null,null,null,null,null,null,null,null,null,1036]
[36,38,38,37,115,1073,222,244,245,50,265,null,null,null,null,null,null,null,null,null,null,null,1073]
[37,39,37,38,125,1110,228,241,244,49,265,null,null,null,null,null,null,null,null,null,null,null,1110]
[38,38,39,36,138,1147,237,239,244,48,265,null,null,null,null,null,null,null,null,null,null,null,1147]
[39,40,38,38,149,1182,245,239,244,50,265,null,null,null,null,null,null,null,null,null,null,null,1182]
[40,40,39,38,161,1219,255,239,244,50,265,null,null,null,null,null,null,null,null,null,null,null,1219]
[41,37,40,37,170,1256,264,237,244,49,264,null,null,null,null,null,null,null,null,null,null,null,1256]
[42,40,36,40,180,1293,272,236,243,50,263,null,null,null,null,null,null,null,null,null,null,null,1293]
[43,38,40,36,193,1332,281,236,243,50,261,null,null,null,null,null,null,null,null,null,null,null,1332]
[44,40,38,39,203,1368,291,236,243,49,261,null,null,null,null,null,null,null,null,null,null,null,1368]
[45,39,40,38,215,1407,251,235,242,99,211,null,null,null,null,null,null,null,null,null,null,null,1407]
[46,38,38,39,224,1443,261,235,240,99,161,null,null,null,null,null,null,null,null,null,null,null,1443]
[47,39,38,36,235,1481,271,234,240,99,111,null,null,null,null,null,null,null,null,null,null,null,1481]
[48,40,38,38,247,1517,280,234,240,99,111,null,null,null,null,null,null,null,null,null,null,null,1517]

{"sheet":"Брак","index":5,"n_rows":63,"n_cols":21,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Детализация работы оборудования"]
["Брак"]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTA(A16:A10006)","v":48}]
[]
["всего",{"$f":"SUM(OFFSET(B16,,,StatCount))","v":33},17,18,35,17,29,32,22,24,17,0,0,0,0,0,0,0,0,0,0]
[]
["Час","Брак #1","Брак #2","Брак #3","Брак #4","Брак #5","Брак #6","Брак #7","Брак #8","Брак #9","Брак #10","Брак #11","Брак #12","Брак #13","Брак #14","Брак #15","Брак #16","Брак #17","Брак #18","Брак #19","Брак #20"]
[1,0,0,0,0,0,0,0,3,1,0]
[2,0,0,0,0,0,0,1,2,1,0]
[3,2,0,0,0,0,0,1,0,1,1]
[4,1,0,0,2,0,0,0,1,0,0]
[5,1,1,0,2,0,0,0,0,0,1]
[6,0,0,0,0,0,1,1,0,0,0]
[7,1,3,0,0,1,1,1,1,2,1]
[8,0,0,1,1,0,1,1,1,1,0]
[9,0,1,1,1,0,1,1,1,2,0]
[10,0,0,0,0,1,0,0,1,0,0]
[11,0,2,0,1,0,0,0,1,0,1]
[12,1,0,1,2,1,0,0,0,0,0]
[13,0,0,0,3,0,0,1,1,0,0]
[14,0,0,0,0,0,0,1,0,0,0]
[15,0,0,1,2,0,0,0,0,1,0]
[16,0,0,0,2,0,0,0,0,1,0]
[17,1,0,0,3,0,1,0,0,0,0]
[18,0,0,0,0,0,0,0,0,0,0]
[19,0,0,0,0,0,0,0,1,0,1]
[20,0,0,0,0,0,0,0,0,0,1]
[21,0,1,0,0,2,2,0,0,1,0]
[22,0,0,0,0,1,1,2,1,0,1]
[23,2,1,0,1,1,1,1,0,0,1]
[24,0,0,0,1,0,0,1,0,1,1]
[25,0,0,0,1,0,1,2,0,1,0]
[26,1,0,1,0,0,2,2,0,1,0]
[27,1,0,0,2,1,0,1,1,1,1]
[28,0,0,2,0,0,0,2,0,0,0]
[29,0,0,0,0,0,1,0,0,2,0]
[30,2,0,0,0,0,0,1,0,0,0]
[31,0,1,1,0,0,1,1,0,1,0]
[32,2,0,0,1,0,0,0,0,0,2]
[33,2,0,0,1,0,3,0,0,0,1]
[34,1,0,0,1,0,0,1,2,1,0]
[35,1,1,1,0,1,2,0,0,0,0]
[36,2,1,1,1,0,2,0,0,0,0]
[37,1,1,0,2,0,4,3,1,1,0]
[38,2,0,1,0,1,0,2,0,2,0]
[39,0,0,1,0,1,0,0,0,0,0]
[40,0,1,0,0,1,0,0,0,0,0]
[41,3,0,2,2,1,1,2,0,1,1]
[42,0,1,0,0,0,1,1,1,0,1]
[43,2,0,0,1,1,1,0,0,0,2]
[44,0,0,1,0,0,0,0,0,1,0]
[45,1,0,0,0,0,0,1,1,0,0]
[46,2,1,1,1,2,0,0,2,0,0]
[47,1,0,2,1,1,0,1,0,0,0]
[48,0,1,0,0,0,1,0,0,0,0]

{"sheet":"Работа","index":6,"n_rows":63,"n_cols":21,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Детализация работы оборудования"]
["Состояние оборудования (ИСТИНА - работает, ЛОЖЬ - поломка)"]
[]
[]
[]
[]
[]
["суммируем сколько не было произведено из-за поломки (если даже буфер был пустой)"]
["всего потерь, шт",{"$f":"B13*IF(StandartEqSettingsFlag,Оборудование!$B$5,OFFSET(Оборудование!$B$19,Буфер!B14-1,,))","v":0},{"$f":"C13*OFFSET(Оборудование!$B$19,Буфер!C14-1,,)","v":0},{"$f":"D13*OFFSET(Оборудование!$B$19,Буфер!D14-1,,)","v":0},{"$f":"E13*OFFSET(Оборудование!$B$19,Буфер!E14-1,,)","v":200},{"$f":"F13*OFFSET(Оборудование!$B$19,Буфер!F14-1,,)","v":0},{"$f":"G13*OFFSET(Оборудование!$B$19,Буфер!G14-1,,)","v":0},{"$f":"H13*OFFSET(Оборудование!$B$19,Буфер!H14-1,,)","v":200},{"$f":"I13*OFFSET(Оборудование!$B$19,Буфер!I14-1,,)","v":0},{"$f":"J13*OFFSET(Оборудование!$B$19,Буфер!J14-1,,)","v":250},{"$f":"K13*OFFSET(Оборудование!$B$19,Буфер!K14-1,,)","v":150},{"$f":"L13*OFFSET(Оборудование!$B$19,Буфер!L14-1,,)","v":0},{"$f":"M13*OFFSET(Оборудование!$B$19,Буфер!M14-1,,)","v":0},{"$f":"N13*OFFSET(Оборудование!$B$19,Буфер!N14-1,,)","v":0},{"$f":"O13*OFFSET(Оборудование!$B$19,Буфер!O14-1,,)","v":0},{"$f":"P13*OFFSET(Оборудование!$B$19,Буфер!P14-1,,)","v":0},{"$f":"Q13*OFFSET(Оборудование!$B$19,Буфер!Q14-1,,)","v":0},{"$f":"R13*OFFSET(Оборудование!$B$19,Буфер!R14-1,,)","v":0},{"$f":"S13*OFFSET(Оборудование!$B$19,Буфер!S14-1,,)","v":0},{"$f":"T13*OFFSET(Оборудование!$B$19,Буфер!T14-1,,)","v":0},{"$f":"U13*OFFSET(Оборудование!$B$19,Буфер!U14-1,,)","v":0}]
[]
[{"$f":"COUNTA(A16:A10006)","v":48}]
[]
["всего простоев, ч",{"$f":"COUNTIF(OFFSET(B16,,,WorkClear),FALSE)","v":0},0,0,4,0,0,4,0,5,3,0,0,0,0,0,0,0,0,0,0]
[]
["Час","Работа #1","Работа #2","Работа #3","Работа #4","Работа #5","Работа #6","Работа #7","Работа #8","Работа #9","Работа #10","Работа #11","Работа #12","Работа #13","Работа #14","Работа #15","Работа #16","Работа #17","Работа #18","Работа #19","Работа #20"]
[1,true,true,true,true,true,true,true,true,true,true]
[2,true,true,true,true,true,true,true,true,true,true]
[3,true,true,true,true,true,true,true,true,true,true]
[4,true,true,true,true,true,true,true,true,true,true]
[5,true,true,true,true,true,true,true,true,true,true]
[6,true,true,true,true,true,true,true,true,true,true]
[7,true,true,true,true,true,true,true,true,true,true]
[8,true,true,true,true,true,true,true,true,true,true]
[9,true,true,true,true,true,true,true,true,true,true]
[10,true,true,true,true,true,true,true,true,false,true]
[11,true,true,true,true,true,true,true,true,false,true]
[12,true,true,true,true,true,true,true,true,false,true]
[13,true,true,true,true,true,true,true,true,false,true]
[14,true,true,true,true,true,true,true,true,false,true]
[15,true,true,true,true,true,true,true,true,true,true]
[16,true,true,true,true,true,true,true,true,true,true]
[17,true,true,true,true,true,true,false,true,true,true]
[18,true,true,true,true,true,true,false,true,true,true]
[19,true,true,true,true,true,true,false,true,true,true]
[20,true,true,true,true,true,true,false,true,true,true]
[21,true,true,true,true,true,true,true,true,true,true]
[22,true,true,true,true,true,true,true,true,true,true]
[23,true,true,true,true,true,true,true,true,true,true]
[24,true,true,true,true,true,true,true,true,true,true]
[25,true,true,true,true,true,true,true,true,true,true]
[26,true,true,true,true,true,true,true,true,true,true]
[27,true,true,true,true,true,true,true,true,true,true]
[28,true,true,true,false,true,true,true,true,true,true]
[29,true,true,true,false,true,true,true,true,true,true]
[30,true,true,true,false,true,true,true,true,true,true]
[31,true,true,true,false,true,true,true,true,true,true]
[32,true,true,true,true,true,true,true,true,true,true]
[33,true,true,true,true,true,true,true,true,true,true]
[34,true,true,true,true,true,true,true,true,true,true]
[35,true,true,true,true,true,true,true,true,true,true]
[36,true,true,true,true,true,true,true,true,true,true]
[37,true,true,true,true,true,true,true,true,true,true]
[38,true,true,true,true,true,true,true,true,true,true]
[39,true,true,true,true,true,true,true,true,true,true]
[40,true,true,true,true,true,true,true,true,true,true]
[41,true,true,true,true,true,true,true,true,true,true]
[42,true,true,true,true,true,true,true,true,true,true]
[43,true,true,true,true,true,true,true,true,true,true]
[44,true,true,true,true,true,true,true,true,true,true]
[45,true,true,true,true,true,true,true,true,true,false]
[46,true,true,true,true,true,true,true,true,true,false]
[47,true,true,true,true,true,true,true,true,true,false]
[48,true,true,true,true,true,true,true,true,true,true]

{"sheet":"Потери.ПустойБуфер","index":7,"n_rows":63,"n_cols":21,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Детализация работы оборудования"]
["Потери из-за пустого питающего буфера"]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTA(A16:A10006)","v":48}]
[]
["всего",{"$f":"SUM(OFFSET(B16,,,LossesBufferClear))","v":202},755,810,278,866,323,62,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Час","Брак #1","Брак #2","Брак #3","Брак #4","Брак #5","Брак #6","Брак #7","Брак #8","Брак #9","Брак #10","Брак #11","Брак #12","Брак #13","Брак #14","Брак #15","Брак #16","Брак #17","Брак #18","Брак #19","Брак #20"]
[1,40,50,50,50,50,50,50,0,0,0]
[2,40,50,50,50,50,1,3,0,0,0]
[3,0,50,50,4,50,1,2,0,0,0]
[4,0,12,50,3,50,1,0,0,0,0]
[5,0,11,12,0,50,0,1,0,0,0]
[6,0,11,12,1,12,0,0,0,0,0]
[7,0,10,11,1,12,0,0,0,0,0]
[8,0,11,13,1,11,2,1,0,0,0]
[9,0,10,11,2,14,1,1,0,0,0]
[10,0,10,11,2,12,2,1,0,0,0]
[11,0,10,10,1,11,50,1,0,0,0]
[12,0,10,12,1,10,50,1,0,0,0]
[13,2,11,10,1,13,50,0,0,0,0]
[14,40,12,11,1,10,50,1,0,0,0]
[15,40,50,12,2,11,50,0,0,0,0]
[16,40,50,50,0,13,1,0,0,0,0]
[17,0,50,50,0,50,1,0,0,0,0]
[18,0,11,50,0,50,0,0,0,0,0]
[19,0,10,11,50,50,0,0,0,0,0]
[20,0,10,10,50,11,0,0,0,0,0]
[21,0,10,10,50,10,0,0,0,0,0]
[22,0,10,11,0,10,1,0,0,0,0]
[23,0,10,10,2,11,0,0,0,0,0]
[24,0,12,11,1,10,0,0,0,0,0]
[25,0,10,12,1,11,1,0,0,0,0]
[26,0,10,10,2,12,1,0,0,0,0]
[27,0,11,10,2,11,1,0,0,0,0]
[28,0,11,11,0,10,1,0,0,0,0]
[29,0,10,11,0,13,0,0,0,0,0]
[30,0,10,10,0,11,2,0,0,0,0]
[31,0,12,10,0,10,0,0,0,0,0]
[32,0,10,13,0,11,1,0,0,0,0]
[33,0,12,10,0,13,0,0,0,0,0]
[34,0,12,12,0,10,0,0,0,0,0]
[35,0,11,12,0,12,1,0,0,0,0]
[36,0,11,12,0,13,0,0,0,0,0]
[37,0,12,12,0,13,0,0,0,0,0]
[38,0,11,13,0,12,1,0,0,0,0]
[39,0,12,11,0,14,2,0,0,0,0]
[40,0,10,12,0,12,0,0,0,0,0]
[41,0,10,11,0,12,0,0,0,0,0]
[42,0,13,10,0,13,1,0,0,0,0]
[43,0,10,14,0,10,0,0,0,0,0]
[44,0,12,10,0,14,0,0,0,0,0]
[45,0,10,12,0,11,0,0,0,0,0]
[46,0,11,10,0,12,0,0,0,0,0]
[47,0,12,12,0,11,0,0,0,0,0]
[48,0,11,12,0,14,0,0,0,0,0]

{"sheet":"EXCEL2.RU","index":8,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["EXCEL2.RU - профессиональные приемы для всех >>>"]
["Хорошая новость! Большинство задач, которые Вы хотите решить с помощью MS EXCEL – уже давно решены! \nНа нашем сайте Вы найдете решения множества из наиболее часто встречающихся задач. Сайт содержит более 500 качественно оформленных статей с файлами примеров."]
["Миссия нашего сайта - превратить Вашу работу в MS EXCEL в приятное времяпрепровождение и ускорить решение Ваших задач. Мы постоянно работаем над содержанием и оформлением нашего сайта и благодарим активных пользователей за поддержку и неоценимую помощь в нашей работе."]