[gvttc general] Monday League Stats

[Chris Fisher]

Hello All,
Unforcanutly as some of you have noticed the stats from last were not correct. Last week they showed multiple people with Zero wins which was not correct. Just to give a quick history lesson, the excel program that is used for the league was created back in 1999 (numerous modifications have been done since then) and is showing signs of its age. Not only has the Monday league had problems but the Wednesday league has as well which also is using the same excel program. The Tuesday League uses a different excel program since they only have 3 players per Team and play best of 7 games. This program works with only 36 people in the league.  While the Monday & Wednesday leagues can have more players and  have 4 players per Team and play best of 5 games.

This week, when trying to get the stats the below is happening when caculationing Table 4. Not sure why, but I’m the last person on this planet that can get into excel at the Marcos level and correct this. If anyone can, please contact me directly or tomorrow at RSG. I have already reached out to some people but with out any luck on fixing the issue.  Below are the screen shots of the issue. When clicking on the “Debug”, it’s showing the error is in the Marcos, but nothing has changed or been rewritten, so I don’t know why its happening. Going back to prior excels from a few weeks back yielded the same results.  So, unless this can get corrected, we will only be able to have Rating Central updated and have to

[cid:image002.png at 01D8370C.CFE53570]

[cid:image006.png at 01D8370C.CFE53570]


Now – For some good news…… A new program has been in the works for a little while and will be used for the next league.  I’m going to changed the last Ladder Week (3/21) to a Team Week. Team 1 will still have a Bye.  These issues will NOT affect Rating Central.  Rating Central has been update to included last week.


Sorry about this, I’m just as disappointed as you are. Thanks for your understanding.
Thanks
Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist3.pair.net/pipermail/gvttc.general/attachments/20220313/6e2da362/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 939D161AC7DD4C24908989A1EAEDA501.png
Type: image/png
Size: 162567 bytes
Desc: 939D161AC7DD4C24908989A1EAEDA501.png
URL: <https://pairlist3.pair.net/pipermail/gvttc.general/attachments/20220313/6e2da362/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 77BD61D0111D4870BB7AF74294E9004B.png
Type: image/png
Size: 135805 bytes
Desc: 77BD61D0111D4870BB7AF74294E9004B.png
URL: <https://pairlist3.pair.net/pipermail/gvttc.general/attachments/20220313/6e2da362/attachment-0003.png>