Fantasy Football - Footballguys Forums
This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
SuperJohn96's Annual NFL Schedule Grid - 2008 Edition (1 Viewer)
- Thread starter SuperJohn96
- Start date
Biabreakable
Footballguy
For QBBC pairings.
Someone creates an NCAA Football helmet grid every year that I get my hands on. I like the look, so I decided to pimp out SuperJohns96's annual grid. Please check for accuracy.
NCAA Football Helmet Schedule
[http://www.fileshack.us/get_file.php?id=71996&file=NFL_Schedule_2008.xls]NFL Helmet Schedule
(This is SuperJohn96's original excel file, but a new "Helmet" tab added near the end.)
* Edited to include IndyHavoc's edits. There were a few errors, and he made home games more distinguishable.
NCAA Football Helmet Schedule
[http://www.fileshack.us/get_file.php?id=71996&file=NFL_Schedule_2008.xls]NFL Helmet Schedule
(This is SuperJohn96's original excel file, but a new "Helmet" tab added near the end.)
* Edited to include IndyHavoc's edits. There were a few errors, and he made home games more distinguishable.
Last edited by a moderator:
Yeah, wasn't sure how to do this. I have access to a plotter, so I am going to put all of the helmet schedules on a 36x48 to hang on my wall. At that size I think the bold should be sufficient. It's kind of hard to select an individual cell once you have the image in it, so I did it before adding the images.
Got it! Just turn on a 1/4" border on the pictures that are "Home" games. So, the helmets get a thin black border to home games, no border for away games.
Looks awesome man! Great work. And to SuperJohn as well! Think I'll do the same for a wall poster. Very chic.
Looks awesome man! Great work. And to SuperJohn as well! Think I'll do the same for a wall poster. Very chic.
Last edited by a moderator:
One change I made was to freeze the top rows and left columns. This helps me keep track of what dates/weeks and what teams I am looking at when I scroll down or right. If you are printing it out this won't matter, but if you are viewing it on the monitor it helps alot.
Here's what you do:
Click in the upper left (@SF) cell.
Click on Window on the top tool bar and click Freeze Panes.
You will have to repeat this for all of the worksheets (tabs).
For the helmet grid you need to make sure you click in the cell and not on the helmet picture itself.
HTH
Here's what you do:
Click in the upper left (@SF) cell.
Click on Window on the top tool bar and click Freeze Panes.
You will have to repeat this for all of the worksheets (tabs).
For the helmet grid you need to make sure you click in the cell and not on the helmet picture itself.
HTH
Nemesis
Footballguy
You can use Conditional Formating to do exactly what you want and you'll probably be able to see it better than the "outline method" described.QUEZILLA said:
Here's what I did:
1-on the ACC Tab: click on cell B3 (this the Boston College @Kent St matchup)
2-Conditional Format this cell to recognize Away Games (ie, any away game that starts with an "@").
Goto: Format, Conditional Format.
Change the Condition 1 drop down to say "Formula Is"......."=AND(LEFT(B3,1)="@")"
FYI: This takes cell B3 and cuts off the text so that only the 1st character is evaluated.
FYI2: The only formulas that you can use for Conditional formats is one that ultimately returns a TRUE or FALSE answer.
Pick what color you want (I picked Gray)
3-Copy this format to the other cells.
Copy cell B3. (I'm a Ctrl-C type of guy.)
Hi-light the paste area with your mouse.
Goto: Edit, PASTE SPECIAL
Select "Format" and hit OK.
Be careful as you don't want to paste this format on everything and override some of the cells with the Conference Titles, etc.... in them as they are merged cells.
Worked for me! Good Luck.
Last edited by a moderator:
Thank you.
What every bachlor pad needs.
SuperJohn96
RPS World Champion
:bump: for dapunisher
JoeSteeler
Footballguy
bump for the start of the season 
Mystery Achiever
Footballguy
For everyone who has appreciated John's grid, every year you can offer condolences on his dad here:
http://forums.footballguys.com/forum/index...howtopic=389958
(It is a long thread; if you haven't been following, you can go to post 263)
http://forums.footballguys.com/forum/index...howtopic=389958
(It is a long thread; if you haven't been following, you can go to post 263)
Last edited by a moderator:
SuperJohn96
RPS World Champion
Last edited by a moderator:
Chase Stuart
Footballguy
SuperJohn,
Any thoughts on why this is down?
Any thoughts on why this is down?
SuperJohn96
RPS World Champion
Looks like that whole file sharing site is down.I'm updating the links in all my posts now.
Similar threads
