J
joes4200
Guest
If there is someone out there that could help make the lane score sheet easier. or give an example you could send an attachment to joeschidek@hotmail.com
Overview:
You are going to create a program that tracks the scores for a season in a bowling league. This program needs to be very easy to use. In fact, Access, SQL Server, or VB on top of Access is one good way to attack this program. Using a web interface to a CGI database is also acceptable. VB accessing text files will work as well. VC on top of Access/SQL Server is OK as well (wicked hard). VC has wizards that connect to databases just like VB. Check the Win 32 App Wizards.
The league meets every other week. The players bowl anywhere from 1 to 3 games (typically 3). Each week, the teams play each other and give handicaps based on total team average. The teams will win if their team total is higher than the other team’s total, including a handicap. With three games the league tracks wins/losses per game plus overall pins. This gives 4 games per week. The overall pins goes to the team with the most pins over the 3 games. As a note: the team names are the names of their captains.
The league bowls on lanes 17 through 20. This means that there are 4 teams with 5 players each.
Program flow
v The program should perform like the following:
Ø User inputs the week’s data
Ø Program validates the week’s data
Ø User then tells program to update the season data
Program output requirements
v Player data sheet
Ø Player average (sort by this)
§ Total pins divided by number of games
Ø Player high game
Ø Player low game
Ø Player high series
§ Highest total pins for a week
Ø Player total pins (subsort by this)
Ø Player number of games (subsort by this)
v Team Standing
Ø Sort by Wins, then losses
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
v Lane score sheet
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.>>
Ø Two teams per player
Ø An entry for each player
Ø Three lines for scores for each player
Ø What alley the team is on
§ All teams must play on all lanes the same number of times in a season
§ You must determine a fair strategy to move the teams around
Ø The handicap
§ Difference in total team average
§ Whichever team has the lower average total will get the handicap
Ø Need a simple way to print different sheets for each week, based on the schedule
§ The code to automatically change the schedule based on the week is probably too much
§ A manual changing of team and lane assignments is OK
Program input requirements
v Weekly data
Ø User should be able to input player scores who bowled
Ø Program should allow you to skip players that did not bowl this week
Ø Program should account for players that bowl less than 3 games
§ Example: a player with 12 games bowled going into this week, can only bowl one game
§ Once the stats are entered, the program will reflect 13 games, and calculate the average based on 13 games, not 15
Ø Program should allow inputting of which team won or lost
§ Be advised that this code can get tricky
§ I will accept, without penalty, manual entering of wins and losses
§ There can be a maximum of 4 wins per team per week
v Interface
Ø The user should be presented with command buttons, in order, to do their task
Ø They should not have to type in 50 commands nor have to open certain queries in certain order
Ø Ie: you are coding for a non Access geek, you may assume an intelligent person, not Brenda
Program calculations
v Player average
v Hi game
v Low game
v Total pins per week
v Total pins overall
v Which team wins or loses
Ø You may force the user to enter this manually
Ø The amount of code to calculate wins/losses automatically is more than the amount of time to have the user calculate it manually.
v Wins/Loss percentage
Ø Number of wins divided by games played
v Total team
v Team Handicap
v More calculations may be necessary
Brenda Checks
All scores are between 0 and 300
Wins cannot be larger than 4
Two teams cannot be on the same lane
Overview:
You are going to create a program that tracks the scores for a season in a bowling league. This program needs to be very easy to use. In fact, Access, SQL Server, or VB on top of Access is one good way to attack this program. Using a web interface to a CGI database is also acceptable. VB accessing text files will work as well. VC on top of Access/SQL Server is OK as well (wicked hard). VC has wizards that connect to databases just like VB. Check the Win 32 App Wizards.
The league meets every other week. The players bowl anywhere from 1 to 3 games (typically 3). Each week, the teams play each other and give handicaps based on total team average. The teams will win if their team total is higher than the other team’s total, including a handicap. With three games the league tracks wins/losses per game plus overall pins. This gives 4 games per week. The overall pins goes to the team with the most pins over the 3 games. As a note: the team names are the names of their captains.
The league bowls on lanes 17 through 20. This means that there are 4 teams with 5 players each.
Program flow
v The program should perform like the following:
Ø User inputs the week’s data
Ø Program validates the week’s data
Ø User then tells program to update the season data
Program output requirements
v Player data sheet
Ø Player average (sort by this)
§ Total pins divided by number of games
Ø Player high game
Ø Player low game
Ø Player high series
§ Highest total pins for a week
Ø Player total pins (subsort by this)
Ø Player number of games (subsort by this)
v Team Standing
Ø Sort by Wins, then losses
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
v Lane score sheet
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.>>
Ø Two teams per player
Ø An entry for each player
Ø Three lines for scores for each player
Ø What alley the team is on
§ All teams must play on all lanes the same number of times in a season
§ You must determine a fair strategy to move the teams around
Ø The handicap
§ Difference in total team average
§ Whichever team has the lower average total will get the handicap
Ø Need a simple way to print different sheets for each week, based on the schedule
§ The code to automatically change the schedule based on the week is probably too much
§ A manual changing of team and lane assignments is OK
Program input requirements
v Weekly data
Ø User should be able to input player scores who bowled
Ø Program should allow you to skip players that did not bowl this week
Ø Program should account for players that bowl less than 3 games
§ Example: a player with 12 games bowled going into this week, can only bowl one game
§ Once the stats are entered, the program will reflect 13 games, and calculate the average based on 13 games, not 15
Ø Program should allow inputting of which team won or lost
§ Be advised that this code can get tricky
§ I will accept, without penalty, manual entering of wins and losses
§ There can be a maximum of 4 wins per team per week
v Interface
Ø The user should be presented with command buttons, in order, to do their task
Ø They should not have to type in 50 commands nor have to open certain queries in certain order
Ø Ie: you are coding for a non Access geek, you may assume an intelligent person, not Brenda
Program calculations
v Player average
v Hi game
v Low game
v Total pins per week
v Total pins overall
v Which team wins or loses
Ø You may force the user to enter this manually
Ø The amount of code to calculate wins/losses automatically is more than the amount of time to have the user calculate it manually.
v Wins/Loss percentage
Ø Number of wins divided by games played
v Total team
v Team Handicap
v More calculations may be necessary
Brenda Checks
All scores are between 0 and 300
Wins cannot be larger than 4
Two teams cannot be on the same lane
