J
John
This is for scoring duplicate bridge
essentially this:
Have five scores
1 40 1.5
2 100 3
3 40 1.5
4 400 4
5 -60 0
Want to award points from 0 to 4 as shown.
given second, what would a formula be in each cell of the third column
that would produce the score? ties are common and scores are given to 1
dec place by halves.
I have pretty much got nowhere with this so far.
Thanks for any help
John
essentially this:
Have five scores
1 40 1.5
2 100 3
3 40 1.5
4 400 4
5 -60 0
Want to award points from 0 to 4 as shown.
given second, what would a formula be in each cell of the third column
that would produce the score? ties are common and scores are given to 1
dec place by halves.
I have pretty much got nowhere with this so far.
Thanks for any help
John