[okfn-za] Cape Town budget for dummies

[Rufus Pollock]

Dear Fritz (cc'ing the Open Knowledge Foundation South Africa mailing list),

This is brilliant. I've google-doc'd it here:

https://docs.google.com/a/okfn.org/spreadsheet/ccc?key=0AqR8dXc6Ji4JdDM4LWtFWVFLTWZ4ZDdNZHNzY1NmUmc&hl=en#gid=0

As the document is quite large with a lot of tables I wondered if you
had any tips on how to get the best (most disaggregated) set of
expenditure (or revenue info) out in a consolidated table.

To illustrate what I had in mind I've creating a separate example
sheet with headings:

https://docs.google.com/a/okfn.org/spreadsheet/ccc?key=0AqR8dXc6Ji4JdDM4LWtFWVFLTWZ4ZDdNZHNzY1NmUmc&hl=en#gid=1

This is what would be perfect for loading into http://openspending.org/!

Rufus

On 20 April 2013 18:26, Fritz Jooste <fritz at nu.org.za> wrote:
> Hi Rufus and Thoko
>
> I've attached the Excel file I used for the document. It the output from a
> PDF to XLS conversion program I used on the budget document from the City of
> Cape Town website. It's not the cleanest data, but with some editing and
> tweaking should be usable.
>
> The more people can meaningfully engage with the budget, the better!
>
> All the best
> Fritz
>
>
>
> On 20 April 2013 16:22, Thoko Madonko <thoko.madonko at gmail.com> wrote:
>>
>> Dear Fritz
>>
>> See the request below from Rufus Pollock. It would be great to get Cape
>> Town included.
>>
>> Let me know if I can help.
>>
>> regards
>> Thoko
>>
>>
>> ---------- Forwarded message ----------
>> From: Rufus Pollock <rufus.pollock at okfn.org>
>> Date: 19 April 2013 18:43
>> Subject: Re: [okfn-za] Cape Town budget for dummies
>> To: Adi Eyal <adi at burgercom.co.za>
>> Cc: "okfn-za at lists.okfn.org" <okfn-za at lists.okfn.org>
>>
>>
>> http://nu.org.za/analysis-city-of-cape-town-201314-draft-budget/ - very
>> nice!
>>
>> Is there any way to get the underlying data in excel / CSV? It would then
>> be 2s to get this into http://openspending.org/ and have a first South
>> African city on http://apps.openspending.org/maps/!
>>
>> Rufus
>>
>>
>> On 18 April 2013 17:47, Adi Eyal <adi at burgercom.co.za> wrote:
>>>
>>> Hi All
>>>
>>> Check out @fritzjooste of Ndifuna Ukwazi and his visualisation of the
>>> draft Cape Town city budget. He's turned a spreadsheet into a story. I can't
>>> think of a more apt use of visualisation for simplifying data.
>>>
>>> Adi
>>>
>>> --
>>> Adi Eyal
>>> Data Specialist
>>> phone: +27 78 014 2469
>>> skype: adieyalcas
>>> linkedin: http://za.linkedin.com/pub/dir/Adi/Eyal
>>>
>>>
>>> _______________________________________________
>>> okfn-za mailing list
>>> okfn-za at lists.okfn.org
>>> http://lists.okfn.org/mailman/listinfo/okfn-za
>>> Unsubscribe: http://lists.okfn.org/mailman/options/okfn-za
>>>
>>
>>
>> _______________________________________________
>> okfn-za mailing list
>> okfn-za at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/okfn-za
>> Unsubscribe: http://lists.okfn.org/mailman/options/okfn-za
>>
>>
>
>
>
> --
> Fritz Jooste
> RESEARCHER
>
> Ndifuna Ukwazi (Dare to Know)
>
> Tel: +27 (0) 21 423 9593/3089
> Fax: +27 (0) 21 423 7554
> Cell: +27 (0) 82 512 5496
>
> Office 203, 47 on Strand,
> Cape Town, 8001
>
> http://www.nu.org.za