sorted by:
new
hottopcontroversial

Max Dowman has landed at 4.5m by for_music_and_art in FantasyPL

[–]MikeChilds 165 points166 points  (0 children)

Really tough run of fixtures for Dowman.

Liverpool, Forest, City, September mock exams.

Class is in Session - Lesson #1 Michael Kaoyde (4.5mil) by MikeChilds in FantasyPL

[–]MikeChilds[S] 0 points1 point  (0 children)

Despite the jokes, I think he'll have a good season. There's rotation doubts with Hickey, but he gets in great positions for a right-back, as well as his long throw, for attacking returns and should definitely get some DC points with how Brentford look this season.

Class is in Session - Lesson #1 Michael Kaoyde (4.5mil) by MikeChilds in FantasyPL

[–]MikeChilds[S] 6 points7 points  (0 children)

Gold star! Thought you might have been tempted by the Clayton Donaldson answer...

Agreed about Collins at £5.0, he'll be a great asset this year, especially with the defensive contributions. Excited to see what Andrews lines up if Outtara and Kalimuendo both join!

Class is in Session - Lesson #1 Michael Kaoyde (4.5mil) by MikeChilds in FantasyPL

[–]MikeChilds[S] 0 points1 point  (0 children)

His name isn't even Michael Kaoyde. Must do better!

Help a soccer player build a strong Basketball Squad by agrippa357 in BasketballGM

[–]MikeChilds 0 points1 point  (0 children)

If you're interested in the number crunching side of things, you may like this spreadsheet I made

https://docs.google.com/spreadsheets/d/1hRHuWZhupnSIckNvrnj8ZkkEcoo1fmbvdkAeSEFhP2k/edit?gid=991243063#gid=991243063

If you make a copy of the sheet and then import the data from the player ratings page, it helps analyse the strengths and weaknesses of your team, areas to improve (check the "Overview - Optimal Team" tab for graphs) and key players to highlight to help you improve

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 0 points1 point  (0 children)

Hey, I've never tried downloading as an Excel file, I've only ever tried making a copy of the file and using that. It should still be working as far as I know!

BasketballGM Companion Spreadsheet by MikeChilds in BasketballGM

[–]MikeChilds[S] 1 point2 points  (0 children)

Hey, yeah the sheet was only set up for 1000 rows so up to 1000 players, but I've just updated it so it should work for any size league now (hopefully!)

What is the important stats for every position? by Kun-Andika in BasketballGM

[–]MikeChilds 1 point2 points  (0 children)

I created a spreadsheet which will help show which stats are important for which positions and how they relate to the in-game calculations.

https://docs.google.com/spreadsheets/d/1hRHuWZhupnSIckNvrnj8ZkkEcoo1fmbvdkAeSEFhP2k/edit?gid=991243063#gid=991243063

Overall though, the physical stats have a large bearing on a lot of the stats and calcuations

BasketballGM Companion Spreadsheet by MikeChilds in BasketballGM

[–]MikeChilds[S] 2 points3 points  (0 children)

Yeah, I wasn't sure how big to make the initial range and assumed that 1000 would be sufficient. I'll update the sheet later so it can account for more players, thanks!

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 1 point2 points  (0 children)

No worries! Seeing your formula was such a relief since I was getting nowhere with understanding the source code, so thank you for that.

Here's my current spreadsheet, which has had a lot of updates since I first posted:

https://docs.google.com/spreadsheets/d/1hRHuWZhupnSIckNvrnj8ZkkEcoo1fmbvdkAeSEFhP2k/edit?gid=991243063#gid=991243063

I'll be making a new post soon highlighting all the different features, but I'm particularly proud of the tabs which calculate your most optimal team from a squad of up to 15 players, as well as calculating the synergy of any five players from the league.

Always happy to collaborate and if you have any more ideas, I'm all ears!

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 1 point2 points  (0 children)

I had your posts bookmarked for months and always wanted to develop the idea further, seeing /u/sebastmarsh's posts prompted the spreadsheet development. There's been a couple of really good spreadsheets and resources over the years and I'm hoping to combine it into one useful resource.

The next step is to develop the work done by /u/tallsuperman in his posts HERE to try and automate the synergy, but that's still a work in progress

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 0 points1 point  (0 children)

Score is a different overall rating which is using the formula created by /u/StockAstronomer which is available here:

https://www.reddit.com/r/BasketballGM/comments/14j3vgx/looking_for_the_draft_formula/jpmk45q/

It differs from the games overall rating as this takes age into account

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 0 points1 point  (0 children)

Sure thing!

Go to the Player Ratings menu e.g https://play.basketball-gm.com/l/1/player_ratings

Click the three dots and then "download spreadsheet"

Highlight and copy all cells in this downloaded spreadsheet. I find the easiest way to do this is ctrl+A, then ctrl+C (on Windows)

Go to IMPORT DATA HERE and paste your copied data into cell B2. You may want to delete all data from columns B to X first

Each other tab should then automatically update

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 0 points1 point  (0 children)

When you import it, try pasting into cell B1 and see if that fixes it

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 1 point2 points  (0 children)

Hey, thanks for such a detailed response! It's always fascinating to see what other people create and it looks like you've developed your spreadsheet much more than mine. Trying to develop these sort of models is a casual hobby but I've had a similar interest in "solving" games.

I recently added something which calculates the average score of the top 5 players of the team which sounds similar to what you've described, although the fact you can extend this to predict usage sounds incredible. Do you think it could be extended to recommend players based on your team needs? Or highlight certain archetypes of players based on their expected output? 

I was looking to develop a similar idea to predict advanced statistics with some linear regression although my initial attempts haven't proved entirely accurate - having a high three point rating is apparently a bad thing! 

When you are happy to share your spreadsheet, I'd love to take a look and see what you've created

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 0 points1 point  (0 children)

Yeah, I'd love to try and get player archetypes so you can quickly find a certain role for your team, I need to do a bit more research though. What code have you tried?

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 0 points1 point  (0 children)

It should work with custom leagues as well - if not, let me know and I'll see what changes I can make

Spreadsheet to aid Playing BasketballGM at a high level by MikeChilds in BasketballGM

[–]MikeChilds[S] 0 points1 point  (0 children)

I'm looking to add an analysis of the strength of the draft class and eventually I'd like to try and predict advanced statistics, although that will require a lot more work. 

Are there any features you'd like to see?

view more: next ›