Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Latex Maths Text in Excel
- About Newton Excel Bach
- Downloads
- Retrieving unique values from a range or array ...
- Frame Analysis with Excel - 3, Continuous beam or frame
- ULS design of circular reinforced concrete columns
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Category Archives: UDFs
Tension Stiffening
Tension Stiffening in reinforced concrete is the increase in stiffness of a cracked member due to the development of tensile stresses in the concrete between the cracks. The main application of tension stiffening theory in design applications is in the … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Excel, moment curvature, Reinforced Concrete, tension stiffening, UDF, VBA
3 Comments
Stringing more than two words together
It has always seemed strange to me that the Excel function Concatenate(), which has such a long name, provides no additional functionality over using the & operator. The TextString function is a simple User Defined Function (UDF) which provides the … Continue reading
Reinforced Concrete Moment-Curvature – 4; Development of curvature over time
The previous post in this series looked at how specified shrinkage and creep strains affect the curvature of a reinforced consrete section subject to a constant load. In this post I will present a User Defined Function (UDF) that analyses … Continue reading
Posted in Concrete, Excel, Newton, UDFs, VBA
Tagged creep, Eurocode 2, Reinforced Concrete, shrinkage
6 Comments
Hello World (again)
Over at Daily Dose of Excel Dick has been asking for suggestions for excellent training, to which Jan Karel Pietersen replied that training should be relevant to the task at hand, and that “hello world” examples are useless. John Walkenbach responded … Continue reading
Good practice, best practice, or just practice?
Browsing the ‘net this morning I found the “Golden Rules” listed below at Ozgrid.com The rules are described as things that “should not be optional”, which seemed to me in some cases to be going way too far, since for many … Continue reading