Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- AS 3600 public comment draft and py_RC Design
- Deflections and Moments in Rectangular Plates
- Using LINEST for non-linear curve fitting
- Taming Symbols in Excel
- Finding Prime Numbers with Excel, and using Array Formulas
- Retrieving unique values from a range or array ...
- Tension Stiffening
- Downloads
- The history of the theory of beam bending - Part 3
- 3D Frames, axes and stiffness matrices
Recent Comments
Category Archives: Newton
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
Katherine Johnson, NASA Legend
Cartoon by Steve Breen from The San-Diego Union Tribune. More on Katherine Johnson.