Author Archives: dougaj4

International Keyboard Shortcut Day

Posted on 07/11/2019 by dougaj4

Daily Dose of Excel is increasingly inaccurately named these days, but it still contains a wealth of information, and we get a new post on special occasions, such as: International Keyboard Shortcut Day Have a look for all the keyboard … Continue reading →

Posted in Computing - general | Tagged , | Leave a comment

Two Assasinations

Posted on 29/10/2019 by dougaj4

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 →

Posted in Bach | Tagged , , | Leave a comment

More powers of 3

Posted on 20/10/2019 by dougaj4

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 , , , , , | Leave a comment

Restoring sound on an HP computer.

Posted on 13/10/2019 by dougaj4

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 , , , | Leave a comment

A problem with integers in VBA

Posted on 01/10/2019 by dougaj4

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 →

Posted in Excel, UDFs, VBA | Tagged , , , | Leave a comment