Re: Bank Charges Interest Calculator

[smbird090177]

Hi All.

 

I have inputted my information into the Bank Charges Interest Calculator

 

http://www.consumeractiongroup.co.uk/forum/showthread.php?t=182

 

I am currently struggling to understand the:

 

Days Since Offence

 

and

 

Interest

 

sections as they both say #NAME?

 

and i am not sure what to put the values to.

 

Does the days since offence really mean how many days from the 'In Respect Of' to the actual date today. I dont think it does but is confusing me.

 

And what do i type in the interest section as this also has the same NAME values.

 

Sorry if this is obvious but need help to complete this

 

Cheers

Shaun

[Bovvered]

Have a look at this:

 

http://www.consumeractiongroup.co.uk/forum/showpost.php?p=50088&postcount=16

 

Maybe the formula has been accidentally changed, maybe download a new copy

[bram stoker]

#Name is an error message indicating that you haven't entered the data correctly or completely.

 

Once the amount and date incurred have been entered, all should read well. Try to avoid making any other amendments to the spreadsheet as the calculations may corrupt.

 

Let me know if you need further help.

Vamp.

[smbird090177]

thanks for your replies.

 

I have entered my info into the coumns...

 

I cannot understand what i have done wrong if anything..

 

In the In respect of: i have added the terms that natwest have place...i.e: Charges, instead of your Unpaid DD, or something similiar.

 

In the Amount it looks like: £30.00 etc

 

Date Incurred: 22/02/2004....like the examples are:

 

Therefore im stuck as the days since offence and interest apr are still showing #NAME?

 

Cheers

Shaun

[Bovvered]

Did you download a new copy?

[barracad]

Are you using Excel? Some other programs like OpenOffice don't understand the date function.

[Bovvered]

Also make sure you don't press delete before entering your data, just tab across and enter your data over the top of what's already there

[smbird090177]

oops

 

sorry im using open office

[barracad]

Try this one instead:

 

http://www.consumeractiongroup.co.uk/forum/showthread.php?p=49846#post49846

[smbird090177]

Sorry to be of nuissance but

 

I get a message saying:

 

An A.P.I Call exited Abnormally.

 

not sure what this means but cant open it

[Spiceskull]

If you are using Open Office then PM me, it's the spreadsheet I put together, so if there are any problems you need to give me a kicking

 

I suspect you have deleted the formulas in the first rows, so I may need to send them to you to paste back into the relevant cells.

[ella]

Hi, i have just discovered all this today but am having trouble opening up a spreadsheet, im not very computer literate for a start! i dont think i have excel on my computer, i clicked on the link for the open office one (because when i looked at my programmes it said open office so i must have that one!?) and it opened a window but there were loads of things on there that mean gobbledygook to me , and nothing saying "schedule of charges" or anything to suggest it was anything to do with this? i clicked on most of them anyway but nothing looking like a spreadsheet comes up please help me i am a useless woman and pregnant too if that makes you pity me more

 

and as for calculating interest......... :o thats a whole new ball game!