{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Пример таблицы",null,null,null,null,null,null,"Присваиваем \"1\" номеру 3 в столбце Switch и получаем активный номер 1"]
[]
["Мах","№ п/п","Switch","Активная Нумерация ",null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[3,1,1,2,null,null,null,3,1,0,0]
[null,2,1,3,null,null,null,null,2,0,0]
[null,3,1,1,null,null,null,null,3,1,1]
[null,4,0,0,null,null,null,null,4,0,0]
[null,5,0,0,null,null,null,null,5,0,0]
[]
[null,null,null,null,null,null,null,null,"Присваиваем \"1\" номеру 1 в столбце Switch и получаем активный номер 2"]
[]
[null,null,null,null,null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[null,null,null,null,null,null,null,3,1,1,2]
[null,null,null,null,null,null,null,null,2,0,0]
[null,null,null,null,null,null,null,null,3,1,1]
[null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,5,0,0]
[]
[null,null,null,null,null,null,null,null,"Присваиваем \"1\" номеру 4 в столбце Switch и получаем активный номер 3"]
[]
[null,null,null,null,null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[null,null,null,null,null,null,null,3,1,1,2]
[null,null,null,null,null,null,null,null,2,0,0]
[null,null,null,null,null,null,null,null,3,1,1]
[null,null,null,null,null,null,null,null,4,1,3]
[null,null,null,null,null,null,null,null,5,0,0]
[]
[null,null,null,null,null,null,null,null,"Поскольку достигнуто максимальное значение, то при вводе номеру 2 значения \"1\" в столбец Switch, введенная \"1\" должна обнулиться, аналогично и для номера \"5\""]
[]
[null,null,null,null,null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[null,null,null,null,null,null,null,3,1,1,2]
[null,null,null,null,null,null,null,null,2,1,0]
[null,null,null,null,null,null,null,null,3,1,1]
[null,null,null,null,"Нумерация достигла максимального значения",null,null,null,4,1,3]
[null,null,null,null,null,null,null,null,5,0,0]
[]
[null,null,null,null,null,null,null,null,"Все осталось как есть"]
[]
[null,null,null,null,null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[null,null,null,null,null,null,null,3,1,1,2]
[null,null,null,null,"без изменения",null,null,null,2,0,0]
[null,null,null,null,null,null,null,null,3,1,1]
[null,null,null,null,null,null,null,null,4,1,3]
[null,null,null,null,null,null,null,null,5,0,0]
[]
[null,null,null,null,null,null,null,null,"Присваиваем \"0\" номеру 3 в столбце Switch и получаем вычитние всех активных нумеров на 1, активные номера которые больше активного номера \"номера 3\", а активный номер \"номера 3\" становится 0"]
[]
[null,null,null,null,null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[null,null,null,null,null,null,null,3,1,1,1]
[null,null,null,null,"без изменения",null,null,null,2,0,0]
[null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,4,1,2]
[null,null,null,null,null,null,null,null,5,0,0]
[]
[null,null,null,null,null,null,null,null,"Присваиваем \"1\" номеру 5 в столбце Switch и получаем активный номер 3"]
[]
[null,null,null,null,null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[null,null,null,null,"изменение",null,null,3,1,1,1]
[null,null,null,null,null,null,null,null,2,0,0]
[null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,"изменение",null,null,null,4,1,2]
[null,null,null,null,null,null,null,null,5,1,3]
[]
[null,null,null,null,null,null,null,null,"Присваиваем \"0\" номеру 4 в столбце Switch и получаем вычитние всех активных нумеров на 1, активные номера которые больше активного номера \"номера 4\", а активный номер \"номера 4\" становится 0"]
[]
[null,null,null,null,null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[null,null,null,null,null,null,null,3,1,1,1]
[null,null,null,null,null,null,null,null,2,0,0]
[null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,5,1,2]
[]
[null,null,null,null,null,null,null,null,"Присваиваем \"1\" номеру 2 в столбце Switch и получаем активный номер 3"]
[]
[null,null,null,null,null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[null,null,null,null,"без изменения",null,null,3,1,1,1]
[null,null,null,null,null,null,null,null,2,1,3]
[null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,"изменение",null,null,null,5,1,2]
[]
[null,null,null,null,null,null,null,null,"Присваиваем максимальное количество активных номеров равное 2 в столбце Max и присваеваем всем значениям switch равное 0, активные номера которых больше максимального количества номеров"]
[]
[null,null,null,null,null,null,null,"Мах","№ п/п","Switch","Активная Нумерация "]
[null,null,null,null,null,null,null,2,1,1,1]
[null,null,null,null,null,null,null,null,2,0,0]
[null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,5,1,2]