cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Automate number of entry lines?

dsochor
5-Regular Member

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.

1 ACCEPTED SOLUTION

Accepted Solutions
StuartBruff
23-Emerald II
(To:dsochor)

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 solution in original post

3 REPLIES 3
StuartBruff
23-Emerald II
(To:dsochor)

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

dsochor
5-Regular Member
(To:StuartBruff)

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?

tietjee
14-Alexandrite
(To:dsochor)

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

Top Tags