Until then, try playing around with the different form controls to see how they can improve your Excel-based engineering applications. The logic will run different calculations based on what the user has selected. Stay tuned for next week’s post, where I will create the spreadsheet logic for the mass moment of inertia calculator. It changes to “2” when the second button is selected, and so on.ĭo you see how we might be able to use this to our advantage later on? To be continued… When the first button is selected, the output cell value changes to “1”. Now, we can see what the radio buttons actually do. If the motor and pump inertia values are not available, you can use this calculator to determine an estimate by entering values for the following attributes. Inside the Control tab, click inside the “Cell link:” box, then select a cell on the worksheet. Then Right-Click and select “Format Control”. To set the output cell for all buttons, hold CTRL and click each one. The result of the user selection is output to a cell in order to use it later in the calculations.
Then edit the title like any normal text box. Section Modulus using Moment of Inertia calculator uses Section Modulus (Moment of Inertia)/(Distance from Neutral Axis) to calculate the Section Modulus. To edit the labels beside the radio controls, hold CTRL and click the radio button until the control is outlined with a box. To make it simple for a future user to intuitively choose between the shapes, I added “radio button” form controls underneath each drawing. The moment-of-inertia calculator can be used to assist you if you are having trouble determining the second instant of area for any common shape (such as a round or a hexagon). I started with some simple drawings of the four shapes for which I want to calculate mass moment of inertia: solid cylinder, hollow cylinder, disk, and a block. Then select Developer from the list of “Main Tabs” and click OK. To enable the Developer tab, click File>Options>Customize Ribbon. If you don’t see a Developer tab in Excel, you will have to enable it (it’s disabled by default). You can find these controls under the Developer tab. Form Controlsįorm controls are a great way to add an easy-to-understand user interface to your spreadsheets.
Moment of inertia calculator how to#
In today’s post, I’ll demonstrate how to accomplish goal 1.
There are a few goals for this calculator: If you could use a spreadsheet like this, then you can follow along and build it yourself. However, this demonstration will illustrate how to use a few advanced Excel features to create a custom engineering “app” within Excel.
Moment of inertia calculator series#
Today’s post kicks off a multi-part series where I will create a mass moment of inertia calculator in Excel.
0 kommentar(er)
