Bits and Bobs 3

Malc · **Posted:** Thu Sep 11, 2008 17:38

Are these the number of people that have searched for those terms, or the number of people that have searched for those terms and clicked on the link to take them here?

I'm assuming the latter!

Malc

Grim... · **Posted:** Thu Sep 11, 2008 17:39

Yeah, the latter.

Goddess Jasmine · **Posted:** Thu Sep 11, 2008 17:40

37 amuses me.

Malc · **Posted:** Thu Sep 11, 2008 17:40

given that I only use spinglo sponglo on here why would anyone search for me to find this place?

Malc

Grim... · **Posted:** Thu Sep 11, 2008 17:48

There are better ones, actually. Let me make a nice list.

Grim... · **Posted:** Thu Sep 11, 2008 17:49

Code:

 beexcellenttoeachother
beteo
be excellent to each other
be excellent to each other forum
beexcellenttoeachother.com
gazchap
beex
be excellent to each other#
gazchap girlfriend
beteo forum
its.orson.welles cus
lacesensor comicalgnomes
beexcellenttoeachother polar bear
site:beexcellenttoeachother.com polar bear
beexcellenttoeachother forum
craster beteo
spinglo sponglo
beexcellenttoeachother forums
be excellent forum
be excellent to eachother
bezzie blogs rss feed
katania jane caslin seymour
tapestryshopped
beexcellenttoeachother gaming magazines
"drunken bakers"
beex forum
beteo excellent forum
drunken bakers
be excellent
gamesbiteltd
beex.co.uk
gkeche.com
filthy flatmates
fuppes wd mybookworld
gkeche
jbaktaskman certificate error
kryuss
phoenix festival 1996
pizza tycoon cities
pizza tycoon forum
rotateme certificate error mac
the drunken bakers
"because you have opted for a tv licence by"
"buy to let bastards"
"cheque rules" uk
"fambly cassette"
"fantastic contraption" "need to work"
"georgia invaded ostetia"
"hey hey it's saturday matinee"
"mrs. susan t. buffett"
"natacha gachnang" gp2
"of course it's shank or be shanked"
"ou degrees" employers inurl:forum
"phoenix festival 1996" "line up"
"race for life" "pathetic distance"
"rock band" pedal "remove the sensor"
"sistercheeba fakes"
"sitting on a giant goose"
"sonia saul"
"sporting swine"
"troubleshooting+washing machines"
"you have received this email because you have opted for a tv licence by email."
"you think that's baaaad?"
+"viva pinata" +"saved games"
+44-703-174-7806
365games affiliate
action plan for 2nd job interview
adywan star wars picasaweb
anti-compete clause legal?
anyone used gamesbite
azbekhia
batman parrs wood
battle of the halji +white dwarf
be excelelnt to each other
be excellent each other forum
be excellent forums
be excellent to each-other
be excellent to eachother forum
be excellent, to each other
be excelllent to each other
beteo salad
bioshock tape recordings transcripts
bjork phoenix festival
brigyn greenman
calypso cay scams
calypsocay scam
calypsocay.com
cex hanley branch
cex shops hanley
christian worst flatmates
datinglocked
diying a ginger beard
download "all is full of love radio string mix" mp3
download rotateme.cert file
dsl-g640 wireless bridge?
examples one line movie descriptions
excellent labia
excellent to each other
fantastic contraption alternatives
fantastic contraption armadillo
fantastic contraption four balls windmill
fantastic contraption spoiler tube
fatima mansions phoenix festival
fruit toffos
funneys video
games are getting easier
gamesbite legit
gaping anus of christ
gawdamn sploicers
geometry wars 2 pacificism tips
greenman fest brigyn
greenman festival deschanel
heroic people
highest pacafism score in geometry wars 2?
illegal "discussing underage sex"
istubble babliss
itrim istubble
jerry sadowtiz 2008
joker in batman as nurse the cark night
kidnapped madie
line up for phoenix festival 1996
live police controller
louisa preston bbc
malc74
malcseventyfour
man with luton van stroud
md4_raid1
meaning of propah
mental health ste mar discussions boards
mr2 3gse
mrchris+solicitor+stroud
netdisaster
nik joans
nuisance neighbours in dudley
paul stanfield customer service manager tv licensing
paul stanfield tv licensing
phoenix festival 1996 and review
phoenix festival 1996 line up
pizza game for pc
pizza tycon download
pizza tycoon edit character
pizza tycoon versions
rotateme +working +hacked
rotateme .cert
rotateme.cert download
sandylands arcade game with a boot
savygamer eternal sonata
scanwichita.com
school jabs,hpv
sefa greenman festival
sleepscreep
small claims court swindon
smartlogistics xbox live cards
solovair
solovair boots
solovair shoes
spore +"rude creatures"
statistics about speed kills,in graphs
tapestry-shopped
tax code 579l
throwball rules
top ten jokes edinburgh
tredair solovair
tron washing machine
truffle shuffle chunk animated gif
tryhard_fashionvictim
twatotron
ushare mybook boot startup
videoshopped gif
virgin sentena
wavetransit vst
wdc/fuel-gauge
whatyoushouldhavedone
wocus "stuart campbell"
woodsport mr2
xbox live "won't sign in" dashboard
you get the ankles and i'll grab the wrists lyric
zoe ball green man
zoe ball greenman
malc74 thunder bay 

