[openspending-dev] Balance Sheets - advice please!

[Lucy Chambers]

Hi Folk,

Great - thanks for all of your input. Are we decided then - to reformat the
data along the lines suggested by Mark.

@Friedrich, didn't entirely understand:

"We'll just have to remember to reverse `to` and `from` if they are to be
set :)"

- Is this something JeanBrice needs to worry about when formatting his data
/ is this only an issue when loading the data in?

Lucy

On Thu, Jan 26, 2012 at 3:53 PM, JeanBrice Anti-Corruption <
jeanbrice at kick-corruption.org> wrote:

> Hello all,
>
> Thank you for your quick responses. I would just add that it is
> deliberately that the budget is made to be hard to understand, in the other
> hand we have a lot of difficulties in obtaining more detailed information
> on expenses. But we continue to seek this information.
> We hope that the viewing of this budget will be an asset to improve the
> budget in Cameroon.
>
> Thank you for your support again.
>
> JeanBrice.
>
> 2012/1/26 Friedrich Lindenberg <friedrich.lindenberg at okfn.org>
>
>> On Thu, Jan 26, 2012 at 1:32 PM, Mark Brough
>> <mark.brough at publishwhatyoufund.org> wrote:
>> > Looks to me like it's two tables of data side by side?
>>
>> That was my impression as well, but my french is disastrous.
>>
>> > The Revenue (left) side has titles for each of the sections (anything
>> where
>> > "Imputation" is blank). Imputation means budget line.
>> >
>> > The "Spending" (right) side looks like it is separated into capital and
>> > recurrent spending on each row. You'd want to include the stuff lower
>> down
>> > on pensions, local government (presuming commune=local government)
>> spending
>> > and debt.
>>
>> This is nice for us, since we can aggregate both ways: sum up capital
>> and recurrent or by other breakdowns.
>>
>> > BF = Budget de fonctionnement. BIP = Budget d'Investissement Public
>> >
>> > BF = current
>> > BIP = capital
>> >
>> > Would combining the two tables work in OpenSpending by turning the data
>> into
>> > something like:
>> >
>> > From | From_id | To | source | type | type_code | type_2 | type_2_code
>> >
>> > IMPOTS SUR LES REVENUS DES PERSONNES PHYSIQUES | 721 | Government of
>> > Cameroon | Revenue | RECETTES PROPRES | A | RECETTES FISCALES | i |
>> 155900
>> > Government of Cameroon | 1 | Society (Cameroon) | Spending | PRESIDENCE
>> DE
>> > LA REPUBPLIQUE | 1 | Current spending | BF | 40927
>> >
>> > Would that work? Then the views would allow you to show Revenue and
>> Spending
>> > on separate tabs, broken down by `type` in each case.
>>
>> That sounds good, I've been using this with German budgets (Federal,
>> Berlin, Bremen) and the Budget of the European Union.
>>
>> We'll just have to remember to reverse `to` and `from` if they are to be
>> set :)
>>
>> - Friedrich
>>
>> > On 26 January 2012 09:34, Lucy Chambers <lucy.chambers at okfn.org> wrote:
>> >>
>> >> Hi Pudo,
>> >>
>> >> Thanks for looking at this.
>> >>
>> >>> Looking at the tree though, I'm not entirely sure this is normal
>> >>> balance sheet data - is there perhaps an English version or some data
>> >>> to look at available?
>> >>
>> >>
>> >>  Sorry, I meant to send you the link to the DataHub package, there's
>> some
>> >> sample data in there:
>> >>
>> >> http://thedatahub.org/dataset/cameroon-budget-2012
>> >>
>> >> If there is any way to meaningfully restructure the data, I'd be happy
>> to
>> >> write up a guide to put on the wiki.
>> >>
>> >> Lucy
>> >>
>> >>
>> >>>
>> >>> Best regards,
>> >>>
>> >>>  - Friedrich
>> >>>
>> >>> [1] https://github.com/okfn/openspending/issues/157
>> >>>
>> >>> On Thu, Jan 26, 2012 at 12:14 AM, Lucy Chambers <
>> lucy.chambers at okfn.org>
>> >>> wrote:
>> >>> > Hi All,
>> >>> >
>> >>> > I've been attempting to guide JeanBrice, dealing with the Cameroon
>> >>> > budget
>> >>> > through the Data Format process, but want to make sure I am advising
>> >>> > him to
>> >>> > do the right thing.
>> >>> >
>> >>> > His data is more like a balance sheet than what we usually have. Do
>> we
>> >>> > have
>> >>> > any nice way to display receipts / income (distinguishing them from
>> >>> > outgoings) or should he work just on the outgoings for now?
>> >>> >
>> >>> > His data (including a diagram to show the structure of the budget)
>> is
>> >>> >
>> >>> > here:
>> https://commondatastorage.googleapis.com/ckannet-storage/2012-01-25T132804/Tree-of-the-Budget-of-the-State-of-Cameroon.pdf
>> ).
>> >>> >
>> >>> > Help appreciated!
>> >>> >
>> >>> > Lucy
>> >>> >
>> >>> > --
>> >>> > Lucy Chambers
>> >>> > Community Coordinator
>> >>> > Open Knowledge Foundation
>> >>> > http://okfn.org/
>> >>> > Skype: lucyfediachambers
>> >>> >
>> >>> > _______________________________________________
>> >>> > openspending-dev mailing list
>> >>> > openspending-dev at lists.okfn.org
>> >>> > http://lists.okfn.org/mailman/listinfo/openspending-dev
>> >>> >
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> Lucy Chambers
>> >> Community Coordinator
>> >> Open Knowledge Foundation
>> >> http://okfn.org/
>> >> Skype: lucyfediachambers
>> >>
>> >> _______________________________________________
>> >> openspending-dev mailing list
>> >> openspending-dev at lists.okfn.org
>> >> http://lists.okfn.org/mailman/listinfo/openspending-dev
>> >>
>> >
>>
>
>


-- 
Lucy Chambers
Community Coordinator
Open Knowledge Foundation
http://okfn.org/
Skype: lucyfediachambers
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending-dev/attachments/20120127/cefe5fda/attachment.html>