Author Topic: I need a maths whiz!  (Read 7144 times)

Offline smartcooky

  • Uranus
  • ****
  • Posts: 1959
I need a maths whiz!
« on: December 23, 2014, 07:08:41 AM »
I have what seems to be a simple problem but I just cannot see a simple solution.

I have rolls of photographic paper which I use at work. They look similar to this



What I want to do is to be able to measure the diameter of a part roll to estimate the amount of paper left on the roll, given that I know the following...

dc - the diameter of the core
df - the diameter of a full roll
Lf - the number of metres of paper on a full roll

It should be possible to come up with a formula, which I imagine will involve pi somewhere along the line, to do this...

 
If you're not a scientist but you think you've destroyed the foundation of a vast scientific edifice with 10 minutes of Googling, you might want to consider the possibility that you're wrong.

Offline Bryanpoprobson

  • Jupiter
  • ***
  • Posts: 823
  • Another Clown
Re: I need a maths whiz!
« Reply #1 on: December 23, 2014, 07:56:08 AM »
If you could gauge the thickness of the paper the formula is..

Length of Paper in Feet:            1000*3.1426*(Do^2 - Di^2) = 65.47*(Do^2 - Di^2)
                                                _______________________     _________________
                                                       (t*12*4)                                        t

Where......
Outer Roll Diameter                            Do
Outer Diameter of Core                      Di
Thickness of Paper                                t

Length of Paper in Meter:            1000*3.1426*(Do^2 - Di^2) = 78.56*(Do^2 - Di^2)
                                                        (t*10*4)                                        t
"Wise men speak because they have something to say!" "Fools speak, because they have to say something!" (Plato)

Offline Bryanpoprobson

  • Jupiter
  • ***
  • Posts: 823
  • Another Clown
Re: I need a maths whiz!
« Reply #2 on: December 23, 2014, 08:02:48 AM »
"Wise men speak because they have something to say!" "Fools speak, because they have to say something!" (Plato)

Offline Zakalwe

  • Uranus
  • ****
  • Posts: 1590
Re: I need a maths whiz!
« Reply #3 on: December 23, 2014, 11:07:50 AM »
The tightness of the roll might throw this off a fair bit? Would you be better off doing this by the weight of the roll?
"The strain of anti-intellectualism has been a constant thread winding its way through our political and cultural life, nurtured by the false notion that democracy means that 'my ignorance is just as good as your knowledge.' " - Isaac Asimov

Offline smartcooky

  • Uranus
  • ****
  • Posts: 1959
Re: I need a maths whiz!
« Reply #4 on: December 23, 2014, 01:07:22 PM »
If you could gauge the thickness of the paper the formula is..

Length of Paper in Feet:            1000*3.1426*(Do^2 - Di^2) = 65.47*(Do^2 - Di^2)
                                                _______________________     _________________
                                                       (t*12*4)                                        t

Where......
Outer Roll Diameter                            Do
Outer Diameter of Core                      Di
Thickness of Paper                                t

Length of Paper in Meter:            1000*3.1426*(Do^2 - Di^2) = 78.56*(Do^2 - Di^2)
                                                        (t*10*4)                                        t

Right, so it no wonder I cannot work out how to do it using the known length of a full roll and without accurately knowing the thickness paper. However...

Quick search comes up with this...

http://www.cutsmart.com/pages/length_on_roll_calculator.html

This is great because I know the length of paper on a full roll (100m) so I can input the known values of Do and Di and substitute various values for t until I get 100m for an answer. Turns out the paper is .1mm thick

The tightness of the roll might throw this off a fair bit? Would you be better off doing this by the weight of the roll?

Yep, I had thought of that. I carry five different paper widths, 4", 5" 6" 10" and 12", so I would need to record the weight of all five. I'd need to buy scales to weigh the paper.

It does have the advantage of being a "linear" solution; full roll weight minus core weight = 100m, so a roll that weight (-core) of only 35% of full will have 35 metres left.


Thanks for the help guys. I think I'll use the website Bryan found (desktop shortcut). 
If you're not a scientist but you think you've destroyed the foundation of a vast scientific edifice with 10 minutes of Googling, you might want to consider the possibility that you're wrong.

Offline ka9q

  • Neptune
  • ****
  • Posts: 3014
Re: I need a maths whiz!
« Reply #5 on: December 23, 2014, 03:20:35 PM »
Yeah, I'd do it by weight too. If it's too difficult to weigh all five, and if you can assume they all have the same weight per unit area, then you can just scale by the widths.

Offline Bob B.

  • Jupiter
  • ***
  • Posts: 819
  • Bob the Excel Guru™
    • Rocket & Space Technology
Re: I need a maths whiz!
« Reply #6 on: December 23, 2014, 09:55:19 PM »
L = Lf * (d - dc)2 / (df - dc)2

where L if the length remaining and d is the diameter of the partially used roll.
« Last Edit: December 23, 2014, 09:58:10 PM by Bob B. »

Offline Bob B.

  • Jupiter
  • ***
  • Posts: 819
  • Bob the Excel Guru™
    • Rocket & Space Technology
Re: I need a maths whiz!
« Reply #7 on: December 24, 2014, 12:55:37 PM »
Sorry, made a mistake.  Ignore my previous post.  The corrected formula is,

L = Lf * (d2 - dc2) / (df2 - dc2)

Offline smartcooky

  • Uranus
  • ****
  • Posts: 1959
Re: I need a maths whiz!
« Reply #8 on: December 25, 2014, 08:14:09 PM »
Sorry, made a mistake.  Ignore my previous post.  The corrected formula is,

L = Lf * (d2 - dc2) / (df2 - dc2)

Thank you Bob, that works perfectly

Checked against the website Bryan posted, and against a test I did when I used your formula to calculate the length (and therefore the number of 7"x5" prints left) on a roll of 5" paper. Your formula gave 15.6m (therefore 86.6 prints), and it ran out on the 88th print; accurate enough for my purposes.

I'm going to have a crack at programming that into my old HP-25C (if I can remember how!).
If you're not a scientist but you think you've destroyed the foundation of a vast scientific edifice with 10 minutes of Googling, you might want to consider the possibility that you're wrong.

Offline Bob B.

  • Jupiter
  • ***
  • Posts: 819
  • Bob the Excel Guru™
    • Rocket & Space Technology
Re: I need a maths whiz!
« Reply #9 on: December 26, 2014, 02:17:21 AM »
Thank you Bob, that works perfectly

I'm glad I could help.

Offline Allan F

  • Saturn
  • ****
  • Posts: 1008
Re: I need a maths whiz!
« Reply #10 on: December 26, 2014, 09:25:16 AM »
It might be an idea to draw a diagram, and print it out, that way you don't need to do the math every time, and can just look it up on the wall.
Well, it is like this: The truth doesn't need insults. Insults are the refuge of a darkened mind, a mind that refuses to open and see. Foul language can't outcompete knowledge. And knowledge is the result of education. Education is the result of the wish to know more, not less.

Offline smartcooky

  • Uranus
  • ****
  • Posts: 1959
Re: I need a maths whiz!
« Reply #11 on: December 26, 2014, 02:16:52 PM »
It might be an idea to draw a diagram, and print it out, that way you don't need to do the math every time, and can just look it up on the wall.

Yes. Another way will be to plug bob's formula into an excel lookup table.
If you're not a scientist but you think you've destroyed the foundation of a vast scientific edifice with 10 minutes of Googling, you might want to consider the possibility that you're wrong.