{"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":2,"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":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,11,1,11],[0,12,1,12],[0,9,1,9],[0,10,1,10],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,8]]}
["Отдел","Должность",null,null,null,"ФИО",null,null,null,"Категория","Дата рождения\n","Возраст"]
["Отдел"]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B2=\"Итого\"),MATCH(A2,Лист2!A:A,0)+1,MATCH(A2,Лист2!A:A,0))&\"c1\",0)","v":"Отдел1"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K3<>\"\",DATEDIF(K3,TODAY(),\"y\"),\"\")","v":""}]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B3=\"Итого\"),MATCH(A3,Лист2!A:A,0)+1,MATCH(A3,Лист2!A:A,0))&\"c1\",0)","v":"Отдел1"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K4<>\"\",DATEDIF(K4,TODAY(),\"y\"),\"\")","v":""}]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B4=\"Итого\"),MATCH(A4,Лист2!A:A,0)+1,MATCH(A4,Лист2!A:A,0))&\"c1\",0)","v":"Отдел1"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B5=\"Итого\"),MATCH(A5,Лист2!A:A,0)+1,MATCH(A5,Лист2!A:A,0))&\"c1\",0)","v":"Отдел1"},"ИТОГО",{"$f":"SUMIF($A$1:$A5,\"=\"&$A6,C$1:C5)","v":0},null,{"$f":"SUMIF($A$1:$A5,\"=\"&$A6,E$1:E5)","v":0},null,null,{"$f":"SUMIF($A$1:$A5,\"=\"&$A6,H$1:H5)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B6=\"Итого\"),MATCH(A6,Лист2!A:A,0)+1,MATCH(A6,Лист2!A:A,0))&\"c1\",0)","v":"Отдел2"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B7=\"Итого\"),MATCH(A7,Лист2!A:A,0)+1,MATCH(A7,Лист2!A:A,0))&\"c1\",0)","v":"Отдел2"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B8=\"Итого\"),MATCH(A8,Лист2!A:A,0)+1,MATCH(A8,Лист2!A:A,0))&\"c1\",0)","v":"Отдел2"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B9=\"Итого\"),MATCH(A9,Лист2!A:A,0)+1,MATCH(A9,Лист2!A:A,0))&\"c1\",0)","v":"Отдел2"},"ИТОГО",{"$f":"SUMIF($A$1:$A9,\"=\"&$A10,C$1:C9)","v":0},null,{"$f":"SUMIF($A$1:$A9,\"=\"&$A10,E$1:E9)","v":0},null,null,{"$f":"SUMIF($A$1:$A9,\"=\"&$A10,H$1:H9)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B10=\"Итого\"),MATCH(A10,Лист2!A:A,0)+1,MATCH(A10,Лист2!A:A,0))&\"c1\",0)","v":"Отдел3"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B11=\"Итого\"),MATCH(A11,Лист2!A:A,0)+1,MATCH(A11,Лист2!A:A,0))&\"c1\",0)","v":"Отдел3"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B12=\"Итого\"),MATCH(A12,Лист2!A:A,0)+1,MATCH(A12,Лист2!A:A,0))&\"c1\",0)","v":"Отдел3"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B13=\"Итого\"),MATCH(A13,Лист2!A:A,0)+1,MATCH(A13,Лист2!A:A,0))&\"c1\",0)","v":"Отдел3"},"ИТОГО",{"$f":"SUMIF($A$1:$A13,\"=\"&$A14,C$1:C13)","v":0},null,{"$f":"SUMIF($A$1:$A13,\"=\"&$A14,E$1:E13)","v":0},null,null,{"$f":"SUMIF($A$1:$A13,\"=\"&$A14,H$1:H13)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B14=\"Итого\"),MATCH(A14,Лист2!A:A,0)+1,MATCH(A14,Лист2!A:A,0))&\"c1\",0)","v":"Отдел4"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B15=\"Итого\"),MATCH(A15,Лист2!A:A,0)+1,MATCH(A15,Лист2!A:A,0))&\"c1\",0)","v":"Отдел4"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B16=\"Итого\"),MATCH(A16,Лист2!A:A,0)+1,MATCH(A16,Лист2!A:A,0))&\"c1\",0)","v":"Отдел4"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B17=\"Итого\"),MATCH(A17,Лист2!A:A,0)+1,MATCH(A17,Лист2!A:A,0))&\"c1\",0)","v":"Отдел4"},"ИТОГО",{"$f":"SUMIF($A$1:$A17,\"=\"&$A18,C$1:C17)","v":0},null,{"$f":"SUMIF($A$1:$A17,\"=\"&$A18,E$1:E17)","v":0},null,null,{"$f":"SUMIF($A$1:$A17,\"=\"&$A18,H$1:H17)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B18=\"Итого\"),MATCH(A18,Лист2!A:A,0)+1,MATCH(A18,Лист2!A:A,0))&\"c1\",0)","v":"Отдел5"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B19=\"Итого\"),MATCH(A19,Лист2!A:A,0)+1,MATCH(A19,Лист2!A:A,0))&\"c1\",0)","v":"Отдел5"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B20=\"Итого\"),MATCH(A20,Лист2!A:A,0)+1,MATCH(A20,Лист2!A:A,0))&\"c1\",0)","v":"Отдел5"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B21=\"Итого\"),MATCH(A21,Лист2!A:A,0)+1,MATCH(A21,Лист2!A:A,0))&\"c1\",0)","v":"Отдел5"},"ИТОГО",{"$f":"SUMIF($A$1:$A21,\"=\"&$A22,C$1:C21)","v":0},null,{"$f":"SUMIF($A$1:$A21,\"=\"&$A22,E$1:E21)","v":0},null,null,{"$f":"SUMIF($A$1:$A21,\"=\"&$A22,H$1:H21)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B22=\"Итого\"),MATCH(A22,Лист2!A:A,0)+1,MATCH(A22,Лист2!A:A,0))&\"c1\",0)","v":"Отдел6"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B23=\"Итого\"),MATCH(A23,Лист2!A:A,0)+1,MATCH(A23,Лист2!A:A,0))&\"c1\",0)","v":"Отдел6"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B24=\"Итого\"),MATCH(A24,Лист2!A:A,0)+1,MATCH(A24,Лист2!A:A,0))&\"c1\",0)","v":"Отдел6"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B25=\"Итого\"),MATCH(A25,Лист2!A:A,0)+1,MATCH(A25,Лист2!A:A,0))&\"c1\",0)","v":"Отдел6"},"ИТОГО",{"$f":"SUMIF($A$1:$A25,\"=\"&$A26,C$1:C25)","v":0},null,{"$f":"SUMIF($A$1:$A25,\"=\"&$A26,E$1:E25)","v":0},null,null,{"$f":"SUMIF($A$1:$A25,\"=\"&$A26,H$1:H25)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B26=\"Итого\"),MATCH(A26,Лист2!A:A,0)+1,MATCH(A26,Лист2!A:A,0))&\"c1\",0)","v":"Отдел7"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B27=\"Итого\"),MATCH(A27,Лист2!A:A,0)+1,MATCH(A27,Лист2!A:A,0))&\"c1\",0)","v":"Отдел7"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B28=\"Итого\"),MATCH(A28,Лист2!A:A,0)+1,MATCH(A28,Лист2!A:A,0))&\"c1\",0)","v":"Отдел7"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B29=\"Итого\"),MATCH(A29,Лист2!A:A,0)+1,MATCH(A29,Лист2!A:A,0))&\"c1\",0)","v":"Отдел7"},"ИТОГО",{"$f":"SUMIF($A$1:$A29,\"=\"&$A30,C$1:C29)","v":0},null,{"$f":"SUMIF($A$1:$A29,\"=\"&$A30,E$1:E29)","v":0},null,null,{"$f":"SUMIF($A$1:$A29,\"=\"&$A30,H$1:H29)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B30=\"Итого\"),MATCH(A30,Лист2!A:A,0)+1,MATCH(A30,Лист2!A:A,0))&\"c1\",0)","v":"Отдел8"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B31=\"Итого\"),MATCH(A31,Лист2!A:A,0)+1,MATCH(A31,Лист2!A:A,0))&\"c1\",0)","v":"Отдел8"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B32=\"Итого\"),MATCH(A32,Лист2!A:A,0)+1,MATCH(A32,Лист2!A:A,0))&\"c1\",0)","v":"Отдел8"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B33=\"Итого\"),MATCH(A33,Лист2!A:A,0)+1,MATCH(A33,Лист2!A:A,0))&\"c1\",0)","v":"Отдел8"},"ИТОГО",{"$f":"SUMIF($A$1:$A33,\"=\"&$A34,C$1:C33)","v":0},null,{"$f":"SUMIF($A$1:$A33,\"=\"&$A34,E$1:E33)","v":0},null,null,{"$f":"SUMIF($A$1:$A33,\"=\"&$A34,H$1:H33)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B34=\"Итого\"),MATCH(A34,Лист2!A:A,0)+1,MATCH(A34,Лист2!A:A,0))&\"c1\",0)","v":"Отдел9"}]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B35=\"Итого\"),MATCH(A35,Лист2!A:A,0)+1,MATCH(A35,Лист2!A:A,0))&\"c1\",0)","v":"Отдел9"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B36=\"Итого\"),MATCH(A36,Лист2!A:A,0)+1,MATCH(A36,Лист2!A:A,0))&\"c1\",0)","v":"Отдел9"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B37=\"Итого\"),MATCH(A37,Лист2!A:A,0)+1,MATCH(A37,Лист2!A:A,0))&\"c1\",0)","v":"Отдел9"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B38=\"Итого\"),MATCH(A38,Лист2!A:A,0)+1,MATCH(A38,Лист2!A:A,0))&\"c1\",0)","v":"Отдел9"},"ИТОГО",{"$f":"SUMIF($A$1:$A38,\"=\"&$A39,C$1:C38)","v":0},null,{"$f":"SUMIF($A$1:$A38,\"=\"&$A39,E$1:E38)","v":0},null,null,{"$f":"SUMIF($A$1:$A38,\"=\"&$A39,H$1:H38)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B39=\"Итого\"),MATCH(A39,Лист2!A:A,0)+1,MATCH(A39,Лист2!A:A,0))&\"c1\",0)","v":"Отдел10"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K40<>\"\",DATEDIF(K40,TODAY(),\"y\"),\"\")","v":""}]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B40=\"Итого\"),MATCH(A40,Лист2!A:A,0)+1,MATCH(A40,Лист2!A:A,0))&\"c1\",0)","v":"Отдел10"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B41=\"Итого\"),MATCH(A41,Лист2!A:A,0)+1,MATCH(A41,Лист2!A:A,0))&\"c1\",0)","v":"Отдел10"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B42=\"Итого\"),MATCH(A42,Лист2!A:A,0)+1,MATCH(A42,Лист2!A:A,0))&\"c1\",0)","v":"Отдел10"},"ИТОГО",{"$f":"SUMIF($A$1:$A42,\"=\"&$A43,C$1:C42)","v":0},null,{"$f":"SUMIF($A$1:$A42,\"=\"&$A43,E$1:E42)","v":0},null,null,{"$f":"SUMIF($A$1:$A42,\"=\"&$A43,H$1:H42)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B43=\"Итого\"),MATCH(A43,Лист2!A:A,0)+1,MATCH(A43,Лист2!A:A,0))&\"c1\",0)","v":"Отдел11"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B44=\"Итого\"),MATCH(A44,Лист2!A:A,0)+1,MATCH(A44,Лист2!A:A,0))&\"c1\",0)","v":"Отдел11"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B45=\"Итого\"),MATCH(A45,Лист2!A:A,0)+1,MATCH(A45,Лист2!A:A,0))&\"c1\",0)","v":"Отдел11"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B46=\"Итого\"),MATCH(A46,Лист2!A:A,0)+1,MATCH(A46,Лист2!A:A,0))&\"c1\",0)","v":"Отдел11"},"ИТОГО",{"$f":"SUMIF($A$1:$A46,\"=\"&$A47,C$1:C46)","v":0},null,{"$f":"SUMIF($A$1:$A46,\"=\"&$A47,E$1:E46)","v":0},null,null,{"$f":"SUMIF($A$1:$A46,\"=\"&$A47,H$1:H46)","v":0},null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B47=\"Итого\"),MATCH(A47,Лист2!A:A,0)+1,MATCH(A47,Лист2!A:A,0))&\"c1\",0)","v":"Отдел12"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B48=\"Итого\"),MATCH(A48,Лист2!A:A,0)+1,MATCH(A48,Лист2!A:A,0))&\"c1\",0)","v":"Отдел12"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B49=\"Итого\"),MATCH(A49,Лист2!A:A,0)+1,MATCH(A49,Лист2!A:A,0))&\"c1\",0)","v":"Отдел12"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B50=\"Итого\"),MATCH(A50,Лист2!A:A,0)+1,MATCH(A50,Лист2!A:A,0))&\"c1\",0)","v":"Отдел12"},"ИТОГО",{"$f":"SUMIF($A$1:$A50,\"=\"&$A51,C$1:C50)","v":0},null,{"$f":"SUMIF($A$1:$A50,\"=\"&$A51,E$1:E50)","v":0},null,null,{"$f":"SUMIF($A$1:$A50,\"=\"&$A51,H$1:H50)","v":0},null,null,null,{"$f":"IF(K51<>\"\",DATEDIF(K51,TODAY(),\"y\"),\"\")","v":""}]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B51=\"Итого\"),MATCH(A51,Лист2!A:A,0)+1,MATCH(A51,Лист2!A:A,0))&\"c1\",0)","v":"Отдел13"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B52=\"Итого\"),MATCH(A52,Лист2!A:A,0)+1,MATCH(A52,Лист2!A:A,0))&\"c1\",0)","v":"Отдел13"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B53=\"Итого\"),MATCH(A53,Лист2!A:A,0)+1,MATCH(A53,Лист2!A:A,0))&\"c1\",0)","v":"Отдел13"},null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"INDIRECT(\"Лист2!r\"&IF(OR(ROW()=3,B54=\"Итого\"),MATCH(A54,Лист2!A:A,0)+1,MATCH(A54,Лист2!A:A,0))&\"c1\",0)","v":"Отдел13"},"ИТОГО",{"$f":"SUMIF($A$1:$A54,\"=\"&$A55,C$1:C54)","v":0},null,{"$f":"SUMIF($A$1:$A54,\"=\"&$A55,E$1:E54)","v":0},null,null,{"$f":"SUMIF($A$1:$A54,\"=\"&$A55,H$1:H54)","v":0},null,null,null,""]
[" ",null,null,null,null,null,null,null,null,null,null,""]
[" ",null,{"$f":"SUMIF($B:$B,\"=ИТОГО\",C$1:C56)","v":0},null,{"$f":"SUMIF($B:$B,\"=ИТОГО\",E$1:E55)","v":0},null,null,{"$f":"SUMIF($B:$B,\"=ИТОГО\",H$1:H55)","v":0}]

{"sheet":"Лист2","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Отдел","Категория",null,null,"Категория"]
["Отдел1","АУП"]
["Отдел2","УВП"]
["Отдел3","ППС"]
["Отдел4","ОП"]
["Отдел5","НС"]
["Отдел6"]
["Отдел7"]
["Отдел8"]
["Отдел9"]
["Отдел10"]
["Отдел11"]
["Отдел12"]
["Отдел13"]

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