{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Manager","SendMail","EmailList","HRTemplate","EngTemplate","TaskBook"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":3,"defined_names":40,"comments":1,"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":"Manager","index":0,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,5,0,7]]}
[null,null,null,null,null,"Протокол обработки\nProtocol"]
[null,null,null,null,null,"Файл с бюджетом:"]
[null,null,null,null,null,"Текущий файл для обработки:"]

{"sheet":"SendMail","index":1,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,4,1,6],[1,1,1,3],[2,1,2,3]]}
[null,null,null,null,null,"Режим отправки:\nWay of sending:","Open before sendings",null,null,null,null,null,null,"Send without opening"]
["Тема письма\nEmail subject",null,null,null,"Список отделов\nList of cost centres",null,null,null,null,null,null,null,null,"Open before sendings"]
["Тело письма\nEmail body",null,null,null,"Название\nCost centres name","Контактное лицо\nContact person","Отправляем запрос Да/Нет\nSend to Yes/No",null,null,null,null,null,null,"Yes"]
[null,null,null,null,"Engineering department",null,"No",null,null,null,null,null,null,"No"]
[null,null,null,null,"Purchasing department",null,"No"]
[null,null,null,null," Logistic department",null,"Yes"]
[null,null,null,null,"PM MOS",null,"No"]
[null,null,null,null,"PM department",null,"No"]
[null,null,null,null,"Production department (SP)",null,"No"]
[null,null,null,null,"Production department (T&I)",null,"No"]
[null,null,null,null,"Welding workshop",null,"No"]
[null,null,null,null,"Sales department Moscow",null,"No"]
[null,null,null,null,"Technology",null,"No"]
[null,null,null,null,"Technology BD",null,"No"]
[null,null,null,null,"TFS",null,"No"]
[null,null,null,null,"IT",null,"No"]
[null,null,null,null,"HR",null,"No"]
[null,null,null,null," Accounting department",null,"No"]
[null,null,null,null,"QESH",null,"No"]
[null,null,null,null,"Quality Control COGS",null,"No"]
[null,null,null,null,"Administration",null,"No"]
[null,null,null,null,"Admin MSK",null,"No"]
[null,null,null,null,"Service",null,"No"]
[null,null,null,null,"Sales GTB",null,"No"]

