Toby's FHM Advanced Analytics Tool is here! - Page 3

TobyInHR · 01-04-2023, 10:37 PM

Major updates to my advanced stat tracker! A new webapp is available to help clean your CSVs prior to loading them, which entirely eliminates the slow loading and occasional freezing of the current Sheet. This is thanks to my switch to using R as my data manipulation program, rather than sheets, which has also provided me with a collection of tools for much more effective modeling for xG, GAR, and WAR! Now, a script will do all the calculations, and export a few CSVs that can be put into Sheets, taking the labor off of Google and improving performance.

Second, I have made the necessary changes to allow for expansion teams to be added! Instructions are in the video. Thanks to the FHM team for the most recent update, which added in a bunch of crazy useful stats! Please use this video to see how to use the new tools, as well as how to add expansion teams. For those interested, I also cover my modeling process later in the video.

https://youtu.be/1TSe41OWWwI

TobyInHR · 01-04-2023, 10:38 PM

Quote:

Originally Posted by vign5440

this is amazing, thanks so much for all your hard work.

I know the current set up isn't really compatible with custom games - but what about standard games with a custom team in it? i.e. I added an expansion team to my franchise mode and I don't see it come up in the advanced metrics drop down. is there a way I could make that work within the current sheet?

Take a look at the video I just posted -- big update to the Sheet which now supports expansion teams! Let me know if you run into any issues. I just started a new save with an expansion team, so I was able to troubleshoot with my own game. I may have overlooked a few things though, so definitely mention any problems that may pop up.

Gazkyo · 01-07-2023, 12:21 AM

When I am cleaning the files there are only 3 upload buttons instead of 4 in the video. The missing one is cleaned team records. How do I fix this?

TobyInHR · 01-07-2023, 04:57 PM

Quote:

Originally Posted by Gazkyo

When I am cleaning the files there are only 3 upload buttons instead of 4 in the video. The missing one is cleaned team records. How do I fix this?

Interesting, I’ll take a look. Sounds like the web app may have reverted to an old version. I’ll check on it when I get home.

TobyInHR · 01-07-2023, 06:37 PM

Quote:

Originally Posted by Gazkyo

When I am cleaning the files there are only 3 upload buttons instead of 4 in the video. The missing one is cleaned team records. How do I fix this?

https://tobyinhr.shinyapps.io/FHM_Data_Cleanup/

Appears to be working correctly now.

DragoReborn7 · 01-07-2023, 09:56 PM

Def working now. Just wanna say you're an absolute hero for this tool! Not many would put in this kind of work for such a nice project

tomkmb · 01-08-2023, 04:50 AM

Quote:

Originally Posted by DragoReborn7

Def working now. Just wanna say you're an absolute hero for this tool! Not many would put in this kind of work for such a nice project

I second this, thanks for all the work you've put in Toby!

Gazkyo · 01-08-2023, 06:58 AM

Yes it working now. Awesome!

TobyInHR · 01-08-2023, 02:27 PM

Thanks everyone! It means so much that you all are finding good use out of this tool. It's a labor of love, and like I have said before, it gives me so much fulfillment to add this level of "custom" input into one of my favorite games. Being able to share it with the community takes that to a new level.

Here's hoping that the developers continue to work with us to provide even more trackable metrics to the CSVs so that we can continue to produce statistically sound advanced stats.

TobyInHR · 01-08-2023, 02:31 PM

Update: after doing some cleanup and checking out the usage metrics for the webapp, it looks like we are already at 20 active hours from January 2 to January 8 lol. That is *incredible*! Unfortunately, it means the site may become unavailable within the next couple days.

Not to worry, I am going to immediately start working on a desktop, offline webapp to replace the browser version. This will introduce some new challenges, like pushing updates and ensuring compatibility with different versions of Windows, but it seems like it will be necessary.

Keep an eye out on this thread for updates. Thanks everyone!

TobyInHR · 02-16-2023, 03:28 PM

Hi folks! Back with a small update, and big request: I *think* I’m finished with the first desktop build for the CSV cleaner app! But I have no idea if it works outside of my machine environment. I need a few people to send the file to so that they can install the app and run it on their computers to make sure it works, and if it doesn’t, provide me with the error log that gets generated. If anyone is able to assist in testing, please let me know. Discord is the easiest way to get ahold of me, but I’ll try to check this post and my messages here as often as I can. Thanks everyone!

01-04-2023, 10:37 PM	#41
TobyInHR Minors (Rookie Ball) Join Date: Oct 2022 Posts: 30	Major updates to my advanced stat tracker! A new webapp is available to help clean your CSVs prior to loading them, which entirely eliminates the slow loading and occasional freezing of the current Sheet. This is thanks to my switch to using R as my data manipulation program, rather than sheets, which has also provided me with a collection of tools for much more effective modeling for xG, GAR, and WAR! Now, a script will do all the calculations, and export a few CSVs that can be put into Sheets, taking the labor off of Google and improving performance. Second, I have made the necessary changes to allow for expansion teams to be added! Instructions are in the video. Thanks to the FHM team for the most recent update, which added in a bunch of crazy useful stats! Please use this video to see how to use the new tools, as well as how to add expansion teams. For those interested, I also cover my modeling process later in the video. https://youtu.be/1TSe41OWWwI

01-07-2023, 12:21 AM	#43
Gazkyo Minors (Rookie Ball) Join Date: Oct 2022 Posts: 25	When I am cleaning the files there are only 3 upload buttons instead of 4 in the video. The missing one is cleaned team records. How do I fix this?

01-07-2023, 09:56 PM	#46
DragoReborn7 Bat Boy Join Date: Jul 2021 Posts: 10	Def working now. Just wanna say you're an absolute hero for this tool! Not many would put in this kind of work for such a nice project

01-08-2023, 06:58 AM	#48
Gazkyo Minors (Rookie Ball) Join Date: Oct 2022 Posts: 25	Yes it working now. Awesome!

01-08-2023, 02:27 PM	#49
TobyInHR Minors (Rookie Ball) Join Date: Oct 2022 Posts: 30	Thanks everyone! It means so much that you all are finding good use out of this tool. It's a labor of love, and like I have said before, it gives me so much fulfillment to add this level of "custom" input into one of my favorite games. Being able to share it with the community takes that to a new level. Here's hoping that the developers continue to work with us to provide even more trackable metrics to the CSVs so that we can continue to produce statistically sound advanced stats.

01-08-2023, 02:31 PM	#50
TobyInHR Minors (Rookie Ball) Join Date: Oct 2022 Posts: 30	Update: after doing some cleanup and checking out the usage metrics for the webapp, it looks like we are already at 20 active hours from January 2 to January 8 lol. That is incredible! Unfortunately, it means the site may become unavailable within the next couple days. Not to worry, I am going to immediately start working on a desktop, offline webapp to replace the browser version. This will introduce some new challenges, like pushing updates and ensuring compatibility with different versions of Windows, but it seems like it will be necessary. Keep an eye out on this thread for updates. Thanks everyone!

02-16-2023, 03:28 PM	#51
TobyInHR Minors (Rookie Ball) Join Date: Oct 2022 Posts: 30	Hi folks! Back with a small update, and big request: I think I’m finished with the first desktop build for the CSV cleaner app! But I have no idea if it works outside of my machine environment. I need a few people to send the file to so that they can install the app and run it on their computers to make sure it works, and if it doesn’t, provide me with the error log that gets generated. If anyone is able to assist in testing, please let me know. Discord is the easiest way to get ahold of me, but I’ll try to check this post and my messages here as often as I can. Thanks everyone!