Previous in Forum: Deadbeat partners   Next in Forum: Spider's Web
Close
Close
Close
23 comments
Rate Comments: Nested
Commentator
Engineering Fields - Manufacturing Engineering - New Member United States - Member - New Member Popular Science - Cosmology - New Member

Join Date: Aug 2008
Location: Indiana / Ohio
Posts: 56

Length or material on a roll

11/17/2008 10:34 AM

We are currently, trying to account for some old inventory. It was moved from another location with no Inventory records, and we need to get in the ball park. What we need to count is a large quantity of rolls of fiberglass cloth, (various lengths of linear feet). The cloth is rolled onto 3" cores and a whole role measures in circumference 36 7/8" (including the core) and the linear length of cloth is 1150 feet. I Realize that as the circumference decreases the math will change as to how many linear feet are left on the roll, does any one know a formula or a rule of thumb that will help me get a close inventory with out re-rolling all of our partial rolls?

Thanks

__________________
Regards, and stay Positive
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Good Answers:

These comments received enough positive votes to make them "good answers".

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Guru

Join Date: Sep 2007
Location: Reno, NV (USA)
Posts: 608
Good Answers: 66
#1

Re: Length or material on a roll

11/17/2008 10:58 AM

This question comes up periodically...check this thread:

http://cr4.globalspec.com/thread/13976#comment140483

__________________
Aequam memento rebus in arduis servare mentem.
Register to Reply
Guru
Hobbies - Fishing - Old Salt Hobbies - CNC - New Member United States - US - Statue of Liberty - New Member

Join Date: Mar 2007
Location: Rosedale, Maryland USA
Posts: 5197
Good Answers: 266
#2

Re: Length or material on a roll

11/17/2008 12:01 PM

If you have a scale you could weigh it to compute the length left on the rolls.

__________________
Life is not a journey to the grave with the intention of arriving in a pretty, pristine body but rather to come sliding in sideways, all used up and exclaiming, "Wow, what a ride!"
Register to Reply
Guru
Hobbies - HAM Radio - New Member Engineering Fields - Mechanical Engineering - New Member United States - Member - New Member

Join Date: Jun 2007
Location: Kiefer OK
Posts: 1325
Good Answers: 22
#3

Re: Length or material on a roll

11/17/2008 8:56 PM

You might also want to take a look at this thread:

http://cr4.globalspec.com/thread/10628.

__________________
I wonder..... Would Schrödinger's cat play with a ball of string theory?
Register to Reply
Guru
United States - Member - I am a Yankee Doodle Boy. Engineering Fields - Manufacturing Engineering - Old School is the best school. Safety - ESD - Safety Mgr that keeps the peace Hobbies - DIY Welding - My Motto:

Join Date: Jan 2007
Location: Broken Arrow, OK, USA
Posts: 838
Good Answers: 26
#8
In reply to #3

Re: Length or material on a roll

11/18/2008 8:03 AM

I have made a spread sheet that allows you to input numbers into it and it will give you your lengths based on the calculations the were derived from the discussion you mentioned.

I find it gets very close to the actual length of the rolls we use here. I can e-mail it to you if you like.

__________________
If necessity is the mother of invention then is laziness the mother of necessity?
Register to Reply
Guru

Join Date: Dec 2006
Location: Hop around Toronto, New York & Karachi
Posts: 1876
Good Answers: 19
#9
In reply to #8

Re: Length or material on a roll

11/18/2008 9:14 AM

I don't know about him but I'd love receive it on my email: duconems@yahoo.com. thanks

__________________
I not only use all the brains that I have, but all that I can borrow. Woodrow Wilson
Register to Reply
Commentator
Engineering Fields - Manufacturing Engineering - New Member United States - Member - New Member Popular Science - Cosmology - New Member

Join Date: Aug 2008
Location: Indiana / Ohio
Posts: 56
#10
In reply to #8

Re: Length or material on a roll

11/18/2008 9:15 AM

that would be great

rwindbigler@yahoo.com

__________________
Regards, and stay Positive
Register to Reply
Guru
United States - Member - I am a Yankee Doodle Boy. Engineering Fields - Manufacturing Engineering - Old School is the best school. Safety - ESD - Safety Mgr that keeps the peace Hobbies - DIY Welding - My Motto:

Join Date: Jan 2007
Location: Broken Arrow, OK, USA
Posts: 838
Good Answers: 26
#11
In reply to #8

Re: Length or material on a roll

11/18/2008 10:27 AM

I have sent it to you both I hope it works for you.

__________________
If necessity is the mother of invention then is laziness the mother of necessity?
Register to Reply
Guru

Join Date: Oct 2007
Location: Tulare, CA
Posts: 1783
Good Answers: 35
#12
In reply to #11

Re: Length or material on a roll

11/18/2008 10:48 AM

OD + ID x #wraps x .131

We manufacture belt conveyors and also use rubber/vinyl material and this is the formula we use for calculating materials at inventory.

__________________
Why is there never enough time to do it right the first time but always enough time to do it over?
Register to Reply Score 1 for Good Answer
Guru

