Showing posts with label fun with numbers. Show all posts
Showing posts with label fun with numbers. Show all posts

Monday, 3 December 2007

BrokenTV's Telly Yule (B)Log: Day Three

Sorry about yesterday's update, everyone. Just plonking a graph onto the site and expecting everyone to be entertained was a bit lacklustre, a bit like when Sky One advertise a new episode of The Simpsons, only for it to be a clip show.

Luckily, we'll pulled out all the stops, and can promise everyone that today's update is literally five times better than yesterday's effort.

YULE (B)LOG DAY THREE: Five Pie Charts About TV Ratings

Ho, yus. Today's second and final (promise) part of our Excel rollercoaster takes a look at the three most watched shows for each Christmas week since 1998, and compares how varied each channel's output was. The single programmes named are used, apart from where a number of shows receive a single hit, so we've grouped those by genre.

Who had the most eclectic line-up of the Big Five? Well, top of the heap, winning a commemorative bag of mixed nuts...





A tie between BBC Two and Channel Four. Traditionally the two channels with less to risk over the big Christmas day schedule (often resulting in them flinging an old film or opera on), the last nine years have seen the channels wheeling out some of their big hitters. Channel Four saw Deal Or No Deal take up the top six slots of their 2006 Xmas week ratings, and for the past few years The Weakest Link has been BBC Two's main offering. Both have used The Simpsons to good effect for a short period, BBC Two until they lost it to Channel Four, Channel Four until they got a bit confused and started shifting it all around the schedules. Both have had a special Christmas Pie (chart) containing the fruits and nine different shows and/or genres, suggesting above all else that we really haven't thought this through properly.



Third on the list, Five have always had trouble finding something to fling into their Christmas schedules. While this has led to some actual hidden gold in our festive Radio Times (Jerry Sadowitz vs The People Of New York), it's only been the twin guns of Home & Away and CSI that have given them a more respectable share of viewers too full of turkey and After Eights to go out or prance around in front of Wii Sports.



Fourth place falls to 'The One' (as absolutely no-one outside of Television Centre calls it), with a possibly surprising four different shows making up their pie. While the 'comeback' episodes of ...Badly, ...Dibley and ...Horses all failed to trouble the chuckle muscles of discerning comedy fans (or, at least, us), they clearly got enough of arses on the nation's couches to be considered a big hit. And if we've got to say something nice about The Vicar Of Dibley... erm, the bit where Carol Vorderman knelt on the floor to beg for votes during the final of Britain's Favourite Sitcom made us feel a bit funny in our 'special area'.



In last place, ITV1. With it's one 'Christmas' show. That pie chart probably says enough about their efforts over each festive season, really. It'd be great if a TV Burp Christmas Special did well enough to sneak into that pie for this time next year, though.

Right, we're going to leave Excel well along for the rest of the month. No more numbers. Promise.
Share:

Thursday, 28 June 2007

BrokenBrother: MicroUpdate

With Seany - who'd we'd jokingly stated would be next to leave the house because we'd just put a fiver on him to win - having been the next person to leave the house, it's quite clear that we'd never pass ourselves off as Big Brother experts. Each of the two people we've now backed as winners have left the house in disgrace at the very next opportunity, and we're flirting dangerously with relegation from Brig Bother's Fantasy Big Brother League (the bottom three quite possibly having to enter a fantasy league based on Castaway 2008). With that in mind, we're simply going to post up the figures, and restrict ourselves to five observations based on the last two weeks of Big Brother.



  1. Our current favourites are now the twins. Yes, who'd have thought that after the launch show, eh? Despite initial revelations, along with Laura they seem to be the most genuine people in the bungalow this year. Coupled with the fact we've just realised that they both look quite a bit like Lauren Laverne When She Was Still In Kenickie, we've decided they must win.

  2. Amanda is the current Betfair favourite to win. Somehow, Sam is languishing on 13, while Amanda is on just 5.8. We've no idea how, because we can't really tell them apart. Of course, in our imagination both of them are [the rest of this paragraph has been confiscated by The Taste Police]

  3. Brian seems quite incapable of understanding that women need to go for a poo as well as men. We're not even making this up. That's almost as funny as him believing Laura and Seany telling him that there's no electricity or inside toilets in both Wales and Ireland ("Can't you ask Tony Blair to do summink abaht it?"). The fool - we've had indoor lavvies since 1997, although we do both still get our electric from a really long extension cable plugged into Blackpool Illuminations.

  4. Unless every single Big Brother viewer PayPals one British pound to BrokenIndustries account in the next 36 hours, we're going to lay odds on Charlie winning, thereby ensuring she'll be in the house for the duration of the series.

  5. We don't know who Russell Kay is (or whether that's the right way to spell his name), but we'd sure like to punch his face in.
