Задание в excel
5 USD1 Объедините данные с листов "База врачей", "Метрики врачей", "Данные по врачам" в одну сводную таблицу.
2 "Рассчитайте категорию каждого врача, учитывая условия ниже. Категория должна состоять из Количества пациентов и Предпочтений. Например, А1 – означает, что у этого врача кол-во пациентов более 50 (для педиатра) либо более 30 для неонатолога, гастроэнтеролога, аллерголога и что этот врач назначает только наши продукты
Условия:
Количество пациентов: Для педиатров = А = 50 детей, B = 20-49 детей, С – =30 детей, В = 10-29 детей, С =
Applications 1
Client's review of cooperation with Olena Roianova
Задание в excelСпасибо за хорошую и быструю работу.
Рекомендую данного исполнителя
Freelancer's review of cooperation with client
Задание в excelБыстрый проект, понятное задание, адекватная оплата.
-
в екселе чтоли сделать или вам надо код написать который всё это делает и выводит инфо?)
-
Current freelance projects in the category Databases & SQL
It is necessary to process the database so that the output files are in the formatThere is a database of the forum and files of the XENFORO 1.6 forum. It is necessary to create an import file for another script, but all fields must be preserved. I provide the specification files and the FAQ file which specify the fields I need. The specification files are for… Databases & SQL, Data Parsing ∙ 1 hour 16 minutes back ∙ 3 proposals |
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 3 days 14 hours back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 3 days 17 hours back ∙ 19 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 5 days 8 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 6 days 13 hours back ∙ 36 proposals |