Home / Products / Bespoke Applications /

Sports Results Processor

Bespoke Application Example - Sports Results Processor

Suddensource can provide you with bespoke software at a standard price.

Sports Results Data Processor
Type Bespoke Windows application
Client National sporting magazine, Peterborough
Brief To develop an application to allow data on athletes and sporting performances to be compared with master lists and national and internal standards, and also to have output in two formats: print-ready Word documents and database import files (for a national rankings system).
Description We developed an application to save the authors of a national sports magazine from the drudgery of checking athletes' names and times against published data and then typing results in a print-ready style.
Platform Visual Basic in Visual Studio 2005
Details The application we developed links with two databases:
  1. A data repository of existing standards, historical performance data and permanent data such as the location of venues and clubs.
  2. A database of the athletes and performances whose details our client collects on an on-going basis.
Data is collected every week from many sporting events, and the application is equipped with a number of import options to suit the most common ways in which the data is received. The data is first imported raw, and is then subjected to a series of checks:
  • Known or unknown venues
  • Known or unknown competitors (checking sex and age)
  • Valid event codes
  • Performance data in line with expectations
Once the data had been validated and discrepancies dealt with the details are output in two forms:
  1. Word documents are produced with known text and paragraph styles and with carefully crafted syntax;
  2. Data is written to an Excel sheet with preconfigured column names.
The data is output at regular intervals, according to intended use. Excel data is used to populate the repository referred to above, as well as other local and national databases. The Word output is copied into other systems (e.g QuarkExpress) where the named styles are used to produce print-ready page layouts. The import and output parts of the program have been redeveloped in Visual Basic .NET allowing us to deploy changes very quickly using ClickOnce when required.

Contact Us

To find out more contact us by email