Reply to thread

Message: [QUOTE="maccca3232, post: 3079113, member: 7923"] I have made available a [URL='https://docs.google.com/spreadsheets/d/15n1_ZQQvO3GJWcuoiXxlqg4MTb4UuJg0njSRz4K1n_Y/edit?usp=sharing']Google Spreadsheet[/URL]. [COLOR=rgb(184, 49, 47)]You should "Make a copy" of the document before updating anything, as this file will be available to everyone.[/COLOR] It contains box scores for 30 of the 34 players nominated for either Naismith or Wooden Mid Season (or later) awards. The 4 players excluded were: [LIST] [*]Megan Huff (Utah) and Tynice Martin (West Virginia) nominated Mid Season Naismith [*]Kenisha Bell (Minnesota) and Rennia Davis (Tennessee) nominated Mid Season Wooden [/LIST] The spreadsheet includes standard averages, some advanced stats (eFG%, TS%, Efficiency, Usage Rate) and a stat I have added, primarily to filter players by, which I have called 'Impact'. Impact is the player's Efficiency x their Usage Rate divided by 300. The 300 used is expected Efficiency of 15 x average Usage Rate of 20. The Impact value is a [I]rough[/I] number to show the 'impact' of that player on [B]their[/B] team. The first 4 tabs contains rankings data (RPI, Massey, AP and USA Today). The next 4 tabs contains stats data (Box Scores, Overall, Qualified and Non Qualified). You can filter the data by: [LIST] [*]Game Type [*]Game Rating [*]Game Criteria [/LIST] [COLOR=rgb(209, 72, 65)]Important: You can change data ONLY on the 'QUALIFIED' tab and ONLY in the top 4 rows (Editable cells are shown in yellow). You will not be able to change any other data.[/COLOR] [U]Game Type[/U] By selecting your preference (Yes or No) of which games to include (in cells C1, C2, C3 and C4). Default selection: Yes for all. Note: There is currently no NCAA Tourney data available. [LIST=1] [*]Non Conference [*]Conference [*]Conference Tourney [*]NCAA Tourney [/LIST] [U]Game Rating[/U] By selecting your preference of which rating to use (in cell D4). Default selection: RPI [LIST=1] [*]RPI [*]Massey [*]AP Poll [*]USA Today Poll [/LIST] [U]Game Criteria[/U] By selecting your preference for which games to be included in the 'QUALIFIED' tab (in cell D2). Default selection: Revised [LIST=1] [*]Standard - Home = 50, Neutral = 50 and Away = 50 (i.e. Tier 1) [*]Revised - Home = 30, Neutral = 50 and Away = 75 (i.e. what I like to use as away games are harder) [*]Personal - Home = 25, Neutral = 25 and Away = 25 (i.e. Top 25 but you can change to whatever you like). [/LIST] The 'Game Criteria' is the most important as it determines the number of games which will be included. The more data (i.e. games) that are included the more reliable the results that are returned will be. Example: If you want to exclude Home games. You would change to the Criteria to 'Personal' and then Change Home to '0'. Enjoy! [/QUOTE]

Verification: First name of men's bb coach

Forum statistics

Threads: 164,410

Messages: 4,394,754

Members: 10,208

Latest member: jskwrite