Category Archives: Excel

RCInteract and RC Design Functions 7.03

Posted on 09/04/2017 by dougaj4

Since the previous post, I have updated the notes in the RC Design Functions spreadsheet to reflect the fact that with the recent update to the Bridge Design Code (AS 5100) the reinforced concrete strength design requirements for beam bending … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , , , | 16 Comments

RC Design Functions 7.03

Posted on 06/04/2017 by dougaj4

The latest update to my RC Design Functions spreadsheet has just been uploaded, and is available for free download (including full open-source code) from: RC Design Functions7.zip The main new feature in the latest version is a new RCInteract function, which generates an … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

Indexing NumPy arrays with floats …

Posted on 01/04/2017 by dougaj4

… now you can’t. I recently updated to the latest version of NumPy (1.12.1), and today I discovered that some of my spreadsheets using NumPy arrays (via xlwings) were returning errors like: IndexError: only integers, slices (`:`), ellipsis (`…`), numpy.newaxis … Continue reading →

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA | Tagged , , , , , | 2 Comments

Formatting Text from VBA

Posted on 30/03/2017 by dougaj4

In a recent Eng-Tips thread someone wanted a VBA routine to combine a value with different + and – tolerance values, formatted as superscript and subscript.  Eng-Tips (and Tek-Tips) regular, Skip Vought, came up with a macro to do the job, … Continue reading →

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

Extracting numbers from text – update

Posted on 11/03/2017 by dougaj4

I have previously posted a spreadsheet with user defined functions (UDFs) using regular expressions to extract numbers from a text string (see Extracting numbers from text and regular expressions). I have now modified the Extractnums function to optionally return the numbers … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , | 2 Comments