Saving output from a equation

New Contributor

I am creating a probability simulator for sports betting.

I have expected probabilities for each team winning a game, and I am running a simulation with a monte Carlo. I have summed up the total Net profit from running 100 games in to a cell (lets say A1 for reference). I would like to take the output in cell A1, and store each output when I refresh my data table in to Colum C. 

example

Sim1=$123.00

Sim2=$(66.00)

.

.

Sim100=$(132.00)

0 Replies