Dennis McDermott
Freelance Database Systems and Web Developer

Tel:  +44 (0)20 8123 0528
Email:  admin@dennismcdermott.co.uk  
Home - About Me - Clients and Projects - Training - Software/Programming/Technologies - Hosting - Websites - Testimonials - Contact
 

Clients and Projects

These are a few of the companies I have worked with recently.
 
  Clients and Projects

121 Fundraising Ltd.

301 Design

Abbey Storage

ABS Wastewater Technology Ltd

Acacia Conservatories

Advice North Lincolnshire

Air Heating (Southern) Ltd.

Allianz Global Corporate & Specialty

Almond Art

Alpha Impact Ltd.

Anitox

Art du Midi

Barconn Limited

Barnet and Chase Farm Hospitals

Blairgowrie Guest House

Brentwood Communications

Broadway Records

Bruce Burlington & Co. Ltd.

Cachet (London) Ltd.

Camping La Corconne

Canon Consumer Imaging

Careys Private Hire

Dartford Council

Disabled Living Foundation

Dellcourt House

ESAB

Excel IT Ltd.

Fleetwood Building and Maintenance

GAP Photos

Gites in the Languedoc

Haymarket Publishing

Hiltongrove Audio Bank

Hiltongrove Business Space

Lansbury International

Le Palais des Roses

Lynwood Lodge

Marie-Louise von Motesiczky

Metacosm

Metal Cleaning UK Ltd

Midaye Somali Development Network

Moving Ahead Online Ltd.

MSL Medical

Pepperneck

Pro-Talk

Regent Carriage Services

Rail Professional

Rail Professional Development

Sea Containers

South Essex Gymnastics Club

South & East Essex Training Group

Standish Metal Treatment Ltd

Sunnyseek

The Gifted Goat

The Lamp Company

Thompson and Morgan

Total Crane Services

Virtual BM

Wasteking

Weatherbys

Multiple Jackpot Analyser Project undertaken for 121 Fundraising Limited

As the name implies 121 Fundraising Limited provides a range of services to charities to assist in their individual donor fundraising activities. They specialise in the use of games to encourage participation in fundraising by commonly untapped market segments, whose cause disposition alone may not persuade them to give.

In early 2006 they launched a numbers based game designed to replicate the key characteristics of a weekly lottery, but structured in such a fashion as to offer a far greater degree of flexibility and better prize offer than normally feasible and at no risk to their charity clients.

Players in the game can win cash prizes ranging from £10 to £50,000 every week, based on the comparison of numbers between their own selection and an external range. The game was designed to rely upon the number match probability in order to predict the prize payout ratio.

Early in 2009 it became apparent that the distribution of player selected numbers was not even across the range of permutations (of which there are 49 million), hence certain number combinations could potentially result in multiple jackpot liabilities in a single week.

121 Fundraising Application

A Different Approach
I took a different approach to the problem and decided to compare users selected draw numbers to determine where there could be multiple jackpot liabilities.

Driven from a single form, the user operates from left to right; firstly undertaking analysis of all the currently selected draw numbers, the system provides user feedback during this process. Once the analysis is complete the central section of the form shows the results of the last analysis.

Reporting
The system provides flexible reporting facilities allowing the user to select, a full report, a report against a given set of draw numbers, a report based on the number of jackpot wins, and another based on the financial levels of payout.

Example Report
121 Fundraising

Export of Results
The system also provides a facility to export the results of the latest analysis to allow further comparison to data exports from another system.

Client Comments:
To his great credit Dennis rapidly grasped the fundamentals of the problem: part of the conundrum is that to identify the high risk combinations using a conventional approach would have required a very substantial amount of processing power and a long time to run, even on a powerful server / database facility; impractical in the context of a weekly draw.

Dennis's solution is both simple and elegant, with an Access 2003 application taking a data feed from our main system. Results are available in a variety of formats and flavours and enable us to see rapidly where corrective action is needed.

I would add that costs are very reasonable and flagged in advance, meaning no unpleasant surprises. Anyone looking for an intelligent, value-for-money and friendly approach to application development can expect to be very pleased with their choice when appointing Dennis McDermott to the task.

Clive Mollett
Director
121 Fundraising Limited.


See examples of some of my Microsoft Access Development and VBA Programming Projects here...
 
© Dennis McDermott 2001-2021  -:-  Dennis McDermott is a Freelance Access Developer at Bespoke Software Development Limited -:- Privacy Policy