SportWise - Custom Calculated Columns

Click "CREATE NEW DATASPACE"

Name your DataSpace and select the NFL data sets for this tutorial. The concepts in this guide can also be used for NHL, NBA and MLB. As well as Yahoo Fantasy teams.

Click "PLAYER STATS"

Select the following fields from the Player Stats data set: Name Team REC Rush YDS Rec YDS Rush ATT Pass YDS COMP Click "NEXT", then "CREATE DATASPACE".

Custom Calculated Columns can be added by clicking "ADD NEW COLUMN"

Enter a name for your Custom Calculated Column

Click the Expression field to enter your formula

For this example we'll use the following formula, which is designed to calculate Fantasy Points for a Fantasy League. This formula can be modified to match your league's scoring system: (Player_Stats__regular_season_passing_touchdowns*4)+ (Player_Stats__regular_season_passing_interceptions*-1)+ (Player_Stats__regular_season_passing_yards/25)+ (Player_Stats__regular_season_rushing_touchdowns*6)+ (Player_Stats__regular_season_rushing_yards/10)+ (Player_Stats__regular_season_receptions*0.5)+ (Player_Stats__regular_season_receiving_yards/10)+ (Player_Stats__regular_season_receiving_touchdowns*6)+ ((Player_Stats__regular_season_punt_return_touchdowns+ Player_Stats__regular_season_kick_return_touchdowns)*6)+ ((Player_Stats__regular_season_two_point_conversion_pass_completions+ Player_Stats__regular_season_two_point_conversion_reception_succeeded+ Player_Stats__regular_season_two_point_conversion_rush_succeeded)*2)+ (Player_Stats__regular_season_fumbles_lost*-2)

Click "CALCULATE"

Your Custom Calculated Column can be sorted and filtered like any other column in SportWise.