+ Reply to Thread
Results 1 to 6 of 6

solving equations

  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    iran
    MS-Off Ver
    2007
    Posts
    3

    solving equations

    hi
    i am writing a program which i need to solve a, 1 variable nonlinear equation for seveal times .it should be mentiond that i can abloulotly usethe solver add on but the problem is that i cant use it manuali for all my 300 time steps !! how can i solve thise 300 independent equtions automaticaly.
    best regards.

  2. #2
    Registered User
    Join Date
    10-15-2010
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: solving equations

    Might want to post an excel dummy sheet so people can get a better picture of what your trying to do. Im not sure if you have to do the formula 300 times, if so you can just copy & paste it...

  3. #3
    Registered User
    Join Date
    03-03-2011
    Location
    iran
    MS-Off Ver
    2007
    Posts
    3

    Re: solving equations

    come on gill!!
    is there any one who can copy te solver operation ?!!
    there is a flood routing problem which i need to solve the equation for every single time step using the solver or goal seek .now the quastion is how can i use solver automaticali for this 300 time steps.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: solving equations

    You can automate Solver in VBA. You can start by recording a macro.

    No one is going to be able to tell you anything specific to your requirement unless you do as gill suggested, and post a workbook that shows exactly what you're trying to do.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    03-03-2011
    Location
    iran
    MS-Off Ver
    2007
    Posts
    3

    Re: solving equations

    tnx shg
    tis is the macro cde

    Sub Macro3()
    '
    ' Macro3 Macro
    ' gg
    '

    '
    Range("K37").GoalSeek Goal:=1685.24, ChangingCell:=Range("J37")
    Range("K39").GoalSeek Goal:=1636, ChangingCell:=Range("J39")
    Range("K41").GoalSeek Goal:=1563.99, ChangingCell:=Range("J41")
    ActiveWindow.SmallScroll Down:=-3
    End Sub

    as can be seen i need to use the goal seek more than this 3 time(over 200 times)
    how can i use this solver ?pleas help i am totaly confused.

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: solving equations

    Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

    Your code is implementing Goal Seek, not Solver.

    If you are unable to post a workbook and explain what you're trying to do in context, I have no suggestions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1