Roll Length Calculator

[BenMiller]

I recently created a useful spreadsheet in Excel, and I'd love to share it with you peeps
It is a tool for determining how much material is left on a roll. Practical application would be, for example, a print shop which prints on paper/foil/film which comes on a roll, and they have used some of the roll. The spreadsheet allows you to enter the thickness of the material (in hundredths of an inch [mil]); the diameter of the core (in inches); and the outer diameter of the roll (in inches) and it will display how many feet of a material (if the entire roll were to be unrolled) are left on the roll. I have a couple of other functionalities I added but that's the basic concept.
I'm no mathematician, but I kind of made up how this would be calculated - and I found one or two websites which calculate this as well, and the numbers matched.
How would I upload this sheet for people to use? Can anyone recommend a good (free) FTP site I can do it on?

 

[shg]

box.net is simple and free of all annoyances.

 

[BenMiller]

Thanks! Here's the link.
http://www.box.com/s/os6llcjez8dmkru3ktl0

 

[BenMiller]

I made a dumbed-down version, pretty easy if anyone is interested.
http://bit.ly/z1Omsd

 

[PlasticGuy]

Thanks for this link. "Perfect" timing for inventory at my work...
Cheers

 

[Wemash77]

I recently created a useful spreadsheet in Excel, and I'd love to share it with you peeps
It is a tool for determining how much material is left on a roll. Practical application would be, for example, a print shop which prints on paper/foil/film which comes on a roll, and they have used some of the roll. The spreadsheet allows you to enter the thickness of the material (in hundredths of an inch [mil]); the diameter of the core (in inches); and the outer diameter of the roll (in inches) and it will display how many feet of a material (if the entire roll were to be unrolled) are left on the roll. I have a couple of other functionalities I added but that's the basic concept.
I'm no mathematician, but I kind of made up how this would be calculated - and I found one or two websites which calculate this as well, and the numbers matched.
How would I upload this sheet for people to use? Can anyone recommend a good (free) FTP site I can do it on?

is there a way I can get a copy of this? i clicked on the links but I believe they are too old? Will not pull anything up?

 

[AhoyNC]

Maybe this will be of help.
Note that as in any manufacturing process the caliper will vary to some degree in the roll, so the footage left on the roll will be an approximation.
Enter the known data in the green cells (B3:B4).

Paper roll length.xlsx
	A	B	C
1			Unit
2	Outer Diameter	60	Inch
3	Outer Diameter of Core	4	Inch
4	Caliper	0.014	Inch
5
6
7	Linear Inches	201061.9	Inch
8	Linear Feet	16755.16	Feet
9
Sheet2

Cell Formulas
Range	Formula
B7	B7	=(PI()*((B2/2)^2-(B3/2)^2))/B4
B8	B8	=B7/12

 

[BenMiller]

is there a way I can get a copy of this? i clicked on the links but I believe they are too old? Will not pull anything up?

Sorry, I do not have the original files any more so I cannot repost