Posted By: Redem S. Legaspi

 

Description

This spreadsheet is a variant of the Eccentrically Loaded Bolt Group (any geometry) Coefficient C Calculator' I previously posted here on Steel Tools.

The spreadsheet has the following input/features:

1.) Any number of bolts can be specified.

2.) Bolt coordinates may be specified, thus allowing formation of bolt group of any geometry or arrangement.

3.) Load eccentricity and rotation can be specified

 

Spreadsheet Output:

The spreadsheet, as usual, calculates the C coefficient of a bolt group but this time it includes the following:

1.) Location of the INTANTANEOUS CENTER (I.C.) of rotation.

2.) Tabulated calculation of bolt stresses showing how the value of coefficient C is arrived at.

3.) With the I.C. determined, the spreadsheet also shows that the three equations of in-plane static equilibrium (ΣFx=0, ΣFy=0, ΣM=0) for bolt group have been satisfied --- thus, providing the PROOF that the value of coefficient C returned by the spreadsheet is correct.
 

List of Articles
번호 제목 글쓴이 날짜 조회 수
공지 [BeST.PCS Ver 2.6.1] 프리캐스트, 프리스트레스 부재설계 박종배 2019-07-03 188
공지 [BeST.RC Ver 2.8.1] 콘크리트 부재설계 프로그램 박종배 2019-06-03 1058
공지 [BeST.Steel Ver 3.1.1] 철골부재 설계 프로그램 박종배 2019-05-02 1585
공지 [BeST.Pro Ver 3.7.1] 건축구조 부재설계 프로그램 - KDS2019 내진기준 추가 [3] 박종배 2019-04-09 2596
107 Vertical Bracing Connection for Rectangular HSS file 박종배 2019-07-03 40
106 [BeST.Pro Ver 3.7.0] 건축구조 부재설계 프로그램 박종배 2019-02-07 2186
105 ASCE710W_v2.4 file 박종배 2019-01-15 542
104 [BeST.Steel Ver 3.1.0] 철골부재 설계 프로그램 박종배 2019-01-02 2813
103 [BeST.Basic Ver 2.7.9] 건축구조 단위부재 계산프로그램 박종배 2018-12-04 4715
102 [BeST.PCS Ver 2.5.2] 프리캐스트, 프리스트레스 부재설계 박종배 2018-11-05 964
101 [BeST.RC Ver 2.7.2] 콘크리트 부재설계 프로그램 박종배 2018-10-02 2605
100 [7-Zip Ver 16.04] 파일 압축 프로그램 file 박종배 2017-07-31 409
99 [Notepad++ Ver 7.4.2] 무료 텍스트 편집기 file 박종배 2017-07-31 587
98 가설 거푸집/동바리 구조계산 file 박종배 2016-09-05 6769
97 ASCE 7-10E file 박종배 2016-06-20 1086
96 END_PLATE-Moment Connection Design file 박종배 2016-06-01 931
» A variant of the Eccentrically Loaded Bolt Group (any geometry) Coefficient 'C' Calculator file 박종배 2015-07-13 473
94 Guide for the Design of Crane-Supporting Steel Structures file 박종배 2015-05-11 725
93 AISC360-05 LRFD Shear Plate bolted connection check file 박종배 2015-03-02 646
92 종합병원 병원 요양병원 내진설계 기준 file 박종배 2015-02-25 1557