Budget: 4000 UAH Deadline: 5 days
Hello. Let's be honest: the fact that your Google Sheet is currently "falling apart" is quite natural.
You are trying to build a serious ERP system based on a tool that is not really designed for this purpose. Formulas (especially if there are many IMPORTRANGE or arrays) simply cannot handle such logic: import, distribution of logistics costs (Landed Cost), multi-currency, and reserves. That’s why you are experiencing failures.
I am writing this proposal because I understand how to fix it architecturally. My experience is not just from Excel courses. I have built warehouse and logistics processes at Ajax Systems and worked with databases at MedExpert. This means I know how the cost of a batch is calculated when the goods are still at sea, and how to ensure that two managers do not reserve the same stock.
How I suggest proceeding: Instead of patching holes in old sheets, create a proper architecture. Directories separately, operations separately. For complex calculations (costing with exchange rate changes), it is better to use scripts (Apps Script) rather than simple formulas, then the system will run smoothly.
I propose to start with an audit of what exists and to create a clear structure for the new system. Because if we start doing everything at once, we will just create another monster that will freeze in a month.
I am ready to look at your current files and tell you how to rebuild it properly.
The price I indicate is for Stage 1: Audit and Technical Specification.