Stat lists for Wikipedia
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEF
1
INSTRUCTIONS FOR FOOTBALL STATISTICAL LEADERS
2
3
1Check https://en.wikipedia.org/wiki/Category:Lists_of_college_football_statistical_leaders_by_team to see if the page already exists.
4
2If it does not, create the article by typing the name in the proper format, "[Common School Name] [Nickname] football statistical leaders". If there is inconsistency in what the "common school name" is, use what's established on Wikpiedia already. For example, "UCF Knights football statistical leaders" instead of calling them Central Florida.
5
3Save this document to your computer, presumably to Excel (File -> Download As).
6
4On |Football Lists| cell E1, enter the common name of the school.
7
5On |Football Lists| cell F1, enter the name of the school's athletic teams.
8
6On |Football Lists| cell I1, enter the name of the school's conference.
9
7On |Football Lists| cell N1, enter the Wikipedia name of the school's image, which is found on the school's main Wikipedia athletics article.
10
8On |Football Lists| cell P1, keep the word "the" if the name of the university is preceeded by the word. IE, the University of Illinois gets a "the," but Michigan State University does not.
11
9On |Football Lists| cell Q1, enter the name of the university.
12
10On |Football Lists| cell E2, enter the URL of the school's media guide, which will presumably be your primary source for the lists. If you use something other than a media guide, that's OK, as long as it's a valid source, but you will have to manually change some text when creating the article.
13
11On |Football Lists| cell E3, enter the main website (probably the school's athletic website) where you found the media guide, or whatever source you used.
14
12On |Football Lists| cell T2, enter in the first year the school played football.
15
13On |Football Lists| cell T3, enter in the first year of the school's "modern era," the earliest year included in the media guide's lists. The school may not have one if they include records going all the way back to the beginning, or they may not have a set year, but most of the official lists don't go all the way back to the 1800s. If the school doesn't have a formal start date, you may have to word the text a little differently, but many schools' media guides do explicitly state the beginning of the "modern era."
16
14
In cells V2 and V3, enter the 6-character hex code of the school's official colors, found on the school's main athletics Wikipedia article.
17
15
Do not delete rows or columns, or any information in columns A:C or AA:AC, so that the formulas on "Football Code" will calculate properly.
18
16|Football Lists| columns D:V - enter in the top 10 lists from all categories.
19
17If the source you're using only goes through the 2013, you'll have to add in any players who entered the list in the 2014 season. Probably won't be but a few entries, and you can easily find them.
20
18If there is a tie for 10th, list both/all players. If the media guide doesn't give a full top 10 (or if there's something like a 20-way tie for 10th and you don't want to list them all), feel free to cut off the list early.
21
19For the career leader stats, list all years the player played in columns G:K. There are formulas to make it easier, but remove/edit them as necessary, for players that didn't play 4 seasons, or played non-consecutively. Don't include years that the player redshirted, although do include a year if the player played at all.
22
20Some on Wikipedia were concerned that the media guide isn't a sufficient source for the records, so column X gives you the opportunity to add in links to ESPN articles as a citation, at least for games since 2003. In Column X, enter in a reference name (something simple like "12AL" if it's the 2012 game against Alabama), and column W's formulas will account for it. Do not edit column W! For games before 2003, worry about them, unless it's a bizarre, borderline unbelievable stat (like a WR with 7 receiving TDs in a game!) and you feel the need to. In fact, you could just forego this altogether, but you probably should include a link if it's a single-game entry from 2014 that doesn't appear in the media guide.
23
21Rows 179:188 are the field goal percentage leaders. The blue numbers in columns F and O are formula-driven percentages. Enter in the field goals made and attempted in columns S:V.
24
22Columns AD:BD show the total offense (passing + rushing) and total touchdowns responsible for leaders. These columns are the same as the ones to the left, but couldn't be included among them because there are more columns to list the total, pashing, and rushing numbers.
25
23Columns BI:BK can probably be left alone. They give the link to the article each particular season for a team based on the entries in cells E1:F1. If the team has changed nicknames since then, you could manually update these, or just leave them -- Wikipedia will probably redirect. Also, this may lead to a bunch of red links, but leave them -- eventually Wikipedia will have an article for every team for every year.
26
24Columns BM:BP give the proper link to each palyer's Wikipedia page, if it exists. Place a "Y" into column BO if the player has a Wikipedia page (or if you feel they should, or soon will). Place an "N" if the player does not. If the player does have an article, but it is not just name player's name, such as Walt Harris (cornerback), enter in the article title in column BO and the formulas will correct.
27
25Columns BR:BY allow you to enter in a citation for single-game entries. Presumably an ESPN.com article about the game, but it doesn't have to be. Enter in the URL into column BT, the article headline into column BU, and the date into column BV, and the formulas will take care of the rest. If it's not from ESPN.com, you'll have to change column BW.
28
26That's everything on }Football Lists|. Now copy and paste all of the grey cells from |Football Code| into Notepad, remove the tabs, and you have your completed Wikipedia code to paste into the article.
29
27You will have to manually enter in rows if there's a tie for 10th, by typing it straight into the code. If you don't have 10 entries in a column, you'll have to subtract from the code. Depending on the colors, the boxes at the top of the lists may not look good, and you could consider changing the color to white or something. Up to you.
30
28Go through the introduction and edit as necessary. There are a couple places marked "Something school specific." Also, if anything doesn't match (such as there not being a real "modern era" or something), you'll have to make it match reality.
31
29Once you're happy with the article, submit.
32
30If you want to keep the articles updated week-by-week during the season, be my guest. I currently do that for Mississippi State. But I imagine most of them will just be updated every January, which is fine.
33
34
35
36
37
38
39
40
41
42
43
Loading...
Main menu