Budgets and Gadgets

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…

Advertisements

4 Comments

Filed under Economy

4 responses to “Budgets and Gadgets

  1. Luca

    Let’s just do it! 😀

  2. Pingback: My 2009 tax receipt « The Blog by Javier

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s