Bowling Tournament Database
Budget: $750 – $1,500 USD
I need a small-footprint database (MS Access) that lets us manage a 10-pin bowling tournament season after season.
Data flow
• I will be dropping clean .xlsx sheets into the system; a simple importer should map the columns I specify, run only basic type/blank checks, and feed the records into the tables. No heavy validation rules—just stop obvious data-type mismatches so I can fix them before posting.
• Existing tables include Bowler data, Accepted Entries, Verified Entries, and Event Ledger (which tracks which optional events bowlers are participating in).
• Handicap is calculated automatically from the average I key in.
• Otional contests are based on a simple Yes/No toggle coming from the Event Ledger - Tournament Insurance, Best 3 of 9, Optional Scratch (by division), Seniors (55+ bowlers), Youngbloods (35- bowlers) with flags pulled from the Event Ledger.
• Average ranges will also drop bowlers into Divisions A through E and caclulate the handicap based upon an established formula.
• The number of teams (and thefore bowlers) may vary from event to event (this needs to be a configurable variable for each event).
• Bowlers may be added to the database without team and doubles assignments as they may register as substitutes to be assigned to teams/doubles as-needed.
• Optional "Mega Bracket" consisting of 64 bowlers, 32 on each side, will be caculated based upon entered scores - Bracket "boards" that will be defined prior to the tournament and will leveage six scores (per board) in various defined combinations - e.g. (Teams/Doubles handicap scores, Double/Teams handicap scores, Doubles/Teams scratch scores, Teams/Doubles handicap reversed scores (where the scores are used in reverse order T3 then T2, then T1, then D3, then D2, then D1). The number of boards will be configurable. Any score ties in the brackets will be broken using the next score in the series.
• Users must be able to make adjustments/corrections to records as-needed (e.g. updating bowler contact information, moving bowlers between teams and doubles pairs, etc.
• Lane assignments will be added after teams/doubles-pairs are established
Core structure
Each tournament is tagged by year. From the player pool I must be able to:
• slot bowlers into teams of four,
• pair them into doubles, and
• flag an optional “Dark Horse” doubles team that the program builds automatically (DHD team creation has constraints (e.g. bowlers cannot be paired with themselves, no duplicate teams), the number of DHD entries will be determined from registration, there is no maximum number of entries per bowler.
Data entry
• For every participant the system needs quick screens for four sessions—singles, doubles, teams, and optional no-tap—each consisting of three games (no-tap may be two or three games and scores are only entered for those bowlers who enter via registration).
• Score entry will be done it the same order as the shift score sheets are printed.
• Mega Bracket entries will be keyed in using Entry IDs for each of the 64 brackets.
• Each defined event/contest needs to have a payout variable set to determin the number of winners on the the respective leader boards, e.g. 10:1 or 8:1.
Reporting & calculations
Once scores are in, I want one-click reports that show:
• The logo and tournament name for each event should be configurable for reports,
• prior to score entry, lane score sheets will be printed with bowler records sorted by lane number
- Teams will be sub sorted by bowler position number
- Doubles will be sub sorted by entrance ID - with the partner of the odd lane placed in the same position on the even lane (e.g. doubles team 10 will have bowler A on lane 3, position 1, and bowler B on lane 4, position 1, doubles team 11 will have bowler A on lane 3, position 2, and bowler B on lane 4, position 2, etc.)
- Singles will be sub sorted by entrance ID
• singles, doubles, and team scratch and handicap totals,
• individual all events rankings (high handicap score of singles, doubles, teams scores combined)
• Dark Horse doubles results,
• division-level, senior-only, youngbloods-only leaderboards,
• overall tournament summaries I can export back to Excel or PDF,
• Mega Brackets boards/reports can be generated after each game is entered to provide "still alive" lists and charts,
• A "tournament insurance" list will be generated with bowlers that elect to purchase an entry as part of their registration.
Please include a brief outline of your proposed tables or entities so I can see how you’ll map bowlers, events, and scores, plus the language or toolset you will use for the importer and report generation.
Data flow
• I will be dropping clean .xlsx sheets into the system; a simple importer should map the columns I specify, run only basic type/blank checks, and feed the records into the tables. No heavy validation rules—just stop obvious data-type mismatches so I can fix them before posting.
• Existing tables include Bowler data, Accepted Entries, Verified Entries, and Event Ledger (which tracks which optional events bowlers are participating in).
• Handicap is calculated automatically from the average I key in.
• Otional contests are based on a simple Yes/No toggle coming from the Event Ledger - Tournament Insurance, Best 3 of 9, Optional Scratch (by division), Seniors (55+ bowlers), Youngbloods (35- bowlers) with flags pulled from the Event Ledger.
• Average ranges will also drop bowlers into Divisions A through E and caclulate the handicap based upon an established formula.
• The number of teams (and thefore bowlers) may vary from event to event (this needs to be a configurable variable for each event).
• Bowlers may be added to the database without team and doubles assignments as they may register as substitutes to be assigned to teams/doubles as-needed.
• Optional "Mega Bracket" consisting of 64 bowlers, 32 on each side, will be caculated based upon entered scores - Bracket "boards" that will be defined prior to the tournament and will leveage six scores (per board) in various defined combinations - e.g. (Teams/Doubles handicap scores, Double/Teams handicap scores, Doubles/Teams scratch scores, Teams/Doubles handicap reversed scores (where the scores are used in reverse order T3 then T2, then T1, then D3, then D2, then D1). The number of boards will be configurable. Any score ties in the brackets will be broken using the next score in the series.
• Users must be able to make adjustments/corrections to records as-needed (e.g. updating bowler contact information, moving bowlers between teams and doubles pairs, etc.
• Lane assignments will be added after teams/doubles-pairs are established
Core structure
Each tournament is tagged by year. From the player pool I must be able to:
• slot bowlers into teams of four,
• pair them into doubles, and
• flag an optional “Dark Horse” doubles team that the program builds automatically (DHD team creation has constraints (e.g. bowlers cannot be paired with themselves, no duplicate teams), the number of DHD entries will be determined from registration, there is no maximum number of entries per bowler.
Data entry
• For every participant the system needs quick screens for four sessions—singles, doubles, teams, and optional no-tap—each consisting of three games (no-tap may be two or three games and scores are only entered for those bowlers who enter via registration).
• Score entry will be done it the same order as the shift score sheets are printed.
• Mega Bracket entries will be keyed in using Entry IDs for each of the 64 brackets.
• Each defined event/contest needs to have a payout variable set to determin the number of winners on the the respective leader boards, e.g. 10:1 or 8:1.
Reporting & calculations
Once scores are in, I want one-click reports that show:
• The logo and tournament name for each event should be configurable for reports,
• prior to score entry, lane score sheets will be printed with bowler records sorted by lane number
- Teams will be sub sorted by bowler position number
- Doubles will be sub sorted by entrance ID - with the partner of the odd lane placed in the same position on the even lane (e.g. doubles team 10 will have bowler A on lane 3, position 1, and bowler B on lane 4, position 1, doubles team 11 will have bowler A on lane 3, position 2, and bowler B on lane 4, position 2, etc.)
- Singles will be sub sorted by entrance ID
• singles, doubles, and team scratch and handicap totals,
• individual all events rankings (high handicap score of singles, doubles, teams scores combined)
• Dark Horse doubles results,
• division-level, senior-only, youngbloods-only leaderboards,
• overall tournament summaries I can export back to Excel or PDF,
• Mega Brackets boards/reports can be generated after each game is entered to provide "still alive" lists and charts,
• A "tournament insurance" list will be generated with bowlers that elect to purchase an entry as part of their registration.
Please include a brief outline of your proposed tables or entities so I can see how you’ll map bowlers, events, and scores, plus the language or toolset you will use for the importer and report generation.