Category Archives: VBA

A Loopy Link (and three more)

Posted on 23/08/2015 by dougaj4

For some reason Doug Glancy’s Excel Blog has escaped my attention up till now, but having a browse today, I discovered this loopy animation: which would not have been out of place in Douglas Hofstadter’s “I am a Strange Loop” I really … Continue reading →

Posted in Animation, Computing - general, Excel, Maths, Newton, VBA | Tagged , , , , , | 2 Comments

Filling Blanks with Go To-Special (and local help rant)

Posted on 10/08/2015 by dougaj4

Recently a thread at the Eng-Tips forum prompted me to look for help on the Go To-Special function in Excel.  Pressing F5-Alt S, then clicking the help icon in the dialog box brought up: It seems that the offline help … Continue reading →

Posted in Excel, VBA | Tagged , , , , , , | 13 Comments

ConBeamU 4.05 and ConBeampy 1.02

Posted on 15/07/2015 by dougaj4

The latest update of the two continuous beam spreadsheets can be downloaded from: ConBeamU.zip ConBeampy.zip The main changes are: A problem with point loads applied exactly at a support position has been corrected A function has been added to evaluate … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

New and updated links

Posted on 12/07/2015 by dougaj4

I have just updated my Blogroll, with 9 new links, and a couple of updates: Colin Caprani’s site is now back on-line I have updated the link to Jon Peltier’s blog dataprose.org was the source of many of the new links, … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | Leave a comment

Section Properties – Lunes and Groups

Posted on 08/07/2015 by dougaj4

Following a discussion at Eng-Tips and resulting comments I have updated my Section Properties spreadsheet to include calculation of the area and centroid of a “Lune” (the shape of a crescent moon).  I have also added a “Re-draw Shape” button because … Continue reading →

Posted in Drawing, Excel, Maths, Newton, VBA | Tagged , , , , | 2 Comments