Jump to content
GLF

Reel Fill Calculator

Recommended Posts

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.

reel_fill_calculator.zip

  • Like 1

Share this post


Link to post
Share on other sites

....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. :rolleyes:

....This helps especially when you only have one reel of a certain make and size! ;)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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. :o I corrected it in the first post.

Thanks for putting this together for everyone! :thumb:

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
Mike was gracious enough to put it up here for all to use.

You did all the work putting it together.

Share this post


Link to post
Share on other sites
I tried to make it as simple as possible.................Hope it keeps the cabin fever away for a few more months.
:no::lol:

Share this post


Link to post
Share on other sites

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.;)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Hi fellas, first off, great spreadsheet! I've been using this for awhile now. However, it hasn't worked for me the last couple days. It opens up but I am unable to put any calculations in. Is anyone else having this problem or is it user error (me)?

Share this post


Link to post
Share on other sites

I just tried it and did not have a problem. Do you have it saved to your computer? If you don't give that a try.

Share this post


Link to post
Share on other sites

Ok, thanks for the response KJ. Figured it was user error. I'll try again later when I get home.

Share this post


Link to post
Share on other sites

arbogaster, Thanks very much for putting this together. I used it to put together a couple of copper reels. In my case, I think it over estimated the amount of line slightly. I was only able to fit about 90% capacity. Maybe because of the larger diameter of the copper throws it off a bit? Could also be the line counter I used - a Shakespeare that I never bothered to calibrate.

Also, it works fine with OpenOffice/LibreOffice and Google Docs. -- Bud

Share this post


Link to post
Share on other sites

Yeah it is not an exact science but it will usually get you pretty close. One thing you cannot do is use the line counter to measure the feet of line as you put it on. When the spool is less than full the line counter measure is off. This isn't a problem when the spool is most of the way full but when you are first filling it; the count is way off. I either use line lengths in my recipe that I can buy i.e. 300 yds of power pro or 150 yds of power pro, or I'll drag the line out in my back yard and unspool it in the grass and measure out the length i need.

I'm glad it has caught on and you guys are getting some use out of it. I put some time in developing and testing it. Glad to see it has worked well for most everyone.

Think Spring guys!

Share this post


Link to post
Share on other sites

Eric,

Just wanted to thank you for developing and sharing this with us! Extremely usefull tool.

Matt

Share this post


Link to post
Share on other sites

I's been a while but I thought I would check in on you guys. Glad to see people are getting some use out of the spreadsheet. I'll be up fishing this weekend Sept 9-12 hope to see some of you out there. Give Arbogaster a call on 68

Share this post


Link to post
Share on other sites

Hey everyone, we have updated our Reel Fill charts for all of our coppers (32lb, 45lb, 60lb) and our Copper Backing Line. We made a few changes on previous numbers to make them more accurate, as well as adding reel fill data for the Daiwa Seagates and Penn Squalls. These figures should get you real close when spooling up. Figure on 30' of leader..

We will be doing performance reviews for both of those reels in the coming weeks and will post results.

http://www.bloodruntackle.com/wp-content/uploads/2013/05/CopperDiveChart.pdf

http://www.bloodruntackle.com/wp-content/uploads/2013/06/BloodRunWalleyeCopperDiveChartDepthCurve.pdf

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×