{"text_format":"1","workbook":"xlsx","n_sheets":44,"sheets":["Инструкция","Обновление","Лог обновления","Титульный","Стр 1-3","Стр 4-6","Стр 7-9","Стр 10-12","Стр 13","Стр 14","Комментарии","Проверка","AllSheetsInThisWorkbook","et_union","TEHSHEET","REESTR_ORG","REESTR_FILTERED","REESTR_MO","modHyperlink","modChange","modPROV","modTitleSheetHeaders","modServiceModule","modCommandButton","modReestr","modClassifierValidate","modInfo","modfrmReestr","modfrmDateChoose","modDblClick","Паспорт","modUpdTemplMain","modRegionSelectSub","modThisWorkbook","modReestrMO","modSheetMain01","modSheetMain02","modSheetMain03","modSheetMain04","modSheetMain05","modSheetMain06","modSheetMain07","modSheetMain08","modSheetMain09"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":186,"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":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[[36,2,36,3],[23,2,23,3],[23,4,23,7],[33,4,33,7],[43,2,43,3],[42,5,42,8],[43,5,43,8],[39,1,39,9],[42,2,42,3],[21,2,21,7],[31,2,31,4],[32,2,32,3],[32,4,32,7],[34,4,34,7],[34,2,34,3],[33,2,33,3],[28,2,28,3],[22,2,22,4],[24,2,24,3],[24,4,24,7],[28,4,28,7],[29,2,29,3],[29,4,29,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[13,4,14,7],[45,5,45,8],[46,5,46,8],[47,5,47,8],[17,2,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[36,4,36,7],[25,2,25,3],[25,4,25,7],[26,2,26,3],[26,4,26,7],[35,2,35,3],[35,4,35,7],[27,2,27,3],[27,4,27,7],[3,1,3,9],[51,2,51,3],[52,2,52,3],[49,5,49,8],[50,5,50,8],[51,5,51,8],[52,5,52,8],[48,2,48,3],[49,2,49,3],[50,2,50,3],[48,5,48,8],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[44,5,44,8]]}
[]
[null,null,"FORMA5.BUHG.2011"]
[]
[null,"Инструкция по заполнению шаблона\n\"Приложение к бухгалтерскому балансу\""]
[]
[]
[null,null,"Технические требования:\n\n• макросы во время работы должны быть включены \n\n"]
[null,null,"• на рабочем месте должен быть установлен MS Office 2003, 2007, 2010 x86 с полной версией MS Excel"]
[null,null,"• макросы во время работы должны быть включены "]
[null,null,"• для корректной работы шаблона требуется выбрать низкий уровень безопасности\n(В меню MS Excel 2003: Сервис → Макрос → Безопасность → выбрать нижний пункт «Низкая безопасность» → «OK»)\n(В MS Excel 2007 после открытия файла шаблона нажать на кнопку «Параметры…» → «Предупреждение системы безопасности» → «Включить это содержимое» → «OK»)"]
[null,null,null,"Цвета ячеек:"]
[null,null,null,"●","Голубой – ячейки, обязательные для заполнения;"]
[null,null,null,"●","Желтый – ячейки, предназначенные для заполнения;"]
[null,null,null,"●","Зеленый – ячейки с формулами/константами или заполняемые автоматически (например, при выборе организации из реестра или выборе даты)."]
[]
[null,null,null,"Пояснение к заполнению (необходимо нажать один раз)."]
[]
[null,null,"Шаблон может быть сохранен на любом этапе заполнения!"]
[null,null,"• При сохранении шаблона осуществляется проверка на наличие и корректность (например, КПП – 9 цифр) обязательных параметров на листах. "]
[null,null,"• Если какая-то ячейка не удовлетворяет условию проверки, на лист «Проверка» добавляется гиперссылка на данную ячейку и причина, по которой шаблон не будет загружен в хранилище данных. "]
[null,null,"• В колонке «Статус ошибки» для каждого сообщения возможны 2 значения: ошибка и предупреждение. "]
[null,null,"• При наличии сообщений со статусом «Ошибка» шаблон будет отклонён системой, сообщения со статусом «Предупреждение» носят информационный характер, и такой шаблон будет принят системой."]
[null,null,"Организационно-технические консультации:"]
[null,null,"ФИО:"]
[null,null,"телефон:"]
[null,null,"e-mail:"]
[null,null,"WEB-сайт:"]
[null,null,"Комментарий"]
[null,null,"Дистрибутивы:"]
[null,null,"Дистрибутивы (ссылка):"]
[]
[null,null,"Консультации по методологии заполнения форм:"]
[null,null,"ФИО:"]
[null,null,"телефон:"]
[null,null,"e-mail:"]
[null,null,"WEB-сайт:"]
[null,null,"Комментарий"]
[]
[]
[null,"Список сокращений"]
[]
[]
[null,null,"Сокращение",null,"Расшифровка","Данные"]
[null,null,1,null,2,3]
[null,null,"ОКПО",null,"Общероссийский классификатор предприятий и организаций"]
[null,null,"ОКВЭД",null,"Общероссийский классификатор видов экономической деятельности","http://www.gmcgks.ru/new_page_96.htm"]
[null,null,"ОКАТО",null,"Общероссийский классификатор объектов административно-территориального деления","http://www.gmcgks.ru/new_page_87.htm"]
[null,null,"ОКОГУ",null,"Общероссийский классификатор органов государственной власти и управления","http://www.gmcgks.ru/new_page_77.htm"]
[null,null,"ОКОПФ",null,"Общероссийский классификатор организационно-правовых форм","http://www.gmcgks.ru/new_page_95.htm"]
[null,null,"ОКФС",null,"Общероссийский классификатор форм собственности","http://www.gmcgks.ru/new_page_94.htm"]
[null,null,"ОКУД",null,"Общероссийский классификатор управленческой документации","http://www.gmcgks.ru/new_page_80.htm"]
[null,null,"ОКЕИ",null,"Общероссийский классификатор единиц измерения","http://www.gmcgks.ru/new_page_83.htm"]
[null,null,"ОКТМО",null,"Общероссийский классификатор территорий муниципальных образований","http://www.gks.ru/metod/classifiers.html"]

{"sheet":"Обновление","index":1,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":true,"merged":[[1,14,1,16],[2,2,2,15],[23,2,23,7],[23,8,23,15]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"version","v":0}]
[null,null,"Инструкция по обновлению шаблона"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Если компьютер имеет подключение к Интернет, можно автоматически проверять наличие доступных обновлений. Выберите способ оповещения о наличии обновлений для шаблона:"]

{"sheet":"Лог обновления","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Дата/Время","Сообщение","Статус"]
["3/8/2013  6:29:49 PM","Проверка доступных обновлений...","Информация"]
["3/8/2013  6:29:50 PM","Версия шаблона 2.2 актуальна, обновление не требуется","Информация"]
["11/3/2016  3:28:53 AM","Проверка доступных обновлений...","Информация"]
["11/3/2016  3:28:56 AM","Версия шаблона 2.3 актуальна, обновление не требуется","Информация"]
["11/3/2016  3:29:12 AM","Проверка доступных обновлений...","Информация"]
["11/3/2016  3:29:13 AM","Версия шаблона 2.3 актуальна, обновление не требуется","Информация"]
["11/9/2016  6:31:53 PM","Проверка доступных обновлений...","Информация"]
["11/9/2016  6:31:54 PM","Версия шаблона 2.3 актуальна, обновление не требуется","Информация"]

{"sheet":"Титульный","index":3,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[12,3,12,5],[17,3,17,5],[19,3,19,5],[30,3,30,5],[5,1,5,10],[8,3,8,5],[14,3,14,5],[10,2,10,5],[3,1,3,10],[11,3,11,5],[26,10,28,10],[21,8,21,9],[23,8,23,9],[21,3,21,5],[15,8,15,9],[16,2,16,5],[19,7,19,9],[18,3,18,5],[20,3,20,5],[20,7,20,9],[16,8,16,9],[23,3,23,5],[17,8,17,9],[18,7,18,9],[34,3,34,5],[33,3,33,5],[32,2,32,5],[50,3,50,5],[25,2,25,5],[46,3,46,5],[47,3,47,5],[48,3,48,5],[44,2,44,5],[26,3,26,5],[37,3,37,5],[41,3,41,5],[28,3,28,5],[38,7,42,9],[38,3,38,5],[45,3,45,5],[42,3,42,5],[36,2,36,5],[40,2,40,5]]}
[null,null,null,null,null,null,null,null,null,"01.01.2016"]
[]
[]
[null,"Приложение к бухгалтерскому балансу"]
[]
[null,"Приложение\nк Приказу Минфина РФ\nот 02.07.2010 № 66н\n(в ред. Приказов Минфина России от 05.10.2011 №124н, \nот 17.08.2012 №113н, от 04.12.2012 №154н)"]
[]
[null,null,"Создать печатную форму"]
[null,null,"Регион РФ","Рязанская область"]
[]
[null,null,"Отчётный период"]
[null,null,"Год","2016"]
[null,null,"Квартал (с нарастающим итогом)","год"]
[]
[null,null,"Признак филиала","нет"]
[null,null,null,null,null,null,null,"Форма №2 по ОКУД","0710005"]
[null,null,null,null,null,null,null,"Дата (год,месяц,число)","31.12.2016"]
[null,null,"Организация:","МУНИЦИПАЛЬНОЕ ПРЕДПРИЯТИЕ \"ВОДОКАНАЛ ГОРОДА РЯЗАНИ\"",null,null,null,"Коды* по ОКПО","03219667"]
[null,null,"Наименование филиала:     "]
[null,null,"ИНН:","6227004811"]
[null,null,"КПП:","623401001"]
[null,null,"Вид деятельности:","Холодное водоснабжение; Водоотведение",null,null,null,"Коды* по ОКВЭД","41.00.2"]
[null,null,"Организационно-правовая форма/форма собственности:","МУНИЦИПАЛЬНОЕ ПРЕДПРИЯТИЕ \"ВОДОКАНАЛ ГОРОДА РЯЗАНИ\"","/","муниципальная собственность",null,"Коды* по ОКОПФ/ОКФС ","14","42"]
[null,null,"Единица измерения:","тыс.руб.",null,null,null,"Коды* по ОКЕИ","384"]
[]
[]
[null,null,"Муниципальный район","Город Рязань"]
[]
[null,null,"Муниципальное образование","Город Рязань"]
[]
[null,null,"ОКТМО","61701000"]
[]
[null,null,"Адрес организации"]
[null,null,"Юридический адрес:","390027, ОБЛ РЯЗАНСКАЯ, Г РЯЗАНЬ, Ш КАСИМОВСКОЕ, д.9"]
[null,null,"Почтовый адрес:","390000, Рязанская Область, Рязань Город, Касимовское Шоссе, д.9"]
[]
[null,null,"Руководитель"]
[null,null,"Фамилия, имя, отчество:","Штефае Олег Борисович"]
[null,null,"(код) номер телефона:","(4912)41 00 10",null,null,null,"* Расшифровки всех сокращений и ссылки приведены на листе \"Инструкция\""]
[]
[null,null,"Главный бухгалтер"]
[null,null,"Фамилия, имя, отчество:","Куранова Наталия Александровна"]
[null,null,"(код) номер телефона:","(4912) 41 80 48"]
[]
[null,null,"Должностное лицо, ответственное за составление формы"]
[null,null,"Фамилия, имя, отчество:","Оболенцева Екатерина Николаевна"]
[null,null,"Должность:","начальник планово-экономического отдела"]
[null,null,"(код) номер телефона:","(4912) 41 02 13"]
[null,null,"e-mail:","oen@vkrzn.ru"]
[]
[null,null,"Дата составления документа",{"$f":"TODAY()","v":"2017-04-24"}]

{"sheet":"Стр 1-3","index":4,"n_rows":75,"n_cols":43,"rows_kept":75,"cut":false,"hidden":false,"merged":[[7,3,7,41],[9,3,9,41],[12,4,14,4],[12,5,14,5],[12,6,14,6],[12,7,14,7],[12,8,12,13],[12,14,12,34],[12,35,12,40],[13,8,14,10],[13,11,14,13],[13,14,14,16],[13,17,13,22],[13,23,14,25],[14,17,14,19],[14,20,14,22],[15,17,15,19],[15,23,15,25],[15,38,15,40],[13,26,14,28],[13,29,13,34],[13,35,14,37],[13,38,14,40],[14,29,14,31],[14,32,14,34],[16,4,17,4],[16,5,17,5],[18,4,19,4],[18,5,19,5],[15,11,15,13],[29,5,29,6],[29,11,29,13],[30,5,30,6],[31,5,31,6],[25,3,25,17],[28,5,28,6],[28,8,28,10],[28,11,28,13],[28,14,28,16],[39,5,39,6],[39,11,39,13],[40,5,40,6],[41,5,41,6],[35,3,35,17],[38,5,38,6],[38,8,38,10],[38,11,38,13],[38,14,38,16],[45,3,45,32],[48,4,50,4],[48,5,50,5],[48,6,50,6],[48,7,50,7],[48,8,48,13],[48,14,48,25],[48,26,48,31],[49,8,50,10],[49,11,50,13],[49,29,50,31],[50,17,50,19],[50,20,50,22],[51,11,51,13],[51,17,51,19],[51,23,51,25],[51,29,51,31],[49,14,50,16],[49,17,49,22],[49,23,50,25],[49,26,50,28],[52,4,53,4],[52,5,53,5],[54,4,55,4],[54,5,55,5],[63,17,63,19],[64,14,64,16],[64,17,64,19],[65,4,66,4],[65,5,66,5],[59,3,59,23],[62,4,63,4],[62,5,63,5],[62,6,63,6],[62,7,63,7],[62,8,63,10],[62,11,62,19],[62,20,63,22],[63,11,63,13],[63,14,63,16],[72,4,73,4],[72,5,73,5],[67,4,68,4],[67,5,68,5],[70,4,71,4],[70,5,71,5]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Форма 0710005 с. 1-3"]
[null,null,null,"1. Нематериальные активы и расходы на научно-исследовательские, опытно-конструкторские и технологические работы (НИОКР)"]
[]
[null,null,null,"1.1. Наличие и движение нематериальных активов"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","На начало года",null,null,null,null,null,"Изменения за период",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"На конец периода"]
[null,null,null,null,null,null,null,null,"первоначальная стоимость *",null,null,"накопленная амортизация и убытки от обесценения",null,null,"поступило",null,null,"выбыло",null,null,null,null,null,"начислено амортизации",null,null,"убыток\nот обесценения",null,null,"переоценка",null,null,null,null,null,"первоначальная стоимость *",null,null,"накопленная амортизация и убытки от обесценения"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"первоначальная стоимость *",null,null,"накопленная амортизация и убытки от обесценения",null,null,null,null,null,null,null,null,"первоначальная стоимость *",null,null,"накопленная амортизация и убытки от обесценения"]
[null,null,null,null,1,2,3,4,null,5,null,6,null,null,null,7,null,8,null,null,null,9,null,10,null,null,null,11,null,null,12,null,null,13,null,null,14,null,15]
[null,null,null,null,"1.1","Нематериальные активы - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5100,{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"c\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"c\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))","v":0},{"$f":"IF(I17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AQ$19:$AQ$21,$AQ17,M$19:M$21)","v":0},")",{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"c\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"c\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))","v":0},{"$f":"IF(O17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AQ$19:$AQ$21,$AQ17,S$19:S$21)","v":0},")",{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"c\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"c\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))","v":0},{"$f":"IF(U17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AQ$19:$AQ$21,$AQ17,Y$19:Y$21)","v":0},")",{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"c\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"c\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))","v":0},{"$f":"IF(AA17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"c\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"c\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))","v":0},{"$f":"IF(AD17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"c\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"c\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))","v":0},{"$f":"IF(AG17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"c\",IF(AJ$19:AJ$21=\"(\",-AK$19:AK$21,AK$19:AK$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"c\",IF(AJ$19:AJ$21=\"(\",-AK$19:AK$21,AK$19:AK$21))))","v":0},{"$f":"IF(AJ17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AQ$19:$AQ$21,$AQ17,AN$19:AN$21)","v":0},")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5110,{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"p\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"p\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))","v":0},{"$f":"IF(I18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AQ$19:$AQ$21,$AQ18,M$19:M$21)","v":0},")",{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"p\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"p\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))","v":0},{"$f":"IF(O18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AQ$19:$AQ$21,$AQ18,S$19:S$21)","v":0},")",{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"p\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"p\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))","v":0},{"$f":"IF(U18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AQ$19:$AQ$21,$AQ18,Y$19:Y$21)","v":0},")",{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"p\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"p\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))","v":0},{"$f":"IF(AA18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"p\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"p\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))","v":0},{"$f":"IF(AD18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"p\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"p\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))","v":0},{"$f":"IF(AG18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AQ$19:$AQ$21=\"p\",IF(AJ$19:AJ$21=\"(\",-AK$19:AK$21,AK$19:AK$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AQ$19:$AQ$21=\"p\",IF(AJ$19:AJ$21=\"(\",-AK$19:AK$21,AK$19:AK$21))))","v":0},{"$f":"IF(AJ18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AQ$19:$AQ$21,$AQ18,AN$19:AN$21)","v":0},")",null,"p"]
[null,null,null,null,"1.1.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,"(",null,")",null,"p"]
[null,null,null,null,null,"Добавить вид нематериальных активов"]
[]
[null,null,null,null,"*","В случае переоценки в графе \"Первоначальная стоимость\" приводится текущая рыночная стоимость или текущая (восстановительная) стоимость."]
[]
[]
[null,null,null,"1.2. Первоначальная стоимость нематериальных активов, созданных самой организацией"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"На \"&IF(report_date = \"\",\"отчётную дату отчётного года\",report_date& \" г.\")","v":"На 31.12.2016 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"предыдущего года\",god-1& \" г.\")","v":"На 31 декабря 2015 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"года, предшествующего предыдущему\",god-2& \" г.\")","v":"На 31 декабря 2014 г."}]
[null,null,null,null,1,2,null,3,null,4,null,5,null,null,null,6]
[null,null,null,null,"1.2","Всего, в том числе: ",null,5120,{"$f":"IF((SUMIF(I32:I33,\"\",J32:J33)-SUMIF(I32:I33,\"(\",J32:J33))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I32:I33,\"\",J32:J33)-SUMIF(I32:I33,\"(\",J32:J33))","v":0},{"$f":"IF(I31=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L32:L33,\"\",M32:M33)-SUMIF(L32:L33,\"(\",M32:M33))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L32:L33,\"\",M32:M33)-SUMIF(L32:L33,\"(\",M32:M33))","v":0},{"$f":"IF(L31=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O32:O33,\"\",P32:P33)-SUMIF(O32:O33,\"(\",P32:P33))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O32:O33,\"\",P32:P33)-SUMIF(O32:O33,\"(\",P32:P33))","v":0},{"$f":"IF(O31=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"1.2.1"]
[null,null,null,null,null,"Добавить вид нематериальных активов"]
[]
[]
[null,null,null,"1.3. Нематериальные активы с полностью погашенной стоимостью"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"На \"&IF(report_date = \"\",\"отчётную дату отчётного года\",report_date& \" г.\")","v":"На 31.12.2016 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"предыдущего года\",god-1& \" г.\")","v":"На 31 декабря 2015 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"года, предшествующего предыдущему\",god-2& \" г.\")","v":"На 31 декабря 2014 г."}]
[null,null,null,null,1,2,null,3,null,4,null,5,null,null,null,6]
[null,null,null,null,"1.3","Всего, в том числе: ",null,5130,{"$f":"IF((SUMIF(I42:I43,\"\",J42:J43)-SUMIF(I42:I43,\"(\",J42:J43))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I42:I43,\"\",J42:J43)-SUMIF(I42:I43,\"(\",J42:J43))","v":0},{"$f":"IF(I41=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L42:L43,\"\",M42:M43)-SUMIF(L42:L43,\"(\",M42:M43))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L42:L43,\"\",M42:M43)-SUMIF(L42:L43,\"(\",M42:M43))","v":0},{"$f":"IF(L41=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O42:O43,\"\",P42:P43)-SUMIF(O42:O43,\"(\",P42:P43))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O42:O43,\"\",P42:P43)-SUMIF(O42:O43,\"(\",P42:P43))","v":0},{"$f":"IF(O41=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"1.3.1"]
[null,null,null,null,null,"Добавить вид нематериальных активов"]
[]
[]
[null,null,null,"1.4. Наличие и движение результатов НИОКР"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","На начало года",null,null,null,null,null,"Изменения за период",null,null,null,null,null,null,null,null,null,null,null,"На конец периода"]
[null,null,null,null,null,null,null,null,"первоначальная стоимость",null,null,"часть стоимости, списанной на расходы",null,null,"поступило",null,null,"выбыло",null,null,null,null,null,"часть стоимости, списанная на расходы за период",null,null,"первоначальная стоимость *",null,null,"часть стоимости, списанная на расходы"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"первоначальная стоимость",null,null,"часть стоимости, списанной на расходы"]
[null,null,null,null,1,2,3,4,null,5,null,6,null,null,null,7,null,8,null,null,null,9,null,10,null,null,null,11,null,12]
[null,null,null,null,"1.4","НИОКР - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5140,{"$f":"IF((SUM(IF($AH$55:$AH$57=\"c\",IF(I$55:I$57=\"(\",-J$55:J$57,J$55:J$57))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AH$55:$AH$57=\"c\",IF(I$55:I$57=\"(\",-J$55:J$57,J$55:J$57))))","v":0},{"$f":"IF(I53=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AH$55:$AH$57,$AH53,M$55:M$57)","v":0},")",{"$f":"IF((SUM(IF($AH$55:$AH$57=\"c\",IF(O$55:O$57=\"(\",-P$55:P$57,P$55:P$57))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AH$55:$AH$57=\"c\",IF(O$55:O$57=\"(\",-P$55:P$57,P$55:P$57))))","v":0},{"$f":"IF(O53=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AH$55:$AH$57,$AH53,S$55:S$57)","v":0},")",{"$f":"IF((SUM(IF($AH$55:$AH$57=\"c\",IF(U$55:U$57=\"(\",-V$55:V$57,V$55:V$57))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AH$55:$AH$57=\"c\",IF(U$55:U$57=\"(\",-V$55:V$57,V$55:V$57))))","v":0},{"$f":"IF(U53=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AH$55:$AH$57,$AH53,Y$55:Y$57)","v":0},")",{"$f":"IF((SUM(IF($AH$55:$AH$57=\"c\",IF(AA$55:AA$57=\"(\",-AB$55:AB$57,AB$55:AB$57))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AH$55:$AH$57=\"c\",IF(AA$55:AA$57=\"(\",-AB$55:AB$57,AB$55:AB$57))))","v":0},{"$f":"IF(AA53=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AH$55:$AH$57,$AH53,AE$55:AE$57)","v":0},")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5150,{"$f":"IF((SUM(IF($AH$55:$AH$57=\"p\",IF(I$55:I$57=\"(\",-J$55:J$57,J$55:J$57))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AH$55:$AH$57=\"p\",IF(I$55:I$57=\"(\",-J$55:J$57,J$55:J$57))))","v":0},{"$f":"IF(I54=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AH$55:$AH$57,$AH54,M$55:M$57)","v":0},")",{"$f":"IF((SUM(IF($AH$55:$AH$57=\"p\",IF(O$55:O$57=\"(\",-P$55:P$57,P$55:P$57))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AH$55:$AH$57=\"p\",IF(O$55:O$57=\"(\",-P$55:P$57,P$55:P$57))))","v":0},{"$f":"IF(O54=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AH$55:$AH$57,$AH54,S$55:S$57)","v":0},")",{"$f":"IF((SUM(IF($AH$55:$AH$57=\"p\",IF(U$55:U$57=\"(\",-V$55:V$57,V$55:V$57))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AH$55:$AH$57=\"p\",IF(U$55:U$57=\"(\",-V$55:V$57,V$55:V$57))))","v":0},{"$f":"IF(U54=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AH$55:$AH$57,$AH54,Y$55:Y$57)","v":0},")",{"$f":"IF((SUM(IF($AH$55:$AH$57=\"p\",IF(AA$55:AA$57=\"(\",-AB$55:AB$57,AB$55:AB$57))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AH$55:$AH$57=\"p\",IF(AA$55:AA$57=\"(\",-AB$55:AB$57,AB$55:AB$57))))","v":0},{"$f":"IF(AA54=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AH$55:$AH$57,$AH54,AE$55:AE$57)","v":0},")",null,"p"]
[null,null,null,null,"1.4.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,"p"]
[null,null,null,null,null,"Добавить объект"]
[]
[]
[null,null,null,"1.5. Незаконченные и неоформленные НИОКР и незаконченные операции по приобретению нематериальных активов"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","На начало года",null,null,"Изменения за период",null,null,null,null,null,null,null,null,"На конец периода"]
[null,null,null,null,null,null,null,null,null,null,null,"затраты за период",null,null,"списано затрат как не давших положительного результата",null,null,"принято к учету в качестве нематериальных активов или НИОКР"]
[null,null,null,null,1,2,3,4,null,5,null,null,6,null,7,null,null,8,null,null,null,9]
[null,null,null,null,"1.5.1","Затраты по незаконченным исследованиям и разработкам - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5160,{"$f":"IF((SUM(IF($Y$68:$Y$70=\"c\",IF(I$68:I$70=\"(\",-J$68:J$70,J$68:J$70))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$68:$Y$70=\"c\",IF(I$68:I$70=\"(\",-J$68:J$70,J$68:J$70))))","v":0},{"$f":"IF(I66=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($Y$68:$Y$70=\"c\",IF(L$68:L$70=\"(\",-M$68:M$70,M$68:M$70))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$68:$Y$70=\"c\",IF(L$68:L$70=\"(\",-M$68:M$70,M$68:M$70))))","v":0},{"$f":"IF(L66=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($Y$68:$Y$70,$Y66,P$68:P$70)","v":0},")","(",{"$f":"SUMIF($Y$68:$Y$70,$Y66,S$68:S$70)","v":0},")",{"$f":"IF((SUM(IF($Y$68:$Y$70=\"c\",IF(U$68:U$70=\"(\",-V$68:V$70,V$68:V$70))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$68:$Y$70=\"c\",IF(U$68:U$70=\"(\",-V$68:V$70,V$68:V$70))))","v":0},{"$f":"IF(U66=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5170,{"$f":"IF((SUM(IF($Y$68:$Y$70=\"p\",IF(I$68:I$70=\"(\",-J$68:J$70,J$68:J$70))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$68:$Y$70=\"p\",IF(I$68:I$70=\"(\",-J$68:J$70,J$68:J$70))))","v":0},{"$f":"IF(I67=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($Y$68:$Y$70=\"p\",IF(L$68:L$70=\"(\",-M$68:M$70,M$68:M$70))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$68:$Y$70=\"p\",IF(L$68:L$70=\"(\",-M$68:M$70,M$68:M$70))))","v":0},{"$f":"IF(L67=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($Y$68:$Y$70,$Y67,P$68:P$70)","v":0},")","(",{"$f":"SUMIF($Y$68:$Y$70,$Y67,S$68:S$70)","v":0},")",{"$f":"IF((SUM(IF($Y$68:$Y$70=\"p\",IF(U$68:U$70=\"(\",-V$68:V$70,V$68:V$70))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$68:$Y$70=\"p\",IF(U$68:U$70=\"(\",-V$68:V$70,V$68:V$70))))","v":0},{"$f":"IF(U67=\"(\",\")\",\"\")","v":""},null,"p"]
[null,null,null,null,"1.5.1.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"p"]
[null,null,null,null,null,"Добавить объект"]
[null,null,null,null,"1.5.2","Незаконченные операции по приобретению нематериальных активов - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5180,{"$f":"IF((SUM(IF($Y$73:$Y$75=\"c\",IF(I$73:I$75=\"(\",-J$73:J$75,J$73:J$75))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$73:$Y$75=\"c\",IF(I$73:I$75=\"(\",-J$73:J$75,J$73:J$75))))","v":0},{"$f":"IF(I71=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($Y$73:$Y$75=\"c\",IF(L$73:L$75=\"(\",-M$73:M$75,M$73:M$75))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$73:$Y$75=\"c\",IF(L$73:L$75=\"(\",-M$73:M$75,M$73:M$75))))","v":0},{"$f":"IF(L71=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($Y$73:$Y$75,$Y71,P$73:P$75)","v":0},")","(",{"$f":"SUMIF($Y$73:$Y$75,$Y71,S$73:S$75)","v":0},")",{"$f":"IF((SUM(IF($Y$73:$Y$75=\"c\",IF(U$73:U$75=\"(\",-V$73:V$75,V$73:V$75))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$73:$Y$75=\"c\",IF(U$73:U$75=\"(\",-V$73:V$75,V$73:V$75))))","v":0},{"$f":"IF(U71=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5190,{"$f":"IF((SUM(IF($Y$73:$Y$75=\"p\",IF(I$73:I$75=\"(\",-J$73:J$75,J$73:J$75))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$73:$Y$75=\"p\",IF(I$73:I$75=\"(\",-J$73:J$75,J$73:J$75))))","v":0},{"$f":"IF(I72=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($Y$73:$Y$75=\"p\",IF(L$73:L$75=\"(\",-M$73:M$75,M$73:M$75))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$73:$Y$75=\"p\",IF(L$73:L$75=\"(\",-M$73:M$75,M$73:M$75))))","v":0},{"$f":"IF(L72=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($Y$73:$Y$75,$Y72,P$73:P$75)","v":0},")","(",{"$f":"SUMIF($Y$73:$Y$75,$Y72,S$73:S$75)","v":0},")",{"$f":"IF((SUM(IF($Y$73:$Y$75=\"p\",IF(U$73:U$75=\"(\",-V$73:V$75,V$73:V$75))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$73:$Y$75=\"p\",IF(U$73:U$75=\"(\",-V$73:V$75,V$73:V$75))))","v":0},{"$f":"IF(U72=\"(\",\")\",\"\")","v":""},null,"p"]
[null,null,null,null,"1.5.2.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"p"]
[null,null,null,null,null,"Добавить объект"]

{"sheet":"Стр 4-6","index":5,"n_rows":73,"n_cols":40,"rows_kept":73,"cut":false,"hidden":false,"merged":[[7,3,7,38],[9,3,9,38],[12,4,14,4],[12,5,14,5],[12,6,14,6],[14,20,14,22],[14,26,14,28],[12,7,14,7],[12,8,12,13],[13,23,14,25],[13,26,13,31],[12,32,12,37],[13,8,14,10],[13,35,14,37],[14,17,14,19],[14,29,14,31],[13,32,14,34],[41,4,42,4],[41,5,42,5],[15,35,15,37],[15,11,15,13],[15,17,15,19],[15,23,15,25],[13,11,14,13],[21,4,22,4],[21,5,22,5],[23,4,24,4],[23,5,24,5],[31,3,31,23],[34,4,35,4],[34,5,35,5],[34,6,35,6],[12,14,12,31],[13,14,14,16],[13,17,13,22],[18,4,19,4],[18,5,19,5],[16,4,17,4],[16,5,17,5],[34,7,35,7],[34,20,35,22],[35,17,35,19],[35,14,35,16],[34,8,35,10],[34,11,34,19],[35,11,35,13],[36,11,36,13],[36,17,36,19],[37,4,38,4],[37,5,38,5],[39,4,40,4],[39,5,40,5],[50,5,50,6],[50,11,50,13],[51,5,51,6],[52,5,52,6],[46,3,46,14],[49,5,49,6],[49,8,49,10],[49,11,49,13],[54,5,54,6],[55,5,55,6],[59,3,59,17],[62,5,62,6],[62,8,62,10],[62,11,62,13],[62,14,62,16],[63,5,63,6],[63,11,63,13],[70,5,70,6],[71,5,71,6],[64,5,64,6],[65,5,65,6],[66,5,66,6],[67,5,67,6],[68,5,68,6],[69,5,69,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Форма 0710005 с. 4-6"]
[null,null,null,"2. Основные средства"]
[]
[null,null,null,"2.1. Наличие и движение основных средств"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","На начало года",null,null,null,null,null,"Изменения за период",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"На конец периода"]
[null,null,null,null,null,null,null,null,"первоначальная стоимость *",null,null,"накопленная амортизация **",null,null,"поступило",null,null,"выбыло объектов",null,null,null,null,null,"начислено амортизации **",null,null,"переоценка",null,null,null,null,null,"первоначальная стоимость *",null,null,"накопленная амортизация **"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"первоначальная стоимость *",null,null,"накопленная амортизация **",null,null,null,null,null,"первоначальная стоимость *",null,null,"накопленная амортизация **"]
[null,null,null,null,1,2,3,4,null,5,null,6,null,null,null,7,null,8,null,null,null,9,null,10,null,null,null,11,null,null,12,null,null,13,null,14]
[null,null,null,null,"1.1","Основные средства (без учета доходных вложений в материальные ценности) - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5200,{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))","v":2902807},{"$f":"IF(I17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN17,M$19:M$21)","v":1240510},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))","v":198021},{"$f":"IF(O17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN17,S$19:S$21)","v":6990},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))","v":7030},{"$f":"IF(U17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN17,Y$19:Y$21)","v":150942},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))","v":111896},{"$f":"IF(AA17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))<0,\"(\",\"\")","v":"("},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))","v":234},{"$f":"IF(AD17=\"(\",\")\",\"\")","v":")"},{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))","v":3205734},{"$f":"IF(AG17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN17,AK$19:AK$21)","v":1384666},")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5210,{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))","v":2768533},{"$f":"IF(I18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN18,M$19:M$21)","v":1109551},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))","v":144675},{"$f":"IF(O18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN18,S$19:S$21)","v":10401},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))","v":1677},{"$f":"IF(U18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN18,Y$19:Y$21)","v":140142},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))","v":0},{"$f":"IF(AA18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))<0,\"(\",\"\")","v":"("},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))","v":7506},{"$f":"IF(AD18=\"(\",\")\",\"\")","v":")"},{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))","v":2902807},{"$f":"IF(AG18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN18,AK$19:AK$21)","v":1240510},")",null,"p"]
[null,null,null,null,"1.1.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,2902807,null,"(",1240510,")",null,198021,null,"(",6990,")",null,7030,null,"(",150942,")",null,111896,null,"(",234,")",null,3205734,null,"(",1384666,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,2768533,null,"(",1109551,")",null,144675,null,"(",10401,")",null,1677,null,"(",140142,")",null,0,null,"(",7506,")",null,2902807,null,"(",1240510,")",null,"p"]
[null,null,null,null,null,"Добавить группу основных средств"]
[null,null,null,null,"1.2","Учтено в составе доходных вложений в материальные ценности - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5220,{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))","v":0},{"$f":"IF(I22=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN22,M$24:M$26)","v":0},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))","v":0},{"$f":"IF(O22=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN22,S$24:S$26)","v":0},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(U$24:U$26=\"(\",-V$24:V$26,V$24:V$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(U$24:U$26=\"(\",-V$24:V$26,V$24:V$26))))","v":0},{"$f":"IF(U22=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN22,Y$24:Y$26)","v":0},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))","v":0},{"$f":"IF(AA22=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(AD$24:AD$26=\"(\",-AE$24:AE$26,AE$24:AE$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(AD$24:AD$26=\"(\",-AE$24:AE$26,AE$24:AE$26))))","v":0},{"$f":"IF(AD22=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))","v":0},{"$f":"IF(AG22=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN22,AK$24:AK$26)","v":0},")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5230,{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))","v":0},{"$f":"IF(I23=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN23,M$24:M$26)","v":0},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))","v":0},{"$f":"IF(O23=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN23,S$24:S$26)","v":0},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(U$24:U$26=\"(\",-V$24:V$26,V$24:V$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(U$24:U$26=\"(\",-V$24:V$26,V$24:V$26))))","v":0},{"$f":"IF(U23=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN23,Y$24:Y$26)","v":0},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))","v":0},{"$f":"IF(AA23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(AD$24:AD$26=\"(\",-AE$24:AE$26,AE$24:AE$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(AD$24:AD$26=\"(\",-AE$24:AE$26,AE$24:AE$26))))","v":0},{"$f":"IF(AD23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))","v":0},{"$f":"IF(AG23=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN23,AK$24:AK$26)","v":0},")",null,"p"]
[null,null,null,null,"1.2.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,"(",null,")",null,"p"]
[null,null,null,null,null,"Добавить группу объектов"]
[]
[null,null,null,null,"*","В случае переоценки в графе \"Первоначальная стоимость\" приводится текущая рыночная стоимость или текущая (восстановительная) стоимость."]
[null,null,null,null,"**","Некоммерческая организация графы \"Накопленная амортизация\" и \"Начисленная амортизация\" именует соответственно \"Накопленный износ\" и \"Начисленный износ\""]
[]
[]
[null,null,null,"2.2. Незавершенные капитальные вложения"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","На начало года",null,null,"Изменения за период",null,null,null,null,null,null,null,null,"На конец периода"]
[null,null,null,null,null,null,null,null,null,null,null,"затраты за период",null,null,"списано",null,null,"принято к учету в качестве основных средств или увеличена стоимость"]
[null,null,null,null,1,2,3,4,null,5,null,6,null,null,null,7,null,8,null,null,null,9]
[null,null,null,null,"2","Незавершенное строительство и незаконченные операции по приобретению, модернизации и т.п. основных средств - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5240,{"$f":"IF((SUM(IF($Y$40:$Y$44=\"c\",IF(I$40:I$44=\"(\",-J$40:J$44,J$40:J$44))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$40:$Y$44=\"c\",IF(I$40:I$44=\"(\",-J$40:J$44,J$40:J$44))))","v":261911},{"$f":"IF(I38=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($Y$40:$Y$44=\"c\",IF(L$40:L$44=\"(\",-M$40:M$44,M$40:M$44))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$40:$Y$44=\"c\",IF(L$40:L$44=\"(\",-M$40:M$44,M$40:M$44))))","v":166628},{"$f":"IF(L38=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($Y$40:$Y$44,$Y38,P$40:P$44)","v":1299},")","(",{"$f":"SUMIF($Y$40:$Y$44,$Y38,S$40:S$44)","v":312014},")",{"$f":"IF((SUM(IF($Y$40:$Y$44=\"c\",IF(U$40:U$44=\"(\",-V$40:V$44,V$40:V$44))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$40:$Y$44=\"c\",IF(U$40:U$44=\"(\",-V$40:V$44,V$40:V$44))))","v":115226},{"$f":"IF(U38=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5250,{"$f":"IF((SUM(IF($Y$40:$Y$44=\"p\",IF(I$40:I$44=\"(\",-J$40:J$44,J$40:J$44))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$40:$Y$44=\"p\",IF(I$40:I$44=\"(\",-J$40:J$44,J$40:J$44))))","v":210085},{"$f":"IF(I39=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($Y$40:$Y$44=\"p\",IF(L$40:L$44=\"(\",-M$40:M$44,M$40:M$44))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$40:$Y$44=\"p\",IF(L$40:L$44=\"(\",-M$40:M$44,M$40:M$44))))","v":344707},{"$f":"IF(L39=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($Y$40:$Y$44,$Y39,P$40:P$44)","v":1300},")","(",{"$f":"SUMIF($Y$40:$Y$44,$Y39,S$40:S$44)","v":291581},")",{"$f":"IF((SUM(IF($Y$40:$Y$44=\"p\",IF(U$40:U$44=\"(\",-V$40:V$44,V$40:V$44))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($Y$40:$Y$44=\"p\",IF(U$40:U$44=\"(\",-V$40:V$44,V$40:V$44))))","v":261911},{"$f":"IF(U39=\"(\",\")\",\"\")","v":""},null,"p"]
[null,null,null,null,"2.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,250715,null,null,166628,null,"(",null,")","(",312014,")",null,105329,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,197589,null,null,344707,null,"(",null,")","(",291581,")",null,250715,null,null,"p"]
[null,null,null,"Удалить группу","2.2","Расходы будущих периодов долгосрочного характера(энергоаудит)",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},5240,null,11196,null,null,0,null,"(",1299,")","(",null,")",null,9897,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},5250,null,12496,null,null,null,null,"(",1300,")","(",null,")",null,11196,null,null,"p"]
[null,null,null,null,null,"Добавить группу объектов"]
[]
[]
[null,null,null,"2.3. Изменение стоимости основных средств в результате достройки, дооборудования, реконструкции и частичной ликвидации"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"За \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"За 2016 год"},null,null,{"$f":"\"За \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"За 2015 год"}]
[null,null,null,null,1,2,null,3,null,4,null,5]
[null,null,null,null,"3.1","Увеличение стоимости объектов основных средств в результате достройки, дооборудования, реконструкции - всего, в том числе: ",null,5260,{"$f":"IF((SUMIF(I53:I54,\"\",J53:J54)-SUMIF(I53:I54,\"(\",J53:J54))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I53:I54,\"\",J53:J54)-SUMIF(I53:I54,\"(\",J53:J54))","v":0},{"$f":"IF(I52=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L53:L54,\"\",M53:M54)-SUMIF(L53:L54,\"(\",M53:M54))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L53:L54,\"\",M53:M54)-SUMIF(L53:L54,\"(\",M53:M54))","v":0},{"$f":"IF(L52=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"3.1.1"]
[null,null,null,null,null,"Добавить объект основных средств"]
[null,null,null,null,"3.2","Уменьшение стоимости объектов основных средств в результате частичной ликвидации - всего, в том числе: ",null,5270,"(",{"$f":"SUM(J56:J57)","v":0},")","(",{"$f":"SUM(M56:M57)","v":0},")"]
[null,null,null,null,"3.2.1",null,null,null,"(",null,")","(",null,")"]
[null,null,null,null,null,"Добавить объект основных средств"]
[]
[]
[null,null,null,"2.4. Иное использование основных средств"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"На \"&IF(report_date = \"\",\"отчётную дату отчётного года\",report_date& \" г.\")","v":"На 31.12.2016 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"предыдущего года\",god-1& \" г.\")","v":"На 31 декабря 2015 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"года, предшествующего предыдущему\",god-2& \" г.\")","v":"На 31 декабря 2014 г."}]
[null,null,null,null,1,2,null,3,null,4,null,5,null,null,null,6]
[null,null,null,null,"4.1","Переданные в аренду основные средства, числящиеся на балансе",null,5280]
[null,null,null,null,"4.2","Переданные в аренду основные средства, числящиеся за балансом",null,5281]
[null,null,null,null,"4.3","Полученные в аренду основные средства, числящиеся на балансе",null,5282]
[null,null,null,null,"4.4","Полученные в аренду основные средства, числящиеся за балансом",null,5283]
[null,null,null,null,"4.5","Объекты недвижимости, принятые в эксплуатацию и фактически используемые, находящиеся в процессе государственной регистрации",null,5284]
[null,null,null,null,"4.6","Основные средства, переведенные на консервацию",null,5285]
[null,null,null,null,"4.7","Иное использование основных средств (залог и др.)",null,5286,{"$f":"IF((SUMIF(I72:I73,\"\",J72:J73)-SUMIF(I72:I73,\"(\",J72:J73))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I72:I73,\"\",J72:J73)-SUMIF(I72:I73,\"(\",J72:J73))","v":0},{"$f":"IF(I71=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L72:L73,\"\",M72:M73)-SUMIF(L72:L73,\"(\",M72:M73))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L72:L73,\"\",M72:M73)-SUMIF(L72:L73,\"(\",M72:M73))","v":0},{"$f":"IF(L71=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O72:O73,\"\",P72:P73)-SUMIF(O72:O73,\"(\",P72:P73))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O72:O73,\"\",P72:P73)-SUMIF(O72:O73,\"(\",P72:P73))","v":0},{"$f":"IF(O71=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"4.7.1"]
[null,null,null,null,null,"Добавить объект основных средств"]

{"sheet":"Стр 7-9","index":6,"n_rows":76,"n_cols":37,"rows_kept":76,"cut":false,"hidden":false,"merged":[[12,8,12,13],[13,32,14,34],[14,17,14,19],[14,20,14,22],[12,14,12,28],[12,29,12,34],[13,8,14,10],[15,32,15,34],[7,3,7,35],[9,3,9,35],[12,4,14,4],[12,5,14,5],[12,6,14,6],[12,7,14,7],[13,23,14,25],[13,26,14,28],[13,29,14,31],[15,11,15,13],[15,17,15,19],[15,23,15,25],[13,11,14,13],[13,14,14,16],[13,17,13,22],[21,4,22,4],[21,5,22,5],[23,4,24,4],[23,5,24,5],[16,4,17,4],[16,5,17,5],[18,4,19,4],[18,5,19,5],[39,5,39,6],[39,11,39,13],[40,5,40,6],[41,5,41,6],[26,4,27,4],[26,5,27,5],[35,3,35,17],[38,5,38,6],[38,8,38,10],[38,11,38,13],[38,14,38,16],[43,5,43,6],[44,5,44,6],[46,5,46,6],[49,3,49,35],[55,23,56,25],[55,26,56,28],[51,3,51,35],[54,4,56,4],[54,5,56,5],[54,6,56,6],[55,14,56,16],[55,17,55,22],[54,7,56,7],[54,8,54,13],[54,14,54,28],[54,29,54,34],[57,17,57,19],[57,23,57,25],[57,32,57,34],[55,29,56,31],[55,32,56,34],[56,17,56,19],[56,20,56,22],[55,8,56,10],[55,11,56,13],[58,4,59,4],[58,5,59,5],[60,4,61,4],[60,5,61,5],[57,11,57,13],[65,3,65,17],[68,5,68,6],[68,8,68,10],[68,11,68,13],[68,14,68,16],[73,5,73,6],[74,5,74,6],[69,5,69,6],[69,11,69,13],[70,5,70,6],[71,5,71,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Форма 0710005 с. 7-9"]
[null,null,null,"3. Финансовые вложения"]
[]
[null,null,null,"3.1. Наличие и движение финансовых вложений"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","На начало года",null,null,null,null,null,"Изменения за период",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"На конец периода"]
[null,null,null,null,null,null,null,null,"первоначальная стоимость",null,null,"накопленная корректировка *",null,null,"поступило",null,null,"выбыло (погашено)",null,null,null,null,null,"начисление\nпроцентов (включая доведение перво-начальной стоимости до номинальной)",null,null,"текущей рыночной стоимости (убытков от обесценения)",null,null,"первоначальная стоимость",null,null,"накопленная корректировка *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"первоначальная стоимость",null,null,"накопленная корректировка *"]
[null,null,null,null,1,2,3,4,null,5,null,6,null,null,null,7,null,8,null,null,null,9,null,10,null,null,null,11,null,null,12,null,13]
[null,null,null,null,"1.1.1","Долгосрочные - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5301,{"$f":"IF((SUM(IF($AK$19:$AK$21=\"c\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"c\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))","v":0},{"$f":"IF(I17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"c\",IF(L$19:L$21=\"(\",-M$19:M$21,M$19:M$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"c\",IF(L$19:L$21=\"(\",-M$19:M$21,M$19:M$21))))","v":0},{"$f":"IF(L17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"c\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"c\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))","v":0},{"$f":"IF(O17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$19:$AK$21,$AK17,S$19:S$21)","v":0},")",{"$f":"IF((SUM(IF($AK$19:$AK$21=\"c\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"c\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))","v":0},{"$f":"IF(U17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"c\",IF(X$19:X$21=\"(\",-Y$19:Y$21,Y$19:Y$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"c\",IF(X$19:X$21=\"(\",-Y$19:Y$21,Y$19:Y$21))))","v":0},{"$f":"IF(X17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"c\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"c\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))","v":0},{"$f":"IF(AA17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"c\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"c\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))","v":0},{"$f":"IF(AD17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"c\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"c\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))","v":0},{"$f":"IF(AG17=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5311,{"$f":"IF((SUM(IF($AK$19:$AK$21=\"p\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"p\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))","v":0},{"$f":"IF(I18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"p\",IF(L$19:L$21=\"(\",-M$19:M$21,M$19:M$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"p\",IF(L$19:L$21=\"(\",-M$19:M$21,M$19:M$21))))","v":0},{"$f":"IF(L18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"p\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"p\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))","v":0},{"$f":"IF(O18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$19:$AK$21,$AK18,S$19:S$21)","v":0},")",{"$f":"IF((SUM(IF($AK$19:$AK$21=\"p\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"p\",IF(U$19:U$21=\"(\",-V$19:V$21,V$19:V$21))))","v":0},{"$f":"IF(U18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"p\",IF(X$19:X$21=\"(\",-Y$19:Y$21,Y$19:Y$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"p\",IF(X$19:X$21=\"(\",-Y$19:Y$21,Y$19:Y$21))))","v":0},{"$f":"IF(X18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"p\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"p\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))","v":0},{"$f":"IF(AA18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"p\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"p\",IF(AD$19:AD$21=\"(\",-AE$19:AE$21,AE$19:AE$21))))","v":0},{"$f":"IF(AD18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$19:$AK$21=\"p\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$19:$AK$21=\"p\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))","v":0},{"$f":"IF(AG18=\"(\",\")\",\"\")","v":""},null,"p"]
[null,null,null,null,"1.1.1.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,null,null,null,null,null,null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,null,null,null,null,null,null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p"]
[null,null,null,null,null,"Добавить группу/вид"]
[null,null,null,null,"1.1.2","Краткосрочные - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5305,{"$f":"IF((SUM(IF($AK$24:$AK$26=\"c\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"c\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))","v":0},{"$f":"IF(I22=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"c\",IF(L$24:L$26=\"(\",-M$24:M$26,M$24:M$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"c\",IF(L$24:L$26=\"(\",-M$24:M$26,M$24:M$26))))","v":0},{"$f":"IF(L22=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"c\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"c\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))","v":0},{"$f":"IF(O22=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$24:$AK$26,$AK22,S$24:S$26)","v":0},")",{"$f":"IF((SUM(IF($AK$24:$AK$26=\"c\",IF(U$24:U$26=\"(\",-V$24:V$26,V$24:V$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"c\",IF(U$24:U$26=\"(\",-V$24:V$26,V$24:V$26))))","v":0},{"$f":"IF(U22=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"c\",IF(X$24:X$26=\"(\",-Y$24:Y$26,Y$24:Y$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"c\",IF(X$24:X$26=\"(\",-Y$24:Y$26,Y$24:Y$26))))","v":0},{"$f":"IF(X22=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"c\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"c\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))","v":0},{"$f":"IF(AA22=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"c\",IF(AD$24:AD$26=\"(\",-AE$24:AE$26,AE$24:AE$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"c\",IF(AD$24:AD$26=\"(\",-AE$24:AE$26,AE$24:AE$26))))","v":0},{"$f":"IF(AD22=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"c\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"c\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))","v":0},{"$f":"IF(AG22=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5315,{"$f":"IF((SUM(IF($AK$24:$AK$26=\"p\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"p\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))","v":0},{"$f":"IF(I23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"p\",IF(L$24:L$26=\"(\",-M$24:M$26,M$24:M$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"p\",IF(L$24:L$26=\"(\",-M$24:M$26,M$24:M$26))))","v":0},{"$f":"IF(L23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"p\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"p\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))","v":0},{"$f":"IF(O23=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$24:$AK$26,$AK23,S$24:S$26)","v":0},")",{"$f":"IF((SUM(IF($AK$24:$AK$26=\"p\",IF(U$24:U$26=\"(\",-V$24:V$26,V$24:V$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"p\",IF(U$24:U$26=\"(\",-V$24:V$26,V$24:V$26))))","v":0},{"$f":"IF(U23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"p\",IF(X$24:X$26=\"(\",-Y$24:Y$26,Y$24:Y$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"p\",IF(X$24:X$26=\"(\",-Y$24:Y$26,Y$24:Y$26))))","v":0},{"$f":"IF(X23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"p\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"p\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))","v":0},{"$f":"IF(AA23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"p\",IF(AD$24:AD$26=\"(\",-AE$24:AE$26,AE$24:AE$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"p\",IF(AD$24:AD$26=\"(\",-AE$24:AE$26,AE$24:AE$26))))","v":0},{"$f":"IF(AD23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$24:$AK$26=\"p\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$24:$AK$26=\"p\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))","v":0},{"$f":"IF(AG23=\"(\",\")\",\"\")","v":""},null,"p"]
[null,null,null,null,"1.1.2.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,null,null,null,null,null,null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,null,null,null,null,null,null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p"]
[null,null,null,null,null,"Добавить группу/вид"]
[null,null,null,null,"1.1.3","Финансовых вложений - \nитого",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5300,{"$f":"IF((IF(I17=\"(\",-J17,J17)+IF(I22=\"(\",-J22,J22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(I17=\"(\",-J17,J17)+IF(I22=\"(\",-J22,J22))","v":0},{"$f":"IF(I27=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(L17=\"(\",-M17,M17)+IF(L22=\"(\",-M22,M22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(L17=\"(\",-M17,M17)+IF(L22=\"(\",-M22,M22))","v":0},{"$f":"IF(L27=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(O17=\"(\",-P17,P17)+IF(O22=\"(\",-P22,P22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(O17=\"(\",-P17,P17)+IF(O22=\"(\",-P22,P22))","v":0},{"$f":"IF(O27=\"(\",\")\",\"\")","v":""},"(",{"$f":"S17+S22","v":0},")",{"$f":"IF((IF(U17=\"(\",-V17,V17)+IF(U22=\"(\",-V22,V22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(U17=\"(\",-V17,V17)+IF(U22=\"(\",-V22,V22))","v":0},{"$f":"IF(U27=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(X17=\"(\",-Y17,Y17)+IF(X22=\"(\",-Y22,Y22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(X17=\"(\",-Y17,Y17)+IF(X22=\"(\",-Y22,Y22))","v":0},{"$f":"IF(X27=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(AA17=\"(\",-AB17,AB17)+IF(AA22=\"(\",-AB22,AB22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AA17=\"(\",-AB17,AB17)+IF(AA22=\"(\",-AB22,AB22))","v":0},{"$f":"IF(AA27=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(AD17=\"(\",-AE17,AE17)+IF(AD22=\"(\",-AE22,AE22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AD17=\"(\",-AE17,AE17)+IF(AD22=\"(\",-AE22,AE22))","v":0},{"$f":"IF(AD27=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(AG17=\"(\",-AH17,AH17)+IF(AG22=\"(\",-AH22,AH22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AG17=\"(\",-AH17,AH17)+IF(AG22=\"(\",-AH22,AH22))","v":0},{"$f":"IF(AG27=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5310,{"$f":"IF((IF(I18=\"(\",-J18,J18)+IF(I23=\"(\",-J23,J23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(I18=\"(\",-J18,J18)+IF(I23=\"(\",-J23,J23))","v":0},{"$f":"IF(I28=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(L18=\"(\",-M18,M18)+IF(L23=\"(\",-M23,M23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(L18=\"(\",-M18,M18)+IF(L23=\"(\",-M23,M23))","v":0},{"$f":"IF(L28=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(O18=\"(\",-P18,P18)+IF(O23=\"(\",-P23,P23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(O18=\"(\",-P18,P18)+IF(O23=\"(\",-P23,P23))","v":0},{"$f":"IF(O28=\"(\",\")\",\"\")","v":""},"(",{"$f":"S18+S23","v":0},")",{"$f":"IF((IF(U18=\"(\",-V18,V18)+IF(U23=\"(\",-V23,V23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(U18=\"(\",-V18,V18)+IF(U23=\"(\",-V23,V23))","v":0},{"$f":"IF(U28=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(X18=\"(\",-Y18,Y18)+IF(X23=\"(\",-Y23,Y23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(X18=\"(\",-Y18,Y18)+IF(X23=\"(\",-Y23,Y23))","v":0},{"$f":"IF(X28=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(AA18=\"(\",-AB18,AB18)+IF(AA23=\"(\",-AB23,AB23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AA18=\"(\",-AB18,AB18)+IF(AA23=\"(\",-AB23,AB23))","v":0},{"$f":"IF(AA28=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(AD18=\"(\",-AE18,AE18)+IF(AD23=\"(\",-AE23,AE23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AD18=\"(\",-AE18,AE18)+IF(AD23=\"(\",-AE23,AE23))","v":0},{"$f":"IF(AD28=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(AG18=\"(\",-AH18,AH18)+IF(AG23=\"(\",-AH23,AH23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AG18=\"(\",-AH18,AH18)+IF(AG23=\"(\",-AH23,AH23))","v":0},{"$f":"IF(AG28=\"(\",\")\",\"\")","v":""},null,"p"]
[]
[null,null,null,null,"*","Накопленная корректировка определяется как:"]
[null,null,null,null,null,"- разница между первоначальной и текущей рыночной стоимостью - по финансовым вложениям, по которым можно определить текущую рыночную стоимость;"]
[null,null,null,null,null,"- начисленная в течение срока обращения разница между первоначальной стоимостью и номинальной стоимостью - по долговым ценным бумагам, по которым не определяется текущая рыночная стоимость;"]
[null,null,null,null,null,"- величина резерва под обесценение финансовых вложений, созданного на предыдущую отчетную дату, - по финансовым вложениям, по которым не определяется текущая рыночная стоимость;"]
[]
[]
[null,null,null,"3.2. Иное использование финансовых вложений"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"На \"&IF(report_date = \"\",\"отчётную дату отчётного года\",report_date& \" г.\")","v":"На 31.12.2016 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"предыдущего года\",god-1& \" г.\")","v":"На 31 декабря 2015 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"года, предшествующего предыдущему\",god-2& \" г.\")","v":"На 31 декабря 2014 г."}]
[null,null,null,null,1,2,null,3,null,4,null,4,null,null,null,5]
[null,null,null,null,"1.2.1","Финансовые вложения, находящиеся в залоге - всего, в том числе: ",null,5320,{"$f":"IF((SUMIF(I42:I43,\"\",J42:J43)-SUMIF(I42:I43,\"(\",J42:J43))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I42:I43,\"\",J42:J43)-SUMIF(I42:I43,\"(\",J42:J43))","v":0},{"$f":"IF(I41=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L42:L43,\"\",M42:M43)-SUMIF(L42:L43,\"(\",M42:M43))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L42:L43,\"\",M42:M43)-SUMIF(L42:L43,\"(\",M42:M43))","v":0},{"$f":"IF(L41=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O42:O43,\"\",P42:P43)-SUMIF(O42:O43,\"(\",P42:P43))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O42:O43,\"\",P42:P43)-SUMIF(O42:O43,\"(\",P42:P43))","v":0},{"$f":"IF(O41=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"1.2.1.1"]
[null,null,null,null,null,"Добавить группу/вид"]
[null,null,null,null,"1.2.2","Финансовые вложения, переданные третьим лицам (кроме продажи) - всего, в том числе: ",null,5325,{"$f":"IF((SUMIF(I45:I46,\"\",J45:J46)-SUMIF(I45:I46,\"(\",J45:J46))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I45:I46,\"\",J45:J46)-SUMIF(I45:I46,\"(\",J45:J46))","v":0},{"$f":"IF(I44=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L45:L46,\"\",M45:M46)-SUMIF(L45:L46,\"(\",M45:M46))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L45:L46,\"\",M45:M46)-SUMIF(L45:L46,\"(\",M45:M46))","v":0},{"$f":"IF(L44=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O45:O46,\"\",P45:P46)-SUMIF(O45:O46,\"(\",P45:P46))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O45:O46,\"\",P45:P46)-SUMIF(O45:O46,\"(\",P45:P46))","v":0},{"$f":"IF(O44=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"1.2.2.1"]
[null,null,null,null,null,"Добавить группу/вид"]
[null,null,null,null,"1.2.3","Иное использование финансовых вложений",null,5329]
[]
[]
[null,null,null,"4. Запасы"]
[]
[null,null,null,"4.1. Наличие и движение запасов"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","На начало года",null,null,null,null,null,"Изменения за период",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"На конец периода"]
[null,null,null,null,null,null,null,null,"себестоимость",null,null,"величина резерва\nпод снижение стоимости",null,null,"поступления\nи затраты",null,null,"выбыло",null,null,null,null,null,"убытков\nот снижения стоимости",null,null,"оборот запасов между их группами (видами)",null,null,"себестоимость",null,null,"величина резерва\nпод снижение стоимости"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"себестоимость",null,null,"резерв\nпод снижение стоимости"]
[null,null,null,null,1,2,3,4,null,5,null,6,null,null,null,7,null,8,null,null,null,9,null,10,null,null,null,11,null,null,12,null,13]
[null,null,null,null,"2.1","Запасы - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5400,{"$f":"IF((SUM(IF($AK$61:$AK$63=\"c\",IF(I$61:I$63=\"(\",-J$61:J$63,J$61:J$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"c\",IF(I$61:I$63=\"(\",-J$61:J$63,J$61:J$63))))","v":47372},{"$f":"IF(I59=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$61:$AK$63,$AK59,M$61:M$63)","v":0},")",{"$f":"IF((SUM(IF($AK$61:$AK$63=\"c\",IF(O$61:O$63=\"(\",-P$61:P$63,P$61:P$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"c\",IF(O$61:O$63=\"(\",-P$61:P$63,P$61:P$63))))","v":124557},{"$f":"IF(O59=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$61:$AK$63,$AK59,S$61:S$63)","v":118322},")",{"$f":"IF((SUM(IF($AK$61:$AK$63=\"c\",IF(U$61:U$63=\"(\",-V$61:V$63,V$61:V$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"c\",IF(U$61:U$63=\"(\",-V$61:V$63,V$61:V$63))))","v":0},{"$f":"IF(U59=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$61:$AK$63=\"c\",IF(X$61:X$63=\"(\",-Y$61:Y$63,Y$61:Y$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"c\",IF(X$61:X$63=\"(\",-Y$61:Y$63,Y$61:Y$63))))","v":0},{"$f":"IF(X59=\"(\",\")\",\"\")","v":""},null,"x",null,{"$f":"IF((SUM(IF($AK$61:$AK$63=\"c\",IF(AD$61:AD$63=\"(\",-AE$61:AE$63,AE$61:AE$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"c\",IF(AD$61:AD$63=\"(\",-AE$61:AE$63,AE$61:AE$63))))","v":53607},{"$f":"IF(AD59=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$61:$AK$63,$AK59,AH$61:AH$63)","v":0},")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5420,{"$f":"IF((SUM(IF($AK$61:$AK$63=\"p\",IF(I$61:I$63=\"(\",-J$61:J$63,J$61:J$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"p\",IF(I$61:I$63=\"(\",-J$61:J$63,J$61:J$63))))","v":44405},{"$f":"IF(I60=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$61:$AK$63,$AK60,M$61:M$63)","v":0},")",{"$f":"IF((SUM(IF($AK$61:$AK$63=\"p\",IF(O$61:O$63=\"(\",-P$61:P$63,P$61:P$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"p\",IF(O$61:O$63=\"(\",-P$61:P$63,P$61:P$63))))","v":111957},{"$f":"IF(O60=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$61:$AK$63,$AK60,S$61:S$63)","v":108990},")",{"$f":"IF((SUM(IF($AK$61:$AK$63=\"p\",IF(U$61:U$63=\"(\",-V$61:V$63,V$61:V$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"p\",IF(U$61:U$63=\"(\",-V$61:V$63,V$61:V$63))))","v":0},{"$f":"IF(U60=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AK$61:$AK$63=\"p\",IF(X$61:X$63=\"(\",-Y$61:Y$63,Y$61:Y$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"p\",IF(X$61:X$63=\"(\",-Y$61:Y$63,Y$61:Y$63))))","v":0},{"$f":"IF(X60=\"(\",\")\",\"\")","v":""},null,"x",null,{"$f":"IF((SUM(IF($AK$61:$AK$63=\"p\",IF(AD$61:AD$63=\"(\",-AE$61:AE$63,AE$61:AE$63))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AK$61:$AK$63=\"p\",IF(AD$61:AD$63=\"(\",-AE$61:AE$63,AE$61:AE$63))))","v":47372},{"$f":"IF(AD60=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AK$61:$AK$63,$AK60,AH$61:AH$63)","v":0},")",null,"p"]
[null,null,null,null,"2.1.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,47372,null,"(",null,")",null,124557,null,"(",118322,")",null,null,null,null,null,null,null,null,null,null,53607,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,44405,null,"(",null,")",null,111957,null,"(",108990,")",null,null,null,null,null,null,null,null,null,null,47372,null,"(",null,")",null,"p"]
[null,null,null,null,null,"Добавить группу/вид"]
[]
[]
[null,null,null,"4.2. Запасы в залоге"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"На \"&IF(report_date = \"\",\"отчётную дату отчётного года\",report_date& \" г.\")","v":"На 31.12.2016 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"предыдущего года\",god-1& \" г.\")","v":"На 31 декабря 2015 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"года, предшествующего предыдущему\",god-2& \" г.\")","v":"На 31 декабря 2014 г."}]
[null,null,null,null,1,2,null,3,null,4,null,5,null,null,null,6]
[null,null,null,null,"2.2.1","Запасы, не оплаченные на отчетную дату - всего, в том числе: ",null,5440,{"$f":"IF((SUMIF(I72:I73,\"\",J72:J73)-SUMIF(I72:I73,\"(\",J72:J73))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I72:I73,\"\",J72:J73)-SUMIF(I72:I73,\"(\",J72:J73))","v":0},{"$f":"IF(I71=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L72:L73,\"\",M72:M73)-SUMIF(L72:L73,\"(\",M72:M73))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L72:L73,\"\",M72:M73)-SUMIF(L72:L73,\"(\",M72:M73))","v":0},{"$f":"IF(L71=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O72:O73,\"\",P72:P73)-SUMIF(O72:O73,\"(\",P72:P73))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O72:O73,\"\",P72:P73)-SUMIF(O72:O73,\"(\",P72:P73))","v":0},{"$f":"IF(O71=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"2.2.1.1"]
[null,null,null,null,null,"Добавить группу/вид"]
[null,null,null,null,"2.2.2","Запасы, находящиеся в залоге по договору - всего, в том числе: ",null,5445,{"$f":"IF((SUMIF(I75:I76,\"\",J75:J76)-SUMIF(I75:I76,\"(\",J75:J76))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I75:I76,\"\",J75:J76)-SUMIF(I75:I76,\"(\",J75:J76))","v":0},{"$f":"IF(I74=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L75:L76,\"\",M75:M76)-SUMIF(L75:L76,\"(\",M75:M76))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L75:L76,\"\",M75:M76)-SUMIF(L75:L76,\"(\",M75:M76))","v":0},{"$f":"IF(L74=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O75:O76,\"\",P75:P76)-SUMIF(O75:O76,\"(\",P75:P76))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O75:O76,\"\",P75:P76)-SUMIF(O75:O76,\"(\",P75:P76))","v":0},{"$f":"IF(O74=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"2.2.2.1"]
[null,null,null,null,null,"Добавить группу/вид"]

{"sheet":"Стр 10-12","index":7,"n_rows":92,"n_cols":40,"rows_kept":92,"cut":false,"hidden":false,"merged":[[26,4,27,4],[26,5,27,5],[36,17,36,19],[36,20,36,22],[36,23,36,25],[7,3,7,38],[9,3,9,38],[12,4,14,4],[12,5,14,5],[12,6,14,6],[13,20,13,28],[12,32,12,37],[12,14,12,31],[14,23,14,25],[15,29,15,31],[15,35,15,37],[13,32,14,34],[14,17,14,19],[13,8,14,10],[13,29,14,31],[14,26,14,28],[15,20,15,22],[21,4,22,4],[21,5,22,5],[13,35,14,37],[23,4,24,4],[23,5,24,5],[14,20,14,22],[13,11,14,13],[13,14,13,19],[15,11,15,13],[18,4,19,4],[18,5,19,5],[16,4,17,4],[16,5,17,5],[12,7,14,7],[14,14,14,16],[12,8,12,13],[37,5,37,6],[37,14,37,16],[32,3,32,26],[35,4,36,4],[35,5,36,6],[35,7,36,7],[35,8,35,13],[35,14,35,19],[35,20,35,25],[36,8,36,10],[36,11,36,13],[36,14,36,16],[38,5,38,6],[39,5,39,6],[43,3,43,29],[46,4,48,4],[46,5,48,5],[46,6,48,6],[46,7,48,7],[46,8,48,10],[46,11,46,25],[46,26,48,28],[47,11,47,16],[47,17,47,22],[47,23,48,25],[48,11,48,13],[48,14,48,16],[48,17,48,19],[48,20,48,22],[55,4,56,4],[55,5,56,5],[57,4,58,4],[57,5,58,5],[49,17,49,19],[50,4,51,4],[50,5,51,5],[52,4,53,4],[52,5,53,5],[70,5,70,6],[80,11,80,13],[60,4,61,4],[60,5,61,5],[66,3,66,17],[69,5,69,6],[69,8,69,10],[69,11,69,13],[69,14,69,16],[70,11,70,13],[71,5,71,6],[80,5,80,6],[72,5,72,6],[79,5,79,6],[79,8,79,10],[79,11,79,13],[76,3,76,14],[81,5,81,6],[82,5,82,6],[85,5,85,6],[89,5,89,6],[91,5,91,6],[83,5,83,6],[84,5,84,6],[86,5,86,6],[88,5,88,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Форма 0710005 с. 10-12"]
[null,null,null,"5. Дебиторская и кредиторская задолженность"]
[]
[null,null,null,"5.1. Наличие и движение дебиторской задолженности"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","На начало года",null,null,null,null,null,"Изменения за период",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"На конец периода"]
[null,null,null,null,null,null,null,null,"учтенная по условиям договора",null,null,"величина резерва по сомнительным долгам",null,null,"поступление",null,null,null,null,null,"выбыло",null,null,null,null,null,null,null,null,"перевод из долго- в краткосрочную задолженность",null,null,"учтенная по условиям договора",null,null,"величина резерва\nпо сомнительным долгам"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"в результате хозяйственных операций (сумма долга по сделке операции) *",null,null,"причитающиеся проценты, штрафы и иные начисления *",null,null,"погашение",null,null,"списание на финансовый результат *",null,null,"восстановление резерва"]
[null,null,null,null,1,2,3,4,null,5,null,6,null,null,null,7,null,null,8,null,9,null,null,null,10,null,null,11,null,12,null,null,null,13,null,14]
[null,null,null,null,"1.1.1","Долгосрочная дебиторская задолженность - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5501,{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))","v":0},{"$f":"IF(I17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN17,M$19:M$21)","v":0},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))","v":0},{"$f":"IF(O17=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(R$19:R$21=\"(\",-S$19:S$21,S$19:S$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(R$19:R$21=\"(\",-S$19:S$21,S$19:S$21))))","v":0},{"$f":"IF(R17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN17,V$19:V$21)","v":0},")","(",{"$f":"SUMIF($AN$19:$AN$21,$AN17,Y$19:Y$21)","v":0},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))","v":0},{"$f":"IF(AA17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN17,AE$19:AE$21)","v":0},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"c\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"c\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))","v":0},{"$f":"IF(AG17=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN17,AK$19:AK$21)","v":0},")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5521,{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(I$19:I$21=\"(\",-J$19:J$21,J$19:J$21))))","v":0},{"$f":"IF(I18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN18,M$19:M$21)","v":0},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(O$19:O$21=\"(\",-P$19:P$21,P$19:P$21))))","v":0},{"$f":"IF(O18=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(R$19:R$21=\"(\",-S$19:S$21,S$19:S$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(R$19:R$21=\"(\",-S$19:S$21,S$19:S$21))))","v":0},{"$f":"IF(R18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN18,V$19:V$21)","v":0},")","(",{"$f":"SUMIF($AN$19:$AN$21,$AN18,Y$19:Y$21)","v":0},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(AA$19:AA$21=\"(\",-AB$19:AB$21,AB$19:AB$21))))","v":0},{"$f":"IF(AA18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN18,AE$19:AE$21)","v":0},")",{"$f":"IF((SUM(IF($AN$19:$AN$21=\"p\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$19:$AN$21=\"p\",IF(AG$19:AG$21=\"(\",-AH$19:AH$21,AH$19:AH$21))))","v":0},{"$f":"IF(AG18=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$19:$AN$21,$AN18,AK$19:AK$21)","v":0},")",null,"p"]
[null,null,null,null,"1.1.1.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,null,null,"(",null,")",null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,null,null,"(",null,")",null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,"p"]
[null,null,null,null,null,"Добавить вид"]
[null,null,null,null,"1.1.2","Краткосрочная дебиторская задолженность - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5510,{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))","v":217293},{"$f":"IF(I22=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN22,M$24:M$26)","v":83393},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))","v":0},{"$f":"IF(O22=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(R$24:R$26=\"(\",-S$24:S$26,S$24:S$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(R$24:R$26=\"(\",-S$24:S$26,S$24:S$26))))","v":0},{"$f":"IF(R22=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN22,V$24:V$26)","v":0},")","(",{"$f":"SUMIF($AN$24:$AN$26,$AN22,Y$24:Y$26)","v":0},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))","v":0},{"$f":"IF(AA22=\"(\",\")\",\"\")","v":""},null,"x",null,{"$f":"IF((SUM(IF($AN$24:$AN$26=\"c\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"c\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))","v":213418},{"$f":"IF(AG22=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN22,AK$24:AK$26)","v":82040},")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5530,{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(I$24:I$26=\"(\",-J$24:J$26,J$24:J$26))))","v":163920},{"$f":"IF(I23=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN23,M$24:M$26)","v":92595},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(O$24:O$26=\"(\",-P$24:P$26,P$24:P$26))))","v":0},{"$f":"IF(O23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(R$24:R$26=\"(\",-S$24:S$26,S$24:S$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(R$24:R$26=\"(\",-S$24:S$26,S$24:S$26))))","v":0},{"$f":"IF(R23=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN23,V$24:V$26)","v":0},")","(",{"$f":"SUMIF($AN$24:$AN$26,$AN23,Y$24:Y$26)","v":0},")",{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(AA$24:AA$26=\"(\",-AB$24:AB$26,AB$24:AB$26))))","v":0},{"$f":"IF(AA23=\"(\",\")\",\"\")","v":""},null,"x",null,{"$f":"IF((SUM(IF($AN$24:$AN$26=\"p\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AN$24:$AN$26=\"p\",IF(AG$24:AG$26=\"(\",-AH$24:AH$26,AH$24:AH$26))))","v":217293},{"$f":"IF(AG23=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AN$24:$AN$26,$AN23,AK$24:AK$26)","v":83393},")",null,"p"]
[null,null,null,null,"1.1.2.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,217293,null,"(",83393,")",null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"x",null,null,213418,null,"(",82040,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,163920,null,"(",92595,")",null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"x",null,null,217293,null,"(",83393,")",null,"p"]
[null,null,null,null,null,"Добавить вид"]
[null,null,null,null,"1.1.3","Итого",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5500,{"$f":"IF((IF(I17=\"(\",-J17,J17)+IF(I22=\"(\",-J22,J22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(I17=\"(\",-J17,J17)+IF(I22=\"(\",-J22,J22))","v":217293},{"$f":"IF(I27=\"(\",\")\",\"\")","v":""},"(",{"$f":"M17+M22","v":83393},")",{"$f":"IF((IF(O17=\"(\",-P17,P17)+IF(O22=\"(\",-P22,P22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(O17=\"(\",-P17,P17)+IF(O22=\"(\",-P22,P22))","v":0},{"$f":"IF(O27=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(R17=\"(\",-S17,S17)+IF(R22=\"(\",-S22,S22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(R17=\"(\",-S17,S17)+IF(R22=\"(\",-S22,S22))","v":0},{"$f":"IF(R27=\"(\",\")\",\"\")","v":""},"(",{"$f":"V17+V22","v":0},")","(",{"$f":"Y17+Y22","v":0},")",{"$f":"IF((IF(AA17=\"(\",-AB17,AB17)+IF(AA22=\"(\",-AB22,AB22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AA17=\"(\",-AB17,AB17)+IF(AA22=\"(\",-AB22,AB22))","v":0},{"$f":"IF(AA27=\"(\",\")\",\"\")","v":""},null,"x",null,{"$f":"IF((IF(AG17=\"(\",-AH17,AH17)+IF(AG22=\"(\",-AH22,AH22))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AG17=\"(\",-AH17,AH17)+IF(AG22=\"(\",-AH22,AH22))","v":213418},{"$f":"IF(AG27=\"(\",\")\",\"\")","v":""},"(",{"$f":"AK17+AK22","v":82040},")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5520,{"$f":"IF((IF(I18=\"(\",-J18,J18)+IF(I23=\"(\",-J23,J23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(I18=\"(\",-J18,J18)+IF(I23=\"(\",-J23,J23))","v":163920},{"$f":"IF(I28=\"(\",\")\",\"\")","v":""},"(",{"$f":"M18+M23","v":92595},")",{"$f":"IF((IF(O18=\"(\",-P18,P18)+IF(O23=\"(\",-P23,P23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(O18=\"(\",-P18,P18)+IF(O23=\"(\",-P23,P23))","v":0},{"$f":"IF(O28=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(R18=\"(\",-S18,S18)+IF(R23=\"(\",-S23,S23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(R18=\"(\",-S18,S18)+IF(R23=\"(\",-S23,S23))","v":0},{"$f":"IF(R28=\"(\",\")\",\"\")","v":""},"(",{"$f":"V18+V23","v":0},")","(",{"$f":"Y18+Y23","v":0},")",{"$f":"IF((IF(AA18=\"(\",-AB18,AB18)+IF(AA23=\"(\",-AB23,AB23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AA18=\"(\",-AB18,AB18)+IF(AA23=\"(\",-AB23,AB23))","v":0},{"$f":"IF(AA28=\"(\",\")\",\"\")","v":""},null,"x",null,{"$f":"IF((IF(AG18=\"(\",-AH18,AH18)+IF(AG23=\"(\",-AH23,AH23))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AG18=\"(\",-AH18,AH18)+IF(AG23=\"(\",-AH23,AH23))","v":217293},{"$f":"IF(AG28=\"(\",\")\",\"\")","v":""},"(",{"$f":"AK18+AK23","v":83393},")",null,"p"]
[]
[null,null,null,null,"*","Данные раскрываются за минусом дебиторской задолженности, поступившей и погашенной (списанной) в одном отчетном периоде."]
[]
[]
[null,null,null,"5.2. Просроченная дебиторская задолженность"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"На \"&IF(report_date = \"\",\"отчётную дату отчётного года\",report_date& \" г.\")","v":"На 31.12.2016 г."},null,null,null,null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"предыдущего года\",god-1& \" г.\")","v":"На 31 декабря 2015 г."},null,null,null,null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"года, предшествующего предыдущему\",god-2& \" г.\")","v":"На 31 декабря 2014 г."}]
[null,null,null,null,null,null,null,null,"учтенная по условиям договора",null,null,"балансовая стоимость",null,null,"учтенная по условиям договора",null,null,"балансовая стоимость",null,null,"учтенная по условиям договора",null,null,"балансовая стоимость"]
[null,null,null,null,1,2,null,3,null,4,null,null,5,null,6,null,null,null,7,null,null,8,null,null,9]
[null,null,null,null,"1.2","Всего, в том числе: ",null,5540,{"$f":"IF((SUMIF(I40:I41,\"\",J40:J41)-SUMIF(I40:I41,\"(\",J40:J41))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I40:I41,\"\",J40:J41)-SUMIF(I40:I41,\"(\",J40:J41))","v":0},{"$f":"IF(I39=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L40:L41,\"\",M40:M41)-SUMIF(L40:L41,\"(\",M40:M41))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L40:L41,\"\",M40:M41)-SUMIF(L40:L41,\"(\",M40:M41))","v":0},{"$f":"IF(L39=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O40:O41,\"\",P40:P41)-SUMIF(O40:O41,\"(\",P40:P41))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O40:O41,\"\",P40:P41)-SUMIF(O40:O41,\"(\",P40:P41))","v":0},{"$f":"IF(O39=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(R40:R41,\"\",S40:S41)-SUMIF(R40:R41,\"(\",S40:S41))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(R40:R41,\"\",S40:S41)-SUMIF(R40:R41,\"(\",S40:S41))","v":0},{"$f":"IF(R39=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(U40:U41,\"\",V40:V41)-SUMIF(U40:U41,\"(\",V40:V41))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(U40:U41,\"\",V40:V41)-SUMIF(U40:U41,\"(\",V40:V41))","v":0},{"$f":"IF(U39=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(X40:X41,\"\",Y40:Y41)-SUMIF(X40:X41,\"(\",Y40:Y41))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(X40:X41,\"\",Y40:Y41)-SUMIF(X40:X41,\"(\",Y40:Y41))","v":0},{"$f":"IF(X39=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"1.2.1"]
[null,null,null,null,null,"Добавить вид"]
[]
[]
[null,null,null,"5.3. Наличие и движение кредиторской задолженности"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","Остаток на начало года",null,null,"Изменения за период",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Остаток на конец периода"]
[null,null,null,null,null,null,null,null,null,null,null,"поступление",null,null,null,null,null,"выбыло",null,null,null,null,null,"перевод из долго- в краткосрочную задолженность"]
[null,null,null,null,null,null,null,null,null,null,null,"в результате хозяйственных операций (сумма долга по сделке, операции) **",null,null,"причитающиеся проценты, штрафы и иные начисления **",null,null,"погашение",null,null,"списание на финансовый результат **"]
[null,null,null,null,1,2,3,4,null,5,null,null,6,null,null,7,null,8,null,null,null,9,null,null,10,null,null,11]
[null,null,null,null,"1.3.1","Долгосрочная кредиторская задолженность - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5551,{"$f":"IF((SUM(IF($AE$53:$AE$55=\"c\",IF(I$53:I$55=\"(\",-J$53:J$55,J$53:J$55))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$53:$AE$55=\"c\",IF(I$53:I$55=\"(\",-J$53:J$55,J$53:J$55))))","v":0},{"$f":"IF(I51=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AE$53:$AE$55=\"c\",IF(L$53:L$55=\"(\",-M$53:M$55,M$53:M$55))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$53:$AE$55=\"c\",IF(L$53:L$55=\"(\",-M$53:M$55,M$53:M$55))))","v":0},{"$f":"IF(L51=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AE$53:$AE$55=\"c\",IF(O$53:O$55=\"(\",-P$53:P$55,P$53:P$55))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$53:$AE$55=\"c\",IF(O$53:O$55=\"(\",-P$53:P$55,P$53:P$55))))","v":0},{"$f":"IF(O51=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AE$53:$AE$55,$AE51,S$53:S$55)","v":0},")","(",{"$f":"SUMIF($AE$53:$AE$55,$AE51,V$53:V$55)","v":0},")","(",{"$f":"SUMIF($AE$53:$AE$55,$AE51,Y$53:Y$55)","v":0},")",{"$f":"IF((SUM(IF($AE$53:$AE$55=\"c\",IF(AA$53:AA$55=\"(\",-AB$53:AB$55,AB$53:AB$55))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$53:$AE$55=\"c\",IF(AA$53:AA$55=\"(\",-AB$53:AB$55,AB$53:AB$55))))","v":0},{"$f":"IF(AA51=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5571,{"$f":"IF((SUM(IF($AE$53:$AE$55=\"p\",IF(I$53:I$55=\"(\",-J$53:J$55,J$53:J$55))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$53:$AE$55=\"p\",IF(I$53:I$55=\"(\",-J$53:J$55,J$53:J$55))))","v":0},{"$f":"IF(I52=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AE$53:$AE$55=\"p\",IF(L$53:L$55=\"(\",-M$53:M$55,M$53:M$55))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$53:$AE$55=\"p\",IF(L$53:L$55=\"(\",-M$53:M$55,M$53:M$55))))","v":0},{"$f":"IF(L52=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AE$53:$AE$55=\"p\",IF(O$53:O$55=\"(\",-P$53:P$55,P$53:P$55))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$53:$AE$55=\"p\",IF(O$53:O$55=\"(\",-P$53:P$55,P$53:P$55))))","v":0},{"$f":"IF(O52=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AE$53:$AE$55,$AE52,S$53:S$55)","v":0},")","(",{"$f":"SUMIF($AE$53:$AE$55,$AE52,V$53:V$55)","v":0},")","(",{"$f":"SUMIF($AE$53:$AE$55,$AE52,Y$53:Y$55)","v":0},")",{"$f":"IF((SUM(IF($AE$53:$AE$55=\"p\",IF(AA$53:AA$55=\"(\",-AB$53:AB$55,AB$53:AB$55))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$53:$AE$55=\"p\",IF(AA$53:AA$55=\"(\",-AB$53:AB$55,AB$53:AB$55))))","v":0},{"$f":"IF(AA52=\"(\",\")\",\"\")","v":""},null,"p"]
[null,null,null,null,"1.3.1.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,null,null,null,null,null,null,null,null,"(",null,")","(",null,")","(",null,")",null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,null,null,null,null,null,null,null,null,"(",null,")","(",null,")","(",null,")",null,null,null,null,"p"]
[null,null,null,null,null,"Добавить вид"]
[null,null,null,null,"1.3.2","Краткосрочная кредиторская задолженность - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5560,{"$f":"IF((SUM(IF($AE$58:$AE$60=\"c\",IF(I$58:I$60=\"(\",-J$58:J$60,J$58:J$60))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$58:$AE$60=\"c\",IF(I$58:I$60=\"(\",-J$58:J$60,J$58:J$60))))","v":672434},{"$f":"IF(I56=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AE$58:$AE$60=\"c\",IF(L$58:L$60=\"(\",-M$58:M$60,M$58:M$60))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$58:$AE$60=\"c\",IF(L$58:L$60=\"(\",-M$58:M$60,M$58:M$60))))","v":0},{"$f":"IF(L56=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AE$58:$AE$60=\"c\",IF(O$58:O$60=\"(\",-P$58:P$60,P$58:P$60))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$58:$AE$60=\"c\",IF(O$58:O$60=\"(\",-P$58:P$60,P$58:P$60))))","v":0},{"$f":"IF(O56=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AE$58:$AE$60,$AE56,S$58:S$60)","v":0},")","(",{"$f":"SUMIF($AE$58:$AE$60,$AE56,V$58:V$60)","v":0},")",null,"x",null,{"$f":"IF((SUM(IF($AE$58:$AE$60=\"c\",IF(AA$58:AA$60=\"(\",-AB$58:AB$60,AB$58:AB$60))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$58:$AE$60=\"c\",IF(AA$58:AA$60=\"(\",-AB$58:AB$60,AB$58:AB$60))))","v":626008},{"$f":"IF(AA56=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5580,{"$f":"IF((SUM(IF($AE$58:$AE$60=\"p\",IF(I$58:I$60=\"(\",-J$58:J$60,J$58:J$60))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$58:$AE$60=\"p\",IF(I$58:I$60=\"(\",-J$58:J$60,J$58:J$60))))","v":554548},{"$f":"IF(I57=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AE$58:$AE$60=\"p\",IF(L$58:L$60=\"(\",-M$58:M$60,M$58:M$60))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$58:$AE$60=\"p\",IF(L$58:L$60=\"(\",-M$58:M$60,M$58:M$60))))","v":0},{"$f":"IF(L57=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($AE$58:$AE$60=\"p\",IF(O$58:O$60=\"(\",-P$58:P$60,P$58:P$60))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$58:$AE$60=\"p\",IF(O$58:O$60=\"(\",-P$58:P$60,P$58:P$60))))","v":0},{"$f":"IF(O57=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($AE$58:$AE$60,$AE57,S$58:S$60)","v":0},")","(",{"$f":"SUMIF($AE$58:$AE$60,$AE57,V$58:V$60)","v":0},")",null,"x",null,{"$f":"IF((SUM(IF($AE$58:$AE$60=\"p\",IF(AA$58:AA$60=\"(\",-AB$58:AB$60,AB$58:AB$60))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($AE$58:$AE$60=\"p\",IF(AA$58:AA$60=\"(\",-AB$58:AB$60,AB$58:AB$60))))","v":672434},{"$f":"IF(AA57=\"(\",\")\",\"\")","v":""},null,"p"]
[null,null,null,null,"1.3.2.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,672434,null,null,null,null,null,null,null,"(",null,")","(",null,")",null,"x",null,null,626008,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,554548,null,null,null,null,null,null,null,"(",null,")","(",null,")",null,"x",null,null,672434,null,null,"p"]
[null,null,null,null,null,"Добавить вид"]
[null,null,null,null,"1.3.3","Итого",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5550,{"$f":"IF((IF(I51=\"(\",-J51,J51)+IF(I56=\"(\",-J56,J56))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(I51=\"(\",-J51,J51)+IF(I56=\"(\",-J56,J56))","v":672434},{"$f":"IF(I61=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(L51=\"(\",-M51,M51)+IF(L56=\"(\",-M56,M56))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(L51=\"(\",-M51,M51)+IF(L56=\"(\",-M56,M56))","v":0},{"$f":"IF(L61=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(O51=\"(\",-P51,P51)+IF(O56=\"(\",-P56,P56))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(O51=\"(\",-P51,P51)+IF(O56=\"(\",-P56,P56))","v":0},{"$f":"IF(O61=\"(\",\")\",\"\")","v":""},"(",{"$f":"S51+S56","v":0},")","(",{"$f":"V51+V56","v":0},")",null,"x",null,{"$f":"IF((IF(AA51=\"(\",-AB51,AB51)+IF(AA56=\"(\",-AB56,AB56))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AA51=\"(\",-AB51,AB51)+IF(AA56=\"(\",-AB56,AB56))","v":626008},{"$f":"IF(AA61=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5570,{"$f":"IF((IF(I52=\"(\",-J52,J52)+IF(I57=\"(\",-J57,J57))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(I52=\"(\",-J52,J52)+IF(I57=\"(\",-J57,J57))","v":554548},{"$f":"IF(I62=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(L52=\"(\",-M52,M52)+IF(L57=\"(\",-M57,M57))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(L52=\"(\",-M52,M52)+IF(L57=\"(\",-M57,M57))","v":0},{"$f":"IF(L62=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(O52=\"(\",-P52,P52)+IF(O57=\"(\",-P57,P57))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(O52=\"(\",-P52,P52)+IF(O57=\"(\",-P57,P57))","v":0},{"$f":"IF(O62=\"(\",\")\",\"\")","v":""},"(",{"$f":"S52+S57","v":0},")","(",{"$f":"V52+V57","v":0},")",null,"x",null,{"$f":"IF((IF(AA52=\"(\",-AB52,AB52)+IF(AA57=\"(\",-AB57,AB57))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(AA52=\"(\",-AB52,AB52)+IF(AA57=\"(\",-AB57,AB57))","v":672434},{"$f":"IF(AA62=\"(\",\")\",\"\")","v":""},null,"p"]
[]
[null,null,null,null,"*","Данные раскрываются за минусом кредиторской задолженности, поступившей и погашенной (списанной) в одном отчетном периоде."]
[]
[]
[null,null,null,"5.4. Просроченная кредиторская задолженность"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"На \"&IF(report_date = \"\",\"отчётную дату отчётного года\",report_date& \" г.\")","v":"На 31.12.2016 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"предыдущего года\",god-1& \" г.\")","v":"На 31 декабря 2015 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"года, предшествующего предыдущему\",god-2& \" г.\")","v":"На 31 декабря 2014 г."}]
[null,null,null,null,1,2,null,3,null,4,null,5,null,null,null,6]
[null,null,null,null,"1.4","Всего, в том числе: ",null,5590,{"$f":"IF((SUMIF(I73:I74,\"\",J73:J74)-SUMIF(I73:I74,\"(\",J73:J74))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I73:I74,\"\",J73:J74)-SUMIF(I73:I74,\"(\",J73:J74))","v":0},{"$f":"IF(I72=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L73:L74,\"\",M73:M74)-SUMIF(L73:L74,\"(\",M73:M74))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L73:L74,\"\",M73:M74)-SUMIF(L73:L74,\"(\",M73:M74))","v":0},{"$f":"IF(L72=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O73:O74,\"\",P73:P74)-SUMIF(O73:O74,\"(\",P73:P74))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O73:O74,\"\",P73:P74)-SUMIF(O73:O74,\"(\",P73:P74))","v":0},{"$f":"IF(O72=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"1.4.1"]
[null,null,null,null,null,"Добавить вид"]
[]
[]
[null,null,null,"6. Затраты на производство"]
[]
[]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"За \"&IF(god = \"\",\"отчётный год\",god& \" г.\")","v":"За 2016 г."},null,null,{"$f":"\"За \"&IF(god = \"\",\"предыдущий год\",god-1& \" г.\")","v":"За 2015 г."}]
[null,null,null,null,1,2,null,3,null,4,null,5]
[null,null,null,null,"2.1","Материальные затраты",null,5610]
[null,null,null,null,"2.2","Расходы на оплату труда",null,5620]
[null,null,null,null,"2.3","Отчисления на социальные нужды",null,5630]
[null,null,null,null,"2.4","Амортизация",null,5640]
[null,null,null,null,"2.5","Прочие затраты",null,5650]
[null,null,null,null,"2.6","Итого по элементам затрат",null,5660,{"$f":"IF((SUMIF(I82:I86,\"\",J82:J86)-SUMIF(I82:I86,\"(\",J82:J86))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I82:I86,\"\",J82:J86)-SUMIF(I82:I86,\"(\",J82:J86))","v":0},{"$f":"IF(I87=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L82:L86,\"\",M82:M86)-SUMIF(L82:L86,\"(\",M82:M86))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L82:L86,\"\",M82:M86)-SUMIF(L82:L86,\"(\",M82:M86))","v":0},{"$f":"IF(L87=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,"2.7","Изменение остатков (прирост, уменьшение):"]
[null,null,null,null,"2.7.1","незавершенного производства",null,"5670/5680"]
[null,null,null,null,"2.7.2","готовой продукции",null,"5670/5680"]
[null,null,null,null,null,"Добавить вид"]
[null,null,null,null,"2.8","Итого расходы по обычным видам деятельности",null,5600,{"$f":"IF((IF(I87=\"(\",-J87,J87)+SUMIF(I89:I91,\"\",J89:J91)-SUMIF(I89:I91,\"(\",J89:J91))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(I87=\"(\",-J87,J87)+SUMIF(I89:I91,\"\",J89:J91)-SUMIF(I89:I91,\"(\",J89:J91))","v":0},{"$f":"IF(I92=\"(\",\")\",\"\")","v":""},{"$f":"IF((IF(L87=\"(\",-M87,M87)+SUMIF(L89:L91,\"\",M89:M91)-SUMIF(L89:L91,\"(\",M89:M91))<0,\"(\",\"\")","v":""},{"$f":"ABS(IF(L87=\"(\",-M87,M87)+SUMIF(L89:L91,\"\",M89:M91)-SUMIF(L89:L91,\"(\",M89:M91))","v":0},{"$f":"IF(L92=\"(\",\")\",\"\")","v":""}]

{"sheet":"Стр 13","index":8,"n_rows":28,"n_cols":25,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,4,7,23],[10,8,10,10],[10,11,10,13],[10,14,10,16],[10,17,10,19],[10,20,10,22],[21,11,21,13],[11,14,11,16],[11,20,11,22],[17,4,17,17],[20,8,20,10],[20,11,20,13],[20,14,20,16]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Форма 0710005 с. 13"]
[null,null,null,null,"7. Оценочные обязательства"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,null,"№ п/п","Наименование показателя","Код строки",{"$f":"\"Остаток на начало\"&IF(god=\"\",\"\",\" \"&god)&\" года\"","v":"Остаток на начало 2016 года"},null,null,"Признано",null,null,"Погашено",null,null,"Списано как избыточная сумма",null,null,{"$f":"\"Остаток на конец\"&IF(god=\"\",\" периода\",\" \"&god&\" года\")","v":"Остаток на конец 2016 года"}]
[null,null,null,null,null,1,2,3,null,4,null,null,5,null,6,null,null,null,7,null,8]
[null,null,null,null,null,"1","Оценочные обязательства - всего, в том числе: ",5700,{"$f":"IF((SUMIF(I14:I15,\"\",J14:J15)-SUMIF(I14:I15,\"(\",J14:J15))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I14:I15,\"\",J14:J15)-SUMIF(I14:I15,\"(\",J14:J15))","v":0},{"$f":"IF(I13=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L14:L15,\"\",M14:M15)-SUMIF(L14:L15,\"(\",M14:M15))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L14:L15,\"\",M14:M15)-SUMIF(L14:L15,\"(\",M14:M15))","v":0},{"$f":"IF(L13=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUM(P14:P15)","v":0},")","(",{"$f":"SUM(S14:S15)","v":0},")",{"$f":"IF((SUMIF(U14:U15,\"\",V14:V15)-SUMIF(U14:U15,\"(\",V14:V15))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(U14:U15,\"\",V14:V15)-SUMIF(U14:U15,\"(\",V14:V15))","v":0},{"$f":"IF(U13=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,"1.1",null,null,null,0,null,null,0,null,"(",0,")","(",0,")",null,0,null,null,"c"]
[null,null,null,null,null,null,"Добавить вид обязательства"]
[]
[]
[null,null,null,null,"8. Обеспечения обязательств"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,null,"№ п/п","Наименование показателя","Код строки",{"$f":"\"На \"&IF(report_date = \"\",\"отчётную дату отчётного года\",report_date& \" г.\")","v":"На 31.12.2016 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"предыдущего года\",god-1& \" г.\")","v":"На 31 декабря 2015 г."},null,null,{"$f":"\"На 31 декабря \"&IF(god = \"\",\"года, предшествующего предыдущему\",god-2& \" г.\")","v":"На 31 декабря 2014 г."}]
[null,null,null,null,null,1,2,3,null,4,null,5,null,null,null,6]
[null,null,null,null,null,"2.1","Полученные - всего, в том числе: ",5800,{"$f":"IF((SUMIF(I24:I25,\"\",J24:J25)-SUMIF(I24:I25,\"(\",J24:J25))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I24:I25,\"\",J24:J25)-SUMIF(I24:I25,\"(\",J24:J25))","v":0},{"$f":"IF(I23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L24:L25,\"\",M24:M25)-SUMIF(L24:L25,\"(\",M24:M25))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L24:L25,\"\",M24:M25)-SUMIF(L24:L25,\"(\",M24:M25))","v":0},{"$f":"IF(L23=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O24:O25,\"\",P24:P25)-SUMIF(O24:O25,\"(\",P24:P25))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O24:O25,\"\",P24:P25)-SUMIF(O24:O25,\"(\",P24:P25))","v":0},{"$f":"IF(O23=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,null,"2.1.1"]
[null,null,null,null,null,null,"Добавить вид"]
[null,null,null,null,null,"2.2","Выданные - всего, в том числе: ",5810,{"$f":"IF((SUMIF(I27:I28,\"\",J27:J28)-SUMIF(I27:I28,\"(\",J27:J28))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I27:I28,\"\",J27:J28)-SUMIF(I27:I28,\"(\",J27:J28))","v":0},{"$f":"IF(I26=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L27:L28,\"\",M27:M28)-SUMIF(L27:L28,\"(\",M27:M28))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L27:L28,\"\",M27:M28)-SUMIF(L27:L28,\"(\",M27:M28))","v":134150},{"$f":"IF(L26=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(O27:O28,\"\",P27:P28)-SUMIF(O27:O28,\"(\",P27:P28))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(O27:O28,\"\",P27:P28)-SUMIF(O27:O28,\"(\",P27:P28))","v":134150},{"$f":"IF(O26=\"(\",\")\",\"\")","v":""}]
[null,null,null,null,null,"2.2.1","договор залога",null,null,0,null,null,134150,null,null,134150]
[null,null,null,null,null,null,"Добавить вид"]

{"sheet":"Стр 14","index":9,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[7,3,7,20],[10,5,10,6],[10,8,10,10],[10,11,10,13],[15,14,15,16],[15,17,15,19],[16,8,16,10],[16,11,16,13],[16,14,16,16],[16,17,16,19],[20,4,21,4],[20,5,21,5],[17,14,17,16],[17,17,17,19],[18,4,19,4],[18,5,19,5]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Форма 0710005 с. 14"]
[null,null,null,"9. Государственная помощь"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(unit=\"\",\"\",unit)","v":"тыс.руб."}]
[null,null,null,null,"№ п/п","Наименование показателя",null,"Код строки",{"$f":"\"За \"&IF(god = \"\",\"отчётный год\",god& \" г.\")","v":"За 2016 г."},null,null,{"$f":"\"За \"&IF(god = \"\",\"предыдущий год\",god-1& \" г.\")","v":"За 2015 г."}]
[null,null,null,null,1,2,null,3,null,4,null,null,5]
[null,null,null,null,"1.1","Получено бюджетных средств - всего, в том числе: ",null,5900,{"$f":"IF((SUMIF(I14:I15,\"\",J14:J15)-SUMIF(I14:I15,\"(\",J14:J15))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(I14:I15,\"\",J14:J15)-SUMIF(I14:I15,\"(\",J14:J15))","v":0},{"$f":"IF(I13=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUMIF(L14:L15,\"\",M14:M15)-SUMIF(L14:L15,\"(\",M14:M15))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUMIF(L14:L15,\"\",M14:M15)-SUMIF(L14:L15,\"(\",M14:M15))","v":0},{"$f":"IF(L13=\"(\",\")\",\"\")","v":""},null,null,null,null,null,null,null,"c"]
[null,null,null,null,"1.1.1","на текущие расходы",null,5901,null,0,null,null,0,null,null,null,null,null,null,null,null,"c"]
[null,null,null,null,"1.1.2","на вложения во внеоборотные активы",null,5905,null,0,null,null,0,null,null,null,null,null,null,null,null,"c"]
[]
[null,null,null,null,"№ п/п","Наименование показателя","Период","Код строки","На начало года",null,null,"Получено за год",null,null,"Возвращено за год",null,null,"На конец года"]
[null,null,null,null,1,2,3,4,null,5,null,null,6,null,7,null,null,8]
[null,null,null,null,"1.2","Бюджетные кредиты - всего, в том числе: ",{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},5910,{"$f":"IF((SUM(IF($V$21:$V$23=\"c\",IF(I$21:I$23=\"(\",-J$21:J$23,J$21:J$23))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($V$21:$V$23=\"c\",IF(I$21:I$23=\"(\",-J$21:J$23,J$21:J$23))))","v":0},{"$f":"IF(I19=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($V$21:$V$23=\"c\",IF(L$21:L$23=\"(\",-M$21:M$23,M$21:M$23))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($V$21:$V$23=\"c\",IF(L$21:L$23=\"(\",-M$21:M$23,M$21:M$23))))","v":0},{"$f":"IF(L19=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($V$21:$V$23,$V19,P$21:P$23)","v":0},")",{"$f":"IF((SUM(IF($V$21:$V$23=\"c\",IF(R$21:R$23=\"(\",-S$21:S$23,S$21:S$23))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($V$21:$V$23=\"c\",IF(R$21:R$23=\"(\",-S$21:S$23,S$21:S$23))))","v":0},{"$f":"IF(R19=\"(\",\")\",\"\")","v":""},null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},5920,{"$f":"IF((SUM(IF($V$21:$V$23=\"p\",IF(I$21:I$23=\"(\",-J$21:J$23,J$21:J$23))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($V$21:$V$23=\"p\",IF(I$21:I$23=\"(\",-J$21:J$23,J$21:J$23))))","v":0},{"$f":"IF(I20=\"(\",\")\",\"\")","v":""},{"$f":"IF((SUM(IF($V$21:$V$23=\"p\",IF(L$21:L$23=\"(\",-M$21:M$23,M$21:M$23))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($V$21:$V$23=\"p\",IF(L$21:L$23=\"(\",-M$21:M$23,M$21:M$23))))","v":0},{"$f":"IF(L20=\"(\",\")\",\"\")","v":""},"(",{"$f":"SUMIF($V$21:$V$23,$V20,P$21:P$23)","v":0},")",{"$f":"IF((SUM(IF($V$21:$V$23=\"p\",IF(R$21:R$23=\"(\",-S$21:S$23,S$21:S$23))))<0,\"(\",\"\")","v":""},{"$f":"ABS(SUM(IF($V$21:$V$23=\"p\",IF(R$21:R$23=\"(\",-S$21:S$23,S$21:S$23))))","v":0},{"$f":"IF(R20=\"(\",\")\",\"\")","v":""},null,"p"]
[null,null,null,null,"1.2.1",null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\" год\")","v":"за 2016 год"},null,null,0,null,null,0,null,"(",0,")",null,0,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\" год\")","v":"за 2015 год"},null,null,0,null,null,0,null,"(",0,")",null,0,null,null,"p"]
[null,null,null,null,null,"Добавить цель"]

{"sheet":"Комментарии","index":10,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,3,7,5]]}
[]
["Амурская область"]
[]
[]
[]
[]
[]
[null,null,null,"КОММЕНТАРИИ"]

{"sheet":"Проверка","index":11,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,4,9,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Результат проверки"]
[]
[null,null,null,null,"Ссылка","Причина","Статус ошибки"]
[null,null,null,null,"1","2","3"]

{"sheet":"AllSheetsInThisWorkbook","index":12,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Расчетные листы","Скрытые листы"]
["Инструкция","AllSheetsInThisWorkbook"]
["Титульный","et_union"]
["Стр 1-3","TEHSHEET"]
["Стр 4-6","REESTR_ORG"]
["Стр 7-9","REESTR_FILTERED"]
["Стр 10-12","REESTR_MO"]
["Стр 13","modHyperlink"]
["Стр 14","modChange"]
["Комментарии","modPROV"]
["Проверка","modTitleSheetHeaders"]
[null,"modServiceModule"]
[null,"modCommandButton"]
[null,"modReestr"]
[null,"modClassifierValidate"]
[null,"modInfo"]
[null,"modfrmReestr"]
[null,"modfrmDateChoose"]
[null,"modDblClick"]
[null,"Паспорт"]
[null,"modUpdTemplMain"]
[null,"modRegionSelectSub"]
[null,"modThisWorkbook"]
[null,"modReestrMO"]
[null,"modSheetMain01"]
[null,"modSheetMain02"]
[null,"modSheetMain03"]
[null,"modSheetMain04"]
[null,"modSheetMain05"]
[null,"modSheetMain06"]
[null,"modSheetMain07"]
[null,"modSheetMain08"]
[null,"modSheetMain09"]

{"sheet":"et_union","index":13,"n_rows":105,"n_cols":43,"rows_kept":105,"cut":false,"hidden":true,"merged":[[41,5,41,6],[46,4,47,4],[80,4,81,4],[80,5,81,5],[23,5,24,5],[28,4,29,4],[28,5,29,5],[33,5,33,6],[37,5,37,6],[23,4,24,4],[46,5,47,5],[51,5,51,6],[55,4,56,4],[55,5,56,5],[66,5,67,5],[71,5,71,6],[103,4,104,4],[103,5,104,5],[61,4,62,4],[61,5,62,5],[66,4,67,4],[85,5,85,6],[89,5,89,6],[75,4,76,4],[75,5,76,5],[17,4,18,4],[17,5,18,5],[3,4,4,4],[3,5,4,5],[8,5,8,6],[12,4,13,4],[12,5,13,5]]}
[]
["add_STR_1_range_1"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,"(",null,")",null,"p"]
[]
["add_STR_1_range_2"]
[]
[]
[]
["add_STR_1_range_3"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,"p"]
[]
["add_STR_1_range_4"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"p"]
[]
[]
["add_STR_2_range_1"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,"(",null,")",null,"p"]
[]
["add_STR_2_range_2"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"p"]
[]
["add_STR_2_range_3"]
[]
[]
[]
["add_STR_2_range_4"]
[]
[null,null,null,null,null,null,null,null,"(",null,")","(",null,")"]
[]
["add_STR_2_range_5"]
[]
[]
[]
[]
["add_STR_3_range_1"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,null,null,null,null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,null,null,null,null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p"]
[]
["add_STR_3_range_2"]
[]
[]
[]
["add_STR_3_range_3"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,"(",null,")",null,null,null,"(",null,")",null,null,null,null,null,null,null,null,null,null,null,null,"(",null,")",null,"p"]
[]
[]
["add_STR_4_range_1"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,"(",null,")",null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,"(",null,")",null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,"(",null,")",null,null,null,"(",null,")",null,"p"]
[]
["add_STR_4_range_2"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,"(",null,")",null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"x",null,null,null,null,"(",null,")",null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,"(",null,")",null,null,null,null,null,null,"(",null,")","(",null,")",null,null,null,null,"x",null,null,null,null,"(",null,")",null,"p"]
[]
["add_STR_4_range_3"]
[]
[]
[]
["add_STR_4_range_4"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,null,null,null,null,null,null,"(",null,")","(",null,")","(",null,")",null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,null,null,null,null,null,null,"(",null,")","(",null,")","(",null,")",null,null,null,null,"p"]
[]
["add_STR_4_range_5"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,null,null,null,null,null,null,"(",null,")","(",null,")",null,"x",null,null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,null,null,null,null,null,null,"(",null,")","(",null,")",null,"x",null,null,null,null,null,"p"]
[]
["add_STR_4_range_6"]
[]
[]
[]
["add_STR_4_range_7"]
[]
[]
[]
[]
["add_STR_5_range_1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(",null,")","(",null,")"]
[]
["add_STR_5_range_2"]
[]
[]
[]
[]
["add_STR_6_range_1"]
[]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"отчётный год\",god&\"год\")","v":"за 2016год"},null,null,null,null,null,null,null,"(",null,")",null,null,null,null,"c"]
[null,null,null,null,null,null,{"$f":"\"за \"&IF(god=\"\",\"предыдущий год\",god-1&\"год\")","v":"за 2015год"},null,null,null,null,null,null,null,"(",null,")",null,null,null,null,"p"]

{"sheet":"TEHSHEET","index":14,"n_rows":86,"n_cols":10,"rows_kept":86,"cut":false,"hidden":true,"merged":[[0,0,1,0]]}
["регион","Логика","Кварталы","Года","Единица измерения","Месяц-текст","Месяц-число","День-число",null,"XML_ORG_LIST_TAG_NAMES"]
[null,"да","I квартал",2011,"тыс.руб.","январь","01","01",null,"NSRF"]
["Алтайский край","нет","I полугодие",2012,"млн.руб.","февраль","02","02",null,"MR_NAME"]
["Амурская область",null,"9 месяцев",2013,null,"март","03","03",null,"OKTMO_MR_NAME"]
["Архангельская область",null,"год",2014,"Единица измерения для листа \"Доходы-Расходы\"","апрель","04","04",null,"MO_NAME"]
["Астраханская область","Выбранный регион",null,2015,"руб.","май","05","05",null,"OKTMO_NAME"]
["Белгородская область",0,null,null,"тыс.руб.","июнь","06","06",null,"ORG_NAME"]
["Брянская область",null,null,null,"млн.руб.","июль","07","07",null,"INN_NAME"]
["Владимирская область",null,null,null,null,"август","08","08",null,"KPP_NAME"]
["Волгоградская область",null,null,null,null,"сентябрь","09","09"]
["Вологодская область",null,null,null,null,"октябрь",10,10,null,"XML_MR_MO_OKTMO_LIST_TAG_NAMES"]
["Воронежская область",null,null,null,null,"ноябрь",11,11,null,"NSRF"]
["г.Байконур",null,null,null,null,"декабрь",12,12,null,"MR_NAME"]
["г. Москва",null,null,null,null,null,null,13,null,"OKTMO_MR_NAME"]
["г.Санкт-Петербург",null,null,null,null,null,null,14,null,"MO_NAME"]
["Еврейская автономная область",null,null,null,null,null,null,15,null,"OKTMO_NAME"]
["Забайкальский край",null,null,null,null,null,null,16]
["Ивановская область",null,null,null,null,null,null,17]
["Иркутская область",null,null,null,null,null,null,18]
["Кабардино-Балкарская республика",null,null,null,null,null,null,19]
["Калининградская область",null,null,null,null,null,null,20]
["Калужская область",null,null,null,null,null,null,21]
["Камчатский край",null,null,null,null,null,null,22]
["Карачаево-Черкесская республика",null,null,null,null,null,null,23]
["Кемеровская область",null,null,null,null,null,null,24]
["Кировская область",null,null,null,null,null,null,25]
["Костромская область",null,null,null,null,null,null,26]
["Краснодарский край",null,null,null,null,null,null,27]
["Красноярский край",null,null,null,null,null,null,28]
["Курганская область",null,null,null,null,null,null,29]
["Курская область",null,null,null,null,null,null,30]
["Ленинградская область",null,null,null,null,null,null,31]
["Липецкая область"]
["Магаданская область"]
["Московская область"]
["Мурманская область"]
["Ненецкий автономный округ"]
["Нижегородская область"]
["Новгородская область"]
["Новосибирская область"]
["Омская область"]
["Оренбургская область"]
["Орловская область"]
["Пензенская область"]
["Пермский край"]
["Приморский край"]
["Псковская область"]
["Республика Адыгея"]
["Республика Алтай"]
["Республика Башкортостан"]
["Республика Бурятия"]
["Республика Дагестан"]
["Республика Ингушетия"]
["Республика Калмыкия"]
["Республика Карелия"]
["Республика Коми"]
["Республика Марий Эл"]
["Республика Мордовия"]
["Республика Саха (Якутия)"]
["Республика Северная Осетия-Алания"]
["Республика Татарстан"]
["Республика Тыва"]
["Республика Хакасия"]
["Ростовская область"]
["Рязанская область"]
["Самарская область"]
["Саратовская область"]
["Сахалинская область"]
["Свердловская область"]
["Смоленская область"]
["Ставропольский край"]
["Тамбовская область"]
["Тверская область"]
["Томская область"]
["Тульская область"]
["Тюменская область"]
["Удмуртская республика"]
["Ульяновская область"]
["Хабаровский край"]
["Ханты-Мансийский автономный округ"]
["Челябинская область"]
["Чеченская республика"]
["Чувашская республика"]
["Чукотский автономный округ"]
["Ямало-Ненецкий автономный округ"]
["Ярославская область"]

{"sheet":"REESTR_ORG","index":15,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["№","МР","МО","МО ОКТМО","ОРГАНИЗАЦИЯ","ИНН","КПП","ВИД ДЕЯТЕЛЬНОСТИ"]

{"sheet":"REESTR_FILTERED","index":16,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["№","МР","МО","МО ОКТМО","ОРГАНИЗАЦИЯ","ИНН","КПП","ВИД ДЕЯТЕЛЬНОСТИ"]

{"sheet":"REESTR_MO","index":17,"n_rows":308,"n_cols":5,"rows_kept":308,"cut":false,"hidden":true,"merged":[]}
["МР","МО","МО_ОКТМО","МР","ИМЯ ДИАПАЗОНА"]
["Александро-Невский муниципальный район","Александро-Невский муниципальный район","61620000","Александро-Невский муниципальный район","MO_LIST_2"]
["Александро-Невский муниципальный район","Александро-Невское","61620151","Город Касимов","MO_LIST_3"]
["Александро-Невский муниципальный район","Благовское","61620405","Город Рязань","MO_LIST_4"]
["Александро-Невский муниципальный район","Борисовское","61620410","Город Сасово","MO_LIST_5"]
["Александро-Невский муниципальный район","Бурминское","61620420","Город Скопин","MO_LIST_6"]
["Александро-Невский муниципальный район","Каширинское","61620450","Ермишинский муниципальный район","MO_LIST_7"]
["Александро-Невский муниципальный район","Ленинское","61620435","Захаровский муниципальный район","MO_LIST_8"]
["Александро-Невский муниципальный район","Нижнеякимецкое","61620445","Кадомский муниципальный район","MO_LIST_9"]
["Александро-Невский муниципальный район","Просеченское","61620460","Касимовский муниципальный район","MO_LIST_10"]
["Город Касимов","Город Касимов","61705000","Клепиковский муниципальный район","MO_LIST_11"]
["Город Рязань","Город Рязань","61701000","Кораблинский муниципальный район","MO_LIST_12"]
["Город Сасово","Город Сасово","61710000","Милославский муниципальный район","MO_LIST_13"]
["Город Скопин","Город Скопин","61715000","Михайловский муниципальный район","MO_LIST_14"]
["Ермишинский муниципальный район","Азеевское","61602405","Пителинский муниципальный район","MO_LIST_15"]
["Ермишинский муниципальный район","Ермишинский муниципальный район","61602000","Пронский муниципальный район","MO_LIST_16"]
["Ермишинский муниципальный район","Ермишинское","61602151","Путятинский муниципальный район","MO_LIST_17"]
["Ермишинский муниципальный район","Мердушинское","61602425","Рыбновский муниципальный район","MO_LIST_18"]
["Ермишинский муниципальный район","Надежкинское","61602430","Ряжский муниципальный район","MO_LIST_19"]
["Ермишинский муниципальный район","Нарминское","61602435","Рязанский муниципальный район","MO_LIST_20"]
["Ермишинский муниципальный район","Савватемское","61602440","Сапожковский муниципальный район","MO_LIST_21"]
["Захаровский муниципальный район","Безлыченское","61604412","Сараевский муниципальный район","MO_LIST_22"]
["Захаровский муниципальный район","Большекоровинское","61604415","Сасовский муниципальный район","MO_LIST_23"]
["Захаровский муниципальный район","Добро-Пчельское","61604430","Скопинский муниципальный район","MO_LIST_24"]
["Захаровский муниципальный район","Елинское","61604432","Спасский муниципальный район","MO_LIST_25"]
["Захаровский муниципальный район","Захаровский муниципальный район","61604000","Старожиловский муниципальный район","MO_LIST_26"]
["Захаровский муниципальный район","Захаровское","61604440","Ухоловский муниципальный район","MO_LIST_27"]
["Захаровский муниципальный район","Плахинское","61604465","Чучковский муниципальный район","MO_LIST_28"]
["Захаровский муниципальный район","Сменовское","61604425","Шацкий муниципальный район","MO_LIST_29"]
["Кадомский муниципальный район","Восходское","61606405","Шиловский муниципальный район","MO_LIST_30"]
["Кадомский муниципальный район","Енкаевское","61606410"]
["Кадомский муниципальный район","Кадомский муниципальный район","61606000"]
["Кадомский муниципальный район","Кадомское","61606151"]
["Кадомский муниципальный район","Котелинское","61606420"]
["Кадомский муниципальный район","Кущапинское","61606430"]
["Касимовский муниципальный район","Ардабьевское","61608403"]
["Касимовский муниципальный район","Ахматовское","61608406"]
["Касимовский муниципальный район","Балушево-Починковское","61608409"]
["Касимовский муниципальный район","Булгаковское","61608439"]
["Касимовский муниципальный район","Гиблицкое","61608418"]
["Касимовский муниципальный район","Гусевское","61608154"]
["Касимовский муниципальный район","Дмитриевское","61608421"]
["Касимовский муниципальный район","Елатомское","61608156"]
["Касимовский муниципальный район","Ермоловское","61608424"]
["Касимовский муниципальный район","Ибердусское","61608430"]
["Касимовский муниципальный район","Касимовский муниципальный район","61608000"]
["Касимовский муниципальный район","Китовское","61608433"]
["Касимовский муниципальный район","Клетинское","61608434"]
["Касимовский муниципальный район","Которовское","61608442"]
["Касимовский муниципальный район","Крутоярское","61608453"]
["Касимовский муниципальный район","Лашманское","61608454"]
["Касимовский муниципальный район","Лощининское","61608471"]
["Касимовский муниципальный район","Новодеревенское","61608456"]
["Касимовский муниципальный район","Овчинниковское","61608459"]
["Касимовский муниципальный район","Первинское","61608462"]
["Касимовский муниципальный район","Погостинское","61608465"]
["Касимовский муниципальный район","Савостьяновское","61608468"]
["Касимовский муниципальный район","Сынтульское","61608160"]
["Касимовский муниципальный район","Токаревское","61608474"]
["Касимовский муниципальный район","Торбаевское","61608412"]
["Касимовский муниципальный район","Шостьинское","61608480"]
["Клепиковский муниципальный район","Алексеевское","61610403"]
["Клепиковский муниципальный район","Болоньское","61610415"]
["Клепиковский муниципальный район","Бусаевское","61610418"]
["Клепиковский муниципальный район","Екшурское","61610451"]
["Клепиковский муниципальный район","Клепиковский муниципальный район","61610000"]
["Клепиковский муниципальный район","Колесниковское","61610448"]
["Клепиковский муниципальный район","Криушинское","61610454"]
["Клепиковский муниципальный район","Макеевское","61610460"]
["Клепиковский муниципальный район","Малаховское","61610463"]
["Клепиковский муниципальный район","Молькинское","61610475"]
["Клепиковский муниципальный район","Ненашкинское","61610487"]
["Клепиковский муниципальный район","Оськинское","61610472"]
["Клепиковский муниципальный район","Спас-Клепиковское","61610101"]
["Клепиковский муниципальный район","Тумское","61610154"]
["Клепиковский муниципальный район","Тюковское","61610484"]
["Клепиковский муниципальный район","Уткинское","61610421"]
["Кораблинский муниципальный район","Бобровинское","61612408"]
["Кораблинский муниципальный район","Кипчаковское","61612424"]
["Кораблинский муниципальный район","Ключанское","61612428"]
["Кораблинский муниципальный район","Ковалинское","61612432"]
["Кораблинский муниципальный район","Кораблинский муниципальный район","61612000"]
["Кораблинский муниципальный район","Кораблинское","61612101"]
["Кораблинский муниципальный район","Молвинослободское","61612456"]
["Кораблинский муниципальный район","Незнановское","61612448"]
["Кораблинский муниципальный район","Пехлецкое","61612460"]
["Кораблинский муниципальный район","Пустотинское","61612464"]
["Кораблинский муниципальный район","Яблоневское","61612484"]
["Милославский муниципальный район","Богородицкое","61615408"]
["Милославский муниципальный район","Большеподовечинское","61615412"]
["Милославский муниципальный район","Горняцкое","61615422"]
["Милославский муниципальный район","Кочуровское","61615428"]
["Милославский муниципальный район","Липяговское","61615432"]
["Милославский муниципальный район","Милославский муниципальный район","61615000"]
["Милославский муниципальный район","Павловское","61615456"]
["Милославский муниципальный район","Центральное","61615160"]
["Милославский муниципальный район","Чернавское","61615472"]
["Милославский муниципальный район","городское поселение Милославское","61615151"]
["Милославский муниципальный район","сельское поселение Милославское","61615444"]
["Михайловский муниципальный район","Виленское","61617406"]
["Михайловский муниципальный район","Голдинское","61617412"]
["Михайловский муниципальный район","Горностаевское","61617415"]
["Михайловский муниципальный район","Грязновское","61617418"]
["Михайловский муниципальный район","Жмуровское","61617421"]
["Михайловский муниципальный район","Ильичевское","61617476"]
["Михайловский муниципальный район","Каморинское","61617433"]
["Михайловский муниципальный район","Красновское","61617439"]
["Михайловский муниципальный район","Михайловский муниципальный район","61617000"]
["Михайловский муниципальный район","Михайловское","61617101"]
["Михайловский муниципальный район","Новопанское","61617448"]
["Михайловский муниципальный район","Октябрьское","61617154"]
["Михайловский муниципальный район","Печерниковское","61617451"]
["Михайловский муниципальный район","Поярковское","61617457"]
["Михайловский муниципальный район","Рачатниковское","61617460"]
["Михайловский муниципальный район","Слободское","61617467"]
["Михайловский муниципальный район","Стрелецко-Высельское","61617470"]
["Михайловский муниципальный район","Трепольское","61617473"]
["Михайловский муниципальный район","Чуриковское","61617485"]
["Михайловский муниципальный район","Щетининское","61617491"]
["Пителинский муниципальный район","Ермо-Николаевское","61623420"]
["Пителинский муниципальный район","Нестеровское","61623425"]
["Пителинский муниципальный район","Пеньковское","61623435"]
["Пителинский муниципальный район","Пителинский муниципальный район","61623000"]
["Пителинский муниципальный район","Пителинское","61623151"]
["Пителинский муниципальный район","Потапьевское","61623450"]
["Пронский муниципальный район","Малинищинское","61625435"]
["Пронский муниципальный район","Мамоновское","61625440"]
["Пронский муниципальный район","Новомичуринское","61625114"]
["Пронский муниципальный район","Октябрьское","61625445"]
["Пронский муниципальный район","Орловское","61625450"]
["Пронский муниципальный район","Погореловское","61625455"]
["Пронский муниципальный район","Пронский муниципальный район","61625000"]
["Пронский муниципальный район","Пронское","61625151"]
["Пронский муниципальный район","Тырновское","61625405"]
["Путятинский муниципальный район","Береговское","61626406"]
["Путятинский муниципальный район","Большеекатериновское","61626403"]
["Путятинский муниципальный район","Карабухинское","61626424"]
["Путятинский муниципальный район","Песочинское","61626432"]
["Путятинский муниципальный район","Путятинский муниципальный район","61626000"]
["Путятинский муниципальный район","Путятинское","61626436"]
["Путятинский муниципальный район","Строевское","61626412"]
["Рыбновский муниципальный район","Алешинское","61627404"]
["Рыбновский муниципальный район","Баграмовское","61627406"]
["Рыбновский муниципальный район","Батуринское","61627408"]
["Рыбновский муниципальный район","Вакинское","61627416"]
["Рыбновский муниципальный район","Глебковское","61627418"]
["Рыбновский муниципальный район","Истобниковское","61627424"]
["Рыбновский муниципальный район","Кузьминское","61627436"]
["Рыбновский муниципальный район","Пионерское","61627476"]
["Рыбновский муниципальный район","Пощуповское","61627456"]
["Рыбновский муниципальный район","Рыбновский муниципальный район","61627000"]
["Рыбновский муниципальный район","Рыбновское","61627101"]
["Рыбновский муниципальный район","Селецкое","61627460"]
["Рыбновский муниципальный район","Ходынинское","61627472"]
["Рыбновский муниципальный район","Чурилковское","61627464"]
["Ряжский муниципальный район","Алешинское","61630405"]
["Ряжский муниципальный район","Дегтянское","61630415"]
["Ряжский муниципальный район","Журавинское","61630420"]
["Ряжский муниципальный район","Петровское","61630450"]
["Ряжский муниципальный район","Поплевинское","61630460"]
["Ряжский муниципальный район","Ряжский муниципальный район","61630000"]
["Ряжский муниципальный район","Ряжское","61630101"]
["Рязанский муниципальный район","Варсковское","61634402"]
["Рязанский муниципальный район","Высоковское","61634409"]
["Рязанский муниципальный район","Вышгородское","61634412"]
["Рязанский муниципальный район","Вышетравинское","61634415"]
["Рязанский муниципальный район","Дубровическое","61634427"]
["Рязанский муниципальный район","Дядьковское","61634430"]
["Рязанский муниципальный район","Екимовское","61634433"]
["Рязанский муниципальный район","Заборьевское","61634436"]
["Рязанский муниципальный район","Заокское","61634439"]
["Рязанский муниципальный район","Искровское","61634485"]
["Рязанский муниципальный район","Кораблинское","61634451"]
["Рязанский муниципальный район","Листвянское","61634457"]
["Рязанский муниципальный район","Льговское","61634460"]
["Рязанский муниципальный район","Мурминское","61634401"]
["Рязанский муниципальный район","Окское","61634475"]
["Рязанский муниципальный район","Подвязьевское","61634478"]
["Рязанский муниципальный район","Полянское","61634483"]
["Рязанский муниципальный район","Ровновское","61634490"]
["Рязанский муниципальный район","Рязанский муниципальный район","61634000"]
["Рязанский муниципальный район","Семеновское","61634495"]
["Рязанский муниципальный район","Турлатовское","61634496"]
["Рязанский муниципальный район","Тюшевское","61634498"]
["Сапожковский муниципальный район","Березниковское","61637435"]
["Сапожковский муниципальный район","Канинское","61637410"]
["Сапожковский муниципальный район","Михеевское","61637405"]
["Сапожковский муниципальный район","Морозово-Борковское","61637430"]
["Сапожковский муниципальный район","Сапожковский муниципальный район","61637000"]
["Сапожковский муниципальный район","Сапожковское","61637151"]
["Сараевский муниципальный район","Алексеевское","61640403"]
["Сараевский муниципальный район","Борецкое","61640412"]
["Сараевский муниципальный район","Бычковское","61640415"]
["Сараевский муниципальный район","Высоковское","61640424"]
["Сараевский муниципальный район","Желобовское","61640430"]
["Сараевский муниципальный район","Кривское","61640436"]
["Сараевский муниципальный район","Можарское","61640442"]
["Сараевский муниципальный район","Муравлянское","61640448"]
["Сараевский муниципальный район","Напольновское","61640451"]
["Сараевский муниципальный район","Новобокинское","61640454"]
["Сараевский муниципальный район","Сараевский муниципальный район","61640000"]
["Сараевский муниципальный район","Сараевское","61640151"]
["Сараевский муниципальный район","Сысоевское","61640469"]
["Сараевский муниципальный район","Телятниковское","61640472"]
["Сараевский муниципальный район","Ягодновское","61640481"]
["Сасовский муниципальный район","Агломазовское","61642403"]
["Сасовский муниципальный район","Алешинское","61642406"]
["Сасовский муниципальный район","Батьковское","61642415"]
["Сасовский муниципальный район","Берестянское","61642408"]
["Сасовский муниципальный район","Гавриловское","61642418"]
["Сасовский муниципальный район","Глядковское","61642420"]
["Сасовский муниципальный район","Демушкинское","61642466"]
["Сасовский муниципальный район","Каргашинское","61642424"]
["Сасовский муниципальный район","Кустаревское","61642433"]
["Сасовский муниципальный район","Малостуденецкое","61642439"]
["Сасовский муниципальный район","Нижнемальцевское","61642448"]
["Сасовский муниципальный район","Новоберезовское","61642454"]
["Сасовский муниципальный район","Придорожное","61642464"]
["Сасовский муниципальный район","Сасовский муниципальный район","61642000"]
["Сасовский муниципальный район","Сотницынское","61642470"]
["Сасовский муниципальный район","Трудолюбовское","61642463"]
["Скопинский муниципальный район","Вослебовское","61644412"]
["Скопинский муниципальный район","Горловское","61644415"]
["Скопинский муниципальный район","Ильинское","61644430"]
["Скопинский муниципальный район","Корневское","61644445"]
["Скопинский муниципальный район","Павелецкое","61644154"]
["Скопинский муниципальный район","Побединское","61644157"]
["Скопинский муниципальный район","Полянское","61644478"]
["Скопинский муниципальный район","Скопинский муниципальный район","61644000"]
["Скопинский муниципальный район","Успенское","61644488"]
["Скопинский муниципальный район","Шелемишевское","61644496"]
["Спасский муниципальный район","Выжелесское","61646409"]
["Спасский муниципальный район","Гавриловское","61646415"]
["Спасский муниципальный район","Заречинское","61646434"]
["Спасский муниципальный район","Ижевское","61646443"]
["Спасский муниципальный район","Исадское","61646446"]
["Спасский муниципальный район","Кирицкое","61646452"]
["Спасский муниципальный район","Киструсское","61646488"]
["Спасский муниципальный район","Кутуковское","61646455"]
["Спасский муниципальный район","Лакашинское","61646458"]
["Спасский муниципальный район","Михальское","61646461"]
["Спасский муниципальный район","Панинское","61646473"]
["Спасский муниципальный район","Перкинское","61646476"]
["Спасский муниципальный район","Собчаковское","61646485"]
["Спасский муниципальный район","Спасск-Рязанское","61646101"]
["Спасский муниципальный район","Спасский муниципальный район","61646000"]
["Спасский муниципальный район","Троицкое","61646493"]
["Спасский муниципальный район","Федотьевское","61646498"]
["Старожиловский муниципальный район","Гребневское","61648420"]
["Старожиловский муниципальный район","Гулынское","61648425"]
["Старожиловский муниципальный район","Истьинское","61648435"]
["Старожиловский муниципальный район","Ленинское","61648438"]
["Старожиловский муниципальный район","Мелекшинское","61648440"]
["Старожиловский муниципальный район","Старожиловский муниципальный район","61648000"]
["Старожиловский муниципальный район","Старожиловское","61648151"]
["Старожиловский муниципальный район","Столпянское","61648460"]
["Ухоловский муниципальный район","Калининское","61650430"]
["Ухоловский муниципальный район","Коноплинское","61650440"]
["Ухоловский муниципальный район","Ольховское","61650450"]
["Ухоловский муниципальный район","Смолеевское","61650455"]
["Ухоловский муниципальный район","Ухоловский муниципальный район","61650000"]
["Ухоловский муниципальный район","Ухоловское","61650151"]
["Чучковский муниципальный район","Аладьинское","61653405"]
["Чучковский муниципальный район","Завидовское","61653420"]
["Чучковский муниципальный район","Остро-Пластиковское","61653435"]
["Чучковский муниципальный район","Пертовское","61653440"]
["Чучковский муниципальный район","Ункосовское","61653450"]
["Чучковский муниципальный район","Чучковский муниципальный район","61653000"]
["Чучковский муниципальный район","Чучковское","61653151"]
["Шацкий муниципальный район","Агишевское","61656406"]
["Шацкий муниципальный район","Борковское","61656415"]
["Шацкий муниципальный район","Желанновское","61656418"]
["Шацкий муниципальный район","Каверинское","61656421"]
["Шацкий муниципальный район","Казачинское","61656427"]
["Шацкий муниципальный район","Кермисинское","61656433"]
["Шацкий муниципальный район","Криволуцкое","61656460"]
["Шацкий муниципальный район","Куплинское","61656439"]
["Шацкий муниципальный район","Кучасьевское","61656442"]
["Шацкий муниципальный район","Лесно-Конобеевское","61656445"]
["Шацкий муниципальный район","Лесно-Полянское","61656448"]
["Шацкий муниципальный район","Новосвеженское","61656450"]
["Шацкий муниципальный район","Новочернеевское","61656451"]
["Шацкий муниципальный район","Ольховское","61656454"]
["Шацкий муниципальный район","Печинское","61656457"]
["Шацкий муниципальный район","Польно-Ялтуновское","61656463"]
["Шацкий муниципальный район","Тарадеевское","61656478"]
["Шацкий муниципальный район","Чернослободское","61656484"]
["Шацкий муниципальный район","Шацкий муниципальный район","61656000"]
["Шацкий муниципальный район","Шацкое","61656101"]
["Шацкий муниципальный район","Ямбирнское","61656493"]
["Шиловский муниципальный район","Аделинское","61658403"]
["Шиловский муниципальный район","Борковское","61658475"]
["Шиловский муниципальный район","Боровское","61658415"]
["Шиловский муниципальный район","Ерахтурское","61658424"]
["Шиловский муниципальный район","Желудевское","61658427"]
["Шиловский муниципальный район","Задубровское","61658430"]
["Шиловский муниципальный район","Занино-Починковское","61658445"]
["Шиловский муниципальный район","Ибредское","61658473"]
["Шиловский муниципальный район","Инякинское","61658436"]
["Шиловский муниципальный район","Краснохолмское","61658439"]
["Шиловский муниципальный район","Лесновское","61658157"]
["Шиловский муниципальный район","Мосоловское","61658448"]
["Шиловский муниципальный район","Санское","61658472"]
["Шиловский муниципальный район","Тереховское","61658478"]
["Шиловский муниципальный район","Тимошкинское","61658481"]
["Шиловский муниципальный район","Тырновское","61658484"]
["Шиловский муниципальный район","Шиловский муниципальный район","61658000"]
["Шиловский муниципальный район","Шиловское","61658151"]

{"sheet":"modHyperlink","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modChange","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modPROV","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modTitleSheetHeaders","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modServiceModule","index":22,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modCommandButton","index":23,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modReestr","index":24,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modClassifierValidate","index":25,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modInfo","index":26,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modfrmReestr","index":27,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modfrmDateChoose","index":28,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modDblClick","index":29,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Паспорт","index":30,"n_rows":71,"n_cols":57,"rows_kept":71,"cut":false,"hidden":true,"merged":[[38,8,38,10],[39,8,39,10],[40,8,40,10],[42,8,42,10],[43,8,43,10],[48,8,48,10],[49,8,49,10],[46,8,46,10],[47,8,47,10],[41,8,41,10],[3,3,3,10],[12,5,12,10],[13,5,13,10],[6,5,6,10],[7,5,7,10],[5,3,5,10],[8,5,8,10],[9,5,9,10],[10,5,10,10],[11,5,11,10],[14,6,14,9],[21,5,21,10],[17,3,17,10],[15,5,15,10],[18,5,18,10],[19,5,19,10],[20,5,20,10],[30,5,30,10],[31,7,31,10],[32,7,32,10],[22,5,22,10],[23,5,23,10],[29,3,29,10],[25,3,25,10],[26,5,26,10],[27,3,27,10],[33,3,33,10],[54,3,54,10],[62,5,62,10],[57,5,57,10],[58,5,58,10],[56,3,56,10],[36,8,36,10],[37,8,37,10],[59,5,59,10],[35,3,35,10],[52,8,52,10],[53,8,53,10],[44,8,44,10],[45,8,45,10],[50,8,50,10],[51,8,51,10],[64,3,64,10],[61,3,61,10],[63,5,63,10],[70,5,70,10],[69,5,69,10],[68,5,68,10],[67,5,67,10],[66,3,66,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Код диапазона:","Название диапазона:","Сфера регулирования:","Подсфера:","Тип информации в шаблоне:","Состояние шаблона:","Периодичность:","\"Геотип\" шаблона:","Тип шаблона:","Заказчик:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ps_sr","Сфера регулирования:","Не определено","Не определено","Не определено","Не определено","Не определено","Не определено","Не определено","Не определено"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ps_ti","Тип информации в шаблоне:","NETS","водоотведение - очистка","Статистический","Проект","Единовременный","Региональный шаблон","Атомарный","РЭК"]
[null,null,null,"Паспорт к шаблону",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ps_ssh","Состояние шаблона:","Аэропорты","водоотведение - передача","Расчетный","Утвержден","Ежемесячный","Муниципальный шаблон","Сводный","ФСТ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ps_p","Периодичность:","Газ","водоотведение - прием","Обосновывающие материалы",null,"Ежеквартальный","Шаблон от организации",null,"Экспертная организация"]
[null,null,null,"1. Общие сведения",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ps_geo","\"Геотип\" шаблона:","Железные дороги","водоснабжение - очистка",null,null,"Ежегодный"]
[null,null,null,"1.1","Код","EE.BALANCE.SBO.3.23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ps_tsh","Тип шаблона:","ЖКХ","водоснабжение - передача"]
[null,null,null,"1.2","Краткое наименование","Отчет о фактическом исполнении прогнозных балансов производства и поставок электрической (тепловой) энергии и мощности по электростанции",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ps_psr","Подсфера:","Медицина","водоснабжение - подъем"]
[null,null,null,"1.3","Полное наименование","Отчет о фактическом исполнении прогнозных балансов производства и поставок электрической (тепловой) энергии и мощности по электростанции",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ps_z","Заказчик:","Порты","выработка ТС  "]
[null,null,null,"1.4","Сфера регулирования ","Электроэнергетика",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Связь","выработка ТС в режиме комбинированной выработки"]
[null,null,null,"1.5","Подсфера","Не определено",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Транспорт","выработка электрической энергии"]
[null,null,null,"1.6","Состояние шаблона (Утвержден/Проект)","Проект",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Электроэнергетика","выработка+передача+сбыт ТС"]
[null,null,null,"1.7","Заказчик","РЭК",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"передача ТС"]
[null,null,null,"1.8","Отчитывается","Региональный шаблон",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"передача ЭЭ"]
[null,null,null,"1.9","Тип шаблона","Атомарный","Если шаблон сводный, необходимо указать код атомарного шаблона для него:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"сбыт ТС"]
[null,null,null,"1.10","Текущая версия","1.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"сбыт ЭЭ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ТБО"]
[null,null,null,"2. Организационные"]
[null,null,null,"2.1","Тип информации в шаблоне ","Расчетный"]
[null,null,null,"2.2","Ответственный регулятор (от заказчика)"]
[null,null,null,"2.3","Ответственный специалист (от СМА)"]
[null,null,null,"2.4","Ответственный программист (от СМА)","Кропачева А.В."]
[null,null,null,"2.5","Ответственные за сбор данных (от СМА)"]
[null,null,null,"2.6","Ответственные за сбор данных (от заказчика)"]
[]
[null,null,null,"3. Законодательство (методики, приказы, постановления ...)"]
[null,null,"first","3.1","Документ1"]
[null,null,"end","Добавить документ"]
[]
[null,null,null,"4. Периодичность"]
[null,null,null,"4.1","Периодичность","Не определено"]
[null,null,null,null,"Мониторинги(прошедшие и плановые)","Дата начала","Дата окончания","Согласно (приказ, постановление, письмо)"]
[null,null,"first","4.2.1","Мониторинг1"]
[null,null,"end","Добавить мониторинг"]
[]
[null,null,null,"5. Состав шаблона"]
[null,null,null,null,"Лист","Последняя дата изменений эскиза","Состояние листа","Наименование витрины для листа","Комментарии"]
[null,null,"first","5.1.1","Инструкция","24.03.2009","В разработке"]
[null,null,"Удалить","5.1.2","Справочники","24.03.2009","В разработке"]
[null,null,"Удалить","5.1.3","Титульный","24.03.2009","В разработке"]
[null,null,"Удалить","5.1.4","янв","24.03.2009","В разработке"]
[null,null,"Удалить","5.1.5","фев","25.03.2009","В разработке"]
[null,null,"Удалить","5.1.6","март","25.03.2010","В разработке"]
[null,null,"Удалить","5.1.7","апр","25.03.2011","В разработке"]
[null,null,"Удалить","5.1.8","май","25.03.2012","В разработке"]
[null,null,"Удалить","5.1.9","июнь","25.03.2013","В разработке"]
[null,null,"Удалить","5.1.10","июль","25.03.2014","В разработке"]
[null,null,"Удалить","5.1.11","авг","25.03.2015","В разработке"]
[null,null,"Удалить","5.1.12","сент","25.03.2016","В разработке"]
[null,null,"Удалить","5.1.13","окт","25.03.2017","В разработке"]
[null,null,"Удалить","5.1.14","нояб","25.03.2018","В разработке"]
[null,null,"Удалить","5.1.15","дек","25.03.2019","В разработке"]
[null,null,"Удалить","5.1.16","свод","25.03.2020","В разработке"]
[null,null,"Удалить","5.1.17","Проверка","24.03.2009","В разработке"]
[null,null,"end","Добавить лист"]
[]
[null,null,null,"6. Сроки и даты"]
[null,null,null,"6.1.1","Даты получения последних эскизов, от экспертов","24.03.2009"]
[null,null,null,"6.1.2","Даты отправки шаблона на проверку","25.03.2009"]
[null,null,null,"6.1.3","Предполагаемый срок сдачи шаблона в эксплуатацию"]
[]
[null,null,null,"7. Версии"]
[null,null,null,null,"Версия","Отличия от предыдущей"]
[null,null,"first","7.1"]
[null,null,"end","Добавить версию"]
[]
[null,null,null,"8. Дополнительно"]
[null,null,null,"8.1","Аналогичные(\"похожие\") шаблоны"]
[null,null,null,"8.2","Особенности шаблона"]
[null,null,null,"8.3","Модуль на основе данного шаблона"]
[null,null,null,"8.4","Процедуры загрузки данных в витрины"]

{"sheet":"modUpdTemplMain","index":31,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modRegionSelectSub","index":32,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modThisWorkbook","index":33,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modReestrMO","index":34,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modSheetMain01","index":35,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modSheetMain02","index":36,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modSheetMain03","index":37,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modSheetMain04","index":38,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modSheetMain05","index":39,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modSheetMain06","index":40,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modSheetMain07","index":41,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modSheetMain08","index":42,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"modSheetMain09","index":43,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}