Category Archives: Excel

Reinforced Concrete Moment Curvature – Development over time

Posted on 28/08/2015 by dougaj4

I recently noticed that in the RC Design Functions spreadsheet the TimeCurve function had stopped working.  The function calculates the development of reinforced concrete section curvature over time, and was previously presented in Reinforced Concrete Moment-Curvature – 3; Restrained Shrinkage and Creep and Reinforced … Continue reading →

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

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

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