{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Главная форма","Реализация и себестоимость","Производственные затраты и ФР","Справочник","Сводный отчет","СР","СП","Шаблоны"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,3,2,5],[21,1,38,6],[6,5,7,5],[17,1,17,6],[18,1,18,6],[19,1,19,6],[15,1,15,6],[14,1,14,6],[8,1,12,1]]}
[null,"Сегодня:",null,{"$f":"TODAY()","v":"2018-09-12"}]
[]
[null,"Наименование ЮЛ:",null,"ООО \"РАДУГА\" ИНН/КПП 0000000001/000000000, ОГРН 0000000000000"]
[]
[null,"Отчетный месяц:",null,null,null,7]
[]
[null,"Отчетный год:",null,2018]
[]
[null,"Навигация"]
[]
[]
[]
[]
[]
[null,{"$f":"IF('Производственные затраты и ФР'!B30=0, \" \", \"ИМЕЕТСЯ ВВЕДЕННАЯ ИНФОРМАЦИЯ!\")","v":"ИМЕЕТСЯ ВВЕДЕННАЯ ИНФОРМАЦИЯ!"}]
[null,{"$f":"IF('Производственные затраты и ФР'!B30=0, \"ДАННЫЕ ОБНУЛЕНЫ!\", \" \")","v":" "}]
[]
[]
[]
[]
[]
[null,"Перед началом ввода данных необходимо выбрать из открывающегося списка отчетный месяц. Если ранее введенные данные больше не нужны (о чем символизирует сигнальная строка \"ИМЕЕТСЯ ВВЕДЕННАЯ ИНФОРМАЦИЯ!\") , необходимо нажать кнопку \"Очистка (обнуление) данных о реализации и себестоимости готовой продукции за предыдущий отчетный период\" (сигнальная строка примет вид \"ДАННЫЕ ОБНУЛЕНЫ!\" - произойдет автоматическая очистка всех ячеек, предназначенных для ввода информации).                                                                                                                                                                    После этого необходимо нажать кнопку \"Переход к вводу информации о реализации и себестоимости готовой продукции за текущий месяц\", после которой Вы попадете в основное рабочее окно, где необходимо внести требуемую информацию. Для редактирования и работы пользователя доступны только поля, окрашенные в светло-синий цвет. Все остальны ячейки и поля защищены от изменений. Все расчеты производятся автоматически.                                                                                       Ввод из справочников возможен только в поля, окрашенные в светло-салатовый цвет.                                                                                                                                               После полного ввода требуемого объема расчетных данных, необходимо нажать на кнопку \"Переход к вводу производственных затрат и финансового результата\". Вся необходимая информация переносится автоматически. В данном окне необходимо ввести суммы затрат по статьям (основной список остается без изменений), а для дополнительных - возможно самостоятельное заполнение в полях, окрашенных в светло-синий цвет.                                                                                   Возможен вывод на печать всех отчетов в привычном для пользователя виде, но при этом отчет выводится в черно-белом варианте печати. Справочники на печать не выводятся."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[8]

{"sheet":"Реализация и себестоимость","index":1,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,1,5,12],[6,5,6,10],[13,1,13,3],[6,2,6,4],[6,11,6,12],[6,1,7,1]]}
["Сегодня:   ",{"$f":"TODAY()","v":"2018-09-12"}]
[null,null,null,"Контрольные суммы:",{"$f":"E14","v":450},0,0,0,0,0,0,450,"ДОХОД"]
[]
[null,"Наименование юридического лица:",{"$f":"'Главная форма'!D3","v":"ООО \"РАДУГА\" ИНН/КПП 0000000001/000000000, ОГРН 0000000000000"}]
[null,null," ",null,"Отчетный месяц:",{"$f":"'Главная форма'!A33","v":8},"год:",{"$f":"'Главная форма'!D7","v":2018},null,null,null," ",null,null," ",null,null," "]
[null,"ДАННЫЕ ПО РЕАЛИЗАЦИИ И СЕБЕСТОИМОСТИ ГОТОВОЙ ПРОДУКЦИИ, ВЫПУЩЕННОЙ ЗА ОТЧЕТНЫЙ МЕСЯЦ В РАЗРЕЗЕ НОМЕНКЛАТУРЫ ТОВАРА:"]
[null,"Наименование товара","Реализация:",null,null,"Себестоимость материалов, отпущенных в производство и прочие накладные расходы:",null,null,null,null,null,"Итого по товару"]
[null,null,"кол-во отпущ. товара","цена реализац.","сумма по реализации","ткань","фурнитура","сдельная з/плата"," "," ","всего расходов","сумма","показатель"]
["** 0",{"$f":"VLOOKUP(A9,СП!$A$2:$C$501,2,0)","v":0},null,{"$f":"VLOOKUP(A9,СП!$A$2:$C$501,3,0)","v":0},{"$f":"C9*D9","v":0},0,0,0,0,0,{"$f":"F9+G9+H9+I9+J9","v":0},{"$f":"E9-K9","v":0},{"$f":"IF(L9<0,\"УБЫТОК\",\"ДОХОД\")","v":"ДОХОД"}]
["*10* Носовой платок",{"$f":"VLOOKUP(A10,СП!$A$2:$C$501,2,0)","v":"Носовой платок"},45,{"$f":"VLOOKUP(A10,СП!$A$2:$C$501,3,0)","v":10},{"$f":"C10*D10","v":450},0,0,0,0,0,{"$f":"F10+G10+H10+I10+J10","v":0},{"$f":"E10-K10","v":450},"ДОХОД"]
["** ИРИНА",{"$f":"VLOOKUP(A11,СП!$A$2:$C$501,2,0)","v":"ИРИНА"},null,{"$f":"VLOOKUP(A11,СП!$A$2:$C$501,3,0)","v":0},{"$f":"C11*D11","v":0},0,0,0,0,0,{"$f":"F11+G11+H11+I11+J11","v":0},{"$f":"E11-K11","v":0},"ДОХОД"]
["*10* Носовой платок",{"$f":"VLOOKUP(A12,СП!$A$2:$C$501,2,0)","v":"Носовой платок"},null,{"$f":"VLOOKUP(A12,СП!$A$2:$C$501,3,0)","v":10},{"$f":"C12*D12","v":0},0,0,0,0,0,{"$f":"F12+G12+H12+I12+J12","v":0},{"$f":"E12-K12","v":0},"ДОХОД"]
["** 0",{"$f":"VLOOKUP(A13,СП!$A$2:$C$501,2,0)","v":0},null,{"$f":"VLOOKUP(A13,СП!$A$2:$C$501,3,0)","v":0},{"$f":"C13*D13","v":0},0,0,0,0,0,{"$f":"F13+G13+H13+I13+J13","v":0},{"$f":"E13-K13","v":0},"ДОХОД"]
[null,"ИТОГО ЗА ТЕКУЩИЙ МЕСЯЦ ПО ВСЕМ ТОВАРНЫМ НАИМЕНОВАНИЯМ:     ",null,null,{"$f":"IFERROR(SUM(INDIRECT(\"E9\"&\":\"&CELL(\"адрес\",$E$13))),\"-\")","v":450},{"$f":"IFERROR(SUM(INDIRECT(\"F9\"&\":\"&CELL(\"адрес\",$F$13))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"G9\"&\":\"&CELL(\"адрес\",$G$13))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"H9\"&\":\"&CELL(\"адрес\",$H$13))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"I9\"&\":\"&CELL(\"адрес\",$I$13))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"J9\"&\":\"&CELL(\"адрес\",$J$13))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"K9\"&\":\"&CELL(\"адрес\",$K$13))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"L9\"&\":\"&CELL(\"адрес\",$L$13))),\"-\")","v":450},"ДОХОД"]

