OPR after Week Four Events

[Ed Law]

Originally Posted by DELurker

Ed,

There appears to be a minor discrepancy between the OPR Results and the CCWM Results page regarding the # of Events column. It looks like the CCWM page shows the number of events completed while the OPR page shows the number the team registered for. Is this an artifact of the calculations?

Yes I found an error in the formula for counting number of events. The one on OPR page is correct. The one on CCWM page only counts up to Column CC (PineTree) which is why events from Las Vegas and after do not show up. Last year there were less events that only went up to Column CC. I don't know why I would update the formula on one page and forgot to update it on another. It will be fixed next week.

Also I accidentally ran the macro on Toronto West because the color of the tab (green) for Week 5 is too similar to the color (blue) for Week 4. That is why the list of teams is gone. I manually copied the list of teams from last week's version onto the page CCWM Results and OPR Results but forgot to copy the # of Events column also. Hence all Toronto West teams will show one less in the # of Events column. It does not affect anything else. This will be corrected next week after the event is over. If you cannot wait, you can copy that column from Week 3 (Version 3.0) and paste into Week 4 (Version 4.0). Sorry for the confusion.