The home of intelligent horse racing discussion

Home Forums Tipping and Research Systems Systems Building Reply To: Systems Building

#43954

No, problem Stephen,

This type of staking plan doesn’t rely on a high strike rate but on level stakes profit. So it suits a strike rate of around 20%. In the example there are only 3 winners from 16 bets (18%) and although there isn’t a profit there also isn’t a loss.

Matron here is an introduction to spread sheets and how to set up the plan shown. This works in basic spread sheets and excel. It takes a bit of practice but once you get used to it it’s quite easy. You might want to print this off before you start.

Open up the Spread sheet function.<br>The sheet is split into a series of boxes called ‘Cells’. Ãƒâ€šÃ‚Â Across the top of these are letters naming each ‘Column’ and down the side are numbers naming each row. So, cell ‘C3’ is the cell on row 3 in column C.

Values in each cell can be calculated against one another using symbols;<br>/ is divide by<br>* is multiplied by<br>- is minus<br>+ is add<br>^ is to the power of

Each formula starts with the following; =sum

Example, try this,<br>In cell c3 type a 3 in cell d3 type a 4. in cell e3 type =sum(c3+d3) and then press enter. The value shown in e3 should be 7.<br>Click back on the cell with the formula in it and you will see that the formula appears in the formula bar at the top of the spread sheet. To amend the formula click in the formula bar. Try to amend the formula using the different symbols shown above, in lieu of the + sign. Do this until you are comfortable with what is going on.

To set up the staking plan as shown;

Type in the following information into the following cells;

Row 3 only<br>Column<br>A – Sequence<br>B – Divisor<br>C – Target<br>D – Bet<br>E – P/Loss<br>F – Result<br>G – Bank<br>H – 10000

These are your column titles, now populate the columns,<br>In column A fill in 1 to 17, this is the series of bets.<br>In column B, manually enter the values as shown in the earlier post.<br>In column F, enter results L for Lost and winning odds in numbers 6 for 6/1, etc.<br>In column C, for your first target (c4) type =sum(\$h\$3/100*1)*b4. In the next row (c5) add the formula =sum(c4+d4) copy and paste this to every row after each losing bet. In column c row 16 add the formula =sum(c15-e15), copy and paste this to each row beneath each winning bet.<br>In row D, add the formula =sum(c4/b4). Copy and paste this into all cells in this column.<br>In row E, (e4) add the formula =sum(d4-d4)-d4, copy and paste this to each row that has a losing result. In (e15) add the formula =sum(d15*f15), copy and paste this in every row that has a winner.<br>In column G, (g4) add =sum(h3+e4). In (g5) add the formula =sum(g4+e4), copy and paste this into all subsequent rows.

By now if you’ve done it right and I’ve explained it properly, you’re formula cells will be full of numbers running out into decimal places. To sort this, highlight each column you are using along the letter at the top, so each column is black. Click on the format buttong at the top of the screen. Click on number and adjust the decimal places to ‘0’. Leaving the columns highlighted click on format, column, autofit width. And that’s it.

Note that ‘\$’ (dollar sign) is added to the formula cell (c4), this pins the formula to always get it’s data from that cell when you copy and paste it. Copy and paste (c4) to (c20). This starts the betting again when the target drops below 600, providing you have entered the divisor.

Have a play around with this and let me know how you get on Matron. As I said before it’s not as complicated as it looks and once you’ve decide how your cash flow will work it’s just a matter of copy and paste.<br>

(Edited by dave jay at 8:51 pm on Dec. 30, 2002)