Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Latex Maths Text in Excel
- Time in hours and minutes between two dates
- LU Decomposition with Python and Scipy
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- The history of the theory of beam bending - Part 1
- Cubic Splines
- Contour plots with Excel and Matplotlib
- Stereograms
Recent Comments
Tag 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
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
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
Two views on VBA
First from Microsoft: Microsoft are continuing their quest to make downloading spreadsheets with macros ever more difficult, and now any downloaded spreadsheet has VBA code disabled by default. Unblocking the code (if you know and trust the source of the … Continue reading