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

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

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.

No more war no more war no more war

Permalink: http://paul.us2uk.eu/?x=entry:entry170620-013718

This is the original version of the song which helped make a star out of Sade:

Timmy Thomas - Why Can’t We Live Together

Where are all the protest songs now.. and I mean protests about the real stuff going down in this world, and the real causes?

Hint: it’s not Donald Trump, muslims, or “equality”. It is however agenda-driven and media-led… whether those sock puppets who masquerade as journalists know it or not.

Eleven years ago

Permalink: http://paul.us2uk.eu/?x=entry:entry170618-132536

Duke Gildenberg was on television…

Duke Gildenberg on British TV 10th June 2006 at 18:37 GMT

So, why was Mr Gildenberg on TV? Where does he fit in to world history?

image When Joe Kittinger made his world-record jump from 102,800 feet on Aug. 16, 1960, as part of Project Excelsior, launch couldn’t even take place until one man gave thumbs up. “Our forecasts were provided by one of the best meteorologists in the Air Force…: Bernard ‘Duke’ Gildenberg,” Kittinger wrote in “Come Up and Get Me” (UNM Press/2010, with Craig Ryan). “If Duke said go, you went, or you’d wonder why you hadn’t.”

http://www.spacesafetymagazine.com/aerospace-engineering/red-bull-stratos/balloon-go-no-go-gildenbergs-call-part-1/

Bernard David Gildenberg or “Duke,” as he was known in New Mexico and at NASA, was born in Hazelton, Pa., in 1925. He was brought up in Brooklyn, N.Y., and had lived in La Luz and Tularosa for the last 60 years of his life. He was a graduate of New York University and was in the Air Force during World War II, stationed in the Aleutian Islands in Alaska.

Mr Gildenberg died on the 2nd April, 2013, of natural causes.

Food Mixer and Back Door - June 2006

3D - Here come the pirates!

Permalink: http://paul.us2uk.eu/?x=entry:entry170617-212815

image

How to make a Facebook Cover VIDEO

Permalink: http://paul.us2uk.eu/?x=entry:entry170616-010936

For the lucky few (guinea pigs) Facebook have enabled a feature which allows users to upload a video to be used instead of a regular (static) cover photo.

This feature is still very much in its infancy but it was worthy of a little bit of experimentation, so this is how I created a short video animation for the Darlington FC Supporters Group Facebook page. [Read More…]

The earth moved for me last night…

Permalink: http://paul.us2uk.eu/?x=entry:entry170608-064346

…and a few other people in the office said they also felt the little earthquake which hit Georgia last night.

Not much to report - it caused a few things we had hanging up on the wall to rock to and fro for a while afterwards - but if you weren’t looking at them you’d probably miss them. My Darlo bottle opener makes for a great earthquake detector!

https://www.emsc-csem.org/Earthquake/earthquake.php?id=596947

A Spring Storm in Tbilisi

Permalink: http://paul.us2uk.eu/?x=entry:entry170519-174209

It just got very very dark outside my office, with a fair bit of lightning.

I took about 150 photos and this was the best I could do!

A Spring Storm in Tbilisi

How to create an alphabetical list in Excel

Permalink: http://paul.us2uk.eu/?x=entry:entry170331-151659

There didn’t seem to be a way to create a custom list in Excel which would allow you to put letters of the alphabet down one column (unless you typed one in by hand for however many letters you want to go down to) so here’s a formula I dreamt up to do just that.

