Thursday Sheep

[kyro]

[ QUOTE ]
[ QUOTE ]
I am at 33 so far.

[/ QUOTE ]
i think youll need a longer lunch

[/ QUOTE ]

Somewhere, CPFB is reading this going "JAWS! JAWS! THE ANSWER IS JAWS!"

[Neil S]

I voted everyone gets points because it's probably easier to tabulate automatically than eliminating one-point answers, heh.

[amplify]

Do you guys tabulate it with countif? When I did that it took forever.

[kyro]

[ QUOTE ]
Do you guys tabulate it with countif? When I did that it took forever.

[/ QUOTE ]

I was adding up as I went along, but then I got 15 new submissions this morning and said "[censored] it"

[ScottHoward v3.1]

[ QUOTE ]
Do you guys tabulate it with countif? When I did that it took forever.

[/ QUOTE ]
i did just to get the totals for each answer, but then i had to manually find each person that said it.
i had my excel with the names as they were submittted. next time i arrange them alphamabetically like for sure. i think it will save me much time in assigning points.

[kyro]

I got submissions from...

kyro
Zurvan
books
Hbe
Neil
Bobo
amplify
fmxda
mute
FCBL
eskimo
MaxxDaddy
antidan
kokiri
Dustin
bravos
Alex
madtown
bojtun
lastchance
Siegmund
Jcool
shorty
dmk
Cueball
theSmell
UMTerp
nich
kbar
Herbie
patton
chuckles
scott

[His Boy Elroy]

I won't be around for the revealing of the answers, so I'm going to appoint Herbie as my surrogate cheering section. Do me proud buddy!

[amplify]

[ QUOTE ]
[ QUOTE ]
Do you guys tabulate it with countif? When I did that it took forever.

[/ QUOTE ]
i did just to get the totals for each answer, but then i had to manually find each person that said it.
i had my excel with the names as they were submittted. next time i arrange them alphamabetically like for sure. i think it will save me much time in assigning points.

[/ QUOTE ]
I did a replace all where I substituted whatever answer with the point value. "Turkey" = 7 and so forth. At least I got the thing to add itself up that way.

[ScottHoward v3.1]

[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
Do you guys tabulate it with countif? When I did that it took forever.

[/ QUOTE ]
i did just to get the totals for each answer, but then i had to manually find each person that said it.
i had my excel with the names as they were submittted. next time i arrange them alphamabetically like for sure. i think it will save me much time in assigning points.

[/ QUOTE ]
I did a replace all where I substituted whatever answer with the point value. "Turkey" = 7 and so forth. At least I got the thing to add itself up that way.

[/ QUOTE ]
still need to find each person (to list them in the reveal like I do)

[kokiri]

[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
Do you guys tabulate it with countif? When I did that it took forever.

[/ QUOTE ]
i did just to get the totals for each answer, but then i had to manually find each person that said it.
i had my excel with the names as they were submittted. next time i arrange them alphamabetically like for sure. i think it will save me much time in assigning points.

[/ QUOTE ]
I did a replace all where I substituted whatever answer with the point value. "Turkey" = 7 and so forth. At least I got the thing to add itself up that way.

[/ QUOTE ]
still need to find each person (to list them in the reveal like I do)

[/ QUOTE ]

meh, you want like 4 tabs,
1) entrant across the top x question number along the bottom, that you can dump the answers in,
2) that counts the score by countif on entry in matrix 1),
3) that takes a running total from 2) by question, and
4) an output in the right format for dumping into 2+2

you still need to find and replace for the people who can't spell hamerhead, but it should be pretty fast.


/nit