5

Final results:

October 3, 2011 15:30 pm

Thanks very much to our winner, Monica Cellio, and to all of the other contestants for everything they did to promote our excellent Jewish Q&A content!

I've started an ongoing score chart for the Ingathering Contest.

I won't necessarily update this every day. If anyone is interested in helping keep it updated, please let me know.

This image will automatically stay up to date with the chart: Ingathering Contest Score Chart

8
  • 2
    +1 Cool! Good use of Google gadgets.
    – WAF Mod
    Commented Sep 14, 2011 at 2:05
  • 1
    I guess the "submit-new-question" strategy worked.
    – Ariel K
    Commented Sep 15, 2011 at 17:27
  • 2
    @Ariel, yes, for a good head-start, but the contest is yet young ...
    – Isaac Moses Mod
    Commented Sep 15, 2011 at 17:39
  • @Ariel, I decided to try it to see what would happen because nobody else had. I wasn't actually planning to enter, but 20 minutes before the start I thought of a question to try. But by tomorrow it'll likely be off the front page and that'll change everything, I suspect.
    – Monica Cellio
    Commented Sep 16, 2011 at 3:06
  • 1
    Its OK, this isn't the highest stake contest and everyone could have picked a recent one also.
    – Ariel K
    Commented Sep 16, 2011 at 4:09
  • I think it will be interesting to see how the different approaches play out. Day 3 of a 3-week contest is way too early to draw conclusions. (Pity nobody picked a question specific to this season to see how that would work.)
    – Monica Cellio
    Commented Sep 16, 2011 at 13:00
  • 2
    @Monica, while the initial results are largely dependent on which question you each chose to bet on, I'm hoping that at least some of you will do some actual ingathering via social networking, blogging (as I know you've already done), seeding your favorite celebrity twitterer, etc., with effects that dominate the question-selection effects.
    – Isaac Moses Mod
    Commented Sep 16, 2011 at 13:37
  • 2
    A lesson learned so far for me: I find it very difficult to ask people to go look at my own stuff (a question, in this case); I find it much easier to pitch the site in general or specific questions from other people, both of which I've done before. I wonder if it's just me or if others are having this difficulty too. (Also I seem to not be very good at it; mentions in my blog and G+ don't seem to have brought a lot of traffic, and a mailing list I also tried to use seems to be down at the moment. :-( )
    – Monica Cellio
    Commented Sep 23, 2011 at 1:05

1 Answer 1

Reset to default
2 
=(IF(RANK(C1,C1:C5)=2,C1,IF(RANK(C2,C1:C5)=2,C2,IF(RANK(C3,C1:C5)=2,C3,IF(RANK(C4,C1:C5)=2,C4,IF(RANK(C5,C1:C5)=2,C5,0))))))/MAX(C1:C5)

(Works in Excel 2008 for Mac; I don't know about Google Docs.) This finds the percentage of the top score the second-highest score is, where C1 to C5 are the scores at any point in time.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .