[wdmmg-discuss] DATA Sample for Spending data in Argentina

[Peralta Ramos Momi (Gerente de Desarrollo Multimedia)]

Friedrich: here´s the Data-set without subtotal rows in the third level "Porcentaje por programa".

I eliminated the "Percentage" column that was calculated as a Fn of the subtotals and left the absolute values in the rows.
I left the coloured rows but they´re empty, feel free to erase them.

Ready for your feedback and next steps!
;)
Angelica




-----Mensaje original-----
De: friedrich.lindenberg at gmail.com [mailto:friedrich.lindenberg at gmail.com] En nombre de Friedrich Lindenberg
Enviado el: Lunes, 28 de Marzo de 2011 05:13 p.m.
Para: Peralta Ramos Momi (Gerente de Desarrollo Multimedia)
CC: wdmmg-discuss at lists.okfn.org
Asunto: Re: [wdmmg-discuss] DATA Sample for Spending data in Argentina

Hi Angélica,

this is really fantastic stuff, I wish we also saw data that was so
well formatted!

On Thu, Mar 24, 2011 at 5:37 PM, Peralta Ramos Momi (Gerente de
Desarrollo Multimedia) <APERALTA at lanacion.com.ar> wrote:
> - In the spreadsheet "Porcentaje por FinFun" you will find the 1st level: "Finalidad" and 2nd levels "Función"

These are aggregate values derived from the first sheet, no?

> - In the spreadsheet "Porcentaje por Programa" there´s a sample of a detailed 3rd level for two destinations "Administración Gubernamental" and "Servicios de defensa y seguridad".

This is perfect, if you could perhaps remove the subtotal rows we
should be able to use our new web-based loader to integrate the
information.

> - At the 3rd level we will replace next week the numbers of the E column ("Programa") with their labels.

We can also for now go without a third level?

As a further questions: do you have someone with some Python knowledge
who could work with us to get the data loaded? Perhaps we should have
a quick call some time?

- Friedrich
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sampleforecast2011OKF1.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 33123 bytes
Desc: sampleforecast2011OKF1.xlsx
URL: <http://lists.okfn.org/pipermail/openspending/attachments/20110329/3f9a29c5/attachment.xlsx>