Estimating Cable Length on a Reel
$begingroup$
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
estimation
asked Nov 25 '15 at 11:27
MatthewMatthew
13
$endgroup$
add a comment |
$begingroup$
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
estimation
asked Nov 25 '15 at 11:27
MatthewMatthew
13
$endgroup$
$begingroup$
anyone have any idea on a standard formula for calculating cable length on a drum/reel?
$endgroup$
– Matthew
Dec 8 '15 at 9:51
$begingroup$
I'm voting to close this question because it's old; I suspect the OP no longer needs an answer.
$endgroup$
– Ethan Bolker
Oct 15 '18 at 14:11
add a comment |
$begingroup$
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
estimation
asked Nov 25 '15 at 11:27
MatthewMatthew
13
$endgroup$
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
estimation
estimation
asked Nov 25 '15 at 11:27
MatthewMatthew
13
asked Nov 25 '15 at 11:27
MatthewMatthew
13
edited Dec 7 '15 at 12:04
Matthew
asked Nov 25 '15 at 11:27
MatthewMatthew
13
asked Nov 25 '15 at 11:27
MatthewMatthew
13
asked Nov 25 '15 at 11:27
MatthewMatthew
13
13
$begingroup$
anyone have any idea on a standard formula for calculating cable length on a drum/reel?
$endgroup$
– Matthew
Dec 8 '15 at 9:51
$begingroup$
I'm voting to close this question because it's old; I suspect the OP no longer needs an answer.
$endgroup$
– Ethan Bolker
Oct 15 '18 at 14:11
add a comment |
$begingroup$
anyone have any idea on a standard formula for calculating cable length on a drum/reel?
$endgroup$
– Matthew
Dec 8 '15 at 9:51
$begingroup$
I'm voting to close this question because it's old; I suspect the OP no longer needs an answer.
$endgroup$
– Ethan Bolker
Oct 15 '18 at 14:11
$begingroup$
anyone have any idea on a standard formula for calculating cable length on a drum/reel?
$endgroup$
– Matthew
Dec 8 '15 at 9:51
$begingroup$
anyone have any idea on a standard formula for calculating cable length on a drum/reel?
$endgroup$
– Matthew
Dec 8 '15 at 9:51
$begingroup$
I'm voting to close this question because it's old; I suspect the OP no longer needs an answer.
$endgroup$
– Ethan Bolker
Oct 15 '18 at 14:11
$begingroup$
I'm voting to close this question because it's old; I suspect the OP no longer needs an answer.
$endgroup$
– Ethan Bolker
Oct 15 '18 at 14:11
add a comment |
1 Answer
1
active
oldest
votes
$begingroup$
- Weigh the reel.
- Weigh or estimate the weight of an empty reel (may be negligible).
- Weigh a metre of cable.
$$Cable space length = {[1] - [2] over [3]}$$
Not mathematics.
answered Nov 25 '15 at 14:04
ThumbnailThumbnail
535211
$endgroup$
$begingroup$
Hi, Thanks for suggestion, however weighing the cable is not really ideal for the given situation, surely there is a calculation that can estimate cable length given various measurements?
$endgroup$
– Matthew
Nov 25 '15 at 14:46
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "69"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f1545701%2festimating-cable-length-on-a-reel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
$begingroup$
- Weigh the reel.
- Weigh or estimate the weight of an empty reel (may be negligible).
- Weigh a metre of cable.
$$Cable space length = {[1] - [2] over [3]}$$
Not mathematics.
answered Nov 25 '15 at 14:04
ThumbnailThumbnail
535211
$endgroup$
$begingroup$
Hi, Thanks for suggestion, however weighing the cable is not really ideal for the given situation, surely there is a calculation that can estimate cable length given various measurements?
$endgroup$
– Matthew
Nov 25 '15 at 14:46
add a comment |
$begingroup$
- Weigh the reel.
- Weigh or estimate the weight of an empty reel (may be negligible).
- Weigh a metre of cable.
$$Cable space length = {[1] - [2] over [3]}$$
Not mathematics.
answered Nov 25 '15 at 14:04
ThumbnailThumbnail
535211
$endgroup$
$begingroup$
Hi, Thanks for suggestion, however weighing the cable is not really ideal for the given situation, surely there is a calculation that can estimate cable length given various measurements?
$endgroup$
– Matthew
Nov 25 '15 at 14:46
add a comment |
$begingroup$
- Weigh the reel.
- Weigh or estimate the weight of an empty reel (may be negligible).
- Weigh a metre of cable.
$$Cable space length = {[1] - [2] over [3]}$$
Not mathematics.
answered Nov 25 '15 at 14:04
ThumbnailThumbnail
535211
$endgroup$
- Weigh the reel.
- Weigh or estimate the weight of an empty reel (may be negligible).
- Weigh a metre of cable.
$$Cable space length = {[1] - [2] over [3]}$$
Not mathematics.
answered Nov 25 '15 at 14:04
ThumbnailThumbnail
535211
answered Nov 25 '15 at 14:04
ThumbnailThumbnail
535211
answered Nov 25 '15 at 14:04
ThumbnailThumbnail
535211
answered Nov 25 '15 at 14:04
ThumbnailThumbnail
535211
535211
$begingroup$
Hi, Thanks for suggestion, however weighing the cable is not really ideal for the given situation, surely there is a calculation that can estimate cable length given various measurements?
$endgroup$
– Matthew
Nov 25 '15 at 14:46
add a comment |
$begingroup$
Hi, Thanks for suggestion, however weighing the cable is not really ideal for the given situation, surely there is a calculation that can estimate cable length given various measurements?
$endgroup$
– Matthew
Nov 25 '15 at 14:46
$begingroup$
Hi, Thanks for suggestion, however weighing the cable is not really ideal for the given situation, surely there is a calculation that can estimate cable length given various measurements?
$endgroup$
– Matthew
Nov 25 '15 at 14:46
$begingroup$
Hi, Thanks for suggestion, however weighing the cable is not really ideal for the given situation, surely there is a calculation that can estimate cable length given various measurements?
$endgroup$
– Matthew
Nov 25 '15 at 14:46
add a comment |
Thanks for contributing an answer to Mathematics Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f1545701%2festimating-cable-length-on-a-reel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
$begingroup$
anyone have any idea on a standard formula for calculating cable length on a drum/reel?
$endgroup$
– Matthew
Dec 8 '15 at 9:51
$begingroup$
I'm voting to close this question because it's old; I suspect the OP no longer needs an answer.
$endgroup$
– Ethan Bolker
Oct 15 '18 at 14:11