Total novice fishing weight percentage calculator

Hey guys first off hey all im new here...

a little background, me and some friends are running a fishing competition this year where we try to catch all the uk native freshwater species and are awarded points based on the percentage weight against the record fish of that species.

weights are measures in lbs oz and dram (2lb 4oz 1dram)

so for example I catch a fish at 1lb 1oz 1dram and the record for that species is 2lb 2oz 2dram how would I calculate the percentage weight of the caught fish against the record in a spreadsheet/database
in this case its easy obviously 50%

16oz = 1lb
16dr = 1oz

btw im a complete novice at this so please be patient with me

I have a list of all native records if anyone can help me out id be greatly appreciative.

LoL. So much easier with SI Units (grams...). Put Lb, oz, dram in separate columns and in a 4th column calculate the weight in drams & then calculate as a percentage of the record weight.

Dohh. Itchy trigger finger - the phone rang. Is this what you want?

BTW, the sheet with the list of record weights MUST be in alphabetical order. So when you add a newone at the bottom, don't forget to resort

Cheers grant much appreciated I will let you know as soon as possible having problems installing with windows 8

Cheers grant that was awsome give me a good platform to work with

And try to add some features thanks alot

Garry

ok so now im trying to add a points system for example if the percentage comes out at 0-10% that's would mirror 1pt in the next column 11-20% 2pts and so on then at the bottom of that colum a total

ive also added a page for each member would it be possible to compile the totals into a league table?

also how do I upload attachments

cheers garry

hers the document with the fish weights and users added

Cheers Kevin

Ok so managed to get it how I wanted it heres the updated one

is it possible to total the points column and then transfer the usename of page and total points for user into a league table sorting higest points first. this would be on a separate page.

Cheers Garry

I've tarted Stuart Frew up a bit (in a manner of speaking...) to tidy up the error messages...

Cheers grant thats perfect struggling to understand the new formulas but thay doesnt matter aslong as it works
Cheers garry

cheers cofad think I understand most of it now.

the calc is working great but its easy for people to mess it up if the deleate the drams percentage or points column is there any way I can blank these out so there not editable?

Exactly which bits will you allow others to edit?

has any one got a sea fishing weight percentage calculator