[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: [Debconf-team] adding a Pesos column to the spreadsheet

Andreas Schuldei dijo [Fri, Feb 24, 2006 at 11:09:28PM +0100]:
> i now added the option to add pesos to the budget spreadsheet.
> it is not complete yet, since i only added it (as an example) to
> the "expected expenses" group of the housing page. the other
> pages (and the "spent" group on the housing
> page) where local currency will be used should also get this
> column. But with the formular there and ready it should be easy
> to just duplicate it to other areas of the spreadsheet. 

Ok, I finally got around to do this. The updated budget is in svn.

> this is mostly busy work and especially people who want to get
> used to work with the budget can do it.

Hmmm... So it looks I will be balancing budgets? :(

> what you need to do:
> - append a column after the USD and EUR columns. watch out for
>   the merged cells in the headline of the group.
> - copy in the formular from the housing page to the USD column.
>   it should be sometihng like
>   =IF(ISNUMBER($C6);IF(EXACT($D6;"$");$C6*Overview.C$39;IF(EXACT($D6;"¤");$C6*Overview.C$40;IF(EXACT($D6;"M");$C6*Overview.C$41;"")));"")
> - double check that the correct fields in the Overview page are
>   referenced. the order of the currencies in the matrix on the
>   overview page matches the order of the columns in the other
>   pages. therefor it works just fine to pull (i think the correct
>   jargon for spreadsheets is "fill") the USD value over the EUR
>   and the MXN columns and rows. 
> - check that the filling incremented the Cs in the Overview
>   references to Ds and Es in the EUR and MXN column.
> - check if everything works by adding some costs in the different
>   currencies, like it can be seen in the housing page and that
>   the results are correct.
> - update the subtotal line, too

Ok, it _seems_ it works fine. I worked with:

- Housing
- Food
- Daytrip
- Other expenses

You will noticed I added two lines at Housing: 

    Quote was originally for how many people: 200
    Calculate amounts for how many people: 300

Of course, I tried to only duplicate what's needed according to this
(pricing for rooms and food). AFAIK, the daytrip projected costs are
for 300 people. I added only one of the possible quotes we have so far
(which is by ~US$2000 more expensive) to give us a ceiling and not a
floor value (and because I hope that's the one we hire in the end). 

Now, about having spurious old DC5 values: The data in "private
sponsors" (one with US$1000 and one with 2000EUR), are those real or
testing values? Can I drop them? (we have a MX$2000 donation)

I would like to start tracking here the bank account - It follows a
different structure, so I prefer to wait on your comments, ok?


Gunnar Wolf - gwolf@gwolf.org - (+52-55)5623-0154 / 1451-2244
PGP key 1024D/8BB527AF 2001-10-23
Fingerprint: 0C79 D2D1 2C4E 9CE4 5973  F800 D80E F35A 8BB5 27AF

Attachment: signature.asc
Description: Digital signature

Reply to: