{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["result","calc_step_1","calc_step_2","fold_calc","material_list"],"not_rendered":{"images":13,"macros":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"result","index":0,"n_rows":44,"n_cols":3,"rows_kept":44,"merged":[[43,1,43,21]]}
[]
[]
[]
[]
[null,"Вхідні дані специфікації"]
[null,"Параметри корпусу секції"]
[null,"Висота корпусу (KH, mm)","KH"]
[null,"Товщина верхньої панелі (K1, мм)"]
[null,"Верхній зазор (G1, мм)"]
[null,"Накладання фасаду (A1, мм)"]
[null,"Товщина нижньої панелі (K2, мм)"]
[null,"Нижній зазор (G2, мм)"]
[null,"Накладання фасаду (A2, мм)","A2"]
[]
[null,"Параметри фасаду"]
[null,"Висота фасаду (FH, мм)"]
[null,"Ширина фасаду (FW, мм)"]
[null,"Товщина фасаду (T, мм)"]
[null,"Щільність матеріалу фасаду"]
[null,"Вага ручки (грам)"]
[null,"Вага фасаду"]
[]
[null,"Рекомендована модель",{"$f":"IFERROR(INDEX(result[Модель],MATCH(\"Рекомендована модель\",result[Коментар],0)),\"\")","v":""}]
[null,"Комплект, сірі заглушки",{"$f":"IFERROR(INDEX(calc_data[сірі заглушки],MATCH($C$23,calc_data[model],0)),\"\")","v":""}]
[null,"Комплект, білі заглушки",{"$f":"IFERROR(INDEX(calc_data[білі заглушки],MATCH($C$23,calc_data[model],0)),\"\")","v":""}]
[null,"Комплект, заклушки \"Антрацит\"",{"$f":"IFERROR(INDEX(calc_data[антрацит],MATCH($C$23,calc_data[model],0)),\"\")","v":""}]
[]
[null,"Параметри планування"]
[null,"Значення Y (мм)",{"$f":"IFERROR(INDEX(result[Y (мм)],MATCH(\"Рекомендована модель\",result[Коментар],0)),\"Y\")","v":"Y"}]
[null,"Значення X (мм)",{"$f":"IFERROR(INDEX(result[X (мм)],MATCH(\"Рекомендована модель\",result[Коментар],0)),\"X\")","v":"X"}]
[null,"Q (мм)",{"$f":"IFERROR(calc_step_2!C23,\"Q\")","v":"Q"}]
[null,"R (мм)",{"$f":"IFERROR(calc_step_2!D23,\"R\")","v":"R"}]
[null,"S (мм)",{"$f":"IFERROR(calc_step_2!E23,\"S\")","v":"S"}]
[null,"β (≈)",{"$f":"IFERROR(calc_step_2!B23,\"β\")","v":"β"}]
[null,"T (мм)",{"$f":"IFERROR(calc_step_2!F23,\"T\")","v":"T"}]
[null,"U (мм)",{"$f":"IFERROR(calc_step_2!G23,\"U\")","v":"U"}]
[null,"V (мм)",{"$f":"IFERROR(calc_step_2!H23,\"V\")","v":"V"}]
[null,"W (мм)",{"$f":"IFERROR(calc_step_2!I23,\"W\")","v":"W"}]
[]
[]
[]
[]
[]
[null,"Це тестова версія програми. Розробник залишає за собою право вносити зміни в специфікації без додаткового попередження"]

{"sheet":"calc_step_1","index":1,"n_rows":21,"n_cols":8,"rows_kept":21,"hidden":true}
["ID","KH (мм)","FW (кг)","Модель","Y (мм)","X (мм)","Q","Коментар"]
[1,{"$f":"IFERROR(INDEX(fold_calc!$S$11:$S$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A2),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$T$11:$T$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A2),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$O$11:$O$44,MATCH(B2&C2,fold_calc!$C$11:$C$44&fold_calc!$F$11:$F$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$U$11:$U$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A2),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$V$11:$V$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A2),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$W$11:$W$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A2),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IF(G2=MAX($G$2:$G$9),\"Рекомендована модель\",\"\")","v":""}]
[2,{"$f":"IFERROR(INDEX(fold_calc!$S$11:$S$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A3),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$T$11:$T$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A3),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$O$11:$O$44,MATCH(B3&C3,fold_calc!$C$11:$C$44&fold_calc!$F$11:$F$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$U$11:$U$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A3),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$V$11:$V$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A3),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$W$11:$W$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A3),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IF(G3=MAX($G$2:$G$9),\"Рекомендована модель\",\"\")","v":""}]
[3,{"$f":"IFERROR(INDEX(fold_calc!$S$11:$S$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A4),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$T$11:$T$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A4),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$O$11:$O$44,MATCH(B4&C4,fold_calc!$C$11:$C$44&fold_calc!$F$11:$F$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$U$11:$U$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A4),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$V$11:$V$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A4),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$W$11:$W$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A4),fold_calc!$R$11:$R$44,0)),\"\")","v":""},""]
[4,{"$f":"IFERROR(INDEX(fold_calc!$S$11:$S$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A5),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$T$11:$T$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A5),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$O$11:$O$44,MATCH(B5&C5,fold_calc!$C$11:$C$44&fold_calc!$F$11:$F$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$U$11:$U$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A5),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$V$11:$V$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A5),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$W$11:$W$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A5),fold_calc!$R$11:$R$44,0)),\"\")","v":""},""]
[5,{"$f":"IFERROR(INDEX(fold_calc!$S$11:$S$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A6),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$T$11:$T$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A6),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$O$11:$O$44,MATCH(B6&C6,fold_calc!$C$11:$C$44&fold_calc!$F$11:$F$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$U$11:$U$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A6),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$V$11:$V$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A6),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$W$11:$W$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A6),fold_calc!$R$11:$R$44,0)),\"\")","v":""},""]
[6,{"$f":"IFERROR(INDEX(fold_calc!$S$11:$S$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A7),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$T$11:$T$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A7),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$O$11:$O$44,MATCH(B7&C7,fold_calc!$C$11:$C$44&fold_calc!$F$11:$F$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$U$11:$U$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A7),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$V$11:$V$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A7),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$W$11:$W$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A7),fold_calc!$R$11:$R$44,0)),\"\")","v":""},""]
[7,{"$f":"IFERROR(INDEX(fold_calc!$S$11:$S$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A8),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$T$11:$T$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A8),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$O$11:$O$44,MATCH(B8&C8,fold_calc!$C$11:$C$44&fold_calc!$F$11:$F$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$U$11:$U$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A8),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$V$11:$V$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A8),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$W$11:$W$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A8),fold_calc!$R$11:$R$44,0)),\"\")","v":""},""]
[8,{"$f":"IFERROR(INDEX(fold_calc!$S$11:$S$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A9),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$T$11:$T$44,MATCH(SMALL(fold_calc!$R$11:$R$44,$A9),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$O$11:$O$44,MATCH(B9&C9,fold_calc!$C$11:$C$44&fold_calc!$F$11:$F$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$U$11:$U$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A9),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$V$11:$V$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A9),fold_calc!$R$11:$R$44,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(fold_calc!$W$11:$W$44,MATCH(SMALL(fold_calc!$R$11:$R$44,A9),fold_calc!$R$11:$R$44,0)),\"\")","v":""},""]
{"$rows_empty":9}
[{"$f":"IFERROR(INDEX($J$2:$J$13,MATCH(SMALL(K2:K13,#REF!),K2:K13,0)),\"\")","v":""}]
[]
[{"$f":"IFERROR(INDEX($J$2:$J$13,MATCH(SMALL(K2:K13,#REF!),K2:K13,0)),\"\")","v":""}]

{"sheet":"calc_step_2","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"hidden":true}
["висота корпусу","β","Q","R","S","T","U","V","W","LEN"]
["450–480","107–98",{"v":1,"d":"1.0"},349,313,"94–49","93–128","196–180","315–343",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":7}]
["480–530","107–96",1.1,426,328,"100–37","100–155","203–186","328–370",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":7}]
["520–590","107–93",1.1,466,347,"106–23","112–184","213–190","347–401",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":7}]
["580–650","108–95",1.2,589,377,"119–40","126–197","227–207","375–430",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":7}]
["650–730","107–94",1.2,664,409,"124–38","147–224","238–215","411–470",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":7}]
["710–790","108–95",1.2,736,439,"136–46","161–233","250–219","439–500",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":7}]
["770–840","108–95",{"v":1,"d":"1.0"},644,467,"146–43","179–223","267–200","466–527",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":7}]
["840–910","108–98",1.2,882,501,"154–70","195–248","272–231","502–559",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":7}]
["910–970","107–98",1.1,865,533,"160–78","214–246","282–225","536–588",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":7}]
["960–1010","107–100",1.1,915,557,"170–99","228–251","295–240","560–605",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":8}]
["1000–1040","107–102",1.1,954,576,"177–120","239–256","306–256","578–616",{"$f":"LEN(free_fold_data[[#This Row],[висота корпусу]])","v":9}]
[]
["LEN",{"$f":"INDEX(free_fold_data[LEN],MATCH(A17,free_fold_data[висота корпусу],0))","v":{"$error":"#N/A"}}]
[1,2,3,4,5,6,7,8,9]
["висота корпусу","β","Q","R","S","T","U","V","W"]
[{"$f":"INDEX(calc_step_1!$B$1:$B$9,MATCH(\"Рекомендована модель\",calc_step_1!$H$1:$H$9,0))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A17,free_fold_data[],B15,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A17,free_fold_data[],C15,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A17,free_fold_data[],D15,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A17,free_fold_data[],E15,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A17,free_fold_data[],F15,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A17,free_fold_data[],G15,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A17,free_fold_data[],H15,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A17,free_fold_data[],I15,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"IF($B$14=9,LEFT(A17,4),IF(OR($B$14=8,$B$14=7),LEFT(A17,3),))","v":{"$error":"#N/A"}},{"$f":"LEFT(B17,3)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"LEFT(F17,3)","v":{"$error":"#N/A"}},{"$f":"LEFT(G17,3)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"IF($B$14=9,RIGHT(A17,4),IF($B$14=8,RIGHT(A17,4),IF($B$14=7,RIGHT(A17,3))))","v":{"$error":"#N/A"}},{"$f":"RIGHT(B17,LEN(B17)-4)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"RIGHT(F17,LEN(F17)-4)","v":{"$error":"#N/A"}},{"$f":"RIGHT(G17,LEN(G17)-4)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A19-A18","v":{"$error":"#N/A"}},{"$f":"B18-B19","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"F18-F19","v":{"$error":"#N/A"}},{"$f":"G18-G19","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
["Q",{"$f":"B20/$A$20","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"F20/$A$20","v":{"$error":"#N/A"}},{"$f":"G20/$A$20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A23-A18","v":{"$error":"#VALUE!"}},{"$f":"B21*$A$22","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"F21*$A$22","v":{"$error":"#N/A"}},{"$f":"G21*$A$22","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"result!C7","v":"KH"},{"$f":"ROUND(B18-B22,)&\"°\"","v":{"$error":"#N/A"}},{"$f":"C17","v":{"$error":"#N/A"}},{"$f":"D17","v":{"$error":"#N/A"}},{"$f":"E17","v":{"$error":"#N/A"}},{"$f":"ROUND(F18-F22,)","v":{"$error":"#N/A"}},{"$f":"ROUND(G18-G22,)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"~"]

{"sheet":"fold_calc","index":3,"n_rows":44,"n_cols":25,"rows_kept":44,"hidden":true}
[]
[null,null,"K top",{"$f":"result!C8","v":{"v":0,"d":"0мм"}}]
[null,null,"K bottom",{"$f":"result!C11","v":{"v":0,"d":"0мм"}}]
[null,null,"KH",{"$f":"result!C7","v":"KH"}]
[null,null,"FW",{"$f":"result!C21","v":{"v":0,"d":"0.00кг"}}]
[null,null,"A1",{"$f":"result!C13","v":"A2"}]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,15,true,4]
[]
[null,"KG","KH","KH min","KH max","FW","FW min","FW max","Q","R","S","сірі заглушки","білі заглушки","антрацит","model","ціна","індекс","SMALL(fx)","KH2","FW2","Y","X","Q2","Qmin","Qmax"]
[null,{"$f":"AND($D$4>=$D11,$D$4<=$E11,$D$5<=$H11,$D$5>=$G11)","v":false},"480–530",480,530,"2,6–5,2",2.6,5.2,{"$f":"VLOOKUP(C11,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C11,calc_step_2!$A:$D,4,FALSE)","v":426},{"$f":"VLOOKUP(C11,calc_step_2!$A:$E,5,FALSE)","v":328},"372.37.510","372.37.710","372.37.300","C1fo",null,1,{"$f":"IF($S11=\"\",\"\",VLOOKUP($S11,$C11:$Q11,R$8,FALSE))","v":""},{"$f":"IF(B11=$S$8,VLOOKUP($S$8,B11:P11,2,FALSE),\"\")","v":""},{"$f":"IF($S11=\"\",\"\",VLOOKUP($S11,$C11:$P11,T$8,FALSE))","v":""},{"$f":"IF($S11=\"\",\"\",(I11*$D$4)-J11-$D$2)","v":""},{"$f":"IF($S11=\"\",\"\",$D$4-U11-K11-($D$2+$D$3)+$D$6)","v":""},{"$f":"IF(R11=\"\",\"\",((1-G11/$D$5)+(1-$D$5/H11))/2)","v":""},{"$f":"IF(R11=\"\",\"\",(1-G11/$D$5))","v":""},{"$f":"IF(R11=\"\",\"\",(1-$D$5/H11))","v":""}]
[null,{"$f":"AND($D$4>=$D12,$D$4<=$E12,$D$5<=$H12,$D$5>=$G12)","v":false},"480–530",480,530,"5,2–10,6",5.2,10.6,{"$f":"VLOOKUP(C12,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C12,calc_step_2!$A:$D,4,FALSE)","v":426},{"$f":"VLOOKUP(C12,calc_step_2!$A:$E,5,FALSE)","v":328},"372.37.512","372.37.712","372.37.301","C3fo",null,2,"","","","","","","",""]
[null,false,"480–530",480,530,"7,8–15,1",7.8,15.1,{"$f":"VLOOKUP(C13,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C13,calc_step_2!$A:$D,4,FALSE)","v":426},{"$f":"VLOOKUP(C13,calc_step_2!$A:$E,5,FALSE)","v":328},"372.37.513","372.37.713","372.37.302","C4fo",null,3,"","","","","","","",""]
[null,false,"520–590",520,590,"2,4–4,9",2.4,4.9,{"$f":"VLOOKUP(C14,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C14,calc_step_2!$A:$D,4,FALSE)","v":466},{"$f":"VLOOKUP(C14,calc_step_2!$A:$E,5,FALSE)","v":347},"372.37.520","372.37.720","372.37.303","D1fo",null,4,"","","","","","","",""]
[null,false,"520–590",520,590,"4,8–9,8",4.8,9.8,{"$f":"VLOOKUP(C15,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C15,calc_step_2!$A:$D,4,FALSE)","v":466},{"$f":"VLOOKUP(C15,calc_step_2!$A:$E,5,FALSE)","v":347},"372.37.522","372.37.722","372.37.304","D3fo",null,5,"","","","","","","",""]
[null,false,"520–590",520,590,"7,2–14,1",7.2,14.1,{"$f":"VLOOKUP(C16,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C16,calc_step_2!$A:$D,4,FALSE)","v":466},{"$f":"VLOOKUP(C16,calc_step_2!$A:$E,5,FALSE)","v":347},"372.37.523","372.37.723","372.37.305","D4fo",null,6,"","","","","","","",""]
[null,{"$f":"AND($D$4>=$D17,$D$4<=$E17,$D$5<=$H17,$D$5>=$G17)","v":false},"520–590",520,590,"11,8–23,30",11.8,23.3,{"$f":"VLOOKUP(C17,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C17,calc_step_2!$A:$D,4,FALSE)","v":466},{"$f":"VLOOKUP(C17,calc_step_2!$A:$E,5,FALSE)","v":347},"372.37.524","372.37.724","372.37.328","D5fo",null,7,"","","","","","","",""]
[null,false,"580–650",580,650,"2,2–4,4",2.2,4.4,{"$f":"VLOOKUP(C18,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C18,calc_step_2!$A:$D,4,FALSE)","v":589},{"$f":"VLOOKUP(C18,calc_step_2!$A:$E,5,FALSE)","v":377},"372.37.530","372.37.730","372.37.306","E1fo",null,8,"","","","","","","",""]
[null,false,"580–650",580,650,"4,3–8,8",4.3,8.8,{"$f":"VLOOKUP(C19,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C19,calc_step_2!$A:$D,4,FALSE)","v":589},{"$f":"VLOOKUP(C19,calc_step_2!$A:$E,5,FALSE)","v":377},"372.37.532","372.37.732","372.37.307","E3fo",null,9,"","","","","","","",""]
[null,false,"580–650",580,650,"6,0–12,2",{"v":6,"d":"6.0"},12.2,{"$f":"VLOOKUP(C20,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C20,calc_step_2!$A:$D,4,FALSE)","v":589},{"$f":"VLOOKUP(C20,calc_step_2!$A:$E,5,FALSE)","v":377},"372.37.533","372.37.733","372.37.308","E4fo",null,10,"","","","","","","",""]
[null,false,"580–650",580,650,"10,6–20,9",10.6,20.9,{"$f":"VLOOKUP(C21,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C21,calc_step_2!$A:$D,4,FALSE)","v":589},{"$f":"VLOOKUP(C21,calc_step_2!$A:$E,5,FALSE)","v":377},"372.37.534","372.37.734","372.37.309","E5fo",null,11,"","","","","","","",""]
[null,false,"650–730",650,730,"3,9–4,0",1.9,{"v":4,"d":"4.0"},{"$f":"VLOOKUP(C22,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C22,calc_step_2!$A:$D,4,FALSE)","v":664},{"$f":"VLOOKUP(C22,calc_step_2!$A:$E,5,FALSE)","v":409},"372.37.540","372.37.740","372.37.329","F1fo",null,12,"","","","","","","",""]
[null,false,"650–730",650,730,"3,9–7,9",3.9,7.9,{"$f":"VLOOKUP(C23,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C23,calc_step_2!$A:$D,4,FALSE)","v":664},{"$f":"VLOOKUP(C23,calc_step_2!$A:$E,5,FALSE)","v":409},"372.37.542","372.37.742","372.37.310","F3fo",null,13,"","","","","","","",""]
[null,false,"650–730",650,730,"5,8–11,6",5.8,11.6,{"$f":"VLOOKUP(C24,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C24,calc_step_2!$A:$D,4,FALSE)","v":664},{"$f":"VLOOKUP(C24,calc_step_2!$A:$E,5,FALSE)","v":409},"372.37.543","372.37.743","372.37.311","F4fo",null,14,"","","","","","","",""]
[null,false,"650–730",650,730,"9,5–18,7",9.5,18.7,{"$f":"VLOOKUP(C25,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C25,calc_step_2!$A:$D,4,FALSE)","v":664},{"$f":"VLOOKUP(C25,calc_step_2!$A:$E,5,FALSE)","v":409},"372.37.544","372.37.744","372.37.312","F5fo",null,15,"","","","","","","",""]
[null,false,"710–790",710,790,"3,5–7,2",3.5,7.2,{"$f":"VLOOKUP(C26,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C26,calc_step_2!$A:$D,4,FALSE)","v":736},{"$f":"VLOOKUP(C26,calc_step_2!$A:$E,5,FALSE)","v":439},"372.37.552","372.37.752","372.37.313","G3fo",null,16,"","","","","","","",""]
[null,false,"710–790",710,790,"5,2–10,3",5.2,10.3,{"$f":"VLOOKUP(C27,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C27,calc_step_2!$A:$D,4,FALSE)","v":736},{"$f":"VLOOKUP(C27,calc_step_2!$A:$E,5,FALSE)","v":439},"372.37.553","372.37.753","372.37.314","G4fo",null,17,"","","","","","","",""]
[null,false,"710–790",710,790,"8,7–17,2",8.7,17.2,{"$f":"VLOOKUP(C28,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C28,calc_step_2!$A:$D,4,FALSE)","v":736},{"$f":"VLOOKUP(C28,calc_step_2!$A:$E,5,FALSE)","v":439},"372.37.554","372.37.754","372.37.315","G5fo",null,18,"","","","","","","",""]
[null,false,"770–840",770,840,"3,2–6,7",3.2,6.7,{"$f":"VLOOKUP(C29,calc_step_2!$A:$D,3,FALSE)","v":1},{"$f":"VLOOKUP(C29,calc_step_2!$A:$D,4,FALSE)","v":644},{"$f":"VLOOKUP(C29,calc_step_2!$A:$E,5,FALSE)","v":467},"372.37.562","372.37.762","372.37.330","H3fo",null,19,"","","","","","","",""]
[null,false,"770–840",770,840,"4,9–9,8",4.9,9.8,{"$f":"VLOOKUP(C30,calc_step_2!$A:$D,3,FALSE)","v":1},{"$f":"VLOOKUP(C30,calc_step_2!$A:$D,4,FALSE)","v":644},{"$f":"VLOOKUP(C30,calc_step_2!$A:$E,5,FALSE)","v":467},"372.37.563","372.37.763","372.37.316","H4fo",null,20,"","","","","","","",""]
[null,false,"770–840",770,840,"8,0–15,5",{"v":8,"d":"8.0"},15.5,{"$f":"VLOOKUP(C31,calc_step_2!$A:$D,3,FALSE)","v":1},{"$f":"VLOOKUP(C31,calc_step_2!$A:$D,4,FALSE)","v":644},{"$f":"VLOOKUP(C31,calc_step_2!$A:$E,5,FALSE)","v":467},"372.37.564","372.37.764","372.37.317","H5fo",null,21,"","","","","","","",""]
[null,{"$f":"AND($D$4>=$D32,$D$4<=$E32,$D$5<=$H32,$D$5>=$G32)","v":false},"770–840",770,840,"12,5–20,9",12.5,20.9,{"$f":"VLOOKUP(C32,calc_step_2!$A:$D,3,FALSE)","v":1},{"$f":"VLOOKUP(C32,calc_step_2!$A:$D,4,FALSE)","v":644},{"$f":"VLOOKUP(C32,calc_step_2!$A:$E,5,FALSE)","v":467},"372.37.565","372.37.764","372.37.332","H6fo",null,22,"","","","","","","",""]
[null,false,"840–910",840,910,"4,5–9,0",4.5,{"v":9,"d":"9.0"},{"$f":"VLOOKUP(C33,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C33,calc_step_2!$A:$D,4,FALSE)","v":882},{"$f":"VLOOKUP(C33,calc_step_2!$A:$E,5,FALSE)","v":501},"372.37.573","372.37.773","372.37.318","I4fo",null,23,"","","","","","","",""]
[null,{"$f":"AND($D$4>=$D34,$D$4<=$E34,$D$5<=$H34,$D$5>=$G34)","v":false},"840–910",840,910,"7,3–14,6",7.3,14.6,{"$f":"VLOOKUP(C34,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C34,calc_step_2!$A:$D,4,FALSE)","v":882},{"$f":"VLOOKUP(C34,calc_step_2!$A:$E,5,FALSE)","v":501},"372.37.574","372.37.774","372.37.319","I5fo",null,24,"","","","","","","",""]
[null,{"$f":"AND($D$4>=$D35,$D$4<=$E35,$D$5<=$H35,$D$5>=$G35)","v":false},"840–910",840,910,"10,0–20,0",{"v":10,"d":"10.0"},{"v":20,"d":"20.0"},{"$f":"VLOOKUP(C35,calc_step_2!$A:$D,3,FALSE)","v":1.2},{"$f":"VLOOKUP(C35,calc_step_2!$A:$D,4,FALSE)","v":882},{"$f":"VLOOKUP(C35,calc_step_2!$A:$E,5,FALSE)","v":501},"372.37.575","372.37.775","372.37.333","I6fo",null,25,"","","","","","","",""]
[null,false,"910–970",910,970,"4,2–8,0",4.2,{"v":8,"d":"8.0"},{"$f":"VLOOKUP(C36,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C36,calc_step_2!$A:$D,4,FALSE)","v":865},{"$f":"VLOOKUP(C36,calc_step_2!$A:$E,5,FALSE)","v":533},"372.37.583","372.37.783","372.37.320","J4fo",null,26,"","","","","","","",""]
[null,false,"910–970",910,970,"6,8–13,5",6.8,13.5,{"$f":"VLOOKUP(C37,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C37,calc_step_2!$A:$D,4,FALSE)","v":865},{"$f":"VLOOKUP(C37,calc_step_2!$A:$E,5,FALSE)","v":533},"372.37.584","372.37.784","372.37.321","J5fo",null,27,"","","","","","","",""]
[null,false,"910–970",910,970,"9,50–17,9",9.5,17.9,{"$f":"VLOOKUP(C38,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C38,calc_step_2!$A:$D,4,FALSE)","v":865},{"$f":"VLOOKUP(C38,calc_step_2!$A:$E,5,FALSE)","v":533},"372.37.585","372.37.785","372.37.334","J6fo",null,28,"","","","","","","",""]
[null,false,"960–1010",960,1010,"3,9–7,6",3.9,7.6,{"$f":"VLOOKUP(C39,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C39,calc_step_2!$A:$D,4,FALSE)","v":915},{"$f":"VLOOKUP(C39,calc_step_2!$A:$E,5,FALSE)","v":557},"372.37.593","372.37.793","372.37.322","K4fo",null,29,"","","","","","","",""]
[null,false,"960–1010",960,1010,"6,5–12,8",6.5,12.8,{"$f":"VLOOKUP(C40,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C40,calc_step_2!$A:$D,4,FALSE)","v":915},{"$f":"VLOOKUP(C40,calc_step_2!$A:$E,5,FALSE)","v":557},"372.37.594","372.37.794","372.37.323","K5fo",null,30,"","","","","","","",""]
[null,false,"960–1010",960,1010,"8,6–17,30",8.6,17.3,{"$f":"VLOOKUP(C41,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C41,calc_step_2!$A:$D,4,FALSE)","v":915},{"$f":"VLOOKUP(C41,calc_step_2!$A:$E,5,FALSE)","v":557},"372.37.591","372.37.791","372.37.335","K6fo",null,31,"","","","","","","",""]
[null,{"$f":"AND($D$4>=$D42,$D$4<=$E42,$D$5<=$H42,$D$5>=$G42)","v":false},"1000–1040",1000,1040,"3,7–7,3",3.7,7.3,{"$f":"VLOOKUP(C42,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C42,calc_step_2!$A:$D,4,FALSE)","v":954},{"$f":"VLOOKUP(C42,calc_step_2!$A:$E,5,FALSE)","v":576},"372.37.598","372.37.798","372.37.331","L4fo",null,32,"","","","","","","",""]
[null,false,"1000–1040",1000,1040,"6,2–12,3",6.2,12.3,{"$f":"VLOOKUP(C43,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C43,calc_step_2!$A:$D,4,FALSE)","v":954},{"$f":"VLOOKUP(C43,calc_step_2!$A:$E,5,FALSE)","v":576},"372.37.599","372.37.799","372.37.324","L5fo",null,33,"","","","","","","",""]
[null,false,"1000–1040",1000,1040,"8,1–16,0",8.1,{"v":16,"d":"16.0"},{"$f":"VLOOKUP(C44,calc_step_2!$A:$D,3,FALSE)","v":1.1},{"$f":"VLOOKUP(C44,calc_step_2!$A:$D,4,FALSE)","v":954},{"$f":"VLOOKUP(C44,calc_step_2!$A:$E,5,FALSE)","v":576},"372.37.596","372.37.796","372.37.336","L6fo",null,34,"","","","","","","",""]

{"sheet":"material_list","index":4,"n_rows":6,"n_cols":6,"rows_kept":6,"hidden":true}
["Тип матеріалу фасаду","Kg, m3","KGmin","KGmax","Опис","1"]
["ДСП","620–750",620,750,{"$f":"CONCATENATE(A2,\", \",B2,\" кг/м3\")","v":"ДСП, 620–750 кг/м3"},650]
["МДФ","600–900",600,900,{"$f":"CONCATENATE(A3,\", \",B3,\" кг/м3\")","v":"МДФ, 600–900 кг/м3"},770]
["Скло",2500,2500,2500,{"$f":"CONCATENATE(A4,\", \",B4,\" кг/м3\")","v":"Скло, 2500 кг/м3"},2500]
["Фанера (береза)",{"$nulls":3},{"$f":"CONCATENATE(A5,\", \",B5,\" кг/м3\")","v":"Фанера (береза),  кг/м3"},750]
["Фанера (хвоя)","500–800",500,800,{"$f":"CONCATENATE(A6,\", \",B6,\" кг/м3\")","v":"Фанера (хвоя), 500–800 кг/м3"},650]