Updated Football Spreadsheet

[StellaBot]

Here is my updated football spreadsheet

Would also point out that if there are zeros within the spreadsheet ie 0 games played or 0 goals for and against
the spreadsheet cannot calc

An example would be scottish championship
if you enter a team who hasnt played yet V a team who has
you should see and understand

EDIT
I have input a game at 16.30 today

[cmuddle]

Thanks a lot mate, but don't understand your spreadsheet.

It might be just me, I am not a data person but trying to learn.

Would appreciate more explanation for the stupid ones like me.

Best

[Derek27]

Thanks a lot mate, but don't understand your spreadsheet.

It might be just me, I am not a data person but trying to learn.

Would appreciate more explanation for the stupid ones like me.

Best

I've never understood StellaBot's posts, but I was hoping he might be a spreadsheet wizard.

[Derek27]

Here is my updated football spreadsheet

Would also point out that if there are zeros within the spreadsheet ie 0 games played or 0 goals for and against
the spreadsheet cannot calc

An example would be scottish championship
if you enter a team who hasnt played yet V a team who has
you should see and understand

EDIT
I have input a game at 16.30 today

I never realised Excel has a Poisson function, I just assumed you'd have to calculate it manually.

cmuddle, the link below may help explain it.

https://help.smarkets.com/hc/en-gb/arti ... ll-betting

[cmuddle]

Here is my updated football spreadsheet

Would also point out that if there are zeros within the spreadsheet ie 0 games played or 0 goals for and against
the spreadsheet cannot calc

An example would be scottish championship
if you enter a team who hasnt played yet V a team who has
you should see and understand

EDIT
I have input a game at 16.30 today

I never realised Excel has a Poisson function, I just assumed you'd have to calculate it manually.

cmuddle, the link below may help explain it.

https://help.smarkets.com/hc/en-gb/arti ... ll-betting

Thanks Derek,

now it makes sense.
To me it looks like too much calculation for small margins and still might not be profitable because of too many variables not considered in the spreadsheet, as mentioned in the article from Smarkets.
That's my foolish opinion

[Mcdonkey]

how do you input other teams info?! or leauges for that matter?