hoja cálculo tornillos

74
SEGÚN NORMA VDI 2230 GEOMETRIC DATA 30 METRICA 16 Fty (Mpa) 900 CALIDAD 10.9 Ftu (Mpa) 1000 diámetro (d 16 mm mm C-A 8 LA 8 A-B 70 LB 78 B-D 13.28 LC 4 LD 84.64 mm 2 W bolt Wp As 157 3293.81 554.94 mm Ds 14.14 pitch mm pitch diameter mm P 2 d2 13.49 * Nota: SECCIÓN PARA MODELIZAR EL TORNILLO: Sección cte de tensión (A * Nota: Datos INPUT, EN CELDAS AMARILLAS

Upload: gorrotxa0

Post on 30-Oct-2014

89 views

Category:

Documents


2 download

DESCRIPTION

archivo excell para el cálculo de uniones atornilladas

TRANSCRIPT

Page 1: hoja cálculo tornillos

SEGÚN NORMA VDI 2230GEOMETRIC DATA

30

METRICA 16 Fty (Mpa) 900CALIDAD 10.9 Ftu (Mpa) 1000diámetro (d) 16

mm mmC-A 8 LA 8A-B 70 LB 78B-D 13.28 LC 4

LD 84.64

mm 2 W bolt WpAs 157 3293.81 554.94

mmDs 14.14

pitch mm pitch diameter mmP 2 d2 13.49

* Nota: SECCIÓN PARA MODELIZAR EL TORNILLO: Sección cte de tensión (As) - Diámetro Beams (Ds)

* Nota: Datos INPUT, EN CELDAS AMARILLAS

Page 2: hoja cálculo tornillos

SEGÚN NORMA VDI 2230

H 1.73205081

: SECCIÓN PARA MODELIZAR EL TORNILLO: Sección cte de tensión (As) - Diámetro Beams (Ds)

Page 3: hoja cálculo tornillos

Element Int SF.SF1 SF.SF2 SF.SF3 SM.SM1 SM.SM2 SM.SM3Label Pt @Loc 1 @Loc 1 @Loc 1 @Loc 1 @Loc 1 @Loc 1 SHEAR

bolt number--------------- --------------- --------------- ----------------- --------------- ---------------- ----------------- ---------------1 4681 1 1.30E+05 1.88E+01 4.99E+00 -3.21E+02 2.90E+01 -4.14E-01 1.95E+01

14675 1 1.30E+05 1.88E+01 4.99E+00 1.16E+03 -3.65E+02 -4.14E-01 1.95E+01

2 4660 1 1.30E+05 1.29E+01 3.17E+00 -5.98E+02 1.67E+02 1.50E+01 1.32E+011

4654 1 1.30E+05 1.29E+01 3.17E+00 4.18E+02 -8.35E+01 1.50E+01 1.32E+013 4636 1 1.30E+05 9.31E+00 1.60E+01 -5.57E+02 4.02E+02 4.23E+00 1.86E+01

14630 1 1.30E+05 9.31E+00 1.60E+01 1.79E+02 -8.66E+02 4.23E+00 1.86E+01

4 4592 1 1.30E+05 3.23E+00 1.38E+00 -1.65E+02 6.95E+01 -5.79E+00 3.52E+001

4586 1 1.30E+05 3.23E+00 1.38E+00 9.00E+01 -3.98E+01 -5.79E+00 3.52E+005 4548 1 1.30E+05 1.47E+00 9.10E+00 -2.01E+02 2.25E+02 -2.92E+01 9.22E+00

14542 1 1.30E+05 1.47E+00 9.10E+00 -8.52E+01 -4.93E+02 -2.92E+01 9.22E+00

6 4534 1 1.30E+05 1.93E+00 1.79E+01 -1.10E+02 1.36E+02 1.14E-01 1.80E+011

4528 1 1.30E+05 1.93E+00 1.79E+01 4.20E+01 -1.28E+03 1.14E-01 1.80E+017 4520 1 1.30E+05 -5.20E+00 8.00E+00 2.17E+02 2.30E+02 2.91E+01 9.54E+00

14514 1 1.30E+05 -5.20E+00 8.00E+00 -1.94E+02 -4.02E+02 2.91E+01 9.54E+00

8 4506 1 1.30E+05 -4.73E+00 1.10E+00 1.61E+02 7.85E+01 5.13E+00 4.86E+001

4500 1 1.30E+05 -4.73E+00 1.10E+00 -2.13E+02 -8.77E+00 5.13E+00 4.86E+009 4492 1 1.30E+05 -8.82E+00 2.36E+01 4.23E+02 5.79E+02 -2.57E+00 2.52E+01

14486 1 1.30E+05 -8.82E+00 2.36E+01 -2.74E+02 -1.29E+03 -2.57E+00 2.52E+01

10 4478 1 1.30E+05 -1.08E+01 4.35E+00 4.54E+02 2.44E+02 -1.45E+01 1.16E+011

4472 1 1.30E+05 -1.08E+01 4.35E+00 -3.98E+02 -1.00E+02 -1.45E+01 1.16E+0111 4485 1 1.30E+05 -1.86E+01 4.97E+00 3.19E+02 2.77E+01 4.69E-01 1.93E+01

14479 1 1.30E+05 -1.86E+01 4.97E+00 -1.15E+03 -3.65E+02 4.69E-01 1.93E+01

12 4499 1 1.30E+05 -1.02E+01 -5.84E-01 4.09E+02 -1.20E+02 1.45E+01 1.02E+011

4493 1 1.30E+05 -1.02E+01 -5.84E-01 -3.95E+02 -7.42E+01 1.45E+01 1.02E+0113 4513 1 1.30E+05 -9.57E+00 -1.98E+01 4.30E+02 -4.47E+02 2.40E+00 2.20E+01

14507 1 1.30E+05 -9.57E+00 -1.98E+01 -3.26E+02 1.12E+03 2.40E+00 2.20E+01

14 4527 1 1.30E+05 -5.42E+00 1.44E+00 1.75E+02 -1.48E+01 -4.73E+00 5.61E+001

4521 1 1.30E+05 -5.42E+00 1.44E+00 -2.53E+02 -1.29E+02 -4.73E+00 5.61E+0015 4541 1 1.30E+05 -4.25E+00 1.39E+00 2.05E+02 -2.82E+02 -2.87E+01 4.47E+00

14535 1 1.30E+05 -4.25E+00 1.39E+00 -1.31E+02 -3.91E+02 -2.87E+01 4.47E+00

16 4580 1 1.30E+05 1.89E+00 -1.48E+01 -1.11E+02 -2.51E+02 -1.93E-01 1.50E+011

4574 1 1.30E+05 1.89E+00 -1.48E+01 3.80E+01 9.22E+02 -1.93E-01 1.50E+0117 4604 1 1.30E+05 4.15E-01 2.44E-01 -1.87E+02 -2.79E+02 2.88E+01 4.81E-01

14598 1 1.30E+05 4.15E-01 2.44E-01 -1.54E+02 -2.98E+02 2.88E+01 4.81E-01

18 4653 1 1.30E+05 3.92E+00 1.15E+00 -1.79E+02 -6.37E+00 5.39E+00 4.09E+001

4647 1 1.30E+05 3.92E+00 1.15E+00 1.30E+02 -9.72E+01 5.39E+00 4.09E+0019 4667 1 1.30E+05 9.82E+00 -1.28E+01 -5.55E+02 -2.87E+02 -3.24E+00 1.62E+01

14661 1 1.30E+05 9.82E+00 -1.28E+01 2.20E+02 7.27E+02 -3.24E+00 1.62E+01

20 4674 1 1.30E+05 1.22E+01 6.03E-01 -5.53E+02 -4.31E+01 -1.50E+01 1.23E+011

Page 4: hoja cálculo tornillos

4668 1 1.30E+05 1.22E+01 6.03E-01 4.14E+02 -9.07E+01 -1.50E+01 1.23E+01

MinimumAt ElementInt Pt

MaximumAt ElementInt Pt

Total

MAX 1.30E+05 1.88E+01 1.60E+01 1.16E+03 4.02E+02 1.50E+01

MIN 1.30E+05 9.31E+00 3.17E+00 -5.98E+02 -8.66E+02 -4.14E-01

BOLT FORCES DATASection forces in beam elements at the integration points (C y D):

SF1: Axial section force (N)SF2: Shear section force in direction 1(N)SF3: Shear section force in direction 2(N)SM1: Bending moment along direction 1 (Nm)SM2: Bending moment along direction 2 (Nm)SM3: Torsional momento (Nm)

Fx=SF1, Mx=SM1, My=SM2

Page 5: hoja cálculo tornillos

regardingtware prod options ahe hardwarrmationlisted bel orrect. If not, pleas ntact your MSC salesrepresentupdate thmation andbtain correauthorizationcodes.

MSC Techport Cent be reached at:

Internet il scnastran. rt@mscsofomm scpatran.s t@mscsoftm

World Wi b ttp://www. ftware.com/

France 3 3-1-6936-6936Germany 4 9-8943-1987-277Italy (Ro 3 9-6-527993-40Netherla 3 1-182-543700Nordic Coies 7-22-75-48-50Russia 7 0-95-236- 3.00E+00Spain (Ma) 4-91-5560919United K m 4-1276-601900

Thank yo joy our products!

Sincerely,

The MSC.Corporationhttp://ww tware.com/

* PLEAS E * PLEAPLEASE NPLEASE NOTE *

The "\" b sh characthe continu character fheFEATURE ines. All e last line a FEATURE blockMUST end"\" backs racter.

Please in this file, e of the lo lines may beenwrapped ltiple line ugh e-mail essing or btingand pasti rations.

Thank you.

Page 6: hoja cálculo tornillos

License for MSCAgreemenRE007414-MA-A0Configuranew mainwindowsHostid(s):0018FE262A8ACustomerProduct s Develop S.L. - Ped z - MAPO-6YDDYB

MSC Softorization tion

ProductPackageSub-product Users Stats Expires------------ ------------ ----- ---- ------ ------ --

0 Nast ic Packa 3.91E+04 3/2007 12 9.90E+01Nastran Backage 1.00E+00Nastran BasicConnectorsDMAP CompileDynamic nseHeat TransferADAMS Intion

# ------- S f License -----#SERVER t0018FE262A8A 1700DAEMON path/mscFEATURESC 2007.ec-2099 1 25D97636 \HOSTID=a8a ISSU-2007 ck=229 \SN=13879eb840b2cfc8aefFEATUREtors MSC1 31-dec-2\ADA662 BA04 HOe262a8a 13-feb-2007 \ck=111 -9c7ccf3 ba1dFEATURESC 2007.ec-2099 1 2CDF1759\HOSTID=a8a ISSU-2007 ck=64 \SN=1216f0489632bf6cf4aFEATUREcs MSC 231-dec-20 DF6C24DA89F \HOSTID=a8a ISSU-2007 ck=83 \SN=1069289218239f68a08FEATUREl MSC 20 1-dec-209 86D2ADF599 \VENDORD:3002,3 D=0018fe2\ISSUED=07 ck=47 24-cb78bb1fec25f6FEATUR Integrati 007.1231 -2099 1 \1DE612 9D77 HOe262a8a 13-feb-2007 \ck=40 S ### 2b5c## ------- License Fi-----## NOTES# 1. Thesization UIRE THE LATION# AND FLEXLM ERVER.

Page 7: hoja cálculo tornillos

max

1.95E+01

1.32E+01

1.86E+01

3.52E+00

9.22E+00

1.80E+01

9.54E+00

4.86E+00

2.52E+01

1.16E+01

1.93E+01

1.02E+01

2.20E+01

5.61E+00

4.47E+00

1.50E+01

4.81E-01

4.09E+00

1.62E+01

1.23E+01

PRELOAD

Page 8: hoja cálculo tornillos
Page 9: hoja cálculo tornillos

Element Int SF.SF1 SF.SF2 SF.SF3 SM.SM1 SM.SM2 SM.SM3Label Pt @Loc 1 @Loc 1 @Loc 1 @Loc 1 @Loc 1 @Loc 1 SHEAR

bolt number--------------- --------------- --------------- ----------------- --------------- ---------------- ----------------- ---------------1 4681 1 1.30E+05 1.03E+02 -7.84E+00 4.44E+03 1.41E+02 1.36E+01 1.03E+02

14675 1 1.30E+05 1.03E+02 -7.93E+00 -3.69E+03 -4.82E+02 1.36E+01 1.03E+02

2 4660 1 1.31E+05 9.35E+01 2.88E+01 3.50E+03 -1.07E+03 1.05E+01 9.79E+011

4654 1 1.31E+05 9.32E+01 2.87E+01 -3.87E+03 1.20E+03 1.05E+01 9.75E+013 4636 1 1.31E+05 5.63E+01 7.12E+01 1.95E+03 -3.00E+03 -3.24E+01 9.08E+01

14630 1 1.31E+05 5.60E+01 7.11E+01 -2.49E+03 2.62E+03 -3.24E+01 9.05E+01

4 4592 1 1.31E+05 4.37E+00 5.89E+01 1.04E+02 -2.25E+03 -5.24E+01 5.91E+011

4586 1 1.31E+05 4.05E+00 5.88E+01 -2.28E+02 2.40E+03 -5.24E+01 5.89E+015 4548 1 1.30E+05 -2.64E+01 5.04E+01 -1.20E+03 -2.11E+03 -5.39E+01 5.69E+01

14542 1 1.30E+05 -2.67E+01 5.03E+01 9.04E+02 1.87E+03 -5.39E+01 5.70E+01

6 4534 1 1.30E+05 -3.72E+01 2.57E+01 -1.51E+03 -1.59E+03 5.73E+01 4.52E+011

4528 1 1.30E+05 -3.75E+01 2.56E+01 1.45E+03 4.36E+02 5.73E+01 4.55E+017 4520 1 1.30E+05 -4.34E+01 -2.02E+01 -1.71E+03 6.99E+02 5.95E+01 4.79E+01

14514 1 1.30E+05 -4.38E+01 -2.03E+01 1.73E+03 -8.99E+02 5.95E+01 4.82E+01

8 4506 1 1.30E+05 -2.57E+01 -4.59E+01 -1.07E+03 1.80E+03 -4.60E+00 5.26E+011

4500 1 1.30E+05 -2.60E+01 -4.60E+01 9.72E+02 -1.83E+03 -4.60E+00 5.29E+019 4492 1 1.30E+05 1.10E+01 -2.40E+01 4.26E+02 5.41E+02 -1.20E+01 2.64E+01

14486 1 1.30E+05 1.07E+01 -2.41E+01 -4.31E+02 -1.36E+03 -1.20E+01 2.63E+01

10 4478 1 1.30E+05 6.31E+01 -2.21E+01 2.42E+03 9.22E+02 -2.96E+01 6.69E+011

4472 1 1.30E+05 6.28E+01 -2.22E+01 -2.55E+03 -8.30E+02 -2.96E+01 6.66E+0111 4485 1 1.30E+05 9.17E+01 1.67E+01 3.15E+03 -8.16E+02 -2.53E+01 9.32E+01

14479 1 1.30E+05 9.14E+01 1.66E+01 -4.09E+03 4.98E+02 -2.53E+01 9.29E+01

12 4499 1 1.30E+05 9.51E+01 4.71E+01 3.65E+03 -1.91E+03 4.53E+01 1.06E+021

4493 1 1.30E+05 9.48E+01 4.70E+01 -3.85E+03 1.81E+03 4.53E+01 1.06E+0213 4513 1 1.30E+05 5.81E+01 5.28E+01 2.24E+03 -1.66E+03 2.74E+01 7.85E+01

14507 1 1.30E+05 5.78E+01 5.27E+01 -2.34E+03 2.51E+03 2.74E+01 7.82E+01

14 4527 1 1.30E+05 6.46E+00 7.34E+01 1.56E+02 -2.89E+03 3.98E+01 7.37E+011

4521 1 1.30E+05 6.13E+00 7.33E+01 -3.41E+02 2.91E+03 3.98E+01 7.36E+0115 4541 1 1.30E+05 -2.96E+01 5.41E+01 -1.15E+03 -2.44E+03 3.98E+00 6.17E+01

14535 1 1.30E+05 -3.00E+01 5.40E+01 1.21E+03 1.83E+03 3.98E+00 6.17E+01

16 4580 1 1.30E+05 -4.81E+01 1.35E+00 -1.93E+03 2.82E+02 -5.50E+01 4.82E+011

4574 1 1.30E+05 -4.85E+01 1.25E+00 1.88E+03 3.84E+02 -5.50E+01 4.85E+0117 4604 1 1.30E+05 -6.23E+01 -2.48E+01 -2.62E+03 6.87E+02 -3.27E+01 6.71E+01

14598 1 1.30E+05 -6.26E+01 -2.49E+01 2.31E+03 -1.27E+03 -3.27E+01 6.74E+01

18 4653 1 1.31E+05 -4.58E+01 -5.17E+01 -1.84E+03 1.95E+03 -3.61E+01 6.91E+011

4647 1 1.31E+05 -4.61E+01 -5.18E+01 1.79E+03 -2.14E+03 -3.61E+01 6.94E+0119 4667 1 1.30E+05 2.57E+00 -7.77E+01 -1.32E+02 3.25E+03 -4.32E+01 7.78E+01

14661 1 1.30E+05 2.24E+00 -7.78E+01 -3.21E+02 -2.89E+03 -4.32E+01 7.79E+01

20 4674 1 1.31E+05 6.31E+01 -4.88E+01 2.34E+03 1.83E+03 -4.76E+01 7.98E+011

Page 10: hoja cálculo tornillos

4668 1 1.31E+05 6.28E+01 -4.89E+01 -2.63E+03 -2.03E+03 -4.76E+01 7.96E+01

MinimumAt ElementInt Pt

MaximumAt ElementInt Pt

Total

MAX 1.31E+05 1.03E+02 7.12E+01 4.44E+03 2.62E+03 1.36E+01

MIN 1.30E+05 5.60E+01 -7.93E+00 -3.87E+03 -3.00E+03 -3.24E+01

BOLT FORCES DATASection forces in beam elements at the integration points (C y D):

SF1: Axial section force (N)SF2: Shear section force in direction 1(N)SF3: Shear section force in direction 2(N)SM1: Bending moment along direction 1 (Nm)SM2: Bending moment along direction 2 (Nm)SM3: Torsional momento (Nm)

Fx=SF1, Mx=SM1, My=SM2

Page 11: hoja cálculo tornillos

regardingtware prod options ahe hardwarrmationlisted bel orrect. If not, pleas ntact your MSC salesrepresentupdate thmation andbtain correauthorizationcodes.

MSC Techport Cent be reached at:

Internet il scnastran. rt@mscsofomm scpatran.s t@mscsoftm

World Wi b ttp://www. ftware.com/

France 3 3-1-6936-6936Germany 4 9-8943-1987-277Italy (Ro 3 9-6-527993-40Netherla 3 1-182-543700Nordic Coies 7-22-75-48-50Russia 7 0-95-236- 3.00E+00Spain (Ma) 4-91-5560919United K m 4-1276-601900

Thank yo joy our products!

Sincerely,

The MSC.Corporationhttp://ww tware.com/

* PLEAS E * PLEAPLEASE NPLEASE NOTE *

The "\" b sh characthe continu character fheFEATURE ines. All e last line a FEATURE blockMUST end"\" backs racter.

Please in this file, e of the lo lines may beenwrapped ltiple line ugh e-mail essing or btingand pasti rations.

Thank you.

Page 12: hoja cálculo tornillos

License for MSCAgreemenRE007414-MA-A0Configuranew mainwindowsHostid(s):0018FE262A8ACustomerProduct s Develop S.L. - Ped z - MAPO-6YDDYB

MSC Softorization tion

ProductPackageSub-product Users Stats Expires------------ ------------ ----- ---- ------ ------ --

0 Nast ic Packa 3.91E+04 3/2007 12 9.90E+01Nastran Backage 1.00E+00Nastran BasicConnectorsDMAP CompileDynamic nseHeat TransferADAMS Intion

# ------- S f License -----#SERVER t0018FE262A8A 1700DAEMON path/mscFEATURESC 2007.ec-2099 1 25D97636 \HOSTID=a8a ISSU-2007 ck=229 \SN=13879eb840b2cfc8aefFEATUREtors MSC1 31-dec-2\ADA662 BA04 HOe262a8a 13-feb-2007 \ck=111 -9c7ccf3 ba1dFEATURESC 2007.ec-2099 1 2CDF1759\HOSTID=a8a ISSU-2007 ck=64 \SN=1216f0489632bf6cf4aFEATUREcs MSC 231-dec-20 DF6C24DA89F \HOSTID=a8a ISSU-2007 ck=83 \SN=1069289218239f68a08FEATUREl MSC 20 1-dec-209 86D2ADF599 \VENDORD:3002,3 D=0018fe2\ISSUED=07 ck=47 24-cb78bb1fec25f6FEATUR Integrati 007.1231 -2099 1 \1DE612 9D77 HOe262a8a 13-feb-2007 \ck=40 S ### 2b5c## ------- License Fi-----## NOTES# 1. Thesization UIRE THE LATION# AND FLEXLM ERVER.

Page 13: hoja cálculo tornillos

max

1.03E+02

9.79E+01

9.08E+01

5.91E+01

5.70E+01

4.55E+01

4.82E+01

5.29E+01

2.64E+01

6.69E+01

9.32E+01

1.06E+02

7.85E+01

7.37E+01

6.17E+01

4.85E+01

6.74E+01

6.94E+01

7.79E+01

7.98E+01

PRELOAD + LOAD

Page 14: hoja cálculo tornillos
Page 15: hoja cálculo tornillos

PRELOAD 1 direction

BOLT MC MD LA LB LC LD

1 -3.21E+02 1.16E+03 8 78 4 84.64 -2.47E+02 1.04E+032 -5.98E+02 4.18E+02 8 78 4 84.64 -5.48E+02 3.34E+023 -5.57E+02 1.79E+02 8 78 4 84.64 -5.20E+02 1.19E+024 -1.65E+02 9.00E+01 8 78 4 84.64 -1.53E+02 6.90E+015 -2.01E+02 -8.52E+01 8 78 4 84.64 -1.95E+02 -9.47E+016 -1.10E+02 4.20E+01 8 78 4 84.64 -1.03E+02 2.94E+017 2.17E+02 -1.94E+02 8 78 4 84.64 1.97E+02 -1.60E+028 1.61E+02 -2.13E+02 8 78 4 84.64 1.42E+02 -1.82E+029 4.23E+02 -2.74E+02 8 78 4 84.64 3.88E+02 -2.16E+02

10 4.54E+02 -3.98E+02 8 78 4 84.64 4.12E+02 -3.28E+0211 3.19E+02 -1.15E+03 8 78 4 84.64 2.46E+02 -1.03E+0312 4.09E+02 -3.95E+02 8 78 4 84.64 3.69E+02 -3.29E+0213 4.30E+02 -3.26E+02 8 78 4 84.64 3.93E+02 -2.64E+0214 1.75E+02 -2.53E+02 8 78 4 84.64 1.54E+02 -2.18E+0215 2.05E+02 -1.31E+02 8 78 4 84.64 1.89E+02 -1.03E+0216 -1.11E+02 3.80E+01 8 78 4 84.64 -1.04E+02 2.57E+0117 -1.87E+02 -1.54E+02 8 78 4 84.64 -1.85E+02 -1.57E+0218 -1.79E+02 1.30E+02 8 78 4 84.64 -1.64E+02 1.05E+0219 -5.55E+02 2.20E+02 8 78 4 84.64 -5.17E+02 1.57E+0220 -5.53E+02 4.14E+02 8 78 4 84.64 -5.05E+02 3.35E+02

2 direction

BOLT MC MD LA LB LC LD1 2.90E+01 -3.65E+02 8 78 4 84.64 9.40E+00 -3.33E+022 1.67E+02 -8.35E+01 8 78 4 84.64 1.54E+02 -6.29E+013 4.02E+02 -8.66E+02 8 78 4 84.64 3.39E+02 -7.62E+024 6.95E+01 -3.98E+01 8 78 4 84.64 6.40E+01 -3.08E+015 2.25E+02 -4.93E+02 8 78 4 84.64 1.90E+02 -4.34E+026 1.36E+02 -1.28E+03 8 78 4 84.64 6.57E+01 -1.16E+037 2.30E+02 -4.02E+02 8 78 4 84.64 1.98E+02 -3.50E+028 7.85E+01 -8.77E+00 8 78 4 84.64 7.42E+01 -1.58E+009 5.79E+02 -1.29E+03 8 78 4 84.64 4.86E+02 -1.14E+03

10 2.44E+02 -1.00E+02 8 78 4 84.64 2.27E+02 -7.17E+0111 2.77E+01 -3.65E+02 8 78 4 84.64 8.19E+00 -3.32E+0212 -1.20E+02 -7.42E+01 8 78 4 84.64 -1.18E+02 -7.80E+0113 -4.47E+02 1.12E+03 8 78 4 84.64 -3.69E+02 9.92E+0214 -1.48E+01 -1.29E+02 8 78 4 84.64 -2.04E+01 -1.19E+0215 -2.82E+02 -3.91E+02 8 78 4 84.64 -2.87E+02 -3.82E+0216 -2.51E+02 9.22E+02 8 78 4 84.64 -1.93E+02 8.26E+0217 -2.79E+02 -2.98E+02 8 78 4 84.64 -2.80E+02 -2.97E+0218 -6.37E+00 -9.72E+01 8 78 4 84.64 -1.09E+01 -8.97E+0119 -2.87E+02 7.27E+02 8 78 4 84.64 -2.37E+02 6.44E+02

MA1 MB1

MA2 MB2

Page 16: hoja cálculo tornillos

20 -4.31E+01 -9.07E+01 8 78 4 84.64 -4.54E+01 -8.68E+01

Page 17: hoja cálculo tornillos

1 directionBOLT MC MD LA LB LC LD MA MB

1 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!2 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!3 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!4 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!5 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!6 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!7 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!8 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!9 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

10 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!11 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

12 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!13 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!14 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!15 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!16 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!17 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!18 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

2 direction

BOLT MC MD LA LB LC LD MA MB1 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!2 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!3 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!4 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!5 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!6 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!7 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!8 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!9 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

10 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!11 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

Page 18: hoja cálculo tornillos

12 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!13 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!14 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!15 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!16 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!17 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!18 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

1 directionBOLT MC MD LA LB LC LD MA MB

1 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!2 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!3 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!4 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!5 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!6 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!7 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!8 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!9 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

10 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!11 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

12 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!13 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!14 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!15 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!16 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!17 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!18 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

2 direction

BOLT MC MD LA LB LC LD MA MB1 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!2 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!3 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!4 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!5 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!6 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!7 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

Page 19: hoja cálculo tornillos

8 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!9 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

10 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!11 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!12 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!13 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!14 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!15 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!16 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!17 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!18 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

Page 20: hoja cálculo tornillos

PRELOAD

BENDING STRESS

MPaFty 900Ftu 1000

BOLT MA MBMS-A MS-B

1 2.5E+02 1.1E+03 0.1 0.3 11976.34 2708.682 5.7E+02 3.4E+02 0.2 0.1 5207.49 8712.633 6.2E+02 7.7E+02 0.2 0.2 4774.73 3845.004 1.7E+02 7.6E+01 0.1 0.0 17911.43 39226.625 2.7E+02 4.4E+02 0.1 0.1 10888.50 6667.896 1.2E+02 1.2E+03 0.0 0.4 24311.11 2553.677 2.8E+02 3.9E+02 0.1 0.1 10617.57 7693.818 1.6E+02 1.8E+02 0.0 0.1 18496.68 16254.479 6.2E+02 1.2E+03 0.2 0.4 4764.22 2563.82

10 4.7E+02 3.4E+02 0.1 0.1 6304.08 8824.3511 2.5E+02 1.1E+03 0.1 0.3 12045.20 2733.6212 3.9E+02 3.4E+02 0.1 0.1 7645.29 8771.6913 5.4E+02 1.0E+03 0.2 0.3 5499.43 2888.1114 1.5E+02 2.5E+02 0.0 0.1 19127.37 11922.6015 3.4E+02 4.0E+02 0.1 0.1 8624.31 7485.3116 2.2E+02 8.3E+02 0.1 0.3 13546.05 3587.0317 3.4E+02 3.4E+02 0.1 0.1 8827.24 8830.6818 1.6E+02 1.4E+02 0.0 0.0 18029.78 21481.9319 5.7E+02 6.6E+02 0.2 0.2 5212.25 4472.7020 5.1E+02 3.5E+02 0.2 0.1 5845.30 8571.59

σ - bending in A

σ - bending in B

Page 21: hoja cálculo tornillos

MPaFty 940Ftu 1000

BOLT MA MB W bolt σ - bending i σ - bending MS-A1 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!2 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!3 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!4 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!5 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!6 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!7 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!8 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!9 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!

10 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!11 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!12 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!13 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!14 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!15 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!16 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!17 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!18 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!

Page 22: hoja cálculo tornillos

MPaFty 940Ftu 1000

BOLT MA MB W bolt σ - bending i σ - bending MS-A1 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!2 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!3 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!4 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!5 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!6 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!7 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!8 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!9 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!

10 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!11 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!12 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!13 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!14 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!15 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!16 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!17 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!

Page 23: hoja cálculo tornillos

18 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!

Page 24: hoja cálculo tornillos

MS-B#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

Page 25: hoja cálculo tornillos

MS-B#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

Page 26: hoja cálculo tornillos

#VALUE!

Page 27: hoja cálculo tornillos

PRECARGA + LOAD1 direction

BOLT MC MD LA LB LC LD1 4.44E+03 -3.69E+03 8 78 4 84.64 4.03E+03 -3.02E+032 3.50E+03 -3.87E+03 8 78 4 84.64 3.14E+03 -3.26E+033 1.95E+03 -2.49E+03 8 78 4 84.64 1.73E+03 -2.13E+034 1.04E+02 -2.28E+02 8 78 4 84.64 8.78E+01 -2.01E+025 -1.20E+03 9.04E+02 8 78 4 84.64 -1.09E+03 7.31E+026 -1.51E+03 1.45E+03 8 78 4 84.64 -1.36E+03 1.20E+037 -1.71E+03 1.73E+03 8 78 4 84.64 -1.54E+03 1.45E+038 -1.07E+03 9.72E+02 8 78 4 84.64 -9.69E+02 8.04E+029 4.26E+02 -4.31E+02 8 78 4 84.64 3.83E+02 -3.60E+02

10 2.42E+03 -2.55E+03 8 78 4 84.64 2.18E+03 -2.14E+0311 3.15E+03 -4.09E+03 8 78 4 84.64 2.79E+03 -3.49E+0312 3.65E+03 -3.85E+03 8 78 4 84.64 3.28E+03 -3.23E+0313 2.24E+03 -2.34E+03 8 78 4 84.64 2.01E+03 -1.96E+0314 1.56E+02 -3.41E+02 8 78 4 84.64 1.31E+02 -3.00E+0215 -1.15E+03 1.21E+03 8 78 4 84.64 -1.03E+03 1.01E+0316 -1.93E+03 1.88E+03 8 78 4 84.64 -1.74E+03 1.57E+0317 -2.62E+03 2.31E+03 8 78 4 84.64 -2.38E+03 1.90E+0318 -1.84E+03 1.79E+03 8 78 4 84.64 -1.66E+03 1.49E+0319 -1.32E+02 -3.21E+02 8 78 4 84.64 -1.41E+02 -3.06E+0220 2.34E+03 -2.63E+03 8 78 4 84.64 2.10E+03 -2.22E+03

2 direction

BOLT MC MD LA LB LC LD1 1.41E+02 -4.82E+02 8 78 4 84.64 1.10E+02 -4.31E+022 -1.07E+03 1.20E+03 8 78 4 84.64 -9.56E+02 1.02E+033 -3.00E+03 2.62E+03 8 78 4 84.64 -2.72E+03 2.16E+034 -2.25E+03 2.40E+03 8 78 4 84.64 -2.02E+03 2.01E+035 -2.11E+03 1.87E+03 8 78 4 84.64 -1.91E+03 1.55E+036 -1.59E+03 4.36E+02 8 78 4 84.64 -1.49E+03 2.69E+027 6.99E+02 -8.99E+02 8 78 4 84.64 6.20E+02 -7.67E+028 1.80E+03 -1.83E+03 8 78 4 84.64 1.62E+03 -1.53E+039 5.41E+02 -1.36E+03 8 78 4 84.64 4.47E+02 -1.20E+03

10 9.22E+02 -8.30E+02 8 78 4 84.64 8.35E+02 -6.86E+0211 -8.16E+02 4.98E+02 8 78 4 84.64 -7.50E+02 3.90E+0212 -1.91E+03 1.81E+03 8 78 4 84.64 -1.73E+03 1.50E+0313 -1.66E+03 2.51E+03 8 78 4 84.64 -1.45E+03 2.16E+0314 -2.89E+03 2.91E+03 8 78 4 84.64 -2.60E+03 2.43E+0315 -2.44E+03 1.83E+03 8 78 4 84.64 -2.22E+03 1.48E+0316 2.82E+02 3.84E+02 8 78 4 84.64 2.87E+02 3.76E+0217 6.87E+02 -1.27E+03 8 78 4 84.64 5.89E+02 -1.11E+0318 1.95E+03 -2.14E+03 8 78 4 84.64 1.75E+03 -1.80E+0319 3.25E+03 -2.89E+03 8 78 4 84.64 2.95E+03 -2.39E+0320 1.83E+03 -2.03E+03 8 78 4 84.64 1.64E+03 -1.71E+03

MA1 MB1

MA2 MB2

Page 28: hoja cálculo tornillos

1 directionBOLT MC MD LA LB LC LD MA MB

1 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!2 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!3 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!4 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!5 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!6 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!7 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!8 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!9 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

10 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!11 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

12 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!13 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!14 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!15 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!16 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!17 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!18 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

2 direction

BOLT MC MD LA LB LC LD MA MB1 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!2 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!3 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!4 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!5 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!6 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!7 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!8 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!9 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

10 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!11 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!12 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

Page 29: hoja cálculo tornillos

13 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!14 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!15 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!16 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!17 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!18 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

1 directionBOLT MC MD LA LB LC LD MA MB

1 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!2 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!3 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!4 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!5 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!6 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!7 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!8 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!9 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

10 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!11 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

12 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!13 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!14 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!15 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!16 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!17 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!18 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

2 direction

BOLT MC MD LA LB LC LD MA MB1 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!2 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!3 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!4 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!5 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!6 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!7 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!8 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

Page 30: hoja cálculo tornillos

9 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!10 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!11 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!12 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!13 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!14 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!15 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!16 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!17 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!18 #N/A 0.00E+00 0 0 0 0 #VALUE! #VALUE!

Page 31: hoja cálculo tornillos

PRECARGA + LOAD

BENDING STRESS

MPaFty 900Ftu 1000

BOLT MA MBMS-A MS-B

1 4.0E+03 3.1E+03 1.22 0.93 733.89 970.262 3.3E+03 3.4E+03 1.00 1.04 902.95 865.883 3.2E+03 3.0E+03 0.98 0.92 919.75 977.294 2.0E+03 2.0E+03 0.62 0.61 1462.36 1464.815 2.2E+03 1.7E+03 0.67 0.52 1346.82 1733.006 2.0E+03 1.2E+03 0.61 0.37 1467.77 2401.977 1.7E+03 1.6E+03 0.50 0.50 1784.02 1807.248 1.9E+03 1.7E+03 0.57 0.52 1567.12 1715.62

9 5.9E+02 1.3E+03 0.18 0.38 5029.94 2366.5010 2.3E+03 2.2E+03 0.71 0.68 1270.45 1317.4811 2.9E+03 3.5E+03 0.88 1.07 1025.21 843.1712 3.7E+03 3.6E+03 1.13 1.08 797.94 831.4513 2.5E+03 2.9E+03 0.75 0.89 1192.95 1013.7814 2.6E+03 2.4E+03 0.79 0.74 1136.89 1209.8415 2.5E+03 1.8E+03 0.74 0.54 1208.40 1651.7516 1.8E+03 1.6E+03 0.54 0.49 1677.02 1835.5117 2.5E+03 2.2E+03 0.74 0.67 1207.98 1343.1018 2.4E+03 2.3E+03 0.73 0.71 1229.46 1265.8619 3.0E+03 2.4E+03 0.90 0.73 1002.97 1231.6420 2.7E+03 2.8E+03 0.81 0.85 1112.51 1056.70

σ - bending in A

σ - bending in B

Page 32: hoja cálculo tornillos

MPaFty 940Ftu 1000

BOLT MA MB W bolt σ - bending iσ - bending MS-A1 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!2 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!3 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!4 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!5 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!6 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!7 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!8 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!9 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!

10 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!11 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!12 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!13 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!14 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!15 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!16 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!17 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!18 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!

Page 33: hoja cálculo tornillos

MPaFty 940Ftu 1000

BOLT MA MB W bolt σ - bending iσ - bending MS-A1 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!2 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!3 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!4 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!5 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!6 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!7 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!8 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!9 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!

10 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!11 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!12 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!13 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!14 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!15 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!16 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!17 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!18 #VALUE! #VALUE! 0.0000E+00 #VALUE! #VALUE! #VALUE!

Page 34: hoja cálculo tornillos

MS-B#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

Page 35: hoja cálculo tornillos

MS-B#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

Page 36: hoja cálculo tornillos

MPaFty 900

AXIAL STRESS Ftu 1000

PRECARGA LOAD

BOLT AXIAL σ - axial MS AXIAL σ - axial MS1 1.30E+05 828.84 0.09 1.30E+05 829.62 0.082 1.30E+05 830.59 0.08 1.31E+05 831.47 0.083 1.30E+05 830.45 0.08 1.31E+05 831.38 0.084 1.30E+05 830.87 0.08 1.31E+05 831.82 0.085 1.30E+05 830.32 0.08 1.30E+05 831.01 0.086 1.30E+05 828.81 0.09 1.30E+05 829.06 0.097 1.30E+05 830.46 0.08 1.30E+05 830.31 0.088 1.30E+05 830.83 0.08 1.30E+05 830.17 0.089 1.30E+05 830.82 0.08 1.30E+05 829.93 0.08

10 1.30E+05 830.65 0.08 1.30E+05 829.74 0.0811 1.30E+05 828.83 0.09 1.30E+05 827.88 0.0912 1.30E+05 830.66 0.08 1.30E+05 829.64 0.0813 1.30E+05 830.96 0.08 1.30E+05 829.97 0.0814 1.30E+05 830.83 0.08 1.30E+05 829.63 0.0815 1.30E+05 830.43 0.08 1.30E+05 829.60 0.0816 1.30E+05 828.69 0.09 1.30E+05 828.34 0.0917 1.30E+05 830.29 0.08 1.30E+05 830.33 0.0818 1.30E+05 830.88 0.08 1.31E+05 831.36 0.0819 1.30E+05 830.48 0.08 1.30E+05 831.12 0.0820 1.30E+05 830.59 0.08 1.31E+05 831.26 0.08

Page 37: hoja cálculo tornillos

1 directionBOLT MC

1 ###2 ###3 ###4 ###5 ###6 ###7 ### MPa8 ### Fty 9409 ### Ftu ###

10 ###11 ###

12 ### MA MB W boltσ - bending iσ - bending i MS-A13 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!14 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!15 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!16 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!17 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!18 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!2 direction #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!BOLT MC #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

1 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!2 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!3 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!4 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!5 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!6 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!7 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!8 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!9 ###

10 ###11 ###12 ###13 ###14 ###15 ###16 ###

Page 38: hoja cálculo tornillos

17 ###18 ###

1 directionBOLT MC

1 ###2 ###3 ###4 ###5 ###6 ###7 ### MPa8 ### Fty 9409 ### Ftu ###

10 ###11 ###

12 ### MA MB W boltσ - bending iσ - bending i MS-A13 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!14 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!15 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!16 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!17 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!18 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!2 direction #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!BOLT MC #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

1 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!2 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!3 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!4 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!5 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!6 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!7 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!8 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!9 ###

10 ###11 ###12 ###

Page 39: hoja cálculo tornillos

13 ###14 ###15 ###16 ###17 ###18 ###

Page 40: hoja cálculo tornillos

Fty 900

SHEAR STRESS Ftu 1000

PRELOAD LCF0

BOLT SHEAR σ - shear MS SHEAR σ - shear MS1 1.95E+01 0.12 7262.10 1.03E+02 0.66 1366.552 1.32E+01 0.08 10664.53 9.79E+01 0.62 1442.943 1.86E+01 0.12 7614.88 9.08E+01 0.58 1555.814 3.52E+00 0.02 40197.28 5.91E+01 0.38 2391.165 9.22E+00 0.06 15331.69 5.70E+01 0.36 2478.226 1.80E+01 0.11 7858.96 4.55E+01 0.29 3107.647 9.54E+00 0.06 14805.83 4.82E+01 0.31 2928.928 4.86E+00 0.03 29084.60 5.29E+01 0.34 2672.499 2.52E+01 0.16 5598.49 2.64E+01 0.17 5357.33

10 1.16E+01 0.07 12142.85 6.69E+01 0.43 2111.1911 1.93E+01 0.12 7326.56 9.32E+01 0.59 1514.5112 1.02E+01 0.06 13857.03 1.06E+02 0.68 1329.8913 2.20E+01 0.14 6412.59 7.85E+01 0.50 1798.3114 5.61E+00 0.04 25191.25 7.37E+01 0.47 1916.1215 4.47E+00 0.03 31583.68 6.17E+01 0.39 2288.0316 1.50E+01 0.10 9438.02 4.85E+01 0.31 2912.8817 4.81E-01 0.00 293603.47 6.74E+01 0.43 2095.6018 4.09E+00 0.03 34581.22 6.94E+01 0.44 2036.1819 1.62E+01 0.10 8737.65 7.79E+01 0.50 1813.4920 1.23E+01 0.08 11523.87 7.98E+01 0.51 1769.88

Page 41: hoja cálculo tornillos

1 directionBOLT MC

1 ###2 ###3 ###4 ###5 ###6 ###7 ### MPa8 ### Fty 9409 ### Ftu ###

10 ###11 ###

12 ### MA MB W boltσ - bendinσ - bendin MS-A13 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!14 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!15 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!16 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!17 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!18 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!2 direction #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!BOLT MC #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

1 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!2 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!3 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!4 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!5 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!6 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!7 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!8 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!9 ###

10 ###11 ###12 ###13 ###14 ###15 ###16 ###

Page 42: hoja cálculo tornillos

17 ###18 ###

1 directionBOLT MC

1 ###2 ###3 ###4 ###5 ###6 ###7 ### MPa8 ### Fty 9409 ### Ftu ###

10 ###11 ###

12 ### MA MB W boltσ - bendinσ - bendin MS-A13 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!14 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!15 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!16 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!17 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!18 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!2 direction #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!BOLT MC #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!

1 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!2 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!3 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!4 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!5 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!6 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!7 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!8 ### #VALUE! #VALUE! ### #VALUE! #VALUE! #VALUE!9 ###

10 ###11 ###12 ###

Page 43: hoja cálculo tornillos

13 ###14 ###15 ###16 ###17 ###18 ###

Page 44: hoja cálculo tornillos

Fty

TORSIONAL STRESS Ftu

PRECARGA PRECARGA + LOAD

BOLT MG σ - torsional MS MG σ - torsional1 1.48E+05 266.10 2.38 1.48E+05 266.362 1.48E+05 266.66 2.38 1.48E+05 266.953 1.48E+05 266.62 2.38 1.48E+05 266.924 1.48E+05 266.76 2.37 1.48E+05 267.065 1.48E+05 266.58 2.38 1.48E+05 266.806 1.48E+05 266.09 2.38 1.48E+05 266.177 1.48E+05 266.62 2.38 1.48E+05 266.588 1.48E+05 266.74 2.37 1.48E+05 266.539 1.48E+05 266.74 2.37 1.48E+05 266.45

10 1.48E+05 266.68 2.37 1.48E+05 266.3911 1.48E+05 266.10 2.38 1.48E+05 265.8012 1.48E+05 266.69 2.37 1.48E+05 266.3613 1.48E+05 266.78 2.37 1.48E+05 266.4714 1.48E+05 266.74 2.37 1.48E+05 266.3615 1.48E+05 266.61 2.38 1.48E+05 266.3516 1.48E+05 266.05 2.38 1.48E+05 265.9417 1.48E+05 266.57 2.38 1.48E+05 266.5818 1.48E+05 266.76 2.37 1.48E+05 266.9119 1.48E+05 266.63 2.38 1.48E+05 266.8420 1.48E+05 266.67 2.38 1.48E+05 266.88

Page 45: hoja cálculo tornillos

1 directionBOLT MC

1 ###2 ###3 ###4 ###5 ###6 ###7 ### MPa8 ### Fty 9409 ### Ftu ###

10 ###11 ###

12 ### MA MB W boltσ - bending iσ - bending in13 ### #VALUE! #VALUE! ### #VALUE! #VALUE!14 ### #VALUE! #VALUE! ### #VALUE! #VALUE!15 ### #VALUE! #VALUE! ### #VALUE! #VALUE!16 ### #VALUE! #VALUE! ### #VALUE! #VALUE!17 ### #VALUE! #VALUE! ### #VALUE! #VALUE!18 ### #VALUE! #VALUE! ### #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE!2 direction #VALUE! #VALUE! ### #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE!BOLT MC #VALUE! #VALUE! ### #VALUE! #VALUE!

1 ### #VALUE! #VALUE! ### #VALUE! #VALUE!2 ### #VALUE! #VALUE! ### #VALUE! #VALUE!3 ### #VALUE! #VALUE! ### #VALUE! #VALUE!4 ### #VALUE! #VALUE! ### #VALUE! #VALUE!5 ### #VALUE! #VALUE! ### #VALUE! #VALUE!6 ### #VALUE! #VALUE! ### #VALUE! #VALUE!7 ### #VALUE! #VALUE! ### #VALUE! #VALUE!8 ### #VALUE! #VALUE! ### #VALUE! #VALUE!9 ###

10 ###11 ###12 ###13 ###14 ###15 ###16 ###

Page 46: hoja cálculo tornillos

17 ###18 ###

1 directionBOLT MC

1 ###2 ###3 ###4 ###5 ###6 ###7 ### MPa8 ### Fty 9409 ### Ftu ###

10 ###11 ###

12 ### MA MB W boltσ - bending iσ - bending in13 ### #VALUE! #VALUE! ### #VALUE! #VALUE!14 ### #VALUE! #VALUE! ### #VALUE! #VALUE!15 ### #VALUE! #VALUE! ### #VALUE! #VALUE!16 ### #VALUE! #VALUE! ### #VALUE! #VALUE!17 ### #VALUE! #VALUE! ### #VALUE! #VALUE!18 ### #VALUE! #VALUE! ### #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE!2 direction #VALUE! #VALUE! ### #VALUE! #VALUE!

#VALUE! #VALUE! ### #VALUE! #VALUE!BOLT MC #VALUE! #VALUE! ### #VALUE! #VALUE!

1 ### #VALUE! #VALUE! ### #VALUE! #VALUE!2 ### #VALUE! #VALUE! ### #VALUE! #VALUE!3 ### #VALUE! #VALUE! ### #VALUE! #VALUE!4 ### #VALUE! #VALUE! ### #VALUE! #VALUE!5 ### #VALUE! #VALUE! ### #VALUE! #VALUE!6 ### #VALUE! #VALUE! ### #VALUE! #VALUE!7 ### #VALUE! #VALUE! ### #VALUE! #VALUE!8 ### #VALUE! #VALUE! ### #VALUE! #VALUE!9 ###

10 ###11 ###12 ###

Page 47: hoja cálculo tornillos

13 ###14 ###15 ###16 ###17 ###18 ###

Page 48: hoja cálculo tornillos

MPa900

1000

MS2.382.372.372.372.372.382.382.382.382.382.392.382.382.382.382.382.382.372.372.37

Page 49: hoja cálculo tornillos

MS-A#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

Page 50: hoja cálculo tornillos

MS-A#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

Page 51: hoja cálculo tornillos

Fty

TOTAL STRESS FtuPRECARGA

σ - bend σ axial ζ σ total σ total

BOLT A B A y B A B A B MS-A1 0.1 0.3 828.8 828.9 829.2 266.1 890.7 890.9 0.012 0.2 0.1 830.6 830.8 830.7 266.7 892.7 892.6 0.013 0.2 0.2 830.4 830.6 830.7 266.6 892.5 892.6 0.014 0.1 0.0 830.9 830.9 830.9 266.8 892.8 892.8 0.015 0.1 0.1 830.3 830.4 830.5 266.6 892.3 892.3 0.016 0.0 0.4 828.8 828.8 829.2 266.1 890.6 890.9 0.017 0.1 0.1 830.5 830.5 830.6 266.6 892.4 892.5 0.018 0.0 0.1 830.8 830.9 830.9 266.7 892.8 892.8 0.019 0.2 0.4 830.8 831.0 831.2 266.7 892.9 893.1 0.01

10 0.1 0.1 830.6 830.8 830.8 266.7 892.7 892.7 0.0111 0.1 0.3 828.8 828.9 829.2 266.1 890.7 890.9 0.0112 0.1 0.1 830.7 830.8 830.8 266.7 892.7 892.7 0.0113 0.2 0.3 831.0 831.1 831.3 266.8 893.0 893.2 0.0114 0.0 0.1 830.8 830.9 830.9 266.7 892.8 892.8 0.0115 0.1 0.1 830.4 830.5 830.5 266.6 892.4 892.4 0.0116 0.1 0.3 828.7 828.8 828.9 266.1 890.5 890.7 0.0117 0.1 0.1 830.3 830.4 830.4 266.6 892.3 892.3 0.0118 0.0 0.0 830.9 830.9 830.9 266.8 892.9 892.8 0.0119 0.2 0.2 830.5 830.7 830.7 266.6 892.5 892.6 0.0120 0.2 0.1 830.6 830.7 830.7 266.7 892.6 892.6 0.01

PRECARGA + LOAD

σ - bend σ axial ζ σ total σ total

BOLT A B A y B A B A B MS-A1 1.2 0.9 829.6 830.8 830.6 266.4 892.6 892.3 0.012 1.0 1.0 831.5 832.5 832.5 266.9 894.4 894.4 0.013 1.0 0.9 831.4 832.4 832.3 266.9 894.2 894.2 0.014 0.6 0.6 831.8 832.4 832.4 267.1 894.4 894.4 0.015 0.7 0.5 831.0 831.7 831.5 266.8 893.6 893.4 0.016 0.6 0.4 829.1 829.7 829.4 266.2 891.4 891.2 0.017 0.5 0.5 830.3 830.8 830.8 266.6 892.7 892.7 0.018 0.6 0.5 830.2 830.7 830.7 266.5 892.6 892.5 0.019 0.2 0.4 829.9 830.1 830.3 266.5 892.0 892.1 0.01

10 0.7 0.7 829.7 830.4 830.4 266.4 892.2 892.2 0.0111 0.9 1.1 827.9 828.8 828.9 265.8 890.4 890.6 0.0112 1.1 1.1 829.6 830.8 830.7 266.4 892.5 892.5 0.0113 0.8 0.9 830.0 830.7 830.9 266.5 892.5 892.7 0.0114 0.8 0.7 829.6 830.4 830.4 266.4 892.2 892.2 0.0115 0.7 0.5 829.6 830.3 830.1 266.3 892.1 891.9 0.0116 0.5 0.5 828.3 828.9 828.8 265.9 890.6 890.5 0.0117 0.7 0.7 830.3 831.1 831.0 266.6 892.9 892.8 0.0118 0.7 0.7 831.4 832.1 832.1 266.9 894.0 894.0 0.01

σ z

σ z

Page 52: hoja cálculo tornillos

19 0.9 0.7 831.1 832.0 831.9 266.8 893.9 893.7 0.0120 0.8 0.9 831.3 832.1 832.1 266.9 894.0 894.0 0.01

Page 53: hoja cálculo tornillos

MPa900

1000

σ z PRECARGA

MS-B BOLT A B0.01 1 828.9 829.20.01 2 830.8 830.70.01 3 830.6 830.70.01 4 830.9 830.90.01 5 830.4 830.50.01 6 828.8 829.20.01 7 830.5 830.60.01 8 830.9 830.90.01 9 831.0 831.20.01 10 830.8 830.80.01 11 828.9 829.20.01 12 830.8 830.80.01 13 831.1 831.30.01 14 830.9 830.90.01 15 830.5 830.50.01 16 828.8 828.90.01 17 830.4 830.40.01 18 830.9 830.90.01 19 830.7 830.70.01 20 830.7 830.7

Incremento para FATIGA

σ z PRECARGA+LOAMS-B BOLT A B A B NA (ciclos)0.01 1 830.8 830.6 1 1.93 1.38 1.257E+130.01 2 832.5 832.5 2 1.71 1.82 2.333E+130.01 3 832.4 832.3 3 1.72 1.62 2.261E+130.01 4 832.4 832.4 4 1.51 1.54 4.268E+130.01 5 831.7 831.5 5 1.27 1.07 1.041E+140.01 6 829.7 829.4 6 0.82 0.27 8.924E+140.01 7 830.8 830.8 7 0.27 0.23 2.521E+170.01 8 830.7 830.7 8 0.13 0.19 8.872E+180.01 9 830.1 830.3 9 0.90 0.86 5.898E+140.01 10 830.4 830.4 10 0.35 0.33 6.871E+160.01 11 828.8 828.9 11 0.15 0.22 4.032E+180.01 12 830.8 830.7 12 0.01 0.04 2.895E+240.01 13 830.7 830.9 13 0.40 0.42 3.174E+160.01 14 830.4 830.4 14 0.46 0.54 1.649E+160.01 15 830.3 830.1 15 0.19 0.40 1.437E+180.01 16 828.9 828.8 16 0.12 0.11 1.387E+190.01 17 831.1 831.0 17 0.68 0.61 2.322E+150.01 18 832.1 832.1 18 1.16 1.15 1.621E+14

Tension a evaluar para FATIGA INCREMENTO(Restado de PRECARGA)

0,00 0,25 0,50 0,75 1,00

Time (s)

Input Signal

PRELOAD

LCF

Page 54: hoja cálculo tornillos

0.01 19 832.0 831.9 19 1.36 1.17 7.273E+130.01 20 832.1 832.1 20 1.32 1.41 8.368E+13

Page 55: hoja cálculo tornillos

6.831E+131.698E+133.080E+133.916E+132.469E+142.336E+175.520E+171.479E+187.378E+148.643E+166.829E+173.092E+212.651E+167.668E+153.164E+162.005E+194.155E+151.715E+14

INCREMENTO(Restado de PRECARGA)

0,00 0,25 0,50 0,75 1,00

Time (s)

Page 56: hoja cálculo tornillos

1.575E+145.988E+13

Page 57: hoja cálculo tornillos
Page 58: hoja cálculo tornillos
Page 59: hoja cálculo tornillos

1000

900

SRI1 6299.605SRI2 805.5961

DC 50 Se 50.00 Ne 2.00E+06

Sc 36.84031 Nc 5.00E+06 b1 0.333333b2 0.2

SRI1 4979.925

DC 50 Se 39.53 Ne 2.00E+06

Sc 29.12278 Nc 5.00E+06 b1 0.333333b2 0.2

su (MPa)

se (MPa)

Page 60: hoja cálculo tornillos

CARACTERÍSTICAS TORNILLERÍA

Métrica PasoSección de Carga en el Limite Elástico Coeficiente Pares de Apriete

Tensión 8.8 10.9 12.9 8.8 10.9 12.9 8.80

(mm) [ P ] [ A ]

F . P2p*MC

(mm) (mm²) (N) ( - ) (N. m)4 0.70 5,600 7,900 9,500 0.22 0.21 0.22 2.905 0.80 9,100 12,800 15,300 0.19 0.19 0.19 6.006 1 20.10 12,864 18,090 21,708 0.19 0.19 0.20 117 1 178 1.25 36.60 23,424 32,940 39,528 0.18 0.16 0.19 268 1 39.20 25,088 35,280 42,336 0.15 0.15 0.15 27

10 1.50 58 37,120 52,200 62,640 0.17 0.17 0.18 5310 1.25 61.20 39,168 55,080 66,096 0.15 0.15 0.15 5210 1 5512 1.25 84.30 53,952 75,870 91,044 0.12 0.12 0.12 9012 1.25 92.01 58,886 82,809 99,371 0.12 0.12 0.12 9512 1.50 88.01 56,326 79,209 95,051 0.15 0.15 0.15 9014 2 115 73,600 103,500 124,200 0.17 0.16 0.17 14014 1.50 125 80,000 112,500 135,000 0.13 0.13 0.13 15016 2 157 100,480 141,300 169,560 0.15 0.15 0.15 21516 1.50 167 106,880 150,300 180,360 0.11 0.11 0.11 22518 2.50 192 122,880 172,800 207,360 0.17 0.17 0.19 29518 1.50 216 138,240 194,400 233,280 0.10 0.10 0.10 32520 2.50 245 156,800 220,500 264,600 0.15 0.15 0.15 41520 1.50 272 174,080 244,800 293,760 0.09 0.09 0.09 46022 2.50 303 193,920 272,700 327,240 0.13 0.13 0.14 58022 1.50 333 213,120 299,700 359,640 0.08 0.08 0.08 61024 3 353 225,920 317,700 381,240 0.15 0.15 0.15 71024 1.50 384 245,760 345,600 414,720 0.08 0.08 0.08 78027 3 459 293,760 413,100 495,720 0.13 0.13 0.13 1,05030 3.50 561 359,040 504,900 605,880 0.14 0.13 0.14 1,42033 3.50 694 444,160 624,600 749,520 0.13 0.13 0.14 1,90036 4 817 522,880 735,300 882,360 0.14 0.13 0.15 2,40039 4 976 624,640 878,400 1,054,080 0.13 0.14 0.14 3,10042 4.50 1,120 716,800 1,008,000 1,209,60045 4.50 1,300 832,000 1,170,000 1,404,00048 5 1,470 940,800 1,323,000 1,587,60052 5 1,760 1,126,400 1,584,000 1,900,800

Calidad Limite Elástico Carga Rotura AlargamientoDureza Brinell

(X,Y F-Z)[ Cr ] 2º Ensayo

(N/ mm²) (N/ mm²) % (Kg. mm²)8,8 F-114 640 800 8.00 247-277

10,9 F-125 900 1,000 9.00 296-35312,9 F-125 1,080 1,200 8.00 353-407

p = 3.1415927

[ F ] = A.Le [ m ] = [ M ] =

[ Le ] = Cr.(Y/100)

Page 61: hoja cálculo tornillos

CARACTERÍSTICAS TORNILLERÍA

Pares de Apriete10.90 12.90

F . P2p*mC

(N. m)4.10 4.908.50 10.0015 1721 2640 4138 4575 8373 8870 85125 145135 160125 150200 230210 250300 355315 380410 425460 550590 690640 770820 930860 1,050

1,000 1,2001,100 1,3001,480 1,8002,090 2,4002,750 2,9003,580 3,7004,000 4,800