Year To Date combined results

[jluther820]

Does anyone have a good method of aggregating monthly club match results to calculate year to date standings?

Our club gives some prizes based on year end standings, but we currently have to aggregate the scores manually in a spreadsheet.

The process is tedious and error prone, t here must be a better way, I am open to suggestions and would really appreciate the help.

[Skydiver]

I've written a small program that computes the scores like for:

http://northwestsection.org/nws2012/2012.html

http://northwestsection.org/nws2011/2011.html

In the end though, it computes the match percentages, not the cumulative match points. It looks like you are looking for match points.

Anyway, the way the program works is that it reads in the webfile.txt that gets uploaded to USPSA. The program has to recompute the scores because we throw away scores from non section members, but in your case, you should be able to to just keep the scores already computed in the webfile.txt.

Be aware that you can load the webfile.txt into Excel. This makes the task less error prone and is what I had done in the prior year before I wrote my program.

[jluther820]

I've written a small program that computes the scores like for:

http://northwestsection.org/nws2012/2012.html

http://northwestsection.org/nws2011/2011.html

In the end though, it computes the match percentages, not the cumulative match points. It looks like you are looking for match points.

@@@This looks like what I am looking for, or a great start, is it somthing ou can share? Or share more info on?

Anyway, the way the program works is that it reads in the webfile.txt that gets uploaded to USPSA. The program has to recompute the scores because we throw away scores from non section members, but in your case, you should be able to to just keep the scores already computed in the webfile.txt.

@@@I would like to aggregate for all shooters so I can have some sort of cross check built in.

Be aware that you can load the webfile.txt into Excel. This makes the task less error prone and is what I had done in the prior year before I wrote my program.

@@@I tried this once before and it didn't feel too successful, perhaps focusing on the web file will help.

See reply above, I marked them with @@@. I would like to find a solution that doesn't require an excel wizard, or I'll never divest myself of this task...

Edited September 13, 2012 by jluther820

[jluther820]

"Divest myself of this task" ... I know...no such thing LOL

[Skydiver]

PM me your email address and I can either give you read access to bitbucket.org for you to grab the source code, or I can email you a zip file with my current source.

By default the program includes everybody, I have UI where I can mark non-members to take them out of the running. You can just always leave everybody in. I also have code that locks in people's classifications for the year with special handling of unclassified shooters who enter the series late. You probably just want the latest known classification.

So the the only major things to change are:

- display match points instead of match percentages

- add up a sum of all match points to date instead of computing average of best 3 (or best 4)

- disable code that locks in peoples classification for the year

[jluther820]

Pm sent