Generate static random numbers within formula

P.s - will i get any problems having circular references within a dynamic table? (perhaps I should post this in a new thread )

Any values linked to the circular reference will remain the same (from testing I've done). Any values not linked to the circular reference will recalculate