Budget: 6000 UAH Deadline: 3 days
We can take the first stage - auditing the structure, searching for errors in formulas, correcting calculations, and providing a brief explanation of the logic for your team. The timeframe is estimated at 2-3 working days after access to the spreadsheet and a description of the problematic areas. The budget for the first stage is from 6000 UAH, as it is important not just to tweak one formula, but to check the connections between sheets to ensure that payroll calculations do not break further.
Look, there’s a nuance here - in such spreadsheets, the error often lives not where it is visible. Therefore, I would start with a map of sheets, dependencies, key formulas, and verification control totals. If there are Google Apps Scripts, we will separately look at triggers, access rights, and data update scripts. In general, it’s fine to do this as a small stage, without unnecessary bureaucracy =)
I need 2 clarifications.
> Are there scripts, imports, or automatic data updates in the spreadsheet?
> Are the errors currently in all calculations or in specific employees, periods, or types of work?
Similar logic projects by Ingello.
> https://business.ingello.com/forma-bpm - automation of business processes and control of operational logic
> https://business.ingello.com/forma-crm - accounting systems, roles, relationships between entities and workflows
> https://systems-fl.ingello.com/ua - main page of Ingello Systems for FLH
!!For an accurate assessment, access to a copy of the spreadsheet or a view of the structure without personal data is needed!! After that, I will say whether a pinpoint correction will suffice or if it’s better to move part of the logic into protected formulas or scripts so that the spreadsheet does not need to be fixed every month.