A couple of Sundays ago I was discussing with my father about Spanish public debt, budget deficits, etc. We both had some figures in mind and I also had some others recorded in the mobile phone, from a conference I had attended at EOI Business School some months before (see the slides below).
Over the table, my father and I were trying to figure out whether the Spanish public debt could reach or not 75% of GDP in two years from now: “given that budget is around 35% of GDP and public debt is around 53% of GDP, then if budget deficit is 12% this would add to the public debt no more than 4% debt over GDP a year”… at that moment I missed having had at hand a detailed view of the Spanish Government Budget of 2010. I wanted to have some TreeMap of the budget like the one I had recently seen from the US 2011 Budget request at The New York Times website.
So I put myself into it. Google docs spreadsheet has among its many gadgets the possibility to draw a Tree Map which is precisely what I wanted to have. First I used some already prepared data from the my job to see how it worked, and, once I saw it was easy, I gathered the data about Spanish Government from the following website (of which I also liked much the way of presenting).
I had seen some treemaps before at the job, but so far not so many outside. So, the main purpose of this post is not to talk about budgets, but to let you know about this gadget which maybe useful in your job. You may see below the gadget I prepared and if you click on it you may see the detailed figures for each one of the chapters, grouped by category.
The one thing I didn’t like much, again, is that WordPress.com is not enabling its users to directly embed this kind of gadgets into the blog… but this has a simple solution that I keep postponing…
The Blog by Javier 