No subject
Sun Dec 12 18:29:16 GMT 2010
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
>
>
--20cf3005140a78719104b76be404
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Looks to me like it's two tables of data side by side? <br><br>The Reve=
nue (left) side has titles for each of the sections (anything where "I=
mputation" is blank). Imputation means budget line.<br><br>The "S=
pending" (right) side looks like it is separated into capital and recu=
rrent spending on each row. You'd want to include the stuff lower down =
on pensions, local government (presuming commune=3Dlocal government) spendi=
ng and debt.<br>
<br><span class=3D"st"><em>BF</em> =3D <em>Budget</em> de fonctionnement. <=
em>BIP</em> =3D <em>Budget</em> d'Investissement Public<br><br>BF =3D c=
urrent<br>BIP =3D capital<br></span><br>Would combining the two tables work=
in OpenSpending by turning the data into something like:<br>
<br>From | From_id | To | source | type | type_code | type_2 | type_2_code<=
br><br>IMPOTS SUR LES REVENUS DES PERSONNES PHYSIQUES | 721 | Government of=
Cameroon | Revenue | RECETTES PROPRES | A | RECETTES FISCALES | i | 155900=
<br>
Government of Cameroon | 1 | Society (Cameroon) | Spending | PRESIDENCE DE =
LA REPUBPLIQUE | 1 | Current spending | BF | 40927<br><br>Would that work? =
Then the views would allow you to show Revenue and Spending on separate tab=
s, broken down by `type` in each case.<br>
<br>Mark<br>
<br><br><div class=3D"gmail_quote">On 26 January 2012 09:34, Lucy Chambers =
<span dir=3D"ltr"><<a href=3D"mailto:lucy.chambers at okfn.org">lucy.chambe=
rs at okfn.org</a>></span> wrote:<br><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Pudo,=A0<br><br>Thanks for looking at this.=A0<br><br><div class=3D"gmai=
l_quote"><div class=3D"im"><blockquote class=3D"gmail_quote" style=3D"margi=
n:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Looking at the tree though, I'm not entirely sure this is normal<br>
balance sheet data - is there perhaps an English version or some data<br>
to look at available?<br></blockquote><div><br></div></div><div>=A0Sorry, I=
meant to send you the link to the DataHub package, there's some sample=
data in there:=A0</div><div><br></div><div><a href=3D"http://thedatahub.or=
g/dataset/cameroon-budget-2012" target=3D"_blank">http://thedatahub.org/dat=
aset/cameroon-budget-2012</a></div>
<div><br></div><div>If there is any way to meaningfully restructure the dat=
a, I'd be happy to write up a guide to put on the wiki.=A0</div><span c=
lass=3D"HOEnZb"><font color=3D"#888888"><div><br></div><div>Lucy=A0</div></=
font></span><div>
<div class=3D"h5"><div><br></div><div><br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1=
ex">
<br>
Best regards,<br>
<br>
=A0- Friedrich<br>
<br>
[1] <a href=3D"https://github.com/okfn/openspending/issues/157" target=3D"_=
blank">https://github.com/okfn/openspending/issues/157</a><br>
<div><div><br>
On Thu, Jan 26, 2012 at 12:14 AM, Lucy Chambers <<a href=3D"mailto:lucy.=
chambers at okfn.org" target=3D"_blank">lucy.chambers at okfn.org</a>> wrote:<=
br>
> Hi All,<br>
><br>
> I've been attempting to guide JeanBrice, dealing with the Cameroon=
budget<br>
> through the Data Format process, but want to make sure I am advising h=
im to<br>
> do the right thing.<br>
><br>
> His data is more like a balance sheet than what we usually have. Do we=
have<br>
> any nice way to display receipts / income (distinguishing them from<br=
>
> outgoings) or should he work just on the outgoings for now?<br>
><br>
> His data (including a diagram to show the structure of the budget) is<=
br>
> here:=A0<a href=3D"https://commondatastorage.googleapis.com/ckannet-st=
orage/2012-01-25T132804/Tree-of-the-Budget-of-the-State-of-Cameroon.pdf" ta=
rget=3D"_blank">https://commondatastorage.googleapis.com/ckannet-storage/20=
12-01-25T132804/Tree-of-the-Budget-of-the-State-of-Cameroon.pdf</a>).<br>
><br>
> Help appreciated!<br>
><br>
> Lucy<br>
><br>
> --<br>
> Lucy Chambers<br>
> Community Coordinator<br>
> Open Knowledge Foundation<br>
> <a href=3D"http://okfn.org/" target=3D"_blank">http://okfn.org/</a><br=
>
> Skype: lucyfediachambers<br>
><br>
</div></div>> _______________________________________________<br>
> openspending-dev mailing list<br>
> <a href=3D"mailto:openspending-dev at lists.okfn.org" target=3D"_blank">o=
penspending-dev at lists.okfn.org</a><br>
> <a href=3D"http://lists.okfn.org/mailman/listinfo/openspending-dev" ta=
rget=3D"_blank">http://lists.okfn.org/mailman/listinfo/openspending-dev</a>=
<br>
><br>
</blockquote></div></div></div><div class=3D"HOEnZb"><div class=3D"h5"><br>=
<br clear=3D"all"><div><br></div>-- <br>Lucy Chambers=A0<br>Community Coord=
inator<br>Open Knowledge Foundation=A0<br><a href=3D"http://okfn.org/" targ=
et=3D"_blank">http://okfn.org/</a><br>
Skype: lucyfediachambers<br>
</div></div><br>_______________________________________________<br>
openspending-dev mailing list<br>
<a href=3D"mailto:openspending-dev at lists.okfn.org">openspending-dev at lists.o=
kfn.org</a><br>
<a href=3D"http://lists.okfn.org/mailman/listinfo/openspending-dev" target=
=3D"_blank">http://lists.okfn.org/mailman/listinfo/openspending-dev</a><br>
<br></blockquote></div><br>
--20cf3005140a78719104b76be404--
More information about the openspending-dev
mailing list