[Fin] Aggregate and update Google Spreadsheets data
29 USD 
Сценарий:
Я выгружаю данные из учетной системы в Google Spreadsheets, открываю его и копирую данные на страницу Data. Перехожу на страницу Operations и делаю следующие настройки
Sheet A - значит загрузка данных пойдет на страницу A Task Bucket Apr 2022 - использовать только данные с этим значением в колонке Task Bucket Customers column B - названия компаний в колонке B листа А Bookkeepers column C - имна бухгалтеров в колонку С листа А Hours Column D - часы работы суммарно в колонку D листа А Amount Column E - стоимость суммарно в колонку Е листа А Stauses only Prep, Review 1, Review 2 - использовать только данные со статусами
Нажимаю на кнопку Run и скрипт удаляет ВСЕ данные из колонок C,D,Е листа А и вставляет туда новые данные.
Аггрегация в разрезе клиента за указанный период - надо посчитать общее количество частов, общая сумма и сотрудники для данного клиента и затем обновить данные на странице
Возможна ситуация когда несколько сотрудников работали для одного клиента - тогда их надо перечислить через запятую
При подаче заявки укажите слово Fin в теле сообщения чтобы я знал вы внимательно прочитали до этого места
Applications 2
Client's review of cooperation with Aleksandr Pomazun
[Fin] Aggregate and update Google Spreadsheets dataExcellent work done earlier
Freelancer's review of cooperation with Oleksandr Fedorov
[Fin] Aggregate and update Google Spreadsheets dataThank you to Alexander for the opportunity to implement this project, fairly loyal attitude, adequate requirements and fast payment.
-
1 day29 USD
15 1 day29 USD
Good day !
and fin.
Ready to fulfill your task.
I’ve been working with Google Spreadsheets.
-
1 day29 USD
528 40 3 2 1 day29 USD
Finally
I have read your TZ, I am ready to help you in this matter.
I suggest to go to L/S to discuss all the points on the project in more detail.
-
1 day56 USD
250 37 1 2 1 day56 USD
Good evening !
I work with Excel and Google tables.
I will be happy to cooperate.
Fine
-
1 day29 USD
419 13 0 1 day29 USD
Fine
Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
Fine
-
4 days40 USD
129 4 0 4 days40 USD
Hello to you. There is experience working with different tables, so there will be no problems with your order. I will do everything qualityly and as quickly as possible. Not everything is understood by your tz, so I suggest you go to the discussion of the details and ready to start implementing.
Current freelance projects in the category Data Parsing
Parsing products, preparation for import to WPScrape the full catalog of these websites: https://svit-mebliv.ua/ https://kompanit.com.ua/ru https://amia.com.ua/ https://mebliromax.com.ua/ https://pehotin.com.ua/catalog/ https://www.sokme.ua/ru/ All products need to be combined into one general table for import into WP.… Web Programming, Data Parsing ∙ 1 day 17 hours back ∙ 54 proposals |
I am looking for a programmer for OpenCart.Good day 1) It is necessary to implement on the website dneprkomfort.dp.ua A module for Ukrainian banks has been purchased, and we have already integrated Mono Bank Here is an example from our competitor It is necessary to implement installment payments, purchase in parts… Web Programming, Data Parsing ∙ 2 days 15 hours back ∙ 48 proposals |
A specialist in Telegram promotion is required.
28 USD
Tasks: invite real users from the username database to new chats and send messages to the target database. Only quality traffic and work with a live audience are of interest — performers using bots, fake engagement, or low-quality methods are requested NOT TO DISTURB. Work… Data Parsing, Social Media Marketing (SMM) ∙ 6 days 17 hours back ∙ 9 proposals |
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 10 days 12 hours back ∙ 13 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 10 days 17 hours back ∙ 22 proposals |
United States