Grim... · **Posted:** Thu Sep 11, 2008 17:50

"gaping anus of christ"

Squirt · **Joined:** 31st Mar, 2008 **Posts:** 6535

I bet the person who searched for "excellent labia" was pretty disappointed.

ElephantBanjoGnome · **Joined:** 22nd Dec, 2010 **Posts:** 8175

#13 is very strange.

Bobbyaro · **Joined:** 18th Apr, 2008 **Posts:** 11845

Guwuffle wrote:

ZOMG Spoiler! Click here to view!

Having thought about it a bit more, I'm not sure SUMIF is the answer, it would be if you wanted to just appraise the whole column, but the variable number of rows involved is scuppering me writing something using it. It would be dead easy if you could use variables in Excel formulas, but you can't.

I've got another idea though, I'll be back if I can get it to work.

EDIT

Right, this is a horrible bodge and assumes that you don't mind having 0s between all the averages.

If your original columns are A, B and C and you have a title header then in columns E, F & G from row 3 down you can put the following:

E: =IF(C3=0,IF(C2<>0,B3,E2+B3),E2/F2)
F: =IF(C3=0,F2+1,0)
G: =IF(C3<>0,E3,0)

This will give you the requested average in column G with 0s where there shouldn't be one. For a neater appearance you could then hide E & F and conditionally format G to white out the 0s.

If that doesn't make sense, PM me an e-mail address and I'll send you the .xls sheet I worked it out on.

Thank you for the effort! That should work nicely. I am (kind of) glad that it wasn't a really easy problem to solve.

Goddess Jasmine · **Posted:** Thu Sep 11, 2008 17:55

Good grief!

Malc · **Posted:** Thu Sep 11, 2008 17:58

Quote:

illegal "discussing underage sex"

!

Malc

Shin · **Posted:** Thu Sep 11, 2008 18:00

Grim... wrote:

I like #9

This was when I was investigating what he's said about me I think :/
Bastard....is nothing I do sacred?

myp · **Posted:** Thu Sep 11, 2008 18:01

ComicalGnomes wrote:

myoptika wrote:

A word of advice: if you decide to use Ryvita to make your sandwiches instead of bread, then don't do it the night before as they go all soft. Yuck.

I can recommend DR KARG as an infinitely superior alternative.

Yikes, I just checked out the fat content - it'd be healthier eating bread, man.

ElephantBanjoGnome · **Joined:** 22nd Dec, 2010 **Posts:** 8175

If I were mod I'd edit out that UNNECESSARILY LONG QUOTE by shin

Shin · **Posted:** Thu Sep 11, 2008 18:03

ComicalGnomes wrote:

If I were mod I'd edit out that UNNECESSARILY LONG QUOTE by shin

Haha, sorry I was going to edit it all out but the cats trying to fuck Mr.Snuffles. Will edit now

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 25673

Haha, rumbled Shin! Why'd you search for it 59 times, though?

Was that you searching all those times for 'Gazchap' also?

Shin · **Posted:** Thu Sep 11, 2008 18:07

Mimi wrote:

Haha, rumbled Shin! Why'd you search for it 59 times, though?

Was that you searching all those times for 'Gazchap' also?

(Puts her hands up) BUSTED

Yes, I am a shit Shinobiyoru! Bad Kat, very bad Kat.

59 times was probably because I am shit at using these things and it confused me at first-who knows why. I'm sure they aren't all me though

Nah that wasn't me-I searched a few times because I was wondering what he was like really. Oh now he's going to know I'm a creepy lady

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49232

Drunken Bakers?

Shin · **Posted:** Thu Sep 11, 2008 18:13

Who's bright idea was this anyway? Bastards...can you trace who's searched for what by the way? Just wondering is all

ElephantBanjoGnome · **Joined:** 22nd Dec, 2010 **Posts:** 8175

If it helps, nobody here believed that 'I was told by a friend to come here to promote his forum' bullshit.

Shin · **Posted:** Thu Sep 11, 2008 18:17

ComicalGnomes wrote:

If it helps, nobody here believed that 'I was told by a friend to come here to promote his forum' bullshit.

Actually, I wasn't asking because of that. And Colin did actually, he's on another forum called Twisted Reality he's made, which is not going so good. But that's mainly because we've got no idea what we are doing. If I was really joining a forum to stalk Gaz I would have joined everything he has, which I'm pretty sure I haven't done and I wouldn't have announced myself on here as his girlfriend. I'm really not that clever

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 25673

Shin wrote:

Mimi wrote:

Haha, rumbled Shin! Why'd you search for it 59 times, though?

Was that you searching all those times for 'Gazchap' also?

(Puts her hands up) BUSTED

Yes, I am a shit Shinobiyoru! Bad Kat, very bad Kat.

59 times was probably because I am shit at using these things and it confused me at first-who knows why. I'm sure they aren't all me though

Nah that wasn't me-I searched a few times because I was wondering what he was like really. Oh now he's going to know I'm a creepy lady

Still, I hear the advanced sales are looking healthy

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 25673

Shin wrote:

can you trace who's searched for what by the way? Just wondering is all

Bwah ha ha ha ha

Why'd you ask, Shin?

No, I'm pretty sure not, anyway.

Relax, the police will never find the evidence, anyway. 'Barbados', my foot.

Bobbyaro · **Joined:** 18th Apr, 2008 **Posts:** 11845

Quote:

diying a ginger beard

Quote:

katania jane caslin seymour

that's a pretty specific search going on there!

as is this:

Quote:

mrchris+solicitor+stroud

but this is my favourite:

Quote:

"race for life" "pathetic distance"

ElephantBanjoGnome · **Joined:** 22nd Dec, 2010 **Posts:** 8175

Bobbyaro wrote:

Quote:

"race for life" "pathetic distance"

That is fucking awesome, as I'm fairly sure I'm the person that called race for life a pathetic distance

Edit: YES! I WAS! HAHAHAHAHAHA

Shin · **Posted:** Thu Sep 11, 2008 18:28

Lmao! That's ace

In any case, I looked twice under GazChap's girlfriend or whatever the link was because he said, 'Oh, I've been talking about you to some people online' or something like that and I thought-'whoa!' because I didn't really like that fact because he could have been saying anything-and it's nice to know what people say about you honestly. It sent me to a 'pay' forum or something under his name and I left it at that. Then after Col made the site then we were looking for similar one's

