{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["База","Лист1","Лист3","Лист4"],"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":"База","index":0,"n_rows":10,"n_cols":38,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["№\nп/п","ФИО","Примечания","Образование","Образование","Дата приема на работу","Дата\nпроверки","Текущая\nдата","Лет","Месяцев","Дней","Стаж для расчета (лет)","Лет","Месяцев","Дней","Стаж на текущую дату (лет)","Приказ\nо приеме","Листов","Приказ\nо переводе","Листов","ТД","Листов","Доп.\nСоглашение","Листов","Диплом\n(ВО)","Листов","Диплом\n(СПО)","Листов","ТК","Листов","УПК","Листов","Почетное звание","Листов","Ученая степень","Листов","Смена фамилии","Листов"]
[1,"Иванов ИИ",null,1,{"$f":"IF(B4=\"\",\"\",IF(D4=1,\"ВО\",IF(D4=0.5,\"СПО\",\"Б/О\")))","v":"ВО"},"2006-05-03","2017-07-07",{"$f":"TODAY()","v":"2020-11-25"},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"y\"))","v":11},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"ym\"))","v":2},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"md\"))","v":4},{"$f":"IF(OR(F4=0,G4=0),\"\",I4+J4/12+K4/365)","v":11.177625570776256},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"y\"))","v":14},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"ym\"))","v":6},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"md\"))","v":22},{"$f":"IF(OR(F4=0,H4=0),\"\",M4+N4/12+O4/365)","v":14.56027397260274},2,null,null,null,1,null,null,null,1,null,null,null,1]
[{"$f":"A4+1","v":2},"Петров ПП",null,1,{"$f":"IF(B5=\"\",\"\",IF(D5=1,\"ВО\",IF(D5=0.5,\"СПО\",\"Б/О\")))","v":"ВО"},"2010-06-07","2010-08-19",{"$f":"TODAY()","v":"2020-11-25"},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"y\"))","v":0},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"ym\"))","v":2},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"md\"))","v":12},{"$f":"IF(OR(F5=0,G5=0),\"\",I5+J5/12+K5/365)","v":0.19954337899543378},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"y\"))","v":10},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"ym\"))","v":5},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"md\"))","v":18},{"$f":"IF(OR(F5=0,H5=0),\"\",M5+N5/12+O5/365)","v":10.465981735159817},3,null,null,null,4,null,null,null,1,null,null,null,1]
[{"$f":"A5+1","v":3},null,null,null,"",null,null,"2020-11-25","","","","","","","","",3,null,null,null,4,null,null,null,1,null,null,null,1]
[{"$f":"A6+1","v":4},"Сидоров СС",null,1,"ВО","1998-08-03","2017-07-07","2020-11-25",18,11,4,18.927625570776257,22,3,22,22.31027397260274,1,null,null,null,3,null,null,null,2,null,null,null,1,null,2]
[5,"Антонов АА",null,0.5,"СПО","1983-02-28","1983-10-10","2020-11-25",0,7,12,0.61621004566210047,37,8,28,37.743378995433787,2,null,null,null,1,null,null,null,null,null,1,null,1]
[null,"Подсчет",null,{"$f":"SUM(D4:D8)","v":3.5},null,null,null,null,{"$f":"SUM(I4:I8)","v":29},22,32,30.921004566210048,83,22,90,85.079908675799089,11,0,0,0,13,0,0,0,5,0,1,0,5,0,2,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IFERROR(D9/COUNTA(B4:B8),0)","v":0.875},null,null,null,null,null,null,null,{"$f":"IFERROR(L9/COUNTA(B4:B8),0)","v":7.7302511415525119},null,null,null,{"$f":"IFERROR(P9/COUNTA(B4:B8),0)","v":21.269977168949772}]

{"sheet":"Лист1","index":1,"n_rows":10,"n_cols":38,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["№\nп/п","ФИО","Примечания","Образование","Образование","Дата приема на работу","Дата\nпроверки","Текущая\nдата","Лет","Месяцев","Дней","Стаж для расчета (лет)","Лет","Месяцев","Дней","Стаж на текущую дату (лет)","Приказ\nо приеме","Листов","Приказ\nо переводе","Листов","ТД","Листов","Доп.\nСоглашение","Листов","Диплом\n(ВО)","Листов","Диплом\n(СПО)","Листов","ТК","Листов","УПК","Листов","Почетное звание","Листов","Ученая степень","Листов","Смена фамилии","Листов"]
[1,"Иванов ИИ",null,1,{"$f":"IF(B4=\"\",\"\",IF(D4=1,\"ВО\",IF(D4=0.5,\"СПО\",\"Б/О\")))","v":"ВО"},"2006-05-03","2017-07-07",{"$f":"TODAY()","v":"2020-11-25"},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"y\"))","v":11},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"ym\"))","v":2},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"md\"))","v":4},{"$f":"IF(OR(F4=0,G4=0),\"\",I4+J4/12+K4/365)","v":11.177625570776256},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"y\"))","v":14},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"ym\"))","v":6},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"md\"))","v":22},{"$f":"IF(OR(F4=0,H4=0),\"\",M4+N4/12+O4/365)","v":14.56027397260274},2,null,null,null,1,null,null,null,1,null,null,null,1]
[{"$f":"A4+1","v":2},"Петров ПП",null,1,{"$f":"IF(B5=\"\",\"\",IF(D5=1,\"ВО\",IF(D5=0.5,\"СПО\",\"Б/О\")))","v":"ВО"},"2010-06-07","2010-08-19",{"$f":"TODAY()","v":"2020-11-25"},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"y\"))","v":0},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"ym\"))","v":2},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"md\"))","v":12},{"$f":"IF(OR(F5=0,G5=0),\"\",I5+J5/12+K5/365)","v":0.19954337899543378},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"y\"))","v":10},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"ym\"))","v":5},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"md\"))","v":18},{"$f":"IF(OR(F5=0,H5=0),\"\",M5+N5/12+O5/365)","v":10.465981735159817},3,null,null,null,4,null,null,null,1,null,null,null,1]
[{"$f":"A5+1","v":3},null,null,null,{"$f":"IF(B6=\"\",\"\",IF(D6=1,\"ВО\",IF(D6=0.5,\"СПО\",\"Б/О\")))","v":""},null,null,"2020-11-25",{"$f":"IF(OR(F6=0,G6=0),\"\",DATEDIF(F6,G6,\"y\"))","v":""},{"$f":"IF(OR(F6=0,G6=0),\"\",DATEDIF(F6,G6,\"ym\"))","v":""},{"$f":"IF(OR(F6=0,G6=0),\"\",DATEDIF(F6,G6,\"md\"))","v":""},{"$f":"IF(OR(F6=0,G6=0),\"\",I6+J6/12+K6/365)","v":""},{"$f":"IF(OR(F6=0,H6=0),\"\",DATEDIF(F6,H6,\"y\"))","v":""},{"$f":"IF(OR(F6=0,H6=0),\"\",DATEDIF(F6,H6,\"ym\"))","v":""},{"$f":"IF(OR(F6=0,H6=0),\"\",DATEDIF(F6,H6,\"md\"))","v":""},{"$f":"IF(OR(F6=0,H6=0),\"\",M6+N6/12+O6/365)","v":""},3,null,null,null,4,null,null,null,1,null,null,null,1]
[{"$f":"A6+1","v":4},"Сидоров СС",null,1,"ВО","1998-08-03","2017-07-07","2020-11-25",18,11,4,18.927625570776257,22,3,22,22.31027397260274,1,null,null,null,3,null,null,null,2,null,null,null,1,null,2]
[5,"Антонов АА",null,0.5,"СПО","1983-02-28","1983-10-10","2020-11-25",0,7,12,0.61621004566210047,37,8,28,37.743378995433787,2,null,null,null,1,null,null,null,null,null,1,null,1]
[null,"Подсчет",null,{"$f":"SUM(D4:D8)","v":3.5},null,null,null,null,{"$f":"SUM(I4:I8)","v":29},22,32,30.921004566210048,83,22,90,85.079908675799089,11,0,0,0,13,0,0,0,5,0,1,0,5,0,2,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IFERROR(D9/COUNTA(B4:B8),0)","v":0.875},null,null,null,null,null,null,null,{"$f":"IFERROR(L9/COUNTA(B4:B8),0)","v":7.7302511415525119},null,null,null,{"$f":"IFERROR(P9/COUNTA(B4:B8),0)","v":21.269977168949772}]

{"sheet":"Лист3","index":2,"n_rows":10,"n_cols":38,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["№\nп/п","ФИО","Примечания","Образование","Образование","Дата приема на работу","Дата\nпроверки","Текущая\nдата","Лет","Месяцев","Дней","Стаж для расчета (лет)","Лет","Месяцев","Дней","Стаж на текущую дату (лет)","Приказ\nо приеме","Листов","Приказ\nо переводе","Листов","ТД","Листов","Доп.\nСоглашение","Листов","Диплом\n(ВО)","Листов","Диплом\n(СПО)","Листов","ТК","Листов","УПК","Листов","Почетное звание","Листов","Ученая степень","Листов","Смена фамилии","Листов"]
[1,"Иванов ИИ",null,1,{"$f":"IF(B4=\"\",\"\",IF(D4=1,\"ВО\",IF(D4=0.5,\"СПО\",\"Б/О\")))","v":"ВО"},"2006-05-03","2017-07-07",{"$f":"TODAY()","v":"2020-11-25"},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"y\"))","v":11},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"ym\"))","v":2},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"md\"))","v":4},{"$f":"IF(OR(F4=0,G4=0),\"\",I4+J4/12+K4/365)","v":11.177625570776256},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"y\"))","v":14},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"ym\"))","v":6},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"md\"))","v":22},{"$f":"IF(OR(F4=0,H4=0),\"\",M4+N4/12+O4/365)","v":14.56027397260274},2,null,null,null,1,null,null,null,1,null,null,null,1]
[{"$f":"A4+1","v":2},"Петров ПП",null,1,{"$f":"IF(B5=\"\",\"\",IF(D5=1,\"ВО\",IF(D5=0.5,\"СПО\",\"Б/О\")))","v":"ВО"},"2010-06-07","2010-08-19",{"$f":"TODAY()","v":"2020-11-25"},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"y\"))","v":0},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"ym\"))","v":2},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"md\"))","v":12},{"$f":"IF(OR(F5=0,G5=0),\"\",I5+J5/12+K5/365)","v":0.19954337899543378},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"y\"))","v":10},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"ym\"))","v":5},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"md\"))","v":18},{"$f":"IF(OR(F5=0,H5=0),\"\",M5+N5/12+O5/365)","v":10.465981735159817},3,null,null,null,4,null,null,null,1,null,null,null,1]
[{"$f":"A5+1","v":3},null,null,null,"",null,null,"2020-11-25","","","","","","","","",3,null,null,null,4,null,null,null,1,null,null,null,1]
[{"$f":"A6+1","v":4},"Сидоров СС",null,1,"ВО","1998-08-03","2017-07-07","2020-11-25",18,11,4,18.927625570776257,22,3,22,22.31027397260274,1,null,null,null,3,null,null,null,2,null,null,null,1,null,2]
[5,"Антонов АА",null,0.5,"СПО","1983-02-28","1983-10-10","2020-11-25",0,7,12,0.61621004566210047,37,8,28,37.743378995433787,2,null,null,null,1,null,null,null,null,null,1,null,1]
[null,"Подсчет",null,{"$f":"SUM(D4:D8)","v":3.5},null,null,null,null,{"$f":"SUM(I4:I8)","v":29},22,32,30.921004566210048,83,22,90,85.079908675799089,11,0,0,0,13,0,0,0,5,0,1,0,5,0,2,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IFERROR(D9/COUNTA(B4:B8),0)","v":0.875},null,null,null,null,null,null,null,{"$f":"IFERROR(L9/COUNTA(B4:B8),0)","v":7.7302511415525119},null,null,null,{"$f":"IFERROR(P9/COUNTA(B4:B8),0)","v":21.269977168949772}]

{"sheet":"Лист4","index":3,"n_rows":10,"n_cols":38,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["№\nп/п","ФИО","Примечания","Образование","Образование","Дата приема на работу","Дата\nпроверки","Текущая\nдата","Лет","Месяцев","Дней","Стаж для расчета (лет)","Лет","Месяцев","Дней","Стаж на текущую дату (лет)","Приказ\nо приеме","Листов","Приказ\nо переводе","Листов","ТД","Листов","Доп.\nСоглашение","Листов","Диплом\n(ВО)","Листов","Диплом\n(СПО)","Листов","ТК","Листов","УПК","Листов","Почетное звание","Листов","Ученая степень","Листов","Смена фамилии","Листов"]
[1,"Иванов ИИ",null,1,{"$f":"IF(B4=\"\",\"\",IF(D4=1,\"ВО\",IF(D4=0.5,\"СПО\",\"Б/О\")))","v":"ВО"},"2006-05-03","2017-07-07",{"$f":"TODAY()","v":"2020-11-25"},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"y\"))","v":11},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"ym\"))","v":2},{"$f":"IF(OR(F4=0,G4=0),\"\",DATEDIF(F4,G4,\"md\"))","v":4},{"$f":"IF(OR(F4=0,G4=0),\"\",I4+J4/12+K4/365)","v":11.177625570776256},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"y\"))","v":14},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"ym\"))","v":6},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"md\"))","v":22},{"$f":"IF(OR(F4=0,H4=0),\"\",M4+N4/12+O4/365)","v":14.56027397260274},2,null,null,null,1,null,null,null,1,null,null,null,1]
[{"$f":"A4+1","v":2},"Петров ПП",null,1,{"$f":"IF(B5=\"\",\"\",IF(D5=1,\"ВО\",IF(D5=0.5,\"СПО\",\"Б/О\")))","v":"ВО"},"2010-06-07","2010-08-19",{"$f":"TODAY()","v":"2020-11-25"},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"y\"))","v":0},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"ym\"))","v":2},{"$f":"IF(OR(F5=0,G5=0),\"\",DATEDIF(F5,G5,\"md\"))","v":12},{"$f":"IF(OR(F5=0,G5=0),\"\",I5+J5/12+K5/365)","v":0.19954337899543378},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"y\"))","v":10},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"ym\"))","v":5},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"md\"))","v":18},{"$f":"IF(OR(F5=0,H5=0),\"\",M5+N5/12+O5/365)","v":10.465981735159817},3,null,null,null,4,null,null,null,1,null,null,null,1]
[{"$f":"A5+1","v":3},null,null,null,"",null,null,"2020-11-25","","","","","","","","",3,null,null,null,4,null,null,null,1,null,null,null,1]
[{"$f":"A6+1","v":4},"Сидоров СС",null,1,"ВО","1998-08-03","2017-07-07","2020-11-25",18,11,4,18.927625570776257,22,3,22,22.31027397260274,1,null,null,null,3,null,null,null,2,null,null,null,1,null,2]
[5,"Антонов АА",null,0.5,"СПО","1983-02-28","1983-10-10","2020-11-25",0,7,12,0.61621004566210047,37,8,28,37.743378995433787,2,null,null,null,1,null,null,null,null,null,1,null,1]
[null,"Подсчет",null,{"$f":"SUM(D4:D8)","v":3.5},null,null,null,null,{"$f":"SUM(I4:I8)","v":29},22,32,30.921004566210048,83,22,90,85.079908675799089,11,0,0,0,13,0,0,0,5,0,1,0,5,0,2,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IFERROR(D9/COUNTA(B4:B8),0)","v":0.875},null,null,null,null,null,null,null,{"$f":"IFERROR(L9/COUNTA(B4:B8),0)","v":7.7302511415525119},null,null,null,{"$f":"IFERROR(P9/COUNTA(B4:B8),0)","v":21.269977168949772}]