I am looking for the development of an excel spreadsheet that calculates stake amounts on football results in order to achieve a user-definable target profit from each match.
Assuming there are only 3 possible outcomes to a football match: Home Win, Away Win or The Draw.
If the odds for each (in UK Decimal) are:
Home Win: 1.9
Away Win: 3.60
I want to be able to set a target profit of say 25 and have the stakes for each individual selection calculated automatically so that the stakes on the losing bets are recovered and the target profit is achieved.
The target amount must be a variable that I can change, and I would like a starting bank and a running bank total that gets updated each time a bet is placed.
The assumption is that regardless of the outcome (or size of the stakes involved) the target amount is made on each event, regardless of the outcome.
This is going to pose a challenge I am sure, so a good knowledge of maths is probably advisable, as well as a good understanding of odds calculations.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Must run on Windows XP using Microsoft Office XP