Access and structure design
Separating the data layer from the reporting layer, with protection so the calculation cannot be broken by a well-meaning row insertion.
Excel experts for hire
Find a Sheets expert for the shared file your whole team depends on and nobody controls.
Abhishek
Abhishek Singh
Akhilesh
Prahalad
ShaktiA remote team of Excel and spreadsheet specialists. You work directly with the person building your file, from the first question to the final handover. More about us.
The short version
Google Sheets fails differently to Excel. The problems are rarely computational — they are collaborative. Someone inserts a row and breaks a formula range. Thirty people have edit access to the tab that holds the revenue number. A volatile function turns a fast file into a slow one. Fixing this is part restructuring and part deciding who is allowed to change what.
Scope
Every engagement gets an hours estimate before it starts. If something below is not relevant to you, it comes out of the scope and off the estimate.
Separating the data layer from the reporting layer, with protection so the calculation cannot be broken by a well-meaning row insertion.
Scheduled imports, email reports, form handling and integrations, written to be maintained rather than to impress.
Diagnosing and fixing the volatile functions and whole-column references that make a Sheet slow.
Reporting built for a team that lives in the browser and will not open a separate BI tool.
Need to check a feature before hiring? Read Microsoft’s official Excel help and learning for formulas, PivotTables, importing data and troubleshooting.
Same work, different job titles
These all describe the same engagement. The title matters less than whether the person writes things down — but it is worth knowing which term to search, because the results differ.
The general term, covering formulas, structure and the collaboration problems that are specific to Sheets.
The automation side. Apps Script is to Sheets what VBA is to Excel, and the same questions about error handling apply.
Used where the problem is how a shared file is organised and governed rather than what a formula does.
Where the work spans Sheets, Forms, Gmail and Drive as one connected process rather than a single file.
Method
The access pattern usually explains the breakage pattern.
Two layers, different permissions. This one change prevents most recurring breakage.
Structured ranges and named references that survive rows being added.
Who owns which sheet, and what the process is for changing structure.
| Discovery | 15% of hours | Understanding the decision the file supports, and who edits it. |
|---|---|---|
| Prototype | 20% of hours | A working version on your real data, while changing course is still cheap. |
| Build | 40% of hours | The main work, against definitions agreed in writing first. |
| Testing | 15% of hours | Edge cases, checks that fail loudly, and the numbers reconciled. |
| Handover | 10% of hours | Documentation, update procedure and a recorded walkthrough. |
Questions
What clients ask before commissioning this work.
Ask us something elseSheets when collaboration and access-from-anywhere matter most. Excel when you need computational depth, large datasets or offline work. Many teams sensibly run both, with Sheets for collection and Excel for modelling.
Usually. The causes are predictable: volatile functions recalculating constantly, whole-column references, and array formulas over far more rows than needed. A restructure typically resolves it. If the dataset is genuinely too large, we will tell you it needs to move to BigQuery rather than optimising indefinitely.
Yes, via Apps Script or the available connectors. We build for the failure case — what happens when the source is unavailable — because scheduled imports fail eventually and silent failure is the expensive kind.
Yes, though a direct conversion rarely works well for a complex file. The formula behaviour and performance characteristics differ enough that a rebuild against the same requirements usually produces a better result.
Often combined with
Most engagements touch more than one of these. We scope them together rather than selling them separately.
Start with the problem
Send the file or describe the problem. An hours estimate back within a day, at no cost.
Post your project