Results 1 to 5 of 5

Thread: Finding recommended value in table

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    3

    Finding recommended value in table

    Hi genious,

    So I have this table with recommended [Kg/min] for each [m]. Forget about the [/min] column:


    Problem is I need to know the [kg/min] value for 6m. You can see the [kg/min] for 10m is 30, and for 4m is 60. What I need to know is the kg/min related to 6m.

    What do you say? The easiest way to know this value would be:

  2. #2
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Finding recommended value in table

    Welcome to the Forums


    It depends how accurate you want to be. For example, you could use linear interpolation; i.e. assume that between any two points you have a straight line. Thus the proportions on both sides will be the same, meaning that 6 is a third of the way from 4 to 10, so the answer lies a third of the way from 60 to 30 (=50).

    Or, to visualise:


    4 -> 60


    6 -> 50


    8 -> 40


    10 -> 30




    That's an approximate answer. If you want to do better, you will need to try to fit an equation to the data, such that when you plug in the numbers in the m column, you get out the numbers in the kg/min column.


    zaza
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes

  3. #3

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    3

    Re: Finding recommended value in table

    Hi zaza

    Thanks

    I guess you can make it in a linear way, but let's say I consider the [/min] row now, with a value 3,95 for 6 m. Is it possible to know the [Kg/min] in this case?

  4. #4
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Finding recommended value in table

    Well, the /min and the kg/min are directly related aren't they?

    The latter is 15 times the former.
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes

  5. #5

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    3

    Re: Finding recommended value in table

    lol, you're right. If /min is 3,95, then that makes Kg/min 59,25. Nice zaza

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width