Share:

Monday, 11 June 2007

BrokenBrother: "He Looks Like A Clown!"



According to Wikipedia, a petard was a medieval small bomb used to blow up gates and walls when breaching fortifications. In medieval and Renaissance siege warfare, a common tactic was to dig a shallow trench close to the enemy gate, and then erect a small hoisting engine that would lift the lit petard out of the trench, swing it up, out, and over to the gate, where it would detonate and (hopefully) breach the gate. It was not impossible, however, that this procedure would go awry, and the engineer lighting the bomb could be snagged in the ropes and lifted out with the petard and consequently blown up. Thus to be 'hoist with his own petar' is to be caught up (and destroyed) by his own plot.

The phrase was coined by a Mr W Shakespeare of Stratford-upon-Avon, who first used it in his play Hamlet. Two schoolfellows of the titular Dane, Rosencrantz and Guildenstern, concoct a plan to see Hamlet executed. However, the Prince is too wily for them, and amends the death warrant to contain their names instead of his. Hence, "for 'tis the sport to have the enginer. Hoist with his own petar; and 't shall go hard"

That's quite handy for us to know, as right now modern day Rosencrantz-in-blog's-clothing BrokenTV finds itself dangling from its very own electronic petard. We go and get ourselves quoted in an online magazine, stating how that Emily off of that Big Brother think she all dead clever and that but she ain't, only to find they've used a section of text where we begin two consecutive sentences with the words "of course". Of course, we're suitably chastened by this, and have to face the fact that Victoria Coren will never want to join us down the Lamb and Thesaurus for a drink now. But then, we did only get a 'B' in GCSE English, so what can you expect, eh?

But anyway, there are new people in the bungalow. Seany seems quite interesting, and sure to raise the overall entertainment level in the house. Gerry hasn’t really done enough yet for us to think that much of him, and hopefully he’ll seem a bit less one-dimensional as time goes on. And Lesley has gone – a bit of a shame, but if you treat everyone else as if you’re some sort of public school headmistress, you can’t be too shocked if some light-hearted St Trinians type behaviour goes on.

As for the others, the number of dislikeable people seems to have been whittled right down. The twins, who’d initially given the impression they’d do little but squeal for the duration of their time in the house, seem to do little more than wander around in an innocent world of their own, electing to keep their mouths closed and just run around on the furniture if something important is going on. And more power to them for that. If there’s ever a British live-action version of Cutie Honey, the twins would be perfect.

As everyone seems to have pointed out, Shabnam looked a lot nicer without make-up, but if she prefers to wear it, then that’s fair enough. We’d guess her willingness to agree with whoever is speaking to her is more to do with an innate desperation to be liked by others (notice her frantic comment about make-up and clothing to Gerry, 0.5 seconds after he walked in the door), rather than any calculated cattishness. We should admit that as the fake PhD certificate in psychology we’ve ordered from eBay is still in the post, it’s not exactly a professional opinion. Meanwhile, Ziggy’s reaction to his ‘competition’ was quite funny. It’s the same reaction we had once we realised that Big Brother’s Black Eye is doing much better coverage of the show than we are.

It did seem a bit suspicious that Charley swiftly moved from not being too bothered about the whole Emilygate situation, to suddenly acting as if it affected her hugely. This could be because it’ll improve her chance of winning (“I’m going to be on the front of all the papers”), but it could well be because she’s had more time to think about it. Although there wasn’t any malice on Emily’s part when she said it, so: hmm. Of course, she won’t win because of this – it wasn’t just coincidence that Shilpa won CBB whilst being the nicest person in the house, you know.

