I'm not sure if this goes here or in handicapping but I'll start here.
My little database program crunches data from up to a years worth of races and then outputs it to a comma separated values (.csv) file that I then open in Excel and do my analysis. Once upon a time I also had an analysis program but it was extremely awkward to use and even more difficult to modify. Excel is much easier.
So I run the program and now I have this large .csv file that I want to analyze.
First I sort the data by surface and distance. I recorded a marco to do this but after that, I have to manually* copy all the dirt sprints, dirt routes, turf sprints, turf routes to separate sheets in order to do more specific analysis. I need a marco to do this work for me.
I can record simple macros, like sorting by surface and distance, but in order to move dirt sprints to the DIRT SPRINTS tab, the macro has to be able to tell if column E is D(irt) or T(urf) and it has to tell if column D is greater than or equal to 1100 but less than 1760 (yards).
While I am sure I could figure this out (given enough time), I was wondering is anyone has this already worked out and could slip me a spreadsheet with it in there?
I had not thought of that. I think maybe this could be done. I'll need to sit and ponder a bit and see what I can come up with but I'm still interested in the marco.
Thanks for the offer Biniak but I think I'm going Dave and Ranch's route. Although my first "route" was going to be a "right turn", it looks like I may have to do this with "three lefts".:rofl: