Improvement of Excel table
22 USD There is a table (attached)
It has tabs for entry price, selling price, technical zero price
The selling price is calculated based on coefficients from formulas, where for wholesale there is one markup, for retail another, and there can be several types of tariffs.
There is a technical zero price, which is also calculated by a formula, just without markup with all costs (conditionally)
I need to be able to have the option to insert presets with markups in one file and accordingly get the result with prices in tabular form. It may be possible to greatly simplify the table itself, so that I do not have to jump between tabs but set the necessary preset - retail price (for example) and get the result.
An example of a test table is in the attached file
The working table looks exactly the same, only there are more tabs - about 60 tabs with similar data for 3 tabs for each type of delivery
The table can be transferred to Google Sheets if it is more convenient for the performer.
Applications 1
Client's review of cooperation with Viktor Biruk
Improvement of Excel tableGreat job, very demanding and meticulous performer. I recommend.
Freelancer's review of cooperation with Dmitry Kolosovsky
Improvement of Excel tableIt's interesting to work on such tasks. Communication is equal, without conflicts and misunderstandings.
-
4 days78 USD
812 15 0 4 days78 USD
I will do it, we need to discuss, please contact me.
======================================================
-
5 days56 USD
1311 63 1 5 days56 USD
Dmitry, good day.
Feel free to reach out, I can implement it using standard Excel features or through VBA scripts.
We can also implement it using Google Sheets with Apps Script.
Contact me, we will discuss in more detail, we will agree, I will do it.
-
5 days111 USD
421 13 0 5 days111 USD
Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
-
3 days27 USD
5899 345 0 3 days27 USD
I can automate Excel and Google Sheets tables, then we need to discuss further, after which the implementation options, price, and timeline will become clear.
-
2 days22 USD
1312 37 0 2 days22 USD
Hello.
I have experience writing macros for Excel.
Let's discuss the details.
Current freelance projects in the category Databases & SQL
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 2 days 11 hours back ∙ 16 proposals |
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 ∙ 4 days 15 hours back ∙ 55 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 ∙ 4 days 15 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project 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 ∙ 5 days 4 hours back ∙ 10 proposals |
Database synchronization
Synchronization 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 ∙ 5 days 9 hours back ∙ 13 proposals |
Kyiv