It is necessary to create a Google spreadsheet for accounting of inventory, production, and write-off of materials.

Budget: 4000 UAH Deadline: 2 days

Good day, I have extensive experience working with spreadsheets, I will complete your order as quickly and efficiently as possible.

Budget: 1948 UAH Deadline: 3 days

Hello! I am very interested in your project.

I have already developed identical systems for the commodity business and small productions, so I clearly understand the logic you described: "Order" → pulling norms from "BOM" → automatic write-off of materials from "Warehouse."

How I will implement your tasks:

Database: I will make the "Price/Components" sheet the main source of prices. When the cost of metal or fittings changes, the cost will be recalculated in all orders automatically.

Warehouse and Write-off: I will set up formulas (for example, SUMIFS or QUERY) that will subtract the used materials from the incoming stock. I will add conditional formatting: if the material is below the limit — the cell will light up red.

Specifications: I will create a convenient template. You will not have to manually calculate the costs for each order — the table will automatically multiply the norm by the quantity of products in the order.

Reports: I will set up an automatic dashboard where you will see net profit, expenses on salaries and materials for the selected month.

💡 My suggestion for improvement: You mentioned that you plan to copy the "Specification" sheet for new products. If there are many products (50+), the file will become heavy. I suggest creating one general specification database on a separate sheet. Then you will only need to select from the list "Hatch 200x300" in the order, and the table will automatically understand what to write off. This is much more convenient and professional.

I am ready to start working. An example of your product (hatch) will help me quickly set up the basic structure that you can scale.

I would be happy to discuss the details! Expand

Budget: 1997 UAH Deadline: 3 days

I am ready to fully complete this task and create a convenient, functional Google spreadsheet for inventory and production accounting. I will set up all sheets (Orders, Specifications, Price List, Inventory, Report) with automatic formulas, material write-offs, cost calculations, and summary reports. I will do this based on one product with the ability to easily copy the system to other items and, if necessary, I will suggest improvements for the convenience of the manager. I am ready to discuss the details and budget.

Budget: 2000 UAH Deadline: 1 day

Hello! I have experience in setting up accounting and reporting in Excel and Google Sheets. I suggest breaking down the functionality you described into step-by-step execution. In fact, to ensure that the setup and development of all forms and tables meet your expectations, we need to discuss all the nuances in more detail. I can provide an initial consultation and discuss the nuances to understand the time for phased implementation.

Budget: 5000 UAH Deadline: 5 days

Hello!
I work with Excel and Google Sheets.
I am ready to help with formulas or macros (scripts).
Connection of Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.

Budget: 4200 UAH Deadline: 3 days

I work as a financial analyst in a large international company. I have extensive experience in performing such tasks. Write to me - I will help.

Budget: 4000 UAH Deadline: 5 days

Hello! I have over 2 years of experience in performing similar tasks. I will gladly take on this job.

Budget: 5000 UAH Deadline: 4 days

I can already provide a formatted file, with a prepared example and adaptation to your data, including filling in real specifications and setting up conditional formatting in approximately 3-5 working days.

3000-7000 UAH (depending on the number of products and details that need to be entered. I am ready to discuss the budget after reviewing your specifications and clarifying the details)

Budget: 2000 UAH Deadline: 3 days

I am ready to promptly and qualitatively complete your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate!

Budget: 5000 UAH Deadline: 5 days

Hello!
I am ready to complete the project with quality. There is an option to create simple tables, or we can add a web wrapper for them: it will be functional and convenient to work with both PCs and mobile devices. The price I indicate is approximate; we can discuss it in more detail.

Budget: 4000 UAH Deadline: 4 days

Hello! The task is clear and very interesting. I have experience working with complex formulas in Google Sheets.

Your project brief describes a classic accounting system (mini-ERP). I can implement this.

My vision for implementation:

Architecture: I will do everything with formulas (without scripts) to ensure the spreadsheet works quickly and stably.

Inventory: I will implement it through dynamic calculation (Income - Expense = Current balance). This is the most reliable method that eliminates errors.

Specifications: I will set it up so that when the price of a material in the "Price List" changes, the cost of all products is recalculated instantly.

Clarification: Do you already have a ready list of materials in Excel, or will it need to be entered from scratch?

Regarding price and deadlines: Since this is the development of an automation system, not just a spreadsheet, I estimate the work at 4000 UAH. Deadline: 3-4 days for development and testing.

I am ready to start as soon as we agree on the details. Expand