Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel Information Inserted

Excel Information Inserted

Excel Information Inserted

In the attached file, I have an embedded excel spreadsheet.  I have not been able to find information on how to insert data into this and retrieve data from it.  The information I have found only relates to external excel files.  The spreadsheet is used for table display purposes only, so if there is a better way to do this, I'm all ears.

The issue that brought this up is that one of the array values will not display into the necessary cell.  Only one value of the array behaves this way.  Any insight into the problem would be most appreciated.

RE: Excel Information Inserted

I do this all the time without tiptoeing through Excel.  I would define the entire output table at the beginning, with the zero row being the column headers (just put double quotes in a cell to make it a text block) and load the input columns into that table.

Then you work with a two dimensional array for your output.  It really is easier than trying to make a live link work properly.  Live links can work, but they can also be touchy.


RE: Excel Information Inserted


I attempted to isolate the problem.  The actual calculation can have any number of "courses" as shown in column 1 of the table.  These are index values.  

Getting the values to display properly in the table is problem 1.
td is usually shown as tdi (imagine subscripts) where i ranges from 0 to course-1.  Since I usually don't know the number of courses when starting a project, this allows me to be flexible.

Being able to pull the user input information in the last column is problem 2.  The idea is for the mathcad sheet to tell you that 0.987 is the minimum and for the user to input the convenient value of 1.0.  Mathcad would then calculate some other value using that user input number.

I hope this makes things clearer.

RE: Excel Information Inserted

I assume you're referring to cell D4 being 0?  If so it's because there's an error in the input variables, although with 41 input variables(!!) it's difficult to see this, and it will get even worse if you ever expand the table.  I would suggest deriving your table inputs using a for loop, and having just one input variable to your table (or at most one per column).  See the attached.


RE: Excel Information Inserted


That's the type of answer I was looking for.  Thank you for your help.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close