Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


App/Software for "selection" of things

App/Software for "selection" of things

App/Software for "selection" of things

I have a couple of common questions asked by my Sales team. I want a software that helps people to narrow down from a list of options based on the information they know.

One example is helping identify the correct pipe flange. (Customers often don't appreciate that a '30" manway' is not enough to know for sure what they have). They might know the nominal pipe size - then enter it and watch the list shorten. Then enter the number of bolts and see it reduce further. And continue on until one possibility is left, which becomes the result.

I would do a plain datasheet but the pieces of available information will vary, and it's important to know how much data is enough without wasting time on numerous redundant measurements. Plus somebody would have to review the datasheets over and over.

I'd like to build an app that allows me to enter a table of data, and then a series of questions that guide the user to narrow the list until it comes down to a final identification. Then have it output the details of that final selection. Kind of reminds me of those "choose your own ending" books I read as a child.

Perhaps there is a software that does this for diagnostic situations, or taxonomy of wildlife, or anything that helps hunt down an answer that we can use as a framework and limits our setup to the table of data and guiding questions. I suspect this can be done using Excel, but I'm concerned Excel won't be portable enough.

Anyone understand what I'm saying? Have any suggestions?

RE: App/Software for "selection" of things

I can give an example that you might aspire toward:

I don't think Excel can do it.
Maybe you can figure out something from McMaster-Carr's visible code.
Maybe you can just call them and ask where to start.

Mike Halloran
Pembroke Pines, FL, USA

RE: App/Software for "selection" of things

Mike, you're right. This is the same basic problem as solved by any number of website catalogs. Enter what you know until you find the item for you.

This is especially interesting because in my mind, this app would be powerful for us as a web-based interface, and possibly available on mobile devices too.


RE: App/Software for "selection" of things

Our vehicle suspension spec sheets (47000 buildable combinations is the worst I know of) use excel. each column has a drop down list of check boxes, so you just tick the combination you want, say 134 N/mm springs, and 31mm sta bar, and then it filters the results, so i can see which shock absorbers go with those . It's automagically available in Excel 2010, which I otherwise despise. Insert table is the command. Here's a demo


Greg Locock

New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?

RE: App/Software for "selection" of things

Thanks Greg, that Excel feature seems to be doing what I want. It might not be quite as slick as a web interface but it's close and very easy to build.

I made a version for my flange application and will see if the team finds it useful.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


eBook - Manufacturing the Cars of Tomorrow
In this ebook, we'll explore how additive manufacturing is going to transform the way cars are made. This includes commentary from thought leaders such as Ford's CTO, Ken Washington, Customer case studies of ways 3D printing is being used today, and a variety of part examples where 3D printing is already impacting how automobiles are made. Download Now
White Paper - Smart Manufacturing for Semiconductor
New technologies and approaches present great opportunities for semiconductor manufacturers to achieve high levels of innovation, yield and improvement. This white paper explores some of these cutting-edge technologies and how they can be applied effectively in the semiconductor industry. Read about how Smart Manufacturing is transforming the semiconductor industry. Download Now
White Paper - Analysis and Simulation in Aircraft Structure Certification
Organizations using simulation and analysis tools effectively see the benefits in their ability to achieve certification faster and with drastically less total cost than those who do not maximize these tools. Read this White Paper to learn about how digital tools such as analysis and simulation help in aircraft structure certification. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close