Friday, 30 September 2011

Vlookup

Thought this might come in useful to anyone who is lacking a little Excel skill. It's one of my old favourites... the vlookup. I have uploaded it to Google Docs but the formula is the same...

 

USE  '=VLOOKUP(G5,A5:B14,2,FALSE)'

The arguments are…

Lookup_Value The thing you want to lookup. In the table there is a person id with our vehicle we want to check it against our person table

Table_Array This is the table we want to check our value against in this case it’s the person table

Col_Index_Num This is the value we want to return, in the above case we want the name from the person table so we say 2

[range_lookup]  always make this false, if not it will get the closest match. We don't want that.

Take a look here at the example https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0AsCbyg...  

BBC News - Tiangong-1 launch betrays China's earthly ambitions

Media_httpnewsbbcimgc_rhidb

I am almost certain that China will be populating the solar system before the rest of the world. The scenes in Firefly (with everyone being able to speak both English and Chinese) may be quite right!

MAKE | X-Wing Soap Box Racer

Media_httpblogmakezin_iljcd

This is a brilliant go kart.

Wednesday, 28 September 2011

lee wei chen: arcade washing machine

Media_httpwwwdesignbo_aigga

What a cool washing machine! Massive, but very cool.

A Mclaren thought process...

Mclaren

Jimmy Robinson Alarm Clock

Nickrobinson

I have just finished a very low fidelity of my Jimmy Robinson Alarm Clock. I really think it might work. Let me know what you think. Would you buy one? Depending on the success of this I am also thinking of a Duncan Bannatoon grandfather clock. It would essentially be a life size replica of Bannatoon himself with a transparent belly and a pendulum in the middle. At twelve he could declare himself out...

Tuesday, 27 September 2011

Minecraft on touchscreen Android

