Calculating Remaining Edgebanding
OD = Outside Diameter
(OD – ID /2) + ID = CC
OD = 457mm
457-127 /2 = 165 + 127 = 292
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)
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?