[openspending-dev] Balance Sheets - advice please!

Thu Jan 26 10:32:09 UTC 2012

Looks to me like it's two tables of data side by side?

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.

*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.

Mark

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending-dev/attachments/20120126/f1188548/attachment.html>