Tag Archives: Excel

Spherical Geometry and Vincenty’s Formulae

Posted on 27/09/2020 by dougaj4

Wikipedia has detailed articles on: Spherical Geometry  and Vincenty’s Formulae (for geometric calculations on an ellipsoid). The spreadsheet Vincenty.zip uses those resources to perform the following calculations, using both on-sheet calculations and VBA user-defined functions (UDF’s): Calculation of distance and … Continue reading →

Posted in Computing - general, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 9 Comments

Import Data from a Picture to Excel

Posted on 16/09/2020 by dougaj4

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 , , , | 1 Comment

Concrete Stress Blocks

Posted on 15/08/2020 by dougaj4

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 , , , , , , , , , | 1 Comment

Deflections and Moments in Rectangular Plates

Posted on 09/08/2020 by dougaj4

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 , , , , , , , , , , | 7 Comments

Section Properties for Rotated Shapes

Posted on 06/08/2020 by dougaj4

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