{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Заявка","Цена МДФ кв.м.","Инструкция"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[55,5,55,7],[57,5,57,7],[59,5,59,7],[6,3,6,4],[7,3,7,4],[13,3,13,7],[12,3,12,7],[10,2,10,7],[53,5,53,7]]}
[]
[null,null,null,"Заказ№",55]
[]
[null,null,"ТОО \" Glory company\"","т/ф. ","381 9901(02,03), 381 9696, 381 9705"]
[]
[]
[null,null,"Дата составления заказа","2012-02-15",null,null,null,"Алма Мебель"]
[null,null,"Дата согласования заказа","2012-02-14"]
[]
[null,null,"Примечание:"]
[null,null,"размеры все габаритные с учетом ПВХ 1мм, либо алюминиевого профиля"]
[]
[null,null,"МДФ (цвет):","Белая полоска 18мм"]
[null,null,"Обработка торцов:","Акриловая лента 1 мм"]
[]
[]
[]
[null,"№п/п","Наименование, МДФ","высота","ширина","кол-во","площадь","длина детали"]
[null,{"$f":"IF(C19=\"\",\"\",MAX($B$18:B18)+1)","v":1},{"$f":"ЦВЕТ_МДФ","v":"Белая полоска 18мм"},200,200,1,{"$f":"IF(C19=\"\",\"\",D19*E19*F19/10^6)","v":0.04},{"$f":"IF(C19=\"\",\"\",(D19+E19)*F19/500)","v":0.8}]
[null,{"$f":"IF(C20=\"\",\"\",MAX($B$18:B19)+1)","v":""},{"$f":"IF(SUM(D20:F20)=0,\"\",ЦВЕТ_МДФ)","v":""},null,null,null,{"$f":"IF(C20=\"\",\"\",D20*E20*F20/10^6)","v":""},{"$f":"IF(C20=\"\",\"\",(D20+E20)*F20/500)","v":""}]
[null,{"$f":"IF(C21=\"\",\"\",MAX($B$18:B20)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C22=\"\",\"\",MAX($B$18:B21)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C23=\"\",\"\",MAX($B$18:B22)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C24=\"\",\"\",MAX($B$18:B23)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C25=\"\",\"\",MAX($B$18:B24)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C26=\"\",\"\",MAX($B$18:B25)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C27=\"\",\"\",MAX($B$18:B26)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C28=\"\",\"\",MAX($B$18:B27)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C29=\"\",\"\",MAX($B$18:B28)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C30=\"\",\"\",MAX($B$18:B29)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C31=\"\",\"\",MAX($B$18:B30)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C32=\"\",\"\",MAX($B$18:B31)+1)","v":""},{"$f":"IF(SUM(D32:F32)=0,\"\",ЦВЕТ_МДФ)","v":""},null,null,null,{"$f":"IF(C32=\"\",\"\",D32*E32*F32/10^6)","v":""},{"$f":"IF(C32=\"\",\"\",(D32+E32)*F32/500)","v":""}]
[null,{"$f":"IF(C33=\"\",\"\",MAX($B$18:B32)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C34=\"\",\"\",MAX($B$18:B33)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C35=\"\",\"\",MAX($B$18:B34)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C36=\"\",\"\",MAX($B$18:B35)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C37=\"\",\"\",MAX($B$18:B36)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C38=\"\",\"\",MAX($B$18:B37)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C39=\"\",\"\",MAX($B$18:B38)+1)","v":""},"",null,null,null,"",""]
[null,{"$f":"IF(C40=\"\",\"\",MAX($B$18:B39)+1)","v":""},"",null,null,null,"",""]
[null,null,"Итого:",null,null,{"$f":"SUM(F19:F40)","v":1},{"$f":"SUM(G19:G40)","v":0.04},{"$f":"SUM(H19:H40)","v":0.8}]
[]
[]
[null,"№п/п","Наименование ","кол-во","цена","стоимость"]
[null,{"$f":"IF(C45=\"\",\"\",SUBTOTAL(103,$C$44:C44))","v":1},{"$f":"D13","v":"Белая полоска 18мм"},{"$f":"G41","v":0.04},{"$f":"VLOOKUP(D13,OFFSET(МДФ,0,0,,2),2,0)","v":9000},{"$f":"D45*E45","v":360}]
[null,{"$f":"IF(C46=\"\",\"\",SUBTOTAL(103,$C$44:C45))","v":2},{"$f":"Обработка","v":"Акриловая лента 1 мм"},{"$f":"H41","v":0.8},{"$f":"VLOOKUP(Обработка,OFFSET(торцы,0,0,,2),2,0)","v":210},{"$f":"D46*E46","v":168}]
[null,{"$f":"IF(C47=\"\",\"\",SUBTOTAL(103,$C$44:C46))","v":3},"Уголки",{"$f":"F41","v":1},200,{"$f":"D47*E47","v":200}]
[null,{"$f":"IF(C48=\"\",\"\",SUBTOTAL(103,$C$44:C47))","v":3},"Сборка фасадов ",{"$f":"F41","v":1},600,{"$f":"D48*E48","v":600}]
[null,{"$f":"IF(C49=\"\",\"\",SUBTOTAL(103,$C$44:C48))","v":""}]
[null,null,"Итого к оплате:",null,null,{"$f":"SUBTOTAL(109,F45:F48)","v":528}]
[]
[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":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Цена МДФ за кв. метр ",null,null,"Цена профиля за метр "]
[]
["Наименование","цена",null,"Наименование","цена"]
["Черный 18мм",7400,null,"Акриловая лента 1 мм",210]
["Белый 18мм",7400,null,"Алюминиевый профиль серебро",950]
["Бежевый 18мм",7400,null,"Алюминиевый профиль золото",1190]
["Фиолетовый 18мм",7400]
["Светло-розовый 18мм",7400]
["Черный перламутр 18 мм",8600]
["Белый перламутр 18 мм",8600]
["Оранжевый перламутр 18мм",8600]
["Светло-розовый 18мм",8600,null,"МДФ","=СМЕЩ('Цена МДФ кв.м.'!$A$6;0;0;СЧЁТЗ('Цена МДФ кв.м.'!$A$6:$A$105);1)"]
["Элеганс черный 18мм",9000,null,"Обработка","=Заявка!$D$14"]
["Элеганс белый 18мм",9000,null,"Прятать","=Заявка!$42:$43"]
["Элеганс красный 18мм",9000,null,"торцы","='Цена МДФ кв.м.'!$D$6:$D$8"]
["Fresh - А 18мм",9000]
["Fresh - В 18мм",9000]
["Fresh - C  18мм",9000]
["Волна А белая 18мм",9000]
["Волна В бежевая18мм",9000]
["Волна С черная  18мм",9000]
["Черная полоска 18мм",9000]
["Белая полоска 18мм",9000]
["Роза 18мм",9000]
["Эбен 18мм",9000]
["Ясень 18мм",9000]
["Shine-1-белый 18мм",9900]
["Shine-1-красный 18мм",9900]
["Shine-2- черный 18мм",9900]

{"sheet":"Инструкция","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[1,"Для составления Заказа необходимо заполнить только зеленые поля. "]
[2,"При заполнении полей \"МДФ (цвет)\" и \"Обработка торцов\" необходимые данные выбираются\nиз выпадающего списка при нажатии стрелочки справа от ячейки."]
[3,"В табличной части заполняются необходимые размеры и количество фасадов, все остальное\nвыведется автоматически."]