M
manogolf
A mysql database dumps user generated form selections into an excel
spreadsheet. The form asks the user to select three choices from those
available. I would like to compare the selections the user made against
actual results. I'll try to illustrate.
A B C D E F G
1 18 25 0 0 92 7 67
2 X X X
3 X X X
4 X X X
5 X X X
6 X X X
Row 1 is the points awarded for selecting that column. Rows 2-6 represent
user selections. What is needed is a way to total users accumulated points
based on their selections. So user 4 accumulated the most points 0+92+67.
In truth there are around 100 users making selections from a list of 130+-,
but hopefully the illustration is representative.
spreadsheet. The form asks the user to select three choices from those
available. I would like to compare the selections the user made against
actual results. I'll try to illustrate.
A B C D E F G
1 18 25 0 0 92 7 67
2 X X X
3 X X X
4 X X X
5 X X X
6 X X X
Row 1 is the points awarded for selecting that column. Rows 2-6 represent
user selections. What is needed is a way to total users accumulated points
based on their selections. So user 4 accumulated the most points 0+92+67.
In truth there are around 100 users making selections from a list of 130+-,
but hopefully the illustration is representative.