Видео

It’s just so based on matchups but I reckon if you combine the model with your own eye test it could be very profitable

Thank you! This was immensely helpful!

does it update automatically?

hello there save as type which option ?? cause i save it but when i opened it's not saving right

Thanks for the video. I have an issue though, how come I never get any Tie in my simulations ?

This isn't an accurate sim. Love the effort, but to sim the monte hall problem you need to sim the decision tree. Step 1: choose 1. Step 2: remove one false answer. Step 3: choose to stay or switch between remaining 2. Step 4: compare results of staying vs switching

I'm having a problem with the IFS function

The Analysis Sheet, should the percentages be constant? Mine doesn't change, but values change in the other sheets when I hit backspace or when I tell Excel to recalculate formulas

7:42 is that really necessary? It's not like teams/players had no injuries during the previous season? I don't see the purpose of that

can you make a college basketball and football model?

Awesome! Can you do one for the NRL?

I can make work home XG calculation work fine but when I drag the formula down (14:00 mins) and change to "away_xg" I get an error? Any suggestions? Thanks

Hi. What do I do if instead of points for win, draw, loss i just want to put in points on the table is the same as they score. Like snooker where a score is 5 frames to 3 where you get 5 points for winning 5 and other player gets 3 points for winning 3 frames? Great vid. Thanks

This was absolutely spectacular. I'm a complete novice, and had a great time following this. Created a table for a league I am in that is run by a mate, to make sure they're not fobbing me off!! Thanks so much

Hi, just used the same exact formula, exp. Scores is reaching a very high number... is there any fix or leave it as is?

Don't give the impression that it's free. $23.50 a month !!! I'll pass Thank you.

Your Excel skills are top-notch. Tell me, how can I update the matches on the excel on a regularly basis without interfering with the data in the table?

too bad it didnt work for the giants vs browns

Just a quick thing, in the fixtures table, it isnt the away and home team, its the winner and loser, the @ symbol signifies if the away team won

Another W video as always

does the all the data updates automatically, second question do you sell these Models or no? because i want to buy if its so.

NFL model has date and number problems RE: last 3 games etc pls check all fornmats

Excellent video have you done the follow up video how to return a league table as of a round?

Love the video. Could you possibly show the passing and rushing stats per team/game as well with the projected score?

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?

Can this model make long term ROI profit if I use it? Is it possible to bolt this model in Google spreadsheet, excel 2010 and 2016?

Good video. But i think it was nice to have a video explaining from zero. like to get the live data and updated. Because some times the power query gives erros and it is difficult to mantain the live data working specially if there are a lot of tables..

You should do a short 30 second reel of this video (or an old one with the outcomes at the end) and put it on different socials.

36:55 is the biggest let function I have ever seen 👀

G'day, lads! Please let me know if you have any questions/suggestions below 🔥 If you'd like to download the file and become a member on Patreon, here's the link: www.patreon.com/posts/excel-ladz-2024-111333965

I just want to say you are a fking lad for these videos ! I am doing a university assignment for Data Analytics and we have use Monte Carlo, whatif analysis (E.g. goal seek, solver), breakeven analysis, hypothesis testing or regression and other statistical topics such as median/mean to tell a story about something. I want to use monte carlo to predict the probability of a team winning when their best team is performing below. HAVE YOU GOT ANY ADVICE FOR ME or which videos of yours's I can watch that will help me ? We have not learnt Poisson Distribution or anything mentioned outside of the above topics. How Would you tell a story about how we can use data analytics to predict outcomes on sportsbet ?

Thnks for tour hard work and sharing with us.

Do you have a NCAA Football ELO model?

evaluate the money line bet..

try starting from the fact that 1 door is always eliminated from the beginning as if you couldn't possibly choose the door with goat that gets revealed. it's just 50/50 dude.

Having some trouble with the function for players in player working, rows are a lil different cause im using 2023/2024 data (teams are column D) but this is what I have written down: =IFERROR(INDEX('raw player stats'!$B$3:$B$1002,SMALL(IF('raw player stats'!$D$3:$D$1002=XLOOKUP(Results!$E$2,Teams,teams_id),ROW('raw player stats'!$D$3:$D$1002)-ROW('raw player stats'!$D$3)+1),ROWS('raw player stats'!$D$3:D6))),"") Thanks!!!

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!

How to calculate the actual home advantage rather using arbitrary number ?

It's possible to do for soccer/football

Not great to follow for me

Very helpful video! I would like to add the form of each team (last 5 matches). Do you have any idea how?

Thanks so much for this. the best step by step video. you made it super easy to follow

tnxs!

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 there, if I wanted to add another criteria for "knockdowns/15 minutes", could you help me modify the formula on the 'Final' worksheet calculating the % chance of winning (starts with EXP('Fight Data'!A2+(D17-I117)*? Thanks

What should I study in order to create such models

if someone has to start from zero, what should he needs to study in order to make such models.

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?

Doing research currently but do you know if it's possible to automate ESPN daily stats updates into an excel file? I go through every morning and out of the 50 or so batters, update their last 7 hit/hr stats, august hit/hr stats, if they got a hit last game and total games they got a hit out of games played that month. About a tedious hour thing everyday just seeing if you had any insight, thanks!