What if scenario xcelsius

In this way I have used Gauge and Spinner components to predict the outcome for the input entered by the user. Please feel free to share your views and ideas on the same and also share if you have any workarounds in such case.

Skip to Content. Technical Articles Prasanth S. March 10, 1 minute read. A sample data file and a working what-if analysis report are provided as download files to help you get started. Key Concept… Sign In Become a Member. By Kehinde Eseyin. December 01, December 02, Necessary cookies are absolutely essential for the website to function properly.

Before we move to the next step, there are three other items worth noting. First, you will see another icon to the right of the selector icon in the Properties panel double-click the slider to open the Properties panel if it is not visible.

These information icons are found throughout the Xcelsius application. If you click on them, a window will open and a brief movie will play illustrating the operation of the tool in question. You may close the window in the conventional manner when you are finished watching the movie. Also, if you look at the slider itself, you will note there is a blue slider button that represents the data value 5, in this case drawn from the spreadsheet.

The slider button is on the far left of the slider—almost at the zero point. The reason is that the slider scale goes to This is probably too large a number for the annualized growth rate of most product lines.

In fact, it can. Why did it work this way? The answer is simple. You would have to change the sales growth number in Row 4 of the Excel spreadsheet to decimals, and then change the formulas in Row 5 of the spreadsheet accordingly. Then, since you had modified the spreadsheet, you would have to re-import it into the presentation. You have now built your first interactive chart. Are you ready to see it in action? Place your cursor on the blue slider button and drag it. Immediately, you will note that the top bar on the chart grows and shrinks along with it.

As you mouse over the top bar on the chart, you will find that the sales volume value in the call-out changes depending upon how long the bar is. Click the existing slider, and then click the Copy button in the Xcelsius upper toolbar. Click on the canvas away from the slider, and then click the Paste button in the upper toolbar.

A new slider appears roughly on top of the first one. Drag it to a new position somewhere underneath the first slider. We have two sliders, but we need three more. So click the Paste button three more times to make three more copies of the slider on the canvas and adjust them until you have the five sliders roughly lined up, each somewhere below the other. Note that each item appears as an entry in the Object Browser pane.

Of course, as just noted, all the sliders are identical. To do that, click on this second slider to open its respective Properties panel. Proceed to make the equivalent changes for the other three sliders, changing both the title and data sources for each.

You should now see five sliders, all different—each representing sales growth rates for a different product line. Position the cursor below and to the right of the five sliders, click, and drag the bounding box to the upper left until all the sliders have been selected. When you release the mouse, you will see control handles on all five sliders. If you choose, you can move them around with the arrow keys on your keyboard until they are in the position you want.

If they are already de-selected, simply use the bounding box to select them again, and then move them with your arrow keys. After moving the sliders, your screen should look something like the illustration at the top of the next page. That is, you can move each of the sliders independently.

Note, as you do, that the bars on the bar chart move in response to changes in the individual sliders. A gauge is useful in this circumstance because it portrays a single variable, and because it is a familiar indicator for a rising or falling aggregate value. They provide clear and immediate feedback of our status in a given situation.

Open the Gauges folder and click each of the three gauge names to see what each looks like. Choose one of them we chose Gauge-1 , and drag and drop it on the lower right of the canvas. Use the control handles to increase the size of the gauge a bit.

Your screen should look like the depiction on the next page. Now that we have our gauge in place, the first thing to do is to link it to the embedded spreadsheet. We know that we want the gauge to represent projected total sales, so we need to locate that variable on the spreadsheet. To do so, double-click on the gauge to open the Properties panel. For one thing, the title is too small and is poorly positioned.

Note: depending on the settings on your computer, you may need to use amounts that are different than those presented here. Just keep experimenting until you get the result that you want.

We want it to be clear at a glance how close to our sales target we are. An alert is simply what it implies—a visual indicator of when we are close to, or far away from, a particular target. Now, we can make some choices. The first is our target value. Click the selector icon to the right of the input window, and select cell H5 in the embedded spreadsheet—the cell containing the target value. Fortunately, appearances can be deceiving. You might have noticed when you first enabled the alerts feature, the pointer on the gauge turned red and the perimeter of the gauge became multi-colored.

Then, when you selected the second radio button, the colors changed. Not good. Look at the color bar in the middle of the tab. That certainly needs to be changed! Look at the chart. Now, we have some real information. Luckily, Xcelsius provides us the Spinner component. Touch means big buttons for user input and as you can see on the right, the Spinner component is way too detailed. So we needed something else to do the job.

To solve this we used the new Push Button components. The Push Button simply does what its name says and pushes a value from a source cell to a destination cell. In the spreadsheet two formulas and a cell with a start value for the gauge C2 are created.