{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","график","график_1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["2013-11-27T20:49:00"]
["2013-11-28T20:48:59.995"]
["2013-11-29T20:48:59.995"]
["2013-11-30T20:48:59.995"]
["2013-12-01T20:48:59.995"]
["2014-01-06T20:49:00",{"$f":"VLOOKUP(--VLOOKUP(TRUNC(A6),график_1!A$1:B$62,2,),график_1!G$1:H$3,2,)","v":"Иванов"}]
[]
[]
[]
["Необходимо чтоб при вводе даты в столбце В проставлялось фио чья смена"]
["Возможно конструктивно изменить сам график (лист \"график\")"]

{"sheet":"график","index":1,"n_rows":9,"n_cols":32,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"2013-12-01","2013-12-02","2013-12-03","2013-12-04","2013-12-05","2013-12-06","2013-12-07","2013-12-08","2013-12-09","2013-12-10","2013-12-11","2013-12-12","2013-12-13","2013-12-14","2013-12-15","2013-12-16","2013-12-17","2013-12-18","2013-12-19","2013-12-20","2013-12-21","2013-12-22","2013-12-23","2013-12-24","2013-12-25","2013-12-26","2013-12-27","2013-12-28","2013-12-29","2013-12-30","2013-12-31"]
["Иванов",1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1]
["Петров ",null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1]
["Сидоров",null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1]
[]
[null,"2014-01-01","2014-01-02","2014-01-03","2014-01-04","2014-01-05","2014-01-06","2014-01-07","2014-01-08","2014-01-09","2014-01-10","2014-01-11","2014-01-12","2014-01-13","2014-01-14","2014-01-15","2014-01-16","2014-01-17","2014-01-18","2014-01-19","2014-01-20","2014-01-21","2014-01-22","2014-01-23","2014-01-24","2014-01-25","2014-01-26","2014-01-27","2014-01-28","2014-01-29","2014-01-30"]
["Иванов",1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1]
["Петров ",null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1]
["Сидоров",null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,1,1]

{"sheet":"график_1","index":2,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[null,"Код",null,null,null,null,1,"Иванов"]
["2013-12-01",1,null,null,null,null,2,"Петров "]
["2013-12-02",1,null,null,null,null,3,"Сидоров"]
["2013-12-03",2]
["2013-12-04",2]
["2013-12-05",3]
["2013-12-06",3]
["2013-12-07",1]
["2013-12-08",1]
["2013-12-09",2]
["2013-12-10",2]
["2013-12-11",3]
["2013-12-12",3]
["2013-12-13",1]
["2013-12-14",1]
["2013-12-15",2]
["2013-12-16",2]
["2013-12-17",3]
["2013-12-18",3]
["2013-12-19",1]
["2013-12-20",1]
["2013-12-21",2]
["2013-12-22",2]
["2013-12-23",3]
["2013-12-24",3]
["2013-12-25",1]
["2013-12-26",1]
["2013-12-27",2]
["2013-12-28",2]
["2013-12-29",3]
["2013-12-30",3]
["2013-12-31",1]
["2014-01-01",1]
["2014-01-02",2]
["2014-01-03",2]
["2014-01-04",3]
["2014-01-05",3]
["2014-01-06",1]
["2014-01-07",1]
["2014-01-08",2]
["2014-01-09",2]
["2014-01-10",3]
["2014-01-11",3]
["2014-01-12",1]
["2014-01-13",1]
["2014-01-14",2]
["2014-01-15",2]
["2014-01-16",3]
["2014-01-17",3]
["2014-01-18",1]
["2014-01-19",1]
["2014-01-20",2]
["2014-01-21",2]
["2014-01-22",3]
["2014-01-23",3]
["2014-01-24",1]
["2014-01-25",1]
["2014-01-26",2]
["2014-01-27",2]
["2014-01-28",3]
["2014-01-29",3]
["2014-01-30",1]