Its okay i've set up similar spreadsheets at work for analysing lots of data so it shouldn't be too much trouble, it's really just a case of categorising the data and converting Dollars (US or AUS) to UK Pounds or vice versa.
I'll have a go and see what I can come up with.