Author Archives: dougaj4

ULS Design Functions – Python version

I have now converted my ULS Design Functions spreadsheet (last presented here) to Python. The new spreadsheet and open source Python code can be downloaded from: py_ULS Design Functions The spreadsheet has the same functionality as the VBA version, providing … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , , , , , , | 3 Comments

Downloads update

A list of files available for free download can be found under the Downloads link at the top of the page: The list has now been updated and there are now 189 files available for download, most with open source … Continue reading →

Posted in Computing - general, Excel | Tagged , , , , , , | Leave a comment

A not so easy problem

A seemingly simple problem was posted in my Quora feed: or to put it more mathematically, what three positive integers satisfy the equation: It turns out the answer is not so simple. A full and detailed derivation can be found … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, PyXLL, UDFs | Tagged , , , , | 1 Comment

Displaying You-tube transcripts

This is probably widely known, but I only found out this week. I find You-tube informative videos frustrating because you have to sit through 10-20 minutes of video to get maybe 1-2 minutes worth of information. If only you could … Continue reading →

Posted in Bach, Newton | Tagged , | Leave a comment

ULS Design Functions 2.16

The ULS Design Spreadsheet has now been updated to Version 2.16, which can be downloaded from: ULS Design Functions The main new feature is the option to design for prestress loads applied to circular tanks. Due to axi-symmetric effects, when … Continue reading →

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