Posted by abninety on 8/14/2019 6:52:00 PM (view original):

Posted by topdogggbm on 8/14/2019 6:39:00 PM (view original):

Posted by abninety on 8/14/2019 5:23:00 PM (view original):
Good god. I’m skeptical, but if what you said was even half true, it might be death to guys who just eyeball players, as I do

I was going to say something similar but i didn't wanna be a grouch.

Don't any of you just play basketball here? Cuz i do. I probably apply about 5% of the effort that the OP mentioned. I look at this like a real team. And what a basketball team needs to succeed. Not a math problem with equations and formulas and charts and graphs. I get players that fit what i need, without all the data.

One coach said the best thing I've ever heard, to explain my coaching style (and it was his style as well)....... "i just look at a team full of numbers until those numbers talk to me." Then i proceed to do what i need to do. And I'm successful doing so. I value the effort put in by some of you that add things like this. But wow it's a lot to look at!

I like that a lot, but I’m also a math guy. I think there’s beauty in both philosophies. As my great grandma used to say, “****, dawg. Whatever creams your Twinkie.”

On a scale of 0 to 10 there’s no way your grandma said that

Posted by shoe3 on 8/14/2019 7:25:00 PM (view original):
I think I spent more than 5 minutes on a game plan one single time, OK St’s Final 4 game a few years ago. Whatever floats your boat, but just skimming this was way too much work for me.

I’m surprised to hear this. I don’t think I’ve ever spent less than 5 minutes on an NT game, except for first rounders.

There’s no way these formulas are better than an eye test from someone like Gil or Ab. But better than mine: generally yes.

Even if you do not like the game-planning part of this, I urge you to check out the spreadsheet and go to the stats sheet at the back. It will help you understand what your players provide to another level.

Posted by cubcub113 on 8/14/2019 9:42:00 PM (view original):

Posted by abninety on 8/14/2019 6:52:00 PM (view original):

Posted by topdogggbm on 8/14/2019 6:39:00 PM (view original):

Posted by abninety on 8/14/2019 5:23:00 PM (view original):
Good god. I’m skeptical, but if what you said was even half true, it might be death to guys who just eyeball players, as I do

I was going to say something similar but i didn't wanna be a grouch.

Don't any of you just play basketball here? Cuz i do. I probably apply about 5% of the effort that the OP mentioned. I look at this like a real team. And what a basketball team needs to succeed. Not a math problem with equations and formulas and charts and graphs. I get players that fit what i need, without all the data.

One coach said the best thing I've ever heard, to explain my coaching style (and it was his style as well)....... "i just look at a team full of numbers until those numbers talk to me." Then i proceed to do what i need to do. And I'm successful doing so. I value the effort put in by some of you that add things like this. But wow it's a lot to look at!

I like that a lot, but I’m also a math guy. I think there’s beauty in both philosophies. As my great grandma used to say, “****, dawg. Whatever creams your Twinkie.”

On a scale of 0 to 10 there’s no way your grandma said that

Hahaha. I wanna meet grandma. I'd have a beer with her!

Nice tool, thanks. For recruiting use I am not sure what you mean here:

For this to work, you must manually enter '100' into all boxes from AZ3 to BF7 on the "Matchup" page of your recruiting sheet.

I just put 100 in every box in columns AZ23-BF7 to be safe and it worked fine.

One wrinkle I found is that you can't set Column H7 (team defense) to 2 or 3 (which correspond to zone) because if you do the D and OA ratings try to average the backup position as well and thus you get #N/A.

I found another issue with setting the defense to Zone in cell H7. Right now it is setting the average for every player on the team equal to whatever is in cell AE9 which I think defaults to PG2. I am not sure where it is supposed to point instead?

Posted by marl_karx on 8/14/2019 10:54:00 PM (view original):
I found another issue with setting the defense to Zone in cell H7. Right now it is setting the average for every player on the team equal to whatever is in cell AE9 which I think defaults to PG2. I am not sure where it is supposed to point instead?

Thank you very much for taking the time to look over it.

This is actually working as intended. In WIS, when a team plays zone, the defensive rating is averaged, and all players on the floor are averaged into one defensive unit. I store the formula to compute this team average in the PG2 cell, and then just copy that to the others if a zone is entered.

Posted by marl_karx on 8/14/2019 10:34:00 PM (view original):
Nice tool, thanks. For recruiting use I am not sure what you mean here:

For this to work, you must manually enter '100' into all boxes from AZ3 to BF7 on the "Matchup" page of your recruiting sheet.

I just put 100 in every box in columns AZ23-BF7 to be safe and it worked fine.

One wrinkle I found is that you can't set Column H7 (team defense) to 2 or 3 (which correspond to zone) because if you do the D and OA ratings try to average the backup position as well and thus you get #N/A.

I am going to release a second demo sheet used for recruiting. It is too hard to relay in words.

I don't believe it is working as intended.

