Add Single Variables in Discovery Wizard (Google Sheets Version)

Overview

This article focuses on adding single variables in the Discovery Wizard for Google Sheets, walking users through the process of incorporating individual data points into their value models. By adding single variables, users can create more dynamic and customizable models, where each variable can be adjusted independently to see its impact on calculations and outcomes. The article explains how to define these variables, set their properties, and link them to other parts of the model to improve interactivity and flexibility. This feature simplifies the modeling process, allowing developers to build more accurate and adaptable value models in Google Sheets.

Step-by-Step Guide

1. Follow the steps to Integrate with Google Sheets.

2. Click Discovery Wizard on the Visualizer Type page.

   
   
3. Follow the steps to Add Sections and Categories in Discovery Wizard.

4. Click Create Variable.

5. The Create New Variable pop-up box appears.

   
   
6. Click inside the Choose Cell text box.

7. The imported Google spreadsheet appears.

8. Click a value on the Google spreadsheet and its code reference automatically appears in the Choose Cell text box of the Create New Variable pop-up box.

9. Click inside the Descriptor text box.

   
   

10. Click the corresponding variable on the Google spreadsheet and it also automatically appears in the Descriptor text box of the Create New Variable pop-up box.

    
    
11. Click Create.

12. Click Advanced and it expands to show text boxes where you can add Minimum and Maximum values.

    
    
13. Click Create.

14. The variable and the value added appear on the Prototype page.

15. Click the Copy icon, if you want to copy the code reference.

15. You can add any number of variables to the prototype.

    
    

16. Click the pencil icon to change the variable and/or the value.

    
    
17. Click the trash icon to delete the variable.

18. Enable Google Sheets Mapping to know the cell reference. For a step-by-step guide, follow the steps to Enable Google Sheets Mapping.