{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":11,"n_cols":38,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["№\nп/п","ФИО","Примечания","Образование","Образование","Дата приема на работу","Дата\nпроверки","Текущая\nдата","Лет","Месяцев","Дней","Стаж для расчета (лет)","Лет","Месяцев","Дней","Стаж на текущую дату (лет)","Приказ\nо приеме","Листов","Приказ\nо переводе","Листов","ТД","Листов","Доп.\nСоглашение","Листов","Диплом\n(ВО)","Листов","Диплом\n(СПО)","Листов","ТК","Листов","УПК","Листов","Почетное звание","Листов","Ученая степень","Листов","Смена фамилии","Листов"]
[{"$f":"SUM(INDEX(A:A,ROW()-1),1)","v":1},"Иванов ИИ",null,1,{"$f":"IF(B4=\"\",\"\",IF(D4=1,\"ВО\",IF(D4=0.5,\"СПО\",\"Б/О\")))","v":"ВО"},"2006-05-03","2017-07-07",{"$f":"TODAY()","v":"2017-07-17"},{"$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":11},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"ym\"))","v":2},{"$f":"IF(OR(F4=0,H4=0),\"\",DATEDIF(F4,H4,\"md\"))","v":14},{"$f":"IF(OR(F4=0,H4=0),\"\",M4+N4/12+O4/365)","v":11.205022831050227},2,null,null,null,1,null,null,null,1,null,null,null,1]
[{"$f":"SUM(INDEX(A:A,ROW()-1),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":"2017-07-17"},{"$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":7},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"ym\"))","v":1},{"$f":"IF(OR(F5=0,H5=0),\"\",DATEDIF(F5,H5,\"md\"))","v":10},{"$f":"IF(OR(F5=0,H5=0),\"\",M5+N5/12+O5/365)","v":7.1107305936073057},3,null,null,null,4,null,null,null,1,null,null,null,1]
[{"$f":"SUM(INDEX(A:A,ROW()-1),1)","v":3},null,null,null,"","2011-10-03","2012-08-24","2017-07-17",0,10,21,0.89086757990867582,5,9,14,5.7883561643835613]
[{"$f":"SUM(INDEX(A:A,ROW()-1),1)","v":4},null,null,null,"","2013-04-05","2017-07-07","2017-07-17",4,3,2,4.2554794520547947,4,3,12,4.2828767123287674]
[{"$f":"SUM(INDEX(A:A,ROW()-1),1)","v":5},"Сидоров СС",null,1,"ВО","1998-08-03","2017-07-07","2017-07-17",18,11,4,18.927625570776257,18,11,14,18.955022831050229,1,null,null,null,3,null,null,null,2,null,null,null,1,null,2]
[{"$f":"SUM(INDEX(A:A,ROW()-1),1)","v":6},"Антонов АА",null,0.5,"СПО","1983-02-28","1983-10-10","2017-07-17",0,7,12,0.61621004566210047,34,4,19,34.385388127853886,2,null,null,null,1,null,null,null,null,null,1,null,1]
[null,"Подсчет",null,{"$f":"SUM(D4:INDEX(D:D,ROW()-1))","v":3.5},null,null,null,null,{"$f":"SUM(I4:INDEX(I:I,ROW()-1))","v":33},{"$f":"SUM(J4:INDEX(J:J,ROW()-1))","v":35},{"$f":"SUM(K4:INDEX(K:K,ROW()-1))","v":55},{"$f":"SUM(L4:INDEX(L:L,ROW()-1))","v":36.067351598173516},{"$f":"SUM(M4:INDEX(M:M,ROW()-1))","v":79},{"$f":"SUM(N4:INDEX(N:N,ROW()-1))","v":30},{"$f":"SUM(O4:INDEX(O:O,ROW()-1))","v":83},{"$f":"SUM(P4:INDEX(P:P,ROW()-1))","v":81.727397260273975},{"$f":"SUM(Q4:INDEX(Q:Q,ROW()-1))","v":8},{"$f":"SUM(R4:INDEX(R:R,ROW()-1))","v":0},{"$f":"SUM(S4:INDEX(S:S,ROW()-1))","v":0},{"$f":"SUM(T4:INDEX(T:T,ROW()-1))","v":0},{"$f":"SUM(U4:INDEX(U:U,ROW()-1))","v":9},{"$f":"SUM(V4:INDEX(V:V,ROW()-1))","v":0},{"$f":"SUM(W4:INDEX(W:W,ROW()-1))","v":0},{"$f":"SUM(X4:INDEX(X:X,ROW()-1))","v":0},{"$f":"SUM(Y4:INDEX(Y:Y,ROW()-1))","v":4},{"$f":"SUM(Z4:INDEX(Z:Z,ROW()-1))","v":0},{"$f":"SUM(AA4:INDEX(AA:AA,ROW()-1))","v":1},{"$f":"SUM(AB4:INDEX(AB:AB,ROW()-1))","v":0},{"$f":"SUM(AC4:INDEX(AC:AC,ROW()-1))","v":4},{"$f":"SUM(AD4:INDEX(AD:AD,ROW()-1))","v":0},{"$f":"SUM(AE4:INDEX(AE:AE,ROW()-1))","v":2},{"$f":"SUM(AF4:INDEX(AF:AF,ROW()-1))","v":0},{"$f":"SUM(AG4:INDEX(AG:AG,ROW()-1))","v":0},{"$f":"SUM(AH4:INDEX(AH:AH,ROW()-1))","v":0},{"$f":"SUM(AI4:INDEX(AI:AI,ROW()-1))","v":0},{"$f":"SUM(AJ4:INDEX(AJ:AJ,ROW()-1))","v":0},{"$f":"SUM(AK4:INDEX(AK:AK,ROW()-1))","v":0},{"$f":"SUM(AL4:INDEX(AL:AL,ROW()-1))","v":0}]
[null,null,null,{"$f":"IFERROR(D10/COUNTA($B$4:INDEX($B:$B,ROW()-2)),0)","v":0.875},null,null,null,null,null,null,null,{"$f":"IFERROR(L10/COUNTA($B$4:INDEX($B:$B,ROW()-2)),0)","v":9.0168378995433791},null,null,null,{"$f":"IFERROR(P10/COUNTA($B$4:INDEX($B:$B,ROW()-2)),0)","v":20.431849315068494}]