Calculating Remaining Edgebanding

      Formula to determine how much is left on the roll, with a nod to Archimedes. March 14, 2004

Is there a simple chart that I can reference to see how many feet of typical .018 edgebanding is remaining on a roll?

Forum Responses
(Cabinetmaking Forum)
From contributor K:
Formula for calculating lineal footage of edgebanding on a coil roll:

OD = Outside Diameter
ID= Inside Diameter
#L = # of Layers in Coil
BT = Banding Thickness
CC= Center Coil Layer circumference
CD = Center Coil Layer Diameter
LM= Lineal mm of Banding
LF = Lineal Feet of Banding

(OD – ID /2) + ID = CC
CC * BT * PI (3.14) = CD
(OD – ID) * BT = #L
CD *#L = LM
LM / 304.8 = LF


OD = 457mm
ID = 127mm
BT = .5mm

457-127 /2 = 165 + 127 = 292
292 * .5 = 146 * 3.14 = 458
(457 – 127 = 330) * .5 = 165
458 * 165 = 75570
75570 / 304.8 = 248 LF of Banding

I have this formula as an Excel spreadsheet at the office that will take both English and metric dimensions. I'll post it on the net with a link to download of others are interested.

From contributor D:
I think I've got an easier way. Pace off the block your home is on. Hire next door neighbor's kid - give him end of roll and send him off running... wherever he hits pavement when end of roll jerks him silly...

My formula: B-K(D)


Just kidding…

From contributor K:
Now if you can just get the kid to roll the banding back up! We use lots of custom colors to match laminates and sometimes we have a small roll on the shelf that might just be enough to keep us from having to order an additional roll, so I made the little spreadsheet to help us out. It only takes a second to fill out and you have a pretty good idea (usually within one coil layer) of the LF of banding.

The formula actually goes back to Archimedes as he calculated the spiral:

Spiral Length - N 2pi(ri+d N /2) = N 2pi(ri+Rw /2)

ri is the inner radius at the start of the spiral, N is the number of revolutions of the spiral and d is the distance between the spiral. Without being able to insert the pi symbol as well as using subset text it makes the formula much harder to read. I interpreted it for the original formula and our calculator to make the variables relevant to our usage.

Would you like to add information to this article?
Interested in writing or submitting an article?
Have a question about this article?

Have you reviewed the related Knowledge Base areas below?
  • KnowledgeBase: Business

  • KnowledgeBase: Business: Plant Management

  • KnowledgeBase: Cabinetmaking

  • KnowledgeBase: Cabinetmaking: General

  • KnowledgeBase: Laminates and Solid Surfacing

  • KnowledgeBase: Woodworking Miscellaneous

  • KnowledgeBase: Woodworking Miscellaneous: Woodworking

    Would you like to add information to this article? ... Click Here

    If you have a question regarding a Knowledge Base article, your best chance at uncovering an answer is to search the entire Knowledge Base for related articles or to post your question at the appropriate WOODWEB Forum. Before posting your message, be sure to
    review our Forum Guidelines.

    Questions entered in the Knowledge Base Article comment form will not generate responses! A list of WOODWEB Forums can be found at WOODWEB's Site Map.

    When you post your question at the Forum, be sure to include references to the Knowledge Base article that inspired your question. The more information you provide with your question, the better your chances are of receiving responses.

    Return to beginning of article.

    Refer a Friend || Read This Important Information || Site Map || Privacy Policy || Site User Agreement

    Letters, questions or comments? E-Mail us and let us know what you think. Be sure to review our Frequently Asked Questions page.

    Contact us to discuss advertising or to report problems with this site.

    To report a problem, send an e-mail to our Webmaster

    Copyright © 1996-2019 - WOODWEB ® Inc.
    All rights reserved. No part of this publication may be reproduced in any manner without permission of the Editor.
    Review WOODWEB's Copyright Policy.

    The editors, writers, and staff at WOODWEB try to promote safe practices. What is safe for one woodworker under certain conditions may not be safe for others in different circumstances. Readers should undertake the use of materials and methods discussed at WOODWEB after considerate evaluation, and at their own risk.

    WOODWEB, Inc.
    335 Bedell Road
    Montrose, PA 18801

    Contact WOODWEB

  • WOODWEB - the leading resource for professional woodworkers

      Home » Knowledge Base » Knowledge Base Article