Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2012, 07:47 AM
furface00 furface00 is offline Spreadsheet Help Windows XP Spreadsheet Help Office 2007
Novice
Spreadsheet Help
 
Join Date: Feb 2011
Posts: 14
furface00 is on a distinguished road
Default Spreadsheet Help

Hello all



I have a spreadsheet I am trying to build for use with my Bridge club (Excel 2007).

The spreadsheet is required to randomly select teams each week to sit in four locations around the card tables using compass references as designations, ie: North/South & East/West. There is one exception. Team 1 for North/South must remain the same each week.

There are in total 27 teams. The maximum amount of tables allowed is 11. Not all teams play each week. The minimum requirement for a game to occur is 6 teams/3 tables.

I would like to keep a record of which teams played and which positions. Shifting teams around to different compass directions is an important aspect.


Is this possible or should I simply put names on paper and pull them out of a hat...

Thanks

David
Reply With Quote
  #2  
Old 12-14-2012, 08:30 AM
hanvyj hanvyj is offline Spreadsheet Help Windows XP Spreadsheet Help Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default

Quote:
Originally Posted by furface00 View Post
Hello all

I have a spreadsheet I am trying to build for use with my Bridge club (Excel 2007).

The spreadsheet is required to randomly select teams each week to sit in four locations around the card tables using compass references as designations, ie: North/South & East/West. There is one exception. Team 1 for North/South must remain the same each week.

There are in total 27 teams. The maximum amount of tables allowed is 11. Not all teams play each week. The minimum requirement for a game to occur is 6 teams/3 tables.

I would like to keep a record of which teams played and which positions. Shifting teams around to different compass directions is an important aspect.


Is this possible or should I simply put names on paper and pull them out of a hat...

Thanks

David
It sounded like a fun spreadsheet to put together, I couldn't work out a way of doing it without using a macro though (all it does is generate a list of random numbers that don't repeat!)

I have attached an attempt at what you want.

The list of teams can be included by putting an 'x' next to the team name in the list (add any teams you want).

A number is randomly generated for each team included, this number defines a seating position at a table - so each team will be placed at a random position at a random table.

If you want to save it, just copy the positions and paste "As values" into the next sheet.


What it does not do is make sure the same teams don't play each other twice each week! you can just press "randomise" again though if you don't like the turnout.
Attached Files
File Type: xlsm TeamCalculator.xlsm (24.5 KB, 7 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving spreadsheet to Windows 7 don madsen Excel 1 09-30-2011 03:37 AM
vba Code to Print Spreadsheet to PDF OTPM Excel Programming 3 05-25-2011 08:22 AM
Spreadsheet Help Creating a spreadsheet nickypatterson Excel 1 01-14-2010 03:21 PM
Spreadsheet Help Looking for a specific spreadsheet DivideByZer0 Excel 3 11-10-2009 05:58 PM
Spreadsheet Help Spreadsheet for words Rosie Office 3 06-15-2005 02:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft