Great Lakes Fisherman
 

Forums Gallery Web Cams Nautical Charts Wind Forecast Marine Forecast Water Temps Satellite Chat Room ADVERTISE
Go Back   Great Lakes Fisherman > Great Lakes Fishing > Salmon Pro's Connection
 [Register]

Salmon Pro's Connection Ask your Salmon fishing questions here. There are lots of professional and seasoned fisherman that are willing to help.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-30-2010, 05:22 PM
GLF's Avatar
GLF GLF is offline
Administrator
 
Join Date: Dec 2005
Location: Otsego, Michigan
Posts: 9,626
Real Name: Mike
Thanks: 832
Thanked 1,218 Times in 867 Posts
Images: 774
Send a message via MSN to GLF Send a message via Yahoo to GLF
Lightbulb Reel Fill Calculator

Ever wonder how much backing you can put on your reel along with your lead core or copper?

This is an excel spread sheet that will calculate how much of the various lines will fit on your reel. It was created by Eric Lang who goes by the username Arbogaster here. You have to have excel in order to use it.

There are directions on how to use this on the spread sheet, and I am going to walk you through it also.

Step one
The first thing you need to do is to is to enter the line capacity for you reel in the Advertised Reel Data box. It is important that you use the Big Game dimensions for this first box. I have a reel in front of me that says it will hold 430 yds of 25lb line. In the line spec table it shows berk. big game 25 = 0.019.

In the Line Capacity in Yds box I am going to enter 430.
In the Diameter of line in inches box I am going to enter 0.019.

This shows the Calculated Reel Volume Capacity = 4.389 Cubic Inches.

Step two
Enter the diameters of the lines you wish to use on your reel in the Proposed Line Data box. I am going to use 30lb power pro for backing, 27lb lead core, and a 20lb leader.

Enter the diameters in the boxes.
Backing 0.011
Core 0.032
Leader 0.018

Step three
Enter the length of the propsed lines you wish to place on the reel. I am going to use 300 yds of backing, 100 yds or core, and 25 yds of leader.

Enter these lengths in the boxes.
Backing 300
Core 100
Leader 25

This shows the reel is 94.6% full.

Play around with different line combinations and see what you come up with.
Attached Files
File Type: zip reel_fill_calculator.zip (7.9 KB, 396 views)
__________________
Is it spring yet?
Reply With Quote
The Following 45 Users Say Thank You to GLF For This Useful Post:
anonymous (01-31-2010), bigfish101 (08-09-2012), Blaze (02-19-2012), Boblo (05-15-2011), CAC (09-08-2011), DarkBlue (03-18-2011), Dave.C (08-24-2012), DIRTY DOG (01-31-2010), Eliminator (11-24-2010), FishinRich (03-25-2011), Fishin_Freak (05-27-2011), Flyboy (03-20-2011), flyman013 (01-30-2010), Gander Club (09-01-2011), Grant Sadler (04-05-2011), HizzOBizzO07 (09-09-2012), Hotdog71 (01-30-2010), j1musser (03-22-2011), jbuesing (05-22-2012), jimcr (04-05-2011), joelsanders (01-31-2010), jonmarvin (08-04-2011), Kara_B_N (01-30-2010), KJ pluggin (01-30-2010), knotatwork (02-10-2012), Line Dancin (02-01-2010), medic (03-21-2012), MichaelAngelo (01-17-2013), Midway97 (01-30-2010), Mushy's Dad (08-11-2011), niagaramusky (01-22-2014), Paulywood (01-31-2010), Poles293 (03-08-2013), Priority1 (01-30-2010), propman (04-02-2011), Rayman96 (01-30-2010), Reel Screwd (01-03-2012), Side JOB (03-20-2011), sjk984 (02-28-2010), Smells Like...Fish! (03-05-2011), Special K (02-10-2012), ted williamson (03-21-2010), tunglnguyen (03-17-2013), TXRH Wausau (03-21-2011), wingnut (04-04-2011)
Sponsored Links
Advertisement
 
  #2  
Old 01-30-2010, 07:24 PM
Rayman96 Rayman96 is offline
Advanced Fisherman
 
Join Date: Jul 2007
Location: Lake Erie, Ontario
Posts: 434
Real Name: Richard
Thanks: 61
Thanked 83 Times in 67 Posts
Thumbs up Reel Fill Calculator

....This a very useful application to have.

....I've seen this somewhere before and will add it when I can, as the other version did not require excel, if memory serves me correctly.

....This helps especially when you only have one reel of a certain make and size!
Reply With Quote
  #3  
Old 01-30-2010, 09:28 PM
arbogaster arbogaster is offline
Fisherman
 
Join Date: Apr 2007
Location: Dillsboro IN, (about 1 hour west of Cincy)
Posts: 35
Real Name: Eric Lang
Thanks: 0
Thanked 18 Times in 11 Posts
Enjoy guys

