Subject: RE: January Swim Challenge- NE POOLTRIOTSThen based on the wording of the "Number of members at goal" I had that equal the number of people on the team who had acchieved their stated goal (i.e. 100%) Therein lies the discrepancy. These numbers were through the 22nd, which is roughly 2/3 of the way through the month. Assuming an even distribution of distance throughout the month, anyone who has swum approximately 66% of their monthly goal is at their goal FOR THIS DATE. That's how it was calculated. Why? Because I'm Renee this month and that's how I want to calculate it. As to the Florida Force member that hadn't been reported, the spreadsheet has been updated with their current numbers. |