{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":11,"n_cols":39,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,30]]}
["ФИО"]
[null,"2019-11-01","2019-11-02","2019-11-03","2019-11-04","2019-11-05","2019-11-06","2019-11-07","2019-11-08","2019-11-09","2019-11-10","2019-11-11","2019-11-12","2019-11-13","2019-11-14","2019-11-15","2019-11-16","2019-11-17","2019-11-18","2019-11-19","2019-11-20","2019-11-21","2019-11-22","2019-11-23","2019-11-24","2019-11-25","2019-11-26","2019-11-27","2019-11-28","2019-11-29","2019-11-30","на работе","период","в коммандировке","период","отпуск","период","учеба","период"]
["BORISOV","Р","Р","Р","Р","Р","Р","О","О","О","О","О","О","К","К","К","К","Р","Р","Р","Р","Р","Р","Р","Р","Р","Р","У","У","У","Р",{"$f":"COUNTIF(B3:AE3,AG8)","v":17},{"$f":"u_4(B3:AE3,$AG$8,$B$2:$AE$2)","v":"01.11.2019-06.11.2019, 17.11.2019-26.11.2019, 30.11.2019"},{"$f":"COUNTIF(B3:AE3,AG10)","v":4},"здесь нужно показать дату когда сотрудник был на роботе",{"$f":"COUNTIF(B3:AE3,M3)","v":6},"здесь нужно показать дату когда сотрудник был в отпуске",{"$f":"COUNTIF(D3:AG3,AG11)","v":3},"здесь нужно показать дату когда сотрудник был на учебе"]
["UBISSKYI","К","К","К","К","Р","Р","Р","Р","Р","Р","Р","Р","У","У","У","У","У","У","У","У","О","О","О","О","О","О","О","У","У","Р",null,{"$f":"u_4(B4:AE4,$AG$8,$B$2:$AE$2)","v":"05.11.2019-12.11.2019, 30.11.2019"}]
["ZAKHARENKO","О","О","О","О","О","О","О","О","Р","Р","Р","Р","Р","Р","Р","Р","У","У","У","У","О","О","О","О","О","О","О","У","У","Р",{"$f":"COUNTIF(B5:AE5,AG10)","v":0},{"$f":"u_4(B5:AE5,$AG$8,$B$2:$AE$2)","v":"09.11.2019-16.11.2019, 30.11.2019"}]
[]
[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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,"У","учеба"]