Skip to main content

Excel Mixer Nano: Add Sliders to Control Cell Value. See Results in Real-Time

Excel Mixer Nano is a fantastic add-on for Microsoft Excel that allows you to adjust values in a cell with the help of sliders and observe in real-time how the result of a formula change as you vary the inputs. It can be used to study how different inputs in a mathematical or scientific formula has an effect on the result.

To illustrate, here is an Excel sheet that calculates the volume of a cylinder from the radius and height of the cylinder. The volume of the cylinder is given by (Pi) x (radius)2 x (height).

excel-mixer-vol

The values assigned to radius and height are currently 10 and 30. But I want to see how the volume of the cylinder would change if I change the radius and the height of the cylinder.

So I fire up Excel Mixer Nano, click on the value 10 and then click on the ‘New Slider’ button. This creates a slider that allows me to adjust the value of the selected cell. I do the same for height and get another slider. Now as I move both sliders up and down, the result in the formula cell changes in real-time too.

excel-mixer2

In another practical example, I’m trying to find out how the distance of a projectile varies as you change the angle and velocity. Notice, the maximum distance is achieved at 45 degrees.

excel-mixer3

Though I’m using only two variables in my examples, there is no limit to the number of variable cells you can use.

Excel Mixer Nano doesn’t actually integrate with Excel. It’s a standalone program that can read data from an Excel sheet and feed data back to it. It doesn’t even require installation because it’s a portable program.

The Pro version of this program is vastly more powerful that can produce 3-dimensional graph of the output, allowing one make a visual analysis of mathematical and engineering equations. Watch the video demo of Excel Mixer Pro.

Comments

  1. This is definitely one of the best websites i have EVER come across with tips and tricks. Keep up the great work!

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Record CPU and Memory Usage Over Time in Windows?

Whenever the computer is lagging or some application is taking too long to respond, we usually fire up task manager and look under the Performance tab or under Processes to check on processor utilization or the amount of free memory available. The task manager is ideal for real-time analysis of CPU and memory utilization. It even displays a short history of CPU utilization in the form of a graph. You get a small time-window, about 30 seconds or so, depending on how large the viewing area is.

How to Schedule Changes to Your Facebook Page Cover Photo

Facebook’s current layout, the so called Timeline, features a prominent, large cover photo that some people are using in a lot of different creative ways. Timeline is also available for Facebook Pages that people can use to promote their website or business or event. Although you can change the cover photo as often as you like, it’s meant to be static – something which you design and leave it for at least a few weeks or months like a redesigned website. However, there are times when you may want to change the cover photo frequently and periodically to match event dates or some special promotion that you are running or plan to run. So, here is how you can do that.

Diagram 101: Different Types of Diagrams and When To Use Them

Diagrams are a great way to visualize information and convey meaning. The problem is that there’s too many different types of diagrams, so it can be hard to know which ones you should use in any given situation. To help you out, we’ve created this diagram that lays out the 7 most common types of diagrams and when they’re best used: