Tag Archives: Excel

Elastic Biaxial Bending

Posted on 11/04/2021 by dougaj4

Spreadsheets performing Ultimate Limit State analysis with biaxial moments have been presented previously, most recently here: Biaxial bending update I have now modified the Beam Design Functions spreadsheet to carry out a biaxial moment analysis with linear elastic material properties. … Continue reading →

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

Floating Point Precision Problems

Posted on 05/04/2021 by dougaj4

A question on Quora : prompted me to look at how these numbers are handled in Excel, in VBA called from Excel, and in Python called from Excel via pyxll. The results are shown in the screenshot below: Column A … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , | 1 Comment

Lambda and VBA

Posted on 28/02/2021 by dougaj4

The new Excel Lambda function (see here for more details and links) is currently only available to those signed up to the Beta Preview version of Excel 365, but is has been favourably reviewed by almost all of those who … Continue reading →

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , , , | 1 Comment

Eval and Let examples

Posted on 21/02/2021 by dougaj4

Final example updated 28th Feb 2021, following comment from Craig: There are many examples of the use of the new Let function on the web (see my previous post on this topic for links). This post compares use of Let … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , , | 9 Comments

Two New Functions; Let and Lambda

Posted on 14/02/2021 by dougaj4

Two new Excel functions have recently attracted a lot of attention; these are: LET (now available to Office 365 subscribers and LAMBDA (currently available to Office Insiders program only) Microsoft documentation can be found at: Announcing LET Have you ever … Continue reading →

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