Sports Prediction Quiz for GAA (Ireland)

[DavidMoran]

I am looking for a template to create a score prediction quiz with a leaderboard feature
the scoring will be as follows

40 points – Correct draw predicted.
[h=3] 20 points – Correct Winning Team predicted
10 points – Exact Margin of victory
9 points – Margin of victory within 1 point
8 points – Margin of victory within 2 points
7 points – Margin of victory within 3 points
6 points – Margin of victory within 4 points
5 points – Margin of victory within 5 points
4 points – Margin of victory within 6 points
3 points – Margin of victory within 7 points
2 points – Margin of victory within 8 points
1 point – Margin of victory within 9 points[/h]
Thank you

 

[steve the fish]

You may be able to adapt this:

In A1:B2

Home Team	Home Score	Away Score	Away Team
Team A	8	9	Team B

<colgroup><col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2523;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> </colgroup><tbody>
</tbody>

In F1:G12

Margin	Points Won
0	10
1	9
2	8
3	7
4	6
5	5
6	4
7	3
8	2
9	1
10	0

<colgroup><col><col></colgroup><tbody>
</tbody>

In I1:J2

Prediction	By No. Points
Team A	1

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> </colgroup><tbody>
</tbody>

Then the formula:

=IF(AND(B2=C2,J2=0),40,IF(IF(B2>C2,A2,D2)=I2,20,0)+LOOKUP(ABS(ABS(B2-C2)-J2),F1:F12,G1:G12))

Its probably not how you are set up but may give you some clues to whats possible.