Help please, Trout returns in an excel spread shee.t

Bob M wrote in message ...
Greetings.
Any of you gents out there secs who have to do trout returns, I have an
excel
spread sheet that I use to tally up returns for over 300 members, problem
is my
formulas do not work, I may have deleted something.............stupid boy.
Unfortunately I am useless at setting up spreadsheets and need help with
the
one I used in previous seasons.


On Wed, 9 Feb 2005 at 13:22:32 in uk.rec.fishing.game George Houston
wrote:
Not a sec, but work with Excel quite a lot. If you'd like to email me, I'll
take a look.


Ditto. I use Excel a lot. I put a spreadsheet together for this sort
of thing some time ago. I remember grappling with conversions from
kilos to pounds and ounces etc. Also sorting the list various ways.

Email me a copy and I'll look at it.

--
Nogood Boyo

In article , Nogood Boyo
writes
I remember grappling with conversions from kilos to pounds and ounces
etc. Also sorting the list various ways.

I convert from lbs + ozs to kilos for TDFA - simple "off the sheet"
formula and a couple of columns.

I must teach you how to do it some time :-) :-) :-) :-)
--
Bill Grey
http://www.billboy.co.uk

On Sun, 13 Feb 2005 at 22:36:36 in uk.rec.fishing.game W. D. Grey wrote:
In article , Nogood Boyo
writes
I remember grappling with conversions from kilos to pounds and ounces
etc. Also sorting the list various ways.

I convert from lbs + ozs to kilos for TDFA - simple "off the sheet"
formula and a couple of columns.

I must teach you how to do it some time :-) :-) :-) :-)

Yes dear... :-)
--
Nogood Boyo

In article , Nogood Boyo
writes
On Sun, 13 Feb 2005 at 22:36:36 in uk.rec.fishing.game W. D. Grey wrote:
In article , Nogood Boyo
writes
I remember grappling with conversions from kilos to pounds and ounces
etc. Also sorting the list various ways.

I convert from lbs + ozs to kilos for TDFA - simple "off the sheet"
formula and a couple of columns.

I must teach you how to do it some time :-) :-) :-) :-)

Yes dear... :-)

Game, set and match ;-)
--
Bill Grey
http://www.billboy.co.uk

Where cell A1 contains a numeric value in kg, for the stones part use:
In one cell
=INT(CONVERT(A1,"kg","lbm")/14)


for the remainder in pounds:
in another cell

=MOD(CONVERT(A1,"kg","lbm"),14)

oops...wrong one....thats stones and pounds.

Check this formula for converting Kilograms to Pounds and Ounces; be sure
you have been to Tools, Add-Ins and checked Analysis Toolpak.

=INT(CONVERT(A2,"kg","lbm"))&" lbs " &INT( MOD(CONVERT(A2,"kg","ozm"),16))&
" oz"http://www.barasch.com/excel/xlFormulas.htm