Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Filling Blanks with Go To-Special (and local help rant)
- Automating chart scale limits - update
- Frame Analysis with Excel 1 - Single beam
- Installing Python, Scipy and Pyxll
- Bridges over the Tiber - 1
Recent Comments
Author Archives: dougaj4
Downloads update
A list of files available for free download can be found under the Downloads link at the top of the page: The list has now been updated and there are now 189 files available for download, most with open source … Continue reading
Posted in Computing - general, Excel
Tagged Download list, Files for download, open source code, Python, PyXLL, VBA, xlwings
Leave a comment
A not so easy problem
A seemingly simple problem was posted in my Quora feed: or to put it more mathematically, what three positive integers satisfy the equation: It turns out the answer is not so simple. A full and detailed derivation can be found … Continue reading
Displaying You-tube transcripts
This is probably widely known, but I only found out this week. I find You-tube informative videos frustrating because you have to sit through 10-20 minutes of video to get maybe 1-2 minutes worth of information. If only you could … 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-2
Following the first post in this series, this post compares friction losses in prestressing cables as defined in the Australian Concrete Structures Code (AS 3600), compared with a cable modelled with contact elements in Strand7. The example used is based … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7
Tagged contact elements, Excel, FEA, Friction losses, prestressing, sticking friction stiffness, Strand7
1 Comment