← getting started

Create your first calculator

Updated 2026-06-22

This walkthrough takes you from a blank project to a published, shareable calculator: create the project, add inputs, wire up the spreadsheet, add results, and publish.

1. Create the project

  1. From your workspace dashboard, start a new project.
  2. In the Start a new project dialog, give it a Name.
  3. Optionally, import an Excel file: drag a file onto the dropzone or click to browse. Importing seeds the Formula spreadsheet with your numbers and formulas. A downloadable template link is provided for best results.
  4. Click Create project. Numio opens the editor.

You can always import or edit the spreadsheet later, so importing now is optional.

2. Add input blocks

Open the Input tab. Click + Add and choose a block type. Available input blocks:

  • Input Field — a single number, currency, or percentage entry.
  • Slider — a value chosen along a min/max range.
  • Dropdown — a single-select list of label/value options.
  • Selection — radio or multi-select cards (multi-select sums the selected values).
  • Toggle — an on/off switch that emits a set value when on and 0 when off.
  • Text and Divider — layout-only blocks with no value.

Add one block per value your visitor needs to enter. Click a block to open its settings panel and set its label, default value, and number format.

3. Wire inputs to the spreadsheet

Open the Formula tab. This is a real embedded spreadsheet.

  • If you imported a file, your data lives here (the imported sheet starts at column D, and references are rewritten so everything still computes). Multi-sheet files become multiple tabs.
  • If you didn't import, type your numbers and formulas directly into cells like you would in Excel.

Next, assign each input to a cell so the input's value flows into your model:

  1. Select an input block and find its Formula box in the settings panel.
  2. Click Assign. The spreadsheet overlay slides in.
  3. Click the cell the input should write into.
  4. Click the confirm button — it reads, for example, Assign B7.

The box now shows the bound cell with a Change option. While you build, the input's current value is pushed into its cell so the preview updates live.

Numio supports a defined set of 23 spreadsheet functions (SUM, AVERAGE, MIN, MAX, COUNT, ROUND, ROUNDUP, ROUNDDOWN, ABS, SQRT, POWER, CEILING, FLOOR, IF, AND, OR, NOT, IFERROR, VLOOKUP, HLOOKUP, INDEX, MATCH) plus operators, ranges, absolute refs, and cross-sheet refs. Unknown functions and division by zero evaluate to 0.

4. Add result blocks

Open the Output tab. Click + Add and choose a result type — for your first calculator, Numeric is the simplest. Then assign it to a cell:

  1. Select the result block.
  2. In its Formula box, click Assign.
  3. Click the cell that holds the computed value, then confirm.

The result reads that cell's value back and displays it. Set its number format, decimals, and label in the settings panel.

5. Style it (optional)

Open Settings to pick a Theme, set fonts and Corner Radius, and toggle the workspace icon or wallpaper. Your workspace branding (logo, color, font) is applied automatically.

6. Publish

  1. Click Publish in the top bar. (It's enabled once you have unsaved changes.)
  2. The Publish dialog reviews your formulas. If a result's formula isn't valid, it's flagged in red and publishing stays disabled until you fix it.
  3. Click Publish. On success you'll see a View Sandbox button to preview the live version.

7. Share or embed

Once published, the share icon in the top bar is enabled. Use it to grab a public share link or an embed snippet for your website.

Where to go next