Search results for query: *

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...

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...

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...

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

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.

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...

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")

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...

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...

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...

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...

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...