Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Buckling of columns with varying cross section
- Writing Arrays to the worksheet - VBA function
- Continuous Beams With Spring Supports by Macaulay’s Method
- Daily Download 3: ULS design of reinforced concrete sections
- Linking Excel to C - 2
Recent Comments
Category Archives: Newton
Managing Data Using Excel …
… is a new book by Mark Gardener, published by Pelagic Publishing.* It is subtitled “Organising, summarising and visualising scientific data”. The publishers say of the book: Microsoft Excel is a powerful tool that can transform the way you use … Continue reading
Posted in Charts, Excel, Newton
Tagged Charts, pivot tables, Scientific data analysis
Leave a comment
xlSciPy 1.01
The xlSciPy spreadsheet, introduced here, has been updated with many new functions. The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy. It … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel. VBA, ExcelPython, Fast Fourier Transform, Python, SciPy distance functions, sparse solvers, UDF
Leave a comment
ConbeamU Update Update
Following some comments from 4Step on the last ConbeamU update, and a thorough check of results against Strand7 results, I have posted a new version that fixes a number of issues with the previous one. The new version number is … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, Strand7, UDF, VBA
4 Comments
ConbeamU Update; defined support deflections
As promised in a recent post, I have updated the ConBeamU spreadsheet to allow defined deflections to be specified at any support. The new spreadsheet (including full open-source code), can be downloaded from ConBeamU.zip In addition to the support deflections the … Continue reading
Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged array entry, Array function entry, ConBeamU, continuous beam, defined support deflections, deflections, Excel, Macaulay's Method, UDF, VBA
12 Comments