I would like you to make a spreadsheet (google docs) that will help me generate correct score percentages in a darts match using poisson formula.
Here is the information you will be working with
Player A Hold %, Player B Break Percentage
Player B Hold %, Player A Break Percentage
Best of X legs, so for example if this is 17, the simulation will stop when one player reaches 9.
As the player going first alternates after every leg, the hold % and break % for each player needs to be reversed every other game, as their chance of holding serve is far greater when they serve first
Cycle through until one player reaches the requred number of legs
Player A Hold 70 %. Break 45 %
Player B Hold 69 %. Break 52 %
League Average Hold 68.33, Break 43.06
The output will be similar to the screenshot, however it will show percentages of chance for each score.
For somebody good on excel, this should be a pretty simple job. I would like to be able to customised so the total number of legs can be changed, so if it is changed to 33 for example, a table can still be created.
If you have any questions please ask. my buget for this is small as I believe this is quite a simple job.
30 pekerja bebas membida secara purata £20 untuk pekerjaan ini
Hi, I am Brandon, Computer Engineer. I do have deep knowledge in excel and I am familiar with poisson formulae. I can help you with this task :) Thanks! Regards, Brandon