My friend and I are betting against each other on hockey match up. It take several hours for us to do the accounting for who won money and who lost and how much.
I am looking for a faster and easier way to do the accounting of our bets.
Would love to use either excel or google sheet.
Here a picture of what the result look like. We have about 20 like that per night,
The complexity is that not every one bet the same amount against each other. There also bonus for finishing first and bonus for extra points.
Exemple : If you look at the attach Image.
Every one play head up against each other, Then if LSP16 finish 1, every one need to pay him indivually. Adding to that, because he finish 1 people need to pay double amount. And adding to that if you're 30 points behind you need to pay extra $.
Exemple for myself (eqn778): I finish 3 then i need to pay lsp double $, need to pay Lucky regular payment, and all the other players need to pay me. (ben201, joroy70 etc will need to pay extra $ because they are behind by more then 30 points.
13 фрилансеров(-а) готовы выполнить эту работу в среднем за $118
I'm an excel expert and will create a spreadsheet that automatically calculate the sums needed to be payed and received by each person ( based on modifiable parameters ) can we discuss more your request ? john
hi ..............................Fanduel Data project........................... I have gone thr' the details i believe i can do this project with the best quality.
I have more than 5 years experience in data processing, data entry, excel, pdf and word. If you choose me I could submit the project as soon as possible. Thanks and regards,