{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ГБР","инкас","Постовая \"М\""],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":23,"n_cols":37,"rows_kept":23,"cut":false,"hidden":false,"merged":[[19,36,22,36],[0,29,0,33],[8,9,8,19],[8,20,8,29],[11,36,14,36],[15,36,18,36],[9,0,10,0],[9,1,10,1],[9,34,10,34],[9,35,10,35],[9,36,10,36],[9,2,10,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Август",null,null,null,null,null,null,null,null,null,null,2024]
["№","Фамилия И.О.",null,{"$f":"DATE(U9,SEARCH(MID(J9,2,2),\"ёнвеварпрайюнюлвгенктояек\")/2,1)","v":"2024-08-01"},{"$f":"D10+1","v":"2024-08-02"},{"$f":"E10+1","v":"2024-08-03"},"2024-08-04","2024-08-05","2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10","2024-08-11","2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17","2024-08-18","2024-08-19","2024-08-20","2024-08-21","2024-08-22","2024-08-23","2024-08-24","2024-08-25","2024-08-26","2024-08-27","2024-08-28",{"$f":"IFERROR(IF(MONTH(AE10+1)=SEARCH(MID($J$9,2,2),\"ёнвеварпрайюнюлвгенктояек\")/2,AE10+1,\"\"),\"\")","v":"2024-08-29"},{"$f":"IFERROR(IF(MONTH(AF10+1)=SEARCH(MID($J$9,2,2),\"ёнвеварпрайюнюлвгенктояек\")/2,AF10+1,\"\"),\"\")","v":"2024-08-30"},{"$f":"IFERROR(IF(MONTH(AG10+1)=SEARCH(MID($J$9,2,2),\"ёнвеварпрайюнюлвгенктояек\")/2,AG10+1,\"\"),\"\")","v":"2024-08-31"},"Всего смен"]
[null,null,null,{"$f":"D10","v":"2024-08-01"},{"$f":"E10","v":"2024-08-02"},"2024-08-03","2024-08-04","2024-08-05","2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10","2024-08-11","2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17","2024-08-18","2024-08-19","2024-08-20","2024-08-21","2024-08-22","2024-08-23","2024-08-24","2024-08-25","2024-08-26","2024-08-27","2024-08-28","2024-08-29","2024-08-30","2024-08-31"]
[1,{"$f":"'Постовая \"М\"'!J26","v":"Колесов Е.Д."},"ст.",null,null,null,null,null,null,3,3,null,null,3,3,null,null,3,3,null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х",{"$f":"COUNT(D12:AH12)","v":6},null,41]
[2,{"$f":"'Постовая \"М\"'!J27","v":"Румянцев Д.А."},"вод",null,null,null,null,null,null,3,3,null,null,3,3,null,null,3,3,null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х",6]
[3,{"$f":"'Постовая \"М\"'!J28","v":"Фролов И.Я."},"ст.",3,3,null,null,4,3,null,null,3,4,null,null,4,3,null,null,4,4,null,null,4,4,null,null,4,4,null,null,4,4,null,{"$f":"COUNT(D14:AH14)","v":16},{"$f":"SUM(D14:AH14)","v":59}]
[4,{"$f":"'Постовая \"М\"'!J29","v":"Богданов М.В."},"вод","х","х",null,null,"х",3,null,null,3,4,null,null,4,3,null,null,4,4,null,null,"х","х",null,null,"х","х",null,null,"х","х",null,{"$f":"COUNTIF(D15:AH15,\"х\")","v":9}]
[5,{"$f":"'Постовая \"М\"'!J30","v":"Макаров А.М."},"ст.",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х",15,{"$f":"AI16*3","v":45},42]
[6,{"$f":"'Постовая \"М\"'!J31","v":"Фатеев А.В."},"вод",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х",15,45]
[7,{"$f":"'Постовая \"М\"'!J32","v":"Исаев С.В."},"ст.","х","х",null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[8,{"$f":"'Постовая \"М\"'!J33","v":"Евдокимов К.Н."},"вод","х","х",null,null,null,3,null,null,3.5,null,null,null,null,3.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[9,{"$f":"'Постовая \"М\"'!J34","v":"Зимин Р.О."},"ст.",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х",{"$f":"COUNTIF(D20:AH20,\"х\")","v":15},{"$f":"AI20*3","v":45},43]
[10,{"$f":"'Постовая \"М\"'!J35","v":"Балашов М.М."},"вод",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х",15,45]
[11,{"$f":"'Постовая \"М\"'!J36","v":"Васильев С.П."},"ст.","х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,16,{"$f":"AI22*3","v":48}]
[12,{"$f":"'Постовая \"М\"'!J37","v":"Виноградов М.М."},"вод","х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,null,"х","х",null,16,{"$f":"AI23*3","v":48}]

{"sheet":"инкас","index":1,"n_rows":17,"n_cols":35,"rows_kept":17,"cut":false,"hidden":false,"merged":[[11,34,12,34],[11,0,12,0],[11,1,12,1],[11,33,12,33],[0,26,0,30],[7,0,7,33],[8,0,8,33],[9,0,9,33],[10,8,10,18],[10,19,10,28]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Август",null,null,null,null,null,null,null,null,null,null,2024]
["№","Фамилия И.О.",{"$f":"DATE(T11,SEARCH(MID(I11,2,2),\"ёнвеварпрайюнюлвгенктояек\")/2,1)","v":"2024-08-01"},{"$f":"C12+1","v":"2024-08-02"},"2024-08-03","2024-08-04","2024-08-05","2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10","2024-08-11","2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17","2024-08-18","2024-08-19","2024-08-20","2024-08-21","2024-08-22","2024-08-23","2024-08-24","2024-08-25","2024-08-26","2024-08-27","2024-08-28",{"$f":"IFERROR(IF(MONTH(AD12+1)=SEARCH(MID($I$11,2,2),\"ёнвеварпрайюнюлвгенктояек\")/2,AD12+1,\"\"),\"\")","v":"2024-08-29"},{"$f":"IFERROR(IF(MONTH(AE12+1)=SEARCH(MID($I$11,2,2),\"ёнвеварпрайюнюлвгенктояек\")/2,AE12+1,\"\"),\"\")","v":"2024-08-30"},{"$f":"IFERROR(IF(MONTH(AF12+1)=SEARCH(MID($I$11,2,2),\"ёнвеварпрайюнюлвгенктояек\")/2,AF12+1,\"\"),\"\")","v":"2024-08-31"},"Всего","Подпись"]
[null,null,{"$f":"C12","v":"2024-08-01"},"2024-08-02","2024-08-03","2024-08-04","2024-08-05","2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10","2024-08-11","2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17","2024-08-18","2024-08-19","2024-08-20","2024-08-21","2024-08-22","2024-08-23","2024-08-24","2024-08-25","2024-08-26","2024-08-27","2024-08-28","2024-08-29","2024-08-30","2024-08-31"]
[1,"Гаевский О.Е.",1,2,null,null,2,1,2,1,null,null,null,2,1,2,null,2,null,null,2,1,null,1,2,null,null,2,null,2,1,2,null,{"$f":"COUNTA(C14:AG14)","v":18}]
[2,"Туманов С.И.",3,1,null,null,3,2,1,2,3,null,null,null,3,1,2,3,null,null,3,3,1,2,3,null,null,1,3,1,3,null,null,{"$f":"COUNTA(C15:AG15)","v":20}]
[3,"Кучерявенко Д.В.",null,3,3,null,1,3,null,3,2,null,3,1,null,3,1,null,3,null,null,2,3,null,1,3,null,3,2,null,2,3,null,{"$f":"COUNTA(C16:AG16)","v":19}]
[4,"Новиков О.О.",2,null,null,3,null,null,3,null,1,3,null,3,2,null,3,1,null,3,1,null,2,3,null,null,3,null,1,3,null,1,3,{"$f":"COUNTA(C17:AG17)","v":18}]

{"sheet":"Постовая \"М\"","index":2,"n_rows":37,"n_cols":45,"rows_kept":37,"cut":false,"hidden":false,"merged":[[16,14,16,20],[18,3,18,6],[31,3,31,6],[30,3,30,6],[19,3,19,6],[25,3,25,6],[26,3,26,6],[27,3,27,6],[28,3,28,6],[29,3,29,6],[21,3,21,6],[23,3,23,6],[24,3,24,6],[32,3,32,6],[33,3,33,6],[34,3,34,6],[7,5,7,6],[9,0,9,8],[10,0,10,8],[16,3,16,6],[17,3,17,6],[14,0,14,5],[15,0,15,5],[12,3,12,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Постовая ведомость суточного наряда"]
[]
[]
["                                                                                                                         ",null,"на","2024-08-01"]
[]
["1. Общее количество охранников, заступивших на службу:  ",null,null,null,null,null,{"$f":"COUNTIF(B18:B40,\"*.*\")","v":8}]
["     2. Расстановка сотрудников по маршрутам"]
["№\nмарш\nрута","Ф.И.О. охранника","Время \nзаступл","Наличие оружия и спецсредств на маршруте",null,null,null,"Время\n оконча\nния ","Прим",null,null,null,null,null,{"$f":"инкас!I11","v":"Август"}]
[41,{"$f":"_xlfn._xlws.FILTER($J$26:$J$37, (INDEX($K$26:$AO$37,, DAY($D$13))=\"х\") * ({41;41;41;41;42;42;42;42;43;43;43;43}=A18), \"\")","v":"Богданов М.В."},"06:00:00","Гражданское ОООП МР-79-9тм",null,null,null,"06:00:00"]
[null,null,null,"16 патронов травм. действия,",null,null,null,null,null,null,"1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-08","1900-01-09","1900-01-10","1900-01-11","1900-01-12","1900-01-13","1900-01-14","1900-01-15","1900-01-16","1900-01-17","1900-01-18","1900-01-19","1900-01-20","1900-01-21","1900-01-22","1900-01-23","1900-01-24","1900-01-25","1900-01-26","1900-01-27","1900-01-28","1900-01-29","1900-01-30","1900-01-31"]
[null,null,null," бронежилет-2 шт., ПР-73, наручники",null,null,null,null,null,null,{"$f":"инкас!C13","v":"2024-08-01"},{"$f":"инкас!D13","v":"2024-08-02"},{"$f":"инкас!E13","v":"2024-08-03"},{"$f":"инкас!F13","v":"2024-08-04"},{"$f":"инкас!G13","v":"2024-08-05"},{"$f":"инкас!H13","v":"2024-08-06"},{"$f":"инкас!I13","v":"2024-08-07"},{"$f":"инкас!J13","v":"2024-08-08"},{"$f":"инкас!K13","v":"2024-08-09"},{"$f":"инкас!L13","v":"2024-08-10"},{"$f":"инкас!M13","v":"2024-08-11"},{"$f":"инкас!N13","v":"2024-08-12"},{"$f":"инкас!O13","v":"2024-08-13"},{"$f":"инкас!P13","v":"2024-08-14"},{"$f":"инкас!Q13","v":"2024-08-15"},{"$f":"инкас!R13","v":"2024-08-16"},{"$f":"инкас!S13","v":"2024-08-17"},{"$f":"инкас!T13","v":"2024-08-18"},{"$f":"инкас!U13","v":"2024-08-19"},{"$f":"инкас!V13","v":"2024-08-20"},{"$f":"инкас!W13","v":"2024-08-21"},{"$f":"инкас!X13","v":"2024-08-22"},{"$f":"инкас!Y13","v":"2024-08-23"},{"$f":"инкас!Z13","v":"2024-08-24"},{"$f":"инкас!AA13","v":"2024-08-25"},{"$f":"инкас!AB13","v":"2024-08-26"},{"$f":"инкас!AC13","v":"2024-08-27"},{"$f":"инкас!AD13","v":"2024-08-28"},{"$f":"инкас!AE13","v":"2024-08-29"},{"$f":"инкас!AF13","v":"2024-08-30"},{"$f":"инкас!AG13","v":"2024-08-31"},null,1,2,3]
[42,{"$f":"_xlfn._xlws.FILTER($J$26:$J$37, (INDEX($K$26:$AO$37,, DAY($D$13))=\"х\") * ({41;41;41;41;42;42;42;42;43;43;43;43}=A21), \"\")","v":"Исаев С.В."},"06:00:00",null,null,null,null,"06:00:00",null,"Белов А.В.",{"$f":"инкас!C14","v":1},{"$f":"инкас!D14","v":2},{"$f":"инкас!E14","v":0},{"$f":"инкас!F14","v":0},{"$f":"инкас!G14","v":2},{"$f":"инкас!H14","v":1},{"$f":"инкас!I14","v":2},{"$f":"инкас!J14","v":1},{"$f":"инкас!K14","v":0},{"$f":"инкас!L14","v":0},{"$f":"инкас!M14","v":0},{"$f":"инкас!N14","v":2},{"$f":"инкас!O14","v":1},{"$f":"инкас!P14","v":2},{"$f":"инкас!Q14","v":0},{"$f":"инкас!R14","v":2},{"$f":"инкас!S14","v":0},{"$f":"инкас!T14","v":0},{"$f":"инкас!U14","v":2},{"$f":"инкас!V14","v":1},{"$f":"инкас!W14","v":0},{"$f":"инкас!X14","v":1},{"$f":"инкас!Y14","v":2},{"$f":"инкас!Z14","v":0},{"$f":"инкас!AA14","v":0},{"$f":"инкас!AB14","v":2},{"$f":"инкас!AC14","v":0},{"$f":"инкас!AD14","v":2},{"$f":"инкас!AE14","v":1},{"$f":"инкас!AF14","v":2},{"$f":"инкас!AG14","v":0},{"$f":"SUM(AQ21:AS21)","v":18},{"$f":"COUNTIF(K21:AO21,\"1\")","v":7},{"$f":"COUNTIF(K21:AO21,\"2\")","v":11},{"$f":"COUNTIF(K21:AO21,\"3\")","v":0}]
[null,"Евдокимов К.Н.",null," бронежилет-2 шт., ПР-73, наручники",null,null,null,null,null,"Тарасов Д.А",{"$f":"инкас!C15","v":3},{"$f":"инкас!D15","v":1},{"$f":"инкас!E15","v":0},{"$f":"инкас!F15","v":0},{"$f":"инкас!G15","v":3},{"$f":"инкас!H15","v":2},{"$f":"инкас!I15","v":1},{"$f":"инкас!J15","v":2},{"$f":"инкас!K15","v":3},{"$f":"инкас!L15","v":0},{"$f":"инкас!M15","v":0},{"$f":"инкас!N15","v":0},{"$f":"инкас!O15","v":3},3,{"$f":"инкас!Q15","v":2},{"$f":"инкас!R15","v":3},{"$f":"инкас!S15","v":0},{"$f":"инкас!T15","v":0},{"$f":"инкас!U15","v":3},{"$f":"инкас!V15","v":3},{"$f":"инкас!W15","v":1},null,{"$f":"инкас!Y15","v":3},{"$f":"инкас!Z15","v":0},{"$f":"инкас!AA15","v":0},{"$f":"инкас!AB15","v":1},{"$f":"инкас!AC15","v":3},{"$f":"инкас!AD15","v":1},{"$f":"инкас!AE15","v":3},{"$f":"инкас!AF15","v":0},{"$f":"инкас!AG15","v":0},{"$f":"SUM(AQ22:AS22)","v":19},{"$f":"COUNTIF(K22:AO22,\"1\")","v":5},{"$f":"COUNTIF(K22:AO22,\"2\")","v":3},{"$f":"COUNTIF(K22:AO22,\"3\")","v":11}]
[null,null,null,null,null,null,null,null,null,"Черных Л.В.",{"$f":"инкас!C16","v":0},{"$f":"инкас!D16","v":3},{"$f":"инкас!E16","v":3},{"$f":"инкас!F16","v":0},{"$f":"инкас!G16","v":1},{"$f":"инкас!H16","v":3},{"$f":"инкас!I16","v":0},{"$f":"инкас!J16","v":3},{"$f":"инкас!K16","v":2},{"$f":"инкас!L16","v":0},{"$f":"инкас!M16","v":3},{"$f":"инкас!N16","v":1},{"$f":"инкас!O16","v":0},{"$f":"инкас!P16","v":3},{"$f":"инкас!Q16","v":1},{"$f":"инкас!R16","v":0},{"$f":"инкас!S16","v":3},{"$f":"инкас!T16","v":0},{"$f":"инкас!U16","v":0},{"$f":"инкас!V16","v":2},{"$f":"инкас!W16","v":3},{"$f":"инкас!X16","v":0},{"$f":"инкас!Y16","v":1},{"$f":"инкас!Z16","v":3},{"$f":"инкас!AA16","v":0},{"$f":"инкас!AB16","v":3},{"$f":"инкас!AC16","v":2},{"$f":"инкас!AD16","v":0},{"$f":"инкас!AE16","v":2},{"$f":"инкас!AF16","v":3},{"$f":"инкас!AG16","v":0},19,4,4,11]
[43,{"$f":"_xlfn._xlws.FILTER($J$26:$J$37, (INDEX($K$26:$AO$37,, DAY($D$13))=\"х\") * ({41;41;41;41;42;42;42;42;43;43;43;43}=A24), \"\")","v":"Васильев С.П."},"06:00:00","Гражданское ОООП МР-79-9тм",null,null,null,"06:00:00",null,"Никитин О.О.",{"$f":"инкас!C17","v":2},{"$f":"инкас!D17","v":0},{"$f":"инкас!E17","v":0},{"$f":"инкас!F17","v":3},{"$f":"инкас!G17","v":0},{"$f":"инкас!H17","v":0},{"$f":"инкас!I17","v":3},{"$f":"инкас!J17","v":0},{"$f":"инкас!K17","v":1},{"$f":"инкас!L17","v":3},{"$f":"инкас!M17","v":0},{"$f":"инкас!N17","v":3},{"$f":"инкас!O17","v":2},null,{"$f":"инкас!Q17","v":3},{"$f":"инкас!R17","v":1},{"$f":"инкас!S17","v":0},{"$f":"инкас!T17","v":3},{"$f":"инкас!U17","v":1},{"$f":"инкас!V17","v":0},{"$f":"инкас!W17","v":2},1,{"$f":"инкас!Y17","v":0},{"$f":"инкас!Z17","v":0},{"$f":"инкас!AA17","v":3},{"$f":"инкас!AB17","v":0},{"$f":"инкас!AC17","v":1},{"$f":"инкас!AD17","v":3},{"$f":"инкас!AE17","v":0},{"$f":"инкас!AF17","v":1},{"$f":"инкас!AG17","v":3},18,6,3,9]
[null,"Виноградов М.М.",null,"16 патронов травм. действия,"]
[null,null,null," бронежилет-2 шт., ПР-73, наручники",null,null,null,null,null,"Колесов Е.Д.",{"$f":"ГБР!D12","v":0},{"$f":"ГБР!E12","v":0},{"$f":"ГБР!F12","v":0},{"$f":"ГБР!G12","v":0},{"$f":"ГБР!H12","v":0},{"$f":"ГБР!I12","v":0},"х","х",{"$f":"ГБР!L12","v":0},{"$f":"ГБР!M12","v":0},"х","х",{"$f":"ГБР!P12","v":0},{"$f":"ГБР!Q12","v":0},"х","х",{"$f":"ГБР!T12","v":0},{"$f":"ГБР!U12","v":0},"х","х",{"$f":"ГБР!X12","v":0},{"$f":"ГБР!Y12","v":0},"х","х",{"$f":"ГБР!AB12","v":0},{"$f":"ГБР!AC12","v":0},"х","х",{"$f":"ГБР!AF12","v":0},{"$f":"ГБР!AG12","v":0},"х",{"$f":"COUNTIF(K26:AO26,\"*\")","v":13}]
[null,null,null,null,null,null,null,null,null,"Румянцев Д.А.",{"$f":"ГБР!D13","v":0},{"$f":"ГБР!E13","v":0},{"$f":"ГБР!F13","v":0},{"$f":"ГБР!G13","v":0},{"$f":"ГБР!H13","v":0},{"$f":"ГБР!I13","v":0},"х","х",{"$f":"ГБР!L13","v":0},{"$f":"ГБР!M13","v":0},"х","х",{"$f":"ГБР!P13","v":0},{"$f":"ГБР!Q13","v":0},"х","х",{"$f":"ГБР!T13","v":0},{"$f":"ГБР!U13","v":0},"х","х",{"$f":"ГБР!X13","v":0},{"$f":"ГБР!Y13","v":0},"х","х",{"$f":"ГБР!AB13","v":0},{"$f":"ГБР!AC13","v":0},"х","х",{"$f":"ГБР!AF13","v":0},{"$f":"ГБР!AG13","v":0},"х",13]
[1,{"$f":"_xlfn.XLOOKUP(A28, INDEX($K$21:$AO$24,,DAY($D$13)), $J$21:$J$24, \"нет маршрута\")","v":"Белов А.В."},{"$f":"IF(COUNTIF(B31,\"нет маршрута\"),\"\",\"6:30 \")","v":"6:30 "},{"$f":"IF(COUNTIF(B28,\"нет маршрута\"),\"НЕ ВЫДАВАЛОСЬ\",\"Служебное оружие МР-71 9мм\")","v":"Служебное оружие МР-71 9мм"},null,null,null,{"$f":"IF(COUNTIF(B31,\"нет маршрута\"),\"\",\"19:00 \")","v":"19:00 "},null,"Фролов И.Я.",{"$f":"ГБР!D14","v":3},{"$f":"ГБР!E14","v":3},{"$f":"ГБР!F14","v":0},{"$f":"ГБР!G14","v":0},{"$f":"ГБР!H14","v":4},{"$f":"ГБР!I14","v":3},{"$f":"ГБР!J14","v":0},{"$f":"ГБР!K14","v":0},{"$f":"ГБР!L14","v":3},{"$f":"ГБР!M14","v":4},{"$f":"ГБР!N14","v":0},{"$f":"ГБР!O14","v":0},{"$f":"ГБР!P14","v":4},{"$f":"ГБР!Q14","v":3},{"$f":"ГБР!R14","v":0},{"$f":"ГБР!S14","v":0},{"$f":"ГБР!T14","v":4},{"$f":"ГБР!U14","v":4},{"$f":"ГБР!V14","v":0},{"$f":"ГБР!W14","v":0},{"$f":"ГБР!X14","v":4},{"$f":"ГБР!Y14","v":4},{"$f":"ГБР!Z14","v":0},{"$f":"ГБР!AA14","v":0},{"$f":"ГБР!AB14","v":4},{"$f":"ГБР!AC14","v":4},{"$f":"ГБР!AD14","v":0},{"$f":"ГБР!AE14","v":0},{"$f":"ГБР!AF14","v":4},{"$f":"ГБР!AG14","v":4},{"$f":"ГБР!AH14","v":0},0]
[null,null,null,{"$f":"IF(COUNTIF(B28,\"нет маршрута\"),\"\",\"20 патронов 9Х17 мм, бронежилет\")","v":"20 патронов 9Х17 мм, бронежилет"},null,null,null,null,null,"Богданов М.В.",{"$f":"ГБР!D15","v":"х"},{"$f":"ГБР!E15","v":"х"},{"$f":"ГБР!F15","v":0},{"$f":"ГБР!G15","v":0},{"$f":"ГБР!H15","v":"х"},{"$f":"ГБР!I15","v":3},{"$f":"ГБР!J15","v":0},{"$f":"ГБР!K15","v":0},{"$f":"ГБР!L15","v":3},{"$f":"ГБР!M15","v":4},{"$f":"ГБР!N15","v":0},{"$f":"ГБР!O15","v":0},{"$f":"ГБР!P15","v":4},{"$f":"ГБР!Q15","v":3},{"$f":"ГБР!R15","v":0},{"$f":"ГБР!S15","v":0},{"$f":"ГБР!T15","v":4},{"$f":"ГБР!U15","v":4},{"$f":"ГБР!V15","v":0},{"$f":"ГБР!W15","v":0},{"$f":"ГБР!X15","v":"х"},{"$f":"ГБР!Y15","v":"х"},{"$f":"ГБР!Z15","v":0},{"$f":"ГБР!AA15","v":0},{"$f":"ГБР!AB15","v":"х"},{"$f":"ГБР!AC15","v":"х"},{"$f":"ГБР!AD15","v":0},{"$f":"ГБР!AE15","v":0},{"$f":"ГБР!AF15","v":"х"},{"$f":"ГБР!AG15","v":"х"},{"$f":"ГБР!AH15","v":0},{"$f":"COUNTIF(K29:AO29,\"*\")","v":9}]
[null,null,null,null,null,null,null,null,null,"Макаров А.М.",{"$f":"ГБР!D16","v":0},{"$f":"ГБР!E16","v":0},{"$f":"ГБР!F16","v":"х"},{"$f":"ГБР!G16","v":"х"},{"$f":"ГБР!H16","v":0},{"$f":"ГБР!I16","v":0},{"$f":"ГБР!J16","v":"х"},{"$f":"ГБР!K16","v":"х"},{"$f":"ГБР!L16","v":0},{"$f":"ГБР!M16","v":0},{"$f":"ГБР!N16","v":"х"},{"$f":"ГБР!O16","v":"х"},{"$f":"ГБР!P16","v":0},{"$f":"ГБР!Q16","v":0},{"$f":"ГБР!R16","v":"х"},{"$f":"ГБР!S16","v":"х"},{"$f":"ГБР!T16","v":0},{"$f":"ГБР!U16","v":0},{"$f":"ГБР!V16","v":"х"},{"$f":"ГБР!W16","v":"х"},{"$f":"ГБР!X16","v":0},{"$f":"ГБР!Y16","v":0},{"$f":"ГБР!Z16","v":"х"},{"$f":"ГБР!AA16","v":"х"},{"$f":"ГБР!AB16","v":0},{"$f":"ГБР!AC16","v":0},{"$f":"ГБР!AD16","v":"х"},{"$f":"ГБР!AE16","v":"х"},{"$f":"ГБР!AF16","v":0},{"$f":"ГБР!AG16","v":0},{"$f":"ГБР!AH16","v":"х"},15]
[2,{"$f":"_xlfn.XLOOKUP(A31, INDEX($K$21:$AO$24,,DAY($D$13)), $J$21:$J$24, \"нет маршрута\")","v":"Никитин О.О."},{"$f":"IF(COUNTIF(B31,\"нет маршрута\"),\"\",\"6:30 \")","v":"6:30 "},{"$f":"IF(COUNTIF(B31,\"нет маршрута\"),\"НЕ ВЫДАВАЛОСЬ\",\"Служебное оружие МР-71 9мм\")","v":"Служебное оружие МР-71 9мм"},null,null,null,{"$f":"IF(COUNTIF(B31,\"нет маршрута\"),\"\",\"19:00 \")","v":"19:00 "},null,"Фатеев А.В.",{"$f":"ГБР!D17","v":0},{"$f":"ГБР!E17","v":0},{"$f":"ГБР!F17","v":"х"},{"$f":"ГБР!G17","v":"х"},{"$f":"ГБР!H17","v":0},{"$f":"ГБР!I17","v":0},{"$f":"ГБР!J17","v":"х"},{"$f":"ГБР!K17","v":"х"},{"$f":"ГБР!L17","v":0},{"$f":"ГБР!M17","v":0},{"$f":"ГБР!N17","v":"х"},{"$f":"ГБР!O17","v":"х"},{"$f":"ГБР!P17","v":0},{"$f":"ГБР!Q17","v":0},{"$f":"ГБР!R17","v":"х"},{"$f":"ГБР!S17","v":"х"},{"$f":"ГБР!T17","v":0},{"$f":"ГБР!U17","v":0},{"$f":"ГБР!V17","v":"х"},{"$f":"ГБР!W17","v":"х"},{"$f":"ГБР!X17","v":0},{"$f":"ГБР!Y17","v":0},{"$f":"ГБР!Z17","v":"х"},{"$f":"ГБР!AA17","v":"х"},{"$f":"ГБР!AB17","v":0},{"$f":"ГБР!AC17","v":0},{"$f":"ГБР!AD17","v":"х"},{"$f":"ГБР!AE17","v":"х"},{"$f":"ГБР!AF17","v":0},{"$f":"ГБР!AG17","v":0},{"$f":"ГБР!AH17","v":"х"},15]
[null,null,null,{"$f":"IF(COUNTIF(B31,\"нет маршрута\"),\"\",\"20 патронов 9Х17 мм, бронежилет\")","v":"20 патронов 9Х17 мм, бронежилет"},null,null,null,null,null,"Исаев С.В.",{"$f":"ГБР!D18","v":"х"},{"$f":"ГБР!E18","v":"х"},{"$f":"ГБР!F18","v":0},{"$f":"ГБР!G18","v":0},null,{"$f":"ГБР!I18","v":3},{"$f":"ГБР!J18","v":0},{"$f":"ГБР!K18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ГБР!AH18","v":0},2]
[null,null,null,null,null,null,null,null,null,"Евдокимов К.Н.",{"$f":"ГБР!D19","v":"х"},{"$f":"ГБР!E19","v":"х"},{"$f":"ГБР!F19","v":0},{"$f":"ГБР!G19","v":0},null,{"$f":"ГБР!I19","v":3},{"$f":"ГБР!J19","v":0},{"$f":"ГБР!K19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ГБР!AH19","v":0},2]
[3,{"$f":"_xlfn.XLOOKUP(A34, INDEX($K$21:$AO$24,,DAY($D$13)), $J$21:$J$24, \"\")","v":"Тарасов Д.А"},{"$f":"IF(COUNTIF(B31,\"нет маршрута\"),\"11:00\",\"6:30 \")","v":"6:30 "},{"$f":"IF(COUNTIF(B34,\"*\"),\"Служебное оружие МР-71 9мм\",\"\")","v":"Служебное оружие МР-71 9мм"},null,null,null,{"$f":"IF(COUNTIF(B34,\"*\"),\"19:00\",\"\")","v":"19:00"},null,"Зимин Р.О.",{"$f":"ГБР!D20","v":0},{"$f":"ГБР!E20","v":0},{"$f":"ГБР!F20","v":"х"},{"$f":"ГБР!G20","v":"х"},{"$f":"ГБР!H20","v":0},{"$f":"ГБР!I20","v":0},{"$f":"ГБР!J20","v":"х"},{"$f":"ГБР!K20","v":"х"},{"$f":"ГБР!L20","v":0},{"$f":"ГБР!M20","v":0},{"$f":"ГБР!N20","v":"х"},{"$f":"ГБР!O20","v":"х"},{"$f":"ГБР!P20","v":0},{"$f":"ГБР!Q20","v":0},{"$f":"ГБР!R20","v":"х"},{"$f":"ГБР!S20","v":"х"},{"$f":"ГБР!T20","v":0},{"$f":"ГБР!U20","v":0},{"$f":"ГБР!V20","v":"х"},{"$f":"ГБР!W20","v":"х"},{"$f":"ГБР!X20","v":0},{"$f":"ГБР!Y20","v":0},{"$f":"ГБР!Z20","v":"х"},{"$f":"ГБР!AA20","v":"х"},{"$f":"ГБР!AB20","v":0},{"$f":"ГБР!AC20","v":0},{"$f":"ГБР!AD20","v":"х"},{"$f":"ГБР!AE20","v":"х"},{"$f":"ГБР!AF20","v":0},{"$f":"ГБР!AG20","v":0},{"$f":"ГБР!AH20","v":"х"},15]
[null,null,null,{"$f":"IF(COUNTIF(B34,\"*\"),\"20 патронов 9Х17 мм, бронежилет\",\"\")","v":"20 патронов 9Х17 мм, бронежилет"},null,null,null,null,null,"Балашов М.М.",{"$f":"ГБР!D21","v":0},{"$f":"ГБР!E21","v":0},{"$f":"ГБР!F21","v":"х"},{"$f":"ГБР!G21","v":"х"},{"$f":"ГБР!H21","v":0},{"$f":"ГБР!I21","v":0},{"$f":"ГБР!J21","v":"х"},{"$f":"ГБР!K21","v":"х"},{"$f":"ГБР!L21","v":0},{"$f":"ГБР!M21","v":0},{"$f":"ГБР!N21","v":"х"},{"$f":"ГБР!O21","v":"х"},{"$f":"ГБР!P21","v":0},{"$f":"ГБР!Q21","v":0},{"$f":"ГБР!R21","v":"х"},{"$f":"ГБР!S21","v":"х"},{"$f":"ГБР!T21","v":0},{"$f":"ГБР!U21","v":0},{"$f":"ГБР!V21","v":"х"},{"$f":"ГБР!W21","v":"х"},{"$f":"ГБР!X21","v":0},{"$f":"ГБР!Y21","v":0},{"$f":"ГБР!Z21","v":"х"},{"$f":"ГБР!AA21","v":"х"},{"$f":"ГБР!AB21","v":0},{"$f":"ГБР!AC21","v":0},{"$f":"ГБР!AD21","v":"х"},{"$f":"ГБР!AE21","v":"х"},{"$f":"ГБР!AF21","v":0},{"$f":"ГБР!AG21","v":0},{"$f":"ГБР!AH21","v":"х"},15]
[null,null,null,null,null,null,null,null,null,"Васильев С.П.",{"$f":"ГБР!D22","v":"х"},{"$f":"ГБР!E22","v":"х"},{"$f":"ГБР!F22","v":0},{"$f":"ГБР!G22","v":0},{"$f":"ГБР!H22","v":"х"},{"$f":"ГБР!I22","v":"х"},{"$f":"ГБР!J22","v":0},{"$f":"ГБР!K22","v":0},{"$f":"ГБР!L22","v":"х"},{"$f":"ГБР!M22","v":"х"},{"$f":"ГБР!N22","v":0},{"$f":"ГБР!O22","v":0},{"$f":"ГБР!P22","v":"х"},{"$f":"ГБР!Q22","v":"х"},{"$f":"ГБР!R22","v":0},{"$f":"ГБР!S22","v":0},{"$f":"ГБР!T22","v":"х"},{"$f":"ГБР!U22","v":"х"},{"$f":"ГБР!V22","v":0},{"$f":"ГБР!W22","v":0},{"$f":"ГБР!X22","v":"х"},{"$f":"ГБР!Y22","v":"х"},{"$f":"ГБР!Z22","v":0},{"$f":"ГБР!AA22","v":0},{"$f":"ГБР!AB22","v":"х"},{"$f":"ГБР!AC22","v":"х"},{"$f":"ГБР!AD22","v":0},{"$f":"ГБР!AE22","v":0},{"$f":"ГБР!AF22","v":"х"},{"$f":"ГБР!AG22","v":"х"},{"$f":"ГБР!AH22","v":0},16]
[null,null,null,null,null,null,null,null,null,"Виноградов М.М.",{"$f":"ГБР!D23","v":"х"},{"$f":"ГБР!E23","v":"х"},{"$f":"ГБР!F23","v":0},{"$f":"ГБР!G23","v":0},{"$f":"ГБР!H23","v":"х"},{"$f":"ГБР!I23","v":"х"},{"$f":"ГБР!J23","v":0},{"$f":"ГБР!K23","v":0},{"$f":"ГБР!L23","v":"х"},{"$f":"ГБР!M23","v":"х"},{"$f":"ГБР!N23","v":0},{"$f":"ГБР!O23","v":0},{"$f":"ГБР!P23","v":"х"},{"$f":"ГБР!Q23","v":"х"},{"$f":"ГБР!R23","v":0},{"$f":"ГБР!S23","v":0},{"$f":"ГБР!T23","v":"х"},{"$f":"ГБР!U23","v":"х"},{"$f":"ГБР!V23","v":0},{"$f":"ГБР!W23","v":0},{"$f":"ГБР!X23","v":"х"},{"$f":"ГБР!Y23","v":"х"},{"$f":"ГБР!Z23","v":0},{"$f":"ГБР!AA23","v":0},{"$f":"ГБР!AB23","v":"х"},{"$f":"ГБР!AC23","v":"х"},{"$f":"ГБР!AD23","v":0},{"$f":"ГБР!AE23","v":0},{"$f":"ГБР!AF23","v":"х"},{"$f":"ГБР!AG23","v":"х"},{"$f":"ГБР!AH23","v":0},16]