Recent Comments
Category Archives: Excel
RC Design Functions 7.03
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
Indexing NumPy arrays with floats …
… 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 Float index, IndexError, Numpy, Python, VBA, xlwings
2 Comments
Formatting Text from VBA
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
Extracting numbers from text – update
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 Excel, Extract number from string, ExtractNums, regular expressions, UDF, VBA
2 Comments
Year 9 Report
Last years’ statistics for this blog are now uploaded to Onedrive. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what has been posted over the year, and what people are looking … Continue reading
Newton Excel Bach, not (just) an Excel Blog 