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

<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>
[TD="class: xl65, width: 70"]Home Team[/TD]
[TD="class: xl65, width: 71"]Home Score[/TD]
[TD="class: xl65, width: 69"]Away Score[/TD]
[TD="class: xl65, width: 68"]Away Team[/TD]

[TD="class: xl65"]Team A[/TD]
[TD="class: xl65"]8[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl65"]Team B
[/TD]

</tbody>

In F1:G12

[TABLE="width: 118"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Margin[/TD]
[TD]Points Won[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]0
[/TD]
[/TR]
</tbody>[/TABLE]

In I1:J2

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> </colgroup><tbody>
[TD="class: xl65, width: 64"]Prediction[/TD]
[TD="class: xl65, width: 79"]By No. Points[/TD]

[TD="class: xl65"]Team A[/TD]
[TD="class: xl65"]1
[/TD]

</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.