You don't need that - there is a function called 'average'

=AVERAGE(Start Cell:End Cell)

Make the end cell ridiculously long way off like... column ATC And it ignores blank spaces, so calculates the true average

Nah what I mean is.... say 2 people from Team Australia vote, well all that the person who is counting the votes has to do is write in the cell designated that 2 people from Team Australia have voted, then the score will be added onto the total for the public vote (which then has to be adjusted accordingly so that it's a 50/50 voting system).

Maybe this will show it better.



So in this example, all the person tallying had to do is type in that 1 person from Chop 1 voted in the public vote, 2 people from Chop 2 also voted, and on and on and it'll add automatically onto their vote count.

Here's the spreadsheet now. https://docs.google.com/spreadsheet/ccc?key=0Avbvzkbauq_BdG11cnU3MkszdFQwOFVNdGxyWDNmMFE

Sorry, but google docs screws up all of the cell widths and formatting

oh right - i got around that by integrating the count function. Whenever someone from that country votes, you just enter a fullstop instead of a score. Then the spreadsheet counts the number of dots, multiplies that by the average and adds it to the score

Actually, that's a pretty smart idea. Now that I've got this working I don't think I'll bother though (putting a dot in probably would take just a little less time than counting up the number of votes from that team and adding it into the spreadsheet anyway).

+1

Why are you talking about Excel? We can do everything in PHP and Mysql, dont worry about that .

I will talk with Mark and see how we can start coding all this up...

Think the reason we drifted to Excel is because PhP and MySQL can be nice, but website coding tends to take its time. I could have a spreadsheet that tallies votes, averages, discards based on standard deviation, detects trends etc. knocked out in an afternoon.

Nice. But how are you going to manage such a huge amount of votes and chops in Excel?And all this without typing 1 number wrong...

Each round you will have to spend hours and hours typing all the votes for each chop while i spend just 1 second pressing a little button.

My excel spreadsheet worked fine last year. Even got adopted as the official one by iron chop i think .
It's not that hard to enter numbers from 1 to 10

Haha ok guys, you win. If you want to work with Excel, do it. I cant do anything against it.

But i think a clean code would be faster and much more easier for all of us.