Using the Interactive Calculator
The interactive calculator block allows you to personalise calculations during your sales process. It enables value-based selling by serving as an ROI calculator to showcase the value of your solution to a buyer. The interactive interface allows buyers to easily adjust the inputs based on their specific situation. The flexible setup also enables other use cases e.g., using it as a quoting engine based on custom inputs.
We recommended to configure the underlying calculations and logic once in a template (more on this below) and then simply adjust the inputs to reflect your buyer's business when creating a space. Adjusting the inputs is straightforward:
Click on "adjust inputs" in the upper right corner to open a pop-up with the default inputs.
Change the default inputs e.g., by selecting the right category in a drop-down or adjusting the numbers. Navigate to the next page, if available, to continue changing the inputs.
To finish, click on "recalculate". The pop-up will close and show the updated results.
Within a few seconds, the results will be recalculated and appear in the block. The inputs can be adjusted as often as you'd like.
To learn more, watch our introduction to the interactive calculator:
Initial setup of the Interactive Calculator Block with Google Sheets
The calculation logic and formulas only need to be set up once in a Google Sheet during the template creation. Afterwards, the Google Sheet will be duplicated each time a new space is created. Of course, you can also adjust the block or create new interactive calculator blocks in spaces for individual customers. Here’s how to add an interactive calculator block and the Google Sheet calculations:
To add a new block, click the blue “+” button in the sidebar and select the "Interactive Calculator Block".
In the sidebar, click "open" to open the Google Sheet.
The linked Google Sheet will open in a new browser tab, where you can create the underlying calculation logic. Here You have three tabs that you can adjust:
Input: Here you can define the input parameters. You can provide additional context to your buyer by adding pages, line items, units, and a description. Further you can also enable drop-down answers.
Calculations: This is where the calculation logic sits. Use the inputs from the first reference tab and manipulate them as you like, using formulas and any other capabilities available in Google Sheets.
Output: Link the result of your calculations to the value column and choose how they should be displayed by adjusting the type, title, description, and unit columns as you see fit.
Navigate back to Valuecase and click on "refresh" in the sidebar to update the block. Now the adjusted data will show.
For more information, also check out our Loom video for a visual explanation of the Valuecase <> Google Sheets mapping: