Fanduel Data

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