{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["мужчины","женщины"],"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":"2021-02-05"}]
[null,"дата увольнения",null,"рост","182-188","одежда","96-100","обувь",44]
[]
["№ п/п","Наименование СИЗ","н/н","цена","дата выдачи","срок носки, мес","дата списания","износ","Закупка"]
[1,"Костюм летний",null,null,"2020-03-22",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2021-03-22"},{"$f":"IF(E10=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E10)/($G10-$E10),($C$7-$E10)/($G10-$E10)))","v":0.12328767123287676},{"$f":"IF(H10<0,1,0)","v":0}]
[2,"Ботинки с защитным подноском",null,null,"2020-09-24",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2021-09-24"},0.63287671232876708,{"$f":"IF(H11<0,1,0)","v":0}]
[3,"Перчатки с полимерным покрытием",null,null,"2020-12-28",1,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2021-01-28"},-0.25806451612903225,1]
[4,"Каска защитная",null,null,"2020-02-27",24,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2022-02-27"},{"$f":"IF(E13=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E13)/($G13-$E13),($C$7-$E13)/($G13-$E13)))","v":0.52941176470588236},0]
[5,"Тапочки кожанные",null,null,"2020-07-20",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2021-07-20"},0.45205479452054798,0]
[6,"Очки защитные",null,null,"2020-10-29",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2021-10-29"},0.72876712328767124,0]
[7,"Боты или галоши диэлектрические",null,null,"2020-02-13",36,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2023-02-13"},{"$f":"IF(E16=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E16)/($G16-$E16),($C$7-$E16)/($G16-$E16)))","v":0.67335766423357657},0]
[8,"Перчатки диэлектрические",null,null,"2020-02-13",12,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2021-02-13"},2.1857923497267784E-2,0]
[9,"Костюм утепленный",null,null,"2020-10-13",24,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2022-10-13"},0.84246575342465757,0]
[10,"Ботинки утепленныес защитным подноском",null,null,"2020-03-22",18,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2021-09-22"},0.41712204007285969,0]
[11,"Перчатки полимерные утепленные",null,null,"2020-09-24",6,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2021-03-24"},0.25966850828729282,0]
[12,"Подшлемник под каску утепленный",null,null,"2020-09-24",24,{"$f":"EDATE(Table13[[#This Row],[дата выдачи]],Table13[[#This Row],[срок носки, мес]])","v":"2022-09-24"},0.81643835616438354,0]
[]
["Костя",null,null,null,null,"инженер 1 категории",null,"Сегодня ",{"$f":"TODAY()","v":"2021-02-05"}]
[null,"дата увольнения",null,"рост","182-188","одежда","96-100","обувь",44]
[]
["№ п/п","Наименование СИЗ","н/н","цена","дата выдачи","срок носки, мес","дата списания","износ","Закупка"]
[1,"Костюм летний",null,null,"2020-01-22",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2021-01-22"},{"$f":"IF(E27=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E27)/($G27-$E27),($C$7-$E27)/($G27-$E27)))","v":-3.8251366120218622E-2},{"$f":"IF(H27<0,1,0)","v":1}]
[2,"Ботинки с защитным подноском",null,null,"2020-01-23",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2021-01-23"},-3.5519125683060038E-2,{"$f":"IF(H28<0,1,0)","v":1}]
[3,"Перчатки с полимерным покрытием",null,null,"2020-01-24",1,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2020-02-24"},-11.193548387096774,1]
[4,"Каска защитная",null,null,"2020-01-25",24,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2022-01-25"},0.48426812585499313,0]
[5,"Тапочки кожанные",null,null,"2020-01-26",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2021-01-26"},-2.732240437158473E-2,1]
[6,"Очки защитные",null,null,"2020-01-27",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2021-01-27"},-2.4590163934426146E-2,1]
[7,"Боты или галоши диэлектрические",null,null,"2020-01-28",36,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2023-01-28"},0.65875912408759119,0]
[8,"Перчатки диэлектрические",null,null,"2020-01-29",12,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2021-01-29"},-1.91256830601092E-2,1]
[9,"Костюм утепленный",null,null,"2020-01-30",24,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2022-01-30"},0.49110807113543087,0]
[10,"Ботинки утепленныес защитным подноском",null,null,"2020-01-31",18,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2021-07-31"},0.32175502742230344,0]
[11,"Перчатки полимерные утепленные",null,null,"2020-02-01",6,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2020-08-01"},-1.0329670329670328,1]
[12,"Подшлемник под каску утепленный",null,null,"2020-02-02",24,{"$f":"EDATE(Table138[[#This Row],[дата выдачи]],Table138[[#This Row],[срок носки, мес]])","v":"2022-02-02"},0.49521203830369354,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":"2021-02-05"}]
[null,"дата увольнения",null,"рост","158-164","одежда","88-92","обувь",36]
[]
["№ п/п","Наименование СИЗ","н/н","цена","дата выдачи","срок носки, мес","дата списания","износ","Закупка"]
[1,"Костюм летний",null,null,"2020-01-22",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2021-01-22"},{"$f":"IF(E10=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E10)/($G10-$E10),($C$7-$E10)/($G10-$E10)))","v":-3.8251366120218622E-2},{"$f":"IF(H10<0,1,0)","v":1}]
[2,"Ботинки с защитным подноском",null,null,"2020-01-23",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2021-01-23"},-3.5519125683060038E-2,{"$f":"IF(H11<0,1,0)","v":1}]
[3,"Перчатки с полимерным покрытием",null,null,"2020-01-24",1,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2020-02-24"},-11.193548387096774,1]
[4,"Каска защитная",null,null,"2020-01-25",24,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2022-01-25"},0.48426812585499313,0]
[5,"Тапочки кожанные",null,null,"2020-01-26",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2021-01-26"},-2.732240437158473E-2,1]
[6,"Очки защитные",null,null,"2020-01-27",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2021-01-27"},-2.4590163934426146E-2,1]
[7,"Боты или галоши диэлектрические",null,null,"2020-01-28",36,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2023-01-28"},0.65875912408759119,0]
[8,"Перчатки диэлектрические",null,null,"2020-01-29",12,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2021-01-29"},-1.91256830601092E-2,1]
[9,"Костюм утепленный",null,null,"2020-01-30",24,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2022-01-30"},0.49110807113543087,0]
[10,"Ботинки утепленныес защитным подноском",null,null,"2020-01-31",18,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2021-07-31"},0.32175502742230344,0]
[11,"Перчатки полимерные утепленные",null,null,"2020-02-01",6,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2020-08-01"},-1.0329670329670328,1]
[12,"Подшлемник под каску утепленный",null,null,"2020-02-02",24,{"$f":"EDATE(Таблица1[[#This Row],[дата выдачи]],Таблица1[[#This Row],[срок носки, мес]])","v":"2022-02-02"},0.49521203830369354,0]
[]
["Резеда",null,null,null,null,"инженер",null,"Сегодня ",{"$f":"TODAY()","v":"2021-02-05"}]
[null,"дата увольнения",null,"рост","158-164","одежда","88-92","обувь",36]
[]
["№ п/п","Наименование СИЗ","н/н","цена","дата выдачи","срок носки, мес","дата списания","износ","Закупка"]
[1,"Костюм летний",null,null,"2020-02-01",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2021-02-01"},{"$f":"IF(E27=\"\",\"\",1-IF(ISBLANK($C$7),(TODAY()-$E27)/($G27-$E27),($C$7-$E27)/($G27-$E27)))","v":-1.0928961748633892E-2},{"$f":"IF(H27<0,1,0)","v":1}]
[2,"Ботинки с защитным подноском",null,null,"2020-02-02",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2021-02-02"},-8.1967213114753079E-3,{"$f":"IF(H28<0,1,0)","v":1}]
[3,"Перчатки с полимерным покрытием",null,null,"2020-02-03",1,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2020-03-03"},-11.689655172413794,1]
[4,"Каска защитная",null,null,"2020-02-04",24,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2022-02-04"},0.49794801641586872,0]
[5,"Тапочки кожанные",null,null,"2020-02-05",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2021-02-05"},0,0]
[6,"Очки защитные",null,null,"2020-02-06",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2021-02-06"},2.732240437158473E-3,0]
[7,"Боты или галоши диэлектрические",null,null,"2020-02-07",36,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2023-02-07"},0.66788321167883213,0]
[8,"Перчатки диэлектрические",null,null,"2020-02-08",12,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2021-02-08"},8.1967213114754189E-3,0]
[9,"Костюм утепленный",null,null,"2020-02-09",24,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2022-02-09"},0.50478796169630646,0]
[10,"Ботинки утепленныес защитным подноском",null,null,"2020-02-10",18,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2021-08-10"},0.34003656307129804,0]
[11,"Перчатки полимерные утепленные",null,null,"2020-02-11",6,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2020-08-11"},-0.9780219780219781,1]
[12,"Подшлемник под каску утепленный",null,null,"2020-02-12",24,{"$f":"EDATE(Table1367[[#This Row],[дата выдачи]],Table1367[[#This Row],[срок носки, мес]])","v":"2022-02-12"},0.50889192886456902,0]