U
ufo_pilot
Need a 'singe cell' (or best) formula to calculate the bonus tolerance for a
true position on a circle for a dimensional check.
I have the formula in 6 cells, but can't get them shrunk enough to be able
to fit 3 cells or less.
using cells for: upper, lower, and total tolerance for diameter (+/-0.2mm)
upper, lower spec. limits (6.2mm, 5.8mm)
actual measured diameter (6.123mm)
nominal diameter (6.00mm)
nominal true poisitional tolerance for circle
(1.00mm)
The formula will show that if the circle dia is smaller than the LSL (5.8mm),
the circle will get 0.00 bonus added to the position tolerance of the circle.
as the measured circle gets larger (LMC -least material condition) a bonus
is added to the circles positional tolerance. But a circle will never receive
more than the positional tolerance (1.00mm) + total tolerance (0.4mm). If the
dia. exceeds the USL(6.2mm),
the circle will max out at 1.4mm tolerance
the sample abobe would receive a bonus of 0.277mm for a total poistional
tolerance of 1.277mm
true position on a circle for a dimensional check.
I have the formula in 6 cells, but can't get them shrunk enough to be able
to fit 3 cells or less.
using cells for: upper, lower, and total tolerance for diameter (+/-0.2mm)
upper, lower spec. limits (6.2mm, 5.8mm)
actual measured diameter (6.123mm)
nominal diameter (6.00mm)
nominal true poisitional tolerance for circle
(1.00mm)
The formula will show that if the circle dia is smaller than the LSL (5.8mm),
the circle will get 0.00 bonus added to the position tolerance of the circle.
as the measured circle gets larger (LMC -least material condition) a bonus
is added to the circles positional tolerance. But a circle will never receive
more than the positional tolerance (1.00mm) + total tolerance (0.4mm). If the
dia. exceeds the USL(6.2mm),
the circle will max out at 1.4mm tolerance
the sample abobe would receive a bonus of 0.277mm for a total poistional
tolerance of 1.277mm