Author Archives: Zaaba

James Cameron dives the Mariana Trench

Link

Reply

At 10.91km at the Challenger Deep, the Mariana Trench is the deepest part of the ocean. To put that into perspective, the site is 120 times larger than the Grand Canyon and a mile higher than Everest is tall. At the bottom, the pressure is 15,000 pounds per square inch; which is over a thousand times normal atmospheric pressure on the surface.

So who would ever want to go there? James Cameron, that’s who. The director became the first solo diver to visit Earth’s deepest point but resurfaced six hours earlier than expected in a 12-ton, lime-green sub called Deepsea Challenger.

As someone who grew up watching SeaQuest DSV and reading Fathom, I hereby award 1,000 cool points to Mr Cameron for spending his hard earned millions on exploring a place on earth very few have even dared to venture. We’ve not yet heard of the things he’s managed to see, sample or observe, but I presume this will come to a NatGeo documentary soon enough.

Disaster averted!

Posted on by
Reply

With the icky Google malware warning finally disappearing overnight, I now begin the loooooong task of restoring stor.my back to its original host. I think this is probably going to be more difficult than I anticipate…

Update 23/3: Restore complete! Purged the root folder of all files, reinstalled WP, imported  all old posts, restored all content images. Luckily for me, the original stor.my backup kept hyperlinks to the images to this domain. This recent event is a reminder that part of being a responsible domain owner is to ensure that the software should be well maintained and monitored!

Update 23/3 11am: In my zealousness to purge the root directory of stuff, I inadvertently deleted stor.my’s YoURLs installation! So while the database is live, the files and what not are gone. /sad face

Update 23/3 2pm: Yep, I confirm that any effort of mine to restore the old URL shortener would involve a wee bit more work than I expected. So that’s outta the window. Looks like the old URLs which I have shortened before will now be consigned to oblivion…

Restoring from backup

Posted on by
Reply

So my inactiveness in maintaining the blog has come to bite me in the ass. Found malicious code injected onto the website and Google has a nice big malware warning. Pretty much renders the old stor.my URL useless for all intents and purposes. So here I am on WordPress again trying to backup the old posts. Hope this goes well!

Excel: Average() and rank

Posted on by
Reply

My high-school batch has a football league going on the official Fantasy Football website. This year, the organizers proposed assigning points to teams representing our respective sports houses with bragging rights at the end of the season. Now, while the official league does a pretty good job at keeping track of individual scores, it doesn’t have a way to group teams into “groups” so I came up with this Excel spreadsheet.

We decided to assign 10/7/5/3 points to 1st, 2nd, 3rd and 4th placed houses each game week, with each house’s score each week being the average score of the top 3 performers in that house. At the end of the season, the house with the most points wins!

My initial thought process led me to think that the solution to this problem would be a combination of average() and rank(). The deliverable being, “return the average score of the top 3 teams in house X”. Turns out, rank() isn’t required at all! The solution was as follows, and must be entered using Shift+Control+Enter as it is an array formula:

If you’d like to toy around with the formulas, the excel spreadsheet is here: week1.xlsx

An Old Spice ode to London

Posted on by

Hello Rioters. Look at your friend, now back to me. Now at your friend, now back to me. Sadly, he isn’t me, but if he stopped used petrol bombs and started using the job centre he could potentially be me. Look down, back up. Where are we? You’re at an interview with the man your friend could work for. What’s in your hand? Back at me. I have it. It’s an application form to that job you need. Look again. The form is now money. Anything is possible when you get a job, stop looting and grow up.

***

I don’t claim originality for this! First seen by Marc Penny on the “Scotland, where we don’t destroy our own city cause we’re no mongos” fan page.

London Riots

Posted on by
Reply

As a Londoner, the recent events have been appalling. The people involved have stopped being protesters and have turned into opportunistic looters and thieves. The scariest thing to me though, is that the riots are symptomatic of a far greater threat to our society: that of the lack of respect for authority. I think we as a society have failed to create meaningful lives for a growing underclass of individuals and that this growing resentment will continue to fester and blow up again in our faces again at some point in the future.

Here are a few pieces which I think communicate the issues pretty well:

Max Hastings from the Daily Mail:

If you live a normal life of absolute futility, which we can assume most of this week’s rioters do, excitement of any kind is welcome. The people who wrecked swathes of property, burned vehicles and terrorised communities have no moral compass to make them susceptible to guilt or shame. Most have no jobs to go to or exams they might pass. They know no family role models, for most live in homes in which the father is unemployed, or from which he has decamped. They are illiterate and innumerate, beyond maybe some dexterity with computer games and BlackBerries.

Zoe Williams from the Guardian:

I think it’s just about possible that you could see your actions refashioned into a noble cause if you were stealing the staples: bread, milk. But it can’t be done while you’re nicking trainers, let alone laptops. In Clapham Junction, the only shop left untouched was Waterstone’s, and the looters of Boots had, unaccountably, stolen a load of Imodium. So this kept Twitter alive all night with tweets about how uneducated these people must be and the condition of their digestive systems. While that palled after a bit, it remains the case that these are shopping riots, characterised by their consumer choices: that’s the bit we’ve never seen before. A violent act by the authorities, triggering a howl of protest – that bit is as old as time. But crowds moving from shopping centre to shopping centre? Actively trying to avoid a confrontation with police, trying to get in and out of JD Sports before the “feds” arrive? That bit is new.