There is a department with employees who fill out a spreadsheet every day in an excel file with the name of the activity and the amount of time spent on this activity:

Название деятельности | Кол-во часов Перебор книг | 5 Заполнение документации | 0.5 .........................| ...

Certain fields are summarized.

Each employee fills out his file and at the end of the month / week sends by mail / grid to the head of the department.

Required: calculate, display the number of time for each activity by all employees of the department at once, who fill in each file.

What is the best way to do this through excel? Or using php.

  • 2
    Get a normal system, like Redmine. - Kromster
  • one
    Take to the staff of the old-timekeeper. She will adjust accounting without any of these systems - Sergey

1 answer 1

Through Excel, the solution may be the following:

  1. Each employee is provided with a pre-formed template in MS Excel format (hereinafter Шаблон ), preferably with a single formalized list of Названий деятельности containing the following fields:

Сотрудник - Full Name the employee who provided the information;

Неделя - the number of the reporting week;

Название деятельности - description of the type of activity;

Кол-во часов - elapsed time.

For example:

Table of employee accounting activities

  1. Completed Шаблоны sent to the head of the department for the vault (mail / network);

  2. Шаблоны with information from employees are combined into a Общую таблицу отдела . To automate the merge, you can use the RDBMerge add- RDBMerge ;

For example, data for several employees in two weeks:

General table of the department for two weeks

  1. With the help of pivot tables based on the data of the Общей таблице отдела form all kinds of cuts.

For example:

Summary table

+ solutions

  • better option than nothing;
  • minimum required set of tools;
  • sufficient skills qualified user Excel;
  • flexibility in making changes in the number of Шаблона fields, etc .;
  • automatic calculation of the required indicators over time.

- solutions

  • problems with data aggregation due to incorrectness of filling in Шаблонов Employees;
  • a large proportion of manual operations to obtain a Общей таблицы отдела ;