Category Archives: VBA

ConBeamU and Strand7 check update

Posted on 05/12/2025 by dougaj4

Results of the continuous beam spreadsheet were last checked against Strand7 results 10 years ago. I have now updated this check with the latest version (4.19), which can be downloaded from: ConBeamU.zip The download file now includes: The Strand7 check … Continue reading →

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

ConBeamU update

Posted on 20/09/2025 by dougaj4

Following a comment at https://newtonexcelbach.com/2023/01/20/using-conbeamu/ I have updated the ConBeamU-Template file so that the function to select the input range works the same as in the main spreadsheet. For more details of how the spreadsheet works, see the link above, … Continue reading →

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

Pandigital sums and Python permutations and combinations

Posted on 13/04/2025 by dougaj4

The New Scientist brain twister from last weeks edition has several problems involving pandigital sums, which are additions that use each of the digits from 0 to 9 exactly once, and with no number within the sum that starts with … Continue reading →

Posted in Arrays, Computing - general, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , | Leave a comment

ULS Design Functions-biax 0.08

Posted on 16/03/2025 by dougaj4

I have just uploaded a new version ULS Design Functions-biax, which can be downloaded (together with the uni-axial version) from: ULS Design Functions.zip The main changes are added code parameters from Eurocode 2: Detailed output for a specified load and … Continue reading →

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

RC Design Functions 9.09

Posted on 12/03/2025 by dougaj4

The RC Design Functions spreadsheet has had two further recent revisions: 9.08 21-Feb-25 CircUPF EC2 parameters corrected to allow variation of reduction factors for steel and rectangular stress block factors.9.09 6-Mar-25 Calculation of depth NA amended in UMomPF for NA … Continue reading →

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