Wednesday, July 4, 2018

Home / Connection Design / Engineering / Spreadsheet / Weld Analysis / Fillet Weld Coefficient Calculator Spreadsheet Free Download (Version 2.0)

Fillet Weld Coefficient Calculator Spreadsheet Free Download (Version 2.0)

by on in , , ,

Below is a captured image of a Microsoft Excel Spreadsheet. The spreadsheet is an implementation of Fillet Weld Coefficient Calculator VISUAL BASIC Code. It calculates the coefficient 'C' of eccentrically loaded fillet weld group using INSTANTANEOUS CENTER of ROTATION METHOD. An online ECCENTRICALLY LOADED FILLET WELD COEFFICIENT CALCULATOR will be available soon on this blog. You may download the Microsoft Excel Workbook containing the spreadsheet by clicking the download buttons below.


Please note Spreadsheet Version 2.0 slightly differs from Spreadsheet Version 1.3 previously posted. The later version allows weld segments to be specified with different weld sizes.

To help ease your burden in connection design calculations, I am giving away the spreadsheet for FREE. However, if you are a generous person as I do and you find the spreadsheet helpful, you may want to click the DONATE button provided below.

FILLET WELD COEFFICIENT CALCULATOR SPREADSHEET



Choose File To Download:


Click this button if you are a Generous Person!



Author Image

About Redeemer
I am a simple but HANDSOME CIVIL/STRUCTURAL ENGINEER. Do you want to stay handsome? Please email me at redemlegaspi@gmail.com.

Related Posts:

By vào lúc
Labels: , , ,

8 comments:

  1. CraigJuly 30, 2018 at 2:25 PM

    Great work!
    It would be good to see the IC plotted on the graph just for info, and also the loading arrow actually applied location wise to scale on the diagram. It can be a little misleading when you have a large weld group but it plots the load vector outside of the weld group.

    Also from a technical standpoint, what benefits are you seeing over simply using an 'elastic approach' to determining the weld capacity. Can you generalise it to any degree, like you might get X% more capacity for the same sized welds base don your experience, I understand theoretically this is more 'correct' than using an elastic method (my understanding is the elastic methods are viewed as being conservative at least)?

    ReplyDelete
    Replies
    1. RedeemerMay 14, 2019 at 11:21 PM

      Hi Craig,

      sorry, i forgot to reply to your comment. anyway, i will try to do something about your suggestions.

      Many, many thanks...

      Delete
  2. michaelJanuary 24, 2020 at 1:04 AM

    Yes, great tool, Thanks!
    Craig is right, the location of the IC printed in the diagram would be helpful. Especially to understand xRo and yRo (relative to {0;0} coordinates? relative to CG?). Also the positive direction of axis x/y are usually demanded by clients.
    Thanks again,
    Michael

    ReplyDelete
    Replies
    1. RedeemerJanuary 24, 2020 at 7:37 PM

      Thanks, Mike. I will add that feature soon. Just give me some time. Just too busy right now with my job. Hard to find ample time to do the spreadsheet update. I will be updating this post to include the revised version of the spreadsheet soon.

      Delete
  3. UnknownApril 21, 2020 at 3:21 AM

    Hi,
    Great job, thank you.
    Is there any chance of releasing a version of this in metric units? That would be great.

    ReplyDelete
  4. SmonJune 16, 2023 at 8:05 AM

    Hi, I have been using this spreadsheet for years as a connection engineer, And now it doesn't work anymore. Using Excel 365 Version 2304 64bits. The IC value is constantly calculation even for simple weld profile. it says Instantaneous Center Found: xRo = -nan(ind),000, yRo = -nan(ind),000

    ReplyDelete
    Replies
    1. RedeemerJune 21, 2023 at 5:12 PM

      i will look into this matter and make an update to the spreadsheet. please bear with me.

      Delete
  5. fiberglass greenhouse panelsJune 28, 2023 at 8:53 AM

    Good information.

    ReplyDelete

Subscribe to: Post Comments (Atom)