{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Лист2","полотно","Алюм коробки Фрист","Деревянные коробки","Лист4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист2","index":0,"n_rows":5,"n_cols":26,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,4,1,6]]}
[]
[]
[]
[null,"полотно",null,null,"высота мм",null,"ширина мм","толщина проема мм","площадь м2",null,"матирование",null,"Тип коробки","Цвет",null,null,null,"Фурнитура"]
[null,1,null,null,2800,1,900,90,{"$f":"E5*G5/1000000","v":2.52},null,5,null,1,1,{"$f":"INDEX(Лист4!$I$2:$L$7,M5,N5)*(1+(E5*2+G5>5800)*ISNUMBER(FIND(\"V\",INDEX(Лист4!$H$2:$H$7,M5)))*0.5+(G5>1100)*ISNUMBER(FIND(\"Фитинг\",INDEX(Лист4!$H$2:$H$7,M5))))+I5*CHOOSE(B5,Лист4!B30,Лист4!B31)+I5*CHOOSE(K5,Лист4!B56,Лист4!B57,Лист4!B58,Лист4!B59,Лист4!B60)","v":8022},null,null,2,null,{"$f":"CHOOSE(R5,Лист4!J36,Лист4!J37,Лист4!J38)*IF(AND(ISNUMBER(FIND(\"Titan\",INDEX(Лист4!$I$36:$I$38,R5))),G5>1100),2,1)","v":3890},null,null,null,null,null,{"$f":"O5+T5","v":11912}]

{"sheet":"полотно","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[15,0,15,2]]}
[null,"Сотовое полотно","трубчатое полотно","полнотелое полотно","(ПП IE 30)","(ПП IE 60)"]
["Вид отделки","цена руб/м2","цена руб/м2","цена руб/м2","цена руб/м2","цена руб/м2"]
["шпон эконом",3890,4520,4830,5250,6510]
["шпон натурал",4410,5040,5360,5780,7030]
["Пластик белый",2100,2630,2940,2940,6510]
["Пластик под дерево",2100,2630,2940,2940,5040]
["эмаль",3890,4520,4830,4830,6510]
[]
[]
[]
["тонировка шпона","цена руб/м2"]
["ДА",630]
["НЕТ",0]
[]
[]
["Доп опция пластика"]
["вид отделки","белый","дерево"]
["цена руб/лист",2600,3000]
[]
[]
["Фрезеровка",85]
[]
[]
[]
["сотовое"]
["трубчатое"]
["полнотелое"]
["(ПП IE 30)"]
["(ПП IE 60)"]

{"sheet":"Алюм коробки Фрист","index":2,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,7,0,9],[0,11,0,13],[0,15,0,17],[35,0,35,5],[0,0,0,5],[7,0,7,5],[14,0,14,4],[21,0,21,5],[28,0,28,5]]}
["Под глухое полотно RAL 9016",null,null,null,null,null,null,"RAL 9016",null,null,null,"Анодировка",null,null,null,"неокрашено"]
[null,700,900,1200,1500,1800,null,"высота","ширина","стоимость",null,"высота","ширина","стоимость",null,"высота","ширина","стоимость"]
[2100,2860,2860,2940,2960,2975,null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H3))+1),MIN(5,SUMPRODUCT(--(B2:F2<I3))+1))","v":{"$error":"#REF!"}},null,{"$f":"H3","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L3))+1),MIN(5,SUMPRODUCT(--(B9:F9<M3))+1))","v":{"$error":"#REF!"}},null,{"$f":"L3","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P3))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q3))+1))","v":{"$error":"#REF!"}}]
[2300,2950,2950,2965,2980,2995,null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H4))+1),MIN(5,SUMPRODUCT(--(B2:F2<I4))+1))","v":{"$error":"#REF!"}},null,{"$f":"H4","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L4))+1),MIN(5,SUMPRODUCT(--(B9:F9<M4))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P4))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q4))+1))","v":{"$error":"#REF!"}}]
[2700,2980,2990,3010,3025,3035,null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H5))+1),MIN(5,SUMPRODUCT(--(B2:F2<I5))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L5))+1),MIN(5,SUMPRODUCT(--(B9:F9<M5))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P5))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q5))+1))","v":{"$error":"#REF!"}}]
[3000,3010,3025,3035,3055,3065,null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H6))+1),MIN(5,SUMPRODUCT(--(B2:F2<I6))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L6))+1),MIN(5,SUMPRODUCT(--(B9:F9<M6))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P6))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q6))+1))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H7))+1),MIN(5,SUMPRODUCT(--(B2:F2<I7))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L7))+1),MIN(5,SUMPRODUCT(--(B9:F9<M7))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P7))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q7))+1))","v":{"$error":"#REF!"}}]
["Под глухое полотно анодировка"]
[null,700,900,1200,1500,1800]
[2100,3060,3060,3075,3095,3105]
[2300,3070,3080,3100,3115,3130]
[2700,3110,3125,3140,3160,3180]
[3000,3145,3160,3175,3190,3210]
[]
["Под глухое полотно неокрашено"]
[null,700,900,1200,1500,1800]
[2100,2730,2730,2740,2760,2770]
[2300,2740,2750,2765,2775,2790]
[2700,2775,2785,2800,2820,2830]
[3000,2810,2820,2830,2845,2860]
[]
["Под цельностеклянное полотно Ral 9016"]
[null,700,900,1200,1500,1800]
[2100,3570,3570,3935,3955,3975]
[2300,3570,3945,3960,3980,4005]
[2700,3980,3995,4015,4035,4055]
[3000,4020,4035,4055,4070,4095]
[]
["Под цельностеклянное полотно анодировка"]
[null,700,900,1200,1500,1800]
[2100,3740,3740,4125,4140,4165]
[2300,3740,4130,4150,4170,4195]
[2700,4170,4185,4205,4230,4250]
[3000,4215,4230,4250,4270,4290]
[]
["Под цельностеклянное полотно неокрашено"]
[null,700,900,1200,1500,1800]
[2100,3440,3440,3790,3810,3830]
[2300,3440,"3800","3815",3835,3860]
[2700,3835,"3850","3870",3890,3910]
[3000,3875,"3890","3910",3925,3950]

{"sheet":"Деревянные коробки","index":3,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,0,15,2],[28,0,28,2],[0,0,0,1],[8,0,8,1]]}
["коробка деревянная стандартная"]
["цена за п/м руб","стоимость"]
[430,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A3/1000","v":{"$error":"#REF!"}}]
[430,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A4/1000","v":{"$error":"#REF!"}}]
[430,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A5/1000","v":{"$error":"#REF!"}}]
[430,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A6/1000","v":{"$error":"#REF!"}}]
[430,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A7/1000","v":{"$error":"#REF!"}}]
[]
["коробка деревянная усиленная"]
[570,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A10/1000","v":{"$error":"#REF!"}}]
[570,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A11/1000","v":{"$error":"#REF!"}}]
[570,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A12/1000","v":{"$error":"#REF!"}}]
[570,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A13/1000","v":{"$error":"#REF!"}}]
[570,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A14/1000","v":{"$error":"#REF!"}}]
[]
["наличники "]
["наименование","цена за п/м руб","стоимость"]
["плоский",320,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B18/1000","v":{"$error":"#REF!"}}]
["плоский",320,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B19/1000","v":{"$error":"#REF!"}}]
["плоский",320,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B20/1000","v":{"$error":"#REF!"}}]
["плоский",320,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B21/1000","v":{"$error":"#REF!"}}]
["плоский",320,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B22/1000","v":{"$error":"#REF!"}}]
["телескопический",380,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B23/1000","v":{"$error":"#REF!"}}]
["телескопический",380,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B24/1000","v":{"$error":"#REF!"}}]
["телескопический",380,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B25/1000","v":{"$error":"#REF!"}}]
["телескопический",380,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B26/1000","v":{"$error":"#REF!"}}]
["телескопический",380,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B27/1000","v":{"$error":"#REF!"}}]
[]
["доборы"]
[null,"стоимость","цена"]
[1,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)/1000*(Лист2!#REF!-100)/1000*C31+(Лист2!#REF!*2+Лист2!#REF!)/1000*B37","v":{"$error":"#REF!"}},2890]
[2,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)/1000*(Лист2!#REF!-100)/1000*C32+(Лист2!#REF!*2+Лист2!#REF!)/1000*B37","v":{"$error":"#REF!"}},2890]
[3,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)/1000*(Лист2!#REF!-90)/1000*C33+(Лист2!#REF!*2+Лист2!#REF!)/1000*B37","v":{"$error":"#REF!"}},2890]
[4,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)/1000*(Лист2!#REF!-90)/1000*C34+(Лист2!#REF!*2+Лист2!#REF!)/1000*B37","v":{"$error":"#REF!"}},2890]
[5,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)/1000*(Лист2!#REF!-90)/1000*C35+(Лист2!#REF!*2+Лист2!#REF!)/1000*B37","v":{"$error":"#REF!"}},2890]
[]
["Фрезеровка",85]
[]
[null,"Сотовое полотно","трубчатое полотно","полнотелое полотно","(ПП IE 30)","(ПП IE 60)"]
[null,"цена руб/м2","цена руб/м2","цена руб/м2","цена руб/м2","цена руб/м2"]
["плоский",{"$f":"C18","v":{"$error":"#REF!"}},{"$f":"C19","v":{"$error":"#REF!"}},{"$f":"C20","v":{"$error":"#REF!"}},{"$f":"C21","v":{"$error":"#REF!"}},{"$f":"C22","v":{"$error":"#REF!"}}]
["телескопический",{"$f":"C23","v":{"$error":"#REF!"}},{"$f":"C24","v":{"$error":"#REF!"}},{"$f":"C25","v":{"$error":"#REF!"}},{"$f":"C26","v":{"$error":"#REF!"}},{"$f":"C27","v":{"$error":"#REF!"}}]

{"sheet":"Лист4","index":4,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":false,"merged":[[18,0,18,1],[28,0,28,1]]}
[null,"анодировка","9006/9016","неокрас","-",null,null,null,"анодировка","9006/9016","неокрас","-"]
["Торцевая V",{"$f":"CEILING((235.21*6.2+1000+200),10)","v":2660},{"$f":"CEILING(((194.31)*6.2+1000+200),10)","v":2410},{"$f":"CEILING(((153.71)*6.2+1000+200),10)","v":2160},null,"Толщина стены",null,"Торцевая V",{"$f":"CEILING((235.21*6.2+1000+200),10)","v":2660},{"$f":"CEILING(((194.31)*6.2+1000+200),10)","v":2410},{"$f":"CEILING(((153.71)*6.2+1000+200),10)","v":2160},null,"Толщина стены"]
["Угловая V",{"$f":"CEILING(((235.21+42.57)*6.2+1000+500),10)","v":3230},{"$f":"CEILING(((194.31+35.76)*6.2+1000+500),10)","v":2930},{"$f":"CEILING(((153.71+27.28)*6.2+1000+500),10)","v":2630},null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},null,"Угловая V",{"$f":"CEILING(((235.21+42.57)*6.2+1000+500),10)","v":3230},{"$f":"CEILING(((194.31+35.76)*6.2+1000+500),10)","v":2930},{"$f":"CEILING(((153.71+27.28)*6.2+1000+500),10)","v":2630},null,{"$f":"Лист2!H5","v":90}]
["Телескопическая V",{"$f":"CEILING(((235.21+42.57+69.02+93.53)*6.2+1000+700+((F3-75)/1000*6.2*300+30*6.2)),10)","v":{"$error":"#REF!"}},{"$f":"CEILING(((194.31+35.76+57.72+78.06)*6.2+1000+700+((F3-75)/1000*6.2*300+30*6.2)),10)","v":{"$error":"#REF!"}},{"$f":"CEILING(((153.71+27.28+43.27+57.8)*6.2+1000+700+((F3-75)/1000*6.2*300+30*6.2)),10)","v":{"$error":"#REF!"}},null,null,null,"Телескопическая V",{"$f":"CEILING(((235.21+42.57+69.02+93.53)*6.2+1000+700+((M3-75)/1000*6.2*300+30*6.2)),10)","v":4650},{"$f":"CEILING(((194.31+35.76+57.72+78.06)*6.2+1000+700+((M3-75)/1000*6.2*300+30*6.2)),10)","v":4190},{"$f":"CEILING(((153.71+27.28+43.27+57.8)*6.2+1000+700+((M3-75)/1000*6.2*300+30*6.2)),10)","v":3670}]
["Обжимная V",{"$f":"CEILING(((33.76+248.9+53.58/3.9)*6.2+1000+500),10)","v":3340},{"$f":"CEILING(((27.3+208.75+63.58/3.9)*6.2+1000+500),10)","v":3070},{"$f":"CEILING(((20.9+153.8+63.58/3.9)*6.2+1000+500),10)","v":2690},null,null,null,"Обжимная V",{"$f":"CEILING(((33.76+248.9+53.58/3.9)*6.2+1000+500),10)","v":3340},{"$f":"CEILING(((27.3+208.75+63.58/3.9)*6.2+1000+500),10)","v":3070},{"$f":"CEILING(((20.9+153.8+63.58/3.9)*6.2+1000+500),10)","v":2690}]
["Деревянная  Стандарт",null,null,null,{"$f":"'Деревянные коробки'!B3+'Деревянные коробки'!B31","v":{"$error":"#REF!"}},null,null,"Фитинги",null,null,null,{"$f":"G36","v":2433.5}]
["Деревянная  Усиленная",null,null,null,{"$f":"'Деревянные коробки'!B10+'Деревянные коробки'!B31","v":{"$error":"#REF!"}},null,null,"Фитинги угл",null,null,null,{"$f":"G37","v":3372}]
[]
[]
[]
[]
[]
["анодировка"]
["9006/9016"]
["неокрас"]
["-"]
[]
[]
["Фурнитура"]
["Hafele",1500]
["Titan 800",2190]
["Titan 1000",2290]
["Titan 1200",2380]
["Titan 1500",2430]
["Titan 2000",3660]
["Другая"]
[]
[]
["Стекло"]
["10мм",1600]
["12мм",2620]
[]
[]
[]
[]
["Фитинг верхний Т-110",308,null,null,null,"фитинги",{"$f":"B36+B37+B39+B42+B44","v":2433.5},null,"Titan T-633+ замок",{"$f":"B47+B40+B43","v":1886}]
["Фитинг нижний Т-120",308,null,null,null,"фитинги угловые",{"$f":"B36+B37+B38+B42+B44+B45","v":3372},null,"Dorma SR",{"$f":"B49","v":3890}]
["Фитинг угловой Т-140К без оси",480,null,null,null,"Петли Glassmarte",2200,null,"Dorma SR+ответка",{"$f":"B50","v":6700}]
["Верхняя ось T-133 SSS",157.5]
["Замок угловой комплект Т-150 + отв.часть с подпруж.крышкой T-100-6",609]
["Нижний шарнир T-110-12 SSS",357]
["Доводчик T-84D",1610]
["Ответная часть в пол для замка с круглым ригелем с подпружиненной крышкой T-100-6",77]
["Торцевая заглушка",50]
["Фитинг угловой Т-140 с осью",616]
[]
["Ручка комплект T-633 38x1000 SSS",1200]
[]
["Dorma Studio Rondo",3890]
["Dorma Studio Rondo c ответкой",6700]
["Петли Glassmarte",2200]
[]
[]
[]
[]
["Пленка матовая сплошная",400]
["Пленка матовая полосами",560]
["Пленка зеркальная",800]
["Пленка плотерная резка",1200]
["нет",0]
[]
[]
[]
["Монтаж"]
["сотовое",1000]
["трубчатое",1000]
["полнотелое",1000]
["(ПП IE 30)",1500]
["(ПП IE 60)",1500]