Random number generation that adds up to X

Hi

I have built a model but need to make a test data set. On every 13th line I have data, but I need to randomly distribute this data across the previous 12 rows (the allocation to each cell needs to be random, but all 12 cells must add up to the value in the 13th cell).

Is there a way of doing this?

Thanks

Can you adapt the following paradigm?

	A	B	C	D	E
1	Period#	Actual	Actual%	RAND	Target%
2	1	14,252	14.25%	0.700073	14.25%
3	2	14,373	14.37%	0.706013	14.37%
4	3	7,440	7.44%	0.365492	7.44%
5	4	5,942	5.94%	0.291868	5.94%
6	5	3,363	3.36%	0.165198	3.36%
7	6	1,429	1.43%	0.070175	1.43%
8	7	19,326	19.33%	0.949316	19.33%
9	8	228	0.23%	0.011181	0.23%
10	9	2,558	2.56%	0.125647	2.56%
11	10	18,867	18.87%	0.926801	18.87%
12	11	11,984	11.98%	0.588663	11.98%
13	12	238	0.24%	0.011802	0.24%
14	total	100,000		4.912229	sum RAND
15				100,000	check sum

Please Login or Register  to view this content.

Thanks Glenn,

This is quite what I wanted, just going downward rather than across, but I think I can adapt it!

Cheers,