He contacted me a few months ago on facebook and if I'd really wanted to sneak about and suss him out I'd have been quicker off the draw wouldn't I? In any case I asked him straight away when I'd found he was on this if he wanted me to leave as I would straight away

EDIT: Katania Jane etc was to find a very old forum I made when I was about 16. I was fanfictionalforum or something and I couldn't remember what it was called, this was the same time I was having a look round so I could get idea's for topics on Col's

Mimi-I asked because I think I did a weird one on there to see if it popped up anything and I didn't want people to think I was a pervert,lol

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 25673

haha, the mind boggles, but I shan't ask what it was.

Shin · **Posted:** Thu Sep 11, 2008 18:32

I'm not sure if I was googlewhacking or not after Gaz showed me the DVD about it.

http://z4.invisionfree.com/FictionalForum/index.php?act=idx

And there's the old forum I was after, back in the day

Curiosity · **Posted:** Thu Sep 11, 2008 19:14

Some of those are brilliant. Both the Gazchap stalking and the love of 'drunken bakers'.

MrChris · **Joined:** 1st Apr, 2008 **Posts:** 30498

Bobbyaro wrote:

Quote:

mrchris+solicitor+stroud

That's pretty fucking frightening, actually.

Shin · **Posted:** Thu Sep 11, 2008 19:58

Not me, before anyone says it

MrChris · **Joined:** 1st Apr, 2008 **Posts:** 30498

Man, I'm shallow in some ways.

We got hold of the Juno soundtrack, and there's some stuff on there by the Moldy Peaches and Kimya Dawson which I really liked. I thought Ms Dawson had a lovely, beguiling voice, and so I looked her up. Boy, was I disappointed to discover that this is the visage that goes with the voice:

This has happened before, of course - you assume someone with a pretty voice will be pretty when you see them, and when they aren't it's *such* a jolt to the system. Why is it that sound and visuals are so linked in this way in our heads?

Shin · **Posted:** Thu Sep 11, 2008 22:55

Mr Chris wrote:

Man, I'm shallow in some ways.

We got hold of the Juno soundtrack, and there's some stuff on there by the Moldy Peaches and Kimya Dawson which I really liked. I thought Ms Dawson had a lovely, beguiling voice, and so I looked her up. Boy, was I disappointed to discover that this is the visage that goes with the voice:

This has happened before, of course - you assume someone with a pretty voice will be pretty when you see them, and when they aren't it's *such* a jolt to the system. Why is it that sound and visuals are so linked in this way in our heads?

I do that at work, when a customer comes in I've been speaking with on the phone and they sound nice, so you assume they look it....it is a LIE. I try and draw a picture of them on my notepad before they come in and match it-sad games for sad office people

Dimrill · **Posted:** Thu Sep 11, 2008 23:00

Mr Chris wrote:

Is that Charlie Chuck?

MrChris · **Joined:** 1st Apr, 2008 **Posts:** 30498

You know when you have a packet of cheesy puffs, and you get a little blob of solid "cheesy"? I've just eaten two of those and I think I'm going to die.

Shin · **Posted:** Thu Sep 11, 2008 23:36

Mr Chris wrote:

You know when you have a packet of cheesy puffs, and you get a little blob of solid "cheesy"? I've just eaten two of those and I think I'm going to die.

They stick to the underside of my tongue when they do that. 'Cloying' is a good word for that I think

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49232

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 25673

Shin wrote:

Mr Chris wrote:

You know when you have a packet of cheesy puffs, and you get a little blob of solid "cheesy"? I've just eaten two of those and I think I'm going to die.

They stick to the underside of my tongue when they do that. 'Cloying' is a good word for that I think

It's quite similar to what the word 'cloying' actually means, as it happens. Cloying is something a little bit overbearing or sickly, which I guess the 'flavour powder ball' sort of is. Sort of overly rich, I think it means. Maybe that meaning was sitting in the back of your mind when you thought up the term?

