Import Data, calculate, export data, repeat

[ptc-1743905]

I want to import a line of data from an embedded excel component, do some calcs on it then export the results to another embedded excel component. How do I programme mathcad to repeat the calculations? I assume I use the 'for' statement but I don't understand the examples given. I have attached a very simple worksheet. Can someone show me how I can make this work so I can apply to more complex worksheets?

[ptc-1368288]

1. don't format the Excel cells-row.
2. press space bar after the last character.
3. copy /paste in Mathcad or else fetch technique.

That is going on and on for several weeks in this collab,
... last night [early morning].

jmG

[TomGutman]

For a simple case like this you don't need a for loop. Simple range variable iteration will do the job just fine.
__________________
� � � � Tom Gutman

[ptc-1743905]

Tom, fantastic. Thanks for the quick and detailed response. I'm quite excited by what I can do with that!