EXCEL database software.
1. There's a file in the exel: three columns, a lot of lines over 6,000 lines (more than 50,000 lines could be added in the future). Filling lines without graphic elements, numbers, addresses, etc.
2. The person collects new data and adds them to the table, EXCEL by using the function "Constant Formatation \Distinguishing Values" immediately illuminates if the data he has already entered are already available in the database.
PROBLEMS:
Because of the large number of lines, EXCEL is not actually slowing down, and the line is going to be even bigger.
TASK:
Any software solution (acceptable using a fee-based software) that will perform the following functions similar to the EXCEL file.
1. Keep the database as a table, three columns with a lot of lines.
2. The ability to add new data by input or insert Ctrl+C into the database(s).
3. In the base table, a function should be performed and duplicated on-line, i.e. As soon as the value is entered into the table base if it already exists in the database, it shall in any way be highlighted or illuminated.
4. The ability to select and copy text values from the base (preferably as) of the table for subsequent copying in EXCEL (Ctrl+C – Ctrl+V)
Consider all the price proposals.
-
848 22 0 1 есть решения Вашей задачи. Готов реализовать Ваш проект. Свяжитесь со мной дл обсуждения деталей
-
366 25 1 Готов написать программу которая будет выполнять поставленные задачи. Есть наработки по поиску схожих слов (названий организаций, ФИО, адрес и т.д)
Можно сделать как локальную программу, так и с поддержкой работы по сети.
Сроки и цена ориентировочны.
-
567 28 2 С условным форматированием конечно будет тормозить нереально. Необходимо написать программу взаимодействия с базой, типа добавление данных, изменение данных, выборка данных и т.д. Реализовать можно там же в Excel посредством VBA. Для одного или нескольких пользователей? Есть примеры, могу показать.
-
6127 71 2 5 Могу разработать простую программу с веб интерфейсом. будет выполнять все ваши задачи. у пользователя будет доступ по логину и паролю.
Расчет стоимости после составления ТЗ.
Даю гарантию на выполненную работу
-
4327 215 0 1 Добрый день, есть идеи, могу реализовать на PHP. Пишите в личку
-
277 1 0 Здравствуйте, интересное задание, готов пообщаться, предложить свое видение реализации этого проекта, пишите в лс, на связи все время
-
3621 113 7 1 Добрий день
Готовий запропонувати варіант. Треба спробувати на пратиці
Пишіть в особисті
Current freelance projects in the category Databases & SQL
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 ∙ 1 day 16 hours back ∙ 51 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 ∙ 1 day 17 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject 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 ∙ 2 days 5 hours back ∙ 10 proposals |
Database synchronizationSynchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 2 days 11 hours back ∙ 12 proposals |
Setting up a backup system and optimizing server infrastructureObjective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 3 days 9 hours back ∙ 25 proposals |