Department of Energy Argonne National Laboratory Office of Science NEWTON's Homepage NEWTON's Homepage
NEWTON, Ask A Scientist!
NEWTON Home Page NEWTON Teachers Visit Our Archives Ask A Question How To Ask A Question Question of the Week Our Expert Scientists Volunteer at NEWTON! Frequently Asked Questions Referencing NEWTON About NEWTON About Ask A Scientist Education At Argonne Calculating Length of Spiral
Name: charles c dorsey
Status: N/A
Age: N/A
Location: N/A
Country: N/A
Date: N/A 

I have a problem where I need to calculate the length a roll of tape without unwinding the tape. I know the diameter and thickness of the tape. The tape is wound on a core. I know the diameter of the core. Given that information, how do I calculate the length of the tape? I need a formula that I could plug into an Excel or Lotus spreadsheet. Thank you.

A reasonably simple formula is L = pi*N*(D+d)/2 where N = (D-d)/(2*t) is the number of wraps of tape of thickness t on a roll of diameter D (when full) around a core of diameter d. The formula represents the average of two estimates using the sum of circumferences of concentric circles (inside vs. outside diameters based on t). The summation formula 1+2+3+...+N = N*(N+1)/2 is needed to develop each estimate.


Click here to return to the Mathematics Archives

NEWTON is an electronic community for Science, Math, and Computer Science K-12 Educators, sponsored and operated by Argonne National Laboratory's Educational Programs, Andrew Skipor, Ph.D., Head of Educational Programs.

For assistance with NEWTON contact a System Operator (, or at Argonne's Educational Programs

Educational Programs
Building 360
9700 S. Cass Ave.
Argonne, Illinois
60439-4845, USA
Update: June 2012
Weclome To Newton

Argonne National Laboratory