The Google Docs. and Query. Restoration of values
7 USD You need to fill the value "Price for 1st" in the material table.
Where do we get the price for 1 piece?
What you need to do in Google Docs
The "prices" table contains periodically updated prices. There is the “code” of the material and the “date”
Our task is based on the "code" of the material and the "data" in the "material" table to find the corresponding record in the "price" table. If full coincidence by date (and it will be very often) - take the nearest date record.
The main difficulty (good for me was) - in the absence of coincidence on the date to find the nearest and give that value.
The right solution through query.
Client's review of cooperation with Oleksii Kuzavov
The Google Docs. and Query. Restoration of valuesThe task was more difficult than the execution planned. But everything was done well and in time.
I advise.
Freelancer's review of cooperation with client
The Google Docs. and Query. Restoration of valuesA great customer. pleasant to collaborate.
I hope for further joint work.
-
1 day6 USD
377 56 3 1 1 day6 USD
Good day ! I can help you solve the task. Maybe query and will not be needed. They have been specializing in automating calculations in Google tables for 10 years. I can also help with Power BI. Call me, I am in contact.
-
Winning proposal1 day7 USD
3621 113 7 1 Winning proposal1 day7 USD
Good day . I have more than three years of experience working with such tables.
Ready to do today.
Let’s talk about the flights.
-
1 day12 USD
1134 38 0 1 day12 USD
Good Morning Nikita. A very interesting task. I will solve your task with standard formulas. If necessary, I will explain logic.
Current freelance projects in the category Desktop Apps
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 7 days 10 hours back ∙ 10 proposals |
Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food)
22 USD
We are looking for an experienced team or a Middle/Senior Android developer (possibly with Full-stack skills) to create proprietary software for self-service kiosks for a fast food retail chain. Currently, our terminals operate on a ready-made cloud integrator, but we are… Content Management Systems, Desktop Apps ∙ 12 days 5 hours back ∙ 23 proposals |