Gear Shift Lever Design Expert System


We develop expert systems or artificial intelligence systems which use sophisticated algorithms to select proper components from a myriad of choices by simply entering answers to simple questions. Once the answers are provided the program goes about evaluating the rules to determine the proper solution. This is far more than a simple table look-up.   It ranks solutions when there are more than one and bases the ranking on the rules. Drawings, specifications and prices are commonly part of the solution

Gear Shift Lever Design Example

Expert System Developed For Eaton Corporation By Mitchell Selling Dynamics, Inc.

Expert System Objective:

The objective of this Expert System is to allow users to select simple choices from available options and allow the computer to construct a drawing and create machining parameters for computer driven machines to manufacture the truck gear shift lever from a solid, straight piece of steel.

Operating Systems

This PC based version of the Lever Program runs out of Microsoft Access. This version (1.0) of the Program requires that Access 97 be installed on the Workstation computers that will use the program.

The Application

The application is divided into three parts:

  1. LeverDat1.mdb contains the data used by the program and should be loaded onto an accessible directory on the Central Server that can be accessed by the Workstations over the local network.
  2. LeverFrm1.mdb contains all of the forms and code that the Users manipulate to design a Lever and display its features on both Screens and Printers. LeverFrm1.mdb should be loaded on to each User’s Workstation computer.
  3. Ball End and Lever End graphical cells. Ball end cells are graphical images (Windows bitmap format) which are used to display the ball end forms on drawings. Ball end cells have the format "NCxxxx.bmp" and all should be loaded into a directory on the Server that can be accessed by the Workstations over the Network. Lever end cells are graphical images (Windows bitmap format) that display the lever threaded end shapes and dimensions. Lever end cells have the format "NVxxxx.bmp" and should be loaded into a directory on the Server that can be accessed by the Workstations.

Lever Program Expert System Main Menu

The Main Menu provides access to all of the features of the program. The Main Menu consists of a group of nine buttons as shown in the figure below.

Customer Information Screen

The customer information screen allows Eaton to store information about the customer’s company and the customer’s employees. There is additional information that can be stored and functionality that is helpful to Eaton to keep track of what is going on with the customer.

Lever Data Screen

This screen shows the choices that can be selected by the user to allow the Expert System to construct the drawing and create the machining parameters.

Drawing Created By The Expert System

The Expert System uses the information from the selected options and constructs the drawing and creates the machining parameters.

Additional Functionality

  • The Expert System outputs a text file with machine parameters
  • It automatically emails the text file to the manufacturing facility
  • The program creates a file for coordinate measuring machines to use to verify quality

To view an Expert System on the internet click on the following link: Web Expert System.


Typical Expert Systems

Tooling package selection
Cross-reference selection
Network hardware and software proposal development
Construction project plan development

Your Cost

This type of Expert System involved over 500 hours of programming time and installation visits.


Mitchell Selling Dynamics, Inc.
Since 1990


1360 Puritan Avenue, Birmingham, Michigan 48009, USA
Phone: 248-644-8092

© Copyright 1996-2014 Mitchell Selling Dynamics Inc.