{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Задача","Подсчёт","29.11","29.11 (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," Нужно ещё чтобы после этого сверялись ячейки $F17 и $J17 в диапазоне =$F$17:$F$100;$J$17:$J$100 и если в ячейке $J17 есть число, то ячейка $F17 должна очистится.\u000b\u000b"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"как прописать так что бы лист копировался и вставал сразу за предыдущим (а не вторым в списке)"]

{"sheet":"Подсчёт","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,0,20,0],[17,3,20,3],[5,3,10,3],[0,0,0,1],[1,1,1,2],[2,1,2,2],[5,0,10,0],[11,0,12,0],[11,3,12,3],[13,0,14,0],[13,3,14,3],[15,0,15,1],[15,2,15,3],[4,0,4,2]]}
["Расчетный период"]
["Точка"]
["Выручка",{"$f":"SUM('Подсчёт:29.11'!I3)","v":0}]
[null,null,null,"Сумма"]
["Все расходы",null,null,{"$f":"SUM(D6:D15)","v":0}]
["Расходы","Аренда",null,{"$f":"SUM(C6:C11)","v":0}]
[null,"Ком. услуги"]
[null,"ЗП"]
[null,"Интернет + Телефон"]
[null,"Программа"]
[null,"Эквайринг"]
["По товару","Себестоимость",null,{"$f":"SUM(C12:C13)","v":0}]
[null,"Амортизация"]
["Налоги","Вычеты",null,{"$f":"SUM(C14:C15)","v":0}]
[null,0.06]
["Чистая прибыль",null,{"$f":"B3-SUM(D6:D15)","v":0}]
[]
["Закуп","Бумага",null,{"$f":"SUM(C18:C21)","v":0}]
[null,"Расходники"]
[null,"Под заказ у партнеров"]
[null,"Товары"]

{"sheet":"29.11","index":2,"n_rows":64,"n_cols":21,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,5,0,6],[0,7,0,8],[0,9,0,12],[0,16,0,18],[4,7,4,8],[4,10,4,12],[5,6,5,8],[5,10,5,12],[2,4,2,7],[2,10,2,11],[3,4,3,7],[3,10,3,11],[14,5,15,5],[14,6,15,6],[14,7,15,8],[14,9,14,11],[9,6,9,7],[9,9,9,11],[10,2,10,5],[10,6,10,7],[10,9,10,11],[11,2,11,5],[11,6,11,7],[11,9,11,11],[8,8,11,8],[8,9,8,11],[9,2,9,5],[14,0,15,4],[18,14,19,16],[18,19,18,20],[19,17,19,18],[19,19,19,20],[20,14,35,14],[20,15,25,15],[26,15,31,15],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,1,25,1],[24,2,24,3],[25,2,25,3],[26,1,35,1],[26,2,30,2],[30,3,30,4],[31,2,35,2],[32,15,35,15],[35,3,35,4],[36,16,36,20],[36,1,37,1],[36,2,36,3],[37,16,37,20],[37,2,37,3],[61,2,63,3],[65,2,65,3],[0,0,0,4],[1,0,1,12],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,4],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[56,0,58,1],[59,0,59,1],[6,0,6,12],[7,0,7,1],[8,0,11,1],[12,0,12,5],[13,0,13,12],[12,6,12,7],[12,8,12,11],[7,2,7,5],[7,6,7,7],[7,9,7,11],[8,2,8,5],[8,6,8,7],[61,0,63,1],[64,0,64,1],[65,0,65,1],[16,0,17,3],[18,0,18,4],[19,0,20,3],[21,0,37,0],[38,0,42,2],[43,0,48,3],[60,0,60,1],[52,2,53,3],[54,2,54,3],[55,2,55,3],[49,0,51,3],[52,0,55,1],[21,1,23,1]]}
["Дата:",null,null,null,null,"2023-11-29",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,"Номинал","Количество","Сумма",{"$f":"SUM(S3:S15)","v":7228},{"$f":"E4+F6","v":7228}]
["Касса на начало дня",null,null,null,3799,null,null,null,"Приход",4600,"Выручка на начало дня",null,3000,null,null,null,5000,null,{"$f":"Q3*R3","v":0},null,{"$f":"T2-U2","v":0}]
["Касса на конец дня",null,null,null,{"$f":"E3+E5-J6-G13","v":7228},null,null,null,"Расход",{"$f":"SUM(G8:H12,M8:M12)","v":71},"Выручка на конец дня",null,{"$f":"M3+J6-M13","v":3000},null,null,null,2000,1,{"$f":"Q4*R4","v":2000}]
["нал",null,null,null,3500,"безнал",1100,"сумма прихода",null,{"$f":"E5+G5","v":4600},null,null,null,null,null,null,1000,2,{"$f":"Q5*R5","v":2000}]
["плюс в кассе",null,null,null,null,null,"перенос наличных в выручку",null,null,null,null,null,null,null,null,null,500,3,1500]
["Расход",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,4,800]
["ЗП",null,null,null,null,null,null,null,"Инкассация",null,null,null,null,null,null,null,100,5,500]
["Расходы из кассы",null,"Минус в кассе",null,null,null,71,null,"Расходы из выручки",null,null,null,null,null,null,null,50,6,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,7,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,8,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,9,18]
["сумма расходов из кассы",null,null,null,null,null,{"$f":"SUM(G8:H12)","v":71},null,"сумма расходов из выручки",null,null,null,{"$f":"SUM(M8:M12)","v":0},null,null,null,1,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,0]
["Чек лист остатков",null,null,null,null,"Нужно заказать","В наличии","Минимальный остаток",null,"Заказ",null,null,"Приход",null,null,null,0.1,null,{"$f":"R15*Q15","v":0}]
[null,null,null,null,null,null,null,null,null,"Количество","Дата заказа","Дата поставки","Количество"]
["Офисная бумага",null,null,null,"А4",null,23.5,2,"уп целых"]
[null,null,null,null,"А3",null,3,0.5,"уп"]
["Запасной картридж",null,null,null,null,"+",1,1,"заправлен",null,null,null,null,null,"Заправка чернил",null,null,"Было","Стало","Минимальный остаток"]
["Файлы / \nМультифора",null,null,null,"А4",null,1.8,1,"уп целая",null,null,null,null,null,null,null,null,"* номер деления",null,"* заливать не больше 4 деления"]
[null,null,null,null,"А3",null,1,0.5,"уп",null,null,null,null,null,"Количество чернил в Epson","Ф 01","C 674",1,4,1.5,"делений"]
["Фотобумага","10х15 А6","глянец",null,"180г/м2",null,48,3,"уп целая",null,null,null,null,null,null,null,"M 674",2,3,1.5,"делений"]
[null,null,"матовая",null,"180г/м2",null,34,2,"уп целая",null,null,null,null,null,null,null,"LM 674",3,null,1.5,"делений"]
[null,null,"матовая (ф/д)",null,"190г/м2",null,5.2,0.5,"уп",null,null,null,null,null,null,null,"LC 674",4,null,1.5,"делений"]
[null,"15х21 А5","глянец",null,"230г/м2",null,0.9,0.2,"уп ",null,null,null,null,null,null,null,"Bk 674",1,2,1.5,"делений"]
[null,null,"матовая",null,"230г/м2",null,0.9,0.2,"уп",null,null,null,null,null,null,null,"Y 674",2,null,1.5,"делений"]
[null,"21х30 А4","глянец","1/ст","230г/м2 плотная",null,3.9,1,"уп целых",null,null,null,null,null,null,"Ф 02","C 674",null,null,1.5,"делений"]
[null,null,null,"2х/ст","220г/м2 плотная",null,1,0.5,"уп",null,null,null,null,null,null,null,"M 674",null,null,1.5,"делений"]
[null,null,null,"1/ст","130г/м2 \nтонкая",null,1,0.5,"уп",null,null,null,null,null,null,null,"LM 674",null,null,1.5,"делений"]
[null,null,null,"2х/ст","170г/м2 \nтонкая",null,1,0.5,"уп",null,null,null,null,null,null,null,"LC 674",null,null,1.5,"делений"]
[null,null,null,"самоклеящаяся",null,null,1.9,0.5,"уп",null,null,null,null,null,null,null,"Bk 674",null,null,1.5,"делений"]
[null,null,"матовая","1/ст","230г/м2 плотная",null,1.9,1,"уп целая",null,null,null,null,null,null,null,"Y 674",null,null,1.5,"делений"]
[null,null,null,"2х/ст","220г/м2 плотная",null,1,0.5,"уп",null,null,null,null,null,null,"С 03"]
[null,null,null,"1/ст","140г/м2 \nтонкая",null,1,0.5,"уп"]
[null,null,null,"2х/ст","170г/м2\nтонкая",null,1,0.5,"уп"]
[null,null,null,"самоклеящаяся",null,null,2,0.5,"уп"]
[null,"30х42 А3","глянец",null,"230г/м2",null,1,0.5,"уп ",null,null,null,null,null,"Замена картриджа",null,"* поставить \"1\" если меняли"]
[null,null,"матовая",null,"230г/м2",null,1,0.5,"уп",null,null,null,null,null,"Kyocera M2040dn"]
["Плёнка для ламинации",null,null,"А7","7,5х10,5",null,1,0.2,"уп"]
[null,null,null,"А6","10х15",null,0.9,0.5,"уп"]
[null,null,null,"А5","15х21",null,0.9,0.5,"уп"]
[null,null,null,"А4","21х30",null,0.9,0.5,"уп"]
[null,null,null,"А3","30х42",null,1,0.5,"уп"]
["Чернила полиграфия",null,null,null,"C 674",null,1,0.2,"бутылки"]
[null,null,null,null,"M 674",null,1,0.2,"бутылки"]
[null,null,null,null,"LM 674",null,1,0.2,"бутылки"]
[null,null,null,null,"LC 674",null,1,0.2,"бутылки"]
[null,null,null,null,"Bk 674",null,1,0.2,"бутылки"]
[null,null,null,null,"Y 674",null,1,0.2,"бутылки"]
["Конверты для \nупаковки фото",null,null,null,"С6 10х15","+",null,0.5,"коробки"]
[null,null,null,null,"С5 15х21","+",null,0.3,"коробки"]
[null,null,null,null,"С4 21х30","+",null,0.3,"коробки"]
["Брошюровка",null,"пружина метал",null,"7,9мм",null,100,10,"шт"]
[null,null,null,null,"14,3мм",null,null,5,"шт",100,"2023-11-23"]
[null,null,"ригель",null,"135мм",null,50,5,"шт"]
[null,null,"обложка пвх",null,"А4 150мкм",null,100,6,"шт"]
["Магниты",null,"винил",null,"0,7мм",null,0.9,0.2,"рулуна"]
[null,null,"акрил",null,"6,5х6,5",null,25,4,"шт"]
[null,null,"акрил",null,"8,4х5,9",null,25,4,"шт"]
["Брелки",null,"акрил",null,"5,6х4,0",null,100,5,"шт"]
["Альбом",null,"классика",null,"10х15/100",null,4,1,"шт"]
["Фоторамки",null,"деревянные",null,"10х15",null,8,4,"шт"]
[null,null,null,null,"15х21",null,4,2,"шт"]
[null,null,null,null,"21х30",null,4,2,"шт"]

{"sheet":"29.11 (2)","index":3,"n_rows":64,"n_cols":21,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,0,1,12],[0,0,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,12],[0,16,0,18],[2,0,2,3],[2,4,2,7],[2,10,2,11],[3,0,3,3],[3,4,3,7],[3,10,3,11],[4,0,4,3],[4,7,4,8],[4,10,4,12],[5,0,5,4],[5,6,5,8],[5,10,5,12],[6,0,6,12],[7,0,7,1],[7,2,7,5],[7,6,7,7],[7,9,7,11],[9,2,9,5],[9,6,9,7],[9,9,9,11],[10,2,10,5],[10,6,10,7],[10,9,10,11],[8,8,11,8],[8,9,8,11],[11,2,11,5],[11,6,11,7],[11,9,11,11],[12,0,12,5],[12,6,12,7],[12,8,12,11],[8,0,11,1],[8,2,8,5],[8,6,8,7],[13,0,13,12],[14,0,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,8],[14,9,14,11],[16,0,17,3],[18,0,18,4],[18,14,19,16],[18,19,18,20],[19,0,20,3],[19,17,19,18],[19,19,19,20],[20,14,35,14],[20,15,25,15],[21,0,37,0],[21,1,23,1],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,1,25,1],[24,2,24,3],[25,2,25,3],[38,0,42,2],[26,1,35,1],[26,2,30,2],[26,15,31,15],[30,3,30,4],[31,2,35,2],[32,15,35,15],[35,3,35,4],[36,1,37,1],[36,2,36,3],[36,16,36,20],[37,2,37,3],[37,16,37,20],[43,0,48,3],[49,0,51,3],[52,0,55,1],[52,2,53,3],[54,2,54,3],[55,2,55,3],[65,0,65,1],[65,2,65,3],[56,0,58,1],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,0,59,1],[59,2,59,3],[60,0,60,1],[60,2,60,3],[61,0,63,1],[61,2,63,3],[64,0,64,1]]}
[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,null,null,null,null,"Номинал","Количество","Сумма",{"$f":"SUM(S3:S15)","v":0},{"$f":"E4+F6","v":10728}]
["Касса на конец дня",null,null,null,7228,null,null,null,null,4600,"Выручка на конец дня",null,3000,null,null,null,null,null,{"$f":"Q3*R3","v":0},null,{"$f":"T2-U2","v":-10728}]
["Касса на конец дня",null,null,null,{"$f":"E3+E5-J6-G13","v":10728},null,null,null,"Расход",{"$f":"SUM(G8:H12,M8:M12)","v":0},"Выручка на конец дня",null,{"$f":"M3+J6-M13","v":3000},null,null,null,null,1,{"$f":"Q4*R4","v":0}]
[null,null,null,null,3500,null,1100,"сумма прихода",null,{"$f":"E5+G5","v":4600},null,null,null,null,null,null,null,2,{"$f":"Q5*R5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0]
["Расход",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0]
["сумма расходов из кассы",null,null,null,null,null,{"$f":"SUM(G8:H12)","v":0},null,"сумма расходов из выручки",null,null,null,{"$f":"SUM(M8:M12)","v":0},null,null,null,null,null,0]
[null,null,null,null,null,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,{"$f":"R15*Q15","v":0}]
[null,null,null,null,null,null,null,null,null,"Количество","Дата заказа","Дата поставки","Количество"]
["Офисная бумага",null,null,null,"А4",null,23.5,2,"уп целых"]
[null,null,null,null,"А3",null,3,0.5,"уп"]
["Запасной картридж",null,null,null,null,"+",1,1,"заправлен",null,null,null,null,null,"Заправка чернил",null,null,"Было","Стало","Минимальный остаток"]
["Файлы / \nМультифора",null,null,null,"А4",null,1.8,1,"уп целая",null,null,null,null,null,null,null,null,"* номер деления",null,"* заливать не больше 4 деления"]
[null,null,null,null,"А3",null,1,0.5,"уп",null,null,null,null,null,"Количество чернил в Epson","Ф 01",null,null,4,1.5,"делений"]
["Фотобумага","10х15 А6","глянец",null,"180г/м2",null,48,3,"уп целая",null,null,null,null,null,null,null,null,null,3,1.5,"делений"]
[null,null,"матовая",null,null,null,34,2,"уп целая",null,null,null,null,null,null,null,null,null,null,1.5,"делений"]
[null,null,"матовая (ф/д)",null,"190г/м2",null,5.2,0.5,"уп",null,null,null,null,null,null,null,null,null,null,1.5,"делений"]
[null,"15х21 А5","глянец",null,"230г/м2",null,0.9,0.2,"уп ",null,null,null,null,null,null,null,null,null,2,1.5,"делений"]
[null,null,"матовая",null,"230г/м2",null,0.9,0.2,"уп",null,null,null,null,null,null,null,null,null,null,1.5,"делений"]
[null,"21х30 А4","глянец","1/ст","230г/м2 плотная",null,3.9,1,"уп целых",null,null,null,null,null,null,"Ф 02",null,null,null,1.5,"делений"]
[null,null,null,"2х/ст","220г/м2 плотная",null,1,0.5,"уп",null,null,null,null,null,null,null,null,null,null,1.5,"делений"]
[null,null,null,"1/ст","130г/м2 \nтонкая",null,1,0.5,"уп",null,null,null,null,null,null,null,null,null,null,1.5,"делений"]
[null,null,null,"2х/ст","170г/м2 \nтонкая",null,1,0.5,"уп",null,null,null,null,null,null,null,null,null,null,1.5,"делений"]
[null,null,null,"самоклеящаяся",null,null,1.9,0.5,"уп",null,null,null,null,null,null,null,null,null,null,1.5,"делений"]
[null,null,"матовая","1/ст","230г/м2 плотная",null,1.9,1,"уп целая",null,null,null,null,null,null,null,null,null,null,1.5,"делений"]
[null,null,null,"2х/ст","220г/м2 плотная",null,1,0.5,"уп",null,null,null,null,null,null,"С 03"]
[null,null,null,"1/ст","140г/м2 \nтонкая",null,1,0.5,"уп"]
[null,null,null,"2х/ст","170г/м2\nтонкая",null,1,0.5,"уп"]
[null,null,null,"самоклеящаяся",null,null,2,0.5,"уп"]
[null,"30х42 А3","глянец",null,"230г/м2",null,1,0.5,"уп ",null,null,null,null,null,"Замена картриджа",null,"* поставить \"1\" если меняли"]
[null,null,"матовая",null,"230г/м2",null,1,0.5,"уп",null,null,null,null,null,"Kyocera M2040dn"]
["Плёнка для ламинации",null,null,"А7","7,5х10,5",null,1,0.2,"уп"]
[null,null,null,"А6","10х15",null,0.9,0.5,"уп"]
[null,null,null,"А5","15х21",null,0.9,0.5,"уп"]
[null,null,null,"А4","21х30",null,0.9,0.5,"уп"]
[null,null,null,"А3","30х42",null,1,0.5,"уп"]
["Чернила полиграфия",null,null,null,"C 674",null,1,0.2,"бутылки"]
[null,null,null,null,"M 674",null,1,0.2,"бутылки"]
[null,null,null,null,"LM 674",null,1,0.2,"бутылки"]
[null,null,null,null,"LC 674",null,1,0.2,"бутылки"]
[null,null,null,null,"Bk 674",null,1,0.2,"бутылки"]
[null,null,null,null,"Y 674",null,1,0.2,"бутылки"]
["Конверты для \nупаковки фото",null,null,null,"С6 10х15","+",null,0.5,"коробки"]
[null,null,null,null,"С5 15х21","+",null,0.3,"коробки"]
[null,null,null,null,"С4 21х30","+",null,0.3,"коробки"]
["Брошюровка",null,"пружина метал",null,"7,9мм",null,100,10,"шт"]
[null,null,null,null,"14,3мм",100,null,5,"шт",100,"2023-11-23"]
[null,null,"ригель",null,"135мм",null,50,5,"шт"]
[null,null,"обложка пвх",null,"А4 150мкм",null,100,6,"шт"]
["Магниты",null,"винил",null,"0,7мм",null,0.9,0.2,"рулуна"]
[null,null,"акрил",null,"6,5х6,5",null,25,4,"шт"]
[null,null,"акрил",null,"8,4х5,9",null,25,4,"шт"]
["Брелки",null,"акрил",null,"5,6х4,0",null,100,5,"шт"]
["Альбом",null,"классика",null,"10х15/100",null,4,1,"шт"]
["Фоторамки",null,"деревянные",null,"10х15",null,8,4,"шт"]
[null,null,null,null,"15х21",null,4,2,"шт"]
[null,null,null,null,"21х30",null,4,2,"шт"]