texasfishingforum.com logo
Main Menu
Advertisement
Affiliates
Advertisement
Newest Members
TraeMartin, Power-Pole CS, T-Rigger, JoeGoes, EcKo
119150 Registered Users
Top Posters(All Time)
hopalong 120,565
TexDawg 119,510
Bigbob_FTW 94,875
John175☮ 85,892
Pilothawk 83,259
Bob Davis 81,465
Mark Perry 72,280
Derek 🐝 68,311
JDavis7873 67,416
Forum Statistics
Forums59
Topics1,037,798
Posts13,934,681
Members144,150
Most Online39,925
Dec 30th, 2023
Print Thread
BASS CLUB STANDING'S #10446410 12/01/14 04:19 PM
Joined: Jan 2012
Posts: 1,520
6BOOMER Offline OP
Extreme Angler
OP Offline
Extreme Angler
Joined: Jan 2012
Posts: 1,520
Taking over Tournament Chairman for our Bass Club and I'm having a problem with the excel spreadsheet for the conversion to lbs and ounces it adds up whole numbers and tenth's but doesn't convert them. I'm no wiz at excel for sure. Does any clubs have an example for a 12 month period? Any assistance would be appreciated.

Re: BASS CLUB STANDING'S [Re: 6BOOMER] #10447351 12/01/14 11:37 PM
Joined: Mar 2010
Posts: 1,488
R
Randy Harrell Offline
Extreme Angler
Offline
Extreme Angler
R
Joined: Mar 2010
Posts: 1,488
I don't have a sheet that does pounds and ounces, but I can help you with the formula that will tally them for you correctly. You would think with the infinite wisdom of Microsoft, they could figure out how to make it an easy function. LOL


Set the hook first, ask questions later!!!
Re: BASS CLUB STANDING'S [Re: 6BOOMER] #10447869 12/02/14 03:59 AM
Joined: Jun 2010
Posts: 5,753
David Welcher Offline
TFF Celebrity
Offline
TFF Celebrity
Joined: Jun 2010
Posts: 5,753
Your easiest method is for you to convert it. You can't mix lbs and ounces. A 4llb 6 ounce bass is 4 x 16 =64 ounces plus 6 ounces=70 ounces , now divide that by 16 ounces and that comes to 4.375 lbs, not sure how you could build a spread sheet with one input column. You would have to create two inputs for each person one column for lbs one column for ounces , do the conversion for lbs to ounces ,add the two ,and then divide by 16

Re: BASS CLUB STANDING'S [Re: 6BOOMER] #10447875 12/02/14 04:03 AM
Joined: Jun 2010
Posts: 5,753
David Welcher Offline
TFF Celebrity
Offline
TFF Celebrity
Joined: Jun 2010
Posts: 5,753
try Katelyn in the off topic section

Re: BASS CLUB STANDING'S [Re: 6BOOMER] #10448114 12/02/14 01:17 PM
Joined: Jan 2012
Posts: 1,520
6BOOMER Offline OP
Extreme Angler
OP Offline
Extreme Angler
Joined: Jan 2012
Posts: 1,520
Thanks guys that math is way over me. The spreadsheet tally's up but I don't think it's correct since it's going to the whole number. (ie 1.80 plus 1.20 adds up to 3.0 but actually its not correct).

Re: BASS CLUB STANDING'S [Re: 6BOOMER] #10448134 12/02/14 01:37 PM
Joined: Jun 2004
Posts: 4,091
Ranger Z21 Offline
TFF Team Angler
Offline
TFF Team Angler
Joined: Jun 2004
Posts: 4,091
Invest in tournament keeper software for your club. It calculates everything for you. I have used it for our club for seven years and it's a breeze to use. Google it and you can download load from the Internet. I believe it's around 99.00. Well worth it.

Re: BASS CLUB STANDING'S [Re: 6BOOMER] #10448252 12/02/14 02:48 PM
Joined: Jan 2012
Posts: 1,520
6BOOMER Offline OP
Extreme Angler
OP Offline
Extreme Angler
Joined: Jan 2012
Posts: 1,520
I'll check this out. Thanks

Re: BASS CLUB STANDING'S [Re: 6BOOMER] #10448733 12/02/14 07:03 PM
Joined: Jan 2012
Posts: 1,520
6BOOMER Offline OP
Extreme Angler
OP Offline
Extreme Angler
Joined: Jan 2012
Posts: 1,520
A special Thanks to Randy Harrell for his knowledge and assistance.

Re: BASS CLUB STANDING'S [Re: 6BOOMER] #10478786 12/17/14 02:54 PM
Joined: Feb 2014
Posts: 197
Randy Parks Offline
Outdoorsman
Offline
Outdoorsman
Joined: Feb 2014
Posts: 197
If you would PM me I would be able to update some formulas to help you. You could send me a copy of the excel file and I would quickly update the formulas to get what you need. No charge of course. I do stuff like this for fun.

Previous Thread
Index
Next Thread

© 1998-2022 OUTDOOR SITES NETWORK all rights reserved USA and Worldwide
Powered by UBB.threads™ PHP Forum Software 7.7.3