I put the same player's stats as all 10 positions, PG1-C2. All 10 display correctly. His 2-3 defensive values from Column BR in order of position are 84,84,71,71,58. However, the D value in column AE when I set H7 to Zone shows the defense of all 10 players as 82. That is obviously not correct IMO.

Posted by cubcub113 on 8/14/2019 11:03:00 PM (view original):

Posted by marl_karx on 8/14/2019 10:34:00 PM (view original):
Nice tool, thanks. For recruiting use I am not sure what you mean here:

For this to work, you must manually enter '100' into all boxes from AZ3 to BF7 on the "Matchup" page of your recruiting sheet.

I just put 100 in every box in columns AZ23-BF7 to be safe and it worked fine.

One wrinkle I found is that you can't set Column H7 (team defense) to 2 or 3 (which correspond to zone) because if you do the D and OA ratings try to average the backup position as well and thus you get #N/A.

I am going to release a second demo sheet used for recruiting. It is too hard to relay in words.

I understand your instructions and have it working perfectly except for the fact that the D value in Column AE displays incorrectly if you set the defense to Zone.

I pared down the spreadsheet for recruiting. On the tab I named "Enter Player" you should put your player's name in Cell B2. Everything else will autopopulate. Put the rankings you want to analyze into E2-P2. You don't need to input FT.

Then check out the sheet named "Overall" to see the players Overall ratings at all 5 positions.

https://docs.google.com/spreadsheets/d/1jpi-cBNkI0LCipAXlc4tX-xF23DZ__Iy_D6ci3e-Xfg/edit?usp=sharing

I changed Zone to make it show the individual rating. For recruiting purposes the average didn't make sense anyway. Everything works now as far as I can tell. Will be interested in Cub's sheet tomorrow but mine is very straightforward and simple.

Wow, I plan to look at this when I have a few minutes mostly out of curiosity (and I might find something to help me finally win at D1!), but I have to say I'm also one of those on the far end of this much effort. I rarely spend more than 30 seconds game-planning during the regular season and not much more than that until elite 8 and past. Maybe 5-10 minutes at that point depending on if I feel comfortable with the 'eye test' and my normal process or if I am a big underdog I might spend the time to try and find some way to squeak out a win by making some changes. Anyway, thanks for sharing it cubcub should be interesting to see what is in there!

Posted by cubcub113 on 8/14/2019 10:58:00 PM (view original):

Posted by marl_karx on 8/14/2019 10:54:00 PM (view original):
I found another issue with setting the defense to Zone in cell H7. Right now it is setting the average for every player on the team equal to whatever is in cell AE9 which I think defaults to PG2. I am not sure where it is supposed to point instead?

Thank you very much for taking the time to look over it.

This is actually working as intended. In WIS, when a team plays zone, the defensive rating is averaged, and all players on the floor are averaged into one defensive unit. I store the formula to compute this team average in the PG2 cell, and then just copy that to the others if a zone is entered.

Unless the engine has changed, I dont think this is how zone works.

Ages ago, seble or someone said that zone involves averaging of different sets of players - in a 3-2 it averages the 3 players up top and separately averages the two players at the back. In 2-3 it averages the two guards and averages the PF and SF and does not average the 5,

Posted by mamxet on 8/15/2019 10:29:00 AM (view original):

Posted by cubcub113 on 8/14/2019 10:58:00 PM (view original):

Posted by marl_karx on 8/14/2019 10:54:00 PM (view original):
I found another issue with setting the defense to Zone in cell H7. Right now it is setting the average for every player on the team equal to whatever is in cell AE9 which I think defaults to PG2. I am not sure where it is supposed to point instead?

Thank you very much for taking the time to look over it.

This is actually working as intended. In WIS, when a team plays zone, the defensive rating is averaged, and all players on the floor are averaged into one defensive unit. I store the formula to compute this team average in the PG2 cell, and then just copy that to the others if a zone is entered.

Unless the engine has changed, I dont think this is how zone works.

Ages ago, seble or someone said that zone involves averaging of different sets of players - in a 3-2 it averages the 3 players up top and separately averages the two players at the back. In 2-3 it averages the two guards and averages the PF and SF and does not average the 5,

The0nly and I discussed this, and in the end, we determined that the formulas are the same for the 1-2 and 3-4 and 5 (2-3)/ 1-2-3 and 4-5 (3-2) but the unit is then totaled.

Posted by marl_karx on 8/14/2019 11:06:00 PM (view original):
I don't believe it is working as intended.

I put the same player's stats as all 10 positions, PG1-C2. All 10 display correctly. His 2-3 defensive values from Column BR in order of position are 84,84,71,71,58. However, the D value in column AE when I set H7 to Zone shows the defense of all 10 players as 82. That is obviously not correct IMO.

That is definitely not working as intended. I double-checked the formula on mine and it seems correct. Could you share the sheet to me that displays this?

I may have accidentally messed up a formula somehow. What I will do is just grab new copy of your original file and confirm that it works. If I still have a problem with it I will follow up with you.

Thanks for sharing this!