Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VenusInBlueJeans

    Curve fit libraries?

    Hello, I have two arrays, X[] and Y[] in Visual C++, and am looking for a library, a function or a way to use excel curve fitting in order to find the coefficients appropriate. The curve is a Y(X)=A+B*X+C*X*X and I need the coefficients A, B and C! Does anyone have any clues about these...
  2. VenusInBlueJeans

    Least square polynomial fit to data in table!

    Or a possible alternative for me could be, to open excel, perform regression and then just have the cofficients added to the table in Access. Can that be done automatically and also have the excel window as hidden as possible? /M
  3. VenusInBlueJeans

    Least square polynomial fit to data in table!

    Thx Jebry! However, I was looking for a function in VBA to use in my Access Data Base. Is it not possible to do? Thx /M
  4. VenusInBlueJeans

    Least square polynomial fit to data in table!

    Hi, guys! I have a problem. I have a two column Access table (x and y values), and I need vba code which fits a 2nd order polynomial using least square method, and adds the three coefficients in the next three columns of the Access table. (Pol fit like: y=A+B*x+C*x*x) Thx for helping out! /M
  5. VenusInBlueJeans

    Need least square function!

    Hi all! Could someone plz help me with a function. The function should take two arrays, x and y values, and then make a polynomial fit (y(x)=a+b*x+c*x*x), and in the end return the coefficients a, b, c. Thank you! /M
  6. VenusInBlueJeans

    Import data from an Excel file, storing it in a temporary Access table

    Hi guys! Im a newbie at Access and I am trying to do the following: 1) From my Access Form, I want to press a button "Load data" 2) Then I want a window to appear (API) so I can browse through my computer and select an arbitrary .xls file 3) The .xls file has a sheet with 3...

Part and Inventory Search

Back
Top