Yan Nakonechny
Rating
Skills and abilities
Programming
Portfolio
-
Analysis in Excel (VBA)
Desktop AppsCreate dashboards with analytical indicators selected by the customer. You can choose different sets: month, year, quarter, fiscal week, store, status with automatic restructuring of all charts and data. The data is imported from the customer system.
-
Map of the World with Excel (VBA)
Desktop AppsThe interactive map of the world with the bulk of countries depending on the desired indicator. It is possible to choose color and indicator.
-
Creating a reporting base + visualization + functions
Desktop AppsTask: Create a single reporting base for company management with the ability to operate from any company computer
Additional task: implementing the data mass prediction algorithm, automatic calculation ABC-XYZ analysis by various methods
The result: a single upgrade with the ability to select the report and manage it is created, the requested mathematical algorithms are prescribed, their stable work is done. All functions are as simple and understandable as possible, managing is easy and can literally be explained to any user in minutes.
…
#Excel #Macros #VBA #VisualBasicForApplications
-
Residual Distribution System in Excel (VBA)
Desktop AppsTask: Create from zero and automatize the mathematical residual re-distribution algorithm between trade facilities for equalization of goods.
The main complexity: to write the logic of how much and where to take and where to take, taking into account the economic essence (the smallest number of movements on collection, transportation)
Volume: up to 500 SKU at the same time, more than a hundred trading facilities.
There are additional settings, a step-by-step calculation is possible (to optimize the distribution manually)
… Result: Create files to send to each network store with instructions
#Excel #Macros #VBA #VisualBasicForApplications
Reviews and compliments on completed projects 13
25 July 2017
17 USD
Macro for the Excel Table
I recommend Jan as a great makro spice for the excels.
It our company to save a lot of time.
11 June 2017
18 USD
Identification of the same products in the EXCEL prizes
Everything is done pretty quickly and quality. The level of knowledge was pleased. I recommend cooperation.
![]()
21 February 2017
5 USD
The Excel
Explanation of tasks online by Skype, performing the work at the highest level.
![]()
| Response review
20 January 2017
2 USD
Create an edited Excel sheet from an image
The work was done greatly. I recommend !
6 January 2017
6 USD
Template in Excel 2
100% fast, accurate, understands from the first time, patient, high-level, high-level
![]()
| Response review
2 January 2017
23 USD
Implementation of calculation methods in the program
A great executive. Very grateful performance.
23 December 2016
9 USD
Examples based on Excel
And again we worked with Jan, he personally understands me well and corrects everything quickly, sometimes even very quickly))
Thank you !The !
![]()
| Response review
19 December 2016
2 USD
Write a macro for the Excel. The breakdown of data.
The work is done in time and meets the TZ, quality.
2 December 2016
8 USD
Examples based on Excel
Thanks to Jan in our company it became a little easier in terms of automation to work, now we have a magical table that considers a better person. Thank you very much, it was a pleasure to work.)
![]()
| Response review
30 November 2016
23 USD
Write an EXCEL-based table for calculation and order
I’ve always been jealous of people who can do such a project. For me it is a dark forest. It’s good that I found in it Jana, who actually, and did everything to us without any wire.
Thank you very much, it was great to work!!
![]()
| Response review
24 November 2016
5 USD
Additions to the PDF report
As always, the work is done quality and timely!
22 November 2016
3 USD
Macro for the PDF report
The second project was carried out quickly and efficiently. Very pleasant to work!
21 November 2016
7 USD
Macro for PDF reporting from Excel
Great work! Jan developed a macro to create a report in the PDF format in less than 2 days. He was always ready to help understand the file and make it really user-friendly. I recommend !
Activity
| Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Нужен макрос Excel, VBA
11 USD
|
|||||
|
VBA macros for calculating work volumes
10 USD
|
|||||
|
Excel склад товара и остатков
16 USD
|
|||||
|
Creating a database for reporting using VBA in Exel
18 USD
|
|||||
|
Data in Excel
6 USD
|
|||||
|
Reformate Excel Price List Data
11 USD
|
|||||
|
Нужны макросы под кнопки, для выпадающего списка с поиском и переходом
10 USD
|
|||||
|
change in the Promotional file of the Exel unit of the product measurement
18 USD
|
|||||
|
Підготовка прайсу для prom.ua та оптимізація роботи з прайсами
68 USD
|
|||||
|
Макрос "Выбросы"
23 USD
|