Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- Downloads
- Linking Excel to C - 2
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Author Archives: dougaj4
Dreamers’ Circus
Dreamers’ Circus is a Danish folk/indie band who have been around since 2009, but I have only just discovered them. Here is an example of their work, featuring the clog fiddle: “About the clog-fiddle: You take an old clog shoe, … Continue reading
Microsoft blocking VBA in downloaded files (or do they?)
Microsoft announced earlier this year that they would be automatically blocking macros in downloaded Office files (as a security measure), then recently they said they wouldn’t, then yesterday they said they would, but not right now. For more details, plus … Continue reading
Posted in Computing - general, Excel, UDFs, VBA
Tagged download security, Security certificate, VBA macro block
1 Comment
Two new old live recordings
Two recordings of live concerts recently found on You Tube: Sandy Denny singing Blackwaterside (BBC In Concert – Paris Theatre 16/3/72) : The Pentangle, three songs recorded in Australia in August 1972:
Posted in Bach
Tagged Blackwaterside, Light Flight, live recordings, Pentangle, Reflection, Sandy Denny, Solomon's Seal
Leave a comment
Installing PyPardiso and speed of Scipy spsolve
I recently upgraded to Python 3.10, and because of some problems with my previous installation I decided to do a complete new installation using pip, which required installation of all the libraries needed for my various programs. For my linear … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, PyPardiso, Python, PyXLL, SciPy, sparse matrices, sparse solvers
4 Comments
Removing Add-ins
Recently I had problems with an Excel Add-in that was still trying to run, and generating error messages, even after being removed from the add-in list and uninstalled. After much searching and trying suggested methods that didn’t work, I finally … Continue reading
Posted in Computing - general, Excel, Link to dll, Link to Python, VBA
Tagged Add-in problems, Excel, Link to Python, Regedit, Remove add-ins, VBA, Windows registry
Leave a comment