Estimating Cable Length on a Reel

Question

I have been searching all areas of the internet to try and find a reliable formula for estimating cable length on a reel,

I'm trying to create a faster and more reliable way to estimate cable to enhance the speed of our Stock Take.

So far I have found one formula that makes sense to an extent but falls short on the layers calculation (step 6-8) this can be found here: http://www.ehow.co.uk/how_7464814_estimate-cable-reel.html

The reel sizes and cable diameter change per reel.

I used the guide above to measure a single wrap around of cat 5e, 4 layers thick and the results were out by at least 200mm, (77% inaccuracy)

Here are the measurements i recorded;

Center of the reel diameter : 57.5mm
Cable diameter : 4.3mm
Width of the Reel : 4.3mm (single layer of the cat 5e),
Flange Used : 17.2mm

Total Length : 756mm - Using the formula below

Start of Edit
Formula for working out the 4 layers is:
Using the Example Above
Layer 1 = (4.3*2)3.14
Layer 2 = (4.3*2+4.3)3.14
Layer 3 = (4.3*2+4.3+4.3*2)3.14
Layer 4 = (4.3*2+4.3+4.3*3)3.14

Can anyone see where i am going wrong?

I Manually counted the length and it was 980mm

End Of Edit

I noticed a trend in the increase of length per layer which was 30mm, is this relevant to factor in at any point in the guide?

I am by no means a Math Professional, so my mind is slightly boggled!

Any help at all would be appreciated.

Thank you

Answer 1

1. Weigh the reel.
2. Weigh or estimate the weight of an empty reel (may be negligible).
3. Weigh a metre of cable.

$$Cable \space length = {[1] - [2] \over [3]}$$

Not mathematics.