Tag Archives: Excel

Import Data from a Picture to Excel

Posted on September 16, 2020 by

The myOnlineTraininghub blog recently had a post entitled Import Data from a Picture to Excel which sounded promising, since I often need to extract data from Autocad files saved to a pdf. From the link, it seems that if I … Continue reading →

Posted in Computing - general, Excel | Tagged , , , | Leave a comment

Concrete Stress Blocks

Posted on August 15, 2020 by

Back in 2010 and 2011 posts here looked at a comparison of alternative stress blocks in the then new AS 3600, and a procedure for calculating parameters for a rectangular stress block exactly equivalent to the Eurocode 2 parabolic-rectangular stress … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton | Tagged , , , , , , , , , | Leave a comment

Deflections and Moments in Rectangular Plates

Posted on August 9, 2020 by

Following a question here I have compared tabulated coefficients for deflections and bending moments in a rectangular plate with results of a Strand7 analysis using 8 noded plate/shell elements.  The results are summarised below, and in a spreadsheet which also … Continue reading →

Posted in Beam Bending, Curve fitting, Excel, Finite Element Analysis, Newton | Tagged , , , , , , , , , , | Leave a comment

Section Properties for Rotated Shapes

Posted on August 6, 2020 by

I have just posted an update to my section properties spreadsheet, last discussed at: Using Section Properties- Group The new version can be downloaded from: Section Properties07-Group.zip The main sheet provides section properties for a wide variety of defined shapes: This … Continue reading →

Posted in Beam Bending, Coordinate Geometry, Excel, Frame Analysis, Maths, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

Reinforced Concrete Design for Circular Sections to Eurocode 2

Posted on July 26, 2020 by

As mentioned in the previous post, the Reinforced Concrete Design Functions spreadsheet includes a function for ULS analysis of circular sections, using either a rectangular  or a parabolic-linear stress block.  A new CircuPF function has now been added, for codes … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | Leave a comment