Join Date: Oct 2007
Location: Tulare, CA
Posts: 1783
Good Answers: 35
#15
In reply to #12

Re: Length or material on a roll

11/18/2008 12:34 PM

This formula works on any thickness of material.

We have material that is 1/32" thick to 1/2" thick.

__________________
Why is there never enough time to do it right the first time but always enough time to do it over?
Register to Reply
Guru
United States - Member - I am a Yankee Doodle Boy. Engineering Fields - Manufacturing Engineering - Old School is the best school. Safety - ESD - Safety Mgr that keeps the peace Hobbies - DIY Welding - My Motto:

Join Date: Jan 2007
Location: Broken Arrow, OK, USA
Posts: 838
Good Answers: 26
#17
In reply to #15

Re: Length or material on a roll

11/18/2008 12:46 PM

the formula you provide is a good formula if you know the # of wraps. However the count for wraps can be up in the thousands for the types of material we run. Spiral calculating formulas work well to find the number of wraps.

The spread sheet I created does both calculations and takes into account the thickness of the core as well as the material and will also calculate the number of wraps on the roll and provide you with the lineal footage.

I hope it is helpful to those that needed it and if any others would like to have it let me know. I would not have been able to get it figured out without the help from others in this forum.

__________________
If necessity is the mother of invention then is laziness the mother of necessity?
Register to Reply
Guru

Join Date: Dec 2006
Location: Hop around Toronto, New York & Karachi
Posts: 1876
Good Answers: 19
#13
In reply to #11

Re: Length or material on a roll

11/18/2008 11:56 AM

Thanks

__________________
I not only use all the brains that I have, but all that I can borrow. Woodrow Wilson
Register to Reply
Anonymous Poster
#19
In reply to #8

Re: Length or material on a roll

11/26/2008 12:14 PM

I WOULD LOVE A COPY OF YOU FORMULA FOR INVENTORY PURPOSES

Register to Reply
2
Guru

Join Date: Aug 2007
Location: Columbia City, Indiana, USA
Posts: 836
Good Answers: 96
#4

Re: Length or material on a roll

11/18/2008 1:07 AM

Yes, this topic has been posed before, but maybe I can also give you a simple way to do a fast estimate:

OD minus ID ... divide by 2 (keep this number handy) ... add to the ID. That gives you the average diameter. Multiply that by 3.14 and that will give you the circumference of the average diameter.

Measure the thickness of material on the roll, and divide the number you kept by that thickness. That will tell you how many layers or 'turns' there are on the roll.

Multiply the turns by the average circumference and you have an estimate of the length of material on the roll.

Example: 6-inch OD, 3-inch ID, and the material measures 0.010 inches thick.

6 minus 3 = 3. Divided by 2 = 1.5. Plus 3 = 4.5. Multiply by 3.14 = 14.13 inches.

1.5 divided by 0.010 = 150 layers or 'turns'.

150 turns times 14.13 inches = 2120 inches per roll.

Just an estimate because in the winding process there may be compression of the material, or loose 'turns', or varying thicknesses of materials. BUT, it's close.

Kind regards ...

__________________
"Just when I had all the answers, they changed all the questions"
Register to Reply Good Answer (Score 2)
Power-User
Hobbies - Musician - New Member Engineering Fields - Manufacturing Engineering - New Member

Join Date: Sep 2007
Location: Endless Mountains of NE Pa, USA
Posts: 298
Good Answers: 20
#5

Re: Length or material on a roll

11/18/2008 1:18 AM

Yes...the length of an archimede's spiral.

L= length

r0= radius of outside roll diameter

ri= radius of core diameter

t= thickness of material

pi= 3.1416

This should get you Very close. The complete formula folllows. (1n) is a natural log. Most of the time the difference in answers between the short and long versions are of little consequence. If the material is Very thick, use the long version for better accuracy. Hope this helps you.

__________________
Courage is not the absence of fear, but the inner resolve to rise above it....or the inane lapse in judgement brought on by copious imbibitions....Egre Flagrus
Register to Reply Score 1 for Good Answer
Commentator

Join Date: Jun 2007
Posts: 62
#7
In reply to #5

Re: Length or material on a roll

11/18/2008 5:20 AM

What is very thick ?

Thank you.

__________________
Coming together is a beginning. Keeping together is progress. Working together is success. Henry Ford
Register to Reply
Power-User
Hobbies - Musician - New Member Engineering Fields - Manufacturing Engineering - New Member

Join Date: Sep 2007
Location: Endless Mountains of NE Pa, USA
Posts: 298
Good Answers: 20
#16
In reply to #7

Re: Length or material on a roll

11/18/2008 12:36 PM

Hi Sal

Sorry for delay. I should have been more precise.

The short calculation doesn't take into account that each layer has a bottom radius and a top radius. So the thicker the material the less accurate the short version becomes.

I've used both on fairly thin materials like papers and films that are wrapped tightly and at known lengths of 5000+ feet and the answers were correct within a 1 1/2 feet of the total length.

Of course, neither takes into account any air space that may exist, but they are good tools for accurate estimation.

