Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Downloads by category
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Section Properties of Defined Shapes - Spreadsheet
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
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
1 Comment
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