Завдання написати макрос для роботи з даними в Exeль
- Макросу потрібно вказати колонку з назвою бренду та колонка з номером деталі
- Макрос має виділити весь діапазон цього бренду
- Скопіювати його та створити новий фай з назвою бренда із цим вмістом
- Також потрібен алгоритм ідентифікації по спільним признакам коли не прописаний Бренд а є код деталі скопіювати його до файлу бренду з найбільш похожими ознаками
- Наприклад наявність префіксів незалежно від їх розміщення тільки перед а бо після номеру злитно або окремо 335810KYB або 335810 KYB або KYB 335810 або KYB 335810
- Немає префіксу але є спільна ознака бренду
- <!--[if !vml]-->
Client's feedback on cooperation with Ivan Moroz
Writing Macro for ExelThanks to Ivan for the rapid development of the Exel macros, the macros is great and hard to deal with the massive files of more than a million lines with both CSV and XLS files. All desires were taken into account and input advice was given to optimize the process of processing. I recommend Ivan as a highly qualified specialist in my business.
Freelancer's feedback on cooperation with Andrii Gm
Writing Macro for ExelIt’s not the first time I’m working with Andrew.
The task is as always accurate. You can always contact and clarify all the questions that arise in the process.
Payment is timely and taking into account all rectangles and fees.
One of the best customers with whom I had to work, as he perfectly understands all aspects of freelance-work.
And I strongly recommend Andrea to work together.
-
Winning proposal1 day14 USD
922 99 0 Winning proposal1 day14 USDGood Morning Andrei!
Ready to write such a macro to process data and form files for the brand.
bear it.
Доброго дня, Андрій!
Готовий написати такий макрос для опрацювання даних та формування файлів за брендом.
Звератйтесь.
-
2605 79 0 Ready to do.
‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘
Готов сделать.
'''''''''''''''''''''''''''''''''''''''''''''
Current freelance projects in the category C and C++
Project for the development of software for microcontrollersGreetings! I am looking for a specialist or team who can develop software for distributed microcontrollers such as Arduino, ESP, or Raspberry-Pi. Key points: - the controller should receive 5 analog signals as input, - it should also output 5 analog signals, - the controller… C and C++, System programming ∙ 1 proposal |
Script that will interact based on the imageI need a script that will interact based on the image + text (product name on the screen) + price. In other words, the script should click on the platform logo (white text in the top left) to update the range of products (every 3-5 seconds), then there should be a search by… C and C++, Python ∙ 8 proposals |
Create a bot telegram with GPT integration
306 USD
The technical task: 1) Create a bot telegram for example, When you start asking the language: The Russian The English The rest is the example of the first bot: to propose to send a photo from which the face will be taken, the second - to ask for a video on which the face… C and C++, Python ∙ 12 proposals |
Configurate the data exchange between Jetson nano and another device by can shiSet the data exchange between the jetson nano and other device on the can band using the RS485 CAN documentation and examples here: https://www.waveshare.com/wiki/RS485_CAN_for_Jetson_Nano The data package that is transmitted is broken down on the frame size of 8 bytes, the… C and C++, Linux and Unix ∙ 2 proposals |
Infrared temperature sensor ZigBeeRequired an infrared temperature sensor with data transmission through the ZigBee protocol to the Home Assistants server in MQTT Equipment of : Module ESP32-C6-WROOM-1-N8 Infrared thermometer MLX90614 + Add LED laser to indicate where the temperature is scored C and C++, Embedded systems and microcontrollers ∙ 1 proposal |