### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- The angle between two vectors, Python version
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Cubic Splines
- Downloads
- Frame Analysis with Excel 1 - Single beam
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Frame Analysis with Excel - 4, 2D frame analysis

### Recent Comments

dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho… dougaj4 on P-Y Curve function Zhitong Zhang on P-Y Curve function Matt Cornell on Newton’s Cradle Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin… Roulior Halder on Excel to Alglib via xlwin… dougaj4 on Excel to Alglib via xlwin… dougaj4 on Excel to Alglib via xlwin…

# Author Archives: dougaj4

## More powers of 3

Following the discovery of a question to which the answer is 42, the same team has now reported a sum of three cubes equal to 3. As before, the result can be checked from Excel, linking to mpmath, via pyxll. … Continue reading

Posted in Computing - general, Excel, Link to Python, Maths, Newton, PyXLL
Tagged 42, Excel, Life the Universe and Everything, mpmath, PyXLL, sum of 3 cubes
Leave a comment

## Restoring sound on an HP computer.

Yesterday the sound on my HP Omen computer stopped working for no apparent reason. I found the video below, which fixed the problem: The video is short, easy to follow, and doesn’t need the sound working to understand it! The … Continue reading

Posted in Computing - general
Tagged Device Manager, HP Sound problem, Realtek Audio, Restore sound
Leave a comment

## A problem with integers in VBA

A recent question at Quora asked: “Why am I getting an overflow error in Excel VBA when doing a simple arithmetic calculation like str1 = 24*60*30 where str1 is a variant or long or double?” I hadn’t encountered that problem … Continue reading

## Indexing pdf files, yet again

Recent versions of Windows have provided indexing of file contents that allows for fast searches over the entire contents of your hard disk. This includes pdf files, but the default filter file only works with 32 bit Windows. It is … Continue reading

## The answer to Life the Universe and Everything …

is 42, as is well-known: The actual question, to which the answer is 42, is not known, but a lesser known long standing question involving this number has recently been solved: The original problem, set in 1954 at the University … Continue reading

Posted in Computing - general, Excel, Maths, Newton, PyXLL
Tagged 42, Excel, Life the Universe and Everything, mpmath, PyXLL
5 Comments

## Plotting Mandelbrot

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA
Tagged Charts, Excel, Mandelbrot Set, VBA
3 Comments

## Using conditional formatting with array formulas

A recent Quora question asked “How do I highlight the number closest to an initial number in a row in Excel?“. The answer by Bill Jelen provides a good example of using conditional formatting with an array formula: In my … Continue reading

Posted in Arrays, Excel
Tagged Array Formula, conditional formatting, Excel, Office Insider
Leave a comment