Custom applications / practical delivery
Explain what the workbook does before estimating its replacement.
Two workbooks with the same number of sheets can represent very different projects. Prepare a conversion scope around the decisions people make, the records they rely on and the work that must continue after the first release.
Separate calculations from decisions
Choose one task and follow it through the workbook. Note which cells are entered, calculated, copied from another source or changed after someone approves an exception. Include hidden tabs, linked files and staff instructions that sit outside the spreadsheet.
For each rule, bring a harmless ordinary example and a difficult one. A discount calculation may be straightforward; deciding who can override it, why and what the next person sees adds work. Identify the person who can settle an unwritten rule rather than asking a developer to infer it from inconsistent rows.
Choose the records and history that must move
Distinguish current work, reference information and history needed to explain earlier decisions. List stable identifiers, linked records, attachments, repeated headings, duplicate candidates and inconsistent units. Ask who approves cleanup and which original references must remain available.
Agree a sample import and a reconciliation method. Check representative records and their relationships as well as counts. Keep rejected or ambiguous rows in a review list with an owner. Migrating a large volume of consistent records may require less judgment than untangling a small set of conflicting ones.
Describe access through real tasks
Write down who may view, enter, correct, approve and export each kind of information. Include staff covering an absence and someone who should be denied a record. A shared workbook account may hide differences that the replacement needs to make explicit.
Decide what happens when two people edit the same item. Specify how a person learns whether a save succeeded and how an earlier version is handled. These decisions affect the application and the checks needed to accept it.
Name the owner at each connection
List accounting, customer, stock or other tools that exchange information with the workbook. For each exchange, state the owning record, direction, frequency and expected result. Identify who can provide approved access and confirm the connection method.
Include an unavailable service, a rejected value and a delayed response in the discussion. Ask how staff find an incomplete handoff before trying it again. Available provider features, plans and access must be checked for the actual project before treating a connection as a settled part of the estimate.
Separate the first delivery from continuing work
A useful first phase might let one team create a request, have it reviewed and retrieve the saved result using checked data. Name the records, roles and exceptions included. Put later departments, historical cleanup and optional reporting in explicit later or excluded work.
Ask for ongoing hosting or subscriptions, backups, updates, support, account administration and future rule changes to be described separately. Name who owns each responsibility after handover, including any vendor charges paid directly by your business.
Bring a scope another person can examine
Prepare a safe description of the workbook, example inputs and results, current tools, user roles, approximate usage and the reason for the deadline. Ask an estimate to state assumptions, exclusions, acceptance checks, migration responsibilities and the change process. A shared list of open decisions is more useful than an unexplained total.
Review the spreadsheet-to-app service, use the provider comparison questions or discuss the first workflow.