Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Retrieving unique values from a range or array ...
- Latex Maths Text in Excel
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Automatic download of csv files
- Cubic Splines
- Contour plots with Excel and Matplotlib
- 3D Matplotlib Plots in Excel
- Downloads by category
Recent Comments
Category Archives: Concrete
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
ULS Design Functions – Python version
I have now converted my ULS Design Functions spreadsheet (last presented here) to Python. The new spreadsheet and open source Python code can be downloaded from: py_ULS Design Functions The spreadsheet has the same functionality as the VBA version, providing … Continue reading
ULS Design Functions 2.16
The ULS Design Spreadsheet has now been updated to Version 2.16, which can be downloaded from: ULS Design Functions The main new feature is the option to design for prestress loads applied to circular tanks. Due to axi-symmetric effects, when … Continue reading
Secondary moments in prestressed beams with FEA
Secondary (or hyperstatic) bending moments occur in prestressed beams that are continuous over internal supports, or have other redundant support conditions. Any eccentric prestress force will cause a beam to deflect, and if these deflections are restrained at internal supports, … Continue reading