I playing with my friend long time in 8pool billiards and saving results to excel spreadsheet.
Data looks that for every meeting i have result, for example 4-2.
Basic on that data consolidated i'm calculating Games_Advantage/Games_Overall, that gives me how big part frames advantage are total played frames, for example when consolidated game points will be equal then value will be 0%, when i will be loosing then will be under 0%, otherwise when all frames will be on my side then 100%.
How to convert that value to percentage of winning 6 games (frames) meeting?. 1 Hour meeting is in average 6 games, i want to know what percentage of winning or not loosing (including tie) i have.