Recent Comments
Tag Archives: VBA
More on writing arrays to the worksheet
Writing a large VBA array to the worksheet in a single operation, rather than cell by cell, can result in a huge improvement of the speed of many macros. The basic technique was described here. I recently wanted to modify this … Continue reading
Using the Strand7 API
Strand7 is a general purpose Finite Element Analysis program, which has an Application Programming Interface (API), allowing external programs to interact with Strand7, including reading and writing to data files, running analyses, and reading the results. The API is a comprehensive … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged API, Excel, Finite Element Analysis, Strand7, UDF, VBA
7 Comments
Flipping Coin Problems
At Daily Dose of Excel Dick K. looks at a VBA solution to this problem: Problem description: Take a stack of coins all heads up. Upturn the topmost coin, place back on the stack and then proceed: take the top 2 … Continue reading
Using Beam Design Functions
“Beam Design Functions” is an Excel spreadsheet providing a User Defined Function (UDF) that will calculate the stresses, strains, forces and moments in a reinforced or prestressed concrete section subject to any specified bending moment and axial load, using an … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Beam Bending, elastic analysis, Excel, Prestressed concrete, Reinforced Concrete, Section Analysis, UDF, VBA
12 Comments
Spline Interpolation Alternatives
A recent post at Jon Peltier’s Blog looks at an “on-sheet” method of performing linear interpolation on a set of tabular data, and the following comments include a number of alternative ways of carrying out the same process, and also some … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic splines, curve fitting, Excel, Interpolation, UDF, VBA
7 Comments
Newton Excel Bach, not (just) an Excel Blog 