Recent Comments
Tag Archives: VBA
Composite Beam Spreadsheet – 2
The previous post on this topic presented a spreadsheet performing elastic analysis of composite reinforced or prestressed composite beams, available for download from: Composite Design Functions-GS.zip. This post will look in more detail at how the spreadsheet works, and a preview … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged composite concrete beam, Excel, Goal Seek, Prestressed concrete, Reinforced Concrete, UDF, VBA
4 Comments
Modifying spreadsheet data with VBA – the quick way
A question recently came up (here) asking how to speed up the process of scanning a large range of data on one sheet, and wherever a cell had a value of zero, deleting the data in the same cell address … Continue reading
Composite Beam Spreadsheet
As promised in the previous post, a spreadsheet for designing reinforced or prestressed concrete composite beams has now been uploaded to my web site. It can be downloaded from: Composite Design Functions-GS.zip . As usual, the spreadsheet includes full open-source code. … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged composite concrete beam, Excel, Goal Seek, Prestressed concrete, Reinforced Concrete, UDF, VBA
3 Comments
Geometry for Joiners
A question came up on the ABC Self-Service-Science Forum, asking for a solution to find the dimensions of a diagonal brace looking like the diagram below: The solution is not as simple as it might look because the angle of … Continue reading
Posted in Coordinate Geometry, Excel, Newton, UDFs, VBA
Tagged circle intersection, Excel, Framebrace.xlsb, geometry, IP2.xls, UDF, VBA
1 Comment
Writing Arrays to the worksheet – VBA function
Previous posts have looked at the VBA code for efficiently writing a VBA array to the spreadsheet as quickly as possible, most recently here. I have now put this code in a function that can be conveniently called from any … Continue reading
Newton Excel Bach, not (just) an Excel Blog 