Tough one. Rolled material formula.

[craigwojo9]

I need a simple input spreadsheet for figuring material remaining on a roll.

Three inputs needed and one formula created.
Outside Diameter of Rolled Material
Thickness of Material
Diameter of Center Hole
Formula output - Length of Material

I just need the formula figured... do not know where to start.

Here is a link to the calculator I need created.

Cut Smart : LENGTH ON ROLL CALCULATOR

Thank you so much and God bless,
Craig

 

[MickG]

Maybe a starting point Length of material on roll , Appears quite close to "Calculator"

Function Lgh(MaxD As Double, MinD As Double, Th As Double) As Double
Dim L As Double, D As Double
D = MinD
 Do Until D >= MaxD
  L = L + D * Application.Pi
  D = D + 2 * Th
 Loop
Lgh = (L - Application.Pi * MinD) / 1000 'Divide by 12 for Feet
End Function

 

[AhoyNC]

The basic formula is:

Pi x ((Ouside Radius^2) – (Core Radius^2)) / Caliper = Linear Inches

The .06545 in the shorter formula in Pi divided by 48, which is a constant to change the LI to LF.

Note that the formula assumes the caliper remains constant (usually not the case in a manufacturing process) and there is a tight wrap around the core.

Excel Workbook
	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
10	Shorter formula for LF	16755.2	Feet
11
Sheet

 

[craigwojo9]

Thank you so much.

God bless.

Craig

 

[Mike_JC]

The basic formula is:

Pi x ((Ouside Radius^2) – (Core Radius^2)) / Caliper = Linear Inches

The .06545 in the shorter formula in Pi divided by 48, which is a constant to change the LI to LF.

Note that the formula assumes the caliper remains constant (usually not the case in a manufacturing process) and there is a tight wrap around the core.

Excel Workbook
	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
10	Shorter formula for LF	16755.2	Feet
11
Sheet

Thank you! ?