[okfn-za] Cape Town budget for dummies

Rufus Pollock rufus.pollock at okfn.org
Tue Apr 30 10:59:21 UTC 2013


Hi Fritz and Thoko,

Just wanted to follow up here. Having been looking through the
spreadsheet<https://docs.google.com/a/okfn.org/spreadsheet/ccc?key=0AqR8dXc6Ji4JdDM4LWtFWVFLTWZ4ZDdNZHNzY1NmUmc&hl=en#gid=0>
it
seems that Table 1 may be the best (if there were a way to merge other
tables I could perhaps get richer info).

@Fritz: would you have any tips here.

Regards,

Rufus

On 22 April 2013 13:01, Rufus Pollock <rufus.pollock at okfn.org> wrote:
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/okfn-za/attachments/20130430/9f1f3fad/attachment-0002.html>


More information about the okfn-za mailing list