Steve:
Having a list of t40 is on my list of priorities about 5 feet below the water table.
While you think that it can be done from the top ten list, I think that any conclusions from that list would be faulty at best. But if you want it and think it can be done, contact the Records and Tabulations committee, tell them about what you would like to see done. Then at the end of the email/letter, put your address and telephone number and say, "I am willing to chair a committee to put the plan together, describe how it will work, answer the questions and pull the information together for the next five years." ( I figure it will take about five years for it to be "institutionalized.")
Please do not expect other volunteers to take on this big project, just because you would like to see it done. If you want it done, you are going to have to carry the water.
best of luck with it
michael
OK, folks, it's time to ante up or get out of the game. While a complete list of swim times is not so important to some swimmers, it is to me. I have thought about this problem for over 10 years without taking any action.
I agree with Michael Moore that having it mandated to the USMS via our local LMSC groups will take at least 5 years. I'm old enough to remember the 5-year plans from the former Soviet Union too!
So, I'm just going to start on this myself & see what comes of it.
In consultation with Jim Matysek, I've taken the files for the Pacific SCY championship meet and am in the process of creating an SDIF file that can be imported into the USMS database. It's taken quite a bit of fooling around initially but, in the long run, I think I would have to invest less than 2 hours to do this in the future. That for a meet with 823 swimmers. This is a big harvest for the database.
The process involves saving the HTML file to a text file by copying it into a word processor such as Notepad. The saved file can then be imported into Excel and, with the help of a custom template and some custom macros, converted to an SDIF file. I have the men's results ready to go and the women's results will be done by early next week. If this works, it will appear in the database by the time Jim gets back home.
As for completeness, we can never guarantee completeness. However, I have trolled around on the LMSC web sites in past years looking at meet results, trying to anticipate what my standing in a particular event might be. I've gotten pretty close in most cases.
So, we would need to find out what meets are in the database for a particular course season. As a starter, we could cajole meet directors to create the SDIF files if they have the meet data. This is what Jim did to me for the Arizona meets which are now ALL in the database for 2002. Once this is skimmed off, we can fish for other meets not represented and do the conversions.
I think this can be done without bringing up any legislation either at the local or national level, and have a pretty good database. It is not going to be perfect, however. Neither is the top ten. I know of at least one case where a TT chairman missed a deadline & those swimmers slipped through that filter.
Anyone else in the game?
mel dyck
The results from the 2002 Pacific SCY championship meet have been converted to an SDIF file and Jim Matysek has posted them on the USMS database. There may still be some errors because the data required quite a bit of hand fiddling to get them into the right format. Look them over...
mel
You can get the results in SDIF format from the 2002 NE SCY Championship (670+ swimmers) at:
www.swimindex.com/.../results.html
You know have the results from the two largest regional championship meets for SCY 02 season.
Thanks for taking this on
Bob
Since you asked for it.
An SDIF file for the Pacific Masters Championship is posted on the Pacific Masters web site at
www.pacificmasters.org/.../results.shtml
The file is a big one - about 1.2 MB.
Also on the same page is an SDIF file for the Walnut Creek Long Course meet.
The top 16 times of the championships by sex by event (all the age groups together) is at
www.pacificmasters.org/.../02cruzscy16.html
The top ten times of the Walnut Creek LCM meet by sex by event is at
www.pacificmasters.org/.../02wcmlcmtop10.html
I sent the sdif files to Jim Matysek for consolidation and posting on the USMS web site.
have fun with it.
michael
Spectacular Michael!!
These will be great additions to the USMS database. I managed to create a pseudo SDIF file from your previously published HTML file but it had a problem with the women's 500 free for some reason I haven't been able to sort out.
This should clear that up.
Also, I'm going to try to have a complete LCM set of files (daydreaming, of course, but the number of meets is smaller so the chance of getting it done is somewhat better) and your results for Walnut Creek will help.
Again, thanks for the help.
mel dyck
