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. this is mostly busy work and especially people who want to get used to work with the budget can do it. 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 - rinse, repeat. - check in the new improved spreadsheet. Thanks!!!
Attachment:
signature.asc
Description: Digital signature