{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Учет","Канцтовары","Сотрудники"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Дата","Вид","Фамилия","Количество","Лимит"]
[null,null,null,null,{"$f":"IFERROR(MAX(0,IF(ISBLANK(C2),\"\",(VLOOKUP(B2,Лимит,2,0)-SUMIFS(Количество,Фамилия,C2,Вид,B2)))),\"\")","v":""}]

{"sheet":"Канцтовары","index":1,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Номенклатура","Лимит","Расход","В наличии с учетом расхода","В наличии","Январь","Февраль","Март"]
["Буамга 200гр",{"$f":"IF(D2<=0,0,ROUNDUP(E2/(COUNTA(ФИО)),0))","v":2},{"$f":"SUMIF(Вид,A2,Количество)","v":0},{"$f":"E2-C2","v":14},{"$f":"SUM(F2:Q2)","v":14},5,4,5]
["Бумага для заметок",{"$f":"IF(D3<=0,0,ROUNDUP(E3/(COUNTA(ФИО)),0))","v":2},0,12,12,5,2,5]
["Бумага для записей",{"$f":"IF(D4<=0,0,ROUNDUP(E4/(COUNTA(ФИО)),0))","v":3},0,15,15,5,5,5]
["Бумага ксероксная",{"$f":"IF(D5<=0,0,ROUNDUP(E5/(COUNTA(ФИО)),0))","v":9},0,60,60,5,50,5]
["Дрель",{"$f":"IF(D6<=0,0,ROUNDUP(E6/(COUNTA(ФИО)),0))","v":1},0,6,6,2,2,2]
["Журнал входящей корреспонденции",{"$f":"IF(D7<=0,0,ROUNDUP(E7/(COUNTA(ФИО)),0))","v":2},0,13,13,5,3,5]
["Журнал исходящей корреспонденции",{"$f":"IF(D8<=0,0,ROUNDUP(E8/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]
["Зажим",{"$f":"IF(D9<=0,0,ROUNDUP(E9/(COUNTA(ФИО)),0))","v":7},0,46,46,5,36,5]
["Иголка",{"$f":"IF(D10<=0,0,ROUNDUP(E10/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]
["Карандаш",{"$f":"IF(D11<=0,0,ROUNDUP(E11/(COUNTA(ФИО)),0))","v":3},0,20,20,5,10,5]
["Карандаш клейкий",{"$f":"IF(D12<=0,0,ROUNDUP(E12/(COUNTA(ФИО)),0))","v":3},0,16,16,5,6,5]
["Краска штемпельная",{"$f":"IF(D13<=0,0,ROUNDUP(E13/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]
["Нитки",{"$f":"IF(D14<=0,0,ROUNDUP(E14/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]
["Папка входящей корреспонденции",{"$f":"IF(D15<=0,0,ROUNDUP(E15/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]
["Папка на 2 кольцах",{"$f":"IF(D16<=0,0,ROUNDUP(E16/(COUNTA(ФИО)),0))","v":3},0,15,15,5,5,5]
["Ручка",{"$f":"IF(D17<=0,0,ROUNDUP(E17/(COUNTA(ФИО)),0))","v":5},0,34,34,5,24,5]
["Ручка гелевая",{"$f":"IF(D18<=0,0,ROUNDUP(E18/(COUNTA(ФИО)),0))","v":2},0,13,13,5,3,5]
["Ручка корректирующая",{"$f":"IF(D19<=0,0,ROUNDUP(E19/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]
["Ручка на липучке (для заявителей)",{"$f":"IF(D20<=0,0,ROUNDUP(E20/(COUNTA(ФИО)),0))","v":3},0,16,16,5,6,5]
["Салфетки для монитора",{"$f":"IF(D21<=0,0,ROUNDUP(E21/(COUNTA(ФИО)),0))","v":3},0,16,16,5,6,5]
["Скобы бол",{"$f":"IF(D22<=0,0,ROUNDUP(E22/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]
["Скобы мал",{"$f":"IF(D23<=0,0,ROUNDUP(E23/(COUNTA(ФИО)),0))","v":3},0,20,20,5,10,5]
["Скоросшиватель",{"$f":"IF(D24<=0,0,ROUNDUP(E24/(COUNTA(ФИО)),0))","v":5},0,30,30,5,20,5]
["Скотч",{"$f":"IF(D25<=0,0,ROUNDUP(E25/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]
["Скрепки большие",{"$f":"IF(D26<=0,0,ROUNDUP(E26/(COUNTA(ФИО)),0))","v":6},0,36,36,5,26,5]
["Скрепки цветные",{"$f":"IF(D27<=0,0,ROUNDUP(E27/(COUNTA(ФИО)),0))","v":3},0,16,16,5,6,5]
["Стержни пишущие",{"$f":"IF(D28<=0,0,ROUNDUP(E28/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]
["Текстовыделитель",{"$f":"IF(D29<=0,0,ROUNDUP(E29/(COUNTA(ФИО)),0))","v":2},0,13,13,5,3,5]
["Термолента",{"$f":"IF(D30<=0,0,ROUNDUP(E30/(COUNTA(ФИО)),0))","v":4},0,22,22,5,12,5]
["Точилка",{"$f":"IF(D31<=0,0,ROUNDUP(E31/(COUNTA(ФИО)),0))","v":3},0,20,20,5,10,5]
["Уголок",{"$f":"IF(D32<=0,0,ROUNDUP(E32/(COUNTA(ФИО)),0))","v":3},0,15,15,5,5,5]
["Файл",{"$f":"IF(D33<=0,0,ROUNDUP(E33/(COUNTA(ФИО)),0))","v":30},0,210,210,5,200,5]
["Шило",{"$f":"IF(D34<=0,0,ROUNDUP(E34/(COUNTA(ФИО)),0))","v":2},0,11,11,5,1,5]
["Штрих",{"$f":"IF(D35<=0,0,ROUNDUP(E35/(COUNTA(ФИО)),0))","v":2},0,10,10,5,0,5]

{"sheet":"Сотрудники","index":2,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["ФИО"]
["Иванова И.И."]
["Кириллова И.И."]
["Кузнецова И.И."]
["Петрова И.И."]
["Потапова И.И."]
["Сидорова И.И."]
["Федорова И.И."]