When done with this, the macro copies the result to a different location (where it can be looked up by team name and used elsewhere). ColorIndex = 1 'otherwise make it black for the regular weeks and tiesĮach position in the cell is thus formatted differently depending on the outcome of the game that week for that team. ColorIndex = 2 'color it white for the unplayed weeks too ColorIndex = 2 'color it white to blank out the Bye weekĮlseIf result = "U" Then 'and for an unplayed week (future week) Subscript = True 'otherwise make it a subscript Superscript = True 'make it a superscript FontStyle = "Regular" ' can be set to "Bold" With ActiveCell.Characters(Start:=n, Length:=1).Font The macro has just selected the cell with the 17 |s in it when it does this, cycling n = 1 to 17:
I am not going to show the whole macro here because it makes a lot of references into the spreadsheet where I keep all the team scores, etc., but this is the core bit that does the formatting for a single team (the macro loops through all 32 teams, the part shown loops through the 17 weeks for a single team). Each can be individually set to Superscript or Subscript, and for the Bye week (the week off) the font can be colored white so as to leave a gap when the team doesn't play.Īs you might imagine, doing 32 teams this way soon becomes tedious and error-prone, but you can see the effect and it is possible to write a macro to do it automatically, which is what I did. Go to the formula bar at the top of Excel and in that bar select the | things one at a time. Now you can edit the formatting of each | separately. Each | represents a week in the team's schedule.
#DELTAGRAPH QUICKTIME ERROR FULL#
To do a full 17-week NFL schedule for a single team, for instance, you go to a cell in your spreadsheet and enter | (the vertical line above the \) 17 times. I have run this pool for years and find it a great venue to test out new things since it gets used by a broad audience of differing levels of sophistication.ĭoing sparklines manually in Excel is possible but tedious. Among my less-serious duties, I run the office football pool and decided to try implementing sparklines in the pool, which is run in Microsoft Excel 97. I was intrigued by the sparkline idea presented there and shown on the handouts, particulary in relation to baseball team records. I attended the 9/30/03 one-day course in Chicago and thought it was great.
0 kommentar(er)
