Dynamic Statisics

[TheRogue!]

I have a table that shows the probability of what type of toy a child might have, based upon gender.

I have a seperate input sheet where a user can input the # of boys & the # of girls in the sampling.

I can get it to do all of the calculations & generate the random #'s for the probabilty & get it to populate the results to another table, in order to calculate a total inventory (i.e. -5 trucks & 3 dolls), but I'm stuck on how to make the second table dynamic to account for whatever # of boys & girls the user inputs on the 1st sheet.

Column1	Trucks	Dolls	Boats	Balls	Stuffed
Boys	75%	5%	60%	50%	10%
Girls	0%	90%	5%	50%	70%

<TBODY>
</TBODY>

How do I get the second table to look like this:
(I'm having trouble with how I get it to populate Column1[Dynamically, based upon Input on the other sheet (might be 100 boys & 300 girls)], the rest of the table, I can handle.

Column1	Trucks	Dolls	Boats	Balls	Stuffed
Boy1		1	1	1	1
Boy2	1		1
Boy3	1			1
Boy4	1			1	1
Girl1		1		1	1
Girl2		1			1
Girl3		1			1

<TBODY>
</TBODY>

 

[dspel79082]

Hi Rogue, could you show how the input is set up?

 

[TheRogue!]

Very simple. Just two direct input boxes for the two variables. Otherwise, there is just some text, explaining to the user how it works. The variable boxes Default to zero, but any intiger can be input.

	x Boys
	x Girls

<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>