×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*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.

# BASIC MIN /MAX CALCULATION- VERY BASIC

 Forum Search FAQs Links MVPs

## BASIC MIN /MAX CALCULATION- VERY BASIC

(OP)

Hello All, Good Evening
I just want to start with a very basic question. I would like to use the excel file to find my Min /Max Values. I have downloaded that excel from this forum.
I want to start with your guidance rather assuming something wrong
.

Then I would like to figure out myself on shift and bonus when I get fundamentals right. Appreciate your help

(OP)

### RE: BASIC MIN /MAX CALCULATION- VERY BASIC

You asked when to use the + or - in the Max (or Min) column. That depends on the direction that the vector is traveling in your "stack path." So before filling in that spreadsheet, you should sketch a starting point and an ending point to the distance you are solving for, and then sketch some vectors to get from start to finish. ((Within those vectors, you sometimes also have position tolerances, along with "bonus" or "shift" tolerances.)

However, the sketch you provided won't have any bonus or shift; it just uses traditional ± distances between the 2 holes and 2 pins.

So your question is a little more involved... We'd have to give you a crash course on tolerance stack analysis. But the main answer is that the + and - numbers to fill in depends on having a path of connected dimensions.

### RE: BASIC MIN /MAX CALCULATION- VERY BASIC

The answer to your question depends on what "minimum diameter" means. The following should allow you to work with whatever definition you like.

I have a GeoGebra file attached that lets you work with this problem. I have scaled the majority of the dimensions down by a factor of 10 and reduced the spacing to better fit on the sheet.

The check boxes select the various conditions:
1) Sets the pin distance position tolerance to positive, else it is negative
2) Sets the hole distance position tolerance to positive, else it is negative
3) Sets the left pin diameter size to use the positive tolerance, else it is set to the negative one
4) Sets the left hole diameter size to use the positive tolerance, else it is set to the negative one
5) Sets the calculation as if the left hole is pushed to the left against the pin, else it is pushed to the right
6) Set the right pin diameter size to use the positive tolerance, else it uses the negative one

At the bottom of the list is the expected hole diameter for the right end hole.

GeoGebra is available for free from https://www.geogebra.org The file I created is from GeoGebra Classic 5 for Windows. See https://www.geogebra.org/download for Classic 5 and Classic 6.

It looks like:

The right side hole diameter is marked in red.

If a change is made that breaks the diagram then just reload from the one I posted. For no reason it sometimes evaluates the results as true/false rather than numbers. Maybe they fixed it in Classic 6. Anyway it's free, so you get what you paid for, a bargain at twice the price.

### RE: BASIC MIN /MAX CALCULATION- VERY BASIC

(OP)
Thank you Belanger

Please see attached. I have gone through several threads and got an idea on how to use excel file. Brain started to explode but managed to make some progress since morning.
1- Is my chain dimensions correct??? ( A to F). Do you see any errors. Regards

3D DAve

Thank you let me download and go through your instructions. Looks' interesting.

#### 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.

#### 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

#### Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a partâ€™s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. 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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!