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
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
- Writing Arrays to the worksheet - VBA function
- Linking Excel to C
Recent Comments
Category Archives: Newton
3DFrame-py update
The Python 3DFrame spreadsheet has been updated to allow for analysis including torsional warping effects. The new spreadsheet and associated Python files can be downloaded from: 3DFrame-py.zip The download file includes four sample spreadsheets comparing analysis results with output from … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7
Tagged 3DFrame-py, Excel, Frame Analysis, global axes, local axes, MASTAN2, principal axes, Torsional warping
1 Comment
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