Anyway, new graphs. We’ve added another clause in the calculation process, so that anyone not left in the house automatically takes a 15% hit to their total score. This should translate to a 15% boost for whoever wins at the end of BB’07, and for now it should help the people still in the house (and who don’t get the benefit of some extra Wikipedia text explaining why they’re not there any more). Finally, we’ve taken out the keywords clause, because it was a pain in the bum to calculate.



Emily storms into the lead despite not being in the house any more. Infamy and, erm, famy just being two sides of the same coin, of course. Gerry is helped to a decent score by having a very long full name. Somehow, and maybe we’ve missed something here, Laura has collapsed in the betting race, with Tracey now a somewhat unlikely favourite. Gerry has leaped into second, and Chanelle third.

Seany, who’d we’d say has a decent chance of winning, sits at a surprising 39/1. Expect him to get hounded out of the house very soon, as we’ve just buggered all that up, by putting a fiver on him to win.
Share:

Thursday, 7 June 2007

BrokenBrother: "The upholstery is smouldering gently"


From Monty Python's Flying Circus episode 28:

(Sound of an explosion out of vision. Cut to reveal Mrs Nigger-Baiter's chair charred and smoking. Mrs Nigger-Baiter is no longer there. The upholstery is smouldering gently.)

Mrs Shazam: Oh, Mrs Nigger-Baiter's exploded.

Son: Good thing, too.

Mrs Shazam: She was my best friend.

Son: Oh, mother, don't be so Sentimental. Things explode every day.

Mrs Shazam: Yes, I suppose so. Anyway, I didn't really like her that much.


Hey boys and girls, can you count all of the stupid mistakes we made in the last update?

"We've noticed that there doesn't even seem to be an Official Big Brother I-Thought-Scousers-Come-From-Newcastle standard Thicko this time, almost definitely so there's less risk of overt racism."

"Lovely Emily is hopping along in at 30, so we've plonked a fiver on her"

"We can always lay the bet once her odds drop AS THEY SURELY WILL."
Pof. As well as everything else, we'd like to state we hadn't seem them doing the 'rank themselves in order of' task before placing that bet. And we'd wondered why the odds were so good. "I'm definitely in the top four of attractiveness", indeed. Of course, it's quite obvious that Emily isn't a massive racist, but really quite staggeringly thick. Of course, anyone who feels the need to introduce themselves to the nation by stating how intelligent they are before they say anything else, very probably isn't.

Of course, today's events have had quite an effect on our slightly tweaked Fame-o-meter. Slightly tweaked because having 'citation needed' as a bonus multiplier wasn't really worthwhile, so we've adapted it to account for the number of times each person has been Googled and found BrokenTV. A bonus of 2% added to their score for each search, limited to a maximum of 20%. That's good news for Charley, because of what we're inadvertently top-Google-ranked for (can't think why), along with Shabnam and the twins (we've given 50% of the bonus points for joint searches to each twin, who now merit their very own bar on the chart).

We're a day behind the highlights shows at the moment, because of a power cut last night, so our current favourite is Laura for displaying a little bit of quiet dignity, with Charley still in the relegation places. It's quite possible Emily would be bottom, but The Big BrokenTV Big Brother Rulebook states that only current bungalowmates are eligible for those positions. This gives us the following scores.

Name Total
Amanda Merchant 39.90
Carole Vincent 78.00
Chanelle Hayes 36.00
Charley Uchea 100.80
Emily Parr 136.08
Laura Williams 43.20
Lesley Brain 58.00
Nicky Maxwell 57.00
Sam Merchant 39.90
Shabnam Paryani 62.40
Tracey Barnard 40.00
Zac "Ziggy" Lichman 115.00

But what does that look like in barchart form? In super 3D? This:



Woo, eh?

THE BROKENTV NON-BIG BROTHER THING CORNER

It's the DVD boxset we really, really want.



All 692 episodes. 174 discs. Plus, a signed photo of Val "Bea Smith" Lehman. Yours for just £702.68 (not including shipping from Australia). Cripes.
Share:

Wednesday, 6 June 2007

Broken Brother: Part Three

We've finally got around to watching the highlight shows. All of them. In one evening. Including Friday's live show. For you. Because we care. And because we thought we'd better have something proper to say about it, given we've tried to squeeze a week's worth of updates out of the Wikipedia page for it, the Betfair odds and the Word Count extension for FireFox. Here are a few thoughts that thousands of people have already said on other blogs by now, so we'll keep it mercifully short.

As ever, there seem to be three distinct camps in the preliminary rounds of Big Brother. One contains the people who seem quite annoying at first, but after a while aren't that bad, such as Emily, quite rightly top of our Fame-o-meter, or Carole, who seems quite staggeringly different from her pre-bungalow montage so far. Another contains the people who'd seemed quite nice, but soon display themselves to be The Worst Person In Britain As Far As The Tabloids Are Concerned, namely the aggressively vacuous Charley (who doesn't seem to realise that being the first one to leave the bungalow rarely even garners a Conference South level of celebrity). The other, larger group contains the supporting cast who kind of blend into the background; the others, even including Sam and Amanda, who put the twee in twins (erm, does that work? Has anyone else said that yet? Oh).

For the most part, as ever, the contestants aren't in full-on Ooh, Look At Meeeeee, Davina mode and tend to relax into their everyday personalities, meaning they're generally quite difficult to dislike. Unless they're trying especially hard to be disagreeable like Charley. Even Tracey has stop saying "'ave it" every four seconds, thankfully. After watching the first highlight show, we'd prepared a comment along the lines of "how can someone who seems so determined to point out that she's more unique than everyone else be such a horrendous stereotype? Catherine Tate is very probably kicking herself for missing out on Middle Aged Clubber Woman Who Always Does The Same Thing", but that now seems callous and nasty. Bah.

We've noticed that there doesn't even seem to be an Official Big Brother I-Thought-Scousers-Come-From-Newcastle standard Thicko this time, almost definitely so there's less risk of overt racism. Despite initial appearances, the twins wouldn't scrape a Level 2 NVQ in Dimwittery, and Charley's more self-centred than anything else. Once The Blokes storm into the house this may well change, but for now it's reasonably well mannered. Which is a polite way of saying "pretty dull". Unless one of the next three bungalowmates to enter is a baboon with toothache, we might well get rather bored of all this.

So: graphs. It's not really worth updating the Fame-O-Meter right now, hardly anything has changed and it might well need a massive reimagining over the next few days. Luckily, galloping to the rescue on a numerical steed comes Ollie from Betfair, who has been good enough to supply us with spreadsheets of Betfair's daily prices since day one of the Big Brother Bungalow. So now, here in glorious Office-2007-o-vision (because we put them together at work) are some nice hot graphs. Hey, they're probably slightly less dull than watching Chris Moyles host Big Brother's Big Mouth.




Firstly, because having everyone on the same graph was like a car crash, the outsiders. Lovely Emily is hopping along in at 30, so we've plonked a fiver on her. We can always lay the bet once her odds drop AS THEY SURELY WILL. Charley is struggling in last place on about the same odds as Kieran Richardson signing for Inter Milan.



There's the middle bunch, squabbling for the middle ground like eejits.



And there are the favourites. Fairly surprisingly as far as we're concerned, Ziggy's odds have lengthened, despite him seeming more agreeable as the days have progressed. Carole at second favourite seems a bit of a shock, given that we're sure she'll get bored of it all by the end of the first month and walk, especially if most of the others devote most of their energy to cooing over any new male co-inhabitants. Chanelle seems quite desperate to become this years' Chantelle, and Laura seems like a nice person, but we're sure she's only in the house to give Justin Lee Collins someone to do a piss-poor impression of during The Friday Night Project.

Our prediction: Someone who isn't even in the bungalow yet to win it. But hopefully not before Emily's odds have dropped to single figures and we've made a killing.

Someone who knows what they're talking about's prediction: We've got permission to post the following bit of proper knowledge from Steve, the Betfair Betting Expert.

Keep stakes low. Don't be fooled into the 60% book on Betfair (the winner may not even be in the house yet). With 3 months of Big Brother anything can happen. It won't be as simple as picking the winner Pete from last year. I have managed to lock in (no loss) green book on the winner's market through some trading. Nothing big or worth shouting about but a green book of £45 always makes me smile. Backed Chanelle at 32 as soon as she entered the house and then layed her at 27 the next day. Then laying Ziggy at 7.4 when he entered the house and backing him at 7.8 the next morning.

I think this year's show will be one of the most interesting yet. Big Brother wants a love relationship to blossom and I think we will see it. Will it be Chanelle and Ziggy? Odds are shortening every day. I'd give odds of 1.1 they will kiss sometime in the show.

The two prices that have been affected most over the last 24 hours are those of Chanelle and Emily. Chanelle's price got significantly shorter throughout yesterday and she became second favourite at one point however this soon changed after a late night row with Emily over a pair of hair straighteners. Chanelle is back to being third favourite while Emily's price has drifted from 25 to 30.

Tracey and both the twin's prices have all shortened meaning Emily is now the fourth least favoured housemate.
The Big Bouncy Betfair BB Betting Blog is in full here, for anyone who wants to read it. And that's enough plugging Betfair for now. Other betting websites are also available, folks.

More BB07 fun next time, where BrokenTV shamelessly tries to sneak back onto the artistic roll-call, and we try to think about something to write about that isn't Big Brother or a graph.

Pop Fact: We were going to visit the Hay Festival this week. We've ended up doing this. Best laid plans, eh?
Share:

Friday, 1 June 2007

Big Brother 2007 (With Graphs): Part Two

Day three in the Big Brother Bungalow (IT IS NOT A HOUSE, IT IS A BUNGALOW AS IT ONLY HAS ONE FLOOR), and there's a new resident. His name is Zac, he is a male man with a man's penis and testicles, and he isn't a woman.

Okay, we haven't had time to watch any of this (or indeed, any telly at all apart from the England vs Brazil match earlier) since the bungalowmates entered the bungalow. Don't worry, we're not about to become the sort of tiresome bores who wander around shouting at everyone how they don't watch Big Brother, we've got each highlight show and tonight's live show nicely SkyPlussed up for when we're less horrendously busy, and will report our findings in due course.

Luckily, we don't need to have watched any television at all to quickly flip to Wikipedia, Betfair, Photoshop and Microsoft Excel, so stat-hungry BB fans won't miss out on the latest edition of



Before we drop numbers, a few points of interest. Well, we say 'interest'.
  • We haven't watched Big Brother for a couple of days. Therefore it would be criminally negligent of us to allocate any bonus multiplier score/penalty for our current favourite and anti-favourite bungalowmates. A narrow escape for the squee twins, we're guessing.

  • Zak has jumped into first place in the betting, mainly because blokes tend to win Big Brother. This is reflected in the results, as he wins the 10% bump that goes with it.

  • Those editing the Wikipedia entry on BB07 are either taking a lot more care and research in their uncovering of everybody's past (or they're just taking everything in the red tops as gospel), as there's a shameful solitary [citation needed] between everyone (for Laura, as it happens). This is clearly unacceptable, and we encourage our readers to add as many stupid claims as possible to the entries for all the bungalowmates.

  • We've switched to the 'clustered bar with a 3-D visual effect' setting for the graph, as it'll give us room for the dozens of new people sure to be added in the next few weeks. And because it'll mean less fannying about with Photoshop to stop it spilling into the right sidebar on the blog. And yes, that was worth mentioning.
So, with no further ado, here come the numbers:



So, Emily and Nicki are still in the lead, but Zac (are we supposed to be calling him 'Ziggy'? Oh well) has zoomed straight into the bronze medal position. As he's a former boy band member, we're expecting lots more tabloid 'revelations' about him (mainly sourced from his agent, we suspect), so he could be a shoo-in for the big prize. Erm, that's the BrokenTV's Coverage of Big Brother Expressed Purely Via The Medium Of Not Very Complicated And Quite Possibly Incorrect Mathematics Special Winner's Certificate, not whatever you get for winning Big Brother, which of course is 'being quite famous for about three months'.

BUT WHAT ABOUT THE BROKENTV VIEWERS WHO DON'T LIKE BIG BROTHER? THEY'RE PEOPLE TOO!

Here you go. It's a test card. But wait, it's got Frank Sidebottom in it, and it's live action, and it's excellent.


Share:

Thursday, 31 May 2007

Big Brother 2007 (With Graphs): Part One

Now, we don't usually watch this, but in the interests of our viewer, we're going to try and stick with it for as long as possible. Our comprehensive review of the first instalment of the UK's most drawn out audition for fronting your own short-lived E4 series runs thusly.

Broadcasting equivalent of standing in front of the class and admitting what you just did aside, the show kicked off with a rundown of the rumours about the new series that aren't true (and which, presumably, had been leaked to the press by the production team in advance of the new series to maximise the viewing audience). Then we saw inside the house and... some other stuff happened and we kind of lost interest a bit.

What we need is to somehow distil each component (or housemate) into a series of numbers. It's the only way our fractured minds will be able to make sense of the screeching masses in need of a dignity transplant. That's why we've adapted our ranking system from the Celeb Big Brother to take in a whole new set of rankings, with bonus multipliers and everything.

Here's how it works:

As with our earlier system, the basis is the amount of words written in Wikipedia about each contestant. But! As a tribute to the way they keep on adding spurious trinkets to the house each time that everyone generally ignores because they're sunbathing instead, the following bonus multipliers are due to be applied to each word count:

+10% for each [citation needed] displayed in the contestant's Wikipedia rating – unverified facts are always fun

+20% for the current Betfair favourite to win

+10% for the second favourite

+5% for the third favourite

+10% for whoever we like the bestest of them all at any given moment

-15% for whoever's really getting on our tits

(You'll just have to imagine us reading the above bit out loud in a kind of faux-really-excited voice, just like Davina does on her tour of the house.)

We're really tempted to dock everyone an extra 10% for there being a new Trident Gum advert in the first ad break of the new series, but that would just be unfair. If you want to play along at home, our Excel formula for working out all of this is =SUM(B4+((B4*$C$2)*C4))+((B4*$D$2)*D4)+((B4*$E$2)*E4)+((B4*$F$2)*F4)+((B4*$G$2)*G4)+((B4*$H$2)*H4). Write that down. Of course, we reserve the right to add extra accumulators as the game progresses, especially if we can get an easy joke out of it.

So, what does that mean for the tenants of the Big Brother Bungalow?

Sam and Amanda Merchant

An annoying noise with four legs, the twins automatically won our vote as Most Annoying Person so far, docking them 15% of their word count of 47. Score: 44.65

Lesley Brain

Depending on whether the others see her as some sort of mother figure, or just some old woman with illusions of grandeur, will last a week, or ages. She still won't win, though. Score: 41.80

Charley Uchea

Despite getting booed, she seems relatively nice. Our current favourite, gives her points a boost all the way up to: 53.90

Tracey Barnard

Oh shit, it's Donny Tourette with a vagina. The bookies seem to like her, but we can't see her winning. We're betting she'll storm out of the house to make some sort of laboured 'point' within the first month, and claim it was something to do with a more pressing need to 'have it' elsewhere. Three [citations needed] give her score a boost, though. Score: 52.65

Chanelle Hayes

Who looks about as much like Victoria Beckham as we would if we just did our hair like hers. The second lowest score: 26.00

Shabnam Paryani

Quite extroverted, but in a way that isn’t too annoying. Yet. We suspect she could fall into the BrokenTV favourite column with the wind behind her. A bit of a shame that she’s currently last in the rankings, really. Score: 24.00

Emily Parr

Seems quite nice, although we’re not quite buying into the ‘indie’ personality until she mentions someone a bit more leftfield than Pete sodding Docherty. We’re tempted to offer her a bonus 25% if she can name more than one Pixies album, then we’ll see. The current leader, helped along by three [citations needed]. Score: 100.10

Laura Williams

Flying the flag for Wales. Seems okay, could turn out to be a ‘character’, which isn’t necessarily a good thing. Time will tell. Score: 66.30

Nicky Maxwell

Another relatively normal person who could well sneak into our favoured housemate category. It looks like they’re going for a controversy-lite series this year. Well, unless they chuck Freddie Starr in there at some point or something. Score: 82.80

Carole Vincent

Ah, there we go. It’s Millie Tant. Harsh, but fair, we feel. Score: 37.20

In summary then:



Expect regular updates when we get around to watching our Sky+ recordings of the highlight shows, or not if we get really ticked off with the whole idea of this. Hey, we’re not getting paid for this, you know. And if anyone’s expecting us to sit through Moyles, they can bally well piss off.
Share:

BTemplates.com

Blog Archive

Popular Posts

Labels

Blog Archive