{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["ТТ","ТП","Шайбы","Регистр 10-50","Регистр 40-100","Окраска","ТИ"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":4,"comments":3,"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":251,"n_cols":43,"rows_kept":251,"cut":false,"hidden":false,"merged":[[27,30,27,35],[20,30,20,35],[21,30,21,35],[22,30,22,35],[23,30,23,35],[40,30,42,36],[0,38,1,42],[2,38,8,38],[2,39,3,42],[4,39,5,40],[4,41,5,42],[6,39,6,42],[7,39,8,39],[28,30,28,35],[29,30,29,35],[7,40,8,40],[7,41,8,41],[7,42,8,42],[16,38,18,42],[34,30,36,36],[37,30,39,36],[31,30,31,36],[32,30,33,36],[24,30,24,35],[16,30,16,35],[17,30,17,35],[18,30,18,35],[19,30,19,35],[12,30,12,35],[13,30,13,35],[14,30,14,35],[15,30,15,35],[26,30,26,35],[25,30,25,35],[214,19,214,28],[123,19,123,28],[176,19,176,28],[185,19,185,28],[193,19,193,28],[250,19,250,28],[0,30,1,36],[2,30,2,35],[3,30,3,35],[4,30,4,35],[5,30,5,35],[6,30,6,35],[7,30,7,35],[227,19,227,28],[240,19,240,28],[8,30,8,35],[9,30,9,35],[10,30,10,35],[11,30,11,35],[248,19,248,28],[249,19,249,28],[246,19,246,28],[247,19,247,28],[199,19,199,28],[81,19,81,28],[99,19,99,28],[107,19,107,28],[108,19,108,28],[11,19,11,28],[12,19,12,28],[44,19,44,28],[61,19,61,28],[208,19,208,28],[207,19,207,28],[0,19,2,28],[4,19,10,19],[4,20,10,20],[4,21,10,21],[4,22,9,23],[4,24,4,28],[5,24,9,25],[5,26,9,27],[5,28,9,28],[34,14,36,14],[37,0,37,1],[36,0,36,1],[34,11,36,11],[31,11,33,11],[34,0,34,1],[31,0,31,1],[35,0,35,1],[32,0,32,1],[33,0,33,1],[4,0,4,5],[5,0,5,5],[6,0,6,5],[7,0,7,5],[13,15,15,15],[29,0,29,1],[30,0,30,1],[0,0,0,14],[13,12,15,12],[13,13,15,13],[14,0,14,1],[15,0,15,1],[13,14,15,14],[2,1,2,15],[3,0,3,5],[28,11,30,11],[28,12,30,12],[26,0,26,1],[27,0,27,1],[25,11,27,11],[25,12,27,12],[28,0,28,1],[25,13,27,13],[25,14,27,14],[10,11,11,11],[10,0,11,2],[17,0,17,1],[18,0,18,1],[13,0,13,1],[13,11,15,11],[21,0,21,1],[8,0,8,4],[8,5,8,6],[19,0,19,1],[21,14,23,14],[21,13,23,13],[22,0,22,1],[23,0,23,1],[34,15,36,15],[17,11,19,11],[28,15,30,15],[31,15,33,15],[17,12,19,12],[17,13,19,13],[21,11,23,11],[28,13,30,13],[17,14,19,14],[17,15,19,15],[25,0,25,1],[21,12,23,12],[25,15,27,15],[21,15,23,15],[34,12,36,12],[34,13,36,13],[31,12,33,12],[28,14,30,14],[31,13,33,13],[31,14,33,14]]}
["Теплотехнический расчёт ограждающих конструкций",{"$nulls":18},"НОРМИРУЕМЫЕ ТЕПЛОТЕНХНИЧЕСКИЕ ПОКАЗАТЕЛИ СТРОИТЕЛЬНЫХ МАТЕРИАЛОВ И ИЗДЕЛИЙ",{"$nulls":10},"ПРИВЕДЕННОЕ СОПРОТИВЛЕНИЕ ТЕПЛОПЕРЕДАЧЕ ОКОН                     R, м²·ºС/Вт",{"$nulls":7},"ТЕРМИЧЕСКОЕ СОПРОТИВЛЕНИЕ ЗАМКНУТЫХ ВОЗДУШНЫХ ПРОСЛОЕК"]
[]
["Объект:",{"$nulls":29},"1. Двойное остекление в спаренных переплетах",{"$nulls":5},0.4,null,"Толщина воздуш-ной прос-лойки, м","Термическое сопротивление замкнутой воздушной прослойки Rв.п, м²·ºС/Вт"]
["Расчётная температура наружного воздуха. text, ºC",{"$nulls":5},-22,{"$nulls":23},"2. Двойное остекление в раздельных переплетах",{"$nulls":5},0.44]
["Расчётная температура внутреннего воздуха. tint, ºC",{"$nulls":5},18,{"$nulls":12},"№ п.п.","Материал","Плот-ность ρ0, кг/м³","Расчетное массовое отношение влаги в материале w, %",null,"Расчетные коэффициенты при условиях эксплуатации",{"$nulls":5},"3. Тройное остекление в раздельно-спаренных переплетах",{"$nulls":5},0.55000000000000004,null,null,"гориз-й при потоке тепла снизу вверх и вертик-й",null,"горизонтальной при потоке тепла сверху вниз"]
["Средняя температура за отопительный период. tht, ºC",{"$nulls":5},-0.6,{"$nulls":17},"теплопроводности λ, Вт/(м·ºС)",null,"теплоусвоения (при периоде 24 ч) s, Вт/(м²·ºС)",null,"паропроницаемости μ, мг/(м·ч·Па)",null,"4. Однокамерный стеклопакет из стекла:"]
["Продолжительность отопительного периода Zht, сут",{"$nulls":5},224,{"$nulls":23},"- обычного",{"$nulls":5},0.38,null,null,"при температуре воздуха в прослойке"]
["Градусо-сутки отопительного периода Dd, ºС·сут",{"$nulls":5},{"$f":"(G5-G6)*G7","v":4166.4000000000005},{"$nulls":23},"- с твердым селективным покрытием ",{"$nulls":5},0.51,null,null,"положи-тельной","отрица-тельной","положи-тельной","отрица-тельной"]
["Здание:",{"$nulls":4},"жилое",{"$nulls":24},"- с мягким селективным покрытием",{"$nulls":5},0.56000000000000005]
[{"$nulls":30},"5. Двухкамерный стеклопакет из стекла:",{"$nulls":7},"0,01",0.13,0.15,0.14000000000000001,0.15]
["Ограждающая поверхность",null,null,"№ слоя","aext",1,2,3,4,5,"aint","D","R0","K","Rreq","Dt0",{"$nulls":6},"А","Б","А","Б","A","Б","А, Б",null,"- обычного (с межстекольным расстоянием 6 мм)",{"$nulls":5},"0,51",null,"0,02",0.14000000000000001,0.15,0.15,0.19]
[{"$nulls":4},"Вт/м²·ºC",{"$nulls":5},"Вт/м2.oC",null,"м2.oC/Вт","Вт/м2.oC","м2.oC/Вт","oC",null,null,null,"I Теплоизоляционные материалы (ГОСТ 16381)",{"$nulls":10},"- обычного (с межстекольным расстоянием 12 мм)",{"$nulls":5},"0,54",null,"0,03",0.14000000000000001,0.16,0.16,0.21]
[null,null,null,"Слой",null,"Штукатурка","Fibo 5","теплоизол","воздушн прос","вагонка",{"$nulls":9},"А. Полимерные",{"$nulls":10},"- с твердым селективным покрытием ",{"$nulls":5},"0,58",null,"0,05",0.14000000000000001,0.17,0.17,0.22]
["Наружная стена",null,"λ","Вт/м·ºC",{"$f":"IF(A15=\"с вент. прослойкой\",12,IF(A15=\"...\",23,\"ошибка\"))","v":12},{"$f":"Z212","v":0.93},0.24,0.04,{"$f":"AO11","v":0.15},0,8.6999999999999993,{"$f":"IF(F14=0,0,F16*F15/F14)+IF(G14=0,0,G16*G15/G14)+IF(H14=0,0,H16*H15/H14)+IF(J14=0,0,J16*J15/J14)","v":0},{"$f":"1/E14+IF(F14=0,0,F16/F14)+IF(G14=0,0,G16/G14)+IF(H14=0,0,H16/H14)+IF(I14=0,0,I16/I14)+IF(J14=0,0,J16/J14)+1/K14","v":8.6944048943270307},{"$f":"ROUND(1/M14,3)","v":0.115},{"$f":"IF(F9=\"общественное\",0.0003*G8+1.2,IF(F9=\"жилое\",0.00035*G8+1.4,IF(F9=\"производственное\",0.0002*G8+1,\"ошибка\")))","v":2.8582400000000003},{"$f":"(G5-G4)/(M14*8.7)","v":0.52881148339723849},{"$f":"IF(O14>M14,\"Ro<Rreq\",\"Ro…OK\")","v":"Ro…OK"},null,null,1,"Экструдированный пенополистирол фирмы БАСФ ТУ 2244-001-47547616-00 Стиродур 2500С",25,2,10,3.1E-2,3.1E-2,0.28000000000000003,0.31,1.2999999999999999E-2,null,"- с мягким селективным покрытием",{"$nulls":5},"0,68",null,"0,1",0.15,0.18,0.18,0.23]
["с вент. прослойкой",null,"s","Вт/м²·ºC",{"$nulls":12},{"$f":"IF($F$9=\"жилое\",IF(P14<4,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"общественное\",IF(P14<4.5,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"производственное\",IF(P14<7,\"Dto..OK\",\"Dto<DTh\"))))","v":"Dto..OK"},null,null,2,"То же, 2800С",28,2,10,3.1E-2,3.1E-2,0.3,0.33,1.2999999999999999E-2,null,"- с твердым селективным покрытием и заполнением аргоном",{"$nulls":5},"0,65",null,"0,15",0.15,0.18,0.19,0.24]
[null,null,"δ","м",null,1.4999999999999999E-2,0.2,0.3,2.1999999999999999E-2,2.1000000000000001E-2,{"$f":"\"Sd = \"&SUM(F16:I16)","v":"Sd = 0,537"},{"$nulls":8},3,"» 3035С",33,2,10,3.1E-2,3.1E-2,0.32,0.36,1.2999999999999999E-2,null,"6. Обычное стекло и однокамерный стеклопакет в раздельных ",{"$nulls":7},"0,2 - 0,3",0.15,0.19,0.19,0.24]
[null,null,null,"Слой",null,"Ж/б плита","Утеплитель ","Цем.-песч. ст",{"$nulls":11},4,"» 4000С",35,2,10,3.1E-2,3.1E-2,0.34,0.37,5.0000000000000001E-3,null,"переплетах из стекла:",{"$nulls":7},"П р и м е ч а н и е. При оклейке одной или обеих поверхностей воздушной прослойки алюминиевой фольгой термическое сопротивление следует увеличивать в 2 раза."]
["Бесчердачное",null,"λ","Вт/м·ºC",{"$f":"IF(A20=\"с вент. прослойкой\",10.8,IF(A20=\"...\",23,\"ошибка\"))","v":23},1.22,0.03,{"$f":"Z212","v":0.93},null,null,8.6999999999999993,{"$f":"IF(F18=0,0,F20*F19/F18)+IF(G18=0,0,G20*G19/G18)+IF(H18=0,0,H20*H19/H18)+IF(I18=0,0,J20*J19/I18)","v":0},{"$f":"1/E18+IF(F18=0,0,F20/F18)+IF(G18=0,0,G20/G18)+IF(H18=0,0,H20/H18)+IF(I18=0,0,I20/I18)+IF(J18=0,0,J20/J18)+1/K18","v":1.2247701638340007},{"$f":"ROUND(1/M18,3)","v":0.81599999999999995},{"$f":"IF(F9=\"общественное\",0.0004*G8+1.6,IF(F9=\"жилое\",0.0005*G8+2.2,IF(F9=\"производственное\",0.00025*G8+1.5,\"ошибка\")))","v":4.2832000000000008},{"$f":"($G$5-$G$4)/(M18*8.7)","v":3.7539297455064697},{"$f":"IF(O18>M18,\"Ro<Rreq\",\"Ro…OK\")","v":"Ro<Rreq"},null,null,5,"» 5000С",45,2,10,3.1E-2,3.1E-2,0.38,0.42,5.0000000000000001E-3,null,"- обычного",{"$nulls":5},"0,56"]
["покрытие",null,"s","Вт/м²·ºC",{"$nulls":12},{"$f":"IF($F$9=\"жилое\",IF(P18<3,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"общественное\",IF(P18<4,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"производственное\",IF(P18<6,\"Dto..OK\",\"Dto<DTh\"))))","v":"Dto<DTh"},null,null,6,"Пенополистирол фирмы БАСФ Стиропор PS15",15,2,10,0.04,4.3999999999999997E-2,0.25,0.28999999999999998,3.5000000000000003E-2,null,"- с твердым селективным покрытием ",{"$nulls":5},"0,65"]
["...",null,"δ","м",null,0.22,2.5000000000000001E-2,4.9000000000000002E-2,null,null,{"$f":"\"Sd = \"&SUM(F20:J20)","v":"Sd = 0,294"},{"$nulls":8},7,"То же PS20",20,2,10,3.7999999999999999E-2,4.2000000000000003E-2,0.28000000000000003,0.33,0.03,null,"- с мягким селективным покрытием",{"$nulls":5},"0,72"]
[null,null,null,"Слой",null,"Fibo 3",{"$nulls":13},8,"» PS30",30,2,10,3.5999999999999997E-2,0.04,0.33,0.39,0.03,null,"- с твердым селективным покрытием и заполнением аргоном",{"$nulls":5},"0,69"]
["Внутрен стена",null,"λ","Вт/м·ºC",23,0.24,{"$nulls":4},8.6999999999999993,{"$f":"IF(F22=0,0,F24*F23/F22)+IF(G22=0,0,G24*G23/G22)+IF(H22=0,0,H24*H23/H22)+IF(J22=0,0,J24*J23/J22)","v":0},{"$f":"1/E22+IF(F22=0,0,F24/F22)+IF(G22=0,0,G24/G22)+IF(H22=0,0,H24/H22)+IF(I22=0,0,I24/I22)+IF(J22=0,0,J24/J22)+1/K22","v":0.78342078960519734},{"$f":"ROUND(1/M22,3)","v":1.276},{"$f":"IF(F9=\"общественное\",0.0004*G8+1.6,IF(F9=\"жилое\",0.0005*G8+2.2,IF(F9=\"производственное\",0.00025*G8+1.5,\"ошибка\")))","v":4.2832000000000008},{"$f":"($G$5-$G$4)/(M22*8.7)","v":5.8687504983653627},{"$f":"IF(O22>M22,\"Ro<Rreq\",\"Ro…OK\")","v":"Ro<Rreq"},null,null,9,"Пенополистирол",150,1,5,5.1999999999999998E-2,0.06,0.89,0.99,0.05,null,"7. Обычное стекло и двухкамерный стеклопакет в раздельных "]
[null,null,"s","Вт/м²·ºC",{"$nulls":12},{"$f":"IF($F$9=\"жилое\",IF(P22<2,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"общественное\",IF(P22<2.5,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"производственное\",IF(P22<2.5,\"Dto..OK\",\"Dto<DTh\"))))","v":"Dto<DTh"},null,null,10,"Пенополистирол",100,2,10,4.1000000000000002E-2,5.1999999999999998E-2,0.65,0.82,0.05,null,"переплетах из стекла:"]
[null,null,"δ","м",null,0.15,{"$nulls":4},{"$f":"\"Sd = \"&SUM(F24:J24)","v":"Sd = 0,15"},{"$nulls":8},11,"Пенополистирол (ГОСТ 15588)",40,2,10,4.1000000000000002E-2,0.05,0.41,0.49,0.05,null,"- обычного",{"$nulls":5},"0,68"]
[null,null,null,"Слой",null,"Минплита",{"$nulls":13},12,"Пенопласт ПХВ-1 и ПВ1",125,2,10,0.06,6.4000000000000001E-2,0.86,0.99,0.23,null,"- с твердым селективным покрытием ",{"$nulls":5},"0,74"]
["Чердачное",null,"λ","Вт/м·ºC",23,3.3000000000000002E-2,{"$nulls":4},8.6999999999999993,{"$f":"IF(F26=0,0,F28*F27/F26)+IF(G26=0,0,G28*G27/G26)+IF(H26=0,0,H28*H27/H26)+IF(J26=0,0,J28*J27/J26)","v":0},{"$f":"1/E26+IF(F26=0,0,F28/F26)+IF(G26=0,0,G28/G26)+IF(H26=0,0,H28/H26)+IF(I26=0,0,I28/I26)+IF(J26=0,0,J28/J26)+1/K26","v":9.2493298805142867},{"$f":"ROUND(1/M26,3)","v":0.108},{"$f":"IF(F9=\"общественное\",0.00035*G8+1.3,IF(F9=\"жилое\",0.00045*G8+1.9,IF(F9=\"производственное\",0.0002*G8+1,\"ошибка\")))","v":3.77488},{"$f":"($G$5-$G$4)/(M26*8.7)","v":0.49708478439193082},{"$f":"IF(O26>M26,\"Ro<Rreq\",\"Ro…OK\")","v":"Ro…OK"},null,null,13,"Пенопласт ПХВ-1 и ПВ1","100 и менее",2,10,0.05,5.1999999999999998E-2,6.8000000000000005E-2,0.8,0.23,null,"- с мягким селективным покрытием",{"$nulls":5},"0,81"]
["перекрытие",null,"s","Вт/м²·ºC",{"$nulls":12},{"$f":"IF($F$9=\"жилое\",IF(P26<2,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"общественное\",IF(P26<2.5,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"производственное\",IF(P26<2.5,\"Dto..OK\",\"Dto<DTh\"))))","v":"Dto..OK"},null,null,14,"Пенополиуретан",80,2,5,0.05,0.05,0.67,0.7,0.05,null,"- с твердым селективным покрытием и заполнением аргоном",{"$nulls":5},"0,82"]
[null,null,"δ","м",null,0.3,{"$nulls":4},{"$f":"\"Sd = \"&SUM(F28:J28)","v":"Sd = 0,3"},{"$nulls":8},15,"Пенополиуретан",60,2,5,4.1000000000000002E-2,4.1000000000000002E-2,0.53,0.55000000000000004,0.05,null,"8. Два однакамерных стеклопакета в спаренных переплетах",{"$nulls":5},0.7]
[null,null,"λ","Вт/м·ºC",23,{"$nulls":5},8.6999999999999993,{"$f":"IF(F29=0,0,F31*F30/F29)+IF(G29=0,0,G31*G30/G29)+IF(H29=0,0,H31*H30/H29)+IF(J29=0,0,J31*J30/J29)","v":0},{"$f":"1/E29+IF(F29=0,0,F31/F29)+IF(G29=0,0,G31/G29)+IF(H29=0,0,H31/H29)+IF(I29=0,0,I31/I29)+IF(J29=0,0,J31/J29)+1/K29","v":0.1584207896051974},{"$f":"ROUND(1/M29,3)","v":6.3120000000000003},{"$f":"ROUND(1/N29,3)","v":0.158},{"$f":"($G$5-$G$4)/(M29*8.7)","v":29.022082018927449},{"$f":"IF(O29>M29,\"Ro<Rreq\",\"Ro…OK\")","v":"Ro…OK"},null,null,16,"Пенополиуретан",40,2,5,0.04,0.04,0.4,0.42,0.05,null,"9. Два однакамерных стеклопакета в раздельных переплетах",{"$nulls":5},"0,74"]
[null,null,"s","Вт/м²·ºC",{"$nulls":12},{"$f":"IF($F$9=\"жилое\",IF(P29<4,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"общественное\",IF(P29<4.5,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"производственное\",IF(P29<4.5,\"Dto..OK\",\"Dto<DTh\"))))","v":"Dto<DTh"},null,null,17,"Плиты из резольно-формальдегидного пенопласта (ГОСТ 20916)",100,5,20,5.1999999999999998E-2,7.5999999999999998E-2,0.85,1.18,0.15,null,"10. Четырехслойное остекление в двух спаренных переплетах",{"$nulls":5},0.8]
[null,null,"δ","м",{"$nulls":6},{"$f":"\"Sd = \"&SUM(F31:J31)","v":"Sd = 0"},{"$nulls":8},18,"Плиты из резольно-формальдегидного пенопласта (ГОСТ 20916)",75,5,20,0.05,7.0000000000000007E-2,0.72,0.98,0.23]
[null,null,"λ","Вт/м·ºC",23,{"$nulls":5},8.6999999999999993,{"$f":"IF(F32=0,0,F34*F33/F32)+IF(G32=0,0,G34*G33/G32)+IF(H32=0,0,H34*H33/H32)+IF(J32=0,0,J34*J33/J32)","v":0},{"$f":"1/E32+IF(F32=0,0,F34/F32)+IF(G32=0,0,G34/G32)+IF(H32=0,0,H34/H32)+IF(I32=0,0,I34/I32)+IF(J32=0,0,J34/J32)+1/K32","v":0.1584207896051974},{"$f":"ROUND(1/M32,3)","v":6.3120000000000003},{"$f":"ROUND(1/N32,3)","v":0.158},{"$f":"($G$5-$G$4)/(M32*8.7)","v":29.022082018927449},{"$f":"IF(O32>M32,\"Ro<Rreq\",\"Ro…OK\")","v":"Ro…OK"},null,null,19,"Плиты из резольно-формальдегидного пенопласта (ГОСТ 20916)",50,5,20,0.05,6.4000000000000001E-2,0.59,0.77,0.23,null,"Примечания:"]
[null,null,"s","Вт/м²·ºC",{"$nulls":12},{"$f":"IF($F$9=\"жилое\",IF(P32<4,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"общественное\",IF(P32<4.5,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"производственное\",IF(P32<4.5,\"Dto..OK\",\"Dto<DTh\"))))","v":"Dto<DTh"},null,null,20,"Плиты из резольно-формальдегидного пенопласта (ГОСТ 20916)",40,5,20,4.1000000000000002E-2,0.06,0.48,0.66,0.23,null,"1. К мягким селективным покрытиям стекла относят покрытия с тепловой эмиссией менее 0,15, к твердым — более 0,15. "]
[null,null,"δ","м",{"$nulls":6},{"$f":"\"Sd = \"&SUM(F34:J34)","v":"Sd = 0"},{"$nulls":8},21,"Перлитопластбетон",200,2,3,5.1999999999999998E-2,0.06,0.93,1.01,8.0000000000000002E-3]
[null,null,"λ","Вт/м·ºC",23,{"$nulls":5},8.6999999999999993,{"$f":"IF(F35=0,0,F37*F36/F35)+IF(G35=0,0,G37*G36/G35)+IF(H35=0,0,H37*H36/H35)+IF(J35=0,0,J37*J36/J35)","v":0},{"$f":"1/E35+IF(F35=0,0,F37/F35)+IF(G35=0,0,G37/G35)+IF(H35=0,0,H37/H35)+IF(I35=0,0,I37/I35)+IF(J35=0,0,J37/J35)+1/K35","v":0.1584207896051974},{"$f":"ROUND(1/M35,3)","v":6.3120000000000003},{"$f":"ROUND(1/N35,3)","v":0.158},{"$f":"($G$5-$G$4)/(M35*8.7)","v":29.022082018927449},{"$f":"IF(O35>M35,\"Ro<Rreq\",\"Ro…OK\")","v":"Ro…OK"},null,null,22,"Перлитопластбетон",100,2,3,4.1000000000000002E-2,0.05,0.57999999999999996,0.66,8.0000000000000002E-3,null,"Значения приведенных сопротивлений теплопередаче заполнений световых проемов да-ны для случаев, когда отношение площади остекления к площади заполнения светового про-ема равно 0,75."]
[null,null,"s","Вт/м²·ºC",{"$nulls":12},{"$f":"IF($F$9=\"жилое\",IF(P35<4,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"общественное\",IF(P35<4.5,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"производственное\",IF(P35<4.5,\"Dto..OK\",\"Dto<DTh\"))))","v":"Dto<DTh"},null,null,23,"Перлитофосфогелевые изделия",300,3,12,0.08,0.12,1.43,2.02,0.2]
[null,null,"δ","м",{"$nulls":6},{"$f":"\"Sd = \"&SUM(F37:J37)","v":"Sd = 0"},{"$nulls":8},24,"Перлитофосфогелевые изделия",200,3,12,7.0000000000000007E-2,0.09,1.1000000000000001,1.43,0.23]
["Окна с дв. остекл.",{"$nulls":11},{"$f":"1/N38","v":0.90909090909090906},1.1000000000000001,{"$f":"IF(F9=\"общественное\",0.00005*G8+0.2,IF(F9=\"жилое\",IF(G8<6000,0.000075*G8+0.15,IF(G8<8000,0.00005*G8+0.3,IF(G8>8000,0.000025*G8+0.5,\"ошибка\"))),IF(F9=\"производственное\",0.0002*G8+1,\"ошибка\")))","v":0.46248},{"$f":"$G$5-($G$5-$G$4)/(M38*8)","v":12.5},{"$f":"IF(O38>M38,\"Ro<Rreq\",\"Ro…OK\")","v":"Ro…OK"},{"$f":"IF($F$9=\"жилое\",IF(P38>3,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"общественное\",IF(P38>3,\"Dto..OK\",\"Dto<DTh\"),IF($F$9=\"производственное\",IF(P38>0,\"Dto..OK\",\"Dto<DTh\"))))","v":"Dto..OK"},null,25,"Теплоизоляционные изделия из вспененного синтетического каучука «Аэрофлекс»",80,5,15,0.04,5.3999999999999999E-2,0.65,0.71,3.0000000000000001E-3,null,"2. Значения приведенных сопротивлений теплопередаче, указанных в таблице, допуска-ется применять в качестве расчетных при отсутствии этих значений в стандартах или техни-ческих условиях на конструкции или не подтвержденных результатами испытаний."]
["Двери наружные",{"$nulls":11},{"$f":"1/N39","v":1.1111111111111112},0.9,{"$f":"IF(F9=\"жилое\",0.6*(G5-G4)/(4*8.7),IF(F9=\"общественное\",0.6*(G5-G4)/(4.5*8.7),IF(F9=\"производственное\",0.6*(G5-G4)/(7*8.7),\"ошибка\")))","v":0.68965517241379315},null,{"$f":"IF(O39>M39,\"Ro<Rreq\",\"Ro…OK\")","v":"Ro…OK"},null,null,26,"Теплоизоляционные изделия из вспененного синтетического каучука"]
["Двери внутренние",{"$nulls":11},0.55000000000000004,{"$f":"1/M40","v":1.8181818181818181},{"$nulls":6},"«Кайманфлекс»; ЕС","60-80",0,0,3.9E-2,3.9E-2,0.6,0.6,0.01]
["Пол, 1 зона",null,"λ","Вт/м·ºC",null,3.9E-2,1.92,0.03,0.93,null,null,null,{"$f":"IF(F41=0,0,F42/F41)+IF(G41=0,0,G42/G41)+IF(H41=0,0,H42/H41)+IF(J41=0,0,J42/J41)+2.1","v":10.703766025641025},{"$f":"ROUND(1/M41,3)","v":9.2999999999999999E-2},{"$nulls":6},"ST","60-80",0,0,3.9E-2,3.9E-2,0.6,0.6,8.9999999999999993E-3,null,"3. Температура внутренней поверхности конструктивных элементов окон  зданий (кроме производственных) должна быть не ниже 3 оС при расчетной температуре наружного возду-ха."]
[null,null,"δ","м",null,0.3,0.15,2.5000000000000001E-2,4.9000000000000002E-2,{"$nulls":11},"ЕСО","60-95",0,0,4.1000000000000002E-2,4.1000000000000002E-2,0.65,0.65,0.01]
["Пол, 2 зона",null,"λ","Вт/м·ºC",null,3.9E-2,1.92,0.03,0.93,null,null,null,{"$f":"IF(F43=0,0,F44/F43)+IF(G43=0,0,G44/G43)+IF(H43=0,0,H44/H43)+IF(J43=0,0,J44/J43)+4.3","v":12.903766025641026},{"$f":"ROUND(1/M43,3)","v":7.6999999999999999E-2},{"$nulls":5},27,"Экструзионный пенополистирол «Пеноплэкс» (ТУ 5767-002-46261013), тип 35",35,2,3,2.9000000000000001E-2,0.03,0.36,0.37,1.7999999999999999E-2]
[null,null,"δ","м",null,0.3,0.15,2.5000000000000001E-2,4.9000000000000002E-2,{"$nulls":10},28,"То же, тип 45",45,2,3,3.1E-2,3.2000000000000001E-2,0.4,0.42,1.4999999999999999E-2]
["Пол, 3 зона",null,"λ","Вт/м·ºC",null,3.9E-2,1.92,0.03,0.93,null,null,null,{"$f":"IF(F45=0,0,F46/F45)+IF(G45=0,0,G46/G45)+IF(H45=0,0,H46/H45)+IF(J45=0,0,J46/J45)+8.6","v":17.203766025641023},{"$f":"ROUND(1/M45,3)","v":5.8000000000000003E-2},{"$nulls":5},"Б. Минераловатные (ГОСТ 4640), стекловолокнистые, пеностекло, газостекло"]
[null,null,"δ","м",null,0.3,0.15,2.5000000000000001E-2,4.9000000000000002E-2,{"$nulls":10},29,"Маты минераловатные прошивные (ГОСТ 21880) и на синтетическом связующем (ГОСТ 9573)",125,2,5,6.4000000000000001E-2,7.0000000000000007E-2,0.73,0.82,0.3]
["Пол, 4 зона",null,"λ","Вт/м·ºC",null,3.9E-2,1.92,0.03,0.93,null,null,null,{"$f":"IF(F47=0,0,F48/F47)+IF(G47=0,0,G48/G47)+IF(H47=0,0,H48/H47)+IF(J47=0,0,J48/J47)+14.2","v":22.803766025641025},{"$f":"ROUND(1/M47,3)","v":4.3999999999999997E-2},{"$nulls":5},30,"Маты минераловатные прошивные (ГОСТ 21880) и на синтетическом связующем (ГОСТ 9573)",75,2,5,0.06,6.4000000000000001E-2,0.55000000000000004,0.61,0.49]
[null,null,"δ","м",null,0.3,0.15,2.5000000000000001E-2,4.9000000000000002E-2,{"$nulls":10},31,"Маты минераловатные прошивные (ГОСТ 21880) и на синтетическом связующем (ГОСТ 9573)",50,2,5,5.1999999999999998E-2,0.06,0.42,0.48,0.53]
[{"$nulls":19},32,"Плиты мягкие, полужесткие и жесткие минераловатные на синтетическом и битумном связующих (ГОСТ 9573, ГОСТ 10140, ГОСТ 22950)",350,2,5,0.09,0.11,1.46,1.72,0.38]
[{"$nulls":19},33,"Плиты мягкие, полужесткие и жесткие минераловатные на синтетическом и битумном связующих (ГОСТ 9573, ГОСТ 10140, ГОСТ 22950)",300,2,5,8.6999999999999994E-2,0.09,1.32,1.44,0.41]
[{"$nulls":19},34,"Плиты мягкие, полужесткие и жесткие минераловатные на синтетическом и битумном связующих (ГОСТ 9573, ГОСТ 10140, ГОСТ 22950)",200,2,5,7.5999999999999998E-2,0.08,1.01,1.1100000000000001,0.49]
[{"$nulls":19},35,"Плиты мягкие, полужесткие и жесткие минераловатные на синтетическом и битумном связующих (ГОСТ 9573, ГОСТ 10140, ГОСТ 22950)",100,2,5,0.06,7.0000000000000007E-2,0.64,0.73,0.56000000000000005]
[{"$nulls":19},36,"Плиты мягкие, полужесткие и жесткие минераловатные на синтетическом и битумном связующих (ГОСТ 9573, ГОСТ 10140, ГОСТ 22950)",50,2,5,5.1999999999999998E-2,0.06,0.42,0.48,0.6]
[{"$nulls":19},37,"Плиты минераловатные повышенной жесткости на органофосфатном связующем",200,1,2,7.0000000000000007E-2,7.5999999999999998E-2,0.94,1.01,0.45]
[{"$nulls":19},38,"Плиты полужесткие минераловатные на крахмальном связующем",200,2,5,7.5999999999999998E-2,0.08,1.01,1.1100000000000001,0.38]
[{"$nulls":19},39,"Плиты полужесткие минераловатные на крахмальном связующем",125,2,5,0.06,6.4000000000000001E-2,0.7,0.78,0.38]
[{"$nulls":19},40,"Плиты из стеклянного штапельного волокна на синтетическом связующем (ГОСТ 10499)",50,2,5,0.06,6.4000000000000001E-2,0.44,0.5,0.6]
[{"$nulls":19},41,"Маты и полосы из стеклянного волокна прошивные",150,2,5,6.4000000000000001E-2,7.0000000000000007E-2,0.8,0.9,0.53]
[{"$nulls":19},42,"Пеностекло или газостекло",400,1,2,0.12,0.14000000000000001,1.76,1.94,0.02]
[{"$nulls":19},43,"Пеностекло или газостекло",300,1,2,0.11,0.12,1.46,1.56,0.02]
[{"$nulls":19},44,"Пеностекло или газостекло",200,1,2,0.08,0.09,1.01,1.1000000000000001,0.03]
[{"$nulls":19},"В. Плиты из природных органических и неорганических материалов"]
[{"$nulls":19},45,"Плиты древесно-волокнистые и древесно-стружечные (ГОСТ 4598, ГОСТ 8904, ГОСТ 10632)",1000,10,12,0.23,0.28999999999999998,6.75,7.7,0.12]
[{"$nulls":19},46,"То же",800,10,12,0.19,0.23,5.49,6.13,0.12]
[{"$nulls":19},47,"»",600,10,12,0.13,0.16,3.93,4.43,0.13]
[{"$nulls":19},48,"»",400,10,12,0.11,0.13,2.95,3.26,0.19]
[{"$nulls":19},49,"»",200,10,12,7.0000000000000007E-2,0.08,1.67,1.81,0.24]
[{"$nulls":19},50,"Плиты фибролитовые и арболит (ГОСТ 19222) на портландцементе",800,10,15,0.24,0.3,6.17,7.16,0.11]
[{"$nulls":19},51,"Плиты фибролитовые и арболит (ГОСТ 19222) на портландцементе",600,10,15,0.18,0.23,4.63,5.43,"0.11"]
[{"$nulls":19},52,"Плиты фибролитовые и арболит (ГОСТ 19222) на портландцементе",400,10,15,0.13,0.16,3.21,3.7,0.26]
[{"$nulls":19},53,"Плиты фибролитовые и арболит (ГОСТ 19222) на портландцементе",300,10,15,0.11,0.14000000000000001,2.56,2.99,0.3]
[{"$nulls":19},54,"Плиты камышитовые",300,10,15,0.09,0.14000000000000001,2.31,2.99,0.45]
[{"$nulls":19},55,"Плиты камышитовые",200,10,15,7.0000000000000007E-2,0.09,1.67,1.96,0.49]
[{"$nulls":19},56,"Плиты торфяные теплоизоляционные",300,15,20,7.0000000000000007E-2,0.08,2.12,2.34,0.19]
[{"$nulls":19},57,"Плиты торфяные теплоизоляционные",200,15,20,0.06,6.4000000000000001E-2,1.6,1.71,0.49]
[{"$nulls":19},58,"Пакля",150,7,12,0.06,7.0000000000000007E-2,1.3,1.47,0.49]
[{"$nulls":19},59,"Плиты из гипса (ГОСТ 6428)",1200,4,6,0.41,0.47,6.01,6.7,9.8000000000000004E-2]
[{"$nulls":19},60,"Плиты из гипса (ГОСТ 6428)",1000,4,6,0.28999999999999998,0.35,4.62,5.28,0.11]
[{"$nulls":19},61,"Листы гипсовые обшивочные (сухая штукатурка) (ГОСТ 6266)",800,4,6,0.19,0.21,3.34,3.66,7.4999999999999997E-2]
[{"$nulls":19},62,"Изделия из вспученного перлита на битумном связующем (ГОСТ 16136)",400,1,2,0.12,0.13,2.4500000000000002,2.59,0.04]
[{"$nulls":19},63,"То же",300,1,2,0.09,9.9000000000000005E-2,1.84,1.95,0.04]
[{"$nulls":19},"Г. Засыпки"]
[{"$nulls":19},64,"Гравий керамзитовый (ГОСТ 9757)",800,2,3,0.21,0.23,3.36,3.6,0.21]
[{"$nulls":19},65,"Гравий керамзитовый (ГОСТ 9757)",600,2,3,0.17,0.2,2.62,2.91,0.23]
[{"$nulls":19},66,"Гравий керамзитовый (ГОСТ 9757)",400,2,3,0.13,0.14000000000000001,1.87,1.99,0.24]
[{"$nulls":19},67,"Гравий керамзитовый (ГОСТ 9757)",300,2,3,0.12,0.13,1.56,1.66,0.25]
[{"$nulls":19},68,"Гравий керамзитовый (ГОСТ 9757)",200,2,3,0.11,0.12,1.22,1.3,0.26]
[{"$nulls":19},69,"Гравий шунгизитовый (ГОСТ 9757)",800,2,4,0.2,0.23,3.28,3.68,0.21]
[{"$nulls":19},70,"Гравий шунгизитовый (ГОСТ 9757)",600,2,4,0.16,0.2,2.54,2.97,0.22]
[{"$nulls":19},71,"Гравий шунгизитовый (ГОСТ 9757)",400,2,4,0.13,0.14000000000000001,1.87,2.0299999999999998,0.23]
[{"$nulls":19},72,"Щебень из доменного шлака (ГОСТ 5578), шлаковой пемзы и аглопорита (ГОСТ 9757)",800,2,3,0.21,0.26,3.36,3.83,0.21]
[{"$nulls":19},73,"То же",600,2,3,0.18,0.21,2.7,2.98,0.23]
[{"$nulls":19},74,"»",400,2,3,0.14000000000000001,0.16,1.94,2.12,0.24]
[{"$nulls":19},75,"Щебень и песок из перлита вспученного (ГОСТ 10832)",600,1,2,0.111,0.12,2.0699999999999998,2.2000000000000002,0.26]
[{"$nulls":19},76,"То же",400,1,2,8.6999999999999994E-2,0.09,1.5,1.56,0.3]
[{"$nulls":19},77,"»",200,1,2,7.5999999999999998E-2,0.08,0.99,1.04,0.34]
[{"$nulls":19},78,"Вермикулит вспученный (ГОСТ 12865)",200,1,3,0.09,0.11,1.08,1.24,0.23]
[{"$nulls":19},79,"Вермикулит вспученный (ГОСТ 12865)",100,1,3,7.5999999999999998E-2,0.08,0.7,0.75,0.3]
[{"$nulls":19},80,"Песок для строительных работ (ГОСТ 8736)",1600,1,2,0.47,0.57999999999999996,6.95,7.91,0.17]
[{"$nulls":19},"Д. Тёплые растворы (ГОСТ 28013)"]
[{"$nulls":19},81,"Цементно-шлаковый",1400,2,4,0.52,0.64,7,8.11,0.11]
[{"$nulls":19},82,"Цементно-шлаковый",1200,2,4,0.47,0.57999999999999996,6.16,7.15,0.14000000000000001]
[{"$nulls":19},83,"Цементно-перлитовый",1000,7,12,0.26,0.3,4.6399999999999997,5.42,0.15]
[{"$nulls":19},84,"Цементно-перлитовый",800,7,12,0.21,0.26,3.73,4.51,0.16]
[{"$nulls":19},85,"Гипсоперлитовый",600,10,15,0.19,0.23,3.24,3.84,0.17]
[{"$nulls":19},86,"Поризованный гипсоперлитовый",500,6,10,0.15,0.19,2.44,2.95,0.43]
[{"$nulls":19},87,"Поризованный гипсоперлитовый",400,6,10,0.13,0.15,2.0299999999999998,2.35,0.53]
[{"$nulls":19},"IІ Конструкционно-теплоизоляционные материалы"]
[{"$nulls":19},"А. Бетоны на природных пористых заполнителях (ГОСТ 25820, ГОСТ 22263)"]
[{"$nulls":19},88,"Туфобетон",1800,7,10,0.87,0.99,11.38,12.79,0.09]
[{"$nulls":19},89,"Туфобетон",1600,7,10,0.7,0.81,9.6199999999999992,10.91,0.11]
[{"$nulls":19},90,"Туфобетон",1400,7,10,0.52,0.57999999999999996,7.76,8.6300000000000008,0.11]
[{"$nulls":19},91,"Туфобетон",1200,7,10,0.41,0.47,6.38,7.2,0.12]
[{"$nulls":19},92,"Пемзобетон",1600,4,6,0.62,0.68,8.5399999999999991,9.3000000000000007,7.4999999999999997E-2]
[{"$nulls":19},93,"Пемзобетон",1400,4,6,0.49,0.54,7.1,7.76,8.3000000000000004E-2]
[{"$nulls":19},94,"Пемзобетон",1200,4,6,0.4,0.43,5.94,6.41,9.8000000000000004E-2]
[{"$nulls":19},95,"Пемзобетон",1000,4,6,0.3,0.34,4.6900000000000004,5.2,0.11]
[{"$nulls":19},96,"Пемзобетон",800,4,6,0.22,0.26,3.6,4.07,0.12]
[{"$nulls":19},97,"Бетон на вулканическом шлаке",1600,7,10,0.64,0.7,9.1999999999999993,10.14,7.4999999999999997E-2]
[{"$nulls":19},98,"Бетон на вулканическом шлаке",1400,7,10,0.52,0.57999999999999996,7.76,8.6300000000000008,8.3000000000000004E-2]
[{"$nulls":19},99,"Бетон на вулканическом шлаке",1200,7,10,0.41,0.47,6.38,7.2,0.09]
[{"$nulls":19},100,"Бетон на вулканическом шлаке",1000,7,10,0.28999999999999998,0.35,4.9000000000000004,5.67,9.8000000000000004E-2]
[{"$nulls":19},101,"Бетон на вулканическом шлаке",800,7,10,0.23,0.28999999999999998,3.9,4.6100000000000003,0.11]
[{"$nulls":19},"Б. Бетоны на искусственных пористых заполнителях (ГОСТ 25820, ГОСТ 9757)"]
[{"$nulls":19},102,"Керамзитобетон на керамзитовом песке и керамзитопенобетон",1800,5,10,0.8,0.92,10.5,12.33,0.09]
[{"$nulls":19},103,"Керамзитобетон на керамзитовом песке и керамзитопенобетон",1600,5,10,0.67,0.79,9.06,10.77,0.09]
[{"$nulls":19},104,"Керамзитобетон на керамзитовом песке и керамзитопенобетон",1400,5,10,0.56000000000000005,0.65,7.75,9.14,9.8000000000000004E-2]
[{"$nulls":19},105,"Керамзитобетон на керамзитовом песке и керамзитопенобетон",1200,5,10,0.44,0.52,6.36,7.57,0.11]
[{"$nulls":19},106,"Керамзитобетон на керамзитовом песке и керамзитопенобетон",1000,5,10,0.33,0.41,5.03,6.13,0.14000000000000001]
[{"$nulls":19},107,"Керамзитобетон на керамзитовом песке и керамзитопенобетон",800,5,10,0.24,0.31,3.83,4.7699999999999996,0.19]
[{"$nulls":19},108,"Керамзитобетон на керамзитовом песке и керамзитопенобетон",600,5,10,0.2,0.26,3.03,3.78,0.26]
[{"$nulls":19},109,"Керамзитобетон на керамзитовом песке и керамзитопенобетон",500,5,10,0.17,0.23,2.5499999999999998,3.25,0.3]
[{"$nulls":19},110,"Керамзитобетон на кварцевом песке с поризацией",1200,4,8,0.52,0.57999999999999996,6.77,7.72,7.4999999999999997E-2]
[{"$nulls":19},111,"Керамзитобетон на кварцевом песке с поризацией",1000,4,8,0.41,0.47,5.49,6.35,7.4999999999999997E-2]
[{"$nulls":19},112,"Керамзитобетон на кварцевом песке с поризацией",800,4,8,0.28999999999999998,0.35,4.13,4.9000000000000004,7.4999999999999997E-2]
[{"$nulls":19},113,"Керамзитобетон на перлитовом песке",1000,9,13,0.35,0.41,5.57,6.43,0.15]
[{"$nulls":19},114,"Керамзитобетон на перлитовом песке",800,9,13,0.28999999999999998,0.35,4.54,5.32,0.17]
[{"$nulls":19},115,"Шунгизитобетон",1400,4,7,0.56000000000000005,0.64,7.59,8.6,9.8000000000000004E-2]
[{"$nulls":19},116,"Шунгизитобетон",1200,4,7,0.44,0.5,6.23,7.04,0.11]
[{"$nulls":19},117,"Шунгизитобетон",1000,4,7,0.33,0.38,4.92,5.6,0.14000000000000001]
[{"$nulls":19},118,"Перлитобетон",1200,10,15,0.44,0.5,6.96,8.01,0.15]
[{"$nulls":19},119,"Перлитобетон",1000,10,15,0.33,0.38,5.5,6.38,0.19]
[{"$nulls":19},120,"Перлитобетон",800,10,15,0.27,0.33,4.45,5.32,0.26]
[{"$nulls":19},121,"Перлитобетон",600,10,15,0.19,0.23,"2024-03-01",3.84,0.3]
[{"$nulls":19},122,"Шлакопемзобетон (термозитобетон)",1800,5,8,0.63,0.76,9.32,10.83,7.4999999999999997E-2]
[{"$nulls":19},123,"Шлакопемзобетон (термозитобетон)",1600,5,8,0.52,0.63,7.98,9.2899999999999991,0.09]
[{"$nulls":19},124,"Шлакопемзобетон (термозитобетон)",1400,5,8,0.44,0.52,6.87,7.9,9.8000000000000004E-2]
[{"$nulls":19},125,"Шлакопемзобетон (термозитобетон)",1200,5,8,0.37,0.44,5.83,6.73,0.11]
[{"$nulls":19},126,"Шлакопемзобетон (термозитобетон)",1000,5,8,0.31,0.37,4.87,5.63,0.11]
[{"$nulls":19},127,"Шлакопемзопено- и шлакопемзогазобетон",1600,8,11,0.63,"0.7",9.2899999999999991,10.31,0.09]
[{"$nulls":19},128,"Шлакопемзопено- и шлакопемзогазобетон",1400,8,11,0.52,0.57999999999999996,7.9,8.7799999999999994,9.8000000000000004E-2]
[{"$nulls":19},129,"Шлакопемзопено- и шлакопемзогазобетон",1200,8,11,0.41,0.47,6.49,7.31,0.11]
[{"$nulls":19},130,"Шлакопемзопено- и шлакопемзогазобетон",1000,8,11,0.35,0.41,5.48,6.24,0.11]
[{"$nulls":19},131,"Шлакопемзопено- и шлакопемзогазобетон",800,8,11,0.28999999999999998,0.35,4.46,5.15,0.13]
[{"$nulls":19},132,"Бетон на доменных гранулированных шлаках",1800,5,8,0.7,0.81,9.82,11.18,8.3000000000000004E-2]
[{"$nulls":19},133,"Бетон на доменных гранулированных шлаках",1600,5,8,0.57999999999999996,0.64,8.43,9.3699999999999992,0.09]
[{"$nulls":19},134,"Бетон на доменных гранулированных шлаках",1400,5,8,0.52,0.57999999999999996,7.46,8.34,9.8000000000000004E-2]
[{"$nulls":19},135,"Бетон на доменных гранулированных шлаках",1200,5,8,0.47,0.52,6.57,7.31,0.11]
[{"$nulls":19},136,"Аглопоритобетон и бетоны на топливных (котельных) шлаках",1800,5,8,0.85,0.93,10.82,11.98,7.4999999999999997E-2]
[{"$nulls":19},137,"Аглопоритобетон и бетоны на топливных (котельных) шлаках",1600,5,8,0.72,0.78,9.39,10.34,8.3000000000000004E-2]
[{"$nulls":19},138,"Аглопоритобетон и бетоны на топливных (котельных) шлаках",1400,5,8,0.59,0.65,7.92,8.83,0.09]
[{"$nulls":19},139,"Аглопоритобетон и бетоны на топливных (котельных) шлаках",1200,5,8,0.48,0.54,6.64,7.45,0.11]
[{"$nulls":19},140,"Аглопоритобетон и бетоны на топливных (котельных) шлаках",1000,5,8,0.38,0.44,5.39,6.14,0.14000000000000001]
[{"$nulls":19},141,"Бетон на зольном гравии",1400,5,8,0.52,0.57999999999999996,7.46,8.34,0.09]
[{"$nulls":19},142,"Бетон на зольном гравии",1200,5,8,0.41,0.47,6.14,6.95,0.11]
[{"$nulls":19},143,"Бетон на зольном гравии",1000,5,8,0.3,0.35,4.79,5.48,0.12]
[{"$nulls":19},144,"Вермикулитобетон",800,8,13,0.23,0.26,3.97,4.58,"-"]
[{"$nulls":19},145,"Вермикулитобетон",600,8,13,0.16,0.17,2.87,3.21,0.15]
[{"$nulls":19},146,"Вермикулитобетон",400,8,13,0.11,0.13,1.94,2.29,0.19]
[{"$nulls":19},147,"Вермикулитобетон",300,8,13,0.09,0.11,1.52,1.83,0.23]
[{"$nulls":19},148,"Полистиролбетон (ТУ 5741-159-002 84807, ТУ 5760-160-0284807)",600,4,8,0.17499999999999999,0.2,3.07,3.49,6.8000000000000005E-2]
[{"$nulls":19},149,"Полистиролбетон (ТУ 5741-159-002 84807, ТУ 5760-160-0284807)",500,4,8,0.14000000000000001,0.16,2.5,2.85,7.4999999999999997E-2]
[{"$nulls":19},150,"Полистиролбетон (ТУ 5741-159-002 84807, ТУ 5760-160-0284807)",400,4,8,0.12,0.13500000000000001,2.0699999999999998,2.34,8.5000000000000006E-2]
[{"$nulls":19},151,"Полистиролбетон (ТУ 5741-159-002 84807, ТУ 5760-160-0284807)",300,4,8,0.09,0.11,1.55,1.83,0.1]
[{"$nulls":19},152,"Полистиролбетон (ТУ 5741-159-002 84807, ТУ 5760-160-0284807)",200,4,8,7.0000000000000007E-2,0.08,1.1200000000000001,1.28,0.12]
[{"$nulls":19},153,"Полистиролбетон (ТУ 5741-159-002 84807, ТУ 5760-160-0284807)",150,4,8,5.7000000000000002E-2,0.06,0.87,0.96,0.13500000000000001]
[{"$nulls":19},"В. Бетоны ячеистые (ГОСТ 25485, ГОСТ 5742)"]
[{"$nulls":19},154,"Газо- и пенобетон, газо- и пеносиликат",1000,10,15,0.41,0.47,6.13,7.09,0.11]
[{"$nulls":19},155,"Газо- и пенобетон, газо- и пеносиликат",800,10,15,0.33,0.37,4.92,5.63,0.14000000000000001]
[{"$nulls":19},156,"Газо- и пенобетон, газо- и пеносиликат",600,8,12,0.22,0.26,3.36,3.91,0.17]
[{"$nulls":19},157,"Газо- и пенобетон, газо- и пеносиликат",400,8,12,0.14000000000000001,0.15,2.19,2.42,0.23]
[{"$nulls":19},158,"Газо- и пенобетон, газо- и пеносиликат",300,8,12,0.11,0.13,1.68,1.95,0.26]
[{"$nulls":19},159,"Газо- и пенозолобетон",1200,15,22,0.52,0.57999999999999996,8.17,9.4600000000000009,7.4999999999999997E-2]
[{"$nulls":19},160,"Газо- и пенозолобетон",1000,15,22,0.44,0.5,6.86,8.01,9.8000000000000004E-2]
[{"$nulls":19},161,"Газо- и пенозолобетон",800,15,22,0.35,0.41,5.48,6.49,0.12]
[{"$nulls":19},"Г. Кирпичная кладка из сплошного кирпича"]
[{"$nulls":19},162,"Глиняного обыкновенного (ГОСТ 530) на цементно-песчаном растворе",1800,1,2,0.7,0.81,9.1999999999999993,10.119999999999999,0.11]
[{"$nulls":19},163,"Глиняного обыкновенного на цементно-шлаковом растворе",1700,1.5,3,0.64,0.76,8.64,9.6999999999999993,0.12]
[{"$nulls":19},164,"Глиняного обыкновенного на цементно-перлитовом растворе",1600,2,4,0.57999999999999996,0.7,8.08,9.23,0.15]
[{"$nulls":19},165,"Силикатного (ГОСТ 379) на цементно-песчаном растворе",1800,2,4,0.76,0.87,9.77,10.9,0.11]
[{"$nulls":19},166,"Трепельного (ГОСТ 530) на цементно-песчаном растворе",1200,2,4,0.47,0.52,6.26,6.49,0.19]
[{"$nulls":19},167,"Трепельного (ГОСТ 530) на цементно-песчаном растворе",1000,2,4,0.41,0.47,5.35,5.96,0.23]
[{"$nulls":19},168,"Шлакового на цементно-песчаном растворе",1500,1.5,3,0.64,0.7,8.1199999999999992,8.76,0.11]
[{"$nulls":19},"Д. Кирпичная кладка из пустотного кирпича"]
[{"$nulls":19},169,"Керамического пустотного плотностью 1400 кг/м3 (брутто) на цементно-песчаном растворе",1600,1,2,0.57999999999999996,0.64,7.91,8.48,0.14000000000000001]
[{"$nulls":19},170,"Керамического пустотного плотностью 1300 кг/м3 (брутто) на цементно-песчаном растворе",1400,1,2,0.52,0.57999999999999996,7.01,7.56,0.16]
[{"$nulls":19},171,"Керамического пустотного плотностью 1000 кг/м3 (брутто) на цементно-песчаном растворе",1200,1,2,0.47,0.52,6.16,6.62,0.17]
[{"$nulls":19},172,"Силикатного одиннадцатипустотного (ГОСТ 379) на цементно-песчаном растворе",1500,2,4,0.7,0.81,8.59,9.6300000000000008,0.13]
[{"$nulls":19},173,"Силикатного четырнадцатипустотного (ГОСТ 379) на цементно-песчаном растворе",1400,2,4,0.64,0.76,7.93,9.01,0.14000000000000001]
[{"$nulls":19},"Е. Дерево и изделия из него"]
[{"$nulls":19},174,"Сосна и ель поперек волокон (ГОСТ 8486, ГОСТ 9463)",500,15,20,0.14000000000000001,0.18,3.87,4.54,0.06]
[{"$nulls":19},175,"Сосна и ель вдоль волокон",500,15,20,0.28999999999999998,0.35,5.56,6.33,0.32]
[{"$nulls":19},176,"Дуб поперек волокон (ГОСТ 9462, ГОСТ 2695)",700,10,15,0.18,0.23,5,5.86,0.05]
[{"$nulls":19},177,"Дуб вдоль волокон",700,10,15,0.35,0.41,6.9,7.83,0.3]
[{"$nulls":19},178,"Фанера клееная (ГОСТ 8673)",600,10,13,0.15,0.18,4.22,4.7300000000000004,0.02]
[{"$nulls":19},179,"Картон облицовочный (ГОСТ 8740)",1000,5,10,0.21,0.23,6.2,6.75,0.06]
[{"$nulls":19},180,"Картон строительный многослойный",650,6,12,0.15,0.18,4.26,4.8899999999999997,8.3000000000000004E-2]
[{"$nulls":19},"IІІ Конструкционные материалы"]
[{"$nulls":19},"А. Бетоны (ГОСТ 7473, ГОСТ 25192) и растворы (ГОСТ 28013)"]
[{"$nulls":19},181,"Железобетон (ГОСТ 26633)",2500,2,3,1.92,2.04,17.98,18.95,0.03]
[{"$nulls":19},182,"Бетон на гравии или щебне из природного камня (ГОСТ 26633)",2400,2,3,1.74,1.86,16.77,17.88,0.03]
[{"$nulls":19},183,"Раствор цементно-песчаный",1800,2,4,0.76,0.93,9.6,11.09,0.09]
[{"$nulls":19},184,"Раствор сложный (песок, известь, цемент)",1700,2,4,0.7,0.87,8.9499999999999993,10.42,9.8000000000000004E-2]
[{"$nulls":19},185,"Раствор известково-песчаный",1600,2,4,0.7,0.81,8.69,9.76,0.12]
[{"$nulls":19},"Б. Облицовка природным камнем (ГОСТ 9480)"]
[{"$nulls":19},186,"Гранит, гнейс и базальт",2800,0,0,3.49,3.49,25.04,25.04,8.0000000000000002E-3]
[{"$nulls":19},187,"Мрамор",2800,0,0,2.91,2.91,22.86,22.86,8.0000000000000002E-3]
[{"$nulls":19},188,"Известняк",2000,2,3,1.1599999999999999,1.28,12.77,13.7,0.06]
[{"$nulls":19},189,"Известняк",1800,2,3,0.93,1.05,10.85,11.77,7.4999999999999997E-2]
[{"$nulls":19},190,"Известняк",1600,2,3,0.73,0.81,9.06,9.75,0.09]
[{"$nulls":19},191,"Известняк",1400,2,3,0.56000000000000005,0.57999999999999996,7.42,7.72,0.11]
[{"$nulls":19},192,"Туф",2000,3,5,0.93,1.05,11.68,12.92,7.4999999999999997E-2]
[{"$nulls":19},193,"Туф",1800,3,5,0.7,0.81,9.61,10.76,8.3000000000000004E-2]
[{"$nulls":19},194,"Туф",1600,3,5,0.52,0.64,7.81,9.02,0.09]
[{"$nulls":19},195,"Туф",1400,3,5,0.43,0.52,6.64,7.6,9.8000000000000004E-2]
[{"$nulls":19},196,"Туф",1200,3,5,0.35,0.41,5.55,6.25,0.11]
[{"$nulls":19},197,"Туф",1000,3,5,0.24,0.28999999999999998,4.2,4.8,0.11]
[{"$nulls":19},"В. Материалы кровельные, гидроизоляционные, облицовочные и рулонные покрытия для полов (ГОСТ 23835, ГОСТ 30547)"]
[{"$nulls":19},198,"Листы асбестоцементные плоские (ГОСТ 18124)",1800,2,3,0.47,0.52,7.55,8.1199999999999992,0.03]
[{"$nulls":19},199,"Листы асбестоцементные плоские (ГОСТ 18124)",1600,2,3,0.35,0.41,6.14,6.8,0.03]
[{"$nulls":19},200,"Битумы нефтяные строительные и кровельные (ГОСТ 6617, ГОСТ 9548)",1400,0,0,0.27,0.27,6.8,6.8,8.0000000000000002E-3]
[{"$nulls":19},201,"Битумы нефтяные строительные и кровельные (ГОСТ 6617, ГОСТ 9548)",1200,0,0,0.22,0.22,5.69,5.69,8.0000000000000002E-3]
[{"$nulls":19},202,"Битумы нефтяные строительные и кровельные (ГОСТ 6617, ГОСТ 9548)",1000,0,0,0.17,0.17,4.5599999999999996,4.5599999999999996,8.0000000000000002E-3]
[{"$nulls":19},203,"Асфальтобетон (ГОСТ 9128)",2100,0,0,1.05,1.05,16.43,16.43,8.0000000000000002E-3]
[{"$nulls":19},204,"Рубероид (ГОСТ 10923), пергамин (ГОСТ 2697), толь",600,0,0,0.17,0.17,3.53,3.53,"-"]
[{"$nulls":19},205,"Линолеум поливинилхлоридный на теплоизолирующей подоснове (ГОСТ 18108)",1800,0,0,0.38,0.38,8.56,8.56,2E-3]
[{"$nulls":19},206,"Линолеум поливинилхлоридный на теплоизолирующей подоснове (ГОСТ 18108)",1600,0,0,0.33,0.33,7.52,7.52,2E-3]
[{"$nulls":19},207,"Линолеум поливинилхлоридный на тканевой основе (ГОСТ 7251)",1800,0,0,0.35,0.35,8.2200000000000006,8.2200000000000006,2E-3]
[{"$nulls":19},208,"Линолеум поливинилхлоридный на тканевой основе (ГОСТ 7251)",1600,0,0,0.28999999999999998,0.28999999999999998,7.05,7.05,2E-3]
[{"$nulls":19},209,"Линолеум поливинилхлоридный на тканевой основе (ГОСТ 7251)",1400,0,0,0.23,0.23,5.87,5.87,2E-3]
[{"$nulls":19},"Г. Металлы и стекло"]
[{"$nulls":19},210,"Сталь стержневая арматурная (ГОСТ 10884, ГОСТ 5781)",7850,0,0,58,58,126.5,126.5,0]
[{"$nulls":19},211,"Чугун (ГОСТ 9583)",7200,0,0,50,50,112.5,112.5,0]
[{"$nulls":19},212,"Алюминий (ГОСТ 22233, ГОСТ 24767)",2600,0,0,221,221,187.6,187.6,0]
[{"$nulls":19},213,"Медь (ГОСТ 931, ГОСТ 15527)",8500,0,0,407,407,326,326,0]
[{"$nulls":19},214,"Стекло оконное (ГОСТ 111)",2500,0,0,0.76,0.76,10.79,10.79,0]
[{"$nulls":19},"Примечания"]
[{"$nulls":19},"1. Расчетные значения коэффициента теплоусвоения (при периоде 24 ч) материала в конструкции вычислены по формуле"]
[{"$nulls":19},"s = 0,27 √λρ0(c0 + 0,0419w)"]
[{"$nulls":19},"где λ, ρ0, с0, w - принимают по соответствующим графам настоящей таблицы."]
[{"$nulls":19},"2. Характеристики материалов в сухом состоянии приведены при массовом отношении влаги в материале w, %, равном нулю."]

{"sheet":"ТП","index":1,"n_rows":177,"n_cols":21,"rows_kept":177,"cut":false,"hidden":false,"merged":[[129,1,129,3],[130,1,130,3],[131,1,131,3],[132,1,132,3],[134,1,134,3],[135,1,135,3],[136,1,136,3],[137,0,137,20],[34,0,34,19],[113,1,113,3],[114,1,114,3],[116,1,116,3],[117,1,117,3],[118,1,118,3],[119,1,119,3],[120,1,120,3],[122,1,122,3],[528,1,528,3],[529,1,529,3],[516,1,516,3],[517,1,517,3],[518,1,518,3],[519,1,519,3],[520,1,520,3],[522,1,522,3],[537,1,537,3],[510,1,510,3],[511,1,511,3],[512,0,512,20],[513,1,513,3],[514,1,514,3],[523,1,523,3],[524,1,524,3],[525,1,525,3],[526,1,526,3],[499,1,499,3],[491,1,491,3],[492,1,492,3],[493,1,493,3],[494,1,494,3],[505,1,505,3],[506,1,506,3],[507,1,507,3],[509,1,509,3],[500,1,500,3],[501,1,501,3],[503,1,503,3],[504,1,504,3],[488,1,488,3],[489,1,489,3],[481,1,481,3],[482,1,482,3],[483,1,483,3],[485,1,485,3],[495,1,495,3],[497,1,497,3],[498,1,498,3],[477,1,477,3],[479,1,479,3],[480,1,480,3],[471,1,471,3],[473,1,473,3],[474,1,474,3],[475,1,475,3],[486,1,486,3],[487,1,487,3],[467,1,467,3],[468,1,468,3],[469,1,469,3],[470,1,470,3],[462,1,462,3],[463,1,463,3],[464,1,464,3],[465,1,465,3],[476,1,476,3],[451,1,451,3],[443,1,443,3],[444,1,444,3],[445,1,445,3],[446,1,446,3],[457,1,457,3],[458,1,458,3],[459,1,459,3],[461,1,461,3],[452,1,452,3],[453,1,453,3],[455,1,455,3],[456,1,456,3],[440,1,440,3],[441,1,441,3],[433,1,433,3],[434,1,434,3],[435,1,435,3],[437,1,437,3],[447,1,447,3],[449,1,449,3],[450,1,450,3],[429,1,429,3],[431,1,431,3],[432,1,432,3],[423,1,423,3],[425,1,425,3],[426,1,426,3],[427,1,427,3],[438,1,438,3],[439,1,439,3],[419,1,419,3],[420,1,420,3],[421,1,421,3],[422,1,422,3],[414,1,414,3],[415,1,415,3],[416,1,416,3],[417,1,417,3],[428,1,428,3],[403,1,403,3],[395,1,395,3],[396,1,396,3],[397,1,397,3],[398,1,398,3],[409,1,409,3],[410,1,410,3],[411,1,411,3],[413,1,413,3],[404,1,404,3],[405,1,405,3],[407,1,407,3],[408,1,408,3],[392,1,392,3],[393,1,393,3],[385,1,385,3],[386,1,386,3],[387,1,387,3],[389,1,389,3],[399,1,399,3],[401,1,401,3],[402,1,402,3],[381,1,381,3],[383,1,383,3],[384,1,384,3],[375,1,375,3],[377,1,377,3],[378,1,378,3],[379,1,379,3],[390,1,390,3],[391,1,391,3],[371,1,371,3],[372,1,372,3],[373,1,373,3],[374,1,374,3],[366,1,366,3],[367,0,367,20],[368,1,368,3],[369,1,369,3],[380,1,380,3],[355,1,355,3],[347,1,347,3],[348,1,348,3],[349,1,349,3],[350,1,350,3],[361,1,361,3],[362,1,362,3],[364,1,364,3],[365,1,365,3],[356,1,356,3],[358,1,358,3],[359,1,359,3],[360,1,360,3],[344,1,344,3],[346,1,346,3],[337,1,337,3],[338,1,338,3],[340,1,340,3],[341,1,341,3],[352,1,352,3],[353,1,353,3],[354,1,354,3],[334,1,334,3],[335,1,335,3],[336,1,336,3],[328,1,328,3],[329,1,329,3],[330,1,330,3],[331,1,331,3],[342,1,342,3],[343,1,343,3],[323,1,323,3],[324,1,324,3],[325,1,325,3],[326,1,326,3],[318,1,318,3],[319,1,319,3],[320,1,320,3],[322,1,322,3],[332,1,332,3],[307,1,307,3],[299,1,299,3],[300,1,300,3],[301,1,301,3],[302,1,302,3],[313,1,313,3],[314,1,314,3],[316,1,316,3],[317,1,317,3],[308,1,308,3],[310,1,310,3],[311,1,311,3],[312,1,312,3],[296,1,296,3],[298,1,298,3],[289,1,289,3],[290,1,290,3],[292,1,292,3],[293,1,293,3],[304,1,304,3],[305,1,305,3],[306,1,306,3],[286,1,286,3],[287,1,287,3],[288,1,288,3],[280,1,280,3],[281,1,281,3],[282,1,282,3],[283,1,283,3],[294,1,294,3],[295,1,295,3],[275,1,275,3],[276,1,276,3],[277,1,277,3],[278,1,278,3],[270,1,270,3],[271,1,271,3],[272,1,272,3],[274,1,274,3],[284,1,284,3],[259,1,259,3],[251,1,251,3],[252,1,252,3],[253,1,253,3],[254,1,254,3],[265,1,265,3],[266,1,266,3],[268,1,268,3],[269,1,269,3],[260,1,260,3],[262,1,262,3],[263,1,263,3],[264,1,264,3],[248,1,248,3],[250,1,250,3],[241,1,241,3],[242,1,242,3],[244,1,244,3],[245,1,245,3],[256,1,256,3],[257,1,257,3],[258,1,258,3],[238,1,238,3],[239,1,239,3],[240,1,240,3],[232,1,232,3],[233,1,233,3],[234,1,234,3],[235,1,235,3],[246,1,246,3],[247,1,247,3],[227,1,227,3],[228,1,228,3],[229,1,229,3],[230,1,230,3],[221,1,221,3],[222,0,222,20],[223,1,223,3],[224,1,224,3],[236,1,236,3],[226,1,226,3],[3,3,3,11],[86,1,86,3],[81,1,81,3],[79,1,79,3],[97,1,97,3],[91,1,91,3],[92,1,92,3],[88,1,88,3],[0,3,0,16],[26,0,26,20],[93,1,93,3],[94,1,94,3],[95,1,95,3],[13,14,13,15],[8,14,8,15],[15,14,15,15],[20,14,20,15],[23,14,23,15],[16,14,16,15],[17,14,17,15],[18,14,18,15],[14,14,14,15],[19,14,19,15],[15,3,15,10],[16,3,16,10],[13,3,13,10],[14,3,14,10],[14,12,14,13],[16,12,16,13],[13,12,13,13],[7,12,7,13],[11,12,11,13],[10,12,10,13],[15,12,15,13],[12,12,12,13],[8,12,8,13],[6,14,6,15],[7,3,7,10],[12,3,12,10],[8,3,8,10],[6,3,6,10],[10,3,10,10],[6,12,6,13],[7,14,7,15],[10,14,10,15],[12,14,12,15],[11,3,11,10],[11,14,11,15],[9,3,9,10],[9,12,9,13],[9,14,9,15],[17,3,17,10],[19,12,19,13],[28,4,33,4],[28,5,33,5],[28,15,33,15],[19,3,19,10],[27,11,33,11],[27,13,27,15],[27,18,33,18],[27,17,33,17],[27,16,33,16],[18,3,18,10],[28,14,33,14],[23,3,23,13],[24,3,24,13],[21,12,21,13],[18,12,18,13],[20,12,20,13],[17,12,17,13],[28,13,33,13],[27,9,33,9],[27,12,33,12],[21,3,21,10],[20,3,20,10],[21,14,21,15],[35,1,35,3],[27,20,33,20],[27,0,33,0],[27,4,27,8],[29,7,33,7],[28,6,28,7],[58,1,58,3],[50,1,50,3],[53,1,53,3],[54,1,54,3],[51,1,51,3],[52,1,52,3],[27,19,33,19],[27,10,33,10],[27,1,33,3],[24,14,24,15],[56,1,56,3],[48,1,48,3],[57,1,57,3],[28,8,33,8],[29,6,33,6],[40,1,40,3],[83,1,83,3],[85,1,85,3],[101,1,101,3],[102,1,102,3],[99,1,99,3],[70,1,70,3],[82,1,82,3],[75,1,75,3],[76,1,76,3],[77,1,77,3],[80,1,80,3],[71,1,71,3],[72,1,72,3],[73,1,73,3],[74,1,74,3],[100,0,100,20],[98,1,98,3],[104,1,104,3],[105,1,105,3],[154,1,154,3],[155,1,155,3],[156,1,156,3],[36,1,36,3],[38,1,38,3],[39,1,39,3],[47,1,47,3],[45,1,45,3],[62,1,62,3],[66,1,66,3],[60,1,60,3],[65,1,65,3],[41,1,41,3],[46,1,46,3],[42,1,42,3],[44,1,44,3],[67,1,67,3],[69,1,69,3],[59,1,59,3],[87,1,87,3],[89,1,89,3],[157,1,157,3],[160,1,160,3],[106,1,106,3],[107,1,107,3],[141,1,141,3],[143,1,143,3],[108,1,108,3],[110,1,110,3],[144,1,144,3],[145,1,145,3],[146,1,146,3],[147,1,147,3],[148,1,148,3],[149,1,149,3],[150,1,150,3],[158,1,158,3],[111,1,111,3],[112,1,112,3],[140,1,140,3],[123,1,123,3],[124,1,124,3],[125,1,125,3],[126,1,126,3],[128,1,128,3],[171,1,171,3],[172,1,172,3],[173,1,173,3],[174,0,174,20],[161,1,161,3],[162,1,162,3],[163,1,163,3],[165,1,165,3],[166,1,166,3],[167,1,167,3],[164,1,164,3],[183,1,183,3],[184,1,184,3],[185,1,185,3],[186,1,186,3],[187,1,187,3],[189,1,189,3],[175,1,175,3],[177,1,177,3],[178,1,178,3],[179,1,179,3],[180,1,180,3],[181,1,181,3],[210,1,210,3],[216,1,216,3],[217,1,217,3],[219,1,219,3],[220,1,220,3],[211,1,211,3],[213,1,213,3],[214,1,214,3],[215,1,215,3],[201,1,201,3],[202,1,202,3],[208,1,208,3],[209,1,209,3],[203,1,203,3],[204,1,204,3],[205,1,205,3],[207,1,207,3],[190,1,190,3],[191,1,191,3],[192,1,192,3],[193,1,193,3],[195,1,195,3],[196,1,196,3],[197,1,197,3],[198,1,198,3],[199,1,199,3],[540,1,540,3],[541,1,541,3],[542,1,542,3],[543,1,543,3],[530,1,530,3],[531,1,531,3],[532,1,532,3],[534,1,534,3],[535,1,535,3],[536,1,536,3],[538,1,538,3],[552,1,552,3],[553,1,553,3],[554,1,554,3],[555,1,555,3],[556,1,556,3],[558,1,558,3],[544,1,544,3],[546,1,546,3],[547,1,547,3],[548,1,548,3],[549,1,549,3],[550,1,550,3],[566,1,566,3],[567,1,567,3],[568,1,568,3],[570,1,570,3],[571,1,571,3],[572,1,572,3],[559,1,559,3],[560,1,560,3],[561,1,561,3],[562,1,562,3],[564,1,564,3],[565,1,565,3],[580,1,580,3],[582,1,582,3],[583,1,583,3],[584,1,584,3],[585,1,585,3],[586,1,586,3],[573,1,573,3],[574,1,574,3],[576,1,576,3],[577,1,577,3],[578,1,578,3],[579,1,579,3],[595,1,595,3],[596,1,596,3],[597,1,597,3],[598,1,598,3],[600,1,600,3],[601,1,601,3],[588,1,588,3],[589,1,589,3],[590,1,590,3],[591,1,591,3],[592,1,592,3],[594,1,594,3],[612,1,612,3],[620,1,620,3],[621,1,621,3],[613,1,613,3],[614,1,614,3],[615,1,615,3],[616,1,616,3],[602,1,602,3],[603,1,603,3],[604,1,604,3],[606,1,606,3],[607,1,607,3],[608,1,608,3],[609,1,609,3],[610,1,610,3],[647,1,647,3],[649,1,649,3],[650,1,650,3],[651,1,651,3],[635,1,635,3],[637,1,637,3],[638,1,638,3],[639,1,639,3],[640,1,640,3],[641,1,641,3],[645,1,645,3],[646,1,646,3],[627,0,627,20],[622,1,622,3],[624,1,624,3],[625,1,625,3],[626,1,626,3],[618,1,618,3],[619,1,619,3],[643,1,643,3],[644,1,644,3],[628,1,628,3],[629,1,629,3],[631,1,631,3],[632,1,632,3],[633,1,633,3],[634,1,634,3],[678,1,678,3],[680,1,680,3],[681,1,681,3],[687,1,687,3],[688,1,688,3],[682,1,682,3],[683,1,683,3],[684,1,684,3],[686,1,686,3],[670,1,670,3],[665,1,665,3],[666,1,666,3],[668,1,668,3],[669,1,669,3],[677,1,677,3],[664,0,664,20],[652,1,652,3],[653,1,653,3],[655,1,655,3],[656,1,656,3],[657,1,657,3],[663,1,663,3],[658,1,658,3],[662,1,662,3],[659,1,659,3],[661,1,661,3],[676,1,676,3],[671,1,671,3],[672,1,672,3],[674,1,674,3],[675,1,675,3]]}
[null,null,null,"Расчёт теплопотерь через ограждающие конструкции помещений"]
[]
[]
[null,null,null,"Расчётная температура наружного воздуха. text, °C:",{"$nulls":8},{"$f":"ТТ!G4","v":-22}]
[]
[null,null,null,"Таблица 1 - Сопротивления теплопередаче Rо и коэффициенты теплопередачи К"]
[null,null,null,"Наименование конструкции",{"$nulls":7},"Сокр.","R0, м²·°C/Вт",null,"К, Вт/(м²·°C)",null,"n"]
[null,null,null,"- наружная стена",{"$nulls":7},"нс",{"$f":"ТТ!M14","v":8.6944048943270307},null,{"$f":"IF(M8=\"\",\"\",ROUND(1/M8,3))","v":0.115},null,1]
[null,null,null,"- наружная стена лестничной клетки",{"$nulls":7},"нс1",{"$f":"ТТ!M14","v":8.6944048943270307},null,{"$f":"IF(M9=\"\",\"\",ROUND(1/M9,3))","v":0.115}]
[null,null,null,"- перекрытие над неотапливаемым подвалом",{"$nulls":7},"нп",null,null,{"$f":"IF(M10=\"\",\"\",ROUND(1/M10,3))","v":""}]
[null,null,null,"- бесчердачное/чердачное перекрытие",{"$nulls":7},"п",{"$f":"ТТ!M26","v":9.2493298805142867},null,{"$f":"IF(M11=\"\",\"\",ROUND(1/M11,3))","v":0.108},null,1]
[null,null,null,"- двери наружные",{"$nulls":7},"дн",{"$f":"ТТ!M39","v":1.1111111111111112},null,{"$f":"IF(M12=\"\",\"\",ROUND(1/M12,3))","v":0.9},null,1]
[null,null,null,"- перекрытие над отапливаемым техэтажом",{"$nulls":7},"пл",{"$f":"ТТ!M18","v":1.2247701638340007},null,{"$f":"IF(M13=\"\",\"\",ROUND(1/M13,3))","v":0.81599999999999995},null,1]
[null,null,null,"- двери внутренние",{"$nulls":7},"дв",0.55000000000000004,null,1.8180000000000001,null,1]
[null,null,null,"- внутренняя стена в тамбуре ЛК",{"$nulls":7},"вс",{"$f":"ТТ!M22","v":0.78342078960519734},null,1.276,null,1]
[null,null,null,"- остекление",{"$nulls":7},"о",{"$f":"ТТ!M38","v":0.90909090909090906},null,1.1000000000000001,null,1]
[null,null,null,"- пол I зона",{"$nulls":7},"пл-1",{"$f":"ТТ!M41","v":10.703766025641025},null,9.2999999999999999E-2,null,1]
[null,null,null,"- пол Iа зона",{"$nulls":7},"пл-1а",null,null,"",null,1]
[null,null,null,"- пол II(а) зона",{"$nulls":7},"пл-2",{"$f":"ТТ!M43","v":12.903766025641026},null,7.6999999999999999E-2,null,1]
[null,null,null,"- пол IIб зона",{"$nulls":7},"пл-2б",null,null,"",null,1]
[null,null,null,"- пол III зона",{"$nulls":7},"пл-3",{"$f":"ТТ!M45","v":17.203766025641023},null,5.8000000000000003E-2,null,1]
[null,null,null,"- пол IV зона",{"$nulls":7},"пл-4",{"$f":"ТТ!M47","v":22.803766025641025},null,4.3999999999999997E-2,null,1]
[]
[null,null,null,"Коэффициент учета шага номенклатурного ряда прибора β1",{"$nulls":10},1.048]
[null,null,null,"Коэффициент учета теплопотерь через заприборный участок β2",{"$nulls":10},1.02]
[{"$nulls":19},{"$f":"SUM(T41:T222)","v":4465},{"$f":"SUM(U41:U222)","v":4805}]
["Таблица 2 - Расчёт теплопотерь через ограждающие конструкции помещений"]
["№ помещения","Наименование помещения и температура, °С",null,null,"Характеристика ограждения",{"$nulls":4},"Коэф. т/передачи k, Вт/(м²·°C)","Коэффициент n","Разность темпе- ратур, (tint – text), °С","Основные тепло-потери Qо, Вт","Добавки к т/потерям",null,null,"Общие потери тепла Qогр, Вт","Расход инфильт. воздуха Lинф, м³/ч","Потери тепла на нагрев инф. возд. Qинф, Вт","Суммарные поте- ри тепла Qсум, Вт","Мощность отопительных приборов, Вт"]
[{"$nulls":4},"наименование","сторона света","размеры, м",null,"площадь, м²",{"$nulls":4},"на сторону света","прочие","коэффицинет (1+Σβ)"]
[{"$nulls":6},"H","L"]
[]
[]
[]
[]
[{"$f":"\"1 этаж. Q₁ = \"&SUM(T41:T100)&\" Вт\"","v":"1 этаж. Q₁ = 2830 Вт"}]
["101","Tuulekoda",null,null,"нс","в",3.25,2.39,{"$f":"IF(E36=\"\",\"\",G36*H36)-I38","v":5.6174999999999997},{"$f":"IF(E36=\"\",\"\",IF(E36=\"о\",VLOOKUP(E36,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E36,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E36=\"\",\"\",VLOOKUP(E36,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E36=\"\",\"\",IF(OR(E36=$L$15,E36=$L$14,E36=$L$13),B37-B40,B37-$M$4))","v":41},{"$f":"IF(E36=\"\",\"\",J36*K36*I36*L36)","v":26.4865125},{"$f":"IF(E36=\"\",\"\",IF(F36=\"в\",0.1,IF(F36=\"св\",0.1,IF(F36=\"с\",0.1,IF(F36=\"сз\",0.1,IF(F36=\"з\",0.05,IF(F36=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E36=\"\",\"\",1+N36+O36)","v":1.2000000000000002},{"$f":"IF(G36=0,\"\",CEILING(M36*P36,5))","v":35}]
[null,19,null,null,"пл-1",null,2.6230000000000002,{"$f":"H36","v":2.39},{"$f":"IF(E37=\"\",\"\",G37*H37)","v":6.2689700000000013},{"$f":"IF(E37=\"\",\"\",IF(E37=\"о\",VLOOKUP(E37,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E37,$L$8:$P$22,4,FALSE)))","v":9.2999999999999999E-2},{"$f":"IF(E37=\"\",\"\",VLOOKUP(E37,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E37=\"\",\"\",IF(OR(E37=$L$15,E37=$L$14,E37=$L$13),B37-B40,B37-$M$4))","v":41},{"$f":"IF(E37=\"\",\"\",J37*K37*I37*L37)","v":23.903582610000004},{"$f":"IF(E37=\"\",\"\",IF(F37=\"в\",0.1,IF(F37=\"св\",0.1,IF(F37=\"с\",0.1,IF(F37=\"сз\",0.1,IF(F37=\"з\",0.05,IF(F37=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E37=\"\",\"\",1+N37+O37)","v":1},{"$f":"IF(G37=0,\"\",CEILING(M37*P37,5))","v":25}]
[null,"Sп =",4.54,"м²","дн","в",2.15,1,{"$f":"IF(E38=\"\",\"\",G38*H38)","v":2.15},{"$f":"IF(E38=\"\",\"\",IF(E38=\"о\",VLOOKUP(E38,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E38,$L$8:$P$22,4,FALSE)))","v":0.9},{"$f":"IF(E38=\"\",\"\",VLOOKUP(E38,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E38=\"\",\"\",IF(OR(E38=$L$15,E38=$L$14,E38=$L$13),B37-B40,B37-$M$4))","v":41},{"$f":"IF(E38=\"\",\"\",J38*K38*I38*L38)","v":79.335000000000008},{"$f":"IF(E38=\"\",\"\",IF(F38=\"в\",0.1,IF(F38=\"св\",0.1,IF(F38=\"с\",0.1,IF(F38=\"сз\",0.1,IF(F38=\"з\",0.05,IF(F38=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E38=\"\",\"\",1+N38+O38)","v":1.2000000000000002},{"$f":"IF(G38=0,\"\",CEILING(M38*P38,5))","v":100}]
[null,{"$f":"IF(OR(E36=$L$15,E36=$L$14,E36=$L$13),\"В смежн. пом.\",IF(OR(E37=$L$15,E37=$L$14,E37=$L$13),\"В смежн. пом.\",IF(OR(E38=$L$15,E38=$L$14,E38=$L$13),\"В смежн. пом.\",IF(OR(E39=$L$15,E39=$L$14,E39=$L$13),\"В смежн. пом.\",IF(OR(E40=$L$15,E40=$L$14,E40=$L$13),\"В смежн. пом.\",\"\")))))","v":"В смежн. пом."},null,null,"вс","с",3.25,2.39,{"$f":"IF(E39=\"\",\"\",G39*H39)-I40","v":5.6675000000000004},{"$f":"IF(E39=\"\",\"\",IF(E39=\"о\",VLOOKUP(E39,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E39,$L$8:$P$22,4,FALSE)))","v":1.276},{"$f":"IF(E39=\"\",\"\",VLOOKUP(E39,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E39=\"\",\"\",IF(OR(E39=$L$15,E39=$L$14,E39=$L$13),B37-B40,B37-$M$4))","v":9},{"$f":"IF(E39=\"\",\"\",J39*K39*I39*L39)","v":65.085570000000004},{"$f":"IF(E39=\"\",\"\",IF(F39=\"в\",0.1,IF(F39=\"св\",0.1,IF(F39=\"с\",0.1,IF(F39=\"сз\",0.1,IF(F39=\"з\",0.05,IF(F39=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E39=\"\",\"\",1+N39+O39)","v":1.2000000000000002},{"$f":"IF(G39=0,\"\",CEILING(M39*P39,5))","v":80}]
[null,"10",null,null,"дв",null,2.1,1,{"$f":"IF(E40=\"\",\"\",G40*H40)","v":2.1},{"$f":"IF(E40=\"\",\"\",IF(E40=\"о\",VLOOKUP(E40,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E40,$L$8:$P$22,4,FALSE)))","v":1.8180000000000001},{"$f":"IF(E40=\"\",\"\",VLOOKUP(E40,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E40=\"\",\"\",IF(OR(E40=$L$15,E40=$L$14,E40=$L$13),B37-B40,B37-$M$4))","v":9},{"$f":"IF(E40=\"\",\"\",J40*K40*I40*L40)","v":34.360199999999999},{"$f":"IF(E40=\"\",\"\",IF(F40=\"в\",0.1,IF(F40=\"св\",0.1,IF(F40=\"с\",0.1,IF(F40=\"сз\",0.1,IF(F40=\"з\",0.05,IF(F40=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E40=\"\",\"\",1+N40+O40)","v":1},{"$f":"IF(G40=0,\"\",CEILING(M40*P40,5))","v":35}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q36:Q40)","v":275},null,{"$f":"CEILING(R41*(353/(273+0.5*(B37+$M$4)))*1005*(B37-$M$4)/3600,5)","v":0},{"$f":"S41+Q41","v":275},{"$f":"CEILING(T41*$O$24*$O$25,5)","v":295}]
["102","Esik",null,null,"вс","с",3.25,1.7949999999999999,{"$f":"IF(E42=\"\",\"\",G42*H42)","v":5.8337500000000002},{"$f":"IF(E42=\"\",\"\",IF(E42=\"о\",VLOOKUP(E42,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E42,$L$8:$P$22,4,FALSE)))","v":1.276},{"$f":"IF(E42=\"\",\"\",VLOOKUP(E42,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E42=\"\",\"\",IF(OR(E42=$L$15,E42=$L$14,E42=$L$13),B43-B46,B43-$M$4))","v":11},{"$f":"IF(E42=\"\",\"\",J42*K42*I42*L42)","v":81.882515000000012},{"$f":"IF(E42=\"\",\"\",IF(F42=\"в\",0.1,IF(F42=\"св\",0.1,IF(F42=\"с\",0.1,IF(F42=\"сз\",0.1,IF(F42=\"з\",0.05,IF(F42=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E42=\"\",\"\",1+N42+O42)","v":1.2000000000000002},{"$f":"IF(G42=0,\"\",CEILING(M42*P42,5))","v":100}]
[null,21,null,null,"пл-2","с",4.2,1.36,{"$f":"IF(E43=\"\",\"\",G43*H43)","v":5.7120000000000006},{"$f":"IF(E43=\"\",\"\",IF(E43=\"о\",VLOOKUP(E43,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E43,$L$8:$P$22,4,FALSE)))","v":7.6999999999999999E-2},{"$f":"IF(E43=\"\",\"\",VLOOKUP(E43,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E43=\"\",\"\",IF(OR(E43=$L$15,E43=$L$14,E43=$L$13),B43-B46,B43-$M$4))","v":43},{"$f":"IF(E43=\"\",\"\",J43*K43*I43*L43)","v":18.912432000000003},{"$f":"IF(E43=\"\",\"\",IF(F43=\"в\",0.1,IF(F43=\"св\",0.1,IF(F43=\"с\",0.1,IF(F43=\"сз\",0.1,IF(F43=\"з\",0.05,IF(F43=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E43=\"\",\"\",1+N43+O43)","v":1.2000000000000002},{"$f":"IF(G43=0,\"\",CEILING(M43*P43,5))","v":25}]
[null,"Sп =",5.73,"м²",{"$nulls":4},{"$f":"IF(E44=\"\",\"\",G44*H44)","v":""},{"$f":"IF(E44=\"\",\"\",IF(E44=\"о\",VLOOKUP(E44,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E44,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E44=\"\",\"\",VLOOKUP(E44,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E44=\"\",\"\",IF(OR(E44=$L$15,E44=$L$14,E44=$L$13),B43-B46,B43-$M$4))","v":""},{"$f":"IF(E44=\"\",\"\",J44*K44*I44*L44)","v":""},{"$f":"IF(E44=\"\",\"\",IF(F44=\"в\",0.1,IF(F44=\"св\",0.1,IF(F44=\"с\",0.1,IF(F44=\"сз\",0.1,IF(F44=\"з\",0.05,IF(F44=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E44=\"\",\"\",1+N44+O44)","v":""},{"$f":"IF(G44=0,\"\",CEILING(M44*P44,5))","v":""}]
[null,{"$f":"IF(OR(E42=$L$15,E42=$L$14,E42=$L$13),\"В смежн. пом.\",IF(OR(E43=$L$15,E43=$L$14,E43=$L$13),\"В смежн. пом.\",IF(OR(E44=$L$15,E44=$L$14,E44=$L$13),\"В смежн. пом.\",IF(OR(E45=$L$15,E45=$L$14,E45=$L$13),\"В смежн. пом.\",IF(OR(E46=$L$15,E46=$L$14,E46=$L$13),\"В смежн. пом.\",\"\")))))","v":"В смежн. пом."},{"$nulls":6},{"$f":"IF(E45=\"\",\"\",G45*H45)","v":""},{"$f":"IF(E45=\"\",\"\",IF(E45=\"о\",VLOOKUP(E45,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E45,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E45=\"\",\"\",VLOOKUP(E45,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E45=\"\",\"\",IF(OR(E45=$L$15,E45=$L$14,E45=$L$13),B43-B46,B43-$M$4))","v":""},{"$f":"IF(E45=\"\",\"\",J45*K45*I45*L45)","v":""},{"$f":"IF(E45=\"\",\"\",IF(F45=\"в\",0.1,IF(F45=\"св\",0.1,IF(F45=\"с\",0.1,IF(F45=\"сз\",0.1,IF(F45=\"з\",0.05,IF(F45=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E45=\"\",\"\",1+N45+O45)","v":""},{"$f":"IF(G45=0,\"\",CEILING(M45*P45,5))","v":""}]
[null,"10",{"$nulls":6},{"$f":"IF(E46=\"\",\"\",G46*H46)","v":""},{"$f":"IF(E46=\"\",\"\",IF(E46=\"о\",VLOOKUP(E46,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E46,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E46=\"\",\"\",VLOOKUP(E46,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E46=\"\",\"\",IF(OR(E46=$L$15,E46=$L$14,E46=$L$13),B43-B46,B43-$M$4))","v":""},{"$f":"IF(E46=\"\",\"\",J46*K46*I46*L46)","v":""},{"$f":"IF(E46=\"\",\"\",IF(F46=\"в\",0.1,IF(F46=\"св\",0.1,IF(F46=\"с\",0.1,IF(F46=\"сз\",0.1,IF(F46=\"з\",0.05,IF(F46=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E46=\"\",\"\",1+N46+O46)","v":""},{"$f":"IF(G46=0,\"\",CEILING(M46*P46,5))","v":""}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q42:Q46)","v":125},{"$f":"IF(B42=\"Кухня\",30,IF(B42=\"ЖК\",CEILING(C44*3,1),IF(B42=\"Кабинет\",CEILING(C44*3,1),0)))","v":0},{"$f":"CEILING(R47*(353/(273+0.5*(B43+$M$4)))*1005*(B43-$M$4)/3600,5)","v":0},{"$f":"S47+Q47","v":125},{"$f":"CEILING(T47*$O$24*$O$25,10)","v":140}]
["103","Puhkeruum",null,null,"нс","с",3.25,4.2149999999999999,{"$f":"IF(E48=\"\",\"\",G48*H48)","v":13.69875},{"$f":"IF(E48=\"\",\"\",IF(E48=\"о\",VLOOKUP(E48,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E48,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E48=\"\",\"\",VLOOKUP(E48,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E48=\"\",\"\",IF(OR(E48=$L$15,E48=$L$14,E48=$L$13),B49-B52,B49-$M$4))","v":44},{"$f":"IF(E48=\"\",\"\",J48*K48*I48*L48)","v":69.315674999999999},{"$f":"IF(E48=\"\",\"\",IF(F48=\"в\",0.1,IF(F48=\"св\",0.1,IF(F48=\"с\",0.1,IF(F48=\"сз\",0.1,IF(F48=\"з\",0.05,IF(F48=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E48=\"\",\"\",1+N48+O48)","v":1.2000000000000002},{"$f":"IF(G48=0,\"\",CEILING(M48*P48,5))","v":85}]
[null,22,null,null,"пл-1",null,2,{"$f":"H48","v":4.2149999999999999},{"$f":"IF(E49=\"\",\"\",G49*H49)","v":8.43},{"$f":"IF(E49=\"\",\"\",IF(E49=\"о\",VLOOKUP(E49,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E49,$L$8:$P$22,4,FALSE)))","v":9.2999999999999999E-2},{"$f":"IF(E49=\"\",\"\",VLOOKUP(E49,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E49=\"\",\"\",IF(OR(E49=$L$15,E49=$L$14,E49=$L$13),B49-B52,B49-$M$4))","v":44},{"$f":"IF(E49=\"\",\"\",J49*K49*I49*L49)","v":34.495559999999998},{"$f":"IF(E49=\"\",\"\",IF(F49=\"в\",0.1,IF(F49=\"св\",0.1,IF(F49=\"с\",0.1,IF(F49=\"сз\",0.1,IF(F49=\"з\",0.05,IF(F49=\"юв\",0.05,0)))))))","v":0},0.1,{"$f":"IF(E49=\"\",\"\",1+N49+O49)","v":1.1000000000000001},{"$f":"IF(G49=0,\"\",CEILING(M49*P49,5))","v":40}]
[null,"Sп =",6.3,"м²","пл-2",null,0.6,{"$f":"H48","v":4.2149999999999999},{"$f":"IF(E50=\"\",\"\",G50*H50)","v":2.5289999999999999},{"$f":"IF(E50=\"\",\"\",IF(E50=\"о\",VLOOKUP(E50,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E50,$L$8:$P$22,4,FALSE)))","v":7.6999999999999999E-2},{"$f":"IF(E50=\"\",\"\",VLOOKUP(E50,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E50=\"\",\"\",IF(OR(E50=$L$15,E50=$L$14,E50=$L$13),B49-B52,B49-$M$4))","v":44},{"$f":"IF(E50=\"\",\"\",J50*K50*I50*L50)","v":8.5682519999999993},{"$f":"IF(E50=\"\",\"\",IF(F50=\"в\",0.1,IF(F50=\"св\",0.1,IF(F50=\"с\",0.1,IF(F50=\"сз\",0.1,IF(F50=\"з\",0.05,IF(F50=\"юв\",0.05,0)))))))","v":0},0.1,{"$f":"IF(E50=\"\",\"\",1+N50+O50)","v":1.1000000000000001},{"$f":"IF(G50=0,\"\",CEILING(M50*P50,5))","v":10}]
[null,{"$f":"IF(OR(E48=$L$15,E48=$L$14,E48=$L$13),\"В смежн. пом.\",IF(OR(E49=$L$15,E49=$L$14,E49=$L$13),\"В смежн. пом.\",IF(OR(E50=$L$15,E50=$L$14,E50=$L$13),\"В смежн. пом.\",IF(OR(E51=$L$15,E51=$L$14,E51=$L$13),\"В смежн. пом.\",IF(OR(E52=$L$15,E52=$L$14,E52=$L$13),\"В смежн. пом.\",\"\")))))","v":""},{"$nulls":6},{"$f":"IF(E51=\"\",\"\",G51*H51)","v":""},{"$f":"IF(E51=\"\",\"\",IF(E51=\"о\",VLOOKUP(E51,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E51,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E51=\"\",\"\",VLOOKUP(E51,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E51=\"\",\"\",IF(OR(E51=$L$15,E51=$L$14,E51=$L$13),B49-B52,B49-$M$4))","v":""},{"$f":"IF(E51=\"\",\"\",J51*K51*I51*L51)","v":""},{"$f":"IF(E51=\"\",\"\",IF(F51=\"в\",0.1,IF(F51=\"св\",0.1,IF(F51=\"с\",0.1,IF(F51=\"сз\",0.1,IF(F51=\"з\",0.05,IF(F51=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E51=\"\",\"\",1+N51+O51)","v":""},{"$f":"IF(G51=0,\"\",CEILING(M51*P51,5))","v":""}]
[{"$nulls":8},{"$f":"IF(E52=\"\",\"\",G52*H52)","v":""},{"$f":"IF(E52=\"\",\"\",IF(E52=\"о\",VLOOKUP(E52,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E52,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E52=\"\",\"\",VLOOKUP(E52,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E52=\"\",\"\",IF(OR(E52=$L$15,E52=$L$14,E52=$L$13),B49-B52,B49-$M$4))","v":""},{"$f":"IF(E52=\"\",\"\",J52*K52*I52*L52)","v":""},{"$f":"IF(E52=\"\",\"\",IF(F52=\"в\",0.1,IF(F52=\"св\",0.1,IF(F52=\"с\",0.1,IF(F52=\"сз\",0.1,IF(F52=\"з\",0.05,IF(F52=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E52=\"\",\"\",1+N52+O52)","v":""},{"$f":"IF(G52=0,\"\",CEILING(M52*P52,5))","v":""}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q48:Q52)","v":135},{"$f":"IF(B48=\"Кухня\",30,IF(B48=\"ЖК\",CEILING(C50*3,1),IF(B48=\"Кабинет\",CEILING(C50*3,1),0)))","v":0},{"$f":"CEILING(R53*(353/(273+0.5*(B49+$M$4)))*1005*(B49-$M$4)/3600,5)","v":0},{"$f":"S53+Q53","v":135},{"$f":"CEILING(T53*$O$24*$O$25,5)","v":145}]
["104","Leiliruum",null,null,"нс","с",3.25,2.1,{"$f":"IF(E54=\"\",\"\",G54*H54)","v":6.8250000000000002},{"$f":"IF(E54=\"\",\"\",IF(E54=\"о\",VLOOKUP(E54,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E54,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E54=\"\",\"\",VLOOKUP(E54,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E54=\"\",\"\",IF(OR(E54=$L$15,E54=$L$14,E54=$L$13),B55-B58,B55-$M$4))","v":43},{"$f":"IF(E54=\"\",\"\",J54*K54*I54*L54)","v":33.749625000000002},{"$f":"IF(E54=\"\",\"\",IF(F54=\"в\",0.1,IF(F54=\"св\",0.1,IF(F54=\"с\",0.1,IF(F54=\"сз\",0.1,IF(F54=\"з\",0.05,IF(F54=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E54=\"\",\"\",1+N54+O54)","v":1.1000000000000001},{"$f":"IF(G54=0,\"\",CEILING(M54*P54,5))","v":40}]
[null,21,{"$nulls":6},{"$f":"IF(E55=\"\",\"\",G55*H55)","v":""},{"$f":"IF(E55=\"\",\"\",IF(E55=\"о\",VLOOKUP(E55,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E55,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E55=\"\",\"\",VLOOKUP(E55,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E55=\"\",\"\",IF(OR(E55=$L$15,E55=$L$14,E55=$L$13),B55-B58,B55-$M$4))","v":""},{"$f":"IF(E55=\"\",\"\",J55*K55*I55*L55)","v":""},{"$f":"IF(E55=\"\",\"\",IF(F55=\"в\",0.1,IF(F55=\"св\",0.1,IF(F55=\"с\",0.1,IF(F55=\"сз\",0.1,IF(F55=\"з\",0.05,IF(F55=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E55=\"\",\"\",1+N55+O55)","v":""},{"$f":"IF(G55=0,\"\",CEILING(M55*P55,5))","v":""}]
[null,"Sп =",3.8,"м²","пл-1",null,2,{"$f":"H54","v":2.1},{"$f":"IF(E56=\"\",\"\",G56*H56)","v":4.2},{"$f":"IF(E56=\"\",\"\",IF(E56=\"о\",VLOOKUP(E56,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E56,$L$8:$P$22,4,FALSE)))","v":9.2999999999999999E-2},{"$f":"IF(E56=\"\",\"\",VLOOKUP(E56,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E56=\"\",\"\",IF(OR(E56=$L$15,E56=$L$14,E56=$L$13),B55-B58,B55-$M$4))","v":43},{"$f":"IF(E56=\"\",\"\",J56*K56*I56*L56)","v":16.7958},{"$f":"IF(E56=\"\",\"\",IF(F56=\"в\",0.1,IF(F56=\"св\",0.1,IF(F56=\"с\",0.1,IF(F56=\"сз\",0.1,IF(F56=\"з\",0.05,IF(F56=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E56=\"\",\"\",1+N56+O56)","v":1},{"$f":"IF(G56=0,\"\",CEILING(M56*P56,5))","v":20}]
[null,{"$f":"IF(OR(E54=$L$15,E54=$L$14,E54=$L$13),\"В смежн. пом.\",IF(OR(E55=$L$15,E55=$L$14,E55=$L$13),\"В смежн. пом.\",IF(OR(E56=$L$15,E56=$L$14,E56=$L$13),\"В смежн. пом.\",IF(OR(E57=$L$15,E57=$L$14,E57=$L$13),\"В смежн. пом.\",IF(OR(E58=$L$15,E58=$L$14,E58=$L$13),\"В смежн. пом.\",\"\")))))","v":""},null,null,"пл-2",null,0.65,{"$f":"H54","v":2.1},{"$f":"IF(E57=\"\",\"\",G57*H57)","v":1.3650000000000002},{"$f":"IF(E57=\"\",\"\",IF(E57=\"о\",VLOOKUP(E57,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E57,$L$8:$P$22,4,FALSE)))","v":7.6999999999999999E-2},{"$f":"IF(E57=\"\",\"\",VLOOKUP(E57,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E57=\"\",\"\",IF(OR(E57=$L$15,E57=$L$14,E57=$L$13),B55-B58,B55-$M$4))","v":43},{"$f":"IF(E57=\"\",\"\",J57*K57*I57*L57)","v":4.5195150000000011},{"$f":"IF(E57=\"\",\"\",IF(F57=\"в\",0.1,IF(F57=\"св\",0.1,IF(F57=\"с\",0.1,IF(F57=\"сз\",0.1,IF(F57=\"з\",0.05,IF(F57=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E57=\"\",\"\",1+N57+O57)","v":1},{"$f":"IF(G57=0,\"\",CEILING(M57*P57,5))","v":5}]
[{"$nulls":8},{"$f":"IF(E58=\"\",\"\",G58*H58)","v":""},{"$f":"IF(E58=\"\",\"\",IF(E58=\"о\",VLOOKUP(E58,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E58,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E58=\"\",\"\",VLOOKUP(E58,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E58=\"\",\"\",IF(OR(E58=$L$15,E58=$L$14,E58=$L$13),B55-B58,B55-$M$4))","v":""},{"$f":"IF(E58=\"\",\"\",J58*K58*I58*L58)","v":""},{"$f":"IF(E58=\"\",\"\",IF(F58=\"в\",0.1,IF(F58=\"св\",0.1,IF(F58=\"с\",0.1,IF(F58=\"сз\",0.1,IF(F58=\"з\",0.05,IF(F58=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E58=\"\",\"\",1+N58+O58)","v":""},{"$f":"IF(G58=0,\"\",CEILING(M58*P58,5))","v":""}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q54:Q58)","v":65},{"$f":"IF(B54=\"Кухня\",30,IF(B54=\"ЖК\",CEILING(C56*3,1),IF(B54=\"Кабинет\",CEILING(C56*3,1),0)))","v":0},{"$f":"CEILING(R59*(353/(273+0.5*(B55+$M$4)))*1005*(B55-$M$4)/3600,5)","v":0},{"$f":"S59+Q59","v":65},{"$f":"CEILING(T59*$O$24*$O$25,5)","v":70}]
["105","Köök",null,null,"нс","ю",3.25,5.53,{"$f":"IF(E60=\"\",\"\",G60*H60)-I61-I62","v":14.657500000000001},{"$f":"IF(E60=\"\",\"\",IF(E60=\"о\",VLOOKUP(E60,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E60,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E60=\"\",\"\",VLOOKUP(E60,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E60=\"\",\"\",IF(OR(E60=$L$15,E60=$L$14,E60=$L$13),B61-B64,B61-$M$4))","v":43},{"$f":"IF(E60=\"\",\"\",J60*K60*I60*L60)","v":72.481337500000009},{"$f":"IF(E60=\"\",\"\",IF(F60=\"в\",0.1,IF(F60=\"св\",0.1,IF(F60=\"с\",0.1,IF(F60=\"сз\",0.1,IF(F60=\"з\",0.05,IF(F60=\"юв\",0.05,0)))))))","v":0},0.1,{"$f":"IF(E60=\"\",\"\",1+N60+O60)","v":1.1000000000000001},{"$f":"IF(G60=0,\"\",CEILING(M60*P60,5))","v":80}]
[null,21,null,null,"о","ю",1.1499999999999999,1.2,{"$f":"IF(E61=\"\",\"\",G61*H61)","v":1.38},{"$f":"IF(E61=\"\",\"\",IF(E61=\"о\",VLOOKUP(E61,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E61,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},1,{"$f":"IF(E61=\"\",\"\",IF(OR(E61=$L$15,E61=$L$14,E61=$L$13),B61-B64,B61-$M$4))","v":43},58.4499,0,null,1,60]
[null,"Sп =",22.2,"м²","дн","ю",2.15,0.9,{"$f":"IF(E62=\"\",\"\",G62*H62)","v":1.9350000000000001},0.9,1,{"$f":"IF(E62=\"\",\"\",IF(OR(E62=$L$15,E62=$L$14,E62=$L$13),B61-B64,B61-$M$4))","v":43},74.884500000000003,0,null,1,75]
[null,{"$f":"IF(OR(E60=$L$15,E60=$L$14,E60=$L$13),\"В смежн. пом.\",IF(OR(E61=$L$15,E61=$L$14,E61=$L$13),\"В смежн. пом.\",IF(OR(E62=$L$15,E62=$L$14,E62=$L$13),\"В смежн. пом.\",IF(OR(E63=$L$15,E63=$L$14,E63=$L$13),\"В смежн. пом.\",IF(OR(E64=$L$15,E64=$L$14,E64=$L$13),\"В смежн. пом.\",\"\")))))","v":""},null,null,"пл-1",null,2,{"$f":"H60","v":5.53},{"$f":"IF(E63=\"\",\"\",G63*H63)","v":11.06},9.2999999999999999E-2,1,{"$f":"IF(E63=\"\",\"\",IF(OR(E63=$L$15,E63=$L$14,E63=$L$13),B61-B64,B61-$M$4))","v":43},44.228940000000001,0,null,1,45]
[null,"16",null,null,"пл-2",null,2,{"$f":"H60","v":5.53},{"$f":"IF(E64=\"\",\"\",G64*H64)","v":11.06},7.6999999999999999E-2,1,{"$f":"IF(E64=\"\",\"\",IF(OR(E64=$L$15,E64=$L$14,E64=$L$13),B61-B64,B61-$M$4))","v":43},36.619660000000003,0,null,1,40]
[{"$nulls":4},"пл-3",null,0.63,{"$f":"H60","v":5.53},{"$f":"IF(E65=\"\",\"\",G65*H65)","v":3.4839000000000002},5.8000000000000003E-2,1,{"$f":"IF(E65=\"\",\"\",IF(OR(E65=$L$15,E65=$L$14,E65=$L$13),B61-B64,B61-$M$4))","v":43},8.6888466000000015,0,null,1,10]
[{"$nulls":15},"Σ",{"$f":"SUM(Q60:Q65)","v":310},{"$f":"IF(B60=\"Кухня\",30,IF(B60=\"ЖК\",CEILING(C62*3,1),IF(B60=\"Кабинет\",CEILING(C62*3,1),0)))","v":0},{"$f":"CEILING(R66*(353/(273+0.5*(B61+$M$4)))*1005*(B61-$M$4)/3600,5)","v":0},{"$f":"S66+Q66","v":310},{"$f":"CEILING(T66*$O$24*$O$25,5)","v":335}]
["106","Elutuba",null,null,"нс","с",3.25,6.7370000000000001,{"$f":"IF(E67=\"\",\"\",G67*H67)","v":21.895250000000001},{"$f":"IF(E67=\"\",\"\",IF(E67=\"о\",VLOOKUP(E67,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E67,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E67=\"\",\"\",VLOOKUP(E67,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E67=\"\",\"\",IF(OR(E67=$L$15,E67=$L$14,E67=$L$13),B68-B71,B68-$M$4))","v":41},{"$f":"IF(E67=\"\",\"\",J67*K67*I67*L67)","v":103.23610375000001},{"$f":"IF(E67=\"\",\"\",IF(F67=\"в\",0.1,IF(F67=\"св\",0.1,IF(F67=\"с\",0.1,IF(F67=\"сз\",0.1,IF(F67=\"з\",0.05,IF(F67=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E67=\"\",\"\",1+N67+O67)","v":1.2000000000000002},{"$f":"IF(G67=0,\"\",CEILING(M67*P67,5))","v":125}]
[null,19,null,null,"нс","ю",3.25,6.74,{"$f":"IF(E68=\"\",\"\",G68*H68)-I73","v":16.325000000000003},0.115,1,{"$f":"IF(E68=\"\",\"\",IF(OR(E68=$L$15,E68=$L$14,E68=$L$13),B68-B71,B68-$M$4))","v":41},76.972375000000014,0,null,1,80]
[null,"Sп =",41.7,"м²","нс","з",3.25,7.157,{"$f":"IF(E69=\"\",\"\",G69*H69)-I70-I71","v":18.330249999999999},0.115,1,{"$f":"IF(E69=\"\",\"\",IF(OR(E69=$L$15,E69=$L$14,E69=$L$13),B68-B71,B68-$M$4))","v":41},86.427128749999994,0.05,null,1.05,95]
[null,{"$f":"IF(OR(E67=$L$15,E67=$L$14,E67=$L$13),\"В смежн. пом.\",IF(OR(E68=$L$15,E68=$L$14,E68=$L$13),\"В смежн. пом.\",IF(OR(E69=$L$15,E69=$L$14,E69=$L$13),\"В смежн. пом.\",IF(OR(E70=$L$15,E70=$L$14,E70=$L$13),\"В смежн. пом.\",IF(OR(E71=$L$15,E71=$L$14,E71=$L$13),\"В смежн. пом.\",\"\")))))","v":""},null,null,"о","з",1.1000000000000001,1.55,{"$f":"IF(E70=\"\",\"\",G70*H70)","v":1.7050000000000003},0.9850000000000001,1,{"$f":"IF(E70=\"\",\"\",IF(OR(E70=$L$15,E70=$L$14,E70=$L$13),B68-B71,B68-$M$4))","v":41},68.856425000000016,0.05,null,1.05,75]
[{"$nulls":4},"дн","з",2.15,1.5,{"$f":"IF(E71=\"\",\"\",G71*H71)","v":3.2249999999999996},0.9,1,{"$f":"IF(E71=\"\",\"\",IF(OR(E71=$L$15,E71=$L$14,E71=$L$13),B68-B71,B68-$M$4))","v":41},119.0025,0.05,null,1.05,125]
[{"$nulls":4},"п",null,3.25,6.7370000000000001,66,0.108,1,{"$f":"IF(E72=\"\",\"\",IF(OR(E72=$L$15,E72=$L$14,E71=$L$13),B68-B71,B68-$M$4))","v":41},292.24799999999999,0,null,1,295]
[{"$nulls":4},"о","ю",1.8,1.55,{"$f":"IF(E73=\"\",\"\",G73*H73)*2","v":5.58},0.9850000000000001,1,{"$f":"IF(E73=\"\",\"\",IF(OR(E73=$L$15,E73=$L$14,E73=$L$13),B70-B73,B68-$M$4))","v":41},225.34830000000002,0,null,1,230]
[{"$nulls":4},"пл-1",null,20.64,2,{"$f":"IF(E74=\"\",\"\",G74*H74)","v":41.28},{"$f":"IF(E74=\"\",\"\",IF(E74=\"о\",VLOOKUP(E74,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E74,$L$8:$P$22,4,FALSE)))","v":9.2999999999999999E-2},{"$f":"IF(E74=\"\",\"\",VLOOKUP(E74,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E74=\"\",\"\",IF(OR(E74=$L$15,E74=$L$14,E74=$L$13),B68-B71,B68-$M$4))","v":41},{"$f":"IF(E74=\"\",\"\",J74*K74*I74*L74)","v":157.40064000000001},{"$f":"IF(E74=\"\",\"\",IF(F74=\"в\",0.1,IF(F74=\"св\",0.1,IF(F74=\"с\",0.1,IF(F74=\"сз\",0.1,IF(F74=\"з\",0.05,IF(F74=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E74=\"\",\"\",1+N74+O74)","v":1},{"$f":"IF(G74=0,\"\",CEILING(M74*P74,5))","v":160}]
[{"$nulls":4},"пл-2",null,3.16,4.74,{"$f":"IF(E75=\"\",\"\",G75*H75)","v":14.978400000000001},{"$f":"IF(E75=\"\",\"\",IF(E75=\"о\",VLOOKUP(E75,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E75,$L$8:$P$22,4,FALSE)))","v":7.6999999999999999E-2},{"$f":"IF(E75=\"\",\"\",VLOOKUP(E75,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E75=\"\",\"\",IF(OR(E75=$L$15,E75=$L$14,E75=$L$13),B68-B71,B68-$M$4))","v":41},{"$f":"IF(E75=\"\",\"\",J75*K75*I75*L75)","v":47.286808799999996},{"$f":"IF(E75=\"\",\"\",IF(F75=\"в\",0.1,IF(F75=\"св\",0.1,IF(F75=\"с\",0.1,IF(F75=\"сз\",0.1,IF(F75=\"з\",0.05,IF(F75=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E75=\"\",\"\",1+N75+O75)","v":1},{"$f":"IF(G75=0,\"\",CEILING(M75*P75,5))","v":50}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q67:Q75)","v":1235},{"$f":"IF(B67=\"Кухня\",30,IF(B67=\"ЖК\",CEILING(C69*3,1),IF(B67=\"Кабинет\",CEILING(C69*3,1),0)))","v":0},{"$f":"CEILING(R76*(353/(273+0.5*(B68+$M$4)))*1005*(B68-$M$4)/3600,5)","v":0},{"$f":"S76+Q76","v":1235},{"$f":"CEILING(T76*$O$24*$O$25,5)","v":1325}]
["107","Sahver",null,null,"нс","ю",3.25,6.56,{"$f":"IF(E77=\"\",\"\",G77*H77)-I80","v":16.72},{"$f":"IF(E77=\"\",\"\",IF(E77=\"о\",VLOOKUP(E77,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E77,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E77=\"\",\"\",VLOOKUP(E77,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E77=\"\",\"\",IF(OR(E77=$L$15,E77=$L$14,E77=$L$13),B78-B81,B78-$M$4))","v":41},{"$f":"IF(E77=\"\",\"\",J77*K77*I77*L77)","v":78.834799999999987},{"$f":"IF(E77=\"\",\"\",IF(F77=\"в\",0.1,IF(F77=\"св\",0.1,IF(F77=\"с\",0.1,IF(F77=\"сз\",0.1,IF(F77=\"з\",0.05,IF(F77=\"юв\",0.05,0)))))))","v":0},0.1,{"$f":"IF(E77=\"\",\"\",1+N77+O77)","v":1.1000000000000001},{"$f":"IF(G77=0,\"\",CEILING(M77*P77,5))","v":90}]
[null,19,null,null,"пл-1",null,2,9.35,{"$f":"IF(E78=\"\",\"\",G78*H78)","v":18.7},{"$f":"IF(E78=\"\",\"\",IF(E78=\"о\",VLOOKUP(E78,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E78,$L$8:$P$22,4,FALSE)))","v":9.2999999999999999E-2},{"$f":"IF(E78=\"\",\"\",VLOOKUP(E78,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E78=\"\",\"\",IF(OR(E78=$L$15,E78=$L$14,E78=$L$13),B78-B81,B78-$M$4))","v":41},{"$f":"IF(E78=\"\",\"\",J78*K78*I78*L78)","v":71.303100000000001},{"$f":"IF(E78=\"\",\"\",IF(F78=\"в\",0.1,IF(F78=\"св\",0.1,IF(F78=\"с\",0.1,IF(F78=\"сз\",0.1,IF(F78=\"з\",0.05,IF(F78=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E78=\"\",\"\",1+N78+O78)","v":1},{"$f":"IF(G78=0,\"\",CEILING(M78*P78,5))","v":75}]
[null,"Sп =",17.399999999999999,"м²","пл-2",null,4.5599999999999996,0.8,{"$f":"IF(E79=\"\",\"\",G79*H79)","v":3.6479999999999997},{"$f":"IF(E79=\"\",\"\",IF(E79=\"о\",VLOOKUP(E79,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E79,$L$8:$P$22,4,FALSE)))","v":7.6999999999999999E-2},{"$f":"IF(E79=\"\",\"\",VLOOKUP(E79,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E79=\"\",\"\",IF(OR(E79=$L$15,E79=$L$14,E79=$L$13),B78-B81,B78-$M$4))","v":41},{"$f":"IF(E79=\"\",\"\",J79*K79*I79*L79)","v":11.516736},{"$f":"IF(E79=\"\",\"\",IF(F79=\"в\",0.1,IF(F79=\"св\",0.1,IF(F79=\"с\",0.1,IF(F79=\"сз\",0.1,IF(F79=\"з\",0.05,IF(F79=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E79=\"\",\"\",1+N79+O79)","v":1},{"$f":"IF(G79=0,\"\",CEILING(M79*P79,5))","v":15}]
[null,{"$f":"IF(OR(E77=$L$15,E77=$L$14,E77=$L$13),\"В смежн. пом.\",IF(OR(E78=$L$15,E78=$L$14,E78=$L$13),\"В смежн. пом.\",IF(OR(E79=$L$15,E79=$L$14,E79=$L$13),\"В смежн. пом.\",IF(OR(E80=$L$15,E80=$L$14,E80=$L$13),\"В смежн. пом.\",IF(OR(E81=$L$15,E81=$L$14,E81=$L$13),\"В смежн. пом.\",\"\")))))","v":""},null,null,"о","ю",2,2.2999999999999998,{"$f":"IF(E80=\"\",\"\",G80*H80)","v":4.5999999999999996},{"$f":"IF(E80=\"\",\"\",IF(E80=\"о\",VLOOKUP(E80,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E80,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},{"$f":"IF(E80=\"\",\"\",VLOOKUP(E80,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E80=\"\",\"\",IF(OR(E80=$L$15,E80=$L$14,E80=$L$13),B78-B81,B78-$M$4))","v":41},{"$f":"IF(E80=\"\",\"\",J80*K80*I80*L80)","v":185.77099999999999},{"$f":"IF(E80=\"\",\"\",IF(F80=\"в\",0.1,IF(F80=\"св\",0.1,IF(F80=\"с\",0.1,IF(F80=\"сз\",0.1,IF(F80=\"з\",0.05,IF(F80=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E80=\"\",\"\",1+N80+O80)","v":1},{"$f":"IF(G80=0,\"\",CEILING(M80*P80,5))","v":190}]
[{"$nulls":4},"нс","в",3.25,2.79,{"$f":"IF(E81=\"\",\"\",G81*H81)","v":9.0675000000000008},{"$f":"IF(E81=\"\",\"\",IF(E81=\"о\",VLOOKUP(E81,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E81,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E81=\"\",\"\",VLOOKUP(E81,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E81=\"\",\"\",IF(OR(E81=$L$15,E81=$L$14,E81=$L$13),B78-B81,B78-$M$4))","v":41},{"$f":"IF(E81=\"\",\"\",J81*K81*I81*L81)","v":42.753262499999998},{"$f":"IF(E81=\"\",\"\",IF(F81=\"в\",0.1,IF(F81=\"св\",0.1,IF(F81=\"с\",0.1,IF(F81=\"сз\",0.1,IF(F81=\"з\",0.05,IF(F81=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E81=\"\",\"\",1+N81+O81)","v":1.1000000000000001},{"$f":"IF(G81=0,\"\",CEILING(M81*P81,5))","v":50}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q77:Q81)","v":420},{"$f":"IF(B77=\"Кухня\",30,IF(B77=\"ЖК\",CEILING(C79*3,1),IF(B77=\"Кабинет\",CEILING(C79*3,1),0)))","v":0},{"$f":"CEILING(R82*(353/(273+0.5*(B78+$M$4)))*1005*(B78-$M$4)/3600,5)","v":0},{"$f":"S82+Q82","v":420},{"$f":"CEILING(T82*$O$24*$O$25,5)","v":450}]
["108","Trepp",null,null,"нс","с",0,1.58,{"$f":"IF(E83=\"\",\"\",G83*H83)","v":0},{"$f":"IF(E83=\"\",\"\",IF(E83=\"о\",VLOOKUP(E83,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E83,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E83=\"\",\"\",VLOOKUP(E83,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E83=\"\",\"\",IF(OR(E83=$L$15,E83=$L$14,E83=$L$13),B84-B87,B84-$M$4))","v":43},{"$f":"IF(E83=\"\",\"\",J83*K83*I83*L83)","v":0},{"$f":"IF(E83=\"\",\"\",IF(F83=\"в\",0.1,IF(F83=\"св\",0.1,IF(F83=\"с\",0.1,IF(F83=\"сз\",0.1,IF(F83=\"з\",0.05,IF(F83=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E83=\"\",\"\",1+N83+O83)","v":1.1000000000000001},{"$f":"IF(G83=0,\"\",CEILING(M83*P83,5))","v":""}]
[null,21,null,null,"о","с",null,null,{"$f":"IF(E84=\"\",\"\",G84*H84)","v":0},{"$f":"IF(E84=\"\",\"\",IF(E84=\"о\",VLOOKUP(E84,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E84,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},{"$f":"IF(E84=\"\",\"\",VLOOKUP(E84,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E84=\"\",\"\",IF(OR(E84=$L$15,E84=$L$14,E84=$L$13),B84-B87,B84-$M$4))","v":43},{"$f":"IF(E84=\"\",\"\",J84*K84*I84*L84)","v":0},{"$f":"IF(E84=\"\",\"\",IF(F84=\"в\",0.1,IF(F84=\"св\",0.1,IF(F84=\"с\",0.1,IF(F84=\"сз\",0.1,IF(F84=\"з\",0.05,IF(F84=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E84=\"\",\"\",1+N84+O84)","v":1.1000000000000001},{"$f":"IF(G84=0,\"\",CEILING(M84*P84,5))","v":""}]
[null,"Sп =",2.4,"м²","пл",null,null,null,{"$f":"IF(E85=\"\",\"\",G85*H85)","v":0},{"$f":"IF(E85=\"\",\"\",IF(E85=\"о\",VLOOKUP(E85,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E85,$L$8:$P$22,4,FALSE)))","v":0.81599999999999995},{"$f":"IF(E85=\"\",\"\",VLOOKUP(E85,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E85=\"\",\"\",IF(OR(E85=$L$15,E85=$L$14,E85=$L$13),B84-B87,B84-$M$4))","v":21},{"$f":"IF(E85=\"\",\"\",J85*K85*I85*L85)","v":0},{"$f":"IF(E85=\"\",\"\",IF(F85=\"в\",0.1,IF(F85=\"св\",0.1,IF(F85=\"с\",0.1,IF(F85=\"сз\",0.1,IF(F85=\"з\",0.05,IF(F85=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E85=\"\",\"\",1+N85+O85)","v":1},{"$f":"IF(G85=0,\"\",CEILING(M85*P85,5))","v":""}]
[null,{"$f":"IF(OR(E83=$L$15,E83=$L$14,E83=$L$13),\"В смежн. пом.\",IF(OR(E84=$L$15,E84=$L$14,E84=$L$13),\"В смежн. пом.\",IF(OR(E85=$L$15,E85=$L$14,E85=$L$13),\"В смежн. пом.\",IF(OR(E86=$L$15,E86=$L$14,E86=$L$13),\"В смежн. пом.\",IF(OR(E87=$L$15,E87=$L$14,E87=$L$13),\"В смежн. пом.\",\"\")))))","v":"В смежн. пом."},{"$nulls":6},{"$f":"IF(E86=\"\",\"\",G86*H86)","v":""},{"$f":"IF(E86=\"\",\"\",IF(E86=\"о\",VLOOKUP(E86,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E86,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E86=\"\",\"\",VLOOKUP(E86,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E86=\"\",\"\",IF(OR(E86=$L$15,E86=$L$14,E86=$L$13),B84-B87,B84-$M$4))","v":""},{"$f":"IF(E86=\"\",\"\",J86*K86*I86*L86)","v":""},{"$f":"IF(E86=\"\",\"\",IF(F86=\"в\",0.1,IF(F86=\"св\",0.1,IF(F86=\"с\",0.1,IF(F86=\"сз\",0.1,IF(F86=\"з\",0.05,IF(F86=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E86=\"\",\"\",1+N86+O86)","v":""},{"$f":"IF(G86=0,\"\",CEILING(M86*P86,5))","v":""}]
[{"$nulls":8},{"$f":"IF(E87=\"\",\"\",G87*H87)","v":""},{"$f":"IF(E87=\"\",\"\",IF(E87=\"о\",VLOOKUP(E87,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E87,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E87=\"\",\"\",VLOOKUP(E87,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E87=\"\",\"\",IF(OR(E87=$L$15,E87=$L$14,E87=$L$13),B84-B87,B84-$M$4))","v":""},{"$f":"IF(E87=\"\",\"\",J87*K87*I87*L87)","v":""},{"$f":"IF(E87=\"\",\"\",IF(F87=\"в\",0.1,IF(F87=\"св\",0.1,IF(F87=\"с\",0.1,IF(F87=\"сз\",0.1,IF(F87=\"з\",0.05,IF(F87=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E87=\"\",\"\",1+N87+O87)","v":""},{"$f":"IF(G87=0,\"\",CEILING(M87*P87,5))","v":""}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q83:Q87)","v":0},{"$f":"IF(B83=\"Кухня\",30,IF(B83=\"ЖК\",CEILING(C85*3,1),IF(B83=\"Кабинет\",CEILING(C85*3,1),0)))","v":0},{"$f":"CEILING(R88*(353/(273+0.5*(B84+$M$4)))*1005*(B84-$M$4)/3600,5)","v":0},{"$f":"S88+Q88","v":0},{"$f":"CEILING(T88*$O$24*$O$25,5)","v":0}]
["109","WC",null,null,"нс","с",3.25,1.58,{"$f":"IF(E89=\"\",\"\",G89*H89)","v":5.1349999999999998},{"$f":"IF(E89=\"\",\"\",IF(E89=\"о\",VLOOKUP(E89,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E89,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E89=\"\",\"\",VLOOKUP(E89,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E89=\"\",\"\",IF(OR(E89=$L$15,E89=$L$14,E89=$L$13),B90-B93,B90-$M$4))","v":43},{"$f":"IF(E89=\"\",\"\",J89*K89*I89*L89)","v":25.392574999999997},{"$f":"IF(E89=\"\",\"\",IF(F89=\"в\",0.1,IF(F89=\"св\",0.1,IF(F89=\"с\",0.1,IF(F89=\"сз\",0.1,IF(F89=\"з\",0.05,IF(F89=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E89=\"\",\"\",1+N89+O89)","v":1.1000000000000001},{"$f":"IF(G89=0,\"\",CEILING(M89*P89,5))","v":30}]
[null,21,null,null,"вс",null,3.25,1.98,{"$f":"IF(E90=\"\",\"\",G90*H90)","v":6.4349999999999996},{"$f":"IF(E90=\"\",\"\",IF(E90=\"о\",VLOOKUP(E90,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E90,$L$8:$P$22,4,FALSE)))","v":1.276},{"$f":"IF(E90=\"\",\"\",VLOOKUP(E90,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E90=\"\",\"\",IF(OR(E90=$L$15,E90=$L$14,E90=$L$13),B90-B93,B90-$M$4))","v":11},{"$f":"IF(E90=\"\",\"\",J90*K90*I90*L90)","v":90.321659999999994},{"$f":"IF(E90=\"\",\"\",IF(F90=\"в\",0.1,IF(F90=\"св\",0.1,IF(F90=\"с\",0.1,IF(F90=\"сз\",0.1,IF(F90=\"з\",0.05,IF(F90=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E90=\"\",\"\",1+N90+O90)","v":1},{"$f":"IF(G90=0,\"\",CEILING(M90*P90,5))","v":95}]
[null,"Sп =",2.9,"м²","пл-1",null,2,1.58,{"$f":"IF(E91=\"\",\"\",G91*H91)","v":3.16},{"$f":"IF(E91=\"\",\"\",IF(E91=\"о\",VLOOKUP(E91,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E91,$L$8:$P$22,4,FALSE)))","v":9.2999999999999999E-2},{"$f":"IF(E91=\"\",\"\",VLOOKUP(E91,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E91=\"\",\"\",IF(OR(E91=$L$15,E91=$L$14,E91=$L$13),B90-B93,B90-$M$4))","v":43},{"$f":"IF(E91=\"\",\"\",J91*K91*I91*L91)","v":12.636840000000001},{"$f":"IF(E91=\"\",\"\",IF(F91=\"в\",0.1,IF(F91=\"св\",0.1,IF(F91=\"с\",0.1,IF(F91=\"сз\",0.1,IF(F91=\"з\",0.05,IF(F91=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E91=\"\",\"\",1+N91+O91)","v":1},{"$f":"IF(G91=0,\"\",CEILING(M91*P91,5))","v":15}]
[null,{"$f":"IF(OR(E89=$L$15,E89=$L$14,E89=$L$13),\"В смежн. пом.\",IF(OR(E90=$L$15,E90=$L$14,E90=$L$13),\"В смежн. пом.\",IF(OR(E91=$L$15,E91=$L$14,E91=$L$13),\"В смежн. пом.\",IF(OR(E92=$L$15,E92=$L$14,E92=$L$13),\"В смежн. пом.\",IF(OR(E93=$L$15,E93=$L$14,E93=$L$13),\"В смежн. пом.\",\"\")))))","v":"В смежн. пом."},null,null,"пл-2",null,0.4,1.58,{"$f":"IF(E92=\"\",\"\",G92*H92)","v":0.63200000000000012},{"$f":"IF(E92=\"\",\"\",IF(E92=\"о\",VLOOKUP(E92,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E92,$L$8:$P$22,4,FALSE)))","v":7.6999999999999999E-2},{"$f":"IF(E92=\"\",\"\",VLOOKUP(E92,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E92=\"\",\"\",IF(OR(E92=$L$15,E92=$L$14,E92=$L$13),B90-B93,B90-$M$4))","v":43},{"$f":"IF(E92=\"\",\"\",J92*K92*I92*L92)","v":2.0925520000000004},{"$f":"IF(E92=\"\",\"\",IF(F92=\"в\",0.1,IF(F92=\"св\",0.1,IF(F92=\"с\",0.1,IF(F92=\"сз\",0.1,IF(F92=\"з\",0.05,IF(F92=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E92=\"\",\"\",1+N92+O92)","v":1},{"$f":"IF(G92=0,\"\",CEILING(M92*P92,5))","v":5}]
[null,"10",{"$nulls":6},{"$f":"IF(E93=\"\",\"\",G93*H93)","v":""},{"$f":"IF(E93=\"\",\"\",IF(E93=\"о\",VLOOKUP(E93,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E93,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E93=\"\",\"\",VLOOKUP(E93,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E93=\"\",\"\",IF(OR(E93=$L$15,E93=$L$14,E93=$L$13),B90-B93,B90-$M$4))","v":""},{"$f":"IF(E93=\"\",\"\",J93*K93*I93*L93)","v":""},{"$f":"IF(E93=\"\",\"\",IF(F93=\"в\",0.1,IF(F93=\"св\",0.1,IF(F93=\"с\",0.1,IF(F93=\"сз\",0.1,IF(F93=\"з\",0.05,IF(F93=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E93=\"\",\"\",1+N93+O93)","v":""},{"$f":"IF(G93=0,\"\",CEILING(M93*P93,5))","v":""}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q89:Q93)","v":145},{"$f":"IF(B89=\"Кухня\",30,IF(B89=\"ЖК\",CEILING(C91*3,1),IF(B89=\"Кабинет\",CEILING(C91*3,1),0)))","v":0},{"$f":"CEILING(R94*(353/(273+0.5*(B90+$M$4)))*1005*(B90-$M$4)/3600,5)","v":0},{"$f":"S94+Q94","v":145},{"$f":"CEILING(T94*$O$24*$O$25,5)","v":155}]
["110","Tehniline ruum",null,null,"нс","с",3.25,4.2,{"$f":"IF(E95=\"\",\"\",G95*H95)","v":13.65},{"$f":"IF(E95=\"\",\"\",IF(E95=\"о\",VLOOKUP(E95,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E95,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E95=\"\",\"\",VLOOKUP(E95,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E95=\"\",\"\",IF(OR(E95=$L$15,E95=$L$14,E95=$L$13),B96-B99,B96-$M$4))","v":32},{"$f":"IF(E95=\"\",\"\",J95*K95*I95*L95)","v":50.232000000000006},{"$f":"IF(E95=\"\",\"\",IF(F95=\"в\",0.1,IF(F95=\"св\",0.1,IF(F95=\"с\",0.1,IF(F95=\"сз\",0.1,IF(F95=\"з\",0.05,IF(F95=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E95=\"\",\"\",1+N95+O95)","v":1.2000000000000002},{"$f":"IF(G95=0,\"\",CEILING(M95*P95,5))","v":65}]
[null,10,null,null,"нс","в",3.25,1.982,{"$f":"IF(E96=\"\",\"\",G96*H96)","v":6.4414999999999996},{"$f":"IF(E96=\"\",\"\",IF(E96=\"о\",VLOOKUP(E96,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E96,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E96=\"\",\"\",VLOOKUP(E96,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E96=\"\",\"\",IF(OR(E96=$L$15,E96=$L$14,E96=$L$13),B96-B99,B96-$M$4))","v":32},{"$f":"IF(E96=\"\",\"\",J96*K96*I96*L96)","v":23.704719999999998},{"$f":"IF(E96=\"\",\"\",IF(F96=\"в\",0.1,IF(F96=\"св\",0.1,IF(F96=\"с\",0.1,IF(F96=\"сз\",0.1,IF(F96=\"з\",0.05,IF(F96=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E96=\"\",\"\",1+N96+O96)","v":1.2000000000000002},{"$f":"IF(G96=0,\"\",CEILING(M96*P96,5))","v":30}]
[null,"Sп =",6.2,"м²","пл-1",null,4.2,1.982,{"$f":"IF(E97=\"\",\"\",G97*H97)","v":8.3244000000000007},{"$f":"IF(E97=\"\",\"\",IF(E97=\"о\",VLOOKUP(E97,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E97,$L$8:$P$22,4,FALSE)))","v":9.2999999999999999E-2},{"$f":"IF(E97=\"\",\"\",VLOOKUP(E97,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E97=\"\",\"\",IF(OR(E97=$L$15,E97=$L$14,E97=$L$13),B96-B99,B96-$M$4))","v":32},{"$f":"IF(E97=\"\",\"\",J97*K97*I97*L97)","v":24.773414400000004},{"$f":"IF(E97=\"\",\"\",IF(F97=\"в\",0.1,IF(F97=\"св\",0.1,IF(F97=\"с\",0.1,IF(F97=\"сз\",0.1,IF(F97=\"з\",0.05,IF(F97=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E97=\"\",\"\",1+N97+O97)","v":1},{"$f":"IF(G97=0,\"\",CEILING(M97*P97,5))","v":25}]
[null,{"$f":"IF(OR(E95=$L$15,E95=$L$14,E95=$L$13),\"В смежн. пом.\",IF(OR(E96=$L$15,E96=$L$14,E96=$L$13),\"В смежн. пом.\",IF(OR(E97=$L$15,E97=$L$14,E97=$L$13),\"В смежн. пом.\",IF(OR(E98=$L$15,E98=$L$14,E98=$L$13),\"В смежн. пом.\",IF(OR(E99=$L$15,E99=$L$14,E99=$L$13),\"В смежн. пом.\",\"\")))))","v":""},{"$nulls":6},{"$f":"IF(E98=\"\",\"\",G98*H98)","v":""},{"$f":"IF(E98=\"\",\"\",IF(E98=\"о\",VLOOKUP(E98,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E98,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E98=\"\",\"\",VLOOKUP(E98,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E98=\"\",\"\",IF(OR(E98=$L$15,E98=$L$14,E98=$L$13),B96-B99,B96-$M$4))","v":""},{"$f":"IF(E98=\"\",\"\",J98*K98*I98*L98)","v":""},{"$f":"IF(E98=\"\",\"\",IF(F98=\"в\",0.1,IF(F98=\"св\",0.1,IF(F98=\"с\",0.1,IF(F98=\"сз\",0.1,IF(F98=\"з\",0.05,IF(F98=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E98=\"\",\"\",1+N98+O98)","v":""},{"$f":"IF(G98=0,\"\",CEILING(M98*P98,5))","v":""}]
[{"$nulls":8},{"$f":"IF(E99=\"\",\"\",G99*H99)","v":""},{"$f":"IF(E99=\"\",\"\",IF(E99=\"о\",VLOOKUP(E99,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E99,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E99=\"\",\"\",VLOOKUP(E99,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E99=\"\",\"\",IF(OR(E99=$L$15,E99=$L$14,E99=$L$13),B96-B99,B96-$M$4))","v":""},{"$f":"IF(E99=\"\",\"\",J99*K99*I99*L99)","v":""},{"$f":"IF(E99=\"\",\"\",IF(F99=\"в\",0.1,IF(F99=\"св\",0.1,IF(F99=\"с\",0.1,IF(F99=\"сз\",0.1,IF(F99=\"з\",0.05,IF(F99=\"юв\",0.05,0)))))))","v":""},null,null,{"$f":"SUM(Q95:Q97)","v":120}]
[null,"Sп общ",{"$nulls":13},"Σ",{"$f":"SUM(Q95:Q98)","v":120},{"$f":"IF(B95=\"Кухня\",30,IF(B95=\"ЖК\",CEILING(C97*3,1),IF(B95=\"Кабинет\",CEILING(C97*3,1),0)))","v":0},{"$f":"CEILING(R100*(353/(273+0.5*(B96+$M$4)))*1005*(B96-$M$4)/3600,5)","v":0},{"$f":"S100+Q100","v":120},{"$f":"CEILING(T100*$O$24*$O$25,5)","v":130}]
[{"$f":"\"2 этаж. Q₁ = \"&SUM(T103:T137)&\" Вт\"","v":"2 этаж. Q₁ = 1635 Вт"}]
["201","Trepihall",null,null,"нс","с",2.65,2.31,{"$f":"IF(E102=\"\",\"\",G102*H102)-I103","v":3.7815000000000003},{"$f":"IF(E102=\"\",\"\",IF(E102=\"о\",VLOOKUP(E102,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E102,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E102=\"\",\"\",VLOOKUP(E102,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E102=\"\",\"\",IF(OR(E102=$L$15,E102=$L$14,E102=$L$13),B103-B106,B103-$M$4))","v":45},{"$f":"IF(E102=\"\",\"\",J102*K102*I102*L102)","v":19.569262500000001},{"$f":"IF(E102=\"\",\"\",IF(F102=\"в\",0.1,IF(F102=\"св\",0.1,IF(F102=\"с\",0.1,IF(F102=\"сз\",0.1,IF(F102=\"з\",0.05,IF(F102=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E102=\"\",\"\",1+N102+O102)","v":1.2000000000000002},{"$f":"IF(G102=0,\"\",CEILING(M102*P102,5))","v":25}]
[null,23,null,null,"о","с",1.95,1.2,{"$f":"IF(E103=\"\",\"\",G103*H103)","v":2.34},{"$f":"IF(E103=\"\",\"\",IF(E103=\"о\",VLOOKUP(E103,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E103,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},{"$f":"IF(E103=\"\",\"\",VLOOKUP(E103,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E103=\"\",\"\",IF(OR(E103=$L$15,E103=$L$14,E103=$L$13),B103-B106,B103-$M$4))","v":45},{"$f":"IF(E103=\"\",\"\",J103*K103*I103*L103)","v":103.7205},{"$f":"IF(E103=\"\",\"\",IF(F103=\"в\",0.1,IF(F103=\"св\",0.1,IF(F103=\"с\",0.1,IF(F103=\"сз\",0.1,IF(F103=\"з\",0.05,IF(F103=\"юв\",0.05,0)))))))","v":0.1},0.1,{"$f":"IF(E103=\"\",\"\",1+N103+O103)","v":1.2000000000000002},{"$f":"IF(G103=0,\"\",CEILING(M103*P103,5))","v":125}]
[null,"Sп =",17.5,"м²","п",null,2.4,3.8,{"$f":"IF(E104=\"\",\"\",G104*H104)-H105","v":9.1199999999999992},{"$f":"IF(E104=\"\",\"\",IF(E104=\"о\",VLOOKUP(E104,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E104,$L$8:$P$22,4,FALSE)))","v":0.108},{"$f":"IF(E104=\"\",\"\",VLOOKUP(E104,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E104=\"\",\"\",IF(OR(E104=$L$15,E104=$L$14,E104=$L$13),B103-B106,B103-$M$4))","v":45},{"$f":"IF(E104=\"\",\"\",J104*K104*I104*L104)","v":44.3232},{"$f":"IF(E104=\"\",\"\",IF(F104=\"в\",0.1,IF(F104=\"св\",0.1,IF(F104=\"с\",0.1,IF(F104=\"сз\",0.1,IF(F104=\"з\",0.05,IF(F104=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E104=\"\",\"\",1+N104+O104)","v":1},{"$f":"IF(G104=0,\"\",CEILING(M104*P104,5))","v":45}]
[null,{"$f":"IF(OR(E102=$L$15,E102=$L$14,E102=$L$13),\"В смежн. пом.\",IF(OR(E103=$L$15,E103=$L$14,E103=$L$13),\"В смежн. пом.\",IF(OR(E104=$L$15,E104=$L$14,E104=$L$13),\"В смежн. пом.\",IF(OR(E105=$L$15,E105=$L$14,E105=$L$13),\"В смежн. пом.\",IF(OR(E106=$L$15,E106=$L$14,E106=$L$13),\"В смежн. пом.\",\"\")))))","v":""},{"$nulls":6},{"$f":"IF(E105=\"\",\"\",G105*H105)","v":""},{"$f":"IF(E105=\"\",\"\",IF(E105=\"о\",VLOOKUP(E105,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E105,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E105=\"\",\"\",VLOOKUP(E105,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E105=\"\",\"\",IF(OR(E105=$L$15,E105=$L$14,E105=$L$13),B103-B106,B103-$M$4))","v":""},{"$f":"IF(E105=\"\",\"\",J105*K105*I105*L105)","v":""},{"$f":"IF(E105=\"\",\"\",IF(F105=\"в\",0.1,IF(F105=\"св\",0.1,IF(F105=\"с\",0.1,IF(F105=\"сз\",0.1,IF(F105=\"з\",0.05,IF(F105=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E105=\"\",\"\",1+N105+O105)","v":""},{"$f":"IF(G105=0,\"\",CEILING(M105*P105,5))","v":""}]
[{"$nulls":8},{"$f":"IF(E106=\"\",\"\",G106*H106)","v":""},{"$f":"IF(E106=\"\",\"\",IF(E106=\"о\",VLOOKUP(E106,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E106,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E106=\"\",\"\",VLOOKUP(E106,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E106=\"\",\"\",IF(OR(E106=$L$15,E106=$L$14,E106=$L$13),B103-B106,B103-$M$4))","v":""},{"$f":"IF(E106=\"\",\"\",J106*K106*I106*L106)","v":""},{"$f":"IF(E106=\"\",\"\",IF(F106=\"в\",0.1,IF(F106=\"св\",0.1,IF(F106=\"с\",0.1,IF(F106=\"сз\",0.1,IF(F106=\"з\",0.05,IF(F106=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E106=\"\",\"\",1+N106+O106)","v":""},{"$f":"IF(G106=0,\"\",CEILING(M106*P106,5))","v":""}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q102:Q106)","v":195},{"$f":"IF(B102=\"Кухня\",30,IF(B102=\"ЖК\",CEILING(C104*3,1),IF(B102=\"Кабинет\",CEILING(C104*3,1),0)))","v":0},{"$f":"CEILING(R107*(353/(273+0.5*(B103+$M$4)))*1005*(B103-$M$4)/3600,5)","v":0},{"$f":"S107+Q107","v":195},{"$f":"CEILING(T107*$O$24*$O$25,5)","v":210}]
["202","Garderoob",null,null,"нс","с",2.65,5.68,{"$f":"IF(E108=\"\",\"\",G108*H108)","v":15.052},{"$f":"IF(E108=\"\",\"\",IF(E108=\"о\",VLOOKUP(E108,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E108,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E108=\"\",\"\",VLOOKUP(E108,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E108=\"\",\"\",IF(OR(E108=$L$15,E108=$L$14,E108=$L$13),B109-B112,B109-$M$4))","v":41},{"$f":"IF(E108=\"\",\"\",J108*K108*I108*L108)","v":70.970179999999999},{"$f":"IF(E108=\"\",\"\",IF(F108=\"в\",0.1,IF(F108=\"св\",0.1,IF(F108=\"с\",0.1,IF(F108=\"сз\",0.1,IF(F108=\"з\",0.05,IF(F108=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E108=\"\",\"\",1+N108+O108)","v":1.1000000000000001},{"$f":"IF(G108=0,\"\",CEILING(M108*P108,5))","v":80}]
[null,19,null,null,"нс","в",2.65,2.34,{"$f":"IF(E109=\"\",\"\",G109*H109)","v":6.2009999999999996},{"$f":"IF(E109=\"\",\"\",IF(E109=\"о\",VLOOKUP(E109,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E109,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E109=\"\",\"\",VLOOKUP(E109,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E109=\"\",\"\",IF(OR(E109=$L$15,E109=$L$14,E109=$L$13),B109-B112,B109-$M$4))","v":41},{"$f":"IF(E109=\"\",\"\",J109*K109*I109*L109)","v":29.237714999999998},{"$f":"IF(E109=\"\",\"\",IF(F109=\"в\",0.1,IF(F109=\"св\",0.1,IF(F109=\"с\",0.1,IF(F109=\"сз\",0.1,IF(F109=\"з\",0.05,IF(F109=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E109=\"\",\"\",1+N109+O109)","v":1.1000000000000001},{"$f":"IF(G109=0,\"\",CEILING(M109*P109,5))","v":35}]
[null,"Sп =",14.28,"м²","пл",null,{"$f":"H108","v":5.68},{"$f":"H109","v":2.34},{"$f":"IF(E110=\"\",\"\",G110*H110)","v":13.291199999999998},{"$f":"IF(E110=\"\",\"\",IF(E110=\"о\",VLOOKUP(E110,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E110,$L$8:$P$22,4,FALSE)))","v":0.81599999999999995},{"$f":"IF(E110=\"\",\"\",VLOOKUP(E110,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E110=\"\",\"\",IF(OR(E110=$L$15,E110=$L$14,E110=$L$13),B109-B112,B109-$M$4))","v":9},{"$f":"IF(E110=\"\",\"\",J110*K110*I110*L110)","v":97.610572799999986},{"$f":"IF(E110=\"\",\"\",IF(F110=\"в\",0.1,IF(F110=\"св\",0.1,IF(F110=\"с\",0.1,IF(F110=\"сз\",0.1,IF(F110=\"з\",0.05,IF(F110=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E110=\"\",\"\",1+N110+O110)","v":1},{"$f":"IF(G110=0,\"\",CEILING(M110*P110,5))","v":100}]
[null,{"$f":"IF(OR(E108=$L$15,E108=$L$14,E108=$L$13),\"В смежн. пом.\",IF(OR(E109=$L$15,E109=$L$14,E109=$L$13),\"В смежн. пом.\",IF(OR(E110=$L$15,E110=$L$14,E110=$L$13),\"В смежн. пом.\",IF(OR(E111=$L$15,E111=$L$14,E111=$L$13),\"В смежн. пом.\",IF(OR(E112=$L$15,E112=$L$14,E112=$L$13),\"В смежн. пом.\",\"\")))))","v":"В смежн. пом."},null,null,"п",null,{"$f":"H110","v":2.34},{"$f":"G110","v":5.68},{"$f":"IF(E111=\"\",\"\",G111*H111)","v":13.291199999999998},{"$f":"IF(E111=\"\",\"\",IF(E111=\"о\",VLOOKUP(E111,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E111,$L$8:$P$22,4,FALSE)))","v":0.108},{"$f":"IF(E111=\"\",\"\",VLOOKUP(E111,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E111=\"\",\"\",IF(OR(E111=$L$15,E111=$L$14,E111=$L$13),B109-B112,B109-$M$4))","v":41},{"$f":"IF(E111=\"\",\"\",J111*K111*I111*L111)","v":58.853433599999995},{"$f":"IF(E111=\"\",\"\",IF(F111=\"в\",0.1,IF(F111=\"св\",0.1,IF(F111=\"с\",0.1,IF(F111=\"сз\",0.1,IF(F111=\"з\",0.05,IF(F111=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E111=\"\",\"\",1+N111+O111)","v":1},{"$f":"IF(G111=0,\"\",CEILING(M111*P111,5))","v":60}]
[null,"10",{"$nulls":6},{"$f":"IF(E112=\"\",\"\",G112*H112)","v":""},{"$f":"IF(E112=\"\",\"\",IF(E112=\"о\",VLOOKUP(E112,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E112,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E112=\"\",\"\",VLOOKUP(E112,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E112=\"\",\"\",IF(OR(E112=$L$15,E112=$L$14,E112=$L$13),B109-B112,B109-$M$4))","v":""},{"$f":"IF(E112=\"\",\"\",J112*K112*I112*L112)","v":""},{"$f":"IF(E112=\"\",\"\",IF(F112=\"в\",0.1,IF(F112=\"св\",0.1,IF(F112=\"с\",0.1,IF(F112=\"сз\",0.1,IF(F112=\"з\",0.05,IF(F112=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E112=\"\",\"\",1+N112+O112)","v":""},{"$f":"IF(G112=0,\"\",CEILING(M112*P112,5))","v":""}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q108:Q112)","v":275},{"$f":"IF(B108=\"Кухня\",30,IF(B108=\"ЖК\",CEILING(C110*3,1),IF(B108=\"Кабинет\",CEILING(C110*3,1),0)))","v":0},{"$f":"CEILING(R113*(353/(273+0.5*(B109+$M$4)))*1005*(B109-$M$4)/3600,5)","v":0},{"$f":"S113+Q113","v":275},{"$f":"CEILING(T113*$O$24*$O$25,5)","v":295}]
["203","Magamistuba",null,null,"нс","в",2.65,4.83,{"$f":"IF(E114=\"\",\"\",G114*H114)-I117","v":10.7295},{"$f":"IF(E114=\"\",\"\",IF(E114=\"о\",VLOOKUP(E114,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E114,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E114=\"\",\"\",VLOOKUP(E114,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E114=\"\",\"\",IF(OR(E114=$L$15,E114=$L$14,E114=$L$13),B115-B118,B115-$M$4))","v":44},{"$f":"IF(E114=\"\",\"\",J114*K114*I114*L114)","v":54.291270000000004},{"$f":"IF(E114=\"\",\"\",IF(F114=\"в\",0.1,IF(F114=\"св\",0.1,IF(F114=\"с\",0.1,IF(F114=\"сз\",0.1,IF(F114=\"з\",0.05,IF(F114=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E114=\"\",\"\",1+N114+O114)","v":1.1000000000000001},{"$f":"IF(G114=0,\"\",CEILING(M114*P114,5))","v":60}]
[null,22,null,null,"нс","ю",2.65,4.05,{"$f":"IF(E115=\"\",\"\",G115*H115)-I118","v":7.5150000000000006},{"$f":"IF(E115=\"\",\"\",IF(E115=\"о\",VLOOKUP(E115,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E115,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E115=\"\",\"\",VLOOKUP(E115,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E115=\"\",\"\",IF(OR(E115=$L$15,E115=$L$14,E115=$L$13),B115-B118,B115-$M$4))","v":44},{"$f":"IF(E115=\"\",\"\",J115*K115*I115*L115)","v":38.025900000000007},{"$f":"IF(E115=\"\",\"\",IF(F115=\"в\",0.1,IF(F115=\"св\",0.1,IF(F115=\"с\",0.1,IF(F115=\"сз\",0.1,IF(F115=\"з\",0.05,IF(F115=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E115=\"\",\"\",1+N115+O115)","v":1},{"$f":"IF(G115=0,\"\",CEILING(M115*P115,5))","v":40}]
[null,"Sп =",14.28,"м²","п",null,{"$f":"H114","v":4.83},{"$f":"H115","v":4.05},{"$f":"IF(E116=\"\",\"\",G116*H116)","v":19.561499999999999},{"$f":"IF(E116=\"\",\"\",IF(E116=\"о\",VLOOKUP(E116,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E116,$L$8:$P$22,4,FALSE)))","v":0.108},{"$f":"IF(E116=\"\",\"\",VLOOKUP(E116,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E116=\"\",\"\",IF(OR(E116=$L$15,E116=$L$14,E116=$L$13),B115-B118,B115-$M$4))","v":44},{"$f":"IF(E116=\"\",\"\",J116*K116*I116*L116)","v":92.956247999999988},{"$f":"IF(E116=\"\",\"\",IF(F116=\"в\",0.1,IF(F116=\"св\",0.1,IF(F116=\"с\",0.1,IF(F116=\"сз\",0.1,IF(F116=\"з\",0.05,IF(F116=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E116=\"\",\"\",1+N116+O116)","v":1},{"$f":"IF(G116=0,\"\",CEILING(M116*P116,5))","v":95}]
[null,{"$f":"IF(OR(E114=$L$15,E114=$L$14,E114=$L$13),\"В смежн. пом.\",IF(OR(E115=$L$15,E115=$L$14,E115=$L$13),\"В смежн. пом.\",IF(OR(E116=$L$15,E116=$L$14,E116=$L$13),\"В смежн. пом.\",IF(OR(E117=$L$15,E117=$L$14,E117=$L$13),\"В смежн. пом.\",IF(OR(E118=$L$15,E118=$L$14,E118=$L$13),\"В смежн. пом.\",\"\")))))","v":""},null,null,"о","в",1.8,1.1499999999999999,{"$f":"IF(E117=\"\",\"\",G117*H117)","v":2.0699999999999998},{"$f":"IF(E117=\"\",\"\",IF(E117=\"о\",VLOOKUP(E117,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E117,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},{"$f":"IF(E117=\"\",\"\",VLOOKUP(E117,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E117=\"\",\"\",IF(OR(E117=$L$15,E117=$L$14,E117=$L$13),B115-B118,B115-$M$4))","v":44},{"$f":"IF(E117=\"\",\"\",J117*K117*I117*L117)","v":89.713800000000006},{"$f":"IF(E117=\"\",\"\",IF(F117=\"в\",0.1,IF(F117=\"св\",0.1,IF(F117=\"с\",0.1,IF(F117=\"сз\",0.1,IF(F117=\"з\",0.05,IF(F117=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E117=\"\",\"\",1+N117+O117)","v":1.1000000000000001},{"$f":"IF(G117=0,\"\",CEILING(M117*P117,5))","v":100}]
[{"$nulls":4},"о","ю",1.65,1.95,{"$f":"IF(E118=\"\",\"\",G118*H118)","v":3.2174999999999998},{"$f":"IF(E118=\"\",\"\",IF(E118=\"о\",VLOOKUP(E118,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E118,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},{"$f":"IF(E118=\"\",\"\",VLOOKUP(E118,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E118=\"\",\"\",IF(OR(E118=$L$15,E118=$L$14,E118=$L$13),B115-B118,B115-$M$4))","v":44},{"$f":"IF(E118=\"\",\"\",J118*K118*I118*L118)","v":139.44645},{"$f":"IF(E118=\"\",\"\",IF(F118=\"в\",0.1,IF(F118=\"св\",0.1,IF(F118=\"с\",0.1,IF(F118=\"сз\",0.1,IF(F118=\"з\",0.05,IF(F118=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E118=\"\",\"\",1+N118+O118)","v":1},{"$f":"IF(G118=0,\"\",CEILING(M118*P118,5))","v":140}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q114:Q118)","v":435},{"$f":"IF(B114=\"Кухня\",30,IF(B114=\"ЖК\",CEILING(C116*3,1),IF(B114=\"Кабинет\",CEILING(C116*3,1),0)))","v":0},{"$f":"CEILING(R119*(353/(273+0.5*(B115+$M$4)))*1005*(B115-$M$4)/3600,5)","v":0},{"$f":"S119+Q119","v":435},{"$f":"CEILING(T119*$O$24*$O$25,5)","v":465}]
["204","Vannituba",null,null,"нс","ю",2.65,3.95,{"$f":"IF(E120=\"\",\"\",G120*H120)-I121","v":9.0874999999999986},{"$f":"IF(E120=\"\",\"\",IF(E120=\"о\",VLOOKUP(E120,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E120,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E120=\"\",\"\",VLOOKUP(E120,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E120=\"\",\"\",IF(OR(E120=$L$15,E120=$L$14,E120=$L$13),B121-B124,B121-$M$4))","v":44},{"$f":"IF(E120=\"\",\"\",J120*K120*I120*L120)","v":45.982749999999989},{"$f":"IF(E120=\"\",\"\",IF(F120=\"в\",0.1,IF(F120=\"св\",0.1,IF(F120=\"с\",0.1,IF(F120=\"сз\",0.1,IF(F120=\"з\",0.05,IF(F120=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E120=\"\",\"\",1+N120+O120)","v":1},{"$f":"IF(G120=0,\"\",CEILING(M120*P120,5))","v":50}]
[null,22,null,null,"о","ю",1.1499999999999999,1.2,{"$f":"IF(E121=\"\",\"\",G121*H121)","v":1.38},{"$f":"IF(E121=\"\",\"\",IF(E121=\"о\",VLOOKUP(E121,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E121,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},{"$f":"IF(E121=\"\",\"\",VLOOKUP(E121,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E121=\"\",\"\",IF(OR(E121=$L$15,E121=$L$14,E121=$L$13),B121-B124,B121-$M$4))","v":44},{"$f":"IF(E121=\"\",\"\",J121*K121*I121*L121)","v":59.809199999999997},{"$f":"IF(E121=\"\",\"\",IF(F121=\"в\",0.1,IF(F121=\"св\",0.1,IF(F121=\"с\",0.1,IF(F121=\"сз\",0.1,IF(F121=\"з\",0.05,IF(F121=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E121=\"\",\"\",1+N121+O121)","v":1},{"$f":"IF(G121=0,\"\",CEILING(M121*P121,5))","v":60}]
[null,"Sп =",14.28,"м²","п",null,{"$f":"H120","v":3.95},3.41,{"$f":"IF(E122=\"\",\"\",G122*H122)","v":13.469500000000002},{"$f":"IF(E122=\"\",\"\",IF(E122=\"о\",VLOOKUP(E122,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E122,$L$8:$P$22,4,FALSE)))","v":0.108},{"$f":"IF(E122=\"\",\"\",VLOOKUP(E122,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E122=\"\",\"\",IF(OR(E122=$L$15,E122=$L$14,E122=$L$13),B121-B124,B121-$M$4))","v":44},{"$f":"IF(E122=\"\",\"\",J122*K122*I122*L122)","v":64.007064000000014},{"$f":"IF(E122=\"\",\"\",IF(F122=\"в\",0.1,IF(F122=\"св\",0.1,IF(F122=\"с\",0.1,IF(F122=\"сз\",0.1,IF(F122=\"з\",0.05,IF(F122=\"юв\",0.05,0)))))))","v":0},0.1,{"$f":"IF(E122=\"\",\"\",1+N122+O122)","v":1.1000000000000001},{"$f":"IF(G122=0,\"\",CEILING(M122*P122,5))","v":75}]
[null,{"$f":"IF(OR(E120=$L$15,E120=$L$14,E120=$L$13),\"В смежн. пом.\",IF(OR(E121=$L$15,E121=$L$14,E121=$L$13),\"В смежн. пом.\",IF(OR(E122=$L$15,E122=$L$14,E122=$L$13),\"В смежн. пом.\",IF(OR(E123=$L$15,E123=$L$14,E123=$L$13),\"В смежн. пом.\",IF(OR(E124=$L$15,E124=$L$14,E124=$L$13),\"В смежн. пом.\",\"\")))))","v":""},{"$nulls":6},{"$f":"IF(E123=\"\",\"\",G123*H123)","v":""},{"$f":"IF(E123=\"\",\"\",IF(E123=\"о\",VLOOKUP(E123,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E123,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E123=\"\",\"\",VLOOKUP(E123,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E123=\"\",\"\",IF(OR(E123=$L$15,E123=$L$14,E123=$L$13),B121-B124,B121-$M$4))","v":""},{"$f":"IF(E123=\"\",\"\",J123*K123*I123*L123)","v":""},{"$f":"IF(E123=\"\",\"\",IF(F123=\"в\",0.1,IF(F123=\"св\",0.1,IF(F123=\"с\",0.1,IF(F123=\"сз\",0.1,IF(F123=\"з\",0.05,IF(F123=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E123=\"\",\"\",1+N123+O123)","v":""},{"$f":"IF(G123=0,\"\",CEILING(M123*P123,5))","v":""}]
[{"$nulls":8},{"$f":"IF(E124=\"\",\"\",G124*H124)","v":""},{"$f":"IF(E124=\"\",\"\",IF(E124=\"о\",VLOOKUP(E124,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E124,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E124=\"\",\"\",VLOOKUP(E124,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E124=\"\",\"\",IF(OR(E124=$L$15,E124=$L$14,E124=$L$13),B121-B124,B121-$M$4))","v":""},{"$f":"IF(E124=\"\",\"\",J124*K124*I124*L124)","v":""},{"$f":"IF(E124=\"\",\"\",IF(F124=\"в\",0.1,IF(F124=\"св\",0.1,IF(F124=\"с\",0.1,IF(F124=\"сз\",0.1,IF(F124=\"з\",0.05,IF(F124=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E124=\"\",\"\",1+N124+O124)","v":""},{"$f":"IF(G124=0,\"\",CEILING(M124*P124,5))","v":""}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q120:Q124)","v":185},{"$f":"IF(B120=\"Кухня\",30,IF(B120=\"ЖК\",CEILING(C122*3,1),IF(B120=\"Кабинет\",CEILING(C122*3,1),0)))","v":0},{"$f":"CEILING(R125*(353/(273+0.5*(B121+$M$4)))*1005*(B121-$M$4)/3600,5)","v":0},{"$f":"S125+Q125","v":185},{"$f":"CEILING(T125*$O$24*$O$25,5)","v":200}]
["205","Magamistuba",null,null,"нс","з",2.65,5.48,{"$f":"IF(E126=\"\",\"\",G126*H126)-I130","v":13.602},{"$f":"IF(E126=\"\",\"\",IF(E126=\"о\",VLOOKUP(E126,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E126,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E126=\"\",\"\",VLOOKUP(E126,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E126=\"\",\"\",IF(OR(E126=$L$15,E126=$L$14,E126=$L$13),B127-B130,B127-$M$4))","v":44},{"$f":"IF(E126=\"\",\"\",J126*K126*I126*L126)","v":68.826120000000003},{"$f":"IF(E126=\"\",\"\",IF(F126=\"в\",0.1,IF(F126=\"св\",0.1,IF(F126=\"с\",0.1,IF(F126=\"сз\",0.1,IF(F126=\"з\",0.05,IF(F126=\"юв\",0.05,0)))))))","v":0.05},null,{"$f":"IF(E126=\"\",\"\",1+N126+O126)","v":1.05},{"$f":"IF(G126=0,\"\",CEILING(M126*P126,5))","v":75}]
[null,22,null,null,"нс","ю",2.65,4.2300000000000004,{"$f":"IF(E127=\"\",\"\",G127*H127)-I129","v":9.1395},{"$f":"IF(E127=\"\",\"\",IF(E127=\"о\",VLOOKUP(E127,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E127,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E127=\"\",\"\",VLOOKUP(E127,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E127=\"\",\"\",IF(OR(E127=$L$15,E127=$L$14,E127=$L$13),B127-B130,B127-$M$4))","v":44},{"$f":"IF(E127=\"\",\"\",J127*K127*I127*L127)","v":46.245870000000004},{"$f":"IF(E127=\"\",\"\",IF(F127=\"в\",0.1,IF(F127=\"св\",0.1,IF(F127=\"с\",0.1,IF(F127=\"сз\",0.1,IF(F127=\"з\",0.05,IF(F127=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E127=\"\",\"\",1+N127+O127)","v":1},{"$f":"IF(G127=0,\"\",CEILING(M127*P127,5))","v":50}]
[null,"Sп =",14.28,"м²","п",null,{"$f":"H126","v":5.48},{"$f":"H127","v":4.2300000000000004},{"$f":"IF(E128=\"\",\"\",G128*H128)","v":23.180400000000006},{"$f":"IF(E128=\"\",\"\",IF(E128=\"о\",VLOOKUP(E128,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E128,$L$8:$P$22,4,FALSE)))","v":0.108},{"$f":"IF(E128=\"\",\"\",VLOOKUP(E128,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E128=\"\",\"\",IF(OR(E128=$L$15,E128=$L$14,E128=$L$13),B127-B130,B127-$M$4))","v":44},{"$f":"IF(E128=\"\",\"\",J128*K128*I128*L128)","v":110.15326080000003},{"$f":"IF(E128=\"\",\"\",IF(F128=\"в\",0.1,IF(F128=\"св\",0.1,IF(F128=\"с\",0.1,IF(F128=\"сз\",0.1,IF(F128=\"з\",0.05,IF(F128=\"юв\",0.05,0)))))))","v":0},0.1,{"$f":"IF(E128=\"\",\"\",1+N128+O128)","v":1.1000000000000001},{"$f":"IF(G128=0,\"\",CEILING(M128*P128,5))","v":125}]
[null,{"$f":"IF(OR(E126=$L$15,E126=$L$14,E126=$L$13),\"В смежн. пом.\",IF(OR(E127=$L$15,E127=$L$14,E127=$L$13),\"В смежн. пом.\",IF(OR(E128=$L$15,E128=$L$14,E128=$L$13),\"В смежн. пом.\",IF(OR(E129=$L$15,E129=$L$14,E129=$L$13),\"В смежн. пом.\",IF(OR(E130=$L$15,E130=$L$14,E130=$L$13),\"В смежн. пом.\",\"\")))))","v":""},null,null,"о","ю",1.8,1.1499999999999999,{"$f":"IF(E129=\"\",\"\",G129*H129)","v":2.0699999999999998},{"$f":"IF(E129=\"\",\"\",IF(E129=\"о\",VLOOKUP(E129,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E129,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},{"$f":"IF(E129=\"\",\"\",VLOOKUP(E129,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E129=\"\",\"\",IF(OR(E129=$L$15,E129=$L$14,E129=$L$13),B127-B130,B127-$M$4))","v":44},{"$f":"IF(E129=\"\",\"\",J129*K129*I129*L129)","v":89.713800000000006},{"$f":"IF(E129=\"\",\"\",IF(F129=\"в\",0.1,IF(F129=\"св\",0.1,IF(F129=\"с\",0.1,IF(F129=\"сз\",0.1,IF(F129=\"з\",0.05,IF(F129=\"юв\",0.05,0)))))))","v":0},null,{"$f":"IF(E129=\"\",\"\",1+N129+O129)","v":1},{"$f":"IF(G129=0,\"\",CEILING(M129*P129,5))","v":90}]
[{"$nulls":4},"о","з",0.8,1.1499999999999999,{"$f":"IF(E130=\"\",\"\",G130*H130)","v":0.91999999999999993},{"$f":"IF(E130=\"\",\"\",IF(E130=\"о\",VLOOKUP(E130,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E130,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},{"$f":"IF(E130=\"\",\"\",VLOOKUP(E130,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E130=\"\",\"\",IF(OR(E130=$L$15,E130=$L$14,E130=$L$13),B127-B130,B127-$M$4))","v":44},{"$f":"IF(E130=\"\",\"\",J130*K130*I130*L130)","v":39.872799999999998},{"$f":"IF(E130=\"\",\"\",IF(F130=\"в\",0.1,IF(F130=\"св\",0.1,IF(F130=\"с\",0.1,IF(F130=\"сз\",0.1,IF(F130=\"з\",0.05,IF(F130=\"юв\",0.05,0)))))))","v":0.05},null,{"$f":"IF(E130=\"\",\"\",1+N130+O130)","v":1.05},{"$f":"IF(G130=0,\"\",CEILING(M130*P130,5))","v":45}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q126:Q130)","v":385},{"$f":"IF(B126=\"Кухня\",30,IF(B126=\"ЖК\",CEILING(C128*3,1),IF(B126=\"Кабинет\",CEILING(C128*3,1),0)))","v":0},{"$f":"CEILING(R131*(353/(273+0.5*(B127+$M$4)))*1005*(B127-$M$4)/3600,5)","v":0},{"$f":"S131+Q131","v":385},{"$f":"CEILING(T131*$O$24*$O$25,5)","v":415}]
["205а","Garderoob",null,null,"нс","с",2.65,4.33,{"$f":"IF(E132=\"\",\"\",G132*H132)","v":11.474499999999999},{"$f":"IF(E132=\"\",\"\",IF(E132=\"о\",VLOOKUP(E132,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E132,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E132=\"\",\"\",VLOOKUP(E132,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E132=\"\",\"\",IF(OR(E132=$L$15,E132=$L$14,E132=$L$13),B133-B136,B133-$M$4))","v":44},{"$f":"IF(E132=\"\",\"\",J132*K132*I132*L132)","v":58.060969999999998},{"$f":"IF(E132=\"\",\"\",IF(F132=\"в\",0.1,IF(F132=\"св\",0.1,IF(F132=\"с\",0.1,IF(F132=\"сз\",0.1,IF(F132=\"з\",0.05,IF(F132=\"юв\",0.05,0)))))))","v":0.1},null,{"$f":"IF(E132=\"\",\"\",1+N132+O132)","v":1.1000000000000001},{"$f":"IF(G132=0,\"\",CEILING(M132*P132,5))","v":65}]
[null,22,null,null,"нс","з",2.65,1.68,{"$f":"IF(E133=\"\",\"\",G133*H133)-I135","v":3.7320000000000002},{"$f":"IF(E133=\"\",\"\",IF(E133=\"о\",VLOOKUP(E133,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E133,$L$8:$P$22,4,FALSE)))","v":0.115},{"$f":"IF(E133=\"\",\"\",VLOOKUP(E133,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E133=\"\",\"\",IF(OR(E133=$L$15,E133=$L$14,E133=$L$13),B133-B136,B133-$M$4))","v":44},{"$f":"IF(E133=\"\",\"\",J133*K133*I133*L133)","v":18.883920000000003},{"$f":"IF(E133=\"\",\"\",IF(F133=\"в\",0.1,IF(F133=\"св\",0.1,IF(F133=\"с\",0.1,IF(F133=\"сз\",0.1,IF(F133=\"з\",0.05,IF(F133=\"юв\",0.05,0)))))))","v":0.05},null,{"$f":"IF(E133=\"\",\"\",1+N133+O133)","v":1.05},{"$f":"IF(G133=0,\"\",CEILING(M133*P133,5))","v":20}]
[null,"Sп =",14.28,"м²","п",null,{"$f":"H132","v":4.33},{"$f":"H133","v":1.68},{"$f":"IF(E134=\"\",\"\",G134*H134)","v":7.2744},{"$f":"IF(E134=\"\",\"\",IF(E134=\"о\",VLOOKUP(E134,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E134,$L$8:$P$22,4,FALSE)))","v":0.108},{"$f":"IF(E134=\"\",\"\",VLOOKUP(E134,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E134=\"\",\"\",IF(OR(E134=$L$15,E134=$L$14,E134=$L$13),B133-B136,B133-$M$4))","v":44},{"$f":"IF(E134=\"\",\"\",J134*K134*I134*L134)","v":34.567948799999996},{"$f":"IF(E134=\"\",\"\",IF(F134=\"в\",0.1,IF(F134=\"св\",0.1,IF(F134=\"с\",0.1,IF(F134=\"сз\",0.1,IF(F134=\"з\",0.05,IF(F134=\"юв\",0.05,0)))))))","v":0},0.1,{"$f":"IF(E134=\"\",\"\",1+N134+O134)","v":1.1000000000000001},{"$f":"IF(G134=0,\"\",CEILING(M134*P134,5))","v":40}]
[null,{"$f":"IF(OR(E132=$L$15,E132=$L$14,E132=$L$13),\"В смежн. пом.\",IF(OR(E133=$L$15,E133=$L$14,E133=$L$13),\"В смежн. пом.\",IF(OR(E134=$L$15,E134=$L$14,E134=$L$13),\"В смежн. пом.\",IF(OR(E135=$L$15,E135=$L$14,E135=$L$13),\"В смежн. пом.\",IF(OR(E136=$L$15,E136=$L$14,E136=$L$13),\"В смежн. пом.\",\"\")))))","v":""},null,null,"о","з",0.6,1.2,{"$f":"IF(E135=\"\",\"\",G135*H135)","v":0.72},{"$f":"IF(E135=\"\",\"\",IF(E135=\"о\",VLOOKUP(E135,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E135,$L$8:$P$22,4,FALSE)))","v":0.9850000000000001},{"$f":"IF(E135=\"\",\"\",VLOOKUP(E135,$L$8:$Q$22,6,FALSE))","v":1},{"$f":"IF(E135=\"\",\"\",IF(OR(E135=$L$15,E135=$L$14,E135=$L$13),B133-B136,B133-$M$4))","v":44},{"$f":"IF(E135=\"\",\"\",J135*K135*I135*L135)","v":31.204800000000002},{"$f":"IF(E135=\"\",\"\",IF(F135=\"в\",0.1,IF(F135=\"св\",0.1,IF(F135=\"с\",0.1,IF(F135=\"сз\",0.1,IF(F135=\"з\",0.05,IF(F135=\"юв\",0.05,0)))))))","v":0.05},null,{"$f":"IF(E135=\"\",\"\",1+N135+O135)","v":1.05},{"$f":"IF(G135=0,\"\",CEILING(M135*P135,5))","v":35}]
[{"$nulls":8},{"$f":"IF(E136=\"\",\"\",G136*H136)","v":""},{"$f":"IF(E136=\"\",\"\",IF(E136=\"о\",VLOOKUP(E136,$L$8:$P$22,4,FALSE)-VLOOKUP(\"нс\",$L$8:$P$22,4,FALSE),VLOOKUP(E136,$L$8:$P$22,4,FALSE)))","v":""},{"$f":"IF(E136=\"\",\"\",VLOOKUP(E136,$L$8:$Q$22,6,FALSE))","v":""},{"$f":"IF(E136=\"\",\"\",IF(OR(E136=$L$15,E136=$L$14,E136=$L$13),B133-B136,B133-$M$4))","v":""},{"$f":"IF(E136=\"\",\"\",J136*K136*I136*L136)","v":""},{"$f":"IF(E136=\"\",\"\",IF(F136=\"в\",0.1,IF(F136=\"св\",0.1,IF(F136=\"с\",0.1,IF(F136=\"сз\",0.1,IF(F136=\"з\",0.05,IF(F136=\"юв\",0.05,0)))))))","v":""},null,{"$f":"IF(E136=\"\",\"\",1+N136+O136)","v":""},{"$f":"IF(G136=0,\"\",CEILING(M136*P136,5))","v":""}]
[{"$nulls":15},"Σ",{"$f":"SUM(Q132:Q136)","v":160},{"$f":"IF(B132=\"Кухня\",30,IF(B132=\"ЖК\",CEILING(C134*3,1),IF(B132=\"Кабинет\",CEILING(C134*3,1),0)))","v":0},{"$f":"CEILING(R137*(353/(273+0.5*(B133+$M$4)))*1005*(B133-$M$4)/3600,5)","v":0},{"$f":"S137+Q137","v":160},{"$f":"CEILING(T137*$O$24*$O$25,5)","v":175}]
[{"$f":"\"Общ.на дом. Q₁ = \"&SUM(T36:T136)&\" Вт\"","v":"Общ.на дом. Q₁ = 4305 Вт"}]
{"$rows_empty":38}
[{"$nulls":20},{"$f":"U156+U173","v":0}]

{"sheet":"Шайбы","index":2,"n_rows":50,"n_cols":21,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,13,2,13],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,14,1,17],[1,18,1,20]]}
["Расчет дроссельных шайб"]
["№ стояка/ участка","№ этажа","Gp, кг/ч","Dу, мм","DPRLV, Па","DPст, Па","H, м","Pe, Па","Dу, мм","DPсч, Па","DPр, Па","DP, Па","Невязка, %","dш.расч, мм","Стандартная шайба",null,null,null,"Шайба с шагом 0,5 мм"]
[{"$nulls":14},"dш, мм","DPш, Па","Нев, %","Обозн.","dш, мм","DPш, Па","Нев, %"]
["Ст.1",null,563.54597642194608,null,{"$f":"IF(D4=\"\",0,(C4/980/IF(D4=15,2.5,IF(D4=20,3.4,0)))^2*10^5)","v":0},12884.517489280141,null,{"$f":"ROUND(G4*9.81*(985.6-971.8),0)","v":0},null,{"$f":"(C4/980/IF(I4=15,3,IF(I4=20,5,IF(I4=25,7,IF(I4=32,12,IF(I4=40,20,IF(I4=50,120.3,IF(I4=65,189.74,IF(I4=80,205.55,318.2)))))))))^2*10^5","v":0.32659249815084035},12877,{"$f":"K4-(E4+F4-H4*0.7+J4)","v":-7.8440817782920931},{"$f":"L4/K4*100","v":-6.0915444422552562E-2},{"$f":"IF(M4>10,IF(3.54*(C4^2/L4)^0.25<3,3,3.54*(C4^2/L4)^0.25),IF(M4<-10,\"% big\",IF(M4<10,0)))","v":0},{"$f":"IF(N4=0,0,IF(N4<=3.5,3.5,IF(N4<=4.6,4.6,IF(N4<=5.8,5.8,IF(N4<=6.5,6.5,IF(N4<=7.5,7.5,9))))))","v":0},{"$f":"IF(O4=0,0,C4^2*3.54^4/(O4^4))","v":0},{"$f":"(L4-P4)/K4*100","v":-6.0915444422552562E-2},{"$f":"IF(O4=0,\"нет\",IF(O4=3.5,\"ШД-006\",IF(O4=4.6,\"ШД-007\",IF(O4=5.8,\"ШД-008\",IF(O4=6.5,\"ШД-009\",IF(O4=7.5,\"ШД-010\",IF(O4=9,\"ШД-011\",\"ошибка\")))))))","v":"нет"},{"$f":"CEILING(IF(M4>10,IF(3.54*(C4^2/L4)^0.25<=5,5,3.54*(C4^2/L4)^0.25),IF(M4<-10,\"% big\",IF(M4<10,0))),0.5)","v":0},{"$f":"IF(N4=0,0,C4^2*3.54^4/(S4^4))","v":0},{"$f":"(L4-T4)/K4*100","v":-6.0915444422552562E-2}]
["Ст.2",null,563.54597642194608,null,0,12884.517489280141,null,0,null,0.32659249815084035,{"$f":"K4","v":12877},-7.8440817782920931,-6.0915444422552562E-2,{"$f":"IF(M5>10,IF(3.54*(C5^2/L5)^0.25<3,3,3.54*(C5^2/L5)^0.25),IF(M5<-10,\"% big\",IF(M5<10,0)))","v":0},0,0,-6.0915444422552562E-2,{"$f":"IF(O5=0,\"нет\",IF(O5=3.5,\"ШД-006\",IF(O5=4.6,\"ШД-007\",IF(O5=5.8,\"ШД-008\",IF(O5=6.5,\"ШД-009\",IF(O5=7.5,\"ШД-010\",IF(O5=9,\"ШД-011\",\"ошибка\")))))))","v":"нет"},{"$f":"CEILING(IF(M5>10,IF(3.54*(C5^2/L5)^0.25<=5,5,3.54*(C5^2/L5)^0.25),IF(M5<-10,\"% big\",IF(M5<10,0))),0.5)","v":0},0,-6.0915444422552562E-2]
["Ст.3",null,454.28324830564543,null,0,10968.507202900793,null,0,null,0.21222715050465848,12877,1908.2805699487017,14.819294633444915,11.415792499932177,9,4939.6531547610175,-23.540984583461334,"ШД-011",11.5,1852.998772782375,0.42930649348704408]
["Ст.4",null,454.28324830564543,null,0,10907.802505621148,null,0,null,0.21222715050465848,12877,1968.9852672283469,15.290714197626365,11.326768037739134,9,4939.6531547610175,-23.069565019279885,"ШД-011",11.5,1852.998772782375,0.90072605766849301]
["Ст.5",null,376.83118786877412,null,0,8295.0799645754269,null,0,null,0.14602969450877012,12877,4581.7740057300653,35.581067063213986,8.3525342604344637,9,3398.8867091404522,9.1860471894821227,"ШД-011",8.5,4271.9978350202719,2.4056548164152631]
["Ст.6",null,376.83118786877412,null,0,7928.694488022591,null,0,null,0.14602969450877012,12877,4948.1594822829002,38.426337518699235,8.1934302227426095,9,3398.8867091404522,12.031317644967368,"ШД-011",8.5,4271.9978350202719,5.2509252719005071]
["Ст.7",null,516.40937014255667,null,0,10154.91431594787,null,0,null,0.27424311024809817,12877,2721.8114409418813,21.13699961902525,11.137451097284062,9,6383.0939702446613,-28.432729124041156,"ШД-011",11.5,2394.4728350041755,2.5420408941345483]
["Ст.8",null,533.6043256449509,null,0,12512.203514706722,null,0,null,0.29281018637523021,12877,364.50367510690376,2.830656792008261,0,0,0,2.830656792008261,"нет",0,0,2.830656792008261]
["Ст.9",null,456.41392757442043,null,0,8670.5866206880546,null,0,null,0.21422259461397045,12877,4206.1991567173318,32.66443392651496,9.3909655700490653,9,4986.0977390956496,-6.0565238982551666,"ШД-011",9.5,4016.394873115652,1.4739790603531862]
["Ст.10",null,575.84410763996289,null,0,12103.540734547845,null,0,null,0.34100233474786823,12877,773.11826311740697,6.0038694037229705,0,0,0,6.0038694037229705,"нет",0,0,6.0038694037229705]
["Ст.11",null,673.89273434165852,null,0,7342.6790774017645,null,0,null,0.46701308174923722,12877,5533.8539095164861,42.974713904764201,10.654712281240181,9,10869.875211968452,-41.43838861887059,"ШД-011",11,4871.0642214141808,5.1470815259944489]
["Ст.12",null,{"$f":"C14","v":673.89273434165852},null,0,{"$f":"F14","v":7342.6790774017645},null,0,null,0.46701308174923722,12877,5533.8539095164861,42.974713904764201,10.654712281240181,9,10869.875211968452,-41.43838861887059,"ШД-011",11,4871.0642214141808,5.1470815259944489]
["Ст.13",null,459.77815799880182,null,0,9340.5980699721222,null,0,null,0.21739230635022502,12877,3536.1845377215268,27.461245148105355,9.8433675031416943,9,5059.8737688846804,-11.832641385129715,"ШД-011",10,3319.7831797652389,1.6805261936498248]
["Ст.14",null,459.77815799880182,null,0,9377.3471427150544,null,0,null,0.21739230635022502,12877,3499.4354649785946,27.175859788604445,9.8691087099713162,9,5059.8737688846804,-12.118026744630626,"ШД-011",10,3319.7831797652389,1.3951408341489149]
["Ст.15",null,418.47288445500703,null,0,8442.6717921689269,null,0,null,0.18008690861966195,12877,4434.148120922453,34.434636335500919,8.8743054763862528,9,4191.5789953309768,1.8837394237126368,"ШД-011",9,4191.5789953309768,1.8837394237126368]
["Ст.16",null,418.47288445500703,null,0,8274.3786556137038,null,0,null,0.18008690861966195,12877,4602.4412574776761,35.741564475247934,8.7920441393470234,9,4191.5789953309768,3.1906675634596517,"ШД-011",9,4191.5789953309768,3.1906675634596517]
["Ст.17",null,418.47288445500703,null,0,8153.4767259000846,null,0,null,0.18008690861966195,12877,4723.3431871912953,36.680462741254139,8.7352340907249513,9,4191.5789953309768,4.1295658294658582,"ШД-011",9,4191.5789953309768,4.1295658294658582]
["Ст.18",null,418.47288445500703,null,0,8249.775148888737,null,0,null,0.18008690861966195,12877,4627.0447642026429,35.93262999303132,8.7803332200275861,9,4191.5789953309768,3.3817330812430386,"ШД-011",9,4191.5789953309768,3.3817330812430386]
["Ст.19",null,459.77815799880182,null,0,9287.5544904962771,null,0,null,0.21739230635022502,12877,3589.2281171973718,27.87317012656187,9.806796530364263,9,5059.8737688846804,-11.420716406673206,"ШД-011",10,3319.7831797652389,2.0924511721063364]
["Ст.20",null,713.40375165911666,null,0,7949.5711861130803,null,0,null,0.52338138939358758,12877,4926.9054324975259,38.261283159878282,11.285671371343822,9,12181.865162461816,-56.340449871587253,"ШД-011",11.5,4569.7502413677466,2.7735900530385904]
["Ст.21",null,237.73894998962442,null,0,7922.0798206493891,null,0,null,5.8123020919717536E-2,12877,4954.8620563296909,38.47838826069497,6.5057225821183087,7.5,2805.2312937794563,16.693568086900946,"ШД-010",7,3696.7626574235987,9.7701281269402198]
["Ст.22",null,557.34084030586473,null,0,12215.470870591229,null,0,null,0.31943995359466237,12877,661.20968945517598,5.1348115978502449,0,0,0,5.1348115978502449,"нет",0,0,5.1348115978502449]
["Ст.23",null,557.34084030586473,null,0,12177.645600120766,null,0,null,0.31943995359466237,12877,699.03495992563876,5.4285544763969771,0,0,0,5.4285544763969771,"нет",0,0,5.4285544763969771]
["Ст.24",null,704.24556883718913,null,0,7850.5806324024834,null,0,null,0.51003002586333812,12877,5025.9093375716529,39.030126097473428,11.157365521283513,9,11871.108009921569,-53.158334024616885,"ШД-011",11.5,4453.1767484018656,4.447717551990273]
["Ст.26",null,149.3344505044889,null,0,1613.0298020603004,null,0,null,2.2933350810742617E-2,12877,11263.947264588889,87.473380947339365,4.1991425109198968,4.5999999999999996,7821.7105040524748,26.731667007349646,"ШД-007",5,5603.4183402612425,43.958444702396882]
["Ст.27",null,191.53685216145212,null,{"$f":"IF(D29=\"\",0,(C29/980/IF(D29=15,2.5,IF(D29=20,3.4,0)))^2*10^5)","v":0},3720.5923784442739,null,{"$f":"ROUND(G29*9.81*(985.6-971.8),0)","v":0},null,{"$f":"(C29/980/IF(I29=15,3,IF(I29=20,5,IF(I29=25,7,IF(I29=32,12,IF(I29=40,20,IF(I29=50,120.3,IF(I29=65,189.74,IF(I29=80,205.55,318.2)))))))))^2*10^5","v":3.7726992813354135E-2},3846,{"$f":"K29-(E29+F29-H29*0.4+J29)","v":125.36989456291258},{"$f":"L29/K29*100","v":3.2597476485416688},0,0,0,3.2597476485416688,"нет",0,0,3.2597476485416688]
["уч.19",null,40.313946978743722,null,0,3605.3117526064666,null,0,null,1.6713143365052411E-3,3846,240.68657607919704,6.2581013021112071,0,0,0,6.2581013021112071,"нет",0,0,6.2581013021112071]
["Ст.28",null,39.037034631000708,null,0,3366.0243896509942,null,0,null,1.5671159754016921E-3,3846,479.97404323303044,12.479824317031472,4.7253853889398085,5.8,211.47289649141248,6.9813090676447729,"ШД-008",5,382.90114996055735,2.5239961849316974]
["Ст.29",null,366.91164232147128,null,0,3846.3026646460357,null,0,null,0.13844283458112616,3846,-0.44110748061666527,-1.1469253266163944E-2,0,0,0,-1.1469253266163944E-2,"нет",0,0,-1.1469253266163944E-2]
["уч.10",null,32.105224743252926,null,0,3430.956703274243,null,0,null,1.0599830652031363E-3,3846,415.04223674269178,10.791529816502647,4.4439385555641024,4.5999999999999996,361.52068416157624,1.3916160317502742,"ШД-007",5,258.99087302773665,4.0574977564990933]
["Ст.30",null,376.3607936947696,null,0,3316.9546110592401,null,0,null,0.14566534757406566,3846,528.89972359318608,13.751942891138484,14.320629696475191,9,3390.4064205385412,-74.402150206587493,"ШД-011",14.5,503.21061134464787,0.66794363620744168]
["уч.38'",null,76,null,0,2553.4973844445071,null,0,null,5.9398391233009638E-3,3846,1292.4966757163697,33.606257818938374,5.1469825929696844,5.8,801.54564423701481,12.765237427960347,"ШД-008",5.5,991.26432094262418,7.8323545182981169]
["Ст.31",null,410.67325263912113,null,0,3635.6669866965885,null,0,null,0.17343643336433681,3846,210.1595768700472,5.4643675733241599,0,0,0,5.4643675733241599,"нет",0,0,5.4643675733241599]
["Ст.32",null,256.34927461189397,null,0,3424.3775580277324,null,0,null,6.7578987971657539E-2,3846,421.55486298429605,10.960864872186585,12.50851583127397,9,1572.9220334719971,-29.936743902436326,"ШД-011",13,361.32983654668163,1.5659133239109315]
["уч.47'",null,26,null,0,3178.0028336186574,null,0,null,6.9517507745004358E-4,3846,667.99647120626514,17.368602995482714,3.5505562218744013,4.5999999999999996,237.09828756901248,11.203800926605634,"ШД-007",5,169.85554404249601,12.952182193545738]
["Ст.33",null,36.665625985192264,null,0,3530.5084182898731,null,0,null,1.3825018019522183E-3,3846,315.49019920832507,8.203073302348546,0,0,0,8.203073302348546,"нет",0,0,8.203073302348546]
["Ст.34",null,123.86049773107239,null,0,3674.9963485225067,null,0,null,1.5776590016926627E-2,3846,170.98787488747621,4.4458625815776447,{"$f":"IF(M40>10,IF(3.54*(C40^2/L40)^0.25<3,3,3.54*(C40^2/L40)^0.25),IF(M40<-10,\"% big\",IF(M40<10,0)))","v":0},{"$f":"IF(N40=0,0,IF(N40<=3.5,3.5,IF(N40<=4.6,4.6,IF(N40<=5.8,5.8,IF(N40<=6.5,6.5,IF(N40<=7.5,7.5,9))))))","v":0},{"$f":"IF(O40=0,0,C40^2*3.54^4/(O40^4))","v":0},{"$f":"(L40-P40)/K40*100","v":4.4458625815776447},{"$f":"IF(O40=0,\"нет\",IF(O40=3.5,\"ШД-006\",IF(O40=4.6,\"ШД-007\",IF(O40=5.8,\"ШД-008\",IF(O40=6.5,\"ШД-009\",IF(O40=7.5,\"ШД-010\",IF(O40=9,\"ШД-011\",\"ошибка\")))))))","v":"нет"},0,{"$f":"IF(N40=0,0,C40^2*3.54^4/(S40^4))","v":0},{"$f":"(L40-T40)/K40*100","v":4.4458625815776447}]
["Ст.35",null,108.90238165751136,null,0,2445.393119311037,null,0,null,1.21961358563399E-2,3846,1400.5946845531066,36.416918475119772,6.0387052539491011,6.5,1043.3604663794329,9.2884612109639573,"ШД-009",6.5,1043.3604663794329,9.2884612109639573]
["уч.26'",null,34.659049438738954,null,0,2429.3582886637337,null,0,null,1.2353237556118678E-3,3846,1416.6404760125106,36.834125741354931,3.3970088182089087,3.5,1257.1125608579732,4.147891709686359,"ШД-006",5,301.83272586199939,28.986160950351309]
["уч.27'",null,71.507091473608796,null,0,2707.4662292216581,null,0,null,5.258304420563493E-3,3846,1138.5285124739212,29.602925441339607,5.1533761242080107,5.8,709.57662604717495,11.153195174902399,"ШД-008",5.5,877.52705966601741,6.7863092253745139]
["уч.29'",null,106.89580511105804,null,0,2874.609471169741,null,0,null,1.1750837572911163E-2,3846,971.37877799268608,25.256858502149925,6.555962195336253,7.5,567.13874754000017,10.510661218218562,"ШД-010",7,747.38127588016732,5.8241680216463543]
["Ст.37",null,94.309097683305481,null,0,2721.4718997444329,null,0,null,9.1464944962255015E-3,3846,1124.5189537610709,29.238662344281614,5.9366078485579923,6.5,782.46838799831721,8.8936704566498612,"ШД-009",6,1077.7430376938628,1.2162224666460757]
["Ст.38",null,85.735543348459515,null,0,2892.5190964092671,null,0,null,7.5590863605169449E-3,3846,953.47334450437211,24.791298609058039,5.8987036144931801,6.5,646.66808925480746,7.9772557267177495,"ШД-009",6,890.69672536682845,1.6322573878716502]
["Ст.39",null,92.484937186529748,null,0,2963.1300468305094,null,0,null,8.7960868713649609E-3,3846,882.86115708261923,22.955308296479959,6.2454777078317489,6.5,752.4915603207744,3.3897451056121901,"ШД-009",6.5,752.4915603207744,3.3897451056121901]
["Ст.40",null,43.779851922617624,null,0,3366.0243896509942,null,0,null,1.9710428898405434E-3,3846,479.97363930611618,12.479813814511601,5.0042161442504982,5.8,265.98040959702507,5.5640465342977414,"ШД-008",5.5,328.93559087855704,3.9271463449703363]
["уч.20",null,51.806158108430857,null,0,3307.8633727625338,null,0,null,2.7600075576906039E-3,3846,538.13386722990845,13.992040229586802,5.2901912650573841,5.8,372.44645688294543,4.3080449908206715,"ШД-008",5.5,460.60119822744616,2.0159300312652699]
["уч.21",null,89.201448292333424,null,0,3175.1081949018785,null,0,null,8.1825997719020913E-3,3846,670.88362249834972,17.443671931834366,6.569425884936102,7.5,394.92243488716349,7.1752778890064022,"ШД-010",7,520.43284741156424,3.9118766273215151]

