Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak

Yan Nakonechny

Sleeping face
Yan hasn't been on the service for a long time.
But on Freelancehunt, there are also 471 freelancers in category Desktop Apps, who will professionally and timely complete a project of any complexity.

Ukraine Kyiv, Ukraine
5 years back
Available for hire available for hire
7 Safes completed
8 years back
8 clients
on the service 9 years

Rating

Successful projects
100%
Average rating
No data
Rating
225
4 projects
Desktop Apps
3 projects
Web Programming
1 project
Enterprise Resource Planning (ERP)
1 project
Data Parsing

Skills and abilities

Programming

Portfolio


  • Analysis in Excel (VBA)

    Desktop Apps
    Create 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 Apps
    The 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 Apps
    Task: 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 Apps
    Task: 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

Quality
Professionalism
Cost
Contactability
Deadlines

I recommend Jan as a great makro spice for the excels.
It our company to save a lot of time.

Quality
Professionalism
Cost
Contactability
Deadlines

Everything is done pretty quickly and quality. The level of knowledge was pleased. I recommend cooperation.

Profile deleted | Response review

21 February 2017 5 USD
The Excel

Quality
Professionalism
Cost
Contactability
Deadlines

Explanation of tasks online by Skype, performing the work at the highest level.

Profile deleted | Safe Safe | Response review

Quality
Professionalism
Cost
Contactability
Deadlines

The work was done greatly. I recommend !

6 January 2017 6 USD
Template in Excel 2

Quality
Professionalism
Cost
Contactability
Deadlines

100% fast, accurate, understands from the first time, patient, high-level, high-level

Profile deleted | Safe Safe | Response review

Quality
Professionalism
Cost
Contactability
Deadlines

A great executive. Very grateful performance.

23 December 2016 9 USD
Examples based on Excel

Quality
Professionalism
Cost
Contactability
Deadlines

And again we worked with Jan, he personally understands me well and corrects everything quickly, sometimes even very quickly))
Thank you !The !

Profile deleted | Safe Safe | Response review

Quality
Professionalism
Cost
Contactability
Deadlines

The work is done in time and meets the TZ, quality.

2 December 2016 8 USD
Examples based on Excel

Quality
Professionalism
Cost
Contactability
Deadlines

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.)

Profile deleted | Safe Safe | Response review

Quality
Professionalism
Cost
Contactability
Deadlines

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!!

Profile deleted | Safe Safe | Response review

24 November 2016 5 USD
Additions to the PDF report

Quality
Professionalism
Cost
Contactability
Deadlines

As always, the work is done quality and timely!

22 November 2016 3 USD
Macro for the PDF report

Quality
Professionalism
Cost
Contactability
Deadlines

The second project was carried out quickly and efficiently. Very pleasant to work!

21 November 2016 7 USD
Macro for PDF reporting from Excel

Quality
Professionalism
Cost
Contactability
Deadlines

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
Нужен макрос 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