James Titcumb

So the “Microsoft Browser Choice Screen Update For EEA Users” has arrived in my list of potential updates. Interestingly though, Microsoft have not selected this update by default. That might put a dampener on Opera’s big day…

I’m not a power Excel user, but as we handle a lot of data, I had to use it earlier today to do some in_array type searching. Basically, I had a CSV with a load of IDs, but we’d already processed some of the IDs. I wanted to remove the IDs from the CSV that we’d already processed. So I have this CSV of IDs, and a list of IDs we’d already processed. Great! In PHP, I could just use in_array on each of them. But I didn’t have time to do a PHP script, so this is how to do a similar thing in Excel – a Vertical Lookup.

Open your CSV in Excel, and add two new columns “vlookup” and “is_processed”. The formula to apply should be something like:

=VLOOKUP(C2,'already processed'!A:A,1,TRUE)

C2 is the ID you want to check if is in the list of already processed IDs (the “needle”). If you want the matching to be non-strict and have the lookup table sorted in whatever order (probably not), set the last parameter to TRUE. Normally you want FALSE to check anywhere, and make sure you sort the lookup table in ascending order.

Add a new sheet, and call it “already processed”, and add your list of IDs in the first column. This is your “haystack”.

If you return to your original sheet, you’ll see the “vlookup” column has either IDs (if the ID is found in your list) or #N/A if the value is not found. To make this neat, add this formula to your is_processed column:

=IF(ISNA(F2),"no","yes")

Where F2 is the vlookup column. Then for the IDs (“needles”) that are found in the search list (“haystack”) the value of is_processed will be “yes”, and all that aren’t found it’ll be “no”. You can then filter on this or whatever you like!

Now that the fuss over Bing‘s launch is already over (that didn’t last long, did it?), what is the future for it? According to this article‘s source, Bing had a 11.1% share of the US Search market. Microsoft apparently haven’t hit above 10% since 2007, so that could be seen as quite a positive thing. But Google seems pretty confident this is just a blip on the radar and they are unconcerned, and that could potentially be true.

I’m no expert by any means, but it will be interesting to see how this pans out.

Whats more, if Microsoft really love the Bing name, will they start replacing all the Windows Live products after replacing Live Search? Will we start using Bing Messenger, Bing Hotmail and so on? Will they do a last minute re-brand of Windows 7 to be Windows Bing? That would be quite funny…

This bears slight resemblance to the already widely publicised anti-trust/monopolising cases against Microsoft for bundling their own software with their OS, without offering the alternatives (read here (Windows Media Player) and here (Internet Explorer)). Admittedly, the competition for browsers and media player software is much higher than instant messaging software, but it’s slightly related.

Many Windows users will have already seen this install software, which is now downloaded every time you want to update a program, such as Windows Live Messenger. The program itself isn’t my concern, rather the automatic ticking of nearly every other Windows Live software on the list. I only wanted to update Windows Live Messenger, yet the program had automatically selected Mail, Photo Gallery, Toolbar, Writer, Family Safety, Office Outlook Add-on and Office Live Add-on for additional installation. That is an extra 128mb – a paltry amount, by most accounts, yet still an amount I have no need for.

To rub salt into the wound, post installation the default option is to change your search engine as well as fix your homepage. Rumours on the Internet are that if you do not remove the “Set my homepage” link, then the program installs an additional program that forces your homepage to stay the same; apparently (although I have not had first hand evidence) to the extent of not letting the user change their homepage for themselves. The idea behind it is to stop spy ware changing the homepage, yet this seems counter-intuitive to not allow users to change their homepage at all… As I said though, I cannot confirm the legitimacy of this rumour, so it may be speculative.

To summarise, Microsoft shouldn’t have these additional pieces of software automatically selected for installation – a less savvy user (family members come to mind…) might not look at this list and add these unnecessary pieces of software to their system.

It looks like we’ve taken another step towards never leaving our houses. It’s nothing new I know, but Luke reminded me yesterday of it’s existance – Microsoft’s rather impressive stab at mapping software à la Google Maps.

Instead of Google’s angle of just taking pictures of everything, Microsoft are going down the less intrusive route of just making 3D models of all the buildings. When I last saw this last, it was much less impressive, but looking at it today, you could almost say it’s better than Google. Although having said that, Google Earth has this same 3D view, but in a standalone app.

My opinion though, is that they both have their merits – Google Street View is pretty cool, and so is this 3D view… I suppose it depends what you want it for.

Regardless, with competition from these, and probably other mapping software, combined with online shopping, online chat, video gaming, home offices and a whole host of other software, it’s looking more and more likeley that I’ll never have to get off my bum ever again.