Multiple Scenarios, Single Run (MSSR)

Reply #8

time*treat — Sun, 19 Feb 2006 19:39:43 GMT

~ skip counter, macro style~

The setup

filename: skip__count.xls

tabname: Pick3

in row 1:

col 1: date

col 2: num

col 3: ~

col 4: skip

row 2: ---

row 3: first line of data (e.g. jan 1)

row 4: next line of data (e.g. jan 2)

no blank lines between data

under last line, col 1: EOF

(skip is 1 less than drawing difference.

IOW, if a number comes out 2 days in a row, the skip is 0 )

Thus:

r/c1 2 3 4

1 datenum ~ skip

2------ ---

3 jan 1, 1990522

Reply #7

time*treat — Sun, 19 Feb 2006 02:17:17 GMT

Part 3: mini macro

This section will demonstrate a manual version of what was described in parts 1 2. It will pick up data from one place and copy it to another. It's just for visualization. Of course, you could do much more with it.

step 1: open a new workbook

step 2: tools --> macro --> vis bas editor

(in the vb editor)

step 3: insert --> module

step 4: type sub and some name for the macro

step 5: (Enter/Return)

Now in the VBE you will have:

Sub some__name()

End Su... [ More ]

Reply #6

MrBobb — Sat, 18 Feb 2006 05:42:10 GMT

time*treat said:

I have mini macro for the eXceL crowd. It just shows you can lift separate data sets, but does so based on active cell. It was what I was writing when I hit upon the above idea. If there is demand, I will post it as a part 3.

Thank you for taking the time to share this with us, time*treat. I would be interested in your Excel mini macro.

Reply #5

truecritic — Sat, 18 Feb 2006 02:38:23 GMT

Hehe...my brain no longer functions in the complex mode

Reply #4

time*treat — Sat, 18 Feb 2006 02:29:41 GMT

truecritic,

If you wanted to do just 1 scenario, you could do it your way. The reason I use a 2-D array is to let you do multiple scenarios at once...well just running the code once. The 2-D arrays job is to store all of the limit sets. The (first) for-next loop picks up each limit-set (one at a time) and processes it.

This may be harder in a language that uses line numbers.

I posted it for people who already had something up and running, but were fiddling with the parameters. The idea w... [ More ]

Reply #3

truecritic — Sat, 18 Feb 2006 02:09:57 GMT

If I get it so far, for GW BASIC, I would first set up my data file consisting of say, 10 pick 3 numbers and this would be the code from there?

10 COLOR 14,9: CLS: CLEAR

20 DIM BESTRANK(10), STARTPOINT(10), ENDPOINT(10), STEPVALUE(10)

30 PICKS=10

40 OPEN "10.DAT" FOR INPUT AS #1

Then on to FOR/NEXT Loops or whatever.

Or do you really need 2 dimensional arrays

Reply #2

time*treat — Sat, 18 Feb 2006 01:45:20 GMT

Part 2

This is where we turn the array into a workhorse. Each language/app has a way of storing data. It may be a data file, a location on a spreadsheet, those read-data statements in some of the older flavors of BASIC, or something else.

Declare a variable for each parameter, in this case, you will declare 4 names (best_ranks, start_point, end_point, step_value).

The next step is to create an array at the top of the code. In this case, it will be a 4rows-by-4cols array. The values tha... [ More ]

Reply #1

truecritic — Sat, 18 Feb 2006 01:42:03 GMT

Looks good so far.

Multiple Scenarios, Single Run (MSSR)

time*treat — Fri, 17 Feb 2006 20:49:04 GMT

Part 1

So, you have a system but you don't know which set of limits/parameters are best to use. You are tired of changing the limits, running the code, repeating... ad infinitum. Or, maybe you have a better use for your time than watching your screen. I will outline/describe a way to, within limits, let you test multiple scenarios for your system.

Your basic programming tools will be for-next loops and arrays/matricies. You will also need 1 sheet of paper. The paper will help you visual... [ More ]