Category Archives: Excel

Concrete 2015

Posted on 14/08/2015 by dougaj4

This year the 27th biennial Conference of the Concrete Institute of Australia will be held in Melbourne from 31st August to 2nd September, in conjunction with RILEM Week. Concrete 2015 On behalf of the organising and technical committees, we cordially invite … Continue reading →

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

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

Solvers, parsers and more

Posted on 18/07/2015 by dougaj4

Links to some really useful recently discovered sites: OpenSolver for Excel OpenSolver is an Excel VBA add-in that extends Excel’s built-in Solver with more powerful solvers. It is developed and maintained by Andrew Mason and students at the Engineering Science … Continue reading →

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

A mystery curve links to Jupyter

Posted on 16/07/2015 by dougaj4

Reviewing some of my less visited links recently, I was intrigued by a post at The Math Less Travelled: The previous post at the site provides more details of the source of the curve, and some links to an interactive … Continue reading →

Posted in Charts, Charts, Excel, Maths, Newton | Tagged , , , , , , | 2 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