{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["СВОД","Петрова","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,4,0,5],[2,4,2,5]]}
[]
[]
[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(A2)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":"Начальник отдела кадров"},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A2)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":"2013-02-04"},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A2)),\"]\",REPT(\" \",30)),31))&\"'!D11\"),\"\")","v":105}]
[{"$f":"A6+1","v":2},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A3)),\"]\",REPT(\" \",30)),31))&\"'!F4\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A3)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A3)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A3)),\"]\",REPT(\" \",30)),31))&\"'!D11\"),\"\")","v":0}]
[{"$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(A4)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A4)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A4)),\"]\",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(A5)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A5)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A5)),\"]\",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(A6)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A6)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A6)),\"]\",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(A7)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A7)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A7)),\"]\",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(A8)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A8)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A8)),\"]\",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(A9)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A9)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A9)),\"]\",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(A10)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A10)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A10)),\"]\",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(A11)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A11)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A11)),\"]\",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(A12)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A12)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A12)),\"]\",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(A13)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A13)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A13)),\"]\",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(A14)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A14)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A14)),\"]\",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(A15)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A15)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A15)),\"]\",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(A16)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A16)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A16)),\"]\",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(A17)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A17)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A17)),\"]\",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(A18)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A18)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A18)),\"]\",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(A19)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A19)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A19)),\"]\",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(A20)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A20)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A20)),\"]\",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(A21)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A21)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A21)),\"]\",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(A22)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A22)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A22)),\"]\",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(A23)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A23)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A23)),\"]\",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(A24)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A24)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A24)),\"]\",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(A25)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A25)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A25)),\"]\",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(A26)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A26)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A26)),\"]\",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(A27)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A27)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A27)),\"]\",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(A28)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A28)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A28)),\"]\",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(A29)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A29)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A29)),\"]\",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(A30)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A30)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A30)),\"]\",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(A31)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A31)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A31)),\"]\",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(A32)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A32)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A32)),\"]\",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(A33)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A33)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A33)),\"]\",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(A34)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A34)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A34)),\"]\",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(A35)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A35)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A35)),\"]\",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(A36)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A36)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A36)),\"]\",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(A37)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A37)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A37)),\"]\",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(A38)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A38)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A38)),\"]\",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(A39)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A39)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A39)),\"]\",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(A40)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A40)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A40)),\"]\",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(A41)),\"]\",REPT(\" \",30)),31))&\"'!K4\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A41)),\"]\",REPT(\" \",30)),31))&\"'!D6\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&TRIM(RIGHTB(SUBSTITUTE(INDEX(Ю,ROW(A41)),\"]\",REPT(\" \",30)),31))&\"'!D11\"),\"\")","v":""}]
[null,"Итого задолженность по отпускам",{"$f":"E3","v":"Отдел кадров"},null,{"$f":"SUM(E6:E45)","v":105},"дней отпуска"]

{"sheet":"Петрова","index":1,"n_rows":57,"n_cols":11,"rows_kept":57,"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],[30,6,30,7],[61,6,61,7],[86,6,86,7],[113,4,113,5],[124,8,124,10]]}
[]
[]
[null,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-04-25"},"2016-12-30",null,"основной",28]
[null,"Кол-во  дней отпуска с даты приема",null,119,109.67,null,"дополнит.",3,"НРД - по ПВТР"]
[null,"Кол-во отгуленных дней отпуска ",null,{"$f":"SUM($F$32:$F$57)","v":14},{"$f":"SUM($F$32:$F$57)","v":14},null,"дополнит."]
[]
[null,"Кол-во неотгуленного отпуска ",null,105,95.67,null,"ВСЕГО",{"$f":"SUM(H7:H10)","v":31}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Журнал отпусков  ОСНОВНЫХ"]
[]
[null,"Начало","Конец","Календарные дни","Праздничные дни","Отгуленные дни","За период с… по…",null,"Приказ №","Период (закрыт/нет)","Кол-во дней за период осталось"]
[{"$f":"H7","v":28},"2015-09-21","2015-10-04",{"$f":"$C32-$B32+1","v":14},null,{"$f":"$D32-$E32","v":14}]
[null,null,null,null,null,{"$f":"$D33-$E33","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]

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