{"sheet":"Производственные затраты и ФР","index":2,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,0,28,0],[5,0,6,0]]}
["Контрольные суммы:                                           Финансовый результат:","Общая сумма расходов:"]
[{"$f":"B28","v":450},{"$f":"B25","v":0}]
["Наименование юридического лица:"]
[{"$f":"'Главная форма'!D3","v":"ООО \"РАДУГА\" ИНН/КПП 0000000001/000000000, ОГРН 0000000000000"}]
[]
[{"$f":"CONCATENATE(\"Итог по реализации и себестоимости, полученный за текущий месяц \",\"(\",'Реализация и себестоимость'!F5,\"/\",'Реализация и себестоимость'!H5,\"):\")","v":"Итог по реализации и себестоимости, полученный за текущий месяц (8/2018):"},{"$f":"'Реализация и себестоимость'!L14","v":450}]
[null,{"$f":"'Реализация и себестоимость'!M14","v":"ДОХОД"}]
[]
["Производственные и прочие затраты, учтенные в текущем месяце в разрезе видов:"]
[]
["Наименование статей постоянных и переменных затрат","Сумма (руб, коп.)"]
["А001 Заработная плата (АУП)",0]
["А002 Налоги",0]
["А003 Штрафы",0]
["А004 Аренда помещения",0]
["А005 Электроэнергия",0]
["А006 Тепло- и водоснабжение",0]
["А007 Услуги связи и Internet",0]
["А008 Обслуживание оргтехники и компьютеров",0]
["А009 Аутсорсинговые услуги (\"Счетовод\")",0]
["А010 Банковское обслуживание",0]
["А011 Транспортные расходы",0]
["А012 Ремонт машин и оборудования основного производства",0]
[]
["Итого расходов за месяц:",{"$f":"IFERROR(SUM(INDIRECT(\"B12\"&\":\"&CELL(\"адрес\",$B$24))),\"-\")","v":0}]
[]
[]
["ФИНАНСОВЫЙ РЕЗУЛЬТАТ ЗА ТЕКУЩИЙ МЕСЯЦ:",{"$f":"B6-B25","v":450}]
[null,{"$f":"IF(B28<0,\"(НЕПОКРЫТЫЙ УБЫТОК)\",\"ЧИСТАЯ ПРИБЫЛЬ\")","v":"ЧИСТАЯ ПРИБЫЛЬ"}]
[null,{"$f":"B28","v":450}]

