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

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

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.

Cropping & converting MP4 Files to other video formats

Permalink: http://paul.us2uk.eu/?x=entry:entry170715-125101

I recently had a small success which made me go “yeh!” and I happened to find this neat intro to a 1960 western serial featuring my name which kind of summed up how I was feeling at the time :D

Download video: MP4 format | Ogg format | WebM format

The problem was that I could only download the full episode in MP4 format so I needed to crop the video just to get the intro into a much smaller file.

Not being one for downloading over-hyped and bloated software I remembered I had a very good little MP4 Joiner (to stitch mp4 files together) on my computer so went looking to see if they had a splitter too - and so they did:

http://www.mp4joiner.org/en/

The joiner and the splitter are now bundled together in one installation file called Mp4Tools, but they work great and are simplicity itself to work out how to use them.

Just one word of warning - while the latest file you can download at the above link installs and works just fine I did have a problem opening the splitter application when I tried to install it on my old Windows XP computer, so I installed the older version 3.0 of the software on that machine, and that worked without a hitch.

In case you have any trouble running the latest version of the sofware you can find the older versions here. Just choose the version 3.0 EXE file and you should be ok:

https://www.videohelp.com/software/MP4Joiner/old-versions

Now that I have the intro of my video nicely cropped I can either make and animated GIF of it or share it on the web, as I’ve done here, but I needed to convert it to a couple of extra formats in order to ensure that the video played in as many browsers as possible.

The formats I needed were .webm and .ogv (OGG format), and instructions for embedding the videos after first uploading the files to your web space can be found here:

http://camendesign.com/code/video_for_everybody

However, you don’t need to really understand how to do this as you can save much time by using the handy code generator which they’ve provided here:

http://v4e.thewikies.com/

In order to covert my MP4 file into these 2 formats I used the following online converter which was quick and very easy to use:

http://video.online-convert.com/

The above website has converters for all sorts of different types of file (e.g. Office documents too), so it’s well worth bookmarking.

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.