Category: Uncategorized
-
Amazing infrared thermometer for £8
I bought an infrared thermometer to diagnose my central heating system but for £8 it is great for anyone who is interested in physics. It measures the infrared that that is emitted from a surface to get the temperature. Different surfaces emit different amounts of infrared. To promote getting an accurate reading I stuck a…
-
Windows 10 Creators Update: How to turn off focused inbox
If there is one thing that is guaranteed to make me fume with anger it is vendors mucking about with my email. I think that ordinary home users should use Office 365 and Microsoft email services. Outlook.com offers you a free mail account with an *@outlook.com address. You can also use it with other addresses…
-
Using Excel 2016 to unpivot data
Normal people, by which I mean those who don’t process data all day will often create data that is present in a crosstab table. This is a poor structure for storing and processing information. We say that its “denormalised” because the three different columns “Europe”, “USA”, “Asia” contain information of the same type – “budget…
-
Create the Union of two tables in Excel revisited
In 2013 I published a technique to create the union of two tables in Excel. This post is still very popular and so I am revisiting this topic. Excel 2016 (and possibly Excel 2013 but I have not tested) has this capability built-in and the new method should always be preferred to the one that…
-
Understanding Formidable Forms and WordPress
I have been using Formidable Forms with WordPress on and off for about 3 years. I have a conventional SQL and web programming background and I have found understanding the Formidable framework difficult. Today I had the insight that Formidable “views” are really just HTML fragments that contain data fetched by a simple SQL statement working…
-
How should a user manage their passwords?
I was recently asked how a user should manage their passwords. This is a tricky topic and I have avoided biting the bullet until now but here goes, Considerations It is very important that user do not lose access to important passwords by forgetting them or losing access. Users are often the weakest link in…
-
New year – annual backups
If, dear reader, you have been following my advice on backups then you will, be using OneDrive to sync your Documents to the cloud. This gives you a real-time copy of everything in case you use your laptop and the ability to access documents from many devices. be using File History with a big NAS…
-
Configuring “connected accounts” in new Outlook.com
In the old Outlook.com you would configure your business email address like myname @ mydomain.com to forward emails to your Outlook.com account and as a “send only” account so you could send emails from that address. After the forced migration to the new Outlook.com this feature has been removed. The only way to send emails…
-
Windows 10 Parental Controls don’t work
I have been testing Windows 10 parental controls and they simply don’t work. Many others have this experience. http://answers.microsoft.com/en-us/windows/forum/windows_10-security/windows-10-family-safety-screen-time-limits-not/57689ce1-6638-4d44-8f2f-9af82138375c They simply do not reliably impose screen time limits and in some cases do not even successfully filter porn. A limitation (not a bug) is that filtering only works with IE and Edge so you must…
-
Humour: How to write a Haiku
Counting syllables seventeen is not enough eighteen would be bet A haiku is a Japanese poem with lines of 5, 7, 5 syllables, 17 in total with thanks to Chlemtil
Dr James Bayley 