Below is a suggestion for inputting each way bets into thebetting tracker spreadsheet. The inputs below are based on example #2 here:

http://en.wikipedia.org/wiki/Each-way_%28bet%29

"A £10 each-way single on a 10-1 selection in a horse race and paying 1⁄4 the odds a place 1, 2, or 3 would cost £20."

Note that the spreadsheet has been set to fractional odds in the Settings sheet to be consistent with the example above.

In the spreadsheet you would input two lines: one at 10-1 odds and one at 2.5-1 odds. The sport, selection, bet type, event, and wager amounts are identical for both lines of the wager. You then update the two lines separately based on the event outcome.

The bets have been entered into the spreadsheet three times to cover three scenarios:

- The horse places first
- The horse places 2nd or 3rd
- The horse doesn't place

The payouts/profits for the three scenarios are as follows:

- You have a total payout of $145 for a net profit of $125 if the horse places first.
- You have a total payout of $35 for a net profit of $15 if the horse places 2nd or 3rd
- You have a net loss of $20 if the horse doesn't place

Note that a bet type called 'Each Way' has been created in the settings sheet.

## Bookmarks