Excel Spreadsheet to Tabulate Scores

Completado Publicado Sep 28, 2011 Pagado a la entrega
Completado Pagado a la entrega

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!

Programación en C++ Excel

Nº del proyecto: #1226614

Sobre el proyecto

4 propuestas Proyecto remoto Activo Sep 28, 2011

Adjudicado a:

domwakeling

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

$250 USD en 1 día
(11 comentarios)
3.7

4 freelancers están ofertando un promedio de $313 por este trabajo

abbie3290

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

$250 USD en 5 días
(22 comentarios)
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 en 1 día
(10 comentarios)
4.3
stanleyjob

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

$500 USD en 2 días
(0 comentarios)
0.0