Creating a report in Excel
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.
Applications 1
Client's review of cooperation with Andrey Repin
Creating a report in ExcelThank 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%
Freelancer's review of cooperation with Konstantin Gavryushin
Creating a report in ExcelConstantine 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.
Current freelance projects in the category Desktop Apps
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 6 days 16 hours back ∙ 10 proposals |
Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food)
22 USD
We are looking for an experienced team or a Middle/Senior Android developer (possibly with Full-stack skills) to create proprietary software for self-service kiosks for a fast food retail chain. Currently, our terminals operate on a ready-made cloud integrator, but we are… Content Management Systems, Desktop Apps ∙ 11 days 12 hours back ∙ 23 proposals |