Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Rory Phillips - The Truth
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Passing variable argument lists from Excel to Python via xlwings
- Time in hours and minutes between two dates
- Latex Maths Text in Excel
- Fitting high order polynomials
- Cubic Splines
- Deflections and Moments in Rectangular Plates
- Contour plots with Excel and Matplotlib
Recent Comments
Category Archives: VBA
RC Design Functions 9.06; Momcurve functions update
The RC Design Functions spreadsheet has now been updated to Version 9.06, and is available for free download from: RC Design Functions9.zip The new version fixes a problem with the MomcurveTS function, which was returning an error for any input … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Excel, MomCurve function, RC Design Functions, RC moment-curvature, Reinforced Concrete, UDFs, VBA
Leave a comment
Download Problems
Update 24th March 2024: The certificate problem has now been fixed, and most download links should now work without a problem. Note that any file with VBA code (which is almost all of them) will have the VBA blocked with … Continue reading
Posted in Computing - general, Excel, Link to dll, Link to Python, Python Pandas, PyXLL, UDFs, VBA
Tagged Clear downloads, Download link
1 Comment
Longitudinal force due to shear – update
In the post RC Design Functions 9.03; compression strut angle adjustment I recommended that when finding the longitudinal force due to shear according to AS 5100.5 (Amendment 1), the effect of increased vertical shear reinforcement should be limited in accordance … Continue reading
Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs, VBA
Tagged Concrete, Design for Shear, Excel, longitudinal force due to shear, Python, PyXLL, py_UMom, RC Design Functions, VBA
1 Comment
Counting words in a list and dictionary links
This post presents two methods for extracting all the different words from a list and counting the number of occurrences of each word. The spreadsheet, including full open-source VBA code, can be downloaded from: CountWords.zip As an example, I have … Continue reading
Posted in Excel, UDFs, VBA
Tagged Count words, Countif function, Excel, Extract unique words, scripting dictionaries, UDF, Unique function, VBA
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
2 Comments