Spreadsheet: 675389d1588265676-if-formula-help-database_copy
Sheet: PLAYERS ALL STATS TOP TEAM

TEAM | YEAR | LAST NAME | FIRST NAME | # | HT | POS | CLASS | G | ORTG | D-RTG | USG | OR | DR | BLK | STL | FLS | DUNK | MPG | RPG | APG | SPG | BPG | PPG | TOV | ORB | HC FGA | HC % shots ATR | HC # FGA ATR | HC # FGM ATR | HC FG% ATR | HC % asst'd ATR | HC FGA ASST'd ATR | HC % shots MRG | HC # FGA MRG | HC # FGM  MRG | HC FG% MRG | HC % asst'd MRG | HC FGA ASST'd MRG | HC % shots 3PT | HC # FGA 3PT | HC # FGM 3PT | HC FG% 3PT | HC % asst'd 3PT | HC FGA ASST'd 3PT | TRAN FGA | TRAN % shots ATR | TRAN # FGA ATR | TRAN # ASST'd ATR | TRAN FG% ATR | TRAN % shots MRG | TRAN # FGA MRG | TRAN # ASST'd MRG | TRAN FG% MRG | TRAN % shots 3PT | TRAN # FGA 3PT | TRAN # ASST'd 3PT | TRAN FG% 3PT | ALL FTA / FGA | ALL FT% | PB | PB %of ATR on PB | PB # FGA on PB ATR | PB %of MRG on PB | PB # FGA on PB MRG | ASST | ASST % total assists TRAN | ASST % total ATR | ASST % total assists MRG | ASST % total assists 3PT | HC ASST | HC ASST ATR | HC ASST MRG | HC ASST 3PT | TRAN ASST | TRAN ASST ATR | TRAN ASST MRG | TRAN ASST 3PT | ALL FGA | ALL % asst'd ATR | ALL % asst'd MRG | ALL % asst'd 3PT | HC ASST'd FGA Per/M ATR | HC ASST'd FGA Per/M A MRG | HC ASST'd FGA Per/M 3PT | TRAN ASST'd FGA Per/M ATR | TRAN ASST'd FGA Per/M MRG | TRAN ASST'd FGA Per/M 3PT | Created HC  FGA ATR | HC Created FGA MRG | HC Created FGA 3PT | HC Created FOUL POSS's | HC Created FOULS on SHOT | HC Created FOULS on SHOT ATR | HC Created FOULS on SHOT MRG | HC Created FOULS FLOOR | HC ASST ATR w/ Misses | HC ASST MRG w/ Misses | HC ASST 3PT w/ Misses | TEAM Non STL TO's | HC Created TO's | CREATED TOTAL SHARES | Created HC  FGA ATR | HC Created FGA MRG | HC Created FGA 3PT | HC Created FOULS on SHOT ATR | HC Created FOULS on SHOT MRG | HC Created FOULS on 3PT | HC Created FOULS FLOOR | HC ASST ATR w/ Misses | HC ASST MRG w/ Misses | HC ASST 3PT w/ Misses | HC Created OFF FOULS | HC Created OFF FOULS | HC TOTAL SHARES CHART | TRAN Created FGA ATR | TRAN Created FGA MRG | TRAN Created FGA 3PT | TRAN Created FOUL POSS's | TRAN Created FOULS on SHOT | TRAN Created FOULS on SHOT ATR | TRAN Created FOULS on SHOT MRG | TRAN Created FOULS FLOOR | TRAN ASST ATR w/ Misses | TRAN ASST MRG w/ Misses | TRAN ASST 3PT w/ Misses | TRAN  Created TO's | TRAN CREATED TOTAL SHARES | Created TRAN FGA ATR | TRAN  Created FGA MRG | TRAN  Created FGA 3PT | TRAN  Created FOULS on SHOT ATR | TRAN  Created FOULS on SHOT MRG | TRAN  Created FOULS on SHOT 3PT | TRAN  Created FOULS FLOOR | TRAN ASST ATR w/ Misses | TRAN ASST MRG w/ Misses | TRAN ASST 3PT w/ Misses | TRAN  OFF FOULS | TRAN  Created TO's | TRAN TOTAL SHARES CHART | PB RTG ATR | PB RTG MRG | DUNK RATING | ORTG | OFF RTG OFF RTG PTS | USG | OFF RTG USAGE PTS | MPG | OFF RTG MPG PTS | TEAM TEMPO | OFF RTG TEMPO PTS | OFF RTG DEDUCT | OFF RTG TOTAL PTS | OFF RTG OFFICIAL | D-RTG | DEF RTG DEF RTG PTS | DEF RTG MPG PTS | TEAM TEMPO PTS | DEF RTG DEDUCT | DEF RTG TOTAL PTS | DEF RTG OFFICIAL
MICHIGAN | 2020 | Livers | [NAME] | 2 | 2020-06-07 00:00:00 | F | Jr | 21 | 117.2 | 93.5 | 18 | 3 | 11.3 | 2.1 | 0.8 | 2.9 | 8 | 31.5 | 4 | 1.1 | 0.4 | 0.7 | 12.9 | 18 | 17 | 156 | 0.218 |  |  | 0.676 | 0.609 |  | 0.321 |  |  | 0.34 | 0.235 |  | 0.462 |  |  | 0.347 | 0.8 |  | 52 | 0.327 |  |  | 0.706 | 0.096 |  |  | 0 | 0.577 |  |  | 0.533 | 0.221 | 0.957 | 4 | 0.039 |  | 0.036 |  | 23 | 0.391 | 0.391 | 0.043 | 0.565 |  |  |  |  |  |  |  |  | 208 | 0.629 | 0.235 | 0.878 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 117.2 | 15 | 18 | 10 | 31.5 | 16 |  | 11 |  |  |  | 93.5 | 14 |  | 10
MICHIGAN | 2020 | Simpson | Zavier | 3 | 2000-06-01 00:00:00 | G | Sr | 30 | 106.3 | 92.1 | 25.9 | 2.4 | 12.2 | 0.4 | 1.7 | 3.1 | 1 | 33.7 | 4.5 | 7.9 | 1 | 0.1 | 12.9 | 96 | 21 | 215 | 0.423 |  |  | 0.648 | 0.051 |  | 0.307 |  |  | 0.303 | 0.05 |  | 0.27 |  |  | 0.345 | 0.6 |  | 102 | 0.578 |  |  | 0.61 | 0.147 |  |  | 0.333 | 0.275 |  |  | 0.393 | 0.297 | 0.574 | 2 | 0.013 |  | 0 |  | 230 | 0.313 | 0.396 | 0.109 | 0.496 |  |  |  |  |  |  |  |  | 317 | 0.095 | 0.04 | 0.581 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106.3 | 12 | 25.9 | 16 | 33.7 | 17 |  | 11 |  |  |  | 92.1 | 15 |  | 10