Freelance projects

Freelance projects

Editing Excel databases (data matching)

Databases & SQL — incorrectly specified categories?

45 USD

Project translated automatically. Log in or register, to view the original

Task Description: It is necessary to process and merge the tables of clients, leads, deals, and tasks according to the specified criteria.

Data Volume:

Clients: approximately 3,000 records
Leads: approximately 13,000 records
Tasks: approximately 2,000 records
Deals: approximately 650 records
Comments: approximately 29,000 records

Deadline: The task must be completed on March 8 between 12:00 PM and 7:00 PM Kyiv time, as the current data tables will be exported around 12:00 PM.

Description of Actions to be Performed:

5. Adding Comments to the Clients Table

Add a new column Rist_comments to the contacts table.
Fill this column with comments from the comments table, using the connection Rist_id = Student_id.

6. Adding Comments to the Leads Table

Add a new column Rist_comments to the leads table.
Fill this column with comments from the comments table if they do not match the contacts (matching by columns Rist_id = Student_id).

7. Adding Clients to the Deals Table

Add new columns from the clients table to the deals table (matching is possible by name, phone number, or email).
Extract to a separate table clients that did not match with the deals.

8. Adding Clients and Funnel to the Tasks Table

Add columns from the clients table to the tasks table (matching is possible by name, phone number, or email).
Add a new column Funnel with the value Task.

Payment: To be discussed in person.

Proposals 15 Withdrawn 1

Petro Shpak

13 0

Projects 13
Rating -
Rating 419

Budget: 10000 UAH Deadline: 1 day

Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.

Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.

Olga Dmytrik

24 3

Budget: 2000 UAH Deadline: 1 day

Hello, I am ready to quickly and efficiently complete the task. I suggest discussing the details in private messages.

Denis Shlyahov

1 0

Projects -
Rating -
Rating 492

Budget: 2000 UAH Deadline: 1 day

Hello! I have extensive experience working with Excel. I can help with completing the task within the specified time. However, I need to see all the tables by that moment. As I understand, you currently have all the tables, but they are not up to date?! I indicated an approximate price, I will be able to specify the exact one when I see the tables. Feel free to reach out, I would be happy to collaborate.

Vladislav S.

102 0

Budget: 1000 UAH Deadline: 1 day

Good day. I will be happy to help. I will complete everything quickly and efficiently!

Valentin Grechany

1 0

Projects -
Rating -
Rating 171

Budget: 500 UAH Deadline: 1 day

Good day! I will gladly complete this task within the specified time. I have extensive experience working with Excel formulas.
The task is simple, so the price is 400 UAH
(I set the lowest price allowed in the bid)

Dmitry L.

Winning proposal

63 1

Projects 61
Rating -
Rating 1 276

Budget: 2000 UAH Deadline: 2 days

Pavlo, good time.
Such work clearly does not need to be automated.
Contact me, I will do it through VBA, Power Query, SQL, these are all built-in Excel tools.
P.S. I have worked with large tables in the Armed Forces of Ukraine.
I will be able to name the price when I see the tables.

Oleg N.

53 0

Budget: 800 UAH Deadline: 1 day

Hello! I will edit your database according to the assigned task. I will do everything on March 8 from 12:00 to 19:00.

Denys Kalashnikov

15 0

Budget: 2000 UAH Deadline: 1 day

Good day.
I work with Excel. I can help you.
Feel free to reach out.

Ihor L.

22 0

Projects 22
Rating -
Rating 634

Budget: 1000 UAH Deadline: 3 days

Hello. I work as an analyst where the main tool is Excel. I think I can help you.

Oleksandr Gubenko

0 0

Projects -
Rating -
Rating 94

Budget: 1500 UAH Deadline: 1 day

Good day, I have extensive experience working with Excel spreadsheets, and I am currently available.

Nadiia G.

19 0

Budget: 2940 UAH Deadline: 10 days

Good day!
I have familiarized myself with the task.
I will combine the data according to the specifications. I will be available for work during the specified time frame.