Your Excel model. A calculator others can use.
You already have a spreadsheet that calculates a price, estimates savings or plans materials. Give clients and colleagues a focused interface to that model: they enter values and see results in a browser, without receiving the source workbook.
Three ways to put your model to work
Start with a calculation you already use and can verify. These are examples of what to build with your own workbook, rather than ready-made calculators.
Custom quotes and pricing
Let prospective clients explore an indicative price before discussing the details with your team. Keep the pricing rules in the model you maintain in Excel.
- Inputs to expose
- Dimensions, material, quantity, options and installation.
- Results to show
- Estimated total and the cost breakdown your model provides.
Explain what is included and when a final quote requires confirmation.
Savings and payback scenarios
Help a customer explore the economics of equipment or a service using their own assumptions. Make the calculation and its limits easy to understand.
- Inputs to expose
- Current costs, expected usage, investment and ongoing costs.
- Results to show
- Estimated savings, comparison of scenarios and payback period.
Label assumptions and estimates; a model is not a guarantee of future savings.
Materials and production costs
Give colleagues a repeatable way to estimate a job using the material and cost formulas in your existing workbook.
- Inputs to expose
- Job dimensions, batch size, material rates and waste allowance.
- Results to show
- Material quantities, estimated waste and production cost.
State units, rounding rules and the conditions in which your model applies.
From workbook to published calculator
Prepare your workbook
Use an XLSX workbook with defined names for the cells or ranges you want to expose. Keep a few known input and result combinations to check the calculation.
Upload it to your workspace
Sign in to xlTalky and upload the workbook. Published web calculators use cloud calculation. The Excel add-in also supports local workbooks, which are a separate workflow.
Choose inputs and results
Classify the named ranges as inputs or outputs. Choose clear labels, appropriate controls and the order in which people will see them.
Check the calculator
Open the calculator view and compare its results with your known examples. Check the workbook functions, accepted inputs, units and rounding before publishing.
Publish and share a link
Publish the calculator and open the link as a recipient would. Share the interface with your clients or colleagues; they do not need Excel to use it.
Decide what your audience should see
A calculator works best when it answers one clear question. Expose the inputs needed for that answer, then label the result and explain its assumptions.
- Use descriptive field names and show units such as hours, metres or currency.
- Test typical values, boundary values and invalid combinations against your workbook.
- Explain whether tax, delivery, installation or other costs are included when relevant.
- Share only the inputs and results intended for your audience. Review the publication settings before distributing a link.
- Check the published result after changing the model; do not assume an old link reflects an update without verifying it.
Share the result, keep the source workbook private
People using a published calculator receive the interface and the selected results, rather than a download of your Excel file. Uploading a workbook for cloud calculation still means the service processes that workbook. Review the privacy policy before uploading sensitive information.
Read the privacy policyBefore you start
Does the recipient need Excel?
No. A published web calculator runs in the recipient's browser interface, with calculations performed by the cloud service.
Do I need to rewrite my formulas as website code?
Your workbook remains the calculation model. You configure which named inputs and results appear in the calculator. Verify that the functions used in your workbook give the expected results.
Can this help with incoming sales enquiries?
You can share an indicative pricing calculator so prospects can explore options before contacting you. Measuring its effect on qualified enquiries and sales requires your own sales process and analytics.
Where should I start?
Choose a small, representative workbook with known results. Build and test one calculator before preparing a larger set of models.
Start with a model you already trust.
Open your workspace, prepare the named inputs and results, and build your first calculator.