Tech Tuesday: The Grid Control

Jeremy Hynek

Howdy, folks. This will be the first installment of what we hope will become a regular feature around here. Each Tuesday, look for an article highlighting a technical aspect of our software. This may be a demonstration of a feature, an explanation of the mathematics that power the tools, or some comments on technical support questions that we’re frequently asked.

Today, I’ll be talking about the Grid Control feature of our Availability Workbench and Reliability Workbench tools. If you’ve used our AvSim or FaultTree+ software, you know the power of the tool, and the usefulness of the diagram view to be able to create and edit intricate Fault Tree or Reliability Block Diagrams (RBDs). However, sometimes you may find that you have to do some task, such as text entry, or finding and replacing some information, that can be cumbersome to perform in the diagram view.

For instance, suppose you’ve created a large, multi-page Fault Tree, and now you want to add unique IDs and descriptions to all the gates and events, so you can identify what each one represents. To do this in the diagram view, you’d need to locate each item individually, double-click to open the Properties dialog for the gate or event, set the ID and description, click “OK” to close the dialog, find the next item, rinse, and repeat. There’s a lot of back-and-forth between mouse and keyboard, and hunting through the diagram for the items you want.

Properties
The Event Properties dialog from FaultTree+

 

The Grid control helps with this by providing a tabular format for editing data, similar to what you’d see in Microsoft’s Excel or Access products. Each gate or event appears on one line of the grid, and you can use the cursor keys, or the tab key, to navigate the records and fields. To edit some text, simply highlight a field with the mouse or keyboard and start typing, or press Enter on your keyboard.

Grid
The Grid view in FaultTree+

From the grid view, you can use the table selector to choose which data you want to display. This might be the Gates, Events, or Failure Models table in FaultTree+ , or the RBD Blocks or Failure Models table in AvSim.

TableSelector
Grid Table selector

With a given table selected, you can refine which records should be displayed by using the “Filter Grid by Tree Control Selection” option, found in the Grid menu. This mouthful-of-a-name simply means that data will only be displayed in the Grid if it’s relevant to the selection in the tree control on the left hand side. For instance, selecting a particular gate in the Fault Tree hierarchy will only show events under that gate, or selecting a Failure Model group in the AvSim project will only display failure models in that group.

FilterByTreeControlSelection
“Filter by Tree Selection” turned on; note how only events logically dependent on the selection on the left are displayed in the grid.

There are plenty more options in the Grid view that allow you to choose what data is displayed. You can use the Grid Layout options to choose what columns should be displayed, and what their order should be; the Grid Filter provides further methods of filtering records; and the Grid Sort allows you to choose how the records are sorted. And any custom grid layout, filtering, or sorting you’ve created can be saved, so you can share it with your colleagues or transfer it to a new computer. You can even copy and paste data directly from the Grid view to a spreadsheet application like Microsoft Excel.

GridOptions
The options under the Grid menu. Layout Options, Filter, and Sort are all near the top. Options to import and export grid layouts are near the bottom.

There’s even a Find & Replace feature, for when you need it. The cool part is, when you use Find & Replace, it will only apply to the currently-displayed records. If you use a filter to hide certain rows, they won’t be included in the replacement.

FindandReplace
The Find & Replace dialog. This works exactly like you’d expect.

And for those times when you want the Properties dialog, you can just double-click the grey space to the left of a grid row to open the Properties dialog for the item.

Why don’t you take a look at the Grid control, and try it out? I’ve found it to be a great tool to use when quickly building or editing a project.

Monte Carlo Simulation

Jeremy Hynek

Happy MLK jr day,

For those of you working today I thought I would give a little background on Monte Carlo Simulation (MCS). I have to admit that when asked I have tied MCS back to the gambling industry more than once. It sounds like a good story, however, it turns out the name comes from the resemblance to the act of playing and recording your results in a real gambling casino.  MCS techniques are often used in physical and mathematical problems and are most useful when it is difficult or impossible to obtain a closed-form expression, or in-feasible to apply a deterministic algorithm. Monte Carlo methods are mainly used in three distinct problem classes: optimization, numerical integration and generation of draws from a probability distribution.

The modern version of the Monte Carlo method was invented in the late 1940s by Stanislaw Ulam, while he was working on nuclear weapons projects at the Los Alamos National Labs. It was named by Nicholas Metropolis, after the Monte Carlo Casino, where Ulam’s uncle often gambled.  Immediately after Ulam’s breakthrough, John Von Neumann understood its importance and programmed the ENIAC computer to carry out Monte Carlo calculations.

So although gambling is a reference it’s not the reason for or used in the gaming industry… we at Isograph use MCS techniques to solve problems that cannot be solved using quantitative methods. Optimizing Preventive Maintenance Intervals, deciding the perfect number  of spares to have and where to keep them as well as optimizing the configuration of your system are just a few of the problems we can solve with the Availability Workbench using Monte Carlo Simulation. However, we cannot tell you where to place your bets or what number to choose on the Roulette Wheel.

The following is a short demonstration as to how we use MCS together with FMEA’s for RCM analysis or Block Diagrams to model complex systems logic.

Availability Workbench using Monte Carlo Simulation

 

Isograph at RAMS 2014

Jeremy Hynek

For almost 2 decades Isograph has been supporting the RAMS conference in various locations around North America. The week of January 27 Isograph will again be attending RAMS 2014 which will be held at The Broadmoor Hotel in Colorado Springs, Colorado. In addition to the exhibits the conference will offer tutorials, technical presentations, CEUs and certifications such as the ASQ Certification Exams – ASQ Certified Reliability Engineer (CRE), Certified Six Sigma Black Belt (CSSBB) and Certified Six Sigma Green Belt (CSSGB).

For more information on RAMS please go to www.rams.org

Broadmoor Hotel