Excel MoneySavingExpert Budget Spreadsheet

birch_2

kiwichick wrote:

wearetalkingphonenumbers wrote:

You can download it from www.openoffice.org & it will work with standard Excel and Word files. I've opened the budget spreadsheet in it successfully although I haven't tested it to make sure all the Macro's work.
quote]

Hiya,

I have openoffice but dont know how to open the spreadsheet within it properly. It says it is zipped?!? I click to repair the file/upzip the file but it says it is corrupted and therefor cant be opened?!? Any advice?

Many THanks,
Allison

Hi, iv just downloaded openoffice and tryed to open the budget but it says its corrupt, can anyone help.

on my computer i have microsoft spreadsheet as standard.

birch_2

birch wrote:

kiwichick wrote:

Hi, iv just downloaded openoffice and tryed to open the budget but it says its corrupt, can anyone help.

on my computer i have microsoft spreadsheet as standard.

just extracted it to openoffice and disabled marcos, but it only had the wording on it of how to budget, not the actual formulas etc HELP!

pompom_uk

Tony_H wrote:

Mmmm, can I just say that like the online version & at Martins request this has been specifically designed to allow you to enter either weekly, monthly or annually figures for each expense.

When it states that you can mix the entries this means that you could enter "Weekly" for say shopping & "Monthly" for a mobile telephone bill & "Annually" for car insurance.

If you have 2 cars with seperate insurance's you will have to manually add these up and add them to the column of you choice.

It will fail if you enter Weekly, Monthly & Annually on the same line.

Hope this clarifies it's workings more clearly.

A recent buyer of Martin's book. I definitely will be using what is a very useful spreadsheet.

Just a recommendation Tony: wouldn't it be better just to add the weekly, monthly & annual totals together, instead of using an 'IF' statement. That way it's easier to add different charges together, cutting the amount of manual calculations.

John_Stumbles

The_Nickster wrote:

For us poor peasants who prefer not to pay the extortionate prices that Microsoft charge for MS Office and MS Excell can this spreadsheet be used in any other software package?

Good point: here's a great MoneySaving (tm:-) tip: don't buy expensive and often insecure software from Microsoft, run Free Open Source Software instead! For example OpenOffice.org (OOo) is a near-as-dammit M$ Office clone (they've even cloned some of the bugs, I swear :-|). It runs under Windoze, but you could go the whole hog and ditch M$ altogether and run Linux. Kubuntu is a pretty easy-to-install Linux distribution with an interface that's familiar to windows users.

However, the budget spreadsheet doesn't even open under OpenOffice version 1.1, and under version 2.0 it complains (after warning that macros may contain viruses, which isn't really a problem under Linux) of a"BASIC runtime error / Property or method not found". The spreadsheet seems to work - I bunged some figures in to the expenditure and income sheets and it worked out a balance - so the error may be in something cosmetic. For what it's worth OOo showed me the 'ThisWorkbook' sheet with the line
Application.CommandBars("Standard").Visible=False
highlighted so maybe that's where the problem was.

philipbenton

I deleted something in a cell and this message has appeared in the part B and I cant remove it therefore throwing the expenditure calculations out- any advice?

Thanks

Neilmgracie

MSE_Webmaster wrote:

Technical Queries Discussions: This is the place for any comments or queries regarding the technical and/or functional facets of MSE's Excel Budget Spreadsheet. !Any bugs or errors, please write them down here.

Questions about Budgetting: To discuss budgets and budgeting, please go here.

Martin's Article: Before you download the Spreadsheet, make sure you read Martin's article:
Budget the MoneySavingExpert way

To get the spreadsheet, click here.

Special thanks to MSE regular Tony H for putting the Spreadsheet together! ! !

Webby


Addition from Martin

Tony has done an amazing volunteer job doing this. !And i know he is reading this and will be here to help if you can't use the spreadsheet. !
martin

Hi
Great spreadsheet. Can you possibly advise formula on consolodation sheet which grabs the totals from the other account sheets. Tried everything to work it out but now admit defeat. Hope this is posted in the correct place.
Thank you.
Neil

littlescarlet

Seems churlish after all these people having problems getting at the spreadsheet at all, but I have filled it in and am sadly in the red, but find that my 'desired expenditure' has no summary sheet and no way except paging back and forth and manually filling in the column to see if my cuts have been enough to bring me into the green. Please could we have a version with a summary for the desired budget too?

landsker

I have Open Office and the spreadsheet will not work i Open Office Calc spreadsheet.
Any help here?
Thanks

tiff

I couldnt get it to work in open office either, then found this post

http://forums.moneysavingexpert.com/showpost.html?p=301244&postcount=107

Download the version in the link and it should work fine.

landsker

Hi,

I downloaded the latest version from the link, but still no joy!
Here is `a screen shot of the error message. Macros are enabled BTW.