Completed

Excel Spreadsheet to Tabulate Scores

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!

Skills: C++ Programming, Excel

See more: tabulate scores, addition score sheet excel, tabulate score judge excel, judges master score sheet, excel spreadsheet cheerleading scores, spreadsheet tabulate, judge tabulator spreadsheet, competition spreadsheet scores, total safety, sheets add, programming in excel, programming for excel, programming competition problems, excel c# programming, excel add in programming, c programming competition problems, c programming competition, c programming break, competition programming, bottom up programming

About the Employer:
( 15 reviews ) Columbus, United States

Project ID: #1226614

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