Spreadsheet: 675310d1588244801-creating-a-race-night-tracker-race-night-tracker
Sheet: Race Night Bet Tracking

100
Players | Running Balance | Race 1 Horse | Race 1 Bet | Race 1 Odds | Odds as Decimal | Race Stake | Race Result | Race 1 Winnings
Player 1 |  | Horse 1 | Win | Look up the horse name in cell [NAME], then the bet type in D3 and pull the odds from the race results tab for the correlating horse and bet type i.e. Horse 1 & Win would pull from the race results tab, cell B2 |  | 10 |  | If the race result in cell [NAME] is either Won or placed, then multiply the value in cell G2 by the odds in cell F2. If the race result is lost then the calue in cell G2 needs to show as a negative i.e. -£10.00
Player 2 |  | Horse 2 | Each Way | Look up the horse name in cell C4, then the bet type in D4 and pull the odds from the race results tab for the correlating horse and bet type i.e. Horse 1 & Each Way would pull from the race results tab, cell [NAME] |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10
Players | Running Balance | Race 2 Horse | Race 2 Bet | Race 2 Odds | Odds as Decimal | Race Stake | Race Result | Race 2 Winnings
Player 1 |  | Horse 1 | Win |  |  | 10
Player 2 |  | Horse 2 | Each Way |  |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10
Players | Running Balance | Race 3 Horse | Race 3 Bet | Race 3 Odds | Odds as Decimal | Race Stake | Race Result | Race 3 Winnings
Player 1 |  | Horse 1 | Win |  |  | 10
Player 2 |  | Horse 2 | Each Way |  |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10
Players | Running Balance | Race 4 Horse | Race 4 Bet | Race 4 Odds | Odds as Decimal | Race Stake | Race Result | Race 4 Winnings
Player 1 |  | Horse 1 | Win |  |  | 10
Player 2 |  | Horse 2 | Each Way |  |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10
Players | Running Balance | Race 5 Horse | Race 5 Bet | Race 5 Odds | Odds as Decimal | Race Stake | Race Result | Race 5 Winnings
Player 1 |  | Horse 1 | Win |  |  | 10
Player 2 |  | Horse 2 | Each Way |  |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10
Players | Running Balance | Race 6 Horse | Race 6 Bet | Race 6 Odds | Odds as Decimal | Race Stake | Race Result | Race 6 Winnings
Player 1 |  | Horse 1 | Win |  |  | 10
Player 2 |  | Horse 2 | Each Way |  |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10
Players | Running Balance | Race 7 Horse | Race 7 Bet | Race 7 Odds | Odds as Decimal | Race Stake | Race Result | Race 7 Winnings
Player 1 |  | Horse 1 | Win |  |  | 10
Player 2 |  | Horse 2 | Each Way |  |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10
Players | Running Balance | Race 8 Horse | Race 8 Bet | Race 8 Odds | Odds as Decimal | Race Stake | Race Result | Race 8 Winnings
Player 1 |  | Horse 1 | Win |  |  | 10
Player 2 |  | Horse 2 | Each Way |  |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10
Players | Running Balance | Race 9 Horse | Race 9 Bet | Race 9 Odds | Odds as Decimal | Race Stake | Race Result | Race 9 Winnings
Player 1 |  | Horse 1 | Win |  |  | 10
Player 2 |  | Horse 2 | Each Way |  |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10
Players | Running Balance | Race 10 Horse | Race 10 Bet | Race 10 Odds | Odds as Decimal | Race Stake | Race Result | Race 10 Winnings
Player 1 |  | Horse 1 | Win |  |  | 10
Player 2 |  | Horse 2 | Each Way |  |  | 10
Player 3 |  | Horse 3 | Each Way |  |  | 10
Player 4 |  | Horse 4 | Win |  |  | 10
Player 5 |  | Horse 5 | Win |  |  | 10
Player 6 |  | Horse 6 | Win |  |  | 10
Player 7 |  | Horse 7 | Win |  |  | 10
Player 8 |  | Horse 8 | Win |  |  | 10
Player 9 |  | Horse 9 | Win |  |  | 10