Project translated automatically. Log in or register, to view the original Hello to you!The task without introduction will be difficult to perceive.Therefore: Our laboratory is engaged in conducting medical research for patients and external medical institutions.However, not all the research we carry out on our own and send those we do not outsourcing to other laboratories.All submitted samples are registered in electronic form (Excel Book).The results of preparation can be viewed in the personal offices of the laboratories.The problem is that employees can’t quickly and conveniently track the readiness of the results and we delay them, or we can entirely agree at the moment when the customer begins to search for the results.The following mechanism must be implemented through macros in the applied Excel format log: - After registering the directed material in a new line in the column "Period of preparation" a number is entered that corresponds to the maximum duration of expectation for results from third-party laboratories.- After filling the cells in the columns “FIO”, “LPU”, “Laboratory”, “Analytics” and “Period” in the columns “Send Date” must automatically pass the current system time, which then cannot be changed.- At the same time, only the cells in the columns "Analysis" and "Preparacy time" are required to fill - the Macro must "follow" by system time the moment when the result must be ready in comparison with the fixed time of registration (the "Send Date" cell) composed of the working days prescribed in the "Preparacy time" cell.It is important that the monitoring of the moment of preparation occurs on the working days, except for the weekend (sb and eve).For example, if the analysis is sent on Friday and a deadline for 2 working days is set, the time of preparation should come on Tuesday.After the arrival of the moment of preparation in the column "Ready mark" should appear the "Ready mark" marked with a yellow color.- After the employee enters or copies the text "Sended" in the column "Sended" the "Ready" must be marked with a green color.

Proposals 2 Rejected 1

Vladyslav Y.

62 2

Projects 64
Rating -
Rating 1 261

Budget: 2600 RUB Deadline: 1 day

Hello, I can implement the macro according to your requirements.

Pavel V.

Winning proposal

12 0

Projects 12
Rating -
Rating 283

Budget: 1000 UAH Deadline: 3 days

Hi, once I worked hard with VBA in Excel, I can accomplish your task, write to LS, or Telegram: +380 95 101 67 94

Volodimir Sokolov

85 3

Projects 50
Rating -
Rating 418

Budget: 1000 UAH Deadline: 3 days

Good day, I propose to implement as an application under Windows, will work as a clock, as well as you can make a conclusion in the same Excel or PDF for printing

Pavel Tregub
Barnaul, Russia

Projects 1
Rating -
Rating 49

Macro for Excel for Laboratory Analysis Preparation Tracking

Client's review of cooperation with Pavel V.

Macro for Excel for Laboratory Analysis Preparation Tracking

5.0

Freelancer's review of cooperation with client

Macro for Excel for Laboratory Analysis Preparation Tracking

5.0

Pavel V.

Vladyslav Y.

Pavel V.

Proposals are currently absent

Volodimir Sokolov

Current freelance projects in the category Databases & SQL

Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities