{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["ИД","ГР_Предв","Остывание","Бачок"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":134,"n_cols":29,"rows_kept":134,"cut":false,"hidden":false,"merged":[[100,0,100,9],[101,0,101,9],[65,0,65,9],[66,0,66,9],[67,0,67,9],[97,10,97,15],[99,0,99,9],[33,10,33,15],[35,0,35,9],[36,0,36,9],[37,0,37,9],[63,10,63,15],[26,0,26,9],[27,0,27,9],[28,0,28,9],[29,0,29,9],[31,1,31,15],[19,19,19,23],[20,9,20,11],[23,13,23,17],[23,19,23,23],[24,13,24,17],[24,19,24,23],[14,20,15,20],[14,23,15,23],[14,26,15,26],[14,29,15,29],[15,2,16,2],[12,3,15,3],[12,4,15,4],[13,0,19,0],[13,1,19,1],[13,17,17,17],[14,14,15,14],[19,8,19,9],[19,13,19,17],[10,9,10,10],[10,11,10,15],[10,17,10,21],[10,23,10,27],[11,11,11,15],[11,17,11,21],[11,23,11,27],[0,0,0,28],[1,0,1,29],[2,0,2,29],[3,0,9,5],[3,9,3,11],[4,9,4,27],[5,9,5,27],[6,9,6,21],[7,9,7,21],[8,9,8,15],[9,9,9,15]]}
[]
["Расчет двухтрубной системы отопления с естественной циркуляцией \n(по «Справочник проектировщика: Внутренние санитарно-технические устройства. Часть 1. Отопление» (Староверов) 1975, переизд. 1990, с.115)"]
[]
["Все расстояния в метрах.",{"$nulls":8},"Расширительный бак"]
[{"$nulls":9},"Гор. расстояние от гл. стояка до ст. 3 (L)"]
[{"$nulls":9},{"$f":"J11+L11+R11+X11","v":13.83}]
[{"$nulls":9},"Гор. расстояние от гл. стояка до ст. 2 (L)"]
[{"$nulls":9},{"$f":"J11+L11+R11","v":9.86}]
[{"$nulls":9},"Гор. расстояние от гл. стояка до ст. 1 (L)"]
[{"$nulls":9},{"$f":"J11+L11","v":6.0600000000000005}]
[{"$nulls":9},1.87,null,4.1900000000000004,{"$nulls":5},3.8,{"$nulls":5},3.97]
[{"$nulls":8},4,5,5.0999999999999996,5.2,{"$nulls":4},6,17,{"$nulls":4},18,28,{"$nulls":4},29]
[null,null,null,"расстояние от усл. ЦН воды в котле до верхней гориз. трубы (hг)",{"$f":"H13+B14/2+0.1","v":2.2600000000000002},null,null,1.9,3,null,1.6,"Коэффициент изоляции (b):\n\n3,9 — при неизолированных трубах или изоляции только гл. стояка\n3,3 — при изолированном главном стояке и обратной магистрали\n1,6 — при всех изолированных трубах",null,1.79,null,null,7,"Высота отопительного прибора",null,1.75,null,null,19,null,null,1.7,null,null,30]
["Высота котла между соед. патрубками",0.52,{"$nulls":4},0,1,2,{"$nulls":5},10,9,8,0.5,null,null,22,21,20,null,null,null,33,32,31]
[{"$nulls":14},"Ось ЦО",{"$nulls":5},"Ось ЦО",{"$nulls":5},"Ось ЦО"]
[null,null,"Ось ЦН",{"$nulls":7},0.2,"Верт. расст. между ЦН и ЦО"]
[{"$nulls":15},0.75,{"$nulls":5},1,{"$nulls":5},0.1]
[{"$nulls":12},12,11,{"$nulls":4},24,23,{"$nulls":4},35,34]
[{"$nulls":12},13,0.1,"Выс. от ОП до лежака",null,null,null,25,{"$f":"N19","v":0.1},"Выс. от ОП до лежака",null,null,null,36,0.2,"Выс. от ОП до лежака"]
[{"$nulls":7},16,15,null,14.2,14.1,14,27,{"$nulls":4},26,38,{"$nulls":4},37]
[{"$nulls":7},0.1,{"$nulls":5},0.2,{"$nulls":5},{"$f":"N21","v":0.2},{"$nulls":5},0]
[]
[]
[{"$nulls":9},1.5,null,2.42,null,3.46,{"$nulls":5},6.26]
[]
[]
["Температура горячей воды (из котла)",{"$nulls":9},"tг",90,null,"°С"]
["Температура обратной воды",{"$nulls":9},"tо",70,null,"°С"]
["Средн. приращен. плотн. воды при понижении на 1 °С",{"$nulls":9},"β",0.64,null,null,"стр. 89"]
["Коэффициент изоляции труб",{"$nulls":9},"b",{"$f":"K13","v":1.6},null,null,"стр. 116"]
[]
[null,"Нагрузка на второй ветке",{"$nulls":15},3840,null,"Вт"]
[]
[{"$nulls":10},"Циркуляционное кольцо 1",{"$nulls":6},{"$f":"1320+150","v":1470},null,"Вт",{"$nulls":6},{"$f":"R34+R64+R98","v":3360}]
[]
["Располагаемое давление (для двухтрубной системы)",{"$nulls":9},1,"ΔPр=b▪hг▪(l+hг)±β▪g▪h1(tг-tо)",null,"=",{"$f":"(L30*E13*(J10+E13))+(L29*9.81*K16*(L27-L28))","v":55.198720000000009},"Па"]
["Длина кольца",{"$nulls":9},2,"Σl",null,"=",{"$f":"O62","v":14.92},"м"]
["Удельное располагаемое давление",{"$nulls":9},3,"ΔP1=ΔPр/Σl",null,"=",{"$f":"O36/O37","v":3.6996461126005369},"Па/м"]
[]
[{"$nulls":10},"Участки",null,null,null,"ДЛИНА",null,null,"КМС"]
[{"$nulls":10},1,"Линейный. Длина",null,null,{"$f":"H21","v":0.1},"м"]
[{"$nulls":10},2,"Сужение, Отвод. КМС",{"$nulls":5},{"$f":"0.5+1.2","v":1.7},"-"]
[{"$nulls":10},3,"Линейный. Длина",null,null,{"$f":"H13","v":1.9},"м"]
[{"$nulls":10},4,"Тройник на отв. (G=1). КМС",{"$nulls":5},2.2999999999999998,"-"]
[{"$nulls":10},5,"Линейный. Длина",null,null,{"$f":"J11","v":1.87},"м"]
[{"$nulls":10},5.0999999999999996,"Тр. на отв (G=0,5, d^=0,74). КМС",{"$nulls":5},2]
[{"$nulls":10},5.2,"Линейный. Длина",null,null,{"$f":"L11","v":4.1900000000000004},"м"]
[{"$nulls":10},6,"Тр. на отв (G=0,5, d^=0,74). КМС",{"$nulls":5},2]
[{"$nulls":10},7,"Линейный. Длина",null,null,{"$f":"N13","v":1.79},"м"]
[{"$nulls":10},8,"Отвод, арматура, расшир. КМС",{"$nulls":5},{"$f":"0.9+0.26+1","v":2.16}]
[{"$nulls":10},9,"Линейный. Длина",null,null,{"$f":"P17","v":0.75},"м"]
[{"$nulls":10},10,"Отопительный прибор. КМС",{"$nulls":5},1.5,"-"]
[{"$nulls":10},11,"Линейный. Длина",null,null,{"$f":"N21","v":0.2},"м"]
[{"$nulls":10},12,"Отвод и арматура. КМС",{"$nulls":5},{"$f":"0.9+0.26","v":1.1600000000000001}]
[{"$nulls":10},13,"Линейный. Длина",null,null,{"$f":"N19","v":0.1},"м"]
[{"$nulls":10},14,"Тройн. на слиян. КМС",{"$nulls":5},3]
[{"$nulls":10},14.1,"Линейный. Длина",null,null,{"$f":"L24","v":2.42},"м"]
[{"$nulls":10},14.2,"Тройн. на слиян. КМС",{"$nulls":5},3]
[{"$nulls":10},15,"Линейный. Длина",null,null,{"$f":"J24","v":1.5},"м"]
[{"$nulls":10},16,"Линейный. Длина",null,null,{"$f":"H21","v":0.1},"м"]
[{"$nulls":10},0,"Отвод, котел, арматура. КМС",{"$nulls":5},{"$f":"1.2+1+0.3","v":2.5}]
[{"$nulls":14},{"$f":"SUM(O41:O60)","v":14.92},"м"]
[]
[{"$nulls":10},"Циркуляционное кольцо 2",{"$nulls":6},{"$f":"1290+150","v":1440},null,"Вт"]
[]
["Располагаемое давление (для двухтрубной системы)",{"$nulls":9},1,"ΔPр=b▪hг▪(l+hг)±β▪g▪h1(tг-tо)",null,"=",{"$f":"(L30*E13*(J8+E13))+(L29*9.81*K16*(L27-L28))","v":68.939520000000002},"Па"]
["Длина кольца",{"$nulls":9},2,"Σl",null,"=",{"$f":"SUM(O71:O95)","v":21.200000000000003},"м"]
["Удельное располагаемое давление",{"$nulls":9},3,"ΔP1=ΔPр/Σl",null,"=",{"$f":"O66/O67","v":3.2518641509433959},"Па/м"]
[]
[{"$nulls":10},"Участки",null,null,null,"ДЛИНА",null,null,"КМС"]
[{"$nulls":10},1,"Линейный. Длина",null,null,{"$f":"O41","v":0.1},"м"]
[{"$nulls":10},2,"Сужение, Отвод. КМС",{"$nulls":5},{"$f":"R42","v":1.7},"-"]
[{"$nulls":10},3,"Линейный. Длина",null,null,{"$f":"O43","v":1.9},"м"]
[{"$nulls":10},4,"Тройник на отв. (G=1). КМС",{"$nulls":5},{"$f":"R44","v":2.2999999999999998},"-"]
[{"$nulls":10},5,"Линейный. Длина",null,null,{"$f":"O45","v":1.87},"м"]
[{"$nulls":10},5.0999999999999996,"Тр. на отв (G=0,5, d^=0,74). КМС",{"$nulls":5},2]
[{"$nulls":10},5.2,"Линейный. Длина",null,null,3,"м"]
[{"$nulls":10},6,"Тр. на проход (G=0,5, d^=0,74). КМС",{"$nulls":5},2]
[{"$nulls":10},17,"Линейный. Длина",null,null,{"$f":"R11","v":3.8},"м"]
[{"$nulls":10},18,"Тр. на отв (G=0,5, d^=0,74). КМС",{"$nulls":5},2]
[{"$nulls":10},19,"Линейный. Длина",null,null,{"$f":"T13","v":1.75},"м"]
[{"$nulls":10},20,"Отвод, арматура, расшир. КМС",{"$nulls":5},{"$f":"0.9+0.26+1","v":2.16}]
[{"$nulls":10},21,"Линейный. Длина",null,null,{"$f":"V17","v":1},"м"]
[{"$nulls":10},22,"Отопительный прибор. КМС",{"$nulls":5},1.5,"-"]
[{"$nulls":10},23,"Линейный. Длина",null,null,{"$f":"T21","v":0.2},"м"]
[{"$nulls":10},24,"Отвод и арматура. КМС",{"$nulls":5},{"$f":"0.9+0.26","v":1.1600000000000001}]
[{"$nulls":10},25,"Линейный. Длина",null,null,{"$f":"T19","v":0.1},"м"]
[{"$nulls":10},26,"Тр. на слияние. КМС",{"$nulls":5},3]
[{"$nulls":10},27,"Линейный. Длина",null,null,{"$f":"N24","v":3.46},"м"]
[{"$nulls":10},14,"Тройн. на проход. КМС",{"$nulls":5},2]
[{"$nulls":10},14.1,"Линейный. Длина",null,null,{"$f":"O57","v":2.42},"м"]
[{"$nulls":10},14.2,"Тройн. на проход. КМС",{"$nulls":5},{"$f":"R58","v":3}]
[{"$nulls":10},15,"Линейный. Длина",null,null,{"$f":"O59","v":1.5},"м"]
[{"$nulls":10},16,"Линейный. Длина",null,null,{"$f":"O60","v":0.1},"м"]
[{"$nulls":10},0,"Отвод, котел, арматура. КМС",{"$nulls":5},{"$f":"1.2+1+0.3","v":2.5}]
[{"$nulls":14},{"$f":"SUM(O71:O94)","v":21.200000000000003},"м"]
[]
[{"$nulls":10},"Циркуляционное кольцо 3",{"$nulls":6},{"$f":"400+50","v":450},null,"Вт"]
[]
["Располагаемое давление (для двухтрубной системы)",{"$nulls":9},1,"ΔPр=b▪hг▪(l+hг)±β▪g▪h1(tг-tо)",null,"=",{"$f":"(L30*E13*(J6+E13))+(L29*9.81*K16*(L27-L28))","v":83.295040000000014},"Па"]
["Длина кольца",{"$nulls":9},2,"Σl",null,"=",{"$f":"O134","v":31.570000000000007},"м"]
["Удельное располагаемое давление",{"$nulls":9},3,"ΔP1=ΔPр/Σl",null,"=",{"$f":"O100/O101","v":2.6384238200823567},"Па/м"]
[]
[{"$nulls":10},"Участки",null,null,null,"ДЛИНА",null,null,"КМС"]
[{"$nulls":10},1,"Линейный. Длина",null,null,{"$f":"O41","v":0.1},"м"]
[{"$nulls":10},2,"Сужение, Отвод. КМС",{"$nulls":5},{"$f":"R78","v":2},"-"]
[{"$nulls":10},3,"Линейный. Длина",null,null,{"$f":"O43","v":1.9},"м"]
[{"$nulls":10},4,"Тройник на отв. (G=1). КМС",{"$nulls":5},{"$f":"R80","v":2},"-"]
[{"$nulls":10},5,"Линейный. Длина",null,null,{"$f":"O45","v":1.87},"м"]
[{"$nulls":10},5.0999999999999996,"Тр. на отв (G=0,5, d^=0,74). КМС",{"$nulls":5},2]
[{"$nulls":10},5.2,"Линейный. Длина",null,null,{"$f":"O47","v":4.1900000000000004},"м"]
[{"$nulls":10},6,"Тр. на проход (G=0,5, d^=0,74). КМС",{"$nulls":5},2]
[{"$nulls":10},17,"Линейный. Длина",null,null,{"$f":"O79","v":3.8},"м"]
[{"$nulls":10},18,"Тр. на проход (G=0,5, d^=0,74). КМС",{"$nulls":5},2]
[{"$nulls":10},28,"Линейный. Длина",null,null,{"$f":"X11","v":3.97},"м"]
[{"$nulls":10},29,"Отвод. КМС",{"$nulls":5},0.9]
[{"$nulls":10},30,"Линейный. Длина",null,null,{"$f":"Z13","v":1.7},"м"]
[{"$nulls":10},31,"Отвод, арматура, расшир. КМС",{"$nulls":5},{"$f":"0.9+0.26+1","v":2.16}]
[{"$nulls":10},32,"Линейный. Длина",null,null,{"$f":"AB17","v":0.1},"м"]
[{"$nulls":10},33,"Отопительный прибор. КМС",{"$nulls":5},1.5,"-"]
[{"$nulls":10},34,"Линейный. Длина",null,null,{"$f":"Z21","v":0},"м"]
[{"$nulls":10},35,"Отвод и арматура. КМС",{"$nulls":5},{"$f":"0.9+0.26","v":1.1600000000000001}]
[{"$nulls":10},36,"Линейный. Длина",null,null,{"$f":"Z19","v":0.2},"м"]
[{"$nulls":10},37,"Отвод. КМС",{"$nulls":5},0.9]
[{"$nulls":10},38,"Линейный. Длина",null,null,{"$f":"T24","v":6.26},"м"]
[{"$nulls":10},26,"Тр. на проход. КМС",{"$nulls":5},2]
[{"$nulls":10},27,"Линейный. Длина",null,null,{"$f":"O89","v":3.46},"м"]
[{"$nulls":10},14,"Тройн. на проход. КМС",{"$nulls":5},2]
[{"$nulls":10},14.1,"Линейный. Длина",null,null,{"$f":"O57","v":2.42},"м"]
[{"$nulls":10},14.2,"Тройн. на проход. КМС",{"$nulls":5},{"$f":"R58","v":3}]
[{"$nulls":10},15,"Линейный. Длина",null,null,{"$f":"O59","v":1.5},"м"]
[{"$nulls":10},16,"Линейный. Длина",null,null,{"$f":"O60","v":0.1},"м"]
[{"$nulls":10},0,"Отвод, котел, арматура. КМС",{"$nulls":5},{"$f":"1.2+1+0.3","v":2.5}]
[{"$nulls":14},{"$f":"SUM(O105:O132)","v":31.570000000000007},"м"]

{"sheet":"ГР_Предв","index":1,"n_rows":59,"n_cols":24,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,"Труба","Дн","Т.ст","Двн",{"$nulls":5},"Поправочный коэффициент на мощность отопительного прибора","β1",null,1.06,"по табл 9.4 справочн. проектир том 1 (от 1,02 до 1,13)"]
[null,"Valtec PP-ALUX",20,3.4,13.2,20,{"$nulls":4},"Поправочный коэффициент на тип прибора и место установки","β2",null,1.1000000000000001,"по табл 9.5 справочн. проектир том 1 (от 1,02 до 1,1)"]
[null,"Valtec PP-ALUX",25,4.5,16.600000000000001,25]
[null,"Valtec PP-ALUX",32,5.4,21.2,32]
[null,"Valtec PP-ALUX",40,6.7,26.6,40,null,"tг","tо"]
[null,"Valtec PP-ALUX",50,8.3000000000000007,33.4,50,null,{"$f":"ИД!L27","v":90},{"$f":"ИД!L28","v":70},null,"удельная теплоемкость воды","с",null,4187,"Дж/ кг*град C"]
[null,"Valtec PP-ALUX",63,10.5,42,63]
[{"$nulls":10},"плотн. Воды",970,"кг/м"]
[{"$nulls":10},"объемн расх",{"$f":"K13/L8","v":0.37207360041759102},"м3/ч",{"$f":"L9/3600","v":1.0335377789377528E-4},"м3/с",{"$f":"N9*1000","v":0.10335377789377528},"л/с"]
[]
[{"$nulls":5},"Дн",null,"№ уч","Тепловая нагрузка, Вт","Температурный напор, °C","Расход воды на участке, кг/ч","Длина участка, м","Диаметр трубы, мм","Скорость воды на участке, м/с","Критерий Рейнольдса","Абс. эквив. шерох-ть, мм","Коэф. кинем. вязкости, м2/с","Коэф. гидр. трения","Удельные потери на трение, Па/м","Потери на трение, Па","Сумма КМС","Динамич. давление, Па","Потери на КМС, Па","Суммарные потери давления,Па"]
[{"$nulls":6},"ЦК1"]
[null,null,null,"Выход с котла",null,{"$f":"VLOOKUP(M13,$E$2:$F$7,2)","v":50},null,1,{"$f":"ИД!R34+ИД!R64+ИД!R98+ИД!R32","v":7200},20,{"$f":"I13*3600/($N$6*J13)*$N$1*$N$2","v":360.91139240506328},{"$f":"ИД!O41","v":0.1},40,{"$f":"(K13/$L$8/3600)/(PI()*(M13/1000)^2/4)","v":8.2246323195080975E-2},{"$f":"N13*(M13/1000)/Q13","v":10762.439653871372},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P13/M13+68/O13)^0.25*0.11","v":3.1315217685109094E-2},{"$f":"(R13*N13^2*$L$8)/((M13/1000)*2)","v":2.5684443850092213},{"$f":"S13*L13","v":0.25684443850092215},{"$f":"ИД!R42","v":1.7},{"$f":"N13^2*$L$8/2","v":3.2807619743682119},{"$f":"U13*V13","v":5.5772953564259602},{"$f":"W13+T13","v":5.8341397949268821}]
[null,null,null,"Гл. стояк",null,50,null,3,{"$f":"I13","v":7200},20,360.91139240506328,{"$f":"ИД!O43","v":1.9},{"$f":"M13","v":40},8.2246323195080975E-2,10762.439653871372,0.01,3.0567910563102129E-7,3.1315217685109094E-2,2.5684443850092213,4.8800443315175199,{"$f":"ИД!R44","v":2.2999999999999998},3.2807619743682119,7.5457525410468866,12.425796872564407]
[null,null,null,"Первый гор. кусок до разд",null,50,null,5,{"$f":"I13","v":7200},20,360.91139240506328,{"$f":"ИД!O45","v":1.87},40,8.2246323195080975E-2,10762.439653871372,0.01,3.0567910563102129E-7,3.1315217685109094E-2,2.5684443850092213,4.8029909999672444,{"$f":"ИД!R46","v":2},3.2807619743682119,6.5615239487364239,11.364514948703668]
[null,null,null,"Первый гор. кусок после разд.",null,50,null,5.2,{"$f":"ИД!R34+ИД!R64+ИД!R98","v":3360},20,168.42531645569622,{"$f":"ИД!O47","v":4.1900000000000004},40,3.8381617491037794E-2,5022.4718384733069,0.01,3.0567910563102129E-7,3.7694419524677683E-2,0.67329494365553522,2.8211058139166929,{"$f":"ИД!R48","v":2},0.71447705219574398,1.428954104391488,4.2500599183081809]
[null,null,null,"Стояк",null,25,null,7,{"$f":"ИД!R34","v":1470},20,73.686075949367094,{"$f":"ИД!O49","v":1.79},20,6.7167830609316137E-2,4394.6628586641436,0.01,3.0567910563102129E-7,3.9105824327053028E-2,4.2783452823593615,7.658238055423257,{"$f":"ИД!R50","v":2.16},2.1880859723494663,4.7262657002748476,12.384503755698105]
[null,null,null,"Вход в радиатор",null,25,null,9,{"$f":"I17","v":1470},20,73.686075949367094,{"$f":"ИД!O51","v":0.75},{"$f":"M17","v":20},6.7167830609316137E-2,4394.6628586641436,0.01,3.0567910563102129E-7,3.9105824327053028E-2,4.2783452823593615,3.2087589617695214,{"$f":"ИД!R52","v":1.5},2.1880859723494663,3.2821289585241997,6.4908879202937211]
[null,null,null,"РАДИАТОР"]
[null,null,null,"Выход с радиатора",null,{"$f":"VLOOKUP(M20,$E$2:$F$7,2)","v":25},null,11,{"$f":"I18","v":1470},20,{"$f":"I20*3600/($N$6*J20)*$N$1*$N$2","v":73.686075949367094},{"$f":"ИД!O53","v":0.2},20,{"$f":"(K20/$L$8/3600)/(PI()*(M20/1000)^2/4)","v":6.7167830609316137E-2},{"$f":"N20*(M20/1000)/Q20","v":4394.6628586641436},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P20/M20+68/O20)^0.25*0.11","v":3.9105824327053028E-2},{"$f":"(R20*N20^2*$L$8)/((M20/1000)*2)","v":4.2783452823593615},{"$f":"S20*L20","v":0.8556690564718723},{"$f":"ИД!R54","v":1.1600000000000001},{"$f":"N20^2*$L$8/2","v":2.1880859723494663},{"$f":"U20*V20","v":2.5381797279253813},{"$f":"W20+T20","v":3.3938487843972536}]
[null,null,null,"Верт. перемычка",null,{"$f":"VLOOKUP(M21,$E$2:$F$7,2)","v":25},null,13,{"$f":"I17","v":1470},20,{"$f":"I21*3600/($N$6*J21)*$N$1*$N$2","v":73.686075949367094},{"$f":"ИД!O55","v":0.1},{"$f":"M20","v":20},{"$f":"(K21/$L$8/3600)/(PI()*(M21/1000)^2/4)","v":6.7167830609316137E-2},{"$f":"N21*(M21/1000)/Q21","v":4394.6628586641436},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P21/M21+68/O21)^0.25*0.11","v":3.9105824327053028E-2},{"$f":"(R21*N21^2*$L$8)/((M21/1000)*2)","v":4.2783452823593615},{"$f":"S21*L21","v":0.42783452823593615},{"$f":"ИД!R56","v":3},{"$f":"N21^2*$L$8/2","v":2.1880859723494663},{"$f":"U21*V21","v":6.5642579170483994},{"$f":"W21+T21","v":6.9920924452843352}]
[null,null,null,"Первый лежак до слиян",null,{"$f":"VLOOKUP(M22,$E$2:$F$7,2)","v":50},null,14.1,{"$f":"I18","v":1470},20,{"$f":"I22*3600/($N$6*J22)*$N$1*$N$2","v":73.686075949367094},{"$f":"ИД!O57","v":2.42},{"$f":"M16","v":40},{"$f":"(K22/$L$8/3600)/(PI()*(M22/1000)^2/4)","v":1.6791957652329034E-2},{"$f":"N22*(M22/1000)/Q22","v":2197.3314293320718},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P22/M22+68/O22)^0.25*0.11","v":4.622954311705612E-2},{"$f":"(R22*N22^2*$L$8)/((M22/1000)*2)","v":0.15805346062899267},{"$f":"S22*L22","v":0.38248937472216227},{"$f":"ИД!R58","v":3},{"$f":"N22^2*$L$8/2","v":0.13675537327184165},{"$f":"U22*V22","v":0.41026611981552497},{"$f":"W22+T22","v":0.79275549453768723}]
[null,null,null,"Первый лежак после слиян",null,{"$f":"VLOOKUP(M23,$E$2:$F$7,2)","v":50},null,15,{"$f":"I13","v":7200},20,{"$f":"I23*3600/($N$6*J23)*$N$1*$N$2","v":360.91139240506328},{"$f":"ИД!O59","v":1.5},{"$f":"M14","v":40},{"$f":"(K23/$L$8/3600)/(PI()*(M23/1000)^2/4)","v":8.2246323195080975E-2},{"$f":"N23*(M23/1000)/Q23","v":10762.439653871372},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P23/M23+68/O23)^0.25*0.11","v":3.1315217685109094E-2},{"$f":"(R23*N23^2*$L$8)/((M23/1000)*2)","v":2.5684443850092213},{"$f":"S23*L23","v":3.852666577513832},0,{"$f":"N23^2*$L$8/2","v":3.2807619743682119},{"$f":"U23*V23","v":0},{"$f":"W23+T23","v":3.852666577513832}]
[null,null,null,"Вход в котел",null,{"$f":"VLOOKUP(M24,$E$2:$F$7,2)","v":50},null,16,{"$f":"I13","v":7200},20,{"$f":"I24*3600/($N$6*J24)*$N$1*$N$2","v":360.91139240506328},{"$f":"ИД!O60","v":0.1},{"$f":"M13","v":40},{"$f":"(K24/$L$8/3600)/(PI()*(M24/1000)^2/4)","v":8.2246323195080975E-2},{"$f":"N24*(M24/1000)/Q24","v":10762.439653871372},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P24/M24+68/O24)^0.25*0.11","v":3.1315217685109094E-2},{"$f":"(R24*N24^2*$L$8)/((M24/1000)*2)","v":2.5684443850092213},{"$f":"S24*L24","v":0.25684443850092215},{"$f":"ИД!R61","v":2.5},{"$f":"N24^2*$L$8/2","v":3.2807619743682119},{"$f":"U24*V24","v":8.2019049359205294},{"$f":"W24+T24","v":8.4587493744214513}]
[{"$nulls":23},{"$f":"SUM(X13:X24)","v":76.24001588664953}]
[{"$nulls":6},"ЦК2"]
[null,null,null,"Выход с котла",null,{"$f":"VLOOKUP(M27,$E$2:$F$7,2)","v":50},null,1,{"$f":"I13","v":7200},20,{"$f":"I27*3600/($N$6*J27)*$N$1*$N$2","v":360.91139240506328},{"$f":"L13","v":0.1},40,{"$f":"(K27/$L$8/3600)/(PI()*(M27/1000)^2/4)","v":8.2246323195080975E-2},{"$f":"N27*(M27/1000)/Q27","v":10762.439653871372},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P27/M27+68/O27)^0.25*0.11","v":3.1315217685109094E-2},{"$f":"(R27*N27^2*$L$8)/((M27/1000)*2)","v":2.5684443850092213},{"$f":"S27*L27","v":0.25684443850092215},{"$f":"U13","v":1.7},{"$f":"N27^2*$L$8/2","v":3.2807619743682119},{"$f":"U27*V27","v":5.5772953564259602},{"$f":"W27+T27","v":5.8341397949268821}]
[null,null,null,"Гл. стояк",null,50,null,3,{"$f":"I14","v":7200},20,360.91139240506328,1.9,40,8.2246323195080975E-2,10762.439653871372,0.01,3.0567910563102129E-7,3.1315217685109094E-2,2.5684443850092213,4.8800443315175199,{"$f":"U14","v":2.2999999999999998},3.2807619743682119,7.5457525410468866,12.425796872564407]
[null,null,null,"Первый гор. кусок до разд",null,50,null,5,{"$f":"I15","v":7200},20,360.91139240506328,1.87,40,8.2246323195080975E-2,10762.439653871372,0.01,3.0567910563102129E-7,3.1315217685109094E-2,2.5684443850092213,4.8029909999672444,{"$f":"U15","v":2},3.2807619743682119,6.5615239487364239,11.364514948703668]
[null,null,null,"Первый гор. кусок после разд.",null,50,null,5.2,{"$f":"I16","v":3360},20,168.42531645569622,4.1900000000000004,40,3.8381617491037794E-2,5022.4718384733069,0.01,3.0567910563102129E-7,3.7694419524677683E-2,0.67329494365553522,2.8211058139166929,{"$f":"U16","v":2},0.71447705219574398,1.428954104391488,4.2500599183081809]
[null,null,null,"Втор. гор. кусок",null,40,null,17,{"$f":"ИД!R64","v":1440},20,72.182278481012673,{"$f":"ИД!O79","v":3.8},32,2.5701975998462818E-2,2690.6099134678443,0.01,3.0567910563102129E-7,4.3993802662222123E-2,0.44046995508446496,1.6737858293209669,{"$f":"ИД!R80","v":2},0.32038691155939603,0.64077382311879205,2.3145596524397591]
[null,null,null,"Стояк",null,20,null,19,{"$f":"I31","v":1440},20,72.182278481012673,{"$f":"ИД!O81","v":1.75},15,0.11697254854411522,5739.9678153980676,0.01,3.0567910563102129E-7,3.6790586942206313E-2,16.27627805266048,28.483486592155842,{"$f":"ИД!R82","v":2.16},6.6360498997591151,14.33386778347969,42.817354375635531]
[null,null,null,"Вход в радиатор",null,20,null,21,{"$f":"I31","v":1440},20,72.182278481012673,{"$f":"ИД!O83","v":1},{"$f":"M32","v":15},0.11697254854411522,5739.9678153980676,0.01,3.0567910563102129E-7,3.6790586942206313E-2,16.27627805266048,16.27627805266048,{"$f":"ИД!R84","v":1.5},6.6360498997591151,9.9540748496386726,26.230352902299153]
[null,null,null,"РАДИАТОР"]
[null,null,null,"Выход с радиатора",null,{"$f":"VLOOKUP(M35,$E$2:$F$7,2)","v":20},null,23,{"$f":"I31","v":1440},20,{"$f":"I35*3600/($N$6*J35)*$N$1*$N$2","v":72.182278481012673},{"$f":"ИД!O85","v":0.2},15,{"$f":"(K35/$L$8/3600)/(PI()*(M35/1000)^2/4)","v":0.11697254854411522},{"$f":"N35*(M35/1000)/Q35","v":5739.9678153980676},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P35/M35+68/O35)^0.25*0.11","v":3.6790586942206313E-2},{"$f":"(R35*N35^2*$L$8)/((M35/1000)*2)","v":16.27627805266048},{"$f":"S35*L35","v":3.255255610532096},{"$f":"ИД!R86","v":1.1600000000000001},{"$f":"N35^2*$L$8/2","v":6.6360498997591151},{"$f":"U35*V35","v":7.6978178837205746},{"$f":"W35+T35","v":10.953073494252671}]
[null,null,null,"Верт. перемычка",null,20,null,25,{"$f":"I31","v":1440},20,72.182278481012673,{"$f":"ИД!O87","v":0.1},{"$f":"M35","v":15},0.11697254854411522,5739.9678153980676,0.01,3.0567910563102129E-7,3.6790586942206313E-2,16.27627805266048,1.627627805266048,{"$f":"ИД!R88","v":3},6.6360498997591151,19.908149699277345,21.535777504543393]
[null,null,null,"Втор. лежак",null,40,null,27,{"$f":"I31","v":1440},20,72.182278481012673,{"$f":"ИД!O89","v":3.46},{"$f":"M31","v":32},2.5701975998462818E-2,2690.6099134678443,0.01,3.0567910563102129E-7,4.3993802662222123E-2,0.44046995508446496,1.5240260445922487,{"$f":"ИД!R90","v":2},0.32038691155939603,0.64077382311879205,2.1647998677110407]
[null,null,null,"Первый лежак до слиян",null,50,null,14.1,{"$f":"I22","v":1470},20,73.686075949367094,{"$f":"L22","v":2.42},40,1.6791957652329034E-2,2197.3314293320718,0.01,3.0567910563102129E-7,4.622954311705612E-2,0.15805346062899267,0.38248937472216227,{"$f":"U22","v":3},0.13675537327184165,0.41026611981552497,0.79275549453768723]
[null,null,null,"Первый лежак после слиян",null,50,null,15,{"$f":"I23","v":7200},20,360.91139240506328,1.5,40,8.2246323195080975E-2,10762.439653871372,0.01,3.0567910563102129E-7,3.1315217685109094E-2,2.5684443850092213,3.852666577513832,{"$f":"U23","v":0},3.2807619743682119,0,3.852666577513832]
[null,null,null,"Вход в котел",null,50,null,16,{"$f":"I24","v":7200},20,360.91139240506328,0.1,40,8.2246323195080975E-2,10762.439653871372,0.01,3.0567910563102129E-7,3.1315217685109094E-2,2.5684443850092213,0.25684443850092215,{"$f":"U24","v":2.5},3.2807619743682119,8.2019049359205294,8.4587493744214513]
[{"$nulls":23},{"$f":"SUM(X27:X40)","v":152.99460077785767}]
[{"$nulls":6},"ЦК3"]
[null,null,null,"Выход с котла",null,{"$f":"VLOOKUP(M43,$E$2:$F$7,2)","v":50},null,1,{"$f":"I13","v":7200},20,{"$f":"I43*3600/($N$6*J43)*$N$1*$N$2","v":360.91139240506328},{"$f":"L13","v":0.1},{"$f":"M13","v":40},{"$f":"(K43/$L$8/3600)/(PI()*(M43/1000)^2/4)","v":8.2246323195080975E-2},{"$f":"N43*(M43/1000)/Q43","v":10762.439653871372},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P43/M43+68/O43)^0.25*0.11","v":3.1315217685109094E-2},{"$f":"(R43*N43^2*$L$8)/((M43/1000)*2)","v":2.5684443850092213},{"$f":"S43*L43","v":0.25684443850092215},{"$f":"U13","v":1.7},{"$f":"N43^2*$L$8/2","v":3.2807619743682119},{"$f":"U43*V43","v":5.5772953564259602},{"$f":"W43+T43","v":5.8341397949268821}]
[null,null,null,"Гл. стояк",null,50,null,3,{"$f":"I14","v":7200},20,360.91139240506328,{"$f":"L14","v":1.9},{"$f":"M14","v":40},8.2246323195080975E-2,10762.439653871372,0.01,3.0567910563102129E-7,3.1315217685109094E-2,2.5684443850092213,4.8800443315175199,{"$f":"U14","v":2.2999999999999998},3.2807619743682119,7.5457525410468866,12.425796872564407]
[null,null,null,"Первый гор. кусок до разд",null,50,null,5,{"$f":"I31","v":1440},20,72.182278481012673,{"$f":"L31","v":3.8},{"$f":"M15","v":40},1.6449264639016203E-2,2152.4879307742754,0.01,3.0567910563102129E-7,4.6466563407206708E-2,0.15244573430593331,0.57929379036254658,{"$f":"U15","v":2},0.13123047897472859,0.26246095794945717,0.84175474831200381]
[null,null,null,"Первый гор. кусок после разд.",null,50,null,5.2,{"$f":"I32","v":1440},20,72.182278481012673,{"$f":"L32","v":1.75},{"$f":"M16","v":40},1.6449264639016203E-2,2152.4879307742754,0.01,3.0567910563102129E-7,4.6466563407206708E-2,0.15244573430593331,0.26678003503538328,{"$f":"U16","v":2},0.13123047897472859,0.26246095794945717,0.52924099298484051]
[null,null,null,"Втор. гор. кусок",null,40,null,17,{"$f":"I31","v":1440},20,72.182278481012673,{"$f":"L31","v":3.8},{"$f":"M31","v":32},2.5701975998462818E-2,2690.6099134678443,0.01,3.0567910563102129E-7,4.3993802662222123E-2,0.44046995508446496,1.6737858293209669,{"$f":"U31","v":2},0.32038691155939603,0.64077382311879205,2.3145596524397591]
[null,null,null,"Третий гор. кусок",null,{"$error":"#N/A"},null,28,{"$f":"ИД!R98","v":450},20,22.556962025316455,{"$f":"ИД!O115","v":3.97},10,8.2246323195080975E-2,2690.6099134678429,0.01,3.0567910563102129E-7,4.4286405558947084E-2,14.529315533924258,57.681382669679309,{"$f":"ИД!R116","v":0.9},3.2807619743682119,2.952685776931391,60.634068446610698]
[null,null,null,"Стояк",null,{"$error":"#N/A"},null,30,{"$f":"I48","v":450},20,22.556962025316455,{"$f":"ИД!O117","v":1.7},10,8.2246323195080975E-2,2690.6099134678429,0.01,3.0567910563102129E-7,4.4286405558947084E-2,14.529315533924258,24.699836407671238,{"$f":"ИД!R118","v":2.16},3.2807619743682119,7.0864458646353379,31.786282272306575]
[null,null,null,"Вход в радиатор",null,{"$error":"#N/A"},null,32,{"$f":"I48","v":450},20,22.556962025316455,{"$f":"ИД!O119","v":0.1},{"$f":"M49","v":10},8.2246323195080975E-2,2690.6099134678429,0.01,3.0567910563102129E-7,4.4286405558947084E-2,14.529315533924258,1.4529315533924259,{"$f":"ИД!R120","v":1.5},3.2807619743682119,4.9211429615523183,6.374074514944744]
[null,null,null,"РАДИАТОР"]
[null,null,null,"Выход с радиатора",null,{"$f":"VLOOKUP(M52,$E$2:$F$7,2)","v":{"$error":"#N/A"}},null,34,{"$f":"I48","v":450},20,{"$f":"I52*3600/($N$6*J52)*$N$1*$N$2","v":22.556962025316455},{"$f":"ИД!O121","v":0},{"$f":"M49","v":10},{"$f":"(K52/$L$8/3600)/(PI()*(M52/1000)^2/4)","v":8.2246323195080975E-2},{"$f":"N52*(M52/1000)/Q52","v":2690.6099134678429},0.01,{"$f":"(1.78*10^(-6))/(1+0.0337*$H$6+0.000221*$H$6^2)","v":3.0567910563102129E-7},{"$f":"(P52/M52+68/O52)^0.25*0.11","v":4.4286405558947084E-2},{"$f":"(R52*N52^2*$L$8)/((M52/1000)*2)","v":14.529315533924258},{"$f":"S52*L52","v":0},{"$f":"ИД!R122","v":1.1600000000000001},{"$f":"N52^2*$L$8/2","v":3.2807619743682119},{"$f":"U52*V52","v":3.8056838902671264},{"$f":"W52+T52","v":3.8056838902671264}]
[null,null,null,"Верт. перемычка",null,{"$error":"#N/A"},null,36,{"$f":"I48","v":450},20,22.556962025316455,{"$f":"ИД!O123","v":0.2},{"$f":"M49","v":10},8.2246323195080975E-2,2690.6099134678429,0.01,3.0567910563102129E-7,4.4286405558947084E-2,14.529315533924258,2.9058631067848517,{"$f":"ИД!R124","v":0.9},3.2807619743682119,2.952685776931391,5.8585488837162423]
[null,null,null,"Третий лежак",null,{"$error":"#N/A"},null,38,{"$f":"I48","v":450},20,22.556962025316455,{"$f":"ИД!O125","v":6.26},{"$f":"M48","v":10},8.2246323195080975E-2,2690.6099134678429,0.01,3.0567910563102129E-7,4.4286405558947084E-2,14.529315533924258,90.953515242365853,{"$f":"ИД!R126","v":2},3.2807619743682119,6.5615239487364239,97.515039191102275]
[null,null,null,"Втор. лежак",null,40,null,27,{"$f":"I37","v":1440},20,72.182278481012673,{"$f":"L37","v":3.46},{"$f":"M37","v":32},2.5701975998462818E-2,2690.6099134678443,0.01,3.0567910563102129E-7,4.3993802662222123E-2,0.44046995508446496,1.5240260445922487,{"$f":"U37","v":2},0.32038691155939603,0.64077382311879205,2.1647998677110407]
[null,null,null,"Первый лежак до слиян",null,50,null,14.1,{"$f":"I22","v":1470},20,73.686075949367094,{"$f":"L22","v":2.42},40,1.6791957652329034E-2,2197.3314293320718,0.01,3.0567910563102129E-7,4.622954311705612E-2,0.15805346062899267,0.38248937472216227,{"$f":"U22","v":3},0.13675537327184165,0.41026611981552497,0.79275549453768723]
[null,null,null,"Первый лежак после слиян",null,50,null,15,{"$f":"I23","v":7200},20,360.91139240506328,1.5,40,8.2246323195080975E-2,10762.439653871372,0.01,3.0567910563102129E-7,3.1315217685109094E-2,2.5684443850092213,3.852666577513832,{"$f":"U23","v":0},3.2807619743682119,0,3.852666577513832]
[null,null,null,"Вход в котел",null,50,null,16,{"$f":"I24","v":7200},20,360.91139240506328,0.1,40,8.2246323195080975E-2,10762.439653871372,0.01,3.0567910563102129E-7,3.1315217685109094E-2,2.5684443850092213,0.25684443850092215,{"$f":"U24","v":2.5},3.2807619743682119,8.2019049359205294,8.4587493744214513]
[{"$nulls":23},{"$f":"SUM(X43:X58)","v":243.18816057435956}]

{"sheet":"Остывание","index":2,"n_rows":62,"n_cols":42,"rows_kept":62,"cut":false,"hidden":false,"merged":[[27,1,27,9],[27,12,27,13],[43,1,43,9],[43,12,43,13],[61,1,61,9],[61,12,61,13]]}
[{"$nulls":19},"Теплоотд. ППР Гор dT 70 гр",null,"По формуле",{"$nulls":4},"Теплоотд. Сталь Гор dT 70 гр"]
[{"$nulls":16},"Ду","Днар","Тст",null,null,0.2,null,"Ду","Днар","Тст"]
[{"$nulls":16},{"$f":"R3-S3*2","v":13.2},20,3.4,55.9,null,{"$f":"(3.14*70)/((1/14*R3)+(1.15/$V$2)+LOG10(R3/Q3)+(1/1000*Q3))","v":29.814598126254367},null,10,17,{"$f":"(Y3-X3)/2","v":3.5},63]
[{"$nulls":23},15,21.3,3.1500000000000004,77]
[{"$nulls":23},20,26.8,3.4000000000000004,93]
[{"$nulls":16},16.600000000000001,25,4.2,66.400000000000006,null,28.434132309108126,null,25,33.5,{"$f":"(Y6-X6)/2","v":4.25},113]
[{"$nulls":16},21.2,32,5.4,78.900000000000006,null,26.68859258606928,null,32,42.3,5.1499999999999986,138]
[{"$nulls":16},26.6,40,6.7,91.6,null,24.946313185123238,null,40,48,4,155]
[{"$nulls":16},33.4,50,8.3000000000000007,105.3,null,23.063882283865848,null,50,60,5,187]
[{"$nulls":16},42,63,10.5,119.4,null,20.997142130362743,null,65,75.5,5.25,200]
[]
[{"$nulls":25},"ППР — 0,2, Сталь — 50 — уменьшено для соотв. эмпирическим"]
[{"$nulls":8},{"$f":"ИД!L27","v":90}]
[null,null,null,"d","Тип Тр.","q","l","G","tн","Q","Δt","dn",null,"hi","hi*dt",{"$nulls":8},"Тизол","Кизол","Ктр","dтр1","dтр2","Rтр","d1","d2","Rизол","a","Rто","R","Tв","q","Q","Gм","Tг_нач","dТ","Tг_кон"]
[null,null,"ЦК1"]
[null,null,{"$f":"ГР_Предв!H13","v":1},{"$f":"ГР_Предв!M13","v":40},"СТАЛЬ",{"$f":"IF(E16=\"ППР\",VLOOKUP(D16,$Q$3:$T$10,4),VLOOKUP(D16,$X$3:$AA$10,4))","v":155},{"$f":"ГР_Предв!L13","v":0.1},{"$f":"ГР_Предв!K13/3600","v":0.10025316455696202},{"$f":"I13","v":90},{"$f":"(F16*G16)","v":15.5},{"$f":"J16/(H16*4187)","v":3.6925862397560509E-2},{"$f":"ГР_Предв!F13","v":50},null,{"$f":"ИД!B14/2","v":0.26},{"$f":"N16*K16","v":9.6007242233657319E-3},{"$nulls":8},0,3.5999999999999997E-2,{"$f":"IF(E16=\"ППР\",0.12,58)","v":58},{"$f":"D16/1000","v":0.04},{"$f":"AD16","v":0.05},{"$f":"1/(2*PI()*Z16)*LN(AB16/AA16)","v":6.1231722777131865E-4},{"$f":"L16/1000","v":0.05},{"$f":"AD16+X16/1000","v":0.05},{"$f":"1/(2*PI()*Y16)*LN(AE16/AD16)","v":0},{"$f":"10.3+0.052*(AN16-AJ16)","v":13.940000000000001},{"$f":"1/AG16","v":7.1736011477761832E-2},{"$f":"AH16+AF16+AC16","v":7.2348328705533149E-2},20,{"$f":"(AN16-AJ16)/AI16","v":967.54135516950032},{"$f":"AK16*G16","v":96.754135516950043},{"$f":"H16","v":0.10025316455696202},90,{"$f":"AL16/(AM16*4187)","v":0.23049870287056901},{"$f":"AN16-AO16","v":89.769501297129437}]
[null,null,{"$f":"ГР_Предв!H14","v":3},{"$f":"ГР_Предв!M14","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L14","v":1.9},{"$f":"ГР_Предв!K14/3600","v":0.10025316455696202},{"$f":"I16-K16","v":89.963074137602433},294.5,0.70159138555364975,{"$f":"ГР_Предв!F14","v":50},null,{"$f":"ИД!B14/2+ИД!H13/2","v":1.21},0.84892557651991618,{"$nulls":8},0,3.5999999999999997E-2,{"$f":"IF(E17=\"ППР\",0.12,58)","v":58},{"$f":"D17/1000","v":0.04},{"$f":"AD17","v":0.05},{"$f":"1/(2*PI()*Z17)*LN(AB17/AA17)","v":6.1231722777131865E-4},{"$f":"L17/1000","v":0.05},{"$f":"AD17+X17/1000","v":0.05},{"$f":"1/(2*PI()*Y17)*LN(AE17/AD17)","v":0},{"$f":"10.3+0.052*(AN17-AJ17)","v":13.938079855155326},{"$f":"1/AG17","v":7.1745894010653594E-2},{"$f":"AH17+AF17+AC17","v":7.235821123842491E-2},20,{"$f":"(AN17-AJ17)/AI17","v":966.89889012139417},{"$f":"AK17*G17","v":1837.1078912306489},0.10025316455696202,89.963074137602433,{"$f":"AL17/(AM17*4187)","v":4.3765673032939034},{"$f":"AN17-AO17","v":85.586506834308523}]
[null,null,{"$f":"ГР_Предв!H15","v":5},{"$f":"ГР_Предв!M15","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L15","v":1.87},{"$f":"ГР_Предв!K15/3600","v":0.10025316455696202},{"$f":"I17-K17","v":89.261482752048778},289.85000000000002,0.69051362683438167,{"$f":"ГР_Предв!F15","v":50},null,{"$f":"ИД!B14/2+ИД!H13","v":2.16},1.4915094339622645,{"$nulls":8},0,3.5999999999999997E-2,{"$f":"IF(E18=\"ППР\",0.12,58)","v":58},{"$f":"D18/1000","v":0.04},{"$f":"AD18","v":0.05},{"$f":"1/(2*PI()*Z18)*LN(AB18/AA18)","v":6.1231722777131865E-4},{"$f":"L18/1000","v":0.05},{"$f":"AD18+X18/1000","v":0.05},{"$f":"1/(2*PI()*Y18)*LN(AE18/AD18)","v":0},{"$f":"10.3+0.052*(AN18-AJ18)","v":13.901597103106537},{"$f":"1/AG18","v":7.193418084146129E-2},{"$f":"AH18+AF18+AC18","v":7.2546498069232607E-2},20,{"$f":"(AN18-AJ18)/AI18","v":954.71848532166405},{"$f":"AK18*G18","v":1785.3235675515118},0.10025316455696202,89.261482752048778,{"$f":"AL18/(AM18*4187)","v":4.2532007993889644},{"$f":"AN18-AO18","v":85.008281952659814}]
[null,null,{"$f":"ГР_Предв!H16","v":5.2},{"$f":"ГР_Предв!M16","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L16","v":4.1900000000000004},{"$f":"ГР_Предв!K16/3600","v":4.6784810126582282E-2},{"$f":"I18-K18","v":88.57096912521439},649.45000000000005,3.3154149309809688,{"$f":"ГР_Предв!F16","v":50},null,{"$f":"ИД!B14/2+ИД!H13","v":2.16},7.1612962509188929]
[null,null,{"$f":"ГР_Предв!H17","v":7},{"$f":"ГР_Предв!M17","v":20},"СТАЛЬ",93,{"$f":"ГР_Предв!L17","v":1.79},{"$f":"ГР_Предв!K17/3600","v":2.0468354430379747E-2},{"$f":"I19-K19","v":85.255554194233426},166.47,1.9424510799173873,{"$f":"ГР_Предв!F17","v":25},null,{"$f":"ИД!K16+ИД!R14/2+ИД!N13/2","v":1.345},2.6125967024888861,{"$nulls":8},0,3.5999999999999997E-2,{"$f":"IF(E20=\"ППР\",0.12,58)","v":58},{"$f":"D20/1000","v":0.02},{"$f":"AD20","v":2.5000000000000001E-2},{"$f":"1/(2*PI()*Z20)*LN(AB20/AA20)","v":6.1231722777131865E-4},{"$f":"L20/1000","v":2.5000000000000001E-2},{"$f":"AD20+X20/1000","v":2.5000000000000001E-2},{"$f":"1/(2*PI()*Y20)*LN(AE20/AD20)","v":0},{"$f":"10.3+0.052*(AN20-AJ20)","v":13.69328881810014},{"$f":"1/AG20","v":7.302847499120696E-2},{"$f":"AH20+AF20+AC20","v":7.3640792218978277E-2},20,{"$f":"(AN20-AJ20)/AI20","v":886.1332452832595},{"$f":"AK20*G20","v":1586.1785090570345},{"$f":"H20","v":2.0468354430379747E-2},{"$f":"I20","v":85.255554194233426},{"$f":"AL20/(AM20*4187)","v":18.508284723130821},{"$f":"AN20-AO20","v":66.747269471102612}]
[null,null,{"$f":"ГР_Предв!H18","v":9},{"$f":"ГР_Предв!M18","v":20},"СТАЛЬ",93,{"$f":"ГР_Предв!L18","v":0.75},{"$f":"ГР_Предв!K18/3600","v":2.0468354430379747E-2},{"$f":"I20-K20","v":83.313103114316036},69.75,0.81387615080337461,{"$f":"ГР_Предв!F18","v":25},null,{"$f":"ИД!K16+ИД!R14/2","v":0.45},0.36624426786151859,{"$nulls":8},0,3.5999999999999997E-2,{"$f":"IF(E21=\"ППР\",0.12,58)","v":58},{"$f":"D21/1000","v":0.02},{"$f":"AD21","v":2.5000000000000001E-2},{"$f":"1/(2*PI()*Z21)*LN(AB21/AA21)","v":6.1231722777131865E-4},{"$f":"L21/1000","v":2.5000000000000001E-2},{"$f":"AD21+X21/1000","v":2.5000000000000001E-2},{"$f":"1/(2*PI()*Y21)*LN(AE21/AD21)","v":0},{"$f":"10.3+0.052*(AN21-AJ21)","v":13.592281361944433},{"$f":"1/AG21","v":7.3571166853549141E-2},{"$f":"AH21+AF21+AC21","v":7.4183484081320458E-2},20,{"$f":"(AN21-AJ21)/AI21","v":853.46629237461764},{"$f":"AK21*G21","v":640.0997192809632},{"$f":"H21","v":2.0468354430379747E-2},{"$f":"I21","v":83.313103114316036},{"$f":"AL21/(AM21*4187)","v":7.4689877513793688},{"$f":"AN21-AO21","v":75.844115362936662}]
["Qтруб",{"$f":"SUM(J19:J21,J23:J25)*0.9","v":1159.8030000000001},"РАДИАТОР 1",null,"Qрад",{"$f":"ИД!R34-B22","v":310.19699999999989},"Ср.Т.",{"$f":"I21-(J22*ГР_Предв!$N$1*ГР_Предв!$N$2)/(2*4187*H21)","v":79.612422842207195},null,544,{"$f":"(I21-L22)","v":7.4013605442176953},{"$f":"I21-(J22*ГР_Предв!$N$1*ГР_Предв!$N$2)/(4187*H21)","v":75.91174257009834},null,{"$f":"ИД!K16","v":0.2},1.4802721088435391]
[null,null,{"$f":"ГР_Предв!H20","v":11},{"$f":"ГР_Предв!M20","v":20},"СТАЛЬ",{"$f":"IF(E23=\"ППР\",VLOOKUP(D23,$Q$3:$T$10,4),VLOOKUP(D23,$X$3:$AA$10,4))","v":93},{"$f":"ГР_Предв!L20","v":0.2},{"$f":"ГР_Предв!K20/3600","v":2.0468354430379747E-2},{"$f":"L22","v":75.91174257009834},{"$f":"(F23*G23)","v":18.600000000000001},{"$f":"J23/(H23*4187)","v":0.21703364021423324},{"$f":"ГР_Предв!F20","v":25},null,{"$f":"ИД!K16-ИД!R14/2","v":-4.9999999999999989E-2},-1.085168201071166E-2,{"$nulls":8},20,3.5999999999999997E-2,{"$f":"IF(E23=\"ППР\",0.12,58)","v":58},{"$f":"D23/1000","v":0.02},{"$f":"AD23","v":2.5000000000000001E-2},{"$f":"1/(2*PI()*Z23)*LN(AB23/AA23)","v":6.1231722777131865E-4},{"$f":"L23/1000","v":2.5000000000000001E-2},{"$f":"AD23+X23/1000","v":4.4999999999999998E-2},{"$f":"1/(2*PI()*Y23)*LN(AE23/AD23)","v":2.5985875889631029},{"$f":"10.3+0.052*(AN23-AJ23)","v":13.207410613645115},{"$f":"1/AG23","v":7.5715068551503895E-2},{"$f":"AH23+AF23+AC23","v":2.6749149747423782},20,{"$f":"(AN23-AJ23)/AI23","v":20.902250388531776},{"$f":"AK23*G23","v":4.1804500777063556},{"$f":"H23","v":2.0468354430379747E-2},{"$f":"I23","v":75.91174257009834},{"$f":"AL23/(AM23*4187)","v":4.8779478392391641E-2},{"$f":"AN23-AO23","v":75.86296309170595}]
[null,null,{"$f":"ГР_Предв!H21","v":13},{"$f":"ГР_Предв!M21","v":20},"СТАЛЬ",{"$f":"IF(E24=\"ППР\",VLOOKUP(D24,$Q$3:$T$10,4),VLOOKUP(D24,$X$3:$AA$10,4))","v":93},{"$f":"ГР_Предв!L21","v":0.1},{"$f":"ГР_Предв!K21/3600","v":2.0468354430379747E-2},{"$f":"I23-K23","v":75.694708929884101},{"$f":"(F24*G24)","v":9.3000000000000007},{"$f":"J24/(H24*4187)","v":0.10851682010711662},{"$f":"ГР_Предв!F21","v":25},null,{"$f":"ИД!K16-ИД!R14/2-ИД!N19/2","v":-9.9999999999999992E-2},-1.085168201071166E-2,{"$nulls":8},20,3.5999999999999997E-2,{"$f":"IF(E24=\"ППР\",0.12,58)","v":58},{"$f":"D24/1000","v":0.02},{"$f":"AD24","v":2.5000000000000001E-2},{"$f":"1/(2*PI()*Z24)*LN(AB24/AA24)","v":6.1231722777131865E-4},{"$f":"L24/1000","v":2.5000000000000001E-2},{"$f":"AD24+X24/1000","v":4.4999999999999998E-2},{"$f":"1/(2*PI()*Y24)*LN(AE24/AD24)","v":2.5985875889631029},{"$f":"10.3+0.052*(AN24-AJ24)","v":13.196124864353974},{"$f":"1/AG24","v":7.5779822506927733E-2},{"$f":"AH24+AF24+AC24","v":2.6749797286978021},20,{"$f":"(AN24-AJ24)/AI24","v":20.820609716170317},{"$f":"AK24*G24","v":2.082060971617032},{"$f":"H24","v":2.0468354430379747E-2},{"$f":"I24","v":75.694708929884101},{"$f":"AL24/(AM24*4187)","v":2.429447697946386E-2},{"$f":"AN24-AO24","v":75.670414452904637}]
[null,null,{"$f":"ГР_Предв!H22","v":14.1},{"$f":"ГР_Предв!M22","v":40},"СТАЛЬ",{"$f":"IF(E25=\"ППР\",VLOOKUP(D25,$Q$3:$T$10,4),VLOOKUP(D25,$X$3:$AA$10,4))","v":155},{"$f":"ГР_Предв!L22","v":2.42},{"$f":"ГР_Предв!K22/3600","v":2.0468354430379747E-2},{"$f":"I24-K24","v":75.586192109776988},{"$f":"(F25*G25)","v":375.09999999999997},{"$f":"J25/(H25*4187)","v":4.3768450776537033},{"$f":"ГР_Предв!F22","v":50},null,{"$f":"ИД!K16-ИД!R14/2-ИД!N19","v":-0.15},-0.65652676164805546]
[null,null,{"$f":"ГР_Предв!H23","v":15},{"$f":"ГР_Предв!M23","v":40},"СТАЛЬ",{"$f":"IF(E26=\"ППР\",VLOOKUP(D26,$Q$3:$T$10,4),VLOOKUP(D26,$X$3:$AA$10,4))","v":155},{"$f":"ГР_Предв!L23","v":1.5},{"$f":"ГР_Предв!K23/3600","v":0.10025316455696202},{"$f":"I24-K24","v":75.586192109776988},{"$f":"(F26*G26)","v":232.5},{"$f":"J26/(H26*4187)","v":0.55388793596340768},{"$f":"ГР_Предв!F23","v":50},null,{"$f":"ИД!K16-ИД!R14/2-ИД!N19","v":-0.15},-8.3083190394511147E-2,{"$nulls":4},"НЕВЯЗКА",{"$f":"1-O28/U28","v":-8.7321880867083035E-2},null,null,20,3.5999999999999997E-2,{"$f":"IF(E26=\"ППР\",0.12,58)","v":58},{"$f":"D26/1000","v":0.04},{"$f":"AD26","v":0.05},{"$f":"1/(2*PI()*Z26)*LN(AB26/AA26)","v":6.1231722777131865E-4},{"$f":"L26/1000","v":0.05},{"$f":"AD26+X26/1000","v":7.0000000000000007E-2},{"$f":"1/(2*PI()*Y26)*LN(AE26/AD26)","v":1.487533879762553},{"$f":"10.3+0.052*(AN26-AJ26)","v":13.190481989708404},{"$f":"1/AG26","v":7.5812241037153075E-2},{"$f":"AH26+AF26+AC26","v":1.5639584380274774},20,{"$f":"(AN26-AJ26)/AI26","v":35.541988046616098},{"$f":"AK26*G26","v":53.312982069924146},{"$f":"H26","v":0.10025316455696202},{"$f":"I26","v":75.586192109776988},{"$f":"AL26/(AM26*4187)","v":0.12700824773662128},{"$f":"AN26-AO26","v":75.459183862040362}]
[null,null,{"$f":"ГР_Предв!H24","v":16},{"$f":"ГР_Предв!M24","v":40},"СТАЛЬ",{"$f":"IF(E27=\"ППР\",VLOOKUP(D27,$Q$3:$T$10,4),VLOOKUP(D27,$X$3:$AA$10,4))","v":155},{"$f":"ГР_Предв!L24","v":0.1},{"$f":"ГР_Предв!K24/3600","v":0.10025316455696202},{"$f":"I26-K26","v":75.032304173813586},{"$f":"(F27*G27)","v":15.5},{"$f":"J27/(H27*4187)","v":3.6925862397560509E-2},{"$f":"ГР_Предв!F24","v":50},null,{"$f":"ИД!K16-ИД!R14/2-ИД!N19","v":-0.15},-5.538879359634076E-3,{"$nulls":8},20,3.5999999999999997E-2,{"$f":"IF(E27=\"ППР\",0.12,58)","v":58},{"$f":"D27/1000","v":0.04},{"$f":"AD27","v":0.05},{"$f":"1/(2*PI()*Z27)*LN(AB27/AA27)","v":6.1231722777131865E-4},{"$f":"L27/1000","v":0.05},{"$f":"AD27+X27/1000","v":7.0000000000000007E-2},{"$f":"1/(2*PI()*Y27)*LN(AE27/AD27)","v":1.487533879762553},{"$f":"10.3+0.052*(AN27-AJ27)","v":13.161679817038307},{"$f":"1/AG27","v":7.597814366411354E-2},{"$f":"AH27+AF27+AC27","v":1.5641243406544378},20,{"$f":"(AN27-AJ27)/AI27","v":35.184098056288661},{"$f":"AK27*G27","v":3.5184098056288664},{"$f":"H27","v":0.10025316455696202},{"$f":"I27","v":75.032304173813586},{"$f":"AL27/(AM27*4187)","v":8.3819558929599455E-3},{"$f":"AN27-AO27","v":75.023922217920628}]
[null,"Остывание:",{"$nulls":8},{"$f":"I16-I27","v":14.967695826186414},"0С","Действительное ЕЦД:",null,{"$f":"SUM(O16:O27)*ИД!$L$29*9.81","v":82.897437471208065},"Па",null,null,null,"Потери:",{"$f":"ГР_Предв!X25","v":76.24001588664953},"Па"]
[null,null,"ЦК2"]
[null,null,{"$f":"ГР_Предв!H27","v":1},{"$f":"ГР_Предв!M27","v":40},"СТАЛЬ",{"$f":"IF(E30=\"ППР\",VLOOKUP(D30,$Q$3:$T$10,4),VLOOKUP(D30,$X$3:$AA$10,4))","v":155},{"$f":"ГР_Предв!L27","v":0.1},{"$f":"ГР_Предв!K27/3600","v":0.10025316455696202},{"$f":"I13","v":90},{"$f":"(F30*G30)","v":15.5},{"$f":"J30/(H30*4187)","v":3.6925862397560509E-2},{"$f":"ГР_Предв!F27","v":50},null,{"$f":"N16","v":0.26},{"$f":"N30*K30","v":9.6007242233657319E-3}]
[null,null,{"$f":"ГР_Предв!H28","v":3},{"$f":"ГР_Предв!M28","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L28","v":1.9},{"$f":"ГР_Предв!K28/3600","v":0.10025316455696202},{"$f":"I30-K30","v":89.963074137602433},294.5,0.70159138555364975,{"$f":"ГР_Предв!F28","v":50},null,{"$f":"N17","v":1.21},0.84892557651991618]
[null,null,{"$f":"ГР_Предв!H29","v":5},{"$f":"ГР_Предв!M29","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L29","v":1.87},{"$f":"ГР_Предв!K29/3600","v":0.10025316455696202},89.261482752048778,289.85000000000002,0.69051362683438167,{"$f":"ГР_Предв!F29","v":50},null,{"$f":"N18","v":2.16},1.4915094339622645]
[null,null,{"$f":"ГР_Предв!H30","v":5.2},{"$f":"ГР_Предв!M30","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L30","v":4.1900000000000004},{"$f":"ГР_Предв!K30/3600","v":4.6784810126582282E-2},88.57096912521439,649.45000000000005,3.3154149309809688,{"$f":"ГР_Предв!F30","v":50},null,{"$f":"N19","v":2.16},7.1612962509188929]
[null,null,{"$f":"ГР_Предв!H31","v":17},{"$f":"ГР_Предв!M31","v":32},"СТАЛЬ",138,{"$f":"ГР_Предв!L31","v":3.8},{"$f":"ГР_Предв!K31/3600","v":2.0050632911392408E-2},85.255554194233426,524.4,6.2464265294453964,{"$f":"ГР_Предв!F31","v":40},null,{"$f":"ИД!B14/2+ИД!H13","v":2.16},13.492281303602057]
[null,null,{"$f":"ГР_Предв!H32","v":19},{"$f":"ГР_Предв!M32","v":15},"СТАЛЬ",77,{"$f":"ГР_Предв!L32","v":1.75},{"$f":"ГР_Предв!K32/3600","v":2.0050632911392408E-2},79.009127664788025,134.75,1.6050838574423478,{"$f":"ГР_Предв!F32","v":20},null,{"$f":"ИД!K16+ИД!R14/2+ИД!T13/2","v":1.325},2.1267361111111107]
[null,null,{"$f":"ГР_Предв!H33","v":21},{"$f":"ГР_Предв!M33","v":15},"СТАЛЬ",77,{"$f":"ГР_Предв!L33","v":1},{"$f":"ГР_Предв!K33/3600","v":2.0050632911392408E-2},77.404043807345673,77,0.91719077568134155,{"$f":"ГР_Предв!F33","v":20},null,{"$f":"ИД!K16+ИД!R14/2","v":0.45},0.41273584905660371]
["Qтруб",{"$f":"SUM(J34:J36,J38:J40)*0.9","v":1113.057},"РАДИАТОР 2",null,"Qрад",{"$f":"ИД!R64-B37","v":326.94299999999998},"Ср.Т.",{"$f":"I36-(J37*ГР_Предв!$N$1*ГР_Предв!$N$2)/(2*4187*H36)","v":73.626266029567901},null,544,{"$f":"I36-L37","v":7.5555555555555571},{"$f":"I36-(J37*ГР_Предв!$N$1*ГР_Предв!$N$2)/(4187*H36)","v":69.848488251790116},null,{"$f":"N22","v":0.2},1.5111111111111115]
[null,null,{"$f":"ГР_Предв!H35","v":23},{"$f":"ГР_Предв!M35","v":15},"СТАЛЬ",{"$f":"IF(E38=\"ППР\",VLOOKUP(D38,$Q$3:$T$10,4),VLOOKUP(D38,$X$3:$AA$10,4))","v":77},{"$f":"ГР_Предв!L35","v":0.2},{"$f":"ГР_Предв!K35/3600","v":2.0050632911392408E-2},{"$f":"L37","v":69.848488251790116},{"$f":"(F38*G38)","v":15.4},{"$f":"J38/(H38*4187)","v":0.18343815513626832},{"$f":"ГР_Предв!F35","v":20},null,{"$f":"ИД!K16-ИД!R14/2","v":-4.9999999999999989E-2},-9.171907756813414E-3]
[null,null,{"$f":"ГР_Предв!H36","v":25},{"$f":"ГР_Предв!M36","v":15},"СТАЛЬ",77,{"$f":"ГР_Предв!L36","v":0.1},{"$f":"ГР_Предв!K36/3600","v":2.0050632911392408E-2},{"$f":"I38-K38","v":69.665050096653843},7.7,9.1719077568134161E-2,{"$f":"ГР_Предв!F36","v":20},null,{"$f":"ИД!K16-ИД!R14/2-ИД!T19/2","v":-9.9999999999999992E-2},-9.1719077568134157E-3]
[null,null,{"$f":"ГР_Предв!H37","v":27},{"$f":"ГР_Предв!M37","v":32},"СТАЛЬ",138,{"$f":"ГР_Предв!L37","v":3.46},{"$f":"ГР_Предв!K37/3600","v":2.0050632911392408E-2},{"$f":"I39-K39","v":69.573331019085714},477.48,5.6875357347055457,{"$f":"ГР_Предв!F37","v":40},null,{"$f":"ИД!K16-ИД!R14/2-ИД!T19","v":-0.15},-0.85313036020583188]
[null,null,{"$f":"ГР_Предв!H38","v":14.1},{"$f":"ГР_Предв!M38","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L38","v":2.42},{"$f":"ГР_Предв!K38/3600","v":2.0468354430379747E-2},{"$f":"I40-K40","v":63.885795284380166},375.09999999999997,4.3768450776537033,{"$f":"ГР_Предв!F38","v":50},null,{"$f":"N25","v":-0.15},-0.65652676164805546,{"$nulls":4},"НЕВЯЗКА",{"$f":"1-O44/U44","v":-4.3875141540274942E-2}]
[null,null,{"$f":"ГР_Предв!H39","v":15},{"$f":"ГР_Предв!M39","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L39","v":1.5},{"$f":"ГР_Предв!K39/3600","v":0.10025316455696202},{"$f":"I41-K41","v":59.50895020672646},232.5,0.55388793596340768,{"$f":"ГР_Предв!F39","v":50},null,{"$f":"N26","v":-0.15},-8.3083190394511147E-2]
[null,null,{"$f":"ГР_Предв!H40","v":16},{"$f":"ГР_Предв!M40","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L40","v":0.1},{"$f":"ГР_Предв!K40/3600","v":0.10025316455696202},{"$f":"I42-K42","v":58.955062270763051},15.5,3.6925862397560509E-2,{"$f":"ГР_Предв!F40","v":50},null,{"$f":"N27","v":-0.15},-5.538879359634076E-3]
[null,"Остывание:",{"$nulls":8},{"$f":"I30-I42","v":30.49104979327354},"0С","Действительное ЕЦД:",null,{"$f":"SUM(O30:O43)*ИД!$L$29*9.81","v":159.70726054188404},"Па",null,null,null,"Потери:",{"$f":"ГР_Предв!X41","v":152.99460077785767},"Па"]
[null,null,"ЦК3"]
[null,null,{"$f":"ГР_Предв!H43","v":1},{"$f":"ГР_Предв!M43","v":40},"СТАЛЬ",{"$f":"IF(E46=\"ППР\",VLOOKUP(D46,$Q$3:$T$10,4),VLOOKUP(D46,$X$3:$AA$10,4))","v":155},{"$f":"ГР_Предв!L43","v":0.1},{"$f":"ГР_Предв!K43/3600","v":0.10025316455696202},{"$f":"I13","v":90},{"$f":"(F46*G46)","v":15.5},{"$f":"J46/(H46*4187)","v":3.6925862397560509E-2},{"$f":"ГР_Предв!F43","v":50},null,{"$f":"N16","v":0.26},{"$f":"N46*K46","v":9.6007242233657319E-3}]
[null,null,{"$f":"ГР_Предв!H44","v":3},{"$f":"ГР_Предв!M44","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L44","v":1.9},{"$f":"ГР_Предв!K44/3600","v":0.10025316455696202},{"$f":"I46-K46","v":89.963074137602433},294.5,0.70159138555364975,{"$f":"ГР_Предв!F44","v":50},null,{"$f":"N17","v":1.21},0.84892557651991618]
[null,null,{"$f":"ГР_Предв!H45","v":5},{"$f":"ГР_Предв!M45","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L45","v":3.8},{"$f":"ГР_Предв!K45/3600","v":2.0050632911392408E-2},89.261482752048778,589,7.0159138555364962,{"$f":"ГР_Предв!F45","v":50},null,{"$f":"N18","v":2.16},15.154373927958833]
[null,null,{"$f":"ГР_Предв!H46","v":5.2},{"$f":"ГР_Предв!M46","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L46","v":1.75},{"$f":"ГР_Предв!K46/3600","v":2.0050632911392408E-2},82.245568896512282,271.25,3.2310129597865442,{"$f":"ГР_Предв!F46","v":50},null,{"$f":"N19","v":2.16},6.9789879931389356]
[null,null,{"$f":"ГР_Предв!H47","v":17},{"$f":"ГР_Предв!M47","v":32},"СТАЛЬ",138,{"$f":"ГР_Предв!L47","v":3.8},{"$f":"ГР_Предв!K47/3600","v":2.0050632911392408E-2},79.014555936725742,524.4,6.2464265294453964,{"$f":"ГР_Предв!F47","v":40},null,{"$f":"N34","v":2.16},13.492281303602057]
[null,null,{"$f":"ГР_Предв!H48","v":28},{"$f":"ГР_Предв!M48","v":10},"СТАЛЬ",63,{"$f":"ГР_Предв!L48","v":3.97},{"$f":"ГР_Предв!K48/3600","v":6.2658227848101265E-3},72.768129407280341,250.11,9.5334476843910814,{"$f":"ГР_Предв!F48","v":{"$error":"#N/A"}},null,{"$f":"ИД!B14/2+ИД!H13","v":2.16},20.592246998284736]
[null,null,{"$f":"ГР_Предв!H49","v":30},{"$f":"ГР_Предв!M49","v":10},"СТАЛЬ",63,{"$f":"ГР_Предв!L49","v":1.7},{"$f":"ГР_Предв!K49/3600","v":6.2658227848101265E-3},63.234681722889263,107.1,4.0823327615780443,{"$f":"ГР_Предв!F49","v":{"$error":"#N/A"}},null,{"$f":"ИД!K16+ИД!R14/2+ИД!Z13/2","v":1.3},5.3070325900514579]
[null,null,{"$f":"ГР_Предв!H50","v":32},{"$f":"ГР_Предв!M50","v":10},"СТАЛЬ",63,{"$f":"ГР_Предв!L50","v":0.1},{"$f":"ГР_Предв!K50/3600","v":6.2658227848101265E-3},59.152348961311219,6.3000000000000007,0.24013722126929676,{"$f":"ГР_Предв!F50","v":{"$error":"#N/A"}},null,{"$f":"ИД!K16+ИД!R14/2","v":0.45},0.10806174957118354]
["Qтруб",{"$f":"SUM(J51:J53,J55:J57)","v":770.49},"РАДИАТОР 3",null,"Qрад",{"$f":"ИД!R98-B54","v":-320.49},"Ср.Т.",{"$f":"I53-(J54*ГР_Предв!$N$1*ГР_Предв!$N$2)/(2*4187*H53)","v":50.263460072422333},null,400,{"$f":"I53-L54","v":17.777777777777779},{"$f":"I53-(J54*ГР_Предв!$N$1*ГР_Предв!$N$2)/(4187*H53)","v":41.37457118353344},null,{"$f":"N22","v":0.2},3.5555555555555558]
[null,null,{"$f":"ГР_Предв!H52","v":34},{"$f":"ГР_Предв!M52","v":10},"СТАЛЬ",{"$f":"IF(E55=\"ППР\",VLOOKUP(D55,$Q$3:$T$10,4),VLOOKUP(D55,$X$3:$AA$10,4))","v":63},{"$f":"ГР_Предв!L52","v":0},{"$f":"ГР_Предв!K52/3600","v":6.2658227848101265E-3},{"$f":"L54","v":41.37457118353344},{"$f":"(F55*G55)","v":0},{"$f":"J55/(H55*4187)","v":0},{"$f":"ГР_Предв!F52","v":{"$error":"#N/A"}},null,{"$f":"ИД!K16-ИД!R14/2","v":-4.9999999999999989E-2},0]
[null,null,{"$f":"ГР_Предв!H53","v":36},{"$f":"ГР_Предв!M53","v":10},"СТАЛЬ",63,{"$f":"ГР_Предв!L53","v":0.2},{"$f":"ГР_Предв!K53/3600","v":6.2658227848101265E-3},{"$f":"I55-K55","v":41.37457118353344},12.600000000000001,0.48027444253859353,{"$f":"ГР_Предв!F53","v":{"$error":"#N/A"}},null,{"$f":"ИД!K16-ИД!R14/2-ИД!Z19/2","v":-0.15},-7.2041166380789029E-2]
[null,null,{"$f":"ГР_Предв!H54","v":38},{"$f":"ГР_Предв!M54","v":10},"СТАЛЬ",63,{"$f":"ГР_Предв!L54","v":6.26},{"$f":"ГР_Предв!K54/3600","v":6.2658227848101265E-3},40.894296740994847,394.38,15.032590051457976,{"$f":"ГР_Предв!F54","v":{"$error":"#N/A"}},null,{"$f":"ИД!K16-ИД!R14/2-ИД!Z19","v":-0.25},-3.7581475128644941]
[null,null,{"$f":"ГР_Предв!H55","v":27},{"$f":"ГР_Предв!M55","v":32},"СТАЛЬ",138,{"$f":"ГР_Предв!L55","v":3.46},{"$f":"ГР_Предв!K55/3600","v":2.0050632911392408E-2},25.86170668953687,477.48,5.6875357347055457,{"$f":"ГР_Предв!F55","v":40},null,{"$f":"N57","v":-0.25},-1.4218839336763864,{"$nulls":4},"НЕВЯЗКА",{"$f":"1-O62/U62","v":-0.53772292898681018}]
[null,null,{"$f":"ГР_Предв!H56","v":14.1},{"$f":"ГР_Предв!M56","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L56","v":2.42},{"$f":"ГР_Предв!K56/3600","v":2.0468354430379747E-2},20.174170954831325,375.09999999999997,4.3768450776537033,{"$f":"ГР_Предв!F56","v":50},null,{"$f":"N58","v":-0.25},-1.0942112694134258]
[null,null,{"$f":"ГР_Предв!H57","v":15},{"$f":"ГР_Предв!M57","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L57","v":1.5},{"$f":"ГР_Предв!K57/3600","v":0.10025316455696202},15.797325877177622,232.5,0.55388793596340768,{"$f":"ГР_Предв!F57","v":50},null,{"$f":"N59","v":-0.25},-0.13847198399085192]
[null,null,{"$f":"ГР_Предв!H58","v":16},{"$f":"ГР_Предв!M58","v":40},"СТАЛЬ",155,{"$f":"ГР_Предв!L58","v":0.1},{"$f":"ГР_Предв!K58/3600","v":0.10025316455696202},15.243437941214214,15.5,3.6925862397560509E-2,{"$f":"ГР_Предв!F58","v":50},null,{"$f":"N60","v":-0.25},-9.2314655993901273E-3]
[null,"Остывание:",{"$nulls":8},{"$f":"I46-I59","v":69.825829045168675},"0С","Действительное ЕЦД:",null,{"$f":"SUM(O46:O60)*ИД!$L$29*9.81","v":373.95601057331891},"Па",null,null,null,"Потери:",{"$f":"ГР_Предв!X59","v":243.18816057435956},"Па"]

{"sheet":"Бачок","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":10}
[null,null,"Внутр. Диам","Длина"]
[null,null,10,12.9,{"$f":"(C12/1000)^2*3.1416/4","v":7.8540000000000004E-5},{"$f":"E12*D12","v":1.013166E-3}]
[null,null,15,8.8000000000000007,{"$f":"(C13/1000)^2*3.1416/4","v":1.76715E-4},{"$f":"E13*D13","v":1.5550920000000001E-3}]
[null,null,20,11.1,3.1416000000000001E-4,3.4871760000000003E-3]
[null,null,25,0.5,4.908750000000001E-4,2.4543750000000005E-4]
[null,null,32,16.7,8.0424959999999992E-4,1.3430968319999998E-2]
[null,null,40,32,1.2566400000000001E-3,4.0212480000000002E-2]
[{"$nulls":5},{"$f":"SUM(F12:F17)","v":5.9944319820000001E-2},{"$f":"F18*1000","v":59.944319820000004}]
[null,null,"Секций рад","Воды в 1"]
[null,null,22,0.2,{"$f":"D20*C20","v":4.4000000000000004}]
[]
[]
[]
[]
[null,null,"Воды в системе ",null,null,"Бак"]
[null,null,{"$f":"G18+E20","v":64.34431982000001},null,null,{"$f":"C26*0.1","v":6.4344319820000013},"литров"]