Introduction
Version
This is version 1.00 of the Excel betting tracker with staking plans.  It has an .xlsx filename extension and requires Microsoft Office 2007 or later due to the lengthy formulas and use of countifs() and sumifs() functions.
Terms of Use
This spreadsheet is free for personal use.  Feel free to make amendments to the sheet to suit your needs.  The password to unlock the sheet is sport.
Do not make this spreadsheet, or any variant of it, available elsewhere on the Internet.  If you wish to tell others about this betting tracker, please share the following URL:
http://www.aussportsbetting.com/tools/staking-plan-calculator-excel-spreadsheet/
Setup - READ THIS BEFORE USING THE SPREADSHEET
STEP 1:  Delete the sample data in the Settings, Deposits and Bets worksheets.  IMPORTANT: do not use the Ctrl+X keyboard combination to delete data because this can cause background calculations to go awry.  To remove data we recommend you highlight the cells and press the Delete button on your keyboard.
STEP 2:  Go to the General Settings worksheet and input the names of your betting agencies along with the sports you plan to bet on.  We recommend you also input bet types.  Change the odds format and currency rounding if necessary. 
STEP 3:  Go to the Staking Plan Settings worksheet and adjust the settings if necessary. 
STEP 4:  Go to the Deposits worksheet and input your bookmaker account balances into the Deposits & Withdrawals table
STEP 5:  Go to the Bets worksheet and input your betting details
STEP 6:  Once each bet has resulted, update the Bets worksheet accordingly
Worksheets
This workbook enables you to monitor your sports betting performance. It consists of ten worksheets that can be selected using the tabs at the bottom of the screen. The yellow sheets display information and statistics, while the blue sheets are for data entry. Each worksheet is described below.  Feel free to delete the Tipper Analysis, Closing Odds Analysis and Closing Line Analysis worksheets if you don't need them.
INTRO (output) - provides an introduction to the spreadsheet along with usage instructions
GENERAL SETTINGS (input) - manages settings for bookmakers, sports categories, tippers, bet types, odds formats and currency rounding
STAKING SETTINGS (input) - choose which staking plans to display on the Bets worksheet and elect whether to adjust the plans (where applicable) for odds and bet ratings.
DEPOSITS (input) - lists your bookmaker deposits and withdrawals, including bonus credit and free bets
BETS (input) - the main data entry sheet for your wagers
AVAILABLE FUNDS (output) - tracks your net deposits and available credit with each bookmaker
PERFORMANCE SUMMARY (output) - an interactive sheet that summarises your betting performance
STAKING PLANS COMPARISON GRAPH (output) - compares your actual profit to the hypothetical profit had you strictly followed each staking plan.
Bets Worksheet - Field Explanations
Below are descriptions of the fields in the Bets worksheet.  Variables with black headers are required while those with blue headers are optional.  Sample data is provided in the Bets worksheet so you can see how the fields are intended to be used.  Input instructions are automatically displayed for the first 20 rows of the Bets worksheet to assist with the data entry process.
Date (required) - this field is crucial for the Performance Graph and is handy for filtering your results in the Performance Summary.  It is highly recommended that you input your wagers in chronological order to avoid erroneous looking graphs.  For this reason we recommend entering the date that you placed the wager rather than the event date.  This avoids having to re-sort the data to get a meaningful graph. The dates are displayed in the format d-mmm-yy (e.g. 3-Nov-14), although you can actually input dates in the format dd/mm/yyyy (e.g. 03/11/2014).  Note that if you highlight a cell, the cell formula will have the dd/mm/yyyy format despite the fact that the cell is displayed on the page as d-mmm-yy.
Time (optional) - if you need to separate bets on the same day as NOT being simultaneously placed, you can input different times to separate the bet timings.  See the Simultaneous Bets explanation at the bottom of the Staking Plan Settings worksheet to learn more.
Bookmaker (required) - this field contains the bookmaker or betting exchange that the wager was placed with.  To ensure data integrity, you must enter a list of your bookmakers on the Settings sheet first.
Sport/League (required) - this field enables you to filter your results on the Performance Summary sheet by sport.  To ensure data integrity, you must enter a list of sports/leagues into the Settings sheet first.  Depending on how you use the Custom column (discussed below), you can either use this field for sport and league (e.g. "Football - EPL") or you can use this field for sport (e.g. "Football") and then use the Custom column for the league (e.g. "EPL").
Selection (optional) - this is your wager selection.  This field is for your reference only and is not referenced anywhere else in the spreadsheet.  To give some input examples, if you back Team A to beat Team B your selection is "Team A".  If you back the over in the total score market, your selection is "Over".
Bet Type (optional) - this field is recommended because it can be used as an additional filter in the Performance Summary sheet.  It records the type of wager you placed.  To ensure data integrity you must input a list of bet types into the Settings sheet first.  Examples include head-to-head (a.k.a. money line), line (a.k.a. handicap or spread), total score, correct score, etc.
Tipper (optional) - subscribers of tipping services can use this field to track the betting performance of each tipper/capper. This field is referenced in the Performance Summary sheet and is required if you want to use the Tipper Analysis sheet.  To ensure data integrity you need to enter your tippers into the Settings sheet first.
My Variable (optional) - this field can be renamed in the Settings sheet.  It provides an additional filter by which you can analyse your betting data in the Performance Summary sheet.  To ensure data integrity you need to input a list of acceptable values into the Custom Filter table of the Settings sheet first.  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.
Fixture/event (optional) - this records the game that you wagered on.  This field is for your reference only and is not referenced anywhere else in the spreadsheet.  For futures markets you could enter something like "2014/15 NBA Championship" or "2014/15 NBA MVP".
Live Bet (optional) - this is a simple Y or N field for whether your wager was placed in-play (a.k.a. live) or pre-game.  You can leave this field blank for pre-game wagers.
Score/result (optional) - this records the final score or result for your selection.  This field is for your reference only and is not referenced anywhere else in the spreadsheet.
Stake (required) - this is the currency amount wagered.  For lay bets on betting exchanges you should input the backer's stake rather than the amount of money you're risking.  Note that the amount of money at risk is automatically shown in the At Risk column.  The at risk amount will equal the stake amount for all back bets (i.e. all wagers with traditional bookmakers).  For betting exchange lay bets the stake could be greater or less than the at risk amount, depending on the odds.
Odds (required) - the bookmaker odds for your selection go in this field.  If you are using an odds system other then decimal/European, change the odds type in the Settings sheet first.  The + sign is not required for American odds such as +200.
FB (optional) - this is a simple Y or N field for whether your wager was placed using Free Bet money.  You can leave this field blank for regular wagers.
Win (required) - this field defaults to "P" for pending bets.  It is the only field for which input instructions appear for all rows, not just the first 20.  Once your bet has concluded, input the bet result using the instructions that automatically appear on the Bets worksheet.  The standard accepted values are P (pending bet), Y (winning bet), N (losing bet), R (refund) and H (half payout).  For Asian Handicap wagers there are also the values PU (push), HW (half win) and HL (half lose).
Betting Exchange fields:
The following fields only apply if you placed your wager with a betting exchange.
Commission (optional) - enter the betting exchange commission here.  The values are displayed in % form, so if the commission is 5%, enter "5" and not "0.05".  Note that the commission is applied to your wager profit, which is the practice with most, but not all betting exchanges.  If no commission applies to your wager you can leave this field blank.
Lay Bet? (optional) - if you are placing a lay bet (a bet that the selection WON'T win), input Y.  If the wager is a standard back bet you can input N or simply leave the field blank.
Staking plan fields:
Your bet rating (optional) - if in the Staking Plan Settings you elect to adjust the stake recommendations based on a bet rating (between 1 and 10), input a rating for each bet.  A 1 denotes the lowest rating and 10 denotes the highest rating.
Your probability estimate (optional) - if you are using the Kelly Criterion as one of your staking plans, input your best guess for the probability that the bet will win.  If you are placing a lay bet using a betting exchange, input the probability that the backer's bet will win.  To assist you with your data entry, the probability of winning as implied by the odds (1 / decimal odds) is shown in the column next to this field.  For standard wagers the Kelly Criterion will only recommend a stake if your estimated probability is higher than the implied probability.  The reverse is true for lay bets on betting exchanges.
Data entry colour coding
To clarify which cells are editable and which aren't, the following colour coding is used for table headers:
Required input cells
Optional input cells
Automatically populated cells (do not edit)
Worksheet protection
As it stands, only limited sections of this spreadsheet can be edited. This is to prevent key formulas from being accidentally overwritten.
To unlock a worksheet, go to that worksheet and select the Review header ribbon, then click on Unprotect Sheet.
The password to unlock each worksheet is sport
Betting exchange wagers
If you do not use a betting exchange you can ignore columns O and P in the Bets worksheet.
This spreadsheet enables you to input whether a wager is a back bet or a lay bet.  It also enables you to input betting exchange commissions on winning wagers.
Note that this sheet only supports betting exchanges that charge commissions on the profits of winning bets.  If you are using Matchbook, which charges commissions on both winning and losing wagers, you will need to manually tweak the stake amounts of losing bets to give the correct value.
Important: if you place a lay bet, input Y for the Win column in the Bets worksheet if your wager won and N if your wager lost.  Input all other outcomes (HW, HL, PU, etc.) as per the result of the bet from a backing perspective.  See the input examples below for clarification.
If you place one or more back or lay bets on the same market, tweak the commission(s) for the winning wager(s) as required so that the payout corresponds to your exchange account.  This involves revising the commission downward.  For example if your commission is usually 5% and you win $10 on a back bet and at the same time lose $5 on a lay bet on the same market, input 2.5% as your commission on the winning back bet.
Note that the inclusion of back and lay bets on the same market will distort the Performance Graph because the betting tracker won't acknowledge that the opposing bets were on the same market.  Also, the Available Funds calculation will be off until the bet has concluded, because it won't acknowledge the fact that opposing bets on the same market free up funds.  Lay bets at high odds will also inflate the concluded bet amounts, which will pull your percentage profit closer to zero.  While this isn't ideal, this betting tracker is designed to be beginner friendly and versatile, hence the lack of additional exchange-specific features.  Feel free to modify the spreadsheet further to suit your needs.  The instructions to unlock the workbook are shown above in the 'Worksheet protection' section.
Exchange input examples
Example 1: you place a Back bet on Clijsters to win the Australian Open. The wager is for $10.00 at 4.50 odds.
- Input 10.00 into the Wager field
- Input 4.50 into the
Odds field
- Input your commission level (e.g. 5%) into the
Commission field
- Leave the
Lay Bet field blank, or input N into this field
At the conclusion of the event, input Y into the
Win field if Clijsters wins the tournament.  Input N into the Win field if she doesn't.  A win will result in a profit of $35 (before commission), while a loss will result in a profit of negative $10.
Example 2: you place a Lay bet on Clijsters to win the Australian Open. The wager is for $10.00 at 4.50 odds.
- Input 10.00 into the Wager field
- Input 4.50 into the
Odds field
- Input your commission level (e.g. 5%) into the Commission field
- Input Y into the
Lay Bet field
At the conclusion of the event, input N into the
Win field if Clijsters wins the tournament.  Input Y into the Win field if she doesn't.  A win will result in a profit of $10 (before commission), while a loss will result in a profit of negative $35.
If the result is anything under than Y or N, input the result (R, HW, HL, etc.) from the backer's perspective, regardless of whether it is a back or lay bet.  Note that the spreadsheet will calculate your profit/loss accordingly, depending on whether it is a lay bet.
What if I run out of space?
If you require more betting agencies, sports categories, or bet types you will need to edit the spreadsheet yourself.  This will require fairly good knowledge of Microsoft Excel.
If you require more rows for the Deposits worksheet you should:
1. Unlock the Deposits worksheet using the instructions above
2. Click on the Excel row number corresponding to the last row of the deposits table (make sure it is empty)
3. In the Home menu ribbon click on Insert (or Insert -> Insert Sheet Rows).   Repeat as required.
Be sure to insert rows above the last row rather than append rows below the last row.
If you require more rows for the Bets worksheet you should:
1. Unlock the Bets worksheet using the instructions above
2. Click on the Excel row number corresponding to the last row of the bets table (make sure the row is empty)
3. In the Home menu ribbon click on Insert (or Insert -> Insert Sheet Rows).   Repeat as required. 
4. In the At Risk, Payout and Profit/Loss  columns you will see blank cells for the new row(s). Highlight the row below the lowest blank cell by clicking on the row number.
5. Click on the small black box at the bottom right corner of the cell number and drag the mouse up without releasing the mouse button.  Once you have reached the highest blank row release the mouse button.
6. The new Payout & Profit cells should now look as follows
Frequently asked questions
Why does the Performance Graph have vertical spikes in it?
The Performance Graph uses the bet date for the x-axis.  If you place more than one wager on the same date then vertical spikes can appear in the graph.  These spikes represent the high point and low point for your profit level on that given day.  As you accumulate more betting data these spikes will become less pronounced.
How do I input multi bets (including exotic multis)?
http://forum.aussportsbetting.com/showthread.php?317-Multi-betting-accumulators-parlays
How to I input each way bets?
http://forum.aussportsbetting.com/showthread.php?352-Entering-each-way-bets
How do I remove unwanted columns?
http://forum.aussportsbetting.com/showthread.php?351-Unwanted-columns
How do I remove input instructions?
http://forum.aussportsbetting.com/showthread.php?17-How-to-remove-input-instructions
Please note that version 2.14 the betting tracker and above of only display betting instructions for the first 20 rows of the Bets sheet.  These are designed to help you familiarise yourself with the spreadsheet.  If you ever need to refer to the input instructions later, simply scroll to the top of the Bets sheet and click on a cell to read the instructions.
What are the closing odds and lines columns for in the Bets worksheet?
Note that these columns only appear in the Advanced version of the spreadsheet.  You can use the Standard version of the betting tracker if you don't need them.  These columns enable you to track whether your wager odds and/or line (a.k.a. spread) are better than the closing odds and lines prior to the event start.  These columns are for advanced users only and can be safely ignored.  Just be sure to remove the sample data in these columns before you use this spreadsheet.
I'm getting ##### displayed instead of numbers.  How can I fix this?
If a number is too large for Excel to display you will see ##### displayed.  Simply increase the column width to fix the issue.  The instructions to unlock the workbook are shown above in the 'Worksheet protection' section.
What are the Tipper Analysis columns for?
Note that these columns only appear in the Advanced version of the spreadsheet.  You can use the Standard version of the betting tracker if you don't need them.  Many punters place bets based on the advice of a tipper/capper.  Often the odds change after the tipper recommended a selection so if you follow the tipper's advice you may not be getting the same payout as their published tip.  The Tipper odds and line columns enable you to track the tipper's betting performance using the odds & handicaps they published, rather than using the odds & handicaps available to you when you followed their tip.
Does this spreadsheet support multiple currencies?
No, this spreadsheet supports one currency only.  Support for multiple currencies may be added to future versions.  In the meantime we suggest you maintain a separate copy of the spreadsheet for each currency.
Troubleshooting
If you cut and paste bet data from one row or column to another you can sometimes throw off the rest of the spreadsheet's calculations.  If you need to reset the background calculations, unlock the Bets sheet (see instructions above) and highlight cells BL12 to CF12 (note this is row 12, not row 11).  You will need to scroll to the right to view these cells.  Double click on the small black box at the bottom right hand corner of cell BG11.  This will reset all formulas for the cells below based on row 10, which is likely to be in its original state.
In the worst case scenario, simply start over by copying and pasting your betting data into a clean copy of the betting tracker.  Use the procedure below when you do so.
Pasting in data from a previous version
Because some cell validation formulas have changed, it is strongly advised that when you copy betting data from a previous worksheet (using Edit -> Copy), instead of selecting Edit -> Paste, select Edit -> Paste Special… -> Select 'Values' and then click OK.  This will paste in the new data without overriding the new validation formulas.
Support
The homepage for this spreadsheet is:
http://www.aussportsbetting.com/tools/staking-plan-calculator-excel-spreadsheet/
Questions can be submitted through:
http://www.aussportsbetting.com/contact/
A support and discussion forum can be found here:
http://www.aussportsbetting.com/forum/