Most up to date version:
http://www.mediafire.com/file/lchjat23c ... tatsDA.zipWhen processing as team stats, the assists formulations messes things up because it negates the players field goals (determines the percentage of assists a player made to every player on a team discounting his shots). When it processed the team version, it treats player values as team values. So it tells it to work out the assist percent from 0 field goals (either made or attempts, I can't remember which I use right now) + turnovers, creating a result that throws things a bit out of balance. I'll look into accomodating formulas like that.
I've also made explicit mention that the program doesn't support 'order of operation', so you should be generous with use of brackets. For example, it doesn't know how to process this very well: PLFTM + PLFGM * 2 + PL3PM * 3. Order of operation rules specify you use the multiplication and division first, multiplying PL3PM by 3 and PLFGM by 2. Then it processes from left to right. Without doing those first, the results can come out incorrectly especially as the expression becomes more complex. It does process parenthesis first, so instead you need to be generous with brackets which forces them to be done first PLFTM + (PLFGM * 2) + (PL3PM * 3). It is low priority to fix up as I imagine it might be high stress to figure out how to add the new stuff into the mess I done up (I had to come up with my own conception for converting strings into formulas). I didn't really notice it was a problem before adding GMSC recently.
The value of assists to rebounds from a team stats perspective. I had to hand type out these numbers, I think my next goal will be to create a custom copy to clipboard option. Especially as my eyes weren't in a state that could see very well (slime coming out of them after an eye trauma; may also be from lack of sleep, my eyes tend to want to go slimy when I don't sleep).
Since offensive rebounds often corresponds to negative team shooting performance, I've isolated defensive rebounds.
This is the first time that I've examined it seriously on a team level (using the "ALL" search after processing out a full season to generate game stats with ""). I thought there might be some difference in valuation to player numbers but it appears more or less the same. The numbers are from the 2016-17 regular season.
I've grouped each bracket into a similar number of games between them. I started at the first bracket where the numbers had enough games to stabilize.
AST 36 (37.6): 31-3 (91.18%) +21.8 FG:54.21% DFG:44.54%
...means it is for 36 or more team assists in a game for an average of 37.6 team assists, corresponding with 31 wins and 3 losses -- 2.8% of all games -- and (win%) and a 21.8 points average winning marin. Then it shows the FG and DFG% which is self-explanatory. Assists inflates the FG% while defensive rebounds corresponds with lower opponent FG%. The league wide average FG% for that season was 45.72%.
It is clear assists are more valuable than defensive rebounds are (and even more so total rebounds due to their negative correlation with team performance). The idea of having two great passers (eg. Chris Paul and James Harden) or numerous good passers on the same team may be vastly beneficial in this way.
AST 36 (37.6): 31-3 (91.18%) +21.8 FG:54.21% DFG:44.54%
DRB 46 (47.6): 31-6 (83.78%) +15.6 FG:44.95% DFG:37.77%
AST 35 (36.9): 43-4 (91.49%) +20.1 FG:54.03% DFG:45.17%
DRB 45 (46.8): 44-9 (83.02%) +13.8 FG:44.57% DFG:38.03%
AST 34 (36.2): 55-6 (90.16%) +19.5 FG:53.86% DFG:45.27%
DRB 44 (46.1): 56-13 (81.16%) +13.1 FG:44.70% DFG:38.39%
AST 33 (35.3): 75-9 (89.29%) +17.2 FG:53.26% DFG:45.03%
AST 32 (34.3): 103-17 (85.83%) +15.2 FG:52.32% DFG:45.31%
DRB 43 (45.1): 83-20 (80.58%) +11.8 FG:44.57% DFG:38.78%
AST 31 (33.4): 145-23 (86.31%) +14.0 FG:51.79% DFG:45.42%
DRB 42 (44.1): 120-29 (80.54%) +10.8 FG:44.74% DFG:38.97%
AST 30 (32.5): 186-44 (80.87%) +12.1 FG:51.35% DFG:45.71%
DRB 41 (43.3): 163-45 (78.37%) +9.8 FG:44.80% DFG:39.42%
AST 29 (31.4): 252-74 (77.30%) +10.2 FG:50.72% DFG:45.86%
DRB 40 (42.2): 235-69 (77.30%) +9.2 FG:45.19% DFG:40.11%
AST 28 (30.7): 315-103 (75.36%) +9.7 FG:50.15% DFG:45.63%
DRB 39 (41.4): 306-104 (74.63%) +8.9 FG:45.62% DFG:40.68%