121 Fundraising - Access Database FoxPro SQL Server VB VBA ASP WEB Programming - Freelance Database Systems and Web Developer

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.

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

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...


	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. 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 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...

Clients and Projects