{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CTRL-SCE-B","учёт_SCE","таблица шкафов_(База)_SCE"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":2,"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":"CTRL-SCE-B","index":0,"n_rows":55,"n_cols":29,"rows_kept":55,"cut":false,"hidden":false,"merged":[[17,12,21,20],[22,12,26,13],[22,18,27,20],[26,14,26,17],[14,6,14,14],[22,14,25,17],[2,7,2,17],[6,7,7,24],[4,7,4,17],[3,15,3,17],[3,8,3,14],[5,7,5,17],[4,18,5,19],[3,18,3,20],[8,3,8,17],[9,3,9,6],[9,7,9,10],[10,6,10,14],[13,6,13,14],[11,6,11,14]]}
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[2]
[3,null,"Заказ пр-ва",null,null,null,null,{"$f":"MID(D9,8,8)","v":"21800002"}]
[4,null,"Дата",null,null,null,null,null,{"$f":" TODAY()","v":"2019-01-21"},null,null,null,null,null,null,{"$f":"NOW()","v":43486.428792708335},null,null,{"$f":"SUM('таблица шкафов_(База)_SCE'!S11:S12)","v":43486.460042708335}]
[5,null,"Артикул",null,null,null,null,{"$f":"MID(D9,16,8)","v":"2785242"},null,null,null,null,null,null,null,null,null,null,{"$f":"MID(H7,14,1)","v":"3"}]
[6,null,"Серийный №",null,null,null,null,250088728]
[7,null,null,null,null,null,null,{"$f":"HYPERLINK('таблица шкафов_(База)_SCE'!D2)","v":"W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU"}]
[8,null,"Модель шк. (АРТ)"]
[9,null,null,"5720001218000022785242"]
[10]
[11,null,"Сборка",null,null,null,{"$f":"HYPERLINK('таблица шкафов_(База)_SCE'!U4)","v":"Никитин А."}]
[12,null,null,null,null,null,900]
[13]
[14,null,"Проверка",null,null,null,{"$f":"HYPERLINK('таблица шкафов_(База)_SCE'!W5)","v":"Кириллов В."}]
[15,null,null,null,null,null,111]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,"Записать\nв таблицу\nучёта"]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]

