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!

Register Log in
  • Congratulations derfloh 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. quayz15

    VBA to VB 6.0

    Can I do this say if I save the data as a .txt file with the first column time second x and third xdot? Using somthing like Input #1, time, x, xdot(I'm not sure if this will work or if I need 3 seporate inputfiles.) In the end I would like to stay away from excel all together, but I dont know...
  2. quayz15

    VBA to VB 6.0

    I am new to programming. I have recently written a code in VBA for excel, and I need to write the same code in VB 6.0. I believe my trouble is I'm not sure how to define the element of an array as variables and use them in a function. Any help is appreciated. the variables I am having trouble...
  3. quayz15

    non linear optimization with Excel solver

    Is there a way to solve for a range of cells simultaniously? I need to best fit a curve where I need to set cells $E$14 : $E$417 = $D$14 : $D$417 by changing rows D2 : M2. Here is what I have, is there a way to adjust this code to do a best fit? Sub BoucwenSOLVER() For Row = 14 To 417...
  4. quayz15

    Runge Kutta as UDF

    Does anyone where to find an example of Runge-Kutta ODE integration written as a UDF for Excel? I need to intgrate another UDF so the Runge Kutta needs to use the function as an argument. Thanks in advance
  5. quayz15

    Multi variable solver

    Matlab has a tool box that runs an optimization. Is there an Add-in on Excel that does this, or some kind of curve fitting. Basically I need to fit the exerimental force velocity curve with predicted force velocity curve.
  6. quayz15

    Multi variable solver

    The solutiono is excel based, there are no formulas in the spread sheet. Evedently the parameters are usually found with "constrained nonliniar optimization using a sequential quadradic programming algorithm in MATLAB." I'm not sure what a sequential quadradic programming algorithm is, and I...
  7. quayz15

    Multi variable solver

    I'm guessing I can't simple add this after my FOR NEXT loop. Range("E14:417").Value.GoalSeek _ Goal:=Range("D14:D417").Value, ChangingCell:=Range("D2:M2")
  8. quayz15

    Multi variable solver

    My objective is to uses data form a manufacturer which contains time step, displacement, velocity and force. I need to be able to process the displacement and velocity of each time step in order to predict the given force. I need a solver to solve the parameters in which I placed in row 2. I...
  9. quayz15

    Multi variable solver

    I would like to know if what I want to do is even possible. I would like to create a solver that sets one range equal to another range by changing multiple variables. Specifically, my target cell values for column "E" are currently in column "F"(ft=...) I would like to do this by changing the...
  10. quayz15

    runtime error 9: subscript out of range

    This gives me a type mismatch error at the xdot1=range(...). I'm not sure what Im doing wrong. pleas help. Private Sub Command1_Click() Dim s As Integer Dim xddot As Double Dim timestep As Integer Dim z, h As Double Dim row1, endrow As Integer Dim time, x, xdot As Long Dim time1, x1, xdot1...
  11. quayz15

    runtime error 9: subscript out of range

    I am a new programmer, and I am trying to write a code that cycles though an excel spread sheet. Time is in the first column displace in the second and velocity in the third. I would like to process the data one row at a time. I am getting the runtime error when I try to calc acceleration...
  12. quayz15

    For without next error.

    I am trying to teach myself VB and this is my first real program. So, I'm sure this is a simple question. I'm trying to write a program that will process the information given by the manufacturer in a spread sheet, and predict the result. I'm sure that at this point there are many errors in the...

Part and Inventory Search

Back
Top