Database (payment) (Power Query + Macro)
Source data: a table by employees (date, order, route, sum)
TZ: It is necessary to create a report for each employee in a specific month.In big tables (1) fill out all the work they have done (copy of the line from the general), in small (2) calculate the amount for each week, in (3) calculate the GDP taking into account taxes, etc.All this information should be placed in the monthly report.Information is constantly updated.Complete: a request for a general table is formed through Power Query and uploaded to a separate sheet where staff columns are added.(We will continue to work with it.The client works only with the starting table.Each employee is dynamically attributed to indices, according to the month.On the page with the report we form a table 1 and according to the index work with the massives (so we form an automatic filling of lines with information on each manager).Furthermore, for the next manager, it is only enough to copy the range and enter a new name.In Table 2, we calculate the number of the week, according to the month, and calculate the amount.Table 3 is a mini calculator.It is calculated with regard to prizes and taxes.This list forms dynamic reports.According to this, this information is carried out each month separately.Macro 1 - Updates the request (if any information about managers has been added to the starting table).Macro 2 - records the values (not a full copy) of the sheet to a new sheet.If the list with the right month exists, it re-records the data.If not, it creates a sheet with the name of the month and records the information.The customer can work and change something in it.Thus, the client only adds information about managers to the general output table, on the report forming page updates the request and forms (the button) the report.All actions are automated.
TZ: It is necessary to create a report for each employee in a specific month.In big tables (1) fill out all the work they have done (copy of the line from the general), in small (2) calculate the amount for each week, in (3) calculate the GDP taking into account taxes, etc.All this information should be placed in the monthly report.Information is constantly updated.Complete: a request for a general table is formed through Power Query and uploaded to a separate sheet where staff columns are added.(We will continue to work with it.The client works only with the starting table.Each employee is dynamically attributed to indices, according to the month.On the page with the report we form a table 1 and according to the index work with the massives (so we form an automatic filling of lines with information on each manager).Furthermore, for the next manager, it is only enough to copy the range and enter a new name.In Table 2, we calculate the number of the week, according to the month, and calculate the amount.Table 3 is a mini calculator.It is calculated with regard to prizes and taxes.This list forms dynamic reports.According to this, this information is carried out each month separately.Macro 1 - Updates the request (if any information about managers has been added to the starting table).Macro 2 - records the values (not a full copy) of the sheet to a new sheet.If the list with the right month exists, it re-records the data.If not, it creates a sheet with the name of the month and records the information.The customer can work and change something in it.Thus, the client only adds information about managers to the general output table, on the report forming page updates the request and forms (the button) the report.All actions are automated.
Poltava 
Available for hire