Skip to main content
E
Eng_ReyD_49712-Amethyst
12-Amethyst
March 28, 2021
Question

I need help in Looping or any other technique in four equations

  • March 28, 2021
  • 3 replies
  • 4506 views

Hi,

I am still learning Mathcad. I need help with making some of the formulas easier, with looping or any other technique.

 

My spreadsheet is full of some equations with toms of variables, each one is calculated previously 12 times, 

 

I appreciate it if someone can provide a shorter format for each of the following four equations, and I will try to apply the same technique in all of them...

 

AK_5467365_5-1616965314809.png

 

AK_5467365_6-1616965358340.png

 

AK_5467365_1-1616965146170.png

 

AK_5467365_2-1616965193909.png

 

Thanks a lot

 

 

3 replies

L
LucMeekes23-Emerald IV
23-Emerald IV
March 28, 2021

Make sure W and Ws are vectors, then you can use summation:

LucMeekes_0-1616966824417.png

And be sure to attach your worksheet for further help, not just a picture.

 

Success!
Luc

E
Eng_ReyD_49712-AmethystAuthor
12-Amethyst
March 28, 2021

Thanks  @LucMeekes 

I do not think that this is what I need.I apologize if I was not clear enough.


I already have W1, W2, W3, .... etc defined before. Similarly for all the variables on the right-hand side such as M1sm2, M1sm3, etc,

I want to rewrite the four equations: Wcsw, Wssw, Mrmw, and WTw  in a shorter form instead of repeating all the variables, getting an advantage of the looping technique...Thanks again

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
March 29, 2021

Hi,

 

Example you use M[1 to define the variables.  They then make a vector that can be summed.

Capture.JPG

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
March 29, 2021

Hi,

Please enclose your worksheet and we can show you how to use indexing.

Cheers

Terry

E
Eng_ReyD_49712-AmethystAuthor
12-Amethyst
March 29, 2021

Thanks LucMeekes and terryhendicott for the help...

As requested, I am attaching a simplified sample of the worksheet containing the bone of the calculations Please note that many variables are currently in a hidden range that you can expand. The actual sheet is over 40 pages for repetitions!, but if I learn how to do it I think I would be able to apply everywhere...

I will experiment with some techniques as I learned above, but I appreciate if someone can provide some insight considering the bigger picture as I enclosed here..
@LucMeekes 
@terryhendicott 

L
LucMeekes23-Emerald IV
23-Emerald IV
March 29, 2021

Here's the proposed approach:

LucMeekes_0-1617030299185.png

See attached Prime6 file.

With this you don't need the variable NM anymore, and also the first row of your Module matrix is obsolete, or you can change it to titles:

LucMeekes_1-1617040224133.png

If you want to calculate more than 3 items, just add them to Mod. You don't need to change the other formulae, the definition of m takes care of the number of items. Example:

LucMeekes_0-1617039689878.png

Next thing is, you need to make sure that all your calculation can deal with the vectors.

 

Hmm. I see that your further formulae use ORIGIN=0 (the default) . Maybe better keep ORIGIN=0.

Just delete the 'ORIGIN :=1' definition and all is well.

 

Success!
Luc

    T
    21-Topaz II
    terryhendicott21-Topaz II
    21-Topaz II
    March 30, 2021

    Hi,

    Have taken some time with your worksheet.

    I have created the values as vectors and used two ranges "i" 1 to 12 and "j" 2 to 12 to do this.

    You reference a value in a vector (or matrix) using the square bracket for instance V[3 gets you a value from the V.

    By default the indices start at zero and you can change that.  At the top of the sheet I reset ORIGIN = 1 to set the first element to be position 1 for better understanding of the formulas.

    I have left some subscripted expressions for you to change they are highlighted in red and are easy to change.

    I have left them so you can see the very subtle difference between a subscripted variable and an indexed variable.  The index is a little lower compared to the subscript.

     

    Hope this all helps.

     

    Enclosed worksheet

     

    Cheers

    Terry 

    T
    21-Topaz II
    terryhendicott21-Topaz II
    21-Topaz II
    March 30, 2021

    Hi,

    spotted a small error. Corrected in Version 2.

      E
      Eng_ReyD_49712-AmethystAuthor
      12-Amethyst
      April 2, 2021

      Thanks @terryhendicott  & @LucMeekes for your help
      I am experimenting with your solutions and still learning...
      I am not sure why the attached does not read the variables, although I think I have followed the steps?
      Thanks again!


       
      Terms & ConditionsCookie settingsAccessibility statement