{"sheet":"учёт_SCE","index":1,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["зак/произ","Дата","серийный №","Артикул","Модель","Кол/н","Сборка","тест","Время","оконч."]
[]
[null,null,null,null,null,null,null,null,null,null,"Апрель"]
[1,"2018-04-02",250067664,2785249,{"$f":"VLOOKUP(D4,'[1]таблица шкафов_(База)_SCE'!C4:G300,2)","v":"W-CTRL-SCE-B-2x16A-T4-FM-ND2-RU"},{"$f":"MID(E4,14,1)","v":"2"},null,"Кириллов.В",null,null,{"$f":"SUMPRODUCT(--(TEXT($B4:$B31,\"ММММ\")=K3))","v":22}]
[2,"2018-04-03",250066869,2785241,{"$f":"VLOOKUP(D5,'[1]таблица шкафов_(База)_SCE'!C5:G301,2)","v":"W-CTRL-SCE-B-2x10A-T4-FM-ND2-RU"},{"$f":"MID(E5,14,1)","v":"2"},null,"Кириллов.В"]
[3,"2018-04-04",250067801,2785246,{"$f":"VLOOKUP(D6,'[1]таблица шкафов_(База)_SCE'!C6:G302,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},{"$f":"MID(E6,14,1)","v":"3"},"Старостин.П.Д.","Кириллов.В"]
[4,"2018-04-05",250066871,2785241,{"$f":"VLOOKUP(D7,'[1]таблица шкафов_(База)_SCE'!C7:G303,2)","v":"W-CTRL-SCE-B-2x10A-T4-FM-ND2-RU"},"2",null,"Кириллов.В"]
[5,"2018-04-06",250066870,2785241,{"$f":"VLOOKUP(D8,'[1]таблица шкафов_(База)_SCE'!C8:G304,2)","v":"W-CTRL-SCE-B-2x10A-T4-FM-ND2-RU"},"2",null,"Кириллов.В"]
[6,"2018-04-06",250066868,2785241,{"$f":"VLOOKUP(D9,'[1]таблица шкафов_(База)_SCE'!C9:G305,2)","v":"W-CTRL-SCE-B-2x10A-T4-FM-ND2-RU"},"2",null,"Кириллов.В"]
[7,"2018-04-06",250066867,2785241,{"$f":"VLOOKUP(D10,'[1]таблица шкафов_(База)_SCE'!C10:G306,2)","v":"W-CTRL-SCE-B-2x10A-T4-FM-ND2-RU"},"2",null,"Кириллов.В"]
[1,"2018-04-09",250067454,2785246,{"$f":"VLOOKUP(D11,'[1]таблица шкафов_(База)_SCE'!C11:G307,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3",null,"Кириллов.В"]
[2,"2018-04-16",250067596,2785246,{"$f":"VLOOKUP(D12,'[1]таблица шкафов_(База)_SCE'!C12:G308,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3","Попов.Д","Кириллов.В"]
[3,"2018-04-16",250067876,2785246,{"$f":"VLOOKUP(D13,'[1]таблица шкафов_(База)_SCE'!C13:G309,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3","Попов.Д","Кириллов.В"]
[4,"2018-04-18",250067875,2785246,{"$f":"VLOOKUP(D14,'[1]таблица шкафов_(База)_SCE'!C14:G310,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3","Попов.Д","Кириллов.В"]
[5,"2018-04-18",250067874,2785246,{"$f":"VLOOKUP(D15,'[1]таблица шкафов_(База)_SCE'!C15:G311,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3","Попов.Д","Кириллов.В"]
[6,"2018-04-18",250068869,2785246,{"$f":"VLOOKUP(D16,'[1]таблица шкафов_(База)_SCE'!C16:G312,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3","Старостин.П.Д.","Кириллов.В"]
[7,"2018-04-19",250068868,2785246,{"$f":"VLOOKUP(D17,'[1]таблица шкафов_(База)_SCE'!C17:G313,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3","Старостин.П.Д.","Кириллов.В"]
[8,"2018-04-19",250068900,2785242,{"$f":"VLOOKUP(D18,'[1]таблица шкафов_(База)_SCE'!C18:G314,2)","v":"W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU"},"3","Старостин.П.Д.","Кириллов.В"]
[9,"2018-04-20",250069184,2785199,{"$f":"VLOOKUP(D19,'[1]таблица шкафов_(База)_SCE'!C19:G315,2)","v":"W-CTRL-SCE-B-2x13A-T4-FM-ND2-RU"},"2","Старостин.П.Д.","Кириллов.В"]
[10,"2018-04-20",250069197,2785242,{"$f":"VLOOKUP(D20,'[1]таблица шкафов_(База)_SCE'!C20:G316,2)","v":"W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU"},"3","Кириллов.В","Кириллов.В"]
[1,"2018-04-23",250069744,2785199,{"$f":"VLOOKUP(D21,'[1]таблица шкафов_(База)_SCE'!C21:G317,2)","v":"W-CTRL-SCE-B-2x13A-T4-FM-ND2-RU"},"2","Старостин.П.Д.","Кириллов.В"]
[2,"2018-04-24",250068872,2785246,{"$f":"VLOOKUP(D22,'[1]таблица шкафов_(База)_SCE'!C22:G318,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3","Старостин.П.Д.","Кириллов.В"]
[3,"2018-04-24",250069193,2785246,{"$f":"VLOOKUP(D23,'[1]таблица шкафов_(База)_SCE'!C23:G319,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3","Старостин.П.Д.","Кириллов.В"]
[4,"2018-04-25",250070053,2785199,{"$f":"VLOOKUP(D24,'[1]таблица шкафов_(База)_SCE'!C24:G320,2)","v":"W-CTRL-SCE-B-2x13A-T4-FM-ND2-RU"},"2","Старостин.П.Д.","Кириллов.В"]
[5,"2018-04-26",250069189,2785242,{"$f":"VLOOKUP(D25,'[1]таблица шкафов_(База)_SCE'!C25:G321,2)","v":"W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU"},"3","Старостин.П.Д.","Кириллов.В",null,null,null,null,null,null,null,null,{"$f":"SUM(Q27:Q31)","v":28},{"$f":"SUM(R27:R31)","v":11},{"$f":"SUM(S27:S31)","v":17},{"$f":"SUM(T27:T31)","v":0},{"$f":"SUM(P31:P430)","v":0},{"$f":"SUM(Q32:Q430)","v":0}]
[1,"2018-05-07",250069199,2785246,{"$f":"VLOOKUP(D26,'[1]таблица шкафов_(База)_SCE'!C26:G322,2)","v":"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU"},"3","Попов.Д","Горбанёв.Н",null,null,null,null,null,null,null,null,2018,"2 НАС","3 НАС","4 НАС",2019,2020]
[2,"2018-05-07",250070408,2785199,{"$f":"VLOOKUP(D27,'[1]таблица шкафов_(База)_SCE'!C27:G323,2)","v":"W-CTRL-SCE-B-2x13A-T4-FM-ND2-RU"},"2","Попов.Д","Горбанёв.Н",null,null,null,null,null,null,null,"январь",{"$f":"COUNT(D431:D451)","v":0}]
[3,"2018-05-07",250070055,2785250,{"$f":"VLOOKUP(D28,'[1]таблица шкафов_(База)_SCE'!C28:G324,2)","v":"W-CTRL-SCE-B-3x16A-T4-FM-ND2-RU"},"3","Старостин.П.Д.","Горбанёв.Н",null,null,null,null,null,null,null,"февраль",{"$f":"COUNT(E452:E489)","v":0}]
[4,"2018-05-08",250069187,2785242,{"$f":"VLOOKUP(D29,'[1]таблица шкафов_(База)_SCE'!C29:G325,2)","v":"W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU"},"3","Попов.Д","Горбанёв.Н",null,null,null,null,null,null,null,"март",{"$f":"COUNT(F490:F518)","v":0}]
[5,"2018-05-08",250069763,2785241,{"$f":"VLOOKUP(D30,'[1]таблица шкафов_(База)_SCE'!C30:G326,2)","v":"W-CTRL-SCE-B-2x10A-T4-FM-ND2-RU"},"2","Старостин.П.Д.","Горбанёв.Н",null,null,null,null,null,null,null,"апрель",{"$f":"COUNT(C4:C25)","v":22},{"$f":"COUNTIF($F$4:$F$25,2)","v":9},{"$f":"COUNTIF($F$4:$F$25,3)","v":13},{"$f":"COUNTIF($F$4:$F$25,4)","v":0}]
[6,"2018-05-08",250069191,2785242,{"$f":"VLOOKUP(D31,'[1]таблица шкафов_(База)_SCE'!C31:G327,2)","v":"W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU"},"3","Попов.Д","Горбанёв.Н",null,null,{"$f":"COUNT(D27:D31)","v":5},null,null,null,null,"май",{"$f":"COUNT(C26:C31)","v":6},{"$f":"COUNTIF($F$26:$F$31,2)","v":2},{"$f":"COUNTIF($F$26:$F$31,3)","v":4},{"$f":"COUNTIF($F$26:$F$31,4)","v":0}]
["21779023","2019-01-15",250088111,"2785241","W-CTRL-SCE-B-2x10A-T4-FM-ND2-RU","2","Никитин А.","Кириллов В.",43480.678414351853,43480.740914351853]
["21779028","2019-01-16",250088116,"2785247","W-CTRL-SCE-B-4x13A-T4-FM-ND2-RU","4","Левыкин В.","Кириллов В.",43481.583564814813,43481.618287037039]
["21779027","2019-01-16",250088115,"2785247","W-CTRL-SCE-B-4x13A-T4-FM-ND2-RU","4","Никитин А.","Кириллов В.",43481.634710648148,43481.665960648148]
["21789379","2019-01-17",250088311,"2785242","W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU","3","Никитин А.","Кириллов В.",43482.451777199072,43482.479555787038]
["21779074","2019-01-17",250088169,"2785249","W-CTRL-SCE-B-2x16A-T4-FM-ND2-RU","2","Никитин А.","Кириллов В.",43482.657954861112,43482.682261111113]
["21789378","2019-01-18",250088310,"2785199","W-CTRL-SCE-B-2x13A-T4-FM-ND2-RU","2","Никитин А.","Кириллов В.",43483.464110185188,43483.491888657409,"v1.31"]
["21800002","2019-01-21",250088728,"2785242","W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU","3","Никитин А.","Кириллов В.",43486.338461689818,43486.369712268519,"v1.31"]
[]
[]
[]
[]
[null,null,null,null,"На главной (1 стр), заполняются 4 графы, в нашем случаи сканером штрих кода.И при нажатии на квадрат с надписью (записать в таблицу учёта),производится уопирование на 2й лист(учёт SCE)\nкопирование происходит с помощью маленького макроса, который мне тут и дали.\nа вопрос в следущем, таких файлов, много но они разделины по разным тематикам.Кака зделать чтоб ,помимо того что данные капирует на другой лист, он одновременно копировал в другой файл, где будут собиратся все модели, так сказать с каждого подобного файлика?"]

{"sheet":"таблица шкафов_(База)_SCE","index":2,"n_rows":52,"n_cols":24,"rows_kept":52,"cut":false,"hidden":false,"merged":[[18,20,18,23],[1,7,2,7],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,11,2,11],[16,15,17,15],[1,12,2,12],[10,18,11,18],[1,8,2,8],[1,9,2,9]]}
[null,null,{"$f":"HYPERLINK('CTRL-SCE-B'!H5)","v":"2785242"},{"$f":"SUM('CTRL-SCE-B'!D9:R9)","v":0},"кол-нас","вр","KW/A",null,"№","willo_OEM_V2.19_5_p,"]
[null,null,{"$f":"C1*1","v":2785242},{"$f":"VLOOKUP('таблица шкафов_(База)_SCE'!C2,C4:E51,2)","v":"W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU"},{"$f":"VLOOKUP(C2,C4:E51,3,)","v":3},{"$f":"VLOOKUP('таблица шкафов_(База)_SCE'!C2,C4:M51,4)","v":45},{"$f":"VLOOKUP(E2,E4:G34,3,)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F2,F4:H34,3,)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G2,G4:I34,3,)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C2,C4:L35,8)","v":0},null,null,{"$f":"F2/1440","v":"00:45:00"},2018,"2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('таблица шкафов_(База)_SCE'!N4:N51,N4)","v":28},{"$f":"SUM('таблица шкафов_(База)_SCE'!O4:O51,O4)","v":7}]
[null,1,2785100,"ОБНОВИТЬ БАЗУ",null,{"$f":"IF(ISERR(MID(D4,FIND(\"(\",D4),FIND(\")\",D4)-FIND(\"(\",D4)+1)),\"\",MID(D4,FIND(\"(\",D4),FIND(\")\",D4)-FIND(\"(\",D4)+1))","v":""},null,null,{"$f":"MID(D4,15,1)","v":""},null,null,null,{"$f":"F4/1440","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C4)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C4)","v":0},null,null,null,2,{"$f":"SUM(T13+0)","v":900},{"$f":"VLOOKUP(T4,T6:U12,2)","v":"Никитин А."}]
[null,2,2785101,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$f":"F5/1440","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C5)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C5)","v":0},null,null,null,null,null,null,{"$f":"SUM(V14+0)","v":111},{"$f":"VLOOKUP(V5,V6:W12,2)","v":"Кириллов В."}]
[null,3,2785102,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C6)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C6)","v":0},null,null,null,1,111,"Кириллов В.",111,"Кириллов В."]
[null,4,2785103,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C7)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C7)","v":0},null,null,null,4,222,"Двойченков А.",222,"Двойченков А."]
[null,5,2785104,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C8)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C8)","v":0},null,null,null,5,333,"Горбанёв Н.",333,"Горбанёв Н."]
[null,6,2785105,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C9)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C9)","v":0},null,null,null,3,444,"Левыкин В.",444,"Левыкин В."]
[null,7,2785106,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C10)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C10)","v":0},null,null,null,6,555,"Старостин П.",555,"Старостин П."]
[null,8,2785107,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C11)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C11)","v":0},null,null,null,{"$f":"SUM('CTRL-SCE-B'!P4:R4,M2)","v":43486.460042708335},600,"Попов Д.",600,"Попов Д."]
[null,9,2785108,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C12)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C12)","v":0},null,null,null,null,900,"Никитин А.",900,"Оператор"]
[null,10,2785109,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C13)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C13)","v":0},null,null,null,null,{"$f":"HYPERLINK('CTRL-SCE-B'!G12)","v":"900"},"сборка"]
[null,11,2785110,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C14)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C14)","v":0},null,null,null,null,900,null,{"$f":"HYPERLINK('CTRL-SCE-B'!G15)","v":"111"},"проверка"]
[null,12,2785111,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C15)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C15)","v":0},null,null,null,null,null,null,900]
[null,13,2785112,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C16)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C16)","v":0}]
[null,14,2785113,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C17)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C17)","v":0},null,null,null,null,null,"Сирош А"]
[null,15,2785114,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C18)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C18)","v":0}]
[null,16,2785115,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C19)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C19)","v":0},null,null,null,null,null,"статискика сборки шкафов SCE"]
[null,17,2785116,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C20)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C20)","v":0},null,null,null,null,null,null,2018,2019,2020]
[null,18,2785117,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C21)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C21)","v":0},null,null,null,null,null,"Январь",{"$f":"SUMPRODUCT(--(TEXT($C2:$C35,\"ММММ\")=F1))","v":0},{"$f":"COUNT(учёт_SCE!C32:C41)","v":7},0]
[null,19,2785118,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C22)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C22)","v":0},null,null,null,null,null,"Февраль",null,{"$f":"COUNT(учёт_SCE!C42:C72)","v":0},0]
[null,20,2785119,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C23)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C23)","v":0},null,null,null,null,null,"Март",null,{"$f":"COUNT(учёт_SCE!C73:C103)","v":0},0]
[null,21,2785120,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C24)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C24)","v":0},null,null,null,null,null,"Апрель",{"$f":"COUNT(учёт_SCE!C4:C25)","v":22},{"$f":"COUNT(учёт_SCE!C44:C74)","v":0},0]
[null,22,2785121,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C25)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C25)","v":0},null,null,null,null,null,"Май",{"$f":"COUNT(учёт_SCE!C26:C31)","v":6},{"$f":"COUNT(учёт_SCE!C75:C105)","v":0},0]
[null,23,2785122,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C26)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C26)","v":0},null,null,null,null,null,"Июнь",{"$f":"COUNT(учёт_SCE!#REF!)","v":0},{"$f":"COUNT(учёт_SCE!C143:C173)","v":0},0]
[null,24,2785123,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C27)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C27)","v":0},null,null,null,null,null,"Июль",{"$f":"COUNT(учёт_SCE!#REF!)","v":0},{"$f":"COUNT(учёт_SCE!C174:C203)","v":0},0]
[null,25,2785124,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C28)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C28)","v":0},null,null,null,null,null,"Август",{"$f":"COUNT(учёт_SCE!#REF!)","v":0},{"$f":"COUNT(учёт_SCE!C204:C233)","v":0},0]
[null,26,2785125,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C29)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C29)","v":0},null,null,null,null,null,"Сентябрь",{"$f":"COUNT(учёт_SCE!#REF!)","v":0},{"$f":"COUNT(учёт_SCE!C234:C263)","v":0},0]
[null,27,2785126,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C30)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C30)","v":0},null,null,null,null,null,"Октябрь",{"$f":"COUNT(учёт_SCE!#REF!)","v":0},{"$f":"COUNT(учёт_SCE!C264:C293)","v":0},0]
[null,28,2785127,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C31)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C31)","v":0},null,null,null,null,null,"Ноябрь",{"$f":"COUNT(учёт_SCE!#REF!)","v":0},{"$f":"COUNT(учёт_SCE!C294:C313)","v":0},0]
[null,29,2785128,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C32)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C32)","v":0},null,null,null,null,null,"Декабрь",{"$f":"COUNT(учёт_SCE!#REF!)","v":0},{"$f":"COUNT(учёт_SCE!C314:C343)","v":0},0]
[null,30,2785129,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C33)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C33)","v":0}]
[null,31,2785130,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C34)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C34)","v":0},null,null,null,null,null,"Ноябрь",{"$f":"SUMPRODUCT(--(TEXT($C$847:$C$2847,\"ММММ\")=U34))","v":0}]
[null,32,2785131,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C35)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C35)","v":0}]
[null,98,2785197,"W-CTRL-SCE-B-4x10A-T4-FM-ND2-RU",4,{"$f":"IF(ISERR(MID(D36,FIND(\"(\",D36),FIND(\")\",D36)-FIND(\"(\",D36)+1)),\"\",MID(D36,FIND(\"(\",D36),FIND(\")\",D36)-FIND(\"(\",D36)+1))","v":""},null,null,{"$f":"MID(D36,15,1)","v":"x"},220518,null,null,{"$f":"F36/1440","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C36)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C36)","v":0}]
[null,99,2785198,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C37)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C37)","v":0}]
[null,100,2785199,"W-CTRL-SCE-B-2x13A-T4-FM-ND2-RU",2,40,null,null,"x",null,null,null,"00:40:00",{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C38)","v":4},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C38)","v":1},"0118"]
[null,142,2785241,"W-CTRL-SCE-B-2x10A-T4-FM-ND2-RU",2,40,null,null,{"$f":"MID(D39,15,1)","v":"x"},30418,null,null,{"$f":"F39/1440","v":"00:40:00"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C39)","v":6},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C39)","v":1}]
[null,143,2785242,"W-CTRL-SCE-B-3x10A-T4-FM-ND2-RU",3,45,null,null,"x",null,null,null,{"$f":"F40/1440","v":"00:45:00"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C40)","v":5},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C40)","v":2},"0117"]
[null,144,2785243,"ОБНОВИТЬ БАЗУ",null,{"$f":"IF(ISERR(MID(D41,FIND(\"(\",D41),FIND(\")\",D41)-FIND(\"(\",D41)+1)),\"\",MID(D41,FIND(\"(\",D41),FIND(\")\",D41)-FIND(\"(\",D41)+1))","v":""},null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C41)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C41)","v":0}]
[null,145,2785244,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C42)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C42)","v":0}]
[null,146,2785245,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C43)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C43)","v":0}]
[null,147,2785246,"W-CTRL-SCE-B-3x13A-T4-FM-ND2-RU",3,45,null,null,null,null,"V",null,"00:45:00",{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C44)","v":11},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C44)","v":0},null,null,null,null,null,{"$f":"SUM(M39,M40)","v":"01:25:00"}]
[null,148,2785247,"W-CTRL-SCE-B-4x13A-T4-FM-ND2-RU",4,50,null,null,{"$f":"MID(D45,15,1)","v":"x"},null,null,null,"00:50:00",{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C45)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C45)","v":2},"0116"]
[null,149,2785248,"ОБНОВИТЬ БАЗУ",null,"",null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C46)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C46)","v":0}]
[null,150,2785249,"W-CTRL-SCE-B-2x16A-T4-FM-ND2-RU",2,40,null,null,"x",300318,null,null,"00:40:00",{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C47)","v":1},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C47)","v":1},"0117"]
[null,151,2785250,"W-CTRL-SCE-B-3x16A-T4-FM-ND2-RU",3,45,null,null,"x",null,null,null,"00:45:00",{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C48)","v":1},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C48)","v":0}]
[null,152,2785251,"W-CTRL-SCE-B-4x16A-T4-FM-ND2-RU",4,50,null,null,"x",null,null,null,{"$f":"F49/1440","v":"00:50:00"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C49)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C49)","v":0}]
[null,158,2785257,"W-CTRL-SCE-B-2x32A-T4-FM-ND2-RU",2,40,null,null,"x",null,null,null,"00:40:00",{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C50)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C50)","v":0}]
[null,201,2785300,"ОБНОВИТЬ БАЗУ",null,{"$f":"IF(ISERR(MID(D51,FIND(\"(\",D51),FIND(\")\",D51)-FIND(\"(\",D51)+1)),\"\",MID(D51,FIND(\"(\",D51),FIND(\")\",D51)-FIND(\"(\",D51)+1))","v":""},null,null,"",null,null,null,{"$error":"#VALUE!"},{"$f":"COUNTIF(учёт_SCE!D$4:$D$31,C51)","v":0},{"$f":"COUNTIF(учёт_SCE!$D$32:$D$325,C51)","v":0}]
[null,202,2455545,"W-CTRL-SKm-W-B-3x(7,2A)-T4-OI-R3-GSM",null,"(7,2A)",null,null,"-",null,null,null,{"$error":"#VALUE!"}]