Simple sports simulation

I'm not sure if I can use this forum to ask about hobby-related stuff, but I can't seem to find answers for my question in the Internet. If this is not allowed, I'm sorry!
I am a fan of recreating old football (soccer) tournaments because I like to see what could have happened and who could have won the tournament in another "reality". My problem is on how to generate a result for every single match.
Now, the thing is that I don't need everything to be as realistic as possible and I'm open to underdogs beating favorites sometimes. All I can find online are RANDOM results generator, meaning Salford City can beat Liverpool 5-0 and stuff like this. I want a little bit of reality.

To keep it simple for those who don't want to read everything: I'm looking for a way to generate a soccer result for a match taking into consideration only TWO things: each team's strength (I can manually define this from 0 to 100) and the Home/Away factor. Just these two. Is there a way to do it in Excel? With or without Macros, I'm open to all suggestions

Thanks!

Is there a way to do it in Excel and/or VBA? Short but useless answer -- yes, I'm sure it is possible.

How much is an Excel programming question (you already know how you want to generate the random results, but are not sure how to program that algorithm into Excel) and how much is a more generic "what kind of algorithm should I use/develop"? We are pretty good at Excel programming if you can explain your desired algorithm to us, but we are not always as successful at developing brand new algorithms.

If you already know your algorithm, explain it to us and we should be able to help you program that into Excel.

If this is more generic, then I would need more research. The few times I have encountered football/soccer simulations, they used a random number generator (the math was pretty involved, as I recall) to randomly choose how many goals each team would score in a given match. From this, they could determine results and probabilities and so on and so forth.

For example, assuming a uniform distribution of scores, you might use your "team strength" and "home/away" parameters to determine a maximum number of goals each team would score (5 goals for team A and 3 goals for team B, might be one possible outcome of this calculation). Then a simple =RANDBETWEEN(0,max goals) could be used to come up with each team's goals scored. The programming challenge is exactly how to use your "team strength" and "home/away" parameters to calculate "max goals". From what I recall from the previous discussions, most of the "higher math" was to use something other than a uniform distribution.

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks