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

Andrey Kruglyakov

Offer Andrey to work on your next project.

Ukraine Kyiv, Ukraine
3 days 20 hours ago
A little busy a little busy
4 Safe completed
5 years ago
6 Clients
registered for 10 years

Rating

Successful projects
100%
Average rating
There is no data
Rating
379
Application programming
Databases
3 projects
Application programming
1 project
Databases

Skills

Portfolio


  • Interactive map of Ukraine

    Application programming
    One of the tasks of visualization of accounting tasks.
    Excel's file, which using the data from the table, macroscodes the map of Ukraine with gradient colors by areas. The color of the paint and inscriptions on the map can be changed.
    Plus, the option is added for each area to enter a circular diagram or volume histogram depending on the input data. The color can also be changed.
    The input data can be made in the form of a summary table, then there is the possibility of adding filters to the map and viewing the graphs on any product/plane/size in time, etc.
  • Tests

    Application programming
    Tests — example of a freelancer's portfolio in the category Application programming
    A dozen tests with different results calculation algorithms for a group of respondents.
    Everyone can go through any of the tests at the same time, for each one a personal result is fixed.by Excel)
  • Data Protection in Excel

    Application programming
    It does not display data until macros are enabled.
    If the file is open in reading, then:
    Cover the Excel tape.
    Cover all contextual menus
    - Disable hot copying/cutting/printing data key
    - Disable events Print/Save
    Monitor the PrintScreen button and does not allow the screen to be taken.
    - Tracks attempts to violate security and records them into the log file
    Do not extend these restrictions to other parallelly open books.
    The lists in the book can be as much as you want and can be called as much as you want.
    - Adapted to x86 and x64 for Excel 2003-2016
  • Working task of the laboratory

    Application programming
    From the loaded list of samples the laboratory task is formed by assigning 1 or more cells.
    After allocating cells and pressing the "Take sample to task" button, the selected data on a specific algorithm will enter the printing form.
    Transmitted data is distinguished by color.
    For navigation convenience, the changed fields are equipped with falling lists, including. A field with a date.
    After completing the filling and printing of the form, you can clean it all with one button.
    There is a possibility to cancel the last wrong act.
  • Stock Exchange Monitor

    Application programming
    Stock Exchange Monitor — example of a freelancer's portfolio in the category Application programming
    The #Excel file, created as a trading assistant on the #MWB stock exchange.
    According to the given algorithm in the online mode, the data is compared between the scoring table and the scoring table, with the purpose of identifying a large hidden participant.
    All the automatization is done on #VBA. #SQL requests are used to address tables.
    The result on the screen.
    There is the possibility to set the start in the cycle and change the time interval for the analysis.

Reviews and compliments on completed projects 6

25 October 2018 3 USD
Добавление предпоследнего столбца по кнопке

Quality
Professionalism
Price
Availability
Terms

Работа выполнена очень быстро. Андрей - замечательный человек и приятный собеседник, который не просто профессионально выполняет свою работу, но еще и подскажет как довести до ума уже существующие доработки. Однозначно рекомендую к сотрудничеству.

Quality
Professionalism
Price
Availability
Terms

Thank you for work. Completed quickly and professionally.

Quality
Professionalism
Price
Availability
Terms

Thank you very much Andrea!
Very quickly prescribed me a Macro that will save me a lot of time!
I recommend !

Quality
Professionalism
Price
Availability
Terms

A great specialist. It’s all very fast, quality and professional.

Quality
Professionalism
Price
Availability
Terms

Andrei is pleased with the work. He demonstrated the initiative, proposed options for the solution of the assigned task to choose the optimal solution. Despite the small amount of information in the TZ performed the work quickly, quality exceeding expectations.
We can be called a professional in this field.
A huge thanks! I know to whom I will contact the next time if I need to solve such questions.

Quality
Professionalism
Price
Availability
Terms

Thank you for the lightning reaction (he called Andrea, asked to come and in the morning after the day he was with me. He came, listened and sent the first version of the decision the next day. TZ was very flushing)

I recommend it.

Activity

  Recent proposals 10
Анализ таблиц Excel / импорт в базы данных / Big date
18 USD
Суммирование ячеек в экселе по цвету
13 USD
Upgrade the current or make a new Excel Calculator
18 USD
Сформировать базу данных access
18 USD
Сделать макрос, что бы удалить дубликаты в файле Excel
18 USD
Барбер шоп
26 USD
Перевести файл Excel в формат CSV
18 USD
Унификация данных в эксель и сведение баз к одному общему виду
18 USD
Макрос excel
30 USD
Генератор в один формат эксель файла
36 USD