=SUBSTITUTE(ADDRESS(ROW(),COLUMN()+ROW()-COLUMN(),4),ROW(),”")

This will work in any column and will keep incrementing the lettering well past “Z” (which is a limitation of some other formulae I found to do the same job).

My formula will only work if you start the sequence in the first row because it works by setting the column number as the current row number - so row 1 will be “A”, row 26 will be “Z”, row 5000 will be “GJH”, and so on.

If you need to start your list in any row other than row 1 then you’ll either need to adapt the formula somehow (good luck with that - but please let me know if you have any success) or simply create a list starting in row 1 on a new blank worksheet then the list and paste it as values (so you just get A, B, C, etc. instead of the formula) in the cell where you want your list to start. The keyboard shortcut I use to paste values is Alt-E,S,V., or you can do it the standard way - see the help section for your version of Excel for instructions if you get stuck.

The beauty of this is that the exact same fomula work in any cell and in any column.

image

Formulae for Roots & Powers in Excel

Permalink: http://paul.us2uk.eu/?x=entry:entry170304-003048

If you’ve ever wondered what the little “hat” symbol (^) is for, generally above the number 6 on your keyboard, then your further enlightenment is at hand.

It has a number of uses, for instance you can use ^p in the search & replace function in MS Word to find and replace paragraph markers - useful when you need to remove extraneous line breaks when you paste a block of text in which doesn’t format correctly.

However the ^ symbol in Excel is used to denote powers so, if you want to find the square or cube of a number, rather than use the more cumbersome POWER worksheet function you can just use n^2 or n^3 to find the square or cube of a number.

Here’s how to use that in a formula. [Read More…]

Oil does not come from dead trees (or dinosaurs)

Permalink: http://paul.us2uk.eu/?x=entry:entry170303-215520

You don’t believe me?

Well how do you explain the fact that Saturn’s largest moon, Titan, holds more oil & gas than all the known reserves of the Earth?

http://www.space.com … titan-oil-earth.html

There’s a lot to be said for the idea that the earth’s oil pockets are self-replenishing. It wouldn’t do a great deal for the price of oil if word got out that there are trillions of gallons of the stuff sloshing about way down deep in the Earth’s mantle, ready to slowly seep back up and fill the voids which we’ve so far managed to suck dry.

We’re NOT running out of oil folks!

Give anonymously

Permalink: http://paul.us2uk.eu/?x=entry:entry170201-175934

imageI put it to you that the main reason people give to charity is to boost their own ego. We all know their type “does a lot of good work for cherridy and don’t like to talk about it (but want everyone to know about it, otherwise… what’s the point?).

If you see someone who needs help, and you can help, do it! No need to make a song and dance about it, and it feels much better.

Fate

Permalink: http://paul.us2uk.eu/?x=entry:entry170131-133010

View from my new office…

View from my office

Hardly identical to one of my favourite Van Gogh paintings, but at least I’ve got some cypress trees in there.

Wheat Field With Cypresses, 1889 by Van Gogh

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

For Once in my Life (Extended Version) - Stevie Wonder

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

Knife… Fork… Sparklers

Permalink: http://paul.us2uk.eu/?x=entry:entry170103-111707

Happy New Year! S Novim Godam! I hope for world peace in 2017 (not that we’ll ever get it in my lifetime but, as the song goes, “things can only get better”.

Knife... Fork... Sparklers

Want one!

Permalink: http://paul.us2uk.eu/?x=entry:entry161229-004337

A South Korean company has unveiled a prototype for the world’s first manned, two-legged robot. It’s 4m High!

When it came up with “Potential uses” on the video I thought the first one should be to fight other 4m high robots!

I wonder when we’ll ever see the first manned walking robot on the moon?

http://www.bbc.com/news/technology-38442672

image

An automatic house

Permalink: http://paul.us2uk.eu/?x=entry:entry161228-213245

There was an interesting article on the BBC website today about a guy who has turned his home into one which watches who is in the building and alerts the owner if there is someone there which it doesn’t recognise. It also adjusts the heating etc. if someone turns up who prefers the house a little warmer or cooler, and the developer expects to be able to expand his system to allow him to “talk” to the house and just issue whatever commands he wants.

http://www.bbc.com/news/technology-38261690

It may all sound a bit geeky and even a bit sinister from a privacy point of view, but this is exactly the kind of system which I am surprised hasn’t been developed by a big company such as Amazon or Google because it could open up the possibility of affording a much greater degree of independence for disabled people.

Couple this with a few robots for specialist operations such as getting someone in and out of bed, or to the bathroom, and it would be just brilliant for someone like Georgi to be able to live more or less on his own, yet still be monitored in case he needs help with something.

What the world needs now...

3D Coaster Plate

Permalink: http://paul.us2uk.eu/?x=entry:entry161226-170824

It works for me!

image

Cures ALL Windows problems since Vista

Permalink: http://paul.us2uk.eu/?x=entry:entry161224-201602

winxpsp3packaging.jpg

Just saying…

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.