Serhii D.
Rating
Skills and abilities
Programming
Services
Portfolio
-
FIFO
Desktop AppsFIFO application in PowerApps
-
The Power BI Dashboard
Data ProcessingData analysis and the creation of a dashboard in Power BI. The data is uploaded through the API.
-
Graphics in Excel
Data ProcessingJust different graphics in Excel made by me ever for different projects, dashboards or just for learning purposes.
-
Excel program for storage accounting
Desktop AppsExcel-based program to account for the manual and electrical tools of a large construction company operating in the energy sector.
The program allows you to track which tool, when and in what amount it was issued to the employee. Accounting of the written instrument. It allows you to quickly see where and what it is. Also, the program has the function of accounting certification and technical examination of special tools and informs the user of the approaching end date of the importance of such a certificate.
-
Excel Power Pivot data model
Data ProcessingFrom the database, tables are uploaded completely different in terms of information and structure. Power Pivot has created a data model, and a number of measures have been written in the DAX language. This allows different data structures to create a single common summary table and have all the important information in one report.
-
Excel Program for Product Accounting
Desktop AppsExcel-based program to account for the warehouse of a company that is engaged in making different types of wood packaging. Completed products are ordered in whole sets from the manufacturer (5 suppliers). Then in the warehouse everything is discompleted and different elements are sent to different contractors (about 15) for processing (sliping, painting, emblematization, etc.). Initially the report was in the register.
The program allows you to account orders with the assignment of the party number. It then allows you to break the set into elements without losing the link to the party number. Watch what the contractor is and what is in the warehouse. Completion of delivery, complaint - all is also fixed in the program.
… All input data, as well as settings, are set by the user.
-
Excel program for painting
Desktop AppsThe Excel-based program for painting the interior details of the car. The operator on the drawing of the data from the painting camera introduces in the base all the variants of painted details as well as the number of details that the robot collapsed and married. This is the way to monitor and analyze evacuations. The program allows you to generate several types of reports. Also, each detail shows the barcode that the operator scans and the data is entered into SAP. For convenience, each detail is displayed visually, all data is also entered by the operator on the sensor monitor.
-
Excel to recognize details
Desktop AppsIn the manufacturing plant, the operator places the details for installation by scanning them in sequence in accordance with the customer's order. After scanning, the data is stored in the Excel file.
The installation line operator, by extracting the details from the container, knows which components to be installed on that detail depending on the model.
… Due to the impossibility of hanging the monitor at the eye level in the app there is a voice recognition feature of the detail model. There is also the option of choosing the interface language.
-
Excel program for ordering materials from the warehouse
Desktop AppsExcel-based program for ordering materials from the warehouse in the manufacturing plant.The program is installed on different workstations in the manufacturing plant creating a whole network of such files.If it is necessary to fill in the necessary materials for production, the order from the file is sent via WI-FI to the ZEBRA mobile printer, which is located in the cabin of the wire chargers or at the warehouse worker.The paid label shows the logistics staff where, what and in what amount to deliver.The logistics department has one main file in which it manages the data, i.e. the link numbers, the attachment of goods to the department, the attachment of goods to the printer (some of them) on which the label should be printed, etc.All files are connected with each other via Power Query.Thanks to this, the logistics department can connect to all files at any time and download the data about all orders.Production in turn, in this way, connects to the main file, and after pressing the button "Update logistics data" immediately updates all data from the warehouse.
-
Excel for storing palettes in storage
Desktop AppsExcel-based program for a small palette storage. The program supports a screenshots scanner. When receiving the palette to the warehouse, it generates the palette number with a strip code with this number. Connect the palette to a specific location in the warehouse (automatically or manually). During the release of the palette from the warehouse removes it from the location. The receipt-transmission account of the European Palette. The stored data enables you at any time to withdraw any report, see the state of the stock and the status of all actions for the palettes that have been taken to the stock.
Reviews and compliments on completed projects 38
Great job on the assigned task. I recommend.
27 November 2024
48 USD
Optimization and functional improvement of the Excel spreadsheet
Working with Sergey is always a pleasure! He not only completes tasks quickly and professionally but also suggests improvements that I hadn't even considered. This time, the result exceeded my expectations — everything was done clearly, conveniently, and with attention to all the details.
In the future, I plan to turn to Sergey for the refinement of other tables, as I am confident in his skills and attention to detail. Thank you very much for your help and quality work!
22 November 2024
62 USD
Optimization of Excel spreadsheet for inventory accounting of provisions on the ship
Sergey did an excellent job! Communication was easy, and all my wishes were taken into account. I really appreciate your attention to detail and patience during the work process. I will definitely reach out again if needed!
12 June 2023
24 USD
The work done
It’s good, I’ve got it, and I’ll be.
14 March 2023
14 USD
Additional file settings
Everything works! I will turn again.
27 February 2023
91 USD
Create 4 files from the main file
Sergey knows his thing. professionally performed,
10 January 2023
36 USD
Excel - Data analysis task solution
Very positive experience! I can recommend Sergey as an excellent data processing specialist in Excel.
The task was not trivial, the data is loaded from external sources, with complex logic, but it all got five with a plus!
1 April 2022
6 USD
Find an error in the Excel document.
Everything is fine, thank you very quickly.
22 March 2022
96 USD
I need a calculator program to fix the discount.
A great executive. Fast introduction of the right. Everything is fast and clear. thank you.
I recommend cooperation.
8 February 2022
5 USD
From PDF to Google tables
Excellently performed work. The most important thing is the lightning time.
4 February 2022
72 USD
Based on Excel
Sergey did everything well, the project required some improvements because. In the process of checking I had new tasks in my head, which Sergey treated greatly and fulfilled my wishes. I recommend Sergey to perform such tasks.
22 January 2022
84 USD
Настроитъ автоматический отчет для гугл страницы (dynamic dashboard)
A great specialist with great patience.
Everything in time and more than expected.
21 January 2022
7 USD
Create a diagram in Excel
Everything was great, Sergey studied all the nuances and quickly completed the work!
17 January 2022
19 USD
Парсинг файла PDF
Thank you, you did everything clearly, I didn’t even give the TK correctly, but you did everything smoothly and cool. Thank you
9 January 2022
6 USD
Удалить строки по стоп словам из списка в Notepad++ 2
Everything is perfectly done! Thank you !
3 January 2022
36 USD
Holiday Planner in Excel and Working Schedule
Very pleased with cooperation. Rapid contact and quick execution of work
31 December 2021
10 USD
Formule of Measure
The project was done very well and timely.
24 December 2021
15 USD
You need to realize the account of the product in Google tables, you need what it would be:
Everything was done clearly, quickly, professionally. I am very pleased that I received answers to all the questions in a kind form, and reasonable advice and their implementation gave a great result!
| Response review
22 December 2021
36 USD
Excel Specialist to Create a Template File with a Base
Everything went well, I'll be glad to work with Sergey.
14 December 2021
60 USD
Excel Project
Great work!
He is a professional who knows his work 100%.
Thank you !
11 December 2021
10 USD
Conversion of Excel Document
Qualitatively and in time.
| Response review
10 December 2021
24 USD
PC Generator from Exel (Macros)
Thank you ! satisfied with work. The project is carried out in accordance with our deadlines and all our wishes.
29 November 2021
12 USD
The PowerBI Project
Everything is done quickly and quality. Sergey was able to do what other performers could not do. Thank you greatly! I recommend !
15 November 2021
14 USD
Автоматизация Ексель
Задание выполнено в сроки согласно требований. Исполнитель предложил дополнительные варианты решения задачи. Рекомендую к сотрудничеству.
11 November 2021
7 USD
Optimization of Google Sheets Excel
The task is performed in time and in accordance with the TZ. I recommend cooperation!
4 November 2021
6 USD
Task by Excel
Excellent performers, they did everything quickly and very well! Just about Excel! I recommend it!!The !
| Response review
14 October 2021
5 USD
Написать 3 формулы ВПР Excel — персональный проект для Сергія Дрюкова
Самый быстро выполненный проект на фрилансханте) Рекомендую исполнителя: шарит
30 September 2021
5 USD
Create a drop-down list of Excel
I am very pleased with the result of Sergey’s work in Excel.
This specialist took for a complex work that is solved by macros, which was not suitable for me as the document was planned to be used in the browser version.
In general, Sergey decided this with the help of multi-page formulas, all this time he carefully explained his steps and was really involved in the process with interest.
I recommend Sergey as a responsible executive!
27 September 2021
7 USD
Excel specialist for macro writing
Switch and good. Pleased with the work and the result.
20 September 2021
12 USD
Exel Translation of the file from ukr to Russian
I am pleased with the cooperation, of course.
11 September 2021
7 USD
Модифицировать формулу EXEL
Оперативность выполнения заказа, отзывчивость и понимание ситуации, однозначно рекомендую к работе!
9 September 2021
24 USD
Города превратить в район и просклонять (510 строк)
Класс!! Большое спасибо за работу. Очень быстро и, что главное, качественно выполнено задание. Рекомендую.
| Personal | Response review
8 September 2021
7 USD
Нужно просклонять 50 названий районов по трём падежам (на ру языке) — персональный проект для Сергія Дрюкова
Все четко и быстро. Большое спасибо.
| Personal | Response review
8 September 2021
6 USD
Selection of data from Excel
Operational execution of the order, a literary approach, clarification of things not described in the TZ, I recommend to work!
| Response review
6 September 2021
5 USD
Translation of the catalogue in the Exsel table from Chinese to Ukrainian.
Everything is done quickly and efficiently, I recommend!!The !
3 September 2021
31 USD
Converter of Excel to VBA code
Speed of performance and professionalism at a high level + responsibility, adequacy. I hope for further cooperation. A good evening. A great human thanks. Before the meeting.
| Response review
24 August 2021
7 USD
Macro for Excell tables - removal of line under condition
greatly ! Quick and quality written very necessary macros - now I'm happy!
11 August 2021
7 USD
Making the macro filter of the dashboard tables
The project is done in time and satisfied with the work.
Activity
Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
---|---|---|---|---|---|
Universal Excel file for task planning and control.
|
|||||
Power apps aplication
272 USD
|
|||||
Table for production and procurement planning.
48 USD
|
|||||
Sign
23 USD
|
|||||
Work with Excel. Excel Macro
24 USD
|
|||||
Create a template for inventory accounting in Excel
72 USD
|
|||||
Creating a Google or Excel spreadsheet
119 USD
|
|||||
Google Sheets (add additional formulas and edits to the table) so that the indicators are summarized correctly.
84 USD
|
|||||
Excel spreadsheet
23 USD
|
|||||
Creating a Google Sheets table with formulas for row calculations and output to the dashboard
119 USD
|