{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ввод данных","Лист1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"ввод данных","index":0,"n_rows":203,"n_cols":18,"rows_kept":203,"cut":false,"hidden":false,"merged":[[21,4,21,6],[22,4,22,6],[43,0,43,1],[98,4,98,5],[99,4,99,5],[93,4,93,5],[94,4,94,5],[95,4,95,5],[96,4,96,5],[97,4,97,5],[176,4,176,5],[197,4,197,5],[26,3,26,4],[171,1,171,2],[173,4,173,5],[174,4,174,5],[175,4,175,5],[87,0,87,1],[86,0,86,1],[92,0,92,1],[92,2,92,3],[73,0,73,3],[34,0,34,20],[37,0,37,1],[45,0,45,1],[36,0,36,1]]}
[]
[]
[null,"Калькулятор расчета стоимости набора профиля \"Астрель\" "]
[]
[]
[]
[null,"Сторона \"А\" шкафа",null,null,1000,"мм"]
[null,"Сторона \"В\" шкафа",null,null,1000,"мм"]
[null,"Сторона \"С\" шкафа",null,null,0,"мм",null,null,null,null,null,null,null,null,null,null,null,"Радиус трека"]
[null,"Условный радиус",null,null,{"$f":"IF(C56=3,10000,IF(E7>=E8,E7,E8))","v":1000},"мм"]
[null,"Высота проёма",null,null,2500,"мм"]
[null,"Количество дверей",null,null,2,"шт",null,null,null,null,null,null,null,"Сторона \"А\""]
[null,"Количество секций в двери",null,null,4,"шт"]
[]
[]
[null,"Цвет -"]
[]
[null,"Диагональ шкафа (хорда)",null,null,{"$f":"CEILING(SQRT((ABS(E7-E9))^2+E8^2),0.01)","v":1414.22},"мм"]
[null,"Длина трека",null,null,{"$f":"CEILING(2^5*E10*(SQRT(2-SQRT(2+SQRT(2+SQRT(2+SQRT(2+SQRT(4-((E18/E10)^2)))))))),0.01)","v":1570.65},"мм",null,null,null,null,null,null,null,null,null,null,"сторона \"В\""]
[null,"Ширина двери",null,null,{"$f":"IF(C56=1,(E19+(E12-1)*C38)/E12-30,(E19+(E12-1)*C38)/E12+30)","v":768.32500000000005},"мм"]
[null,"Размер наполнения (ВхШ) мм.",null,{"$f":"D68","v":590.5},{"$f":"D69","v":730.32500000000005},"мм"]
[null,"фрезеровка панелей и установка треков",null,null," материал заказчика"]
[null,"раскрой наполнения",null,null," материал заказчика"]
[null,"сборка дверей"]
[null,"упаковка"," (для отправки транспортной компанией)"]
[]
[null,"Итого",null,{"$f":"E203","v":23765.3},null,"руб."]
[]
[]
[]
[]
[]
[]
[]
["Списки и окна и расчетные значения"]
[]
["Выбор ручки профиля",null,1]
["Ширина  ручки профиля в мм.",null,{"$f":"IF(C37=2,C40,IF(C37=3,C41,IF(C37=4,C42,C39)))","v":26}]
["Открытая \"С\"",null,26]
["Закрытая \"Н\"",null,35]
["Овальная",null,39]
["Квадро",null,42]
[]
["выбор ручки и цвета",null,{"$f":"IF(C37<=2,IF(C46=1,1,IF(C46=2,2,IF(C46=3,3,IF(8>C46,4,IF(C46=8,5))))),IF(C37=3,IF(C46=1,6,IF(C46=2,0,IF(C46=3,7,IF(8>C46,8,IF(C46=8,0))))),IF(C37=4,IF(C46<2,9,0))))","v":1}]
[]
["Цвет профиля",null,1]
["\"серебро\""]
["\"шампань\""]
["\"золото\""]
["кэшированный \"Венге\""]
["кэшированный \"Дуб Млечный\""]
["кэшированный \"Вишня\""]
["кэшированный \"Орех Итальянский\""]
["кэшированный \"Белый\""]
[]
["Форма шкафа",null,1]
["Выгнутый"]
["Вогнутый"]
["Прямой"]
[]
[null,null,null,null,null,null,"хлыст"]
["горизонталь универсальная",null,null,{"$f":"IF(E12>1,E13*(D70+300)*E12,(E13-1)*(D70+300))*0.001","v":8.1306000000000012},"м.",null,{"$f":"IF(C46=3,CEILING(D62,2.9)/2.9,CEILING(D62,2.7)/2.7)","v":4},"шт."]
["Горизонталь нижняя",null,"3м.",{"$f":"IF(E12>1,(D70+300)*E12,2*(D70+300))*0.001","v":2.0326500000000003},"м.",null,{"$f":"CEILING(D63,3)/3","v":1},"шт."]
["Длина трека",null,"3,5м.",{"$f":"(E19+100)*0.001","v":1.6706500000000002},"м.",null,{"$f":"IF(D64<=3.5,3.5,6)","v":3.5},"м."]
["ручка профиль",null,null,{"$f":"E11-40","v":2460},"мм",null,{"$f":"E12","v":2}]
["уплотнитель",null,null,{"$f":"CEILING((D65*E12*2+E13*E12*D70*2)*0.001,1)","v":22},"м."]
["шлегель",null,null,{"$f":"CEILING(E11*2*E12*0.001,1)","v":10},"м."]
["Заполнение дверей (высота)",null,null,{"$f":"(D65-50-18-((E13-1)*10))/E13","v":590.5},"мм"]
["Заполнение дверей (ширина)",null,null,{"$f":"D70+14","v":730.32500000000005},"мм"]
["Длина  горизонтали",null,null,{"$f":"E20-C38*2","v":716.32500000000005},"мм"]
["Винт сборочный",null,null,{"$f":"(E13+1)*E12*2","v":20},"шт."]
["Фиксатор",null,null,{"$f":"IF(E12>=3,E12+1,E12)","v":2},"шт."]
[]
["Выбор услуг и позиций"]
["верхний трек",null,null,true]
["нижний трек",null,null,true]
["ручка профиль",null,null,true]
["уплотнитель",null,null,true]
["шлегель",null,null,true]
["ролики",null,null,true]
["фиксатор",null,null,true]
["установка треков",null,null,false]
["раскрой наполнения",null,null,false]
["сборка дверей",null,null,false]
["упаковка",null,null,false]
[]
["Использование нашего ЛДСП",null,1]
["Список нашего ЛДСП"]
["ЛДСП \"Томсклесдрев\""]
["ЛДСП \"Сыктывкар\""]
["ЛДСП \"Эггер\""]
[]
["Использование нашего заполнения",null,{"$f":"D68*D69*0.000001","v":0.43125691250000003},null,"S зап. =",{"$f":"C93*E13*E12","v":3.4500553000000003},"листов"]
["Акриловое стекло ",null,null,false,{"$f":"IF(AND(D94,D96,D97,D98,D99),F93/5,IF(AND(D94,D96,D97,D98),F93/4,IF(AND(D94,D96,D97,D99),F93/4,IF(AND(D94,D96,D98,D99),F93/4,IF(AND(D94,D97,D98,D99),F93/4,IF(AND(D94,D96,D97),F93/3,IF(AND(D94,D96,D98),F93/3,IF(AND(D94,D96,D99),F93/3,IF(AND(D94,D97,D98),F93/3,IF(AND(D94,D97,D99),F93/3,IF(AND(D94,D98,D99),F93/3,IF(AND(D94,D96),F93/2,IF(AND(D94,D97),F93/2,IF(AND(D94,D98),F93/2,IF(AND(D94,D99),F93/2,IF(D94,F93,0))))))))))))))))","v":0},null,{"$f":"CEILING(E94/6,0.5)","v":0}]
["Фотопечать",null,null,false,{"$f":"IF(D95,C93*N20,0)","v":0},null,{"$f":"CEILING(E95/1,1)","v":0}]
["Пластик \"Слотекс\" ",null,null,false,{"$f":"IF(AND(D94,D96,D97,D98,D99),F93/5,IF(AND(D96,D94,D97,D98),F93/4,IF(AND(D96,D94,D97,D99),F93/4,IF(AND(D96,D94,D98,D99),F93/4,IF(AND(D96,D97,D98,D99),F93/4,IF(AND(D96,D94,D97),F93/3,IF(AND(D94,D96,D98),F93/3,IF(AND(D94,D96,D99),F93/3,IF(AND(D96,D97,D98),F93/3,IF(AND(D96,D97,D99),F93/3,IF(AND(D96,D98,D99),F93/3,IF(AND(D94,D96),F93/2,IF(AND(D96,D97),F93/2,IF(AND(D96,D98),F93/2,IF(AND(D96,D99),F93/2,IF(D96,F93,0))))))))))))))))","v":0},null,{"$f":"CEILING(E96/3,1)","v":0}]
["Пластик \"Абет Ламинати\" ",null,null,false,{"$f":"IF(AND(D94,D96,D97,D98,D99),F93/5,IF(AND(D94,D96,D97,D98),F93/4,IF(AND(D94,D96,D97,D99),F93/4,IF(AND(D97,D96,D98,D99),F93/4,IF(AND(D94,D97,D98,D99),F93/4,IF(AND(D94,D96,D97),F93/3,IF(AND(D97,D96,D98),F93/3,IF(AND(D97,D96,D99),F93/3,IF(AND(D94,D97,D98),F93/3,IF(AND(D94,D97,D99),F93/3,IF(AND(D97,D98,D99),F93/3,IF(AND(D97,D96),F93/2,IF(AND(D94,D97),F93/2,IF(AND(D97,D98),F93/2,IF(AND(D97,D99),F93/2,IF(D97,F93,0))))))))))))))))","v":0},null,{"$f":"CEILING(E97/3,1)","v":0}]
["Пластик \"Willsonart\" 1500х3000",null,null,false,{"$f":"IF(AND(D94,D96,D97,D98,D99),F93/5,IF(AND(D94,D96,D97,D98),F93/4,IF(AND(D98,D96,D97,D99),F93/4,IF(AND(D94,D96,D98,D99),F93/4,IF(AND(D94,D97,D98,D99),F93/4,IF(AND(D98,D96,D97),F93/3,IF(AND(D94,D96,D98),F93/3,IF(AND(D98,D96,D99),F93/3,IF(AND(D94,D97,D98),F93/3,IF(AND(D98,D97,D99),F93/3,IF(AND(D94,D98,D99),F93/3,IF(AND(D98,D96),F93/2,IF(AND(D98,D97),F93/2,IF(AND(D94,D98),F93/2,IF(AND(D98,D99),F93/2,IF(D98,F93,0))))))))))))))))","v":0},null,{"$f":"CEILING(E98/4,1)","v":0}]
["Экокожа",null,null,false,{"$f":"IF(AND(D94,D96,D97,D98,D99),F93/5,IF(AND(D99,D96,D97,D98),F93/4,IF(AND(D94,D96,D97,D99),F93/4,IF(AND(D94,D96,D98,D99),F93/4,IF(AND(D94,D97,D98,D99),F93/4,IF(AND(D99,D96,D97),F93/3,IF(AND(D99,D96,D98),F93/3,IF(AND(D94,D96,D99),F93/3,IF(AND(D99,D97,D98),F93/3,IF(AND(D94,D97,D99),F93/3,IF(AND(D94,D98,D99),F93/3,IF(AND(D99,D96),F93/2,IF(AND(D99,D97),F93/2,IF(AND(D99,D98),F93/2,IF(AND(D94,D99),F93/2,IF(D99,F93,0))))))))))))))))","v":0},null,{"$f":"CEILING(E99/1,1)","v":0}]
["ДВПо",null,null,{"$f":"OR(D99,D98,D97,D96)","v":false},{"$f":"SUM(E96:E99)","v":0},null,{"$f":"CEILING(E100/4,1)","v":0}]
[]
[]
["Прайс"]
[]
[null,"Наименование",null,"ед. изм."]
[null,"Серебро"]
[null,"Горизонталь верх, средняя",null,"2,7 м.",550,"руб."]
[null,"Горизонталь нижняя",null,"6 м.",2400,"руб."]
[null,"Верхняя направляющая",null,"6 м.",1350,"руб."]
[null,"Нижняя направляющая",null,"6 м.",500,"руб."]
[null,"Профиль-ручка открытая",null,"5,4 м.",1550,"руб."]
[null,"Профиль-ручка закрытая",null,"5,4 м.",1550,"руб."]
[null,"Профиль-ручка \"овальная\" \"Модус\"",null,"2,7 м.",990,"руб."]
[null,"Профиль-ручка \"квадро\" \"Модус\"",null,"2,7 м.",1505,"руб."]
[null,"Шампань \"Аристо\",\"Модус\""]
[null,"Горизонталь верх, средняя",null,"2,7 м.",550,"руб."]
[null,"Горизонталь нижняя",null,"6 м.",2400,"руб."]
[null,"Верхняя направляющая",null,"6 м.",1350,"руб."]
[null,"Нижняя направляющая",null,"6 м.",500,"руб."]
[null,"Профиль-ручка открытая",null,"5,4 м.",1610,"руб."]
[null,"Профиль-ручка закрытая",null,"5,4 м.",1610,"руб."]
[null,"Профиль-ручка \"овальная\" \"Модус\"",null,"2,7 м."]
[null,"Профиль-ручка \"квадро\" \"Модус\"",null,"2,7 м."]
[null,"Золото \"Фурниту\""]
[null,"Горизонталь верх, средняя",null,"2,9 м.",753,"руб."]
[null,"Горизонталь нижняя",null,"6 м.",2400,"руб."]
[null,"Верхняя направляющая",null,"6 м.",1350,"руб."]
[null,"Нижняя направляющая",null,"6 м.",500,"руб."]
[null,"Профиль-ручка открытая",null,"5,5 м.",975,"руб."]
[null,"Профиль-ручка закрытая",null,"5,5 м.",975,"руб."]
[null,"Профиль ручка \"овальная\" \"Модус\"",null,"2,7 м.",1030,"руб."]
[null,"Кэшированные дерево \"Аристо\""]
[null,"Горизонталь верх, средняя",null,"2,7 м.",550,"руб."]
[null,"Горизонталь нижняя",null,"3 м.",2400,"руб."]
[null,"Верхняя направляющая",null,"6 м.",1350,"руб."]
[null,"Нижняя направляющая",null,"6 м.",500,"руб."]
[null,"Профиль-ручка открытая",null,"5,4 м.",1630,"руб."]
[null,"Профиль-ручка закрытая",null,"5,4 м.",1630,"руб."]
[null,"Профиль ручка \"овальная\"\"Модус\"",null,"2,7 м.",1585,"руб."]
[null,"Кэшированные белый \"Аристо\""]
[null,"Горизонталь верх, средняя",null,"2,7 м.",600,"руб."]
[null,"Горизонталь нижняя",null,"6 м.",2400,"руб."]
[null,"Верхняя направляющая",null,"6 м.",1350,"руб."]
[null,"Нижняя направляющая",null,"6 м.",500,"руб."]
[null,"Профиль-ручка открытая",null,"5,4 м.",1800,"руб."]
[]
[null,"Шлегель",null,"1 м.",19,"руб."]
[null,"Уплотнитель",null,"1 м.",19,"руб."]
[null,"К-т роликов",null,"1 к-т",250,"руб."]
[null,"Распашной механизм",null,"1 к-т",150,"руб."]
[null,"Сборка двери 3 секции",null,"1 шт.",1000,"руб."]
[null,"Сборка 1 секции",null,"1 шт.",100,"руб."]
[null,"Винт сборочный",null,"1 шт.",2,"руб."]
[null,"Фиксатор двери на скотче",null,"1 шт.",25,"руб."]
[null,"Фиксатор двери магнит",null,"1 шт.",100,"руб."]
[null,"ЛДСП \"Томсклесдрев\"",null,"1 лист.",1700,"руб."]
[null,"ЛДСП \"Сыктывкар\"",null,"1 лист.",3200,"руб."]
[null,"ЛДСП \"Эггер\"",null,"1 лист.",3800,"руб."]
[null,"ДВПо 2750х1700",null,"1 лист.",500,"руб."]
[null,"Акриловое стекло 2050х3050",null,"1 лист.",20000,"руб."]
[null,"Фотопечать",null,"1 м.кв.",3000,"руб."]
[null,"Пластик \"Слотекс\" 1300х3000",null,"1 лист.",2000,"руб."]
[null,"Пластик \"Абет Ламинати\" ",null,"1 лист.",4000,"руб."]
[null,"Пластик \"Willsonart\" 1500х3000",null,"1 лист.",6000,"руб."]
[null,"Экокожа",null,"п.м.",1000,"руб."]
[null,"Раскрой наполнения",null,"п.м.",30,"руб."]
[null,"Кромкооблицовка",null,"п.м.",70,"руб."]
[null,"Кэширование",null,"п.м.",70,"руб."]
[null,"Установка треков",null,"шт.",200,"руб."]
[null,"Упаковка в ЛДСП",null,"шт.",3000,"руб."]
[]
[null,"Расчет цены",null,null,"Цена *",3,null,"Цена +",10,"%",null,"Цена без надбавки"]
[]
[null,"Горизонталь универсальная",null,{"$f":"IF(C46=1,G62*E107,IF(C46=2,G62*E116,IF(C46=3,G62*E125,IF(C46=8,G62*E141,G62*E133))))","v":2200},{"$f":"D174*F172","v":6600}]
[null,"Горизонталь нижняя",null,{"$f":"IF(C46=2,G63*E117/2,IF(C46=3,E126/2*G63,E108/2))","v":1200},{"$f":"D175*F172","v":3600}]
[null,"Трек верний",null,{"$f":"IF(E12>1,IF(C46<4,E109/6*G64*3,E109/6*G64*3+D64*3*E168),0)","v":2362.5},{"$f":"D176*F172","v":7087.5}]
[null,"Трек нижний",null,{"$f":"IF(E12>1,E110/6*G64*2,0)","v":583.33333333333326},{"$f":"D177*F172","v":1749.9999999999998}]
[null,"Ролики или распашной мех.",null,{"$f":"IF(D80,IF(E12>=2,E12*E149,E12*E150),0)","v":500},null,null,null,{"$f":"D178+D178*I172/100","v":550}]
[null,"Шлегель",null,{"$f":"IF(D79,D67*E147,0)","v":190},null,null,null,{"$f":"D179+D179*I172/100","v":209}]
[null,"Уплотнитель",null,{"$f":"IF(D78,D66*E148,0)","v":418},null,null,null,{"$f":"D180+D180*I172/100","v":459.8}]
[null,"Винт сборочный",null,{"$f":"IF(D80,D71*E153,0)","v":40},null,null,null,{"$f":"D181+D181*I172/100","v":44}]
[null,"Фиксатор двери",null,{"$f":"IF(D81,IF(D72=1,E155,E154*D72),0)","v":50},null,null,null,{"$f":"D182+D182*I172/100","v":55}]
[null,"Установка треков+ кромкооблицовка",null,{"$f":"IF(D82,(D64*5*E169)+(D64*4*E167),0)","v":0},null,null,null,null,null,null,null,{"$f":"D183","v":0}]
[null,"ЛДСП",null,{"$f":"IF(D82,IF(C87=2,E156,IF(C87=3,E157,IF(C87=4,E158,0))),0)","v":0},null,null,null,{"$f":"D184+D184*I172/100","v":0}]
[null,"Сборка дверей",null,{"$f":"IF(AND(D84,E13<=3),E151*E12,IF(AND(D84,E13>=4),E151*E12+(E152*E12*(E13-3)),0))","v":0},null,null,null,null,null,null,null,{"$f":"D185","v":0}]
[null,"Раскрой наполнения",null,{"$f":"IF(D83,D66*E166,0)","v":0},null,null,null,null,null,null,null,{"$f":"D186","v":0}]
[null,"Акриловое стекло",null,{"$f":"E160*G94","v":0},null,null,null,{"$f":"D187+D187*I172/100","v":0}]
[null,"Пластик \"Слотекс\" ",null,{"$f":"E162*G96","v":0},null,null,null,{"$f":"D188+D188*I172/100","v":0}]
[null,"Пластик \"Абет Ламинати\" ",null,{"$f":"E163*G97","v":0},null,null,null,{"$f":"D189+D189*I172/100","v":0}]
[null,"Пластик \"Willsonart\" 1500х3000",null,{"$f":"E164*G98","v":0},null,null,null,{"$f":"D190+D190*I172/100","v":0}]
[null,"Экокожа",null,{"$f":"E165*G99","v":0},null,null,null,{"$f":"D191+D191*I172/100","v":0}]
[null,"ДВПо",null,{"$f":"E159*G100","v":0},null,null,null,{"$f":"D192+D192*I172/100","v":0}]
[null,"Фотопечать",null,{"$f":"E161*G95","v":0},null,null,null,{"$f":"D193+D193*I172/100","v":0}]
[null,"Упаковка",null,{"$f":"IF(D85,E170,0)","v":0},null,null,null,null,null,null,null,{"$f":"D194","v":0}]
[null,"Ручка профиль",null,{"$f":"IF(D77,IF(C44=1,E111*E12,IF(C44=2,E120*E12,IF(C44=3,E129*E12,IF(C44=4,E137*E12,IF(C44=5,E145*E12,IF(C44=6,E113*E12*2,IF(C44=7,E131*E12*2,IF(C44=8,E139*E12*2,IF(C44=9,E114*E12*2,0))))))))),0)","v":3100},null,null,null,{"$f":"IF(D65>2700,(D195+D195*I172/100)*2,D195+D195*I172/100)","v":3410}]
[]
["-----------------------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,"--------------------------------------------------------------------------------------"]
["Итого:",null,null,null,{"$f":"SUM(E174:E197)","v":19037.5},null,null,{"$f":"SUM(H178:H197)","v":4727.8},null,null,null,{"$f":"SUM(L183:L197)","v":0}]
[]
[]
["Всего:",{"$f":"SUM(E198:L198)","v":23765.3}]
[]
["Расчет прямого профиля",null,null,null,{"$f":"IF(C56=3,B201/2,B201)","v":23765.3}]

{"sheet":"Лист1","index":1,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[197,197,197,197,197,null,197,197,197,null,197,197,null,197]
[199,199,199,199,null,199,199,199,null,null,199]
[200,200,200,null,200,200,200,null,null,200]
[201,201,null,201,201,201,null,null,201,201,null,null,201]
[202,null,202,202,202,202,null,202,202,202,null,202,202]
[]
[]
[199,199,199,199,199,null,199,199,199,null,199,199,null,199]
[200,200,200,200,null,200,200,200,null,null,200]
[201,201,201,null,201,201,201,null,null,201]
[202,202,null,202,202,202,null,null,202,202,null,null,202]
[197,null,197,197,197,197,null,197,197,197,null,197,197]
[]
[200,200,200,200,200,null,200,200,200,null,200,200,null,200]
[201,201,201,201,null,201,201,201,null,null,201]
[202,202,202,null,202,202,202,null,null,202]
[197,197,null,197,197,197,null,null,197,197,null,null,197]
[199,null,199,199,199,199,null,199,199,199,null,199,199]
[]
[201,201,201,201,201,null,201,201,201,null,201,201,null,201]
[202,202,202,202,null,202,202,202,null,null,202]
[197,197,197,null,197,197,197,null,null,197]
[199,199,null,199,199,199,null,null,199,199,null,null,199]
[200,null,200,200,200,200,null,200,200,200,null,200,200]
[]
[202,202,202,202,202,null,202,202,202,null,202,202,null,202]
[197,197,197,197,null,197,197,197,null,null,197]
[199,199,199,null,199,199,199,null,null,199]
[200,200,null,200,200,200,null,null,200,200,null,null,200]
[201,null,201,201,201,201,null,201,201,201,null,201,201]