{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Справка","Учет доходов и расходов"],"not_rendered":{"charts":0,"images":11,"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":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[15,0,15,7]]}
[]
["Здравствуйте, уважаемый Пользователь!",null,null,null,null,null," "]
[]
["Этот файл содержит программный код, который АВТОМАТИЧЕСКИ считает Ваши суммарные доходы и расходы."]
["Для выполнения программы в вашем Microsoft Excel должны быть включены макросы."]
[]
["Как включить макросы в Excel?",null,null,null,null,null," "]
["1) При открытии файла. "]
["Если при открытии файла выдается предупреждение системы безопасности о том, что объект содержит потенциально опасное "]
["содержимое и макросы отключены, их нужно включить, нажав последовательно \"Разрешить редактирование\" и \"Включить содержимое\"."]
["Если такого сообщения нет, жмите кнопку ниже \"Макросы включены. Начать работу!\":"]
[]
[null,null,null,null,null," "]
[]
["Если макросы не включить, программный код работать не будет."]
["Как включить макросы, подскажет справка Microsoft или клавиша 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":"2018-07-28"}]
["Учет доходов и расходов",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Доход - Расход","Комментарий"]
[2018,"июль","30 неделя","сб","2018-07-28",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}]
[2018,"июль","30 неделя","вс","2018-07-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]
[2018,"июль","31 неделя","пн","2018-07-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]
[2018,"июль","31 неделя","вт","2018-07-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]
[2018,"август","31 неделя","ср","2018-08-01",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}]
[2018,"август","31 неделя","чт","2018-08-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,{"$f":"SUM(Q9:AE9)","v":0},0]
[2018,"август","31 неделя","пт","2018-08-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]
[2018,"август","31 неделя","сб","2018-08-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]
[2018,"август","31 неделя","вс","2018-08-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]
[2018,"август","32 неделя","пн","2018-08-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]
[2018,"август","32 неделя","вт","2018-08-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]
[2018,"август","32 неделя","ср","2018-08-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]
[2018,"август","32 неделя","чт","2018-08-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]
[2018,"август","32 неделя","пт","2018-08-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]
[2018,"август","32 неделя","сб","2018-08-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]
[2018,"август","32 неделя","вс","2018-08-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]
[2018,"август","33 неделя","пн","2018-08-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]
[2018,"август","33 неделя","вт","2018-08-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]
[2018,"август","33 неделя","ср","2018-08-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]
[2018,"август","33 неделя","чт","2018-08-16",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]
[2018,"август","33 неделя","пт","2018-08-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,0,0]
[2018,"август","33 неделя","сб","2018-08-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]
[2018,"август","33 неделя","вс","2018-08-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]
[2018,"август","34 неделя","пн","2018-08-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]
[2018,"август","34 неделя","вт","2018-08-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]
[2018,"август","34 неделя","ср","2018-08-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]
[2018,"август","34 неделя","чт","2018-08-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]
[2018,"август","34 неделя","пт","2018-08-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]
[2018,"август","34 неделя","сб","2018-08-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]
[2018,"август","34 неделя","вс","2018-08-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]
[2018,"август","35 неделя","пн","2018-08-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]
[2018,"август","35 неделя","вт","2018-08-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]
[2018,"август","35 неделя","ср","2018-08-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]
[2018,"август","35 неделя","чт","2018-08-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]
[2018,"август","35 неделя","пт","2018-08-31",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]
[2018,"сентябрь","35 неделя","сб","2018-09-01",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]
[2018,"сентябрь","35 неделя","вс","2018-09-02",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]
[2018,"сентябрь","36 неделя","пн","2018-09-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]
[2018,"сентябрь","36 неделя","вт","2018-09-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]
[2018,"сентябрь","36 неделя","ср","2018-09-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]
[2018,"сентябрь","36 неделя","чт","2018-09-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]
[2018,"сентябрь","36 неделя","пт","2018-09-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]
[2018,"сентябрь","36 неделя","сб","2018-09-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]
[2018,"сентябрь","36 неделя","вс","2018-09-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]
[2018,"сентябрь","37 неделя","пн","2018-09-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]
[2018,"сентябрь","37 неделя","вт","2018-09-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]
[2018,"сентябрь","37 неделя","ср","2018-09-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]
[2018,"сентябрь","37 неделя","чт","2018-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]
[2018,"сентябрь","37 неделя","пт","2018-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]
[2018,"сентябрь","37 неделя","сб","2018-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]
[2018,"сентябрь","37 неделя","вс","2018-09-16",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]
[2018,"сентябрь","38 неделя","пн","2018-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,0,0]
[2018,"сентябрь","38 неделя","вт","2018-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]
[2018,"сентябрь","38 неделя","ср","2018-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,{"$f":"P57-AF57","v":0}]
[2018,"сентябрь","38 неделя","чт","2018-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]
[2018,"сентябрь","38 неделя","пт","2018-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]
[2018,"сентябрь","38 неделя","сб","2018-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]
[2018,"сентябрь","38 неделя","вс","2018-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]
[2018,"сентябрь","39 неделя","пн","2018-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]
[2018,"сентябрь","39 неделя","вт","2018-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]
[2018,"сентябрь","39 неделя","ср","2018-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]
[]
[]
[]
[]
["Полная версия файла на vExcele.ru"]