For a two-opponents competition, you bet the result of each match :
- 0 point if you mistook
- 2 points if you are correct with a 1 point bonus if the score is correct
The winner is the one who has the most important accumulated points.
Here, it is a example for the euro 2016.
- Go to Google Drive and create Google Sheets
- Customize your Google Sheet with freeze row and colors, respectively in :
View > Freeze
andFormat > Conditional formatting...
- Write your script to define your own functions in
Tools > Script editor...
- Here :
- Score total is obtained with
=SUM(E2:E100)
- Score total is obtained with
=COMPARE_RESULT(C<i>:D<i>)
where<i>
is theith
row. - The colums C and D should be in Plain Text in
Format > Number > Plain Text
.
https://www.google.com/script/start/
- File with extension
.gs
as Google Sheets UPPER_CASE_UNDERSCORE
for public functionslower_case_underscore
for private functions
https://developers.google.com/closure/compiler/docs/js-for-compiler