For a while now I’ve been looking for a simple way to have a spreadsheet look up a lie currency exchange rate. The various solutions offered included writing scripts to go and get the live values… but try as I might I couldn’t get Apple Numbers to work with this. As a result, I’ve been manually looking up the current rate and typing it manually into a cell that all other cells reference. It works, but it’s a bit manual and clunky.
It turns out I had the solution all along – it’s built in to Numbers, but isn’t obvious (at least not to me!)
All you do is click into a cell and enter a formula, so just choose your cell and type the ‘=’ sign to bring up the formula entry. Now type CURRENCY
(yes, it’s really that obvious)
There are three components to enter – the currency you want to convert from, the currency you wnat to convert to, and the price of that currency. The last part is what you will get dynamically.
Firstly, you need to know the currency codes for your conversion. For example, if you want to know how many US dollars there are to one GB Pound, you’d need to know the currency code for Sterling is GBP and for the dollar is USD. These are the first two things to type, and you have to add quote marks around both:
CURRENCY(“GBP”,”USD”,0)
The third thing is the zero at the end. This forces Apple Numbers to look up the current price. In the formula editor you can see a drop down list of possible values to use instead of zero, such as the name, or the current change in rate.. or the highs, lows and so on.
What you should get back, after a very slight pause when you enter the formula, is the cell showing you the current exchange rate (At the time of writing, this returned $1.31)
This is a really useful feature if you are trading in different currencies and need to do some basic calculations. Keep in mind that whilst this looks up the live rate, it is not the rate a bank will offer you! Use it as a guide… if you want to check it, go to https://xe.com and see what they say there. It’ll be pretty close!
You know that annoying moment when you have downloaded an application – perfectly legally – from an ‘unidentified developer’ and your Mac decides you are not allowed to run it? Well that is pants! I realise Apple are only trying to protect you from the evils of the universe, but it really ticks me off that I don’t get an option to ‘open anyway’ right there and then. No… instead I need to go to system preferences and enable it, or right click the app icon to start with. This is just too tedious. It’s a feature called ‘Gatekeeper’, and it really is there to prevent malicious code being run on your machine.
In previous versions of OSX it was possible in System preferences to allow apps from ‘Anywhere’ to open, but in more recent versions that has ben taken away. Apparently we are not allowed to play with ‘Anything’ – only those from the App store or ‘identified’ developers (i.e. anyone who distributes through the App store).
OK – once again I get the need to protect us from our own stupidity, but it is taking it a little far, IMO.
So for all you geeks who want to return the option in system prefs to allow apps from ‘Anywhere’ just follow these steps:
Quit system prefs if it is running
Launch a terminal window
type this:
sudo spctl --master-disable
Then enter your password.
that’s it – job done. Now you can open system preferences and see the welcome return of ‘Anywhere’ in your Gatekeeper panel.
OK – so the headline is a little dramatic, but that’s exactly what I did.
My lovely Audi A5 had a service (and there’s nothing I like more than parting with £400 for that) and when they checked the car they found the tyres were worn low – nothing too remarkable in that, except I had already spotted it and resolved to fix them anyway. After I dropped the car off, I spoke to my colleague Matthew who pointed out that tyres from main dealers were over priced. I know that, you know that… we all know that, but what are the alternatives?
Sitting in the waiting area for any of the main car fitters is at best a roundly depressing experience. It takes forever, there are many cars to deal with and yours is never front of the queue. Even if you book a time slot. It takes two hours minimum, and often quite a lot more. Plus the waiting areas themselves – so depressing, filled with car magazines and tool adverts, with a broken TV and occasionally a spluttering coffee machine. Hardly a dynamic place to while away a few hours! Not even some decent wifi to get online with… you get the idea.
Matt then said – “tyres on your drive”
Not too sure if that was a cryptic message, referring to my car as ‘my drive’… he then said “google it”. Ever talkative, is Matt!
http://www.tyresonthedrive.com/
Aha – so that’s what he meant!
Finding the right tyre size was easy, and the price to fit them was a steep (that’s what you get when you drive premium cars and stuff) £149 each. I needed two. Sigh.
Around an hour later, the garage phoned and said the car was ready, and that it needed two new tyres (no surprise there). I asked how much it would cost them to fit them, to which I was told “we can do it all in for 199 per wheel”.
I went to pick up the car – all spick and span, freshly serviced and valeted, and they tried again:
Him: “Y’know – we can do those tyres for you right now”
Me: “no, it’s OK – I know they are low – I’ll get them done myself… much as I enjoy giving you guys my money, your price is too high”
Him: “We do price match y’know..”
Me, after getting the website on my phone, and getting the tyre deal in plain view: “Can you match this?”
Him, looking very concerned: “Err… no, we… er… can’t match that. I thought you meant like one of the high street fitters…”
Me: “no, I meant these guys, a hundred pounds cheaper than you!”
Him: silemce…
So a quick call to the firm and a booking later, and before you know it Daniel was ringing me saying he was in the car park at my office, ready to start fitting tyres. What a decent young man he was too – great to talk with about what needed doing, no mystery, jargon or techie babble… and he said he’d call me when it was done.
30 minutes later – I kid you not, I had not had enough time to go in to the office, make a coffee and finish it before he was back on the phone – 30 minutes later it was done.
The price? £100 saving on premium car tyres, compared to Audi. All done at work, no fuss, no drama, no waiting around. Would I use them again? You bet!
I had the misfortune of getting a crack on my car wind screen and have been attempting to get it repaired. Now, the job is never straight forward, I know, but to date I have been let down three times by the same company.
I am covered by my insurers – a trading company of Hastings insurance called Insure, and whilst there is an excess, the rest is at least covered. However, they deal with Nationwide Crash Repairs in Leicester, who I have had the dubious pleasure of dealing with. Now – I am not saying anything about the quality of thier service, which, to be fair, is actually pretty good in the way they deal with you. There is at least clear communication… it’s just that they cannot seem to get the repair completed.
The first booking was over two weeks ago, and I was told the repair could take place at work. The time and date organised, I waited for my car to get its new glass. However, I didn’t get an engineer, I got a call *on the day* to tell me the glass they sourced had a fault. So we rearrange…
The second attempt was also cancelled *on the day* because the engineer’s van had a problem and he couldn’t get to me. He could get to other clients but I was way too far down the list to be able to say it was possible. That alone as curious.
Today I get the third call *on the day* to tell me the repair required special ‘clips’. These were not with the engineer and so we would have to delay again. This is getting beyond a joke – we’ve rearranged for next Tuesday now.
So tell me – if the first glass was damaged, the clips would have been in, right…? And if the second attempt was down to a vehicle issue, the clips would have still been in… right? So why now are there no clips? Do all Audi A5’s get broken screens around the same time and the clips get used up?
It just doesn’t make sense.
So let’s see what happens on Tuesday – I’ll post pictures and let you know if it actually all goes ahead! Until then, I am saying I am less than impressed with being let down three times and on what many would consider to be spurious reasons… Good luck if you are dealing with the same issues from the same company – I’d love to know how you got on, and whether my experience is simply a fluke.
For years and years, I’ve been a loyal visitor to Stonehenge. The ancient monument sits proudly alongside the A303 and every time I go past it I want to go and visit it. I first went there as a child, aged about 4 or 5 probably. I remember at the time being allowed to walk amongst the stones and actually climbing and sitting on them whilst the guide droned on about where we were. I must have had some kind of moment there back in 1970, as I have always loved going to see the site.
Until today, that is.
Today, I drove along the A303 and sat in traffic jam after jam. I’d had enough, so took a familiar detour to go along the ‘other’ road (B3083 to Shrewton, and then turn right along the A360) that meets up at the same roundabout, but passes the Stonehenge visitor centre. Imagine my surprise when I found the road ahead closed, and a strange new building on the landscape, approximately two miles from the monument itself. Instead of the familiar and always friendly visitor experience, I was greeted by a very modern and slightly disturbing piece of architecture, and no sign of a tunnel under the road to scamper along in eager anticipation. Oh no, those days are now a relic, just like the monument.
On arriving, and after paying a fiver to park (you do get it refunded), you go to a large and fairly open covered space. To your right are a very dominating set of three toilets. To your left, a cafe. Behind the toilets is an exhibition, and behind the cafe is a souvenir shop. Between the two is a set of kiosks to buy your tickets. I already hated it.
Regardless, the ticket buying is slick, the exhibition very techy… but I am sad to say not a patch on the underground time tunnel of before. It doesn’t come close to raising the excitement of it’s older version, and everything is on display in museum type cases. Modern, brightly lit, and not at all what it was – that’s great, some might say – that’s progress!
Out of the exhibition you can see a mock neolithic village, complete with fibre glass sarson stone on a wooden frame. it looked fake, it is fake and it doesn’t help. Up until then I am going with the new feel, but then the very worst thing happens. You get on a bus to go and visit the stones.
The new visitor centre is about 2 miles from the stones. You can walk it, if you’re energetic enough, and can go past barrows and other antiquities. Lovely. But a bus is a must for anyone who is older, infirm, too young, lazy, wants a bit of help… in fact, nearly everyone. And sitting on a  bus for two miles to get to the monument is nowhere as exciting as a time tunnel and rushing through it to get to the stones!
This is not the way to build up anticipation and excite the youngsters – or indeed the old ‘uns! It is a sure fire way to build an anti-climax. This, English heritage have done in spades. So much of an anti-climax that I couldn’t wait to leave. So I go on the bus to trek the two miles back and was ushered, I kid you not, into the shop. Filled with the usual ‘henge based goods, it did nothing for me. I went for a bite to eat instead.
Pork Pie Salad - but it is revolting
The cafe feels new, clean, modern – excellent, I thought. I found a pork pie and salad box for £4.75 – a bit high, but it looked tasty. At the till I learned that despite the ‘offer to buy’ on the shelf, the price to pay was a hefty £6.75 instead. I protested, but to no avail. I decided to pay up, and eat. And when I did I just about gave up – the food is a disgrace. The pie was filled with a tasteless mush not at all resembling pork chunks – more like mechanically recovered meat from the inside of a sausage.. revolting texture, and all encased in the most abysmal and salty pastry I’ve ever had the misfortune to taste. Two salad potatoes, two slices of cucumber, a cherry tomato, some ‘slaw and about a tonne of lettuce – mostly iceberg, nothing close to tasty.
Tasteless, badly priced and served with no more than a wooden fork that would be at home at a seaside chip shop.
It cost me a fiver to park, £17.50 to get in and (with a drink) £9 to eat – except I didn’t – I left it.
I toyed with the idea of joining English Heritage today. And then decided not to. This is NOT the experience I want each time I go to Stonehenge – a conveyor belt of tourists, not one ounce of excitement and everything geared towards getting people in and out fast. A two mile bus ride… it’s a nonsense. A pastiche of what was there, and as far as I can see, there’s no reason why the centre could not have been a *lot* closer to the monument.
Now, if English Heritage also run their other 400 sites throughout the country in the same way I want no part of it at all. I’ll not join an organisation so clearly disjointed from the user experience and so appallingly and obviously driven to a quick buck. This is NOT what English Heritage used to be about, and not what I want it to be now. So I’ll keep my cash and buy membership to the National Trust instead.
And what is even more sad, I’ll never visit Stonehenge like that again. I’d implore you all to protest if, like me, you have gone to it since the 70s or before, and now found your visit there to be something very removed from what it was. OK – so the stones are in the same geographic location, but everything that was special about them has been moved. Or ‘re-moved’… you decide.
