CAKitty.xls Litty spread sheet/

[Lawnmower Man]

I've been asked about the spread sheet for dealing with the Kitty at LM.


It should be available at the link below.

Edit <damn it looks a bit knackered I'll see if I can find the original link.>

I have.  try http://lemans.tmdg.co.uk/Call.xls  it has some example entries that you need to clear but it should work.

t.

[Andy Zarse]

Why thank you Thomas!  Any ideas on how to make it work? I've enabled the macros but I can't seem to clear the example entries for some reason.

[Lawnmower Man]

Hi Andy,

I just tired it on my lapdog adn it seem to work fine that is http://lemans.tmdg.co.uk/Call.xls 

First on Balances  sheet.
You need to change the names in B2 though Z2.
Enter the Exchange rate in B5 though Z5.
Enter the number of shares for each person in B6 though Z6

Then on the Outgoings sheet.
You should be able to clear all of the values in the Amount Column that should zero all the numbers on the Balances sheet.

If you are running out of rows on Outgoings just copy a blank line.

Finally you columns A B C and D for each item spent.  The Balances should happen Automagically.

Tom.

[Andy Zarse]

Thanks Tom, Mr Thicko has now solved his own problem! 

[Lawnmower Man]

Well there weren't any instructions with the Spreadsheet.   So I don't think you should feel like a thicko over it.
It took me a while to work out how to drive it and I wrote it. 

Anyway catch up on the other side.

t.

[sbull9]

Well there weren't any instructions with the Spreadsheet.   So I don't think you should feel like a thicko over it.
It took me a while to work out how to drive it and I wrote it. 

Anyway catch up on the other side.

t.

Are you both accountants or just tight..

[Lawnmower Man]

Are you both accountants or just tight..

We're tight accountants.    Well I was until the Gimp go at me.

t.