steveburton1
12-22-2013, 08:44 PM
Hello World!
Been working on this one a while a can't quite seem to crack it- close though! I need some VBA code that produces the data below- which is just a sample. So the LS and PB data inputs on the right are the parameters (6 inputs in total.) And the results are basically all combinations of the different parameters. Note that LS2 must always be greater than LS1, and so on. I've written some nested For Loops that are getting me 80% there but I'm still off... Thanks for any help I can get. Good luck!
LS1
PB1
LS2
PB2
LS3
PB3
10
5
LS
INPUTS
10
10
Start #
10
10
15
Range
30
10
20
Interval
10
20
5
20
10
PB
20
15
Start
5
20
20
Range
20
30
5
Interval
5
30
10
30
15
30
20
10
5
20
5
10
5
20
10
10
5
20
15
10
5
20
20
10
10
20
5
10
10
20
10
10
10
20
15
10
10
20
20
10
15
20
5
10
15
20
10
10
15
20
15
10
15
20
20
10
20
20
5
10
20
20
10
10
20
20
15
10
20
20
20
10
5
30
5
10
5
30
10
10
5
30
15
10
5
30
20
10
10
30
5
10
10
30
10
10
10
30
15
10
10
30
20
10
15
30
5
10
15
30
10
10
15
30
15
10
15
30
20
10
20
30
5
10
20
30
10
10
20
30
15
10
20
30
20
20
5
30
5
20
5
30
10
20
5
30
15
20
5
30
20
20
10
30
5
20
10
30
10
20
10
30
15
20
10
30
20
20
15
30
5
20
15
30
10
20
15
30
15
20
15
30
20
20
20
30
5
20
20
30
10
20
20
30
15
20
20
30
20
10
5
20
5
30
5
10
5
20
5
30
10
10
5
20
5
30
15
10
5
20
5
30
20
10
5
20
10
30
5
10
5
20
10
30
10
10
5
20
10
30
15
10
5
20
10
30
20
10
5
20
15
30
5
10
5
20
15
30
10
10
5
20
15
30
15
10
5
20
15
30
20
10
5
20
20
30
5
10
5
20
20
30
10
10
5
20
20
30
15
10
5
20
20
30
20
10
10
20
5
30
5
10
10
20
5
30
10
10
10
20
5
30
15
10
10
20
5
30
20
10
10
20
10
30
5
10
10
20
10
30
10
10
10
20
10
30
15
10
10
20
10
30
20
10
15
20
15
30
5
10
15
20
15
30
10
10
15
20
15
30
15
10
15
20
15
30
20
10
20
20
20
30
5
10
20
20
20
30
10
10
20
20
20
30
15
10
20
20
20
30
20
Been working on this one a while a can't quite seem to crack it- close though! I need some VBA code that produces the data below- which is just a sample. So the LS and PB data inputs on the right are the parameters (6 inputs in total.) And the results are basically all combinations of the different parameters. Note that LS2 must always be greater than LS1, and so on. I've written some nested For Loops that are getting me 80% there but I'm still off... Thanks for any help I can get. Good luck!
LS1
PB1
LS2
PB2
LS3
PB3
10
5
LS
INPUTS
10
10
Start #
10
10
15
Range
30
10
20
Interval
10
20
5
20
10
PB
20
15
Start
5
20
20
Range
20
30
5
Interval
5
30
10
30
15
30
20
10
5
20
5
10
5
20
10
10
5
20
15
10
5
20
20
10
10
20
5
10
10
20
10
10
10
20
15
10
10
20
20
10
15
20
5
10
15
20
10
10
15
20
15
10
15
20
20
10
20
20
5
10
20
20
10
10
20
20
15
10
20
20
20
10
5
30
5
10
5
30
10
10
5
30
15
10
5
30
20
10
10
30
5
10
10
30
10
10
10
30
15
10
10
30
20
10
15
30
5
10
15
30
10
10
15
30
15
10
15
30
20
10
20
30
5
10
20
30
10
10
20
30
15
10
20
30
20
20
5
30
5
20
5
30
10
20
5
30
15
20
5
30
20
20
10
30
5
20
10
30
10
20
10
30
15
20
10
30
20
20
15
30
5
20
15
30
10
20
15
30
15
20
15
30
20
20
20
30
5
20
20
30
10
20
20
30
15
20
20
30
20
10
5
20
5
30
5
10
5
20
5
30
10
10
5
20
5
30
15
10
5
20
5
30
20
10
5
20
10
30
5
10
5
20
10
30
10
10
5
20
10
30
15
10
5
20
10
30
20
10
5
20
15
30
5
10
5
20
15
30
10
10
5
20
15
30
15
10
5
20
15
30
20
10
5
20
20
30
5
10
5
20
20
30
10
10
5
20
20
30
15
10
5
20
20
30
20
10
10
20
5
30
5
10
10
20
5
30
10
10
10
20
5
30
15
10
10
20
5
30
20
10
10
20
10
30
5
10
10
20
10
30
10
10
10
20
10
30
15
10
10
20
10
30
20
10
15
20
15
30
5
10
15
20
15
30
10
10
15
20
15
30
15
10
15
20
15
30
20
10
20
20
20
30
5
10
20
20
20
30
10
10
20
20
20
30
15
10
20
20
20
30
20