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

Help with output into excel component

SOLVED
Participant

Help with output into excel component

Kindly refer to attached worksheet, need advice on how to show Tc(i) as an array in excel component instead of a scalar. Would also greatly appreciate if anyone can explain how mathcad component read Tc(i) and causes a value to be shown only. 

 

Thank you. 

 

[Mathcad 15]

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Help with output into excel component

You have to be aware that a range (like i in your sheet) is NOT a vector or an array, but some kind of implicit loop.

So Tc(i) is no array either (try to assign Tc(i) to a variable - it will fail).

Simply create a vector Tc by writing Tc[i:=.... instead of defining a function Tc(i) and use Tc as input for the Excel table.

Werner_E_0-1582269037716.png

Oh, I see that Luc was faster. Had not seen his answer when I began typing.

 

View solution in original post

4 REPLIES 4
Highlighted

Re: Help with output into excel component

Instead of defining Tc as a function, define it as an array Tci,

then you can call Tc instead of Tc(i) in the excel component.

 

Success!

Luc

Highlighted

Re: Help with output into excel component

Thank you

Highlighted

Re: Help with output into excel component

You have to be aware that a range (like i in your sheet) is NOT a vector or an array, but some kind of implicit loop.

So Tc(i) is no array either (try to assign Tc(i) to a variable - it will fail).

Simply create a vector Tc by writing Tc[i:=.... instead of defining a function Tc(i) and use Tc as input for the Excel table.

Werner_E_0-1582269037716.png

Oh, I see that Luc was faster. Had not seen his answer when I began typing.

 

View solution in original post

Highlighted

Re: Help with output into excel component

Many thanks!

Announcements