Hi guys,
sorry for posting here before contributing, but I can't figure it out myself. I came across this website thx to http://www.youtube.com/user/ExcelIsFun
Anyhow. The project I need to make goes as followed:
Global idea.
I need to build up a userlist. The userlist is randomly generated, though it keeps certain things into account.
Example 1:
The list should be 1000 users long, each user has an age. I want to determine that age with a random between an agegroup. For example:
Chris 18
Alfred 26
...
The agegroups will be 18-25, 26-35, 36-45, 46-55, 56-80
What I want is to build this list, according to a parameter which I choose first: I divide the 1k usernames upfront, (ie 30% 18-25, 20% 26-35, ...)
Would it be possible for me to get one table where I enter the percentages and the rest is automatically calculated?
second problem:
I need to fill the properties of the people:
for example:
haircolor: red, blond, brown
hairstyle: bold, short hair, long hair,
There is a catch, bold people can't have a haircolor, bold people can't be 18-25, etc... (not saying this statement is true, it's an example.)
How would you guys suggest I apporach this? I have tried countinga and according to a corresponding vanlue of the percentages I've chose first, I provide a randbetween 18-25 for that field... or is that ??? I'm stuck and don't know where or how I should proceed.
Thank you all in advance!
Best regards,
Tim
sorry for posting here before contributing, but I can't figure it out myself. I came across this website thx to http://www.youtube.com/user/ExcelIsFun
Anyhow. The project I need to make goes as followed:
Global idea.
I need to build up a userlist. The userlist is randomly generated, though it keeps certain things into account.
Example 1:
The list should be 1000 users long, each user has an age. I want to determine that age with a random between an agegroup. For example:
Chris 18
Alfred 26
...
The agegroups will be 18-25, 26-35, 36-45, 46-55, 56-80
What I want is to build this list, according to a parameter which I choose first: I divide the 1k usernames upfront, (ie 30% 18-25, 20% 26-35, ...)
Would it be possible for me to get one table where I enter the percentages and the rest is automatically calculated?
second problem:
I need to fill the properties of the people:
for example:
haircolor: red, blond, brown
hairstyle: bold, short hair, long hair,
There is a catch, bold people can't have a haircolor, bold people can't be 18-25, etc... (not saying this statement is true, it's an example.)
How would you guys suggest I apporach this? I have tried countinga and according to a corresponding vanlue of the percentages I've chose first, I provide a randbetween 18-25 for that field... or is that ??? I'm stuck and don't know where or how I should proceed.
Thank you all in advance!
Best regards,
Tim
