Andrey Kruglyakov
Private message
Offer work
Kyiv,
Ukraine
a little busy
Rating
Skills and abilities
Programming
Services
Portfolio
-
Interactive map of Ukraine
Desktop Apps
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
Desktop Apps
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
Desktop Apps
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
Desktop Apps
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
Desktop Apps
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
2 USD
Добавление предпоследнего столбца по кнопке
Работа выполнена очень быстро. Андрей - замечательный человек и приятный собеседник, который не просто профессионально выполняет свою работу, но еще и подскажет как довести до ума уже существующие доработки. Однозначно рекомендую к сотрудничеству.
3 July 2018
2 USD
Writing one complex formula in MS Excel
Thank you for work. Completed quickly and professionally.
29 January 2018
4 USD
Excel Configuration/Configuration of the created macro
Thank you very much Andrea!
Very quickly prescribed me a Macro that will save me a lot of time!
I recommend !
|
11 October 2017
10 USD
You need an Excel specialist - bring the base in the necessary form
A great specialist. It’s all very fast, quality and professional.
27 May 2017
11 USD
Create macros to transfer data from a Excel file table to another
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.
20 January 2017
9 USD
Excel Making macros under specific tasks + work with data
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
| Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
A table needs to be created for calculating expenses for the repair of AT, BT, LBT, VT transport.
22 USD
|
|||||
|
Анализ таблиц Excel / импорт в базы данных / Big date
16 USD
|
|||||
|
Суммирование ячеек в экселе по цвету
11 USD
|
|||||
|
Upgrade the current or make a new Excel Calculator
16 USD
|
|||||
|
Сформировать базу данных access
16 USD
|
|||||
|
Сделать макрос, что бы удалить дубликаты в файле Excel
16 USD
|
|||||
|
Барбер шоп
22 USD
|
|||||
|
Перевести файл Excel в формат CSV
16 USD
|
|||||
|
Унификация данных в эксель и сведение баз к одному общему виду
16 USD
|
|||||
|
Макрос excel
20 USD
|