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
- Downloads
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- Linking Excel to C - 2
- RCInteract and RC Design Functions 7.03
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Category Archives: Newton
Lennox Bridge
Last December I joined Bill Harvey on a visit to Lennox Bridge west of Sydney. Bill has now documented the visit in his Bridge of the Month site, including history, comments on the structural form, and a dynamic 3D model … Continue reading
Posted in Arch structures, Historic Bridges, Newton
Tagged 3D Model, Bill Harvey, Bridge of the Month, Lennox Bridge, stone arch bridge
Leave a comment
The Concrete Institute of Australia – Golden Jubilee
The Concrete Institute of Australia will celebrate 50 years in 2020. The Institute was originally formed when members of the Australia Prestressed Concrete Group proposed a change in 1968 where it was resolved to adopt the name Concrete Institute of … Continue reading
Dancing Pendulums Revisited
I have previously posted on Dynamically Defined Dancing Pendulums, using the Strand7 FEA program to generate the motion of a series of pendulums of varying length. I have now updated that video using the latest Beta version of the program (Rel … Continue reading
Posted in Animation, Finite Element Analysis, Frame Analysis, Newton, Strand7
Tagged avi, dynamic analysis, mp4, Pendulum animation, Snagit, Strand7
Leave a comment
More Python Traps
I recently posted on some Python Traps, focussing on code where changes in the values of sub-routine arguments were not reflected in the calling routines. The reverse can also be a problem: if an array, a, is passed to a … Continue reading
Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Numpy, Passing variables, Python, python traps, PyXLL, UDF
Leave a comment
LinEstGap with non-linear functions
The LinEstGap user defined function (UDF) allows the built-in Linest function to be used on data with empty cells or hidden rows, returning results that agree with the chart trend-line function, which automatically ignores blank cells and hidden data. It … Continue reading
Posted in Arrays, Curve fitting, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, Exponential curves, Linest, Linest with gaps, Log curves, non-linear curve fitting, Polynomial curves, Power curves, UDF, VBA
4 Comments