The first tool offered by Whatifster’s is an input-linked slider. Simple as it may seem, this widget alone makes it possible to manipulate the entire model. Any and all dependent variables – whether in the form of standard Excel-based charts and graphs or just regular numerical values – will readily respond to every movement of the sliders.
Creating sliders in Whatifster is simple and intuitive. For details, a step-by-step manual is provided below. We will be happy to make additional clarifications if needed – send us an email using the “Contact us” button at the top of the page.
You can install Whatifster directly from Microsoft AppSource, as any other add-in.
To launch Whatifster, open your model in Excel and click Insert – My Add-ins drop-down menu – Whatifster.
You will see the Starting Window that acts as a library of widgets.
Clicking anywhere on the Starting Window will reveal a small grey “i” button in the upper right corner providing several menu options, including Delete.
In the Starting Window, click on Slider to open the interface.
Select the type of slider by choosing between Horizontal or Vertical options at the top. The inner layout of the interface will change accordingly.
Create a name for the slider by writing it into the Name Your Slider field at the top.
To bind the slider to a cell to be controlled, click on the Bind button in the center of the interface and then click on the target cell. In order to choose a cell within a different worksheet, select that sheet first and then click the target cell there.
Define the desired variation range for the target cell by entering minimum and maximum values into From and To fields, respectively. When done, these fields will automatically pick up the formatting of the value in the target cell.
Define the incremental change within the variation range by writing it in the Step field. Use decimals if necessary.
Click Apply. If this button turns red, check on all of the fields within the interface in order to make sure that they are filled in as required.
To format the slider, click on the border of the slider widget. When it turns into a double line, the borders can be stretched out or brought closer together, and the widget as a whole can be moved around the worksheet.
To re-edit the slider, click inside the slider widget and then click on the grey button with two horizontal sliders in the top right corner. This will reopen the original interface with pre-populated fields, which can then be edited.
You can create and place as many additional sliders as you want by copying and re-pasting an existing widget, or by opening the library from My add-ins dropdown menu.
We will be grateful for your comments and suggestions. To do that or to leave a review, please use the button on top of the page or send us a message at firstname.lastname@example.org.