I am currently running a Mathcad program in controlled loops and exporting the resulting data in to an Excel file. My problem is this; each time Mathcad goes through the loop, it overwrites the data from the previous loop. This is a an issue considering I need the data from all 24 loops. I would like to know if there is a way to capture the output from each loop of calculations and save the data in Excel in: 1. Different File Names, 2. Different Sheets of that File, 3. Different Ranges of that File. Either one of the three mentioned ways is acceptable.
Solved! Go to Solution.
Well I'm not sure how your trying to do it or how you have set your loop up.
You could post an example.
Nevertheless I will post the Excel component.
I couldn't get you an example program, but here is a document with a flow chart of what the program essentially looks like.
Looking at the Word document, can't you just pass the whole Matrix to Excel in one go?
Why don't you post the loop with none sensitive data included?