I have been struggling with soccer and goalscorers. Bookmakers iffer prices for 20 or more players, taking into account the probability of a player playing in a match. The player expectations surpass team expectations. Any idea? Same principle for shots and ahot On target
G'day lad, the 'player expectations' might surpass the 'team expectations' in total odds due to the margin built in by the bookmaker. To cover their liability in the case of any missing information, bookmakers would most likely increase their "margin of safety" when providing odds for individual player markets. These markets are more volatile than overall team markets, as usually teams are more consistent 👍 I hope that answered your question lad, ask away if you have anymore 🔥
Hi lad! Wow you are a master at Excel!! What I want to be able to do is create a basic pickleball (or tennis) round robin generator for social play events that I run at my local tennis club. We only play doubles (so 4 per court). Because every session is different based on who turns out, the generator needs to accommodate the variables. Number of players, maximum of 30 Number of courts, maximum of 7 Number of rounds, maximum of 10 It needs to then tell me for example, Round 1, Court 1 players 1&9 vs 2&8, Court 2, 3&7 vs 4&6 and so on. Is this possible? Thanks in advance!
Starting an in house Darts and Pool league using this spreadsheet. Thank you so much. I enjoyed the process of setting it up and learnt some things I never knew along the way!
Thanks lad 🔥 I’m planning on releasing a simple NFL ELO Model shortly. One of the limitations of the ELO model is that it can’t do over/under goals accurately, as it doesn’t take into account the Attack and Defence strength of teams (only their overall ratings). However, it is possible to use the difference in ELO ratings between two teams to come up with a handicap or goals line.
@@excel_ladz I know you could use the Poisson method to predict under and over goals, but mostly it won't be accurate, and you have to download various league tables(English, German e.t.c) Is there a model to perform this task?
Hey, at 15:19 im getting something where there is a gap after the 10th team and then teams 1-10 come up again, does anyone know what is causing this or how i could fix it please? Thanks
Hi a couple of prerequisites required for the fixture list i am trying to create 1 ) limit the number of consecutive home or away games to X 2 ) Ensure that there is an equal split of home and away fixtures for the round ie if a ten team round, 9 games then there should be a 5-4 split (5 teams 5 home ) (5 teams 4 home)
Thanks lad 💪 Using the SUMPRODUCT function, you could grab the number of away wins. Then, instead of multiplying by 3, you would multiply by 4 (added bonus point). This same concept can be applied for a draw too.
Great idea lad 🔥 I've sort of already done the knockout stage in the 'World Cup' videos, but I definitely should publish a model where you can input the teams and get a Group Stage + Knockout fixture list. To get updates for when I publish this model lad, I recommend joining the Excel LADZ Patreon either as a member or for free 💪 Check it out here: www.patreon.com/ExcelLADZ
is there anywhere i can download this fixture and league table please sir ? ive started a competiotion and the league table im using hasnt worked. its giving me anightmare ???
@excel_ladz Thanks for the reply. Appreciate it. £20 is a bit steep for one spreadsheet, but thanks anyway brother. I'll check your video out properly and hopefully get myself somewhere near. Thanks again
@excel_ladz sorry mate, is there any way I can check this file will work for what I want before I pay for it ??? I'm really struggling to get it done. I need this sheet for my competiton, and I'm happy to pay £20 as long as it works 💪?
Hallo, can you create multiple leaderboards for goals scorers? For example leaderboard with Season 1 with the goals scorers, leaderboard with Season 2 with the goals scorers,..etc. And One leaderboard with the all time goalscorers. To make it that the leaderboard with the all time goalscorers it is updated automatically when seasons leaderboards get new goals.
Hi lad, you would need to modify it. In this video, I capped the number of possible teams to 24. However, that's just an arbitrary number. If you signed up to the Patreon lad you could message me and I'll help you make the necessary changes to the file 👍
I'm facing a similar issue with a model I'm currently working on. I have 27 players who need to play against each other twice. However, whenever I set the team number to 27, the fixtures don't look correct. When I reduce the team number to 22, the fixtures appear accurate.Please what can I do to resolve this? @excel_ladz????
hello there! i'm writing simultaneously the command with the video in 20:39 but still i get too few arguments error. why do i keep getting this error? is there something i miss or is it the excel's fault? edit: i remade all of the spreadsheet so far and now it rejects that 0.01 value you wrote in 18:50 and says there's a problem with this formula. what should i do?
Hi lad, it's definitely a messy formula. For cell A5 in the 'Fixtures' worksheet, paste the following formula: =IF(IF(OR(MOD($A$4+(1/((EVEN($L$1)/2)+1))+(1/((EVEN($L$1)/2)+1))*(ROW()-ROW($A$4)),1)0.99),"",ROUNDDOWN($A$4+(1/((EVEN($L$1)/2)+1))*(ROW()-ROW($A$4)),0))>(EVEN($L$1)-1)*$L$2,"",IF(OR(MOD($A$4+(1/((EVEN($L$1)/2)+1))+(1/((EVEN($L$1)/2)+1))*(ROW()-ROW($A$4)),1)0.99),"",ROUNDDOWN($A$4+(1/((EVEN($L$1)/2)+1))*(ROW()-ROW($A$4)),0))) If there's still an error, it will be because there's something wrong with another part of the model unfortunately. Good luck 👍
@@excel_ladz i pasted it but still have the same problem with the 0.01 value. maybe i've made some mistakes before this step which may effect it. thanks for your help :)
@@excel_ladz Teach me to read the comments earlier, after spending an hour reading and re-reading the formula i still got the too few arguments error. read this.....copied this....pasted this.....error gone. amazing work excellent videos, all clearly explained thanks Ladz.
This has been such a huge help!! Thank you! Adapted it for a darts league. Having one little issue... On league table, Ive followed the goals for but is coming up with a #VALUE! error. I can't see a reason for this. In my 'away_score' column I do have a formula (just for ease as the score is always out of 11). Could it be this causing the problem? It doesn't seem to be affecting other columns in table. Any ideas please?
I'm currently creating a Fixture List and League Table in excel of my own but has come to a stuck when trying to rank the 8 teams from their ranking points using the Rank.EQ formular. After completing the formular corectly as given in the video using the rank.eq function, the columns are still blank. please sort this issue. Thank you
Good table. I am experiencing an issue with the league Table. The number of games played woks fine. But the number of win says N/A. I ttried averthing. but to no avail. Can someone help me sort it out?
At 36.20 when editing the formula for the goals for and against, I've followed your formula change but for some reason the formula is returning a #value! Any ideas on what's causing this?
Hi mate! Is this after downloading the file, or are you working on it yourself? If you're a member, you can shoot me a message through there and I can take a closer look 😉 If not, I'll try and answer though here!
@@excel_ladz Hi, I was working my way through your formulas, copying them on paper and entering the formulas onto my spreadsheet. Had loads of problems, my errors in copying, syntax differences etc. I did download it but got a Macro warning which I couldn't over-ride that so couldn't use it. I don't know if that is your protection. I did join partly but then it was £19. I don't mind paying if I can download it and it works, cheers :)
@@excel_ladz Yes I am working on it myself but really slow progress. I'm doing it for a Table Tennis league which I want automated. I've made the cards okay but want the captains to be able to print them off for their particular team with date & opponents so all they have to do is fill in the players on the night, and need to do an averages sheet too. I really want to do a Ratings program too. The hardest problem so far is the ratings but the fixtures have me baffled too.
@@paulpells1864 Good luck mate. Unfortunately, there's not enough context for me to provide solutions to why there's an error in C16 right now. What worksheet was that in?
The fixtures Tab cell C16. Clearly it works in yours when you pressed enter, but mine said I entered too many arguments. The double nested IF statements I think caused me the problem but not you 😅
G’day lads, if you have a question or suggestion let me know 🔥
I have been struggling with soccer and goalscorers. Bookmakers iffer prices for 20 or more players, taking into account the probability of a player playing in a match. The player expectations surpass team expectations. Any idea? Same principle for shots and ahot
On target
Can you show my video in youtube script paython
G'day lad, the 'player expectations' might surpass the 'team expectations' in total odds due to the margin built in by the bookmaker. To cover their liability in the case of any missing information, bookmakers would most likely increase their "margin of safety" when providing odds for individual player markets. These markets are more volatile than overall team markets, as usually teams are more consistent 👍 I hope that answered your question lad, ask away if you have anymore 🔥
Hi lad! Wow you are a master at Excel!! What I want to be able to do is create a basic pickleball (or tennis) round robin generator for social play events that I run at my local tennis club. We only play doubles (so 4 per court). Because every session is different based on who turns out, the generator needs to accommodate the variables.
Number of players, maximum of 30
Number of courts, maximum of 7
Number of rounds, maximum of 10
It needs to then tell me for example, Round 1, Court 1 players 1&9 vs 2&8, Court 2, 3&7 vs 4&6 and so on.
Is this possible?
Thanks in advance!
suggestion: let me download without having to spend the only money i have left
Starting an in house Darts and Pool league using this spreadsheet. Thank you so much. I enjoyed the process of setting it up and learnt some things I never knew along the way!
That’s great mate! I love hearing these types of comments 🔥
Amazing tutorial, took me a while to go through it but I got it up and running! Thanks for such a great excel document
Great work as always. My suggestion is for a way to compute over and under for goals, using the elo rating system.
Thanks lad 🔥 I’m planning on releasing a simple NFL ELO Model shortly. One of the limitations of the ELO model is that it can’t do over/under goals accurately, as it doesn’t take into account the Attack and Defence strength of teams (only their overall ratings). However, it is possible to use the difference in ELO ratings between two teams to come up with a handicap or goals line.
@@excel_ladz I know you could use the Poisson method to predict under and over goals, but mostly it won't be accurate, and you have to download various league tables(English, German e.t.c) Is there a model to perform this task?
Thank you so so much for this. If really helped and taught me much about excel🎉
Best video yet.
Brilliant. Thank you
Brilliant !! Thank you Lad
This is awesome!
Hey, at 15:19 im getting something where there is a gap after the 10th team and then teams 1-10 come up again, does anyone know what is causing this or how i could fix it please?
Thanks
Cool stuff
Hi a couple of prerequisites required for the fixture list i am trying to create
1 ) limit the number of consecutive home or away games to X
2 ) Ensure that there is an equal split of home and away fixtures for the round ie if a ten team round, 9 games then there should be a 5-4 split (5 teams 5 home ) (5 teams 4 home)
do you have something similar for a knock out tournament?
If I join the channel I can download this fixture list?
Hi, great table, many thanks. Is there a way of adding a bonus point for an away win and half a point for an away draw Please. Cheers
Thanks lad 💪 Using the SUMPRODUCT function, you could grab the number of away wins. Then, instead of multiplying by 3, you would multiply by 4 (added bonus point). This same concept can be applied for a draw too.
Many thanks for the reply, how and where would I put the SUMPRODUCT formula please. In the bottom table on the League table sheet?
Got this so far, but returning a 0. =IF(SUMPRODUCT(away_score>home_score),1)+IF(SUMPRODUCT(away_score=home_score),0.5) any thoughts?
if we have even teams do we have to do the long formula?
Hi Are you able to do one for my darts league where i can generate league and also will i be able to put more teams in if so
Can you make football cup tournaments group stage and knockout
Great idea lad 🔥 I've sort of already done the knockout stage in the 'World Cup' videos, but I definitely should publish a model where you can input the teams and get a Group Stage + Knockout fixture list. To get updates for when I publish this model lad, I recommend joining the Excel LADZ Patreon either as a member or for free 💪 Check it out here: www.patreon.com/ExcelLADZ
tnxs!
I have script scoré exacte VBA excel
Do you sell the programmes individually?
Hi lad, not right now. You can download the spreadsheet by becoming a member of the Excel LADZ Patreon for a month 🔥
@@excel_ladz I see there's a monthly charge to become a member.I would just want the Spreadsheet as it's the best I've seen .ty
is there anywhere i can download this fixture and league table please sir ? ive started a competiotion and the league table im using hasnt worked. its giving me anightmare ???
Hi mate, you can download the file here: www.patreon.com/posts/excel-ladz-table-89532234
@excel_ladz Thanks for the reply. Appreciate it. £20 is a bit steep for one spreadsheet, but thanks anyway brother. I'll check your video out properly and hopefully get myself somewhere near. Thanks again
@excel_ladz sorry mate, is there any way I can check this file will work for what I want before I pay for it ??? I'm really struggling to get it done. I need this sheet for my competiton, and I'm happy to pay £20 as long as it works 💪?
I used a free version which works great, but because I have 22 teams it creates drama !!!
@@quirk1982 It works lad 🔥 22 teams is absolutely fine. If it doesn't, reach out and I'll give you a full refund.
Hey lad. Do you know a method on predicting match outcomes using the last two digits i.e 2.90 odds for 0-8 corners, 2.55 odds for 12+ corners ?
Hallo, can you create multiple leaderboards for goals scorers? For example leaderboard with Season 1 with the goals scorers, leaderboard with Season 2 with the goals scorers,..etc. And One leaderboard with the all time goalscorers. To make it that the leaderboard with the all time goalscorers it is updated automatically when seasons leaderboards get new goals.
Brillaint
Will the file on your site support 32 or more teams as it is or would I need to modify it?
Hi lad, you would need to modify it. In this video, I capped the number of possible teams to 24. However, that's just an arbitrary number. If you signed up to the Patreon lad you could message me and I'll help you make the necessary changes to the file 👍
I'm facing a similar issue with a model I'm currently working on. I have 27 players who need to play against each other twice. However, whenever I set the team number to 27, the fixtures don't look correct. When I reduce the team number to 22, the fixtures appear accurate.Please what can I do to resolve this? @excel_ladz????
hello there! i'm writing simultaneously the command with the video in 20:39 but still i get too few arguments error. why do i keep getting this error? is there something i miss or is it the excel's fault?
edit: i remade all of the spreadsheet so far and now it rejects that 0.01 value you wrote in 18:50 and says there's a problem with this formula. what should i do?
Hi lad, it's definitely a messy formula. For cell A5 in the 'Fixtures' worksheet, paste the following formula: =IF(IF(OR(MOD($A$4+(1/((EVEN($L$1)/2)+1))+(1/((EVEN($L$1)/2)+1))*(ROW()-ROW($A$4)),1)0.99),"",ROUNDDOWN($A$4+(1/((EVEN($L$1)/2)+1))*(ROW()-ROW($A$4)),0))>(EVEN($L$1)-1)*$L$2,"",IF(OR(MOD($A$4+(1/((EVEN($L$1)/2)+1))+(1/((EVEN($L$1)/2)+1))*(ROW()-ROW($A$4)),1)0.99),"",ROUNDDOWN($A$4+(1/((EVEN($L$1)/2)+1))*(ROW()-ROW($A$4)),0)))
If there's still an error, it will be because there's something wrong with another part of the model unfortunately. Good luck 👍
@@excel_ladz i pasted it but still have the same problem with the 0.01 value. maybe i've made some mistakes before this step which may effect it. thanks for your help :)
@@excel_ladz Teach me to read the comments earlier, after spending an hour reading and re-reading the formula i still got the too few arguments error. read this.....copied this....pasted this.....error gone. amazing work excellent videos, all clearly explained thanks Ladz.
This has been such a huge help!! Thank you!
Adapted it for a darts league.
Having one little issue...
On league table, Ive followed the goals for but is coming up with a #VALUE! error.
I can't see a reason for this.
In my 'away_score' column I do have a formula (just for ease as the score is always out of 11).
Could it be this causing the problem? It doesn't seem to be affecting other columns in table.
Any ideas please?
I worked out it is because of the formula, can I make any amendment to allow for formula?
I'm currently creating a Fixture List and League Table in excel of my own but has come to a stuck when trying to rank the 8 teams from their ranking points using the Rank.EQ formular. After completing the formular corectly as given in the video using the rank.eq function, the columns are still blank. please sort this issue. Thank you
Good table. I am experiencing an issue with the league Table. The number of games played woks fine. But the number of win says N/A. I ttried averthing. but to no avail. Can someone help me sort it out?
idk why but when I input a score only the away team displays as a match played but for the home team it dosent
If i do the action after 7:15, the empty cells get a value problem
At 36.20 when editing the formula for the goals for and against, I've followed your formula change but for some reason the formula is returning a #value! Any ideas on what's causing this?
Nevermind, I finally realised I had some text data down the bottom in one of the cells. It now works :D
Even number of teams but still have two playing against each other every week. How can I fix that?
Am i able to have a one off payment for the Fixture List & League Table in Excel download please
Please excel data with over under 2.5 goals :)
Great video! But I get stuck immediately :(
This function does not work for me: =OM(§A15
Did you find a fix?
Ive got the same problem, seems like i cant use A15 two times... But i dont know why :/
ua-cam.com/video/6qfYAptpzKw/v-deo.html
how to distrubute teams before drawing a fixture
please comment on this video
In cell c16 it says you have entered too many arguments in my excel..
Hi mate! Is this after downloading the file, or are you working on it yourself? If you're a member, you can shoot me a message through there and I can take a closer look 😉 If not, I'll try and answer though here!
@@excel_ladz Hi, I was working my way through your formulas, copying them on paper and entering the formulas onto my spreadsheet. Had loads of problems, my errors in copying, syntax differences etc. I did download it but got a Macro warning which I couldn't over-ride that so couldn't use it. I don't know if that is your protection. I did join partly but then it was £19. I don't mind paying if I can download it and it works, cheers :)
@@excel_ladz Yes I am working on it myself but really slow progress. I'm doing it for a Table Tennis league which I want automated. I've made the cards okay but want the captains to be able to print them off for their particular team with date & opponents so all they have to do is fill in the players on the night, and need to do an averages sheet too. I really want to do a Ratings program too. The hardest problem so far is the ratings but the fixtures have me baffled too.
@@paulpells1864 Good luck mate. Unfortunately, there's not enough context for me to provide solutions to why there's an error in C16 right now. What worksheet was that in?
The fixtures Tab cell C16. Clearly it works in yours when you pressed enter, but mine said I entered too many arguments. The double nested IF statements I think caused me the problem but not you 😅
i DONT UNDERSTAND why u try to go so fast & go onto next screen when function is completed?