Skip to main content

OnePlus 5

I’m very much looking forward to the arrival of my new OnePlus 5 phone.

I’ve been a OnePlus fan for a while now, having migrated from using the Nexus phones. I like to have a high-spec phone, but don’t like paying the premium prices that the likes of Samsung and Apple demand.

I used to have a OnePlus 1 and currently use a OnePlus 3 (my wife has the OnePlus 3T as well), but about 2 weeks after a bought by OnePlus 3 I managed to put a huge scratch across its face – and I’ve been looking at that scratch for about a year now. It wasn’t bad enough to warrant buying a replacement OnePlus 3, but now that the OnePlus 5 is out I have the excuse to upgrade handsets.

If you’re planning to buy one yourself, you might be interested in this referral code that will get you €20 off accessories when you buy a OnePlus 5. Here’s the link: https://oneplus.net/ie/invite#W5ZGN6VN63274F

Working on more than one Excel spreadsheet

Microsoft Excel by default opens all spreadsheets into the same Workspace, so it can be tricky if you want to work on multiple spreadsheets at the same time.

If you’re copying information between two spreadsheets, or want to compare data from two different sources, then it can be tricky to do. You might have experienced the problem of having to flick back and forth between two spreadsheets.

One way around it is to use the View Side by Side option:

  • Open the two spreadsheets you want to work upon
  • Select the View tab
  • Click on View Side by Side
  • To switch between the spreadsheets being on top of each other or side by side, click on Arrange All and select Horizontal or Vertical

It will look something like this:

However, that’s still not much use if you have two monitors, and want to have a separate spreadsheet in each monitor, because a maximised Excel worksheet only works in one monitor.

What you need is to start up two separate instances of Excel, and then each instance can be maximised on separate monitors. The first instance of Excel loads in the normal way, and you open your first spreadsheet in that. The second instance of Excel can be started by holding down the shift key as you click on the Excel icon (either from the Start menu or Taskbar). A separate blank Excel worksheet will launch (it’s actually a second instance of the Excel program running) and you can load your second spreadsheet into that.

These separate instances run completely independently of each other, and one can be closed (or even killed in the Task Manager) without affecting the other.

Is Ireland facing a transportation crisis?

It seems that not a week goes by these days without another news story about our transportation network.

A few weeks ago we had a three-week strike by Bus Eireann drivers. Over the last few days there was a call for increased road capacity on the N11 as it is so severely congested, and at the same time four people die every day in Ireland as a result of air pollution, about half of which is attributed to traffic emissions.

Certainly there’s a problem with transportation in this country, particularly in our cities. Our over-reliance on cars to get about is only going to get worse over time. Particularly when 44% have a perception that public transport is difficult to use.

The answer is definitely not to build more roads. That’s not going to ease congestion or reduce pollution – it will just encourage more people to drive, and make the situation worse. The only answer is to get people out of their cars, and get them using more sustainable transport options – public transport, cycling and walking.

But how do you convince people to leave the car at home?

We need a mind-shift in Ireland. We need a change in attitude amongst the people that this needs to be tackled. And we need to decide, once and for all, whether we want a properly-funded and sustainable transport network.

That means putting proper investment into trains, busses (including Bus Eireann), trams, cycle lanes, and footpaths – to make our cities into places where its safe and easy to get about without a car. It’s only then, once we’ve made the investment, that people will finally (and willingly) leave their cars behind and we will see lasting reductions in congestion and pollution.

Unfortunately the political will at the moment seems to be leaning in a different direction. Instead of the carrot approach of making sustainable travel appealing, they are making noises about the stick approach of increasing taxation on diesel cars – through increasing fuel duties and tolls. These are the same diesel cars that the government of 10-15 years ago were trying to persuade people to buy, in order to reduce CO2 emissions.

Vodafone Ireland Red Roaming APN

I was using Vodafone Ireland for roaming data while I’m visiting the USA, but was concerned to see my prepay credit being eaten up incredibly quickly.

The Red Roaming plan is meant to give me 200MB of data a day for €2.99, but after only using about 5MB of data and sending a couple of texts my €25 of credit was gone!

I checked the Vodafone terms and conditions and found out that the 200MB allowance is only available on the “Live” and “Blackberry” APNs. My phone was set to use the “ISP” APN (isp.vodafone.ie) and as such was being charged something like €6 per MB.

Be sure to have the correct APN selected, or it could cost you!

I’ve changed the APN to now use the “Live” APN (live.vodafone.ie) and my credit isn’t disappearing as before.

Use your domain for email too!

It never fails to amaze me how, when small businesses go to all the effort of registering a domain name and creating a web site, that they don’t use that domain for their email.

I seem to see it all the time – mostly on the side of vans, and sometimes on invoices and other documentation – whereby the email address looks so amateurish because they’re using a gmail address or similar.

It’s probably not the fault of the small businesses themselves, as they’re not internet specialists. But the people that sell them a web site are really letting the side down by not encouraging them to use their domain for an email address – even if it just forwards straight on to their gmail account!

After all the email address of john@amazingdecorators.ie is much more professional looking that johnsmithpainter@gmail.com.