{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Расчет","Табл","Данные"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":68,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Расчет","index":0,"n_rows":311,"n_cols":61,"rows_kept":311,"cut":false,"hidden":false,"merged":[[247,3,248,5],[245,3,245,5],[254,9,254,10],[246,3,246,5],[3,9,3,11],[192,7,192,8],[216,7,216,8],[210,7,210,8],[201,7,201,8],[183,7,183,8],[147,7,147,8],[98,7,98,8],[87,7,87,8],[305,1,305,11],[256,9,256,10],[263,9,263,10],[251,9,251,10],[253,5,253,6],[262,9,262,10],[257,9,257,10],[253,9,253,10],[256,5,256,6],[255,5,255,6],[254,5,254,6],[255,9,255,10],[252,9,252,10],[0,0,0,6],[10,2,10,4],[11,2,11,4],[12,2,12,4],[20,7,20,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"пролёт","h балки",null,null,"Тип","°t вн","ГСОП",null,{"$f":"CONCATENATE(\"Толщина утеплителя кровли и стен определена согласно требованиям СНиП 23-02-2003 как для \",X4,\" помещений с внутренней температурой  + \",Y3,\" °С, для нормальных условий влажности. При изменении температурно-влажностных условий внутренней среды помещения толщина утеплителя и стоимость ограждающих конструкций подлежат уточнению.\")","v":{"$error":"#REF!"}},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Окна_нащельники",null,"$",50,{"$f":"2.36/(3)","v":0.78666666666666663},50,{"$f":"(AZ2+40*2)*1.5/10^6*7850","v":1.5307500000000001},null,"Двери_нащельник",null,50,0.74,null,"Ворота_нащельник","$"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1.2,null,null,{"$f":"N4","v":0},{"$f":"VLOOKUP(X3,Табл!#REF!,2,0)","v":{"$error":"#REF!"}},{"$f":"(Y3-VLOOKUP(N5,Табл!#REF!,5,0))*VLOOKUP(N5,Табл!#REF!,4,0)","v":{"$error":"#REF!"}},{"$f":"IF(EVEN(ROUNDUP(Z3/1000,0)-2)*1000<12000,MAX(EVEN(ROUNDUP(Z3/1000,0)-2)*1000,0),\"STOP\")","v":{"$error":"#REF!"}},null,null," ",null,null,null,{"$f":"IF(AJ3>=AG6,1,0)+AK2","v":{"$error":"#REF!"}},"СПО 4М1-16-4М1",0.32,"1 кам",0,null,null,null,{"$f":"IF(AR3>=AO6,1,0)+AS2","v":{"$error":"#REF!"}},"СПО 4М1-16-4М1",0.32,"1 кам",0,null,"Цена 1 кг нащ",{"$f":"533/5.5/Курс","v":3.0284090909090908},80,{"$f":"2.36/(3)","v":0.78666666666666663},80,1.8840000000000001,null,"Цена 1 кг нащ",{"$f":"AW3","v":3.0284090909090908},80,0.91,null,"Цена 1 кг нащ",{"$f":"AW3","v":3.0284090909090908}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,1.3,null,null,{"$f":"IF(X3=1,\"общественных\",IF(X3=2,\"производственных\",IF(X3=3,\"складских\",\"###\")))","v":"###"},null,null,null,null,null," ",null,null,null,{"$f":"IF(AJ4>=AG6,1,0)+AH3","v":{"$error":"#REF!"}},"СПД 4М-10-4М-10-4М",{"$f":"IF(N20,0.47,0)","v":0},"2 кам",18,null,null,null,{"$f":"IF(AR4>=AO6,1,0)+AP3","v":{"$error":"#REF!"}},"СПД 4М-10-4М-10-4М",{"$f":"IF(N20,0.47,0)","v":0},"2 кам",18,null,"Цена 1 кг гн. Проф",{"$f":"Табл!D27/Курс/1000","v":2.0125000000000002},100,{"$f":"2.46/(3)","v":0.82},100,2.1194999999999999,null,"Цена 1 кг гн. Проф",{"$f":"Табл!D27/Курс/1000","v":2.0125000000000002},100,1.02,null,"Цена 1 кг гн. Проф",{"$f":"Табл!D27/Курс/1000","v":2.0125000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,1.4,null,null,null,null,"R, м2*°С/Вт",null,null,null,null,null,null,null,{"$f":"IF(AJ5>=AG6,1,0)+AH4","v":{"$error":"#REF!"}},"4М1-16-И4",0.59,"1 кам ЭС",17,null,null,null,{"$f":"IF(AR5>=AO6,1,0)+AP4","v":{"$error":"#REF!"}},"4М1-16-И4",0.59,"1 кам ЭС",17,null,"Саморез гн. проф",0.1215,120,{"$f":"2.59/(3)","v":0.86333333333333329},120,2.355,null,"Саморез гн. проф",0.13150000000000001,120,1.1299999999999999,null,"Саморез гн. проф",0.13150000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,1.4,"ПРОВЕРКА!!! У Кожина В.И. дата",null,null,"Кровля",{"$f":"IF(X3=1,VLOOKUP(AA3,Табл!B103:E109,3,0),VLOOKUP(AA3,Табл!B111:E117,3,0))","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(Z6+(Z3-AA3)/2000*(Z7-Z6),3)","v":{"$error":"#REF!"}},"Стены",{"$f":"IF(X3=1,VLOOKUP(AA3,Табл!B103:E109,2,0),VLOOKUP(AA3,Табл!B111:E117,2,0))","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(AC6+(Z3-AA3)/2000*(AC7-AC6),3)","v":{"$error":"#REF!"}},"Окна",{"$f":"IF(X3=1,VLOOKUP(AA3,Табл!B103:E109,4,0),VLOOKUP(AA3,Табл!B111:E117,4,0))","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(AF6+(Z3-AA3)/2000*(AF7-AF6),3)","v":{"$error":"#REF!"}},{"$f":"IF(AJ6>=AG6,1,0)+AH5","v":{"$error":"#REF!"}},"4М1-10-4М1-10-И4",0.64,"2 кам ЭС",30,"Фонарь",{"$f":"IF(X3=1,VLOOKUP(AA3,Табл!B103:E109,5,0),VLOOKUP(AA3,Табл!B111:E117,5,0))","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(AN6+(Z3-AA3)/2000*(AN7-AN6),3)","v":{"$error":"#REF!"}},{"$f":"IF(AR6>=AO6,1,0)+AP5","v":{"$error":"#REF!"}},"4М1-10-4М1-10-И4",0.64,"2 кам ЭС",30,null,"Саморез нащельн.",0.1215,150,{"$f":"2.8/(3)","v":0.93333333333333324},150,2.70825,null,"Саморез нащельн.",0.1215,150,1.29,null,"Саморез нащельн.",0.1215]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,1.5,"Междуэтажка",null,"S, м2","М уд",{"$f":"IF(X3=1,VLOOKUP(AA3+2000,Табл!B103:E109,3,0),VLOOKUP(AA3+2000,Табл!B111:E117,3,0))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(X3=1,VLOOKUP(AA3+2000,Табл!B103:E109,2,0),VLOOKUP(AA3+2000,Табл!B111:E117,2,0))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(X3=1,VLOOKUP(AA3+2000,Табл!B103:E109,4,0),VLOOKUP(AA3+2000,Табл!B111:E117,4,0))","v":{"$error":"#REF!"}},null,{"$f":"IF(AJ7>=AG6,1,0)+AH6","v":{"$error":"#REF!"}},"4М1-Ar10-4М1-Ar10-И4",0.71,"2 кам Ar",46,null,{"$f":"IF(X3=1,VLOOKUP(AA3+2000,Табл!B103:E109,5,0),VLOOKUP(AA3+2000,Табл!B111:E117,5,0))","v":{"$error":"#REF!"}},null,{"$f":"IF(AR7>=AO6,1,0)+AP6","v":{"$error":"#REF!"}},"4М1-Ar10-4М1-Ar10-И4",0.71,"2 кам Ar",46,null,"Саморез окон. проф",{"$f":"1.8/Курс","v":5.6250000000000001E-2},180,{"$f":"3.03/(3)","v":1.01},180,3.0615000000000001,null,null,null,180,1.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,1.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1стекло",-10,null,null,null,null,null,null,"1стекло",-10,null,null,null,200,{"$f":"3.18/(3)","v":1.06},200,3.2970000000000002,null,null,null,200,1.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,1.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,{"$f":"3.58/(3)","v":1.1933333333333334},250,3.8857499999999998,null,null,null,250,1.84]
["III","Стены",null,null,"Hцок=",{"$f":"IF(O2=\"Ориентировочный расчёт. СПАЙДЕР.\",0,0.3)","v":0.3},null,"Ветер -","I","м2","Ц(р)","С(руб)"]
[{"$f":"IF(O2=\"Ориентировочный расчёт. СПАЙДЕР.\",0.314,IF(Ш/пролёт>=21,VLOOKUP(Ш/пролёт,$T$3:$U$9,2,1),1.2))","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(C11,Данные!$A$32:$D$53,3,0)","v":100},"ВС100",null,null,null,{"$f":"IF(парапет>0,\"вкл парапет\",\"\")","v":{"$error":"#REF!"}},true,{"$f":"IF(H11,\"уч. проемов\",\"без учета\")","v":"уч. проемов"},{"$f":"(Ш+Д+2.4)*2*(В+балка+парапет)+IF(AND(#REF!=2,парапет=0),(Ш/2*Уклон+1.2*Уклон)*(Ш+1.2),0)+IF(AND(#REF!=1,парапет=0),(Ш*Уклон+1.2*Уклон)*(Ш+1.2)+Ш*Уклон*(Д+1.2),0)-(Ш+Д)*2*цоколь-IF(H11,A66+A95+A137+A190+A199+A208+A215+A242,0)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(C11,Данные!A$32:B$53,2,0)","v":1582},{"$f":"ROUND(J11*K11,$N$1)","v":{"$error":"#DIV/0!"}}]
[0,{"$f":"VLOOKUP(C12,Данные!$A$32:$D$53,3,0)","v":50},"ВС18",null,null,null,null,null,null,null,{"$f":"VLOOKUP(C12,Данные!A$32:B$53,2,0)","v":444},{"$f":"ROUND(J12*K12,$N$1)","v":0}]
[0,{"$f":"VLOOKUP(C13,Данные!$A$32:$D$53,3,0)","v":50},"ВС18",null,null,null,"фриз навеса / козырька h=",0,null,{"$f":"каркас_фриза*фриз","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C13,Данные!A$32:B$53,2,0)","v":444},{"$f":"ROUND(J13*K13,$N$1)","v":{"$error":"#REF!"}}]
[true,{"$f":"IF(Раскладка,\"Раскладка вертикальная\",\"Раскладка горизонтальная\")","v":"Раскладка вертикальная"},null,null,null,{"$f":"IF(AND(шаг_кол>6,B14=\"Раскладка горизонтальная\"),\"Проверь шаг колонн!!!\",\"\")","v":""},null,null,null,null,null,"Стоимость для базовых цветов."]
[{"$f":"IF(#REF!=0,0.8,IF(A18,IF(#REF!=1,Ш/10,Ш/20),0))","v":{"$error":"#REF!"}}]
[]
[{"$f":"VLOOKUP(C11,Данные!$A$32:$F$53,6,0)","v":1.19},"Всего стоимость ограждающих конструкций",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:L14)","v":{"$error":"#DIV/0!"}}]
[false]
[null,"Всего стоимость каркаса и ограждающих конструкций",null,null,null,null,null,null,null,null,null,{"$f":"#REF!+L17","v":{"$error":"#REF!"}}]
[]
["IV","Окна",null,"шт","профиль","стеклопакет  ","тип","размер (ш х в) ",null,"м2","Ц(р/м2)","С(руб)"]
[null,null,null,null,"НЕТ /Не поставляются/"]
[{"$f":"IF(Раскладка,IF(H23>шир_пан,(ROUNDDOWN(H23/шир_пан,0)-1)*шир_пан*I23*D23,0),IF(I23>шир_пан,(ROUNDDOWN(I23/шир_пан,0)-1)*шир_пан*H23*D23,0))","v":0},{"$f":"IF(D23>0,1,0)","v":0}]
[0,{"$f":"IF(D24>0,MAX(B23)+1,0)","v":0}]
[0,{"$f":"IF(D25>0,MAX(B$23:B24)+1,0)","v":0}]
[0,{"$f":"IF(D26>0,MAX(B$23:B25)+1,0)","v":0}]
[0,{"$f":"IF(D27>0,MAX(B$23:B26)+1,0)","v":0}]
[0,{"$f":"IF(D28>0,MAX(B$23:B27)+1,0)","v":0}]
[0,{"$f":"IF(D29>0,MAX(B$23:B28)+1,0)","v":0}]
[0,{"$f":"IF(D30>0,MAX(B$23:B29)+1,0)","v":0}]
[0,{"$f":"IF(D31>0,MAX(B$23:B30)+1,0)","v":0}]
[0,{"$f":"IF(D32>0,MAX(B$23:B31)+1,0)","v":0}]
[0,{"$f":"IF(D33>0,MAX(B$23:B32)+1,0)","v":0}]
[0,{"$f":"IF(D34>0,MAX(B$23:B33)+1,0)","v":0}]
[0,{"$f":"IF(D35>0,MAX(B$23:B34)+1,0)","v":0}]
[0,{"$f":"IF(D36>0,MAX(B$23:B35)+1,0)","v":0}]
[0,{"$f":"IF(D37>0,MAX(B$23:B36)+1,0)","v":0}]
[0,{"$f":"IF(D38>0,MAX(B$23:B37)+1,0)","v":0}]
[0,{"$f":"IF(D39>0,MAX(B$23:B38)+1,0)","v":0}]
[0,{"$f":"IF(D40>0,MAX(B$23:B39)+1,0)","v":0}]
[0,{"$f":"IF(D41>0,MAX(B$23:B40)+1,0)","v":0}]
[null,{"$f":"IF(D42>0,MAX(B$23:B41)+1,0)","v":0}]
[null,{"$f":"IF(D43>0,MAX(B$23:B42)+1,0)","v":0},null,null,null,"2 кам",null,null,null,{"$f":"D43*H43*I43","v":0},null,{"$f":"ROUND(J43*K43,$N$1)","v":0}]
[null,{"$f":"IF(D44>0,MAX(B$23:B43)+1,0)","v":0},null,null,null,"1 кам ЭС",null,null,null,0,null,0]
[null,{"$f":"IF(D45>0,MAX(B$23:B44)+1,0)","v":0},null,null,null,"2 кам ЭС",null,null,null,0,null,0]
[null,{"$f":"IF(D46>0,MAX(B$23:B45)+1,0)","v":0},null,null,null,"2 кам Ar",null,null,null,0,null,0]
[null,{"$f":"IF(D47>0,MAX(B$23:B46)+1,0)","v":0},null,null,null,"1стекло",null,null,null,0,null,0]
[null,{"$f":"IF(D48>0,MAX(B$23:B47)+1,0)","v":0},null,null,"Алюминий","2 кам","глухие",null,"кв м 1 шт",{"$f":"D48*H48","v":0},null,0,null,"Обрамление гн профилем","Обрамление гн профилем + нащельники","Нащельники","-"]
[{"$f":"IF(Раскладка,IF(H49>шир_пан,(ROUNDDOWN(H49/шир_пан,0)-1)*шир_пан*I49*D49,0),IF(I49>шир_пан,(ROUNDDOWN(I49/шир_пан,0)-1)*шир_пан*H49*D49,0))","v":0},{"$f":"IF(D49>0,MAX(B$23:B48)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,1.2,1.2,0,{"$f":"HLOOKUP(F49,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N49,1)+1,0)","v":550.4},0,null,{"$f":"(ROUND(((H49+I49+0.06)*2*VLOOKUP(толщ_ут_стен,$AZ$2:$BA$9,2)*$AW$4+ROUNDUP((H49+I49)*2/4.8,0)*0.18*$AW$4+ROUNDUP((H49/0.5+1)*4+(I49/0.5+1)*4,0)*$AW$5)/(H49*I49),1))*Курс","v":550.4},{"$f":"(ROUND(IF(H49>6,((6+I49+0.3)*4*VLOOKUP(толщ_ут_стен,$AX$2:$AY$9,2)*$AW$3+(6+0.15)*0.77*$AW$3+(6+I49+0.06)*2*VLOOKUP(толщ_ут_стен,$AZ$2:$BA$9,2)*$AW$4+ROUNDUP((6+I49)*2/4.8,0)*0.18*$AW$4+ROUNDUP((6/0.5+1)*4+(I49/0.5+1)*4,0)*$AW$5+(ROUNDUP((6/0.3+1)*4+(I49/0.3+1)*4,0)*2+ROUNDUP(6/0.3+1,0))*$AW$6+ROUNDUP((6/0.5+1)*2+(I49/0.5+1)*2,0)*$AW$7)/(6*I49),((H49+I49+0.3)*4*VLOOKUP(толщ_ут_стен,$AX$2:$AY$9,2)*$AW$3+(H49+0.15)*0.77*$AW$3+(H49+I49+0.06)*2*VLOOKUP(толщ_ут_стен,$AZ$2:$BA$9,2)*$AW$4+ROUNDUP((H49+I49)*2/4.8,0)*0.18*$AW$4+ROUNDUP((H49/0.5+1)*4+(I49/0.5+1)*4,0)*$AW$5+(ROUNDUP((H49/0.3+1)*4+(I49/0.3+1)*4,0)*2+ROUNDUP(H49/0.3+1,0))*$AW$6+ROUNDUP((H49/0.5+1)*2+(I49/0.5+1)*2,0)*$AW$7)/(H49*I49)),1))*Курс","v":1462.4},{"$f":"O49-N49","v":912.00000000000011},0]
[{"$f":"IF(Раскладка,IF(H50>шир_пан,(ROUNDDOWN(H50/шир_пан,0)-1)*шир_пан*I50*D50,0),IF(I50>шир_пан,(ROUNDDOWN(I50/шир_пан,0)-1)*шир_пан*H50*D50,0))","v":0},{"$f":"IF(D50>0,MAX(B$23:B49)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,2.2000000000000002,1.3,0,{"$f":"HLOOKUP(F50,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N50,1)+1,0)","v":396.8},0,null,396.8,1052.8,{"$f":"O50-N50","v":656},0]
[{"$f":"IF(Раскладка,IF(H51>шир_пан,(ROUNDDOWN(H51/шир_пан,0)-1)*шир_пан*I51*D51,0),IF(I51>шир_пан,(ROUNDDOWN(I51/шир_пан,0)-1)*шир_пан*H51*D51,0))","v":0},{"$f":"IF(D51>0,MAX(B$23:B50)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,3.2,1.4,0,{"$f":"HLOOKUP(F51,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N51,1)+1,0)","v":329.6},0,null,329.6,873.6,{"$f":"O51-N51","v":544},0]
[{"$f":"IF(Раскладка,IF(H52>шир_пан,(ROUNDDOWN(H52/шир_пан,0)-1)*шир_пан*I52*D52,0),IF(I52>шир_пан,(ROUNDDOWN(I52/шир_пан,0)-1)*шир_пан*H52*D52,0))","v":0},{"$f":"IF(D52>0,MAX(B$23:B51)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,4.2,1.5,0,{"$f":"HLOOKUP(F52,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N52,1)+1,0)","v":288},0,null,288,764.8,476.79999999999995,0]
[{"$f":"IF(Раскладка,IF(H53>шир_пан,(ROUNDDOWN(H53/шир_пан,0)-1)*шир_пан*I53*D53,0),IF(I53>шир_пан,(ROUNDDOWN(I53/шир_пан,0)-1)*шир_пан*H53*D53,0))","v":0},{"$f":"IF(D53>0,MAX(B$23:B52)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,5.2,1.6,{"$f":"D53*H53*I53","v":0},{"$f":"HLOOKUP(F53,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N53,1)+1,0)","v":259.2},0,null,259.2,684.8,425.59999999999997,0]
[0,{"$f":"IF(D54>0,MAX(B$23:B53)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,6.2,1.47,0,{"$f":"HLOOKUP(F54,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N54,1)+1,0)","v":265.60000000000002},0,null,265.60000000000002,710.4,444.79999999999995,0]
[0,{"$f":"IF(D55>0,MAX(B$23:B54)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,7.2,1.59,0,{"$f":"HLOOKUP(F55,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N55,1)+1,0)","v":243.2},0,null,243.2,668.8,425.59999999999997,0]
[0,{"$f":"IF(D56>0,MAX(B$23:B55)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,8.1999999999999993,1.8,0,{"$f":"HLOOKUP(F56,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N56,1)+1,0)","v":214.4},0,null,214.4,604.79999999999995,390.4,0]
[0,{"$f":"IF(D57>0,MAX(B$23:B56)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,9.1999999999999993,1.9,0,{"$f":"HLOOKUP(F57,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N57,1)+1,0)","v":198.4},0,null,198.4,579.20000000000005,380.80000000000007,0]
[0,{"$f":"IF(D58>0,MAX(B$23:B57)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,10.199999999999999,1.1200000000000001,0,{"$f":"HLOOKUP(F58,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N58,1)+1,0)","v":310.39999999999998},0,null,310.39999999999998,892.8,582.4,0]
[0,{"$f":"IF(D59>0,MAX(B$23:B58)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,11.2,1.125,0,{"$f":"HLOOKUP(F59,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N59,1)+1,0)","v":307.2},0,null,307.2,889.6,582.40000000000009,0]
[0,{"$f":"IF(D60>0,MAX(B$23:B59)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,12.2,1.5649999999999999,0,{"$f":"HLOOKUP(F60,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N60,1)+1,0)","v":224},0,null,224,675.2,451.20000000000005,0]
[0,{"$f":"IF(D61>0,MAX(B$23:B60)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,13.2,1.258,0,{"$f":"HLOOKUP(F61,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N61,1)+1,0)","v":272},0,null,272,812.8,540.79999999999995,0]
[{"$f":"IF(Раскладка,IF(H62>шир_пан,(ROUNDDOWN(H62/шир_пан,0)-1)*шир_пан*I62*D62,0),IF(I62>шир_пан,(ROUNDDOWN(I62/шир_пан,0)-1)*шир_пан*H62*D62,0))","v":0},{"$f":"IF(D62>0,MAX(B$23:B61)+1,0)","v":0},null,null,"Проём","Обрамление гн профилем",null,14.2,1.32548,0,{"$f":"HLOOKUP(F62,$N$48:$Q$62,ROW()-MATCH(\"яя\",N$1:N62,1)+1,0)","v":259.2},0,null,259.2,777.6,518.40000000000009,0]
[null,"Тонировка",null,null,null,null,null,null,null,{"$f":"SUM(J23:J41)","v":0},null,0]
[null,null,null,null,"Механизмы открывания окон с пола ",null,null,null,null,null,{"$f":"200*Курс","v":6400},0]
[null,"Нащельники и доборные элементы окон",null,null,null,null,null,null,null,{"$f":"SUM(J22:J41)","v":0},{"$f":"L65/J65/Курс","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(SUMPRODUCT(C23:C41,J23:J41)*Курс,$N$1)","v":0}]
[{"$f":"SUM(A23:A65)","v":0},{"$f":"IF(SUM(D23:D41)>0,\"Размер секции окон:\",\"\")","v":""},null,null,null,null,null,null,"Итого:",{"$f":"SUM(J23:J62)","v":0},null,{"$f":"SUM(L22:L65)","v":0}]
[null,{"$f":"IF(D23>0,CONCATENATE(\"п. \",B23,\")  \", N23,\" х \",O23,\"(h) м\"),\"\")","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(D90>0,CONCATENATE(\"п. \",B90,\")  \", N90,\" х \",O90,\"(h) м\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(D100>0,CONCATENATE(\"п. \",B100,\")  \",N100,\"х\",O100, \"(h) м\"),\"\")","v":""}]
[null,{"$f":"IF(D101>0,CONCATENATE(\"п. \",B101,\") - \",N101,\"х\",O101, \"(h) м\"),\"\")","v":""}]
[null,{"$f":"IF(D102>0,CONCATENATE(\"п. \",B102,\") - \",N102,\"х\",O102, \"(h) м\"),\"\")","v":""}]
[null,{"$f":"IF(D103>0,CONCATENATE(\"п. \",B103,\") - \",N103,\"х\",O103, \"(h) м\"),\"\")","v":""}]
[null,{"$f":"IF(D104>0,CONCATENATE(\"п. \",B104,\") - \",N104,\"х\",O104, \"(h) м\"),\"\")","v":""}]
[null,{"$f":"IF(D105>0,CONCATENATE(\"п. \",B105,\") - \",N105,\"х\",O105, \"(h) м\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L262*Процентъ","v":{"$error":"#REF!"}},{"$f":"#REF!*Процентъ2","v":{"$error":"#REF!"}},{"$f":"#REF!*Процентъ3","v":{"$error":"#REF!"}}]
[null,null,null,"курс $",32,null,null,null,null,{"$f":"L262/Курс","v":0},null,{"$f":"L262/(Площадь+ПлощадьА+Sнавеса+Sкозырька)/Курс","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!-P262","v":{"$error":"#REF!"}},{"$f":"#REF!-Q262","v":{"$error":"#REF!"}},{"$f":"#REF!-R262","v":{"$error":"#REF!"}}]
[null,null,null,"курс €",44,null,null,null,null,{"$f":"L262/курс_евро","v":0},null,{"$f":"L262/(Площадь+ПлощадьА+Sнавеса+Sкозырька)/курс_евро","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(OR(O2=\"Ориентировочный расчёт. СПАЙДЕР.\",O2=\"Ориентировочный расчёт. КОНДОР.\"),A66+A95+A137+A190+A199+A208+A215+A242,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]

{"sheet":"Табл","index":1,"n_rows":117,"n_cols":5,"rows_kept":117,"cut":false,"hidden":false,"merged":[[29,3,29,4],[26,3,26,4],[27,3,27,4],[28,3,28,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,70900,73700]
[null,null,null,72800,75700]
[null,null,null,89700,95700]
[null,null,null,76000,82900]
[null,null,null,73800,81800]
[null,null,null,113300,117500]
[null,null,null,85800,93000]
[null,null,null,77000,85000]
[null,null,null,64400]
[null,null,null,98900]
[null,null,null,89200]
[null,null,null,80800]
[null,null,null,79800,82700]
[null,null,null,100100,106400]
[null,null,null,83200,86000]
[]
[]
[]
[]
[]
[null,"Каркас"]
[null,"Фриза",25]
[null,"Тамбура",50]
[null,"Подвесного тотолка",15]
[null,"Светоовой фонарь",65]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rкг/кв м  перекр",null,"t вн °С"]
[]
["Автоцентр"]
["Общежитие"]
["АБК",1,200,"2 кам",20]
["Ангар",3,300,"1 кам",12]
["Вышка","?",200,"1 кам",0]
["Гараж",2,300,"1 кам",16]
["Каркас","?",300,"1 кам","?"]
["Котельная",2,300,"1 кам",16]
["Мойка",2,300,"1 кам",16]
["Навес","?",200,"1 кам","?"]
["Общественное",1,400,"2 кам",20]
["Огр. конструкции","?",300,"?","?"]
["Производственное",2,300,"1 кам",16]
["Птичник",2,200,"1 кам",16]
["Склад",3,300,"1 кам",12]
["Спортивное",1,400,"2 кам",20]
["СТО",2,300,"1 кам",16]
["Стоянка",3,300,"1 кам",12]
["Торговое",1,400,"2 кам",20]
["Холодильник","?",300,"1 кам","?"]
[]
["Здания и помещения","ГСОП","Приведенное сопротивление теплопередаче"]
[null,null,"ограждающих конструкций не менее "]
[null,"°С*сут","Rтро, м2*град/Вт"]
[]
[null,null,"стен","кровля","окна"]
["Общественные, ",0,1.2,1.6,0.2]
["АБК",2000,1.8,2.4,0.3]
[null,4000,2.4,3.2,0.4]
[null,6000,3,4,0.5]
[null,8000,3.6,4.8,0.6]
[null,10000,4.2,5.6,0.7]
[null,12000,4.8,6.4,0.8]
[]
["Производственные,",0,1,1.5,0.2]
["склады",2000,1.4,2,0.25]
[null,4000,1.8,2.5,0.3]
[null,6000,2.2000000000000002,3,0.35]
[null,8000,2.6,3.5,0.4]
[null,10000,3,4,0.45]
[null,12000,3.4,4.5,0.5]

{"sheet":"Данные","index":2,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,7,1,9],[1,16,1,22],[7,16,7,24]]}
[null,null,"толщина","ВК","ВКС","ширина"]
["ВКС50",{"$f":"IF(A2=\"ВК50\",D2,E2)+(26+56)","v":1492},50,1510,1410,1]
["ВКС80",{"$f":"IF(A3=\"ВК80\",D3,E3)+(28+72)","v":1620},80,1650,1520,1]
["ВКС100",{"$f":"IF(A4=\"ВК100\",D4,E4)+(29+83)","v":1752},100,1790,1640,1,"кровля",{"$f":"I4-J4","v":87},149,62]
["ВКС120",{"$f":"IF(A5=\"ВК120\",D5,E5)+(30+125)","v":1875},120,1880,1720,1,"стена",{"$f":"I5-J5","v":92.240845702586725},158,{"$f":"J4/A54*B54","v":65.759154297413275}]
["ВКС150",{"$f":"IF(A6=\"ВК150\",D6,E6)+(32+143)","v":2015},150,2030,1840,1]
["ВКС180",{"$f":"IF(A7=\"ВК180\",D7,E7)+(34+169)","v":2183},180,2200,1980,1]
["ВКС200",{"$f":"IF(A8=\"ВК200\",D8,E8)+(35+169)","v":2274},200,2310,2070,1]
["ВКС230",{"$f":"IF(A9=\"ВК230\",D9,E9)+(41+169)","v":2390},230,2440,2180,1]
["ВКС250",{"$f":"IF(A10=\"ВК250\",D10,E10)+(41+169)","v":2470},250,2540,2260,1,null,null,null,null,null,null,"Гориз. раскладка "]
["ВН45",{"$f":"ВН45+(13+42)","v":475},50,null,null,0.9,null,null,null,null,null,null,2.5]
["ВН45- МВУ100 -ВС18",{"$f":"B14-J4","v":1262},100,null,null,0.9,null,null,null,null,null,null,"Т153-850-0,8"]
["ВН45- МВУ100-Al",{"$f":"B15-J4","v":705},100,null,null,0.9,null,null,null,null,null,null,"Т153-850-0,8"]
["ВН45- МВУ150 -ВС18",1324,150,null,null,0.9,null,null,null,null,null,null,"Т153-850-1,0"]
["ВН45- МВУ150-Al",767,150,null,null,0.9,null,null,null,null,null,null,"Т153-850-1,2"]
["ВН45- МВУ200 -ВС18",{"$f":"B14+J4","v":1386},200,null,null,0.9]
["ВН45- МВУ200-Al",{"$f":"B15+J4","v":829},200,null,null,0.9]
["ВН45- МВУ250 -ВС18",{"$f":"B14+J4*2","v":1448},250,null,null,0.9]
["ВН45- МВУ250-Al",{"$f":"B15+J4*2","v":891},250,null,null,0.9]
["ВН45- МВУ50 -ВС18",{"$f":"B14-I4-J4+H4","v":1200},50,null,null,0.9]
["ВН45- МВУ50-Al",{"$f":"B15-I4-J4+H4*A54","v":649.59151682803133},50,"протан","техно-ль",0.9]
["Мембранная утепл. 100мм (Протан/Rockwool)",{"$f":"IF(A22=\"Мембранная утепл. 100мм (Протан/Rockwool)\",D22,E22)","v":1875},100,1875,1830,0.84499999999999997]
["Мембранная утепл. 120мм (Протан/Rockwool)",{"$f":"IF(A23=\"Мембранная утепл. 120мм (Протан/Rockwool)\",D23,E23)","v":1973},120,1973,1917,0.84499999999999997]
["Мембранная утепл. 150мм (Протан/Rockwool)",{"$f":"IF(A24=\"Мембранная утепл. 150мм (Протан/Rockwool)\",D24,E24)","v":2105},150,2105,2030,0.84499999999999997]
["Мембранная утепл. 180мм (Протан/Rockwool)",{"$f":"IF(A25=\"Мембранная утепл. 180мм (Протан/Rockwool)\",D25,E25)","v":2248},180,2248,2156,0.84499999999999997]
["Мембранная утепл. 200мм (Протан/Rockwool)",{"$f":"IF(A26=\"Мембранная утепл. 200мм (Протан/Rockwool)\",D26,E26)","v":2333},200,2333,2229,0.84499999999999997]
["Мембранная утепл. 220мм (Протан/Rockwool)",{"$f":"IF(A27=\"Мембранная утепл. 220мм (Протан/Rockwool)\",D27,E27)","v":2509},220,2509,2393,0.84499999999999997]
["Мембранная утепл. 250мм (Протан/Rockwool)",{"$f":"IF(A28=\"Мембранная утепл. 250мм (Протан/Rockwool)\",D28,E28)","v":2653},250,2653,2520,0.84499999999999997]
["Мембранная утепл. 40мм (Протан/Rockwool)",{"$f":"IF(A29=\"Мембранная утепл. 40мм (Протан/Rockwool)\",D29,E29)","v":1619.7511895837683},50,1619.7511895837683,1646.9202563678527,0.84499999999999997]
["НЕТ (не поставляется)",0,50,null,null,1,"ВН45","ВС18"]
["светопрозрачная кровля ",2700,50,null,null,0.9,420,343]
["ВС50",{"$f":"1220+(110+17)","v":1347},50,50,null,1.19]
["ВС80",{"$f":"1350+(112+20)","v":1482},80,80,null,{"$f":"IF(A33=\"ВС80\",1.19,1.1)","v":1.19}]
["ВС100",{"$f":"1440+(113+29)","v":1582},100,100,null,{"$f":"IF(A34=\"ВС100\",1.19,1.1)","v":1.19},"Сейсмичности - НЕТ",null,null,1]
["ВС120",{"$f":"1520+(114+38)","v":1672},120,120,null,{"$f":"IF(A35=\"ВС120\",1.19,1.1)","v":1.19},"Сейсмичность 7 баллов.",null,null,1.03]
["ВС150",{"$f":"1660+(115+38)","v":1813},150,150,null,{"$f":"IF(A36=\"ВС150\",1.19,1.1)","v":1.19},"Сейсмичность 8 баллов.",null,null,1.05]
["ВС180",{"$f":"1790+(117+52)","v":1959},180,180,null,1.19,"Сейсмичность 9 баллов.",null,null,1.1000000000000001]
["ВС200",{"$f":"1870+(118+52)","v":2040},200,200,null,1.19,"Сейсмичность10 баллов.",null,null,{"$f":"1.15","v":1.1499999999999999}]
["ВС230",{"$f":"1980+(121+77)","v":2178},230,230,null,1.19]
["ВС250",{"$f":"2090+(121+77)","v":2288},250,250,null,1.19]
["ВС18",{"$f":"ВС18+(65+36)","v":444},50,20,null,1.1000000000000001]
["ВС18 - МВУ100 -ВС18",{"$f":"B47+ВС18+50","v":1015},100,140,null,1.1000000000000001]
["ВС18 - МВУ150 -ВС18",{"$f":"B48+ВС18+50","v":1080.7591542974133},150,190,null,1.1000000000000001]
["ВС18 - МВУ200 -ВС18",{"$f":"B49+ВС18+50","v":1146.5183085948265},200,240,null,1.1000000000000001]
["ВС18 - МВУ250 -ВС18",{"$f":"B50+ВС18+50","v":1212.2774628922398},250,290,null,1.1000000000000001]
["ВС18 - МВУ50 -ВС18",{"$f":"B51+ВС18+50","v":949.24084570258674},50,90,null,1.1000000000000001]
["ВС18- МВУ100-Al",622,100,120,null,1.1000000000000001]
["ВС18- МВУ150-Al",{"$f":"B47+J5","v":687.75915429741326},150,170,null,1.1000000000000001]
["ВС18- МВУ200-Al",{"$f":"B47+J5*2","v":753.51830859482652},200,220,null,1.1000000000000001]
["ВС18- МВУ250-Al",{"$f":"B47+J5*3","v":819.27746289223978},250,270,null,1.1000000000000001]
["ВС18- МВУ50-Al",{"$f":"B47-I5+H5","v":556.24084570258674},50,70,null,1.1000000000000001]
["Гипсокартон","?",50,0,null,1.19]
["НЕТ (не поставляются)",0,50,0,null,1.19]
[1.0757645612417397,1.1409898027481395]