Jeff

__________________
Courage is not the absence of fear, but the inner resolve to rise above it....or the inane lapse in judgement brought on by copious imbibitions....Egre Flagrus
Register to Reply
Power-User

Join Date: Mar 2007
Location: Devon England
Posts: 214
Good Answers: 5
#6

Re: Length or material on a roll

11/18/2008 3:14 AM

All the mathematical methods are fine if you have any real dimension for the thickness of the material on the roll. However, GRP mat and cloth does not really lay well on the roll and thus the thickness is arbitrary.

We manufacture in GRP - see www.explorermarine.co.uk - and we buy glass by weight in kg. Hence we would do the easy stock take and count the rolls and weigh each one, and deduct the weight of the empty card tube.

Good counting

HM

__________________
Hugh Mattos Chartered Engineer...... :---------: Through helping others we give purpose to our time on this earth and take pleasure from it.
Register to Reply Score 1 for Good Answer
Guru
United States - US - Statue of Liberty - New Member Hobbies - Fishing - New Member

Join Date: Nov 2007
Location: Gone to Alabama with my banjo on my knee...
Posts: 5595
Good Answers: 20
#14

Re: Length or material on a roll

11/18/2008 12:05 PM

You got several very good answers here, didn't you?!? I'd go for the "by weight" method myself, but only if you have to relocate the rolls anyway. Otherwise, the "measurements and math" methods are less effort. I'm also thinking that unless you are seeking very quantitative results, a simple diameter ratio might be ballpark-y enough. Full roll diameter/100% : partial roll diameter/x and solve for x.

Say the full roll is 36" for simplicity's sake. 36"/100% : 18"/x; then 36x = 1800, and then x = 1800/36 = 50%, or half of a roll. Most any fractional percentage can be determined by this method, and the carboard tube doesn't have to be subtracted.

__________________
Veni, vidi, video - I came, I saw, I got it on film.
Register to Reply
Commentator
Engineering Fields - Manufacturing Engineering - New Member United States - Member - New Member Popular Science - Cosmology - New Member

Join Date: Aug 2008
Location: Indiana / Ohio
Posts: 56
#18
In reply to #14

Re: Length or material on a roll

11/18/2008 1:05 PM

Because we have a good scales here and we do a lot of other work by weight, I believe we are going to use the weight method. Our rolls are not always wound as tight as we would like because they go through several process's, (but the end result is consistent in weight) so the measuring does not always seem to be a good guide. Yes I have gotten several good replies and formulas. I will save much of this information because we do use other types of rolled stock where it may come in helpful for the future. I appreciate all of the replies I have gotten you have all been great.

RW

__________________
Regards, and stay Positive
Register to Reply
Member

Join Date: Nov 2008
Posts: 5
#20

Re: Length or material on a roll

11/26/2008 2:32 PM

I used to work in the paper industry. We had the same problem. Go here and check out the math. If you know the caliper thickness of the sheet, outside diameter of the roll and the outside diameter of the core, this will work for you.

http://findarticles.com/p/articles/mi_m3116/is_/ai_n15691841

Register to Reply
Commentator
Engineering Fields - Manufacturing Engineering - New Member United States - Member - New Member Popular Science - Cosmology - New Member

Join Date: Aug 2008
Location: Indiana / Ohio
Posts: 56
#21
In reply to #20

Re: Length or material on a roll

12/01/2008 6:41 AM

Thanks that was a very helpful website.

__________________
Regards, and stay Positive
Register to Reply
Commentator

Join Date: Nov 2007
Posts: 85
Good Answers: 2
#22

Re: Length or material on a roll

12/01/2008 10:55 PM

If we imagine that the roll is unwound and laid flat on the floor,the total area at the side of the roll will be equal to length multiplied by thickness. This gives the entire area on the side.This is equal to the area of the one of the sides after rolling in the roll form.Area on the side of the roll is equl to area of the outer dia minus the area of the inner dia.Now we can equate the first part with the second.

To know the length we have to divide this area by the thickness of the sheet.The result is accurate if the rooll is wound tightly.Otherwise we shoud take the factor of bulk density also in to account.

Register to Reply
Commentator
Engineering Fields - Manufacturing Engineering - New Member United States - Member - New Member Popular Science - Cosmology - New Member

Join Date: Aug 2008
Location: Indiana / Ohio
Posts: 56
#23

Re: Length or material on a roll

03/01/2011 4:02 PM

A lot of Data na d a lot of help thanks to all>>

__________________
Regards, and stay Positive
Register to Reply
Register to Reply 23 comments

Good Answers:

These comments received enough positive votes to make them "good answers".

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

3Doug (1); Anonymous Poster (1); CSM Engineer (1); DCaD (1); double_j_b (3); ducon (2); EnviroMan (1); HughMattos (1); Janissaries (2); k.v.gopalakrishnan (1); ozzb (1); rwindbigler (4); Sal (1); snygolfgs (2); staceyroberts (1)

Previous in Forum: Deadbeat partners   Next in Forum: Spider's Web

Advertisement