{"sheet":"Регистр 10-50","index":3,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,6,9,6],[1,0,1,5],[3,0,9,0],[3,1,9,1],[3,2,9,2]]}
[]
["Теплоотдача открыто проложенных труб",{"$nulls":6},"1 труба","2 трубы","3 трубы","4 трубы"]
["t1, оС","t2, оС","tв, оС","Ду, мм","qг, Вт/м","qв, Вт/м","Q, Вт","lг1, м","lг2, м","lг3, м","lг4, м"]
[89.5,70,16,10,{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.321580135*(((A4+B4)*0.5-C4)^1.240747779),123.38*LN(((A4+B4)*0.5-C4))-466.96)","v":55.743470034025677},{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.16399692*(((A4+B4)*0.5-C4)^1.329640854),93.91*LN(((A4+B4)*0.5-C4))-356.44)","v":41.128822059601113},170,{"$f":"$G$4/E4","v":3.0496845620883022},{"$f":"$G$4/(E4*0.9)/2","v":1.6942692011601679},{"$f":"$G$4/(E4*0.9*0.9)/3","v":1.2550142230816059},{"$f":"$G$4/(E4*0.9*0.9*0.9)/4","v":1.0458451859013382}]
[null,null,null,15,{"$f":"IF(((A4+B4)*0.5-C4)<=79,((A4+B4)*0.5-C4)/(-0.0048*((A4+B4)*0.5-C4)+1.2424)+0.066,148.43*LN(((A4+B4)*0.5-C4))-559.64)","v":68.145880392994457},{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.238080045*(((A4+B4)*0.5-C4)^1.295542844),115.03*LN(((A4+B4)*0.5-C4))-433.57)","v":51.820833270348423},null,2.4946482314061695,1.3859156841145388,1.0266042104552138,0.85550350871267822]
[null,null,null,20,{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.496214489*(((A4+B4)*0.5-C4)^1.232046431),186.67*LN(((A4+B4)*0.5-C4))-709.66)","v":82.960778330806335},{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.246128613*(((A4+B4)*0.5-C4)^1.343377217),151.33*LN(((A4+B4)*0.5-C4))-576.12)","v":65.352119760070906},null,2.0491611026372549,1.1384228347984751,0.84327617392479626,0.70273014493733021]
[null,null,null,25,{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.592042752*(((A4+B4)*0.5-C4)^1.237498981),227.29*LN(((A4+B4)*0.5-C4))-864.95)","v":101.25010072942881},{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.356583242*(((A4+B4)*0.5-C4)^1.306705202),183.68*LN(((A4+B4)*0.5-C4))-695.46)","v":81.298883099420252},null,1.6790106753008762,0.93278370850048686,0.69095089518554575,0.57579241265462155]
[null,null,null,32,{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.801688483*(((A4+B4)*0.5-C4)^1.212688216),273.04*LN(((A4+B4)*0.5-C4))-1035.4)","v":123.67374327713873},{"$f":"IF(((A4+B4)*0.5-C4)<=79,((A4+B4)*0.5-C4)/(-0.0038*((A4+B4)*0.5-C4)+0.8658)+0.129,223.67*LN(((A4+B4)*0.5-C4))-364.26)","v":102.36619028145297},null,1.3745844145676858,0.76365800809315876,0.56567259858752494,0.47139383215627079]
[null,null,null,40,{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.748430133*(((A4+B4)*0.5-C4)^1.253041198),300.66*LN(((A4+B4)*0.5-C4))-1137.16)","v":136.53351858175148},{"$f":"IF(((A4+B4)*0.5-C4)<=79,27.388*EXP(0.022*((A4+B4)*0.5-C4)),263.86*LN(((A4+B4)*0.5-C4))-1000.39)","v":111.34182359750851},null,1.2451154981273698,0.69173083229298327,0.51239320910591346,0.42699434092159455]
[null,null,null,50,{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.877833837*(((A4+B4)*0.5-C4)^1.262711756),367.82*LN(((A4+B4)*0.5-C4))-1392.3)","v":166.70578288673323},{"$f":"IF(((A4+B4)*0.5-C4)<=79,0.676321906*(((A4+B4)*0.5-C4)^1.292614386),330.4*LN(((A4+B4)*0.5-C4))-1253.12)","v":145.42882864026816},null,1.0197606649044981,0.56653370272472114,0.41965459461090465,0.34971216217575385]

{"sheet":"Регистр 40-100","index":4,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,7,2,8]]}
[]
[]
[]
[null,null,"общая мощность","Вт",695]
[null,null,null,"ккал/ч",{"$f":"E4/1.163","v":597.59243336199484}]
[]
[null,null,"температура подачи t1","°С",95]
[null,null,"температура обратки t2","°С",70]
[null,null,"температура внутреннего воздуха tвн","°С",25]
[]
[null,null,"диаметр регистра","Ду",4]
[null,null,"число рядов",null,3]
[null,null,"ф",null,{"$f":"IF(E12=1,1.2,1.4)","v":1.4}]
[]
[null,null,"q","ккал/(ч*экм)",{"$f":"1.9/E13*(POWER((E7+E8)/2-E9,1.32))","v":285.35607335953131}]
[null,null,"требуемая площадь нагр поверхности","экм",{"$f":"E5/E15","v":2.0941991047412007}]
[]
[null,null,"площадь нагр поверхности 1 м"]
[null,null,"открытой горизонтальной трубы","экм/м",{"$f":"INDEX(E33:E37,E11,1)","v":0.46500000000000002}]
[]
[]
[null,null,"длина греющей трубы","м",{"$f":"E16/E19","v":4.5036539886907541}]
[]
[null,null,"длина регистра","м",{"$f":"E22/E12","v":1.5012179962302514}]
[]
[null,null,null,"Вт/м",{"$f":"E4/E22","v":154.31913769246773}]
[]
[]
[]
[]
[]
[null,null,null,"Ду","f э (экм/м)"]
[null,null,1,40,0.27]
[null,null,2,50,0.33400000000000002]
[null,null,3,65,0.40500000000000003]
[null,null,4,80,0.46500000000000002]
[null,null,null,100,0.55000000000000004]

{"sheet":"Окраска","index":5,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[34,5,34,6],[40,1,40,4],[41,1,41,4],[42,1,42,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[34,1,35,4]]}
[null,null,"площадь покраски 1 м трубы, м2"]
[]
[null,"Трубы","Ду, мм","Дн, мм","Стенка, мм","Площадь покраски 1 м трубы, м2","Кол-во, м","Площадь окраски, м2"]
[null,"стальные",15,18,2,{"$f":"3.14*D4/1000","v":5.6520000000000001E-2},null,{"$f":"G4*F4","v":0}]
[null,"электро-",20,25,2,7.85E-2,null,0]
[null,"сварные",25,32,2.2000000000000002,0.10048,null,0]
[null,"(ГОСТ",32,40,2.2000000000000002,0.12560000000000002,null,0]
[null,"10704-91)",40,45,2.2000000000000002,0.14130000000000001,null,0]
[null,null,50,57,3,0.17898000000000003,null,0]
[null,null,65,76,3,0.23864000000000002,null,0]
[null,null,80,89,3.5,0.27946000000000004,null,0]
[null,null,100,108,4,0.33911999999999998,null,0]
[null,null,100,114,3,0.35796000000000006,null,0]
[null,null,125,133,3.5,0.41761999999999999,null,0]
[null,null,150,159,3.2,0.49926000000000004,null,0]
[null,null,150,159,4,0.49926000000000004,null,0]
[null,null,200,219,4,0.68766000000000005,null,0]
[null,null,250,273,4,0.85721999999999998,null,0]
[null,null,300,325,4,1.0205,null,0]
[null,null,350,377,5,1.1837800000000001,null,0]
[null,"стальные",15,21.3,2.5,6.6882000000000011E-2,null,0]
[null,"водогазо-",20,26.8,2.5,8.4152000000000005E-2,null,0]
[null,"проводные",25,33.5,2.8,0.10518999999999999,20,2.1037999999999997]
[null,"(ГОСТ",32,42.3,2.8,0.132822,null,0]
[null,"3262-75)",40,48,3,0.15071999999999999,null,0]
[null,null,50,60,3,0.18840000000000001,null,0]
[null,null,65,75.5,3.2,0.23707000000000003,null,0]
[null,null,80,88.5,2.5,0.27788999999999997,null,0]
[null,null,90,101,3.5,0.31713999999999998,null,0]
[null,null,100,114,4,0.35796000000000006,null,0]
[null,null,125,140,4,0.43960000000000005,null,0]
[null,null,150,165,4,0.5181,null,0]
[{"$nulls":5},"Всего:",{"$f":"SUM(G4:G32)","v":20},{"$f":"SUM(H4:H32)","v":2.1037999999999997}]
[]
[null,"Наименование",null,null,null,"Показатель"]
[{"$nulls":5},"кг/м2","кг"]
[null,"1. Обезжиривание (Уайт-спирит)",null,null,null,0.32,{"$f":"ROUNDUP($H$33*F37,1)","v":0.7}]
[null,"2. Грунтование:"]
[null,"2.1 Грунт ГФ-0119 по ГОСТ 19151-73",null,null,null,0.1,{"$f":"ROUNDUP($H$33*F39,1)","v":0.30000000000000004}]
[null,"2.2 Уайт-спирит",null,null,null,0.01,{"$f":"ROUNDUP($H$33*F40,1)","v":0.1}]
[null,"3. Окраска на 2 раза по ГОСТ 10503-71"]
[null,"3.1 Краска алкидная (зеленая) МА-15",null,null,null,0.246,{"$f":"ROUNDUP($H$33*F42,1)","v":0.6}]
[null,"3.2 Олифа",null,null,null,{"$f":"2.7/100","v":2.7000000000000003E-2},{"$f":"ROUNDUP($H$33*F43,1)","v":0.1}]

{"sheet":"ТИ","index":6,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[12,0,13,0],[16,0,17,0],[18,0,19,0],[20,0,21,0],[22,0,23,0],[14,0,15,0],[30,0,31,0],[24,0,25,0],[30,7,31,7],[26,0,27,0],[28,0,29,0],[26,7,27,7],[28,7,29,7],[24,7,25,7],[0,0,0,12],[2,11,2,12],[10,11,11,11],[8,7,9,7],[14,7,15,7],[2,1,3,1],[2,0,3,0],[6,0,7,0],[10,0,11,0],[14,3,21,3],[4,7,5,7],[18,7,19,7],[20,7,21,7],[2,3,3,3],[2,4,3,4],[8,0,9,0],[6,11,7,11],[2,2,3,2],[2,6,3,6],[4,11,5,11],[16,7,17,7],[2,10,3,10],[2,5,3,5],[2,9,3,9],[2,7,2,8],[6,7,7,7],[28,11,29,11],[24,11,25,11],[8,11,9,11],[12,7,13,7],[10,7,11,7],[22,7,23,7],[32,7,33,7],[32,11,33,11],[32,0,33,0],[4,1,33,1],[22,3,33,3],[4,6,33,6],[12,11,13,11],[14,11,15,11],[4,0,5,0],[4,3,13,3],[30,11,31,11],[16,11,17,11],[18,11,19,11],[20,11,21,11],[22,11,23,11],[26,11,27,11]]}
["Параметры теплоносителя t=105-70 oC; 95-70 oC"]
[]
["Dн, мм","Антикорроз. покр.","Наименов. трубопр.","Материал изоляции","Толщина изол., мм","Объём изол., м3/м","Покровный слой","Пов-ть труб, м2/м",null,"Длина труб, м","Объём изол., м3","Пов-ть труб, м2"]
[{"$nulls":7},"без изол.","с изол.",null,null,"без изол.","с изол."]
[26,"Трехслойное покрытие из грунта ГФ-020 и краски БТ-177 (код материала 231000)","подающий","Шнур теплоизоляцион-ный из минеральной ваты в чулке из метал-лической проволоки по ТУ36-1695-73 код 576295",30,{"$f":"(3.14*(A5/1000+E5*2/1000)^2/4-3.14*(A5/1000)^2/4)*1.15","v":6.0664799999999991E-3},"Стеклотекстолит покровный листовой СТПЛ-ТБ ТУ 36-1583-72                                                           (код материала 229624)",{"$f":"A5*3.14/1000","v":8.1640000000000004E-2},{"$f":"(A5+E5*2)/1000*3.14","v":0.27004},null,{"$f":"J5*F5","v":0},{"$f":"(J5+J6)*H5","v":0},{"$f":"J5*I5","v":0}]
[null,null,"обратный",null,30,{"$f":"(3.14*(A5/1000+E6*2/1000)^2/4-3.14*(A5/1000)^2/4)*1.15","v":6.0664799999999991E-3},null,null,{"$f":"(A5+E6*2)/1000*3.14","v":0.27004},null,0,null,0]
[31,null,"подающий",null,30,{"$f":"(3.14*(A7/1000+E7*2/1000)^2/4-3.14*(A7/1000)^2/4)*1.15","v":6.6081300000000003E-3},null,{"$f":"A7*3.14/1000","v":9.734000000000001E-2},{"$f":"(A7+E7*2)/1000*3.14","v":0.28573999999999999},null,0,{"$f":"(J7+J8)*H7","v":0},0]
[null,null,"обратный",null,30,{"$f":"(3.14*(A7/1000+E8*2/1000)^2/4-3.14*(A7/1000)^2/4)*1.15","v":6.6081300000000003E-3},null,null,{"$f":"(A7+E8*2)/1000*3.14","v":0.28573999999999999},null,0,null,0]
[38,null,"подающий",null,30,{"$f":"(3.14*(A9/1000+E9*2/1000)^2/4-3.14*(A9/1000)^2/4)*1.15","v":7.366440000000001E-3},null,{"$f":"A9*3.14/1000","v":0.11932000000000001},{"$f":"(A9+E9*2)/1000*3.14","v":0.30772000000000005},2,1.4732880000000002E-2,{"$f":"(J9+J10)*H9","v":0.23864000000000002},0.6154400000000001]
[null,null,"обратный",null,30,{"$f":"(3.14*(A9/1000+E10*2/1000)^2/4-3.14*(A9/1000)^2/4)*1.15","v":7.366440000000001E-3},null,null,{"$f":"(A9+E10*2)/1000*3.14","v":0.30772000000000005},null,0,null,0]
[46,null,"подающий",null,30,{"$f":"(3.14*(A11/1000+E11*2/1000)^2/4-3.14*(A11/1000)^2/4)*1.15","v":8.2330800000000003E-3},null,{"$f":"A11*3.14/1000","v":0.14443999999999999},{"$f":"(A11+E11*2)/1000*3.14","v":0.33284000000000002},5,4.1165400000000005E-2,{"$f":"(J11+J12)*H11","v":0.72219999999999995},1.6642000000000001]
[null,null,"обратный",null,30,{"$f":"(3.14*(A11/1000+E12*2/1000)^2/4-3.14*(A11/1000)^2/4)*1.15","v":8.2330800000000003E-3},null,null,{"$f":"(A11+E12*2)/1000*3.14","v":0.33284000000000002},null,0,null,0]
[57,null,"подающий",null,30,{"$f":"(3.14*(A13/1000+E13*2/1000)^2/4-3.14*(A13/1000)^2/4)*1.15","v":9.4247099999999976E-3},null,{"$f":"A13*3.14/1000","v":0.17898000000000003},{"$f":"(A13+E13*2)/1000*3.14","v":0.36738000000000004},null,0,{"$f":"(J13+J14)*H13","v":9.8439000000000014},0]
[null,null,"обратный",null,30,{"$f":"(3.14*(A13/1000+E14*2/1000)^2/4-3.14*(A13/1000)^2/4)*1.15","v":9.4247099999999976E-3},null,null,{"$f":"(A13+E14*2)/1000*3.14","v":0.36738000000000004},55,0.51835904999999982,null,20.205900000000003]
[76,null,"подающий","Минераловатные плиты \"ПМ\" по ГОСТ 9573-96 код 576203",40,{"$f":"(3.14*(A15/1000+E15*2/1000)^2/4-3.14*(A15/1000)^2/4)*1.15","v":1.6755040000000002E-2},null,{"$f":"A15*3.14/1000","v":0.23864000000000002},{"$f":"(A15+E15*2)/1000*3.14","v":0.48984},5,8.3775200000000008E-2,{"$f":"(J15+J16)*H15","v":1.1932},2.4491999999999998]
[null,null,"обратный",null,30,{"$f":"(3.14*(A15/1000+E16*2/1000)^2/4-3.14*(A15/1000)^2/4)*1.15","v":1.1482980000000002E-2},null,null,{"$f":"(A15+E16*2)/1000*3.14","v":0.42704000000000003},null,0,null,0]
[89,null,"подающий",null,40,{"$f":"(3.14*(A17/1000+E17*2/1000)^2/4-3.14*(A17/1000)^2/4)*1.15","v":1.8632759999999998E-2},null,{"$f":"A17*3.14/1000","v":0.27946000000000004},{"$f":"(A17+E17*2)/1000*3.14","v":0.53066000000000002},8,0.14906207999999999,{"$f":"(J17+J18)*H17","v":4.4713600000000007},4.2452800000000002]
[null,null,"обратный",null,30,{"$f":"(3.14*(A17/1000+E18*2/1000)^2/4-3.14*(A17/1000)^2/4)*1.15","v":1.2891270000000002E-2},null,null,{"$f":"(A17+E18*2)/1000*3.14","v":0.46786},8,0.10313016000000001,null,3.74288]
[108,null,"подающий",null,40,{"$f":"(3.14*(A19/1000+E19*2/1000)^2/4-3.14*(A19/1000)^2/4)*1.15","v":2.1377120000000003E-2},null,{"$f":"A19*3.14/1000","v":0.33911999999999998},{"$f":"(A19+E19*2)/1000*3.14","v":0.59032000000000007},20,0.42754240000000004,{"$f":"(J19+J20)*H19","v":13.564799999999998},11.806400000000002]
[null,null,"обратный",null,30,{"$f":"(3.14*(A19/1000+E20*2/1000)^2/4-3.14*(A19/1000)^2/4)*1.15","v":1.4949539999999996E-2},null,null,{"$f":"(A19+E20*2)/1000*3.14","v":0.5275200000000001},20,0.29899079999999989,null,10.550400000000002]
[133,null,"подающий",null,40,{"$f":"(3.14*(A21/1000+E21*2/1000)^2/4-3.14*(A21/1000)^2/4)*1.15","v":2.4988119999999999E-2},null,{"$f":"A21*3.14/1000","v":0.41761999999999999},{"$f":"(A21+E21*2)/1000*3.14","v":0.66881999999999997},{"$f":"45/2","v":22.5},0.56223270000000003,{"$f":"(J21+J22)*H21","v":18.792899999999999},15.048449999999999]
[null,null,"обратный",null,30,{"$f":"(3.14*(A21/1000+E22*2/1000)^2/4-3.14*(A21/1000)^2/4)*1.15","v":1.765779E-2},null,null,{"$f":"(A21+E22*2)/1000*3.14","v":0.60602},{"$f":"J21","v":22.5},0.39730027499999998,null,13.635450000000001]
[159,null,"подающий","Маты минераловатные прошивные (в обкладке из сетки) по ГОСТ 21880-94",50,{"$f":"(3.14*(A23/1000+E23*2/1000)^2/4-3.14*(A23/1000)^2/4)*1.15","v":3.7734949999999989E-2},null,{"$f":"A23*3.14/1000","v":0.49926000000000004},{"$f":"(A23+E23*2)/1000*3.14","v":0.81326000000000009},10,0.37734949999999989,{"$f":"(J23+J24)*H23","v":9.9852000000000007},8.1326000000000001]
[null,null,"обратный",null,40,{"$f":"(3.14*(A23/1000+E24*2/1000)^2/4-3.14*(A23/1000)^2/4)*1.15","v":2.8743559999999994E-2},null,null,{"$f":"(A23+E24*2)/1000*3.14","v":0.75046000000000002},10,0.28743559999999996,null,7.5045999999999999]
[219,null,"подающий",null,50,{"$f":"(3.14*(A25/1000+E25*2/1000)^2/4-3.14*(A25/1000)^2/4)*1.15","v":4.8567949999999999E-2},null,{"$f":"A25*3.14/1000","v":0.68766000000000005},{"$f":"(A25+E25*2)/1000*3.14","v":1.00166},null,0,{"$f":"(J25+J26)*H25","v":0},0]
[null,null,"обратный",null,40,{"$f":"(3.14*(A25/1000+E26*2/1000)^2/4-3.14*(A25/1000)^2/4)*1.15","v":3.7409959999999992E-2},null,null,{"$f":"(A25+E26*2)/1000*3.14","v":0.93886000000000003},null,0,null,0]
[273,null,"подающий",null,50,{"$f":"(3.14*(A27/1000+E27*2/1000)^2/4-3.14*(A27/1000)^2/4)*1.15","v":5.8317649999999985E-2},null,{"$f":"A27*3.14/1000","v":0.85721999999999998},{"$f":"(A27+E27*2)/1000*3.14","v":1.1712200000000001},null,0,{"$f":"(J27+J28)*H27","v":0},0]
[null,null,"обратный",null,40,{"$f":"(3.14*(A27/1000+E28*2/1000)^2/4-3.14*(A27/1000)^2/4)*1.15","v":4.5209720000000009E-2},null,null,{"$f":"(A27+E28*2)/1000*3.14","v":1.10842},null,0,null,0]
[325,null,"подающий",null,50,{"$f":"(3.14*(A29/1000+E29*2/1000)^2/4-3.14*(A29/1000)^2/4)*1.15","v":6.7706250000000023E-2},null,{"$f":"A29*3.14/1000","v":1.0205},{"$f":"(A29+E29*2)/1000*3.14","v":1.3345},null,0,{"$f":"(J29+J30)*H29","v":0},0]
[null,null,"обратный",null,40,{"$f":"(3.14*(A29/1000+E30*2/1000)^2/4-3.14*(A29/1000)^2/4)*1.15","v":5.2720600000000006E-2},null,null,{"$f":"(A29+E30*2)/1000*3.14","v":1.2717000000000001},null,0,null,0]
[377,null,"подающий",null,50,{"$f":"(3.14*(A31/1000+E31*2/1000)^2/4-3.14*(A31/1000)^2/4)*1.15","v":7.7094849999999979E-2},null,{"$f":"A31*3.14/1000","v":1.1837800000000001},{"$f":"(A31+E31*2)/1000*3.14","v":1.4977799999999999},null,0,{"$f":"(J31+J32)*H31","v":0},0]
[null,null,"обратный",null,40,{"$f":"(3.14*(A31/1000+E32*2/1000)^2/4-3.14*(A31/1000)^2/4)*1.15","v":6.0231480000000011E-2},null,null,{"$f":"(A31+E32*2)/1000*3.14","v":1.4349800000000001},null,0,null,0]
[426,null,"подающий",null,50,{"$f":"(3.14*(A33/1000+E33*2/1000)^2/4-3.14*(A33/1000)^2/4)*1.15","v":8.5941800000000013E-2},null,{"$f":"A33*3.14/1000","v":1.3376400000000002},{"$f":"(A33+E33*2)/1000*3.14","v":1.6516400000000002},null,0,{"$f":"(J33+J34)*H33","v":0},0]
[null,null,"обратный",null,40,{"$f":"(3.14*(A33/1000+E34*2/1000)^2/4-3.14*(A33/1000)^2/4)*1.15","v":6.7309039999999987E-2},null,null,{"$f":"(A33+E34*2)/1000*3.14","v":1.58884},null,0,null,0]
[{"$nulls":9},"Шнур, м3",{"$f":"SUM(K5:K14)","v":0.57425732999999979}]
[{"$nulls":9},"Плиты, м3",{"$f":"SUM(K15:K22)","v":2.0220336149999998}]
[{"$nulls":9},"Маты, м3",{"$f":"SUM(K23:K34)","v":0.6647850999999998}]
[{"$nulls":9},"С/текст, м2",null,null,{"$f":"SUM(M5:M34)","v":99.600800000000007}]
[{"$nulls":9},"Пов-ть, м2",null,{"$f":"SUM(L5:L34)","v":58.812199999999997}]