Analyzing Results Data

I would like some help analyzing some data that I accumlated. I have a spreadsheet that has multiple columns that are used to predict an outcome, each column is ranked from 1 to 10. So what I do is count up how many 1st ranked, 2nd ranked, 3rd ranked ect.. for each column. So what I would have is a table with columns telling me this column had 20 first ranked values that were predicted, 18 second ranked values that were predicted, ect... My question would be how can I analyzed this data to put a "weight" on these columns to make my predictions better. Hope this makes sense.

Thanks
Jeremy

Here is a small sample size of my worksheet. The bottom part of the sheet is the "winner" and rank from each column. Then at the top I count how many 1st,2nd, 3rd ect.. for each column. I want a good way of "weighting" the columns to more accurate predict the outcome. I dont even know if this is a good way of doing it, its just what I have come up with so far.




Samp.xlsx