[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
Collection of a database of designers, architects, and installation companies in UkraineTask description: It is necessary to collect an up-to-date database of contacts in Ukraine for further B2B communication. Required categories: Interior designers Architects / architectural firms Installation companies Companies engaged in repairs, finishing, lighting,… Data Parsing ∙ 9 hours 15 minutes back ∙ 26 proposals |
Telegram group parser
22 USD
# Technical Assignment ## Project Goal It is necessary to develop a parser for Telegram groups that will find groups based on specified keywords and save the results in text files. ## Main Functionality ### 1. Group Search The parser should search for Telegram groups… Data Parsing, Bot Development ∙ 11 hours 49 minutes back ∙ 43 proposals |
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 3 hours back ∙ 53 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 1 hour 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 3 hours back ∙ 9 proposals |
United States