![]() ![]() OK, I know, Excel is not the ideal package for graphics, but for something like this pool I'm not buying Illustrator! This is cheap and stinky but it does work and if I cared about baseball the same concept would work just with n =1 to 162 and a wider cell. I don't know that shutouts mean as much in football, but overtime wins and losses might be worthwhile noting and I may try this later. Also, when printed in color, Tufte's baseball sparklines would be red for a shutout. I could do Home games Bold but haven't yet. Tufte's baseball results distinguished between home and away games using a horizontal center line I haven't figure out how to do this in a single cell. I am so tickled with this working out that I haven't taken it further, yet. The | marks formatted white, for the Bye week and the Unplayed (future) weeks mean they don't show up but, in the case of Bye Weeks, block off a week-sized hole to show the off week for the team. 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. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |