{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["База данных проблем","8D","Обновленные документы (FMEA)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":35,"n_cols":24,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,1,30,2],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,16,3,16],[2,21,3,21],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,14,3,14],[2,15,3,15],[2,8,3,8],[2,9,3,9],[2,23,3,23],[2,10,2,11],[2,12,2,13],[2,17,2,18],[2,19,2,20],[2,22,3,22]]}
[]
[]
["№\nп/п","Дата возникновения","Тип проблемы (0 км, гарантия, внутренняя)","№ детали","Наименование","Дефект","Повторный да/нет",null,"Причина","Корректирующие мероприятия","Ответственный за ",null,"Срок проведения",null,"Результативность","Статус","Предупреждающие действия","Ответственный за",null,"Срок проведения",null,"Результативность","Статус","8D"]
[null,null,null,null,null,null,null,null,null,null,"Выполнение","Контроль","Начало","Окончание",null,null,null,"Выполнение","Контроль","Начало","Окончание"]
[1,"2013-03-29T10:00:00","КД",2,"БОЛТ","Пересорт болта",{"$f":"bdmk()","v":"нет"},{"$f":"k()","v":0},null,null,null,null,null,null,null,"К",null,null,null,null,null,null,null,"Ссылка"]
[{"$f":"A5+1","v":2},null,null,null,"НеКран","кран","нет",{"$f":"k()","v":0},null,null,null,null,null,null,null,"З",null,null,null,null,null,null,null,"code.docx"]
[{"$f":"A6+1","v":3},null,null,null,"НеКран","кран","да",{"$f":"k()","v":0.33333333333333331},null,null,null,null,null,null,null,"нп",null,null,null,null,null,null,null,"model_3_02_06_14.xls"]
[4,null,null,null,"НеКран","столб","нет",0,null,null,null,null,null,null,null,"Ж"]
[5,null,null,null,"НеКран","столб","да",{"$f":"k()","v":0.2}]
[6,null,null,null,"Кран","кран","нет",0]
[7,null,null,null,"НеКран","кран","да",{"$f":"k()","v":0.2857142857142857}]
[8,null,null,null,"Кран","кран","нет",0.125]
[9,null,null,null,"Кран","столб","нет",{"$f":"k()","v":0}]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[]
[]
[]
[]
[]
[null,null,null,null,null,3,{"$f":"IF(F28>2,\"да\",\"нет\")","v":"да"}]
[null,null,null,null,null,{"$f":"COUNTIF(F5:F6,F7)","v":1}]
[null,null,null,null,null,{"$f":"COUNTIF(E5:F5,E6:F6)","v":0}]
[null,"Статус "]
[null,"К","Требуется, но не начато"]
[null,"Ж","Начато, но не завершено",null,null,"Коэффициент повторяемости",null,null,null,{"$f":"2/7*100","v":28.571428571428569}]
[null,"З","Выполнено",null,null,{"$f":"COUNTIFS(G5:G26,\"да\")/COUNTA(G5:G26)","v":{"$error":"#NAME?"}}]
[null,"НП","Не применимо"]

{"sheet":"8D","index":1,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[19,12,20,12],[19,9,20,9],[23,11,24,11],[23,12,24,12],[19,10,20,10],[23,7,24,7],[21,8,22,8],[23,8,24,8],[23,10,24,10],[23,9,24,9],[21,9,22,9],[23,13,24,13],[19,13,20,13],[21,7,22,7],[21,10,22,10],[21,11,22,11],[19,8,20,8],[21,13,22,13],[19,7,20,7],[21,12,22,12],[19,11,20,11],[23,1,24,1],[19,6,20,6],[21,6,22,6],[23,6,24,6],[23,2,24,2],[19,2,20,2],[21,2,22,2],[21,1,22,1],[19,1,20,1],[1,1,3,1],[1,3,3,3],[2,10,2,11],[15,7,16,7],[15,9,15,13],[17,9,18,9],[17,10,18,10],[17,7,18,7],[15,8,16,8],[15,6,16,6],[15,1,16,1],[15,3,15,5],[15,2,16,2],[17,1,18,1],[17,2,18,2],[17,13,18,13],[17,11,18,11],[17,12,18,12],[17,8,18,8],[17,6,18,6],[1,15,2,19],[1,14,3,14],[1,4,1,13],[2,4,2,5],[2,7,2,8],[2,13,3,13],[2,9,3,9],[2,12,3,12],[2,6,3,6]]}
[]
[null,"№ 8D",null,"Дата открытия 8D","Этапы (сроки)/статус",null,null,null,null,null,null,null,null,null,"8D","Обновление документов"]
[null,null,null,null,"1-4 (48 часов)",null,"Статус"," 5 и 6 (10 дней)",null,"Статус","7 и 8 (30 дней)",null,"Статус","Результативность по истечению 3-х месяцев"]
[null,null,null,null,"Начало","Окончание",null,"Начало","Окончание",null,"Начало","Окончание",null,null,null,"DFMEA","PFMEA","РИ","Чертежи","Другое"]
[null,123,null,{"$f":"TODAY()","v":"2014-07-15"},null,null,null,null,null,null,null,null,null,null,"ссылка",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"№ 8D","Дата открытия","Шаги 8D  план/факт",null,null,"Статус","№ 8D","Результативность по истечению 3-х месяцев","Обновить"]
[null,null,null,"1-4 (48 часов)"," 5 и 6 (10 дней)","7 и 8 (30 дней)"]
[null,123,{"$f":"TODAY()","v":"2014-07-15"},{"$f":"C18+2","v":"2014-07-17"},{"$f":"C18+10","v":"2014-07-25"},{"$f":"C18+30","v":"2014-08-14"},null,"ссылка"]
[null,null,null,"2011-04-28","2011-05-06"]
[null,124]
[]
[null,125]
[]
[null,126]

{"sheet":"Обновленные документы (FMEA)","index":2,"n_rows":29,"n_cols":20,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,4,3,4],[2,8,3,8],[2,15,3,15],[28,2,28,3],[2,13,2,14],[24,1,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[2,17,2,18],[2,19,3,19],[2,1,2,2],[2,3,3,3],[2,5,2,6],[2,7,3,7],[2,11,3,11],[2,12,3,12],[2,9,2,10],[2,16,3,16]]}
[]
[]
["№ PFMEA","Срок проведения",null,"Статус","№ КПП","Срок проведения",null,"Статус","№ ПУ","Срок проведения",null,"Статус","№ РИ","Срок проведения",null,"Статус","№ DFMEA","Срок проведения",null,"Статус"]
[null,"План","Факт",null,null,"План","Факт",null,null,"План","Факт",null,null,"План","Факт",null,null,"План","Факт"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Статус "]
[null,"К","Требуется, но не начато"]
[null,"Ж","Начато, но не завершено"]
[null,"З","Выполнено"]
[null,"НП","Не применимо"]