Animated Races of the 4 Big Football Leagues

Comments

4 responses to “Animated Races of the 4 Big Football Leagues”

1. 

   July 13, 2020

   Microsoft Excel Recalc Or Die

   Hi Robert,
   Question: did you added the “Miliseconds” parameter, because of the new version of Excel (Office 365)? I ask because sometimes when I click play of some VBA macros, the calculation happens so fast that you don´t get to see the animation happening :(.
   If you have any link or information about why this is happening on computers with Office 365 or fast CPUs, that will be great to read.

   Reply
2. 

   July 13, 2020

   Robert

   Carlos,
   the parameter “Delay in milliseconds” shall provide the option of defining how slow or fast the animation will be, i.e. the milliseconds the code waits between two matchdays. This applies only to the normal forward and backward buttons, though.
   If you press fast forward or fast backward (the ones with the two triangles) there is also a small delay hardcoded in VBA (50 milliseconds) in order to avoid the effect you are describing. On very fast machines, this may be not long enough. You can increase the constant C_MIN_DELAY = 50 in the code or you can simply use the normal forward and backward button and control the speed with the value in the cell defining the delay in milliseconds.
   It has nothing to do with the version of Excel. I guess you have a very fast machine, or it may have to do with your monitor.

   Reply
3. 

   July 15, 2020

   AJ

   Could you please do this for the previous 15-20 seasons? Would be greatly appreciated

   Reply
4. 

   July 15, 2020

   Robert

   AJ,
   I am glad to see that you apparently like the workbook and visualization. However, I am sorry to tell you that I do not have the time to create 60 to 80 workbooks or 4 workbooks covering 15 to 20 seasons for 4 football leagues.
   My intention was to demonstrate an alternative to the Bar Chart Race. Football was only publicly available data to demonstrate the technique.
   Expanding that to the other three big European Leagues for the current season wasn’t much of an effort, so I made this available in this post.
   That being said, you can do this by yourself. Here is a short tutorial what you have to change:
   1. Delete the entries in the data columns (blue column headers) on worksheet [Data] and insert the results of the required season
   2. Update the team names in section B26:B45 on worksheet [Calculation]
   3. Insert the team names and the logos on worksheet [Logos] to replace the relegated with the new teams
   4. Change the markers of the Race Chart on the [Chart] sheet for the teams which were relegated
   I have not done that, but I would assume, this would take less than an hour, including getting the data and finding the team logos.
   I hope for your understanding, but I rather invest my free time in posting something else than spending 80 hours to create the same visualization for all leagues for 20 seasons.
   The templates are available, so feel free to fill them with the seasons/data you want to visualize.

   Reply