{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Решения","PQ","Праздники"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,2]]}
["Дата последнего рабочего дня"]
[]
[]
["Текущая дата",{"$f":"TODAY()","v":"2017-10-23"}]
[null,"Результат","Текст формулы"]
["Формула\n(с учетом выходных)",{"$f":"WORKDAY(\n    IF(WEEKDAY(EOMONTH(B4,0),2)<6,\n                EOMONTH(B4,0),\n                EOMONTH(B4,0)-(WEEKDAY(EOMONTH(B4,0),2)-5)),\n  0,Праздники!$A$2:$A$827)","v":"2017-10-31"},"РАБДЕНЬ(\n    ЕСЛИ(ДЕНЬНЕД(КОНМЕСЯЦА(B4;0);2)<6;\n        КОНМЕСЯЦА(B4;0);\n        КОНМЕСЯЦА(B4;0)-(ДЕНЬНЕД(КОНМЕСЯЦА(B4;0);2)-5));\n    0;Праздники!$A$2:$A$827)"]
["Формула\n(без учета выходных)",{"$f":"WORKDAY(EOMONTH(B4,0),0,Праздники!$A$2:$A$827)","v":"2017-10-31"},"РАБДЕНЬ(КОНМЕСЯЦА(B4;0);0;Праздники!$A$2:$A$827)"]
["UDF",{"$f":"ПоследнийРабочийДень(B4,Праздники!$A$2:$A$827,0)","v":"2017-10-31"},"ПоследнийРабочийДень(B4;Праздники!$A$2:$A$827;0)"]
["Power Query",{"$f":"PQ!A2","v":"2017-10-31"},"запрос на листе \"PQ\".\nОтобразить запросы:\nДанные -Запросы и подключения -ПослРабДень"]

{"sheet":"PQ","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Value"]
["2017-10-31"]

{"sheet":"Праздники","index":2,"n_rows":827,"n_cols":1,"rows_kept":827,"cut":false,"hidden":false,"merged":[]}
["Дата выходного дня"]
["2013-01-01"]
["2013-01-02"]
["2013-01-03"]
["2013-01-04"]
["2013-01-05"]
["2013-01-06"]
["2013-01-07"]
["2013-01-08"]
["2013-01-12"]
["2013-01-13"]
["2013-01-19"]
["2013-01-20"]
["2013-01-26"]
["2013-01-27"]
["2013-02-02"]
["2013-02-03"]
["2013-02-09"]
["2013-02-10"]
["2013-02-16"]
["2013-02-17"]
["2013-02-23"]
["2013-02-24"]
["2013-03-02"]
["2013-03-03"]
["2013-03-08"]
["2013-03-09"]
["2013-03-10"]
["2013-03-16"]
["2013-03-17"]
["2013-03-23"]
["2013-03-24"]
["2013-03-30"]
["2013-03-31"]
["2013-04-06"]
["2013-04-07"]
["2013-04-13"]
["2013-04-14"]
["2013-04-20"]
["2013-04-21"]
["2013-04-27"]
["2013-04-28"]
["2013-05-01"]
["2013-05-02"]
["2013-05-03"]
["2013-05-04"]
["2013-05-05"]
["2013-05-09"]
["2013-05-10"]
["2013-05-11"]
["2013-05-12"]
["2013-05-18"]
["2013-05-19"]
["2013-05-25"]
["2013-05-26"]
["2013-06-01"]
["2013-06-02"]
["2013-06-08"]
["2013-06-09"]
["2013-06-12"]
["2013-06-15"]
["2013-06-16"]
["2013-06-22"]
["2013-06-23"]
["2013-06-29"]
["2013-06-29"]
["2013-06-30"]
["2013-07-06"]
["2013-07-07"]
["2013-07-13"]
["2013-07-14"]
["2013-07-20"]
["2013-07-21"]
["2013-07-27"]
["2013-07-28"]
["2013-08-03"]
["2013-08-04"]
["2013-08-10"]
["2013-08-11"]
["2013-08-17"]
["2013-08-18"]
["2013-08-24"]
["2013-08-25"]
["2013-08-31"]
["2013-09-01"]
["2013-09-07"]
["2013-09-08"]
["2013-09-14"]
["2013-09-15"]
["2013-09-21"]
["2013-09-22"]
["2013-09-28"]
["2013-09-29"]
["2013-10-05"]
["2013-10-06"]
["2013-10-12"]
["2013-10-13"]
["2013-10-19"]
["2013-10-20"]
["2013-10-26"]
["2013-10-27"]
["2013-11-02"]
["2013-11-03"]
["2013-11-04"]
["2013-11-09"]
["2013-11-10"]
["2013-11-16"]
["2013-11-17"]
["2013-11-23"]
["2013-11-24"]
["2013-11-30"]
["2013-12-01"]
["2013-12-07"]
["2013-12-08"]
["2013-12-14"]
["2013-12-15"]
["2013-12-21"]
["2013-12-22"]
["2013-12-28"]
["2013-12-29"]
["2014-01-01"]
["2014-01-02"]
["2014-01-03"]
["2014-01-04"]
["2014-01-05"]
["2014-01-06"]
["2014-01-07"]
["2014-01-08"]
["2014-01-11"]
["2014-01-12"]
["2014-01-18"]
["2014-01-19"]
["2014-01-25"]
["2014-01-26"]
["2014-02-01"]
["2014-02-02"]
["2014-02-08"]
["2014-02-09"]
["2014-02-15"]
["2014-02-16"]
["2014-02-22"]
["2014-02-23"]
["2014-03-01"]
["2014-03-02"]
["2014-03-08"]
["2014-03-09"]
["2014-03-10"]
["2014-03-15"]
["2014-03-16"]
["2014-03-22"]
["2014-03-23"]
["2014-03-29"]
["2014-03-30"]
["2014-04-05"]
["2014-04-06"]
["2014-04-12"]
["2014-04-13"]
["2014-04-19"]
["2014-04-20"]
["2014-04-26"]
["2014-04-27"]
["2014-05-01"]
["2014-05-02"]
["2014-05-03"]
["2014-05-04"]
["2014-05-09"]
["2014-05-10"]
["2014-05-11"]
["2014-05-17"]
["2014-05-18"]
["2014-05-24"]
["2014-05-25"]
["2014-05-31"]
["2014-06-01"]
["2014-06-07"]
["2014-06-08"]
["2014-06-12"]
["2014-06-13"]
["2014-06-14"]
["2014-06-15"]
["2014-06-21"]
["2014-06-22"]
["2014-06-28"]
["2014-06-29"]
["2014-07-05"]
["2014-07-06"]
["2014-07-12"]
["2014-07-13"]
["2014-07-19"]
["2014-07-20"]
["2014-07-26"]
["2014-07-27"]
["2014-08-02"]
["2014-08-03"]
["2014-08-09"]
["2014-08-10"]
["2014-08-16"]
["2014-08-17"]
["2014-08-23"]
["2014-08-24"]
["2014-08-30"]
["2014-08-31"]
["2014-09-06"]
["2014-09-07"]
["2014-09-13"]
["2014-09-14"]
["2014-09-20"]
["2014-09-21"]
["2014-09-27"]
["2014-09-28"]
["2014-10-04"]
["2014-10-05"]
["2014-10-11"]
["2014-10-12"]
["2014-10-18"]
["2014-10-19"]
["2014-10-25"]
["2014-10-26"]
["2014-11-01"]
["2014-11-02"]
["2014-11-03"]
["2014-11-04"]
["2014-11-08"]
["2014-11-09"]
["2014-11-15"]
["2014-11-16"]
["2014-11-22"]
["2014-11-23"]
["2014-11-29"]
["2014-11-30"]
["2014-12-06"]
["2014-12-07"]
["2014-12-13"]
["2014-12-14"]
["2014-12-20"]
["2014-12-21"]
["2014-12-27"]
["2014-12-28"]
["2015-01-01"]
["2015-01-02"]
["2015-01-03"]
["2015-01-04"]
["2015-01-05"]
["2015-01-06"]
["2015-01-07"]
["2015-01-08"]
["2015-01-09"]
["2015-01-10"]
["2015-01-11"]
["2015-01-17"]
["2015-01-18"]
["2015-01-24"]
["2015-01-25"]
["2015-01-31"]
["2015-02-01"]
["2015-02-07"]
["2015-02-08"]
["2015-02-14"]
["2015-02-15"]
["2015-02-21"]
["2015-02-22"]
["2015-02-23"]
["2015-02-28"]
["2015-03-01"]
["2015-03-07"]
["2015-03-08"]
["2015-03-09"]
["2015-03-14"]
["2015-03-15"]
["2015-03-21"]
["2015-03-22"]
["2015-03-28"]
["2015-03-29"]
["2015-04-04"]
["2015-04-05"]
["2015-04-11"]
["2015-04-12"]
["2015-04-18"]
["2015-04-19"]
["2015-04-25"]
["2015-04-26"]
["2015-05-01"]
["2015-05-02"]
["2015-05-03"]
["2015-05-04"]
["2015-05-09"]
["2015-05-10"]
["2015-05-11"]
["2015-05-16"]
["2015-05-17"]
["2015-05-23"]
["2015-05-24"]
["2015-05-30"]
["2015-05-31"]
["2015-06-06"]
["2015-06-07"]
["2015-06-12"]
["2015-06-13"]
["2015-06-14"]
["2015-06-20"]
["2015-06-21"]
["2015-06-27"]
["2015-06-28"]
["2015-07-04"]
["2015-07-05"]
["2015-07-11"]
["2015-07-12"]
["2015-07-18"]
["2015-07-19"]
["2015-07-25"]
["2015-07-26"]
["2015-08-01"]
["2015-08-02"]
["2015-08-08"]
["2015-08-09"]
["2015-08-15"]
["2015-08-16"]
["2015-08-22"]
["2015-08-23"]
["2015-08-29"]
["2015-08-30"]
["2015-09-05"]
["2015-09-06"]
["2015-09-12"]
["2015-09-13"]
["2015-09-19"]
["2015-09-20"]
["2015-09-26"]
["2015-09-27"]
["2015-10-03"]
["2015-10-04"]
["2015-10-10"]
["2015-10-11"]
["2015-10-17"]
["2015-10-18"]
["2015-10-24"]
["2015-10-25"]
["2015-10-31"]
["2015-11-01"]
["2015-11-04"]
["2015-11-07"]
["2015-11-08"]
["2015-11-14"]
["2015-11-15"]
["2015-11-21"]
["2015-11-22"]
["2015-11-28"]
["2015-11-29"]
["2015-12-05"]
["2015-12-06"]
["2015-12-12"]
["2015-12-13"]
["2015-12-19"]
["2015-12-20"]
["2015-12-26"]
["2015-12-27"]
["2016-01-01"]
["2016-01-02"]
["2016-01-03"]
["2016-01-04"]
["2016-01-05"]
["2016-01-06"]
["2016-01-07"]
["2016-01-08"]
["2016-01-09"]
["2016-01-10"]
["2016-01-16"]
["2016-01-17"]
["2016-01-23"]
["2016-01-24"]
["2016-01-30"]
["2016-01-31"]
["2016-02-06"]
["2016-02-07"]
["2016-02-13"]
["2016-02-14"]
["2016-02-21"]
["2016-02-22"]
["2016-02-23"]
["2016-02-27"]
["2016-02-28"]
["2016-03-05"]
["2016-03-06"]
["2016-03-07"]
["2016-03-08"]
["2016-03-12"]
["2016-03-13"]
["2016-03-19"]
["2016-03-20"]
["2016-03-26"]
["2016-03-27"]
["2016-04-02"]
["2016-04-03"]
["2016-04-09"]
["2016-04-10"]
["2016-04-16"]
["2016-04-17"]
["2016-04-23"]
["2016-04-24"]
["2016-04-30"]
["2016-05-01"]
["2016-05-02"]
["2016-05-03"]
["2016-05-07"]
["2016-05-08"]
["2016-05-09"]
["2016-05-14"]
["2016-05-15"]
["2016-05-21"]
["2016-05-22"]
["2016-05-28"]
["2016-05-29"]
["2016-06-04"]
["2016-06-05"]
["2016-06-11"]
["2016-06-12"]
["2016-06-13"]
["2016-06-18"]
["2016-06-19"]
["2016-06-25"]
["2016-06-26"]
["2016-07-02"]
["2016-07-03"]
["2016-07-09"]
["2016-07-10"]
["2016-07-16"]
["2016-07-17"]
["2016-07-23"]
["2016-07-24"]
["2016-07-30"]
["2016-07-31"]
["2016-08-06"]
["2016-08-07"]
["2016-08-13"]
["2016-08-14"]
["2016-08-20"]
["2016-08-21"]
["2016-08-27"]
["2016-08-28"]
["2016-09-03"]
["2016-09-04"]
["2016-09-10"]
["2016-09-11"]
["2016-09-17"]
["2016-09-18"]
["2016-09-24"]
["2016-09-25"]
["2016-10-01"]
["2016-10-02"]
["2016-10-08"]
["2016-10-09"]
["2016-10-15"]
["2016-10-16"]
["2016-10-22"]
["2016-10-23"]
["2016-10-29"]
["2016-10-30"]
["2016-11-04"]
["2016-11-05"]
["2016-11-06"]
["2016-11-12"]
["2016-11-13"]
["2016-11-19"]
["2016-11-20"]
["2016-11-26"]
["2016-11-27"]
["2016-12-03"]
["2016-12-04"]
["2016-12-10"]
["2016-12-11"]
["2016-12-17"]
["2016-12-18"]
["2016-12-24"]
["2016-12-25"]
["2016-12-31"]
["2017-01-01"]
["2017-01-02"]
["2017-01-03"]
["2017-01-04"]
["2017-01-05"]
["2017-01-06"]
["2017-01-07"]
["2017-01-08"]
["2017-01-14"]
["2017-01-15"]
["2017-01-21"]
["2017-01-22"]
["2017-01-28"]
["2017-01-29"]
["2017-02-04"]
["2017-02-05"]
["2017-02-11"]
["2017-02-12"]
["2017-02-18"]
["2017-02-19"]
["2017-02-23"]
["2017-02-24"]
["2017-02-25"]
["2017-02-26"]
["2017-03-04"]
["2017-03-05"]
["2017-03-08"]
["2017-03-11"]
["2017-03-12"]
["2017-03-18"]
["2017-03-19"]
["2017-03-25"]
["2017-03-26"]
["2017-04-01"]
["2017-04-02"]
["2017-04-08"]
["2017-04-09"]
["2017-04-15"]
["2017-04-16"]
["2017-04-22"]
["2017-04-23"]
["2017-04-29"]
["2017-04-30"]
["2017-05-01"]
["2017-05-06"]
["2017-05-07"]
["2017-05-08"]
["2017-05-09"]
["2017-05-13"]
["2017-05-14"]
["2017-05-20"]
["2017-05-21"]
["2017-05-27"]
["2017-05-28"]
["2017-06-03"]
["2017-06-04"]
["2017-06-10"]
["2017-06-11"]
["2017-06-12"]
["2017-06-17"]
["2017-06-18"]
["2017-06-24"]
["2017-06-25"]
["2017-07-01"]
["2017-07-02"]
["2017-07-08"]
["2017-07-09"]
["2017-07-15"]
["2017-07-16"]
["2017-07-22"]
["2017-07-23"]
["2017-07-29"]
["2017-07-30"]
["2017-08-05"]
["2017-08-06"]
["2017-08-12"]
["2017-08-13"]
["2017-08-19"]
["2017-08-20"]
["2017-08-26"]
["2017-08-27"]
["2017-09-02"]
["2017-09-03"]
["2017-09-09"]
["2017-09-10"]
["2017-09-16"]
["2017-09-17"]
["2017-09-23"]
["2017-09-24"]
["2017-09-30"]
["2017-10-01"]
["2017-10-07"]
["2017-10-08"]
["2017-10-14"]
["2017-10-15"]
["2017-10-21"]
["2017-10-22"]
["2017-10-28"]
["2017-10-29"]
["2017-11-04"]
["2017-11-05"]
["2017-11-06"]
["2017-11-11"]
["2017-11-12"]
["2017-11-18"]
["2017-11-19"]
["2017-11-25"]
["2017-11-26"]
["2017-12-02"]
["2017-12-03"]
["2017-12-09"]
["2017-12-10"]
["2017-12-16"]
["2017-12-17"]
["2017-12-23"]
["2017-12-24"]
["2017-12-30"]
["2017-12-31"]
["2018-01-01"]
["2018-01-02"]
["2018-01-03"]
["2018-01-04"]
["2018-01-05"]
["2018-01-06"]
["2018-01-07"]
["2018-01-08"]
["2018-01-13"]
["2018-01-14"]
["2018-01-20"]
["2018-01-21"]
["2018-01-27"]
["2018-01-28"]
["2018-02-03"]
["2018-02-04"]
["2018-02-10"]
["2018-02-11"]
["2018-02-17"]
["2018-02-18"]
["2018-02-23"]
["2018-02-24"]
["2018-02-25"]
["2018-03-03"]
["2018-03-04"]
["2018-03-08"]
["2018-03-09"]
["2018-03-10"]
["2018-03-11"]
["2018-03-17"]
["2018-03-18"]
["2018-03-24"]
["2018-03-25"]
["2018-03-31"]
["2018-04-01"]
["2018-04-07"]
["2018-04-08"]
["2018-04-14"]
["2018-04-15"]
["2018-04-21"]
["2018-04-22"]
["2018-04-29"]
["2018-04-30"]
["2018-05-01"]
["2018-05-02"]
["2018-05-05"]
["2018-05-06"]
["2018-05-09"]
["2018-05-12"]
["2018-05-13"]
["2018-05-19"]
["2018-05-20"]
["2018-05-26"]
["2018-05-27"]
["2018-06-02"]
["2018-06-03"]
["2018-06-10"]
["2018-06-11"]
["2018-06-12"]
["2018-06-16"]
["2018-06-17"]
["2018-06-23"]
["2018-06-24"]
["2018-06-30"]
["2018-07-01"]
["2018-07-07"]
["2018-07-08"]
["2018-07-14"]
["2018-07-15"]
["2018-07-21"]
["2018-07-22"]
["2018-07-28"]
["2018-07-29"]
["2018-08-04"]
["2018-08-05"]
["2018-08-11"]
["2018-08-12"]
["2018-08-18"]
["2018-08-19"]
["2018-08-25"]
["2018-08-26"]
["2018-09-01"]
["2018-09-02"]
["2018-09-08"]
["2018-09-09"]
["2018-09-15"]
["2018-09-16"]
["2018-09-22"]
["2018-09-23"]
["2018-09-29"]
["2018-09-30"]
["2018-10-06"]
["2018-10-07"]
["2018-10-13"]
["2018-10-14"]
["2018-10-20"]
["2018-10-21"]
["2018-10-27"]
["2018-10-28"]
["2018-11-03"]
["2018-11-04"]
["2018-11-05"]
["2018-11-10"]
["2018-11-11"]
["2018-11-17"]
["2018-11-18"]
["2018-11-24"]
["2018-11-25"]
["2018-12-01"]
["2018-12-02"]
["2018-12-08"]
["2018-12-09"]
["2018-12-15"]
["2018-12-16"]
["2018-12-22"]
["2018-12-23"]
["2018-12-30"]
["2018-12-31"]
["2019-01-01"]
["2019-01-02"]
["2019-01-03"]
["2019-01-04"]
["2019-01-05"]
["2019-01-06"]
["2019-01-07"]
["2019-01-08"]
["2019-01-09"]
["2019-01-10"]
["2019-01-12"]
["2019-01-13"]
["2019-01-19"]
["2019-01-20"]
["2019-01-26"]
["2019-01-27"]
["2019-02-02"]
["2019-02-03"]
["2019-02-09"]
["2019-02-10"]
["2019-02-16"]
["2019-02-17"]
["2019-02-23"]
["2019-02-24"]
["2019-02-25"]
["2019-03-02"]
["2019-03-03"]
["2019-03-08"]
["2019-03-09"]
["2019-03-10"]
["2019-03-16"]
["2019-03-17"]
["2019-03-23"]
["2019-03-24"]
["2019-03-30"]
["2019-03-31"]
["2019-04-06"]
["2019-04-07"]
["2019-04-13"]
["2019-04-14"]
["2019-04-20"]
["2019-04-21"]
["2019-04-27"]
["2019-04-28"]
["2019-05-04"]
["2019-05-05"]
["2019-05-09"]
["2019-05-11"]
["2019-05-12"]
["2019-05-18"]
["2019-05-19"]
["2019-05-25"]
["2019-05-26"]
["2019-06-01"]
["2019-06-02"]
["2019-06-08"]
["2019-06-09"]
["2019-06-12"]
["2019-06-15"]
["2019-06-16"]
["2019-06-22"]
["2019-06-23"]
["2019-06-29"]
["2019-06-30"]
["2019-07-06"]
["2019-07-07"]
["2019-07-13"]
["2019-07-14"]
["2019-07-20"]
["2019-07-21"]
["2019-07-27"]
["2019-07-28"]
["2019-08-03"]
["2019-08-04"]
["2019-08-10"]
["2019-08-11"]
["2019-08-17"]
["2019-08-18"]
["2019-08-24"]
["2019-08-25"]
["2019-08-31"]
["2019-09-01"]
["2019-09-07"]
["2019-09-08"]
["2019-09-14"]
["2019-09-15"]
["2019-09-21"]
["2019-09-22"]
["2019-09-28"]
["2019-09-29"]
["2019-10-05"]
["2019-10-06"]
["2019-10-12"]
["2019-10-13"]
["2019-10-19"]
["2019-10-20"]
["2019-10-26"]
["2019-10-27"]
["2019-11-02"]
["2019-11-03"]
["2019-11-09"]
["2019-11-10"]
["2019-11-16"]
["2019-11-17"]
["2019-11-23"]
["2019-11-24"]
["2019-11-30"]
["2019-12-01"]
["2019-12-07"]
["2019-12-08"]
["2019-12-14"]
["2019-12-15"]
["2019-12-21"]
["2019-12-22"]
["2019-12-28"]
["2019-12-29"]