[wdmmg-discuss] NEW DATA Sample for Spending data in Argentina with Detailed labels in level 3

Thu Apr 7 23:35:34 UTC 2011

Hi Frederik,
thanks a lot everyone for this afternoon conference.

To set adecuate expectatives about my knowledge in this topic for tomorrow meeting, I´ve done several scrapping operations, but based on Visual Basic for Applications (VBA) running on an Excel worksheet, what has the advantage of writing directly in a Sheet with the columns design and data that journalists expected.
One of this projects was an application that automatic opened 180 Excel files (previously converted from PDF) that contained "suspicious" compensations to bus transportation companies.

I´m not a Python programmer, I'm doing my first code lines experience because we see that Phython is everywere..
And being honest, I saw this WDMMG documents with de OpenSpending Architecture and the CSV model about two hours before the meeting, so I was not able to follow you while you were showing the Google Docs sheet.

As an attachment you will find an Excel sheet similar to the one Angelica sent you, but this one is the full version with additional information.
You can find in different sheets with information than could help you to understand better what it reflects.

* ADAPTED Sheet - is a copy of the one original (named ORIGINAL) but with the headers translated to english to help the understanding of the data contained.
* Structure Sheet - shows in three columns how the Jurisdictio, Function and Pourpose are related each other.
* Descriptors Sheet - shows how information could be arranged (with translation for help). Pourpouse could be associated to WHY, Function to WHAT, and Jurisdiction to WHO.
         Function_ID is 2 digits (the original is only one), because it includes de Pourpose_ID (??)
* Program Details - In this we can see that the same Program ID could have different menings. If not different in the sense, different ministries.
* ORIGINAL - Is the original document.

I tried to map this with the "mongo entities", "mongo-classifiers" or "mongo fields" described in the Google Docs references but I couldn't find how.
I hope this will help to get results in our tomorrow meeting.

All the Best, and many thanks again !!!
Ricardo
________________________________________
De: Peralta Ramos Momi (Gerente de Desarrollo Multimedia)
Enviado el: jueves, 07 de abril de 2011 10:49 a.m.
Para: Lucy Chambers
CC: Friedrich Lindenberg; Brom, Ricardo (Gerente de Tecnologia y Seguridad Informatica); wdmmg-discuss at lists.okfn.org; Cabot, Diego (Economia); Rufus Pollock
Asunto: RE: [wdmmg-discuss] NEW DATA Sample for Spending data in Argentina with Detailed labels in level 3

Yes! We entered as guests! rgbrom and momiperalta1
I tried the upper right login with my wddmg mai an ling list password but it didn’t work!
We´ll be ready to Meet at 3pm (Buenos Aires)

Best wishes
Angelica (momiperalta1)

-----Mensaje original-----
De: okfn.lucy.chambers at gmail.com [mailto:okfn.lucy.chambers at gmail.com] En nombre de Lucy Chambers
Enviado el: Miércoles, 06 de Abril de 2011 14:31
Para: Peralta Ramos Momi (Gerente de Desarrollo Multimedia)
CC: Friedrich Lindenberg; Brom, Ricardo (Gerente de Tecnologia y Seguridad Informatica); wdmmg-discuss at lists.okfn.org; Cabot, Diego (Economia); Rufus Pollock
Asunto: Re: [wdmmg-discuss] NEW DATA Sample for Spending data in Argentina with Detailed labels in level 3

Not a problem!

Would you like me to add you to the list for the call tomorrow at 7pm
UK (6pm GMT) / 2pm EST / 8pm CET? Were you able to access the
etherpad?

If you could give me your Skype name (or names if your programmer and
economy editor would like to join), then we will be able to pull you
into the call.

Please also send me any specific questions that you have so that I can
add them to the agenda - that way we can think about them before hand
and possibly have some answers ready for you.

Looking forward to speaking to you soon!

Lucy

On Wed, Apr 6, 2011 at 4:38 PM, Peralta Ramos Momi (Gerente de
Desarrollo Multimedia) <APERALTA at lanacion.com.ar> wrote:
> Thanks Lucy!
>
> Let me know what is a convinient moment for you to make that call, and of it´s necessary I can coordinate with our senior programmer or our investigative/economy editor.
>
> We´re eager to move forward!
> :)
> Angélica
>
> -----Mensaje original-----
> De: okfn.lucy.chambers at gmail.com [mailto:okfn.lucy.chambers at gmail.com] En nombre de Lucy Chambers
> Enviado el: Miércoles, 06 de Abril de 2011 12:29 p.m.
> Para: Peralta Ramos Momi (Gerente de Desarrollo Multimedia)
> CC: Friedrich Lindenberg; Brom, Ricardo (Gerente de Tecnologia y Seguridad Informatica); wdmmg-discuss at lists.okfn.org; Cabot, Diego (Economia); Rufus Pollock
> Asunto: Re: [wdmmg-discuss] NEW DATA Sample for Spending data in Argentina with Detailed labels in level 3
>
> Dear Angelica,
>
> Thank you for your email, we are definitely making progress. I think
> the best next step would be to arrange a call to discuss how we can
> move forward next.
>
> As you may be aware, we are having a wdmmg online community meetup
> tomorrow, 7th April at 7pm UK (6pm GMT) / 2pm EST / 8pm CET and it
> would be an excellent opportunity to talk to the team about how to
> proceed.
>
> If you would like to attend the catchup - please simply add your name
> and Skype id to the etherpad for the catchup:
> http://wdmmg.okfnpad.org/meeting-2011-04-07
>
> If this is not convenient then we will arrange another catchup, either
> way, looking forward to hearing from you soon!
>
> Best wishes,
>
> Lucy
>
>
>
> On Tue, Apr 5, 2011 at 5:44 PM, Peralta Ramos Momi (Gerente de
> Desarrollo Multimedia) <APERALTA at lanacion.com.ar> wrote:
>> Hi Friedrich and WDMMG team!
>>
>> I´m sending the new data sample or Argentina 2011 Forcast with 3 levels, with Friederich´s feedback included, and the most detailed "Program" description, now with labels, in the third level (find it in the "Detalle por funcion" spreadsheet.)
>>
>> Let me know it this is ok and next steps, so we can move forward and upload the information!
>>
>> Regards
>> :)
>> 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
>>
>> _______________________________________________
>> wdmmg-discuss mailing list
>> wdmmg-discuss at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/wdmmg-discuss
>>
>>
>
>
>
> --
> Lucy Chambers
> Community Coordinator
> Open Knowledge Foundation
> http://okfn.org/
>

--
Lucy Chambers
Community Coordinator
Open Knowledge Foundation
http://okfn.org/