NBA schedule creater

hungchan

New Member
Joined
Mar 20, 2002
Messages
2
You have been asked to assume the administration of the Wednesday Night ¡§pick-a-sport (pool/darts/bowling/spelling/whatever)¡¨ League. The league plays every Wednesday evening over an 11 week period. Each team plays games at ¡§Home¡¨ and an equal number of ¡§Away¡¨ games. There are 11 teams in the league.

„h Your first task is to circulate an individual schedule to each team.
„h The previous organizer has left you with a worksheet that lists the teams by name, the address at which their home games are played, a contact phone number, and a unique team number. (See Figure 1 Below.)
„h You need to devise a master schedule worksheet that will let each team play each other team once. (See Figure 2 Below)
„h Then you need to create a worksheet that will generate a customized schedule for any one team. (See Figure 3 Below)
„h This sheet will allow the user to enter the number of any team, and then displays the team¡¦s name and location at the top of the schedule.
„h Below that it will list the date, opponent, and status (Home or Away) for each game for the season.
„h For ¡§Away¡¨ games it should also list the address at which the game will be played.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,213,535
Messages
6,114,192
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top