Skip to main content
M
MikeArmstrong1-Visitor
1-Visitor
February 28, 2017
Solved

Performance Issues

  • February 28, 2017
  • 2 replies
  • 3743 views

Hi,

I am having performance issues with the attached worksheet and would appreciate any help/guidence. I am trying to calculate the deflection and stress along a pipeline during flooding / installation. I am relatively confident that the equations are correct, as the spreadsheet works for a single input of water depth (delta c).

So the aim of this sheet is to rewrite it so that maximum water depth is calculated based on allowable stresses. I have managed to calculate the deflection, slope and bending moment, but the spreadsheet takes a long time to converge. I am looking for a more efficient way as I have passed delta c to all dependent variables and sure this is the issue. .

Thanks in advance.

Mike

    Best answer by Werner_E

    Hi Mike, long time no see.

    You call the solve block function "Func" really very, very often in your various routines. Better call it just once (or at least only once per plotted point) and pass the result as additional argument.

    See if the attached can be of any help.

    On a slow machine here the plotting of the slope diagram speeds up from 52 seconds to just 6 seconds.

    2 replies

    L
    LucMeekes23-Emerald IV
    23-Emerald IV
    February 28, 2017

    Instead of the first solve block, you could have used:

    (I've undefined all your parameters first: , etc) and it did not improve the speed .

    Unfortunately for the second solve block I haven't found a way to solve it symbolically....

    Luc

      M
      MikeArmstrong1-VisitorAuthor
      1-Visitor
      March 1, 2017

      Thanks for looking at it Luc. I think Werner has solved it.

      Mike

      W
      Werner_E25-Diamond IAnswer
      25-Diamond I
      March 1, 2017

      Hi Mike, long time no see.

      You call the solve block function "Func" really very, very often in your various routines. Better call it just once (or at least only once per plotted point) and pass the result as additional argument.

      See if the attached can be of any help.

      On a slow machine here the plotting of the slope diagram speeds up from 52 seconds to just 6 seconds.

      M
      MikeArmstrong1-VisitorAuthor
      1-Visitor
      March 1, 2017

      Thank you Werner, excellent effort as always.

      Mike

      Terms & ConditionsCookie settingsAccessibility statement