Author Archives: dougaj4

Filling Blanks with Go To-Special (and local help rant)

Posted on 10/08/2015 by dougaj4

Recently a thread at the Eng-Tips forum prompted me to look for help on the Go To-Special function in Excel.  Pressing F5-Alt S, then clicking the help icon in the dialog box brought up: It seems that the offline help … Continue reading →

Posted in Excel, VBA | Tagged , , , , , , | 13 Comments

Installing Windows 10 …

Posted on 03/08/2015 by dougaj4

… did not go well. After installing over night it needed another half hour or so to “just finish off a few things”, after which it briefly displayed the desktop, followed by a message saying that it was going to … Continue reading →

Posted in Computing - general | Tagged , , , | 2 Comments

Indexing pdf content

Posted on 30/07/2015 by dougaj4

I recently discovered that my 64 bit Windows 8.1 Search was not indexing the content of pdf files.  Since searching the content of pdf files is just about the only thing I want to do with a desktop search tool, … Continue reading →

Posted in Computing - general | Tagged , , , | 2 Comments

Solvers, parsers and more

Posted on 18/07/2015 by dougaj4

Links to some really useful recently discovered sites: OpenSolver for Excel OpenSolver is an Excel VBA add-in that extends Excel’s built-in Solver with more powerful solvers. It is developed and maintained by Andrew Mason and students at the Engineering Science … Continue reading →

Posted in Excel | Tagged , , , , | 3 Comments

A mystery curve links to Jupyter

Posted on 16/07/2015 by dougaj4

Reviewing some of my less visited links recently, I was intrigued by a post at The Math Less Travelled: The previous post at the site provides more details of the source of the curve, and some links to an interactive … Continue reading →

Posted in Charts, Charts, Excel, Maths, Newton | Tagged , , , , , , | 2 Comments