{"id":1081,"date":"2016-12-07T14:52:10","date_gmt":"2016-12-07T14:52:10","guid":{"rendered":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/?p=1081"},"modified":"2016-12-07T14:52:10","modified_gmt":"2016-12-07T14:52:10","slug":"football-travel-the-cost-of-tv-fixture-changes","status":"publish","type":"post","link":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/2016\/12\/07\/football-travel-the-cost-of-tv-fixture-changes\/","title":{"rendered":"Football Travel &#8211; the cost of TV fixture changes"},"content":{"rendered":"<p class=\"western\">In recent years, television broadcasters have pumped more and more money into the football industry, resulting in Premier League clubs in particular receiving both more TV money and more TV coverage. This extra coverage, however, has come at a cost to the fan on the terrace. There are more and more instances of last-minute fixture alterations being made to accommodate televised games. These last-minute changes often result in fans having to rebook travel plans, getting home even later, or in some cases staying overnight in a hotel. I personally remember having to rebook trains twice, and book and subsequently cancel accommodation (losing my deposit) as an Aston Villa vs Norwich City game had its kick-off time changed twice because of TV.<\/p>\n<p class=\"western\"><a href=\"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/liverpool-fan-supporter-protest-ticket-prices_3412122.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1091\" src=\"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/liverpool-fan-supporter-protest-ticket-prices_3412122.jpg\" alt=\"liverpool-fan-supporter-protest-ticket-prices_3412122\" width=\"768\" height=\"432\" srcset=\"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/liverpool-fan-supporter-protest-ticket-prices_3412122.jpg 768w, https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/liverpool-fan-supporter-protest-ticket-prices_3412122-300x169.jpg 300w, https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/liverpool-fan-supporter-protest-ticket-prices_3412122-500x281.jpg 500w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px\" \/><\/a><\/p>\n<p class=\"western\">In previous work we have investigated the travel times of football fans and how they could be affected by fixture changes. This looked at the additional time and difficult faced by travelling supporters but did not consider the cost of these changes. Therefore in this piece of work we wanted to determine which fixture changes would result in the biggest cost increase for a fan travelling to the game by public transport. For this we used an API from British Rail Fares Queries (<span style=\"color: #000080\"><span lang=\"zxx\"><u><a class=\"western\" href=\"http:\/\/www.brfares.com\/api\/\">http:\/\/www.brfares.com\/api\/<\/a><\/u><\/span><\/span> ) which allowed us to determine the both the cheapest possible advance tickets and the cheapest possible ticket that a fan could buy on the day. As in the previous work, the Google Travel API (<span style=\"color: #000080\"><span lang=\"zxx\"><u><a class=\"western\" href=\"https:\/\/developers.google.com\/maps\/documentation\/distance-matrix\/\">https:\/\/developers.google.com\/maps\/documentation\/distance-matrix\/<\/a><\/u><\/span><\/span>) was used to determine the amount of time travelling and whether a fan would have to stay overnight either the night before or after a match.<\/p>\n<p class=\"western\">As we didn\u2019t want to just consider the cost of new rail tickets but the cost of having to potentially spend more leisure time travelling to and from the game due to the fixture change, we wanted to apply a \u201ccost\u201d to the fan for each extra minute spent travelling. The Department for Transport determined a value of \u00a38 per hour for a non-work related journey using their \u2018Value of Time method (<span style=\"color: #000080\"><span lang=\"zxx\"><u><a class=\"western\" href=\"https:\/\/www.gov.uk\/government\/uploads\/system\/uploads\/attachment_data\/file\/313222\/webtag-tag-unit-a1-3-user-and-provider-impacts.pdf\">https:\/\/www.gov.uk\/government\/uploads\/system\/uploads\/attachment_data\/file\/313222\/webtag-tag-unit-a1-3-user-and-provider-impacts.pdf<\/a><\/u><\/span><\/span>).We consequently applied this cost to the time a fan would spend travelling to and from the game to give an approximate monetary value.<\/p>\n<p class=\"western\">\n<figure id=\"attachment_1092\" aria-describedby=\"caption-attachment-1092\" style=\"width: 584px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/harlepoolsmurfs.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1092 size-large\" src=\"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/harlepoolsmurfs-1024x576.jpg\" alt=\"harlepoolsmurfs\" width=\"584\" height=\"329\" srcset=\"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/harlepoolsmurfs-1024x576.jpg 1024w, https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/harlepoolsmurfs-300x169.jpg 300w, https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/harlepoolsmurfs-768x432.jpg 768w, https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/harlepoolsmurfs-500x281.jpg 500w, https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/files\/2016\/12\/harlepoolsmurfs.jpg 1280w\" sizes=\"auto, (max-width: 584px) 85vw, 584px\" \/><\/a><figcaption id=\"caption-attachment-1092\" class=\"wp-caption-text\">Hartlepool fans on their yearly fancy dress trip<\/figcaption><\/figure>\n<p class=\"western\">Finally, if the fixture meant a fan would have to stay overnight we added an extra \u00a350 to the journey cost to represent an approximate value of a night in a cheap hotel. Whilst all of these costs make assumptions (that the supporter is diligent enough to buy the cheapest available Advance ticket to travel to the match when they are initially released, that the rearranged game means the purchase of an Off-peak ticket rather than another Advance ticket, that they will not be able to stay with friends) they are a first attempt at capturing the extra personal cost of these TV fixture moves.<\/p>\n<p class=\"western\">The results of this piece of analysis are available here:<br \/>\n<strong><a style=\"font-size: 24pt\" href=\"http:\/\/ceg-sense2.ncl.ac.uk\/football_cost\/\">Full Results<\/a><\/strong><\/p>\n<p>With the top 10 biggest cost increases shown below.<\/p>\n<p class=\"western\">It\u2019s a good job that no-one chose to televise Bournemouth vs Sunderland\u2026<\/p>\n<p>&nbsp;<\/p>\n<table class=\"dynatable-loaded\">\n<thead>\n<tr>\n<th>Home Team<\/th>\n<th>Away Team<\/th>\n<th>Kickoff Time<\/th>\n<th>Total Cost<\/th>\n<th>Hotel needed<\/th>\n<th>New Travel Time (hours)<\/th>\n<th>3 o&#8217;clock kickoff Travel Time (hours)<\/th>\n<th>Rail Tickets Cost<\/th>\n<th>Extra cost of fixture move<\/th>\n<th>3 o&#8217;clock cost<\/th>\n<th>Percentage Increase<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Bournemouth<\/td>\n<td>Sunderland<\/td>\n<td>17:30:00<\/td>\n<td>\u00a3490.83<\/td>\n<td>1<\/td>\n<td>20.89 Hours<\/td>\n<td>13.64 Hours<\/td>\n<td>\u00a3273.70<\/td>\n<td>\u00a3277.72<\/td>\n<td>\u00a3213.11<\/td>\n<td>230.32%<\/td>\n<\/tr>\n<tr>\n<td>Sunderland<\/td>\n<td>Bournemouth<\/td>\n<td>16:00:00<\/td>\n<td>\u00a3474.55<\/td>\n<td>1<\/td>\n<td>18.86 Hours<\/td>\n<td>13.71 Hours<\/td>\n<td>\u00a3273.70<\/td>\n<td>\u00a3260.90<\/td>\n<td>\u00a3213.65<\/td>\n<td>222.12%<\/td>\n<\/tr>\n<tr>\n<td>Middlesbrough<\/td>\n<td>Bournemouth<\/td>\n<td>16:00:00<\/td>\n<td>\u00a3464.10<\/td>\n<td>1<\/td>\n<td>18.46 Hours<\/td>\n<td>13.10 Hours<\/td>\n<td>\u00a3266.40<\/td>\n<td>\u00a3259.14<\/td>\n<td>\u00a3204.96<\/td>\n<td>226.43%<\/td>\n<\/tr>\n<tr>\n<td>Middlesbrough<\/td>\n<td>Bournemouth<\/td>\n<td>17:30:00<\/td>\n<td>\u00a3462.64<\/td>\n<td>1<\/td>\n<td>18.28 Hours<\/td>\n<td>13.10 Hours<\/td>\n<td>\u00a3266.40<\/td>\n<td>\u00a3257.68<\/td>\n<td>\u00a3204.96<\/td>\n<td>225.72%<\/td>\n<\/tr>\n<tr>\n<td>Hull City<\/td>\n<td>Bournemouth<\/td>\n<td>13:00:00<\/td>\n<td>\u00a3444.00<\/td>\n<td>1<\/td>\n<td>19.94 Hours<\/td>\n<td>12.39 Hours<\/td>\n<td>\u00a3234.50<\/td>\n<td>\u00a3257.30<\/td>\n<td>\u00a3186.70<\/td>\n<td>237.81%<\/td>\n<\/tr>\n<tr>\n<td>Sunderland<\/td>\n<td>Bournemouth<\/td>\n<td>17:30:00<\/td>\n<td>\u00a3470.70<\/td>\n<td>1<\/td>\n<td>18.37 Hours<\/td>\n<td>13.71 Hours<\/td>\n<td>\u00a3273.70<\/td>\n<td>\u00a3257.05<\/td>\n<td>\u00a3213.65<\/td>\n<td>220.31%<\/td>\n<\/tr>\n<tr>\n<td>Bournemouth<\/td>\n<td>Sunderland<\/td>\n<td>16:00:00<\/td>\n<td>\u00a3463.90<\/td>\n<td>1<\/td>\n<td>17.53 Hours<\/td>\n<td>13.64 Hours<\/td>\n<td>\u00a3273.70<\/td>\n<td>\u00a3250.80<\/td>\n<td>\u00a3213.11<\/td>\n<td>217.68%<\/td>\n<\/tr>\n<tr>\n<td>Southampton<\/td>\n<td>Sunderland<\/td>\n<td>17:30:00<\/td>\n<td>\u00a3438.28<\/td>\n<td>1<\/td>\n<td>16.81 Hours<\/td>\n<td>12.78 Hours<\/td>\n<td>\u00a3253.80<\/td>\n<td>\u00a3240.07<\/td>\n<td>\u00a3198.22<\/td>\n<td>221.11%<\/td>\n<\/tr>\n<tr>\n<td>Sunderland<\/td>\n<td>Southampton<\/td>\n<td>17:30:00<\/td>\n<td>\u00a3444.95<\/td>\n<td>1<\/td>\n<td>17.64 Hours<\/td>\n<td>13.70 Hours<\/td>\n<td>\u00a3253.80<\/td>\n<td>\u00a3239.37<\/td>\n<td>\u00a3205.58<\/td>\n<td>216.44%<\/td>\n<\/tr>\n<tr>\n<td>Southampton<\/td>\n<td>Sunderland<\/td>\n<td>16:00:00<\/td>\n<td>\u00a3437.08<\/td>\n<td>1<\/td>\n<td>16.66 Hours<\/td>\n<td>12.78 Hours<\/td>\n<td>\u00a3253.80<\/td>\n<td>\u00a3238.87<\/td>\n<td>\u00a3198.22<\/td>\n<td>220.51%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>In recent years, television broadcasters have pumped more and more money into the football industry, resulting in Premier League clubs in particular receiving both more TV money and more TV coverage. This extra coverage, however, has come at a cost to the fan on the terrace. There are more and more instances of last-minute fixture &hellip; <a href=\"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/2016\/12\/07\/football-travel-the-cost-of-tv-fixture-changes\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Football Travel &#8211; the cost of TV fixture changes&#8221;<\/span><\/a><\/p>\n","protected":false},"author":4972,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,7],"tags":[],"class_list":["post-1081","post","type-post","status-publish","format-standard","hentry","category-football-analysis","category-research"],"_links":{"self":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts\/1081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/users\/4972"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/comments?post=1081"}],"version-history":[{"count":9,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts\/1081\/revisions"}],"predecessor-version":[{"id":1093,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts\/1081\/revisions\/1093"}],"wp:attachment":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/media?parent=1081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/categories?post=1081"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/tags?post=1081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}