USAWA

By Eric Todd

Thanks to the tire less work of our records director and his team, we have a new update to our records list and century club. They have been not only making updates, but also polishing things up by correcting errors and such. The most exciting thing is the additions to our century club. I already posted on the additions of Everett Todd and Stephen Santangelo recently. Well, we have a few more to mention. In the men’s division, John Monk comes in at 140 records. Since he has not competed in the USAWA since around 2009, this was clearly an oversite on our part. Tony Lupo comes in at 107 records, while Dan Wagman sits at 100. The biggest movers in the men’s side are both from Clark’s Gym. Bill moves up two spots from #10 to #8 with an additional 34 records. Dave DeForest jumps up 6 spots from #21 to #15 with an additional 57 records. This brings the men’s club up to 34 members.

In the Women’s division we have a new Century Club member as well. Janet Thompson, of Clark’s gym comes in at 101 records and makes the company of the women’s club seven members. The biggest mover in the Women’s club is Phoebe Todd moving up one spot to number 4 by way of twenty four additional records.

It is an honor to become a member of the century club. The Century Club was something that Al Myers came up with when he was Secretary/Treasurer to motivate lifters to participate lifters to have fun while participating in USAWA events. Congrats to all members, particularly this who just reached the 100 record milestone.

Over the coming weeks I plan to overhaul the record list data.

This is possible due to the outstanding help of Sanjiv working in the background to keep me afloat. As I once did for Al when he was records director, Sanjiv has offered to assist, and so began taking on the worst part of the process; organizing the website data into a format that makes life easier. 

We have some new gung-ho members promoting meets with guns blazing and Bill’s Gym has had a mammoth resurgence on the meet/ records front no name a couple.

So, a big thank you to Sanjiv and his enthusiasm, he has made a big difference to keep me on top of the updates and this is now affording me time to make long wanted changes.

NOTES TAB
In the next update you will see a new tab added to the records excel; “NOTES”.

The plan is to note any corrections here. It will contain a copy of the changed record, who requested and who changed it and why.

The initial notes list you will see contains some records which had to be removed because they were given in err. (The person who found the error is listed just for our ease of if future research is necessary, but if you do see a mistake/lift issue in the sheet and do not want your name listed please state in your correction email.)

Unfortunately, there will be more removals due to my early misunderstanding of an “out of meet lift at Nationals” counting as a NAT lift, my apologies.

MEET NAMING
I am reworking the meet names for some consistency.

Record days will have the pre-fix “Record Day -“

Major USAWA meets will be in CAPS; NATIONALS (yr) – name, POSTAL – 1st QUARTER/POSTAL 2nd QUARTER etc.

Recent example;
89 Nationals – Pl. Meet
1989 Nationals – Plymouth

1999 Nationals – Ambridge
99 USAWA Nationals – Amb

both meets changed to;
NATIONALS (89)- Plymouth (Day 1)
NATIONALS (89)- Plymouth (Day 2)

NATIONALS (99)- Ambridge (Day 1)
NATIONALS (99)- Ambridge (Day 2)

EDIT
I’ve noticed later two day meets are listed under one name using the final days date for all lifts.
I will begin grouping old meets with two dates to follow that trend. So the changes above will become NATIONALS (89)- Plymouth, NATIONALS (99)- Ambridge. SJ

WORKING ON
Tried a new layout to consolidate the lines in the excel workbook which took over 17000 lines to 13500 odd, but while testing with formulas I discovered some typos/date errors and inconsistencies which I am correcting.

This layout test removed the ALL and NAT individual lines while adding two columns after age group, so ALL and NAT could be listed in each next to the lifter who owns them.  Note, no change to the layout is planned, this was a test of an idea to ponder but the process did help to find some hidden issues.

SJ

Here is the work the video submission committee did for the membership to consider moving forward.