{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Табель","Лист2","Лист3"],"not_rendered":{"charts":0,"images":3,"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":"Табель","index":0,"n_rows":19,"n_cols":44,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,2,0,32],[13,1,13,45],[14,1,14,45],[11,0,11,43],[12,0,12,46],[10,0,10,42]]}
["Ф.И.О.","Специальность","Продолжительность работы"]
["Петров П.П.","электрик ",8]
["Иванов И.И.","грузчик",8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8]
["Сидоров С.С.","слесарь",8]
["Мухин М.М.","электрик ",8]
["Панов В.В.","слесарь",8]
["ТитовР.Л.","слесарь",8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,null,null,null,null,null,null,null,null,null,{"$f":"MOD(AR7-XEQ$6,4)+1","v":2},1]
["ОсинП.Р.","грузчик",8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,null,null,null,null,null,null,null,null,null,{"$f":"MOD(AR8-XEQ$6,4)+1","v":3},2]
["паывпы","электрик ",{"$f":"IF(C$6=\"\",\"\",IF($BG9=\"\",IF(COUNTIF($BJ$2:$BJ$7,C$6)>0,7,IF(OR(C$6=WORKDAY(C$6-1,1,$BI$2:$BI$29)),8*$BH9^2,IF(COUNTIF($BI$2:$BI$29,C$6)=1,\"\",\"\"))),CHOOSE(MOD($BG9-COLUMN(D9),4)+1,14,\"\",\"\",8)))","v":""},"",14,8,"","",14,8,"","",14,8,"","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,{"$f":"MOD(AR9-XEQ$6,4)+1","v":4},3]
[]
["Это табель.Данные в табель заполняются с помощью формул.Это кусочек табеля для примера."]
["В столбце AQ через меню прописывается формула =ОСТАТ(3-XEQ$6;4)+1  в которой цифра \"3\" с помощью которой выбирается  в табеле какого числа рабочий день. "]
["Вопрос в том, как выберать или менять чило \"3\"в формуле столбца AQ (всего чисел 1 2 3 4 т.к. работают четыре человекав) формуле столбца AQ ,чтобы иметь возможность выберать разным работникам разные рабочие дни?"]
[null,"Может эти цифры(1 2 3 4) каким то образом выберать на кнопке добавить ,когда я вставляю эту формулу в столбец AQ или потом создать кнопку   изменить эти цифры в формуле?"]
[null,"Как это сделать не могу догататься.Помогите пожалуста?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]

{"sheet":"Лист2","index":1,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,2,1,18]]}
["Специальность"]
["электрик ",null,"Составил           Руководитель            Подпись"]
["грузчик"]
["слесарь"]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}