[youtube http://www.youtube.com/watch?v=rCcsuPH4vJY]

Oh noes! It's getting closer and closer! I'm not sure how I'm expected to lead a normal life with this, Skyrim, Modern Warfare 3 and Old Republic coming up to name just a few...

My workspace

C360_2011-09-27_21-28-16

 

My workdesk is steadily getting messier and messier. Still generally pleased with the zone though.

Solve Puzzles for Science | Foldit

Media_httpfolditporta_foebf

I heard about this site on BBC Click tonight. It is a brilliant idea. Using games and competition to help science is most excellent. I want to see much much more of it. I wonder if the very way we teach needs to adapt and take on this idea to a greater extent.

Essential Hobbies

There are 3 important hobbies that are currently missing from my life. All of which are catered for locally to me. 

Archery

Fencing

Horse Riding

At some point I need to do a little of each hobby with an ultimate aim of combining them to become the ultimate warlord.

Wj1181626058_58583

Monday, 26 September 2011

Jimmy Miliband vows to give you nightmares

Jimmy Miliband freaks me out. No chance will I be voting for him. But if he happens to ask you who I am voting for. Please say tell him I'm behind him all the way.

Ed_milibandEd_miliband

Tuesday, 20 September 2011

Back Street Sketch

Backalley

3d Model export from a little Google Sketchup drawing. I tried to get some real textures to use but it turned out crap so went with the thick marker pen style.

Recent books I have read this month

I have read a series of excellent books since the start of August so I thought I would share them with you...


White Fever

Recommended by a friend who had read it, this book is an interesting look into the strange world of Siberia. Whilst it wasn't as humourous as I hoped (it actually left me feeling quite blue in general due to the plight of the native siberians) but the book is packed full of weird and wonderful characters. 

The Gods Themselves

I really enjoyed this book. Having noticed I have missed some of Asimovs books I needed to fill in the gaps. This has realyl interesting points to think about in terms of how we kid ourselves about energy because we don't want to change the way we live. The ultimate message for me was you can't just convince people there is a problem. You need to come up with a solution at the same time. 

I enjoyed the moon seperation side story. They remind me of early spacers from Asimovs robot series. They don't particularly like earthlings and see them as dirty...

 

The End Of Eternity

Another Asmiov book. I can't believe I had not read this before. Essentially it's a time travel based boggle. It raises loads of interesting ideas and literally had me hooked so I could not even walk to the train station without reading it. It only lasted 4 days. How can people watch television when there are books like this to read! Amazing!

 

Upcoming..

I have changed direction slightly with my next set of books to read. At night I am reading 2001 A Space Odyssey by Arther C Clarke (I'll let you know what I think when I have finished it). In the day (whilst commuting etc.. ) I am reading Rashomon and Seventeen Other Stories by Akutagawa. I have actually read this before but I can no longer remember it and something got me thinking about Akutagawa again. One thing I have done this time whilst reading it is read the foreward by the translator. They have shed some light on other Japanese authors that I probably need to take a look at also. 

3cTLO.jpg (453?604)

Media_httpiimgurcom3c_tozyu

This picture made me laugh out very loud. It's has a certain quality that just kills me.

Motorola DEFY+ priced at surprisingly affordable level ? Eurodroid

Media_httpwwweurodroi_jypjl

This is a great price for a great phone. Especially with a bit of 2.3 love.

BBC News - ?3m 'bling' car put on display

I love it. Just simply crazy.

Sunday, 18 September 2011

Harnessing solar power without an ugly landscape

I'm wondering if instead of the potential fields of solar panels that we would need to utilize solar power, if we couldn't just build large underground caverns for them instead. We could use a system of mirrors that can swivel around and follow the sun, redirecting it down into the ground...?

Just an idea anyway :-)

231

Friday, 9 September 2011

Nottinghamshire Police ? 'Cunning predator' jailed


Home > Latest news > News > 'Cunning predator' jailed


'Cunning predator' jailed


Posted on 9th September 2011 16:30


A ?cunning predator? who sexually assaulted young boys over two decades has been sentenced to six years behind bars.

Peter Holland, 79, of Bankfield Drive, Bramcote Hills, Beeston, abused 13 boys ? now grown men ? between 1974 and 1993.

He pleaded guilty to ten counts of gross indecency and 15 counts of indecent assault and was sentenced to six years in prison at Nottingham Crown Court today (Friday 9 September).

Nottinghamshire Police arrested Holland in September 2010 after one of his victims came forward and reported the abuse he had endured as a child.

The man, now 38, said Holland had sexually assaulted him on a number of occasions when he was a young boy between 1979 and 1984.

Officers subsequently searched Holland?s address and discovered more than 1,300 photographs containing images of young boys or men.

Detectives launched an extensive investigation to trace the people in the pictures, and a further 12 men - now aged between 33 and 51 - were located.

All made similar allegations and said they had been sexually abused by Holland between the ages of 11 and 15.

The abuse took place at a number of different locations within Nottingham.

Holland pleaded guilty to all charges at Nottingham Crown Court on 10 August this year. On sentencing, the judge said he was taking into account the fact that Holland pleaded guilty.

Detective Constable Perveez Rashid, from CID, said: ?Holland is a manipulative and cunning predator who targeted young, vulnerable boys to satisfy his own perverse pleasure.

?His victims have shown incredible strength and courage in coming forward. They have suffered in silence for many years and have lived with the long and enduring pain of childhood abuse.

?The sentence handed to Holland today will hopefully offer them some comfort to know their attacker has finally been brought to justice. He has been convicted, will spend time in jail and his name will be on the Sex Offenders? Register for life.

?Nottinghamshire Police will do everything in its power to apprehend those who perpetrate these sorts of crimes, regardless of how long ago an offence was committed.

?All victims will be treated with respect and sensitivity and we will do all we can to secure a conviction to prevent people like Holland from harming anyone else.?

Anyone who would like to report a crime should contact Nottinghamshire Police on 0300 300 99 99 or call Crimestoppers anonymously on 0800 555 111.


Back to news page





Such a bizarre thing to call such a fiend! Surely a "Cunning predator" is the title you would give to a super smart Velociraptor or an acclaimed Deer Hunter. Not some Peado that abuses kids!

Wednesday, 7 September 2011

Thursday, 1 September 2011

3d head mounted displays in violent games. One abstraction too close?

Media_httpwwwblogcdnc_mhsnp

I saw this article on Engadget about the Sony 3d headset earlier and I immediately thought about it's application in gaming. To be fully immersed in a game like Modern Warfare would be amazing. You would have surround sound (hopefully) and be able to see everything that is going on around you.

My only worry about this, as video game graphics get more and more realistic is the potential psychological impact this degree of realism could have on gamers. After a serious gaming session I certainly find it hard to sleep sometimes and the sound of gun fire can be ringing in my ears for hours! Being able to stab someone with extreme realism and with so many senses being catered for I'm not sure how I would feel. In my case, being a sensible adult with no urge to stab most real people I think it would be overall a good experience still.. until the realism was hiked up even further. Would I still want to play it? I'm not so sure.

With parents utter inability to stop buying these type of games for their children (illegal or not) I wonder what lasting effects it would have on the next generation? A 7 year old boy being completely immersed in a war game for several hours a day can only be a bad thing surely?

On a different note I thought about the potential such devices could have in my profession (software development) to be in some sort of Matrix like environment similar to gate keepers of Zion would be amazing. With the help of some sort of special gloves, the ability to construct program logic by hand would be excellent. Even with this, I wonder what the long term effect from working in this environment for 8hrs a day would have to me. As I often code at home for fun as well and game it could potentially be from the moment I wake up to the moment I go to bed. That's a slightly more scary thought.

This type of immersive technology is fantastic and I can't wait, but several ethical questions must be asked when it finally comes.

Lenovo A1 ? budget-busting 7? Android 2.3 tablet ? Eurodroid

Media_httpwwweurodroi_qevdl

This looks extremely promising in my ongoing hunt for a reasonably priced tablet computer. Eurodroid suspects the amount may be around ?125 but I can imagine the greedy fiends will have the price around ?180.

As has been seen with the Touchpad, I think the first non shit Android tablet that can come to market for around the ?100 price is going to rule. It's a pity they couldn't get this to market for xmas time, I can imagine lots of disgruntled people this year who have been bought a cheap tablet for christmas that just doesn't cut the mustard.

I am still hoping Amazon are going to wow me but nothing is materializing.

Who Moved My Cheese?

I was listening to a Hanselminutes podcast and he mentioned a reference to the "Who Moved My Cheese" book (not sure if it was intentional!). It's a great little book about managing change in life and specifically at work. Well worth a read even if you think you are ok with handling change. Good stuff, it's a really small if you aren't normally a reader. I think I have already given my copy to someone but it's only a couple of quid so pick it up.

Comments System

Disqus Shortname