I've tested this on a couple of reels guys and it works really well. It's nice to be able to look at your options and not have to guess what will fit. Ohh and Mike . . . The last name is Lang. But most of the guys who know me as arbogaster know that. Have a great weekend guys. Stay warm
Reply With Quote
The Following 7 Users Say Thank You to arbogaster For This Useful Post:
danthebuilder (08-09-2011), DIRTY DOG (01-31-2010), Fishwhisperer (01-31-2010), Legacy (02-18-2010), Nailer (01-31-2010), Paulywood (01-31-2010), Priority1 (01-30-2010)
  #4  
Old 01-30-2010, 09:43 PM
GLF's Avatar
GLF GLF is offline
Administrator
 
Join Date: Dec 2005
Location: Otsego, Michigan
Posts: 9,626
Real Name: Mike
Thanks: 832
Thanked 1,218 Times in 867 Posts
Images: 774
Send a message via MSN to GLF Send a message via Yahoo to GLF
Quote:
Originally Posted by arbogaster View Post
I've tested this on a couple of reels guys and it works really well. It's nice to be able to look at your options and not have to guess what will fit. Ohh and Mike . . . The last name is Lang. But most of the guys who know me as arbogaster know that. Have a great weekend guys. Stay warm
Sorry about the mis spelling of your last name. My sons teacher's last name is Lane, and I no brained it. I corrected it in the first post.

Thanks for putting this together for everyone!
__________________
Is it spring yet?
Reply With Quote
  #5  
Old 01-30-2010, 11:10 PM
KJ pluggin's Avatar
KJ pluggin KJ pluggin is offline
Moderator
 
Join Date: Sep 2008
Location: Weston, WI
Posts: 1,613
Real Name: Kyle
Thanks: 135
Thanked 350 Times in 335 Posts
Images: 79
Very helpful tool thanks. I did get hung up for a while when I was doing calcs for a 300 copper. I kept putting in 300 for the copper instead of 100, I forgot to make the conversion from feet to yards. I felt pretty stupid afterwords.
Reply With Quote
  #6  
Old 01-31-2010, 08:52 AM
arbogaster arbogaster is offline
Fisherman
 
Join Date: Apr 2007
Location: Dillsboro IN, (about 1 hour west of Cincy)
Posts: 35
Real Name: Eric Lang
Thanks: 0
Thanked 18 Times in 11 Posts
Units . . . . . Units . . . . .Units

Yeah you gotta watch the yards / feet thing, I did that very thing once calculating copper and I wrote the darn spreadsheet. It should become second nature once you use it a few times. I tried to make it as simple as possible. Enjoy it guys and let me know if you have any questions. Mike was gracious enough to put it up here for all to use. Hope it keeps the cabin fever away for a few more months.
Reply With Quote
The Following User Says Thank You to arbogaster For This Useful Post:
Line Dancin (03-04-2010)
  #7  
Old 01-31-2010, 09:26 AM
GLF's Avatar
GLF GLF is offline
Administrator
 
Join Date: Dec 2005
Location: Otsego, Michigan
Posts: 9,626
Real Name: Mike
Thanks: 832
Thanked 1,218 Times in 867 Posts
Images: 774
Send a message via MSN to GLF Send a message via Yahoo to GLF
Quote:
Originally Posted by arbogaster View Post
Mike was gracious enough to put it up here for all to use.
You did all the work putting it together.
__________________
Is it spring yet?
Reply With Quote
  #8  
Old 01-31-2010, 09:30 AM
Rayman96 Rayman96 is offline
Advanced Fisherman
 
Join Date: Jul 2007
Location: Lake Erie, Ontario
Posts: 434
Real Name: Richard
Thanks: 61
Thanked 83 Times in 67 Posts
Units . . . . . Units . . . . .Units

Quote:
Originally Posted by arbogaster View Post
I tried to make it as simple as possible.................Hope it keeps the cabin fever away for a few more months.
Reply With Quote
  #9  
Old 01-31-2010, 01:09 PM
anonymous anonymous is offline
Fisherman
 
Join Date: Jul 2009
Posts: 94
Real Name: Dean
Thanks: 58
Thanked 79 Times in 37 Posts
Excellent starting point information, no more guessing on how much backing will fit then tearing everythig apart and starting over, not that I have ever had to do that.
Reply With Quote
  #10  
Old 03-04-2010, 12:42 AM
Line Dancin's Avatar
Line Dancin Line Dancin is offline
Seasoned Veteran
 
Join Date: Jun 2008
Location: Jenison
Posts: 1,753
Real Name: Aaron
Thanks: 390
Thanked 566 Times in 428 Posts
Images: 62
just tried it on a couple different reels i have here with different lines and WAY COOL. i could actually squeeze a little more on and would have been able to see this before assembly and cutting. thanks
__________________
Line Dancin
Aaron
Reply With Quote




Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off





All times are GMT -5. The time now is 05:55 AM.


Powered by vBulletin®
Copyright © 2000 - 2014, Jelsoft Enterprises Ltd.