{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["мужчины","женщины","Лист1","По месяцам"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"мужчины","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[38,0,38,7],[21,0,21,7]]}
[]
[]
[]
[]
[]
["Ринат",null,null,null,null,"инженер 1 категории",null,"Сегодня ",{"$f":"TODAY()","v":"2019-01-17"}]
[null,"дата увольнения",null,"рост","182-188","одежда","96-100","обувь",44]
[]
["№ п/п","Наименование СИЗ","н/н","цена","дата выдачи","срок носки, мес","дата списания","износ","Закупка"]
[1,"Костюм летний",null,null,"2018-03-22",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2019-03-22"},{"$f":"IF(E10=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E10)/($G10-$E10),($C$7-$E10)/($G10-$E10)))","v":0.1753424657534246},{"$f":"IF(H10<0,1,0)","v":0}]
[2,"Ботинки с защитным подноском",null,null,"2018-09-24",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2019-09-24"},0.68493150684931514,{"$f":"IF(H11<0,1,0)","v":0}]
[3,"Перчатки с полимерным покрытием",null,null,"2018-12-28",1,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2019-01-28"},0.35483870967741937,0]
[4,"Каска защитная",null,null,"2018-02-27",24,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2020-02-27"},{"$f":"IF(E13=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E13)/($G13-$E13),($C$7-$E13)/($G13-$E13)))","v":0.55616438356164388},0]
[5,"Тапочки кожанные",null,null,"2018-07-20",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2019-07-20"},0.50410958904109582,0]
[6,"Очки защитные",null,null,"2018-10-29",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2019-10-29"},0.78082191780821919,0]
[7,"Боты или галоши диэлектрические",null,null,"2018-02-13",36,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2021-02-13"},{"$f":"IF(E16=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E16)/($G16-$E16),($C$7-$E16)/($G16-$E16)))","v":0.69160583941605847},0]
[8,"Перчатки диэлектрические",null,null,"2018-02-13",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2019-02-13"},7.3972602739726057E-2,0]
[9,"Костюм утепленный",null,null,"2017-10-13",24,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2019-10-13"},0.36849315068493149,0]
[10,"Ботинки утепленныес защитным подноском",null,null,"2018-03-22",18,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2019-09-22"},0.45173041894353372,0]
[11,"Перчатки полимерные утепленные",null,null,"2018-09-24",6,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2019-03-24"},0.36464088397790051,0]
[12,"Подшлемник под каску утепленный",null,null,"2018-09-24",24,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2020-09-24"},0.84268125854993159,0]
[]
["Костя",null,null,null,null,"инженер 1 категории",null,"Сегодня ",{"$f":"TODAY()","v":"2019-01-17"}]
[null,"дата увольнения",null,"рост","182-188","одежда","96-100","обувь",44]
[]
["№ п/п","Наименование СИЗ","н/н","цена","дата выдачи","срок носки, мес","дата списания","износ","Закупка"]
[1,"Костюм летний",null,null,"2018-03-22",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2019-03-22"},{"$f":"IF(E27=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E27)/($G27-$E27),($C$7-$E27)/($G27-$E27)))","v":0.1753424657534246},{"$f":"IF(H27<0,1,0)","v":0}]
[2,"Ботинки с защитным подноском",null,null,"2018-09-24",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2019-09-24"},0.68493150684931514,{"$f":"IF(H28<0,1,0)","v":0}]
[3,"Перчатки с полимерным покрытием",null,null,"2018-12-28",1,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2019-01-28"},0.35483870967741937,0]
[4,"Каска защитная",null,null,"2018-02-27",24,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2020-02-27"},0.55616438356164388,0]
[5,"Тапочки кожанные",null,null,"2018-07-20",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2019-07-20"},0.50410958904109582,0]
[6,"Очки защитные",null,null,"2018-10-29",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2019-10-29"},0.78082191780821919,0]
[7,"Боты или галоши диэлектрические",null,null,"2018-02-13",36,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2021-02-13"},0.69160583941605847,0]
[8,"Перчатки диэлектрические",null,null,"2018-02-13",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2019-02-13"},7.3972602739726057E-2,0]
[9,"Костюм утепленный",null,null,"2017-10-13",24,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2019-10-13"},0.36849315068493149,0]
[10,"Ботинки утепленныес защитным подноском",null,null,"2018-03-22",18,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2019-09-22"},0.45173041894353372,0]
[11,"Перчатки полимерные утепленные",null,null,"2018-09-24",6,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2019-03-24"},0.36464088397790051,0]
[12,"Подшлемник под каску утепленный",null,null,"2018-09-24",24,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2020-09-24"},0.84268125854993159,0]

{"sheet":"женщины","index":1,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[21,0,21,7],[38,0,38,7]]}
[]
[]
[]
[]
[]
["Флюра",null,null,null,null,"инженер",null,"Сегодня ",{"$f":"TODAY()","v":"2019-01-17"}]
[null,"дата увольнения",null,"рост","158-164","одежда","88-92","обувь",36]
[]
["№ п/п","Наименование СИЗ","н/н","цена","дата выдачи","срок носки, мес","дата списания","износ","Закупка"]
[1,"Костюм летний",null,null,"2018-03-22",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2019-03-22"},{"$f":"IF(E10=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E10)/($G10-$E10),($C$7-$E10)/($G10-$E10)))","v":0.1753424657534246},{"$f":"IF(H10<0,1,0)","v":0}]
[2,"Ботинки с защитным подноском",null,null,"2018-09-24",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2019-09-24"},0.68493150684931514,{"$f":"IF(H11<0,1,0)","v":0}]
[3,"Перчатки с полимерным покрытием",null,null,"2018-12-28",1,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2019-01-28"},0.35483870967741937,0]
[4,"Каска защитная",null,null,"2018-02-27",24,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2020-02-27"},0.55616438356164388,0]
[5,"Тапочки кожанные",null,null,"2018-07-20",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2019-07-20"},0.50410958904109582,0]
[6,"Очки защитные",null,null,"2018-10-29",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2019-10-29"},0.78082191780821919,0]
[7,"Боты или галоши диэлектрические",null,null,"2018-02-13",36,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2021-02-13"},0.69160583941605847,0]
[8,"Перчатки диэлектрические",null,null,"2018-02-13",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2019-02-13"},7.3972602739726057E-2,0]
[9,"Костюм утепленный",null,null,"2017-10-13",24,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2019-10-13"},0.36849315068493149,0]
[10,"Ботинки утепленныес защитным подноском",null,null,"2018-03-22",18,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2019-09-22"},0.45173041894353372,0]
[11,"Перчатки полимерные утепленные",null,null,"2018-09-24",6,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2019-03-24"},0.36464088397790051,0]
[12,"Подшлемник под каску утепленный",null,null,"2018-09-24",24,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2020-09-24"},0.84268125854993159,0]
[]
["Резеда",null,null,null,null,"инженер",null,"Сегодня ",{"$f":"TODAY()","v":"2019-01-17"}]
[null,"дата увольнения",null,"рост","158-164","одежда","88-92","обувь",36]
[]
["№ п/п","Наименование СИЗ","н/н","цена","дата выдачи","срок носки, мес","дата списания","износ","Закупка"]
[1,"Костюм летний",null,null,"2018-03-22",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2019-03-22"},{"$f":"IF(E27=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E27)/($G27-$E27),($C$7-$E27)/($G27-$E27)))","v":0.1753424657534246},{"$f":"IF(H27<0,1,0)","v":0}]
[2,"Ботинки с защитным подноском",null,null,"2018-09-24",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2019-09-24"},0.68493150684931514,{"$f":"IF(H28<0,1,0)","v":0}]
[3,"Перчатки с полимерным покрытием",null,null,"2018-12-28",1,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2019-01-28"},0.35483870967741937,0]
[4,"Каска защитная",null,null,"2018-02-27",24,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2020-02-27"},0.55616438356164388,0]
[5,"Тапочки кожанные",null,null,"2018-07-20",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2019-07-20"},0.50410958904109582,0]
[6,"Очки защитные",null,null,"2018-10-29",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2019-10-29"},0.78082191780821919,0]
[7,"Боты или галоши диэлектрические",null,null,"2018-02-13",36,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2021-02-13"},0.69160583941605847,0]
[8,"Перчатки диэлектрические",null,null,"2018-02-13",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2019-02-13"},7.3972602739726057E-2,0]
[9,"Костюм утепленный",null,null,"2017-10-13",24,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2019-10-13"},0.36849315068493149,0]
[10,"Ботинки утепленныес защитным подноском",null,null,"2018-03-22",18,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2019-09-22"},0.45173041894353372,0]
[11,"Перчатки полимерные утепленные",null,null,"2018-09-24",6,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2019-03-24"},0.36464088397790051,0]
[12,"Подшлемник под каску утепленный",null,null,"2018-09-24",24,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2020-09-24"},0.84268125854993159,0]

{"sheet":"Лист1","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,8,0],[9,0,16,0]]}
["март","ФИО","Наименование СИЗ","Рост/Размер","Обувь","Кол-во"]
[null,"Костя","костюм летний","182-188/96-100",null,1]
[null,"Ринат","обувь летняя",null,44,1]
[]
[]
[]
[]
[]
[]
["апрель","Резеда","очки",null,null,1]
[null,"Флюра","перчатки зимнии",null,null,1]

{"sheet":"По месяцам","index":3,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Месяц","ФИО","Наименование СИЗ","Рост/Размер","Обувь","Кол-во"]
["Январь 2019","Ринат","Перчатки с полимерным покрытием","182-188/96-100",44,1]
[null,"Костя","Перчатки с полимерным покрытием","182-188/96-100",44,1]
[null,"Резеда","Перчатки с полимерным покрытием","158-164/88-92",36,1]
[null,"Флюра","Перчатки с полимерным покрытием","158-164/88-92",36,1]
["Февраль 2019","Ринат","Каска защитная","182-188/96-100",44,1]
[null,"Ринат","Боты или галоши диэлектрические","182-188/96-100",44,1]
[null,"Ринат","Перчатки диэлектрические","182-188/96-100",44,1]
[null,"Костя","Каска защитная","182-188/96-100",44,1]
[null,"Костя","Боты или галоши диэлектрические","182-188/96-100",44,1]
[null,"Костя","Перчатки диэлектрические","182-188/96-100",44,1]
[null,"Резеда","Каска защитная","158-164/88-92",36,1]
[null,"Резеда","Боты или галоши диэлектрические","158-164/88-92",36,1]
[null,"Резеда","Перчатки диэлектрические","158-164/88-92",36,1]
[null,"Флюра","Каска защитная","158-164/88-92",36,1]
[null,"Флюра","Боты или галоши диэлектрические","158-164/88-92",36,1]
[null,"Флюра","Перчатки диэлектрические","158-164/88-92",36,1]
["Март 2019","Ринат","Костюм летний","182-188/96-100",44,1]
[null,"Ринат","Перчатки полимерные утепленные","182-188/96-100",44,1]
[null,"Костя","Костюм летний","182-188/96-100",44,1]
[null,"Костя","Перчатки полимерные утепленные","182-188/96-100",44,1]
[null,"Резеда","Костюм летний","158-164/88-92",36,1]
[null,"Резеда","Перчатки полимерные утепленные","158-164/88-92",36,1]
[null,"Флюра","Костюм летний","158-164/88-92",36,1]
[null,"Флюра","Перчатки полимерные утепленные","158-164/88-92",36,1]
["Июль 2019","Ринат","Тапочки кожанные","182-188/96-100",44,1]
[null,"Костя","Тапочки кожанные","182-188/96-100",44,1]
[null,"Резеда","Тапочки кожанные","158-164/88-92",36,1]
[null,"Флюра","Тапочки кожанные","158-164/88-92",36,1]
["Сентябрь 2019","Ринат","Ботинки с защитным подноском","182-188/96-100",44,1]
[null,"Ринат","Ботинки утепленныес защитным подноском","182-188/96-100",44,1]
[null,"Ринат","Подшлемник под каску утепленный","182-188/96-100",44,1]
[null,"Костя","Ботинки с защитным подноском","182-188/96-100",44,1]
[null,"Костя","Ботинки утепленныес защитным подноском","182-188/96-100",44,1]
[null,"Костя","Подшлемник под каску утепленный","182-188/96-100",44,1]
[null,"Резеда","Ботинки с защитным подноском","158-164/88-92",36,1]
[null,"Резеда","Ботинки утепленныес защитным подноском","158-164/88-92",36,1]
[null,"Резеда","Подшлемник под каску утепленный","158-164/88-92",36,1]
[null,"Флюра","Ботинки с защитным подноском","158-164/88-92",36,1]
[null,"Флюра","Ботинки утепленныес защитным подноском","158-164/88-92",36,1]
[null,"Флюра","Подшлемник под каску утепленный","158-164/88-92",36,1]
["Октябрь 2019","Ринат","Очки защитные","182-188/96-100",44,1]
[null,"Ринат","Костюм утепленный","182-188/96-100",44,1]
[null,"Костя","Очки защитные","182-188/96-100",44,1]
[null,"Костя","Костюм утепленный","182-188/96-100",44,1]
[null,"Резеда","Очки защитные","158-164/88-92",36,1]
[null,"Резеда","Костюм утепленный","158-164/88-92",36,1]
[null,"Флюра","Очки защитные","158-164/88-92",36,1]
[null,"Флюра","Костюм утепленный","158-164/88-92",36,1]
["Декабрь 2019"]