Skip to main content
dsochor1-Visitor
1-Visitor
Apr 9, 2015 3:28 PM UTC
Solved

Automate number of entry lines?

This beam worksheet is attached in Mathcad 15 and Prime 3.1 format. The end user enters the number of point loads, p, and the number of distributed loads, z. Is it possible for Mathcad to take this value entered and create/trim the number of entries for point loads (P1, y1) and distributed loads (ws1, we1, zs1, ze1) following them? This way the end user doesn’t have to trim off or add additional entries on their own.

StuartBruffAnswer
23-Emerald V
Apr 9, 2015 6:23 PM UTC

Daniel Sochor wrote:

This beam worksheet is attached in Mathcad 15 and Prime 3.1 format. The end user enters the number of point loads, p, and the number of distributed loads, z. Is it possible for Mathcad to take this value entered and create/trim the number of entries for point loads (P1, y1) and distributed loads (ws1, we1, zs1, ze1) following them? This way the end user doesn’t have to trim off or add additional entries on their own.

Do you want the worksheet to calculate the point and distributed loads? If so, how do you calculate them?

If you merely wish to save the user the effort of copying/modifying the various Vp and Vd formulae, then you should be able to get rid of the individual formulae and just have a summation of the formulae based on the index alone - see attached.

Stuart

View in thread

3 replies

StuartBruff23-Emerald VAnswer
23-Emerald V
Apr 9, 2015 6:23 PM UTC

Daniel Sochor wrote:

This beam worksheet is attached in Mathcad 15 and Prime 3.1 format. The end user enters the number of point loads, p, and the number of distributed loads, z. Is it possible for Mathcad to take this value entered and create/trim the number of entries for point loads (P1, y1) and distributed loads (ws1, we1, zs1, ze1) following them? This way the end user doesn’t have to trim off or add additional entries on their own.

Do you want the worksheet to calculate the point and distributed loads? If so, how do you calculate them?

If you merely wish to save the user the effort of copying/modifying the various Vp and Vd formulae, then you should be able to get rid of the individual formulae and just have a summation of the formulae based on the index alone - see attached.

Stuart

Translate
dsochor1-VisitorAuthor
1-Visitor
Apr 10, 2015 2:18 PM UTC

Thank you Stuart. I was attempting to do two things:

  1. Remove the need for the end user to copy and modify the Vp and Vd formulae (which you helped with greatly – thank you!)
  2. When the end user enters a value for p (number of point loads) and z (number of distributed loads) the program will create that many lines in the vectors (P, y, ws, we, zs, and ze) for the end user to complete. Similar to #1, this will save the effort of coping and edit.

Another question – in your worksheet you attached a variable to a text box (R1, Vdn); how did you do this?

Translate
tietjee15-Moonstone
15-Moonstone
Apr 11, 2015 2:37 PM UTC

You want to change how you enter the information. You could consider using a matrix for the data. First column is location and second column is load. I have used this to solve a similar problem

Translate
Terms & ConditionsAccessibility statement