{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Реестр испытаний СИЗ","Настройки","SETS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Ф.И.О работника","Должность","Подразделение","Наименование СИЗ","Дата начала использования СИЗ ","Дата испытания","Дата следующего испытания","Периодичность испытаний"]
["Иванов Иван Иванович","Мастер цеха","Цех № 1","Галоши диэлектрические","2022-01-01","2023-01-01",{"$f":"IF(F5>0,IFERROR(F5+GetDaysToNextCheckFromPeriodic(F5,H5)-1,\"\"),\"\")","v":"2024-01-01"},{"$f":"IFERROR(VLOOKUP($D5,_tbl.sizsets[#All],2,0),\"\")","v":"1 раз в 12 месяцев"}]
["Иванов Иван Иванович","Мастер цеха","Цех № 1","Перчатки диэлектрические","2023-06-15","2023-12-15",{"$f":"IF(F6>0,IFERROR(F6+GetDaysToNextCheckFromPeriodic(F6,H6)-1,\"\"),\"\")","v":"2024-06-15"},{"$f":"IFERROR(VLOOKUP($D6,_tbl.sizsets[#All],2,0),\"\")","v":"1 раз в 6 месяцев"}]
["Петров Александр Николаевич","Мастер цеха","Цех № 2","Перчатки диэлектрические","2023-01-15","2023-07-15",{"$f":"IF(F7>0,IFERROR(F7+GetDaysToNextCheckFromPeriodic(F7,H7)-1,\"\"),\"\")","v":"2024-01-15"},{"$f":"IFERROR(VLOOKUP($D7,_tbl.sizsets[#All],2,0),\"\")","v":"1 раз в 6 месяцев"}]
["Петров Александр Николаевич","Мастер цеха","Цех № 2","Боты диэлектрические","2023-10-01","2023-10-01",{"$f":"IF(F8>0,IFERROR(F8+GetDaysToNextCheckFromPeriodic(F8,H8)-1,\"\"),\"\")","v":"2026-10-01"},{"$f":"IFERROR(VLOOKUP($D8,_tbl.sizsets[#All],2,0),\"\")","v":"1 раз в 36 месяцев"}]
[null,null,null,null,null,null,{"$f":"IF(F9>0,IFERROR(F9+GetDaysToNextCheckFromPeriodic(F9,H9)-1,\"\"),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D9,_tbl.sizsets[#All],2,0),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F10>0,IFERROR(F10+GetDaysToNextCheckFromPeriodic(F10,H10)-1,\"\"),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D10,_tbl.sizsets[#All],2,0),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F11>0,IFERROR(F11+GetDaysToNextCheckFromPeriodic(F11,H11)-1,\"\"),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D11,_tbl.sizsets[#All],2,0),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F12>0,IFERROR(F12+GetDaysToNextCheckFromPeriodic(F12,H12)-1,\"\"),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D12,_tbl.sizsets[#All],2,0),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F13>0,IFERROR(F13+GetDaysToNextCheckFromPeriodic(F13,H13)-1,\"\"),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D13,_tbl.sizsets[#All],2,0),\"\")","v":""}]

{"sheet":"Настройки","index":1,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,6]]}
["Настройка периодичности испытаний",null,null,"Настройки напоминаний"]
["Наименование СИЗ","Периодичность испытаний",null,"Напомнить об испытаниях"]
["Перчатки диэлектрические","1 раз в 6 месяцев",null,"За",20,"дней","зеленым цветом в контрольном листе"]
["Галоши диэлектрические","1 раз в 12 месяцев"]
["Боты диэлектрические","1 раз в 36 месяцев",null,"За",5,"дней","красным цветом в контрольном листе"]

{"sheet":"SETS","index":2,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Варианты периодичности испытаний"]
["1 раз в 3 месяца"]
["1 раз в 6 месяцев"]
["1 раз в 12 месяцев"]
["1 раз в 36 месяцев"]