{"sheet":"Справочник","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Январь",2018]
["Февраль",2019]
["Март",2020]
["Апрель",2021]
["Май",2022]
["Июнь",2023]
["Июль",2024]
["Август",2025]
["Сентябрь",2026]
["Октябрь",2027]
["Ноябрь",2028]
["Декабрь",2029]

{"sheet":"Сводный отчет","index":4,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,0,3,14],[2,2,2,14],[23,0,23,1],[24,0,24,1],[25,0,25,1],[14,0,14,14],[4,0,4,1],[4,14,5,14],[29,0,29,1],[28,0,28,1],[5,0,5,1],[6,0,6,1],[13,0,13,1],[15,0,15,1],[16,0,16,1],[7,0,11,0],[12,0,12,1],[20,0,20,1],[26,0,26,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[22,0,22,1]]}
[]
[]
["Наименование юридического лица:",null,{"$f":"'Производственные затраты и ФР'!A4","v":"ООО \"РАДУГА\" ИНН/КПП 0000000001/000000000, ОГРН 0000000000000"}]
[{"$f":"CONCATENATE(\"СВОДНЫЙ ОТЧЕТ ПО РЕАЛИЗАЦИИ, СЕБЕСТОИМОСТИ, ПРОИЗВОДСТВЕННЫХ ЗАТРАТ И ФИНАНСОВЫХ РЕЗУЛЬТАТОВ ЗА\",\"  \",C6,\" ГОД\")","v":"СВОДНЫЙ ОТЧЕТ ПО РЕАЛИЗАЦИИ, СЕБЕСТОИМОСТИ, ПРОИЗВОДСТВЕННЫХ ЗАТРАТ И ФИНАНСОВЫХ РЕЗУЛЬТАТОВ ЗА  2018 ГОД"}]
["Отчетный период",null,"Январь","Февраль","Март","Апрель","Май","Июнь","Июль","Август","Сентябрь","Октябрь","Ноябрь","Декабрь","Итого"]
["Наименование показателя",null,{"$f":"'Реализация и себестоимость'!H5","v":2018},{"$f":"C6","v":2018},2018,2018,2018,2018,2018,2018,2018,2018,2018,2018]
["Стоимость реализации",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C7:N7)","v":0}]
["Себестоимость:","ткань",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C8:N8)","v":0}]
[null,"фурнитура",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"сдельная з/плата",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Всего расходов:",null,{"$f":"SUM(C8:C12)","v":0},{"$f":"SUM(D8:D12)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["ПРОМЕЖУТОЧНЫЙ ФИНАНСОВЫЙ РЕЗУЛЬТАТ",null,{"$f":"C7-C13","v":0},{"$f":"D7-D13","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Статьи постоянных и переменных затрат (код \"А\" - постоянные; код \"П\" - переменные):"]
[{"$f":"'Производственные затраты и ФР'!A12","v":"А001 Заработная плата (АУП)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C16:N16)","v":0}]
[{"$f":"'Производственные затраты и ФР'!A13","v":"А002 Налоги"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C17:N17)","v":0}]
[{"$f":"'Производственные затраты и ФР'!A14","v":"А003 Штрафы"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Производственные затраты и ФР'!A15","v":"А004 Аренда помещения"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Производственные затраты и ФР'!A16","v":"А005 Электроэнергия"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Производственные затраты и ФР'!A17","v":"А006 Тепло- и водоснабжение"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Производственные затраты и ФР'!A18","v":"А007 Услуги связи и Internet"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Производственные затраты и ФР'!A19","v":"А008 Обслуживание оргтехники и компьютеров"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Производственные затраты и ФР'!A20","v":"А009 Аутсорсинговые услуги (\"Счетовод\")"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Производственные затраты и ФР'!A21","v":"А010 Банковское обслуживание"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Производственные затраты и ФР'!A22","v":"А011 Транспортные расходы"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Производственные затраты и ФР'!A23","v":"А012 Ремонт машин и оборудования основного производства"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Всего расходов:",null,{"$f":"IFERROR(SUM(INDIRECT(\"C16\"&\":\"&CELL(\"адрес\",$C$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"D16\"&\":\"&CELL(\"адрес\",$D$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"E16\"&\":\"&CELL(\"адрес\",$E$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"F16\"&\":\"&CELL(\"адрес\",$F$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"G16\"&\":\"&CELL(\"адрес\",$G$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"H16\"&\":\"&CELL(\"адрес\",$H$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"I16\"&\":\"&CELL(\"адрес\",$I$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"J16\"&\":\"&CELL(\"адрес\",$J$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"K16\"&\":\"&CELL(\"адрес\",$K$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"L16\"&\":\"&CELL(\"адрес\",$L$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"M16\"&\":\"&CELL(\"адрес\",$M$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"N16\"&\":\"&CELL(\"адрес\",$N$28))),\"-\")","v":0},{"$f":"IFERROR(SUM(INDIRECT(\"O16\"&\":\"&CELL(\"адрес\",$O$28))),\"-\")","v":0}]
["ИТОГОВЫЙ ФИН. РЕЗУЛЬТАТ",null,{"$f":"C14-C29","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C30:N30)","v":0}]

{"sheet":"СР","index":5,"n_rows":101,"n_cols":3,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,null,"Статья переменных затрат"]
[{"$f":"B2&\" \"&C2","v":"П001 GGGGG"},"П001","GGGGG"]
["П002 А потому что","П002","А потому что"]
["П003 Гггггг","П003","Гггггг"]
["П004 ггггггггггггггггггггггггг","П004","ггггггггггггггггггггггггг"]
["П033 ггггггггггггггггггггггггг","П033","ггггггггггггггггггггггггг"]
["П005 дддд","П005","дддд"]
["П030 ДДДДД","П030","ДДДДД"]
["П031 ДДДДДД","П031","ДДДДДД"]
["П006 Еееее","П006","Еееее"]
["П029 ЗЗЗЗ","П029","ЗЗЗЗ"]
["П007 Ййййй","П007","Ййййй"]
["П035 Кант","П035","Кант"]
["П008 Канцтовары","П008","Канцтовары"]
["П034 Канцы","П034","Канцы"]
["П009 лллл","П009","лллл"]
["П010 Может быть","П010","Может быть"]
["П011 ннн","П011","ннн"]
["П028 ОООООООООООООООО","П028","ОООООООООООООООО"]
["П012 Отчет","П012","Отчет"]
["П013 платежно","П013","платежно"]
["П014 Предплатежная","П014","Предплатежная"]
["П015 Премия квартальная","П015","Премия квартальная"]
["П016 Премия ко дню рождения","П016","Премия ко дню рождения"]
["П017 Премия новогодняя","П017","Премия новогодняя"]
["П027 Проверка","П027","Проверка"]
["П018 Просто так","П018","Просто так"]
["П019 расчетно-","П019","расчетно-"]
["П020 ррр","П020","ррр"]
["П032 РРРРРРРРРРРРРРРРРРРРРРРРРРРРР","П032","РРРРРРРРРРРРРРРРРРРРРРРРРРРРР"]
["П021 Сборная-затратная","П021","Сборная-затратная"]
["П022 Сборно-разборная","П022","Сборно-разборная"]
["П023 тртртртт","П023","тртртртт"]
[{"$f":"B34&\" \"&C34","v":"П024 ттттттттттттт"},"П024","ттттттттттттт"]
["П025 уууууууууууууу","П025","уууууууууууууу"]
["П026 щщщщ","П026","щщщщ"]
["П036 ","П036"]
["П037 ","П037"]
["П038 ","П038"]
["П039 ","П039"]
["П040 ","П040"]
["П041 ","П041"]
["П042 ","П042"]
["П043 ","П043"]
["П044 ","П044"]
["П045 ","П045"]
["П046 ","П046"]
["П047 ","П047"]
["П048 ","П048"]
["П049 ","П049"]
["П050 ","П050"]
["П051 ","П051"]
["П052 ","П052"]
["П053 ","П053"]
["П054 ","П054"]
["П055 ","П055"]
["П056 ","П056"]
["П057 ","П057"]
["П058 ","П058"]
["П059 ","П059"]
["П060 ","П060"]
["П061 ","П061"]
["П062 ","П062"]
["П063 ","П063"]
["П064 ","П064"]
[{"$f":"B66&\" \"&C66","v":"П065 "},"П065"]
["П066 ","П066"]
["П067 ","П067"]
["П068 ","П068"]
["П069 ","П069"]
["П070 ","П070"]
["П071 ","П071"]
["П072 ","П072"]
["П073 ","П073"]
["П074 ","П074"]
["П075 ","П075"]
["П076 ","П076"]
["П077 ","П077"]
["П078 ","П078"]
["П079 ","П079"]
["П080 ","П080"]
["П081 ","П081"]
["П082 ","П082"]
["П083 ","П083"]
["П084 ","П084"]
["П085 ","П085"]
["П086 ","П086"]
["П087 ","П087"]
["П088 ","П088"]
["П089 ","П089"]
["П090 ","П090"]
["П091 ","П091"]
["П092 ","П092"]
["П093 ","П093"]
["П094 ","П094"]
["П095 ","П095"]
["П096 ","П096"]
[{"$f":"B98&\" \"&C98","v":"П097 "},"П097"]
[{"$f":"B99&\" \"&C99","v":"П098 "},"П098"]
[{"$f":"B100&\" \"&C100","v":"П099 "},"П099"]
[{"$f":"B101&\" \"&C101","v":"П100 "},"П100"]

{"sheet":"СП","index":6,"n_rows":501,"n_cols":3,"rows_kept":501,"cut":false,"hidden":false,"merged":[]}
["N","Наименование продукции","Отпускная цена реализации"]
[{"$f":"\"*\"&C2&\"*\"&\" \"&B2","v":"** 0"},0]
["*1000* Брюки","Брюки",1000]
["*300* БТовар7","БТовар7",300]
["*121* ЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖ","ЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖЖ",121]
["** ИРИНА","ИРИНА"]
["*1400* Костюм1","Костюм1",1400]
["** НАТАЛЬЯ","НАТАЛЬЯ"]
["*10* Носовой платок","Носовой платок",10]
["*100* ОООООООООООООООООООО","ОООООООООООООООООООО",100]
["*150* Плавки мужские","Плавки мужские",150]
["*120* Полотенце махровое","Полотенце махровое",120]
["*1800* ПППП","ПППП",1800]
["*1200* Спортивный костюм женский","Спортивный костюм женский",1200]
["*2700* Спортивный костюм мужской","Спортивный костюм мужской",2700]
["*15* Товар1","Товар1",15]
["*5* Товар3","Товар3",5]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
[{"$f":"\"*\"&C66&\"*\"&\" \"&B66","v":"** "}]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
[{"$f":"\"*\"&C130&\"*\"&\" \"&B130","v":"** "}]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
[{"$f":"\"*\"&C194&\"*\"&\" \"&B194","v":"** "}]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
[{"$f":"\"*\"&C258&\"*\"&\" \"&B258","v":"** "}]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
[{"$f":"\"*\"&C322&\"*\"&\" \"&B322","v":"** "}]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
[{"$f":"\"*\"&C386&\"*\"&\" \"&B386","v":"** "}]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
[{"$f":"\"*\"&C450&\"*\"&\" \"&B450","v":"** "}]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]
["** "]

{"sheet":"Шаблоны","index":7,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":true,"merged":[[1,0,1,1]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C2:N2)","v":0}]
[]
[null,0]
[]
[null,{"$f":"VLOOKUP(A6,СП!$A$2:$C$501,2,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A6,СП!$A$2:$C$501,3,0)","v":{"$error":"#N/A"}},{"$f":"C6*D6","v":{"$error":"#N/A"}},0,0,0,0,0,{"$f":"F6+G6+H6+I6+J6","v":0},{"$f":"E6-K6","v":{"$error":"#N/A"}},{"$f":"IF(L6<0,\"УБЫТОК\",\"ДОХОД\")","v":{"$error":"#N/A"}}]