Re: Found another bug in the budget 2009

["Jaap A. Haitsma" <jaap haitsma org>]

On Tue, Jun 9, 2009 at 23:56, Stormy Peters<stormy gnome org> wrote:
>
>
> On Tue, Jun 9, 2009 at 12:35 AM, Jaap A. Haitsma <jaap haitsma org> wrote:
>>
>> Hi Stormy,
>>
>> I was making the budget spreadsheet a bit less error prone by using
>> named cells and found another bug.
>>
>> If you look at the "Corporate Contributions" sheet the total for
>> programs in 22K$ on the "Programs" sheet it's 35K$
>>
>> I notice the following differences
>> 1) Canonical: 2K for Programs on  "Corporate Contributions" sheet and
>> 0K on the "Programs" sheet
>> 2) Intel: 5K for Programs on  "Corporate Contributions" sheet and 15K
>> on the "Programs" sheet
>> 3) Mozilla 0K for Programs on  "Corporate Contributions" sheet and 5K
>> on the "Programs" sheet

Oops I made mistake here 2 should be
2) Intel: 5K for Programs on  "Corporate Contributions" sheet and 0K
on the "Programs" sheet

And there should be a 4)
4) IBM: 0K on Programs on  "Corporate Contributions" sheet and 15K on
the "Programs" sheet


> I don't believe the program column on the corporate contributions sheet and
> the programs sheet were necessarily tracking the same thing. At least things
> like a usability study were never added to the programs sheet.
>
> This is what I've been meaning to redo for a while ... I think we should
> have a tab for each program, especially programs where the money is
> earmarked for a specific purpose and needs to be kept just for that. We can
> also have a tab just for annual donations or any general purpose donations.
> Then we can have a tab that summarizes all the corporate contributions by
> company so we can see it all in one place.

I think having the seperate tabs like you are proposing is a good
idea. Can you do this. I wouldn't mind doing it but I don't know for
what the money is actually planned to be used.

> I'm not sure if gnucash will take care of all this for us or not, but in the
> meantime we can do it in the spreadsheet ...

These programs are usually very good in doing standard stuff but if
you are not standard or want to do something none standard a
spreadsheet is a lot more flexible

> As for the specifics. Intel gave us $30K for the year. They agreed $10K was
> a general purpose donation but they wanted some say over how the other $20K
> was used - so for example, with their agreement, we used some of it to
> sponsor the Documentation hackfest. But we have the $30K.
>
> Google gave us $5K towards a sys admin and committed to the Summer of Code
> funding. (In addition to the annual $10K.)
>
> Most of the others (above the annual dues) are not collected yet and were
> more of an estimate of what they thought they'd do, not a firm commitment so
> I didn't roll them all up into the total. (Companies do their budget
> planning in the fall, so we provided them with an estimate of all the things
> we'd be asking for over the year. However, they declined to pay in advance
> and since all companies are cutting budgets, I don't think we can count on
> that money until we see it. Another reason premium and bundled sponsorships
> would be good.)

I understand that these are estimates because you never know you
really get the money.

However it would be nice to have the spreadsheet correct, otherwise
you do not have a good reference if you want to see how you are doing
during the year.


Jaap