{"text_format":"1","workbook":"xlsx","n_sheets":3,"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":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"стоимость",null,null,"Тип коробки","Цвет",null,"Тип наличников",null,"Фурнитура",null,"Монтаж / Доставка","Итого"]
[null,{"$f":"INDIRECT(\"полотно!B\" &#REF!+ 11)","v":{"$error":"#REF!"}},null,null,6,4,{"$f":"INDEX(Лист4!$B$2:$E$7,E4,F4)*IF(AND(ISNUMBER(FIND(\"V\",INDEX(Лист4!$A$2:$A$7,E4))),#REF!*2+#REF!>5800),1.5,1)","v":{"$error":"#REF!"}},1,{"$f":"INDIRECT(\"'Деревянные коробки'!B\" & H4+40)","v":{"$error":"#REF!"}},1,{"$f":"CHOOSE(J4,Лист4!B19,Лист4!B20,Лист4!B21,Лист4!B22,Лист4!B23,Лист4!B24,Лист4!B25,Лист4!B26)*IF(AND(ISNUMBER(FIND(\"Titan\",INDEX(Лист4!$A$19:$A$26,J4))),#REF!>1100),2,1)","v":{"$error":"#REF!"}},{"$f":"((CHOOSE(#REF!,Лист4!#REF!,Лист4!#REF!,Лист4!#REF!,Лист4!#REF!,Лист4!#REF!)+IF(AND(ISNUMBER(FIND(\"Телескопическая\",INDEX(Лист4!$A$78:$A$83,E4))),#REF!>600),400,0))*IF(#REF!>1100,2,1)+CHOOSE(#REF!,Лист4!#REF!,Лист4!#REF!,Лист4!#REF!,Лист4!#REF!,Лист4!#REF!))","v":{"$error":"#REF!"}},{"$f":"#REF!+B4+G4+I4+K4+L4","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Дверь глухая распашная. \nПолотно: \"&CHOOSE(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)&\" \"&CHOOSE(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)&\"\nКоробка: \"&CHOOSE(E4,#REF!,#REF!,#REF!,#REF!,#REF!,)&\" \"&CHOOSE(H4,#REF!,#REF!,#REF!,)&\". Цвет: \"&CHOOSE(F4,#REF!,#REF!,#REF!,#REF!)&\"\nФрамуга: нет \nРазмеры: \"&#REF!&\"х\"&#REF!&\"мм\"","v":{"$error":"#REF!"}}]

{"sheet":"Деревянные коробки","index":1,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[15,0,15,2],[28,0,28,2],[0,0,0,1],[8,0,8,1]]}
["коробка деревянная стандартная"]
["цена за п/м руб","стоимость"]
[452,{"$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!"}}]
[]
["коробка деревянная усиленная"]
[600,{"$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!"}}]
[]
["наличники "]
["наименование","цена за п/м руб","стоимость"]
["плоский",336,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B18/1000","v":{"$error":"#REF!"}}]
["плоский",336,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B19/1000","v":{"$error":"#REF!"}}]
["плоский",336,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B20/1000","v":{"$error":"#REF!"}}]
["плоский",336,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B21/1000","v":{"$error":"#REF!"}}]
["плоский",336,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B22/1000","v":{"$error":"#REF!"}}]
["телескопический",400,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B23/1000","v":{"$error":"#REF!"}}]
["телескопический",400,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B24/1000","v":{"$error":"#REF!"}}]
["телескопический",400,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B25/1000","v":{"$error":"#REF!"}}]
["телескопический",400,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B26/1000","v":{"$error":"#REF!"}}]
["телескопический",400,{"$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]
[]
["Фрезеровка",90]
[]
[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":2,"n_rows":83,"n_cols":13,"rows_kept":83,"cut":false,"hidden":false,"merged":[[17,0,17,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(((253.71)*6.2+1000+200),10)","v":2780},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(((253.71)*6.2+1000+200),10)","v":2780},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(((253.71+48.1)*6.2+1000+500),10)","v":3380},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(((253.71+48.1)*6.2+1000+500),10)","v":3380},null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}}]
["Телескопическая 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(((253.71+27.28+135.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":{"$error":"#REF!"}},{"$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":{"$error":"#REF!"}},{"$f":"CEILING(((253.71+27.28+135.27+57.8)*6.2+1000+700+((M3-75)/1000*6.2*300+30*6.2)),10)","v":{"$error":"#REF!"}}]
["Фристайл",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},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+253.8+170.58/3.9)*6.2+1000+500),10)","v":3480}]
["Деревянная  Стандарт",null,null,null,{"$f":"'Деревянные коробки'!B3+'Деревянные коробки'!B31","v":{"$error":"#REF!"}},null,null,"Фитинги",null,null,null,{"$f":"G37","v":2433.5}]
["Деревянная  Усиленная",null,null,null,{"$f":"'Деревянные коробки'!B10+'Деревянные коробки'!B31","v":{"$error":"#REF!"}},null,null,"Фитинги угл",null,null,null,{"$f":"G38","v":3372}]
[]
[]
[]
[]
["анодировка"]
["9006/9016"]
["нестандарт"]
["-"]
[]
[]
["Фурнитура"]
["Hafele",1500]
["Titan 800",2190]
["Titan 1000",2290]
["Titan 1200",2380]
["Titan 1500",2430]
["Titan 1800",2530]
["Titan 2000",3660]
["Другая"]
[]
[]
["Стекло"]
["10мм",1600]
["12мм",2620,null,null,null,null,null,null,"Ручки ","Цена"]
[null,null,null,null,null,null,null,null,"T-633 (800 мм)",1190,null,"Замки","Цена"]
[null,null,null,null,null,null,null,null,"T-633 (1000 мм)",1290,null,"T-150R*",609]
[null,null,null,null,null,null,null,null,"T-633 (1200 мм)",1380,null,"T-034*",840]
[null,null,null,null,null,null,null,null,"T-633 (1500 мм)",1430,null,"T-034(+K)",1270]
["Фитинг верхний Т-110",308,null,null,null,null,null,null,"T-633 (1800 мм)",1530,null,"-"]
["Фитинг нижний Т-120",308,null,null,null,"фитинги",{"$f":"B36+B37+B39+B42+B44","v":2433.5},null,"T-633 (2000 мм)",2660]
["Фитинг угловой Т-140К без оси",480,null,null,null,"фитинги угловые",{"$f":"B36+B37+B38+B42+B44+B45","v":3372},null,"Dorma Studio R",{"$f":"B49","v":3890}]
["Верхняя ось T-133 SSS",157.5,null,null,null,"Петли Glassmarte",2200,null,"Dorma SR+ответка",{"$f":"B50","v":6700}]
["Замок угловой комплект Т-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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Монтаж Стеклянных дверей"]
["Торцевая V",1200]
["Угловая V",1200]
["Телескопическая V",1600]
["Обжимная V",1200]
["Фитинги",1400]
["Фитинги угл",1400]