Creating a report in Excel

Desktop Apps, Data Processing — incorrectly specified categories?

8 USD

Client's review of cooperation with Andrey Repin

Creating a report in Excel

8 USD

Thank you very much for the work. Andrei was a very pleasant person and was a very loyal person in the discussion process. Thank him for not refusing to participate in a kind of social project by giving up at the price. The order was performed qualitatively, before the declared deadline. Andrei was very careful to the details, nothing about the TZ had to explain further. The time was delayed for the tests, and a separate thanks to him for what he agreed to wait. I recommend 100%

5.0

Konstantin Gavryushin

Reciprocal Feedback

13 July 2022

Freelancer's review of cooperation with Konstantin Gavryushin

Creating a report in Excel

8 USD

Constantine was immediately scheduled TZ clearly, worked out without clarificing questions. Thank you for the project. They were closed in time after checking as agreed. I recommend the work.

5.0

Andrey Repin

Reciprocal Feedback

13 July 2022

Project translated automatically. Log in or register, to view the original Good day .The task is to organize the automatic creation of a report in the Excel book.The book is attached to the investment The report will be formed separately for each day.I will examine the various options for the implementation of the report, namely by means of macros or formulas.Characteristics of Excel: The book contains 4 lists: Flights.All the original data will be included on this list.The connection.The list organizes an interim report, based on the data that are placed on the Flight List.The report.This is a list in which it is necessary to obtain a report on the task described.The guide.This list contains a number of guidelines that are necessary to enter the data on the Flight list.The names of the guidelines correspond to (ident) the names of the columns in the Book of Flight.Establishment of the task (auto-creation of the report on the report list): This report is formed daily on the basis of the data entered on the Flight List.The following day the data on the Flights list will be updated (deleted) in manual mode.List of flights: The list contains the following columns: Commander of the crew, Time of departure, Time of landing, Duty, Type of flight, Time of day, Type of ship.Columns: Duty, Type of flight, Time of day, Type of ship - these are revealing lists.The data is submitted from the Book of Manual.In the columns: Flight Number, Flight, Flight ID - the current formulas are embedded.Also, a macro is organized on the outlet column.The essence of the macro is that after the data is entered and when any value is assigned in the columns Time of landing or Time of landing, cells that have a deviation of +- 1 minute or equal to the corresponding assigned value are painted.The work of the macro when organizing a report on the Report list must be saved.List of report: This list presents the structure of the report, which must be obtained on the basis of the data entered on the Flight List.On this list in column A except the lines that relate to the sum lines, all types of data should be drawn from the Flight list and preferably those types of vessels that participated only on that day.If a specific type of ship did not have any flights, it will not be displayed in the report.In column B, C, “Duty”, “Flight Type” respectively, the data from the corresponding columns on the Flight List must be taken. The tables “Day” and “Night” should be divided into the tables “Flights” and “Flights”.Flights are an indicator of the number of flights.For his calculation, the calculation column ID of the flight was provided on the Exit list.Flight is the total amount of time.These indicators should be taken from the column of the Flight list.I will recall again that this column has a formula.The sum lines for all types are sum values for all types of vessels.In principle, he tried to describe the task as in detail as possible.If there are questions ask.