{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Инструкция","Рабочий лист","Прайс","Провода","Маркировка","t","b"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["№","Включены следующие производители оборудования","Дата обновления\nбазы номенклатуры","Дата обновления\nбазы цены"]
[1,"RITTAL (2015.01.13 Smart КП январь_12012015)"]
[2,"EATON (EATON Прайс-лист 01012015 партнер)"]
[3,"WAGO (Net Price 2015.01.16_Avtomatika Privodnaya Technika_for customer)"]
[4,"WIENTEK (Weintek_13_08_2014_y e)"]
[5,"ABB (двигатели/привода) (АББ Прайс-лист_январь 2015)"]
[6,"ABB (низковольтное оборудование) (АББ Прайс-лист_январь 2015)"]
[7,"SIEMENS"]
[8,"ProVento"]
[9,"Pfannenberg (ПФАНЕНБЕРГ new price_010314 v1)"]
[10,"Другие произоводители:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Важно, формат ячейки артикула должен быть числовым"]

{"sheet":"Рабочий лист","index":1,"n_rows":78,"n_cols":22,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,3,78,3],[0,16,0,17],[2,10,2,11],[0,7,0,8],[0,9,0,10],[1,9,1,10],[0,1,0,6],[77,7,78,7],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,5,3,5],[1,6,3,6],[55,21,74,21],[56,11,60,11],[1,4,3,4],[1,13,3,13],[2,17,3,17],[2,9,3,9],[2,16,3,16],[1,16,1,17]]}
[null,null,null,null,null,null,null,"Розничная цена без НДС",null,"Оборудование минус склад (без НДС) =",null,{"$f":"L2-SUM(V6:V54)","v":5242.95},{"$f":"$M$2-SUM(K6:K54)","v":433068.91000000003},"Запас на \nусушку, %",10,{"$f":"(M2+M1)*O1/100","v":86613.782000000007},"Работы для клиента =",null,{"$f":"SUM(S62:S77)","v":0}]
[null,"№ \nп/п","Наименование","Артикул","Производитель","Заказ, шт","Склад, шт","EUR/USD",1.148819,"Цена оборудование\n(без НДС) =",null,{"$f":"SUM(U6:U54)","v":5242.95},{"$f":"SUM(M5:M56)","v":433068.91000000003},"ТЗР + запас,\nсуммарный процент\n (распределение в оборудование)",25,{"$f":"M2*(O2)/100","v":108267.22749999999},"Оборуд. для клиента =",null,{"$f":"S4-S1","v":584641.44000000006}]
[null,null,null,null,null,null,null,"EURO","РУБЛЬ","Скидка,   %","Цена с НДС (18%), \nскидкой, руб",null,"Стоимость\nНАША, \nв рублях с НДС",null,"Оборуд.\n\nРентаб. , %\n\nРаботы","Итоговый\nкоэффициент, \n %","Цена\nклиент,\nруб без НДС,\nза шт.","Цена\nклиент,\nруб с НДС,\nза шт.","Стоимость\nКЛИЕНТА,\nв рублях с НДС"]
[null,null,null,null,null,null,null,70,null,null,"Склад","Закуп, шт",{"$f":"SUM(M5:M79)","v":433068.91000000003},null,25,{"$f":"M1*O4/100","v":108267.22749999999},null,null,{"$f":"SUM(S5:S77)","v":584641.44000000006}]
[null,1,"Нулевая поставка",null,null,1,null,100,1,null,null,1.18,{"$f":"L5*F5","v":1.18},{"$f":"((($D$55*1.18+100)/100)*(($D$56*1.18+100)/100)-1)*100","v":0},{"$f":"$O$2","v":25},{"$f":"O5+N5+$O$1","v":35},{"$f":"CEILING(((100+P5)/100*I5)*((100-J5)/100),0.01)","v":1.35},{"$f":"CEILING(Q5*1.18,0.01)","v":1.6},{"$f":"R5*(F5-F5)","v":0}]
[null,{"$f":"B5+1","v":2},{"$f":"INDEX(Прайс!D:D,MATCH(D6,Прайс!B:B,0))","v":"Непредвиденное"},"Непредвиденное",{"$f":"INDEX(Прайс!$E:$E,MATCH($D6,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D6,Прайс!B:B,0))","v":100},{"$f":"H6*$H$4","v":7000},{"$f":"INDEX(Прайс!I:I,MATCH(D6,Прайс!B:B,0))","v":0},{"$f":"CEILING(CEILING($H6*$H$4*(100-$J6)/100,0.01)*1.18,0.01)*$G6","v":0},{"$f":"CEILING(CEILING(I6*(100-J6)/100,0.01)*1.18,0.01)","v":8260},{"$f":"L6*F6","v":0},0,25,{"$f":"O6+N6+$O$1","v":35},{"$f":"CEILING(((100+P6)/100*I6)*((100-J6)/100),0.01)","v":9450},{"$f":"CEILING(Q6*1.18,0.01)","v":11151},{"$f":"R6*F6","v":0},null,{"$f":"F6*H6*CEILING((100-J6)/100,0.01)","v":0},{"$f":"G6*H6*CEILING((100-J6)/100,0.01)","v":0}]
[null,{"$f":"B6+1","v":3},{"$f":"INDEX(Прайс!D:D,MATCH(D7,Прайс!B:B,0))","v":"SIMATIC S7-1200, КОМПАКТНОЕ ЦПУ CPU 1214C DC/DC/DC, ВСТРОЕННЫЕ ВХОДЫ/ВЫХОДЫ: 14 DI =24 В; 10 DO =24 В; 2 AI =0 - 10 В, БЛОК ПИТАНИЯ: =20.4 - 28.8 В, ПАМЯТЬ ПРОГРАММЫ/ДАННЫХ: 75 КБ"},"6ES7214-1AG40-0XB0",{"$f":"INDEX(Прайс!$E:$E,MATCH($D7,Прайс!$B:$B,0))","v":"Siemens"},1,null,{"$f":"INDEX(Прайс!H:H,MATCH(D7,Прайс!B:B,0))","v":234.29},16400.3,{"$f":"INDEX(Прайс!I:I,MATCH(D7,Прайс!B:B,0))","v":0},0,19352.36,19352.36,0,25,35,22140.41,26125.690000000002,26125.690000000002,null,{"$f":"F7*H7*CEILING((100-J7)/100,0.01)","v":234.29},{"$f":"G7*H7*CEILING((100-J7)/100,0.01)","v":0}]
[null,4,{"$f":"INDEX(Прайс!D:D,MATCH(D8,Прайс!B:B,0))","v":"SIMATIC S7-1200, МОДУЛЬ ДИСКРЕТНОГО ВВОДА SM 1221, 8DI, =24 В, ВХОДЫ SINK/SOURCE"},"6ES7221-1BF32-0XB0",{"$f":"INDEX(Прайс!$E:$E,MATCH($D8,Прайс!$B:$B,0))","v":"Siemens"},1,null,{"$f":"INDEX(Прайс!H:H,MATCH(D8,Прайс!B:B,0))","v":67.739999999999995},4741.7999999999993,{"$f":"INDEX(Прайс!I:I,MATCH(D8,Прайс!B:B,0))","v":0},0,5595.33,5595.33,0,25,35,6401.43,7553.6900000000005,7553.6900000000005,null,67.739999999999995,0]
[null,5,{"$f":"INDEX(Прайс!D:D,MATCH(D9,Прайс!B:B,0))","v":"SIMATIC S7-1200, КОММУНИКАЦИОННЫЙ МОДУЛЬ CM 1241, RS422/485, 9-ПОЛЮСНЫЙ РАЗЪЁМ SUB D (ВИЛКА), СВОБОДНО-ПРОГРАММИРУЕМЫЙ ПОРТ С ПОДДЕРЖКОЙ ТЕЛЕГРАММ"},"6ES7241-1CH32-0XB0",{"$f":"INDEX(Прайс!$E:$E,MATCH($D9,Прайс!$B:$B,0))","v":"Siemens"},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D9,Прайс!B:B,0))","v":79.349999999999994},5554.5,{"$f":"INDEX(Прайс!I:I,MATCH(D9,Прайс!B:B,0))","v":0},0,6554.31,0,0,25,35,7498.58,8848.33,0,null,0,0]
[null,6,{"$f":"INDEX(Прайс!D:D,MATCH(D10,Прайс!B:B,0))","v":"ВАКУУМНЫЙ КОНТАКТОР, 250КВТ/400V/AC-3, AC/DC-НОМИНАЛЬНОЕ ПИТАЮЩЕЕ НАПРЯЖЕНИЕ УПРАВЛЕНИЯ 220-240В UCБЛОК-КОНТАКТЫ 2НО+2НЗ 3-Х ПОЛЮСНЫЙ, ТИПОРАЗМЕР S12 ШИННОЕ ПРИСОЕДИНЕНИЕ ПРИВОД: ОБЫЧНЫЙ"},"3RT1276-6AP36",{"$f":"INDEX(Прайс!$E:$E,MATCH($D10,Прайс!$B:$B,0))","v":"Siemens"},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D10,Прайс!B:B,0))","v":1269.07},88834.9,{"$f":"INDEX(Прайс!I:I,MATCH(D10,Прайс!B:B,0))","v":0},0,104825.19,0,0,25,35,119927.12,141514.01,0,null,0,0]
[null,7,{"$f":"INDEX(Прайс!D:D,MATCH(D11,Прайс!B:B,0))","v":"КОНТАКТОР 250КВТ/400V/AC-3, AC/DC-НОМИНАЛЬНОЕ ПИТАЮЩЕЕ НАПРЯЖЕНИЕ УПРАВЛЕНИЯ 220-240В UCБЛОК-КОНТАКТЫ 2НО+2НЗ 3-Х ПОЛЮСНЫЙ, ТИПОРАЗМЕР S12 ШИННОЕ ПРИСОЕДИНЕНИЕ ПРИВОД: ОБЫЧНЫЙ"},"3RT1076-6AP36",{"$f":"INDEX(Прайс!$E:$E,MATCH($D11,Прайс!$B:$B,0))","v":"Siemens"},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D11,Прайс!B:B,0))","v":916.97},{"$f":"H11*$H$4","v":64187.9},{"$f":"INDEX(Прайс!I:I,MATCH(D11,Прайс!B:B,0))","v":0},0,{"$f":"CEILING(CEILING(I11*(100-J11)/100,0.01)*1.18,0.01)","v":75741.73},0,0,25,35,86653.67,102251.34,{"$f":"R11*F11","v":0},null,0,0]
[null,8,{"$f":"INDEX(Прайс!D:D,MATCH(D12,Прайс!B:B,0))","v":"АВТОМАТИЧЕСКИЙ ВЫКЛЮЧАТЕЛЬ 3VT1 СТАНДАРТНАЯ ОТКЛ. СПОСОБНОСТЬ ICU=25KA, 415V AC 3-ПОЛ.; STARTER COMBINATION РАСЦЕПИТЕЛЬ TM, LIN IN= 63A RATED CURRENT II= 315... 630A, SHORT-CIRCUIT PROTECTION W/O AUXILIARY TRIP UNIT W/O AUXILIARY/ALARM SWITCH WITHOUT AUXIL"},"3VT1706-2DB36-0AA0",{"$f":"INDEX(Прайс!$E:$E,MATCH($D12,Прайс!$B:$B,0))","v":"Siemens"},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D12,Прайс!B:B,0))","v":53.67},{"$f":"H12*$H$4","v":3756.9},{"$f":"INDEX(Прайс!I:I,MATCH(D12,Прайс!B:B,0))","v":0},0,{"$f":"CEILING(CEILING(I12*(100-J12)/100,0.01)*1.18,0.01)","v":4433.1500000000005},0,0,25,35,5071.82,5984.75,0,null,0,0]
[null,9,{"$f":"INDEX(Прайс!D:D,MATCH(D13,Прайс!B:B,0))","v":"ВЫКЛЮЧАТЕЛЬ-РАЗЪЕДИНИТЕЛЬ 1250A, ТР.5, 3-ПОЛ ФРОНТ.УПР. СЛЕВА БАЗ.БЛОК БЕЗ РУЧКИ ПЛОСКИЕ КЛЕММЫ"},"3KD5230-0RE10-0",{"$f":"INDEX(Прайс!$E:$E,MATCH($D13,Прайс!$B:$B,0))","v":"Siemens"},6,null,{"$f":"INDEX(Прайс!H:H,MATCH(D13,Прайс!B:B,0))","v":743.12},52018.400000000001,{"$f":"INDEX(Прайс!I:I,MATCH(D13,Прайс!B:B,0))","v":0},0,61381.72,368290.32,0,25,35,70224.84,82865.320000000007,497191.92000000004,null,4458.72,0]
[null,10,{"$f":"INDEX(Прайс!D:D,MATCH(D14,Прайс!B:B,0))","v":"РАСЦЕПИТЕЛЬ МАКС.ТОКА ЭЛЕКТР. VT630 3-ПОЛ.,MOTOR/TRANSF. PROTECT. ETU MPS, LI IR= 250... 630A, OVERLOAD PROTECTION IRM= 3... 9KA SHORT-CIRCUIT PROTECTION, SCREW TERMINAL CONNECTIONS IN SCOPE OF SUPPLY OF SWITCHING UNIT"},"3VT9363-6AS00",{"$f":"INDEX(Прайс!$E:$E,MATCH($D14,Прайс!$B:$B,0))","v":"Siemens"},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D14,Прайс!B:B,0))","v":300.33},{"$f":"H14*$H$4","v":21023.1},{"$f":"INDEX(Прайс!I:I,MATCH(D14,Прайс!B:B,0))","v":0},0,{"$f":"CEILING(CEILING(I14*(100-J14)/100,0.01)*1.18,0.01)","v":24807.260000000002},{"$f":"L14*F14","v":0},0,25,{"$f":"O14+N14+$O$1","v":35},{"$f":"CEILING(((100+P14)/100*I14)*((100-J14)/100),0.01)","v":28381.190000000002},{"$f":"CEILING(Q14*1.18,0.01)","v":33489.81},{"$f":"R14*F14","v":0},null,0,0]
[null,11,{"$f":"INDEX(Прайс!D:D,MATCH(D15,Прайс!B:B,0))","v":"АВТОМАТИЧЕСКИЙ ВЫКЛЮЧАТЕЛЬ 3VT3 СТАНДАРТНАЯ ОТКЛ. СПОСОБНОСТЬ ICU=36KA, 415V AC 3-ПОЛ.; АВТОМАТИЧЕСКИЙ ВЫКЛЮЧАТЕЛЬ W/O ELECTRONIC TRIP UNIT W/O AUXILIARY TRIP UNIT W/O AUXILIARY/ALARM SWITCH WITHOUT AUXILIARY RELEASE WITHOUT AUXILIARY/ALARM SWITCH OHNE HIL"},"3VT3763-2AA36-0AA0",{"$f":"INDEX(Прайс!$E:$E,MATCH($D15,Прайс!$B:$B,0))","v":"Siemens"},2,null,{"$f":"INDEX(Прайс!H:H,MATCH(D15,Прайс!B:B,0))","v":241.1},16877,{"$f":"INDEX(Прайс!I:I,MATCH(D15,Прайс!B:B,0))","v":0},0,19914.86,39829.72,0,25,35,22783.95,26885.07,53770.14,null,482.2,0]
[null,12,{"$f":"INDEX(Прайс!D:D,MATCH(D16,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D16,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D16,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D16,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,13,{"$f":"INDEX(Прайс!D:D,MATCH(D17,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D17,Прайс!$B:$B,0))","v":0},3,null,{"$f":"INDEX(Прайс!H:H,MATCH(D17,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D17,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,14,{"$f":"INDEX(Прайс!D:D,MATCH(D18,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D18,Прайс!$B:$B,0))","v":0},2,null,{"$f":"INDEX(Прайс!H:H,MATCH(D18,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D18,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,15,{"$f":"INDEX(Прайс!D:D,MATCH(D19,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D19,Прайс!$B:$B,0))","v":0},2,null,{"$f":"INDEX(Прайс!H:H,MATCH(D19,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D19,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,16,{"$f":"INDEX(Прайс!D:D,MATCH(D20,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D20,Прайс!$B:$B,0))","v":0},3,null,{"$f":"INDEX(Прайс!H:H,MATCH(D20,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D20,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,17,{"$f":"INDEX(Прайс!D:D,MATCH(D21,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D21,Прайс!$B:$B,0))","v":0},3,null,{"$f":"INDEX(Прайс!H:H,MATCH(D21,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D21,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,18,{"$f":"INDEX(Прайс!D:D,MATCH(D22,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D22,Прайс!$B:$B,0))","v":0},3,null,{"$f":"INDEX(Прайс!H:H,MATCH(D22,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D22,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,19,{"$f":"INDEX(Прайс!D:D,MATCH(D23,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D23,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D23,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D23,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,20,{"$f":"INDEX(Прайс!D:D,MATCH(D24,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D24,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D24,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D24,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,21,{"$f":"INDEX(Прайс!D:D,MATCH(D25,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D25,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D25,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D25,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,22,{"$f":"INDEX(Прайс!D:D,MATCH(D26,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D26,Прайс!$B:$B,0))","v":0},1,null,{"$f":"INDEX(Прайс!H:H,MATCH(D26,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D26,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,23,{"$f":"INDEX(Прайс!D:D,MATCH(D27,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D27,Прайс!$B:$B,0))","v":0},1,null,{"$f":"INDEX(Прайс!H:H,MATCH(D27,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D27,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,24,{"$f":"INDEX(Прайс!D:D,MATCH(D28,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D28,Прайс!$B:$B,0))","v":0},1,null,{"$f":"INDEX(Прайс!H:H,MATCH(D28,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D28,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,25,{"$f":"INDEX(Прайс!D:D,MATCH(D29,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D29,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D29,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D29,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,26,{"$f":"INDEX(Прайс!D:D,MATCH(D30,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D30,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D30,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D30,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,27,{"$f":"INDEX(Прайс!D:D,MATCH(D31,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D31,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D31,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D31,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,28,{"$f":"INDEX(Прайс!D:D,MATCH(D32,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D32,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D32,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D32,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,29,{"$f":"INDEX(Прайс!D:D,MATCH(D33,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D33,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D33,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D33,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,30,{"$f":"INDEX(Прайс!D:D,MATCH(D34,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D34,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D34,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D34,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,31,{"$f":"INDEX(Прайс!D:D,MATCH(D35,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D35,Прайс!$B:$B,0))","v":0},1,null,{"$f":"INDEX(Прайс!H:H,MATCH(D35,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D35,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,32,{"$f":"INDEX(Прайс!D:D,MATCH(D36,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D36,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D36,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D36,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,33,{"$f":"INDEX(Прайс!D:D,MATCH(D37,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D37,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D37,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D37,Прайс!B:B,0))","v":0},0,0,0,{"$f":"((($D$55*1.18+100)/100)*(($D$56*1.18+100)/100)-1)*100","v":0},25,35,0,0,0,null,0,0]
[null,34,{"$f":"INDEX(Прайс!D:D,MATCH(D38,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D38,Прайс!$B:$B,0))","v":0},3,null,{"$f":"INDEX(Прайс!H:H,MATCH(D38,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D38,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,35,{"$f":"INDEX(Прайс!D:D,MATCH(D39,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D39,Прайс!$B:$B,0))","v":0},3,null,{"$f":"INDEX(Прайс!H:H,MATCH(D39,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D39,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,36,{"$f":"INDEX(Прайс!D:D,MATCH(D40,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D40,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D40,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D40,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,37,{"$f":"INDEX(Прайс!D:D,MATCH(D41,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D41,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D41,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D41,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,38,{"$f":"INDEX(Прайс!D:D,MATCH(D42,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D42,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D42,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D42,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,39,{"$f":"INDEX(Прайс!D:D,MATCH(D43,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D43,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D43,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D43,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,40,{"$f":"INDEX(Прайс!D:D,MATCH(D44,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D44,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D44,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D44,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,41,{"$f":"INDEX(Прайс!D:D,MATCH(D45,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D45,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D45,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D45,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,42,{"$f":"INDEX(Прайс!D:D,MATCH(D46,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D46,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D46,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D46,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,43,{"$f":"INDEX(Прайс!D:D,MATCH(D47,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D47,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D47,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D47,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,44,{"$f":"INDEX(Прайс!D:D,MATCH(D48,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D48,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D48,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D48,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,45,{"$f":"INDEX(Прайс!D:D,MATCH(D49,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D49,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D49,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D49,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,46,{"$f":"INDEX(Прайс!D:D,MATCH(D50,Прайс!B:B,0))","v":0},null,{"$f":"INDEX(Прайс!$E:$E,MATCH($D50,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D50,Прайс!B:B,0))","v":0},0,{"$f":"INDEX(Прайс!I:I,MATCH(D50,Прайс!B:B,0))","v":0},0,0,0,0,25,35,0,0,0,null,0,0]
[null,47,{"$f":"INDEX(Прайс!D:D,MATCH(D51,Прайс!B:B,0))","v":"Маркировка   - 1шт./ "},"Маркировка",{"$f":"INDEX(Прайс!$E:$E,MATCH($D51,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D51,Прайс!B:B,0))","v":100},7000,{"$f":"INDEX(Прайс!I:I,MATCH(D51,Прайс!B:B,0))","v":0},0,8260,0,0,25,35,9450,11151,0,null,0,0]
[null,48,{"$f":"INDEX(Прайс!D:D,MATCH(D52,Прайс!B:B,0))","v":"Провода неопределенны   - 1м/ "},"Провода",{"$f":"INDEX(Прайс!$E:$E,MATCH($D52,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D52,Прайс!B:B,0))","v":100},7000,{"$f":"INDEX(Прайс!I:I,MATCH(D52,Прайс!B:B,0))","v":0},0,8260,0,0,25,35,9450,11151,0,null,0,0]
[null,null,{"$f":"INDEX(Прайс!D:D,MATCH(D53,Прайс!B:B,0))","v":"Монтажный материал"},"Монтаж",{"$f":"INDEX(Прайс!$E:$E,MATCH($D53,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D53,Прайс!B:B,0))","v":100},{"$f":"H53*$H$4","v":7000},{"$f":"INDEX(Прайс!I:I,MATCH(D53,Прайс!B:B,0))","v":0},0,{"$f":"CEILING(CEILING(I53*(100-J53)/100,0.01)*1.18,0.01)","v":8260},{"$f":"L53*F53","v":0},0,25,{"$f":"O53+N53+$O$1","v":35},{"$f":"CEILING(((100+P53)/100*I53)*((100-J53)/100),0.01)","v":9450},{"$f":"CEILING(Q53*1.18,0.01)","v":11151},{"$f":"R53*F53","v":0},null,0,0]
[null,{"$f":"B52+1","v":49},{"$f":"INDEX(Прайс!D:D,MATCH(D54,Прайс!B:B,0))","v":"Шильдики"},"Шильдики",{"$f":"INDEX(Прайс!$E:$E,MATCH($D54,Прайс!$B:$B,0))","v":0},null,null,{"$f":"INDEX(Прайс!H:H,MATCH(D54,Прайс!B:B,0))","v":100},7000,{"$f":"INDEX(Прайс!I:I,MATCH(D54,Прайс!B:B,0))","v":0},0,8260,0,0,25,35,9450,11151,0,null,0,0]
[null,50,"Запас, %",0,null,null,null,null,null,null,null,null,{"$f":"CEILING(CEILING(SUM(M5:M54)*D55/100,0.01)*1.18,0.01)","v":0}]
[null,51,"Остальное, %",0,null,null,null,null,null,null,null,null,{"$f":"CEILING(CEILING(SUM(M5:M55)*D56/100,0.01)*1.18,0.01)","v":0}]
[null,52,"Сборочные работы  ( при распределении в стоимость компонентов)",null,null,null,null,5000,{"$f":"D57*H57","v":0},null,null,{"$f":"SUM(I57:I61)","v":0}]
[null,53,"Пачка бумаги ( для комплекта документации)  + папка",null,null,null,null,1500,{"$f":"H58*D58","v":0},null,null,null,null,{"$f":"SUM(M5:M55)","v":433068.91000000003}]
[null,54,"ТЗР ( транспортно-заготовительные расходы)",null,null,null,null,5000,{"$f":"H59*D59","v":0},null,null,null,null,{"$f":"L57/N58","v":0}]
[null,55,"Прокатило 1",null,null,null,null,30000,{"$f":"H60*D60","v":0}]
[null,56,"Прокатило 2",null,null,null,null,15000,{"$f":"H61*D61","v":0}]
[null,57,"Разработка КП",null,null,null,null,null,6800,null,null,{"$f":"CEILING(I62*1.18*(100-J62)/100,0.01)","v":8024},{"$f":"CEILING(L62*D62,0.01)","v":0},null,null,null,{"$f":"CEILING(((100+P62)/100*I62)*((100-J62)/100)*((100+$O$1+$O$4)/100),0.01)","v":9180},{"$f":"CEILING(Q62*1.18,0.01)","v":10832.4},{"$f":"R62*D62","v":0},null,{"$f":"S62+S64+S66+S65+S70+S74","v":0}]
[null,58,"Разработка ТЗ",null,null,null,null,null,6800,null,null,{"$f":"CEILING(I63*1.18*(100-J63)/100,0.01)","v":8024},{"$f":"CEILING(L63*D63,0.01)","v":0},null,null,null,{"$f":"CEILING(((100+P63)/100*I63)*((100-J63)/100)*((100+$O$1+$O$4)/100),0.01)","v":9180},{"$f":"CEILING(Q63*1.18,0.01)","v":10832.4},{"$f":"R63*D63","v":0}]
[null,59,"Разработка технической документации",null,null,null,null,null,6800,null,null,{"$f":"CEILING(I64*1.18*(100-J64)/100,0.01)","v":8024},{"$f":"CEILING(L64*D64,0.01)","v":0},null,null,null,{"$f":"CEILING(((100+P64)/100*I64)*((100-J64)/100)*((100+$O$1+$O$4)/100),0.01)","v":9180},{"$f":"CEILING(Q64*1.18,0.01)","v":10832.4},{"$f":"R64*D64","v":0}]
[null,60,"Разработка программного обеспечения",null,null,null,null,null,6800,null,null,{"$f":"CEILING(I65*1.18*(100-J65)/100,0.01)","v":8024},{"$f":"CEILING(L65*D65,0.01)","v":0},null,null,null,{"$f":"CEILING(((100+P65)/100*I65)*((100-J65)/100)*((100+$O$1+$O$4)/100),0.01)","v":9180},{"$f":"CEILING(Q65*1.18,0.01)","v":10832.4},{"$f":"R65*D65","v":0}]
[null,61,"Сборочные работы (ШУ)",null,null,null,null,1,6800,null,null,{"$f":"CEILING(I66*1.18*(100-J66)/100,0.01)","v":8024},{"$f":"CEILING(I66*D66*H66,0.01)","v":0},null,null,null,{"$f":"CEILING(((100+P66)/100*I66)*((100-J66)/100)*((100+$O$1+$O$4)/100),0.01)","v":9180},{"$f":"CEILING(Q66*1.18,0.01)","v":10832.4},{"$f":"R66*D66*H66","v":0}]
[null,62,"Транспортно - персональные, км",null,null,null,null,1,11,null,null,null,{"$f":"CEILING(I67*D67*H67,0.01)","v":0},null,null,null,{"$f":"I67","v":11},null,{"$f":"Q67*D67","v":0}]
[null,63,"Командировочные",null,null,null,null,1,700,null,null,null,0,null,null,null,{"$f":"I68","v":700},null,{"$f":"Q68*D68","v":0}]
[null,64,"Гостиница",null,null,null,null,1,2500,null,null,null,0,null,null,null,{"$f":"I69","v":2500},null,{"$f":"Q69*D69","v":0}]
[null,65,"Пуско-наладка",null,null,null,null,1,6800,null,null,{"$f":"CEILING(I70*1.18*(100-J70)/100,0.01)","v":8024},0,null,null,null,{"$f":"CEILING(((100+P70)/100*I70)*((100-J70)/100)*((100+$O$1+$O$4)/100),0.01)","v":9180},{"$f":"CEILING(Q70*1.18,0.01)","v":10832.4},{"$f":"R70*D70*H70","v":0}]
[null,66,"Транспортно - персональные, км",null,null,null,null,1,11,null,null,null,{"$f":"CEILING(I71*D71*H71,0.01)","v":0},null,null,null,{"$f":"I71","v":11},null,{"$f":"Q71*D71","v":0}]
[null,67,"Командировочные",null,null,null,null,1,700,null,null,null,0,null,null,null,{"$f":"I72","v":700},null,{"$f":"Q72*D72","v":0}]
[null,68,"Гостиница",null,null,null,null,1,500,null,null,null,0,null,null,null,{"$f":"I73","v":500},null,{"$f":"Q73*D73","v":0}]
[null,69,"Командировка -разведка",null,null,null,null,1,6800,null,null,{"$f":"CEILING(I74*1.18*(100-J74)/100,0.01)","v":8024},0,null,null,null,{"$f":"CEILING(((100+P74)/100*I74)*((100-J74)/100)*((100+$O$1+$O$4)/100),0.01)","v":9180},{"$f":"CEILING(Q74*1.18,0.01)","v":10832.4},{"$f":"R74*D74*H74","v":0}]
[null,70,"Транспортно - персональные, км",null,null,null,null,1,11,null,null,null,0,null,null,null,{"$f":"I75","v":11},null,{"$f":"Q75*D75","v":0}]
[null,71,"Командировочные",null,null,null,null,1,700,null,null,null,0,null,null,null,{"$f":"I76","v":700},null,{"$f":"Q76*D76","v":0}]
[null,{"$f":"B76+1","v":72},"Гостиница",null,null,null,null,1,2000,null,null,{"$f":"CEILING(I77*1.18*(100-J77)/100,0.01)","v":2360},0,null,null,null,{"$f":"I77","v":2000},null,{"$f":"Q77*D77","v":0}]
[null,73,null,"ДНЕЙ",null,null,null,"СОТРУДНИКОВ"]

{"sheet":"Прайс","index":2,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,0,0,0,0,0,0,0,0]
["Price list 1.0",null,"действ. с 25.11.2014"]
["Изменения","Артикул","Описание","Описание русское","Производитель","Кол-во \nв упаковке","Ед. \nизмерения","Наша цена \nевро, без НДС","Скидка, %","Цена \nв рублях, без НДС","Наша цена \nв долларах, без НДС","Тип продукции","Группа продукции","EAN/UPC-Code (штрих код)","брутто в кг ","нетто в кг ","объем в куб.дм ","ширина","высота","глубина","Страница в каталоге","Размеры","Product Lifecycle Management / производится до:","альтернативный артикул"]
[null,{"$f":"Провода!B1","v":"Провода"},null,{"$f":"Провода!C55","v":"Провода неопределенны   - 1м/ "},null,null,null,{"$f":"Провода!K4","v":100}]
[null,"Кабеля"]
[null,{"$f":"Маркировка!B1","v":"Маркировка"},null,{"$f":"Маркировка!C55","v":"Маркировка   - 1шт./ "},null,null,null,{"$f":"Маркировка!K4","v":100}]
[null,"Монтаж",null,"Монтажный материал",null,null,null,100]
[null,"Шильдики",null,"Шильдики",null,null,null,100]
[null,"Непредвиденное",null,"Непредвиденное",null,null,null,100]
[null,"FRN 18.5 G1E-4E",null,"Преобразователь частоты, 380-480В (3 фазы) серия G1/ 18,50кВт/39.0-45.0А, управление с ОС, БВУ, динамический векторный контроль и ВЧХ, IP20,тормозное устройство, ЕМС фильтр, без пульта управления","Fuji",null,null,1909.0536]
[null,"5E1500iUSB",null,"ИБП 5E 1500i USB (1500ВА/900Вт) Eaton ","Eaton",null,null,500]
[null,"5E850iUSB",null,"ИБП Eaton 5E 850i USB (850ВА/480Вт)","Eaton",null,null,234]
[null,"А0000013901",null,"ИБП Eaton, Powerware 9130 700 700VA/630W, 230V, On-Line, Hot Swap User Replaceable Batteries, ЖК- дисплей с отображением параметров и измерений ИБП,  Serial port RJ45+USB + разъем для подключения SNMP /WEB карт, Eaton Software Suite,in IEC320 /10A, out 6*IEC320 /10A,  разъем для подключения внешнего батарейного модуля.  Парт. номер: 103006433-6591","Eaton",null,null,318]
[null,"DR-45-24",null,"Блок питания 24В 2A Mean Well DR-45-24","MeanWell",null,null,20]
[null,"DR-120-24",null,"Блок питания 24В 5A Mean Well DR-120-24","MeanWell",null,null,30]
[null,"DR-240-24",null,"Блок питания 24В 10A Mean Well DR-240-24","MeanWell",null,null,50]
[null,"APC BK650",null,"Источник б.п. UPS APC BK 650EI 650VA Complete System Protection","ShinderElectric",null,null,90]
[null,"00.F5.060-3000",null,"Пульты оператора предназначены для иcпользования с преобразователями частоты KEB серии F5. Расширяют возможности управления преобразователем частоты посредством различных интерфейсов и протоколов обмена данными.","KEB",null,null,192.3]
[null,"МЗМ-1",null,"МЗМ-1 звонок громкого боя на переменном токе 220В",null,null,null,10]
[]
[]
[]
["ШНЭЛС"]
[null,"6ES7214-1AG40-0XB0",null,"SIMATIC S7-1200, КОМПАКТНОЕ ЦПУ CPU 1214C DC/DC/DC, ВСТРОЕННЫЕ ВХОДЫ/ВЫХОДЫ: 14 DI =24 В; 10 DO =24 В; 2 AI =0 - 10 В, БЛОК ПИТАНИЯ: =20.4 - 28.8 В, ПАМЯТЬ ПРОГРАММЫ/ДАННЫХ: 75 КБ","Siemens",null,null,234.29]
[null,"6ES7221-1BF32-0XB0",null,"SIMATIC S7-1200, МОДУЛЬ ДИСКРЕТНОГО ВВОДА SM 1221, 8DI, =24 В, ВХОДЫ SINK/SOURCE","Siemens",null,null,67.739999999999995]
[null,"6ES7241-1CH32-0XB0",null,"SIMATIC S7-1200, КОММУНИКАЦИОННЫЙ МОДУЛЬ CM 1241, RS422/485, 9-ПОЛЮСНЫЙ РАЗЪЁМ SUB D (ВИЛКА), СВОБОДНО-ПРОГРАММИРУЕМЫЙ ПОРТ С ПОДДЕРЖКОЙ ТЕЛЕГРАММ","Siemens",null,null,79.349999999999994]
[null,"3RT1276-6AP36",null,"ВАКУУМНЫЙ КОНТАКТОР, 250КВТ/400V/AC-3, AC/DC-НОМИНАЛЬНОЕ ПИТАЮЩЕЕ НАПРЯЖЕНИЕ УПРАВЛЕНИЯ 220-240В UCБЛОК-КОНТАКТЫ 2НО+2НЗ 3-Х ПОЛЮСНЫЙ, ТИПОРАЗМЕР S12 ШИННОЕ ПРИСОЕДИНЕНИЕ ПРИВОД: ОБЫЧНЫЙ","Siemens",null,null,1269.07]
[null,"3RT1076-6AP36",null,"КОНТАКТОР 250КВТ/400V/AC-3, AC/DC-НОМИНАЛЬНОЕ ПИТАЮЩЕЕ НАПРЯЖЕНИЕ УПРАВЛЕНИЯ 220-240В UCБЛОК-КОНТАКТЫ 2НО+2НЗ 3-Х ПОЛЮСНЫЙ, ТИПОРАЗМЕР S12 ШИННОЕ ПРИСОЕДИНЕНИЕ ПРИВОД: ОБЫЧНЫЙ","Siemens",null,null,916.97]
[null,"3VT1706-2DB36-0AA0",null,"АВТОМАТИЧЕСКИЙ ВЫКЛЮЧАТЕЛЬ 3VT1 СТАНДАРТНАЯ ОТКЛ. СПОСОБНОСТЬ ICU=25KA, 415V AC 3-ПОЛ.; STARTER COMBINATION РАСЦЕПИТЕЛЬ TM, LIN IN= 63A RATED CURRENT II= 315... 630A, SHORT-CIRCUIT PROTECTION W/O AUXILIARY TRIP UNIT W/O AUXILIARY/ALARM SWITCH WITHOUT AUXIL","Siemens",null,null,53.67]
[null,"3KD5230-0RE10-0",null,"ВЫКЛЮЧАТЕЛЬ-РАЗЪЕДИНИТЕЛЬ 1250A, ТР.5, 3-ПОЛ ФРОНТ.УПР. СЛЕВА БАЗ.БЛОК БЕЗ РУЧКИ ПЛОСКИЕ КЛЕММЫ","Siemens",null,null,743.12]
[null,"3VT9363-6AS00",null,"РАСЦЕПИТЕЛЬ МАКС.ТОКА ЭЛЕКТР. VT630 3-ПОЛ.,MOTOR/TRANSF. PROTECT. ETU MPS, LI IR= 250... 630A, OVERLOAD PROTECTION IRM= 3... 9KA SHORT-CIRCUIT PROTECTION, SCREW TERMINAL CONNECTIONS IN SCOPE OF SUPPLY OF SWITCHING UNIT","Siemens",null,null,300.33]
[null,"3VT3763-2AA36-0AA0",null,"АВТОМАТИЧЕСКИЙ ВЫКЛЮЧАТЕЛЬ 3VT3 СТАНДАРТНАЯ ОТКЛ. СПОСОБНОСТЬ ICU=36KA, 415V AC 3-ПОЛ.; АВТОМАТИЧЕСКИЙ ВЫКЛЮЧАТЕЛЬ W/O ELECTRONIC TRIP UNIT W/O AUXILIARY TRIP UNIT W/O AUXILIARY/ALARM SWITCH WITHOUT AUXILIARY RELEASE WITHOUT AUXILIARY/ALARM SWITCH OHNE HIL","Siemens",null,null,241.1]

{"sheet":"Провода","index":3,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,8,0,11],[1,1,3,1],[1,2,3,2],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,3,3,3]]}
[null,"Провода",null,null,null,null,{"$f":"TODAY()","v":"2015-03-30"},"2015-02-10","Цена без НДС"]
[null,"№ \nп/п","Наименование, марка провода","Цвет","Артикул","Производитель","Склад, м","Заказ, м","EUR/USD",{"$f":"'Рабочий лист'!I2","v":1.148819},"Сумма","Сумма"]
[null,null,null,null,null,null,null,null,"EURO","РУБЛЬ","EURO","РУБЛЬ"]
[null,null,null,null,null,null,null,null,{"$f":"'Рабочий лист'!H4","v":70},null,{"$f":"SUM(K5:K54)","v":100},{"$f":"SUM(L5:L54)","v":7000}]
[null,1,"Провода неопределенны"," ",null,null,1,1,100,{"$f":"$I$4*I5","v":7000},{"$f":"H5*I5","v":100},{"$f":"H5*J5","v":7000},null,{"$f":"IF(H5<>0,CONCATENATE(C5,\" \",TEXT(D5,0),\" - \",TEXT(H5,0),\"м\",\"/ \"),\"\")","v":"Провода неопределенны   - 1м/ "},{"$f":"IF(AND(H5<>0,F5<>0),CONCATENATE(F5,\"/ \"),\"\")","v":""}]
[null,{"$f":"1+B5","v":2},"ПВЗ, 1х0,75","PE",null,"КирсКабель",650,null,0.2,{"$f":"$I$4*I6","v":14},{"$f":"H6*I6","v":0},{"$f":"H6*J6","v":0},null,{"$f":"IF(H6<>0,CONCATENATE(C6,\" \",TEXT(D6,0),\" - \",TEXT(H6,0),\"м\",\"/ \"),\"\")","v":""},{"$f":"IF(AND(H6<>0,F6<>0),CONCATENATE(F6,\"/ \"),\"\")","v":""}]
[null,{"$f":"1+B6","v":3},"ПВ3, 1х2,5","PE",null,"ОкуловкаКабель",250,null,0.2,{"$f":"$I$4*I7","v":14},0,0,null,{"$f":"IF(H7<>0,CONCATENATE(C7,\" \",TEXT(D7,0),\" - \",TEXT(H7,0),\"м\",\"/ \"),\"\")","v":""},{"$f":"IF(AND(H7<>0,F7<>0),CONCATENATE(F7,\"/ \"),\"\")","v":""}]
[null,{"$f":"1+B7","v":4},"ПВ3, 1х4","PE",null,null,150,null,0.2,14,0,0,null,{"$f":"IF(H8<>0,CONCATENATE(C8,\" \",TEXT(D8,0),\" - \",TEXT(H8,0),\"м\",\"/ \"),\"\")","v":""}]
[null,5,"ПуГВ, 1х10","PE",null,null,100,null,0.2,14,0,0,null,""]
[null,{"$f":"1+B9","v":6},"(луженый) 1х0,5","белый",null,null,500,null,0.2,14,0,0,null,""]
[null,7,"ПВЗ, 1х0,75","белый",null,null,1100,null,0.2,14,0,0,null,""]
[null,8,"ПВСЗ, 1х1,5","белый",null,null,550,null,0.2,14,0,0,null,""]
[null,9,"ПВ3, 1х2,5","белый",null,null,300,null,0.2,14,0,0,null,""]
[null,10,"ПВ3, 1х4","белый",null,null,570,null,0.2,14,0,0,null,""]
[null,11,"ПуГВ, 1х10","белый",null,null,200,null,0.2,14,0,0,null,""]
[null,12,"ПуГВ, 1х16","белый",null,null,15,null,0.2,14,0,0,null,""]
[null,13,"ПВЗ, 1х0,75","синий",null,null,2250,null,0.2,14,0,0,null,""]
[null,14,"ПВ3, 1х2,5","синий",null,null,300,null,0.2,14,0,0,null,""]
[null,15,"ПВ3, 1х4","синий",null,null,200,null,0.2,14,0,0,null,""]
[null,16,"ПуГВ, 1х10","синий",null,null,100,null,0.2,14,0,0,null,""]
[null,17,"ПВЗ, 1х0,75","оранжевый",null,null,2700,null,0.2,14,0,0,null,""]
[null,18,"ПВ3, 1х4","красный",null,null,100,null,0.2,14,0,0,null,""]
[null,19,"ПВЗ, 1х0,75","коричневый",null,null,600,null,0.2,14,0,0,null,""]
[null,20,"ПВЗ, 1х0,75","черный",null,null,1000,null,null,null,0,0,null,""]
[null,21,null,null,null,null,null,null,null,null,0,0,null,""]
[null,22,null,null,null,null,null,null,null,null,0,0,null,""]
[null,23,null,null,null,null,null,null,null,null,0,0,null,""]
[null,24,null,null,null,null,null,null,null,null,0,0,null,""]
[null,25,null,null,null,null,null,null,null,null,0,0,null,""]
[null,26,null,null,null,null,null,null,null,null,0,0,null,""]
[null,27,null,null,null,null,null,null,null,null,0,0,null,""]
[null,28,null,null,null,null,null,null,null,null,0,0,null,""]
[null,29,null,null,null,null,null,null,null,null,0,0,null,""]
[null,30,null,null,null,null,null,null,null,null,0,0,null,""]
[null,31,null,null,null,null,null,null,null,null,0,0,null,""]
[null,32,null,null,null,null,null,null,null,null,0,0,null,""]
[null,33,null,null,null,null,null,null,null,null,0,0,null,""]
[null,34,null,null,null,null,null,null,null,null,0,0,null,""]
[null,35,null,null,null,null,null,null,null,null,0,0,null,""]
[null,36,null,null,null,null,null,null,null,null,0,0,null,""]
[null,37,null,null,null,null,null,null,null,null,0,0,null,""]
[null,38,null,null,null,null,null,null,null,null,0,0,null,""]
[null,39,null,null,null,null,null,null,null,null,0,0,null,""]
[null,40,null,null,null,null,null,null,null,null,0,0,null,""]
[null,41,null,null,null,null,null,null,null,null,0,0,null,""]
[null,42,null,null,null,null,null,null,null,null,0,0,null,""]
[null,43,null,null,null,null,null,null,null,null,0,0,null,""]
[null,44,null,null,null,null,null,null,null,null,0,0,null,""]
[null,45,null,null,null,null,null,null,null,null,0,0,null,""]
[null,46,null,null,null,null,null,null,null,null,0,0,null,""]
[null,47,null,null,null,null,null,null,null,null,0,0,null,""]
[null,48,null,null,null,null,null,null,null,null,0,0,null,""]
[null,49,null,null,null,null,null,null,null,null,0,0,null,""]
[null,50,null,null,null,null,null,null,null,null,0,0,null,""]
[null,null,{"$f":"CONCATENATE(N5,N6,N7,N8,N9,N10,N11,N12,N13,N14,N15,N16,N17,N18,N19,N20,N21,N22,N23,N24,N25,N26,N27,N28,N29,N30,N31,N32,N33,N34,N35,N36,N37,N38,N39,N40,N41,N42,N43,N44,N45,N46,N47,N48,N49,N50,N51,N52,N53,N54)","v":"Провода неопределенны   - 1м/ "}]
[null,null,{"$f":"CONCATENATE(F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,F24,F25,F26,F27,F28,F29,F30,F31,F32,F33,F34,F35,F36,F37,F38,F39,F40,F41,F42,F43,F44,F45,F46,F47,F48,F49,F50,F51,F52,F53,F54,F55)","v":"КирсКабельОкуловкаКабель"}]

{"sheet":"Маркировка","index":4,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,8,0,11],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7]]}
[null,"Маркировка",null,null,null,null,{"$f":"TODAY()","v":"2015-03-30"},"2015-02-10","Цена без НДС"]
[null,"№ \nп/п","Наименование, марка провода","Цвет","Артикул","Производитель","Склад, м","Заказ, м","EUR/USD",{"$f":"'Рабочий лист'!I2","v":1.148819},"Сумма","Сумма"]
[null,null,null,null,null,null,null,null,"EURO","РУБЛЬ","EURO","РУБЛЬ"]
[null,null,null,null,null,null,null,null,{"$f":"'Рабочий лист'!H4","v":70},null,{"$f":"SUM(K5:K54)","v":100},{"$f":"SUM(L5:L54)","v":7000}]
[null,1,"Маркировка ","неизвестна",null,null,1,1,100,{"$f":"$I$4*I5","v":7000},{"$f":"H5*I5","v":100},{"$f":"H5*J5","v":7000},null,{"$f":"IF(H5<>0,CONCATENATE(TEXT(C5,0),\" \",\" - \",TEXT(H5,0),\"шт.\",\"/ \"),\"\")","v":"Маркировка   - 1шт./ "}]
[null,{"$f":"1+B5","v":2},0,null,null,null,200,null,4.0000000000000001E-3,{"$f":"$I$4*I6","v":0.28000000000000003},{"$f":"H6*I6","v":0},{"$f":"H6*J6","v":0},null,{"$f":"IF(H6<>0,CONCATENATE(TEXT(C6,0),\" \",\" - \",TEXT(H6,0),\"шт.\",\"/ \"),\"\")","v":""}]
[null,{"$f":"1+B6","v":3},"1",null,null,null,200,null,4.0000000000000001E-3,{"$f":"$I$4*I7","v":0.28000000000000003},0,0,null,{"$f":"IF(H7<>0,CONCATENATE(TEXT(C7,0),\" \",\" - \",TEXT(H7,0),\"шт.\",\"/ \"),\"\")","v":""}]
[null,{"$f":"1+B7","v":4},"2",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,5,"3",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,6,"4",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,7,"5",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,8,"6",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,9,"7",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,10,"8",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,11,"9",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,12,"A",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,13,"B",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,14,"C",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,15,"PE",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,16,"N",null,null,null,200,null,4.0000000000000001E-3,0.28000000000000003,0,0,null,""]
[null,17,null,null,null,null,null,null,null,0,0,0,null,""]
[null,18,null,null,null,null,null,null,null,0,0,0,null,""]
[null,19,null,null,null,null,null,null,null,0,0,0,null,""]
[null,20,null,null,null,null,null,null,null,null,0,0,null,""]
[null,21,null,null,null,null,null,null,null,null,0,0,null,""]
[null,22,null,null,null,null,null,null,null,null,0,0,null,""]
[null,23,null,null,null,null,null,null,null,null,0,0,null,""]
[null,24,null,null,null,null,null,null,null,null,0,0,null,""]
[null,25,null,null,null,null,null,null,null,null,0,0,null,""]
[null,26,null,null,null,null,null,null,null,null,0,0,null,""]
[null,27,null,null,null,null,null,null,null,null,0,0,null,""]
[null,28,null,null,null,null,null,null,null,null,0,0,null,""]
[null,29,null,null,null,null,null,null,null,null,0,0,null,""]
[null,30,null,null,null,null,null,null,null,null,0,0,null,""]
[null,31,null,null,null,null,null,null,null,null,0,0,null,""]
[null,32,null,null,null,null,null,null,null,null,0,0,null,""]
[null,33,null,null,null,null,null,null,null,null,0,0,null,""]
[null,34,null,null,null,null,null,null,null,null,0,0,null,""]
[null,35,null,null,null,null,null,null,null,null,0,0,null,""]
[null,36,null,null,null,null,null,null,null,null,0,0,null,""]
[null,37,null,null,null,null,null,null,null,null,0,0,null,""]
[null,38,null,null,null,null,null,null,null,null,0,0,null,""]
[null,39,null,null,null,null,null,null,null,null,0,0,null,""]
[null,40,null,null,null,null,null,null,null,null,0,0,null,""]
[null,41,null,null,null,null,null,null,null,null,0,0,null,""]
[null,42,null,null,null,null,null,null,null,null,0,0,null,""]
[null,43,null,null,null,null,null,null,null,null,0,0,null,""]
[null,44,null,null,null,null,null,null,null,null,0,0,null,""]
[null,45,null,null,null,null,null,null,null,null,0,0,null,""]
[null,46,null,null,null,null,null,null,null,null,0,0,null,""]
[null,47,null,null,null,null,null,null,null,null,0,0,null,""]
[null,48,null,null,null,null,null,null,null,null,0,0,null,""]
[null,49,null,null,null,null,null,null,null,null,0,0,null,""]
[null,50,null,null,null,null,null,null,null,null,0,0,null,""]
[null,null,{"$f":"CONCATENATE(N5,N6,N7,N8,N9,N10,N11,N12,N13,N14,N15,N16,N17,N18,N19,N20,N21,N22,N23,N24,N25,N26,N27,N28,N29,N30,N31,N32,N33,N34,N35,N36,N37,N38,N39,N40,N41,N42,N43,N44,N45,N46,N47,N48,N49,N50,N51,N52,N53,N54)","v":"Маркировка   - 1шт./ "}]
[null,null,{"$f":"CONCATENATE(F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,F24,F25,F26,F27,F28,F29,F30,F31,F32,F33,F34,F35,F36,F37,F38,F39,F40,F41,F42,F43,F44,F45,F46,F47,F48,F49,F50,F51,F52,F53,F54,F55)","v":""}]

{"sheet":"t","index":5,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Заработная плата","руб, на руки","штат"]
["директор",40000,1]
["заместитель  директора",40000,0]
["бухгалтер",40000,1]
["старший инженер",40000,0,{"$f":"CEILING((B5*(1+B22)*(1+B13)*(1+B14)*(1+B15))/B10,50)","v":5600},{"$f":"D5*1.18","v":6608}]
["инженер",35000,4,{"$f":"CEILING((B6*(1+$B$13)*(1+$B$14)/$B$10)*(1+B$22)*(1+$B$15),50)","v":4900},{"$f":"D6*1.18","v":5782}]
["монтажник",35000,0,{"$f":"CEILING((B7*(1+$B$13)*(1+$B$14)/$B$10)*(1+B$22)*(1+$B$15),50)","v":4900},{"$f":"D7*1.18","v":5782}]
["Аренда",20000]
["командировки",10000,{"$f":"C7+C6+C5","v":4},"фактический\n Штат инж-монт"]
["рабочих дней в месяце",22]
["расчетный период, месяцев",1]
["управленческий корпус, руб",{"$f":"CEILING(B11*(B2*C2+B3*C3+B4*C4+B8+B9),0.001)","v":110000}]
["налоговые и пенсионные отчисления",0.36]
["тариф банка по зарпл. проекту",7.000000000000001E-3]
["коэффициент запаса",0.2]
["база расчетов \n(фот инженеров-монтажников без налогов и банка)",{"$f":"(B5*C5+B6*C6+B7*C7)","v":140000}]
["Человеко-дни \n(инженеры-монтажники)",{"$f":"C9*B10","v":88}]
["Месяц-компани",{"$f":"CEILING(B17/B10/C9,0.001)","v":1}]
["управленческие расходы на период, руб",{"$f":"B18*B12","v":110000}]
["управленческие расходы на период, %",{"$f":"B19/B16","v":0.7857142857142857}]
["на развитие, % от упр. Расх",0.1,null,{"$f":"B21*B19","v":11000}]
["управл. Расходы  + развитие %",{"$f":"B20*(1+B21)","v":0.86428571428571432}]

{"sheet":"b","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Рентабельность ","Брутто ( с НДС)","без НДС"]
["всего проект",{"$f":"'Рабочий лист'!S4","v":584641.44000000006}]
["оборудование",{"$f":"'Рабочий лист'!P2","v":108267.22749999999},{"$f":"B3/1.18","v":91751.887711864401},{"$f":"'Рабочий лист'!O2","v":25}]
["работы",{"$f":"'Рабочий лист'!P4","v":108267.22749999999},91751.887711864401,{"$f":"'Рабочий лист'!O4","v":25}]
["коэффициент запаса",{"$f":"'Рабочий лист'!P1","v":86613.782000000007},73401.510169491536,{"$f":"'Рабочий лист'!O1","v":10}]
["суммарно",{"$f":"B5+B4+B3","v":303148.23699999996},256905.28559322032]
["ФОТ",{"$f":"'Рабочий лист'!M1","v":433068.91000000003},367007.55084745766]
["управл расходы",{"$f":"B10*t!B19","v":6553687.5},5553972.4576271186]
["запас на развитие",{"$f":"t!B21*B8","v":655368.75},555397.24576271186]
["Месяц-компани",{"$f":"'Рабочий лист'!L1/t!B10/t!C9","v":59.578977272727272}]
["Человеко-дней",{"$f":"'Рабочий лист'!L1","v":5242.95}]