121 Fundraising -  I am a Freelance Microsoft Access Database and WEB Systems Developer/Programmer specialising in Database Development, Access, SQL, Foxpro. Design, Programming and Development of both local network and Internet based applications. +44 (0)20 8123 0528  

E-mail: 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.
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
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
Metal Cleaning UK Ltd
Midaye Somali Development Network
Moving Ahead Online Ltd.
MSL Medical
Regent Carriage Services
Rail Professional
Rail Professional Development
Sea Containers
South Essex Gymnastics Club
South & East Essex Training Group
Standish Metal Treatment Ltd
The Gifted Goat
The Lamp Company
Thompson and Morgan
Total Crane Services
Virtual BM
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.

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
121 Fundraising Limited.

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