Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Downloads by category
- Cubic Splines
- Writing an array to a worksheet range - correction
- Section Properties of Defined Shapes - Spreadsheet
- Drawing in Excel 7 - Creating drawings from coordinates
- Frame Analysis with Excel 1 - Single beam
- Using Goal Seek on Multiple Cells
- Finding Prime Numbers with Excel, and using Array Formulas
- Fitting high order polynomials
Recent Comments
Using RC Design Func… on Using RC Design Functions… dougaj4 on Using RC Design Functions… Omar Khan on 5 Year Report hadwao on Using RC Design Functions… dougaj4 on Using RC Design Functions… hadwao on Using RC Design Functions… Marina Lindon on More from the Low Countri… China Amazing Archit… on World’s Largest Natural… metroxx on Using RC Design Functions… dougaj4 on Using RC Design Functions… metroxx on Using RC Design Functions… dougaj4 on Using RC Design Functions… metroxx on Using RC Design Functions… metroxx on Using RC Design Functions… Using RC Design Func… on Using Array Formulas
Category Archives: Newton
Using RC Design Functions – 2
In the previous post we looked at a summary of the functions in the RC Design Functions spreadsheet, and ways of using the EStress function (download file with examples). In this post we will look in more detail at the … Continue reading
Posted in Concrete, Excel, Newton, UDFs, VBA
Tagged EStress, Excel, RC Design Functions, Reinforced concrete design, UDF, VBA
Leave a comment
A Fish Called Newton
From Big Questions Online (via Letters to Nature): By Frank Wilczek April 22, 2013 Imagine a planet encrusted with ice, beneath which a vast ocean lies. (Imagine Europa.) Within that ocean a species of brilliant fish evolved. Those fish were … Continue reading
While sitting in a tin can …
… astronaut Chris Hadfield has created a video cover of David Bowie’s “Space Oddity” made on location in the International Space Station: and a damned good job he made of it too. Top comment: I can’t stop watching this. Seriously.. everything … Continue reading
Using RC Design Functions – 1
Download RC Design Functions (includes full open source code) and EStress Examples.xlsx This series of posts will cover ways of using the many functions contained in the RC Design Functions spreadsheet, starting with some general comments on using the User … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Examples, Excel, RC Design Functions, Reinforced Concrete, UDF, VBA
11 Comments
World’s Largest Natural Arches
Update 9th May 2013: Not in the top 10 for size, but a little known rock formation in Australia: From AmusingPlanet.com and The Natural Arch and Bridge Society A natural arch is a geological formation where rocky cliffs subject to erosion … Continue reading
Section properties for groups of defined shapes
Following a discussion at Eng-Tips, I have modified the section properties spreadsheet (presented here) so that section properties can be found for groups of defined shapes, including provision for translation and rotation of each shape, and application of different E … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, section properties, section properties of multiple shapes, VBA
1 Comment
3DFrame Ver 1.03 and Frame4 Ver 3.07
Updated versions of my 2D and 3D frame analysis spreadsheets are now available for download from: 3DFrame.zip Frame4.zip The download files include full open-source VBA code, and dll files for compiled solvers for much better performance with large models. See http://newtonexcelbach.wordpress.com/2012/11/16/frame4-now-with-added-alglib/ for … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA
Tagged 3D frame analysis, Excel, Frame Analysis, VBA
3 Comments
Tanh-Sinh Quadrature V4.1
The latest update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes is now available for download from: Tanh-Sinh-V4.1. As usual, the download includes full open-source code and extensive documentation. Version 4.1 Release Notes 1. Small but useful accuracy improvements have been … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh Quadrature, UDF, VBA
Leave a comment
Bridges Over the Tiber -3
See Bridges Over the Tiber -1 for location map. The final installment of Bridges Over the Tiber brings us to the six bridges built in the 20 th Century, which can be grouped in three pairs: two copies of the ancient … Continue reading
Using Frame4 for truss analysis
The Frame4 spreadsheet is set up to allow the analysias of rigid-jointed 2D frames, but it is simple to use it for 2D truss analysis; simply either provide a moment release at each end of every member, or define every member … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Frame Analysis, trusss analysis, VBA
1 Comment