Optimization of the working table in Google Sheets format

Budget: 6000 UAH Deadline: 5 days

Good day! I have extensive experience in Excel for business — calculators, financial models, automation. I also have worked a lot with tables on warehouse analytics, stock levels, incoming goods, and managers' work.
I will help create convenient, visual, and secure Excel documents: cost calculators, financial models, reports, analytics. Quickly, efficiently, with attention to detail.

Budget: 5000 UAH Deadline: 5 days

Good day, ready to discuss the task with you

I love working with data in Google Sheets/Excel. I can write complex formulas for arrays, named functions, filtering, sorting, conditional formatting, basic/intermediate level JavaScript (Apps Scripts for Google Sheets)

Budget: 5000 UAH Deadline: 5 days

Hello. I have extensive experience in developing and automating various tables and reports in Excel and Google Sheets. I am ready to complete the task.

Budget: 5000 UAH Deadline: 3 days

Good afternoon. I will help optimize the table. I have been doing this for about 10 years as my main job

Budget: 16000 UAH Deadline: 1 day

To estimate the cost of work on optimizing such a table, consider the following aspects:

1. **Analysis of the current state of the table**: To understand why the table "hangs," the first step is to analyze the existing data design, formulas, and connections. It is necessary to assess which processes cause overload.

2. **Optimization of formulas and data**: At this stage, formulas are adjusted or rewritten to reduce their complexity, cyclic dependencies are eliminated, and data may be split into several tables to improve performance.

3. **Implementation of scripts for automation**: Using Google Apps Script scripts to automate frequently performed tasks can significantly speed up the table's operation.

4. **User training**: In addition to technical aspects, training managers and warehouse staff on proper table usage may be required to prevent inefficient resource use.

5. **Testing and implementation of changes**: After optimization, the table must be thoroughly tested with large volumes of data and typical user scenarios to ensure all functions operate correctly and without delays.

### Estimated budget

Depends on the depth of analysis, the number of implemented changes, and the complexity of formulas and data. However, considering the task as a medium-complexity project, the following figures can be proposed:

- **Analysis and development of an optimization plan**: 8 to 16 hours of work
- **Optimization and restructuring of data**: 15 to 30 hours
- **Writing and implementing scripts**: 10 to 20 hours
- **Testing and revisions**: 5 to 10 hours

**Total work volume**: 38 to 76 hours

**Web developer rate**: $25-50 per hour (depends on region and the developer's qualifications)

**Final budget**: $950 to $3800

These estimates may vary depending on specific conditions and project requirements. Clarification of details with the client is essential for more accurate planning and budget proposal. Expand

Budget: 5000 UAH Deadline: 2 days

Hello, Pavle! Ready to help you optimize the table, speeding up its performance:)

Budget: 5000 UAH Deadline: 4 days

Hello! Ready to help optimize your Google Sheet.

I specialize in working with large and complex Google Sheets — optimizing formulas, structure, and links between files. I will help make your sheet faster and more stable without losing functionality.