{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["СВОД","иванов","гидион е.","гидион т"],"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":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,4,0,5],[2,4,2,5],[6,6,7,9]]}
[]
[]
[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))&\"!K4\"),\"\")","v":"Начальник цеха"},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C2)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":"2017-01-19"},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D2)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":3.67}]
[{"$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))&\"!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C3)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D3)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""},null,"почему не видно значений?"]
[{"$f":"A7+1","v":3},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A4)),\"]\",REPT(\" \",30)),31))&\"'!F4\"),\"\")","v":"Гидион Татьяна А"},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(B4)),\"]\",REPT(\" \",30)),31))&\"!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(C4)),\"]\",REPT(\" \",30)),31))&\"!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(D4)),\"]\",REPT(\" \",30)),31))&\"!D11\"),\"\")","v":""}]
[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))&\"!K4\"),\"\")","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":""}]
[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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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":""}]
[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))&\"!K4\"),\"\")","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":""}]
[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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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":""}]
[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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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))&\"!K4\"),\"\")","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":""}]
[null,"Итого задолженность по отпускам",{"$f":"E3","v":0},null,{"$f":"SUM(E6:E45)","v":3.67},"дней отпуска"]

{"sheet":"иванов","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,7,0,10],[2,9,2,12],[3,5,3,9],[5,6,5,9],[5,10,5,12],[6,8,6,9],[6,10,17,12],[7,8,7,9],[9,1,9,2],[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,"2017-01-19","план. дата",null,"Дней отпуска полагается",null,null,null,"Примечание:   "]
[null,"Текущая дата ",null,{"$f":"TODAY()","v":"2017-03-28"},"2017-12-31",null,"основной",28]
[null,"Кол-во  дней отпуска с даты приема",null,{"$f":"(DATEDIF(D6,D7+1,\"m\")+(DATEDIF(D6,D7+1,\"md\")>13))/12*$H$7","v":4.6666666666666661},{"$f":"(DATEDIF(D6,E7+1,\"m\")+(DATEDIF(D6,E7+1,\"md\")>13))/12*$H$7","v":25.666666666666664},null,"дополнит."]
[null,"Кол-во отгуленных дней отпуска ",null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,"дополнит."]
[]
[null,"Кол-во неотгуленного отпуска ",null,3.67,{"$f":"(DATEDIF(D6,E7,\"m\")+(DATEDIF(D6,E7,\"md\")>13))/12*$H$7-E9","v":{"$error":"#REF!"}},null,"ВСЕГО",{"$f":"SUM(H7:H10)","v":28}]
[]
[1,"Новый период"]
[null,"Текущая дата "]
[null,"Кол-во  дней отпуска новый период"]
[null,"Кол-во отгуленных дней отпуска "]
[null,"Изменить формулу в ячейке D!!!"]
[null,"Кол-во неотгуленного отпуска "]
[]
[2,"Новый период"]
[null,"Текущая дата "]
[null,"Кол-во  дней отпуска новый период"]
[null,"Кол-во отгуленных дней отпуска "]
[null,"Изменить формулу в ячейке D!!!"]
[null,"Кол-во неотгуленного отпуска "]
[]
[]
[]
[null,"Журнал отпусков  ОСНОВНЫХ"]

{"sheet":"гидион е.","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,8,6,9],[6,10,11,12],[7,8,7,9],[9,1,9,2],[0,1,0,5],[0,7,0,10],[3,5,3,9],[5,6,5,9],[5,10,5,12],[2,9,2,12]]}
[]
[]
[]
[null,"Расчет количества дней отпуска",null,null,null,"Гидион Елена ",null,null,null,null,"Оператор "]
[]
[null,"Дата трудоустройства ",null,"2015-10-02","план. дата",null,"Дней отпуска полагается",null,null,null,"Примечание:   "]
[null,"Текущая дата ",null,{"$f":"TODAY()","v":"2017-03-28"},"2016-12-30",null,"основной",28]
[null,"Кол-во  дней отпуска с даты приема",null,{"$f":"(DATEDIF(D6,D7+1,\"m\")+(DATEDIF(D6,D7+1,\"md\")>13))/12*$H$7","v":42},{"$f":"(DATEDIF(D6,E7+1,\"m\")+(DATEDIF(D6,E7+1,\"md\")>13))/12*$H$7","v":35},null,"дополнит."]
[null,"Кол-во отгуленных дней отпуска ",null,42,null,null,"дополнит."]
[]
[null,"Кол-во неотгуленного отпуска ",null,{"$f":"(DATEDIF(D6,D7,\"m\")+(DATEDIF(D6,D7,\"md\")>13))/12*$H$7-D9","v":0},null,null,"ВСЕГО",{"$f":"SUM(H7:H10)","v":28}]

{"sheet":"гидион т","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,8,6,9],[6,10,11,12],[7,8,7,9],[9,1,9,2],[0,1,0,5],[0,7,0,10],[3,5,3,9],[5,6,5,9],[5,10,5,12],[2,9,2,12]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"Цех минводы"]
[null,"Расчет количества дней отпуска",null,null,null,"Гидион Татьяна А",null,null,null,null,"Оператор линии в пр-ве пищевой продукции"]
[]
[null,"Дата трудоустройства ",null,"2016-07-18","план. дата",null,"Дней отпуска полагается",null,null,null,"Примечание:   "]
[null,"Текущая дата ",null,{"$f":"TODAY()","v":"2017-03-28"},"2016-12-30",null,"основной",28]
[null,"Кол-во  дней отпуска с даты приема",null,{"$f":"(DATEDIF(D6,D7+1,\"m\")+(DATEDIF(D6,D7+1,\"md\")>13))/12*$H$7","v":18.666666666666664},{"$f":"(DATEDIF(D6,E7+1,\"m\")+(DATEDIF(D6,E7+1,\"md\")>13))/12*$H$7","v":11.666666666666668},null,"дополнит."]
[null,"Кол-во отгуленных дней отпуска ",null,null,null,null,"дополнит."]
[]
[null,"Кол-во неотгуленного отпуска ",null,4.67,null,null,"ВСЕГО",{"$f":"SUM(H7:H10)","v":28}]