{"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":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":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Убыл","Прибыл",null,null,"цифры","кол-во"]
[7455575,7455575,{"$f":"VLOOKUP(B2,$G$16:$J$110,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(A2>0,1,0)","v":1},{"$f":"IF(B2>0,1,0)","v":1},{"$f":"SUM(E2:E1000)-SUM(D2:D1000)","v":4},null,null,null,null,null,{"$f":"VLOOKUP(A2,$G$5:$N$110,8,FALSE)","v":{"$error":"#N/A"}},null,"убыл"]
[7465543,7465543,{"$error":"#N/A"},{"$f":"IF(A3>0,1,0)","v":1},{"$f":"IF(B3>0,1,0)","v":1},null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[7453079,7476067,{"$error":"#N/A"},1,1,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[7469991,7469991,{"$error":"#N/A"},1,1,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[7477213,7477213,{"$error":"#N/A"},1,1,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,7464884,{"$error":"#N/A"},0,1,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,7472719,{"$error":"#N/A"},0,1,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,7456049,{"$error":"#N/A"},0,1,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,7476067,{"$error":"#N/A"},0,1,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,0,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,null,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,null,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,{"$error":"#N/A"},0,null,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,"убыл"]

{"sheet":"Лист2","index":1,"n_rows":41,"n_cols":62,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Код","Дата, время","Фамилия","Количество сотрудников"]
[7455575,"2018-12-09T12:29:36",{"$f":"VLOOKUP(A2,$BG$5:$BJ$110,3,FALSE)","v":"иванов"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C1,C2),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[7456049,"2018-12-09T12:29:44",{"$f":"VLOOKUP(A3,$BG$5:$BJ$110,3,FALSE)","v":"петров"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C2,C3),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[7456049,"2018-12-09T12:29:48","петров",{"$f":"CHOOSE(MOD(COUNTIF(C$1:C3,C4),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"},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,"наименование","стоимость ","инвентарный","кабинет"]
[7453079,"2018-12-09T12:32:15","Хлыбов",{"$f":"CHOOSE(MOD(COUNTIF(C$1:C4,C5),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"},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,7455575,10,"иванов",99]
[7472719,"2018-12-09T12:32:15","вася",{"$f":"CHOOSE(MOD(COUNTIF(C$1:C5,C6),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"},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,7456049,20,"петров",88]
[7476067,"2018-12-09T12:32:15","паша",{"$f":"CHOOSE(MOD(COUNTIF(C$1:C6,C7),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"},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,7469991,30,"сидоров",77]
[7453079,"2018-12-09T12:32:34","Хлыбов",{"$f":"CHOOSE(MOD(COUNTIF(C$1:C7,C8),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"},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,7453079,40,"Хлыбов",66]
[7453079,"2018-12-09T12:32:40","Хлыбов",{"$f":"CHOOSE(MOD(COUNTIF(C$1:C8,C9),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"},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,7472719,50,"вася",55]
[7453079,"2018-12-09T12:47:45","Хлыбов",{"$f":"CHOOSE(MOD(COUNTIF(C$1:C9,C10),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"},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,7476067,60,"паша",44]
[7453079,"2018-12-09T12:47:48","Хлыбов",{"$f":"CHOOSE(MOD(COUNTIF(C$1:C10,C11),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[7453079,"2018-12-09T12:47:50","Хлыбов",{"$f":"CHOOSE(MOD(COUNTIF(C$1:C11,C12),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C12,C13),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"},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,7464884,null,"dsdg"]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C13,C14),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"},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,7477213,null,"rtert"]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C14,C15),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"},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,7465543,null,"gtnhjdbx"]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C15,C16),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C16,C17),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C17,C18),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C18,C19),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C19,C20),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C20,C21),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C21,C22),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C22,C23),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C23,C24),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C24,C25),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C25,C26),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C26,C27),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C27,C28),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C28,C29),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C29,C30),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C30,C31),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C31,C32),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C32,C33),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C33,C34),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C34,C35),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C35,C36),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C36,C37),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C37,C38),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C38,C39),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C39,C40),2)+1,\"Прибыл\",\"Убыл\")","v":"Убыл"}]
[null,null,{"$error":"#N/A"},{"$f":"CHOOSE(MOD(COUNTIF(C$1:C40,C41),2)+1,\"Прибыл\",\"Убыл\")","v":"Прибыл"}]

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