{"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":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":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["№КД","Название","кол-во","дата","ответств.","статус","служебн.1","служебн.2","служебн.3","служебн.4","служебн.5",null,"kod","kod_z","im","kol","srok","men","sts","zv"]
[15457,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":{"$error":"#N/A"}},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":{"$error":"#N/A"}},null,null,null,15458,1245,"Изделие 1",12,"2015-08-25","Иванов","архив",2]
[15458,"Изделие 1",12,"2015-08-25","Иванов","архив",1245,2,24,null,null,null,15459,1246,"Изделие 2",45,"2015-08-25","Петров","архив",4]
[15459,"Изделие 2",45,"2015-08-25","Петров","архив",1246,4,180,null,null,null,15460,1247,"Изделие 3",48,"2016-08-25","Сидоров","архив",65]
[15460,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 3"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":48},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-08-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Сидоров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"архив"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1247},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":65},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":3120},null,null,null,15461,1248,"Изделие 4",54,"2016-08-25","Иванов","архив",3]
[15461,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 4"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":54},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-08-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Иванов"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"архив"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1248},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":3},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":162},null,null,null,15462,1249,"Изделие 5",321,"2016-08-25","Петров","архив",454]
[15462,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 5"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":321},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-08-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Петров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"архив"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1249},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":454},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":145734},null,null,null,15463,1250,"Изделие 6",546,"2016-09-25","Сидоров","в работе",6]
[15463,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 6"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":546},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-09-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Сидоров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"в работе"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1250},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":6},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":3276},null,null,null,15464,1251,"Изделие 7",54,"2015-09-25","Иванов","архив",2]
[15464,"Изделие 7",54,"2015-09-25","Иванов","архив",1251,2,108,null,null,null,15465,1252,"Изделие 8",51,"2015-08-25","Петров","в работе",54]
[15465,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 8"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":51},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2015-08-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Петров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"в работе"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1252},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":54},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":2754},null,null,null,15466,1253,"Изделие 9",25,"2016-08-25","Сидоров","архив",2]
[15466,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 9"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":25},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-08-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Сидоров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"архив"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1253},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":2},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":50},null,null,null,15467,1254,"Изделие 10",5,"2016-09-25","Иванов","в работе",5]
[15467,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 10"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":5},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-09-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Иванов"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"в работе"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1254},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":5},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":25},null,null,null,15468,1255,"Изделие 11",25454,"2016-09-25","Петров","архив",45]
[15468,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 11"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":25454},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-09-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Петров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"архив"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1255},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":45},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":1145430},null,null,null,15469,1256,"Изделие 12",21,"2016-09-25","Сидоров","в работе",45]
[15469,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 12"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":21},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-09-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Сидоров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"в работе"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1256},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":45},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":945},null,null,null,15470,1257,"Изделие 13",545,"2016-09-25","Иванов","в работе",23]
[15470,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 13"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":545},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-09-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Иванов"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"в работе"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1257},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":23},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":12535},null,null,null,15471,1258,"Изделие 14",5515,"2016-11-25","Петров","архив",56]
[15471,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 14"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":5515},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-11-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Петров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"архив"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1258},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":56},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":308840},null,null,null,15472,1259,"Изделие 15",2212,"2016-08-25","Сидоров","план",2]
[15472,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 15"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":2212},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-08-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Сидоров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"план"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1259},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":2},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":4424},null,null,null,15473,1260,"Изделие 16",63,"2016-11-25","Иванов","в работе",5]
[15473,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 16"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":63},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-11-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Иванов"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"в работе"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1260},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":5},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":315},null,null,null,15474,1261,"Изделие 17",54,"2016-08-25","Петров","план",4]
[15474,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 17"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":54},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-08-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Петров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"план"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1261},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":4},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":216},null,null,null,15475,1262,"Изделие 18",1,"2016-11-25","Сидоров","план",54]
[15475,{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],3,0)","v":"Изделие 18"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],4,0)","v":1},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],5,0)","v":"2016-11-25"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],6,0)","v":"Сидоров"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],7,0)","v":"план"},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],2,0)","v":1262},{"$f":"VLOOKUP(Рабочая[[#This Row],[№КД]],изБД[],8,0)","v":54},{"$f":"Рабочая[[#This Row],[кол-во]]*Рабочая[[#This Row],[служебн.2]]","v":54}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Данные из БД"]
[]
[]
[]
[]
[null,"30 сентября в текстовый/числовой вид должны перейти только синие строки."]
[null,"Условие: статус АРХИВ и дата БОЛЕЕ месяца от сегодня"]

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

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