Thread: table structure

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2006
    Posts
    21
    Rep Power
    0

    table structure


    I have a table of information which i want to store into a database.

    ( http://128.173.204.63/courses/cee561...e1_a5_2005.gif )

    I have a weight variable on my Y axis which links to a distances on the X axis.

    I find the result by scrolling up my Y axis or across my X axis and right or up to find the blue line which is my result.

    How can I store this so it can be searched?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2016
    Location
    Cheshire, UK
    Posts
    89
    Rep Power
    72
    What information are you storing?
    What information is involved in calculating the slope and position of the diagonal chart lines?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2006
    Posts
    21
    Rep Power
    0
    Originally Posted by Barand
    What information are you storing?
    What information is involved in calculating the slope and position of the diagonal chart lines?
    I'm not entirely sure, I believe that is a very complex formula hence it's on a chart.

    I'm wonder if I can just have have 3 columns yAxis, xAxis, blueLine and insert rows such as

    325, 1, 360 (being the first blue line in the bottom left.

    Firstly would this work in very basic logic? it would then just depend on how many intervals I decided to include?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2016
    Location
    Cheshire, UK
    Posts
    89
    Rep Power
    72
    Originally Posted by NZ_kiwis
    ... I believe that is a very complex formula hence it's on a chart.
    Exactly, the purpose of such a chart it to make it easy for mere humans to find an approximation to the the value they need.

    It seems like you want to to produce a program that can read the chart, whereas you should be concerned with being able to produce the chart. Computer are good at things like that. If you store the variables required for production you can then calculate precisely any point in the x-y plane.

    For example, when you want "325, 1, 365" which won't be in your data.

IMN logo majestic logo threadwatch logo seochat tools logo