Skip to main content
D
dsochor1-Visitor
1-Visitor
April 9, 2015
Solved

Automate number of entry lines?

  • April 9, 2015
  • 2 replies
  • 1260 views

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.

Best answer by StuartBruff

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

2 replies

S
StuartBruff23-Emerald VAnswer
23-Emerald V
April 9, 2015

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

D
dsochor1-VisitorAuthor
1-Visitor
April 10, 2015

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?

T
tietjee15-Moonstone
15-Moonstone
April 11, 2015

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

Terms & ConditionsAccessibility statement