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

IMPRODCT & IMSUM

  • November 5, 2021
  • 3 replies
  • 5660 views

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  

Best answer by terryhendicott

Hi,

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

Capture.JPG

3 replies

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

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

    Here goes...

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

      Hi,

       

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

      Capture.JPG 

        B
        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

         

         

         

         

         

         

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

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

        Terms & ConditionsAccessibility statement