Spreadsheet with interest - Page 2

essjaydee · 31st May 2006, 14:44

Hello thanks for the spreadsheet, just one (possibly stupid) question!

Just entered the interest parts in on the right hand columns, and i take it that it is working out rough estimate of the interest charge which is the piece you would add onto your claim total?

19.62 interest.... balance of -1,441.44 at time of interest = 7.21 that i would then add to my charges to the bank?

i also saw someone else comment about the spreadsheet not working if the balance you enter is positive? i think u advised to try to work out the average balance for the month - but what happens if the average is also positive?

Thanks again!

bram stoker · 31st May 2006, 14:55

Essjaydee,

You are right to add the interest to the charges (of course, for other looking at this post, I'm NOT talking about the 8% interest).

Please see my notes in the spreadsheet as to the date and balance used. They can only ever give an estimate.

Vamp. x

timkay · 9th June 2006, 13:19

I downloaded the basic Xls sheet, I have entered the statement date and amount and reason. But how do i calculate the days since offence. Do i have to count back for every transaction (about 30)? Is there an easier way to work it out?

bram stoker · 9th June 2006, 13:20

Tim,

There is a formula set up in there. Don't delete it. You may need to copy it out again.

D.R.Burgess · 12th June 2006, 11:41

Hi,

Apologies if this is the wrong place to ask this question, but at what point does the 8% County Courts Act (?) interest get applied? I ask because there are a lot of conflicting accounts (I can expand if necessary) and I like to know exactly where I stand (especially with the letter before action).

From what I've largely pieced together, I need to:

1. Send a preliminary letter with a list of charges and the approximation of interest charged, without the 8% interest.

2. If I don't get any joy, I need to send a letter/notice before action, again including the list of charges but I'm not clear whether or not I can include the 8% at this stage - I'm thinking this is, again, without the 8% added....?

3. Still no joy, I need to file a claim with the county court, at which point I can add the 8%.

Is this the case or have I completely lost it?

Many Thanks

krakan · 12th June 2006, 12:30

Bang on as I understand it!

Rooster-UK · 12th June 2006, 12:37

Almost right.

Stage 2...... Detail your charges along with the overdraft interest. Don't add on the 8%.

There is a letter in the templates library for this.

3. Letter before action - Consumer version - asking for it back

Good luck with your claim.

D.R.Burgess · 16th June 2006, 17:34

Cheers - much appreciated

blinkyblinkyblonk · 16th June 2006, 21:45

I downloaded the basic Xls sheet, I have entered the statement date and amount and reason. But how do i calculate the days since offence. Do i have to count back for every transaction (about 30)? Is there an easier way to work it out?

Quote:

Originally Posted by Vampiress

Tim,

There is a formula set up in there. Don't delete it. You may need to copy it out again.

hi vampiress,

im sorry if i may be sounding a bit thick here, but i have entered the date of the charge and the charge amount, but the formula just says #NAME?

I have the same problem as tim, i thought i had to count back the days from my first date of charges.

can you help me please,

many thanks

barracad · 16th June 2006, 22:36

Quote:

Originally Posted by blinkyblinkyblonk

i have entered the date of the charge and the charge amount, but the formula just says #NAME?

Are you using Microsoft Excel?

blinkyblinkyblonk · 16th June 2006, 23:49

hi barracad,

no i dont have microsoft excel its open office one that i downloaded from here.

bram stoker · 17th June 2006, 08:47

Quote:

Originally Posted by blinkyblinkyblonk

hi barracad,

no i dont have microsoft excel its open office one that i downloaded from here.

You have a corrupted formula in that cell. Try downloading the spreadsheet again and copying the formula back in. If you get stuck Let me know.

powerful_rogue · 17th June 2006, 12:15

Quote:

Originally Posted by Vampiress

You have a corrupted formula in that cell. Try downloading the spreadsheet again and copying the formula back in. If you get stuck Let me know.

Vampiress,

Im having the same problem. Thought I had to count back how many days have passed since august 2001!

I have downloaded the basic spreadsheet a few times but it still shows up with #NAME? in the "Days since offence" and "interest at 8%" fields.

I am using open office as I dont have excel.

Any help would be greatly appreciated.

bram stoker · 17th June 2006, 14:22

Are you all downloading the Excel spreadsheet or the Open Office spreadsheet? You need to make sure you get the correct one as they have different formulae.

powerful_rogue · 17th June 2006, 15:41

Quote:

Originally Posted by Vampiress

Are you all downloading the Excel spreadsheet or the Open Office spreadsheet? You need to make sure you get the correct one as they have different formulae.

Im downloading the excel spreadsheet and using it on open office.

For some reason the open office spreadsheet isnt working.

barracad · 17th June 2006, 18:31

The Excel template will not work with OpenOffice.

You need to download the OpenOffice template and try that again.

If that still doesn't work, have you got Micrososft Works?

As a last resort, you can go to Think Free and register on that site, then upload the Excel template and use it on Think Free - it should work on there.

blinkyblinkyblonk · 17th June 2006, 23:18

thank you vampiress and barracad for your wonderful help

i was getting the two muddled up but have now downloaded your one vampiress with the two bits of interest on
and its working wonderfully

thank you so much for your help, i appreciate it very much

i can now start proceedings on monday as now i am fully armed, well at least sorted out the interest,and have added a few more charges which have come out recently , almost £3000 with interest, blimey and thats only since last march 2005

anyway i digress

thanks again

many thanks

CAG Products - We think that these will help you to make your claim or Reclaim your Right These sales also help us to keep helping YOU and keeps this site free of third party adverts!

Small Claims Kit	Small Claims Court Guide	CallBurner - Skype CallRecorder Review	Last Will & Testament Kit	Fight a Motoring Ticket

Alternatively you could purchase a CAG email address here, or maybe you'd prefer our address labels here.
UPDATE: Consumer Forums ConsumerWiki is now LIVE - click here: ConsumerWiki N.B. Please note - due to postage costs these products are only available in the U.K.