There is no guidance for this case.
tgtm's conservative solution should be followed, convert moment into an equivalent axial load and add to existing axial load by dividing moment by CHS section modulus then multiplying by CHS area.
From the menu select Format, Cells, click the Protection tab, ticking the locked box will specify the cell(s) selected as locked. I suggest you lock all the cells then select the individual cells you want to unlock.
You can use styles and specify locked/unlocked cells for each style.
Remember...
Thanks FrenchCAD, I also found it wasn't working because I was trying to select a group of items which didn't exist!
Thanks MintJulep, it now positions correctly.
Hi,
Can anyone please help me and put me right!
I am trying to select a group of shapes in Excel, copy, paste then position them using a macro. My feable attempt below selects but does not copy and paste! I haven't got as far as positioning yet.
Set myDocument =...
Hi Kags,
The moment is usually distributed into the chord each side of the joint as the bracings are considered pinned and chord continuous.
The moment is the combined horizontal component of the braces (along the axis of the chord) is multiplyed by the eccentricity ( distance between the chord...
Thanks for that ProjEngKLS,
I tried a new pair of workbooks like you and found no problems either!
I have a lot of code running and have found while a macro in one workbook is making changes to the 2nd workbook, which in turn sets off more macros in the 2nd workbook, was causing the crash. I...
Has anyone tried running two Excel Workbooks together, with a macro in one replacing cell values and changing option/check boxes in the second workbook?
As soon as the first workbook effects a option/check box change in the second workbook the relevent option/check box macro click event occurs...
I am writing a series of spreadsheets for tubular joint design and am really stuck with a macro problem. I've only recently started learning VB and any helpful advice would be most welcome.
I have written a Master Excel workbook which contains common values and information to all the joints...
There are some pdf's you can download for free from the Corus Tubes website (www.corustubes.com). Go to 'info centre', then 'publications'. 'Design of SHS welded joints' gives the fomulas, 'Design of SHS welded joints supplement' is additional info, 'Design of SHS joint examples' and 'SHS...
I agree with Curmudgeon and pylko, simple cantilever deflection theory. Consider half the plate as a cantilever with the central support as the fixed end. Beam length L is then half the plate length (or distance from support to end if not equal distance each side of support).
