Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Contour plots with Excel and Matplotlib
- Cubic Splines
- Brent's Method; Update and Examples
Recent Comments
mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd… metroxx on Composite Beam Spreadsheet Upd…
Category Archives: Computing – general
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
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
Getting Excel Solver working
Recently I found that for unknown reasons the Excel Solver add-in was not working. Opening the add-ins list from the Devloper tab showed that it had become deactivated (also accessible from File-Options-Add-ins): Clicking the Solver check box returned a message … Continue reading
Posted in Computing - general, Excel
Tagged Excel, Office 365, Solver add-in, Solver disabled
Leave a comment
Free and Simple Tools for Editing Videos
I recently needed to extract 15 minutes from a 45 minute long video, in 5 separate clips. I discovered that there are free tools to do this simply and efficiently, although they are not widely advertised. Here’s how: By default, … Continue reading
Posted in Bach, Computing - general, Newton
Tagged Adobe Merge Videos, Film&TV, Photos, Trim videos
2 Comments
Clearing OneDrive download files in Android
I recently found that downloaded files on OneDrive on my Android pad had almost filled my storage space to capacity, and that the procedure to delete them was not at all obvious. I eventually found a link with detailed instructions … Continue reading