Great, thanks! I have tried to create a working system over this topic as well. My latest trial was to see whether a "too rested" (a team with no games in x amount of days) team would actually be negatively affected by the break in games. My back testing showed that this might actually be the case to an extent, but it was not enough to warrant a reliable system by any means.
I did not check the stats for "too rested" vs. teams with B2B-games (first game compared to second game of B2B vs. the too rested team's first game after the break). I could do it but I can not figure out an excel formula for it. Would take a million years to do the back testing manually. Arent you a statistics expert? How about using excel? What would the formula look like if I have an excel with:
1. In column A (on rows 2-83) the team that plays
2. In column B (on rows 84-165) the opposing team
3. In column C the dates of the games for team A (on rows 2-83) (to see the break between games for team A)
4. In column D the dates of the games for team B (on rows 84-165) (to see the B2B games for opposing team)
5. In column E the result of the game (W/L for the team in column A)
I want to have a formula that will show me exactly the results (W/L) in games where there has been a break of X games (e.g. 3 games) for a team AND that the game after the break is against a team that is having B2B-games. I cant figure that formula out...
It should be like "the results of a game if a team in column A has more than X amount of days in between games and is facing a team B who is on the second leg of its B2B".
I am not a statistics or excel expert by any means, I just try to learn this stuff to be able to calculate very quickly different scenarios and outcomes of different possible systems.