RE: [AMPL 6096] Information regarding transferring information from AMPL to Excel
Robert Fourer
If you just need to transfer the data occasionally, try a command like
print {h in HOURS}: X[h];
then copy the 24 numbers and paste them into your spreadsheet. To automate the process so that it can be run from a script, you'll need to use the database features described in chapter 10 of the AMPL book, www.ampl.com/BOOK/download.html. There are a number of examples in that chapter that involve spreadsheets.
Bob Fourer
From: am...@googlegroups.com [mailto:am...@googlegroups.com]
On Behalf Of Sachin Argade
Sent: Monday, August 27, 2012 1:01 PM
To: am...@googlegroups.com
Subject: [AMPL 6096] Information regarding transferring information from AMPL to Excel
All,
I am trying to transfer solution of my problem in to excel file. I am using MINOS as a solver. I display my variables for 24 hours.
Meaning for every hour I get a number from MINOS 5.5 solver. So it displays 24 hour data. I want to transfer that 24 hour data in to excel file so I can do analysis of that result.
Like this I got 3 variables that I want to transfer to excel file.
Can anyone please help me with this.I am really new at this.