Building a Poisson Probability Football Betting Model – (Part II)

Building a Poisson Probability Football Betting Model – (Part II)

Setting up your Spreadsheet

The first page of your Poisson Probability Football Betting Model is complete.   Now we move on the 2nd page.

Building a Poisson Probability Football Betting Model

We’ll start designing the Stats UK – POI tab.  You are well on your way to having your first Football Betting Model.

Poisson Probability Football Betting Model - Name your Tabs

Poisson Probability Football Betting Model – Name your Tabs

Designing the Layout – Stats UK – POI Tab

Select the ‘Stats UK – POI’ Tab.

The header should be made up of 3 rows, the main data will be in row 3.

There are 2 sections, Home and Away

Poisson Probability Football Betting Model - Name your Columns

Poisson Probability Football Betting Model – Name your Columns

This spreadsheet is quick and easy to set up.  It should’t take more than 5 minutes

Team = Team Name (from chosen Division)

Pld = (Games) Played

W = Wins

W% = Win Percentage

D = Draws

D% = Draw Percentage

L = Losses

L% = Loss Percentage

GS = Goals Scored

GSpG = Goals Scored per Game

GC = Goals Conceded

GCpG = Goals Conceded per Game

PTS = Points

GD = Goal Difference

AS = Attack Strength

DW = Defensive Weakness

Then repeat for the Away section.

You will notice the appearance of Attack Strength and Defensive Weakness once again.  These are the key elements that the POISSON Probability Football Betting Model are made up from.

All done.

Once you add your Team names, your second page of you Football Betting model is completed and should look like this

Poisson Probability Football Betting Model - Name your Columns

Poisson Probability Football Betting Model – Name your Columns

Double check everything is as it should be and save your work.

Designing the Layout – Tables UK Tab

The final tab we need to set up is the “Tables UK” Tab

Again, really straight forward and three repetitions of the same section

Poisson Probability Football Betting Model - Name your Columns

Poisson Probability Football Betting Model – Name your Columns

Pos = (League Position)

Team = Team Name

P = Played

W = Won

D = Drawn

L = Lost

G+ = Goals Scored

G- = Goals Conceded

GD = Goal Difference

Pts = Points

Repeat for the final 2 sections and you are down.  The final table should look like this.

Poisson Probability Football Betting Model - Name your Columns

Poisson Probability Football Betting Model – Name your Columns

Set up Completed

Thats the setup of you model completed.  Now we start to move on the more complex part of adding the calculations and formulas

Make sure you follow our page on Facebook – How to build a Football Betting Model for all the updates

Upgrade your Betting Knowledge..

  • Upgrade your Betting Knowledge..

    Getting Betting Guide & Great tips sent straight to your inbox!

  • Winning with our bets ? Let us know or subscribe to our RSS feed Sign up to BET365 now for the best deals around
    Tagged , , , . Bookmark the permalink.

    One Response to Building a Poisson Probability Football Betting Model – (Part II)

    1. Pingback: Building a Poisson Probability Football Betting Model - (Part I) -