ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Settings
2
3
Input InstructionsBookmakersSports / LeaguesBet TypesTipsters / CappersCustom FilterCustom Filter NameOdds Type
Currency Rounding
Unit Size
4
5
Input the names of the bookmakers you have memberships with into the Betting Agencies table. For the credit facility, input 0 if you are unsure. For the commission structure input None if you are unsure.

Input names for the sports that you plan to bet on into the Sports table. This will enable you to track your performance for each sport. When you input details into the Bets worksheet, you will only be able to input agency and sport names that are on these lists. This ensures data integrity.

Inputting bet types is optional. If you do so you will be able to select these from a drop down menu in the Bets worksheet. If you wish to track performance by bet type, you need to input the bet types to track here.

Inputting tipsters/cappers is optional, and is for subscribers of tipping services. If you do so you will be able to select these from a drop down menu in the Bets worksheet. If you wish to track performance by tipster/capper, you need to input the tipster names here.		Agency NameCredit FacilityCommission StructureSport NameBet TypeTipster / CapperCustom FiltersMy Variable2 $ 100,00
6
Betfair $ - Net Profit (Betfair, Smarkets...) SoccerLay to WINAwayOnlyHome Fav
7
 $ - None Home DogThe Custom Filter name can be renamed using the box above. The filters themselves can be set up using the Custom Filters table to the left.

This provides an additional filter by which you can analyse your betting data in the Performance Summary sheet. You can use this field any way you want. Some example uses are:

League - if you use the Sport / League column to enter just the sport, you can use this field for the specific league.

Pick attribute - you could filter your wager data based on the home favourite, home underdog, road favourite, etc.

Tip rating - if you subscribe to tippers who publish tip ratings you could enter them here.		The examples above in brackets would result in a $177 payoff and $77 profit for a winning $100 bet.

Decimal odds are popular in Europe, Australia and New Zealand.

To use fractional odds, input = then the fraction into the odds field in the Bets sheet. For example =10/13. Note that Excel will display the odds in decimal format in the sheet. To change this to fractional display, go to the Bets sheet and unlock it (if you have not done so already) by selecting Tools -> Protection -> Unprotect Sheet. The password to do so is sport. Then highlight the odds column and select Format -> Cells -> Number -> Fraction.

This spreadsheet calculates profits based on decimal odds. This is the procedure used by many, but not all bookmakers, so results may vary from those calculated by your bookmaker. In this case it is recommended that you tweak the odds to achieve results that match those calculated by your bookmaker.

If using American odds, leave out the + sign for odds such as +130.
Input the number of decimal places that your currency supports. For most currencies this is 2 (i.e. $5.95 has two decimal places).

If your currency doesn't have decimal places, input 0. I.e. 5.95 rounds to 6.00 in your calculated payouts and profits.

If your betting currency only supports rounding to say, the nearest 10 units, input -1 for rounding. This means 25.95 will round to 30.

This rounding input will determine the rounding used in the calculation of bet payoffs and profits.		Enter an arbitrary currency value that will represent 1 unit.

This field is used in the Performance Summary sheet for those who like to measure their profit in units rather than as currency values.

You can ignore this field if you don't plan on using it.

A "unit" in the context of betting is a measurement of your standard bet amount. Everyone has different sized bankrolls for betting so units are a way for people to compare each other's betting performance when some bet using larger stakes than others.

For example, suppose you wager $20 per bet and you are up $145 since you began tracking your performance. If you set 1 unit equal to $20, then in unit terms you are up $145/$20 = 7.25 units.
8
 $ - None Away Fav
9
 $ - None Away Dog
10
 $ - None
11
 $ - None
12
 $ - None
13
 $ - None
14
 $ - None
15
 $ - None
16
 $ - None
17
 $ - None
18
 $ - None
19
 $ - None
20
 $ - None
21
 $ - None
22
 $ - None
23
 $ - None
24
 $ - None
25
 $ - None
26
 $ - None
27
 $ - None
28
 $ - None
29
 $ - None
30
 $ - None
31
 $ - None
32
 $ - None
33
 $ - None
34
 $ - None
35
 $ - None
36
 $ - None
37
 $ - None
38
 $ - None
39
 $ - None
40
 $ - None
41
 $ - None
42
 $ - None
43
 $ - None
44
 $ - None
45
 $ - None
46
 $ - None
47
 $ - None
48
 $ - None
49
 $ - None
50
 $ - None
51
 $ - None
52
 $ - None
53
 $ - None
54
 $ - None
55
 $ - None
56
 $ - None
57
 $ - None
58
 $ - None
59
 $ - None
60
 $ - None
61
 $ - None
62
 $ - None
63
 $ - None
64
 $ - None
65
 $ - None
66
 $ - None
67
 $ - None
68
 $ - None
69
 $ - None
70
 $ - None
71
 $ - None
72
 $ - None
73
 $ - None
74
 $ - None
75
 $ - None
76
 $ - None
77
 $ - None
78
 $ - None
79
 $ - None
80
 $ - None
81
 $ - None
82
 $ - None
83
 $ - None
84
 $ - None
85
 $ - None
86
 $ - None
87
 $ - None
88
 $ - None
89
 $ - None
90
 $ - None
91
 $ - None
92
 $ - None
93
 $ - None
94
 $ - None
95
 $ - None
96
 $ - None
97
 $ - None
98
 $ - None
99
 $ - None
100
 $ - None