{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Подоконники100","!СПРАВКА!"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":92,"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":"Подоконники100","index":0,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[34,0,34,1],[34,2,34,10],[7,0,7,1],[7,2,7,10],[9,1,9,2],[9,3,9,6],[9,7,9,8],[10,3,10,4],[4,0,4,1],[4,2,4,10],[5,0,5,1],[5,2,5,10],[6,0,6,1],[6,2,6,10],[3,5,3,10],[0,0,0,1],[0,2,0,3],[2,0,2,4],[3,0,3,1],[3,2,3,4]]}
["Дата:",null,null,null,null,null,null,null,null,null,null,null,null,null,"1977-04-11",{"$f":"LOOKUP(DATE(,MONTH(O1),DAY(O1)),{1,20,50,81,111,142,173,205,236,267,297,327,357}, {\"Козерог\",\"Водолей\",\"Рыбы\",\"Овен\",\"Телец\",\"Близнецы\",\"Рак\",\"Лев\",\"Дева\",\"Весы\",\"Скорпион\",\"Стрелец\",\"Козерог\"})","v":"Овен"},"Сейчас",{"$f":"LOOKUP(DATE(,MONTH(NOW()),DAY(NOW())),{1,20,50,81,111,142,173,205,236,267,297,327,357}, {\"Козерог\",\"Водолей\",\"Рыбы\",\"Овен\",\"Телец\",\"Близнецы\",\"Рак\",\"Лев\",\"Дева\",\"Весы\",\"Скорпион\",\"Стрелец\",\"Козерог\"})","v":"Телец"}]
[]
["Заказ с предоплатой №",null,null,null,null,"откН",null,null,null,null,null,null,null,null,1977,{"$f":"REPT(CHOOSE(TRUNC(MOD(O3,10)/2,)+1,\"бело\",\"черно\",\"зелено\",\"красно\",\"желто\")&IF(COUNT(1/(MOD(O3,12)={1,6,7,8})),\"го \",\"й \")&CHOOSE(MOD(O3,12)+1,\"обезьяны\",\"петуха\",\"собаки\",\"свиньи\",\"крысы\",\"коровы\",\"тигра\",\"зайца\",\"дракона\",\"змеи\",\"лошади\",\"овцы\"),O3<>\"\")","v":"красной змеи"}]
["Заказчик"]
["Адрес"]
["Организация"]
["Адрес/тел"]
["ИНН"]
[]
["№","Подоконники",null,"Расчет",null,null,null,"Накладки на Под.",null,"Монтаж","Всего",null,null,"Монтаж"]
[null,"Ширина","Размер","Ширина/кол-во",null,"Итого","Сумма","Итого","Сумма","Сумма","Сумма",null,null,true]
[1,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L12,1)","v":150},{"$f":"IF(OR(ISBLANK(B12),E12=0),,ROUNDUP(B12/1000,2))","v":1},1,{"$f":"D12*E12","v":1},{"$f":"$F12*VLOOKUP($L12,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},{"$f":"E12","v":1},{"$f":"IF(M12,0,H12*РЦзП)","v":30},{"$f":"IF(F12=0,0,IF($N$11,E12*МонтП,0))","v":50},{"$f":"G12+I12+J12","v":260},1,{"$f":"OR(ISBLANK(C12),ISBLANK(B12))","v":false}]
[{"$f":"A12+1","v":2},1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L13,1)","v":600},{"$f":"IF(OR(ISBLANK(B13),E13=0),,ROUNDUP(B13/1000,2))","v":1},1,{"$f":"D13*E13","v":1},{"$f":"$F13*VLOOKUP($L13,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":670},{"$f":"E13","v":1},30,50,{"$f":"G13+I13+J13","v":750},10,{"$f":"OR(ISBLANK(C13),ISBLANK(B13))","v":false}]
[3,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L14,1)","v":150},1,1,1,{"$f":"$F14*VLOOKUP($L14,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},1,30,50,260,1,false]
[4,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L15,1)","v":150},1,1,1,{"$f":"$F15*VLOOKUP($L15,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},1,30,50,260,1,false]
[5,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L16,1)","v":150},1,1,1,{"$f":"$F16*VLOOKUP($L16,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},1,30,50,260,1,false]
[6,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L17,1)","v":150},1,1,1,{"$f":"$F17*VLOOKUP($L17,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},1,30,50,260,1,false]
[7,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L18,1)","v":150},1,1,1,{"$f":"$F18*VLOOKUP($L18,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},1,30,50,260,1,false]
[8,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L19,1)","v":"Мюллер"},1,1,1,{"$f":"$F19*VLOOKUP($L19,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":2000},1,30,50,2080,11,false]
[9,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L20,1)","v":150},1,1,1,{"$f":"$F20*VLOOKUP($L20,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},1,30,50,260,1,false]
[10,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L21,1)","v":150},1,1,1,{"$f":"$F21*VLOOKUP($L21,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},1,30,50,260,1,false]
[11,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L22,1)","v":150},1,1,1,{"$f":"$F22*VLOOKUP($L22,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},1,30,50,260,1,false]
[12,1000,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L23,1)","v":150},1,1,1,{"$f":"$F23*VLOOKUP($L23,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":180},1,30,50,260,1,false]
[13,null,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L24,1)","v":350},{"$f":"IF(OR(ISBLANK(B24),E24=0),,ROUNDUP(B24/1000,2))","v":0},null,{"$f":"D24*E24","v":0},{"$f":"$F24*VLOOKUP($L24,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":0},{"$f":"E24","v":0},0,{"$f":"IF(F24=0,0,IF($N$11,E24*МонтП,0))","v":0},{"$f":"G24+I24+J24","v":0},5,true]
[14,null,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L25,1)","v":350},{"$f":"IF(OR(ISBLANK(B25),E25=0),,ROUNDUP(B25/1000,2))","v":0},null,{"$f":"D25*E25","v":0},{"$f":"$F25*VLOOKUP($L25,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":0},{"$f":"E25","v":0},0,{"$f":"IF(F25=0,0,IF($N$11,E25*МонтП,0))","v":0},{"$f":"G25+I25+J25","v":0},5,true]
[15,null,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L26,1)","v":350},{"$f":"IF(OR(ISBLANK(B26),E26=0),,ROUNDUP(B26/1000,2))","v":0},null,{"$f":"D26*E26","v":0},{"$f":"$F26*VLOOKUP($L26,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":0},{"$f":"E26","v":0},0,{"$f":"IF(F26=0,0,IF($N$11,E26*МонтП,0))","v":0},{"$f":"G26+I26+J26","v":0},5,true]
[16,null,{"$f":"INDEX('!СПРАВКА!'!$I$70:$I$81,L27,1)","v":350},{"$f":"IF(OR(ISBLANK(B27),E27=0),,ROUNDUP(B27/1000,2))","v":0},null,{"$f":"D27*E27","v":0},{"$f":"$F27*VLOOKUP($L27,'!СПРАВКА!'!$G$70:$J$81,4,0)","v":0},{"$f":"E27","v":0},0,{"$f":"IF(F27=0,0,IF($N$11,E27*МонтП,0))","v":0},{"$f":"G27+I27+J27","v":0},5,true]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F12:F27)","v":12},{"$f":"SUM(G12:G27)","v":4470},{"$f":"SUM(H12:H27)","v":12},{"$f":"SUM(I12:I27)","v":360},{"$f":"SUM(J12:J17)","v":300},{"$f":"CEILING(SUM(K12:K27),1)","v":5430}]
[]
[]
[]
[]
[]
["Сумма прописью",null,{"$f":"[2]!сумма_прописью(K29)","v":{"$error":"#NAME?"}}]
[]
[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,"подпись",null,null,"фио"]

{"sheet":"!СПРАВКА!","index":1,"n_rows":105,"n_cols":21,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,"СкПСТов",{"$f":"0.68*0.9","v":0.6120000000000001}]
[null,"СКПСДоп",{"$f":"0.8","v":0.8}]
[null,"МКомп",300,"Монтажный комплект"]
[null,"НацКонМ",1.23,"Наценка на конструкцию с монтажем"]
[null,"ДРК",250,"Доставка"]
[null,"Этаж",40,"Подъем на этаж"]
[null,"Ком",150,"Командировочные"]
[null,"Груз",20,"Доставка по району"]
[null,"Легк",10,"Проезд за город"]
[null,"ДостПоГор",100,"Доставка по городу"]
[null,"НацРаб",2,"Наценка на работы"]
[null,"Монтаж",0.05,"Монтаж от закупки"]
[null,"Демонтаж",100,"Демонтаж за 1м2"]
[null,"ДемСлож",100,{"$f":"\"+ за сложность демонтажа\"","v":"+ за сложность демонтажа"}]
[null,"МонСлож",100,{"$f":"\"+ за сложность монтажа\"","v":"+ за сложность монтажа"}]
[null,"НацМонДем",0.25,"Наценка монтаж-демонтаж"]
[null,"ЗамерОкн",100,"Замер 1 окна"]
[null,"МКомпР",150,"Монтажный комплект ролл"]
[null,"МонтажПл",200,"Монтаж за 1 м2 МПИ"]
[null,"ПрибыльО",1.3,"Прибыль от закупки МПИ"]
[null,"РасчетМенО",200,"ЗП за расчет менеджерам МПИ"]
[null,"ПрибыльР",1.5,"Прибыль от закупки Ролл-Ставни"]
[null,"ЗамерРолл",100,"Замер 1 Ролл-ставни"]
[null,"РасчетМенР",200,"ЗП за расчет менеджерам Ролл"]
[null,"МонтажПлР",300,"Монтаж за 1 м2 Ролл"]
[]
[null,"РЦ78",180]
[null,"РЦ56",130]
[null,"РЦ35",100]
[null,"РЦНС",3]
[null,"РЦМонт",50]
[null,"ЗЦ78",70]
[null,"ЗЦ56",51]
[null,"ЗЦ35",35]
[null,"РЦ100",210]
[]
[null,null,35]
[null,null,56]
[null,null,78]
[null,null,100]
["Выс",null,null,null,null,"Высота","Ширина"]
[null,"Шир","Форма",null,{"$f":"INDEX(ФормаНал,D43,1)","v":" "},{"$f":"FLOOR((D43-0.5)/3,1)","v":0},{"$f":"MOD(D43-1,3)","v":0}]
[null,null," ",1,"-",0,1]
[null,1,"-",2,"=",0,2]
[1,2,"=",3,"I",1,0]
[1,null,"I",4,"Г",1,1]
[1,1,"Г",5,"С",1,2]
[2,2,"С",6,"| |",2,{"$f":"MOD(D49-1,3)","v":0}]
[2,null,"| |",7,"П",2,{"$f":"MOD(D50-1,3)","v":1}]
[2,1,"П",8,"O",{"$f":"FLOOR((D51-0.5)/3,1)","v":2},{"$f":"MOD(D51-1,3)","v":2}]
[null,2,"O",9]
[]
[]
[]
[null,"РазОр60х90","60х90","Размер Орас 60х90"]
[null,"РазОр60х94","60х94","Размер Орас 60х94"]
[null,"РазОр60х130","60х130","Размер Орас 60х130"]
[]
[]
[]
[null,"РЦОр60х94",280,"Розничная цена Орас 60х94"]
[null,"РЦОр60х130",320,"Розничная цена Орас 60х130"]
[null,"Сил",50,"Силикон"]
[null,"Ор60х94_Кр",50,"Крепеж"]
[null,"Ор60х94_Мон",200,"Монтаж"]
[]
[]
[null,null,null,null,null,null,null,null,"ПОДОКОННИК",null,null,"ОБНАЛИЧКА(нащельник)",null,null,"   ОТЛИВ",null,null,"  ОТКОС нар.",null,"ОТКОС внут.+нащельник"]
[null,"Тиц400","Тиц400","Размер Тициано 400мм",null,null,null,null,"мм/6м","цена п/м с монт","Розница","мм/6м","цена","Розница","мм/6м","цена","Розница","мм","цена","мм","цена"]
[null,"РБК250","РБК250","Размер РБК 250мм",null,null,1,"РЦп150",150,180,250,60,180,180,90,120,190,"60х90",350,450,"550+50"]
[null,null,null,null,null,null,2,"РЦп200",200,220,320,80,200,200,110,150,220,"90х125",410,600,"700+50"]
[null,"Монб_КН","Монб_КН","Монблан с капиносами и наличником",null,null,3,"РЦп250",250,280,380,100,250,250,130,190,260]
[null,"Монб_F","Монб_F","Монблан без капиносов с F-50 на клей \"Монтаж\"",null,null,4,"РЦп300",300,330,430,null,null,null,150,210,280,null,null,"обналичка 50р п.м"]
[null,null,null,null,null,null,5,"РЦп350",350,390,500,null,null,null,180,240,310]
[null,"Сенд_УГ","Сенд_УГ","Сендвич-панель с Углом",null,null,6,"РЦп400",400,450,570,null,null,null,200,260,330]
[null,"Сенд_F","Сенд_F","Сендвич-панель с F-ой",null,null,7,"РЦп450",450,500,620,null,null,null,220,280,350]
[null,null,null,null,null,null,8,"РЦп500",500,560,700]
[null,null,null,null,null,null,9,"РЦп550",550,600,810]
[null,"РЦТиц400",250,"Розничная цена Тициано 400мм",null,null,10,"РЦп600",600,670,920]
[null,"РЦРБК250",165,"Розничная цена РБК 250мм",null,null,11,"РЦпМюллер","Мюллер",2000,2500]
[null,"Квад",50,"Декоратив_Квадрат",null,null,12,"РЦпДанке","Данке",1500,2000]
[null,"L-ка",35,"1шт-3м",null,null,null,"РЦзП",null,30,50,null,null,null,null,null,null,"6,5м",null,"6.5м"]
[null,"Мон_ТицРБК",550,"Монтаж",null,null,null,"РЦзО",null,30,50]
[null,null,null,null,null,null,null,"МонтП",null,50]
[null,"РЦМонбл_КН",170,"Розничная цена Монблан с капиносами и наличником",null,null,null,"МонтО",null,50]
[null,"РЦМонб_Нал",100,"Розничная цена Наличника Монблан"]
[null,"РЦМонб_F",120,"Монблан без капиносов с F-50 на клей \"Монтаж\""]
[null,"РЦМонбл_КН_600",390,"Розничная цена Монблан600 с капиносами и наличником",null,null,null,null,"монтаж от 350р за конструкцию"]
[null,"РЦМонбл_КН_450",290,"Розничная цена Монблан450 с капиносами и наличником",null,null,null,null,"гребенка-70р"]
[null,"РЦМонбл_КН_300",195,"Розничная цена Монблан300 с капиносами и наличником",null,null,null,null,"ручка с ключом-350р"]
[null,"РЦМонбл_КН_150",150,"Розничная цена Монблан150 с капиносами и наличником",null,null,null,null,"заглушка подоконника-30-50"]
[null,"РЦМонбл_КН_225",170,"Розничная цена Монблан225 с капиносами и наличником",null,null,null,null,"заглушка отлива-30-50"]
[null,"РЦМонб_Нал_300",70,"Розничная цена Наличника Монблан300"]
[null,"РЦМонб_Нал_150",70,"Розничная цена Наличника Монблан150"]
[null,"РЦМонб_Нал_225",70,"Розничная цена Наличника Монблан225"]
[null,"F-ка",90,"1шт-3м"]
[null,"Уголок",90,"1шт-2,7м"]
[null,"Клей",250,"Клей \"Монтаж\""]
[null,"Клей50",50]
[null,"Мон_Монб",600,"Монтаж"]
[null,"Мон_Монб_300",600,"Монтаж"]
[null,"Мон_Монб_150",600,"Монтаж"]
[null,"Мон_Монб_225",600,"Монтаж"]
[null,"Мон_Сенд",600,"Монтаж"]
[null,"РЦСенд",450,"Розничная цена Сендвич-панели 150;200;250;300;375;450;500;500;600;750мм"]