{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["СВОД","иванова","петрова","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,4,2,5],[6,6,7,12]]}
[]
[]
[null,"Отчет по отпускам","СВОД по отделу",null,"Отдел кадров"]
[]
[null,"ФИО","Должность","Дата приема на работу","Долг на текущую дату","Примечание"]
[1,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A2)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":"Иванова "},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B2)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":"Начальник отдела кадров"},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C2)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":"2013-02-04"},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D2)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":102.67},null,"Эта вся информация из других листов."]
[{"$f":"A6+1","v":2},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A3)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":"петрова"},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B3)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":"Специалист по кадрам"},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C3)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":"2016-09-05"},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D3)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":15.33},null,"Соответственно, если я скопирую этот свод в другую книгу (в другое подразделение), то ссылка все равно останется на  этот отдел."]
[{"$f":"A7+1","v":3},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A4)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B4)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C4)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D4)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":0}]
[4,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A5)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B5)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C5)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D5)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""},null,"Кроме того, если добавить еще один лист, то автоматически в строку №3 информация не поступит. "]
[5,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A6)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B6)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C6)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D6)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[6,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A7)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B7)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C7)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D7)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""},null,"Например, принимаю на работу еще сидорову. С копирую Петрову, внесу в этот лист корректив, хотелось бы."]
[7,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A8)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B8)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C8)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D8)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""},null,"чтобы в данной листе в своде в строке под №3 появилась инвормация о сидоровой."]
[8,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A9)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B9)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C9)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D9)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[9,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A10)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B10)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C10)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D10)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""},null,"А если петрову уволю и удалю лист, чтобы информация тоже отсюда исчезла! "]
[10,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A11)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B11)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C11)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D11)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[11,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A12)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B12)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C12)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D12)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[12,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A13)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B13)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C13)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D13)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[13,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A14)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B14)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C14)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D14)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[14,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A15)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B15)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C15)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D15)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[15,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A16)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B16)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C16)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D16)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[16,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A17)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B17)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C17)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D17)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[17,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A18)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B18)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C18)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D18)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[18,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A19)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B19)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C19)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D19)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[19,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A20)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B20)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C20)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D20)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[20,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A21)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B21)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C21)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D21)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[21,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A22)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B22)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C22)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D22)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[22,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A23)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B23)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C23)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D23)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[23,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A24)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B24)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C24)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D24)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[24,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A25)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B25)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C25)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D25)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[25,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A26)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B26)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C26)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D26)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[26,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A27)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B27)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C27)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D27)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[27,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A28)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B28)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C28)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D28)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[28,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A29)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B29)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C29)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D29)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[29,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A30)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B30)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C30)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D30)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[30,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A31)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B31)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C31)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D31)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[31,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A32)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B32)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C32)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D32)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[32,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A33)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B33)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C33)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D33)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[33,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A34)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B34)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C34)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D34)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[34,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A35)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B35)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C35)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D35)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[35,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A36)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B36)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C36)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D36)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[36,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A37)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B37)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C37)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D37)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[37,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A38)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B38)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C38)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D38)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[38,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A39)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B39)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C39)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D39)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[39,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A40)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B40)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C40)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D40)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[40,{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A41)),\"]\",REPT(\" \",30)),31))&\"!F4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B41)),\"]\",REPT(\" \",30)),31))&\"!J4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C41)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D41)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]

{"sheet":"иванова","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,8,6,9],[6,10,17,12],[7,8,7,9],[9,1,9,2],[0,1,0,5],[0,7,0,10],[3,5,3,8],[5,6,5,9],[5,10,5,12],[2,9,2,12],[12,0,17,0],[12,5,17,5],[12,6,12,9],[13,8,13,9],[14,8,14,9],[16,1,16,2],[19,0,24,0],[19,5,24,5],[19,6,19,9],[20,8,20,9],[21,8,21,9],[23,1,23,2]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"ОТДЕЛ КАДРОВ"]
[null,"Расчет количества дней отпуска",null,null,null,"Иванова ",null,null,null,"Начальник отдела кадров"]
[]
[null,"Дата трудоустройства ",null,"2013-02-04","план. дата",null,"Дней отпуска полагается",null,null,null,"Примечание:   "]
[null,"Текущая дата ",null,{"$f":"TODAY()","v":"2017-03-21"},"2016-12-30",null,"основной",28,null,null,"Отпуск за НЕНОРМИРОВАННЫЙ РАБОЧИЙ ДЕНЬ предоставляется за период с 01.01.2015 года!!!                                                            ПВТР действует с 01.01.2015!!!"]
[null,"Кол-во  дней отпуска с даты приема",null,null,null,null,"дополнит.",3,"НРД - по ПВТР"]
[null,"Кол-во отгуленных дней отпуска ",null,null,null,null,"дополнит."]
[]
[null,"Кол-во неотгуленного отпуска ",null,102.67,null,null,"ВСЕГО",{"$f":"SUM(H7:H10)","v":31}]
[]
[1,"Новый период"]
[null,"Текущая дата "]
[null,"Кол-во  дней отпуска новый период"]
[null,"Кол-во отгуленных дней отпуска "]
[null,"Изменить формулу в ячейке D!!!"]
[null,"Кол-во неотгуленного отпуска "]
[]
[2,"Новый период"]
[null,"Текущая дата "]
[null,"Кол-во  дней отпуска новый период"]
[null,"Кол-во отгуленных дней отпуска "]
[null,"Изменить формулу в ячейке D!!!"]
[null,"Кол-во неотгуленного отпуска "]

{"sheet":"петрова","index":2,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,8,6,9],[6,10,17,12],[7,8,7,9],[9,1,9,2],[0,1,0,5],[0,7,0,10],[3,5,3,8],[5,6,5,9],[5,10,5,12],[2,9,2,12],[12,0,17,0],[12,5,17,5],[12,6,12,9],[13,8,13,9],[14,8,14,9],[16,1,16,2],[19,0,24,0],[19,5,24,5],[19,6,19,9],[20,8,20,9],[21,8,21,9],[23,1,23,2]]}
[null,"Автор: Пестова Анна Владимировна - начальник отдела кадров",null,null,null,null,null,"anna-otdel-kadrov@yandex.ru"]
[]
[null,null,null,null,null,null,null,null,null,"ОТДЕЛ КАДРОВ"]
[null,"Расчет количества дней отпуска",null,null,null,"петрова",null,null,null,"Специалист по кадрам"]
[]
[null,"Дата трудоустройства ",null,"2016-09-05","план. дата",null,"Дней отпуска полагается",null,null,null,"Примечание:   "]
[null,"Текущая дата ",null,{"$f":"TODAY()","v":"2017-03-21"},null,null,"основной",28]
[null,"Кол-во  дней отпуска с даты приема",null,null,null,null,"дополнит."]
[null,"Кол-во отгуленных дней отпуска ",null,null,null,null,"дополнит."]
[]
[null,"Кол-во неотгуленного отпуска ",null,15.33,null,null,"ВСЕГО",{"$f":"SUM(H7:H10)","v":28}]
[]
[1,"Новый период"]
[null,"Текущая дата "]
[null,"Кол-во  дней отпуска новый период"]
[null,"Кол-во отгуленных дней отпуска "]
[null,"Изменить формулу в ячейке D!!!"]
[null,"Кол-во неотгуленного отпуска "]
[]
[2,"Новый период"]
[null,"Текущая дата "]
[null,"Кол-во  дней отпуска новый период"]
[null,"Кол-во отгуленных дней отпуска "]
[null,"Изменить формулу в ячейке D!!!"]
[null,"Кол-во неотгуленного отпуска "]

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