Force Required to Fit (3 different materials)

[kieren12345]

I have three different parts:
1. An Aluminum Bronze Outer Ring
2. A Neoprene Ring
3. A Phenolic Composite Ring.

The (2) fits into a recess in (1), (2's) purpose is to seal between (1) & (3).

What I would like to do is create a calculator on excel that will calculate the force required to insert (3) into (1) & (2).

I am presuming that the Formulas here won't work as I have the neoprene compressing but also being backed up by the aluminum bronze.

Any help will be greatly appreciated. I have a little maths and physics knowledge at HND level but that's my limit I am affraid.

Thanks
Kieren

 

[kieren12345]

sorry missed the link to formulas

http://www.engineersedge.com/calculators/machine-design/press-fit/press-fit-equations.htm