Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Latex Maths Text in Excel
- XLDennis, the MSDN Library, and VBA rant
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Retrieving unique values from a range or array ...
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel
- Beam actions and deflections by Macaulay's Method
- Downloads
Recent Comments
Category Archives: Newton
More long numbers with Python
In A not so easy problem I looked at using Python with Excel (via pyxll) to work with very long integers, using the MPMath package. For high precision calculations involving decimal values MPMath is required, but for simple operations entirely … Continue reading
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
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