Excel Spreadsheet to Tabulate Scores

Completed Posted Sep 28, 2011 Paid on delivery
Completed Paid on delivery

This is for Judges that judge a state cheerleading competition. They will still us the “paper” based sheet to score the teams, but the problems arise with the tabulators!!!

INPUT SHEET FROM 5 JUDGES AND INFRACTION JUDGE: I would like to have where the tabulators get the 5 scores sheets from the 5 judges and the one safety infraction sheet. The tabulator will then take each sheet and input the scores from the 15 categories… The excel sheet will add up the total from the 15 categories and yield a total at the bottom. This will take place for all 5 judges. One column will need to be listed for deductions. This can be manually input on the separate spreadsheet (below).

MASTER SHEET: In addition, the total scores from the 5 judges will then, on a separate spreadsheet, be listed, high and low score dropped and then added up (see master score sheet). After they are added up, some formula (I hope) will be able to rank the teams. Obliviously, if there is only one team, they would be first. This sheet will need to be able to list up to 30 teams.

This may just have to be completed manually… TIE BREAKERS: if on the master sheet there is a tie… the high and low score will need to be added back in to break the tie ONLY between the two or more teams that were tied. The system CANNOT add back in the high and low and end up beating out the first place team (unless they were tied for 1st and 2nd)…

I can sent paper based examples!

C++ Programming Excel

Project ID: #1226614

About the project

4 proposals Remote project Active Sep 28, 2011

Awarded to:

domwakeling

Expert MS Excel user, I would be delighted to support you in this project. Look no further.

$250 USD in 1 day
(11 Reviews)
3.7

4 freelancers are bidding on average $313 for this job

abbie3290

I have gone through your requirements. Pleae check your PMB.

$250 USD in 5 days
(22 Reviews)
4.3
psprongs

Hi, I have good deal of experience in excel data processing. I can start immediately and can deliver this within a day. Please check PMB psprongs

$250 USD in 1 day
(10 Reviews)
4.3
stanleyjob

Hi, I'm a professional developer in C, C + +, c #, java, asm, python. I have extensive experience.

$500 USD in 2 days
(0 Reviews)
0.0