![]() ![]() Now, we can clean up the data set by Deleting the empty columns, and Row 1. Simply, add detail to the column headers, such as “Rushing_Yds” and “Receiving_Yds” as follows: I like to categorize each data column, in order to avoid confusion between rushing yards and receiving yards, etc. This step is key to creating PivotTables by Week and Season in later steps. Enter and auto-fill the Week and Season for each player. There’s a nice blank column that’s ready for you in column D. ![]() Next, change the Games column header from “G” to “Week”, and add a column for the “Season” (e.g. This is my least favorite part of the process, too. I have already done this tedious task for you. Yikes! Or, just get a FREE copy of my NFL stats. You can now repeat this step another 51 times (3 seasons x 17 weeks = 51 times), for each position. Your imported data should look like this on your Excel spreadsheet. The yellow arrow changes into a green check mark. Then, select only the statistics table by clicking its yellow arrow. ![]() Import the raw data directly from the webpage by clicking the Data tab, then the From Web command in the Get External Data group, as follows:Ĭopy the URL from your browser (above), and Paste it into the Address field (below), and click Go. Always set the Players filter to “All Players”, if given the option. It has all of the basic elements needed to begin building our Excel spreadsheet (Yards, TD’s, Fumbles, etc.).įirst, filter the online data by Position, View by, Year and Timeframe. Since I’m in Yahoo! leagues, I found the Yahoo! statistics page. ![]() Use less than three seasons of data, and we might as well pick players based on last season’s performance. I only gather data of the last three seasons. With the Excel spreadsheet, we can consume mass quantities of fantasy football stats, and properly digest this data into useful information for the big draft. The Coneheads from Saturday Night Live (1977) would “consume mass quantities,” by gulping entire six-packs and bags of chips. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |