Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Daily Download 8: Drawing in Excel
- Downloads
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Time in hours and minutes between two dates
Recent Comments
mounir soufi on More on RC design of circular… dougaj4 on More on RC design of circular… mounir soufi on More on RC design of circular… mounir soufi on More on RC design of circular… Sophea CE on Biaxial bending update Sophea CE on Biaxial bending update Python optional argu… on Using Python optional argument… Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for…
Tag Archives: VBA
Newton-Raphson and Brent’s Method – Solver examples
I recently discovered the Computing Skillset site (via open-struct-engineer), which has good information on the basis and use of the Newton-Raphson method: The Newton Raphson method explained, details, pictures, python code Highly instructive examples for the Newton Raphson method I … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Computing Skillset, Excel, Newton Raphson Method, UDF, VBA
Leave a comment
Spherical Geometry and Vincenty’s Formulae
Wikipedia has detailed articles on: Spherical Geometry and Vincenty’s Formulae (for geometric calculations on an ellipsoid). The spreadsheet Vincenty.xlsb uses those resources to perform the following calculations, using both on-sheet calculations and VBA user-defined functions (UDF’s): Calculation of distance and … Continue reading
Posted in Computing - general, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged ellipsoid area, ellipsoid distance, Excel, Spherical Geometry, UDF, VBA, Vincenty's Formulae
Leave a comment
Concrete Stress Blocks
Back in 2010 and 2011 posts here looked at a comparison of alternative stress blocks in the then new AS 3600, and a procedure for calculating parameters for a rectangular stress block exactly equivalent to the Eurocode 2 parabolic-rectangular stress … Continue reading
Section Properties for Rotated Shapes
I have just posted an update to my section properties spreadsheet, last discussed at: Using Section Properties- Group The new version can be downloaded from: Section Properties07-Group.zip The main sheet provides section properties for a wide variety of defined shapes: This … Continue reading
Posted in Beam Bending, Coordinate Geometry, Excel, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged Excel, section properties, section properties of rotated shapes, UDF, VBA
Leave a comment
Reinforced Concrete Design for Circular Sections to Eurocode 2
As mentioned in the previous post, the Reinforced Concrete Design Functions spreadsheet includes a function for ULS analysis of circular sections, using either a rectangular or a parabolic-linear stress block. A new CircuPF function has now been added, for codes … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Eurocode 2, Eurocodeapplied, Excel, RC Design Functions, Reinforced concrete design, UDFs, UK National Annex, ULS design of circular section, VBA
1 Comment