- #BOLT WEIGHT CALCULATOR EXCEL MANUAL#
- #BOLT WEIGHT CALCULATOR EXCEL CODE#
- #BOLT WEIGHT CALCULATOR EXCEL PLUS#
Thanks for the spreadsheet and any comments.The relation between applied torque and axial force – or load – in a bolt can be calculated as But once I made the change from sin to asin, I was able to match results from this spreadsheet, the one I had been working on, and Horn?s example to within 4 decimal places. Using the data from Horn's example, the maximum bolt force and concrete stress only changed by about 2%. The first comment above is the only one that actually affects the results. I believe a negative sign should also be shown before the first bracket.(These corrections are used in the formula in cell P45). The fourth term in the written equation in cell Q45 shows ?ri^2*sin(yc/ri)/4? I believe this should be ri^4*asin(yc/ri)/4 as used in cell P45 and Horn?s example on page 60. I believe A1 is the correct value to use.
#BOLT WEIGHT CALCULATOR EXCEL MANUAL#
of Horn?s manual shows Ac, but the example on page 60 uses the value of A1. The last value in the written equation in cell Q39 uses Ac. The formula in cell P39 uses the value for A1. The fourth term in the written equation in cell Q44 shows ?r^2*sin(yo/r)/4? I believe this should be r^4*asin(yo/r)/4 as used in cell P44 and Horn?s example on page 60. Referencing page 57 of Horn?s Tech Manual, I believe this should be the arcsin. In the calculation for ?I1? in cell P44, the fourth term uses sin(yc/ri). However, I do have a few of items I would like to have verified, if possible. This is a very well thought-out spreadsheet the input and documentation is very clear. I found the Circbase spreadsheet here, and it has been a great help. I had started to develop a spreadsheet of my own based on Daniel Horn?s Tech Manual, and was having problems working out some bugs I was having with it.
#BOLT WEIGHT CALCULATOR EXCEL CODE#
Simply Supported, the Third Edge Free and the Fourth is Built In ()ĪISC 9th Edition Allowable Stress (ASD) ManualĪCI 318-02 Building Code Requirements For Structural Concrete Table 26 - Deflection & Bending Moments for a Uniformly Loaded Plate with Two Opposite Edges For the addition of gusset plates to the baseplate, this program derives the baseplate moments from "Theory of Plates and Shells", by S. Merely move the mouse pointer to the desired cell to view the contents of that particular "comment box".)Ĩ. (Note: presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell. This program contains numerous “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc. Axial column load, 'P' > 0 for the case with moment.ħ. The column & base plate are centered on a round pedestal in both directions.ī. The column is centered on a circular base plate in both directions.ī. Additional assumptions used in this program are as follows:Ī. User has option to take out some of the total shear though friction between column base and grout based on column dead load and coefficient of friction, thus reducing amount of shear to be taken by anchor bolts.Ħ. Section 10.17 of ACI 318-02, "Building Code Requirements For Structural Concrete"ĥ. For concrete bearing, this program follows: For steel interaction of anchor bolt tension and shear, this program follows:Īppendix D of ACI 318-02, "Building Code Requirements For Structural Concrete"Ĥ. This program follows the procedures and guidelines of the AISC 9th Edition Allowable Stress (ASD) Manual (2nd Revision, 1995) for round hollow structural tube & column base plates subjected to flexure.ģ. This program follows the procedures and guidelines of "Design of Monopole Bases", by Daniel Horn, P.E.Ģ. This program is a workbook consisting of two (2) worksheets, described as follows:Ĭomplete method - Circular base plate analysisġ. Finally, a propoesed base plate thickness is is checked. If shear is present, bolt shear as well as interaction of bolt tension and shear, if applicable, are calculated. Base plate bearing pressure is checked as well as bolt tension, if applicable.
#BOLT WEIGHT CALCULATOR EXCEL PLUS#
Specifically, pipe columns base plates may be subjected to axial loads (compression only), with or without column bending, plus shear. "CIRCBASE" is a spreadsheet program written in MS-Excel for the purpose of analysis of steel column base plates. "CIRCBASE" - STEEL COLUMN CIRCULAR BASE PLATE ANALYSIS
0 kommentar(er)
