destabilizator
New Member
- Joined
- Aug 18, 2011
- Messages
- 2
Hi,
I have stumbled upon a little problem. I have Excel worksheet with tab containing keywords and their possible parameters, see the attached destabilizator.xlsb.
Now what I need to do is to generate files containing some header and then set number of those keywords (randomly picked, but unique) with randomly picked option. I have this coded and it's working.
What I have problem with is when some rules come to play, see rules.xlsx. I have coded the FUNCTION=INDEX<blah blah> "switch". Is there any effective trick to code or use such rules in Excel? If you for example randomly pick NUMBEROFPARTS keyword, there has to be PARTITION keyword for which there has to be DBDNAME, etc.
Basically I need a script which generates allowed combinations of keywords and their options.
Those rules I have are just sample, there are programs with hundreds of keywords and rules
Or do you have suggestion for other tool to use to do this? I was toying with RapidMiner, but it's very long time ago since I've used it.
For some reason I can't post attachements :S if anyone is interested, I can e-mail the refered files.
I have stumbled upon a little problem. I have Excel worksheet with tab containing keywords and their possible parameters, see the attached destabilizator.xlsb.
Now what I need to do is to generate files containing some header and then set number of those keywords (randomly picked, but unique) with randomly picked option. I have this coded and it's working.
What I have problem with is when some rules come to play, see rules.xlsx. I have coded the FUNCTION=INDEX<blah blah> "switch". Is there any effective trick to code or use such rules in Excel? If you for example randomly pick NUMBEROFPARTS keyword, there has to be PARTITION keyword for which there has to be DBDNAME, etc.
Basically I need a script which generates allowed combinations of keywords and their options.
Those rules I have are just sample, there are programs with hundreds of keywords and rules
Or do you have suggestion for other tool to use to do this? I was toying with RapidMiner, but it's very long time ago since I've used it.
For some reason I can't post attachements :S if anyone is interested, I can e-mail the refered files.
