Subject: RE: ABS CORE May-June Captains onlyOK Captains. Here are the Week 1 results, Team Blue has a slim lead, BUT they are also the team with the most no workouts in week 1 and to prevent averaging calc issues, 0's are not calculated in the percentage averages. So in reality they are not in 1st place try as they may ! I attached the full 'All Teams' spreadsheet file (ZIP). I changed a team member from Red to Black that was an over site, so Jonny Bee is now on Black not Red. Also I updated the weekly 'sessions/week' YES or NO determination to be based on the % of the challenge (weeks) * the 'Weekly Totals'. This actually works now as you can see weekly who's on/near pace or way behind. To update your team file, download the 'All Teams' file and delete the worksheets for the other teams that are not needed and resave as your team file. Let me know if you have any questions...Happy crunching! Week 1 May & June ABS/Core Challenge Compiled Results | Team Results | Black Team | Red Team | Green Team | Blue Team | Average % of Goal | 8.42% | 9.62% | 10.89% | 11.72% | Overall Goal met % | 0.00% | 0.00% | 0.00% | 0.00% | Teams Combined % | 4.21% | 4.81% | 5.44% | 5.86% |
Attachments ---------------- All Teams May June-ABS-Spreadsheet-wk1.zip (48KB - 32 downloads) |