{"sheet":"EmailList","index":2,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Наименование отдела","Адрес email"]
["Engineering department"]
["Purchasing department"]
[" Logistic department"]
["PM MOS"]
["PM department"]
["Production department (SP)"]
["Production department (T&I)"]
["Welding workshop"]
["Sales department Moscow"]
["Technology"]
["Technology BD"]
["TFS"]
["IT"]
["HR"]
[" Accounting department"]
["QESH"]
["Quality Control COGS"]
["Administration"]
["Admin MSK"]
["Service"]
["Sales GTB"]

{"sheet":"HRTemplate","index":3,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Cost center level2/Department2","Budget owner level 1/ Head of department","Budget owner level 2/ Responsible person","Attribute","Value","Total"]
["Отдел управления персоналом",null,null,"ID","000000026-0700"]
["Отдел управления персоналом",null,null,"Limits","no limit"]
["Отдел управления персоналом",null,null,"Cost Item level 2","IT Software Licenses (expensed)",{"$f":"SUM(F5:F8)","v":0},{"$f":"IF(F4>E3,\"Выше лимита\",\"ОК\")","v":"ОК"}]
["Отдел управления персоналом",null,null,"Item1","__"]
["Отдел управления персоналом",null,null,"Item2","__"]
["Отдел управления персоналом",null,null,"Item3","__"]
["Отдел управления персоналом",null,null,"Item4","__"]
["Отдел управления персоналом",null,null,"ID","000000026-0800"]
["Отдел управления персоналом",null,null,"Limits","no limit"]
["Отдел управления персоналом",null,null,"Cost Item level 2","IT Hardware (expensed)",{"$f":"SUM(F12:F15)","v":110000},{"$f":"IF(F11>E10,\"Выше лимита\",\"ОК\")","v":"ОК"}]
["Отдел управления персоналом",null,null,"Item1",null,60000]
["Отдел управления персоналом",null,null,"Item2",null,50000]
["Отдел управления персоналом",null,null,"Item3","__"]
["Отдел управления персоналом",null,null,"Item4","__"]
["Отдел управления персоналом",null,null,"ID","000000026-0500"]
["Отдел управления персоналом",null,null,"Limits","no limit"]
["Отдел управления персоналом",null,null,"Cost Item level 2","Hotel expenses/ 3rd/ Remaining in Sulzer",{"$f":"SUM(F19:F22)","v":50000},{"$f":"IF(F18>E17,\"Выше лимита\",\"ОК\")","v":"ОК"}]
["Отдел управления персоналом",null,null,"Item1",null,50000]
["Отдел управления персоналом",null,null,"Item2","__"]
["Отдел управления персоналом",null,null,"Item3","__"]
["Отдел управления персоналом",null,null,"Item4","__"]
["Отдел управления персоналом",null,null,"ID","000000026-0501"]
["Отдел управления персоналом",null,null,"Limits","no limit"]
["Отдел управления персоналом",null,null,"Cost Item level 2","Flight expenses/ 3rd/ Remaining in Sulzer",{"$f":"SUM(F26:F29)","v":200000},{"$f":"IF(F25>E24,\"Выше лимита\",\"ОК\")","v":"ОК"}]
["Отдел управления персоналом",null,null,"Item1",null,200000]
["Отдел управления персоналом",null,null,"Item2","__"]
["Отдел управления персоналом",null,null,"Item3","__"]
["Отдел управления персоналом",null,null,"Item4","__"]
["Отдел управления персоналом",null,null,"ID","000000026-0505"]
["Отдел управления персоналом",null,null,"Limits","no limit"]
["Отдел управления персоналом",null,null,"Cost Item level 2","Other travel expenses/ 3rd/ Remaining in Sulzer",{"$f":"SUM(F33:F36)","v":50000},{"$f":"IF(F32>E31,\"Выше лимита\",\"ОК\")","v":"ОК"}]
["Отдел управления персоналом",null,null,"Item1",null,50000]
["Отдел управления персоналом",null,null,"Item2","__"]
["Отдел управления персоналом",null,null,"Item3","__"]
["Отдел управления персоналом",null,null,"Item4","__"]

{"sheet":"EngTemplate","index":4,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Eng"]
["Cost center level2/Department2","Budget owner level 1/ Head of department","Budget owner level 2/ Responsible person","Attribute","Value","Total, RUB"]
["Инжиниринговый отдел (E)    Engineering department","Богданова Анна Александровна","Богданова Анна Александровна","ID","000000006-0700",{"$f":"SUM(F4:F7)","v":0}]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Limits","no limit",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Cost Item level 2","IT Software Licenses (expensed)",0,{"$f":"IF(F5>E4,\"Выше лимита\",\"ОК\")","v":"ОК"}]
[null,null,null,"Item1","__",0]
[null,null,null,"Item2","__",0]
[null,null,null,"Item3","__",0]
[null,null,null,"Item4","__",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"ID","000000006-0800",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Limits","no limit",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Cost Item level 2","IT Hardware (expensed)",0,{"$f":"IF(F12>E11,\"Выше лимита\",\"ОК\")","v":"ОК"}]
[null,null,null,"Item1","__",0]
[null,null,null,"Item2","__",0]
[null,null,null,"Item3","__",0]
[null,null,null,"Item4","__",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"ID","000000006-0500",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Limits","no limit",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Cost Item level 2","Hotel expenses/ 3rd/ Remaining in Sulzer",0,{"$f":"IF(F19>E18,\"Выше лимита\",\"ОК\")","v":"ОК"}]
[null,null,null,"Item1","__",0]
[null,null,null,"Item2","__",0]
[null,null,null,"Item3","__",0]
[null,null,null,"Item4","__",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"ID","000000006-0501",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Limits","no limit",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Cost Item level 2","Flight expenses/ 3rd/ Remaining in Sulzer",0,{"$f":"IF(F26>E25,\"Выше лимита\",\"ОК\")","v":"ОК"}]
[null,null,null,"Item1","__",0]
[null,null,null,"Item2","__",0]
[null,null,null,"Item3","__",0]
[null,null,null,"Item4","__",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"ID","000000006-0505",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Limits","no limit",0]
["Инжиниринговый отдел (E)    Engineering department",null,null,"Cost Item level 2","Other travel expenses/ 3rd/ Remaining in Sulzer",0,"ОК"]
[null,null,null,"Item1","__",{"$f":"SUM(F35:F38)","v":0}]
[null,null,null,"Item2","__",{"$f":"SUM(F36:F39)","v":0}]
[null,null,null,"Item3","__",{"$f":"SUM(F37:F39)","v":0}]
[null,null,null,"Item4","__",{"$f":"SUM(F38:F39)","v":0}]

{"sheet":"TaskBook","index":5,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Заголовок\n(Header)","Задача\n(Task text)","Получатель\n(Receiver)","Важность\n(Importance)","Дата начала\n(Start date)","Дата завершения\n(Finish date)","Дата напоминания\n(Remind date)","Напоминание: часов\n(Remind: hours)","Напоминание: минут\n(Remind: minutes)",null,"Виды важности\n(Importance types)"]
["Заполнить \nOPEX","Заполнить \nOPEX",null,"Высокая","2022-08-01","2022-08-02","2022-07-31",10,0,null,"Низкая"]
[null,null,null,null,null,null,null,null,null,null,"Обычная"]
[null,null,null,null,null,null,null,null,null,null,"Высокая"]