Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- Cubic Splines
- About Newton Excel Bach
- Downloads
- Biaxial bending update
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 5: Frame Analysis
- Linking Excel to C - 2
- Frame Analysis with Excel – 7; Shear deflections and support displacements
Recent Comments
Monthly Archives: July 2013
SelectAv Function
Suppose you have a spreadsheet range containing numerical data, and would like to find the average for a number of the most recent values, ignoring the highest (and/or lowest) values from the selected set. If you like using long array … Continue reading
Copy non-blank rows to another sheet
A thread at Eng-Tips asked for a way to display the data from Sheet2 on Sheet1, but only the rows that were not blank in Column A. There are probably ways to do it without VBA, but it seems to me … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Array Function, copy non-blank rows, Excel, UDF, VBA
3 Comments
Just discovered – Data Explorer
Browsing, following up Jeff Weir’s recent comments, led me to a Bacon Bits post about a new add-in from Microsoft called Data Explorer, for importing, transforming and merging data from a wide variety of sources. Follow the Bacon Bits link … Continue reading
Using RC Design Functions 4 – Umom and new MaxAx function
Previous post in this series. Download latest version of RC Design Functions6. Previous posts in this series have looked at elastic design functions. We now move on to functions for ultimate limit state (ULS) analysis of reinforced concrete sections: UMom: … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged ACI 318, AS 3600, AS 5100, BS 5400, BS 8110, Combined bending and axial load, EC 2, Excel, slender columns, UDF, ULS Analysis, VBA
6 Comments
Concrete ULS spreadsheet update-2
The concrete ULS design spreadsheet last posted at: Concrete ULS spreadsheet update has been updated to fix a problem encountered with non-symmetrical reinforcement using the Eurocode 2 rectangular stress block. Download from ULS Design Functions. Typical input and output interaction diagram are … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Eurocode 2, Excel, Prestressed Concrete Design, Reinforced concrete design, UDF, ULS Design Functions, VBA
11 Comments