Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel
- Daily Download 5: Frame Analysis
- Downloads by category
- Writing Arrays to the worksheet - VBA function
Recent Comments
Author Archives: dougaj4
Two Assasinations
In 1975 John Fahey released an LP including the track “The Assassination of Stefan Grossman”: Stefan Grossman responded in the only way possible, with the assassination of John Fahey: Why John Fahey chose to assassinate Stefan Grossman in the first … Continue reading
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