1
1fishy
I am trying to build a spreadsheet to total five separate fish weighe
in pounds and ounces. I need a column for the name of the fisherman
1st fish, 2nd fish, 3rd fish, 4th fish, 5th fish (each in pounds an
ounces), and a total column in pounds and ounces.
I would also like to designate a point value by the most weight t
least, (160pts 1st, 150pts 2nd ... 10 pts 16th place). I also need
column to denote a 2 oz penalty for each dead fish, that would then b
subtracted from the total. I also will need to be able to total betwee
two sheets, so I can show totals for a two day tournament where the 1s
and 2nd day and combined totals are on the same sheet. In this case th
point designation would not have to be figured for the 1st day, onl
for the two day total.
I have been pulling my hair out on this one! I am by no mean
experienced with Excel but I'm not lame either. Please don't assume
know anything though. I have been to the Microsoft site and downloade
the necessary addins. I have the formula for converting ozm > lbm
(=INT(CONVERT(C7,"ozm","lbm"))&" lbs " &INT
MOD(CONVERT(C7,"ozm","ozm"),16))& " oz") but am not sure how to ad
these up properly. Any help will be greatly appreciated!!! Thanks i
advanc
in pounds and ounces. I need a column for the name of the fisherman
1st fish, 2nd fish, 3rd fish, 4th fish, 5th fish (each in pounds an
ounces), and a total column in pounds and ounces.
I would also like to designate a point value by the most weight t
least, (160pts 1st, 150pts 2nd ... 10 pts 16th place). I also need
column to denote a 2 oz penalty for each dead fish, that would then b
subtracted from the total. I also will need to be able to total betwee
two sheets, so I can show totals for a two day tournament where the 1s
and 2nd day and combined totals are on the same sheet. In this case th
point designation would not have to be figured for the 1st day, onl
for the two day total.
I have been pulling my hair out on this one! I am by no mean
experienced with Excel but I'm not lame either. Please don't assume
know anything though. I have been to the Microsoft site and downloade
the necessary addins. I have the formula for converting ozm > lbm
(=INT(CONVERT(C7,"ozm","lbm"))&" lbs " &INT
MOD(CONVERT(C7,"ozm","ozm"),16))& " oz") but am not sure how to ad
these up properly. Any help will be greatly appreciated!!! Thanks i
advanc