Excel/Google Table
22 USD Analyzing the data to count the parameters:
1) probably the VPN formula - which in one column will find the desired phone number and put the data from the desired column
2) any formula that takes into account the date, the manager- and compares the number of orders he has accepted for that day
3) probably a chart that takes into account the order time and the driver's name and clearly shows when the driver is busy and when free
Applications 1
Client's review of cooperation with Viktor Biruk
Excel/Google TableVery pleased with the outcome of cooperation!
The specialist knows his business, quickly responded to the request, during the evening all tasks were implemented.
Patient and accessible everything is explained, accompanied by copying/transmission to the current table.
It is a great luck to meet such a good and talented professional.
Freelancer's review of cooperation with Mariya Dzyuba
Excel/Google TableI am happy with work. Maria clearly puts the task, carefully listening and analyzing the proposed options. It is easy to communicate with humor.
-
5 days33 USD
647 11 1 5 days33 USD
Good Morning Mary.
The first two points can be completed using the corresponding functions or formula of the massive.
For the third point, many factors must be taken into account.
How to calculate when the driver is free and when occupied.
For example, the trip can take half an hour, and it can take an hour.
In this regard, the schedule of employment may be different.
Working hours of the driver should also be taken into account.
… 3) There is a break for lunch, etc.
-
1 day22 USD
4464 102 0 1 day22 USD
Good day . I will be glad to help. I do everything quickly and efficiently.
-
1 day27 USD
928 14 0 1 day27 USD
Good day .
I will perform your task on the basis of Excel, the bucket solution is automated to rediscover when new data appears, adding visual analytical elements and cuts if necessary.
-
5 days11 USD
351 4 0 5 days11 USD
Hello to you. Get acquainted with the task. I can do according to TZ. The final price and deadlines will be determined during the dialogue. At a reasonable price and deadline, we will agree. What budget are you about to calculate? Will we discuss cooperation?
-
1 day11 USD
421 13 0 1 day11 USD
Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
4 days22 USD
135 1 0 4 days22 USD
Good day ! Do you need a daily report on telephone calls, the number of orders by managers and the load of the vehicle? Should it be in three diagrams? On a separate Google table list, in a separate Google table file or in the Excel book? The source is an example of screenshots. And is it all the data from the source or will there be more data?
-
Winning proposal1 day22 USD
2870 72 0 Winning proposal1 day22 USD
I have been working with the formulas since 2009. With VBA macros since 2011 (but if Google tables, then there are no macros, there is another programming language).
If you look at the task, then scripts are not needed, enough to apply the formula.
Diagram is according to the type of Ganta diagram. Per, with operational settings (selection of period, data...).
Let’s write and talk. It will be optimal, fast and reliable.
-
1 day13 USD
5907 345 0 1 day13 USD
I will look at the possibility of updating the table with formulas/scripts.
It is very desirable to replace the “probably” type of formulation with something more accurate.
You also need to determine exactly what to work with: with Excel or with a Google Table (from the formula they are similar, from the automation through the script they are completely different).
Ready to discuss the TZ and offer the options of implementation, price and time from the lighthouse.
-
5 days22 USD
937 19 0 5 days22 USD
Good day . Here is an example of your task.
HTTPS://prnt.sc/s9EIIQMyVy6B
If necessary, other options can be discussed.
-
1 day22 USD
2578 57 1 1 1 day22 USD
I am an analyst at a large international company. I know Excel and the formulas very well. I do it.
-
Может, идет речь о ВПР и функции СУММЕСЛИ?
-
Вы думаете именно это заказчику важнее всего?😂
-
Current freelance projects in the category Databases & SQL
Development of the web service "Interactive Veterinary Dental Map"Project essence: a web application where doctors can maintain interactive dental charts for patients (cats and dogs) The interface design and all jaw elements are already fully prepared in Figma (vector SVG with separation by individual teeth) Required functionality:… Databases & SQL, Web Programming ∙ 10 hours 43 minutes back ∙ 50 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 12 hours 46 minutes back ∙ 13 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 2 days 16 hours back ∙ 54 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 2 days 17 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 3 days 5 hours back ∙ 10 proposals |
Kyiv