{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Справка","Учет доходов и расходов"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":2,"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":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
["Здравствуйте, уважаемый Пользователь!",null,null,null,null,null," "]
[]
["Этот файл содержит программный код, который АВТОМАТИЧЕСКИ считает Ваши суммарные доходы и расходы."]
["Для выполнения программы в вашем Microsoft Excel должны быть включены макросы."]
[]
["Как включить макросы в Excel?",null,null,null,null,null," "]
["1) При открытии файла. "]
["Если при открытии файла выдается предупреждение системы безопасности о том, что объект содержит потенциально опасное "]
["содержимое и макросы отключены, их нужно включить. Если такого сообщения нет, нажмите кнопку \"Макросы включены. Начать работу!\" ниже:"]
[]
[]
[]
["Если макросы не включить, программный код работать не будет."]
[]
["Для включения макросов нужно нажать кнопку 'Параметры' рядом с предупреждением системы безопасности в верхней части экрана, "]
["затем в открывшемся диалоговом окне поставить флажок 'Включить это содержимое' (см.изображения ниже)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"или"]
[]
[]
[]
[]
[]
["2) Через меню Excel (если файл уже открыт): "]
["Кнопка Office:"]
[]
[]
[]
[]
[]
[]
[]
["Далее: \"Параметры Excel - Центр управления безопасностью - Параметры центра управления безопасностью - Параметры макросов - Включить макросы\""]
[]
["Если макросы включить не удается, обратитесь к справочной системе (клавиша F1) или к специалисту по установке ПО"]
[]
[]
[null,"Что дальше? Создаем таблицу учета доходов и расходов"]
["1.","Внесите типы Ваши доходов и расходов в строку заголовков (строка 3)"]
["2.","Внесите Ваши данные за соответствующие даты"]
["3.","Нажмите кнопку \"Подвести итоги…\""]
["4. ","Детализируйте отчет по годам, месяцам, неделям и дням, нажимая"]
[null,"на соответствующую кнопку под заголовком \"Детализация отчета\""]
["5.","Добавляйте новые типы доходов и расходов. Для этого:"]
[null,"а) Нажмите кнопку \"Удалить детализазцию\""]
[null,"б) Внесите нужные данные"]
[null,"в) Нажмите кнопку \"Подвести итоги…\""]

{"sheet":"Учет доходов и расходов","index":1,"n_rows":69,"n_cols":34,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,5,1,15],[0,5,0,7],[1,16,1,31],[1,0,1,4],[68,0,68,4]]}
[null,null,null,null,null,"Детализация отчета:",null,null,null,null,null,null,null,null,null,null,{"$f":"\"Сегодня: \"","v":"Сегодня: "},{"$f":"TODAY()","v":"2016-09-20"}]
["Учет доходов и расходов",null,null,null,null,"Типы доходов",null,null,null,null,null,null,null,null,null,null,"               Типы расходов"]
["Год","Месяц","Неделя года","День недели","Дата","Выручка","Реклама","Другое",null,null,null,null,null,null,null,"ИТОГО \nдоход","Зарплата","Налоги на з/п","Налог на прибыль","Аренда","Реклама","Связь ",null,null,null,null,null,null,null,null,null,"ИТОГО \nрасход","Итого \nДоход - Расход","Комментарий"]
[2016,"сентябрь","38 неделя","пн","2016-09-12",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F4:O4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q4:AE4)","v":0},{"$f":"P4-AF4","v":0}]
[2016,"сентябрь","38 неделя","вт","2016-09-13",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","38 неделя","ср","2016-09-14",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","38 неделя","чт","2016-09-15",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","38 неделя","пт","2016-09-16",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F8:O8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q8:AE8)","v":0},{"$f":"P8-AF8","v":0}]
[2016,"сентябрь","38 неделя","сб","2016-09-17",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q9:AE9)","v":0},0]
[2016,"сентябрь","38 неделя","вс","2016-09-18",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","39 неделя","пн","2016-09-19",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","39 неделя","вт","2016-09-20",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","39 неделя","ср","2016-09-21",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","39 неделя","чт","2016-09-22",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","39 неделя","пт","2016-09-23",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","39 неделя","сб","2016-09-24",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","39 неделя","вс","2016-09-25",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","40 неделя","пн","2016-09-26",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","40 неделя","вт","2016-09-27",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","40 неделя","ср","2016-09-28",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","40 неделя","чт","2016-09-29",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"сентябрь","40 неделя","пт","2016-09-30",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","40 неделя","сб","2016-10-01",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","40 неделя","вс","2016-10-02",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","41 неделя","пн","2016-10-03",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","41 неделя","вт","2016-10-04",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","41 неделя","ср","2016-10-05",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","41 неделя","чт","2016-10-06",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","41 неделя","пт","2016-10-07",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","41 неделя","сб","2016-10-08",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","41 неделя","вс","2016-10-09",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","42 неделя","пн","2016-10-10",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","42 неделя","вт","2016-10-11",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","42 неделя","ср","2016-10-12",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","42 неделя","чт","2016-10-13",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","42 неделя","пт","2016-10-14",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","42 неделя","сб","2016-10-15",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","42 неделя","вс","2016-10-16",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F38:O38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","43 неделя","пн","2016-10-17",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F39:O39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","43 неделя","вт","2016-10-18",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F40:O40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","43 неделя","ср","2016-10-19",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","43 неделя","чт","2016-10-20",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","43 неделя","пт","2016-10-21",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","43 неделя","сб","2016-10-22",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","43 неделя","вс","2016-10-23",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","44 неделя","пн","2016-10-24",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","44 неделя","вт","2016-10-25",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","44 неделя","ср","2016-10-26",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","44 неделя","чт","2016-10-27",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","44 неделя","пт","2016-10-28",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","44 неделя","сб","2016-10-29",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","44 неделя","вс","2016-10-30",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"октябрь","45 неделя","пн","2016-10-31",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","45 неделя","вт","2016-11-01",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","45 неделя","ср","2016-11-02",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","45 неделя","чт","2016-11-03",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","45 неделя","пт","2016-11-04",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"P57-AF57","v":0}]
[2016,"ноябрь","45 неделя","сб","2016-11-05",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","45 неделя","вс","2016-11-06",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","46 неделя","пн","2016-11-07",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","46 неделя","вт","2016-11-08",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","46 неделя","ср","2016-11-09",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","46 неделя","чт","2016-11-10",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2016,"ноябрь","46 неделя","пт","2016-11-11",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[]
[]
["Полная версия файла на vExcele.ru"]