{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Расчет"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":24,"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":101,"n_cols":9,"rows_kept":101,"cut":false,"hidden":false,"merged":[[14,3,14,4],[15,1,15,4],[33,1,33,4],[17,8,30,12],[0,0,0,5],[2,2,2,4],[4,2,5,4],[7,2,7,4],[9,2,9,4],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,11,4],[11,5,12,5]]}
["РАСЧЕТ"]
[]
[null,"на"]
[]
[]
[null,"Наименование организации"]
[]
[null,"Район"]
[]
[null,"Населенный пункт"]
[]
["№ п/п","Наименование показателей","Ед.изм.","Год",null,"Отклонение\n(п.5-п.4)"]
[]
[1,2,3,4,5,6]
["Условия"]
["I","Объем"]
[1,"А","тыс.куб.м.",{"$f":"D23+D21+D19","v":160},{"$f":"E23+E21+E19","v":50},{"$f":"E17-D17","v":-110}]
[2,"Б","тыс.куб.м.",10,null,{"$f":"E18-D18","v":-10},null,null,"Нужно скрыть строки в каждом из разделов (I, II), в которых по столбцам D и E нет данных. При этом основные пункты (закрашенные зеленой заливкой: А,Б,В,Г,Д и тд.), даже если в них сумма показателей равна нулю, скрываться не должны."]
[3,"В","тыс.куб.м.",null,20,20]
[4,"Г","тыс.куб.м.",{"$f":"D23+D21","v":160},{"$f":"E23+E21","v":30},-130]
[5,"Д","тыс.куб.м.",50,null,-50]
["5.1","Д1","%",{"$f":"IF(D20=0,0,D21/D20*100)","v":31.25},{"$f":"IF(E20=0,0,E21/E20*100)","v":0},-31.25]
[6,"Е","тыс.куб.м.",{"$f":"D24+D25+D26","v":110},{"$f":"E24+E25+E26","v":30},-80]
["6.1","Е1","тыс.куб.м.",null,30,30]
["6.2","Е2","тыс.куб.м.",null,null,0,"скрыть"]
["6.3","Е3","тыс.куб.м.",{"$f":"D27+D28+D31","v":110},{"$f":"E27+E28+E31","v":0},-110]
["6.3.1","Е31","тыс.куб.м.",50,null,-50]
["6.3.2","Е32","тыс.куб.м.",{"$f":"D29+D30","v":60},{"$f":"E29+E30","v":0},-60]
[null,"Е321","тыс.куб.м.",null,null,0,"скрыть"]
[null,"Е322","тыс.куб.м.",60,null,-60]
["6.3.3","Е33","тыс.куб.м.",null,null,0,"скрыть"]
[7,"Ё","тыс.куб.м.",{"$f":"D29","v":0},{"$f":"E29","v":0},0]
[8,"Ж","тыс.куб.м.",{"$f":"D30","v":60},{"$f":"E30","v":0},-60]
["II","Расходы"]
["1","А","тыс.руб.",{"$f":"D36+D37+D57+D58+D64+D65+D66","v":600},{"$f":"E36+E37+E57+E58+E64+E65+E66","v":800},{"$f":"E35-D35","v":200}]
["1.1","А1","тыс.руб.",100,null,-100]
["1.2","А2","тыс.руб.",{"$f":"D38+D54+D55+D56","v":500},{"$f":"E38+E54+E55+E56","v":800},300]
["1.2.1","А21","тыс.руб.",{"$f":"D42+D45+D48+D51","v":0},{"$f":"E42+E45+E48+E51","v":200},200]
[null,"А211","тыс.кВт*ч",{"$f":"D43+D46+D49+D52","v":0},{"$f":"E43+E46+E49+E52","v":200},200]
[null,"А212","руб.",{"$f":"IF(D39=0,0,D38/D39)","v":0},{"$f":"IF(E39=0,0,E38/E39)","v":1},1]
[null,"А213","кВт*чм3",{"$f":"IF(D17=0,0,D39/D17*1000)","v":0},{"$f":"IF(E17=0,0,E39/E17*1000)","v":4000},4000]
[null,"А2131","тыс.руб.",{"$f":"D43*D44","v":0},{"$f":"E43*E44","v":200},200]
[null,"А21311","тыс.кВт*ч",null,200,200]
[null,"А21312","руб.",null,1,1]
[null,"А2132","тыс.руб.",{"$f":"D46*D47","v":0},{"$f":"E46*E47","v":0},0]
[null,"А21321","тыс.кВт*ч",null,null,0,"скрыть"]
[null,"А213122","руб.",null,null,0,"скрыть"]
[null,"А2133","тыс.руб.",{"$f":"D49*D50","v":0},{"$f":"E49*E50","v":0},0]
[null,"А21331","тыс.кВт*ч",null,null,0,"скрыть"]
[null,"А21332","руб.",null,null,0,"скрыть"]
[null,"А2134","тыс.руб.",{"$f":"D52*D53","v":0},{"$f":"E52*E53","v":0},0]
[null,"А21341","тыс.кВт*ч",null,null,0,"скрыть"]
[null,"А21342","руб.",null,null,0,"скрыть"]
["1.2.2","А22","тыс.руб.",500,null,-500]
["1.2.3","А23","тыс.руб.",null,600,600]
["1.2.4","А24","тыс.руб.",null,null,0,"скрыть"]
["1.3","А3","тыс.руб.",null,null,0,"скрыть"]
["1.4","А4","тыс.руб.",{"$f":"D59+D63","v":0},{"$f":"E59+E63","v":0},0]
["1.4.1","А41","тыс.руб.",null,null,0,"скрыть"]
[null,"А411","руб.",null,null,{"$f":"E60-D60","v":0},"скрыть"]
[null,"А412","чел.",null,null,{"$f":"E61-D61","v":0},"скрыть"]
[null,"А413","руб./мес.",{"$f":"IF(D61=0,0,D59/D61/12*1000)","v":0},{"$f":"IF(E61=0,0,E59/E61/12*1000)","v":0},{"$f":"E62-D62","v":0}]
["1.4.2","А42","тыс.руб.",null,null,0,"скрыть"]
["1.5","А5","тыс.руб.",null,null,0,"скрыть"]
["1.6","А6","тыс.руб.",null,null,0,"скрыть"]
["1.7","А7","тыс.руб.",null,null,0,"скрыть"]
["2","Б","тыс.руб.",{"$f":"D68+D69+D70+D71","v":500},{"$f":"E68+E69+E70+E71","v":600},100]
["2.1","Б1","тыс.руб.",500,null,-500]
["2.2","Б2","тыс.руб.",null,null,0,"скрыть"]
["2.3","Б3","тыс.руб.",null,600,600]
["2.4","Б4","тыс.руб.",null,null,0,"скрыть"]
["3","В","тыс.руб.",{"$f":"D73+D74+D77+D78+D79+D80+D81+D82","v":0},{"$f":"E73+E74+E77+E78+E79+E80+E81+E82","v":0},0]
["3.1","В1","тыс.руб.",null,null,0,"скрыть"]
["3.2","В2","тыс.руб.",null,null,0,"скрыть"]
["3.2.1","В21","чел.",null,70,{"$f":"E75-D75","v":70}]
["3.2.2","В22","руб./мес.",{"$f":"IF(D75=0,0,D74/D75/12*1000)","v":0},{"$f":"IF(E75=0,0,E74/E75/12*1000)","v":0},{"$f":"E76-D76","v":0}]
["3.3","В3","тыс.руб.",null,null,0,"скрыть"]
["3.4","В4","тыс.руб.",null,null,0,"скрыть"]
["3.5","В5","тыс.руб.",null,null,0,"скрыть"]
["3.6","В6","тыс.руб.",null,null,0,"скрыть"]
["3.7","В7","тыс.руб.",null,null,0,"скрыть"]
["3.8","В8","тыс.руб.",null,null,0,"скрыть"]
["4","Г","тыс.руб.",600,null,-600]
["5","Д","тыс.руб.",null,700,700]
["6","Е","тыс.руб.",{"$f":"D86+D87+D88+D89+D90+D91","v":800},{"$f":"E86+E87+E88+E89+E90+E91","v":200},-600]
["6.1","Е1","тыс.руб.",800,null,-800]
["6.2","Е2","тыс.руб.",null,null,0,"скрыть"]
["6.3","Е3","тыс.руб.",null,200,200]
["6.4","Е4","тыс.руб.",null,null,0,"скрыть"]
["6.5","Е5","тыс.руб.",null,null,0,"скрыть"]
["6.6","Е6","тыс.руб.",null,null,0,"скрыть"]
["7","Ё","тыс.руб.",{"$f":"D93+D94+D95+D96+D97","v":900},{"$f":"E93+E94+E95+E96+E97","v":0},-900]
["7.1","Ё1","тыс.руб.",900,null,-900]
["7.2","Ё2","тыс.руб.",null,null,0,"скрыть"]
["7.3","Ё3","тыс.руб.",null,null,0,"скрыть"]
["7.4","Ё4","тыс.руб.",null,null,0,"скрыть"]
["7.5","Ё5","тыс.руб.",null,null,0,"скрыть"]
["8","Ж","тыс.руб.",50,null,-50]
["9","З","тыс.руб.",null,80,80]
["10","И","тыс.руб.",{"$f":"(D35+D67+D72+D83+D84+D85+D92+D98)-D99","v":3450},{"$f":"(E35+E67+E72+E83+E84+E85+E92+E98)-E99","v":2220},-1230]
["III","К","руб.",{"$f":"IF(D23=0,0,D100/D23)","v":31.363636363636363},{"$f":"IF(E23=0,0,E100/E23)","v":74},42.63636363636364]