Hey guys!

So, I'm not sure if this is the appropriate board, but as its the only forum I'm using, and I'm using Geeks Toy..I thought why not give it a try!

So I'm a complete beginner, with less than 200 bets placed lifetime, but I like it and I feel like continuing doing it..so to the point>

I'm trying to make/use an excel spreadsheet to track my history etc. and for this I downloaded a spreadsheet from betandskill.com which seems very good. (http://www.betandskill.com/betting-t...worksheet.html) Basically, its perfect...EXCEPT I'm not sure how to input bets when I LAY, as it's really just made for normal bets. THey say that if I want to insert a laybet I will have to:

...But what if the Lay odds were less than 2.0.I will end up with multiplying the stake with a number less than 1 which makes everything messy...

If any1 has any idea how to do it, or a different spreadsheet or whatever I would greatly appreciate it.

If this is the wrong board to ask for stuff like this, I'm terribly sorry!

Regards!

So, I'm not sure if this is the appropriate board, but as its the only forum I'm using, and I'm using Geeks Toy..I thought why not give it a try!

So I'm a complete beginner, with less than 200 bets placed lifetime, but I like it and I feel like continuing doing it..so to the point>

I'm trying to make/use an excel spreadsheet to track my history etc. and for this I downloaded a spreadsheet from betandskill.com which seems very good. (http://www.betandskill.com/betting-t...worksheet.html) Basically, its perfect...EXCEPT I'm not sure how to input bets when I LAY, as it's really just made for normal bets. THey say that if I want to insert a laybet I will have to:

*
*
* If you place a lay bet with Betfair, we recommend you input it into the spreadsheet as follows. This example is for a $5.00 wager against an outcome at 4.00 odds. $5.00 is the lay stake amount and the lay odds are 4.00.

Input the stake amount as stake * (lay odds - 1), i.e "=5.00*3"

This reflects the fact that you have put $15.00 at risk by placing the wager.

Input the odds as 1 + 1/(lay odds - 1), i.e "=1 + 1/3"

This reflects the fact that you have put $15.00 at risk for the possibility of winning a $5.00 profit. The bet is equivalent to wagering $15 at 1.33 odds, because $15*1.33 = $20, and $20 - $15 = $5.

Input the stake amount as stake * (lay odds - 1), i.e "=5.00*3"

This reflects the fact that you have put $15.00 at risk by placing the wager.

Input the odds as 1 + 1/(lay odds - 1), i.e "=1 + 1/3"

This reflects the fact that you have put $15.00 at risk for the possibility of winning a $5.00 profit. The bet is equivalent to wagering $15 at 1.33 odds, because $15*1.33 = $20, and $20 - $15 = $5.

...But what if the Lay odds were less than 2.0.I will end up with multiplying the stake with a number less than 1 which makes everything messy...

If any1 has any idea how to do it, or a different spreadsheet or whatever I would greatly appreciate it.

If this is the wrong board to ask for stuff like this, I'm terribly sorry!

Regards!

## Comment