London Coronavirus Heatmap in Excel
Check how many confirmed cases in London borough in Excel tracker?
Whether we like it or not, for some time we have been witnessing spreading of the virus all over the world. Being a Londoner, I have decided to develop data visualisation regarding virus cases observed in one of the largest agglomerations in the world. To do so, I used an MS Excel spread sheet. Heat map presentation is automatically updated on the day-to-day basis and it presents confirmed virus cases in all London boroughs. What is more, using one of my spreadsheets you can follow development of infection over the course of time in 10 most exposed boroughs. Source data acquired is published online by Public-Health England.
Should you wish the attached file to download data from the Internet automatically, you must accept Connect Access Web and Enabled Content.
Then, each time you open the file, the spreadsheet will communicate with www.eexcel.co.uk/coronavirus to updated the current data. Please bear in mind that the connection requires some time and the following message may be displayed in the bottom left corner of the spread sheet status bar: if you see this message, please do not use the spread sheet.