Tag Archives: Excel

Reinforced Concrete Section Analysis – 5; Ultimate Limit State

Posted on 19/08/2008 by dougaj4

Previous posts in this series have looked at the analysis of beams where the steel stress is within the elastic range, and the concrete stress is sufficiently low that the assumption of linear elastic behaviour in compression is a reasonable approximation.  … Continue reading →

Posted in Beam Bending, Excel, UDFs | Tagged , , , , , , , | 5 Comments

Intersections, interpolations, and rotations

Posted on 10/08/2008 by dougaj4

Amongst the many and varied functions provided by Excel (or as far as I know any other spreadsheet) there are none that provide a one step process for linear interpolation, finding the intersection points of lines, or conversion between polar … Continue reading →

Posted in Coordinate Geometry, Excel, UDFs, VBA | Tagged , , , , , , | 37 Comments

Drawing in Excel 5 – Shape List

Posted on 26/07/2008 by dougaj4

Previous Post For some reason best known to Microsoft, the Excel documentation does not include a graphic list of shapes with an example of each shape, and the text list they do provide is incomplete.  The file shapelist.zip rectifies that … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 4 Comments

Newton’s Cradle

Posted on 20/07/2008 by dougaj4

Previous animation post I have added a Newton’s Cradle animation to the animation file posted previously: Animation.zip The animation finds the correct period for the input string length and starting angle, and displays the movement of the balls in real … Continue reading →

Posted in Animation, Drawing, Excel, Newton | Tagged , , , | 4 Comments

Drawing in Excel-4

Posted on 15/07/2008 by dougaj4

This post will look in a bit more detail at the methods presented in the previous post.  It would be a good idea to open the previous post on another tab, or download the example file and open the code … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 3 Comments