I need an excel spreadsheet created for a Couples Pool League. There are two parts.
PART I - Calculating Team Averages
There are 6 teams with 2 people per team. (Team 1, Team 2, etc.) There are 12 weeks to the season. I need to calculate the averages per week.
PART II - Team Line Up
We week, each team will play four games. So on week 1, Team 1 will play Team 2, 3, 4 and 5. On week 2, Team 1 will play 6, 2, 3 and 4. On week 3, Team 1 will play 5, 6, 2 and 3. All teams need to rotate and a schedule for EACH team needs to be made.
I would like the above created in Excel (I use Office XP) and reusable so I can track various nights of leagues. (Division A plays on Wednesdays, Division B plays on Thursdays, etc.)
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Windows XP, Office XP, Excel