T
T-Bottch
I am working on a project in excel and have run into a problem. What I
have made is a model of a tennis game where each point is determined
with excel's rand number generator and whether or not a given
fraction(odds) is higher or lower than the random # for that point.
The whole thing is quite nifty looking, branching out like a flow
chart. I have macros created to run 1000 games at a time and the wins
for each player get recorded in a cell under each "game winable
cell"(there's a lot of game winning cells when you extend a game out to
thirty some deuce points). That sounds confusing. Its kind of hard to
describe but if you're still with me, the problem comes when I try to
reset all of the games won to zero. To reset the games to zero I
simply type "reset" in cell A1. After I do that they all return to
zero but then I have to delete the "reset" otherwise the games won
won't record. Since delete is a shortcut to run the random number
generator, when I try to delete "reset" I always get one game recorded.
And there you have it, my question: is there a way to alter the
shortcut keys in excel so that delete does not run the random #
generator and give me that recorded win? or is there another way I can
get around recording that one win after I have reset all wins to zero?
if you have any ideas you can post or email to me at (e-mail address removed)
Thanks Very Much!
have made is a model of a tennis game where each point is determined
with excel's rand number generator and whether or not a given
fraction(odds) is higher or lower than the random # for that point.
The whole thing is quite nifty looking, branching out like a flow
chart. I have macros created to run 1000 games at a time and the wins
for each player get recorded in a cell under each "game winable
cell"(there's a lot of game winning cells when you extend a game out to
thirty some deuce points). That sounds confusing. Its kind of hard to
describe but if you're still with me, the problem comes when I try to
reset all of the games won to zero. To reset the games to zero I
simply type "reset" in cell A1. After I do that they all return to
zero but then I have to delete the "reset" otherwise the games won
won't record. Since delete is a shortcut to run the random number
generator, when I try to delete "reset" I always get one game recorded.
And there you have it, my question: is there a way to alter the
shortcut keys in excel so that delete does not run the random #
generator and give me that recorded win? or is there another way I can
get around recording that one win after I have reset all wins to zero?
if you have any ideas you can post or email to me at (e-mail address removed)
Thanks Very Much!