{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["10-ОИП_Раздел 1","10-ОИП_Раздел 2","Сообщения","Настройки словаря","Настройка","Методики","Методики DOS","Параметры"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":6,"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":"10-ОИП_Раздел 1","index":0,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[10,0,10,7],[6,0,6,7],[4,0,4,5],[11,0,11,7],[12,0,12,7],[8,3,8,4],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,15,7],[2,0,2,5],[2,6,2,7],[3,6,3,7],[4,6,4,7],[3,0,3,5],[9,0,9,7],[51,0,51,1],[51,2,51,3],[51,5,51,6],[52,2,52,3],[52,5,52,6],[16,9,16,11],[14,1,16,1],[14,0,16,0],[14,2,14,7],[15,2,16,2],[53,2,53,3],[53,5,53,6],[54,2,54,3],[54,5,54,6],[49,5,49,6],[50,5,50,6]]}
["161000","лок.код","030",""]
[]
["Представляют: Органы исполнительной власти субъектов Российской Федерации, осуществляющие переданные полномочия Российской Федерации в области лесных отношений",null,null,null,null,null,"Форма 10-ОИП "]
["Срок представления: не позднее 25-го числа месяца, следующего за отчетным периодом",null,null,null,null,null,"ежеквартальная"]
["Кому представляется: Федеральное агентство лесного хозяйства, 115184, г. Москва, ул. Пятницкая, д. 59/19",null,null,null,null,null,"Утверждена приказом \nМинприроды России\nот 28.12.2015 г. № 565"]
[]
["Раздел 1. Сведения об очагах вредителей и болезней леса"]
[null,null,"за  январь -","декабрь",2018,"года"]
[null,null,null,"(нарастающим итогом)"]
["Липецкая обл. Управление ЛХ"]
["(наименование органа исполнительной власти субъекта Российской Федерации)"]
[]
["(наименование лесничества, лесопарка)"]
[]
["Наименование показателя","Код строки","Площадь очагов вредных организмов, га"]
[null,null,"на начало отчетного года","возникло вновь","ликвидировано мерами борьбы","затухло под воздействием естественных факторов","на конец отчетного периода"]
[null,null,null,null,null,null,"всего\n(гр.1+2-3-4)","в т.ч. требуют мер борьбы",null,"Протокол контроля"]
["А","Б",1,2,3,4,5,6,null,"строки","гр.(1+2)>=гр.(3+4)","гр.5.>=гр.6"]
["Вредители леса, всего","10",{"$f":"SUM(C20,C32,C39)","v":0},{"$f":"SUM(D20,D32,D39)","v":0},{"$f":"SUM(E20,E32,E39)","v":0},{"$f":"SUM(F20,F32,F39)","v":0},{"$f":"SUM(C19,D19)-SUM(E19,F19)","v":0},{"$f":"SUM(H20,H32,H39)","v":0},null,{"$f":"B19","v":"10"},{"$f":"IF((C19+D19)>=(E19+F19),0,(C19+D19)-(E19+F19))","v":0},{"$f":"IF(G19>=H19,0,G19-H19)","v":0}]
["  в том числе:\n  хвоегрызущие вредители:","20",{"$f":"SUM(C21:C31)","v":0},{"$f":"SUM(D21:D31)","v":0},{"$f":"SUM(E21:E31)","v":0},{"$f":"SUM(F21:F31)","v":0},0,{"$f":"SUM(H21:H31)","v":0},null,{"$f":"B20","v":"20"},{"$f":"IF((C20+D20)>=(E20+F20),0,(C20+D20)-(E20+F20))","v":0},{"$f":"IF(G20>=H20,0,G20-H20)","v":0}]
["       сибирский шелкопряд","21",null,null,null,null,0,null,null,"21",0,0]
["       сосновый шелкопряд","22",null,null,null,null,0,null,null,"22",0,0]
["       шелкопряд монашенка","23",null,null,null,null,0,null,null,"23",0,0]
["       сосновая пяденица","24",null,null,null,null,0,null,null,"24",0,0]
["       сосновая совка","25",null,null,null,null,0,null,null,"25",0,0]
["       рыжий сосновый пилильщик","26",null,null,null,null,0,null,null,"26",0,0]
["       обыкновенный сосновый \n       пилильщик","27",null,null,null,null,0,null,null,"27",0,0]
["       красноголовый пилильщик-\n       ткач","28",null,null,null,null,0,null,null,"28",0,0]
["       звездчатый пилильщик-\n       ткач","29",null,null,null,null,0,null,null,"29",0,0]
["       еловый обыкновенный \n       пилильщик","30",null,null,null,null,0,null,null,"30",0,0]
["       другие","31",null,null,null,null,0,null,null,"31",0,0]
["   листогрызущие вредители:","40",{"$f":"SUM(C33:C38)","v":0},{"$f":"SUM(D33:D38)","v":0},{"$f":"SUM(E33:E38)","v":0},{"$f":"SUM(F33:F38)","v":0},0,{"$f":"SUM(H33:H38)","v":0},null,"40",0,0]
["       непарный шелкопряд","41",null,null,null,null,0,null,null,"41",0,0]
["       американская белая \n       бабочка","42",null,null,null,null,0,null,null,"42",0,0]
["       пяденица зимняя","43",null,null,null,null,0,null,null,"43",0,0]
["       златогузка","44",null,null,null,null,0,null,null,"44",0,0]
["       дубовая зеленая листовертка","45",null,null,null,null,0,null,null,"45",0,0]
["       другие","46",null,null,null,null,0,null,null,"46",0,0]
["   стволовые вредители:","50",{"$f":"SUM(C40:C43)","v":0},{"$f":"SUM(D40:D43)","v":0},{"$f":"SUM(E40:E43)","v":0},{"$f":"SUM(F40:F43)","v":0},0,{"$f":"SUM(H40:H43)","v":0},null,"50",0,0]
["       хрущи","51",null,null,null,null,0,null,null,"51",0,0]
["       сосновый подкорный клоп","52",null,null,null,null,0,null,null,"52",0,0]
["       короед-типограф","53",null,null,null,null,0,null,null,"53",0,0]
["       другие","54",null,null,null,null,0,null,null,"54",0,0]
["Болезни леса, всего","60",{"$f":"SUM(C45:C46)","v":21430},{"$f":"SUM(D45:D46)","v":2353},{"$f":"SUM(E45:E46)","v":1995},{"$f":"SUM(F45:F46)","v":5382},16406,{"$f":"SUM(H45:H46)","v":7743},null,"60",0,0]
["  в том числе:\n       корневая губка","61",10779,1497,1495,3018,7763,1909,null,"61",0,0]
["       другие","62",10651,856,500,2364,8643,5834,null,{"$f":"B46","v":"62"},{"$f":"IF((C46+D46)>=(E46+F46),0,(C46+D46)-(E46+F46))","v":0},{"$f":"IF(G46>=H46,0,G46-H46)","v":0}]
["Итого","70",{"$f":"SUM(C19,C44)","v":21430},{"$f":"SUM(D19,D44)","v":2353},{"$f":"SUM(E19,E44)","v":1995},{"$f":"SUM(F19,F44)","v":5382},16406,{"$f":"SUM(H19,H44)","v":7743},null,"70",0,0]
["Справочно: по лесам, расположен-\nным на землях иных категорий","80",null,"Х","Х","Х",null,"Х"]
[]
["Руководитель ",null,null,null,null,"Соколов В.Н."]
[null,null,null,null,null,"(Ф.И.О.)",null,"(подпись)"]
["Должностное лицо, \nответственное за составление формы",null,"консультант",null,null,"Князев А.Е."]
[null,null,"(должность)",null,null,"(Ф.И.О.)",null,"(подпись)"]
[null,null,"10.01.2019",null,null,"8-4742-43-00-07"]
[null,null,"(дата составления документа)",null,null,"(номер контактного телефона\nс указанием кода города)"]

{"sheet":"10-ОИП_Раздел 2","index":1,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":false,"merged":[[11,12,11,14],[9,0,11,0],[9,1,11,1],[9,2,9,7],[9,8,9,10],[10,2,11,2],[10,10,11,10],[10,8,11,8],[10,9,11,9],[10,6,11,6],[10,7,11,7],[23,5,23,6],[23,12,23,21],[27,2,27,3],[28,2,28,3],[1,0,1,10],[27,5,27,6],[28,5,28,6],[3,5,3,6],[4,2,4,9],[24,5,24,6],[25,0,25,1],[25,2,25,3],[5,2,5,9],[26,2,26,3],[26,5,26,6],[7,2,7,9],[10,3,10,5],[6,2,6,9],[25,5,25,6]]}
["161001","лок.код",{"$f":"'10-ОИП_Раздел 1'!C1","v":"030"},{"$f":"'10-ОИП_Раздел 1'!D1","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW(#REF!)","v":{"$error":"#REF!"}},{"$f":"COLUMN(#REF!)","v":{"$error":"#REF!"}}]
["Раздел 2. Сведения о повреждении и гибели лесов "]
[null,null,null,null,"за  январь -",{"$f":"'10-ОИП_Раздел 1'!D8","v":"декабрь"},{"$f":"'10-ОИП_Раздел 1'!E8","v":2018},"года"]
[null,null,null,null,null,"(нарастающим итогом)"]
[null,null,{"$f":"'10-ОИП_Раздел 1'!A10","v":"Липецкая обл. Управление ЛХ"}]
[null,null,"(наименование органа исполнительной власти субъекта Российской Федерации)"]
[null,null,{"$f":"'10-ОИП_Раздел 1'!A12","v":0}]
[null,null,"(наименование лесничества, лесопарка)"]
["                                                                          "]
["Наименование причин повреждения и гибели лесов","Код строки","Поврежденные насаждения, га ",null,null,null,null,null,"в том числе погибшие насаждения, га"]
[null,null,"Всего ","в том числе по степени усыхания\n лесных насаждений",null,null,"Повреждено с начала года","площадь лесов, указанных \nв графе 1, на которых проведены лесопатологи-ческие обследования","Всего ","Погибло с начала года","площадь лесов, указанных \nв графе 7, на которых проведены лесопатологи-ческие обследования"]
[null,null,null,"4,1 - 10%","10-40%","более 40%",null,null,null,null,null,null,"Протокол контроля"]
["А","В",1,2,3,4,5,6,7,8,9,null,"строки","гр.1>=гр.6","гр.7>=гр.9"]
["Лесные пожары ","10",{"$f":"SUM(D14:F14)","v":806.9},24.8,632.20000000000005,149.9,19.900000000000002,139.5,104.7,13.899999999999999,104.7,null,10,{"$f":"IF(C14>=H14,0,C14-H14)","v":0},{"$f":"IF(I14>=K14,0,I14-K14)","v":0}]
["в том числе от пожаров текущего года","11",0,null,null,null,null,null,null,null,null,null,"11",{"$f":"IF(C15>=H15,0,C15-H15)","v":0},{"$f":"IF(I15>=K15,0,I15-K15)","v":0}]
["Повреждения насекомыми","20",1.9,null,null,1.9,5.6999999999999993,null,0.9,4.7,null,null,"20",0,0]
["Погодные условия и почвенно-климатические факторы","30",1586.8000000000002,1095.3000000000002,305.3,186.2,504.69999999999993,1200.1000000000001,34.800000000000004,32.700000000000003,21.700000000000003,null,"30",0,0]
["Болезни леса","40",13367.5,6325.5999999999995,6498.4000000000005,543.5,2695,8803,251.5,590.1,216.00000000000003,null,"40",0,0]
["Повреждения дикими животными","50",9.9,null,9.9,null,null,9.9,null,null,null,null,"50",0,0]
["Антропогенные факторы","60",77.699999999999989,15.1,60.099999999999994,2.5,11.2,65,null,null,null,null,"60",0,0]
["Непатогенные факторы","70",0,0,null,null,null,null,null,null,null,null,"70",0,0]
["Всего","80",{"$f":"SUM(C14,C16:C21)","v":15850.7},7460.8,7505.9000000000005,884,3236.5,10217.5,391.9,641.4,342.40000000000003,null,"80",0,0]
[]
["Руководитель ",null,null,null,null,"Соколов В.Н.",null,null,null,null,null,null,"Протокол контроля"]
[null,null,null,null,null,"(Ф.И.О.)",null,null,"(подпись)",null,null,null,"формула контроля","гр.1","гр.2","гр.3","гр.4","гр.5","гр.6","гр.7","гр.8","гр.9"]
["Должностное лицо, \nответственное за составление формы",null,"консультант",null,null,"Князев А.Е.",null,null,null,null,null,null,"стр.10>=стр.11",{"$f":"IF(C14>=C15,0,C14-C15)","v":0},{"$f":"IF(D14>=D15,0,D14-D15)","v":0},0,0,0,0,0,0,0]
[null,null,"(должность)",null,null,"(Ф.И.О.)",null,null,"(подпись)"]
[null,null,"10.01.2019",null,null,"8-4742-43-00-07"]
[null,null,"(дата составления документа)",null,null,"(номер контактного телефона\nс указанием кода города)"]

{"sheet":"Сообщения","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Количество сведенных книг: 9."]

{"sheet":"Настройки словаря","index":3,"n_rows":3,"n_cols":18,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,16,0,17],[0,4,0,5],[0,8,0,9],[0,0,1,0],[0,10,0,11],[0,12,0,13],[0,6,0,7],[0,2,0,3],[0,14,0,15]]}
["Имя листа","Выбор лесничества","Версия словаря",null,"Краткое наименование орг.",null,"Полное наименование орг.",null,"Код орг.",null,"Наименование лесничества",null,"Код лесничества",null,"Наименование суб.",null,"Код суб."]
[null,"1-да, 2-нет","строка","графа","строка","графа","строка","графа","строка","графа","строка","графа","строка","графа","строка","графа","строка","графа"]
["10-ОИП_Раздел 1",1,null,null,10,1,null,null,1,3,12,1,1,4]

{"sheet":"Настройка","index":4,"n_rows":3,"n_cols":81,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,8,0,9],[0,6,0,7]]}
["код\nформы","Наименование формы","Имя\nлиста\n(формы)","Здесь надо\nпоставить\nсимвол \n*","адрес\nназв.\nУЛ (c/r)",null,"адрес кода формы (c/r)",null,"адрес\nдаты (c/r)",null,"Кол\nблк","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г.","dS","c.","г.","с.","г."]
["161000","10-ОИП","10-ОИП_Раздел 1",7,3,1,1,1,null,null,1,1,3,19,8,48]
["161001","10-ОИП","10-ОИП_Раздел 2",7,3,1,1,1,null,null,1,1,3,14,11,22]

{"sheet":"Методики","index":5,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[{"$f":"COUNTIF(A3:A1000,\"*Ошибка*\")","v":0},{"$f":"COUNTIF(B3:B1000,\"*Ошибка*\")","v":0},{"$f":"COUNTIF(C3:C1000,\"*Ошибка*\")","v":0}]

{"sheet":"Методики DOS","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Параметры","index":7,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Строка в формах для анализа, с которой должны выводиться данные",10]
["Столбец в формах для анализа, с которого должны выводиться данные",3]