I have always found number generation and backtesting easier in excel for workouts. You can see the whole process and propagate changes and tweaks with immediate visual feedback with autocomplete...
here's a pick3 example...
=IF(G2=(($D2*100)+($E2*10)+$F2),"S",IF(G2=(($D2*100)+($F2*10)+$E2),"B",IF(G2=(($F2
*100)+($E2*10)+$D2),"B",IF(G2=(($F2*100)+($D2*10)+$E2),"B",IF(G2=(($E2*100)+($D2*1
0)+$F2),"B",IF(G2=(($E2*100)+($F2*10)+$D2),"B"," "))))))
This assumes you separated your digits for each draw in columns D E and F, Have a workout numbr in column G and want to see straight box results in some higher column. This also assumes your workout numbers are done up and waiting for the results in D, E and F... you can generate your workout numbers from the row above.
let's say G2 contains the combo that is a workout step (last night's number for example was 4-2-3 and you are using the 1-1-1 workout... G contains 534... the night number drawn was 453... in the column you paste the above formula into ,it would read B, because a box hit was encountered, the other 2 display options are S for straight and a blank space for no match... then, simply using a countif statement, you can gather backtest results quickly... for example, let's say your rundown went for 10 columns (G thru P)... G element would be tested in column Q... at the bottom of column Q, take 2 rows...
let's say you have 100 past draws...
Q101 contains =countif(Q1:Q100,"=S") this counts all straights for that workout element
Q102 contains =countif(Q1:Q100,"=B") this counts all box hits for that element....
a simple autofill right and now all elements are accounted for in Q thru Z
to modify this for pick4, simply alter the above formula to take into account all possibilities in the pick4 draws (1 straight or 23 box or no match)
I always start in column D with results because I keep a formula in columns D,E, and F that lets me enter a combo in column C and it extracts the individual digits, saving column A for draw date and column B for draw number.
I'm sure you could just load up an array in vb and use a similar IF test....