{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["введение","ПОТЕРИ","скорость","диффузор","прямой","отвод","фильтр"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"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":"введение","index":0,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":true,"merged":[[62,2,62,3],[62,7,64,7],[62,8,63,10],[63,2,63,3],[64,2,64,3],[64,8,64,10],[56,7,58,10],[59,2,59,3],[60,2,60,3],[60,8,61,8],[60,9,61,9],[60,10,61,10],[61,2,61,3],[60,7,61,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"7582-003-АТС.01.ГП"]
[]
[null,null,"Изм.","Лист","№ докум","Подп.","Дата"]
[null,null,"Разраб.",null,"Медвинский",null,null,"УУТЭ","Стадия","Лист","Листов"]
[null,null,"Пров.",null,"Волков",null,null,"пр. М.Тореза, кв.7-7А, УУТЭ-1","Р","1.1","4"]
[null,null,"Т.контр."]
[null,null,"Принял",null,null,null,null,"Гидравлический расчет","ЗАО \"СРНУ\""]
[null,null,"Н.контр."]
[null,null,"Утв.",null,null,null,null,null,"Санкт-Петербург"]

{"sheet":"ПОТЕРИ","index":1,"n_rows":134,"n_cols":200,"rows_kept":134,"cut":false,"hidden":false,"merged":[[1,1,1,5],[14,1,15,1],[14,4,14,5],[16,1,16,5],[34,1,34,5],[13,1,13,5],[2,1,2,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,"на узлах учета с ультразвуковыми расходомерами \"ПУЛЬСАР\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,6.0000000000000001E-3,0.6,1.2,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,1.2E-2,0.6,1.2,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0.03,1.5,3,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,1.4999999999999999E-2,1.5,3.5,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0.03,1.5,3,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,20,2.5000000000000001E-2,2.5,5,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,3.5000000000000003E-2,3.5,7,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0.06,6,12,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0.06,6,12,11,null,"Выбор ДУ 1-й","Выбор ДУ 2-й"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0.1,10,20,12,null,{"$f":"SMALL(IF((E18>=$Q$3:$Q$25)*(E49<=$T$3:$T$25),$Q$3:$Q$25,\"\"),1)","v":15},{"$f":"SMALL(IF((F18>=$Q$3:$Q$25)*(F49<=$T$3:$T$25),$Q$3:$Q$25,\"\"),1)","v":25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.15,15,30,13,null,{"$f":"SMALL(IF((E18>=$Q$3:$Q$25)*(E49<=$T$3:$T$25),$U$3:$U$25,\"\"),1)","v":6},{"$f":"SMALL(IF((F18>=$Q$3:$Q$25)*(F49<=$T$3:$T$25),$U$3:$U$25,\"\"),1)","v":10}]
[null,"Исходные параметры",null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.35,35,70,14,null,2.5000000000000001E-2,0.06]
[null,"Наименование","Обозна-","Размер-"," Трубопроводы",null,null,null,null,null,null,null,null,null,null,null,65,0.25,25,50,15,null,2.5,6]
[null,null,"чение","ность","1 - й","2 -й",null,null,null,null,null,null,null,null,null,null,65,0.5,50,100,16,null,5,12]
[null,"Исходные параметры",null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,0.4,40,80,17]
[null,"Диаметр трубопровода перед конфузором","D1","мм",20,40," ",null,null,null,null,null,null,null,null,null,80,0.4,40,80,18]
[null,"Диаметр трубопровода после диффузора","D2","мм",25,40,null,null,null,null,null,null,null,null,null,null,80,0.8,80,160,19]
[null,"Диаметр расходомера","Dy","мм",20,32,null,null,null,null,null,null,null,null,null,null,100,1.2,120,240,20]
[null,"Длина прямого участка до счетчика","L1","мм",{"$f":"5*E20","v":100},{"$f":"5*F20","v":160},null,null,null,null,null,null,null,null,null,null,125,1,100,200,21]
[null,"Длина прямого участка после счетчика","L2","мм",{"$f":"3*E20","v":60},{"$f":"3*F20","v":96},null,null,null,null,null,null,null,null,null,null,125,2,200,400,22]
[null,"Длина расходомера","L3","мм",{"$f":"IF(E20=15,110,IF(E20=20,130,IF(E20=25,160,IF(E20=32,180,IF(E20=40,200,IF(E20=50,220,IF(E20=65,260,IF(E20=80,300,IF(E20=100,360,IF(E20=125,420,IF(E20=150,500,IF(E20=200,500,\"ошибка\"))))))))))))","v":130},{"$f":"IF(F20=15,110,IF(F20=20,130,IF(F20=25,160,IF(F20=32,180,IF(F20=40,200,IF(F20=50,220,IF(F20=65,260,IF(F20=80,300,IF(F20=100,360,IF(F20=125,420,IF(F20=150,500,IF(F20=200,500,\"ошибка\"))))))))))))","v":180},null,null,null,null,null,null,null,null,null,null,150,1.5,150,300,23]
[null,"Длина сужения","L","мм",{"$f":"E21+E22+E23","v":290},{"$f":"F21+F23+F22","v":436},null,null,null,null,null,null,null,null,null,null,150,3,300,600,24]
[null,"Угол раскрытия конфузора","a","град",{"$f":"I78","v":0},{"$f":"K78","v":14.2},null,null,null,null,null,null,null,null,null,null,200,2,500,1000,25]
[null,"Угол раскрытия диффузора","a","град",{"$f":"J78","v":11.2},{"$f":"L78","v":14.2}]
[null,"Массовый расход воды","G","т / ч",3,10]
[null,"Максимальная температура воды","t1","град",150,150]
[null,"Температура воды","t","град",100,100]
[null,"Рабочее (избыточное) давление воды","P","кг / см2",10,10]
[null,"Ду косого фильтра","dу","мм",{"$f":"IF(E20=15,E18,IF(E20=20,E18,IF(E20=25,E18,IF(E32=32,E18,IF(E20=40,E18,0)))))","v":20},{"$f":"IF(F20=15,F18,IF(F20=20,F18,IF(F20=25,F18,IF(F20=32,F18,IF(F20=40,F18,0)))))","v":40}]
[null,"Эквивалентная шероховатость трубопр.","d","мм",0.5,0.5]
[null,"Допустимые потери напора (суммарные)","h","м в. ст.",5,10]
[]
[null,"Расчетные параметры"]
[null,"Диаметр расходомера","Dy","мм",{"$f":"E20","v":20},{"$f":"F20","v":32}]
[null,"Минимальный объемный расход","qi","м3 / ч",{"$f":"W14","v":2.5000000000000001E-2},0.06]
[null,"Максимальный объемный расход","qp","м3 / ч",2.5,6]
[null,"Предельный объемный расход","qs","м3 / ч",5,12]
[null,"Длина прямого участка до счетчика","L1","мм",{"$f":"E21","v":100},160]
[null,"Длина прямого участка после счетчика","L2","мм",60,96]
[null,"Длина расходомера","L3","мм",130,180]
[null,"Угол раскрытия конфузора","a","град",{"$f":"E25","v":0},{"$f":"F25","v":14.2}]
[null,"Угол раскрытия диффузора","a","град",{"$f":"E26","v":11.2},{"$f":"F26","v":14.2}]
[null,"Ду косого фильтра","dу","мм",{"$f":"E31","v":20},{"$f":"F31","v":40}]
[null,"Эквивалентная шероховатость трубопр.","d","мм",{"$f":"E32","v":0.5},{"$f":"F32","v":0.5}]
[null,"Потеря давления на счетчике","hсч","МПа",{"$f":"IF(E28=105,J129,IF(E28=150,J113,\"ошибка\"))","v":1.6620434755551788E-2},{"$f":"IF(F28=105,A129,IF(F28=150,A113,\"ошибка\"))","v":2.6819539134567447E-2}]
[null,"Эквивалентная шероховатость трубопр.","d","мм",0.5,0.5]
[null,"Объемный расход воды","Q","м3 / ч",{"$f":"(E27/E51)*1000","v":3.1288561685626206},{"$f":"(F27/F51)*1000","v":10.429520561875401}]
[null,"Скорость воды в сужении","v","м / с",{"$f":"скорость!B24","v":2.7665162525017197},{"$f":"скорость!D24","v":3.6022347037782803}]
[null,"Плотность воды","r","кг / м3",{"$f":"(E29*0.01)^5*(-0.0005625*E30-1.3864)+(E29*0.01)^4*(0.054517*E30+7.325)+(E29*0.01)^3*(-0.27408*E30-15.474)+(E29*0.01)^2*(0.52327*E30-5.0668)+(E29*0.01)*(-0.42067*E30-38.224)+0.16333*E30+1011.185","v":958.81684499999994},{"$f":"(F29*0.01)^5*(-0.0005625*F30-1.3864)+(F29*0.01)^4*(0.054517*F30+7.325)+(F29*0.01)^3*(-0.27408*F30-15.474)+(F29*0.01)^2*(0.52327*F30-5.0668)+(F29*0.01)*(-0.42067*F30-38.224)+0.16333*F30+1011.185","v":958.81684499999994}]
[null,"Кинематическая вязкость воды","n","м2 / с",{"$f":"0.00000178/(1+0.0337*E29+0.000221*E29^2)","v":2.7051671732522795E-7},{"$f":"0.00000178/(1+0.0337*F29+0.000221*F29^2)","v":2.7051671732522795E-7}]
[null,"Число Рейнолдса","Re",null,{"$f":"E20*E50/(E52*1000)","v":204535.69597147545},{"$f":"F20*F50/(F52*1000)","v":426116.03327390715}]
[null,"Коэффициент гидравлического трения","l",null,{"$f":"0.11*((68/E53)+(E48/E20))^0.25","v":4.3884588244519886E-2},{"$f":"0.11*((68/F53)+(F48/F20))^0.25","v":3.8989794779636662E-2}]
[null,"Коэффициент сопротивления конфузора","xk",null,{"$f":"IF(E25=\"ошибка\",\"ошибка\",(-0.0125*(E20/E18)^6+0.0224*(E20/E18)^5-0.00723*(E20/E18)^4+0.00444*(E20/E18)^2-0.00745)*((0.01745*E25)^3-2*PI()*(0.01745*E25)^2-10*0.01745*E25)+E58)","v":0},{"$f":"IF(F25=\"ошибка\",\"ошибка\",((-0.0125*(F20/F18)^6+0.0224*(F20/F18)^5-0.00723*(F20/F18)^4+0.00444*(F20/F18)^2-0.00745)*((0.01745*F25)^3-2*PI()*(0.01745*F25)^2-10*0.01745*F25)+F58))","v":3.3268421773818078E-2}]
[null,"Коффициент нерав. поля скоростей ","kд",null,{"$f":"-0.24*LOG10(E53)+2.869","v":1.5944154129078056},{"$f":"-0.24*LOG10(F53)+2.869","v":1.5179133098779465}]
[null,"Коэффициент сопротивления расширения","xрасш",null,{"$f":"IF(E25=\"ошибка\",\"ошибка\",(E56*3.2*(1-(E20/E19)^2)^2*(TAN(RADIANS(E25/2)))^1.25))","v":0},{"$f":"IF(F25=\"ошибка\",\"ошибка\",(F56*3.2*(1-(F20/F19)^2)^2*(TAN(RADIANS(F25/2)))^1.25))","v":4.6581161333502194E-2},null,null,"Коэффициент сопротивления трения","Коэффициент сопротивления трения"]
[null,"Коэффициент сопротивления трения","xтр",null,{"$f":"IF(E25=0,0,IF(E25=\"ошибка\",\"ошибка\",I58))","v":0},{"$f":"IF(F25=0,0,IF(F25=\"ошибка\",\"ошибка\",J58))","v":2.3280036214927465E-2},null,null,{"$f":"E54/(8*SIN(RADIANS(E25/2)))*(1-(E20/E19)^4)","v":{"$error":"#DIV/0!"}},{"$f":"F54/(8*SIN(RADIANS(F25/2)))*(1-(F20/F19)^4)","v":2.3280036214927465E-2}]
[null,"Потери напора на прямом участке","hl","м в. ст.",{"$f":"прямой!B24","v":0.30749861447106114},{"$f":"IF(F26=0,0,прямой!D24)","v":0.41099304344782583}]
[null,"Потери напора в конфузоре","hk","м в. ст.",{"$f":"IF(E55=\"ошибка\",\"ошибка\",(E55*E50^2/(2*9.81)))","v":0},{"$f":"IF(F55=\"ошибка\",\"ошибка\",(F55*F50^2/(2*9.81)))","v":2.2002762324989853E-2}]
[null,"Потери напора на диффузоре","hд","м в. ст.",{"$f":"IF(E26=0,0,IF(E26=\"ошибка\",\"ошибка\",IF(E25=\"ошибка\",\"ошибка\",диффузор!B24)))","v":0},{"$f":"IF(F26=0,0,IF(F26=\"ошибка\",\"ошибка\",IF(F25=\"ошибка\",\"ошибка\",диффузор!D24)))","v":4.7774135535671322E-2}]
[null,"Потери напора на счетчике","hсч","м в. ст.",{"$f":"E47*101.9744288922","v":1.6948593421374651},{"$f":"F47*101.9744288922","v":2.7349071863995231}]
[null,{"$f":"CONCATENATE(\"Потери напора на фильтре\",\" Ду\",E31)","v":"Потери напора на фильтре Ду20"},"hф","м в. ст.",{"$f":"фильтр!C6","v":0.26525823848649221},{"$f":"фильтр!F6","v":0.22104853207207686}]
[null,"Потери напора (суммарные)","h","м в. ст.",{"$f":"IF(E59=\"ошибка\",\"ошибка\",IF(E60=\"ошибка\",\"ошибка\",IF(E61=\"ошибка\",\"ошибка\",IF(E62=\"ошибка\",\"ошибка\",IF(E63=\"ошибка\",\"ошибка\",(E63+E61+E60+E59+E62))))))","v":2.2676161950950187},{"$f":"IF(F59=\"ошибка\",\"ошибка\",IF(F60=\"ошибка\",\"ошибка\",IF(F61=\"ошибка\",\"ошибка\",IF(F62=\"ошибка\",\"ошибка\",IF(F63=\"ошибка\",\"ошибка\",(F63+F61+F60+F59+F62))))))","v":3.436725659780087}]
[]
[null,"Подающий тр-д",{"$f":"E64","v":2.2676161950950187},"м в. ст."]
[null,"Обратныйй тр-д",{"$f":"F64","v":3.436725659780087},"м в. ст."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"конф прям","диф прям","конф обрат","диф обрат",null,"счетчик",null,null,null,"конф прям","диф прям","конф обрат","диф обрат"]
[null,null,"ввод","прям участок","вывод","угол1","угол2",null,{"$f":"IF(E18=15,I106,IF(E18=20,I79,IF(E18=25,I81,IF(E18=32,I84,IF(E18=40,I88,IF(E18=50,I92,IF(E18=65,I96,IF(E18=80,I100,IF(E18=100,I103,IF(E18=125,I105,IF(E18=150,R85,IF(E18=200,R89,IF(E18=250,R93,IF(E18=300,R94,IF(E18=350,R95,\"ошибка\")))))))))))))))","v":0},{"$f":"IF(E19=15,I106,IF(E19=20,I79,IF(E19=25,I81,IF(E19=32,I84,IF(E19=40,I88,IF(E19=50,I92,IF(E19=65,I96,IF(E19=80,I100,IF(E19=100,I103,IF(E19=125,I105,IF(E19=150,R85,IF(E19=200,R89,IF(E19=250,R93,IF(E19=300,R94,IF(E19=350,R95,\"ошибка\")))))))))))))))","v":11.2},{"$f":"IF(F18=15,K106,IF(F18=20,K79,IF(F18=25,K81,IF(F18=32,K84,IF(F18=40,K88,IF(F18=50,K92,IF(F18=65,K96,IF(F18=80,K100,IF(F18=100,K103,IF(F18=125,K105,IF(F18=150,R85,IF(F18=200,T89,IF(F18=250,T93,IF(F18=300,T94,IF(F18=350,T95,\"ошибка\")))))))))))))))","v":14.2},{"$f":"IF(F19=15,K106,IF(F19=20,K79,IF(F19=25,K81,IF(F19=32,K84,IF(F19=40,K88,IF(F19=50,K92,IF(F19=65,K96,IF(F19=80,K100,IF(F19=100,K103,IF(F19=125,K105,IF(F19=150,R85,IF(F19=200,T89,IF(F19=250,T93,IF(F19=300,T94,IF(F19=350,T95,\"ошибка\")))))))))))))))","v":14.2},"ввод","прям участок","вывод","угол1","угол2"]
[null,null,20,15,20,15,15,null,{"$f":"IF(E20=15,F79,IF(E20=20,F80,\"ошибка\"))","v":0},null,{"$f":"IF(F20=15,F79,IF(F20=20,F80,\"ошибка\"))","v":"ошибка"},null,80,80,80,0,0]
[null,null,20,20,20,0,0,null,null,null,null,null,100,80,100,22.6,22.6]
[null,null,25,15,25,22,22,null,{"$f":"IF(E20=15,F81,IF(E20=20,F82,IF(E20=25,F83,\"ошибка\")))","v":11.2},null,{"$f":"IF(F20=15,F81,IF(F20=20,F82,IF(F20=25,F83,\"ошибка\")))","v":"ошибка"},null,100,100,100,0,0]
[null,null,25,20,25,11.2,11.2,null,null,null,null,null,125,80,125,39,39]
[null,null,25,25,25,0,0,null,null,null,null,null,125,100,125,22.6,22.6]
[null,null,32,15,32,36.799999999999997,36.799999999999997,null,{"$f":"IF(E20=15,F84,IF(E20=20,F85,IF(E20=25,F86,IF(E20=32,F87,\"ошибка\"))))","v":26.4},null,{"$f":"IF(F20=15,F84,IF(F20=20,F85,IF(F20=25,F86,IF(F20=32,F87,\"ошибка\"))))","v":0},null,125,125,125,0,0]
[null,null,32,20,32,26.4,26.4,null,null,null,null,null,150,80,150,53.1,53.1,{"$f":"IF(E20=80,P85,IF(E20=100,P86,IF(E20=125,P87,IF(E20=150,P87,\"ошибка\"))))","v":"ошибка"},null,{"$f":"IF(F20=80,P85,IF(F20=100,P86,IF(F20=125,P87,IF(F20=150,P87,\"ошибка\"))))","v":"ошибка"}]
[null,null,32,25,32,15.6,15.6,null,null,null,null,null,150,100,150,39.6,39.6]
[null,null,32,32,32,0,0,null,null,null,null,null,150,125,150,20.399999999999999,20.399999999999999]
[null,null,40,20,40,34.799999999999997,34.799999999999997,null,{"$f":"IF(E20=20,F88,IF(E20=25,F89,IF(E20=32,F90,IF(E20=40,F91,\"ошибка\"))))","v":34.799999999999997},null,{"$f":"IF(F20=20,F88,IF(F20=25,F89,IF(F20=32,F90,IF(F20=40,F91,\"ошибка\"))))","v":14.2},null,150,150,150,0,0]
[null,null,40,25,40,26.4,26.4,null,null,null,null,null,200,100,200,66.8,66.8,{"$f":"IF(E20=100,P89,IF(E20=125,P90,IF(E20=150,P91,IF(E20=200,P92,\"ошибка\"))))","v":"ошибка"},null,{"$f":"IF(F20=100,P89,IF(F20=125,P90,IF(F20=150,P91,IF(F20=200,P92,\"ошибка\"))))","v":"ошибка"}]
[null,null,40,32,40,14.2,14.2,null,null,null,null,null,200,125,200,52.2,52.2]
[null,null,40,40,40,0,0,null,null,null,null,null,200,150,200,36.5,36.5]
[null,null,50,25,50,36.6,36.6,null,{"$f":"IF(E20=25,F92,IF(E20=32,F93,IF(E20=40,F94,IF(E20=50,F95,\"ошибка\"))))","v":"ошибка"},null,{"$f":"IF(F20=25,F92,IF(F20=32,F93,IF(F20=40,F94,IF(F20=50,F95,\"ошибка\"))))","v":26.6},null,200,200,200,0,0]
[null,null,50,32,50,26.6,26.6,null,null,null,null,null,250,200,250,31.3,31.3,{"$f":"IF(E20=200,P93,\"ошибка\")","v":"ошибка"},null,{"$f":"IF(F20=200,P93,\"ошибка\")","v":"ошибка"}]
[null,null,50,40,50,15,15,null,null,null,null,null,300,200,300,53.1,53.1,{"$f":"IF(E20=200,P94,\"ошибка\")","v":"ошибка"},null,{"$f":"IF(F20=200,P94,\"ошибка\")","v":"ошибка"}]
[null,null,50,50,50,0,0,null,null,null,null,null,350,200,200,48.5,48.5,{"$f":"IF(E20=200,P95,\"ошибка\")","v":"ошибка"},null,{"$f":"IF(F20=200,P95,\"ошибка\")","v":"ошибка"}]
[null,null,65,32,65,40.799999999999997,40.799999999999997,null,{"$f":"IF(E20=32,F96,IF(E20=40,F97,IF(E20=50,F98,IF(E20=65,F99,\"ошибка\"))))","v":"ошибка"},null,{"$f":"IF(F20=32,F96,IF(F20=40,F97,IF(F20=50,F98,IF(F20=65,F99,\"ошибка\"))))","v":40.799999999999997}]
[null,null,65,40,65,31.4,31.4]
[null,null,65,50,65,19.2,19.2]
[null,null,65,65,65,0,0]
[null,null,80,40,80,48.4,48.4,null,{"$f":"IF(E20=40,F100,IF(E20=50,F101,IF(E20=65,F102,IF(E20=80,P79,IF(E20=100,P80,\"ошибка\")))))","v":"ошибка"},null,{"$f":"IF(F20=40,F100,IF(F20=50,F101,IF(F20=65,F102,IF(F20=80,P79,IF(F20=100,P80,\"ошибка\")))))","v":"ошибка"}]
[null,null,80,50,80,37.200000000000003,37.200000000000003]
[null,null,80,65,80,19.2,19.2]
[null,null,100,50,100,52.2,52.2,null,{"$f":"IF(E20=50,F103,IF(E20=65,F104,IF(E20=80,P80,IF(E20=100,P81,\"ошибка\"))))","v":"ошибка"},null,{"$f":"IF(F20=50,F103,IF(F20=65,F104,IF(F20=80,P80,IF(F20=100,P81,\"ошибка\"))))","v":"ошибка"},null,null,"вычисление угла"]
[null,null,100,65,100,37.799999999999997,37.799999999999997,null,null,null,null,null,null,0.45]
[null,null,125,65,125,50.3,50.3,null,{"$f":"IF(E20=65,F105,IF(E20=80,P82,IF(E20=100,P83,IF(E20=125,P84,\"ошибка\"))))","v":"ошибка"},null,{"$f":"IF(F20=65,F105,IF(F20=80,P82,IF(F20=100,P83,IF(F20=125,P84,\"ошибка\"))))","v":"ошибка"},null,null,{"$f":"ATAN(N104)","v":0.42285392613294071},{"$f":"2*N105*57.2958","v":48.455507961855488}]
[null,null,15,15,15,0,0,null,{"$f":"IF(E20=15,0,\"ошибка\")","v":"ошибка"},null,{"$f":"IF(F20=15,0,\"ошибка\")","v":"ошибка"}]
[]
[]
[]
[]
[]
[null,"обратка",null,null,null,null,null,null,null,null,"подача"]
[{"$f":"IF(F20=200,B126,IF(F20=150,B125,IF(F20=125,B124,IF(F20=100,B123,IF(F20=80,B122,IF(F20=65,B115,IF(F20=50,B116,IF(F20=40,B117,IF(F20=32,B118,IF(F20=25,B119,IF(F20=20,B120,IF(F20=15,B121,\"Недопустимое значение параметра\"))))))))))))","v":2.6819539134567447E-2},null,"металл",null,null,null,null,null,null,{"$f":"IF(E20=200,K126,IF(E20=150,K125,IF(E20=125,K124,IF(E20=100,K123,IF(E20=80,K122,IF(E20=65,K115,IF(E20=50,K116,IF(E20=40,K117,IF(E20=32,K118,IF(E20=25,K119,IF(E20=20,K120,IF(E20=15,K121,\"Недопустимое значение параметра\"))))))))))))","v":1.6620434755551788E-2},null,"металл"]
["ду","металл",null,null,null,null,null,null,null,"ду","металл"]
[65,{"$f":"5.83333333333333E-06*F49*F49","v":6.3452024504506005E-4},null,null,null,null,null,null,null,65,{"$f":"5.83333333333333E-06*E49*E49","v":5.7106822054055407E-5}]
[50,{"$f":"0.0000119047619047619*F49*F49","v":1.2949392756021636E-3},null,null,null,null,null,null,null,50,{"$f":"0.0000119047619047619*E49*E49","v":1.1654453480419475E-4}]
[40,{"$f":"0.000074113*F49*F49","v":8.0616341007470685E-3},null,null,null,null,null,null,null,40,{"$f":"0.000074113*E49*E49","v":7.255470690672363E-4}]
[32,{"$f":"0.00024656*F49*F49","v":2.6819539134567447E-2},null,null,null,null,null,null,null,32,{"$f":"0.00024656*E49*E49","v":2.4137585221110703E-3}]
[25,{"$f":"0.00103607*F49*F49","v":0.11269840976294328},null,null,null,null,null,null,null,25,{"$f":"0.00103607*E49*E49","v":1.0142856878664896E-2}]
[20,{"$f":"0.00169774*F49*F49","v":0.18467149728390875},null,null,null,null,null,null,null,20,{"$f":"0.00169774*E49*E49","v":1.6620434755551788E-2}]
[15,{"$f":"0.00694906*F49*F49","v":0.75588330069134191},null,null,null,null,null,null,null,15,{"$f":"0.00694906*E49*E49","v":6.8029497062220778E-2}]
[80,{"$f":"2.65118040651432E-06*F49*F49","v":2.883818813485936E-4},null,null,null,null,null,null,null,80,{"$f":"2.65118040651432E-06*E49*E49","v":2.5954369321373426E-5}]
[100,{"$f":"8.00182898948331E-07*F49*F49","v":8.703981413512488E-5},null,null,null,null,null,null,null,100,{"$f":"8.00182898948331E-07*E49*E49","v":7.8335832721612396E-6}]
[125,{"$f":"3.49854227405247E-07*F49*F49","v":3.8055358303410448E-5},null,null,null,null,null,null,null,125,{"$f":"3.49854227405247E-07*E49*E49","v":3.4249822473069405E-6}]
[150,{"$f":"1.75415149186407E-07*F49*F49","v":1.9080765162235679E-5},null,null,null,null,null,null,null,150,{"$f":"1.75415149186407E-07*E49*E49","v":1.7172688646012113E-6}]
[200,{"$f":"4.15413009548564E-08*F49*F49","v":4.5186508219484718E-6},null,null,null,null,null,null,null,200,{"$f":"4.15413009548564E-08*E49*E49","v":4.0667857397536251E-7}]
[]
[]
[{"$f":"IF(F20=40,B130,IF(F20=32,B131,IF(F20=25,B132,IF(F20=20,B133,IF(F20=15,B134,\"Недопустимое значение параметра\")))))","v":3.3142188922594157E-2},"пластик",null,null,null,null,null,null,null,{"$f":"IF(E20=40,K130,IF(E20=32,K131,IF(E20=25,K132,IF(E20=20,K133,IF(E20=15,K134,\"Недопустимое значение параметра\")))))","v":1.7803877376836339E-2},"пластик"]
[40,{"$f":"0.00013797*F49*F49","v":1.500767283580577E-2},null,null,null,null,null,null,null,40,{"$f":"0.00013797*E49*E49","v":1.3506905552225195E-3}]
[32,{"$f":"0.000304686*F49*F49","v":3.3142188922594157E-2},null,null,null,null,null,null,null,32,{"$f":"0.000304686*E49*E49","v":2.9827970030334747E-3}]
[25,{"$f":"0.001290555*F49*F49","v":0.14037998997327908},null,null,null,null,null,null,null,25,{"$f":"0.001290555*E49*E49","v":1.263419909759512E-2}]
[20,{"$f":"0.001818626*F49*F49","v":0.19782085974262598},null,null,null,null,null,null,null,20,{"$f":"0.001818626*E49*E49","v":1.7803877376836339E-2}]
[15,{"$f":"0.00895472*F49*F49","v":0.97404876492169767},null,null,null,null,null,null,null,15,{"$f":"0.00895472*E49*E49","v":8.7664388842952801E-2}]

{"sheet":"скорость","index":2,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":true,"merged":[[3,0,3,4],[4,0,4,4]]}
[]
[]
[]
["расчет скорости в сужении",null,null,null,null,1,2,3,4]
["м/с",null,null,null,null,{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*ПОТЕРИ!E20^2)/4)","v":2.7665162525017197},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*ПОТЕРИ!F20^2)/4)","v":3.6022347037782803},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*ПОТЕРИ!#REF!^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*ПОТЕРИ!#REF!^2)/4)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,null,null,null,null,1,2,3,4]
[null,null,null,null,"условие:",{"$f":"IF(ПОТЕРИ!E24>0,1,0)","v":1},{"$f":"IF(ПОТЕРИ!F24>0,1,0)","v":1},{"$f":"IF(ПОТЕРИ!#REF!>0,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!>0,1,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"IF(F11=1,F5,0)","v":2.7665162525017197},{"$f":"IF(G11=1,G5,0)","v":3.6022347037782803},{"$f":"IF(H11=1,H5,0)","v":{"$error":"#REF!"}},{"$f":"IF(I11=1,I5,0)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1-й тр-д",null,"2-й тр-д"]
["м/с=",{"$f":"F12","v":2.7665162525017197},"м/с=",{"$f":"G12","v":3.6022347037782803}]
["3-й тр-д",null,"4-й тр-д"]
["м/с=",{"$f":"H12","v":{"$error":"#REF!"}},"м/с=",{"$f":"I12","v":{"$error":"#REF!"}}]

{"sheet":"диффузор","index":3,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":true,"merged":[[4,0,4,4],[5,0,5,4],[6,0,6,4],[13,0,13,4],[3,0,3,4],[10,0,10,4],[11,0,11,4],[12,0,12,4],[7,0,7,4],[8,0,8,4],[9,0,9,4]]}
[]
[]
[]
["расчет потерь на диффузоре",null,null,null,null,1,2,3,4]
["Площадь cечения трубопровода после диффузора (м2)",null,null,null,null,{"$f":"(PI()*ПОТЕРИ!E19^2)/4","v":490.87385212340519},{"$f":"(PI()*ПОТЕРИ!F19^2)/4","v":1256.6370614359173},{"$f":"(PI()*ПОТЕРИ!#REF!^2)/4","v":{"$error":"#REF!"}},{"$f":"(PI()*ПОТЕРИ!#REF!^2)/4","v":{"$error":"#REF!"}}]
["Площадь cечения сужения (м2)",null,null,null,null,{"$f":"(PI()*ПОТЕРИ!E20^2)/4","v":314.15926535897933},{"$f":"(PI()*ПОТЕРИ!F20^2)/4","v":804.24771931898704},{"$f":"(PI()*ПОТЕРИ!#REF!^2)/4","v":{"$error":"#REF!"}},{"$f":"(PI()*ПОТЕРИ!#REF!^2)/4","v":{"$error":"#REF!"}}]
["Отношение площадей",null,null,null,null,{"$f":"F5/F6","v":1.5625},{"$f":"G5/G6","v":1.5625},{"$f":"H5/H6","v":{"$error":"#REF!"}},{"$f":"I5/I6","v":{"$error":"#REF!"}}]
["Коэф.сопр. расширения",null,null,null,null,{"$f":"ПОТЕРИ!E57","v":0},{"$f":"ПОТЕРИ!F57","v":4.6581161333502194E-2},{"$f":"ПОТЕРИ!#REF!","v":{"$error":"#REF!"}},{"$f":"ПОТЕРИ!#REF!","v":{"$error":"#REF!"}}]
["Коэф.сопр. трения диффузора",null,null,null,null,{"$f":"ПОТЕРИ!E58/(8*SIN(RADIANS(ПОТЕРИ!E26/2)))*(1-1/диффузор!F7)^2","v":0},{"$f":"ПОТЕРИ!F58/(8*SIN(RADIANS(ПОТЕРИ!F26/2)))*(1-1/диффузор!G7)^2","v":3.0512304272354409E-3},{"$f":"ПОТЕРИ!#REF!/(8*SIN(RADIANS(ПОТЕРИ!#REF!/2)))*(1-1/диффузор!H7)^2","v":{"$error":"#REF!"}},{"$f":"ПОТЕРИ!#REF!/(8*SIN(RADIANS(ПОТЕРИ!#REF!/2)))*(1-1/диффузор!I7)^2","v":{"$error":"#REF!"}}]
["Коэф.сопр. суммарный ",null,null,null,null,{"$f":"F8+F9","v":0},{"$f":"G8+G9","v":4.9632391760737637E-2},{"$f":"H8+H9","v":{"$error":"#REF!"}},{"$f":"I8+I9","v":{"$error":"#REF!"}}]
["Коэф. сопротивления диффузора",null,null,null,null,{"$f":"F10*ПОТЕРИ!E56","v":0},{"$f":"G10*ПОТЕРИ!F56","v":7.5337668054700185E-2},{"$f":"H10*ПОТЕРИ!#REF!","v":{"$error":"#REF!"}},{"$f":"I10*ПОТЕРИ!#REF!","v":{"$error":"#REF!"}}]
["Динамический напор Па",null,null,null,null,{"$f":"(ПОТЕРИ!E51*ПОТЕРИ!E50^2)/2","v":3669.2061394142893},{"$f":"(ПОТЕРИ!F51*ПОТЕРИ!F50^2)/2","v":6220.849167572509},{"$f":"(ПОТЕРИ!#REF!*ПОТЕРИ!#REF!^2)/2","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*ПОТЕРИ!#REF!^2)/2","v":{"$error":"#REF!"}}]
["Потеря давления диффузором Па",null,null,null,null,{"$f":"F11*F12","v":0},{"$f":"G11*G12","v":468.66426960493567},{"$f":"H11*H12","v":{"$error":"#REF!"}},{"$f":"I11*I12","v":{"$error":"#REF!"}}]
["Потеря давления диффузором мм",null,null,null,null,{"$f":"F13/9.81","v":0},{"$f":"G13/9.81","v":47.77413553567132},{"$f":"H13/9.81","v":{"$error":"#REF!"}},{"$f":"I13/9.81","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,1,2,3,4]
[null,null,null,null,"условие:",{"$f":"IF(ПОТЕРИ!E24>0,1,0)","v":1},{"$f":"IF(ПОТЕРИ!F24>0,1,0)","v":1},{"$f":"IF(ПОТЕРИ!#REF!>0,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!>0,1,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"IF(F18=1,F14,0)","v":0},{"$f":"IF(G18=1,G14,0)","v":47.77413553567132},{"$f":"IF(H18=1,H14,0)","v":{"$error":"#REF!"}},{"$f":"IF(I18=1,I14,0)","v":{"$error":"#REF!"}}]
[]
[]
[]
["1-й тр-д",null,"2-й тр-д"]
["hм=",{"$f":"F19/1000","v":0},"hм=",{"$f":"G19/1000","v":4.7774135535671322E-2}]
["3-й тр-д",null,"4-й тр-д"]
["hм=",{"$f":"H19/1000","v":{"$error":"#REF!"}},"hм=",{"$f":"I19/1000","v":{"$error":"#REF!"}}]

{"sheet":"прямой","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":true,"merged":[[6,0,6,4],[5,0,5,4],[7,0,7,4],[3,0,3,4],[4,0,4,4]]}
[]
[]
[]
["расчет потерь прямого участка",null,null,null,null,1,2,3,4]
["коэффициент трения прямого участка",null,null,null,null,{"$f":"1/((2*LOG10((ПОТЕРИ!E20/2)/ПОТЕРИ!E48)+1.74)^2)","v":5.3040591788831866E-2},{"$f":"1/((2*LOG10((ПОТЕРИ!F20/2)/ПОТЕРИ!F48)+1.74)^2)","v":4.4315732495500963E-2},{"$f":"1/((2*LOG10((ПОТЕРИ!#REF!/2)/ПОТЕРИ!#REF!)+1.74)^2)","v":{"$error":"#REF!"}},{"$f":"1/((2*LOG10((ПОТЕРИ!#REF!/2)/ПОТЕРИ!#REF!)+1.74)^2)","v":{"$error":"#REF!"}}]
["коэффициент местного сопротивления",null,null,null,null,{"$f":"F5*ПОТЕРИ!E24/ПОТЕРИ!E20","v":0.76908858093806209},{"$f":"G5*ПОТЕРИ!F24/ПОТЕРИ!F20","v":0.60380185525120067},{"$f":"H5*ПОТЕРИ!#REF!/ПОТЕРИ!#REF!","v":{"$error":"#REF!"}},{"$f":"I5*ПОТЕРИ!#REF!/ПОТЕРИ!#REF!","v":{"$error":"#REF!"}}]
["потери участка (Па)",null,null,null,null,{"$f":"(F5+F6)*ПОТЕРИ!E51*ПОТЕРИ!E50^2/2","v":3016.56140796111},{"$f":"(G5+G6)*ПОТЕРИ!F51*ПОТЕРИ!F50^2/2","v":4031.8417562231716},{"$f":"(H5+H6)*ПОТЕРИ!#REF!*ПОТЕРИ!#REF!^2/2","v":{"$error":"#REF!"}},{"$f":"(I5+I6)*ПОТЕРИ!#REF!*ПОТЕРИ!#REF!^2/2","v":{"$error":"#REF!"}}]
["потери участка (мм)",null,null,null,null,{"$f":"F7/9.81","v":307.49861447106116},{"$f":"G7/9.81","v":410.99304344782581},{"$f":"H7/9.81","v":{"$error":"#REF!"}},{"$f":"I7/9.81","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,1,2,3,4]
[null,null,null,null,"условие:",{"$f":"IF(ПОТЕРИ!E24>0,1,0)","v":1},{"$f":"IF(ПОТЕРИ!F24>0,1,0)","v":1},{"$f":"IF(ПОТЕРИ!#REF!>0,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!>0,1,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"IF(F11=1,F8,0)","v":307.49861447106116},{"$f":"IF(G11=1,G8,0)","v":410.99304344782581},{"$f":"IF(H11=1,H8,0)","v":{"$error":"#REF!"}},{"$f":"IF(I11=1,I8,0)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1-й тр-д",null,"2-й тр-д"]
["hм=",{"$f":"F12/1000","v":0.30749861447106114},"hм=",{"$f":"G12/1000","v":0.41099304344782583}]
["3-й тр-д",null,"4-й тр-д"]
["hм=",{"$f":"H12/1000","v":{"$error":"#REF!"}},"hм=",{"$f":"I12/1000","v":{"$error":"#REF!"}}]

{"sheet":"отвод","index":5,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":true,"merged":[[69,0,69,10],[71,0,71,10],[19,0,19,10],[33,0,33,10],[58,0,58,10],[61,0,61,10],[65,0,65,10],[48,0,48,10],[50,0,50,10],[27,0,27,10],[29,0,29,10],[31,0,31,10],[52,0,52,10],[39,0,39,10],[42,0,42,10],[0,0,0,10],[3,0,3,10],[7,0,7,10],[9,0,9,10],[67,0,67,10],[46,0,46,10],[11,0,11,10],[13,0,13,10],[20,0,20,10],[23,0,23,10]]}
["1-й трубопровод Ду"]
[200,150,125,100,80,50,40,32,25,20,15]
[{"$f":"IF(ПОТЕРИ!#REF!=200,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=150,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=125,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=100,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=80,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=50,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=40,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=32,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=25,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=25,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=15,1,0)","v":{"$error":"#REF!"}}]
["Cкорость потока"]
[{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*A2^2)/4)","v":2.7665162525017196E-2},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*B2^2)/4)","v":4.9182511155586126E-2},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*C2^2)/4)","v":7.0822816064044031E-2},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*D2^2)/4)","v":0.11066065010006879},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*E2^2)/4)","v":0.17290726578135748},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*F2^2)/4)","v":0.44264260040027514},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*G2^2)/4)","v":0.69162906312542993},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*H2^2)/4)","v":1.0806704111334844},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*I2^2)/4)","v":1.7705704016011006},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*J2^2)/4)","v":2.7665162525017197},{"$f":"(ПОТЕРИ!E49*1000/3.6)/((PI()*K2^2)/4)","v":4.9182511155586131}]
[]
[]
["Коэффициент Ктр"]
[{"$f":"1/(4*LOG10(3.7*A2/ПОТЕРИ!E48)^2)","v":2.4874237486770666E-2},{"$f":"1/(4*LOG10(3.7*B2/ПОТЕРИ!E48)^2)","v":2.6957107444510676E-2},{"$f":"1/(4*LOG10(3.7*C2/ПОТЕРИ!E48)^2)","v":2.841555939249284E-2},{"$f":"1/(4*LOG10(3.7*D2/ПОТЕРИ!E48)^2)","v":3.0367480544962282E-2},{"$f":"1/(4*LOG10(3.7*E2/ПОТЕРИ!E48)^2)","v":3.252765521010674E-2},{"$f":"1/(4*LOG10(3.7*F2/ПОТЕРИ!E48)^2)","v":3.7903711892391292E-2},{"$f":"1/(4*LOG10(3.7*G2/ПОТЕРИ!E48)^2)","v":4.0934735039248625E-2},{"$f":"1/(4*LOG10(3.7*H2/ПОТЕРИ!E48)^2)","v":4.4344415677485663E-2},{"$f":"1/(4*LOG10(3.7*I2/ПОТЕРИ!E48)^2)","v":4.8637492191595917E-2},{"$f":"1/(4*LOG10(3.7*J2/ПОТЕРИ!E48)^2)","v":5.3078151547333113E-2},{"$f":"1/(4*LOG10(3.7*K2/ПОТЕРИ!E48)^2)","v":5.9760773975612184E-2}]
["Коэффициент К"]
[{"$f":"1.5705*A9+0.21","v":0.24906498997297333},{"$f":"1.5705*B9+0.21","v":0.25233613724160403},0.25462663602591001,0.25769212819586323,0.26108468250747263,0.26952777952700052,0.27428800137913995,0.27964290482149123,0.2863851814869014,0.29335923700508665,0.30385429552869891]
["Потери на отводе [Па]"]
[{"$f":"(A11*ПОТЕРИ!E51*A5^2)/2","v":9.1387079032199212E-2},{"$f":"(B11*ПОТЕРИ!E51*B5^2)/2","v":0.292621686190769},{"$f":"(C11*ПОТЕРИ!E51*C5^2)/2","v":0.61228817852968254},{"$f":"(D11*ПОТЕРИ!E51*D5^2)/2","v":1.5128408621679927},{"$f":"(E11*ПОТЕРИ!E51*E5^2)/2","v":3.7420840623572231},{"$f":"(F11*ПОТЕРИ!E51*F5^2)/2","v":25.317196374609182},{"$f":"(G11*ПОТЕРИ!E51*G5^2)/2","v":62.901201164250956},{"$f":"(H11*ПОТЕРИ!E51*H5^2)/2","v":156.56546985086999},{"$f":"(I11*ПОТЕРИ!E51*I5^2)/2","v":430.41024661463609},{"$f":"(J11*ПОТЕРИ!E51*J5^2)/2","v":1076.3955134729554},{"$f":"(K11*ПОТЕРИ!E51*K5^2)/2","v":3523.6473572861032}]
["Потери на отводе [м.в.ст.]"]
[{"$f":"A13/10000","v":9.1387079032199209E-6},{"$f":"B13/10000","v":2.9262168619076901E-5},6.1228817852968255E-5,1.5128408621679928E-4,3.7420840623572231E-4,2.5317196374609182E-3,6.2901201164250959E-3,1.5656546985086998E-2,4.304102466146361E-2,0.10763955134729554,0.35236473572861032]
[]
[{"$f":"IF(A3=1,A15,0)","v":{"$error":"#REF!"}},{"$f":"IF(B3=1,B15,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"A17+B17+C17+D17+E17+F17+G17+H17+I17+J17+K17","v":{"$error":"#REF!"}},"1-й трубопровод"]
[]
["2-й трубопровод Ду"]
[200,150,125,100,80,50,40,32,25,20,15]
[{"$f":"IF(ПОТЕРИ!#REF!=200,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=150,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=125,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=100,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=80,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=50,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=40,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=32,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=25,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=20,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=15,1,0)","v":{"$error":"#REF!"}}]
["Cкорость потока"]
[{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*A22^2)/4)","v":9.2217208416723984E-2},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*B22^2)/4)","v":0.16394170385195372},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*C22^2)/4)","v":0.23607605354681338},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*D22^2)/4)","v":0.36886883366689593},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*E22^2)/4)","v":0.57635755260452481},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*F22^2)/4)","v":1.4754753346675837},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*G22^2)/4)","v":2.3054302104180993},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*H22^2)/4)","v":3.6022347037782803},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*I22^2)/4)","v":5.901901338670335},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*J22^2)/4)","v":9.221720841672397},{"$f":"(ПОТЕРИ!F49*1000/3.6)/((PI()*K22^2)/4)","v":16.394170385195373}]
[]
[]
["Коэффициент Ктр"]
[{"$f":"1/(4*LOG10(3.7*A22/ПОТЕРИ!F48)^2)","v":2.4874237486770666E-2},{"$f":"1/(4*LOG10(3.7*B22/ПОТЕРИ!F48)^2)","v":2.6957107444510676E-2},{"$f":"1/(4*LOG10(3.7*C22/ПОТЕРИ!F48)^2)","v":2.841555939249284E-2},{"$f":"1/(4*LOG10(3.7*D22/ПОТЕРИ!F48)^2)","v":3.0367480544962282E-2},{"$f":"1/(4*LOG10(3.7*E22/ПОТЕРИ!F48)^2)","v":3.252765521010674E-2},{"$f":"1/(4*LOG10(3.7*F22/ПОТЕРИ!F48)^2)","v":3.7903711892391292E-2},{"$f":"1/(4*LOG10(3.7*G22/ПОТЕРИ!F48)^2)","v":4.0934735039248625E-2},{"$f":"1/(4*LOG10(3.7*H22/ПОТЕРИ!F48)^2)","v":4.4344415677485663E-2},{"$f":"1/(4*LOG10(3.7*I22/ПОТЕРИ!F48)^2)","v":4.8637492191595917E-2},{"$f":"1/(4*LOG10(3.7*J22/ПОТЕРИ!F48)^2)","v":5.3078151547333113E-2},{"$f":"1/(4*LOG10(3.7*K22/ПОТЕРИ!F48)^2)","v":5.9760773975612184E-2}]
["Коэффициент К"]
[{"$f":"1.5705*A29+0.21","v":0.24906498997297333},{"$f":"1.5705*B29+0.21","v":0.25233613724160403},0.25462663602591001,0.25769212819586323,0.26108468250747263,0.26952777952700052,0.27428800137913995,0.27964290482149123,0.2863851814869014,0.29335923700508665,0.30385429552869891]
["Потери на отводе [Па]"]
[{"$f":"(A31*ПОТЕРИ!F51*A25^2)/2","v":1.0154119892466578},{"$f":"(B31*ПОТЕРИ!F51*B25^2)/2","v":3.2513520687863213},{"$f":"(C31*ПОТЕРИ!F51*C25^2)/2","v":6.8032019836631372},{"$f":"(D31*ПОТЕРИ!F51*D25^2)/2","v":16.809342912977694},{"$f":"(E31*ПОТЕРИ!F51*E25^2)/2","v":41.578711803969128},{"$f":"(F31*ПОТЕРИ!F51*F25^2)/2","v":281.302181940102},{"$f":"(G31*ПОТЕРИ!F51*G25^2)/2","v":698.90223515834361},{"$f":"(H31*ПОТЕРИ!F51*H25^2)/2","v":1739.6163316763323},{"$f":"(I31*ПОТЕРИ!F51*I25^2)/2","v":4782.336073495956},{"$f":"(J31*ПОТЕРИ!F51*J25^2)/2","v":11959.9501496995},{"$f":"(K31*ПОТЕРИ!F51*K25^2)/2","v":39151.637303178904}]
["Потери на отводе [м.в.ст.]"]
[{"$f":"A33/10000","v":1.0154119892466577E-4},{"$f":"B33/10000","v":3.2513520687863211E-4},6.8032019836631371E-4,1.6809342912977694E-3,4.1578711803969132E-3,2.8130218194010199E-2,6.9890223515834363E-2,0.17396163316763322,0.47823360734959558,1.1959950149699501,3.9151637303178903]
[]
[{"$f":"IF(A23=1,A35,0)","v":{"$error":"#REF!"}},{"$f":"IF(B23=1,B35,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"A37+B37+C37+D37+E37+F37+G37+H37+I37+J37+K37","v":{"$error":"#REF!"}},"2-й трубопровод"]
["3-й трубопровод Ду"]
[200,150,125,100,80,50,40,32,25,20,15]
[{"$f":"IF(ПОТЕРИ!#REF!=200,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=150,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=125,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=100,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=80,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=50,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=40,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=32,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=25,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=20,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=15,1,0)","v":{"$error":"#REF!"}}]
["Cкорость потока"]
[{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*A41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*B41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*C41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*D41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*E41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*F41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*G41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*H41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*I41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*J41^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*K41^2)/4)","v":{"$error":"#REF!"}}]
[]
[]
["Коэффициент Ктр"]
[{"$f":"1/(4*LOG10(3.7*A41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*B41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*C41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*D41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*E41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*F41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*G41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*H41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*I41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*J41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*K41/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}}]
["Коэффициент К"]
[{"$f":"1.5705*A48+0.21","v":{"$error":"#REF!"}},{"$f":"1.5705*B48+0.21","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Потери на отводе [Па]"]
[{"$f":"(A50*ПОТЕРИ!#REF!*A44^2)/2","v":{"$error":"#REF!"}},{"$f":"(B50*ПОТЕРИ!#REF!*B44^2)/2","v":{"$error":"#REF!"}},{"$f":"(C50*ПОТЕРИ!#REF!*C44^2)/2","v":{"$error":"#REF!"}},{"$f":"(D50*ПОТЕРИ!#REF!*D44^2)/2","v":{"$error":"#REF!"}},{"$f":"(E50*ПОТЕРИ!#REF!*E44^2)/2","v":{"$error":"#REF!"}},{"$f":"(F50*ПОТЕРИ!#REF!*F44^2)/2","v":{"$error":"#REF!"}},{"$f":"(G50*ПОТЕРИ!#REF!*G44^2)/2","v":{"$error":"#REF!"}},{"$f":"(H50*ПОТЕРИ!#REF!*H44^2)/2","v":{"$error":"#REF!"}},{"$f":"(I50*ПОТЕРИ!#REF!*I44^2)/2","v":{"$error":"#REF!"}},{"$f":"(J50*ПОТЕРИ!#REF!*J44^2)/2","v":{"$error":"#REF!"}},{"$f":"(K50*ПОТЕРИ!#REF!*K44^2)/2","v":{"$error":"#REF!"}}]
["Потери на отводе [м.в.ст.]"]
[{"$f":"A52/10000","v":{"$error":"#REF!"}},{"$f":"B52/10000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"IF(A42=1,A54,0)","v":{"$error":"#REF!"}},{"$f":"IF(B42=1,B54,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"A56+B56+C56+D56+E56+F56+G56+H56+I56+J56+K56","v":{"$error":"#REF!"}},"3-й трубопровод"]
["4-й трубопровод Ду"]
[200,150,125,100,80,50,40,32,25,20,15]
[{"$f":"IF(ПОТЕРИ!#REF!=200,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=150,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=125,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=100,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=80,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=50,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=40,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=32,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=25,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=20,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(ПОТЕРИ!#REF!=15,1,0)","v":{"$error":"#REF!"}}]
["Cкорость потока"]
[{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*A60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*B60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*C60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*D60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*E60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*F60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*G60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*H60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*I60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*J60^2)/4)","v":{"$error":"#REF!"}},{"$f":"(ПОТЕРИ!#REF!*1000/3.6)/((PI()*K60^2)/4)","v":{"$error":"#REF!"}}]
[]
[]
["Коэффициент Ктр"]
[{"$f":"1/(4*LOG10(3.7*A60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*B60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*C60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*D60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*E60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*F60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*G60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*H60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*I60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*J60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}},{"$f":"1/(4*LOG10(3.7*K60/ПОТЕРИ!#REF!)^2)","v":{"$error":"#REF!"}}]
["Коэффициент К"]
[{"$f":"1.5705*A67+0.21","v":{"$error":"#REF!"}},{"$f":"1.5705*B67+0.21","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Потери на отводе [Па]"]
[{"$f":"(A69*ПОТЕРИ!#REF!*A63^2)/2","v":{"$error":"#REF!"}},{"$f":"(B69*ПОТЕРИ!#REF!*B63^2)/2","v":{"$error":"#REF!"}},{"$f":"(C69*ПОТЕРИ!#REF!*C63^2)/2","v":{"$error":"#REF!"}},{"$f":"(D69*ПОТЕРИ!#REF!*D63^2)/2","v":{"$error":"#REF!"}},{"$f":"(E69*ПОТЕРИ!#REF!*E63^2)/2","v":{"$error":"#REF!"}},{"$f":"(F69*ПОТЕРИ!#REF!*F63^2)/2","v":{"$error":"#REF!"}},{"$f":"(G69*ПОТЕРИ!#REF!*G63^2)/2","v":{"$error":"#REF!"}},{"$f":"(H69*ПОТЕРИ!#REF!*H63^2)/2","v":{"$error":"#REF!"}},{"$f":"(I69*ПОТЕРИ!#REF!*I63^2)/2","v":{"$error":"#REF!"}},{"$f":"(J69*ПОТЕРИ!#REF!*J63^2)/2","v":{"$error":"#REF!"}},{"$f":"(K69*ПОТЕРИ!#REF!*K63^2)/2","v":{"$error":"#REF!"}}]
["Потери на отводе [м.в.ст.]"]
[{"$f":"A71/10000","v":{"$error":"#REF!"}},{"$f":"B71/10000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"IF(A61=1,A73,0)","v":{"$error":"#REF!"}},{"$f":"IF(B61=1,B73,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"A75+B75+C75+D75+E75+F75+G75+H75+I75+J75+K75","v":{"$error":"#REF!"}},"4-й трубопровод"]

{"sheet":"фильтр","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,3,0,5],[6,0,6,2],[6,3,6,5]]}
["1-й трубопровод",null,null,"2-й трубопровод"]
[]
[]
[null,"True=",{"$f":"IF(ПОТЕРИ!E31>0,1,0)","v":1},null,"True=",{"$f":"IF(ПОТЕРИ!F31>0,1,0)","v":1}]
[{"$f":"(4*ПОТЕРИ!E27/((ПОТЕРИ!E30*3.6)*PI()*POWER(ПОТЕРИ!E31/1000,2)))/1000","v":0.26525823848649221},null,null,{"$f":"(4*ПОТЕРИ!F27/((ПОТЕРИ!F30*3.6)*PI()*POWER(ПОТЕРИ!F31/1000,2)))/1000","v":0.22104853207207686}]
[null,"Enter=",{"$f":"IF(C4>0,A5,0)","v":0.26525823848649221},null,"Enter=",{"$f":"IF(F4>0,D5,0)","v":0.22104853207207686}]
["3-й трубопровод",null,null,"4-й трубопровод"]
[]
[]
[null,"True=",{"$f":"IF(ПОТЕРИ!#REF!>0,1,0)","v":{"$error":"#REF!"}},null,"True=",{"$f":"IF(ПОТЕРИ!#REF!>0,1,0)","v":{"$error":"#REF!"}}]
[{"$f":"(4*ПОТЕРИ!#REF!/((ПОТЕРИ!#REF!*3.6)*PI()*POWER(ПОТЕРИ!#REF!/1000,2)))/1000","v":{"$error":"#REF!"}},null,null,{"$f":"(4*ПОТЕРИ!#REF!/((ПОТЕРИ!#REF!*3.6)*PI()*POWER(ПОТЕРИ!#REF!/1000,2)))/1000","v":{"$error":"#REF!"}}]
[null,"Enter=",{"$f":"IF(C10>0,A11,0)","v":{"$error":"#REF!"}},null,"Enter=",{"$f":"IF(F10>0,D11,0)","v":{"$error":"#REF!"}}]