{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Заявка-зали"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Заявка-зали","index":0,"n_rows":88,"n_cols":9,"rows_kept":88,"merged":[[0,4,0,6],[0,7,0,8],[1,1,1,2],[1,5,1,6],[1,7,1,8],[2,1,2,2],[2,5,2,6],[2,7,2,8],[3,4,3,6],[4,1,4,2],[4,4,4,5],[5,1,5,2],[5,3,5,8],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[23,3,23,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[31,3,31,6],[32,3,32,5],[33,3,33,5],[34,3,34,5],[39,1,39,3],[40,5,40,6],[41,7,41,8],[43,1,43,2],[45,1,45,3],[47,1,47,2],[53,1,53,2],[53,6,53,8],[54,1,54,2],[57,3,57,7],[58,3,58,7],[61,3,61,5],[62,3,62,5],[63,3,63,5],[64,3,64,5],[65,3,65,5],[66,3,66,5],[67,3,67,5],[68,3,68,5],[69,3,69,5],[70,3,70,5],[71,3,71,5],[72,3,72,5],[73,3,73,5],[74,3,74,5],[75,3,75,5],[76,3,76,5],[77,3,77,5],[78,3,78,5],[79,1,79,3],[80,1,80,3],[81,1,81,3]]}
[{"$nulls":3},"ПОРЪЧКА за ОРГАНИЗАЦИОННИ УСЛУГИ ",{"$f":"NOW()","v":"2017-05-16T15:53:08.530"}]
[null,"Фирма",null,null,"лице:",null,null,"ПЛАТЕНО МЕРОПРИЯТИЕ "]
[null,"е-mail:",null,null,"тел."]
[null,"   Организиране на:"]
[null,"Дата:",null,null,"час (от-до):"]
[null,"Тема:"]
[null,null,"№","Вид услуга:",null,null,"Ед. цена","време за ползване","Цена с ДДС"]
[false,null,"1.","Ползване на зали:",null,null,"лева/час","часове","лева"]
[false,null," 1.1","Заседателна зала ет.1 - до 100 места (тип \"киносалон\")",null,null,200,null,{"$f":"IF($A$36>1,0,(IF(A9,IF(H9>0,G9*H9,G9),G9*H9)))","v":0}]
[false,null," 1.2","Заседателна зала ет.1 - до 40 места (тип \"учебна зала\")",null,null,150,null,{"$f":"IF($A$36>1,0,(IF(A10,IF(H10>0,G10*H10,G10),G10*H10)))","v":0}]
[false,null," 1.3","Заседателна зала ет.1 - до 50 места (тип \"кръгла маса\")",null,null,100,null,0]
[false,null," 1.4","Зала ет.7 - 100 места",null,null,100,null,0]
[false,null," 1.5","Зала ет.7 -  80 места",null,null,80,null,0]
[false,null," 1.6","Малка зала ет.1 - 12 места",null,null,50,null,0]
[false,null," 1.7","Ползване на фоайе (ет.1) за коктейл, кетъринг и др.",null,null,50,null,0]
[{"$nulls":3},"общо:",{"$nulls":4},{"$f":"SUM(I9:I15)","v":0}]
[null,null,"2.","Техн. обслужване:(маркира се карето на съотв. ред)",null,null,"лева",null,"лева"]
[false,null," 2.1","Мултимедия + екран",null,null,50,null,{"$f":"IF($A$36>1,0,(IF(A18,G18,0)))","v":0}]
[false,null," 2.2","Плазмен екран (размер 60\")",null,null,30,null,{"$f":"IF($A$36>1,0,(IF(A19,G19,0)))","v":0}]
[false,null," 2.3","Аудиозапис ",null,null,20,null,0]
[{"$nulls":3},"общо:",{"$nulls":4},{"$f":"SUM(I18:I20)","v":0}]
[null,null,"3.","PR услуги: (маркира се карето на съотв. ред)",null,null,"лева","бр.","лева"]
[false,null," 3.1","Уведомяване на медиите",null,null,70,null,{"$f":"IF($A$36>1,0,(IF(A23,IF(H23>0,G23*H23,G23),G23*H23)))","v":0}]
[false,null," 3.2","Разпространение на пресрелийз",null,null,60,null,{"$f":"IF($A$36>1,0,(IF(A24,IF(H24>0,G24*H24,G24),G24*H24)))","v":0}]
[false,null," 3.3","Водещ (на час)",null,null,50,null,0]
[false,null," 3.4","Публикация в сайта на БСК",null,null,60,null,0]
[false,null," 3.5","Мониторинг на ежедневници",null,null,50,null,0]
[false,null," 3.6","Слайд на екрана във фоайето",null,null,30,null,0]
[false,null," 3.7","Снимки с дигитален фотоапарат",null,null,40,null,0]
[false,null," 3.8","Стенографски запис (на стр.)",null,null,"7 / стр. ",null,{"$f":"IF($A$36>1,0,(IF(A30,IF(H30>0,7*H30,7),7*H30)))","v":0}]
[{"$nulls":3},"общо:",{"$nulls":4},{"$f":"SUM(I23:I29)","v":0}]
[0,null,"4.","ОТСТЪПКИ: (маркира се в жълтото каре горе в дясно)",{"$nulls":4},"лева"]
[true,null," 4.1","За членове на БСК (20%)",{"$nulls":4},{"$f":"IF(A36>1,0,IF(A32=1,(I16+I21+I31)*(-0.2),0))","v":0}]
[false,null," 4.2","За служители на БСК (50%)",{"$nulls":4},{"$f":"IF(A36>1,0,IF(A32=2,(I16+I21+I31)*(-0.5),0))","v":0}]
[null,null,"5.","Копирни услуги (на стр.)",null,null,{"v":0.15,"d":"0.15 лв"},null,{"$f":"G35*H35","v":{"v":0,"d":"0.00 лв"}}]
[0,null,null,"Общо услуги:",{"$nulls":4},{"$f":"IF(A36>1,0,I16+I21+I31+I33+I34+I35)","v":{"v":0,"d":"0.00 лв"}}]
[null,null,"6.","Сервиз (Съгласно Приложение 1)",{"$nulls":4},{"$f":"I82","v":{"v":0,"d":"0.00 лв"}}]
[{"$nulls":3},"Общо (сервиз + зала) с ДДС:",{"$nulls":4},{"$f":"I36+I37","v":{"v":0,"d":"0.00 лв"}}]
[]
[null,"Фирмени данни на КЛИЕНТА:"]
[null,"Фирма: ",null,"……………………………………………………",null,"  Подпис на клиента: "]
[null,"Адрес:",null,"……………………………………………………",{"$nulls":3}," ………………………."]
[null,"ЕИК:",null,"……………………………………………………"]
[null,"МОЛ:",null,"………………………………………………………….",null,"  ОДОБРИЛ:  ……....………….……..…."]
[{"$nulls":7},"(Иван Костов)"]
[null,"Фирмени данни на ИЗПЪЛНИТЕЛЯ:"]
[null,"Фирма:",null,"Българска стопанска камара",null,"  Координатор зали:  ………...……….…… "]
[null,"Адрес:",null,"София 1000, ул. \"Алабин\" 16-20",{"$nulls":3},"(Анета Йорданова)"]
[{"$nulls":3},"БАНКА ДСК ЕАД София"]
[{"$nulls":3},"IBAN: BG61 STSA 93 0000 2160 9234",null,"  Координатор техника: ……….…...…… "]
[{"$nulls":3},"BIC: STSABGSF",{"$nulls":3},"(Рашко Рашков)"]
[]
[0,"Плащане:",{"$nulls":3},"  Организатор: ……........………...……."]
[null,"дата:",null,"....................................................",null,null,"(Магдалена Богданлийска)"]
[null,"касиер:",null,"...................................................."]
[]
[]
[{"$nulls":3},"ПРИЛОЖЕНИЕ 1"]
[{"$nulls":3},"КЪМ ПОРЪЧКА ЗА ОРГАНИЗАЦИОННИ УСЛУГИ"]
[]
[]
[null,null,"№ по ред","артикул ",null,null,"ед.цена","кол.","Цена"]
[null,null,1,"кафе",null,null,{"v":0.6,"d":"0.60 лв"},null,{"$f":"G63*H63","v":{"v":0,"d":"0.00 лв"}}]
[null,null,2,"кафе",null,null,{"v":1,"d":"1.00 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,3,"мин.вода - 0,5 л",null,null,{"v":0.7,"d":"0.70 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,4,"мин.вода - 1,5 л",null,null,{"v":1.2,"d":"1.20 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,5,"безалк.напитки - 0,5 л.",null,null,{"v":1.5,"d":"1.50 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,6,"безалк.напитки - 2 л.",null,null,{"v":3,"d":"3.00 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,7,"сладкиши (кг)",null,null,{"v":17,"d":"17.00 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,8,"соленки (кг)",null,null,{"v":17,"d":"17.00 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,9,"шоколадови бонбони (бр.кутии)",{"$nulls":4},{"v":0,"d":"0.00 лв"}]
[null,null,10,"сандвичи - \"Бъргър\" (бр.)",null,null,{"v":2.7,"d":"2.70 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,11,"сандвичи (бр.)",null,null,{"v":2.2,"d":"2.20 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,12,"чай с мед",null,null,{"v":0.5,"d":"0.50 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,13,"сметана за кафе",null,null,{"v":0.2,"d":"0.20 лв"},null,{"v":0,"d":"0.00 лв"}]
[null,null,14,{"$nulls":5},{"v":0,"d":"0.00 лв"}]
[null,null,15,{"$nulls":5},{"v":0,"d":"0.00 лв"}]
[null,null,16,{"$nulls":5},{"v":0,"d":"0.00 лв"}]
[null,null,17,"Кетъринг (по оферта)",{"$nulls":4},{"$f":"G79*H79","v":{"v":0,"d":"0.00 лв"}}]
[null,"Общо артикули:",{"$nulls":6},{"$f":"SUM(I63:I79)","v":{"v":0,"d":"0.00 лв"}}]
[null,"Сервизно обслужване (20%)",{"$nulls":6},{"$f":"I80*20%","v":{"v":0,"d":"0.00 лв"}}]
[null,"ОБЩО:",{"$nulls":6},{"$f":"I80+I81","v":{"v":0,"d":"0.00 лв"}}]
[]
[]
[]
[]
[{"$nulls":5},"Подпис на клиента:"]
[{"$nulls":7},"……………………….."]