Excel Information Inserted
Excel Information Inserted
(OP)
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.
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
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.
David
RE: Excel Information Inserted
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize
RE: Excel Information Inserted
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize
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
Peter
RE: Excel Information Inserted
That's the type of answer I was looking for. Thank you for your help.