Hi, I have a bit of a problem. Usually I manage to find answers and solutions in the older threads (thanks to everyone for posting answers on the site), but this time I was forced to register and post my issue
.
I m designing an algorithm for a football game, the issue is statistics. It would be great if I could simulate 10.000 matches and have the statistics to be able to make necessary tweaks.
Since the algorithm uses a lot of the RAND function, I recalculate the result by pressing F9. The screenshot shows what the end result looks like – I have a sheet “REZ” where this is located.
[/URL][/IMG]
It would be perfect if the simulated matches could be recorded on separate sheet for example “STAT”. - I would like to copy the 4 important info from every match (Goal team 1 (U3), Goal team 2 (U15), chances team 1(K3), Chances team 2(K15) ) into one row -for example c10:c10010 in the “STAT” sheet.
[/URL][/IMG]
If it is possible to simulate 10000 matches and place the results in rows, I could easily extrapolate the statistics. I m a bit new to VBA, but I think I could manage with a bit of help.
I hope I presented the issue clearly and thanks for the help in advance.

I m designing an algorithm for a football game, the issue is statistics. It would be great if I could simulate 10.000 matches and have the statistics to be able to make necessary tweaks.
Since the algorithm uses a lot of the RAND function, I recalculate the result by pressing F9. The screenshot shows what the end result looks like – I have a sheet “REZ” where this is located.

It would be perfect if the simulated matches could be recorded on separate sheet for example “STAT”. - I would like to copy the 4 important info from every match (Goal team 1 (U3), Goal team 2 (U15), chances team 1(K3), Chances team 2(K15) ) into one row -for example c10:c10010 in the “STAT” sheet.

If it is possible to simulate 10000 matches and place the results in rows, I could easily extrapolate the statistics. I m a bit new to VBA, but I think I could manage with a bit of help.
I hope I presented the issue clearly and thanks for the help in advance.