Budget: 5000 UAH Deadline: 3 days
So it is possible to do this. The comment added here regarding whether it will work quickly is 100% true. But I am sure that a solution can be found. I can automate this for you using a macro and some other Excel capabilities.
Budget: 2000 UAH Deadline: 1 day
Hello, Anna.
I am ready to do it by morning.
-------------------------
Budget: 2000 UAH Deadline: 1 day
Yes, everything you described in the video is possible... The only thing is that the script that highlights the rows will take a long time to run if there are 20,000 rows... Is it possible to split such files into several?
Budget: 2000 UAH Deadline: 5 days
Good day!
I understood the task, I will help implement a simple automation method.
Here is the implementation.
https://prnt.sc/COgyCixHh6mt
In your file, I changed the names to demonstrate that the same name will be highlighted the same way.
Write to me, I will send the code, explain how to use it, and set up a keyboard shortcut for quick execution.
Budget: 2000 UAH Deadline: 2 days
I can do it if you provide clarification on how exactly to shade the cells (whether it should just visually separate the groups or if the color depends on the data itself) and what data needs to be cloned in each group.
Budget: 2000 UAH Deadline: 2 days
Good day. Please write to me in private. I will be happy to help. Feel free to reach out, we will discuss the details.
Budget: 2000 UAH Deadline: 1 day
I looked at the project brief, of course, everything is possible to do. I have a few questions, write to me and we will communicate.
Budget: 2000 UAH Deadline: 1 day
Good day. I am ready to create a macro for Excel that will perform color highlighting and data copying according to the specifications.
I guarantee speed and quality.
Budget: 2000 UAH Deadline: 2 days
Good day, I will help you complete the task. My experience and technical skills meet the requirements of the terms of reference. I will propose an optimal solution. Feel free to reach out.
Budget: 2000 UAH Deadline: 2 days
Good day! I have experience = I can do it well!!!!!! Feel free to contact me!!!!!!
Proposals concealed
Proposals are currently absent
-
Oleksandr Nazarov 21 November 2024Добрый день, на 20000 строк и такое количество колонок которое нужно обработать, даже с мощным компьютером и 2013 офисом может уйти часов 8. Вы готовы будете ждать так долго каждый раз?
Current freelance projects in the category Databases & SQL
A separate CRM system needs to be developed for the centralized processing of all retail orders from various sales channels (Prom, Rozetka, own websites, and manual orders). Main requirements: A unified order registry from all sources, preserving information about the source and its status. A separate internal CRM status that operates independently of the status on the marketplace or website, with two-way synchronization of statuses where supported. Flexible integration with 1C: for each source, the administrator can separately enable or disable automatic order export. Integration with carriers for automatic creation of shipping documents, saving their numbers in the CRM, and transmitting the shipping document numbers to Prom and Rozetka. Integration with Checkbox for creating receipt projects, using customizable payment method matching, with subsequent fiscalization control. Support for manual order creation (phone, Viber, Telegram, Direct, etc.) with a complete subsequent processing cycle through the CRM. All API keys and integration settings must be managed by the administrator through the CRM interface without the involvement of a programmer. A complete action log and integration logging for system operation control. Main goal The manager must be able to fully process orders in one CRM interface — from receiving the order to creating a document in 1C, shipping document, receipt project, and completing the order, without the need to access the cabinets of Prom, Rozetka, websites, carriers, or Checkbox.
We have synchronization of two data sources with the CRM. The system as a whole is stable. However, there remains a part that becomes desynchronized. The main hypothesis is that in one of the sources, the data changes after the initial synchronization, and these changes are not always pulled into the CRM. + the data in the two sources have different names/identifiers even though they represent the same entities.
Task: deploy an LLM service that knows all the company's documentation and answers questions from the sales department managers. Current situation: the client has independently assembled a prototype (a separate project with uploaded company information, hosted on a server), but the information from the database is not transmitted to the model — likely, there is an issue with the API. We will provide the code and access. The first step is an audit: fix the existing setup or justifiably rebuild from scratch. Required functionality: Upload all company documentation: description of each service, regulations, FAQ, pricing (all materials will be provided). Answers strictly based on the uploaded documents (RAG). The model does not invent facts; if the answer is not in the database — it honestly informs about it. Access for managers via a link (web interface), with authorization. Scenarios: the manager asks any question about the company's work; inserts the client's question "as is" and receives a ready answer for sending; finds the necessary regulation/report by request. Knowledge base updates without a developer (uploading files through the interface or a connected folder). English language. History of requests for quality control. Technical expectations: LLM via API (Claude/OpenAI — propose with a cost calculation for tokens), RAG pipeline (vector database, embeddings), hosting on our server or in the cloud, HTTPS. The architecture should allow for future connection of the assistant to the analytical data warehouse (parallel project). In the response, indicate: examples of similar RAG projects, stack, timeline, cost of work, and estimated monthly ownership cost (tokens + hosting).
Hello There is a small department where patients are admitted. It is necessary to develop a simple "database" where consumables, medications, and others can be entered, along with incoming and outgoing records, as well as assigning usage to a specific patient. Required functionality Directories Medications Consumables (manual entry option) Patients (ability to continuously add new ones and delete those who have been discharged) Employees (ability to modify)Movement Accounting A single table (movement log) where everything is registered Incoming and write-off Manual correction option When writing off, the nurse must select: date; patient; medication or material; quantity; her full name. The system automatically reduces the balance. When receiving, the head nurse must be able to enter: Delivery date; Medication/material; Remaining quantity; Source; Expiration dateAutomatic Functionality automatic balance calculation; minimum stock control; expiration date control; low stock warnings; protection against writing off more than is available; drop-down lists; data entry validation; conditional formatting.Reports It is necessary to implement automatic reports: current balances; usage over a period; usage by patient; usage by employee; history of movement of a specific medication.Preferred implementation on Google Sheets; We will fill in the databases ourselves. A template for work is needed. I don't know how much this costs, so let's start with $50, and you can suggest your options, preferably with experience.
It is necessary to calculate statistics in a medical project (including correlations). Additionally, there is a request to create a mathematical model for predicting the development of pathologies based on available data.