Shin · **Posted:** Fri Sep 12, 2008 0:13

I think it had something to do with the cloying affect of the cat trying to suffocate me aswell. Words often just spring to mind. Cloying is also a way I described someone's perfume once-ick

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 25673

Oh, right yes, that's the right usage. I thought you meant that you had 'invented' the word 'cloying' to describe what you mentioned as the word bought to mind that feeling. Sorry, I totally misunderstood what you were saying. Maybe overtired

Shin · **Posted:** Fri Sep 12, 2008 0:16

Mimi wrote:

Oh, right yes, that's the right usage. I thought you meant that you had 'invented' the word 'cloying' to describe what you mentioned as the word bought to mind that feeling. Sorry, I totally misunderstood what you were saying. Maybe overtired

Me and you seem to do this a lot 0_o; hehe. This bastard paint things too frigging small to load. I know I'm overtired aswell

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 25673

I thought you had perhaps known the word in the back of your mind, but when searching for an appropriate word bought to imagination that one as it sounds almost descriptive of the feeling, which is how I had turned it around in my head, but actually I had just mentally inserted a couple of words into the paragraph you had written to make it read that way when I scanned it.

Shin · **Posted:** Fri Sep 12, 2008 0:27

I do this all the time, which is why half the time I have no idea what the hell is going on

metalangel · **Posted:** Fri Sep 12, 2008 7:47

I have had an incredibly sore throat for the last few days. And it's not because of being ill, either, as I'm otherwise completely fine (apart from being very irritable, due to having a sore throat).

I have a horrible feeling one of my notorious 'mouth ulcer at the back of my throat' things has occured again, but a glance in the mirror yesterday didn't reveal one.

Suffice it to say, my long weekend appears to be spoiled already by it. :'(

myp · **Posted:** Fri Sep 12, 2008 7:54

Ange is constantly (well, 2-3 times a year) getting tonsilitis, despite having her tonsils out years ago. It's really crap.

DBSnappa · **Posted:** Fri Sep 12, 2008 7:55

MetalAngel wrote:

I have had an incredibly sore throat for the last few days. And it's not because of being ill, either, as I'm otherwise completely fine (apart from being very irritable, due to having a sore throat).

I have a horrible feeling one of my notorious 'mouth ulcer at the back of my throat' things has occured again, but a glance in the mirror yesterday didn't reveal one.

Suffice it to say, my long weekend appears to be spoiled already by it. :'(

Organic honey, two teaspoons, juice of half a lemon, ground up ubuprofen, hot water. Gargle and swallow.

DBSnappa · **Posted:** Fri Sep 12, 2008 7:57

Mr Chris wrote:

Man, I'm shallow in some ways.

We got hold of the Juno soundtrack, and there's some stuff on there by the Moldy Peaches and Kimya Dawson which I really liked. I thought Ms Dawson had a lovely, beguiling voice, and so I looked her up. Boy, was I disappointed to discover that this is the visage that goes with the voice:

This has happened before, of course - you assume someone with a pretty voice will be pretty when you see them, and when they aren't it's *such* a jolt to the system. Why is it that sound and visuals are so linked in this way in our heads?

Miriam Margoyles is a good one for this. She did the Cadbury's Caramel bunny for their TV ads.
Also, the phone sex industry is wholly reliant on this, I would have thought.

myp · **Posted:** Fri Sep 12, 2008 7:59

Mr Chris wrote:

You know when you have a packet of cheesy puffs

Mr Chris, yesterday.

metalangel · **Posted:** Fri Sep 12, 2008 7:59

As is the phone-in-sex channels on Sky at night, right Nottingham bezzies?

MAKE ME C*M!!!

Be Excellent To Each Other

Bits and Bobs 3
Gloryholes n' all

Who is online

Be Excellent To Each Other

Bits and Bobs 3 Gloryholes n' all

Who is online

Bits and Bobs 3
Gloryholes n' all