About this Dataroom
Best City Contest Dataset.
Data History and Data Preview contains table with all cities in the Economist Intelligence Unit's dataset ranked using the authors weighed scorecard model. Each city is given an overall rank and score, as well as scores in each of seven main livability categories.
Attachments contains the executive summary which is a detailed description of the model and results. It also contains an Excel 2010 version of the actual model used (unfortunately not usable in Excel 2003 or earlier).
In addition, visualizations contain map with all cities in the dataset, color coded by their score. Web versions of these visualizations where you can hover your mouse pointer over each city and get the name and rank are available here:
http://www.ministryofclever.com/Livability/WorldMap.html http://www.ministryofclever.com/Livability/AsiaMap.html http://www.ministryofclever.com/Livability/EuropeMap.html http://www.ministryofclever.com/Livability/NorthAmericaMap.html http://www.ministryofclever.com/Livability/MiddleEastMap.html
Thanks! :) At first, I had some trouble trying to think of what weather is "best" - but the scale itself really says it all: it's not so much about rewarding good weather as it is penalizing the bad.. ;)
I took a look at your stuff too, and I quite like the idea of personalizing the final output - especially when my model could easily have been extended to support that too... But ah well, you live and you learn! Next time...
I wanted to add an other panel so the 'user' can set the min / max temp and sunshine is looking for, but (1) no time to compute this on my end and (2) the interface will look too messy and complex with this on the top.
So using my app, what's your best city? Still the same?
Hi arcald, and sorry for the slow response.
You make a very good point, sunnier isn't always better, just most of the time. ;)
It seemed to me to be a reasonable enough simplification - especially when you consider that excessive temperatures (high or low) and drought will give a reduction in the two other parameters making up my weather model.
Too much sun can lead to health problems (even when you discount the heat) such as skin cancer. Too little sun can lead to health problems as well, usually vitamin D deficiency or winter depression. I guess people can complain about weather, no matter what it is, if they really want to... :D