Poll

Aboot this blog

This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:

feed-icon-28x28.png

DISCLAIMER

Please note that any reviews/recommendations are based solely on my own experience and does not constitute a guarantee that you will have the same experience. Please do your own research before parting with any money - the risk is all yours!

The Briticiser

Looking for my world famous US to GB English spelling converter?

THE “BRITICIZSER”

www.us2uk.eu

IT’S HERE

Tags

  Bits and Bobs     Family     Bookmarks     Acrobat     Flatpress     VBA     News     Education     Windows     Browsers     Reviews     Plausible Lies     Tutorials     Utilities     Hardware     Software     Overcoming Disabilities     PHP     Odds and Sods     Excel     Word     Equipment      

Find me on Facebook

facebook-icon-28x28.pngVisit my Briticiser Facebook Page to keep up with things here - lots of reviews of stuff I’ve really used and also all kinds of helpful computer tips with a heavy bias towards SAVING YOU TIME.

The fish were looking at me - Stanley Oliver

Permalink: http://paul.us2uk.eu/?x=entry:entry170128-203107

They had that look that said…

“We can see that you’re sat over there with nothing to do…

so how about giving us our food a little earlier tonight?”,

and do I did

Stanley Oliver 1828

The Collected Works of Stanley Oliver - The Partridge Press 1945

Do trees shiver? by Stanley Oliver

Permalink: http://paul.us2uk.eu/?x=entry:entry170128-200900

It seems odd that trees, if you observe them closely, only sporadically drop their leaves, and do so in unison with all the other trees around them… almost in symphony with one another - even when there is no wind at all.

Perhaps some highly expensive apparatus could detect, record, and analyse the precise barometric and climatic conditions in fine enough detail in order to determine any correlation with the trees dropping their leaves.

If not, then there is something else going on.

Stanley Oliver 1841

The Collected Works of Stanley Oliver - The Partridge Press 1945

I was awake - Stanley Oliver

Permalink: http://paul.us2uk.eu/?x=entry:entry170128-184325

The rain fell lightly, but steadily, all through the night.

In its wake the road to the headland took on a sheen of sheer silver.

It was then, I knew, I was awake.

Stanley Oliver 1823

The Collected Works of Stanley Oliver - The Partridge Press 1945

Excel Functions - Version Compatibility

Permalink: http://paul.us2uk.eu/?x=entry:entry161117-162809

While working on a spreadsheet today I was using the ISERROR function to test if a VLOOKUP formula returned a value and, if it did, return the value otherwise display nothing - instead of the usual #N/A error notification.

The usual syntax for this formula begins “=IF(ISERROR(VLOOKUP(…”.

I happened to notice that Excel 2010 (the version I use at work) offered up “IFERROR” as a possible function as soon as I typed the “IF” and, indeed, this allows me to write slightly shorter formula. However this is not backwards compatible with Excel 2003 which I use elsewhere so I avoided using it.

For anyone faced with a situation where they have a spreadsheet containing lots of instances where the a formula contains “IFERROR” then help is at hand at the following link - untested, but I’m sure it’ll work. I’ve bookmarked it here because it looks like quite a useful site.

http://www.professionalexcel.com/2011/06/replace-iferror-with-ifiserror/

There are obviously a few more functions which were added in later versions of Excel which you should avoid using if you don’t want your spreadsheet to fail when someone opens it in Excel 2003 (which I much prefer!). The other one I avoid for this reason is “SUMIFS” (I use “SUMPRODUCT” instead) but here’s a useful list of all Excel functions showing which versions they are compatible with - plus a useful description of each..

https://docs.google.com/spreadsheets/d/1ztUAhgAghKn2wNih7-QgMbSAKfux4w_qkAcJdD82bLU/edit

Here’s the same thing downloaded for posterity as an XLSX file

Fix for Windows 10 Can’t Connect To This Network

Permalink: http://paul.us2uk.eu/?x=entry:entry161025-233719

The solution to this extremely annoying recurring problem which worked for me was this:

[Read More…]

Dad’s Army Story - Victoria Wood

Permalink: http://paul.us2uk.eu/?x=entry:entry160425-005228

Dad’s Army Story

I don’t know Jack

Permalink: http://paul.us2uk.eu/?x=entry:entry160415-143737

David Lynch funded this documentary about the star of possibly the strangest, most intensly photographed film I’ve ever seen.

https://www.youtube.com/watch?v=-cSZvOyZNtU

A documentary about Jack Nance, star of the David Lynch film “Eraserhead”

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.

Support our caregiving

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.