Skip to main content
BG_964177012-Amethyst
12-Amethyst
November 5, 2021
Solved

IMPRODCT & IMSUM

Hi guys, i have some complex IMPRODUCT combined with some if statements within excel. I have inserted and excel element into mathcad. I am trying to strip out the excel elements and cant see to find the mathcad version of these excel functions.

 

sheet is attached 🙂 

 

thanks guys  

terryhendicottAnswer
21-Topaz II
November 8, 2021

Hi,

The engineering solution is to simply use a solve block:  The sample problem with units.

Capture.JPG

View in thread

14 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
November 5, 2021

I can't read Prime 7 files, but you should not need any special function to calculate the sum or product of imaginary numbers because Prime can natively  deal with non-real numbers - just use + and * or, if you have to deal with vectors of numbers, use the sum (Sigma) or product (Pi) operator.

Translate
    LucMeekes23-Emerald IV
    23-Emerald IV
    November 5, 2021

    Here goes...

    Translate
      terryhendicott21-Topaz II
      21-Topaz II
      November 6, 2021

      Hi,

       

      Here is the Prime replacement for the excel sheet.  Prime sheet enclosed.

      Capture.JPG 

      Translate
        BG_964177012-AmethystAuthor
        12-Amethyst
        November 8, 2021

        Hi guys thanks for the solutions,

         

        The equation is with the mathcad sheet at the top with all the variables. 

         

        I initially used excel along time ago before starting on mathcad and have not got round to coming up with the best approach for this equation. To give me the best guess of change in tension which originated from the "change in state equation". there are 2 x unknown variables as shown below within the figures (PDF also attached)/ I also used the solver block in mathcad to see what answer I got but there must be a better way to use mathcad with for equations with 2 x unknown variables. 

         

        Page 11 & 12 - Change in state equation (attached PDF and snippets below)

         

        BG_9641770_0-1636369268797.pngBG_9641770_1-1636369288256.png

        BG_9641770_2-1636369310190.png

        BG_9641770_3-1636369326913.png

         

         

         

         

         

         

        Translate
        Fred_Kohlhepp23-Emerald I
        23-Emerald I
        November 8, 2021

        There are several fairly extensive posts on this forum, the latest https://community.ptc.com/t5/PTC-Mathcad/Catenary-formula-thru-ODE/m-p/667131#M190278 treats the catenary.  One of Valery's favorite repeating topics.  

         

        As for equations with two unknowns, the function "lsolve" (with the equations in matrix form) will do.

        Translate
        BG_964177012-AmethystAuthor
        12-Amethyst
        November 8, 2021

        Thanks Fred, the difference here is that the Catenary tension is not constant due to temperatures changes. The resultant moment being the difference in changes between the two spans hence the equation for differential spans. 

        Translate
        Terms & ConditionsAccessibility statement