Quote:
Originally Posted by Gorrex
The problem I ran into was being and to reliably and programmatically get the full order of finish instead of top X (4-5). Ended up making it so anyone finishing past top X was considered as a loser to the last known finisher.
May have to revisit it and get the last little bit of work done on it.
|
I'm not sure I understand exactly what you are saying here, but I may have had a similar problem with regression analysis using Excel (I was a beginner).
I tried to use Excel to weigh several factors and produce more winners, but I was struggling with finish position. It was producing results that maximized the order of finish from 1st to last, but I wasn't interested in getting 7th, 8th, and 9th more accurate. I was only interested in getting more winners and maybe in the money finishes. Eventually I dropped the project because I was getting better results using trial and error than I was able to get from Excel. Someone with more experience probably could have figured it out.