Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Daily Download 5: Frame Analysis
- XLDennis, the MSDN Library, and VBA rant
- Linking Excel to C - 2
- Writing Arrays to the worksheet - VBA function
Recent Comments
Author Archives: dougaj4
Pi day of the Century
In North America, where today is 3-14-15, it is Pi day, and since there are not 31 days in April, the rest of us have to go along with that as well. Not only is it Pi day, it’s the … Continue reading
Continuous Beams with Specified Deflections
A few weeks ago there was some discussion in a previous continuous beam post about how to analyse a continuous beam with specified deflections at the supports. In this post I will look at three different ways of doing this … Continue reading
Posted in Excel
Tagged ConBeamU, continuous beam analysis, Excel, specified displacements, UDF, VBA
1 Comment
7 Year Report
As in previous years, I have downloaded the statistics for this blog for the previous year, and pasted them into a worksheet. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what … Continue reading
Reducing Risk in Structural Concrete Design
The Concrete Institute of Australia is running a series of full day seminars on Structural Concrete Design for Extreme Events in each of the mainland capitals: See: Structural Concrete Design for Extreme Events for details of dates and locations in … Continue reading
Posted in Concrete, Newton
Tagged Concrete Institute, Earthquake design, Fire design, Risk reduction
Leave a comment
Slicing Arrays with VBA
A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading