Budget: 900 UAH Deadline: 1 day
Hello to you! Interested in your project.
My name is Maxime, I have worked in Excel for more than 10 years. I am engaged in creating tables, aggregate tables, databases from scratch.
Budget: 1000 UAH Deadline: 1 day
Andrei, hello to you!
I can offer a solution based on Excel+ VBA macros, and it’s fashionable to do on Google tables and scripts.
Write to me, we will discuss the details.
Budget: 1000 UAH Deadline: 3 days
Good time of day.
I can help to solve your question. I hope for mutually beneficial cooperation.
Happy days .
Budget: 1999 UAH Deadline: 3 days
I can suggest you do everything you want on the basis of Google tables. Google tools have a number of advantages compared to Excel:
The ability to work simultaneously in a file of several users
- Individual protection
Availability from mobile devices
Simplicity in Use
Automatic (non-manual) data update
Possibility to link files by reference
- Dozens of Google tools with analytics and so on
I have considerable experience in automating plans on the basis of Excel and Google tables. At Kyiv there is an opportunity to meet to discuss details if necessary.
Budget: 500 UAH Deadline: 1 day
Hello to you! Ready to take. I have more than a decade of experience in creating various forms in Excel. He also worked in the construction sector. Knowledge of material expenses, tables of working time accounting, forms of state statistical reporting, forms for the analysis of the movement of the TMC on the warehouse.
I will be glad to work with you.
The price and time of execution can be corrected after the volume of work is revealed. I usually get 500 rupees. in eight years.
Budget: 3000 UAH Deadline: 3 days
Good day
I have worked in Excel for more than 12 years - formulas, masses, summary tables, etc.
Configure accounting of both the manufacturing enterprise and services and trade, using 1C downloads, and other accounting or accounting programs, or keeping the entire database in Excel
Please specify exactly what indicators or forms of reports you want to see in the account. Where the original data is currently being formed? Who will be the user of the database - one person or group. Payment and deadlines for clarification of all input data
Budget: 2000 UAH Deadline: 7 days
A familiar topic. I am an engineer-electric expert, Excel as a hobby. I keep all my account in it. Revenue - Expenses - Remains, wages, warehouses, printing and so on. For this calculation, Excel is more than enough. Ask me, I will do it.
Budget: 5000 RUB Deadline: 10 days
Good day .
Excel is not the best environment for such applications.
It is better to use the database.
I am writing programs Database Interbase (Firebird), MS SQL, MySQL, Access ...
(including the Client-Server) with an interface on Delphi since 1997 (not a site).
He worked with almost all types of databases.
I have written a database program for the General Representative
Nokia in Armenia, for Armenian Water and Sewerage Company.
The Production, Wholesale and Retail Database Programme
AlexGrig, the wholesale and retail data base program for
Importing company with a lot of warehouses, 2 programs for pharmacies ...
A total of programs Database more than 100 (may all 200. I lost the account for a long time.
When using BD Access, the program works on any compet.
with Windows (with any version of Access, even if it is not available).
The database is also designed by me.
With respect, Mike
by P.S. The price and time are examples. To clarify the task.
Budget: 1500 UAH Deadline: 20 days
Good day .
To determine the working time, you need to learn more in detail about the program’s functions. I can do this with the help of Excel macros. If there is no function in the built-in Excel, I will write. If it is necessary to use some database, it can be organized in the current file processor, or in the dop.file, to which the program "knows" and if necessary opens it. The most likely will be three files: the file processor, the project database and the database of the work done. There may be another file with the data for the account (or these data will be in the file processor, if not significantly increased). The principle of the database will be implemented by the Excel macros. The possible functionality in the task is not described, it needs to be discussed in the process of implementation of the project.
It is possible to implement graphic information (standard drawing for the discount, but with the necessary data, etc.)
The deadlines are examples. There is experience writing such projects.
- Projects -
- Rating -
- Rating 72
Budget: 3000 UAH Deadline: 10 days
Good day !
I can develop this BD on MsAccess. You do not develop anything difficult enough on Exel.
Budget: 1000 UAH Deadline: 1 day
Ready to help implement analytics in Excel.
Ready to help implement analytics in Excel.
Ready to help implement analytics in Excel.
Proposals are currently absent
-
Aleksandr Afanasyev 26 May 2020Добрый день!
Может вас заинтересовала бы разработка системы учета (база данных) в виде веб-приложения (удаленно, через браузер) ? Так, думаю было бы более эффективно. И клиентов, заказы, расчеты по заказам можно вести в единой системе. С эксельками - замучаетесь)
-
Andrey Kracha
5 June 2020
Да такое есть у нас уже, и СРМ подключили и 1С все синхронизированно, это уже так для себя скорее) Спасибо вам)
Current freelance projects in the category Databases & SQL
There is an active production platform with a catalog and automatic updates of external offers and prices. Stack: — Node.js / TypeScript; — PostgreSQL; — existing price refresh service and cron; — separate ready Python module for validation and selection of offers; — staging and production. It is necessary to make targeted improvements to the existing price refresh pipeline without completely rewriting the backend. MANDATORY SCOPE 1. Integration of the Python module — The Python module remains a separate component; — returns a structured result: offers, selected offer, statuses, and risk flags; — Node.js validates the result and performs a write to the database; — provide for error handling and partial/failed runs; — the legacy pipeline is not turned off until QA is completed. 2. Launch refresh by list Add launch: — by one slug/id; — by the provided list of slug/id. Assume CLI or existing service API. A new user interface is not required. 3. Shadow Mode New results must be recorded separately and not affect production until QA. Shadow fields required: — price; — selected offer ID; — direct URL; — offer status; — risk/QA flags; — checkedAt; — engineVersion. 4. Expanding the existing offers table Add: — source; — external_offer_id; — last_seen_at; — last_checked_at; — engine_version; — risk flags or storage in existing JSON; — unique constraint to protect against duplicates. It is not required to create a new parallel offer system if the existing table can be safely expanded. 5. UPSERT, STALE, and DB transaction Replace the current DELETE → CREATE scheme: — UPSERT existing and new offers; — offers missing in the full successful snapshot are translated to STALE; — in case of API error, partial result, or incomplete snapshot, active offers should not become STALE; — updating offers, selected offer metadata, and shadow fields for one model is performed within one DB transaction; — in case of an error, a full rollback is performed. 6. Canonical-safe refresh Price refresh should not change: — brand; — reference; — model; — collection; — name/title; — slug; — descriptions; — images; — SEO fields. Only offer, price, and shadow data are updated. 7. Preserving current cron logic Preserve: — existing cron; — rolling batches; — cooldown; — checking PRICE_REFRESH_MIN_DAYS before calling the external API; — legacy production pipeline until Shadow QA is completed. 8. Audit output One option is sufficient: — shadow columns in the existing admin table; or — CSV export. Minimum data: — model/reference; — production price; — shadow price; — delta; — production/shadow URL; — status; — risk flags; — checkedAt; — engineVersion. A new complex dashboard is not required. 9. Staging and QA — DB migrations; — staging deployment; — smoke test on 5 provided models; — then Shadow Mode on approximately 50 models; — fixing technical errors identified during these runs; — brief documentation of the Python → Node.js contract and rollback procedure. OPTIONALLY ASSESS SEPARATELY Simple technical promotion without a new UI: — promotion of one model by slug; — promotion of a list of slugs; — transferring confirmed shadow values to production; — technical check after rollout. RESULT — Pull Request; — DB migrations; — working integration Python → Node.js; — Shadow Mode; — UPSERT, STALE, and transactional update; — launch by slug/id; — staging deployment; — smoke-test results; — brief documentation; — at least 7 days of bug fixes for the implemented scope after acceptance. IN RESPONSE, INDICATE 1. Fixed price for the mandatory scope. 2. Separate cost for the promotion mechanism. 3. Timeline. 4. Hourly estimate. 5. When you are ready to start. 6. Experience with PostgreSQL transactions, migrations, and ingestion pipelines. 7. What questions need to be clarified before starting. 8. Whether staging, QA, migrations, and bug-fix period are included. Template responses without specific estimates will not be considered. Access to production is not provided at the first stage. Work begins with limited code review and staging.
A centralized server system for collecting and storing data from Planfix, 1C, Meta Ads, and Google Ads is needed, as well as a web dashboard for displaying and analyzing this data. All data, change history, calculations, and aggregated metrics must be stored exclusively in the server database. The dashboard should not store or duplicate business data. It must retrieve the necessary information from the server database via API according to user requests and display it in the form of KPIs, charts, tables, and detailed reports.
We are looking for support for a project based on Yii , we need to make edits and improvements to the database, there is partially a connection with the previous contractor .....................
It is necessary to migrate the database from CRM G-PLUS to MyChatBot Database volume - 26 thousand leads 2 funnels - Call center and Sales department with their own funnels Lead cards (besides name and number) have many different fields Leads also have voice recordings of calls. These also need to be transferred I expect an approximate amount and implementation timeline from the candidate
Create a dashboard for monitoring and analyzing the performance of the company's location network (branches) in Google Business Profile (GBP) through the official Google Business Profile API. Process via a script based on Google Apps Script (link to Google Sheets). Record data in Google Sheets (which serves as a database for Looker Studio). Update: Daily (with an indication of the last update date). Create a Google Cloud service account. The script runs once a day (trigger at 03:00 AM) and sends a request to the GBP API. It retrieves metrics for the previous day for each location (locationId). Records data in a flat format (row = unique combination of Date + Branch ID + Metrics). Key Performance Indicator CardsCard NameGBP MetricDynamic FormatProfile ViewsImpressions (Search + Maps)Percentage %, Sparkline (blue)CallsLocal Services Phone CallsPercentage %, Sparkline (green)Website ClicksWebsite ClicksPercentage %, Sparkline (purple)Direction RequestsDirection RequestsPercentage %, Sparkline (orange)Average RatingAverage Review RatingAbsolute change (e.g., +0.1), Sparkline (yellow)New ReviewsNew Reviews CountPercentage %, Sparkline (turquoise)