Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 5: Frame Analysis
- The angle between two vectors, Python version
- Daily Download 4: Continuous Beam Analysis
- Downloads
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Moving averages and User Defined Array Functions
Recent Comments
Category Archives: Newton
Mastan2
Mastan2 is a free frame analysis program based on Matlab. The linked site provides alternative downloads for those with or without Matlab installed. The site also provides a link to the book Matrix Structural Analysis, 2nd Edition, by McGuire, Gallagher, … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7
Tagged 3DFrame, Excel, Frame Analysis, global axes, local axes, MASTAN2, principal axes, Torsional warping
1 Comment
Concrete 2023
The Concrete Institute of Australia’s biennial conference is almost upon us. This year it is being held in Sydney from 10-13 September. CONCRETE 2023 Look below at what’s in store at Concrete 2023. Keynote and Invited Speakers We have … Continue reading
Posted in Concrete, Newton
Tagged Concrete 2023, conference registration, Conference speakers
Leave a comment
Dynamic charts
A frequently asked question is how to get Excel charts to automatically update when new data is added outside the original selected ranges. The most frequent recommendation (such as here) is to convert the data to a table, then insert … Continue reading
Posted in Charts, Charts, Concrete, Excel, UDFs
Tagged Dynamic charts, Dynamic functions, Engineer v Sheep, Excel, Plotting interaction diagrams, UDFs
Leave a comment
3DFrame-py
My 3DFrame spreadsheet has now been converted to Python code and can be downloaded from: 3DFrame-py.zip The frame analysis uses the Scipy linear algebra functions called from pyLinalgfuncs3, which must be available on the Python path: pyLinAlgfuncs3.zip The 3DFrame-py download … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, VBA
Tagged 3DFrame-py, Excel, Frame Analysis, Numba, PyPardiso, Python, PyXLL, SciPy
3 Comments
Calculating and plotting rotations
This post was prompted by a recent post at Eng-Tips. The original problem seemed simple enough: Im trying to wirte a formula where I imput vessel heading and datum bore heading and it tells me FWD, STBD, AFT or PORT … Continue reading
Posted in Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA
Tagged Calculate rotations, Excel, Mod, Nautical bearings, Plot rotations, VBA, VLookup
Leave a comment