Hello,

I suggest to take my UDF RandSum1() and multiply by 100:

http://www.sulprobil.com/html/randsum1.html

Choose one of the proposed distributions...

You might want to adjust the resulting numbers by rounding to two
digits and finally adjust of them (maybe the highest so that all are
0) to get 100.0.

HTH,
Bernd